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
{
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.'",
127 'civicrm_product' => [
128 'name' => "varchar(255) NOT NULL COMMENT 'Required product/premium name'",
129 'description' => "text COMMENT 'Optional description of the product/premium.'",
130 'options' => "text COMMENT 'Store comma-delimited list of color, size, etc. options for the product.'",
132 'civicrm_payment_processor' => [
133 'title' => "varchar(127) COMMENT 'Payment Processor Descriptive Name.'",
135 'civicrm_membership_type' => [
136 'name' => "varchar(128) COMMENT 'Name of Membership Type'",
137 'description' => "varchar(255) COMMENT 'Description of Membership Type'",
139 'civicrm_membership_block' => [
140 'new_title' => "varchar(255) COMMENT 'Title to display at top of block'",
141 'new_text' => "text COMMENT 'Text to display below title'",
142 'renewal_title' => "varchar(255) COMMENT 'Title for renewal'",
143 'renewal_text' => "text COMMENT 'Text to display for member renewal'",
145 'civicrm_price_set' => [
146 'title' => "varchar(255) NOT NULL COMMENT 'Displayed title for the Price Set.'",
147 'help_pre' => "text COMMENT 'Description and/or help text to display before fields in form.'",
148 'help_post' => "text COMMENT 'Description and/or help text to display after fields in form.'",
150 'civicrm_dashboard' => [
151 'label' => "varchar(255) COMMENT 'dashlet title'",
153 'civicrm_uf_group' => [
154 'title' => "varchar(64) NOT NULL COMMENT 'Form title.'",
155 'frontend_title' => "varchar(64) COMMENT 'Profile Form Public title'",
156 'help_pre' => "text COMMENT 'Description and/or help text to display before fields in form.'",
157 'help_post' => "text COMMENT 'Description and/or help text to display after fields in form.'",
158 'cancel_button_text' => "varchar(64) DEFAULT NULL COMMENT 'Custom Text to display on the Cancel button when used in create or edit mode'",
159 'submit_button_text' => "varchar(64) DEFAULT NULL COMMENT 'Custom Text to display on the submit button on profile edit/create screens'",
161 'civicrm_uf_field' => [
162 'help_post' => "text COMMENT 'Description and/or help text to display after this field.'",
163 'help_pre' => "text COMMENT 'Description and/or help text to display before this field.'",
164 'label' => "varchar(255) NOT NULL COMMENT 'To save label for fields.'",
166 'civicrm_price_field' => [
167 'label' => "varchar(255) NOT NULL COMMENT 'Text for form field label (also friendly name for administering this field).'",
168 'help_pre' => "text COMMENT 'Description and/or help text to display before this field.'",
169 'help_post' => "text COMMENT 'Description and/or help text to display after this field.'",
171 'civicrm_price_field_value' => [
172 'label' => "varchar(255) COMMENT 'Price field option label'",
173 'description' => "text DEFAULT NULL COMMENT 'Price field option description.'",
174 'help_pre' => "text DEFAULT NULL COMMENT 'Price field option pre help text.'",
175 'help_post' => "text DEFAULT NULL COMMENT 'Price field option post field help.'",
177 'civicrm_pcp_block' => [
178 'link_text' => "varchar(255) DEFAULT NULL COMMENT 'Link text for PCP.'",
181 'title' => "varchar(255) COMMENT 'Event Title (e.g. Fall Fundraiser Dinner)'",
182 '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.'",
183 'description' => "text COMMENT 'Full description of event. Text and html allowed. Displayed on built-in Event Information screens.'",
184 '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.'",
185 '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.'",
186 'fee_label' => "varchar(255)",
187 'intro_text' => "text COMMENT 'Introductory message for Event Registration page. Text and html allowed. Displayed at the top of Event Registration form.'",
188 'footer_text' => "text COMMENT 'Footer message for Event Registration page. Text and html allowed. Displayed at the bottom of Event Registration form.'",
189 'confirm_title' => "varchar(255) DEFAULT NULL COMMENT 'Title for Confirmation page.'",
190 'confirm_text' => "text COMMENT 'Introductory message for Event Registration page. Text and html allowed. Displayed at the top of Event Registration form.'",
191 'confirm_footer_text' => "text COMMENT 'Footer message for Event Registration page. Text and html allowed. Displayed at the bottom of Event Registration form.'",
192 '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'",
193 'confirm_from_name' => "varchar(255) COMMENT 'FROM email name used for confirmation emails.'",
194 'thankyou_title' => "varchar(255) DEFAULT NULL COMMENT 'Title for ThankYou page.'",
195 'thankyou_text' => "text COMMENT 'ThankYou Text.'",
196 'thankyou_footer_text' => "text COMMENT 'Footer message.'",
197 'pay_later_text' => "text COMMENT 'The text displayed to the user in the main form'",
198 'pay_later_receipt' => "text COMMENT 'The receipt sent to the user instead of the normal receipt text'",
199 'initial_amount_label' => "varchar(255) COMMENT 'Initial amount label for partial payment'",
200 'initial_amount_help_text' => "text COMMENT 'Initial amount help text for partial payment'",
201 'waitlist_text' => "text COMMENT 'Text to display when the event is full, but participants can signup for a waitlist.'",
202 'approval_req_text' => "text COMMENT 'Text to display when the approval is required to complete registration for an event.'",
203 'template_title' => "varchar(255) COMMENT 'Event Template Title'",
211 * Get a table indexed array of the indices for translatable fields.
214 * Indices for translatable fields.
216 public static function &indices() {
217 static $result = NULL;
220 'civicrm_custom_group' => [
221 'UI_title_extends' => [
222 'name' => 'UI_title_extends',
230 'civicrm_custom_field' => [
231 'UI_label_custom_group_id' => [
232 'name' => 'UI_label_custom_group_id',
242 'name' => 'UI_title',
255 * Get tables with translatable fields.
258 * Array of names of tables with fields that can be translated.
260 public static function &tables() {
261 static $result = NULL;
263 $result = array_keys(self
::columns());
269 * Get a list of widgets for editing translatable fields.
272 * Array of the widgets for editing translatable fields.
274 public static function &widgets() {
275 static $result = NULL;
278 'civicrm_location_type' => [
283 'civicrm_option_group' => [
291 'civicrm_relationship_type' => [
302 'civicrm_contact_type' => [
307 'type' => "TextArea",
317 'type' => "TextArea",
322 'civicrm_premiums' => [
323 'premiums_intro_title' => [
326 'premiums_intro_text' => [
329 'premiums_nothankyou_label' => [
333 'civicrm_membership_status' => [
338 'civicrm_survey' => [
341 'required' => "true",
344 'type' => "TextArea",
348 'thankyou_title' => [
352 'type' => "TextArea",
357 'civicrm_participant_status_type' => [
362 'civicrm_case_type' => [
365 'required' => "true",
371 'civicrm_tell_friend' => [
378 'suggested_message' => [
381 'thankyou_title' => [
388 'civicrm_custom_group' => [
391 'required' => "true",
394 'type' => "TextArea",
399 'type' => "TextArea",
404 'civicrm_custom_field' => [
407 'required' => "true",
416 'civicrm_option_value' => [
419 'required' => "true",
422 'type' => "TextArea",
432 'civicrm_contribution_page' => [
437 'type' => "RichTextEditor",
441 'pay_later_text' => [
444 'pay_later_receipt' => [
447 'initial_amount_label' => [
450 'initial_amount_help_text' => [
453 'thankyou_title' => [
457 'type' => "RichTextEditor",
461 'thankyou_footer' => [
462 'type' => "RichTextEditor",
466 'receipt_from_name' => [
470 'type' => "TextArea",
475 'type' => "RichTextEditor",
480 'civicrm_product' => [
483 'required' => "true",
492 'civicrm_payment_processor' => [
497 'civicrm_membership_type' => [
503 'type' => "TextArea",
506 'label' => "Description",
509 'civicrm_membership_block' => [
523 'civicrm_price_set' => [
526 'required' => "true",
529 'type' => "TextArea",
534 'type' => "TextArea",
539 'civicrm_dashboard' => [
544 'civicrm_uf_group' => [
547 'required' => "true",
549 'frontend_title' => [
553 'type' => "TextArea",
558 'type' => "TextArea",
562 'cancel_button_text' => [
565 'submit_button_text' => [
569 'civicrm_uf_field' => [
578 'required' => "true",
581 'civicrm_price_field' => [
584 'required' => "true",
587 'type' => "TextArea",
592 'type' => "TextArea",
597 'civicrm_price_field_value' => [
602 'type' => "TextArea",
607 'type' => "TextArea",
612 'type' => "TextArea",
617 'civicrm_pcp_block' => [
627 'type' => "TextArea",
632 'type' => "RichTextEditor",
636 'registration_link_text' => [
639 'event_full_text' => [
640 'type' => "TextArea",
648 'type' => "RichTextEditor",
653 'type' => "RichTextEditor",
661 'type' => "RichTextEditor",
665 'confirm_footer_text' => [
666 'type' => "RichTextEditor",
670 'confirm_email_text' => [
671 'type' => "TextArea",
675 'confirm_from_name' => [
678 'thankyou_title' => [
682 'type' => "RichTextEditor",
686 'thankyou_footer_text' => [
687 'type' => "RichTextEditor",
691 'pay_later_text' => [
692 'type' => "RichTextEditor",
694 'pay_later_receipt' => [
697 'initial_amount_label' => [
700 'initial_amount_help_text' => [
704 'type' => "TextArea",
708 'approval_req_text' => [
709 'type' => "TextArea",
713 'template_title' => [