Add Column
Current Schema
CREATE TABLE review_topics (
id TEXT PRIMARY KEY,
package_id TEXT NOT NULL REFERENCES review_packages(id) ON DELETE CASCADE,
topic_name TEXT NOT NULL,
priority INTEGER DEFAULT 3 CHECK(priority BETWEEN 0 AND 5),
error_count INTEGER DEFAULT 0,
mastery REAL DEFAULT 0,
ai_content TEXT DEFAULT '[]',
status TEXT DEFAULT 'pending' CHECK(status IN ('pending','in_progress','mastered')),
created_at DATETIME DEFAULT (datetime('now'))
)