[Sommaire] [Imprimer]

   1  UPDATE ezsite_data SET value='3.9.0rc2' WHERE name='ezpublish-version';
   2  UPDATE ezsite_data SET value='4' WHERE name='ezpublish-release';
   3  
   4  -- alter table ezsearch_return_count add key ( phrase_id, count );
   5  -- alter table ezsearch_search_phrase add key ( phrase );
   6  CREATE INDEX  ezsearch_return_cnt_new_ph_id_count  ON   ezsearch_return_count ( phrase_id, count );
   7  CREATE INDEX ezsearch_search_phrase_phr ON ezsearch_search_phrase ( phrase );
   8  
   9  CREATE TABLE `ezsearch_search_phrase_new` (
  10    `id` int(11) NOT NULL auto_increment PRIMARY KEY ,
  11    `phrase` varchar(250) default NULL,
  12    `phrase_count` int(11) default '0',
  13    `result_count` int(11) default '0'
  14  );
  15  CREATE UNIQUE INDEX ezsearch_search_phrase_phrase ON ezsearch_search_phrase_new ( phrase );
  16  CREATE INDEX ezsearch_search_phrase_count ON ezsearch_search_phrase_new ( phrase_count );
  17  
  18  
  19  INSERT INTO ezsearch_search_phrase_new ( phrase, phrase_count, result_count )
  20  SELECT   lower( phrase ), count(*), sum( ezsearch_return_count.count )
  21  FROM     ezsearch_search_phrase,
  22           ezsearch_return_count
  23  WHERE    ezsearch_search_phrase.id = ezsearch_return_count.phrase_id
  24  GROUP BY lower( ezsearch_search_phrase.phrase );
  25  
  26  -- ezsearch_return_count is of no (additional) use in a normal eZ publish installation
  27  -- but perhaps someone built something for himself, then it is not BC
  28  -- to not break BC apply the CREATE and INSERT statements
  29  
  30  CREATE TABLE `ezsearch_return_count_new` (
  31    `id` int(11) NOT NULL auto_increment   PRIMARY KEY,
  32    `phrase_id` int(11) NOT NULL default '0',
  33    `time` int(11) NOT NULL default '0',
  34    `count` int(11) NOT NULL default '0'
  35  );
  36  CREATE INDEX  ezsearch_return_cnt_ph_id_cnt  ON   ezsearch_return_count_new ( phrase_id, count );
  37  
  38  INSERT INTO `ezsearch_return_count_new` ( phrase_id, time, `count` )
  39  SELECT    ezsearch_search_phrase_new.id, time, `count`
  40  FROM      ezsearch_search_phrase,
  41            ezsearch_search_phrase_new,
  42            ezsearch_return_count
  43  WHERE     ezsearch_search_phrase_new.phrase = LOWER( ezsearch_search_phrase.phrase ) AND
  44            ezsearch_search_phrase.id = ezsearch_return_count.phrase_id;
  45  
  46  -- final tasks with and without BC
  47  DROP TABLE ezsearch_search_phrase;
  48  -- ALTER TABLE ezsearch_search_phrase RENAME TO ezsearch_search_phrase_old;
  49  ALTER TABLE ezsearch_search_phrase_new RENAME TO ezsearch_search_phrase;
  50  
  51  DROP TABLE `ezsearch_return_count`;
  52  -- ALTER TABLE ezsearch_return_count RENAME TO ezsearch_return_count_old;
  53  -- of course the next statement is only valid if you created `ezsearch_return_count_new`
  54  ALTER TABLE ezsearch_return_count_new RENAME TO ezsearch_return_count;
  55  
  56