- // FIXME: this should be generated dynamically from the schema's
- // foreign keys referencing civicrm_contact(id)
- $cidRefs = array(
- 'civicrm_acl_cache' => array('contact_id'),
- 'civicrm_activity_contact' => array('contact_id'),
- 'civicrm_case_contact' => array('contact_id'),
- 'civicrm_contact' => array('primary_contact_id'),
- 'civicrm_contribution' => array('contact_id', 'honor_contact_id'),
- 'civicrm_contribution_page' => array('created_id'),
- 'civicrm_contribution_recur' => array('contact_id'),
- 'civicrm_contribution_soft' => array('contact_id'),
- 'civicrm_financial_item' => array('contact_id'),
- 'civicrm_custom_group' => array('created_id'),
- 'civicrm_entity_tag' => array('entity_id'),
- 'civicrm_event' => array('created_id'),
- 'civicrm_grant' => array('contact_id'),
- 'civicrm_group_contact' => array('contact_id'),
- 'civicrm_group_organization' => array('organization_id'),
- 'civicrm_log' => array('modified_id'),
- 'civicrm_mailing' => array('created_id', 'scheduled_id'),
- 'civicrm_mailing_event_queue' => array('contact_id'),
- 'civicrm_mailing_event_subscribe' => array('contact_id'),
- 'civicrm_membership' => array('contact_id'),
- 'civicrm_membership_log' => array('modified_id'),
- 'civicrm_membership_type' => array('member_of_contact_id'),
- 'civicrm_note' => array('contact_id'),
- 'civicrm_participant' => array('contact_id'),
- 'civicrm_pcp' => array('contact_id'),
- 'civicrm_relationship' => array('contact_id_a', 'contact_id_b'),
- 'civicrm_uf_match' => array('contact_id'),
- 'civicrm_uf_group' => array('created_id'),
- 'civicrm_pledge' => array('contact_id'),
- );
-
- $cidRefs += self::getMultiValueCustomSets('cidRefs');
-
- // Add ContactReference custom fields CRM-9561
- $sql = "SELECT cg.table_name, cf.column_name
- FROM civicrm_custom_group cg, civicrm_custom_field cf
- WHERE cg.id = cf.custom_group_id AND cf.data_type = 'ContactReference'";