crm.fsf.org/20131203/files/sites/all/modules-new/civicrm/CRM/Core/I18n/SchemaStructure_3_3_beta1.php

   1 <?php
   2 /*
   3 +--------------------------------------------------------------------+
   4 | CiviCRM version 4.6                                                |
   5 +--------------------------------------------------------------------+
   6 | Copyright CiviCRM LLC (c) 2004-2015                                |
   7 +--------------------------------------------------------------------+
   8 | This file is a part of CiviCRM.                                    |
   9 |                                                                    |
  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.   |
  13 |                                                                    |
  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.        |
  18 |                                                                    |
  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 +--------------------------------------------------------------------+
  26  */
  27
  28 /**
  29  *
  30  * @package CRM
  31  * @copyright CiviCRM LLC (c) 2004-2015
  32  * $Id$
  33  *
  34  */
  35 class CRM_Core_I18n_SchemaStructure_3_3_beta1 {
  36   /**
  37    * @return array
  38    */
  39   static public function &columns() {
  40     static $result = NULL;
  41     if (!$result) {
  42       $result = array(
  43         'civicrm_option_group' => array(
  44           'label' => 'varchar(255)',
  45           'description' => 'varchar(255)',
  46         ),
  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)',
  58         ),
  59         'civicrm_contact_type' => array(
  60           'label' => 'varchar(64)',
  61           'description' => 'text',
  62         ),
  63         'civicrm_mailing_component' => array(
  64           'name' => 'varchar(64)',
  65           'subject' => 'varchar(255)',
  66           'body_html' => 'text',
  67           'body_text' => 'text',
  68         ),
  69         'civicrm_mailing' => array(
  70           'name' => 'varchar(128)',
  71           'from_name' => 'varchar(128)',
  72           'subject' => 'varchar(128)',
  73           'body_text' => 'longtext',
  74           'body_html' => 'longtext',
  75         ),
  76         'civicrm_premiums' => array(
  77           'premiums_intro_title' => 'varchar(255)',
  78           'premiums_intro_text' => 'text',
  79         ),
  80         'civicrm_product' => array(
  81           'name' => 'varchar(255)',
  82           'description' => 'text',
  83           'options' => 'text',
  84         ),
  85         'civicrm_membership_type' => array(
  86           'name' => 'varchar(128)',
  87           'description' => 'varchar(255)',
  88         ),
  89         'civicrm_membership_status' => array(
  90           'label' => 'varchar(128)',
  91         ),
  92         'civicrm_participant_status_type' => array(
  93           'label' => 'varchar(255)',
  94         ),
  95         'civicrm_tell_friend' => array(
  96           'title' => 'varchar(255)',
  97           'intro' => 'text',
  98           'suggested_message' => 'text',
  99           'thankyou_title' => 'varchar(255)',
 100           'thankyou_text' => 'text',
 101         ),
 102         'civicrm_price_set' => array(
 103           'title' => 'varchar(255)',
 104           'help_pre' => 'text',
 105           'help_post' => 'text',
 106         ),
 107         'civicrm_batch' => array(
 108           'label' => 'varchar(64)',
 109           'description' => 'text',
 110         ),
 111         'civicrm_custom_group' => array(
 112           'title' => 'varchar(64)',
 113           'help_pre' => 'text',
 114           'help_post' => 'text',
 115         ),
 116         'civicrm_custom_field' => array(
 117           'label' => 'varchar(255)',
 118           'help_pre' => 'text',
 119           'help_post' => 'text',
 120         ),
 121         'civicrm_dashboard' => array(
 122           'label' => 'varchar(255)',
 123         ),
 124         'civicrm_option_value' => array(
 125           'label' => 'varchar(255)',
 126           'description' => 'varchar(255)',
 127         ),
 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',
 142         ),
 143         'civicrm_membership_block' => array(
 144           'new_title' => 'varchar(255)',
 145           'new_text' => 'text',
 146           'renewal_title' => 'varchar(255)',
 147           'renewal_text' => 'text',
 148         ),
 149         'civicrm_price_field' => array(
 150           'label' => 'varchar(255)',
 151           'help_pre' => 'text',
 152           'help_post' => 'text',
 153         ),
 154         'civicrm_uf_group' => array(
 155           'title' => 'varchar(64)',
 156           'help_pre' => 'text',
 157           'help_post' => 'text',
 158         ),
 159         'civicrm_uf_field' => array(
 160           'help_post' => 'text',
 161           'help_pre' => 'text',
 162           'label' => 'varchar(255)',
 163         ),
 164         'civicrm_address' => array(
 165           'street_address' => 'varchar(96)',
 166           'supplemental_address_1' => 'varchar(96)',
 167           'supplemental_address_2' => 'varchar(96)',
 168           'supplemental_address_3' => 'varchar(96)',
 169           'city' => 'varchar(64)',
 170           'name' => 'varchar(255)',
 171         ),
 172         'civicrm_event' => array(
 173           'title' => 'varchar(255)',
 174           'summary' => 'text',
 175           'description' => 'text',
 176           'registration_link_text' => 'varchar(255)',
 177           'event_full_text' => 'text',
 178           'fee_label' => 'varchar(255)',
 179           'intro_text' => 'text',
 180           'footer_text' => 'text',
 181           'confirm_title' => 'varchar(255)',
 182           'confirm_text' => 'text',
 183           'confirm_footer_text' => 'text',
 184           'confirm_email_text' => 'text',
 185           'confirm_from_name' => 'varchar(255)',
 186           'thankyou_title' => 'varchar(255)',
 187           'thankyou_text' => 'text',
 188           'thankyou_footer_text' => 'text',
 189           'pay_later_text' => 'text',
 190           'pay_later_receipt' => 'text',
 191           'waitlist_text' => 'text',
 192           'approval_req_text' => 'text',
 193           'template_title' => 'varchar(255)',
 194         ),
 195         'civicrm_price_field_value' => array(
 196           'label' => 'varchar(255)',
 197           'description' => 'text',
 198         ),
 199       );
 200     }
 201     return $result;
 202   }
 203
 204   /**
 205    * @return array
 206    */
 207   static public function &indices() {
 208     static $result = NULL;
 209     if (!$result) {
 210       $result = array(
 211         'civicrm_contact' => array(
 212           'index_sort_name' => array(
 213             'name' => 'index_sort_name',
 214             'field' => array(
 215               'sort_name',
 216             ),
 217           ),
 218           'index_first_name' => array(
 219             'name' => 'index_first_name',
 220             'field' => array(
 221               'first_name',
 222             ),
 223           ),
 224           'index_last_name' => array(
 225             'name' => 'index_last_name',
 226             'field' => array(
 227               'last_name',
 228             ),
 229           ),
 230           'index_household_name' => array(
 231             'name' => 'index_household_name',
 232             'field' => array(
 233               'household_name',
 234             ),
 235           ),
 236           'index_organization_name' => array(
 237             'name' => 'index_organization_name',
 238             'field' => array(
 239               'organization_name',
 240             ),
 241           ),
 242         ),
 243         'civicrm_price_set' => array(
 244           'UI_title' => array(
 245             'name' => 'UI_title',
 246             'field' => array(
 247               'title',
 248             ),
 249             'unique' => 1,
 250           ),
 251         ),
 252         'civicrm_custom_group' => array(
 253           'UI_title_extends' => array(
 254             'name' => 'UI_title_extends',
 255             'field' => array(
 256               'title',
 257               'extends',
 258             ),
 259             'unique' => 1,
 260           ),
 261         ),
 262         'civicrm_custom_field' => array(
 263           'UI_label_custom_group_id' => array(
 264             'name' => 'UI_label_custom_group_id',
 265             'field' => array(
 266               'label',
 267               'custom_group_id',
 268             ),
 269             'unique' => 1,
 270           ),
 271         ),
 272         'civicrm_address' => array(
 273           'index_city' => array(
 274             'name' => 'index_city',
 275             'field' => array(
 276               'city',
 277             ),
 278           ),
 279         ),
 280       );
 281     }
 282     return $result;
 283   }
 284
 285   /**
 286    * @return array
 287    */
 288   static public function &tables() {
 289     static $result = NULL;
 290     if (!$result) {
 291       $result = array_keys(self::columns());
 292     }
 293     return $result;
 294   }
 295
 296 }