//此为bbs.sql
CREATE 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),
PRIMARY 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,
PRIMARY 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,
&nb
CREATE 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),
PRIMARY 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,
PRIMARY 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,
&nb
| 对此文章发表了评论 |
