PageRenderTime 124ms CodeModel.GetById 15ms app.highlight 102ms RepoModel.GetById 1ms app.codeStats 0ms

/BlogEngine/BlogEngine.NET/setup/SQLServer/MSSQLSetup2.0.0.0.sql

#
SQL | 650 lines | 605 code | 21 blank | 24 comment | 0 complexity | 434677b7ecc04095b7d87b8f58a55655 MD5 | raw file
  1/****** BlogEngine.NET 2.0 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	[IsDeleted] [bit] NOT NULL DEFAULT 0,
 52 CONSTRAINT [PK_be_Pages] PRIMARY KEY CLUSTERED 
 53(
 54	[PageID] ASC
 55)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
 56) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
 57GO
 58/****** Object:  Table [dbo].[be_PingService]    Script Date: 12/22/2007 14:15:47 ******/
 59SET ANSI_NULLS ON
 60GO
 61SET QUOTED_IDENTIFIER ON
 62GO
 63CREATE TABLE [dbo].[be_PingService](
 64	[PingServiceID] [int] IDENTITY(1,1) NOT NULL,
 65	[Link] [nvarchar](255) NULL,
 66 CONSTRAINT [PK_be_PingService] PRIMARY KEY CLUSTERED 
 67(
 68	[PingServiceID] ASC
 69)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
 70) ON [PRIMARY]
 71GO
 72/****** Object:  Table [dbo].[be_Posts]    Script Date: 12/22/2007 14:16:27 ******/
 73SET ANSI_NULLS ON
 74GO
 75SET QUOTED_IDENTIFIER ON
 76GO
 77CREATE TABLE [dbo].[be_Posts](
 78	[PostID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_be_Posts_PostID]  DEFAULT (newid()),
 79	[Title] [nvarchar](255) NULL,
 80	[Description] [nvarchar](max) NULL,
 81	[PostContent] [nvarchar](max) NULL,
 82	[DateCreated] [datetime] NULL,
 83	[DateModified] [datetime] NULL,
 84	[Author] [nvarchar](50) NULL,
 85	[IsPublished] [bit] NULL,
 86	[IsCommentEnabled] [bit] NULL,
 87	[Raters] [int] NULL,
 88	[Rating] [real] NULL,
 89	[Slug] [nvarchar](255) NULL,
 90	[IsDeleted] [bit] NOT NULL DEFAULT 0,
 91 CONSTRAINT [PK_be_Posts] PRIMARY KEY CLUSTERED 
 92(
 93	[PostID] ASC
 94)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
 95) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
 96GO
 97/****** Object:  Table [dbo].[be_Settings]    Script Date: 12/22/2007 14:16:07 ******/
 98SET ANSI_NULLS ON
 99GO
