merged 2 if() into one as requested by CR

[friendica.git] / util / convert_innodb.sql

diff --git a/util/convert_innodb.sql b/util/convert_innodb.sql
index bcc87222af75438d3c2ac400fa03c95a8026312d..7f3d99a4da43f6932b493c0029e1db03fa58c3b8 100644 (file)
--- a/util/convert_innodb.sql
+++ b/util/convert_innodb.sql
@@ -1,4 +1,6 @@
-
+#  script to convert tables from MyISAM to InnoDB
+#  change the %PLACEHOLDER% to the actual name of your Friendica DB
+ 
 SELECT CONCAT('ALTER TABLE ',table_schema,'.',table_name,' engine=InnoDB;') 
 FROM information_schema.tables 
-WHERE engine = 'MyISAM' AND  `table_schema` = 'friendica';
+WHERE engine = 'MyISAM' AND  `table_schema` = '%PLACEHOLDER%';