<?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_VERSION'    => array(
        'sTableName'  => 'd3_extsearch_synset',
        'sFieldName'  => 'VERSION',
        'sType'       => 'CHAR(32)',
        'blNull'      => false,
        'sDefault'    => false,
        'sComment'    => '',
        'sExtra'      => '',
        'blMultilang' => false,
    ),
    'D3SYN_SYNSET_EVALUATION'    => array(
        'sTableName'  => 'd3_extsearch_synset',
        'sFieldName'  => 'EVALUATION',
        'sType'       => 'INT(11)',
        'blNull'      => false,
        'sDefault'    => false,
        'sComment'    => '',
        'sExtra'      => '',
        'blMultilang' => false,
    ),
    'D3SYN_SYNSET_IMPORT_STATUS'    => array(
        'sTableName'  => 'd3_extsearch_synset',
        'sFieldName'  => 'IMPORT_STATUS',
        'sType'       => 'INT(11)',
        'blNull'      => true,
        '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_ORIGINAL_ID'    => array(
        'sTableName'  => 'd3_extsearch_synset',
        'sFieldName'  => 'ORIGINAL_ID',
        'sType'       => 'INT(11)',
        'blNull'      => true,
        'sDefault'    => false,
        'sComment'    => '',
        'sExtra'      => '',
        'blMultilang' => false,
    ),
    'D3SYN_SYNSET_ORIGINALURI'    => array(
        'sTableName'  => 'd3_extsearch_synset',
        'sFieldName'  => 'ORIGINALURI',
        'sType'       => 'VARCHAR(255)',
        'blNull'      => true,
        'sDefault'    => false,
        'sComment'    => '',
        'sExtra'      => '',
        'blMultilang' => false,
    ),
    'D3SYN_SYNSET_PREFCATID'    => array(
        'sTableName'  => 'd3_extsearch_synset',
        'sFieldName'  => 'PREFERRED_CATEGORY_ID',
        'sType'       => 'CHAR(32)',
        'blNull'      => true,
        'sDefault'    => false,
        'sComment'    => '',
        'sExtra'      => '',
        'blMultilang' => false,
    ),
    'D3SYN_SYNSET_SECTION_ID'    => array(
        'sTableName'  => 'd3_extsearch_synset',
        'sFieldName'  => 'SECTION_ID',
        'sType'       => 'CHAR(32)',
        'blNull'      => true,
        'sDefault'    => false,
        'sComment'    => '',
        'sExtra'      => '',
        'blMultilang' => false,
    ),
    'D3SYN_SYNSET_SOURCE_ID'    => array(
        'sTableName'  => 'd3_extsearch_synset',
        'sFieldName'  => 'SOURCE_ID',
        'sType'       => 'CHAR(32)',
        'blNull'      => true,
        'sDefault'    => false,
        'sComment'    => '',
        'sExtra'      => '',
        'blMultilang' => false,
    ),
    'D3SYN_SYNSET_SYNPREFTERM'    => array(
        'sTableName'  => 'd3_extsearch_synset',
        'sFieldName'  => 'SYNSET_PREFERRED_TERM',
        'sType'       => 'VARCHAR(255)',
        'blNull'      => true,
        '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,
    ),
    'FKCB1A289A4A27BB5'  => array(
        'sTableName'  => 'd3_extsearch_synset',
        'sType'   => '',
        'sName'     => 'FKCB1A289A4A27BB5',
        'aFields' => array(
            'SOURCE_ID' => 'SOURCE_ID',
        ),
        'blMultilang' => false,
    ),
    'FKCB1A289AED375357'  => array(
        'sTableName'  => 'd3_extsearch_synset',
        'sType'   => '',
        'sName'     => 'FKCB1A289AED375357',
        'aFields' => array(
            'PREFERRED_CATEGORY_ID' => 'PREFERRED_CATEGORY_ID',
        ),
        'blMultilang' => false,
    ),
    'FKCB1A289AD9BB831F'  => array(
        'sTableName'  => 'd3_extsearch_synset',
        'sType'   => '',
        'sName'     => 'FKCB1A289AD9BB831F',
        'aFields' => array(
            'SECTION_ID' => 'SECTION_ID',
        ),
        'blMultilang' => false,
    ),
    'IS_VISIBLE'  => array(
        'sTableName'  => 'd3_extsearch_synset',
        'sType'   => '',
        'aFields' => array(
            'IS_VISIBLE' => 'IS_VISIBLE',
        ),
        'blMultilang' => false,
    ),
    'IS_ORIGINAL'  => array(
        'sTableName'  => 'd3_extsearch_synset',
        'sType'   => '',
        'aFields' => array(
            'ORIGINAL_ID' => 'ORIGINAL_ID',
        ),
        'blMultilang' => false,
    ),
);

