[Sommaire] [Imprimer]

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