mysql/mysql_change_engine.sql

diff --git a/mysql/mysql_change_engine.sql b/mysql/mysql_change_engine.sql
index 77bdabb..128c6ee 100644 (file)
--- a/mysql/mysql_change_engine.sql
+++ b/mysql/mysql_change_engine.sql
@@ -1,62 +1,6 @@
 
 
 DROP PROCEDURE IF EXISTS mysql_change_engine;
-
-delimiter $$
-
-
-CREATE PROCEDURE mysql_change_engine(mytb TEXT)
-    BEGIN
-    DECLARE mydb TEXT;
-    
-    SELECT database() INTO mydb;
-    
-    
-    SELECT
-        IF(
-            dbtb2='.',
-            CONCAT('ALTER TABLE ',dbtb1,' ENGINE=InnoDB'),
-            CONCAT('SELECT ''',dbtb1,' is Already InnoDB'' as \"No Need to Convert\"')
-        )
-    INTO
-        @ConvertEngineSQL
-        
-    FROM (
-        SELECT
-            CONCAT(A.db,'.',A.tb) dbtb1,
-            CONCAT(IFNULL(B.db,''),'.',IFNULL(B.tb,'')) dbtb2,engine
-        FROM
-            (
-                SELECT
-                    table_schema db,table_name tb,engine
-                FROM
-                    information_schema.tables
-                WHERE
-                    table_schema=mydb and table_name=mytb
-            ) A
-        LEFT JOIN
-            (
-                SELECT
-                    table_schema db,table_name tb
-                FROM
-                    information_schema.tables
-                WHERE
-                    table_schema=mydb COLLATE utf8_unicode_ci 
-                    AND 
-                    table_name=mytb COLLATE utf8_unicode_ci 
-                    AND engine='InnoDB'
-            ) B
-        USING
-            (db,tb)
-    ) AA;
-            
-    -- SELECT ConvertEngineSQL; -- ???
-    PREPARE st FROM @ConvertEngineSQL;
-    EXECUTE st;
-    DEALLOCATE PREPARE st;
-
-END;
-
-$$
-
-DELIMITER ;
+  
+ -- this code has been moved to PHP as we force it on all tables now..
+ 
\ No newline at end of file