Menu
▾
▴
[phpBT-dev] CVS: phpbt/schemas mysql.in,1.15,1.16 oci8.in,1.1,1.2 pgsql.in,1.17,1.18
|
From: Benjamin C. <bc...@us...> - 2002-03-17 01:36:16
|
Update of /cvsroot/phpbt/phpbt/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv3189
Modified Files:
mysql.in oci8.in pgsql.in
Log Message:
Changes for PEAR::DB -- completely untested. :)
Index: mysql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.in,v
retrieving revision 1.15
retrieving revision 1.16
diff -u -r1.15 -r1.16
--- mysql.in 26 Jan 2002 16:59:20 -0000 1.15
+++ mysql.in 17 Mar 2002 01:36:08 -0000 1.16
@@ -3,15 +3,6 @@
#
# $Id$
-CREATE TABLE TBL_ACTIVE_SESSIONS (
- sid varchar(32) NOT NULL default '',
- name varchar(32) NOT NULL default '',
- val text,
- changed varchar(14) NOT NULL default '',
- PRIMARY KEY (name,sid),
- KEY changed (changed)
-) TYPE=MyISAM;
-
CREATE TABLE TBL_ATTACHMENT (
attachment_id int(10) unsigned NOT NULL default '0',
bug_id int(10) unsigned NOT NULL default '0',
@@ -148,12 +139,6 @@
PRIMARY KEY (varname)
) TYPE=MyISAM;
-CREATE TABLE TBL_DB_SEQUENCE (
- seq_name varchar(127) NOT NULL default '',
- nextid int(10) unsigned NOT NULL default '0',
- PRIMARY KEY (seq_name)
-) TYPE=MyISAM;
-
CREATE TABLE TBL_GROUP_PERM (
group_id int(10) unsigned NOT NULL default '0',
perm_id int(10) unsigned NOT NULL default '0',
@@ -261,13 +246,15 @@
(user_id, login, first_name, last_name, email, password)
values (1, 'OPTION_ADMIN_EMAIL', 'System', 'Admin', 'OPTION_ADMIN_EMAIL',
'OPTION_ADMIN_PASS');
-INSERT INTO TBL_DB_SEQUENCE values ('TBL_AUTH_USER', 1);
+create table TBL_AUTH_USER_seq (id int unsigned auto_increment not null primary key);
+insert into TBL_AUTH_USER_seq values (1);
# Start off with three user levels...
INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (1, 'Admin', 1);
INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (2, 'User', 1);
INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (3, 'Developer', 1);
-INSERT INTO TBL_DB_SEQUENCE values ('TBL_AUTH_GROUP', 3);
+create table TBL_AUTH_GROUP_seq (id int unsigned auto_increment not null primary key);
+insert into TBL_AUTH_GROUP_seq values (3);
# ... and only two permissions
INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (1, 'Admin');
@@ -333,7 +320,8 @@
INSERT INTO TBL_OS VALUES (29,'Solaris',29,'/Mozilla.*\\(.*;.*; SunOS 5.*\\)/');
INSERT INTO TBL_OS VALUES (30,'SunOS',30,'/Mozilla.*\\(.*;.*; SunOS.*\\)/');
INSERT INTO TBL_OS VALUES (31,'other',31,'');
-INSERT INTO TBL_DB_SEQUENCE values ('TBL_OS', 31);
+create table TBL_OS_seq (id int unsigned auto_increment not null primary key);
+insert into TBL_OS_seq values (31);
INSERT INTO TBL_RESOLUTION VALUES (1,'Fixed','Bug was eliminated',1);
INSERT INTO TBL_RESOLUTION VALUES (2,'Not a bug','It\'s not a bug -- it\'s a feature!',2);
@@ -341,7 +329,8 @@
INSERT INTO TBL_RESOLUTION VALUES (4,'Deferred','We\'ll get around to it later',4);
INSERT INTO TBL_RESOLUTION VALUES (5,'Works for me','Can\'t replicate the bug',5);
INSERT INTO TBL_RESOLUTION VALUES (6,'Duplicate','',6);
-INSERT INTO TBL_DB_SEQUENCE values ('TBL_RESOLUTION', 6);
+create table TBL_RESOLUTION_seq (id int unsigned auto_increment not null primary key);
+insert into TBL_RESOLUTION_seq values (6);
INSERT INTO TBL_SEVERITY VALUES (1,'Unassigned','Default bug creation',1,'#dadada');
INSERT INTO TBL_SEVERITY VALUES (2,'Idea','Ideas for further development',2,'#dad0d0');
@@ -350,7 +339,8 @@
INSERT INTO TBL_SEVERITY VALUES (5,'Content','Non-functional related bugs, such as text content',5,'#dababa');
INSERT INTO TBL_SEVERITY VALUES (6,'Significant','A bug affecting the intended performance of the product',6,'#dab0b0');
INSERT INTO TBL_SEVERITY VALUES (7,'Critical','A bug severe enough to prevent the release of the product',7,'#daaaaa');
-INSERT INTO TBL_DB_SEQUENCE values ('TBL_SEVERITY', 7);
+create table TBL_SEVERITY_seq (id int unsigned auto_increment not null primary key);
+insert into TBL_SEVERITY_seq values (7);
INSERT INTO TBL_STATUS VALUES (1,'Unconfirmed','Reported but not confirmed',1);
INSERT INTO TBL_STATUS VALUES (2,'New','A new bug',2);
@@ -359,5 +349,6 @@
INSERT INTO TBL_STATUS VALUES (5,'Resolved','Set by engineer with a resolution',5);
INSERT INTO TBL_STATUS VALUES (6,'Verified','The resolution is confirmed by the reporter',6);
INSERT INTO TBL_STATUS VALUES (7,'Closed','The bug is officially squashed (QA)',7);
-INSERT INTO TBL_DB_SEQUENCE values ('TBL_STATUS', 7);
+create table TBL_STATUS_seq (id int unsigned auto_increment not null primary key);
+insert into TBL_STATUS_seq values (7);
Index: oci8.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/oci8.in,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- oci8.in 15 Mar 2002 23:05:46 -0000 1.1
+++ oci8.in 17 Mar 2002 01:36:10 -0000 1.2
@@ -1,12 +1,8 @@
-CREATE TABLE TBL_ACTIVE_SESSIONS (
- sid varchar2(32) default '' NOT NULL,
- name varchar2(32) default '' NOT NULL,
- val varchar2(4000) ,
- changed varchar2(14) default '' NOT NULL ,
- PRIMARY KEY (name, sid)
-) ;
-CREATE INDEX CHANGEDIDX ON TBL_ACTIVE_SESSIONS ( changed );
+-- Oracle database creation script
+-- This is a template for install.php -- not for creating the database!
+--
+-- $Id$
CREATE TABLE TBL_ATTACHMENT (
attachment_id number(10) default '0' NOT NULL,
@@ -145,12 +141,6 @@
PRIMARY KEY (varname)
) ;
-CREATE TABLE TBL_DB_SEQUENCE (
- seq_name varchar2(127) default '' NOT NULL,
- nextid number(10) default '0' NOT NULL,
- PRIMARY KEY (seq_name)
-) ;
-
CREATE TABLE TBL_GROUP_PERM (
group_id number(10) default '0' NOT NULL,
perm_id number(10) default '0' NOT NULL,
@@ -263,7 +253,7 @@
INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (1, 'Admin', 1);
INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (2, 'User', 1);
INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (3, 'Developer', 1);
-INSERT INTO TBL_DB_SEQUENCE values ('TBL_AUTH_GROUP', 3);
+CREATE SEQUENCE TBL_AUTH_USER_seq START WITH 1;
-- ... and only two permissions
INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (1, 'Admin');
@@ -329,7 +319,7 @@
INSERT INTO TBL_OS VALUES (29,'Solaris',29,'/Mozilla.*\\(.*;.*; SunOS 5.*\\)/');
INSERT INTO TBL_OS VALUES (30,'SunOS',30,'/Mozilla.*\\(.*;.*; SunOS.*\\)/');
INSERT INTO TBL_OS VALUES (31,'other',31,'');
-INSERT INTO TBL_DB_SEQUENCE values ('TBL_OS', 31);
+CREATE SEQUENCE TBL_OS_seq START WITH 31;
INSERT INTO TBL_RESOLUTION VALUES (1,'Fixed','Bug was eliminated',1);
INSERT INTO TBL_RESOLUTION VALUES (2,'Not a bug','It''s not a bug -- it''s a feature!',2);
@@ -337,7 +327,7 @@
INSERT INTO TBL_RESOLUTION VALUES (4,'Deferred','We''ll get around to it later',4);
INSERT INTO TBL_RESOLUTION VALUES (5,'Works for me','Can''t replicate the bug',5);
INSERT INTO TBL_RESOLUTION VALUES (6,'Duplicate','',6);
-INSERT INTO TBL_DB_SEQUENCE values ('TBL_RESOLUTION', 6);
+CREATE SEQUENCE TBL_RESOLUTION_seq START WITH 6;
INSERT INTO TBL_SEVERITY VALUES (1,'Unassigned','Default bug creation',1,'#dadada');
INSERT INTO TBL_SEVERITY VALUES (2,'Idea','Ideas for further development',2,'#dad0d0');
@@ -346,7 +336,7 @@
INSERT INTO TBL_SEVERITY VALUES (5,'Content','Non-functional related bugs, such as text content',5,'#dababa');
INSERT INTO TBL_SEVERITY VALUES (6,'Significant','A bug affecting the intended performance of the product',6,'#dab0b0');
INSERT INTO TBL_SEVERITY VALUES (7,'Critical','A bug severe enough to prevent the release of the product',7,'#daaaaa');
-INSERT INTO TBL_DB_SEQUENCE values ('TBL_SEVERITY', 7);
+CREATE SEQUENCE TBL_SEVERITY_seq START WITH 7;
INSERT INTO TBL_STATUS VALUES (1,'Unconfirmed','Reported but not confirmed',1);
INSERT INTO TBL_STATUS VALUES (2,'New','A new bug',2);
@@ -355,4 +345,4 @@
INSERT INTO TBL_STATUS VALUES (5,'Resolved','Set by engineer with a resolution',5);
INSERT INTO TBL_STATUS VALUES (6,'Verified','The resolution is confirmed by the reporter',6);
INSERT INTO TBL_STATUS VALUES (7,'Closed','The bug is officially squashed (QA)',7);
-INSERT INTO TBL_DB_SEQUENCE values ('TBL_STATUS', 7);
+CREATE SEQUENCE TBL_STATUS_seq START WITH 7;
Index: pgsql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.in,v
retrieving revision 1.17
retrieving revision 1.18
diff -u -r1.17 -r1.18
--- pgsql.in 5 Mar 2002 21:52:06 -0000 1.17
+++ pgsql.in 17 Mar 2002 01:36:10 -0000 1.18
@@ -1,8 +1,5 @@
-- PostgreSQL database creation script
--- If you change the database name, make sure you change the DB_DATABASE
--- constant in config.php. Make sure you edit the TBL_AUTH_USER insert below.
---
-- This is a template for install.php -- not for creating the database!
--
-- $Id$
@@ -10,14 +7,6 @@
BEGIN;
-CREATE TABLE TBL_ACTIVE_SESSIONS (
- sid varchar(32) NOT NULL DEFAULT '',
- name varchar(32) NOT NULL DEFAULT '',
- val text,
- changed varchar(14) NOT NULL DEFAULT '',
- PRIMARY KEY (name,sid)
-);
-
CREATE TABLE TBL_ATTACHMENT (
attachment_id INT4 NOT NULL DEFAULT '0',
bug_id INT4 NOT NULL DEFAULT '0',
@@ -151,12 +140,6 @@
PRIMARY KEY (varname)
);
-CREATE TABLE TBL_DB_SEQUENCE (
- seq_name varchar(127) NOT NULL DEFAULT '',
- nextid INT4 NOT NULL DEFAULT '0',
- PRIMARY KEY (seq_name)
-);
-
CREATE TABLE TBL_GROUP_PERM (
group_id INT4 NOT NULL DEFAULT '0',
perm_id INT4 NOT NULL DEFAULT '0',
@@ -261,13 +244,13 @@
(user_id, login, first_name, last_name, email, password)
values (1, 'OPTION_ADMIN_EMAIL', 'System', 'Admin', 'OPTION_ADMIN_EMAIL',
'OPTION_ADMIN_PASS');
-INSERT INTO TBL_DB_SEQUENCE values ('TBL_AUTH_USER', 1);
+CREATE SEQUENCE TBL_AUTH_USER_seq START 1;
-- Start off with three user levels...
INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (1, 'Admin', 1);
INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (2, 'User', 1);
INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (3, 'Developer', 1);
-INSERT INTO TBL_DB_SEQUENCE values ('TBL_AUTH_GROUP', 3);
+CREATE SEQUENCE TBL_AUTH_GROUP_seq START 3;
-- ... and only two permissions
INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (1, 'Admin');
@@ -334,7 +317,7 @@
INSERT INTO TBL_OS VALUES (29,'Solaris',29,'/Mozilla.*\\(.*;.*; SunOS 5.*\\)/');
INSERT INTO TBL_OS VALUES (30,'SunOS',30,'/Mozilla.*\\(.*;.*; SunOS.*\\)/');
INSERT INTO TBL_OS VALUES (31,'other',31,'');
-INSERT INTO TBL_DB_SEQUENCE values ('TBL_OS', 31);
+CREATE SEQUENCE TBL_OS_seq START 31;
INSERT INTO TBL_RESOLUTION VALUES (1,'Fixed','Bug was eliminated',1);
INSERT INTO TBL_RESOLUTION VALUES (2,'Not a bug','It\'s not a bug -- it\'s a feature!',2);
@@ -342,7 +325,7 @@
INSERT INTO TBL_RESOLUTION VALUES (4,'Deferred','We\'ll get around to it later',4);
INSERT INTO TBL_RESOLUTION VALUES (5,'Works for me','Can\'t replicate the bug',5);
INSERT INTO TBL_RESOLUTION VALUES (6,'Duplicate','',6);
-INSERT INTO TBL_DB_SEQUENCE values ('TBL_RESOLUTION', 6);
+CREATE SEQUENCE TBL_RESOLUTION_seq START 6;
INSERT INTO TBL_SEVERITY VALUES (1,'Unassigned','Default bug creation',1,'#dadada');
INSERT INTO TBL_SEVERITY VALUES (2,'Idea','Ideas for further development',2,'#dad0d0');
@@ -351,7 +334,7 @@
INSERT INTO TBL_SEVERITY VALUES (5,'Content','Non-functional related bugs, such as text content',5,'#dababa');
INSERT INTO TBL_SEVERITY VALUES (6,'Significant','A bug affecting the intended performance of the product',6,'#dab0b0');
INSERT INTO TBL_SEVERITY VALUES (7,'Critical','A bug severe enough to prevent the release of the product',7,'#daaaaa');
-INSERT INTO TBL_DB_SEQUENCE values ('TBL_SEVERITY', 7);
+CREATE SEQUENCE TBL_SEVERITY_seq START 7;
INSERT INTO TBL_STATUS VALUES (1,'Unconfirmed','Reported but not confirmed',1);
INSERT INTO TBL_STATUS VALUES (2,'New','A new bug',2);
@@ -360,7 +343,7 @@
INSERT INTO TBL_STATUS VALUES (5,'Resolved','Set by engineer with a resolution',5);
INSERT INTO TBL_STATUS VALUES (6,'Verified','The resolution is confirmed by the reporter',6);
INSERT INTO TBL_STATUS VALUES (7,'Closed','The bug is officially squashed (QA)',7);
-INSERT INTO TBL_DB_SEQUENCE values ('TBL_STATUS', 7);
+CREATE SEQUENCE TBL_STATUS_seq START 7;
--
|
