From fc552950d30d752f856a7c686c4cbc74e4b0da4b Mon Sep 17 00:00:00 2001 From: alecpl Date: Tue, 14 Sep 2010 06:28:43 +0000 Subject: - Added warning about tables engine, per discussion in #1486794 --- SQL/mysql.update.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'SQL') diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql index 23fcad838..739a3d801 100644 --- a/SQL/mysql.update.sql +++ b/SQL/mysql.update.sql @@ -53,7 +53,6 @@ ALTER TABLE `users` ENGINE=InnoDB; ALTER TABLE `contacts` ENGINE=InnoDB; ALTER TABLE `identities` ENGINE=InnoDB; - -- Updates from version 0.3-stable TRUNCATE `messages`; @@ -68,6 +67,8 @@ ALTER TABLE `contacts` ADD INDEX `user_contacts_index` (`user_id`,`email`); -- Updates from version 0.3.1 +-- WARNING: Make sure that all tables are using InnoDB engine!!! +-- If not, use: ALTER TABLE xxx ENGINE=InnoDB; /* MySQL bug workaround: http://bugs.mysql.com/bug.php?id=46293 */ /*!40014 SET FOREIGN_KEY_CHECKS=0 */; -- cgit v1.2.3