[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['email_cache'] = array(
  48      'table' => 'email_cache',
  49      'fields' => array(
  50          'ie_id' => array(
  51              'name'        => 'ie_id',
  52              'type'        => 'id',
  53              'required'    => 'true',
  54          ),
  55          'mbox' => array(
  56              'name'        => 'mbox',
  57              'type'        => 'varchar',
  58              'len'        => 60,
  59              'required'    => true,
  60          ),
  61          'subject' => array(
  62              'name'        => 'subject',
  63              'type'        => 'varchar',
  64              'len'        => 255,
  65              'required'    => false,
  66          ),
  67          'fromaddr' => array(
  68              'name'        => 'fromaddr',
  69              'type'        => 'varchar',
  70              'len'        => 100,
  71              'required'    => false,
  72          ),
  73          'toaddr' => array(
  74              'name'        => 'toaddr',
  75              'type'        => 'varchar',
  76              'len'        => 255,
  77              'required'    => false,
  78          ),
  79          'senddate' => array(
  80              'name'        => 'senddate',
  81              'type'        => 'datetime',
  82              'required'    => false,
  83          ),
  84          'message_id' => array(
  85              'name'        => 'message_id',
  86              'type'        => 'varchar',
  87              'len'        => 255,
  88              'required'    => false,
  89          ),
  90          'mailsize' => array(
  91              'name'        => 'mailsize',
  92              'type'        => 'uint',
  93              'len'        => 16,
  94              'required'    => true,
  95          ),
  96          'imap_uid' => array(
  97              'name'        => 'imap_uid',
  98              'type'        => 'uint',
  99              'len'        => 32,
 100              'required'    => true,
 101          ),
 102          'msgno' => array(
 103              'name'        => 'msgno',
 104              'type'        => 'uint',
 105              'len'        => 32,
 106              'required'    => false,
 107          ),
 108          'recent' => array(
 109              'name'        => 'recent',
 110              'type'        => 'tinyint',
 111              'len'        => 1,
 112              'required'    => true,
 113          ),
 114          'flagged' => array(
 115              'name'        => 'flagged',
 116              'type'        => 'tinyint',
 117              'len'        => 1,
 118              'required'    => true,
 119          ),
 120          'answered' => array(
 121              'name'        => 'answered',
 122              'type'        => 'tinyint',
 123              'len'        => 1,
 124              'required'    => true,
 125          ),
 126          'deleted' => array(
 127              'name'        => 'deleted',
 128              'type'        => 'tinyint',
 129              'len'        => 1,
 130              'required'    => true,
 131          ),
 132          'seen' => array(
 133              'name'        => 'seen',
 134              'type'        => 'tinyint',
 135              'len'        => 1,
 136              'required'    => true,
 137          ),
 138          'draft' => array(
 139              'name'        => 'draft',
 140              'type'        => 'tinyint',
 141              'len'        => 1,
 142              'required'    => true,
 143          ),
 144      ),
 145      'indices' => array(
 146          array(
 147              'name'            => 'idx_ie_id',
 148              'type'            => 'index',
 149              'fields'        => array(
 150                  'ie_id',
 151              ),
 152          ),
 153          array(
 154              'name'            => 'idx_mail_date',
 155              'type'            => 'index',
 156              'fields'        => array(
 157                  'ie_id',
 158                  'mbox',
 159                  'senddate',
 160              )
 161          ),
 162          array(
 163              'name'            => 'idx_mail_from',
 164              'type'            => 'index',
 165              'fields'        => array(
 166                  'ie_id',
 167                  'mbox',
 168                  'fromaddr',
 169              )
 170          ),
 171          array(
 172              'name'            => 'idx_mail_subj',
 173              'type'            => 'index',
 174              'fields'        => array(
 175                  'subject',
 176              )
 177          ),
 178  
 179      ),
 180  );