BEGIN TRANSACTION;
GO

ALTER TABLE [Session] ADD [Interactive] bit NOT NULL DEFAULT CAST(0 AS bit);
GO

DECLARE @var0 sysname;
SELECT @var0 = [d].[name]
FROM [sys].[default_constraints] [d]
INNER JOIN [sys].[columns] [c] ON [d].[parent_column_id] = [c].[column_id] AND [d].[parent_object_id] = [c].[object_id]
WHERE ([d].[parent_object_id] = OBJECT_ID(N'[DialogMessage]') AND [c].[name] = N'Content');
IF @var0 IS NOT NULL EXEC(N'ALTER TABLE [DialogMessage] DROP CONSTRAINT [' + @var0 + '];');
ALTER TABLE [DialogMessage] ALTER COLUMN [Content] nvarchar(2000) NULL;
GO

ALTER TABLE [DialogMessage] ADD [StaffNickName] nvarchar(100) NULL;
GO

CREATE TABLE [OpenApiCaller] (
    [Id] uniqueidentifier NOT NULL,
    [SiteId] uniqueidentifier NOT NULL,
    [Name] nvarchar(100) NULL,
    [IPWhiteList] nvarchar(500) NULL,
    [SecretKey] nvarchar(100) NULL,
    [CallbackApiUrl] nvarchar(2000) NULL,
    [DomainId] uniqueidentifier NOT NULL,
    CONSTRAINT [PK_OpenApiCaller] PRIMARY KEY ([Id]),
    CONSTRAINT [FK_OpenApiCaller_Domain_DomainId] FOREIGN KEY ([DomainId]) REFERENCES [Domain] ([Id]) ON DELETE NO ACTION,
    CONSTRAINT [FK_OpenApiCaller_Site_SiteId] FOREIGN KEY ([SiteId]) REFERENCES [Site] ([Id]) ON DELETE NO ACTION
);
GO

CREATE TABLE [OpenApiCallLog] (
    [Id] uniqueidentifier NOT NULL,
    [SiteId] uniqueidentifier NOT NULL,
    [OpenApiCallerId] uniqueidentifier NOT NULL,
    [CallTime] datetime2 NOT NULL,
    [IP] nvarchar(50) NULL,
    [Action] nvarchar(500) NULL,
    [InArgs] nvarchar(max) NULL,
    [OutResult] nvarchar(max) NULL,
    [DomainId] uniqueidentifier NOT NULL,
    CONSTRAINT [PK_OpenApiCallLog] PRIMARY KEY ([Id]),
    CONSTRAINT [FK_OpenApiCallLog_Domain_DomainId] FOREIGN KEY ([DomainId]) REFERENCES [Domain] ([Id]) ON DELETE NO ACTION,
    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 NO ACTION
);
GO

CREATE INDEX [IX_OpenApiCaller_DomainId] ON [OpenApiCaller] ([DomainId]);
GO

CREATE INDEX [IX_OpenApiCaller_SiteId] ON [OpenApiCaller] ([SiteId]);
GO

CREATE INDEX [IX_OpenApiCallLog_DomainId] ON [OpenApiCallLog] ([DomainId]);
GO

CREATE INDEX [IX_OpenApiCallLog_OpenApiCallerId] ON [OpenApiCallLog] ([OpenApiCallerId]);
GO

CREATE INDEX [IX_OpenApiCallLog_SiteId] ON [OpenApiCallLog] ([SiteId]);
GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20241211083922_20241211a', N'8.0.11');
GO

COMMIT;
GO

BEGIN TRANSACTION;
GO

ALTER TABLE [OpenApiCaller] ADD [CreateTime] datetime2 NOT NULL DEFAULT '0001-01-01T00:00:00.0000000';
GO

ALTER TABLE [OpenApiCaller] ADD [Enable] bit NOT NULL DEFAULT CAST(0 AS bit);
GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20241213075222_20241213a', N'8.0.11');
GO

COMMIT;
GO