-- CreateTable
CREATE TABLE `ParlourBranding` (
    `id` INTEGER NOT NULL AUTO_INCREMENT,
    `parlourId` INTEGER NOT NULL,
    `appName` VARCHAR(191) NULL,
    `tagline` VARCHAR(191) NULL,
    `primaryColor` VARCHAR(191) NULL,
    `secondaryColor` VARCHAR(191) NULL,
    `accentColor` VARCHAR(191) NULL,
    `textColor` VARCHAR(191) NULL,
    `backgroundColor` VARCHAR(191) NULL,
    `fontFamily` VARCHAR(191) NULL,
    `customCss` VARCHAR(191) NULL,
    `themeVersion` VARCHAR(191) NULL,
    `enableCustomSplash` BOOLEAN NOT NULL DEFAULT false,
    `logoImageId` INTEGER NULL,
    `coverImageId` INTEGER NULL,
    `splashImageId` INTEGER NULL,
    `faviconImageId` INTEGER NULL,
    `onboardingTitle` VARCHAR(191) NULL,
    `onboardingBody` VARCHAR(191) NULL,
    `referralText` VARCHAR(191) NULL,
    `supportPhone` VARCHAR(191) NULL,
    `supportEmail` VARCHAR(191) NULL,
    `termsUrl` VARCHAR(191) NULL,
    `privacyUrl` VARCHAR(191) NULL,
    `extras` JSON NULL,
    `createdAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
    `updatedAt` DATETIME(3) NOT NULL,

    UNIQUE INDEX `ParlourBranding_parlourId_key`(`parlourId`),
    PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- AddForeignKey
ALTER TABLE `ParlourBranding` ADD CONSTRAINT `ParlourBranding_logoImageId_fkey` FOREIGN KEY (`logoImageId`) REFERENCES `Media`(`id`) ON DELETE SET NULL ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE `ParlourBranding` ADD CONSTRAINT `ParlourBranding_coverImageId_fkey` FOREIGN KEY (`coverImageId`) REFERENCES `Media`(`id`) ON DELETE SET NULL ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE `ParlourBranding` ADD CONSTRAINT `ParlourBranding_splashImageId_fkey` FOREIGN KEY (`splashImageId`) REFERENCES `Media`(`id`) ON DELETE SET NULL ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE `ParlourBranding` ADD CONSTRAINT `ParlourBranding_faviconImageId_fkey` FOREIGN KEY (`faviconImageId`) REFERENCES `Media`(`id`) ON DELETE SET NULL ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE `ParlourBranding` ADD CONSTRAINT `ParlourBranding_parlourId_fkey` FOREIGN KEY (`parlourId`) REFERENCES `Parlour`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;