[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  CREATE INDEX  ezsearch_return_cnt_ph_id_count  ON   ezsearch_return_count ( phrase_id, count );
   5  -- alter table ezsearch_return_count add key ( phrase_id, count );
   6  CREATE INDEX ezsearch_search_phrase_phr ON ezsearch_search_phrase ( phrase );
   7  -- alter table ezsearch_search_phrase add key ( phrase );
   8  CREATE SEQUENCE ezsearch_search_phrase_new_s
   9      START 1
  10      INCREMENT 1
  11      MAXVALUE 9223372036854775807
  12      MINVALUE 1
  13      CACHE 1;
  14  
  15  CREATE TABLE ezsearch_search_phrase_new (
  16    id int DEFAULT nextval('ezsearch_search_phrase_new_s'::text) PRIMARY KEY,
  17    phrase varchar(250) default NULL,
  18    phrase_count int default 0,
  19    result_count int default 0
  20  );
  21  CREATE UNIQUE INDEX ezsearch_search_phrase_phrase ON ezsearch_search_phrase_new ( phrase );
  22  CREATE INDEX ezsearch_search_phrase_count ON ezsearch_search_phrase_new ( phrase_count );
  23  
  24  
  25  INSERT INTO ezsearch_search_phrase_new ( phrase, phrase_count, result_count )
  26  SELECT   lower( phrase ), count(*), sum( ezsearch_return_count.count )
  27  FROM     ezsearch_search_phrase,
  28           ezsearch_return_count
  29  WHERE    ezsearch_search_phrase.id = ezsearch_return_count.phrase_id
  30  GROUP BY lower( ezsearch_search_phrase.phrase );
  31  
  32  -- ezsearch_return_count is of no (additional) use in a normal eZ publish installation
  33  -- but perhaps someone built something for himself, then it is not BC
  34  -- to not break BC apply the CREATE and INSERT statements
  35  CREATE SEQUENCE ezsearch_return_count_new_s
  36      START 1
  37      INCREMENT 1
  38      MAXVALUE 9223372036854775807
  39      MINVALUE 1
  40      CACHE 1;
  41  
  42  CREATE TABLE ezsearch_return_count_new (
  43    id int NOT NULL DEFAULT nextval('ezsearch_search_phrase_new_s'::text) PRIMARY KEY,
  44    phrase_id int NOT NULL default 0,
  45    time int NOT NULL default 0,
  46    count int NOT NULL default 0
  47  );
  48  CREATE INDEX  ezsearch_return_cnt_new_ph_id_cnt  ON  ezsearch_return_count_new ( phrase_id, count );
  49  
  50  INSERT INTO ezsearch_return_count_new ( phrase_id, time, count )
  51  SELECT    ezsearch_search_phrase_new.id, time, count
  52  FROM      ezsearch_search_phrase,
  53            ezsearch_search_phrase_new,
  54            ezsearch_return_count
  55  WHERE     ezsearch_search_phrase_new.phrase = LOWER( ezsearch_search_phrase.phrase ) AND
  56            ezsearch_search_phrase.id = ezsearch_return_count.phrase_id;
  57  
  58  -- final tasks with and without BC
  59  DROP TABLE ezsearch_search_phrase;
  60  --ALTER TABLE ezsearch_search_phrase RENAME TO ezsearch_search_phrase_old;
  61  ALTER TABLE ezsearch_search_phrase_new RENAME TO ezsearch_search_phrase;
  62  
  63  DROP TABLE ezsearch_return_count;
  64  -- ALTER TABLE ezsearch_return_count RENAME TO ezsearch_return_count_old;
  65  -- of course the next statement is only valid if you created `ezsearch_return_count_new`
  66  ALTER TABLE ezsearch_return_count_new RENAME TO ezsearch_return_count;
  67  ALTER TABLE  ezsearch_return_count drop  constraint ezsearch_return_count_new_pkey;
  68  ALTER TABLE ezsearch_return_count ADD PRIMARY KEY(id);
  69  ALTER TABLE ezsearch_search_phrase  drop  constraint ezsearch_search_phrase_new_pkey;
  70  ALTER TABLE ezsearch_search_phrase  ADD PRIMARY KEY(id);
  71  DROP  INDEX ezsearch_return_cnt_new_ph_id_cnt;
  72  CREATE INDEX  ezsearch_return_cnt_ph_id_cnt  ON   ezsearch_return_count ( phrase_id, count );
  73  
  74