PageRenderTime 107ms CodeModel.GetById 14ms app.highlight 86ms RepoModel.GetById 2ms app.codeStats 0ms

/BlogEngine/BlogEngine.NET/setup/SQLServer/MSSQLSetup1.6.0.0.sql

#
SQL | 608 lines | 565 code | 19 blank | 24 comment | 0 complexity | cc88b686cad4e742d2389922b3bb669f MD5 | raw file
  1/****** BlogEngine.NET 1.6 SQL Setup Script ******/
  2
  3/****** Object:  Table [dbo].[be_Categories]    Script Date: 12/22/2007 14:14:54 ******/
  4SET ANSI_NULLS ON
  5GO
  6SET QUOTED_IDENTIFIER ON
  7GO
  8CREATE TABLE [dbo].[be_Categories](
  9	[CategoryID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_be_Categories_CategoryID]  DEFAULT (newid()),
 10	[CategoryName] [nvarchar](50) NULL,
 11	[Description] [nvarchar](200) NULL,
 12	[ParentID] [uniqueidentifier] NULL,
 13 CONSTRAINT [PK_be_Categories] PRIMARY KEY CLUSTERED 
 14(
 15	[CategoryID] ASC
 16)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
 17) ON [PRIMARY]
 18GO
 19/****** Object:  Table [dbo].[be_DataStoreSettings]    Script Date: 06/28/2008 19:29:31 ******/
 20SET ANSI_NULLS ON
 21GO
 22SET QUOTED_IDENTIFIER ON
 23GO
 24SET ANSI_PADDING ON
 25GO
 26CREATE TABLE [dbo].[be_DataStoreSettings](
 27	[ExtensionType] [nvarchar](50) NOT NULL,
 28	[ExtensionId] [nvarchar](100) NOT NULL,
 29	[Settings] [nvarchar](max) NOT NULL
 30) ON [PRIMARY]
 31
 32GO
 33/****** Object:  Table [dbo].[be_Pages]    Script Date: 12/22/2007 14:15:17 ******/
 34SET ANSI_NULLS ON
 35GO
 36SET QUOTED_IDENTIFIER ON
 37GO
 38CREATE TABLE [dbo].[be_Pages](
 39	[PageID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_be_Pages_PageID]  DEFAULT (newid()),
 40	[Title] [nvarchar](255) NULL,
 41	[Description] [nvarchar](max) NULL,
 42	[PageContent] [nvarchar](max) NULL,
 43	[Keywords] [nvarchar](max) NULL,
 44	[DateCreated] [datetime] NULL,
 45	[DateModified] [datetime] NULL,
 46	[IsPublished] [bit] NULL,
 47	[IsFrontPage] [bit] NULL,
 48	[Parent] [uniqueidentifier] NULL,
 49	[ShowInList] [bit] NULL,
 50	[Slug] [nvarchar](255) NULL,
 51 CONSTRAINT [PK_be_Pages] PRIMARY KEY CLUSTERED 
 52(
 53	[PageID] ASC
 54)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
 55) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
 56GO
 57/****** Object:  Table [dbo].[be_PingService]    Script Date: 12/22/2007 14:15:47 ******/
 58SET ANSI_NULLS ON
 59GO
 60SET QUOTED_IDENTIFIER ON
 61GO
 62CREATE TABLE [dbo].[be_PingService](
 63	[PingServiceID] [int] IDENTITY(1,1) NOT NULL,
 64	[Link] [nvarchar](255) NULL,
 65 CONSTRAINT [PK_be_PingService] PRIMARY KEY CLUSTERED 
 66(
 67	[PingServiceID] ASC
 68)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
 69) ON [PRIMARY]
 70GO
 71/****** Object:  Table [dbo].[be_Posts]    Script Date: 12/22/2007 14:16:27 ******/
 72SET ANSI_NULLS ON
 73GO
 74SET QUOTED_IDENTIFIER ON
 75GO
 76CREATE TABLE [dbo].[be_Posts](
 77	[PostID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_be_Posts_PostID]  DEFAULT (newid()),
 78	[Title] [nvarchar](255) NULL,
 79	[Description] [nvarchar](max) NULL,
 80	[PostContent] [nvarchar](max) NULL,
 81	[DateCreated] [datetime] NULL,
 82	[DateModified] [datetime] NULL,
 83	[Author] [nvarchar](50) NULL,
 84	[IsPublished] [bit] NULL,
 85	[IsCommentEnabled] [bit] NULL,
 86	[Raters] [int] NULL,
 87	[Rating] [real] NULL,
 88	[Slug] [nvarchar](255) NULL,
 89 CONSTRAINT [PK_be_Posts] PRIMARY KEY CLUSTERED 
 90(
 91	[PostID] ASC
 92)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
 93) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
 94GO
 95/****** Object:  Table [dbo].[be_Settings]    Script Date: 12/22/2007 14:16:07 ******/
 96SET ANSI_NULLS ON
 97GO
 98SET QUOTED_IDENTIFIER ON
 99GO
