USE [Intranet]
GO
/****** Object:  Table [planogram].[Category]    Script Date: 04/15/2008 13:30:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [planogram].[Category](
	[CategoryID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_Category_CategoryID]  DEFAULT (newid()),
	[Name] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[GroupName] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 CONSTRAINT [PK_Category_1] PRIMARY KEY CLUSTERED 
(
	[CategoryID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [planogram].[ComplexCategory]    Script Date: 04/15/2008 13:30:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [planogram].[ComplexCategory](
	[ComplexCategoryID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_ComplexCategory_ComplexCategoryID]  DEFAULT (newid()),
	[CategoryID] [uniqueidentifier] NOT NULL,
	[SetAdjective] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 CONSTRAINT [PK_Table1] PRIMARY KEY CLUSTERED 
(
	[ComplexCategoryID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [planogram].[ComplexPogSet]    Script Date: 04/15/2008 13:30:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [planogram].[ComplexPogSet](
	[ComplexPogSetID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_ComplexPogSet_PogSetID]  DEFAULT (newid()),
	[PogSetID] [uniqueidentifier] NOT NULL,
	[ComplexCategoryID] [uniqueidentifier] NOT NULL,
 CONSTRAINT [PK_ComplexPogSet_1] PRIMARY KEY CLUSTERED 
(
	[ComplexPogSetID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [planogram].[ComplexPogSetItem]    Script Date: 04/15/2008 13:30:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [planogram].[ComplexPogSetItem](
	[POGSubSet_MM_ComplexPogSetID] [uniqueidentifier] NOT NULL,
	[ComplexPogSetID] [uniqueidentifier] NOT NULL,
	[PogSubSetID] [uniqueidentifier] NOT NULL,
	[Position] [int] NOT NULL,
 CONSTRAINT [PK_POGSubSet_MM_ComplexPogSet_1] PRIMARY KEY CLUSTERED 
(
	[POGSubSet_MM_ComplexPogSetID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [planogram].[PogSet]    Script Date: 04/15/2008 13:30:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [planogram].[PogSet](
	[PogSetID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_PogSet_PogSetID]  DEFAULT (newid()),
	[Name] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 CONSTRAINT [PK_PogSet_1] PRIMARY KEY CLUSTERED 
(
	[PogSetID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [planogram].[PogSet_MM_Store]    Script Date: 04/15/2008 13:30:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [planogram].[PogSet_MM_Store](
	[PogSet_MM_StoreID] [uniqueidentifier] NOT NULL,
	[PogSetID] [uniqueidentifier] NOT NULL,
	[StoreID] [uniqueidentifier] NOT NULL,
 CONSTRAINT [PK_POGSet_MM_Store_1] PRIMARY KEY CLUSTERED 
(
	[PogSet_MM_StoreID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [planogram].[PogSubSet]    Script Date: 04/15/2008 13:30:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [planogram].[PogSubSet](
	[PogSubSetID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_PogSubSet_PogSubSet]  DEFAULT (newid()),
	[ComplexCategoryID] [uniqueidentifier] NOT NULL,
	[Name] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[DocName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[DocType] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 CONSTRAINT [PK_PogSubSet_1] PRIMARY KEY CLUSTERED 
(
	[PogSubSetID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [planogram].[SimpleCategory]    Script Date: 04/15/2008 13:30:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [planogram].[SimpleCategory](
	[SimpleCategoryID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_SimpleCategory_SimpleCategoryID]  DEFAULT (newid()),
	[CategoryID] [uniqueidentifier] NOT NULL,
	[Selections] [int] NOT NULL,
 CONSTRAINT [PK_SimpleCategory] PRIMARY KEY CLUSTERED 
(
	[SimpleCategoryID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [planogram].[SimplePogSet]    Script Date: 04/15/2008 13:30:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [planogram].[SimplePogSet](
	[SimplePogSetID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_SimplePogSet_PogSetID]  DEFAULT (newid()),
	[PogSetID] [uniqueidentifier] NOT NULL,
	[SimpleCategoryID] [uniqueidentifier] NOT NULL,
	[DocName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[DocType] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[Global] [bit] NOT NULL,
 CONSTRAINT [PK_SimplePogSet_1] PRIMARY KEY CLUSTERED 
(
	[SimplePogSetID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
USE [Intranet]
GO
USE [Intranet]
GO
USE [Intranet]
GO
USE [Intranet]
GO
USE [Intranet]
GO
USE [Intranet]
GO
USE [Intranet]
GO
ALTER TABLE [planogram].[ComplexCategory]  WITH CHECK ADD  CONSTRAINT [FK_ComplexCategory_Category] FOREIGN KEY([CategoryID])
REFERENCES [planogram].[Category] ([CategoryID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [planogram].[ComplexCategory]  WITH CHECK ADD  CONSTRAINT [FK_ComplexCategory_ComplexPogSet] FOREIGN KEY([CategoryID])
REFERENCES [planogram].[ComplexPogSet] ([ComplexPogSetID])
GO
ALTER TABLE [planogram].[ComplexPogSet]  WITH CHECK ADD  CONSTRAINT [FK_ComplexPogSet_PogSet] FOREIGN KEY([PogSetID])
REFERENCES [planogram].[PogSet] ([PogSetID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [planogram].[ComplexPogSet]  WITH CHECK ADD  CONSTRAINT [FK_ComplexPogSet_POGSubSet_MM_ComplexPogSet] FOREIGN KEY([PogSetID])
REFERENCES [planogram].[ComplexPogSetItem] ([POGSubSet_MM_ComplexPogSetID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [planogram].[PogSet]  WITH CHECK ADD  CONSTRAINT [FK_PogSet_POGSet_MM_Store] FOREIGN KEY([PogSetID])
REFERENCES [planogram].[PogSet_MM_Store] ([PogSet_MM_StoreID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [planogram].[PogSet_MM_Store]  WITH CHECK ADD  CONSTRAINT [FK_POGSet_MM_Store_Store] FOREIGN KEY([StoreID])
REFERENCES [dbo].[Store] ([StoreID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [planogram].[PogSubSet]  WITH CHECK ADD  CONSTRAINT [FK_PogSubSet_ComplexCategory] FOREIGN KEY([ComplexCategoryID])
REFERENCES [planogram].[ComplexCategory] ([ComplexCategoryID])
GO
ALTER TABLE [planogram].[PogSubSet]  WITH CHECK ADD  CONSTRAINT [FK_PogSubSet_POGSubSet_MM_ComplexPogSet] FOREIGN KEY([ComplexCategoryID])
REFERENCES [planogram].[ComplexPogSetItem] ([POGSubSet_MM_ComplexPogSetID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [planogram].[SimpleCategory]  WITH CHECK ADD  CONSTRAINT [FK_SimpleCategory_Category] FOREIGN KEY([CategoryID])
REFERENCES [planogram].[Category] ([CategoryID])
GO
ALTER TABLE [planogram].[SimplePogSet]  WITH CHECK ADD  CONSTRAINT [FK_SimplePogSet_PogSet] FOREIGN KEY([PogSetID])
REFERENCES [planogram].[PogSet] ([PogSetID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [planogram].[SimplePogSet]  WITH CHECK ADD  CONSTRAINT [FK_SimplePogSet_SimpleCategory] FOREIGN KEY([SimpleCategoryID])
REFERENCES [planogram].[SimpleCategory] ([SimpleCategoryID])