[Sommaire] [Imprimer]

   1  UPDATE ezsite_data SET value='3.5.0' WHERE name='ezpublish-version';
   2  UPDATE ezsite_data SET value='5' WHERE name='ezpublish-release';
   3  
   4  -- 3.4.2 to 3.5.0alpha1
   5  
   6  -- We allow users from the "Editors" group 
   7  -- access only to "Root Folder" and "Media" trees.
   8  -- If you want to fix this you need to figure out the ids of these roles and modify
   9  -- the following SQLs
  10  --
  11  -- DELETE FROM ezuser_role WHERE id=30 AND role_id=3;  
  12  -- INSERT INTO ezuser_role
  13  --        (role_id, contentobject_id, limit_identifier,limit_value)
  14  --        VALUES (3,13,'Subtree','/1/2/');
  15  -- INSERT INTO ezuser_role
  16  --        (role_id, contentobject_id, limit_identifier,limit_value)
  17  --        VALUES (3,13,'Subtree','/1/43/');
  18  
  19  -- the support of redirect payment gateways
  20  -- create table for eZPaymentObjects
  21  CREATE TABLE ezpaymentobject(
  22      id int not null primary key auto_increment,
  23      workflowprocess_id int not null,
  24      order_id int not null default '0',
  25      payment_string varchar(255) NOT NULL DEFAULT '',
  26      status int not null default '0'
  27      ) TYPE=MyISAM;
  28  
  29  ALTER TABLE ezbinaryfile ADD COLUMN download_count integer NOT NULL default 0;
  30  ALTER TABLE ezbasket ADD COLUMN order_id integer NOT NULL DEFAULT 0;
  31  
  32  ALTER TABLE ezcontentclass ADD is_container int NOT NULL DEFAULT 0;
  33  
  34  -- New table for storing the users last visit
  35  
  36  create table ezuservisit
  37  (
  38  user_id int primary key not null,
  39  current_visit_timestamp int not null,
  40  last_visit_timestamp int not null
  41  );
  42  
  43  -- New columns for the hiding functionality
  44  ALTER TABLE ezcontentobject_tree ADD is_hidden    INTEGER NOT NULL DEFAULT 0;
  45  ALTER TABLE ezcontentobject_tree ADD is_invisible INTEGER NOT NULL DEFAULT 0;
  46  
  47  
  48  -- 3.5.0alpha1 to 3.5.0beta1
  49  
  50  -- fix for section based conditional assignment also in 3.4.3
  51  update  ezuser_role set limit_identifier='Section' where limit_identifier='section';
  52  
  53  -- fixes incorrect name of group in ezcontentclass_classgroup 
  54  update ezcontentclass_classgroup set group_name='Users' where group_id=2;
  55  
  56  
  57  -- 3.5.0beta1 to 3.5.0rc1
  58  
  59  alter table ezrole add column is_new integer not null default 0;
  60  
  61  -- New name for ezsearch index, the old one crashed with the table name ezsearch_word
  62  ALTER TABLE ezsearch_word DROP INDEX ezsearch_word;
  63  ALTER TABLE ezsearch_word ADD INDEX ezsearch_word_word_i ( word );
  64  
  65   -- ezpdf_export
  66   -- Added support for versioning (class-type)
  67  
  68  CREATE TABLE tmp_ezpdf_export (
  69      created int(11) default NULL,
  70      creator_id int(11) default NULL,
  71      export_classes varchar(255) default NULL,
  72      export_structure varchar(255) default NULL,
  73      id int(11) NOT NULL auto_increment,
  74      intro_text longtext,
  75      modified int(11) default NULL,
  76      modifier_id int(11) default NULL,
  77      pdf_filename varchar(255) default NULL,
  78      show_frontpage int(11) default NULL,
  79      site_access varchar(255) default NULL,
  80      source_node_id int(11) default NULL,
  81      status int(11) default NULL,
  82      sub_text longtext,
  83      title varchar(255) default NULL,
  84      version int(11) NOT NULL default '0',
  85      PRIMARY KEY (id,version)
  86  ) TYPE=MyISAM;
  87  
  88  INSERT INTO tmp_ezpdf_export( created, creator_id, export_classes, export_structure, id, intro_text, modified, modifier_id,
  89      pdf_filename, show_frontpage, site_access, source_node_id, status, sub_text, title )
  90  SELECT created, creator_id, export_classes, export_structure, id, intro_text, modified, modifier_id,
  91      pdf_filename, show_frontpage, site_access, source_node_id, status, sub_text, title
  92  FROM ezpdf_export;
  93  
  94  DROP TABLE ezpdf_export;
  95  
  96  ALTER TABLE tmp_ezpdf_export RENAME TO ezpdf_export;
  97  
  98   -- ezrss_import
  99   -- Added support for versioning (class-type) by reusing status attribute
 100  
 101  CREATE TABLE tmp_ezrss_import (
 102      active int(11) default NULL,
 103      class_description varchar(255) default NULL,
 104      class_id int(11) default NULL,
 105      class_title varchar(255) default NULL,
 106      class_url varchar(255) default NULL,
 107      created int(11) default NULL,
 108      creator_id int(11) default NULL,
 109      destination_node_id int(11) default NULL,
 110      id int(11) NOT NULL auto_increment,
 111      modified int(11) default NULL,
 112      modifier_id int(11) default NULL,
 113      name varchar(255) default NULL,
 114      object_owner_id int(11) default NULL,
 115      status int(11) NOT NULL default '0',
 116      url longtext,
 117      PRIMARY KEY (id,status)
 118  ) TYPE=MyISAM;
 119  
 120  INSERT INTO tmp_ezrss_import( active, class_description, class_id, class_title, class_url, created, creator_id,
 121      destination_node_id, id, modified, modifier_id, name, object_owner_id, status, url )
 122  SELECT active, class_description, class_id, class_title, class_url, created, creator_id,
 123      destination_node_id, id, modified, modifier_id, name, object_owner_id, status, url
 124  FROM ezrss_import;
 125  
 126  DROP TABLE ezrss_import;
 127  
 128  ALTER TABLE tmp_ezrss_import RENAME TO ezrss_import;
 129  
 130   -- ezrss_export
 131   -- Added support for versioning (class-type) by reusing status attribute
 132  
 133  CREATE TABLE tmp_ezrss_export (
 134      access_url varchar(255) default NULL,
 135      active int(11) default NULL,
 136      created int(11) default NULL,
 137      creator_id int(11) default NULL,
 138      description longtext,
 139      id int(11) NOT NULL auto_increment,
 140      image_id int(11) default NULL,
 141      modified int(11) default NULL,
 142      modifier_id int(11) default NULL,
 143      rss_version varchar(255) default NULL,
 144      site_access varchar(255) default NULL,
 145      status int(11) NOT NULL default '0',
 146      title varchar(255) default NULL,
 147      url varchar(255) default NULL,
 148      PRIMARY KEY (id,status)
 149  ) TYPE=MyISAM;
 150  
 151  INSERT INTO tmp_ezrss_export( access_url, active, created, creator_id, description, id, image_id, modified,
 152      modifier_id, rss_version, site_access, status, title, url )
 153  SELECT access_url, active, created, creator_id, description, id, image_id, modified,
 154      modifier_id, rss_version, site_access, status, title, url
 155  FROM ezrss_export;
 156  
 157  DROP TABLE ezrss_export;
 158  
 159  ALTER TABLE tmp_ezrss_export RENAME TO ezrss_export;
 160  
 161   -- ezrss_export_item
 162   -- Added support for versioning (class-type) by introducing status attribute
 163  
 164  CREATE TABLE tmp_ezrss_export_item (
 165      class_id int(11) default NULL,
 166      description varchar(255) default NULL,
 167      id int(11) NOT NULL auto_increment,
 168      rssexport_id int(11) default NULL,
 169      source_node_id int(11) default NULL,
 170      status int(11) NOT NULL default '0',
 171      title varchar(255) default NULL,
 172      PRIMARY KEY (id,status),
 173      KEY ezrss_export_rsseid (rssexport_id)
 174  ) TYPE=MyISAM;
 175  
 176  INSERT INTO tmp_ezrss_export_item( class_id, description, id, rssexport_id, source_node_id, title )
 177  SELECT class_id, description, id, rssexport_id, source_node_id, title
 178  FROM ezrss_export_item;
 179  
 180  UPDATE tmp_ezrss_export_item SET status='1';
 181  
 182  DROP TABLE ezrss_export_item;
 183  
 184  ALTER TABLE tmp_ezrss_export_item RENAME TO ezrss_export_item;
 185  
 186   -- ezproductcollection_item
 187   -- Added attribute name for storing a product name
 188  
 189  ALTER TABLE ezproductcollection_item ADD COLUMN name VARCHAR(255) NOT NULL DEFAULT '';
 190  UPDATE ezproductcollection_item SET name='Unknown product';
 191  
 192  
 193  -- 3.5.0rc1 to 3.5.0rc2
 194  
 195  -- Reduce the total size of the index eztrigger_def_id to make it work with utf-8
 196  ALTER TABLE eztrigger DROP INDEX eztrigger_def_id;
 197  ALTER TABLE eztrigger ADD UNIQUE INDEX eztrigger_def_id (module_name( 50 ),function_name( 50 ),connect_type);
 198  
 199  
 200  -- 3.5.0rc2 to 3.5.0