<?php

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

$this->aESSemanticFields = array(
    'D3SYN_CAT_OXID'    => array(
        'sTableName'  => 'd3_extsearch_category',
        'sFieldName'  => 'id',
        'sType'       => 'CHAR(32)',
        'blNull'      => false,
        'sDefault'    => false,
        'sComment'    => '',
        'sExtra'      => '',
        'blMultilang' => false,
    ),
    'D3SYN_CAT_VERSION'    => array(
        'sTableName'  => 'd3_extsearch_category',
        'sFieldName'  => 'version',
        'sType'       => 'CHAR(32)',
        'blNull'      => false,
        'sDefault'    => false,
        'sComment'    => '',
        'sExtra'      => '',
        'blMultilang' => false,
    ),
    'D3SYN_CAT_CATEGORY_NAME'    => array(
        'sTableName'  => 'd3_extsearch_category',
        'sFieldName'  => 'category_name',
        'sType'       => 'VARCHAR(255)',
        'blNull'      => false,
        'sDefault'    => false,
        'sComment'    => '',
        'sExtra'      => '',
        'blMultilang' => false,
    ),
    'D3SYN_CAT_CATEGORY_TYPE_ID'    => array(
        'sTableName'  => 'd3_extsearch_category',
        'sFieldName'  => 'category_type_id',
        'sType'       => 'CHAR(32)',
        'blNull'      => true,
        'sDefault'    => 'NULL',
        'sComment'    => '',
        'sExtra'      => '',
        'blMultilang' => false,
    ),
    'D3SYN_CAT_IS_DISABLED'    => array(
        'sTableName'  => 'd3_extsearch_category',
        'sFieldName'  => 'is_disabled',
        'sType'       => 'BIT(1)',
        'blNull'      => true,
        'sDefault'    => 'NULL',
        'sComment'    => '',
        'sExtra'      => '',
        'blMultilang' => false,
    ),
    'D3SYN_CAT_IS_ORIGINAL'    => array(
        'sTableName'  => 'd3_extsearch_category',
        'sFieldName'  => 'is_original',
        'sType'       => 'BIT(1)',
        'blNull'      => false,
        'sDefault'    => false,
        'sComment'    => '',
        'sExtra'      => '',
        'blMultilang' => false,
    ),
    'D3SYN_CAT_URI'    => array(
        'sTableName'  => 'd3_extsearch_category',
        'sFieldName'  => 'uri',
        'sType'       => 'VARCHAR(255)',
        'blNull'      => true,
        'sDefault'    => 'NULL',
        'sComment'    => '',
        'sExtra'      => '',
        'blMultilang' => false,
    ),
);

$this->aESSemanticIndizes = array(
    'SYNCAT_PRIMARY'  => array(
        'sTableName'  => 'd3_extsearch_category',
        'sType'     => 'PRIMARY',
        'sName'     => 'PRIMARY',
        'aFields'   => array(
            'id' => 'id',
        ),
        'blMultilang' => false,
    ),
    'SYNCAT_CATEGORY_NAME'  => array(
        'sTableName'  => 'd3_extsearch_category',
        'sType'     => 'UNIQUE',
        'sName'     => 'category_name',
        'aFields'   => array(
            'category_name' => 'category_name',
        ),
        'blMultilang' => false,
    ),
    'SYNCAT_URI'  => array(
        'sTableName'  => 'd3_extsearch_category',
        'sType'     => 'UNIQUE',
        'sName'     => 'uri',
        'aFields'   => array(
            'uri' => 'uri',
        ),
        'blMultilang' => false,
    ),
    'FK302BCFE9E125C18'  => array(
        'sTableName'  => 'd3_extsearch_category',
        'sType'     => '',
        'sName'     => 'FK302BCFE9E125C18',
        'aFields'   => array(
            'category_type_id' => 'category_type_id',
        ),
        'blMultilang' => false,
    ),
);