X-Git-Url: https://git.xonotic.org/?a=blobdiff_plain;f=tables%2Fservers.tab;h=e1aa61f80a4aa21e8eff448c383678afd62ff6c5;hb=02751718fbe416a2529c18947748644eefeb1c56;hp=a18829424fc1e9ebd19fe0f7800aaf1ed90935b4;hpb=51372af5a78f0514b6f0448f520e4644ddb85098;p=xonotic%2Fxonstatdb.git

diff --git a/tables/servers.tab b/tables/servers.tab
index a188294..e1aa61f 100644
--- a/tables/servers.tab
+++ b/tables/servers.tab
@@ -4,11 +4,14 @@ CREATE TABLE xonstat.servers
   "name" character varying(64),
   "location" character varying(100),
   ip_addr character varying(32),
-  max_players integer,
+  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,
   active_ind boolean NOT NULL DEFAULT true,
-  create_dt timestamp without time zone NOT NULL DEFAULT now(),
+  create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'),
   CONSTRAINT servers_pk PRIMARY KEY (server_id)
 )
 WITH (