[Sommaire] [Imprimer]

   1  UPDATE ezsite_data SET value='3.8.0alpha1' WHERE name='ezpublish-version';
   2  UPDATE ezsite_data SET value='1' 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