CRM/Core/I18n/SchemaStructure_3_0_beta1.php

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