[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  
   6  DROP   INDEX ezproductcollection_item_contentobject_id;
   7  CREATE INDEX ezproductcollection_item_contentobject_id ON ezproductcollection_item USING btree ( "contentobject_id" );
   8  DROP   INDEX ezsubtree_notification_rule_id;
   9  
  10  -- Fix faulty index on ezurl_object_link
  11  ALTER TABLE ezurl_object_link DROP CONSTRAINT ezurl_object_link1039_key;
  12  CREATE INDEX ezurl_ol_url_id ON ezurl_object_link (url_id);
  13  CREATE INDEX ezurl_ol_coa_id ON ezurl_object_link (contentobject_attribute_id);
  14  CREATE INDEX ezurl_ol_coa_version ON ezurl_object_link (contentobject_attribute_version);
  15  
  16  -- Fix bug in cache-block, ezsubtree_exipry
  17  DELETE FROM ezsubtree_expiry;
  18  ALTER TABLE ezsubtree_expiry DROP COLUMN subtree;
  19  ALTER TABLE ezsubtree_expiry ADD COLUMN subtree INT;
  20  CREATE INDEX ezsubtree_expiry_subtree ON ezsubtree_expiry( subtree );
  21  
  22  -- Create index for path_identification_string
  23  CREATE INDEX ezcontentobject_tree_path_ident ON ezcontentobject_tree (path_identification_string);