ALTER TABLE [SiteSettings_ChatMisc] ADD [CustomerFillInFieldBeforeStart1_Description] nvarchar(200) NULL;

GO

ALTER TABLE [SiteSettings_ChatMisc] ADD [CustomerFillInFieldBeforeStart1_MultipleRow] bit NOT NULL DEFAULT CAST(0 AS bit);

GO

ALTER TABLE [SiteSettings_ChatMisc] ADD [CustomerFillInFieldBeforeStart2_Description] nvarchar(200) NULL;

GO

ALTER TABLE [SiteSettings_ChatMisc] ADD [CustomerFillInFieldBeforeStart2_MultipleRow] bit NOT NULL DEFAULT CAST(0 AS bit);

GO

ALTER TABLE [SiteSettings_ChatMisc] ADD [CustomerFillInFieldBeforeStart3_Description] nvarchar(200) NULL;

GO

ALTER TABLE [SiteSettings_ChatMisc] ADD [CustomerFillInFieldBeforeStart3_MultipleRow] bit NOT NULL DEFAULT CAST(0 AS bit);

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20210511022215_20210511a', N'3.1.10');

GO

ALTER TABLE [SiteSettings_ChatMisc] ADD [CustomerFillInFieldBeforeStart1_Required] bit NOT NULL DEFAULT CAST(0 AS bit);

GO

ALTER TABLE [SiteSettings_ChatMisc] ADD [CustomerFillInFieldBeforeStart2_Required] bit NOT NULL DEFAULT CAST(0 AS bit);

GO

ALTER TABLE [SiteSettings_ChatMisc] ADD [CustomerFillInFieldBeforeStart3_Required] bit NOT NULL DEFAULT CAST(0 AS bit);

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20210511031113_20210511b', N'3.1.10');

GO

ALTER TABLE [Customer] ADD [CreatedTime] datetime2 NULL;

GO

ALTER TABLE [Customer] ADD [LastDialogueTime] datetime2 NULL;

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20210521143231_20210521a', N'3.1.10');

GO

ALTER TABLE [Customer] ADD [AnyDialogue] bit NOT NULL DEFAULT CAST(0 AS bit);

GO

ALTER TABLE [Customer] ADD [LastDialogueSessionStartType] int NULL;

GO

ALTER TABLE [Customer] ADD [LastDialogueStaffId] uniqueidentifier NULL;

GO

CREATE INDEX [IX_Customer_LastDialogueStaffId] ON [Customer] ([LastDialogueStaffId]);

GO

ALTER TABLE [Customer] ADD CONSTRAINT [FK_Customer_Staff_LastDialogueStaffId] FOREIGN KEY ([LastDialogueStaffId]) REFERENCES [Staff] ([Id]) ON DELETE NO ACTION;

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20210522055759_20210522a', N'3.1.10');

GO

CREATE TABLE [SiteSettings_FakeCustomerWaitingQueue] (
    [Id] uniqueidentifier NOT NULL,
    [DomainId] uniqueidentifier NOT NULL,
    [SiteId] uniqueidentifier NOT NULL,
    [Enabled] bit NOT NULL,
    CONSTRAINT [PK_SiteSettings_FakeCustomerWaitingQueue] PRIMARY KEY ([Id]),
    CONSTRAINT [FK_SiteSettings_FakeCustomerWaitingQueue_Domain_DomainId] FOREIGN KEY ([DomainId]) REFERENCES [Domain] ([Id]) ON DELETE CASCADE,
    CONSTRAINT [FK_SiteSettings_FakeCustomerWaitingQueue_Site_SiteId] FOREIGN KEY ([SiteId]) REFERENCES [Site] ([Id]) ON DELETE CASCADE
);

GO

CREATE INDEX [IX_SiteSettings_FakeCustomerWaitingQueue_DomainId] ON [SiteSettings_FakeCustomerWaitingQueue] ([DomainId]);

GO

CREATE INDEX [IX_SiteSettings_FakeCustomerWaitingQueue_SiteId] ON [SiteSettings_FakeCustomerWaitingQueue] ([SiteId]);

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20210608063023_20210608a', N'3.1.10');

GO

ALTER TABLE [SiteSettings_FakeCustomerWaitingQueue] ADD [MaxQueueCount] int NOT NULL DEFAULT 0;

GO

ALTER TABLE [SiteSettings_FakeCustomerWaitingQueue] ADD [MinQueueCount] int NOT NULL DEFAULT 0;

GO

ALTER TABLE [DialogMessage] ADD [Removed] bit NOT NULL DEFAULT CAST(0 AS bit);

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20210817133320_20210817a', N'3.1.10');

GO

ALTER TABLE [SiteSettings_Misc] ADD [CustomerSideLanguage] int NOT NULL DEFAULT 0;

GO

ALTER TABLE [Customer] ADD [CustomerSideLanguage] int NOT NULL DEFAULT 0;

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20210819155034_20210819', N'3.1.10');

GO

DROP TABLE [SiteSettings_MobileWebFloatIcon];

