diff options
author | Julien Dessaux | 2022-11-22 22:55:36 +0100 |
---|---|---|
committer | Julien Dessaux | 2022-11-22 22:55:36 +0100 |
commit | 038c877aed55cffdb4401a4c7e7b15b113798145 (patch) | |
tree | e2902779e76ba8bd60b63be0e512a3c112530d68 /database/001_games.sql | |
parent | Added basic games handling (diff) | |
download | jeux-de-mots-038c877aed55cffdb4401a4c7e7b15b113798145.tar.gz jeux-de-mots-038c877aed55cffdb4401a4c7e7b15b113798145.tar.bz2 jeux-de-mots-038c877aed55cffdb4401a4c7e7b15b113798145.zip |
Implemented game creation
Diffstat (limited to '')
-rw-r--r-- | database/001_games.sql | 1 |
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); |