sql/cms_page.sql

diff --git a/sql/cms_page.sql b/sql/cms_page.sql
index 800edf1..41ea917 100644 (file)
--- 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);
+
+