[phpBT-dev] CVS: phpbt perms.sql,1.1,1.2 dbchanges.sql,1.8,1.9

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

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

Modified Files:
	perms.sql dbchanges.sql 
Log Message:
Added login field to auth_user

Index: perms.sql
===================================================================
RCS file: /cvsroot/phpbt/phpbt/perms.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- perms.sql	2001/08/25 04:48:55	1.1
+++ perms.sql	2001/08/25 15:46:32	1.2
@@ -23,5 +23,6 @@
 # You can use these queries to convert the post 0.2.x / pre 0.3.0 schema
 alter table user rename auth_user;
 alter table auth_user change user_level active tinyint unsigned not null;
+alter table auth_user add login char(40) not null after user_id;
 update auth_user set active = 1 where active > 0;
- 
+update auth_user set login = email;

Index: dbchanges.sql
===================================================================
RCS file: /cvsroot/phpbt/phpbt/dbchanges.sql,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -r1.8 -r1.9
--- dbchanges.sql	2001/08/25 04:48:55	1.8
+++ dbchanges.sql	2001/08/25 15:46:32	1.9
@@ -138,6 +138,7 @@
 
 CREATE TABLE `auth_user` (
   `user_id` int(10) unsigned NOT NULL default '0',
+	`login` char(40) NOT NULL default '',
   `first_name` char(40) NOT NULL default '',
   `last_name` char(40) NOT NULL default '',
   `email` char(60) NOT NULL default '',