SQL

CREATE TABLE user  (
  id INTEGER NOT NULL,
  username VARCHAR(80) NOT NULL,
  password_hash VARCHAR(128) NOT NULL,
  extra TEXT,
  is_admin BOOLEAN,
  PRIMARY KEY (id),
  UNIQUE (username)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
username VARCHAR(80) Rename | Drop
password_hash VARCHAR(128) Rename | Drop
extra TEXT ✓ Rename | Drop
is_admin BOOLEAN ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_user_1 username ✓ SQL
-- no sql found --
 Drop