-- Sync schema changes that were applied locally via db push

-- AlterTable
ALTER TABLE `ContactMessage` ADD COLUMN `isRead` BOOLEAN NOT NULL DEFAULT false,
    ADD COLUMN `readAt` DATETIME(3) NULL;

-- AlterTable
ALTER TABLE `ContactSetting` ADD COLUMN `creatorExperience` VARCHAR(191) NULL,
    ADD COLUMN `creatorSkills` TEXT NULL;

-- AlterTable
ALTER TABLE `GalleryImage` ADD COLUMN `seoTitle` VARCHAR(191) NULL,
    ADD COLUMN `seoDescription` TEXT NULL,
    ADD COLUMN `seoKeywords` VARCHAR(191) NULL;

-- AlterTable
ALTER TABLE `PageContent` ADD COLUMN `seoTitle` VARCHAR(191) NULL,
    ADD COLUMN `seoDescription` TEXT NULL,
    ADD COLUMN `seoKeywords` VARCHAR(191) NULL;

-- AlterTable
ALTER TABLE `Post` ADD COLUMN `seoTitle` VARCHAR(191) NULL,
    ADD COLUMN `seoDescription` TEXT NULL,
    ADD COLUMN `seoKeywords` VARCHAR(191) NULL;

-- AlterTable
ALTER TABLE `Review` ADD COLUMN `approvalStatus` ENUM('PENDING', 'APPROVED', 'REJECTED') NOT NULL DEFAULT 'APPROVED',
    ADD COLUMN `rejectionReason` TEXT NULL;

-- AlterTable
ALTER TABLE `SiteSetting` ADD COLUMN `aboutBrandImageUrl` VARCHAR(191) NULL,
    ADD COLUMN `aboutCreatorImageUrl` VARCHAR(191) NULL;

-- AlterTable
ALTER TABLE `User` ADD COLUMN `age` INTEGER NULL,
    ADD COLUMN `sex` VARCHAR(191) NULL,
    ADD COLUMN `phone` VARCHAR(191) NULL,
    ADD COLUMN `address` VARCHAR(191) NULL,
    ADD COLUMN `isApproved` BOOLEAN NOT NULL DEFAULT true;

-- AlterTable
ALTER TABLE `Video` ADD COLUMN `seoTitle` VARCHAR(191) NULL,
    ADD COLUMN `seoDescription` TEXT NULL,
    ADD COLUMN `seoKeywords` VARCHAR(191) NULL;

-- AlterTable
ALTER TABLE `Video` MODIFY `description` TEXT NOT NULL;

-- AlterTable
ALTER TABLE `User` MODIFY `role` ENUM('ADMIN', 'EDITOR', 'USER') NOT NULL DEFAULT 'ADMIN';