Upgrade Requirements - 2.2 to 3.0

Please add all upgrade script TASKS to the this page as you resolve 3.0 issues which require schema or fixed data modifications to existing 2.2 sites. Include the issue number which is the source of the change.

CRM-3336
we have added two columns in civicrm_relationship_type table, namely label_a_b, label_b_a which will store values from name_a_b, name_b_a respectively.
CRM-4048
we had modified in civicrm_uf_field.visibility type "enum('User and User Admin Only', 'Public User Pages', 'Public User Pages and Listings')" to "enum('User and User Admin Only', 'Public Pages', 'Public Pages and Listings')". we had removed 'Public User Pages and Listings' from civicrm_group.visibility type and modified as "enum('User and User Admin Only', 'Public Pages')".

CRM-4407: Add navigation column to civicrm_preference table.
- Add civicrm_navigation table
- Add default menus to upgrade script.
'name' column is add to civicrm_uf_group table. Add default participant profile to default data
CRM-4414, add individual, organization and household default profile to upgrade

CRM-3553
we have added new activity type called "Bulk Email" in civicrm_option_value.

CRM-4469
we have added new column 'collapse_adv_display' in civicrm_custom_group.

CRM-3140
We have added a new column in civicrm_mapping_field, namely im_provider_id which will store Internet Messangers's mapping provider id.

CRM-4461
we have added enum type 'AdvMulti-Select' into civicrm_custom_field.html_type. We have modified civicrm_custom_field.html_type "enum('Text', 'TextArea', 'Select', 'Multi-Select', 'Radio', 'CheckBox', 'Select Date', 'Select State/Province', 'Select Country', 'Multi-Select Country', 'Multi-Select State/Province', 'File', 'Link', 'RichTextEditor')" to "enum('Text', 'TextArea', 'Select', 'Multi-Select', 'AdvMulti-Select', 'Radio', 'CheckBox', 'Select Date', 'Select State/Province', 'Select Country', 'Multi-Select Country', 'Multi-Select State/Province', 'File', 'Link', 'RichTextEditor')".