2023_03_29_110955_create_jobs_table.php
1 <?php 2 3 use Illuminate\Database\Migrations\Migration; 4 use Illuminate\Database\Schema\Blueprint; 5 use Illuminate\Support\Facades\Schema; 6 7 return new class extends Migration 8 { 9 /** 10 * Run the migrations. 11 * 12 * @return void 13 */ 14 public function up() 15 { 16 Schema::create('jobs', function (Blueprint $table) { 17 $table->bigIncrements('id'); 18 $table->string('queue')->index(); 19 $table->longText('payload'); 20 $table->unsignedTinyInteger('attempts'); 21 $table->unsignedInteger('reserved_at')->nullable(); 22 $table->unsignedInteger('available_at'); 23 $table->unsignedInteger('created_at'); 24 }); 25 } 26 27 /** 28 * Reverse the migrations. 29 * 30 * @return void 31 */ 32 public function down() 33 { 34 Schema::dropIfExists('jobs'); 35 } 36 };