1DROP TABLE IF EXISTS be_categories;
  2CREATE TABLE  be_categories (
  3  CategoryID varchar(36) NOT NULL default '',
  4  CategoryName varchar(50) default NULL,
  5  Description varchar(200) default NULL,
  6  PRIMARY KEY  (CategoryID)
  7);
  8
  9DROP TABLE IF EXISTS be_pages;
 10CREATE TABLE  be_pages (
 11  PageID varchar(36) NOT NULL default '',
 12  Title varchar(255) NOT NULL default '',
 13  Description text,
 14  PageContent longtext,
 15  Keywords text,
 16  DateCreated datetime default NULL,
 17  DateModified datetime default NULL,
 18  IsPublished tinyint(1) default NULL,
 19  IsFrontPage tinyint(1) default NULL,
 20  Parent varchar(64) default NULL,
 21  ShowInList tinyint(1) default NULL,
 22  Slug varchar(255) default NULL,
 23  PRIMARY KEY  (PageID)
 24);
 25
 26DROP TABLE IF EXISTS be_pingservice;
 27CREATE TABLE  be_pingservice (
 28  PingServiceID int(10) unsigned NOT NULL auto_increment,
 29  Link varchar(255) default NULL,
 30  PRIMARY KEY  (PingServiceID)
 31);
 32
 33DROP TABLE IF EXISTS be_postcategory;
 34CREATE TABLE  be_postcategory (
 35  PostCategoryID int(10) unsigned NOT NULL auto_increment,
 36  PostID varchar(36) NOT NULL default '',
 37  CategoryID varchar(36) NOT NULL default '',
 38  PRIMARY KEY  (PostCategoryID)
 39);
 40
 41DROP TABLE IF EXISTS be_postcomment;
 42CREATE TABLE  be_postcomment (
 43  PostCommentID varchar(36) NOT NULL default '',
 44  PostID varchar(36) NOT NULL default '',
 45  CommentDate datetime NOT NULL default '0000-00-00 00:00:00',
 46  Author varchar(255) NOT NULL default '',
 47  Email varchar(255) NOT NULL default '',
 48  Website varchar(255) NOT NULL default '',
 49  Comment text NOT NULL,
 50  Country varchar(255) NOT NULL default '',
 51  Ip varchar(50) NOT NULL default '',
 52  IsApproved tinyint(1) NOT NULL default '0',
 53  PRIMARY KEY  (PostCommentID)
 54);
 55
 56DROP TABLE IF EXISTS be_postnotify;
 57CREATE TABLE  be_postnotify (
 58  PostNotifyID int(10) unsigned NOT NULL auto_increment,
 59  PostID varchar(36) NOT NULL default '',
 60  NotifyAddress varchar(255) default NULL,
 61  PRIMARY KEY  (PostNotifyID)
 62);
 63
 64DROP TABLE IF EXISTS be_posts;
 65CREATE TABLE  be_posts (
 66  PostID varchar(36) NOT NULL default '',
 67  Title varchar(255) NOT NULL default '',
 68  Description text NOT NULL,
 69  PostContent longtext NOT NULL,
 70  DateCreated datetime NOT NULL default '0000-00-00 00:00:00',
 71  DateModified datetime NOT NULL default '0000-00-00 00:00:00',
 72  Author varchar(50) NOT NULL default '',
 73  IsPublished tinyint(1) NOT NULL default '0',
 74  IsCommentEnabled tinyint(1) NOT NULL default '0',
 75  Raters int(10) unsigned NOT NULL default '0',
 76  Rating float NOT NULL default '0',
 77  Slug varchar(255) NOT NULL default '',
 78  PRIMARY KEY  (PostID)
 79);
 80
 81DROP TABLE IF EXISTS be_posttag;
 82CREATE TABLE  be_posttag (
 83  PostTagID int(10) unsigned NOT NULL auto_increment,
 84  PostID varchar(36) NOT NULL default '',
 85  Tag varchar(50) default NULL,
 86  PRIMARY KEY  (PostTagID)
 87);
 88
 89DROP TABLE IF EXISTS be_settings;
 90CREATE TABLE  be_settings (
 91  SettingName varchar(50) NOT NULL,
 92  SettingValue text,
 93  PRIMARY KEY  (SettingName)
 94);
 95
 96INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('alternatefeedurl', '');
 97INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('authorname', 'My name');
 98INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('avatar', 'combine');
 99INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('blogrollmaxlength', '23');
100INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('blogrollupdateminutes', '60');
101INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('blogrollvisibleposts', '3');
102INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('contactformmessage', '<p>我们会尽快回复您的邮件。</p>');
103INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('contactthankmessage', '<h1>谢谢！</h1><p>邮件已经发出。</p>');
104INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('culture', 'zh-CN');
105INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('dayscommentsareenabled', '0');
106INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('description', 'Short description of the blog');
107INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('displaycommentsonrecentposts', 'True');
108INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('displayratingsonrecentposts', 'True');
109INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('email', 'user@example.com');
110INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('emailsubjectprefix', 'Weblog');
111INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('enablecommentsearch', 'True');
112INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('enablecommentsmoderation', 'True');
113INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('enablecontactattachments', 'True');
114INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('enablecountryincomments', 'True');
115INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('enablehttpcompression', 'True');
116INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('enableopensearch', 'True');
117INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('enablepingbackreceive', 'True');
118INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('enablepingbacksend', 'True');
119INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('enablerating', 'True');
120INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('enablereferrertracking', 'False');
121INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('enablerelatedposts', 'True');
122INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('enablessl', 'False');
123INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('enabletrackbackreceive', 'True');
124INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('enabletrackbacksend', 'True');
125INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('endorsement', 'http://www.iusers.com.cn/syndication.axd');
126INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('fileextension', '.aspx');
127INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('geocodinglatitude', '0');
128INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('geocodinglongitude', '0');
129INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('handlewwwsubdomain', '');
130INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('htmlheader', '');
131INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('iscocommentenabled', 'False');
132INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('iscommentsenabled', 'True');
133INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('language', 'zh-CN');
134INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('name', 'Name of the blog');
135INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('numberofrecentcomments', '10');
136INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('numberofrecentposts', '10');
137INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('postsperfeed', '15');
138INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('postsperpage', '10');
139INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('removewhitespaceinstylesheets', 'True');
140INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('searchbuttontext', '搜索');
141INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('searchcommentlabeltext', '搜索评论');
142INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('searchdefaulttext', '关键字');
143INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('sendmailoncomment', 'True');
144INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('showdescriptioninpostlist', 'False');
145INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('showlivepreview', 'True');
146INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('showpostnavigation', 'True');
147INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('smtppassword', 'password');
148INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('smtpserver', 'mail.example.dk');
149INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('smtpserverport', '25');
150INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('smtpusername', 'user@example.com');
151INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('storagelocation', '~/App_Data/');
152INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('syndicationformat', 'Rss');
153INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('theme', 'Default');
154INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('timestamppostlinks', 'True');
155INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('timezone', '0');
156INSERT INTO be_Settings (SettingName, SettingValue)    VALUES ('trackingscript', '');