Skip to content

GitLab

Merged
Created by Mujahid Rofiq@MujahidRMaintainer

p

Compare
and
1 file
+ 1
- 7
database/migrations/2024_08_16_033829_alter_paymentpurch.php
+ 1
- 7
Show all unchanged lines Show 20 lines
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
use Illuminate\Support\Facades\DB;
return new class extends Migration
{
Show 20 lines Show all unchanged lines Show 20 lines
public function up()
{
Schema::table('payment_purchases', function (Blueprint $table) {
// Drop the existing foreign key constraint
$table->dropForeign(['user_id']);
// Change the column to be nullable
$table->integer('user_id')->nullable()->change();
// Re-add the foreign key constraint
$table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
});
}
Show 20 lines Show all unchanged lines Show 20 lines
{
Schema::table('payment_purchases', function (Blueprint $table) {
// Drop the existing foreign key constraint
$table->dropForeign(['user_id']);
// Revert the column to be non-nullable
$table->integer('user_id')->nullable(false)->change();
// Re-add the foreign key constraint
$table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
});
}
};