Manual:Coding conventions/Database#MySQL/MariaDB says:
Make sure to include the/*_*/
comment immediately before any table name; ..., and omitting it will cause breakage. Similarly, include the/*$wgDBTableOptions*/
comment after any table declaration, and/*i*/
immediately before any index names.
But tables-generated.sql does not have /*i*/
before index names.
The coding convention should probably be updated.