[Sommaire] [Imprimer]

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