GO

DROP TABLE [SiteSettings_WebFloatIcon];

GO

CREATE TABLE [SiteSettings_MiniWebChat] (
    [Id] uniqueidentifier NOT NULL,
    [DomainId] uniqueidentifier NOT NULL,
    [SiteId] uniqueidentifier NOT NULL,
    [Position] int NOT NULL,
    [HorizontalMargin] int NOT NULL,
    [VerticalMargin] int NOT NULL,
    CONSTRAINT [PK_SiteSettings_MiniWebChat] PRIMARY KEY ([Id]),
    CONSTRAINT [FK_SiteSettings_MiniWebChat_Domain_DomainId] FOREIGN KEY ([DomainId]) REFERENCES [Domain] ([Id]) ON DELETE CASCADE,
    CONSTRAINT [FK_SiteSettings_MiniWebChat_Site_SiteId] FOREIGN KEY ([SiteId]) REFERENCES [Site] ([Id]) ON DELETE CASCADE
);

GO

CREATE INDEX [IX_SiteSettings_MiniWebChat_DomainId] ON [SiteSettings_MiniWebChat] ([DomainId]);

GO

CREATE INDEX [IX_SiteSettings_MiniWebChat_SiteId] ON [SiteSettings_MiniWebChat] ([SiteId]);

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20210831050732_20210831a', N'3.1.10');

GO

CREATE TABLE [OfficialInformation] (
    [Id] uniqueidentifier NOT NULL,
    [Type] nvarchar(50) NULL,
    [Title] nvarchar(200) NULL,
    [Url] nvarchar(1000) NULL,
    CONSTRAINT [PK_OfficialInformation] PRIMARY KEY ([Id])
);

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20210910063241_20210910a', N'3.1.10');

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'[SiteSettings_WebLeaveMessage]') AND [c].[name] = N'Notice');
IF @var0 IS NOT NULL EXEC(N'ALTER TABLE [SiteSettings_WebLeaveMessage] DROP CONSTRAINT [' + @var0 + '];');
ALTER TABLE [SiteSettings_WebLeaveMessage] ALTER COLUMN [Notice] nvarchar(max) NULL;

GO

DECLARE @var1 sysname;
SELECT @var1 = [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'[SiteSettings_WebChatStyle]') AND [c].[name] = N'ChatWindowTitle');
IF @var1 IS NOT NULL EXEC(N'ALTER TABLE [SiteSettings_WebChatStyle] DROP CONSTRAINT [' + @var1 + '];');
ALTER TABLE [SiteSettings_WebChatStyle] ALTER COLUMN [ChatWindowTitle] nvarchar(2000) NULL;

GO

DECLARE @var2 sysname;
SELECT @var2 = [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'[SiteSettings_WebChatOpeningGreetings]') AND [c].[name] = N'Greetings');
IF @var2 IS NOT NULL EXEC(N'ALTER TABLE [SiteSettings_WebChatOpeningGreetings] DROP CONSTRAINT [' + @var2 + '];');
ALTER TABLE [SiteSettings_WebChatOpeningGreetings] ALTER COLUMN [Greetings] nvarchar(max) NULL;

GO

DECLARE @var3 sysname;
SELECT @var3 = [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'[SiteSettings_MobileWebLeaveMessage]') AND [c].[name] = N'Notice');
IF @var3 IS NOT NULL EXEC(N'ALTER TABLE [SiteSettings_MobileWebLeaveMessage] DROP CONSTRAINT [' + @var3 + '];');
ALTER TABLE [SiteSettings_MobileWebLeaveMessage] ALTER COLUMN [Notice] nvarchar(max) NULL;

GO

DECLARE @var4 sysname;
SELECT @var4 = [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'[SiteSettings_MobileWebChatStyle]') AND [c].[name] = N'ChatWindowTitle');
IF @var4 IS NOT NULL EXEC(N'ALTER TABLE [SiteSettings_MobileWebChatStyle] DROP CONSTRAINT [' + @var4 + '];');
ALTER TABLE [SiteSettings_MobileWebChatStyle] ALTER COLUMN [ChatWindowTitle] nvarchar(2000) NULL;

GO

DECLARE @var5 sysname;
SELECT @var5 = [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'[SiteSettings_MobileWebChatOpeningGreetings]') AND [c].[name] = N'Greetings');
IF @var5 IS NOT NULL EXEC(N'ALTER TABLE [SiteSettings_MobileWebChatOpeningGreetings] DROP CONSTRAINT [' + @var5 + '];');
ALTER TABLE [SiteSettings_MobileWebChatOpeningGreetings] ALTER COLUMN [Greetings] nvarchar(max) NULL;

GO

DECLARE @var6 sysname;
SELECT @var6 = [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'[SiteSettings_LeaveMessageContentTemplate]') AND [c].[name] = N'ContentTemplate');
IF @var6 IS NOT NULL EXEC(N'ALTER TABLE [SiteSettings_LeaveMessageContentTemplate] DROP CONSTRAINT [' + @var6 + '];');
ALTER TABLE [SiteSettings_LeaveMessageContentTemplate] ALTER COLUMN [ContentTemplate] nvarchar(max) NULL;

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20210918171843_20210919a', N'3.1.10');

