[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 USING btree ( published );
   7  CREATE INDEX ezcontentobject_status ON ezcontentobject USING btree ( status );
   8  CREATE INDEX ezcontentobject_classid ON ezcontentobject USING btree ( contentclass_id );
   9  CREATE INDEX ezcontentobject_currentversion ON ezcontentobject USING btree ( current_version );
  10  
  11  -- ezcontentobject_name
  12  CREATE INDEX ezcontentobject_name_lang_id ON ezcontentobject_name USING btree ( language_id );
  13  CREATE INDEX ezcontentobject_name_name ON ezcontentobject_name USING btree ( name );
  14  CREATE INDEX ezcontentobject_name_co_id ON ezcontentobject_name USING btree ( contentobject_id );
  15  CREATE INDEX ezcontentobject_name_cov_id ON ezcontentobject_name USING btree ( content_version );
  16  
  17  -- ezcontentobject_version
  18  CREATE INDEX ezcobj_version_creator_id ON ezcontentobject_version USING btree ( creator_id );
  19  CREATE INDEX ezcobj_version_status ON ezcontentobject_version USING btree ( status );
  20  
  21  -- ezpolicy_limitation_value
  22  CREATE INDEX ezpolicy_limitation_value_val ON ezpolicy_limitation_value USING btree ( value );
  23  
  24  -- ezinfocollection_attribute
  25  CREATE INDEX ezinfocollection_attr_co_id ON ezinfocollection_attribute USING btree ( contentobject_id );
  26  
  27  -- ezurlalias
  28  CREATE INDEX ezurlalias_forward_to_id ON ezurlalias USING btree ( forward_to_id );
  29  
  30  -- ezkeyword
  31  CREATE INDEX ezkeyword_keyword ON ezkeyword USING btree ( keyword );
  32  
  33  -- ezurl
  34  CREATE INDEX ezurl_url ON ezurl USING btree ( url );
  35  
  36  -- ezcontentobject_attribute
  37  CREATE INDEX ezcontentobject_attr_id ON ezcontentobject_attribute USING btree ( id );
  38  
  39  -- ezcontentoclass_attribute
  40  CREATE INDEX ezcontentclass_attr_ccid ON ezcontentclass_attribute USING btree ( contentclass_id );
  41  
  42  -- eznode_assignment
  43  CREATE INDEX eznode_assignment_co_id ON eznode_assignment USING btree ( contentobject_id );
  44  CREATE INDEX eznode_assignment_co_version ON eznode_assignment USING btree ( contentobject_version );
  45  
  46  -- ezkeyword_attribute_link
  47  CREATE INDEX ezkeyword_attr_link_keyword_id ON ezkeyword_attribute_link USING btree ( keyword_id );
  48  -- END: from 3.8.5