smallBusiness

/* * Create Table News * */ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[News]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[News]( [id] [nvarchar](32) NOT NULL, [visible] [bit] NOT NULL, [title] [nvarchar](256) NOT NULL, [date] [datetime] NOT NULL, [content] [nvarchar](4000) NULL, [imageUrl] [nvarchar](256) NULL, [imageAltText] [nvarchar](256) NULL, [displayOrder] [int] NULL, PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO /* * Create Table People * */ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[People]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[People]( [id] [nvarchar](32) NOT NULL, [visible] [bit] NOT NULL, [firstName] [nvarchar](64) NOT NULL, [middleName] [nvarchar](64) NULL, [lastName] [nvarchar](64) NOT NULL, [title] [nvarchar](128) NULL, [description] [nvarchar](2048) NULL, [email] [nvarchar](256) NULL, [phone] [nvarchar](64) NULL, [fax] [nvarchar](64) NULL, [streetAddress] [nvarchar](128) NULL, [city] [nvarchar](128) NULL, [state] [nvarchar](64) NULL, [postalCode] [nvarchar](64) NULL, [country] [nvarchar](64) NULL, [imageUrl] [nvarchar](256) NULL, [imageAltText] [nvarchar](256) NULL, [displayOrder] [int] NULL, PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO /* * Create Table Category * */ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Category]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Category]( [id] [nvarchar](32) NOT NULL, [visible] [bit] NOT NULL, [title] [nvarchar](256) NULL, [description] [nvarchar](2048) NULL, [imageUrl] [nvarchar](256) NULL, [imageAltText] [nvarchar](256) NULL, [parentCategoryId] [nvarchar](32) NULL, [displayOrder] [int] NULL, PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO /* * Create Table Item * */ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Item]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Item]( [id] [nvarchar](32) NOT NULL, [visible] [bit] NOT NULL, [title] [nvarchar](256) NOT NULL, [description] [nvarchar](2048) NULL, [price] [float] NULL, [inStock] [bit] NULL, [imageUrl] [nvarchar](256) NULL, [imageAltText] [nvarchar](256) NULL, [displayOrder] [int] NULL, PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO /* * Create Table Testimonails * */ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Testimonials]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Testimonials]( [id] [nvarchar](32) NOT NULL, [visible] [bit] NOT NULL, [title] [nvarchar](256) NOT NULL, [date] [datetime] NOT NULL, [content] [nvarchar](1024) NULL, [testifier] [nvarchar](256) NULL, [testifierTitle] [nvarchar](256) NULL, [testifierCompany] [nvarchar](256) NULL, [imageUrl] [nvarchar](256) NULL, [imageAltText] [nvarchar](256) NULL, [displayOrder] [int] NULL, PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO /* * Create Table Categorization * */ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Categorization]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Categorization]( [itemId] [nvarchar](32) NOT NULL, [parentCategoryId] [nvarchar](32) NOT NULL, PRIMARY KEY CLUSTERED ( [itemId] ASC, [pare