<?php

declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class TaskInc60593 extends AbstractMigration
{
    public function up(): void
    {
        $this->execute(<<<SQL
            UPDATE regulacao.lvp001_croqui
               SET ds_coordenadas_poligono = REPLACE(REPLACE(ds_coordenadas_poligono, 'm', 'latitude'), 'n', 'longitude')
             WHERE ds_coordenadas_poligono ilike '%"m"%"n"%';
SQL
        );
    }

    public function down(): void
    {
        // there is no return once all rows will be "latitude" and "longitude"
    }
}