Community (Php&&mysql) six _php Foundation

This is Bbs.sql

CREATE TABLE Bbs_area (
ID Int (a) unsigned DEFAULT ' 0 ' not NULL auto_increment,
Master varchar not NULL,
Banner varchar () not NULL,
Body text is not NULL,
Email varchar (50),
Login varchar (20),
passwd varchar (20),
PRIMARY KEY (ID)
);

INSERT into Bbs_area VALUES (' 1 ', ' master ', ' 癚 order  ', ', ' 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 not NULL,
PRIMARY KEY (ID),
KEY sid (SID),
KEY Email (email)
);

CREATE TABLE BBS_SUBJ (
ID Int (a) unsigned DEFAULT ' 0 ' not NULL auto_increment,
aid Int (a) unsigned DEFAULT ' 0 ' not NULL,
Banner varchar () not NULL,
Body text is not NULL,
Poster varchar is not NULL,
Email varchar (50),
Pip varchar is not NULL,
wdate datetime DEFAULT ' 0000-00-00 00:00:00 ' not NULL,
The views int (8) unsigned DEFAULT ' 1 ' is 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 (a) unsigned DEFAULT ' 0 ' not NULL auto_increment,
aid Int (a) unsigned DEFAULT ' 0 ' not NULL,
Sid Int (a) unsigned DEFAULT ' 0 ' not NULL,
Banner varchar () not NULL,
Body text is not NULL,
Poster varchar is not NULL,
Email varchar (50),
Pip varchar is not NULL,
wdate datetime DEFAULT ' 0000-00-00 00:00:00 ' not NULL,
The views int (8) unsigned DEFAULT ' 1 ' is 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 (not NULL),
Sel_0 char (not NULL),
Sel_1 char (not NULL),
Sel_2 char (not NULL),
Sel_3 char (not NULL),
Sel_4 char (not NULL),
Sel_5 char (not NULL),
Sel_6 char (not NULL),
Sel_7 char (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)
);




This is SQL.PHP3


?
$sql [' User ']= ' root ';
$sql [' passwd ']= "畐 盞 絏";
$sql [' db ']=]  畐  hey ";
$sql [' Host ']= "localhost";

?>