DB Indexes

What indexes should be create in MySQL when installing Spark?

Recently I moved from Windows to Linux, I ran the normal setup for Openfire but then afterwards I noticed lag when doing DB look ups. I found there has been no indexes made at all in my install. I used the .sql file in the openfire directory to make a few by hand but does someone have a complete list of what indexes should be made for both the Openfire app and plugins.

The required indexes should be in the .sql file and created during setup.

Perfect those are the ones I made by hand. Setup never created them.