2 CREATE TABLE cms_category_type (
3 id int(11) NOT NULL AUTO_INCREMENT,
4 name varchar(64) NOT NULL DEFAULT '',
8 CREATE TABLE cms_page (
9 id int(11) NOT NULL AUTO_INCREMENT,
10 title varchar(200) NOT NULL DEFAULT '',
13 comments_no int(11) NOT NULL DEFAULT '0',
14 trackbacks_no int(11) NOT NULL DEFAULT '0',
16 has_extended int(1) NOT NULL DEFAULT 0,
17 author_id int(11) NOT NULL DEFAULT 0,
18 category_id int(11) NOT NULL DEFAULT 0,
19 is_draft int(1) NOT NULL DEFAULT 0,
20 updated datetime NOT NULL,
21 created DATETIME NOT NULL,
22 to_replace_id int(11) NOT NULL DEFAULT 0,
23 page_link varchar(128) NOT NULL DEFAULT '',
24 keywords varchar(200) NOT NULL DEFAULT '',
25 descriptions varchar(200) NOT NULL DEFAULT '',
26 in_rss int(1) NOT NULL DEFAULT 0,
27 parent_id int(11) NOT NULL DEFAULT 0,
31 ALTER TABLE cms_page ADD COLUMN language VARCHAR(8) NOT NULL DEFAULT '';
32 ALTER TABLE cms_page ADD COLUMN keywords text NOT NULL;
33 ALTER TABLE cms_page ADD COLUMN descriptions text NOT NULL;
35 ALTER TABLE cms_page ADD COLUMN is_attachment INT(2) NOT NULL DEFAULT 0;
36 ALTER TABLE cms_page ADD COLUMN is_menuitem INT(2) NOT NULL DEFAULT 0;
37 ALTER TABLE cms_page ADD COLUMN menu_page_id INT(11) NOT NULL DEFAULT 0;
38 ALTER TABLE cms_page ADD COLUMN template_id INT(11) NOT NULL DEFAULT 0;
39 ALTER TABLE cms_page ADD COLUMN element_id INT(11) NOT NULL DEFAULT 0;
40 ALTER TABLE cms_page ADD COLUMN category_type_id INT(11) NOT NULL DEFAULT 0;
42 ALTER TABLE cms_page ADD COLUMN page_type_id INT(11) NOT NULL DEFAULT 0;
43 ALTER TABLE cms_page ADD COLUMN translation_of_id INT(11) NOT NULL DEFAULT 0;
44 ALTER TABLE cms_page ADD COLUMN is_system_page INT(2) NOT NULL DEFAULT 0;
45 ALTER TABLE cms_page ADD COLUMN is_static INT(2) NOT NULL DEFAULT 0;
46 ALTER TABLE cms_page ADD COLUMN seq_id INT(2) NOT NULL DEFAULT 0;
48 ALTER TABLE cms_page ADD COLUMN category_page_id INT(11) NOT NULL DEFAULT 0;
49 ALTER TABLE cms_page ADD COLUMN is_deleted INT(2) NOT NULL DEFAULT 0;
51 ALTER TABLE cms_page ADD COLUMN extra_css LONGTEXT;
57 -- this is postgres?!?
58 -- ALTER TABLE cms_page ALTER keywords type TEXT;
60 ALTER TABLE cms_page CHANGE COLUMN parent_id parent_id int(11) NOT NULL DEFAULT 0;
61 ALTER TABLE cms_page CHANGE COLUMN page_type_id page_type_id INT(11) NOT NULL DEFAULT 0;
69 ALTER TABLE cms_page ADD COLUMN is_element INT(1) DEFAULT 0;
70 ALTER TABLE cms_page ADD COLUMN tpl_name VARCHAR(45) NULL DEFAULT NULL;
73 ALTER TABLE cms_page ADD COLUMN target_url VARCHAR(128) NOT NULL DEFAULT '';
76 ALTER TABLE cms_page DROP INDEX elookup;
78 -- create valid ones that work..
79 alter table cms_page add index entry_short (title,body(254),extended(254));
81 ALTER TABLE cms_page ADD COLUMN tree_sequence INT(11) NOT NULL DEFAULT 0;
83 ALTER TABLE cms_page ADD COLUMN page_cls TEXT NOT NULL DEFAULT '';
85 ALTER TABLE cms_page ADD COLUMN tree_depth INT(11) NOT NULL DEFAULT 0;
88 ALTER TABLE cms_page CHANGE COLUMN is_attachment is_attachment INT(2) NOT NULL DEFAULT 0;
89 ALTER TABLE cms_page CHANGE COLUMN is_menuitem is_menuitem INT(2) NOT NULL DEFAULT 0;
90 ALTER TABLE cms_page CHANGE COLUMN menu_page_id menu_page_id INT(11) NOT NULL DEFAULT 0;
91 ALTER TABLE cms_page CHANGE COLUMN template_id template_id INT(11) NOT NULL DEFAULT 0;
92 ALTER TABLE cms_page CHANGE COLUMN element_id element_id INT(11) NOT NULL DEFAULT 0;
93 ALTER TABLE cms_page CHANGE COLUMN category_page_id category_page_id INT(11) NOT NULL DEFAULT 0;