[Sommaire] [Imprimer]

   1  UPDATE ezsite_data SET value='3.5.0alpha1' WHERE name='ezpublish-version';
   2  UPDATE ezsite_data SET value='1' 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  -- This is present in 3.4.2, uncomment and run this if
  18  -- this is missing from your DB
  19  -- CREATE SEQUENCE tmp_notification_rule_s
  20  --     START 1
  21  --     INCREMENT 1
  22  --     MAXVALUE 9223372036854775807
  23  --     MINVALUE 1
  24  --     CACHE 1;
  25  
  26  -- the support of redirect payment gateways
  27  -- create table for eZPaymentObjects
  28  CREATE SEQUENCE ezpaymentobject_s
  29      START 1
  30      INCREMENT 1
  31      MAXVALUE 9223372036854775807
  32      MINVALUE 1
  33      CACHE 1;
  34  
  35  CREATE TABLE ezpaymentobject(
  36      id integer DEFAULT nextval('ezpaymentobject_s'::text) NOT NULL PRIMARY KEY,
  37      workflowprocess_id integer DEFAULT 0 NOT NULL,
  38      order_id integer DEFAULT 0 NOT NULL,
  39      payment_string character varying(255) DEFAULT ''::character varying NOT NULL,
  40      status integer DEFAULT 0 NOT NULL
  41      );
  42  
  43  ALTER TABLE ezbasket ADD COLUMN order_id integer;
  44  UPDATE ezbasket SET order_id=0;
  45  ALTER TABLE ezbasket ALTER order_id SET NOT NULL;
  46  ALTER TABLE ezbasket ALTER order_id SET DEFAULT 0;
  47  
  48  ALTER TABLE ezbinaryfile ADD COLUMN download_count integer;
  49  UPDATE ezbinaryfile SET download_count='0';
  50  ALTER TABLE ezbinaryfile ALTER download_count SET NOT NULL;
  51  ALTER TABLE ezbinaryfile ALTER download_count SET DEFAULT 0;
  52  
  53  ALTER TABLE ezcontentclass ADD is_container integer;
  54  UPDATE ezcontentclass SET is_container=0;
  55  ALTER TABLE ezcontentclass ALTER is_container SET NOT NULL;
  56  ALTER TABLE ezcontentclass ALTER is_container SET DEFAULT 0;
  57  
  58  -- New table for storing the users last visit
  59  
  60  CREATE TABLE ezuservisit
  61  (
  62      user_id                 INT NOT NULL PRIMARY KEY,
  63      current_visit_timestamp INT NOT NULL,
  64      last_visit_timestamp    INT NOT NULL
  65  );
  66  
  67  -- New columns for the hiding functionality
  68  ALTER TABLE ezcontentobject_tree ADD   is_hidden INTEGER;
  69  UPDATE      ezcontentobject_tree SET   is_hidden = 0;
  70  ALTER TABLE ezcontentobject_tree ALTER is_hidden SET NOT NULL;
  71  ALTER TABLE ezcontentobject_tree ALTER is_hidden SET DEFAULT 0;
  72  ALTER TABLE ezcontentobject_tree ADD   is_invisible INTEGER;
  73  UPDATE      ezcontentobject_tree SET   is_invisible = 0;
  74  ALTER TABLE ezcontentobject_tree ALTER is_invisible SET NOT NULL;
  75  ALTER TABLE ezcontentobject_tree ALTER is_invisible SET DEFAULT 0;
  76