Skip to content

An open-source, self-hostable PaaS alternative to Vercel, Heroku & Netlify that lets you easily deploy static sites, databases, full-stack applications and 360+ one-click services on your own servers.

1.1 KB
Raw Blame
<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Support\Facades\DB;

return new class extends Migration
{
    /**
     * Run the migrations.
     */
    public function up(): void
    {
        DB::table('additional_destinations')
            ->select([
                'application_id',
                'server_id',
                'standalone_docker_id',
                DB::raw('MIN(id) as first_id'),
            ])
            ->groupBy('application_id', 'server_id', 'standalone_docker_id')
            ->havingRaw('COUNT(*) > 1')
            ->get()
            ->each(function (object $duplicate): void {
                DB::table('additional_destinations')
                    ->where('application_id', $duplicate->application_id)
                    ->where('server_id', $duplicate->server_id)
                    ->where('standalone_docker_id', $duplicate->standalone_docker_id)
                    ->where('id', '!=', $duplicate->first_id)
                    ->delete();
            });
    }

    /**
     * Reverse the migrations.
     */
    public function down(): void {}
};