From: Edward <edward@roojs.com>
Date: Tue, 15 Jan 2013 02:30:52 +0000 (+0800)
Subject: DataObjects/core.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=07c59bd70f6d6925351d8034513a8f63dadfa31e

DataObjects/core.sql
---

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index 8c5ed4b2..c1c60d83 100644
--- a/DataObjects/core.sql
+++ b/DataObjects/core.sql
@@ -296,7 +296,7 @@ ALTER TABLE Images    ALTER COLUMN   mimetype mimetype  varchar(128) NOT NULL de
 
 ALTER TABLE Images ADD INDEX lookup(ontable, onid);
 
-
+ALTER TABLE Images ADD INDEX lookupc(created, ontable, onid);
  
 #// old core image type - merged into enum.
 DROP TABLE core_image_type;