-- Adds the PanelLocation table (custom panel locations created by super admins). Additive only; safe to re-run.
-- Run once against the application database (MariaDB), then run `pnpm prisma generate`.

CREATE TABLE IF NOT EXISTS `PanelLocation` (
  `id` VARCHAR(191) NOT NULL,
  `key` VARCHAR(32) NOT NULL,
  `name` VARCHAR(80) NOT NULL,
  `description` VARCHAR(255) NULL,
  `placement` VARCHAR(16) NOT NULL DEFAULT 'below-content',
  `siteIds` LONGTEXT NULL,
  `active` TINYINT(1) NOT NULL DEFAULT 1,
  `sortOrder` INT NOT NULL DEFAULT 0,
  `createdAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `updatedAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `PanelLocation_key_key` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;