[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   * Description:
  40   * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. All Rights
  41   * Reserved. Contributor(s): ______________________________________..
  42   *********************************************************************************/
  43  
  44  /**
  45   * Relationship table linking emails with 1 or more SugarBeans
  46   */
  47  $dictionary['emails_beans'] = array('table' => 'emails_beans',
  48      'fields' => array(
  49          array(
  50              'name'        => 'id',
  51              'type'        => 'varchar',
  52              'len'        => '36'
  53          ),
  54          array(
  55              'name'        => 'email_id',
  56              'type'        => 'varchar',
  57              'len'        => '36',
  58              'comment'     => 'FK to emails table',
  59          ),
  60          array(
  61              'name'        => 'bean_id',
  62              'type'        => 'varchar',
  63              'len'        => '36',
  64              'comment'     => 'FK to various beans\'s tables',
  65          ),
  66          array(
  67              'name'        => 'bean_module',
  68              'type'        => 'varchar',
  69              'len'        => '36',
  70              'comment'     => 'bean\'s Module',
  71          ),
  72          array(  'name'      => 'campaign_data',
  73                  'type'      => 'text',
  74          ),
  75          array(
  76              'name'        => 'date_modified',
  77              'type'        =>    'datetime'
  78          ),
  79          array(
  80              'name'        => 'deleted',
  81              'type'        => 'bool',
  82              'len'        => '1',
  83              'default'    => '0',
  84              'required'    => true
  85          )
  86      ),
  87      'indices' => array(
  88          array(
  89              'name'        => 'emails_beanspk',
  90              'type'        => 'primary',
  91              'fields'    => array('id')
  92          ),
  93          array(
  94              'name'        => 'idx_emails_beans_bean_id',
  95              'type'        => 'index',
  96              'fields'    => array('bean_id')
  97          ),
  98          array(
  99              'name'        => 'idx_emails_beans_email_bean',
 100              'type'        => 'alternate_key',
 101              'fields'    => array('email_id', 'bean_id', 'deleted')
 102          ),
 103      ),
 104      'relationships' => array(
 105          'emails_accounts_rel' => array(
 106              'lhs_module'        => 'Emails',
 107              'lhs_table'            => 'emails',
 108              'lhs_key'            => 'id',
 109              'rhs_module'        => 'Accounts',
 110              'rhs_table'            => 'accounts',
 111              'rhs_key'            => 'id',
 112              'relationship_type'    => 'many-to-many',
 113              'join_table'        => 'emails_beans',
 114              'join_key_lhs'        => 'email_id',
 115              'join_key_rhs'        => 'bean_id',
 116              'relationship_role_column' => 'bean_module',
 117              'relationship_role_column_value' => 'Accounts',
 118          ),
 119          'emails_bugs_rel' => array(
 120              'lhs_module'        => 'Emails',
 121              'lhs_table'            => 'emails',
 122              'lhs_key'            => 'id',
 123              'rhs_module'        => 'Bugs',
 124              'rhs_table'            => 'bugs',
 125              'rhs_key'            => 'id',
 126              'relationship_type'    => 'many-to-many',
 127              'join_table'        => 'emails_beans',
 128              'join_key_lhs'        => 'email_id',
 129              'join_key_rhs'        => 'bean_id',
 130              'relationship_role_column' => 'bean_module',
 131              'relationship_role_column_value' => 'Bugs',
 132          ),
 133          'emails_cases_rel' => array(
 134              'lhs_module'        => 'Emails',
 135              'lhs_table'            => 'emails',
 136              'lhs_key'            => 'id',
 137              'rhs_module'        => 'Cases',
 138              'rhs_table'            => 'cases',
 139              'rhs_key'            => 'id',
 140              'relationship_type'    => 'many-to-many',
 141              'join_table'        => 'emails_beans',
 142              'join_key_lhs'        => 'email_id',
 143              'join_key_rhs'        => 'bean_id',
 144              'relationship_role_column' => 'bean_module',
 145              'relationship_role_column_value' => 'Cases',
 146          ),
 147          'emails_contacts_rel'    => array(
 148              'lhs_module'        => 'Emails',
 149              'lhs_table'            => 'emails',
 150              'lhs_key'            => 'id',
 151              'rhs_module'        => 'Contacts',
 152              'rhs_table'            => 'contacts',
 153              'rhs_key'            => 'id',
 154              'relationship_type'    => 'many-to-many',
 155              'relationship_role_column' => 'bean_module',
 156              'relationship_role_column_value' => 'Contacts',
 157              'join_table'        => 'emails_beans',
 158              'join_key_lhs'        => 'email_id',
 159              'join_key_rhs'        => 'bean_id',
 160              'relationship_role_column' => 'bean_module',
 161              'relationship_role_column_value' => 'Contacts',
 162          ),
 163          'emails_leads_rel' => array(
 164              'lhs_module'        => 'Emails',
 165              'lhs_table'            => 'emails',
 166              'lhs_key'            => 'id',
 167              'rhs_module'        => 'Leads',
 168              'rhs_table'            => 'leads',
 169              'rhs_key'            => 'id',
 170              'relationship_type'    => 'many-to-many',
 171              'join_table'        => 'emails_beans',
 172              'join_key_lhs'        => 'email_id',
 173              'join_key_rhs'        => 'bean_id',
 174              'relationship_role_column' => 'bean_module',
 175              'relationship_role_column_value' => 'Leads',
 176          ),
 177          'emails_opportunities_rel' => array(
 178              'lhs_module'        => 'Emails',
 179              'lhs_table'            => 'emails',
 180              'lhs_key'            => 'id',
 181              'rhs_module'        => 'Opportunities',
 182              'rhs_table'            => 'opportunities',
 183              'rhs_key'            => 'id',
 184              'relationship_type'    => 'many-to-many',
 185              'join_table'        => 'emails_beans',
 186              'join_key_lhs'        => 'email_id',
 187              'join_key_rhs'        => 'bean_id',
 188              'relationship_role_column' => 'bean_module',
 189              'relationship_role_column_value' => 'Opportunities',
 190          ),
 191          'emails_tasks_rel' => array(
 192              'lhs_module'        => 'Emails',
 193              'lhs_table'            => 'emails',
 194              'lhs_key'            => 'id',
 195              'rhs_module'        => 'Tasks',
 196              'rhs_table'            => 'tasks',
 197              'rhs_key'            => 'id',
 198              'relationship_type'    => 'many-to-many',
 199              'join_table'        => 'emails_beans',
 200              'join_key_lhs'        => 'email_id',
 201              'join_key_rhs'        => 'bean_id',
 202              'relationship_role_column' => 'bean_module',
 203              'relationship_role_column_value' => 'Tasks',
 204          ),
 205          'emails_users_rel' => array(
 206              'lhs_module'        => 'Emails',
 207              'lhs_table'            => 'emails',
 208              'lhs_key'            => 'id',
 209              'rhs_module'        => 'Users',
 210              'rhs_table'            => 'users',
 211              'rhs_key'            => 'id',
 212              'relationship_type'    => 'many-to-many',
 213              'join_table'        => 'emails_beans',
 214              'join_key_lhs'        => 'email_id',
 215              'join_key_rhs'        => 'bean_id',
 216              'relationship_role_column' => 'bean_module',
 217              'relationship_role_column_value' => 'Users',
 218          ),
 219          'emails_project_task_rel' => array(
 220              'lhs_module'        => 'Emails',
 221              'lhs_table'            => 'emails',
 222              'lhs_key'            => 'id',
 223              'rhs_module'        => 'ProjectTask',
 224              'rhs_table'            => 'project_task',
 225              'rhs_key'            => 'id',
 226              'relationship_type'    => 'many-to-many',
 227              'join_table'        => 'emails_beans',
 228              'join_key_lhs'        => 'email_id',
 229              'join_key_rhs'        => 'bean_id',
 230              'relationship_role_column' => 'bean_module',
 231              'relationship_role_column_value' => 'ProjectTask',
 232          ),
 233          'emails_projects_rel' => array(
 234              'lhs_module'        => 'Emails',
 235              'lhs_table'            => 'emails',
 236              'lhs_key'            => 'id',
 237              'rhs_module'        => 'Project',
 238              'rhs_table'            => 'project',
 239              'rhs_key'            => 'id',
 240              'relationship_type'    => 'many-to-many',
 241              'join_table'        => 'emails_beans',
 242              'join_key_lhs'        => 'email_id',
 243              'join_key_rhs'        => 'bean_id',
 244              'relationship_role_column' => 'bean_module',
 245              'relationship_role_column_value' => 'Project',
 246          ),
 247          'emails_prospects_rel' => array(
 248              'lhs_module'        => 'Emails',
 249              'lhs_table'            => 'emails',
 250              'lhs_key'            => 'id',
 251              'rhs_module'        => 'Prospects',
 252              'rhs_table'            => 'prospects',
 253              'rhs_key'            => 'id',
 254              'relationship_type'    => 'many-to-many',
 255              'join_table'        => 'emails_beans',
 256              'join_key_lhs'        => 'email_id',
 257              'join_key_rhs'        => 'bean_id',
 258              'relationship_role_column' => 'bean_module',
 259              'relationship_role_column_value' => 'Prospects',
 260          ),
 261          'emails_quotes' => array(
 262              'lhs_module'        => 'Emails',
 263              'lhs_table'            => 'emails',
 264              'lhs_key'            => 'id',
 265              'rhs_module'        => 'Quotes',
 266              'rhs_table'            => 'quotes',
 267              'rhs_key'            => 'id',
 268              'relationship_type'    => 'many-to-many',
 269              'join_table'        => 'emails_beans',
 270              'join_key_lhs'        => 'email_id',
 271              'join_key_rhs'        => 'bean_id',
 272              'relationship_role_column' => 'bean_module',
 273              'relationship_role_column_value' => 'Quotes',
 274          ),
 275      )
 276  );
 277  
 278  
 279  /**
 280   * Large text field table, shares a 1:1 with the emails table.  Moving all longtext fields to this table allows more
 281   * effiencient email management and full-text search capabilities with MyISAM for MySQL.
 282   */
 283  $dictionary['emails_text'] = array(
 284      'table' => 'emails_text',
 285      'comment' => 'Large email text fields',
 286      'mysqlengine' => 'MyISAM',
 287      'fields' => array(
 288          'email_id' => array (
 289              'name'            => 'email_id',
 290              'vname'            => 'LBL_ID',
 291              'type'            => 'varchar',
 292              'len'            => 36,
 293              'required'        => true,
 294              'reportable'    => true,
 295              'comment'         => 'Foriegn key to emails table',
 296          ),
 297          'from_addr' => array (
 298              'name'            => 'from_addr',
 299              'vname'            => 'LBL_FROM',
 300              'type'            => 'varchar',
 301              'len'            => 255,
 302              'comment'        => 'Email address of person who send the email',
 303          ),
 304          'reply_to_addr' => array (
 305              'name'            => 'reply_to_addr',
 306              'vname'            => 'LBL_REPLY_TO',
 307              'type'            => 'varchar',
 308              'len'            => 255,
 309              'comment'        => 'reply to email address',
 310          ),
 311          'to_addrs' => array (
 312              'name'            => 'to_addrs',
 313              'vname'            => 'LBL_TO',
 314              'type'            => 'text',
 315              'comment'        => 'Email address(es) of person(s) to receive the email',
 316          ),
 317          'cc_addrs' => array (
 318              'name'            => 'cc_addrs',
 319              'vname'            => 'LBL_CC',
 320              'type'            => 'text',
 321              'comment'        => 'Email address(es) of person(s) to receive a carbon copy of the email',
 322          ),
 323          'bcc_addrs' => array (
 324              'name'            => 'bcc_addrs',
 325              'vname'            => 'LBL_BCC',
 326              'type'            => 'text',
 327              'comment'        => 'Email address(es) of person(s) to receive a blind carbon copy of the email',
 328          ),
 329          'description' => array (
 330              'name'            => 'description',
 331              'vname'            => 'LBL_TEXT_BODY',
 332              'type'            => 'longtext',
 333              'reportable'    => false,
 334              'comment'        => 'Email body in plain text',
 335          ),
 336          'description_html' => array (
 337              'name'            => 'description_html',
 338              'vname'            => 'LBL_HTML_BODY',
 339              'type'            => 'longtext',
 340              'reportable'    => false,
 341              'comment'        => 'Email body in HTML format',
 342          ),
 343          'raw_source' => array (
 344              'name'            => 'raw_source',
 345              'vname'            => 'LBL_RAW',
 346              'type'            => 'longtext',
 347              'reportable'    => false,
 348              'comment'        => 'Full raw source of email',
 349          ),
 350          'deleted' => array(
 351              'name'            => 'deleted',
 352              'type'            => 'bool',
 353              'default'        => 0,
 354          ),
 355      ),
 356      'indices' => array(
 357          array(
 358              'name'            => 'emails_textpk',
 359              'type'            => 'primary',
 360              'fields'        => array('email_id')
 361          ),
 362          array(
 363              'name'            => 'emails_textfromaddr',
 364              'type'            => 'index',
 365              'fields'        => array('from_addr')
 366          ),
 367      ),
 368  );
 369  
 370  
 371  
 372  
 373  
 374  
 375  
 376  
 377  
 378