Library to help migrations to figure out whether a related field is int or bigInt

1.5.0 2022-03-10 21:36 UTC

This package is auto-updated.

Last update: 2022-05-10 22:51:34 UTC


Tests Packagist Stable Version Packagist downloads StyleCI MIT Software License

Laravel 5.8 And The BigInt Problem

As of Laravel 5.8, migration stubs use the bigIncrements method on ID columns by default. Previously, ID columns were created using the increments method.

Foreign key columns must be of the same type. Therefore, a column created using the increments method can not reference a column created using the bigIncrements method.

This small change is a big source of problems for packages that define references to the default Laravel user table.

This package helps solving this problem by extending Laravel's Blueprint class by a method that can detect the actual referenced field type:

class CreateProfilesTable extends Migration
    public function up()
        Schema::create('profiles', function (Blueprint $table) {

            // Make `user_id` field the same type as the `id` field of the `user` table:
            $table->intOrBigIntBasedOnRelated('user_id', Schema::connection(null), 'users.id');




composer require konekt/laravel-migration-compatibility


For detailed usage and examples go to the Documentation or refer to the markdown files in the docs/ folder of this repo.

For the list of changes read the Changelog.