我有自定義遷移:代碼:// Groups migrationSchema::create('groups', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('name'); $table->boolean('status')->default(false); $table->timestamps();});// Clients migrationSchema::create('clients', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('fullname'); $table->integer('phone'); $table->date('birthday')->nullable(); $table->boolean('can_get_congratulations')->default(false); $table->unsignedInteger('group_id')->default(null); $table->foreign('group_id') ->references('id') ->on('groups') ->onDelete('cascade'); $table->boolean('status')->default(true); $table->timestamps();});當(dāng)我運(yùn)行此遷移文件時(shí),會(huì)收到錯(cuò)誤消息:Illuminate\Database\QueryException : SQLSTATE[HY000]: General error: 1005 Can't create table taxisms。#sql-1cc0_65c(errno: 150 "Foreign key constraint is wrongly forms") (SQL: alter table clientsadd constraint clients_group_id_foreignforeign key ( group_id) references groups( id) on delete cascade)我的遷移代碼哪里有錯(cuò)誤?
1 回答

守著一只汪
TA貢獻(xiàn)1872條經(jīng)驗(yàn) 獲得超4個(gè)贊
該列需要在兩側(cè)匹配。由于groups.id
是無符號(hào)大整數(shù),因此 group_id 也需要。改變
$table->unsignedInteger('group_id')
到
$table->unsignedBigInteger('group_id')
- 1 回答
- 0 關(guān)注
- 148 瀏覽
添加回答
舉報(bào)
0/150
提交
取消