X-Git-Url: https://git.xonotic.org/?a=blobdiff_plain;f=tables%2Fservers.tab;h=cf37cd73e02a872528d86ae930a56c2124abdab6;hb=a49b111e04da2f30dc9c5713b3724b3530c4893c;hp=761d9445669bf7d884769a508c765693f98fa742;hpb=6010ce2004e1ba1be9eed6e99c9d05779b7fbb9a;p=xonotic%2Fxonstatdb.git

diff --git a/tables/servers.tab b/tables/servers.tab
index 761d944..cf37cd7 100755
--- a/tables/servers.tab
+++ b/tables/servers.tab
@@ -3,7 +3,7 @@ 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),
@@ -11,6 +11,7 @@ CREATE TABLE xonstat.servers
   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)