Getting rid of unused indexes.
Source: http://dev.mysql.com/doc/refman/5.5/en/multiple-column-indexes.html
If the table has a multiple-column index, any leftmost prefix of the index can be used by the optimizer to find rows. For example, if you have a three-column index on (col1, col2, col3), you have indexed search capabilities on (col1), (col1, col2), and (col1, col2, col3).
Allow unsigned int values for guild exp (as it was before the change).