1 CREATE TABLE xonstat.server_hashkeys
3 server_id integer NOT NULL,
4 hashkey character varying(44) NOT NULL,
5 active_ind boolean NOT NULL DEFAULT true,
6 create_dt timestamp without time zone NOT NULL DEFAULT now(),
7 CONSTRAINT server_hashkeys_pk PRIMARY KEY (server_id, hashkey),
8 CONSTRAINT server_hashkeys_fk001 FOREIGN KEY (server_id)
9 REFERENCES xonstat.servers (server_id) MATCH SIMPLE
10 ON UPDATE NO ACTION ON DELETE NO ACTION
15 ALTER TABLE xonstat.server_hashkeys OWNER TO xonstat;