instal_en.php

软件类别： PHP源码 / 文章管理 软件语言： 简体中文 授权方式： 商业版 文件大小： 308K

    pagesetid SMALLINT(4) DEFAULT '' NOT NULL,
    title VARCHAR(255) NOT NULL,
    description MEDIUMTEXT,
    onserver TINYINT(1) DEFAULT '' NOT NULL,
    PRIMARY KEY (id))";

  $query[news_pageset] = "CREATE TABLE news_pageset (
    id SMALLINT(5) NOT NULL auto_increment,
    title VARCHAR(255) NOT NULL,
    PRIMARY KEY (id))";

  $query[news_pm] = "CREATE TABLE news_pm (
    id SMALLINT(5) UNSIGNED NOT NULL auto_increment,
    fromuserid SMALLINT(5) UNSIGNED DEFAULT '' NOT NULL,
    touserid SMALLINT(5) UNSIGNED DEFAULT '' NOT NULL,
    folder TINYINT(1) DEFAULT '' NOT NULL,
    senddate INT(10) DEFAULT '' NOT NULL,
    readdate INT(10) DEFAULT '' NOT NULL,
    subject VARCHAR(255) NOT NULL,
    message MEDIUMTEXT NOT NULL,
    showsig TINYINT(1) DEFAULT '' NOT NULL,
    copyid SMALLINT(5) UNSIGNED DEFAULT '' NOT NULL,
    PRIMARY KEY (id))";

  $query[news_poll] = "CREATE TABLE news_poll (
    id SMALLINT(5) NOT NULL auto_increment,
    question VARCHAR(255) NOT NULL,
    option1 VARCHAR(255) NOT NULL,
    option2 VARCHAR(255) NOT NULL,
    option3 VARCHAR(255),
    option4 VARCHAR(255),
    option5 VARCHAR(255),
    option6 VARCHAR(255),
    option7 VARCHAR(255),
    option8 VARCHAR(255),
    option9 VARCHAR(255),
    option10 VARCHAR(255),
    totalvotes SMALLINT(5) DEFAULT '' NOT NULL,
    votes VARCHAR(255) NOT NULL,
    display VARCHAR(255) NOT NULL,
    PRIMARY KEY (id))";

  $query[news_pollvote] = "CREATE TABLE news_pollvote (
    id INT(10) UNSIGNED NOT NULL auto_increment,
    pollid INT(10) DEFAULT '' NOT NULL,
    userid INT(10) DEFAULT '' NOT NULL,
    votedate INT(10) DEFAULT '' NOT NULL,
    voteoption INT(10) DEFAULT '' NOT NULL,
    PRIMARY KEY (id),
    KEY pollid (pollid,userid))";

  $query[news_profilefield] = "CREATE TABLE news_profilefield (
    id SMALLINT(5) NOT NULL auto_increment,
    title VARCHAR(255) NOT NULL,
    description MEDIUMTEXT NOT NULL,
    required TINYINT(1) DEFAULT '' NOT NULL,
    hidden TINYINT(1) DEFAULT '' NOT NULL,
    editable TINYINT(1) DEFAULT '' NOT NULL,
    displayorder SMALLINT(5) DEFAULT '' NOT NULL,
    maxlength SMALLINT(5) DEFAULT '' NOT NULL,
    size SMALLINT(5) DEFAULT '' NOT NULL,
    PRIMARY KEY (id))";

  $query[news_referer] = "CREATE TABLE news_referer (
    name varchar(255) NOT NULL default '',
    value int(10) unsigned NOT NULL default '0',
    PRIMARY KEY (name))";

  $query[news_smilie] = "CREATE TABLE news_smilie (
    id SMALLINT(5) UNSIGNED NOT NULL auto_increment,
    title CHAR(100) NOT NULL,
    smilietext CHAR(100) NOT NULL,
    smiliepath CHAR(100) NOT NULL,
    PRIMARY KEY (id))";

  $query[news_staff] = "CREATE TABLE news_staff (
    id SMALLINT(5) NOT NULL auto_increment,
    userid SMALLINT(5) DEFAULT '' NOT NULL,
    job VARCHAR(100) NOT NULL,
    newsposts SMALLINT(5) DEFAULT '' NOT NULL,
    caneditallnews SMALLINT(1) DEFAULT '' NOT NULL,
    caneditallcomments SMALLINT(1) DEFAULT '' NOT NULL,
    canmakesticky TINYINT(1) DEFAULT '' NOT NULL,
    caneditusers TINYINT(1) DEFAULT '' NOT NULL,
    caneditprofilefields TINYINT(1) DEFAULT '' NOT NULL,
    caneditstaff SMALLINT(1) DEFAULT '' NOT NULL,
    caneditcategories SMALLINT(1) DEFAULT '' NOT NULL,
    caneditarticles TINYINT(1) DEFAULT '' NOT NULL,
    caneditsmilies TINYINT(1) DEFAULT '' NOT NULL,
    caneditpolls SMALLINT(1) DEFAULT '' NOT NULL,
    candeletelogos TINYINT(1) DEFAULT '' NOT NULL,
    caneditmodules TINYINT(1) DEFAULT '' NOT NULL,
    caneditthemes SMALLINT(1) DEFAULT '' NOT NULL,
    caneditoptions TINYINT(1) DEFAULT '' NOT NULL,
    canmaintaindb TINYINT(1) DEFAULT '' NOT NULL,
    canviewlog SMALLINT(1) DEFAULT '' NOT NULL,
    canpost_1 SMALLINT(1) DEFAULT '' NOT NULL,
    PRIMARY KEY (id),
    KEY userid (userid))";

  $query[news_stats] = "CREATE TABLE news_stats (
    lastupdate int(10) unsigned NOT NULL default '0',
    uniquestotal int(10) unsigned NOT NULL default '0',
    uniquestoday int(10) unsigned NOT NULL default '0',
    maxusersonline int(10) unsigned NOT NULL default '0')";

  $query[news_style] = "CREATE TABLE news_style (
    id SMALLINT(5) NOT NULL auto_increment,
    stylesetid SMALLINT(5) DEFAULT '0' NOT NULL,
    varname TEXT DEFAULT '' NOT NULL,
    value TEXT DEFAULT '' NOT NULL,
    PRIMARY KEY (id),
    KEY stylesetid (stylesetid))";

  $query[news_styleset] = "CREATE TABLE news_styleset (
    id SMALLINT(5) NOT NULL auto_increment,
    title VARCHAR(255) DEFAULT '' NOT NULL,
    PRIMARY KEY (id))";

  $query[news_subscribe] = "CREATE TABLE news_subscribe (
    id MEDIUMINT(10) NOT NULL auto_increment,
    newsid MEDIUMINT(10) DEFAULT '' NOT NULL,
    userid MEDIUMINT(10) DEFAULT '' NOT NULL,
    lastview INT(10) DEFAULT '' NOT NULL,
    emailupdate TINYINT(1) DEFAULT '' NOT NULL,
    PRIMARY KEY (id),
    KEY newsid (newsid,userid))";

  $query[news_theme] = "CREATE TABLE news_theme (
    id SMALLINT(5) NOT NULL auto_increment,
    title VARCHAR(255) DEFAULT '' NOT NULL,
    pagesetid SMALLINT(5) DEFAULT '0' NOT NULL,
    stylesetid SMALLINT(5) DEFAULT '0' NOT NULL,
    allowselect TINYINT(1) DEFAULT '1' NOT NULL,
    PRIMARY KEY (id))";

  $query[news_user] = "CREATE TABLE news_user (
    userid INT(10) UNSIGNED NOT NULL auto_increment,
    username VARCHAR(50) NOT NULL,
    password VARCHAR(50) NOT NULL,
    email VARCHAR(50) NOT NULL,
    showemail TINYINT(1) DEFAULT '' NOT NULL,
    homepage VARCHAR(100) NOT NULL,
    oicq VARCHAR(20) NOT NULL,
    aim VARCHAR(20) NOT NULL,
    yahoo VARCHAR(20) NOT NULL,
    signature MEDIUMTEXT NOT NULL,
    activated TINYINT(1) DEFAULT '' NOT NULL,
    moderated TINYINT(1) DEFAULT '' NOT NULL,
    joindate INT(10) DEFAULT '' NOT NULL,
    posts SMALLINT(5) UNSIGNED DEFAULT '' NOT NULL,
    emailnotification TINYINT(1) DEFAULT '' NOT NULL,
    commentdefault TINYINT(1) DEFAULT '' NOT NULL,
    viewsigs TINYINT(1) DEFAULT '' NOT NULL,
    allowpm TINYINT(1) DEFAULT '' NOT NULL,
    emailpm TINYINT(1) DEFAULT '' NOT NULL,
    isbanned TINYINT(1) DEFAULT '' NOT NULL,
    PRIMARY KEY (userid))";

  $query[news_useragent] = "CREATE TABLE news_useragent (
    name VARCHAR(255) DEFAULT '' NOT NULL,
    type VARCHAR(15) DEFAULT '' NOT NULL,
    value INT(10) DEFAULT '' NOT NULL,
    PRIMARY KEY (name,type))";

  $query[news_userfield] = "CREATE TABLE news_userfield (
    userid INT(10) DEFAULT '0' NOT NULL,
    field1 VARCHAR(250) DEFAULT ''NOT NULL,
    field2 VARCHAR(250) DEFAULT ''NOT NULL,
    field3 VARCHAR(255) DEFAULT ''NOT NULL,
    field4 VARCHAR(255) DEFAULT ''NOT NULL,
    PRIMARY KEY (userid),
    UNIQUE KEY id (userid))";

  echo "  <tr>\n    <td>Installing the VirtuaNews tables:</tr>\n";

  while (list($table_name,$query_text) = each($query)) {
    query($query_text,0);
    if (geterrno() == 0) {
      echo "  <tr>\n    <td>Creating table: $table_name</td>\n  </tr>\n";
    } else {
      echo "  <tr>\n    <td>Error Creating table: $table_name<br>Error Number: ".geterrno()."<br>Error Description: ".geterrordesc()."</td>\n  </tr>\n";
      $error = 1;
    }
  }

  if ($error) {
      echo "  <tr>\n    <td>There has been an error creating one or more of the tables.  Please examine this error and only continue if you are sure it will not effect the install process.  Click <a href=\"install.php?step=5\">here</a> to continue</td>\n  </tr>\n";
  } else {
      echo "  <tr>\n    <td>All tables created correctly, please click <a href=\"install.php?step=5\">here</a> to continue</tr>\n";
  }

}

if ($step == 5) {