英文:
Laravel migration, can't create foreign key
问题
以下是要翻译的内容：
Those are the following migration files:
User migration
Schema::create('users', function (Blueprint $table) {
$table->uuid('id');
$table->string('name');
$table->string('email')->unique();
$table->timestamps();
});
Log migration
Schema::create('log', function (Blueprint $table) {
$table->uuid('id');
$table->boolean('status');
$table->timestamps();
$table->foreign('id')->references('id')->on('users')->onDelete('cascade');
});
When I run the migrations it shows:
PDOException::("SQLSTATE[HY000]: General error: 1005 Can't create table
laravel.log(errno: 150 "Foreign key constraint is incorrectly formed")")
I also tried:
Schema::create('log', function (Blueprint $table) {
$table->uuid('id');
$table->boolean('status');
$table->timestamps();
});
Schema::table('log', function($table) {
$table->foreign('id')
->references('id')
->on('users')
->onDelete('cascade');
});
Schema::create('log', function (Blueprint $table) {
$table->uuid('id')->primary();
$table->foreignUuid('foreign_id');
$table->boolean('status');
$table->timestamps();
});
Schema::table('log', function($table) {
$table->foreign('foreign_id')
->references('id')
->on('users')
->onDelete('cascade');
});
But still not working.
-- I have solved this problem
User
Schema::create('users', function (Blueprint $table) {
$table->uuid('id')->primary();
$table->string('name');
$table->string('email')->unique();
$table->timestamps();
});
log
Schema::create('log', function (Blueprint $table) {
$table->uuid('id')->primary();
$table->foreignUuid('user_id');
$table->boolean('status');
$table->timestamps();
}
Schema::table('log', function($table) {
$table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
});
英文:
Those are the following migration files:
User migration
Schema::create('users', function (Blueprint $table) {
$table->uuid('id');
$table->string('name');
$table->string('email')->unique();
$table->timestamps();
});
Log migration
Schema::create('log', function (Blueprint $table) {
$table->uuid('id');
$table->boolean('statu');
$table->timestamps();
$table->foreign('id')->references('id')->on('users')->onDelete('cascade');
});
When I run the migrations it shows:
> PDOException::("SQLSTATE[HY000]: General error: 1005 Can't create table laravel.log (errno: 150 "Foreign key constraint is incorrectly formed")")
I also tried:
Schema::create('log', function (Blueprint $table) {
$table->uuid('id');
$table->boolean('statu');
$table->timestamps();
});
Schema::table('log', function($table) {
$table->foreign('id')
->references('id')
->on('users')
->onDelete('cascade');
});
Schema::create('log', function (Blueprint $table) {
$table->uuid('id')->primary();
$table->foreignUuid('foreign_id');
$table->boolean('statu');
$table->timestamps();
});
Schema::table('log', function($table) {
$table->foreign('foreign_id')
->references('id')
->on('users')
->onDelete('cascade');
});
But still not working.
-- I have solved this problem
User
Schema::create('users', function (Blueprint $table) {
$table->uuid('id')->primary();
$table->string('name');
$table->string('email')->unique();
$table->timestamps();
});
log
Schema::create('log', function (Blueprint $table) {
$table->uuid('id')->primary();
$table->foreignUuid('user_id');
$table->boolean('statu');
$table->timestamps();
});
Schema::table('log', function($table) {
$table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
});
答案1
得分: 2
尝试将以下内容添加到您的用户表中：
$table->uuid('id')->primary();
这里的代码告诉数据库将'id'列设置为主键。
然后，您应该将您的外键命名为“表的名称_id”。对于您来说，应该是：
$table->foreignUuid('foreign_id');
最后，您可以添加：
$table->foreignUuid('user_id')->constrained();
完整的代码如下：
Schema::create('users', function (Blueprint $table) {
$table->uuid('id')->primary();
$table->string('name');
$table->string('email')->unique();
$table->timestamps();
});
Schema::create('log', function (Blueprint $table) {
$table->uuid('id');
$table->boolean('statu');
$table->timestamps();
$table->foreignUuid('user_id')->constrained();
});
希望这对您有所帮助。
英文:
Try adding to your users table :
$table->uuid('id')->primary();
Nothing here indicate to you database that id is the primary key.
Then you should call your foreign key as "name_of_the_table"_id.
For you it should be :
$table->foreignUuid('foreign_id');
And finally you can add :
$table->foreignUuid('user_id')->constrained();
The complete code is something like that :
Schema::create('users', function (Blueprint $table) {
$table->uuid('id')->primary();
$table->string('name');
$table->string('email')->unique();
$table->timestamps();
});
Schema::create('log', function (Blueprint $table) {
$table->uuid('id');
$table->boolean('statu');
$table->timestamps();
$table->foreignUuid('user_id')->constrained();
});
答案2
得分: -1
请使用 $table->id(); 而不是 $table->uuid('id');。
英文:
Please use $table->id(); instead of $table->uuid('id');
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论