summaryrefslogtreecommitdiff
path: root/SQL/sqlite.initial.sql
diff options
context:
space:
mode:
authoralecpl <alec@alec.pl>2010-03-06 14:13:25 +0000
committeralecpl <alec@alec.pl>2010-03-06 14:13:25 +0000
commit94fe9ca1a87b20ddeee55024986e95ca72097af6 (patch)
treec991134bf8f7cf1d98cf7230d7e67d3a23269f37 /SQL/sqlite.initial.sql
parent1163db99d45baa33894d70f53d93c3783c8e9d27 (diff)
- re-fix (#1486474) + require MySQL 4.0.8 + add index/update in identities table
Diffstat (limited to 'SQL/sqlite.initial.sql')
-rw-r--r--SQL/sqlite.initial.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/SQL/sqlite.initial.sql b/SQL/sqlite.initial.sql
index cccad7a20..30546bbb2 100644
--- a/SQL/sqlite.initial.sql
+++ b/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);
-- --------------------------------------------------------