SQL

CREATE TABLE parents  (
  id          TEXT PRIMARY KEY,
  phone       TEXT UNIQUE NOT NULL,
  wx_openid   TEXT UNIQUE,
  nickname    TEXT,
  created_at  DATETIME DEFAULT (datetime('now')),
  updated_at  DATETIME DEFAULT (datetime('now'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
phone TEXT Rename | Drop
wx_openid TEXT ✓ Rename | Drop
nickname TEXT ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop
updated_at DATETIME ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_parents_1 id ✓ SQL
-- no sql found --
 Drop
sqlite_autoindex_parents_2 phone ✓ SQL
-- no sql found --
 Drop
sqlite_autoindex_parents_3 wx_openid ✓ SQL
-- no sql found --
 Drop