3 +--------------------------------------------------------------------+
5 +--------------------------------------------------------------------+
6 | Copyright CiviCRM LLC (c) 2004-2019 |
7 +--------------------------------------------------------------------+
8 | This file is a part of CiviCRM. |
10 | CiviCRM is free software; you can copy, modify, and distribute it |
11 | under the terms of the GNU Affero General Public License |
12 | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. |
14 | CiviCRM is distributed in the hope that it will be useful, but |
15 | WITHOUT ANY WARRANTY; without even the implied warranty of |
16 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. |
17 | See the GNU Affero General Public License for more details. |
19 | You should have received a copy of the GNU Affero General Public |
20 | License and the CiviCRM Licensing Exception along |
21 | with this program; if not, contact CiviCRM LLC |
22 | at info[AT]civicrm[DOT]org. If you have questions about the |
23 | GNU Affero General Public License or the licensing of CiviCRM, |
24 | see the CiviCRM license FAQ at http://civicrm.org/licensing |
25 +--------------------------------------------------------------------+
31 * @copyright CiviCRM LLC (c) 2004-2019
33 * Generated from schema_structure.tpl
34 * DO NOT EDIT. Generated by CRM_Core_CodeGen
36 class CRM_Core_I18n_SchemaStructure_5_20_alpha1
{
39 * Get translatable columns.
42 * A table-indexed array of translatable columns.
44 public static function &columns() {
45 static $result = NULL;
48 'civicrm_location_type' => [
49 'display_name' => "varchar(64) COMMENT 'Location Type Display Name.'",
51 'civicrm_option_group' => [
52 'title' => "varchar(255) COMMENT 'Option Group title.'",
53 'description' => "varchar(255) COMMENT 'Option group description.'",
55 'civicrm_relationship_type' => [
56 'label_a_b' => "varchar(64) COMMENT 'label for relationship of contact_a to contact_b.'",
57 'label_b_a' => "varchar(64) COMMENT 'Optional label for relationship of contact_b to contact_a.'",
58 'description' => "varchar(255) COMMENT 'Optional verbose description of the relationship type.'",
60 'civicrm_contact_type' => [
61 'label' => "varchar(64) COMMENT 'localized Name of Contact Type.'",
62 'description' => "text COMMENT 'localized Optional verbose description of the type.'",
65 'title' => "varchar(255) COMMENT 'Friendly Name.'",
66 'description' => "text COMMENT 'Description of this batch set.'",
68 'civicrm_premiums' => [
69 'premiums_intro_title' => "varchar(255) COMMENT 'Title for Premiums section.'",
70 'premiums_intro_text' => "text COMMENT 'Displayed in <div> at top of Premiums section of page. Text and HTML allowed.'",
71 'premiums_nothankyou_label' => "varchar(255) COMMENT 'Label displayed for No Thank-you option in premiums block (e.g. No thank you)'",
73 'civicrm_membership_status' => [
74 'label' => "varchar(128) COMMENT 'Label for Membership Status'",
77 'title' => "varchar(255) NOT NULL COMMENT 'Title of the Survey.'",
78 'instructions' => "text COMMENT 'Script instructions for volunteers to use for the survey.'",
79 'thankyou_title' => "varchar(255) COMMENT 'Title for Thank-you page (header title tag, and display at the top of the page).'",
80 'thankyou_text' => "text COMMENT 'text and html allowed. displayed above result on success page'",
82 'civicrm_participant_status_type' => [
83 'label' => "varchar(255) COMMENT 'localized label for display of this status type'",
85 'civicrm_case_type' => [
86 'title' => "varchar(64) NOT NULL COMMENT 'Natural language name for Case Type'",
87 'description' => "varchar(255) COMMENT 'Description of the Case Type'",
89 'civicrm_tell_friend' => [
90 'title' => "varchar(255)",
91 'intro' => "text COMMENT 'Introductory message to contributor or participant displayed on the Tell a Friend form.'",
92 'suggested_message' => "text COMMENT 'Suggested message to friends, provided as default on the Tell A Friend form.'",
93 'thankyou_title' => "varchar(255) COMMENT 'Text for Tell a Friend thank you page header and HTML title.'",
94 'thankyou_text' => "text COMMENT 'Thank you message displayed on success page.'",
96 'civicrm_custom_group' => [
97 'title' => "varchar(64) NOT NULL COMMENT 'Friendly Name.'",
98 'help_pre' => "text COMMENT 'Description and/or help text to display before fields in form.'",
99 'help_post' => "text COMMENT 'Description and/or help text to display after fields in form.'",
101 'civicrm_custom_field' => [
102 'label' => "varchar(255) NOT NULL COMMENT 'Text for form field label (also friendly name for administering this custom property).'",
103 'help_pre' => "text COMMENT 'Description and/or help text to display before this field.'",
104 'help_post' => "text COMMENT 'Description and/or help text to display after this field.'",
106 'civicrm_option_value' => [
107 'label' => "varchar(512) NOT NULL COMMENT 'Option string as displayed to users - e.g. the label in an HTML OPTION tag.'",
108 'description' => "text COMMENT 'Optional description.'",
111 'title' => "varchar(64) COMMENT 'Name of Group.'",
113 'civicrm_contribution_page' => [
114 'title' => "varchar(255) COMMENT 'Contribution Page title. For top of page display'",
115 'intro_text' => "text COMMENT 'Text and html allowed. Displayed below title.'",
116 'pay_later_text' => "text COMMENT 'The text displayed to the user in the main form'",
117 'pay_later_receipt' => "text COMMENT 'The receipt sent to the user instead of the normal receipt text'",
118 'initial_amount_label' => "varchar(255) COMMENT 'Initial amount label for partial payment'",
119 'initial_amount_help_text' => "text COMMENT 'Initial amount help text for partial payment'",
120 'thankyou_title' => "varchar(255) COMMENT 'Title for Thank-you page (header title tag, and display at the top of the page).'",
121 'thankyou_text' => "text COMMENT 'text and html allowed. displayed above result on success page'",
122 'thankyou_footer' => "text COMMENT 'Text and html allowed. displayed at the bottom of the success page. Common usage is to include link(s) to other pages such as tell-a-friend, etc.'",
123 'receipt_from_name' => "varchar(255) COMMENT 'FROM email name used for receipts generated by contributions to this contribution page.'",
124 'receipt_text' => "text COMMENT 'text to include above standard receipt info on receipt email. emails are text-only, so do not allow html for now'",
125 'footer_text' => "text COMMENT 'Text and html allowed. Displayed at the bottom of the first page of the contribution wizard.'",
126 'frontend_title' => "varchar(255) COMMENT 'Contribution Page Public title'",
128 'civicrm_product' => [
129 'name' => "varchar(255) NOT NULL COMMENT 'Required product/premium name'",
130 'description' => "text COMMENT 'Optional description of the product/premium.'",
131 'options' => "text COMMENT 'Store comma-delimited list of color, size, etc. options for the product.'",
133 'civicrm_payment_processor' => [
134 'title' => "varchar(127) COMMENT 'Payment Processor Descriptive Name.'",
136 'civicrm_membership_type' => [
137 'name' => "varchar(128) COMMENT 'Name of Membership Type'",
138 'description' => "varchar(255) COMMENT 'Description of Membership Type'",
140 'civicrm_membership_block' => [
141 'new_title' => "varchar(255) COMMENT 'Title to display at top of block'",
142 'new_text' => "text COMMENT 'Text to display below title'",
143 'renewal_title' => "varchar(255) COMMENT 'Title for renewal'",
144 'renewal_text' => "text COMMENT 'Text to display for member renewal'",
146 'civicrm_price_set' => [
147 'title' => "varchar(255) NOT NULL COMMENT 'Displayed title for the Price Set.'",
148 'help_pre' => "text COMMENT 'Description and/or help text to display before fields in form.'",
149 'help_post' => "text COMMENT 'Description and/or help text to display after fields in form.'",
151 'civicrm_dashboard' => [
152 'label' => "varchar(255) COMMENT 'dashlet title'",
154 'civicrm_uf_group' => [
155 'title' => "varchar(64) NOT NULL COMMENT 'Form title.'",
156 'frontend_title' => "varchar(64) COMMENT 'Profile Form Public title'",
157 'help_pre' => "text COMMENT 'Description and/or help text to display before fields in form.'",
158 'help_post' => "text COMMENT 'Description and/or help text to display after fields in form.'",
159 'cancel_button_text' => "varchar(64) DEFAULT NULL COMMENT 'Custom Text to display on the Cancel button when used in create or edit mode'",
160 'submit_button_text' => "varchar(64) DEFAULT NULL COMMENT 'Custom Text to display on the submit button on profile edit/create screens'",
162 'civicrm_uf_field' => [
163 'help_post' => "text COMMENT 'Description and/or help text to display after this field.'",
164 'help_pre' => "text COMMENT 'Description and/or help text to display before this field.'",
165 'label' => "varchar(255) NOT NULL COMMENT 'To save label for fields.'",
167 'civicrm_price_field' => [
168 'label' => "varchar(255) NOT NULL COMMENT 'Text for form field label (also friendly name for administering this field).'",
169 'help_pre' => "text COMMENT 'Description and/or help text to display before this field.'",
170 'help_post' => "text COMMENT 'Description and/or help text to display after this field.'",
172 'civicrm_price_field_value' => [
173 'label' => "varchar(255) COMMENT 'Price field option label'",
174 'description' => "text DEFAULT NULL COMMENT 'Price field option description.'",
175 'help_pre' => "text DEFAULT NULL COMMENT 'Price field option pre help text.'",
176 'help_post' => "text DEFAULT NULL COMMENT 'Price field option post field help.'",
178 'civicrm_pcp_block' => [
179 'link_text' => "varchar(255) DEFAULT NULL COMMENT 'Link text for PCP.'",
182 'title' => "varchar(255) COMMENT 'Event Title (e.g. Fall Fundraiser Dinner)'",
183 'summary' => "text COMMENT 'Brief summary of event. Text and html allowed. Displayed on Event Registration form and can be used on other CMS pages which need an event summary.'",
184 'description' => "text COMMENT 'Full description of event. Text and html allowed. Displayed on built-in Event Information screens.'",
185 'registration_link_text' => "varchar(255) COMMENT 'Text for link to Event Registration form which is displayed on Event Information screen when is_online_registration is true.'",
186 'event_full_text' => "text COMMENT 'Message to display on Event Information page and INSTEAD OF Event Registration form if maximum participants are signed up. Can include email address/info about getting on a waiting list, etc. Text and html allowed.'",
187 'fee_label' => "varchar(255)",
188 'intro_text' => "text COMMENT 'Introductory message for Event Registration page. Text and html allowed. Displayed at the top of Event Registration form.'",
189 'footer_text' => "text COMMENT 'Footer message for Event Registration page. Text and html allowed. Displayed at the bottom of Event Registration form.'",
190 'confirm_title' => "varchar(255) DEFAULT NULL COMMENT 'Title for Confirmation page.'",
191 'confirm_text' => "text COMMENT 'Introductory message for Event Registration page. Text and html allowed. Displayed at the top of Event Registration form.'",
192 'confirm_footer_text' => "text COMMENT 'Footer message for Event Registration page. Text and html allowed. Displayed at the bottom of Event Registration form.'",
193 'confirm_email_text' => "text COMMENT 'text to include above standard event info on confirmation email. emails are text-only, so do not allow html for now'",
194 'confirm_from_name' => "varchar(255) COMMENT 'FROM email name used for confirmation emails.'",
195 'thankyou_title' => "varchar(255) DEFAULT NULL COMMENT 'Title for ThankYou page.'",
196 'thankyou_text' => "text COMMENT 'ThankYou Text.'",
197 'thankyou_footer_text' => "text COMMENT 'Footer message.'",
198 'pay_later_text' => "text COMMENT 'The text displayed to the user in the main form'",
199 'pay_later_receipt' => "text COMMENT 'The receipt sent to the user instead of the normal receipt text'",
200 'initial_amount_label' => "varchar(255) COMMENT 'Initial amount label for partial payment'",
201 'initial_amount_help_text' => "text COMMENT 'Initial amount help text for partial payment'",
202 'waitlist_text' => "text COMMENT 'Text to display when the event is full, but participants can signup for a waitlist.'",
203 'approval_req_text' => "text COMMENT 'Text to display when the approval is required to complete registration for an event.'",
204 'template_title' => "varchar(255) COMMENT 'Event Template Title'",
212 * Get a table indexed array of the indices for translatable fields.
215 * Indices for translatable fields.
217 public static function &indices() {
218 static $result = NULL;
221 'civicrm_custom_group' => [
222 'UI_title_extends' => [
223 'name' => 'UI_title_extends',
231 'civicrm_custom_field' => [
232 'UI_label_custom_group_id' => [
233 'name' => 'UI_label_custom_group_id',
243 'name' => 'UI_title',
256 * Get tables with translatable fields.
259 * Array of names of tables with fields that can be translated.
261 public static function &tables() {
262 static $result = NULL;
264 $result = array_keys(self
::columns());
270 * Get a list of widgets for editing translatable fields.
273 * Array of the widgets for editing translatable fields.
275 public static function &widgets() {
276 static $result = NULL;
279 'civicrm_location_type' => [
284 'civicrm_option_group' => [
292 'civicrm_relationship_type' => [
303 'civicrm_contact_type' => [
308 'type' => "TextArea",
318 'type' => "TextArea",
323 'civicrm_premiums' => [
324 'premiums_intro_title' => [
327 'premiums_intro_text' => [
330 'premiums_nothankyou_label' => [
334 'civicrm_membership_status' => [
339 'civicrm_survey' => [
342 'required' => "true",
345 'type' => "TextArea",
349 'thankyou_title' => [
353 'type' => "TextArea",
358 'civicrm_participant_status_type' => [
363 'civicrm_case_type' => [
366 'required' => "true",
372 'civicrm_tell_friend' => [
379 'suggested_message' => [
382 'thankyou_title' => [
389 'civicrm_custom_group' => [
392 'required' => "true",
395 'type' => "TextArea",
400 'type' => "TextArea",
405 'civicrm_custom_field' => [
408 'required' => "true",
417 'civicrm_option_value' => [
420 'required' => "true",
423 'type' => "TextArea",
433 'civicrm_contribution_page' => [
438 'type' => "RichTextEditor",
442 'pay_later_text' => [
445 'pay_later_receipt' => [
448 'initial_amount_label' => [
451 'initial_amount_help_text' => [
454 'thankyou_title' => [
458 'type' => "RichTextEditor",
462 'thankyou_footer' => [
463 'type' => "RichTextEditor",
467 'receipt_from_name' => [
471 'type' => "TextArea",
476 'type' => "RichTextEditor",
480 'frontend_title' => [
484 'civicrm_product' => [
487 'required' => "true",
496 'civicrm_payment_processor' => [
501 'civicrm_membership_type' => [
507 'type' => "TextArea",
510 'label' => "Description",
513 'civicrm_membership_block' => [
527 'civicrm_price_set' => [
530 'required' => "true",
533 'type' => "TextArea",
538 'type' => "TextArea",
543 'civicrm_dashboard' => [
548 'civicrm_uf_group' => [
551 'required' => "true",
553 'frontend_title' => [
557 'type' => "TextArea",
562 'type' => "TextArea",
566 'cancel_button_text' => [
569 'submit_button_text' => [
573 'civicrm_uf_field' => [
582 'required' => "true",
585 'civicrm_price_field' => [
588 'required' => "true",
591 'type' => "TextArea",
596 'type' => "TextArea",
601 'civicrm_price_field_value' => [
606 'type' => "TextArea",
611 'type' => "TextArea",
616 'type' => "TextArea",
621 'civicrm_pcp_block' => [
631 'type' => "TextArea",
636 'type' => "RichTextEditor",
640 'registration_link_text' => [
643 'event_full_text' => [
644 'type' => "TextArea",
652 'type' => "RichTextEditor",
657 'type' => "RichTextEditor",
665 'type' => "RichTextEditor",
669 'confirm_footer_text' => [
670 'type' => "RichTextEditor",
674 'confirm_email_text' => [
675 'type' => "TextArea",
679 'confirm_from_name' => [
682 'thankyou_title' => [
686 'type' => "RichTextEditor",
690 'thankyou_footer_text' => [
691 'type' => "RichTextEditor",
695 'pay_later_text' => [
696 'type' => "RichTextEditor",
698 'pay_later_receipt' => [
701 'initial_amount_label' => [
704 'initial_amount_help_text' => [
708 'type' => "TextArea",
712 'approval_req_text' => [
713 'type' => "TextArea",
717 'template_title' => [