Massive improvements on efficiency, robustness, security, reliability and more

3 files changed, 0 insertions, 107 deletions

diff --git a/data/database/tables-Pg.sql b/data/database/tables-Pg.sql
deleted file mode 100755
index f5663ff..0000000
--- a/data/database/tables-Pg.sql
+++ /dev/null
@@ -1,35 +0,0 @@
-CREATE TABLE serverlist(
-  id              SERIAL    UNIQUE NOT NULL PRIMARY KEY,
-  ip              inet             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 FALSE,
-  blacklisted     BOOLEAN          NOT NULL DEFAULT FALSE,
-  added           timestamptz      NOT NULL DEFAULT NOW(),
-  beacon          timestamptz      NOT NULL DEFAULT NOW(),
-  updated         timestamptz      NOT NULL DEFAULT NOW()
-);
-
-CREATE TABLE pending(
-  id              SERIAL    UNIQUE NOT NULL PRIMARY KEY,
-  ip              inet             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           timestamptz      NOT NULL DEFAULT NOW()
-);
-
-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
-);
diff --git a/data/database/tables-SQLite.sql b/data/database/tables-SQLite.sql
deleted file mode 100755
index 7d68786..0000000
--- a/data/database/tables-SQLite.sql
+++ /dev/null
@@ -1,35 +0,0 @@
-CREATE TABLE serverlist(
-  id              INTEGER          PRIMARY KEY AUTOINCREMENT,
-  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           timestamptz      NOT NULL DEFAULT CURRENT_TIMESTAMP,
-  beacon          timestamptz      NOT NULL DEFAULT CURRENT_TIMESTAMP,
-  updated         timestamptz      NOT NULL DEFAULT CURRENT_TIMESTAMP
-);
-
-CREATE TABLE pending(
-  id              INTEGER          PRIMARY KEY AUTOINCREMENT,
-  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           timestamptz      NOT NULL DEFAULT CURRENT_TIMESTAMP
-);
-
-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
-);
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
-);