From 32aaaf92f2c06214abdc93e3cede07e067df6b88 Mon Sep 17 00:00:00 2001 From: lonkaars Date: Mon, 22 Feb 2021 12:48:38 +0100 Subject: added columns to games + cleanup function --- database/init_db.sql | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'database') diff --git a/database/init_db.sql b/database/init_db.sql index 5b9e0a7..2ce8a1e 100644 --- a/database/init_db.sql +++ b/database/init_db.sql @@ -23,13 +23,16 @@ create table if not exists games ( player_1_id text not null, player_2_id text, outcome text, - timestamp integer, + created integer, + started integer, + last_activity integer, duration integer, rating_delta_player_1 integer, rating_delta_player_2 integer, status text not null, ruleset text not null, private boolean not null, + debug boolean not null, foreign key(player_1_id) references users(user_id), foreign key(player_2_id) references users(user_id) ); -- cgit v1.2.3