summaryrefslogtreecommitdiff
path: root/database/migrations/2021_02_28_172947_create_jobs_table.php
diff options
context:
space:
mode:
authorhorus2022-01-03 14:55:54 +0100
committerhorus2022-01-03 14:55:54 +0100
commit0f94ba96bd39e48f5f7720ee62b028e2584ff96d (patch)
treef87f189f9cca1701eb6cc62afae0159ecab7034f /database/migrations/2021_02_28_172947_create_jobs_table.php
parent536b38a27f5ca16e40eb3de4d1fd8e6f1d25e924 (diff)
downloadsenpai-0f94ba96bd39e48f5f7720ee62b028e2584ff96d.tar.gz
Add queue monitor
Diffstat (limited to 'database/migrations/2021_02_28_172947_create_jobs_table.php')
-rw-r--r--database/migrations/2021_02_28_172947_create_jobs_table.php36
1 files changed, 36 insertions, 0 deletions
diff --git a/database/migrations/2021_02_28_172947_create_jobs_table.php b/database/migrations/2021_02_28_172947_create_jobs_table.php
new file mode 100644
index 0000000..1be9e8a
--- /dev/null
+++ b/database/migrations/2021_02_28_172947_create_jobs_table.php
@@ -0,0 +1,36 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+class CreateJobsTable extends Migration
+{
+ /**
+ * Run the migrations.
+ *
+ * @return void
+ */
+ public function up()
+ {
+ Schema::create('jobs', function (Blueprint $table) {
+ $table->bigIncrements('id');
+ $table->string('queue')->index();
+ $table->longText('payload');
+ $table->unsignedTinyInteger('attempts');
+ $table->unsignedInteger('reserved_at')->nullable();
+ $table->unsignedInteger('available_at');
+ $table->unsignedInteger('created_at');
+ });
+ }
+
+ /**
+ * Reverse the migrations.
+ *
+ * @return void
+ */
+ public function down()
+ {
+ Schema::dropIfExists('jobs');
+ }
+}