 );
 
 CREATE TABLE player_matches (
-  PRIMARY KEY(account_id, match_id),
+  PRIMARY KEY(match_id, player_slot),
       match_id integer,
       account_id integer,
       player_slot integer,

  time timestamp with time zone
);

CREATE INDEX on matches(version);
CREATE INDEX on players(full_history_time);
CREATE INDEX on players(cheese);
);

CREATE TABLE player_ratings (
  PRIMARY KEY(match_id, account_id),
  match_id integer,
  account_id integer,
  soloCompetitiveRank integer,