GO

DECLARE @var7 sysname;
SELECT @var7 = [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'[StaffPersonalSettings_WebChatOpeningGreetings]') AND [c].[name] = N'Greetings');
IF @var7 IS NOT NULL EXEC(N'ALTER TABLE [StaffPersonalSettings_WebChatOpeningGreetings] DROP CONSTRAINT [' + @var7 + '];');
ALTER TABLE [StaffPersonalSettings_WebChatOpeningGreetings] ALTER COLUMN [Greetings] nvarchar(max) NULL;

GO

DECLARE @var8 sysname;
SELECT @var8 = [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'[StaffPersonalSettings_MobileWebChatOpeningGreetings]') AND [c].[name] = N'Greetings');
IF @var8 IS NOT NULL EXEC(N'ALTER TABLE [StaffPersonalSettings_MobileWebChatOpeningGreetings] DROP CONSTRAINT [' + @var8 + '];');
ALTER TABLE [StaffPersonalSettings_MobileWebChatOpeningGreetings] ALTER COLUMN [Greetings] nvarchar(max) NULL;

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20210921104826_20210921a', N'3.1.10');

GO

ALTER TABLE [RobotItem] ADD [Language] int NOT NULL DEFAULT 0;

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20210921131557_20210921b', N'3.1.10');

GO

DROP TABLE [SiteSettings_ChatMisc];

GO

CREATE TABLE [SiteSettings_CustomerFillInFieldBeforeStart] (
    [Id] uniqueidentifier NOT NULL,
    [DomainId] uniqueidentifier NOT NULL,
    [SiteId] uniqueidentifier NOT NULL,
    [Language] int NOT NULL,
    [CustomerFillInFieldBeforeStart1] bit NOT NULL,
    [CustomerFillInFieldBeforeStart1_MultipleRow] bit NOT NULL,
    [CustomerFillInFieldBeforeStart1_Required] bit NOT NULL,
    [CustomerFillInFieldBeforeStart1_Title] nvarchar(100) NULL,
    [CustomerFillInFieldBeforeStart1_Description] nvarchar(200) NULL,
    [CustomerFillInFieldBeforeStart2] bit NOT NULL,
    [CustomerFillInFieldBeforeStart2_MultipleRow] bit NOT NULL,
    [CustomerFillInFieldBeforeStart2_Required] bit NOT NULL,
    [CustomerFillInFieldBeforeStart2_Title] nvarchar(100) NULL,
    [CustomerFillInFieldBeforeStart2_Description] nvarchar(200) NULL,
    [CustomerFillInFieldBeforeStart3] bit NOT NULL,
    [CustomerFillInFieldBeforeStart3_MultipleRow] bit NOT NULL,
    [CustomerFillInFieldBeforeStart3_Required] bit NOT NULL,
    [CustomerFillInFieldBeforeStart3_Title] nvarchar(100) NULL,
    [CustomerFillInFieldBeforeStart3_Description] nvarchar(200) NULL,
    CONSTRAINT [PK_SiteSettings_CustomerFillInFieldBeforeStart] PRIMARY KEY ([Id]),
    CONSTRAINT [FK_SiteSettings_CustomerFillInFieldBeforeStart_Domain_DomainId] FOREIGN KEY ([DomainId]) REFERENCES [Domain] ([Id]) ON DELETE CASCADE,
    CONSTRAINT [FK_SiteSettings_CustomerFillInFieldBeforeStart_Site_SiteId] FOREIGN KEY ([SiteId]) REFERENCES [Site] ([Id]) ON DELETE CASCADE
);

GO

CREATE INDEX [IX_SiteSettings_CustomerFillInFieldBeforeStart_DomainId] ON [SiteSettings_CustomerFillInFieldBeforeStart] ([DomainId]);

GO

CREATE INDEX [IX_SiteSettings_CustomerFillInFieldBeforeStart_SiteId] ON [SiteSettings_CustomerFillInFieldBeforeStart] ([SiteId]);

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20210925094922_20210925a', N'3.1.10');

GO

DECLARE @var9 sysname;
SELECT @var9 = [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'[SiteSettings_CustomerFillInFieldBeforeStart]') AND [c].[name] = N'Language');
IF @var9 IS NOT NULL EXEC(N'ALTER TABLE [SiteSettings_CustomerFillInFieldBeforeStart] DROP CONSTRAINT [' + @var9 + '];');
ALTER TABLE [SiteSettings_CustomerFillInFieldBeforeStart] DROP COLUMN [Language];

GO

