[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) NOT NULL default '';
   5  ALTER TABLE ezcontentobject_tree ADD COLUMN remote_id varchar(100) NOT NULL default '';
   6  
   7  ALTER TABLE eznode_assignment ADD COLUMN parent_remote_id varchar(100) NOT NULL default '';
   8  
   9  CREATE TABLE tmp_ezsession AS
  10  SELECT ezsession.*, ezuser_session_link.user_id FROM ezsession, ezuser_session_link
  11   WHERE ezsession.session_key=ezuser_session_link.session_key;
  12  
  13  DELETE FROM ezsession;
  14  
  15  ALTER TABLE ezsession ADD COLUMN user_id integer NOT NULL default 0;
  16  
  17  INSERT INTO ezsession SELECT * FROM tmp_ezsession;
  18  
  19  CREATE INDEX ezsession_user_id ON ezsession ( user_id );
  20  
  21  DROP TABLE tmp_ezsession;
  22  
  23  DROP TABLE ezuser_session_link;