diff options
| author | Darkelarious <darkelarious@333networks.com> | 2015-05-19 22:00:40 +0200 |
|---|---|---|
| committer | Darkelarious <darkelarious@333networks.com> | 2015-05-19 22:00:40 +0200 |
| commit | 2c7d62f38944f61e7eafea155c6128521d16aed9 (patch) | |
| tree | bd473e6fb9dbbf8e0fdc67b87f0a4ac251fada7b /data/database | |
| parent | 534626943a0a5e251e5465376f3de3fb71b25e91 (diff) | |
| download | MasterServer-Perl-2c7d62f38944f61e7eafea155c6128521d16aed9.tar.gz MasterServer-Perl-2c7d62f38944f61e7eafea155c6128521d16aed9.zip | |
Beta with support for Pg and SQLite
Diffstat (limited to 'data/database')
| -rwxr-xr-x | data/database/tables-SQLite.sql | 5 |
1 files changed, 3 insertions, 2 deletions
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( |