diff options
| author | Darkelarious <darkelarious@333networks.com> | 2015-11-08 22:29:50 +0100 |
|---|---|---|
| committer | Darkelarious <darkelarious@333networks.com> | 2015-11-08 22:29:50 +0100 |
| commit | dc409b9cb6e92fd9ff9ef18ab2ca825bd247b419 (patch) | |
| tree | 7c4b6cc56d02012a58635abe0be987bbe7f28ec6 /data/database | |
| parent | 8b3d393e7755c167eebe4d9f7fc786074f12e9af (diff) | |
| download | MasterServer-Perl-dc409b9cb6e92fd9ff9ef18ab2ca825bd247b419.tar.gz MasterServer-Perl-dc409b9cb6e92fd9ff9ef18ab2ca825bd247b419.zip | |
Access ciphers and games through database instead of keeping them in memory
Diffstat (limited to 'data/database')
| -rwxr-xr-x | data/database/tables-Pg.sql | 9 | ||||
| -rwxr-xr-x | data/database/tables-SQLite.sql | 9 | ||||
| -rwxr-xr-x | data/database/tables-mysql.sql | 9 |
3 files changed, 27 insertions, 0 deletions
diff --git a/data/database/tables-Pg.sql b/data/database/tables-Pg.sql index abe5744..f5663ff 100755 --- a/data/database/tables-Pg.sql +++ b/data/database/tables-Pg.sql @@ -24,3 +24,12 @@ CREATE TABLE pending( enctype INTEGER NOT NULL DEFAULT 0, added timestamptz NOT NULL DEFAULT NOW() ); + +CREATE TABLE games( + gamename VARCHAR(50) NOT NULL, + cipher VARCHAR(10) NOT NULL DEFAULT ' ', + description VARCHAR(200) NOT NULL DEFAULT ' ', + default_qport INTEGER NOT NULL DEFAULT 0, + num_uplink INTEGER NOT NULL DEFAULT 0, + num_total INTEGER NOT NULL DEFAULT 0 +); diff --git a/data/database/tables-SQLite.sql b/data/database/tables-SQLite.sql index cd904ed..7d68786 100755 --- a/data/database/tables-SQLite.sql +++ b/data/database/tables-SQLite.sql @@ -24,3 +24,12 @@ CREATE TABLE pending( enctype INTEGER NOT NULL DEFAULT 0, added timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP ); + +CREATE TABLE games( + gamename VARCHAR(50) NOT NULL, + cipher VARCHAR(10) NOT NULL DEFAULT ' ', + description VARCHAR(200) NOT NULL DEFAULT ' ', + default_qport INTEGER NOT NULL DEFAULT 0, + num_uplink INTEGER NOT NULL DEFAULT 0, + num_total INTEGER NOT NULL DEFAULT 0 +); diff --git a/data/database/tables-mysql.sql b/data/database/tables-mysql.sql index 9c1d2fc..c460b1b 100755 --- a/data/database/tables-mysql.sql +++ b/data/database/tables-mysql.sql @@ -26,3 +26,12 @@ CREATE TABLE pending( added TIMESTAMP NOT NULL DEFAULT NOW(), PRIMARY KEY (id) ); + +CREATE TABLE games( + gamename VARCHAR(50) NOT NULL, + cipher VARCHAR(10) NOT NULL DEFAULT ' ', + description VARCHAR(200) NOT NULL DEFAULT ' ', + default_qport INTEGER NOT NULL DEFAULT 0, + num_uplink INTEGER NOT NULL DEFAULT 0, + num_total INTEGER NOT NULL DEFAULT 0 +); |