[Sommaire] [Imprimer]

   1  UPDATE ezsite_data SET value='3.5.0rc1' WHERE name='ezpublish-version';
   2  UPDATE ezsite_data SET value='3' WHERE name='ezpublish-release';
   3  
   4  alter table ezrole add column is_new integer not null default 0;
   5  
   6  -- New name for ezsearch index, the old one crashed with the table name ezsearch_word
   7  ALTER TABLE ezsearch_word DROP INDEX ezsearch_word;
   8  ALTER TABLE ezsearch_word ADD INDEX ezsearch_word_word_i ( word );
   9  
  10   -- ezpdf_export
  11   -- Added support for versioning (class-type)
  12  
  13  CREATE TABLE tmp_ezpdf_export (
  14      created int(11) default NULL,
  15      creator_id int(11) default NULL,
  16      export_classes varchar(255) default NULL,
  17      export_structure varchar(255) default NULL,
  18      id int(11) NOT NULL auto_increment,
  19      intro_text longtext,
  20      modified int(11) default NULL,
  21      modifier_id int(11) default NULL,
  22      pdf_filename varchar(255) default NULL,
  23      show_frontpage int(11) default NULL,
  24      site_access varchar(255) default NULL,
  25      source_node_id int(11) default NULL,
  26      status int(11) default NULL,
  27      sub_text longtext,
  28      title varchar(255) default NULL,
  29      version int(11) NOT NULL default '0',
  30      PRIMARY KEY (id,version)
  31  ) TYPE=MyISAM;
  32  
  33  INSERT INTO tmp_ezpdf_export( created, creator_id, export_classes, export_structure, id, intro_text, modified, modifier_id,
  34      pdf_filename, show_frontpage, site_access, source_node_id, status, sub_text, title )
  35  SELECT created, creator_id, export_classes, export_structure, id, intro_text, modified, modifier_id,
  36      pdf_filename, show_frontpage, site_access, source_node_id, status, sub_text, title
  37  FROM ezpdf_export;
  38  
  39  DROP TABLE ezpdf_export;
  40  
  41  ALTER TABLE tmp_ezpdf_export RENAME TO ezpdf_export;
  42  
  43   -- ezrss_import
  44   -- Added support for versioning (class-type) by reusing status attribute
  45  
  46  CREATE TABLE tmp_ezrss_import (
  47      active int(11) default NULL,
  48      class_description varchar(255) default NULL,
  49      class_id int(11) default NULL,
  50      class_title varchar(255) default NULL,
  51      class_url varchar(255) default NULL,
  52      created int(11) default NULL,
  53      creator_id int(11) default NULL,
  54      destination_node_id int(11) default NULL,
  55      id int(11) NOT NULL auto_increment,
  56      modified int(11) default NULL,
  57      modifier_id int(11) default NULL,
  58      name varchar(255) default NULL,
  59      object_owner_id int(11) default NULL,
  60      status int(11) NOT NULL default '0',
  61      url longtext,
  62      PRIMARY KEY (id,status)
  63  ) TYPE=MyISAM;
  64  
  65  INSERT INTO tmp_ezrss_import( active, class_description, class_id, class_title, class_url, created, creator_id,
  66      destination_node_id, id, modified, modifier_id, name, object_owner_id, status, url )
  67  SELECT active, class_description, class_id, class_title, class_url, created, creator_id,
  68      destination_node_id, id, modified, modifier_id, name, object_owner_id, status, url
  69  FROM ezrss_import;
  70  
  71  DROP TABLE ezrss_import;
  72  
  73  ALTER TABLE tmp_ezrss_import RENAME TO ezrss_import;
  74  
  75   -- ezrss_export
  76   -- Added support for versioning (class-type) by reusing status attribute
  77  
  78  CREATE TABLE tmp_ezrss_export (
  79      access_url varchar(255) default NULL,
  80      active int(11) default NULL,
  81      created int(11) default NULL,
  82      creator_id int(11) default NULL,
  83      description longtext,
  84      id int(11) NOT NULL auto_increment,
  85      image_id int(11) default NULL,
  86      modified int(11) default NULL,
  87      modifier_id int(11) default NULL,
  88      rss_version varchar(255) default NULL,
  89      site_access varchar(255) default NULL,
  90      status int(11) NOT NULL default '0',
  91      title varchar(255) default NULL,
  92      url varchar(255) default NULL,
  93      PRIMARY KEY (id,status)
  94  ) TYPE=MyISAM;
  95  
  96  INSERT INTO tmp_ezrss_export( access_url, active, created, creator_id, description, id, image_id, modified,
  97      modifier_id, rss_version, site_access, status, title, url )
  98  SELECT access_url, active, created, creator_id, description, id, image_id, modified,
  99      modifier_id, rss_version, site_access, status, title, url
 100  FROM ezrss_export;
 101  
 102  DROP TABLE ezrss_export;
 103  
 104  ALTER TABLE tmp_ezrss_export RENAME TO ezrss_export;
 105  
 106   -- ezrss_export_item
 107   -- Added support for versioning (class-type) by introducing status attribute
 108  
 109  CREATE TABLE tmp_ezrss_export_item (
 110      class_id int(11) default NULL,
 111      description varchar(255) default NULL,
 112      id int(11) NOT NULL auto_increment,
 113      rssexport_id int(11) default NULL,
 114      source_node_id int(11) default NULL,
 115      status int(11) NOT NULL default '0',
 116      title varchar(255) default NULL,
 117      PRIMARY KEY (id,status),
 118      KEY ezrss_export_rsseid (rssexport_id)
 119  ) TYPE=MyISAM;
 120  
 121  INSERT INTO tmp_ezrss_export_item( class_id, description, id, rssexport_id, source_node_id, title )
 122  SELECT class_id, description, id, rssexport_id, source_node_id, title
 123  FROM ezrss_export_item;
 124  
 125  UPDATE tmp_ezrss_export_item SET status='1';
 126  
 127  DROP TABLE ezrss_export_item;
 128  
 129  ALTER TABLE tmp_ezrss_export_item RENAME TO ezrss_export_item;
 130  
 131   -- ezproductcollection_item
 132   -- Added attribute name for storing a product name
 133  
 134  ALTER TABLE ezproductcollection_item ADD COLUMN name VARCHAR(255) NOT NULL DEFAULT '';
 135  UPDATE ezproductcollection_item SET name='Unknown product';