From 0dac70d010ae6a4769af35a3aab9fd70e420f525 Mon Sep 17 00:00:00 2001
From: Mike Cochrane <mikec@mikenz.geek.nz>
Date: Tue, 22 Jul 2008 16:53:35 -0400
Subject: Index on the correct column

darcs-hash:20080722205335-533db-d7b4a6c727305cffedc443b5bfa15779a685d03a.gz
---
 db/laconica.sql | 3 +--
 1 file changed, 1 insertion(+), 2 deletions(-)

(limited to 'db/laconica.sql')

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;
 
-- 
cgit v1.2.3-54-g00ecf