|
From: Jirka P. <fi...@us...> - 2002-06-13 11:29:43
|
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;
|