summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--db/laconica.sql3
1 files changed, 1 insertions, 2 deletions
diff --git a/db/laconica.sql b/db/laconica.sql
index ae5184778..5869297cc 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -108,8 +108,7 @@ create table notice (
source varchar(8) comment 'source of comment, like "web", "im", or "clientname"',
index notice_profile_id_idx (profile_id),
- index notice_created_idx (profile_id),
-
+ index notice_created_idx (created),
FULLTEXT(content)
) ENGINE=MyISAM;