From 6c95809d10fda20d522a6a09b861f20bed43ee8c Mon Sep 17 00:00:00 2001 From: alecpl <alec@alec.pl> Date: Mon, 30 Nov 2009 06:55:33 -0500 Subject: [PATCH] - don't warn about lack of plugin's config file, it's absolutely optional --- 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