DROP TABLE IF EXISTS storage_providers;

CREATE TABLE `storage_providers` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alias` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `credentials` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `storage_providers` (`id`, `name`, `alias`, `credentials`, `created_at`, `updated_at`) VALUES
(1, 'Local', 'local', '{}', '2022-02-20 20:13:06', '2022-02-20 20:44:06'),
(2, 'S3', 's3', '{\"access_key_id\":null,\"secret_access_key\":null,\"default_region\":null,\"bucket\":null,\"url\":null,\"endpoint\":null}', '2022-02-20 20:12:55', '2025-05-31 10:25:46'),
(3, 'Digitalocean Spaces', 'digitalocean', '{\"access_key_id\":null,\"secret_access_key\":null,\"default_region\":null,\"bucket\":null,\"url\":null,\"endpoint\":null}', '2024-03-05 23:23:02', '2024-03-06 07:12:36'),
(4, 'Storj', 'storj', '{\"access_key_id\":null,\"secret_access_key\":null,\"default_region\":null,\"bucket\":null,\"url\":null,\"endpoint\":null}', '2024-03-05 23:23:02', '2024-03-06 07:12:36'),
(5, 'Idrive E2', 'idrive', '{\"access_key_id\":null,\"secret_access_key\":null,\"default_region\":null,\"bucket\":null,\"url\":null,\"endpoint\":null}', '2024-03-05 23:23:02', '2024-05-17 18:45:33'),
(6, 'Contabo Object Storage', 'contabo', '{\"access_key_id\":null,\"secret_access_key\":null,\"default_region\":null,\"bucket\":null,\"url\":null,\"endpoint\":null}', '2024-03-05 23:23:02', '2024-03-06 07:12:36'),
(7, 'Cloudflare R2', 'cloudflare', '{\"access_key_id\":null,\"secret_access_key\":null,\"default_region\":null,\"bucket\":null,\"url\":null,\"endpoint\":null}', '2024-03-05 23:23:02', '2025-05-31 12:02:55');

ALTER TABLE `storage_providers`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `storage_providers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;