<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class Task2109031442 extends AbstractMigration
{
    public function up(): void
    {
        $this->execute(<<<SQL
CREATE TABLE atendimento.chamados_leitura (
	id SERIAL NOT NULL,
	ip varchar(45) NOT NULL,
	id_chamado INTEGER NOT NULL,
	CONSTRAINT pk_chamados_leitura PRIMARY KEY (id),
	CONSTRAINT fk_chamados_leitura_chamados FOREIGN KEY (id_chamado) REFERENCES atendimento.chamados(id)
) INHERITS (public.campos_default);
SQL
);
    }

    public function down(): void
    {
        $this->execute(<<<SQL
DROP TABLE atendimento.chamados_leitura;
SQL
);
    }
}