CRM/Core/I18n/SchemaStructure_3_4_beta2.php

   1 <?php
   2 /*
   3 +--------------------------------------------------------------------+
   4 | CiviCRM version 4.7                                                |
   5 +--------------------------------------------------------------------+
   6 | Copyright CiviCRM LLC (c) 2004-2018                                |
   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-2018
  32  * $Id$
  33  *
  34  */
  35 class CRM_Core_I18n_SchemaStructure_3_4_beta2 {
  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_premiums' => array(
  70           'premiums_intro_title' => "varchar(255)",
  71           'premiums_intro_text' => "text",
  72         ),
  73         'civicrm_product' => array(
  74           'name' => "varchar(255)",
  75           'description' => "text",
  76           'options' => "text",
  77         ),
  78         'civicrm_membership_type' => array(
  79           'name' => "varchar(128)",
  80           'description' => "varchar(255)",
  81         ),
  82         'civicrm_membership_status' => array(
  83           'label' => "varchar(128)",
  84         ),
  85         'civicrm_participant_status_type' => array(
  86           'label' => "varchar(255)",
  87         ),
  88         'civicrm_tell_friend' => array(
  89           'title' => "varchar(255)",
  90           'intro' => "text",
  91           'suggested_message' => "text",
  92           'thankyou_title' => "varchar(255)",
  93           'thankyou_text' => "text",
  94         ),
  95         'civicrm_price_set' => array(
  96           'title' => "varchar(255)",
  97           'help_pre' => "text",
  98           'help_post' => "text",
  99         ),
 100         'civicrm_batch' => array(
 101           'label' => "varchar(64)",
 102           'description' => "text",
 103         ),
 104         'civicrm_custom_group' => array(
 105           'title' => "varchar(64)",
 106           'help_pre' => "text",
 107           'help_post' => "text",
 108         ),
 109         'civicrm_custom_field' => array(
 110           'label' => "varchar(255)",
 111           'help_pre' => "text",
 112           'help_post' => "text",
 113         ),
 114         'civicrm_dashboard' => array(
 115           'label' => "varchar(255)",
 116         ),
 117         'civicrm_option_value' => array(
 118           'label' => "varchar(255)",
 119           'description' => "text",
 120         ),
 121         'civicrm_mailing' => array(
 122           'name' => "varchar(128)",
 123           'from_name' => "varchar(128)",
 124           'subject' => "varchar(128)",
 125           'body_text' => "longtext",
 126           'body_html' => "longtext",
 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_price_field_value' => array(
 155           'label' => "varchar(255)",
 156           'description' => "text",
 157         ),
 158         'civicrm_uf_group' => array(
 159           'title' => "varchar(64)",
 160           'help_pre' => "text",
 161           'help_post' => "text",
 162         ),
 163         'civicrm_uf_field' => array(
 164           'help_post' => "text",
 165           'help_pre' => "text",
 166           'label' => "varchar(255)",
 167         ),
 168         'civicrm_address' => array(
 169           'street_address' => "varchar(96)",
 170           'supplemental_address_1' => "varchar(96)",
 171           'supplemental_address_2' => "varchar(96)",
 172           'supplemental_address_3' => "varchar(96)",
 173           'city' => "varchar(64)",
 174           'name' => "varchar(255)",
 175         ),
 176         'civicrm_event' => array(
 177           'title' => "varchar(255)",
 178           'summary' => "text",
 179           'description' => "text",
 180           'registration_link_text' => "varchar(255)",
 181           'event_full_text' => "text",
 182           'fee_label' => "varchar(255)",
 183           'intro_text' => "text",
 184           'footer_text' => "text",
 185           'confirm_title' => "varchar(255)",
 186           'confirm_text' => "text",
 187           'confirm_footer_text' => "text",
 188           'confirm_email_text' => "text",
 189           'confirm_from_name' => "varchar(255)",
 190           'thankyou_title' => "varchar(255)",
 191           'thankyou_text' => "text",
 192           'thankyou_footer_text' => "text",
 193           'pay_later_text' => "text",
 194           'pay_later_receipt' => "text",
 195           'waitlist_text' => "text",
 196           'approval_req_text' => "text",
 197           'template_title' => "varchar(255)",
 198         ),
 199       );
 200     }
 201     return $result;
 202   }
 203
 204   /**
 205    * @return array
 206    */
 207   public static 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   public static function &tables() {
 289     static $result = NULL;
 290     if (!$result) {
 291       $result = array_keys(self::columns());
 292     }
 293     return $result;
 294   }
 295
 296 }