$this->aESSemanticRenameFields = array(
    'SYNSET_OXID'        => array(
        'sTableName'  => 'd3_extsearch_synset',
        'mOldFieldNames' => array('oxid'), // is case sensitive
        'sFieldName'  => 'OXID',
        'blMultilang' => false,
    ),
    'SYNSET_VERSION'        => array(
        'sTableName'  => 'd3_extsearch_synset',
        'mOldFieldNames' => array('version'), // is case sensitive
        'sFieldName'  => 'VERSION',
        'blMultilang' => false,
    ),
    'SYNSET_EVALUATION'        => array(
        'sTableName'  => 'd3_extsearch_synset',
        'mOldFieldNames' => array('evaluation'), // is case sensitive
        'sFieldName'  => 'EVALUATION',
        'blMultilang' => false,
    ),
    'SYNSET_IMPORTSTATUS'        => array(
        'sTableName'  => 'd3_extsearch_synset',
        'mOldFieldNames' => array('import_status'), // is case sensitive
        'sFieldName'  => 'IMPORT_STATUS',
        'blMultilang' => false,
    ),
    'SYNSET_ISVISIBLE'        => array(
        'sTableName'  => 'd3_extsearch_synset',
        'mOldFieldNames' => array('is_visible'), // is case sensitive
        'sFieldName'  => 'IS_VISIBLE',
        'blMultilang' => false,
    ),
    'SYNSET_ORIGINALID'        => array(
        'sTableName'  => 'd3_extsearch_synset',
        'mOldFieldNames' => array('original_id'), // is case sensitive
        'sFieldName'  => 'ORIGINAL_ID',
        'blMultilang' => false,
    ),
    'SYNSET_ORIGINALURI'        => array(
        'sTableName'  => 'd3_extsearch_synset',
        'mOldFieldNames' => array('originaluri'), // is case sensitive
        'sFieldName'  => 'ORIGINALURI',
        'blMultilang' => false,
    ),
    'SYNSET_PREFERREDCATEGORYID'        => array(
        'sTableName'  => 'd3_extsearch_synset',
        'mOldFieldNames' => array('preferred_category_id'), // is case sensitive
        'sFieldName'  => 'PREFERRED_CATEGORY_ID',
        'blMultilang' => false,
    ),
    'SYNSET_SECTIONID'        => array(
        'sTableName'  => 'd3_extsearch_synset',
        'mOldFieldNames' => array('section_id'), // is case sensitive
        'sFieldName'  => 'SECTION_ID',
        'blMultilang' => false,
    ),
    'SYNSET_SOURCEID'        => array(
        'sTableName'  => 'd3_extsearch_synset',
        'mOldFieldNames' => array('source_id'), // is case sensitive
        'sFieldName'  => 'SOURCE_ID',
        'blMultilang' => false,
    ),
    'SYNSET_PREFERREDTERM'        => array(
        'sTableName'  => 'd3_extsearch_synset',
        'mOldFieldNames' => array('synset_preferred_term'), // is case sensitive
        'sFieldName'  => 'SYNSET_PREFERRED_TERM',
        'blMultilang' => false,
    ),
    'SYNSET_USER_COMMENT'        => array(
        'sTableName'  => 'd3_extsearch_synset',
        'mOldFieldNames' => array('user_comment'), // is case sensitive
        'sFieldName'  => 'USER_COMMENT',
        'blMultilang' => false,
    ),
);
