# 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'))
)
""")
# <>