migrations/0001_create_scores.sql 333 B raw
1
CREATE TABLE IF NOT EXISTS scores (
2
  id          INTEGER PRIMARY KEY AUTOINCREMENT,
3
  player_name TEXT    NOT NULL,
4
  score       INTEGER NOT NULL,
5
  end_frame   INTEGER NOT NULL,
6
  duration_ms INTEGER NOT NULL,
7
  created_at  DATETIME DEFAULT CURRENT_TIMESTAMP
8
);
9
CREATE INDEX IF NOT EXISTS idx_scores_score ON scores (score DESC);