From 8f069c03ed3f12362a670b4863ecffb8fa7811de Mon Sep 17 00:00:00 2001 From: Eileen McNaughton Date: Mon, 25 Aug 2014 10:18:39 +1200 Subject: [PATCH] CRM-15168 stdise whitespace across schema xml to make editing easier --- xml/schema/Bridge/OG.xml | 132 +- xml/schema/Bridge/Role.xml | 36 +- xml/schema/Case/Case.xml | 292 ++-- xml/schema/Contact/ACLContactCache.xml | 76 +- xml/schema/Contact/Contact.xml | 1421 +++++++++-------- xml/schema/Contact/DashboardContact.xml | 108 +- xml/schema/Contact/Group.xml | 252 +-- xml/schema/Contact/GroupContact.xml | 96 +- xml/schema/Contact/GroupContactCache.xml | 44 +- xml/schema/Contact/Household.xml | 72 +- xml/schema/Contact/Individual.xml | 336 ++-- xml/schema/Contact/Organization.xml | 102 +- xml/schema/Contact/Relationship.xml | 178 ++- xml/schema/Contact/RelationshipType.xml | 189 +-- xml/schema/Contact/SavedSearch.xml | 100 +- xml/schema/Contact/SubscriptionHistory.xml | 176 +- xml/schema/Contribute/ContributionSoft.xml | 192 +-- xml/schema/Contribute/Widget.xml | 158 +- xml/schema/Core/ActionLog.xml | 110 +- xml/schema/Core/ActionMapping.xml | 92 +- xml/schema/Core/ActionSchedule.xml | 356 ++--- xml/schema/Core/Address.xml | 556 +++---- xml/schema/Core/AddressFormat.xml | 24 +- xml/schema/Core/Cache.xml | 42 +- xml/schema/Core/Component.xml | 43 +- xml/schema/Core/EntityFile.xml | 78 +- xml/schema/Core/EntityTag.xml | 118 +- xml/schema/Core/File.xml | 72 +- xml/schema/Core/IM.xml | 114 +- xml/schema/Core/Job.xml | 156 +- xml/schema/Core/JobLog.xml | 96 +- xml/schema/Core/LocationType.xml | 86 +- xml/schema/Core/Log.xml | 86 +- xml/schema/Core/Mapping.xml | 72 +- xml/schema/Core/MappingField.xml | 228 +-- xml/schema/Core/Menu.xml | 144 +- xml/schema/Core/MessageTemplate.xml | 124 +- xml/schema/Core/Navigation.xml | 114 +- xml/schema/Core/OpenID.xml | 96 +- xml/schema/Core/Persistent.xml | 58 +- xml/schema/Core/Preferences.xml | 242 +-- xml/schema/Core/PreferencesDate.xml | 84 +- xml/schema/Core/PrevNextCache.xml | 54 +- xml/schema/Core/Setting.xml | 98 +- xml/schema/Core/StateProvince.xml | 62 +- xml/schema/Core/Tag.xml | 74 +- xml/schema/Core/Timezone.xml | 70 +- xml/schema/Core/UFGroup.xml | 360 ++--- xml/schema/Core/UFJoin.xml | 140 +- xml/schema/Core/UFMatch.xml | 134 +- xml/schema/Core/Website.xml | 84 +- xml/schema/Core/Worldregion.xml | 30 +- xml/schema/Event/EventPage.xml | 420 ++--- xml/schema/Event/Participant.xml | 408 ++--- xml/schema/Event/ParticipantPayment.xml | 56 +- xml/schema/Financial/Currency.xml | 78 +- xml/schema/Financial/PaymentProcessorType.xml | 234 +-- xml/schema/Friend/Friend.xml | 142 +- xml/schema/Queue/QueueItem.xml | 78 +- 59 files changed, 4864 insertions(+), 4809 deletions(-) diff --git a/xml/schema/Bridge/OG.xml b/xml/schema/Bridge/OG.xml index 46f30a553e..14256e1f49 100644 --- a/xml/schema/Bridge/OG.xml +++ b/xml/schema/Bridge/OG.xml @@ -7,93 +7,93 @@ An FK table that links between drupal organic group, civicrm group and civicrm acl roles 2.0 - id - int unsigned - true - Unique table ID - 2.0 + id + int unsigned + true + Unique table ID + 2.0 - id - true + id + true - drupal_og_id - int unsigned - Foreign key to the organic group. - 2.0 + drupal_og_id + int unsigned + Foreign key to the organic group. + 2.0 - index_drupal_og_id - index_drupal_og_id - 2.0 + index_drupal_og_id + index_drupal_og_id + 2.0 - group_id - int unsigned - true - FK to civicrm group. - 2.0 - - civicrm_group
- id - title - - - Select - + group_id + int unsigned + true + FK to civicrm group. + 2.0 + + civicrm_group
+ id + title + + + Select + - group_id - civicrm_group
- id - 2.0 + group_id + civicrm_group
+ id + 2.0 - acl_id - int unsigned - true - FK to civicrm acl. - 2.0 + acl_id + int unsigned + true + FK to civicrm acl. + 2.0 - acl_id - civicrm_acl
- id - 2.0 + acl_id + civicrm_acl
+ id + 2.0 - admin_group_id - int unsigned - true - FK to admin civicrm group. - 2.0 - - civicrm_group
- id - title - - - Select - + admin_group_id + int unsigned + true + FK to admin civicrm group. + 2.0 + + civicrm_group
+ id + title + + + Select + - admin_group_id - civicrm_group
- id - 2.0 + admin_group_id + civicrm_group
+ id + 2.0 - admin_acl_id - int unsigned - true - FK to civicrm acl. - 2.0 + admin_acl_id + int unsigned + true + FK to civicrm acl. + 2.0 - admin_acl_id - civicrm_acl
- id - 2.0 + admin_acl_id + civicrm_acl
+ id + 2.0 diff --git a/xml/schema/Bridge/Role.xml b/xml/schema/Bridge/Role.xml index 2b1357ddd3..52f01cde2a 100644 --- a/xml/schema/Bridge/Role.xml +++ b/xml/schema/Bridge/Role.xml @@ -7,26 +7,26 @@ An FK table that links between civicrm group and drupal roles 2.0 - id - int unsigned - true - Unique table ID - 2.0 + id + int unsigned + true + Unique table ID + 2.0 - id - true + id + true - drupal_role_id - int unsigned - Foreign key to the drupal role. - 2.0 + drupal_role_id + int unsigned + Foreign key to the drupal role. + 2.0 - index_drupal_role_id - index_drupal_role_id - 2.0 + index_drupal_role_id + index_drupal_role_id + 2.0 group_id @@ -44,9 +44,9 @@ - group_id - civicrm_group
- id - 2.0 + group_id + civicrm_group
+ id + 2.0 diff --git a/xml/schema/Case/Case.xml b/xml/schema/Case/Case.xml index 77b565673d..99ccfae54b 100644 --- a/xml/schema/Case/Case.xml +++ b/xml/schema/Case/Case.xml @@ -7,188 +7,188 @@ 1.8 true - id - int unsigned - case_id - true - true - Case ID - Unique Case ID - 1.8 + id + int unsigned + case_id + true + true + Case ID + Unique Case ID + 1.8 - id - true + id + true - contact_id - int unsigned - case_contact_id - true - Contact ID of contact record given case belongs to. - 1.8 - 2.1 + contact_id + int unsigned + case_contact_id + true + Contact ID of contact record given case belongs to. + 1.8 + 2.1 - contact_id - civicrm_contact
- id - 1.8 - 2.1 - CASCADE + contact_id + civicrm_contact
+ id + 1.8 + 2.1 + CASCADE - case_type_id - int unsigned - true - false - Case Type - FK to civicrm_case_type.id - - Select - - - civicrm_case_type
- id - title - - 2.0 + case_type_id + int unsigned + true + false + Case Type + FK to civicrm_case_type.id + + Select + + + civicrm_case_type
+ id + title + + 2.0 - index_case_type_id - case_type_id - 2.0 + index_case_type_id + case_type_id + 2.0 - case_type_id - civicrm_case_type
- id - 4.5 - SET NULL + case_type_id + civicrm_case_type
+ id + 4.5 + SET NULL - casetag1_id - varchar - 128 - true - Id of first case category. - 1.8 - 2.0 + casetag1_id + varchar + 128 + true + Id of first case category. + 1.8 + 2.0 - index_casetag1_id - casetag1_id - 1.8 - 2.0 + index_casetag1_id + casetag1_id + 1.8 + 2.0 - casetag2_id - varchar - 128 - true - Id of second case category. - 1.8 - 2.0 + casetag2_id + varchar + 128 + true + Id of second case category. + 1.8 + 2.0 - index_casetag2_id - casetag2_id - 1.8 - 2.0 + index_casetag2_id + casetag2_id + 1.8 + 2.0 - casetag3_id - varchar - 128 - true - Id of third case category. - 1.8 - 2.0 + casetag3_id + varchar + 128 + true + Id of third case category. + 1.8 + 2.0 - index_casetag3_id - casetag3_id - 1.8 - 2.0 + index_casetag3_id + casetag3_id + 1.8 + 2.0 - subject - varchar - 128 - Case Subject - true - case_subject - Short name of the case. - - Text - - 1.8 + subject + varchar + 128 + Case Subject + true + case_subject + Short name of the case. + + Text + + 1.8 - - start_date - case_start_date - Case Start Date - true - date - Date on which given case starts. - - Select Date - - 1.8 + + start_date + case_start_date + Case Start Date + true + date + Date on which given case starts. + + Select Date + + 1.8 - end_date - case_end_date - Case End Date - true - date - Date on which given case ends. - - Select Date - - 1.8 + end_date + case_end_date + Case End Date + true + date + Date on which given case ends. + + Select Date + + 1.8 - details - text - - TextArea - 8 - 60 - - Details about the meeting (agenda, notes, etc). - 1.8 + details + text + + TextArea + 8 + 60 + + Details about the meeting (agenda, notes, etc). + 1.8 - status_id - int unsigned - case_status_id - true - true - false - Case Status - Id of case status. - - case_status - - - Select - - 1.8 + status_id + int unsigned + case_status_id + true + true + false + Case Status + Id of case status. + + case_status + + + Select + + 1.8 - is_deleted - Case is in the Trash - case_deleted - boolean - 0 - true - Case Deleted - 2.2 + is_deleted + Case is in the Trash + case_deleted + boolean + 0 + true + Case Deleted + 2.2 - index_is_deleted - is_deleted - 2.2 + index_is_deleted + is_deleted + 2.2 diff --git a/xml/schema/Contact/ACLContactCache.xml b/xml/schema/Contact/ACLContactCache.xml index 32448ead05..f584a4de74 100644 --- a/xml/schema/Contact/ACLContactCache.xml +++ b/xml/schema/Contact/ACLContactCache.xml @@ -7,56 +7,56 @@ Join table cache for contacts that a user has permission on. 3.1 - id - int unsigned - true - primary key - 3.1 + id + int unsigned + true + primary key + 3.1 - id - true + id + true - user_id - int unsigned - FK to civicrm_contact (could be null for anon user) - 3.1 + user_id + int unsigned + FK to civicrm_contact (could be null for anon user) + 3.1 - user_id - civicrm_contact
- id - 3.1 - CASCADE + user_id + civicrm_contact
+ id + 3.1 + CASCADE - contact_id - int unsigned - true - FK to civicrm_contact - 3.1 + contact_id + int unsigned + true + FK to civicrm_contact + 3.1 - contact_id - civicrm_contact
- id - 3.1 - CASCADE + contact_id + civicrm_contact
+ id + 3.1 + CASCADE - operation - varchar - 8 - true - What operation does this user have permission on? - - CRM_ACL_BAO_ACL::operation - - 1.6 - - Select - + operation + varchar + 8 + true + What operation does this user have permission on? + + CRM_ACL_BAO_ACL::operation + + 1.6 + + Select + UI_user_contact_operation diff --git a/xml/schema/Contact/Contact.xml b/xml/schema/Contact/Contact.xml index 82bf0b532d..803396d89b 100644 --- a/xml/schema/Contact/Contact.xml +++ b/xml/schema/Contact/Contact.xml @@ -7,131 +7,131 @@ Contact objects are defined by a civicrm_contact record plus a related civicrm_contact_type record. 1.1 true - - id - int unsigned - Internal Contact ID - true - /internal|contact?|id$/i - true - Unique Contact ID - 1.1 + + id + int unsigned + Internal Contact ID + true + /internal|contact?|id$/i + true + Unique Contact ID + 1.1 - id - true + id + true - contact_type - Contact Type - varchar - 64 - Type of Contact. - true - - civicrm_contact_type
- name - label - parent_id IS NULL - - - Select - - 1.1 - 3.1 + contact_type + Contact Type + varchar + 64 + Type of Contact. + true + + civicrm_contact_type
+ name + label + parent_id IS NULL + + + Select + + 1.1 + 3.1 - index_contact_type - contact_type - 2.1 + index_contact_type + contact_type + 2.1 - contact_sub_type - Contact Subtype - varchar - 255 - true - true - /C(ontact )?(subtype|sub-type|sub type)/i - May be used to over-ride contact view and edit templates. - - civicrm_contact_type
- name - label - parent_id IS NOT NULL - - - Multi-Select - - 1.5 + contact_sub_type + Contact Subtype + varchar + 255 + true + true + /C(ontact )?(subtype|sub-type|sub type)/i + May be used to over-ride contact view and edit templates. + + civicrm_contact_type
+ name + label + parent_id IS NOT NULL + + + Multi-Select + + 1.5 - index_contact_sub_type - contact_sub_type - - Multi-Select - - 2.1 + index_contact_sub_type + contact_sub_type + + Multi-Select + + 2.1 - do_not_email - boolean - true - /d(o )?(not )?(email)/i - /^\d{1,}$/ - 0 - - CheckBox - - 1.1 - - - do_not_phone - boolean - 0 - true - /d(o )?(not )?(call|phone)/i - /^\d{1,}$/ - 1.1 - - CheckBox - - - - do_not_mail - boolean - true - /^(d(o\s)?n(ot\s)?mail)|(\w*)?bulk\s?(\w*)$/i - /^\d{1,}$/ - 0 - 1.1 - - CheckBox - - - - do_not_sms - boolean - true - /d(o )?(not )?(sms)/i - /^\d{1,}$/ - 0 - 3.0 - - CheckBox - - - - do_not_trade - boolean - true - /d(o )?(not )?(trade)/i - /^\d{1,}$/ - 0 - 1.1 - - CheckBox - + do_not_email + boolean + true + /d(o )?(not )?(email)/i + /^\d{1,}$/ + 0 + + CheckBox + + 1.1 + + + do_not_phone + boolean + 0 + true + /d(o )?(not )?(call|phone)/i + /^\d{1,}$/ + 1.1 + + CheckBox + + + + do_not_mail + boolean + true + /^(d(o\s)?n(ot\s)?mail)|(\w*)?bulk\s?(\w*)$/i + /^\d{1,}$/ + 0 + 1.1 + + CheckBox + + + + do_not_sms + boolean + true + /d(o )?(not )?(sms)/i + /^\d{1,}$/ + 0 + 3.0 + + CheckBox + + + + do_not_trade + boolean + true + /d(o )?(not )?(trade)/i + /^\d{1,}$/ + 0 + 1.1 + + CheckBox + is_opt_out @@ -143,672 +143,681 @@ Has the contact opted out from receiving all bulk email from the organization or site domain? 1.1 - CheckBox - + CheckBox + - legal_identifier - varchar - 32 - true - /legal\s?id/i - /\w+?\d{5,}/ - May be used for SSN, EIN/TIN, Household ID (census) or other applicable unique legal/government ID. - 1.1 - - Text - + legal_identifier + varchar + 32 + true + /legal\s?id/i + /\w+?\d{5,}/ + May be used for SSN, EIN/TIN, Household ID (census) or other applicable unique legal/government ID. + + 1.1 + + Text + - external_identifier - varchar - 32 - - Text - EIGHT - + external_identifier + varchar + 32 + + Text + EIGHT + - true - /external\s?id/i - /^\d{11,}$/ - Unique trusted external ID (generally from a legacy app/datasource). Particularly useful for deduping operations. - 1.1 + true + /external\s?id/i + /^\d{11,}$/ + Unique trusted external ID (generally from a legacy app/datasource). Particularly useful for deduping + operations. + + 1.1 - UI_external_identifier - true - external_identifier - 1.7 + UI_external_identifier + true + external_identifier + 1.7 - sort_name - Sort Name - varchar - 128 - - Text - BIG - + sort_name + Sort Name + varchar + 128 + + Text + BIG + - true - Name used for sorting different contact types - 1.1 + true + Name used for sorting different contact types + 1.1 - index_sort_name - sort_name - 2.1 + index_sort_name + sort_name + 2.1 - display_name - Display Name - varchar - 128 - - Text - BIG - + display_name + Display Name + varchar + 128 + + Text + BIG + - true - Formatted name representing preferred format for display/print/other output. - 1.1 - - - nick_name - Nickname - varchar - 128 - - Text - BIG - + true + Formatted name representing preferred format for display/print/other output. + 1.1 + + + nick_name + Nickname + varchar + 128 + + Text + BIG + - true - /n(ick\s)name|nick$/i - /^\w+$/ - Nickname. - - 1.1 - - - legal_name - varchar - 128 - - Text - BIG - + true + /n(ick\s)name|nick$/i + /^\w+$/ + Nickname. + + 1.1 + + + legal_name + varchar + 128 + + Text + BIG + - true - /^legal|(l(egal\s)?name)$/i - Legal Name. - - 1.1 - - - home_URL - url - Website - varchar - 128 - - Text - BIG - + true + /^legal|(l(egal\s)?name)$/i + Legal Name. + + 1.1 + + + home_URL + url + Website + varchar + 128 + + Text + BIG + - true - /^(home\sURL)|URL|web|site/i - /^[\w\/\:\.]+$/ - optional "home page" URL for this contact. - 1.1 - 3.2 - - - image_URL - varchar - 255 - true - optional URL for preferred image (photo, logo, etc.) to display for this contact. - 1.1 - - Text - - - - preferred_communication_method - Preferred Communication Method - varchar - 255 - true - /^p(ref\w*\s)?c(omm\w*)|( meth\w*)$/i - /^\w+$/ - What is the preferred mode of communication. - 1.1 - - preferred_communication_method - - - Select - + true + /^(home\sURL)|URL|web|site/i + /^[\w\/\:\.]+$/ + optional "home page" URL for this contact. + 1.1 + 3.2 + + + image_URL + varchar + 255 + true + optional URL for preferred image (photo, logo, etc.) to display for this contact. + 1.1 + + Text + + + + preferred_communication_method + Preferred Communication Method + varchar + 255 + true + /^p(ref\w*\s)?c(omm\w*)|( meth\w*)$/i + /^\w+$/ + What is the preferred mode of communication. + 1.1 + + preferred_communication_method + + + Select + - index_preferred_communication_method - preferred_communication_method - 1.6 + index_preferred_communication_method + preferred_communication_method + 1.6 - preferred_language - Preferred Language - varchar - 5 - Which language is preferred for communication. FK to languages in civicrm_option_value. - /^lang/i - true - - languages - name - - - Select - - 3.2 - - - preferred_mail_format - varchar - 8 - "Both" - true - /^p(ref\w*\s)?m(ail\s)?f(orm\w*)$/i - What is the preferred mode of sending an email. - 1.1 - - CRM_Core_SelectValues::pmf - - - Select - - - - hash - Contact Hash - varchar - 32 - Key for validating requests related to this contact. - 1.1 - 1.5 - true + preferred_language + Preferred Language + varchar + 5 + Which language is preferred for communication. FK to languages in civicrm_option_value. + /^lang/i + true + + languages + name + + + Select + + 3.2 + + + preferred_mail_format + varchar + 8 + "Both" + true + /^p(ref\w*\s)?m(ail\s)?f(orm\w*)$/i + What is the preferred mode of sending an email. + 1.1 + + CRM_Core_SelectValues::pmf + + + Select + + + + hash + Contact Hash + varchar + 32 + Key for validating requests related to this contact. + 1.1 + 1.5 + true - index_hash - hash - 2.1 + index_hash + hash + 2.1 - api_key - varchar - 32 - API Key for validating requests related to this contact. - 2.2 + api_key + varchar + 32 + API Key for validating requests related to this contact. + 2.2 - index_api_key - api_key - 2.1 + index_api_key + api_key + 2.1 - source - Source of Contact Data - contact_source - varchar - 255 - - Text - BIG - + source + Source of Contact Data + contact_source + varchar + 255 + + Text + BIG + - true - /(S(ource\s)?o(f\s)?C(ontact\s)?Data)$/i - where contact come from, e.g. import, donate module insert... - 1.1 - - - first_name - varchar - 64 - - Text - BIG - - true - /^first|(f(irst\s)?name)$/i - /^\w+$/ - - First Name. - 1.1 + true + /(S(ource\s)?o(f\s)?C(ontact\s)?Data)$/i + where contact come from, e.g. import, donate module insert... + 1.1 + + + first_name + varchar + 64 + + Text + BIG + + true + /^first|(f(irst\s)?name)$/i + /^\w+$/ + + First Name. + 1.1 - index_first_name - first_name - 1.8 + index_first_name + first_name + 1.8 - middle_name - varchar - 64 - - Text - MEDIUM - - true - /^middle|(m(iddle\s)?name)$/i - /^\w+$/ - - Middle Name. - 1.1 - - - last_name - varchar - 64 - - Text - BIG - - true - /^last|(l(ast\s)?name)$/i - /^\w+(\s\w+)?+$/ - Last Name. - - 1.1 + middle_name + varchar + 64 + + Text + MEDIUM + + true + /^middle|(m(iddle\s)?name)$/i + /^\w+$/ + + Middle Name. + 1.1 + + + last_name + varchar + 64 + + Text + BIG + + true + /^last|(l(ast\s)?name)$/i + /^\w+(\s\w+)?+$/ + Last Name. + + 1.1 - index_last_name - last_name - 1.8 - - Text - + index_last_name + last_name + 1.8 + + Text + - prefix_id - Individual Prefix - int unsigned - Prefix or Title for name (Ms, Mr...). FK to prefix ID - - individual_prefix - - - Select - - /^(prefix|title)/i - /^(mr|ms|mrs|sir|dr)\.?$/i - true - 1.2 + prefix_id + Individual Prefix + int unsigned + Prefix or Title for name (Ms, Mr...). FK to prefix ID + + individual_prefix + + + Select + + /^(prefix|title)/i + /^(mr|ms|mrs|sir|dr)\.?$/i + true + 1.2 - UI_prefix - prefix_id - 1.6 + UI_prefix + prefix_id + 1.6 - suffix_id - Individual Suffix - int unsigned - - individual_suffix - - - Select - - true - Suffix for name (Jr, Sr...). FK to suffix ID - /^suffix$/i - /^(sr|jr)\.?|i{2,}$/ - 1.2 + suffix_id + Individual Suffix + int unsigned + + individual_suffix + + + Select + + true + Suffix for name (Jr, Sr...). FK to suffix ID + /^suffix$/i + /^(sr|jr)\.?|i{2,}$/ + 1.2 - UI_suffix - suffix_id - 1.6 + UI_suffix + suffix_id + 1.6 - formal_title - varchar - 64 - true - /^title/i - Formal (academic or similar) title in front of name. (Prof., Dr. etc.) - 4.5 - - - communication_style_id - Communication Style - int unsigned - - communication_style - - true - Communication style (e.g. formal vs. familiar) to use with this contact. FK to communication styles in civicrm_option_value. - 4.4 + formal_title + varchar + 64 + true + /^title/i + Formal (academic or similar) title in front of name. (Prof., Dr. etc.) + 4.5 + + + communication_style_id + Communication Style + int unsigned + + communication_style + + true + Communication style (e.g. formal vs. familiar) to use with this contact. FK to communication styles in + civicrm_option_value. + + 4.4 - index_communication_style_id - communication_style_id - 4.4 + index_communication_style_id + communication_style_id + 4.4 - greeting_type - varchar - 128 - true - Preferred greeting format. - 1.1 - 2.2 - - - greeting_type_id - Greeting Type - int unsigned - FK to civicrm_option_value.id, that has to be valid, registered Greeting type. - 2.2 - 3.0 - - - custom_greeting - varchar - 128 - true - Custom greeting message. - 1.1 - 3.0 - - - email_greeting_id - int unsigned - Email Greeting ID - FK to civicrm_option_value.id, that has to be valid registered Email Greeting. - 3.0 - - - email_greeting_custom - varchar - 128 - true - false - Custom Email Greeting. - 3.0 - - Text - - - - email_greeting_display - Email Greeting - varchar - 255 - Cache Email Greeting. - 3.0 - - Text - - - - postal_greeting_id - int unsigned - Postal Greeting ID - FK to civicrm_option_value.id, that has to be valid registered Postal Greeting. - 3.0 - - Text - - - - postal_greeting_custom - varchar - 128 - true - false - Custom Postal greeting. - 3.0 - - Text - - - - postal_greeting_display - Postal Greeting - varchar - 255 - Cache Postal greeting. - 3.0 - - Text - - - - addressee_id - int unsigned - Addressee ID - FK to civicrm_option_value.id, that has to be valid registered Addressee. - 3.0 - - - addressee_custom - varchar - 128 - true - false - Custom Addressee. - 3.0 - - Text - - - - addressee_display - Addressee - varchar - 255 - Cache Addressee. - 3.0 - - Text - - - - job_title - varchar - 255 - - Text - MEDIUM - - true - /^job|(j(ob\s)?title)$/i - // - Job Title - 1.1 - - - gender_id - Gender - int unsigned - - gender - - - Select - - /^gender$/i - FK to gender ID - true - 1.2 + greeting_type + varchar + 128 + true + Preferred greeting format. + 1.1 + 2.2 + + + greeting_type_id + Greeting Type + int unsigned + FK to civicrm_option_value.id, that has to be valid, registered Greeting type. + 2.2 + 3.0 + + + custom_greeting + varchar + 128 + true + Custom greeting message. + 1.1 + 3.0 + + + email_greeting_id + int unsigned + Email Greeting ID + FK to civicrm_option_value.id, that has to be valid registered Email Greeting. + 3.0 + + + email_greeting_custom + varchar + 128 + true + false + Custom Email Greeting. + 3.0 + + Text + + + + email_greeting_display + Email Greeting + varchar + 255 + Cache Email Greeting. + 3.0 + + Text + + + + postal_greeting_id + int unsigned + Postal Greeting ID + FK to civicrm_option_value.id, that has to be valid registered Postal Greeting. + 3.0 + + Text + + + + postal_greeting_custom + varchar + 128 + true + false + Custom Postal greeting. + 3.0 + + Text + + + + postal_greeting_display + Postal Greeting + varchar + 255 + Cache Postal greeting. + 3.0 + + Text + + + + addressee_id + int unsigned + Addressee ID + FK to civicrm_option_value.id, that has to be valid registered Addressee. + 3.0 + + + addressee_custom + varchar + 128 + true + false + Custom Addressee. + 3.0 + + Text + + + + addressee_display + Addressee + varchar + 255 + Cache Addressee. + 3.0 + + Text + + + + job_title + varchar + 255 + + Text + MEDIUM + + true + /^job|(j(ob\s)?title)$/i + // + Job Title + 1.1 + + + gender_id + Gender + int unsigned + + gender + + + Select + + /^gender$/i + FK to gender ID + true + 1.2 - UI_gender - gender_id - 1.6 - - Select - + UI_gender + gender_id + 1.6 + + Select + - 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 - - Select Date - - - - is_deceased - Is Deceased - true - true - /i(s\s)?d(eceased)$/i - boolean - 0 - 1.1 - - CheckBox - - - - deceased_date - date - true - true - /^deceased|(d(eceased\s)?date)$/i - Date of deceased - 1.5 - - Select Date - - - - mail_to_household_id - 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. - true - 1.1 - 3.3 + 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 + + Select Date + + + + is_deceased + Is Deceased + true + true + /i(s\s)?d(eceased)$/i + boolean + 0 + 1.1 + + CheckBox + + + + deceased_date + date + true + true + /^deceased|(d(eceased\s)?date)$/i + Date of deceased + 1.5 + + Select Date + + + + mail_to_household_id + 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. + + true + 1.1 + 3.3 - mail_to_household_id - civicrm_contact
- id - 2.1 - SET NULL - 3.3 + mail_to_household_id + civicrm_contact
+ id + 2.1 + SET NULL + 3.3 - household_name - varchar - 128 - - Text - BIG - - true - /^household|(h(ousehold\s)?name)$/i - /^\w+$/ - Household Name. - - 1.1 + household_name + varchar + 128 + + Text + BIG + + true + /^household|(h(ousehold\s)?name)$/i + /^\w+$/ + Household Name. + + 1.1 - index_household_name - household_name - 1.8 + index_household_name + household_name + 1.8 - primary_contact_id - int unsigned - Household Primary Contact ID - Optional FK to Primary Contact for this household. - 1.1 - - Select - + primary_contact_id + int unsigned + Household Primary Contact ID + Optional FK to Primary Contact for this household. + 1.1 + + Select + - primary_contact_id - civicrm_contact
- id - 1.1 - SET NULL + primary_contact_id + civicrm_contact
+ id + 1.1 + SET NULL - organization_name - varchar - 128 - - Text - BIG - - true - /^organization|(o(rganization\s)?name)$/i - /^\w+$/ - Organization Name. - - 1.1 + organization_name + varchar + 128 + + Text + BIG + + true + /^organization|(o(rganization\s)?name)$/i + /^\w+$/ + Organization Name. + + 1.1 - index_organization_name - organization_name - 1.8 + index_organization_name + organization_name + 1.8 - sic_code - varchar - 8 - true - /^sic|(s(ic\s)?code)$/i - Standard Industry Classification Code. - 1.1 - - Text - - - - user_unique_id - url - Unique ID (OpenID) - varchar - 255 - true - /^Open\s?ID|u(niq\w*)?\s?ID/i - /^[\w\/\:\.]+$/ - the OpenID (or OpenID-style http://username.domain/) unique identifier for this contact mainly used for logging in to CiviCRM - 2.0 - - Text - - - - employer_id - Current Employer ID - current_employer_id - int unsigned - OPTIONAL FK to civicrm_contact record. - true - 2.1 - - Autocomplete-Select - + sic_code + varchar + 8 + true + /^sic|(s(ic\s)?code)$/i + Standard Industry Classification Code. + 1.1 + + Text + + + + user_unique_id + url + Unique ID (OpenID) + varchar + 255 + true + /^Open\s?ID|u(niq\w*)?\s?ID/i + /^[\w\/\:\.]+$/ + the OpenID (or OpenID-style http://username.domain/) unique identifier for this contact mainly used for + logging in to CiviCRM + + 2.0 + + Text + + + + employer_id + Current Employer ID + current_employer_id + int unsigned + OPTIONAL FK to civicrm_contact record. + true + 2.1 + + Autocomplete-Select + - employer_id - civicrm_contact
- id - 2.1 - SET NULL + employer_id + civicrm_contact
+ id + 2.1 + SET NULL is_deleted diff --git a/xml/schema/Contact/DashboardContact.xml b/xml/schema/Contact/DashboardContact.xml index b09b4ea206..dfb94a73f3 100644 --- a/xml/schema/Contact/DashboardContact.xml +++ b/xml/schema/Contact/DashboardContact.xml @@ -7,70 +7,70 @@ Table to store dashboard for each contact. 3.1 - id - int unsigned - true - 3.1 + id + int unsigned + true + 3.1 - id - true + id + true - dashboard_id - int unsigned - true - Dashboard ID - 3.1 + dashboard_id + int unsigned + true + Dashboard ID + 3.1 - dashboard_id - civicrm_dashboard
- id - CASCADE - 3.1 + dashboard_id + civicrm_dashboard
+ id + CASCADE + 3.1 - contact_id - int unsigned - true - Contact ID - 3.1 + contact_id + int unsigned + true + Contact ID + 3.1 - contact_id - civicrm_contact
- id - CASCADE - 3.1 + contact_id + civicrm_contact
+ id + CASCADE + 3.1 - column_no - boolean - column no for this widget - 0 - 3.1 + column_no + boolean + column no for this widget + 0 + 3.1 - is_minimized - boolean - Is Minimized? - 0 - 3.1 + is_minimized + boolean + Is Minimized? + 0 + 3.1 - is_fullscreen - boolean - Is Fullscreen? - 1 - 3.1 + is_fullscreen + boolean + Is Fullscreen? + 1 + 3.1 - is_active - boolean - Is this widget active? - 0 - 3.1 + is_active + boolean + Is this widget active? + 0 + 3.1 weight @@ -80,15 +80,15 @@ 3.1 - content - longtext - dashlet content - 3.3 + content + longtext + dashlet content + 3.3 - created_date - datetime - When was content populated - 3.3 + created_date + datetime + When was content populated + 3.3 diff --git a/xml/schema/Contact/Group.xml b/xml/schema/Contact/Group.xml index 5cab0e21b0..6f68023e73 100644 --- a/xml/schema/Contact/Group.xml +++ b/xml/schema/Contact/Group.xml @@ -8,132 +8,132 @@ 1.1 true - id - int unsigned - Group ID - true - Group ID - 1.1 + id + int unsigned + Group ID + true + Group ID + 1.1 - id - true + id + true - name - varchar - Group Name - 64 - Internal name of Group. - 1.1 - - - title - varchar - Group Title - 64 - true - Name of Group. - 1.1 - - - description - text - Group Description - - TextArea - 2 - 60 - - Optional verbose description of the group. - 1.1 - - - source - varchar - Group Source - 64 - Module or process which created this group. - 1.1 - - - saved_search_id - int unsigned - Saved Search ID - FK to saved search table. - 1.1 + name + varchar + Group Name + 64 + Internal name of Group. + 1.1 - - saved_search_id - civicrm_saved_search
- id - 1.1 - SET NULL - - is_active - boolean - Group Enabled - Is this entry active? - 1.1 + title + varchar + Group Title + 64 + true + Name of Group. + 1.1 - visibility - varchar - 24 - Group Visibility Setting - 'User and User Admin Only' - In what context(s) is this field visible. - - CRM_Core_SelectValues::groupVisibility - - 1.2 - - Select - + description + text + Group Description + + TextArea + 2 + 60 + + Optional verbose description of the group. + 1.1 + + + source + varchar + Group Source + 64 + Module or process which created this group. + 1.1 + + + saved_search_id + int unsigned + Saved Search ID + FK to saved search table. + 1.1 + + saved_search_id + civicrm_saved_search
+ id + 1.1 + SET NULL + - where_clause - text - Group Where Clause - the sql where clause if a saved search acl - 1.6 + is_active + boolean + Group Enabled + Is this entry active? + 1.1 + + + visibility + varchar + 24 + Group Visibility Setting + 'User and User Admin Only' + In what context(s) is this field visible. + + CRM_Core_SelectValues::groupVisibility + + 1.2 + + Select + + + + where_clause + text + Group Where Clause + the sql where clause if a saved search acl + 1.6 - select_tables - text - Tables For Select Clause - the tables to be included in a select data - 1.6 + select_tables + text + Tables For Select Clause + the tables to be included in a select data + 1.6 - where_tables - text - Tables For Where Clause - the tables to be included in the count statement - 1.6 + where_tables + text + Tables For Where Clause + the tables to be included in the count statement + 1.6 - group_type - varchar - Group Type - 128 - FK to group type - 1.9 + group_type + varchar + Group Type + 128 + FK to group type + 1.9 - cache_date - datetime - Group Cache Date - Date when we created the cache for a smart group - 2.1 + cache_date + datetime + Group Cache Date + Date when we created the cache for a smart group + 2.1 - refresh_date - datetime - Next Group Refresh Time - Date and time when we need to refresh the cache next. - 4.3 + refresh_date + datetime + Next Group Refresh Time + Date and time when we need to refresh the cache next. + 4.3 parents @@ -182,31 +182,31 @@ 2.1 - created_id - int unsigned - Group Created By - FK to contact table. - 4.3 + created_id + int unsigned + Group Created By + FK to contact table. + 4.3 - created_id - civicrm_contact
- id - 4.3 - SET NULL + created_id + civicrm_contact
+ id + 4.3 + SET NULL - modified_id - int unsigned - Group Modified By - FK to contact table. - 4.5 + modified_id + int unsigned + Group Modified By + FK to contact table. + 4.5 - modified_id - civicrm_contact
- id - 4.5 - SET NULL + modified_id + civicrm_contact
+ id + 4.5 + SET NULL diff --git a/xml/schema/Contact/GroupContact.xml b/xml/schema/Contact/GroupContact.xml index 014b2b028c..22f3dd8bef 100644 --- a/xml/schema/Contact/GroupContact.xml +++ b/xml/schema/Contact/GroupContact.xml @@ -4,20 +4,22 @@ CRM/Contact GroupContact civicrm_group_contact - Join table sets membership for 'static' groups. Also used to store 'opt-out' entries for 'query' type groups (status = 'OUT') + Join table sets membership for 'static' groups. Also used to store 'opt-out' entries for 'query' type groups + (status = 'OUT') + 1.1 true - id - int unsigned - Group Contact ID - true - primary key - 1.1 + id + int unsigned + Group Contact ID + true + primary key + 1.1 - id - true + id + true group_id @@ -36,47 +38,47 @@ - group_id - civicrm_group
- id - 1.1 - CASCADE + group_id + civicrm_group
+ id + 1.1 + CASCADE - contact_id - int unsigned - Contact ID - true - FK to civicrm_contact - 1.1 + contact_id + int unsigned + Contact ID + true + FK to civicrm_contact + 1.1 - contact_id - civicrm_contact
- id - 1.1 - CASCADE + contact_id + civicrm_contact
+ id + 1.1 + CASCADE - status - varchar - 8 - Group Contact Status - status of contact relative to membership in group - - CRM_Core_SelectValues::groupContactStatus - - 1.1 - - Select - + status + varchar + 8 + Group Contact Status + status of contact relative to membership in group + + CRM_Core_SelectValues::groupContactStatus + + 1.1 + + Select + - location_id - int unsigned - Group Contact Location - Optional location to associate with this membership - 1.1 + location_id + int unsigned + Group Contact Location + Optional location to associate with this membership + 1.1 location_id @@ -86,11 +88,11 @@ SET NULL - email_id - int unsigned - Group Contact Email - Optional email to associate with this membership - 1.1 + email_id + int unsigned + Group Contact Email + Optional email to associate with this membership + 1.1 email_id diff --git a/xml/schema/Contact/GroupContactCache.xml b/xml/schema/Contact/GroupContactCache.xml index 7be337fca3..f14894a0e3 100644 --- a/xml/schema/Contact/GroupContactCache.xml +++ b/xml/schema/Contact/GroupContactCache.xml @@ -7,15 +7,15 @@ Join table cache for 'static' groups. 2.1 - id - int unsigned - true - primary key - 2.1 + id + int unsigned + true + primary key + 2.1 - id - true + id + true group_id @@ -33,25 +33,25 @@ - group_id - civicrm_group
- id - 2.1 - CASCADE + group_id + civicrm_group
+ id + 2.1 + CASCADE - contact_id - int unsigned - true - FK to civicrm_contact - 2.1 + contact_id + int unsigned + true + FK to civicrm_contact + 2.1 - contact_id - civicrm_contact
- id - 2.1 - CASCADE + contact_id + civicrm_contact
+ id + 2.1 + CASCADE UI_contact_group diff --git a/xml/schema/Contact/Household.xml b/xml/schema/Contact/Household.xml index 827312783a..89f4216792 100644 --- a/xml/schema/Contact/Household.xml +++ b/xml/schema/Contact/Household.xml @@ -8,56 +8,56 @@ 1.1 true - id - int unsigned - true - Unique Household ID - 1.1 + id + int unsigned + true + Unique Household ID + 1.1 - id - true + id + true - contact_id - int unsigned - true - FK to Contact ID - 1.1 + contact_id + int unsigned + true + FK to Contact ID + 1.1 - contact_id - civicrm_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 + household_name + varchar + 128 + true + /^household|(h(ousehold\s)?name)$/i + /^\w+$/ + Household Name. + + 1.1 - index_household_name - household_name - 1.8 + index_household_name + household_name + 1.8 - primary_contact_id - int unsigned - Optional FK to Primary Contact for this household. - 1.1 + primary_contact_id + int unsigned + Optional FK to Primary Contact for this household. + 1.1 - primary_contact_id - civicrm_contact
- id - 1.1 + primary_contact_id + civicrm_contact
+ id + 1.1 UI_contact diff --git a/xml/schema/Contact/Individual.xml b/xml/schema/Contact/Individual.xml index c361dc46ce..552d46f11a 100644 --- a/xml/schema/Contact/Individual.xml +++ b/xml/schema/Contact/Individual.xml @@ -8,213 +8,219 @@ true 1.1 - id - int unsigned - true - Unique Individual ID - 1.1 + id + int unsigned + true + Unique Individual ID + 1.1 - id - true + id + true - contact_id - int unsigned - true - FK to Contact ID - 1.1 + contact_id + int unsigned + true + FK to Contact ID + 1.1 - contact_id - civicrm_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 + first_name + varchar + 64 + true + /^first|(f(irst\s)?name)$/i + /^\w+$/ + + First Name. + 1.1 - index_first_name - first_name - 1.8 + 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 + 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 + index_last_name + last_name + 1.8 - gender - enum - true - Female, Male, Transgender - 1.1 - 1.2 + gender + enum + true + Female, Male, Transgender + 1.1 + 1.2 - 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 + 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 + 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 + 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 + UI_suffix + suffix_id + 1.6 - prefix - varchar - 64 - true - Prefix to Name. - 1.1 - 1.2 + prefix + varchar + 64 + true + Prefix to Name. + 1.1 + 1.2 - suffix - varchar - 64 - true - Suffix to Name. - 1.1 - 1.2 + suffix + varchar + 64 + true + Suffix to Name. + 1.1 + 1.2 - greeting_type - varchar - 128 - Preferred greeting format. - 1.1 - 2.2 + greeting_type + varchar + 128 + Preferred greeting format. + 1.1 + 2.2 - greeting_type_id - Greeting Type - int unsigned - FK to civicrm_option_value.id, that has to be valid, registered Greeting type. - 2.2 + 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 + custom_greeting + varchar + 128 + Custom greeting message. + 1.1 - job_title - varchar - 64 - true - /^job|(j(ob\s)?title)$/i - // - Job Title - 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 + gender_id + int unsigned + /^gender$/i + FK to gender ID + 1.2 - UI_gender - gender_id - 1.6 + 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 - Is 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 + 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 + Is 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 diff --git a/xml/schema/Contact/Organization.xml b/xml/schema/Contact/Organization.xml index c5836fb0fe..bb5c88b827 100644 --- a/xml/schema/Contact/Organization.xml +++ b/xml/schema/Contact/Organization.xml @@ -8,75 +8,75 @@ 1.1 true - id - int unsigned - true - Unique Organization ID - 1.1 + id + int unsigned + true + Unique Organization ID + 1.1 - id - true + id + true - contact_id - int unsigned - true - FK to Contact ID - 1.1 + contact_id + int unsigned + true + FK to Contact ID + 1.1 - contact_id - civicrm_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 + organization_name + varchar + 128 + true + /^organization|(o(rganization\s)?name)$/i + /^\w+$/ + Organization Name. + + 1.1 - index_organization_name - organization_name - 1.8 + index_organization_name + organization_name + 1.8 - legal_name - varchar - 128 - true - /^legal|(l(egal\s)?name)$/i - Legal Name. - - 1.1 + 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 + sic_code + varchar + 8 + true + /^sic|(s(ic\s)?code)$/i + Standard Industry Classification Code. + 1.1 - primary_contact_id - int unsigned - Optional FK to Primary Contact for this organization. - 1.1 + primary_contact_id + int unsigned + Optional FK to Primary Contact for this organization. + 1.1 - primary_contact_id - civicrm_contact
- id - 1.1 + primary_contact_id + civicrm_contact
+ id + 1.1 UI_contact diff --git a/xml/schema/Contact/Relationship.xml b/xml/schema/Contact/Relationship.xml index 20f3362b83..b3be05c34d 100644 --- a/xml/schema/Contact/Relationship.xml +++ b/xml/schema/Contact/Relationship.xml @@ -8,123 +8,125 @@ 1.1 true - id - int unsigned - Relationship ID - true - Relationship ID - 1.1 + id + int unsigned + Relationship ID + true + Relationship ID + 1.1 - id - true + id + true - contact_id_a - int unsigned - Contact A - true - id of the first contact - 1.1 + contact_id_a + int unsigned + Contact A + true + id of the first contact + 1.1 - contact_id_a - civicrm_contact
- id - 1.1 - CASCADE + contact_id_a + civicrm_contact
+ id + 1.1 + CASCADE - contact_id_b - int unsigned - Contact B - true - id of the second contact - 1.1 + contact_id_b + int unsigned + Contact B + true + id of the second contact + 1.1 - contact_id_b - civicrm_contact
- id - 1.1 - CASCADE + contact_id_b + civicrm_contact
+ id + 1.1 + CASCADE - relationship_type_id - int unsigned - Relationship Type - true - id of the relationship - 1.1 + relationship_type_id + int unsigned + Relationship Type + true + id of the relationship + 1.1 - relationship_type_id - civicrm_relationship_type
- id - 1.1 - CASCADE + relationship_type_id + civicrm_relationship_type
+ id + 1.1 + CASCADE - start_date - date - Relationship Start Date - date when the relationship started - 1.1 + start_date + date + Relationship Start Date + date when the relationship started + 1.1 - end_date - date - Relationship End Date - date when the relationship ended - 1.1 + end_date + date + Relationship End Date + date when the relationship ended + 1.1 - is_active - boolean - Relationship Is Active - 1 - is the relationship active ? - 1.1 + is_active + boolean + Relationship Is Active + 1 + is the relationship active ? + 1.1 - description - varchar - Relationship Description - 255 - Optional verbose description for the relationship. - 1.5 + description + varchar + Relationship Description + 255 + Optional verbose description for the relationship. + 1.5 - is_permission_a_b - boolean - Contact A has Permission Over Contact B - 0 - is contact a has permission to view / edit contact and - related data for contact b ? - 2.1 + is_permission_a_b + boolean + Contact A has Permission Over Contact B + 0 + is contact a has permission to view / edit contact and + related data for contact b ? + + 2.1 - is_permission_b_a - boolean - Contact B has Permission Over Contact A - 0 - is contact b has permission to view / edit contact and - related data for contact a ? - 2.1 + is_permission_b_a + boolean + Contact B has Permission Over Contact A + 0 + is contact b has permission to view / edit contact and + related data for contact a ? + + 2.1 - case_id - int unsigned - Relationship Case - NULL - FK to civicrm_case - 2.2 + case_id + int unsigned + Relationship Case + NULL + FK to civicrm_case + 2.2 - case_id - civicrm_case
- id - 2.2 - CASCADE + case_id + civicrm_case
+ id + 2.2 + CASCADE diff --git a/xml/schema/Contact/RelationshipType.xml b/xml/schema/Contact/RelationshipType.xml index 1416a1da88..b2cf321ba2 100644 --- a/xml/schema/Contact/RelationshipType.xml +++ b/xml/schema/Contact/RelationshipType.xml @@ -4,125 +4,130 @@ CRM/Contact RelationshipType civicrm_relationship_type - Relationship types s/b structured with contact_a as the 'subject/child' contact and contact_b as the 'object/parent' contact (e.g. Individual A is Employee of Org B). + Relationship types s/b structured with contact_a as the 'subject/child' contact and contact_b as the + 'object/parent' contact (e.g. Individual A is Employee of Org B). + 1.1 true - id - int unsigned - Relationship Type ID - true - Primary key - 1.1 + id + int unsigned + Relationship Type ID + true + Primary key + 1.1 - id - true + id + true - name_a_b - varchar - Relationship Type Name A to B - 64 - name for relationship of contact_a to contact_b. - 1.1 + name_a_b + varchar + Relationship Type Name A to B + 64 + name for relationship of contact_a to contact_b. + 1.1 - label_a_b - varchar - Relationship Type Label A to B - 64 - label for relationship of contact_a to contact_b. - 3.0 + label_a_b + varchar + Relationship Type Label A to B + 64 + label for relationship of contact_a to contact_b. + 3.0 - name_b_a - varchar - Relationship Type Name B to A - 64 - Optional name for relationship of contact_b to contact_a. - 1.1 + name_b_a + varchar + Relationship Type Name B to A + 64 + Optional name for relationship of contact_b to contact_a. + 1.1 - label_b_a - varchar - Relationship Type Label B to A - 64 - Optional label for relationship of contact_b to contact_a. - 3.0 + label_b_a + varchar + Relationship Type Label B to A + 64 + Optional label for relationship of contact_b to contact_a. + 3.0 - description - varchar - Relationship Description - 255 - Optional verbose description of the relationship type. - 1.1 + description + varchar + Relationship Description + 255 + Optional verbose description of the relationship type. + 1.1 - contact_type_a - Contact Type for Contact A - varchar - 12 - If defined, contact_a in a relationship of this type must be a specific contact_type. - - CRM_Contact_BAO_ContactType::getSelectElements - - 1.1 - - Select - + contact_type_a + Contact Type for Contact A + varchar + 12 + If defined, contact_a in a relationship of this type must be a specific contact_type. + + CRM_Contact_BAO_ContactType::getSelectElements + + 1.1 + + Select + - contact_type_b - Contact Type for Contact B - varchar - 12 - If defined, contact_b in a relationship of this type must be a specific contact_type. - - CRM_Contact_BAO_ContactType::getSelectElements - - 1.1 - - Select - + contact_type_b + Contact Type for Contact B + varchar + 12 + If defined, contact_b in a relationship of this type must be a specific contact_type. + + CRM_Contact_BAO_ContactType::getSelectElements + + 1.1 + + Select + - contact_sub_type_a - Contact Subtype A - varchar - 64 - If defined, contact_sub_type_a in a relationship of this type must be a specific contact_sub_type. - 3.1 - - Select - + contact_sub_type_a + Contact Subtype A + varchar + 64 + If defined, contact_sub_type_a in a relationship of this type must be a specific contact_sub_type. + + 3.1 + + Select + - contact_sub_type_b - Contact Subtype B - varchar - 64 - If defined, contact_sub_type_b in a relationship of this type must be a specific contact_sub_type. - 3.1 - - Select - + contact_sub_type_b + Contact Subtype B + varchar + 64 + If defined, contact_sub_type_b in a relationship of this type must be a specific contact_sub_type. + + 3.1 + + Select + - is_reserved - boolean - Relationship Type is Reserved - Is this relationship type a predefined system type (can not be changed or de-activated)? - 1.1 + is_reserved + boolean + Relationship Type is Reserved + Is this relationship type a predefined system type (can not be changed or de-activated)? + 1.1 - is_active - Relationship Type is Active - boolean - 1 - Is this relationship type currently active (i.e. can be used when creating or editing relationships)? - 1.1 + is_active + Relationship Type is Active + boolean + 1 + Is this relationship type currently active (i.e. can be used when creating or editing relationships)? + + 1.1 UI_name_a_b diff --git a/xml/schema/Contact/SavedSearch.xml b/xml/schema/Contact/SavedSearch.xml index 680ccbac87..5ac148e228 100644 --- a/xml/schema/Contact/SavedSearch.xml +++ b/xml/schema/Contact/SavedSearch.xml @@ -7,74 +7,74 @@ Users can save their complex SQL queries and use them later. 1.1 - id - int unsigned - true - Saved search ID - 1.1 + id + int unsigned + true + Saved search ID + 1.1 - id - false + id + false - query - SQL Query - text - true - SQL query for this search - 1.1 - 1.5 + query + SQL Query + text + true + SQL query for this search + 1.1 + 1.5 - form_values - Submitted Form Values - text - true - Submitted form values for this search - 1.1 + form_values + Submitted Form Values + text + true + Submitted form values for this search + 1.1 - - is_active - boolean - Is this entry active? - 1.1 - 1.5 + + is_active + boolean + Is this entry active? + 1.1 + 1.5 - mapping_id - int unsigned - Foreign key to civicrm_mapping used for saved search-builder searches. - 1.5 + mapping_id + int unsigned + Foreign key to civicrm_mapping used for saved search-builder searches. + 1.5 - mapping_id - civicrm_mapping
- id - 1.5 + mapping_id + civicrm_mapping
+ id + 1.5 - search_custom_id - int unsigned - Foreign key to civicrm_option value table used for saved custom searches. - 2.0 + search_custom_id + int unsigned + Foreign key to civicrm_option value table used for saved custom searches. + 2.0 - where_clause - text - the sql where clause if a saved search acl - 1.6 + where_clause + text + the sql where clause if a saved search acl + 1.6 - select_tables - text - the tables to be included in a select data - 1.6 + select_tables + text + the tables to be included in a select data + 1.6 - where_tables - text - the tables to be included in the count statement - 1.6 + where_tables + text + the tables to be included in the count statement + 1.6 diff --git a/xml/schema/Contact/SubscriptionHistory.xml b/xml/schema/Contact/SubscriptionHistory.xml index af7dacdce0..83f55d9db8 100644 --- a/xml/schema/Contact/SubscriptionHistory.xml +++ b/xml/schema/Contact/SubscriptionHistory.xml @@ -1,93 +1,93 @@ - CRM/Contact - SubscriptionHistory - civicrm_subscription_history - History information of subscribe/unsubscribe actions + CRM/Contact + SubscriptionHistory + civicrm_subscription_history + History information of subscribe/unsubscribe actions + 1.1 + true + + id + int unsigned + true + Internal Id 1.1 - true - - id - int unsigned - true - Internal Id - 1.1 - - - id - true - - - contact_id - int unsigned - true - Contact Id - 1.1 - - - contact_id -
civicrm_contact
- id - 1.1 - CASCADE - - - group_id - int unsigned - Group Id - 1.1 - - civicrm_group
- id - title - - - Select - - - - group_id - civicrm_group
- id - 1.1 - CASCADE - - - date - datetime - true - Date of the (un)subscription - 1.1 - - - method - varchar - 8 - How the (un)subscription was triggered - - CRM_Core_SelectValues::getSubscriptionHistoryMethods - - 1.1 - - Select - - - - status - varchar - 8 - The state of the contact within the group - - CRM_Core_SelectValues::groupContactStatus - - 1.1 - - - tracking - varchar - 255 - IP address or other tracking info - 1.1 - + + + id + true + + + contact_id + int unsigned + true + Contact Id + 1.1 + + + contact_id + civicrm_contact
+ id + 1.1 + CASCADE + + + group_id + int unsigned + Group Id + 1.1 + + civicrm_group
+ id + title + + + Select + + + + group_id + civicrm_group
+ id + 1.1 + CASCADE + + + date + datetime + true + Date of the (un)subscription + 1.1 + + + method + varchar + 8 + How the (un)subscription was triggered + + CRM_Core_SelectValues::getSubscriptionHistoryMethods + + 1.1 + + Select + + + + status + varchar + 8 + The state of the contact within the group + + CRM_Core_SelectValues::groupContactStatus + + 1.1 + + + tracking + varchar + 255 + IP address or other tracking info + 1.1 + diff --git a/xml/schema/Contribute/ContributionSoft.xml b/xml/schema/Contribute/ContributionSoft.xml index 4659004995..6aecf02048 100644 --- a/xml/schema/Contribute/ContributionSoft.xml +++ b/xml/schema/Contribute/ContributionSoft.xml @@ -7,127 +7,127 @@ 2.2 true - id - contribution_soft_id - int unsigned - true - true - Soft Contribution ID - Soft Contribution ID - 2.2 + id + contribution_soft_id + int unsigned + true + true + Soft Contribution ID + Soft Contribution ID + 2.2 - id - true + id + true - contribution_id - int unsigned - true - FK to contribution table. - 2.2 + contribution_id + int unsigned + true + FK to contribution table. + 2.2 - contribution_id - civicrm_contribution
- id - 2.2 - CASCADE + contribution_id + civicrm_contribution
+ id + 2.2 + CASCADE - contact_id - contribution_soft_contact_id - Contact ID - int unsigned - true - true - /contact(.?id)?/i - /^\d+$/ - FK to Contact ID - 2.2 + contact_id + contribution_soft_contact_id + Contact ID + int unsigned + true + true + /contact(.?id)?/i + /^\d+$/ + FK to Contact ID + 2.2 - contact_id - civicrm_contact
- id - 2.2 - CASCADE + contact_id + civicrm_contact
+ id + 2.2 + CASCADE - amount - decimal - true - true - /total(.?am(ou)?nt)?/i - /^\d+(\.\d{2})?$/ - Amount of this soft contribution. - 2.2 + amount + decimal + true + true + /total(.?am(ou)?nt)?/i + /^\d+(\.\d{2})?$/ + Amount of this soft contribution. + 2.2 - currency - varchar - 3 - NULL - 3 character string, value from config setting or input via user. - 3.2 - - civicrm_currency
- name - full_name - numeric_code - - - Select - + currency + varchar + 3 + NULL + 3 character string, value from config setting or input via user. + 3.2 + + civicrm_currency
+ name + full_name + numeric_code + + + Select + - pcp_id - int unsigned - NULL - FK to civicrm_pcp.id - 2.2 + pcp_id + int unsigned + NULL + FK to civicrm_pcp.id + 2.2 - pcp_id - civicrm_pcp
- id - 3.1 - SET NULL + pcp_id + civicrm_pcp
+ id + 3.1 + SET NULL - index_id - pcp_id - 2.2 - - - pcp_display_in_roll - boolean - 0 - 2.2 + index_id + pcp_id + 2.2 + + + pcp_display_in_roll + boolean + 0 + 2.2 - pcp_roll_nickname - varchar - 255 - NULL - 2.2 + pcp_roll_nickname + varchar + 255 + NULL + 2.2 - pcp_personal_note - varchar - 255 - NULL - 2.2 + pcp_personal_note + varchar + 255 + NULL + 2.2 - soft_credit_type_id - int unsigned - NULL - Soft Credit Type - - soft_credit_type - - Soft Credit Type ID.Implicit FK to civicrm_option_value where option_group = soft_credit_type. - 2.2 + soft_credit_type_id + int unsigned + NULL + Soft Credit Type + + soft_credit_type + + Soft Credit Type ID.Implicit FK to civicrm_option_value where option_group = soft_credit_type. + 2.2 diff --git a/xml/schema/Contribute/Widget.xml b/xml/schema/Contribute/Widget.xml index bee97aa250..14fc88e247 100644 --- a/xml/schema/Contribute/Widget.xml +++ b/xml/schema/Contribute/Widget.xml @@ -8,120 +8,120 @@ 2.0 true - id - int unsigned - true - Contribution Id - 2.0 + id + int unsigned + true + Contribution Id + 2.0 - id - true + id + true - contribution_page_id - int unsigned - The Contribution Page which triggered this contribution - 1.5 + contribution_page_id + int unsigned + The Contribution Page which triggered this contribution + 1.5 - contribution_page_id - civicrm_contribution_page
- id - CASCADE + contribution_page_id + civicrm_contribution_page
+ id + CASCADE - is_active - boolean - Is this property active? - 2.0 + is_active + boolean + Is this property active? + 2.0 - title - varchar - 255 - Widget title. - 2.0 + title + varchar + 255 + Widget title. + 2.0 - url_logo - varchar - 255 - URL to Widget logo - 2.0 + url_logo + varchar + 255 + URL to Widget logo + 2.0 - button_title - varchar - 255 - Button title. - 2.0 + button_title + varchar + 255 + Button title. + 2.0 - about - text - About description. - 2.0 + about + text + About description. + 2.0 - url_homepage - varchar - 255 - URL to Homepage. - 2.0 + url_homepage + varchar + 255 + URL to Homepage. + 2.0 - color_title - varchar - 10 - 2.0 + color_title + varchar + 10 + 2.0 - color_button - varchar - 10 - 2.0 + color_button + varchar + 10 + 2.0 - color_bar - varchar - 10 - 2.0 + color_bar + varchar + 10 + 2.0 - color_main_text - varchar - 10 - 2.0 + color_main_text + varchar + 10 + 2.0 - color_main - varchar - 10 - 2.0 + color_main + varchar + 10 + 2.0 - color_main_bg - varchar - 10 - 2.0 + color_main_bg + varchar + 10 + 2.0 - color_bg - varchar - 10 - 2.0 + color_bg + varchar + 10 + 2.0 - color_about_link - varchar - 10 - 2.0 + color_about_link + varchar + 10 + 2.0 - color_homepage_link - varchar - 10 - 2.0 + color_homepage_link + varchar + 10 + 2.0 diff --git a/xml/schema/Core/ActionLog.xml b/xml/schema/Core/ActionLog.xml index 09f05039b2..17c7aa0da1 100644 --- a/xml/schema/Core/ActionLog.xml +++ b/xml/schema/Core/ActionLog.xml @@ -7,84 +7,84 @@ Table to store log for the reminder. 3.4 - id - int unsigned - true - 3.4 + id + int unsigned + true + 3.4 - id - true + id + true - contact_id - int unsigned - FK to Contact ID - 3.4 + contact_id + int unsigned + FK to Contact ID + 3.4 - contact_id - civicrm_contact
- id - 3.4 - CASCADE + contact_id + civicrm_contact
+ id + 3.4 + CASCADE - entity_id - int unsigned - true - FK to id of the entity that the action was performed on. Pseudo - FK. - 3.4 + entity_id + int unsigned + true + FK to id of the entity that the action was performed on. Pseudo - FK. + 3.4 - entity_table - varchar - 255 - name of the entity table for the above id, e.g. civicrm_activity, civicrm_participant - 3.4 + entity_table + varchar + 255 + name of the entity table for the above id, e.g. civicrm_activity, civicrm_participant + 3.4 - entity_id - entity_table - 3.4 + entity_id + entity_table + 3.4 - action_schedule_id - int unsigned - true - FK to the action schedule that this action originated from. - 3.4 + action_schedule_id + int unsigned + true + FK to the action schedule that this action originated from. + 3.4 - action_schedule_id - civicrm_action_schedule
- id - 3.4 - CASCADE + action_schedule_id + civicrm_action_schedule
+ id + 3.4 + CASCADE - action_date_time - datetime - date time that the action was performed on. - 3.4 + action_date_time + datetime + date time that the action was performed on. + 3.4 - is_error - boolean - 0 - Was there any error sending the reminder? - 3.4 + is_error + boolean + 0 + Was there any error sending the reminder? + 3.4 - message - text - Description / text in case there was an error encountered. - 3.4 + message + text + Description / text in case there was an error encountered. + 3.4 - repetition_number - int unsigned - Keeps track of the sequence number of this repetition. - 3.4 + repetition_number + int unsigned + Keeps track of the sequence number of this repetition. + 3.4 diff --git a/xml/schema/Core/ActionMapping.xml b/xml/schema/Core/ActionMapping.xml index f4efcfdb77..e889c3bc3d 100644 --- a/xml/schema/Core/ActionMapping.xml +++ b/xml/schema/Core/ActionMapping.xml @@ -7,69 +7,69 @@ Table to store mapping for the reminder. 3.4 - id - int unsigned - true - 3.4 + id + int unsigned + true + 3.4 - id - true + id + true - entity - varchar - 64 - Entity for which the reminder is created - 3.4 + entity + varchar + 64 + Entity for which the reminder is created + 3.4 - entity_value - varchar - 64 - Entity value - 3.4 + entity_value + varchar + 64 + Entity value + 3.4 - entity_value_label - varchar - 64 - Entity value label - 3.4 + entity_value_label + varchar + 64 + Entity value label + 3.4 - entity_status - varchar - 64 - Entity status - 3.4 + entity_status + varchar + 64 + Entity status + 3.4 - entity_status_label - varchar - 64 - Entity status label - 3.4 + entity_status_label + varchar + 64 + Entity status label + 3.4 - entity_date_start - varchar - 64 - Entity date - 3.4 + entity_date_start + varchar + 64 + Entity date + 3.4 - entity_date_end - varchar - 64 - Entity date - 3.4 + entity_date_end + varchar + 64 + Entity date + 3.4 - entity_recipient - varchar - 64 - Entity recipient - 3.4 + entity_recipient + varchar + 64 + Entity recipient + 3.4 diff --git a/xml/schema/Core/ActionSchedule.xml b/xml/schema/Core/ActionSchedule.xml index bdb9bc9b9c..6d941768a2 100644 --- a/xml/schema/Core/ActionSchedule.xml +++ b/xml/schema/Core/ActionSchedule.xml @@ -7,211 +7,211 @@ Table to store the reminders. 3.4 - id - int unsigned - true - 3.4 + id + int unsigned + true + 3.4 - id - true + id + true - name - Name - varchar - 64 - Name of the action(reminder) - 3.4 + name + Name + varchar + 64 + Name of the action(reminder) + 3.4 - title - Title - varchar - 64 - Title of the action(reminder) - 3.4 - + title + Title + varchar + 64 + Title of the action(reminder) + 3.4 + - recipient - varchar - 64 - Recipient - 3.4 + recipient + varchar + 64 + Recipient + 3.4 - limit_to - boolean - 1 - Is this the recipient criteria limited to OR in addition to? - 4.4 + limit_to + boolean + 1 + Is this the recipient criteria limited to OR in addition to? + 4.4 - entity_value - varchar - 64 - Entity value - 3.4 + entity_value + varchar + 64 + Entity value + 3.4 - entity_status - varchar - 64 - Entity status - 3.4 + entity_status + varchar + 64 + Entity status + 3.4 + + + start_action_offset + int unsigned + Reminder Interval. + 3.4 - start_action_offset - int unsigned - Reminder Interval. - 3.4 - + start_action_unit + varchar + 8 + Time units for reminder. + + CRM_Core_SelectValues::getScheduleReminderFrequencyUnits + + 3.4 + + Select + + - start_action_unit - varchar - 8 - Time units for reminder. - - CRM_Core_SelectValues::getScheduleReminderFrequencyUnits - - 3.4 - - Select - + start_action_condition + varchar + 32 + Reminder Action + 3.4 - - start_action_condition - varchar - 32 - Reminder Action - 3.4 + + start_action_date + varchar + 64 + Entity date + 3.4 - start_action_date - varchar - 64 - Entity date - 3.4 + is_repeat + Repeat? + boolean + 0 + 3.4 - is_repeat - Repeat? - boolean - 0 - 3.4 - + repetition_frequency_unit + varchar + 8 + Time units for repetition of reminder. + + CRM_Core_SelectValues::getScheduleReminderFrequencyUnits + + 3.4 + + Select + + - repetition_frequency_unit - varchar - 8 - Time units for repetition of reminder. - - CRM_Core_SelectValues::getScheduleReminderFrequencyUnits - - 3.4 - - Select - + repetition_frequency_interval + int unsigned + Time interval for repeating the reminder. + 3.4 - repetition_frequency_interval - int unsigned - Time interval for repeating the reminder. - 3.4 + end_frequency_unit + varchar + 8 + Time units till repetition of reminder. + + CRM_Core_SelectValues::getScheduleReminderFrequencyUnits + + 3.4 + + Select + - end_frequency_unit - varchar - 8 - Time units till repetition of reminder. - - CRM_Core_SelectValues::getScheduleReminderFrequencyUnits - - 3.4 - - Select - + end_frequency_interval + int unsigned + Time interval till repeating the reminder. + 3.4 - end_frequency_interval - int unsigned - Time interval till repeating the reminder. - 3.4 + end_action + varchar + 32 + Reminder Action till repeating the reminder. + 3.4 - end_action - varchar - 32 - Reminder Action till repeating the reminder. - 3.4 + end_date + varchar + 64 + Entity end date + 3.4 - end_date - varchar - 64 - Entity end date - 3.4 + is_active + boolean + 1 + Is this option active? + 3.4 - is_active - boolean - 1 - Is this option active? - 3.4 + recipient_manual + Recipient Manual + varchar + 128 + Contact IDs to which reminder should be sent. + 3.4 - - recipient_manual - Recipient Manual - varchar - 128 - Contact IDs to which reminder should be sent. - 3.4 - - - recipient_listing - Recipient Listing - varchar - 128 - listing based on recipient field. - 4.1 + + recipient_listing + Recipient Listing + varchar + 128 + listing based on recipient field. + 4.1 - body_text - longtext - Body of the mailing in text format. - 3.4 + body_text + longtext + Body of the mailing in text format. + 3.4 - body_html - longtext - Body of the mailing in html format. - 3.4 + body_html + longtext + Body of the mailing in html format. + 3.4 - - subject - varchar - 128 - Subject of mailing - 3.4 + + subject + varchar + 128 + Subject of mailing + 3.4 - - record_activity - boolean - NULL - Record Activity for this reminder? - 3.4 + + record_activity + boolean + NULL + Record Activity for this reminder? + 3.4 - - mapping_id - int unsigned - FK to mapping which is being used by this reminder - 3.4 + + mapping_id + int unsigned + FK to mapping which is being used by this reminder + 3.4 - mapping_id - civicrm_action_mapping
- id - SET NULL + mapping_id + civicrm_action_mapping
+ id + SET NULL group_id @@ -227,28 +227,28 @@ 3.4 - - group_id - civicrm_group
- id - SET NULL - - - msg_template_id + + group_id + civicrm_group
+ id + SET NULL + + + msg_template_id int unsigned FK to the message template. - - - msg_template_id + + + msg_template_id civicrm_msg_template
id SET NULL - - - absolute_date - date - Date on which the reminder be sent. - 4.1 + + + absolute_date + date + Date on which the reminder be sent. + 4.1 from_name diff --git a/xml/schema/Core/Address.xml b/xml/schema/Core/Address.xml index 9bee1de755..0635829372 100644 --- a/xml/schema/Core/Address.xml +++ b/xml/schema/Core/Address.xml @@ -4,49 +4,51 @@ CRM/Core Address civicrm_address - Stores the physical street / mailing address. This format should be capable of storing ALL international addresses. + Stores the physical street / mailing address. This format should be capable of storing ALL international + addresses. + 1.1 true - id - int unsigned - Address ID - true - Unique Address ID - 1.1 + id + int unsigned + Address ID + true + Unique Address ID + 1.1 - id - true + id + true - contact_id - Contact ID - int unsigned - FK to Contact ID - 2.0 + contact_id + Contact ID + int unsigned + FK to Contact ID + 2.0 - contact_id - civicrm_contact
- id - 2.0 - CASCADE + contact_id + civicrm_contact
+ id + 2.0 + CASCADE - location_type_id - Address Location Type - int unsigned - Which Location does this address belong to. - 2.0 - - civicrm_location_type
- id - display_name - - - Select - + location_type_id + Address Location Type + int unsigned + Which Location does this address belong to. + 2.0 + + civicrm_location_type
+ id + display_name + + + Select + index_location_type @@ -54,12 +56,12 @@ 2.0 - is_primary - Is Address Primary? - boolean - 0 - Is this the primary address. - 2.0 + is_primary + Is Address Primary? + boolean + 0 + Is this the primary address. + 2.0 index_is_primary @@ -67,12 +69,12 @@ 2.0 - is_billing - Is Billing Address - boolean - 0 - Is this the billing address. - 2.0 + is_billing + Is Billing Address + boolean + 0 + Is this the billing address. + 2.0 index_is_billing @@ -80,290 +82,298 @@ 2.0 - street_address - Street Address - varchar - 96 - true - /(street|address)/i - /^(\d{1,5}( [0-9A-Za-z]+)+)$|^(P\.?O\.\? Box \d{1,5})$/i - Concatenation of all routable street address components (prefix, street number, street name, suffix, unit number OR P.O. Box). Apps should be able to determine physical location with this data (for mapping, mail delivery, etc.). - 1.1 + street_address + Street Address + varchar + 96 + true + /(street|address)/i + /^(\d{1,5}( [0-9A-Za-z]+)+)$|^(P\.?O\.\? Box \d{1,5})$/i + Concatenation of all routable street address components (prefix, street number, street name, suffix, unit + number OR P.O. Box). Apps should be able to determine physical location with this data (for mapping, mail + delivery, etc.). + + 1.1 - street_number - Street Number - int - true - Numeric portion of address number on the street, e.g. For 112A Main St, the street_number = 112. - 1.1 + street_number + Street Number + int + true + Numeric portion of address number on the street, e.g. For 112A Main St, the street_number = 112. + 1.1 - street_number_suffix - Street Number Suffix - varchar - 8 - true - Non-numeric portion of address number on the street, e.g. For 112A Main St, the street_number_suffix = A - 1.1 + street_number_suffix + Street Number Suffix + varchar + 8 + true + Non-numeric portion of address number on the street, e.g. For 112A Main St, the street_number_suffix = A + + 1.1 - street_number_predirectional - Street Direction Prefix - varchar - 8 - Directional prefix, e.g. SE Main St, SE is the prefix. - 1.1 + street_number_predirectional + Street Direction Prefix + varchar + 8 + Directional prefix, e.g. SE Main St, SE is the prefix. + 1.1 - street_name - varchar - Street Name - 64 - true - Actual street name, excluding St, Dr, Rd, Ave, e.g. For 112 Main St, the street_name = Main. - 1.1 + street_name + varchar + Street Name + 64 + true + Actual street name, excluding St, Dr, Rd, Ave, e.g. For 112 Main St, the street_name = Main. + 1.1 - index_street_name - street_name - 1.1 + index_street_name + street_name + 1.1 - street_type - Street Type - varchar - 8 - St, Rd, Dr, etc. - 1.1 + street_type + Street Type + varchar + 8 + St, Rd, Dr, etc. + 1.1 - street_number_postdirectional - Street Direction Suffix - varchar - 8 - Directional prefix, e.g. Main St S, S is the suffix. - 1.1 + street_number_postdirectional + Street Direction Suffix + varchar + 8 + Directional prefix, e.g. Main St S, S is the suffix. + 1.1 - street_unit - Street Unit - varchar - 16 - true - Secondary unit designator, e.g. Apt 3 or Unit # 14, or Bldg 1200 - 1.1 + street_unit + Street Unit + varchar + 16 + true + Secondary unit designator, e.g. Apt 3 or Unit # 14, or Bldg 1200 + 1.1 - supplemental_address_1 - Supplemental Address 1 - varchar - 96 - true - /(supplemental(\s)?)?address(\s\d+)?/i - /unit|ap(ar)?t(ment)?\s(\d|\w)+/i - Supplemental Address Information, Line 1 - 1.1 + supplemental_address_1 + Supplemental Address 1 + varchar + 96 + true + /(supplemental(\s)?)?address(\s\d+)?/i + /unit|ap(ar)?t(ment)?\s(\d|\w)+/i + Supplemental Address Information, Line 1 + 1.1 - supplemental_address_2 - Supplemental Address 2 - varchar - 96 - true - /(supplemental(\s)?)?address(\s\d+)?/i - /unit|ap(ar)?t(ment)?\s(\d|\w)+/i - Supplemental Address Information, Line 2 - 1.1 + supplemental_address_2 + Supplemental Address 2 + varchar + 96 + true + /(supplemental(\s)?)?address(\s\d+)?/i + /unit|ap(ar)?t(ment)?\s(\d|\w)+/i + Supplemental Address Information, Line 2 + 1.1 - supplemental_address_3 - Supplemental Address 3 - varchar - 96 - Supplemental Address Information, Line 3 - 1.1 + supplemental_address_3 + Supplemental Address 3 + varchar + 96 + Supplemental Address Information, Line 3 + 1.1 - city - City - varchar - 64 - true - /city/i - /^[A-Za-z]+(\.?)(\s?[A-Za-z]+){0,2}$/ - City, Town or Village Name. - 1.1 + city + City + varchar + 64 + true + /city/i + /^[A-Za-z]+(\.?)(\s?[A-Za-z]+){0,2}$/ + City, Town or Village Name. + 1.1 - index_city - city - 1.1 + index_city + city + 1.1 - county_id - int unsigned - County - Which County does this address belong to. - - civicrm_county
- id - name - - - Select - - 1.1 + county_id + int unsigned + County + Which County does this address belong to. + + civicrm_county
+ id + name + + + Select + + 1.1 - county_id - civicrm_county
- id - true - /county/i - /[A-Z]{2}/ - 1.1 - SET NULL + county_id + civicrm_county
+ id + true + /county/i + /[A-Z]{2}/ + 1.1 + SET NULL - state_province_id - State - int unsigned - Which State_Province does this address belong to. - - civicrm_state_province
- id - name - - - Select - - 1.1 + state_province_id + State + int unsigned + Which State_Province does this address belong to. + + civicrm_state_province
+ id + name + + + Select + + 1.1 - state_province_id - civicrm_state_province
- id - true - /state|prov(ince)?/i - /A[LKSZRAP]|C[AOT]|D[EC]|F[LM]|G[AU]|HI|I[ADLN]|K[SY]|LA|M[ADEHINOPST]|N[CDEHJMVY]|O[HKR]|P[ARW]|RI|S[CD]|T[NX]|UT|V[AIT]|W[AIVY]/i - 1.1 - SET NULL + state_province_id + civicrm_state_province
+ id + true + /state|prov(ince)?/i + + /A[LKSZRAP]|C[AOT]|D[EC]|F[LM]|G[AU]|HI|I[ADLN]|K[SY]|LA|M[ADEHINOPST]|N[CDEHJMVY]|O[HKR]|P[ARW]|RI|S[CD]|T[NX]|UT|V[AIT]|W[AIVY]/i + + 1.1 + SET NULL - - postal_code_suffix - Postal Code Suffix - varchar - 12 - true - /p(ostal)\sc(ode)\ss(uffix)/i - /\d?\d{4}(-\d{4})?/ - Store the suffix, like the +4 part in the USPS system. - 1.1 + + postal_code_suffix + Postal Code Suffix + varchar + 12 + true + /p(ostal)\sc(ode)\ss(uffix)/i + /\d?\d{4}(-\d{4})?/ + Store the suffix, like the +4 part in the USPS system. + 1.1 - - postal_code - Postal Code - varchar - 12 - true - /postal|zip/i - /\d?\d{4}(-\d{4})?/ - Store both US (zip5) AND international postal codes. App is responsible for country/region appropriate validation. - 1.1 + + postal_code + Postal Code + varchar + 12 + true + /postal|zip/i + /\d?\d{4}(-\d{4})?/ + Store both US (zip5) AND international postal codes. App is responsible for country/region appropriate + validation. + + 1.1 - usps_adc - USPS Code - varchar - 32 - USPS Bulk mailing code. - 1.1 + usps_adc + USPS Code + varchar + 32 + USPS Bulk mailing code. + 1.1 - country_id - Country - int unsigned - Which Country does this address belong to. - - civicrm_country
- id - name - iso_code - - - Select - - 1.1 + country_id + Country + int unsigned + Which Country does this address belong to. + + civicrm_country
+ id + name + iso_code + + + Select + + 1.1 - country_id - civicrm_country
- id - true - /country/i - /\w+(\s\w+)?/ - 1.1 - SET NULL + country_id + civicrm_country
+ id + true + /country/i + /\w+(\s\w+)?/ + 1.1 + SET NULL - geo_code_1 - Latitude - float - true - /geo/i - Latitude - 1.1 + geo_code_1 + Latitude + float + true + /geo/i + Latitude + 1.1 - geo_code_2 - Longitude - float - Longitude - true - /geo/i - 1.1 + geo_code_2 + Longitude + float + Longitude + true + /geo/i + 1.1 - manual_geo_code - Is manually geocoded - boolean - 0 - Is this a manually entered geo code - 4.3 + manual_geo_code + Is manually geocoded + boolean + 0 + Is this a manually entered geo code + 4.3 - timezone - Timezone - varchar - 8 - Timezone expressed as a UTC offset - e.g. United States CST would be written as "UTC-6". - 1.1 + timezone + Timezone + varchar + 8 + Timezone expressed as a UTC offset - e.g. United States CST would be written as "UTC-6". + 1.1 - name - address_name - Address Name - varchar - 255 - true - /^location|(l(ocation\s)?name)$/i - /^\w+$/ - 2.1 + name + address_name + Address Name + varchar + 255 + true + /^location|(l(ocation\s)?name)$/i + /^\w+$/ + 2.1 - master_id - Master Address Belongs To - int unsigned - true - FK to Address ID - 3.3 + master_id + Master Address Belongs To + int unsigned + true + FK to Address ID + 3.3 - master_id - civicrm_address
- id - 3.3 - SET NULL + master_id + civicrm_address
+ id + 3.3 + SET NULL diff --git a/xml/schema/Core/AddressFormat.xml b/xml/schema/Core/AddressFormat.xml index 773665fcbc..6222cb262c 100644 --- a/xml/schema/Core/AddressFormat.xml +++ b/xml/schema/Core/AddressFormat.xml @@ -6,21 +6,21 @@ civicrm_address_format 3.2 - id - int unsigned - true - Address Format Id - 3.2 + id + int unsigned + true + Address Format Id + 3.2 - id - true + id + true - format - Address Format - text - The format of an address - 3.2 + format + Address Format + text + The format of an address + 3.2 diff --git a/xml/schema/Core/Cache.xml b/xml/schema/Core/Cache.xml index 611070f524..de80e3da7d 100644 --- a/xml/schema/Core/Cache.xml +++ b/xml/schema/Core/Cache.xml @@ -7,29 +7,29 @@ Table to cache items for civicrm components. 2.1 - id - int unsigned - true - 2.1 + id + int unsigned + true + 2.1 - id - true + id + true - group_name - varchar - 32 - true - group name for cache element, useful in cleaning cache elements - 2.1 + group_name + varchar + 32 + true + group name for cache element, useful in cleaning cache elements + 2.1 - path - varchar - 255 - Unique path name for cache element - 2.1 + path + varchar + 255 + Unique path name for cache element + 2.1 UI_group_path @@ -68,10 +68,10 @@ - component_id - civicrm_component
- id - 2.1 + component_id + civicrm_component
+ id + 2.1 created_date diff --git a/xml/schema/Core/Component.xml b/xml/schema/Core/Component.xml index c773dbe5af..0a9f7e13f2 100644 --- a/xml/schema/Core/Component.xml +++ b/xml/schema/Core/Component.xml @@ -6,32 +6,33 @@ civicrm_component 2.0 - id - int unsigned - true - Component ID - 2.0 + id + int unsigned + true + Component ID + 2.0 - id - true + id + true - name - Component name - varchar - true - 64 - Name of the component. - 2.0 + name + Component name + varchar + true + 64 + Name of the component. + 2.0 - namespace - Namespace reserved for component. - varchar - 128 - Path to components main directory in a form of a class -namespace. - 2.0 + namespace + Namespace reserved for component. + varchar + 128 + Path to components main directory in a form of a class + namespace. + + 2.0 diff --git a/xml/schema/Core/EntityFile.xml b/xml/schema/Core/EntityFile.xml index bfd8260601..373f230f6e 100644 --- a/xml/schema/Core/EntityFile.xml +++ b/xml/schema/Core/EntityFile.xml @@ -4,62 +4,62 @@ CRM/Core EntityFile civicrm_entity_file - Attaches (joins) uploaded files (images, documents, etc.) to entities (Contacts, Groups, Actions). + Attaches (joins) uploaded files (images, documents, etc.) to entities (Contacts, Groups, Actions). true - id - int unsigned - true - primary key - 1.5 + id + int unsigned + true + primary key + 1.5 - id - true + id + true - entity_table - varchar - 64 - physical tablename for entity being joined to file, e.g. civicrm_contact - 1.5 + entity_table + varchar + 64 + physical tablename for entity being joined to file, e.g. civicrm_contact + 1.5 - entity_id - int unsigned - true - FK to entity table specified in entity_table column. - 1.5 + entity_id + int unsigned + true + FK to entity table specified in entity_table column. + 1.5 - entity_id - entity_table - 1.5 + entity_id + entity_table + 1.5 - index_entity - entity_table - entity_id - 1.5 + index_entity + entity_table + entity_id + 1.5 - file_id - int unsigned - true - FK to civicrm_file - 1.5 + file_id + int unsigned + true + FK to civicrm_file + 1.5 - file_id - civicrm_file
- id - 1.5 + file_id + civicrm_file
+ id + 1.5 - index_entity_file_id - entity_table - entity_id - file_id - 1.1 + index_entity_file_id + entity_table + entity_id + file_id + 1.1 diff --git a/xml/schema/Core/EntityTag.xml b/xml/schema/Core/EntityTag.xml index c40a2ebf04..f0c2b04d21 100644 --- a/xml/schema/Core/EntityTag.xml +++ b/xml/schema/Core/EntityTag.xml @@ -7,83 +7,83 @@ Tag entities (Contacts, Groups, Actions) to categories. true - id - int unsigned - Entity Tag ID - true - primary key - 1.1 + id + int unsigned + Entity Tag ID + true + primary key + 1.1 - id - true + id + true - contact_id - int unsigned - true - FK to contact table. - 2.0 - 3.2 + contact_id + int unsigned + true + FK to contact table. + 2.0 + 3.2 - contact_id - civicrm_contact
- id - 2.0 - 3.2 - CASCADE + contact_id + civicrm_contact
+ id + 2.0 + 3.2 + CASCADE - entity_table - varchar - Entity Table - 64 - physical tablename for entity being joined to file, e.g. civicrm_contact - 3.2 + entity_table + varchar + Entity Table + 64 + physical tablename for entity being joined to file, e.g. civicrm_contact + 3.2 - entity_id - int unsigned - Entity ID - true - FK to entity table specified in entity_table column. - 3.2 + entity_id + int unsigned + Entity ID + true + FK to entity table specified in entity_table column. + 3.2 - entity_id - entity_table - 3.2 + entity_id + entity_table + 3.2 - index_entity - entity_table - entity_id - 3.2 - 3.4 + index_entity + entity_table + entity_id + 3.2 + 3.4 - tag_id - int unsigned - Tag ID - true - FK to civicrm_tag - 1.1 - - civicrm_tag
- id - name - - - Select - + tag_id + int unsigned + Tag ID + true + FK to civicrm_tag + 1.1 + + civicrm_tag
+ id + name + + + Select + - tag_id - civicrm_tag
- id - 1.1 - CASCADE + tag_id + civicrm_tag
+ id + 1.1 + CASCADE UI_entity_id_entity_table_tag_id diff --git a/xml/schema/Core/File.xml b/xml/schema/Core/File.xml index d8beb0ef55..d7b8f7d876 100644 --- a/xml/schema/Core/File.xml +++ b/xml/schema/Core/File.xml @@ -4,57 +4,59 @@ CRM/Core File civicrm_file - Data store for uploaded (attached) files (pointer to file on disk OR blob). Maybe be joined to entities via custom_value.file_id or entity_file table. + Data store for uploaded (attached) files (pointer to file on disk OR blob). Maybe be joined to entities via + custom_value.file_id or entity_file table. + 1.5 true - id - int unsigned - true - Unique ID - 1.5 + id + int unsigned + true + Unique ID + 1.5 - id - true + id + true - file_type_id - int unsigned - Type of file (e.g. Transcript, Income Tax Return, etc). FK to civicrm_option_value. - 1.5 + file_type_id + int unsigned + Type of file (e.g. Transcript, Income Tax Return, etc). FK to civicrm_option_value. + 1.5 - mime_type - varchar - 255 - mime type of the document - 1.5 + mime_type + varchar + 255 + mime type of the document + 1.5 - uri - varchar - 255 - uri of the file on disk - 1.5 + uri + varchar + 255 + uri of the file on disk + 1.5 - document - mediumblob - contents of the document - 1.5 + document + mediumblob + contents of the document + 1.5 - description - varchar - 255 - Additional descriptive text regarding this attachment (optional). - 1.5 + description + varchar + 255 + Additional descriptive text regarding this attachment (optional). + 1.5 - upload_date - datetime - Date and time that this attachment was uploaded or written to server. - 1.5 + upload_date + datetime + Date and time that this attachment was uploaded or written to server. + 1.5 diff --git a/xml/schema/Core/IM.xml b/xml/schema/Core/IM.xml index 036c9556ff..376ff47364 100644 --- a/xml/schema/Core/IM.xml +++ b/xml/schema/Core/IM.xml @@ -8,40 +8,40 @@ 1.1 true - id - int unsigned - true - Unique IM ID - 1.1 + id + int unsigned + true + Unique IM ID + 1.1 - id - true + id + true - contact_id - int unsigned - FK to Contact ID - 2.0 + contact_id + int unsigned + FK to Contact ID + 2.0 - contact_id - civicrm_contact
- id - 2.0 - CASCADE + contact_id + civicrm_contact
+ id + 2.0 + CASCADE - location_type_id - IM Location Type - int unsigned - Which Location does this email belong to. - - civicrm_location_type
- id - display_name - - 2.0 + location_type_id + IM Location Type + int unsigned + Which Location does this email belong to. + + civicrm_location_type
+ id + display_name + + 2.0 index_location_type @@ -49,28 +49,28 @@ 2.0 - name - IM Screen Name - varchar - 64 - true - /I(nstant )?M(ess.*)?|screen(\s+)?name/i - /^[A-Za-z][0-9A-Za-z]{20,}$/ - IM screen name - 1.1 + name + IM Screen Name + varchar + 64 + true + /I(nstant )?M(ess.*)?|screen(\s+)?name/i + /^[A-Za-z][0-9A-Za-z]{20,}$/ + IM screen name + 1.1 - provider_id - IM Provider - int unsigned - Which IM Provider does this screen name belong to. - 1.1 - - instant_messenger_service - - - Select - + provider_id + IM Provider + int unsigned + Which IM Provider does this screen name belong to. + 1.1 + + instant_messenger_service + + + Select + UI_provider_id @@ -78,12 +78,12 @@ 1.6 - is_primary - Is IM Primary? - boolean - 0 - Is this the primary IM for this contact and location. - 1.1 + is_primary + Is IM Primary? + boolean + 0 + Is this the primary IM for this contact and location. + 1.1 index_is_primary @@ -91,11 +91,11 @@ 2.0 - is_billing - boolean - 0 - Is this the billing? - 2.0 + is_billing + boolean + 0 + Is this the billing? + 2.0 index_is_billing diff --git a/xml/schema/Core/Job.xml b/xml/schema/Core/Job.xml index a14a271d8d..5573648e25 100644 --- a/xml/schema/Core/Job.xml +++ b/xml/schema/Core/Job.xml @@ -8,107 +8,107 @@ 4.1 false - id - int unsigned - true - Job Id - 4.1 + id + int unsigned + true + Job Id + 4.1 - id - true + id + true - domain_id - int unsigned - true - - civicrm_domain
- id - name - - Which Domain is this scheduled job for - 4.1 + domain_id + int unsigned + true + + civicrm_domain
+ id + name + + Which Domain is this scheduled job for + 4.1 - domain_id - civicrm_domain
- id - 4.1 + domain_id + civicrm_domain
+ id + 4.1 - run_frequency - varchar - 8 - "Daily" - Scheduled job run frequency. - - CRM_Core_SelectValues::getJobFrequency - - 4.1 - - Select - + run_frequency + varchar + 8 + "Daily" + Scheduled job run frequency. + + CRM_Core_SelectValues::getJobFrequency + + 4.1 + + Select + - last_run - datetime - NULL - When was this cron entry last run - 4.1 + last_run + datetime + NULL + When was this cron entry last run + 4.1 - name - varchar - 255 - Title of the job - 4.1 + name + varchar + 255 + Title of the job + 4.1 - description - varchar - 255 - Description of the job - 4.1 + description + varchar + 255 + Description of the job + 4.1 - api_prefix - varchar - 255 - "civicrm_api3" - Prefix of the job api call - 4.1 - 4.3 + api_prefix + varchar + 255 + "civicrm_api3" + Prefix of the job api call + 4.1 + 4.3 - api_entity - varchar - 255 - Entity of the job api call - 4.1 + api_entity + varchar + 255 + Entity of the job api call + 4.1 - api_action - varchar - 255 - Action of the job api call - 4.1 + api_action + varchar + 255 + Action of the job api call + 4.1 - parameters - text - List of parameters to the command. - - TextArea - 4 - 60 - - 4.1 + parameters + text + List of parameters to the command. + + TextArea + 4 + 60 + + 4.1 - is_active - boolean - Is this job active? - 4.1 + is_active + boolean + Is this job active? + 4.1 diff --git a/xml/schema/Core/JobLog.xml b/xml/schema/Core/JobLog.xml index 4917b91c3f..b4383fa5d2 100644 --- a/xml/schema/Core/JobLog.xml +++ b/xml/schema/Core/JobLog.xml @@ -8,71 +8,71 @@ 4.1 false - id - int unsigned - true - Job log entry Id - 4.1 + id + int unsigned + true + Job log entry Id + 4.1 - id - true + id + true - domain_id - int unsigned - true - - civicrm_domain
- id - name - - Which Domain is this scheduled job for - 4.1 + domain_id + int unsigned + true + + civicrm_domain
+ id + name + + Which Domain is this scheduled job for + 4.1 - domain_id - civicrm_domain
- id - 4.1 + domain_id + civicrm_domain
+ id + 4.1 - run_time - timestamp - Log entry date - 4.1 + run_time + timestamp + Log entry date + 4.1 - job_id - int unsigned - Pointer to job id - not a FK though, just for logging purposes - 4.1 + job_id + int unsigned + Pointer to job id - not a FK though, just for logging purposes + 4.1 - name - varchar - 255 - Title of the job - 4.1 + name + varchar + 255 + Title of the job + 4.1 - command - varchar - 255 - Full path to file containing job script - 4.1 + command + varchar + 255 + Full path to file containing job script + 4.1 - description - varchar - 255 - Title line of log entry - 4.1 + description + varchar + 255 + Title line of log entry + 4.1 - data - text - Potential extended data for specific job run (e.g. tracebacks). - 4.1 + data + text + Potential extended data for specific job run (e.g. tracebacks). + 4.1 diff --git a/xml/schema/Core/LocationType.xml b/xml/schema/Core/LocationType.xml index d22454612b..f6a48e4a7f 100644 --- a/xml/schema/Core/LocationType.xml +++ b/xml/schema/Core/LocationType.xml @@ -7,65 +7,65 @@ 1.1 true - id - int unsigned - true - Location Type ID - 1.1 + id + int unsigned + true + Location Type ID + 1.1 - id - true + id + true - name - Location Type - varchar - 64 - Location Type Name. - 1.1 + name + Location Type + varchar + 64 + Location Type Name. + 1.1 - display_name - Display Name - varchar - 64 - Location Type Display Name. - true - 4.1 + display_name + Display Name + varchar + 64 + Location Type Display Name. + true + 4.1 - vcard_name - vCard Location Type - varchar - 64 - vCard Location Type Name. - 1.1 + vcard_name + vCard Location Type + varchar + 64 + vCard Location Type Name. + 1.1 - description - varchar - 255 - Location Type Description. - 1.1 + description + varchar + 255 + Location Type Description. + 1.1 - is_reserved - boolean - Is this location type a predefined system location? - 1.1 + is_reserved + boolean + Is this location type a predefined system location? + 1.1 - is_active - boolean - Is this property active? - 1.1 + is_active + boolean + Is this property active? + 1.1 - is_default - boolean - Is this location type the default? - 1.1 + is_default + boolean + Is this location type the default? + 1.1 UI_name diff --git a/xml/schema/Core/Log.xml b/xml/schema/Core/Log.xml index fccbe8ac37..ef6efc31f4 100644 --- a/xml/schema/Core/Log.xml +++ b/xml/schema/Core/Log.xml @@ -7,66 +7,66 @@ Log can be linked to any object in the application. 1.5 - id - int unsigned - true - Log ID - 1.5 + id + int unsigned + true + Log ID + 1.5 - id - true + id + true - entity_table - varchar - 64 - true - Name of table where item being referenced is stored. - 1.5 + entity_table + varchar + 64 + true + Name of table where item being referenced is stored. + 1.5 - entity_id - int unsigned - true - Foreign key to the referenced item. - 1.5 + entity_id + int unsigned + true + Foreign key to the referenced item. + 1.5 - entity_id - entity_table - 1.5 + entity_id + entity_table + 1.5 - index_entity - 1.5 - entity_table - entity_id - 1.5 + index_entity + 1.5 + entity_table + entity_id + 1.5 - data - text - Updates does to this object if any. - 1.5 + data + text + Updates does to this object if any. + 1.5 - modified_id - int unsigned - FK to Contact ID of person under whose credentials this data modification was made. - 1.5 + modified_id + int unsigned + FK to Contact ID of person under whose credentials this data modification was made. + 1.5 - modified_id - civicrm_contact
- id - 1.5 - CASCADE + modified_id + civicrm_contact
+ id + 1.5 + CASCADE - modified_date - datetime - When was the referenced entity created or modified or deleted. - 1.5 + modified_date + datetime + When was the referenced entity created or modified or deleted. + 1.5 diff --git a/xml/schema/Core/Mapping.xml b/xml/schema/Core/Mapping.xml index 9d25fca113..692f6b4534 100644 --- a/xml/schema/Core/Mapping.xml +++ b/xml/schema/Core/Mapping.xml @@ -7,54 +7,56 @@ Store field mappings in import or export for reuse 1.2 - id - int unsigned - true - Mapping ID - 1.2 + id + int unsigned + true + Mapping ID + 1.2 - id - true - 1.2 + id + true + 1.2 - name - varchar - 64 - Name of Mapping - 1.2 + name + varchar + 64 + Name of Mapping + 1.2 - description - varchar - 255 - Description of Mapping. - 1.2 + description + varchar + 255 + Description of Mapping. + 1.2 - mapping_type - enum - Export, Import, Export Contributions, Import Contributions, Import Activity, Search Builder, Import Memberships, Import Participants - Type of Mapping. - 1.2 - 2.1 + mapping_type + enum + Export, Import, Export Contributions, Import Contributions, Import Activity, Search Builder, Import + Memberships, Import Participants + + Type of Mapping. + 1.2 + 2.1 - mapping_type_id - int unsigned - Mapping Type - 2.1 - - mapping_type - - - Select - + mapping_type_id + int unsigned + Mapping Type + 2.1 + + mapping_type + + + Select + UI_name name - 1.2 + 1.2 diff --git a/xml/schema/Core/MappingField.xml b/xml/schema/Core/MappingField.xml index 5c136763ee..1f1eb51d5b 100644 --- a/xml/schema/Core/MappingField.xml +++ b/xml/schema/Core/MappingField.xml @@ -7,153 +7,155 @@ Individual field mappings for Mapping 1.2 - id - int unsigned - true - Mapping Field ID - 1.2 + id + int unsigned + true + Mapping Field ID + 1.2 - id - true - 1.2 + id + true + 1.2 - mapping_id - int unsigned - true - Mapping to which this field belongs - 1.2 + mapping_id + int unsigned + true + Mapping to which this field belongs + 1.2 - mapping_id - civicrm_mapping
- id - 1.2 + mapping_id + civicrm_mapping
+ id + 1.2 - name - varchar - 255 - Mapping field key - 1.2 + name + varchar + 255 + Mapping field key + 1.2 - contact_type - varchar - 64 - Contact Type in mapping - - civicrm_contact_type
- name - label - - - Select - - 1.2 + contact_type + varchar + 64 + Contact Type in mapping + + civicrm_contact_type
+ name + label + + + Select + + 1.2 - column_number - int unsigned - true - Column number for mapping set - 1.2 + column_number + int unsigned + true + Column number for mapping set + 1.2 - location_type_id - int unsigned - Location type of this mapping, if required - 1.2 + location_type_id + int unsigned + Location type of this mapping, if required + 1.2 - location_type_id - civicrm_location_type
- id - 1.2 + location_type_id + civicrm_location_type
+ id + 1.2 - phone_type - varchar - 64 - Phone type, if required - 1.2 - 2.2 + phone_type + varchar + 64 + Phone type, if required + 1.2 + 2.2 - phone_type_id - int unsigned - Which type of phone does this number belongs. - 2.2 + phone_type_id + int unsigned + Which type of phone does this number belongs. + 2.2 - - im_provider_id - int unsigned - Which type of IM Provider does this name belong. - 3.0 - - instant_messenger_service - - - Select - + + im_provider_id + int unsigned + Which type of IM Provider does this name belong. + 3.0 + + instant_messenger_service + + + Select + - website_type_id - int unsigned - Which type of website does this site belong - 3.2 - - website_type - - - Select - + website_type_id + int unsigned + Which type of website does this site belong + 3.2 + + website_type + + + Select + - relationship_type_id - int unsigned - Relationship type, if required - 1.2 + relationship_type_id + int unsigned + Relationship type, if required + 1.2 - relationship_type_id - civicrm_relationship_type
- id - 1.2 + relationship_type_id + civicrm_relationship_type
+ id + 1.2 - relationship_direction - varchar - 6 - 1.7 + relationship_direction + varchar + 6 + 1.7 - grouping - int unsigned - 1 - Used to group mapping_field records into related sets (e.g. for criteria sets in search builder mappings). - 1.5 + grouping + int unsigned + 1 + Used to group mapping_field records into related sets (e.g. for criteria sets in search builder + mappings). + + 1.5 - operator - varchar - 16 - enum - SQL WHERE operator for search-builder mapping fields (search criteria). - - CRM_Core_SelectValues::getSearchBuilderOperators - - 1.5 - - Select - + operator + varchar + 16 + enum + SQL WHERE operator for search-builder mapping fields (search criteria). + + CRM_Core_SelectValues::getSearchBuilderOperators + + 1.5 + + Select + - value - varchar - 255 - SQL WHERE value for search-builder mapping fields. - 1.5 + value + varchar + 255 + SQL WHERE value for search-builder mapping fields. + 1.5 diff --git a/xml/schema/Core/Menu.xml b/xml/schema/Core/Menu.xml index 3f983d4ab8..a3adb4adc2 100644 --- a/xml/schema/Core/Menu.xml +++ b/xml/schema/Core/Menu.xml @@ -7,39 +7,39 @@ Table to store menu items for all civicrm components. 1.1 - id - int unsigned - true - 2.1 + id + int unsigned + true + 2.1 - id - true + id + true - domain_id - int unsigned - true - - civicrm_domain
- id - name - - Which Domain is this menu item for - 3.0 + domain_id + int unsigned + true + + civicrm_domain
+ id + name + + Which Domain is this menu item for + 3.0 - domain_id - civicrm_domain
- id - 3.0 + domain_id + civicrm_domain
+ id + 3.0 - path - varchar - 255 - Path Name - 2.1 + path + varchar + 255 + Path Name + 2.1 UI_path_domain_id @@ -55,11 +55,11 @@ 2.1 - title - varchar - 255 - Menu Title - 2.1 + title + varchar + 255 + Menu Title + 2.1 access_callback @@ -122,63 +122,63 @@ - component_id - civicrm_component
- id - 2.1 + component_id + civicrm_component
+ id + 2.1 - is_active - boolean - Is this menu item active? - 2.1 + is_active + boolean + Is this menu item active? + 2.1 - is_public - boolean - Is this menu accessible to the public? - 2.1 + is_public + boolean + Is this menu accessible to the public? + 2.1 - is_exposed - boolean - Is this menu exposed to the navigation system? - 2.1 + is_exposed + boolean + Is this menu exposed to the navigation system? + 2.1 - is_ssl - boolean - Should this menu be exposed via SSL if enabled? - 2.1 + is_ssl + boolean + Should this menu be exposed via SSL if enabled? + 2.1 - weight - int - true - 1 - Ordering of the menu items in various blocks. - 2.1 + weight + int + true + 1 + Ordering of the menu items in various blocks. + 2.1 - type - int - true - 1 - Drupal menu type. - 2.1 + type + int + true + 1 + Drupal menu type. + 2.1 - page_type - int - true - 1 - CiviCRM menu type. - 2.1 + page_type + int + true + 1 + CiviCRM menu type. + 2.1 - skipBreadcrumb - boolean - skip this url being exposed to breadcrumb - 2.2 + skipBreadcrumb + boolean + skip this url being exposed to breadcrumb + 2.2 diff --git a/xml/schema/Core/MessageTemplate.xml b/xml/schema/Core/MessageTemplate.xml index d83bcbc3d7..5f8cc7ca5e 100644 --- a/xml/schema/Core/MessageTemplate.xml +++ b/xml/schema/Core/MessageTemplate.xml @@ -7,87 +7,87 @@ Users will need a way to save and retrieve templates with tokens for use in recurring email communication tasks 1.6 - id - int unsigned - true - Message Template ID - 1.6 + id + int unsigned + true + Message Template ID + 1.6 - id - true + id + true - msg_title - varchar - 255 - Descriptive title of message - 1.6 + msg_title + varchar + 255 + Descriptive title of message + 1.6 - msg_subject - text - Subject for email message. - 1.6 - + msg_subject + text + Subject for email message. + 1.6 + - msg_text - longtext - - TextArea - 10 - 75 - - Text formatted message - 1.6 - + msg_text + longtext + + TextArea + 10 + 75 + + Text formatted message + 1.6 + - msg_html - longtext - - RichTextEditor - 10 - 75 - - HTML formatted message - 1.6 - + msg_html + longtext + + RichTextEditor + 10 + 75 + + HTML formatted message + 1.6 + - is_active - Is Active - boolean - 1 - 1.6 + is_active + Is Active + boolean + 1 + 1.6 - workflow_id - int unsigned - a pseudo-FK to civicrm_option_value - 3.1 + workflow_id + int unsigned + a pseudo-FK to civicrm_option_value + 3.1 - is_default - boolean - 1 - is this the default message template for the workflow referenced by workflow_id? - 3.1 + is_default + boolean + 1 + is this the default message template for the workflow referenced by workflow_id? + 3.1 - is_reserved - boolean - is this the reserved message template which we ship for the workflow referenced by workflow_id? - 3.1 + is_reserved + boolean + is this the reserved message template which we ship for the workflow referenced by workflow_id? + 3.1 - pdf_format_id - int unsigned - a pseudo-FK to civicrm_option_value containing PDF Page Format. - - pdf_format - - 3.4 + pdf_format_id + int unsigned + a pseudo-FK to civicrm_option_value containing PDF Page Format. + + pdf_format + + 3.4 diff --git a/xml/schema/Core/Navigation.xml b/xml/schema/Core/Navigation.xml index 8efe8f555c..74a5573daa 100644 --- a/xml/schema/Core/Navigation.xml +++ b/xml/schema/Core/Navigation.xml @@ -7,46 +7,46 @@ Table to store navigation. 3.0 - id - int unsigned - true - 3.0 + id + int unsigned + true + 3.0 - id - true + id + true - domain_id - int unsigned - true - - civicrm_domain
- id - name - - Which Domain is this navigation item for - 3.0 + domain_id + int unsigned + true + + civicrm_domain
+ id + name + + Which Domain is this navigation item for + 3.0 - domain_id - civicrm_domain
- id - 3.0 + domain_id + civicrm_domain
+ id + 3.0 - label - varchar - 255 - Navigation Title - 3.0 + label + varchar + 255 + Navigation Title + 3.0 - name - varchar - 255 - Internal Name - 3.0 + name + varchar + 255 + Internal Name + 3.0 url @@ -56,43 +56,43 @@ 3.0 - permission - varchar - 255 - Permission for menu item - 3.0 + permission + varchar + 255 + Permission for menu item + 3.0 - permission_operator - varchar - 3 - Permission Operator - 3.0 + permission_operator + varchar + 3 + Permission Operator + 3.0 - parent_id - int unsigned - Parent navigation item, used for grouping - 3.0 + parent_id + int unsigned + Parent navigation item, used for grouping + 3.0 - parent_id - civicrm_navigation
- id - CASCADE - 3.0 + parent_id + civicrm_navigation
+ id + CASCADE + 3.0 - is_active - boolean - Is this navigation item active? - 3.0 + is_active + boolean + Is this navigation item active? + 3.0 - has_separator - boolean - If separator needs to be added after this menu item - 3.0 + has_separator + boolean + If separator needs to be added after this menu item + 3.0 weight diff --git a/xml/schema/Core/OpenID.xml b/xml/schema/Core/OpenID.xml index 607ea3ca18..027167344c 100644 --- a/xml/schema/Core/OpenID.xml +++ b/xml/schema/Core/OpenID.xml @@ -6,35 +6,35 @@ OpenID information for a specific location. 2.0 - id - int unsigned - true - Unique OpenID ID - 2.0 + id + int unsigned + true + Unique OpenID ID + 2.0 - id - true + id + true - contact_id - int unsigned - FK to Contact ID - 2.0 + contact_id + int unsigned + FK to Contact ID + 2.0 - contact_id - civicrm_contact
- id - 2.0 - CASCADE + contact_id + civicrm_contact
+ id + 2.0 + CASCADE - location_type_id - OpenID Location Type - int unsigned - Which Location does this email belong to. - 2.0 + location_type_id + OpenID Location Type + int unsigned + Which Location does this email belong to. + 2.0 index_location_type @@ -42,38 +42,38 @@ 2.0 - openid - OpenID - varchar - 255 - true - /^Open.?ID|u(niq\w*)?.?ID/i - /^[\w\/\:\.]+$/ - the OpenID (or OpenID-style http://username.domain/) unique identifier for this contact mainly used for logging in to CiviCRM - url - OpenID - 2.0 + openid + OpenID + varchar + 255 + true + /^Open.?ID|u(niq\w*)?.?ID/i + /^[\w\/\:\.]+$/ + the OpenID (or OpenID-style http://username.domain/) unique identifier for this contact mainly used for logging in to CiviCRM + url + OpenID + 2.0 - UI_openid - openid - true - 2.0 + UI_openid + openid + true + 2.0 - allowed_to_login - boolean - true - 0 - Whether or not this user is allowed to login - 2.0 + allowed_to_login + boolean + true + 0 + Whether or not this user is allowed to login + 2.0 - is_primary - Is OpenID Primary? - boolean - 0 - Is this the primary email for this contact and location. - 2.0 + is_primary + Is OpenID Primary? + boolean + 0 + Is this the primary email for this contact and location. + 2.0 diff --git a/xml/schema/Core/Persistent.xml b/xml/schema/Core/Persistent.xml index 710215140e..801bdbfbe5 100644 --- a/xml/schema/Core/Persistent.xml +++ b/xml/schema/Core/Persistent.xml @@ -6,44 +6,44 @@ DB Template Customization strings 3.2 - id - int unsigned - true - Persistent Record Id - 3.2 + id + int unsigned + true + Persistent Record Id + 3.2 - id - false + id + false - context - varchar - 255 - Context for which name data pair is to be stored - true - 3.2 + context + varchar + 255 + Context for which name data pair is to be stored + true + 3.2 - name - varchar - 255 - Name of Context - true - 3.2 + name + varchar + 255 + Name of Context + true + 3.2 - data - longtext - data associated with name - 3.2 + data + longtext + data associated with name + 3.2 - is_config - boolean - 0 - Config Settings - true - 3.2 + is_config + boolean + 0 + Config Settings + true + 3.2 diff --git a/xml/schema/Core/Preferences.xml b/xml/schema/Core/Preferences.xml index 22e3b055f9..985b71ab3c 100644 --- a/xml/schema/Core/Preferences.xml +++ b/xml/schema/Core/Preferences.xml @@ -9,61 +9,61 @@ 4.1 true - id - int unsigned - true - 1.8 + id + int unsigned + true + 1.8 - id - true + id + true - domain_id - int unsigned - true - Which Domain is this menu item for - 3.0 + domain_id + int unsigned + true + Which Domain is this menu item for + 3.0 - domain_id - civicrm_domain
- id - CASCADE - 3.0 + domain_id + civicrm_domain
+ id + CASCADE + 3.0 - contact_id - int unsigned - FK to Contact ID - 1.8 + contact_id + int unsigned + FK to Contact ID + 1.8 - contact_id - civicrm_contact
- id - CASCADE - 1.8 + contact_id + civicrm_contact
+ id + CASCADE + 1.8 - is_domain - boolean - Is this the record for the domain setting? - 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 + 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 + contact_view_options + varchar + 128 + What tabs are displayed in the contact summary + 1.8 index_contact_view_options @@ -71,11 +71,11 @@ 1.8 - contact_edit_options - varchar - 128 - What tabs are displayed in the contact edit - 1.8 + contact_edit_options + varchar + 128 + What tabs are displayed in the contact edit + 1.8 index_contact_edit_options @@ -83,11 +83,11 @@ 1.8 - advanced_search_options - varchar - 128 - What tabs are displayed in the advanced search screen - 1.8 + advanced_search_options + varchar + 128 + What tabs are displayed in the advanced search screen + 1.8 index_advanced_search_options @@ -95,11 +95,11 @@ 1.8 - user_dashboard_options - varchar - 128 - What tabs are displayed in the contact edit - 1.8 + user_dashboard_options + varchar + 128 + What tabs are displayed in the contact edit + 1.8 index_user_dashboard_options @@ -107,98 +107,98 @@ 1.8 - address_options - varchar - 128 - What fields are displayed from the address table - 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 + address_format + text + Format to display the address + 1.8 - mailing_format - text - Format to display a mailing label - 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 + display_name_format + text + Format to display contact display name + 3.2 - sort_name_format - text - Format to display contact sort 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 + 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_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_userid + varchar + 64 + user id for provider login + 1.8 - address_standardization_url - varchar - 255 - url of address standardization service - 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 + + editor_id + int unsigned + 4 + ID of the editor + 2.1 - - mailing_backend - text - Smtp Backend configuration. - - TextArea - 20 - 80 - - 2.2 + + mailing_backend + text + Smtp Backend configuration. + + TextArea + 20 + 80 + + 2.2 - navigation - text - Store navigation for the Contact - 3.0 + navigation + text + Store navigation for the Contact + 3.0 - contact_autocomplete_options - varchar - 255 - What Autocomplete has to return - 3.1 + contact_autocomplete_options + varchar + 255 + What Autocomplete has to return + 3.1 diff --git a/xml/schema/Core/PreferencesDate.xml b/xml/schema/Core/PreferencesDate.xml index 383509a271..8aa1ed7ed8 100644 --- a/xml/schema/Core/PreferencesDate.xml +++ b/xml/schema/Core/PreferencesDate.xml @@ -8,22 +8,22 @@ 2.0 true - id - int unsigned - true - 2.0 + id + int unsigned + true + 2.0 - id - true + id + true - name - varchar - 64 - true - The meta name for this date (fixed in code) - 2.0 + name + varchar + 64 + true + The meta name for this date (fixed in code) + 2.0 index_name @@ -31,45 +31,45 @@ 2.0 - description - varchar - 255 - Description of this date type. - 2.0 + description + varchar + 255 + Description of this date type. + 2.0 - start - int - true - The start offset relative to current year - 2.0 + start + int + true + The start offset relative to current year + 2.0 - end - int - true - The end offset relative to current year, can be negative - 2.0 + end + int + true + The end offset relative to current year, can be negative + 2.0 - minute_increment - int - The minute increment number - 2.0 - 3.1 + minute_increment + int + The minute increment number + 2.0 + 3.1 - date_format - varchar - 64 - The date type - 2.0 + date_format + varchar + 64 + The date type + 2.0 - time_format - varchar - 64 - time format - 3.1 + time_format + varchar + 64 + time format + 3.1 diff --git a/xml/schema/Core/PrevNextCache.xml b/xml/schema/Core/PrevNextCache.xml index 45b0455ca9..5db686e653 100644 --- a/xml/schema/Core/PrevNextCache.xml +++ b/xml/schema/Core/PrevNextCache.xml @@ -7,35 +7,35 @@ Table to cache items for navigation on civicrm searched results. 3.4 - id - int unsigned - true - 3.4 + id + int unsigned + true + 3.4 - id - true + id + true - entity_table - varchar - 64 - physical tablename for entity being joined to discount, e.g. civicrm_event - 3.4 + entity_table + varchar + 64 + physical tablename for entity being joined to discount, e.g. civicrm_event + 3.4 - entity_id1 - int unsigned - true - FK to entity table specified in entity_table column. - 3.4 + entity_id1 + int unsigned + true + FK to entity table specified in entity_table column. + 3.4 - entity_id2 - int unsigned - true - FK to entity table specified in entity_table column. - 3.4 + entity_id2 + int unsigned + true + FK to entity table specified in entity_table column. + 3.4 cacheKey @@ -57,11 +57,11 @@ 4.2 - index_all - cacheKey - entity_id1 - entity_id2 - entity_table - is_selected + index_all + cacheKey + entity_id1 + entity_id2 + entity_table + is_selected diff --git a/xml/schema/Core/Setting.xml b/xml/schema/Core/Setting.xml index 08f2978b9c..e50318fa55 100644 --- a/xml/schema/Core/Setting.xml +++ b/xml/schema/Core/Setting.xml @@ -7,32 +7,32 @@ Table to store civicrm settings for civicrm core and components. 4.1 - id + id Setting ID - int unsigned - true - 4.1 + int unsigned + true + 4.1 - id - true + id + true - group_name + group_name Setting Group - varchar - 64 - true - group name for setting element, useful in caching setting elements - 4.1 + varchar + 64 + true + group name for setting element, useful in caching setting elements + 4.1 - name + name Setting Name - varchar - 255 - Unique name for setting - 4.1 + varchar + 255 + Unique name for setting + 4.1 index_group_name @@ -47,45 +47,45 @@ 4.1 - domain_id + domain_id Setting Domain - int unsigned - true - - civicrm_domain
- id - name - - Which Domain is this menu item for - 4.1 + int unsigned + true + + civicrm_domain
+ id + name + + Which Domain is this menu item for + 4.1 - domain_id - civicrm_domain
- id - CASCADE - 4.1 + domain_id + civicrm_domain
+ id + CASCADE + 4.1 - contact_id + contact_id Setting Contact - int unsigned - FK to Contact ID if the setting is localized to a contact - 4.1 + int unsigned + FK to Contact ID if the setting is localized to a contact + 4.1 - contact_id - civicrm_contact
- id - CASCADE - 4.1 + contact_id + civicrm_contact
+ id + CASCADE + 4.1 - is_domain + is_domain Is Domain Setting? - boolean - Is this setting a contact specific or site wide setting? - 4.1 + boolean + Is this setting a contact specific or site wide setting? + 4.1 component_id @@ -103,10 +103,10 @@ - component_id - civicrm_component
- id - 4.1 + component_id + civicrm_component
+ id + 4.1 created_date diff --git a/xml/schema/Core/StateProvince.xml b/xml/schema/Core/StateProvince.xml index 83b1857500..daa60c4871 100644 --- a/xml/schema/Core/StateProvince.xml +++ b/xml/schema/Core/StateProvince.xml @@ -6,47 +6,47 @@ civicrm_state_province 1.1 - id - int unsigned - true - State / Province ID - 1.1 + id + int unsigned + true + State / Province ID + 1.1 - id - false + id + false - name - State - varchar - 64 - true - /state|prov(ince)?/i - /[A-Z]{2}/ - Name of State / Province - 1.1 + name + State + varchar + 64 + true + /state|prov(ince)?/i + /[A-Z]{2}/ + Name of State / Province + 1.1 - abbreviation - State Abbreviation - varchar - 4 - 2-4 Character Abbreviation of State / Province - 1.1 + abbreviation + State Abbreviation + varchar + 4 + 2-4 Character Abbreviation of State / Province + 1.1 - country_id - int unsigned - true - ID of Country that State / Province belong - 1.1 + country_id + int unsigned + true + ID of Country that State / Province belong + 1.1 - country_id - civicrm_country
- id - 1.1 + country_id + civicrm_country
+ id + 1.1 UI_name_country_id diff --git a/xml/schema/Core/Tag.xml b/xml/schema/Core/Tag.xml index 000b058046..13fd3869df 100644 --- a/xml/schema/Core/Tag.xml +++ b/xml/schema/Core/Tag.xml @@ -8,55 +8,55 @@ 1.1 true - id - Tag ID - int unsigned - true - Tag ID - 1.1 + id + Tag ID + int unsigned + true + Tag ID + 1.1 - id - true + id + true - name - Tag Name - varchar - true - 64 - Name of Tag. - 1.1 + name + Tag Name + varchar + true + 64 + Name of Tag. + 1.1 - description - Description - varchar - 255 - Optional verbose description of the tag. - 1.1 + description + Description + varchar + 255 + Optional verbose description of the tag. + 1.1 - parent_id - Parent Tag - int unsigned - NULL - Optional parent id for this tag. - 1.1 + parent_id + Parent Tag + int unsigned + NULL + Optional parent id for this tag. + 1.1 - is_selectable - Display Tag? - boolean - 1 - Is this tag selectable / displayed - 2.1 + is_selectable + Display Tag? + boolean + 1 + Is this tag selectable / displayed + 2.1 - parent_id - civicrm_tag
- id - 1.1 + parent_id + civicrm_tag
+ id + 1.1 UI_name diff --git a/xml/schema/Core/Timezone.xml b/xml/schema/Core/Timezone.xml index a42c81566e..edccd0778c 100644 --- a/xml/schema/Core/Timezone.xml +++ b/xml/schema/Core/Timezone.xml @@ -6,55 +6,55 @@ civicrm_timezone 1.8 - id - int unsigned - true - Timezone Id - 1.8 + id + int unsigned + true + Timezone Id + 1.8 - id - true + id + true - name - varchar - 64 - Timezone full name - 1.8 + name + varchar + 64 + Timezone full name + 1.8 - abbreviation - char - 3 - ISO Code for timezone abbreviation - 1.8 + abbreviation + char + 3 + ISO Code for timezone abbreviation + 1.8 - gmt - varchar - 64 - GMT name of the timezone - 1.8 + gmt + varchar + 64 + GMT name of the timezone + 1.8 - offset - int - - 1.8 + offset + int + + 1.8 - country_id - int unsigned - true - Country Id - 1.8 + country_id + int unsigned + true + Country Id + 1.8 - country_id - civicrm_country
- id - 1.8 + country_id + civicrm_country
+ id + 1.8 diff --git a/xml/schema/Core/UFGroup.xml b/xml/schema/Core/UFGroup.xml index 40d2e21a96..b1058e3d9a 100644 --- a/xml/schema/Core/UFGroup.xml +++ b/xml/schema/Core/UFGroup.xml @@ -8,199 +8,199 @@ 1.1 true - id - Profile ID - int unsigned - true - Unique table ID - 1.1 + id + Profile ID + int unsigned + true + Unique table ID + 1.1 - id - true + id + true - is_active - Profile Is Active - boolean - 1 - Is this form currently active? If false, hide all related fields for all sharing contexts. - 1.1 - - - group_type - Profile Group Type - varchar - 255 - true - This column will store a comma separated list of the type(s) of profile fields. - 2.1 - - - form_type - enum - CiviCRM Profile - Type of form. - 2.1 - - - title - varchar - 64 - true - true - Form title. - 1.1 - - - description - text - Profile Description - - TextArea - 2 - 60 - - Optional verbose description of the profile. - 4.4 - - - collapse_display - int unsigned - 0 - Will this group be in collapsed or expanded mode on initial display ? - 1.1 - 2.2 - - - help_pre - text - true - Description and/or help text to display before fields in form. - - TextArea - 4 - 80 - - 1.2 - - - help_post - Profile Post Text - text - true - Description and/or help text to display after fields in form. - - TextArea - 4 - 80 - - 1.2 - - - weight - Profile Weight - int - true - 1 - Controls display order when multiple user framework groups are setup for concurrent display. - 1.2 - 1.3 - - - limit_listings_group_id - Profile Search Limit Group - int unsigned - Group id, foriegn key from civicrm_group - 1.4 + is_active + Profile Is Active + boolean + 1 + Is this form currently active? If false, hide all related fields for all sharing contexts. + 1.1 + + + group_type + Profile Group Type + varchar + 255 + true + This column will store a comma separated list of the type(s) of profile fields. + 2.1 + + + form_type + enum + CiviCRM Profile + Type of form. + 2.1 + + + title + varchar + 64 + true + true + Form title. + 1.1 + + + description + text + Profile Description + + TextArea + 2 + 60 + + Optional verbose description of the profile. + 4.4 + + + collapse_display + int unsigned + 0 + Will this group be in collapsed or expanded mode on initial display ? + 1.1 + 2.2 + + + help_pre + text + true + Description and/or help text to display before fields in form. + + TextArea + 4 + 80 + + 1.2 + + + help_post + Profile Post Text + text + true + Description and/or help text to display after fields in form. + + TextArea + 4 + 80 + + 1.2 + + + weight + Profile Weight + int + true + 1 + Controls display order when multiple user framework groups are setup for concurrent display. + 1.2 + 1.3 + + + limit_listings_group_id + Profile Search Limit Group + int unsigned + Group id, foriegn key from civicrm_group + 1.4 - limit_listings_group_id - civicrm_group
- id - 1.4 - SET NULL + limit_listings_group_id + civicrm_group
+ id + 1.4 + SET NULL - post_URL - varchar - 255 - Redirect to URL. - 1.4 + post_URL + varchar + 255 + Redirect to URL. + 1.4 - add_to_group_id - Add Contact To Group - int unsigned - foreign key to civicrm_group_id + add_to_group_id + Add Contact To Group + int unsigned + foreign key to civicrm_group_id - add_to_group_id - civicrm_group
- id - SET NULL + add_to_group_id + civicrm_group
+ id + SET NULL - - add_captcha - Show Captcha On Profile - boolean - 0 - Should a CAPTCHA widget be included this Profile form. - 1.1 - - - is_map - Map Profile - boolean - 0 - Do we want to map results from this profile. - 1.5 - - - is_edit_link - Show Edit Link? - boolean - 0 - Should edit link display in profile selector - 1.6 - - - is_uf_link - Show Link to CMS User - boolean - 0 - Should we display a link to the website profile in profile selector - 1.7 - - - is_update_dupe - Update on Duplicate - boolean - 0 - Should we update the contact record if we find a duplicate - 1.7 - - - cancel_URL - Profile Cancel URL - varchar - 255 - Redirect to URL when Cancle button clik . - 1.4 - - - is_cms_user - Create CMS User? - boolean - 0 - Should we create a cms user for this profile - 1.8 - - - notify - Notify on Profile Submit - text - 1.8 + + add_captcha + Show Captcha On Profile + boolean + 0 + Should a CAPTCHA widget be included this Profile form. + 1.1 + + + is_map + Map Profile + boolean + 0 + Do we want to map results from this profile. + 1.5 + + + is_edit_link + Show Edit Link? + boolean + 0 + Should edit link display in profile selector + 1.6 + + + is_uf_link + Show Link to CMS User + boolean + 0 + Should we display a link to the website profile in profile selector + 1.7 + + + is_update_dupe + Update on Duplicate + boolean + 0 + Should we update the contact record if we find a duplicate + 1.7 + + + cancel_URL + Profile Cancel URL + varchar + 255 + Redirect to URL when Cancle button clik . + 1.4 + + + is_cms_user + Create CMS User? + boolean + 0 + Should we create a cms user for this profile + 1.8 + + + notify + Notify on Profile Submit + text + 1.8 is_reserved diff --git a/xml/schema/Core/UFJoin.xml b/xml/schema/Core/UFJoin.xml index 3b463b9047..6f23639427 100644 --- a/xml/schema/Core/UFJoin.xml +++ b/xml/schema/Core/UFJoin.xml @@ -8,97 +8,97 @@ 1.3 true - id - UF Join ID - int unsigned - true - Unique table ID - 1.3 + id + UF Join ID + int unsigned + true + Unique table ID + 1.3 - id - true + id + true - is_active - Profile Use is active - boolean - 1 - Is this join currently active? - 1.3 + is_active + Profile Use is active + boolean + 1 + Is this join currently active? + 1.3 - module - Profile Module - varchar - 64 - true - Module which owns this uf_join instance, e.g. User Registration, CiviDonate, etc. - 1.3 + module + Profile Module + varchar + 64 + true + Module which owns this uf_join instance, e.g. User Registration, CiviDonate, etc. + 1.3 - entity_table - Profile Entity Table - varchar - 64 - Name of table where item being referenced is stored. Modules which only need a single collection of uf_join instances may choose not to populate entity_table and entity_id. - 1.3 + entity_table + Profile Entity Table + varchar + 64 + Name of table where item being referenced is stored. Modules which only need a single collection of uf_join instances may choose not to populate entity_table and entity_id. + 1.3 - entity_id - Profile Entity ID - int unsigned - Foreign key to the referenced item. - 1.3 + entity_id + Profile Entity ID + int unsigned + Foreign key to the referenced item. + 1.3 - entity_id - entity_table - 1.3 + entity_id + entity_table + 1.3 - index_entity - 1.3 - entity_table - entity_id - 1.3 + index_entity + 1.3 + entity_table + entity_id + 1.3 - weight - Profile Weight - int - true - 1 - Controls display order when multiple user framework groups are setup for concurrent display. - 1.3 + weight + Profile Weight + int + true + 1 + Controls display order when multiple user framework groups are setup for concurrent display. + 1.3 - uf_group_id - Profile ID - int unsigned - true - Which form does this field belong to. - 1.3 - - civicrm_uf_group
- id - title - - - Select - + uf_group_id + Profile ID + int unsigned + true + Which form does this field belong to. + 1.3 + + civicrm_uf_group
+ id + title + + + Select + - uf_group_id - civicrm_uf_group
- id - 1.3 + uf_group_id + civicrm_uf_group
+ id + 1.3 - module_data - Profile Use Data - longtext - Json serialized array of data used by the ufjoin.module - 4.5 + module_data + Profile Use Data + longtext + Json serialized array of data used by the ufjoin.module + 4.5 diff --git a/xml/schema/Core/UFMatch.xml b/xml/schema/Core/UFMatch.xml index a4481d27fd..fb3a05425d 100644 --- a/xml/schema/Core/UFMatch.xml +++ b/xml/schema/Core/UFMatch.xml @@ -8,79 +8,79 @@ 1.1 true - id - UF Match ID - int unsigned - true - System generated ID. - 1.1 + id + UF Match ID + int unsigned + true + System generated ID. + 1.1 - id - true + id + true - domain_id - UF Match Domain ID - int unsigned - true - Which Domain is this match entry for - - civicrm_domain
- id - name - - 3.0 + domain_id + UF Match Domain ID + int unsigned + true + Which Domain is this match entry for + + civicrm_domain
+ id + name + + 3.0 - domain_id - civicrm_domain
- id - 3.0 + domain_id + civicrm_domain
+ id + 3.0 - uf_id - CMS ID - int unsigned - true - UF ID - 1.1 + uf_id + CMS ID + int unsigned + true + UF ID + 1.1 - I_civicrm_uf_match_uf_id - uf_id - 3.3 + I_civicrm_uf_match_uf_id + uf_id + 3.3 - uf_name - CMS Unique Identifier - varchar - 128 - UF Name - 1.9.kabissa + uf_name + CMS Unique Identifier + varchar + 128 + UF Name + 1.9.kabissa - contact_id - CiviCRM Contact ID - int unsigned - FK to Contact ID - 1.1 + contact_id + CiviCRM Contact ID + int unsigned + FK to Contact ID + 1.1 - contact_id - civicrm_contact
- id - 1.1 - CASCADE + contact_id + civicrm_contact
+ id + 1.1 + CASCADE - email - varchar - 64 - email - Email address - 1.1 - 2.0 + email + varchar + 64 + email + Email address + 1.1 + 2.0 language @@ -91,24 +91,24 @@ 2.1 - UI_uf_id_domain_id - uf_id - domain_id - true - 1.5 - 1.7 + UI_uf_id_domain_id + uf_id + domain_id + true + 1.5 + 1.7 - UI_uf_name_domain_id - uf_name - domain_id - true - 2.1 + UI_uf_name_domain_id + uf_name + domain_id + true + 2.1 UI_contact_domain_id contact_id - domain_id + domain_id true 1.6 diff --git a/xml/schema/Core/Website.xml b/xml/schema/Core/Website.xml index d6a9fdff82..32a68a4c76 100644 --- a/xml/schema/Core/Website.xml +++ b/xml/schema/Core/Website.xml @@ -7,58 +7,58 @@ Website information for a specific location. 3.2 - id - int unsigned - Website ID - true - Unique Website ID - 3.2 + id + int unsigned + Website ID + true + Unique Website ID + 3.2 - id - true + id + true - contact_id - Contact - int unsigned - FK to Contact ID - 3.2 + contact_id + Contact + int unsigned + FK to Contact ID + 3.2 - contact_id - civicrm_contact
- id - 3.2 - CASCADE + contact_id + civicrm_contact
+ id + 3.2 + CASCADE - url - Website - varchar - 128 - - Text - BIG - - true - /Website/i - /^[A-Za-z][0-9A-Za-z]{20,}$/ - Website - 3.2 + url + Website + varchar + 128 + + Text + BIG + + true + /Website/i + /^[A-Za-z][0-9A-Za-z]{20,}$/ + Website + 3.2 - website_type_id - Website Type - int unsigned - Which Website type does this website belong to. - 3.2 - - website_type - - - Select - + website_type_id + Website Type + int unsigned + Which Website type does this website belong to. + 3.2 + + website_type + + + Select + UI_website_type_id diff --git a/xml/schema/Core/Worldregion.xml b/xml/schema/Core/Worldregion.xml index 1c2f287004..bdf52037c8 100644 --- a/xml/schema/Core/Worldregion.xml +++ b/xml/schema/Core/Worldregion.xml @@ -6,24 +6,24 @@ civicrm_worldregion 1.8 - id - int unsigned - true - Country Id - 1.8 + id + int unsigned + true + Country Id + 1.8 - id - true + id + true - name - world_region - World Region - varchar - 128 - Region name to be associated with countries - true - 1.8 + name + world_region + World Region + varchar + 128 + Region name to be associated with countries + true + 1.8 diff --git a/xml/schema/Event/EventPage.xml b/xml/schema/Event/EventPage.xml index 5992f52ecd..1969f61910 100644 --- a/xml/schema/Event/EventPage.xml +++ b/xml/schema/Event/EventPage.xml @@ -6,218 +6,228 @@ civicrm_event_page 1.7 - id - int unsigned - true - Event Page ID - 1.7 + id + int unsigned + true + Event Page ID + 1.7 - id - true + id + true - event_id - Event - int unsigned - true - Event which this page belongs to. - 1.7 + event_id + Event + int unsigned + true + Event which this page belongs to. + 1.7 - event_id - civicrm_event
- id - CASCADE + event_id + civicrm_event
+ id + CASCADE - intro_text - text - - TextArea - 6 - 50 - - Introductory Message - true - Introductory message for Event Registration page. Text and html allowed. Displayed at the top of Event Registration form. - 1.7 - - - footer_text - Footer Message - text - - TextArea - 6 - 50 - - true - Footer message for Event Registration page. Text and html allowed. Displayed at the bottom of Event Registration form. - 1.7 - - - confirm_title - varchar - Confirmation Title - 255 - NULL - true - Title for Confirmation page. - 1.7 - - - confirm_text - text - - TextArea - 6 - 50 - - Confirm Text - true - Introductory message for Event Registration page. Text and html allowed. Displayed at the top of Event Registration form. - 1.7 - - - confirm_footer_text - text - Footer Text - - TextArea - 6 - 50 - - true - Footer message for Event Registration page. Text and html allowed. Displayed at the bottom of Event Registration form. - 1.7 - - - is_email_confirm - boolean - Is confirm email - 0 - If true, confirmation is automatically emailed to contact on successful registration. - 1.7 - - - confirm_email_text - text - Confirmation Email Text - - TextArea - 4 - 50 - - true - text to include above standard event info on confirmation email. emails are text-only, so do not allow html for now - 1.7 - - - confirm_from_name - varchar - Confirm From Name - 255 - true - FROM email name used for confirmation emails. - 1.7 - - - confirm_from_email - varchar - Confirm From Email - 255 - FROM email address used for confirmation emails. - 1.7 - - - cc_confirm - varchar - 255 - comma-separated list of email addresses to cc each time a confirmation is sent - 1.7 - - - bcc_confirm - varchar - 255 - comma-separated list of email addresses to bcc each time a confirmation is sent - 1.7 - - - default_fee_id - int unsigned - FK to civicrm_option_value. - 1.7 - - - default_discount_id - int unsigned - FK to civicrm_option_value. - 1.7 - - - thankyou_title - varchar - ThankYou Title - 255 - NULL - true - Title for ThankYou page. - 1.7 - - - thankyou_text - text - - TextArea - 6 - 50 - - ThankYou Text - true - ThankYou Text. - 1.7 - - - thankyou_footer_text - text - Footer Text - - TextArea - 6 - 50 - - true - Footer message. - 1.7 - - - is_pay_later - boolean - 0 - if true - allows the user to send payment directly to the org later - 2.0 - - - pay_later_text - text - true - The text displayed to the user in the main form - 2.0 - - - pay_later_receipt - text - true - The receipt sent to the user instead of the normal receipt text - 2.0 - - - is_multiple_registrations - boolean - 0 - if true - allows the user to register multiple participants for event - 2.1 + intro_text + text + + TextArea + 6 + 50 + + Introductory Message + true + Introductory message for Event Registration page. Text and html allowed. Displayed at the top of Event + Registration form. + + 1.7 + + + footer_text + Footer Message + text + + TextArea + 6 + 50 + + true + Footer message for Event Registration page. Text and html allowed. Displayed at the bottom of Event + Registration form. + + 1.7 + + + confirm_title + varchar + Confirmation Title + 255 + NULL + true + Title for Confirmation page. + 1.7 + + + confirm_text + text + + TextArea + 6 + 50 + + Confirm Text + true + Introductory message for Event Registration page. Text and html allowed. Displayed at the top of Event + Registration form. + + 1.7 + + + confirm_footer_text + text + Footer Text + + TextArea + 6 + 50 + + true + Footer message for Event Registration page. Text and html allowed. Displayed at the bottom of Event + Registration form. + + 1.7 + + + is_email_confirm + boolean + Is confirm email + 0 + If true, confirmation is automatically emailed to contact on successful registration. + 1.7 + + + confirm_email_text + text + Confirmation Email Text + + TextArea + 4 + 50 + + true + text to include above standard event info on confirmation email. emails are text-only, so do not allow html + for now + + 1.7 + + + confirm_from_name + varchar + Confirm From Name + 255 + true + FROM email name used for confirmation emails. + 1.7 + + + confirm_from_email + varchar + Confirm From Email + 255 + FROM email address used for confirmation emails. + 1.7 + + + cc_confirm + varchar + 255 + comma-separated list of email addresses to cc each time a confirmation is sent + 1.7 + + + bcc_confirm + varchar + 255 + comma-separated list of email addresses to bcc each time a confirmation is sent + 1.7 + + + default_fee_id + int unsigned + FK to civicrm_option_value. + 1.7 + + + default_discount_id + int unsigned + FK to civicrm_option_value. + 1.7 + + + thankyou_title + varchar + ThankYou Title + 255 + NULL + true + Title for ThankYou page. + 1.7 + + + thankyou_text + text + + TextArea + 6 + 50 + + ThankYou Text + true + ThankYou Text. + 1.7 + + + thankyou_footer_text + text + Footer Text + + TextArea + 6 + 50 + + true + Footer message. + 1.7 + + + is_pay_later + boolean + 0 + if true - allows the user to send payment directly to the org later + 2.0 + + + pay_later_text + text + true + The text displayed to the user in the main form + 2.0 + + + pay_later_receipt + text + true + The receipt sent to the user instead of the normal receipt text + 2.0 + + + is_multiple_registrations + boolean + 0 + if true - allows the user to register multiple participants for event + 2.1 diff --git a/xml/schema/Event/Participant.xml b/xml/schema/Event/Participant.xml index e76bca9db9..260baff418 100644 --- a/xml/schema/Event/Participant.xml +++ b/xml/schema/Event/Participant.xml @@ -7,73 +7,75 @@ 1.7 true - id - participant_id - Participant ID - int unsigned - true - Participant Id - true - /(^(participant(.)?)?id$)/i - 1.7 + id + participant_id + Participant ID + int unsigned + true + Participant Id + true + /(^(participant(.)?)?id$)/i + 1.7 - id - true + id + true - contact_id - participant_contact_id - int unsigned - Contact ID - /contact(.?id)?/i - true - true - FK to Contact ID - 1.7 + contact_id + participant_contact_id + int unsigned + Contact ID + /contact(.?id)?/i + true + true + FK to Contact ID + 1.7 - contact_id - civicrm_contact
- id - CASCADE + contact_id + civicrm_contact
+ id + CASCADE - event_id - int unsigned - Event - true - /event id$/i - true - FK to Event ID - 1.7 + event_id + int unsigned + Event + true + /event id$/i + true + FK to Event ID + 1.7 - event_id - civicrm_event
- id - CASCADE + event_id + civicrm_event
+ id + CASCADE - status_id - participant_status_id - Participant Status - /(participant.)?(status)$/i - true - int unsigned - false - true - 1 - Participant status ID. FK to civicrm_participant_status_type. Default of 1 should map to status = Registered. - 1.7 - - civicrm_participant_status_type
- id - label - - - Select - + status_id + participant_status_id + Participant Status + /(participant.)?(status)$/i + true + int unsigned + false + true + 1 + Participant status ID. FK to civicrm_participant_status_type. Default of 1 should map to status = + Registered. + + 1.7 + + civicrm_participant_status_type
+ id + label + + + Select + status_id @@ -87,23 +89,23 @@ 1.8 - role_id - participant_role_id - Participant Role(s) - - participant_role - - - Select - - /(participant.)?(role)$/i - true - varchar - 128 - false - NULL - Participant role ID. Implicit FK to civicrm_option_value where option_group = participant_role. - 1.7 + role_id + participant_role_id + Participant Role(s) + + participant_role + + + Select + + /(participant.)?(role)$/i + true + varchar + 128 + false + NULL + Participant role ID. Implicit FK to civicrm_option_value where option_group = participant_role. + 1.7 index_role_id @@ -111,168 +113,170 @@ 1.8 - register_date - participant_register_date - Register date - /^(r(egister\s)?date)$/i - true - datetime - When did contact register for event? - 1.7 + register_date + participant_register_date + Register date + /^(r(egister\s)?date)$/i + true + datetime + When did contact register for event? + 1.7 - source - participant_source - Participant Source - /(participant.)?(source)$/i - true - varchar - 128 - Source of this event registration. - 1.7 + source + participant_source + Participant Source + /(participant.)?(source)$/i + true + varchar + 128 + Source of this event registration. + 1.7 - fee_level - participant_fee_level - Fee level - /^(f(ee\s)?level)$/i - text - true - Populate with the label (text) associated with a fee level for paid events with multiple levels. Note that we store the label value and not the key - 1.7 + fee_level + participant_fee_level + Fee level + /^(f(ee\s)?level)$/i + text + true + Populate with the label (text) associated with a fee level for paid events with multiple levels. Note that + we store the label value and not the key + + 1.7 - is_test - participant_is_test - Test - boolean - 0 - true - 1.7 + is_test + participant_is_test + Test + boolean + 0 + true + 1.7 - is_pay_later - participant_is_pay_later - Is Pay Later - boolean - 0 - true - /(is.)?(pay(.)?later)$/i - 2.1 + is_pay_later + participant_is_pay_later + Is Pay Later + boolean + 0 + true + /(is.)?(pay(.)?later)$/i + 2.1 - fee_amount - participant_fee_amount - Fee Amount - decimal - true - /fee(.?am(ou)?nt)?/i - /^\d+(\.\d{2})?$/ - actual processor fee if known - may be 0. - 2.1 + fee_amount + participant_fee_amount + Fee Amount + decimal + true + /fee(.?am(ou)?nt)?/i + /^\d+(\.\d{2})?$/ + actual processor fee if known - may be 0. + 2.1 - registered_by_id - participant_registered_by_id - int unsigned - Registered By ID - true - NULL - FK to Participant ID - 2.1 - true + registered_by_id + participant_registered_by_id + int unsigned + Registered By ID + true + NULL + FK to Participant ID + 2.1 + true - registered_by_id - civicrm_participant
- id - 2.1 - SET NULL + registered_by_id + civicrm_participant
+ id + 2.1 + SET NULL - discount_id - participant_discount_id - int unsigned - Discount ID - NULL - FK to Discount ID - 2.1 + discount_id + participant_discount_id + int unsigned + Discount ID + NULL + FK to Discount ID + 2.1 - discount_id - civicrm_discount
- id - 2.1 - SET NULL + discount_id + civicrm_discount
+ id + 2.1 + SET NULL - fee_currency - participant_fee_currency - Fee Currency - varchar - 3 - NULL - true - /(fee)?.?cur(rency)?/i - /^[A-Z]{3}$/i - 3 character string, value derived from config setting. - 3.0 - - civicrm_currency
- name - full_name - numeric_code - - - Select - + fee_currency + participant_fee_currency + Fee Currency + varchar + 3 + NULL + true + /(fee)?.?cur(rency)?/i + /^[A-Z]{3}$/i + 3 character string, value derived from config setting. + 3.0 + + civicrm_currency
+ name + full_name + numeric_code + + + Select + - campaign_id - participant_campaign_id - int unsigned - Campaign - true - The campaign for which this participant has been registered. - - civicrm_campaign
- id - title - - 3.4 + campaign_id + participant_campaign_id + int unsigned + Campaign + true + The campaign for which this participant has been registered. + + civicrm_campaign
+ id + title + + 3.4 - campaign_id - civicrm_campaign
- id - SET NULL + campaign_id + civicrm_campaign
+ id + SET NULL - discount_amount - int unsigned - Discount Amount - Discount Amount - 4.1 + discount_amount + int unsigned + Discount Amount + Discount Amount + 4.1 - cart_id - int unsigned - Event Cart ID - FK to civicrm_event_carts - 4.1 + cart_id + int unsigned + Event Cart ID + FK to civicrm_event_carts + 4.1 - cart_id - civicrm_event_carts
- id - SET NULL + cart_id + civicrm_event_carts
+ id + SET NULL - must_wait - int - Must Wait on List - On Waiting List - 4.1 + must_wait + int + Must Wait on List + On Waiting List + 4.1 diff --git a/xml/schema/Event/ParticipantPayment.xml b/xml/schema/Event/ParticipantPayment.xml index ecb4df53bf..c751945685 100644 --- a/xml/schema/Event/ParticipantPayment.xml +++ b/xml/schema/Event/ParticipantPayment.xml @@ -7,44 +7,44 @@ 1.7 true - id - Payment ID - int unsigned - true - Participant Payment Id - 1.7 + id + Payment ID + int unsigned + true + Participant Payment Id + 1.7 - id - true + id + true - participant_id - Participant ID - int unsigned - true - Participant Id (FK) - 1.7 + participant_id + Participant ID + int unsigned + true + Participant Id (FK) + 1.7 - participant_id - civicrm_participant
- id - CASCADE + participant_id + civicrm_participant
+ id + CASCADE - contribution_id - int unsigned - true - FK to contribution table. - 2.0 + contribution_id + int unsigned + true + FK to contribution table. + 2.0 - contribution_id - civicrm_contribution
- id - 2.0 - CASCADE + contribution_id + civicrm_contribution
+ id + 2.0 + CASCADE UI_contribution_participant diff --git a/xml/schema/Financial/Currency.xml b/xml/schema/Financial/Currency.xml index 96113189f4..19c5a24fcd 100644 --- a/xml/schema/Financial/Currency.xml +++ b/xml/schema/Financial/Currency.xml @@ -7,54 +7,54 @@ 1.7 true - id - int unsigned - true - Currency Id - 1.7 + id + int unsigned + true + Currency Id + 1.7 - id - true + id + true - name - Currency - varchar - 64 - true - Currency Name - 1.7 - - Text - + name + Currency + varchar + 64 + true + Currency Name + 1.7 + + Text + - symbol - varchar - 8 - Currency Symbol - 1.7 - - Text - + symbol + varchar + 8 + Currency Symbol + 1.7 + + Text + - numeric_code - varchar - 3 - true - Numeric currency code - 1.9 + numeric_code + varchar + 3 + true + Numeric currency code + 1.9 - full_name - varchar - 64 - Full currency name - - Text - - 1.9 + full_name + varchar + 64 + Full currency name + + Text + + 1.9 diff --git a/xml/schema/Financial/PaymentProcessorType.xml b/xml/schema/Financial/PaymentProcessorType.xml index 55b766bb4d..6aef995e31 100644 --- a/xml/schema/Financial/PaymentProcessorType.xml +++ b/xml/schema/Financial/PaymentProcessorType.xml @@ -6,50 +6,50 @@ civicrm_payment_processor_type 1.8 - id - int unsigned - true - Payment Processor Type ID - 1.8 + id + int unsigned + true + Payment Processor Type ID + 1.8 - id - true + id + true - name - Payment Processor variable name to be used in code - varchar - 64 - Payment Processor Name. - 1.8 + name + Payment Processor variable name to be used in code + varchar + 64 + Payment Processor Name. + 1.8 - title - Payment Processor Title - varchar - 127 - Payment Processor Name. - 1.8 + title + Payment Processor Title + varchar + 127 + Payment Processor Name. + 1.8 - description - varchar - 255 - Payment Processor Description. - 1.8 + description + varchar + 255 + Payment Processor Description. + 1.8 - is_active - boolean - Is this processor active? - 1.8 + is_active + boolean + Is this processor active? + 1.8 - is_default - boolean - Is this processor the default? - 1.8 + is_default + boolean + Is this processor the default? + 1.8 UI_name @@ -58,120 +58,120 @@ 2.1 - user_name_label - Label for User Name if used - varchar - 255 - 1.8 + user_name_label + Label for User Name if used + varchar + 255 + 1.8 - password_label - Label for password - varchar - 255 - 1.8 + password_label + Label for password + varchar + 255 + 1.8 - signature_label - Label for Signature - varchar - 255 - 1.8 + signature_label + Label for Signature + varchar + 255 + 1.8 - subject_label - Label for Subject - varchar - 255 - 1.8 + subject_label + Label for Subject + varchar + 255 + 1.8 - class_name - Suffix for PHP clas name implementation - varchar - 255 - 1.8 + class_name + Suffix for PHP clas name implementation + varchar + 255 + 1.8 - url_site_default - Default Live Site URL - varchar - 255 - 1.8 + url_site_default + Default Live Site URL + varchar + 255 + 1.8 - url_api_default - Default API Site URL - varchar - 255 - 1.8 + url_api_default + Default API Site URL + varchar + 255 + 1.8 - url_recur_default - Default Live Recurring Payments URL - varchar - 255 - 1.8 + url_recur_default + Default Live Recurring Payments URL + varchar + 255 + 1.8 - url_button_default - Default Live Button URL - varchar - 255 - 1.8 + url_button_default + Default Live Button URL + varchar + 255 + 1.8 - url_site_test_default - Default Test Site URL - varchar - 255 - 1.8 + url_site_test_default + Default Test Site URL + varchar + 255 + 1.8 - url_api_test_default - Default Test API URL - varchar - 255 - 1.8 + url_api_test_default + Default Test API URL + varchar + 255 + 1.8 - url_recur_test_default - Default Test Recurring Payment URL - varchar - 255 - 1.8 + url_recur_test_default + Default Test Recurring Payment URL + varchar + 255 + 1.8 - url_button_test_default - Default Test Button URL - varchar - 255 - 1.8 + url_button_test_default + Default Test Button URL + varchar + 255 + 1.8 - billing_mode - int unsigned - true - Billing Mode - - CRM_Core_SelectValues::billingMode - - - Select - - 1.8 + billing_mode + int unsigned + true + Billing Mode + + CRM_Core_SelectValues::billingMode + + + Select + + 1.8 - is_recur - boolean - Can process recurring contributions - 1.8 + is_recur + boolean + Can process recurring contributions + 1.8 - payment_type - int unsigned - 1 - Payment Type: Credit or Debit - 3.0 + payment_type + int unsigned + 1 + Payment Type: Credit or Debit + 3.0 diff --git a/xml/schema/Friend/Friend.xml b/xml/schema/Friend/Friend.xml index 68cc704904..b851fdfdef 100644 --- a/xml/schema/Friend/Friend.xml +++ b/xml/schema/Friend/Friend.xml @@ -6,97 +6,97 @@ civicrm_tell_friend 2.0 - id - int unsigned - true - Friend ID - 2.0 + id + int unsigned + true + Friend ID + 2.0 - id - true + id + true - entity_table - varchar - 64 - true - Name of table where item being referenced is stored. - 2.0 + entity_table + varchar + 64 + true + Name of table where item being referenced is stored. + 2.0 - entity_id - int unsigned - true - Foreign key to the referenced item. - 2.0 + entity_id + int unsigned + true + Foreign key to the referenced item. + 2.0 - entity_id - entity_table - 2.0 + entity_id + entity_table + 2.0 - title - varchar - 255 - true - - Text - - 2.0 + title + varchar + 255 + true + + Text + + 2.0 - intro - text - true - Introductory message to contributor or participant displayed on the Tell a Friend form. - - Text - - 2.0 + intro + text + true + Introductory message to contributor or participant displayed on the Tell a Friend form. + + Text + + 2.0 - suggested_message - text - true - Suggested message to friends, provided as default on the Tell A Friend form. - - Text - - 2.0 + suggested_message + text + true + Suggested message to friends, provided as default on the Tell A Friend form. + + Text + + 2.0 - general_link - varchar - 255 - true - URL for general info about the organization - included in the email sent to friends. - - Text - - 2.0 + general_link + varchar + 255 + true + URL for general info about the organization - included in the email sent to friends. + + Text + + 2.0 - thankyou_title - varchar - 255 - true - Text for Tell a Friend thank you page header and HTML title. - - Text - - 2.0 + thankyou_title + varchar + 255 + true + Text for Tell a Friend thank you page header and HTML title. + + Text + + 2.0 - thankyou_text - text - true - Thank you message displayed on success page. - 2.0 - - Text - + thankyou_text + text + true + Thank you message displayed on success page. + 2.0 + + Text + is_active diff --git a/xml/schema/Queue/QueueItem.xml b/xml/schema/Queue/QueueItem.xml index 106394ca79..fa2ed63e8b 100644 --- a/xml/schema/Queue/QueueItem.xml +++ b/xml/schema/Queue/QueueItem.xml @@ -11,60 +11,60 @@ Stores a list of queue items 4.2 - id - int unsigned - true + id + int unsigned + true - id - true + id + true - queue_name - varchar - 64 - Name of the queue which includes this item - true - - Text - + queue_name + varchar + 64 + Name of the queue which includes this item + true + + Text + - weight - int - true - - Text - + weight + int + true + + Text + - submit_time - datetime - date on which this item was submitted to the queue - true - - Select Date + submit_time + datetime + date on which this item was submitted to the queue + true + + Select Date - release_time - datetime - date on which this job becomes available; null if ASAP - - Select Date + release_time + datetime + date on which this job becomes available; null if ASAP + + Select Date - + - data - Queue item datas - text - Serialized queue + data + Queue item datas + text + Serialized queue - index_queueids - queue_name - weight - id + index_queueids + queue_name + weight + id -- 2.25.1