<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class Task2104231610 extends AbstractMigration
{
    public function up(): void
    {
    	$this->execute("
			CREATE TABLE sistema.assessorias_prepostos
			(
			  id_preposto integer NOT NULL,
			  id_assessoria integer NOT NULL,
			  vl_percentual numeric(12,2) NOT NULL,
			  CONSTRAINT pk_assessorias_prepostos PRIMARY KEY (id_preposto),
			  CONSTRAINT fk_assessorias_prepostos FOREIGN KEY (id_preposto)
			      REFERENCES sistema.prepostos (id),
			  CONSTRAINT fk_assessorias_corretores_assessorias FOREIGN KEY (id_assessoria)
			      REFERENCES sistema.assessorias (id)
			)
			INHERITS (public.campos_default);
    	");
    }

    public function down(): void
    {
    	$this->execute("DROP TABLE sistema.assessorias_prepostos;");
    }
}