diff options
Diffstat (limited to 'makima/migrations/20260304000000_reconcile_mode_to_text.sql')
| -rw-r--r-- | makima/migrations/20260304000000_reconcile_mode_to_text.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/makima/migrations/20260304000000_reconcile_mode_to_text.sql b/makima/migrations/20260304000000_reconcile_mode_to_text.sql new file mode 100644 index 0000000..a15dd77 --- /dev/null +++ b/makima/migrations/20260304000000_reconcile_mode_to_text.sql @@ -0,0 +1,4 @@ +-- Change reconcile_mode from BOOLEAN to TEXT with three-way enum: auto, semi-auto, manual. +-- Backward compatibility: true -> 'semi-auto', false -> 'auto'. +ALTER TABLE directives ALTER COLUMN reconcile_mode TYPE TEXT USING CASE WHEN reconcile_mode THEN 'semi-auto' ELSE 'auto' END; +ALTER TABLE directives ALTER COLUMN reconcile_mode SET DEFAULT 'auto'; |