[Sommaire] [Imprimer]

   1  UPDATE ezsite_data SET value='2' WHERE name='ezpublish-release';
   2  
   3  ALTER TABLE ezsubtree_notification_rule add user_id INT NOT NULL;
   4  
   5  CREATE TABLE tmp_notification_rule ( id INT PRIMARY KEY AUTO_INCREMENT,
   6                                       use_digest INT DEFAULT 0,
   7                                       node_id INT NOT NULL,
   8                                       user_id INT NOT NULL );
   9  
  10  INSERT INTO tmp_notification_rule ( use_digest, node_id, user_id ) SELECT rule.use_digest, rule.node_id, ezuser.contentobject_id AS user_id 
  11        FROM ezsubtree_notification_rule AS rule, ezuser 
  12        WHERE rule.address=ezuser.email;
  13  
  14  DROP TABLE ezsubtree_notification_rule;
  15  ALTER TABLE tmp_notification_rule rename ezsubtree_notification_rule;
  16  
  17  CREATE INDEX ezsubtree_notification_rule_id ON ezsubtree_notification_rule(id);
  18  CREATE INDEX ezsubtree_notification_rule_user_id ON ezsubtree_notification_rule(user_id);
  19  
  20  ALTER TABLE ezrss_export ADD rss_version VARCHAR(255) DEFAULT NULL;
  21  
  22  -- If you're upgrading the packages from 3.3.0-1 you must the following line also,
  23  -- it was missing from the previous release in the packages.
  24  --
  25