path: root/makima/migrations/20260304000000_reconcile_mode_to_text.sql

-- 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';