[phpBT-dev] CVS: phpbt dbchanges.sql,1.9,1.10 perms.sql,1.2,1.3

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv1872

Modified Files:
	dbchanges.sql perms.sql 
Log Message:
Some cleanup

Index: dbchanges.sql
===================================================================
RCS file: /cvsroot/phpbt/phpbt/dbchanges.sql,v
retrieving revision 1.9
retrieving revision 1.10
diff -u -r1.9 -r1.10
--- dbchanges.sql	2001/08/25 15:46:32	1.9
+++ dbchanges.sql	2001/08/28 03:51:33	1.10
@@ -149,9 +149,10 @@
   `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',
-  PRIMARY KEY  (`user_id`)
+  PRIMARY KEY  (`user_id`),
+	UNIQUE login (login)
 );
-insert into auth_user select UserID, FirstName, LastName, Email, Password, if (UserLevel > 0, 1, 0), '', 0, CreatedDate, 0, CreatedDate from User;
+insert into auth_user select UserID, Email, FirstName, LastName, Email, Password, if (UserLevel > 0, 1, 0), '', 0, CreatedDate, 0, CreatedDate from User;
 
 CREATE TABLE `version` (
   `version_id` int(10) unsigned NOT NULL default '0',

Index: perms.sql
===================================================================
RCS file: /cvsroot/phpbt/phpbt/perms.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- perms.sql	2001/08/25 15:46:32	1.2
+++ perms.sql	2001/08/28 03:51:33	1.3
@@ -4,6 +4,7 @@
 create table user_perm (user_id int unsigned not null, perm_id int unsigned not null, primary key (user_id, perm_id), key (perm_id));
 create table group_perm (group_id int unsigned not null, perm_id int unsigned not null, primary key (group_id, perm_id), key (perm_id));
 create table bug_group (bug_id int unsigned not null, group_id int unsigned not null, primary key (bug_id, group_id), key (group_id));
+create table project_group (project_id int unsigned not null, group_id int unsigned not null, primary key (project_id, group_id), key (group_id));
 
 # Start off with two user levels...
 insert into auth_group (group_id, group_name) values (1, 'admin');