2 if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
3 /*********************************************************************************
4 * SugarCRM Community Edition is a customer relationship management program developed by
5 * SugarCRM, Inc. Copyright (C) 2004-2012 SugarCRM Inc.
7 * This program is free software; you can redistribute it and/or modify it under
8 * the terms of the GNU Affero 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.
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 Affero General Public License for more
19 * You should have received a copy of the GNU Affero 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
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.
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 Affero General Public License version 3.
31 * In accordance with Section 7(b) of the GNU Affero 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 ********************************************************************************/
40 * Core email_address table
42 $dictionary['email_addresses'] = array(
43 'table' => 'email_addresses',
48 'vname' => 'LBL_EMAIL_ADDRESS_ID',
51 'email_address' =>array(
52 'name' => 'email_address',
54 'vname' => 'LBL_EMAIL_ADDRESS',
58 'email_address_caps' => array(
59 'name' => 'email_address_caps',
61 'vname' => 'LBL_EMAIL_ADDRESS_CAPS',
64 'reportable' => false,
66 'invalid_email' => array(
67 'name' => 'invalid_email',
70 'vname' => 'LBL_INVALID_EMAIL',
76 'vname' => 'LBL_OPT_OUT',
78 'date_created' => array(
79 'name' => 'date_created',
81 'vname' => 'LBL_DATE_CREATE',
83 'date_modified' => array(
84 'name' => 'date_modified',
86 'vname' => 'LBL_DATE_MODIFIED',
92 'vname' => 'LBL_DELETED',
97 'name' => 'email_addressespk',
99 'fields' => array('id')
102 'name' => 'idx_ea_caps_opt_out_invalid',
104 'fields' => array('email_address_caps','opt_out','invalid_email')
107 'name' => 'idx_ea_opt_out_invalid',
109 'fields' => array('email_address', 'opt_out', 'invalid_email')
114 // hack for installer
115 if (file_exists("cache/modules/EmailAddresses/EmailAddressvardefs.php"))
117 include("cache/modules/EmailAddresses/EmailAddressvardefs.php");
119 $dictionary['EmailAddress'] = $dictionary['email_addresses'];
123 * Relationship table linking email addresses to an instance of a Sugar Email object
125 $dictionary['emails_email_addr_rel'] = array(
126 'table' => 'emails_email_addr_rel',
127 'comment' => 'Normalization of multi-address fields such as To:, CC:, BCC',
136 'name' => 'email_id',
139 'comment' => 'Foriegn key to emails table NOT unique',
141 'address_type' => array(
142 'name' => 'address_type',
146 'comment' => 'Type of entry, TO, CC, or BCC',
148 'email_address_id' => array(
149 'name' => 'email_address_id',
152 'comment' => 'Foriegn key to emails table NOT unique',
162 'name' => 'emails_email_addr_relpk',
164 'fields' => array('id'),
167 'name' => 'idx_eearl_email_id',
169 'fields' => array('email_id', 'address_type'),
172 'name' => 'idx_eearl_address_id',
174 'fields' => array('email_address_id'),
180 * Relationship table linking email addresses to various SugarBeans or type Person
182 $dictionary['email_addr_bean_rel'] = array(
183 'table' => 'email_addr_bean_rel',
191 'name' => 'email_address_id',
201 'name' => 'bean_module',
207 'name' => 'primary_address',
212 'name' => 'reply_to_address',
217 'name' => 'date_created',
221 'name' => 'date_modified',
232 'name' => 'email_addresses_relpk',
234 'fields' => array('id')
237 'name' => 'idx_email_address_id',
239 'fields' => array('email_address_id')
242 'name' => 'idx_bean_id',
244 'fields' => array('bean_id', 'bean_module'),
247 'relationships' => array (
248 //Defined in Person/Company template vardefs