installsql.php

来自「BLOG HOSTER---PHP & MYSQL Create Blogs 」· PHP 代码 · 共 314 行 · 第 1/5 页

<?

//######### DROP TABLES FIRST
mysql_query("DROP TABLE IF EXISTS bhost_admin");
mysql_query("DROP TABLE IF EXISTS bhost_categories");
mysql_query("DROP TABLE IF EXISTS bhost_comments");
mysql_query("DROP TABLE IF EXISTS bhost_entries");
mysql_query("DROP TABLE IF EXISTS bhost_entrycategories");
mysql_query("DROP TABLE IF EXISTS bhost_faq");
mysql_query("DROP TABLE IF EXISTS bhost_faqcat");
mysql_query("DROP TABLE IF EXISTS bhost_groups");
mysql_query("DROP TABLE IF EXISTS bhost_interests");
mysql_query("DROP TABLE IF EXISTS bhost_log");
mysql_query("DROP TABLE IF EXISTS bhost_members");
mysql_query("DROP TABLE IF EXISTS bhost_profile");
mysql_query("DROP TABLE IF EXISTS bhost_templates");
mysql_query("DROP TABLE IF EXISTS bhost_tips");
mysql_query("DROP TABLE IF EXISTS bhost_trackbacks");
mysql_query("DROP TABLE IF EXISTS bhost_uploads");
mysql_query("DROP TABLE IF EXISTS bhost_users");


//######### CREATE bhost_admin
mysql_query("CREATE TABLE `bhost_admin` (
  `username` varchar(255) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  `license` varchar(19) NOT NULL default '',
  `fname` varchar(255) NOT NULL default '',
  `lname` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `language` varchar(255) NOT NULL default '',
  `html_header` text NOT NULL,
  `html_footer` text NOT NULL,
  `faq_on` int(1) NOT NULL default '0',
  `allow_password` int(1) NOT NULL default '0',
  `signup_choosetemplate` int(1) NOT NULL default '0',
  `signup_templatedefault` int(8) NOT NULL default '0',
  `signup_emaildupeok` int(1) NOT NULL default '0',
  `signup_emaildomain` varchar(100) NOT NULL default '',
  `signup_emailverify` int(1) NOT NULL default '0',
  `signup_notify` int(1) NOT NULL default '0',
  `signup_timezone` varchar(5) NOT NULL default '',
  `signup_format_date` varchar(20) NOT NULL default '',
  `signup_format_time` varchar(20) NOT NULL default '',
  `signup_sendemail` int(1) NOT NULL default '0',
  `signup_terms` int(1) NOT NULL default '0',
  `signup_termstext` text NOT NULL,
  `signup_image` int(1) NOT NULL default '0',
  `comment_subject` varchar(255) NOT NULL default '',
  `comment_message` text NOT NULL,
  `welcome_subject` varchar(255) NOT NULL default '',
  `welcome_message` text NOT NULL,
  `verify_subject` varchar(255) NOT NULL default '',
  `verify_message` text NOT NULL,
  `user_password_subject` varchar(255) NOT NULL default '',
  `user_password_email` text NOT NULL,
  `forgot_subject` varchar(255) NOT NULL default '',
  `forgot_message` text NOT NULL,
  `field_website` int(1) NOT NULL default '0',
  `field_screenname` int(1) NOT NULL default '0',
  `field_gender` int(1) NOT NULL default '0',
  `field_birthday` int(1) NOT NULL default '0',
  `field_city` int(1) NOT NULL default '0',