From 74e5bd449f5a2fd6b42314d7c72c58d88d73b5b9 Mon Sep 17 00:00:00 2001 From: alecpl <alec@alec.pl> Date: Fri, 23 Oct 2009 13:32:05 -0400 Subject: [PATCH] - fix IE6 toolbarmenu regression (#1486195) --- SQL/postgres.initial.sql | 3 ++- 1 files changed, 2 insertions(+), 1 deletions(-) diff --git a/SQL/postgres.initial.sql b/SQL/postgres.initial.sql index 1a21ee2..a52a01f 100644 --- a/SQL/postgres.initial.sql +++ b/SQL/postgres.initial.sql @@ -110,7 +110,7 @@ vcard text ); -CREATE INDEX contacts_user_id_idx ON contacts (user_id); +CREATE INDEX contacts_user_id_idx ON contacts (user_id, email); -- -- Sequence "cache_ids" @@ -174,4 +174,5 @@ ); ALTER TABLE messages ADD UNIQUE (user_id, cache_key, uid); +CREATE INDEX messages_index_idx ON messages (user_id, cache_key, idx); CREATE INDEX messages_created_idx ON messages (created); -- Gitblit v1.9.1