[Sommaire] [Imprimer]

   1  UPDATE ezsite_data SET value='3.4.0alpha3' WHERE name='ezpublish-version';
   2  UPDATE ezsite_data SET value='3' WHERE name='ezpublish-release';
   3  
   4  ALTER TABLE ezcontentclass ADD COLUMN remote_id varchar(100);
   5  UPDATE ezcontentclass SET remote_id='';
   6  ALTER TABLE ezcontentclass ALTER remote_id SET NOT NULL;
   7  ALTER TABLE ezcontentclass ALTER remote_id SET default '';
   8  
   9  ALTER TABLE ezcontentobject_tree ADD COLUMN remote_id varchar(100);
  10  UPDATE ezcontentobject_tree SET remote_id='';
  11  ALTER TABLE ezcontentobject_tree ALTER remote_id SET NOT NULL;
  12  ALTER TABLE ezcontentobject_tree ALTER remote_id SET default '';
  13  
  14  ALTER TABLE eznode_assignment ADD COLUMN parent_remote_id varchar(100);
  15  UPDATE eznode_assignment SET parent_remote_id='';
  16  ALTER TABLE eznode_assignment ALTER parent_remote_id SET NOT NULL;
  17  ALTER TABLE eznode_assignment ALTER parent_remote_id SET default '';
  18  
  19  ALTER TABLE ezsession ADD COLUMN user_id integer;
  20  UPDATE ezsession SET user_id=0;
  21  ALTER TABLE ezsession ALTER user_id SET NOT NULL;
  22  ALTER TABLE ezsession ALTER user_id SET DEFAULT 0;
  23  CREATE INDEX ezsession_user_id ON ezsession ( user_id );
  24  ALTER TABLE ezsession ALTER user_id DROP NOT NULL;
  25  UPDATE ezsession SET user_id=(SELECT ezuser_session_link.user_id FROM ezuser_session_link, ezsession WHERE ezsession.session_key=ezuser_session_link.session_key);
  26  UPDATE ezsession SET user_id=0 WHERE user_id IS NULL;
  27  ALTER TABLE ezsession ALTER user_id SET NOT NULL;
  28  DROP TABLE ezuser_session_link;