[Sommaire] [Imprimer]

   1  UPDATE ezsite_data SET value='3.8.0beta1' WHERE name='ezpublish-version';
   2  UPDATE ezsite_data SET value='3' WHERE name='ezpublish-release';
   3  
   4  -- Multilanguage fixes
   5  
   6  CREATE TABLE ezcontent_language
   7  (
   8      id int NOT NULL default '0',
   9      disabled int NOT NULL default '0',
  10      locale varchar(20) NOT NULL default '',
  11      name varchar(255) NOT NULL default '',
  12      PRIMARY KEY (id)
  13  );
  14                      
  15  DROP TABLE ezcontent_translation;
  16                   
  17  ALTER TABLE ezcontentobject ADD COLUMN language_mask int; 
  18  ALTER TABLE ezcontentobject ALTER COLUMN language_mask SET DEFAULT 0;
  19  ALTER TABLE ezcontentobject ALTER COLUMN language_mask SET NOT NULL;
  20  
  21  ALTER TABLE ezcontentobject ADD COLUMN initial_language_id int;
  22  ALTER TABLE ezcontentobject ALTER COLUMN initial_language_id SET DEFAULT 0;
  23  ALTER TABLE ezcontentobject ALTER COLUMN initial_language_id SET NOT NULL;
  24  
  25  ALTER TABLE ezcontentobject_name ADD COLUMN language_id int;
  26  ALTER TABLE ezcontentobject_name ALTER COLUMN language_id SET DEFAULT 0;
  27  ALTER TABLE ezcontentobject_name ALTER COLUMN language_id SET NOT NULL;
  28  
  29  ALTER TABLE ezcontentobject_attribute ADD COLUMN language_id int;
  30  ALTER TABLE ezcontentobject_attribute ALTER COLUMN language_id SET DEFAULT 0;
  31  ALTER TABLE ezcontentobject_attribute ALTER COLUMN language_id SET NOT NULL;
  32  
  33  ALTER TABLE ezcontentobject_version ADD COLUMN language_mask int;
  34  ALTER TABLE ezcontentobject_version ALTER COLUMN language_mask SET DEFAULT 0;
  35  ALTER TABLE ezcontentobject_version ALTER COLUMN language_mask SET NOT NULL;
  36  
  37  ALTER TABLE ezcontentobject_version ADD COLUMN initial_language_id int;
  38  ALTER TABLE ezcontentobject_version ALTER COLUMN initial_language_id SET DEFAULT 0;
  39  ALTER TABLE ezcontentobject_version ALTER COLUMN initial_language_id SET NOT NULL;
  40  
  41  ALTER TABLE ezcontentclass ADD COLUMN always_available int;
  42  ALTER TABLE ezcontentclass ALTER COLUMN always_available SET DEFAULT 0;
  43  ALTER TABLE ezcontentclass ALTER COLUMN always_available SET NOT NULL;
  44  
  45  ALTER TABLE ezcontentobject_link ADD COLUMN op_code int;
  46  ALTER TABLE ezcontentobject_link ALTER COLUMN op_code SET DEFAULT 0;
  47  ALTER TABLE ezcontentobject_link ALTER COLUMN op_code SET NOT NULL;
  48  
  49  ALTER TABLE eznode_assignment ADD COLUMN op_code int;
  50  ALTER TABLE eznode_assignment ALTER COLUMN op_code SET DEFAULT 0;
  51  ALTER TABLE eznode_assignment ALTER COLUMN op_code SET NOT NULL;
  52  
  53  -- updates
  54  -- set correct op_code
  55  -- mark as being moved
  56  update eznode_assignment set op_code=4 where from_node_id > 0 and op_code=0;
  57  -- mark as being created
  58  update eznode_assignment set op_code=2 where from_node_id <= 0 and op_code=0;
  59  -- mark as being set
  60  update eznode_assignment set op_code=2 where remote_id != 0 and op_code=0;
  61  
  62  CREATE INDEX ezcontentobject_lmask ON ezcontentobject USING btree ( language_mask );
  63  
  64  -- Now remember to run ./update/common/scripts/updatemultilingual.php before using the site
  65  
  66  -- Information collection improvments
  67  ALTER TABLE ezinfocollection ADD creator_id INT;
  68  ALTER TABLE ezinfocollection ALTER COLUMN creator_id SET DEFAULT 0;
  69  ALTER TABLE ezinfocollection ALTER COLUMN creator_id SET NOT NULL;