Create ProxyWebApps and ProxyWebAppCounts tables

dbo.ProxyWebApps.sql

USE [IisLogs]
GO

/****** Object:  Table [dbo].[ProxyWebApps]    Script Date: 9/2/2018 6:48:43 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[ProxyWebApps](
	[SiteName] [varchar](255) NOT NULL,
	[AppPath] [varchar](255) NOT NULL,
 CONSTRAINT [PK_ProxyWebApps] PRIMARY KEY CLUSTERED 
(
	[SiteName] ASC,
	[AppPath] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

USE [IisLogs]
GO

/****** Object:  Table [dbo].[ProxyWebAppCounts]    Script Date: 9/2/2018 6:49:53 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[ProxyWebAppCounts](
	[SiteName] [varchar](255) NOT NULL,
	[WebAppCount] [int] NOT NULL,
 CONSTRAINT [PK_ProxyWebAppCounts] PRIMARY KEY CLUSTERED 
(
	[SiteName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO