From 3c7d215856dd2d528302ceec14ed0f6e958aa677 Mon Sep 17 00:00:00 2001 From: eileen Date: Tue, 18 Jun 2013 13:18:37 +1200 Subject: [PATCH] remove trailing whitespaces en-masse --- xml/schema/Activity/ActivityAssignment.xml | 26 +- xml/schema/Bridge/OG.xml | 2 +- xml/schema/Bridge/Role.xml | 34 +-- xml/schema/Campaign/Campaign.xml | 8 +- xml/schema/Campaign/CampaignGroup.xml | 8 +- xml/schema/Campaign/Survey.xml | 2 +- xml/schema/Case/Case.xml | 12 +- xml/schema/Case/CaseActivity.xml | 7 +- xml/schema/Case/CaseContact.xml | 2 +- xml/schema/Contact/Household.xml | 2 +- xml/schema/Contact/Individual.xml | 10 +- xml/schema/Contact/Organization.xml | 2 +- xml/schema/Contact/Relationship.xml | 8 +- xml/schema/Contribute/ContributionProduct.xml | 154 +++++------ xml/schema/Contribute/ContributionSoft.xml | 124 ++++----- xml/schema/Contribute/Premium.xml | 98 +++---- xml/schema/Contribute/PremiumsProduct.xml | 128 ++++----- xml/schema/Contribute/Product.xml | 158 +++++------ xml/schema/Contribute/Widget.xml | 20 +- xml/schema/Core/ActionSchedule.xml | 32 +-- xml/schema/Core/Address.xml | 2 +- xml/schema/Core/CustomGroup.xml | 8 +- xml/schema/Core/Discount.xml | 2 +- xml/schema/Core/Domain.xml | 12 +- xml/schema/Core/EntityTag.xml | 2 +- xml/schema/Core/IM.xml | 2 +- xml/schema/Core/JobLog.xml | 4 +- xml/schema/Core/LocBlock.xml | 96 +++---- xml/schema/Core/MappingField.xml | 16 +- xml/schema/Core/MessageTemplates.xml | 8 +- xml/schema/Core/Phone.xml | 4 +- xml/schema/Core/UFGroup.xml | 16 +- xml/schema/Core/UFJoin.xml | 78 +++--- xml/schema/Core/UFMatch.xml | 2 +- xml/schema/Core/Website.xml | 2 +- xml/schema/Dedupe/Exception.xml | 44 +-- xml/schema/Event/EventPage.xml | 252 +++++++++--------- xml/schema/Event/Participant.xml | 202 +++++++------- xml/schema/Event/ParticipantPayment.xml | 80 +++--- .../Financial/EntityFinancialAccount.xml | 70 ++--- xml/schema/Financial/EntityFinancialTrxn.xml | 82 +++--- xml/schema/Financial/FinancialAccount.xml | 96 +++---- xml/schema/Financial/FinancialItem.xml | 58 ++-- xml/schema/Financial/FinancialType.xml | 40 +-- xml/schema/Financial/OfficialReceipt.xml | 144 +++++----- xml/schema/Financial/PaymentProcessor.xml | 6 +- xml/schema/Friend/Friend.xml | 102 +++---- xml/schema/GccSchema.xml | 14 +- xml/schema/Mailing/Mailing.xml | 58 ++-- xml/schema/Member/Membership.xml | 120 ++++----- xml/schema/Member/MembershipBlock.xml | 96 +++---- xml/schema/Member/MembershipLog.xml | 46 ++-- xml/schema/Member/MembershipPayment.xml | 20 +- xml/schema/Member/MembershipStatus.xml | 100 +++---- xml/schema/Member/MembershipType.xml | 134 +++++----- xml/schema/PCP/PCP.xml | 182 ++++++------- xml/schema/PCP/PCPBlock.xml | 70 ++--- xml/schema/Pledge/Pledge.xml | 114 ++++---- xml/schema/Pledge/PledgeBlock.xml | 6 +- xml/schema/Pledge/PledgePayment.xml | 32 +-- xml/schema/Price/Field.xml | 2 +- xml/schema/QuestSchema.xml | 16 +- xml/schema/Queue/QueueItem.xml | 4 +- 63 files changed, 1640 insertions(+), 1641 deletions(-) diff --git a/xml/schema/Activity/ActivityAssignment.xml b/xml/schema/Activity/ActivityAssignment.xml index a60ddab71e..a8f3a17a4b 100644 --- a/xml/schema/Activity/ActivityAssignment.xml +++ b/xml/schema/Activity/ActivityAssignment.xml @@ -19,10 +19,10 @@ true - + activity_entity_table varchar - 64 + 64 true Name of table where item being referenced is stored (activity, phonecall or meeting). 1.8 @@ -35,43 +35,43 @@ true Entity (activity, phonecall or meeting) id for which the assigment is created 1.8 - 2.0 + 2.0 activity_entity_id activity_entity_table 1.8 - 2.0 + 2.0 - + target_entity_table varchar - 64 + 64 true Name of table where item being referenced is stored (contact assigned to given activity). 1.8 - 2.0 + 2.0 - + target_entity_id int unsigned true Foreign key to the referenced item. 1.1 - 2.0 + 2.0 target_entity_id target_entity_table 1.8 - 2.0 + 2.0 - + activity_id int unsigned Activity ID @@ -87,7 +87,7 @@ CASCADE - + assignee_contact_id int unsigned Assignee Contact ID @@ -106,7 +106,7 @@ UI_activity_assignee_contact_id assignee_contact_id - activity_id + activity_id true 2.0 diff --git a/xml/schema/Bridge/OG.xml b/xml/schema/Bridge/OG.xml index c1a171e2af..5e335c68d5 100644 --- a/xml/schema/Bridge/OG.xml +++ b/xml/schema/Bridge/OG.xml @@ -64,7 +64,7 @@ int unsigned true FK to admin civicrm group. - 2.0 + 2.0 civicrm_group
id diff --git a/xml/schema/Bridge/Role.xml b/xml/schema/Bridge/Role.xml index 948c53982c..99586735a0 100644 --- a/xml/schema/Bridge/Role.xml +++ b/xml/schema/Bridge/Role.xml @@ -17,18 +17,18 @@ 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 int unsigned true @@ -39,11 +39,11 @@ id title - - - group_id - civicrm_group
- id - 2.0 - + + + group_id + civicrm_group
+ id + 2.0 + diff --git a/xml/schema/Campaign/Campaign.xml b/xml/schema/Campaign/Campaign.xml index adbdc24ef4..1efdad9d10 100644 --- a/xml/schema/Campaign/Campaign.xml +++ b/xml/schema/Campaign/Campaign.xml @@ -77,13 +77,13 @@ Campaign Type ID int unsigned NULL - Campaign Type ID.Implicit FK to civicrm_option_value where option_group = campaign_type + Campaign Type ID.Implicit FK to civicrm_option_value where option_group = campaign_type true campaign_type - 3.3 - + 3.3 + UI_campaign_type_id campaign_type_id @@ -100,7 +100,7 @@ campaign_status - 3.3 + 3.3 UI_campaign_status_id diff --git a/xml/schema/Campaign/CampaignGroup.xml b/xml/schema/Campaign/CampaignGroup.xml index 04de043b7b..b8cd70bd45 100644 --- a/xml/schema/Campaign/CampaignGroup.xml +++ b/xml/schema/Campaign/CampaignGroup.xml @@ -5,7 +5,7 @@ civicrm_campaign_group Campaign Group Details. 3.3 - + id int unsigned @@ -17,7 +17,7 @@ id true - + campaign_id int unsigned @@ -41,10 +41,10 @@ Type of Group. - + entity_table varchar - 64 + 64 NULL Name of table where item being referenced is stored. 3.3 diff --git a/xml/schema/Campaign/Survey.xml b/xml/schema/Campaign/Survey.xml index 683fee058d..bba9a69519 100644 --- a/xml/schema/Campaign/Survey.xml +++ b/xml/schema/Campaign/Survey.xml @@ -49,7 +49,7 @@ Activity Type ID int unsigned NULL - Implicit FK to civicrm_option_value where option_group = activity_type + Implicit FK to civicrm_option_value where option_group = activity_type true 3.3 diff --git a/xml/schema/Case/Case.xml b/xml/schema/Case/Case.xml index 1e8907dc08..27d6e45130 100644 --- a/xml/schema/Case/Case.xml +++ b/xml/schema/Case/Case.xml @@ -11,7 +11,7 @@ int unsigned case_id true - true + true Case ID Unique Case ID 1.8 @@ -34,9 +34,9 @@ civicrm_contact
id 1.8 - 2.1 + 2.1 CASCADE - + case_type_id varchar @@ -78,7 +78,7 @@ true Id of second case category. 1.8 - 2.0 + 2.0 index_casetag2_id @@ -124,7 +124,7 @@ end_date case_end_date Case End Date - true + true date Date on which given case ends. 1.8 @@ -166,5 +166,5 @@ index_is_deleted is_deleted 2.2 - + diff --git a/xml/schema/Case/CaseActivity.xml b/xml/schema/Case/CaseActivity.xml index 562fa5f2d0..d840664d04 100644 --- a/xml/schema/Case/CaseActivity.xml +++ b/xml/schema/Case/CaseActivity.xml @@ -51,9 +51,8 @@ activity_id 2.0 - - + activity_entity_table varchar 64 @@ -64,12 +63,12 @@ - activity_entity_id + activity_entity_id int unsigned true Entity (activity, phonecall or meeting) id for which the assigment is created 1.8 - 2.0 + 2.0 diff --git a/xml/schema/Case/CaseContact.xml b/xml/schema/Case/CaseContact.xml index 9ddd99b186..b454e4e101 100644 --- a/xml/schema/Case/CaseContact.xml +++ b/xml/schema/Case/CaseContact.xml @@ -45,7 +45,7 @@ id 2.1 CASCADE - + UI_case_contact_id case_id diff --git a/xml/schema/Contact/Household.xml b/xml/schema/Contact/Household.xml index 51834a7db4..827312783a 100644 --- a/xml/schema/Contact/Household.xml +++ b/xml/schema/Contact/Household.xml @@ -44,7 +44,7 @@ index_household_name - household_name + household_name 1.8 diff --git a/xml/schema/Contact/Individual.xml b/xml/schema/Contact/Individual.xml index c8d342fb27..c361dc46ce 100644 --- a/xml/schema/Contact/Individual.xml +++ b/xml/schema/Contact/Individual.xml @@ -44,7 +44,7 @@ index_first_name - first_name + first_name 1.8 @@ -71,7 +71,7 @@ index_last_name - last_name + last_name 1.8 @@ -92,7 +92,7 @@ UI_prefix - prefix_id + prefix_id 1.6 @@ -105,7 +105,7 @@ UI_suffix - suffix_id + suffix_id 1.6 @@ -167,7 +167,7 @@ UI_gender - gender_id + gender_id 1.6 diff --git a/xml/schema/Contact/Organization.xml b/xml/schema/Contact/Organization.xml index 282684782b..c5836fb0fe 100644 --- a/xml/schema/Contact/Organization.xml +++ b/xml/schema/Contact/Organization.xml @@ -44,7 +44,7 @@ index_organization_name - organization_name + organization_name 1.8 diff --git a/xml/schema/Contact/Relationship.xml b/xml/schema/Contact/Relationship.xml index 0016ec9fef..7a20ad673f 100644 --- a/xml/schema/Contact/Relationship.xml +++ b/xml/schema/Contact/Relationship.xml @@ -120,10 +120,10 @@ FK to civicrm_case 2.2 - - case_id - civicrm_case
- id + + case_id + civicrm_case
+ id 2.2 CASCADE diff --git a/xml/schema/Contribute/ContributionProduct.xml b/xml/schema/Contribute/ContributionProduct.xml index 7e70efa67a..ec7525061d 100644 --- a/xml/schema/Contribute/ContributionProduct.xml +++ b/xml/schema/Contribute/ContributionProduct.xml @@ -1,110 +1,110 @@ - + - - CRM/Contribute - ContributionProduct - civicrm_contribution_product - 1.4 +
+ CRM/Contribute + ContributionProduct + civicrm_contribution_product + 1.4true - - id - int unsigned - true - 1.4 - - - id - true - - - product_id + + id int unsigned - true - 1.4 - - - contribution_id - int unsigned - true - 1.4 - - - contribution_id -
civicrm_contribution
- id - 1.4 + true + 1.4 + + + id + true + + + product_id + int unsigned + true + 1.4 + + + contribution_id + int unsigned + true + 1.4 + + + contribution_id + civicrm_contribution
+ id + 1.4 CASCADE - - - product_option + + + product_option Product Option - varchar + varchar 255 true - Option value selected if applicable - e.g. color, size etc. - 1.4 - - - quantity + Option value selected if applicable - e.g. color, size etc. + 1.4 + + + quantity Quantity int 1 true - - 1.4 - - - total_cost - decimal + + 1.4 + + + total_cost + decimal true true /^total|(.?^am(ou)?nt)/i /^\d+(\.\d{2})?$/ - quantity X civicrm_product.cost. - 1.3 + quantity X civicrm_product.cost. + 1.3 4.1 - - fulfilled_date + + fulfilled_date date true - Optional. Can be used to record the date this product was fulfilled or shipped. - 1.4 - - - start_date + Optional. Can be used to record the date this product was fulfilled or shipped. + 1.4 + + + start_date contribution_start_date - date + date true - Actual start date for a time-delimited premium (subscription, service or membership) - 1.4 + Actual start date for a time-delimited premium (subscription, service or membership) + 1.4 - - end_date + + end_date contribution_end_date date true - Actual end date for a time-delimited premium (subscription, service or membership) - 1.4 + Actual end date for a time-delimited premium (subscription, service or membership) + 1.4 - - comment - text - 1.4 + + comment + text + 1.4 - - financial_type_id + + financial_type_id Financial Type - int unsigned + int unsigned NULL FK to Financial Type(for membership price sets only). - 4.3 - - - financial_type_id - civicrm_financial_type
- id + 4.3 + + + financial_type_id + civicrm_financial_type
+ id SET NULL 4.3 - + diff --git a/xml/schema/Contribute/ContributionSoft.xml b/xml/schema/Contribute/ContributionSoft.xml index 9c4c4728de..36c68bb1ca 100644 --- a/xml/schema/Contribute/ContributionSoft.xml +++ b/xml/schema/Contribute/ContributionSoft.xml @@ -1,66 +1,66 @@ - - - - CRM/Contribute - ContributionSoft - civicrm_contribution_soft - 2.2 + + +
+ CRM/Contribute + ContributionSoft + civicrm_contribution_soft + 2.2true - - id + + id contribution_soft_id - int unsigned + int unsigned true - true + true Soft Contribution ID - Soft Contribution ID - 2.2 - - - id - true - - - contribution_id - int unsigned - true - FK to contribution table. - 2.2 - - - contribution_id -
civicrm_contribution
- id - 2.2 + Soft Contribution ID + 2.2 + + + id + true + + + contribution_id + int unsigned + true + FK to contribution table. + 2.2 + + + contribution_id + civicrm_contribution
+ id + 2.2 CASCADE - - contact_id + + contact_id contribution_soft_contact_id Contact ID - int unsigned - true + int unsigned + true true /contact(.?id)?/i /^\d+$/ - FK to Contact ID - 2.2 - - - contact_id - civicrm_contact
- id - 2.2 + FK to Contact ID + 2.2 + + + contact_id + civicrm_contact
+ id + 2.2 CASCADE - - - amount - decimal + + + amount + decimal true true /total(.?am(ou)?nt)?/i /^\d+(\.\d{2})?$/ - Amount of this soft contribution. + Amount of this soft contribution. 2.2 @@ -77,18 +77,18 @@ numeric_code - - pcp_id - int unsigned + + pcp_id + int unsigned NULL - FK to civicrm_pcp.id - 2.2 - + FK to civicrm_pcp.id + 2.2 + - pcp_id - civicrm_pcp
- id - 3.1 + pcp_id + civicrm_pcp
+ id + 3.1 SET NULL @@ -96,12 +96,12 @@ pcp_id 2.2 - - pcp_display_in_roll - boolean + + pcp_display_in_roll + boolean 0 - 2.2 - + 2.2 + pcp_roll_nickname varchar diff --git a/xml/schema/Contribute/Premium.xml b/xml/schema/Contribute/Premium.xml index 0d7e215514..b5c5b980de 100644 --- a/xml/schema/Contribute/Premium.xml +++ b/xml/schema/Contribute/Premium.xml @@ -1,22 +1,22 @@ - - - - CRM/Contribute + + +
+ CRM/ContributePremiumtable - settings for the Premiums features for a given contribution page - civicrm_premiums - 1.4 + civicrm_premiums + 1.4true - - id - int unsigned - true - 1.4 - - - id - true - + + id + int unsigned + true + 1.4 + + + id + true + entity_table varchar @@ -36,60 +36,60 @@ entity_table 1.4 - - premiums_active - boolean + + premiums_active + boolean 0 true Is the Premiums feature enabled for this page? - 1.4 - - - premiums_intro_title + 1.4 + + + premiums_intro_title varchar Title for Premiums section 255 true - Title for Premiums section. - 1.4 - - - premiums_intro_text - text + Title for Premiums section. + 1.4 + + + premiums_intro_text + text true - Displayed in <div> at top of Premiums section of page. Text and HTML allowed. - 1.4 - - + Displayed in <div> at top of Premiums section of page. Text and HTML allowed. + 1.4 + + premiums_contact_email - varchar + varchar 100 - This email address is included in receipts if it is populated and a premium has been selected. - 1.4 - - - premiums_contact_phone + This email address is included in receipts if it is populated and a premium has been selected. + 1.4 + + + premiums_contact_phone Premiums Contact Phone - varchar + varchar 50 - This phone number is included in receipts if it is populated and a premium has been selected. - 1.4 + This phone number is included in receipts if it is populated and a premium has been selected. + 1.4 - - premiums_display_min_contribution - boolean + + premiums_display_min_contribution + boolean true - Boolean. Should we automatically display minimum contribution amount text after the premium descriptions. - 1.4 + Boolean. Should we automatically display minimum contribution amount text after the premium descriptions. + 1.4 premiums_nothankyou_label No Thank-you Text varchar - 255 + 255 true Label displayed for No Thank-you option in premiums block (e.g. No thank you) - 4.3 + 4.3 premiums_nothankyou_position diff --git a/xml/schema/Contribute/PremiumsProduct.xml b/xml/schema/Contribute/PremiumsProduct.xml index d96a5fc706..255fc29b1b 100644 --- a/xml/schema/Contribute/PremiumsProduct.xml +++ b/xml/schema/Contribute/PremiumsProduct.xml @@ -1,77 +1,77 @@ - + -
- CRM/Contribute - PremiumsProduct +
+ CRM/Contribute + PremiumsProductcivicrm_premiums_productjoins premiums (settings) to individual product/premium items - determines which products are available for a given contribution page - 1.4 + 1.4true - - id - int unsigned - true - Contribution ID - 1.4 - - - id - true - - - premiums_id - int unsigned - true - Foreign key to premiums settings record. - 1.4 - - - premiums_id -
civicrm_premiums
- id - 1.4 - - - product_id - int unsigned - true - Foreign key to each product object. - 1.4 - - - product_id - civicrm_product
- id - 1.4 - - - sort_position + + id + int unsigned + true + Contribution ID + 1.4 + + + id + true + + + premiums_id + int unsigned + true + Foreign key to premiums settings record. + 1.4 + + + premiums_id + civicrm_premiums
+ id + 1.4 + + + product_id + int unsigned + true + Foreign key to each product object. + 1.4 + + + product_id + civicrm_product
+ id + 1.4 + + + sort_position Sort Position - int unsigned - true - 1.4 + int unsigned + true + 1.4 2.0 - - - weight + + + weight Weight - int unsigned - true - 2.0 - - - financial_type_id + int unsigned + true + 2.0 + + + financial_type_id Financial Type - int unsigned + int unsigned NULL FK to Financial Type. - 4.3 - - - financial_type_id - civicrm_financial_type
- id + 4.3 + + + financial_type_id + civicrm_financial_type
+ id SET NULL 4.3 - + diff --git a/xml/schema/Contribute/Product.xml b/xml/schema/Contribute/Product.xml index f0261dd965..b3b344575c 100644 --- a/xml/schema/Contribute/Product.xml +++ b/xml/schema/Contribute/Product.xml @@ -1,21 +1,21 @@ - - - - CRM/Contribute + + +
+ CRM/ContributeProductable - stores "product info" for premiums and can be used for non-incentive products - civicrm_product - 1.4 + civicrm_product + 1.4true - - id - int unsigned - true - 1.4 - - - id - true + + id + int unsigned + true + 1.4 + + + id + true name @@ -37,45 +37,45 @@ Optional description of the product/premium. 1.4 - - sku + + sku SKU varchar 50 - true + true Optional product sku or code. - 1.4 - - - options + 1.4 + + + options Options text true - Store comma-delimited list of color, size, etc. options for the product. - 1.4 - - + Store comma-delimited list of color, size, etc. options for the product. + 1.4 + + image Image - varchar + varchar 255 - Full or relative URL to uploaded image - fullsize. - 1.4 - - + Full or relative URL to uploaded image - fullsize. + 1.4 + + thumbnail Thumbnail - varchar + varchar 255 - Full or relative URL to image thumbnail. - 1.4 - - - price + Full or relative URL to image thumbnail. + 1.4 + + + price Price - decimal - Sell price or market value for premiums. For tax-deductible contributions, this will be stored as non_deductible_amount in the contribution record. - 1.4 + decimal + Sell price or market value for premiums. For tax-deductible contributions, this will be stored as non_deductible_amount in the contribution record. + 1.4 currency @@ -91,91 +91,91 @@ numeric_code - - financial_type_id + + financial_type_id Financial Type - int unsigned + int unsigned NULL FK to Financial Type. - 4.3 - - - financial_type_id -
civicrm_financial_type
- id + 4.3 + + + financial_type_id + civicrm_financial_type
+ id SET NULL 4.3 - - - + + + min_contribution Minimum Contribution decimal - Minimum contribution required to be eligible to select this premium. - 1.4 + Minimum contribution required to be eligible to select this premium. + 1.4 - + cost Cost - decimal - Actual cost of this product. Useful to determine net return from sale or using this as an incentive. - 1.4 + decimal + Actual cost of this product. Useful to determine net return from sale or using this as an incentive. + 1.4 - + is_active Is Active - boolean - true - Disabling premium removes it from the premiums_premium join table below. - 1.4 + boolean + true + Disabling premium removes it from the premiums_premium join table below. + 1.4 - + period_type Period Type enum rolling,fixed 'rolling' Rolling means we set start/end based on current day, fixed means we set start/end for current year or month -(e.g. 1 year + fixed -> we would set start/end for 1/1/06 thru 12/31/06 for any premium chosen in 2006) - 1.4 +(e.g. 1 year + fixed -> we would set start/end for 1/1/06 thru 12/31/06 for any premium chosen in 2006) + 1.4 - + fixed_period_start_day Fixed Period Start Day int 0101 - Month and day (MMDD) that fixed period type subscription or membership starts. - 1.4 + Month and day (MMDD) that fixed period type subscription or membership starts. + 1.4 - + duration_unit Duration Unit enum day,month,week,year 'year' - 1.4 + 1.4 - + duration_interval Duration Interval int - Number of units for total duration of subscription, service, membership (e.g. 12 Months). - 1.4 + Number of units for total duration of subscription, service, membership (e.g. 12 Months). + 1.4 - + frequency_unit Frequency Unit enum day,month,week,year 'month' Frequency unit and interval allow option to store actual delivery frequency for a subscription or service. - 1.4 + 1.4 - + frequency_interval Frequency Interval int - Number of units for delivery frequency of subscription, service, membership (e.g. every 3 Months). - 1.4 + Number of units for delivery frequency of subscription, service, membership (e.g. every 3 Months). + 1.4 diff --git a/xml/schema/Contribute/Widget.xml b/xml/schema/Contribute/Widget.xml index c6ec71b7ec..bee97aa250 100644 --- a/xml/schema/Contribute/Widget.xml +++ b/xml/schema/Contribute/Widget.xml @@ -18,16 +18,16 @@ id true - - contribution_page_id - int unsigned - The Contribution Page which triggered this contribution - 1.5 - - - contribution_page_id - civicrm_contribution_page
- id + + contribution_page_id + int unsigned + The Contribution Page which triggered this contribution + 1.5 + + + contribution_page_id + civicrm_contribution_page
+ id CASCADE diff --git a/xml/schema/Core/ActionSchedule.xml b/xml/schema/Core/ActionSchedule.xml index d1462b02cd..fa6bf4b7f9 100644 --- a/xml/schema/Core/ActionSchedule.xml +++ b/xml/schema/Core/ActionSchedule.xml @@ -68,7 +68,7 @@ start_action_unit - enum + enum hour,day,week,month,year Time units for reminder. 3.4 @@ -96,7 +96,7 @@ repetition_frequency_unit - enum + enum hour,day,week,month,year Time units for repetition of reminder. 3.4 @@ -109,7 +109,7 @@ end_frequency_unit - enum + enum hour,day,week,month,year Time units till repetition of reminder. 3.4 @@ -141,21 +141,21 @@ Is this option active? 3.4 - - recipient_manual + + recipient_manual Recipient Manual - varchar - 128 - Contact IDs to which reminder should be sent. - 3.4 + varchar + 128 + Contact IDs to which reminder should be sent. + 3.4 - - recipient_listing + + recipient_listing Recipient Listing - varchar - 128 - listing based on recipient field. - 4.1 + varchar + 128 + listing based on recipient field. + 4.1 body_text @@ -194,7 +194,7 @@ civicrm_action_mapping
id SET NULL - + group_id int unsigned diff --git a/xml/schema/Core/Address.xml b/xml/schema/Core/Address.xml index 3825c46779..2c23ac7a66 100644 --- a/xml/schema/Core/Address.xml +++ b/xml/schema/Core/Address.xml @@ -239,7 +239,7 @@ /\d?\d{4}(-\d{4})?/ Store the suffix, like the +4 part in the USPS system. 1.1 - + postal_code Postal Code diff --git a/xml/schema/Core/CustomGroup.xml b/xml/schema/Core/CustomGroup.xml index 517a1adc61..2aa872f5c1 100644 --- a/xml/schema/Core/CustomGroup.xml +++ b/xml/schema/Core/CustomGroup.xml @@ -64,7 +64,7 @@ linking custom group for dynamic object 1.6 - + style enum @@ -179,13 +179,13 @@ Date and time this custom group was created. 3.0 - + is_reserved boolean 0 Is this a reserved Custom Group? - 4.4 - + 4.4 + diff --git a/xml/schema/Core/Discount.xml b/xml/schema/Core/Discount.xml index 7596da2185..12b370e530 100644 --- a/xml/schema/Core/Discount.xml +++ b/xml/schema/Core/Discount.xml @@ -44,7 +44,7 @@ option_group_id - participant_discount_name + participant_discount_name Discount Name int unsigned true diff --git a/xml/schema/Core/Domain.xml b/xml/schema/Core/Domain.xml index 158f50a99a..64a2e35938 100644 --- a/xml/schema/Core/Domain.xml +++ b/xml/schema/Core/Domain.xml @@ -106,12 +106,12 @@ FK to Contact ID. This is specifically not an FK to avoid circular constraints 4.3 - - contact_id - civicrm_contact
- id - 4.3 - + + contact_id + civicrm_contact
+ id + 4.3 + locales text diff --git a/xml/schema/Core/EntityTag.xml b/xml/schema/Core/EntityTag.xml index 89ff9eb2ca..bc1e2529f2 100644 --- a/xml/schema/Core/EntityTag.xml +++ b/xml/schema/Core/EntityTag.xml @@ -61,7 +61,7 @@ entity_id 3.2 3.4 - + tag_id int unsigned diff --git a/xml/schema/Core/IM.xml b/xml/schema/Core/IM.xml index 8b7f585a3e..fbe0805d25 100644 --- a/xml/schema/Core/IM.xml +++ b/xml/schema/Core/IM.xml @@ -66,7 +66,7 @@ UI_provider_id - provider_id + provider_id 1.6 diff --git a/xml/schema/Core/JobLog.xml b/xml/schema/Core/JobLog.xml index c79eb49c69..5c3d57bcf9 100644 --- a/xml/schema/Core/JobLog.xml +++ b/xml/schema/Core/JobLog.xml @@ -30,7 +30,7 @@ civicrm_domain
id 4.1 - + run_time timestamp @@ -69,5 +69,5 @@ text Potential extended data for specific job run (e.g. tracebacks). 4.1 - + diff --git a/xml/schema/Core/LocBlock.xml b/xml/schema/Core/LocBlock.xml index d33d404f38..740875bd71 100644 --- a/xml/schema/Core/LocBlock.xml +++ b/xml/schema/Core/LocBlock.xml @@ -23,95 +23,95 @@ int unsigned 2.0 - - address_id - civicrm_address
- id - 2.0 + + address_id + civicrm_address
+ id + 2.0 SET NULL - + email_id int unsigned 2.0 - - email_id - civicrm_email
- id - 2.0 + + email_id + civicrm_email
+ id + 2.0 SET NULL - + phone_id int unsigned 2.0 - - phone_id - civicrm_phone
- id - 2.0 + + phone_id + civicrm_phone
+ id + 2.0 SET NULL - + im_id int unsigned 2.0 - - im_id - civicrm_im
- id - 2.0 + + im_id + civicrm_im
+ id + 2.0 SET NULL - + address_2_id int unsigned 2.0 - - address_2_id - civicrm_address
- id - 2.0 + + address_2_id + civicrm_address
+ id + 2.0 SET NULL - + email_2_id int unsigned 2.0 - - email_2_id - civicrm_email
- id - 2.0 + + email_2_id + civicrm_email
+ id + 2.0 SET NULL - + phone_2_id int unsigned 2.0 - - phone_2_id - civicrm_phone
- id - 2.0 + + phone_2_id + civicrm_phone
+ id + 2.0 SET NULL - + im_2_id int unsigned 2.0 - - im_2_id - civicrm_im
- id - 2.0 + + im_2_id + civicrm_im
+ id + 2.0 SET NULL - + diff --git a/xml/schema/Core/MappingField.xml b/xml/schema/Core/MappingField.xml index fbae7d3d50..21882a9ee4 100644 --- a/xml/schema/Core/MappingField.xml +++ b/xml/schema/Core/MappingField.xml @@ -82,7 +82,7 @@ int unsigned Which type of phone does this number belongs. 2.2 - + im_provider_id int unsigned @@ -100,7 +100,7 @@ website_type - + relationship_type_id int unsigned @@ -113,12 +113,12 @@ id 1.2 - - relationship_direction - varchar - 6 - 1.7 - + + relationship_direction + varchar + 6 + 1.7 + grouping int unsigned diff --git a/xml/schema/Core/MessageTemplates.xml b/xml/schema/Core/MessageTemplates.xml index 4ec80ad230..04cbcefe4a 100644 --- a/xml/schema/Core/MessageTemplates.xml +++ b/xml/schema/Core/MessageTemplates.xml @@ -49,13 +49,13 @@ 1.6 - - is_active + + is_active Is Active boolean 1 - 1.6 - + 1.6 + workflow_id int unsigned diff --git a/xml/schema/Core/Phone.xml b/xml/schema/Core/Phone.xml index 66ce945384..11b3a078d4 100644 --- a/xml/schema/Core/Phone.xml +++ b/xml/schema/Core/Phone.xml @@ -81,7 +81,7 @@ UI_mobile_provider_id - mobile_provider_id + mobile_provider_id 1.6 @@ -138,5 +138,5 @@ phone_type 2.2 - + diff --git a/xml/schema/Core/UFGroup.xml b/xml/schema/Core/UFGroup.xml index 237ffcbf6f..2c2c34d0e2 100644 --- a/xml/schema/Core/UFGroup.xml +++ b/xml/schema/Core/UFGroup.xml @@ -106,15 +106,15 @@ Redirect to URL. 1.4 - - add_to_group_id - int unsigned - foreign key to civicrm_group_id - + + add_to_group_id + int unsigned + foreign key to civicrm_group_id + - add_to_group_id - civicrm_group
- id + add_to_group_id + civicrm_group
+ id SET NULL diff --git a/xml/schema/Core/UFJoin.xml b/xml/schema/Core/UFJoin.xml index 0af165a9d6..f8cace84bd 100644 --- a/xml/schema/Core/UFJoin.xml +++ b/xml/schema/Core/UFJoin.xml @@ -25,38 +25,38 @@ Is this join currently active? 1.3 - - module - varchar - 64 - true - Module which owns this uf_join instance, e.g. User Registration, CiviDonate, etc. - 1.3 - - - 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 - int unsigned - Foreign key to the referenced item. - 1.3 + + module + varchar + 64 + true + Module which owns this uf_join instance, e.g. User Registration, CiviDonate, etc. + 1.3 + + + 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 + int unsigned + Foreign key to the referenced item. + 1.3 entity_id entity_table - 1.3 + 1.3 - - index_entity - 1.3 - entity_table - entity_id - 1.3 + + index_entity + 1.3 + entity_table + entity_id + 1.3 weight @@ -66,22 +66,22 @@ Controls display order when multiple user framework groups are setup for concurrent display. 1.3 - - uf_group_id - int unsigned - true - Which form does this field belong to. + + uf_group_id + int unsigned + true + Which form does this field belong to. 1.3 civicrm_uf_group
id title - - - uf_group_id - civicrm_uf_group
- id - 1.3 - + + + uf_group_id + civicrm_uf_group
+ id + 1.3 + diff --git a/xml/schema/Core/UFMatch.xml b/xml/schema/Core/UFMatch.xml index b90b91c4ae..3ecebaa755 100644 --- a/xml/schema/Core/UFMatch.xml +++ b/xml/schema/Core/UFMatch.xml @@ -30,7 +30,7 @@ civicrm_domain
id 3.0 - + uf_id int unsigned diff --git a/xml/schema/Core/Website.xml b/xml/schema/Core/Website.xml index 0305638e4c..ab79cfe66b 100644 --- a/xml/schema/Core/Website.xml +++ b/xml/schema/Core/Website.xml @@ -54,7 +54,7 @@ UI_website_type_id - website_type_id + website_type_id 3.2 diff --git a/xml/schema/Dedupe/Exception.xml b/xml/schema/Dedupe/Exception.xml index 6613a2e8fb..f5f095cdc8 100644 --- a/xml/schema/Dedupe/Exception.xml +++ b/xml/schema/Dedupe/Exception.xml @@ -16,32 +16,32 @@ id true - - contact_id1 + + contact_id1 First Dupe Contact ID - int unsigned - FK to Contact ID - 3.3 - - - contact_id1 - civicrm_contact
- id - 3.3 + int unsigned + FK to Contact ID + 3.3 + + + contact_id1 + civicrm_contact
+ id + 3.3 CASCADE - - contact_id2 + + contact_id2 Second Dupe Contact ID - int unsigned - FK to Contact ID - 3.3 - - - contact_id2 - civicrm_contact
- id - 3.3 + int unsigned + FK to Contact ID + 3.3 + + + contact_id2 + civicrm_contact
+ id + 3.3 CASCADE diff --git a/xml/schema/Event/EventPage.xml b/xml/schema/Event/EventPage.xml index 449e8ee7ab..adcb2fdd03 100644 --- a/xml/schema/Event/EventPage.xml +++ b/xml/schema/Event/EventPage.xml @@ -1,138 +1,138 @@ - - - - CRM/Event - EventPage - civicrm_event_page - 1.7 - - id - int unsigned - true - Event Page ID - 1.7 - - - id - true - - - event_id + + +
+ CRM/Event + EventPage + civicrm_event_page + 1.7 + + id + int unsigned + true + Event Page ID + 1.7 + + + id + true + + + event_id Event ID - int unsigned - true - Event which this page belongs to. - 1.7 - - - event_id -
civicrm_event
- id + int unsigned + true + Event which this page belongs to. + 1.7 + + + event_id + civicrm_event
+ id CASCADE - - intro_text - text + + 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 + 1.7 + + + footer_text Footer Message - text + 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 + 1.7 + + + confirm_title + varchar Confirmation Title - 255 + 255 NULL true Title for Confirmation page. - 1.7 - - - confirm_text - text + 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 + 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 + 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 + 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 + 1.7 + + + confirm_from_name + varchar Confirm From Name - 255 + 255 true FROM email name used for confirmation emails. - 1.7 + 1.7 - - confirm_from_email - varchar + + confirm_from_email + varchar Confirm From Email - 255 + 255 FROM email address used for confirmation emails. - 1.7 - - - cc_confirm - varchar - 255 + 1.7 + + + cc_confirm + varchar + 255 comma-separated list of email addresses to cc each time a confirmation is sent - 1.7 + 1.7 - - bcc_confirm - varchar - 255 + + bcc_confirm + varchar + 255 comma-separated list of email addresses to bcc each time a confirmation is sent - 1.7 + 1.7 default_fee_id @@ -146,64 +146,64 @@ FK to civicrm_option_value. 1.7 - - thankyou_title - varchar + + thankyou_title + varchar ThankYou Title - 255 + 255 NULL true Title for ThankYou page. - 1.7 - - - thankyou_text - text + 1.7 + + + thankyou_text + text textarea 6 50 ThankYou Text true ThankYou Text. - 1.7 - - - thankyou_footer_text - 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 + 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 + The text displayed to the user in the main form + 2.0 - - pay_later_receipt - text + + pay_later_receipt + text true - The receipt sent to the user instead of the normal receipt text - 2.0 + The receipt sent to the user instead of the normal receipt text + 2.0 - - is_multiple_registrations + + is_multiple_registrations boolean - 0 - if true - allows the user to register multiple participants for event - 2.1 + 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 c4a4aa868f..c5a9f54c35 100644 --- a/xml/schema/Event/Participant.xml +++ b/xml/schema/Event/Participant.xml @@ -1,71 +1,71 @@ - - - - CRM/Event - Participant - civicrm_participant - 1.7 + + +
+ CRM/Event + Participant + civicrm_participant + 1.7true - - id - participant_id + + id + participant_id Participant ID - int unsigned - true - Participant Id + int unsigned + true + Participant Id true /(^(participant(.)?)?id$)/i - 1.7 - - - id - true - - + 1.7 + + + id + true + + contact_id - participant_contact_id - int unsigned + participant_contact_id + int unsigned Contact ID /contact(.?id)?/i true 0 - FK to Contact ID - 1.7 + FK to Contact ID + 1.7 - - contact_id -
civicrm_contact
- id + + contact_id + civicrm_contact
+ id CASCADE - - event_id - int unsigned + + event_id + int unsigned Event true /event id$/i 0 - FK to Event ID - 1.7 + FK to Event ID + 1.7 - - event_id - civicrm_event
- id + + event_id + civicrm_event
+ id CASCADE - - status_id + + status_id participant_status_id Participant Status Id /(participant.)?(status)$/i true int unsigned false - true + true 1 Participant status ID. FK to civicrm_participant_status_type. Default of 1 should map to status = Registered. - 1.7 + 1.7 civicrm_participant_status_type
id @@ -83,8 +83,8 @@ status_id 1.8 - - role_id + + role_id participant_role_id Participant Role Id @@ -92,70 +92,70 @@ /(participant.)?(role)$/i true - varchar - 128 + varchar + 128 false NULL - Participant role ID. Implicit FK to civicrm_option_value where option_group = participant_role. - 1.7 + Participant role ID. Implicit FK to civicrm_option_value where option_group = participant_role. + 1.7 index_role_id role_id 1.8 - + register_date participant_register_date Register date /^(r(egister\s)?date)$/i true - datetime + datetime When did contact register for event? - 1.7 + 1.7 source participant_source - Participant Source + Participant Source /(participant.)?(source)$/i true - varchar - 128 + varchar + 128 Source of this event registration. - 1.7 - - + 1.7 + + fee_level participant_fee_level Fee level /^(f(ee\s)?level)$/i - text + 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 + 1.7 + + + is_test + participant_is_test Test boolean 0 true - 1.7 + 1.7 - - is_pay_later - participant_is_pay_later + + is_pay_later + participant_is_pay_later Is Pay Later boolean 0 true /(is.)?(pay(.)?later)$/i - 2.1 + 2.1 - - + + fee_amount participant_fee_amount Fee Amount @@ -164,43 +164,43 @@ /fee(.?am(ou)?nt)?/i /^\d+(\.\d{2})?$/ actual processor fee if known - may be 0. - 2.1 - - + 2.1 + + registered_by_id - participant_registered_by_id - int unsigned + participant_registered_by_id + int unsigned Registered By ID true NULL - FK to Participant ID - 2.1 + FK to Participant ID + 2.1 true - - registered_by_id - civicrm_participant
- id - 2.1 + + registered_by_id + civicrm_participant
+ id + 2.1 SET NULL - - + + discount_id participant_discount_id - int unsigned + int unsigned Discount ID NULL FK to Discount ID 2.1 - - discount_id - civicrm_discount
- id - 2.1 + + discount_id + civicrm_discount
+ id + 2.1 SET NULL - - + + fee_currency participant_fee_currency Fee Currency @@ -219,19 +219,19 @@ numeric_code - - campaign_id + + campaign_id participant_campaign_id int unsigned Campaign ID - true - The campaign for which this participant has been registered. - 3.4 - - - campaign_id - civicrm_campaign
- id + true + The campaign for which this participant has been registered. + 3.4 + + + campaign_id + civicrm_campaign
+ id SET NULL diff --git a/xml/schema/Event/ParticipantPayment.xml b/xml/schema/Event/ParticipantPayment.xml index ab6eabd256..ecb4df53bf 100644 --- a/xml/schema/Event/ParticipantPayment.xml +++ b/xml/schema/Event/ParticipantPayment.xml @@ -1,49 +1,49 @@ - - - - CRM/Event - ParticipantPayment - civicrm_participant_payment - 1.7 + + +
+ CRM/Event + ParticipantPayment + civicrm_participant_payment + 1.7true - - id + + id Payment ID - int unsigned - true - Participant Payment Id - 1.7 - - - id - true - - - participant_id - Participant ID - int unsigned - true - Participant Id (FK) - 1.7 + int unsigned + true + Participant Payment Id + 1.7 + + + id + true + + + participant_id + Participant ID + int unsigned + true + Participant Id (FK) + 1.7 - - participant_id -
civicrm_participant
- id + + 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 + + contribution_id + civicrm_contribution
+ id + 2.0 CASCADE diff --git a/xml/schema/Financial/EntityFinancialAccount.xml b/xml/schema/Financial/EntityFinancialAccount.xml index e9273bb442..61d2586f77 100755 --- a/xml/schema/Financial/EntityFinancialAccount.xml +++ b/xml/schema/Financial/EntityFinancialAccount.xml @@ -1,36 +1,36 @@ - + - - CRM/Financial - EntityFinancialAccount - civicrm_entity_financial_account +
+ CRM/Financial + EntityFinancialAccount + civicrm_entity_financial_account4.3Map between an entity and a financial account, where there is a specific relationship between the financial account and the entity, e.g. Income Account for or AR Account for - true - - id - int unsigned - true - ID - 4.3 - - - id - true - + true + + id + int unsigned + true + ID + 4.3 + + + id + true + entity_table varchar 64 - true + true true 4.3 Links to an entity_table like civicrm_financial_type - - entity_id - int unsigned - true + + entity_id + int unsigned + true 4.3 Links to an id in the entity_table, such as vid in civicrm_financial_type @@ -39,21 +39,21 @@ entity_table 4.3 - - account_relationship - int unsigned + + account_relationship + int unsigned true - 4.3 + 4.3 FK to a new civicrm_option_value (account_relationship) account_relationship - + - financial_account_id - int unsigned + financial_account_id + int unsigned true - 4.3 + 4.3 FK to the financial_account_id
civicrm_financial_account
@@ -61,11 +61,11 @@ name - - financial_account_id - civicrm_financial_account
- id - 4.3 + + financial_account_id + civicrm_financial_account
+ id + 4.3 RESTRICT diff --git a/xml/schema/Financial/EntityFinancialTrxn.xml b/xml/schema/Financial/EntityFinancialTrxn.xml index 26935a5b8f..a1e92170c6 100755 --- a/xml/schema/Financial/EntityFinancialTrxn.xml +++ b/xml/schema/Financial/EntityFinancialTrxn.xml @@ -1,63 +1,63 @@ - + - - CRM/Financial - EntityFinancialTrxn - civicrm_entity_financial_trxn - 3.2 - - id - int unsigned - true - ID - 3.2 - - - id - true - +
+ CRM/Financial + EntityFinancialTrxn + civicrm_entity_financial_trxn + 3.2 + + id + int unsigned + true + ID + 3.2 + + + id + true + entity_table varchar 64 - true + true true 3.2 May contain civicrm_order, civicrm_order_line_itme, civicrm_order_line_sub_item, civicrm_grant, civicrm_credit_adjustment - - entity_id - int unsigned - true - 3.2 + + entity_id + int unsigned + true + 3.2 entity_id entity_table - 3.2 + 3.2 - - financial_trxn_id - int unsigned - 3.2 - - - financial_trxn_id -
civicrm_financial_trxn
- id - 3.2 + + financial_trxn_id + int unsigned + 3.2 + + + financial_trxn_id + civicrm_financial_trxn
+ id + 3.2 SET NULL - - amount - decimal + + amount + decimal true true /amount/i /^\d+(\.\d{2})?$/ allocated amount of transaction to this entity - 3.2 - + 3.2 + currency varchar @@ -71,11 +71,11 @@ UI_entity_financial_trxn_entity_table entity_table 4.3 - + UI_entity_financial_trxn_entity_id entity_id 4.3 - + diff --git a/xml/schema/Financial/FinancialAccount.xml b/xml/schema/Financial/FinancialAccount.xml index 4895591596..9ff3a8556b 100644 --- a/xml/schema/Financial/FinancialAccount.xml +++ b/xml/schema/Financial/FinancialAccount.xml @@ -1,22 +1,22 @@ - + - - CRM/Financial - FinancialAccount - civicrm_financial_account - 3.2 - true - - id - int unsigned - true - ID +
+ CRM/Financial + FinancialAccount + civicrm_financial_account + 3.2 + true + + id + int unsigned + true + ID 3.2 - - - id - true - + + + id + true + name varchar @@ -25,33 +25,33 @@ Financial Account Name. 3.2 - - contact_id + + contact_id financial_account_contact_id Contact ID - int unsigned + int unsigned FK to Contact ID that is responsible for the funds in this account - 4.3 - - - contact_id -
civicrm_contact
- id - 4.3 + 4.3 + + + contact_id + civicrm_contact
+ id + 4.3 SET NULL - - account_type_id - int unsigned - true - 3.2 + + account_type_id + int unsigned + true + 3.2 4.3 - - - financial_account_type_id - int unsigned - true - 3 + + + financial_account_type_id + int unsigned + true + 3 4.3 pseudo FK into civicrm_option_value. @@ -85,21 +85,21 @@ parent_id - int unsigned - Parent ID in account hierarchy + int unsigned + Parent ID in account hierarchy 4.3 - - parent_id - civicrm_financial_account
- id - 4.3 + + parent_id + civicrm_financial_account
+ id + 4.3 is_header_account - boolean - 0 - Is this a header account which does not allow transactions to be posted against it directly, but only to its sub-accounts? + boolean + 0 + Is this a header account which does not allow transactions to be posted against it directly, but only to its sub-accounts? 4.3 diff --git a/xml/schema/Financial/FinancialItem.xml b/xml/schema/Financial/FinancialItem.xml index 7b982bdeec..8bd59d0903 100644 --- a/xml/schema/Financial/FinancialItem.xml +++ b/xml/schema/Financial/FinancialItem.xml @@ -1,43 +1,43 @@ - + - - CRM/Financial - FinancialItem - civicrm_financial_item - 4.3 +
+ CRM/Financial + FinancialItem + civicrm_financial_item + 4.3Financial data for civicrm_line_item, etc. - true - - id + true + + id int unsigned 10 - true - - 4.3 - - - id - true - + true + + 4.3 + + + id + true + created_date timestamp - true - CURRENT_TIMESTAMP + true + CURRENT_TIMESTAMP Date and time the item was created 4.3 - + transaction_date datetime - true + true Date and time of the source transaction 4.3 - + contact_id int unsigned - true + true true FK to Contact ID of contact the item is from 4.3 @@ -56,18 +56,18 @@ Human readable description of this item, to ease display without lookup of source item. 4.3 - - amount + + amount Amount decimal 0 - true + true /unit?.?amoun/i /^\d+(\.\d{2})?$/ - Total amount of this item - 4.3 + Total amount of this item + 4.3 - + currency true varchar diff --git a/xml/schema/Financial/FinancialType.xml b/xml/schema/Financial/FinancialType.xml index f0d2c004be..6b580813c1 100644 --- a/xml/schema/Financial/FinancialType.xml +++ b/xml/schema/Financial/FinancialType.xml @@ -1,31 +1,31 @@ - + -
- CRM/Financial - FinancialType - civicrm_financial_type - 1.3 +
+ CRM/Financial + FinancialType + civicrm_financial_type + 1.3Formerly civicrm_contribution_type merged into this table in 4.3 - true - - id + true + + id int unsigned 10 - true - ID of original financial_type so you can search this table by the financial_type.id and then select the relevant version based on the timestamp + true + ID of original financial_type so you can search this table by the financial_type.id and then select the relevant version based on the timestamp 1.3 - - id - true - + + id + true + name - financial_type + financial_type Financial Type varchar 64 - true + true true /(finan(cial)?)?type/i /donation|member|campaign/i @@ -52,7 +52,7 @@ is_deductible boolean - 4 + 4 1 Is this financial type tax-deductible? If true, contributions of this type may be fully OR partially deductible - non-deductible amount is stored in the Contribution record. 1.3 @@ -60,14 +60,14 @@ is_reserved boolean - 4 + 4 Is this a predefined system object? 1.3 is_active boolean - 4 + 4 Is this property active? 1.3 diff --git a/xml/schema/Financial/OfficialReceipt.xml b/xml/schema/Financial/OfficialReceipt.xml index e9d659b45d..b14b469f17 100755 --- a/xml/schema/Financial/OfficialReceipt.xml +++ b/xml/schema/Financial/OfficialReceipt.xml @@ -1,55 +1,55 @@ - -
- CRM/Financial - OfficialReceipt - civicrm_official_receipt - 4.1 + +
+ CRM/Financial + OfficialReceipt + civicrm_official_receipt + 4.1true - - id - int unsigned - true - Receipt ID - 4.1 - - - id - true - - - contact_id + + id + int unsigned + true + Receipt ID + 4.1 + + + id + true + + + contact_id receipt_contact_id Contact ID - int unsigned - true + int unsigned + true true /contact(.?id)?/i /^\d+$/ - FK to Contact ID - 4.1 - - - contact_id -
civicrm_contact
- id - 4.1 - - - contact_snapshot + FK to Contact ID + 4.1 + + + contact_id + civicrm_contact
+ id + 4.1 + + + contact_snapshot text textarea 4 80 - Serialized array of contact info of payor at time receipt is created + Serialized array of contact info of payor at time receipt is created 4.1 true - - issued_date - datetime - true - 4.1 + + issued_date + datetime + true + 4.1 UI_issued_date @@ -57,10 +57,10 @@ 4.1 - start_date - datetime - true - 4.1 + start_date + datetime + true + 4.1 UI_start_date @@ -68,20 +68,20 @@ 4.1 - end_date - datetime - true - 4.1 + end_date + datetime + true + 4.1 UI_end_date end_date 4.1 - - receipt_status_id - int unsigned - true + + receipt_status_id + int unsigned + true 4.1 pseudo FK to civicrm_option_value @@ -90,36 +90,36 @@ receipt_status_id 4.1 - - receipt_type_id - int unsigned - true + + receipt_type_id + int unsigned + true 4.1 pseudo FK to civicrm_option_value - + UI_receipt_type_id receipt_type_id 4.1 - - total_amount - decimal + + total_amount + decimal true Total amount for this receipt. - 4.1 - - - non_deductible_amount - decimal + 4.1 + + + non_deductible_amount + decimal Portion of total amount which is NOT tax deductible. Equal to total_amount for non-deductible financial types. - 4.1 + 4.1 currency varchar 3 - NULL + NULL true /cur(rency)?/i /^[A-Z]{3}$/ @@ -132,19 +132,19 @@ numeric_code - - msg_template_id + + msg_template_id int unsigned - template used to generate receipt + template used to generate receipt 4.1 - - msg_template_id - civicrm_msg_template
+ + msg_template_id + civicrm_msg_template
id 4.1 Set Null - + diff --git a/xml/schema/Financial/PaymentProcessor.xml b/xml/schema/Financial/PaymentProcessor.xml index 813fdbc687..fe3916b1a2 100644 --- a/xml/schema/Financial/PaymentProcessor.xml +++ b/xml/schema/Financial/PaymentProcessor.xml @@ -28,7 +28,7 @@ civicrm_domain
id 3.0 - + name Payment Processor @@ -63,7 +63,7 @@ civicrm_payment_processor_type
id 4.3 - + is_active boolean @@ -169,7 +169,7 @@ payment_type int unsigned - 1 + 1 Payment Type: Credit or Debit 3.0 diff --git a/xml/schema/Friend/Friend.xml b/xml/schema/Friend/Friend.xml index f79a5fc6a2..c4c9278c06 100644 --- a/xml/schema/Friend/Friend.xml +++ b/xml/schema/Friend/Friend.xml @@ -1,21 +1,21 @@ - - - - CRM/Friend - Friend - civicrm_tell_friend - 2.0 - - id - int unsigned - true - Friend ID - 2.0 - - - id - true - + + +
+ CRM/Friend + Friend + civicrm_tell_friend + 2.0 + + id + int unsigned + true + Friend ID + 2.0 + + + id + true + entity_table varchar @@ -37,52 +37,52 @@ 2.0 - title + title varchar 255 true - 2.0 + 2.0 - - intro - text + + intro + text true - Introductory message to contributor or participant displayed on the Tell a Friend form. - 2.0 + Introductory message to contributor or participant displayed on the Tell a Friend form. + 2.0 - - suggested_message - text + + suggested_message + text true Suggested message to friends, provided as default on the Tell A Friend form. - 2.0 - - - general_link - varchar - 255 + 2.0 + + + general_link + varchar + 255 true URL for general info about the organization - included in the email sent to friends. - 2.0 + 2.0 - - thankyou_title - varchar - 255 + + thankyou_title + varchar + 255 true Text for Tell a Friend thank you page header and HTML title. - 2.0 - - - thankyou_text - text + 2.0 + + + thankyou_text + text true Thank you message displayed on success page. - 2.0 - - - is_active - boolean - 2.0 - + 2.0 + + + is_active + boolean + 2.0 +
diff --git a/xml/schema/GccSchema.xml b/xml/schema/GccSchema.xml index b4782a8e9b..a62406c4ab 100644 --- a/xml/schema/GccSchema.xml +++ b/xml/schema/GccSchema.xml @@ -11,13 +11,13 @@ - - + + - - - - - + + + + + diff --git a/xml/schema/Mailing/Mailing.xml b/xml/schema/Mailing/Mailing.xml index 53d4744e44..7a7df67a68 100644 --- a/xml/schema/Mailing/Mailing.xml +++ b/xml/schema/Mailing/Mailing.xml @@ -173,7 +173,7 @@ override_verp boolean 0 - 2.2 + 2.2 Should we overrite VERP address in Reply-To @@ -254,42 +254,42 @@ Is this mailing archived? 2.2 - - visibility - enum - User and User Admin Only,Public Pages - 'User and User Admin Only' - In what context(s) is the mailing contents visible (online viewing) - 3.3 - - - campaign_id - int unsigned - The campaign for which this mailing has been initiated. - 3.4 - - - campaign_id - civicrm_campaign
- id + + visibility + enum + User and User Admin Only,Public Pages + 'User and User Admin Only' + In what context(s) is the mailing contents visible (online viewing) + 3.3 + + + campaign_id + int unsigned + The campaign for which this mailing has been initiated. + 3.4 + + + campaign_id + civicrm_campaign
+ id SET NULL dedupe_email boolean 0 - 4.1 + 4.1 Remove duplicate emails? - - sms_provider_id - int unsigned - 4.2 - - - sms_provider_id - civicrm_sms_provider
- id + + sms_provider_id + int unsigned + 4.2 + + + sms_provider_id + civicrm_sms_provider
+ id SET NULL 4.2 diff --git a/xml/schema/Member/Membership.xml b/xml/schema/Member/Membership.xml index 5afcafb1cd..d94e6adf95 100644 --- a/xml/schema/Member/Membership.xml +++ b/xml/schema/Member/Membership.xml @@ -12,7 +12,7 @@ membership_id int unsigned true - true + true Membership ID /^(m(embership\s)?id)$/i Membership Id @@ -35,9 +35,9 @@ FK to Contact ID 1.5 - - contact_id - civicrm_contact
+ + contact_id + civicrm_contact
id 1.5 CASCADE @@ -58,55 +58,55 @@ 1.5 - - membership_type_id - civicrm_membership_type
+ + membership_type_id + civicrm_membership_type
id 1.5 CASCADE - - join_date + + join_date Member Since date true /^join|(j(oin\s)?date)$/i - /\d{4}-?\d{2}-?\d{2}/ - Beginning of initial membership period (member since...). - 1.5 - - - start_date + /\d{4}-?\d{2}-?\d{2}/ + Beginning of initial membership period (member since...). + 1.5 + + + start_date membership_start_date Membership Start Date date true /(member(ship)?.)?start(s)?(.date$)?/i - /\d{4}-?\d{2}-?\d{2}/ + /\d{4}-?\d{2}-?\d{2}/ Beginning of current uninterrupted membership period. - 1.5 + 1.5 - - end_date + + end_date membership_end_date Membership Expiration Date date true /(member(ship)?.)?end(s)?(.date$)?/i /\d{4}-?\d{2}-?\d{2}/ - Current membership period expire date. - 1.5 - - - source + Current membership period expire date. + 1.5 + + + source membership_source Source true /^(member(ship?))?source$/i varchar 128 - 1.5 - + 1.5 + status_id Membership Status Id @@ -123,22 +123,22 @@ 1.5 - - status_id - civicrm_membership_status
+ + status_id + civicrm_membership_status
id 1.5 CASCADE - - is_override + + is_override Status Override true /override$/i boolean Admin users may set a manual status which overrides the calculated status. When this flag is true, automated status update scripts should NOT modify status for the record. - 1.5 - + 1.5 + owner_membership_id int unsigned @@ -166,50 +166,50 @@ 4.3 - is_test + is_test Test - member_is_test + member_is_test boolean 0 true /(is.)?test(.member(ship)?)?/i - - is_pay_later - member_is_pay_later + + is_pay_later + member_is_pay_later Is Pay Later boolean 0 true /(is.)?(pay(.)?later)$/i - 2.1 + 2.1 - - contribution_recur_id - int unsigned - Conditional foreign key to civicrm_contribution_recur id. Each membership in connection with a recurring contribution carries a foreign key to the recurring contribution record. This assumes we can track these processor initiated events. - 3.3 - - - contribution_recur_id - civicrm_contribution_recur
- id - 3.3 + + contribution_recur_id + int unsigned + Conditional foreign key to civicrm_contribution_recur id. Each membership in connection with a recurring contribution carries a foreign key to the recurring contribution record. This assumes we can track these processor initiated events. + 3.3 + + + contribution_recur_id + civicrm_contribution_recur
+ id + 3.3 SET NULL - - campaign_id + + campaign_id member_campaign_id int unsigned Campaign ID - true - The campaign for which this membership is attached. - 3.4 - - - campaign_id - civicrm_campaign
- id + true + The campaign for which this membership is attached. + 3.4 + + + campaign_id + civicrm_campaign
+ id SET NULL diff --git a/xml/schema/Member/MembershipBlock.xml b/xml/schema/Member/MembershipBlock.xml index 1ef5a71541..ef1d5a1dd8 100644 --- a/xml/schema/Member/MembershipBlock.xml +++ b/xml/schema/Member/MembershipBlock.xml @@ -32,9 +32,9 @@ FK to civicrm_contribution_page.id 1.5 - - entity_id - civicrm_contribution_page
+ + entity_id + civicrm_contribution_page
id 1.5 @@ -42,79 +42,79 @@ membership_types varchar 255 - Membership types to be exposed by this block + Membership types to be exposed by this block 1.5 - - membership_type_default + + membership_type_default int unsigned - Optional foreign key to membership_type - 1.5 + Optional foreign key to membership_type + 1.5 - - membership_type_default - civicrm_membership_type
+ + membership_type_default + civicrm_membership_type
id 1.5 - - display_min_fee - boolean - 1 - Display minimum membership fee - 1.5 - - - is_separate_payment + + display_min_fee boolean 1 - Should membership transactions be processed separately - 1.5 - - + Display minimum membership fee + 1.5 + + + is_separate_payment + boolean + 1 + Should membership transactions be processed separately + 1.5 + + new_title varchar 255 true - Title to display at top of block - 1.5 - - + Title to display at top of block + 1.5 + + new_text text true - Text to display below title - 1.5 - - + Text to display below title + 1.5 + + renewal_title varchar 255 true - Title for renewal - 1.5 + Title for renewal + 1.5 - + renewal_text text true - Text to display for member renewal - 1.5 - - - is_required + Text to display for member renewal + 1.5 + + + is_required Is Required boolean 0 - Is membership sign up optional - 1.5 - - - is_active + Is membership sign up optional + 1.5 + + + is_active Is Active boolean 1 - Is this membership_block enabled - 1.5 - + Is this membership_block enabled + 1.5 + diff --git a/xml/schema/Member/MembershipLog.xml b/xml/schema/Member/MembershipLog.xml index bfc9f01b3f..1c092bc14c 100644 --- a/xml/schema/Member/MembershipLog.xml +++ b/xml/schema/Member/MembershipLog.xml @@ -24,13 +24,13 @@ FK to Membership table 1.5 - - membership_id - civicrm_membership
- id + + membership_id + civicrm_membership
+ id 1.5 CASCADE - + status_id Membership Status @@ -39,26 +39,26 @@ New status assigned to membership by this action. FK to Membership Status 1.5 - - status_id - civicrm_membership_status
+ + status_id + civicrm_membership_status
id 1.5 CASCADE - start_date - date - /\d{4}-?\d{2}-?\d{2}/ - New membership period start date - 1.5 + start_date + date + /\d{4}-?\d{2}-?\d{2}/ + New membership period start date + 1.5 - - end_date + + end_date date - /\d{4}-?\d{2}-?\d{2}/ - New membership period expiration date. - 1.5 + /\d{4}-?\d{2}-?\d{2}/ + New membership period expiration date. + 1.5 modified_id @@ -75,11 +75,11 @@ modified_date - Membership Change Date - date - /\d{4}-?\d{2}-?\d{2}/ - Date this membership modification action was logged. - 1.5 + Membership Change Date + date + /\d{4}-?\d{2}-?\d{2}/ + Date this membership modification action was logged. + 1.5 membership_type_id diff --git a/xml/schema/Member/MembershipPayment.xml b/xml/schema/Member/MembershipPayment.xml index 2c3a021697..8d5ff2b7a6 100644 --- a/xml/schema/Member/MembershipPayment.xml +++ b/xml/schema/Member/MembershipPayment.xml @@ -24,26 +24,26 @@ FK to Membership table 1.5 - - membership_id - civicrm_membership
- id + + membership_id + civicrm_membership
+ id 1.5 CASCADE - + contribution_id int unsigned FK to contribution table. 2.0 - - contribution_id - civicrm_contribution
- id + + contribution_id + civicrm_contribution
+ id 2.0 CASCADE - + UI_contribution_membership true diff --git a/xml/schema/Member/MembershipStatus.xml b/xml/schema/Member/MembershipStatus.xml index 1b4cb05bae..efbdffbee5 100644 --- a/xml/schema/Member/MembershipStatus.xml +++ b/xml/schema/Member/MembershipStatus.xml @@ -40,83 +40,83 @@ start_event enum start_date, end_date, join_date - Event when this status starts. + Event when this status starts. 1.5 - - start_event_adjust_unit + + start_event_adjust_unit enum day, month, year - Unit used for adjusting from start_event. - 1.5 + Unit used for adjusting from start_event. + 1.5 + + + start_event_adjust_interval + int + Status range begins this many units from start_event. + 1.5 - - start_event_adjust_interval - int - Status range begins this many units from start_event. - 1.5 - - + end_event enum start_date, end_date, join_date - Event after which this status ends. - 1.5 - - + Event after which this status ends. + 1.5 + + end_event_adjust_unit enum - day, month, year - Unit used for adjusting from the ending event. - 1.5 - - - end_event_adjust_interval - int - Status range ends this many units from end_event. - 1.5 - - - is_current_member + day, month, year + Unit used for adjusting from the ending event. + 1.5 + + + end_event_adjust_interval + int + Status range ends this many units from end_event. + 1.5 + + + is_current_member Current Membership? boolean Does this status aggregate to current members (e.g. New, Renewed, Grace might all be TRUE... while Unrenewed, Lapsed, Inactive would be FALSE). - 1.5 - - - is_admin + 1.5 + + + is_admin Admin Assigned Only? boolean Is this status for admin/manual assignment only. - 1.5 - - - weight + 1.5 + + + weight Weight int - 1.5 - - - is_default + 1.5 + + + is_default Default Status? boolean Assign this status to a membership record if no other status match is found. - 1.5 - - - is_active + 1.5 + + + is_active Is Active boolean 1 Is this membership_status enabled. - 1.5 - - - is_reserved + 1.5 + + + is_reserved Is Reserved boolean 0 Is this membership_status reserved. - 2.1 - + 2.1 + diff --git a/xml/schema/Member/MembershipType.xml b/xml/schema/Member/MembershipType.xml index 57fb63f8bb..9b06a592dc 100644 --- a/xml/schema/Member/MembershipType.xml +++ b/xml/schema/Member/MembershipType.xml @@ -30,10 +30,10 @@ civicrm_domain
id 3.0 - + name - membership_type + membership_type Membership Type varchar true @@ -60,9 +60,9 @@ Owner organization for this membership type. FK to Contact ID 1.5 - - member_of_contact_id - civicrm_contact
+ + member_of_contact_id + civicrm_contact
id 1.5 RESTRICT @@ -75,10 +75,10 @@ 1.5 4.3 - - contribution_type_id - civicrm_contribution_type
- id + + contribution_type_id + civicrm_contribution_type
+ id 1.5 4.3 @@ -89,51 +89,51 @@ If membership is paid by a contribution - what financial type should be used. FK to civicrm_financial_type.id 4.3 - - financial_type_id - civicrm_financial_type
- id + + financial_type_id + civicrm_financial_type
+ id 4.3 - - minimum_fee - decimal - Minimum fee for this membership (0 for free/complimentary memberships). + + minimum_fee + decimal + Minimum fee for this membership (0 for free/complimentary memberships). 0 - 1.5 - - - duration_unit + 1.5 + + + duration_unit enum day, month, year, lifetime - Unit in which membership period is expressed. - 1.5 - - + Unit in which membership period is expressed. + 1.5 + + duration_interval int - Number of duration units in membership period (e.g. 1 year, 12 months). - 1.5 - - - period_type + Number of duration units in membership period (e.g. 1 year, 12 months). + 1.5 + + + period_type enum rolling, fixed - Rolling membership period starts on signup date. Fixed membership periods start on fixed_period_start_day. - 1.5 - - - fixed_period_start_day - int - For fixed period memberships, month and day (mmdd) on which subscription/membership will start. Period start is back-dated unless after rollover day. - 1.5 - - - fixed_period_rollover_day + Rolling membership period starts on signup date. Fixed membership periods start on fixed_period_start_day. + 1.5 + + + fixed_period_start_day int - For fixed period memberships, signups after this day (mmdd) rollover to next period. - 1.5 - + For fixed period memberships, month and day (mmdd) on which subscription/membership will start. Period start is back-dated unless after rollover day. + 1.5 + + + fixed_period_rollover_day + int + For fixed period memberships, signups after this day (mmdd) rollover to next period. + 1.5 + relationship_type_id varchar @@ -141,10 +141,10 @@ FK to Relationship Type ID 1.5 - - relationship_type_id - civicrm_relationship_type
- id + + relationship_type_id + civicrm_relationship_type
+ id 1.5 3.3 @@ -153,11 +153,11 @@ relationship_type_id 3.3 - - relationship_direction - varchar - 128 - 1.7 + + relationship_direction + varchar + 128 + 1.7 max_related @@ -166,7 +166,7 @@ 4.3 - visibility + visibility Visible varchar 64 @@ -175,11 +175,11 @@ visibility - - weight + + weight Weight int - 1.5 + 1.5 receipt_text_signup @@ -201,19 +201,19 @@ Receipt Text for membership renewal 2.0 - - auto_renew + + auto_renew boolean 0 - 0 = No auto-renew option; 1 = Give option, but not required; 2 = Auto-renew required; - 3.3 - - - is_active + 0 = No auto-renew option; 1 = Give option, but not required; 2 = Auto-renew required; + 3.3 + + + is_active Is Active boolean 1 - Is this membership_type enabled - 1.5 - + Is this membership_type enabled + 1.5 + diff --git a/xml/schema/PCP/PCP.xml b/xml/schema/PCP/PCP.xml index 2b2c55acc8..1c1c7ee6ff 100644 --- a/xml/schema/PCP/PCP.xml +++ b/xml/schema/PCP/PCP.xml @@ -1,40 +1,40 @@ - - - - CRM/PCP - PCP - civicrm_pcp - 2.2 + + +
+ CRM/PCP + PCP + civicrm_pcp + 2.2true - - id + + id pcp_id - int unsigned + int unsigned true Personal Campaign Page ID - Personal Campaign Page ID - 2.2 - - - id - true - - - contact_id + Personal Campaign Page ID + 2.2 + + + id + true + + + contact_id pcp_contact_id Contact ID - int unsigned - true - FK to Contact ID - 2.2 - - - contact_id -
civicrm_contact
- id - 2.2 + int unsigned + true + FK to Contact ID + 2.2 + + + contact_id + civicrm_contact
+ id + 2.2 CASCADE - + status_id Personal Campaign Page Status @@ -45,88 +45,88 @@ pcp_status - + title Personal Campaign Page Title - varchar + varchar 255 NULL - 2.2 - - - intro_text - text + 2.2 + + + intro_text + text NULL - 2.2 - - - page_text - text + 2.2 + + + page_text + text NULL - 2.2 - - + 2.2 + + donate_link_text - varchar + varchar 255 NULL - 2.2 + 2.2 - - contribution_page_id + + contribution_page_id int unsigned true - The Contribution Page which triggered this pcp - 2.2 + The Contribution Page which triggered this pcp + 2.2 4.1 - - - contribution_page_id - civicrm_contribution_page
- id + + + contribution_page_id + civicrm_contribution_page
+ id 4.1 - - page_id + + page_id int unsigned true - The Contribution or Event Page which triggered this pcp + The Contribution or Event Page which triggered this pcp 4.1 - - + + page_type PCP Page Type The type of PCP this is: contribute or event - varchar + varchar 64 'contribute' 2.2 - - + + pcp_block_id The pcp block that this pcp page was created from - int unsigned + int unsigned true - 4.1 - - - is_thermometer - int unsigned + 4.1 + + + is_thermometer + int unsigned 0 - 2.2 - - - is_honor_roll - int unsigned + 2.2 + + + is_honor_roll + int unsigned 0 - 2.2 - - - goal_amount - decimal - Goal amount of this Personal Campaign Page. - 2.2 - + 2.2 + + + goal_amount + decimal + Goal amount of this Personal Campaign Page. + 2.2 + currency varchar @@ -141,19 +141,19 @@ numeric_code - + referer - varchar + varchar 255 NULL - 2.2 + 2.2 4.1 - - is_active - boolean - Is Personal Campaign Page enabled/active? + + is_active + boolean + Is Personal Campaign Page enabled/active? 0 - 2.2 + 2.2 diff --git a/xml/schema/PCP/PCPBlock.xml b/xml/schema/PCP/PCPBlock.xml index fbd6c504ee..116a0b0574 100644 --- a/xml/schema/PCP/PCPBlock.xml +++ b/xml/schema/PCP/PCPBlock.xml @@ -36,9 +36,9 @@ entity_table 2.2 - - entity_id - civicrm_contribution_page
+ + entity_id + civicrm_contribution_page
id 2.2 4.1 @@ -65,40 +65,40 @@ target_entity_type 4.1 - - supporter_profile_id - int unsigned + + supporter_profile_id + int unsigned FK to civicrm_uf_group.id. Does Personal Campaign Page require manual activation by administrator? (is inactive by default after setup)? NULL - 2.2 + 2.2 - - supporter_profile_id - civicrm_uf_group
+ + supporter_profile_id + civicrm_uf_group
id 3.1 SET NULL - - is_approval_needed - boolean - Does Personal Campaign Page require manual activation by administrator? (is inactive by default after setup)? + + is_approval_needed + boolean + Does Personal Campaign Page require manual activation by administrator? (is inactive by default after setup)? NULL - 2.2 + 2.2 - - is_tellfriend_enabled - boolean - Does Personal Campaign Page allow using tell a friend? + + is_tellfriend_enabled + boolean + Does Personal Campaign Page allow using tell a friend? NULL - 2.2 + 2.2 - - tellfriend_limit - int unsigned + + tellfriend_limit + int unsigned NULL - Maximum recipient fields allowed in tell a friend - 2.2 + Maximum recipient fields allowed in tell a friend + 2.2 link_text @@ -108,20 +108,20 @@ true Link text for PCP. 2.2 - - - is_active - boolean - Is Personal Campaign Page Block enabled/active? + + + is_active + boolean + Is Personal Campaign Page Block enabled/active? 1 - 2.2 + 2.2 - - notify_email + + notify_email varchar - 255 + 255 If set, notification is automatically emailed to this email-address on create/update Personal Campaign Page NULL - 2.2 + 2.2 diff --git a/xml/schema/Pledge/Pledge.xml b/xml/schema/Pledge/Pledge.xml index 83cab6d417..77f737aab2 100644 --- a/xml/schema/Pledge/Pledge.xml +++ b/xml/schema/Pledge/Pledge.xml @@ -36,54 +36,54 @@ 2.1 CASCADE - - contribution_type_id + + contribution_type_id pledge_contribution_type_id false - int unsigned + int unsigned FK to Contribution Type. This is propagated to contribution record when pledge payments are made. 2.1 - 4.3 - - - contribution_type_id - civicrm_contribution_type
- id + 4.3 + + + contribution_type_id + civicrm_contribution_type
+ id 2.1 - 4.3 + 4.3 SET NULL - - financial_type_id + + financial_type_id Type pledge_financial_type_id - int unsigned + int unsigned FK to Financial Type - 4.3 - - - financial_type_id - civicrm_financial_type
- id - 4.3 - - + 4.3 + + + financial_type_id + civicrm_financial_type
+ id + 4.3 + + contribution_page_id pledge_contribution_page_id Pledge Contribution Page - int unsigned - The Contribution Page which triggered this contribution - 2.1 - - - contribution_page_id - civicrm_contribution_page
- id + int unsigned + The Contribution Page which triggered this contribution + 2.1 + + + contribution_page_id + civicrm_contribution_page
+ id SET NULL amount - pledge_amount + pledge_amount Total Pledged decimal true @@ -93,7 +93,7 @@ original_installment_amount - pledge_original_installment_amount + pledge_original_installment_amount Original Installment Amount decimal true @@ -119,7 +119,7 @@ frequency_unit pledge_frequency_unit Pledge Frequency Unit - enum + enum day,week,month,year 'month' Time units for recurrence of pledge payments. @@ -198,20 +198,20 @@ Date this pledge finished successfully (total pledge payments equal to or greater than pledged amount). 2.1 - + honor_contact_id int unsigned Pledge Honor Contact - FK to contact ID. Used when pledge is made in honor of another contact. This is propagated to contribution records when pledge payments are made. - 2.1 - - - honor_contact_id - civicrm_contact
- id - 2.1 + FK to contact ID. Used when pledge is made in honor of another contact. This is propagated to contribution records when pledge payments are made. + 2.1 + + + honor_contact_id + civicrm_contact
+ id + 2.1 SET NULL - + honor_type_id Honor Type @@ -262,27 +262,27 @@ status_id 2.1 - - is_test - pledge_is_test + + is_test + pledge_is_test true Test boolean 0 - - campaign_id + + campaign_id pledge_campaign_id - int unsigned + int unsigned Campaign ID - true - The campaign for which this pledge has been initiated. - 3.4 - - - campaign_id - civicrm_campaign
- id + true + The campaign for which this pledge has been initiated. + 3.4 + + + campaign_id + civicrm_campaign
+ id SET NULL diff --git a/xml/schema/Pledge/PledgeBlock.xml b/xml/schema/Pledge/PledgeBlock.xml index a5e1cf936f..9e76f27346 100644 --- a/xml/schema/Pledge/PledgeBlock.xml +++ b/xml/schema/Pledge/PledgeBlock.xml @@ -26,7 +26,7 @@ entity_id - Entity Id + Entity Id int unsigned true FK to entity table specified in entity_table column. @@ -51,8 +51,8 @@ Delimited list of supported frequency units 2.1 - - is_pledge_interval + + is_pledge_interval boolean 0 Is frequency interval exposed on the contribution form. diff --git a/xml/schema/Pledge/PledgePayment.xml b/xml/schema/Pledge/PledgePayment.xml index e266d0be7d..8a3bee3556 100644 --- a/xml/schema/Pledge/PledgePayment.xml +++ b/xml/schema/Pledge/PledgePayment.xml @@ -9,7 +9,7 @@ true id - pledge_payment_id + pledge_payment_id Payment ID int unsigned true @@ -27,26 +27,26 @@ FK to Pledge table 2.1 - - pledge_id - civicrm_pledge
- id + + pledge_id + civicrm_pledge
+ id 2.1 CASCADE - + contribution_id int unsigned FK to contribution table. 2.1 - - contribution_id - civicrm_contribution
- id + + contribution_id + civicrm_contribution
+ id 2.1 CASCADE - + index_contribution_pledge contribution_id @@ -55,7 +55,7 @@ scheduled_amount - pledge_payment_scheduled_amount + pledge_payment_scheduled_amount Scheduled Amount true decimal @@ -65,7 +65,7 @@ actual_amount - pledge_payment_actual_amount + pledge_payment_actual_amount Actual Amount true decimal @@ -88,7 +88,7 @@ scheduled_date - pledge_payment_scheduled_date + pledge_payment_scheduled_date Scheduled Date true datetime @@ -98,7 +98,7 @@ reminder_date - pledge_payment_reminder_date + pledge_payment_reminder_date Last Reminder true datetime @@ -107,7 +107,7 @@ reminder_count - pledge_payment_reminder_count + pledge_payment_reminder_count Reminders Sent true int unsigned diff --git a/xml/schema/Price/Field.xml b/xml/schema/Price/Field.xml index 5d7472a74a..b79067e455 100644 --- a/xml/schema/Price/Field.xml +++ b/xml/schema/Price/Field.xml @@ -152,7 +152,7 @@ visibility - + count int unsigned diff --git a/xml/schema/QuestSchema.xml b/xml/schema/QuestSchema.xml index 555d2ca35c..b4ecf91977 100644 --- a/xml/schema/QuestSchema.xml +++ b/xml/schema/QuestSchema.xml @@ -11,14 +11,14 @@ - - + + - - - - - - + + + + + + diff --git a/xml/schema/Queue/QueueItem.xml b/xml/schema/Queue/QueueItem.xml index 927bff0a72..6500d9377d 100644 --- a/xml/schema/Queue/QueueItem.xml +++ b/xml/schema/Queue/QueueItem.xml @@ -1,9 +1,9 @@ - CRM/QueueQueueItem -- 2.25.1