[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;
   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  
 124  -- Multilanguage fixes
 125  
 126  CREATE TABLE ezcontent_language
 127  (
 128      id int NOT NULL default '0',
 129      disabled int NOT NULL default '0',
 130      locale varchar(20) NOT NULL default '',
 131      name varchar(255) NOT NULL default '',
 132      PRIMARY KEY (id)
 133  );
 134                      
 135  DROP TABLE ezcontent_translation;
 136                   
 137  ALTER TABLE ezcontentobject ADD COLUMN language_mask int; 
 138  ALTER TABLE ezcontentobject ALTER COLUMN language_mask SET DEFAULT 0;
 139  ALTER TABLE ezcontentobject ALTER COLUMN language_mask SET NOT NULL;
 140  
 141  ALTER TABLE ezcontentobject ADD COLUMN initial_language_id int;
 142  ALTER TABLE ezcontentobject ALTER COLUMN initial_language_id SET DEFAULT 0;
 143  ALTER TABLE ezcontentobject ALTER COLUMN initial_language_id SET NOT NULL;
 144  
 145  ALTER TABLE ezcontentobject_name ADD COLUMN language_id int;
 146  ALTER TABLE ezcontentobject_name ALTER COLUMN language_id SET DEFAULT 0;
 147  ALTER TABLE ezcontentobject_name ALTER COLUMN language_id SET NOT NULL;
 148  
 149  ALTER TABLE ezcontentobject_attribute ADD COLUMN language_id int;
 150  ALTER TABLE ezcontentobject_attribute ALTER COLUMN language_id SET DEFAULT 0;
 151  ALTER TABLE ezcontentobject_attribute ALTER COLUMN language_id SET NOT NULL;
 152  
 153  ALTER TABLE ezcontentobject_version ADD COLUMN language_mask int;
 154  ALTER TABLE ezcontentobject_version ALTER COLUMN language_mask SET DEFAULT 0;
 155  ALTER TABLE ezcontentobject_version ALTER COLUMN language_mask SET NOT NULL;
 156  
 157  ALTER TABLE ezcontentobject_version ADD COLUMN initial_language_id int;
 158  ALTER TABLE ezcontentobject_version ALTER COLUMN initial_language_id SET DEFAULT 0;
 159  ALTER TABLE ezcontentobject_version ALTER COLUMN initial_language_id SET NOT NULL;
 160  
 161  ALTER TABLE ezcontentclass ADD COLUMN always_available int;
 162  ALTER TABLE ezcontentclass ALTER COLUMN always_available SET DEFAULT 0;
 163  ALTER TABLE ezcontentclass ALTER COLUMN always_available SET NOT NULL;
 164  
 165  ALTER TABLE ezcontentobject_link ADD COLUMN op_code int;
 166  ALTER TABLE ezcontentobject_link ALTER COLUMN op_code SET DEFAULT 0;
 167  ALTER TABLE ezcontentobject_link ALTER COLUMN op_code SET NOT NULL;
 168  
 169  ALTER TABLE eznode_assignment ADD COLUMN op_code int;
 170  ALTER TABLE eznode_assignment ALTER COLUMN op_code SET DEFAULT 0;
 171  ALTER TABLE eznode_assignment ALTER COLUMN op_code SET NOT NULL;
 172  
 173  -- updates
 174  -- set correct op_code
 175  -- mark as being moved
 176  update eznode_assignment set op_code=4 where from_node_id > 0 and op_code=0;
 177  -- mark as being created
 178  update eznode_assignment set op_code=2 where from_node_id <= 0 and op_code=0;
 179  -- mark as being set
 180  update eznode_assignment set op_code=2 where remote_id != 0 and op_code=0;
 181  
 182  CREATE INDEX ezcontentobject_lmask ON ezcontentobject USING btree ( language_mask );
 183  
 184  -- Now remember to run ./update/common/scripts/updatemultilingual.php before using the site
 185  
 186  -- Information collection improvments
 187  ALTER TABLE ezinfocollection ADD creator_id INT;
 188  ALTER TABLE ezinfocollection ALTER COLUMN creator_id SET DEFAULT 0;
 189  ALTER TABLE ezinfocollection ALTER COLUMN creator_id SET NOT NULL;