From b778d44133a8d7cf99fe1e3bc8a7cd5fdc8948d4 Mon Sep 17 00:00:00 2001
From: Alan Knowles <alan@roojs.com>
Date: Wed, 3 Oct 2018 11:48:18 +0800
Subject: [PATCH] sql/cms_page.sql

---
 sql/cms_page.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

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);
 
 
-- 
2.39.2