[phpBT-dev] CVS: phpbt perms.sql,1.5,1.6

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

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

Modified Files:
	perms.sql 
Log Message:
Getting ready for release -- this will be folded into dbchanges.sql

Index: perms.sql
===================================================================
RCS file: /cvsroot/phpbt/phpbt/perms.sql,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -r1.5 -r1.6
--- perms.sql	2001/09/03 20:22:42	1.5
+++ perms.sql	2001/09/04 03:45:40	1.6
@@ -21,11 +21,11 @@
 
 # And user_id 1 is the admin and a user
 insert into user_group (user_id, group_id) values (1, 1, 0, 0);
-insert into user_group (user_id, group_id) values (1, 2, 0, 0);
+insert into user_group select user_id, 2, created_by, created_date from auth_user;
 
 # 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;
+#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;