Query

mira.db — sessions

SQL

CREATE TABLE sessions  (
  id         TEXT PRIMARY KEY,
  user_id    TEXT NOT NULL REFERENCES users(id),
  method     TEXT NOT NULL,
  expires_at INTEGER NOT NULL,
  created_at INTEGER NOT NULL DEFAULT (unixepoch())
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
user_id TEXT Rename | Drop
method TEXT Rename | Drop
expires_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_sessions_1 id ✓ SQL
-- no sql found --
 Drop