Query

homilies.db — users

SQL

CREATE TABLE users  (
  id            INTEGER PRIMARY KEY AUTOINCREMENT,
  username      TEXT UNIQUE NOT NULL,
  password_hash TEXT NOT NULL,
  created_at    TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  last_login    TIMESTAMP,
  email         TEXT
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
username TEXT Rename | Drop
password_hash TEXT Rename | Drop
created_at TIMESTAMP ✓ Rename | Drop
last_login TIMESTAMP ✓ Rename | Drop
email TEXT ✓ Rename | Drop

+ Add index

Indexes

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