[Sommaire] [Imprimer]

   1  UPDATE ezsite_data SET value='3.9.0' WHERE name='ezpublish-version';
   2  UPDATE ezsite_data SET value='5' WHERE name='ezpublish-release';
   3  
   4  -- START: from 3.8.1
   5  CREATE INDEX ezkeyword_keyword_id ON ezkeyword ( keyword, id );
   6  CREATE INDEX ezkeyword_attr_link_kid_oaid ON ezkeyword_attribute_link ( keyword_id, objectattribute_id );
   7  
   8  CREATE INDEX ezurlalias_is_wildcard ON ezurlalias( is_wildcard );
   9  
  10  CREATE INDEX eznode_assignment_coid_cov ON eznode_assignment( contentobject_id,contentobject_version );
  11  CREATE INDEX eznode_assignment_is_main ON eznode_assignment( is_main );
  12  CREATE INDEX eznode_assignment_parent_node ON eznode_assignment( parent_node );
  13  -- END: from 3.8.1
  14  
  15  ALTER TABLE ezuservisit ADD COLUMN failed_login_attempts int NOT NULL DEFAULT 0;
  16  
  17  ALTER TABLE ezcontentobject_link ADD COLUMN relation_type int NOT NULL DEFAULT 1;
  18  UPDATE ezcontentobject_link SET relation_type=8 WHERE contentclassattribute_id<>0;
  19  
  20  -- START: 'default sorting' attribute for ezcontentclass
  21  ALTER TABLE ezcontentclass ADD COLUMN sort_field int NOT NULL DEFAULT 1;
  22  ALTER TABLE ezcontentclass ADD COLUMN sort_order int NOT NULL DEFAULT 1;
  23  -- END: 'default sorting' attribute for ezcontentclass
  24  
  25  -- START: new table for trash
  26  CREATE TABLE ezcontentobject_trash (
  27    contentobject_id int(11) default NULL,
  28    contentobject_version int(11) default NULL,
  29    depth int(11) NOT NULL default '0',
  30    is_hidden int(11) NOT NULL default '0',
  31    is_invisible int(11) NOT NULL default '0',
  32    main_node_id int(11) default NULL,
  33    modified_subnode int(11) default '0',
  34    node_id int(11) NOT NULL,
  35    parent_node_id int(11) NOT NULL default '0',
  36    path_identification_string longtext,
  37    path_string varchar(255) NOT NULL default '',
  38    priority int(11) NOT NULL default '0',
  39    remote_id varchar(100) NOT NULL default '',
  40    sort_field int(11) default '1',
  41    sort_order int(11) default '1',
  42    PRIMARY KEY  (node_id)
  43  );
  44  ALTER TABLE ezcontentobject_trash ADD INDEX ezcobj_trash_co_id (contentobject_id);
  45  ALTER TABLE ezcontentobject_trash ADD INDEX ezcobj_trash_depth (depth);
  46  ALTER TABLE ezcontentobject_trash ADD INDEX ezcobj_trash_p_node_id (parent_node_id);
  47  ALTER TABLE ezcontentobject_trash ADD INDEX ezcobj_trash_path (path_string);
  48  ALTER TABLE ezcontentobject_trash ADD INDEX ezcobj_trash_path_ident (path_identification_string(50));
  49  ALTER TABLE ezcontentobject_trash ADD INDEX ezcobj_trash_modified_subnode (modified_subnode);
  50  -- END: new table for trash
  51  
  52  -- START: ezcontentclass/ezcontentclass_attribute translations
  53  ALTER TABLE ezcontentclass CHANGE name serialized_name_list varchar(255) default NULL;
  54  ALTER TABLE ezcontentclass ADD COLUMN language_mask int NOT NULL DEFAULT 0;
  55  ALTER TABLE ezcontentclass ADD COLUMN initial_language_id int NOT NULL DEFAULT 0;
  56  ALTER TABLE ezcontentclass_attribute CHANGE name serialized_name_list varchar(255) NOT NULL default '';
  57  
  58  CREATE TABLE ezcontentclass_name
  59  (
  60      contentclass_id int NOT NULL default '0',
  61      contentclass_version int NOT NULL default '0',
  62      language_locale varchar(20) NOT NULL default '',
  63      language_id int NOT NULL default '0',
  64      name varchar(255) NOT NULL default '',
  65      PRIMARY KEY (contentclass_id, contentclass_version, language_id)
  66  );
  67  -- END: ezcontentclass/ezcontentclass_attribute translations
  68  
  69  -- START: eztipafriend_counter, new column and primary key (new fetch function for tipafriend_top_list)
  70  ALTER TABLE eztipafriend_counter ADD COLUMN requested int NOT NULL DEFAULT 0;
  71  ALTER TABLE eztipafriend_counter DROP PRIMARY KEY;
  72  ALTER TABLE eztipafriend_counter ADD PRIMARY KEY (node_id, requested);
  73  -- END: eztipafriend_counter, new column and primary key (new fetch function for tipafriend_top_list)
  74  
  75  -- START: improvements in shop(better vat handling of order items, like shipping)
  76  ALTER TABLE ezorder_item ADD COLUMN is_vat_inc int default '0' NOT NULL;
  77  -- END: improvements in shop(better vat handling of order items, like shipping)
  78  
  79  -- START: from 3.8.5
  80  -- ezcontentobject
  81  CREATE INDEX ezcontentobject_pub ON ezcontentobject( published );
  82  CREATE INDEX ezcontentobject_status ON ezcontentobject( status );
  83  CREATE INDEX ezcontentobject_classid ON ezcontentobject( contentclass_id );
  84  CREATE INDEX ezcontentobject_currentversion ON ezcontentobject( current_version );
  85  
  86  -- ezcontentobject_name
  87  CREATE INDEX ezcontentobject_name_lang_id ON ezcontentobject_name( language_id );
  88  CREATE INDEX ezcontentobject_name_name ON ezcontentobject_name( name );
  89  CREATE INDEX ezcontentobject_name_co_id ON ezcontentobject_name( contentobject_id );
  90  CREATE INDEX ezcontentobject_name_cov_id ON ezcontentobject_name( content_version );
  91  
  92  -- ezcontentobject_version
  93  CREATE INDEX ezcobj_version_creator_id ON ezcontentobject_version( creator_id );
  94  CREATE INDEX ezcobj_version_status ON ezcontentobject_version( status );
  95  
  96  -- ezpolicy_limitation_value
  97  CREATE INDEX ezpolicy_limitation_value_val ON ezpolicy_limitation_value( value );
  98  
  99  -- ezinfocollection_attribute
 100  CREATE INDEX ezinfocollection_attr_co_id ON ezinfocollection_attribute( contentobject_id );
 101  
 102  -- ezurlalias
 103  CREATE INDEX ezurlalias_forward_to_id ON ezurlalias( forward_to_id );
 104  
 105  -- ezkeyword
 106  CREATE INDEX ezkeyword_keyword ON ezkeyword( keyword );
 107  
 108  -- ezurl
 109  CREATE INDEX ezurl_url ON ezurl( url );
 110  
 111  -- ezcontentobject_attribute
 112  CREATE INDEX ezcontentobject_attr_id ON ezcontentobject_attribute( id );
 113  
 114  -- ezcontentoclass_attribute
 115  CREATE INDEX ezcontentclass_attr_ccid ON ezcontentclass_attribute( contentclass_id );
 116  
 117  -- eznode_assignment
 118  CREATE INDEX eznode_assignment_co_id ON eznode_assignment( contentobject_id );
 119  CREATE INDEX eznode_assignment_co_version ON eznode_assignment( contentobject_version );
 120  
 121  -- ezkeyword_attribute_link
 122  CREATE INDEX ezkeyword_attr_link_keyword_id ON ezkeyword_attribute_link( keyword_id );
 123  -- END: from 3.8.5
 124  
 125  
 126  -- alter table ezsearch_return_count add key ( phrase_id, count );
 127  -- alter table ezsearch_search_phrase add key ( phrase );
 128  CREATE INDEX  ezsearch_return_cnt_new_ph_id_count  ON   ezsearch_return_count ( phrase_id, count );
 129  CREATE INDEX ezsearch_search_phrase_phr ON ezsearch_search_phrase ( phrase );
 130  
 131  CREATE TABLE `ezsearch_search_phrase_new` (
 132    `id` int(11) NOT NULL auto_increment PRIMARY KEY ,
 133    `phrase` varchar(250) default NULL,
 134    `phrase_count` int(11) default '0',
 135    `result_count` int(11) default '0'
 136  );
 137  CREATE UNIQUE INDEX ezsearch_search_phrase_phrase ON ezsearch_search_phrase_new ( phrase );
 138  CREATE INDEX ezsearch_search_phrase_count ON ezsearch_search_phrase_new ( phrase_count );
 139  
 140  
 141  INSERT INTO ezsearch_search_phrase_new ( phrase, phrase_count, result_count )
 142  SELECT   lower( phrase ), count(*), sum( ezsearch_return_count.count )
 143  FROM     ezsearch_search_phrase,
 144           ezsearch_return_count
 145  WHERE    ezsearch_search_phrase.id = ezsearch_return_count.phrase_id
 146  GROUP BY lower( ezsearch_search_phrase.phrase );
 147  
 148  -- ezsearch_return_count is of no (additional) use in a normal eZ publish installation
 149  -- but perhaps someone built something for himself, then it is not BC
 150  -- to not break BC apply the CREATE and INSERT statements
 151  
 152  CREATE TABLE `ezsearch_return_count_new` (
 153    `id` int(11) NOT NULL auto_increment   PRIMARY KEY,
 154    `phrase_id` int(11) NOT NULL default '0',
 155    `time` int(11) NOT NULL default '0',
 156    `count` int(11) NOT NULL default '0'
 157  );
 158  CREATE INDEX  ezsearch_return_cnt_ph_id_cnt  ON   ezsearch_return_count_new ( phrase_id, count );
 159  
 160  INSERT INTO `ezsearch_return_count_new` ( phrase_id, time, `count` )
 161  SELECT    ezsearch_search_phrase_new.id, time, `count`
 162  FROM      ezsearch_search_phrase,
 163            ezsearch_search_phrase_new,
 164            ezsearch_return_count
 165  WHERE     ezsearch_search_phrase_new.phrase = LOWER( ezsearch_search_phrase.phrase ) AND
 166            ezsearch_search_phrase.id = ezsearch_return_count.phrase_id;
 167  
 168  -- final tasks with and without BC
 169  DROP TABLE ezsearch_search_phrase;
 170  -- ALTER TABLE ezsearch_search_phrase RENAME TO ezsearch_search_phrase_old;
 171  ALTER TABLE ezsearch_search_phrase_new RENAME TO ezsearch_search_phrase;
 172  
 173  DROP TABLE `ezsearch_return_count`;
 174  -- ALTER TABLE ezsearch_return_count RENAME TO ezsearch_return_count_old;
 175  -- of course the next statement is only valid if you created `ezsearch_return_count_new`
 176  ALTER TABLE ezsearch_return_count_new RENAME TO ezsearch_return_count;
 177  
 178