From 2659ce1ee18f25a8a33beeccf6172513f3b58d88 Mon Sep 17 00:00:00 2001 From: alecpl <alec@alec.pl> Date: Sat, 12 Sep 2009 03:17:28 -0400 Subject: [PATCH] - re-apply r2940 --- SQL/postgres.initial.sql | 1 + 1 files changed, 1 insertions(+), 0 deletions(-) diff --git a/SQL/postgres.initial.sql b/SQL/postgres.initial.sql index 1a21ee2..f07ca30 100644 --- a/SQL/postgres.initial.sql +++ b/SQL/postgres.initial.sql @@ -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