Separate indexes from constraints creation by extract logic from db_migrate_constraints.
Indexes must be created after functions, since they can be based on them.
Constraints must be created after indexes to speed up data validation, especially in the case of foreign key constraints.
The db_migrate function has been modified to reflect these rules.
No regression detected with mssql_migrator or mysql_migrator plugins with this new function.
laurenz
commented
1 year ago
Separate indexes from constraints creation by extract logic from db_migrate_constraints.
The
db_migratefunction has been modified to reflect these rules. No regression detected withmssql_migratorormysql_migratorplugins with this new function.Related to #24