[Sommaire] [Imprimer]

   1  UPDATE ezsite_data SET value='3.9.0beta1' WHERE name='ezpublish-version';
   2  UPDATE ezsite_data SET value='2' WHERE name='ezpublish-release';
   3  
   4  -- START: from 3.8.5
   5  -- ezcontentobject
   6  CREATE INDEX ezcontentobject_pub ON ezcontentobject( published );
   7  CREATE INDEX ezcontentobject_status ON ezcontentobject( status );
   8  CREATE INDEX ezcontentobject_classid ON ezcontentobject( contentclass_id );
   9  CREATE INDEX ezcontentobject_currentversion ON ezcontentobject( current_version );
  10  
  11  -- ezcontentobject_name
  12  CREATE INDEX ezcontentobject_name_lang_id ON ezcontentobject_name( language_id );
  13  CREATE INDEX ezcontentobject_name_name ON ezcontentobject_name( name );
  14  CREATE INDEX ezcontentobject_name_co_id ON ezcontentobject_name( contentobject_id );
  15  CREATE INDEX ezcontentobject_name_cov_id ON ezcontentobject_name( content_version );
  16  
  17  -- ezcontentobject_version
  18  CREATE INDEX ezcobj_version_creator_id ON ezcontentobject_version( creator_id );
  19  CREATE INDEX ezcobj_version_status ON ezcontentobject_version( status );
  20  
  21  -- ezpolicy_limitation_value
  22  CREATE INDEX ezpolicy_limitation_value_val ON ezpolicy_limitation_value( value );
  23  
  24  -- ezinfocollection_attribute
  25  CREATE INDEX ezinfocollection_attr_co_id ON ezinfocollection_attribute( contentobject_id );
  26  
  27  -- ezurlalias
  28  CREATE INDEX ezurlalias_forward_to_id ON ezurlalias( forward_to_id );
  29  
  30  -- ezkeyword
  31  CREATE INDEX ezkeyword_keyword ON ezkeyword( keyword );
  32  
  33  -- ezurl
  34  CREATE INDEX ezurl_url ON ezurl( url );
  35  
  36  -- ezcontentobject_attribute
  37  CREATE INDEX ezcontentobject_attr_id ON ezcontentobject_attribute( id );
  38  
  39  -- ezcontentoclass_attribute
  40  CREATE INDEX ezcontentclass_attr_ccid ON ezcontentclass_attribute( contentclass_id );
  41  
  42  -- eznode_assignment
  43  CREATE INDEX eznode_assignment_co_id ON eznode_assignment( contentobject_id );
  44  CREATE INDEX eznode_assignment_co_version ON eznode_assignment( contentobject_version );
  45  
  46  -- ezkeyword_attribute_link
  47  CREATE INDEX ezkeyword_attr_link_keyword_id ON ezkeyword_attribute_link( keyword_id );
  48  -- END: from 3.8.5