ALTER TABLE `DialogMessage` ADD `ContentLanguage` varchar(20) CHARACTER SET utf8mb4 NULL;

ALTER TABLE `DialogMessage` ADD `Translated` tinyint(1) NOT NULL DEFAULT FALSE;

ALTER TABLE `DialogMessage` ADD `TranslatedContent` longtext CHARACTER SET utf8mb4 NULL;

ALTER TABLE `DialogMessage` ADD `TranslatedContentLanguage` varchar(20) CHARACTER SET utf8mb4 NULL;

ALTER TABLE `Customer` ADD `ContentLanguage` varchar(20) CHARACTER SET utf8mb4 NULL;

ALTER TABLE `Customer` ADD `TranslateContentToLanguage` varchar(20) CHARACTER SET utf8mb4 NULL;

INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
VALUES ('20220103073109_20220102a', '3.1.10');

CREATE TABLE `SiteSettings_Translation` (
    `Id` char(36) NOT NULL,
    `DomainId` char(36) NOT NULL,
    `SiteId` char(36) NOT NULL,
    `AutoTranslate` tinyint(1) NOT NULL,
    `ContentLanguage` varchar(20) CHARACTER SET utf8mb4 NULL,
    `TranslateContentToLanguage` varchar(20) CHARACTER SET utf8mb4 NULL,
    CONSTRAINT `PK_SiteSettings_Translation` PRIMARY KEY (`Id`),
    CONSTRAINT `FK_SiteSettings_Translation_Domain_DomainId` FOREIGN KEY (`DomainId`) REFERENCES `Domain` (`Id`) ON DELETE CASCADE,
    CONSTRAINT `FK_SiteSettings_Translation_Site_SiteId` FOREIGN KEY (`SiteId`) REFERENCES `Site` (`Id`) ON DELETE CASCADE
);

CREATE INDEX `IX_SiteSettings_Translation_DomainId` ON `SiteSettings_Translation` (`DomainId`);

CREATE INDEX `IX_SiteSettings_Translation_SiteId` ON `SiteSettings_Translation` (`SiteId`);

INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
VALUES ('20220107154250_20220102b', '3.1.10');

ALTER TABLE `SiteSettings_Misc` DROP COLUMN `CustomerSideLanguage`;

ALTER TABLE `SiteSettings_MobileWebChatStyle` ADD `ShowGoBackButton` tinyint(1) NOT NULL DEFAULT FALSE;

CREATE TABLE `SiteSettings_CustomerSideLanguages` (
    `Id` char(36) NOT NULL,
    `DomainId` char(36) NOT NULL,
    `SiteId` char(36) NOT NULL,
    `DefaultLanguage` int NOT NULL,
    `AllowCustomerSwitchLanguage` tinyint(1) NOT NULL,
    `AllLanguagesAvailable` tinyint(1) NOT NULL,
    `AllowedLanguages` varchar(1000) CHARACTER SET utf8mb4 NULL,
    CONSTRAINT `PK_SiteSettings_CustomerSideLanguages` PRIMARY KEY (`Id`),
    CONSTRAINT `FK_SiteSettings_CustomerSideLanguages_Domain_DomainId` FOREIGN KEY (`DomainId`) REFERENCES `Domain` (`Id`) ON DELETE CASCADE,
    CONSTRAINT `FK_SiteSettings_CustomerSideLanguages_Site_SiteId` FOREIGN KEY (`SiteId`) REFERENCES `Site` (`Id`) ON DELETE CASCADE
);

CREATE INDEX `IX_SiteSettings_CustomerSideLanguages_DomainId` ON `SiteSettings_CustomerSideLanguages` (`DomainId`);

CREATE INDEX `IX_SiteSettings_CustomerSideLanguages_SiteId` ON `SiteSettings_CustomerSideLanguages` (`SiteId`);

INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
VALUES ('20220201160927_20220201a', '3.1.10');

CREATE TABLE `SiteSettings_AutoGreetings` (
    `Id` char(36) NOT NULL,
    `DomainId` char(36) NOT NULL,
    `SiteId` char(36) NOT NULL,
    `WebChatAutoExpand` int NOT NULL,
    `ShowGreetings` int NOT NULL,
    `Greetings` longtext CHARACTER SET utf8mb4 NULL,
    CONSTRAINT `PK_SiteSettings_AutoGreetings` PRIMARY KEY (`Id`),
    CONSTRAINT `FK_SiteSettings_AutoGreetings_Domain_DomainId` FOREIGN KEY (`DomainId`) REFERENCES `Domain` (`Id`) ON DELETE CASCADE,
    CONSTRAINT `FK_SiteSettings_AutoGreetings_Site_SiteId` FOREIGN KEY (`SiteId`) REFERENCES `Site` (`Id`) ON DELETE CASCADE
);

