From 18fc4c931e75d8de804c601b46dc8c8b339db3d9 Mon Sep 17 00:00:00 2001
From: Darkelarious <darkelarious@333networks.com>
Date: Mon, 25 Sep 2017 22:41:59 +0200
Subject: game statistics for all servers, numerous small fixes

---
 data/sql/tables-SQLite.sql | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

(limited to 'data/sql/tables-SQLite.sql')

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

