[Sommaire] [Imprimer]

   1  UPDATE ezsite_data SET value='3.5.0' WHERE name='ezpublish-version';
   2  UPDATE ezsite_data SET value='5' WHERE name='ezpublish-release';
   3  
   4  -- 3.4.2 to 3.5.0alpha1
   5  
   6  -- We allow users from the "Editors" group 
   7  -- access only to "Root Folder" and "Media" trees.
   8  -- If you want to fix this you need to figure out the ids of these roles and modify
   9  -- the following SQLs
  10  --
  11  -- DELETE FROM ezuser_role WHERE id=30 AND role_id=3;
  12  -- INSERT INTO ezuser_role
  13  --        (role_id, contentobject_id, limit_identifier,limit_value)
  14  --        VALUES (3,13,'Subtree','/1/2/');
  15  -- INSERT INTO ezuser_role
  16  --        (role_id, contentobject_id, limit_identifier,limit_value)
  17  --        VALUES (3,13,'Subtree','/1/43/');
  18  
  19  -- This is present in 3.4.2, uncomment and run this if
  20  -- this is missing from your DB
  21  -- CREATE SEQUENCE tmp_notification_rule_s
  22  --     START 1
  23  --     INCREMENT 1
  24  --     MAXVALUE 9223372036854775807
  25  --     MINVALUE 1
  26  --     CACHE 1;
  27  
  28  -- the support of redirect payment gateways
  29  -- create table for eZPaymentObjects
  30  CREATE SEQUENCE ezpaymentobject_s
  31      START 1
  32      INCREMENT 1
  33      MAXVALUE 9223372036854775807
  34      MINVALUE 1
  35      CACHE 1;
  36  
  37  CREATE TABLE ezpaymentobject(
  38      id integer DEFAULT nextval('ezpaymentobject_s'::text) NOT NULL PRIMARY KEY,
  39      workflowprocess_id integer DEFAULT 0 NOT NULL,
  40      order_id integer DEFAULT 0 NOT NULL,
  41      payment_string character varying(255) DEFAULT ''::character varying NOT NULL,
  42      status integer DEFAULT 0 NOT NULL
  43      );
  44  
  45  ALTER TABLE ezbasket ADD COLUMN order_id integer;
  46  UPDATE ezbasket SET order_id=0;
  47  ALTER TABLE ezbasket ALTER order_id SET NOT NULL;
  48  ALTER TABLE ezbasket ALTER order_id SET DEFAULT 0;
  49  
  50  ALTER TABLE ezbinaryfile ADD COLUMN download_count integer;
  51  UPDATE ezbinaryfile SET download_count='0';
  52  ALTER TABLE ezbinaryfile ALTER download_count SET NOT NULL;
  53  ALTER TABLE ezbinaryfile ALTER download_count SET DEFAULT 0;
  54  
  55  ALTER TABLE ezcontentclass ADD is_container integer;
  56  UPDATE ezcontentclass SET is_container=0;
  57  ALTER TABLE ezcontentclass ALTER is_container SET NOT NULL;
  58  ALTER TABLE ezcontentclass ALTER is_container SET DEFAULT 0;
  59  
  60  -- New table for storing the users last visit
  61  
  62  CREATE TABLE ezuservisit
  63  (
  64      user_id                 INT NOT NULL PRIMARY KEY,
  65      current_visit_timestamp INT NOT NULL,
  66      last_visit_timestamp    INT NOT NULL
  67  );
  68  
  69  -- New columns for the hiding functionality
  70  ALTER TABLE ezcontentobject_tree ADD   is_hidden INTEGER;
  71  UPDATE      ezcontentobject_tree SET   is_hidden = 0;
  72  ALTER TABLE ezcontentobject_tree ALTER is_hidden SET NOT NULL;
  73  ALTER TABLE ezcontentobject_tree ALTER is_hidden SET DEFAULT 0;
  74  ALTER TABLE ezcontentobject_tree ADD   is_invisible INTEGER;
  75  UPDATE      ezcontentobject_tree SET   is_invisible = 0;
  76  ALTER TABLE ezcontentobject_tree ALTER is_invisible SET NOT NULL;
  77  ALTER TABLE ezcontentobject_tree ALTER is_invisible SET DEFAULT 0;
  78  
  79  
  80  -- 3.5.0alpha1 to 3.5.0beta1
  81  
  82  -- fix for section based conditional assignment also in 3.4.3
  83  update  ezuser_role set limit_identifier='Section' where limit_identifier='section';
  84  
  85  -- fixes incorrect name of group in ezcontentclass_classgroup 
  86  update ezcontentclass_classgroup set group_name='Users' where group_id=2;
  87  
  88  -- 3.5.0beta1 to 3.5.0rc1
  89  
  90  ALTER TABLE ezrole ADD COLUMN is_new integer;
  91  UPDATE ezrole SET is_new=0;
  92  ALTER TABLE ezrole ALTER is_new SET NOT NULL;
  93  ALTER TABLE ezrole ALTER is_new SET DEFAULT 0;
  94  
  95  -- New name for ezsearch index, the old one crashed with the table name ezsearch_word
  96  DROP INDEX ezsearch_word960;
  97  CREATE INDEX ezsearch_word_word_i ON ezsearch_word USING btree (word);
  98  
  99  -- Renamed several indexes, now they have the exact same name as the ones in MySQL.
 100  -- Changed names of all primary keys to be <tbl_name>_pkey
 101  ALTER TABLE ezapprove_items DROP CONSTRAINT ezapprove_items12_key;
 102  ALTER TABLE ONLY ezapprove_items ADD CONSTRAINT ezapprove_items_pkey PRIMARY KEY( "id" );
 103  ALTER TABLE ezbasket DROP CONSTRAINT ezbasket24_key;
 104  ALTER TABLE ONLY ezbasket ADD CONSTRAINT ezbasket_pkey PRIMARY KEY( "id" );
 105  ALTER TABLE ezbinaryfile DROP CONSTRAINT ezbinaryfile36_key;
 106  ALTER TABLE ONLY ezbinaryfile ADD CONSTRAINT ezbinaryfile_pkey PRIMARY KEY( "contentobject_attribute_id", "version" );
 107  ALTER TABLE ezcollab_group DROP CONSTRAINT ezcollab_group50_key;
 108  DROP INDEX ezcollab_group_depth63;
 109  DROP INDEX ezcollab_group_path62;
 110  ALTER TABLE ONLY ezcollab_group ADD CONSTRAINT ezcollab_group_pkey PRIMARY KEY( "id" );
 111  CREATE INDEX ezcollab_group_depth ON ezcollab_group USING btree( "depth" );
 112  CREATE INDEX ezcollab_group_path ON ezcollab_group USING btree( "path_string" );
 113  ALTER TABLE ezcollab_item DROP CONSTRAINT ezcollab_item71_key;
 114  ALTER TABLE ONLY ezcollab_item ADD CONSTRAINT ezcollab_item_pkey PRIMARY KEY( "id" );
 115  ALTER TABLE ezcollab_item_group_link DROP CONSTRAINT ezcollab_item_group_link95_key;
 116  ALTER TABLE ONLY ezcollab_item_group_link ADD CONSTRAINT ezcollab_item_group_link_pkey PRIMARY KEY( "collaboration_id", "group_id", "user_id" );
 117  ALTER TABLE ezcollab_item_message_link DROP CONSTRAINT ezcollab_item_message_link112_key;
 118  ALTER TABLE ONLY ezcollab_item_message_link ADD CONSTRAINT ezcollab_item_message_link_pkey PRIMARY KEY( "id" );
 119  ALTER TABLE ezcollab_item_participant_link DROP CONSTRAINT ezcollab_item_participant_link128_key;
 120  ALTER TABLE ONLY ezcollab_item_participant_link ADD CONSTRAINT ezcollab_item_participant_link_pkey PRIMARY KEY( "collaboration_id", "participant_id" );
 121  ALTER TABLE ezcollab_item_status DROP CONSTRAINT ezcollab_item_status146_key;
 122  ALTER TABLE ONLY ezcollab_item_status ADD CONSTRAINT ezcollab_item_status_pkey PRIMARY KEY( "collaboration_id", "user_id" );
 123  ALTER TABLE ezcollab_notification_rule DROP CONSTRAINT ezcollab_notification_rule160_key;
 124  ALTER TABLE ONLY ezcollab_notification_rule ADD CONSTRAINT ezcollab_notification_rule_pkey PRIMARY KEY( "id" );
 125  ALTER TABLE ezcollab_profile DROP CONSTRAINT ezcollab_profile172_key;
 126  ALTER TABLE ONLY ezcollab_profile ADD CONSTRAINT ezcollab_profile_pkey PRIMARY KEY( "id" );
 127  ALTER TABLE ezcollab_simple_message DROP CONSTRAINT ezcollab_simple_message187_key;
 128  ALTER TABLE ONLY ezcollab_simple_message ADD CONSTRAINT ezcollab_simple_message_pkey PRIMARY KEY( "id" );
 129  ALTER TABLE ezcontent_translation DROP CONSTRAINT ezcontent_translation210_key;
 130  ALTER TABLE ONLY ezcontent_translation ADD CONSTRAINT ezcontent_translation_pkey PRIMARY KEY( "id" );
 131  ALTER TABLE ezcontentbrowsebookmark DROP CONSTRAINT ezcontentbrowsebookmark222_key;
 132  DROP INDEX ezcontentbrowsebookmark_user228;
 133  ALTER TABLE ONLY ezcontentbrowsebookmark ADD CONSTRAINT ezcontentbrowsebookmark_pkey PRIMARY KEY( "id" );
 134  CREATE INDEX ezcontentbrowsebookmark_user ON ezcontentbrowsebookmark USING btree( "user_id" );
 135  ALTER TABLE ezcontentbrowserecent DROP CONSTRAINT ezcontentbrowserecent236_key;
 136  DROP INDEX ezcontentbrowserecent_user243;
 137  ALTER TABLE ONLY ezcontentbrowserecent ADD CONSTRAINT ezcontentbrowserecent_pkey PRIMARY KEY( "id" );
 138  CREATE INDEX ezcontentbrowserecent_user ON ezcontentbrowserecent USING btree( "user_id" );
 139  ALTER TABLE ezcontentclass DROP CONSTRAINT ezcontentclass251_key;
 140  DROP INDEX ezcontentclass_version262;
 141  ALTER TABLE ONLY ezcontentclass ADD CONSTRAINT ezcontentclass_pkey PRIMARY KEY( "id", "version" );
 142  CREATE INDEX ezcontentclass_version ON ezcontentclass USING btree( "version" );
 143  ALTER TABLE ezcontentclass_attribute DROP CONSTRAINT ezcontentclass_attribute270_key;
 144  ALTER TABLE ONLY ezcontentclass_attribute ADD CONSTRAINT ezcontentclass_attribute_pkey PRIMARY KEY( "id", "version" );
 145  ALTER TABLE ezcontentclass_classgroup DROP CONSTRAINT ezcontentclass_classgroup303_key;
 146  ALTER TABLE ONLY ezcontentclass_classgroup ADD CONSTRAINT ezcontentclass_classgroup_pkey PRIMARY KEY( "contentclass_id", "contentclass_version", "group_id" );
 147  ALTER TABLE ezcontentclassgroup DROP CONSTRAINT ezcontentclassgroup316_key;
 148  ALTER TABLE ONLY ezcontentclassgroup ADD CONSTRAINT ezcontentclassgroup_pkey PRIMARY KEY( "id" );
 149  ALTER TABLE ezcontentobject DROP CONSTRAINT ezcontentobject331_key;
 150  ALTER TABLE ONLY ezcontentobject ADD CONSTRAINT ezcontentobject_pkey PRIMARY KEY( "id" );
 151  ALTER TABLE ezcontentobject_attribute DROP CONSTRAINT ezcontentobject_attribute351_key;
 152  DROP INDEX ezcontentobject_attribute_contentobject_id364;
 153  DROP INDEX ezcontentobject_attribute_language_code365;
 154  DROP INDEX sort_key_int366;
 155  DROP INDEX sort_key_string367;
 156  ALTER TABLE ONLY ezcontentobject_attribute ADD CONSTRAINT ezcontentobject_attribute_pkey PRIMARY KEY( "id", "version" );
 157  CREATE INDEX ezcontentobject_attribute_contentobject_id ON ezcontentobject_attribute USING btree( "contentobject_id" );
 158  CREATE INDEX ezcontentobject_attribute_language_code ON ezcontentobject_attribute USING btree( "language_code" );
 159  CREATE INDEX sort_key_int ON ezcontentobject_attribute USING btree( "sort_key_int" );
 160  CREATE INDEX sort_key_string ON ezcontentobject_attribute USING btree( "sort_key_string" );
 161  ALTER TABLE ezcontentobject_link DROP CONSTRAINT ezcontentobject_link375_key;
 162  ALTER TABLE ONLY ezcontentobject_link ADD CONSTRAINT ezcontentobject_link_pkey PRIMARY KEY( "id" );
 163  ALTER TABLE ezcontentobject_name DROP CONSTRAINT ezcontentobject_name388_key;
 164  ALTER TABLE ONLY ezcontentobject_name ADD CONSTRAINT ezcontentobject_name_pkey PRIMARY KEY( "contentobject_id", "content_version", "content_translation" );
 165  ALTER TABLE ezcontentobject_tree DROP CONSTRAINT ezcontentobject_tree402_key;
 166  DROP INDEX ezcontentobject_tree_co_id418;
 167  DROP INDEX ezcontentobject_tree_depth419;
 168  DROP INDEX ezcontentobject_tree_mod_sub;
 169  DROP INDEX ezcontentobject_tree_p_node_id417;
 170  DROP INDEX ezcontentobject_tree_path416;
 171  ALTER TABLE ONLY ezcontentobject_tree ADD CONSTRAINT ezcontentobject_tree_pkey PRIMARY KEY( "node_id" );
 172  CREATE INDEX ezcontentobject_tree_co_id ON ezcontentobject_tree USING btree( "contentobject_id" );
 173  CREATE INDEX ezcontentobject_tree_depth ON ezcontentobject_tree USING btree( "depth" );
 174  CREATE INDEX ezcontentobject_tree_p_node_id ON ezcontentobject_tree USING btree( "parent_node_id" );
 175  CREATE INDEX ezcontentobject_tree_path ON ezcontentobject_tree USING btree( "path_string" );
 176  CREATE INDEX modified_subnode ON ezcontentobject_tree USING btree( "modified_subnode" );
 177  ALTER TABLE ezcontentobject_version DROP CONSTRAINT ezcontentobject_version427_key;
 178  ALTER TABLE ONLY ezcontentobject_version ADD CONSTRAINT ezcontentobject_version_pkey PRIMARY KEY( "id" );
 179  ALTER TABLE ezdiscountrule DROP CONSTRAINT ezdiscountrule445_key;
 180  ALTER TABLE ONLY ezdiscountrule ADD CONSTRAINT ezdiscountrule_pkey PRIMARY KEY( "id" );
 181  ALTER TABLE ezdiscountsubrule DROP CONSTRAINT ezdiscountsubrule456_key;
 182  ALTER TABLE ONLY ezdiscountsubrule ADD CONSTRAINT ezdiscountsubrule_pkey PRIMARY KEY( "id" );
 183  ALTER TABLE ezdiscountsubrule_value DROP CONSTRAINT ezdiscountsubrule_value470_key;
 184  ALTER TABLE ONLY ezdiscountsubrule_value ADD CONSTRAINT ezdiscountsubrule_value_pkey PRIMARY KEY( "discountsubrule_id", "value", "issection" );
 185  ALTER TABLE ezenumobjectvalue DROP CONSTRAINT ezenumobjectvalue482_key;
 186  DROP INDEX ezenumobjectvalue_co_attr_id_co_attr_ver489;
 187  ALTER TABLE ONLY ezenumobjectvalue ADD CONSTRAINT ezenumobjectvalue_pkey PRIMARY KEY( "contentobject_attribute_id", "contentobject_attribute_version", "enumid" );
 188  CREATE INDEX ezenumobjectvalue_co_attr_id_co_attr_ver ON ezenumobjectvalue USING btree( "contentobject_attribute_id", "contentobject_attribute_version" );
 189  ALTER TABLE ezenumvalue DROP CONSTRAINT ezenumvalue497_key;
 190  DROP INDEX ezenumvalue_co_cl_attr_id_co_class_att_ver505;
 191  ALTER TABLE ONLY ezenumvalue ADD CONSTRAINT ezenumvalue_pkey PRIMARY KEY( "id", "contentclass_attribute_id", "contentclass_attribute_version" );
 192  CREATE INDEX ezenumvalue_co_cl_attr_id_co_class_att_ver ON ezenumvalue USING btree( "contentclass_attribute_id", "contentclass_attribute_version" );
 193  ALTER TABLE ezforgot_password DROP CONSTRAINT ezforgot_password513_key;
 194  ALTER TABLE ONLY ezforgot_password ADD CONSTRAINT ezforgot_password_pkey PRIMARY KEY( "id" );
 195  ALTER TABLE ezgeneral_digest_user_settings DROP CONSTRAINT ezgeneral_digest_user_settings526_key;
 196  ALTER TABLE ONLY ezgeneral_digest_user_settings ADD CONSTRAINT ezgeneral_digest_user_settings_pkey PRIMARY KEY( "id" );
 197  ALTER TABLE ezimage DROP CONSTRAINT ezimage541_key;
 198  ALTER TABLE ONLY ezimage ADD CONSTRAINT ezimage_pkey PRIMARY KEY( "contentobject_attribute_id", "version" );
 199  ALTER TABLE ezimagevariation DROP CONSTRAINT ezimagevariation556_key;
 200  ALTER TABLE ONLY ezimagevariation ADD CONSTRAINT ezimagevariation_pkey PRIMARY KEY( "contentobject_attribute_id", "version", "requested_width", "requested_height" );
 201  ALTER TABLE ezinfocollection DROP CONSTRAINT ezinfocollection573_key;
 202  ALTER TABLE ONLY ezinfocollection ADD CONSTRAINT ezinfocollection_pkey PRIMARY KEY( "id" );
 203  ALTER TABLE ezinfocollection_attribute DROP CONSTRAINT ezinfocollection_attribute585_key;
 204  ALTER TABLE ONLY ezinfocollection_attribute ADD CONSTRAINT ezinfocollection_attribute_pkey PRIMARY KEY( "id" );
 205  ALTER TABLE ezkeyword DROP CONSTRAINT ezkeyword600_key;
 206  ALTER TABLE ONLY ezkeyword ADD CONSTRAINT ezkeyword_pkey PRIMARY KEY( "id" );
 207  ALTER TABLE ezkeyword_attribute_link DROP CONSTRAINT ezkeyword_attribute_link612_key;
 208  ALTER TABLE ONLY ezkeyword_attribute_link ADD CONSTRAINT ezkeyword_attribute_link_pkey PRIMARY KEY( "id" );
 209  ALTER TABLE ezmedia DROP CONSTRAINT ezmedia624_key;
 210  ALTER TABLE ONLY ezmedia ADD CONSTRAINT ezmedia_pkey PRIMARY KEY( "contentobject_attribute_id", "version" );
 211  ALTER TABLE ezmessage DROP CONSTRAINT ezmessage646_key;
 212  ALTER TABLE ONLY ezmessage ADD CONSTRAINT ezmessage_pkey PRIMARY KEY( "id" );
 213  ALTER TABLE ezmodule_run DROP CONSTRAINT ezmodule_run663_key;
 214  DROP INDEX ezmodule_run_workflow_process_id_s670;
 215  ALTER TABLE ONLY ezmodule_run ADD CONSTRAINT ezmodule_run_pkey PRIMARY KEY( "id" );
 216  CREATE UNIQUE INDEX ezmodule_run_workflow_process_id_s ON ezmodule_run USING btree( "workflow_process_id" );
 217  ALTER TABLE eznode_assignment DROP CONSTRAINT eznode_assignment678_key;
 218  ALTER TABLE ONLY eznode_assignment ADD CONSTRAINT eznode_assignment_pkey PRIMARY KEY( "id" );
 219  ALTER TABLE eznotificationcollection DROP CONSTRAINT eznotificationcollection696_key;
 220  ALTER TABLE ONLY eznotificationcollection ADD CONSTRAINT eznotificationcollection_pkey PRIMARY KEY( "id" );
 221  ALTER TABLE eznotificationcollection_item DROP CONSTRAINT eznotificationcollection_item711_key;
 222  ALTER TABLE ONLY eznotificationcollection_item ADD CONSTRAINT eznotificationcollection_item_pkey PRIMARY KEY( "id" );
 223  ALTER TABLE eznotificationevent DROP CONSTRAINT eznotificationevent725_key;
 224  ALTER TABLE ONLY eznotificationevent ADD CONSTRAINT eznotificationevent_pkey PRIMARY KEY( "id" );
 225  ALTER TABLE ezoperation_memento DROP CONSTRAINT ezoperation_memento745_key;
 226  ALTER TABLE ONLY ezoperation_memento ADD CONSTRAINT ezoperation_memento_pkey PRIMARY KEY( "id", "memento_key" );
 227  ALTER TABLE ezorder DROP CONSTRAINT ezorder759_key;
 228  ALTER TABLE ONLY ezorder ADD CONSTRAINT ezorder_pkey PRIMARY KEY( "id" );
 229  ALTER TABLE ezorder_item DROP CONSTRAINT ezorder_item778_key;
 230  ALTER TABLE ONLY ezorder_item ADD CONSTRAINT ezorder_item_pkey PRIMARY KEY( "id" );
 231  ALTER TABLE ezpolicy DROP CONSTRAINT ezpolicy792_key;
 232  ALTER TABLE ONLY ezpolicy ADD CONSTRAINT ezpolicy_pkey PRIMARY KEY( "id" );
 233  ALTER TABLE ezpolicy_limitation DROP CONSTRAINT ezpolicy_limitation806_key;
 234  ALTER TABLE ONLY ezpolicy_limitation ADD CONSTRAINT ezpolicy_limitation_pkey PRIMARY KEY( "id" );
 235  ALTER TABLE ezpolicy_limitation_value DROP CONSTRAINT ezpolicy_limitation_value821_key;
 236  ALTER TABLE ONLY ezpolicy_limitation_value ADD CONSTRAINT ezpolicy_limitation_value_pkey PRIMARY KEY( "id" );
 237  ALTER TABLE ezpreferences DROP CONSTRAINT ezpreferences833_key;
 238  DROP INDEX ezpreferences_name839;
 239  ALTER TABLE ONLY ezpreferences ADD CONSTRAINT ezpreferences_pkey PRIMARY KEY( "id" );
 240  CREATE INDEX ezpreferences_name ON ezpreferences USING btree( "name" );
 241  ALTER TABLE ezproductcollection DROP CONSTRAINT ezproductcollection847_key;
 242  ALTER TABLE ONLY ezproductcollection ADD CONSTRAINT ezproductcollection_pkey PRIMARY KEY( "id" );
 243  ALTER TABLE ezproductcollection_item DROP CONSTRAINT ezproductcollection_item858_key;
 244  ALTER TABLE ONLY ezproductcollection_item ADD CONSTRAINT ezproductcollection_item_pkey PRIMARY KEY( "id" );
 245  ALTER TABLE ezproductcollection_item_opt DROP CONSTRAINT ezproductcollection_item_opt875_key;
 246  ALTER TABLE ONLY ezproductcollection_item_opt ADD CONSTRAINT ezproductcollection_item_opt_pkey PRIMARY KEY( "id" );
 247  ALTER TABLE ezrole DROP CONSTRAINT ezrole891_key;
 248  ALTER TABLE ONLY ezrole ADD CONSTRAINT ezrole_pkey PRIMARY KEY( "id" );
 249  ALTER TABLE ezsearch_object_word_link DROP CONSTRAINT ezsearch_object_word_link904_key;
 250  DROP INDEX ezsearch_object_word_link_frequency921;
 251  DROP INDEX ezsearch_object_word_link_identifier922;
 252  DROP INDEX ezsearch_object_word_link_integer_value923;
 253  DROP INDEX ezsearch_object_word_link_object919;
 254  DROP INDEX ezsearch_object_word_link_word920;
 255  ALTER TABLE ONLY ezsearch_object_word_link ADD CONSTRAINT ezsearch_object_word_link_pkey PRIMARY KEY( "id" );
 256  CREATE INDEX ezsearch_object_word_link_frequency ON ezsearch_object_word_link USING btree( "frequency" );
 257  CREATE INDEX ezsearch_object_word_link_identifier ON ezsearch_object_word_link USING btree( "identifier" );
 258  CREATE INDEX ezsearch_object_word_link_integer_value ON ezsearch_object_word_link USING btree( "integer_value" );
 259  CREATE INDEX ezsearch_object_word_link_object ON ezsearch_object_word_link USING btree( "contentobject_id" );
 260  CREATE INDEX ezsearch_object_word_link_word ON ezsearch_object_word_link USING btree( "word_id" );
 261  ALTER TABLE ezsearch_return_count DROP CONSTRAINT ezsearch_return_count931_key;
 262  ALTER TABLE ONLY ezsearch_return_count ADD CONSTRAINT ezsearch_return_count_pkey PRIMARY KEY( "id" );
 263  ALTER TABLE ezsearch_search_phrase DROP CONSTRAINT ezsearch_search_phrase944_key;
 264  ALTER TABLE ONLY ezsearch_search_phrase ADD CONSTRAINT ezsearch_search_phrase_pkey PRIMARY KEY( "id" );
 265  ALTER TABLE ezsearch_word DROP CONSTRAINT ezsearch_word955_key;
 266  ALTER TABLE ONLY ezsearch_word ADD CONSTRAINT ezsearch_word_pkey PRIMARY KEY( "id" );
 267  ALTER TABLE ezsection DROP CONSTRAINT ezsection968_key;
 268  ALTER TABLE ONLY ezsection ADD CONSTRAINT ezsection_pkey PRIMARY KEY( "id" );
 269  DROP INDEX expiration_time986;
 270  ALTER TABLE ezsession DROP CONSTRAINT ezsession981_key;
 271  ALTER TABLE ONLY ezsession ADD CONSTRAINT ezsession_pkey PRIMARY KEY( "session_key" );
 272  CREATE INDEX expiration_time ON ezsession USING btree( "expiration_time" );
 273  ALTER TABLE ezsubtree_notification_rule DROP CONSTRAINT tmp_notification_rule_pkey;
 274  ALTER TABLE ONLY ezsubtree_notification_rule ADD CONSTRAINT ezsubtree_notification_rule_pkey PRIMARY KEY( "id" );
 275  ALTER TABLE eztrigger DROP CONSTRAINT eztrigger1007_key;
 276  DROP INDEX eztrigger_def_id1015;
 277  ALTER TABLE ONLY eztrigger ADD CONSTRAINT eztrigger_pkey PRIMARY KEY( "id" );
 278  CREATE UNIQUE INDEX eztrigger_def_id ON eztrigger USING btree( "module_name", "function_name", "connect_type" );
 279  ALTER TABLE ezurl DROP CONSTRAINT ezurl1023_key;
 280  ALTER TABLE ONLY ezurl ADD CONSTRAINT ezurl_pkey PRIMARY KEY( "id" );
 281  ALTER TABLE ezurlalias DROP CONSTRAINT ezurlalias1051_key;
 282  DROP INDEX ezurlalias_source_md51059;
 283  ALTER TABLE ONLY ezurlalias ADD CONSTRAINT ezurlalias_pkey PRIMARY KEY( "id" );
 284  CREATE INDEX ezurlalias_source_md5 ON ezurlalias USING btree( "source_md5" );
 285  ALTER TABLE ezuser DROP CONSTRAINT ezuser1067_key;
 286  ALTER TABLE ONLY ezuser ADD CONSTRAINT ezuser_pkey PRIMARY KEY( "contentobject_id" );
 287  ALTER TABLE ezuser_accountkey DROP CONSTRAINT ezuser_accountkey1081_key;
 288  ALTER TABLE ONLY ezuser_accountkey ADD CONSTRAINT ezuser_accountkey_pkey PRIMARY KEY( "id" );
 289  ALTER TABLE ezuser_discountrule DROP CONSTRAINT ezuser_discountrule1094_key;
 290  ALTER TABLE ONLY ezuser_discountrule ADD CONSTRAINT ezuser_discountrule_pkey PRIMARY KEY( "id" );
 291  ALTER TABLE ezuser_role DROP CONSTRAINT ezuser_role1107_key;
 292  DROP INDEX ezuser_role_contentobject_id1112;
 293  ALTER TABLE ONLY ezuser_role ADD CONSTRAINT ezuser_role_pkey PRIMARY KEY( "id" );
 294  CREATE INDEX ezuser_role_contentobject_id ON ezuser_role USING btree( "contentobject_id" );
 295  ALTER TABLE ezuser_setting DROP CONSTRAINT ezuser_setting1120_key;
 296  ALTER TABLE ONLY ezuser_setting ADD CONSTRAINT ezuser_setting_pkey PRIMARY KEY( "user_id" );
 297  ALTER TABLE ezvattype DROP CONSTRAINT ezvattype1132_key;
 298  ALTER TABLE ONLY ezvattype ADD CONSTRAINT ezvattype_pkey PRIMARY KEY( "id" );
 299  DROP INDEX ezwaituntildateevalue_wf_ev_id_wf_ver1151;
 300  ALTER TABLE ezwaituntildatevalue DROP CONSTRAINT ezwaituntildatevalue1144_key;
 301  ALTER TABLE ONLY ezwaituntildatevalue ADD CONSTRAINT ezwaituntildatevalue_pkey PRIMARY KEY( "id", "workflow_event_id", "workflow_event_version" );
 302  CREATE INDEX ezwaituntildateevalue_wf_ev_id_wf_ver ON ezwaituntildatevalue USING btree( "workflow_event_id", "workflow_event_version" );
 303  ALTER TABLE ezwishlist DROP CONSTRAINT ezwishlist1159_key;
 304  ALTER TABLE ONLY ezwishlist ADD CONSTRAINT ezwishlist_pkey PRIMARY KEY( "id" );
 305  ALTER TABLE ezworkflow DROP CONSTRAINT ezworkflow1171_key;
 306  ALTER TABLE ONLY ezworkflow ADD CONSTRAINT ezworkflow_pkey PRIMARY KEY( "id", "version" );
 307  ALTER TABLE ezworkflow_assign DROP CONSTRAINT ezworkflow_assign1189_key;
 308  ALTER TABLE ONLY ezworkflow_assign ADD CONSTRAINT ezworkflow_assign_pkey PRIMARY KEY( "id" );
 309  ALTER TABLE ezworkflow_event DROP CONSTRAINT ezworkflow_event1203_key;
 310  ALTER TABLE ONLY ezworkflow_event ADD CONSTRAINT ezworkflow_event_pkey PRIMARY KEY( "id", "version" );
 311  ALTER TABLE ezworkflow_group DROP CONSTRAINT ezworkflow_group1226_key;
 312  ALTER TABLE ONLY ezworkflow_group ADD CONSTRAINT ezworkflow_group_pkey PRIMARY KEY( "id" );
 313  ALTER TABLE ezworkflow_group_link DROP CONSTRAINT ezworkflow_group_link1241_key;
 314  ALTER TABLE ONLY ezworkflow_group_link ADD CONSTRAINT ezworkflow_group_link_pkey PRIMARY KEY( "workflow_id", "group_id", "workflow_version" );
 315  ALTER TABLE ezworkflow_process DROP CONSTRAINT ezworkflow_process1254_key;
 316  ALTER TABLE ONLY ezworkflow_process ADD CONSTRAINT ezworkflow_process_pkey PRIMARY KEY( "id" );
 317  
 318  -- Some minor fixes to schema to make it 100% equal to MySQL
 319  -- Difference in SQL commands from MySQL to PostgreSQL
 320  ALTER TABLE ezcontentobject_attribute RENAME COLUMN data_type_string TO data_type_string_tmp;
 321  ALTER TABLE ezcontentobject_attribute ADD COLUMN data_type_string character varying(50);
 322  ALTER TABLE ezcontentobject_attribute ALTER data_type_string SET DEFAULT '' ;
 323  UPDATE ezcontentobject_attribute SET data_type_string=data_type_string_tmp;
 324  ALTER TABLE ezcontentobject_attribute DROP COLUMN data_type_string_tmp;
 325  
 326  ALTER TABLE ezmedia RENAME COLUMN has_controller TO has_controller_tmp;
 327  ALTER TABLE ezmedia ADD COLUMN has_controller integer;
 328  ALTER TABLE ezmedia ALTER has_controller SET DEFAULT '0' ;
 329  UPDATE ezmedia SET has_controller=has_controller_tmp;
 330  ALTER TABLE ezmedia DROP COLUMN has_controller_tmp;
 331  
 332  ALTER TABLE ezmedia RENAME COLUMN is_autoplay TO is_autoplay_tmp;
 333  ALTER TABLE ezmedia ADD COLUMN is_autoplay integer;
 334  ALTER TABLE ezmedia ALTER is_autoplay SET DEFAULT '0' ;
 335  UPDATE ezmedia SET is_autoplay=is_autoplay_tmp;
 336  ALTER TABLE ezmedia DROP COLUMN is_autoplay_tmp;
 337  
 338  ALTER TABLE ezmedia RENAME COLUMN is_loop TO is_loop_tmp;
 339  ALTER TABLE ezmedia ADD COLUMN is_loop integer;
 340  ALTER TABLE ezmedia ALTER is_loop SET DEFAULT '0' ;
 341  UPDATE ezmedia SET is_loop=is_loop_tmp;
 342  ALTER TABLE ezmedia DROP COLUMN is_loop_tmp;
 343  
 344  ALTER TABLE ezproductcollection_item RENAME COLUMN price TO price_tmp;
 345  ALTER TABLE ezproductcollection_item ADD COLUMN price double precision;
 346  ALTER TABLE ezproductcollection_item ALTER price SET DEFAULT '0' ;
 347  UPDATE ezproductcollection_item SET price=price_tmp;
 348  ALTER TABLE ezproductcollection_item DROP COLUMN price_tmp;
 349  
 350  ALTER TABLE ezrss_export_item RENAME COLUMN description TO description_tmp;
 351  ALTER TABLE ezrss_export_item ADD COLUMN description character varying(255);
 352  ALTER TABLE ezrss_export_item ALTER description SET DEFAULT NULL ;
 353  UPDATE ezrss_export_item SET description=description_tmp;
 354  ALTER TABLE ezrss_export_item DROP COLUMN description_tmp;
 355  
 356   -- ezpdf_export
 357   -- Added support for versioning (class-type)
 358  
 359  ALTER TABLE ezpdf_export
 360      DROP CONSTRAINT ezpdf_export_pkey;
 361  
 362  ALTER TABLE ezpdf_export
 363      ADD COLUMN version integer;
 364  UPDATE ezpdf_export SET version='0';
 365  ALTER TABLE ezpdf_export ALTER version SET DEFAULT 0;
 366  ALTER TABLE ezpdf_export ALTER version SET NOT NULL;
 367  
 368  ALTER TABLE ezpdf_export
 369      ADD CONSTRAINT ezpdf_export_pkey PRIMARY KEY (id,version);
 370  
 371   -- ezrss_import
 372   -- Added support for versioning (class-type) by reusing status attribute
 373  
 374  ALTER TABLE ezrss_import
 375      DROP CONSTRAINT ezrss_import_pkey;
 376  
 377  UPDATE ezrss_import SET status=1 WHERE status=NULL;
 378  
 379  ALTER TABLE ezrss_import ALTER status SET DEFAULT 0;
 380  ALTER TABLE ezrss_import ALTER status SET NOT NULL;
 381  
 382  ALTER TABLE ezrss_import
 383      ADD CONSTRAINT ezrss_import_pkey PRIMARY KEY (id,status);
 384  
 385   -- ezrss_export
 386   -- Added support for versioning (class-type) by reusing status attribute
 387  
 388  ALTER TABLE ezrss_export
 389      DROP CONSTRAINT ezrss_export_pkey;
 390  
 391  UPDATE ezrss_export SET status=1 WHERE status=NULL;
 392  
 393  ALTER TABLE ezrss_export ALTER status SET DEFAULT 0;
 394  ALTER TABLE ezrss_export ALTER status SET NOT NULL;
 395  
 396  ALTER TABLE ezrss_export
 397      ADD CONSTRAINT ezrss_export_pkey PRIMARY KEY (id,status);
 398  
 399   -- ezrss_export_item
 400   -- Added support for versioning (class-type) by introducing status attribute
 401  
 402  ALTER TABLE ezrss_export_item
 403      DROP CONSTRAINT ezrss_export_item_pkey;
 404  
 405  ALTER TABLE ezrss_export_item
 406      ADD COLUMN status integer;
 407  
 408  UPDATE ezrss_export_item SET status=1;
 409  
 410  ALTER TABLE ezrss_export_item ALTER status SET DEFAULT 0;
 411  ALTER TABLE ezrss_export_item ALTER status SET NOT NULL;
 412  
 413  ALTER TABLE ezrss_export_item
 414      ADD CONSTRAINT ezrss_export_item_pkey PRIMARY KEY (id,status);
 415  
 416   -- ezproductcollection_item
 417   -- Added attribute name for storing a product name
 418  
 419  ALTER TABLE ezproductcollection_item ADD COLUMN name varchar(255);
 420  UPDATE ezproductcollection_item SET name='Unknown product';
 421  ALTER TABLE ezproductcollection_item ALTER name SET NOT NULL;
 422  ALTER TABLE ezproductcollection_item ALTER name SET DEFAULT '';
 423  
 424  -- 3.5.0rc1 to 3.5.0rc2
 425  
 426  
 427  -- 3.5.0rc2 to 3.5.0