From: Alan Knowles <alan@roojs.com>
Date: Wed, 3 Oct 2018 03:48:18 +0000 (+0800)
Subject: sql/cms_page.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Cms;a=commitdiff_plain;h=b778d44133a8d7cf99fe1e3bc8a7cd5fdc8948d4

sql/cms_page.sql
---

diff --git a/sql/cms_page.sql b/sql/cms_page.sql
index 41ea9178..00d12375 100644
--- 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);