summaryrefslogtreecommitdiff
path: root/db/08to09_pg.sql
diff options
context:
space:
mode:
Diffstat (limited to 'db/08to09_pg.sql')
-rw-r--r--db/08to09_pg.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/db/08to09_pg.sql b/db/08to09_pg.sql
index 197fcabfd..956c4dee5 100644
--- a/db/08to09_pg.sql
+++ b/db/08to09_pg.sql
@@ -48,3 +48,6 @@ create table login_token (
constraint primary key (user_id)
);
+alter table fave
+ drop index fave_user_id_idx,
+ add index fave_user_id_idx using btree(user_id,modified);