X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=DataObjects%2Fcore.sql;h=c1c60d83531855121d33e93521c34277cf53bfb9;hp=8c5ed4b2373b162fee24529340eb9676f425c9a5;hb=07c59bd70f6d6925351d8034513a8f63dadfa31e;hpb=3066bd3d21112e09285d9e06dcfd115d10013b10 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;