Tony CHEMIT pushed to branch develop at ultreiaio / ird-observe Commits: 1e0eaa67 by Tony CHEMIT at 2018-04-24T08:57:05Z Fix migration script - - - - - 2 changed files: - persistence/src/main/resources/db/migration/7.1/01_add_non_target_catch_release_status-H2.sql - persistence/src/main/resources/db/migration/7.1/01_add_non_target_catch_release_status-PG.sql Changes: ===================================== persistence/src/main/resources/db/migration/7.1/01_add_non_target_catch_release_status-H2.sql ===================================== --- a/persistence/src/main/resources/db/migration/7.1/01_add_non_target_catch_release_status-H2.sql +++ b/persistence/src/main/resources/db/migration/7.1/01_add_non_target_catch_release_status-H2.sql @@ -31,7 +31,7 @@ INSERT INTO observe_seine.NonTargetCatchReleaseStatus(topiaid, topiaversion, top UPDATE observe_seine.NonTargetCatchReleaseStatus SET label3 = label2 || ' TODO'; ALTER TABLE observe_seine.NonTargetCatchRelease add column status2 VARCHAR(255); -ALTER TABLE observe_seine.NonTargetCatchRelease ADD CONSTRAINT fk_NonTargetCatchRelease_status FOREIGN KEY (status) REFERENCES observe_seine.NonTargetCatchReleaseStatus(topiaid); +ALTER TABLE observe_seine.NonTargetCatchRelease ADD CONSTRAINT fk_NonTargetCatchRelease_status FOREIGN KEY (status2) REFERENCES observe_seine.NonTargetCatchReleaseStatus(topiaid); UPDATE observe_seine.NonTargetCatchRelease SET status2 = 'fr.ird.observe.entities.referentiel.seine.NonTargetCatchReleaseStatus#0#1' WHERE status = 0; UPDATE observe_seine.NonTargetCatchRelease SET status2 = 'fr.ird.observe.entities.referentiel.seine.NonTargetCatchReleaseStatus#0#2' WHERE status = 1; UPDATE observe_seine.NonTargetCatchRelease SET status2 = 'fr.ird.observe.entities.referentiel.seine.NonTargetCatchReleaseStatus#0#3' WHERE status = 2; ===================================== persistence/src/main/resources/db/migration/7.1/01_add_non_target_catch_release_status-PG.sql ===================================== --- a/persistence/src/main/resources/db/migration/7.1/01_add_non_target_catch_release_status-PG.sql +++ b/persistence/src/main/resources/db/migration/7.1/01_add_non_target_catch_release_status-PG.sql @@ -31,7 +31,7 @@ INSERT INTO observe_seine.NonTargetCatchReleaseStatus(topiaid, topiaversion, top UPDATE observe_seine.NonTargetCatchReleaseStatus SET label3 = label2 || ' TODO'; ALTER TABLE observe_seine.NonTargetCatchRelease ADD COLUMN status2 VARCHAR(255); -ALTER TABLE observe_seine.NonTargetCatchRelease ADD CONSTRAINT fk_NonTargetCatchRelease_status FOREIGN KEY (status) REFERENCES observe_seine.NonTargetCatchReleaseStatus(topiaid); +ALTER TABLE observe_seine.NonTargetCatchRelease ADD CONSTRAINT fk_NonTargetCatchRelease_status FOREIGN KEY (status2) REFERENCES observe_seine.NonTargetCatchReleaseStatus(topiaid); UPDATE observe_seine.NonTargetCatchRelease SET status2 = 'fr.ird.observe.entities.referentiel.seine.NonTargetCatchReleaseStatus#0#1' WHERE status = 0; UPDATE observe_seine.NonTargetCatchRelease SET status2 = 'fr.ird.observe.entities.referentiel.seine.NonTargetCatchReleaseStatus#0#2' WHERE status = 1; UPDATE observe_seine.NonTargetCatchRelease SET status2 = 'fr.ird.observe.entities.referentiel.seine.NonTargetCatchReleaseStatus#0#3' WHERE status = 2; View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/commit/1e0eaa675fd47f351a0d0534da36... --- View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/commit/1e0eaa675fd47f351a0d0534da36... You're receiving this email because of your account on gitlab.com.
participants (1)
-
Tony CHEMIT