roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From gma...@apache.org
Subject svn commit: r1514786 - /roller/trunk/app/src/main/resources/sql/400-to-500-migration.vm
Date Fri, 16 Aug 2013 16:58:22 GMT
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;
 



Mime
View raw message