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');