From 8b3d393e7755c167eebe4d9f7fc786074f12e9af Mon Sep 17 00:00:00 2001 From: Darkelarious Date: Sun, 8 Nov 2015 15:42:27 +0100 Subject: Full support for Postgres, MySQL and SQLite3 + minor bug fixes --- data/database/tables-mysql.sql | 28 ++++++++++++++++++++++++++++ 1 file changed, 28 insertions(+) create mode 100755 data/database/tables-mysql.sql (limited to 'data/database/tables-mysql.sql') diff --git a/data/database/tables-mysql.sql b/data/database/tables-mysql.sql new file mode 100755 index 0000000..9c1d2fc --- /dev/null +++ b/data/database/tables-mysql.sql @@ -0,0 +1,28 @@ +CREATE TABLE serverlist( + id INTEGER NOT NULL AUTO_INCREMENT, + ip VARCHAR(15) NOT NULL DEFAULT '0.0.0.0', + port INTEGER NOT NULL DEFAULT 0, + gamename VARCHAR(100) NOT NULL DEFAULT ' ', + gamever VARCHAR(50) NOT NULL DEFAULT ' ', + hostname VARCHAR(100) NOT NULL DEFAULT ' ', + hostport INTEGER NOT NULL DEFAULT 0, + country VARCHAR(5), + b333ms BOOLEAN NOT NULL DEFAULT 0, + blacklisted BOOLEAN NOT NULL DEFAULT 0, + added TIMESTAMP NOT NULL DEFAULT NOW(), + beacon TIMESTAMP NOT NULL DEFAULT NOW(), + updated TIMESTAMP NOT NULL DEFAULT NOW(), + PRIMARY KEY (id) +); + +CREATE TABLE pending( + id INTEGER NOT NULL AUTO_INCREMENT, + ip VARCHAR(15) NOT NULL DEFAULT '0.0.0.0', + beaconport INTEGER NOT NULL DEFAULT 0, + heartbeat INTEGER NOT NULL DEFAULT 0, + gamename VARCHAR(25) NOT NULL DEFAULT ' ', + secure VARCHAR(12) NOT NULL DEFAULT ' ', + enctype INTEGER NOT NULL DEFAULT 0, + added TIMESTAMP NOT NULL DEFAULT NOW(), + PRIMARY KEY (id) +); -- cgit v1.2.3