1 CREATE TABLE xonstat.player_groups
3 player_id integer NOT NULL,
4 group_name character varying(30) NOT NULL,
5 create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'),
6 CONSTRAINT player_groups_pk PRIMARY KEY (player_id, group_name),
7 CONSTRAINT player_groups_fk001 FOREIGN KEY (player_id)
8 REFERENCES xonstat.players (player_id) MATCH SIMPLE
9 ON UPDATE NO ACTION ON DELETE NO ACTION
14 ALTER TABLE xonstat.player_groups OWNER TO xonstat;