sql/cms_page.sql

diff --git a/sql/cms_page.sql b/sql/cms_page.sql
index 41ea917..00d1237 100644 (file)
--- a/sql/cms_page.sql
+++ b/sql/cms_page.sql
@@ -94,6 +94,6 @@ ALTER TABLE cms_page DROP INDEX elookup;
 -- create valid ones that work..
 -- alter table  cms_page add index entry_short (title,body(254),extended(254));
 alter table  cms_page drop index entry_short;
-alter table  cms_page add index lookup_title (title);
+alter table  cms_page add index lookup_a (title,language,is_attachment,is_menuitem,category_type_id,translation_of_id,page_type_id,seq_id,is_deleted);