if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_logParserApplication_logParserLogs]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[logWatcherApplication] DROP CONSTRAINT FK_logParserApplication_logParserLogs;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_logWatcherDate_logWatcherLogs]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[logWatcherDate] DROP CONSTRAINT FK_logWatcherDate_logWatcherLogs;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_logParserPage_logParserLogs]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[logWatcherPage] DROP CONSTRAINT FK_logParserPage_logParserLogs;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_logParserSeverity_logParserLogs]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[logWatcherSeverity] DROP CONSTRAINT FK_logParserSeverity_logParserLogs;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_logParserThread_logParserLogs]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[logWatcherThread] DROP CONSTRAINT FK_logParserThread_logParserLogs;

/****** Object:  Table [dbo].[logWatcherApplication]    Script Date: 3/30/2006 6:50:09 AM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[logWatcherApplication]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[logWatcherApplication];

/****** Object:  Table [dbo].[logWatcherDate]    Script Date: 3/30/2006 6:50:09 AM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[logWatcherDate]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[logWatcherDate];

/****** Object:  Table [dbo].[logWatcherLastRun]    Script Date: 3/30/2006 6:50:09 AM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[logWatcherLastRun]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[logWatcherLastRun];

/****** Object:  Table [dbo].[logWatcherLogs]    Script Date: 3/30/2006 6:50:09 AM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[logWatcherLogs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[logWatcherLogs];

/****** Object:  Table [dbo].[logWatcherPage]    Script Date: 3/30/2006 6:50:09 AM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[logWatcherPage]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[logWatcherPage];

/****** Object:  Table [dbo].[logWatcherSeverity]    Script Date: 3/30/2006 6:50:09 AM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[logWatcherSeverity]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[logWatcherSeverity];

/****** Object:  Table [dbo].[logWatcherThread]    Script Date: 3/30/2006 6:50:09 AM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[logWatcherThread]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[logWatcherThread];

/****** Object:  Table [dbo].[itemCount]    Script Date: 3/30/2006 6:50:09 AM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[itemCount]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[itemCount];

/****** Object:  Table [dbo].[logWatcherApplication]    Script Date: 3/30/2006 6:50:12 AM ******/
CREATE TABLE [dbo].[logWatcherApplication] (
	[applicationID] [int] IDENTITY (1, 1) NOT NULL ,
	[logID] [int] NOT NULL ,
	[application] [varchar] (100) NOT NULL ,
	[hitCount] [int] NOT NULL 
);

/****** Object:  Table [dbo].[logWatcherDate]    Script Date: 3/30/2006 6:50:13 AM ******/
CREATE TABLE [dbo].[logWatcherDate] (
	[dateID] [int] IDENTITY (1, 1) NOT NULL ,
	[logID] [int] NOT NULL ,
	[date] [datetime] NOT NULL ,
	[hitCount] [int] NOT NULL 
);

/****** Object:  Table [dbo].[logWatcherLastRun]    Script Date: 3/30/2006 6:50:13 AM ******/
CREATE TABLE [dbo].[logWatcherLastRun] (
	[lastRun] [datetime] NOT NULL 
);

/****** Object:  Table [dbo].[logWatcherLogs]    Script Date: 3/30/2006 6:50:13 AM ******/
CREATE TABLE [dbo].[logWatcherLogs] (
	[logID] [int] IDENTITY (1, 1) NOT NULL ,
	[logName] [varchar] (100) NOT NULL ,
	[hitCount] [int] NOT NULL 
);

/****** Object:  Table [dbo].[logWatcherPage]    Script Date: 3/30/2006 6:50:13 AM ******/
CREATE TABLE [dbo].[logWatcherPage] (
	[pageID] [int] IDENTITY (1, 1) NOT NULL ,
	[logID] [int] NOT NULL ,
	[page] [varchar] (400) NOT NULL ,
	[hitCount] [int] NOT NULL 
);

/****** Object:  Table [dbo].[logWatcherSeverity]    Script Date: 3/30/2006 6:50:13 AM ******/
CREATE TABLE [dbo].[logWatcherSeverity] (
	[severityID] [int] IDENTITY (1, 1) NOT NULL ,
	[logID] [int] NOT NULL ,
	[severity] [varchar] (100) NOT NULL ,
	[hitCount] [int] NOT NULL 
);

/****** Object:  Table [dbo].[logWatcherThread]    Script Date: 3/30/2006 6:50:13 AM ******/
CREATE TABLE [dbo].[logWatcherThread] (
	[threadID] [int] IDENTITY (1, 1) NOT NULL ,
	[logID] [int] NOT NULL ,
	[thread] [varchar] (100) NOT NULL ,
	[hitCount] [int] NOT NULL 
);

/****** Object:  Table [dbo].[itemCount]    Script Date: 04/01/2006 20:39:45 ******/
CREATE TABLE [dbo].[itemCount](
	[item] [int] NOT NULL,
	[weekday] [varchar](9) NULL,
	[month] [varchar](15) NULL
)

ALTER TABLE [dbo].[logWatcherApplication] WITH NOCHECK ADD 
	CONSTRAINT [PK_logParserApplication] PRIMARY KEY  CLUSTERED 
	(
		[logID],
		[application]
	);

