[phpBT-dev] CVS: phpbt/schemas mysql.in,1.46,1.47

[Ulf E. <ulf...@us...>]

Update of /cvsroot/phpbt/phpbt/schemas
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10527/schemas

Modified Files:
	mysql.in 
Log Message:
Removed the hardcoded "assignable" bit from TBL_AUTH_GROUP and instead added a new entry in TBL_AUTH_PERM named "Assignable".


Index: mysql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/mysql.in,v
retrieving revision 1.46
retrieving revision 1.47
diff -u -r1.46 -r1.47
--- mysql.in	22 Aug 2005 19:44:47 -0000	1.46
+++ mysql.in	22 Aug 2005 19:58:25 -0000	1.47
@@ -19,7 +19,6 @@
   group_id int(10) unsigned NOT NULL default '0',
   group_name varchar(80) NOT NULL default '',
   locked tinyint(1) unsigned NOT NULL default '0',
-  assignable tinyint(1) unsigned NOT NULL default '0',
   created_by int(10) unsigned NOT NULL default '0',
   created_date bigint(20) unsigned NOT NULL default '0',
   last_modified_by int(10) unsigned NOT NULL default '0',
@@ -300,7 +299,7 @@
 # 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, assignable) VALUES (3, 'Developer', 1, 1);
+INSERT INTO TBL_AUTH_GROUP (group_id, group_name, locked) VALUES (3, 'Developer', 1);
 create table TBL_AUTH_GROUP_seq (id int unsigned auto_increment not null primary key);
 insert into TBL_AUTH_GROUP_seq values (3);
 
@@ -308,14 +307,17 @@
 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 (3, 'EditAssignment');
+INSERT INTO TBL_AUTH_PERM (perm_id, perm_name) VALUES (4, 'Assignable');
 
-# Admins can do all the admin stuff and users can edit bugs
+# Admins can do all the admin stuff, users can edit bugs, and
+# developers are users who can own bugs 
 INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (1, 1);
 INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (2, 2);
+INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (3, 2);
+INSERT INTO TBL_GROUP_PERM (group_id, perm_id) VALUES (3, 4);
 
-# And user_id 1 is an admin and a user
+# Insert user_id 1 into the admin group 
 INSERT INTO TBL_USER_GROUP (user_id, group_id) VALUES (1, 1);
-INSERT INTO TBL_USER_GROUP (user_id, group_id) VALUES (1, 2);
 
 # Add user's prefs as default values for all users defined so far (only admin)
 INSERT INTO TBL_USER_PREF (user_id) SELECT USER_ID FROM TBL_AUTH_USER;