[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  -- the support of redirect payment gateways
  18  -- create table for eZPaymentObjects
  19  CREATE TABLE ezpaymentobject(
  20      id int not null primary key auto_increment,
  21      workflowprocess_id int not null,
  22      order_id int not null default '0',
  23      payment_string varchar(255) NOT NULL DEFAULT '',
  24      status int not null default '0'
  25      ) TYPE=MyISAM;
  26  
  27  ALTER TABLE ezbinaryfile ADD COLUMN download_count integer NOT NULL default 0;
  28  ALTER TABLE ezbasket ADD COLUMN order_id integer NOT NULL DEFAULT 0;
  29  
  30  ALTER TABLE ezcontentclass ADD is_container int NOT NULL DEFAULT 0;
  31  
  32  -- New table for storing the users last visit
  33  
  34  create table ezuservisit
  35  (
  36  user_id int primary key not null,
  37  current_visit_timestamp int not null,
  38  last_visit_timestamp int not null
  39  );
  40  
  41  -- New columns for the hiding functionality
  42  ALTER TABLE ezcontentobject_tree ADD is_hidden    INTEGER NOT NULL DEFAULT 0;
  43  ALTER TABLE ezcontentobject_tree ADD is_invisible INTEGER NOT NULL DEFAULT 0;
  44