From 8b3d393e7755c167eebe4d9f7fc786074f12e9af Mon Sep 17 00:00:00 2001 From: Darkelarious Date: Sun, 8 Nov 2015 15:42:27 +0100 Subject: Full support for Postgres, MySQL and SQLite3 + minor bug fixes --- data/database/tables-SQLite.sql | 46 ----------------------------------------- 1 file changed, 46 deletions(-) (limited to 'data/database/tables-SQLite.sql') 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 -); - - -- cgit v1.2.3