[Sommaire] [Imprimer]

   1  UPDATE ezsite_data SET value='3.4.0alpha1' WHERE name='ezpublish-version';
   2  UPDATE ezsite_data SET value='1' WHERE name='ezpublish-release';
   3  
   4  ALTER TABLE ezcontentobject_tree ADD COLUMN modified_subnode INT;
   5  ALTER TABLE ezcontentobject_tree ALTER modified_subnode SET DEFAULT 0;
   6  
   7  CREATE INDEX ezcontentobject_tree_mod_sub ON ezcontentobject_tree( modified_subnode );
   8  
   9  UPDATE ezcontentobject_tree SET modified_subnode=(SELECT max( ezcontentobject.modified )
  10         FROM ezcontentobject, ezcontentobject_tree as tree
  11         WHERE ezcontentobject.id = tree.contentobject_id AND
  12               tree.path_string like ezcontentobject_tree.path_string||'%');
  13  
  14  ALTER TABLE ezuser_role ADD COLUMN limit_identifier varchar(255);
  15  ALTER TABLE ezuser_role ALTER limit_identifier SET DEFAULT '';
  16  ALTER TABLE ezuser_role ADD COLUMN limit_value varchar(255);
  17  ALTER TABLE ezuser_role ALTER limit_value SET DEFAULT '';
  18  
  19  ALTER TABLE ezpolicy DROP COLUMN limitation;
  20  
  21  ALTER TABLE ezpolicy_limitation DROP COLUMN role_id;
  22  ALTER TABLE ezpolicy_limitation DROP COLUMN function_name;
  23  ALTER TABLE ezpolicy_limitation DROP COLUMN module_name;
  24  
  25  CREATE INDEX ezuser_role_role_id ON ezuser_role ( role_id );