1 CREATE TABLE xonstat.servers
3 server_id serial NOT NULL,
4 "name" character varying(64),
5 "location" character varying(100),
6 ip_addr character varying(50),
8 hashkey character varying(44),
9 public_key character varying(725),
10 revision character varying(50),
11 pure_ind boolean NOT NULL DEFAULT true,
12 impure_cvars integer NULL,
13 elo_ind boolean NOT NULL DEFAULT true,
14 categories character varying(10)[],
15 active_ind boolean NOT NULL DEFAULT true,
16 create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'),
17 CONSTRAINT servers_pk PRIMARY KEY (server_id)
22 ALTER TABLE xonstat.servers OWNER TO xonstat;