| Index: trunk/extensions/SemanticMediaWiki/includes/storage/SMW_SQLStore2_Queries.php |
| — | — | @@ -1161,7 +1161,7 @@ |
| 1162 | 1162 | . "LANGUAGE 'plpgsql'; " |
| 1163 | 1163 | . "SELECT create_" . $tablename . "(); "; |
| 1164 | 1164 | } else { // MySQL_ just a temporary table, use INSERT IGNORE later |
| 1165 | | - return "CREATE TEMPORARY TABLE " . $tablename . "( id INT UNSIGNED KEY ) TYPE=MEMORY"; |
| | 1165 | + return "CREATE TEMPORARY TABLE " . $tablename . "( id INT UNSIGNED KEY ) ENGINE=MEMORY"; |
| 1166 | 1166 | } |
| 1167 | 1167 | } |
| 1168 | 1168 | |
| Index: trunk/extensions/SemanticMediaWiki/includes/storage/SMW_SQLStore2.php |
| — | — | @@ -1086,7 +1086,7 @@ |
| 1087 | 1087 | . "LANGUAGE 'plpgsql'; " |
| 1088 | 1088 | . "SELECT create_" . $smw_tmp_unusedprops . "(); "; |
| 1089 | 1089 | } else { // MySQL: use temporary in-memory table |
| 1090 | | - $sql = "CREATE TEMPORARY TABLE " . $smw_tmp_unusedprops . "( title VARCHAR(255) ) TYPE=MEMORY"; |
| | 1090 | + $sql = "CREATE TEMPORARY TABLE " . $smw_tmp_unusedprops . "( title VARCHAR(255) ) ENGINE=MEMORY"; |
| 1091 | 1091 | } |
| 1092 | 1092 | |
| 1093 | 1093 | $db->query( $sql, $fname ); |
| Index: trunk/extensions/SemanticMediaWiki/includes/storage/SMW_SQLHelpers.php |
| — | — | @@ -261,7 +261,7 @@ |
| 262 | 262 | $typeold = ( $notnullposold > 0 ) ? substr( $currentFields[$name], 0, $notnullposold ) : $currentFields[$name]; |
| 263 | 263 | |
| 264 | 264 | if ( $typeold != $type ) { |
| 265 | | - $db->query( "ALTER TABLE \"" . $tableName . "\" ALTER COLUMN \"" . $name . "\" TYPE " . $type, __METHOD__ ); |
| | 265 | + $db->query( "ALTER TABLE \"" . $tableName . "\" ALTER COLUMN \"" . $name . "\" ENGINE " . $type, __METHOD__ ); |
| 266 | 266 | } |
| 267 | 267 | |
| 268 | 268 | if ( $notnullposold != $notnullposnew ) { |