[Sommaire] [Imprimer]

   1  UPDATE ezsite_data SET value='3.8.0' WHERE name='ezpublish-version';
   2  UPDATE ezsite_data SET value='6' WHERE name='ezpublish-release';
   3  
   4  ALTER TABLE ezorder ADD is_archived INT DEFAULT '0' NOT NULL;
   5  ALTER TABLE ezorder ADD INDEX ezorder_is_archived (is_archived);
   6  ALTER TABLE ezorder_item ADD type VARCHAR(30);
   7  ALTER TABLE ezorder_item ADD INDEX ezorder_item_type ( type ) ;
   8  
   9  
  10  -- Improved Approval Workflow -- START --
  11  UPDATE ezworkflow_event set data_text3=data_int1;
  12  -- Improved Approval Workflow --  END  --
  13  
  14  UPDATE ezpolicy SET function_name='administrate' WHERE module_name='shop' AND function_name='adminstrate';
  15  
  16  -- Improved RSS import. -- START --
  17  ALTER TABLE ezrss_import ADD COLUMN import_description longtext NOT NULL DEFAULT '';
  18  -- Improved RSS import. -- END --
  19  
  20  -- Multicurrency. -- START --
  21  CREATE TABLE ezcurrencydata (
  22    id int(11) NOT NULL auto_increment,
  23    code varchar(4) NOT NULL default '',
  24    symbol varchar(255) NOT NULL default '',
  25    locale varchar(255) NOT NULL default '',
  26    status int(11) NOT NULL default '1',
  27    auto_rate_value numeric(10,5) NOT NULL default '0.00000',
  28    custom_rate_value numeric(10,5) NOT NULL default '0.00000',
  29    rate_factor numeric(10,5) NOT NULL default '1.00000',
  30    PRIMARY KEY (id)
  31  );
  32  
  33  ALTER TABLE ezcurrencydata ADD INDEX ezcurrencydata_code (code);
  34  
  35  
  36  CREATE TABLE ezmultipricedata (
  37    id int(11) NOT NULL auto_increment,
  38    contentobject_attr_id int(11) NOT NULL default '0',
  39    contentobject_attr_version int(11) NOT NULL default '0',
  40    currency_code varchar(4) NOT NULL default '',
  41    value numeric(15,2) NOT NULL default '0.00',
  42    type int(11) NOT NULL default '0',
  43    PRIMARY KEY (id)
  44  );
  45  
  46  ALTER TABLE ezmultipricedata ADD INDEX ezmultipricedata_coa_id (contentobject_attr_id);
  47  ALTER TABLE ezmultipricedata ADD INDEX ezmultipricedata_coa_version (contentobject_attr_version);
  48  ALTER TABLE ezmultipricedata ADD INDEX ezmultipricedata_currency_code (currency_code);
  49  
  50  ALTER TABLE ezproductcollection ADD COLUMN currency_code varchar(4) NOT NULL default '';
  51  -- Multicurrency. -- END --
  52  
  53  -- Improved packages system -- START --
  54  CREATE TABLE `ezpackage` (
  55    `id` int(11) unsigned NOT NULL auto_increment,
  56    `name` varchar(100) NOT NULL default '',
  57    `version` varchar(30) NOT NULL default '0',
  58    `install_date` int(11) NOT NULL,
  59    PRIMARY KEY  (`id`)
  60  );
  61  -- Improved packages system -- END --
  62  
  63  -- VAT charging rules -- START --
  64  CREATE TABLE ezproductcategory (
  65    id int(11) NOT NULL auto_increment,
  66    name varchar(255) NOT NULL default '',
  67    PRIMARY KEY (id)
  68  );
  69  
  70  CREATE TABLE ezvatrule (
  71    id int(11) NOT NULL auto_increment,
  72    country varchar(255) NOT NULL default '',
  73    vat_type int(11) NOT NULL,
  74    PRIMARY KEY (id)
  75  );
  76  
  77  CREATE TABLE ezvatrule_product_category (
  78    vatrule_id int(11) NOT NULL,
  79    product_category_id int(11) NOT NULL,
  80    PRIMARY KEY (vatrule_id, product_category_id)
  81  );
  82  -- VAT charging rules -- END --
  83  
  84  -- Multilanguage fixes
  85  
  86  CREATE TABLE ezcontent_language
  87  (
  88      id int NOT NULL default '0',
  89      disabled int NOT NULL default '0',
  90      locale varchar(20) NOT NULL default '',
  91      name varchar(255) NOT NULL default '',
  92      PRIMARY KEY (id)
  93  );
  94                      
  95  DROP TABLE ezcontent_translation;
  96                   
  97  ALTER TABLE ezcontentobject ADD COLUMN language_mask int NOT NULL DEFAULT 0;
  98  ALTER TABLE ezcontentobject ADD COLUMN initial_language_id int NOT NULL DEFAULT 0;
  99  
 100  ALTER TABLE ezcontentobject_name ADD COLUMN language_id int NOT NULL DEFAULT 0;
 101  
 102  ALTER TABLE ezcontentobject_attribute ADD COLUMN language_id int NOT NULL DEFAULT 0;
 103  
 104  ALTER TABLE ezcontentobject_version ADD COLUMN language_mask int NOT NULL DEFAULT 0;
 105  ALTER TABLE ezcontentobject_version ADD COLUMN initial_language_id int NOT NULL DEFAULT 0;
 106  
 107  ALTER TABLE ezcontentclass ADD COLUMN always_available int NOT NULL DEFAULT 0;
 108  
 109  ALTER TABLE ezcontentobject_link ADD COLUMN op_code int NOT NULL DEFAULT 0;
 110  
 111  ALTER TABLE eznode_assignment ADD COLUMN op_code int NOT NULL DEFAULT 0;
 112  
 113  -- updates
 114  -- set correct op_code
 115  -- mark as being moved
 116  update eznode_assignment set op_code=4 where from_node_id > 0 and op_code=0;
 117  -- mark as being created
 118  update eznode_assignment set op_code=2 where from_node_id <= 0 and op_code=0;
 119  -- mark as being set
 120  update eznode_assignment set op_code=2 where remote_id != 0 and op_code=0;
 121  
 122  ALTER TABLE ezcontentobject ADD INDEX ezcontentobject_lmask ( language_mask ) ;
 123  
 124  -- Now remember to run ./update/common/scripts/updatemultilingual.php before using the site
 125  
 126  -- Information collection improvments
 127  ALTER TABLE ezinfocollection ADD COLUMN creator_id int NOT NULL DEFAULT 0;