$db=@mysql_connect("sql.inner1.com","earthdes","joeandjami");
if(!$db) {
die("Sorry, no connection [1]
");
}
$select=@mysql_select_db("fengshui",$db);
if(!$select) {
die("Sorry, no connection [2]
");
}
mysql_query("CREATE TABLE bbbb_main (
id smallint(6) NOT NULL auto_increment,
name varchar(40),
email varchar(60),
topic varchar(50),
body blob,
host varchar(80),
thread smallint(6) NOT NULL,
datestamp int(11) NOT NULL,
depth smallint(2) NOT NULL,
childof smallint(6) NOT NULL,
pos smallint(6) NOT NULL,
PRIMARY KEY (id),
KEY thread (thread),
KEY childof (childof),
KEY pos (pos)
)");
mysql_query("CREATE TABLE bbbb_email (
email varchar(60) NOT NULL,
thread smallint(6) NOT NULL,
passwd varchar(10) NOT NULL,
KEY thread (thread))");
echo "tables created";
?>