SQL

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

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
question_id TEXT Rename | Drop
media_type TEXT ✓ Rename | Drop
option_key TEXT ✓ Rename | Drop
media_url TEXT Rename | Drop
sort_order INTEGER ✓ Rename | Drop
create_time DATETIME ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_qm_qid question_id SQL 
CREATE INDEX idx_qm_qid
ON "pager_question_media"(question_id)
Drop