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 [LL] Perte des données saisies "catchhealthstatus" et "discardhealthstatus" dans table "catch" depuis le passage à 7.6.2 - Closes #1624 - - - - - 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: ===================================== persistence/src/main/resources/db/migration/7.4/03_rename_referential-H2.sql ===================================== @@ -29,7 +29,7 @@ INSERT INTO observe_longline.StomachFullness(topiaId, topiaVersion, topiaCreateD ALTER TABLE observe_longline.Catch ADD COLUMN discardHealthStatus VARCHAR(255); ALTER TABLE observe_longline.Catch ADD COLUMN catchHealthStatus VARCHAR(255); ALTER TABLE observe_longline.Catch ADD COLUMN stomachFullness VARCHAR(255); -UPDATE observe_longline.Catch SET discardHealthStatus = REPLACE(discardHealthStatus, 'Healthness','HealthStatus'), catchHealthStatus = REPLACE(catchHealthStatus, 'Healthness','HealthStatus'), stomachFullness = REPLACE(stomachFullness, 'StomacFullness','StomachFullness'); +UPDATE observe_longline.Catch SET discardHealthStatus = REPLACE(discardHealthness, 'Healthness', 'HealthStatus'), catchHealthStatus = REPLACE(catchHealthness, 'Healthness', 'HealthStatus'), stomachFullness = REPLACE(stomacFullness, 'StomacFullness','StomachFullness'); ALTER TABLE observe_longline.Catch DROP COLUMN discardHealthness; ALTER TABLE observe_longline.Catch DROP COLUMN catchHealthness; ALTER TABLE observe_longline.Catch DROP COLUMN stomacFullness; ===================================== persistence/src/main/resources/db/migration/7.4/03_rename_referential-PG.sql ===================================== @@ -28,7 +28,7 @@ INSERT INTO observe_longline.StomachFullness(topiaId, topiaVersion, topiaCreateD ALTER TABLE observe_longline.Catch ADD COLUMN discardHealthStatus VARCHAR(255); ALTER TABLE observe_longline.Catch ADD COLUMN catchHealthStatus VARCHAR(255); ALTER TABLE observe_longline.Catch ADD COLUMN stomachFullness VARCHAR(255); -UPDATE observe_longline.Catch SET discardHealthStatus = REPLACE(discardHealthStatus, 'Healthness','HealthStatus'), catchHealthStatus = REPLACE(catchHealthStatus, 'Healthness','HealthStatus'), stomachFullness = REPLACE(stomachFullness, 'StomacFullness','StomachFullness'); +UPDATE observe_longline.Catch SET discardHealthStatus = REPLACE(discardHealthness, 'Healthness', 'HealthStatus'), catchHealthStatus = REPLACE(catchHealthness, 'Healthness', 'HealthStatus'), stomachFullness = REPLACE(stomacFullness, 'StomacFullness','StomachFullness'); ALTER TABLE observe_longline.Catch DROP COLUMN discardHealthness CASCADE; ALTER TABLE observe_longline.Catch DROP COLUMN catchHealthness CASCADE; ALTER TABLE observe_longline.Catch DROP COLUMN stomacFullness CASCADE; View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/commit/73b7a9101f2d021761dfee2601... -- View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/commit/73b7a9101f2d021761dfee2601... You're receiving this email because of your account on gitlab.com.