20170728050000_expand_text_columns_to_longtext.php

Go to the documentation of this file.

<?php

use Phinx\Db\Adapter\MysqlAdapter;
use Phinx\Migration\AbstractMigration;

class ExpandTextColumnsToLongtext extends AbstractMigration {

    // Columns that change from text to longtext
    private $text_to_longtext = [
        'config' => ['value'],
        'private_settings' => ['value'],
    ];

    public function up() {

        foreach ($this->text_to_longtext as $table => $columns) {
            if (!$this->hasTable($table)) {
                continue;
            }

            $table = $this->table($table);

            foreach ($columns as $column) {
                if ($table->hasColumn($column)) {
                    $table->changeColumn($column, 'text', [
                        'limit' => MysqlAdapter::TEXT_LONG,
                    ]);
                }
            }

            $table->save();
        }
    }

    public function down() {

        foreach ($this->text_to_longtext as $table => $columns) {
            if (!$this->hasTable($table)) {
                continue;
            }

            $table = $this->table($table);

            foreach ($columns as $column) {
                if ($table->hasColumn($column)) {
                    $table->changeColumn($column, 'text', [
                        'limit' => MysqlAdapter::TEXT_REGULAR,
                    ]);
                }
            }

            $table->save();
        }
    }
}