[Sommaire] [Imprimer]

   1  UPDATE ezsite_data SET value='2' WHERE name='ezpublish-release';
   2  
   3  ALTER TABLE ezsubtree_notification_rule ADD user_id INTEGER;
   4  ALTER TABLE ezsubtree_notification_rule ALTER user_id SET NOT NULL;
   5  
   6  CREATE SEQUENCE tmp_notification_rule_s
   7      START 1
   8      INCREMENT 1
   9      MAXVALUE 9223372036854775807
  10      MINVALUE 1
  11      CACHE 1;
  12  
  13  CREATE TABLE tmp_notification_rule ( id INTEGER DEFAULT nextval('tmp_notification_rule_s'::text) NOT NULL,
  14                                       use_digest INTEGER DEFAULT 0,
  15                                       node_id INTEGER NOT NULL,
  16                                       user_id INTEGER NOT NULL,
  17                                       primary key( id ) );
  18  
  19  INSERT INTO tmp_notification_rule ( use_digest, node_id, user_id ) SELECT rule.use_digest, rule.node_id, ezuser.contentobject_id AS user_id 
  20        FROM ezsubtree_notification_rule AS rule, ezuser 
  21        WHERE rule.address=ezuser.email;
  22  
  23  DROP TABLE ezsubtree_notification_rule;
  24  ALTER TABLE tmp_notification_rule rename TO ezsubtree_notification_rule;
  25  
  26  CREATE INDEX ezsubtree_notification_rule_id ON ezsubtree_notification_rule(id);
  27  CREATE INDEX ezsubtree_notification_rule_user_id ON ezsubtree_notification_rule(user_id);