-- Table: dbo.PartitionPlan
-- Bill Wunder

use admin

GO

CREATE TABLE [dbo].[PartitionPlan] (
	[PlanName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[DBName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[PlanOwner] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[PartitionsToKeep] [smallint] NOT NULL ,
	[PartitionsToPrebuild] [smallint] NOT NULL ,
	[PartitionTagPlaceHolder] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
        CONSTRAINT [dft_PartitionPlan__PartitionTagPlaceHolder] DEFAULT ('########'),
	[PlanNotes] [varchar] (7500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	CONSTRAINT [pkc_PartitionPlan__PlanName] 
        PRIMARY KEY  CLUSTERED 
	(
		[PlanName]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO