installsql.php

一个全功能的国外博客商业程序

)
");


//######### INSERT DEFAULTS INTO bhost_faqcat
mysql_query("INSERT INTO `bhost_faqcat` VALUES (1, 2, 'My Profile')");
mysql_query("INSERT INTO `bhost_faqcat` VALUES (2, 1, 'My Account')");
mysql_query("INSERT INTO `bhost_faqcat` VALUES (3, 3, 'Weblog Templates')");



//######### CREATE bhost_groups
mysql_query("CREATE TABLE `bhost_groups` (
  `g_id` int(8) NOT NULL auto_increment,
  `group_name` varchar(255) NOT NULL default '',
  `default_group` int(1) NOT NULL default '0',
  `allow_comments` int(1) NOT NULL default '0',
  `allow_members` int(1) NOT NULL default '0',
  `allow_privacy` int(1) NOT NULL default '0',
  `allow_mailinglist` int(1) NOT NULL default '0',
  `allow_rss` int(1) NOT NULL default '0',
  `allow_uploads` int(1) NOT NULL default '0',
  `uploads_space` varchar(10) NOT NULL default '',
  `uploads_extensions` varchar(255) NOT NULL default '',
  `allow_banning` int(1) NOT NULL default '0',
  `allow_pinging` int(1) NOT NULL default '0',
  `allow_trackback` int(1) NOT NULL default '0',
  `allow_entry_cat` int(1) NOT NULL default '0',
  `allow_edittemplate` int(1) NOT NULL default '0',
  `templates` text NOT NULL,
  `allow_language` int(1) NOT NULL default '0',
  `show_ad` int(1) NOT NULL default '0',
  `html_ad` text NOT NULL,
  `html_ad_bottom` text NOT NULL,
  `announcements` text,
  PRIMARY KEY  (`g_id`)
)
");


//######### INSERT DEFAULTS INTO bhost_groups
mysql_query("INSERT INTO `bhost_groups` VALUES (1, 'Normal Users', 1, 1, 1, 1, 1, 1, 1, '1024', 'jpeg,jpg,gif,bmp,png', 0, 1, 0, 1, 1, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27', 1, 0, '', '', '')");


//######### CREATE bhost_interests
mysql_query("CREATE TABLE `bhost_interests` (
  `int_id` int(9) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`int_id`)
)
");


//######### CREATE bhost_log
mysql_query("CREATE TABLE `bhost_log` (
  `l_id` int(8) NOT NULL auto_increment,
  `username` varchar(40) NOT NULL default '',
  `password` varchar(40) NOT NULL default '',
  `result` int(1) NOT NULL default '0',
  `ipaddress` varchar(20) NOT NULL default '',
  `date` int(14) NOT NULL default '0',
  PRIMARY KEY  (`l_id`)
)