[Phpslash-commit] CVS: phpslash-ft/tables/0.65 6_to_65.sql,1.3,1.4

[Joe S. <joe...@us...>]

Update of /cvsroot/phpslash/phpslash-ft/tables/0.65
In directory usw-pr-cvs1:/tmp/cvs-serv7767

Modified Files:
	6_to_65.sql 
Log Message:
upgrade bugfix - seclev -> perms

Index: 6_to_65.sql
===================================================================
RCS file: /cvsroot/phpslash/phpslash-ft/tables/0.65/6_to_65.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** 6_to_65.sql	2001/09/24 16:32:06	1.3
--- 6_to_65.sql	2001/11/20 14:49:57	1.4
***************
*** 5,6 ****
--- 5,13 ----
  ALTER TABLE psl_topic_lut ADD INDEX(story_id);
  ALTER TABLE psl_author ADD perms VARCHAR (255);
+ update psl_author set perms='nobody,user,topic,story' where seclev > '9' and seclev < '100';
+ update psl_author set perms='nobody,user,topic,story,submission' where seclev > '99' and seclev < '1000';
+ update psl_author set perms='nobody,user,topic,story,submission,section,block,poll' where seclev > '999' and seclev < '10000';
+ 
+ update psl_author set perms='nobody,user,topic,story,section,submission,block,poll,author,variable,glossary,mailinglist,logging,comment' where seclev > '9999' and seclev < '1000000';
+ 
+ update psl_author set perms='root,nobody,user,topic,story,section,submission,block,poll,author,variable,glossary,mailinglist,logging,comment' where seclev > '999999';