table.sql

这是使用ＰＨＰ编程的虚拟社区ＭySQL的简易版

CREATE TABLE user (
   userid         varchar(16) NOT NULL,
   nickname       varchar(16) NOT NULL,
   sex            tinyint(1) UNSIGNED DEFAULT 0,
   realname       varchar(16) NOT NULL,
   password       varchar(16) NOT NULL,
   idnumber       varchar(20) NOT NULL,
   address        varchar(40),
   phone          varchar(20),
   email          varchar(30) NOT NULL,
   createtime     varchar(9),
   sign           tinyint(1) UNSIGNED DEFAULT 0,
   PRIMARY KEY (userid)
);



CREATE TABLE user_attr (
   userid         varchar(16) NOT NULL,
   status         tinyint(1) UNSIGNED DEFAULT 0,
   count          int,
   level          int,
   exper_cent     int,
   act_cent       int,
   life_cent      int,
   last_time      varchar(9) NOT NULL,
   last_ip        varchar(30),
   article        int,
   birthday       varchar(10),
   hei            tinyint(3) UNSIGNED,
   wei            tinyint(2) UNSIGNED,
   hobby          varchar(30),
   icq            varchar(30),
   homepage       varchar(30),
   merriage       tinyint(1) UNSIGNED DEFAULT 0,
   edu            tinyint(1) UNSIGNED DEFAULT 0,
   school         varchar(30),
   music          varchar(30),
   book           varchar(30),
   best           varchar(30),
   memory         varchar(30),
   photo          tinyint(1) UNSIGNED DEFAULT 0,
   signature1     tinytext,
   signature2     tinytext,
   signature3     tinytext,
   readme         text,
   PRIMARY KEY (userid)
);



CREATE TABLE online (
   id             varchar(16) NOT NULL,
   userid         varchar(16) NOT NULL,
   nickname       varchar(16) NOT NULL,
   sex            tinyint(1) UNSIGNED DEFAULT 0,
   email          varchar(30) NOT NULL,
   sign           tinyint(1) UNSIGNED DEFAULT 0,
   old_time       varchar(9) NOT NULL,
   login_time     varchar(9) NOT NULL,
   login_ip       varchar(30),
   PRIMARY KEY (id)
);



CREATE TABLE bbs (
   bbsid          varchar(16) NOT NULL,
   mainid         varchar(16) NOT NULL,
   blockid        varchar(16),
   mood           tinyint(2) UNSIGNED DEFAULT 0,
   title          varchar(100),
   content        text,
   size           int,
   writer         varchar(16) NOT NULL,
   signature      tinytext,
   writetime      varchar(9) NOT NULL,
   read_value     int,
   sub_value      int,
   hot_value      int,
   bbsmail        tinyint(1) UNSIGNED DEFAULT 0,
   bbssub         tinyint(1) UNSIGNED DEFAULT 0,
   bbsok          tinyint(1) UNSIGNED DEFAULT 0,
   bbsprime       tinyint(1) UNSIGNED DEFAULT 0,
   PRIMARY KEY (bbsid)
);



CREATE TABLE block (
   blockid        varchar(16) NOT NULL,
   classid        varchar(16),
   english        varchar(16) NOT NULL,
   chinese        varchar(16) NOT NULL,
   descript       varchar(30),
   admin          varchar(16),
   sysop          varchar(16),
   op             tinytext,
   blockok        tinyint(1) UNSIGNED DEFAULT 0,
   PRIMARY KEY (blockid)
);