Request: enable "indexType" on MySQL dialect.

[musou1500]

I want to create spatial index to specific column by using this feature.
I know knex.raw make it possible to do.

[douglasjunior]

This is very important, how can I create an index of type FULLTEXT?

[elhigu]

@douglasjunior with knex.schema.raw() at least. I cannot remember if passing index type was already fixed.

[kibertoad]

@douglasjunior According to documentation, it is supported, see https://knexjs.org/#Schema-index
If you try and it doesn't work, please consider raising a PR with failing test for it, then we could address it rapidly.

[douglasjunior]

@kibertoad not work with MySQL.

I'm writing a PR right now. 😆

[douglasjunior]

Done #2890.

[glensc]

@knex: perhaps close, as indexType was added with #2890.

[glensc]

  await knex.schema.alterTable('article_attribute', (table) => {
    table.index('value_text', 'article_attribute_value_text', 'FULLTEXT');
  });