<?php
declare(strict_types=1);
use Phinx\Migration\AbstractMigration;

final class FirstMigration extends AbstractMigration
{
    public function up() {
        $table = $this->table('manutencao.migra');
	    $table->addColumn('nome', 'string', ['null' => false])
	          ->addColumn('col2', 'string', ['null' => false])
	          ->addColumn('col3', 'boolean', ['null' => false,'default' => true])
	          ->addColumn('criada', 'datetime',['null' => false,'default'=>'CURRENT_TIMESTAMP'])
              ->save();

        $this->execute("INSERT
                          INTO manutencao.migra
                             ( nome
                             , col2
                             )
                        VALUES
                             ( 'teste'
                             , 'teste@teste.com'
                             )
                       ");
    }
    public function down() {
        $this->execute("DELETE FROM manutencao.migra;");
        $this->table('manutencao.migra')
             ->drop()
             ->save();
    }
}