Tony CHEMIT pushed to branch develop at ultreiaio / ird-observe Commits: e55750fd by Tony Chemit at 2022-06-08T11:28:36+02:00 Plantage de la migration 9.0 (avec l'appli 9.0.2) - Closes #2394 - - - - - 1 changed file: - core/persistence/resources/src/main/resources/db/migration/v9/9.0/99_0_add_missing_not_null-common.sql Changes: ===================================== core/persistence/resources/src/main/resources/db/migration/v9/9.0/99_0_add_missing_not_null-common.sql ===================================== @@ -87,10 +87,10 @@ ALTER TABLE ll_logbook.FloatlinesComposition ALTER COLUMN length SET NOT NULL; ALTER TABLE ll_logbook.FloatlinesComposition ALTER COLUMN lineType SET NOT NULL; ALTER TABLE ll_logbook.HooksComposition ALTER COLUMN hookType SET NOT NULL; -- See https://gitlab.com/ultreiaio/ird-observe/-/issues/2373 -ALTER TABLE ll_logbook.BaitsComposition ALTER COLUMN proportion SET NULL; -ALTER TABLE ll_logbook.BranchlinesComposition ALTER COLUMN proportion SET NULL; -ALTER TABLE ll_logbook.FloatlinesComposition ALTER COLUMN proportion SET NULL; -ALTER TABLE ll_logbook.HooksComposition ALTER COLUMN proportion SET NULL; +ALTER TABLE ll_logbook.BaitsComposition ALTER COLUMN proportion DROP NOT NULL; +ALTER TABLE ll_logbook.BranchlinesComposition ALTER COLUMN proportion DROP NOT NULL; +ALTER TABLE ll_logbook.FloatlinesComposition ALTER COLUMN proportion DROP NOT NULL; +ALTER TABLE ll_logbook.HooksComposition ALTER COLUMN proportion DROP NOT NULL; ALTER TABLE ll_logbook.Sample ALTER COLUMN timeStamp SET NOT NULL; ALTER TABLE ll_logbook.SamplePart ALTER COLUMN count SET NOT NULL; @@ -202,8 +202,8 @@ ALTER TABLE ps_logbook.Catch ALTER COLUMN species SET NOT NULL; -- See #2385 -- ALTER TABLE ps_logbook.Catch ALTER COLUMN weightMeasureMethod SET NOT NULL; -- ALTER TABLE ps_logbook.Catch ALTER COLUMN weight SET NOT NULL; -ALTER TABLE ps_logbook.Catch ALTER COLUMN weightMeasureMethod SET NULL; -ALTER TABLE ps_logbook.Catch ALTER COLUMN weight SET NULL; +ALTER TABLE ps_logbook.Catch ALTER COLUMN weightMeasureMethod DROP NOT NULL; +ALTER TABLE ps_logbook.Catch ALTER COLUMN weight DROP NOT NULL; ALTER TABLE ps_logbook.FloatingObjectPart ALTER COLUMN objectMaterial SET NOT NULL; ALTER TABLE ps_logbook.Route ALTER COLUMN date SET NOT NULL; ALTER TABLE ps_logbook.Sample ALTER COLUMN sampleQuality SET NOT NULL; View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/commit/e55750fd2d31e8a58e2d36998d... -- View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/commit/e55750fd2d31e8a58e2d36998d... You're receiving this email because of your account on gitlab.com.