CRM/Core/I18n/SchemaStructure_3_2_beta4.php

   1 <?php
   2 /*
   3 +--------------------------------------------------------------------+
   4 | CiviCRM version 4.7                                                |
   5 +--------------------------------------------------------------------+
   6 | Copyright CiviCRM LLC (c) 2004-2017                                |
   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-2017
  32  * $Id$
  33  *
  34  */
  35 class CRM_Core_I18n_SchemaStructure_3_2_beta4 {
  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_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_custom_group' => array(
 108           'title' => 'varchar(64)',
 109           'help_pre' => 'text',
 110           'help_post' => 'text',
 111         ),
 112         'civicrm_custom_field' => array(
 113           'label' => 'varchar(255)',
 114           'help_pre' => 'text',
 115           'help_post' => 'text',
 116         ),
 117         'civicrm_dashboard' => array(
 118           'label' => 'varchar(255)',
 119         ),
 120         'civicrm_option_value' => array(
 121           'label' => 'varchar(255)',
 122           'description' => 'varchar(255)',
 123         ),
 124         'civicrm_contribution_page' => array(
 125           'title' => 'varchar(255)',
 126           'intro_text' => 'text',
 127           'pay_later_text' => 'text',
 128           'pay_later_receipt' => 'text',
 129           'thankyou_title' => 'varchar(255)',
 130           'thankyou_text' => 'text',
 131           'thankyou_footer' => 'text',
 132           'for_organization' => 'text',
 133           'receipt_from_name' => 'varchar(255)',
 134           'receipt_text' => 'text',
 135           'footer_text' => 'text',
 136           'honor_block_title' => 'varchar(255)',
 137           'honor_block_text' => 'text',
 138         ),
 139         'civicrm_membership_block' => array(
 140           'new_title' => 'varchar(255)',
 141           'new_text' => 'text',
 142           'renewal_title' => 'varchar(255)',
 143           'renewal_text' => 'text',
 144         ),
 145         'civicrm_price_field' => array(
 146           'label' => 'varchar(255)',
 147           'help_pre' => 'text',
 148           'help_post' => 'text',
 149         ),
 150         'civicrm_uf_group' => array(
 151           'title' => 'varchar(64)',
 152           'help_pre' => 'text',
 153           'help_post' => 'text',
 154         ),
 155         'civicrm_uf_field' => array(
 156           'help_post' => 'text',
 157           'help_pre' => 'text',
 158           'label' => 'varchar(255)',
 159         ),
 160         'civicrm_address' => array(
 161           'street_address' => 'varchar(96)',
 162           'supplemental_address_1' => 'varchar(96)',
 163           'supplemental_address_2' => 'varchar(96)',
 164           'supplemental_address_3' => 'varchar(96)',
 165           'city' => 'varchar(64)',
 166           'name' => 'varchar(255)',
 167         ),
 168         'civicrm_event' => array(
 169           'title' => 'varchar(255)',
 170           'summary' => 'text',
 171           'description' => 'text',
 172           'registration_link_text' => 'varchar(255)',
 173           'event_full_text' => 'text',
 174           'fee_label' => 'varchar(255)',
 175           'intro_text' => 'text',
 176           'footer_text' => 'text',
 177           'confirm_title' => 'varchar(255)',
 178           'confirm_text' => 'text',
 179           'confirm_footer_text' => 'text',
 180           'confirm_email_text' => 'text',
 181           'confirm_from_name' => 'varchar(255)',
 182           'thankyou_title' => 'varchar(255)',
 183           'thankyou_text' => 'text',
 184           'thankyou_footer_text' => 'text',
 185           'pay_later_text' => 'text',
 186           'pay_later_receipt' => 'text',
 187           'waitlist_text' => 'text',
 188           'approval_req_text' => 'text',
 189           'template_title' => 'varchar(255)',
 190         ),
 191       );
 192     }
 193     return $result;
 194   }
 195
 196   /**
 197    * @return array
 198    */
 199   public static function &indices() {
 200     static $result = NULL;
 201     if (!$result) {
 202       $result = array(
 203         'civicrm_contact' => array(
 204           'index_sort_name' => array(
 205             'name' => 'index_sort_name',
 206             'field' => array(
 207               'sort_name',
 208             ),
 209           ),
 210           'index_first_name' => array(
 211             'name' => 'index_first_name',
 212             'field' => array(
 213               'first_name',
 214             ),
 215           ),
 216           'index_last_name' => array(
 217             'name' => 'index_last_name',
 218             'field' => array(
 219               'last_name',
 220             ),
 221           ),
 222           'index_household_name' => array(
 223             'name' => 'index_household_name',
 224             'field' => array(
 225               'household_name',
 226             ),
 227           ),
 228           'index_organization_name' => array(
 229             'name' => 'index_organization_name',
 230             'field' => array(
 231               'organization_name',
 232             ),
 233           ),
 234         ),
 235         'civicrm_price_set' => array(
 236           'UI_title' => array(
 237             'name' => 'UI_title',
 238             'field' => array(
 239               'title',
 240             ),
 241             'unique' => 1,
 242           ),
 243         ),
 244         'civicrm_custom_group' => array(
 245           'UI_title_extends' => array(
 246             'name' => 'UI_title_extends',
 247             'field' => array(
 248               'title',
 249               'extends',
 250             ),
 251             'unique' => 1,
 252           ),
 253         ),
 254         'civicrm_custom_field' => array(
 255           'UI_label_custom_group_id' => array(
 256             'name' => 'UI_label_custom_group_id',
 257             'field' => array(
 258               'label',
 259               'custom_group_id',
 260             ),
 261             'unique' => 1,
 262           ),
 263         ),
 264         'civicrm_address' => array(
 265           'index_city' => array(
 266             'name' => 'index_city',
 267             'field' => array(
 268               'city',
 269             ),
 270           ),
 271         ),
 272       );
 273     }
 274     return $result;
 275   }
 276
 277   /**
 278    * @return array
 279    */
 280   public static function &tables() {
 281     static $result = NULL;
 282     if (!$result) {
 283       $result = array_keys(self::columns());
 284     }
 285     return $result;
 286   }
 287
 288 }