/*
Run this script on SQL Server 2008 or later. There may be flaws if running on earlier versions of SQL Server.
*/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Calendar]') AND type in (N'U'))
DROP TABLE [dbo].[Calendar]
GO
CREATE TABLE [dbo].[Calendar] (
	[ShowName]						[varchar](100)	 COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Category]						[varchar](100)	 COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[WeekEndingDate]				[datetime]		 NULL,
	[Quantity]						[int]			 NULL,
	[Cost]							[decimal](15, 4) NULL,
	[Type]							[varchar](100)	 COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[UseQuantityCostCalculated]		[varchar](100)	 COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[CGEFX]							[varchar](100)	 COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[GLDept]						[varchar](100)	 COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Credit_Dept]					[varchar](100)	 COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[uom]							[varchar](100)	 COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[HrsWeek]						[varchar](100)	 COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[IncomeStmtType]				[varchar](100)	 COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[UserDef1]						[varchar](100)	 COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[AverageRate]					[decimal](15, 4) NULL
) ON [PRIMARY]
GO