[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  -- 
   5  -- Update ContentObjectTreeNode to store latest modified subnode value.
   6  --
   7  
   8  -- 
   9  -- Update ContentObjectTreeNode to store latest modified subnode value.
  10  --
  11  
  12  CREATE TABLE tmp_ezcontentobject_tree (
  13    node_id int(11) NOT NULL,
  14    modified_subnode int NOT NULL
  15  );
  16  
  17  CREATE INDEX idx_modified_obj on ezcontentobject( modified DESC );
  18  CREATE INDEX idx_pat_string_obj on ezcontentobject_tree( path_string );
  19  
  20  INSERT INTO tmp_ezcontentobject_tree ( node_id, modified_subnode )
  21         SELECT tree.node_id, max( obj.modified )
  22         FROM ezcontentobject_tree as subtree, ezcontentobject_tree as tree,  ezcontentobject as obj
  23         WHERE obj.id = subtree.contentobject_id AND
  24               subtree.path_string like concat( tree.path_string, '%')
  25         GROUP BY tree.node_id;
  26  
  27  CREATE TABLE tmp2_ezcontentobject_tree AS
  28   SELECT ezcontentobject_tree.*, tmp_ezcontentobject_tree.modified_subnode
  29    FROM  ezcontentobject_tree, tmp_ezcontentobject_tree
  30    WHERE ezcontentobject_tree.node_id=tmp_ezcontentobject_tree.node_id;
  31  
  32  DELETE FROM ezcontentobject_tree;
  33  
  34  ALTER TABLE ezcontentobject_tree ADD COLUMN modified_subnode int NOT NULL default 0, ADD INDEX (modified_subnode);
  35  
  36  INSERT INTO ezcontentobject_tree SELECT * FROM tmp2_ezcontentobject_tree;
  37  
  38  DROP TABLE tmp2_ezcontentobject_tree;
  39  
  40  DROP TABLE tmp_ezcontentobject_tree;
  41  
  42  DROP INDEX idx_modified_obj on ezcontentobject;
  43  DROP INDEX idx_pat_string_obj on ezcontentobject_tree;
  44  
  45  --
  46  --  Optimization and extending of role system.
  47  --
  48  
  49  ALTER TABLE ezuser_role ADD COLUMN limit_identifier varchar(255) default '';
  50  ALTER TABLE ezuser_role ADD COLUMN limit_value varchar(255) default '';
  51  
  52  ALTER TABLE ezpolicy DROP COLUMN limitation;
  53  
  54  ALTER TABLE ezpolicy_limitation DROP COLUMN role_id;
  55  ALTER TABLE ezpolicy_limitation DROP COLUMN function_name;
  56  ALTER TABLE ezpolicy_limitation DROP COLUMN module_name;
  57  
  58  CREATE INDEX ezuser_role_role_id ON ezuser_role ( role_id );
  59