Author: bleny Date: 2010-11-08 22:50:25 +0000 (Mon, 08 Nov 2010) New Revision: 752 Log: remove potential bugs by adding a default value for new column in DB Modified: trunk/wao-business/src/main/java/fr/ifremer/wao/PostgresMigrationCallback.java Modified: trunk/wao-business/src/main/java/fr/ifremer/wao/PostgresMigrationCallback.java =================================================================== --- trunk/wao-business/src/main/java/fr/ifremer/wao/PostgresMigrationCallback.java 2010-11-08 22:49:50 UTC (rev 751) +++ trunk/wao-business/src/main/java/fr/ifremer/wao/PostgresMigrationCallback.java 2010-11-08 22:50:25 UTC (rev 752) @@ -437,7 +437,6 @@ /** Add a columns to Contact. */ @Override protected void addDataReliability_1_6(List<String> queries) { - queries.add("ALTER TABLE Contact ADD dataReliabilityOrdinal SMALLINT;"); - queries.add("UPDATE Contact SET dataReliabilityOrdinal=0;"); + queries.add("ALTER TABLE Contact ADD dataReliabilityOrdinal SMALLINT NOT NULL DEFAULT 0;"); } }