diff options
Diffstat (limited to 'data/database/tables-SQLite.sql')
| -rwxr-xr-x | data/database/tables-SQLite.sql | 46 |
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 -); - - |
