[Sommaire] [Imprimer]

   1  UPDATE ezsite_data SET value='3.4.2' WHERE name='ezpublish-version';
   2  UPDATE ezsite_data SET value='9' WHERE name='ezpublish-release';
   3  
   4  -- Fix typos in the indexes creation queries.
   5  DROP   INDEX ezproductcollection_item_contentobject_id ON
   6               ezproductcollection_item;                 
   7  CREATE INDEX ezproductcollection_item_contentobject_id ON
   8               ezproductcollection_item (contentobject_id);
   9  
  10  DROP INDEX ezsubtree_notification_rule_id ON ezsubtree_notification_rule;
  11  
  12  -- Fix faulty index on ezurl_object_link
  13  ALTER TABLE ezurl_object_link DROP PRIMARY KEY;
  14  CREATE INDEX ezurl_ol_url_id ON ezurl_object_link (url_id);
  15  CREATE INDEX ezurl_ol_coa_id ON ezurl_object_link (contentobject_attribute_id);
  16  CREATE INDEX ezurl_ol_coa_version ON ezurl_object_link (contentobject_attribute_version);
  17  
  18  -- Fix bug in cache-block, ezsubtree_exipry
  19  DELETE FROM ezsubtree_expiry;
  20  ALTER TABLE ezsubtree_expiry CHANGE subtree subtree INT(11);
  21  
  22  -- Create index for path_identification_string
  23  CREATE INDEX ezcontentobject_tree_path_ident ON ezcontentobject_tree (path_identification_string(50));