[Sommaire] [Imprimer]

   1  alter table ezsearch_object_word_link add column identifier varchar(255) not null default '';
   2  alter table ezsearch_object_word_link add column integer_value integer not null default '0';
   3  
   4  CREATE TABLE ezcollab_notification_rule (
   5      id integer  auto_increment NOT NULL,
   6      user_id varchar(255) NOT NULL,
   7      collab_identifier varchar(255) not null,
   8      primary key ( id )
   9  );
  10  
  11  CREATE TABLE ezurl_object_link (
  12    url_id int(11) NOT NULL default '0',
  13    contentobject_attribute_id int(11) NOT NULL default '0',
  14    contentobject_attribute_version int(11) NOT NULL default '0',
  15    PRIMARY KEY (url_id,contentobject_attribute_id,contentobject_attribute_version)
  16  );
  17  
  18  
  19  CREATE TABLE ezsite_data (
  20    id int(11) auto_increment NOT NULL,
  21    name varchar(60) NOT NULL default '',
  22    value text NOT NULL default '',
  23    PRIMARY KEY (id)
  24  );
  25  
  26  drop index ezcontentobject_tree_depth on ezcontentobject_tree;
  27  create index ezsearch_word_object_count on ezsearch_word(object_count);
  28  create index ezcontentobject_status on ezcontentobject( status );
  29  create index ezcontentobject_tree_path_depth on ezcontentobject_tree( path_string, depth );
  30  
  31  alter table ezcontentclass_attribute add can_translate int default 1;
  32  alter table ezcontentobject_attribute add attribute_original_id int default 0;
  33  
  34  create table ezurlalias
  35  (
  36    id int(11) auto_increment NOT NULL,
  37    source_url text not null,
  38    source_md5 char(32),
  39    destination_url text not null,
  40    is_internal int not null default 1,
  41    forward_to_id int not null,  
  42    PRIMARY KEY (id)
  43  );
  44  
  45  create index ezurlalias_source_md5 on ezurlalias( source_md5 );
  46  
  47  insert into ezurlalias ( source_url, source_md5, destination_url, is_internal ) select path_identification_string, md5( path_identification_string ), concat( 'content/view/full/', node_id ), 1 from ezcontentobject_tree where node_id <> 1;
  48  
  49  # Drop unneeded columns
  50  alter table ezcontentobject_tree drop md5_path;
  51  alter table ezcontentobject_tree drop crc32_path;
  52  
  53  create table ezpreferences
  54  (
  55    id int(11) auto_increment NOT NULL,
  56    user_id int(11) NOT NULL,
  57    name varchar(100),
  58    value varchar(100),
  59    PRIMARY KEY (id)
  60  );
  61  
  62  create index ezpreferences_name on ezpreferences( name );
  63  
  64  alter table ezcontentobject_attribute add sort_key_int int not null default 0;
  65  alter table ezcontentobject_attribute add sort_key_string varchar(50) not null default '';
  66  
  67  ## Updates from sort_key to sort_key_int and sort_key_string
  68  # Not needed if you don't upgrade from an svn version of 3.2
  69  # update ezcontentobject_attribute set sort_key_int=sort_key;
  70  # update ezcontentobject_attribute set sort_key_string=sort_key;
  71  # alter table  ezcontentobject_attribute drop sort_key;
  72  
  73  
  74  ALTER TABLE ezcontentobject_attribute ADD index ( sort_key_int );
  75  ALTER TABLE ezcontentobject_attribute ADD index ( sort_key_string );
  76  
  77  
  78  CREATE INDEX ezorder_item_order_id ON ezorder_item( order_id );
  79  CREATE INDEX ezproductcollection_item_productcollection_id ON ezproductcollection_item( productcollection_id );
  80  CREATE INDEX ezurlalias_source_url ON ezurlalias(source_url(255));
  81  CREATE INDEX ezcontentobject_attribute_co_id_ver_lang_code ON ezcontentobject_attribute( contentobject_id, version, language_code);
  82  
  83  
  84  INSERT INTO ezsite_data (name, value) VALUES('ezpublish-version', '3.2');
  85  INSERT INTO ezsite_data (name, value) VALUES('ezpublish-release', '1');