Tony CHEMIT pushed to branch develop at ultreiaio / ird-observe
Commits:
-
1e0eaa67
by Tony CHEMIT at 2018-04-24T08:57:05Z
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:
| ... | ... | @@ -31,7 +31,7 @@ INSERT INTO observe_seine.NonTargetCatchReleaseStatus(topiaid, topiaversion, top |
| 31 | 31 |
UPDATE observe_seine.NonTargetCatchReleaseStatus SET label3 = label2 || ' TODO';
|
| 32 | 32 |
|
| 33 | 33 |
ALTER TABLE observe_seine.NonTargetCatchRelease add column status2 VARCHAR(255);
|
| 34 |
-ALTER TABLE observe_seine.NonTargetCatchRelease ADD CONSTRAINT fk_NonTargetCatchRelease_status FOREIGN KEY (status) REFERENCES observe_seine.NonTargetCatchReleaseStatus(topiaid);
|
|
| 34 |
+ALTER TABLE observe_seine.NonTargetCatchRelease ADD CONSTRAINT fk_NonTargetCatchRelease_status FOREIGN KEY (status2) REFERENCES observe_seine.NonTargetCatchReleaseStatus(topiaid);
|
|
| 35 | 35 |
UPDATE observe_seine.NonTargetCatchRelease SET status2 = 'fr.ird.observe.entities.referentiel.seine.NonTargetCatchReleaseStatus#0#1' WHERE status = 0;
|
| 36 | 36 |
UPDATE observe_seine.NonTargetCatchRelease SET status2 = 'fr.ird.observe.entities.referentiel.seine.NonTargetCatchReleaseStatus#0#2' WHERE status = 1;
|
| 37 | 37 |
UPDATE observe_seine.NonTargetCatchRelease SET status2 = 'fr.ird.observe.entities.referentiel.seine.NonTargetCatchReleaseStatus#0#3' WHERE status = 2;
|
| ... | ... | @@ -31,7 +31,7 @@ INSERT INTO observe_seine.NonTargetCatchReleaseStatus(topiaid, topiaversion, top |
| 31 | 31 |
UPDATE observe_seine.NonTargetCatchReleaseStatus SET label3 = label2 || ' TODO';
|
| 32 | 32 |
|
| 33 | 33 |
ALTER TABLE observe_seine.NonTargetCatchRelease ADD COLUMN status2 VARCHAR(255);
|
| 34 |
-ALTER TABLE observe_seine.NonTargetCatchRelease ADD CONSTRAINT fk_NonTargetCatchRelease_status FOREIGN KEY (status) REFERENCES observe_seine.NonTargetCatchReleaseStatus(topiaid);
|
|
| 34 |
+ALTER TABLE observe_seine.NonTargetCatchRelease ADD CONSTRAINT fk_NonTargetCatchRelease_status FOREIGN KEY (status2) REFERENCES observe_seine.NonTargetCatchReleaseStatus(topiaid);
|
|
| 35 | 35 |
UPDATE observe_seine.NonTargetCatchRelease SET status2 = 'fr.ird.observe.entities.referentiel.seine.NonTargetCatchReleaseStatus#0#1' WHERE status = 0;
|
| 36 | 36 |
UPDATE observe_seine.NonTargetCatchRelease SET status2 = 'fr.ird.observe.entities.referentiel.seine.NonTargetCatchReleaseStatus#0#2' WHERE status = 1;
|
| 37 | 37 |
UPDATE observe_seine.NonTargetCatchRelease SET status2 = 'fr.ird.observe.entities.referentiel.seine.NonTargetCatchReleaseStatus#0#3' WHERE status = 2;
|