[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  
  27  drop index ezcontentobject_tree_depth on ezcontentobject_tree;
  28  create index ezsearch_word_object_count on ezsearch_word(object_count);
  29  create index ezcontentobject_status on ezcontentobject( status );
  30  create index ezcontentobject_tree_path_depth on ezcontentobject_tree( path_string, depth );
  31  
  32  alter table ezcontentclass_attribute add can_translate int default 1;
  33  alter table ezcontentobject_attribute add attribute_original_id int default 0;
  34  
  35  create table ezurlalias
  36  (
  37    id int(11) auto_increment NOT NULL,
  38    source_url text not null,
  39    source_md5 char(32),
  40    destination_url text not null,
  41    is_internal int not null default 1,
  42    forward_to_id int not null,  
  43    PRIMARY KEY (id)
  44  );
  45  
  46  create index ezurlalias_source_md5 on ezurlalias( source_md5 );
  47  
  48  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;
  49  
  50  # Drop unneeded columns
  51  alter table ezcontentobject_tree drop md5_path;
  52  alter table ezcontentobject_tree drop crc32_path;
  53  
  54  create table ezpreferences
  55  (
  56    id int(11) auto_increment NOT NULL,
  57    user_id int(11) NOT NULL,
  58    name varchar(100),
  59    value varchar(100),
  60    PRIMARY KEY (id)
  61  );
  62  
  63  create index ezpreferences_name on ezpreferences( name );
  64  
  65  alter table ezcontentobject_attribute add sort_key_int int not null default 0;
  66  alter table ezcontentobject_attribute add sort_key_string varchar(50) not null default '';
  67  
  68  ## Updates from sort_key to sort_key_int and sort_key_string
  69  # Not needed if you don not upgrade from an svn version of 3.2
  70  # update ezcontentobject_attribute set sort_key_int=sort_key;
  71  # update ezcontentobject_attribute set sort_key_string=sort_key;
  72  # alter table  ezcontentobject_attribute drop sort_key;
  73  
  74  
  75  ALTER TABLE ezcontentobject_attribute ADD index ( sort_key_int );
  76  ALTER TABLE ezcontentobject_attribute ADD index ( sort_key_string );
  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  ALTER TABLE ezsite_data DROP COLUMN id;
  85  ALTER TABLE ezsite_data ADD PRIMARY KEY ( name );
  86  
  87  INSERT INTO ezsite_data (name, value) VALUES('ezpublish-version', '3.2');
  88  INSERT INTO ezsite_data (name, value) VALUES('ezpublish-release', '1');