[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  $dictionary['folders'] = array(
  45      'table' => 'folders',
  46      'fields' => array(
  47          array(
  48              'name'            => 'id',
  49              'type'            => 'id',
  50              'required'        => true,
  51          ),
  52          array(
  53              'name'            => 'name',
  54              'type'            => 'varchar',
  55              'len'            => 25,
  56              'required'        => true,
  57          ),
  58          array(
  59              'name'            => 'folder_type',
  60              'type'            => 'varchar',
  61              'len'            => 25,
  62              'default'        => NULL,
  63          ),
  64          array(
  65              'name'            => 'parent_folder',
  66              'type'            => 'id',
  67              'required'        => false,
  68          ),
  69          array(
  70              'name'            => 'has_child',
  71              'type'            => 'bool',
  72              'default'        => '0',
  73          ),
  74          array(
  75              'name'            => 'is_group',
  76              'type'            => 'bool',
  77              'default'        => '0',
  78          ),
  79          array(
  80              'name'            => 'is_dynamic',
  81              'type'            => 'bool',
  82              'default'        => '0',
  83          ),
  84          array(
  85              'name'            => 'dynamic_query',
  86              'type'            => 'text',
  87          ),
  88          array(
  89              'name'            => 'assign_to_id',
  90              'type'            => 'id',
  91              'required'        => false,
  92          ),
  93  
  94  
  95  
  96  
  97  
  98  
  99  
 100  
 101  
 102  
 103  
 104  
 105  
 106          array(
 107              'name'            => 'created_by',
 108              'type'            => 'id',
 109              'required'        => true,
 110          ),
 111          array(
 112              'name'            => 'modified_by',
 113              'type'            => 'id',
 114              'required'        => true,
 115          ),
 116          array(
 117              'name'            => 'deleted',
 118              'type'            => 'bool',
 119              'default'        => '0',
 120          ),
 121      ),
 122      'indices' => array(
 123          array(
 124              'name'            => 'folderspk',
 125              'type'            => 'primary',
 126              'fields'        => array('id')
 127          ),
 128          array(
 129              'name'            => 'idx_parent_folder',
 130              'type'            => 'index',
 131              'fields'        => array('parent_folder')
 132          ),
 133      ),
 134  );
 135  
 136  $dictionary['folders_subscriptions'] = array(
 137      'table' => 'folders_subscriptions',
 138      'fields' => array(
 139          array(
 140              'name'            => 'id',
 141              'type'            => 'id',
 142              'required'        => true,
 143          ),
 144          array(
 145              'name'            => 'folder_id',
 146              'type'            => 'id',
 147              'required'        => true,
 148          ),
 149          array(
 150              'name'            => 'assigned_user_id',
 151              'type'            => 'id',
 152              'required'        => true,
 153          ),
 154      ),
 155      'indices' => array(
 156          array(
 157              'name'            => 'folders_subscriptionspk',
 158              'type'            => 'primary',
 159              'fields'        => array('id')
 160          ),
 161          array(
 162              'name'            => 'idx_folder_id_assigned_user_id',
 163              'type'            => 'index',
 164              'fields'        => array('folder_id', 'assigned_user_id')
 165          ),
 166      ),
 167  );
 168  
 169  $dictionary['folders_rel'] = array(
 170      'table' => 'folders_rel',
 171      'fields' => array(
 172          array(
 173              'name'            => 'id',
 174              'type'            => 'id',
 175              'required'        => true,
 176          ),
 177          array(
 178              'name'            => 'folder_id',
 179              'type'            => 'id',
 180              'required'        => true,
 181          ),
 182          array(
 183              'name'            => 'polymorphic_module',
 184              'type'            => 'varchar',
 185              'len'            => 25,
 186              'required'        => true,
 187          ),        
 188          array(
 189              'name'            => 'polymorphic_id',
 190              'type'            => 'id',
 191              'required'        => true,
 192          ),
 193          array(
 194              'name'            => 'deleted',
 195              'type'            => 'bool',
 196              'default'        => '0',
 197          ),
 198      ),
 199      'indices' => array(
 200          array(
 201              'name'            => 'folders_relpk',
 202              'type'            => 'primary',
 203              'fields'        => array('id'),
 204          ),
 205          array(
 206              'name'            => 'idx_poly_module_poly_id',
 207              'type'            => 'index',
 208              'fields'        => array('polymorphic_module', 'polymorphic_id'),
 209          ),
 210          array(
 211              'name'            => 'idx_folders_rel_folder_id',
 212              'type'            => 'index',
 213              'fields'        => array('folder_id'),
 214          ),
 215      ),
 216  );