From 534626943a0a5e251e5465376f3de3fb71b25e91 Mon Sep 17 00:00:00 2001
From: Darkelarious <darkelarious@333networks.com>
Date: Wed, 11 Feb 2015 21:12:44 +0100
Subject: ability to query UCC applets (Pg only)

---
 data/database/tables-Pg.sql | 7 +++++++
 1 file changed, 7 insertions(+)

(limited to 'data/database/tables-Pg.sql')

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',
-- 
cgit v1.2.3

