Variable: ACCOUNTS_SCHEMA

const ACCOUNTS_SCHEMA: "\nCREATE TABLE IF NOT EXISTS tickflare_accounts (\n  id TEXT PRIMARY KEY,\n  name TEXT NOT NULL,\n  name_key TEXT NOT NULL UNIQUE,\n  email TEXT,\n  password_hash TEXT NOT NULL,\n  created_at INTEGER NOT NULL,\n  password_changed_at INTEGER NOT NULL\n);\nCREATE TABLE IF NOT EXISTS tickflare_sessions (\n  token_hash TEXT PRIMARY KEY,\n  account_id TEXT NOT NULL,\n  created_at INTEGER NOT NULL,\n  expires_at INTEGER NOT NULL\n);\nCREATE INDEX IF NOT EXISTS tickflare_sessions_account ON tickflare_sessions (account_id);\nCREATE TABLE IF NOT EXISTS tickflare_player_data (\n  player TEXT NOT NULL,\n  key TEXT NOT NULL,\n  value TEXT NOT NULL,\n  updated_at INTEGER NOT NULL,\n  PRIMARY KEY (player, key)\n);\nCREATE TABLE IF NOT EXISTS tickflare_player_stats (\n  player TEXT NOT NULL,\n  stat TEXT NOT NULL,\n  value REAL NOT NULL,\n  updated_at INTEGER NOT NULL,\n  PRIMARY KEY (player, stat)\n);\nCREATE INDEX IF NOT EXISTS tickflare_player_stats_board ON tickflare_player_stats (stat, value DESC);\nCREATE TABLE IF NOT EXISTS tickflare_stat_awards (\n  key TEXT PRIMARY KEY,\n  awarded_at INTEGER NOT NULL\n);\nCREATE TABLE IF NOT EXISTS tickflare_sign_in_failures (\n  key TEXT PRIMARY KEY,\n  failures INTEGER NOT NULL,\n  window_start INTEGER NOT NULL\n);\nCREATE TABLE IF NOT EXISTS tickflare_recovery (\n  token_hash TEXT PRIMARY KEY,\n  account_id TEXT NOT NULL,\n  kind TEXT NOT NULL,\n  created_at INTEGER NOT NULL,\n  expires_at INTEGER\n);\nCREATE INDEX IF NOT EXISTS tickflare_recovery_account ON tickflare_recovery (account_id);\n";

Defined in: server/accounts.ts:179

The tables, in case you prefer to apply them as a migration. Accounts creates them on first use.