Tony CHEMIT pushed to branch develop-7.x at ultreiaio / ird-observe
Commits:
-
73b7a910
by Tony Chemit at 2020-11-01T10:37:51+01:00
2 changed files:
- persistence/src/main/resources/db/migration/7.4/03_rename_referential-H2.sql
- persistence/src/main/resources/db/migration/7.4/03_rename_referential-PG.sql
Changes:
| ... | ... | @@ -29,7 +29,7 @@ INSERT INTO observe_longline.StomachFullness(topiaId, topiaVersion, topiaCreateD |
| 29 | 29 |
ALTER TABLE observe_longline.Catch ADD COLUMN discardHealthStatus VARCHAR(255);
|
| 30 | 30 |
ALTER TABLE observe_longline.Catch ADD COLUMN catchHealthStatus VARCHAR(255);
|
| 31 | 31 |
ALTER TABLE observe_longline.Catch ADD COLUMN stomachFullness VARCHAR(255);
|
| 32 |
-UPDATE observe_longline.Catch SET discardHealthStatus = REPLACE(discardHealthStatus, 'Healthness','HealthStatus'), catchHealthStatus = REPLACE(catchHealthStatus, 'Healthness','HealthStatus'), stomachFullness = REPLACE(stomachFullness, 'StomacFullness','StomachFullness');
|
|
| 32 |
+UPDATE observe_longline.Catch SET discardHealthStatus = REPLACE(discardHealthness, 'Healthness', 'HealthStatus'), catchHealthStatus = REPLACE(catchHealthness, 'Healthness', 'HealthStatus'), stomachFullness = REPLACE(stomacFullness, 'StomacFullness','StomachFullness');
|
|
| 33 | 33 |
ALTER TABLE observe_longline.Catch DROP COLUMN discardHealthness;
|
| 34 | 34 |
ALTER TABLE observe_longline.Catch DROP COLUMN catchHealthness;
|
| 35 | 35 |
ALTER TABLE observe_longline.Catch DROP COLUMN stomacFullness;
|
| ... | ... | @@ -28,7 +28,7 @@ INSERT INTO observe_longline.StomachFullness(topiaId, topiaVersion, topiaCreateD |
| 28 | 28 |
ALTER TABLE observe_longline.Catch ADD COLUMN discardHealthStatus VARCHAR(255);
|
| 29 | 29 |
ALTER TABLE observe_longline.Catch ADD COLUMN catchHealthStatus VARCHAR(255);
|
| 30 | 30 |
ALTER TABLE observe_longline.Catch ADD COLUMN stomachFullness VARCHAR(255);
|
| 31 |
-UPDATE observe_longline.Catch SET discardHealthStatus = REPLACE(discardHealthStatus, 'Healthness','HealthStatus'), catchHealthStatus = REPLACE(catchHealthStatus, 'Healthness','HealthStatus'), stomachFullness = REPLACE(stomachFullness, 'StomacFullness','StomachFullness');
|
|
| 31 |
+UPDATE observe_longline.Catch SET discardHealthStatus = REPLACE(discardHealthness, 'Healthness', 'HealthStatus'), catchHealthStatus = REPLACE(catchHealthness, 'Healthness', 'HealthStatus'), stomachFullness = REPLACE(stomacFullness, 'StomacFullness','StomachFullness');
|
|
| 32 | 32 |
ALTER TABLE observe_longline.Catch DROP COLUMN discardHealthness CASCADE;
|
| 33 | 33 |
ALTER TABLE observe_longline.Catch DROP COLUMN catchHealthness CASCADE;
|
| 34 | 34 |
ALTER TABLE observe_longline.Catch DROP COLUMN stomacFullness CASCADE;
|