SQL

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

+ Add column

Columns

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

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_psq_asgn assignment_id SQL 
CREATE INDEX idx_psq_asgn
ON "pager_paper_section_questions"(assignment_id)
Drop
idx_psq_sec section_id SQL 
CREATE INDEX idx_psq_sec
ON "pager_paper_section_questions"(section_id)
Drop
sqlite_autoindex_pager_paper_section_questions_1
  • section_id
  • question_id
 ✓ SQL
-- no sql found --
 Drop