Query

cards.db — password_reset_tokens

SQL

CREATE TABLE password_reset_tokens  (
  id TEXT PRIMARY KEY,
  user_id TEXT NOT NULL,
  token TEXT UNIQUE NOT NULL,
  expires_at DATETIME NOT NULL,
  used_at DATETIME,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
user_id TEXT Rename | Drop
token TEXT Rename | Drop
expires_at DATETIME Rename | Drop
used_at DATETIME ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop

Foreign Keys

Column Destination
user_id users.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_password_reset_tokens_token token SQL 
CREATE INDEX idx_password_reset_tokens_token
ON password_reset_tokens(token)
Drop
sqlite_autoindex_password_reset_tokens_1 id ✓ SQL
-- no sql found --
 Drop
sqlite_autoindex_password_reset_tokens_2 token ✓ SQL
-- no sql found --
 Drop