svn commit: r571443 - /roller/branches/roller_4.1_dev/apps/weblogger/src/sql/400-to-410-migration.vm

[sn...@apache.org]

Author: snoopdave
Date: Fri Aug 31 05:22:35 2007
New Revision: 571443

URL: http://svn.apache.org/viewvc?rev=571443&view=rev
Log:
More progress on permssions. SQL code to migrate from old permission table to new, so far tested only with Derby.

http://opensource.atlassian.com/projects/roller/browse/ROL-1534

Modified:
    roller/branches/roller_4.1_dev/apps/weblogger/src/sql/400-to-410-migration.vm

Modified: roller/branches/roller_4.1_dev/apps/weblogger/src/sql/400-to-410-migration.vm
URL: http://svn.apache.org/viewvc/roller/branches/roller_4.1_dev/apps/weblogger/src/sql/400-to-410-migration.vm?rev=571443&r1=571442&r2=571443&view=diff
==============================================================================
--- roller/branches/roller_4.1_dev/apps/weblogger/src/sql/400-to-410-migration.vm (original)
+++ roller/branches/roller_4.1_dev/apps/weblogger/src/sql/400-to-410-migration.vm Fri Aug 31 05:22:35 2007
@@ -19,9 +19,17 @@
 
 #dropNotNullFromColumn("userrole" "userid" "varchar(48)")
 
+insert into roller_permission (id,username,actions,objectid,objecttype,pending,datecreated) 
+   select w.id||u.username, u.username, 'edit_draft', w.id, 'Weblog', 0, current_timestamp
+      from rolleruser as u, website as w, roller_user_permissions as p
+      where p.user_id = u.id and p.website_id = w.id and permission_mask = 1;
 
-insert into roller_permission 
-   select u.username, w.id, p.perm
+insert into roller_permission (id,username,actions,objectid,objecttype,pending,datecreated) 
+   select w.id||u.username, u.username, 'author', w.id, 'Weblog', 0, current_timestamp
       from rolleruser as u, website as w, roller_user_permissions as p
-      where p.user_id = u.id and p.website_id = w.id;
+      where p.user_id = u.id and p.website_id = w.id and permission_mask = 2;
 
+insert into roller_permission (id,username,actions,objectid,objecttype,pending,datecreated) 
+   select w.id||u.username, u.username, 'admin', w.id, 'Weblog', 0, current_timestamp
+      from rolleruser as u, website as w, roller_user_permissions as p
+      where p.user_id = u.id and p.website_id = w.id and permission_mask = 3;