[Vue sommaire] [Imprimer] [Vue textuelle]

   1  <?php
   2  if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
   3  /*********************************************************************************
   4   * SugarCRM is a customer relationship management program developed by
   5   * SugarCRM, Inc. Copyright (C) 2004 - 2009 SugarCRM Inc.
   6   * 
   7   * This program is free software; you can redistribute it and/or modify it under
   8   * the terms of the GNU General Public License version 3 as published by the
   9   * Free Software Foundation with the addition of the following permission added
  10   * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
  11   * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
  12   * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
  13   * 
  14   * This program is distributed in the hope that it will be useful, but WITHOUT
  15   * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
  16   * FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more
  17   * details.
  18   * 
  19   * You should have received a copy of the GNU General Public License along with
  20   * this program; if not, see http://www.gnu.org/licenses or write to the Free
  21   * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
  22   * 02110-1301 USA.
  23   * 
  24   * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
  25   * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
  26   * 
  27   * The interactive user interfaces in modified source and object code versions
  28   * of this program must display Appropriate Legal Notices, as required under
  29   * Section 5 of the GNU General Public License version 3.
  30   * 
  31   * In accordance with Section 7(b) of the GNU General Public License version 3,
  32   * these Appropriate Legal Notices must retain the display of the "Powered by
  33   * SugarCRM" logo. If the display of the logo is not reasonably feasible for
  34   * technical reasons, the Appropriate Legal Notices must display the words
  35   * "Powered by SugarCRM".
  36   ********************************************************************************/
  37  
  38  /**
  39   * Core email_address table
  40   */
  41  $dictionary['email_addresses'] = array(
  42      'table'        => 'email_addresses',
  43      'fields'    => array(
  44          'id' => array(
  45              'name'            => 'id',
  46              'type'            => 'id',
  47              'vname'         => 'LBL_EMAIL_ADDRESS_ID',
  48              'required'        => true,
  49          ),
  50          'email_address' =>array(
  51              'name'            => 'email_address',
  52              'type'            => 'varchar',
  53              'vname'         => 'LBL_EMAIL_ADDRESS',
  54              'length'        => 100,
  55              'required'        => true,
  56          ),
  57          'email_address_caps' => array(
  58              'name'            => 'email_address_caps',
  59              'type'            => 'varchar',
  60              'vname'         => 'LBL_EMAIL_ADDRESS_CAPS',
  61              'length'        => 100,
  62              'required'        => true,
  63          ),
  64          'invalid_email' => array(
  65              'name'            => 'invalid_email',
  66              'type'            => 'bool',
  67              'default'        => 0,
  68              'vname'         => 'LBL_INVALID_EMAIL',
  69          ),
  70          'opt_out' => array(
  71              'name'            => 'opt_out',
  72              'type'            => 'bool',
  73              'default'        => 0,
  74              'vname'         => 'LBL_OPT_OUT',
  75          ),
  76          'date_created' => array(
  77              'name'            => 'date_created',
  78              'type'            => 'datetime',
  79              'vname'         => 'LBL_DATE_CREATE',
  80          ),
  81          'date_modified' => array(
  82              'name'            => 'date_modified',
  83              'type'            => 'datetime',
  84              'vname'         => 'LBL_DATE_MODIFIED',
  85          ),
  86          'deleted' => array(
  87              'name'            => 'deleted',
  88              'type'            => 'bool',
  89              'default'        => 0,
  90              'vname'         => 'LBL_DELETED',
  91          ),
  92      ),
  93      'indices' => array(
  94          array(
  95              'name'            => 'email_addressespk',
  96              'type'            => 'primary',
  97              'fields'        => array('id')
  98          ),
  99          array(
 100              'name'            => 'idx_ea_caps_opt_out_invalid',
 101              'type'            => 'index',
 102              'fields'        => array('email_address_caps','opt_out','invalid_email')
 103          ),
 104          array(
 105              'name'            => 'idx_ea_opt_out_invalid',
 106              'type'            => 'index',
 107              'fields'        => array('email_address', 'opt_out', 'invalid_email')
 108          ),
 109      ),
 110  );
 111  
 112  // hack for installer
 113  $dictionary['EmailAddress'] = $dictionary['email_addresses'];
 114  
 115  /**
 116   * Relationship table linking email addresses to an instance of a Sugar Email object
 117   */
 118  $dictionary['emails_email_addr_rel'] = array(
 119      'table' => 'emails_email_addr_rel',
 120      'comment' => 'Normalization of multi-address fields such as To:, CC:, BCC',
 121      'fields' => array(
 122          'id' => array(
 123              'name'            => 'id',
 124              'type'            => 'id',
 125              'required'        => true,
 126              'comment'        => 'GUID',
 127          ),
 128          'email_id' => array(
 129              'name'            => 'email_id',
 130              'type'            => 'id',
 131              'required'        => true,
 132              'comment'        => 'Foriegn key to emails table NOT unique',
 133          ),
 134          'address_type' => array(
 135              'name'            => 'address_type',
 136              'type'            => 'varchar',
 137              'len'            => 4,
 138              'required'        => true,
 139              'comment'        => 'Type of entry, TO, CC, or BCC',
 140          ),
 141          'email_address_id' => array(
 142              'name'            => 'email_address_id',
 143              'type'            => 'id',
 144              'required'        => true,
 145              'comment'        => 'Foriegn key to emails table NOT unique',
 146          ),
 147          'deleted' => array(
 148              'name'            => 'deleted',
 149              'type'            => 'bool',
 150              'default'        => 0,
 151          ),
 152      ),
 153      'indices' => array(
 154          array(
 155              'name'        => 'emails_email_addr_relpk',
 156              'type'        => 'primary',
 157              'fields'    => array('id'),
 158          ),
 159          array(
 160              'name'        => 'idx_eearl_email_id',
 161              'type'        => 'index',
 162              'fields'    => array('email_id', 'address_type'),
 163          ),
 164          array(
 165              'name'        => 'idx_eearl_address_id',
 166              'type'        => 'index',
 167              'fields'    => array('email_address_id'),
 168          ),
 169      ),
 170  );
 171  
 172  /**
 173   * Relationship table linking email addresses to various SugarBeans or type Person
 174   */
 175  $dictionary['email_addr_bean_rel'] = array(
 176      'table' => 'email_addr_bean_rel',
 177      'fields' => array(
 178          array(
 179              'name'            => 'id',
 180              'type'            => 'id',
 181              'required'        => true,
 182          ),
 183          array(
 184              'name'            => 'email_address_id',
 185              'type'            => 'id',
 186              'required'        => true,
 187          ),
 188          array(
 189              'name'            => 'bean_id',
 190              'type'            => 'id',
 191              'required'        => true,
 192          ),
 193          array(
 194              'name'            => 'bean_module',
 195              'type'            => 'varchar',
 196              'len'            => 25,
 197              'required'        => true,
 198          ),
 199          array(
 200              'name'            => 'primary_address',
 201              'type'            => 'bool',
 202              'default'        => '0',
 203          ),
 204          array(
 205              'name'            => 'reply_to_address',
 206              'type'            => 'bool',
 207              'default'        => '0',
 208          ),
 209          array(
 210              'name'            => 'date_created',
 211              'type'            => 'datetime'
 212          ),
 213          array(
 214              'name'            => 'date_modified',
 215              'type'            => 'datetime'
 216          ),
 217          array(
 218              'name'            => 'deleted',
 219              'type'            => 'bool',
 220              'default'        => 0,
 221          ),
 222      ),
 223      'indices' => array(
 224          array(
 225              'name'            => 'email_addresses_relpk',
 226              'type'            => 'primary',
 227              'fields'        => array('id')
 228          ),
 229          array(
 230              'name'            => 'idx_email_address_id',
 231              'type'            => 'index',
 232              'fields'        => array('email_address_id')
 233          ),
 234          array(
 235              'name'            => 'idx_bean_id',
 236              'type'            => 'index',
 237              'fields'        => array('bean_id', 'bean_module'),
 238          ),
 239      ),
 240      'relationships' => array (
 241          //Defined in Person/Company template vardefs
 242      ),
 243  );