From 34a2c7390ea9662d33258d384e72fff1912343ff Mon Sep 17 00:00:00 2001 From: Darkelarious Date: Sat, 13 May 2017 14:18:28 +0200 Subject: revised synchronization methods, config settings and bug fixes --- data/sql/tables-mysql.sql | 12 +++++++++++- 1 file changed, 11 insertions(+), 1 deletion(-) (limited to 'data/sql/tables-mysql.sql') diff --git a/data/sql/tables-mysql.sql b/data/sql/tables-mysql.sql index c460b1b..0bdfc02 100755 --- a/data/sql/tables-mysql.sql +++ b/data/sql/tables-mysql.sql @@ -1,8 +1,18 @@ +CREATE TABLE appletlist( + id INTEGER NOT NULL AUTO_INCREMENT, + ip VARCHAR(15) NOT NULL DEFAULT '0.0.0.0', + port INTEGER NOT NULL DEFAULT 0, + gamename VARCHAR(50) NOT NULL DEFAULT ' ', + added timestamptz NOT NULL DEFAULT NOW(), + updated timestamptz NOT NULL DEFAULT NOW(), + PRIMARY KEY (id) +); + 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 ' ', + gamename VARCHAR(50) NOT NULL DEFAULT ' ', gamever VARCHAR(50) NOT NULL DEFAULT ' ', hostname VARCHAR(100) NOT NULL DEFAULT ' ', hostport INTEGER NOT NULL DEFAULT 0, -- cgit v1.2.3