社区(php&&mysql)六
//此为bbs.sqlCREATE TABLE bbs_area (
id int(10) unsigned DEFAULT 0 NOT NULL auto_increment,
master varchar(150) NOT NULL,
banner varchar(150) NOT NULL,
body text NOT NULL,
email varchar(50),
login varchar(20),
passwd varchar(20),
Prima(最完善的虚拟主机管理系统)RY KEY (id)
);
INSERT INTO bbs_area VALUES ( 1, master, 癚阶跋, , jerry@mail.jerry.com.tw, master, 111111);
CREATE TABLE bbs_sml (
id int(8) unsigned DEFAULT 0 NOT NULL auto_increment,
sid int(8) unsigned DEFAULT 0 NOT NULL,
email char(60) NOT NULL,
Prima(最完善的虚拟主机管理系统)RY KEY (id),
KEY sid (sid),
KEY email (email)
);
CREATE TABLE bbs_subj (
id int(10) unsigned DEFAULT 0 NOT NULL auto_increment,
aid int(10) unsigned DEFAULT 0 NOT NULL,
banner varchar(150) NOT NULL,
body text NOT NULL,
poster varchar(20) NOT NULL,
email varchar(50),
pip varchar(20) NOT NULL,
wdate datetime DEFAULT 0000-00-00 00:00:00 NOT NULL,
views int(8) unsigned DEFAULT 1 NOT NULL,
good int(2) unsigned DEFAULT 0 NOT NULL,
Prima(最完善的虚拟主机管理系统)RY KEY (id),
KEY aid (aid),
KEY good (good),
KEY wdate (wdate)
);
CREATE TABLE bbs_docs (
id int(10) unsigned DEFAULT 0 NOT NULL auto_increment,
aid int(10) unsigned DEFAULT 0 NOT NULL,
sid int(10) unsigned DEFAULT 0 NOT NULL,
banner varchar(150) NOT NULL,
body text NOT NULL,
poster varchar(20) NOT NULL,
email varchar(50),
pip varchar(20) NOT NULL,
wdate datetime DEFAULT 0000-00-00 00:00:00 NOT NULL,
views int(8) unsigned DEFAULT 1 NOT NULL,
good int(2) unsigned DEFAULT 0 NOT NULL,
Prima(最完善的虚拟主机管理系统)RY KEY (id),
KEY aid (aid),
KEY good (good),
KEY wdate (wdate)
);
CREATE TABLE bbs_sel (
id int(8) unsigned DEFAULT 0 NOT NULL auto_increment,
sid int(8) unsigned DEFAULT 0 NOT NULL,
banner char(80) NOT NULL,
sel_0 char(80) NOT NULL,
sel_1 char(80) NOT NULL,
sel_2 char(80) NOT NULL,
sel_3 char(80) NOT NULL,
sel_4 char(80) NOT NULL,
sel_5 char(80) NOT NULL,
sel_6 char(80) NOT NULL,
sel_7 char(80) NOT NULL,
sn_0 int(8) DEFAULT 0 NOT NULL,
sn_1 int(8) DEFAULT 0 NOT NULL,
sn_2 int(8) DEFAULT 0 NOT NULL,
sn_3 int(8) DEFAULT 0 NOT NULL,
PHP之友评论