From 2c7d62f38944f61e7eafea155c6128521d16aed9 Mon Sep 17 00:00:00 2001 From: Darkelarious Date: Tue, 19 May 2015 22:00:40 +0200 Subject: Beta with support for Pg and SQLite --- data/database/tables-SQLite.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'data/database/tables-SQLite.sql') diff --git a/data/database/tables-SQLite.sql b/data/database/tables-SQLite.sql index 8ed9471..37431bb 100755 --- a/data/database/tables-SQLite.sql +++ b/data/database/tables-SQLite.sql @@ -26,7 +26,7 @@ CREATE TABLE pending( ); CREATE TABLE server_info( - FOREIGN KEY(server_id) REFERENCES serverlist(id), + server_id INTEGER, minnetver INTEGER NOT NULL DEFAULT 400, gamever INTEGER NOT NULL DEFAULT 400, location INTEGER NOT NULL DEFAULT 0, @@ -52,7 +52,8 @@ CREATE TABLE server_info( timelimit INTEGER NOT NULL DEFAULT 0, goalteamscore INTEGER NOT NULL DEFAULT 0, fraglimit INTEGER NOT NULL DEFAULT 0, - mutators TEXT NOT NULL DEFAULT 'None' + mutators TEXT NOT NULL DEFAULT 'None', + FOREIGN KEY(server_id) REFERENCES serverlist(id) ); CREATE TABLE player_info( -- cgit v1.2.3