社区(php&&mysql)六
发表于:2007-07-01来源:作者:点击数:
标签:
//此为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), PRI
//此为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,
good int(2) unsigned DEFAULT @#0@# NOT NULL,
PRIMARY 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,
PRIMARY 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,
sn_4 int(8) DEFAULT @#0@# NOT NULL,
sn_5 int(8) DEFAULT @#0@# NOT NULL,
sn_6 int(8) DEFAULT @#0@# NOT NULL,
sn_7 int(8) DEFAULT @#0@# NOT NULL,
PRIMARY KEY (id)
);
//此为sql.
php3
<?
$sql[@#user@#]="root";
$sql[@#passwd@#]="戈?畐盞絏";
$sql[@#db@#]="恶???戈?畐?嘿";
$sql[@#host@#]="localhost";
?>
原文转自:http://www.ltesting.net