DECLARE @var10 sysname;
SELECT @var10 = [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'[SiteSettings_CustomerFillInFieldBeforeStart]') AND [c].[name] = N'CustomerFillInFieldBeforeStart3_Title');
IF @var10 IS NOT NULL EXEC(N'ALTER TABLE [SiteSettings_CustomerFillInFieldBeforeStart] DROP CONSTRAINT [' + @var10 + '];');
ALTER TABLE [SiteSettings_CustomerFillInFieldBeforeStart] ALTER COLUMN [CustomerFillInFieldBeforeStart3_Title] nvarchar(max) NULL;

GO

DECLARE @var11 sysname;
SELECT @var11 = [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'[SiteSettings_CustomerFillInFieldBeforeStart]') AND [c].[name] = N'CustomerFillInFieldBeforeStart3_Description');
IF @var11 IS NOT NULL EXEC(N'ALTER TABLE [SiteSettings_CustomerFillInFieldBeforeStart] DROP CONSTRAINT [' + @var11 + '];');
ALTER TABLE [SiteSettings_CustomerFillInFieldBeforeStart] ALTER COLUMN [CustomerFillInFieldBeforeStart3_Description] nvarchar(max) NULL;

GO

DECLARE @var12 sysname;
SELECT @var12 = [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'[SiteSettings_CustomerFillInFieldBeforeStart]') AND [c].[name] = N'CustomerFillInFieldBeforeStart2_Title');
IF @var12 IS NOT NULL EXEC(N'ALTER TABLE [SiteSettings_CustomerFillInFieldBeforeStart] DROP CONSTRAINT [' + @var12 + '];');
ALTER TABLE [SiteSettings_CustomerFillInFieldBeforeStart] ALTER COLUMN [CustomerFillInFieldBeforeStart2_Title] nvarchar(max) NULL;

GO

DECLARE @var13 sysname;
SELECT @var13 = [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'[SiteSettings_CustomerFillInFieldBeforeStart]') AND [c].[name] = N'CustomerFillInFieldBeforeStart2_Description');
IF @var13 IS NOT NULL EXEC(N'ALTER TABLE [SiteSettings_CustomerFillInFieldBeforeStart] DROP CONSTRAINT [' + @var13 + '];');
ALTER TABLE [SiteSettings_CustomerFillInFieldBeforeStart] ALTER COLUMN [CustomerFillInFieldBeforeStart2_Description] nvarchar(max) NULL;

GO

DECLARE @var14 sysname;
SELECT @var14 = [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'[SiteSettings_CustomerFillInFieldBeforeStart]') AND [c].[name] = N'CustomerFillInFieldBeforeStart1_Title');
IF @var14 IS NOT NULL EXEC(N'ALTER TABLE [SiteSettings_CustomerFillInFieldBeforeStart] DROP CONSTRAINT [' + @var14 + '];');
ALTER TABLE [SiteSettings_CustomerFillInFieldBeforeStart] ALTER COLUMN [CustomerFillInFieldBeforeStart1_Title] nvarchar(max) NULL;

GO

DECLARE @var15 sysname;
SELECT @var15 = [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'[SiteSettings_CustomerFillInFieldBeforeStart]') AND [c].[name] = N'CustomerFillInFieldBeforeStart1_Description');
IF @var15 IS NOT NULL EXEC(N'ALTER TABLE [SiteSettings_CustomerFillInFieldBeforeStart] DROP CONSTRAINT [' + @var15 + '];');
ALTER TABLE [SiteSettings_CustomerFillInFieldBeforeStart] ALTER COLUMN [CustomerFillInFieldBeforeStart1_Description] nvarchar(max) NULL;

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20210925120850_20210925b', N'3.1.10');

GO

DECLARE @var16 sysname;
SELECT @var16 = [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'[SkillGroup]') AND [c].[name] = N'DisplayNameForCustomer');
IF @var16 IS NOT NULL EXEC(N'ALTER TABLE [SkillGroup] DROP CONSTRAINT [' + @var16 + '];');
ALTER TABLE [SkillGroup] ALTER COLUMN [DisplayNameForCustomer] nvarchar(max) NOT NULL;

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20210926150343_20210926a', N'3.1.10');

GO

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

GO

ALTER TABLE [Customer] ADD [LastSessionMissing] bit NOT NULL DEFAULT CAST(0 AS bit);

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20211015152600_20211015a', N'3.1.10');

GO

ALTER TABLE [Customer] ADD [LastLoginIPAddress] nvarchar(max) NULL;

GO

ALTER TABLE [Customer] ADD [LastLoginLocation] nvarchar(max) NULL;

GO

ALTER TABLE [Customer] ADD [LastLoginTime] datetime2 NULL;

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20211016074929_20211016a', N'3.1.10');

GO

