Make the server hashkey an attribute instead of its own table.

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

diff --git a/tables/servers.tab b/tables/servers.tab
index 56d52ecbe79e16cb6e4ea7cdf233f67d2c74d93d..0bc4bbac54c336e4a32cae3c41c062b8d723d9be 100644 (file)
--- a/tables/servers.tab
+++ b/tables/servers.tab
@@ -1,13 +1,15 @@
 CREATE TABLE xonstat.servers
 (
-  server_id integer NOT NULL,
+  server_id serial NOT NULL,
   "name" character varying(64),
   "location" character varying(100),
   ip_addr character varying(32),
-  max_players integer,
+  hashkey character varying(44),
+  public_key character varying(725),
+  revision character varying(50),
   pure_ind boolean NOT NULL DEFAULT true,
   active_ind boolean NOT NULL DEFAULT true,
-  create_dt timestamp with time zone NOT NULL,
+  create_dt timestamp without time zone NOT NULL DEFAULT now(),
   CONSTRAINT servers_pk PRIMARY KEY (server_id)
 )
 WITH (