/ database / migrations / 2023_03_29_110955_create_jobs_table.php
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  };