CREATE TABLE [SiteSettings_WebPagePlugIn] (
    [Id] uniqueidentifier NOT NULL,
    [DomainId] uniqueidentifier NOT NULL,
    [SiteId] uniqueidentifier NOT NULL,
    [PlugIn1] bit NOT NULL,
    [PlugIn1_Title] nvarchar(50) NULL,
    [PlugIn1_Url] nvarchar(1000) NULL,
    [PlugIn2] bit NOT NULL,
    [PlugIn2_Title] nvarchar(50) NULL,
    [PlugIn2_Url] nvarchar(1000) NULL,
    [PlugIn3] bit NOT NULL,
    [PlugIn3_Title] nvarchar(50) NULL,
    [PlugIn3_Url] nvarchar(1000) NULL,
    CONSTRAINT [PK_SiteSettings_WebPagePlugIn] PRIMARY KEY ([Id]),
    CONSTRAINT [FK_SiteSettings_WebPagePlugIn_Domain_DomainId] FOREIGN KEY ([DomainId]) REFERENCES [Domain] ([Id]) ON DELETE CASCADE,
    CONSTRAINT [FK_SiteSettings_WebPagePlugIn_Site_SiteId] FOREIGN KEY ([SiteId]) REFERENCES [Site] ([Id]) ON DELETE CASCADE
);

GO

CREATE INDEX [IX_SiteSettings_WebPagePlugIn_DomainId] ON [SiteSettings_WebPagePlugIn] ([DomainId]);

GO

CREATE INDEX [IX_SiteSettings_WebPagePlugIn_SiteId] ON [SiteSettings_WebPagePlugIn] ([SiteId]);

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20211016123030_20211016b', N'3.1.10');

GO

CREATE TABLE [Admin] (
    [Id] uniqueidentifier NOT NULL,
    [Account] nvarchar(100) NOT NULL,
    [Password] nvarchar(50) NOT NULL,
    CONSTRAINT [PK_Admin] PRIMARY KEY ([Id])
);

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20211017024947_20211017a', N'3.1.10');

GO

DECLARE @var17 sysname;
SELECT @var17 = [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'[CustomerCount]') AND [c].[name] = N'City');
IF @var17 IS NOT NULL EXEC(N'ALTER TABLE [CustomerCount] DROP CONSTRAINT [' + @var17 + '];');
ALTER TABLE [CustomerCount] DROP COLUMN [City];

GO

DECLARE @var18 sysname;
SELECT @var18 = [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'[CustomerCount]') AND [c].[name] = N'Country');
IF @var18 IS NOT NULL EXEC(N'ALTER TABLE [CustomerCount] DROP CONSTRAINT [' + @var18 + '];');
ALTER TABLE [CustomerCount] DROP COLUMN [Country];

GO

DECLARE @var19 sysname;
SELECT @var19 = [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'[CustomerCount]') AND [c].[name] = N'Province');
IF @var19 IS NOT NULL EXEC(N'ALTER TABLE [CustomerCount] DROP CONSTRAINT [' + @var19 + '];');
ALTER TABLE [CustomerCount] DROP COLUMN [Province];

GO

ALTER TABLE [CustomerCount] ADD [Location] nvarchar(100) NOT NULL DEFAULT N'';

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20211127023415_20211127a', N'3.1.10');

GO

ALTER TABLE [DialogMessage] ADD [ContentLanguage] nvarchar(20) NULL;

GO

ALTER TABLE [DialogMessage] ADD [Translated] bit NOT NULL DEFAULT CAST(0 AS bit);

GO

ALTER TABLE [DialogMessage] ADD [TranslatedContent] nvarchar(max) NULL;

GO

ALTER TABLE [DialogMessage] ADD [TranslatedContentLanguage] nvarchar(20) NULL;

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20211226141215_20211225a', N'3.1.10');

GO

ALTER TABLE [Customer] ADD [ContentLanguage] nvarchar(20) NULL;

GO

ALTER TABLE [Customer] ADD [TranslateContentToLanguage] nvarchar(20) NULL;

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20220102072735_20220102a', N'3.1.10');

GO

CREATE TABLE [SiteSettings_Translation] (
    [Id] uniqueidentifier NOT NULL,
    [DomainId] uniqueidentifier NOT NULL,
    [SiteId] uniqueidentifier NOT NULL,
    [AutoTranslate] bit NOT NULL,
    [ContentLanguage] nvarchar(20) NULL,
    [TranslateContentToLanguage] nvarchar(20) 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
);

GO

CREATE INDEX [IX_SiteSettings_Translation_DomainId] ON [SiteSettings_Translation] ([DomainId]);

GO

CREATE INDEX [IX_SiteSettings_Translation_SiteId] ON [SiteSettings_Translation] ([SiteId]);

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20220104153548_20220102b', N'3.1.10');

GO

DECLARE @var20 sysname;
SELECT @var20 = [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'[SiteSettings_Misc]') AND [c].[name] = N'CustomerSideLanguage');
IF @var20 IS NOT NULL EXEC(N'ALTER TABLE [SiteSettings_Misc] DROP CONSTRAINT [' + @var20 + '];');
ALTER TABLE [SiteSettings_Misc] DROP COLUMN [CustomerSideLanguage];

GO

CREATE TABLE [SiteSettings_CustomerSideLanguages] (
    [Id] uniqueidentifier NOT NULL,
    [DomainId] uniqueidentifier NOT NULL,
    [SiteId] uniqueidentifier NOT NULL,
    [DefaultLanguage] int NOT NULL,
    [AllowCustomerSwitchLanguage] bit NOT NULL,
    [AllLanguagesAvailable] bit NOT NULL,
    [AllowedLanguages] nvarchar(1000) 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
);

