-- Media manager folders (empty folders and the noindex option). Idempotent.
CREATE TABLE IF NOT EXISTS `MediaFolder` (
  `id` VARCHAR(191) NOT NULL,
  `siteId` VARCHAR(191) NOT NULL,
  `path` VARCHAR(190) NOT NULL,
  `noIndex` BOOLEAN NOT NULL DEFAULT false,
  `createdAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE INDEX `MediaFolder_siteId_path_key` (`siteId`, `path`),
  CONSTRAINT `MediaFolder_siteId_fkey` FOREIGN KEY (`siteId`) REFERENCES `Site`(`id`) ON DELETE CASCADE ON UPDATE CASCADE
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;