From c06322da38b4cb76b2036af1a5448083adb8ff20 Mon Sep 17 00:00:00 2001
From: Darkelarious <darkelarious@333networks.com>
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