CREATE TABLE `SiteSettings_MobileAutoGreetings` (
    `Id` char(36) NOT NULL,
    `DomainId` char(36) NOT NULL,
    `SiteId` char(36) NOT NULL,
    `WebChatAutoExpand` int NOT NULL,
    `ShowGreetings` int NOT NULL,
    `Greetings` longtext CHARACTER SET utf8mb4 NULL,
    CONSTRAINT `PK_SiteSettings_MobileAutoGreetings` PRIMARY KEY (`Id`),
    CONSTRAINT `FK_SiteSettings_MobileAutoGreetings_Domain_DomainId` FOREIGN KEY (`DomainId`) REFERENCES `Domain` (`Id`) ON DELETE CASCADE,
    CONSTRAINT `FK_SiteSettings_MobileAutoGreetings_Site_SiteId` FOREIGN KEY (`SiteId`) REFERENCES `Site` (`Id`) ON DELETE CASCADE
);

CREATE INDEX `IX_SiteSettings_AutoGreetings_DomainId` ON `SiteSettings_AutoGreetings` (`DomainId`);

CREATE INDEX `IX_SiteSettings_AutoGreetings_SiteId` ON `SiteSettings_AutoGreetings` (`SiteId`);

CREATE INDEX `IX_SiteSettings_MobileAutoGreetings_DomainId` ON `SiteSettings_MobileAutoGreetings` (`DomainId`);

CREATE INDEX `IX_SiteSettings_MobileAutoGreetings_SiteId` ON `SiteSettings_MobileAutoGreetings` (`SiteId`);

INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
VALUES ('20220220084711_20220219a', '3.1.10');

ALTER TABLE `SiteSettings_MiniWebChat` ADD `TitleWhenNoStaffOnline` varchar(2000) CHARACTER SET utf8mb4 NULL;

ALTER TABLE `SiteSettings_MiniWebChat` ADD `TitleWhenStaffOnline` varchar(2000) CHARACTER SET utf8mb4 NULL;

CREATE TABLE `SiteSettings_MobileMiniWebChat` (
    `Id` char(36) NOT NULL,
    `DomainId` char(36) NOT NULL,
    `SiteId` char(36) NOT NULL,
    `TitleWhenStaffOnline` varchar(2000) CHARACTER SET utf8mb4 NULL,
    `TitleWhenNoStaffOnline` varchar(2000) CHARACTER SET utf8mb4 NULL,
    CONSTRAINT `PK_SiteSettings_MobileMiniWebChat` PRIMARY KEY (`Id`),
    CONSTRAINT `FK_SiteSettings_MobileMiniWebChat_Domain_DomainId` FOREIGN KEY (`DomainId`) REFERENCES `Domain` (`Id`) ON DELETE CASCADE,
    CONSTRAINT `FK_SiteSettings_MobileMiniWebChat_Site_SiteId` FOREIGN KEY (`SiteId`) REFERENCES `Site` (`Id`) ON DELETE CASCADE
);

CREATE INDEX `IX_SiteSettings_MobileMiniWebChat_DomainId` ON `SiteSettings_MobileMiniWebChat` (`DomainId`);

CREATE INDEX `IX_SiteSettings_MobileMiniWebChat_SiteId` ON `SiteSettings_MobileMiniWebChat` (`SiteId`);

INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
VALUES ('20220702121657_20220702a', '3.1.10');

DROP TABLE `SiteSettings_CustomerSideLanguages`;

ALTER TABLE `Customer` DROP COLUMN `CustomerSideLanguage`;

ALTER TABLE `RobotItem` MODIFY COLUMN `Language` longtext CHARACTER SET utf8mb4 NOT NULL;

ALTER TABLE `Customer` ADD `CustomerUILanguage` longtext CHARACTER SET utf8mb4 NULL;

CREATE TABLE `CustomerUILanguage` (
    `Id` char(36) NOT NULL,
    `Name` varchar(50) CHARACTER SET utf8mb4 NULL,
    `Code` varchar(20) CHARACTER SET utf8mb4 NULL,
    `OrderNumber` int NOT NULL,
    CONSTRAINT `PK_CustomerUILanguage` PRIMARY KEY (`Id`)
);

