20170728040000_change_table_engine.php

Go to the documentation of this file.

<?php
 
use Phinx\Migration\AbstractMigration;
 
class ChangeTableEngine extends AbstractMigration {
 
    private $innodb_tables = [
        'access_collection_membership',
        'access_collections',
        'annotations',
        'api_users',
        'config',
        'entities',
        'entity_relationships',
        'entity_subtypes',
        'metadata',
        'metastrings',
        'private_settings',
        'queue',
        'river',
        'system_log',
        'users_remember_me_cookies',
        'users_sessions',
    ];
 
    public function up() {
 
        $prefix = $this->getAdapter()->getOption('table_prefix');
 
        foreach ($this->innodb_tables as $table) {
            if (!$this->hasTable($table)) {
                continue;
            }
 
            $this->execute("
                ALTER TABLE {$prefix}{$table}
                ENGINE=InnoDB
            ");
        }
    }
 
    public function down() {
 
        $prefix = $this->getAdapter()->getOption('table_prefix');
 
        foreach ($this->innodb_tables as $table) {
            if (!$this->hasTable($table)) {
                continue;
            }
 
            $this->execute("
                ALTER TABLE {$prefix}{$table}
                ENGINE=MyISAM
            ");
        }
 
    }
}