1/**//****** BlogEngine.NET 1.3 SQL Setup Script ******/
  2/**//****** Object:  Table [dbo].[be_Categories]    Script Date: 12/22/2007 14:14:54 ******/
  3SET ANSI_NULLS ON
  4GO
  5SET QUOTED_IDENTIFIER ON
  6GO
  7CREATE TABLE [dbo].[be_Categories](
  8    [CategoryID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_be_Categories_CategoryID]  DEFAULT (newid()),
  9    [CategoryName] [nvarchar](50) NULL,
 10    [Description] [nvarchar](200) NULL,
 11 CONSTRAINT [PK_be_Categories] PRIMARY KEY CLUSTERED 
 12(
 13    [CategoryID] ASC
 14)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
 15) ON [PRIMARY]
 16GO
 17/**//****** Object:  Table [dbo].[be_Pages]    Script Date: 12/22/2007 14:15:17 ******/
 18SET ANSI_NULLS ON
 19GO
 20SET QUOTED_IDENTIFIER ON
 21GO
 22CREATE TABLE [dbo].[be_Pages](
 23    [PageID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_be_Pages_PageID]  DEFAULT (newid()),
 24    [Title] [nvarchar](255) NULL,
 25    [Description] [nvarchar](max) NULL,
 26    [PageContent] [ntext] NULL,
 27    [Keywords] [nvarchar](max) NULL,
 28    [DateCreated] [datetime] NULL,
 29    [DateModified] [datetime] NULL,
 30    [IsPublished] [bit] NULL,
 31    [IsFrontPage] [bit] NULL,
 32    [Parent] [uniqueidentifier] NULL,
 33    [ShowInList] [bit] NULL,
 34    [Slug] nvarchar](255) NULL,
 35 CONSTRAINT [PK_be_Pages] PRIMARY KEY CLUSTERED 
 36(
 37    [PageID] ASC
 38)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
 39) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
 40GO
 41/**//****** Object:  Table [dbo].[be_PingService]    Script Date: 12/22/2007 14:15:47 ******/
 42SET ANSI_NULLS ON
 43GO
 44SET QUOTED_IDENTIFIER ON
 45GO
 46CREATE TABLE [dbo].[be_PingService](
 47    [PingServiceID] [int] IDENTITY(1,1) NOT NULL,
 48    [Link] [nvarchar](255) NULL,
 49 CONSTRAINT [PK_be_PingService] PRIMARY KEY CLUSTERED 
 50(
 51    [PingServiceID] ASC
 52)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
 53) ON [PRIMARY]
 54GO
 55/**//****** Object:  Table [dbo].[be_Posts]    Script Date: 12/22/2007 14:16:27 ******/
 56SET ANSI_NULLS ON
 57GO
 58SET QUOTED_IDENTIFIER ON
 59GO
 60CREATE TABLE [dbo].[be_Posts](
 61    [PostID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_be_Posts_PostID]  DEFAULT (newid()),
 62    [Title] [nvarchar](255) NULL,
 63    [Description] [nvarchar](max) NULL,
 64    [PostContent] [ntext] NULL,
 65    [DateCreated] [datetime] NULL,
 66    [DateModified] [datetime] NULL,
 67    [Author] [nvarchar](50) NULL,
 68    [IsPublished] [bit] NULL,
 69    [IsCommentEnabled] [bit] NULL,
 70    [Raters] [int] NULL,
 71    [Rating] [real] NULL,
 72    [Slug] [nvarchar](255) NULL,
 73 CONSTRAINT [PK_be_Posts] PRIMARY KEY CLUSTERED 
 74(
 75    [PostID] ASC
 76)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
 77) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
 78GO
 79/**//****** Object:  Table [dbo].[be_Settings]    Script Date: 12/22/2007 14:16:07 ******/
 80SET ANSI_NULLS ON
 81GO
 82SET QUOTED_IDENTIFIER ON
 83GO
 84CREATE TABLE [dbo].[be_Settings](
 85    [SettingName] [nvarchar](50) NOT NULL,
 86    [SettingValue] [nvarchar](max) NULL,
 87 CONSTRAINT [PK_be_Settings] PRIMARY KEY CLUSTERED 
 88(
 89    [SettingName] ASC
 90)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
 91) ON [PRIMARY]
 92GO
 93/**//****** Object:  Table [dbo].[be_PostCategory]    Script Date: 12/22/2007 14:17:00 ******/
 94SET ANSI_NULLS ON
 95GO
 96SET QUOTED_IDENTIFIER ON
 97GO
 98CREATE TABLE [dbo].[be_PostCategory](
 99    [PostCategoryID] [int] IDENTITY(1,1) NOT NULL,
100    [PostID] [uniqueidentifier] NOT NULL,
101    [CategoryID] [uniqueidentifier] NOT NULL,
102 CONSTRAINT [PK_be_PostCategory] PRIMARY KEY CLUSTERED 
103(
104    [PostCategoryID] ASC
105)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
106) ON [PRIMARY]
107
108GO
109ALTER TABLE [dbo].[be_PostCategory]  WITH CHECK ADD  CONSTRAINT [FK_be_PostCategory_be_Categories] FOREIGN KEY([CategoryID])
110REFERENCES [dbo].[be_Categories] ([CategoryID])
111GO
112ALTER TABLE [dbo].[be_PostCategory] CHECK CONSTRAINT [FK_be_PostCategory_be_Categories]
113GO
114ALTER TABLE [dbo].[be_PostCategory]  WITH CHECK ADD  CONSTRAINT [FK_be_PostCategory_be_Posts] FOREIGN KEY([PostID])
115REFERENCES [dbo].[be_Posts] ([PostID])
116GO
117ALTER TABLE [dbo].[be_PostCategory] CHECK CONSTRAINT [FK_be_PostCategory_be_Posts]
118GO
119/**//****** Object:  Table [dbo].[be_PostComment]    Script Date: 12/22/2007 14:17:15 ******/
120SET ANSI_NULLS ON
121GO
122SET QUOTED_IDENTIFIER ON
123GO
124CREATE TABLE [dbo].[be_PostComment](
125    [PostCommentID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_be_PostComment_PostCommentID]  DEFAULT (newid()),
126    [PostID] [uniqueidentifier] NOT NULL,
127    [CommentDate] [datetime] NOT NULL,
128    [Author] [nvarchar](255) NULL,
129    [Email] [nvarchar](255) NULL,
130    [Website] [nvarchar](255) NULL,
131    [Comment] [nvarchar](max) NULL,
132    [Country] [nvarchar](255) NULL,
133    [Ip] [nvarchar](50) NULL,
134    [IsApproved] [bit] NULL,
135 CONSTRAINT [PK_be_PostComment] PRIMARY KEY CLUSTERED 
136(
137    [PostCommentID] ASC
138)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
139) ON [PRIMARY]
140
141GO
142ALTER TABLE [dbo].[be_PostComment]  WITH CHECK ADD  CONSTRAINT [FK_be_PostComment_be_Posts] FOREIGN KEY([PostID])
143REFERENCES [dbo].[be_Posts] ([PostID])
144GO
145ALTER TABLE [dbo].[be_PostComment] CHECK CONSTRAINT [FK_be_PostComment_be_Posts]
146GO
147/**//****** Object:  Table [dbo].[be_PostNotify]    Script Date: 12/22/2007 14:17:31 ******/
148SET ANSI_NULLS ON
149GO
150SET QUOTED_IDENTIFIER ON
151GO
152CREATE TABLE [dbo].[be_PostNotify](
153    [PostNotifyID] [int] IDENTITY(1,1) NOT NULL,
154    [PostID] [uniqueidentifier] NOT NULL,
155    [NotifyAddress] [nvarchar](255) NULL,
156 CONSTRAINT [PK_be_PostNotify] PRIMARY KEY CLUSTERED 
157(
158    [PostNotifyID] ASC
159)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
160) ON [PRIMARY]
161
162GO
163ALTER TABLE [dbo].[be_PostNotify]  WITH CHECK ADD  CONSTRAINT [FK_be_PostNotify_be_Posts] FOREIGN KEY([PostID])
164REFERENCES [dbo].[be_Posts] ([PostID])
165GO
166ALTER TABLE [dbo].[be_PostNotify] CHECK CONSTRAINT [FK_be_PostNotify_be_Posts]
167GO
168/**//****** Object:  Table [dbo].[be_PostTag]    Script Date: 12/22/2007 14:17:44 ******/
169SET ANSI_NULLS ON
170GO
171SET QUOTED_IDENTIFIER ON
172GO
173CREATE TABLE [dbo].[be_PostTag](
174    [PostTagID] [int] IDENTITY(1,1) NOT NULL,
175    [PostID] [uniqueidentifier] NOT NULL,
176    [Tag] [nvarchar](50) NULL,
177 CONSTRAINT [PK_be_PostTag] PRIMARY KEY CLUSTERED 
178(
179    [PostTagID] ASC
180)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
181) ON [PRIMARY]
182
183GO
184ALTER TABLE [dbo].[be_PostTag]  WITH CHECK ADD  CONSTRAINT [FK_be_PostTag_be_Posts] FOREIGN KEY([PostID])
185REFERENCES [dbo].[be_Posts] ([PostID])
186GO
187ALTER TABLE [dbo].[be_PostTag] CHECK CONSTRAINT [FK_be_PostTag_be_Posts]
188GO
189/**//****** Object:  Index [FK_PostID]    Script Date: 12/22/2007 14:18:36 ******/
190CREATE NONCLUSTERED INDEX [FK_PostID] ON [dbo].[be_PostCategory] 
191(
192    [PostID] ASC
193)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
194GO
195/**//****** Object:  Index [FK_CategoryID]    Script Date: 12/22/2007 14:19:19 ******/
196CREATE NONCLUSTERED INDEX [FK_CategoryID] ON [dbo].[be_PostCategory] 
197(
198    [CategoryID] ASC
199)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
200GO
201/**//****** Object:  Index [FK_PostID]    Script Date: 12/22/2007 14:19:45 ******/
202CREATE NONCLUSTERED INDEX [FK_PostID] ON [dbo].[be_PostComment] 
203(
204    [PostID] ASC
205)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
206GO
207/**//****** Object:  Index [FK_PostID]    Script Date: 12/22/2007 14:20:29 ******/
208CREATE NONCLUSTERED INDEX [