CRM/Core/I18n/SchemaStructure_3_0_beta4.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_0_beta4 {
  36   static function &columns() {
  37     static $result = NULL;
  38     if (!$result) {
  39       $result = array(
  40         'civicrm_option_group' => array(
  41           'label' => 'varchar(255)',
  42           'description' => 'varchar(255)',
  43         ),
  44         'civicrm_price_set' => array(
  45           'title' => 'varchar(255)',
  46           'help_pre' => 'text',
  47           'help_post' => 'text',
  48         ),
  49         'civicrm_contact' => array(
  50           'sort_name' => 'varchar(128)',
  51           'display_name' => 'varchar(128)',
  52           'first_name' => 'varchar(64)',
  53           'middle_name' => 'varchar(64)',
  54           'last_name' => 'varchar(64)',
  55           'email_greeting_display' => 'varchar(255)',
  56           'postal_greeting_display' => 'varchar(255)',
  57           'addressee_display' => 'varchar(255)',
  58           'household_name' => 'varchar(128)',
  59           'organization_name' => 'varchar(128)',
  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           'name' => '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_custom_group' => array(
 101           'title' => 'varchar(64)',
 102           'help_pre' => 'text',
 103           'help_post' => 'text',
 104         ),
 105         'civicrm_custom_field' => array(
 106           'label' => 'varchar(255)',
 107           'help_pre' => 'text',
 108           'help_post' => 'text',
 109         ),
 110         'civicrm_option_value' => array(
 111           'label' => 'varchar(255)',
 112           'description' => 'varchar(255)',
 113         ),
 114         'civicrm_price_field' => array(
 115           'label' => 'varchar(255)',
 116           'help_pre' => 'text',
 117           'help_post' => 'text',
 118         ),
 119         'civicrm_contribution_page' => array(
 120           'title' => 'varchar(255)',
 121           'intro_text' => 'text',
 122           'pay_later_text' => 'text',
 123           'pay_later_receipt' => 'text',
 124           'thankyou_title' => 'varchar(255)',
 125           'thankyou_text' => 'text',
 126           'thankyou_footer' => 'text',
 127           'for_organization' => 'text',
 128           'receipt_from_name' => 'varchar(255)',
 129           'receipt_text' => 'text',
 130           'footer_text' => 'text',
 131           'honor_block_title' => 'varchar(255)',
 132           'honor_block_text' => 'text',
 133         ),
 134         'civicrm_membership_block' => array(
 135           'new_title' => 'varchar(255)',
 136           'new_text' => 'text',
 137           'renewal_title' => 'varchar(255)',
 138           'renewal_text' => 'text',
 139         ),
 140         'civicrm_uf_group' => array(
 141           'title' => 'varchar(64)',
 142           'help_pre' => 'text',
 143           'help_post' => 'text',
 144         ),
 145         'civicrm_uf_field' => array(
 146           'help_post' => 'text',
 147           'label' => 'varchar(255)',
 148         ),
 149         'civicrm_address' => array(
 150           'street_address' => 'varchar(96)',
 151           'supplemental_address_1' => 'varchar(96)',
 152           'supplemental_address_2' => 'varchar(96)',
 153           'supplemental_address_3' => 'varchar(96)',
 154           'city' => 'varchar(64)',
 155           'name' => 'varchar(255)',
 156         ),
 157         'civicrm_event' => array(
 158           'title' => 'varchar(255)',
 159           'summary' => 'text',
 160           'description' => 'text',
 161           'registration_link_text' => 'varchar(255)',
 162           'event_full_text' => 'text',
 163           'fee_label' => 'varchar(255)',
 164           'intro_text' => 'text',
 165           'footer_text' => 'text',
 166           'confirm_title' => 'varchar(255)',
 167           'confirm_text' => 'text',
 168           'confirm_footer_text' => 'text',
 169           'confirm_email_text' => 'text',
 170           'confirm_from_name' => 'varchar(255)',
 171           'thankyou_title' => 'varchar(255)',
 172           'thankyou_text' => 'text',
 173           'thankyou_footer_text' => 'text',
 174           'pay_later_text' => 'text',
 175           'pay_later_receipt' => 'text',
 176           'waitlist_text' => 'text',
 177           'approval_req_text' => 'text',
 178           'template_title' => 'varchar(255)',
 179         ),
 180       );
 181     }
 182     return $result;
 183   }
 184
 185   static function &indices() {
 186     static $result = NULL;
 187     if (!$result) {
 188       $result = array(
 189         'civicrm_price_set' => array(
 190           'UI_title' => array(
 191             'name' => 'UI_title',
 192             'field' => array(
 193               'title',
 194             ),
 195             'unique' => 1,
 196           ),
 197         ),
 198         'civicrm_contact' => array(
 199           'index_sort_name' => array(
 200             'name' => 'index_sort_name',
 201             'field' => array(
 202               'sort_name',
 203             ),
 204           ),
 205           'index_first_name' => array(
 206             'name' => 'index_first_name',
 207             'field' => array(
 208               'first_name',
 209             ),
 210           ),
 211           'index_last_name' => array(
 212             'name' => 'index_last_name',
 213             'field' => array(
 214               'last_name',
 215             ),
 216           ),
 217           'index_household_name' => array(
 218             'name' => 'index_household_name',
 219             'field' => array(
 220               'household_name',
 221             ),
 222           ),
 223           'index_organization_name' => array(
 224             'name' => 'index_organization_name',
 225             'field' => array(
 226               'organization_name',
 227             ),
 228           ),
 229         ),
 230         'civicrm_custom_group' => array(
 231           'UI_title_extends' => array(
 232             'name' => 'UI_title_extends',
 233             'field' => array(
 234               'title',
 235               'extends',
 236             ),
 237             'unique' => 1,
 238           ),
 239         ),
 240         'civicrm_custom_field' => array(
 241           'UI_label_custom_group_id' => array(
 242             'name' => 'UI_label_custom_group_id',
 243             'field' => array(
 244               'label',
 245               'custom_group_id',
 246             ),
 247             'unique' => 1,
 248           ),
 249         ),
 250         'civicrm_address' => array(
 251           'index_city' => array(
 252             'name' => 'index_city',
 253             'field' => array(
 254               'city',
 255             ),
 256           ),
 257         ),
 258       );
 259     }
 260     return $result;
 261   }
 262
 263   static function &tables() {
 264     static $result = NULL;
 265     if (!$result) {
 266       $result = array_keys(self::columns());
 267     }
 268     return $result;
 269   }
 270 }
 271