Migration: Cannot add foreign key constraint

by

Add it in two steps, and it’s good to make it unsigned too:

public function up()
{
    Schema::create('priorities', function($table) {
        $table->increments('id', true);
        $table->integer('user_id')->unsigned();
        $table->string('priority_name');
        $table->smallInteger('rank');
        $table->text('class');
        $table->timestamps('timecreated');
    });

   Schema::table('priorities', function($table) {
       $table->foreign('user_id')->references('id')->on('users');
   });

}

More Related Contents:

  1. Laravel Eloquent groupBy() AND also return count of each group
  2. Eloquent Collection: Counting and Detect Empty
  3. Eloquent eager load Order by
  4. Laravel. Use scope() in models with relation
  5. Laravel Eloquent “WHERE NOT IN”
  6. How to access model hasMany Relation with where condition?
  7. Eloquent push() and save() difference
  8. Laravel save / update many to many relationship
  9. First Or Create
  10. Laravel: Returning the namespaced owner of a polymorphic relation
  11. Polymorphic Eloquent relationships with namespaces
  12. Clone an Eloquent object including all relationships?
  13. laravel migration best way to add foreign key
  14. Laravel Check If Related Model Exists
  15. How to install Laravel 4 to a web host subfolder without publicly exposing /app/ folder?
  16. How to Get the Current URL Inside @if Statement (Blade) in Laravel 4?
  17. laravel with() method versus load() method
  18. Laravel Eloquent: How to order results of related models?
  19. Laravel – Forbidden You don’t have permission to access / on this server
  20. How to set a default attribute value for a Laravel / Eloquent model?
  21. How to use paginate() with a having() clause when column does not exist in table
  22. Select Last Row in the Table
  23. What is the difference between queue:work –daemon and queue:listen
  24. How to create a subquery using Laravel Eloquent?
  25. Eloquent model mass update
  26. Find or Create with Eloquent
  27. Laravel: Change base URL?
  28. How to setup conditional relationship on Eloquent
  29. Laravel Eloquent – Where In All
  30. Laravel 4 : Route to localhost/controller/action

Leave a Comment