[phpBT-dev] CVS: phpbt/schemas mysql.in,1.25,1.26

[Jirka P. <fi...@us...>]

Update of /cvsroot/phpbt/phpbt/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv9422/phpbt/schemas

Modified Files:
	mysql.in 
Log Message:
mysql.in:
 - Added TBL_DATABASE for database provider/version tracking and filled in some example lines - "to be replaced" lines. I don't actually know if we want to distribute this table as empty or filled with something.
 - Added closed_in_version_id and to_be_closed_in_version_id columns to TBL_BUG.
config-dist.php (and config.php):
 - Added TBL_DATABASE to config.

QUESTIONS:
 - Is it correct to change cofig.php (which is distibuted empty), when changed config-dist.php?
 - Is it a good practice to change schemas like I did or we prefer some other way?


Index: mysql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.in,v
retrieving revision 1.25
retrieving revision 1.26
diff -u -r1.25 -r1.26
--- mysql.in	1 May 2002 12:20:55 -0000	1.25
+++ mysql.in	17 May 2002 15:23:47 -0000	1.26
@@ -62,6 +62,7 @@
   priority tinyint(3) unsigned NOT NULL default '0',
   status_id tinyint(3) unsigned NOT NULL default '0',
   resolution_id tinyint(3) unsigned NOT NULL default '0',
+  database_id tinyint(3) unsigned NOT NULL default '0',
   assigned_to int(10) unsigned NOT NULL default '0',
   created_by int(10) unsigned NOT NULL default '0',
   created_date bigint(20) unsigned NOT NULL default '0',
@@ -69,11 +70,15 @@
   last_modified_date bigint(20) unsigned NOT NULL default '0',
   project_id int(10) unsigned NOT NULL default '0',
   version_id int(10) unsigned NOT NULL default '0',
+  closed_in_version_id int(10) unsigned NOT NULL default '0',
+  to_be_closed_in_version_id int(10) unsigned NOT NULL default '0',
   component_id int(10) unsigned NOT NULL default '0',
   os_id tinyint(3) unsigned NOT NULL default '0',
   browser_string varchar(255) NOT NULL default '',
   close_date bigint(20) unsigned NOT NULL default '0',
-  PRIMARY KEY  (bug_id)
+  closed_in_version_id int(10) unsigned NOT NULL default '0',
+  to_be_closed_in_version_id int(10) unsigned NOT NULL default '0',
+  PRIMARY KEY (bug_id)
 ) TYPE=MyISAM;
 
 CREATE TABLE TBL_BUG_CC (
@@ -250,6 +255,14 @@
   PRIMARY KEY  (version_id)
 ) TYPE=MyISAM;
 
+CREATE TABLE TBL_DATABASE (
+  database_id int(10) unsigned NOT NULL default '0',
+  database_name varchar(30) NOT NULL default '',
+  database_version varchar(10) NOT NULL default '',
+  sort_order tinyint(3) unsigned NOT NULL default '0',
+  PRIMARY KEY (database_id)
+) TYPE=MyISAM;
+
 #
 # -- Insert initial data --
 #
@@ -370,4 +383,10 @@
 INSERT INTO TBL_STATUS VALUES (7,'Closed','The bug is officially squashed (QA)',7);
 create table TBL_STATUS_seq (id int unsigned auto_increment not null primary key);
 insert into TBL_STATUS_seq values (7);
+
+INSERT INTO TBL_DATABASE VALUES (1,'Oracle','8.1.7',1);
+INSERT INTO TBL_DATABASE VALUES (2,'MySQL','3.23.49',2);
+INSERT INTO TBL_DATABASE VALUES (2,'PostgreSQL','7.1.3',3);
+create table TBL_DATABASE_seq (id int unsigned auto_increment not null primary key);
+insert into TBL_DATABASE_seq values (2);