9 require("bugs_globals.php");
10 require("bugs_database.php");
14 echo ("Bugs database setup program\n\n");
15 echo ("This script will create the database and tables required to run\n");
16 echo ("the bugs database application.\n\n");
18 echo ("Creating the empty databases ................................. ");
19 if($bugs_database_object->CreateDatabase($bugs_database_name)==0)
21 echo "\ncould not create \"$bugs_database_name\" database! (". BugsDatabaseError() .")\n";
26 if(BugsDatabaseConnect($bugs_database_name)==0)
28 echo "\nCould not connect to the database server!\n";
32 echo("\nSetting up the application database\n");
33 echo("-------------------------------------------------\n\n");
35 echo("Creating the bugdb table ..................................... ");
36 if(BugsDatabaseSeparateDateTime())
37 $date_time="ts1_date date, ts1_time time, ts2_date date, ts2_time time";
39 $date_time="ts1 date, ts2 date";
40 if(BugsDatabaseTextFieldsNeedLength())
44 if(BugsDatabaseSupportAutoIncrement())
46 $auto_increment=" NOT NULL AUTO_INCREMENT";
47 $primary_key=", PRIMARY KEY (id)";
54 if(BugsDatabaseQuery("CREATE TABLE bugdb(id int$auto_increment, bug_type char(32), email char(40), sdesc char(80), ldesc text$length, program_version char(16), os char(32), status char(16), comments text$length, $date_time, dev_id char(16), assign char(16)$primary_key)")==0)
56 echo "\nCouldn't create the bugs database table! (".BugsDatabaseError().")\n";
61 if(!BugsDatabaseSupportAutoIncrement())
63 echo("Creating the serial_numbers table ............................ ");
64 if(BugsDatabaseQuery("CREATE TABLE serial_numbers(id int)")==0)
66 echo "\nCouldn't create the serial_numbers database table! (".BugsDatabaseError().")\n";
69 if(BugsDatabaseQuery("INSERT INTO serial_numbers (id) values(0)")==0)
71 echo "\nCouldn't initialize the serial_numbers table values! (".BugsDatabaseError().").\n";
77 echo("Creating the id index on bugdb table ......................... ");
78 if(BugsDatabaseQuery("CREATE UNIQUE INDEX id_index ON bugdb(id)")==0)
80 echo "\nCouldn't create the the id_index index. (".BugsDatabaseError().")\n";
87 echo ("\nSetup complete.\n\n");