From: Ant Zucaro <azucaro@gmail.com>
Date: Tue, 9 Jun 2015 21:38:11 +0000 (-0400)
Subject: Add a field to track the absolute number of impure cvar changes.
X-Git-Url: http://de.git.xonotic.org/?p=xonotic%2Fxonstatdb.git;a=commitdiff_plain;h=02751718fbe416a2529c18947748644eefeb1c56;ds=sidebyside

Add a field to track the absolute number of impure cvar changes.
---

diff --git a/tables/servers.tab b/tables/servers.tab
index 936268d..e1aa61f 100644
--- a/tables/servers.tab
+++ b/tables/servers.tab
@@ -9,6 +9,7 @@ CREATE TABLE xonstat.servers
   public_key character varying(725),
   revision character varying(50),
   pure_ind boolean NOT NULL DEFAULT true,
+  impure_cvars integer NULL,
   active_ind boolean NOT NULL DEFAULT true,
   create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'),
   CONSTRAINT servers_pk PRIMARY KEY (server_id)