GO

CREATE INDEX [IX_SiteSettings_CustomerSideLanguages_DomainId] ON [SiteSettings_CustomerSideLanguages] ([DomainId]);

GO

CREATE INDEX [IX_SiteSettings_CustomerSideLanguages_SiteId] ON [SiteSettings_CustomerSideLanguages] ([SiteId]);

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20220131094450_20220131a', N'3.1.10');

GO

ALTER TABLE [SiteSettings_MobileWebChatStyle] ADD [ShowGoBackButton] bit NOT NULL DEFAULT CAST(0 AS bit);

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20220201132449_20220201a', N'3.1.10');

GO

CREATE TABLE [SiteSettings_AutoGreetings] (
    [Id] uniqueidentifier NOT NULL,
    [DomainId] uniqueidentifier NOT NULL,
    [SiteId] uniqueidentifier NOT NULL,
    [WebChatAutoExpand] int NOT NULL,
    [ShowGreetings] int NOT NULL,
    [Greetings] nvarchar(max) 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
);

GO

CREATE TABLE [SiteSettings_MobileAutoGreetings] (
    [Id] uniqueidentifier NOT NULL,
    [DomainId] uniqueidentifier NOT NULL,
    [SiteId] uniqueidentifier NOT NULL,
    [WebChatAutoExpand] int NOT NULL,
    [ShowGreetings] int NOT NULL,
    [Greetings] nvarchar(max) 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
);

GO

CREATE INDEX [IX_SiteSettings_AutoGreetings_DomainId] ON [SiteSettings_AutoGreetings] ([DomainId]);

GO

CREATE INDEX [IX_SiteSettings_AutoGreetings_SiteId] ON [SiteSettings_AutoGreetings] ([SiteId]);

GO

CREATE INDEX [IX_SiteSettings_MobileAutoGreetings_DomainId] ON [SiteSettings_MobileAutoGreetings] ([DomainId]);

GO

CREATE INDEX [IX_SiteSettings_MobileAutoGreetings_SiteId] ON [SiteSettings_MobileAutoGreetings] ([SiteId]);

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20220220023655_20220219a', N'3.1.10');

GO

ALTER TABLE [SiteSettings_MiniWebChat] ADD [TitleWhenNoStaffOnline] nvarchar(2000) NULL;

GO

ALTER TABLE [SiteSettings_MiniWebChat] ADD [TitleWhenStaffOnline] nvarchar(2000) NULL;

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20220625103202_20220625a', N'3.1.10');

GO

CREATE TABLE [SiteSettings_MobileMiniWebChat] (
    [Id] uniqueidentifier NOT NULL,
    [DomainId] uniqueidentifier NOT NULL,
    [SiteId] uniqueidentifier NOT NULL,
    [TitleWhenStaffOnline] nvarchar(2000) NULL,
    [TitleWhenNoStaffOnline] nvarchar(2000) 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
);

GO

CREATE INDEX [IX_SiteSettings_MobileMiniWebChat_DomainId] ON [SiteSettings_MobileMiniWebChat] ([DomainId]);

GO

CREATE INDEX [IX_SiteSettings_MobileMiniWebChat_SiteId] ON [SiteSettings_MobileMiniWebChat] ([SiteId]);

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20220702083931_20220702a', N'3.1.10');

GO

DROP TABLE [SiteSettings_CustomerSideLanguages];

GO

DECLARE @var21 sysname;
SELECT @var21 = [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'[Customer]') AND [c].[name] = N'CustomerSideLanguage');
IF @var21 IS NOT NULL EXEC(N'ALTER TABLE [Customer] DROP CONSTRAINT [' + @var21 + '];');
ALTER TABLE [Customer] DROP COLUMN [CustomerSideLanguage];

GO

DECLARE @var22 sysname;
SELECT @var22 = [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'[RobotItem]') AND [c].[name] = N'Language');
IF @var22 IS NOT NULL EXEC(N'ALTER TABLE [RobotItem] DROP CONSTRAINT [' + @var22 + '];');
ALTER TABLE [RobotItem] ALTER COLUMN [Language] nvarchar(max) NOT NULL;

GO

ALTER TABLE [Customer] ADD [CustomerUILanguage] nvarchar(max) NULL;

GO

CREATE TABLE [CustomerUILanguage] (
    [Id] uniqueidentifier NOT NULL,
    [Name] nvarchar(50) NULL,
    [Code] nvarchar(20) NULL,
    [OrderNumber] int NOT NULL,
    CONSTRAINT [PK_CustomerUILanguage] PRIMARY KEY ([Id])
);

GO

CREATE TABLE [RobotExternalApiSettings] (
    [Id] uniqueidentifier NOT NULL,
    [DomainId] uniqueidentifier NOT NULL,
    [SiteId] uniqueidentifier NOT NULL,
    [Url] nvarchar(max) 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
);