100SET QUOTED_IDENTIFIER ON
101GO
102CREATE TABLE [dbo].[be_Settings](
103	[SettingName] [nvarchar](50) NOT NULL,
104	[SettingValue] [nvarchar](max) NULL,
105 CONSTRAINT [PK_be_Settings] PRIMARY KEY CLUSTERED 
106(
107	[SettingName] ASC
108)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
109) ON [PRIMARY]
110GO
111/****** Object:  Table [dbo].[be_Profiles]    Script Date: 06/28/2008 19:33:41 ******/
112SET ANSI_NULLS ON
113GO
114SET QUOTED_IDENTIFIER ON
115GO
116CREATE TABLE [dbo].[be_Profiles](
117	[ProfileID] [int] IDENTITY(1,1) NOT NULL,
118	[UserName] [nvarchar](100) NULL,
119	[SettingName] [nvarchar](200) NULL,
120	[SettingValue] [nvarchar](max) NULL,
121 CONSTRAINT [PK_be_Profiles] PRIMARY KEY CLUSTERED 
122(
123	[ProfileID] ASC
124)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
125) ON [PRIMARY]
126GO
127/****** Object:  Table [dbo].[be_StopWords]    Script Date: 06/28/2008 19:33:32 ******/
128SET ANSI_NULLS ON
129GO
130SET QUOTED_IDENTIFIER ON
131GO
132CREATE TABLE [dbo].[be_StopWords](
133	[StopWord] [nvarchar](50) NOT NULL,
134 CONSTRAINT [PK_be_StopWords] PRIMARY KEY CLUSTERED 
135(
136	[StopWord] ASC
137)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
138) ON [PRIMARY]
139GO
140/****** Object:  Table [dbo].[be_PostCategory]    Script Date: 12/22/2007 14:17:00 ******/
141SET ANSI_NULLS ON
142GO
143SET QUOTED_IDENTIFIER ON
144GO
145CREATE TABLE [dbo].[be_PostCategory](
146	[PostCategoryID] [int] IDENTITY(1,1) NOT NULL,
147	[PostID] [uniqueidentifier] NOT NULL,
148	[CategoryID] [uniqueidentifier] NOT NULL,
149 CONSTRAINT [PK_be_PostCategory] PRIMARY KEY CLUSTERED 
150(
151	[PostCategoryID] ASC
152)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
153) ON [PRIMARY]
154
155GO
156ALTER TABLE [dbo].[be_PostCategory]  WITH CHECK ADD  CONSTRAINT [FK_be_PostCategory_be_Categories] FOREIGN KEY([CategoryID])
157REFERENCES [dbo].[be_Categories] ([CategoryID])
158GO
159ALTER TABLE [dbo].[be_PostCategory] CHECK CONSTRAINT [FK_be_PostCategory_be_Categories]
160GO
161ALTER TABLE [dbo].[be_PostCategory]  WITH CHECK ADD  CONSTRAINT [FK_be_PostCategory_be_Posts] FOREIGN KEY([PostID])
162REFERENCES [dbo].[be_Posts] ([PostID])
163GO
164ALTER TABLE [dbo].[be_PostCategory] CHECK CONSTRAINT [FK_be_PostCategory_be_Posts]
165GO
166/****** Object:  Table [dbo].[be_PostComment]    Script Date: 12/22/2007 14:17:15 ******/
167SET ANSI_NULLS ON
168GO
169SET QUOTED_IDENTIFIER ON
170GO
171CREATE TABLE [dbo].[be_PostComment](
172	[PostCommentID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_be_PostComment_PostCommentID]  DEFAULT (newid()),
173	[PostID] [uniqueidentifier] NOT NULL,
174	[ParentCommentID] [uniqueidentifier] NOT NULL DEFAULT ('00000000-0000-0000-0000-000000000000'),
175	[CommentDate] [datetime] NOT NULL,
176	[Author] [nvarchar](255) NULL,
177	[Email] [nvarchar](255) NULL,
178	[Website] [nvarchar](255) NULL,
179	[Comment] [nvarchar](max) NULL,
180	[Country] [nvarchar](255) NULL,
181	[Ip] [nvarchar](50) NULL,
182	[IsApproved] [bit] NULL,
183	[ModeratedBy] [nvarchar](100) NULL,
184	[Avatar] [nvarchar](255) NULL,
185	[IsSpam] [bit] NOT NULL DEFAULT 0,
186	[IsDeleted] [bit] NOT NULL DEFAULT 0,
187 CONSTRAINT [PK_be_PostComment] PRIMARY KEY CLUSTERED 
188(
189	[PostCommentID] ASC
190)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
191) ON [PRIMARY]
192
193GO
194ALTER TABLE [dbo].[be_PostComment]  WITH CHECK ADD  CONSTRAINT [FK_be_PostComment_be_Posts] FOREIGN KEY([PostID])
195REFERENCES [dbo].[be_Posts] ([PostID])
196GO
197ALTER TABLE [dbo].[be_PostComment] CHECK CONSTRAINT [FK_be_PostComment_be_Posts]
198GO
199/****** Object:  Table [dbo].[be_PostNotify]    Script Date: 12/22/2007 14:17:31 ******/
200SET ANSI_NULLS ON
201GO
202SET QUOTED_IDENTIFIER ON
203GO
204CREATE TABLE [dbo].[be_PostNotify](
205	[PostNotifyID] [int] IDENTITY(1,1) NOT NULL,
206	[PostID] [uniqueidentifier] NOT NULL,
207	[NotifyAddress] [nvarchar](255) NULL,
208 CONSTRAINT [PK_be_PostNotify] PRIMARY KEY CLUSTERED 
209(
210	[PostNotifyID] ASC
211)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
212) ON [PRIMARY]
213
214GO
215ALTER TABLE [dbo].[be_PostNotify]  WITH CHECK ADD  CONSTRAINT [FK_be_PostNotify_be_Posts] FOREIGN KEY([PostID])
216REFERENCES [dbo].[be_Posts] ([PostID])
217GO
218ALTER TABLE [dbo].[be_PostNotify] CHECK CONSTRAINT [FK_be_PostNotify_be_Posts]
219GO
220/****** Object:  Table [dbo].[be_PostTag]    Script Date: 12/22/2007 14:17:44 ******/
221SET ANSI_NULLS ON
222GO
223SET QUOTED_IDENTIFIER ON
224GO
225CREATE TABLE [dbo].[be_PostTag](
226	[PostTagID] [int] IDENTITY(1,1) NOT NULL,
227	[PostID] [uniqueidentifier] NOT NULL,
228	[Tag] [nvarchar](50) NULL,
229 CONSTRAINT [PK_be_PostTag] PRIMARY KEY CLUSTERED 
230(
231	[PostTagID] ASC
232)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
233) ON [PRIMARY]
234
235GO
236ALTER TABLE [dbo].[be_PostTag]  WITH CHECK ADD  CONSTRAINT [FK_be_PostTag_be_Posts] FOREIGN KEY([PostID])
237REFERENCES [dbo].[be_Posts] ([PostID])
238GO
239ALTER TABLE [dbo].[be_PostTag] CHECK CONSTRAINT [FK_be_PostTag_be_Posts]
240GO
241/****** Object:  Table [dbo].[be_Users]    Script Date: 07/30/2008 21:55:28 ******/
242SET ANSI_NULLS ON
243GO
244SET QUOTED_IDENTIFIER ON
245GO
246CREATE TABLE [dbo].[be_Users](
247	[UserID] [int] IDENTITY(1,1) NOT NULL,
248	[UserName] [nvarchar](100) NOT NULL,
249	[Password] [nvarchar](255) NOT NULL,
250	[LastLoginTime] [datetime] NULL,
251	[EmailAddress] [nvarchar](100) NULL,
252 CONSTRAINT [PK_be_Users] PRIMARY KEY CLUSTERED 
253(
254	[UserID] ASC
255)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
256) ON [PRIMARY]
257GO
258/****** Object:  Table [dbo].[be_Roles]    Script Date: 07/30/2008 21:56:59 ******/
259SET ANSI_NULLS ON
260GO
261SET QUOTED_IDENTIFIER ON
262GO
263CREATE TABLE [dbo].[be_Roles](
264	[RoleID] [int] IDENTITY(1,1) NOT NULL,
265	[Role] [nvarchar](100) NOT NULL,
266 CONSTRAINT [PK_be_Roles] PRIMARY KEY CLUSTERED 
267(
268	[RoleID] ASC
269)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
270) ON [PRIMARY]
271GO
272/****** Object:  Table [dbo].[be_UserRoles]    Script Date: 07/31/2008 12:26:45 ******/
273SET ANSI_NULLS ON
274GO
275SET QUOTED_IDENTIFIER ON
276GO
277CREATE TABLE [dbo].[be_UserRoles](
278	[UserRoleID] [int] IDENTITY(1,1) NOT NULL,
279	[UserID] [int] NOT NULL,
280	[RoleID] [int] NOT NULL,
281 CONSTRAINT [PK_be_UserRoles] PRIMARY KEY CLUSTERED 
282(
283	[UserRoleID] ASC
284)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
285) ON [PRIMARY]
286
287GO
288ALTER TABLE [dbo].[be_UserRoles]  WITH CHECK ADD  CONSTRAINT [FK_be_UserRoles_be_Roles] FOREIGN KEY([RoleID])
289REFERENCES [dbo].[be_Roles] ([RoleID])
290GO
291ALTER TABLE [dbo].[be_UserRoles] CHECK CONSTRAINT [FK_be_UserRoles_be_Roles]
292GO
293ALTER TABLE [dbo].[be_UserRoles]  WITH CHECK ADD  CONSTRAINT [FK_be_UserRoles_be_Users] FOREIGN KEY([UserID])
294REFERENCES [dbo].[be_Users] ([UserID])
295GO
296ALTER TABLE [dbo].[be_UserRoles] CHECK CONSTRAINT [FK_be_UserRoles_be_Users]
297GO
298CREATE TABLE [dbo].[be_BlogRollItems](
299	[BlogRollId] [uniqueidentifier] NOT NULL,
300	[Title] [nvarchar](255) NOT NULL,
301	[Description] [nvarchar](max) NULL,
302	[BlogUrl] [varchar](255) NOT NULL,
303	[FeedUrl] [varchar](255) NULL,
304	[Xfn] [varchar](255) NULL,
305	[SortIndex] [int] NOT NULL,
306 CONSTRAINT [PK_be_BlogRollItems] PRIMARY KEY CLUSTERED 
307(
308	[BlogRollId] ASC
309)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
310) ON [PRIMARY]
311GO
312CREATE TABLE [dbo].[be_Referrers](
313	[ReferrerId] [uniqueidentifier] NOT NULL,
314	[ReferralDay] [datetime] NOT NULL CONSTRAINT [DF_be_Referrers_Day]  DEFAULT (getdate()),
315	[ReferrerUrl] [varchar](255) NOT NULL,
316	[ReferralCount] [int] NOT NULL,
317	[Url] [varchar](255) NULL,
318	[IsSpam] [bit] NULL,
319 CONSTRAINT [PK_be_Referrers] PRIMARY KEY CLUSTERED 
320(
321	[ReferrerId] ASC
322)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
323) ON [PRIMARY]
324GO
325
326CREATE TABLE [dbo].[be_Rights](
327	[RightName] [nvarchar](100) NOT NULL,
328 CONSTRAINT [PK_be_Rights] PRIMARY KEY CLUSTERED 
329(
330	[RightName] ASC
331)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
332) ON [PRIMARY]
333GO
334
335CREATE TABLE [dbo].[be_RightRoles](
336	[RightName] [nvarchar](100) NOT NULL,
337	[Role] [nvarchar](100) NOT NULL,
338 CONSTRAINT [PK_be_RightRoles] PRIMARY KEY CLUSTERED 
339(
340	[RightName] ASC,
341	[Role] ASC
342)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
343) ON [PRIMARY]
344GO
345
346/****** Object:  Index [FK_PostID]    Script Date: 12/22/2007 14:18:36 ******/
347CREATE NONCLUSTERED INDEX [FK_PostID] ON [dbo].[be_PostCategory] 
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 [FK_CategoryID]    Script Date: 12/22/2007 14:19:19 ******/
353CREATE NONCLUSTERED INDEX [FK_CategoryID] ON [dbo].[be_PostCategory] 
354(
355	[CategoryID] ASC
356)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]
357GO
358/****** Object:  Index [FK_PostID]    Script Date: 12/22/2007 14:19:45 ******/
359CREATE NONCLUSTERED INDEX [FK_PostID] ON [dbo].[be_PostComment] 
360(
361	[PostID] ASC
362)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]
363GO
364/****** Object:  Index [FK_PostID]    Script Date: 12/22/2007 14:20:29 ******/
365CREATE NONCLUSTERED INDEX [FK_PostID] ON [dbo].[be_PostNotify] 
366(
367	[PostID] ASC
368)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]
369GO
370/****** Object:  Index [FK_PostID]    Script Date: 12/22/2007 14:20:43 ******/
371CREATE NONCLUSTERED INDEX [FK_PostID] ON [dbo].[be_PostTag] 
372(
373	[PostID] ASC
374)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]
375GO
376/****** Object:  Index [I_TypeID]    Script Date: 06/28/2008 19:34:43 ******/
377CREATE NONCLUSTERED INDEX [I_TypeID] ON [dbo].[be_DataStoreSettings] 
378(
379	[ExtensionType] ASC,
380	[ExtensionId] ASC
381)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]
382GO
383/****** Object:  Index [I_UserName]    Script Date: 06/28/2008 19:35:12 ******/
384CREATE NONCLUSTERED INDEX [I_UserName] ON [dbo].[be_Profiles] 
385(
386	[UserName] ASC
387)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]
388GO
389/***  Load initial Data ***/
390INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('administratorrole', 'Administrators');
391INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('alternatefeedurl', '');
392INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('authorname', 'My name');
393INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('avatar', 'combine');
394INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('blogrollmaxlength', '23');
395INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('blogrollupdateminutes', '60');
396INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('blogrollvisibleposts', '3');
397INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('contactformmessage', '<p>I will answer the mail as soon as I can.</p>');
398INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('contactthankmessage', '<h1>Thank you</h1><p>The message was sent.</p>');
399INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('culture', 'Auto');
400INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('dayscommentsareenabled', '0');
401INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('description', 'Short description of the blog');
402INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('displaycommentsonrecentposts', 'True');
403INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('displayratingsonrecentposts', 'True');
404INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('email', 'user@example.com');
405INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('emailsubjectprefix', 'Weblog');
406INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablecommentsearch', 'True');
407INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablecommentsmoderation', 'False');
408INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablecontactattachments', 'True');
409INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablecountryincomments', 'True');
410INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablehttpcompression', 'True');
411INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enableopensearch', 'True');
412INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablepingbackreceive', 'True');
413INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablepingbacksend', 'True');
414INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablerating', 'True');
415INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablereferrertracking', 'False');
416INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablerelatedposts', 'True');
417INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablessl', 'False');
418INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enabletrackbackreceive', 'True');
419INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enabletrackbacksend', 'True');
420INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('endorsement', 'http://www.dotnetblogengine.net/syndication.axd');
421INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('fileextension', '.aspx');
422INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('geocodinglatitude', '0');
423INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('geocodinglongitude', '0');
424INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('handlewwwsubdomain', '');
425INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('iscocommentenabled', 'False');
426INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('iscommentsenabled', 'True');
427INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('language', 'en-GB');
428INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('mobiletheme', 'Mobile');
429INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('name', 'Name of the blog');
430INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('numberofrecentcomments', '10');
431INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('numberofrecentposts', '10');
432INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('postsperfeed', '10');
433INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('postsperpage', '10');
434INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('removewhitespaceinstylesheets', 'True');
435INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('searchbuttontext', 'Search');
436INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('searchcommentlabeltext', 'Include comments in search');
437INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('searchdefaulttext', 'Enter search term');
438INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('sendmailoncomment', 'True');
439INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('showdescriptioninpostlist', 'False');
440INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('showlivepreview', 'True');
441INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('showpostnavigation', 'True');
442INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('smtppassword', 'password');
443INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('smtpserver', 'mail.example.dk');
444INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('smtpserverport', '25');
445INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('smtpusername', 'user@example.com');
446INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('storagelocation', '~/App_Data/');
447INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('syndicationformat', 'Rss');
448INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('theme', 'Standard');
449INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('timestamppostlinks', 'True');
450INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('timezone', '-5');
451INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('trackingscript', '');
452
453INSERT INTO be_PingService (Link) VALUES ('http://rpc.technorati.com/rpc/ping');
454INSERT INTO be_PingService (Link) VALUES ('http://rpc.pingomatic.com/rpc2');
455INSERT INTO be_PingService (Link) VALUES ('http://ping.feedburner.com');
456INSERT INTO be_PingService (Link) VALUES ('http://www.bloglines.com/ping');
457INSERT INTO be_PingService (Link) VALUES ('http://services.newsgator.com/ngws/xmlrpcping.aspx');
458INSERT INTO be_PingService (Link) VALUES ('http://api.my.yahoo.com/rpc2 ');
459INSERT INTO be_PingService (Link) VALUES ('http://blogsearch.google.com/ping/RPC2');
460INSERT INTO be_PingService (Link) VALUES ('http://rpc.pingthesemanticweb.com/');
461
462INSERT INTO be_StopWords (StopWord)	VALUES ('a');
463INSERT INTO be_StopWords (StopWord)	VALUES ('about');
464INSERT INTO be_StopWords (StopWord)	VALUES ('actually');
465INSERT INTO be_StopWords (StopWord)	VALUES ('add');
466INSERT INTO be_StopWords (StopWord)	VALUES ('after');
467INSERT INTO be_StopWords (StopWord)	VALUES ('all');
468INSERT INTO be_StopWords (StopWord)	VALUES ('almost');
469INSERT INTO be_StopWords (StopWord)	VALUES ('along');
470INSERT INTO be_StopWords (StopWord)	VALUES ('also');
471INSERT INTO be_StopWords (StopWord)	VALUES ('an');
472INSERT INTO be_StopWords (StopWord)	VALUES ('and');
473INSERT INTO be_StopWords (StopWord)	VALUES ('any');
474INSERT INTO be_StopWords (StopWord)	VALUES ('are');
475INSERT INTO be_StopWords (StopWord)	VALUES ('as');
476INSERT INTO be_StopWords (StopWord)	VALUES ('at');
477INSERT INTO be_StopWords (StopWord)	VALUES ('be');
478INSERT INTO be_StopWords (StopWord)	VALUES ('both');
479INSERT INTO be_StopWords (StopWord)	VALUES ('but');
480INSERT INTO be_StopWords (StopWord)	VALUES ('by');
481INSERT INTO be_StopWords (StopWord)	VALUES ('can');
482INSERT INTO be_StopWords (StopWord)	VALUES ('cannot');
483INSERT INTO be_StopWords (StopWord)	VALUES ('com');
484INSERT INTO be_StopWords (StopWord)	VALUES ('could');
485INSERT INTO be_StopWords (StopWord)	VALUES ('de');
486INSERT INTO be_StopWords (StopWord)	VALUES ('do');
487INSERT INTO be_StopWords (StopWord)	VALUES ('down');
488INSERT INTO be_StopWords (StopWord)	VALUES ('each');
489INSERT INTO be_StopWords (StopWord)	VALUES ('either');
490INSERT INTO be_StopWords (StopWord)	VALUES ('en');
491INSERT INTO be_StopWords (StopWord)	VALUES ('for');
492INSERT INTO be_StopWords (StopWord)	VALUES ('from');
493INSERT INTO be_StopWords (StopWord)	VALUES ('good');
494INSERT INTO be_StopWords (StopWord)	VALUES ('has');
495INSERT INTO be_StopWords (StopWord)	VALUES ('have');
496INSERT INTO be_StopWords (StopWord)	VALUES ('he');
497INSERT INTO be_StopWords (StopWord)	VALUES ('her');
498INSERT INTO be_StopWords (StopWord)	VALUES ('here');
499INSERT INTO be_StopWords (StopWord)	VALUES ('hers');
500INSERT INTO be_StopWords (StopWord)	VALUES ('his');
501INSERT INTO be_StopWords (StopWord)	VALUES ('how');
502INSERT INTO be_StopWords (StopWord)	VALUES ('i');
503INSERT INTO be_StopWords (StopWord)	VALUES ('if');
504INSERT INTO be_StopWords (StopWord)	VALUES ('in');
505INSERT INTO be_StopWords (StopWord)	VALUES ('into');
506INSERT INTO be_StopWords (StopWord)	VALUES ('is');
507INSERT INTO be_StopWords (StopWord)	VALUES ('it');
508INSERT INTO be_StopWords (StopWord)	VALUES ('its');
509INSERT INTO be_StopWords (StopWord)	VALUES ('just');
510INSERT INTO be_StopWords (StopWord)	VALUES ('la');
511INSERT INTO be_StopWords (StopWord)	VALUES ('like');
512INSERT INTO be_StopWords (StopWord)	VALUES ('long');
513INSERT INTO be_StopWords (StopWord)	VALUES ('make');
514INSERT INTO be_StopWords (StopWord)	VALUES ('me');
515INSERT INTO be_StopWords (StopWord)	VALUES ('more');
516INSERT INTO be_StopWords (StopWord)	VALUES ('much');
517INSERT INTO be_StopWords (StopWord)	VALUES ('my');
518INSERT INTO be_StopWords (StopWord)	VALUES ('need');
519INSERT INTO be_StopWords (StopWord)	VALUES ('new');
520INSERT INTO be_StopWords (StopWord)	VALUES ('now');
521INSERT INTO be_StopWords (StopWord)	VALUES ('of');
522INSERT INTO be_StopWords (StopWord)	VALUES ('off');
523INSERT INTO be_StopWords (StopWord)	VALUES ('on');
524INSERT INTO be_StopWords (StopWord)	VALUES ('once');
525INSERT INTO be_StopWords (StopWord)	VALUES ('one');
526INSERT INTO be_StopWords (StopWord)	VALUES ('ones');
527INSERT INTO be_StopWords (StopWord)	VALUES ('only');
528INSERT INTO be_StopWords (StopWord)	VALUES ('or');
529INSERT INTO be_StopWords (StopWord)	VALUES ('our');
530INSERT INTO be_StopWords (StopWord)	VALUES ('out');
531INSERT INTO be_StopWords (StopWord)	VALUES ('over');
532INSERT INTO be_StopWords (StopWord)	VALUES ('own');
533INSERT INTO be_StopWords (StopWord)	VALUES ('really');
534INSERT INTO be_StopWords (StopWord)	VALUES ('right');
535INSERT INTO be_StopWords (StopWord)	VALUES ('same');
536INSERT INTO be_StopWords (StopWord)	VALUES ('see');
537INSERT INTO be_StopWords (StopWord)	VALUES ('she');
538INSERT INTO be_StopWords (StopWord)	VALUES ('so');
539INSERT INTO be_StopWords (StopWord)	VALUES ('some');
540INSERT INTO be_StopWords (StopWord)	VALUES ('such');
541INSERT INTO be_StopWords (StopWord)	VALUES ('take');
542INSERT INTO be_StopWords (StopWord)	VALUES ('takes');
543INSERT INTO be_StopWords (StopWord)	VALUES ('that');
544INSERT INTO be_StopWords (StopWord)	VALUES ('the');
545INSERT INTO be_StopWords (StopWord)	VALUES ('their');
546INSERT INTO be_StopWords (StopWord)	VALUES ('these');
547INSERT INTO be_StopWords (StopWord)	VALUES ('thing');
548INSERT INTO be_StopWords (StopWord)	VALUES ('this');
549INSERT INTO be_StopWords (StopWord)	VALUES ('to');
550INSERT INTO be_StopWords (StopWord)	VALUES ('too');
551INSERT INTO be_StopWords (StopWord)	VALUES ('took');
552INSERT INTO be_StopWords (StopWord)	VALUES ('und');
553INSERT INTO be_StopWords (StopWord)	VALUES ('up');
554INSERT INTO be_StopWords (StopWord)	VALUES ('use');
555INSERT INTO be_StopWords (StopWord)	VALUES ('used');
556INSERT INTO be_StopWords (StopWord)	VALUES ('using');
557INSERT INTO be_StopWords (StopWord)	VALUES ('very');
558INSERT INTO be_StopWords (StopWord)	VALUES ('was');
559INSERT INTO be_StopWords (StopWord)	VALUES ('we');
560INSERT INTO be_StopWords (StopWord)	VALUES ('well');
561INSERT INTO be_StopWords (StopWord)	VALUES ('what');
562INSERT INTO be_StopWords (StopWord)	VALUES ('when');
563INSERT INTO be_StopWords (StopWord)	VALUES ('where');
564INSERT INTO be_StopWords (StopWord)	VALUES ('who');
565INSERT INTO be_StopWords (StopWord)	VALUES ('will');
566INSERT INTO be_StopWords (StopWord)	VALUES ('with');
567INSERT INTO be_StopWords (StopWord)	VALUES ('www');
568INSERT INTO be_StopWords (StopWord)	VALUES ('you');
569INSERT INTO be_StopWords (StopWord)	VALUES ('your');
570
571INSERT INTO be_BlogRollItems ( BlogRollId, Title, [Description], BlogUrl, FeedUrl, Xfn, SortIndex )
572VALUES ( '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 );
573INSERT INTO be_BlogRollItems ( BlogRollId, Title, [Description], BlogUrl, FeedUrl, Xfn, SortIndex )
574VALUES ( '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 );
575INSERT INTO be_BlogRollItems ( BlogRollId, Title, [Description], BlogUrl, FeedUrl, Xfn, SortIndex )
576VALUES ( 'dcdaa78b-0b77-4691-99f0-1bb6418945a1', 'Ruslan Tur', '.NET and Open Source: better together', 'http://rtur.net/blog/', 'http://feeds.feedburner.com/rtur', 'contact', 2 );
577INSERT INTO be_BlogRollItems ( BlogRollId, Title, [Description], BlogUrl, FeedUrl, Xfn, SortIndex )
578VALUES ( '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 );
579INSERT INTO be_BlogRollItems ( BlogRollId, Title, [Description], BlogUrl, FeedUrl, Xfn, SortIndex )
580VALUES ( '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 );
581INSERT INTO be_BlogRollItems ( BlogRollId, Title, [Description], BlogUrl, FeedUrl, Xfn, SortIndex )
582VALUES ( '890f00e5-3a86-4cba-b85b-104063964a87', 'Ben Amada', 'adventures in application development', 'http://allben.net/', 'http://feeds.feedburner.com/allben', 'contact', 5 );
583
584DECLARE @postID uniqueidentifier, @catID uniqueidentifier;
585
586SET @postID = NEWID();
587SET @catID = NEWID();
588
589INSERT INTO be_Categories (CategoryID, CategoryName)
590	VALUES (@catID, 'General');
591
592INSERT INTO be_Posts (PostID, Title, Description, PostContent, DateCreated, Author, IsPublished)
593	VALUES (@postID, 
594	'Welcome to BlogEngine.NET 2.0 using Microsoft SQL Server', 
595	'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',
596	'<p>If you see this post it means that BlogEngine.NET 2.0 is running and the hard part of creating your own blog is done. There is only a few things left to do.</p>
597<h2>Write Permissions</h2>
598<p>To be able to log in to the blog and writing posts, you need to enable write permissions on the App_Data folder. If you&rsquo;re blog is hosted at a hosting provider, you can either log into your account&rsquo;s admin page or call the support. You need write permissions on the App_Data folder because all posts, comments, and blog attachments are saved as XML files and placed in the App_Data folder.&nbsp;</p>
599<p>If you wish to use a database to to store your blog data, we still encourage you to enable this write access for an images you may wish to store for your blog posts.&nbsp; If you are interested in using Microsoft SQL Server, MySQL, SQL CE, or other databases, please see the <a href="http://blogengine.codeplex.com/documentation">BlogEngine wiki</a> to get started.</p>
600<h2>Security</h2>
601<p>When you''ve got write permissions to the App_Data folder, you need to change the username and password. 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.&nbsp; Passwords are hashed by default so if you lose your password, please see the <a href="http://blogengine.codeplex.com/documentation">BlogEngine wiki</a> for information on recovery.</p>
602<h2>Configuration and Profile</h2>
603<p>Now that you have your blog secured, take a look through the settings and give your new blog a title.&nbsp; BlogEngine.NET 1.4 is set up to take full advantage of of many semantic formats and technologies such as FOAF, SIOC and APML. It means that the content stored in your BlogEngine.NET installation will be fully portable and auto-discoverable.&nbsp; Be sure to fill in your author profile to take better advantage of this.</p>
604<h2>Themes and Widgets</h2>
605<p>One last thing to consider is customizing the look of your blog.&nbsp; We have a few themes available right out of the box including two fully setup to use our new widget framework.&nbsp; The widget framework allows drop and drag placement on your side bar as well as editing and configuration right in the widget while you are logged in.&nbsp; Be sure to check out <a href="http://dotnetblogengine.net">our home page</a> for more theme choices and downloadable widgets to add to your blog.</p>
606<h2>Try Out New Features</h2>
607<p>BlogEngine now supports code syntax highlighting and HTML5 video out of the box. To add a video, click the "Insert video" button just above the post editor. Once your video is uploaded, use the following syntax to show it: [&shy;video src="be-sample.mp4"]. Make sure to add "video/mp4" as a MIME type to your IIS.</p>
608<p>[video src="http://dotnetblogengine.net/media/blogengine-welcome.mp4" type="video/mp4" width="600" height="480"]</p>
609<p>You can add formatted code by pressing the "Insert Code" button on the post editor toolbar. Here is a small sample:</p>
610<pre class="brush: c-sharp;">// Hello1.cs
611public class Hello1
612{
613   public static void Main()
614   {
615      System.Console.WriteLine("Hello, World!");
616   }
617}</pre>
618<p>&nbsp;</p>
619<h2>On the web</h2>
620<p>You can find BlogEngine.NET on the <a href="http://www.dotnetblogengine.net">official website</a>. Here you''ll 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>
621<p>Good luck and happy writing.</p>
622<p>The BlogEngine.NET team</p>',
623	GETDATE(), 
624	'admin',
625	1);
626
627INSERT INTO be_PostCategory (PostID, CategoryID)
628	VALUES (@postID, @catID);
629INSERT INTO be_PostTag (PostID, Tag)
630	VALUES (@postID, 'blog');
631INSERT INTO be_PostTag (PostID, Tag)
632	VALUES (@postID, 'welcome');
633
634INSERT INTO be_Users (UserName, Password, LastLoginTime, EmailAddress)
635	VALUES ('Admin', '', GETDATE(), 'email@example.com');
636INSERT INTO be_Roles (Role) 
637	VALUES ('Administrators');
638INSERT INTO be_Roles (Role) 
639	VALUES ('Editors');
640INSERT INTO be_UserRoles (UserID, RoleID)
641VALUES (1, 1);
642
643INSERT INTO be_DataStoreSettings (ExtensionType, ExtensionId, Settings)
644VALUES (1, 'be_WIDGET_ZONE', 
645'<?xml version="1.0" encoding="utf-16"?>
646<WidgetData xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
647  <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>
648</WidgetData>');
649
650GO