Skip to content

Variable: MATCHES_SCHEMA ​

ts
const MATCHES_SCHEMA: "\nCREATE TABLE IF NOT EXISTS tickflare_matches (\n  id TEXT PRIMARY KEY,\n  room TEXT,\n  ended_at INTEGER NOT NULL,\n  players TEXT NOT NULL,\n  result TEXT NOT NULL,\n  replay_key TEXT\n);\nCREATE INDEX IF NOT EXISTS tickflare_matches_ended_at ON tickflare_matches (ended_at DESC);\n";

Defined in: server/matches.ts:20

The table recordMatches writes to. It creates it on first use; this is here if you prefer migrations.

MIT licence. Tickflare is an independent project and is not affiliated with Cloudflare.