[Sommaire] [Imprimer]

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