--
-- Host: localhost    Database: jdsluggage
-- ------------------------------------------------------


--
-- Table structure for table `admin_assert`
--

CREATE TABLE `admin_assert` (
  `assert_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Assert ID',
  `assert_type` varchar(20) NOT NULL COMMENT 'Assert Type',
  `assert_data` text COMMENT 'Assert Data',
  PRIMARY KEY (`assert_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Admin Assert Table';

--
-- Dumping data for table `admin_assert`
--


--
-- Table structure for table `admin_role`
--

CREATE TABLE `admin_role` (
  `role_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Role ID',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Parent Role ID',
  `tree_level` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Role Tree Level',
  `sort_order` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Role Sort Order',
  `role_type` varchar(1) NOT NULL DEFAULT '0' COMMENT 'Role Type',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'User ID',
  `role_name` varchar(50) NOT NULL COMMENT 'Role Name',
  PRIMARY KEY (`role_id`),
  KEY `IDX_ADMIN_ROLE_PARENT_ID_SORT_ORDER` (`parent_id`,`sort_order`),
  KEY `IDX_ADMIN_ROLE_TREE_LEVEL` (`tree_level`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='Admin Role Table';

--
-- Dumping data for table `admin_role`
--

INSERT INTO `admin_role` VALUES (1,0,1,1,'G',0,'Administrators'),(4,1,2,0,'U',1,'Store'),(5,1,2,0,'U',2,'Javier');

--
-- Table structure for table `admin_rule`
--

CREATE TABLE `admin_rule` (
  `rule_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rule ID',
  `role_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Role ID',
  `resource_id` varchar(255) NOT NULL COMMENT 'Resource ID',
  `privileges` varchar(20) DEFAULT NULL COMMENT 'Privileges',
  `assert_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Assert ID',
  `role_type` varchar(1) DEFAULT NULL COMMENT 'Role Type',
  `permission` varchar(10) DEFAULT NULL COMMENT 'Permission',
  PRIMARY KEY (`rule_id`),
  KEY `IDX_ADMIN_RULE_RESOURCE_ID_ROLE_ID` (`resource_id`,`role_id`),
  KEY `IDX_ADMIN_RULE_ROLE_ID_RESOURCE_ID` (`role_id`,`resource_id`),
  CONSTRAINT `FK_ADMIN_RULE_ROLE_ID_ADMIN_ROLE_ROLE_ID` FOREIGN KEY (`role_id`) REFERENCES `admin_role` (`role_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Admin Rule Table';

--
-- Dumping data for table `admin_rule`
--

INSERT INTO `admin_rule` VALUES (1,1,'all','',0,'G','allow');

--
-- Table structure for table `adminnotification_inbox`
--

CREATE TABLE `adminnotification_inbox` (
  `notification_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Notification id',
  `severity` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Problem type',
  `date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Create date',
  `title` varchar(255) NOT NULL COMMENT 'Title',
  `description` text COMMENT 'Description',
  `url` varchar(255) DEFAULT NULL COMMENT 'Url',
  `is_read` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Flag if notification read',
  `is_remove` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Flag if notification might be removed',
  PRIMARY KEY (`notification_id`),
  KEY `IDX_ADMINNOTIFICATION_INBOX_SEVERITY` (`severity`),
  KEY `IDX_ADMINNOTIFICATION_INBOX_IS_READ` (`is_read`),
  KEY `IDX_ADMINNOTIFICATION_INBOX_IS_REMOVE` (`is_remove`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8 COMMENT='Adminnotification Inbox';

--
-- Dumping data for table `adminnotification_inbox`
--

INSERT INTO `adminnotification_inbox` VALUES (1,4,'2008-07-25 09:24:40','Magento 1.1 Production Version Now Available','We are thrilled to announce the availability of the production release of Magento 1.1. Read more about the release in the Magento Blog.','http://www.magentocommerce.com/blog/comments/magento-11-is-here-1/',0,0),(2,4,'2008-08-02 09:30:16','Updated iPhone Theme is now available','Updated iPhone theme for Magento 1.1 is now available on Magento Connect and for upgrade through your Magento Connect Manager.','http://www.magentocommerce.com/blog/comments/updated-iphone-theme-for-magento-11-is-now-available/',0,0),(3,3,'2008-08-02 09:40:27','Magento version 1.1.2 is now available','Magento version 1.1.2 is now available for download and upgrade.','http://www.magentocommerce.com/blog/comments/magento-version-112-is-now-available/',0,0),(4,3,'2008-08-14 01:51:46','Magento version 1.1.3 is now available','Magento version 1.1.3 is now available','http://www.magentocommerce.com/blog/comments/magento-version-113-is-now-available/',0,0),(5,1,'2008-09-03 05:10:31','Magento Version 1.1.4 Security Update Now Available','Magento 1.1.4 Security Update Now Available. If you are using Magento version 1.1.x, we highly recommend upgrading to this version as soon as possible.','http://www.magentocommerce.com/blog/comments/magento-version-114-security-update/',0,0),(6,3,'2008-09-16 06:09:54','Magento version 1.1.5 Now Available','Magento version 1.1.5 Now Available.\n\nThis release includes many bug fixes, a new category manager and a new skin for the default Magento theme.','http://www.magentocommerce.com/blog/comments/magento-version-115-now-available/',0,0),(7,3,'2008-09-18 04:18:35','Magento version 1.1.6 Now Available','Magento version 1.1.6 Now Available.\n\nThis version includes bug fixes for Magento 1.1.x that are listed in the release notes section.','http://www.magentocommerce.com/blog/comments/magento-version-116-now-available/',0,0),(8,4,'2008-11-08 09:46:42','Reminder: Change Magento`s default phone numbers and callouts before site launch','Before launching your Magento store, please remember to change Magento`s default phone numbers that appear in email templates, callouts, templates, etc.','',0,0),(9,3,'2008-11-20 11:31:12','Magento version 1.1.7 Now Available','Magento version 1.1.7 Now Available.\n\nThis version includes over 350 issue resolutions for Magento 1.1.x that are listed in the release notes section, and new functionality that includes:\n\n-Google Website Optimizer integration\n-Google Base integration\n-Scheduled DB logs cleaning option','http://www.magentocommerce.com/blog/comments/magento-version-117-now-available/',0,0),(10,3,'2008-11-27 07:24:50','Magento Version 1.1.8 Now Available','Magento version 1.1.8 now available.\n\nThis version includes some issue resolutions for Magento 1.1.x that are listed in the release notes section.','http://www.magentocommerce.com/blog/comments/magento-version-118-now-available/',0,0),(11,3,'2008-12-30 17:45:59','Magento version 1.2.0 is now available for download and upgrade','We are extremely happy to announce the availability of Magento version 1.2.0 for download and upgrade.\n\nThis version includes numerous issue resolutions for Magento version 1.1.x and some highly requested new features such as:\n\n    * Support for Downloadable/Digital Products. \n    * Added Layered Navigation to site search result page.\n    * Improved site search to utilize MySQL fulltext search\n    * Added support for fixed-taxes on product level.\n    * Upgraded Zend Framework to the latest stable version 1.7.2','http://www.magentocommerce.com/blog/comments/magento-version-120-is-now-available/',0,0),(12,2,'2008-12-31 07:59:22','Magento version 1.2.0.1 now available','Magento version 1.2.0.1 now available.This version includes some issue resolutions for Magento 1.2.x that are listed in the release notes section.','http://www.magentocommerce.com/blog/comments/magento-version-1201-available/',0,0),(13,2,'2009-01-13 06:41:49','Magento version 1.2.0.2 now available','Magento version 1.2.0.2 is now available for download and upgrade. This version includes an issue resolutions for Magento version 1.2.0.x as listed in the release notes.','http://www.magentocommerce.com/blog/comments/magento-version-1202-now-available/',0,0),(14,3,'2009-01-24 10:25:56','Magento version 1.2.0.3 now available','Magento version 1.2.0.3 is now available for download and upgrade. This version includes issue resolutions for Magento version 1.2.0.x as listed in the release notes.','http://www.magentocommerce.com/blog/comments/magento-version-1203-now-available/',0,0),(15,3,'2009-02-03 07:57:00','Magento version 1.2.1 is now available for download and upgrade','We are happy to announce the availability of Magento version 1.2.1 for download and upgrade.\n\nThis version includes some issue resolutions for Magento version 1.2.x. A full list of items included in this release can be found on the release notes page.','http://www.magentocommerce.com/blog/comments/magento-version-121-now-available/',0,0),(16,3,'2009-02-24 10:45:47','Magento version 1.2.1.1 now available','Magento version 1.2.1.1 now available.This version includes some issue resolutions for Magento 1.2.x that are listed in the release notes section.','http://www.magentocommerce.com/blog/comments/magento-version-1211-now-available/',0,0),(17,3,'2009-02-27 11:39:24','CSRF Attack Prevention','We have just posted a blog entry about a hypothetical CSRF attack on a Magento admin panel. Please read the post to find out if your Magento installation is at risk at http://www.magentocommerce.com/blog/comments/csrf-vulnerabilities-in-web-application-and-how-to-avoid-them-in-magento/','http://www.magentocommerce.com/blog/comments/csrf-vulnerabilities-in-web-application-and-how-to-avoid-them-in-magento/',0,0),(18,2,'2009-03-04 09:03:58','Magento version 1.2.1.2 now available','Magento version 1.2.1.2 is now available for download and upgrade.\nThis version includes some updates to improve admin security as described in the release notes page.','http://www.magentocommerce.com/blog/comments/magento-version-1212-now-available/',0,0),(19,3,'2009-03-31 10:22:40','Magento version 1.3.0 now available','Magento version 1.3.0 is now available for download and upgrade. This version includes numerous issue resolutions for Magento version 1.2.x and new features as described on the release notes page.','http://www.magentocommerce.com/blog/comments/magento-version-130-is-now-available/',0,0),(20,3,'2009-04-18 12:06:02','Magento version 1.3.1 now available','Magento version 1.3.1 is now available for download and upgrade. This version includes some issue resolutions for Magento version 1.3.x and new features such as Checkout By Amazon and Amazon Flexible Payment. To see a full list of updates please check the release notes page.','http://www.magentocommerce.com/blog/comments/magento-version-131-now-available/',0,0),(21,3,'2009-05-20 06:31:21','Magento version 1.3.1.1 now available','Magento version 1.3.1.1 is now available for download and upgrade. This version includes some issue resolutions for Magento version 1.3.x and a security update for Magento installations that run on multiple domains or sub-domains. If you are running Magento with multiple domains or sub-domains we highly recommend upgrading to this version.','http://www.magentocommerce.com/blog/comments/magento-version-1311-now-available/',0,0),(22,3,'2009-05-30 06:54:06','Magento version 1.3.2 now available','This version includes some improvements and issue resolutions for version 1.3.x that are listed on the release notes page. also included is a Beta version of the Compile module.','http://www.magentocommerce.com/blog/comments/magento-version-132-now-available/',0,0),(23,3,'2009-06-02 03:32:52','Magento version 1.3.2.1 now available','Magento version 1.3.2.1 now available for download and upgrade.\n\nThis release solves an issue for users running Magento with PHP 5.2.0, and changes to index.php to support the new Compiler Module.','http://www.magentocommerce.com/blog/comments/magento-version-1321-now-available/',0,0),(24,3,'2009-07-02 09:21:44','Magento version 1.3.2.2 now available','Magento version 1.3.2.2 is now available for download and upgrade.\n\nThis release includes issue resolution for Magento version 1.3.x. To see a full list of changes please visit the release notes page http://www.magentocommerce.com/download/release_notes.','http://www.magentocommerce.com/blog/comments/magento-version-1322-now-available/',0,0),(25,3,'2009-07-23 14:48:54','Magento version 1.3.2.3 now available','Magento version 1.3.2.3 is now available for download and upgrade.\n\nThis release includes issue resolution for Magento version 1.3.x. We recommend to upgrade to this version if PayPal payment modules are in use. To see a full list of changes please visit the release notes page http://www.magentocommerce.com/download/release_notes.','http://www.magentocommerce.com/blog/comments/magento-version-1323-now-available/',0,0),(26,4,'2009-08-29 02:26:28','PayPal is updating Payflow Pro and Website Payments Pro (Payflow Edition) UK.','If you are using Payflow Pro and/or Website Payments Pro (Payflow Edition) UK.  payment methods, you will need to update the URL‘s in your Magento Administrator Panel in order to process transactions after September 1, 2009. Full details are available here: http://www.magentocommerce.com/wiki/paypal_payflow_changes','http://www.magentocommerce.com/wiki/paypal_payflow_changes',0,0),(27,2,'2009-09-24 04:16:49','Magento Version 1.3.2.4 Security Update','Magento Version 1.3.2.4 is now available. This version includes a security updates for Magento 1.3.x that solves possible XSS vulnerability issue on customer registration page and is available through SVN, Download Page and through the Magento Connect Manager.','http://www.magentocommerce.com/blog/comments/magento-version-1324-security-update/',0,0),(28,4,'2009-09-25 22:57:54','Magento Preview Version 1.4.0.0-alpha2 is now available','We are happy to announce the availability of Magento Preview Version 1.4.0.0-alpha2 for download.\nAs this is a preview version it is NOT recommended in any way to be used in a production environment.','http://www.magentocommerce.com/blog/comments/magento-preview-version-1400-alpha2-now-available/',0,0),(29,4,'2009-10-07 08:55:40','Magento Preview Version 1.4.0.0-alpha3 is now available','We are happy to announce the availability of Magento Preview Version 1.4.0.0-alpha3 for download.\nAs this is a preview version it is NOT recommended in any way to be used in a production environment.','http://www.magentocommerce.com/blog/comments/magento-preview-version-1400-alpha3-now-available/',0,0),(30,4,'2009-12-09 09:30:36','Magento Preview Version 1.4.0.0-beta1 is now available','We are happy to announce the availability of Magento Preview Version 1.4.0.0-beta1 for download.\nAs this is a preview version it is NOT recommended in any way to be used in a production environment.','http://www.magentocommerce.com/blog/comments/magento-preview-version-1400-beta1-now-available/',0,0),(31,4,'2009-12-31 19:22:12','Magento Preview Version 1.4.0.0-rc1 is now available','We are happy to announce the availability of Magento Preview Version 1.4.0.0-rc1 for download.\nAs this is a preview version it is NOT recommended in any way to be used in a production environment.','http://www.magentocommerce.com/blog/comments/magento-preview-version-1400-rc1-now-available/',0,0),(32,4,'2010-02-13 13:39:53','Magento CE Version 1.4.0.0 Stable is now available','We are excited to announce the availability of Magento CE Version 1.4.0.0 Stable for upgrade and download.','http://bit.ly/c53rpK',0,0),(33,3,'2010-02-20 12:39:36','Magento CE Version 1.4.0.1 Stable is now available','Magento CE 1.4.0.1 Stable is now available for upgrade and download.','http://www.magentocommerce.com/blog/comments/magento-ce-version-1401-stable-now-available/',0,0),(34,4,'2010-04-24 04:09:03','Magento Version CE 1.3.3.0 Stable - Now Available With Support for 3-D Secure','Based on community requests, we are excited to announce the release of Magento CE 1.3.3.0-Stable with support for 3-D Secure. This release is intended for Magento merchants using version 1.3.x, who want to add support for 3-D Secure.','http://www.magentocommerce.com/blog/comments/magento-version-ce-1330-stable-now-available-with-support-for-3-d-secure/',0,0),(35,4,'2010-06-01 01:20:21','Announcing the Launch of Magento Mobile','The Magento team is pleased to announce the launch of Magento mobile, a new product that will allow Magento merchants to easily create branded, native mobile storefront applications that are deeply integrated with Magento’s market-leading eCommerce platform. The product includes a new administrative manager, a native iPhone app that is fully customizable, and a service where Magento manages the submission and maintenance process for the iTunes App Store.\n\nLearn more by visiting the Magento mobile product page and sign-up to be the first to launch a native mobile commerce app, fully integrated with Magento.','http://www.magentocommerce.com/product/mobile',0,0),(36,4,'2010-06-11 04:08:08','Magento CE Version 1.4.1.0 Stable is now available','We are excited to announce the availability of Magento CE Version 1.4.1.0 Stable for upgrade and download. Some of the highlights of this release include: Enhanced PayPal integration (more info to follow), Change of Database structure of the Sales module to no longer use EAV, and much more.','http://www.magentocommerce.com/blog/comments/magento-ce-version-1410-stable-now-available/',0,0),(37,4,'2010-07-27 05:37:34','Magento CE Version 1.4.1.1 Stable is now available','We are excited to announce the availability of Magento CE Version 1.4.1.1 Stable for download and upgrade.','http://www.magentocommerce.com/blog/comments/magento-ce-version-1411-stable-now-available/',0,0),(38,4,'2010-07-28 13:12:12','Magento CE Version 1.4.2.0-beta1 Preview Release Now Available','This release gives a preview of the new Magento Connect Manager.','http://www.magentocommerce.com/blog/comments/magento-preview-version-1420-beta1-now-available/',0,0),(39,4,'2010-07-29 04:15:01','Magento CE Version 1.4.1.1 Patch Available','As some users experienced issues with upgrading to CE 1.4.1.1 through PEAR channels we provided a patch for it that is available on our blog http://www.magentocommerce.com/blog/comments/magento-ce-version-1411-stable-patch/','http://www.magentocommerce.com/blog/comments/magento-ce-version-1411-stable-patch/',0,0),(40,4,'2010-10-12 08:13:25','Magento Mobile is now live!','Magento Mobile is now live! Signup today to have your own native iPhone mobile-shopping app in iTunes for the holiday season! Learn more at http://www.magentomobile.com/','http://www.magentomobile.com/',0,0),(41,4,'2010-11-09 07:52:06','Magento CE Version 1.4.2.0-RC1 Preview Release Now Available','We are happy to announce the availability of Magento Preview Version 1.4.2.0-RC1 for download.','http://www.magentocommerce.com/blog/comments/magento-preview-version-1420-rc1-now-available/',0,0),(42,4,'2010-12-03 06:33:00','Magento CE Version 1.4.2.0-RC2 Preview Release Now Available','We are happy to announce the availability of Magento Preview Version 1.4.2.0-RC2 for download.','http://www.magentocommerce.com/blog/comments/magento-preview-version-1420-rc2-now-available/',0,0),(43,4,'2010-12-09 08:29:55','Magento CE Version 1.4.2.0 Stable is now available','We are excited to announce the availability of Magento CE Version 1.4.2.0 Stable for download and upgrade.','http://www.magentocommerce.com/blog/comments/magento-ce-version-1420-stable-now-available/',0,0),(44,4,'2010-12-18 09:23:55','Magento Preview Version CE 1.5.0.0-alpha1 is now available','We are happy to announce the availability of Magento Preview Version CE 1.5.0.0-alpha1 for download.\nAs this is a preview version it is NOT recommended in any way to be used in a production environment.','http://www.magentocommerce.com/blog/comments/magento-preview-version-ce-1500-alpha1-now-available/',0,0),(45,4,'2010-12-30 09:51:08','Magento Preview Version CE 1.5.0.0-alpha2 is now available','We are happy to announce the availability of Magento Preview Version CE 1.5.0.0-alpha2 for download.\nAs this is a preview version it is NOT recommended in any way to be used in a production environment.','http://www.magentocommerce.com/blog/comments/magento-preview-version-ce-1500-alpha2-now-available/',0,0),(46,4,'2011-01-14 10:35:36','Magento Preview Version CE 1.5.0.0-beta1 is now available','We are happy to announce the availability of Magento Preview Version CE 1.5.0.0-beta1 for download.\nAs this is a preview version it is NOT recommended in any way to be used in a production environment.','http://www.magentocommerce.com/blog/comments/magento-preview-version-ce-1500-beta1-now-available/',0,0),(47,4,'2011-01-22 07:19:09','Magento Preview Version CE 1.5.0.0-beta2 is now available','We are happy to announce the availability of Magento Preview Version CE 1.5.0.0-beta2 for download.\nAs this is a preview version it is NOT recommended in any way to be used in a production environment.','http://www.magentocommerce.com/blog/comments/magento-preview-version-ce-1500-beta2-now-available/',0,0),(48,4,'2011-01-25 08:10:33','Join us for Magento\'s Imagine eCommerce Conference!','Magento\'s Imagine eCommerce Conference is a must-attend event for anyone who uses the Magento platform or is part of the Magento ecosystem. The conference will bring together over 500 retailers, merchants, developers, partners, eCommerce experts, technologists and marketing pros for a fun and intensive conversation about the future of eCommerce.\n\nThe conference is in Los Angeles and kicks off early Monday evening February 7th through Wednesday, February 9th, 2011.\n\nRegister at http://www.magento.com/imagine. First 20 registrants use discount code IMAGINE3X76 for $300 off. *This discount is sponsored by PayPal and is only valid for new registrations.\n\nHope to see you there!\n\nMagento Team','http://www.magento.com/imagine',0,0),(49,4,'2011-01-28 07:27:57','Magento Preview Version CE 1.5.0.0-rc1 is now available','We are happy to announce the availability of Magento Preview Version CE 1.5.0.0-rc1 for download.\nAs this is a preview version it is NOT recommended in any way to be used in a production environment.','http://www.magentocommerce.com/blog/comments/magento-preview-version-ce-1500-rc1-now-available/',0,0),(50,4,'2011-02-04 07:56:33','Magento Preview Version CE 1.5.0.0-rc2 is now available','We are happy to announce the availability of Magento Preview Version CE 1.5.0.0-rc2 for download.\nAs this is a preview version it is NOT recommended in any way to be used in a production environment.','http://www.magentocommerce.com/blog/comments/magento-preview-version-ce-1500-rc2-now-available/',0,0),(51,4,'2011-02-09 05:43:23','Magento CE Version 1.5.0.0 Stable is now available','We are excited to announce the availability of Magento CE Version 1.5.0.0 Stable for download and upgrade.','http://www.magentocommerce.com/blog/comments/magento-community-professional-and-enterprise-editions-releases-now-availab/',0,0),(52,4,'2011-02-10 09:42:57','Magento CE 1.5.0.1 stable Now Available','We are excited to announce the availability of Magento CE Version 1.5.0.1 Stable for download and upgrade.','http://www.magentocommerce.com/blog/comments/magento-ce-1501-stable-now-available/',0,0),(53,4,'2011-03-19 04:15:45','Magento CE 1.5.1.0-beta1 Now Available','We are happy to announce the availability of Magento Preview Version CE 1.5.1.0-beta1 for download and upgrade.','http://www.magentocommerce.com/blog/comments/magento-preview-version-ce-1510-beta1-now-available/',0,0),(54,4,'2011-04-01 02:43:02','Magento CE 1.5.1.0-rc1 Now Available','We are happy to announce the availability of Magento Preview Version CE 1.5.1.0-rc1 for download and upgrade.','http://www.magentocommerce.com/blog/comments/magento-preview-version-ce-1510-rc1-now-available/',0,0),(55,4,'2011-04-27 03:21:07','Magento CE 1.5.1.0-stable Now Available','We are excited to announce the availability of Magento CE Version 1.5.1.0 Stable for download and upgrade.','http://www.magentocommerce.com/blog/comments/magento-ce-version-1510-stable-now-available/',0,0),(56,4,'2011-05-27 03:33:23','Magento Preview Version CE 1.6.0.0-alpha1 is now available','We are happy to announce the availability of Magento Preview Version CE 1.6.0.0-alpha1 for download.\nAs this is a preview version it is NOT recommended in any way to be used in a production environment.','http://www.magentocommerce.com/blog/comments/magento-preview-version-ce-1600-alpha1-now-available/',0,0),(57,4,'2011-06-16 02:12:08','Magento Preview Version CE 1.6.0.0-beta1 is now available','We are happy to announce the availability of Magento Preview Version CE 1.6.0.0-beta1for download.\nAs this is a preview version it is NOT recommended in any way to be used in a production environment.','http://www.magentocommerce.com/blog/comments/magento-preview-version-ce-1600-beta1-now-available/',0,0),(58,4,'2011-07-01 03:03:58','Magento Preview Version CE 1.6.0.0-rc1 is now available','We are happy to announce the availability of Magento Preview Version CE 1.6.0.0-rc1 for download.\nAs this is a preview version it is NOT recommended in any way to be used in a production environment.','http://www.magentocommerce.com/blog/comments/magento-preview-version-ce-1600-rc1-now-available/',0,0),(59,4,'2011-07-12 03:07:39','Magento Preview Version CE 1.6.0.0-rc2 is now available','We are happy to announce the availability of Magento Preview Version CE 1.6.0.0-rc2 for download.\nAs this is a preview version it is NOT recommended in any way to be used in a production environment.','http://www.magentocommerce.com/blog/comments/magento-preview-version-ce-1600-rc2-now-available/',0,0),(60,4,'2011-08-20 01:58:31','Magento CE 1.6.0.0-stable Now Available','We are excited to announce the availability of Magento CE Version 1.6.0.0 Stable for download and upgrade.','http://www.magentocommerce.com/blog/comments/magento-ce-version-1600-stable-now-available/',0,0),(61,4,'2011-09-17 09:31:26','Magento Preview Version CE 1.6.1.0-beta1 is now available','We are happy to announce the availability of Magento Preview Version CE 1.6.1.0-beta1 for download.\nAs this is a preview version it is NOT recommended in any way to be used in a production environment.','http://www.magentocommerce.com/blog/comments/magento-preview-version-ce-1610-beta1-now-available/',0,0),(62,4,'2011-09-29 23:44:10','Magento Preview Version CE 1.6.1.0-rc1 is now available','We are happy to announce the availability of Magento Preview Version CE 1.6.1.0-rc1 for download.\nAs this is a preview version it is NOT recommended in any way to be used in a production environment.','http://www.magentocommerce.com/blog/comments/magento-preview-version-ce-1610-rc1-now-available/',0,0),(63,4,'2011-10-20 01:50:05','Magento CE 1.6.1.0-stable Now Available','We are excited to announce the availability of Magento CE Version 1.6.1.0 Stable for download and upgrade.','http://www.magentocommerce.com/blog/comments/magento-ce-version-1610-stable-now-available/',0,0),(64,4,'2008-11-08 09:46:42','Reminder: Change Magento`s default phone numbers and callouts before site launch','Before launching your Magento store, please remember to change Magento`s default phone numbers that appear in email templates, callouts, templates, etc.','',0,0),(65,4,'2011-12-31 03:39:35','Magento Preview Version CE 1.7.0.0-alpha1 is now available','We are happy to announce the availability of Magento Preview Version CE 1.7.0.0-alpha1 for download.\nAs this is a preview version it is NOT recommended in any way to be used in a production environment.','http://www.magentocommerce.com/blog/comments/magento-preview-version-ce-1700-alpha1-now-available/',0,0),(66,4,'2012-01-12 03:24:20','Magento CE 1.6.2.0-stable Now Available','We are excited to announce the availability of Magento CE Version 1.6.2.0 Stable for download and upgrade.','http://www.magentocommerce.com/blog/comments/magento-ce-version-1620-stable-now-available/',0,0),(67,4,'2012-03-03 05:54:12','Magento Preview Version CE 1.7.0.0-beta1 is now available','We are happy to announce the availability of Magento Preview Version CE 1.7.0.0-beta1 for download.\nAs this is a preview version it is NOT recommended in any way to be used in a production environment.','http://www.magentocommerce.com/blog/comments/magento-preview-version-ce-1700-beta1-now-available/',0,0),(68,4,'2012-04-23 18:02:40','Magento Community Preview Version CE 1.7.0.0-RC1 has been released!','Learn more about the exciting new features and updates in this release and how you can take it for a test drive. As this is a preview version, we need to stress that it\'s likely unstable and that we DON\'T recommend that you use it in any production environment just yet.','http://www.magentocommerce.com/blog/comments/magento-preview-version-ce-1700-rc1-now-available/',0,0),(69,4,'2012-05-11 13:46:54','Magento Community 1.7 and Magento Enterprise 1.12 now available!','Learn more about the exciting new features and updates in these releases.','http://www.magentocommerce.com/blog/comments/magento-enterprise-112-and-community-17-now-available/',0,0),(70,4,'2012-06-20 22:54:07','Magento Community Edition 1.7.0.1 now available! ','We have just released an updated version of Magento Community Edition, version 1.7.0.1. This update delivers new, minor functionality and fixes for some potential security vulnerabilities.','http://www.magentocommerce.com/blog/comments/magento-community-edition-1701-released/',0,0),(71,4,'2012-07-05 23:21:43','Important Security Update - Zend Platform Vulnerability','We have recently learned of a serious vulnerability in the Zend platform on which Magento is built. Learn more and access a patch that addresses this issue. ','http://www.magentocommerce.com/blog/comments/important-security-update-zend-platform-vulnerability/',0,0),(72,4,'2012-11-20 01:27:42','Wrap up more holiday sales with financing','Give your customers up to 6 months financing. You get paid right away with Bill Me Later, a PayPal service. It’s a great way to extend financing in time for the holidays. Learn More.','http://www.magentocommerce.com/paypal/billmelater?utm_source=CEMessaging&utm_medium=copy&utm_content=sixmonths&utm_campaign=BML',0,0),(73,4,'2012-12-07 16:22:30','Increase Your Sales With PayPal','Magento merchants using PayPal Express Checkout can help increase their sales on average 18%. It is one simple thing you can do right now to help boost your sales. Learn more.','http://www.magentocommerce.com/add-paypal?utm_source=CEModule&utm_medium=copy&utm_content=18&utm_campaign=choosepaypal',0,0),(74,4,'2013-01-16 03:02:07','Imagine 2013 Registration is Now Open!','Join 1500 merchants, partners, developers and enthusiasts from 35+ countries around the world for Magento’s premier global conference! Collaborate, learn, network and get inspired by the future of eCommerce. Tickets will sell out fast! April 8th – 10th in Las Vegas.','https://registration.imagineecommerce.com/',0,0),(75,4,'2013-02-12 22:53:42','Get More eCommerce Power with Magento Enterprise','Limited time offer: Get a free, customized evaluation of your Community Edition site from a Magento Solution Partner. This evaluation gives you a clear look at the numerous benefits you can achieve by upgrading to Enterprise Edition. ','http://www.magentocommerce.com/community-to-enterprise?utm_source=CEMM&utm_medium=copy&utm_campaign=CE2EE',0,0),(76,2,'2013-09-27 21:28:13','Magento Community Edition 1.8.0.0 - now available for download!','Get tax, security, performance, and many other improvements. \n\nLearn more at http://www.magentocommerce.com/blog/comments/magento-community-edition-one-eight-now-available/ ','http://www.magentocommerce.com/blog/comments/magento-community-edition-one-eight-now-available/',0,0),(77,4,'2013-12-11 20:35:06','Magento Community Edition 1.8.1.0 is here!','This new version offers significant tax calculation, product quality, and security enhancements. Be sure to carefully review the upgrade instructions before starting. More information is available at http://www.magentocommerce.com/blog/comments/magento-community-edition-1810-is-here/','http://www.magentocommerce.com/blog/comments/magento-community-edition-1810-is-here/',0,0),(78,4,'2013-12-13 04:24:39','Important Magento Community Edition Patch','A security patch is available for Magento Community Edition 1.4.0.0 through 1.7.0.2; the issue has been fixed in Magento Community Edition 1.8.0.0 and later. It resolves a vulnerability discovered through our quarterly penetration testing process and has not been reported by merchants. We encourage all merchants to apply the patch in their next regularly scheduled maintenance cycle. The patch is available at http://www.magentocommerce.com/download in the Magento Community Edition Patches section.','http://www.magentocommerce.com/download',0,0),(79,4,'2014-01-21 23:34:48','PHP 5.4 Patch Now Available','Magento is advancing its platform and making development more efficient by adding support for PHP 5.4. Patches are available for download at www.magentocommerce.com/download and you can learn more about this update in our blog post at http://www.magentocommerce.com/blog/comments/magento-now-supports-php-54 .','http://www.magentocommerce.com/blog/comments/magento-now-supports-php-54',0,0),(80,4,'2008-11-08 09:46:42','Reminder: Change Magento`s default phone numbers and callouts before site launch','Before launching your Magento store, please remember to change Magento`s default phone numbers that appear in email templates, callouts, templates, etc.','',0,0),(81,4,'2008-11-08 09:46:42','Reminder: Change Magento`s default phone numbers and callouts before site launch','Before launching your Magento store, please remember to change Magento`s default phone numbers that appear in email templates, callouts, templates, etc.','',0,0),(82,4,'2008-11-08 09:46:42','Reminder: Change Magento`s default phone numbers and callouts before site launch','Before launching your Magento store, please remember to change Magento`s default phone numbers that appear in email templates, callouts, templates, etc.','',0,0),(83,4,'2008-11-08 09:46:42','Reminder: Change Magento`s default phone numbers and callouts before site launch','Before launching your Magento store, please remember to change Magento`s default phone numbers that appear in email templates, callouts, templates, etc.','',0,0),(84,4,'2008-11-08 09:46:42','Reminder: Change Magento`s default phone numbers and callouts before site launch','Before launching your Magento store, please remember to change Magento`s default phone numbers that appear in email templates, callouts, templates, etc.','',0,0),(85,4,'2008-11-08 09:46:42','Reminder: Change Magento`s default phone numbers and callouts before site launch','Before launching your Magento store, please remember to change Magento`s default phone numbers that appear in email templates, callouts, templates, etc.','',0,0),(86,4,'2008-11-08 09:46:42','Reminder: Change Magento`s default phone numbers and callouts before site launch','Before launching your Magento store, please remember to change Magento`s default phone numbers that appear in email templates, callouts, templates, etc.','',0,0),(87,4,'2008-11-08 09:46:42','Reminder: Change Magento`s default phone numbers and callouts before site launch','Before launching your Magento store, please remember to change Magento`s default phone numbers that appear in email templates, callouts, templates, etc.','',0,0),(88,4,'2008-11-08 09:46:42','Reminder: Change Magento`s default phone numbers and callouts before site launch','Before launching your Magento store, please remember to change Magento`s default phone numbers that appear in email templates, callouts, templates, etc.','',0,0),(89,4,'2008-11-08 09:46:42','Reminder: Change Magento`s default phone numbers and callouts before site launch','Before launching your Magento store, please remember to change Magento`s default phone numbers that appear in email templates, callouts, templates, etc.','',0,0),(90,4,'2008-11-08 09:46:42','Reminder: Change Magento`s default phone numbers and callouts before site launch','Before launching your Magento store, please remember to change Magento`s default phone numbers that appear in email templates, callouts, templates, etc.','',0,0),(91,4,'2008-11-08 09:46:42','Reminder: Change Magento`s default phone numbers and callouts before site launch','Before launching your Magento store, please remember to change Magento`s default phone numbers that appear in email templates, callouts, templates, etc.','',0,0),(92,4,'2014-02-03 21:14:54','Imagine 2014 Registration is Open','Register today to join us May 12-14 at the Hard Rock Hotel in Las Vegas for Imagine 2014, Magento\'s annual conference.\n\nEarly-bird registration pricing ends February 17 so don’t delay!\n\nhttp://www.imagineecommerce.com?utm_source=magento&utm_medium=cerss&utm_campaign=registrationopen\n\n','http://www.imagineecommerce.com?utm_source=magento&utm_medium=cerss&utm_campaign=registrationopen',0,0),(93,4,'2008-11-08 09:46:42','Reminder: Change Magento`s default phone numbers and callouts before site launch','Before launching your Magento store, please remember to change Magento`s default phone numbers that appear in email templates, callouts, templates, etc.','',0,0),(94,4,'2008-11-08 09:46:42','Reminder: Change Magento`s default phone numbers and callouts before site launch','Before launching your Magento store, please remember to change Magento`s default phone numbers that appear in email templates, callouts, templates, etc.','',0,0),(95,4,'2014-02-20 22:51:46','Discover Card Validation Patch Available','A patch that resolves an issue with validating Discover credit cards is now available for download at http://www.magentocommerce.com/download. More information on the patch is available in the Magento Knowledge Base at http://www.magentocommerce.com/knowledge-base/entry/discover-card-validation','http://www.magentocommerce.com/knowledge-base/entry/discover-card-validation ',0,0),(96,4,'2008-11-08 09:46:42','Reminder: Change Magento`s default phone numbers and callouts before site launch','Before launching your Magento store, please remember to change Magento`s default phone numbers that appear in email templates, callouts, templates, etc.','',0,0),(97,4,'2008-11-08 09:46:42','Reminder: Change Magento`s default phone numbers and callouts before site launch','Before launching your Magento store, please remember to change Magento`s default phone numbers that appear in email templates, callouts, templates, etc.','',0,0),(98,4,'2008-11-08 09:46:42','Reminder: Change Magento`s default phone numbers and callouts before site launch','Before launching your Magento store, please remember to change Magento`s default phone numbers that appear in email templates, callouts, templates, etc.','',0,0),(99,4,'2014-03-04 20:12:26','Learn How to Quickly Increase Sales on Your Site','Adding the PayPal Express Checkout button to your checkout page can help increase sales 18% on average. It’s fast and easy and you can do it right now to boost sales. Express Checkout is already seamlessly integrated into Community Edition.','http://magento.com/paypal/CE_Express_Checkout_NA?utm_source=messagemodule&utm_medium=message&utm_campaign=Ceexpresscheckout',0,0);

--
-- Table structure for table `api2_acl_attribute`
--

CREATE TABLE `api2_acl_attribute` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `user_type` varchar(20) NOT NULL COMMENT 'Type of user',
  `resource_id` varchar(255) NOT NULL COMMENT 'Resource ID',
  `operation` varchar(20) NOT NULL COMMENT 'Operation',
  `allowed_attributes` text COMMENT 'Allowed attributes',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `UNQ_API2_ACL_ATTRIBUTE_USER_TYPE_RESOURCE_ID_OPERATION` (`user_type`,`resource_id`,`operation`),
  KEY `IDX_API2_ACL_ATTRIBUTE_USER_TYPE` (`user_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Api2 Filter ACL Attributes';

--
-- Dumping data for table `api2_acl_attribute`
--


--
-- Table structure for table `api2_acl_role`
--

CREATE TABLE `api2_acl_role` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
  `role_name` varchar(255) NOT NULL COMMENT 'Name of role',
  PRIMARY KEY (`entity_id`),
  KEY `IDX_API2_ACL_ROLE_CREATED_AT` (`created_at`),
  KEY `IDX_API2_ACL_ROLE_UPDATED_AT` (`updated_at`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='Api2 Global ACL Roles';

--
-- Dumping data for table `api2_acl_role`
--

INSERT INTO `api2_acl_role` VALUES (1,'2014-01-29 17:32:43',NULL,'Guest'),(2,'2014-01-29 17:32:43',NULL,'Customer');

--
-- Table structure for table `api2_acl_rule`
--

CREATE TABLE `api2_acl_rule` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `role_id` int(10) unsigned NOT NULL COMMENT 'Role ID',
  `resource_id` varchar(255) NOT NULL COMMENT 'Resource ID',
  `privilege` varchar(20) DEFAULT NULL COMMENT 'ACL Privilege',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `UNQ_API2_ACL_RULE_ROLE_ID_RESOURCE_ID_PRIVILEGE` (`role_id`,`resource_id`,`privilege`),
  CONSTRAINT `FK_API2_ACL_RULE_ROLE_ID_API2_ACL_ROLE_ENTITY_ID` FOREIGN KEY (`role_id`) REFERENCES `api2_acl_role` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Api2 Global ACL Rules';

--
-- Dumping data for table `api2_acl_rule`
--


--
-- Table structure for table `api2_acl_user`
--

CREATE TABLE `api2_acl_user` (
  `admin_id` int(10) unsigned NOT NULL COMMENT 'Admin ID',
  `role_id` int(10) unsigned NOT NULL COMMENT 'Role ID',
  UNIQUE KEY `UNQ_API2_ACL_USER_ADMIN_ID` (`admin_id`),
  KEY `FK_API2_ACL_USER_ROLE_ID_API2_ACL_ROLE_ENTITY_ID` (`role_id`),
  CONSTRAINT `FK_API2_ACL_USER_ADMIN_ID_ADMIN_USER_USER_ID` FOREIGN KEY (`admin_id`) REFERENCES `admin_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_API2_ACL_USER_ROLE_ID_API2_ACL_ROLE_ENTITY_ID` FOREIGN KEY (`role_id`) REFERENCES `api2_acl_role` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Api2 Global ACL Users';

--
-- Dumping data for table `api2_acl_user`
--


--
-- Table structure for table `api_assert`
--

CREATE TABLE `api_assert` (
  `assert_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Assert id',
  `assert_type` varchar(20) DEFAULT NULL COMMENT 'Assert type',
  `assert_data` text COMMENT 'Assert additional data',
  PRIMARY KEY (`assert_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Api ACL Asserts';

--
-- Dumping data for table `api_assert`
--


--
-- Table structure for table `api_role`
--

CREATE TABLE `api_role` (
  `role_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Role id',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Parent role id',
  `tree_level` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Role level in tree',
  `sort_order` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Sort order to display on admin area',
  `role_type` varchar(1) NOT NULL DEFAULT '0' COMMENT 'Role type',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'User id',
  `role_name` varchar(50) DEFAULT NULL COMMENT 'Role name',
  PRIMARY KEY (`role_id`),
  KEY `IDX_API_ROLE_PARENT_ID_SORT_ORDER` (`parent_id`,`sort_order`),
  KEY `IDX_API_ROLE_TREE_LEVEL` (`tree_level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Api ACL Roles';

--
-- Dumping data for table `api_role`
--


--
-- Table structure for table `api_rule`
--

CREATE TABLE `api_rule` (
  `rule_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Api rule Id',
  `role_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Api role Id',
  `resource_id` varchar(255) DEFAULT NULL COMMENT 'Module code',
  `api_privileges` varchar(20) DEFAULT NULL COMMENT 'Privileges',
  `assert_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Assert id',
  `role_type` varchar(1) DEFAULT NULL COMMENT 'Role type',
  `api_permission` varchar(10) DEFAULT NULL COMMENT 'Permission',
  PRIMARY KEY (`rule_id`),
  KEY `IDX_API_RULE_RESOURCE_ID_ROLE_ID` (`resource_id`,`role_id`),
  KEY `IDX_API_RULE_ROLE_ID_RESOURCE_ID` (`role_id`,`resource_id`),
  CONSTRAINT `FK_API_RULE_ROLE_ID_API_ROLE_ROLE_ID` FOREIGN KEY (`role_id`) REFERENCES `api_role` (`role_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Api ACL Rules';

--
-- Dumping data for table `api_rule`
--


--
-- Table structure for table `api_session`
--

CREATE TABLE `api_session` (
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'User id',
  `logdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Login date',
  `sessid` varchar(40) DEFAULT NULL COMMENT 'Sessioin id',
  KEY `IDX_API_SESSION_USER_ID` (`user_id`),
  KEY `IDX_API_SESSION_SESSID` (`sessid`),
  CONSTRAINT `FK_API_SESSION_USER_ID_API_USER_USER_ID` FOREIGN KEY (`user_id`) REFERENCES `api_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Api Sessions';

--
-- Dumping data for table `api_session`
--


--
-- Table structure for table `api_user`
--

CREATE TABLE `api_user` (
  `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'User id',
  `firstname` varchar(32) DEFAULT NULL COMMENT 'First name',
  `lastname` varchar(32) DEFAULT NULL COMMENT 'Last name',
  `email` varchar(128) DEFAULT NULL COMMENT 'Email',
  `username` varchar(40) DEFAULT NULL COMMENT 'Nickname',
  `api_key` varchar(100) DEFAULT NULL COMMENT 'Api key',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'User record create date',
  `modified` timestamp NULL DEFAULT NULL COMMENT 'User record modify date',
  `lognum` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Quantity of log ins',
  `reload_acl_flag` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Refresh ACL flag',
  `is_active` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Account status',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Api Users';

--
-- Dumping data for table `api_user`
--


--
-- Table structure for table `captcha_log`
--

CREATE TABLE `captcha_log` (
  `type` varchar(32) NOT NULL COMMENT 'Type',
  `value` varchar(32) NOT NULL COMMENT 'Value',
  `count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Count',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time',
  PRIMARY KEY (`type`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Count Login Attempts';

--
-- Dumping data for table `captcha_log`
--


--
-- Table structure for table `catalog_category_anc_categs_index_idx`
--

CREATE TABLE `catalog_category_anc_categs_index_idx` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category ID',
  `path` varchar(255) NOT NULL COMMENT 'Path',
  KEY `IDX_CATALOG_CATEGORY_ANC_CATEGS_INDEX_IDX_CATEGORY_ID` (`category_id`),
  KEY `IDX_CATALOG_CATEGORY_ANC_CATEGS_INDEX_IDX_PATH_CATEGORY_ID` (`path`,`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Anchor Indexer Index Table';

--
-- Dumping data for table `catalog_category_anc_categs_index_idx`
--


--
-- Table structure for table `catalog_category_anc_categs_index_tmp`
--

CREATE TABLE `catalog_category_anc_categs_index_tmp` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category ID',
  `path` varchar(255) NOT NULL COMMENT 'Path',
  KEY `IDX_CATALOG_CATEGORY_ANC_CATEGS_INDEX_TMP_CATEGORY_ID` (`category_id`),
  KEY `IDX_CATALOG_CATEGORY_ANC_CATEGS_INDEX_TMP_PATH_CATEGORY_ID` (`path`,`category_id`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8 COMMENT='Catalog Category Anchor Indexer Temp Table';

--
-- Dumping data for table `catalog_category_anc_categs_index_tmp`
--


--
-- Table structure for table `catalog_category_anc_products_index_idx`
--

CREATE TABLE `catalog_category_anc_products_index_idx` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `position` int(10) unsigned DEFAULT NULL COMMENT 'Position',
  KEY `IDX_CAT_CTGR_ANC_PRDS_IDX_IDX_CTGR_ID_PRD_ID_POSITION` (`category_id`,`product_id`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Anchor Product Indexer Index Table';

--
-- Dumping data for table `catalog_category_anc_products_index_idx`
--


--
-- Table structure for table `catalog_category_anc_products_index_tmp`
--

CREATE TABLE `catalog_category_anc_products_index_tmp` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `position` int(10) unsigned DEFAULT NULL COMMENT 'Position',
  KEY `IDX_CAT_CTGR_ANC_PRDS_IDX_TMP_CTGR_ID_PRD_ID_POSITION` (`category_id`,`product_id`,`position`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8 COMMENT='Catalog Category Anchor Product Indexer Temp Table';

--
-- Dumping data for table `catalog_category_anc_products_index_tmp`
--


--
-- Table structure for table `catalog_category_entity`
--

CREATE TABLE `catalog_category_entity` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type ID',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attriute Set ID',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Parent Category ID',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time',
  `path` varchar(255) NOT NULL COMMENT 'Tree Path',
  `position` int(11) NOT NULL DEFAULT '0' COMMENT 'Position',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT 'Tree Level',
  `children_count` int(11) NOT NULL DEFAULT '0' COMMENT 'Child Count',
  PRIMARY KEY (`entity_id`),
  KEY `IDX_CATALOG_CATEGORY_ENTITY_LEVEL` (`level`),
  KEY `IDX_CATALOG_CATEGORY_ENTITY_PATH_ENTITY_ID` (`path`,`entity_id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='Catalog Category Table';

--
-- Dumping data for table `catalog_category_entity`
--

INSERT INTO `catalog_category_entity` VALUES (1,9,12,0,'2007-07-20 22:46:08','2007-08-07 13:50:15','1',1,0,28),(3,9,12,1,'2007-08-22 19:54:41','2007-12-05 09:38:59','1/3',3,1,27),(4,9,12,18,'2007-08-22 19:55:34','2008-08-08 04:56:48','1/3/18/4',4,3,0),(5,9,12,18,'2007-08-22 20:21:29','2008-08-08 03:55:38','1/3/18/5',5,3,2),(8,9,12,13,'2007-08-22 22:10:30','2008-08-08 03:51:26','1/3/13/8',8,3,0),(10,9,12,3,'2007-08-23 15:45:22','2014-03-10 01:00:24','1/3/10',10,2,2),(12,9,12,13,'2007-08-24 16:34:30','2008-08-08 03:54:48','1/3/13/12',12,3,2),(13,9,12,3,'2007-08-24 17:31:01','2014-01-31 20:50:23','1/3/13',13,2,13),(15,9,12,13,'2007-08-24 17:33:17','2008-07-25 05:53:39','1/3/13/15',15,3,8),(16,9,12,5,'2007-08-24 19:41:52','2008-08-08 03:56:01','1/3/18/5/16',16,4,0),(17,9,12,5,'2007-08-24 19:43:07','2008-08-08 03:56:28','1/3/18/5/17',17,4,0),(18,9,12,3,'2007-08-24 19:44:31','2014-03-10 00:59:48','1/3/18',18,2,6),(19,9,12,18,'2007-08-25 00:05:28','2008-08-08 03:57:03','1/3/18/19',19,3,0),(20,9,12,3,'2007-08-25 17:14:09','2008-08-08 03:58:57','1/3/20',20,2,0),(22,9,12,10,'2007-08-26 18:49:39','2008-08-08 04:01:45','1/3/10/22',22,3,0),(23,9,12,10,'2007-08-27 14:35:27','2008-08-08 03:49:18','1/3/10/23',23,3,0),(24,9,12,18,'2007-08-28 22:32:41','2007-08-30 03:20:36','1/3/18/24',24,3,0),(25,9,12,12,'2007-08-29 23:49:52','2008-08-08 03:46:35','1/3/13/12/25',25,4,0),(26,9,12,12,'2007-08-30 00:37:22','2008-08-08 03:47:02','1/3/13/12/26',26,4,0),(27,9,12,15,'2008-07-25 04:36:22','2008-08-08 03:48:15','1/3/13/15/27',1,4,0),(28,9,12,15,'2008-07-25 04:39:10','2008-08-08 17:02:59','1/3/13/15/28',2,4,0),(29,9,12,13,'2008-07-25 04:39:54','2008-07-25 04:39:54','1/3/13/15/29',3,4,0),(30,9,12,13,'2008-07-25 04:41:11','2008-07-25 04:41:11','1/3/13/15/30',4,4,0),(31,9,12,13,'2008-07-25 04:41:56','2008-07-25 04:41:56','1/3/13/15/31',5,4,0),(32,9,12,13,'2008-07-25 04:42:57','2008-07-25 04:42:57','1/3/13/15/32',6,4,0),(33,9,12,13,'2008-07-25 04:43:25','2008-07-25 04:43:25','1/3/13/15/33',7,4,0),(34,9,12,13,'2008-07-25 04:44:17','2008-07-25 04:44:17','1/3/13/15/34',8,4,0),(35,9,12,3,'2014-01-31 20:50:02','2014-01-31 20:52:07','1/3/35',21,2,0),(36,9,12,3,'2014-01-31 20:53:01','2014-01-31 20:53:01','1/3/36',22,2,0);

--
-- Table structure for table `catalog_category_entity_datetime`
--

CREATE TABLE `catalog_category_entity_datetime` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `entity_type_id` smallint(5) unsigned NOT NULL COMMENT 'Entity Type ID',
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `value` datetime DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `UNQ_CAT_CTGR_ENTT_DTIME_ENTT_TYPE_ID_ENTT_ID_ATTR_ID_STORE_ID` (`entity_type_id`,`entity_id`,`attribute_id`,`store_id`),
  KEY `IDX_CATALOG_CATEGORY_ENTITY_DATETIME_ENTITY_ID` (`entity_id`),
  KEY `IDX_CATALOG_CATEGORY_ENTITY_DATETIME_ATTRIBUTE_ID` (`attribute_id`),
  KEY `IDX_CATALOG_CATEGORY_ENTITY_DATETIME_STORE_ID` (`store_id`),
  CONSTRAINT `FK_CATALOG_CATEGORY_ENTITY_DATETIME_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_CTGR_ENTT_DTIME_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_CTGR_ENTT_DTIME_ENTT_ID_CAT_CTGR_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='Catalog Category Datetime Attribute Backend Table';

--
-- Dumping data for table `catalog_category_entity_datetime`
--

INSERT INTO `catalog_category_entity_datetime` VALUES (1,9,565,0,35,NULL),(2,9,566,0,35,NULL),(3,9,565,0,13,NULL),(4,9,566,0,13,NULL),(5,9,565,0,36,NULL),(6,9,566,0,36,NULL);

--
-- Table structure for table `catalog_category_entity_decimal`
--

CREATE TABLE `catalog_category_entity_decimal` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `entity_type_id` smallint(5) unsigned NOT NULL COMMENT 'Entity Type ID',
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `value` decimal(12,4) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `UNQ_CAT_CTGR_ENTT_DEC_ENTT_TYPE_ID_ENTT_ID_ATTR_ID_STORE_ID` (`entity_type_id`,`entity_id`,`attribute_id`,`store_id`),
  KEY `IDX_CATALOG_CATEGORY_ENTITY_DECIMAL_ENTITY_ID` (`entity_id`),
  KEY `IDX_CATALOG_CATEGORY_ENTITY_DECIMAL_ATTRIBUTE_ID` (`attribute_id`),
  KEY `IDX_CATALOG_CATEGORY_ENTITY_DECIMAL_STORE_ID` (`store_id`),
  CONSTRAINT `FK_CATALOG_CATEGORY_ENTITY_DECIMAL_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_CTGR_ENTT_DEC_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_CTGR_ENTT_DEC_ENTT_ID_CAT_CTGR_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='Catalog Category Decimal Attribute Backend Table';

--
-- Dumping data for table `catalog_category_entity_decimal`
--

INSERT INTO `catalog_category_entity_decimal` VALUES (1,9,939,0,35,NULL),(2,9,939,0,10,NULL),(3,9,939,0,13,NULL),(4,9,939,0,18,NULL),(5,9,939,0,36,NULL);

--
-- Table structure for table `catalog_category_entity_int`
--

CREATE TABLE `catalog_category_entity_int` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `entity_type_id` smallint(5) unsigned NOT NULL COMMENT 'Entity Type ID',
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `value` int(11) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `UNQ_CAT_CTGR_ENTT_INT_ENTT_TYPE_ID_ENTT_ID_ATTR_ID_STORE_ID` (`entity_type_id`,`entity_id`,`attribute_id`,`store_id`),
  KEY `IDX_CATALOG_CATEGORY_ENTITY_INT_ENTITY_ID` (`entity_id`),
  KEY `IDX_CATALOG_CATEGORY_ENTITY_INT_ATTRIBUTE_ID` (`attribute_id`),
  KEY `IDX_CATALOG_CATEGORY_ENTITY_INT_STORE_ID` (`store_id`),
  CONSTRAINT `FK_CATALOG_CATEGORY_ENTITY_INT_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_CTGR_ENTT_INT_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_CTGR_ENTT_INT_ENTT_ID_CAT_CTGR_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=187 DEFAULT CHARSET=utf8 COMMENT='Catalog Category Integer Attribute Backend Table';

--
-- Dumping data for table `catalog_category_entity_int`
--

INSERT INTO `catalog_category_entity_int` VALUES (1,9,120,0,13,1),(2,9,120,0,5,1),(3,9,120,0,18,1),(4,9,120,0,16,1),(5,9,120,0,17,1),(6,9,120,0,4,1),(7,9,120,0,19,0),(8,9,120,0,22,0),(9,9,120,0,10,1),(10,9,120,0,15,1),(11,9,119,0,1,1),(12,9,119,0,4,1),(13,9,119,0,8,1),(14,9,119,0,12,1),(15,9,119,0,15,1),(16,9,119,0,17,1),(17,9,120,0,23,0),(18,9,117,0,13,3),(19,9,119,0,23,1),(20,9,120,0,12,1),(21,9,117,0,8,4),(22,9,120,0,8,1),(23,9,120,0,26,1),(25,9,119,0,3,1),(26,9,120,0,20,0),(27,9,119,0,5,1),(28,9,119,0,10,0),(29,9,119,0,13,0),(30,9,119,0,16,1),(31,9,119,0,18,0),(32,9,119,0,19,1),(33,9,119,0,20,0),(34,9,119,0,22,1),(35,9,119,0,24,0),(36,9,119,0,25,1),(37,9,119,0,26,1),(39,9,119,0,27,1),(40,9,120,0,27,0),(42,9,119,0,28,1),(43,9,120,0,28,1),(45,9,119,0,29,1),(46,9,120,0,29,1),(48,9,119,0,30,1),(49,9,120,0,30,1),(51,9,119,0,31,1),(52,9,120,0,31,1),(54,9,119,0,32,1),(55,9,120,0,32,1),(57,9,119,0,33,1),(58,9,120,0,33,1),(60,9,119,0,34,1),(61,9,120,0,34,1),(67,9,120,0,25,0),(77,9,934,0,1,1),(78,9,934,0,3,1),(79,9,934,0,10,0),(80,9,934,0,13,0),(81,9,934,0,18,0),(82,9,934,0,20,1),(83,9,934,0,4,1),(84,9,934,0,5,1),(85,9,934,0,8,1),(86,9,934,0,12,1),(87,9,934,0,15,1),(88,9,934,0,19,1),(89,9,934,0,22,1),(90,9,934,0,23,1),(91,9,934,0,24,1),(92,9,934,0,16,1),(93,9,934,0,17,1),(94,9,934,0,25,1),(95,9,934,0,26,1),(96,9,934,0,27,1),(97,9,934,0,28,1),(98,9,934,0,29,1),(99,9,934,0,30,1),(100,9,934,0,31,1),(101,9,934,0,32,1),(102,9,934,0,33,1),(103,9,934,0,34,1),(108,9,937,0,4,1),(109,9,938,0,4,1),(110,9,937,0,5,1),(111,9,938,0,5,1),(112,9,937,0,8,1),(113,9,938,0,8,1),(114,9,937,0,10,1),(115,9,938,0,10,1),(116,9,937,0,12,1),(117,9,938,0,12,1),(118,9,937,0,15,1),(119,9,938,0,15,1),(120,9,937,0,16,1),(121,9,938,0,16,1),(122,9,937,0,17,1),(123,9,938,0,17,1),(124,9,937,0,18,1),(125,9,938,0,18,1),(126,9,937,0,19,1),(127,9,938,0,19,1),(128,9,937,0,20,1),(129,9,938,0,20,1),(130,9,937,0,22,1),(131,9,938,0,22,1),(132,9,937,0,23,1),(133,9,938,0,23,1),(134,9,937,0,25,1),(135,9,938,0,25,1),(136,9,937,0,26,1),(137,9,938,0,26,1),(138,9,937,0,27,1),(139,9,938,0,27,1),(140,9,937,0,28,1),(141,9,938,0,28,1),(142,9,937,0,29,1),(143,9,938,0,29,1),(144,9,937,0,30,1),(145,9,938,0,30,1),(146,9,937,0,31,1),(147,9,938,0,31,1),(148,9,937,0,32,1),(149,9,938,0,32,1),(150,9,937,0,33,1),(151,9,938,0,33,1),(152,9,937,0,34,1),(153,9,938,0,34,1),(171,9,119,0,35,1),(172,9,934,0,35,1),(173,9,117,0,35,NULL),(174,9,120,0,35,0),(175,9,937,0,35,0),(176,9,938,0,35,0),(177,9,117,0,10,NULL),(178,9,937,0,13,0),(179,9,938,0,13,0),(180,9,117,0,18,NULL),(181,9,119,0,36,1),(182,9,934,0,36,1),(183,9,117,0,36,NULL),(184,9,120,0,36,0),(185,9,937,0,36,0),(186,9,938,0,36,0);

--
-- Table structure for table `catalog_category_entity_text`
--

CREATE TABLE `catalog_category_entity_text` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `entity_type_id` smallint(5) unsigned NOT NULL COMMENT 'Entity Type ID',
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `value` text COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `UNQ_CAT_CTGR_ENTT_TEXT_ENTT_TYPE_ID_ENTT_ID_ATTR_ID_STORE_ID` (`entity_type_id`,`entity_id`,`attribute_id`,`store_id`),
  KEY `IDX_CATALOG_CATEGORY_ENTITY_TEXT_ENTITY_ID` (`entity_id`),
  KEY `IDX_CATALOG_CATEGORY_ENTITY_TEXT_ATTRIBUTE_ID` (`attribute_id`),
  KEY `IDX_CATALOG_CATEGORY_ENTITY_TEXT_STORE_ID` (`store_id`),
  CONSTRAINT `FK_CATALOG_CATEGORY_ENTITY_TEXT_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_CTGR_ENTT_TEXT_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_CTGR_ENTT_TEXT_ENTT_ID_CAT_CTGR_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=164 DEFAULT CHARSET=utf8 COMMENT='Catalog Category Text Attribute Backend Table';

--
-- Dumping data for table `catalog_category_entity_text`
--

INSERT INTO `catalog_category_entity_text` VALUES (1,9,121,0,3,'3,18,4,5,16,17,19,24,10,22,23,13,8,12,26,25,15,20'),(2,9,121,0,4,'4'),(3,9,122,0,4,'4,18'),(4,9,123,0,3,'18,10,13,20'),(5,9,121,0,5,'5,16,17'),(6,9,122,0,5,'5,18'),(7,9,121,0,8,'8'),(8,9,122,0,8,'8,13'),(9,9,121,0,10,'10,22,23'),(10,9,122,0,10,'10'),(11,9,121,0,12,'12,26,25'),(12,9,122,0,12,'12,13'),(13,9,121,0,13,'13,8,12,26,25,15'),(14,9,122,0,13,'13'),(15,9,123,0,13,'8,12,15'),(16,9,121,0,15,'15'),(17,9,122,0,15,'15,13'),(18,9,123,0,5,'16,17'),(19,9,122,0,18,'18'),(20,9,123,0,18,'4,5,19,24'),(21,9,122,0,19,'19,18'),(22,9,122,0,20,'20'),(23,9,121,0,22,'22'),(24,9,122,0,22,'22,10'),(25,9,123,0,10,'22,23'),(26,9,121,0,23,'23'),(27,9,122,0,23,'23,10'),(28,9,123,0,22,''),(29,9,123,0,16,''),(30,9,123,0,4,''),(31,9,123,0,23,''),(32,9,123,0,19,''),(33,9,123,0,15,''),(34,9,121,0,24,'24'),(35,9,122,0,24,'24,18'),(36,9,123,0,24,''),(37,9,123,0,8,''),(38,9,112,0,25,'Random accessories for different electronic items'),(39,9,115,0,25,'electric, accesories, gadgets'),(40,9,122,0,25,'25,12,13'),(41,9,123,0,25,''),(42,9,121,0,26,'26'),(43,9,122,0,26,'26,12,13'),(44,9,123,0,26,''),(45,9,123,0,17,''),(46,9,122,0,3,''),(47,9,112,0,15,''),(48,9,115,0,15,''),(49,9,116,0,15,''),(50,9,530,0,15,''),(51,9,112,0,27,''),(52,9,115,0,27,''),(53,9,116,0,27,''),(54,9,530,0,27,''),(55,9,112,0,28,''),(56,9,115,0,28,''),(57,9,116,0,28,''),(58,9,530,0,28,''),(59,9,112,0,29,''),(60,9,115,0,29,''),(61,9,116,0,29,''),(62,9,530,0,29,''),(63,9,112,0,30,''),(64,9,115,0,30,''),(65,9,116,0,30,''),(66,9,112,0,31,''),(67,9,116,0,31,''),(68,9,530,0,31,''),(69,9,112,0,32,''),(70,9,115,0,32,''),(71,9,116,0,32,''),(72,9,530,0,32,''),(73,9,112,0,33,''),(74,9,115,0,33,''),(75,9,116,0,33,''),(76,9,530,0,33,''),(77,9,112,0,34,''),(78,9,115,0,34,''),(79,9,116,0,34,''),(80,9,112,0,22,''),(81,9,116,0,22,''),(82,9,530,0,22,''),(83,9,112,0,23,''),(84,9,115,0,23,''),(85,9,116,0,23,''),(86,9,530,0,23,''),(87,9,112,0,10,''),(88,9,115,0,10,''),(89,9,116,0,10,''),(90,9,530,0,10,''),(91,9,112,0,12,''),(92,9,115,0,12,''),(93,9,116,0,12,''),(94,9,530,0,12,''),(95,9,116,0,25,''),(96,9,112,0,26,''),(97,9,116,0,26,''),(98,9,112,0,8,''),(99,9,115,0,8,''),(100,9,116,0,8,''),(101,9,530,0,8,''),(102,9,112,0,18,''),(103,9,115,0,18,''),(104,9,116,0,18,''),(105,9,530,0,18,''),(106,9,112,0,4,''),(107,9,115,0,4,''),(108,9,116,0,4,''),(109,9,530,0,4,''),(110,9,112,0,5,''),(111,9,115,0,5,''),(112,9,116,0,5,''),(113,9,530,0,5,''),(114,9,112,0,16,''),(115,9,115,0,16,''),(116,9,116,0,16,''),(117,9,530,0,16,''),(118,9,112,0,17,''),(119,9,115,0,17,''),(120,9,116,0,17,''),(121,9,530,0,17,''),(122,9,112,0,19,''),(123,9,115,0,19,''),(124,9,530,0,19,''),(125,9,115,0,20,''),(126,9,530,0,20,''),(127,9,121,0,16,'16'),(128,9,122,0,16,'16,5,18'),(129,9,121,0,17,'17'),(130,9,122,0,17,'17,5,18'),(131,9,121,0,18,'18,4,5,16,17,19,24'),(132,9,121,0,19,'19'),(133,9,121,0,20,'20'),(134,9,123,0,20,''),(135,9,121,0,25,'25'),(136,9,123,0,12,'26,25'),(137,9,530,0,30,''),(138,9,115,0,31,''),(139,9,530,0,34,''),(140,9,115,0,22,''),(141,9,530,0,25,''),(142,9,115,0,26,''),(143,9,530,0,26,''),(144,9,116,0,19,''),(145,9,112,0,20,''),(146,9,116,0,20,''),(147,9,112,0,35,NULL),(148,9,115,0,35,NULL),(149,9,116,0,35,NULL),(150,9,530,0,35,NULL),(151,9,929,0,35,NULL),(152,9,929,0,10,NULL),(153,9,112,0,13,NULL),(154,9,115,0,13,NULL),(155,9,116,0,13,NULL),(156,9,530,0,13,NULL),(157,9,929,0,13,NULL),(158,9,929,0,18,NULL),(159,9,112,0,36,NULL),(160,9,115,0,36,NULL),(161,9,116,0,36,NULL),(162,9,530,0,36,NULL),(163,9,929,0,36,NULL);

--
-- Table structure for table `catalog_category_entity_varchar`
--

CREATE TABLE `catalog_category_entity_varchar` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `entity_type_id` smallint(5) unsigned NOT NULL COMMENT 'Entity Type ID',
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `UNQ_CAT_CTGR_ENTT_VCHR_ENTT_TYPE_ID_ENTT_ID_ATTR_ID_STORE_ID` (`entity_type_id`,`entity_id`,`attribute_id`,`store_id`),
  KEY `IDX_CATALOG_CATEGORY_ENTITY_VARCHAR_ENTITY_ID` (`entity_id`),
  KEY `IDX_CATALOG_CATEGORY_ENTITY_VARCHAR_ATTRIBUTE_ID` (`attribute_id`),
  KEY `IDX_CATALOG_CATEGORY_ENTITY_VARCHAR_STORE_ID` (`store_id`),
  CONSTRAINT `FK_CATALOG_CATEGORY_ENTITY_VARCHAR_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_CTGR_ENTT_VCHR_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_CTGR_ENTT_VCHR_ENTT_ID_CAT_CTGR_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=223 DEFAULT CHARSET=utf8 COMMENT='Catalog Category Varchar Attribute Backend Table';

--
-- Dumping data for table `catalog_category_entity_varchar`
--

INSERT INTO `catalog_category_entity_varchar` VALUES (1,9,111,0,3,'Root Catalog'),(2,9,118,0,3,'PRODUCTS'),(3,9,479,0,3,'root-catalog'),(4,9,111,0,4,'Shirts'),(5,9,118,0,4,'PRODUCTS'),(6,9,479,0,4,'shirts'),(7,9,111,0,5,'Shoes'),(8,9,118,0,5,'PRODUCTS'),(9,9,479,0,5,'shoes'),(10,9,111,0,8,'Cell Phones'),(11,9,118,0,8,'PRODUCTS_AND_PAGE'),(12,9,479,0,8,'cell-phones'),(13,9,111,0,10,'Furniture'),(14,9,118,0,10,'PRODUCTS'),(15,9,479,0,10,'furniture'),(16,9,111,0,12,'Cameras'),(17,9,118,0,12,'PRODUCTS'),(18,9,479,0,12,'cameras'),(19,9,111,0,13,'Electronics'),(20,9,118,0,13,'PAGE'),(21,9,479,0,13,'electronics'),(22,9,111,0,15,'Computers'),(23,9,118,0,15,'PRODUCTS'),(24,9,479,0,15,'computers'),(25,9,111,0,16,'Mens'),(26,9,118,0,16,'PRODUCTS'),(27,9,479,0,16,'mens'),(28,9,111,0,17,'Womens'),(29,9,118,0,17,'PRODUCTS'),(30,9,479,0,17,'womens'),(31,9,111,0,18,'Apparel'),(32,9,118,0,18,'PRODUCTS'),(33,9,479,0,18,'apparel'),(34,9,111,0,19,'Hoodies'),(35,9,118,0,19,'PRODUCTS'),(36,9,479,0,19,'hoodies'),(37,9,113,0,4,'shirts.jpg'),(38,9,113,0,12,'camera.jpg'),(39,9,111,0,20,'Household Items'),(40,9,118,0,20,'PRODUCTS'),(41,9,479,0,20,'household-items'),(42,9,111,0,22,'Living Room'),(43,9,118,0,22,'PRODUCTS_AND_PAGE'),(44,9,118,0,23,'PRODUCTS'),(45,9,111,0,23,'Bedroom'),(46,9,113,0,5,'shoes.jpg'),(47,9,113,0,23,'bedroom.jpg'),(48,9,113,0,18,'apparel.jpg'),(49,9,113,0,10,'cybr.php.jpg'),(50,9,514,0,13,'one_column'),(51,9,514,0,8,''),(52,9,111,0,24,'Pants'),(53,9,118,0,24,'PRODUCTS'),(54,9,111,0,25,'Accessories'),(55,9,118,0,25,'PRODUCTS'),(56,9,111,0,26,'Digital Cameras'),(57,9,118,0,26,'PRODUCTS'),(58,9,533,0,18,'apparel.html'),(59,9,533,0,4,'apparel/shirts.html'),(60,9,533,0,5,'apparel/shoes.html'),(61,9,533,0,16,'apparel/shoes/mens.html'),(62,9,533,0,17,'apparel/shoes/womens.html'),(63,9,533,0,19,'apparel/hoodies.html'),(64,9,533,0,10,'furniture.html'),(65,9,533,0,13,'electronics.html'),(66,9,533,0,8,'electronics/cell-phones.html'),(67,9,533,0,12,'electronics/cameras.html'),(68,9,533,0,15,'electronics/computers.html'),(69,9,533,0,20,'household-items.html'),(70,9,479,0,22,'living-room'),(71,9,533,0,22,'furniture/living-room.html'),(72,9,479,0,23,'bedroom'),(73,9,533,0,23,'furniture/bedroom.html'),(74,9,479,0,25,'accessories'),(75,9,533,0,25,'electronics/cameras/accessories.html'),(76,9,479,0,26,'digital-cameras'),(77,9,533,0,26,'electronics/cameras/digital-cameras.html'),(78,9,479,0,24,'pants'),(79,9,533,0,24,'apparel/pants.html'),(80,9,114,0,15,''),(81,9,563,0,15,''),(82,9,514,0,15,''),(83,9,111,0,27,'Build Your Own'),(84,9,114,0,27,''),(85,9,118,0,27,'PRODUCTS'),(86,9,479,0,27,'build-your-own'),(87,9,563,0,27,''),(88,9,514,0,27,''),(89,9,533,0,27,'electronics/computers/build-your-own.html'),(90,9,111,0,28,'Laptops'),(91,9,114,0,28,''),(92,9,118,0,28,'PRODUCTS'),(93,9,479,0,28,'laptops'),(94,9,563,0,28,''),(95,9,514,0,28,''),(96,9,533,0,28,'electronics/computers/laptops.html'),(97,9,111,0,29,'Hard Drives'),(98,9,114,0,29,''),(99,9,118,0,29,'PRODUCTS'),(100,9,479,0,29,'hard-drives'),(101,9,563,0,29,''),(102,9,514,0,29,''),(103,9,533,0,29,'electronics/computers/hard-drives.html'),(104,9,111,0,30,'Monitors'),(105,9,114,0,30,''),(106,9,118,0,30,'PRODUCTS'),(107,9,479,0,30,'monitors'),(108,9,563,0,30,''),(109,9,514,0,30,''),(110,9,533,0,30,'electronics/computers/monitors.html'),(111,9,111,0,31,'RAM / Memory'),(112,9,114,0,31,''),(113,9,118,0,31,'PRODUCTS'),(114,9,479,0,31,'ram-memory'),(115,9,563,0,31,''),(116,9,514,0,31,''),(117,9,533,0,31,'electronics/computers/ram-memory.html'),(118,9,111,0,32,'Cases'),(119,9,114,0,32,''),(120,9,118,0,32,'PRODUCTS'),(121,9,479,0,32,'cases'),(122,9,563,0,32,''),(123,9,514,0,32,''),(124,9,533,0,32,'electronics/computers/cases.html'),(125,9,111,0,33,'Processors'),(126,9,114,0,33,''),(127,9,118,0,33,'PRODUCTS'),(128,9,479,0,33,'processors'),(129,9,563,0,33,''),(130,9,514,0,33,''),(131,9,533,0,33,'electronics/computers/processors.html'),(132,9,111,0,34,'Peripherals'),(133,9,114,0,34,''),(134,9,118,0,34,'PRODUCTS'),(135,9,479,0,34,'peripherals'),(136,9,563,0,34,''),(137,9,514,0,34,''),(138,9,533,0,34,'electronics/computers/peripherals.html'),(139,9,114,0,22,''),(140,9,563,0,22,''),(141,9,514,0,22,''),(142,9,114,0,23,''),(143,9,563,0,23,''),(144,9,514,0,23,''),(145,9,114,0,10,''),(146,9,563,0,10,''),(147,9,514,0,10,''),(148,9,114,0,12,''),(149,9,563,0,12,''),(150,9,514,0,12,''),(151,9,114,0,25,''),(152,9,563,0,25,''),(153,9,514,0,25,''),(154,9,114,0,26,''),(155,9,563,0,26,''),(156,9,514,0,26,''),(157,9,114,0,8,''),(158,9,563,0,8,''),(159,9,114,0,18,''),(160,9,563,0,18,''),(161,9,514,0,18,''),(162,9,114,0,4,''),(163,9,563,0,4,''),(164,9,514,0,4,''),(165,9,114,0,5,''),(166,9,563,0,5,''),(167,9,514,0,5,''),(168,9,114,0,16,''),(169,9,563,0,16,''),(170,9,514,0,16,''),(171,9,114,0,17,''),(172,9,563,0,17,''),(173,9,514,0,17,''),(174,9,114,0,19,''),(175,9,563,0,19,''),(176,9,514,0,19,''),(177,9,114,0,20,''),(178,9,563,0,20,''),(179,9,514,0,20,''),(180,9,533,1,10,'furniture.html'),(181,9,533,1,22,'furniture/living-room.html'),(182,9,533,1,23,'furniture/bedroom.html'),(183,9,533,1,13,'electronics.html'),(184,9,533,1,12,'electronics/cameras.html'),(185,9,533,1,25,'electronics/cameras/accessories.html'),(186,9,533,1,26,'electronics/cameras/digital-cameras.html'),(187,9,533,1,15,'electronics/computers.html'),(188,9,533,1,27,'electronics/computers/build-your-own.html'),(189,9,533,1,28,'electronics/computers/laptops.html'),(190,9,533,1,29,'electronics/computers/hard-drives.html'),(191,9,533,1,30,'electronics/computers/monitors.html'),(192,9,533,1,31,'electronics/computers/ram-memory.html'),(193,9,533,1,32,'electronics/computers/cases.html'),(194,9,533,1,33,'electronics/computers/processors.html'),(195,9,533,1,34,'electronics/computers/peripherals.html'),(196,9,533,1,8,'electronics/cell-phones.html'),(197,9,533,1,18,'apparel.html'),(198,9,533,1,19,'apparel/hoodies.html'),(199,9,533,1,24,'apparel/pants.html'),(200,9,533,1,4,'apparel/shirts.html'),(201,9,533,1,5,'apparel/shoes.html'),(202,9,533,1,16,'apparel/shoes/mens.html'),(203,9,533,1,17,'apparel/shoes/womens.html'),(204,9,533,1,20,'household-items.html'),(205,9,111,0,35,'Luggage Sets'),(206,9,114,0,35,NULL),(207,9,479,0,35,'luggage'),(208,9,118,0,35,'PRODUCTS'),(209,9,563,0,35,NULL),(210,9,514,0,35,NULL),(211,9,533,1,35,'luggage.html'),(212,9,533,0,35,'luggage.html'),(213,9,114,0,13,NULL),(214,9,563,0,13,NULL),(215,9,111,0,36,'Single Pieces'),(216,9,114,0,36,NULL),(217,9,479,0,36,'single-pieces'),(218,9,118,0,36,'PRODUCTS'),(219,9,563,0,36,NULL),(220,9,514,0,36,NULL),(221,9,533,1,36,'single-pieces.html'),(222,9,533,0,36,'single-pieces.html');

--
-- Table structure for table `catalog_category_flat_store_1`
--

CREATE TABLE `catalog_category_flat_store_1` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'entity_id',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'parent_id',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'created_at',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'updated_at',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT 'path',
  `position` int(11) NOT NULL DEFAULT '0' COMMENT 'position',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT 'level',
  `children_count` int(11) NOT NULL DEFAULT '0' COMMENT 'children_count',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `all_children` text COMMENT 'All Children',
  `available_sort_by` text COMMENT 'Available Product Listing Sort By',
  `children` text COMMENT 'Children',
  `custom_apply_to_products` int(11) DEFAULT NULL COMMENT 'Apply To Products',
  `custom_design` varchar(255) DEFAULT NULL COMMENT 'Custom Design',
  `custom_design_from` datetime DEFAULT NULL COMMENT 'Active From',
  `custom_design_to` datetime DEFAULT NULL COMMENT 'Active To',
  `custom_layout_update` text COMMENT 'Custom Layout Update',
  `custom_use_parent_settings` int(11) DEFAULT NULL COMMENT 'Use Parent Category Settings',
  `default_sort_by` varchar(255) DEFAULT NULL COMMENT 'Default Product Listing Sort By',
  `description` text COMMENT 'Description',
  `display_mode` varchar(255) DEFAULT NULL COMMENT 'Display Mode',
  `filter_price_range` int(11) DEFAULT NULL COMMENT 'Layered Navigation Price Step',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `include_in_menu` int(11) DEFAULT NULL COMMENT 'Include in Navigation Menu',
  `is_active` int(11) DEFAULT NULL COMMENT 'Is Active',
  `is_anchor` int(11) DEFAULT NULL COMMENT 'Is Anchor',
  `landing_page` int(11) DEFAULT NULL COMMENT 'CMS Block',
  `meta_description` text COMMENT 'Meta Description',
  `meta_keywords` text COMMENT 'Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `path_in_store` text COMMENT 'Path In Store',
  `thumbnail` varchar(255) DEFAULT NULL COMMENT 'Thumbnail Image',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'URL Key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'Url Path',
  PRIMARY KEY (`entity_id`),
  KEY `IDX_CATALOG_CATEGORY_FLAT_STORE_1_STORE_ID` (`store_id`),
  KEY `IDX_CATALOG_CATEGORY_FLAT_STORE_1_PATH` (`path`),
  KEY `IDX_CATALOG_CATEGORY_FLAT_STORE_1_LEVEL` (`level`),
  CONSTRAINT `FK_CATALOG_CATEGORY_FLAT_STORE_1_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_CTGR_FLAT_STORE_1_ENTT_ID_CAT_CTGR_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Flat (Store 1)';

--
-- Dumping data for table `catalog_category_flat_store_1`
--

INSERT INTO `catalog_category_flat_store_1` VALUES (1,0,'2007-07-20 22:46:08','2007-08-07 13:50:15','1',1,0,26,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,1,'2007-08-22 19:54:41','2007-12-05 09:38:59','1/3',3,1,25,1,'3,18,4,5,16,17,19,24,10,22,23,13,8,12,26,25,15,20',NULL,'18,10,13,20',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,'Root Catalog',NULL,'',NULL,'root-catalog',NULL),(4,18,'2007-08-22 19:55:34','2008-08-08 04:56:48','1/3/18/4',4,3,0,1,'4',NULL,'',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,'shirts.jpg',1,1,1,NULL,'','','','Shirts','','4,18',NULL,'shirts','apparel/shirts'),(5,18,'2007-08-22 20:21:29','2008-08-08 03:55:38','1/3/18/5',5,3,2,1,'5,16,17',NULL,'16,17',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,'shoes.jpg',1,1,1,NULL,'','','','Shoes','','5,18',NULL,'shoes','apparel/shoes'),(8,13,'2007-08-22 22:10:30','2008-08-08 03:51:26','1/3/13/8',8,3,0,1,'8',NULL,'',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS_AND_PAGE',NULL,NULL,1,1,1,4,'','','','Cell Phones','','8,13',NULL,'cell-phones','electronics/cell-phones'),(10,3,'2007-08-23 15:45:22','2008-08-08 04:01:18','1/3/10',10,2,2,1,'10,22,23',NULL,'22,23',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,'furniture.jpg',1,1,1,NULL,'','','','Furniture','','10',NULL,'furniture','furniture'),(12,13,'2007-08-24 16:34:30','2008-08-08 03:54:48','1/3/13/12',12,3,2,1,'12,26,25',NULL,'26,25',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,'camera.jpg',1,1,1,NULL,'','','','Cameras','','12,13',NULL,'cameras','electronics/cameras'),(13,3,'2007-08-24 17:31:01','2008-08-08 04:02:23','1/3/13',13,2,13,1,'13,8,12,26,25,15',NULL,'8,12,15',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PAGE',NULL,NULL,1,1,1,3,NULL,NULL,NULL,'Electronics','one_column','13',NULL,'electronics','electronics'),(15,13,'2007-08-24 17:33:17','2008-07-25 05:53:39','1/3/13/15',15,3,8,1,'15',NULL,'',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','Computers','','15,13',NULL,'computers','electronics/computers'),(16,5,'2007-08-24 19:41:52','2008-08-08 03:56:01','1/3/18/5/16',16,4,0,1,'16',NULL,'',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','Mens','','16,5,18',NULL,'mens','apparel/shoes/mens'),(17,5,'2007-08-24 19:43:07','2008-08-08 03:56:28','1/3/18/5/17',17,4,0,1,'17',NULL,'',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','Womens','','17,5,18',NULL,'womens','apparel/shoes/womens'),(18,3,'2007-08-24 19:44:31','2008-08-08 03:54:16','1/3/18',18,2,6,1,'18,4,5,16,17,19,24',NULL,'4,5,19,24',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,'apparel.jpg',1,1,1,NULL,'','','','Apparel','','18',NULL,'apparel','apparel'),(19,18,'2007-08-25 00:05:28','2008-08-08 03:57:03','1/3/18/19',19,3,0,1,'19',NULL,'',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,0,NULL,'','','','Hoodies','','19,18',NULL,'hoodies','apparel/hoodies'),(20,3,'2007-08-25 17:14:09','2008-08-08 03:58:57','1/3/20',20,2,0,1,'20',NULL,'',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,0,0,NULL,'','','','Household Items','','20',NULL,'household-items','household-items'),(22,10,'2007-08-26 18:49:39','2008-08-08 04:01:45','1/3/10/22',22,3,0,1,'22',NULL,'',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS_AND_PAGE',NULL,NULL,1,1,0,NULL,'','','','Living Room','','22,10',NULL,'living-room','furniture/living-room'),(23,10,'2007-08-27 14:35:27','2008-08-08 03:49:18','1/3/10/23',23,3,0,1,'23',NULL,'',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,'bedroom.jpg',1,1,0,NULL,'','','','Bedroom','','23,10',NULL,'bedroom','furniture/bedroom'),(24,18,'2007-08-28 22:32:41','2007-08-30 03:20:36','1/3/18/24',24,3,0,1,'24',NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PRODUCTS',NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,'Pants',NULL,'24,18',NULL,'pants','apparel/pants'),(25,12,'2007-08-29 23:49:52','2008-08-08 03:46:35','1/3/13/12/25',25,4,0,1,'25',NULL,'',1,'',NULL,NULL,'',1,NULL,'Random accessories for different electronic items','PRODUCTS',NULL,NULL,1,1,0,NULL,'','electric, accesories, gadgets','','Accessories','','25,12,13',NULL,'accessories','electronics/cameras/accessories'),(26,12,'2007-08-30 00:37:22','2008-08-08 03:47:02','1/3/13/12/26',26,4,0,1,'26',NULL,'',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','Digital Cameras','','26,12,13',NULL,'digital-cameras','electronics/cameras/digital-cameras'),(27,15,'2008-07-25 04:36:22','2008-08-08 03:48:15','1/3/13/15/27',1,4,0,1,NULL,NULL,NULL,1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,0,NULL,'','','','Build Your Own','',NULL,NULL,'build-your-own','electronics/computers/build-your-own'),(28,15,'2008-07-25 04:39:10','2008-08-08 17:02:59','1/3/13/15/28',2,4,0,1,NULL,NULL,NULL,1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','Laptops','',NULL,NULL,'laptops','electronics/computers/laptops'),(29,13,'2008-07-25 04:39:54','2008-07-25 04:39:54','1/3/13/15/29',3,4,0,1,NULL,NULL,NULL,1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','Hard Drives','',NULL,NULL,'hard-drives','electronics/computers/hard-drives'),(30,13,'2008-07-25 04:41:11','2008-07-25 04:41:11','1/3/13/15/30',4,4,0,1,NULL,NULL,NULL,1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','Monitors','',NULL,NULL,'monitors','electronics/computers/monitors'),(31,13,'2008-07-25 04:41:56','2008-07-25 04:41:56','1/3/13/15/31',5,4,0,1,NULL,NULL,NULL,1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','RAM / Memory','',NULL,NULL,'ram-memory','electronics/computers/ram-memory'),(32,13,'2008-07-25 04:42:57','2008-07-25 04:42:57','1/3/13/15/32',6,4,0,1,NULL,NULL,NULL,1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','Cases','',NULL,NULL,'cases','electronics/computers/cases'),(33,13,'2008-07-25 04:43:25','2008-07-25 04:43:25','1/3/13/15/33',7,4,0,1,NULL,NULL,NULL,1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','Processors','',NULL,NULL,'processors','electronics/computers/processors'),(34,13,'2008-07-25 04:44:17','2008-07-25 04:44:17','1/3/13/15/34',8,4,0,1,NULL,NULL,NULL,1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','Peripherals','',NULL,NULL,'peripherals','electronics/computers/peripherals');

--
-- Table structure for table `catalog_category_flat_store_2`
--

CREATE TABLE `catalog_category_flat_store_2` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'entity_id',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'parent_id',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'created_at',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'updated_at',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT 'path',
  `position` int(11) NOT NULL DEFAULT '0' COMMENT 'position',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT 'level',
  `children_count` int(11) NOT NULL DEFAULT '0' COMMENT 'children_count',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `all_children` text COMMENT 'All Children',
  `available_sort_by` text COMMENT 'Available Product Listing Sort By',
  `children` text COMMENT 'Children',
  `custom_apply_to_products` int(11) DEFAULT NULL COMMENT 'Apply To Products',
  `custom_design` varchar(255) DEFAULT NULL COMMENT 'Custom Design',
  `custom_design_from` datetime DEFAULT NULL COMMENT 'Active From',
  `custom_design_to` datetime DEFAULT NULL COMMENT 'Active To',
  `custom_layout_update` text COMMENT 'Custom Layout Update',
  `custom_use_parent_settings` int(11) DEFAULT NULL COMMENT 'Use Parent Category Settings',
  `default_sort_by` varchar(255) DEFAULT NULL COMMENT 'Default Product Listing Sort By',
  `description` text COMMENT 'Description',
  `display_mode` varchar(255) DEFAULT NULL COMMENT 'Display Mode',
  `filter_price_range` int(11) DEFAULT NULL COMMENT 'Layered Navigation Price Step',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `include_in_menu` int(11) DEFAULT NULL COMMENT 'Include in Navigation Menu',
  `is_active` int(11) DEFAULT NULL COMMENT 'Is Active',
  `is_anchor` int(11) DEFAULT NULL COMMENT 'Is Anchor',
  `landing_page` int(11) DEFAULT NULL COMMENT 'CMS Block',
  `meta_description` text COMMENT 'Meta Description',
  `meta_keywords` text COMMENT 'Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `path_in_store` text COMMENT 'Path In Store',
  `thumbnail` varchar(255) DEFAULT NULL COMMENT 'Thumbnail Image',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'URL Key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'Url Path',
  PRIMARY KEY (`entity_id`),
  KEY `IDX_CATALOG_CATEGORY_FLAT_STORE_2_STORE_ID` (`store_id`),
  KEY `IDX_CATALOG_CATEGORY_FLAT_STORE_2_PATH` (`path`),
  KEY `IDX_CATALOG_CATEGORY_FLAT_STORE_2_LEVEL` (`level`),
  CONSTRAINT `FK_CATALOG_CATEGORY_FLAT_STORE_2_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_CTGR_FLAT_STORE_2_ENTT_ID_CAT_CTGR_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Flat (Store 2)';

--
-- Dumping data for table `catalog_category_flat_store_2`
--

INSERT INTO `catalog_category_flat_store_2` VALUES (1,0,'2007-07-20 22:46:08','2007-08-07 13:50:15','1',1,0,26,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,1,'2007-08-22 19:54:41','2007-12-05 09:38:59','1/3',3,1,25,2,'3,18,4,5,16,17,19,24,10,22,23,13,8,12,26,25,15,20',NULL,'18,10,13,20',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,'Root Catalog',NULL,'',NULL,'root-catalog',NULL),(4,18,'2007-08-22 19:55:34','2008-08-08 04:56:48','1/3/18/4',4,3,0,2,'4',NULL,'',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,'shirts.jpg',1,1,1,NULL,'','','','Shirts','','4,18',NULL,'shirts','apparel/shirts'),(5,18,'2007-08-22 20:21:29','2008-08-08 03:55:38','1/3/18/5',5,3,2,2,'5,16,17',NULL,'16,17',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,'shoes.jpg',1,1,1,NULL,'','','','Shoes','','5,18',NULL,'shoes','apparel/shoes'),(8,13,'2007-08-22 22:10:30','2008-08-08 03:51:26','1/3/13/8',8,3,0,2,'8',NULL,'',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS_AND_PAGE',NULL,NULL,1,1,1,4,'','','','Cell Phones','','8,13',NULL,'cell-phones','electronics/cell-phones'),(10,3,'2007-08-23 15:45:22','2008-08-08 04:01:18','1/3/10',10,2,2,2,'10,22,23',NULL,'22,23',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,'furniture.jpg',1,1,1,NULL,'','','','Furniture','','10',NULL,'furniture','furniture'),(12,13,'2007-08-24 16:34:30','2008-08-08 03:54:48','1/3/13/12',12,3,2,2,'12,26,25',NULL,'26,25',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,'camera.jpg',1,1,1,NULL,'','','','Cameras','','12,13',NULL,'cameras','electronics/cameras'),(13,3,'2007-08-24 17:31:01','2008-08-08 04:02:23','1/3/13',13,2,13,2,'13,8,12,26,25,15',NULL,'8,12,15',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PAGE',NULL,NULL,1,1,1,3,NULL,NULL,NULL,'Electronics','one_column','13',NULL,'electronics','electronics'),(15,13,'2007-08-24 17:33:17','2008-07-25 05:53:39','1/3/13/15',15,3,8,2,'15',NULL,'',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','Computers','','15,13',NULL,'computers','electronics/computers'),(16,5,'2007-08-24 19:41:52','2008-08-08 03:56:01','1/3/18/5/16',16,4,0,2,'16',NULL,'',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','Mens','','16,5,18',NULL,'mens','apparel/shoes/mens'),(17,5,'2007-08-24 19:43:07','2008-08-08 03:56:28','1/3/18/5/17',17,4,0,2,'17',NULL,'',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','Womens','','17,5,18',NULL,'womens','apparel/shoes/womens'),(18,3,'2007-08-24 19:44:31','2008-08-08 03:54:16','1/3/18',18,2,6,2,'18,4,5,16,17,19,24',NULL,'4,5,19,24',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,'apparel.jpg',1,1,1,NULL,'','','','Apparel','','18',NULL,'apparel','apparel'),(19,18,'2007-08-25 00:05:28','2008-08-08 03:57:03','1/3/18/19',19,3,0,2,'19',NULL,'',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,0,NULL,'','','','Hoodies','','19,18',NULL,'hoodies','apparel/hoodies'),(20,3,'2007-08-25 17:14:09','2008-08-08 03:58:57','1/3/20',20,2,0,2,'20',NULL,'',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,0,0,NULL,'','','','Household Items','','20',NULL,'household-items','household-items'),(22,10,'2007-08-26 18:49:39','2008-08-08 04:01:45','1/3/10/22',22,3,0,2,'22',NULL,'',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS_AND_PAGE',NULL,NULL,1,1,0,NULL,'','','','Living Room','','22,10',NULL,'living-room','furniture/living-room'),(23,10,'2007-08-27 14:35:27','2008-08-08 03:49:18','1/3/10/23',23,3,0,2,'23',NULL,'',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,'bedroom.jpg',1,1,0,NULL,'','','','Bedroom','','23,10',NULL,'bedroom','furniture/bedroom'),(24,18,'2007-08-28 22:32:41','2007-08-30 03:20:36','1/3/18/24',24,3,0,2,'24',NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PRODUCTS',NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,'Pants',NULL,'24,18',NULL,'pants','apparel/pants'),(25,12,'2007-08-29 23:49:52','2008-08-08 03:46:35','1/3/13/12/25',25,4,0,2,'25',NULL,'',1,'',NULL,NULL,'',1,NULL,'Random accessories for different electronic items','PRODUCTS',NULL,NULL,1,1,0,NULL,'','electric, accesories, gadgets','','Accessories','','25,12,13',NULL,'accessories','electronics/cameras/accessories'),(26,12,'2007-08-30 00:37:22','2008-08-08 03:47:02','1/3/13/12/26',26,4,0,2,'26',NULL,'',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','Digital Cameras','','26,12,13',NULL,'digital-cameras','electronics/cameras/digital-cameras'),(27,15,'2008-07-25 04:36:22','2008-08-08 03:48:15','1/3/13/15/27',1,4,0,2,NULL,NULL,NULL,1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,0,NULL,'','','','Build Your Own','',NULL,NULL,'build-your-own','electronics/computers/build-your-own'),(28,15,'2008-07-25 04:39:10','2008-08-08 17:02:59','1/3/13/15/28',2,4,0,2,NULL,NULL,NULL,1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','Laptops','',NULL,NULL,'laptops','electronics/computers/laptops'),(29,13,'2008-07-25 04:39:54','2008-07-25 04:39:54','1/3/13/15/29',3,4,0,2,NULL,NULL,NULL,1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','Hard Drives','',NULL,NULL,'hard-drives','electronics/computers/hard-drives'),(30,13,'2008-07-25 04:41:11','2008-07-25 04:41:11','1/3/13/15/30',4,4,0,2,NULL,NULL,NULL,1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','Monitors','',NULL,NULL,'monitors','electronics/computers/monitors'),(31,13,'2008-07-25 04:41:56','2008-07-25 04:41:56','1/3/13/15/31',5,4,0,2,NULL,NULL,NULL,1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','RAM / Memory','',NULL,NULL,'ram-memory','electronics/computers/ram-memory'),(32,13,'2008-07-25 04:42:57','2008-07-25 04:42:57','1/3/13/15/32',6,4,0,2,NULL,NULL,NULL,1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','Cases','',NULL,NULL,'cases','electronics/computers/cases'),(33,13,'2008-07-25 04:43:25','2008-07-25 04:43:25','1/3/13/15/33',7,4,0,2,NULL,NULL,NULL,1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','Processors','',NULL,NULL,'processors','electronics/computers/processors'),(34,13,'2008-07-25 04:44:17','2008-07-25 04:44:17','1/3/13/15/34',8,4,0,2,NULL,NULL,NULL,1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','Peripherals','',NULL,NULL,'peripherals','electronics/computers/peripherals');

--
-- Table structure for table `catalog_category_flat_store_3`
--

CREATE TABLE `catalog_category_flat_store_3` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'entity_id',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'parent_id',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'created_at',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'updated_at',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT 'path',
  `position` int(11) NOT NULL DEFAULT '0' COMMENT 'position',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT 'level',
  `children_count` int(11) NOT NULL DEFAULT '0' COMMENT 'children_count',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `all_children` text COMMENT 'All Children',
  `available_sort_by` text COMMENT 'Available Product Listing Sort By',
  `children` text COMMENT 'Children',
  `custom_apply_to_products` int(11) DEFAULT NULL COMMENT 'Apply To Products',
  `custom_design` varchar(255) DEFAULT NULL COMMENT 'Custom Design',
  `custom_design_from` datetime DEFAULT NULL COMMENT 'Active From',
  `custom_design_to` datetime DEFAULT NULL COMMENT 'Active To',
  `custom_layout_update` text COMMENT 'Custom Layout Update',
  `custom_use_parent_settings` int(11) DEFAULT NULL COMMENT 'Use Parent Category Settings',
  `default_sort_by` varchar(255) DEFAULT NULL COMMENT 'Default Product Listing Sort By',
  `description` text COMMENT 'Description',
  `display_mode` varchar(255) DEFAULT NULL COMMENT 'Display Mode',
  `filter_price_range` int(11) DEFAULT NULL COMMENT 'Layered Navigation Price Step',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `include_in_menu` int(11) DEFAULT NULL COMMENT 'Include in Navigation Menu',
  `is_active` int(11) DEFAULT NULL COMMENT 'Is Active',
  `is_anchor` int(11) DEFAULT NULL COMMENT 'Is Anchor',
  `landing_page` int(11) DEFAULT NULL COMMENT 'CMS Block',
  `meta_description` text COMMENT 'Meta Description',
  `meta_keywords` text COMMENT 'Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `path_in_store` text COMMENT 'Path In Store',
  `thumbnail` varchar(255) DEFAULT NULL COMMENT 'Thumbnail Image',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'URL Key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'Url Path',
  PRIMARY KEY (`entity_id`),
  KEY `IDX_CATALOG_CATEGORY_FLAT_STORE_3_STORE_ID` (`store_id`),
  KEY `IDX_CATALOG_CATEGORY_FLAT_STORE_3_PATH` (`path`),
  KEY `IDX_CATALOG_CATEGORY_FLAT_STORE_3_LEVEL` (`level`),
  CONSTRAINT `FK_CATALOG_CATEGORY_FLAT_STORE_3_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_CTGR_FLAT_STORE_3_ENTT_ID_CAT_CTGR_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Flat (Store 3)';

--
-- Dumping data for table `catalog_category_flat_store_3`
--

INSERT INTO `catalog_category_flat_store_3` VALUES (1,0,'2007-07-20 22:46:08','2007-08-07 13:50:15','1',1,0,26,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,1,'2007-08-22 19:54:41','2007-12-05 09:38:59','1/3',3,1,25,3,'3,18,4,5,16,17,19,24,10,22,23,13,8,12,26,25,15,20',NULL,'18,10,13,20',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,NULL,NULL,NULL,NULL,NULL,'Root Catalog',NULL,'',NULL,'root-catalog',NULL),(4,18,'2007-08-22 19:55:34','2008-08-08 04:56:48','1/3/18/4',4,3,0,3,'4',NULL,'',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,'shirts.jpg',1,1,1,NULL,'','','','Shirts','','4,18',NULL,'shirts','apparel/shirts'),(5,18,'2007-08-22 20:21:29','2008-08-08 03:55:38','1/3/18/5',5,3,2,3,'5,16,17',NULL,'16,17',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,'shoes.jpg',1,1,1,NULL,'','','','Shoes','','5,18',NULL,'shoes','apparel/shoes'),(8,13,'2007-08-22 22:10:30','2008-08-08 03:51:26','1/3/13/8',8,3,0,3,'8',NULL,'',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS_AND_PAGE',NULL,NULL,1,1,1,4,'','','','Cell Phones','','8,13',NULL,'cell-phones','electronics/cell-phones'),(10,3,'2007-08-23 15:45:22','2008-08-08 04:01:18','1/3/10',10,2,2,3,'10,22,23',NULL,'22,23',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,'furniture.jpg',1,1,1,NULL,'','','','Furniture','','10',NULL,'furniture','furniture'),(12,13,'2007-08-24 16:34:30','2008-08-08 03:54:48','1/3/13/12',12,3,2,3,'12,26,25',NULL,'26,25',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,'camera.jpg',1,1,1,NULL,'','','','Cameras','','12,13',NULL,'cameras','electronics/cameras'),(13,3,'2007-08-24 17:31:01','2008-08-08 04:02:23','1/3/13',13,2,13,3,'13,8,12,26,25,15',NULL,'8,12,15',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PAGE',NULL,NULL,1,1,1,3,NULL,NULL,NULL,'Electronics','one_column','13',NULL,'electronics','electronics'),(15,13,'2007-08-24 17:33:17','2008-07-25 05:53:39','1/3/13/15',15,3,8,3,'15',NULL,'',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','Computers','','15,13',NULL,'computers','electronics/computers'),(16,5,'2007-08-24 19:41:52','2008-08-08 03:56:01','1/3/18/5/16',16,4,0,3,'16',NULL,'',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','Mens','','16,5,18',NULL,'mens','apparel/shoes/mens'),(17,5,'2007-08-24 19:43:07','2008-08-08 03:56:28','1/3/18/5/17',17,4,0,3,'17',NULL,'',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','Womens','','17,5,18',NULL,'womens','apparel/shoes/womens'),(18,3,'2007-08-24 19:44:31','2008-08-08 03:54:16','1/3/18',18,2,6,3,'18,4,5,16,17,19,24',NULL,'4,5,19,24',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,'apparel.jpg',1,1,1,NULL,'','','','Apparel','','18',NULL,'apparel','apparel'),(19,18,'2007-08-25 00:05:28','2008-08-08 03:57:03','1/3/18/19',19,3,0,3,'19',NULL,'',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,0,NULL,'','','','Hoodies','','19,18',NULL,'hoodies','apparel/hoodies'),(20,3,'2007-08-25 17:14:09','2008-08-08 03:58:57','1/3/20',20,2,0,3,'20',NULL,'',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,0,0,NULL,'','','','Household Items','','20',NULL,'household-items','household-items'),(22,10,'2007-08-26 18:49:39','2008-08-08 04:01:45','1/3/10/22',22,3,0,3,'22',NULL,'',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS_AND_PAGE',NULL,NULL,1,1,0,NULL,'','','','Living Room','','22,10',NULL,'living-room','furniture/living-room'),(23,10,'2007-08-27 14:35:27','2008-08-08 03:49:18','1/3/10/23',23,3,0,3,'23',NULL,'',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,'bedroom.jpg',1,1,0,NULL,'','','','Bedroom','','23,10',NULL,'bedroom','furniture/bedroom'),(24,18,'2007-08-28 22:32:41','2007-08-30 03:20:36','1/3/18/24',24,3,0,3,'24',NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PRODUCTS',NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,'Pants',NULL,'24,18',NULL,'pants','apparel/pants'),(25,12,'2007-08-29 23:49:52','2008-08-08 03:46:35','1/3/13/12/25',25,4,0,3,'25',NULL,'',1,'',NULL,NULL,'',1,NULL,'Random accessories for different electronic items','PRODUCTS',NULL,NULL,1,1,0,NULL,'','electric, accesories, gadgets','','Accessories','','25,12,13',NULL,'accessories','electronics/cameras/accessories'),(26,12,'2007-08-30 00:37:22','2008-08-08 03:47:02','1/3/13/12/26',26,4,0,3,'26',NULL,'',1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','Digital Cameras','','26,12,13',NULL,'digital-cameras','electronics/cameras/digital-cameras'),(27,15,'2008-07-25 04:36:22','2008-08-08 03:48:15','1/3/13/15/27',1,4,0,3,NULL,NULL,NULL,1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,0,NULL,'','','','Build Your Own','',NULL,NULL,'build-your-own','electronics/computers/build-your-own'),(28,15,'2008-07-25 04:39:10','2008-08-08 17:02:59','1/3/13/15/28',2,4,0,3,NULL,NULL,NULL,1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','Laptops','',NULL,NULL,'laptops','electronics/computers/laptops'),(29,13,'2008-07-25 04:39:54','2008-07-25 04:39:54','1/3/13/15/29',3,4,0,3,NULL,NULL,NULL,1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','Hard Drives','',NULL,NULL,'hard-drives','electronics/computers/hard-drives'),(30,13,'2008-07-25 04:41:11','2008-07-25 04:41:11','1/3/13/15/30',4,4,0,3,NULL,NULL,NULL,1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','Monitors','',NULL,NULL,'monitors','electronics/computers/monitors'),(31,13,'2008-07-25 04:41:56','2008-07-25 04:41:56','1/3/13/15/31',5,4,0,3,NULL,NULL,NULL,1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','RAM / Memory','',NULL,NULL,'ram-memory','electronics/computers/ram-memory'),(32,13,'2008-07-25 04:42:57','2008-07-25 04:42:57','1/3/13/15/32',6,4,0,3,NULL,NULL,NULL,1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','Cases','',NULL,NULL,'cases','electronics/computers/cases'),(33,13,'2008-07-25 04:43:25','2008-07-25 04:43:25','1/3/13/15/33',7,4,0,3,NULL,NULL,NULL,1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','Processors','',NULL,NULL,'processors','electronics/computers/processors'),(34,13,'2008-07-25 04:44:17','2008-07-25 04:44:17','1/3/13/15/34',8,4,0,3,NULL,NULL,NULL,1,'',NULL,NULL,'',1,NULL,'','PRODUCTS',NULL,NULL,1,1,1,NULL,'','','','Peripherals','',NULL,NULL,'peripherals','electronics/computers/peripherals');

--
-- Table structure for table `catalog_category_product`
--

CREATE TABLE `catalog_category_product` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `position` int(11) NOT NULL DEFAULT '0' COMMENT 'Position',
  PRIMARY KEY (`category_id`,`product_id`),
  KEY `IDX_CATALOG_CATEGORY_PRODUCT_PRODUCT_ID` (`product_id`),
  CONSTRAINT `FK_CAT_CTGR_PRD_CTGR_ID_CAT_CTGR_ENTT_ENTT_ID` FOREIGN KEY (`category_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_CTGR_PRD_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product To Category Linkage Table';

--
-- Dumping data for table `catalog_category_product`
--

INSERT INTO `catalog_category_product` VALUES (3,167,1),(35,167,1),(35,168,1),(35,169,1),(35,170,1),(35,171,1),(35,172,1),(35,173,1),(35,174,1),(35,175,1),(35,177,1),(35,178,1),(35,185,1),(36,176,1),(36,179,1),(36,180,1),(36,181,1),(36,182,1),(36,183,1),(36,184,1);

--
-- Table structure for table `catalog_category_product_index`
--

CREATE TABLE `catalog_category_product_index` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `visibility` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `15D3C269665C74C2219037D534F4B0DC` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`),
  KEY `IDX_CAT_CTGR_PRD_IDX_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  CONSTRAINT `FK_CATALOG_CATEGORY_PRODUCT_INDEX_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_CTGR_PRD_IDX_CTGR_ID_CAT_CTGR_ENTT_ENTT_ID` FOREIGN KEY (`category_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_CTGR_PRD_IDX_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index';

--
-- Dumping data for table `catalog_category_product_index`
--

INSERT INTO `catalog_category_product_index` VALUES (3,168,660001,0,1,4),(3,169,660001,0,1,4),(3,170,660001,0,1,4),(3,171,660001,0,1,4),(3,172,660001,0,1,4),(3,173,660001,0,1,4),(3,174,660001,0,1,4),(3,175,660001,0,1,4),(3,177,660001,0,1,4),(3,178,660001,0,1,4),(3,185,660001,0,1,4),(3,176,690001,0,1,4),(3,179,690001,0,1,4),(3,180,690001,0,1,4),(3,181,690001,0,1,4),(3,182,690001,0,1,4),(3,183,690001,0,1,4),(3,184,690001,0,1,4),(3,167,1,1,1,4),(35,167,1,1,1,4),(35,168,1,1,1,4),(35,169,1,1,1,4),(35,170,1,1,1,4),(35,171,1,1,1,4),(35,172,1,1,1,4),(35,173,1,1,1,4),(35,174,1,1,1,4),(35,175,1,1,1,4),(35,177,1,1,1,4),(35,178,1,1,1,4),(35,185,1,1,1,4),(36,176,1,1,1,4),(36,179,1,1,1,4),(36,180,1,1,1,4),(36,181,1,1,1,4),(36,182,1,1,1,4),(36,183,1,1,1,4),(36,184,1,1,1,4),(3,168,660001,0,2,4),(3,169,660001,0,2,4),(3,170,660001,0,2,4),(3,171,660001,0,2,4),(3,172,660001,0,2,4),(3,173,660001,0,2,4),(3,174,660001,0,2,4),(3,175,660001,0,2,4),(3,177,660001,0,2,4),(3,178,660001,0,2,4),(3,185,660001,0,2,4),(3,176,690001,0,2,4),(3,179,690001,0,2,4),(3,180,690001,0,2,4),(3,181,690001,0,2,4),(3,182,690001,0,2,4),(3,183,690001,0,2,4),(3,184,690001,0,2,4),(3,167,1,1,2,4),(35,167,1,1,2,4),(35,168,1,1,2,4),(35,169,1,1,2,4),(35,170,1,1,2,4),(35,171,1,1,2,4),(35,172,1,1,2,4),(35,173,1,1,2,4),(35,174,1,1,2,4),(35,175,1,1,2,4),(35,177,1,1,2,4),(35,178,1,1,2,4),(35,185,1,1,2,4),(36,176,1,1,2,4),(36,179,1,1,2,4),(36,180,1,1,2,4),(36,181,1,1,2,4),(36,182,1,1,2,4),(36,183,1,1,2,4),(36,184,1,1,2,4),(3,168,660001,0,3,4),(3,169,660001,0,3,4),(3,170,660001,0,3,4),(3,171,660001,0,3,4),(3,172,660001,0,3,4),(3,173,660001,0,3,4),(3,174,660001,0,3,4),(3,175,660001,0,3,4),(3,177,660001,0,3,4),(3,178,660001,0,3,4),(3,185,660001,0,3,4),(3,176,690001,0,3,4),(3,179,690001,0,3,4),(3,180,690001,0,3,4),(3,181,690001,0,3,4),(3,182,690001,0,3,4),(3,183,690001,0,3,4),(3,184,690001,0,3,4),(3,167,1,1,3,4),(35,167,1,1,3,4),(35,168,1,1,3,4),(35,169,1,1,3,4),(35,170,1,1,3,4),(35,171,1,1,3,4),(35,172,1,1,3,4),(35,173,1,1,3,4),(35,174,1,1,3,4),(35,175,1,1,3,4),(35,177,1,1,3,4),(35,178,1,1,3,4),(35,185,1,1,3,4),(36,176,1,1,3,4),(36,179,1,1,3,4),(36,180,1,1,3,4),(36,181,1,1,3,4),(36,182,1,1,3,4),(36,183,1,1,3,4),(36,184,1,1,3,4);

--
-- Table structure for table `catalog_category_product_index_enbl_idx`
--

CREATE TABLE `catalog_category_product_index_enbl_idx` (
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `visibility` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Visibility',
  KEY `IDX_CAT_CTGR_PRD_IDX_ENBL_IDX_PRD_ID_VISIBILITY` (`product_id`,`visibility`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Enabled Indexer Index Table';

--
-- Dumping data for table `catalog_category_product_index_enbl_idx`
--


--
-- Table structure for table `catalog_category_product_index_enbl_tmp`
--

CREATE TABLE `catalog_category_product_index_enbl_tmp` (
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `visibility` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Visibility',
  KEY `IDX_CAT_CTGR_PRD_IDX_ENBL_TMP_PRD_ID_VISIBILITY` (`product_id`,`visibility`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Enabled Indexer Temp Table';

--
-- Dumping data for table `catalog_category_product_index_enbl_tmp`
--


--
-- Table structure for table `catalog_category_product_index_idx`
--

CREATE TABLE `catalog_category_product_index_idx` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `position` int(11) NOT NULL DEFAULT '0' COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `visibility` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Visibility',
  KEY `IDX_CAT_CTGR_PRD_IDX_IDX_PRD_ID_CTGR_ID_STORE_ID` (`product_id`,`category_id`,`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Indexer Index Table';

--
-- Dumping data for table `catalog_category_product_index_idx`
--


--
-- Table structure for table `catalog_category_product_index_tmp`
--

CREATE TABLE `catalog_category_product_index_tmp` (
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Category ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `position` int(11) NOT NULL DEFAULT '0' COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `visibility` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Visibility',
  KEY `IDX_CAT_CTGR_PRD_IDX_TMP_PRD_ID_CTGR_ID_STORE_ID` (`product_id`,`category_id`,`store_id`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Indexer Temp Table';

--
-- Dumping data for table `catalog_category_product_index_tmp`
--


--
-- Table structure for table `catalog_compare_item`
--

CREATE TABLE `catalog_compare_item` (
  `catalog_compare_item_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Compare Item ID',
  `visitor_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Visitor ID',
  `customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  PRIMARY KEY (`catalog_compare_item_id`),
  KEY `IDX_CATALOG_COMPARE_ITEM_CUSTOMER_ID` (`customer_id`),
  KEY `IDX_CATALOG_COMPARE_ITEM_PRODUCT_ID` (`product_id`),
  KEY `IDX_CATALOG_COMPARE_ITEM_VISITOR_ID_PRODUCT_ID` (`visitor_id`,`product_id`),
  KEY `IDX_CATALOG_COMPARE_ITEM_CUSTOMER_ID_PRODUCT_ID` (`customer_id`,`product_id`),
  KEY `IDX_CATALOG_COMPARE_ITEM_STORE_ID` (`store_id`),
  CONSTRAINT `FK_CATALOG_COMPARE_ITEM_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CATALOG_COMPARE_ITEM_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_CMP_ITEM_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Catalog Compare Table';

--
-- Dumping data for table `catalog_compare_item`
--

INSERT INTO `catalog_compare_item` VALUES (1,27,NULL,167,1);

--
-- Table structure for table `catalog_eav_attribute`
--

CREATE TABLE `catalog_eav_attribute` (
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `frontend_input_renderer` varchar(255) DEFAULT NULL COMMENT 'Frontend Input Renderer',
  `is_global` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Is Global',
  `is_visible` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Is Visible',
  `is_searchable` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Searchable',
  `is_filterable` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Filterable',
  `is_comparable` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Comparable',
  `is_visible_on_front` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Visible On Front',
  `is_html_allowed_on_front` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is HTML Allowed On Front',
  `is_used_for_price_rules` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Used For Price Rules',
  `is_filterable_in_search` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Filterable In Search',
  `used_in_product_listing` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Used In Product Listing',
  `used_for_sort_by` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Used For Sorting',
  `is_configurable` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Is Configurable',
  `apply_to` varchar(255) DEFAULT NULL COMMENT 'Apply To',
  `is_visible_in_advanced_search` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Visible In Advanced Search',
  `position` int(11) NOT NULL DEFAULT '0' COMMENT 'Position',
  `is_wysiwyg_enabled` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is WYSIWYG Enabled',
  `is_used_for_promo_rules` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Used For Promo Rules',
  PRIMARY KEY (`attribute_id`),
  KEY `IDX_CATALOG_EAV_ATTRIBUTE_USED_FOR_SORT_BY` (`used_for_sort_by`),
  KEY `IDX_CATALOG_EAV_ATTRIBUTE_USED_IN_PRODUCT_LISTING` (`used_in_product_listing`),
  CONSTRAINT `FK_CATALOG_EAV_ATTRIBUTE_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog EAV Attribute Table';

--
-- Dumping data for table `catalog_eav_attribute`
--

INSERT INTO `catalog_eav_attribute` VALUES (96,NULL,0,1,1,0,0,0,0,1,0,1,1,1,'',1,1,0,1),(97,NULL,0,1,1,0,1,0,1,1,0,0,0,1,'',1,1,1,1),(98,NULL,1,1,1,0,1,0,0,1,0,0,0,1,'',1,1,0,1),(99,NULL,2,1,1,1,0,0,0,1,1,1,1,1,'simple,configurable,virtual,bundle,downloadable',1,0,0,1),(100,NULL,2,1,0,0,0,0,0,1,0,0,0,1,'simple,virtual,downloadable',0,1,0,1),(101,NULL,1,1,0,0,0,0,0,1,0,0,0,1,'simple,bundle',0,1,0,1),(102,NULL,1,1,1,1,1,0,0,1,1,0,0,1,'simple',0,1,0,1),(103,NULL,0,1,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(104,NULL,0,1,1,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(105,NULL,0,1,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(106,NULL,0,1,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(107,NULL,1,1,1,1,1,0,0,1,1,0,0,1,'simple,grouped,configurable',0,1,0,1),(109,NULL,0,1,0,0,0,0,0,1,0,1,0,1,'',0,1,0,1),(110,NULL,1,0,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(111,NULL,0,1,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(112,NULL,0,1,0,0,0,0,1,1,0,0,0,1,'',0,1,1,1),(113,NULL,0,1,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(114,NULL,0,1,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(115,NULL,0,1,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(116,NULL,0,1,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(117,NULL,0,1,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(118,NULL,0,1,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(119,NULL,0,1,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(120,NULL,1,1,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(121,NULL,1,0,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(122,NULL,1,0,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(123,NULL,1,0,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(270,NULL,2,1,0,0,0,0,0,0,0,0,0,1,'simple,configurable,virtual,bundle,downloadable',0,1,0,0),(271,NULL,1,1,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(272,NULL,1,1,1,1,1,0,0,1,1,0,0,1,'simple',1,1,0,1),(273,NULL,2,1,1,0,0,0,0,1,0,1,0,1,'',0,1,0,1),(274,NULL,0,1,0,0,0,0,0,1,0,1,0,1,'simple,configurable,virtual,bundle,downloadable',0,1,0,1),(476,NULL,0,1,1,1,1,1,0,1,1,0,0,1,'simple,grouped,configurable',0,1,0,1),(479,NULL,1,1,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(481,NULL,1,1,0,0,0,0,0,1,0,1,0,1,'',0,1,0,1),(492,NULL,0,1,1,0,1,1,1,1,0,0,0,1,'simple,grouped,configurable',0,1,0,1),(493,NULL,0,1,0,0,0,0,0,1,0,1,0,1,'',0,1,0,1),(494,NULL,1,1,1,0,1,1,0,1,0,0,0,1,'simple,grouped,configurable',0,1,0,1),(495,NULL,1,1,1,0,1,1,0,1,0,0,0,1,'simple,grouped,configurable',0,1,0,1),(496,NULL,1,1,0,0,0,1,0,1,0,0,0,1,'simple,grouped,configurable',0,1,0,1),(497,NULL,1,1,1,0,1,1,0,1,0,0,0,1,'simple',0,1,0,1),(498,NULL,1,1,1,0,1,1,0,1,0,0,0,1,'simple,grouped,configurable',0,1,0,1),(499,NULL,1,1,1,0,1,1,0,1,0,0,0,1,'simple,grouped,configurable',0,1,0,1),(500,NULL,1,1,1,0,1,1,0,1,0,0,0,1,'simple,grouped,configurable',0,1,0,1),(501,NULL,1,1,1,0,0,0,0,1,0,0,0,1,'simple,grouped,configurable',1,1,0,1),(502,NULL,1,1,1,0,0,0,0,1,0,0,0,1,'simple,grouped,configurable',0,1,0,1),(503,NULL,0,0,0,0,0,0,0,1,0,0,0,1,'simple,configurable,virtual,bundle,downloadable',0,1,0,1),(506,NULL,0,1,1,0,1,0,1,1,0,1,0,1,'',0,1,1,1),(507,NULL,1,1,1,0,1,1,0,1,0,0,0,1,'simple,grouped,configurable',0,1,0,1),(508,NULL,1,1,1,0,1,0,0,1,0,0,0,1,'simple,grouped,configurable',0,1,0,1),(509,NULL,1,1,1,0,1,1,0,1,0,0,0,1,'simple,grouped,configurable',0,1,0,1),(510,NULL,1,1,1,2,1,1,0,1,1,0,0,1,'simple,grouped,configurable',1,1,0,1),(513,NULL,1,1,1,1,1,1,0,1,1,0,0,1,'simple,grouped,configurable',0,1,0,1),(514,NULL,0,1,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(525,NULL,1,1,1,0,0,0,0,1,0,0,0,1,'simple,grouped,configurable',0,1,0,1),(526,NULL,0,1,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(530,NULL,0,1,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(531,NULL,1,1,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(533,NULL,0,0,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(562,'giftmessage/adminhtml_product_helper_form_config',1,1,0,0,0,0,0,1,0,0,0,0,'',0,1,0,1),(563,NULL,0,1,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(565,NULL,0,1,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(566,NULL,0,1,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(567,NULL,2,1,0,0,0,0,0,1,0,1,0,1,'simple,configurable,virtual,bundle,downloadable',0,1,0,1),(568,NULL,1,1,0,0,0,0,0,1,0,1,0,1,'simple,configurable,virtual,bundle,downloadable',0,1,0,1),(569,NULL,1,1,0,0,0,0,0,1,0,1,0,1,'simple,configurable,virtual,bundle,downloadable',0,1,0,1),(570,NULL,0,0,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(571,NULL,0,1,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(572,NULL,0,1,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(573,NULL,0,1,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(701,NULL,1,0,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(702,NULL,1,0,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(703,NULL,1,1,0,0,0,0,0,1,0,0,0,1,'',0,1,0,1),(704,NULL,1,1,0,0,0,0,0,1,0,1,0,1,'',0,1,0,1),(705,NULL,1,1,0,0,0,0,0,1,0,1,0,1,'',0,1,0,1),(835,NULL,1,0,0,0,0,0,0,1,0,0,0,1,'',0,0,0,1),(836,NULL,0,1,0,0,0,0,0,1,0,0,0,1,'',0,0,0,1),(837,NULL,1,0,0,0,0,0,0,1,0,1,0,1,'',0,0,0,1),(838,NULL,1,0,0,0,0,0,0,1,0,0,0,1,'',0,0,0,1),(859,NULL,1,0,0,0,0,0,0,1,0,1,0,0,'bundle',0,0,0,1),(860,NULL,1,0,0,0,0,0,0,1,0,0,0,0,'bundle',0,0,0,1),(861,NULL,1,0,0,0,0,0,0,1,0,1,0,0,'bundle',0,0,0,1),(862,NULL,1,1,0,0,0,0,0,1,0,1,0,0,'bundle',0,0,0,1),(863,NULL,1,0,0,0,0,0,0,1,0,1,0,0,'bundle',0,0,0,1),(873,NULL,0,1,0,0,0,0,0,1,0,0,0,0,'',0,0,0,1),(874,NULL,0,1,0,0,0,0,0,1,0,0,0,0,'',0,0,0,1),(875,NULL,0,1,0,1,1,1,0,1,1,0,0,0,'',0,0,0,1),(876,NULL,0,1,0,0,0,1,0,1,0,0,0,0,'',0,0,0,1),(877,NULL,0,1,0,0,0,0,0,1,0,0,0,0,'',0,0,0,1),(878,NULL,0,1,0,0,0,1,0,1,0,0,0,0,'',0,0,0,1),(879,NULL,0,0,0,0,0,0,0,1,1,1,0,0,'',0,0,0,1),(880,NULL,0,0,0,0,0,0,0,1,1,1,0,0,'',0,0,0,1),(881,NULL,0,0,0,0,0,0,0,1,1,1,0,0,'',0,0,0,1),(903,NULL,1,1,0,0,0,0,0,1,1,0,0,0,'',0,0,0,1),(904,NULL,1,0,0,0,0,0,0,1,1,1,0,0,'downloadable',0,0,0,1),(905,NULL,0,0,0,0,0,0,0,1,1,0,0,0,'downloadable',0,0,0,1),(906,NULL,0,0,0,0,0,0,0,1,1,0,0,0,'downloadable',0,0,0,1),(929,'adminhtml/catalog_category_helper_sortby_available',0,1,0,0,0,0,0,1,0,0,0,1,'',0,0,0,1),(930,'adminhtml/catalog_category_helper_sortby_default',0,1,0,0,0,0,0,1,0,0,0,1,'',0,0,0,1),(931,NULL,0,1,0,0,0,0,0,1,0,0,0,1,'',0,0,0,1),(932,NULL,1,0,0,0,0,0,0,1,0,0,0,1,'',0,0,0,1),(933,NULL,1,0,0,0,0,0,0,1,0,0,0,1,'',0,0,0,1),(934,NULL,0,1,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0),(935,NULL,1,1,0,0,0,0,0,0,0,0,0,0,'simple,virtual',0,0,0,0),(936,NULL,1,1,0,0,0,0,0,0,0,0,0,0,'simple,virtual',0,0,0,0),(937,NULL,0,1,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0),(938,NULL,0,1,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0),(939,'adminhtml/catalog_category_helper_pricestep',0,1,0,0,0,0,0,0,0,0,0,1,'',0,0,0,0),(940,NULL,2,1,0,0,0,0,0,0,0,0,0,0,'simple,configurable,bundle,grouped',0,0,0,0),(941,'adminhtml/catalog_product_helper_form_msrp_enabled',2,1,0,0,0,0,0,0,0,1,0,1,'simple,bundle,configurable,virtual,downloadable',0,0,0,0),(942,'adminhtml/catalog_product_helper_form_msrp_price',2,1,0,0,0,0,0,0,0,1,0,1,'simple,bundle,configurable,virtual,downloadable',0,0,0,0),(943,NULL,2,1,0,0,0,0,0,0,0,1,0,1,'simple,bundle,configurable,virtual,downloadable',0,0,0,0),(952,NULL,1,0,0,0,0,0,0,0,0,1,0,0,'downloadable',0,0,0,0),(953,NULL,0,1,0,0,0,0,0,0,0,0,0,1,NULL,0,0,0,0),(960,NULL,2,1,0,0,0,0,0,0,0,0,0,1,'simple,configurable,virtual,bundle,downloadable',0,0,0,0);

--
-- Table structure for table `catalog_product_bundle_option`
--

CREATE TABLE `catalog_product_bundle_option` (
  `option_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Id',
  `parent_id` int(10) unsigned NOT NULL COMMENT 'Parent Id',
  `required` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Required',
  `position` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Position',
  `type` varchar(255) DEFAULT NULL COMMENT 'Type',
  PRIMARY KEY (`option_id`),
  KEY `IDX_CATALOG_PRODUCT_BUNDLE_OPTION_PARENT_ID` (`parent_id`),
  CONSTRAINT `FK_CAT_PRD_BNDL_OPT_PARENT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`parent_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Bundle Option';

--
-- Dumping data for table `catalog_product_bundle_option`
--


--
-- Table structure for table `catalog_product_bundle_option_value`
--

CREATE TABLE `catalog_product_bundle_option_value` (
  `value_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `option_id` int(10) unsigned NOT NULL COMMENT 'Option Id',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store Id',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `UNQ_CATALOG_PRODUCT_BUNDLE_OPTION_VALUE_OPTION_ID_STORE_ID` (`option_id`,`store_id`),
  CONSTRAINT `FK_CAT_PRD_BNDL_OPT_VAL_OPT_ID_CAT_PRD_BNDL_OPT_OPT_ID` FOREIGN KEY (`option_id`) REFERENCES `catalog_product_bundle_option` (`option_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Bundle Option Value';

--
-- Dumping data for table `catalog_product_bundle_option_value`
--


--
-- Table structure for table `catalog_product_bundle_price_index`
--

CREATE TABLE `catalog_product_bundle_price_index` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity Id',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website Id',
  `customer_group_id` smallint(5) unsigned NOT NULL COMMENT 'Customer Group Id',
  `min_price` decimal(12,4) NOT NULL COMMENT 'Min Price',
  `max_price` decimal(12,4) NOT NULL COMMENT 'Max Price',
  PRIMARY KEY (`entity_id`,`website_id`,`customer_group_id`),
  KEY `IDX_CATALOG_PRODUCT_BUNDLE_PRICE_INDEX_WEBSITE_ID` (`website_id`),
  KEY `IDX_CATALOG_PRODUCT_BUNDLE_PRICE_INDEX_CUSTOMER_GROUP_ID` (`customer_group_id`),
  CONSTRAINT `FK_CAT_PRD_BNDL_PRICE_IDX_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_ID` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_PRD_BNDL_PRICE_IDX_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_PRD_BNDL_PRICE_IDX_WS_ID_CORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Bundle Price Index';

--
-- Dumping data for table `catalog_product_bundle_price_index`
--


--
-- Table structure for table `catalog_product_bundle_selection`
--

CREATE TABLE `catalog_product_bundle_selection` (
  `selection_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Selection Id',
  `option_id` int(10) unsigned NOT NULL COMMENT 'Option Id',
  `parent_product_id` int(10) unsigned NOT NULL COMMENT 'Parent Product Id',
  `product_id` int(10) unsigned NOT NULL COMMENT 'Product Id',
  `position` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Position',
  `is_default` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Default',
  `selection_price_type` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Selection Price Type',
  `selection_price_value` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Selection Price Value',
  `selection_qty` decimal(12,4) DEFAULT NULL COMMENT 'Selection Qty',
  `selection_can_change_qty` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Selection Can Change Qty',
  PRIMARY KEY (`selection_id`),
  KEY `IDX_CATALOG_PRODUCT_BUNDLE_SELECTION_OPTION_ID` (`option_id`),
  KEY `IDX_CATALOG_PRODUCT_BUNDLE_SELECTION_PRODUCT_ID` (`product_id`),
  CONSTRAINT `FK_CAT_PRD_BNDL_SELECTION_OPT_ID_CAT_PRD_BNDL_OPT_OPT_ID` FOREIGN KEY (`option_id`) REFERENCES `catalog_product_bundle_option` (`option_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_PRD_BNDL_SELECTION_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Bundle Selection';

--
-- Dumping data for table `catalog_product_bundle_selection`
--


--
-- Table structure for table `catalog_product_bundle_selection_price`
--

CREATE TABLE `catalog_product_bundle_selection_price` (
  `selection_id` int(10) unsigned NOT NULL COMMENT 'Selection Id',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website Id',
  `selection_price_type` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Selection Price Type',
  `selection_price_value` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Selection Price Value',
  PRIMARY KEY (`selection_id`,`website_id`),
  KEY `IDX_CATALOG_PRODUCT_BUNDLE_SELECTION_PRICE_WEBSITE_ID` (`website_id`),
  CONSTRAINT `FK_CAT_PRD_BNDL_SELECTION_PRICE_WS_ID_CORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_DCF37523AA05D770A70AA4ED7C2616E4` FOREIGN KEY (`selection_id`) REFERENCES `catalog_product_bundle_selection` (`selection_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Bundle Selection Price';

--
-- Dumping data for table `catalog_product_bundle_selection_price`
--


--
-- Table structure for table `catalog_product_bundle_stock_index`
--

CREATE TABLE `catalog_product_bundle_stock_index` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity Id',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website Id',
  `stock_id` smallint(5) unsigned NOT NULL COMMENT 'Stock Id',
  `option_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Option Id',
  `stock_status` smallint(6) DEFAULT '0' COMMENT 'Stock Status',
  PRIMARY KEY (`entity_id`,`stock_id`,`website_id`,`option_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Bundle Stock Index';

--
-- Dumping data for table `catalog_product_bundle_stock_index`
--


--
-- Table structure for table `catalog_product_enabled_index`
--

CREATE TABLE `catalog_product_enabled_index` (
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `visibility` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Visibility',
  PRIMARY KEY (`product_id`,`store_id`),
  KEY `IDX_CATALOG_PRODUCT_ENABLED_INDEX_STORE_ID` (`store_id`),
  CONSTRAINT `FK_CATALOG_PRODUCT_ENABLED_INDEX_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_PRD_ENABLED_IDX_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Visibility Index Table';

--
-- Dumping data for table `catalog_product_enabled_index`
--


--
-- Table structure for table `catalog_product_entity`
--

CREATE TABLE `catalog_product_entity` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type ID',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set ID',
  `type_id` varchar(32) NOT NULL DEFAULT 'simple' COMMENT 'Type ID',
  `sku` varchar(64) DEFAULT NULL COMMENT 'SKU',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time',
  `has_options` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Has Options',
  `required_options` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Required Options',
  PRIMARY KEY (`entity_id`),
  KEY `IDX_CATALOG_PRODUCT_ENTITY_ENTITY_TYPE_ID` (`entity_type_id`),
  KEY `IDX_CATALOG_PRODUCT_ENTITY_ATTRIBUTE_SET_ID` (`attribute_set_id`),
  KEY `IDX_CATALOG_PRODUCT_ENTITY_SKU` (`sku`),
  CONSTRAINT `FK_CAT_PRD_ENTT_ATTR_SET_ID_EAV_ATTR_SET_ATTR_SET_ID` FOREIGN KEY (`attribute_set_id`) REFERENCES `eav_attribute_set` (`attribute_set_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_PRD_ENTT_ENTT_TYPE_ID_EAV_ENTT_TYPE_ENTT_TYPE_ID` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=186 DEFAULT CHARSET=utf8 COMMENT='Catalog Product Table';

--
-- Dumping data for table `catalog_product_entity`
--

INSERT INTO `catalog_product_entity` VALUES (167,10,9,'simple','JD1','2014-01-31 21:56:44','2014-01-31 22:06:29',0,0),(168,10,9,'simple','JD2','2014-01-31 22:14:45','2014-01-31 22:17:16',0,0),(169,10,9,'simple','JD3','2014-01-31 22:19:04','2014-01-31 22:22:12',0,0),(170,10,9,'simple','JD4','2014-01-31 22:24:23','2014-01-31 22:24:23',0,0),(171,10,9,'simple','JD5','2014-01-31 22:26:26','2014-01-31 22:26:26',0,0),(172,10,9,'simple','JD6','2014-01-31 22:27:46','2014-01-31 22:27:46',0,0),(173,10,9,'simple','JD7','2014-01-31 22:29:17','2014-01-31 22:29:17',0,0),(174,10,9,'simple','JD8','2014-01-31 22:30:45','2014-01-31 22:30:45',0,0),(175,10,9,'simple','JD9','2014-01-31 22:32:04','2014-01-31 22:32:04',0,0),(176,10,9,'simple','JD10','2014-01-31 22:33:26','2014-01-31 22:33:26',0,0),(177,10,9,'simple','JD11','2014-01-31 22:35:43','2014-01-31 22:35:43',0,0),(178,10,9,'simple','JD12','2014-01-31 22:37:02','2014-01-31 22:37:02',0,0),(179,10,9,'simple','JD13','2014-01-31 22:38:17','2014-01-31 22:38:17',0,0),(180,10,9,'simple','JD14','2014-01-31 22:39:27','2014-01-31 22:39:27',0,0),(181,10,9,'simple','JD15','2014-01-31 22:40:50','2014-01-31 22:40:50',0,0),(182,10,9,'simple','JD16','2014-01-31 22:42:02','2014-01-31 22:42:02',0,0),(183,10,9,'simple','JD17','2014-01-31 22:43:39','2014-01-31 22:43:39',0,0),(184,10,9,'simple','JD18','2014-01-31 22:44:45','2014-01-31 22:44:45',0,0),(185,10,9,'simple','SD19','2014-01-31 22:46:21','2014-01-31 22:46:21',0,0);

--
-- Table structure for table `catalog_product_entity_datetime`
--

CREATE TABLE `catalog_product_entity_datetime` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `entity_type_id` smallint(5) unsigned NOT NULL COMMENT 'Entity Type ID',
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `value` datetime DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `UNQ_CAT_PRD_ENTT_DTIME_ENTT_ID_ATTR_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `IDX_CATALOG_PRODUCT_ENTITY_DATETIME_ATTRIBUTE_ID` (`attribute_id`),
  KEY `IDX_CATALOG_PRODUCT_ENTITY_DATETIME_STORE_ID` (`store_id`),
  KEY `IDX_CATALOG_PRODUCT_ENTITY_DATETIME_ENTITY_ID` (`entity_id`),
  CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_DATETIME_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_PRD_ENTT_DTIME_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_PRD_ENTT_DTIME_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=utf8 COMMENT='Catalog Product Datetime Attribute Backend Table';

--
-- Dumping data for table `catalog_product_entity_datetime`
--

INSERT INTO `catalog_product_entity_datetime` VALUES (2,10,704,0,167,NULL),(3,10,705,0,167,NULL),(4,10,568,0,167,NULL),(5,10,569,0,167,NULL),(6,10,572,0,167,NULL),(7,10,573,0,167,NULL),(8,10,704,0,168,NULL),(9,10,705,0,168,NULL),(10,10,568,0,168,NULL),(11,10,569,0,168,NULL),(12,10,572,0,168,NULL),(13,10,573,0,168,NULL),(14,10,704,0,169,NULL),(15,10,705,0,169,NULL),(16,10,568,0,169,NULL),(17,10,569,0,169,NULL),(18,10,572,0,169,NULL),(19,10,573,0,169,NULL),(20,10,704,0,170,NULL),(21,10,705,0,170,NULL),(22,10,568,0,170,NULL),(23,10,569,0,170,NULL),(24,10,572,0,170,NULL),(25,10,573,0,170,NULL),(26,10,704,0,171,NULL),(27,10,705,0,171,NULL),(28,10,568,0,171,NULL),(29,10,569,0,171,NULL),(30,10,572,0,171,NULL),(31,10,573,0,171,NULL),(32,10,704,0,172,NULL),(33,10,705,0,172,NULL),(34,10,568,0,172,NULL),(35,10,569,0,172,NULL),(36,10,572,0,172,NULL),(37,10,573,0,172,NULL),(38,10,704,0,173,NULL),(39,10,705,0,173,NULL),(40,10,568,0,173,NULL),(41,10,569,0,173,NULL),(42,10,572,0,173,NULL),(43,10,573,0,173,NULL),(44,10,704,0,174,NULL),(45,10,705,0,174,NULL),(46,10,568,0,174,NULL),(47,10,569,0,174,NULL),(48,10,572,0,174,NULL),(49,10,573,0,174,NULL),(50,10,704,0,175,NULL),(51,10,705,0,175,NULL),(52,10,568,0,175,NULL),(53,10,569,0,175,NULL),(54,10,572,0,175,NULL),(55,10,573,0,175,NULL),(56,10,704,0,176,NULL),(57,10,705,0,176,NULL),(58,10,568,0,176,NULL),(59,10,569,0,176,NULL),(60,10,572,0,176,NULL),(61,10,573,0,176,NULL),(62,10,704,0,177,NULL),(63,10,705,0,177,NULL),(64,10,568,0,177,NULL),(65,10,569,0,177,NULL),(66,10,572,0,177,NULL),(67,10,573,0,177,NULL),(68,10,704,0,178,NULL),(69,10,705,0,178,NULL),(70,10,568,0,178,NULL),(71,10,569,0,178,NULL),(72,10,572,0,178,NULL),(73,10,573,0,178,NULL),(74,10,704,0,179,NULL),(75,10,705,0,179,NULL),(76,10,568,0,179,NULL),(77,10,569,0,179,NULL),(78,10,572,0,179,NULL),(79,10,573,0,179,NULL),(80,10,704,0,180,NULL),(81,10,705,0,180,NULL),(82,10,568,0,180,NULL),(83,10,569,0,180,NULL),(84,10,572,0,180,NULL),(85,10,573,0,180,NULL),(86,10,704,0,181,NULL),(87,10,705,0,181,NULL),(88,10,568,0,181,NULL),(89,10,569,0,181,NULL),(90,10,572,0,181,NULL),(91,10,573,0,181,NULL),(92,10,704,0,182,NULL),(93,10,705,0,182,NULL),(94,10,568,0,182,NULL),(95,10,569,0,182,NULL),(96,10,572,0,182,NULL),(97,10,573,0,182,NULL),(98,10,704,0,183,NULL),(99,10,705,0,183,NULL),(100,10,568,0,183,NULL),(101,10,569,0,183,NULL),(102,10,572,0,183,NULL),(103,10,573,0,183,NULL),(104,10,704,0,184,NULL),(105,10,705,0,184,NULL),(106,10,568,0,184,NULL),(107,10,569,0,184,NULL),(108,10,572,0,184,NULL),(109,10,573,0,184,NULL),(110,10,704,0,185,NULL),(111,10,705,0,185,NULL),(112,10,568,0,185,NULL),(113,10,569,0,185,NULL),(114,10,572,0,185,NULL),(115,10,573,0,185,NULL);

--
-- Table structure for table `catalog_product_entity_decimal`
--

CREATE TABLE `catalog_product_entity_decimal` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `entity_type_id` smallint(5) unsigned NOT NULL COMMENT 'Entity Type ID',
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `value` decimal(12,4) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `UNQ_CAT_PRD_ENTT_DEC_ENTT_ID_ATTR_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `IDX_CATALOG_PRODUCT_ENTITY_DECIMAL_STORE_ID` (`store_id`),
  KEY `IDX_CATALOG_PRODUCT_ENTITY_DECIMAL_ENTITY_ID` (`entity_id`),
  KEY `IDX_CATALOG_PRODUCT_ENTITY_DECIMAL_ATTRIBUTE_ID` (`attribute_id`),
  CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_DECIMAL_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_PRD_ENTT_DEC_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_PRD_ENTT_DEC_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=506 DEFAULT CHARSET=utf8 COMMENT='Catalog Product Decimal Attribute Backend Table';

--
-- Dumping data for table `catalog_product_entity_decimal`
--

INSERT INTO `catalog_product_entity_decimal` VALUES (411,10,101,0,167,5.0000),(412,10,99,0,167,205.0000),(413,10,100,0,167,NULL),(414,10,567,0,167,NULL),(415,10,943,0,167,NULL),(416,10,101,0,168,0.0000),(417,10,99,0,168,160.0000),(418,10,100,0,168,NULL),(419,10,567,0,168,NULL),(420,10,943,0,168,NULL),(421,10,101,0,169,0.0000),(422,10,99,0,169,160.0000),(423,10,100,0,169,NULL),(424,10,567,0,169,NULL),(425,10,943,0,169,NULL),(426,10,101,0,170,0.0000),(427,10,99,0,170,145.0000),(428,10,100,0,170,NULL),(429,10,567,0,170,NULL),(430,10,943,0,170,NULL),(431,10,101,0,171,0.0000),(432,10,99,0,171,145.0000),(433,10,100,0,171,NULL),(434,10,567,0,171,NULL),(435,10,943,0,171,NULL),(436,10,101,0,172,0.0000),(437,10,99,0,172,145.0000),(438,10,100,0,172,NULL),(439,10,567,0,172,NULL),(440,10,943,0,172,NULL),(441,10,101,0,173,21.5000),(442,10,99,0,173,205.0000),(443,10,100,0,173,NULL),(444,10,567,0,173,NULL),(445,10,943,0,173,NULL),(446,10,101,0,174,12.1000),(447,10,99,0,174,150.0000),(448,10,100,0,174,NULL),(449,10,567,0,174,NULL),(450,10,943,0,174,NULL),(451,10,101,0,175,0.0000),(452,10,99,0,175,135.0000),(453,10,100,0,175,NULL),(454,10,567,0,175,NULL),(455,10,943,0,175,NULL),(456,10,101,0,176,0.0000),(457,10,99,0,176,55.0000),(458,10,100,0,176,NULL),(459,10,567,0,176,NULL),(460,10,943,0,176,NULL),(461,10,101,0,177,0.0000),(462,10,99,0,177,135.0000),(463,10,100,0,177,NULL),(464,10,567,0,177,NULL),(465,10,943,0,177,NULL),(466,10,101,0,178,0.0000),(467,10,99,0,178,115.0000),(468,10,100,0,178,NULL),(469,10,567,0,178,NULL),(470,10,943,0,178,NULL),(471,10,101,0,179,0.0000),(472,10,99,0,179,55.0000),(473,10,100,0,179,NULL),(474,10,567,0,179,NULL),(475,10,943,0,179,NULL),(476,10,101,0,180,0.0000),(477,10,99,0,180,55.0000),(478,10,100,0,180,NULL),(479,10,567,0,180,NULL),(480,10,943,0,180,NULL),(481,10,101,0,181,0.0000),(482,10,99,0,181,55.0000),(483,10,100,0,181,NULL),(484,10,567,0,181,NULL),(485,10,943,0,181,NULL),(486,10,101,0,182,0.0000),(487,10,99,0,182,55.0000),(488,10,100,0,182,NULL),(489,10,567,0,182,NULL),(490,10,943,0,182,NULL),(491,10,101,0,183,0.0000),(492,10,99,0,183,55.0000),(493,10,100,0,183,NULL),(494,10,567,0,183,NULL),(495,10,943,0,183,NULL),(496,10,101,0,184,0.0000),(497,10,99,0,184,55.0000),(498,10,100,0,184,NULL),(499,10,567,0,184,NULL),(500,10,943,0,184,NULL),(501,10,101,0,185,0.0000),(502,10,99,0,185,125.0000),(503,10,100,0,185,NULL),(504,10,567,0,185,NULL),(505,10,943,0,185,NULL);

--
-- Table structure for table `catalog_product_entity_gallery`
--

CREATE TABLE `catalog_product_entity_gallery` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `entity_type_id` smallint(5) unsigned NOT NULL COMMENT 'Entity Type ID',
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `position` int(11) NOT NULL COMMENT 'Position',
  `value` varchar(255) NOT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `UNQ_CAT_PRD_ENTT_GLR_ENTT_TYPE_ID_ENTT_ID_ATTR_ID_STORE_ID` (`entity_type_id`,`entity_id`,`attribute_id`,`store_id`),
  KEY `IDX_CATALOG_PRODUCT_ENTITY_GALLERY_ENTITY_ID` (`entity_id`),
  KEY `IDX_CATALOG_PRODUCT_ENTITY_GALLERY_ATTRIBUTE_ID` (`attribute_id`),
  KEY `IDX_CATALOG_PRODUCT_ENTITY_GALLERY_STORE_ID` (`store_id`),
  CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_GALLERY_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_PRD_ENTT_GLR_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_PRD_ENTT_GLR_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Gallery Attribute Backend Table';

--
-- Dumping data for table `catalog_product_entity_gallery`
--


--
-- Table structure for table `catalog_product_entity_group_price`
--

CREATE TABLE `catalog_product_entity_group_price` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `all_groups` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Is Applicable To All Customer Groups',
  `customer_group_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Customer Group ID',
  `value` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Value',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CC12C83765B562314470A24F2BDD0F36` (`entity_id`,`all_groups`,`customer_group_id`,`website_id`),
  KEY `IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_ENTITY_ID` (`entity_id`),
  KEY `IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_CUSTOMER_GROUP_ID` (`customer_group_id`),
  KEY `IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_WEBSITE_ID` (`website_id`),
  CONSTRAINT `FK_CAT_PRD_ENTT_GROUP_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_PRD_ENTT_GROUP_PRICE_WS_ID_CORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_DF909D22C11B60B1E5E3EE64AB220ECE` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Group Price Attribute Backend Table';

--
-- Dumping data for table `catalog_product_entity_group_price`
--


--
-- Table structure for table `catalog_product_entity_int`
--

CREATE TABLE `catalog_product_entity_int` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `entity_type_id` int(10) unsigned NOT NULL COMMENT 'Entity Type ID',
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `value` int(11) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `UNQ_CATALOG_PRODUCT_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `IDX_CATALOG_PRODUCT_ENTITY_INT_ATTRIBUTE_ID` (`attribute_id`),
  KEY `IDX_CATALOG_PRODUCT_ENTITY_INT_STORE_ID` (`store_id`),
  KEY `IDX_CATALOG_PRODUCT_ENTITY_INT_ENTITY_ID` (`entity_id`),
  CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_INT_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_PRD_ENTT_INT_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_PRD_ENTT_INT_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=801 DEFAULT CHARSET=utf8 COMMENT='Catalog Product Integer Attribute Backend Table';

--
-- Dumping data for table `catalog_product_entity_int`
--

INSERT INTO `catalog_product_entity_int` VALUES (687,10,273,0,167,1),(688,10,274,0,167,0),(689,10,526,0,167,4),(690,10,102,0,167,NULL),(691,10,272,0,167,59),(692,10,935,0,167,0),(693,10,273,0,168,1),(694,10,274,0,168,0),(695,10,526,0,168,4),(696,10,102,0,168,NULL),(697,10,272,0,168,25),(698,10,935,0,168,0),(699,10,273,0,169,1),(700,10,274,0,169,0),(701,10,526,0,169,4),(702,10,102,0,169,NULL),(703,10,272,0,169,59),(704,10,935,0,169,0),(705,10,273,0,170,1),(706,10,274,0,170,0),(707,10,526,0,170,4),(708,10,102,0,170,NULL),(709,10,272,0,170,NULL),(710,10,935,0,170,0),(711,10,273,0,171,1),(712,10,274,0,171,0),(713,10,526,0,171,4),(714,10,102,0,171,NULL),(715,10,272,0,171,NULL),(716,10,935,0,171,0),(717,10,273,0,172,1),(718,10,274,0,172,0),(719,10,526,0,172,4),(720,10,102,0,172,NULL),(721,10,272,0,172,NULL),(722,10,935,0,172,0),(723,10,273,0,173,1),(724,10,274,0,173,0),(725,10,526,0,173,4),(726,10,102,0,173,NULL),(727,10,272,0,173,NULL),(728,10,935,0,173,0),(729,10,273,0,174,1),(730,10,274,0,174,0),(731,10,526,0,174,4),(732,10,102,0,174,NULL),(733,10,272,0,174,NULL),(734,10,935,0,174,0),(735,10,273,0,175,1),(736,10,274,0,175,0),(737,10,526,0,175,4),(738,10,102,0,175,NULL),(739,10,272,0,175,NULL),(740,10,935,0,175,0),(741,10,273,0,176,1),(742,10,274,0,176,0),(743,10,526,0,176,4),(744,10,102,0,176,NULL),(745,10,272,0,176,NULL),(746,10,935,0,176,0),(747,10,273,0,177,1),(748,10,274,0,177,0),(749,10,526,0,177,4),(750,10,102,0,177,NULL),(751,10,272,0,177,NULL),(752,10,935,0,177,0),(753,10,273,0,178,1),(754,10,274,0,178,0),(755,10,526,0,178,4),(756,10,102,0,178,NULL),(757,10,272,0,178,NULL),(758,10,935,0,178,0),(759,10,273,0,179,1),(760,10,274,0,179,0),(761,10,526,0,179,4),(762,10,102,0,179,NULL),(763,10,272,0,179,NULL),(764,10,935,0,179,0),(765,10,273,0,180,1),(766,10,274,0,180,0),(767,10,526,0,180,4),(768,10,102,0,180,NULL),(769,10,272,0,180,NULL),(770,10,935,0,180,0),(771,10,273,0,181,1),(772,10,274,0,181,0),(773,10,526,0,181,4),(774,10,102,0,181,NULL),(775,10,272,0,181,NULL),(776,10,935,0,181,0),(777,10,273,0,182,1),(778,10,274,0,182,0),(779,10,526,0,182,4),(780,10,102,0,182,NULL),(781,10,272,0,182,NULL),(782,10,935,0,182,0),(783,10,273,0,183,1),(784,10,274,0,183,0),(785,10,526,0,183,4),(786,10,102,0,183,NULL),(787,10,272,0,183,NULL),(788,10,935,0,183,0),(789,10,273,0,184,1),(790,10,274,0,184,0),(791,10,526,0,184,4),(792,10,102,0,184,NULL),(793,10,272,0,184,NULL),(794,10,935,0,184,0),(795,10,273,0,185,1),(796,10,274,0,185,0),(797,10,526,0,185,4),(798,10,102,0,185,NULL),(799,10,272,0,185,NULL),(800,10,935,0,185,0);

--
-- Table structure for table `catalog_product_entity_media_gallery`
--

CREATE TABLE `catalog_product_entity_media_gallery` (
  `value_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  KEY `IDX_CATALOG_PRODUCT_ENTITY_MEDIA_GALLERY_ATTRIBUTE_ID` (`attribute_id`),
  KEY `IDX_CATALOG_PRODUCT_ENTITY_MEDIA_GALLERY_ENTITY_ID` (`entity_id`),
  CONSTRAINT `FK_CAT_PRD_ENTT_MDA_GLR_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_PRD_ENTT_MDA_GLR_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=460 DEFAULT CHARSET=utf8 COMMENT='Catalog Product Media Gallery Attribute Backend Table';

--
-- Dumping data for table `catalog_product_entity_media_gallery`
--

INSERT INTO `catalog_product_entity_media_gallery` VALUES (366,703,167,'/s/e/set1b.jpg'),(367,703,167,'/s/e/set1d.jpg'),(368,703,167,'/s/e/set1a.jpg'),(369,703,167,'/s/e/set1c.jpg'),(370,703,168,'/s/e/set2c.jpg'),(371,703,168,'/s/e/set2d.jpg'),(372,703,168,'/s/e/set2a.jpg'),(373,703,168,'/s/e/set2b.jpg'),(378,703,169,'/s/e/set3c.jpg'),(379,703,169,'/s/e/set3b.jpg'),(380,703,169,'/s/e/set3d.jpg'),(381,703,169,'/s/e/set3a.jpg'),(382,703,170,'/s/e/set4c.jpg'),(383,703,170,'/s/e/set4b.jpg'),(384,703,170,'/s/e/set4a.jpg'),(385,703,170,'/s/e/set4d.jpg'),(386,703,171,'/s/e/set5d.jpg'),(387,703,171,'/s/e/set5b.jpg'),(388,703,171,'/s/e/set5a.jpg'),(389,703,171,'/s/e/set5c.jpg'),(390,703,172,'/s/e/set6c.jpg'),(391,703,172,'/s/e/set6a.jpg'),(392,703,172,'/s/e/set6d.jpg'),(393,703,172,'/s/e/set6b.jpg'),(394,703,173,'/s/e/set7d.jpg'),(395,703,173,'/s/e/set7b.jpg'),(396,703,173,'/s/e/set7a.jpg'),(397,703,173,'/s/e/set7c.jpg'),(398,703,174,'/s/e/set8a.jpg'),(399,703,174,'/s/e/set8c.jpg'),(400,703,174,'/s/e/set8b.jpg'),(401,703,175,'/s/e/set9d.jpg'),(402,703,175,'/s/e/set9e.jpg'),(403,703,175,'/s/e/set9c.jpg'),(404,703,175,'/s/e/set9b.jpg'),(405,703,175,'/s/e/set9a.jpg'),(406,703,176,'/s/e/set10c.jpg'),(407,703,176,'/s/e/set10b.jpg'),(408,703,176,'/s/e/set10d.jpg'),(409,703,176,'/s/e/set10e.jpg'),(410,703,176,'/s/e/set10a.jpg'),(411,703,177,'/s/e/set11b.jpg'),(412,703,177,'/s/e/set11a.jpg'),(413,703,177,'/s/e/set11e.jpg'),(414,703,177,'/s/e/set11d.jpg'),(415,703,177,'/s/e/set11c.jpg'),(416,703,178,'/s/e/set12a.jpg'),(417,703,178,'/s/e/set12c.jpg'),(418,703,178,'/s/e/set12b.jpg'),(419,703,178,'/s/e/set12e.jpg'),(420,703,178,'/s/e/set12d.jpg'),(421,703,179,'/s/e/set13b.jpg'),(422,703,179,'/s/e/set13c.jpg'),(423,703,179,'/s/e/set13d.jpg'),(424,703,179,'/s/e/set13a.jpg'),(425,703,179,'/s/e/set13f.jpg'),(426,703,179,'/s/e/set13e.jpg'),(427,703,180,'/s/e/set14b.jpg'),(428,703,180,'/s/e/set14a.jpg'),(429,703,180,'/s/e/set14c.jpg'),(430,703,181,'/s/e/set15b.jpg'),(431,703,181,'/s/e/set15c.jpg'),(432,703,181,'/s/e/set15e.jpg'),(433,703,181,'/s/e/set15a.jpg'),(434,703,181,'/s/e/set15d.jpg'),(435,703,181,'/s/e/set15f.jpg'),(436,703,182,'/s/e/set16d.jpg'),(437,703,182,'/s/e/set16a.jpg'),(438,703,182,'/s/e/set16c.jpg'),(439,703,182,'/s/e/set16b.jpg'),(440,703,182,'/s/e/set16e.jpg'),(441,703,182,'/s/e/set16f.jpg'),(442,703,183,'/s/e/set17f.jpg'),(443,703,183,'/s/e/set17a.jpg'),(444,703,183,'/s/e/set17c.jpg'),(445,703,183,'/s/e/set17b.jpg'),(446,703,183,'/s/e/set17e.jpg'),(447,703,183,'/s/e/set17d.jpg'),(448,703,184,'/s/e/set18e.jpg'),(449,703,184,'/s/e/set18c.jpg'),(450,703,184,'/s/e/set18d.jpg'),(451,703,184,'/s/e/set18a.jpg'),(452,703,184,'/s/e/set18b.jpg'),(453,703,184,'/s/e/set18f.jpg'),(454,703,185,'/s/e/set19a.jpg'),(455,703,185,'/s/e/set19e.jpg'),(456,703,185,'/s/e/set19d.jpg'),(457,703,185,'/s/e/set19b.jpg'),(458,703,185,'/s/e/set19f.jpg'),(459,703,185,'/s/e/set19c.jpg');

--
-- Table structure for table `catalog_product_entity_media_gallery_value`
--

CREATE TABLE `catalog_product_entity_media_gallery_value` (
  `value_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Value ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `label` varchar(255) DEFAULT NULL COMMENT 'Label',
  `position` int(10) unsigned DEFAULT NULL COMMENT 'Position',
  `disabled` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Disabled',
  PRIMARY KEY (`value_id`,`store_id`),
  KEY `IDX_CATALOG_PRODUCT_ENTITY_MEDIA_GALLERY_VALUE_STORE_ID` (`store_id`),
  CONSTRAINT `FK_CAT_PRD_ENTT_MDA_GLR_VAL_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_PRD_ENTT_MDA_GLR_VAL_VAL_ID_CAT_PRD_ENTT_MDA_GLR_VAL_ID` FOREIGN KEY (`value_id`) REFERENCES `catalog_product_entity_media_gallery` (`value_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Media Gallery Attribute Value Table';

--
-- Dumping data for table `catalog_product_entity_media_gallery_value`
--

INSERT INTO `catalog_product_entity_media_gallery_value` VALUES (366,0,NULL,1,0),(366,1,NULL,1,0),(367,0,NULL,2,0),(367,1,NULL,2,0),(368,0,NULL,3,0),(368,1,NULL,3,0),(369,0,NULL,4,0),(369,1,NULL,4,0),(370,0,NULL,1,0),(371,0,NULL,2,0),(372,0,NULL,3,0),(373,0,NULL,4,0),(378,0,NULL,5,0),(379,0,NULL,6,0),(380,0,NULL,7,0),(381,0,NULL,8,0),(382,0,NULL,1,0),(383,0,NULL,2,0),(384,0,NULL,3,0),(385,0,NULL,4,0),(386,0,NULL,1,0),(387,0,NULL,2,0),(388,0,NULL,3,0),(389,0,NULL,4,0),(390,0,NULL,1,0),(391,0,NULL,2,0),(392,0,NULL,3,0),(393,0,NULL,4,0),(394,0,NULL,1,0),(395,0,NULL,2,0),(396,0,NULL,3,0),(397,0,NULL,4,0),(398,0,NULL,1,0),(399,0,NULL,2,0),(400,0,NULL,3,0),(401,0,NULL,1,0),(402,0,NULL,2,0),(403,0,NULL,3,0),(404,0,NULL,4,0),(405,0,NULL,5,0),(406,0,NULL,1,0),(407,0,NULL,2,0),(408,0,NULL,3,0),(409,0,NULL,4,0),(410,0,NULL,5,0),(411,0,NULL,1,0),(412,0,NULL,2,0),(413,0,NULL,3,0),(414,0,NULL,4,0),(415,0,NULL,5,0),(416,0,NULL,1,0),(417,0,NULL,2,0),(418,0,NULL,3,0),(419,0,NULL,4,0),(420,0,NULL,5,0),(421,0,NULL,1,0),(422,0,NULL,2,0),(423,0,NULL,3,0),(424,0,NULL,4,0),(425,0,NULL,5,0),(426,0,NULL,6,0),(427,0,NULL,1,0),(428,0,NULL,2,0),(429,0,NULL,3,0),(430,0,NULL,1,0),(431,0,NULL,2,0),(432,0,NULL,3,0),(433,0,NULL,4,0),(434,0,NULL,5,0),(435,0,NULL,6,0),(436,0,NULL,1,0),(437,0,NULL,2,0),(438,0,NULL,3,0),(439,0,NULL,4,0),(440,0,NULL,5,0),(441,0,NULL,6,0),(442,0,NULL,1,0),(443,0,NULL,2,0),(444,0,NULL,3,0),(445,0,NULL,4,0),(446,0,NULL,5,0),(447,0,NULL,6,0),(448,0,NULL,1,0),(449,0,NULL,2,0),(450,0,NULL,3,0),(451,0,NULL,4,0),(452,0,NULL,5,0),(453,0,NULL,6,0),(454,0,NULL,1,0),(455,0,NULL,2,0),(456,0,NULL,3,0),(457,0,NULL,4,0),(458,0,NULL,5,0),(459,0,NULL,6,0);

--
-- Table structure for table `catalog_product_entity_text`
--

CREATE TABLE `catalog_product_entity_text` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `entity_type_id` int(10) unsigned NOT NULL COMMENT 'Entity Type ID',
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `value` text COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `UNQ_CATALOG_PRODUCT_ENTITY_TEXT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `IDX_CATALOG_PRODUCT_ENTITY_TEXT_ATTRIBUTE_ID` (`attribute_id`),
  KEY `IDX_CATALOG_PRODUCT_ENTITY_TEXT_STORE_ID` (`store_id`),
  KEY `IDX_CATALOG_PRODUCT_ENTITY_TEXT_ENTITY_ID` (`entity_id`),
  CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_TEXT_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_PRD_ENTT_TEXT_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_PRD_ENTT_TEXT_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=769 DEFAULT CHARSET=utf8 COMMENT='Catalog Product Text Attribute Backend Table';

--
-- Dumping data for table `catalog_product_entity_text`
--

INSERT INTO `catalog_product_entity_text` VALUES (693,10,104,0,167,NULL),(694,10,97,0,167,'HEYS COLLECTION \r\n\r\nMATERIAL \r\nPOLYCARBONATE WITH A HIGH GLOSS FINISH \r\n\r\nSIZES \r\n14 IN X 10 IN X 21 IN \r\n22 IN X 14.5 IN X 11 IN\r\n26 IN X 18 IN X 12 IN \r\n\r\nWEIGHT \r\n14 IN 5 LBS \r\n22 IN 7.1 LBS \r\n26 IN 9.4 LBS \r\n\r\nWHEELS \r\nFOUR DUAL SPINNER WHEELS  '),(695,10,506,0,167,'HEYS COLLECTION \r\n\r\nMATERIAL \r\nPOLYCARBONATE WITH A HIGH GLOSS FINISH \r\n\r\nSIZES \r\n14 IN X 10 IN X 21 IN \r\n22 IN X 14.5 IN X 11 IN\r\n26 IN X 18 IN X 12 IN \r\n\r\nWEIGHT \r\n14 IN 5 LBS \r\n22 IN 7.1 LBS \r\n26 IN 9.4 LBS \r\n\r\nWHEELS \r\nFOUR DUAL SPINNER WHEELS  '),(696,10,531,0,167,NULL),(697,10,104,0,168,NULL),(698,10,97,0,168,'THIS BEAUTIFUL LUGGAGE SET IS BRAND NEW!!! \r\n\r\nLOUIS KAISER COLLECTION \r\n\r\nMATERIAL \r\n\r\nPOLYESTER WITH POLYCARBONATE CORNERS \r\n\r\nSIZES \r\n\r\n20 H X 14 W X 9.5 L  \r\n24 H X 17 W X 10 L\r\n28 H X 18.5 W X 12 L \r\n\r\nWHEELS \r\n\r\nFOUR DUAL SPINNER WHEELS'),(699,10,506,0,168,'THIS BEAUTIFUL LUGGAGE SET IS BRAND NEW!!! \r\n\r\nLOUIS KAISER COLLECTION \r\n\r\nMATERIAL \r\n\r\nPOLYESTER WITH POLYCARBONATE CORNERS \r\n\r\nSIZES \r\n\r\n20 H X 14 W X 9.5 L  \r\n24 H X 17 W X 10 L\r\n28 H X 18.5 W X 12 L \r\n\r\nWHEELS \r\n\r\nFOUR DUAL SPINNER WHEELS'),(700,10,531,0,168,NULL),(701,10,104,0,169,NULL),(702,10,97,0,169,'THIS BEAUTIFUL LUGGAGE SET IS BRAND NEW!!! \r\n\r\nLOUIS KAISER COLLECTION \r\n\r\nMATERIAL \r\n\r\nPOLYESTER WITH POLYCARBONATE CORNERS \r\n\r\nSIZES \r\n\r\n20 H X 14 W X 9.5 L  \r\n24 H X 17 W X 10 L\r\n28 H X 18.5 W X 12 L \r\n\r\nWHEELS \r\n\r\nFOUR DUAL SPINNER WHEELS'),(703,10,506,0,169,'THIS BEAUTIFUL LUGGAGE SET IS BRAND NEW!!! \r\n\r\nLOUIS KAISER COLLECTION \r\n\r\nMATERIAL \r\n\r\nPOLYESTER WITH POLYCARBONATE CORNERS \r\n\r\nSIZES \r\n\r\n20 H X 14 W X 9.5 L  \r\n24 H X 17 W X 10 L\r\n28 H X 18.5 W X 12 L \r\n\r\nWHEELS \r\n\r\nFOUR DUAL SPINNER WHEELS'),(704,10,531,0,169,NULL),(705,10,104,0,170,NULL),(706,10,97,0,170,'THIS BEAUTIFUL LUGGAGE SET IS BRAND NEW!!! \r\n\r\nAMERICAN TRAVEL COLLECTION \r\n\r\nMATERIAL \r\n\r\nPOLYCARBONATE WITH A HIGH GLOSS FINISH\r\n\r\nSIZES \r\n\r\n22 H X 15 W X 10 L \r\n26 H X 17 W X 10 L\r\n30 H X 20 W X 12 L\r\n\r\nWHEELS \r\n\r\nFOUR DUAL SPINNER WHEELS '),(707,10,506,0,170,'THIS BEAUTIFUL LUGGAGE SET IS BRAND NEW!!! \r\n\r\nAMERICAN TRAVEL COLLECTION \r\n\r\nMATERIAL \r\n\r\nPOLYCARBONATE WITH A HIGH GLOSS FINISH\r\n\r\nSIZES \r\n\r\n22 H X 15 W X 10 L \r\n26 H X 17 W X 10 L\r\n30 H X 20 W X 12 L\r\n\r\nWHEELS \r\n\r\nFOUR DUAL SPINNER WHEELS '),(708,10,531,0,170,NULL),(709,10,104,0,171,NULL),(710,10,97,0,171,'THIS BEAUTIFUL LUGGAGE SET IS BRAND NEW!!! \r\n\r\nAMERICAN TRAVEL COLLECTION \r\n\r\nMATERIAL \r\n\r\nPOLYCARBONATE WITH A HIGH GLOSS FINISH\r\n\r\nSIZES \r\n\r\n22 H X 15 W X 10 L \r\n26 H X 17 W X 10 L\r\n30 H X 20 W X 12 L\r\n\r\nWHEELS \r\n\r\nFOUR DUAL SPINNER WHEELS  '),(711,10,506,0,171,'THIS BEAUTIFUL LUGGAGE SET IS BRAND NEW!!! \r\n\r\nAMERICAN TRAVEL COLLECTION \r\n\r\nMATERIAL \r\n\r\nPOLYCARBONATE WITH A HIGH GLOSS FINISH\r\n\r\nSIZES \r\n\r\n22 H X 15 W X 10 L \r\n26 H X 17 W X 10 L\r\n30 H X 20 W X 12 L\r\n\r\nWHEELS \r\n\r\nFOUR DUAL SPINNER WHEELS  '),(712,10,531,0,171,NULL),(713,10,104,0,172,NULL),(714,10,97,0,172,'THIS BEAUTIFUL LUGGAGE SET IS BRAND NEW!!! \r\n\r\nTRAVEL CONCEPTS COLLECTION \r\n\r\nMATERIAL \r\n\r\nPOLYCARBONATE WITH A HIGH GLOSS FINISH\r\n\r\nSIZES \r\n\r\n22 H X 15 W X 10 L \r\n26 H X 17 W X 10 L\r\n30 H X 20 W X 12 L\r\n\r\nWHEELS \r\n\r\nFOUR DUAL SPINNER WHEELS  \r\nINCLUDES A LOCK FOR EACH SET '),(715,10,506,0,172,'THIS BEAUTIFUL LUGGAGE SET IS BRAND NEW!!! \r\n\r\nTRAVEL CONCEPTS COLLECTION \r\n\r\nMATERIAL \r\n\r\nPOLYCARBONATE WITH A HIGH GLOSS FINISH\r\n\r\nSIZES \r\n\r\n22 H X 15 W X 10 L \r\n26 H X 17 W X 10 L\r\n30 H X 20 W X 12 L\r\n\r\nWHEELS \r\n\r\nFOUR DUAL SPINNER WHEELS  \r\nINCLUDES A LOCK FOR EACH SET '),(716,10,531,0,172,NULL),(717,10,104,0,173,NULL),(718,10,97,0,173,'HEYS COLLECTION \r\n\r\nMATERIAL \r\nPOLYCARBONATE WITH A HIGH GLOSS FINISH \r\n\r\nSIZES \r\n14 IN X 10 IN X 21 IN \r\n22 IN X 14.5 IN X 11 IN\r\n26 IN X 18 IN X 12 IN \r\n\r\nWEIGHT \r\n14 IN 5 LBS \r\n22 IN 7.1 LBS \r\n26 IN 9.4 LBS \r\n\r\nWHEELS \r\nFOUR DUAL SPINNER WHEELS '),(719,10,506,0,173,'HEYS COLLECTION \r\n\r\nMATERIAL \r\nPOLYCARBONATE WITH A HIGH GLOSS FINISH \r\n\r\nSIZES \r\n14 IN X 10 IN X 21 IN \r\n22 IN X 14.5 IN X 11 IN\r\n26 IN X 18 IN X 12 IN \r\n\r\nWEIGHT \r\n14 IN 5 LBS \r\n22 IN 7.1 LBS \r\n26 IN 9.4 LBS \r\n\r\nWHEELS \r\nFOUR DUAL SPINNER WHEELS '),(720,10,531,0,173,NULL),(721,10,104,0,174,NULL),(722,10,97,0,174,'\r\nHEYS COLLECTION \r\n\r\nMATERIAL \r\nPOLYCARBONATE WITH A HIGH GLOSS FINISH \r\n\r\nSIZES \r\n14 IN X 10 IN X 21 IN \r\n22 IN X 14.5 IN X 11 IN\r\n\r\nWEIGHT \r\n14 IN 5 LBS \r\n22 IN 7.1 LBS \r\n\r\nWHEELS \r\nFOUR DUAL SPINNER WHEELS '),(723,10,506,0,174,'\r\nHEYS COLLECTION \r\n\r\nMATERIAL \r\nPOLYCARBONATE WITH A HIGH GLOSS FINISH \r\n\r\nSIZES \r\n14 IN X 10 IN X 21 IN \r\n22 IN X 14.5 IN X 11 IN\r\n\r\nWEIGHT \r\n14 IN 5 LBS \r\n22 IN 7.1 LBS \r\n\r\nWHEELS \r\nFOUR DUAL SPINNER WHEELS '),(724,10,531,0,174,NULL),(725,10,104,0,175,NULL),(726,10,97,0,175,'THIS BEAUTIFUL LUGGAGE SET IS BRAND NEW!!! STILL HAS PROTECTIVE PLASTIC FILM!!\r\n\r\nTRAVEL CONCEPTS COLLECTION \r\n\r\nMATERIAL \r\nPOLYCARBONATE WITH A HIGH GLOSS FINISH\r\n\r\nSIZES \r\n22 H X 15 W X 10 L \r\n26 H X 17 W X 10 L\r\n30 H X 20 W X 12 L\r\n\r\nWHEELS \r\nFOUR DUAL SPINNER WHEELS  \r\nINCLUDES A LOCK FOR EACH SET'),(727,10,506,0,175,'THIS BEAUTIFUL LUGGAGE SET IS BRAND NEW!!! STILL HAS PROTECTIVE PLASTIC FILM!!\r\n\r\nTRAVEL CONCEPTS COLLECTION \r\n\r\nMATERIAL \r\nPOLYCARBONATE WITH A HIGH GLOSS FINISH\r\n\r\nSIZES \r\n22 H X 15 W X 10 L \r\n26 H X 17 W X 10 L\r\n30 H X 20 W X 12 L\r\n\r\nWHEELS \r\nFOUR DUAL SPINNER WHEELS  \r\nINCLUDES A LOCK FOR EACH SET'),(728,10,531,0,175,NULL),(729,10,104,0,176,NULL),(730,10,97,0,176,'As the world’s first hard side zippered pocket system, P2Drive has a multi-function. Complete with multiple \r\nzippered pockets and compartments, you’ll stay organized on every trip. Ergonomically designed, telescopic \r\nhandle system with easy, one-hand, push button use and cushioned TPR grip that fits easily in your hand. \r\nFully lined interior with convenient tie-down straps to hold your clothes secure during travel. The \r\nmulti-use organizational pocket also doubles as a divider, keeping all items secure. Dual wheel spinner \r\nsystem provides smooth and effortless movement for your life on the go. Polycarbonate \r\nDimensions: 21\" x 14\" x 10\".'),(731,10,506,0,176,'As the world’s first hard side zippered pocket system, P2Drive has a multi-function. Complete with multiple \r\nzippered pockets and compartments, you’ll stay organized on every trip. Ergonomically designed, telescopic \r\nhandle system with easy, one-hand, push button use and cushioned TPR grip that fits easily in your hand. \r\nFully lined interior with convenient tie-down straps to hold your clothes secure during travel. The \r\nmulti-use organizational pocket also doubles as a divider, keeping all items secure. Dual wheel spinner \r\nsystem provides smooth and effortless movement for your life on the go. Polycarbonate \r\nDimensions: 21\" x 14\" x 10\".'),(732,10,531,0,176,NULL),(733,10,104,0,177,NULL),(734,10,97,0,177,'THIS BEAUTIFUL LUGGAGE SET IS BRAND NEW!!! \r\n\r\nTRAVEL CONCEPTS COLLECTION \r\n\r\nMATERIAL \r\nPOLYCARBONATE WITH A HIGH GLOSS FINISH\r\n\r\nSIZES \r\n22 H X 15 W X 10 L \r\n26 H X 17 W X 10 L\r\n30 H X 20 W X 12 L\r\n\r\nWHEELS \r\nFOUR DUAL SPINNER WHEELS  \r\nINCLUDES A LOCK FOR EACH SET '),(735,10,506,0,177,'THIS BEAUTIFUL LUGGAGE SET IS BRAND NEW!!! \r\n\r\nTRAVEL CONCEPTS COLLECTION \r\n\r\nMATERIAL \r\nPOLYCARBONATE WITH A HIGH GLOSS FINISH\r\n\r\nSIZES \r\n22 H X 15 W X 10 L \r\n26 H X 17 W X 10 L\r\n30 H X 20 W X 12 L\r\n\r\nWHEELS \r\nFOUR DUAL SPINNER WHEELS  \r\nINCLUDES A LOCK FOR EACH SET '),(736,10,531,0,177,NULL),(737,10,104,0,178,NULL),(738,10,97,0,178,'THIS BEAUTIFUL LUGGAGE SET IS BRAND NEW!!! \r\n\r\nLOUIES BERRY COLLECTION \r\n\r\nMATERIAL \r\nPOLYCARBONATE WITH A HIGH GLOSS FINISH\r\n\r\nSIZES \r\n20 H X 8 W X 15 L \r\n24 H X 10 W X 16 L\r\n28 H X 11 W X 20 L\r\n\r\nWHEELS \r\nDUAL WHEELS '),(739,10,506,0,178,'THIS BEAUTIFUL LUGGAGE SET IS BRAND NEW!!! \r\n\r\nLOUIES BERRY COLLECTION \r\n\r\nMATERIAL \r\nPOLYCARBONATE WITH A HIGH GLOSS FINISH\r\n\r\nSIZES \r\n20 H X 8 W X 15 L \r\n24 H X 10 W X 16 L\r\n28 H X 11 W X 20 L\r\n\r\nWHEELS \r\nDUAL WHEELS '),(740,10,531,0,178,NULL),(741,10,104,0,179,NULL),(742,10,97,0,179,'Complete with multiple zippered pockets and compartments, you’ll stay organized on every trip. Ergonomically designed, telescopic handle system with easy, one-hand, push button use and cushioned TPR grip that fits easily in your hand. Fully lined interior with convenient tie-down straps to hold your clothes secure during travel. The multi-use organizational pocket also doubles as a divider, keeping all items secure. Four wheel spinner system provides smooth and effortless movement for your life on the go. Dimensions: 30\" x 20\" x 12.5\" in Large- 10.7 lbs.\r\n'),(743,10,506,0,179,'Complete with multiple zippered pockets and compartments, you’ll stay organized on every trip. Ergonomically designed, telescopic handle system with easy, one-hand, push button use and cushioned TPR grip that fits easily in your hand. Fully lined interior with convenient tie-down straps to hold your clothes secure during travel. The multi-use organizational pocket also doubles as a divider, keeping all items secure. Four wheel spinner system provides smooth and effortless movement for your life on the go. Dimensions: 30\" x 20\" x 12.5\" in Large- 10.7 lbs.\r\n'),(744,10,531,0,179,NULL),(745,10,104,0,180,NULL),(746,10,97,0,180,'As the world’s first hard side zippered pocket system, P2Drive has a multi-function. Complete with multiple zippered pockets and compartments, you’ll stay organized on every trip. Ergonomically designed, telescopic handle system with easy, one-hand, push button use and cushioned TPR grip that fits easily in your hand. Fully lined interior with convenient tie-down straps to hold your clothes secure during travel. The multi-use organizational pocket also doubles as a divider, keeping all items secure. Dual wheel spinner system provides smooth and effortless movement for your life on the go. Polycarbonate Dimensions: 21\" x 14\" x 10\".\r\n'),(747,10,506,0,180,'As the world’s first hard side zippered pocket system, P2Drive has a multi-function. Complete with multiple zippered pockets and compartments, you’ll stay organized on every trip. Ergonomically designed, telescopic handle system with easy, one-hand, push button use and cushioned TPR grip that fits easily in your hand. Fully lined interior with convenient tie-down straps to hold your clothes secure during travel. The multi-use organizational pocket also doubles as a divider, keeping all items secure. Dual wheel spinner system provides smooth and effortless movement for your life on the go. Polycarbonate Dimensions: 21\" x 14\" x 10\".\r\n'),(748,10,531,0,180,NULL),(749,10,104,0,181,NULL),(750,10,97,0,181,'Complete with multiple zippered pockets and compartments, you’ll stay organized on every trip. Ergonomically designed, telescopic handle system with easy, one-hand, push button use and cushioned TPR grip that fits easily in your hand. Fully lined interior with convenient tie-down straps to hold your clothes secure during travel. The multi-use organizational pocket also doubles as a divider, keeping all items secure. Four wheel spinner system provides smooth and effortless movement for your life on the go. Dimensions: 25.5\" x 17\" x 11.25\" in Medium - 8.8 lbs.\r\n'),(751,10,506,0,181,'Complete with multiple zippered pockets and compartments, you’ll stay organized on every trip. Ergonomically designed, telescopic handle system with easy, one-hand, push button use and cushioned TPR grip that fits easily in your hand. Fully lined interior with convenient tie-down straps to hold your clothes secure during travel. The multi-use organizational pocket also doubles as a divider, keeping all items secure. Four wheel spinner system provides smooth and effortless movement for your life on the go. Dimensions: 25.5\" x 17\" x 11.25\" in Medium - 8.8 lbs.\r\n'),(752,10,531,0,181,NULL),(753,10,104,0,182,NULL),(754,10,97,0,182,'Complete with multiple zippered pockets and compartments, you’ll stay organized on every trip. Ergonomically designed, telescopic handle system with easy, one-hand, push button use and cushioned TPR grip that fits easily in your hand. Fully lined interior with convenient tie-down straps to hold your clothes secure during travel. The multi-use organizational pocket also doubles as a divider, keeping all items secure. Four wheel spinner system provides smooth and effortless movement for your life on the go. Dimensions:  Medium - 25.5\" x 17\" x 11.25\" in Medium - 8.8 lbs.\r\n'),(755,10,506,0,182,'Complete with multiple zippered pockets and compartments, you’ll stay organized on every trip. Ergonomically designed, telescopic handle system with easy, one-hand, push button use and cushioned TPR grip that fits easily in your hand. Fully lined interior with convenient tie-down straps to hold your clothes secure during travel. The multi-use organizational pocket also doubles as a divider, keeping all items secure. Four wheel spinner system provides smooth and effortless movement for your life on the go. Dimensions:  Medium - 25.5\" x 17\" x 11.25\" in Medium - 8.8 lbs.\r\n'),(756,10,531,0,182,NULL),(757,10,104,0,183,NULL),(758,10,97,0,183,'Complete with multiple zippered pockets and compartments, you’ll stay organized on every trip. Ergonomically designed, telescopic handle system with easy, one-hand, push button use and cushioned TPR grip that fits easily in your hand. Fully lined interior with convenient tie-down straps to hold your clothes secure during travel. The multi-use organizational pocket also doubles as a divider, keeping all items secure. Four wheel spinner system provides smooth and effortless movement for your life on the go. Dimensions: 30\" x 20\" x 12.5\" in Large- 10.7 lbs\r\n'),(759,10,506,0,183,'Complete with multiple zippered pockets and compartments, you’ll stay organized on every trip. Ergonomically designed, telescopic handle system with easy, one-hand, push button use and cushioned TPR grip that fits easily in your hand. Fully lined interior with convenient tie-down straps to hold your clothes secure during travel. The multi-use organizational pocket also doubles as a divider, keeping all items secure. Four wheel spinner system provides smooth and effortless movement for your life on the go. Dimensions: 30\" x 20\" x 12.5\" in Large- 10.7 lbs\r\n'),(760,10,531,0,183,NULL),(761,10,104,0,184,NULL),(762,10,97,0,184,'Complete with multiple zippered pockets and compartments, you’ll stay organized on every trip. Ergonomically designed, telescopic handle system with easy, one-hand, push button use and cushioned TPR grip that fits easily in your hand. Fully lined interior with convenient tie-down straps to hold your clothes secure during travel. The multi-use organizational pocket also doubles as a divider, keeping all items secure. Four wheel spinner system provides smooth and effortless movement for your life on the go. Dimensions: 30\" x 20\" x 12.5\" in Large- 10.7 lbs\r\n'),(763,10,506,0,184,'Complete with multiple zippered pockets and compartments, you’ll stay organized on every trip. Ergonomically designed, telescopic handle system with easy, one-hand, push button use and cushioned TPR grip that fits easily in your hand. Fully lined interior with convenient tie-down straps to hold your clothes secure during travel. The multi-use organizational pocket also doubles as a divider, keeping all items secure. Four wheel spinner system provides smooth and effortless movement for your life on the go. Dimensions: 30\" x 20\" x 12.5\" in Large- 10.7 lbs\r\n'),(764,10,531,0,184,NULL),(765,10,104,0,185,NULL),(766,10,97,0,185,'THIS BEAUTIFUL LUGGAGE SET IS BRAND NEW!!! \r\n\r\nSNOW WHITE COLLECTION \r\n\r\nMATERIAL \r\nPOLYESTER WITH A HIGH GLOSS FINISH \r\n\r\nSIZES \r\n20 H X 15 W X 8 L  \r\n28 H X 19 W X 11 L\r\n32 H X 20 W X 12 L \r\n\r\nWHEELS \r\nFOUR DUAL SPINNER WHEELS  '),(767,10,506,0,185,'THIS BEAUTIFUL LUGGAGE SET IS BRAND NEW!!! \r\n\r\nSNOW WHITE COLLECTION \r\n\r\nMATERIAL \r\nPOLYESTER WITH A HIGH GLOSS FINISH \r\n\r\nSIZES \r\n20 H X 15 W X 8 L  \r\n28 H X 19 W X 11 L\r\n32 H X 20 W X 12 L \r\n\r\nWHEELS \r\nFOUR DUAL SPINNER WHEELS  '),(768,10,531,0,185,NULL);

--
-- Table structure for table `catalog_product_entity_tier_price`
--

CREATE TABLE `catalog_product_entity_tier_price` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `all_groups` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Is Applicable To All Customer Groups',
  `customer_group_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Customer Group ID',
  `qty` decimal(12,4) NOT NULL DEFAULT '1.0000' COMMENT 'QTY',
  `value` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Value',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `E8AB433B9ACB00343ABB312AD2FAB087` (`entity_id`,`all_groups`,`customer_group_id`,`qty`,`website_id`),
  KEY `IDX_CATALOG_PRODUCT_ENTITY_TIER_PRICE_ENTITY_ID` (`entity_id`),
  KEY `IDX_CATALOG_PRODUCT_ENTITY_TIER_PRICE_CUSTOMER_GROUP_ID` (`customer_group_id`),
  KEY `IDX_CATALOG_PRODUCT_ENTITY_TIER_PRICE_WEBSITE_ID` (`website_id`),
  CONSTRAINT `FK_6E08D719F0501DD1D8E6D4EFF2511C85` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_PRD_ENTT_TIER_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_PRD_ENTT_TIER_PRICE_WS_ID_CORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Tier Price Attribute Backend Table';

--
-- Dumping data for table `catalog_product_entity_tier_price`
--


--
-- Table structure for table `catalog_product_entity_varchar`
--

CREATE TABLE `catalog_product_entity_varchar` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `entity_type_id` int(10) unsigned NOT NULL COMMENT 'Entity Type ID',
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `UNQ_CAT_PRD_ENTT_VCHR_ENTT_ID_ATTR_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `IDX_CATALOG_PRODUCT_ENTITY_VARCHAR_ATTRIBUTE_ID` (`attribute_id`),
  KEY `IDX_CATALOG_PRODUCT_ENTITY_VARCHAR_STORE_ID` (`store_id`),
  KEY `IDX_CATALOG_PRODUCT_ENTITY_VARCHAR_ENTITY_ID` (`entity_id`),
  CONSTRAINT `FK_CATALOG_PRODUCT_ENTITY_VARCHAR_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_PRD_ENTT_VCHR_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_PRD_ENTT_VCHR_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1881 DEFAULT CHARSET=utf8 COMMENT='Catalog Product Varchar Attribute Backend Table';

--
-- Dumping data for table `catalog_product_entity_varchar`
--

INSERT INTO `catalog_product_entity_varchar` VALUES (1518,10,96,0,167,'Heys Expandable Spinning 4 Wheel 3 Piece Polycarbonate Luggage Set'),(1519,10,481,0,167,'heys-expandable-spinning-4-wheel-3-piece-polycarbonate-luggage-set'),(1520,10,940,0,167,NULL),(1521,10,941,0,167,'2'),(1522,10,942,0,167,'4'),(1523,10,103,0,167,NULL),(1524,10,105,0,167,NULL),(1525,10,493,0,167,'/s/e/set1a.jpg'),(1526,10,109,0,167,'/s/e/set1a.jpg'),(1527,10,106,0,167,'/s/e/set1a.jpg'),(1528,10,571,0,167,NULL),(1529,10,836,0,167,'container2'),(1530,10,931,0,167,NULL),(1531,10,881,0,167,NULL),(1532,10,880,0,167,NULL),(1533,10,879,0,167,NULL),(1534,10,562,0,167,NULL),(1535,10,881,1,167,NULL),(1536,10,880,1,167,NULL),(1537,10,879,1,167,NULL),(1538,10,570,1,167,'heys-expandable-spinning-4-wheel-3-piece-polycarbonate-luggage-set.html'),(1539,10,570,0,167,'heys-expandable-spinning-4-wheel-3-piece-polycarbonate-luggage-set.html'),(1540,10,96,0,168,'Louis Kaiser Luggage 4 Wheel Spinner 3 Piece Luggage Set'),(1541,10,481,0,168,'louis-kaiser-luggage-4-wheel-spinner-3-piece-luggage-set'),(1542,10,940,0,168,NULL),(1543,10,941,0,168,'2'),(1544,10,942,0,168,'4'),(1545,10,103,0,168,NULL),(1546,10,105,0,168,NULL),(1547,10,493,0,168,'/s/e/set2a.jpg'),(1548,10,109,0,168,'/s/e/set2a.jpg'),(1549,10,106,0,168,'/s/e/set2a.jpg'),(1550,10,571,0,168,NULL),(1551,10,836,0,168,'container2'),(1552,10,931,0,168,NULL),(1553,10,881,0,168,NULL),(1554,10,880,0,168,NULL),(1555,10,879,0,168,NULL),(1556,10,562,0,168,NULL),(1557,10,570,1,168,'louis-kaiser-luggage-4-wheel-spinner-3-piece-luggage-set.html'),(1558,10,570,0,168,'louis-kaiser-luggage-4-wheel-spinner-3-piece-luggage-set.html'),(1559,10,96,0,169,'Louis Kaiser Luggage 4 Wheel Spinner 3 Piece Luggage Set'),(1560,10,481,0,169,'louis-kaiser-luggage-4-wheel-spinner-3-piece-luggage-set'),(1561,10,940,0,169,NULL),(1562,10,941,0,169,'2'),(1563,10,942,0,169,'4'),(1564,10,103,0,169,NULL),(1565,10,105,0,169,NULL),(1566,10,493,0,169,'/s/e/set3a.jpg'),(1567,10,109,0,169,'/s/e/set3a.jpg'),(1568,10,106,0,169,'/s/e/set3a.jpg'),(1569,10,571,0,169,NULL),(1570,10,836,0,169,'container2'),(1571,10,931,0,169,NULL),(1572,10,881,0,169,NULL),(1573,10,880,0,169,NULL),(1574,10,879,0,169,NULL),(1575,10,562,0,169,NULL),(1576,10,570,1,169,'louis-kaiser-luggage-4-wheel-spinner-3-piece-luggage-set-169.html'),(1577,10,570,0,169,'louis-kaiser-luggage-4-wheel-spinner-3-piece-luggage-set-169.html'),(1578,10,96,0,170,'American Gear Polycarbonate 4 Wheel Spinner 3 Piece Luggage Set'),(1579,10,481,0,170,'american-gear-polycarbonate-4-wheel-spinner-3-piece-luggage-set'),(1580,10,940,0,170,NULL),(1581,10,941,0,170,'2'),(1582,10,942,0,170,'4'),(1583,10,103,0,170,NULL),(1584,10,105,0,170,NULL),(1585,10,493,0,170,'/s/e/set4a.jpg'),(1586,10,109,0,170,'/s/e/set4a.jpg'),(1587,10,106,0,170,'/s/e/set4a.jpg'),(1588,10,571,0,170,NULL),(1589,10,836,0,170,'container2'),(1590,10,931,0,170,NULL),(1591,10,881,0,170,NULL),(1592,10,880,0,170,NULL),(1593,10,879,0,170,NULL),(1594,10,562,0,170,NULL),(1595,10,570,1,170,'american-gear-polycarbonate-4-wheel-spinner-3-piece-luggage-set.html'),(1596,10,570,0,170,'american-gear-polycarbonate-4-wheel-spinner-3-piece-luggage-set.html'),(1597,10,96,0,171,'American Gear Polycarbonate 4 Wheel Spinner 3 Piece Luggage Set'),(1598,10,481,0,171,'american-gear-polycarbonate-4-wheel-spinner-3-piece-luggage-set'),(1599,10,940,0,171,NULL),(1600,10,941,0,171,'2'),(1601,10,942,0,171,'4'),(1602,10,103,0,171,NULL),(1603,10,105,0,171,NULL),(1604,10,493,0,171,'/s/e/set5a.jpg'),(1605,10,109,0,171,'/s/e/set5a.jpg'),(1606,10,106,0,171,'/s/e/set5a.jpg'),(1607,10,571,0,171,NULL),(1608,10,836,0,171,'container2'),(1609,10,931,0,171,NULL),(1610,10,881,0,171,NULL),(1611,10,880,0,171,NULL),(1612,10,879,0,171,NULL),(1613,10,562,0,171,NULL),(1614,10,570,1,171,'american-gear-polycarbonate-4-wheel-spinner-3-piece-luggage-set-171.html'),(1615,10,570,0,171,'american-gear-polycarbonate-4-wheel-spinner-3-piece-luggage-set-171.html'),(1616,10,96,0,172,'Travel Concepts Polycarbonate 4 Wheel Spinner 3 Piece Luggage Set'),(1617,10,481,0,172,'travel-concepts-polycarbonate-4-wheel-spinner-3-piece-luggage-set'),(1618,10,940,0,172,NULL),(1619,10,941,0,172,'2'),(1620,10,942,0,172,'4'),(1621,10,103,0,172,NULL),(1622,10,105,0,172,NULL),(1623,10,493,0,172,'/s/e/set6a.jpg'),(1624,10,109,0,172,'/s/e/set6a.jpg'),(1625,10,106,0,172,'/s/e/set6a.jpg'),(1626,10,571,0,172,NULL),(1627,10,836,0,172,'container2'),(1628,10,931,0,172,NULL),(1629,10,881,0,172,NULL),(1630,10,880,0,172,NULL),(1631,10,879,0,172,NULL),(1632,10,562,0,172,NULL),(1633,10,570,1,172,'travel-concepts-polycarbonate-4-wheel-spinner-3-piece-luggage-set.html'),(1634,10,570,0,172,'travel-concepts-polycarbonate-4-wheel-spinner-3-piece-luggage-set.html'),(1635,10,96,0,173,'Heys Expandable Spinning 4 Wheel 3 Piece Polycarbonate Luggage Set'),(1636,10,481,0,173,'heys-expandable-spinning-4-wheel-3-piece-polycarbonate-luggage-set'),(1637,10,940,0,173,NULL),(1638,10,941,0,173,'2'),(1639,10,942,0,173,'4'),(1640,10,103,0,173,NULL),(1641,10,105,0,173,NULL),(1642,10,493,0,173,'/s/e/set7a.jpg'),(1643,10,109,0,173,'/s/e/set7a.jpg'),(1644,10,106,0,173,'/s/e/set7a.jpg'),(1645,10,571,0,173,NULL),(1646,10,836,0,173,'container2'),(1647,10,931,0,173,NULL),(1648,10,881,0,173,NULL),(1649,10,880,0,173,NULL),(1650,10,879,0,173,NULL),(1651,10,562,0,173,NULL),(1652,10,570,1,173,'heys-expandable-spinning-4-wheel-3-piece-polycarbonate-luggage-set-173.html'),(1653,10,570,0,173,'heys-expandable-spinning-4-wheel-3-piece-polycarbonate-luggage-set-173.html'),(1654,10,96,0,174,'Heys Expandable Spinning 4 Wheel 2 Piece Polycarbonate Luggage Set'),(1655,10,481,0,174,'heys-expandable-spinning-4-wheel-2-piece-polycarbonate-luggage-set'),(1656,10,940,0,174,NULL),(1657,10,941,0,174,'2'),(1658,10,942,0,174,'4'),(1659,10,103,0,174,NULL),(1660,10,105,0,174,NULL),(1661,10,493,0,174,'/s/e/set8a.jpg'),(1662,10,109,0,174,'/s/e/set8a.jpg'),(1663,10,106,0,174,'/s/e/set8a.jpg'),(1664,10,571,0,174,NULL),(1665,10,836,0,174,'container2'),(1666,10,931,0,174,NULL),(1667,10,881,0,174,NULL),(1668,10,880,0,174,NULL),(1669,10,879,0,174,NULL),(1670,10,562,0,174,NULL),(1671,10,570,1,174,'heys-expandable-spinning-4-wheel-2-piece-polycarbonate-luggage-set.html'),(1672,10,570,0,174,'heys-expandable-spinning-4-wheel-2-piece-polycarbonate-luggage-set.html'),(1673,10,96,0,175,'Travel Concepts 4 Wheel Spinner 3 Piece Luggage Set Still has Protective Plastic'),(1674,10,481,0,175,'travel-concepts-4-wheel-spinner-3-piece-luggage-set-still-has-protective-plastic'),(1675,10,940,0,175,NULL),(1676,10,941,0,175,'2'),(1677,10,942,0,175,'4'),(1678,10,103,0,175,NULL),(1679,10,105,0,175,NULL),(1680,10,493,0,175,'/s/e/set9a.jpg'),(1681,10,109,0,175,'/s/e/set9a.jpg'),(1682,10,106,0,175,'/s/e/set9a.jpg'),(1683,10,571,0,175,NULL),(1684,10,836,0,175,'container2'),(1685,10,931,0,175,NULL),(1686,10,881,0,175,NULL),(1687,10,880,0,175,NULL),(1688,10,879,0,175,NULL),(1689,10,562,0,175,NULL),(1690,10,570,1,175,'travel-concepts-4-wheel-spinner-3-piece-luggage-set-still-has-protective-plastic.html'),(1691,10,570,0,175,'travel-concepts-4-wheel-spinner-3-piece-luggage-set-still-has-protective-plastic.html'),(1692,10,96,0,176,'Heys Expandable Rolling Upright Suitcase 4 Wheeled Carry on Luggage'),(1693,10,481,0,176,'heys-expandable-rolling-upright-suitcase-4-wheeled-carry-on-luggage'),(1694,10,940,0,176,NULL),(1695,10,941,0,176,'2'),(1696,10,942,0,176,'4'),(1697,10,103,0,176,NULL),(1698,10,105,0,176,NULL),(1699,10,493,0,176,'/s/e/set10a.jpg'),(1700,10,109,0,176,'/s/e/set10a.jpg'),(1701,10,106,0,176,'/s/e/set10a.jpg'),(1702,10,571,0,176,NULL),(1703,10,836,0,176,'container2'),(1704,10,931,0,176,NULL),(1705,10,881,0,176,NULL),(1706,10,880,0,176,NULL),(1707,10,879,0,176,NULL),(1708,10,562,0,176,NULL),(1709,10,570,1,176,'heys-expandable-rolling-upright-suitcase-4-wheeled-carry-on-luggage.html'),(1710,10,570,0,176,'heys-expandable-rolling-upright-suitcase-4-wheeled-carry-on-luggage.html'),(1711,10,96,0,177,'Travel Concepts Polycarbonate 4 Wheel Spinner 3 Piece Luggage Set'),(1712,10,481,0,177,'travel-concepts-polycarbonate-4-wheel-spinner-3-piece-luggage-set'),(1713,10,940,0,177,NULL),(1714,10,941,0,177,'2'),(1715,10,942,0,177,'4'),(1716,10,103,0,177,NULL),(1717,10,105,0,177,NULL),(1718,10,493,0,177,'/s/e/set11a.jpg'),(1719,10,109,0,177,'/s/e/set11a.jpg'),(1720,10,106,0,177,'/s/e/set11a.jpg'),(1721,10,571,0,177,NULL),(1722,10,836,0,177,'container2'),(1723,10,931,0,177,NULL),(1724,10,881,0,177,NULL),(1725,10,880,0,177,NULL),(1726,10,879,0,177,NULL),(1727,10,562,0,177,NULL),(1728,10,570,1,177,'travel-concepts-polycarbonate-4-wheel-spinner-3-piece-luggage-set-177.html'),(1729,10,570,0,177,'travel-concepts-polycarbonate-4-wheel-spinner-3-piece-luggage-set-177.html'),(1730,10,96,0,178,'LOUIES BERRY 2 WHEEL 3 PIECE LUGGAGE SET STILL HAS PROTECTIVE PLASTIC FILM'),(1731,10,481,0,178,'louies-berry-2-wheel-3-piece-luggage-set-still-has-protective-plastic-film'),(1732,10,940,0,178,NULL),(1733,10,941,0,178,'2'),(1734,10,942,0,178,'4'),(1735,10,103,0,178,NULL),(1736,10,105,0,178,NULL),(1737,10,493,0,178,'/s/e/set12a.jpg'),(1738,10,109,0,178,'/s/e/set12a.jpg'),(1739,10,106,0,178,'/s/e/set12a.jpg'),(1740,10,571,0,178,NULL),(1741,10,836,0,178,'container2'),(1742,10,931,0,178,NULL),(1743,10,881,0,178,NULL),(1744,10,880,0,178,NULL),(1745,10,879,0,178,NULL),(1746,10,562,0,178,NULL),(1747,10,570,1,178,'louies-berry-2-wheel-3-piece-luggage-set-still-has-protective-plastic-film.html'),(1748,10,570,0,178,'louies-berry-2-wheel-3-piece-luggage-set-still-has-protective-plastic-film.html'),(1749,10,96,0,179,'Heys Expandable Rolling Upright Suitcase Travel 4 Wheeled Spinning Luggage'),(1750,10,481,0,179,'heys-expandable-rolling-upright-suitcase-travel-4-wheeled-spinning-luggage'),(1751,10,940,0,179,NULL),(1752,10,941,0,179,'2'),(1753,10,942,0,179,'4'),(1754,10,103,0,179,NULL),(1755,10,105,0,179,NULL),(1756,10,493,0,179,'/s/e/set13a.jpg'),(1757,10,109,0,179,'/s/e/set13a.jpg'),(1758,10,106,0,179,'/s/e/set13a.jpg'),(1759,10,571,0,179,NULL),(1760,10,836,0,179,'container2'),(1761,10,931,0,179,NULL),(1762,10,881,0,179,NULL),(1763,10,880,0,179,NULL),(1764,10,879,0,179,NULL),(1765,10,562,0,179,NULL),(1766,10,570,1,179,'heys-expandable-rolling-upright-suitcase-travel-4-wheeled-spinning-luggage.html'),(1767,10,570,0,179,'heys-expandable-rolling-upright-suitcase-travel-4-wheeled-spinning-luggage.html'),(1768,10,96,0,180,'Heys Expandable Rolling Upright Suitcase 4 Wheeled Carry on Luggage'),(1769,10,481,0,180,'heys-expandable-rolling-upright-suitcase-4-wheeled-carry-on-luggage'),(1770,10,940,0,180,NULL),(1771,10,941,0,180,'2'),(1772,10,942,0,180,'4'),(1773,10,103,0,180,NULL),(1774,10,105,0,180,NULL),(1775,10,106,0,180,'no_selection'),(1776,10,493,0,180,'/s/e/set14a.jpg'),(1777,10,109,0,180,'/s/e/set14a.jpg'),(1778,10,571,0,180,NULL),(1779,10,836,0,180,'container2'),(1780,10,931,0,180,NULL),(1781,10,881,0,180,NULL),(1782,10,880,0,180,NULL),(1783,10,562,0,180,NULL),(1784,10,570,1,180,'heys-expandable-rolling-upright-suitcase-4-wheeled-carry-on-luggage-180.html'),(1785,10,570,0,180,'heys-expandable-rolling-upright-suitcase-4-wheeled-carry-on-luggage-180.html'),(1786,10,96,0,181,'Heys Expandable Rolling Upright Suitcase Travel 4 Wheeled Spinning Luggage'),(1787,10,481,0,181,'heys-expandable-rolling-upright-suitcase-travel-4-wheeled-spinning-luggage'),(1788,10,940,0,181,NULL),(1789,10,941,0,181,'2'),(1790,10,942,0,181,'4'),(1791,10,103,0,181,NULL),(1792,10,105,0,181,NULL),(1793,10,493,0,181,'/s/e/set15a.jpg'),(1794,10,109,0,181,'/s/e/set15a.jpg'),(1795,10,106,0,181,'/s/e/set15a.jpg'),(1796,10,571,0,181,NULL),(1797,10,836,0,181,'container2'),(1798,10,931,0,181,NULL),(1799,10,881,0,181,NULL),(1800,10,880,0,181,NULL),(1801,10,879,0,181,NULL),(1802,10,562,0,181,NULL),(1803,10,570,1,181,'heys-expandable-rolling-upright-suitcase-travel-4-wheeled-spinning-luggage-181.html'),(1804,10,570,0,181,'heys-expandable-rolling-upright-suitcase-travel-4-wheeled-spinning-luggage-181.html'),(1805,10,96,0,182,'Heys Expandable Rolling Upright Suitcase Travel 4 Wheeled Spinning Luggage'),(1806,10,481,0,182,'heys-expandable-rolling-upright-suitcase-travel-4-wheeled-spinning-luggage'),(1807,10,940,0,182,NULL),(1808,10,941,0,182,'2'),(1809,10,942,0,182,'4'),(1810,10,103,0,182,NULL),(1811,10,105,0,182,NULL),(1812,10,493,0,182,'/s/e/set16a.jpg'),(1813,10,109,0,182,'/s/e/set16a.jpg'),(1814,10,106,0,182,'/s/e/set16a.jpg'),(1815,10,571,0,182,NULL),(1816,10,836,0,182,'container2'),(1817,10,931,0,182,NULL),(1818,10,881,0,182,NULL),(1819,10,880,0,182,NULL),(1820,10,879,0,182,NULL),(1821,10,562,0,182,NULL),(1822,10,570,1,182,'heys-expandable-rolling-upright-suitcase-travel-4-wheeled-spinning-luggage-182.html'),(1823,10,570,0,182,'heys-expandable-rolling-upright-suitcase-travel-4-wheeled-spinning-luggage-182.html'),(1824,10,96,0,183,'Heys Expandable Rolling Upright Suitcase Travel 4 Wheeled Spinning Luggage'),(1825,10,481,0,183,'heys-expandable-rolling-upright-suitcase-travel-4-wheeled-spinning-luggage'),(1826,10,940,0,183,NULL),(1827,10,941,0,183,'2'),(1828,10,942,0,183,'4'),(1829,10,103,0,183,NULL),(1830,10,105,0,183,NULL),(1831,10,493,0,183,'/s/e/set17a.jpg'),(1832,10,109,0,183,'/s/e/set17a.jpg'),(1833,10,106,0,183,'/s/e/set17a.jpg'),(1834,10,571,0,183,NULL),(1835,10,836,0,183,'container2'),(1836,10,931,0,183,NULL),(1837,10,881,0,183,NULL),(1838,10,880,0,183,NULL),(1839,10,879,0,183,NULL),(1840,10,562,0,183,NULL),(1841,10,570,1,183,'heys-expandable-rolling-upright-suitcase-travel-4-wheeled-spinning-luggage-183.html'),(1842,10,570,0,183,'heys-expandable-rolling-upright-suitcase-travel-4-wheeled-spinning-luggage-183.html'),(1843,10,96,0,184,'Heys Expandable Rolling Upright Suitcase Travel 4 Wheeled Spinning Luggage'),(1844,10,481,0,184,'heys-expandable-rolling-upright-suitcase-travel-4-wheeled-spinning-luggage'),(1845,10,940,0,184,NULL),(1846,10,941,0,184,'2'),(1847,10,942,0,184,'4'),(1848,10,103,0,184,NULL),(1849,10,105,0,184,NULL),(1850,10,493,0,184,'/s/e/set18a.jpg'),(1851,10,109,0,184,'/s/e/set18a.jpg'),(1852,10,106,0,184,'/s/e/set18a.jpg'),(1853,10,571,0,184,NULL),(1854,10,836,0,184,'container2'),(1855,10,931,0,184,NULL),(1856,10,881,0,184,NULL),(1857,10,880,0,184,NULL),(1858,10,879,0,184,NULL),(1859,10,562,0,184,NULL),(1860,10,570,1,184,'heys-expandable-rolling-upright-suitcase-travel-4-wheeled-spinning-luggage-184.html'),(1861,10,570,0,184,'heys-expandable-rolling-upright-suitcase-travel-4-wheeled-spinning-luggage-184.html'),(1862,10,96,0,185,'SNOW WHITE LUGGAGE 4 WHEEL SPINNER 3 PIECE LUGGAGE SET'),(1863,10,481,0,185,'snow-white-luggage-4-wheel-spinner-3-piece-luggage-set'),(1864,10,940,0,185,NULL),(1865,10,941,0,185,'2'),(1866,10,942,0,185,'4'),(1867,10,103,0,185,NULL),(1868,10,105,0,185,NULL),(1869,10,493,0,185,'/s/e/set19a.jpg'),(1870,10,109,0,185,'/s/e/set19a.jpg'),(1871,10,106,0,185,'/s/e/set19a.jpg'),(1872,10,571,0,185,NULL),(1873,10,836,0,185,'container2'),(1874,10,931,0,185,NULL),(1875,10,881,0,185,NULL),(1876,10,880,0,185,NULL),(1877,10,879,0,185,NULL),(1878,10,562,0,185,NULL),(1879,10,570,1,185,'snow-white-luggage-4-wheel-spinner-3-piece-luggage-set.html'),(1880,10,570,0,185,'snow-white-luggage-4-wheel-spinner-3-piece-luggage-set.html');

--
-- Table structure for table `catalog_product_flat_1`
--

CREATE TABLE `catalog_product_flat_1` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity Id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set Id',
  `type_id` varchar(32) NOT NULL DEFAULT 'simple' COMMENT 'Type Id',
  `activation_information` text COMMENT 'Activation Information',
  `color` int(11) DEFAULT NULL COMMENT 'Color',
  `color_value` varchar(255) DEFAULT NULL COMMENT 'Color Value',
  `computer_manufacturers` int(11) DEFAULT NULL COMMENT 'Computer Manufacturers',
  `computer_manufacturers_value` varchar(255) DEFAULT NULL COMMENT 'Computer Manufacturers Value',
  `contrast_ratio` int(11) DEFAULT NULL COMMENT 'Contrast Ratio',
  `contrast_ratio_value` varchar(255) DEFAULT NULL COMMENT 'Contrast Ratio Value',
  `cost` decimal(12,4) DEFAULT NULL COMMENT 'Cost',
  `country_orgin` text COMMENT 'Country Orgin',
  `cpu_speed` int(11) DEFAULT NULL COMMENT 'Cpu Speed',
  `cpu_speed_value` varchar(255) DEFAULT NULL COMMENT 'Cpu Speed Value',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created At',
  `custom_design_from` datetime DEFAULT NULL COMMENT 'Custom Design From',
  `custom_design_to` datetime DEFAULT NULL COMMENT 'Custom Design To',
  `custom_layout_update` text COMMENT 'Custom Layout Update',
  `description` text COMMENT 'Description',
  `dimension` text COMMENT 'Dimension',
  `finish` text COMMENT 'Finish',
  `gallery` varchar(255) DEFAULT NULL COMMENT 'Gallery',
  `gender` int(11) DEFAULT NULL COMMENT 'Gender',
  `gender_value` varchar(255) DEFAULT NULL COMMENT 'Gender Value',
  `gift_message_available` smallint(6) DEFAULT NULL COMMENT 'Gift Message Available',
  `harddrive_speed` varchar(255) DEFAULT NULL COMMENT 'Harddrive Speed',
  `hardrive` text COMMENT 'Hardrive',
  `has_options` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Has Options',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `image_label` varchar(255) DEFAULT NULL COMMENT 'Image Label',
  `in_depth` text COMMENT 'In Depth',
  `is_recurring` smallint(6) DEFAULT NULL COMMENT 'Is Recurring',
  `links_exist` int(11) DEFAULT NULL COMMENT 'Links Exist',
  `links_purchased_separately` int(11) DEFAULT NULL COMMENT 'Links Purchased Separately',
  `links_title` varchar(255) DEFAULT NULL COMMENT 'Links Title',
  `manufacturer` int(11) DEFAULT NULL COMMENT 'Manufacturer',
  `manufacturer_value` varchar(255) DEFAULT NULL COMMENT 'Manufacturer Value',
  `max_resolution` varchar(255) DEFAULT NULL COMMENT 'Max Resolution',
  `media_gallery` varchar(255) DEFAULT NULL COMMENT 'Media Gallery',
  `megapixels` int(11) DEFAULT NULL COMMENT 'Megapixels',
  `megapixels_value` varchar(255) DEFAULT NULL COMMENT 'Megapixels Value',
  `memory` text COMMENT 'Memory',
  `meta_description` varchar(255) DEFAULT NULL COMMENT 'Meta Description',
  `meta_keyword` text COMMENT 'Meta Keyword',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Meta Title',
  `minimal_price` decimal(12,4) DEFAULT NULL COMMENT 'Minimal Price',
  `model` text COMMENT 'Model',
  `msrp` decimal(12,4) DEFAULT NULL COMMENT 'Msrp',
  `msrp_display_actual_price_type` varchar(255) DEFAULT NULL COMMENT 'Msrp Display Actual Price Type',
  `msrp_enabled` smallint(6) DEFAULT NULL COMMENT 'Msrp Enabled',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `news_from_date` datetime DEFAULT NULL COMMENT 'News From Date',
  `news_to_date` datetime DEFAULT NULL COMMENT 'News To Date',
  `old_id` int(11) DEFAULT NULL COMMENT 'Old Id',
  `price` decimal(12,4) DEFAULT NULL COMMENT 'Price',
  `price_type` int(11) DEFAULT NULL COMMENT 'Price Type',
  `price_view` int(11) DEFAULT NULL COMMENT 'Price View',
  `processor` text COMMENT 'Processor',
  `ram_size` varchar(255) DEFAULT NULL COMMENT 'Ram Size',
  `recurring_profile` text COMMENT 'Recurring Profile',
  `required_options` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Required Options',
  `response_time` varchar(255) DEFAULT NULL COMMENT 'Response Time',
  `room` int(11) DEFAULT NULL COMMENT 'Room',
  `room_value` varchar(255) DEFAULT NULL COMMENT 'Room Value',
  `samples_title` varchar(255) DEFAULT NULL COMMENT 'Samples Title',
  `screensize` text COMMENT 'Screensize',
  `shape` text COMMENT 'Shape',
  `shipment_type` int(11) DEFAULT NULL COMMENT 'Shipment Type',
  `shirt_size` int(11) DEFAULT NULL COMMENT 'Shirt Size',
  `shirt_size_value` varchar(255) DEFAULT NULL COMMENT 'Shirt Size Value',
  `shoe_size` int(11) DEFAULT NULL COMMENT 'Shoe Size',
  `shoe_size_value` varchar(255) DEFAULT NULL COMMENT 'Shoe Size Value',
  `shoe_type` int(11) DEFAULT NULL COMMENT 'Shoe Type',
  `shoe_type_value` varchar(255) DEFAULT NULL COMMENT 'Shoe Type Value',
  `short_description` text COMMENT 'Short Description',
  `sku` varchar(64) DEFAULT NULL COMMENT 'Sku',
  `sku_type` int(11) DEFAULT NULL COMMENT 'Sku Type',
  `small_image` varchar(255) DEFAULT NULL COMMENT 'Small Image',
  `small_image_label` varchar(255) DEFAULT NULL COMMENT 'Small Image Label',
  `special_from_date` datetime DEFAULT NULL COMMENT 'Special From Date',
  `special_price` decimal(12,4) DEFAULT NULL COMMENT 'Special Price',
  `special_to_date` datetime DEFAULT NULL COMMENT 'Special To Date',
  `tax_class_id` int(10) unsigned DEFAULT NULL COMMENT 'Tax Class Id',
  `thumbnail` varchar(255) DEFAULT NULL COMMENT 'Thumbnail',
  `thumbnail_label` varchar(255) DEFAULT NULL COMMENT 'Thumbnail Label',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'Url Key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'Url Path',
  `visibility` smallint(5) unsigned DEFAULT NULL COMMENT 'Visibility',
  `weight` decimal(12,4) DEFAULT NULL COMMENT 'Weight',
  `weight_type` int(11) DEFAULT NULL COMMENT 'Weight Type',
  PRIMARY KEY (`entity_id`),
  KEY `IDX_CATALOG_PRODUCT_FLAT_1_TYPE_ID` (`type_id`),
  KEY `IDX_CATALOG_PRODUCT_FLAT_1_ATTRIBUTE_SET_ID` (`attribute_set_id`),
  KEY `IDX_CATALOG_PRODUCT_FLAT_1_NAME` (`name`),
  KEY `IDX_CATALOG_PRODUCT_FLAT_1_PRICE` (`price`),
  CONSTRAINT `FK_CAT_PRD_FLAT_1_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Flat (Store 1)';

--
-- Dumping data for table `catalog_product_flat_1`
--


--
-- Table structure for table `catalog_product_flat_2`
--

CREATE TABLE `catalog_product_flat_2` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity Id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set Id',
  `type_id` varchar(32) NOT NULL DEFAULT 'simple' COMMENT 'Type Id',
  `activation_information` text COMMENT 'Activation Information',
  `color` int(11) DEFAULT NULL COMMENT 'Color',
  `color_value` varchar(255) DEFAULT NULL COMMENT 'Color Value',
  `computer_manufacturers` int(11) DEFAULT NULL COMMENT 'Computer Manufacturers',
  `computer_manufacturers_value` varchar(255) DEFAULT NULL COMMENT 'Computer Manufacturers Value',
  `contrast_ratio` int(11) DEFAULT NULL COMMENT 'Contrast Ratio',
  `contrast_ratio_value` varchar(255) DEFAULT NULL COMMENT 'Contrast Ratio Value',
  `cost` decimal(12,4) DEFAULT NULL COMMENT 'Cost',
  `country_orgin` text COMMENT 'Country Orgin',
  `cpu_speed` int(11) DEFAULT NULL COMMENT 'Cpu Speed',
  `cpu_speed_value` varchar(255) DEFAULT NULL COMMENT 'Cpu Speed Value',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created At',
  `custom_design_from` datetime DEFAULT NULL COMMENT 'Custom Design From',
  `custom_design_to` datetime DEFAULT NULL COMMENT 'Custom Design To',
  `custom_layout_update` text COMMENT 'Custom Layout Update',
  `description` text COMMENT 'Description',
  `dimension` text COMMENT 'Dimension',
  `finish` text COMMENT 'Finish',
  `gallery` varchar(255) DEFAULT NULL COMMENT 'Gallery',
  `gender` int(11) DEFAULT NULL COMMENT 'Gender',
  `gender_value` varchar(255) DEFAULT NULL COMMENT 'Gender Value',
  `gift_message_available` smallint(6) DEFAULT NULL COMMENT 'Gift Message Available',
  `harddrive_speed` varchar(255) DEFAULT NULL COMMENT 'Harddrive Speed',
  `hardrive` text COMMENT 'Hardrive',
  `has_options` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Has Options',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `image_label` varchar(255) DEFAULT NULL COMMENT 'Image Label',
  `in_depth` text COMMENT 'In Depth',
  `is_recurring` smallint(6) DEFAULT NULL COMMENT 'Is Recurring',
  `links_exist` int(11) DEFAULT NULL COMMENT 'Links Exist',
  `links_purchased_separately` int(11) DEFAULT NULL COMMENT 'Links Purchased Separately',
  `links_title` varchar(255) DEFAULT NULL COMMENT 'Links Title',
  `manufacturer` int(11) DEFAULT NULL COMMENT 'Manufacturer',
  `manufacturer_value` varchar(255) DEFAULT NULL COMMENT 'Manufacturer Value',
  `max_resolution` varchar(255) DEFAULT NULL COMMENT 'Max Resolution',
  `media_gallery` varchar(255) DEFAULT NULL COMMENT 'Media Gallery',
  `megapixels` int(11) DEFAULT NULL COMMENT 'Megapixels',
  `megapixels_value` varchar(255) DEFAULT NULL COMMENT 'Megapixels Value',
  `memory` text COMMENT 'Memory',
  `meta_description` varchar(255) DEFAULT NULL COMMENT 'Meta Description',
  `meta_keyword` text COMMENT 'Meta Keyword',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Meta Title',
  `minimal_price` decimal(12,4) DEFAULT NULL COMMENT 'Minimal Price',
  `model` text COMMENT 'Model',
  `msrp` decimal(12,4) DEFAULT NULL COMMENT 'Msrp',
  `msrp_display_actual_price_type` varchar(255) DEFAULT NULL COMMENT 'Msrp Display Actual Price Type',
  `msrp_enabled` smallint(6) DEFAULT NULL COMMENT 'Msrp Enabled',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `news_from_date` datetime DEFAULT NULL COMMENT 'News From Date',
  `news_to_date` datetime DEFAULT NULL COMMENT 'News To Date',
  `old_id` int(11) DEFAULT NULL COMMENT 'Old Id',
  `price` decimal(12,4) DEFAULT NULL COMMENT 'Price',
  `price_type` int(11) DEFAULT NULL COMMENT 'Price Type',
  `price_view` int(11) DEFAULT NULL COMMENT 'Price View',
  `processor` text COMMENT 'Processor',
  `ram_size` varchar(255) DEFAULT NULL COMMENT 'Ram Size',
  `recurring_profile` text COMMENT 'Recurring Profile',
  `required_options` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Required Options',
  `response_time` varchar(255) DEFAULT NULL COMMENT 'Response Time',
  `room` int(11) DEFAULT NULL COMMENT 'Room',
  `room_value` varchar(255) DEFAULT NULL COMMENT 'Room Value',
  `samples_title` varchar(255) DEFAULT NULL COMMENT 'Samples Title',
  `screensize` text COMMENT 'Screensize',
  `shape` text COMMENT 'Shape',
  `shipment_type` int(11) DEFAULT NULL COMMENT 'Shipment Type',
  `shirt_size` int(11) DEFAULT NULL COMMENT 'Shirt Size',
  `shirt_size_value` varchar(255) DEFAULT NULL COMMENT 'Shirt Size Value',
  `shoe_size` int(11) DEFAULT NULL COMMENT 'Shoe Size',
  `shoe_size_value` varchar(255) DEFAULT NULL COMMENT 'Shoe Size Value',
  `shoe_type` int(11) DEFAULT NULL COMMENT 'Shoe Type',
  `shoe_type_value` varchar(255) DEFAULT NULL COMMENT 'Shoe Type Value',
  `short_description` text COMMENT 'Short Description',
  `sku` varchar(64) DEFAULT NULL COMMENT 'Sku',
  `sku_type` int(11) DEFAULT NULL COMMENT 'Sku Type',
  `small_image` varchar(255) DEFAULT NULL COMMENT 'Small Image',
  `small_image_label` varchar(255) DEFAULT NULL COMMENT 'Small Image Label',
  `special_from_date` datetime DEFAULT NULL COMMENT 'Special From Date',
  `special_price` decimal(12,4) DEFAULT NULL COMMENT 'Special Price',
  `special_to_date` datetime DEFAULT NULL COMMENT 'Special To Date',
  `tax_class_id` int(10) unsigned DEFAULT NULL COMMENT 'Tax Class Id',
  `thumbnail` varchar(255) DEFAULT NULL COMMENT 'Thumbnail',
  `thumbnail_label` varchar(255) DEFAULT NULL COMMENT 'Thumbnail Label',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'Url Key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'Url Path',
  `visibility` smallint(5) unsigned DEFAULT NULL COMMENT 'Visibility',
  `weight` decimal(12,4) DEFAULT NULL COMMENT 'Weight',
  `weight_type` int(11) DEFAULT NULL COMMENT 'Weight Type',
  PRIMARY KEY (`entity_id`),
  KEY `IDX_CATALOG_PRODUCT_FLAT_2_TYPE_ID` (`type_id`),
  KEY `IDX_CATALOG_PRODUCT_FLAT_2_ATTRIBUTE_SET_ID` (`attribute_set_id`),
  KEY `IDX_CATALOG_PRODUCT_FLAT_2_NAME` (`name`),
  KEY `IDX_CATALOG_PRODUCT_FLAT_2_PRICE` (`price`),
  CONSTRAINT `FK_CAT_PRD_FLAT_2_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Flat (Store 2)';

--
-- Dumping data for table `catalog_product_flat_2`
--


--
-- Table structure for table `catalog_product_flat_3`
--

CREATE TABLE `catalog_product_flat_3` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity Id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set Id',
  `type_id` varchar(32) NOT NULL DEFAULT 'simple' COMMENT 'Type Id',
  `activation_information` text COMMENT 'Activation Information',
  `color` int(11) DEFAULT NULL COMMENT 'Color',
  `color_value` varchar(255) DEFAULT NULL COMMENT 'Color Value',
  `computer_manufacturers` int(11) DEFAULT NULL COMMENT 'Computer Manufacturers',
  `computer_manufacturers_value` varchar(255) DEFAULT NULL COMMENT 'Computer Manufacturers Value',
  `contrast_ratio` int(11) DEFAULT NULL COMMENT 'Contrast Ratio',
  `contrast_ratio_value` varchar(255) DEFAULT NULL COMMENT 'Contrast Ratio Value',
  `cost` decimal(12,4) DEFAULT NULL COMMENT 'Cost',
  `country_orgin` text COMMENT 'Country Orgin',
  `cpu_speed` int(11) DEFAULT NULL COMMENT 'Cpu Speed',
  `cpu_speed_value` varchar(255) DEFAULT NULL COMMENT 'Cpu Speed Value',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created At',
  `custom_design_from` datetime DEFAULT NULL COMMENT 'Custom Design From',
  `custom_design_to` datetime DEFAULT NULL COMMENT 'Custom Design To',
  `custom_layout_update` text COMMENT 'Custom Layout Update',
  `description` text COMMENT 'Description',
  `dimension` text COMMENT 'Dimension',
  `finish` text COMMENT 'Finish',
  `gallery` varchar(255) DEFAULT NULL COMMENT 'Gallery',
  `gender` int(11) DEFAULT NULL COMMENT 'Gender',
  `gender_value` varchar(255) DEFAULT NULL COMMENT 'Gender Value',
  `gift_message_available` smallint(6) DEFAULT NULL COMMENT 'Gift Message Available',
  `harddrive_speed` varchar(255) DEFAULT NULL COMMENT 'Harddrive Speed',
  `hardrive` text COMMENT 'Hardrive',
  `has_options` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Has Options',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `image_label` varchar(255) DEFAULT NULL COMMENT 'Image Label',
  `in_depth` text COMMENT 'In Depth',
  `is_recurring` smallint(6) DEFAULT NULL COMMENT 'Is Recurring',
  `links_exist` int(11) DEFAULT NULL COMMENT 'Links Exist',
  `links_purchased_separately` int(11) DEFAULT NULL COMMENT 'Links Purchased Separately',
  `links_title` varchar(255) DEFAULT NULL COMMENT 'Links Title',
  `manufacturer` int(11) DEFAULT NULL COMMENT 'Manufacturer',
  `manufacturer_value` varchar(255) DEFAULT NULL COMMENT 'Manufacturer Value',
  `max_resolution` varchar(255) DEFAULT NULL COMMENT 'Max Resolution',
  `media_gallery` varchar(255) DEFAULT NULL COMMENT 'Media Gallery',
  `megapixels` int(11) DEFAULT NULL COMMENT 'Megapixels',
  `megapixels_value` varchar(255) DEFAULT NULL COMMENT 'Megapixels Value',
  `memory` text COMMENT 'Memory',
  `meta_description` varchar(255) DEFAULT NULL COMMENT 'Meta Description',
  `meta_keyword` text COMMENT 'Meta Keyword',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Meta Title',
  `minimal_price` decimal(12,4) DEFAULT NULL COMMENT 'Minimal Price',
  `model` text COMMENT 'Model',
  `msrp` decimal(12,4) DEFAULT NULL COMMENT 'Msrp',
  `msrp_display_actual_price_type` varchar(255) DEFAULT NULL COMMENT 'Msrp Display Actual Price Type',
  `msrp_enabled` smallint(6) DEFAULT NULL COMMENT 'Msrp Enabled',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `news_from_date` datetime DEFAULT NULL COMMENT 'News From Date',
  `news_to_date` datetime DEFAULT NULL COMMENT 'News To Date',
  `old_id` int(11) DEFAULT NULL COMMENT 'Old Id',
  `price` decimal(12,4) DEFAULT NULL COMMENT 'Price',
  `price_type` int(11) DEFAULT NULL COMMENT 'Price Type',
  `price_view` int(11) DEFAULT NULL COMMENT 'Price View',
  `processor` text COMMENT 'Processor',
  `ram_size` varchar(255) DEFAULT NULL COMMENT 'Ram Size',
  `recurring_profile` text COMMENT 'Recurring Profile',
  `required_options` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Required Options',
  `response_time` varchar(255) DEFAULT NULL COMMENT 'Response Time',
  `room` int(11) DEFAULT NULL COMMENT 'Room',
  `room_value` varchar(255) DEFAULT NULL COMMENT 'Room Value',
  `samples_title` varchar(255) DEFAULT NULL COMMENT 'Samples Title',
  `screensize` text COMMENT 'Screensize',
  `shape` text COMMENT 'Shape',
  `shipment_type` int(11) DEFAULT NULL COMMENT 'Shipment Type',
  `shirt_size` int(11) DEFAULT NULL COMMENT 'Shirt Size',
  `shirt_size_value` varchar(255) DEFAULT NULL COMMENT 'Shirt Size Value',
  `shoe_size` int(11) DEFAULT NULL COMMENT 'Shoe Size',
  `shoe_size_value` varchar(255) DEFAULT NULL COMMENT 'Shoe Size Value',
  `shoe_type` int(11) DEFAULT NULL COMMENT 'Shoe Type',
  `shoe_type_value` varchar(255) DEFAULT NULL COMMENT 'Shoe Type Value',
  `short_description` text COMMENT 'Short Description',
  `sku` varchar(64) DEFAULT NULL COMMENT 'Sku',
  `sku_type` int(11) DEFAULT NULL COMMENT 'Sku Type',
  `small_image` varchar(255) DEFAULT NULL COMMENT 'Small Image',
  `small_image_label` varchar(255) DEFAULT NULL COMMENT 'Small Image Label',
  `special_from_date` datetime DEFAULT NULL COMMENT 'Special From Date',
  `special_price` decimal(12,4) DEFAULT NULL COMMENT 'Special Price',
  `special_to_date` datetime DEFAULT NULL COMMENT 'Special To Date',
  `tax_class_id` int(10) unsigned DEFAULT NULL COMMENT 'Tax Class Id',
  `thumbnail` varchar(255) DEFAULT NULL COMMENT 'Thumbnail',
  `thumbnail_label` varchar(255) DEFAULT NULL COMMENT 'Thumbnail Label',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'Url Key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'Url Path',
  `visibility` smallint(5) unsigned DEFAULT NULL COMMENT 'Visibility',
  `weight` decimal(12,4) DEFAULT NULL COMMENT 'Weight',
  `weight_type` int(11) DEFAULT NULL COMMENT 'Weight Type',
  PRIMARY KEY (`entity_id`),
  KEY `IDX_CATALOG_PRODUCT_FLAT_3_TYPE_ID` (`type_id`),
  KEY `IDX_CATALOG_PRODUCT_FLAT_3_ATTRIBUTE_SET_ID` (`attribute_set_id`),
  KEY `IDX_CATALOG_PRODUCT_FLAT_3_NAME` (`name`),
  KEY `IDX_CATALOG_PRODUCT_FLAT_3_PRICE` (`price`),
  CONSTRAINT `FK_CAT_PRD_FLAT_3_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Flat (Store 3)';

--
-- Dumping data for table `catalog_product_flat_3`
--


--
-- Table structure for table `catalog_product_index_eav`
--

CREATE TABLE `catalog_product_index_eav` (
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `value` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Value',
  PRIMARY KEY (`entity_id`,`attribute_id`,`store_id`,`value`),
  KEY `IDX_CATALOG_PRODUCT_INDEX_EAV_ENTITY_ID` (`entity_id`),
  KEY `IDX_CATALOG_PRODUCT_INDEX_EAV_ATTRIBUTE_ID` (`attribute_id`),
  KEY `IDX_CATALOG_PRODUCT_INDEX_EAV_STORE_ID` (`store_id`),
  KEY `IDX_CATALOG_PRODUCT_INDEX_EAV_VALUE` (`value`),
  CONSTRAINT `FK_CATALOG_PRODUCT_INDEX_EAV_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_PRD_IDX_EAV_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_PRD_IDX_EAV_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product EAV Index Table';

--
-- Dumping data for table `catalog_product_index_eav`
--

INSERT INTO `catalog_product_index_eav` VALUES (167,272,1,59),(167,272,2,59),(167,272,3,59),(168,272,1,25),(168,272,2,25),(168,272,3,25),(169,272,1,59),(169,272,2,59),(169,272,3,59);

--
-- Table structure for table `catalog_product_index_eav_decimal`
--

CREATE TABLE `catalog_product_index_eav_decimal` (
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `value` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Value',
  PRIMARY KEY (`entity_id`,`attribute_id`,`store_id`),
  KEY `IDX_CATALOG_PRODUCT_INDEX_EAV_DECIMAL_ENTITY_ID` (`entity_id`),
  KEY `IDX_CATALOG_PRODUCT_INDEX_EAV_DECIMAL_ATTRIBUTE_ID` (`attribute_id`),
  KEY `IDX_CATALOG_PRODUCT_INDEX_EAV_DECIMAL_STORE_ID` (`store_id`),
  KEY `IDX_CATALOG_PRODUCT_INDEX_EAV_DECIMAL_VALUE` (`value`),
  CONSTRAINT `FK_CAT_PRD_IDX_EAV_DEC_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_PRD_IDX_EAV_DEC_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_PRD_IDX_EAV_DEC_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product EAV Decimal Index Table';

--
-- Dumping data for table `catalog_product_index_eav_decimal`
--


--
-- Table structure for table `catalog_product_index_eav_decimal_idx`
--

CREATE TABLE `catalog_product_index_eav_decimal_idx` (
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `value` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Value',
  PRIMARY KEY (`entity_id`,`attribute_id`,`store_id`,`value`),
  KEY `IDX_CATALOG_PRODUCT_INDEX_EAV_DECIMAL_IDX_ENTITY_ID` (`entity_id`),
  KEY `IDX_CATALOG_PRODUCT_INDEX_EAV_DECIMAL_IDX_ATTRIBUTE_ID` (`attribute_id`),
  KEY `IDX_CATALOG_PRODUCT_INDEX_EAV_DECIMAL_IDX_STORE_ID` (`store_id`),
  KEY `IDX_CATALOG_PRODUCT_INDEX_EAV_DECIMAL_IDX_VALUE` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product EAV Decimal Indexer Index Table';

--
-- Dumping data for table `catalog_product_index_eav_decimal_idx`
--


--
-- Table structure for table `catalog_product_index_eav_decimal_tmp`
--

CREATE TABLE `catalog_product_index_eav_decimal_tmp` (
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `value` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Value',
  PRIMARY KEY (`entity_id`,`attribute_id`,`store_id`),
  KEY `IDX_CATALOG_PRODUCT_INDEX_EAV_DECIMAL_TMP_ENTITY_ID` (`entity_id`),
  KEY `IDX_CATALOG_PRODUCT_INDEX_EAV_DECIMAL_TMP_ATTRIBUTE_ID` (`attribute_id`),
  KEY `IDX_CATALOG_PRODUCT_INDEX_EAV_DECIMAL_TMP_STORE_ID` (`store_id`),
  KEY `IDX_CATALOG_PRODUCT_INDEX_EAV_DECIMAL_TMP_VALUE` (`value`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8 COMMENT='Catalog Product EAV Decimal Indexer Temp Table';

--
-- Dumping data for table `catalog_product_index_eav_decimal_tmp`
--


--
-- Table structure for table `catalog_product_index_eav_idx`
--

CREATE TABLE `catalog_product_index_eav_idx` (
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `value` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Value',
  PRIMARY KEY (`entity_id`,`attribute_id`,`store_id`,`value`),
  KEY `IDX_CATALOG_PRODUCT_INDEX_EAV_IDX_ENTITY_ID` (`entity_id`),
  KEY `IDX_CATALOG_PRODUCT_INDEX_EAV_IDX_ATTRIBUTE_ID` (`attribute_id`),
  KEY `IDX_CATALOG_PRODUCT_INDEX_EAV_IDX_STORE_ID` (`store_id`),
  KEY `IDX_CATALOG_PRODUCT_INDEX_EAV_IDX_VALUE` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product EAV Indexer Index Table';

--
-- Dumping data for table `catalog_product_index_eav_idx`
--

INSERT INTO `catalog_product_index_eav_idx` VALUES (140,102,1,111),(140,102,2,111),(140,102,3,111),(141,102,1,111),(141,102,2,111),(141,102,3,111),(143,102,1,111),(143,102,2,111),(143,102,3,111),(145,102,1,117),(145,102,2,117),(145,102,3,117),(147,102,1,3),(147,102,2,3),(147,102,3,3),(148,102,1,117),(148,102,2,117),(148,102,3,117),(149,102,1,118),(149,102,2,118),(149,102,3,118),(150,102,1,118),(150,102,2,118),(150,102,3,118),(151,102,1,116),(151,102,2,116),(151,102,3,116),(152,102,1,1),(152,102,2,1),(152,102,3,1),(153,102,1,116),(153,102,2,116),(153,102,3,116),(154,102,1,119),(154,102,2,119),(154,102,3,119),(155,102,1,119),(155,102,2,119),(155,102,3,119),(156,102,1,1),(156,102,2,1),(156,102,3,1),(157,102,1,29),(157,102,2,29),(157,102,3,29),(159,102,1,120),(159,102,2,120),(159,102,3,120),(160,102,1,121),(160,102,2,121),(160,102,3,121),(161,102,1,121),(161,102,2,121),(161,102,3,121),(162,102,1,120),(162,102,2,120),(162,102,3,120),(163,102,1,1),(163,102,1,3),(163,102,1,29),(163,102,1,111),(163,102,1,116),(163,102,1,117),(163,102,1,118),(163,102,1,119),(163,102,1,120),(163,102,1,121),(163,102,2,1),(163,102,2,3),(163,102,2,29),(163,102,2,111),(163,102,2,116),(163,102,2,117),(163,102,2,118),(163,102,2,119),(163,102,2,120),(163,102,2,121),(163,102,3,1),(163,102,3,3),(163,102,3,29),(163,102,3,111),(163,102,3,116),(163,102,3,117),(163,102,3,118),(163,102,3,119),(163,102,3,120),(163,102,3,121),(164,102,1,111),(164,102,1,116),(164,102,1,117),(164,102,1,118),(164,102,1,119),(164,102,1,120),(164,102,1,121),(164,102,2,111),(164,102,2,116),(164,102,2,117),(164,102,2,118),(164,102,2,119),(164,102,2,120),(164,102,2,121),(164,102,3,111),(164,102,3,116),(164,102,3,117),(164,102,3,118),(164,102,3,119),(164,102,3,120),(164,102,3,121),(165,102,1,1),(165,102,1,3),(165,102,1,29),(165,102,1,111),(165,102,1,116),(165,102,1,117),(165,102,1,118),(165,102,1,119),(165,102,2,1),(165,102,2,3),(165,102,2,29),(165,102,2,111),(165,102,2,116),(165,102,2,117),(165,102,2,118),(165,102,2,119),(165,102,3,1),(165,102,3,3),(165,102,3,29),(165,102,3,111),(165,102,3,116),(165,102,3,117),(165,102,3,118),(165,102,3,119),(166,102,1,122),(166,102,2,122),(166,102,3,122),(83,107,1,97),(83,107,2,97),(83,107,3,97),(93,107,1,49),(93,107,1,53),(93,107,2,49),(93,107,2,53),(93,107,3,49),(93,107,3,53),(98,107,1,49),(98,107,1,52),(98,107,2,49),(98,107,2,52),(98,107,3,49),(98,107,3,52),(103,107,1,51),(103,107,1,52),(103,107,2,51),(103,107,2,52),(103,107,3,51),(103,107,3,52),(108,107,1,51),(108,107,2,51),(108,107,3,51),(112,107,1,47),(112,107,2,47),(112,107,3,47),(135,107,1,97),(135,107,2,97),(135,107,3,97),(16,272,1,24),(16,272,2,24),(16,272,3,24),(17,272,1,23),(17,272,2,23),(17,272,3,23),(18,272,1,24),(18,272,2,24),(18,272,3,24),(19,272,1,23),(19,272,2,23),(19,272,3,23),(20,272,1,23),(20,272,2,23),(20,272,3,23),(25,272,1,23),(25,272,2,23),(25,272,3,23),(26,272,1,24),(26,272,2,24),(26,272,3,24),(27,272,1,24),(27,272,2,24),(27,272,3,24),(28,272,1,24),(28,272,2,24),(28,272,3,24),(39,272,1,22),(39,272,2,22),(39,272,3,22),(41,272,1,59),(41,272,2,59),(41,272,3,59),(42,272,1,59),(42,272,2,59),(42,272,3,59),(44,272,1,24),(44,272,2,24),(44,272,3,24),(45,272,1,23),(45,272,2,23),(45,272,3,23),(46,272,1,23),(46,272,2,23),(46,272,3,23),(47,272,1,23),(47,272,2,23),(47,272,3,23),(48,272,1,23),(48,272,2,23),(48,272,3,23),(51,272,1,26),(51,272,2,26),(51,272,3,26),(52,272,1,26),(52,272,2,26),(52,272,3,26),(53,272,1,26),(53,272,2,26),(53,272,3,26),(54,272,1,26),(54,272,2,26),(54,272,3,26),(83,272,1,25),(83,272,2,25),(83,272,3,25),(93,272,1,61),(93,272,2,61),(93,272,3,61),(98,272,1,24),(98,272,1,61),(98,272,2,24),(98,272,2,61),(98,272,3,24),(98,272,3,61),(103,272,1,26),(103,272,2,26),(103,272,3,26),(108,272,1,26),(108,272,2,26),(108,272,3,26),(112,272,1,59),(112,272,2,59),(112,272,3,59),(119,272,1,22),(119,272,2,22),(119,272,3,22),(120,272,1,60),(120,272,2,60),(120,272,3,60),(123,272,1,60),(123,272,2,60),(123,272,3,60),(126,272,1,22),(126,272,1,26),(126,272,2,22),(126,272,2,26),(126,272,3,22),(126,272,3,26),(135,272,1,59),(135,272,2,59),(135,272,3,59),(138,272,1,24),(138,272,2,24),(138,272,3,24),(139,272,1,23),(139,272,2,23),(139,272,3,23),(158,272,1,24),(158,272,2,24),(158,272,3,24),(160,272,1,59),(160,272,2,59),(160,272,3,59),(162,272,1,24),(162,272,2,24),(162,272,3,24),(163,272,1,23),(163,272,1,24),(163,272,1,59),(163,272,2,23),(163,272,2,24),(163,272,2,59),(163,272,3,23),(163,272,3,24),(163,272,3,59),(164,272,1,23),(164,272,1,24),(164,272,1,59),(164,272,2,23),(164,272,2,24),(164,272,2,59),(164,272,3,23),(164,272,3,24),(164,272,3,59),(165,272,1,23),(165,272,1,24),(165,272,2,23),(165,272,2,24),(165,272,3,23),(165,272,3,24),(166,272,1,24),(166,272,2,24),(166,272,3,24),(39,501,1,36),(39,501,2,36),(39,501,3,36),(83,501,1,35),(83,501,1,36),(83,501,2,35),(83,501,2,36),(83,501,3,35),(83,501,3,36),(93,501,1,36),(93,501,2,36),(93,501,3,36),(98,501,1,36),(98,501,2,36),(98,501,3,36),(103,501,1,35),(103,501,2,35),(103,501,3,35),(108,501,1,35),(108,501,2,35),(108,501,3,35),(112,501,1,35),(112,501,2,35),(112,501,3,35),(119,501,1,36),(119,501,2,36),(119,501,3,36),(120,501,1,35),(120,501,2,35),(120,501,3,35),(123,501,1,36),(123,501,2,36),(123,501,3,36),(126,501,1,36),(126,501,2,36),(126,501,3,36),(135,501,1,35),(135,501,2,35),(135,501,3,35),(25,510,1,77),(25,510,2,77),(25,510,3,77),(26,510,1,79),(26,510,2,79),(26,510,3,79),(27,510,1,76),(27,510,2,76),(27,510,3,76),(28,510,1,74),(28,510,2,74),(28,510,3,74),(158,510,1,76),(158,510,2,76),(158,510,3,76),(44,513,1,90),(44,513,2,90),(44,513,3,90),(45,513,1,93),(45,513,2,93),(45,513,3,93),(46,513,1,91),(46,513,2,91),(46,513,3,91),(47,513,1,90),(47,513,2,90),(47,513,3,90),(48,513,1,93),(48,513,2,93),(48,513,3,93),(147,875,1,110),(147,875,2,110),(147,875,3,110),(152,875,1,106),(152,875,2,106),(152,875,3,106),(156,875,1,106),(156,875,2,106),(156,875,3,106),(157,875,1,107),(157,875,2,107),(157,875,3,107),(163,875,1,106),(163,875,1,107),(163,875,1,110),(163,875,2,106),(163,875,2,107),(163,875,2,110),(163,875,3,106),(163,875,3,107),(163,875,3,110),(165,875,1,106),(165,875,1,107),(165,875,1,110),(165,875,2,106),(165,875,2,107),(165,875,2,110),(165,875,3,106),(165,875,3,107),(165,875,3,110);

--
-- Table structure for table `catalog_product_index_eav_tmp`
--

CREATE TABLE `catalog_product_index_eav_tmp` (
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `value` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Value',
  PRIMARY KEY (`entity_id`,`attribute_id`,`store_id`,`value`),
  KEY `IDX_CATALOG_PRODUCT_INDEX_EAV_TMP_ENTITY_ID` (`entity_id`),
  KEY `IDX_CATALOG_PRODUCT_INDEX_EAV_TMP_ATTRIBUTE_ID` (`attribute_id`),
  KEY `IDX_CATALOG_PRODUCT_INDEX_EAV_TMP_STORE_ID` (`store_id`),
  KEY `IDX_CATALOG_PRODUCT_INDEX_EAV_TMP_VALUE` (`value`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8 COMMENT='Catalog Product EAV Indexer Temp Table';

--
-- Dumping data for table `catalog_product_index_eav_tmp`
--


--
-- Table structure for table `catalog_product_index_group_price`
--

CREATE TABLE `catalog_product_index_group_price` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `customer_group_id` smallint(5) unsigned NOT NULL COMMENT 'Customer Group ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `price` decimal(12,4) DEFAULT NULL COMMENT 'Min Price',
  PRIMARY KEY (`entity_id`,`customer_group_id`,`website_id`),
  KEY `IDX_CATALOG_PRODUCT_INDEX_GROUP_PRICE_CUSTOMER_GROUP_ID` (`customer_group_id`),
  KEY `IDX_CATALOG_PRODUCT_INDEX_GROUP_PRICE_WEBSITE_ID` (`website_id`),
  CONSTRAINT `FK_195DF97C81B0BDD6A2EEC50F870E16D1` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_PRD_IDX_GROUP_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_PRD_IDX_GROUP_PRICE_WS_ID_CORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Group Price Index Table';

--
-- Dumping data for table `catalog_product_index_group_price`
--


--
-- Table structure for table `catalog_product_index_price`
--

CREATE TABLE `catalog_product_index_price` (
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `customer_group_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Customer Group ID',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID',
  `tax_class_id` smallint(5) unsigned DEFAULT '0' COMMENT 'Tax Class ID',
  `price` decimal(12,4) DEFAULT NULL COMMENT 'Price',
  `final_price` decimal(12,4) DEFAULT NULL COMMENT 'Final Price',
  `min_price` decimal(12,4) DEFAULT NULL COMMENT 'Min Price',
  `max_price` decimal(12,4) DEFAULT NULL COMMENT 'Max Price',
  `tier_price` decimal(12,4) DEFAULT NULL COMMENT 'Tier Price',
  `group_price` decimal(12,4) DEFAULT NULL COMMENT 'Group price',
  PRIMARY KEY (`entity_id`,`customer_group_id`,`website_id`),
  KEY `IDX_CATALOG_PRODUCT_INDEX_PRICE_CUSTOMER_GROUP_ID` (`customer_group_id`),
  KEY `IDX_CATALOG_PRODUCT_INDEX_PRICE_WEBSITE_ID` (`website_id`),
  KEY `IDX_CATALOG_PRODUCT_INDEX_PRICE_MIN_PRICE` (`min_price`),
  KEY `IDX_CAT_PRD_IDX_PRICE_WS_ID_CSTR_GROUP_ID_MIN_PRICE` (`website_id`,`customer_group_id`,`min_price`),
  CONSTRAINT `FK_CAT_PRD_IDX_PRICE_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_ID` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_PRD_IDX_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_CAT_PRD_IDX_PRICE_WS_ID_CORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Price Index Table';

--
-- Dumping data for table `catalog_product_index_price`
--

INSERT INTO `catalog_product_index_price` VALUES (167,0,1,0,205.0000,205.0000,205.0000,205.0000,NULL,NULL),(167,1,1,0,205.0000,205.0000,205.0000,205.0000,NULL,NULL),(167,2,1,0,205.0000,205.0000,205.0000,205.0000,NULL,NULL),(167,3,1,0,205.0000,205.0000,205.0000,205.0000,NULL,NULL),(167,4,1,0,205.0000,205.0000,205.0000,205.0000,NULL,NULL),(168,0,1,0,160.0000,160.0000,160.0000,160.0000,NULL,NULL),(168,1,1,0,160.0000,160.0000,160.0000,160.0000,NULL,NULL),(168,2,1,0,160.0000,160.0000,160.0000,160.0000,NULL,NULL),(168,3,1,0,160.0000,160.0000,160.0000,160.0000,NULL,NULL),(168,4,1,0,160.0000,160.0000,160.0000,160.0000,NULL,NULL),(169,0,1,0,160.0000,160.0000,160.0000,160.0000,NULL,NULL),(169,1,1,0,160.0000,160.0000,160.0000,160.0000,NULL,NULL),(169,2,1,0,160.0000,160.0000,160.0000,160.0000,NULL,NULL),(169,3,1,0,160.0000,160.0000,160.0000,160.0000,NULL,NULL),(169,4,1,0,160.0000,160.0000,160.0000,160.0000,NULL,NULL),(170,0,1,0,145.0000,145.0000,145.0000,145.0000,NULL,NULL),(170,1,1,0,145.0000,145.0000,145.0000,145.0000,NULL,NULL),(170,2,1,0,145.0000,145.0000,145.0000,145.0000,NULL,NULL),(170,3,1,0,145.0000,145.0000,145.0000,145.0000,NULL,NULL),(170,4,1,0,145.0000,145.0000,145.0000,145.0000,NULL,NULL),(171,0,1,0,145.0000,145.0000,145.0000,145.0000,NULL,NULL),(171,1,1,0,145.0000,145.0000,145.0000,145.0000,NULL,NULL),(171,2,1,0,145.0000,145.0000,145.0000,145.0000,NULL,NULL),(171,3,1,0,145.0000,145.0000,145.0000,145.0000,NULL,NULL),(171,4,1,0,145.0000,145.0000,145.0000,145.0000,NULL,NULL),(172,0,1,0,145.0000,145.0000,145.0000,145.0000,NULL,NULL),(172,1,1,0,145.0000,145.0000,145.0000,145.0000,NULL,NULL),(172,2,1,0,145.0000,145.0000,145.0000,145.0000,NULL,NULL),(172,3,1,0,145.0000,145.0000,145.0000,145.0000,NULL,NULL),(172,4,1,0,145.0000,145.0000,145.0000,145.0000,NULL,NULL),(173,0,1,0,205.0000,205.0000,205.0000,205.0000,NULL,NULL),(173,1,1,0,205.0000,205.0000,205.0000,205.0000,NULL,NULL),(173,2,1,0,205.0000,205.0000,205.0000,205.0000,NULL,NULL),(173,3,1,0,205.0000,205.0000,205.0000,205.0000,NULL,NULL),(173,4,1,0,205.0000,205.0000,205.0000,205.0000,NULL,NULL),(174,0,1,0,150.0000,150.0000,150.0000,150.0000,NULL,NULL),(174,1,1,0,150.0000,150.0000,150.0000,150.0000,NULL,NULL),(174,2,1,0,150.0000,150.0000,150.0000,150.0000,NULL,NULL),(174,3,1,0,150.0000,150.0000,150.0000,150.0000,NULL,NULL),(174,4,1,0,150.0000,150.0000,150.0000,150.0000,NULL,NULL),(175,0,1,0,135.0000,135.0000,135.0000,135.0000,NULL,NULL),(175,1,1,0,135.0000,135.0000,135.0000,135.0000,NULL,NULL),(175,2,1,0,135.0000,135.0000,135.0000,135.0000,NULL,NULL),(175,3,1,0,135.0000,135.0000,135.0000,135.0000,NULL,NULL),(175,4,1,0,135.0000,135.0000,135.0000,135.0000,NULL,NULL),(176,0,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(176,1,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(176,2,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(176,3,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(176,4,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(177,0,1,0,135.0000,135.0000,135.0000,135.0000,NULL,NULL),(177,1,1,0,135.0000,135.0000,135.0000,135.0000,NULL,NULL),(177,2,1,0,135.0000,135.0000,135.0000,135.0000,NULL,NULL),(177,3,1,0,135.0000,135.0000,135.0000,135.0000,NULL,NULL),(177,4,1,0,135.0000,135.0000,135.0000,135.0000,NULL,NULL),(178,0,1,0,115.0000,115.0000,115.0000,115.0000,NULL,NULL),(178,1,1,0,115.0000,115.0000,115.0000,115.0000,NULL,NULL),(178,2,1,0,115.0000,115.0000,115.0000,115.0000,NULL,NULL),(178,3,1,0,115.0000,115.0000,115.0000,115.0000,NULL,NULL),(178,4,1,0,115.0000,115.0000,115.0000,115.0000,NULL,NULL),(179,0,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(179,1,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(179,2,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(179,3,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(179,4,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(180,0,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(180,1,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(180,2,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(180,3,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(180,4,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(181,0,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(181,1,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(181,2,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(181,3,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(181,4,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(182,0,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(182,1,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(182,2,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(182,3,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(182,4,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(183,0,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(183,1,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(183,2,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(183,3,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(183,4,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(184,0,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(184,1,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(184,2,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(184,3,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(184,4,1,0,55.0000,55.0000,55.0000,55.0000,NULL,NULL),(185,0,1,0,125.0000,125.0000,125.0000,125.0000,NULL,NULL),(185,1,1,0,125.0000,125.0000,125.0000,125.0000,NULL,NULL),(185,2,1,0,125.0000,125.0000,125.0000,125.0000,NULL,NULL),(185,3,1,0,125.0000,125.0000,125.0000,125.0000,NULL,NULL),(185,4,1,0,125.0000,125.0000,125.0000,125.0000,NULL,NULL);

--
-- Table structure for table `catalog_product_index_price_bundle_idx`
--

CREATE TABLE `catalog_product_index_price_bundle_idx` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity Id',
  `customer_group_id` smallint(5) unsigned NOT NULL COMMENT 'Customer Group Id',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website Id',
  `tax_class_id` smallint(5) unsigned DEFAULT '0' COMMENT 'Tax Class Id',
  `price_type` smallint(5) unsigned NOT NULL COMMENT 'Price Type',
  `special_price` decimal(12,4) DEFAULT NULL COMMENT 'Special Price',
  `tier_percent` decimal(12,4) DEFAULT NULL COMMENT 'Tier Percent',
  `orig_price` decimal(12,4) DEFAULT NULL COMMENT 'Orig Price',
  `price` decimal(12,4) DEFAULT NULL COMMENT 'Price',
  `min_price` decimal(12,4) DEFAULT NULL COMMENT 'Min Price',
  `max_price` decimal(12,4) DEFAULT NULL COMMENT 'Max Price',
  `tier_price` decimal(12,4) DEFAULT NULL COMMENT 'Tier Price',
  `base_tier` decimal(12,4) DEFAULT NULL COMMENT 'Base Tier',
  `group_price` decimal(12,4) DEFAULT NULL COMMENT 'Group price',
  `base_group_price` decimal(12,4) DEFAULT NULL COMMENT 'Base Group Price',
  `group_price_percent` decimal(12,4) DEFAULT NULL COMMENT 'Group Price Percent',
  PRIMARY KEY (`entity_id`,`customer_group_id`,`website_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Index Price Bundle Idx';

--
-- Dumping data for table `catalog_product_index_price_bundle_idx`
--


--
-- Table structure for table `catalog_product_index_price_bundle_opt_idx`
--

CREATE TABLE `catalog_product_index_price_bundle_opt_idx` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity Id',
  `customer_group_id` smallint(5) unsigned NOT NULL COMMENT 'Customer Group Id',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website Id',
  `option_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Option Id',
  `min_price` decimal(12,4) DEFAULT NULL COMMENT 'Min Price',
  `alt_price` decimal(12,4) DEFAULT NULL COMMENT 'Alt Price',
  `max_price` decimal(12,4) DEFAULT NULL COMMENT 'Max Price',
  `tier_price` decimal(12,4) DEFAULT NULL COMMENT 'Tier Price',
  `alt_tier_price` decimal(12,4) DEFAULT NULL COMMENT 'Alt Tier Price',
  `group_price` decimal(12,4) DEFAULT NULL COMMENT 'Group price',
  `alt_group_price` decimal(12,4) DEFAULT NULL COMMENT 'Alt Group Price',
  PRIMARY KEY (`entity_id`,`customer_group_id`,`website_id`,`option_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Index Price Bundle Opt Idx';

--
-- Dumping data for table `catalog_product_index_price_bundle_opt_idx`
--


--
-- Table structure for table `catalog_product_index_price_bundle_opt_tmp`
--

CREATE TABLE `catalog_product_index_price_bundle_opt_tmp` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity Id',
  `customer_group_id` smallint(5) unsigned NOT NULL COMMENT 'Customer Group Id',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website Id',
  `option_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Option Id',
  `min_price` decimal(12,4) DEFAULT NULL COMMENT 'Min Price',
  `alt_price` decimal(12,4) DEFAULT NULL COMMENT 'Alt Price',
  `max_price` decimal(12,4) DEFAULT NULL COMMENT 'Max Price',
  `tier_price` decimal(12,4) DEFAULT NULL COMMENT 'Tier Price',
  `alt_tier_price` decimal(12,4) DEFAULT NULL COMMENT 'Alt Tier Price',
  `group_price` decimal(12,4) DEFAULT NULL COMMENT 'Group price',
  `alt_group_price` decimal(12,4) DEFAULT NULL COMMENT 'Alt Group Price',
  PRIMARY KEY (`entity_id`,`customer_group_id`,`website_id`,`option_id`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8 COMMENT='Catalog Product Index Price Bundle Opt Tmp';

--
