From 74410866ad685845f8789d915eb26ed067027fba Mon Sep 17 00:00:00 2001 From: Ant Zucaro Date: Sun, 30 Oct 2011 20:44:34 -0400 Subject: [PATCH] Make the server hashkey an attribute instead of its own table. --- build/build_full.sql | 2 -- tables/servers.tab | 2 +- 2 files changed, 1 insertion(+), 3 deletions(-) diff --git a/build/build_full.sql b/build/build_full.sql index 9a0fabb..d77d323 100755 --- a/build/build_full.sql +++ b/build/build_full.sql @@ -1,5 +1,4 @@ -- drop tables first in reverse order -drop table if exists server_hashkeys cascade; drop table if exists player_nicks cascade; drop table if exists db_version cascade; drop table if exists hashkeys cascade; @@ -34,7 +33,6 @@ drop table if exists players cascade; \i tables/hashkeys.tab \i tables/db_version.tab \i tables/player_nicks.tab -\i tables/server_hashkeys.tab begin; diff --git a/tables/servers.tab b/tables/servers.tab index 46e2279..0bc4bba 100644 --- a/tables/servers.tab +++ b/tables/servers.tab @@ -4,7 +4,7 @@ CREATE TABLE xonstat.servers "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, -- 2.39.2