'user_preferences', 'fields' => array ( 'id' => array ( 'name' => 'id', 'vname' => 'LBL_NAME', 'type' => 'id', 'required'=>true, 'reportable'=>false, ), 'category' => array ( 'name' => 'category', 'type' => 'varchar', 'len' => 50, ), 'deleted' => array ( 'name' => 'deleted', 'type' => 'bool', 'default' => '0', 'required'=>false, ), 'date_entered' => array ( 'name' => 'date_entered', 'type' => 'datetime', 'required' => true, ), 'date_modified' => array ( 'name' => 'date_modified', 'type' => 'datetime', 'required' => true, ), 'assigned_user_id' => array ( 'name' => 'assigned_user_id', 'rname' => 'user_name', 'id_name' => 'assigned_user_id', 'type' => 'assigned_user_name', 'table' => 'users', 'required' => true, 'dbType' => 'id', ), 'assigned_user_name' => array ( 'name' => 'assigned_user_name', 'vname' => 'LBL_ASSIGNED_TO_NAME', 'type' => 'varchar', 'reportable'=>false, 'massupdate' => false, 'source'=>'non-db', 'table' => 'users', ), 'contents' => array ( 'name' => 'contents', 'type' => 'longtext', 'vname' => 'LBL_DESCRIPTION', 'isnull' => true, ), ), 'indices' => array ( array('name' =>'userpreferencespk', 'type' =>'primary', 'fields'=>array('id')), array('name' =>'idx_userprefnamecat', 'type'=>'index', 'fields'=>array('assigned_user_id','category')), ) ); // cn: bug 12036 - $dictionary['x'] for SugarBean::createRelationshipMeta() from upgrades $dictionary['UserPreference'] = $GLOBALS['dictionary']['UserPreference'];