[Sommaire] [Imprimer]

   1  UPDATE ezsite_data SET value='3.4.0' WHERE name='ezpublish-version';
   2  UPDATE ezsite_data SET value='7' WHERE name='ezpublish-release';
   3  
   4  -- incrementing size of 'sort_key_string' to 255 characters
   5  CREATE LOCAL TEMPORARY TABLE temp_sort_key_string
   6  (
   7      id               integer NOT NULL,
   8      sort_key_string  character varying(50) NOT NULL DEFAULT ''::character varying
   9  );
  10  
  11  INSERT INTO temp_sort_key_string SELECT id, sort_key_string FROM ezcontentobject_attribute;
  12  ALTER TABLE ezcontentobject_attribute DROP COLUMN sort_key_string;
  13  ALTER TABLE ezcontentobject_attribute ADD COLUMN sort_key_string character varying(255);
  14  UPDATE ezcontentobject_attribute SET sort_key_string='';
  15  ALTER TABLE ezcontentobject_attribute ALTER COLUMN sort_key_string SET NOT NULL;
  16  ALTER TABLE ezcontentobject_attribute ALTER COLUMN sort_key_string SET DEFAULT ''::character varying;
  17  UPDATE ezcontentobject_attribute SET sort_key_string=temp_sort_key_string.sort_key_string WHERE temp_sort_key_string.id=ezcontentobject_attribute.id;
  18  CREATE INDEX sort_key_string367 ON ezcontentobject_attribute USING btree (sort_key_string);
  19  DROP TABLE temp_sort_key_string;
  20  
  21  -- cleans up ezcontentbrowsebookmark and ezcontentbrowserecent tables from corrupted node_id's
  22  
  23  create temporary  table ezcontentbrowsebookmark_temp as 
  24        select  ezcontentbrowsebookmark.* from ezcontentbrowsebookmark,ezcontentobject_tree 
  25        where  ezcontentbrowsebookmark.node_id = ezcontentobject_tree.node_id;
  26  delete from ezcontentbrowsebookmark;
  27  insert into ezcontentbrowsebookmark select * from ezcontentbrowsebookmark_temp;
  28  
  29  create temporary  table ezcontentbrowserecent_temp as 
  30        select  ezcontentbrowserecent.* from ezcontentbrowserecent,ezcontentobject_tree 
  31        where  ezcontentbrowserecent.node_id = ezcontentobject_tree.node_id;
  32  delete from ezcontentbrowserecent;
  33  insert into ezcontentbrowserecent select * from ezcontentbrowserecent_temp;