This is (i think) my latest version of the database - i'll update it if not

http://forums.gameplay.com/my_forums_database_def.html

Have a look at it and see how it compares to you
( do mysqldump -d <insert name of forum db here)

This will dump you out a similar listing ...

Where i've got a key that you havn't you need to do something like
mysql> alter table <table> add index <column name> (<column name>)

If you have ones that I don't post 'em here however if they are the
two in one things then you need to remove them as MySQL can't
use them all the time ...

mysql> alter table <table> drop index <index name>

Fodder