PageRenderTime 57ms CodeModel.GetById 13ms app.highlight 39ms RepoModel.GetById 1ms app.codeStats 0ms

/BlogEngine/BlogEngine.NET/setup/MySQL/MySQLSetup1.6.0.sql

#
SQL | 390 lines | 362 code | 27 blank | 1 comment | 0 complexity | e76441e1cc05ef1808f279015d4878c1 MD5 | raw file
  1CREATE TABLE `be_Categories` (
  2  `CategoryID` varchar(36) NOT NULL DEFAULT '',
  3  `CategoryName` varchar(50) DEFAULT NULL,
  4  `Description` varchar(200) DEFAULT NULL,
  5  `ParentID` varchar(36) DEFAULT NULL,
  6  PRIMARY KEY  (`CategoryID`)
  7) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  8
  9CREATE TABLE `be_DataStoreSettings` (
 10  `ExtensionType` varchar(50) NOT NULL,
 11  `ExtensionId` varchar(100) NOT NULL,
 12  `Settings` text NOT NULL
 13) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 14
 15CREATE TABLE `be_Pages` (
 16  `PageID` varchar(36) NOT NULL DEFAULT '',
 17  `Title` varchar(255) NOT NULL DEFAULT '',
 18  `Description` text,
 19  `PageContent` longtext,
 20  `Keywords` text,
 21  `DateCreated` datetime DEFAULT NULL,
 22  `DateModified` datetime DEFAULT NULL,
 23  `IsPublished` tinyint(1) DEFAULT NULL,
 24  `IsFrontPage` tinyint(1) DEFAULT NULL,
 25  `Parent` varchar(64) DEFAULT NULL,
 26  `ShowInList` tinyint(1) DEFAULT NULL,
 27  `Slug` varchar(255) DEFAULT NULL,
 28  PRIMARY KEY  (`PageID`)
 29) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 30
 31CREATE TABLE `be_PingService` (
 32  `PingServiceID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
 33  `Link` varchar(255) DEFAULT NULL,
 34  PRIMARY KEY  (`PingServiceID`)
 35) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 36
 37CREATE TABLE `be_Posts` (
 38  `PostID` varchar(36) NOT NULL DEFAULT '',
 39  `Title` varchar(255) NOT NULL DEFAULT '',
 40  `Description` text NOT NULL,
 41  `PostContent` longtext NOT NULL,
 42  `DateCreated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 43  `DateModified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 44  `Author` varchar(50) NOT NULL DEFAULT '',
 45  `IsPublished` tinyint(1) NOT NULL DEFAULT '0',
 46  `IsCommentEnabled` tinyint(1) NOT NULL DEFAULT '0',
 47  `Raters` int(10) UNSIGNED NOT NULL DEFAULT '0',
 48  `Rating` float NOT NULL DEFAULT '0',
 49  `Slug` varchar(255) NOT NULL DEFAULT '',
 50  PRIMARY KEY  (`PostID`)
 51) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 52
 53CREATE TABLE `be_Profiles` (
 54  `ProfileID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
 55  `UserName` varchar(100) NOT NULL,
 56  `SettingName` varchar(200) NOT NULL,
 57  `SettingValue` text NOT NULL,
 58  PRIMARY KEY  (`ProfileID`)
 59) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 60
 61CREATE TABLE `be_Roles` (
 62  `RoleID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
 63  `Role` varchar(100) NOT NULL,
 64  PRIMARY KEY  (`RoleID`)
 65) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
 66
 67CREATE TABLE `be_Settings` (
 68  `SettingName` varchar(50) NOT NULL,
 69  `SettingValue` text,
 70  PRIMARY KEY  (`SettingName`)
 71) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 72
 73CREATE TABLE `be_StopWords` (
 74  `StopWord` varchar(50) NOT NULL,
 75  PRIMARY KEY  (`StopWord`)
 76) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 77
 78CREATE TABLE `be_Users` (
 79  `UserID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
 80  `UserName` varchar(100) DEFAULT NULL,
 81  `Password` varchar(255) DEFAULT NULL,
 82  `LastLoginTime` datetime DEFAULT '0000-00-00 00:00:00',
 83  `EmailAddress` varchar(100) DEFAULT NULL,
 84  PRIMARY KEY  (`UserID`)
 85) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
 86
 87CREATE TABLE `be_UserRoles` (
 88  `UserRoleID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
 89  `UserID` int(10) UNSIGNED NOT NULL DEFAULT '0',
 90  `RoleID` int(10) UNSIGNED NOT NULL DEFAULT '0',
 91  PRIMARY KEY  (`UserRoleID`)
 92) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
 93
 94CREATE TABLE `be_PostCategory` (
 95  `PostCategoryID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
 96  `PostID` varchar(36) NOT NULL DEFAULT '',
 97  `CategoryID` varchar(36) NOT NULL DEFAULT '',
 98  PRIMARY KEY  (`PostCategoryID`)
 99) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
