projects
/
Pman.Cms
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
919f609
)
sql/cms_page.sql
author
Alan Knowles
<alan@roojs.com>
Wed, 3 Oct 2018 03:46:55 +0000
(11:46 +0800)
committer
Alan Knowles
<alan@roojs.com>
Wed, 3 Oct 2018 03:46:55 +0000
(11:46 +0800)
sql/cms_page.sql
patch
|
blob
|
history
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 '';
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 '';
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;
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);
+
+