Added index support for MySQL

- Added index support for MySQL
- Removed wasteful indexing from the 'value' column
if we never are indexing value, we can take it out of the conditional