The internet says I have to create a new table with the primary key I want, then copy the data from the old table over. It's too late at night for this old boong to embark on such a perilous intellectual journey.