20171016113827_update_metadata_columns.php

Go to the documentation of this file.

<?php

use Phinx\Migration\AbstractMigration;

class UpdateMetadataColumns extends AbstractMigration {
    public function up() {

        if ($this->hasTable('metadata')) {
            $table = $this->table('metadata');

            if ($table->hasIndexByName('owner_guid')) {
                $table->removeIndexByName('owner_guid')->save();
            }
            if ($table->hasIndexByName('access_id')) {
                $table->removeIndexByName('access_id')->save();
            }

            if ($table->hasColumn('owner_guid')) {
                $table->changeColumn('owner_guid', 'integer', ['null' => true]);
            }
            if ($table->hasColumn('access_id')) {
                $table->changeColumn('access_id', 'integer', ['null' => true]);
            }

            $table->save();
        }
    }
}