diff options
| author | Evan Prodromou <evan@status.net> | 2009-11-14 17:14:35 +0100 |
|---|---|---|
| committer | Evan Prodromou <evan@status.net> | 2009-11-14 17:14:35 +0100 |
| commit | 959d278c347fdf90e0227adc57c0215f5d82404a (patch) | |
| tree | 16eb3b0155b446ada520566e187b4c47b0b9e76b /db/statusnet_pg.sql | |
| parent | 093857c582a68b39e0d65523d27f25ede7b7fed6 (diff) | |
| parent | 2147ac510f5489c860a4bebf3ab48a069b89ecfb (diff) | |
Merge branch '0.9.x' of git@gitorious.org:statusnet/mainline into 0.9.x
Diffstat (limited to 'db/statusnet_pg.sql')
| -rw-r--r-- | db/statusnet_pg.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/db/statusnet_pg.sql b/db/statusnet_pg.sql index 392a6a5f3..7b0e5313c 100644 --- a/db/statusnet_pg.sql +++ b/db/statusnet_pg.sql @@ -137,7 +137,7 @@ create table notice ( /* FULLTEXT(content) */ ); -create index notice_profile_id_idx on notice using btree(profile_id); +create index notice_profile_id_idx on notice using btree(profile_id,created,id); create index notice_created_idx on notice using btree(created); create table notice_source ( |