CreateTables.txt

CREATE TABLE [dbo].[AppInsightLogs](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[ApplicationId] [nvarchar](50) NOT NULL,
	[AppInsightType] [int] NOT NULL,
	[ProblemId] [nvarchar](max) NULL,
	[ProblemIdBase64] [nvarchar](max) NULL,
	[OuterType] [nvarchar](max) NULL,
	[Type] [nvarchar](max) NULL,
	[InnermostType] [nvarchar](max) NULL,
	[OuterAssembly] [nvarchar](max) NULL,
	[Assembly] [nvarchar](max) NULL,
	[OuterMethod] [nvarchar](max) NULL,
	[Method] [nvarchar](max) NULL,
	[ExceptionCount] [int] NOT NULL,
	[DateCreated] [datetime] NOT NULL,
 CONSTRAINT [PK_dbo.AppInsightLogs] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Applications](
	[Id] [nvarchar](50) NULL,
	[Title] [nvarchar](50) NULL,
	[NextHourly] [datetime] NULL,
	[NextDaily] [datetime] NULL,
	[ApplicationInsightsId] [nvarchar](50) NULL,
	[ApplicationInsigtsKey] [nvarchar](50) NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TriggeredAlerts](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[ApplicationId] [nvarchar](50) NULL,
	[AlertId] [nvarchar](50) NULL,
	[Title] [nvarchar](50) NULL,
	[DateTriggered] [datetime] NULL
) ON [PRIMARY]
GO