summaryrefslogtreecommitdiff
path: root/roundcubemail/SQL/sqlite.initial.sql
diff options
context:
space:
mode:
authoralec <alec@208e9e7b-5314-0410-a742-e7e81cd9613c>2010-03-06 14:13:25 +0000
committeralec <alec@208e9e7b-5314-0410-a742-e7e81cd9613c>2010-03-06 14:13:25 +0000
commit142417c4b3a85c755cb0735577d81e6234f1173e (patch)
tree2828ad056b85d6b70be0455291d47e08b148eed6 /roundcubemail/SQL/sqlite.initial.sql
parentb0764498e73b1ff9e1a9e86d7998b43eed1f8045 (diff)
- re-fix (#1486474) + require MySQL 4.0.8 + add index/update in identities table
git-svn-id: https://svn.roundcube.net/trunk@3333 208e9e7b-5314-0410-a742-e7e81cd9613c
Diffstat (limited to 'roundcubemail/SQL/sqlite.initial.sql')
-rw-r--r--roundcubemail/SQL/sqlite.initial.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/roundcubemail/SQL/sqlite.initial.sql b/roundcubemail/SQL/sqlite.initial.sql
index cccad7a20..30546bbb2 100644
--- a/roundcubemail/SQL/sqlite.initial.sql
+++ b/roundcubemail/SQL/sqlite.initial.sql
@@ -56,7 +56,7 @@ CREATE TABLE identities (
html_signature tinyint NOT NULL default '0'
);
-CREATE INDEX ix_identities_user_id ON identities(user_id);
+CREATE INDEX ix_identities_user_id ON identities(user_id, del);
-- --------------------------------------------------------