From 5435b737218354b367a7272b8518b768835f855a Mon Sep 17 00:00:00 2001 From: Eileen McNaughton Date: Mon, 25 Aug 2014 09:42:50 +1200 Subject: [PATCH] CRM-15168 whitespace only --- xml/schema/Mailing/BouncePattern.xml | 62 +- xml/schema/Mailing/BounceType.xml | 64 +- xml/schema/Mailing/Component.xml | 96 +-- xml/schema/Mailing/Event/Bounce.xml | 102 ++-- xml/schema/Mailing/Event/Confirm.xml | 64 +- xml/schema/Mailing/Event/Delivered.xml | 64 +- xml/schema/Mailing/Event/Forward.xml | 86 +-- xml/schema/Mailing/Event/Opened.xml | 64 +- xml/schema/Mailing/Event/Queue.xml | 138 ++--- xml/schema/Mailing/Event/Reply.xml | 64 +- xml/schema/Mailing/Event/Subscribe.xml | 118 ++-- xml/schema/Mailing/Event/TrackableURLOpen.xml | 88 +-- xml/schema/Mailing/Event/Unsubscribe.xml | 76 +-- xml/schema/Mailing/Mailing.xml | 550 +++++++++--------- xml/schema/Mailing/MailingGroup.xml | 80 +-- xml/schema/Mailing/MailingJob.xml | 122 ++-- xml/schema/Mailing/Recipients.xml | 74 +-- xml/schema/Mailing/Spool.xml | 56 +- xml/schema/Mailing/TrackableURL.xml | 66 +-- xml/schema/Member/Membership.xml | 334 +++++------ xml/schema/Member/MembershipBlock.xml | 164 +++--- xml/schema/Member/MembershipLog.xml | 120 ++-- xml/schema/Member/MembershipPayment.xml | 30 +- xml/schema/Member/MembershipStatus.xml | 212 +++---- xml/schema/Price/LineItem.xml | 6 +- xml/schema/Price/PriceField.xml | 370 ++++++------ xml/schema/Price/PriceFieldValue.xml | 2 +- xml/schema/Price/PriceSetEntity.xml | 68 +-- xml/schema/Report/ReportInstance.xml | 390 ++++++------- xml/schema/SMS/History.xml | 64 +- xml/schema/SMS/Provider.xml | 144 ++--- xml/schema/Standalone/OpenID/Associations.xml | 74 +-- xml/schema/Standalone/OpenID/Nonce.xml | 46 +- 33 files changed, 2029 insertions(+), 2029 deletions(-) diff --git a/xml/schema/Mailing/BouncePattern.xml b/xml/schema/Mailing/BouncePattern.xml index 88060e311c..d5b4c784af 100644 --- a/xml/schema/Mailing/BouncePattern.xml +++ b/xml/schema/Mailing/BouncePattern.xml @@ -1,35 +1,35 @@ - CRM/Mailing - BouncePattern - civicrm_mailing_bounce_pattern - Pseudo-constant table of patterns for bounce classification - - id - int unsigned - true - - - id - true - - - bounce_type_id - int unsigned - true - Type of bounce - - - bounce_type_id -
civicrm_mailing_bounce_type
- id - CASCADE - - - pattern - varchar - 255 - A regexp to match a message to a bounce type - + CRM/Mailing + BouncePattern + civicrm_mailing_bounce_pattern + Pseudo-constant table of patterns for bounce classification + + id + int unsigned + true + + + id + true + + + bounce_type_id + int unsigned + true + Type of bounce + + + bounce_type_id + civicrm_mailing_bounce_type
+ id + CASCADE + + + pattern + varchar + 255 + A regexp to match a message to a bounce type + diff --git a/xml/schema/Mailing/BounceType.xml b/xml/schema/Mailing/BounceType.xml index 392cc9169b..3279d2d30f 100644 --- a/xml/schema/Mailing/BounceType.xml +++ b/xml/schema/Mailing/BounceType.xml @@ -1,36 +1,36 @@ - CRM/Mailing - BounceType - civicrm_mailing_bounce_type - Table to index the various bounce types and their properties - - id - int unsigned - true - - - id - true - - - name - varchar - 8 - true - Type of bounce - - - description - varchar - 255 - A description of this bounce type - - - hold_threshold - int unsigned - true - Number of bounces of this type required before the email address is put on bounce hold - + CRM/Mailing + BounceType + civicrm_mailing_bounce_type + Table to index the various bounce types and their properties + + id + int unsigned + true + + + id + true + + + name + varchar + 8 + true + Type of bounce + + + description + varchar + 255 + A description of this bounce type + + + hold_threshold + int unsigned + true + Number of bounces of this type required before the email address is put on bounce hold +
diff --git a/xml/schema/Mailing/Component.xml b/xml/schema/Mailing/Component.xml index 9ff4b2accd..9de2ef1fba 100644 --- a/xml/schema/Mailing/Component.xml +++ b/xml/schema/Mailing/Component.xml @@ -6,67 +6,67 @@ civicrm_mailing_component Stores information about the mailing components (header/footer). - id - int unsigned - true + id + int unsigned + true - id - true + id + true - name - Component Name - varchar - 64 - The name of this component + name + Component Name + varchar + 64 + The name of this component - component_type - varchar - 12 - Type of Component. - - CRM_Core_SelectValues::mailingComponents - - - Select - + component_type + varchar + 12 + Type of Component. + + CRM_Core_SelectValues::mailingComponents + + + Select + - subject - varchar - 255 + subject + varchar + 255 - body_html - text - Body of the component in html format. - - TextArea - 8 - 80 - - + body_html + text + Body of the component in html format. + + TextArea + 8 + 80 + + - body_text - text - Body of the component in text format. - - TextArea - 8 - 80 - - + body_text + text + Body of the component in text format. + + TextArea + 8 + 80 + + - is_default - boolean - 0 - Is this the default component for this component_type? + is_default + boolean + 0 + Is this the default component for this component_type? - is_active - boolean - Is this property active? + is_active + boolean + Is this property active? diff --git a/xml/schema/Mailing/Event/Bounce.xml b/xml/schema/Mailing/Event/Bounce.xml index e634ac8b00..5842e95102 100644 --- a/xml/schema/Mailing/Event/Bounce.xml +++ b/xml/schema/Mailing/Event/Bounce.xml @@ -1,55 +1,55 @@ - CRM/Mailing/Event - Bounce - civicrm_mailing_event_bounce - Tracks when and why an email bounced. - true - - id - int unsigned - true - - - id - true - - - event_queue_id - int unsigned - true - FK to EventQueue - - - event_queue_id -
civicrm_mailing_event_queue
- id - CASCADE - - - bounce_type_id - int unsigned - What type of bounce was it? - - civicrm_mailing_bounce_type
- id - name - - - Select - - - - bounce_reason - varchar - 255 - The reason the email bounced. - - - time_stamp - datetime - true - When this bounce event occurred. - + CRM/Mailing/Event + Bounce + civicrm_mailing_event_bounce + Tracks when and why an email bounced. + true + + id + int unsigned + true + + + id + true + + + event_queue_id + int unsigned + true + FK to EventQueue + + + event_queue_id + civicrm_mailing_event_queue
+ id + CASCADE + + + bounce_type_id + int unsigned + What type of bounce was it? + + civicrm_mailing_bounce_type
+ id + name + + + Select + + + + bounce_reason + varchar + 255 + The reason the email bounced. + + + time_stamp + datetime + true + When this bounce event occurred. + diff --git a/xml/schema/Mailing/Event/Confirm.xml b/xml/schema/Mailing/Event/Confirm.xml index c054d16ad3..093941f211 100644 --- a/xml/schema/Mailing/Event/Confirm.xml +++ b/xml/schema/Mailing/Event/Confirm.xml @@ -1,36 +1,36 @@ - CRM/Mailing/Event - Confirm - civicrm_mailing_event_confirm - Tracks when a subscription event is confirmed by email - true - - id - int unsigned - true - - - id - true - - - event_subscribe_id - int unsigned - true - FK to civicrm_mailing_event_subscribe - - - event_subscribe_id -
civicrm_mailing_event_subscribe
- id - CASCADE - - - time_stamp - datetime - true - When this confirmation event occurred. - + CRM/Mailing/Event + Confirm + civicrm_mailing_event_confirm + Tracks when a subscription event is confirmed by email + true + + id + int unsigned + true + + + id + true + + + event_subscribe_id + int unsigned + true + FK to civicrm_mailing_event_subscribe + + + event_subscribe_id + civicrm_mailing_event_subscribe
+ id + CASCADE + + + time_stamp + datetime + true + When this confirmation event occurred. + diff --git a/xml/schema/Mailing/Event/Delivered.xml b/xml/schema/Mailing/Event/Delivered.xml index 931c56810f..8eff1e1f84 100644 --- a/xml/schema/Mailing/Event/Delivered.xml +++ b/xml/schema/Mailing/Event/Delivered.xml @@ -1,36 +1,36 @@ - CRM/Mailing/Event - Delivered - civicrm_mailing_event_delivered - Tracks when a queued email is actually delivered to the MTA - true - - id - int unsigned - true - - - id - true - - - event_queue_id - int unsigned - true - FK to EventQueue - - - event_queue_id -
civicrm_mailing_event_queue
- id - CASCADE - - - time_stamp - datetime - true - When this delivery event occurred. - + CRM/Mailing/Event + Delivered + civicrm_mailing_event_delivered + Tracks when a queued email is actually delivered to the MTA + true + + id + int unsigned + true + + + id + true + + + event_queue_id + int unsigned + true + FK to EventQueue + + + event_queue_id + civicrm_mailing_event_queue
+ id + CASCADE + + + time_stamp + datetime + true + When this delivery event occurred. + diff --git a/xml/schema/Mailing/Event/Forward.xml b/xml/schema/Mailing/Event/Forward.xml index 813abd255c..1535bed82a 100644 --- a/xml/schema/Mailing/Event/Forward.xml +++ b/xml/schema/Mailing/Event/Forward.xml @@ -1,47 +1,47 @@ - CRM/Mailing/Event - Forward - civicrm_mailing_event_forward - Tracks when a contact forwards a mailing to a (new) contact - true - - id - int unsigned - true - - - id - true - - - event_queue_id - int unsigned - true - FK to EventQueue - - - event_queue_id -
civicrm_mailing_event_queue
- id - CASCADE - - - dest_queue_id - int unsigned - FK to EventQueue for destination - - - dest_queue_id - civicrm_mailing_event_queue
- id - SET NULL - - - time_stamp - datetime - true - When this forward event occurred. - + CRM/Mailing/Event + Forward + civicrm_mailing_event_forward + Tracks when a contact forwards a mailing to a (new) contact + true + + id + int unsigned + true + + + id + true + + + event_queue_id + int unsigned + true + FK to EventQueue + + + event_queue_id + civicrm_mailing_event_queue
+ id + CASCADE + + + dest_queue_id + int unsigned + FK to EventQueue for destination + + + dest_queue_id + civicrm_mailing_event_queue
+ id + SET NULL + + + time_stamp + datetime + true + When this forward event occurred. + diff --git a/xml/schema/Mailing/Event/Opened.xml b/xml/schema/Mailing/Event/Opened.xml index be9f42d6f7..8367148a56 100644 --- a/xml/schema/Mailing/Event/Opened.xml +++ b/xml/schema/Mailing/Event/Opened.xml @@ -1,36 +1,36 @@ - CRM/Mailing/Event - Opened - civicrm_mailing_event_opened - Tracks when a delivered email is opened by the recipient - true - - id - int unsigned - true - - - id - true - - - event_queue_id - int unsigned - true - FK to EventQueue - - - event_queue_id -
civicrm_mailing_event_queue
- id - CASCADE - - - time_stamp - datetime - true - When this open event occurred. - + CRM/Mailing/Event + Opened + civicrm_mailing_event_opened + Tracks when a delivered email is opened by the recipient + true + + id + int unsigned + true + + + id + true + + + event_queue_id + int unsigned + true + FK to EventQueue + + + event_queue_id + civicrm_mailing_event_queue
+ id + CASCADE + + + time_stamp + datetime + true + When this open event occurred. + diff --git a/xml/schema/Mailing/Event/Queue.xml b/xml/schema/Mailing/Event/Queue.xml index 13c8d775d8..44fef4f044 100644 --- a/xml/schema/Mailing/Event/Queue.xml +++ b/xml/schema/Mailing/Event/Queue.xml @@ -1,73 +1,73 @@ - CRM/Mailing/Event - Queue - civicrm_mailing_event_queue - A collection of all intended recipients of a job - true - - id - int unsigned - true - - - id - true - - - job_id - int unsigned - true - FK to Job - - - job_id -
civicrm_mailing_job
- id - CASCADE - - - email_id - int unsigned - NULL - FK to Email - - - email_id - civicrm_email
- id - CASCADE - - - contact_id - int unsigned - true - FK to Contact - - - contact_id - civicrm_contact
- id - CASCADE - - - hash - varchar - 255 - true - Security hash - - - phone_id - int unsigned - NULL - FK to Phone - - - phone_id - civicrm_phone
- id - CASCADE - + CRM/Mailing/Event + Queue + civicrm_mailing_event_queue + A collection of all intended recipients of a job + true + + id + int unsigned + true + + + id + true + + + job_id + int unsigned + true + FK to Job + + + job_id + civicrm_mailing_job
+ id + CASCADE + + + email_id + int unsigned + NULL + FK to Email + + + email_id + civicrm_email
+ id + CASCADE + + + contact_id + int unsigned + true + FK to Contact + + + contact_id + civicrm_contact
+ id + CASCADE + + + hash + varchar + 255 + true + Security hash + + + phone_id + int unsigned + NULL + FK to Phone + + + phone_id + civicrm_phone
+ id + CASCADE + diff --git a/xml/schema/Mailing/Event/Reply.xml b/xml/schema/Mailing/Event/Reply.xml index a964447e30..0fe33e5558 100644 --- a/xml/schema/Mailing/Event/Reply.xml +++ b/xml/schema/Mailing/Event/Reply.xml @@ -1,36 +1,36 @@ - CRM/Mailing/Event - Reply - civicrm_mailing_event_reply - Tracks when a contact replies to a mailing - true - - id - int unsigned - true - - - id - true - - - event_queue_id - int unsigned - true - FK to EventQueue - - - event_queue_id -
civicrm_mailing_event_queue
- id - CASCADE - - - time_stamp - datetime - true - When this reply event occurred. - + CRM/Mailing/Event + Reply + civicrm_mailing_event_reply + Tracks when a contact replies to a mailing + true + + id + int unsigned + true + + + id + true + + + event_queue_id + int unsigned + true + FK to EventQueue + + + event_queue_id + civicrm_mailing_event_queue
+ id + CASCADE + + + time_stamp + datetime + true + When this reply event occurred. + diff --git a/xml/schema/Mailing/Event/Subscribe.xml b/xml/schema/Mailing/Event/Subscribe.xml index 21fe0f5794..5e9299de19 100644 --- a/xml/schema/Mailing/Event/Subscribe.xml +++ b/xml/schema/Mailing/Event/Subscribe.xml @@ -1,63 +1,63 @@ - CRM/Mailing/Event - Subscribe - civicrm_mailing_event_subscribe - Tracks when a (new) contact subscribes to a group by email - true - - id - int unsigned - true - - - id - true - - - group_id - int unsigned - true - FK to Group - -
civicrm_group
- id - title - - - Select - - - - group_id - civicrm_group
- id - CASCADE - - - contact_id - int unsigned - true - FK to Contact - - - contact_id - civicrm_contact
- id - CASCADE - - - hash - varchar - 255 - true - Security hash - - - time_stamp - datetime - true - When this subscription event occurred. - + CRM/Mailing/Event + Subscribe + civicrm_mailing_event_subscribe + Tracks when a (new) contact subscribes to a group by email + true + + id + int unsigned + true + + + id + true + + + group_id + int unsigned + true + FK to Group + + civicrm_group
+ id + title + + + Select + + + + group_id + civicrm_group
+ id + CASCADE + + + contact_id + int unsigned + true + FK to Contact + + + contact_id + civicrm_contact
+ id + CASCADE + + + hash + varchar + 255 + true + Security hash + + + time_stamp + datetime + true + When this subscription event occurred. + diff --git a/xml/schema/Mailing/Event/TrackableURLOpen.xml b/xml/schema/Mailing/Event/TrackableURLOpen.xml index 1f574b308c..575c7885d2 100644 --- a/xml/schema/Mailing/Event/TrackableURLOpen.xml +++ b/xml/schema/Mailing/Event/TrackableURLOpen.xml @@ -1,48 +1,48 @@ - CRM/Mailing/Event - TrackableURLOpen - civicrm_mailing_event_trackable_url_open - Tracks when a TrackableURL is clicked by a recipient. - true - - id - int unsigned - true - - - id - true - - - event_queue_id - int unsigned - true - FK to EventQueue - - - event_queue_id -
civicrm_mailing_event_queue
- id - CASCADE - - - trackable_url_id - int unsigned - true - FK to TrackableURL - - - trackable_url_id - civicrm_mailing_trackable_url
- id - CASCADE - - - time_stamp - datetime - true - When this trackable URL open occurred. - + CRM/Mailing/Event + TrackableURLOpen + civicrm_mailing_event_trackable_url_open + Tracks when a TrackableURL is clicked by a recipient. + true + + id + int unsigned + true + + + id + true + + + event_queue_id + int unsigned + true + FK to EventQueue + + + event_queue_id + civicrm_mailing_event_queue
+ id + CASCADE + + + trackable_url_id + int unsigned + true + FK to TrackableURL + + + trackable_url_id + civicrm_mailing_trackable_url
+ id + CASCADE + + + time_stamp + datetime + true + When this trackable URL open occurred. + diff --git a/xml/schema/Mailing/Event/Unsubscribe.xml b/xml/schema/Mailing/Event/Unsubscribe.xml index 871453924d..9309bc6b48 100644 --- a/xml/schema/Mailing/Event/Unsubscribe.xml +++ b/xml/schema/Mailing/Event/Unsubscribe.xml @@ -1,42 +1,42 @@ - CRM/Mailing/Event - Unsubscribe - civicrm_mailing_event_unsubscribe - Tracks when a recipient unsubscribes from a group/domain - true - - id - int unsigned - true - - - id - true - - - event_queue_id - int unsigned - true - FK to EventQueue - - - event_queue_id -
civicrm_mailing_event_queue
- id - CASCADE - - - org_unsubscribe - boolean - true - Unsubscribe at org- or group-level - - - time_stamp - datetime - true - When this delivery event occurred. - + CRM/Mailing/Event + Unsubscribe + civicrm_mailing_event_unsubscribe + Tracks when a recipient unsubscribes from a group/domain + true + + id + int unsigned + true + + + id + true + + + event_queue_id + int unsigned + true + FK to EventQueue + + + event_queue_id + civicrm_mailing_event_queue
+ id + CASCADE + + + org_unsubscribe + boolean + true + Unsubscribe at org- or group-level + + + time_stamp + datetime + true + When this delivery event occurred. + diff --git a/xml/schema/Mailing/Mailing.xml b/xml/schema/Mailing/Mailing.xml index 182f7b34dd..b861ff6255 100644 --- a/xml/schema/Mailing/Mailing.xml +++ b/xml/schema/Mailing/Mailing.xml @@ -7,370 +7,370 @@ Stores information about a mailing. true - id - int unsigned - true + id + int unsigned + true - id - true + id + true - domain_id - int unsigned - - civicrm_domain
- id - name - - Which site is this mailing for - 3.4 + domain_id + int unsigned + + civicrm_domain
+ id + name + + Which site is this mailing for + 3.4 - domain_id - civicrm_domain
- id - SET NULL - 3.4 + domain_id + civicrm_domain
+ id + SET NULL + 3.4 - header_id - int unsigned - FK to the header component. + header_id + int unsigned + FK to the header component. - header_id - civicrm_mailing_component
- id - SET NULL + header_id + civicrm_mailing_component
+ id + SET NULL - footer_id - int unsigned - FK to the footer component. + footer_id + int unsigned + FK to the footer component. - footer_id - civicrm_mailing_component
- id - SET NULL + footer_id + civicrm_mailing_component
+ id + SET NULL - reply_id - int unsigned - FK to the auto-responder component. + reply_id + int unsigned + FK to the auto-responder component. - reply_id - civicrm_mailing_component
- id - SET NULL + reply_id + civicrm_mailing_component
+ id + SET NULL - unsubscribe_id - int unsigned - FK to the unsubscribe component. + unsubscribe_id + int unsigned + FK to the unsubscribe component. - unsubscribe_id - civicrm_mailing_component
- id - SET NULL + unsubscribe_id + civicrm_mailing_component
+ id + SET NULL - resubscribe_id - int unsigned + resubscribe_id + int unsigned - optout_id - civicrm_mailing_component
- id - SET NULL + optout_id + civicrm_mailing_component
+ id + SET NULL - optout_id - int unsigned - FK to the opt-out component. + optout_id + int unsigned + FK to the opt-out component. - optout_id - civicrm_mailing_component
- id - SET NULL + optout_id + civicrm_mailing_component
+ id + SET NULL - name - varchar - 128 - Mailing Name. - - Text - + name + varchar + 128 + Mailing Name. + + Text + - from_name - varchar - 128 - From Header of mailing - - Text - + from_name + varchar + 128 + From Header of mailing + + Text + - from_email - varchar - 128 - From Email of mailing - - Text - + from_email + varchar + 128 + From Email of mailing + + Text + - replyto_email - varchar - 128 - Reply-To Email of mailing - - Text - + replyto_email + varchar + 128 + Reply-To Email of mailing + + Text + - subject - varchar - 128 - Subject of mailing - - Text - + subject + varchar + 128 + Subject of mailing + + Text + - body_text - longtext - Body of the mailing in text format. + body_text + longtext + Body of the mailing in text format. - body_html - longtext - Body of the mailing in html format. + body_html + longtext + Body of the mailing in html format. - url_tracking - boolean - Should we track URL click-throughs for this mailing? - - CheckBox - + 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 - + forward_replies + boolean + Should we forward replies back to the author? + + CheckBox + - auto_responder - boolean - Should we enable the auto-responder? - - CheckBox - + auto_responder + boolean + Should we enable the auto-responder? + + CheckBox + - open_tracking - boolean - Should we track when recipients open/read this mailing? + open_tracking + boolean + Should we track when recipients open/read this mailing? - is_completed - boolean - Has at least one job associated with this mailing finished? - - CheckBox - + is_completed + boolean + Has at least one job associated with this mailing finished? + + CheckBox + - msg_template_id - int unsigned - FK to the message template. + msg_template_id + int unsigned + FK to the message template. - msg_template_id - civicrm_msg_template
- id - SET NULL + msg_template_id + civicrm_msg_template
+ id + SET NULL - override_verp - boolean - 0 - 2.2 - Should we overrite VERP address in Reply-To - - CheckBox - + override_verp + boolean + 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 + created_id + int unsigned + FK to Contact ID who first created this mailing - created_id - civicrm_contact
- id - SET NULL + created_id + civicrm_contact
+ id + SET NULL - created_date - datetime - Mailing Created Date - Date and time this mailing was created. - 3.0 - - Select Date - + created_date + datetime + Mailing Created Date + Date and time this mailing was created. + 3.0 + + Select Date + - scheduled_id - int unsigned - FK to Contact ID who scheduled this mailing + scheduled_id + int unsigned + FK to Contact ID who scheduled this mailing - scheduled_id - civicrm_contact
- id - SET NULL + scheduled_id + civicrm_contact
+ id + SET NULL - scheduled_date - datetime - Mailing Scheduled Date - Date and time this mailing was scheduled. - 3.3 + scheduled_date + datetime + Mailing Scheduled Date + Date and time this mailing was scheduled. + 3.3 - approver_id - int unsigned - FK to Contact ID who approved this mailing + approver_id + int unsigned + FK to Contact ID who approved this mailing - approver_id - civicrm_contact
- id - SET NULL + approver_id + civicrm_contact
+ id + SET NULL - approval_date - datetime - Mailing Approved Date - Date and time this mailing was approved. - 3.3 - - - approval_status_id - int unsigned - Approval Status - The status of this mailing. Values: none, approved, rejected - - mail_approval_status - - - Select - - 3.3 - - - approval_note - longtext - Approval Note - Note behind the decision. - 3.3 - - TextArea - - - - is_archived - boolean - 0 - Is this mailing archived? - - CheckBox - - 2.2 - - - visibility - varchar - 40 - 'Public Pages' - In what context(s) is the mailing contents visible (online viewing) - - CRM_Core_SelectValues::groupVisibility - - 3.3 - - Select - - - - campaign_id - int unsigned - The campaign for which this mailing has been initiated. - - civicrm_campaign
- id - title - - 3.4 - - Select - + approval_date + datetime + Mailing Approved Date + Date and time this mailing was approved. + 3.3 + + + approval_status_id + int unsigned + Approval Status + The status of this mailing. Values: none, approved, rejected + + mail_approval_status + + + Select + + 3.3 + + + approval_note + longtext + Approval Note + Note behind the decision. + 3.3 + + TextArea + + + + is_archived + boolean + 0 + Is this mailing archived? + + CheckBox + + 2.2 + + + visibility + varchar + 40 + 'Public Pages' + In what context(s) is the mailing contents visible (online viewing) + + CRM_Core_SelectValues::groupVisibility + + 3.3 + + Select + + + + campaign_id + int unsigned + The campaign for which this mailing has been initiated. + + civicrm_campaign
+ id + title + + 3.4 + + Select + - campaign_id - civicrm_campaign
- id - SET NULL + campaign_id + civicrm_campaign
+ id + SET NULL - dedupe_email - boolean - 0 - 4.1 - Remove duplicate emails? - - CheckBox - + dedupe_email + boolean + 0 + 4.1 + Remove duplicate emails? + + CheckBox + - sms_provider_id - int unsigned - 4.2 - - Select - + sms_provider_id + int unsigned + 4.2 + + Select + - sms_provider_id - civicrm_sms_provider
- id - SET NULL - 4.2 + sms_provider_id + civicrm_sms_provider
+ id + SET NULL + 4.2 - hash - Mailing Hash - varchar - 16 - Key for validating requests related to this mailing. - 4.5 + hash + Mailing Hash + varchar + 16 + Key for validating requests related to this mailing. + 4.5 - index_hash - hash - 4.5 + index_hash + hash + 4.5 diff --git a/xml/schema/Mailing/MailingGroup.xml b/xml/schema/Mailing/MailingGroup.xml index 0d45536818..7109333c63 100644 --- a/xml/schema/Mailing/MailingGroup.xml +++ b/xml/schema/Mailing/MailingGroup.xml @@ -7,63 +7,63 @@ Stores information about the groups that participate in this mailing.. true - id - int unsigned - true + id + int unsigned + true - id - true + id + true - mailing_id - int unsigned - true - The ID of a previous mailing to include/exclude recipients. + mailing_id + int unsigned + true + The ID of a previous mailing to include/exclude recipients. - mailing_id - civicrm_mailing
- id - CASCADE + mailing_id + civicrm_mailing
+ id + CASCADE - group_type - varchar - 8 - Are the members of the group included or excluded?. - - CRM_Core_SelectValues::getMailingGroupTypes - - - Select - + group_type + varchar + 8 + Are the members of the group included or excluded?. + + CRM_Core_SelectValues::getMailingGroupTypes + + + Select + - entity_table - varchar - 64 - true - Name of table where item being referenced is stored. + entity_table + varchar + 64 + true + Name of table where item being referenced is stored. - entity_id - int unsigned - true - Foreign key to the referenced item. + entity_id + int unsigned + true + Foreign key to the referenced item. - entity_id - entity_table + entity_id + entity_table - search_id - int - The filtering search. custom search id or -1 for civicrm api search + search_id + int + The filtering search. custom search id or -1 for civicrm api search - search_args - text - The arguments to be sent to the search function + search_args + text + The arguments to be sent to the search function diff --git a/xml/schema/Mailing/MailingJob.xml b/xml/schema/Mailing/MailingJob.xml index 244efea68a..b0467700ce 100644 --- a/xml/schema/Mailing/MailingJob.xml +++ b/xml/schema/Mailing/MailingJob.xml @@ -7,92 +7,92 @@ Stores information about the job that executes this mailing true - id - int unsigned - true + id + int unsigned + true - id - true + id + true - mailing_id - int unsigned - true - The ID of the mailing this Job will send. + mailing_id + int unsigned + true + The ID of the mailing this Job will send. - mailing_id - civicrm_mailing
- id - CASCADE + mailing_id + civicrm_mailing
+ id + CASCADE - scheduled_date - datetime - date on which this job was scheduled. + scheduled_date + datetime + date on which this job was scheduled. - start_date - datetime - date on which this job was started. + start_date + datetime + date on which this job was started. - end_date - datetime - date on which this job ended. + end_date + datetime + date on which this job ended. - status - varchar - 12 - The state of this job - - CRM_Core_SelectValues::getMailingJobStatus - - - Select - + status + varchar + 12 + The state of this job + + CRM_Core_SelectValues::getMailingJobStatus + + + Select + - is_test - boolean - 0 - Is this job for a test mail? - 1.9 + is_test + boolean + 0 + Is this job for a test mail? + 1.9 - job_type - varchar - 255 - Type of mailling job: null | child - 3.3 + job_type + varchar + 255 + Type of mailling job: null | child + 3.3 - parent_id - int unsigned - Parent job id - NULL - 3.3 + parent_id + int unsigned + Parent job id + NULL + 3.3 - parent_id - civicrm_mailing_job
- id - CASCADE + parent_id + civicrm_mailing_job
+ id + CASCADE - job_offset - int - Offset of the child job - 0 - 3.3 + job_offset + int + Offset of the child job + 0 + 3.3 - job_limit - int - Queue size limit for each child job - 0 - 3.3 + job_limit + int + Queue size limit for each child job + 0 + 3.3 diff --git a/xml/schema/Mailing/Recipients.xml b/xml/schema/Mailing/Recipients.xml index 95b143626a..f53a7d241a 100644 --- a/xml/schema/Mailing/Recipients.xml +++ b/xml/schema/Mailing/Recipients.xml @@ -7,60 +7,60 @@ Stores information about the recipients of a mailing. true - id - int unsigned - true + id + int unsigned + true - id - true + id + true - mailing_id - int unsigned - true - The ID of the mailing this Job will send. + mailing_id + int unsigned + true + The ID of the mailing this Job will send. - mailing_id - civicrm_mailing
- id - CASCADE + mailing_id + civicrm_mailing
+ id + CASCADE - contact_id - int unsigned - true - FK to Contact + contact_id + int unsigned + true + FK to Contact - contact_id - civicrm_contact
- id - CASCADE + contact_id + civicrm_contact
+ id + CASCADE - email_id - int unsigned - NULL - FK to Email + email_id + int unsigned + NULL + FK to Email - email_id - civicrm_email
- id - CASCADE + email_id + civicrm_email
+ id + CASCADE - phone_id - int unsigned - NULL - FK to Phone + phone_id + int unsigned + NULL + FK to Phone - phone_id - civicrm_phone
- id - CASCADE + phone_id + civicrm_phone
+ id + CASCADE diff --git a/xml/schema/Mailing/Spool.xml b/xml/schema/Mailing/Spool.xml index c820ef33ff..505de09fee 100644 --- a/xml/schema/Mailing/Spool.xml +++ b/xml/schema/Mailing/Spool.xml @@ -6,49 +6,49 @@ civicrm_mailing_spool Stores the outbond mails - id - int unsigned - true + id + int unsigned + true - id - true + id + true - job_id - int unsigned - true - The ID of the Job . + job_id + int unsigned + true + The ID of the Job . - job_id - civicrm_mailing_job
- id - CASCADE + job_id + civicrm_mailing_job
+ id + CASCADE - recipient_email - text - The email of the receipients this mail is to be sent. + recipient_email + text + The email of the receipients this mail is to be sent. - headers - text - The header information of this mailing . + headers + text + The header information of this mailing . - body - text - The body of this mailing. + body + text + The body of this mailing. - added_at - datetime - date on which this job was added. + added_at + datetime + date on which this job was added. - removed_at - datetime - date on which this job was removed. + removed_at + datetime + date on which this job was removed. diff --git a/xml/schema/Mailing/TrackableURL.xml b/xml/schema/Mailing/TrackableURL.xml index 5c95a7a54a..92fb4353ab 100644 --- a/xml/schema/Mailing/TrackableURL.xml +++ b/xml/schema/Mailing/TrackableURL.xml @@ -1,37 +1,37 @@ - CRM/Mailing - TrackableURL - civicrm_mailing_trackable_url - Stores URLs for which we should track click-throughs from mailings - true - - id - int unsigned - true - - - id - true - - - url - varchar - 255 - true - The URL to be tracked. - - - mailing_id - int unsigned - true - FK to the mailing - - - mailing_id -
civicrm_mailing
- id - CASCADE - + CRM/Mailing + TrackableURL + civicrm_mailing_trackable_url + Stores URLs for which we should track click-throughs from mailings + true + + id + int unsigned + true + + + id + true + + + url + varchar + 255 + true + The URL to be tracked. + + + mailing_id + int unsigned + true + FK to the mailing + + + mailing_id + civicrm_mailing
+ id + CASCADE + diff --git a/xml/schema/Member/Membership.xml b/xml/schema/Member/Membership.xml index 9abca1d424..b37292db17 100644 --- a/xml/schema/Member/Membership.xml +++ b/xml/schema/Member/Membership.xml @@ -8,175 +8,175 @@ 1.5 true - id - membership_id - int unsigned - true - true - Membership ID - /^(m(embership\s)?id)$/i - Membership Id - 1.5 + id + membership_id + int unsigned + true + true + Membership ID + /^(m(embership\s)?id)$/i + Membership Id + 1.5 - id - true + id + true - contact_id - membership_contact_id - int unsigned - true - Contact ID - /contact(.?id)?/i - /^\d+$/ - true - FK to Contact ID - 1.5 - - Autocomplete-Select - + contact_id + membership_contact_id + int unsigned + true + Contact ID + /contact(.?id)?/i + /^\d+$/ + true + FK to Contact ID + 1.5 + + Autocomplete-Select + - contact_id - civicrm_contact
- id - 1.5 - CASCADE + contact_id + civicrm_contact
+ id + 1.5 + CASCADE - membership_type_id - int unsigned - Membership Type Id - true - /^(m(embership\s)?type)$/i - false - true - FK to Membership Type - - civicrm_membership_type
- id - name - - - Select - - 1.5 + membership_type_id + int unsigned + Membership Type Id + true + /^(m(embership\s)?type)$/i + false + true + FK to Membership Type + + civicrm_membership_type
+ id + name + + + Select + + 1.5 - membership_type_id - civicrm_membership_type
- id - 1.5 - CASCADE + membership_type_id + civicrm_membership_type
+ id + 1.5 + CASCADE - 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 - - Select 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 + + Select Date + - start_date - membership_start_date - Membership Start Date - date - true - /(member(ship)?.)?start(s)?(.date$)?/i - /\d{4}-?\d{2}-?\d{2}/ - Beginning of current uninterrupted membership period. - 1.5 - - Select Date - + start_date + membership_start_date + Membership Start Date + date + true + /(member(ship)?.)?start(s)?(.date$)?/i + /\d{4}-?\d{2}-?\d{2}/ + Beginning of current uninterrupted membership period. + 1.5 + + Select 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 - - Select 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 + + Select Date + - source - membership_source - Source - true - /^(member(ship?))?source$/i - varchar - 128 - 1.5 - - Text - + source + membership_source + Source + true + /^(member(ship?))?source$/i + varchar + 128 + 1.5 + + Text + - status_id - Membership Status Id - true - /(member(ship|).)?(status)$/i - int unsigned - false - true - FK to Membership Status - - civicrm_membership_status
- id - label - - - Select - - 1.5 + status_id + Membership Status Id + true + /(member(ship|).)?(status)$/i + int unsigned + false + true + FK to Membership Status + + civicrm_membership_status
+ id + label + + + Select + + 1.5 - status_id - civicrm_membership_status
- id - 1.5 - CASCADE + status_id + civicrm_membership_status
+ id + 1.5 + CASCADE - 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. - - CheckBox - - 1.5 + 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. + + CheckBox + + 1.5 - owner_membership_id - int unsigned + owner_membership_id + int unsigned Primary Member ID - Optional FK to Parent Membership. - true - 1.7 + Optional FK to Parent Membership. + true + 1.7 - owner_membership_id - civicrm_membership
- id - 1.7 - SET NULL + owner_membership_id + civicrm_membership
+ id + 1.7 + SET NULL index_owner_membership_id @@ -184,38 +184,38 @@ 1.7 - max_related - int - Maximum number of related memberships (membership_type override). - 4.3 - - Text - + max_related + int + Maximum number of related memberships (membership_type override). + 4.3 + + Text + - is_test - Test - member_is_test - boolean - 0 - true - /(is.)?test(.member(ship)?)?/i - - CheckBox - + is_test + Test + member_is_test + boolean + 0 + true + /(is.)?test(.member(ship)?)?/i + + CheckBox + - is_pay_later - member_is_pay_later - Is Pay Later - boolean - 0 - true - /(is.)?(pay(.)?later)$/i - 2.1 - - CheckBox - + is_pay_later + member_is_pay_later + Is Pay Later + boolean + 0 + true + /(is.)?(pay(.)?later)$/i + 2.1 + + CheckBox + contribution_recur_id diff --git a/xml/schema/Member/MembershipBlock.xml b/xml/schema/Member/MembershipBlock.xml index ef1d5a1dd8..6a4ca68ba6 100644 --- a/xml/schema/Member/MembershipBlock.xml +++ b/xml/schema/Member/MembershipBlock.xml @@ -8,113 +8,113 @@ 1.5 true - id - int unsigned - true - Membership Id - 1.5 + id + int unsigned + true + Membership Id + 1.5 - id - true + id + true - entity_table - varchar - 64 - Name for Membership Status - 1.5 + entity_table + varchar + 64 + Name for Membership Status + 1.5 - entity_id - int unsigned - true - FK to civicrm_contribution_page.id - 1.5 + entity_id + int unsigned + true + FK to civicrm_contribution_page.id + 1.5 - entity_id - civicrm_contribution_page
- id - 1.5 + entity_id + civicrm_contribution_page
+ id + 1.5 - membership_types - varchar - 255 - Membership types to be exposed by this block - 1.5 + membership_types + varchar + 255 + Membership types to be exposed by this block + 1.5 - membership_type_default - int unsigned - Optional foreign key to membership_type - 1.5 + membership_type_default + int unsigned + Optional foreign key to membership_type + 1.5 - - membership_type_default - civicrm_membership_type
- id - 1.5 + + membership_type_default + civicrm_membership_type
+ id + 1.5 - display_min_fee - boolean - 1 - Display minimum membership fee - 1.5 + display_min_fee + boolean + 1 + Display minimum membership fee + 1.5 - is_separate_payment - boolean - 1 - Should membership transactions be processed separately - 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 + new_title + varchar + 255 + true + Title to display at top of block + 1.5 - new_text - text - true - Text to display below title - 1.5 + new_text + text + true + Text to display below title + 1.5 - - renewal_title - varchar - 255 - true - Title for renewal - 1.5 + + renewal_title + varchar + 255 + true + Title for renewal + 1.5 - - renewal_text - text - true - Text to display for member renewal - 1.5 + + renewal_text + text + true + Text to display for member renewal + 1.5 - - is_required - Is Required - boolean - 0 - Is membership sign up optional - 1.5 + + is_required + Is Required + boolean + 0 + Is membership sign up optional + 1.5 - is_active - Is Active - boolean - 1 - Is this membership_block enabled - 1.5 + is_active + Is Active + boolean + 1 + Is this membership_block enabled + 1.5 diff --git a/xml/schema/Member/MembershipLog.xml b/xml/schema/Member/MembershipLog.xml index 1c092bc14c..8310ec41d1 100644 --- a/xml/schema/Member/MembershipLog.xml +++ b/xml/schema/Member/MembershipLog.xml @@ -8,21 +8,21 @@ Logs actions which affect a Membership record (signup, status override, renewal, etc.) 1.5 - id - int unsigned - true - 1.5 + id + int unsigned + true + 1.5 - id - true + id + true - membership_id - int unsigned - true - FK to Membership table - 1.5 + membership_id + int unsigned + true + FK to Membership table + 1.5 membership_id @@ -32,72 +32,72 @@ CASCADE - status_id - Membership Status - int unsigned - true - New status assigned to membership by this action. FK to Membership Status - 1.5 + status_id + Membership Status + int unsigned + true + New status assigned to membership by this action. FK to Membership Status + 1.5 - status_id - civicrm_membership_status
- id - 1.5 - CASCADE + 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 - date - /\d{4}-?\d{2}-?\d{2}/ - New membership period expiration date. - 1.5 + end_date + date + /\d{4}-?\d{2}-?\d{2}/ + New membership period expiration date. + 1.5 - modified_id - int unsigned - FK to Contact ID of person under whose credentials this data modification was made. - 1.5 + modified_id + int unsigned + FK to Contact ID of person under whose credentials this data modification was made. + 1.5 - modified_id - civicrm_contact
- id - 1.5 - SET NULL + modified_id + civicrm_contact
+ id + 1.5 + SET NULL - modified_date - Membership Change Date - date - /\d{4}-?\d{2}-?\d{2}/ - Date this membership modification action was logged. - 1.5 + modified_date + Membership Change Date + date + /\d{4}-?\d{2}-?\d{2}/ + Date this membership modification action was logged. + 1.5 - membership_type_id - int unsigned - FK to Membership Type. - 3.4 + membership_type_id + int unsigned + FK to Membership Type. + 3.4 - membership_type_id - civicrm_membership_type
- id - 3.4 - SET NULL + membership_type_id + civicrm_membership_type
+ id + 3.4 + SET NULL - max_related - int - Maximum number of related memberships. - 4.3 + max_related + int + Maximum number of related memberships. + 4.3 diff --git a/xml/schema/Member/MembershipPayment.xml b/xml/schema/Member/MembershipPayment.xml index 8d5ff2b7a6..dec458571f 100644 --- a/xml/schema/Member/MembershipPayment.xml +++ b/xml/schema/Member/MembershipPayment.xml @@ -8,21 +8,21 @@ 1.5 true - id - int unsigned - true - 1.5 + id + int unsigned + true + 1.5 - id - true + id + true - membership_id - int unsigned - true - FK to Membership table - 1.5 + membership_id + int unsigned + true + FK to Membership table + 1.5 membership_id @@ -32,10 +32,10 @@ CASCADE - contribution_id - int unsigned - FK to contribution table. - 2.0 + contribution_id + int unsigned + FK to contribution table. + 2.0 contribution_id diff --git a/xml/schema/Member/MembershipStatus.xml b/xml/schema/Member/MembershipStatus.xml index 3033319ca5..14ae53aa4c 100644 --- a/xml/schema/Member/MembershipStatus.xml +++ b/xml/schema/Member/MembershipStatus.xml @@ -8,140 +8,140 @@ 1.5 true - id + id Membership Status ID - int unsigned - true - Membership Id - 1.5 + int unsigned + true + Membership Id + 1.5 - id - true + id + true - name - membership_status - Membership Status - varchar - true - 128 - Name for Membership Status - 1.5 + name + membership_status + Membership Status + varchar + true + 128 + Name for Membership Status + 1.5 - label - varchar - 128 - true - Label for Membership Status - 3.2 + label + varchar + 128 + true + Label for Membership Status + 3.2 - start_event - varchar - 12 - Event when this status starts. - - CRM_Core_SelectValues::eventDate - - 1.5 - - Select - + start_event + varchar + 12 + Event when this status starts. + + CRM_Core_SelectValues::eventDate + + 1.5 + + Select + - start_event_adjust_unit - varchar - 8 - Unit used for adjusting from start_event. - - CRM_Core_SelectValues::unitList - - 1.5 - - Select - + start_event_adjust_unit + varchar + 8 + Unit used for adjusting from start_event. + + CRM_Core_SelectValues::unitList + + 1.5 + + Select + - 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 - varchar - 12 - Event after which this status ends. - - CRM_Core_SelectValues::eventDate - - 1.5 - - Select - + end_event + varchar + 12 + Event after which this status ends. + + CRM_Core_SelectValues::eventDate + + 1.5 + + Select + - end_event_adjust_unit - varchar - 8 - Unit used for adjusting from the ending event. - - CRM_Core_SelectValues::unitList - - 1.5 - - Select - + end_event_adjust_unit + varchar + 8 + Unit used for adjusting from the ending event. + + CRM_Core_SelectValues::unitList + + 1.5 + + Select + - - end_event_adjust_interval - int - Status range ends this many units from end_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_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 - Admin Assigned Only? - boolean - Is this status for admin/manual assignment only. - 1.5 + is_admin + Admin Assigned Only? + boolean + Is this status for admin/manual assignment only. + 1.5 - weight - Weight - int - 1.5 + weight + Weight + int + 1.5 - is_default - Default Status? - boolean - Assign this status to a membership record if no other status match is found. - 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 - Is Active - boolean - 1 - Is this membership_status enabled. - 1.5 + is_active + Is Active + boolean + 1 + Is this membership_status enabled. + 1.5 - - is_reserved - Is Reserved - boolean - 0 - Is this membership_status reserved. - 2.1 + + is_reserved + Is Reserved + boolean + 0 + Is this membership_status reserved. + 2.1 diff --git a/xml/schema/Price/LineItem.xml b/xml/schema/Price/LineItem.xml index ae740f441c..1b57fb445c 100644 --- a/xml/schema/Price/LineItem.xml +++ b/xml/schema/Price/LineItem.xml @@ -114,9 +114,9 @@ int unsigned NULL Participant count for fiel - - Text - d + + Text + d 3.2 diff --git a/xml/schema/Price/PriceField.xml b/xml/schema/Price/PriceField.xml index 37ef91f5c3..5ff8825f6b 100644 --- a/xml/schema/Price/PriceField.xml +++ b/xml/schema/Price/PriceField.xml @@ -7,205 +7,205 @@ 1.8 true - id - int unsigned - true - Price Field - 1.8 + id + int unsigned + true + Price Field + 1.8 - id - true + id + true - price_set_id - int unsigned - true - FK to civicrm_price_set - 1.8 + price_set_id + int unsigned + true + FK to civicrm_price_set + 1.8 - price_set_id - civicrm_price_set
- id - 1.8 + price_set_id + civicrm_price_set
+ id + 1.8 - name - varchar - Name - 255 - true - Variable name/programmatic handle for this field. - 1.8 - - Text - + name + varchar + Name + 255 + true + Variable name/programmatic handle for this field. + 1.8 + + Text + - index_name - name - 1.8 + index_name + name + 1.8 - label - varchar - Label - 255 - true - true - Text for form field label (also friendly name for administering this field). - - Text - - 1.8 - - - html_type - varchar - 12 - true - - CRM_Price_BAO_PriceField::htmlTypes - - 1.8 - - Select - - - - is_enter_qty - boolean - 0 - Enter a quantity for this field? - 1.8 - - CheckBox - - - - help_pre - text - true - Description and/or help text to display before this field. - - TextArea - 4 - 80 - - 1.8 - - - help_post - text - true - Description and/or help text to display after this field. - - TextArea - 4 - 80 - - 1.8 - - - weight - int - 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 - int unsigned - 1 - number of options per line for checkbox and radio - 1.8 - - Text - - - - is_active - boolean - Is this price field active - 1 - 1.8 - - CheckBox - - - - is_required - boolean - Is this price field required (value must be > 1) - 1 - 1.8 - - CheckBox - - - - active_on - datetime - NULL - If non-zero, do not show this field before the date specified - 1.8 - - CheckBox - - - - expire_on - datetime - NULL - If non-zero, do not show this field after the date specified - 1.8 - - Select Date + label + varchar + Label + 255 + true + true + Text for form field label (also friendly name for administering this field). + + Text + + 1.8 + + + html_type + varchar + 12 + true + + CRM_Price_BAO_PriceField::htmlTypes + + 1.8 + + Select + + + + is_enter_qty + boolean + 0 + Enter a quantity for this field? + 1.8 + + CheckBox + + + + help_pre + text + true + Description and/or help text to display before this field. + + TextArea + 4 + 80 + + 1.8 + + + help_post + text + true + Description and/or help text to display after this field. + + TextArea + 4 + 80 + + 1.8 + + + weight + int + 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 + int unsigned + 1 + number of options per line for checkbox and radio + 1.8 + + Text - javascript - varchar - 255 - Optional scripting attributes for field - 1.8 - - Text - - - - visibility_id - int unsigned - 1 - Implicit FK to civicrm_option_group with name = \'visibility\' - 3.2 - - visibility - - - Select - - - - count - int unsigned - NULL - Number of Participants Per field - 3.2 - 3.3 - + is_active + boolean + Is this price field active + 1 + 1.8 + + CheckBox + + + + is_required + boolean + Is this price field required (value must be > 1) + 1 + 1.8 + + CheckBox + + + + active_on + datetime + NULL + If non-zero, do not show this field before the date specified + 1.8 + + CheckBox + + + + expire_on + datetime + NULL + If non-zero, do not show this field after the date specified + 1.8 + + Select Date + + + + javascript + varchar + 255 + Optional scripting attributes for field + 1.8 + + Text + + + + visibility_id + int unsigned + 1 + Implicit FK to civicrm_option_group with name = \'visibility\' + 3.2 + + visibility + + + Select + + + + count + int unsigned + NULL + Number of Participants Per field + 3.2 + 3.3 + diff --git a/xml/schema/Price/PriceFieldValue.xml b/xml/schema/Price/PriceFieldValue.xml index 096d6e9b33..19a89947e1 100644 --- a/xml/schema/Price/PriceFieldValue.xml +++ b/xml/schema/Price/PriceFieldValue.xml @@ -58,7 +58,7 @@ TextArea 2 - 60 + 60 NULL true diff --git a/xml/schema/Price/PriceSetEntity.xml b/xml/schema/Price/PriceSetEntity.xml index 4614eb7722..a6ec3c2713 100644 --- a/xml/schema/Price/PriceSetEntity.xml +++ b/xml/schema/Price/PriceSetEntity.xml @@ -7,54 +7,54 @@ 1.8 true - id - int unsigned - true - Price Set Entity - 1.8 + id + int unsigned + true + Price Set Entity + 1.8 - id - true + id + true - entity_table - varchar - 64 - true - Table which uses this price set - 1.8 + entity_table + varchar + 64 + true + Table which uses this price set + 1.8 - entity_id - int unsigned - true - Item in table - 1.8 + entity_id + int unsigned + true + Item in table + 1.8 - entity_id - entity_table - 1.8 + entity_id + entity_table + 1.8 - price_set_id - int unsigned - true - price set being used - 1.8 + price_set_id + int unsigned + true + price set being used + 1.8 - price_set_id - civicrm_price_set
- id + price_set_id + civicrm_price_set
+ id - UI_entity - entity_table - entity_id - true - 1.8 + UI_entity + entity_table + entity_id + true + 1.8 diff --git a/xml/schema/Report/ReportInstance.xml b/xml/schema/Report/ReportInstance.xml index 22afdffe57..461a94fed0 100644 --- a/xml/schema/Report/ReportInstance.xml +++ b/xml/schema/Report/ReportInstance.xml @@ -7,215 +7,215 @@ Users can save their report instance and put in a cron tab etc. 2.2 - id - Report Instance ID - int unsigned - true - Report Instance ID - 2.2 + id + Report Instance ID + int unsigned + true + Report Instance ID + 2.2 - id - false + id + false - domain_id - Report Instance Domain ID - int unsigned - - civicrm_domain
- id - name - - true - Which Domain is this instance for - 3.1 + domain_id + Report Instance Domain ID + int unsigned + + civicrm_domain
+ id + name + + true + Which Domain is this instance for + 3.1 - domain_id - civicrm_domain
- id - 3.1 + domain_id + civicrm_domain
+ id + 3.1 - title - Report Instance Title - varchar - 255 - Report Instance Title. - - Text - - 2.2 - - - report_id - Report template ID - varchar - 64 - true - FK to civicrm_option_value for the report template - - Select - - 2.2 - - - name - Report instance Name - varchar - 255 - when combined with report_id/template uniquely identifies the instance - - Text - - 3.2 - - - args - Report Instance Arguments - varchar - 255 - arguments that are passed in the url when invoking the instance - 3.2 - - Text - - - - description - Report Instance description - varchar - 255 - Report Instance description. - - Text - - 2.2 - - - permission - Report Instance Permissions - varchar - 255 - permission required to be able to run this instance - - Text - - 2.2 - - - grouprole - Report Instance Assigned to Roles - varchar - 1024 - role required to be able to run this instance - 4.1 - - Text - - - - form_values - Submitted Form Values - text - true - Submitted form values for this report - 2.2 - - - is_active - Report Instance is Active - boolean - Is this entry active? - - CheckBox - - 2.2 - - - email_subject - Report Instance email Subject - varchar - 255 - Subject of email - - Text - - - - email_to - Email Report Instance To - text - comma-separated list of email addresses to send the report to - - Text - - 2.2 - - - email_cc - cc Email Report Instance To - text - comma-separated list of email addresses to send the report to - - Text - - 2.2 - - - header - Report Instance Header - text - comma-separated list of email addresses to send the report to - - TextArea - 4 - 60 - - 2.2 - - - footer - Report Instance Footer - text - comma-separated list of email addresses to send the report to - - TextArea - 4 - 60 - - 2.2 - - - navigation_id - Navigation ID - int unsigned - true - FK to navigation ID - 3.0 + title + Report Instance Title + varchar + 255 + Report Instance Title. + + Text + + 2.2 + + + report_id + Report template ID + varchar + 64 + true + FK to civicrm_option_value for the report template + + Select + + 2.2 + + + name + Report instance Name + varchar + 255 + when combined with report_id/template uniquely identifies the instance + + Text + + 3.2 + + + args + Report Instance Arguments + varchar + 255 + arguments that are passed in the url when invoking the instance + 3.2 + + Text + + + + description + Report Instance description + varchar + 255 + Report Instance description. + + Text + + 2.2 + + + permission + Report Instance Permissions + varchar + 255 + permission required to be able to run this instance + + Text + + 2.2 + + + grouprole + Report Instance Assigned to Roles + varchar + 1024 + role required to be able to run this instance + 4.1 + + Text + + + + form_values + Submitted Form Values + text + true + Submitted form values for this report + 2.2 + + + is_active + Report Instance is Active + boolean + Is this entry active? + + CheckBox + + 2.2 + + + email_subject + Report Instance email Subject + varchar + 255 + Subject of email + + Text + + + + email_to + Email Report Instance To + text + comma-separated list of email addresses to send the report to + + Text + + 2.2 + + + email_cc + cc Email Report Instance To + text + comma-separated list of email addresses to send the report to + + Text + + 2.2 + + + header + Report Instance Header + text + comma-separated list of email addresses to send the report to + + TextArea + 4 + 60 + + 2.2 + + + footer + Report Instance Footer + text + comma-separated list of email addresses to send the report to + + TextArea + 4 + 60 + + 2.2 + + + navigation_id + Navigation ID + int unsigned + true + FK to navigation ID + 3.0 - navigation_id - civicrm_navigation
- id - 3.0 - SET NULL + navigation_id + civicrm_navigation
+ id + 3.0 + SET NULL - drilldown_id - Drilldown Report ID - int unsigned - true - FK to instance ID drilldown to - 4.3 + drilldown_id + Drilldown Report ID + int unsigned + true + FK to instance ID drilldown to + 4.3 - drilldown_id - civicrm_report_instance
- id - 4.3 - SET NULL + drilldown_id + civicrm_report_instance
+ id + 4.3 + SET NULL is_reserved diff --git a/xml/schema/SMS/History.xml b/xml/schema/SMS/History.xml index c5713abffe..550b4b8a2c 100644 --- a/xml/schema/SMS/History.xml +++ b/xml/schema/SMS/History.xml @@ -8,47 +8,47 @@ 1.4 2.0 - id - int unsigned - true - SMS History ID - 1.4 + id + int unsigned + true + SMS History ID + 1.4 - id - true + id + true - message - text - Contents of the SMS. - - TextArea - 5 - 80 - - 1.4 + message + text + Contents of the SMS. + + TextArea + 5 + 80 + + 1.4 - contact_id - int unsigned - true - FK to Contact who is sending this SMS - 1.4 - - Autocomplete-Select - + contact_id + int unsigned + true + FK to Contact who is sending this SMS + 1.4 + + Autocomplete-Select + - contact_id - civicrm_contact
- id - 1.4 + contact_id + civicrm_contact
+ id + 1.4 - sent_date - date - When was this SMS sent - 1.4 + sent_date + date + When was this SMS sent + 1.4 diff --git a/xml/schema/SMS/Provider.xml b/xml/schema/SMS/Provider.xml index b6db936a55..ed2e797687 100644 --- a/xml/schema/SMS/Provider.xml +++ b/xml/schema/SMS/Provider.xml @@ -7,95 +7,95 @@ Table to add different sms providers 4.2 - id - int unsigned - true - SMS Provider ID - 4.2 + id + int unsigned + true + SMS Provider ID + 4.2 - id - true + id + true - name - varchar - 64 - Provider internal name points to option_value of option_group sms_provider_name - 4.2 + name + varchar + 64 + Provider internal name points to option_value of option_group sms_provider_name + 4.2 - title - varchar - 64 - Provider name visible to user - - Text - - 4.2 + title + varchar + 64 + Provider name visible to user + + Text + + 4.2 - username - varchar - 255 - - Text - - 4.2 + username + varchar + 255 + + Text + + 4.2 - password - varchar - 255 - - Text - - 4.2 + password + varchar + 255 + + Text + + 4.2 - api_type - int unsigned - true - points to value in civicrm_option_value for group sms_api_type - - Select - - 4.2 + api_type + int unsigned + true + points to value in civicrm_option_value for group sms_api_type + + Select + + 4.2 - api_url - varchar - 128 - - Text - - 4.2 + api_url + varchar + 128 + + Text + + 4.2 - api_params - text - the api params in xml, http or smtp format - - Text - - 4.2 + api_params + text + the api params in xml, http or smtp format + + Text + + 4.2 - - is_default - boolean - 0 - 4.2 - - CheckBox - + + is_default + boolean + 0 + 4.2 + + CheckBox + - - is_active - boolean - 0 - 4.2 - - CheckBox - + + is_active + boolean + 0 + 4.2 + + CheckBox + diff --git a/xml/schema/Standalone/OpenID/Associations.xml b/xml/schema/Standalone/OpenID/Associations.xml index 07a379bbe9..b4f693fbe9 100644 --- a/xml/schema/Standalone/OpenID/Associations.xml +++ b/xml/schema/Standalone/OpenID/Associations.xml @@ -7,58 +7,58 @@ The OpenID associations store for standalone login. 2.0 - id - int unsigned - true - 2.0 + id + int unsigned + true + 2.0 - id - true + id + true - server_url - blob - 2.0 + server_url + blob + 2.0 - handle - varchar - 255 - - Text - - 2.0 + handle + varchar + 255 + + Text + + 2.0 - secret - blob - 2.0 + secret + blob + 2.0 - issued - int - 2.0 + issued + int + 2.0 - lifetime - int - 2.0 + lifetime + int + 2.0 - assoc_type - varchar - 64 - - Text - - 2.0 + assoc_type + varchar + 64 + + Text + + 2.0 - server_url_handle_index - server_url - handle - true - 2.0 + server_url_handle_index + server_url + handle + true + 2.0 diff --git a/xml/schema/Standalone/OpenID/Nonce.xml b/xml/schema/Standalone/OpenID/Nonce.xml index 9023c97ae0..60b502a1e2 100644 --- a/xml/schema/Standalone/OpenID/Nonce.xml +++ b/xml/schema/Standalone/OpenID/Nonce.xml @@ -7,37 +7,37 @@ The OpenID nonce store for standalone login. 2.0 - id - int unsigned - true - 2.0 + id + int unsigned + true + 2.0 - id - true + id + true - server_url - blob - 2.0 + server_url + blob + 2.0 - timestamp - int - 2.0 + timestamp + int + 2.0 - salt - char - 40 - 2.0 + salt + char + 40 + 2.0 - nonce_index - server_url - timestamp - salt - true - 2.0 + nonce_index + server_url + timestamp + salt + true + 2.0 - \ No newline at end of file + -- 2.25.1