CRM-12595 fix formatting in CRM/Upgrade files
[civicrm-core.git] / CRM / Upgrade / Incremental / sql / 2.1.2.mysql
index 722388c5632a798e564b3021e82c2bf2cd9b1259..ea79c5d79262244dbfb1f8173cf96e0a0e4c1029 100644 (file)
@@ -4,17 +4,17 @@
 -- *
 -- *****************************************************************************/
 -- fix constraint
-ALTER TABLE `civicrm_group_nesting` 
+ALTER TABLE `civicrm_group_nesting`
     DROP FOREIGN KEY `FK_civicrm_group_nesting_child_group_id`;
-ALTER TABLE `civicrm_group_nesting` 
+ALTER TABLE `civicrm_group_nesting`
     ADD CONSTRAINT `FK_civicrm_group_nesting_child_group_id` FOREIGN KEY (`child_group_id`) REFERENCES `civicrm_group` (`id`) ON DELETE CASCADE;
 
 -- CRM-3749
-UPDATE civicrm_uf_field SET field_type = 'Contact' 
+UPDATE civicrm_uf_field SET field_type = 'Contact'
 WHERE field_name IN ('address_name','city','contact_sub_type','contact_type','country','custom_greeting','display_name','do_not_email','do_not_mail','do_not_phone','do_not_trade','email','external_identifier','geo_code_1','geo_code_2','group','im','image_URL','id','nick_name','is_opt_out','on_hold','openid','phone','postal_code','postal_code_suffix','preferred_communication_method','preferred_mail_format','sort_name','contact_source','state_province','street_address','supplemental_address_1','supplemental_address_2','tag','user_unique_id','is_bulkmail','world_region');
 
 -- civicrm_note constraint fix
-ALTER TABLE civicrm_note 
+ALTER TABLE civicrm_note
     DROP FOREIGN KEY `FK_civicrm_note_contact_id`;
 ALTER TABLE `civicrm_note`
     ADD CONSTRAINT `FK_civicrm_note_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL;