mirror of
https://github.com/janickiy/yii2-nomer
synced 2025-02-12 10:01:52 +00:00
39 lines
1 KiB
PHP
39 lines
1 KiB
PHP
<?php
|
|
/**
|
|
* @link https://github.com/zhuravljov/yii2-queue
|
|
* @copyright Copyright (c) 2017 Roman Zhuravlev
|
|
* @license http://opensource.org/licenses/BSD-3-Clause
|
|
*/
|
|
|
|
use yii\db\Migration;
|
|
|
|
/**
|
|
* Example of migration for queue message storage
|
|
*
|
|
* @author Roman Zhuravlev <zhuravljov@gmail.com>
|
|
*/
|
|
class M161119140200Queue extends Migration
|
|
{
|
|
public $tableName = '{{%queue}}';
|
|
public $tableOptions;
|
|
|
|
public function up()
|
|
{
|
|
$this->createTable($this->tableName, [
|
|
'id' => $this->primaryKey(),
|
|
'channel' => $this->string()->notNull(),
|
|
'job' => $this->binary()->notNull(),
|
|
'created_at' => $this->integer()->notNull(),
|
|
'started_at' => $this->integer(),
|
|
'finished_at' => $this->integer(),
|
|
], $this->tableOptions);
|
|
|
|
$this->createIndex('channel', $this->tableName, 'channel');
|
|
$this->createIndex('started_at', $this->tableName, 'started_at');
|
|
}
|
|
|
|
public function down()
|
|
{
|
|
$this->dropTable($this->tableName);
|
|
}
|
|
}
|