Author: gmazza
Date: Fri Aug 16 17:03:38 2013
New Revision: 1514790
URL: http://svn.apache.org/r1514790
Log:
ROL-1969 fix migration scripts for PostgreSQL
Modified:
roller/branches/roller_5.0/weblogger-business/src/main/resources/sql/400-to-500-migration.vm
Modified:
roller/branches/roller_5.0/weblogger-business/src/main/resources/sql/400-to-500-migration.vm
URL:
http://svn.apache.org/viewvc/roller/branches/roller_5.0/weblogger-business/src/main/resources/sql/400-to-500-migration.vm?rev=1514790&r1=1514789&r2=1514790&view=diff
==============================================================================
---
roller/branches/roller_5.0/weblogger-business/src/main/resources/sql/400-to-500-migration.vm
(original)
+++
roller/branches/roller_5.0/weblogger-business/src/main/resources/sql/400-to-500-migration.vm
Fri Aug 16 17:03:38 2013
@@ -25,17 +25,17 @@ create table roller_permission (
);
insert into roller_permission
(id,username,actions,objectid,objecttype,pending,datecreated)
- select #concat("w.id" "u.username"), u.username, 'edit_draft', w.handle,
'Weblog', 0, current_timestamp
+ select #concat("w.id" "u.username"), u.username, 'edit_draft', w.handle,
'Weblog', $db.BOOLEAN_FALSE, 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 #concat("w.id" "u.username"), u.username, 'author', w.handle,
'Weblog', 0, current_timestamp
+ select #concat("w.id" "u.username"), u.username, 'author', w.handle,
'Weblog', $db.BOOLEAN_FALSE, 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 #concat("w.id" "u.username"), u.username, 'admin', w.handle,
'Weblog', 0, current_timestamp
+ select #concat("w.id" "u.username"), u.username, 'admin', w.handle,
'Weblog', $db.BOOLEAN_FALSE, 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;
