SQL

CREATE TABLE "pager_question_options"  (
  id               INTEGER PRIMARY KEY AUTOINCREMENT,
  question_id      TEXT NOT NULL,
  option_key       TEXT NOT NULL,
  option_text      TEXT NOT NULL DEFAULT '',
  sort_order       INTEGER DEFAULT 0,
  create_time      DATETIME DEFAULT (datetime('now')),
  UNIQUE(question_id, option_key)
)

+ Add column

Columns

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

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_qo_qid question_id SQL 
CREATE INDEX idx_qo_qid
ON "pager_question_options"(question_id)
Drop
sqlite_autoindex_pager_question_options_1
  • question_id
  • option_key
 ✓ SQL
-- no sql found --
 Drop