From 61c73b1a0c91181f719902cdf74c852449cb4d71 Mon Sep 17 00:00:00 2001
From: Paul POULAIN <paul@koha-fr.org>
Date: Wed, 24 Oct 2007 14:15:23 -0500
Subject: [PATCH] new tables created with innoDB & utf8 automatically

Signed-off-by: Chris Cormack <crc@liblime.com>
Signed-off-by: Joshua Ferraro <jmf@liblime.com>
---
 updater/update22to30.pl | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/updater/update22to30.pl b/updater/update22to30.pl
index bb7e044db8..70116985bd 100755
--- a/updater/update22to30.pl
+++ b/updater/update22to30.pl
@@ -1821,7 +1821,7 @@ my $DBversion = "3.00.00.000";
     foreach $table ( keys %requiretables ) {
         unless ( $existingtables{$table} ) {
         print "Adding $table table...\n" unless $silent;
-            my $sth = $dbh->prepare("create table $table $requiretables{$table}");
+            my $sth = $dbh->prepare("create table $table $requiretables{$table} ENGINE=InnoDB DEFAULT CHARSET=utf8");
             $sth->execute;
             if ( $sth->err ) {
                 print "Error : $sth->errstr \n";
-- 
2.39.5