From 668e03d4e52c118cc0e28508cceb1c8ec2b1eabf Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Sat, 19 May 2012 00:45:45 -0700
Subject: sql script to ccnvert all tables to innodb

---
 convert_innodb.sql | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)
 create mode 100644 convert_innodb.sql

(limited to 'convert_innodb.sql')

diff --git a/convert_innodb.sql b/convert_innodb.sql
new file mode 100644
index 000000000..9eeb67fe8
--- /dev/null
+++ b/convert_innodb.sql
@@ -0,0 +1,19 @@
+
+
+ALTER TABLE `profile` DROP INDEX `pub_keywords` ; 
+ALTER TABLE `profile` DROP INDEX `prv_keywords` ;
+
+ALTER TABLE `item` DROP INDEX `title` ;
+ALTER TABLE `item` DROP INDEX `body` ;
+ALTER TABLE `item` DROP INDEX `allow_cid` ;
+ALTER TABLE `item` DROP INDEX `allow_gid` ;
+ALTER TABLE `item` DROP INDEX `deny_cid` ;
+ALTER TABLE `item` DROP INDEX `deny_gid` ;
+ALTER TABLE `item` DROP INDEX `tag` ;
+ALTER TABLE `item` DROP INDEX `file` ;
+
+
+SELECT CONCAT('ALTER TABLE ',table_schema,'.',table_name,' engine=InnoDB;') 
+FROM information_schema.tables 
+WHERE engine = 'MyISAM';
+
-- 
cgit v1.2.3

