123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657 |
- <?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::create('jobs', function (Blueprint $table) {
- $table->id();
- $table->string('queue')->index();
- $table->longText('payload');
- $table->unsignedTinyInteger('attempts');
- $table->unsignedInteger('reserved_at')->nullable();
- $table->unsignedInteger('available_at');
- $table->unsignedInteger('created_at');
- });
- Schema::create('job_batches', function (Blueprint $table) {
- $table->string('id')->primary();
- $table->string('name');
- $table->integer('total_jobs');
- $table->integer('pending_jobs');
- $table->integer('failed_jobs');
- $table->longText('failed_job_ids');
- $table->mediumText('options')->nullable();
- $table->integer('cancelled_at')->nullable();
- $table->integer('created_at');
- $table->integer('finished_at')->nullable();
- });
- Schema::create('failed_jobs', function (Blueprint $table) {
- $table->id();
- $table->string('uuid')->unique();
- $table->text('connection');
- $table->text('queue');
- $table->longText('payload');
- $table->longText('exception');
- $table->timestamp('failed_at')->useCurrent();
- });
- }
- /**
- * Reverse the migrations.
- */
- public function down(): void
- {
- Schema::dropIfExists('jobs');
- Schema::dropIfExists('job_batches');
- Schema::dropIfExists('failed_jobs');
- }
- };
|