SQL

CREATE TABLE users  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  username TEXT UNIQUE NOT NULL,
  password TEXT NOT NULL,
  name TEXT NOT NULL,
  role TEXT NOT NULL DEFAULT 'user' CHECK(role IN ('admin','user','viewer','client')),
  active INTEGER NOT NULL DEFAULT 1,
  created_at TEXT NOT NULL DEFAULT (datetime('now','localtime')),
  updated_at TEXT NOT NULL DEFAULT (datetime('now','localtime')),
  profile_id INTEGER REFERENCES user_profiles(id) ON DELETE SET NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
username TEXT Rename | Drop
password TEXT Rename | Drop
name TEXT Rename | Drop
role TEXT Rename | Drop
active INTEGER Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT Rename | Drop
profile_id INTEGER ✓ Rename | Drop

Foreign Keys

Column Destination
profile_id user_profiles.id

+ Add index

Indexes

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