Query

mira.db — access_codes

SQL

CREATE TABLE access_codes  (
  code       TEXT PRIMARY KEY,
  user_id    TEXT NOT NULL REFERENCES users(id),
  expires_at INTEGER NOT NULL,
  used_at    INTEGER,
  created_at INTEGER NOT NULL DEFAULT (unixepoch())
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
code TEXT ✓ ✓ Rename | Drop
user_id TEXT Rename | Drop
expires_at INTEGER Rename | Drop
used_at INTEGER ✓ Rename | Drop
created_at INTEGER Rename | Drop

Foreign Keys

Column Destination
user_id users.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_access_codes_1 code ✓ SQL
-- no sql found --
 Drop