From 4d163d02bedc6e11e4bb02d3d614032beaba9b72 Mon Sep 17 00:00:00 2001
From: stronk7 <stronk7>
Date: Wed, 9 Sep 2009 09:44:39 +0000
Subject: [PATCH] Do not force table type for temporary tables

---
 lib/ddl/mysql_sql_generator.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/lib/ddl/mysql_sql_generator.php b/lib/ddl/mysql_sql_generator.php
index cc80d17b93..b3f5d06c18 100644
--- a/lib/ddl/mysql_sql_generator.php
+++ b/lib/ddl/mysql_sql_generator.php
@@ -111,7 +111,7 @@ class mysql_sql_generator extends sql_generator {
     public function getCreateTempTableSQL($xmldb_table) {
         $this->temptables->add_temptable($xmldb_table->getName());
         $sqlarr = $this->getCreateTableSQL($xmldb_table);
-        $sqlarr = preg_replace('/^CREATE TABLE (.*)/s', 'CREATE TEMPORARY TABLE $1 TYPE=MyISAM', $sqlarr);
+        $sqlarr = preg_replace('/^CREATE TABLE (.*)/s', 'CREATE TEMPORARY TABLE $1', $sqlarr);
         return $sqlarr;
     }
 
-- 
2.39.5