100CREATE TABLE [dbo].[be_Settings](
101	[SettingName] [nvarchar](50) NOT NULL,
102	[SettingValue] [nvarchar](max) NULL,
103 CONSTRAINT [PK_be_Settings] PRIMARY KEY CLUSTERED 
104(
105	[SettingName] ASC
106)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
107) ON [PRIMARY]
108GO
109/****** Object:  Table [dbo].[be_Profiles]    Script Date: 06/28/2008 19:33:41 ******/
110SET ANSI_NULLS ON
111GO
112SET QUOTED_IDENTIFIER ON
113GO
114CREATE TABLE [dbo].[be_Profiles](
115	[ProfileID] [int] IDENTITY(1,1) NOT NULL,
116	[UserName] [nvarchar](100) NULL,
117	[SettingName] [nvarchar](200) NULL,
118	[SettingValue] [nvarchar](max) NULL,
119 CONSTRAINT [PK_be_Profiles] PRIMARY KEY CLUSTERED 
120(
121	[ProfileID] ASC
122)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
123) ON [PRIMARY]
124GO
125/****** Object:  Table [dbo].[be_StopWords]    Script Date: 06/28/2008 19:33:32 ******/
126SET ANSI_NULLS ON
127GO
128SET QUOTED_IDENTIFIER ON
129GO
130CREATE TABLE [dbo].[be_StopWords](
131	[StopWord] [nvarchar](50) NOT NULL,
132 CONSTRAINT [PK_be_StopWords] PRIMARY KEY CLUSTERED 
133(
134	[StopWord] ASC
135)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
136) ON [PRIMARY]
137GO
138/****** Object:  Table [dbo].[be_PostCategory]    Script Date: 12/22/2007 14:17:00 ******/
139SET ANSI_NULLS ON
140GO
141SET QUOTED_IDENTIFIER ON
142GO
143CREATE TABLE [dbo].[be_PostCategory](
144	[PostCategoryID] [int] IDENTITY(1,1) NOT NULL,
145	[PostID] [uniqueidentifier] NOT NULL,
146	[CategoryID] [uniqueidentifier] NOT NULL,
147 CONSTRAINT [PK_be_PostCategory] PRIMARY KEY CLUSTERED 
148(
149	[PostCategoryID] ASC
150)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
151) ON [PRIMARY]
152
153GO
154ALTER TABLE [dbo].[be_PostCategory]  WITH CHECK ADD  CONSTRAINT [FK_be_PostCategory_be_Categories] FOREIGN KEY([CategoryID])
155REFERENCES [dbo].[be_Categories] ([CategoryID])
156GO
157ALTER TABLE [dbo].[be_PostCategory] CHECK CONSTRAINT [FK_be_PostCategory_be_Categories]
158GO
159ALTER TABLE [dbo].[be_PostCategory]  WITH CHECK ADD  CONSTRAINT [FK_be_PostCategory_be_Posts] FOREIGN KEY([PostID])
160REFERENCES [dbo].[be_Posts] ([PostID])
161GO
162ALTER TABLE [dbo].[be_PostCategory] CHECK CONSTRAINT [FK_be_PostCategory_be_Posts]
163GO
164/****** Object:  Table [dbo].[be_PostComment]    Script Date: 12/22/2007 14:17:15 ******/
165SET ANSI_NULLS ON
166GO
167SET QUOTED_IDENTIFIER ON
168GO
169CREATE TABLE [dbo].[be_PostComment](
170	[PostCommentID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_be_PostComment_PostCommentID]  DEFAULT (newid()),
171	[PostID] [uniqueidentifier] NOT NULL,
172	[ParentCommentID] [uniqueidentifier] NOT NULL DEFAULT ('00000000-0000-0000-0000-000000000000'),
173	[CommentDate] [datetime] NOT NULL,
174	[Author] [nvarchar](255) NULL,
175	[Email] [nvarchar](255) NULL,
176	[Website] [nvarchar](255) NULL,
177	[Comment] [nvarchar](max) NULL,
178	[Country] [nvarchar](255) NULL,
179	[Ip] [nvarchar](50) NULL,
180	[IsApproved] [bit] NULL,
181	[ModeratedBy] [nvarchar](100) NULL,
182	[Avatar] [nvarchar](255) NULL,
183 CONSTRAINT [PK_be_PostComment] PRIMARY KEY CLUSTERED 
184(
185	[PostCommentID] ASC
186)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
187) ON [PRIMARY]
188
189GO
190ALTER TABLE [dbo].[be_PostComment]  WITH CHECK ADD  CONSTRAINT [FK_be_PostComment_be_Posts] FOREIGN KEY([PostID])
191REFERENCES [dbo].[be_Posts] ([PostID])
192GO
193ALTER TABLE [dbo].[be_PostComment] CHECK CONSTRAINT [FK_be_PostComment_be_Posts]
194GO
195/****** Object:  Table [dbo].[be_PostNotify]    Script Date: 12/22/2007 14:17:31 ******/
196SET ANSI_NULLS ON
197GO
198SET QUOTED_IDENTIFIER ON
199GO
200CREATE TABLE [dbo].[be_PostNotify](
201	[PostNotifyID] [int] IDENTITY(1,1) NOT NULL,
202	[PostID] [uniqueidentifier] NOT NULL,
203	[NotifyAddress] [nvarchar](255) NULL,
204 CONSTRAINT [PK_be_PostNotify] PRIMARY KEY CLUSTERED 
205(
206	[PostNotifyID] ASC
207)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
208) ON [PRIMARY]
209
210GO
211ALTER TABLE [dbo].[be_PostNotify]  WITH CHECK ADD  CONSTRAINT [FK_be_PostNotify_be_Posts] FOREIGN KEY([PostID])
212REFERENCES [dbo].[be_Posts] ([PostID])
213GO
214ALTER TABLE [dbo].[be_PostNotify] CHECK CONSTRAINT [FK_be_PostNotify_be_Posts]
215GO
216/****** Object:  Table [dbo].[be_PostTag]    Script Date: 12/22/2007 14:17:44 ******/
217SET ANSI_NULLS ON
218GO
219SET QUOTED_IDENTIFIER ON
220GO
221CREATE TABLE [dbo].[be_PostTag](
222	[PostTagID] [int] IDENTITY(1,1) NOT NULL,
223	[PostID] [uniqueidentifier] NOT NULL,
224	[Tag] [nvarchar](50) NULL,
225 CONSTRAINT [PK_be_PostTag] PRIMARY KEY CLUSTERED 
226(
227	[PostTagID] ASC
228)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
229) ON [PRIMARY]
230
231GO
232ALTER TABLE [dbo].[be_PostTag]  WITH CHECK ADD  CONSTRAINT [FK_be_PostTag_be_Posts] FOREIGN KEY([PostID])
233REFERENCES [dbo].[be_Posts] ([PostID])
234GO
235ALTER TABLE [dbo].[be_PostTag] CHECK CONSTRAINT [FK_be_PostTag_be_Posts]
236GO
237/****** Object:  Table [dbo].[be_Users]    Script Date: 07/30/2008 21:55:28 ******/
238SET ANSI_NULLS ON
239GO
240SET QUOTED_IDENTIFIER ON
241GO
242CREATE TABLE [dbo].[be_Users](
243	[UserID] [int] IDENTITY(1,1) NOT NULL,
244	[UserName] [nvarchar](100) NOT NULL,
245	[Password] [nvarchar](255) NOT NULL,
246	[LastLoginTime] [datetime] NULL,
247	[EmailAddress] [nvarchar](100) NULL,
248 CONSTRAINT [PK_be_Users] PRIMARY KEY CLUSTERED 
249(
250	[UserID] ASC
251)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
252) ON [PRIMARY]
253GO
254/****** Object:  Table [dbo].[be_Roles]    Script Date: 07/30/2008 21:56:59 ******/
255SET ANSI_NULLS ON
256GO
257SET QUOTED_IDENTIFIER ON
258GO
259CREATE TABLE [dbo].[be_Roles](
260	[RoleID] [int] IDENTITY(1,1) NOT NULL,
261	[Role] [nvarchar](100) NOT NULL,
262 CONSTRAINT [PK_be_Roles] PRIMARY KEY CLUSTERED 
263(
264	[RoleID] ASC
265)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
266) ON [PRIMARY]
267GO
268/****** Object:  Table [dbo].[be_UserRoles]    Script Date: 07/31/2008 12:26:45 ******/
269SET ANSI_NULLS ON
270GO
271SET QUOTED_IDENTIFIER ON
272GO
273CREATE TABLE [dbo].[be_UserRoles](
274	[UserRoleID] [int] IDENTITY(1,1) NOT NULL,
275	[UserID] [int] NOT NULL,
276	[RoleID] [int] NOT NULL,
277 CONSTRAINT [PK_be_UserRoles] PRIMARY KEY CLUSTERED 
278(
279	[UserRoleID] ASC
280)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
281) ON [PRIMARY]
282
283GO
284ALTER TABLE [dbo].[be_UserRoles]  WITH CHECK ADD  CONSTRAINT [FK_be_UserRoles_be_Roles] FOREIGN KEY([RoleID])
285REFERENCES [dbo].[be_Roles] ([RoleID])
286GO
287ALTER TABLE [dbo].[be_UserRoles] CHECK CONSTRAINT [FK_be_UserRoles_be_Roles]
288GO
289ALTER TABLE [dbo].[be_UserRoles]  WITH CHECK ADD  CONSTRAINT [FK_be_UserRoles_be_Users] FOREIGN KEY([UserID])
290REFERENCES [dbo].[be_Users] ([UserID])
291GO
292ALTER TABLE [dbo].[be_UserRoles] CHECK CONSTRAINT [FK_be_UserRoles_be_Users]
293GO
294CREATE TABLE [dbo].[be_BlogRollItems](
295	[BlogRollId] [uniqueidentifier] NOT NULL,
296	[Title] [nvarchar](255) NOT NULL,
297	[Description] [nvarchar](max) NULL,
298	[BlogUrl] [varchar](255) NOT NULL,
299	[FeedUrl] [varchar](255) NULL,
300	[Xfn] [varchar](255) NULL,
301	[SortIndex] [int] NOT NULL,
302 CONSTRAINT [PK_be_BlogRollItems] PRIMARY KEY CLUSTERED 
303(
304	[BlogRollId] ASC
305)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
306) ON [PRIMARY]
307GO
308CREATE TABLE [dbo].[be_Referrers](
309	[ReferrerId] [uniqueidentifier] NOT NULL,
310	[ReferralDay] [datetime] NOT NULL CONSTRAINT [DF_be_Referrers_Day]  DEFAULT (getdate()),
311	[ReferrerUrl] [varchar](255) NOT NULL,
312	[ReferralCount] [int] NOT NULL,
313	[Url] [varchar](255) NULL,
314	[IsSpam] [bit] NULL,
315 CONSTRAINT [PK_be_Referrers] PRIMARY KEY CLUSTERED 
316(
317	[ReferrerId] ASC
318)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
319) ON [PRIMARY]
320GO
321
322/****** Object:  Index [FK_PostID]    Script Date: 12/22/2007 14:18:36 ******/
323CREATE NONCLUSTERED INDEX [FK_PostID] ON [dbo].[be_PostCategory] 
324(
325	[PostID] ASC
326)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]
327GO
328/****** Object:  Index [FK_CategoryID]    Script Date: 12/22/2007 14:19:19 ******/
329CREATE NONCLUSTERED INDEX [FK_CategoryID] ON [dbo].[be_PostCategory] 
330(
331	[CategoryID] ASC
332)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]
333GO
334/****** Object:  Index [FK_PostID]    Script Date: 12/22/2007 14:19:45 ******/
335CREATE NONCLUSTERED INDEX [FK_PostID] ON [dbo].[be_PostComment] 
336(
337	[PostID] ASC
338)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]
339GO
340/****** Object:  Index [FK_PostID]    Script Date: 12/22/2007 14:20:29 ******/
341CREATE NONCLUSTERED INDEX [FK_PostID] ON [dbo].[be_PostNotify] 
342(
343	[PostID] ASC
344)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]
345GO
346/****** Object:  Index [FK_PostID]    Script Date: 12/22/2007 14:20:43 ******/
347CREATE NONCLUSTERED INDEX [FK_PostID] ON [dbo].[be_PostTag] 
348(
349	[PostID] ASC
350)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]
351GO
352/****** Object:  Index [I_TypeID]    Script Date: 06/28/2008 19:34:43 ******/
353CREATE NONCLUSTERED INDEX [I_TypeID] ON [dbo].[be_DataStoreSettings] 
354(
355	[ExtensionType] ASC,
356	[ExtensionId] ASC
357)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]
358GO
359/****** Object:  Index [I_UserName]    Script Date: 06/28/2008 19:35:12 ******/
360CREATE NONCLUSTERED INDEX [I_UserName] ON [dbo].[be_Profiles] 
361(
362	[UserName] ASC
363)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]
364GO
365/***  Load initial Data ***/
366INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('administratorrole', 'Administrators');
367INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('alternatefeedurl', '');
368INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('authorname', 'My name');
369INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('avatar', 'combine');
370INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('blogrollmaxlength', '23');
371INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('blogrollupdateminutes', '60');
372INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('blogrollvisibleposts', '3');
373INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('contactformmessage', '<p>I will answer the mail as soon as I can.</p>');
374INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('contactthankmessage', '<h1>Thank you</h1><p>The message was sent.</p>');
375INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('culture', 'Auto');
376INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('dayscommentsareenabled', '0');
377INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('description', 'Short description of the blog');
378INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('displaycommentsonrecentposts', 'True');
379INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('displayratingsonrecentposts', 'True');
380INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('email', 'user@example.com');
381INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('emailsubjectprefix', 'Weblog');
382INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablecommentsearch', 'True');
383INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablecommentsmoderation', 'False');
384INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablecontactattachments', 'True');
385INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablecountryincomments', 'True');
386INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablehttpcompression', 'True');
387INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enableopensearch', 'True');
388INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablepingbackreceive', 'True');
389INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablepingbacksend', 'True');
390INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablerating', 'True');
391INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablereferrertracking', 'False');
392INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablerelatedposts', 'True');
393INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablessl', 'False');
394INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enabletrackbackreceive', 'True');
395INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enabletrackbacksend', 'True');
396INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('endorsement', 'http://www.dotnetblogengine.net/syndication.axd');
397INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('fileextension', '.aspx');
398INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('geocodinglatitude', '0');
399INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('geocodinglongitude', '0');
400INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('handlewwwsubdomain', '');
401INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('iscocommentenabled', 'False');
402INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('iscommentsenabled', 'True');
403INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('language', 'en-GB');
404INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('mobiletheme', 'Mobile');
405INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('name', 'Name of the blog');
406INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('numberofrecentcomments', '10');
407INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('numberofrecentposts', '10');
408INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('postsperfeed', '10');
409INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('postsperpage', '10');
410INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('removewhitespaceinstylesheets', 'True');
411INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('searchbuttontext', 'Search');
412INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('searchcommentlabeltext', 'Include comments in search');
413INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('searchdefaulttext', 'Enter search term');
414INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('sendmailoncomment', 'True');
415INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('showdescriptioninpostlist', 'False');
416INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('showlivepreview', 'True');
417INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('showpostnavigation', 'True');
418INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('smtppassword', 'password');
419INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('smtpserver', 'mail.example.dk');
420INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('smtpserverport', '25');
421INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('smtpusername', 'user@example.com');
422INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('storagelocation', '~/App_Data/');
423INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('syndicationformat', 'Rss');
424INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('theme', 'Standard');
425INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('timestamppostlinks', 'True');
426INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('timezone', '-5');
427INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('trackingscript', '');
428
429INSERT INTO be_PingService (Link) VALUES ('http://rpc.technorati.com/rpc/ping');
430INSERT INTO be_PingService (Link) VALUES ('http://rpc.pingomatic.com/rpc2');
431INSERT INTO be_PingService (Link) VALUES ('http://ping.feedburner.com');
432INSERT INTO be_PingService (Link) VALUES ('http://www.bloglines.com/ping');
433INSERT INTO be_PingService (Link) VALUES ('http://services.newsgator.com/ngws/xmlrpcping.aspx');
434INSERT INTO be_PingService (Link) VALUES ('http://api.my.yahoo.com/rpc2 ');
435INSERT INTO be_PingService (Link) VALUES ('http://blogsearch.google.com/ping/RPC2');
436INSERT INTO be_PingService (Link) VALUES ('http://rpc.pingthesemanticweb.com/');
437
438INSERT INTO be_StopWords (StopWord)	VALUES ('a');
439INSERT INTO be_StopWords (StopWord)	VALUES ('about');
440INSERT INTO be_StopWords (StopWord)	VALUES ('actually');
441INSERT INTO be_StopWords (StopWord)	VALUES ('add');
442INSERT INTO be_StopWords (StopWord)	VALUES ('after');
443INSERT INTO be_StopWords (StopWord)	VALUES ('all');
444INSERT INTO be_StopWords (StopWord)	VALUES ('almost');
445INSERT INTO be_StopWords (StopWord)	VALUES ('along');
446INSERT INTO be_StopWords (StopWord)	VALUES ('also');
447INSERT INTO be_StopWords (StopWord)	VALUES ('an');
448INSERT INTO be_StopWords (StopWord)	VALUES ('and');
449INSERT INTO be_StopWords (StopWord)	VALUES ('any');
450INSERT INTO be_StopWords (StopWord)	VALUES ('are');
451INSERT INTO be_StopWords (StopWord)	VALUES ('as');
452INSERT INTO be_StopWords (StopWord)	VALUES ('at');
453INSERT INTO be_StopWords (StopWord)	VALUES ('be');
454INSERT INTO be_StopWords (StopWord)	VALUES ('both');
455INSERT INTO be_StopWords (StopWord)	VALUES ('but');
456INSERT INTO be_StopWords (StopWord)	VALUES ('by');
457INSERT INTO be_StopWords (StopWord)	VALUES ('can');
458INSERT INTO be_StopWords (StopWord)	VALUES ('cannot');
459INSERT INTO be_StopWords (StopWord)	VALUES ('com');
460INSERT INTO be_StopWords (StopWord)	VALUES ('could');
461INSERT INTO be_StopWords (StopWord)	VALUES ('de');
462INSERT INTO be_StopWords (StopWord)	VALUES ('do');
463INSERT INTO be_StopWords (StopWord)	VALUES ('down');
464INSERT INTO be_StopWords (StopWord)	VALUES ('each');
465INSERT INTO be_StopWords (StopWord)	VALUES ('either');
466INSERT INTO be_StopWords (StopWord)	VALUES ('en');
467INSERT INTO be_StopWords (StopWord)	VALUES ('for');
468INSERT INTO be_StopWords (StopWord)	VALUES ('from');
469INSERT INTO be_StopWords (StopWord)	VALUES ('good');
470INSERT INTO be_StopWords (StopWord)	VALUES ('has');
471INSERT INTO be_StopWords (StopWord)	VALUES ('have');
472INSERT INTO be_StopWords (StopWord)	VALUES ('he');
473INSERT INTO be_StopWords (StopWord)	VALUES ('her');
474INSERT INTO be_StopWords (StopWord)	VALUES ('here');
475INSERT INTO be_StopWords (StopWord)	VALUES ('hers');
476INSERT INTO be_StopWords (StopWord)	VALUES ('his');
477INSERT INTO be_StopWords (StopWord)	VALUES ('how');
478INSERT INTO be_StopWords (StopWord)	VALUES ('i');
479INSERT INTO be_StopWords (StopWord)	VALUES ('if');
480INSERT INTO be_StopWords (StopWord)	VALUES ('in');
481INSERT INTO be_StopWords (StopWord)	VALUES ('into');
482INSERT INTO be_StopWords (StopWord)	VALUES ('is');
483INSERT INTO be_StopWords (StopWord)	VALUES ('it');
484INSERT INTO be_StopWords (StopWord)	VALUES ('its');
485INSERT INTO be_StopWords (StopWord)	VALUES ('just');
486INSERT INTO be_StopWords (StopWord)	VALUES ('la');
487INSERT INTO be_StopWords (StopWord)	VALUES ('like');
488INSERT INTO be_StopWords (StopWord)	VALUES ('long');
489INSERT INTO be_StopWords (StopWord)	VALUES ('make');
490INSERT INTO be_StopWords (StopWord)	VALUES ('me');
491INSERT INTO be_StopWords (StopWord)	VALUES ('more');
492INSERT INTO be_StopWords (StopWord)	VALUES ('much');
493INSERT INTO be_StopWords (StopWord)	VALUES ('my');
494INSERT INTO be_StopWords (StopWord)	VALUES ('need');
495INSERT INTO be_StopWords (StopWord)	VALUES ('new');
496INSERT INTO be_StopWords (StopWord)	VALUES ('now');
497INSERT INTO be_StopWords (StopWord)	VALUES ('of');
498INSERT INTO be_StopWords (StopWord)	VALUES ('off');
499INSERT INTO be_StopWords (StopWord)	VALUES ('on');
500INSERT INTO be_StopWords (StopWord)	VALUES ('once');
501INSERT INTO be_StopWords (StopWord)	VALUES ('one');
502INSERT INTO be_StopWords (StopWord)	VALUES ('ones');
503INSERT INTO be_StopWords (StopWord)	VALUES ('only');
504INSERT INTO be_StopWords (StopWord)	VALUES ('or');
505INSERT INTO be_StopWords (StopWord)	VALUES ('our');
506INSERT INTO be_StopWords (StopWord)	VALUES ('out');
507INSERT INTO be_StopWords (StopWord)	VALUES ('over');
508INSERT INTO be_StopWords (StopWord)	VALUES ('own');
509INSERT INTO be_StopWords (StopWord)	VALUES ('really');
510INSERT INTO be_StopWords (StopWord)	VALUES ('right');
511INSERT INTO be_StopWords (StopWord)	VALUES ('same');
512INSERT INTO be_StopWords (StopWord)	VALUES ('see');
513INSERT INTO be_StopWords (StopWord)	VALUES ('she');
514INSERT INTO be_StopWords (StopWord)	VALUES ('so');
515INSERT INTO be_StopWords (StopWord)	VALUES ('some');
516INSERT INTO be_StopWords (StopWord)	VALUES ('such');
517INSERT INTO be_StopWords (StopWord)	VALUES ('take');
518INSERT INTO be_StopWords (StopWord)	VALUES ('takes');
519INSERT INTO be_StopWords (StopWord)	VALUES ('that');
520INSERT INTO be_StopWords (StopWord)	VALUES ('the');
521INSERT INTO be_StopWords (StopWord)	VALUES ('their');
522INSERT INTO be_StopWords (StopWord)	VALUES ('these');
523INSERT INTO be_StopWords (StopWord)	VALUES ('thing');
524INSERT INTO be_StopWords (StopWord)	VALUES ('this');
525INSERT INTO be_StopWords (StopWord)	VALUES ('to');
526INSERT INTO be_StopWords (StopWord)	VALUES ('too');
527INSERT INTO be_StopWords (StopWord)	VALUES ('took');
528INSERT INTO be_StopWords (StopWord)	VALUES ('und');
529INSERT INTO be_StopWords (StopWord)	VALUES ('up');
530INSERT INTO be_StopWords (StopWord)	VALUES ('use');
531INSERT INTO be_StopWords (StopWord)	VALUES ('used');
532INSERT INTO be_StopWords (StopWord)	VALUES ('using');
533INSERT INTO be_StopWords (StopWord)	VALUES ('very');
534INSERT INTO be_StopWords (StopWord)	VALUES ('was');
535INSERT INTO be_StopWords (StopWord)	VALUES ('we');
536INSERT INTO be_StopWords (StopWord)	VALUES ('well');
537INSERT INTO be_StopWords (StopWord)	VALUES ('what');
538INSERT INTO be_StopWords (StopWord)	VALUES ('when');
539INSERT INTO be_StopWords (StopWord)	VALUES ('where');
540INSERT INTO be_StopWords (StopWord)	VALUES ('who');
541INSERT INTO be_StopWords (StopWord)	VALUES ('will');
542INSERT INTO be_StopWords (StopWord)	VALUES ('with');
543INSERT INTO be_StopWords (StopWord)	VALUES ('www');
544INSERT INTO be_StopWords (StopWord)	VALUES ('you');
545INSERT INTO be_StopWords (StopWord)	VALUES ('your');
546
547INSERT INTO be_BlogRollItems ( BlogRollId, Title, [Description], BlogUrl, FeedUrl, Xfn, SortIndex )
548VALUES ( '25e4d8da-3278-4e58-b0bf-932496dabc96', 'Mads Kristensen', 'Full featured simplicity in ASP.NET and C#', 'http://madskristensen.net', 'http://feeds.feedburner.com/netslave', 'contact', 0 );
549INSERT INTO be_BlogRollItems ( BlogRollId, Title, [Description], BlogUrl, FeedUrl, Xfn, SortIndex )
550VALUES ( 'ccc817ef-e760-482b-b82f-a6854663110f', 'Al Nyveldt', 'Adventures in Code and Other Stories', 'http://www.nyveldt.com/blog/', 'http://feeds.feedburner.com/razorant', 'contact', 1 );
551INSERT INTO be_BlogRollItems ( BlogRollId, Title, [Description], BlogUrl, FeedUrl, Xfn, SortIndex )
552VALUES ( 'dcdaa78b-0b77-4691-99f0-1bb6418945a1', 'Ruslan Tur', '.NET and Open Source: better together', 'http://rtur.net/blog/', 'http://feeds.feedburner.com/rtur', 'contact', 2 );
553INSERT INTO be_BlogRollItems ( BlogRollId, Title, [Description], BlogUrl, FeedUrl, Xfn, SortIndex )
554VALUES ( '8a846489-b69e-4fde-b2b2-53bc6104a6fa', 'John Dyer', 'Technology and web development in ASP.NET, Flash, and JavaScript', 'http://johndyer.name/', 'http://johndyer.name/syndication.axd', 'contact', 3 );
555INSERT INTO be_BlogRollItems ( BlogRollId, Title, [Description], BlogUrl, FeedUrl, Xfn, SortIndex )
556VALUES ( '7f906880-4316-47f1-a934-1a912fc02f8b', 'Russell van der Walt', 'an adventure in web technologies', 'http://blog.ruski.co.za/', 'http://feeds.feedburner.com/rusvdw', 'contact', 4 );
557INSERT INTO be_BlogRollItems ( BlogRollId, Title, [Description], BlogUrl, FeedUrl, Xfn, SortIndex )
558VALUES ( '890f00e5-3a86-4cba-b85b-104063964a87', 'Ben Amada', 'adventures in application development', 'http://allben.net/', 'http://feeds.feedburner.com/allben', 'contact', 5 );
559
560DECLARE @postID uniqueidentifier, @catID uniqueidentifier;
561
562SET @postID = NEWID();
563SET @catID = NEWID();
564
565INSERT INTO be_Categories (CategoryID, CategoryName)
566	VALUES (@catID, 'General');
567
568INSERT INTO be_Posts (PostID, Title, Description, PostContent, DateCreated, Author, IsPublished)
569	VALUES (@postID, 
570	'Welcome to BlogEngine.NET 1.6 using Microsoft SQL Server', 
571	'The description is used as the meta description as well as shown in the related posts. It is recommended that you write a description, but not mandatory',
572	'<p>If you see this post it means that BlogEngine.NET 1.6 is running with SQL Server and the DbBlogProvider is configured correctly.</p>
573	<h2>Setup</h2>
574	<p>If you are using the ASP.NET Membership provider, you are set to use existing users.  If you are using the default BlogEngine.NET XML provider, it is time to setup some users.  Find the sign-in link located either at the bottom or top of the page depending on your current theme and click it. Now enter "admin" in both the username and password fields and click the button. You will now see an admin menu appear. It has a link to the "Users" admin page. From there you can change the username and password.</p>
575	<h2>Write permissions</h2>
576	<p>Since you are using SQL to store your posts, most information is stored there.  However, if you want to store attachments or images in the blog, you will want write permissions setup on the App_Data folder.</p>
577	<h2>On the web </h2>
578	<p>You can find BlogEngine.NET on the <a href="http://www.dotnetblogengine.net">official website</a>. Here you will find tutorials, documentation, tips and tricks and much more. The ongoing development of BlogEngine.NET can be followed at <a href="http://blogengine.codeplex.com/">CodePlex</a> where the daily builds will be published for anyone to download.</p>
579	<p>Good luck and happy writing.</p>
580	<p>The BlogEngine.NET team</p>',
581	GETDATE(), 
582	'admin',
583	1);
584
585INSERT INTO be_PostCategory (PostID, CategoryID)
586	VALUES (@postID, @catID);
587INSERT INTO be_PostTag (PostID, Tag)
588	VALUES (@postID, 'blog');
589INSERT INTO be_PostTag (PostID, Tag)
590	VALUES (@postID, 'welcome');
591
592INSERT INTO be_Users (UserName, Password, LastLoginTime, EmailAddress)
593	VALUES ('Admin', '', GETDATE(), 'email@example.com');
594INSERT INTO be_Roles (Role) 
595	VALUES ('Administrators');
596INSERT INTO be_Roles (Role) 
597	VALUES ('Editors');
598INSERT INTO be_UserRoles (UserID, RoleID)
599VALUES (1, 1);
600
601INSERT INTO be_DataStoreSettings (ExtensionType, ExtensionId, Settings)
602VALUES (1, 'be_WIDGET_ZONE', 
603'<?xml version="1.0" encoding="utf-16"?>
604<WidgetData xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
605  <Settings>&lt;widgets&gt;&lt;widget id="d9ada63d-3462-4c72-908e-9d35f0acce40" title="TextBox" showTitle="True"&gt;TextBox&lt;/widget&gt;&lt;widget id="19baa5f6-49d4-4828-8f7f-018535c35f94" title="Administration" showTitle="True"&gt;Administration&lt;/widget&gt;&lt;widget id="d81c5ae3-e57e-4374-a539-5cdee45e639f" title="Search" showTitle="True"&gt;Search&lt;/widget&gt;&lt;widget id="77142800-6dff-4016-99ca-69b5c5ebac93" title="Tag cloud" showTitle="True"&gt;Tag cloud&lt;/widget&gt;&lt;widget id="4ce68ae7-c0c8-4bf8-b50f-a67b582b0d2e" title="RecentPosts" showTitle="True"&gt;RecentPosts&lt;/widget&gt;&lt;/widgets&gt;</Settings>
606</WidgetData>');
607
608GO