PageRenderTime 41ms CodeModel.GetById 1ms app.highlight 36ms RepoModel.GetById 1ms app.codeStats 0ms

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

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