<?php

use think\migration\db\Column;
use think\migration\Migrator;

class CreateJobsTable extends Migrator
{
    public function change()
    {
        $this->table('{{table}}')
            ->addColumn(Column::string('queue'))
            ->addColumn(Column::longText('payload'))
            ->addColumn(Column::tinyInteger('attempts')->setUnsigned())
            ->addColumn(Column::unsignedInteger('reserved_at')->setNullable())
            ->addColumn(Column::unsignedInteger('available_at'))
            ->addColumn(Column::unsignedInteger('created_at'))
            ->addIndex('queue')
            ->create();
    }
}