Query

pilot.db — account_invites

SQL

CREATE TABLE account_invites  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  account_id INTEGER NOT NULL REFERENCES accounts(id) ON DELETE CASCADE,
  email TEXT NOT NULL,
  token TEXT NOT NULL UNIQUE,
  invited_by_trainer_id INTEGER NOT NULL REFERENCES trainers(id) ON DELETE CASCADE,
  created_at TEXT NOT NULL DEFAULT (datetime('now')),
  expires_at TEXT NOT NULL,
  accepted_at TEXT,
  cancelled_at TEXT
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
account_id INTEGER Rename | Drop
email TEXT Rename | Drop
token TEXT Rename | Drop
invited_by_trainer_id INTEGER Rename | Drop
created_at TEXT Rename | Drop
expires_at TEXT Rename | Drop
accepted_at TEXT ✓ Rename | Drop
cancelled_at TEXT ✓ Rename | Drop

Foreign Keys

Column Destination
invited_by_trainer_id trainers.id
account_id accounts.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_invites_account account_id SQL 
CREATE INDEX idx_invites_account
ON account_invites(account_id)
Drop
idx_invites_email email SQL 
CREATE INDEX idx_invites_email
ON account_invites(email)
Drop
idx_invites_token token SQL 
CREATE INDEX idx_invites_token
ON account_invites(token)
Drop
sqlite_autoindex_account_invites_1 token ✓ SQL
-- no sql found --
 Drop