1 CREATE TABLE xonstat.games
3 game_id bigserial NOT NULL,
4 start_dt timestamp without time zone NOT NULL,
5 game_type_cd character varying(10) NOT NULL,
6 server_id integer NOT NULL,
7 map_id integer NOT NULL,
10 create_dt timestamp without time zone NOT NULL DEFAULT now(),
11 CONSTRAINT games_pk PRIMARY KEY (game_id),
12 CONSTRAINT games_fk001 FOREIGN KEY (game_type_cd)
13 REFERENCES xonstat.cd_game_type (game_type_cd) MATCH SIMPLE
14 ON UPDATE NO ACTION ON DELETE NO ACTION,
15 CONSTRAINT games_fk002 FOREIGN KEY (server_id)
16 REFERENCES xonstat.servers (server_id) MATCH SIMPLE
17 ON UPDATE NO ACTION ON DELETE NO ACTION,
18 CONSTRAINT games_fk003 FOREIGN KEY (map_id)
19 REFERENCES xonstat.maps (map_id) MATCH SIMPLE
20 ON UPDATE NO ACTION ON DELETE NO ACTION
25 ALTER TABLE xonstat.games OWNER TO xonstat;