Add an add_index override for custom index types.

Adds an add_index override to the Postgresql and MySQL adapters for
supporting custom index types.