From 18fc4c931e75d8de804c601b46dc8c8b339db3d9 Mon Sep 17 00:00:00 2001 From: Darkelarious Date: Mon, 25 Sep 2017 22:41:59 +0200 Subject: game statistics for all servers, numerous small fixes --- data/sql/tables-Pg.sql | 1 - data/sql/tables-SQLite.sql | 8 ++++---- 2 files changed, 4 insertions(+), 5 deletions(-) (limited to 'data/sql') diff --git a/data/sql/tables-Pg.sql b/data/sql/tables-Pg.sql index ab68d61..96f8f91 100755 --- a/data/sql/tables-Pg.sql +++ b/data/sql/tables-Pg.sql @@ -101,4 +101,3 @@ CREATE TABLE kfstats( GamesWon INTEGER NOT NULL DEFAULT 0, GamesLost INTEGER NOT NULL DEFAULT 0 ); - diff --git a/data/sql/tables-SQLite.sql b/data/sql/tables-SQLite.sql index 80df6b4..5608a66 100755 --- a/data/sql/tables-SQLite.sql +++ b/data/sql/tables-SQLite.sql @@ -16,8 +16,8 @@ CREATE TABLE serverlist( hostname TEXT, hostport INTEGER DEFAULT 0, country TEXT, - b333ms BOOLEAN DEFAULT FALSE, - blacklisted BOOLEAN DEFAULT FALSE, + b333ms INTEGER DEFAULT 0, + blacklisted INTEGER DEFAULT 0, added timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP, beacon timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP, updated timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP @@ -43,7 +43,7 @@ CREATE TABLE pending( added timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP ); -CREATE TABLE utserver_info( +CREATE TABLE extended_info( server_id INTEGER PRIMARY KEY AUTOINCREMENT, minnetver TEXT, location TEXT, @@ -72,7 +72,7 @@ CREATE TABLE utserver_info( FOREIGN KEY(server_id) REFERENCES serverlist(id) ); -CREATE TABLE utplayer_info( +CREATE TABLE player_info( server_id INTEGER NOT NULL, player TEXT DEFAULT 'Player', team TEXT, -- cgit v1.2.3