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();
        }
    }
}