<?php

$this->aESSemanticTables = array(
    'd3_extsearch_synset'  => array(
        'sName'     => 'd3_extsearch_synset',
        'sType'     => 'MyISAM',
        'sComment'  => '',
    ),
);

$this->aESSemanticFields = array(
    'D3SYN_SYNSET_OXID'    => array(
        'sTableName'  => 'd3_extsearch_synset',
        'sFieldName'  => 'OXID',
        'sType'       => 'CHAR(32)',
        'blNull'      => false,
        'sDefault'    => false,
        'sComment'    => '',
        'sExtra'      => '',
        'blMultilang' => false,
    ),
    'D3SYN_SYNSET_IS_VISIBLE'    => array(
        'sTableName'  => 'd3_extsearch_synset',
        'sFieldName'  => 'IS_VISIBLE',
        'sType'       => 'BIT(1)',
        'blNull'      => false,
        'sDefault'    => false,
        'sComment'    => '',
        'sExtra'      => '',
        'blMultilang' => false,
    ),
    'D3SYN_SYNSET_USER_COMMENT'    => array(
        'sTableName'  => 'd3_extsearch_synset',
        'sFieldName'  => 'USER_COMMENT',
        'sType'       => 'LONGTEXT',
        'blNull'      => true,
        'sDefault'    => false,
        'sComment'    => '',
        'sExtra'      => '',
        'blMultilang' => false,
    ),
);

$this->aESSemanticIndizes = array(
    'SYNSET_PRIMARY'  => array(
        'sTableName'  => 'd3_extsearch_synset',
        'sType'   => 'PRIMARY',
        'sName'     => 'PRIMARY',
        'aFields' => array(
            'OXID' => 'OXID',
        ),
        'blMultilang' => false,
    ),
    'IS_VISIBLE'  => array(
        'sTableName'  => 'd3_extsearch_synset',
        'sType'   => '',
        'aFields' => array(
            'IS_VISIBLE' => 'IS_VISIBLE',
        ),
        'blMultilang' => false,
    ),
);

$this->aESSemanticRenameFields = array(
    'SYNSET_OXID'        => array(
        'sTableName'  => 'd3_extsearch_synset',
        'mOldFieldNames' => array('oxid'), // is case sensitive
        'sFieldName'  => 'OXID',
        'blMultilang' => false,
    ),
    'SYNSET_ISVISIBLE'        => array(
        'sTableName'  => 'd3_extsearch_synset',
        'mOldFieldNames' => array('is_visible'), // is case sensitive
        'sFieldName'  => 'IS_VISIBLE',
        'blMultilang' => false,
    ),
    'SYNSET_USER_COMMENT'        => array(
        'sTableName'  => 'd3_extsearch_synset',
        'mOldFieldNames' => array('user_comment'), // is case sensitive
        'sFieldName'  => 'USER_COMMENT',
        'blMultilang' => false,
    ),
);
