aboutsummaryrefslogtreecommitdiff
path: root/data/database/tables-SQLite.sql
diff options
context:
space:
mode:
Diffstat (limited to 'data/database/tables-SQLite.sql')
-rwxr-xr-xdata/database/tables-SQLite.sql46
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
-);
-
-