diff options
| author | Darkelarious <darkelarious@333networks.com> | 2017-09-25 22:41:59 +0200 |
|---|---|---|
| committer | Darkelarious <darkelarious@333networks.com> | 2017-09-25 22:41:59 +0200 |
| commit | 18fc4c931e75d8de804c601b46dc8c8b339db3d9 (patch) | |
| tree | 58a78c8c7841f649fa2e98ddd94456a55951dfa7 /data/sql | |
| parent | c06322da38b4cb76b2036af1a5448083adb8ff20 (diff) | |
| download | MasterServer-Perl-18fc4c931e75d8de804c601b46dc8c8b339db3d9.tar.gz MasterServer-Perl-18fc4c931e75d8de804c601b46dc8c8b339db3d9.zip | |
game statistics for all servers, numerous small fixes
Diffstat (limited to 'data/sql')
| -rwxr-xr-x | data/sql/tables-Pg.sql | 1 | ||||
| -rwxr-xr-x | data/sql/tables-SQLite.sql | 8 |
2 files changed, 4 insertions, 5 deletions
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, |