Query

diam.db — users

SQL

CREATE TABLE users  (
  id INTEGER PRIMARY KEY ON CONFLICT REPLACE AUTOINCREMENT UNIQUE ON CONFLICT REPLACE NOT NULL,
  name TEXT NOT NULL,
  password TEXT NOT NULL,
  email TEXT,
  role TEXT
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
name TEXT Rename | Drop
password TEXT Rename | Drop
email TEXT ✓ Rename | Drop
role TEXT ✓ Rename | Drop

+ Add index

Indexes

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