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(32),
8 revision character varying(50),
9 pure_ind boolean NOT NULL DEFAULT true,
10 active_ind boolean NOT NULL DEFAULT true,
11 create_dt timestamp without time zone NOT NULL DEFAULT now(),
12 CONSTRAINT servers_pk PRIMARY KEY (server_id)
17 ALTER TABLE xonstat.servers OWNER TO xonstat;