[Sommaire] [Imprimer]

   1  UPDATE ezsite_data SET value='2' WHERE name='ezpublish-release';
   2  
   3  -- If you're upgrading from an 3.3-1 installation ( not 3.2-4 -> 3.3-1 upgrade ) please uncomment and run the line below
   4  
   5  -- ALTER TABLE ezsubtree_notification_rule add user_id INT NOT NULL;
   6  -- 
   7  -- CREATE TABLE tmp_notification_rule ( id INT PRIMARY KEY AUTO_INCREMENT,
   8  --                                      use_digest INT DEFAULT 0,
   9  --                                      node_id INT NOT NULL,
  10  --                                      user_id INT NOT NULL );
  11  -- 
  12  -- INSERT INTO tmp_notification_rule ( use_digest, node_id, user_id ) SELECT rule.use_digest, rule.node_id, ezuser.contentobject_id AS user_id 
  13  --       FROM ezsubtree_notification_rule AS rule, ezuser 
  14  --       WHERE rule.address=ezuser.email;
  15  -- 
  16  -- DROP TABLE ezsubtree_notification_rule;
  17  -- ALTER TABLE tmp_notification_rule rename ezsubtree_notification_rule;
  18  -- 
  19  -- CREATE INDEX ezsubtree_notification_rule_id ON ezsubtree_notification_rule(id);
  20  -- CREATE INDEX ezsubtree_notification_rule_user_id ON ezsubtree_notification_rule(user_id);