diff options
| author | alecpl <alec@alec.pl> | 2010-03-09 06:57:39 +0000 |
|---|---|---|
| committer | alecpl <alec@alec.pl> | 2010-03-09 06:57:39 +0000 |
| commit | ac756e88583e21c60b56b52b34957f1908f9167f (patch) | |
| tree | 0a5e053f96cd3aedf9f164ccc3811e8a06626d51 /SQL/mysql.update.sql | |
| parent | be5133a6f3ec4da11f0a6f972700bf4b256d410c (diff) | |
- fix add index
Diffstat (limited to 'SQL/mysql.update.sql')
| -rw-r--r-- | SQL/mysql.update.sql | 2 |
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 */; |