CREATE TABLE xonstat.servers
(
  server_id serial NOT NULL,
  "name" character varying(64),
  "location" character varying(100),
  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)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE xonstat.servers OWNER TO xonstat;