Author: snoopdave Date: Fri Aug 31 09:12:38 2007 New Revision: 571506 URL: http://svn.apache.org/viewvc?rev=571506&view=rev Log: More progress on permssions. Fixing migration script, we use weblog handle to uniquely identify weblogs.
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=571506&r1=571505&r2=571506&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 09:12:38 2007 @@ -20,16 +20,16 @@ #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 + select w.id||u.username, u.username, 'edit_draft', w.handle, '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 (id,username,actions,objectid,objecttype,pending,datecreated) - select w.id||u.username, u.username, 'author', w.id, 'Weblog', 0, current_timestamp + select w.id||u.username, u.username, 'author', w.handle, '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 = 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 + select w.id||u.username, u.username, 'admin', w.handle, '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;
