FULLTEXT sql syntax

I forward engineered my db and am debugging the script as I import it into my mySql db.

The following line was written by SchemaBank to add a FULLTEXT index:

"ALTER TABLE `seenster_sb`.`Band` ADD INDEX `Band_Name` USING FULLTEXT (`Band_Name`);"

The syntax should be:
"ALTER TABLE `seenster_sb`.`Band` ADD FULLTEXT `Band_Name` (`Band_Name`);"

It seems SchemaBank is using the same syntax for all ADD INDEX queries. I found the correct syntax here: http://dev.mysql.com/doc/refman/5.1/en/alter-table.html



Login or register to post comments

Comments

Thanks for the bug report. We

Thanks for the bug report.
We will look into it.

Done!

The bug is fixed.
Please delete the index in Edit Entity => Indexes tab if you encounter any problem during script/difference report generation.
Thanks for helping us to improve SchemaBank :-)