php - Cannot add foreign key constraint laravel -
i have migration:
for article
public function up() { schema::create('articles', function (blueprint $table) { $table->engine = 'innodb'; $table->increments('id'); $table->integer('user_id')->unsigned(); $table->integer('category_id')->unsigned(); $table->string('title'); $table->string('slug')->unique(); $table->text('body'); $table->timestamps(); $table->foreign('user_id') ->references('id') ->on('users') ->ondelete('cascade'); $table->foreign('category_id') ->references('id') ->on('categories') ->ondelete('cascade'); }); }
for category
public function up() { schema::create('categories', function (blueprint $table) { $table->increments('id'); $table->string('name'); $table->timestamps(); }); }
when try run command php artisan migrate
error:
general error: 1215 cannot add foreign key constraint (sql: alter table`articles` add constraint articles_category_id_foreign foreign key (`category_id`) references `categories` (`id`) on delete cascade)
several times checked can not find problem.
Comments
Post a Comment