Author: bleny Date: 2014-07-29 17:12:53 +0200 (Tue, 29 Jul 2014) New Revision: 2181 Url: http://forge.codelutin.com/projects/wao/repository/revisions/2181 Log: refs #4481 fix migration Modified: trunk/wao-persistence/src/main/resources/db/migration/V4_1__clean_database.sql Modified: trunk/wao-persistence/src/main/resources/db/migration/V4_1__clean_database.sql =================================================================== --- trunk/wao-persistence/src/main/resources/db/migration/V4_1__clean_database.sql 2014-07-29 14:59:20 UTC (rev 2180) +++ trunk/wao-persistence/src/main/resources/db/migration/V4_1__clean_database.sql 2014-07-29 15:12:53 UTC (rev 2181) @@ -111,7 +111,7 @@ WHEN 2 THEN 'DISTRICT' WHEN 3 THEN 'REGION' END; -ALTER TABLE SampleRow RENAME COLUMN locationTypeOrdinal TO locationType; +ALTER TABLE TerrestrialLocation RENAME COLUMN locationTypeOrdinal TO locationType; ALTER TABLE UserProfile ALTER COLUMN obsProgramOrdinal TYPE character varying(255) USING CASE obsProgramOrdinal WHEN 0 THEN 'OBSMER'