[Sommaire] [Imprimer]

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