diff options
| author | Darkelarious <darkelarious@333networks.com> | 2015-02-11 21:12:44 +0100 |
|---|---|---|
| committer | Darkelarious <darkelarious@333networks.com> | 2015-02-11 21:12:44 +0100 |
| commit | 534626943a0a5e251e5465376f3de3fb71b25e91 (patch) | |
| tree | b5b4550c1cdb69c6933aa571244881eaacc72ffe /data/database | |
| parent | e0ada80f8582cf3b28e70b8f18de10aa505159ae (diff) | |
| download | MasterServer-Perl-534626943a0a5e251e5465376f3de3fb71b25e91.tar.gz MasterServer-Perl-534626943a0a5e251e5465376f3de3fb71b25e91.zip | |
ability to query UCC applets (Pg only)
Diffstat (limited to 'data/database')
| -rwxr-xr-x | data/database/tables-Pg.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/data/database/tables-Pg.sql b/data/database/tables-Pg.sql index 1502c05..0778797 100755 --- a/data/database/tables-Pg.sql +++ b/data/database/tables-Pg.sql @@ -14,6 +14,13 @@ CREATE TABLE serverlist( updated timestamptz NOT NULL DEFAULT NOW() ); +-- TODO +CREATE TABLE user_stats( + gamename VARCHAR(50) NOT NULL DEFAULT ' ', + requests INTEGER NOT NULL DEFAULT 1, + beacons INTEGER NOT NULL DEFAULT 1 +); + CREATE TABLE pending( id SERIAL UNIQUE NOT NULL PRIMARY KEY, ip inet NOT NULL DEFAULT '0.0.0.0', |