[Sommaire] [Imprimer]

   1  UPDATE ezsite_data SET value='3.9.0alpha1' WHERE name='ezpublish-version';
   2  UPDATE ezsite_data SET value='1' WHERE name='ezpublish-release';
   3  
   4  -- START: from 3.8.1
   5  CREATE INDEX ezkeyword_keyword_id ON ezkeyword ( keyword, id );
   6  CREATE INDEX ezkeyword_attr_link_kid_oaid ON ezkeyword_attribute_link ( keyword_id, objectattribute_id );
   7  
   8  CREATE INDEX ezurlalias_is_wildcard ON ezurlalias( is_wildcard );
   9  
  10  CREATE INDEX eznode_assignment_coid_cov ON eznode_assignment( contentobject_id,contentobject_version );
  11  CREATE INDEX eznode_assignment_is_main ON eznode_assignment( is_main );
  12  CREATE INDEX eznode_assignment_parent_node ON eznode_assignment( parent_node );
  13  -- END: from 3.8.1
  14  
  15  ALTER TABLE ezuservisit ADD COLUMN failed_login_attempts int NOT NULL DEFAULT 0;
  16  
  17  ALTER TABLE ezcontentobject_link ADD COLUMN relation_type int NOT NULL DEFAULT 1;
  18  UPDATE ezcontentobject_link SET relation_type=8 WHERE contentclassattribute_id<>0;
  19  
  20  -- START: 'default sorting' attribute for ezcontentclass
  21  ALTER TABLE ezcontentclass ADD COLUMN sort_field int NOT NULL DEFAULT 1;
  22  ALTER TABLE ezcontentclass ADD COLUMN sort_order int NOT NULL DEFAULT 1;
  23  -- END: 'default sorting' attribute for ezcontentclass
  24  
  25  -- START: new table for trash
  26  CREATE TABLE ezcontentobject_trash (
  27    contentobject_id int(11) default NULL,
  28    contentobject_version int(11) default NULL,
  29    depth int(11) NOT NULL default '0',
  30    is_hidden int(11) NOT NULL default '0',
  31    is_invisible int(11) NOT NULL default '0',
  32    main_node_id int(11) default NULL,
  33    modified_subnode int(11) default '0',
  34    node_id int(11) NOT NULL,
  35    parent_node_id int(11) NOT NULL default '0',
  36    path_identification_string longtext,
  37    path_string varchar(255) NOT NULL default '',
  38    priority int(11) NOT NULL default '0',
  39    remote_id varchar(100) NOT NULL default '',
  40    sort_field int(11) default '1',
  41    sort_order int(11) default '1',
  42    PRIMARY KEY  (node_id)
  43  );
  44  ALTER TABLE ezcontentobject_trash ADD INDEX ezcobj_trash_co_id (contentobject_id);
  45  ALTER TABLE ezcontentobject_trash ADD INDEX ezcobj_trash_depth (depth);
  46  ALTER TABLE ezcontentobject_trash ADD INDEX ezcobj_trash_p_node_id (parent_node_id);
  47  ALTER TABLE ezcontentobject_trash ADD INDEX ezcobj_trash_path (path_string);
  48  ALTER TABLE ezcontentobject_trash ADD INDEX ezcobj_trash_path_ident (path_identification_string(50));
  49  ALTER TABLE ezcontentobject_trash ADD INDEX ezcobj_trash_modified_subnode (modified_subnode);
  50  -- END: new table for trash
  51  
  52  -- START: ezcontentclass/ezcontentclass_attribute translations
  53  ALTER TABLE ezcontentclass CHANGE name serialized_name_list varchar(255) default NULL;
  54  ALTER TABLE ezcontentclass ADD COLUMN language_mask int NOT NULL DEFAULT 0;
  55  ALTER TABLE ezcontentclass ADD COLUMN initial_language_id int NOT NULL DEFAULT 0;
  56  ALTER TABLE ezcontentclass_attribute CHANGE name serialized_name_list varchar(255) NOT NULL default '';
  57  
  58  CREATE TABLE ezcontentclass_name
  59  (
  60      contentclass_id int NOT NULL default '0',
  61      contentclass_version int NOT NULL default '0',
  62      language_locale varchar(20) NOT NULL default '',
  63      language_id int NOT NULL default '0',
  64      name varchar(255) NOT NULL default '',
  65      PRIMARY KEY (contentclass_id, contentclass_version, language_id)
  66  );
  67  -- END: ezcontentclass/ezcontentclass_attribute translations
  68  
  69  -- START: eztipafriend_counter, new column and primary key (new fetch function for tipafriend_top_list)
  70  ALTER TABLE eztipafriend_counter ADD COLUMN requested int NOT NULL DEFAULT 0;
  71  ALTER TABLE eztipafriend_counter DROP PRIMARY KEY;
  72  ALTER TABLE eztipafriend_counter ADD PRIMARY KEY (node_id, requested);
  73  -- END: eztipafriend_counter, new column and primary key (new fetch function for tipafriend_top_list)
  74  
  75  -- START: improvements in shop(better vat handling of order items, like shipping)
  76  ALTER TABLE ezorder_item ADD COLUMN is_vat_inc int default '0' NOT NULL;
  77  -- END: improvements in shop(better vat handling of order items, like shipping)