-- Per-website options of a library (entries per page, order). Idempotent.
CREATE TABLE IF NOT EXISTS `LibrarySetting` (
  `id` VARCHAR(191) NOT NULL,
  `siteId` VARCHAR(191) NOT NULL,
  `typeKey` VARCHAR(30) NOT NULL,
  `pageSize` INTEGER NOT NULL DEFAULT 20,
  `orderBy` VARCHAR(20) NOT NULL DEFAULT 'updated_desc',
  `updatedAt` DATETIME(3) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `LibrarySetting_siteId_typeKey_key` (`siteId`, `typeKey`),
  CONSTRAINT `LibrarySetting_siteId_fkey` FOREIGN KEY (`siteId`) REFERENCES `Site`(`id`) ON DELETE CASCADE ON UPDATE CASCADE
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;