From 614d72ec5a4d53073125c0ab9a442faff3beadc9 Mon Sep 17 00:00:00 2001 From: lynndanzig Date: Tue, 8 Oct 2013 20:31:13 +0100 Subject: [PATCH] CRM-13497 - getting there on main tables --- xml/schema/ACL/ACL.xml | 20 +- xml/schema/Activity/Activity.xml | 34 +++- xml/schema/Activity/ActivityContact.xml | 3 + xml/schema/Batch/Batch.xml | 30 +++ xml/schema/Bridge/OG.xml | 6 + xml/schema/Bridge/Role.xml | 3 + xml/schema/Campaign/Campaign.xml | 24 +++ xml/schema/Campaign/CampaignGroup.xml | 3 + xml/schema/Campaign/Survey.xml | 3 + xml/schema/Case/Case.xml | 17 +- xml/schema/Case/CaseContact.xml | 5 +- xml/schema/Contact/ACLContactCache.xml | 3 + xml/schema/Contact/Contact.xml | 174 ++++++++++++++++-- xml/schema/Contact/Group.xml | 3 + xml/schema/Contact/GroupContact.xml | 6 + xml/schema/Contact/GroupContactCache.xml | 3 + xml/schema/Contact/GroupOrganization.xml | 3 + xml/schema/Contact/RelationshipType.xml | 12 ++ xml/schema/Contact/SubscriptionHistory.xml | 6 + xml/schema/Contribute/Contribution.xml | 88 ++++++++- xml/schema/Contribute/ContributionPage.xml | 9 + xml/schema/Contribute/ContributionRecur.xml | 9 + xml/schema/Contribute/ContributionSoft.xml | 3 + xml/schema/Contribute/Product.xml | 12 ++ xml/schema/Core/ActionSchedule.xml | 12 ++ xml/schema/Core/Address.xml | 12 ++ xml/schema/Core/Cache.xml | 3 + xml/schema/Core/CustomField.xml | 6 + xml/schema/Core/CustomGroup.xml | 3 + xml/schema/Core/Email.xml | 8 +- xml/schema/Core/EntityTag.xml | 3 + xml/schema/Core/Extension.xml | 3 + xml/schema/Core/IM.xml | 3 + xml/schema/Core/Job.xml | 3 + xml/schema/Core/MailSettings.xml | 3 + xml/schema/Core/Mapping.xml | 3 + xml/schema/Core/MappingField.xml | 12 ++ xml/schema/Core/Menu.xml | 3 + xml/schema/Core/OptionValue.xml | 6 + xml/schema/Core/Phone.xml | 11 +- xml/schema/Core/PrintLabel.xml | 6 + xml/schema/Core/Setting.xml | 3 + xml/schema/Core/UFField.xml | 6 + xml/schema/Core/UFJoin.xml | 3 + xml/schema/Core/Website.xml | 8 +- xml/schema/Core/WordReplacement.xml | 3 + xml/schema/Dedupe/RuleGroup.xml | 6 + xml/schema/Event/Event.xml | 135 ++++++++++++++ xml/schema/Event/Participant.xml | 9 + xml/schema/Event/ParticipantStatusType.xml | 6 + xml/schema/Financial/Currency.xml | 9 + .../Financial/EntityFinancialAccount.xml | 6 + xml/schema/Financial/FinancialAccount.xml | 3 + xml/schema/Financial/FinancialItem.xml | 9 + xml/schema/Financial/FinancialTrxn.xml | 17 +- xml/schema/Financial/PaymentProcessorType.xml | 3 + xml/schema/Friend/Friend.xml | 21 +++ xml/schema/Grant/Grant.xml | 36 ++++ xml/schema/Mailing/BounceType.xml | 3 + xml/schema/Mailing/Component.xml | 3 + xml/schema/Mailing/Event/Bounce.xml | 3 + xml/schema/Mailing/Event/Subscribe.xml | 3 + xml/schema/Mailing/Mailing.xml | 56 +++++- xml/schema/Mailing/MailingGroup.xml | 3 + xml/schema/Mailing/MailingJob.xml | 3 + xml/schema/Member/Membership.xml | 36 ++++ xml/schema/Member/MembershipStatus.xml | 12 ++ xml/schema/Member/MembershipType.xml | 6 + xml/schema/PCP/PCP.xml | 36 ++++ xml/schema/Pledge/Pledge.xml | 63 +++++++ xml/schema/Pledge/PledgePayment.xml | 3 + xml/schema/Price/LineItem.xml | 21 ++- xml/schema/Price/PriceField.xml | 39 ++++ xml/schema/Price/PriceFieldValue.xml | 42 ++++- xml/schema/Price/PriceSet.xml | 27 +++ xml/schema/Queue/QueueItem.xml | 13 ++ 76 files changed, 1186 insertions(+), 48 deletions(-) diff --git a/xml/schema/ACL/ACL.xml b/xml/schema/ACL/ACL.xml index a78f227221..e555468ec4 100644 --- a/xml/schema/ACL/ACL.xml +++ b/xml/schema/ACL/ACL.xml @@ -24,7 +24,10 @@ varchar 64 ACL Name. - 1.6 + + Text + + 1.6 deny @@ -32,7 +35,10 @@ 0 true Is this ACL entry Allow (0) or Deny (1) ? - 1.6 + + Radio + + 1.6 entity_table @@ -59,7 +65,10 @@ All,View,Edit,Create,Delete,Grant,Revoke,Search true What operation does this ACL entry control? - 1.6 + + Select + + 1.6 object_table @@ -79,7 +88,7 @@ varchar 64 If this is a grant/revoke entry, what table are we granting? - 1.6 + 1.6 acl_id @@ -97,5 +106,8 @@ boolean Is this property active? 1.6 + + Checkbox + diff --git a/xml/schema/Activity/Activity.xml b/xml/schema/Activity/Activity.xml index 544b8c616a..6b2e9b40a0 100644 --- a/xml/schema/Activity/Activity.xml +++ b/xml/schema/Activity/Activity.xml @@ -15,6 +15,7 @@ true Unique Other Activity ID 1.1 + id @@ -73,7 +74,7 @@ Select - + UI_activity_type_id @@ -194,6 +195,9 @@ Phone (called) ID Phone ID of the number called (optional - used if an existing phone number is selected). 2.0 + + Autocomplete-Select + phone_id @@ -255,8 +259,8 @@ activity_status - Select - + Select + priority_id @@ -268,7 +272,7 @@ priority - Select + Select @@ -295,6 +299,9 @@ true /(is.)?test(.activity)?/i 2.0 + + Select + medium_id @@ -307,7 +314,7 @@ encounter_medium - Select + Select 2.2 @@ -345,6 +352,9 @@ true /(is.)?(current.)?(revision|version(ing)?)/i 2.2 + + CheckBox + index_is_current_revision @@ -392,6 +402,9 @@ true /(activity.)?(trash|deleted)/i 2.2 + + Text + index_is_deleted @@ -405,10 +418,10 @@ Campaign ID true The campaign for which this activity has been triggered. - - Select - 3.4 + + CheckBox + campaign_id @@ -427,7 +440,7 @@ engagement_index - Select + Select 3.4 @@ -435,5 +448,8 @@ weight int 4.1 + + Text + diff --git a/xml/schema/Activity/ActivityContact.xml b/xml/schema/Activity/ActivityContact.xml index 1cb6a72885..638a06fb7a 100644 --- a/xml/schema/Activity/ActivityContact.xml +++ b/xml/schema/Activity/ActivityContact.xml @@ -58,6 +58,9 @@ activity_contacts + + Select> + 4.4 diff --git a/xml/schema/Batch/Batch.xml b/xml/schema/Batch/Batch.xml index 85523e8186..02329d0d80 100644 --- a/xml/schema/Batch/Batch.xml +++ b/xml/schema/Batch/Batch.xml @@ -23,6 +23,9 @@ 64 Variable name/programmatic handle for this batch. 3.3 + + Text + UI_name @@ -46,6 +49,9 @@ true Friendly Name. 4.2 + + Text + description @@ -77,6 +83,9 @@ datetime When was this item created 3.3 + + Select Date + modified_id @@ -102,6 +111,9 @@ int unsigned FK to Saved Search ID 4.1 + + Autocomplete-Select + saved_search_id @@ -119,6 +131,9 @@ batch_status + + Select> + type_id @@ -128,6 +143,9 @@ batch_type + + Select> + mode_id @@ -137,18 +155,27 @@ batch_mode + + Select> + total decimal Total amount for this batch. 4.2 + + Text + item_count int unsigned Number of items in a batch. 4.2 + + Text + payment_instrument_id @@ -157,6 +184,9 @@ payment_instrument + + Select> + 4.3 diff --git a/xml/schema/Bridge/OG.xml b/xml/schema/Bridge/OG.xml index 5e335c68d5..225cdc192c 100644 --- a/xml/schema/Bridge/OG.xml +++ b/xml/schema/Bridge/OG.xml @@ -39,6 +39,9 @@ id title + + Select> + group_id @@ -70,6 +73,9 @@ id title + + Select> + admin_group_id diff --git a/xml/schema/Bridge/Role.xml b/xml/schema/Bridge/Role.xml index 99586735a0..275163ece8 100644 --- a/xml/schema/Bridge/Role.xml +++ b/xml/schema/Bridge/Role.xml @@ -39,6 +39,9 @@ id title + + Select> + group_id diff --git a/xml/schema/Campaign/Campaign.xml b/xml/schema/Campaign/Campaign.xml index a5c6ab0a3f..eb591427a3 100644 --- a/xml/schema/Campaign/Campaign.xml +++ b/xml/schema/Campaign/Campaign.xml @@ -96,6 +96,9 @@ campaign_type + + Select> + 3.3 @@ -114,6 +117,9 @@ campaign_status + + Select> + 3.3 @@ -131,6 +137,9 @@ Unique trusted external ID (generally from a legacy app/datasource). Particularly useful for deduping operations. true 3.3 + + Text + UI_external_identifier @@ -146,6 +155,9 @@ Optional parent id for this Campaign. true 3.3 + + Autocomplete-Select + parent_id @@ -161,6 +173,9 @@ 1 Is this Campaign enabled or disabled/cancelled? 3.3 + + CheckBox + @@ -183,6 +198,9 @@ Campaign Created Date Date and time that Campaign was created. 3.3 + + Select Date + @@ -211,11 +229,17 @@ Campaign Goals General goals for Campaign. 3.4 + + RichTextEditor + goal_revenue decimal The target revenue for this campaign. 3.4 + + Text + diff --git a/xml/schema/Campaign/CampaignGroup.xml b/xml/schema/Campaign/CampaignGroup.xml index b8cd70bd45..ad48bcd147 100644 --- a/xml/schema/Campaign/CampaignGroup.xml +++ b/xml/schema/Campaign/CampaignGroup.xml @@ -39,6 +39,9 @@ Include, Exclude NULL Type of Group. + + Select + diff --git a/xml/schema/Campaign/Survey.xml b/xml/schema/Campaign/Survey.xml index 0068aabefa..2e3c2ab840 100644 --- a/xml/schema/Campaign/Survey.xml +++ b/xml/schema/Campaign/Survey.xml @@ -55,6 +55,9 @@ activity_type + + Select> + UI_activity_type_id diff --git a/xml/schema/Case/Case.xml b/xml/schema/Case/Case.xml index 0227e20664..0dab82c517 100644 --- a/xml/schema/Case/Case.xml +++ b/xml/schema/Case/Case.xml @@ -49,6 +49,9 @@ case_type + + Select> + 2.0 @@ -109,7 +112,10 @@ true case_subject Short name of the case. - 1.8 + + Text + + 1.8 start_date @@ -118,6 +124,9 @@ true date Date on which given case starts. + + Select Date + 1.8 @@ -127,6 +136,9 @@ true date Date on which given case ends. + + Select Date + 1.8 @@ -152,6 +164,9 @@ case_status + + Select> + 1.8 diff --git a/xml/schema/Case/CaseContact.xml b/xml/schema/Case/CaseContact.xml index b454e4e101..da3c773b6b 100644 --- a/xml/schema/Case/CaseContact.xml +++ b/xml/schema/Case/CaseContact.xml @@ -37,7 +37,10 @@ case_contact_id true Contact ID of contact record given case belongs to. - 2.1 + + Autocomplete-Select + + 2.1 contact_id diff --git a/xml/schema/Contact/ACLContactCache.xml b/xml/schema/Contact/ACLContactCache.xml index 55b1112966..0dd4183d7c 100644 --- a/xml/schema/Contact/ACLContactCache.xml +++ b/xml/schema/Contact/ACLContactCache.xml @@ -51,6 +51,9 @@ true What operation does this user have permission on? 1.6 + + Select + UI_user_contact_operation diff --git a/xml/schema/Contact/Contact.xml b/xml/schema/Contact/Contact.xml index 6c90dc3b98..c3ed59ca4f 100644 --- a/xml/schema/Contact/Contact.xml +++ b/xml/schema/Contact/Contact.xml @@ -34,6 +34,9 @@ label parent_id IS NULL + + Select> + 1.1 3.1 @@ -57,11 +60,17 @@ label parent_id IS NOT NULL + + Multi-Select + 1.5 index_contact_sub_type contact_sub_type + + Multi-Select + 2.1 @@ -71,6 +80,9 @@ /d(o )?(not )?(email)/i /^\d{1,}$/ 0 + + CheckBox + 1.1 @@ -81,6 +93,9 @@ /d(o )?(not )?(call|phone)/i /^\d{1,}$/ 1.1 + + CheckBox + do_not_mail @@ -90,6 +105,9 @@ /^\d{1,}$/ 0 1.1 + + CheckBox + do_not_sms @@ -99,6 +117,9 @@ /^\d{1,}$/ 0 3.0 + + CheckBox + do_not_trade @@ -108,6 +129,9 @@ /^\d{1,}$/ 0 1.1 + + CheckBox + is_opt_out @@ -118,6 +142,9 @@ true Has the contact opted out from receiving all bulk email from the organization or site domain? 1.1 + + CheckBox + legal_identifier @@ -128,12 +155,19 @@ /\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 - EIGHT + + Text + EIGHT + + true /external\s?id/i /^\d{11,}$/ @@ -151,7 +185,11 @@ Sort Name varchar 128 - BIG + + Text + BIG + + true Name used for sorting different contact types 1.1 @@ -166,7 +204,11 @@ Display Name varchar 128 - BIG + + Text + BIG + + true Formatted name representing preferred format for display/print/other output. 1.1 @@ -176,7 +218,11 @@ Nickname varchar 128 - BIG + + Text + BIG + + true /n(ick\s)name|nick$/i /^\w+$/ @@ -188,7 +234,11 @@ legal_name varchar 128 - BIG + + Text + BIG + + true /^legal|(l(egal\s)?name)$/i Legal Name. @@ -201,7 +251,11 @@ Website varchar 128 - BIG + + Text + BIG + + true /^(home\sURL)|URL|web|site/i /^[\w\/\:\.]+$/ @@ -216,6 +270,9 @@ true optional URL for preferred image (photo, logo, etc.) to display for this contact. 1.1 + + Text + preferred_communication_method @@ -230,6 +287,9 @@ preferred_communication_method + + Select> + index_preferred_communication_method @@ -248,6 +308,9 @@ languages name + + Select> + 3.2 @@ -259,6 +322,9 @@ /^p(ref\w*\s)?m(ail\s)?f(orm\w*)$/i What is the preferred mode of sending an email. 1.1 + + Select + hash @@ -293,7 +359,11 @@ contact_source varchar 255 - BIG + + Text + BIG + + true /(S(ource\s)?o(f\s)?C(ontact\s)?Data)$/i where contact come from, e.g. import, donate module insert... @@ -303,7 +373,10 @@ first_name varchar 64 - BIG + + Text + BIG + true /^first|(f(irst\s)?name)$/i /^\w+$/ @@ -320,7 +393,10 @@ middle_name varchar 64 - MEDIUM + + Text + MEDIUM + true /^middle|(m(iddle\s)?name)$/i /^\w+$/ @@ -332,7 +408,10 @@ last_name varchar 64 - BIG + + Text + BIG + true /^last|(l(ast\s)?name)$/i /^\w+(\s\w+)?+$/ @@ -344,6 +423,9 @@ index_last_name last_name 1.8 + + Text + prefix_id @@ -353,6 +435,9 @@ individual_prefix + + Select> + /^(prefix|title)/i /^(mr|ms|mrs|sir|dr)\.?$/i true @@ -370,6 +455,9 @@ individual_suffix + + Select> + true Suffix for name (Jr, Sr...). FK to suffix ID /^suffix$/i @@ -422,6 +510,9 @@ false Custom Email Greeting. 3.0 + + Text + email_greeting_display @@ -430,6 +521,9 @@ 255 Cache Email Greeting. 3.0 + + Text + postal_greeting_id @@ -437,6 +531,9 @@ Postal Greeting ID FK to civicrm_option_value.id, that has to be valid registered Postal Greeting. 3.0 + + Text + postal_greeting_custom @@ -446,6 +543,9 @@ false Custom Postal greeting. 3.0 + + Text + postal_greeting_display @@ -454,6 +554,9 @@ 255 Cache Postal greeting. 3.0 + + Text + addressee_id @@ -470,6 +573,9 @@ false Custom Addressee. 3.0 + + Text + addressee_display @@ -478,12 +584,18 @@ 255 Cache Addressee. 3.0 + + Text + job_title varchar 255 - MEDIUM + + Text + MEDIUM + true /^job|(j(ob\s)?title)$/i // @@ -497,6 +609,9 @@ gender + + Select> + /^gender$/i FK to gender ID true @@ -506,6 +621,9 @@ UI_gender gender_id 1.6 + + Select + birth_date @@ -515,6 +633,9 @@ /\d{4}-?\d{2}-?\d{2}/ Date of birth 1.1 + + Select Date + is_deceased @@ -525,6 +646,9 @@ boolean 0 1.1 + + CheckBox + deceased_date @@ -534,6 +658,9 @@ /^deceased|(d(eceased\s)?date)$/i Date of deceased 1.5 + + Select Date + mail_to_household_id @@ -556,7 +683,10 @@ household_name varchar 128 - BIG + + Text + BIG + true /^household|(h(ousehold\s)?name)$/i /^\w+$/ @@ -575,6 +705,9 @@ Household Primary Contact ID Optional FK to Primary Contact for this household. 1.1 + + Select + primary_contact_id @@ -587,7 +720,10 @@ organization_name varchar 128 - BIG + + Text + BIG + true /^organization|(o(rganization\s)?name)$/i /^\w+$/ @@ -608,6 +744,9 @@ /^sic|(s(ic\s)?code)$/i Standard Industry Classification Code. 1.1 + + Text + user_unique_id @@ -620,6 +759,9 @@ /^[\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 @@ -629,6 +771,9 @@ OPTIONAL FK to civicrm_contact record. true 2.1 + + Autocomplete-Select + employer_id @@ -646,6 +791,9 @@ true true 3.2 + + CheckBox + index_is_deleted diff --git a/xml/schema/Contact/Group.xml b/xml/schema/Contact/Group.xml index 4f425fe53a..abceb8ed5e 100644 --- a/xml/schema/Contact/Group.xml +++ b/xml/schema/Contact/Group.xml @@ -85,6 +85,9 @@ 'User and User Admin Only' In what context(s) is this field visible. 1.2 + + Select + where_clause diff --git a/xml/schema/Contact/GroupContact.xml b/xml/schema/Contact/GroupContact.xml index 5aed17d81b..872e42ba52 100644 --- a/xml/schema/Contact/GroupContact.xml +++ b/xml/schema/Contact/GroupContact.xml @@ -31,6 +31,9 @@ id title + + Select> + group_id @@ -61,6 +64,9 @@ Added, Removed, Pending status of contact relative to membership in group 1.1 + + Select + location_id diff --git a/xml/schema/Contact/GroupContactCache.xml b/xml/schema/Contact/GroupContactCache.xml index 893b0e03d8..52e9e367ed 100644 --- a/xml/schema/Contact/GroupContactCache.xml +++ b/xml/schema/Contact/GroupContactCache.xml @@ -28,6 +28,9 @@ id title + + Select> + group_id diff --git a/xml/schema/Contact/GroupOrganization.xml b/xml/schema/Contact/GroupOrganization.xml index 1f8afa6137..7971151eb4 100644 --- a/xml/schema/Contact/GroupOrganization.xml +++ b/xml/schema/Contact/GroupOrganization.xml @@ -29,6 +29,9 @@ id title + + Select> + group_id diff --git a/xml/schema/Contact/RelationshipType.xml b/xml/schema/Contact/RelationshipType.xml index 8a60e75ed0..92f3df9264 100644 --- a/xml/schema/Contact/RelationshipType.xml +++ b/xml/schema/Contact/RelationshipType.xml @@ -66,6 +66,9 @@ Individual, Organization, Household If defined, contact_a in a relationship of this type must be a specific contact_type. 1.1 + + Select + contact_type_b @@ -74,6 +77,9 @@ Individual, Organization, Household If defined, contact_b in a relationship of this type must be a specific contact_type. 1.1 + + Select + contact_sub_type_a @@ -82,6 +88,9 @@ 64 If defined, contact_sub_type_a in a relationship of this type must be a specific contact_sub_type. 3.1 + + Multi-Select + contact_sub_type_b @@ -90,6 +99,9 @@ 64 If defined, contact_sub_type_b in a relationship of this type must be a specific contact_sub_type. 3.1 + + Multi-Select + is_reserved diff --git a/xml/schema/Contact/SubscriptionHistory.xml b/xml/schema/Contact/SubscriptionHistory.xml index f308694092..1875809516 100644 --- a/xml/schema/Contact/SubscriptionHistory.xml +++ b/xml/schema/Contact/SubscriptionHistory.xml @@ -42,6 +42,9 @@ id title + + Select> + group_id @@ -63,6 +66,9 @@ Admin, Email, Web, API How the (un)subscription was triggered 1.1 + + Select + status diff --git a/xml/schema/Contribute/Contribution.xml b/xml/schema/Contribute/Contribution.xml index 902ddf529d..3b9612bfcb 100644 --- a/xml/schema/Contribute/Contribution.xml +++ b/xml/schema/Contribute/Contribution.xml @@ -30,6 +30,9 @@ /contact(.?id)?/i /^\d+$/ FK to Contact ID + + Autocomplete-Select + 1.3 @@ -83,6 +86,9 @@ id name + + Select> + 4.3 @@ -102,6 +108,9 @@ id title + + Select> + 1.5 @@ -119,6 +128,9 @@ payment_instrument + + Select> + 1.3 @@ -134,6 +146,9 @@ /^\d{4}-?\d{2}-?\d{2} ?(\d{2}:?\d{2}:?(\d{2})?)?$/ when was gift received 1.3 + + Select Date + non_deductible_amount @@ -145,6 +160,9 @@ /^\d+(\.\d{2})?$/ Portion of total amount which is NOT tax deductible. Equal to total_amount for non-deductible financial types. 1.3 + + Text + total_amount @@ -155,6 +173,9 @@ /^\d+(\.\d{2})?$/ Total amount of this contribution. Use market value for non-monetary gifts. 1.3 + + Text + fee_amount @@ -164,6 +185,9 @@ /^\d+(\.\d{2})?$/ actual processor fee if known - may be 0. 1.3 + + Text + net_amount @@ -173,6 +197,9 @@ /^\d+(\.\d{2})?$/ actual funds transfer amount. total less fees. if processor does not report actual fee during transaction, this is set to total_amount. 1.3 + + Text + trxn_id @@ -182,6 +209,9 @@ true /tr(ansactio|x)n(.?id)?/i unique transaction id. may be processor id, bank id + trans id, or account number + check number... depending on payment_method + + Text + 1.3 @@ -192,8 +222,11 @@ true /invoice(.?id)?/i unique invoice id, system generated or passed in + + Text + 1.3 - + currency varchar @@ -210,6 +243,9 @@ full_name numeric_code + + Select> + cancel_date @@ -219,13 +255,19 @@ /^\d{4}-?\d{2}-?\d{2} ?(\d{2}:?\d{2}:?(\d{2})?)?$/ when was gift cancelled 1.3 + + Select Date + cancel_reason text true /(cancel.?)?reason/i - 1.3 + + Text + + 1.3 receipt_date @@ -234,7 +276,10 @@ /receipt(.?date)?/i /^\d{4}-?\d{2}-?\d{2} ?(\d{2}:?\d{2}:?(\d{2})?)?$/ when (if) receipt was sent. populated automatically for online donations w/ automatic receipting - 1.3 + + Select Date + + 1.3 thankyou_date @@ -245,6 +290,9 @@ /^\d{4}-?\d{2}-?\d{2} ?(\d{2}:?\d{2}:?(\d{2})?)?$/ when (if) was donor thanked 1.3 + + Select Date + source @@ -256,6 +304,9 @@ /source/i Origin of this Contribution. 1.3 + + Text + amount_level @@ -263,16 +314,14 @@ text true 1.7 + + Text + note text Note and/or Comment. - - TextArea - 4 - 80 - true /Note|Comment/i // @@ -310,6 +359,9 @@ int unsigned FK to contact ID 1.3 + + Autocomplete-Select + honor_contact_id @@ -324,6 +376,9 @@ boolean 0 true + + CheckBox + is_pay_later @@ -332,6 +387,9 @@ 0 true 2.1 + + CheckBox + contribution_status_id @@ -344,6 +402,9 @@ contribution_status + + Select> + 1.6 @@ -356,6 +417,9 @@ honor_type + + Select> + index_contribution_status @@ -386,7 +450,10 @@ /check(.?number)?/i varchar 255 - SIX + + Text + SIX + true 2.2 @@ -403,6 +470,9 @@ true The campaign for which this contribution has been triggered. 3.4 + + Select + campaign_id diff --git a/xml/schema/Contribute/ContributionPage.xml b/xml/schema/Contribute/ContributionPage.xml index eede149bf4..9103892d95 100644 --- a/xml/schema/Contribute/ContributionPage.xml +++ b/xml/schema/Contribute/ContributionPage.xml @@ -61,6 +61,9 @@ id name + + Select> + 4.3 @@ -79,6 +82,9 @@ id name + + Select> + 1.8 @@ -413,6 +419,9 @@ full_name numeric_code + + Select> + campaign_id diff --git a/xml/schema/Contribute/ContributionRecur.xml b/xml/schema/Contribute/ContributionRecur.xml index 01602426f1..3d217b1fa9 100644 --- a/xml/schema/Contribute/ContributionRecur.xml +++ b/xml/schema/Contribute/ContributionRecur.xml @@ -54,6 +54,9 @@ full_name numeric_code + + Select> + frequency_unit @@ -63,6 +66,9 @@ 'month' Time units for recurrence of payment. 1.6 + + Select + frequency_interval @@ -273,6 +279,9 @@ payment_instrument + + Select> + 4.1 diff --git a/xml/schema/Contribute/ContributionSoft.xml b/xml/schema/Contribute/ContributionSoft.xml index 36c68bb1ca..9b87aa4148 100644 --- a/xml/schema/Contribute/ContributionSoft.xml +++ b/xml/schema/Contribute/ContributionSoft.xml @@ -76,6 +76,9 @@ full_name numeric_code + + Select> + pcp_id diff --git a/xml/schema/Contribute/Product.xml b/xml/schema/Contribute/Product.xml index b3b344575c..4583992042 100644 --- a/xml/schema/Contribute/Product.xml +++ b/xml/schema/Contribute/Product.xml @@ -90,6 +90,9 @@ full_name numeric_code + + Select> + financial_type_id @@ -138,6 +141,9 @@ 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 + + Select + fixed_period_start_day @@ -154,6 +160,9 @@ day,month,week,year 'year' 1.4 + + Select + duration_interval @@ -170,6 +179,9 @@ 'month' Frequency unit and interval allow option to store actual delivery frequency for a subscription or service. 1.4 + + Select + frequency_interval diff --git a/xml/schema/Core/ActionSchedule.xml b/xml/schema/Core/ActionSchedule.xml index fa6bf4b7f9..e0a0084312 100644 --- a/xml/schema/Core/ActionSchedule.xml +++ b/xml/schema/Core/ActionSchedule.xml @@ -72,6 +72,9 @@ hour,day,week,month,year Time units for reminder. 3.4 + + Select + start_action_condition @@ -100,6 +103,9 @@ hour,day,week,month,year Time units for repetition of reminder. 3.4 + + Select + repetition_frequency_interval @@ -113,6 +119,9 @@ hour,day,week,month,year Time units till repetition of reminder. 3.4 + + Select + end_frequency_interval @@ -204,6 +213,9 @@ id title + + Select> + 3.4 diff --git a/xml/schema/Core/Address.xml b/xml/schema/Core/Address.xml index 2f1a000c23..9bcd70c28c 100644 --- a/xml/schema/Core/Address.xml +++ b/xml/schema/Core/Address.xml @@ -42,6 +42,9 @@ id display_name + + Select> + index_location_type @@ -195,6 +198,9 @@ id name + + Select> + 1.1 @@ -217,6 +223,9 @@ id name + + Select> + 1.1 @@ -269,6 +278,9 @@ name iso_code + + Select> + 1.1 diff --git a/xml/schema/Core/Cache.xml b/xml/schema/Core/Cache.xml index 8368ad228a..b68ce573e5 100644 --- a/xml/schema/Core/Cache.xml +++ b/xml/schema/Core/Cache.xml @@ -63,6 +63,9 @@ id name + + Select> + component_id diff --git a/xml/schema/Core/CustomField.xml b/xml/schema/Core/CustomField.xml index d38c353a5e..e0d8e6d378 100644 --- a/xml/schema/Core/CustomField.xml +++ b/xml/schema/Core/CustomField.xml @@ -29,6 +29,9 @@ id title + + Select> + custom_group_id @@ -60,6 +63,9 @@ true Controls location of data storage in extended_data table. 1.1 + + Select + html_type diff --git a/xml/schema/Core/CustomGroup.xml b/xml/schema/Core/CustomGroup.xml index 3ccd747fad..3e2319bb48 100644 --- a/xml/schema/Core/CustomGroup.xml +++ b/xml/schema/Core/CustomGroup.xml @@ -71,6 +71,9 @@ Tab, Inline Visual relationship between this form and its parent. 1.1 + + Select + collapse_display diff --git a/xml/schema/Core/Email.xml b/xml/schema/Core/Email.xml index c7857c66c0..9fa605ab93 100644 --- a/xml/schema/Core/Email.xml +++ b/xml/schema/Core/Email.xml @@ -42,6 +42,9 @@ id display_name + + Select> + index_location_type @@ -52,7 +55,10 @@ email varchar 254 - MEDIUM + + Text + MEDIUM + true /e.?mail/i /^[a-zA-Z][\w\.-]*[a-zA-Z0-9]@[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-Z]$/ diff --git a/xml/schema/Core/EntityTag.xml b/xml/schema/Core/EntityTag.xml index bc1e2529f2..aa39274081 100644 --- a/xml/schema/Core/EntityTag.xml +++ b/xml/schema/Core/EntityTag.xml @@ -74,6 +74,9 @@ id name + + Select> + tag_id diff --git a/xml/schema/Core/Extension.xml b/xml/schema/Core/Extension.xml index a4e4e3204a..00ccaea284 100644 --- a/xml/schema/Core/Extension.xml +++ b/xml/schema/Core/Extension.xml @@ -25,6 +25,9 @@ true 4.2 + + Select + diff --git a/xml/schema/Core/IM.xml b/xml/schema/Core/IM.xml index fbe0805d25..bd3d858f7b 100644 --- a/xml/schema/Core/IM.xml +++ b/xml/schema/Core/IM.xml @@ -63,6 +63,9 @@ instant_messenger_service + + Select> + UI_provider_id diff --git a/xml/schema/Core/Job.xml b/xml/schema/Core/Job.xml index 71561a5cbd..1398135699 100644 --- a/xml/schema/Core/Job.xml +++ b/xml/schema/Core/Job.xml @@ -38,6 +38,9 @@ "Daily" Scheduled job run frequency. 4.1 + + Select + last_run diff --git a/xml/schema/Core/MailSettings.xml b/xml/schema/Core/MailSettings.xml index 49530292b2..a12f2aeacf 100644 --- a/xml/schema/Core/MailSettings.xml +++ b/xml/schema/Core/MailSettings.xml @@ -65,6 +65,9 @@ mail_protocol + + Select> + server diff --git a/xml/schema/Core/Mapping.xml b/xml/schema/Core/Mapping.xml index ee570c0fa7..af4b4203a1 100644 --- a/xml/schema/Core/Mapping.xml +++ b/xml/schema/Core/Mapping.xml @@ -48,6 +48,9 @@ mapping_type + + Select> + UI_name diff --git a/xml/schema/Core/MappingField.xml b/xml/schema/Core/MappingField.xml index 21882a9ee4..072f379731 100644 --- a/xml/schema/Core/MappingField.xml +++ b/xml/schema/Core/MappingField.xml @@ -48,6 +48,9 @@ name label + + Select> + 1.2 @@ -91,6 +94,9 @@ instant_messenger_service + + Select> + website_type_id @@ -100,6 +106,9 @@ website_type + + Select> + relationship_type_id @@ -133,6 +142,9 @@ IN, NOT IN, LIKE, NOT LIKE, IS NULL, IS NOT NULL SQL WHERE operator for search-builder mapping fields (search criteria). 1.5 + + Select + value diff --git a/xml/schema/Core/Menu.xml b/xml/schema/Core/Menu.xml index 09d1786e6d..3d357f20d3 100644 --- a/xml/schema/Core/Menu.xml +++ b/xml/schema/Core/Menu.xml @@ -112,6 +112,9 @@ id name + + Select> + component_id diff --git a/xml/schema/Core/OptionValue.xml b/xml/schema/Core/OptionValue.xml index d6a1347fbe..7bfdc282d2 100644 --- a/xml/schema/Core/OptionValue.xml +++ b/xml/schema/Core/OptionValue.xml @@ -28,6 +28,9 @@ id name + + Select> + option_group_id @@ -136,6 +139,9 @@ id name + + Select> + component_id diff --git a/xml/schema/Core/Phone.xml b/xml/schema/Core/Phone.xml index 11b3a078d4..2f730de447 100644 --- a/xml/schema/Core/Phone.xml +++ b/xml/schema/Core/Phone.xml @@ -41,6 +41,9 @@ id display_name + + Select> + 2.0 @@ -99,7 +102,10 @@ Phone Extension varchar 16 - FOUR + + Text + FOUR + true true /extension/i @@ -137,6 +143,9 @@ phone_type + + Select> + 2.2 diff --git a/xml/schema/Core/PrintLabel.xml b/xml/schema/Core/PrintLabel.xml index fa22cd043f..2ae2e830b5 100644 --- a/xml/schema/Core/PrintLabel.xml +++ b/xml/schema/Core/PrintLabel.xml @@ -45,6 +45,9 @@ name_badge + + Select> + This refers to name column of civicrm_option_value row in name_badge option group 4.4 @@ -54,6 +57,9 @@ label_type + + Select> + Implicit FK to civicrm_option_value row in NEW label_type option group 4.4 diff --git a/xml/schema/Core/Setting.xml b/xml/schema/Core/Setting.xml index 0d22f70a25..836dc50bae 100644 --- a/xml/schema/Core/Setting.xml +++ b/xml/schema/Core/Setting.xml @@ -86,6 +86,9 @@ id name + + Select> + component_id diff --git a/xml/schema/Core/UFField.xml b/xml/schema/Core/UFField.xml index 47eafa0a65..5e09624299 100644 --- a/xml/schema/Core/UFField.xml +++ b/xml/schema/Core/UFField.xml @@ -29,6 +29,9 @@ id title + + Select> + uf_group_id @@ -111,6 +114,9 @@ 'User and User Admin Only' In what context(s) is this field visible. 1.1 + + Select + listings_title diff --git a/xml/schema/Core/UFJoin.xml b/xml/schema/Core/UFJoin.xml index f8cace84bd..120ddfc68c 100644 --- a/xml/schema/Core/UFJoin.xml +++ b/xml/schema/Core/UFJoin.xml @@ -77,6 +77,9 @@ id title + + Select> + uf_group_id diff --git a/xml/schema/Core/Website.xml b/xml/schema/Core/Website.xml index ab79cfe66b..661268f364 100644 --- a/xml/schema/Core/Website.xml +++ b/xml/schema/Core/Website.xml @@ -35,7 +35,10 @@ Website varchar 128 - BIG + + Text + BIG + true /Website/i /^[A-Za-z][0-9A-Za-z]{20,}$/ @@ -51,6 +54,9 @@ website_type + + Select> + UI_website_type_id diff --git a/xml/schema/Core/WordReplacement.xml b/xml/schema/Core/WordReplacement.xml index e19d764234..d4180a55d7 100644 --- a/xml/schema/Core/WordReplacement.xml +++ b/xml/schema/Core/WordReplacement.xml @@ -50,6 +50,9 @@ wildcardMatch, exactMatch "wildcardMatch" 4.4 + + Select + domain_id diff --git a/xml/schema/Dedupe/RuleGroup.xml b/xml/schema/Dedupe/RuleGroup.xml index 6dc6355bc6..979c732e3e 100644 --- a/xml/schema/Dedupe/RuleGroup.xml +++ b/xml/schema/Dedupe/RuleGroup.xml @@ -22,6 +22,9 @@ Individual, Organization, Household The type of contacts this group applies to 1.8 + + Select + threshold @@ -45,6 +48,9 @@ true Whether the rule should be used for cases where usage is Unsupervised, Supervised OR General(programatically) 4.3 + + Select + is_default diff --git a/xml/schema/Event/Event.xml b/xml/schema/Event/Event.xml index 6be7c1b901..bb92ce1d4c 100644 --- a/xml/schema/Event/Event.xml +++ b/xml/schema/Event/Event.xml @@ -28,6 +28,9 @@ 255 true Event Title (e.g. Fall Fundraiser Dinner) + + Text + 1.7 @@ -66,6 +69,9 @@ event_type + + Select> + Event Type ID.Implicit FK to civicrm_option_value where option_group = event_type. 1.7 @@ -82,6 +88,9 @@ 0 Should we expose the participant list? Implicit FK to civicrm_option_value where option_group = participant_listing. 2.0 + + Select + index_participant_listing_id @@ -95,6 +104,9 @@ 1 Public events will be included in the iCal feeds. Access to private event information may be limited using ACLs. 1.7 + + CheckBox + start_date @@ -105,6 +117,9 @@ true Date and time that event starts. 1.7 + + Select Date + end_date @@ -115,6 +130,9 @@ true Date and time that event ends. May be NULL if no defined end date/time 1.7 + + Select Date + is_online_registration @@ -123,6 +141,9 @@ 0 If true, include registration link on Event Info page. 1.7 + + CheckBox + registration_link_text @@ -132,18 +153,27 @@ true Text for link to Event Registration form which is displayed on Event Information screen when is_online_registration is true. 1.7 + + Text + registration_start_date datetime Date and time that online registration starts. 1.8 + + Select Date + registration_end_date datetime Date and time that online registration ends. 1.8 + + Select Date + max_participants @@ -152,6 +182,9 @@ NULL Maximum number of registered participants to allow. After max is reached, a custom Event Full message is displayed. If NULL, allow unlimited number of participants. 1.7 + + Text + event_full_text @@ -173,6 +206,9 @@ 0 If true, one or more fee amounts must be set and a Payment Processor must be configured for Online Event Registration. 1.7 + + CheckBox + contribution_type_id @@ -193,6 +229,9 @@ id name + + Select> + 4.3 @@ -205,6 +244,9 @@ id name + + Select> + 1.8 @@ -214,6 +256,9 @@ 0 Include a map block on the Event Information page when geocode info is available and a mapping provider has been specified? 1.7 + + CheckBox + is_active @@ -222,6 +267,9 @@ 0 Is this Event enabled or disabled/cancelled? 1.7 + + CheckBox + fee_label @@ -231,6 +279,9 @@ /^fee|(f(ee\s)?label)$/i 255 true + + Text + 1.8 @@ -240,6 +291,9 @@ 1 If true, show event location. 1.7 + + CheckBox + loc_block_id @@ -277,6 +331,9 @@ 1 Participant role ID. Implicit FK to civicrm_option_value where option_group = participant_role. 2.0 + + Select + intro_text @@ -312,6 +369,9 @@ NULL true Title for Confirmation page. + + Text + 1.7 @@ -347,6 +407,9 @@ 0 If true, confirmation is automatically emailed to contact on successful registration. 1.7 + + CheckBox + confirm_email_text @@ -369,6 +432,9 @@ true FROM email name used for confirmation emails. 1.7 + + Text + confirm_from_email @@ -377,12 +443,18 @@ 255 FROM email address used for confirmation emails. 1.7 + + Text + cc_confirm varchar 255 comma-separated list of email addresses to cc each time a confirmation is sent + + Text + 1.7 @@ -390,6 +462,9 @@ varchar 255 comma-separated list of email addresses to bcc each time a confirmation is sent + + Text + 1.7 @@ -415,6 +490,9 @@ true Title for ThankYou page. 1.7 + + Text + thankyou_text @@ -449,6 +527,9 @@ 0 if true - allows the user to send payment directly to the org later 2.0 + + CheckBox + pay_later_text @@ -457,6 +538,9 @@ true The text displayed to the user in the main form 2.0 + + Text + pay_later_receipt @@ -465,6 +549,9 @@ true The receipt sent to the user instead of the normal receipt text 2.0 + + Text + is_partial_payment @@ -473,6 +560,9 @@ 0 is partial payment enabled for this event 4.3 + + CheckBox + initial_amount_label @@ -482,6 +572,9 @@ true Initial amount label for partial payment 4.3 + + Text + initial_amount_help_text @@ -490,6 +583,9 @@ true Initial amount help text for partial payment 4.3 + + Text + min_initial_amount @@ -497,6 +593,9 @@ decimal Minimum initial amount for partial payment 4.3 + + Text + is_multiple_registrations @@ -505,6 +604,9 @@ 0 if true - allows the user to register multiple participants for event 2.1 + + CheckBox + allow_same_participant_emails @@ -513,6 +615,9 @@ 0 if true - allows the user to register multiple registrations from same email address. 2.2 + + CheckBox + has_waitlist @@ -520,18 +625,27 @@ boolean Whether the event has waitlist support. 3.0 + + CheckBox + requires_approval boolean Whether participants require approval before they can finish registering. 3.0 + + CheckBox + expiration_time int unsigned Expire pending but unconfirmed registrations after this many hours. 3.0 + + Text + waitlist_text @@ -564,6 +678,9 @@ 0 whether the event has template 3.0 + + CheckBox + template_title @@ -575,6 +692,9 @@ 255 true Event Template Title + + Text + 3.0 @@ -613,6 +733,9 @@ full_name numeric_code + + Select> + campaign_id @@ -620,6 +743,9 @@ Campaign ID The campaign for which this event has been created. 3.4 + + Autocomplete-Select + campaign_id @@ -634,6 +760,9 @@ 1 Can people share the event through social media? 4.1 + + CheckBox + parent_event_id @@ -641,6 +770,9 @@ Parent Event ID NULL Implicit FK to civicrm_event: parent event + + Autocomplete-Select + 4.1 @@ -655,5 +787,8 @@ NULL Subevent slot label. Implicit FK to civicrm_option_value where option_group = conference_slot. 4.1 + + Select + diff --git a/xml/schema/Event/Participant.xml b/xml/schema/Event/Participant.xml index 728bf474f4..b4d2a742b3 100644 --- a/xml/schema/Event/Participant.xml +++ b/xml/schema/Event/Participant.xml @@ -71,6 +71,9 @@ id label + + Select> + status_id @@ -90,6 +93,9 @@ participant_role + + Select> + /(participant.)?(role)$/i true varchar @@ -218,6 +224,9 @@ full_name numeric_code + + Select> + campaign_id diff --git a/xml/schema/Event/ParticipantStatusType.xml b/xml/schema/Event/ParticipantStatusType.xml index 55b67ceafd..b53cbf937a 100644 --- a/xml/schema/Event/ParticipantStatusType.xml +++ b/xml/schema/Event/ParticipantStatusType.xml @@ -43,6 +43,9 @@ Positive, Pending, Waiting, Negative the general group of status type this one belongs to 3.0 + + Select + is_reserved @@ -78,5 +81,8 @@ visibility + + Select> + diff --git a/xml/schema/Financial/Currency.xml b/xml/schema/Financial/Currency.xml index 27be4cf50e..96113189f4 100644 --- a/xml/schema/Financial/Currency.xml +++ b/xml/schema/Financial/Currency.xml @@ -25,6 +25,9 @@ true Currency Name 1.7 + + Text + symbol @@ -32,6 +35,9 @@ 8 Currency Symbol 1.7 + + Text + numeric_code @@ -46,6 +52,9 @@ varchar 64 Full currency name + + Text + 1.9 diff --git a/xml/schema/Financial/EntityFinancialAccount.xml b/xml/schema/Financial/EntityFinancialAccount.xml index 61d2586f77..75797f699e 100755 --- a/xml/schema/Financial/EntityFinancialAccount.xml +++ b/xml/schema/Financial/EntityFinancialAccount.xml @@ -48,6 +48,9 @@ account_relationship + + Select> + financial_account_id @@ -60,6 +63,9 @@ id name + + Select> + financial_account_id diff --git a/xml/schema/Financial/FinancialAccount.xml b/xml/schema/Financial/FinancialAccount.xml index 9ff3a8556b..febadab56b 100644 --- a/xml/schema/Financial/FinancialAccount.xml +++ b/xml/schema/Financial/FinancialAccount.xml @@ -57,6 +57,9 @@ financial_account_type + + Select> + accounting_code diff --git a/xml/schema/Financial/FinancialItem.xml b/xml/schema/Financial/FinancialItem.xml index 8bd59d0903..d8cb684a1e 100644 --- a/xml/schema/Financial/FinancialItem.xml +++ b/xml/schema/Financial/FinancialItem.xml @@ -80,6 +80,9 @@ full_name numeric_code + + Select> + financial_account_id @@ -91,6 +94,9 @@ id name + + Select> + financial_account_id @@ -107,6 +113,9 @@ financial_item_status + + Select> + entity_table diff --git a/xml/schema/Financial/FinancialTrxn.xml b/xml/schema/Financial/FinancialTrxn.xml index 56aceec60d..14430a1cc6 100755 --- a/xml/schema/Financial/FinancialTrxn.xml +++ b/xml/schema/Financial/FinancialTrxn.xml @@ -54,6 +54,9 @@ id name + + Select> + from_financial_account_id @@ -71,6 +74,9 @@ id name + + Select> + to_financial_account_id @@ -128,6 +134,9 @@ full_name numeric_code + + Select> + payment_processor @@ -184,6 +193,9 @@ payment_instrument + + Select> + 4.3 @@ -198,7 +210,10 @@ Check number varchar 255 - SIX + + Text + SIX + 4.3 diff --git a/xml/schema/Financial/PaymentProcessorType.xml b/xml/schema/Financial/PaymentProcessorType.xml index 19dc06d42f..1e700525f1 100644 --- a/xml/schema/Financial/PaymentProcessorType.xml +++ b/xml/schema/Financial/PaymentProcessorType.xml @@ -154,6 +154,9 @@ true Billing Mode true + + Select> + 1.8 diff --git a/xml/schema/Friend/Friend.xml b/xml/schema/Friend/Friend.xml index c4c9278c06..68cc704904 100644 --- a/xml/schema/Friend/Friend.xml +++ b/xml/schema/Friend/Friend.xml @@ -41,6 +41,9 @@ varchar 255 true + + Text + 2.0 @@ -48,6 +51,9 @@ text true Introductory message to contributor or participant displayed on the Tell a Friend form. + + Text + 2.0 @@ -55,6 +61,9 @@ text true Suggested message to friends, provided as default on the Tell A Friend form. + + Text + 2.0 @@ -63,6 +72,9 @@ 255 true URL for general info about the organization - included in the email sent to friends. + + Text + 2.0 @@ -71,6 +83,9 @@ 255 true Text for Tell a Friend thank you page header and HTML title. + + Text + 2.0 @@ -79,10 +94,16 @@ true Thank you message displayed on success page. 2.0 + + Text + is_active boolean 2.0 + + CheckBox + diff --git a/xml/schema/Grant/Grant.xml b/xml/schema/Grant/Grant.xml index 273b5054f8..0301e2a4ee 100644 --- a/xml/schema/Grant/Grant.xml +++ b/xml/schema/Grant/Grant.xml @@ -29,6 +29,9 @@ true Contact ID of contact record given grant belongs to. 1.8 + + Autocomplete-Select + contact_id @@ -52,6 +55,9 @@ Date on which grant decision was made. true 1.8 + + Select Date + money_transfer_date @@ -60,6 +66,9 @@ Date on which grant money transfer was made. true 1.8 + + Select Date + grant_due_date @@ -67,6 +76,9 @@ Grant Due Date Date on which grant report is due. 1.8 + + Select Date + grant_report_received @@ -75,6 +87,9 @@ Yes/No field stating whether grant report was received by donor. true 1.8 + + CheckBox + grant_type_id @@ -83,6 +98,9 @@ grant_type + + Select> + false true Type of grant. Implicit FK to civicrm_option_value in grant_type option_group. @@ -94,6 +112,9 @@ grant_type + + Select> + 1.8 @@ -105,6 +126,9 @@ true Requested grant amount, in default currency. 1.8 + + Text + amount_requested @@ -113,6 +137,9 @@ /^\d+(\.\d{2})?$/ Requested grant amount, in original currency (optional). 1.8 + + Text + amount_granted @@ -122,6 +149,9 @@ true Granted amount, in default currency. 1.8 + + Text + currency @@ -137,6 +167,9 @@ full_name numeric_code + + Select> + currency @@ -172,6 +205,9 @@ grant_status + + Select> + 1.8 diff --git a/xml/schema/Mailing/BounceType.xml b/xml/schema/Mailing/BounceType.xml index dcce50f480..e061e12725 100644 --- a/xml/schema/Mailing/BounceType.xml +++ b/xml/schema/Mailing/BounceType.xml @@ -20,6 +20,9 @@ AOL, Away, DNS, Host, Inactive, Invalid, Loop, Quota, Relay, Spam, Syntax, Unknown true Type of bounce + + Select + description diff --git a/xml/schema/Mailing/Component.xml b/xml/schema/Mailing/Component.xml index f3084ad590..e3158182f0 100644 --- a/xml/schema/Mailing/Component.xml +++ b/xml/schema/Mailing/Component.xml @@ -26,6 +26,9 @@ enum Header, Footer, Subscribe, Welcome, Unsubscribe, OptOut, Reply, Resubscribe Type of Component. + + Select + subject diff --git a/xml/schema/Mailing/Event/Bounce.xml b/xml/schema/Mailing/Event/Bounce.xml index ea09335ca0..9a366ede46 100644 --- a/xml/schema/Mailing/Event/Bounce.xml +++ b/xml/schema/Mailing/Event/Bounce.xml @@ -36,6 +36,9 @@ id name + + Select> + bounce_reason diff --git a/xml/schema/Mailing/Event/Subscribe.xml b/xml/schema/Mailing/Event/Subscribe.xml index 2a458bb6fb..4e8ac082f8 100644 --- a/xml/schema/Mailing/Event/Subscribe.xml +++ b/xml/schema/Mailing/Event/Subscribe.xml @@ -25,6 +25,9 @@ id title + + Select> + group_id diff --git a/xml/schema/Mailing/Mailing.xml b/xml/schema/Mailing/Mailing.xml index 7a7df67a68..f6018ffea8 100644 --- a/xml/schema/Mailing/Mailing.xml +++ b/xml/schema/Mailing/Mailing.xml @@ -98,30 +98,45 @@ varchar 128 Mailing Name. + + Text + from_name varchar 128 From Header of mailing + + Text + from_email varchar 128 From Email of mailing + + Text + replyto_email varchar 128 Reply-To Email of mailing + + Text + subject varchar 128 Subject of mailing + + Text + body_text @@ -137,16 +152,25 @@ url_tracking boolean Should we track URL click-throughs for this mailing? + + CheckBox + forward_replies boolean Should we forward replies back to the author? + + CheckBox + auto_responder boolean Should we enable the auto-responder? + + CheckBox + open_tracking @@ -157,6 +181,9 @@ is_completed boolean Has at least one job associated with this mailing finished? + + CheckBox + msg_template_id @@ -175,11 +202,14 @@ 0 2.2 Should we overrite VERP address in Reply-To + + CheckBox + created_id int unsigned - FK to Contact ID who first created this mailing + FK to Contact ID who first created this mailing created_id @@ -193,6 +223,9 @@ Mailing Created Date Date and time this mailing was created. 3.0 + + Select Date + scheduled_id @@ -238,6 +271,9 @@ mail_approval_status + + Select> + 3.3 @@ -246,12 +282,18 @@ Approval Note Note behind the decision. 3.3 + + TextArea + is_archived boolean 0 Is this mailing archived? + + CheckBox + 2.2 @@ -261,12 +303,18 @@ 'User and User Admin Only' In what context(s) is the mailing contents visible (online viewing) 3.3 + + Select + campaign_id int unsigned The campaign for which this mailing has been initiated. 3.4 + + Select + campaign_id @@ -280,11 +328,17 @@ 0 4.1 Remove duplicate emails? + + CheckBox + sms_provider_id int unsigned 4.2 + + Select + sms_provider_id diff --git a/xml/schema/Mailing/MailingGroup.xml b/xml/schema/Mailing/MailingGroup.xml index 25bc3d7748..ea71720b08 100644 --- a/xml/schema/Mailing/MailingGroup.xml +++ b/xml/schema/Mailing/MailingGroup.xml @@ -32,6 +32,9 @@ enum Include, Exclude, Base Are the members of the group included or excluded?. + + Select + entity_table diff --git a/xml/schema/Mailing/MailingJob.xml b/xml/schema/Mailing/MailingJob.xml index e13aaca2c4..d4f4663cac 100644 --- a/xml/schema/Mailing/MailingJob.xml +++ b/xml/schema/Mailing/MailingJob.xml @@ -47,6 +47,9 @@ enum Scheduled, Running, Complete, Paused, Canceled The state of this job + + Select + is_test diff --git a/xml/schema/Member/Membership.xml b/xml/schema/Member/Membership.xml index d94e6adf95..84feccf9a4 100644 --- a/xml/schema/Member/Membership.xml +++ b/xml/schema/Member/Membership.xml @@ -34,6 +34,9 @@ true FK to Contact ID 1.5 + + Autocomplete-Select + contact_id @@ -56,6 +59,9 @@ id name + + Select> + 1.5 @@ -74,6 +80,9 @@ /\d{4}-?\d{2}-?\d{2}/ Beginning of initial membership period (member since...). 1.5 + + Select Date + start_date @@ -85,6 +94,9 @@ /\d{4}-?\d{2}-?\d{2}/ Beginning of current uninterrupted membership period. 1.5 + + Select Date + end_date @@ -96,6 +108,9 @@ /\d{4}-?\d{2}-?\d{2}/ Current membership period expire date. 1.5 + + Select Date + source @@ -106,6 +121,9 @@ varchar 128 1.5 + + Text + status_id @@ -121,6 +139,9 @@ id label + + Select> + 1.5 @@ -137,6 +158,9 @@ /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. + + CheckBox + 1.5 @@ -164,6 +188,9 @@ int Maximum number of related memberships (membership_type override). 4.3 + + Text + is_test @@ -173,6 +200,9 @@ 0 true /(is.)?test(.member(ship)?)?/i + + CheckBox + is_pay_later @@ -183,6 +213,9 @@ true /(is.)?(pay(.)?later)$/i 2.1 + + CheckBox + contribution_recur_id @@ -205,6 +238,9 @@ true The campaign for which this membership is attached. 3.4 + + Select + campaign_id diff --git a/xml/schema/Member/MembershipStatus.xml b/xml/schema/Member/MembershipStatus.xml index efbdffbee5..406947f67f 100644 --- a/xml/schema/Member/MembershipStatus.xml +++ b/xml/schema/Member/MembershipStatus.xml @@ -42,6 +42,9 @@ start_date, end_date, join_date Event when this status starts. 1.5 + + Select + start_event_adjust_unit @@ -49,6 +52,9 @@ day, month, year Unit used for adjusting from start_event. 1.5 + + Select + start_event_adjust_interval @@ -62,6 +68,9 @@ start_date, end_date, join_date Event after which this status ends. 1.5 + + Select + end_event_adjust_unit @@ -69,6 +78,9 @@ day, month, year Unit used for adjusting from the ending event. 1.5 + + Select + end_event_adjust_interval diff --git a/xml/schema/Member/MembershipType.xml b/xml/schema/Member/MembershipType.xml index 2493b6fd47..c43a7f0262 100644 --- a/xml/schema/Member/MembershipType.xml +++ b/xml/schema/Member/MembershipType.xml @@ -110,6 +110,9 @@ day, month, year, lifetime Unit in which membership period is expressed. 1.5 + + Select + duration_interval @@ -176,6 +179,9 @@ visibility + + Select> + weight diff --git a/xml/schema/PCP/PCP.xml b/xml/schema/PCP/PCP.xml index 1c1c7ee6ff..5faf72231b 100644 --- a/xml/schema/PCP/PCP.xml +++ b/xml/schema/PCP/PCP.xml @@ -27,6 +27,9 @@ true FK to Contact ID 2.2 + + Autocomplete-Select + contact_id @@ -44,6 +47,9 @@ pcp_status + + Select> + title @@ -52,18 +58,27 @@ 255 NULL 2.2 + + Text + intro_text text NULL 2.2 + + TexArea + page_text text NULL 2.2 + + TexArea + donate_link_text @@ -71,6 +86,9 @@ 255 NULL 2.2 + + Text + contribution_page_id @@ -100,6 +118,9 @@ varchar 64 'contribute' + + Select + 2.2 @@ -113,6 +134,9 @@ is_thermometer int unsigned 0 + + CheckBox + 2.2 @@ -120,12 +144,18 @@ int unsigned 0 2.2 + + CheckBox + goal_amount decimal Goal amount of this Personal Campaign Page. 2.2 + + Text + currency @@ -140,6 +170,9 @@ full_name numeric_code + + Select> + referer @@ -155,5 +188,8 @@ Is Personal Campaign Page enabled/active? 0 2.2 + + CheckBox + diff --git a/xml/schema/Pledge/Pledge.xml b/xml/schema/Pledge/Pledge.xml index 77f737aab2..eef36ae1b8 100644 --- a/xml/schema/Pledge/Pledge.xml +++ b/xml/schema/Pledge/Pledge.xml @@ -28,6 +28,9 @@ true Foreign key to civicrm_contact.id . 2.1 + + Autocomplete-Select + contact_id @@ -60,6 +63,9 @@ int unsigned FK to Financial Type 4.3 + + Select + financial_type_id @@ -90,6 +96,9 @@ true Total pledged amount. 2.1 + + Text + original_installment_amount @@ -99,6 +108,9 @@ true Original amount for each of the installments. 3.2 + + Text + currency @@ -114,6 +126,9 @@ full_name numeric_code + + Select> + frequency_unit @@ -124,6 +139,9 @@ 'month' Time units for recurrence of pledge payments. 2.1 + + Select + frequency_interval @@ -134,6 +152,9 @@ 1 Number of time units for recurrence of pledge payments. 2.1 + + Text + frequency_day @@ -143,6 +164,9 @@ true Day in the period when the pledge payment is due e.g. 1st of month, 15th etc. Use this to set the scheduled dates for pledge payments. 2.1 + + Select + installments @@ -151,6 +175,9 @@ 1 Total number of payments to be made. 2.1 + + Text + start_date @@ -159,6 +186,9 @@ true The date the first scheduled pledge occurs. 2.1 + + Select Date + create_date @@ -169,6 +199,9 @@ true When this pledge record was created. 2.1 + + Select Date + acknowledge_date @@ -176,6 +209,9 @@ Pledge Acknowledged When a pledge acknowledgement message was sent to the contributor. 2.1 + + Select Date + modified_date @@ -190,6 +226,9 @@ Pledge Cancelled Date Date this pledge was cancelled by contributor. 2.1 + + Select Date + end_date @@ -197,6 +236,9 @@ Pledge End Date Date this pledge finished successfully (total pledge payments equal to or greater than pledged amount). 2.1 + + Select Date + honor_contact_id @@ -204,6 +246,9 @@ 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 + + Autocomplete-Select + honor_contact_id @@ -222,6 +267,9 @@ honor_type + + Select> + max_reminders @@ -229,6 +277,9 @@ int unsigned 1 The maximum number of payment reminders to send for any given payment. + + Text + 2.1 @@ -238,6 +289,9 @@ 5 Send initial reminder this many days prior to the payment due date. 2.1 + + Select + additional_reminder_day @@ -246,6 +300,9 @@ 5 Send additional reminder this many days after last one sent, up to maximum number of reminders. 2.1 + + Text + status_id @@ -269,6 +326,9 @@ Test boolean 0 + + CheckBox + campaign_id @@ -278,6 +338,9 @@ true The campaign for which this pledge has been initiated. 3.4 + + Select + campaign_id diff --git a/xml/schema/Pledge/PledgePayment.xml b/xml/schema/Pledge/PledgePayment.xml index 8a3bee3556..f2fa8417e9 100644 --- a/xml/schema/Pledge/PledgePayment.xml +++ b/xml/schema/Pledge/PledgePayment.xml @@ -85,6 +85,9 @@ full_name numeric_code + + Select> + scheduled_date diff --git a/xml/schema/Price/LineItem.xml b/xml/schema/Price/LineItem.xml index f2b53285c7..329ce44093 100644 --- a/xml/schema/Price/LineItem.xml +++ b/xml/schema/Price/LineItem.xml @@ -66,6 +66,9 @@ descriptive label for item - from price_field_value.label 1.7 + + Text + qty @@ -73,6 +76,9 @@ true How many items ordered 1.7 + + Text + unit_price @@ -80,6 +86,9 @@ true price of each item 1.7 + + Text + line_total @@ -92,8 +101,12 @@ participant_count int unsigned NULL - Participant count for field + Participant count for fiel + + Text + d 3.2 + index_entity @@ -130,6 +143,9 @@ NULL FK to Financial Type. 4.3 + + Select + financial_type_id @@ -148,6 +164,9 @@ true Tax-deductible portion of the amount 4.3 + + Text + diff --git a/xml/schema/Price/PriceField.xml b/xml/schema/Price/PriceField.xml index a1af3bf18a..dbbd007584 100644 --- a/xml/schema/Price/PriceField.xml +++ b/xml/schema/Price/PriceField.xml @@ -38,6 +38,9 @@ true Variable name/programmatic handle for this field. 1.8 + + Text + index_name @@ -52,6 +55,9 @@ true true Text for form field label (also friendly name for administering this field). + + Text + 1.8 @@ -60,6 +66,9 @@ Text, Select, Radio, CheckBox true 1.8 + + Select + is_enter_qty @@ -67,6 +76,9 @@ 0 Enter a quantity for this field? 1.8 + + CheckBox + help_pre @@ -98,12 +110,18 @@ 1 Order in which the fields should appear 1.8 + + Select + is_display_amounts boolean 1 Should the price be displayed next to the label for each option? + + CheckBox + options_per_line @@ -111,6 +129,9 @@ 1 number of options per line for checkbox and radio 1.8 + + Text + is_active @@ -118,6 +139,9 @@ Is this price field active 1 1.8 + + CheckBox + is_required @@ -125,6 +149,9 @@ Is this price field required (value must be > 1) 1 1.8 + + CheckBox + active_on @@ -132,6 +159,9 @@ NULL If non-zero, do not show this field before the date specified 1.8 + + CheckBox + expire_on @@ -139,6 +169,9 @@ NULL If non-zero, do not show this field after the date specified 1.8 + + Select Date + javascript @@ -146,6 +179,9 @@ 255 Optional scripting attributes for field 1.8 + + Text + visibility_id @@ -156,6 +192,9 @@ visibility + + Select> + count diff --git a/xml/schema/Price/PriceFieldValue.xml b/xml/schema/Price/PriceFieldValue.xml index ab5be701da..89111b33f6 100644 --- a/xml/schema/Price/PriceFieldValue.xml +++ b/xml/schema/Price/PriceFieldValue.xml @@ -35,6 +35,9 @@ Name 255 Price field option name + + Text + 3.3 @@ -44,6 +47,9 @@ 255 true Price field option label + + Text + 3.3 @@ -51,11 +57,10 @@ text TextArea - - - NULL - 2 + 2 60 + + NULL true >Price field option description. 3.3 @@ -65,7 +70,10 @@ varchar Amount 512 - EIGHT + + Text + EIGHT + true Price field option amount 3.3 @@ -76,6 +84,9 @@ NULL Number of participants per field option 3.3 + + Text + max_value @@ -83,6 +94,9 @@ NULL Max number of participants per field options 3.3 + + Text + weight @@ -90,12 +104,18 @@ 1 Order in which the field options should appear 3.3 + + Text + membership_type_id int unsigned NULL FK to Membership Type + + Select + 3.4 @@ -111,6 +131,9 @@ NULL Number of terms for this membership 4.3 + + Text + is_default @@ -118,6 +141,9 @@ Is this default price field option 0 3.3 + + CheckBox + is_active @@ -133,6 +159,9 @@ NULL FK to Financial Type. 4.3 + + Select + financial_type_id @@ -151,6 +180,9 @@ true Tax-deductible portion of the amount 4.1 + + Text + diff --git a/xml/schema/Price/PriceSet.xml b/xml/schema/Price/PriceSet.xml index 894b212fa2..c9010c75ea 100644 --- a/xml/schema/Price/PriceSet.xml +++ b/xml/schema/Price/PriceSet.xml @@ -22,6 +22,9 @@ int unsigned Which Domain is this price-set for 3.1 + + Text + domain_id @@ -36,6 +39,9 @@ true Variable name/programmatic handle for this set of price fields. 1.8 + + Text + UI_name @@ -51,6 +57,9 @@ true Displayed title for the Price Set. 1.8 + + Text + is_active @@ -58,6 +67,9 @@ 1 Is this price set active 1.8 + + CheckBox + help_pre @@ -89,6 +101,9 @@ 64 Optional Javascript script function(s) included on the form with this price_set. Can be used for conditional 1.8 + + Text + extends @@ -97,6 +112,9 @@ true What components are using this price set? 3.1 + + Text + contribution_type_id @@ -121,6 +139,9 @@ NULL FK to Financial Type(for membership price sets only). 4.3 + + Select + financial_type_id @@ -134,6 +155,9 @@ boolean 0 Is set if edited on Contribution or Event Page rather than through Manage Price Sets + + CheckBox + 4.1 @@ -142,5 +166,8 @@ 0 Is this a predefined system price set (i.e. it can not be deleted, edited)? 4.2 + + CheckBox + diff --git a/xml/schema/Queue/QueueItem.xml b/xml/schema/Queue/QueueItem.xml index 6500d9377d..e3761c6bde 100644 --- a/xml/schema/Queue/QueueItem.xml +++ b/xml/schema/Queue/QueueItem.xml @@ -25,23 +25,36 @@ 64 Name of the queue which includes this item true + + Text + weight int true + + Text + 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 + + data Queue item datas -- 2.25.1