Skip to content

Commit

Permalink
Browse files Browse the repository at this point in the history
Script to convert every WebGUI except assetIndex table from MyISAM to…
… InnoDB.
  • Loading branch information
perlDreamer committed Nov 24, 2011
1 parent e0ab5ea commit 288adcf
Showing 1 changed file with 15 additions and 0 deletions.
15 changes: 15 additions & 0 deletions share/upgrades/7.10.23-8.0.0/zzzz_convertToInnoDb.pl
@@ -0,0 +1,15 @@

use WebGUI::Upgrade::Script;

start_step "Convert all tables except assetIndex to InnoDB";

my $get_table = session->db->table_info('', '', '%', 'TABLE');

TABLE: while ( my $table = $get_table->fetchrow_hashref() ) {
next TABLE if $table->{TABLE_NAME} eq 'assetIndex';
session->db->write("ALTER TABLE ". $table->{TABLE_NAME}. " ENGINE=InnoDB");
}


done;

0 comments on commit 288adcf

Please sign in to comment.