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

);

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

  time timestamp with time zone
);

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