ALTER TABLE `Site` ADD `SiteLoginAuthorization` int NOT NULL DEFAULT 0;

CREATE TABLE `SiteLoginAppointedStaff` (
    `Id` char(36) NOT NULL,
    `DomainId` char(36) NOT NULL,
    `SiteId` char(36) NOT NULL,
    `StaffId` char(36) NOT NULL,
    CONSTRAINT `PK_SiteLoginAppointedStaff` PRIMARY KEY (`Id`),
    CONSTRAINT `FK_SiteLoginAppointedStaff_Domain_DomainId` FOREIGN KEY (`DomainId`) REFERENCES `Domain` (`Id`) ON DELETE RESTRICT,
    CONSTRAINT `FK_SiteLoginAppointedStaff_Site_SiteId` FOREIGN KEY (`SiteId`) REFERENCES `Site` (`Id`) ON DELETE CASCADE,
    CONSTRAINT `FK_SiteLoginAppointedStaff_Staff_StaffId` FOREIGN KEY (`StaffId`) REFERENCES `Staff` (`Id`) ON DELETE CASCADE
);

CREATE INDEX `IX_SiteLoginAppointedStaff_DomainId` ON `SiteLoginAppointedStaff` (`DomainId`);

CREATE INDEX `IX_SiteLoginAppointedStaff_SiteId` ON `SiteLoginAppointedStaff` (`SiteId`);

CREATE INDEX `IX_SiteLoginAppointedStaff_StaffId` ON `SiteLoginAppointedStaff` (`StaffId`);

INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
VALUES ('20230402135630_20230402a', '3.1.10');

ALTER TABLE `Session` ADD `FeedbackContent` varchar(500) CHARACTER SET utf8mb4 NULL;

ALTER TABLE `Session` ADD `FeedbackStar` int NULL;

ALTER TABLE `PublishedClientVersion` MODIFY COLUMN `Version` varchar(50) CHARACTER SET utf8mb4 NULL;

ALTER TABLE `PublishedClientVersion` MODIFY COLUMN `Url` varchar(1000) CHARACTER SET utf8mb4 NULL;

ALTER TABLE `PublishedClientVersion` MODIFY COLUMN `Type` varchar(10) CHARACTER SET utf8mb4 NULL;

CREATE TABLE `SiteSettings_WebChatMisc` (
    `Id` char(36) NOT NULL,
    `DomainId` char(36) NOT NULL,
    `SiteId` char(36) NOT NULL,
    `FeedbackWhenEndWebChat` int NOT NULL,
    CONSTRAINT `PK_SiteSettings_WebChatMisc` PRIMARY KEY (`Id`),
    CONSTRAINT `FK_SiteSettings_WebChatMisc_Domain_DomainId` FOREIGN KEY (`DomainId`) REFERENCES `Domain` (`Id`) ON DELETE CASCADE,
    CONSTRAINT `FK_SiteSettings_WebChatMisc_Site_SiteId` FOREIGN KEY (`SiteId`) REFERENCES `Site` (`Id`) ON DELETE CASCADE
);

CREATE INDEX `IX_SiteSettings_WebChatMisc_DomainId` ON `SiteSettings_WebChatMisc` (`DomainId`);

CREATE INDEX `IX_SiteSettings_WebChatMisc_SiteId` ON `SiteSettings_WebChatMisc` (`SiteId`);

INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
VALUES ('20230822161552_20230819a', '3.1.10');

CREATE TABLE `FavouriteFile` (
    `Id` char(36) NOT NULL,
    `DomainId` char(36) NOT NULL,
    `StaffId` char(36) NOT NULL,
    `SiteId` char(36) NOT NULL,
    `Name` varchar(200) CHARACTER SET utf8mb4 NOT NULL,
    `Extension` varchar(50) CHARACTER SET utf8mb4 NULL,
    `Size` double NULL,
    `Description` varchar(500) CHARACTER SET utf8mb4 NULL,
    `Url` varchar(1000) CHARACTER SET utf8mb4 NULL,
    `Shared` tinyint(1) NOT NULL,
    `CreateTime` datetime(6) NOT NULL,
    CONSTRAINT `PK_FavouriteFile` PRIMARY KEY (`Id`),
    CONSTRAINT `FK_FavouriteFile_Domain_DomainId` FOREIGN KEY (`DomainId`) REFERENCES `Domain` (`Id`) ON DELETE CASCADE,
    CONSTRAINT `FK_FavouriteFile_Site_SiteId` FOREIGN KEY (`SiteId`) REFERENCES `Site` (`Id`) ON DELETE CASCADE,
    CONSTRAINT `FK_FavouriteFile_Staff_StaffId` FOREIGN KEY (`StaffId`) REFERENCES `Staff` (`Id`) ON DELETE CASCADE
);

CREATE INDEX `IX_FavouriteFile_DomainId` ON `FavouriteFile` (`DomainId`);

CREATE INDEX `IX_FavouriteFile_SiteId` ON `FavouriteFile` (`SiteId`);

CREATE INDEX `IX_FavouriteFile_StaffId` ON `FavouriteFile` (`StaffId`);

INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
VALUES ('20231116122232_20231113a', '3.1.10');

ALTER TABLE `SiteSettings_Misc` DROP COLUMN `CustomerSideHistory`;

ALTER TABLE `SiteSettings_WebChatMisc` ADD `CustomerSideHistory` int NOT NULL DEFAULT 0;

ALTER TABLE `SiteSettings_Misc` ADD `IPLocationLanguage` varchar(10) CHARACTER SET utf8mb4 NULL;

ALTER TABLE `SiteSettings_CustomerFillInFieldBeforeStart` ADD `CustomerFillInFieldBeforeStart1_Name` varchar(50) CHARACTER SET utf8mb4 NULL;

ALTER TABLE `SiteSettings_CustomerFillInFieldBeforeStart` ADD `CustomerFillInFieldBeforeStart2_Name` varchar(50) CHARACTER SET utf8mb4 NULL;

ALTER TABLE `SiteSettings_CustomerFillInFieldBeforeStart` ADD `CustomerFillInFieldBeforeStart3_Name` varchar(50) CHARACTER SET utf8mb4 NULL;

INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
VALUES ('20231203145512_20231203a', '3.1.10');

ALTER TABLE `SiteSettings_Misc` ADD `StoreVisitSession` tinyint(1) NOT NULL DEFAULT FALSE;

INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
VALUES ('20231227161308_20231227a', '3.1.10');

DROP TABLE `BlockedIP`;

CREATE TABLE `Blocked` (
    `Id` char(36) NOT NULL,
    `Key` varchar(50) CHARACTER SET utf8mb4 NOT NULL,
    `IsIPAddress` tinyint(1) NOT NULL,
    `BlockedTime` datetime(6) NOT NULL,
    `Forever` tinyint(1) NOT NULL,
    `Description` varchar(500) CHARACTER SET utf8mb4 NULL,
    CONSTRAINT `PK_Blocked` PRIMARY KEY (`Id`)
);

INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
VALUES ('20240201151121_20240201a', '3.1.10');