//´ËΪ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', '°Q½×°Ï¤@', '', '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

[1] [2] [3] ÏÂÒ»Ò³

ÔÚgoogleÀïËÑË÷¸ü¶àÉçÇø(php&&mysql)Áù

	Web www.51ec.org

ÉÏһƪÐÅϢѧԺ£º ÉçÇø(php&&mysql)Îå

ÏÂһƪÐÅϢѧԺ£º Ò»¸öphp×÷µÄÎı¾ÁôÑÔ±¾µÄÀý×Ó(Ò»)