From 038c877aed55cffdb4401a4c7e7b15b113798145 Mon Sep 17 00:00:00 2001 From: Julien Dessaux Date: Tue, 22 Nov 2022 22:55:36 +0100 Subject: Implemented game creation --- database/001_games.sql | 1 + 1 file changed, 1 insertion(+) (limited to 'database/001_games.sql') 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); -- cgit v1.2.3