my-idlers/database/migrations/2022_06_24_023931_alter_yabs_foreign_key_delete.php
cp6 59b3138dfb Possible YABs foreign keys migrations error fix
Possible YABs foreign keys migrations error fix
2022-07-25 10:33:54 +10:00

19 lines
523 B
PHP

<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
return new class extends Migration {
public function up()
{
Schema::table('yabs', function (Blueprint $table) {
if (env('DB_CONNECTION') !== 'sqlite') {
$table->dropForeign('yabs_fk_servers');
}
$table->foreign('server_id', 'yabs_fk_servers')->references('id')->on('servers')->onDelete('cascade');
});
}
};