[Sommaire] [Imprimer]

   1  UPDATE ezsite_data SET value='3.6.0beta1' WHERE name='ezpublish-version';
   2  UPDATE ezsite_data SET value='1' WHERE name='ezpublish-release';
   3  
   4  ALTER TABLE ezrss_export_item ADD subnodes INT(11) UNSIGNED DEFAULT '0' NOT NULL;
   5  
   6  ALTER TABLE ezrss_export ADD number_of_objects INT(11) UNSIGNED DEFAULT '0' NOT NULL;
   7  -- Old behaviour of RSS was that it fed 5 items
   8  UPDATE ezrss_export SET number_of_objects='5';
   9  
  10  ALTER TABLE ezrss_export ADD main_node_only INT(11) UNSIGNED DEFAULT '1' NOT NULL;
  11  -- Old behaviour of RSS was that all nodes have been shown,
  12  -- i.e. including those besides the main node
  13  UPDATE ezrss_export SET main_node_only='0';
  14  
  15  ALTER TABLE ezcontentobject_link ADD contentclassattribute_id INT(11) UNSIGNED DEFAULT '0' NOT NULL;
  16  CREATE INDEX ezco_link_to_co_id ON ezcontentobject_link ( to_contentobject_id );
  17  CREATE INDEX ezco_link_from     ON ezcontentobject_link ( from_contentobject_id,
  18                                                            from_contentobject_version,
  19                                                            contentclassattribute_id );
  20  
  21  
  22  
  23  -- Add missing index for orders
  24  ALTER TABLE ezorder ADD INDEX ezorder_is_tmp (is_temporary);
  25  
  26  -- New feature: Status on orders
  27  
  28  ALTER TABLE ezorder ADD status_id int DEFAULT 0;
  29  ALTER TABLE ezorder ADD status_modified int DEFAULT 0;
  30  ALTER TABLE ezorder ADD status_modifier_id int DEFAULT 0;
  31  
  32  CREATE TABLE ezorder_status (
  33      id int(11) NOT NULL auto_increment,
  34      status_id int(11) NOT NULL DEFAULT 0,
  35      name varchar(255) NOT NULL DEFAULT '',
  36      is_active int(11) NOT NULL DEFAULT 1,
  37      PRIMARY KEY (id)
  38  );
  39  
  40  ALTER TABLE ezorder_status ADD INDEX ezorder_status_sid (status_id);
  41  ALTER TABLE ezorder_status ADD INDEX ezorder_status_name (name);
  42  ALTER TABLE ezorder_status ADD INDEX ezorder_status_active (is_active);
  43  
  44  INSERT INTO ezorder_status (status_id, name, is_active)
  45  VALUES( 1, 'Pending', 1 );
  46  INSERT INTO ezorder_status (status_id, name, is_active)
  47  VALUES( 2, 'Processing', 1 );
  48  INSERT INTO ezorder_status (status_id, name, is_active)
  49  VALUES( 3, 'Delivered', 1 );
  50  
  51  CREATE TABLE ezorder_status_history (
  52      id int(11) NOT NULL auto_increment,
  53      order_id int(11) NOT NULL DEFAULT 0,
  54      status_id int(11) NOT NULL DEFAULT 0,
  55      modifier_id int(11) NOT NULL DEFAULT 0,
  56      modified int(11) NOT NULL DEFAULT 0,
  57      PRIMARY KEY (id)
  58  );
  59  
  60  ALTER TABLE ezorder_status_history ADD INDEX ezorder_status_history_oid (order_id);
  61  ALTER TABLE ezorder_status_history ADD INDEX ezorder_status_history_sid (status_id);
  62  ALTER TABLE ezorder_status_history ADD INDEX ezorder_status_history_mod (modified);
  63  
  64  
  65  -- Make sure each order has a history element with Pending status
  66  INSERT INTO ezorder_status_history (order_id, status_id, modifier_id, modified)
  67  SELECT order_nr AS order_id, 1 AS status_id, user_id AS modifier_id, created AS modified FROM ezorder WHERE status_id = 0;
  68  -- Update status of all orders to Pending
  69  UPDATE ezorder SET status_id = 1, status_modifier_id = user_id, status_modified = created WHERE status_id = 0;