[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;
   5  UPDATE ezorder SET is_archived='0';
   6  ALTER TABLE ezorder ALTER COLUMN is_archived SET DEFAULT 0;
   7  ALTER TABLE ezorder ALTER COLUMN is_archived SET NOT NULL;
   8  ALTER TABLE ezorder_item ADD type VARCHAR(30);
   9  
  10  CREATE INDEX ezorder_is_archived ON ezorder USING btree (is_archived);
  11  CREATE INDEX ezorder_item_type ON ezorder_item USING btree (type);
  12  
  13  
  14  -- Improved Approval Workflow -- START --
  15  UPDATE ezworkflow_event set data_text3=data_int1;
  16  -- Improved Approval Workflow --  END  --
  17  
  18  UPDATE ezpolicy SET function_name='administrate' WHERE module_name='shop' AND function_name='adminstrate';
  19  
  20  
  21  -- Improved RSS import. -- START --
  22  ALTER TABLE ezrss_import ADD COLUMN import_description text;
  23  ALTER TABLE ezrss_import ALTER import_description SET NOT NULL;
  24  ALTER TABLE ezrss_import ALTER import_description SET DEFAULT '';
  25  -- Improved RSS import. -- END --
  26  
  27  -- Multicurrency. -- START --
  28  CREATE SEQUENCE ezcurrencydata_s
  29      START 1
  30      INCREMENT 1
  31      MAXVALUE 9223372036854775807
  32      MINVALUE 1
  33      CACHE 1;
  34  
  35  
  36  CREATE TABLE ezcurrencydata (
  37    id integer NOT NULL DEFAULT nextval('ezcurrencydata_s'::text),
  38    code varchar(4) NOT NULL default '',
  39    symbol varchar(255) NOT NULL default '',
  40    locale varchar(255) NOT NULL default '',
  41    status integer NOT NULL default 1,
  42    auto_rate_value numeric(10,5) NOT NULL default '0.00000',
  43    custom_rate_value numeric(10,5) NOT NULL default '0.00000',
  44    rate_factor numeric(10,5) NOT NULL default '1.00000'
  45  );
  46  
  47  ALTER TABLE ONLY ezcurrencydata
  48      ADD CONSTRAINT ezcurrencydata_pkey PRIMARY KEY (id);
  49  
  50  CREATE INDEX ezcurrencydata_code ON ezcurrencydata USING btree (code);
  51  
  52  
  53  CREATE SEQUENCE ezmultipricedata_s
  54      START 1
  55      INCREMENT 1
  56      MAXVALUE 9223372036854775807
  57      MINVALUE 1
  58      CACHE 1;
  59  
  60  CREATE TABLE ezmultipricedata (
  61    id integer NOT NULL DEFAULT nextval('ezmultipricedata_s'::text),
  62    contentobject_attr_id integer NOT NULL default 0,
  63    contentobject_attr_version integer NOT NULL default 0,
  64    currency_code varchar(4) NOT NULL default '',
  65    value numeric(15,2) NOT NULL default '0.00',
  66    type integer NOT NULL default 0
  67  );
  68  
  69  ALTER TABLE ONLY ezmultipricedata
  70      ADD CONSTRAINT ezmultipricedata_pkey PRIMARY KEY (id);
  71  
  72  CREATE INDEX ezmultipricedata_coa_id ON ezmultipricedata USING btree (contentobject_attr_id);
  73  CREATE INDEX ezmultipricedata_coa_version ON ezmultipricedata USING btree (contentobject_attr_version);
  74  CREATE INDEX ezmultipricedata_currency_code ON ezmultipricedata USING btree (currency_code);
  75  
  76  
  77  ALTER TABLE ezproductcollection ADD currency_code varchar(4);
  78  ALTER TABLE ezproductcollection ALTER currency_code SET NOT NULL;
  79  ALTER TABLE ezproductcollection ALTER currency_code SET DEFAULT '';
  80  -- Multicurrency. -- END --
  81  
  82  -- Improved packages system -- START --
  83  CREATE SEQUENCE ezpackage_s
  84         START 1
  85         INCREMENT 1
  86         MAXVALUE 9223372036854775807
  87         MINVALUE 1
  88         CACHE 1;
  89  
  90  CREATE TABLE ezpackage (
  91    id integer NOT NULL DEFAULT nextval('ezpackage_s'::text),
  92    name varchar(100) NOT NULL default '',
  93    version varchar(30) NOT NULL default '0',
  94    install_date integer NOT NULL,
  95    PRIMARY KEY  (id)
  96  );
  97  -- Improved packages system -- END --
  98  
  99  -- VAT charging rules -- START --
 100  CREATE SEQUENCE ezproductcategory_s;
 101  CREATE TABLE ezproductcategory (
 102    id INTEGER NOT NULL DEFAULT nextval('ezproductcategory_s'),
 103    name VARCHAR(255) NOT NULL default '',
 104    PRIMARY KEY (id)
 105  );
 106  
 107  CREATE SEQUENCE ezvatrule_s;
 108  CREATE TABLE ezvatrule (
 109    id INTEGER NOT NULL DEFAULT nextval('ezvatrule_s'),
 110    country VARCHAR(255) NOT NULL default '',
 111    vat_type INTEGER NOT NULL,
 112    PRIMARY KEY (id)
 113  );
 114  
 115  CREATE TABLE ezvatrule_product_category (
 116    vatrule_id INTEGER NOT NULL,
 117    product_category_id INTEGER NOT NULL
 118  );
 119  
 120  ALTER TABLE ONLY ezvatrule_product_category
 121      ADD CONSTRAINT ezvatrule_product_category_pkey PRIMARY KEY (vatrule_id, product_category_id);
 122  -- VAT charging rules -- END --
 123