diff options
| -rw-r--r-- | internal/storage/db.go | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/internal/storage/db.go b/internal/storage/db.go index 51ea648..4eebd04 100644 --- a/internal/storage/db.go +++ b/internal/storage/db.go @@ -180,6 +180,15 @@ func (s *DB) migrate() error { created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL )`, + // Additive columns for DBs created before the full stories schema was + // established. CREATE TABLE IF NOT EXISTS is a no-op on old DBs, so each + // new column needs its own ALTER TABLE to land on existing tables. + `ALTER TABLE stories ADD COLUMN epic_id TEXT`, + `ALTER TABLE stories ADD COLUMN discovery_source TEXT`, + `ALTER TABLE stories ADD COLUMN spec TEXT`, + `ALTER TABLE stories ADD COLUMN acceptance_criteria_json TEXT NOT NULL DEFAULT '[]'`, + `ALTER TABLE stories ADD COLUMN priority TEXT`, + `ALTER TABLE stories ADD COLUMN root_task_id TEXT`, `CREATE INDEX IF NOT EXISTS idx_epics_status ON epics(status)`, `CREATE INDEX IF NOT EXISTS idx_stories_status ON stories(status)`, `CREATE INDEX IF NOT EXISTS idx_stories_epic_id ON stories(epic_id)`, |