summaryrefslogtreecommitdiff
path: root/server.js
diff options
context:
space:
mode:
authorTor Andersson <tor@ccxvii.net>2023-07-05 15:15:21 +0200
committerTor Andersson <tor@ccxvii.net>2023-07-13 14:10:20 +0200
commit9a455686c7e71e71fa84514760e9fb3202da1ca7 (patch)
tree05d9a04bd8a87fa3471a0a7a0fa04d90ef367837 /server.js
parentd4eaac958d3c5c68a6e4bfd47ababb61bd9fd524 (diff)
downloadserver-9a455686c7e71e71fa84514760e9fb3202da1ca7.tar.gz
Add "xtime" column for games to record finish date when state is missing.
Diffstat (limited to 'server.js')
-rw-r--r--server.js2
1 files changed, 1 insertions, 1 deletions
diff --git a/server.js b/server.js
index 4cc8e05..65f5a7a 100644
--- a/server.js
+++ b/server.js
@@ -1061,7 +1061,7 @@ const SQL_DELETE_GAME_NOTE = SQL("DELETE FROM game_notes WHERE game_id=? AND rol
const SQL_SELECT_GAME_STATE = SQL("SELECT state FROM game_state WHERE game_id=?").pluck()
const SQL_UPDATE_GAME_STATE = SQL("INSERT OR REPLACE INTO game_state (game_id,state,active,mtime) VALUES (?,?,?,datetime())")
-const SQL_UPDATE_GAME_RESULT = SQL("UPDATE games SET status=?, result=? WHERE game_id=?")
+const SQL_UPDATE_GAME_RESULT = SQL("UPDATE games SET status=?, result=?, xtime=datetime() WHERE game_id=?")
const SQL_UPDATE_GAME_PRIVATE = SQL("UPDATE games SET is_private=1 WHERE game_id=?")
const SQL_INSERT_REPLAY = SQL("insert into game_replay (game_id,replay_id,role,action,arguments) values (?, (select coalesce(max(replay_id), 0) + 1 from game_replay where game_id=?) ,?,?,?) returning replay_id").pluck()