Skip to content

Fails to migrate Foreign Constraints  #203

@k3rne1pan1c

Description

@k3rne1pan1c
  • Laravel Version: 10.X.X
  • PHP Version: ^8.1
  • Laravel-5-Generators-Extended Version: 2.0.2
  • Command: sail artisan migrate

What I did

I have the generated users table of Backpack, so there is an ID given. I used the example in the Laravel-5-Generators-Extended README so my expectation is that this should work.

sail artisan make:migration:schema create_users_profile  --schema="user_id:unsignedInteger:foreign, display_name:string, username:string, avatar:string, age:integer, height:integer, origin: string, hair_color: string, location: string, radius:string, orientation: string, availability:string, description: text"

This generated the following:

...
    public function up()
    {
        Schema::create('users_profile', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->unsignedInteger('user_id');
            $table->foreign('user_id')->references('id')->on('users');
          ...
        });
    }
...

What I expected to happen

Migrate should work and tables plus table relationship should be created.

What happened

 SQLSTATE[HY000]: General error: 3780 Referencing column 'user_id' and referenced column 'id' in foreign key constraint 'users_profile_user_id_foreign' are incompatible. (Connection: mysql, SQL: alter table `users_profile` add constraint `users_profile_user_id_foreign` foreign key (`user_id`) references `users` (`id`))

What I've already tried to fix it

??

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions