# phpMyAdmin MySQL-Dump
# http://phpwizard.net/phpMyAdmin/
#
# 主机: localhost 数据库 : Forum
# --------------------------------------------------------
#
# 数据表的结构 'forum'
#
CREATE TABLE forum (
id int(10) NOT NULL auto_increment,
writer varchar(15) NOT NULL,
title varchar(40) NOT NULL,
express varchar(4) NOT NULL,
comment text NOT NULL,
judge char(1) NOT NULL,
click varchar(10) NOT NULL,
renumber varchar(10) NOT NULL,
father varchar(10),
date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
ip varchar(15) NOT NULL,
laster varchar(15) NOT NULL,
popular char(1) NOT NULL,
active char(1) NOT NULL,
agreement varchar(30) NOT NULL,
PRIMARY KEY (id),
KEY judge (judge)
);
# --------------------------------------------------------
#
# 数据表的结构 'user'
#
CREATE TABLE user (
id int(10) NOT NULL auto_increment,
username varchar(15) NOT NULL,
userpsd varchar(15) NOT NULL,
email varchar(40) NOT NULL,
sex char(1) NOT NULL,
work varchar(30),
provience varchar(6) NOT NULL,
photo varchar(6) NOT NULL,
interest varchar(20),
oicq varchar(10),
homepage varchar(40),
introduce text NOT NULL,
mark text,
date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
send int(10),
re int(10),
lastvistor datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
PRIMARY KEY (id)
);
|