Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- !-- {
- '' => bless( {
- 'mv_searchspec' => [
- 'Accessories',
- 'Boot Toppers'
- ],
- 'mv_numeric' => [],
- 'mv_search_file' => [
- 'products'
- ],
- 'mv_results' => [
- [
- '00098'
- ],
- [
- '00099'
- ]
- ],
- 'mv_matchlimit' => 50,
- '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' )
- }
- -->
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement