[Sommaire] [Imprimer]

   1  UPDATE ezsite_data SET value='3.4.0alpha2' WHERE name='ezpublish-version';
   2  UPDATE ezsite_data SET value='2' WHERE name='ezpublish-release';
   3  
   4  ---
   5  --- Add session ID to user object
   6  ---
   7  
   8  CREATE TABLE ezuser_session_link (
   9    user_id int(11) NOT NULL,
  10    session_key varchar(32) NOT NULL,
  11    PRIMARY KEY( user_id, session_key )
  12  );
  13  CREATE INDEX ezuser_session_link_user_idx on ezuser_session_link ( user_id );
  14  CREATE INDEX ezuser_session_link_session_idx on ezuser_session_link ( session_key );
  15  
  16  
  17  CREATE INDEX ezpreferences_user_id_idx on ezpreferences ( user_id, name );
  18  
  19  
  20  ALTER  TABLE ezorder ADD COLUMN email varchar(150) NOT NULL default '';
  21  --- 
  22  --- Run script update/common/scripts/addorderemail.php after this change to
  23  --- insert correct email for existing orders.
  24  ---
  25  
  26  
  27  CREATE TABLE ezsubtree_expiry (
  28    subtree varchar(255) NOT NULL default '',
  29    cache_file varchar(255) NOT NULL default '',
  30    KEY ezsubtree_expiry_subtree (subtree)
  31  ) DELAY_KEY_WRITE=1 TYPE=MyISAM;
  32  
  33  
  34  CREATE TABLE ezpending_actions (
  35    action varchar(64) NOT NULL,
  36    param text,
  37    KEY ezpending_actions_action (action)
  38  ) TYPE=MyISAM;
  39  
  40  
  41  -- Change text fields to longtext
  42  ALTER TABLE ezcollab_item CHANGE COLUMN data_text1 data_text1 longtext NOT NULL ;
  43  ALTER TABLE ezcollab_item CHANGE COLUMN data_text2 data_text2 longtext NOT NULL ;
  44  ALTER TABLE ezcollab_item CHANGE COLUMN data_text3 data_text3 longtext NOT NULL ;
  45  ALTER TABLE ezcollab_profile CHANGE COLUMN data_text1 data_text1 longtext NOT NULL ;
  46  ALTER TABLE ezcollab_simple_message CHANGE COLUMN data_text1 data_text1 longtext NOT NULL ;
  47  ALTER TABLE ezcollab_simple_message CHANGE COLUMN data_text2 data_text2 longtext NOT NULL ;
  48  ALTER TABLE ezcollab_simple_message CHANGE COLUMN data_text3 data_text3 longtext NOT NULL ;
  49  ALTER TABLE ezcontentclass_attribute CHANGE COLUMN data_text5 data_text5 longtext ;
  50  ALTER TABLE ezcontentobject_attribute CHANGE COLUMN data_text data_text longtext ;
  51  ALTER TABLE ezcontentobject_tree CHANGE COLUMN path_identification_string path_identification_string longtext ;
  52  ALTER TABLE ezinfocollection_attribute CHANGE COLUMN data_text data_text longtext ;
  53  ALTER TABLE ezmessage CHANGE COLUMN body body longtext ;
  54  ALTER TABLE ezmodule_run CHANGE COLUMN module_data module_data longtext ;
  55  ALTER TABLE eznotificationcollection CHANGE COLUMN data_subject data_subject longtext NOT NULL ;
  56  ALTER TABLE eznotificationcollection CHANGE COLUMN data_text data_text longtext NOT NULL ;
  57  ALTER TABLE eznotificationevent CHANGE COLUMN data_text1 data_text1 longtext NOT NULL ;
  58  ALTER TABLE eznotificationevent CHANGE COLUMN data_text2 data_text2 longtext NOT NULL ;
  59  ALTER TABLE eznotificationevent CHANGE COLUMN data_text3 data_text3 longtext NOT NULL ;
  60  ALTER TABLE eznotificationevent CHANGE COLUMN data_text4 data_text4 longtext NOT NULL ;
  61  ALTER TABLE ezoperation_memento CHANGE COLUMN memento_data memento_data longtext NOT NULL ;
  62  ALTER TABLE ezorder CHANGE COLUMN data_text_2 data_text_2 longtext ;
  63  ALTER TABLE ezorder CHANGE COLUMN data_text_1 data_text_1 longtext ;
  64  ALTER TABLE ezpdf_export CHANGE COLUMN intro_text intro_text longtext ;
  65  ALTER TABLE ezpdf_export CHANGE COLUMN sub_text sub_text longtext ;
  66  ALTER TABLE ezpending_actions CHANGE COLUMN param param longtext ;
  67  ALTER TABLE ezrss_export CHANGE COLUMN description description longtext ;
  68  ALTER TABLE ezrss_import CHANGE COLUMN url url longtext ;
  69  ALTER TABLE ezsession CHANGE COLUMN data data longtext NOT NULL ;
  70  ALTER TABLE ezsite_data CHANGE COLUMN value value longtext NOT NULL ;
  71  ALTER TABLE ezurlalias CHANGE COLUMN source_url source_url longtext NOT NULL ;
  72  ALTER TABLE ezurlalias CHANGE COLUMN destination_url destination_url longtext NOT NULL ;
  73  ALTER TABLE ezworkflow_process CHANGE COLUMN parameters parameters longtext ;
  74  ALTER TABLE ezimagefile CHANGE COLUMN filepath filepath longtext NOT NULL ;
  75  
  76  -- Change NULL and size for some fields
  77  ALTER TABLE ezcontentobject_attribute CHANGE COLUMN sort_key_string sort_key_string varchar(50) DEFAULT '' ;
  78  ALTER TABLE ezcontentobject_attribute CHANGE COLUMN data_type_string data_type_string varchar(50) DEFAULT '' ;
  79  ALTER TABLE ezorder CHANGE COLUMN email email varchar(150) DEFAULT '' ;
  80  ALTER TABLE ezproductcollection_item CHANGE COLUMN price price float DEFAULT '0' ;
  81  
  82  ALTER TABLE ezcontentclass_attribute CHANGE COLUMN is_searchable is_searchable int(11) NOT NULL DEFAULT '0' ;
  83  ALTER TABLE ezcontentclass_attribute CHANGE COLUMN is_required is_required int(11) NOT NULL DEFAULT '0' ;
  84  ALTER TABLE ezcontentobject_tree CHANGE COLUMN sort_order sort_order int(11) DEFAULT '1' ;
  85  ALTER TABLE ezcontentobject_tree CHANGE COLUMN modified_subnode modified_subnode int(11) DEFAULT '0' ;
  86  ALTER TABLE ezcontentobject_version CHANGE COLUMN workflow_event_pos workflow_event_pos int(11) DEFAULT '0' ;
  87  ALTER TABLE ezdiscountsubrule_value CHANGE COLUMN issection issection int(11) NOT NULL DEFAULT '0' ;
  88  ALTER TABLE ezinfocollection CHANGE COLUMN modified modified int(11) DEFAULT '0' ;
  89  ALTER TABLE ezmedia CHANGE COLUMN has_controller has_controller int(11) DEFAULT '0' ;
  90  ALTER TABLE ezmedia CHANGE COLUMN is_autoplay is_autoplay int(11) DEFAULT '0' ;
  91  ALTER TABLE ezmedia CHANGE COLUMN is_loop is_loop int(11) DEFAULT '0' ;
  92  ALTER TABLE ezmessage CHANGE COLUMN is_sent is_sent int(11) NOT NULL DEFAULT '0' ;
  93  ALTER TABLE eznode_assignment CHANGE COLUMN sort_order sort_order int(11) DEFAULT '1' ;
  94  ALTER TABLE ezuser_setting CHANGE COLUMN is_enabled is_enabled int(11) NOT NULL DEFAULT '0' ;
  95  ALTER TABLE ezworkflow CHANGE COLUMN is_enabled is_enabled int(11) NOT NULL DEFAULT '0' ;
  96  ALTER TABLE ezworkflow_assign CHANGE COLUMN as_tree as_tree int(11) NOT NULL DEFAULT '0' ;