CREATE TABLE `RobotExternalApiSettings` (
    `Id` char(36) NOT NULL,
    `DomainId` char(36) NOT NULL,
    `SiteId` char(36) NOT NULL,
    `Url` longtext CHARACTER SET utf8mb4 NULL,
    CONSTRAINT `PK_RobotExternalApiSettings` PRIMARY KEY (`Id`),
    CONSTRAINT `FK_RobotExternalApiSettings_Domain_DomainId` FOREIGN KEY (`DomainId`) REFERENCES `Domain` (`Id`) ON DELETE CASCADE,
    CONSTRAINT `FK_RobotExternalApiSettings_Site_SiteId` FOREIGN KEY (`SiteId`) REFERENCES `Site` (`Id`) ON DELETE CASCADE
);

CREATE TABLE `RobotSettings` (
    `Id` char(36) NOT NULL,
    `DomainId` char(36) NOT NULL,
    `SiteId` char(36) NOT NULL,
    `Mode` int NOT NULL,
    CONSTRAINT `PK_RobotSettings` PRIMARY KEY (`Id`),
    CONSTRAINT `FK_RobotSettings_Domain_DomainId` FOREIGN KEY (`DomainId`) REFERENCES `Domain` (`Id`) ON DELETE CASCADE,
    CONSTRAINT `FK_RobotSettings_Site_SiteId` FOREIGN KEY (`SiteId`) REFERENCES `Site` (`Id`) ON DELETE CASCADE
);

CREATE TABLE `SiteSettings_CustomerUILanguage` (
    `Id` char(36) NOT NULL,
    `DomainId` char(36) NOT NULL,
    `SiteId` char(36) NOT NULL,
    `DefaultLanguage` longtext CHARACTER SET utf8mb4 NULL,
    `AllowCustomerSwitchLanguage` tinyint(1) NOT NULL,
    `AllLanguagesAvailable` tinyint(1) NOT NULL,
    `AllowedLanguages` varchar(1000) CHARACTER SET utf8mb4 NULL,
    CONSTRAINT `PK_SiteSettings_CustomerUILanguage` PRIMARY KEY (`Id`),
    CONSTRAINT `FK_SiteSettings_CustomerUILanguage_Domain_DomainId` FOREIGN KEY (`DomainId`) REFERENCES `Domain` (`Id`) ON DELETE CASCADE,
    CONSTRAINT `FK_SiteSettings_CustomerUILanguage_Site_SiteId` FOREIGN KEY (`SiteId`) REFERENCES `Site` (`Id`) ON DELETE CASCADE
);

CREATE INDEX `IX_RobotExternalApiSettings_DomainId` ON `RobotExternalApiSettings` (`DomainId`);

CREATE INDEX `IX_RobotExternalApiSettings_SiteId` ON `RobotExternalApiSettings` (`SiteId`);

CREATE INDEX `IX_RobotSettings_DomainId` ON `RobotSettings` (`DomainId`);

CREATE INDEX `IX_RobotSettings_SiteId` ON `RobotSettings` (`SiteId`);

CREATE INDEX `IX_SiteSettings_CustomerUILanguage_DomainId` ON `SiteSettings_CustomerUILanguage` (`DomainId`);

CREATE INDEX `IX_SiteSettings_CustomerUILanguage_SiteId` ON `SiteSettings_CustomerUILanguage` (`SiteId`);

INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
VALUES ('20220917110829_20220910a', '3.1.10');

ALTER TABLE `SiteSettings_CustomerUILanguage` ADD `ReplacementLanguage` longtext CHARACTER SET utf8mb4 NULL;

INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
VALUES ('20220918095622_20220917a', '3.1.10');

ALTER TABLE `SiteSettings_CustomerUILanguage` MODIFY COLUMN `ReplacementLanguage` varchar(20) CHARACTER SET utf8mb4 NULL;

ALTER TABLE `SiteSettings_CustomerUILanguage` MODIFY COLUMN `DefaultLanguage` varchar(20) CHARACTER SET utf8mb4 NULL;

ALTER TABLE `RobotItem` MODIFY COLUMN `Language` varchar(20) CHARACTER SET utf8mb4 NOT NULL;

ALTER TABLE `Customer` MODIFY COLUMN `CustomerUILanguage` varchar(20) CHARACTER SET utf8mb4 NULL;

INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
VALUES ('20221029083423_20221029a', '3.1.10');

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