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

sql/cms_page.sql
---

diff --git a/sql/cms_page.sql b/sql/cms_page.sql
index 800edf1b..41ea9178 100644
--- a/sql/cms_page.sql
+++ b/sql/cms_page.sql
@@ -72,12 +72,6 @@ ALTER TABLE cms_page ADD COLUMN tpl_name VARCHAR(45) NULL DEFAULT NULL;
 
 ALTER TABLE cms_page ADD COLUMN target_url VARCHAR(128)  NOT NULL DEFAULT '';
 
--- drop indexes
-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 ADD COLUMN tree_sequence INT(11) NOT NULL DEFAULT 0;
 
 ALTER TABLE cms_page ADD COLUMN page_cls TEXT NOT NULL DEFAULT '';
@@ -91,3 +85,15 @@ ALTER TABLE cms_page CHANGE COLUMN menu_page_id menu_page_id INT(11)  NOT NULL
 ALTER TABLE cms_page CHANGE COLUMN template_id template_id INT(11)  NOT NULL  DEFAULT 0;
 ALTER TABLE cms_page CHANGE COLUMN element_id element_id INT(11)  NOT NULL  DEFAULT 0;
 ALTER TABLE cms_page CHANGE COLUMN category_page_id category_page_id INT(11)  NOT NULL  DEFAULT 0;
+
+
+
+-- drop indexes
+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);
+
+