[phpBT-dev] CVS: phpbt/schemas mysql.in,1.29,1.30 oci8.in,1.13,1.14 pgsql.in,1.30,1.31

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

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

Modified Files:
	mysql.in oci8.in pgsql.in 
Log Message:
Started adding environment tracking. Named the table TBL_SITE and will call the feature SITE TRACKING rather than obsoleted ENVIRONMENT TRACKING from now, because it's better self-explanatory.


Index: mysql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.in,v
retrieving revision 1.29
retrieving revision 1.30
diff -u -r1.29 -r1.30
--- mysql.in	19 May 2002 11:48:30 -0000	1.29
+++ mysql.in	13 Jun 2002 11:29:39 -0000	1.30
@@ -63,6 +63,7 @@
   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',
+  site_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',
@@ -254,13 +255,20 @@
 ) TYPE=MyISAM;
 
 CREATE TABLE TBL_DATABASE (
-  database_id int(10) unsigned NOT NULL default '0',
+  database_id tinyint(3) 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;
 
+CREATE TABLE TBL_SITE (
+  site_id tinyint(3) unsigned NOT NULL default '0',
+  site_name varchar(50) NOT NULL default '',
+  sort_order tinyint(3) unsigned NOT NULL default '0',
+  PRIMARY KEY (site_id)
+) TYPE=MyISAM;
+
 #
 # -- Insert initial data --
 #
@@ -388,3 +396,12 @@
 INSERT INTO TBL_DATABASE VALUES (3,'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 (3);
+
+# Examples only
+INSERT INTO TBL_SITE VALUES (0,'All',1);
+INSERT INTO TBL_SITE VALUES (1,'Production - location 1',2);
+INSERT INTO TBL_SITE VALUES (2,'Production - location 2',3);
+INSERT INTO TBL_SITE VALUES (3,'Test site - location 1',4);
+INSERT INTO TBL_SITE VALUES (4,'Test site - location 2',5);
+create table TBL_SITE_seq (id int unsigned auto_increment not null primary key);
+insert into TBL_SITE_seq values (4);

Index: oci8.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/oci8.in,v
retrieving revision 1.13
retrieving revision 1.14
diff -u -r1.13 -r1.14
--- oci8.in	18 May 2002 16:07:14 -0000	1.13
+++ oci8.in	13 Jun 2002 11:29:39 -0000	1.14
@@ -63,6 +63,7 @@
   status_id number(3)   default '0' NOT NULL,
   resolution_id number(3)   default '0' NOT NULL,
   database_id number(3)   default '0' NOT NULL,
+  site_id number(3)	default '0' NOT NULL,
   assigned_to number(10)   default '0' NOT NULL,
   created_by number(10)   default '0' NOT NULL,
   created_date number(20)   default '0' NOT NULL,
@@ -259,13 +260,20 @@
 ) ;
 
 CREATE TABLE TBL_DATABASE (
-    database_id number(10) default '0' NOT NULL,
+    database_id number(3) default '0' NOT NULL,
     database_name varchar2(30) default '' NOT NULL,
     database_version varchar2(10) default '' NOT NULL,
     sort_order number(3) default '0' NOT NULL,
     PRIMARY KEY (database_id)
 );
 
+CREATE TABLE TBL_SITE (
+    site_id number(3) default '0' NOT NULL,
+    site_name varchar2(50) default '' NOT NULL,
+    sort_order number(3) default '0' NOT NULL,
+    PRIMARY KEY (site_id)
+);
+
 INSERT INTO TBL_AUTH_USER 
 	(user_id, login, first_name, last_name, email, password)
 	values (1, 'OPTION_ADMIN_EMAIL', 'System', 'Admin', 'OPTION_ADMIN_EMAIL', 
@@ -382,3 +390,10 @@
 INSERT INTO TBL_DATABASE VALUES (2,'MySQL','3.23.49',2);
 INSERT INTO TBL_DATABASE VALUES (3,'PostgreSQL','7.1.3',3);
 CREATE SEQUENCE TBL_DATABASE_seq START WITH 4 NOCACHE;
+
+INSERT INTO TBL_SITE VALUES (0,'All',1);
+INSERT INTO TBL_SITE VALUES (1,'Production - location 1',2);
+INSERT INTO TBL_SITE VALUES (2,'Production - location 2',3);
+INSERT INTO TBL_SITE VALUES (3,'Test site - location 1',4);
+INSERT INTO TBL_SITE VALUES (4,'Test site - location 2',5);
+CREATE SEQUENCE TBL_SITE_seq START WITH 5 NOCACHE;

Index: pgsql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.in,v
retrieving revision 1.30
retrieving revision 1.31
diff -u -r1.30 -r1.31
--- pgsql.in	18 May 2002 16:07:14 -0000	1.30
+++ pgsql.in	13 Jun 2002 11:29:39 -0000	1.31
@@ -66,6 +66,7 @@
   status_id INT2  NOT NULL DEFAULT '0',
   resolution_id INT2  NOT NULL DEFAULT '0',
   database_id INT2  NOT NULL DEFAULT '0',
+  site_id INT2  NOT NULL DEFAULT '0',
   assigned_to INT4  NOT NULL DEFAULT '0',
   created_by INT4  NOT NULL DEFAULT '0',
   created_date INT8  NOT NULL DEFAULT '0',
@@ -252,13 +253,20 @@
 );
 
 CREATE TABLE TBL_DATABASE (
-    database_id INT4 NOT NULL DEFAULT '0',
+    database_id INT2 NOT NULL DEFAULT '0',
     database_name varchar(30) NOT NULL DEFAULT '',
     database_version varchar(10) NOT NULL DEFAULT '',
     sort_order INT2 NOT NULL DEFAULT '0',
     PRIMARY KEY (database_id)
 );
 
+CREATE TABLE TBL_SITE (
+    site_id INT2 NOT NULL DEFAULT '0',
+    site_name varchar(50) NOT NULL DEFAULT '',
+    sort_order INT2 NOT NULL DEFAULT '0',
+    PRIMARY KEY (site_id)
+);
+
 --
 -- -- Insert initial data --
 --
@@ -380,6 +388,13 @@
 INSERT INTO TBL_DATABASE VALUES (3,'PostgreSQL','7.1.3',3);
 CREATE SEQUENCE TBL_DATABASE_seq START 3;
 
+INSERT INTO TBL_SITE VALUES (0,'All',1);
+INSERT INTO TBL_SITE VALUES (1,'Production - location 1',2);
+INSERT INTO TBL_SITE VALUES (2,'Production - location 2',3);
+INSERT INTO TBL_SITE VALUES (3,'Test site - location 1',4);
+INSERT INTO TBL_SITE VALUES (4,'Test site - location 2',5);
+CREATE SEQUENCE TBL_SITE_seq START 4;
+
 --
 -- Indexes for table TBL_GROUP_PERM
 --
@@ -403,7 +418,6 @@
 --
 
 CREATE INDEX group_id_TBL_BUG_GROUP_index ON TBL_BUG_GROUP (group_id);
-
 
 COMMIT;