SQL

CREATE TABLE users  (
  id VARCHAR NOT NULL,
  username VARCHAR NOT NULL,
  password_hash VARCHAR NOT NULL,
  is_admin BOOLEAN NOT NULL,
  created_at DATETIME NOT NULL,
  PRIMARY KEY (id),
  UNIQUE (username)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id VARCHAR ✓ Rename | Drop
username VARCHAR Rename | Drop
password_hash VARCHAR Rename | Drop
is_admin BOOLEAN Rename | Drop
created_at DATETIME Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_users_1 id ✓ SQL
-- no sql found --
 Drop
sqlite_autoindex_users_2 username ✓ SQL
-- no sql found --
 Drop