20200303122949_add_time_created_index_to_annotations_table.php

Go to the documentation of this file.

<?php

use Phinx\Migration\AbstractMigration;

class AddTimeCreatedIndexToAnnotationsTable extends AbstractMigration {
    
    public function change() {
        if (!$this->hasTable('annotations')) {
            return;
        }
        
        $table = $this->table('annotations');
        if ($table->hasIndexByName('time_created')) {
            return;
        }
        
        $table->addIndex(['time_created'], [
            'name' => 'time_created',
            'unique' => false,
        ]);
        
        $table->save();
    }
}