1
|
<?php/* Written by Gerben Schmidt, http://scripts.zomp.nl */include('admin/config.php');$query = "CREATE TABLE $table ( id int (10 ) NOT NULL auto_increment , title varchar (100 ) NOT NULL , text text NOT NULL , extended text NOT NULL , image text NOT NULL , catid int (10) NOT NULL , date varchar(25) NOT NULL default '', username text NOT NULL , userid int (10 ) NOT NULL , PRIMARY KEY (id ))"; echo "<br>creating table <b>$table</b>... ";$q = mysql_query($query) or die (mysql_error()); echo "<font color=#99CC33>succeeded</font><br>";$query2 = "CREATE TABLE $table_comments ( id int (10 ) NOT NULL auto_increment , entry_id int (10 ) NOT NULL , name varchar (100 ) NOT NULL , comment text NOT NULL , date varchar(25) NOT NULL default '', PRIMARY KEY (id ))"; echo "<br>creating table <b>$table_comments</b>... ";$q2 = mysql_query($query2) or die (mysql_error()); echo "<font color=#99CC33>succeeded</font><br>";$query3 = "CREATE TABLE $table_users ( id int(5) NOT NULL auto_increment , login varchar(15) DEFAULT '0' , password varchar(15) DEFAULT '0' , permissions int(10) NOT NULL , PRIMARY KEY (id))";echo "<br>creating table <b>$table_users</b>... ";$q3 = mysql_query($query3) or die (mysql_error()); echo "<font color=#99CC33>succeeded</font><br>";$query4 = "CREATE TABLE $table_cat ( id int(5) NOT NULL auto_increment , name text NOT NULL , permissions text NOT NULL , PRIMARY KEY (id))";echo "<br>creating table <b>$table_cat</b>... ";$q4 = mysql_query($query4) or die (mysql_error()); echo "<font color=#99CC33>succeeded</font><br>"; /* Closing connection */ mysql_close($link);echo "<br /><br />"; echo "<a href='install2.php'>continue</a> to the next step of this installation";echo "<br /><br />"; ?>
|