From 993380a93f8b6612a9ccdda92eec69029f69c4b1 Mon Sep 17 00:00:00 2001 From: Ant Zucaro Date: Sat, 21 Jan 2012 23:07:24 -0500 Subject: [PATCH] Fix player_ranks. --- tables/player_ranks.tab | 10 ++++++---- 1 file changed, 6 insertions(+), 4 deletions(-) diff --git a/tables/player_ranks.tab b/tables/player_ranks.tab index 6bcd2df..254b53a 100644 --- a/tables/player_ranks.tab +++ b/tables/player_ranks.tab @@ -1,18 +1,20 @@ -CREATE TABLE xonstat.player_ranks +CREATE TABLE player_ranks ( player_id integer NOT NULL, + nick character varying(128), game_type_cd character varying(10) NOT NULL, elo numeric NOT NULL, + rank integer NOT NULL, create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'), CONSTRAINT player_ranks_pk PRIMARY KEY (player_id, game_type_cd), CONSTRAINT player_ranks_fk01 FOREIGN KEY (player_id) - REFERENCES xonstat.players (player_id) MATCH SIMPLE + REFERENCES players (player_id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT player_ranks_fk02 FOREIGN KEY (game_type_cd) - REFERENCES xonstat.cd_game_type (game_type_cd) MATCH SIMPLE + REFERENCES cd_game_type (game_type_cd) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION ) WITH ( OIDS=FALSE ); -ALTER TABLE xonstat.player_ranks OWNER TO xonstat; +ALTER TABLE player_ranks OWNER TO xonstat; -- 2.39.2