ALTER TABLE `QuicklyReplyItem` ADD `HotKey` varchar(50) CHARACTER SET utf8mb4 NULL;

INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
VALUES ('20241008151004_20241008a', '3.1.10');

CREATE TABLE `StaffClientWebPagePlugIn` (
    `Id` char(36) NOT NULL,
    `DomainId` char(36) NOT NULL,
    `SiteId` char(36) NOT NULL,
    `Enable` tinyint(1) NOT NULL,
    `Title` varchar(50) CHARACTER SET utf8mb4 NULL,
    `Url` varchar(2000) CHARACTER SET utf8mb4 NULL,
    `Description` varchar(500) CHARACTER SET utf8mb4 NULL,
    `NumericalOrder` bigint NOT NULL,
    CONSTRAINT `PK_StaffClientWebPagePlugIn` PRIMARY KEY (`Id`),
    CONSTRAINT `FK_StaffClientWebPagePlugIn_Domain_DomainId` FOREIGN KEY (`DomainId`) REFERENCES `Domain` (`Id`) ON DELETE CASCADE,
    CONSTRAINT `FK_StaffClientWebPagePlugIn_Site_SiteId` FOREIGN KEY (`SiteId`) REFERENCES `Site` (`Id`) ON DELETE CASCADE
);

CREATE INDEX `IX_StaffClientWebPagePlugIn_DomainId` ON `StaffClientWebPagePlugIn` (`DomainId`);

CREATE INDEX `IX_StaffClientWebPagePlugIn_SiteId` ON `StaffClientWebPagePlugIn` (`SiteId`);

INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
VALUES ('20241013122025_20241013a', '3.1.10');