Database Migration

There is currently a problem with the default value. The key only supports a string value.
You can define a database field as a string. Passing strings as fields

The force method expects an absolute path to the migration file.
Force

I'm not sure if migrations are what you need.
Perhaps it will be easier to use a SQL query template to generate tables.

Many thanks, I'll keep an eye out for the fix as this type of functionality is more than handy.

---

I think you are going to wrong way.

The force() method is testing purpose only.
https://codeigniter4.github.io/userguide...html#force
> This method is recommended only for testing and could cause data consistency issues.

Thanks kenjis, I did note this but could not see another way utilising the Migrations to create a new set of empty table's. I suppose it's back to the tried and tested MySql create method, utilising Migrations for updates, unless you a have suggestions? I'm open to suggestions that use Ci4 functions like Migrations as the more I use Ci4 the more powerful I find it for all types of project development. Thanks again.