From c06322da38b4cb76b2036af1a5448083adb8ff20 Mon Sep 17 00:00:00 2001 From: Darkelarious Date: Tue, 22 Aug 2017 11:00:13 +0200 Subject: new server checking mechanism, complete recode of major functions --- data/sql/tables-mysql.sql | 47 ----------------------------------------------- 1 file changed, 47 deletions(-) delete mode 100755 data/sql/tables-mysql.sql (limited to 'data/sql/tables-mysql.sql') diff --git a/data/sql/tables-mysql.sql b/data/sql/tables-mysql.sql deleted file mode 100755 index 0bdfc02..0000000 --- a/data/sql/tables-mysql.sql +++ /dev/null @@ -1,47 +0,0 @@ -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(50) 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) -); - -CREATE TABLE games( - gamename VARCHAR(50) NOT NULL, - cipher VARCHAR(10) NOT NULL DEFAULT ' ', - description VARCHAR(200) NOT NULL DEFAULT ' ', - default_qport INTEGER NOT NULL DEFAULT 0, - num_uplink INTEGER NOT NULL DEFAULT 0, - num_total INTEGER NOT NULL DEFAULT 0 -); -- cgit v1.2.3