aboutsummaryrefslogtreecommitdiff
path: root/data/database/tables-Pg.sql
diff options
context:
space:
mode:
Diffstat (limited to 'data/database/tables-Pg.sql')
-rwxr-xr-xdata/database/tables-Pg.sql7
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',