Add support for FULLTEXT and SPATIAL indexes using the :type flag for MySQL.