In Reply To:
Well, if you've really messed up the tables, you might want to back up your data, then go to admin-->setup-->initial setup and re-install the tables, then re-import your data.
You can best drop indexes using MySQLMan, *BUT* you'll need to also edit the .def file, since certain information is stored in them, and is *not* altered during a "resync".
Hi Pugdog,
I did do that because I had messed up my categories when I altered that table. My data is fine now. What I really wanted to know, was if those 3 keys were setup the right way and if there name had to be the same as they were before.
Thank you for your reply : )