id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
26990	Support MySQL FULLTEXT INDEX in the model DDL	Ed Morley	nobody	"Whilst there is ticket #3254 filed for general full text search support, it's regarding multiple DB types and primarily about adding support for searching, rather than creating indexes. As such, I think it's easier to break this piece out to a new ticket.

In MySQL 5.6 support was added to InnoDB for full text indexes:
https://dev.mysql.com/doc/refman/5.6/en/innodb-fulltext-index.html

Currently we have to create these via a migration like:

{{{
migrations.RunSQL(
    sql='CREATE FULLTEXT INDEX `idx_description` on foo(`description`);',
    reverse_sql='ALTER TABLE foo DROP INDEX idx_description',
),
}}}

It would be ideal to be able to define them via the model DDL instead, so the full DB state can be recreated from the model."	New feature	closed	Database layer (models, ORM)	dev	Normal	wontfix	mysql, fulltext, index		Unreviewed	0	0	0	0	0	0