Changed to StatusNet consistent terminology

[quix0rs-gnu-social.git] / db / statusnet_pg.sql

diff --git a/db/statusnet_pg.sql b/db/statusnet_pg.sql
index 392a6a5f3c29fada0afa2dec63e7671999fe7278..7b0e5313ceac86560de1953612a772180c7e038a 100644 (file)
--- 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 (