3 +--------------------------------------------------------------------+
4 | CiviCRM version 4.7 |
5 +--------------------------------------------------------------------+
6 | Copyright CiviCRM LLC (c) 2004-2018 |
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-2018
35 class CRM_Core_I18n_SchemaStructure_3_4_beta2
{
39 public static function &columns() {
40 static $result = NULL;
43 'civicrm_option_group' => array(
44 'label' => "varchar(255)",
45 'description' => "varchar(255)",
47 'civicrm_contact' => array(
48 'sort_name' => "varchar(128)",
49 'display_name' => "varchar(128)",
50 'first_name' => "varchar(64)",
51 'middle_name' => "varchar(64)",
52 'last_name' => "varchar(64)",
53 'email_greeting_display' => "varchar(255)",
54 'postal_greeting_display' => "varchar(255)",
55 'addressee_display' => "varchar(255)",
56 'household_name' => "varchar(128)",
57 'organization_name' => "varchar(128)",
59 'civicrm_contact_type' => array(
60 'label' => "varchar(64)",
61 'description' => "text",
63 'civicrm_mailing_component' => array(
64 'name' => "varchar(64)",
65 'subject' => "varchar(255)",
66 'body_html' => "text",
67 'body_text' => "text",
69 'civicrm_premiums' => array(
70 'premiums_intro_title' => "varchar(255)",
71 'premiums_intro_text' => "text",
73 'civicrm_product' => array(
74 'name' => "varchar(255)",
75 'description' => "text",
78 'civicrm_membership_type' => array(
79 'name' => "varchar(128)",
80 'description' => "varchar(255)",
82 'civicrm_membership_status' => array(
83 'label' => "varchar(128)",
85 'civicrm_participant_status_type' => array(
86 'label' => "varchar(255)",
88 'civicrm_tell_friend' => array(
89 'title' => "varchar(255)",
91 'suggested_message' => "text",
92 'thankyou_title' => "varchar(255)",
93 'thankyou_text' => "text",
95 'civicrm_price_set' => array(
96 'title' => "varchar(255)",
98 'help_post' => "text",
100 'civicrm_batch' => array(
101 'label' => "varchar(64)",
102 'description' => "text",
104 'civicrm_custom_group' => array(
105 'title' => "varchar(64)",
106 'help_pre' => "text",
107 'help_post' => "text",
109 'civicrm_custom_field' => array(
110 'label' => "varchar(255)",
111 'help_pre' => "text",
112 'help_post' => "text",
114 'civicrm_dashboard' => array(
115 'label' => "varchar(255)",
117 'civicrm_option_value' => array(
118 'label' => "varchar(255)",
119 'description' => "text",
121 'civicrm_mailing' => array(
122 'name' => "varchar(128)",
123 'from_name' => "varchar(128)",
124 'subject' => "varchar(128)",
125 'body_text' => "longtext",
126 'body_html' => "longtext",
128 'civicrm_contribution_page' => array(
129 'title' => "varchar(255)",
130 'intro_text' => "text",
131 'pay_later_text' => "text",
132 'pay_later_receipt' => "text",
133 'thankyou_title' => "varchar(255)",
134 'thankyou_text' => "text",
135 'thankyou_footer' => "text",
136 'for_organization' => "text",
137 'receipt_from_name' => "varchar(255)",
138 'receipt_text' => "text",
139 'footer_text' => "text",
140 'honor_block_title' => "varchar(255)",
141 'honor_block_text' => "text",
143 'civicrm_membership_block' => array(
144 'new_title' => "varchar(255)",
145 'new_text' => "text",
146 'renewal_title' => "varchar(255)",
147 'renewal_text' => "text",
149 'civicrm_price_field' => array(
150 'label' => "varchar(255)",
151 'help_pre' => "text",
152 'help_post' => "text",
154 'civicrm_price_field_value' => array(
155 'label' => "varchar(255)",
156 'description' => "text",
158 'civicrm_uf_group' => array(
159 'title' => "varchar(64)",
160 'help_pre' => "text",
161 'help_post' => "text",
163 'civicrm_uf_field' => array(
164 'help_post' => "text",
165 'help_pre' => "text",
166 'label' => "varchar(255)",
168 'civicrm_address' => array(
169 'street_address' => "varchar(96)",
170 'supplemental_address_1' => "varchar(96)",
171 'supplemental_address_2' => "varchar(96)",
172 'supplemental_address_3' => "varchar(96)",
173 'city' => "varchar(64)",
174 'name' => "varchar(255)",
176 'civicrm_event' => array(
177 'title' => "varchar(255)",
179 'description' => "text",
180 'registration_link_text' => "varchar(255)",
181 'event_full_text' => "text",
182 'fee_label' => "varchar(255)",
183 'intro_text' => "text",
184 'footer_text' => "text",
185 'confirm_title' => "varchar(255)",
186 'confirm_text' => "text",
187 'confirm_footer_text' => "text",
188 'confirm_email_text' => "text",
189 'confirm_from_name' => "varchar(255)",
190 'thankyou_title' => "varchar(255)",
191 'thankyou_text' => "text",
192 'thankyou_footer_text' => "text",
193 'pay_later_text' => "text",
194 'pay_later_receipt' => "text",
195 'waitlist_text' => "text",
196 'approval_req_text' => "text",
197 'template_title' => "varchar(255)",
207 public static function &indices() {
208 static $result = NULL;
211 'civicrm_contact' => array(
212 'index_sort_name' => array(
213 'name' => 'index_sort_name',
218 'index_first_name' => array(
219 'name' => 'index_first_name',
224 'index_last_name' => array(
225 'name' => 'index_last_name',
230 'index_household_name' => array(
231 'name' => 'index_household_name',
236 'index_organization_name' => array(
237 'name' => 'index_organization_name',
243 'civicrm_price_set' => array(
245 'name' => 'UI_title',
252 'civicrm_custom_group' => array(
253 'UI_title_extends' => array(
254 'name' => 'UI_title_extends',
262 'civicrm_custom_field' => array(
263 'UI_label_custom_group_id' => array(
264 'name' => 'UI_label_custom_group_id',
272 'civicrm_address' => array(
273 'index_city' => array(
274 'name' => 'index_city',
288 public static function &tables() {
289 static $result = NULL;
291 $result = array_keys(self
::columns());