Merge branch 'frag-matrix'

[xonotic/xonstatdb.git] / tables / servers.tab

diff --git a/tables/servers.tab b/tables/servers.tab
old mode 100644 (file)
new mode 100755 (executable)
index e1aa61f..cf37cd7
--- a/tables/servers.tab
+++ b/tables/servers.tab
@@ -3,13 +3,15 @@ CREATE TABLE xonstat.servers
   server_id serial NOT NULL,
   "name" character varying(64),
   "location" character varying(100),
-  ip_addr character varying(32),
+  ip_addr character varying(50),
   port integer,
   hashkey character varying(44),
   public_key character varying(725),
   revision character varying(50),
   pure_ind boolean NOT NULL DEFAULT true,
   impure_cvars integer NULL,
+  elo_ind boolean NOT NULL DEFAULT true,
+  categories character varying(10)[],
   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)