   user :  user
----------------------------------------------------------

CREATE TABLE user (
   userid         varchar(16) NOT NULL,            //  ûID       KEY
   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(12),                      //  ʱ  ( ʱ )
   sign           tinyint(1) UNSIGNED DEFAULT 0,   //  ǩ
   PRIMARY KEY (userid)
);



   user :  user_attr
----------------------------------------------------------

CREATE TABLE user_attr (
   userid         varchar(16) NOT NULL,            //  ûID      KEY
   status         tinyint(1) UNSIGNED DEFAULT 0,   //  ǰ״̬ 
   count          int,                             //  վ
   level          int,                             //  ȼ
   exper_cent     int,                             //  
   act_cent       int,                             //  
   life_cent      int,                             //   
   last_time      varchar(12) NOT NULL,             //  ϴνվʱ  ( ʱ )
   last_ip        varchar(30)                      //  ϴνվIP
   article        int,                             //  ƪ 
   birthday       varchar(10),                     //   
   hei            tinyint(3) UNSIGNED,             //   
   wei            tinyint(2) UNSIGNED,             //  
   hobby          varchar(30),                     //  Ⱥ
   icq            varchar(30),                     //  ICQ
   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,                        //  ǩA
   signature2     tinytext,                        //  ǩB
   signature3     tinytext,                        //  ǩC
   readme         text,                            //  ˵
   PRIMARY KEY (userid)
);


   online :   online
----------------------------------------------------------

CREATE TABLE online (
   id             varchar(16) NOT NULL,            //  ID       KEY
   userid         varchar(16) NOT NULL,            //  ûID
   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(12) NOT NULL,             //  ϴμʱ  ( ʱ )
   login_time     varchar(12) NOT NULL,             //  վʱ  ( ʱ )
   login_ip       varchar(30),                     //  վIP
   PRIMARY KEY (id)
);


   bbs :       bbs
----------------------------------------------------------

CREATE TABLE bbs (
   bbsid          varchar(16) NOT NULL,            //  ID           KEY
   mainid         varchar(16) NOT NULL,            //  ID
   blockid        varchar(16),                     //  ID
   mood           tinyint(2) UNSIGNED DEFAULT 0,   //  
   title          varchar(100),                    //  ±
   content        text,                            //  
   size           int,                             //  ֽ
   writer         varchar(16) NOT NULL,            //  
   signature      tinytext,                        //  ǩ
   writetime      varchar(12) 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)
);


   :       block
----------------------------------------------------------

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