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

1 files changed, 35 insertions, 0 deletions

diff --git a/data/sql/tables-SQLite.sql b/data/sql/tables-SQLite.sql
new file mode 100755
index 0000000..7d68786
--- /dev/null
+++ b/data/sql/tables-SQLite.sql
@@ -0,0 +1,35 @@
+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
+);