Dev/build won't create InnoDB tables

General
1

I am using SS 4.5 and MySQL 5.7
When I run /dev/build i get a notice saying:
Table Page options not changed to ENGINE=InnoDB due to fulltextsearch index
and I end up with a MyISAM table

As far as I’m aware, MySQL 5.6+ can have FULLTEXT indexes on InnoDB tables, so I’m not sure why SS would do this

2

I had same problem and added this to the theme.yml seemed to work for me

SilverStripe\Assets\File:
create_table_options:
MySQLDatabase: ‘ENGINE=MyISAM’

obviously has indents

3

Thanks for the suggestion, but unfortunately that’s the opposite of what I need. I want all my tables to be InnoDB but SS insists on them being MyISAM due to the FULLTEXT indexes, which is not required since PHP5.6.