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;
