[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  -- incrementing size of 'sort_key_string' to 255 characters
   5  ALTER TABLE ezcontentobject_attribute MODIFY sort_key_string VARCHAR(255) NOT NULL default '';
   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;