diff options
Diffstat (limited to 'data/database/tables-Pg.sql')
| -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', |