GO

CREATE TABLE [RobotSettings] (
    [Id] uniqueidentifier NOT NULL,
    [DomainId] uniqueidentifier NOT NULL,
    [SiteId] uniqueidentifier 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
);

GO

CREATE TABLE [SiteSettings_CustomerUILanguage] (
    [Id] uniqueidentifier NOT NULL,
    [DomainId] uniqueidentifier NOT NULL,
    [SiteId] uniqueidentifier NOT NULL,
    [DefaultLanguage] nvarchar(max) NULL,
    [AllowCustomerSwitchLanguage] bit NOT NULL,
    [AllLanguagesAvailable] bit NOT NULL,
    [AllowedLanguages] nvarchar(1000) 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
);

GO

CREATE INDEX [IX_RobotExternalApiSettings_DomainId] ON [RobotExternalApiSettings] ([DomainId]);

GO

CREATE INDEX [IX_RobotExternalApiSettings_SiteId] ON [RobotExternalApiSettings] ([SiteId]);

GO

CREATE INDEX [IX_RobotSettings_DomainId] ON [RobotSettings] ([DomainId]);

GO

CREATE INDEX [IX_RobotSettings_SiteId] ON [RobotSettings] ([SiteId]);

GO

CREATE INDEX [IX_SiteSettings_CustomerUILanguage_DomainId] ON [SiteSettings_CustomerUILanguage] ([DomainId]);

GO

CREATE INDEX [IX_SiteSettings_CustomerUILanguage_SiteId] ON [SiteSettings_CustomerUILanguage] ([SiteId]);

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20220910140729_20220910a', N'3.1.10');

GO

ALTER TABLE [SiteSettings_CustomerUILanguage] ADD [ReplacementLanguage] nvarchar(max) NULL;

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20220918023541_20220917a', N'3.1.10');

GO

DECLARE @var23 sysname;
SELECT @var23 = [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'[SiteSettings_CustomerUILanguage]') AND [c].[name] = N'ReplacementLanguage');
IF @var23 IS NOT NULL EXEC(N'ALTER TABLE [SiteSettings_CustomerUILanguage] DROP CONSTRAINT [' + @var23 + '];');
ALTER TABLE [SiteSettings_CustomerUILanguage] ALTER COLUMN [ReplacementLanguage] nvarchar(20) NULL;

GO

DECLARE @var24 sysname;
SELECT @var24 = [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'[SiteSettings_CustomerUILanguage]') AND [c].[name] = N'DefaultLanguage');
IF @var24 IS NOT NULL EXEC(N'ALTER TABLE [SiteSettings_CustomerUILanguage] DROP CONSTRAINT [' + @var24 + '];');
ALTER TABLE [SiteSettings_CustomerUILanguage] ALTER COLUMN [DefaultLanguage] nvarchar(20) NULL;

GO

DECLARE @var25 sysname;
SELECT @var25 = [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'[RobotItem]') AND [c].[name] = N'Language');
IF @var25 IS NOT NULL EXEC(N'ALTER TABLE [RobotItem] DROP CONSTRAINT [' + @var25 + '];');
ALTER TABLE [RobotItem] ALTER COLUMN [Language] nvarchar(20) NOT NULL;

GO

DECLARE @var26 sysname;
SELECT @var26 = [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'[Customer]') AND [c].[name] = N'CustomerUILanguage');
IF @var26 IS NOT NULL EXEC(N'ALTER TABLE [Customer] DROP CONSTRAINT [' + @var26 + '];');
ALTER TABLE [Customer] ALTER COLUMN [CustomerUILanguage] nvarchar(20) NULL;

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20221029081133_20221029a', N'3.1.10');

GO

ALTER TABLE [Site] ADD [SiteLoginAuthorization] int NOT NULL DEFAULT 0;

GO

CREATE TABLE [SiteLoginAppointedStaff] (
    [Id] uniqueidentifier NOT NULL,
    [DomainId] uniqueidentifier NOT NULL,
    [SiteId] uniqueidentifier NOT NULL,
    [StaffId] uniqueidentifier NOT NULL,
    CONSTRAINT [PK_SiteLoginAppointedStaff] PRIMARY KEY ([Id]),
    CONSTRAINT [FK_SiteLoginAppointedStaff_Domain_DomainId] FOREIGN KEY ([DomainId]) REFERENCES [Domain] ([Id]) ON DELETE NO ACTION,
    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
);

GO

CREATE INDEX [IX_SiteLoginAppointedStaff_DomainId] ON [SiteLoginAppointedStaff] ([DomainId]);

GO

CREATE INDEX [IX_SiteLoginAppointedStaff_SiteId] ON [SiteLoginAppointedStaff] ([SiteId]);

GO

CREATE INDEX [IX_SiteLoginAppointedStaff_StaffId] ON [SiteLoginAppointedStaff] ([StaffId]);

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20230402130525_20230402a', N'3.1.10');

GO

ALTER TABLE [Session] ADD [FeedbackContent] nvarchar(500) NULL;

