SQL

CREATE TABLE institutions  (
  id              TEXT PRIMARY KEY,
  name            TEXT NOT NULL,
  address         TEXT DEFAULT '',
  contact         TEXT DEFAULT '',
  phone           TEXT DEFAULT '',
  student_count   INTEGER DEFAULT 0,
  created_at      DATETIME DEFAULT (datetime('now'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
name TEXT Rename | Drop
address TEXT ✓ Rename | Drop
contact TEXT ✓ Rename | Drop
phone TEXT ✓ Rename | Drop
student_count INTEGER ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_institutions_1 id ✓ SQL
-- no sql found --
 Drop