SQL

CREATE TABLE "pager_knowledge_points"  (
  id          INTEGER PRIMARY KEY AUTOINCREMENT,
  kp_code     TEXT NOT NULL UNIQUE,
  kp_name     TEXT NOT NULL,
  parent_code TEXT,
  subject     TEXT DEFAULT '',
  create_time DATETIME DEFAULT (datetime('now'))
)

+ Add column

Columns

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

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_kp_parent parent_code SQL 
CREATE INDEX idx_kp_parent
ON "pager_knowledge_points"(parent_code)
Drop
sqlite_autoindex_pager_knowledge_points_1 kp_code ✓ SQL
-- no sql found --
 Drop