bgui/bugs/bugs_setup.php

   1 <?
   2 /*
   3  * bugs_setup.php
   4  *
   5  * @(#) $Header$
   6  *
   7  */
   8
   9 require("bugs_globals.php");
  10 require("bugs_database.php");
  11
  12 set_time_limit(0);
  13
  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");
  17
  18 echo ("Creating the empty databases ................................. ");
  19 if($bugs_database_object->CreateDatabase($bugs_database_name)==0)
  20 {
  21         echo "\ncould not create \"$bugs_database_name\" database! (". BugsDatabaseError() .")\n";
  22         exit;
  23 }
  24 echo("done.\n");
  25
  26 if(BugsDatabaseConnect($bugs_database_name)==0)
  27 {
  28         echo "\nCould not connect to the database server!\n";
  29         exit;
  30 }
  31
  32 echo("\nSetting up the application database\n");
  33 echo("-------------------------------------------------\n\n");
  34
  35 echo("Creating the bugdb table ..................................... ");
  36 if(BugsDatabaseSeparateDateTime())
  37         $date_time="ts1_date date, ts1_time time, ts2_date date, ts2_time time";
  38 else
  39         $date_time="ts1 date, ts2 date";
  40 if(BugsDatabaseTextFieldsNeedLength())
  41         $length="(80)";
  42 else
  43         $length="";
  44 if(BugsDatabaseSupportAutoIncrement())
  45 {
  46         $auto_increment=" NOT NULL AUTO_INCREMENT";
  47         $primary_key=", PRIMARY KEY (id)";
  48 }
  49 else
  50 {
  51         $auto_increment="";
  52         $primary_key="";
  53 }
  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)
  55 {
  56         echo "\nCouldn't create the bugs database table! (".BugsDatabaseError().")\n";
  57         exit;
  58 }
  59 echo("done.\n");
  60
  61 if(!BugsDatabaseSupportAutoIncrement())
  62 {
  63         echo("Creating the serial_numbers table ............................ ");
  64         if(BugsDatabaseQuery("CREATE TABLE serial_numbers(id int)")==0)
  65         {
  66                 echo "\nCouldn't create the serial_numbers database table! (".BugsDatabaseError().")\n";
  67                 exit;
  68         }
  69         if(BugsDatabaseQuery("INSERT INTO serial_numbers (id) values(0)")==0)
  70         {
  71                 echo "\nCouldn't initialize the serial_numbers table values! (".BugsDatabaseError().").\n";
  72                 exit;
  73         }
  74         echo("done.\n");
  75 }
  76
  77 echo("Creating the id index on bugdb table ......................... ");
  78 if(BugsDatabaseQuery("CREATE UNIQUE INDEX id_index ON bugdb(id)")==0)
  79 {
  80         echo "\nCouldn't create the the id_index index. (".BugsDatabaseError().")\n";
  81         exit;
  82 }
  83 echo("done.\n");
  84
  85 BugsDatabaseClose();
  86
  87 echo ("\nSetup complete.\n\n");
  88
  89
  90
  91 ?>