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