From 52ac0ffb7dd94067fdcb8e7d6752b7392ebea4d8 Mon Sep 17 00:00:00 2001 From: Coleman Watts Date: Tue, 9 Feb 2021 12:08:39 -0500 Subject: [PATCH] Cleanup - Remove old unused schema/xml files. These are old files from schema tables that no longer exist. --- xml/schema/Bridge/OG.xml | 114 --------------- xml/schema/Bridge/Role.xml | 57 -------- xml/schema/Bridge/files.xml | 8 -- xml/schema/Contact/Household.xml | 79 ---------- xml/schema/Contact/Individual.xml | 204 -------------------------- xml/schema/Contact/Organization.xml | 98 ------------- xml/schema/Core/Preferences.xml | 215 ---------------------------- 7 files changed, 775 deletions(-) delete mode 100644 xml/schema/Bridge/OG.xml delete mode 100644 xml/schema/Bridge/Role.xml delete mode 100644 xml/schema/Bridge/files.xml delete mode 100644 xml/schema/Contact/Household.xml delete mode 100644 xml/schema/Contact/Individual.xml delete mode 100644 xml/schema/Contact/Organization.xml delete mode 100644 xml/schema/Core/Preferences.xml diff --git a/xml/schema/Bridge/OG.xml b/xml/schema/Bridge/OG.xml deleted file mode 100644 index f69a560c03..0000000000 --- a/xml/schema/Bridge/OG.xml +++ /dev/null @@ -1,114 +0,0 @@ - - - - CRM/Bridge - OG - civicrm_bridge_og - An FK table that links between drupal organic group, civicrm group and civicrm acl roles - 2.0 - - id - int unsigned - true - Unique table ID - - Number - - 2.0 - - - id - true - - - drupal_og_id - int unsigned - Foreign key to the organic group. - 2.0 - - - index_drupal_og_id - index_drupal_og_id - 2.0 - - - group_id - int unsigned - Group ID - true - FK to civicrm group. - 2.0 - -
civicrm_group
- id - title - - - Select - - - - - group_id - civicrm_group
- id - 2.0 - - - acl_id - int unsigned - ACL ID - true - FK to civicrm acl. - - - - 2.0 - - - acl_id - civicrm_acl
- id - 2.0 - - - admin_group_id - int unsigned - Admin Group ID - true - FK to admin civicrm group. - 2.0 - - civicrm_group
- id - title - - - Select - - - - - admin_group_id - civicrm_group
- id - 2.0 - - - admin_acl_id - int unsigned - Admin ACL ID - true - FK to civicrm acl. - - - - 2.0 - - - admin_acl_id - civicrm_acl
- id - 2.0 - - diff --git a/xml/schema/Bridge/Role.xml b/xml/schema/Bridge/Role.xml deleted file mode 100644 index 1d0708e6aa..0000000000 --- a/xml/schema/Bridge/Role.xml +++ /dev/null @@ -1,57 +0,0 @@ - - - - CRM/Bridge - Role - civicrm_bridge_role - An FK table that links between civicrm group and drupal roles - 2.0 - - id - int unsigned - true - Unique table ID - - Number - - 2.0 - - - id - true - - - drupal_role_id - int unsigned - Foreign key to the drupal role. - 2.0 - - - index_drupal_role_id - index_drupal_role_id - 2.0 - - - group_id - int unsigned - Group ID - true - FK to civicrm group. - 2.0 - -
civicrm_group
- id - title - - - Select - - - - - group_id - civicrm_group
- id - 2.0 - - diff --git a/xml/schema/Bridge/files.xml b/xml/schema/Bridge/files.xml deleted file mode 100644 index d6ce987b2d..0000000000 --- a/xml/schema/Bridge/files.xml +++ /dev/null @@ -1,8 +0,0 @@ - - - - - - - - diff --git a/xml/schema/Contact/Household.xml b/xml/schema/Contact/Household.xml deleted file mode 100644 index a5134aff33..0000000000 --- a/xml/schema/Contact/Household.xml +++ /dev/null @@ -1,79 +0,0 @@ - - - - CRM/Contact - Household - civicrm_household - Define household specific properties - 1.1 - true - - id - int unsigned - true - Unique Household ID - - Number - - 1.1 - - - id - true - - - contact_id - Contact ID - int unsigned - true - FK to Contact ID - - - - 1.1 - - - contact_id -
civicrm_contact
- id - 1.1 - - - household_name - varchar - 128 - true - /^household|(h(ousehold\s)?name)$/i - /^\w+$/ - Household Name. - - 1.1 - - - index_household_name - household_name - 1.8 - - - primary_contact_id - Primary Contact ID - int unsigned - Optional FK to Primary Contact for this household. - - - - 1.1 - - - primary_contact_id - civicrm_contact
- id - 1.1 - - - UI_contact - contact_id - true - 1.6 - - diff --git a/xml/schema/Contact/Individual.xml b/xml/schema/Contact/Individual.xml deleted file mode 100644 index 6935c9541f..0000000000 --- a/xml/schema/Contact/Individual.xml +++ /dev/null @@ -1,204 +0,0 @@ - - - - CRM/Contact - Individual - civicrm_individual - Define contact-individual specific properties. Extends civicrm_contact. - true - 1.1 - - id - int unsigned - true - Unique Individual ID - - Number - - 1.1 - - - id - true - - - contact_id - Contact ID - int unsigned - true - FK to Contact ID - - - - 1.1 - - - contact_id -
civicrm_contact
- id - 1.1 - - - first_name - varchar - 64 - true - /^first|(f(irst\s)?name)$/i - /^\w+$/ - - First Name. - 1.1 - - - index_first_name - first_name - 1.8 - - - middle_name - varchar - 64 - true - /^middle|(m(iddle\s)?name)$/i - /^\w+$/ - - Middle Name. - 1.1 - - - last_name - varchar - 64 - true - /^(l(ast\s)?name)$/i - /^\w+(\s\w+)?+$/ - Last Name. - - 1.1 - - - index_last_name - last_name - 1.8 - - - prefix_id - int unsigned - Prefix or Title for name (Ms, Mr...). FK to prefix ID - /^(prefix|title)/i - /^(mr|ms|mrs|sir|dr)\.?$/i - 1.2 - - - UI_prefix - prefix_id - 1.6 - - - suffix_id - int unsigned - Suffix for name (Jr, Sr...). FK to suffix ID - /^suffix$/i - /^(sr|jr)\.?|i{2,}$/ - 1.2 - - - UI_suffix - suffix_id - 1.6 - - - greeting_type_id - Greeting Type - int unsigned - FK to civicrm_option_value.id, that has to be valid, registered Greeting type. - 2.2 - - - custom_greeting - varchar - 128 - Custom greeting message. - 1.1 - - - job_title - varchar - 64 - true - /^job|(j(ob\s)?title)$/i - // - Job Title - 1.1 - - - gender_id - int unsigned - /^gender$/i - FK to gender ID - 1.2 - - - UI_gender - gender_id - 1.6 - - - birth_date - date - true - /^birth|(b(irth\s)?date)|D(\W*)O(\W*)B(\W*)$/i - /\d{4}-?\d{2}-?\d{2}/ - Date of birth - 1.1 - - - is_deceased - Deceased - true - true - /i(s\s)?d(eceased)$/i - boolean - 0 - 1.1 - - - deceased_date - date - true - true - /^deceased|(d(eceased\s)?date)$/i - Date of deceased - 1.5 - - - phone_to_household_id - int unsigned - OPTIONAL FK to civicrm_contact_household record. If NOT NULL, direct phone communications to household - rather than individual location. - - 1.1 - - - email_to_household_id - int unsigned - OPTIONAL FK to civicrm_contact_household record. If NOT NULL, direct phone communications to household - rather than individual location. - - 1.1 - - - mail_to_household_id - int unsigned - OPTIONAL FK to civicrm_contact_household record. If NOT NULL, direct mail communications to household - rather than individual location. - - 1.1 - - - UI_contact - contact_id - true - 1.6 - - diff --git a/xml/schema/Contact/Organization.xml b/xml/schema/Contact/Organization.xml deleted file mode 100644 index 696525b6fe..0000000000 --- a/xml/schema/Contact/Organization.xml +++ /dev/null @@ -1,98 +0,0 @@ - - - - CRM/Contact - Organization - civicrm_organization - Define organization specific properties - 1.1 - true - - id - int unsigned - true - Unique Organization ID - - Number - - 1.1 - - - id - true - - - contact_id - Contact ID - int unsigned - true - FK to Contact ID - - - - 1.1 - - - contact_id -
civicrm_contact
- id - 1.1 - - - organization_name - varchar - 128 - true - /^organization|(o(rganization\s)?name)$/i - /^\w+$/ - Organization Name. - - 1.1 - - - index_organization_name - organization_name - 1.8 - - - legal_name - varchar - 128 - true - /^legal|(l(egal\s)?name)$/i - Legal Name. - - 1.1 - - - sic_code - varchar - 8 - true - /^sic|(s(ic\s)?code)$/i - Standard Industry Classification Code. - 1.1 - - - primary_contact_id - Primary Contact ID - int unsigned - Optional FK to Primary Contact for this organization. - - - - 1.1 - - - primary_contact_id - civicrm_contact
- id - 1.1 - - - UI_contact - contact_id - true - 1.6 - - diff --git a/xml/schema/Core/Preferences.xml b/xml/schema/Core/Preferences.xml deleted file mode 100644 index e8de3e45cd..0000000000 --- a/xml/schema/Core/Preferences.xml +++ /dev/null @@ -1,215 +0,0 @@ - - - - CRM/Core - Preferences - civicrm_preferences - Define preferences for the site and users - 1.8 - 4.1 - true - - id - int unsigned - true - - Number - - 1.8 - - - id - true - - - domain_id - Domain ID - int unsigned - true - Which Domain is this menu item for - - - - 3.0 - - - domain_id -
civicrm_domain
- id - CASCADE - 3.0 - - - contact_id - Contact ID - int unsigned - FK to Contact ID - - - - 1.8 - - - contact_id - civicrm_contact
- id - CASCADE - 1.8 - - - is_domain - boolean - Is this the record for the domain setting? - 1.8 - - - location_count - int unsigned - Number of locations to be displayed on edit page? - 1.8 - 3.0 - - - contact_view_options - varchar - 128 - What tabs are displayed in the contact summary - 1.8 - - - index_contact_view_options - contact_view_options - 1.8 - - - contact_edit_options - varchar - 128 - What tabs are displayed in the contact edit - 1.8 - - - index_contact_edit_options - contact_edit_options - 1.8 - - - advanced_search_options - varchar - 128 - What tabs are displayed in the advanced search screen - 1.8 - - - index_advanced_search_options - advanced_search_options - 1.8 - - - user_dashboard_options - varchar - 128 - What tabs are displayed in the contact edit - 1.8 - - - index_user_dashboard_options - user_dashboard_options - 1.8 - - - address_options - varchar - 128 - What fields are displayed from the address table - 1.8 - - - index_address_options - address_options - 1.8 - - - address_format - text - Format to display the address - 1.8 - - - mailing_format - text - Format to display a mailing label - 1.8 - - - display_name_format - text - Format to display contact display name - 3.2 - - - sort_name_format - text - Format to display contact sort name - 3.2 - - - individual_name_format - text - Format to display a individual name - 1.8 - 3.0 - - - address_standardization_provider - varchar - 64 - object name of provider for address standarization - 1.8 - - - address_standardization_userid - varchar - 64 - user id for provider login - 1.8 - - - address_standardization_url - varchar - 255 - url of address standardization service - 1.8 - - - editor_id - int unsigned - 4 - ID of the editor - 2.1 - - - mailing_backend - text - Smtp Backend configuration. - - TextArea - 20 - 80 - - 2.2 - - - navigation - text - Store navigation for the Contact - 3.0 - - - contact_autocomplete_options - varchar - 255 - What Autocomplete has to return - 3.1 - - -- 2.25.1