Database Migration confusion

You would need to disable foreign keys before the migration, then enable them after. Unfortunately, that's a hole in our current db layer (though I should be creating some methods for that in the next couple of weeks).

For mysql, you can use:

Code:

$db->query("SET FOREIGN_KEY_CHECKS=0;");

// do your migrations

$db->query("SET FOREIGN_KEY_CHECKS=1;");

Support Development •  CodeIgniter 4 Foundations • Practical CodeIgniter 3  • CodeIgniter Tutorials