server_id serial NOT NULL,
"name" character varying(64),
"location" character varying(100),
- ip_addr character varying(32),
- max_players integer,
+ 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 now(),
+ create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'),
CONSTRAINT servers_pk PRIMARY KEY (server_id)
)
WITH (