[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  -- NOTE: This file will be generated from all the development releases, do not add entries
   5  
   6  -- 3.3.3 to 3.4.0alpha1
   7  
   8  ALTER TABLE ezcontentobject_tree ADD COLUMN modified_subnode INT;
   9  ALTER TABLE ezcontentobject_tree ALTER modified_subnode SET DEFAULT 0;
  10  
  11  CREATE INDEX ezcontentobject_tree_mod_sub ON ezcontentobject_tree( modified_subnode );
  12  
  13  UPDATE ezcontentobject_tree SET modified_subnode=(SELECT max( ezcontentobject.modified )
  14         FROM ezcontentobject, ezcontentobject_tree as tree
  15         WHERE ezcontentobject.id = tree.contentobject_id AND
  16               tree.path_string like ezcontentobject_tree.path_string||'%');
  17  
  18  ALTER TABLE ezuser_role ADD COLUMN limit_identifier varchar(255);
  19  ALTER TABLE ezuser_role ALTER limit_identifier SET DEFAULT '';
  20  ALTER TABLE ezuser_role ADD COLUMN limit_value varchar(255);
  21  ALTER TABLE ezuser_role ALTER limit_value SET DEFAULT '';
  22  
  23  ALTER TABLE ezpolicy DROP COLUMN limitation;
  24  
  25  ALTER TABLE ezpolicy_limitation DROP COLUMN role_id;
  26  ALTER TABLE ezpolicy_limitation DROP COLUMN function_name;
  27  ALTER TABLE ezpolicy_limitation DROP COLUMN module_name;
  28  
  29  CREATE INDEX ezuser_role_role_id ON ezuser_role ( role_id );
  30  
  31  -- 3.4.0alpha1 to 3.4.0alpha2
  32  
  33  ---
  34  --- Add session ID to user object
  35  ---
  36  
  37  CREATE TABLE ezuser_session_link (
  38    user_id INTEGER NOT NULL,
  39    session_key CHARACTER VARYING(32),
  40    PRIMARY KEY( user_id, session_key )
  41  );
  42  CREATE INDEX ezuser_session_link_user_idx on ezuser_session_link ( user_id );
  43  CREATE INDEX ezuser_session_link_session_idx on ezuser_session_link ( session_key );
  44  
  45  CREATE INDEX ezpreferences_user_id_idx on ezpreferences ( user_id, name );
  46  
  47  ALTER TABLE ezorder ADD COLUMN email CHARACTER VARYING(150);
  48  ALTER TABLE ezorder ALTER email SET DEFAULT '';
  49  --- 
  50  --- Run script update/common/scripts/addorderemail.php after this change to
  51  --- insert correct email for existing orders.
  52  ---
  53  
  54  
  55  CREATE TABLE ezsubtree_expiry (
  56      subtree character varying(255) NOT NULL,
  57      cache_file character varying(255) NOT NULL
  58  );
  59  
  60  CREATE INDEX ezsubtree_expiry_subtree ON ezsubtree_expiry USING btree (subtree);
  61  
  62  
  63  CREATE TABLE ezpending_actions (
  64    action character varying(64) NOT NULL,
  65    param text
  66  );
  67  
  68  CREATE INDEX ezpending_actions_action ON ezpending_actions USING btree (action);
  69  
  70  
  71  -- Make sure ezrss_export_item (description) has '' as default like the MySQL schema
  72  ALTER TABLE ezrss_export_item RENAME COLUMN description TO description_tmp;
  73  ALTER TABLE ezrss_export_item ADD COLUMN description character varying(255) ;
  74  ALTER TABLE ezrss_export_item ALTER description SET DEFAULT '' ;
  75  UPDATE ezrss_export_item SET description=description_tmp;
  76  ALTER TABLE ezrss_export_item DROP COLUMN description_tmp;
  77  
  78  -- Make sure ezsession (expiration_time) is normal integer and not bigint
  79  ALTER TABLE ezsession RENAME COLUMN expiration_time TO expiration_time_tmp;
  80  ALTER TABLE ezsession ADD COLUMN expiration_time integer ;
  81  ALTER TABLE ezsession ALTER expiration_time SET DEFAULT 0 ;
  82  UPDATE ezsession SET expiration_time=0;
  83  ALTER TABLE ezsession ALTER expiration_time SET NOT NULL ;
  84  UPDATE ezsession SET expiration_time=expiration_time_tmp;
  85  ALTER TABLE ezsession DROP COLUMN expiration_time_tmp;
  86  CREATE INDEX expiration_time986 ON ezsession USING btree (expiration_time);
  87  
  88  -- Run these four if you installed kernel_schema.sql from 3.4.0alpha1, they were missing
  89  -- ALTER TABLE ezuser_role ADD COLUMN limit_identifier varchar(255);
  90  -- ALTER TABLE ezuser_role ALTER limit_identifier SET DEFAULT '';
  91  -- ALTER TABLE ezuser_role ADD COLUMN limit_value varchar(255);
  92  -- ALTER TABLE ezuser_role ALTER limit_value SET DEFAULT '';
  93  
  94  -- 3.4.0alpha2 to 3.4.0alpha3
  95  
  96  ALTER TABLE ezcontentclass ADD COLUMN remote_id varchar(100);
  97  UPDATE ezcontentclass SET remote_id='';
  98  ALTER TABLE ezcontentclass ALTER remote_id SET NOT NULL;
  99  ALTER TABLE ezcontentclass ALTER remote_id SET default '';
 100  
 101  ALTER TABLE ezcontentobject_tree ADD COLUMN remote_id varchar(100);
 102  UPDATE ezcontentobject_tree SET remote_id='';
 103  ALTER TABLE ezcontentobject_tree ALTER remote_id SET NOT NULL;
 104  ALTER TABLE ezcontentobject_tree ALTER remote_id SET default '';
 105  
 106  ALTER TABLE eznode_assignment ADD COLUMN parent_remote_id varchar(100);
 107  UPDATE eznode_assignment SET parent_remote_id='';
 108  ALTER TABLE eznode_assignment ALTER parent_remote_id SET NOT NULL;
 109  ALTER TABLE eznode_assignment ALTER parent_remote_id SET default '';
 110  
 111  ALTER TABLE ezsession ADD COLUMN user_id integer;
 112  UPDATE ezsession SET user_id=0;
 113  ALTER TABLE ezsession ALTER user_id SET NOT NULL;
 114  ALTER TABLE ezsession ALTER user_id SET DEFAULT 0;
 115  CREATE INDEX ezsession_user_id ON ezsession ( user_id );
 116  ALTER TABLE ezsession ALTER user_id DROP NOT NULL;
 117  UPDATE ezsession SET user_id=(SELECT ezuser_session_link.user_id FROM ezuser_session_link, ezsession WHERE ezsession.session_key=ezuser_session_link.session_key);
 118  UPDATE ezsession SET user_id=0 WHERE user_id IS NULL;
 119  ALTER TABLE ezsession ALTER user_id SET NOT NULL;
 120  DROP TABLE ezuser_session_link;
 121  
 122  -- 3.4.0alpha3 to 3.4.0alpha4
 123  
 124  -- 3.4.0alpha4 to 3.4.0beta1
 125  
 126  ALTER TABLE eznode_assignment RENAME COLUMN parent_remote_id TO parent_remote_id_tmp;
 127  ALTER TABLE eznode_assignment ADD COLUMN parent_remote_id character varying(100) ;
 128  ALTER TABLE eznode_assignment ALTER parent_remote_id SET DEFAULT '' ;
 129  UPDATE eznode_assignment SET parent_remote_id='';
 130  ALTER TABLE eznode_assignment ALTER parent_remote_id SET NOT NULL ;
 131  UPDATE eznode_assignment SET parent_remote_id=parent_remote_id_tmp;
 132  ALTER TABLE eznode_assignment DROP COLUMN parent_remote_id_tmp;
 133  
 134  -- 3.4.0beta1 to 3.4.0beta2
 135  
 136  -- 3.4.0beta2 to 3.4.0
 137  
 138  -- incrementing size of 'sort_key_string' to 255 characters
 139  CREATE LOCAL TEMPORARY TABLE temp_sort_key_string
 140  (
 141      id               integer NOT NULL,
 142      sort_key_string  character varying(50) NOT NULL DEFAULT ''::character varying
 143  );
 144  
 145  INSERT INTO temp_sort_key_string SELECT id, sort_key_string FROM ezcontentobject_attribute;
 146  ALTER TABLE ezcontentobject_attribute DROP COLUMN sort_key_string;
 147  ALTER TABLE ezcontentobject_attribute ADD COLUMN sort_key_string character varying(255);
 148  UPDATE ezcontentobject_attribute SET sort_key_string='';
 149  ALTER TABLE ezcontentobject_attribute ALTER COLUMN sort_key_string SET NOT NULL;
 150  ALTER TABLE ezcontentobject_attribute ALTER COLUMN sort_key_string SET DEFAULT ''::character varying;
 151  UPDATE ezcontentobject_attribute SET sort_key_string=temp_sort_key_string.sort_key_string WHERE temp_sort_key_string.id=ezcontentobject_attribute.id;
 152  CREATE INDEX sort_key_string367 ON ezcontentobject_attribute USING btree (sort_key_string);
 153  DROP TABLE temp_sort_key_string;
 154  
 155  -- cleans up ezcontentbrowsebookmark and ezcontentbrowserecent tables from corrupted node_id's
 156  
 157  create temporary  table ezcontentbrowsebookmark_temp as 
 158        select  ezcontentbrowsebookmark.* from ezcontentbrowsebookmark,ezcontentobject_tree 
 159        where  ezcontentbrowsebookmark.node_id = ezcontentobject_tree.node_id;
 160  delete from ezcontentbrowsebookmark;
 161  insert into ezcontentbrowsebookmark select * from ezcontentbrowsebookmark_temp;
 162  
 163  create temporary  table ezcontentbrowserecent_temp as 
 164        select  ezcontentbrowserecent.* from ezcontentbrowserecent,ezcontentobject_tree 
 165        where  ezcontentbrowserecent.node_id = ezcontentobject_tree.node_id;
 166  delete from ezcontentbrowserecent;
 167  insert into ezcontentbrowserecent select * from ezcontentbrowserecent_temp;