Add Column
Current Schema
CREATE TABLE "pager_question_media" (
id INTEGER PRIMARY KEY AUTOINCREMENT,
question_id TEXT NOT NULL,
media_type TEXT DEFAULT 'content'
CHECK(media_type IN ('content','option','explanation')),
option_key TEXT,
media_url TEXT NOT NULL,
sort_order INTEGER DEFAULT 0,
create_time DATETIME DEFAULT (datetime('now'))
)