[Sommaire] [Imprimer]

   1  UPDATE ezsite_data SET value='3.4.1' WHERE name='ezpublish-version';
   2  UPDATE ezsite_data SET value='8' WHERE name='ezpublish-release';
   3  
   4  -- We allow users from the "Editors" group
   5  -- access only to "Root Folder" and "Media" trees.
   6  -- If you want to fix this you need to figure out the ids of these roles and modify
   7  -- the following SQLs
   8  --
   9  -- DELETE FROM ezuser_role WHERE id=30 AND role_id=3;  
  10  -- INSERT INTO ezuser_role
  11  --        (role_id, contentobject_id, limit_identifier,limit_value)
  12  --        VALUES (3,13,'Subtree','/1/2/');
  13  -- INSERT INTO ezuser_role
  14  --        (role_id, contentobject_id, limit_identifier,limit_value)
  15  --        VALUES (3,13,'Subtree','/1/43/');
  16  
  17  CREATE SEQUENCE tmp_notification_rule_s
  18      START 1
  19      INCREMENT 1
  20      MAXVALUE 9223372036854775807
  21      MINVALUE 1
  22      CACHE 1;
  23  
  24  -- Missing index
  25  CREATE INDEX idx_object_version_objver ON ezcontentobject_version ( contentobject_id, version );