*************************** 1. row ***************************
       Table: jos_vm_product
Create Table: CREATE TABLE `jos_vm_product` (
  `product_id` int(11) NOT NULL,
  `vendor_id` int(11) NOT NULL DEFAULT 0,
  `product_parent_id` int(11) NOT NULL DEFAULT 0,
  `product_sku` varchar(64) NOT NULL DEFAULT '',
  `product_s_desc` varchar(380) DEFAULT NULL,
  `product_desc` text DEFAULT NULL,
  `product_thumb_image` varchar(255) DEFAULT NULL,
  `product_full_image` varchar(255) DEFAULT NULL,
  `product_publish` char(1) DEFAULT NULL,
  `product_weight` decimal(10,4) DEFAULT NULL,
  `product_weight_uom` varchar(32) DEFAULT 'kg',
  `product_length` decimal(10,4) DEFAULT NULL,
  `product_width` decimal(10,4) DEFAULT NULL,
  `product_height` decimal(10,4) DEFAULT NULL,
  `product_lwh_uom` varchar(32) DEFAULT 'inches',
  `product_url` varchar(255) DEFAULT NULL,
  `product_in_stock` int(11) unsigned DEFAULT NULL,
  `product_available_date` int(11) DEFAULT NULL,
  `product_availability` varchar(56) NOT NULL DEFAULT '',
  `product_special` char(100) DEFAULT NULL,
  `product_discount_id` int(11) DEFAULT NULL,
  `ship_code_id` varchar(50) DEFAULT NULL,
  `domain_visibility` varchar(50) DEFAULT NULL,
  `shopper_group_visibility` varchar(128) DEFAULT NULL,
  `cdate` int(11) DEFAULT NULL,
  `mdate` int(11) DEFAULT NULL,
  `mdate_mall` int(11) DEFAULT NULL,
  `mdate_mall_cz` int(11) DEFAULT NULL,
  `product_name` varchar(150) DEFAULT NULL,
  `product_sales` int(11) NOT NULL DEFAULT 0,
  `attribute` text DEFAULT NULL,
  `custom_attribute` text NOT NULL,
  `product_tax_id` tinyint(2) NOT NULL DEFAULT 0,
  `product_unit` varchar(32) DEFAULT NULL,
  `product_packaging` int(11) DEFAULT NULL,
  `images` text NOT NULL,
  `supplier_id` varchar(32) NOT NULL DEFAULT '0',
  `marks_group` text DEFAULT NULL,
  `models_group` text DEFAULT NULL,
  `product_personal_taking_only` int(11) unsigned NOT NULL DEFAULT 0,
  `product_top_offer` char(100) DEFAULT NULL,
  `images_descs` text NOT NULL,
  `together_ordered_products` text NOT NULL,
  `category_ordering` text NOT NULL,
  `product_credit_amount` varchar(6) DEFAULT NULL,
  `use_global_attribute` char(1) DEFAULT NULL,
  `product_sef_name` varchar(64) DEFAULT NULL,
  `alt_price_lbl` varchar(2) DEFAULT NULL,
  `product_thumb_image_dim` varchar(10) DEFAULT NULL,
  `ean` varchar(13) DEFAULT NULL,
  `child_options` varchar(45) DEFAULT NULL,
  `quantity_options` varchar(45) DEFAULT NULL,
  `child_option_ids` varchar(45) DEFAULT NULL,
  `product_order_levels` varchar(45) DEFAULT NULL,
  `product_is_unsaleable` tinyint(1) NOT NULL DEFAULT 0,
  `product_full_thumb_separe_upload` tinyint(1) NOT NULL DEFAULT 0,
  `product_meta_h1` text DEFAULT NULL,
  `product_meta_title` text DEFAULT NULL,
  `product_meta_desc` text DEFAULT NULL,
  `product_meta_keywords` text DEFAULT NULL,
  `remarketing_title` varchar(25) DEFAULT NULL,
  `remarketing_desc` varchar(25) DEFAULT NULL,
  `primary_category_id` int(11) NOT NULL DEFAULT 0,
  `non_redundant` tinyint(1) NOT NULL DEFAULT 0,
  `priceportal_productname` varchar(255) DEFAULT NULL,
  `product_2nd_name` varchar(150) DEFAULT NULL,
  `product_2nd_s_desc` text DEFAULT NULL,
  `old_attribute` text DEFAULT NULL,
  `pohoda_connector_added` int(11) DEFAULT NULL,
  `pohoda_connector_updated` int(11) DEFAULT NULL,
  `prev_product_availability` varchar(1024) NOT NULL DEFAULT '',
  `pohoda_connector_exported` tinyint(1) NOT NULL DEFAULT 0,
  `gift_sk` text NOT NULL,
  `gift_cz` text NOT NULL,
  `pohoda_connector_add_date` varchar(6) NOT NULL DEFAULT '',
  `pohoda_connector_upd_date` varchar(6) NOT NULL DEFAULT '',
  `pohoda_connector_add_md5` varchar(32) NOT NULL DEFAULT '',
  `pohoda_connector_upd_md5` varchar(32) NOT NULL DEFAULT '',
  `productname_zbozi_cz` varchar(255) DEFAULT NULL,
  `action_date` int(11) DEFAULT NULL,
  `product_param_group_id_mall` int(11) DEFAULT NULL,
  `product_param_group_id` text DEFAULT NULL,
  `product_param_group_id_mall_cz` int(11) DEFAULT NULL,
  `_id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`product_id`),
  UNIQUE KEY `_id` (`_id`),
  KEY `idx_product_vendor_id` (`vendor_id`),
  KEY `idx_product_product_parent_id` (`product_parent_id`),
  KEY `idx_product_ship_code_id` (`ship_code_id`),
  KEY `idx_product_name` (`product_name`),
  KEY `idx_mdate` (`mdate`),
  KEY `product_sef_name` (`product_sef_name`),
  KEY `product_publish` (`product_publish`),
  KEY `pohoda_connector_added` (`pohoda_connector_added`),
  KEY `pohoda_connector_updated` (`pohoda_connector_updated`),
  KEY `pohoda_connector_add_date` (`pohoda_connector_add_date`),
  KEY `pohoda_connector_upd_date` (`pohoda_connector_upd_date`),
  KEY `product_special` (`product_special`),
  KEY `idx_mdate_mall` (`mdate_mall`),
  KEY `idx_product_sku` (`product_sku`),
  KEY `product_sales` (`product_sales`),
  KEY `idx_mdate_mall_cz` (`mdate_mall_cz`),
  KEY `non_redundant` (`non_redundant`)
) ENGINE=InnoDB AUTO_INCREMENT=356403 DEFAULT CHARSET=utf8