View file Lottery/migrations/20200605230823_create_lottery_table.php

File size: 522B
<?php

use Phinx\Migration\AbstractMigration;

class CreateLotteryTable extends AbstractMigration
{
    /**
     * Change Method.
     */
    public function change(): void
    {
        $table = $this->table('lottery', ['engine' => config('DB_ENGINE'), 'collation' => config('DB_COLLATION')]);
        $table
            ->addColumn('day', 'date')
            ->addColumn('amount', 'integer')
            ->addColumn('number', 'smallinteger', ['limit' => 3])
            ->addIndex('day')
            ->create();
    }
}