<!-- {
  '' => bless( {
    'mv_searchspec' => [
      'Accessories',
      'Boot Toppers'
    ],
    'mv_numeric' => [],
    'mv_search_file' => [
      'products'
    ],
    'mv_results' => [
      [
        '00098'
      ],
      [
        '00099'
      ]
    ],
    'mv_matchlimit' => 10,
    'mv_return_delim' => '  ',
    'eq_specs_sql' => [
      'prod_group = \'Accessories\'',
      'category = \'Boot Toppers\''
    ],
    'dbref' => bless( [
      {
        'PRINTERROR' => 0,
        'PASS' => 'dbp.23',
        'SEQUENCE_KEY' => 'INT PRIMARY KEY AUTO_INCREMENT',
        'NO_ASCII_INDEX' => '1',
        'file' => 'products.txt',
        'HAS_DESCRIBE' => 1,
        'AUTO_NUMBER_FILE' => '/var/lib/interchange/designsbypat/products/.products.autonumber',
        'HIDE_FIELD' => 'inactive',
        'INDEX' => [
          'title',
          'price',
          'category',
          'prod_group'
        ],
        'ALTER_DELETE' => 'ALTER TABLE _TABLE_ DROP _COLUMN_',
        '_Checked_capability' => 2,
        'COLUMN_DEF' => {
          'sku' => 'char(64) NOT NULL PRIMARY KEY',
          'inactive' => 'varchar(3) DEFAULT \'\'',
          'author' => 'varchar(255)',
          'thumb' => 'varchar(128)',
          'size' => 'varchar(96)',
          'featured' => 'varchar(32)',
          'color' => 'varchar(96)',
          'weight' => 'varchar(12) DEFAULT \'0\' NOT NULL',
          'category' => 'varchar(64) NOT NULL DEFAULT \'\'',
          'gift_cert' => 'varchar(3) DEFAULT \'\'',
          'description' => 'varchar(128) NOT NULL',
          'image' => 'varchar(64)',
          'prod_group' => 'varchar(64) NOT NULL DEFAULT \'\'',
          'related' => 'text',
          'comment' => 'TEXT',
          'template_page' => 'varchar(64)',
          'price' => 'DECIMAL(12,2) NOT NULL',
          'title' => 'varchar(128) DEFAULT \'\' NOT NULL',
          'nontaxable' => 'CHAR(3)'
        },
        'included_from' => 'dbconf/mysql/products.mysql',
        'EXTENDED' => '',
        'db_text' => '/var/lib/interchange/designsbypat/products/products.txt',
        'USER' => 'designsbypat',
        'HIDE_AUTO_FILES' => '1',
        'ALTER_INDEX' => 'CREATE _UNIQUE_ INDEX $TABLE$_$COLUMN$ ON _TABLE_ (_COLUMN_)',
        'KEY' => 'sku',
        'TABLE_COMMENT_SQL' => 'COMMENT=_COMMENT_',
        'Exists_handle' => undef,
        'Update_handle' => undef,
        'name' => 'products',
        '_Insert_h' => undef,
        'SEQUENCE_LAST_FUNCTION' => 'select last_insert_id()',
        'LIST_FIELDS_QUERY' => 'SELECT * FROM `_TABLE_` WHERE 2 = 1',
        'HAS_LIMIT' => 1,
        'dsn_id' => 'dbi:mysql:store2_designsbypat_designsbypat_dbp.23',
        'Class' => 'DBI',
        'type' => 8,
        'RAISEERROR' => 1,
        '_Auto_number' => undef,
        'ObjectType' => 'Vend::Table::DBI',
        'ALTER_CHANGE' => 'ALTER TABLE _TABLE_ CHANGE COLUMN _COLUMN_ _COLUMN_ _DEF_',
        'db_file' => 'products',
        'TABLE_COMMENT_DURING_CREATE' => 1,
        'DIR' => '/var/lib/interchange/designsbypat/products',
        'HAS_TABLE_TYPE' => 1,
        'AutoNumberCounter' => bless( {
          'date' => undef,
          'value' => '00190',
          'file' => '/var/lib/interchange/designsbypat/products/.products.autonumber',
          'magic_value' => undef,
          'dec_routine' => undef,
          'gmt' => undef,
          'updated' => 0,
          'initial' => '00001',
          'inc_routine' => undef
        }, 'Vend::CounterFile' ),
        'ALTER_ADD' => 'ALTER TABLE _TABLE_ ADD COLUMN _COLUMN_ _DEF_',
        'COLUMN_INDEX' => {
          'sku' => 0,
          'inactive' => 22,
          'author' => 15,
          'thumb' => 5,
          'featured' => 17,
          'url' => 23,
          'weight' => 13,
          'category' => 10,
          'dl_location' => 21,
          'wholesale' => 8,
          'image_large' => 25,
          'sale_price' => 24,
          'description' => 1,
          'gift_cert' => 18,
          'image' => 6,
          'prod_group' => 9,
          'option_type' => 14,
          'related' => 16,
          'comment' => 4,
          'template_page' => 3,
          'price' => 7,
          'title' => 2,
          'nontaxable' => 12,
          'dl_type' => 20,
          'download' => 19,
          'tax_category' => 11
        },
        'db_file_extended' => '/var/lib/interchange/designsbypat/products/.products.sql',
        'KEY_INDEX' => 0,
        'DESCRIBE_TABLE' => sub { "DUMMY" },
        'NAME' => [
          'sku',
          'description',
          'title',
          'template_page',
          'comment',
          'thumb',
          'image',
          'price',
          'wholesale',
          'prod_group',
          'category',
          'tax_category',
          'nontaxable',
          'weight',
          'option_type',
          'author',
          'related',
          'featured',
          'gift_cert',
          'download',
          'dl_type',
          'dl_location',
          'inactive',
          'url',
          'sale_price',
          'image_large'
        ],
        '_Numeric_ary' => [
          undef,
          undef,
          undef,
          undef,
          undef,
          undef,
          undef,
          2,
          undef,
          undef,
          undef,
          undef,
          undef,
          undef,
          undef,
          undef,
          undef,
          undef,
          undef,
          undef,
          undef,
          undef,
          undef,
          undef,
          undef,
          undef
        ],
        'DSN' => 'dbi:mysql:store2_designsbypat',
        'NUMERIC' => {
          'price' => undef
        }
      },
      'products',
      'sku',
      [
        'sku',
        'description',
        'title',
        'template_page',
        'comment',
        'thumb',
        'image',
        'price',
        'wholesale',
        'prod_group',
        'category',
        'tax_category',
        'nontaxable',
        'weight',
        'option_type',
        'author',
        'related',
        'featured',
        'gift_cert',
        'download',
        'dl_type',
        'dl_location',
        'inactive',
        'url',
        'sale_price',
        'image_large'
      ],
      '',
      bless( {}, 'DBI::db' )
    ], 'Vend::Table::DBI' ),
    'mv_cache_key' => '76d48363cb95eab082bbbbb802b9cc25',
    'mv_case' => [],
    'mv_min_string' => 1,
    'mv_search_relate' => undef,
    'mv_session_id' => 'TYLm4iNr',
    'mv_begin_string' => [],
    'mv_index_delim' => '   ',
    'mv_orsearch' => [],
    'mv_search_group' => [],
    'mv_search_field' => [
      9,
      10
    ],
    'mv_sort_option' => [],
    'mv_substring_match' => [],
    'mv_base_directory' => 'products',
    'mv_coordinate' => 1,
    'mv_column_op' => [
      [
        ' eq q{',
        '}'
      ],
      [
        ' eq q{',
        '}'
      ]
    ],
    'matches' => 2,
    'mv_head_skip' => 0,
    'field_hash' => {
      'sku' => 0,
      'inactive' => 22,
      'author' => 15,
      'thumb' => 5,
      'featured' => 17,
      'url' => 23,
      'weight' => 13,
      'category' => 10,
      'dl_location' => 21,
      'wholesale' => 8,
      'image_large' => 25,
      'sale_price' => 24,
      'description' => 1,
      'gift_cert' => 18,
      'image' => 6,
      'prod_group' => 9,
      'option_type' => 14,
      'related' => 16,
      'comment' => 4,
      'template_page' => 3,
      'price' => 7,
      'title' => 2,
      'nontaxable' => 12,
      'dl_type' => 20,
      'download' => 19,
      'tax_category' => 11
    },
    'mv_all_chars' => [
      1,
      1
    ],
    'eq_specs' => [
      'Accessories',
      'Boot Toppers'
    ],
    'verbatim_columns' => 1,
    'mv_negate' => [],
    'mv_field_names' => [
      'sku',
      'description',
      'title',
      'template_page',
      'comment',
      'thumb',
      'image',
      'price',
      'wholesale',
      'prod_group',
      'category',
      'tax_category',
      'nontaxable',
      'weight',
      'option_type',
      'author',
      'related',
      'featured',
      'gift_cert',
      'download',
      'dl_type',
      'dl_location',
      'inactive',
      'url',
      'sale_price',
      'image_large'
    ],
    'mv_sort_field' => [
      1
    ]
  }, 'Vend::DbSearch' )
}
 -->