# AUTO-GENERATED shared artifact: database migrations aggregated across IUs. # Each region below is OWNED by exactly one Implementation Unit. Editing inside a # region is drift attributed to that IU; Phoenix regenerates the whole file. from src.db import register_migration # <> register_migration("issues", """ CREATE TABLE IF NOT EXISTS issues ( id INTEGER PRIMARY KEY AUTOINCREMENT, title TEXT NOT NULL, description TEXT NOT NULL DEFAULT '', status TEXT NOT NULL DEFAULT 'backlog', priority TEXT NOT NULL DEFAULT 'normal', point_estimate INTEGER, assignee TEXT, labels TEXT, sprint_id INTEGER, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), completed_at TEXT, FOREIGN KEY (sprint_id) REFERENCES sprints (id) ) """) # <> # <> register_migration("sprints", """ CREATE TABLE IF NOT EXISTS sprints ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, goal TEXT DEFAULT '', start_date TEXT NOT NULL, end_date TEXT NOT NULL, capacity INTEGER, is_current INTEGER DEFAULT 0, is_closed INTEGER DEFAULT 0, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')) ) """) # <>