1 CREATE TABLE xonstat.player_nicks
3 player_id integer NOT NULL,
4 stripped_nick character varying(128) NOT NULL,
5 nick character varying(128) NOT NULL,
6 create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'),
7 CONSTRAINT player_nicks_pk PRIMARY KEY (player_id, stripped_nick),
8 CONSTRAINT player_nicks_fk01 FOREIGN KEY (player_id)
9 REFERENCES xonstat.players (player_id) MATCH SIMPLE
10 ON UPDATE NO ACTION ON DELETE NO ACTION
15 ALTER TABLE xonstat.player_nicks OWNER TO xonstat;