| ... |
... |
@@ -87,10 +87,10 @@ ALTER TABLE ll_logbook.FloatlinesComposition ALTER COLUMN length SET NOT NULL; |
|
87
|
87
|
ALTER TABLE ll_logbook.FloatlinesComposition ALTER COLUMN lineType SET NOT NULL;
|
|
88
|
88
|
ALTER TABLE ll_logbook.HooksComposition ALTER COLUMN hookType SET NOT NULL;
|
|
89
|
89
|
-- See https://gitlab.com/ultreiaio/ird-observe/-/issues/2373
|
|
90
|
|
-ALTER TABLE ll_logbook.BaitsComposition ALTER COLUMN proportion SET NULL;
|
|
91
|
|
-ALTER TABLE ll_logbook.BranchlinesComposition ALTER COLUMN proportion SET NULL;
|
|
92
|
|
-ALTER TABLE ll_logbook.FloatlinesComposition ALTER COLUMN proportion SET NULL;
|
|
93
|
|
-ALTER TABLE ll_logbook.HooksComposition ALTER COLUMN proportion SET NULL;
|
|
|
90
|
+ALTER TABLE ll_logbook.BaitsComposition ALTER COLUMN proportion DROP NOT NULL;
|
|
|
91
|
+ALTER TABLE ll_logbook.BranchlinesComposition ALTER COLUMN proportion DROP NOT NULL;
|
|
|
92
|
+ALTER TABLE ll_logbook.FloatlinesComposition ALTER COLUMN proportion DROP NOT NULL;
|
|
|
93
|
+ALTER TABLE ll_logbook.HooksComposition ALTER COLUMN proportion DROP NOT NULL;
|
|
94
|
94
|
|
|
95
|
95
|
ALTER TABLE ll_logbook.Sample ALTER COLUMN timeStamp SET NOT NULL;
|
|
96
|
96
|
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; |
|
202
|
202
|
-- See #2385
|
|
203
|
203
|
-- ALTER TABLE ps_logbook.Catch ALTER COLUMN weightMeasureMethod SET NOT NULL;
|
|
204
|
204
|
-- ALTER TABLE ps_logbook.Catch ALTER COLUMN weight SET NOT NULL;
|
|
205
|
|
-ALTER TABLE ps_logbook.Catch ALTER COLUMN weightMeasureMethod SET NULL;
|
|
206
|
|
-ALTER TABLE ps_logbook.Catch ALTER COLUMN weight SET NULL;
|
|
|
205
|
+ALTER TABLE ps_logbook.Catch ALTER COLUMN weightMeasureMethod DROP NOT NULL;
|
|
|
206
|
+ALTER TABLE ps_logbook.Catch ALTER COLUMN weight DROP NOT NULL;
|
|
207
|
207
|
ALTER TABLE ps_logbook.FloatingObjectPart ALTER COLUMN objectMaterial SET NOT NULL;
|
|
208
|
208
|
ALTER TABLE ps_logbook.Route ALTER COLUMN date SET NOT NULL;
|
|
209
|
209
|
ALTER TABLE ps_logbook.Sample ALTER COLUMN sampleQuality SET NOT NULL;
|