Menu
▾
▴
[phpBT-dev] CVS: phpbt/schemas mssql.in,1.4,1.5 mysql.in,1.52,1.53 mysqli.in,1.2,1.3 oci8.in,1.32,1.33 pgsql.in,1.51,1.52
|
From: Ulf E. <ulf...@us...> - 2005-10-02 20:57:49
|
Update of /cvsroot/phpbt/phpbt/schemas In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv31223/schemas Modified Files: mssql.in mysql.in mysqli.in oci8.in pgsql.in Log Message: Adding two new permissions (AddBug, CloseBug) and one new group (Manager) Index: mssql.in =================================================================== RCS file: /cvsroot/phpbt/phpbt/schemas/mssql.in,v retrieving revision 1.4 retrieving revision 1.5 diff -u -r1.4 -r1.5 --- mssql.in 3 Sep 2005 16:41:48 -0000 1.4 +++ mssql.in 2 Oct 2005 20:57:40 -0000 1.5 @@ -395,27 +395,34 @@ 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_AUTH_GROUP (group_id, group_name, locked) VALUES (4, 'Manager', 1); CREATE TABLE TBL_AUTH_GROUP_seq ([id] [int] IDENTITY (3, 1) NOT NULL, [vapor] [int] NULL) # ... and four permissions INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (1, 'Admin'); -INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (2, 'Editbug'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (2, 'AddBug'); INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (3, 'EditAssignment'); INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (4, 'Assignable'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (5, 'EditBug'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (6, 'CloseBug'); # Admins can do all the admin stuff, INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (1, 1); -# users can edit bugs, and +# users can add and edit bugs, INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (2, 2); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (2, 5); -# developers are users who can own bugs -INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (3, 2); +# developers can own bugs, and INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (3, 4); +# managers can assign and close bugs +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (4, 3); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (4, 6); + # Insert user_id 1 into the admin group INSERT INTO TBL_USER_GROUP (user_id, group_id) VALUES (1, 1); Index: mysql.in =================================================================== RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.in,v retrieving revision 1.52 retrieving revision 1.53 diff -u -r1.52 -r1.53 --- mysql.in 3 Sep 2005 16:41:48 -0000 1.52 +++ mysql.in 2 Oct 2005 20:57:40 -0000 1.53 @@ -403,6 +403,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_AUTH_GROUP (group_id, group_name, locked) VALUES (4, 'Manager', 1); CREATE TABLE TBL_AUTH_GROUP_seq ( id int unsigned auto_increment not null primary key); @@ -411,21 +412,27 @@ # ... and four permissions INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (1, 'Admin'); -INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (2, 'Editbug'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (2, 'AddBug'); INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (3, 'EditAssignment'); INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (4, 'Assignable'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (5, 'EditBug'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (6, 'CloseBug'); # Admins can do all the admin stuff, INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (1, 1); -# users can edit bugs, and +# users can add and edit bugs, INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (2, 2); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (2, 5); -# developers are users who can own bugs -INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (3, 2); +# developers can own bugs, and INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (3, 4); +# managers can assign and close bugs +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (4, 3); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (4, 6); + # Insert user_id 1 into the admin group INSERT INTO TBL_USER_GROUP (user_id, group_id) VALUES (1, 1); @@ -614,26 +621,20 @@ CREATE TABLE TBL_ATTACHMENT_seq ( id int unsigned auto_increment not null primary key); -INSERT INTO TBL_ATTACHMENT_seq values(0); CREATE TABLE TBL_BUG_seq ( id int unsigned auto_increment not null primary key); -INSERT INTO TBL_BUG_seq values(0); CREATE TABLE TBL_COMMENT_seq ( id int unsigned auto_increment not null primary key); -INSERT INTO TBL_COMMENT_seq values(0); CREATE TABLE TBL_COMPONENT_seq ( id int unsigned auto_increment not null primary key); -INSERT INTO TBL_COMPONENT_seq values(0); CREATE TABLE TBL_PROJECT_seq ( id int unsigned auto_increment not null primary key); -INSERT INTO TBL_PROJECT_seq values(0); CREATE TABLE TBL_VERSION_seq ( id int unsigned auto_increment not null primary key); -INSERT INTO TBL_VERSION_seq values(0); #-- Index: mysqli.in =================================================================== RCS file: /cvsroot/phpbt/phpbt/schemas/mysqli.in,v retrieving revision 1.2 retrieving revision 1.3 diff -u -r1.2 -r1.3 --- mysqli.in 3 Sep 2005 16:41:48 -0000 1.2 +++ mysqli.in 2 Oct 2005 20:57:40 -0000 1.3 @@ -403,6 +403,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_AUTH_GROUP (group_id, group_name, locked) VALUES (4, 'Manager', 1); CREATE TABLE TBL_AUTH_GROUP_seq ( id int unsigned auto_increment not null primary key); @@ -411,21 +412,27 @@ # ... and four permissions INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (1, 'Admin'); -INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (2, 'Editbug'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (2, 'AddBug'); INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (3, 'EditAssignment'); INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (4, 'Assignable'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (5, 'EditBug'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (6, 'CloseBug'); # Admins can do all the admin stuff, INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (1, 1); -# users can edit bugs, and +# users can add and edit bugs, INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (2, 2); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (2, 5); -# developers are users who can own bugs -INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (3, 2); +# developers can own bugs, and INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (3, 4); +# managers can assign and close bugs +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (4, 3); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (4, 6); + # Insert user_id 1 into the admin group INSERT INTO TBL_USER_GROUP (user_id, group_id) VALUES (1, 1); @@ -614,26 +621,20 @@ CREATE TABLE TBL_ATTACHMENT_seq ( id int unsigned auto_increment not null primary key); -INSERT INTO TBL_ATTACHMENT_seq values(0); CREATE TABLE TBL_BUG_seq ( id int unsigned auto_increment not null primary key); -INSERT INTO TBL_BUG_seq values(0); CREATE TABLE TBL_COMMENT_seq ( id int unsigned auto_increment not null primary key); -INSERT INTO TBL_COMMENT_seq values(0); CREATE TABLE TBL_COMPONENT_seq ( id int unsigned auto_increment not null primary key); -INSERT INTO TBL_COMPONENT_seq values(0); CREATE TABLE TBL_PROJECT_seq ( id int unsigned auto_increment not null primary key); -INSERT INTO TBL_PROJECT_seq values(0); CREATE TABLE TBL_VERSION_seq ( id int unsigned auto_increment not null primary key); -INSERT INTO TBL_VERSION_seq values(0); #-- Index: oci8.in =================================================================== RCS file: /cvsroot/phpbt/phpbt/schemas/oci8.in,v retrieving revision 1.32 retrieving revision 1.33 diff -u -r1.32 -r1.33 --- oci8.in 3 Sep 2005 16:41:48 -0000 1.32 +++ oci8.in 2 Oct 2005 20:57:40 -0000 1.33 @@ -406,27 +406,34 @@ 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_AUTH_GROUP (group_id, group_name, locked) VALUES (4, 'Manager', 1); CREATE SEQUENCE TBL_AUTH_GROUP_seq START WITH 4 NOCACHE; # ... and four permissions INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (1, 'Admin'); -INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (2, 'Editbug'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (2, 'AddBug'); INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (3, 'EditAssignment'); INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (4, 'Assignable'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (5, 'EditBug'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (6, 'CloseBug'); # Admins can do all the admin stuff, INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (1, 1); -# users can edit bugs, and +# users can add and edit bugs, INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (2, 2); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (2, 5); -# developers are users who can own bugs -INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (3, 2); +# developers can own bugs, and INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (3, 4); +# managers can assign and close bugs +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (4, 3); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (4, 6); + # Insert user_id 1 into the admin group INSERT INTO TBL_USER_GROUP (user_id, group_id) VALUES (1, 1); Index: pgsql.in =================================================================== RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.in,v retrieving revision 1.51 retrieving revision 1.52 diff -u -r1.51 -r1.52 --- pgsql.in 3 Sep 2005 16:41:48 -0000 1.51 +++ pgsql.in 2 Oct 2005 20:57:40 -0000 1.52 @@ -394,27 +394,34 @@ 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_AUTH_GROUP (group_id, group_name, locked) VALUES (4, 'Manager', 1); CREATE SEQUENCE TBL_AUTH_GROUP_seq START 4; # ... and four permissions INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (1, 'Admin'); -INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (2, 'Editbug'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (2, 'AddBug'); INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (3, 'EditAssignment'); INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (4, 'Assignable'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (5, 'EditBug'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (6, 'CloseBug'); # Admins can do all the admin stuff, INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (1, 1); -# users can edit bugs, and +# users can add and edit bugs, INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (2, 2); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (2, 5); -# developers are users who can own bugs -INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (3, 2); +# developers can own bugs, and INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (3, 4); +# managers can assign and close bugs +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (4, 3); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (4, 6); + # Insert user_id 1 into the admin group INSERT INTO TBL_USER_GROUP (user_id, group_id) VALUES (1, 1); |
