DROP TABLE [SiteSettings_CustomerSideLanguages];

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

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'[RobotItem]') AND [c].[name] = N'Language');
IF @var1 IS NOT NULL EXEC(N'ALTER TABLE [RobotItem] DROP CONSTRAINT [' + @var1 + '];');
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 @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_CustomerUILanguage]') AND [c].[name] = N'ReplacementLanguage');
IF @var2 IS NOT NULL EXEC(N'ALTER TABLE [SiteSettings_CustomerUILanguage] DROP CONSTRAINT [' + @var2 + '];');
ALTER TABLE [SiteSettings_CustomerUILanguage] ALTER COLUMN [ReplacementLanguage] nvarchar(20) 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_CustomerUILanguage]') AND [c].[name] = N'DefaultLanguage');
IF @var3 IS NOT NULL EXEC(N'ALTER TABLE [SiteSettings_CustomerUILanguage] DROP CONSTRAINT [' + @var3 + '];');
ALTER TABLE [SiteSettings_CustomerUILanguage] ALTER COLUMN [DefaultLanguage] nvarchar(20) 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'[RobotItem]') AND [c].[name] = N'Language');
IF @var4 IS NOT NULL EXEC(N'ALTER TABLE [RobotItem] DROP CONSTRAINT [' + @var4 + '];');
ALTER TABLE [RobotItem] ALTER COLUMN [Language] nvarchar(20) NOT 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'[Customer]') AND [c].[name] = N'CustomerUILanguage');
IF @var5 IS NOT NULL EXEC(N'ALTER TABLE [Customer] DROP CONSTRAINT [' + @var5 + '];');
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 @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'[PublishedClientVersion]') AND [c].[name] = N'Version');
IF @var6 IS NOT NULL EXEC(N'ALTER TABLE [PublishedClientVersion] DROP CONSTRAINT [' + @var6 + '];');
ALTER TABLE [PublishedClientVersion] ALTER COLUMN [Version] nvarchar(50) NULL;

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'[PublishedClientVersion]') AND [c].[name] = N'Url');
IF @var7 IS NOT NULL EXEC(N'ALTER TABLE [PublishedClientVersion] DROP CONSTRAINT [' + @var7 + '];');
ALTER TABLE [PublishedClientVersion] ALTER COLUMN [Url] nvarchar(1000) 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'[PublishedClientVersion]') AND [c].[name] = N'Type');
IF @var8 IS NOT NULL EXEC(N'ALTER TABLE [PublishedClientVersion] DROP CONSTRAINT [' + @var8 + '];');
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 @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_Misc]') AND [c].[name] = N'CustomerSideHistory');
IF @var9 IS NOT NULL EXEC(N'ALTER TABLE [SiteSettings_Misc] DROP CONSTRAINT [' + @var9 + '];');
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