SQL

CREATE TABLE "pager_question_knowledge"  (
  id          INTEGER PRIMARY KEY AUTOINCREMENT,
  question_id TEXT NOT NULL,
  kp_code     TEXT NOT NULL,
  create_time DATETIME DEFAULT (datetime('now')),
  UNIQUE(question_id, kp_code)
)

+ Add column

Columns

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

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_qk_qid question_id SQL 
CREATE INDEX idx_qk_qid
ON "pager_question_knowledge"(question_id)
Drop
sqlite_autoindex_pager_question_knowledge_1
  • question_id
  • kp_code
 ✓ SQL
-- no sql found --
 Drop