[Sommaire] [Imprimer]

   1  UPDATE ezsite_data SET value='3.4.0' WHERE name='ezpublish-version';
   2  UPDATE ezsite_data SET value='7' WHERE name='ezpublish-release';
   3  
   4  -- NOTE: This file will be generated from all the development releases, do not add entries
   5  
   6  -- 3.3.3 to 3.4.0alpha1
   7  
   8  -- 
   9  -- Update ContentObjectTreeNode to store latest modified subnode value.
  10  --
  11  
  12  -- 
  13  -- Update ContentObjectTreeNode to store latest modified subnode value.
  14  --
  15  
  16  CREATE TABLE tmp_ezcontentobject_tree (
  17    node_id int(11) NOT NULL,
  18    modified_subnode int NOT NULL
  19  );
  20  
  21  CREATE INDEX idx_modified_obj on ezcontentobject( modified DESC );
  22  CREATE INDEX idx_pat_string_obj on ezcontentobject_tree( path_string );
  23  
  24  INSERT INTO tmp_ezcontentobject_tree ( node_id, modified_subnode )
  25         SELECT tree.node_id, max( obj.modified )
  26         FROM ezcontentobject_tree as subtree, ezcontentobject_tree as tree,  ezcontentobject as obj
  27         WHERE obj.id = subtree.contentobject_id AND
  28               subtree.path_string like concat( tree.path_string, '%')
  29         GROUP BY tree.node_id;
  30  
  31  CREATE TABLE tmp2_ezcontentobject_tree AS
  32   SELECT ezcontentobject_tree.*, tmp_ezcontentobject_tree.modified_subnode
  33    FROM  ezcontentobject_tree, tmp_ezcontentobject_tree
  34    WHERE ezcontentobject_tree.node_id=tmp_ezcontentobject_tree.node_id;
  35  
  36  DELETE FROM ezcontentobject_tree;
  37  
  38  ALTER TABLE ezcontentobject_tree ADD COLUMN modified_subnode int NOT NULL default 0, ADD INDEX (modified_subnode);
  39  
  40  INSERT INTO ezcontentobject_tree SELECT * FROM tmp2_ezcontentobject_tree;
  41  
  42  DROP TABLE tmp2_ezcontentobject_tree;
  43  
  44  DROP TABLE tmp_ezcontentobject_tree;
  45  
  46  DROP INDEX idx_modified_obj on ezcontentobject;
  47  DROP INDEX idx_pat_string_obj on ezcontentobject_tree;
  48  
  49  --
  50  --  Optimization and extending of role system.
  51  --
  52  
  53  ALTER TABLE ezuser_role ADD COLUMN limit_identifier varchar(255) default '';
  54  ALTER TABLE ezuser_role ADD COLUMN limit_value varchar(255) default '';
  55  
  56  ALTER TABLE ezpolicy DROP COLUMN limitation;
  57  
  58  ALTER TABLE ezpolicy_limitation DROP COLUMN role_id;
  59  ALTER TABLE ezpolicy_limitation DROP COLUMN function_name;
  60  ALTER TABLE ezpolicy_limitation DROP COLUMN module_name;
  61  
  62  CREATE INDEX ezuser_role_role_id ON ezuser_role ( role_id );
  63  
  64  -- 3.4.0alpha1 to 3.4.0alpha2
  65  
  66  
  67  ---
  68  --- Add session ID to user object
  69  ---
  70  
  71  CREATE TABLE ezuser_session_link (
  72    user_id int(11) NOT NULL,
  73    session_key varchar(32) NOT NULL,
  74    PRIMARY KEY( user_id, session_key )
  75  );
  76  CREATE INDEX ezuser_session_link_user_idx on ezuser_session_link ( user_id );
  77  CREATE INDEX ezuser_session_link_session_idx on ezuser_session_link ( session_key );
  78  
  79  
  80  CREATE INDEX ezpreferences_user_id_idx on ezpreferences ( user_id, name );
  81  
  82  
  83  ALTER  TABLE ezorder ADD COLUMN email varchar(150) NOT NULL default '';
  84  --- 
  85  --- Run script update/common/scripts/addorderemail.php after this change to
  86  --- insert correct email for existing orders.
  87  ---
  88  
  89  
  90  CREATE TABLE ezsubtree_expiry (
  91    subtree varchar(255) NOT NULL default '',
  92    cache_file varchar(255) NOT NULL default '',
  93    KEY ezsubtree_expiry_subtree (subtree)
  94  ) DELAY_KEY_WRITE=1 TYPE=MyISAM;
  95  
  96  
  97  CREATE TABLE ezpending_actions (
  98    action varchar(64) NOT NULL,
  99    param text,
 100    KEY ezpending_actions_action (action)
 101  ) TYPE=MyISAM;
 102  
 103  
 104  -- Change text fields to longtext
 105  ALTER TABLE ezcollab_item CHANGE COLUMN data_text1 data_text1 longtext NOT NULL ;
 106  ALTER TABLE ezcollab_item CHANGE COLUMN data_text2 data_text2 longtext NOT NULL ;
 107  ALTER TABLE ezcollab_item CHANGE COLUMN data_text3 data_text3 longtext NOT NULL ;
 108  ALTER TABLE ezcollab_profile CHANGE COLUMN data_text1 data_text1 longtext NOT NULL ;
 109  ALTER TABLE ezcollab_simple_message CHANGE COLUMN data_text1 data_text1 longtext NOT NULL ;
 110  ALTER TABLE ezcollab_simple_message CHANGE COLUMN data_text2 data_text2 longtext NOT NULL ;
 111  ALTER TABLE ezcollab_simple_message CHANGE COLUMN data_text3 data_text3 longtext NOT NULL ;
 112  ALTER TABLE ezcontentclass_attribute CHANGE COLUMN data_text5 data_text5 longtext ;
 113  ALTER TABLE ezcontentobject_attribute CHANGE COLUMN data_text data_text longtext ;
 114  ALTER TABLE ezcontentobject_tree CHANGE COLUMN path_identification_string path_identification_string longtext ;
 115  ALTER TABLE ezinfocollection_attribute CHANGE COLUMN data_text data_text longtext ;
 116  ALTER TABLE ezmessage CHANGE COLUMN body body longtext ;
 117  ALTER TABLE ezmodule_run CHANGE COLUMN module_data module_data longtext ;
 118  ALTER TABLE eznotificationcollection CHANGE COLUMN data_subject data_subject longtext NOT NULL ;
 119  ALTER TABLE eznotificationcollection CHANGE COLUMN data_text data_text longtext NOT NULL ;
 120  ALTER TABLE eznotificationevent CHANGE COLUMN data_text1 data_text1 longtext NOT NULL ;
 121  ALTER TABLE eznotificationevent CHANGE COLUMN data_text2 data_text2 longtext NOT NULL ;
 122  ALTER TABLE eznotificationevent CHANGE COLUMN data_text3 data_text3 longtext NOT NULL ;
 123  ALTER TABLE eznotificationevent CHANGE COLUMN data_text4 data_text4 longtext NOT NULL ;
 124  ALTER TABLE ezoperation_memento CHANGE COLUMN memento_data memento_data longtext NOT NULL ;
 125  ALTER TABLE ezorder CHANGE COLUMN data_text_2 data_text_2 longtext ;
 126  ALTER TABLE ezorder CHANGE COLUMN data_text_1 data_text_1 longtext ;
 127  ALTER TABLE ezpdf_export CHANGE COLUMN intro_text intro_text longtext ;
 128  ALTER TABLE ezpdf_export CHANGE COLUMN sub_text sub_text longtext ;
 129  ALTER TABLE ezpending_actions CHANGE COLUMN param param longtext ;
 130  ALTER TABLE ezrss_export CHANGE COLUMN description description longtext ;
 131  ALTER TABLE ezrss_import CHANGE COLUMN url url longtext ;
 132  ALTER TABLE ezsession CHANGE COLUMN data data longtext NOT NULL ;
 133  ALTER TABLE ezsite_data CHANGE COLUMN value value longtext NOT NULL ;
 134  ALTER TABLE ezurlalias CHANGE COLUMN source_url source_url longtext NOT NULL ;
 135  ALTER TABLE ezurlalias CHANGE COLUMN destination_url destination_url longtext NOT NULL ;
 136  ALTER TABLE ezworkflow_process CHANGE COLUMN parameters parameters longtext ;
 137  ALTER TABLE ezimagefile CHANGE COLUMN filepath filepath longtext NOT NULL ;
 138  
 139  -- Change NULL and size for some fields
 140  ALTER TABLE ezcontentobject_attribute CHANGE COLUMN sort_key_string sort_key_string varchar(50) DEFAULT '' ;
 141  ALTER TABLE ezcontentobject_attribute CHANGE COLUMN data_type_string data_type_string varchar(50) DEFAULT '' ;
 142  ALTER TABLE ezorder CHANGE COLUMN email email varchar(150) DEFAULT '' ;
 143  ALTER TABLE ezproductcollection_item CHANGE COLUMN price price float DEFAULT '0' ;
 144  
 145  ALTER TABLE ezcontentclass_attribute CHANGE COLUMN is_searchable is_searchable int(11) NOT NULL DEFAULT '0' ;
 146  ALTER TABLE ezcontentclass_attribute CHANGE COLUMN is_required is_required int(11) NOT NULL DEFAULT '0' ;
 147  ALTER TABLE ezcontentobject_tree CHANGE COLUMN sort_order sort_order int(11) DEFAULT '1' ;
 148  ALTER TABLE ezcontentobject_tree CHANGE COLUMN modified_subnode modified_subnode int(11) DEFAULT '0' ;
 149  ALTER TABLE ezcontentobject_version CHANGE COLUMN workflow_event_pos workflow_event_pos int(11) DEFAULT '0' ;
 150  ALTER TABLE ezdiscountsubrule_value CHANGE COLUMN issection issection int(11) NOT NULL DEFAULT '0' ;
 151  ALTER TABLE ezinfocollection CHANGE COLUMN modified modified int(11) DEFAULT '0' ;
 152  ALTER TABLE ezmedia CHANGE COLUMN has_controller has_controller int(11) DEFAULT '0' ;
 153  ALTER TABLE ezmedia CHANGE COLUMN is_autoplay is_autoplay int(11) DEFAULT '0' ;
 154  ALTER TABLE ezmedia CHANGE COLUMN is_loop is_loop int(11) DEFAULT '0' ;
 155  ALTER TABLE ezmessage CHANGE COLUMN is_sent is_sent int(11) NOT NULL DEFAULT '0' ;
 156  ALTER TABLE eznode_assignment CHANGE COLUMN sort_order sort_order int(11) DEFAULT '1' ;
 157  ALTER TABLE ezuser_setting CHANGE COLUMN is_enabled is_enabled int(11) NOT NULL DEFAULT '0' ;
 158  ALTER TABLE ezworkflow CHANGE COLUMN is_enabled is_enabled int(11) NOT NULL DEFAULT '0' ;
 159  ALTER TABLE ezworkflow_assign CHANGE COLUMN as_tree as_tree int(11) NOT NULL DEFAULT '0' ;
 160  
 161  
 162  -- 3.4.0alpha2 to 3.4.0alpha3
 163  
 164  
 165  ALTER TABLE ezcontentclass ADD COLUMN remote_id varchar(100) NOT NULL default '';
 166  ALTER TABLE ezcontentobject_tree ADD COLUMN remote_id varchar(100) NOT NULL default '';
 167  
 168  ALTER TABLE eznode_assignment ADD COLUMN parent_remote_id varchar(100) NOT NULL default '';
 169  
 170  CREATE TABLE tmp_ezsession AS
 171  SELECT ezsession.*, ezuser_session_link.user_id FROM ezsession, ezuser_session_link
 172   WHERE ezsession.session_key=ezuser_session_link.session_key;
 173  
 174  DELETE FROM ezsession;
 175  
 176  ALTER TABLE ezsession ADD COLUMN user_id integer NOT NULL default 0;
 177  
 178  INSERT INTO ezsession SELECT * FROM tmp_ezsession;
 179  
 180  CREATE INDEX ezsession_user_id ON ezsession ( user_id );
 181  
 182  DROP TABLE tmp_ezsession;
 183  
 184  DROP TABLE ezuser_session_link;
 185  
 186  
 187  -- 3.4.0alpha3 to 3.4.0alpha4
 188  
 189  -- 3.4.0alpha4 to 3.4.0beta1
 190  
 191  -- 3.4.0beta1 to 3.4.0beta2
 192  
 193  -- 3.4.0beta2 to 3.4.0
 194  
 195  -- incrementing size of 'sort_key_string' to 255 characters
 196  ALTER TABLE ezcontentobject_attribute MODIFY sort_key_string VARCHAR(255) NOT NULL default '';
 197  -- cleans up ezcontentbrowsebookmark and ezcontentbrowserecent tables from corrupted node_id's
 198  
 199  CREATE TABLE ezcontentbrowsebookmark_temp AS
 200    SELECT ezcontentbrowsebookmark.* FROM ezcontentbrowsebookmark,ezcontentobject_tree 
 201      WHERE ezcontentbrowsebookmark.node_id = ezcontentobject_tree.node_id;
 202  DELETE FROM ezcontentbrowsebookmark;
 203  INSERT INTO ezcontentbrowsebookmark SELECT * FROM ezcontentbrowsebookmark_temp;
 204  DROP TABLE ezcontentbrowsebookmark_temp;
 205  
 206  CREATE TABLE ezcontentbrowserecent_temp AS
 207    SELECT ezcontentbrowserecent.* from ezcontentbrowserecent,ezcontentobject_tree 
 208      WHERE ezcontentbrowserecent.node_id = ezcontentobject_tree.node_id;
 209  DELETE FROM ezcontentbrowserecent;
 210  INSERT INTO ezcontentbrowserecent SELECT * FROM ezcontentbrowserecent_temp;
 211  DROP TABLE ezcontentbrowserecent_temp;
 212