-- Event settings per website. Additive only; safe to re-run. Requires 2026-10-org-settings.sql (DpaGroup).
-- Run against the application database (MariaDB), then `pnpm prisma generate`.

CREATE TABLE IF NOT EXISTS `SiteEventSettings` (
  `siteId` VARCHAR(191) NOT NULL,
  `startsAt` DATETIME(3) NULL,
  `endsAt` DATETIME(3) NULL,
  `coverMediaId` VARCHAR(191) NULL,
  `categoryTypes` JSON NOT NULL,
  `dpaGroupId` VARCHAR(191) NULL,
  `showForgotPassword` TINYINT(1) NOT NULL DEFAULT 0,
  `allowProfileLock` TINYINT(1) NOT NULL DEFAULT 0,
  `tagIds` JSON NOT NULL,
  `businessSectors` JSON NOT NULL,
  `supportContactUserId` VARCHAR(191) NULL,
  `ssoEnabled` TINYINT(1) NOT NULL DEFAULT 0,
  `ssoSecretSealed` TEXT NULL,
  `updatedAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`siteId`),
  KEY `SiteEventSettings_dpaGroupId_idx` (`dpaGroupId`),
  CONSTRAINT `SiteEventSettings_siteId_fkey` FOREIGN KEY (`siteId`) REFERENCES `Site` (`id`) ON DELETE CASCADE,
  CONSTRAINT `SiteEventSettings_dpaGroupId_fkey` FOREIGN KEY (`dpaGroupId`) REFERENCES `DpaGroup` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;