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