roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From gma...@apache.org
Subject svn commit: r1514790 - /roller/branches/roller_5.0/weblogger-business/src/main/resources/sql/400-to-500-migration.vm
Date Fri, 16 Aug 2013 17:03:38 GMT
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;
 



Mime
View raw message