Migration to add missing `uuid` column to `failed_jobs` table when upgrading Laravel.

0000_00_00_000000_alter_failed_jobs_add_uuid.php

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
use Ramsey\Uuid\Uuid;

class AlterFailedJobsAddUuid extends Migration
{
    public function up()
    {
        Schema::table('failed_jobs', function (Blueprint $table) {
            $table->string('uuid')->nullable();
        });

        // Backfill in chunks
        $chunks = \DB::table('failed_jobs')
            ->select('id')
            ->get()
            ->pluck('id')
            ->chunk(1000);
        foreach ($chunks as $chunk) {
            $values = [];
            foreach ($chunk as $id) {
                $uuid = Uuid::uuid4()->toString();
                $values[] = "({$id}, '{$uuid}')";
            }
            $imploded = implode(',', $values);
            $sql = <<<SQL
update failed_jobs as f set
uuid = u.uuid
from (values $imploded) as u(id, uuid)
where u.id = f.id
SQL;
            \DB::statement($sql);
        }

        Schema::table('failed_jobs', function (Blueprint $table) {
            $table->string('uuid')->unique()->change();
        });
    }

    public function down()
    {
        Schema::table('failed_jobs', function (Blueprint $table) {
            $table->dropColumn('uuid');
        });
    }
}