PageRenderTime 104ms CodeModel.GetById 2ms app.highlight 96ms RepoModel.GetById 1ms app.codeStats 0ms

/BlogEngine/BlogEngine.NET/setup/MySQL/MySQLSetup2.5.0.sql

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