Full support for Postgres, MySQL and SQLite3 + minor bug fixes

1 files changed, 0 insertions, 46 deletions

diff --git a/data/database/tables-SQLite.sql b/data/database/tables-SQLite.sql
index 37431bb..cd904ed 100755
--- a/data/database/tables-SQLite.sql
+++ b/data/database/tables-SQLite.sql
@@ -24,49 +24,3 @@ CREATE TABLE pending(
   enctype         INTEGER          NOT NULL DEFAULT 0,
   added           timestamptz      NOT NULL DEFAULT CURRENT_TIMESTAMP
 );
-
-CREATE TABLE server_info(
-  server_id           INTEGER,
-  minnetver           INTEGER      NOT NULL DEFAULT 400,
-  gamever             INTEGER      NOT NULL DEFAULT 400,
-  location            INTEGER      NOT NULL DEFAULT 0,
-  listenserver        BOOLEAN      NOT NULL DEFAULT 1,
-  hostport            INTEGER      NOT NULL DEFAULT 7777,
-  hostname            varchar(200) NOT NULL DEFAULT '',
-  adminname           varchar(200) NOT NULL DEFAULT '',
-  adminemail          varchar(300) NOT NULL DEFAULT '',
-  password            BOOLEAN      NOT NULL DEFAULT 0,
-  gametype            varchar(50)  NOT NULL DEFAULT '',
-  gamestyle           varchar(50)  NOT NULL DEFAULT 'Normal',
-  changelevels        BOOLEAN      NOT NULL DEFAULT 0,
-  maptitle            varchar(100) NOT NULL DEFAULT 'Unknown',
-  mapname             varchar(100) NOT NULL DEFAULT '',
-  numplayers          INTEGER      NOT NULL DEFAULT 0,
-  maxplayers          INTEGER      NOT NULL DEFAULT 0,
-  minplayers          INTEGER      NOT NULL DEFAULT 0,
-  botskill            varchar(30)  NOT NULL DEFAULT 'Novice',
-  balanceteams        BOOLEAN      NOT NULL DEFAULT 0,
-  playersbalanceteams BOOLEAN      NOT NULL DEFAULT 0,
-  friendlyfire        varchar(10)  NOT NULL DEFAULT '0%',
-  maxteams            INTEGER      NOT NULL DEFAULT 4,
-  timelimit           INTEGER      NOT NULL DEFAULT 0,
-  goalteamscore       INTEGER      NOT NULL DEFAULT 0,
-  fraglimit           INTEGER      NOT NULL DEFAULT 0,
-  mutators            TEXT         NOT NULL DEFAULT 'None',
-  FOREIGN KEY(server_id) REFERENCES serverlist(id)
-);
-
-CREATE TABLE player_info(
-  server_id INTEGER       PRIMARY KEY AUTOINCREMENT,
-  player    varchar(40)   NOT NULL DEFAULT 'Player',
-  team      INTEGER       NOT NULL DEFAULT 255,
-  frags     INTEGER       NOT NULL DEFAULT 0,
-  mesh      varchar(100)  NOT NULL DEFAULT '',
-  skin      varchar(100)  NOT NULL DEFAULT '',
-  face      varchar(100)  NOT NULL DEFAULT '',
-  ping      INTEGER       NOT NULL DEFAULT 0,
-  ngsecret  varchar(10)   NOT NULL DEFAULT 'false',
-  updated   timestamptz   NOT NULL DEFAULT CURRENT_TIMESTAMP
-);
-
-