static function getMap()
{
$connection = Application::getConnection();
$helper = $connection->getSqlHelper();
return array(
'LID' => array(
'data_type' => 'string',
'primary' => true
),
'ID' => array(
'data_type' => 'string',
'expression' => array('%s', 'LID'),
),
'SORT' => array(
'data_type' => 'integer',
),
'DEF' => array(
'data_type' => 'boolean',
'values' => array('N', 'Y'),
),
'ACTIVE' => array(
'data_type' => 'boolean',
'values' => array('N', 'Y'),
),
'NAME' => array(
'data_type' => 'string'
),
'DIR' => array(
'data_type' => 'string'
),
'LANGUAGE_ID' => array(
'data_type' => 'string',
),
'DOC_ROOT' => array(
'data_type' => 'string',
),
'DOMAIN_LIMITED' => array(
'data_type' => 'boolean',
'values' => array('N', 'Y'),
),
'SERVER_NAME' => array(
'data_type' => 'string'
),
'SITE_NAME' => array(
'data_type' => 'string'
),
'EMAIL' => array(
'data_type' => 'string'
),
'CULTURE_ID' => array(
'data_type' => 'integer',
),
'CULTURE' => array(
'data_type' => 'BitrixMainLocalizationCulture',
'reference' => array('=this.CULTURE_ID' => 'ref.ID'),
'join_type' => 'INNER',
),
'LANGUAGE' => array(
'data_type' => 'BitrixMainLocalizationLanguage',
'reference' => array('=this.LANGUAGE_ID' => 'ref.ID'),
'join_type' => 'INNER',
),
(new FieldsExpressionField('DIR_LENGTH', $helper->getLengthFunction('%s'), 'DIR')),
(new FieldsExpressionField('DOC_ROOT_LENGTH', $helper->getIsNullFunction($helper->getLengthFunction('%s'), '0'), 'DOC_ROOT')),
);
}