社区(php&&mysql)六

//此为bbs.sql

CREATETABLEbbs_area(
   idint(10)unsignedDEFAULT"0"NOTNULLauto_increment,
   mastervarchar(150)NOTNULL,
   bannervarchar(150)NOTNULL,
   bodytextNOTNULL,
   emailvarchar(50),
   loginvarchar(20),
   passwdvarchar(20),
   PRIMARYKEY(id)
);

INSERTINTObbs_areaVALUES("1","master","?阶跋?","","jerry@mail.jerry.com.tw","master","111111");


CREATETABLEbbs_sml(
   idint(8)unsignedDEFAULT"0"NOTNULLauto_increment,
   sidint(8)unsignedDEFAULT"0"NOTNULL,
   emailchar(60)NOTNULL,
   PRIMARYKEY(id),
   KEYsid(sid),
   KEYemail(email)
);

CREATETABLEbbs_subj(
   idint(10)unsignedDEFAULT"0"NOTNULLauto_increment,
   aidint(10)unsignedDEFAULT"0"NOTNULL,
   bannervarchar(150)NOTNULL,
   bodytextNOTNULL,
   postervarchar(20)NOTNULL,
   emailvarchar(50),
   pipvarchar(20)NOTNULL,
   wdatedatetimeDEFAULT"0000-00-0000:00:00"NOTNULL,
   viewsint(8)unsignedDEFAULT"1"NOTNULL,
   goodint(2)unsignedDEFAULT"0"NOTNULL,
   PRIMARYKEY(id),
   KEYaid(aid),
   KEYgood(good),
   KEYwdate(wdate)
);

CREATETABLEbbs_docs(
   idint(10)unsignedDEFAULT"0"NOTNULLauto_increment,
   aidint(10)unsignedDEFAULT"0"NOTNULL,
   sidint(10)unsignedDEFAULT"0"NOTNULL,
   bannervarchar(150)NOTNULL,
   bodytextNOTNULL,
   postervarchar(20)NOTNULL,
   emailvarchar(50),
   pipvarchar(20)NOTNULL,
   wdatedatetimeDEFAULT"0000-00-0000:00:00"NOTNULL,
   viewsint(8)unsignedDEFAULT"1"NOTNULL,
   goodint(2)unsignedDEFAULT"0"NOTNULL,
   PRIMARYKEY(id),
   KEYaid(aid),
   KEYgood(good),
   KEYwdate(wdate)
);

CREATETABLEbbs_sel(
   idint(8)unsignedDEFAULT"0"NOTNULLauto_increment,
   sidint(8)unsignedDEFAULT"0"NOTNULL,
   bannerchar(80)NOTNULL,
   sel_0char(80)NOTNULL,
   sel_1char(80)NOTNULL,
   sel_2char(80)NOTNULL,
   sel_3char(80)NOTNULL,
   sel_4char(80)NOTNULL,
   sel_5char(80)NOTNULL,
   sel_6char(80)NOTNULL,
   sel_7char(80)NOTNULL,
   sn_0int(8)DEFAULT"0"NOTNULL,
   sn_1int(8)DEFAULT"0"NOTNULL,
   sn_2int(8)DEFAULT"0"NOTNULL,
   sn_3int(8)DEFAULT"0"NOTNULL,
   sn_4int(8)DEFAULT"0"NOTNULL,
   sn_5int(8)DEFAULT"0"NOTNULL,
   sn_6int(8)DEFAULT"0"NOTNULL,
   sn_7int(8)DEFAULT"0"NOTNULL,
   PRIMARYKEY(id)
);




//此为sql.php3


<?
$sql["user"]="root";
$sql["passwd"]="戈????";
$sql["db"]="恶???戈???嘿";
$sql["host"]="localhost";

?>