summaryrefslogtreecommitdiff
path: root/SQL/mysql.update.sql
diff options
context:
space:
mode:
authoralecpl <alec@alec.pl>2010-03-09 06:57:39 +0000
committeralecpl <alec@alec.pl>2010-03-09 06:57:39 +0000
commitac756e88583e21c60b56b52b34957f1908f9167f (patch)
tree0a5e053f96cd3aedf9f164ccc3811e8a06626d51 /SQL/mysql.update.sql
parentbe5133a6f3ec4da11f0a6f972700bf4b256d410c (diff)
- fix add index
Diffstat (limited to 'SQL/mysql.update.sql')
-rw-r--r--SQL/mysql.update.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql
index 8d86867ce..c4a897903 100644
--- a/SQL/mysql.update.sql
+++ b/SQL/mysql.update.sql
@@ -81,6 +81,6 @@ ALTER TABLE `contacts` ALTER `name` SET DEFAULT '';
ALTER TABLE `contacts` ALTER `firstname` SET DEFAULT '';
ALTER TABLE `contacts` ALTER `surname` SET DEFAULT '';
-ALTER TABLE `identities` INDEX `user_identities_index` (`user_id`, `del`);
+ALTER TABLE `identities` ADD INDEX `user_identities_index` (`user_id`, `del`);
/*!40014 SET FOREIGN_KEY_CHECKS=1 */;