|
Laravel,
PHP,
框架,
laravel 建数据库 迁移 的错误
General error: 1215 Cannot add foreign key constraint (SQL: alter table iphpt_categories add constraint iphpt_categories_art_id_foreign foreign key (art_id) references article (id) on delete cascade on update cascade)
Schema::create('iphpt_categories', function (Blueprint $table) {
$table->engine = 'InnoDB';
$table->integer('art_id')->unsigned();
$table->integer('cate_id')->unsigned();
$table->foreign('art_id')->references('id')->on('iphpt_article');
$table->foreign('cate_id')->references('id')->on('iphpt_category');
$table->primary(['art_id', 'cate_id']);
});
建立文章标签与文章对应的表时报错
然后把
> $table->integer(‘art_id’)->unsigned();
> $table->integer(‘cate_id’)->unsigned();
里面加上10
> $table->integer(‘art_id’)->unsigned(10);
> $table->integer(‘cate_id’)->unsigned(10);
然后就可以了！
运行这个语句前，iphpt_article 和 iphpt_category两个表必须存在，否则还会报错
> SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint (SQL: alter table iphpt_tags add constraint iphpt_tags_tag_id_foreign foreign key (tag_id) references iphpt_tag (id))
欢迎转载,但请附上原文地址哦,尊重原创,谢谢大家 本文地址: https://www.iphpt.com/detail/3/
本站(PHP --> Golang)已重构,代码开源
