ṹ



mysql> describe board;
+-----------+--------------+------+-----+---------+----------------+
| Field     | Type         | Null | Key | Default | Extra          |
+-----------+--------------+------+-----+---------+----------------+
| id        | int(11)      |      | PRI | NULL    | auto_increment |
| btable    | varchar(20)  |      |     | btable1 |                |
| name      | varchar(30)  |      |     |         |                |
| logo      | varchar(100) | YES  |     | NULL    |                |
| inform    | varchar(160) | YES  |     | NULL    |                |
| focus     | varchar(200) | YES  |     | NULL    |                |
| boardmast | varchar(255) |      |     |         |                |
| page      | varchar(80)  |      |     |         |                |
+-----------+--------------+------+-----+---------+----------------+


mysql> describe btable1;
+----------------+--------------+------+-----+---------------------+----------------+
| Field          | Type         | Null | Key | Default             | Extra          |
+----------------+--------------+------+-----+---------------------+----------------+
| id             | int(11)      | NO   | PRI | NULL                | auto_increment |
| boardid        | int(40)      | NO   |     | 0                   |                |
| title          | varchar(50)  | NO   |     |                     |                |
| clas           | varchar(2)   | NO   |     | a                   |                |
| txt            | text         | NO   |     |                     |                |
| up             | char(2)      | NO   |     | n                   |                |
| super          | char(2)      | NO   |     | n                   |                |
| recommendation | char(2)      | NO   |     | n                   |                |
| locked         | char(2)      | YES  |     | n                   |                |
| userid         | varchar(20)  | YES  |     | NULL                |                |
| usname         | varchar(20)  | NO   |     |                     |                |
| lastid         | varchar(20)  | YES  |     | NULL                |                |
| lastname       | varchar(20)  | YES  |     | NULL                |                |
| tim            | datetime     | NO   |     | 0000-00-00 00:00:00 |                |
| editime        | datetime     | NO   |     | 0000-00-00 00:00:00 |                |
| ip             | varchar(15)  | YES  |     | NULL                |                |
| readtimes      | int(11)      | YES  |     | 0                   |                |
| retimes        | int(11)      | NO   |     | 0                   |                |
| lastretime     | datetime     | NO   |     | 0000-00-00 00:00:00 |                |
| penname        | varchar(250) | YES  |     | NULL                |                |
+----------------+--------------+------+-----+---------------------+----------------+
20 rows in set (0.00 sec)

mysql> describe friend;
+------------+-------------+------+-----+---------+----------------+
| Field      | Type        | Null | Key | Default | Extra          |
+------------+-------------+------+-----+---------+----------------+
| id         | int(11)     | NO   | PRI | NULL    | auto_increment |
| userid     | varchar(20) | NO   |     |         |                |
| username   | varchar(20) | NO   |     |         |                |
| friendid   | varchar(20) | NO   |     |         |                |
| friendname | varchar(20) | NO   |     |         |                |
| isfriend   | char(2)     | NO   |     | y       |                |
+------------+-------------+------+-----+---------+----------------+


mysql> describe gift;
+--------+-------------+------+-----+---------+-------+
| Field  | Type        | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| userid | varchar(20) | NO   | PRI |         |       |
| flower | int(11)     | NO   |     | 0       |       |
| flcom  | text        | YES  |     | NULL    |       |
+--------+-------------+------+-----+---------+-------+



mysql> describe massage;
+--------+-------------+------+-----+---------------------+----------------+
| Field  | Type        | Null | Key | Default             | Extra          |
+--------+-------------+------+-----+---------------------+----------------+
| id     | int(11)     | NO   | PRI | NULL                | auto_increment |
| toid   | varchar(20) | NO   |     |                     |                |
| toname | varchar(20) | NO   |     |                     |                |
| frid   | varchar(20) | NO   |     |                     |                |
| frname | varchar(20) | NO   |     |                     |                |
| title  | varchar(30) | NO   |     |                     |                |
| txt    | text        | NO   |     |                     |                |
| time   | datetime    | NO   |     | 0000-00-00 00:00:00 |                |
| isread | int(11)     | YES  |     | 0                   |                |
+--------+-------------+------+-----+---------------------+----------------+


mysql> describe numb1;
+--------+-------------+------+-----+---------------------+-------+
| Field  | Type        | Null | Key | Default             | Extra |
+--------+-------------+------+-----+---------------------+-------+
| userid | varchar(20) | NO   | PRI |                     |       |
| pw     | varchar(20) | NO   |     |                     |       |
| mail   | varchar(40) | NO   |     |                     |       |
| tim    | datetime    | NO   |     | 0000-00-00 00:00:00 |       |
+--------+-------------+------+-----+---------------------+-------+


mysql> describe numb1;
+--------+-------------+------+-----+---------------------+-------+
| Field  | Type        | Null | Key | Default             | Extra |
+--------+-------------+------+-----+---------------------+-------+
| userid | varchar(20) | NO   | PRI |                     |       |
| pw     | varchar(20) | NO   |     |                     |       |
| mail   | varchar(40) | NO   |     |                     |       |
| tim    | datetime    | NO   |     | 0000-00-00 00:00:00 |       |
+--------+-------------+------+-----+---------------------+-------+



mysql> describe online;
+----------+--------------+------+-----+---------------------+-------+
| Field    | Type         | Null | Key | Default             | Extra |
+----------+--------------+------+-----+---------------------+-------+
| userid   | varchar(20)  | NO   | PRI |                     |       |
| ontims   | int(11)      | YES  |     | 0                   |       |
| txt      | int(11)      | YES  |     | 0                   |       |
| re       | int(11)      | YES  |     | 0                   |       |
| point    | int(11)      | YES  |     | 0                   |       |
| popu     | int(11)      | NO   |     | 0                   |       |
| suptxt   | int(11)      | YES  |     | 0                   |       |
| recomtxt | int(11)      | NO   |     | 0                   |       |
| lastip   | varchar(15)  | YES  |     | NULL                |       |
| lastim   | datetime     | YES  |     | 0000-00-00 00:00:00 |       |
| penname1 | varchar(250) | YES  |     | NULL                |       |
| penname2 | varchar(250) | YES  |     | NULL                |       |
+----------+--------------+------+-----+---------------------+-------+


mysql>  describe rebtable1;
+----------+--------------+------+-----+---------------------+----------------+
| Field    | Type         | Null | Key | Default             | Extra          |
+----------+--------------+------+-----+---------------------+----------------+
| id       | int(11)      | NO   | PRI | NULL                | auto_increment |
| bbsid    | int(11)      | YES  |     | 0                   |                |
| boardid  | int(11)      | NO   |     | 0                   |                |
| retitle  | varchar(40)  | NO   |     |                     |                |
| txt      | text         | NO   |     |                     |                |
| userid   | varchar(20)  | NO   |     |                     |                |
| username | varchar(20)  | NO   |     |                     |                |
| time     | datetime     | NO   |     | 0000-00-00 00:00:00 |                |
| editime  | datetime     | YES  |     | 0000-00-00 00:00:00 |                |
| ip       | varchar(15)  | NO   |     |                     |                |
| penname  | varchar(250) | YES  |     | NULL                |                |
+----------+--------------+------+-----+---------------------+----------------+


mysql>  describe user;
+---------------+--------------+------+-----+------------+-------+
| Field         | Type         | Null | Key | Default    | Extra |
+---------------+--------------+------+-----+------------+-------+
| userid        | varchar(20)  | NO   | PRI |            |       |
| step          | int(11)      | NO   |     | 1          |       |
| root          | varchar(75)  | YES  |     | NULL       |       |
| question      | varchar(30)  | NO   |     |            |       |
| answer        | varchar(30)  | NO   |     |            |       |
| face          | varchar(50)  | YES  |     | NULL       |       |
| name          | varchar(20)  | YES  |     | NULL       |       |
| sex           | varchar(5)   | YES  |     | NULL       |       |
| birth         | varchar(10)  | YES  |     | 2004-12-02 |       |
| mail          | varchar(5)   | YES  |     | NULL       |       |
| qq            | varchar(15)  | YES  |     | NULL       |       |
| web           | varchar(30)  | YES  |     | NULL       |       |
| tel           | varchar(15)  | YES  |     | NULL       |       |
| comefrom      | varchar(20)  | YES  |     | NULL       |       |
| job           | varchar(20)  | YES  |     | NULL       |       |
| love          | varchar(30)  | YES  |     | NULL       |       |
| aboutme       | varchar(200) | YES  |     | NULL       |       |
| refusemassage | varchar(2)   | NO   |     | n          |       |
+---------------+--------------+------+-----+------------+-------+