GO

ALTER TABLE [Session] ADD [FeedbackStar] int NULL;

GO

DECLARE @var27 sysname;
SELECT @var27 = [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'[PublishedClientVersion]') AND [c].[name] = N'Version');
IF @var27 IS NOT NULL EXEC(N'ALTER TABLE [PublishedClientVersion] DROP CONSTRAINT [' + @var27 + '];');
ALTER TABLE [PublishedClientVersion] ALTER COLUMN [Version] nvarchar(50) NULL;

GO

DECLARE @var28 sysname;
SELECT @var28 = [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'[PublishedClientVersion]') AND [c].[name] = N'Url');
IF @var28 IS NOT NULL EXEC(N'ALTER TABLE [PublishedClientVersion] DROP CONSTRAINT [' + @var28 + '];');
ALTER TABLE [PublishedClientVersion] ALTER COLUMN [Url] nvarchar(1000) NULL;

GO

DECLARE @var29 sysname;
SELECT @var29 = [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'[PublishedClientVersion]') AND [c].[name] = N'Type');
IF @var29 IS NOT NULL EXEC(N'ALTER TABLE [PublishedClientVersion] DROP CONSTRAINT [' + @var29 + '];');
ALTER TABLE [PublishedClientVersion] ALTER COLUMN [Type] nvarchar(10) NULL;

GO

CREATE TABLE [SiteSettings_WebChatMisc] (
    [Id] uniqueidentifier NOT NULL,
    [DomainId] uniqueidentifier NOT NULL,
    [SiteId] uniqueidentifier 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
);

GO

CREATE INDEX [IX_SiteSettings_WebChatMisc_DomainId] ON [SiteSettings_WebChatMisc] ([DomainId]);

GO

CREATE INDEX [IX_SiteSettings_WebChatMisc_SiteId] ON [SiteSettings_WebChatMisc] ([SiteId]);

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20230818162214_20230819a', N'3.1.10');

GO

CREATE TABLE [FavouriteFile] (
    [Id] uniqueidentifier NOT NULL,
    [DomainId] uniqueidentifier NOT NULL,
    [StaffId] uniqueidentifier NOT NULL,
    [SiteId] uniqueidentifier NOT NULL,
    [Name] nvarchar(200) NOT NULL,
    [Extension] nvarchar(50) NULL,
    [Size] float NULL,
    [Description] nvarchar(500) NULL,
    [Url] nvarchar(1000) NULL,
    [Shared] bit NOT NULL,
    [CreateTime] datetime2 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
);

GO

CREATE INDEX [IX_FavouriteFile_DomainId] ON [FavouriteFile] ([DomainId]);

GO

CREATE INDEX [IX_FavouriteFile_SiteId] ON [FavouriteFile] ([SiteId]);

GO

CREATE INDEX [IX_FavouriteFile_StaffId] ON [FavouriteFile] ([StaffId]);

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20231115073347_20231113a', N'3.1.10');

GO

DECLARE @var30 sysname;
SELECT @var30 = [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'[SiteSettings_Misc]') AND [c].[name] = N'CustomerSideHistory');
IF @var30 IS NOT NULL EXEC(N'ALTER TABLE [SiteSettings_Misc] DROP CONSTRAINT [' + @var30 + '];');
ALTER TABLE [SiteSettings_Misc] DROP COLUMN [CustomerSideHistory];

GO

ALTER TABLE [SiteSettings_WebChatMisc] ADD [CustomerSideHistory] int NOT NULL DEFAULT 0;

GO

ALTER TABLE [SiteSettings_Misc] ADD [IPLocationLanguage] nvarchar(10) NULL;

GO

ALTER TABLE [SiteSettings_CustomerFillInFieldBeforeStart] ADD [CustomerFillInFieldBeforeStart1_Name] nvarchar(50) NULL;

GO

ALTER TABLE [SiteSettings_CustomerFillInFieldBeforeStart] ADD [CustomerFillInFieldBeforeStart2_Name] nvarchar(50) NULL;

GO

ALTER TABLE [SiteSettings_CustomerFillInFieldBeforeStart] ADD [CustomerFillInFieldBeforeStart3_Name] nvarchar(50) NULL;

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20231203145052_20231203a', N'3.1.10');

GO

ALTER TABLE [SiteSettings_Misc] ADD [StoreVisitSession] bit NOT NULL DEFAULT CAST(0 AS bit);

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20231227152420_20231227a', N'3.1.10');

GO

DROP TABLE [BlockedIP];

GO

CREATE TABLE [Blocked] (
    [Id] uniqueidentifier NOT NULL,
    [Key] nvarchar(50) NOT NULL,
    [IsIPAddress] bit NOT NULL,
    [BlockedTime] datetime2 NOT NULL,
    [Forever] bit NOT NULL,
    [Description] nvarchar(500) NULL,
    CONSTRAINT [PK_Blocked] PRIMARY KEY ([Id])
);

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20240201145138_20240201a', N'3.1.10');

GO