CREATE TABLE player_ranks_history
(
  player_id integer NOT NULL,
  nick character varying(128),
  game_type_cd character varying(10) NOT NULL,
  category character varying(10) NOT NULL default 'general',
  elo numeric NOT NULL,
  rank integer NOT NULL,
  create_dt timestamp without time zone
)
WITH (
  OIDS=FALSE
);
ALTER TABLE player_ranks OWNER TO xonstat;