From 0dac70d010ae6a4769af35a3aab9fd70e420f525 Mon Sep 17 00:00:00 2001 From: Mike Cochrane Date: Tue, 22 Jul 2008 16:53:35 -0400 Subject: [PATCH] Index on the correct column darcs-hash:20080722205335-533db-d7b4a6c727305cffedc443b5bfa15779a685d03a.gz --- db/laconica.sql | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) diff --git a/db/laconica.sql b/db/laconica.sql index ae5184778e..5869297cc4 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; -- 2.39.5