라라벨 artisan queue:table

1 개요

artisan queue:table

php artisan queue:table

• queue jobs 테이블을 위한 마이그레이션을 생성하는 artisan 명령어

root@zetawiki:/var/www/laravel# php artisan queue:table
Migration created successfully!

root@zetawiki:/var/www/laravel# php artisan migrate:status
+------+------------------------------------------------+
| Ran? | Migration                                      |
+------+------------------------------------------------+
| Y    | 2014_10_12_000000_create_users_table           |
| Y    | 2014_10_12_100000_create_password_resets_table |
| N    | 2018_02_04_200457_create_jobs_table            |
+------+------------------------------------------------+

2 (Optional) 확인

root@zetawiki:/var/www/laravel# ll database/migrations/ | grep jobs
-rw-r--r-- 1 root   root      905 Feb  4 20:04 2018_02_04_200457_create_jobs_table.php

root@zetawiki:/var/www/laravel# cat database/migrations/2018_02_04_200457_create_jobs_table.php

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateJobsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('jobs', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->string('queue');
            $table->longText('payload');
            $table->unsignedTinyInteger('attempts');
            $table->unsignedInteger('reserved_at')->nullable();
            $table->unsignedInteger('available_at');
            $table->unsignedInteger('created_at');

            $table->index(['queue', 'reserved_at']);
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('jobs');
    }
}

3 artisan migrate

root@zetawiki:/var/www/laravel# php artisan migrate
Migrating: 2018_02_04_200457_create_jobs_table
Migrated:  2018_02_04_200457_create_jobs_table

'Specified key was too long error' 오류 발생하면 https://laravel-news.com/laravel-5-4-key-too-long-error 참고

4 같이 보기

• 라라벨 artisan migrate
• 라라벨 artisan migrate:status
• 라라벨 artisan queue:failed-table
• 라라벨 artisan 명령어
• 라라벨 CreateJobsTable 클래스
• 라라벨 jobs 테이블

5 참고

• https://laravel.com/docs/5.5/queues