View file database/upgrades/20170904124944_change_relate_in_spam.php

<?php

use App\Models\Blog;
use App\Models\Down;
use App\Models\Guest;
use App\Models\Inbox;
use App\Models\News;
use App\Models\Offer;
use App\Models\Photo;
use App\Models\Post;
use App\Models\Wall;
use Phinx\Migration\AbstractMigration;

class ChangeRelateInSpam extends AbstractMigration
{
    /**
     * Migrate Up.
     */
    public function up()
    {
        $table = $this->table('spam');
        $table->changeColumn('relate_type', 'string', ['limit' => 50])
            ->save();

        $this->execute('UPDATE spam SET relate_type="'.addslashes(Photo::class).'" WHERE relate_type="Photo";');
        $this->execute('UPDATE spam SET relate_type="'.addslashes(Blog::class).'" WHERE relate_type="Blog";');
        $this->execute('UPDATE spam SET relate_type="'.addslashes(News::class).'" WHERE relate_type="News";');
        $this->execute('UPDATE spam SET relate_type="'.addslashes(Offer::class).'" WHERE relate_type="Offer";');
        $this->execute('UPDATE spam SET relate_type="'.addslashes(Down::class).'" WHERE relate_type="Down";');
        $this->execute('UPDATE spam SET relate_type="'.addslashes(Post::class).'" WHERE relate_type="Post";');
        $this->execute('UPDATE spam SET relate_type="'.addslashes(Guest::class).'" WHERE relate_type="Guest";');
        $this->execute('UPDATE spam SET relate_type="'.addslashes(Inbox::class).'" WHERE relate_type="Inbox";');
        $this->execute('UPDATE spam SET relate_type="'.addslashes(Wall::class).'" WHERE relate_type="Wall";');
    }

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

        $this->execute('UPDATE spam SET relate_type="Photo" WHERE relate_type="'.addslashes(Photo::class).'";');
        $this->execute('UPDATE spam SET relate_type="Blog" WHERE relate_type="'.addslashes(Blog::class).'";');
        $this->execute('UPDATE spam SET relate_type="News" WHERE relate_type="'.addslashes(News::class).'";');
        $this->execute('UPDATE spam SET relate_type="Offer" WHERE relate_type="'.addslashes(Offer::class).'";');
        $this->execute('UPDATE spam SET relate_type="Down" WHERE relate_type="'.addslashes(Down::class).'";');
        $this->execute('UPDATE spam SET relate_type="Post" WHERE relate_type="'.addslashes(Post::class).'";');
        $this->execute('UPDATE spam SET relate_type="Guest" WHERE relate_type="'.addslashes(Guest::class).'";');
        $this->execute('UPDATE spam SET relate_type="Inbox" WHERE relate_type="'.addslashes(Inbox::class).'";');
        $this->execute('UPDATE spam SET relate_type="Wall" WHERE relate_type="'.addslashes(Wall::class).'";');
    }
}