/ db / migrations / 089-messages-direction-default.sql
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;