From c3f8d65a4fb1f5674557ee67cf7f74369df86ad1 Mon Sep 17 00:00:00 2001
From: Darkelarious <darkelarious@333networks.com>
Date: Sat, 19 Nov 2016 20:56:04 +0100
Subject: Massive improvements on efficiency, robustness, security, reliability
 and more

---
 data/database/tables-mysql.sql | 37 -------------------------------------
 1 file changed, 37 deletions(-)
 delete 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
deleted file mode 100755
index c460b1b..0000000
--- a/data/database/tables-mysql.sql
+++ /dev/null
@@ -1,37 +0,0 @@
-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)
-);
-
-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

