rocknbil - 5:44 pm on Jan 27, 2011 (gmt 0)
The date won't work?
Can you try this? It won't break anything and you can drop it if you want. As always, do a backup first.
alter table yourtable add my_id int(11) primary key auto_increment first;
What *should* happen is it will place a new column at the far left of the field list (left, by usage of "first") and add the id's in the order they were entered, giving you that field to order by. If it errors it means you already have a primary key, even if it's not an auto_increment.
If that doesn't work,
alter table yourtable drop my_id;
will drop the column.