Author: gmazza
Date: Fri Aug 16 16:58:22 2013
New Revision: 1514786
URL: http://svn.apache.org/r1514786
Log:
ROL-1969 fix migration scripts for PostgreSQL
Modified:
roller/trunk/app/src/main/resources/sql/400-to-500-migration.vm
Modified: roller/trunk/app/src/main/resources/sql/400-to-500-migration.vm
URL:
http://svn.apache.org/viewvc/roller/trunk/app/src/main/resources/sql/400-to-500-migration.vm?rev=1514786&r1=1514785&r2=1514786&view=diff
==============================================================================
--- roller/trunk/app/src/main/resources/sql/400-to-500-migration.vm (original)
+++ roller/trunk/app/src/main/resources/sql/400-to-500-migration.vm Fri Aug 16
16:58:22 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;
