ALTER TABLE [SiteSettings_MiniWebChat] ADD [CollapsedStyle] int NOT NULL DEFAULT 0;

GO

ALTER TABLE [SiteSettings_MiniWebChat] ADD [IconHorizontalMargin] int NOT NULL DEFAULT 0;

GO

ALTER TABLE [SiteSettings_MiniWebChat] ADD [IconImageWhenNoStaffOnline] nvarchar(1000) NULL;

GO

ALTER TABLE [SiteSettings_MiniWebChat] ADD [IconImageWhenStaffOnline] nvarchar(1000) NULL;

GO

ALTER TABLE [SiteSettings_MiniWebChat] ADD [IconVerticalMargin] int NOT NULL DEFAULT 0;

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20240413074302_20240413a', N'3.1.10');

GO

ALTER TABLE [SiteSettings_MiniWebChat] ADD [CollapsedIconPosition] int NOT NULL DEFAULT 0;

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20240413093914_20240413b', N'3.1.10');

GO

ALTER TABLE [QuicklyReplyItem] ADD [HotKey] nvarchar(50) NULL;

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20241008104031_20241008a', N'3.1.10');

GO

CREATE TABLE [StaffClientWebPagePlugIn] (
    [Id] uniqueidentifier NOT NULL,
    [DomainId] uniqueidentifier NOT NULL,
    [SiteId] uniqueidentifier NOT NULL,
    [Enable] bit NOT NULL,
    [Title] nvarchar(50) NULL,
    [Url] nvarchar(2000) NULL,
    [Description] nvarchar(500) NULL,
    [NumericalOrder] bigint NOT NULL,
    CONSTRAINT [PK_StaffClientWebPagePlugIn] PRIMARY KEY ([Id]),
    CONSTRAINT [FK_StaffClientWebPagePlugIn_Domain_DomainId] FOREIGN KEY ([DomainId]) REFERENCES [Domain] ([Id]) ON DELETE CASCADE,
    CONSTRAINT [FK_StaffClientWebPagePlugIn_Site_SiteId] FOREIGN KEY ([SiteId]) REFERENCES [Site] ([Id]) ON DELETE CASCADE
);

GO

CREATE INDEX [IX_StaffClientWebPagePlugIn_DomainId] ON [StaffClientWebPagePlugIn] ([DomainId]);

GO

CREATE INDEX [IX_StaffClientWebPagePlugIn_SiteId] ON [StaffClientWebPagePlugIn] ([SiteId]);

GO

INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20241013042920_20241013a', N'3.1.10');

GO