>Even if I set the primary key to both?
yes, order is important with compound keys.
_(I edited my post above to clarify.)_
You _could_ index each column separately (`PRIMARY` on one, `UNIQUE` on the other) if you wanted to, but if you’ll [almost] always be reading _both_, I’d recommend the compound PK.