Laravel 4 Migration - Cannot add foreign key constraint

Question

Here's my migration code:

public function up()
{
    Schema::create('foos', function(Blueprint $table) {
        // Primary key
        $table->increments('id');

        // Standard
        $table->engine = 'InnoDB';
        $table->timestamps();
        $table->softDeletes();
    });

    Schema::create('bars', function(Blueprint $table) {
        // Primary key
        $table->increments('id');

        // Define foreign key
        $table->integer('foo_id')->unsigned;

        // Foreign key contraints
        // NOTE: causes "General error: 1215 Cannot add foreign key constraint"
        // $table->foreign('foo_id')->references('id')->on('foos');

        // Standard
        $table->engine = 'InnoDB';
        $table->timestamps();
        $table->softDeletes();
    });
}

public function down()
{
    Schema::drop('foos');
    Schema::drop('bars');
}

When the code to define the foreign key constraint is not commented out, I get the following error on the command line: General error: 1215 Cannot add foreign key constraint.

Any ideas what I am doing wrong?

d.danailov · Accepted Answer · 2014-05-07 11:14:14Z

15

$table->integer('foo_id')->unsigned;

should be

$table->integer('foo_id')->unsigned();

or you can use short version:

$table->unsignedInteger('foo_id');

edited May 7, 2014 at 11:14

d.danailov

9,8704 gold badges53 silver badges36 bronze badges

answered Sep 25, 2013 at 2:54

ceejayoz

181k42 gold badges311 silver badges382 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

StackOverflowNewbie Over a year ago

In the famous words of Homer, "Doh!". Thanks!

ceejayoz Over a year ago

Don't beat yourself up - I can only answer your question because I did the exact same thing. :-)

Collectives™ on Stack Overflow

Laravel 4 Migration - Cannot add foreign key constraint

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related