-- Per-website label and help text for built-in / shared panel positions. Additive; safe to re-run.
-- Run once against the application database (MariaDB), then run `pnpm prisma generate`.

CREATE TABLE IF NOT EXISTS `PanelPositionOverride` (
  `id` VARCHAR(191) NOT NULL,
  `siteId` VARCHAR(191) NOT NULL,
  `key` VARCHAR(32) NOT NULL,
  `name` VARCHAR(80) NOT NULL,
  `description` VARCHAR(255) NULL,
  `updatedAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `PanelPositionOverride_siteId_key_key` (`siteId`, `key`),
  CONSTRAINT `fk_PanelPositionOverride_siteId` FOREIGN KEY (`siteId`) REFERENCES `Site` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;