|
From: Benjamin C. <bc...@us...> - 2001-08-28 03:51:36
|
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'); |