This is an automated email from the git hooks/post-receive script. New commit to branch develop in repository observe. See https://gitlab.nuiton.org/codelutin/observe.git commit 7d7bdee0c14b473c81dcf131adeea62936326b63 Author: Tony CHEMIT <chemit@codelutin.com> Date: Fri Nov 4 08:04:08 2016 +0100 Correction de la migration des SpeciesFate (Fixes #8377) --- .../migration/V5_1_16_evol_8377_speciesFate_add_discard-H2.sql | 9 ++++++++- .../migration/V5_1_16_evol_8377_speciesFate_add_discard-PG.sql | 9 ++++++++- 2 files changed, 16 insertions(+), 2 deletions(-) diff --git a/entities-migration/src/main/resources/db/migration/V5_1_16_evol_8377_speciesFate_add_discard-H2.sql b/entities-migration/src/main/resources/db/migration/V5_1_16_evol_8377_speciesFate_add_discard-H2.sql index 18ae37a..bc1b035 100644 --- a/entities-migration/src/main/resources/db/migration/V5_1_16_evol_8377_speciesFate_add_discard-H2.sql +++ b/entities-migration/src/main/resources/db/migration/V5_1_16_evol_8377_speciesFate_add_discard-H2.sql @@ -1 +1,8 @@ -ALTER TABLE observe_seine.speciesfate ADD COLUMN discard BOOLEAN DEFAULT false; \ No newline at end of file +ALTER TABLE observe_seine.speciesfate ADD COLUMN discard BOOLEAN; +UPDATE observe_seine.speciesfate SET discard = true WHERE code ='1'; +UPDATE observe_seine.speciesfate SET discard = true WHERE code ='3'; +UPDATE observe_seine.speciesfate SET discard = true WHERE code ='4'; +UPDATE observe_seine.speciesfate SET discard = true WHERE code ='5'; +UPDATE observe_seine.speciesfate SET discard = true WHERE code ='2'; +UPDATE observe_seine.speciesfate SET discard = false WHERE code ='6'; +UPDATE observe_seine.speciesfate SET discard = false WHERE code ='8'; diff --git a/entities-migration/src/main/resources/db/migration/V5_1_16_evol_8377_speciesFate_add_discard-PG.sql b/entities-migration/src/main/resources/db/migration/V5_1_16_evol_8377_speciesFate_add_discard-PG.sql index 18ae37a..bc1b035 100644 --- a/entities-migration/src/main/resources/db/migration/V5_1_16_evol_8377_speciesFate_add_discard-PG.sql +++ b/entities-migration/src/main/resources/db/migration/V5_1_16_evol_8377_speciesFate_add_discard-PG.sql @@ -1 +1,8 @@ -ALTER TABLE observe_seine.speciesfate ADD COLUMN discard BOOLEAN DEFAULT false; \ No newline at end of file +ALTER TABLE observe_seine.speciesfate ADD COLUMN discard BOOLEAN; +UPDATE observe_seine.speciesfate SET discard = true WHERE code ='1'; +UPDATE observe_seine.speciesfate SET discard = true WHERE code ='3'; +UPDATE observe_seine.speciesfate SET discard = true WHERE code ='4'; +UPDATE observe_seine.speciesfate SET discard = true WHERE code ='5'; +UPDATE observe_seine.speciesfate SET discard = true WHERE code ='2'; +UPDATE observe_seine.speciesfate SET discard = false WHERE code ='6'; +UPDATE observe_seine.speciesfate SET discard = false WHERE code ='8'; -- To stop receiving notification emails like this one, please contact codelutin.com SCM administrator <admin+scm@codelutin.com>.