Query

cards.db — email_verification_tokens

SQL

CREATE TABLE email_verification_tokens  (
  id TEXT PRIMARY KEY,
  user_id TEXT NOT NULL,
  token TEXT UNIQUE NOT NULL,
  expires_at DATETIME NOT NULL,
  verified_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
verified_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_email_verification_tokens_token token SQL 
CREATE INDEX idx_email_verification_tokens_token
ON email_verification_tokens(token)
Drop
sqlite_autoindex_email_verification_tokens_1 id ✓ SQL
-- no sql found --
 Drop
sqlite_autoindex_email_verification_tokens_2 token ✓ SQL
-- no sql found --
 Drop