diff options
| author | alecpl <alec@alec.pl> | 2010-09-14 06:28:43 +0000 |
|---|---|---|
| committer | alecpl <alec@alec.pl> | 2010-09-14 06:28:43 +0000 |
| commit | fc552950d30d752f856a7c686c4cbc74e4b0da4b (patch) | |
| tree | 85a648a41fae78e4f6fe0ea5e0fc40d253dec270 /SQL | |
| parent | cb3dfdfedef18381a30fd9b80c9f7120af1031a4 (diff) | |
- Added warning about tables engine, per discussion in #1486794
Diffstat (limited to 'SQL')
| -rw-r--r-- | SQL/mysql.update.sql | 3 |
1 files changed, 2 insertions, 1 deletions
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 */; |