From: Ulf E. <ulf...@us...> - 2005-10-31 21:34:45
|
Update of /cvsroot/phpbt/phpbt/schemas In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv1698/schemas Modified Files: mssql.in mysql.in mysqli.in oci8.in pgsql.in Log Message: Adding a role-based permission system Index: mssql.in =================================================================== RCS file: /cvsroot/phpbt/phpbt/schemas/mssql.in,v retrieving revision 1.5 retrieving revision 1.6 diff -u -r1.5 -r1.6 --- mssql.in 2 Oct 2005 20:57:40 -0000 1.5 +++ mssql.in 31 Oct 2005 21:34:35 -0000 1.6 @@ -30,6 +30,7 @@ created_date int NOT NULL default '0', last_modified_by smallint NOT NULL default '0', last_modified_date int NOT NULL default '0', + is_role bit NOT NULL default '0', PRIMARY KEY (group_id) ); @@ -384,6 +385,10 @@ INSERT INTO TBL_AUTH_USER + (user_id, login, first_name, last_name, email, password, active) + values (0, 'Anonymous User', 'Anonymous', 'User', '', '', 0); + +INSERT INTO TBL_AUTH_USER (user_id, login, first_name, last_name, email, password) values (1, 'OPTION_ADMIN_EMAIL', 'System', 'Admin', 'OPTION_ADMIN_EMAIL', 'OPTION_ADMIN_PASS'); @@ -391,37 +396,71 @@ CREATE TABLE TBL_AUTH_USER_seq ([id] [int] IDENTITY (1, 1) NOT NULL, [vapor] [int] NULL) -# Start off with three user levels... +# Start off with four 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_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) +# ... six user roles ... +INSERT INTO TBL_AUTH_GROUP (group_id, group_name, is_role, locked) VALUES (5, 'Guest', 1, 1); +INSERT INTO TBL_AUTH_GROUP (group_id, group_name, is_role, locked) VALUES (6, 'User', 1, 1); +INSERT INTO TBL_AUTH_GROUP (group_id, group_name, is_role, locked) VALUES (7, 'Reporter', 1, 1); +INSERT INTO TBL_AUTH_GROUP (group_id, group_name, is_role, locked) VALUES (8, 'Assignee', 1, 1); +INSERT INTO TBL_AUTH_GROUP (group_id, group_name, is_role, locked) VALUES (9, 'Owner', 1, 1); + +CREATE TABLE TBL_AUTH_GROUP_seq ([id] [int] IDENTITY (9, 1) NOT NULL, [vapor] [int] NULL) -# ... and four permissions +# ... and fourteen permissions INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (1, 'Admin'); 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'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (7, 'CommentBug'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (8, 'EditPriority'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (9, 'EditStatus'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (10, 'EditSeverity'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (11, 'EditResolution'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (12, 'EditProject'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (13, 'EditComponent'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (14, 'ManageBug'); # Admins can do all the admin stuff, INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (1, 1); # 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); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (5, 7); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (6, 2); + +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (7, 5); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (7, 10); # developers can own bugs, and INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (3, 4); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (3, 5); + +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (8, 8); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (8, 9); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (8, 11); # 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 INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (4, 12); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (4, 13); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (4, 14); + +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 6); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 7); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 8); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 9); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 10); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 11); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 13); # Insert user_id 1 into the admin group Index: mysql.in =================================================================== RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.in,v retrieving revision 1.53 retrieving revision 1.54 diff -u -r1.53 -r1.54 --- mysql.in 2 Oct 2005 20:57:40 -0000 1.53 +++ mysql.in 31 Oct 2005 21:34:35 -0000 1.54 @@ -30,6 +30,7 @@ created_date bigint(20) unsigned NOT NULL default '0', last_modified_by int(10) unsigned NOT NULL default '0', last_modified_date bigint(20) unsigned NOT NULL default '0', + is_role tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (group_id) ) TYPE=MyISAM; @@ -390,6 +391,10 @@ INSERT INTO TBL_AUTH_USER + (user_id, login, first_name, last_name, email, password, active) + values (0, 'Anonymous User', 'Anonymous', 'User', '', '', 0); + +INSERT INTO TBL_AUTH_USER (user_id, login, first_name, last_name, email, password) values (1, 'OPTION_ADMIN_EMAIL', 'System', 'Admin', 'OPTION_ADMIN_EMAIL', 'OPTION_ADMIN_PASS'); @@ -399,39 +404,73 @@ INSERT INTO TBL_AUTH_USER_seq values (1); -# Start off with three user levels... +# Start off with four 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_AUTH_GROUP (group_id, group_name, locked) VALUES (4, 'Manager', 1); +# ... six user roles ... +INSERT INTO TBL_AUTH_GROUP (group_id, group_name, is_role, locked) VALUES (5, 'Guest', 1, 1); +INSERT INTO TBL_AUTH_GROUP (group_id, group_name, is_role, locked) VALUES (6, 'User', 1, 1); +INSERT INTO TBL_AUTH_GROUP (group_id, group_name, is_role, locked) VALUES (7, 'Reporter', 1, 1); +INSERT INTO TBL_AUTH_GROUP (group_id, group_name, is_role, locked) VALUES (8, 'Assignee', 1, 1); +INSERT INTO TBL_AUTH_GROUP (group_id, group_name, is_role, locked) VALUES (9, 'Owner', 1, 1); + CREATE TABLE TBL_AUTH_GROUP_seq ( id int unsigned auto_increment not null primary key); -INSERT INTO TBL_AUTH_GROUP_seq values (3); +INSERT INTO TBL_AUTH_GROUP_seq values (9); -# ... and four permissions +# ... and fourteen permissions INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (1, 'Admin'); 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'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (7, 'CommentBug'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (8, 'EditPriority'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (9, 'EditStatus'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (10, 'EditSeverity'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (11, 'EditResolution'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (12, 'EditProject'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (13, 'EditComponent'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (14, 'ManageBug'); # Admins can do all the admin stuff, INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (1, 1); # 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); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (5, 7); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (6, 2); + +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (7, 5); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (7, 10); # developers can own bugs, and INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (3, 4); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (3, 5); + +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (8, 8); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (8, 9); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (8, 11); # 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 INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (4, 12); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (4, 13); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (4, 14); + +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 6); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 7); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 8); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 9); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 10); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 11); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 13); # Insert user_id 1 into the admin group Index: mysqli.in =================================================================== RCS file: /cvsroot/phpbt/phpbt/schemas/mysqli.in,v retrieving revision 1.3 retrieving revision 1.4 diff -u -r1.3 -r1.4 --- mysqli.in 2 Oct 2005 20:57:40 -0000 1.3 +++ mysqli.in 31 Oct 2005 21:34:35 -0000 1.4 @@ -30,6 +30,7 @@ created_date bigint(20) unsigned NOT NULL default '0', last_modified_by int(10) unsigned NOT NULL default '0', last_modified_date bigint(20) unsigned NOT NULL default '0', + is_role tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (group_id) ) TYPE=MyISAM; @@ -390,6 +391,10 @@ INSERT INTO TBL_AUTH_USER + (user_id, login, first_name, last_name, email, password, active) + values (0, 'Anonymous User', 'Anonymous', 'User', '', '', 0); + +INSERT INTO TBL_AUTH_USER (user_id, login, first_name, last_name, email, password) values (1, 'OPTION_ADMIN_EMAIL', 'System', 'Admin', 'OPTION_ADMIN_EMAIL', 'OPTION_ADMIN_PASS'); @@ -399,39 +404,73 @@ INSERT INTO TBL_AUTH_USER_seq values (1); -# Start off with three user levels... +# Start off with four 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_AUTH_GROUP (group_id, group_name, locked) VALUES (4, 'Manager', 1); +# ... six user roles ... +INSERT INTO TBL_AUTH_GROUP (group_id, group_name, is_role, locked) VALUES (5, 'Guest', 1, 1); +INSERT INTO TBL_AUTH_GROUP (group_id, group_name, is_role, locked) VALUES (6, 'User', 1, 1); +INSERT INTO TBL_AUTH_GROUP (group_id, group_name, is_role, locked) VALUES (7, 'Reporter', 1, 1); +INSERT INTO TBL_AUTH_GROUP (group_id, group_name, is_role, locked) VALUES (8, 'Assignee', 1, 1); +INSERT INTO TBL_AUTH_GROUP (group_id, group_name, is_role, locked) VALUES (9, 'Owner', 1, 1); + CREATE TABLE TBL_AUTH_GROUP_seq ( id int unsigned auto_increment not null primary key); -INSERT INTO TBL_AUTH_GROUP_seq values (3); +INSERT INTO TBL_AUTH_GROUP_seq values (9); -# ... and four permissions +# ... and fourteen permissions INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (1, 'Admin'); 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'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (7, 'CommentBug'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (8, 'EditPriority'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (9, 'EditStatus'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (10, 'EditSeverity'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (11, 'EditResolution'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (12, 'EditProject'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (13, 'EditComponent'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (14, 'ManageBug'); # Admins can do all the admin stuff, INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (1, 1); # 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); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (5, 7); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (6, 2); + +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (7, 5); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (7, 10); # developers can own bugs, and INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (3, 4); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (3, 5); + +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (8, 8); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (8, 9); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (8, 11); # 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 INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (4, 12); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (4, 13); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (4, 14); + +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 6); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 7); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 8); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 9); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 10); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 11); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 13); # Insert user_id 1 into the admin group Index: oci8.in =================================================================== RCS file: /cvsroot/phpbt/phpbt/schemas/oci8.in,v retrieving revision 1.33 retrieving revision 1.34 diff -u -r1.33 -r1.34 --- oci8.in 2 Oct 2005 20:57:40 -0000 1.33 +++ oci8.in 31 Oct 2005 21:34:35 -0000 1.34 @@ -30,6 +30,7 @@ created_date number(20) default '0' NOT NULL, last_modified_by number(10) default '0' NOT NULL, last_modified_date number(20) default '0' NOT NULL, + is_role number(1) default '0' NOT NULL, PRIMARY KEY (group_id) ) ; @@ -395,6 +396,10 @@ INSERT INTO TBL_AUTH_USER + (user_id, login, first_name, last_name, email, password, active) + values (0, 'Anonymous User', 'Anonymous', 'User', '', '', 0); + +INSERT INTO TBL_AUTH_USER (user_id, login, first_name, last_name, email, password) values (1, 'OPTION_ADMIN_EMAIL', 'System', 'Admin', 'OPTION_ADMIN_EMAIL', 'OPTION_ADMIN_PASS'); @@ -402,37 +407,71 @@ CREATE SEQUENCE TBL_AUTH_USER_seq START WITH 2 NOCACHE; -# Start off with three user levels... +# Start off with four 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_AUTH_GROUP (group_id, group_name, locked) VALUES (4, 'Manager', 1); -CREATE SEQUENCE TBL_AUTH_GROUP_seq START WITH 4 NOCACHE; +# ... six user roles ... +INSERT INTO TBL_AUTH_GROUP (group_id, group_name, is_role, locked) VALUES (5, 'Guest', 1, 1); +INSERT INTO TBL_AUTH_GROUP (group_id, group_name, is_role, locked) VALUES (6, 'User', 1, 1); +INSERT INTO TBL_AUTH_GROUP (group_id, group_name, is_role, locked) VALUES (7, 'Reporter', 1, 1); +INSERT INTO TBL_AUTH_GROUP (group_id, group_name, is_role, locked) VALUES (8, 'Assignee', 1, 1); +INSERT INTO TBL_AUTH_GROUP (group_id, group_name, is_role, locked) VALUES (9, 'Owner', 1, 1); + +CREATE SEQUENCE TBL_AUTH_GROUP_seq START WITH 10 NOCACHE; -# ... and four permissions +# ... and fourteen permissions INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (1, 'Admin'); 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'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (7, 'CommentBug'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (8, 'EditPriority'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (9, 'EditStatus'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (10, 'EditSeverity'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (11, 'EditResolution'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (12, 'EditProject'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (13, 'EditComponent'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (14, 'ManageBug'); # Admins can do all the admin stuff, INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (1, 1); # 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); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (5, 7); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (6, 2); + +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (7, 5); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (7, 10); # developers can own bugs, and INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (3, 4); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (3, 5); + +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (8, 8); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (8, 9); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (8, 11); # 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 INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (4, 12); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (4, 13); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (4, 14); + +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 6); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 7); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 8); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 9); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 10); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 11); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 13); # Insert user_id 1 into the admin group Index: pgsql.in =================================================================== RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.in,v retrieving revision 1.52 retrieving revision 1.53 diff -u -r1.52 -r1.53 --- pgsql.in 2 Oct 2005 20:57:40 -0000 1.52 +++ pgsql.in 31 Oct 2005 21:34:35 -0000 1.53 @@ -30,6 +30,7 @@ created_date INT8 NOT NULL DEFAULT '0', last_modified_by INT4 NOT NULL DEFAULT '0', last_modified_date INT8 NOT NULL DEFAULT '0', + is_role INT2 NOT NULL DEFAULT 0, PRIMARY KEY (group_id) ); @@ -383,6 +384,10 @@ INSERT INTO TBL_AUTH_USER + (user_id, login, first_name, last_name, email, password, active) + values (0, 'Anonymous User', 'Anonymous', 'User', '', '', 0); + +INSERT INTO TBL_AUTH_USER (user_id, login, first_name, last_name, email, password) values (1, 'OPTION_ADMIN_EMAIL', 'System', 'Admin', 'OPTION_ADMIN_EMAIL', 'OPTION_ADMIN_PASS'); @@ -390,37 +395,70 @@ CREATE SEQUENCE TBL_AUTH_USER_seq START 2; -# Start off with three user levels... +# Start off with four 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_AUTH_GROUP (group_id, group_name, locked) VALUES (4, 'Manager', 1); -CREATE SEQUENCE TBL_AUTH_GROUP_seq START 4; +# ... six user roles ... +INSERT INTO TBL_AUTH_GROUP (group_id, group_name, is_role, locked) VALUES (5, 'Guest', 1, 1); +INSERT INTO TBL_AUTH_GROUP (group_id, group_name, is_role, locked) VALUES (6, 'User', 1, 1); +INSERT INTO TBL_AUTH_GROUP (group_id, group_name, is_role, locked) VALUES (7, 'Reporter', 1, 1); +INSERT INTO TBL_AUTH_GROUP (group_id, group_name, is_role, locked) VALUES (8, 'Assignee', 1, 1); +INSERT INTO TBL_AUTH_GROUP (group_id, group_name, is_role, locked) VALUES (9, 'Owner', 1, 1); +CREATE SEQUENCE TBL_AUTH_GROUP_seq START 10; -# ... and four permissions +# ... and fourteen permissions INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (1, 'Admin'); 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'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (7, 'CommentBug'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (8, 'EditPriority'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (9, 'EditStatus'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (10, 'EditSeverity'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (11, 'EditResolution'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (12, 'EditProject'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (13, 'EditComponent'); +INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (14, 'ManageBug'); # Admins can do all the admin stuff, INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (1, 1); # 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); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (5, 7); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (6, 2); + +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (7, 5); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (7, 10); # developers can own bugs, and INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (3, 4); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (3, 5); + +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (8, 8); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (8, 9); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (8, 11); # 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 INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (4, 12); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (4, 13); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (4, 14); + +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 6); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 7); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 8); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 9); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 10); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 11); +INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (9, 13); # Insert user_id 1 into the admin group |