Change log¶

CREATE TABLE [Alert] (
    [Id] nvarchar(450) NOT NULL,
    [Organization_Id] nvarchar(450) NOT NULL,
    [Name] nvarchar(256) NOT NULL,
    [Description] nvarchar(1000) NULL,
    [Severity] nvarchar(100) NOT NULL,
    [JavascriptCode] nvarchar(max) NOT NULL,
    [ThrottleInSeconds] int NOT NULL,
    [DateTimeCreated] datetime2 NOT NULL,
    [DateTimeUpdated] datetime2 NOT NULL,
    [IsActive] bit NOT NULL,
    [AppliesTo] nvarchar(2000) NULL,
    [SlackNotification] nvarchar(2000) NULL,
    [MicrosoftTeamsNotification] nvarchar(2000) NULL,
    [EmailNotification] nvarchar(2000) NULL,
    [WebhookNotification] nvarchar(2000) NULL,
    CONSTRAINT [PK_Alert] PRIMARY KEY ([Id]),
    CONSTRAINT [FK_Alert_Organization_Organization_Id] FOREIGN KEY ([Organization_Id]) REFERENCES [Organization] ([Id]) ON DELETE CASCADE
);

CREATE INDEX [IX_Alert_Organization_Id] ON [Alert] ([Organization_Id]);

DROP TABLE [OrganizationSlackConfiguration];
DROP TABLE [ApplicationAlert];
DROP TABLE [ApplicationAlertEmailNotification];
DROP TABLE [ApplicationAlertSlackNotification];

-- if [CustomProperty] table exists
DROP TABLE [CustomProperty];