| 12345678910111213141516171819202122232425262728293031323334 |
- <?php
- use Illuminate\Database\Migrations\Migration;
- use Illuminate\Database\Schema\Blueprint;
- use Illuminate\Support\Facades\Schema;
- return new class extends Migration
- {
- /**
- * Run the migrations.
- */
- public function up(): void
- {
- Schema::table('failed_jobs', static function (Blueprint $table) {
- $table->string('uuid')->after('id')->nullable()->unique();
- });
- DB::table('failed_jobs')->whereNull('uuid')->cursor()->each(function ($job) {
- DB::table('failed_jobs')
- ->where('id', $job->id)
- ->update(['uuid' => (string) Illuminate\Support\Str::uuid()]);
- });
- }
- /**
- * Reverse the migrations.
- */
- public function down(): void
- {
- Schema::table('failed_jobs', function (Blueprint $table) {
- $table->dropColumn('uuid');
- });
- }
- };
|