How do I remove the primary key label on the foreign keys, so I can
add a single autoincrement primary key column?

alter table score drop primary key;
ERROR 1025 (HY000): Error on rename of './sampdb/#sql-185_9' to './
sampdb/score' (errno: 150)

I think it is because the table has two primary keys for some reason.