089-messages-direction-default.sql
1 -- Migration 089: Add DEFAULT 'outbound' to messages.direction 2 -- SQLite doesn't support ALTER COLUMN to add defaults; this is a schema-only documentation fix. 3 -- The DEFAULT is enforced at the application level and in new databases (via schema.sql). 4 -- Existing rows already have 'outbound' or 'inbound' values so no data migration needed. 5 -- No-op migration to maintain version continuity. 6 SELECT 1;