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';
|
