CRM/Core/I18n/SchemaStructure_3_1_beta2.php

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