crm.fsf.org/20131203/files/sites/all/modules-old/civicrm/CRM/Core/I18n/SchemaStructure_3_0_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_0_beta1 {
  36   /**
  37    * @return array
  38    */
  39   public static 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_price_set' => array(
  48           'title' => 'varchar(255)',
  49           'help_pre' => 'text',
  50           'help_post' => 'text',
  51         ),
  52         'civicrm_contact' => array(
  53           'sort_name' => 'varchar(128)',
  54           'display_name' => 'varchar(128)',
  55           'first_name' => 'varchar(64)',
  56           'middle_name' => 'varchar(64)',
  57           'last_name' => 'varchar(64)',
  58           'email_greeting_display' => 'varchar(255)',
  59           'postal_greeting_display' => 'varchar(255)',
  60           'addressee_display' => 'varchar(255)',
  61           'household_name' => 'varchar(128)',
  62           'organization_name' => 'varchar(128)',
  63         ),
  64         'civicrm_premiums' => array(
  65           'premiums_intro_title' => 'varchar(255)',
  66           'premiums_intro_text' => 'text',
  67         ),
  68         'civicrm_product' => array(
  69           'name' => 'varchar(255)',
  70           'description' => 'text',
  71           'options' => 'text',
  72         ),
  73         'civicrm_membership_type' => array(
  74           'name' => 'varchar(128)',
  75           'description' => 'varchar(255)',
  76         ),
  77         'civicrm_membership_status' => array(
  78           'name' => 'varchar(128)',
  79         ),
  80         'civicrm_participant_status_type' => array(
  81           'label' => 'varchar(255)',
  82         ),
  83         'civicrm_tell_friend' => array(
  84           'title' => 'varchar(255)',
  85           'intro' => 'text',
  86           'suggested_message' => 'text',
  87           'thankyou_title' => 'varchar(255)',
  88           'thankyou_text' => 'text',
  89         ),
  90         'civicrm_custom_group' => array(
  91           'title' => 'varchar(64)',
  92           'help_pre' => 'text',
  93           'help_post' => 'text',
  94         ),
  95         'civicrm_custom_field' => array(
  96           'label' => 'varchar(255)',
  97           'help_pre' => 'text',
  98           'help_post' => 'text',
  99         ),
 100         'civicrm_option_value' => array(
 101           'label' => 'varchar(255)',
 102           'description' => 'varchar(255)',
 103         ),
 104         'civicrm_price_field' => array(
 105           'label' => 'varchar(255)',
 106           'help_pre' => 'text',
 107           'help_post' => 'text',
 108         ),
 109         'civicrm_contribution_page' => array(
 110           'title' => 'varchar(255)',
 111           'intro_text' => 'text',
 112           'pay_later_text' => 'text',
 113           'pay_later_receipt' => 'text',
 114           'thankyou_title' => 'varchar(255)',
 115           'thankyou_text' => 'text',
 116           'thankyou_footer' => 'text',
 117           'for_organization' => 'text',
 118           'receipt_from_name' => 'varchar(255)',
 119           'receipt_text' => 'text',
 120           'footer_text' => 'text',
 121           'honor_block_title' => 'varchar(255)',
 122           'honor_block_text' => 'text',
 123         ),
 124         'civicrm_membership_block' => array(
 125           'new_title' => 'varchar(255)',
 126           'new_text' => 'text',
 127           'renewal_title' => 'varchar(255)',
 128           'renewal_text' => 'text',
 129         ),
 130         'civicrm_uf_group' => array(
 131           'title' => 'varchar(64)',
 132           'help_pre' => 'text',
 133           'help_post' => 'text',
 134         ),
 135         'civicrm_uf_field' => array(
 136           'help_post' => 'text',
 137           'label' => 'varchar(255)',
 138         ),
 139         'civicrm_address' => array(
 140           'street_address' => 'varchar(96)',
 141           'supplemental_address_1' => 'varchar(96)',
 142           'supplemental_address_2' => 'varchar(96)',
 143           'supplemental_address_3' => 'varchar(96)',
 144           'city' => 'varchar(64)',
 145           'name' => 'varchar(255)',
 146         ),
 147         'civicrm_event' => array(
 148           'title' => 'varchar(255)',
 149           'summary' => 'text',
 150           'description' => 'text',
 151           'registration_link_text' => 'varchar(255)',
 152           'event_full_text' => 'text',
 153           'fee_label' => 'varchar(255)',
 154           'intro_text' => 'text',
 155           'footer_text' => 'text',
 156           'confirm_title' => 'varchar(255)',
 157           'confirm_text' => 'text',
 158           'confirm_footer_text' => 'text',
 159           'confirm_email_text' => 'text',
 160           'confirm_from_name' => 'varchar(255)',
 161           'thankyou_title' => 'varchar(255)',
 162           'thankyou_text' => 'text',
 163           'thankyou_footer_text' => 'text',
 164           'pay_later_text' => 'text',
 165           'pay_later_receipt' => 'text',
 166           'waitlist_text' => 'text',
 167           'approval_req_text' => 'text',
 168           'template_title' => 'varchar(255)',
 169         ),
 170       );
 171     }
 172     return $result;
 173   }
 174
 175   /**
 176    * @return array
 177    */
 178   public static function &indices() {
 179     static $result = NULL;
 180     if (!$result) {
 181       $result = array(
 182         'civicrm_price_set' => array(
 183           'UI_title' => array(
 184             'name' => 'UI_title',
 185             'field' => array(
 186               'title',
 187             ),
 188             'unique' => 1,
 189           ),
 190         ),
 191         'civicrm_contact' => array(
 192           'index_sort_name' => array(
 193             'name' => 'index_sort_name',
 194             'field' => array(
 195               'sort_name',
 196             ),
 197           ),
 198           'index_first_name' => array(
 199             'name' => 'index_first_name',
 200             'field' => array(
 201               'first_name',
 202             ),
 203           ),
 204           'index_last_name' => array(
 205             'name' => 'index_last_name',
 206             'field' => array(
 207               'last_name',
 208             ),
 209           ),
 210           'index_household_name' => array(
 211             'name' => 'index_household_name',
 212             'field' => array(
 213               'household_name',
 214             ),
 215           ),
 216           'index_organization_name' => array(
 217             'name' => 'index_organization_name',
 218             'field' => array(
 219               'organization_name',
 220             ),
 221           ),
 222         ),
 223         'civicrm_custom_group' => array(
 224           'UI_title_extends' => array(
 225             'name' => 'UI_title_extends',
 226             'field' => array(
 227               'title',
 228               'extends',
 229             ),
 230             'unique' => 1,
 231           ),
 232         ),
 233         'civicrm_custom_field' => array(
 234           'UI_label_custom_group_id' => array(
 235             'name' => 'UI_label_custom_group_id',
 236             'field' => array(
 237               'label',
 238               'custom_group_id',
 239             ),
 240             'unique' => 1,
 241           ),
 242         ),
 243         'civicrm_address' => array(
 244           'index_city' => array(
 245             'name' => 'index_city',
 246             'field' => array(
 247               'city',
 248             ),
 249           ),
 250         ),
 251       );
 252     }
 253     return $result;
 254   }
 255
 256   /**
 257    * @return array
 258    */
 259   public static function &tables() {
 260     static $result = NULL;
 261     if (!$result) {
 262       $result = array_keys(self::columns());
 263     }
 264     return $result;
 265   }
 266
 267 }