[Sommaire] [Imprimer]

   1  UPDATE ezsite_data SET value='6' WHERE name='ezpublish-release';
   2  
   3  -- incrementing size of 'sort_key_string' to 255 characters
   4  ALTER TABLE ezcontentobject_attribute MODIFY sort_key_string VARCHAR(255) NOT NULL default '';
   5  
   6  -- cleans up ezcontentbrowsebookmark and ezcontentbrowserecent tables from corrupted node_id's
   7  
   8  create temporary  table ezcontentbrowsebookmark_temp as 
   9        select  ezcontentbrowsebookmark.* from ezcontentbrowsebookmark,ezcontentobject_tree 
  10        where  ezcontentbrowsebookmark.node_id = ezcontentobject_tree.node_id;
  11  delete from ezcontentbrowsebookmark;
  12  insert into ezcontentbrowsebookmark select * from ezcontentbrowsebookmark_temp;
  13  
  14  create temporary  table ezcontentbrowserecent_temp as 
  15        select  ezcontentbrowserecent.* from ezcontentbrowserecent,ezcontentobject_tree 
  16        where  ezcontentbrowserecent.node_id = ezcontentobject_tree.node_id;
  17  delete from ezcontentbrowserecent;
  18  insert into ezcontentbrowserecent select * from ezcontentbrowserecent_temp;
  19  
  20  -- fixes for schemas in packages, they did not have 100% similarity with the kernel_schema
  21  ALTER TABLE ezcontentobject_attribute MODIFY data_type_string VARCHAR(50) default '';
  22  ALTER TABLE ezproductcollection_item DROP INDEX ezproductcollection_item_contentobject_id;
  23  ALTER TABLE ezproductcollection_item ADD INDEX ezproductcollection_item_contentobject_id ( contentobject_id );
  24  ALTER TABLE ezsubtree_notification_rule DROP INDEX ezsubtree_notification_rule_id;
  25  ALTER TABLE ezurlalias CHANGE COLUMN is_wildcard is_wildcard int(11) NOT NULL DEFAULT '0' ;