You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@roller.apache.org by gm...@apache.org on 2013/08/16 19:03:38 UTC

svn commit: r1514790 - /roller/branches/roller_5.0/weblogger-business/src/main/resources/sql/400-to-500-migration.vm

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;