I am encountering "errno: 150 'Foreign key constraint is incorrectly formed'" when migrating.
I have a table that needs 3 foreign keys:
Schema::create('ads', function (Blueprint $table) { $table->increments('id'); $table->string('prodname'); $table->string('mfrname'); $table->decimal('priceam'); $table->string('imagenametxt',500); $table->string('specstxt',500); $table->string('otherinfotxt',500); $table->decimal('avalableqty'); $table->binary('validyn'); $table->binary('checkyn'); $table->binary('updatedyn'); $table->integer('selleridno')->unsigned(); $table->integer('catidno')->unsigned(); $table->integer('subcatidno')->unsigned(); $table->timestamps(); }); Schema::table('ads', function(Blueprint $table){ $table->foreign('selleridno')->references('id')->on('users'); $table->foreign('catidno')->references('id')->on('categories'); $table->foreign('subcatidno')->references('id')-> on('subcategories'); });
Users, Categories and Subcategories table are created before this table. selleridno and catidno was successfully created but in creating foreign key for subcatidno I am encountering the error. any suggestions/opinions? thank you in advance.
My Database is MySql.
Just in case you need the SubCategories table here it is:
Schema::create('sub_categories', function (Blueprint $table) {
$table->increments('id');
$table->string('subcategorycd');
$table->string('subcategorytxt');
$table->integer('categoryidno')->unsigned();
$table->timestamps();
$table->foreign('categoryidno')->references('id')->on('categories');
});
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire