This is an automated email from the git hooks/post-receive script. New commit to branch develop in repository wao. See http://git.codelutin.com/wao.git commit c8247a751389c904fc91006b3b50a33d0c8747f2 Author: Brendan Le Ny <bleny@codelutin.com> Date: Thu Oct 23 16:27:38 2014 +0200 Par migration sql, on supprime de la base des clause DEFAULT obsolètes --- ...to_int.sql => V4_2__average_tide_time_to_int,_clean_defaults.sql} | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/wao-persistence/src/main/resources/db/migration/V4_2__average_tide_time_to_int.sql b/wao-persistence/src/main/resources/db/migration/V4_2__average_tide_time_to_int,_clean_defaults.sql similarity index 78% rename from wao-persistence/src/main/resources/db/migration/V4_2__average_tide_time_to_int.sql rename to wao-persistence/src/main/resources/db/migration/V4_2__average_tide_time_to_int,_clean_defaults.sql index acba741..612ad66 100644 --- a/wao-persistence/src/main/resources/db/migration/V4_2__average_tide_time_to_int.sql +++ b/wao-persistence/src/main/resources/db/migration/V4_2__average_tide_time_to_int,_clean_defaults.sql @@ -22,3 +22,8 @@ -- On change le type de la colonne pour entier en arrondissant à l'entier supérieur ALTER TABLE SampleRow ALTER COLUMN averageTideTime TYPE integer USING ceiling(averageTideTime); + +-- On supprime des default qui n'ont plus de sens suite à la conversion ordinal vers name dans champs de type énumaration + +ALTER TABLE Contact ALTER COLUMN dataReliability DROP DEFAULT; +ALTER TABLE SampleRow ALTER COLUMN averageObservationsCount DROP DEFAULT; -- To stop receiving notification emails like this one, please contact codelutin.com SCM administrator <admin+scm@codelutin.com>.