25 lines
679 B
PHP
25 lines
679 B
PHP
<?php
|
|
declare(strict_types=1);
|
|
|
|
use Migrations\BaseMigration;
|
|
|
|
class CreateTools extends BaseMigration
|
|
{
|
|
public function change(): void
|
|
{
|
|
$table = $this->table('tools')
|
|
->addColumn('name', 'string', ['limit' => 150])
|
|
->addColumn('description', 'text', ['null' => true])
|
|
->addColumn('quantity', 'integer', ['default' => 1])
|
|
->addColumn('active', 'boolean', ['default' => true])
|
|
->addColumn('created', 'datetime')
|
|
->addColumn('modified', 'datetime', ['null' => true])
|
|
->create();
|
|
}
|
|
|
|
public function down(): void
|
|
{
|
|
$this->table('tools')->drop()->save();
|
|
}
|
|
}
|