1 CREATE TABLE xonstat.game_mutators
3 game_id bigint NOT NULL,
4 mutator_cd integer NOT NULL,
5 CONSTRAINT game_mutators_pk PRIMARY KEY (game_id, mutator_cd),
6 CONSTRAINT game_mutators_fk001 FOREIGN KEY (game_id)
7 REFERENCES xonstat.games (game_id) MATCH SIMPLE
8 ON UPDATE NO ACTION ON DELETE NO ACTION,
9 CONSTRAINT game_mutators_fk002 FOREIGN KEY (mutator_cd)
10 REFERENCES xonstat.cd_mutator (mutator_cd) MATCH SIMPLE
11 ON UPDATE NO ACTION ON DELETE NO ACTION
16 ALTER TABLE xonstat.game_mutators OWNER TO xonstat;