CREATE TABLE xonstat.player_nicks ( player_id integer NOT NULL, stripped_nick character varying(128) NOT NULL, nick character varying(128) NOT NULL, create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'), CONSTRAINT player_nicks_pk PRIMARY KEY (player_id, stripped_nick), CONSTRAINT player_nicks_fk01 FOREIGN KEY (player_id) REFERENCES xonstat.players (player_id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION ) WITH ( OIDS=FALSE ); ALTER TABLE xonstat.player_nicks OWNER TO xonstat;