[Sommaire] [Imprimer]

   1  UPDATE ezsite_data SET value='3.3' WHERE name='ezpublish-version';
   2  UPDATE ezsite_data SET value='1' WHERE name='ezpublish-release';
   3  
   4  ALTER TABLE ezinfocollection ADD COLUMN user_identifier varchar(34);
   5  ALTER TABLE ezinfocollection ADD COLUMN modified int NOT NULL DEFAULT 0;
   6  ALTER TABLE ezinfocollection_attribute ADD COLUMN contentobject_attribute_id int;
   7  ALTER TABLE ezinfocollection_attribute ADD COLUMN contentobject_id int;
   8  
   9  CREATE TABLE ezpdf_export ( 
  10    id integer NOT NULL auto_increment,
  11    title varchar(255) default NULL,
  12    show_frontpage int default NULL,
  13    intro_text text default NULL,
  14    sub_text text default NULL,
  15    source_node_id int default NULL,
  16    export_structure varchar(255) default NULL,
  17    export_classes varchar(255) default NULL,
  18    site_access varchar(255) default NULL,
  19    pdf_filename varchar(255) default NULL,
  20    modifier_id integer default NULL,
  21    modified integer default NULL,
  22    created integer default NULL,
  23    creator_id integer default NULL,
  24    status integer default NULL,
  25    PRIMARY KEY (id) 
  26  ) TYPE=MyISAM;
  27  
  28  CREATE TABLE ezrss_export (
  29    id integer NOT NULL auto_increment,
  30    title varchar(255) default NULL,
  31    modifier_id integer default NULL,
  32    modified integer default NULL,
  33    url varchar(255) default NULL,
  34    description text,
  35    image_id integer default NULL,
  36    active integer default NULL,
  37    access_url varchar(255) default NULL,
  38    created integer default NULL,
  39    creator_id integer default NULL,
  40    status integer default NULL,
  41    site_access varchar(255) default NULL,
  42    rss_version varchar(255) default NULL,
  43    PRIMARY KEY  (id)
  44  ) TYPE=MyISAM;
  45  
  46  CREATE TABLE ezrss_export_item (
  47    id integer NOT NULL auto_increment,
  48    rssexport_id integer default NULL,
  49    source_node_id integer default NULL,
  50    class_id integer default NULL,
  51    title varchar(255) default NULL,
  52    description varchar(255) default NULL,
  53    PRIMARY KEY  (id)
  54  ) TYPE=MyISAM;
  55  
  56  CREATE INDEX ezrss_export_rsseid ON ezrss_export_item( rssexport_id );
  57  
  58  CREATE TABLE ezrss_import (
  59    id integer NOT NULL auto_increment,
  60    name varchar(255) default NULL,
  61    url text,
  62    destination_node_id integer default NULL,
  63    class_id integer default NULL,
  64    class_title varchar(255) default NULL,
  65    class_url varchar(255) default NULL,
  66    class_description varchar(255) default NULL,
  67    active integer default NULL,
  68    creator_id integer default NULL,
  69    created integer default NULL,
  70    modifier_id integer default NULL,
  71    modified integer default NULL,
  72    status integer default NULL,
  73    object_owner_id integer default NULL,
  74    PRIMARY KEY  (id)
  75  ) TYPE=MyISAM;
  76  
  77  
  78  --
  79  -- 
  80  create table ezcontent_attribute_tmp as select ezcontentobject_attribute.*, ezcontentclass_attribute.data_type_string from ezcontentobject_attribute, ezcontentclass_attribute where  ezcontentobject_attribute.contentclassattribute_id=ezcontentclass_attribute.id and ezcontentclass_attribute.version=0;
  81  
  82  delete from ezcontentobject_attribute;
  83  
  84  alter table ezcontentobject_attribute add data_type_string varchar(50) not null;
  85  
  86  -- alter table ezcontentobject_version add workflow_event_pos int(11) not null default '0';
  87  
  88  insert into ezcontentobject_attribute select * from ezcontent_attribute_tmp;
  89  drop table ezcontent_attribute_tmp;
  90  
  91  
  92  -- MySQL 4.1 upgrade
  93  --
  94  -- alter table ezcontentobject_attribute add data_type_string varchar(50) not null;
  95  --
  96  -- update ezcontentobject_attribute, ezcontentclass_attribute 
  97  -- set ezcontentobject_attribute.data_type_string=ezcontentclass_attribute.data_type_string 
  98  -- where ezcontentobject_attribute.contentclassattribute_id=ezcontentclass_attribute.id;
  99  
 100  
 101  CREATE TABLE ezimagefile (
 102    id INTEGER AUTO_INCREMENT NOT NULL,
 103    contentobject_attribute_id INTEGER NOT NULL,
 104    filepath TEXT NOT NULL,
 105    PRIMARY KEY ( id )
 106  ) TYPE=MyISAM;
 107  
 108  CREATE INDEX ezimagefile_coid ON ezimagefile( contentobject_attribute_id );
 109  CREATE INDEX ezimagefile_file ON ezimagefile( filepath(200) );
 110  
 111  
 112  CREATE TABLE ezview_counter (
 113    node_id int(11) NOT NULL default '0',
 114    count int(11) NOT NULL default '0',
 115    PRIMARY KEY  (node_id)
 116  ) TYPE=MyISAM;
 117  
 118  CREATE TABLE eztipafriend_counter (
 119    node_id int(11) NOT NULL default '0',
 120    count int(11) NOT NULL default '0',
 121    PRIMARY KEY  (node_id)
 122  ) TYPE=MyISAM;
 123  
 124  ALTER TABLE ezsubtree_notification_rule add user_id INT NOT NULL;
 125  
 126  CREATE TABLE tmp_notification_rule ( id INT PRIMARY KEY AUTO_INCREMENT,
 127                                       use_digest INT DEFAULT 0,
 128                                       node_id INT NOT NULL,
 129                                       user_id INT NOT NULL );
 130  
 131  INSERT INTO tmp_notification_rule ( use_digest, node_id, user_id ) SELECT rule.use_digest, rule.node_id, ezuser.contentobject_id AS user_id 
 132        FROM ezsubtree_notification_rule AS rule, ezuser 
 133        WHERE rule.address=ezuser.email;
 134  
 135  DROP TABLE ezsubtree_notification_rule;
 136  ALTER TABLE tmp_notification_rule rename ezsubtree_notification_rule;
 137  
 138  CREATE INDEX ezsubtree_notification_rule_id ON ezsubtree_notification_rule(id);
 139  CREATE INDEX ezsubtree_notification_rule_user_id ON ezsubtree_notification_rule(user_id);
 140  
 141  -- If you're upgrading the packages from 3.3.0-1 you must the following line also,
 142  -- it was missing from the previous release in the packages.
 143  --
 144