Files
data_factory/migrations/002_add_storage_columns.sql

6 lines
301 B
SQL

-- Migration 002: track where each run's extracted data is stored.
-- Aditiva, idempotente (SQLite ALTER ADD COLUMN + "duplicate column" ignorado en app code).
ALTER TABLE runs ADD COLUMN storage_db_id TEXT NOT NULL DEFAULT '';
ALTER TABLE runs ADD COLUMN storage_table TEXT NOT NULL DEFAULT '';