View file database/upgrades/20200429150805_change_relate_type_in_comments.php

<?php

use Phinx\Migration\AbstractMigration;

class ChangeRelateTypeInComments extends AbstractMigration
{
    /**
     * Migrate Up.
     */
    public function up(): void
    {
        $this->execute('UPDATE comments SET relate_type="downs" WHERE relate_type LIKE "%Down";');
        $this->execute('UPDATE comments SET relate_type="photos" WHERE relate_type LIKE "%Photo";');
        $this->execute('UPDATE comments SET relate_type="articles" WHERE relate_type LIKE "%Blog";');
        $this->execute('UPDATE comments SET relate_type="offers" WHERE relate_type LIKE "%Offer";');
        $this->execute('UPDATE comments SET relate_type="news" WHERE relate_type LIKE "%News";');

        $table = $this->table('comments');
        $table->changeColumn('relate_type', 'string', ['limit' => 10])
            ->save();
    }

    /**
     * Migrate Down.
     */
    public function down(): void
    {
        $table = $this->table('comments');
        $table->changeColumn('relate_type', 'string', ['limit' => 50])
            ->save();

        $this->execute('UPDATE comments SET relate_type="App\\Models\\Down" WHERE relate_type="downs";');
        $this->execute('UPDATE comments SET relate_type="App\\Models\\Photo" WHERE relate_type="photos";');
        $this->execute('UPDATE comments SET relate_type="App\\Models\\Blog" WHERE relate_type="articles";');
        $this->execute('UPDATE comments SET relate_type="App\\Models\\Offer" WHERE relate_type="offers";');
        $this->execute('UPDATE comments SET relate_type="App\\Models\\News" WHERE relate_type="news";');
    }
}