CRM/Core/I18n/SchemaStructure_3_3_beta1.php

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