[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 NOT NULL DEFAULT 0;
  18  ALTER TABLE ezcontentobject ADD COLUMN initial_language_id int NOT NULL DEFAULT 0;
  19  
  20  ALTER TABLE ezcontentobject_name ADD COLUMN language_id int NOT NULL DEFAULT 0;
  21  
  22  ALTER TABLE ezcontentobject_attribute ADD COLUMN language_id int NOT NULL DEFAULT 0;
  23  
  24  ALTER TABLE ezcontentobject_version ADD COLUMN language_mask int NOT NULL DEFAULT 0;
  25  ALTER TABLE ezcontentobject_version ADD COLUMN initial_language_id int NOT NULL DEFAULT 0;
  26  
  27  ALTER TABLE ezcontentclass ADD COLUMN always_available int NOT NULL DEFAULT 0;
  28  
  29  ALTER TABLE ezcontentobject_link ADD COLUMN op_code int NOT NULL DEFAULT 0;
  30  
  31  ALTER TABLE eznode_assignment ADD COLUMN op_code int NOT NULL DEFAULT 0;
  32  
  33  -- updates
  34  -- set correct op_code
  35  -- mark as being moved
  36  update eznode_assignment set op_code=4 where from_node_id > 0 and op_code=0;
  37  -- mark as being created
  38  update eznode_assignment set op_code=2 where from_node_id <= 0 and op_code=0;
  39  -- mark as being set
  40  update eznode_assignment set op_code=2 where remote_id != 0 and op_code=0;
  41  
  42  ALTER TABLE ezcontentobject ADD INDEX ezcontentobject_lmask ( language_mask ) ;
  43  
  44  -- Now remember to run ./update/common/scripts/updatemultilingual.php before using the site
  45  
  46  -- Information collection improvments
  47  ALTER TABLE ezinfocollection ADD COLUMN creator_id int NOT NULL DEFAULT 0;