Author: tchemit Date: 2012-04-13 18:27:58 +0200 (Fri, 13 Apr 2012) New Revision: 3264 Url: http://chorem.org/repositories/revision/pollen/3264 Log: fix migration script for postgres Modified: trunk/pollen-persistence/src/main/java/org/chorem/pollen/entities/migration/PollenMigrationCallbackV1_3.java Modified: trunk/pollen-persistence/src/main/java/org/chorem/pollen/entities/migration/PollenMigrationCallbackV1_3.java =================================================================== --- trunk/pollen-persistence/src/main/java/org/chorem/pollen/entities/migration/PollenMigrationCallbackV1_3.java 2012-04-13 15:48:45 UTC (rev 3263) +++ trunk/pollen-persistence/src/main/java/org/chorem/pollen/entities/migration/PollenMigrationCallbackV1_3.java 2012-04-13 16:27:58 UTC (rev 3264) @@ -91,9 +91,11 @@ queries.add("ALTER TABLE comment ADD COLUMN author VARCHAR(255);"); - queries.add("UPDATE comment c SET c.author = (SELECT p.votingId FROM pollAccount p WHERE c.pollAccount = p.topiaId);"); + queries.add("UPDATE comment AS c SET c.author = (SELECT p.votingId FROM pollAccount p WHERE c.pollAccount = p.topiaId);"); - queries.add("ALTER TABLE comment ALTER COLUMN author VARCHAR(255) NOT NULL;"); + queries.add("ALTER TABLE comment ALTER COLUMN author TYPE VARCHAR(255);"); + queries.add("UPDATE comment SET author = 'anonymous' WHERE author IS NULL;"); + queries.add("ALTER TABLE comment ALTER COLUMN author SET NOT NULL;"); } private void addForeignKeyIndexes(List<String> queries) {