100
101CREATE TABLE `be_PostComment` (
102  `PostCommentID` varchar(36) NOT NULL DEFAULT '',
103  `PostID` varchar(36) NOT NULL DEFAULT '',
104  `ParentCommentID` varchar(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
105  `CommentDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
106  `Author` varchar(255) NOT NULL DEFAULT '',
107  `Email` varchar(255) NOT NULL DEFAULT '',
108  `Website` varchar(255) NOT NULL DEFAULT '',
109  `Comment` text NOT NULL,
110  `Country` varchar(255) NOT NULL DEFAULT '',
111  `Ip` varchar(50) NOT NULL DEFAULT '',
112  `IsApproved` tinyint(1) NOT NULL DEFAULT '0',
113  `ModeratedBy` varchar(100) DEFAULT NULL,
114  `Avatar` varchar(255) DEFAULT NULL,
115  PRIMARY KEY  (`PostCommentID`)
116) ENGINE=InnoDB DEFAULT CHARSET=latin1;
117
118CREATE TABLE `be_PostNotify` (
119  `PostNotifyID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
120  `PostID` varchar(36) NOT NULL DEFAULT '',
121  `NotifyAddress` varchar(255) DEFAULT NULL,
122  PRIMARY KEY  (`PostNotifyID`)
123) ENGINE=InnoDB DEFAULT CHARSET=latin1;
124
125CREATE TABLE `be_PostTag` (
126  `PostTagID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
127  `PostID` varchar(36) NOT NULL DEFAULT '',
128  `Tag` varchar(50) DEFAULT NULL,
129  PRIMARY KEY  (`PostTagID`)
130) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
131
132CREATE TABLE IF NOT EXISTS `be_BlogRollItems` (
133  `BlogRollID` varchar(36) NOT NULL,
134  `Title` varchar(255) NOT NULL,
135  `Description` longtext DEFAULT NULL,
136  `BlogUrl` varchar(255) NOT NULL,
137  `FeedUrl` varchar(255) DEFAULT NULL,
138  `Xfn` varchar(255) DEFAULT NULL,
139  `SortIndex` int(10) NOT NULL,
140  PRIMARY KEY  (`BlogRollID`)
141) ENGINE=InnoDB DEFAULT CHARSET=latin1;
142
143CREATE TABLE IF NOT EXISTS `be_Referrers` (
144  `ReferrerId` varchar(36) NOT NULL,
145  `ReferralDay` datetime NOT NULL,
146  `ReferrerUrl` varchar(255) NOT NULL,
147  `ReferralCount` int(10) NOT NULL,
148  `Url` varchar(255) DEFAULT NULL,
149  `IsSpam` tinyint(1) NULL,
150  PRIMARY KEY  (`ReferrerId`)
151) ENGINE=InnoDB DEFAULT CHARSET=latin1;
152
153/***  Load initial Data ***/
154INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('administratorrole', 'Administrators');
155INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('alternatefeedurl', '');
156INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('authorname', 'My name');
157INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('avatar', 'combine');
158INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('blogrollmaxlength', '23');
159INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('blogrollupdateminutes', '60');
160INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('blogrollvisibleposts', '3');
161INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('contactformmessage', '<p>I will answer the mail as soon as I can.</p>');
162INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('contactthankmessage', '<h1>Thank you</h1><p>The message was sent.</p>');
163INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('culture', 'Auto');
164INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('dayscommentsareenabled', '0');
165INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('description', 'Short description of the blog');
166INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('displaycommentsonrecentposts', 'True');
167INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('displayratingsonrecentposts', 'True');
168INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('email', 'user@example.com');
169INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('emailsubjectprefix', 'Weblog');
170INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablecommentsearch', 'True');
171INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablecommentsmoderation', 'False');
172INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablecontactattachments', 'True');
173INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablecountryincomments', 'True');
174INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablehttpcompression', 'True');
175INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enableopensearch', 'True');
176INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablepingbackreceive', 'True');
177INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablepingbacksend', 'True');
178INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablerating', 'True');
179INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablereferrertracking', 'False');
180INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablerelatedposts', 'True');
181INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enablessl', 'False');
182INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enabletrackbackreceive', 'True');
183INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('enabletrackbacksend', 'True');
184INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('endorsement', 'http://www.dotnetblogengine.net/syndication.axd');
185INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('fileextension', '.aspx');
186INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('geocodinglatitude', '0');
187INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('geocodinglongitude', '0');
188INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('handlewwwsubdomain', '');
189INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('iscocommentenabled', 'False');
190INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('iscommentsenabled', 'True');
191INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('language', 'en-GB');
192INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('mobiletheme', 'Mobile');
193INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('name', 'Name of the blog');
194INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('numberofrecentcomments', '10');
195INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('numberofrecentposts', '10');
196INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('postsperfeed', '10');
197INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('postsperpage', '10');
198INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('removewhitespaceinstylesheets', 'True');
199INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('searchbuttontext', 'Search');
200INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('searchcommentlabeltext', 'Include comments in search');
201INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('searchdefaulttext', 'Enter search term');
202INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('sendmailoncomment', 'True');
203INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('showdescriptioninpostlist', 'False');
204INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('showlivepreview', 'True');
205INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('showpostnavigation', 'True');
206INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('smtppassword', 'password');
207INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('smtpserver', 'mail.example.dk');
208INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('smtpserverport', '25');
209INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('smtpusername', 'user@example.com');
210INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('storagelocation', '~/App_Data/');
211INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('syndicationformat', 'Rss');
212INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('theme', 'Standard');
213INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('timestamppostlinks', 'True');
214INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('timezone', '-5');
215INSERT INTO be_Settings (SettingName, SettingValue)	VALUES ('trackingscript', '');
216
217INSERT INTO be_PingService (Link) VALUES ('http://rpc.technorati.com/rpc/ping');
218INSERT INTO be_PingService (Link) VALUES ('http://rpc.pingomatic.com/rpc2');
219INSERT INTO be_PingService (Link) VALUES ('http://ping.feedburner.com');
220INSERT INTO be_PingService (Link) VALUES ('http://www.bloglines.com/ping');
221INSERT INTO be_PingService (Link) VALUES ('http://services.newsgator.com/ngws/xmlrpcping.aspx');
222INSERT INTO be_PingService (Link) VALUES ('http://api.my.yahoo.com/rpc2 ');
223INSERT INTO be_PingService (Link) VALUES ('http://blogsearch.google.com/ping/RPC2');
224INSERT INTO be_PingService (Link) VALUES ('http://rpc.pingthesemanticweb.com/');
225
226INSERT INTO be_StopWords (StopWord)	VALUES ('a');
227INSERT INTO be_StopWords (StopWord)	VALUES ('about');
228INSERT INTO be_StopWords (StopWord)	VALUES ('actually');
229INSERT INTO be_StopWords (StopWord)	VALUES ('add');
230INSERT INTO be_StopWords (StopWord)	VALUES ('after');
231INSERT INTO be_StopWords (StopWord)	VALUES ('all');
232INSERT INTO be_StopWords (StopWord)	VALUES ('almost');
233INSERT INTO be_StopWords (StopWord)	VALUES ('along');
234INSERT INTO be_StopWords (StopWord)	VALUES ('also');
235INSERT INTO be_StopWords (StopWord)	VALUES ('an');
236INSERT INTO be_StopWords (StopWord)	VALUES ('and');
237INSERT INTO be_StopWords (StopWord)	VALUES ('any');
238INSERT INTO be_StopWords (StopWord)	VALUES ('are');
239INSERT INTO be_StopWords (StopWord)	VALUES ('as');
240INSERT INTO be_StopWords (StopWord)	VALUES ('at');
241INSERT INTO be_StopWords (StopWord)	VALUES ('be');
242INSERT INTO be_StopWords (StopWord)	VALUES ('both');
243INSERT INTO be_StopWords (StopWord)	VALUES ('but');
244INSERT INTO be_StopWords (StopWord)	VALUES ('by');
245INSERT INTO be_StopWords (StopWord)	VALUES ('can');
246INSERT INTO be_StopWords (StopWord)	VALUES ('cannot');
247INSERT INTO be_StopWords (StopWord)	VALUES ('com');
248INSERT INTO be_StopWords (StopWord)	VALUES ('could');
249INSERT INTO be_StopWords (StopWord)	VALUES ('de');
250INSERT INTO be_StopWords (StopWord)	VALUES ('do');
251INSERT INTO be_StopWords (StopWord)	VALUES ('down');
252INSERT INTO be_StopWords (StopWord)	VALUES ('each');
253INSERT INTO be_StopWords (StopWord)	VALUES ('either');
254INSERT INTO be_StopWords (StopWord)	VALUES ('en');
255INSERT INTO be_StopWords (StopWord)	VALUES ('for');
256INSERT INTO be_StopWords (StopWord)	VALUES ('from');
257INSERT INTO be_StopWords (StopWord)	VALUES ('good');
258INSERT INTO be_StopWords (StopWord)	VALUES ('has');
259INSERT INTO be_StopWords (StopWord)	VALUES ('have');
260INSERT INTO be_StopWords (StopWord)	VALUES ('he');
261INSERT INTO be_StopWords (StopWord)	VALUES ('her');
262INSERT INTO be_StopWords (StopWord)	VALUES ('here');
263INSERT INTO be_StopWords (StopWord)	VALUES ('hers');
264INSERT INTO be_StopWords (StopWord)	VALUES ('his');
265INSERT INTO be_StopWords (StopWord)	VALUES ('how');
266INSERT INTO be_StopWords (StopWord)	VALUES ('i');
267INSERT INTO be_StopWords (StopWord)	VALUES ('if');
268INSERT INTO be_StopWords (StopWord)	VALUES ('in');
269INSERT INTO be_StopWords (StopWord)	VALUES ('into');
270INSERT INTO be_StopWords (StopWord)	VALUES ('is');
271INSERT INTO be_StopWords (StopWord)	VALUES ('it');
272INSERT INTO be_StopWords (StopWord)	VALUES ('its');
273INSERT INTO be_StopWords (StopWord)	VALUES ('just');
274INSERT INTO be_StopWords (StopWord)	VALUES ('la');
275INSERT INTO be_StopWords (StopWord)	VALUES ('like');
276INSERT INTO be_StopWords (StopWord)	VALUES ('long');
277INSERT INTO be_StopWords (StopWord)	VALUES ('make');
278INSERT INTO be_StopWords (StopWord)	VALUES ('me');
279INSERT INTO be_StopWords (StopWord)	VALUES ('more');
280INSERT INTO be_StopWords (StopWord)	VALUES ('much');
281INSERT INTO be_StopWords (StopWord)	VALUES ('my');
282INSERT INTO be_StopWords (StopWord)	VALUES ('need');
283INSERT INTO be_StopWords (StopWord)	VALUES ('new');
284INSERT INTO be_StopWords (StopWord)	VALUES ('now');
285INSERT INTO be_StopWords (StopWord)	VALUES ('of');
286INSERT INTO be_StopWords (StopWord)	VALUES ('off');
287INSERT INTO be_StopWords (StopWord)	VALUES ('on');
288INSERT INTO be_StopWords (StopWord)	VALUES ('once');
289INSERT INTO be_StopWords (StopWord)	VALUES ('one');
290INSERT INTO be_StopWords (StopWord)	VALUES ('ones');
291INSERT INTO be_StopWords (StopWord)	VALUES ('only');
292INSERT INTO be_StopWords (StopWord)	VALUES ('or');
293INSERT INTO be_StopWords (StopWord)	VALUES ('our');
294INSERT INTO be_StopWords (StopWord)	VALUES ('out');
295INSERT INTO be_StopWords (StopWord)	VALUES ('over');
296INSERT INTO be_StopWords (StopWord)	VALUES ('own');
297INSERT INTO be_StopWords (StopWord)	VALUES ('really');
298INSERT INTO be_StopWords (StopWord)	VALUES ('right');
299INSERT INTO be_StopWords (StopWord)	VALUES ('same');
300INSERT INTO be_StopWords (StopWord)	VALUES ('see');
301INSERT INTO be_StopWords (StopWord)	VALUES ('she');
302INSERT INTO be_StopWords (StopWord)	VALUES ('so');
303INSERT INTO be_StopWords (StopWord)	VALUES ('some');
304INSERT INTO be_StopWords (StopWord)	VALUES ('such');
305INSERT INTO be_StopWords (StopWord)	VALUES ('take');
306INSERT INTO be_StopWords (StopWord)	VALUES ('takes');
307INSERT INTO be_StopWords (StopWord)	VALUES ('that');
308INSERT INTO be_StopWords (StopWord)	VALUES ('the');
309INSERT INTO be_StopWords (StopWord)	VALUES ('their');
310INSERT INTO be_StopWords (StopWord)	VALUES ('these');
311INSERT INTO be_StopWords (StopWord)	VALUES ('thing');
312INSERT INTO be_StopWords (StopWord)	VALUES ('this');
313INSERT INTO be_StopWords (StopWord)	VALUES ('to');
314INSERT INTO be_StopWords (StopWord)	VALUES ('too');
315INSERT INTO be_StopWords (StopWord)	VALUES ('took');
316INSERT INTO be_StopWords (StopWord)	VALUES ('und');
317INSERT INTO be_StopWords (StopWord)	VALUES ('up');
318INSERT INTO be_StopWords (StopWord)	VALUES ('use');
319INSERT INTO be_StopWords (StopWord)	VALUES ('used');
320INSERT INTO be_StopWords (StopWord)	VALUES ('using');
321INSERT INTO be_StopWords (StopWord)	VALUES ('very');
322INSERT INTO be_StopWords (StopWord)	VALUES ('was');
323INSERT INTO be_StopWords (StopWord)	VALUES ('we');
324INSERT INTO be_StopWords (StopWord)	VALUES ('well');
325INSERT INTO be_StopWords (StopWord)	VALUES ('what');
326INSERT INTO be_StopWords (StopWord)	VALUES ('when');
327INSERT INTO be_StopWords (StopWord)	VALUES ('where');
328INSERT INTO be_StopWords (StopWord)	VALUES ('who');
329INSERT INTO be_StopWords (StopWord)	VALUES ('will');
330INSERT INTO be_StopWords (StopWord)	VALUES ('with');
331INSERT INTO be_StopWords (StopWord)	VALUES ('www');
332INSERT INTO be_StopWords (StopWord)	VALUES ('you');
333INSERT INTO be_StopWords (StopWord)	VALUES ('your');
334
335INSERT INTO be_BlogRollItems ( BlogRollId, Title, Description, BlogUrl, FeedUrl, Xfn, SortIndex )
336VALUES ( '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 );
337INSERT INTO be_BlogRollItems ( BlogRollId, Title, Description, BlogUrl, FeedUrl, Xfn, SortIndex )
338VALUES ( '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 );
339INSERT INTO be_BlogRollItems ( BlogRollId, Title, Description, BlogUrl, FeedUrl, Xfn, SortIndex )
340VALUES ( 'dcdaa78b-0b77-4691-99f0-1bb6418945a1', 'Ruslan Tur', '.NET and Open Source: better together', 'http://rtur.net/blog/', 'http://feeds.feedburner.com/rtur', 'contact', 2 );
341INSERT INTO be_BlogRollItems ( BlogRollId, Title, Description, BlogUrl, FeedUrl, Xfn, SortIndex )
342VALUES ( '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 );
343INSERT INTO be_BlogRollItems ( BlogRollId, Title, Description, BlogUrl, FeedUrl, Xfn, SortIndex )
344VALUES ( '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 );
345INSERT INTO be_BlogRollItems ( BlogRollId, Title, Description, BlogUrl, FeedUrl, Xfn, SortIndex )
346VALUES ( '890f00e5-3a86-4cba-b85b-104063964a87', 'Ben Amada', 'adventures in application development', 'http://allben.net/', 'http://feeds.feedburner.com/allben', 'contact', 5 );
347
348INSERT INTO be_Categories (CategoryID, CategoryName)
349	VALUES ('ffc26b8b-7d45-46e3-b702-7198e8847e06', 'General');
350
351INSERT INTO be_Posts (PostID, Title, Description, PostContent, DateCreated, DateModified, Author, IsPublished)
352	VALUES ('daf4bc0e-f4b7-4895-94b2-3b1413379d4b', 
353	'Welcome to BlogEngine.NET 1.6 using MySQL', 
354	'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',
355	'<p>If you see this post it means that BlogEngine.NET 1.6 is running with MySQL and the DbBlogProvider is configured correctly.</p>
356	<h2>Setup</h2>
357	<p>You are configured to have your user names and passwords stored in MySQL by default.  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.  You should also see a link to a Change Password page.  You should use this to change the default password right away.</p>
358	<h2>Write permissions</h2>
359	<p>Since you are using MySQL 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>
360	<h2>On the web </h2>
361	<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>
362	<p>Good luck and happy writing.</p>
363	<p>The BlogEngine.NET team</p>',
364	CURDATE(), 
365	CURDATE(),
366	'admin',
367	1);
368
369INSERT INTO be_PostCategory (PostID, CategoryID)
370	VALUES ('daf4bc0e-f4b7-4895-94b2-3b1413379d4b', 'ffc26b8b-7d45-46e3-b702-7198e8847e06');
371INSERT INTO be_PostTag (PostID, Tag)
372	VALUES ('daf4bc0e-f4b7-4895-94b2-3b1413379d4b', 'blog');
373INSERT INTO be_PostTag (PostID, Tag)
374	VALUES ('daf4bc0e-f4b7-4895-94b2-3b1413379d4b', 'welcome');
375	
376INSERT INTO be_Users (UserName, Password, LastLoginTime, EmailAddress)
377	VALUES ('Admin', '', CURDATE(), 'email@example.com');
378INSERT INTO be_Roles (Role) 
379	VALUES ('Administrators');
380INSERT INTO be_Roles (Role) 
381	VALUES ('Editors');
382INSERT INTO be_UserRoles (UserID, RoleID)
383VALUES
384( (SELECT UserID FROM be_Users WHERE UserName = 'Admin'), 
385(SELECT RoleID FROM be_Roles WHERE Role = 'Administrators'));
386
387INSERT INTO be_DataStoreSettings (ExtensionType, ExtensionId, Settings)
388VALUES (1, 'be_WIDGET_ZONE', '<?xml version="1.0" encoding="utf-16"?><WidgetData xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><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></WidgetData>');
389
390