ALTER TABLE [dbo].[logWatcherDate] WITH NOCHECK ADD 
	CONSTRAINT [PK_logWatcherDate] PRIMARY KEY  CLUSTERED 
	(
		[logID],
		[date]
	);

ALTER TABLE [dbo].[logWatcherLogs] WITH NOCHECK ADD 
	CONSTRAINT [PK_logParserLogs] PRIMARY KEY  CLUSTERED 
	(
		[logID]
	) ;

ALTER TABLE [dbo].[logWatcherPage] WITH NOCHECK ADD 
	CONSTRAINT [PK_logParserPage] PRIMARY KEY  CLUSTERED 
	(
		[logID],
		[page]
	);

ALTER TABLE [dbo].[logWatcherSeverity] WITH NOCHECK ADD 
	CONSTRAINT [PK_logParserSeverity] PRIMARY KEY  CLUSTERED 
	(
		[logID],
		[severity]
	);

ALTER TABLE [dbo].[logWatcherThread] WITH NOCHECK ADD 
	CONSTRAINT [PK_logParserThread] PRIMARY KEY  CLUSTERED 
	(
		[logID],
		[thread]
	);

 CREATE  INDEX [IX_logWatcherDate] ON [dbo].[logWatcherDate]([date]);

ALTER TABLE [dbo].[logWatcherApplication] ADD 
	CONSTRAINT [FK_logParserApplication_logParserLogs] FOREIGN KEY 
	(
		[logID]
	) REFERENCES [dbo].[logWatcherLogs] (
		[logID]
	) ON DELETE CASCADE  ON UPDATE CASCADE ;

ALTER TABLE [dbo].[logWatcherDate] ADD 
	CONSTRAINT [FK_logWatcherDate_logWatcherLogs] FOREIGN KEY 
	(
		[logID]
	) REFERENCES [dbo].[logWatcherLogs] (
		[logID]
	) ON DELETE CASCADE  ON UPDATE CASCADE ;

ALTER TABLE [dbo].[logWatcherPage] ADD 
	CONSTRAINT [FK_logParserPage_logParserLogs] FOREIGN KEY 
	(
		[logID]
	) REFERENCES [dbo].[logWatcherLogs] (
		[logID]
	) ON DELETE CASCADE  ON UPDATE CASCADE;

ALTER TABLE [dbo].[logWatcherSeverity] ADD 
	CONSTRAINT [FK_logParserSeverity_logParserLogs] FOREIGN KEY 
	(
		[logID]
	) REFERENCES [dbo].[logWatcherLogs] (
		[logID]
	) ON DELETE CASCADE  ON UPDATE CASCADE ;

ALTER TABLE [dbo].[logWatcherThread] ADD 
	CONSTRAINT [FK_logParserThread_logParserLogs] FOREIGN KEY 
	(
		[logID]
	) REFERENCES [dbo].[logWatcherLogs] (
		[logID]
	) ON DELETE CASCADE  ON UPDATE CASCADE 

INSERT INTO dbo.logWatcherLastRun VALUES('1900-01-01 00:00:00')

INSERT INTO itemCount VALUES(1,'Sunday','January')
INSERT INTO itemCount VALUES(2,'Monday','February')
INSERT INTO itemCount VALUES(3,'Tuesday','March')
INSERT INTO itemCount VALUES(4,'Wednesday','April')
INSERT INTO itemCount VALUES(5,'Thursday','May')
INSERT INTO itemCount VALUES(6,'Friday','June')
INSERT INTO itemCount VALUES(7,'Saturday','July')
INSERT INTO itemCount VALUES(8,NULL,'August')
INSERT INTO itemCount VALUES(9,NULL,'September')
INSERT INTO itemCount VALUES(10,NULL,'October')
INSERT INTO itemCount VALUES(11,NULL,'November')
INSERT INTO itemCount VALUES(12,NULL,'December')
INSERT INTO itemCount VALUES(13,NULL,NULL)
INSERT INTO itemCount VALUES(14,NULL,NULL)
INSERT INTO itemCount VALUES(15,NULL,NULL)
INSERT INTO itemCount VALUES(16,NULL,NULL)
INSERT INTO itemCount VALUES(17,NULL,NULL)
INSERT INTO itemCount VALUES(18,NULL,NULL)
INSERT INTO itemCount VALUES(19,NULL,NULL)
INSERT INTO itemCount VALUES(20,NULL,NULL)
INSERT INTO itemCount VALUES(21,NULL,NULL)
INSERT INTO itemCount VALUES(22,NULL,NULL)
INSERT INTO itemCount VALUES(23,NULL,NULL)
INSERT INTO itemCount VALUES(24,NULL,NULL)
INSERT INTO itemCount VALUES(25,NULL,NULL)
INSERT INTO itemCount VALUES(26,NULL,NULL)
INSERT INTO itemCount VALUES(27,NULL,NULL)
INSERT INTO itemCount VALUES(28,NULL,NULL)
INSERT INTO itemCount VALUES(29,NULL,NULL)
INSERT INTO itemCount VALUES(30,NULL,NULL)
INSERT INTO itemCount VALUES(31,NULL,NULL)