summaryrefslogtreecommitdiff
path: root/database/001_games.sql
diff options
context:
space:
mode:
Diffstat (limited to 'database/001_games.sql')
-rw-r--r--database/001_games.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/database/001_games.sql b/database/001_games.sql
index be45084..a500aa6 100644
--- a/database/001_games.sql
+++ b/database/001_games.sql
@@ -10,3 +10,4 @@ CREATE TABLE games (
);
CREATE INDEX idx_games_player1 ON games(player1);
CREATE INDEX idx_games_player2 ON games(player2);
+CREATE INDEX idx_games_last_move_at ON games(last_move_at);