diff options
Diffstat (limited to 'db/statusnet_pg.sql')
| -rw-r--r-- | db/statusnet_pg.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/db/statusnet_pg.sql b/db/statusnet_pg.sql index 710883e57..392a6a5f3 100644 --- a/db/statusnet_pg.sql +++ b/db/statusnet_pg.sql @@ -115,8 +115,8 @@ create table subscription ( primary key (subscriber, subscribed) ); -create index subscription_subscriber_idx on subscription using btree(subscriber); -create index subscription_subscribed_idx on subscription using btree(subscribed); +create index subscription_subscriber_idx on subscription using btree(subscriber,created); +create index subscription_subscribed_idx on subscription using btree(subscribed,created); create sequence notice_seq; create table notice ( |