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