START TRANSACTION;

ALTER TABLE `Session` ADD `Interactive` tinyint(1) NOT NULL DEFAULT FALSE;

ALTER TABLE `RobotItem` MODIFY COLUMN `Content` varchar(4000) CHARACTER SET utf8mb4 NULL;

ALTER TABLE `DialogMessage` MODIFY COLUMN `Content` varchar(2000) CHARACTER SET utf8mb4 NULL;

ALTER TABLE `DialogMessage` ADD `StaffNickName` varchar(100) CHARACTER SET utf8mb4 NULL;

CREATE TABLE `OpenApiCaller` (
    `Id` char(36) NOT NULL,
    `SiteId` char(36) NOT NULL,
    `Name` varchar(100) CHARACTER SET utf8mb4 NULL,
    `IPWhiteList` varchar(500) CHARACTER SET utf8mb4 NULL,
    `SecretKey` varchar(100) CHARACTER SET utf8mb4 NULL,
    `CallbackApiUrl` varchar(2000) CHARACTER SET utf8mb4 NULL,
    `DomainId` char(36) NOT NULL,
    CONSTRAINT `PK_OpenApiCaller` PRIMARY KEY (`Id`),
    CONSTRAINT `FK_OpenApiCaller_Domain_DomainId` FOREIGN KEY (`DomainId`) REFERENCES `Domain` (`Id`) ON DELETE RESTRICT,
    CONSTRAINT `FK_OpenApiCaller_Site_SiteId` FOREIGN KEY (`SiteId`) REFERENCES `Site` (`Id`) ON DELETE RESTRICT
);

CREATE TABLE `OpenApiCallLog` (
    `Id` char(36) NOT NULL,
    `SiteId` char(36) NOT NULL,
    `OpenApiCallerId` char(36) NOT NULL,
    `CallTime` datetime(6) NOT NULL,
    `IP` varchar(50) CHARACTER SET utf8mb4 NULL,
    `Action` varchar(500) CHARACTER SET utf8mb4 NULL,
    `InArgs` longtext CHARACTER SET utf8mb4 NULL,
    `OutResult` longtext CHARACTER SET utf8mb4 NULL,
    `DomainId` char(36) NOT NULL,
    CONSTRAINT `PK_OpenApiCallLog` PRIMARY KEY (`Id`),
    CONSTRAINT `FK_OpenApiCallLog_Domain_DomainId` FOREIGN KEY (`DomainId`) REFERENCES `Domain` (`Id`) ON DELETE RESTRICT,
    CONSTRAINT `FK_OpenApiCallLog_OpenApiCaller_OpenApiCallerId` FOREIGN KEY (`OpenApiCallerId`) REFERENCES `OpenApiCaller` (`Id`) ON DELETE CASCADE,
    CONSTRAINT `FK_OpenApiCallLog_Site_SiteId` FOREIGN KEY (`SiteId`) REFERENCES `Site` (`Id`) ON DELETE RESTRICT
);

CREATE INDEX `IX_OpenApiCaller_DomainId` ON `OpenApiCaller` (`DomainId`);

CREATE INDEX `IX_OpenApiCaller_SiteId` ON `OpenApiCaller` (`SiteId`);

CREATE INDEX `IX_OpenApiCallLog_DomainId` ON `OpenApiCallLog` (`DomainId`);

CREATE INDEX `IX_OpenApiCallLog_OpenApiCallerId` ON `OpenApiCallLog` (`OpenApiCallerId`);

CREATE INDEX `IX_OpenApiCallLog_SiteId` ON `OpenApiCallLog` (`SiteId`);

INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
VALUES ('20241212161836_20241211a', '8.0.11');

COMMIT;

START TRANSACTION;

ALTER TABLE `OpenApiCaller` ADD `CreateTime` datetime(6) NOT NULL DEFAULT '0001-01-01 00:00:00';

ALTER TABLE `OpenApiCaller` ADD `Enable` tinyint(1) NOT NULL DEFAULT FALSE;

INSERT INTO `__EFMigrationsHistory` (`MigrationId`, `ProductVersion`)
VALUES ('20241213125104_20241213a', '8.0.11');

COMMIT;