# phpMyAdmin MySQL-Dump
# version 2.4.0-rc1
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Aug 27, 2005 at 05:06 PM
# Server version: 4.0.16
# PHP Version: 4.3.10
# Database : `osc017`
# --------------------------------------------------------

#
# Table structure for table `address_book`
#

DROP TABLE IF EXISTS `address_book`;
CREATE TABLE `address_book` (
  `address_book_id` int(11) NOT NULL auto_increment,
  `customers_id` int(11) NOT NULL default '0',
  `entry_gender` char(1) NOT NULL default '',
  `entry_company` varchar(32) default NULL,
  `entry_firstname` varchar(32) NOT NULL default '',
  `entry_lastname` varchar(32) NOT NULL default '',
  `entry_street_address` varchar(64) NOT NULL default '',
  `entry_suburb` varchar(32) default NULL,
  `entry_postcode` varchar(10) NOT NULL default '',
  `entry_city` varchar(32) NOT NULL default '',
  `entry_state` varchar(32) default NULL,
  `entry_country_id` int(11) NOT NULL default '0',
  `entry_zone_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`address_book_id`),
  KEY `idx_address_book_customers_id` (`customers_id`)
) TYPE=MyISAM;

#
# Dumping data for table `address_book`
#

INSERT INTO `address_book` VALUES (1, 1, 'm', 'ACME Inc.', 'John', 'Doe', '1 Way Street', '', '12345', 'NeverNever', '', 223, 12),
(2, 2, 'm', '', 'sdfsdfsdsf', 'sdfsdfsdfd', 'sdfdf', 'sdfd', '22222', 'sdfsdfsdf', 'dfdfdfssdf', 3, 0);
# --------------------------------------------------------

#
# Table structure for table `address_format`
#

DROP TABLE IF EXISTS `address_format`;
CREATE TABLE `address_format` (
  `address_format_id` int(11) NOT NULL auto_increment,
  `address_format` varchar(128) NOT NULL default '',
  `address_summary` varchar(48) NOT NULL default '',
  PRIMARY KEY  (`address_format_id`)
) TYPE=MyISAM;

#
# Dumping data for table `address_format`
#

INSERT INTO `address_format` VALUES (1, '$firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country', '$city / $country'),
(2, '$firstname $lastname$cr$streets$cr$city, $state    $postcode$cr$country', '$city, $state / $country'),
(3, '$firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country', '$state / $country'),
(4, '$firstname $lastname$cr$streets$cr$city ($postcode)$cr$country', '$postcode / $country'),
(5, '$firstname $lastname$cr$streets$cr$postcode $city$cr$country', '$city / $country');
# --------------------------------------------------------

#
# Table structure for table `banners`
#

DROP TABLE IF EXISTS `banners`;
CREATE TABLE `banners` (
  `banners_id` int(11) NOT NULL auto_increment,
  `banners_title` varchar(64) NOT NULL default '',
  `banners_url` varchar(255) NOT NULL default '',
  `banners_image` varchar(64) NOT NULL default '',
  `banners_group` varchar(10) NOT NULL default '',
  `banners_html_text` text,
  `expires_impressions` int(7) default '0',
  `expires_date` datetime default NULL,
  `date_scheduled` datetime default NULL,
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `date_status_change` datetime default NULL,
  `status` int(1) NOT NULL default '1',
  PRIMARY KEY  (`banners_id`)
) TYPE=MyISAM;

#
# Dumping data for table `banners`
#

INSERT INTO `banners` VALUES (1, 'osCommerce', 'http://www.oscommerce.com', 'banners/oscommerce.gif', '468x50', '', NULL, NULL, NULL, '2005-07-07 10:38:22', '2005-08-10 17:05:41', 0);
# --------------------------------------------------------

#
# Table structure for table `banners_history`
#

DROP TABLE IF EXISTS `banners_history`;
CREATE TABLE `banners_history` (
  `banners_history_id` int(11) NOT NULL auto_increment,
  `banners_id` int(11) NOT NULL default '0',
  `banners_shown` int(5) NOT NULL default '0',
  `banners_clicked` int(5) NOT NULL default '0',
  `banners_history_date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`banners_history_id`)
) TYPE=MyISAM;

#
# Dumping data for table `banners_history`
#

INSERT INTO `banners_history` VALUES (1, 1, 424, 0, '2005-07-07 10:42:24'),
(2, 1, 1, 0, '2005-08-10 17:05:16');
# --------------------------------------------------------

#
# Table structure for table `categories`
#

DROP TABLE IF EXISTS `categories`;
CREATE TABLE `categories` (
  `categories_id` int(11) NOT NULL auto_increment,
  `categories_image` varchar(64) default NULL,
  `parent_id` int(11) NOT NULL default '0',
  `sort_order` int(3) default NULL,
  `date_added` datetime default NULL,
  `last_modified` datetime default NULL,
  PRIMARY KEY  (`categories_id`),
  KEY `idx_categories_parent_id` (`parent_id`)
) TYPE=MyISAM;

#
# Dumping data for table `categories`
#

INSERT INTO `categories` VALUES (52, NULL, 0, 50, '2005-07-19 17:00:54', NULL),
(54, NULL, 0, 60, '2005-07-19 17:01:49', NULL),
(55, NULL, 0, 70, '2005-07-19 17:08:18', NULL),
(56, NULL, 0, 80, '2005-07-19 17:08:43', NULL),
(57, NULL, 0, 90, '2005-07-19 17:09:01', NULL),
(58, NULL, 0, 100, '2005-07-19 17:10:14', NULL),
(59, NULL, 0, 110, '2005-07-19 17:10:28', NULL),
(60, NULL, 0, 120, '2005-07-19 17:10:40', NULL),
(51, NULL, 0, 40, '2005-07-19 17:00:37', NULL),
(50, NULL, 0, 30, '2005-07-19 17:00:26', NULL),
(49, NULL, 0, 20, '2005-07-19 17:00:16', NULL),
(48, NULL, 0, 10, '2005-07-19 17:00:05', NULL);
# --------------------------------------------------------

#
# Table structure for table `categories_description`
#

DROP TABLE IF EXISTS `categories_description`;
CREATE TABLE `categories_description` (
  `categories_id` int(11) NOT NULL default '0',
  `language_id` int(11) NOT NULL default '1',
  `categories_name` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`categories_id`,`language_id`),
  KEY `idx_categories_name` (`categories_name`)
) TYPE=MyISAM;

#
# Dumping data for table `categories_description`
#

INSERT INTO `categories_description` VALUES (59, 2, 'Underwear & Socks'),
(59, 3, 'Underwear & Socks'),
(60, 1, 'Workwear'),
(60, 2, 'Workwear'),
(60, 3, 'Workwear'),
(55, 3, 'Pajamas & Robes'),
(56, 1, 'Pants'),
(56, 2, 'Pants'),
(56, 3, 'Pants'),
(57, 1, 'Sweaters'),
(57, 2, 'Sweaters'),
(57, 3, 'Sweaters'),
(58, 1, 'Swim Suits & Shorts'),
(58, 2, 'Swim Suits & Shorts'),
(58, 3, 'Swim Suits & Shorts'),
(59, 1, 'Underwear & Socks'),
(54, 3, 'Outwear'),
(55, 1, 'Pajamas & Robes'),
(55, 2, 'Pajamas & Robes'),
(54, 2, 'Outwear'),
(54, 1, 'Outwear'),
(52, 3, 'Dress Shirts'),
(52, 2, 'Dress Shirts'),
(52, 1, 'Dress Shirts'),
(51, 3, 'Denim'),
(51, 2, 'Denim'),
(51, 1, 'Denim'),
(50, 3, 'Casual Shirts'),
(50, 2, 'Casual Shirts'),
(50, 1, 'Casual Shirts'),
(49, 3, 'Activewear'),
(49, 2, 'Activewear'),
(49, 1, 'Activewear'),
(48, 3, 'Accessories'),
(48, 2, 'Accessories'),
(48, 1, 'Accessories');
# --------------------------------------------------------

#
# Table structure for table `configuration`
#

DROP TABLE IF EXISTS `configuration`;
CREATE TABLE `configuration` (
  `configuration_id` int(11) NOT NULL auto_increment,
  `configuration_title` varchar(64) NOT NULL default '',
  `configuration_key` varchar(64) NOT NULL default '',
  `configuration_value` varchar(255) NOT NULL default '',
  `configuration_description` varchar(255) NOT NULL default '',
  `configuration_group_id` int(11) NOT NULL default '0',
  `sort_order` int(5) default NULL,
  `last_modified` datetime default NULL,
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `use_function` varchar(255) default NULL,
  `set_function` varchar(255) default NULL,
  PRIMARY KEY  (`configuration_id`)
) TYPE=MyISAM;

#
# Dumping data for table `configuration`
#

INSERT INTO `configuration` VALUES (1, 'Store Name', 'STORE_NAME', 'osCommerce', 'The name of my store', 1, 1, NULL, '2005-07-07 10:38:22', NULL, NULL),
(2, 'Store Owner', 'STORE_OWNER', 'Harald Ponce de Leon', 'The name of my store owner', 1, 2, NULL, '2005-07-07 10:38:22', NULL, NULL),
(3, 'E-Mail Address', 'STORE_OWNER_EMAIL_ADDRESS', 'root@localhost', 'The e-mail address of my store owner', 1, 3, NULL, '2005-07-07 10:38:22', NULL, NULL),
(4, 'E-Mail From', 'EMAIL_FROM', 'osCommerce <root@localhost>', 'The e-mail address used in (sent) e-mails', 1, 4, NULL, '2005-07-07 10:38:22', NULL, NULL),
(5, 'Country', 'STORE_COUNTRY', '223', 'The country my store is located in <br><br><b>Note: Please remember to update the store zone.</b>', 1, 6, NULL, '2005-07-07 10:38:22', 'tep_get_country_name', 'tep_cfg_pull_down_country_list('),
(6, 'Zone', 'STORE_ZONE', '18', 'The zone my store is located in', 1, 7, NULL, '2005-07-07 10:38:22', 'tep_cfg_get_zone_name', 'tep_cfg_pull_down_zone_list('),
(7, 'Expected Sort Order', 'EXPECTED_PRODUCTS_SORT', 'desc', 'This is the sort order used in the expected products box.', 1, 8, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'asc\', \'desc\'),'),
(8, 'Expected Sort Field', 'EXPECTED_PRODUCTS_FIELD', 'date_expected', 'The column to sort by in the expected products box.', 1, 9, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'products_name\', \'date_expected\'),'),
(9, 'Switch To Default Language Currency', 'USE_DEFAULT_LANGUAGE_CURRENCY', 'false', 'Automatically switch to the language\'s currency when it is changed', 1, 10, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(10, 'Send Extra Order Emails To', 'SEND_EXTRA_ORDER_EMAILS_TO', '', 'Send extra order emails to the following email addresses, in this format: Name 1 &lt;email@address1&gt;, Name 2 &lt;email@address2&gt;', 1, 11, NULL, '2005-07-07 10:38:22', NULL, NULL),
(11, 'Use Search-Engine Safe URLs (still in development)', 'SEARCH_ENGINE_FRIENDLY_URLS', 'false', 'Use search-engine safe urls for all site links', 1, 12, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(12, 'Display Cart After Adding Product', 'DISPLAY_CART', 'true', 'Display the shopping cart after adding a product (or return back to their origin)', 1, 14, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(13, 'Allow Guest To Tell A Friend', 'ALLOW_GUEST_TO_TELL_A_FRIEND', 'false', 'Allow guests to tell a friend about a product', 1, 15, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(14, 'Default Search Operator', 'ADVANCED_SEARCH_DEFAULT_OPERATOR', 'and', 'Default search operators', 1, 17, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'and\', \'or\'),'),
(15, 'Store Address and Phone', 'STORE_NAME_ADDRESS', 'Store Name\nAddress\nCountry\nPhone', 'This is the Store Name, Address and Phone used on printable documents and displayed online', 1, 18, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_textarea('),
(16, 'Show Category Counts', 'SHOW_COUNTS', 'true', 'Count recursively how many products are in each category', 1, 19, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(17, 'Tax Decimal Places', 'TAX_DECIMAL_PLACES', '0', 'Pad the tax value this amount of decimal places', 1, 20, NULL, '2005-07-07 10:38:22', NULL, NULL),
(18, 'Display Prices with Tax', 'DISPLAY_PRICE_WITH_TAX', 'false', 'Display prices with tax included (true) or add the tax at the end (false)', 1, 21, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(19, 'First Name', 'ENTRY_FIRST_NAME_MIN_LENGTH', '2', 'Minimum length of first name', 2, 1, NULL, '2005-07-07 10:38:22', NULL, NULL),
(20, 'Last Name', 'ENTRY_LAST_NAME_MIN_LENGTH', '2', 'Minimum length of last name', 2, 2, NULL, '2005-07-07 10:38:22', NULL, NULL),
(21, 'Date of Birth', 'ENTRY_DOB_MIN_LENGTH', '10', 'Minimum length of date of birth', 2, 3, NULL, '2005-07-07 10:38:22', NULL, NULL),
(22, 'E-Mail Address', 'ENTRY_EMAIL_ADDRESS_MIN_LENGTH', '6', 'Minimum length of e-mail address', 2, 4, NULL, '2005-07-07 10:38:22', NULL, NULL),
(23, 'Street Address', 'ENTRY_STREET_ADDRESS_MIN_LENGTH', '5', 'Minimum length of street address', 2, 5, NULL, '2005-07-07 10:38:22', NULL, NULL),
(24, 'Company', 'ENTRY_COMPANY_MIN_LENGTH', '2', 'Minimum length of company name', 2, 6, NULL, '2005-07-07 10:38:22', NULL, NULL),
(25, 'Post Code', 'ENTRY_POSTCODE_MIN_LENGTH', '4', 'Minimum length of post code', 2, 7, NULL, '2005-07-07 10:38:22', NULL, NULL),
(26, 'City', 'ENTRY_CITY_MIN_LENGTH', '3', 'Minimum length of city', 2, 8, NULL, '2005-07-07 10:38:22', NULL, NULL),
(27, 'State', 'ENTRY_STATE_MIN_LENGTH', '2', 'Minimum length of state', 2, 9, NULL, '2005-07-07 10:38:22', NULL, NULL),
(28, 'Telephone Number', 'ENTRY_TELEPHONE_MIN_LENGTH', '3', 'Minimum length of telephone number', 2, 10, NULL, '2005-07-07 10:38:22', NULL, NULL),
(29, 'Password', 'ENTRY_PASSWORD_MIN_LENGTH', '5', 'Minimum length of password', 2, 11, NULL, '2005-07-07 10:38:22', NULL, NULL),
(30, 'Credit Card Owner Name', 'CC_OWNER_MIN_LENGTH', '3', 'Minimum length of credit card owner name', 2, 12, NULL, '2005-07-07 10:38:22', NULL, NULL),
(31, 'Credit Card Number', 'CC_NUMBER_MIN_LENGTH', '10', 'Minimum length of credit card number', 2, 13, NULL, '2005-07-07 10:38:22', NULL, NULL),
(32, 'Review Text', 'REVIEW_TEXT_MIN_LENGTH', '50', 'Minimum length of review text', 2, 14, NULL, '2005-07-07 10:38:22', NULL, NULL),
(33, 'Best Sellers', 'MIN_DISPLAY_BESTSELLERS', '1', 'Minimum number of best sellers to display', 2, 15, NULL, '2005-07-07 10:38:22', NULL, NULL),
(34, 'Also Purchased', 'MIN_DISPLAY_ALSO_PURCHASED', '1', 'Minimum number of products to display in the \'This Customer Also Purchased\' box', 2, 16, NULL, '2005-07-07 10:38:22', NULL, NULL),
(35, 'Address Book Entries', 'MAX_ADDRESS_BOOK_ENTRIES', '5', 'Maximum address book entries a customer is allowed to have', 3, 1, NULL, '2005-07-07 10:38:22', NULL, NULL),
(36, 'Search Results', 'MAX_DISPLAY_SEARCH_RESULTS', '6', 'Amount of products to list', 3, 2, '2005-08-27 17:03:49', '2005-07-07 10:38:22', NULL, NULL),
(37, 'Page Links', 'MAX_DISPLAY_PAGE_LINKS', '5', 'Number of \'number\' links use for page-sets', 3, 3, NULL, '2005-07-07 10:38:22', NULL, NULL),
(38, 'Special Products', 'MAX_DISPLAY_SPECIAL_PRODUCTS', '9', 'Maximum number of products on special to display', 3, 4, NULL, '2005-07-07 10:38:22', NULL, NULL),
(39, 'New Products Module', 'MAX_DISPLAY_NEW_PRODUCTS', '6', 'Maximum number of new products to display in a category', 3, 5, '2005-08-27 16:55:42', '2005-07-07 10:38:22', NULL, NULL),
(40, 'Products Expected', 'MAX_DISPLAY_UPCOMING_PRODUCTS', '10', 'Maximum number of products expected to display', 3, 6, NULL, '2005-07-07 10:38:22', NULL, NULL),
(41, 'Manufacturers List', 'MAX_DISPLAY_MANUFACTURERS_IN_A_LIST', '0', 'Used in manufacturers box; when the number of manufacturers exceeds this number, a drop-down list will be displayed instead of the default list', 3, 7, NULL, '2005-07-07 10:38:22', NULL, NULL),
(42, 'Manufacturers Select Size', 'MAX_MANUFACTURERS_LIST', '1', 'Used in manufacturers box; when this value is \'1\' the classic drop-down list will be used for the manufacturers box. Otherwise, a list-box with the specified number of rows will be displayed.', 3, 7, NULL, '2005-07-07 10:38:22', NULL, NULL),
(43, 'Length of Manufacturers Name', 'MAX_DISPLAY_MANUFACTURER_NAME_LEN', '15', 'Used in manufacturers box; maximum length of manufacturers name to display', 3, 8, NULL, '2005-07-07 10:38:22', NULL, NULL),
(44, 'New Reviews', 'MAX_DISPLAY_NEW_REVIEWS', '6', 'Maximum number of new reviews to display', 3, 9, NULL, '2005-07-07 10:38:22', NULL, NULL),
(45, 'Selection of Random Reviews', 'MAX_RANDOM_SELECT_REVIEWS', '10', 'How many records to select from to choose one random product review', 3, 10, NULL, '2005-07-07 10:38:22', NULL, NULL),
(46, 'Selection of Random New Products', 'MAX_RANDOM_SELECT_NEW', '10', 'How many records to select from to choose one random new product to display', 3, 11, NULL, '2005-07-07 10:38:22', NULL, NULL),
(47, 'Selection of Products on Special', 'MAX_RANDOM_SELECT_SPECIALS', '10', 'How many records to select from to choose one random product special to display', 3, 12, NULL, '2005-07-07 10:38:22', NULL, NULL),
(48, 'Categories To List Per Row', 'MAX_DISPLAY_CATEGORIES_PER_ROW', '3', 'How many categories to list per row', 3, 13, NULL, '2005-07-07 10:38:22', NULL, NULL),
(49, 'New Products Listing', 'MAX_DISPLAY_PRODUCTS_NEW', '10', 'Maximum number of new products to display in new products page', 3, 14, NULL, '2005-07-07 10:38:22', NULL, NULL),
(50, 'Best Sellers', 'MAX_DISPLAY_BESTSELLERS', '6', 'Maximum number of best sellers to display', 3, 15, '2005-07-11 18:48:14', '2005-07-07 10:38:22', NULL, NULL),
(51, 'Also Purchased', 'MAX_DISPLAY_ALSO_PURCHASED', '6', 'Maximum number of products to display in the \'This Customer Also Purchased\' box', 3, 16, NULL, '2005-07-07 10:38:22', NULL, NULL),
(52, 'Customer Order History Box', 'MAX_DISPLAY_PRODUCTS_IN_ORDER_HISTORY_BOX', '6', 'Maximum number of products to display in the customer order history box', 3, 17, NULL, '2005-07-07 10:38:22', NULL, NULL),
(53, 'Order History', 'MAX_DISPLAY_ORDER_HISTORY', '10', 'Maximum number of orders to display in the order history page', 3, 18, NULL, '2005-07-07 10:38:22', NULL, NULL),
(54, 'Small Image Width', 'SMALL_IMAGE_WIDTH', '110', 'The pixel width of small images', 4, 1, '2005-07-19 19:18:56', '2005-07-07 10:38:22', NULL, NULL),
(55, 'Small Image Height', 'SMALL_IMAGE_HEIGHT', '110', 'The pixel height of small images', 4, 2, '2005-07-19 19:19:02', '2005-07-07 10:38:22', NULL, NULL),
(56, 'Heading Image Width', 'HEADING_IMAGE_WIDTH', '0', 'The pixel width of heading images', 4, 3, '2005-07-07 11:40:02', '2005-07-07 10:38:22', NULL, NULL),
(57, 'Heading Image Height', 'HEADING_IMAGE_HEIGHT', '1', 'The pixel height of heading images', 4, 4, '2005-07-07 11:40:07', '2005-07-07 10:38:22', NULL, NULL),
(58, 'Subcategory Image Width', 'SUBCATEGORY_IMAGE_WIDTH', '0', 'The pixel width of subcategory images', 4, 5, '2005-07-07 16:11:36', '2005-07-07 10:38:22', NULL, NULL),
(59, 'Subcategory Image Height', 'SUBCATEGORY_IMAGE_HEIGHT', '1', 'The pixel height of subcategory images', 4, 6, '2005-07-07 16:11:42', '2005-07-07 10:38:22', NULL, NULL),
(60, 'Calculate Image Size', 'CONFIG_CALCULATE_IMAGE_SIZE', 'true', 'Calculate the size of images?', 4, 7, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(61, 'Image Required', 'IMAGE_REQUIRED', 'true', 'Enable to display broken images. Good for development.', 4, 8, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(62, 'Gender', 'ACCOUNT_GENDER', 'true', 'Display gender in the customers account', 5, 1, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(63, 'Date of Birth', 'ACCOUNT_DOB', 'true', 'Display date of birth in the customers account', 5, 2, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(64, 'Company', 'ACCOUNT_COMPANY', 'true', 'Display company in the customers account', 5, 3, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(65, 'Suburb', 'ACCOUNT_SUBURB', 'true', 'Display suburb in the customers account', 5, 4, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(66, 'State', 'ACCOUNT_STATE', 'true', 'Display state in the customers account', 5, 5, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(67, 'Installed Modules', 'MODULE_PAYMENT_INSTALLED', 'cc.php;cod.php', 'List of payment module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: cc.php;cod.php;paypal.php)', 6, 0, NULL, '2005-07-07 10:38:22', NULL, NULL),
(68, 'Installed Modules', 'MODULE_ORDER_TOTAL_INSTALLED', 'ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php', 'List of order_total module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php)', 6, 0, NULL, '2005-07-07 10:38:22', NULL, NULL),
(69, 'Installed Modules', 'MODULE_SHIPPING_INSTALLED', 'flat.php', 'List of shipping module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: ups.php;flat.php;item.php)', 6, 0, NULL, '2005-07-07 10:38:22', NULL, NULL),
(70, 'Enable Cash On Delivery Module', 'MODULE_PAYMENT_COD_STATUS', 'True', 'Do you want to accept Cash On Delevery payments?', 6, 1, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),'),
(71, 'Payment Zone', 'MODULE_PAYMENT_COD_ZONE', '0', 'If a zone is selected, only enable this payment method for that zone.', 6, 2, NULL, '2005-07-07 10:38:22', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes('),
(72, 'Sort order of display.', 'MODULE_PAYMENT_COD_SORT_ORDER', '0', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, '2005-07-07 10:38:22', NULL, NULL),
(73, 'Set Order Status', 'MODULE_PAYMENT_COD_ORDER_STATUS_ID', '0', 'Set the status of orders made with this payment module to this value', 6, 0, NULL, '2005-07-07 10:38:22', 'tep_get_order_status_name', 'tep_cfg_pull_down_order_statuses('),
(74, 'Enable Credit Card Module', 'MODULE_PAYMENT_CC_STATUS', 'True', 'Do you want to accept credit card payments?', 6, 0, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),'),
(75, 'Split Credit Card E-Mail Address', 'MODULE_PAYMENT_CC_EMAIL', '', 'If an e-mail address is entered, the middle digits of the credit card number will be sent to the e-mail address (the outside digits are stored in the database with the middle digits censored)', 6, 0, NULL, '2005-07-07 10:38:22', NULL, NULL),
(76, 'Sort order of display.', 'MODULE_PAYMENT_CC_SORT_ORDER', '0', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, '2005-07-07 10:38:22', NULL, NULL),
(77, 'Payment Zone', 'MODULE_PAYMENT_CC_ZONE', '0', 'If a zone is selected, only enable this payment method for that zone.', 6, 2, NULL, '2005-07-07 10:38:22', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes('),
(78, 'Set Order Status', 'MODULE_PAYMENT_CC_ORDER_STATUS_ID', '0', 'Set the status of orders made with this payment module to this value', 6, 0, NULL, '2005-07-07 10:38:22', 'tep_get_order_status_name', 'tep_cfg_pull_down_order_statuses('),
(79, 'Enable Flat Shipping', 'MODULE_SHIPPING_FLAT_STATUS', 'True', 'Do you want to offer flat rate shipping?', 6, 0, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),'),
(80, 'Shipping Cost', 'MODULE_SHIPPING_FLAT_COST', '5.00', 'The shipping cost for all orders using this shipping method.', 6, 0, NULL, '2005-07-07 10:38:22', NULL, NULL),
(81, 'Tax Class', 'MODULE_SHIPPING_FLAT_TAX_CLASS', '0', 'Use the following tax class on the shipping fee.', 6, 0, NULL, '2005-07-07 10:38:22', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes('),
(82, 'Shipping Zone', 'MODULE_SHIPPING_FLAT_ZONE', '0', 'If a zone is selected, only enable this shipping method for that zone.', 6, 0, NULL, '2005-07-07 10:38:22', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes('),
(83, 'Sort Order', 'MODULE_SHIPPING_FLAT_SORT_ORDER', '0', 'Sort order of display.', 6, 0, NULL, '2005-07-07 10:38:22', NULL, NULL),
(84, 'Default Currency', 'DEFAULT_CURRENCY', 'USD', 'Default Currency', 6, 0, NULL, '2005-07-07 10:38:22', NULL, NULL),
(85, 'Default Language', 'DEFAULT_LANGUAGE', 'en', 'Default Language', 6, 0, NULL, '2005-07-07 10:38:22', NULL, NULL),
(86, 'Default Order Status For New Orders', 'DEFAULT_ORDERS_STATUS_ID', '1', 'When a new order is created, this order status will be assigned to it.', 6, 0, NULL, '2005-07-07 10:38:22', NULL, NULL),
(87, 'Display Shipping', 'MODULE_ORDER_TOTAL_SHIPPING_STATUS', 'true', 'Do you want to display the order shipping cost?', 6, 1, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(88, 'Sort Order', 'MODULE_ORDER_TOTAL_SHIPPING_SORT_ORDER', '2', 'Sort order of display.', 6, 2, NULL, '2005-07-07 10:38:22', NULL, NULL),
(89, 'Allow Free Shipping', 'MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING', 'false', 'Do you want to allow free shipping?', 6, 3, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(90, 'Free Shipping For Orders Over', 'MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER', '50', 'Provide free shipping for orders over the set amount.', 6, 4, NULL, '2005-07-07 10:38:22', 'currencies->format', NULL),
(91, 'Provide Free Shipping For Orders Made', 'MODULE_ORDER_TOTAL_SHIPPING_DESTINATION', 'national', 'Provide free shipping for orders sent to the set destination.', 6, 5, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'national\', \'international\', \'both\'),'),
(92, 'Display Sub-Total', 'MODULE_ORDER_TOTAL_SUBTOTAL_STATUS', 'true', 'Do you want to display the order sub-total cost?', 6, 1, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(93, 'Sort Order', 'MODULE_ORDER_TOTAL_SUBTOTAL_SORT_ORDER', '1', 'Sort order of display.', 6, 2, NULL, '2005-07-07 10:38:22', NULL, NULL),
(94, 'Display Tax', 'MODULE_ORDER_TOTAL_TAX_STATUS', 'true', 'Do you want to display the order tax value?', 6, 1, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(95, 'Sort Order', 'MODULE_ORDER_TOTAL_TAX_SORT_ORDER', '3', 'Sort order of display.', 6, 2, NULL, '2005-07-07 10:38:22', NULL, NULL),
(96, 'Display Total', 'MODULE_ORDER_TOTAL_TOTAL_STATUS', 'true', 'Do you want to display the total order value?', 6, 1, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(97, 'Sort Order', 'MODULE_ORDER_TOTAL_TOTAL_SORT_ORDER', '4', 'Sort order of display.', 6, 2, NULL, '2005-07-07 10:38:22', NULL, NULL),
(98, 'Country of Origin', 'SHIPPING_ORIGIN_COUNTRY', '223', 'Select the country of origin to be used in shipping quotes.', 7, 1, NULL, '2005-07-07 10:38:22', 'tep_get_country_name', 'tep_cfg_pull_down_country_list('),
(99, 'Postal Code', 'SHIPPING_ORIGIN_ZIP', 'NONE', 'Enter the Postal Code (ZIP) of the Store to be used in shipping quotes.', 7, 2, NULL, '2005-07-07 10:38:22', NULL, NULL),
(100, 'Enter the Maximum Package Weight you will ship', 'SHIPPING_MAX_WEIGHT', '50', 'Carriers have a max weight limit for a single package. This is a common one for all.', 7, 3, NULL, '2005-07-07 10:38:22', NULL, NULL),
(101, 'Package Tare weight.', 'SHIPPING_BOX_WEIGHT', '3', 'What is the weight of typical packaging of small to medium packages?', 7, 4, NULL, '2005-07-07 10:38:22', NULL, NULL),
(102, 'Larger packages - percentage increase.', 'SHIPPING_BOX_PADDING', '10', 'For 10% enter 10', 7, 5, NULL, '2005-07-07 10:38:22', NULL, NULL),
(103, 'Display Product Image', 'PRODUCT_LIST_IMAGE', '1', 'Do you want to display the Product Image?', 8, 1, NULL, '2005-07-07 10:38:22', NULL, NULL),
(104, 'Display Product Manufaturer Name', 'PRODUCT_LIST_MANUFACTURER', '0', 'Do you want to display the Product Manufacturer Name?', 8, 2, NULL, '2005-07-07 10:38:22', NULL, NULL),
(105, 'Display Product Model', 'PRODUCT_LIST_MODEL', '0', 'Do you want to display the Product Model?', 8, 3, NULL, '2005-07-07 10:38:22', NULL, NULL),
(106, 'Display Product Name', 'PRODUCT_LIST_NAME', '2', 'Do you want to display the Product Name?', 8, 4, NULL, '2005-07-07 10:38:22', NULL, NULL),
(107, 'Display Product Price', 'PRODUCT_LIST_PRICE', '3', 'Do you want to display the Product Price', 8, 5, NULL, '2005-07-07 10:38:22', NULL, NULL),
(108, 'Display Product Quantity', 'PRODUCT_LIST_QUANTITY', '0', 'Do you want to display the Product Quantity?', 8, 6, NULL, '2005-07-07 10:38:22', NULL, NULL),
(109, 'Display Product Weight', 'PRODUCT_LIST_WEIGHT', '0', 'Do you want to display the Product Weight?', 8, 7, NULL, '2005-07-07 10:38:22', NULL, NULL),
(110, 'Display Buy Now column', 'PRODUCT_LIST_BUY_NOW', '4', 'Do you want to display the Buy Now column?', 8, 8, NULL, '2005-07-07 10:38:22', NULL, NULL),
(111, 'Display Category/Manufacturer Filter (0=disable; 1=enable)', 'PRODUCT_LIST_FILTER', '1', 'Do you want to display the Category/Manufacturer Filter?', 8, 9, NULL, '2005-07-07 10:38:22', NULL, NULL),
(112, 'Location of Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)', 'PREV_NEXT_BAR_LOCATION', '2', 'Sets the location of the Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)', 8, 10, NULL, '2005-07-07 10:38:22', NULL, NULL),
(113, 'Check stock level', 'STOCK_CHECK', 'true', 'Check to see if sufficent stock is available', 9, 1, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(114, 'Subtract stock', 'STOCK_LIMITED', 'true', 'Subtract product in stock by product orders', 9, 2, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(115, 'Allow Checkout', 'STOCK_ALLOW_CHECKOUT', 'true', 'Allow customer to checkout even if there is insufficient stock', 9, 3, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(116, 'Mark product out of stock', 'STOCK_MARK_PRODUCT_OUT_OF_STOCK', '***', 'Display something on screen so customer can see which product has insufficient stock', 9, 4, NULL, '2005-07-07 10:38:22', NULL, NULL),
(117, 'Stock Re-order level', 'STOCK_REORDER_LEVEL', '5', 'Define when stock needs to be re-ordered', 9, 5, NULL, '2005-07-07 10:38:22', NULL, NULL),
(118, 'Store Page Parse Time', 'STORE_PAGE_PARSE_TIME', 'false', 'Store the time it takes to parse a page', 10, 1, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(119, 'Log Destination', 'STORE_PAGE_PARSE_TIME_LOG', '/var/log/www/tep/page_parse_time.log', 'Directory and filename of the page parse time log', 10, 2, NULL, '2005-07-07 10:38:22', NULL, NULL),
(120, 'Log Date Format', 'STORE_PARSE_DATE_TIME_FORMAT', '%d/%m/%Y %H:%M:%S', 'The date format', 10, 3, NULL, '2005-07-07 10:38:22', NULL, NULL),
(121, 'Display The Page Parse Time', 'DISPLAY_PAGE_PARSE_TIME', 'true', 'Display the page parse time (store page parse time must be enabled)', 10, 4, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(122, 'Store Database Queries', 'STORE_DB_TRANSACTIONS', 'false', 'Store the database queries in the page parse time log (PHP4 only)', 10, 5, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(123, 'Use Cache', 'USE_CACHE', 'false', 'Use caching features', 11, 1, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(124, 'Cache Directory', 'DIR_FS_CACHE', '/tmp/', 'The directory where the cached files are saved', 11, 2, NULL, '2005-07-07 10:38:22', NULL, NULL),
(125, 'E-Mail Transport Method', 'EMAIL_TRANSPORT', 'sendmail', 'Defines if this server uses a local connection to sendmail or uses an SMTP connection via TCP/IP. Servers running on Windows and MacOS should change this setting to SMTP.', 12, 1, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'sendmail\', \'smtp\'),'),
(126, 'E-Mail Linefeeds', 'EMAIL_LINEFEED', 'LF', 'Defines the character sequence used to separate mail headers.', 12, 2, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'LF\', \'CRLF\'),'),
(127, 'Use MIME HTML When Sending Emails', 'EMAIL_USE_HTML', 'false', 'Send e-mails in HTML format', 12, 3, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(128, 'Verify E-Mail Addresses Through DNS', 'ENTRY_EMAIL_ADDRESS_CHECK', 'false', 'Verify e-mail address through a DNS server', 12, 4, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(129, 'Send E-Mails', 'SEND_EMAILS', 'true', 'Send out e-mails', 12, 5, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(130, 'Enable download', 'DOWNLOAD_ENABLED', 'false', 'Enable the products download functions.', 13, 1, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(131, 'Download by redirect', 'DOWNLOAD_BY_REDIRECT', 'false', 'Use browser redirection for download. Disable on non-Unix systems.', 13, 2, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(132, 'Expiry delay (days)', 'DOWNLOAD_MAX_DAYS', '7', 'Set number of days before the download link expires. 0 means no limit.', 13, 3, NULL, '2005-07-07 10:38:22', NULL, ''),
(133, 'Maximum number of downloads', 'DOWNLOAD_MAX_COUNT', '5', 'Set the maximum number of downloads. 0 means no download authorized.', 13, 4, NULL, '2005-07-07 10:38:22', NULL, ''),
(134, 'Enable GZip Compression', 'GZIP_COMPRESSION', 'false', 'Enable HTTP GZip compression.', 14, 1, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),'),
(135, 'Compression Level', 'GZIP_LEVEL', '5', 'Use this compression level 0-9 (0 = minimum, 9 = maximum).', 14, 2, NULL, '2005-07-07 10:38:22', NULL, NULL),
(136, 'Session Directory', 'SESSION_WRITE_DIRECTORY', '/tmp', 'If sessions are file based, store them in this directory.', 15, 1, NULL, '2005-07-07 10:38:22', NULL, NULL),
(137, 'Force Cookie Use', 'SESSION_FORCE_COOKIE_USE', 'True', 'Force the use of sessions when cookies are only enabled.', 15, 2, '2005-07-11 12:48:14', '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),'),
(138, 'Check SSL Session ID', 'SESSION_CHECK_SSL_SESSION_ID', 'False', 'Validate the SSL_SESSION_ID on every secure HTTPS page request.', 15, 3, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),'),
(139, 'Check User Agent', 'SESSION_CHECK_USER_AGENT', 'False', 'Validate the clients browser user agent on every page request.', 15, 4, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),'),
(140, 'Check IP Address', 'SESSION_CHECK_IP_ADDRESS', 'False', 'Validate the clients IP address on every page request.', 15, 5, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),'),
(141, 'Prevent Spider Sessions', 'SESSION_BLOCK_SPIDERS', 'False', 'Prevent known spiders from starting a session.', 15, 6, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),'),
(142, 'Recreate Session', 'SESSION_RECREATE', 'False', 'Recreate the session to generate a new session ID when the customer logs on or creates an account (PHP >=4.1 needed).', 15, 7, NULL, '2005-07-07 10:38:22', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),');
# --------------------------------------------------------

#
# Table structure for table `configuration_group`
#

DROP TABLE IF EXISTS `configuration_group`;
CREATE TABLE `configuration_group` (
  `configuration_group_id` int(11) NOT NULL auto_increment,
  `configuration_group_title` varchar(64) NOT NULL default '',
  `configuration_group_description` varchar(255) NOT NULL default '',
  `sort_order` int(5) default NULL,
  `visible` int(1) default '1',
  PRIMARY KEY  (`configuration_group_id`)
) TYPE=MyISAM;

#
# Dumping data for table `configuration_group`
#

INSERT INTO `configuration_group` VALUES (1, 'My Store', 'General information about my store', 1, 1),
(2, 'Minimum Values', 'The minimum values for functions / data', 2, 1),
(3, 'Maximum Values', 'The maximum values for functions / data', 3, 1),
(4, 'Images', 'Image parameters', 4, 1),
(5, 'Customer Details', 'Customer account configuration', 5, 1),
(6, 'Module Options', 'Hidden from configuration', 6, 0),
(7, 'Shipping/Packaging', 'Shipping options available at my store', 7, 1),
(8, 'Product Listing', 'Product Listing    configuration options', 8, 1),
(9, 'Stock', 'Stock configuration options', 9, 1),
(10, 'Logging', 'Logging configuration options', 10, 1),
(11, 'Cache', 'Caching configuration options', 11, 1),
(12, 'E-Mail Options', 'General setting for E-Mail transport and HTML E-Mails', 12, 1),
(13, 'Download', 'Downloadable products options', 13, 1),
(14, 'GZip Compression', 'GZip compression options', 14, 1),
(15, 'Sessions', 'Session options', 15, 1);
# --------------------------------------------------------

#
# Table structure for table `counter`
#

DROP TABLE IF EXISTS `counter`;
CREATE TABLE `counter` (
  `startdate` char(8) default NULL,
  `counter` int(12) default NULL
) TYPE=MyISAM;

#
# Dumping data for table `counter`
#

INSERT INTO `counter` VALUES ('20050707', 2535);
# --------------------------------------------------------

#
# Table structure for table `counter_history`
#

DROP TABLE IF EXISTS `counter_history`;
CREATE TABLE `counter_history` (
  `month` char(8) default NULL,
  `counter` int(12) default NULL
) TYPE=MyISAM;

#
# Dumping data for table `counter_history`
#

# --------------------------------------------------------

#
# Table structure for table `countries`
#

DROP TABLE IF EXISTS `countries`;
CREATE TABLE `countries` (
  `countries_id` int(11) NOT NULL auto_increment,
  `countries_name` varchar(64) NOT NULL default '',
  `countries_iso_code_2` char(2) NOT NULL default '',
  `countries_iso_code_3` char(3) NOT NULL default '',
  `address_format_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`countries_id`),
  KEY `IDX_COUNTRIES_NAME` (`countries_name`)
) TYPE=MyISAM;

#
# Dumping data for table `countries`
#

INSERT INTO `countries` VALUES (1, 'Afghanistan', 'AF', 'AFG', 1),
(2, 'Albania', 'AL', 'ALB', 1),
(3, 'Algeria', 'DZ', 'DZA', 1),
(4, 'American Samoa', 'AS', 'ASM', 1),
(5, 'Andorra', 'AD', 'AND', 1),
(6, 'Angola', 'AO', 'AGO', 1),
(7, 'Anguilla', 'AI', 'AIA', 1),
(8, 'Antarctica', 'AQ', 'ATA', 1),
(9, 'Antigua and Barbuda', 'AG', 'ATG', 1),
(10, 'Argentina', 'AR', 'ARG', 1),
(11, 'Armenia', 'AM', 'ARM', 1),
(12, 'Aruba', 'AW', 'ABW', 1),
(13, 'Australia', 'AU', 'AUS', 1),
(14, 'Austria', 'AT', 'AUT', 5),
(15, 'Azerbaijan', 'AZ', 'AZE', 1),
(16, 'Bahamas', 'BS', 'BHS', 1),
(17, 'Bahrain', 'BH', 'BHR', 1),
(18, 'Bangladesh', 'BD', 'BGD', 1),
(19, 'Barbados', 'BB', 'BRB', 1),
(20, 'Belarus', 'BY', 'BLR', 1),
(21, 'Belgium', 'BE', 'BEL', 1),
(22, 'Belize', 'BZ', 'BLZ', 1),
(23, 'Benin', 'BJ', 'BEN', 1),
(24, 'Bermuda', 'BM', 'BMU', 1),
(25, 'Bhutan', 'BT', 'BTN', 1),
(26, 'Bolivia', 'BO', 'BOL', 1),
(27, 'Bosnia and Herzegowina', 'BA', 'BIH', 1),
(28, 'Botswana', 'BW', 'BWA', 1),
(29, 'Bouvet Island', 'BV', 'BVT', 1),
(30, 'Brazil', 'BR', 'BRA', 1),
(31, 'British Indian Ocean Territory', 'IO', 'IOT', 1),
(32, 'Brunei Darussalam', 'BN', 'BRN', 1),
(33, 'Bulgaria', 'BG', 'BGR', 1),
(34, 'Burkina Faso', 'BF', 'BFA', 1),
(35, 'Burundi', 'BI', 'BDI', 1),
(36, 'Cambodia', 'KH', 'KHM', 1),
(37, 'Cameroon', 'CM', 'CMR', 1),
(38, 'Canada', 'CA', 'CAN', 1),
(39, 'Cape Verde', 'CV', 'CPV', 1),
(40, 'Cayman Islands', 'KY', 'CYM', 1),
(41, 'Central African Republic', 'CF', 'CAF', 1),
(42, 'Chad', 'TD', 'TCD', 1),
(43, 'Chile', 'CL', 'CHL', 1),
(44, 'China', 'CN', 'CHN', 1),
(45, 'Christmas Island', 'CX', 'CXR', 1),
(46, 'Cocos (Keeling) Islands', 'CC', 'CCK', 1),
(47, 'Colombia', 'CO', 'COL', 1),
(48, 'Comoros', 'KM', 'COM', 1),
(49, 'Congo', 'CG', 'COG', 1),
(50, 'Cook Islands', 'CK', 'COK', 1),
(51, 'Costa Rica', 'CR', 'CRI', 1),
(52, 'Cote D\'Ivoire', 'CI', 'CIV', 1),
(53, 'Croatia', 'HR', 'HRV', 1),
(54, 'Cuba', 'CU', 'CUB', 1),
(55, 'Cyprus', 'CY', 'CYP', 1),
(56, 'Czech Republic', 'CZ', 'CZE', 1),
(57, 'Denmark', 'DK', 'DNK', 1),
(58, 'Djibouti', 'DJ', 'DJI', 1),
(59, 'Dominica', 'DM', 'DMA', 1),
(60, 'Dominican Republic', 'DO', 'DOM', 1),
(61, 'East Timor', 'TP', 'TMP', 1),
(62, 'Ecuador', 'EC', 'ECU', 1),
(63, 'Egypt', 'EG', 'EGY', 1),
(64, 'El Salvador', 'SV', 'SLV', 1),
(65, 'Equatorial Guinea', 'GQ', 'GNQ', 1),
(66, 'Eritrea', 'ER', 'ERI', 1),
(67, 'Estonia', 'EE', 'EST', 1),
(68, 'Ethiopia', 'ET', 'ETH', 1),
(69, 'Falkland Islands (Malvinas)', 'FK', 'FLK', 1),
(70, 'Faroe Islands', 'FO', 'FRO', 1),
(71, 'Fiji', 'FJ', 'FJI', 1),
(72, 'Finland', 'FI', 'FIN', 1),
(73, 'France', 'FR', 'FRA', 1),
(74, 'France, Metropolitan', 'FX', 'FXX', 1),
(75, 'French Guiana', 'GF', 'GUF', 1),
(76, 'French Polynesia', 'PF', 'PYF', 1),
(77, 'French Southern Territories', 'TF', 'ATF', 1),
(78, 'Gabon', 'GA', 'GAB', 1),
(79, 'Gambia', 'GM', 'GMB', 1),
(80, 'Georgia', 'GE', 'GEO', 1),
(81, 'Germany', 'DE', 'DEU', 5),
(82, 'Ghana', 'GH', 'GHA', 1),
(83, 'Gibraltar', 'GI', 'GIB', 1),
(84, 'Greece', 'GR', 'GRC', 1),
(85, 'Greenland', 'GL', 'GRL', 1),
(86, 'Grenada', 'GD', 'GRD', 1),
(87, 'Guadeloupe', 'GP', 'GLP', 1),
(88, 'Guam', 'GU', 'GUM', 1),
(89, 'Guatemala', 'GT', 'GTM', 1),
(90, 'Guinea', 'GN', 'GIN', 1),
(91, 'Guinea-bissau', 'GW', 'GNB', 1),
(92, 'Guyana', 'GY', 'GUY', 1),
(93, 'Haiti', 'HT', 'HTI', 1),
(94, 'Heard and Mc Donald Islands', 'HM', 'HMD', 1),
(95, 'Honduras', 'HN', 'HND', 1),
(96, 'Hong Kong', 'HK', 'HKG', 1),
(97, 'Hungary', 'HU', 'HUN', 1),
(98, 'Iceland', 'IS', 'ISL', 1),
(99, 'India', 'IN', 'IND', 1),
(100, 'Indonesia', 'ID', 'IDN', 1),
(101, 'Iran (Islamic Republic of)', 'IR', 'IRN', 1),
(102, 'Iraq', 'IQ', 'IRQ', 1),
(103, 'Ireland', 'IE', 'IRL', 1),
(104, 'Israel', 'IL', 'ISR', 1),
(105, 'Italy', 'IT', 'ITA', 1),
(106, 'Jamaica', 'JM', 'JAM', 1),
(107, 'Japan', 'JP', 'JPN', 1),
(108, 'Jordan', 'JO', 'JOR', 1),
(109, 'Kazakhstan', 'KZ', 'KAZ', 1),
(110, 'Kenya', 'KE', 'KEN', 1),
(111, 'Kiribati', 'KI', 'KIR', 1),
(112, 'Korea, Democratic People\'s Republic of', 'KP', 'PRK', 1),
(113, 'Korea, Republic of', 'KR', 'KOR', 1),
(114, 'Kuwait', 'KW', 'KWT', 1),
(115, 'Kyrgyzstan', 'KG', 'KGZ', 1),
(116, 'Lao People\'s Democratic Republic', 'LA', 'LAO', 1),
(117, 'Latvia', 'LV', 'LVA', 1),
(118, 'Lebanon', 'LB', 'LBN', 1),
(119, 'Lesotho', 'LS', 'LSO', 1),
(120, 'Liberia', 'LR', 'LBR', 1),
(121, 'Libyan Arab Jamahiriya', 'LY', 'LBY', 1),
(122, 'Liechtenstein', 'LI', 'LIE', 1),
(123, 'Lithuania', 'LT', 'LTU', 1),
(124, 'Luxembourg', 'LU', 'LUX', 1),
(125, 'Macau', 'MO', 'MAC', 1),
(126, 'Macedonia, The Former Yugoslav Republic of', 'MK', 'MKD', 1),
(127, 'Madagascar', 'MG', 'MDG', 1),
(128, 'Malawi', 'MW', 'MWI', 1),
(129, 'Malaysia', 'MY', 'MYS', 1),
(130, 'Maldives', 'MV', 'MDV', 1),
(131, 'Mali', 'ML', 'MLI', 1),
(132, 'Malta', 'MT', 'MLT', 1),
(133, 'Marshall Islands', 'MH', 'MHL', 1),
(134, 'Martinique', 'MQ', 'MTQ', 1),
(135, 'Mauritania', 'MR', 'MRT', 1),
(136, 'Mauritius', 'MU', 'MUS', 1),
(137, 'Mayotte', 'YT', 'MYT', 1),
(138, 'Mexico', 'MX', 'MEX', 1),
(139, 'Micronesia, Federated States of', 'FM', 'FSM', 1),
(140, 'Moldova, Republic of', 'MD', 'MDA', 1),
(141, 'Monaco', 'MC', 'MCO', 1),
(142, 'Mongolia', 'MN', 'MNG', 1),
(143, 'Montserrat', 'MS', 'MSR', 1),
(144, 'Morocco', 'MA', 'MAR', 1),
(145, 'Mozambique', 'MZ', 'MOZ', 1),
(146, 'Myanmar', 'MM', 'MMR', 1),
(147, 'Namibia', 'NA', 'NAM', 1),
(148, 'Nauru', 'NR', 'NRU', 1),
(149, 'Nepal', 'NP', 'NPL', 1),
(150, 'Netherlands', 'NL', 'NLD', 1),
(151, 'Netherlands Antilles', 'AN', 'ANT', 1),
(152, 'New Caledonia', 'NC', 'NCL', 1),
(153, 'New Zealand', 'NZ', 'NZL', 1),
(154, 'Nicaragua', 'NI', 'NIC', 1),
(155, 'Niger', 'NE', 'NER', 1),
(156, 'Nigeria', 'NG', 'NGA', 1),
(157, 'Niue', 'NU', 'NIU', 1),
(158, 'Norfolk Island', 'NF', 'NFK', 1),
(159, 'Northern Mariana Islands', 'MP', 'MNP', 1),
(160, 'Norway', 'NO', 'NOR', 1),
(161, 'Oman', 'OM', 'OMN', 1),
(162, 'Pakistan', 'PK', 'PAK', 1),
(163, 'Palau', 'PW', 'PLW', 1),
(164, 'Panama', 'PA', 'PAN', 1),
(165, 'Papua New Guinea', 'PG', 'PNG', 1),
(166, 'Paraguay', 'PY', 'PRY', 1),
(167, 'Peru', 'PE', 'PER', 1),
(168, 'Philippines', 'PH', 'PHL', 1),
(169, 'Pitcairn', 'PN', 'PCN', 1),
(170, 'Poland', 'PL', 'POL', 1),
(171, 'Portugal', 'PT', 'PRT', 1),
(172, 'Puerto Rico', 'PR', 'PRI', 1),
(173, 'Qatar', 'QA', 'QAT', 1),
(174, 'Reunion', 'RE', 'REU', 1),
(175, 'Romania', 'RO', 'ROM', 1),
(176, 'Russian Federation', 'RU', 'RUS', 1),
(177, 'Rwanda', 'RW', 'RWA', 1),
(178, 'Saint Kitts and Nevis', 'KN', 'KNA', 1),
(179, 'Saint Lucia', 'LC', 'LCA', 1),
(180, 'Saint Vincent and the Grenadines', 'VC', 'VCT', 1),
(181, 'Samoa', 'WS', 'WSM', 1),
(182, 'San Marino', 'SM', 'SMR', 1),
(183, 'Sao Tome and Principe', 'ST', 'STP', 1),
(184, 'Saudi Arabia', 'SA', 'SAU', 1),
(185, 'Senegal', 'SN', 'SEN', 1),
(186, 'Seychelles', 'SC', 'SYC', 1),
(187, 'Sierra Leone', 'SL', 'SLE', 1),
(188, 'Singapore', 'SG', 'SGP', 4),
(189, 'Slovakia (Slovak Republic)', 'SK', 'SVK', 1),
(190, 'Slovenia', 'SI', 'SVN', 1),
(191, 'Solomon Islands', 'SB', 'SLB', 1),
(192, 'Somalia', 'SO', 'SOM', 1),
(193, 'South Africa', 'ZA', 'ZAF', 1),
(194, 'South Georgia and the South Sandwich Islands', 'GS', 'SGS', 1),
(195, 'Spain', 'ES', 'ESP', 3),
(196, 'Sri Lanka', 'LK', 'LKA', 1),
(197, 'St. Helena', 'SH', 'SHN', 1),
(198, 'St. Pierre and Miquelon', 'PM', 'SPM', 1),
(199, 'Sudan', 'SD', 'SDN', 1),
(200, 'Suriname', 'SR', 'SUR', 1),
(201, 'Svalbard and Jan Mayen Islands', 'SJ', 'SJM', 1),
(202, 'Swaziland', 'SZ', 'SWZ', 1),
(203, 'Sweden', 'SE', 'SWE', 1),
(204, 'Switzerland', 'CH', 'CHE', 1),
(205, 'Syrian Arab Republic', 'SY', 'SYR', 1),
(206, 'Taiwan', 'TW', 'TWN', 1),
(207, 'Tajikistan', 'TJ', 'TJK', 1),
(208, 'Tanzania, United Republic of', 'TZ', 'TZA', 1),
(209, 'Thailand', 'TH', 'THA', 1),
(210, 'Togo', 'TG', 'TGO', 1),
(211, 'Tokelau', 'TK', 'TKL', 1),
(212, 'Tonga', 'TO', 'TON', 1),
(213, 'Trinidad and Tobago', 'TT', 'TTO', 1),
(214, 'Tunisia', 'TN', 'TUN', 1),
(215, 'Turkey', 'TR', 'TUR', 1),
(216, 'Turkmenistan', 'TM', 'TKM', 1),
(217, 'Turks and Caicos Islands', 'TC', 'TCA', 1),
(218, 'Tuvalu', 'TV', 'TUV', 1),
(219, 'Uganda', 'UG', 'UGA', 1),
(220, 'Ukraine', 'UA', 'UKR', 1),
(221, 'United Arab Emirates', 'AE', 'ARE', 1),
(222, 'United Kingdom', 'GB', 'GBR', 1),
(223, 'United States', 'US', 'USA', 2),
(224, 'United States Minor Outlying Islands', 'UM', 'UMI', 1),
(225, 'Uruguay', 'UY', 'URY', 1),
(226, 'Uzbekistan', 'UZ', 'UZB', 1),
(227, 'Vanuatu', 'VU', 'VUT', 1),
(228, 'Vatican City State (Holy See)', 'VA', 'VAT', 1),
(229, 'Venezuela', 'VE', 'VEN', 1),
(230, 'Viet Nam', 'VN', 'VNM', 1),
(231, 'Virgin Islands (British)', 'VG', 'VGB', 1),
(232, 'Virgin Islands (U.S.)', 'VI', 'VIR', 1),
(233, 'Wallis and Futuna Islands', 'WF', 'WLF', 1),
(234, 'Western Sahara', 'EH', 'ESH', 1),
(235, 'Yemen', 'YE', 'YEM', 1),
(236, 'Yugoslavia', 'YU', 'YUG', 1),
(237, 'Zaire', 'ZR', 'ZAR', 1),
(238, 'Zambia', 'ZM', 'ZMB', 1),
(239, 'Zimbabwe', 'ZW', 'ZWE', 1);
# --------------------------------------------------------

#
# Table structure for table `currencies`
#

DROP TABLE IF EXISTS `currencies`;
CREATE TABLE `currencies` (
  `currencies_id` int(11) NOT NULL auto_increment,
  `title` varchar(32) NOT NULL default '',
  `code` char(3) NOT NULL default '',
  `symbol_left` varchar(12) default NULL,
  `symbol_right` varchar(12) default NULL,
  `decimal_point` char(1) default NULL,
  `thousands_point` char(1) default NULL,
  `decimal_places` char(1) default NULL,
  `value` float(13,8) default NULL,
  `last_updated` datetime default NULL,
  PRIMARY KEY  (`currencies_id`)
) TYPE=MyISAM;

#
# Dumping data for table `currencies`
#

INSERT INTO `currencies` VALUES (1, 'US Dollar', 'USD', '$', '', '.', ',', '2', '1.00000000', '2005-07-07 10:38:23'),
(2, 'Euro', 'EUR', '', 'EUR', '.', ',', '2', '1.10360003', '2005-07-07 10:38:23');
# --------------------------------------------------------

#
# Table structure for table `customers`
#

DROP TABLE IF EXISTS `customers`;
CREATE TABLE `customers` (
  `customers_id` int(11) NOT NULL auto_increment,
  `customers_gender` char(1) NOT NULL default '',
  `customers_firstname` varchar(32) NOT NULL default '',
  `customers_lastname` varchar(32) NOT NULL default '',
  `customers_dob` datetime NOT NULL default '0000-00-00 00:00:00',
  `customers_email_address` varchar(96) NOT NULL default '',
  `customers_default_address_id` int(11) NOT NULL default '0',
  `customers_telephone` varchar(32) NOT NULL default '',
  `customers_fax` varchar(32) default NULL,
  `customers_password` varchar(40) NOT NULL default '',
  `customers_newsletter` char(1) default NULL,
  PRIMARY KEY  (`customers_id`)
) TYPE=MyISAM;

#
# Dumping data for table `customers`
#

INSERT INTO `customers` VALUES (1, 'm', 'John', 'doe', '2001-01-01 00:00:00', 'root@localhost', 1, '12345', '', 'd95e8fa7f20a009372eb3477473fcd34:1c', '0'),
(2, 'm', 'sdfsdfsdsf', 'sdfsdfsdfd', '1970-05-21 00:00:00', 'test@hotmail.com', 2, '32423324', '', '7c71b8b8202a770d0f4731f831900280:8e', '');
# --------------------------------------------------------

#
# Table structure for table `customers_basket`
#

DROP TABLE IF EXISTS `customers_basket`;
CREATE TABLE `customers_basket` (
  `customers_basket_id` int(11) NOT NULL auto_increment,
  `customers_id` int(11) NOT NULL default '0',
  `products_id` tinytext NOT NULL,
  `customers_basket_quantity` int(2) NOT NULL default '0',
  `final_price` decimal(15,4) NOT NULL default '0.0000',
  `customers_basket_date_added` varchar(8) default NULL,
  PRIMARY KEY  (`customers_basket_id`)
) TYPE=MyISAM;

#
# Dumping data for table `customers_basket`
#

# --------------------------------------------------------

#
# Table structure for table `customers_basket_attributes`
#

DROP TABLE IF EXISTS `customers_basket_attributes`;
CREATE TABLE `customers_basket_attributes` (
  `customers_basket_attributes_id` int(11) NOT NULL auto_increment,
  `customers_id` int(11) NOT NULL default '0',
  `products_id` tinytext NOT NULL,
  `products_options_id` int(11) NOT NULL default '0',
  `products_options_value_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`customers_basket_attributes_id`)
) TYPE=MyISAM;

#
# Dumping data for table `customers_basket_attributes`
#

# --------------------------------------------------------

#
# Table structure for table `customers_info`
#

DROP TABLE IF EXISTS `customers_info`;
CREATE TABLE `customers_info` (
  `customers_info_id` int(11) NOT NULL default '0',
  `customers_info_date_of_last_logon` datetime default NULL,
  `customers_info_number_of_logons` int(5) default NULL,
  `customers_info_date_account_created` datetime default NULL,
  `customers_info_date_account_last_modified` datetime default NULL,
  `global_product_notifications` int(1) default '0',
  PRIMARY KEY  (`customers_info_id`)
) TYPE=MyISAM;

#
# Dumping data for table `customers_info`
#

INSERT INTO `customers_info` VALUES (1, '0000-00-00 00:00:00', 0, '2005-07-07 10:38:23', '0000-00-00 00:00:00', 0),
(2, NULL, 0, '2005-07-11 18:22:18', NULL, 0);
# --------------------------------------------------------

#
# Table structure for table `geo_zones`
#

DROP TABLE IF EXISTS `geo_zones`;
CREATE TABLE `geo_zones` (
  `geo_zone_id` int(11) NOT NULL auto_increment,
  `geo_zone_name` varchar(32) NOT NULL default '',
  `geo_zone_description` varchar(255) NOT NULL default '',
  `last_modified` datetime default NULL,
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`geo_zone_id`)
) TYPE=MyISAM;

#
# Dumping data for table `geo_zones`
#

INSERT INTO `geo_zones` VALUES (1, 'Florida', 'Florida local sales tax zone', NULL, '2005-07-07 10:38:23');
# --------------------------------------------------------

#
# Table structure for table `languages`
#

DROP TABLE IF EXISTS `languages`;
CREATE TABLE `languages` (
  `languages_id` int(11) NOT NULL auto_increment,
  `name` varchar(32) NOT NULL default '',
  `code` char(2) NOT NULL default '',
  `image` varchar(64) default NULL,
  `directory` varchar(32) default NULL,
  `sort_order` int(3) default NULL,
  PRIMARY KEY  (`languages_id`),
  KEY `IDX_LANGUAGES_NAME` (`name`)
) TYPE=MyISAM;

#
# Dumping data for table `languages`
#

INSERT INTO `languages` VALUES (1, 'English', 'en', 'icon.gif', 'english', 1),
(2, 'Deutsch', 'de', 'icon.gif', 'german', 2),
(3, 'Espaņol', 'es', 'icon.gif', 'espanol', 3);
# --------------------------------------------------------

#
# Table structure for table `manufacturers`
#

DROP TABLE IF EXISTS `manufacturers`;
CREATE TABLE `manufacturers` (
  `manufacturers_id` int(11) NOT NULL auto_increment,
  `manufacturers_name` varchar(32) NOT NULL default '',
  `manufacturers_image` varchar(64) default NULL,
  `date_added` datetime default NULL,
  `last_modified` datetime default NULL,
  PRIMARY KEY  (`manufacturers_id`),
  KEY `IDX_MANUFACTURERS_NAME` (`manufacturers_name`)
) TYPE=MyISAM;

#
# Dumping data for table `manufacturers`
#

INSERT INTO `manufacturers` VALUES (10, 'Mecca', 'm20.gif', '2005-07-07 17:36:50', '2005-07-21 16:25:35'),
(11, 'Sky', 'm21.gif', '2005-07-07 17:37:49', '2005-08-10 14:25:18'),
(12, 'Crucial', 'm22.gif', '2005-07-07 17:37:59', '2005-08-10 14:24:08'),
(13, 'Ebookers', 'm23.gif', '2005-07-07 17:38:36', '2005-08-10 14:25:49'),
(14, 'React', NULL, '2005-08-10 14:27:10', '2005-08-10 14:27:30'),
(15, 'Raddish', NULL, '2005-08-10 14:27:51', NULL);
# --------------------------------------------------------

#
# Table structure for table `manufacturers_info`
#

DROP TABLE IF EXISTS `manufacturers_info`;
CREATE TABLE `manufacturers_info` (
  `manufacturers_id` int(11) NOT NULL default '0',
  `languages_id` int(11) NOT NULL default '0',
  `manufacturers_url` varchar(255) NOT NULL default '',
  `url_clicked` int(5) NOT NULL default '0',
  `date_last_click` datetime default NULL,
  PRIMARY KEY  (`manufacturers_id`,`languages_id`)
) TYPE=MyISAM;

#
# Dumping data for table `manufacturers_info`
#

INSERT INTO `manufacturers_info` VALUES (10, 1, '', 0, NULL),
(10, 2, '', 0, NULL),
(10, 3, '', 0, NULL),
(11, 1, '', 0, NULL),
(11, 2, '', 0, NULL),
(11, 3, '', 0, NULL),
(12, 1, '', 0, NULL),
(12, 2, '', 0, NULL),
(12, 3, '', 0, NULL),
(13, 1, '', 0, NULL),
(13, 2, '', 0, NULL),
(13, 3, '', 0, NULL),
(14, 1, '', 0, NULL),
(14, 2, '', 0, NULL),
(14, 3, '', 0, NULL),
(15, 1, '', 0, NULL),
(15, 2, '', 0, NULL),
(15, 3, '', 0, NULL);
# --------------------------------------------------------

#
# Table structure for table `newsletters`
#

DROP TABLE IF EXISTS `newsletters`;
CREATE TABLE `newsletters` (
  `newsletters_id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `content` text NOT NULL,
  `module` varchar(255) NOT NULL default '',
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `date_sent` datetime default NULL,
  `status` int(1) default NULL,
  `locked` int(1) default '0',
  PRIMARY KEY  (`newsletters_id`)
) TYPE=MyISAM;

#
# Dumping data for table `newsletters`
#

# --------------------------------------------------------

#
# Table structure for table `orders`
#

DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
  `orders_id` int(11) NOT NULL auto_increment,
  `customers_id` int(11) NOT NULL default '0',
  `customers_name` varchar(64) NOT NULL default '',
  `customers_company` varchar(32) default NULL,
  `customers_street_address` varchar(64) NOT NULL default '',
  `customers_suburb` varchar(32) default NULL,
  `customers_city` varchar(32) NOT NULL default '',
  `customers_postcode` varchar(10) NOT NULL default '',
  `customers_state` varchar(32) default NULL,
  `customers_country` varchar(32) NOT NULL default '',
  `customers_telephone` varchar(32) NOT NULL default '',
  `customers_email_address` varchar(96) NOT NULL default '',
  `customers_address_format_id` int(5) NOT NULL default '0',
  `delivery_name` varchar(64) NOT NULL default '',
  `delivery_company` varchar(32) default NULL,
  `delivery_street_address` varchar(64) NOT NULL default '',
  `delivery_suburb` varchar(32) default NULL,
  `delivery_city` varchar(32) NOT NULL default '',
  `delivery_postcode` varchar(10) NOT NULL default '',
  `delivery_state` varchar(32) default NULL,
  `delivery_country` varchar(32) NOT NULL default '',
  `delivery_address_format_id` int(5) NOT NULL default '0',
  `billing_name` varchar(64) NOT NULL default '',
  `billing_company` varchar(32) default NULL,
  `billing_street_address` varchar(64) NOT NULL default '',
  `billing_suburb` varchar(32) default NULL,
  `billing_city` varchar(32) NOT NULL default '',
  `billing_postcode` varchar(10) NOT NULL default '',
  `billing_state` varchar(32) default NULL,
  `billing_country` varchar(32) NOT NULL default '',
  `billing_address_format_id` int(5) NOT NULL default '0',
  `payment_method` varchar(32) NOT NULL default '',
  `cc_type` varchar(20) default NULL,
  `cc_owner` varchar(64) default NULL,
  `cc_number` varchar(32) default NULL,
  `cc_expires` varchar(4) default NULL,
  `last_modified` datetime default NULL,
  `date_purchased` datetime default NULL,
  `orders_status` int(5) NOT NULL default '0',
  `orders_date_finished` datetime default NULL,
  `currency` char(3) default NULL,
  `currency_value` decimal(14,6) default NULL,
  PRIMARY KEY  (`orders_id`)
) TYPE=MyISAM;

#
# Dumping data for table `orders`
#

INSERT INTO `orders` VALUES (1, 2, 'sdfsdfsdsf sdfsdfsdfd', '', 'sdfdf', 'sdfd', 'sdfsdfsdf', '22222', 'dfdfdfssdf', 'Algeria', '32423324', 'test@hotmail.com', 1, 'sdfsdfsdsf sdfsdfsdfd', '', 'sdfdf', 'sdfd', 'sdfsdfsdf', '22222', 'dfdfdfssdf', 'Algeria', 1, 'sdfsdfsdsf sdfsdfsdfd', '', 'sdfdf', 'sdfd', 'sdfsdfsdf', '22222', 'dfdfdfssdf', 'Algeria', 1, 'Cash on Delivery', '', '', '', '', NULL, '2005-07-11 18:22:36', 1, NULL, 'USD', '1.000000'),
(2, 2, 'sdfsdfsdsf sdfsdfsdfd', '', 'sdfdf', 'sdfd', 'sdfsdfsdf', '22222', 'dfdfdfssdf', 'Algeria', '32423324', 'test@hotmail.com', 1, 'sdfsdfsdsf sdfsdfsdfd', '', 'sdfdf', 'sdfd', 'sdfsdfsdf', '22222', 'dfdfdfssdf', 'Algeria', 1, 'sdfsdfsdsf sdfsdfsdfd', '', 'sdfdf', 'sdfd', 'sdfsdfsdf', '22222', 'dfdfdfssdf', 'Algeria', 1, 'Cash on Delivery', '', '', '', '', NULL, '2005-07-11 18:24:32', 1, NULL, 'USD', '1.000000');
# --------------------------------------------------------

#
# Table structure for table `orders_products`
#

DROP TABLE IF EXISTS `orders_products`;
CREATE TABLE `orders_products` (
  `orders_products_id` int(11) NOT NULL auto_increment,
  `orders_id` int(11) NOT NULL default '0',
  `products_id` int(11) NOT NULL default '0',
  `products_model` varchar(12) default NULL,
  `products_name` varchar(64) NOT NULL default '',
  `products_price` decimal(15,4) NOT NULL default '0.0000',
  `final_price` decimal(15,4) NOT NULL default '0.0000',
  `products_tax` decimal(7,4) NOT NULL default '0.0000',
  `products_quantity` int(2) NOT NULL default '0',
  PRIMARY KEY  (`orders_products_id`)
) TYPE=MyISAM;

#
# Dumping data for table `orders_products`
#

INSERT INTO `orders_products` VALUES (1, 1, 38, '', 'AMD Power FV', '299.0000', '299.0000', '0.0000', 1),
(2, 2, 96, '', 'Canon CoolScan V ED', '510.0000', '510.0000', '0.0000', 1),
(3, 2, 54, '', 'Dell Inspiron 6000', '1166.0000', '1166.0000', '0.0000', 1),
(4, 2, 95, '', 'Logitech QuickCam Messenger', '19.0000', '19.0000', '0.0000', 1),
(5, 2, 87, '', 'Canon CanoScan 9950F', '325.0000', '325.0000', '0.0000', 1);
# --------------------------------------------------------

#
# Table structure for table `orders_products_attributes`
#

DROP TABLE IF EXISTS `orders_products_attributes`;
CREATE TABLE `orders_products_attributes` (
  `orders_products_attributes_id` int(11) NOT NULL auto_increment,
  `orders_id` int(11) NOT NULL default '0',
  `orders_products_id` int(11) NOT NULL default '0',
  `products_options` varchar(32) NOT NULL default '',
  `products_options_values` varchar(32) NOT NULL default '',
  `options_values_price` decimal(15,4) NOT NULL default '0.0000',
  `price_prefix` char(1) NOT NULL default '',
  PRIMARY KEY  (`orders_products_attributes_id`)
) TYPE=MyISAM;

#
# Dumping data for table `orders_products_attributes`
#

# --------------------------------------------------------

#
# Table structure for table `orders_products_download`
#

DROP TABLE IF EXISTS `orders_products_download`;
CREATE TABLE `orders_products_download` (
  `orders_products_download_id` int(11) NOT NULL auto_increment,
  `orders_id` int(11) NOT NULL default '0',
  `orders_products_id` int(11) NOT NULL default '0',
  `orders_products_filename` varchar(255) NOT NULL default '',
  `download_maxdays` int(2) NOT NULL default '0',
  `download_count` int(2) NOT NULL default '0',
  PRIMARY KEY  (`orders_products_download_id`)
) TYPE=MyISAM;

#
# Dumping data for table `orders_products_download`
#

# --------------------------------------------------------

#
# Table structure for table `orders_status`
#

DROP TABLE IF EXISTS `orders_status`;
CREATE TABLE `orders_status` (
  `orders_status_id` int(11) NOT NULL default '0',
  `language_id` int(11) NOT NULL default '1',
  `orders_status_name` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`orders_status_id`,`language_id`),
  KEY `idx_orders_status_name` (`orders_status_name`)
) TYPE=MyISAM;

#
# Dumping data for table `orders_status`
#

INSERT INTO `orders_status` VALUES (1, 1, 'Pending'),
(1, 2, 'Offen'),
(1, 3, 'Pendiente'),
(2, 1, 'Processing'),
(2, 2, 'In Bearbeitung'),
(2, 3, 'Proceso'),
(3, 1, 'Delivered'),
(3, 2, 'Versendet'),
(3, 3, 'Entregado');
# --------------------------------------------------------

#
# Table structure for table `orders_status_history`
#

DROP TABLE IF EXISTS `orders_status_history`;
CREATE TABLE `orders_status_history` (
  `orders_status_history_id` int(11) NOT NULL auto_increment,
  `orders_id` int(11) NOT NULL default '0',
  `orders_status_id` int(5) NOT NULL default '0',
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `customer_notified` int(1) default '0',
  `comments` text,
  PRIMARY KEY  (`orders_status_history_id`)
) TYPE=MyISAM;

#
# Dumping data for table `orders_status_history`
#

INSERT INTO `orders_status_history` VALUES (1, 1, 1, '2005-07-11 18:22:36', 1, ''),
(2, 2, 1, '2005-07-11 18:24:32', 1, '');
# --------------------------------------------------------

#
# Table structure for table `orders_total`
#

DROP TABLE IF EXISTS `orders_total`;
CREATE TABLE `orders_total` (
  `orders_total_id` int(10) unsigned NOT NULL auto_increment,
  `orders_id` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `text` varchar(255) NOT NULL default '',
  `value` decimal(15,4) NOT NULL default '0.0000',
  `class` varchar(32) NOT NULL default '',
  `sort_order` int(11) NOT NULL default '0',
  PRIMARY KEY  (`orders_total_id`),
  KEY `idx_orders_total_orders_id` (`orders_id`)
) TYPE=MyISAM;

#
# Dumping data for table `orders_total`
#

INSERT INTO `orders_total` VALUES (1, 1, 'Sub-Total:', '$299.00', '299.0000', 'ot_subtotal', 1),
(2, 1, 'Flat Rate (Best Way):', '$5.00', '5.0000', 'ot_shipping', 2),
(3, 1, 'Total:', '<b>$304.00</b>', '304.0000', 'ot_total', 4),
(4, 2, 'Sub-Total:', '$2,020.00', '2020.0000', 'ot_subtotal', 1),
(5, 2, 'Flat Rate (Best Way):', '$5.00', '5.0000', 'ot_shipping', 2),
(6, 2, 'Total:', '<b>$2,025.00</b>', '2025.0000', 'ot_total', 4);
# --------------------------------------------------------

#
# Table structure for table `products`
#

DROP TABLE IF EXISTS `products`;
CREATE TABLE `products` (
  `products_id` int(11) NOT NULL auto_increment,
  `products_quantity` int(4) NOT NULL default '0',
  `products_model` varchar(12) default NULL,
  `products_image` varchar(64) default NULL,
  `products_price` decimal(15,4) NOT NULL default '0.0000',
  `products_date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `products_last_modified` datetime default NULL,
  `products_date_available` datetime default NULL,
  `products_weight` decimal(5,2) NOT NULL default '0.00',
  `products_status` tinyint(1) NOT NULL default '0',
  `products_tax_class_id` int(11) NOT NULL default '0',
  `manufacturers_id` int(11) default NULL,
  `products_ordered` int(11) NOT NULL default '0',
  PRIMARY KEY  (`products_id`),
  KEY `idx_products_date_added` (`products_date_added`)
) TYPE=MyISAM;

#
# Dumping data for table `products`
#

INSERT INTO `products` VALUES (138, 1000, '', 'hhh.jpg', '35.9500', '2005-07-20 14:54:39', NULL, NULL, '0.00', 1, 0, 12, 0),
(139, 1000, '', 'jjj.jpg', '46.9900', '2005-07-20 14:56:21', NULL, NULL, '0.00', 1, 0, 13, 0),
(140, 1000, '', 'kkk.jpg', '60.9500', '2005-07-20 14:57:37', NULL, NULL, '0.00', 1, 0, 13, 0),
(141, 1000, '', 'lll.jpg', '54.0000', '2005-07-20 15:00:16', NULL, NULL, '0.00', 1, 0, 11, 0),
(142, 1000, '', 'dsd.jpg', '20.0000', '2005-07-20 15:02:11', NULL, NULL, '0.00', 1, 0, 13, 0),
(143, 1000, '', 'dfd.jpg', '22.0000', '2005-07-20 15:06:56', NULL, NULL, '0.00', 1, 0, 13, 0),
(144, 1000, '', 'fdf.jpg', '25.0000', '2005-07-20 15:12:56', NULL, NULL, '0.00', 1, 0, 13, 0),
(145, 1000, '', 'gfg.jpg', '26.9000', '2005-07-20 15:15:15', NULL, NULL, '0.00', 1, 0, 12, 0),
(146, 1000, '', 'fgf.jpg', '24.9900', '2005-07-20 15:16:44', NULL, NULL, '0.00', 1, 0, 12, 0),
(147, 1000, '', 'ghg.jpg', '25.0000', '2005-07-20 15:18:11', NULL, NULL, '0.00', 1, 0, 0, 0),
(148, 1000, '', 'hgh.jpg', '27.9000', '2005-07-20 15:19:45', NULL, NULL, '0.00', 1, 0, 12, 0),
(149, 1000, '', 'jhj.jpg', '45.0000', '2005-07-20 15:26:15', '2005-08-10 16:05:20', NULL, '0.00', 1, 0, 14, 0),
(150, 1000, '', 'hjh.jpg', '50.0000', '2005-07-20 15:28:02', '2005-08-10 16:06:46', NULL, '0.00', 1, 0, 15, 0),
(151, 1000, '', 'kjk.jpg', '45.0000', '2005-07-20 15:30:29', '2005-08-10 16:05:47', NULL, '0.00', 1, 0, 14, 0),
(152, 1000, '', 'jkj.jpg', '50.0000', '2005-07-20 15:32:16', NULL, NULL, '0.00', 1, 0, 11, 0),
(153, 1000, '', 'klk.jpg', '70.0000', '2005-07-20 15:35:21', NULL, NULL, '0.00', 1, 0, 12, 0),
(154, 1000, '', 'lkl.jpg', '130.0000', '2005-07-20 15:36:54', NULL, NULL, '0.00', 1, 0, 13, 0),
(155, 1000, '', 'zzz.jpg', '16.0000', '2005-07-20 15:41:25', NULL, NULL, '0.00', 1, 0, 11, 0),
(156, 1000, '', 'xxx.jpg', '15.0000', '2005-07-20 15:42:37', NULL, NULL, '0.00', 1, 0, 12, 0),
(157, 1000, '', 'ccc.jpg', '13.0000', '2005-07-20 15:43:56', NULL, NULL, '0.00', 1, 0, 11, 0),
(158, 1000, '', 'vvv.jpg', '20.0000', '2005-07-20 15:54:58', NULL, NULL, '0.00', 1, 0, 13, 0),
(159, 1000, '', 'bbb.jpg', '22.0000', '2005-07-20 15:56:29', NULL, NULL, '0.00', 1, 0, 13, 0),
(160, 1000, '', 'nnn.jpg', '14.0000', '2005-07-20 15:58:12', NULL, NULL, '0.00', 1, 0, 10, 0),
(161, 1000, '', 'mmm.jpg', '10.0000', '2005-07-20 16:03:08', NULL, NULL, '0.00', 1, 0, 13, 0),
(162, 1000, '', 'zmz.jpg', '14.0000', '2005-07-20 16:06:38', NULL, NULL, '0.00', 1, 0, 13, 0),
(163, 1000, '', 'xnx.jpg', '14.0000', '2005-07-20 16:09:18', NULL, NULL, '0.00', 1, 0, 12, 0),
(164, 1000, '', 'cnc.jpg', '12.0000', '2005-07-20 16:13:38', NULL, NULL, '0.00', 1, 0, 11, 0),
(137, 1000, '', 'ggg.jpg', '50.0000', '2005-07-20 14:52:54', NULL, NULL, '0.00', 1, 0, 13, 0),
(136, 1000, '', 'fff.jpg', '29.9500', '2005-07-20 14:47:46', NULL, NULL, '0.00', 1, 0, 0, 0),
(135, 1000, '', 'ddd.jpg', '40.0000', '2005-07-20 14:44:10', NULL, NULL, '0.00', 1, 0, 11, 0),
(134, 1000, '', 'sss.jpg', '98.0000', '2005-07-25 14:42:46', '2005-08-04 13:02:17', NULL, '0.00', 1, 0, 12, 0),
(133, 1000, '', 'sas.jpg', '55.0000', '2005-07-22 14:41:11', NULL, NULL, '0.00', 1, 0, 12, 0),
(132, 1000, '', 'asa.jpg', '50.0000', '2005-07-20 14:39:39', NULL, NULL, '0.00', 1, 0, 13, 0),
(131, 1000, '', 'aaa.jpg', '49.0000', '2005-07-20 14:38:49', NULL, NULL, '0.00', 1, 0, 13, 0),
(130, 1000, '', 'oop.jpg', '9.9900', '2005-07-20 13:28:56', NULL, NULL, '0.00', 1, 0, 10, 0),
(129, 1000, '', 'ppo.jpg', '9.9900', '2005-07-20 13:26:17', NULL, NULL, '0.00', 1, 0, 10, 0),
(128, 1000, '', 'iio.jpg', '9.9900', '2005-07-20 13:24:44', NULL, NULL, '0.00', 1, 0, 10, 0),
(127, 1000, '', 'ooi.jpg', '9.9900', '2005-07-20 13:20:15', NULL, NULL, '0.00', 1, 0, 10, 0),
(126, 1000, '', 'uui.jpg', '9.9900', '2005-07-20 13:18:26', NULL, NULL, '0.00', 1, 0, 10, 0),
(125, 1000, '', 'iiu.jpg', '9.9900', '2005-07-20 13:16:50', NULL, NULL, '0.00', 1, 0, 10, 0),
(124, 1000, '', 'uuy.jpg', '16.9900', '2005-07-20 13:14:00', NULL, NULL, '0.00', 1, 0, 11, 0),
(123, 1000, '', 'yyu.jpg', '16.9900', '2005-07-20 13:12:15', NULL, NULL, '0.00', 1, 0, 11, 0),
(122, 1000, '', 'yyt.jpg', '16.9900', '2005-07-20 13:10:45', NULL, NULL, '0.00', 1, 0, 11, 0),
(121, 1000, '', 'tty.jpg', '16.9900', '2005-07-20 13:07:36', NULL, NULL, '0.00', 1, 0, 11, 0),
(120, 1000, '', 'ttr.jpg', '16.9900', '2005-07-20 13:05:18', '2005-08-10 16:03:33', NULL, '0.00', 1, 0, 15, 0),
(119, 1000, '', 'rrt.jpg', '16.9900', '2005-07-20 13:03:35', NULL, NULL, '0.00', 1, 0, 0, 0),
(118, 1000, '', 'eer.jpg', '12.0000', '2005-07-20 13:00:16', NULL, NULL, '0.00', 1, 0, 12, 0),
(117, 1000, '', 'err.jpg', '6.9900', '2005-07-20 12:58:21', NULL, NULL, '0.00', 1, 0, 12, 0),
(116, 1000, '', 'eww.jpg', '6.9900', '2005-07-20 12:45:21', NULL, NULL, '0.00', 1, 0, 12, 0),
(114, 1000, '', 'eew.jpg', '6.9900', '2005-07-20 12:42:42', NULL, NULL, '0.00', 1, 0, 12, 0),
(113, 1000, '', 'wwq.jpg', '6.9900', '2005-07-20 12:39:13', NULL, NULL, '0.00', 1, 0, 12, 0),
(112, 1000, '', 'wqq.jpg', '6.9900', '2005-07-20 11:09:38', NULL, NULL, '0.00', 1, 0, 12, 0),
(111, 1000, '', 'qww.jpg', '11.9900', '2005-07-26 19:46:47', NULL, NULL, '0.00', 1, 0, 13, 0),
(109, 1000, '', 'qqq.jpg', '30.0000', '2005-07-20 19:38:21', NULL, NULL, '0.00', 1, 0, 13, 0),
(108, 1000, '', 'ppp.jpg', '24.0000', '2005-07-19 19:34:41', NULL, NULL, '0.00', 1, 0, 13, 0),
(107, 1000, '', 'ooo.jpg', '24.0000', '2005-07-27 19:32:40', NULL, NULL, '0.00', 1, 0, 13, 0),
(106, 1000, '', 'iii.jpg', '9.9900', '2005-07-24 19:26:06', NULL, NULL, '0.00', 1, 0, 13, 0),
(105, 1000, '', 'uuu.jpg', '7.0000', '2005-07-28 19:21:18', NULL, NULL, '0.00', 1, 0, 13, 0),
(104, 1000, '', 'yyy.jpg', '16.9900', '2005-07-19 19:02:08', NULL, NULL, '0.00', 1, 0, 10, 0),
(103, 1000, '', 'ttt.jpg', '19.5000', '2005-07-19 18:58:27', NULL, NULL, '0.00', 1, 0, 10, 0),
(99, 1000, '', 'qqw.jpg', '17.5000', '2005-07-19 17:30:13', '2005-07-19 19:42:41', NULL, '0.00', 1, 0, 10, 0),
(100, 1000, '', 'www.jpg', '8.9900', '2005-07-19 18:38:59', '2005-07-19 18:41:21', NULL, '0.00', 1, 0, 10, 0),
(101, 1000, '', 'eee.jpg', '17.5000', '2005-07-19 18:49:07', NULL, NULL, '0.00', 1, 0, 10, 0),
(102, 1000, '', 'rrr.jpg', '5.0000', '2005-07-19 18:51:57', NULL, NULL, '0.00', 1, 0, 10, 0),
(165, 1000, '', 'vnv.jpg', '20.0000', '2005-07-20 16:14:51', NULL, NULL, '0.00', 1, 0, 12, 0),
(166, 1000, '', 'vnb.jpg', '15.0000', '2005-07-20 16:16:21', NULL, NULL, '0.00', 1, 0, 11, 0),
(167, 1000, '', 'hgj.jpg', '7.0000', '2005-07-20 16:22:27', NULL, NULL, '0.00', 1, 0, 13, 0),
(168, 1000, '', 'fgh.jpg', '10.0000', '2005-07-20 16:25:42', NULL, NULL, '0.00', 1, 0, 11, 0),
(169, 1000, '', 'zhf.jpg', '3.0000', '2005-07-20 16:26:40', NULL, NULL, '0.00', 1, 0, 13, 0),
(170, 1000, '', 'sre.jpg', '5.0000', '2005-07-20 16:27:53', NULL, NULL, '0.00', 1, 0, 12, 0),
(171, 1000, '', 'tyr.jpg', '10.0000', '2005-07-20 16:29:33', NULL, NULL, '0.00', 1, 0, 12, 0),
(179, 777, '', 'm20.jpg', '11.9500', '2005-08-27 16:39:01', '2005-08-27 16:41:37', NULL, '0.00', 1, 0, 0, 0),
(178, 777, '', 'm21.jpg', '13.9900', '2005-08-27 16:36:32', '2005-08-27 16:42:52', NULL, '0.00', 1, 0, 0, 0),
(177, 777, '', 'm22.jpg', '14.8400', '2005-08-27 16:31:53', '2005-08-27 16:41:11', NULL, '0.00', 1, 0, 0, 0),
(176, 777, '', 'm23.jpg', '16.9900', '2005-08-27 16:30:15', '2005-08-27 16:42:23', NULL, '0.00', 1, 0, 0, 0),
(180, 777, '', 'm19.jpg', '8.9900', '2005-08-27 16:39:56', '2005-08-27 16:41:59', NULL, '0.00', 1, 0, 0, 0),
(181, 777, '', 'm18.jpg', '16.9900', '2005-08-27 16:40:44', '2005-08-27 16:45:57', NULL, '0.00', 1, 0, 0, 0);
# --------------------------------------------------------

#
# Table structure for table `products_attributes`
#

DROP TABLE IF EXISTS `products_attributes`;
CREATE TABLE `products_attributes` (
  `products_attributes_id` int(11) NOT NULL auto_increment,
  `products_id` int(11) NOT NULL default '0',
  `options_id` int(11) NOT NULL default '0',
  `options_values_id` int(11) NOT NULL default '0',
  `options_values_price` decimal(15,4) NOT NULL default '0.0000',
  `price_prefix` char(1) NOT NULL default '',
  PRIMARY KEY  (`products_attributes_id`)
) TYPE=MyISAM;

#
# Dumping data for table `products_attributes`
#

INSERT INTO `products_attributes` VALUES (26, 22, 5, 10, '0.0000', '+'),
(27, 22, 5, 13, '0.0000', '+');
# --------------------------------------------------------

#
# Table structure for table `products_attributes_download`
#

DROP TABLE IF EXISTS `products_attributes_download`;
CREATE TABLE `products_attributes_download` (
  `products_attributes_id` int(11) NOT NULL default '0',
  `products_attributes_filename` varchar(255) NOT NULL default '',
  `products_attributes_maxdays` int(2) default '0',
  `products_attributes_maxcount` int(2) default '0',
  PRIMARY KEY  (`products_attributes_id`)
) TYPE=MyISAM;

#
# Dumping data for table `products_attributes_download`
#

INSERT INTO `products_attributes_download` VALUES (26, 'unreal.zip', 7, 3);
# --------------------------------------------------------

#
# Table structure for table `products_description`
#

DROP TABLE IF EXISTS `products_description`;
CREATE TABLE `products_description` (
  `products_id` int(11) NOT NULL auto_increment,
  `language_id` int(11) NOT NULL default '1',
  `products_name` varchar(64) NOT NULL default '',
  `products_description` text,
  `products_url` varchar(255) default NULL,
  `products_viewed` int(5) default '0',
  PRIMARY KEY  (`products_id`,`language_id`),
  KEY `products_name` (`products_name`)
) TYPE=MyISAM;

#
# Dumping data for table `products_description`
#

INSERT INTO `products_description` VALUES (163, 2, 'Womens Solid Beach Living SwimMini', 'Sold as separates for great fit from top to bottom. Skirt hides an attached swim panty. SupplexŪ nylon dries in a flash. Panty gives full back coverage - no tugging. Small back pocket.', '', 0),
(163, 3, 'Womens Solid Beach Living SwimMini', 'Sold as separates for great fit from top to bottom. Skirt hides an attached swim panty. SupplexŪ nylon dries in a flash. Panty gives full back coverage - no tugging. Small back pocket.', '', 0),
(164, 1, 'Rib One Piece Mailot', 'Ribbed faille fabric smoothes your figure. Bikini style sits at hip level. Hi-cut style features full rear coverage.', '', 2),
(164, 2, 'Rib One Piece Mailot', 'Ribbed faille fabric smoothes your figure. Bikini style sits at hip level. Hi-cut style features full rear coverage.', '', 0),
(164, 3, 'Rib One Piece Mailot', 'Ribbed faille fabric smoothes your figure. Bikini style sits at hip level. Hi-cut style features full rear coverage.', '', 0),
(165, 1, 'Orchid Leapord Mailot', 'Wildly unrefined, this one-piece swimsuit flatters straight and curvaceous figures with its innovative stretch design. Features high cut legs, an adjustable halter-top strap and revealing backless construction, all in a mix of animal print and exotic flowers. 81% Nylon/19% Spandex. Machine washable. Imported', '', 0),
(165, 2, 'Orchid Leapord Mailot', 'Wildly unrefined, this one-piece swimsuit flatters straight and curvaceous figures with its innovative stretch design. Features high cut legs, an adjustable halter-top strap and revealing backless construction, all in a mix of animal print and exotic flowers. 81% Nylon/19% Spandex. Machine washable. Imported', '', 0),
(165, 3, 'Orchid Leapord Mailot', 'Wildly unrefined, this one-piece swimsuit flatters straight and curvaceous figures with its innovative stretch design. Features high cut legs, an adjustable halter-top strap and revealing backless construction, all in a mix of animal print and exotic flowers. 81% Nylon/19% Spandex. Machine washable. Imported', '', 0),
(166, 1, 'Womens Underwire Faille Swim Top', 'Ribbed faille fabric smoothes your figure, Underwire cups and adjustable straps give it a bra-like fit. Fits B-C cups comfortably.', '', 0),
(166, 2, 'Womens Underwire Faille Swim Top', 'Ribbed faille fabric smoothes your figure, Underwire cups and adjustable straps give it a bra-like fit. Fits B-C cups comfortably.', '', 0),
(166, 3, 'Womens Underwire Faille Swim Top', 'Ribbed faille fabric smoothes your figure, Underwire cups and adjustable straps give it a bra-like fit. Fits B-C cups comfortably.', '', 0),
(167, 1, 'Blues Thong', 'A contoured pouch gives you a custom-fit feel. The traditional thong back ensures a snug fit. Additional comfort is provided by the plush, no-roll waistband. Double-needle stitching ensures long lasting quality. 100% Cotton. Machine washable. Imported.', '', 0),
(167, 2, 'Blues Thong', 'A contoured pouch gives you a custom-fit feel. The traditional thong back ensures a snug fit. Additional comfort is provided by the plush, no-roll waistband. Double-needle stitching ensures long lasting quality. 100% Cotton. Machine washable. Imported.', '', 0),
(167, 3, 'Blues Thong', 'A contoured pouch gives you a custom-fit feel. The traditional thong back ensures a snug fit. Additional comfort is provided by the plush, no-roll waistband. Double-needle stitching ensures long lasting quality. 100% Cotton. Machine washable. Imported.', '', 0),
(168, 1, 'Cotton Wide Rib Socks', 'Wide-rib provides a snug fit. Skillfully reinforced at the toe for longer, more comfortable wear. Flattened toe seams provide a sleek fit. 85% Cotton/12% Nylon/3% Spandex. Machine washable. Imported.', '', 1),
(168, 2, 'Cotton Wide Rib Socks', 'Wide-rib provides a snug fit. Skillfully reinforced at the toe for longer, more comfortable wear. Flattened toe seams provide a sleek fit. 85% Cotton/12% Nylon/3% Spandex. Machine washable. Imported.', '', 0),
(168, 3, 'Cotton Wide Rib Socks', 'Wide-rib provides a snug fit. Skillfully reinforced at the toe for longer, more comfortable wear. Flattened toe seams provide a sleek fit. 85% Cotton/12% Nylon/3% Spandex. Machine washable. Imported.', '', 0),
(169, 1, 'Kenwood Socks', 'Support and comfort are provided by the rounded heel. Reinforced at the toe for long lasting wear. Flattened toe seams give you a fit that is nothing short of extraordinary. 60% Cotton/40% Nylon. Machine washable. Imported.', '', 0),
(169, 2, 'Kenwood Socks', 'Support and comfort are provided by the rounded heel. Reinforced at the toe for long lasting wear. Flattened toe seams give you a fit that is nothing short of extraordinary. 60% Cotton/40% Nylon. Machine washable. Imported.', '', 0),
(169, 3, 'Kenwood Socks', 'Support and comfort are provided by the rounded heel. Reinforced at the toe for long lasting wear. Flattened toe seams give you a fit that is nothing short of extraordinary. 60% Cotton/40% Nylon. Machine washable. Imported.', '', 0),
(170, 1, 'Pin Dot Socks', 'A more comfortable, long lasting fit is offered by the reinforced toe. Well rounded heels give you gentle support and a comfy fit. Added fit is provided by the flattened toe seams. Pin dot pattern gives you a sophisticated look. 60% Cotton/40% Nylon. Machine washable. Imported.', '', 0),
(170, 2, 'Pin Dot Socks', 'A more comfortable, long lasting fit is offered by the reinforced toe. Well rounded heels give you gentle support and a comfy fit. Added fit is provided by the flattened toe seams. Pin dot pattern gives you a sophisticated look. 60% Cotton/40% Nylon. Machine washable. Imported.', '', 0),
(170, 3, 'Pin Dot Socks', 'A more comfortable, long lasting fit is offered by the reinforced toe. Well rounded heels give you gentle support and a comfy fit. Added fit is provided by the flattened toe seams. Pin dot pattern gives you a sophisticated look. 60% Cotton/40% Nylon. Machine washable. Imported.', '', 0),
(171, 1, 'Acrylic Amicor Crew', 'Revolutionary Cooling Channels(TM) technology encourages air flow to help dissipate heat, resulting in cooler, drier feet. Super Stay-Up Top holds sock up comfortably. Cushioned sole for added comfort and protection. Amicor(TM) technology provides continuous control of odor-causing bacteria. 61% Duraspun(TM)/22% Amicor(TM)/14% Acrylic/3% Lycra Spandex. Machine washable. Made in the U.S.A.', '', 0),
(171, 2, 'Acrylic Amicor Crew', 'Revolutionary Cooling Channels(TM) technology encourages air flow to help dissipate heat, resulting in cooler, drier feet. Super Stay-Up Top holds sock up comfortably. Cushioned sole for added comfort and protection. Amicor(TM) technology provides continuous control of odor-causing bacteria. 61% Duraspun(TM)/22% Amicor(TM)/14% Acrylic/3% Lycra Spandex. Machine washable. Made in the U.S.A.', '', 0),
(171, 3, 'Acrylic Amicor Crew', 'Revolutionary Cooling Channels(TM) technology encourages air flow to help dissipate heat, resulting in cooler, drier feet. Super Stay-Up Top holds sock up comfortably. Cushioned sole for added comfort and protection. Amicor(TM) technology provides continuous control of odor-causing bacteria. 61% Duraspun(TM)/22% Amicor(TM)/14% Acrylic/3% Lycra Spandex. Machine washable. Made in the U.S.A.', '', 0),
(163, 1, 'Womens Solid Beach Living SwimMini', 'Sold as separates for great fit from top to bottom. Skirt hides an attached swim panty. SupplexŪ nylon dries in a flash. Panty gives full back coverage - no tugging. Small back pocket.', '', 3),
(162, 3, 'Hi Waist Bottom', 'Flattering bikini bottoms are the key to a successful swimsuit. Providing coverage, shape and all-around style, these high-waisted bikini briefs will give you the look you\'ve been waiting for. Coordinates with an array of Apostrophe(R) bikini tops. 90% Polyester/10% Spandex. Hand wash. Imported.', '', 0),
(162, 2, 'Hi Waist Bottom', 'Flattering bikini bottoms are the key to a successful swimsuit. Providing coverage, shape and all-around style, these high-waisted bikini briefs will give you the look you\'ve been waiting for. Coordinates with an array of Apostrophe(R) bikini tops. 90% Polyester/10% Spandex. Hand wash. Imported.', '', 0),
(162, 1, 'Hi Waist Bottom', 'Flattering bikini bottoms are the key to a successful swimsuit. Providing coverage, shape and all-around style, these high-waisted bikini briefs will give you the look you\'ve been waiting for. Coordinates with an array of Apostrophe(R) bikini tops. 90% Polyester/10% Spandex. Hand wash. Imported.', '', 0),
(161, 1, 'Hipster with Buckle', 'A groovy retro print will put you in the mood for some fun at the beach in these bright, upbeat bikini bottoms featuring an ultra-cool, low-waisted cut. Coordinates with an array of Apostrophe(R) bikini tops. 90% Polyester/10% Spandex. Hand wash. Imported.', '', 0),
(161, 2, 'Hipster with Buckle', 'A groovy retro print will put you in the mood for some fun at the beach in these bright, upbeat bikini bottoms featuring an ultra-cool, low-waisted cut. Coordinates with an array of Apostrophe(R) bikini tops. 90% Polyester/10% Spandex. Hand wash. Imported.', '', 0),
(161, 3, 'Hipster with Buckle', 'A groovy retro print will put you in the mood for some fun at the beach in these bright, upbeat bikini bottoms featuring an ultra-cool, low-waisted cut. Coordinates with an array of Apostrophe(R) bikini tops. 90% Polyester/10% Spandex. Hand wash. Imported.', '', 0),
(160, 3, 'Short Sleeve Twill Shirts', 'All the elements that matter most create a work shirt you can depend on. Tough, twill blend that manages to be cool and comfortable. Easy button-front that\'s just roomy enough, with two button-through flap pockets. The PermaPrestŪ finish makes this shirt wrinkle-free right from the dryer. 65% polyester/35% cotton. Machine washable. Made in the U.S.A.', '', 0),
(160, 1, 'Short Sleeve Twill Shirts', 'All the elements that matter most create a work shirt you can depend on. Tough, twill blend that manages to be cool and comfortable. Easy button-front that\'s just roomy enough, with two button-through flap pockets. The PermaPrestŪ finish makes this shirt wrinkle-free right from the dryer. 65% polyester/35% cotton. Machine washable. Made in the U.S.A.', '', 11),
(160, 2, 'Short Sleeve Twill Shirts', 'All the elements that matter most create a work shirt you can depend on. Tough, twill blend that manages to be cool and comfortable. Easy button-front that\'s just roomy enough, with two button-through flap pockets. The PermaPrestŪ finish makes this shirt wrinkle-free right from the dryer. 65% polyester/35% cotton. Machine washable. Made in the U.S.A.', '', 0),
(159, 1, 'Carpenter Bib', 'Rugged, prewashed denim bib overalls. Adjustable straps for the right fit. Four pockets on the bib, two back pockets, two pockets on the right leg and two slant pockets and coin pockets. With a hammer loop. Durable, triple stitching on main seams. 84% Cotton/16% Polyester. Machine washable. Imported.', '', 1),
(159, 2, 'Carpenter Bib', 'Rugged, prewashed denim bib overalls. Adjustable straps for the right fit. Four pockets on the bib, two back pockets, two pockets on the right leg and two slant pockets and coin pockets. With a hammer loop. Durable, triple stitching on main seams. 84% Cotton/16% Polyester. Machine washable. Imported.', '', 0),
(159, 3, 'Carpenter Bib', 'Rugged, prewashed denim bib overalls. Adjustable straps for the right fit. Four pockets on the bib, two back pockets, two pockets on the right leg and two slant pockets and coin pockets. With a hammer loop. Durable, triple stitching on main seams. 84% Cotton/16% Polyester. Machine washable. Imported.', '', 0),
(158, 3, 'Long Sleeve Coverall', 'Full body coverage, generously cut for great range of motion. Full-zip front, two snaps at collar. Snap-closure at sleeve cuffs. Two chest pockets, two slant front pockets. Side openings for access to your pockets. Hammer loop, two tool pockets, and two patch pockets on rear. Elastic at sides of waist for a fit. Permanent press. 65% Polyester/35% Cotton. Machine washable. Imported.', '', 0),
(158, 2, 'Long Sleeve Coverall', 'Full body coverage, generously cut for great range of motion. Full-zip front, two snaps at collar. Snap-closure at sleeve cuffs. Two chest pockets, two slant front pockets. Side openings for access to your pockets. Hammer loop, two tool pockets, and two patch pockets on rear. Elastic at sides of waist for a fit. Permanent press. 65% Polyester/35% Cotton. Machine washable. Imported.', '', 0),
(158, 1, 'Long Sleeve Coverall', 'Full body coverage, generously cut for great range of motion. Full-zip front, two snaps at collar. Snap-closure at sleeve cuffs. Two chest pockets, two slant front pockets. Side openings for access to your pockets. Hammer loop, two tool pockets, and two patch pockets on rear. Elastic at sides of waist for a fit. Permanent press. 65% Polyester/35% Cotton. Machine washable. Imported.', '', 0),
(157, 3, 'Twill Pants', 'Tough enough for work, nice enough for play. Traditional styling with a fit you can be comfortable with...straight legs, front zip, sits at the waist. Two back welt pockets and two front slant pockets. Heavy twill blend manages to be cool and comfortable, never stiff, yet always up to the job at hand. PermaPrest(R) finish. 65% polyester/35% cotton. Machine washable. Imported.', '', 0),
(157, 2, 'Twill Pants', 'Tough enough for work, nice enough for play. Traditional styling with a fit you can be comfortable with...straight legs, front zip, sits at the waist. Two back welt pockets and two front slant pockets. Heavy twill blend manages to be cool and comfortable, never stiff, yet always up to the job at hand. PermaPrest(R) finish. 65% polyester/35% cotton. Machine washable. Imported.', '', 0),
(157, 1, 'Twill Pants', 'Tough enough for work, nice enough for play. Traditional styling with a fit you can be comfortable with...straight legs, front zip, sits at the waist. Two back welt pockets and two front slant pockets. Heavy twill blend manages to be cool and comfortable, never stiff, yet always up to the job at hand. PermaPrest(R) finish. 65% polyester/35% cotton. Machine washable. Imported.', '', 0),
(156, 3, 'Long Sleeve Twill Shirts', 'All the elements that matter most create a work shirt you can depend on. Tough, twill blend that manages to be cool and comfortable. Easy button-front that\'s just roomy enough, with two button-through flap pockets. The PermaPrest(R) finish makes this shirt wrinkle-free right from the dryer. 65% polyester/35% cotton. Machine washable. Imported.', '', 0),
(156, 1, 'Long Sleeve Twill Shirts', 'All the elements that matter most create a work shirt you can depend on. Tough, twill blend that manages to be cool and comfortable. Easy button-front that\'s just roomy enough, with two button-through flap pockets. The PermaPrest(R) finish makes this shirt wrinkle-free right from the dryer. 65% polyester/35% cotton. Machine washable. Imported.', '', 0),
(156, 2, 'Long Sleeve Twill Shirts', 'All the elements that matter most create a work shirt you can depend on. Tough, twill blend that manages to be cool and comfortable. Easy button-front that\'s just roomy enough, with two button-through flap pockets. The PermaPrest(R) finish makes this shirt wrinkle-free right from the dryer. 65% polyester/35% cotton. Machine washable. Imported.', '', 0),
(155, 3, 'Carpenter Jean', 'These prewashed denim jeans are a must for the man on the go. Two back pockets, two pockets on the right leg, two slant front pockets and coin pocket. With a hammer loop. Durable, triple stitching on main seams. 84% Cotton/16% Polyester. Machine washable. Imported.', '', 0),
(155, 2, 'Carpenter Jean', 'These prewashed denim jeans are a must for the man on the go. Two back pockets, two pockets on the right leg, two slant front pockets and coin pocket. With a hammer loop. Durable, triple stitching on main seams. 84% Cotton/16% Polyester. Machine washable. Imported.', '', 0),
(155, 1, 'Carpenter Jean', 'These prewashed denim jeans are a must for the man on the go. Two back pockets, two pockets on the right leg, two slant front pockets and coin pocket. With a hammer loop. Durable, triple stitching on main seams. 84% Cotton/16% Polyester. Machine washable. Imported.', '', 14),
(154, 2, 'Mens Cashmere Crew Sweater', 'The world\'s finest cashmere\r\nRich two-ply yarns have real body\r\nRefined and comfortable set-in sleeves\r\nFully fashioned for a fit like hand knit', '', 0),
(154, 3, 'Mens Cashmere Crew Sweater', 'The world\'s finest cashmere\r\nRich two-ply yarns have real body\r\nRefined and comfortable set-in sleeves\r\nFully fashioned for a fit like hand knit', '', 0),
(154, 1, 'Mens Cashmere Crew Sweater', 'The world\'s finest cashmere\r\nRich two-ply yarns have real body\r\nRefined and comfortable set-in sleeves\r\nFully fashioned for a fit like hand knit', '', 0),
(153, 1, 'Mens Cashmere V-neck Sweater', 'The world\'s highest-grade cashmere, with refined and comfortable set-in sleeves.', '', 0),
(153, 2, 'Mens Cashmere V-neck Sweater', 'The world\'s highest-grade cashmere, with refined and comfortable set-in sleeves.', '', 0),
(153, 3, 'Mens Cashmere V-neck Sweater', 'The world\'s highest-grade cashmere, with refined and comfortable set-in sleeves.', '', 0),
(151, 2, 'Mens Wool Cashmere Half-zip Sweater', '70% lambswool /30% cashmere blend\r\nFull-fashion construction for a natural fit\r\nNicely finished rib-knit cuffs and bottom', '', 0),
(151, 3, 'Mens Wool Cashmere Half-zip Sweater', '70% lambswool /30% cashmere blend\r\nFull-fashion construction for a natural fit\r\nNicely finished rib-knit cuffs and bottom', '', 0),
(152, 1, 'Mens Cashmere Mock Sweater', '100% cashmere\r\nFully fashioned to follow the natural shape of the body\r\nPerfect for layering', '', 0),
(152, 2, 'Mens Cashmere Mock Sweater', '100% cashmere\r\nFully fashioned to follow the natural shape of the body\r\nPerfect for layering', '', 0),
(152, 3, 'Mens Cashmere Mock Sweater', '100% cashmere\r\nFully fashioned to follow the natural shape of the body\r\nPerfect for layering', '', 0),
(149, 3, 'Mens Merino Pullover Sweater Vest', '100% merino wool\r\nWhole garment constructed for a better, more comfortable, fit\r\nRib-knit bottom band\r\nClassic V-neck styling', '', 0),
(150, 1, 'Mens Merino Polo Sweater', '100% merino wool\r\nWhole garment constructed for a better, more comfortable, fit\r\nAttractive shell buttons\r\nRib-knit bottom band', '', 0),
(150, 2, 'Mens Merino Polo Sweater', '100% merino wool\r\nWhole garment constructed for a better, more comfortable, fit\r\nAttractive shell buttons\r\nRib-knit bottom band', '', 0),
(150, 3, 'Mens Merino Polo Sweater', '100% merino wool\r\nWhole garment constructed for a better, more comfortable, fit\r\nAttractive shell buttons\r\nRib-knit bottom band', '', 0),
(151, 1, 'Mens Wool Cashmere Half-zip Sweater', '70% lambswool /30% cashmere blend\r\nFull-fashion construction for a natural fit\r\nNicely finished rib-knit cuffs and bottom', '', 1),
(148, 3, 'Pleated CoolMax(R) Carefree Comfort Khakis', 'These cuffed pants are as easy to wear as they are to care for. Cool Max technology with a moisture wick system helps you stay cool and comfortable. Teflon prevents stains from setting in. A little Lycra and a comfort-stretch waistband invisibly give you up to two extra inches around the waist for superior fit. 64% Cotton/36% Polyester. Machine washable. Imported.', '', 0),
(149, 1, 'Mens Merino Pullover Sweater Vest', '100% merino wool\r\nWhole garment constructed for a better, more comfortable, fit\r\nRib-knit bottom band\r\nClassic V-neck styling', '', 0),
(149, 2, 'Mens Merino Pullover Sweater Vest', '100% merino wool\r\nWhole garment constructed for a better, more comfortable, fit\r\nRib-knit bottom band\r\nClassic V-neck styling', '', 0),
(148, 2, 'Pleated CoolMax(R) Carefree Comfort Khakis', 'These cuffed pants are as easy to wear as they are to care for. Cool Max technology with a moisture wick system helps you stay cool and comfortable. Teflon prevents stains from setting in. A little Lycra and a comfort-stretch waistband invisibly give you up to two extra inches around the waist for superior fit. 64% Cotton/36% Polyester. Machine washable. Imported.', '', 0),
(148, 1, 'Pleated CoolMax(R) Carefree Comfort Khakis', 'These cuffed pants are as easy to wear as they are to care for. Cool Max technology with a moisture wick system helps you stay cool and comfortable. Teflon prevents stains from setting in. A little Lycra and a comfort-stretch waistband invisibly give you up to two extra inches around the waist for superior fit. 64% Cotton/36% Polyester. Machine washable. Imported.', '', 0),
(147, 3, 'Blues Relaxed Fit Jeans', 'Relaxed fit jeans give you more room in the seat and thigh for comfort. Traditional 5-pocket styling. Zip fly with button closure. 100% cotton. Machine washable. Imported.', '', 0),
(147, 1, 'Blues Relaxed Fit Jeans', 'Relaxed fit jeans give you more room in the seat and thigh for comfort. Traditional 5-pocket styling. Zip fly with button closure. 100% cotton. Machine washable. Imported.', '', 0),
(147, 2, 'Blues Relaxed Fit Jeans', 'Relaxed fit jeans give you more room in the seat and thigh for comfort. Traditional 5-pocket styling. Zip fly with button closure. 100% cotton. Machine washable. Imported.', '', 0),
(146, 2, 'Blues Carpenter Jeans', 'For the guy on the go. Lots of pockets and loops make great places to carry your necessities. Zip fly with button closure. 100% cotton. Machine washable. Imported.', '', 0),
(146, 3, 'Blues Carpenter Jeans', 'For the guy on the go. Lots of pockets and loops make great places to carry your necessities. Zip fly with button closure. 100% cotton. Machine washable. Imported.', '', 0),
(145, 3, 'Flexjean', 'Stretchable denim jeans are fashioned with contrast stitching and 4-pocket styling. Updated tab closure with zip fly. Heavyweight denim. 50% cotton/50% polyester. Machine washable. Made in the U.S.A.', '', 0),
(146, 1, 'Blues Carpenter Jeans', 'For the guy on the go. Lots of pockets and loops make great places to carry your necessities. Zip fly with button closure. 100% cotton. Machine washable. Imported.', '', 15),
(145, 2, 'Flexjean', 'Stretchable denim jeans are fashioned with contrast stitching and 4-pocket styling. Updated tab closure with zip fly. Heavyweight denim. 50% cotton/50% polyester. Machine washable. Made in the U.S.A.', '', 0),
(144, 3, 'Front Performance Khakis', 'Plain front pants are stain and wrinkle resistant. Comfortable waist and relaxed fit through the seat and thigh. 16 1/2" leg opening. Zip fly and button closure. 100% cotton, 8 oz. twill. Machine washable. Imported.', '', 0),
(145, 1, 'Flexjean', 'Stretchable denim jeans are fashioned with contrast stitching and 4-pocket styling. Updated tab closure with zip fly. Heavyweight denim. 50% cotton/50% polyester. Machine washable. Made in the U.S.A.', '', 0),
(144, 2, 'Front Performance Khakis', 'Plain front pants are stain and wrinkle resistant. Comfortable waist and relaxed fit through the seat and thigh. 16 1/2" leg opening. Zip fly and button closure. 100% cotton, 8 oz. twill. Machine washable. Imported.', '', 0),
(143, 3, 'Basic Twill Pant', 'The original workpant since 1922. Dickies(R) are known for their comfort and durability. These feature flat front, tunnel belt loops, non-roll waistband and lockstitched hem. Easy-care fabric with stain release finish', '', 0),
(144, 1, 'Front Performance Khakis', 'Plain front pants are stain and wrinkle resistant. Comfortable waist and relaxed fit through the seat and thigh. 16 1/2" leg opening. Zip fly and button closure. 100% cotton, 8 oz. twill. Machine washable. Imported.', '', 0),
(143, 2, 'Basic Twill Pant', 'The original workpant since 1922. Dickies(R) are known for their comfort and durability. These feature flat front, tunnel belt loops, non-roll waistband and lockstitched hem. Easy-care fabric with stain release finish', '', 0),
(143, 1, 'Basic Twill Pant', 'The original workpant since 1922. Dickies(R) are known for their comfort and durability. These feature flat front, tunnel belt loops, non-roll waistband and lockstitched hem. Easy-care fabric with stain release finish', '', 0),
(140, 3, 'Mens 14-oz. Calf-length Turkish Robe', 'Soft, 14-oz. pure Turkish cotton terry. Roomy, no-gap fit. Shawl collar, calf-length.', '', 0),
(141, 1, 'Mens Lightweight Full-length Terry Robe', 'Soft, pure 10-oz. Turkish cotton terry\r\nRoomy fit, no need to size up\r\nShawl collar', '', 0),
(141, 2, 'Mens Lightweight Full-length Terry Robe', 'Soft, pure 10-oz. Turkish cotton terry\r\nRoomy fit, no need to size up\r\nShawl collar', '', 0),
(141, 3, 'Mens Lightweight Full-length Terry Robe', 'Soft, pure 10-oz. Turkish cotton terry\r\nRoomy fit, no need to size up\r\nShawl collar', '', 0),
(142, 1, 'Mens Flannel Pants', 'Fine Portuguese flannel, brushed to bring out the softness\r\nPrewashed so it won\'t shrink out of size\r\nImproved fit', '', 0),
(142, 2, 'Mens Flannel Pants', 'Fine Portuguese flannel, brushed to bring out the softness\r\nPrewashed so it won\'t shrink out of size\r\nImproved fit', '', 0),
(142, 3, 'Mens Flannel Pants', 'Fine Portuguese flannel, brushed to bring out the softness\r\nPrewashed so it won\'t shrink out of size\r\nImproved fit', '', 0),
(139, 1, 'Classics Waffle Robe', 'Medium weight, waffle-textured cotton. White piping detail for a distinctive look. Shawl collar. Two patch pockets on front. Self tie belt. 100% Cotton. Machine washable. Imported.', '', 1),
(139, 2, 'Classics Waffle Robe', 'Medium weight, waffle-textured cotton. White piping detail for a distinctive look. Shawl collar. Two patch pockets on front. Self tie belt. 100% Cotton. Machine washable. Imported.', '', 0),
(139, 3, 'Classics Waffle Robe', 'Medium weight, waffle-textured cotton. White piping detail for a distinctive look. Shawl collar. Two patch pockets on front. Self tie belt. 100% Cotton. Machine washable. Imported.', '', 0),
(140, 1, 'Mens 14-oz. Calf-length Turkish Robe', 'Soft, 14-oz. pure Turkish cotton terry. Roomy, no-gap fit. Shawl collar, calf-length.', '', 5),
(140, 2, 'Mens 14-oz. Calf-length Turkish Robe', 'Soft, 14-oz. pure Turkish cotton terry. Roomy, no-gap fit. Shawl collar, calf-length.', '', 0),
(138, 1, 'Classics Long Sleeve Broadcloth Pajamas', 'Contrasting piping detail, chest pocket and cuffed sleeves give these long sleeved, long legged pajamas a classic look. The pants have a covered elastic waistband and a contoured seat for extra comfort. 55% Cotton/45% Polyester. Machine washable. Imported.', '', 10),
(138, 2, 'Classics Long Sleeve Broadcloth Pajamas', 'Contrasting piping detail, chest pocket and cuffed sleeves give these long sleeved, long legged pajamas a classic look. The pants have a covered elastic waistband and a contoured seat for extra comfort. 55% Cotton/45% Polyester. Machine washable. Imported.', '', 0),
(138, 3, 'Classics Long Sleeve Broadcloth Pajamas', 'Contrasting piping detail, chest pocket and cuffed sleeves give these long sleeved, long legged pajamas a classic look. The pants have a covered elastic waistband and a contoured seat for extra comfort. 55% Cotton/45% Polyester. Machine washable. Imported.', '', 0),
(137, 1, 'Long Sleeve Broadcloth Pajamas', 'Contrasting piping detail, chest pocket and cuffed sleeves give these long sleeved, long legged pajamas a classic look. The pants have a covered elastic waistband and a contoured seat for extra comfort. 55% Cotton/45% Polyester. Machine washable. Imported', '', 0),
(137, 2, 'Long Sleeve Broadcloth Pajamas', 'Contrasting piping detail, chest pocket and cuffed sleeves give these long sleeved, long legged pajamas a classic look. The pants have a covered elastic waistband and a contoured seat for extra comfort. 55% Cotton/45% Polyester. Machine washable. Imported', '', 0),
(137, 3, 'Long Sleeve Broadcloth Pajamas', 'Contrasting piping detail, chest pocket and cuffed sleeves give these long sleeved, long legged pajamas a classic look. The pants have a covered elastic waistband and a contoured seat for extra comfort. 55% Cotton/45% Polyester. Machine washable. Imported', '', 0),
(136, 2, 'Mens Regular Packable 4-Pocket Shell Jacket', 'Completely waterproof  even sealed-seam construction. Three-way adjustable hood. Underarm grommets for ventilation. Four front pockets hold extras. Bottom drawcord for a perfect fit. Adjustable cuffs. Packs into its own pocket.', '', 0),
(136, 3, 'Mens Regular Packable 4-Pocket Shell Jacket', 'Completely waterproof  even sealed-seam construction. Three-way adjustable hood. Underarm grommets for ventilation. Four front pockets hold extras. Bottom drawcord for a perfect fit. Adjustable cuffs. Packs into its own pocket.', '', 0),
(135, 2, 'Mens Thermacheck Jacket', 'Wicks moisture away from body with the power of Coolmax \r\nFabric has superior Lycra stretch for ease and comfort\r\nHeavyweight ThermaCheck-200 fleece\r\nConstructed with T400 for superior warmth\r\nWind resistant\r\nZip front\r\nDrawcord hem\r\nZip pockets\r\nDri-off finish allows water to bead up and roll off', '', 0),
(135, 3, 'Mens Thermacheck Jacket', 'Wicks moisture away from body with the power of Coolmax \r\nFabric has superior Lycra stretch for ease and comfort\r\nHeavyweight ThermaCheck-200 fleece\r\nConstructed with T400 for superior warmth\r\nWind resistant\r\nZip front\r\nDrawcord hem\r\nZip pockets\r\nDri-off finish allows water to bead up and roll off', '', 0),
(136, 1, 'Mens Regular Packable 4-Pocket Shell Jacket', 'Completely waterproof  even sealed-seam construction. Three-way adjustable hood. Underarm grommets for ventilation. Four front pockets hold extras. Bottom drawcord for a perfect fit. Adjustable cuffs. Packs into its own pocket.', '', 0),
(134, 3, 'Mens GORE-TEX Jacket', 'GORE-TEX is the most proven waterproof/breathable technology on the market . Guaranteed To Keep You DryŪ. Soft mesh lining enhances air circulation. Storm flaps and adjustable cuffs seal out rain. Packs away in its own pocket.', '', 0),
(135, 1, 'Mens Thermacheck Jacket', 'Wicks moisture away from body with the power of Coolmax \r\nFabric has superior Lycra stretch for ease and comfort\r\nHeavyweight ThermaCheck-200 fleece\r\nConstructed with T400 for superior warmth\r\nWind resistant\r\nZip front\r\nDrawcord hem\r\nZip pockets\r\nDri-off finish allows water to bead up and roll off', '', 1),
(133, 3, 'Trucker Jacket', 'This updated version of the denim Trucker Jacket has a classic, relaxed-fit. The antique look and copper finished trademark logo buttons never go out of style. Adjustable waist, button front and cuffs. Two flap pockets for convenience. 100% Cotton denim. Machine washable. Imported.', '', 0),
(134, 1, 'Mens GORE-TEX Jacket', 'GORE-TEX is the most proven waterproof/breathable technology on the market . Guaranteed To Keep You DryŪ. Soft mesh lining enhances air circulation. Storm flaps and adjustable cuffs seal out rain. Packs away in its own pocket.', '', 2),
(134, 2, 'Mens GORE-TEX Jacket', 'GORE-TEX is the most proven waterproof/breathable technology on the market . Guaranteed To Keep You DryŪ. Soft mesh lining enhances air circulation. Storm flaps and adjustable cuffs seal out rain. Packs away in its own pocket.', '', 0),
(133, 1, 'Trucker Jacket', 'This updated version of the denim Trucker Jacket has a classic, relaxed-fit. The antique look and copper finished trademark logo buttons never go out of style. Adjustable waist, button front and cuffs. Two flap pockets for convenience. 100% Cotton denim. Machine washable. Imported.', '', 2),
(133, 2, 'Trucker Jacket', 'This updated version of the denim Trucker Jacket has a classic, relaxed-fit. The antique look and copper finished trademark logo buttons never go out of style. Adjustable waist, button front and cuffs. Two flap pockets for convenience. 100% Cotton denim. Machine washable. Imported.', '', 0),
(132, 2, 'Structure Denim Jacket', 'This on-trend, fashion jacket features button front and cuffs with pewter-tone Structure(R) logo buttons. Two welt pockets on front seaming detail. Banded waist. 100% Cotton denim. Machine washable. Imported.', '', 0),
(132, 3, 'Structure Denim Jacket', 'This on-trend, fashion jacket features button front and cuffs with pewter-tone Structure(R) logo buttons. Two welt pockets on front seaming detail. Banded waist. 100% Cotton denim. Machine washable. Imported.', '', 0),
(131, 3, 'Urban Jacket', 'Smart, straightforward styling features a clean-lined zip front, two welt pockets and center back seam. Two inside pockets keep essentials close. Fully lined for a smooth, slick fit. 100% Nylon. Imported.', '', 0),
(132, 1, 'Structure Denim Jacket', 'This on-trend, fashion jacket features button front and cuffs with pewter-tone Structure(R) logo buttons. Two welt pockets on front seaming detail. Banded waist. 100% Cotton denim. Machine washable. Imported.', '', 0),
(131, 1, 'Urban Jacket', 'Smart, straightforward styling features a clean-lined zip front, two welt pockets and center back seam. Two inside pockets keep essentials close. Fully lined for a smooth, slick fit. 100% Nylon. Imported.', '', 0),
(131, 2, 'Urban Jacket', 'Smart, straightforward styling features a clean-lined zip front, two welt pockets and center back seam. Two inside pockets keep essentials close. Fully lined for a smooth, slick fit. 100% Nylon. Imported.', '', 0),
(130, 2, 'Oxford Cloth Dress Shirt', 'This oxford dress shirt is perfect for business casual office environments. Double needle side seam and sleeve seam. Comfortable, generous fit. Finished with a button-down collar, chest pocket and shirttail hem. 65% Polyester/35% Cotton. Machine washable. Imported.', '', 0),
(130, 3, 'Oxford Cloth Dress Shirt', 'This oxford dress shirt is perfect for business casual office environments. Double needle side seam and sleeve seam. Comfortable, generous fit. Finished with a button-down collar, chest pocket and shirttail hem. 65% Polyester/35% Cotton. Machine washable. Imported.', '', 0),
(129, 2, 'Poplin Dress Shirt', 'Comfortable dress shirt is wrinkle free for all-day crispness. Detailed with a point collar, chest pocket and shirttail hem. French placket. 65% Polyester/35% Cotton. Machine washable. Imported.', '', 0),
(129, 3, 'Poplin Dress Shirt', 'Comfortable dress shirt is wrinkle free for all-day crispness. Detailed with a point collar, chest pocket and shirttail hem. French placket. 65% Polyester/35% Cotton. Machine washable. Imported.', '', 0),
(130, 1, 'Oxford Cloth Dress Shirt', 'This oxford dress shirt is perfect for business casual office environments. Double needle side seam and sleeve seam. Comfortable, generous fit. Finished with a button-down collar, chest pocket and shirttail hem. 65% Polyester/35% Cotton. Machine washable. Imported.', '', 0),
(128, 2, 'Long Sleeve Fashion Dress Shirts', 'This shirt is fabricated of a smooth, comfortable plaid fabric that will coordinate well with a variety of dress pants and suits. A button-down collar, seven-button placket and chest pocket complete the look. Imported.', '', 0),
(128, 3, 'Long Sleeve Fashion Dress Shirts', 'This shirt is fabricated of a smooth, comfortable plaid fabric that will coordinate well with a variety of dress pants and suits. A button-down collar, seven-button placket and chest pocket complete the look. Imported.', '', 0),
(129, 1, 'Poplin Dress Shirt', 'Comfortable dress shirt is wrinkle free for all-day crispness. Detailed with a point collar, chest pocket and shirttail hem. French placket. 65% Polyester/35% Cotton. Machine washable. Imported.', '', 2),
(127, 1, 'Broadcloth Dress Shirt', 'You\'ll look polished and sophisticated. Detailed with a point collar, chest pocket and shirttail hem. Double needle side and sleeve seams. Generous fit. 65% Polyester/35% Cotton. Machine washable. Imported.', '', 0),
(127, 2, 'Broadcloth Dress Shirt', 'You\'ll look polished and sophisticated. Detailed with a point collar, chest pocket and shirttail hem. Double needle side and sleeve seams. Generous fit. 65% Polyester/35% Cotton. Machine washable. Imported.', '', 0),
(127, 3, 'Broadcloth Dress Shirt', 'You\'ll look polished and sophisticated. Detailed with a point collar, chest pocket and shirttail hem. Double needle side and sleeve seams. Generous fit. 65% Polyester/35% Cotton. Machine washable. Imported.', '', 0),
(128, 1, 'Long Sleeve Fashion Dress Shirts', 'This shirt is fabricated of a smooth, comfortable plaid fabric that will coordinate well with a variety of dress pants and suits. A button-down collar, seven-button placket and chest pocket complete the look. Imported.', '', 0),
(126, 1, 'Broadcloth Dress Shirt - Tone on Tone', 'You\'ll look polished and sophisticated. Distinctive tone-on-tone styling, detailed with a point collar, chest pocket and shirttail hem. Double needle side and sleeve seams. Generous fit. 65% Polyester/35% Cotton. Machine washable. Imported..', '', 0),
(126, 2, 'Broadcloth Dress Shirt - Tone on Tone', 'You\'ll look polished and sophisticated. Distinctive tone-on-tone styling, detailed with a point collar, chest pocket and shirttail hem. Double needle side and sleeve seams. Generous fit. 65% Polyester/35% Cotton. Machine washable. Imported..', '', 0),
(126, 3, 'Broadcloth Dress Shirt - Tone on Tone', 'You\'ll look polished and sophisticated. Distinctive tone-on-tone styling, detailed with a point collar, chest pocket and shirttail hem. Double needle side and sleeve seams. Generous fit. 65% Polyester/35% Cotton. Machine washable. Imported..', '', 0),
(125, 1, 'Short Sleeve Broadcloth Dress Shirt', 'This crisp short sleeve dress shirt is fashioned with a point collar, chest pocket and shirttail hem. Comfortable, generous fit. Double needle side and sleeve seams. 65% Polyester/35% Cotton. Machine washable. Imported.', '', 0),
(125, 2, 'Short Sleeve Broadcloth Dress Shirt', 'This crisp short sleeve dress shirt is fashioned with a point collar, chest pocket and shirttail hem. Comfortable, generous fit. Double needle side and sleeve seams. 65% Polyester/35% Cotton. Machine washable. Imported.', '', 0),
(125, 3, 'Short Sleeve Broadcloth Dress Shirt', 'This crisp short sleeve dress shirt is fashioned with a point collar, chest pocket and shirttail hem. Comfortable, generous fit. Double needle side and sleeve seams. 65% Polyester/35% Cotton. Machine washable. Imported.', '', 0),
(124, 3, 'Dunbar Jeans', 'These traditional, heavyweight denim jeans have a comfortable waist with a classic, regular fit through the seat and thigh. Straight leg with 16" bottom opening. 5-pocket design, with zip fly and button closure. Machine washable. Imported.', '', 0),
(124, 2, 'Dunbar Jeans', 'These traditional, heavyweight denim jeans have a comfortable waist with a classic, regular fit through the seat and thigh. Straight leg with 16" bottom opening. 5-pocket design, with zip fly and button closure. Machine washable. Imported.', '', 0),
(124, 1, 'Dunbar Jeans', 'These traditional, heavyweight denim jeans have a comfortable waist with a classic, regular fit through the seat and thigh. Straight leg with 16" bottom opening. 5-pocket design, with zip fly and button closure. Machine washable. Imported.', '', 0),
(122, 3, 'Regular Fit Jeans', 'These traditional, heavyweight denim jeans have a comfortable waist with a classic, regular fit through the seat and thigh. Straight leg with 16" bottom opening. 5-pocket design, with zip fly and button closure. Machine washable. Imported.', '', 0),
(123, 1, 'Core Basic Jeans', 'The cornerstone of fashion, the denim jean. These 5-pocket jeans have a regular fit and straight leg styling. Riveted front pockets. Zip fly with button closure. Machine washable.', '', 0),
(123, 2, 'Core Basic Jeans', 'The cornerstone of fashion, the denim jean. These 5-pocket jeans have a regular fit and straight leg styling. Riveted front pockets. Zip fly with button closure. Machine washable.', '', 0),
(123, 3, 'Core Basic Jeans', 'The cornerstone of fashion, the denim jean. These 5-pocket jeans have a regular fit and straight leg styling. Riveted front pockets. Zip fly with button closure. Machine washable.', '', 0),
(121, 3, 'Flexjean', 'Stretchable denim jeans are fashioned with contrast stitching and 4-pocket styling. Updated tab closure with zip fly. Heavyweight denim. 50% cotton/50% polyester. Machine washable. Made in the U.S.A.', '', 0),
(122, 1, 'Regular Fit Jeans', 'These traditional, heavyweight denim jeans have a comfortable waist with a classic, regular fit through the seat and thigh. Straight leg with 16" bottom opening. 5-pocket design, with zip fly and button closure. Machine washable. Imported.', '', 0),
(122, 2, 'Regular Fit Jeans', 'These traditional, heavyweight denim jeans have a comfortable waist with a classic, regular fit through the seat and thigh. Straight leg with 16" bottom opening. 5-pocket design, with zip fly and button closure. Machine washable. Imported.', '', 0),
(120, 2, 'Blues Classic Fit Jeans', 'Classic fit jeans have a natural waistline and slim fit through seat and thighs. 5-pocket styling. Zip fly with button closure. 100% cotton. Machine washable. Imported.', '', 0),
(120, 3, 'Blues Classic Fit Jeans', 'Classic fit jeans have a natural waistline and slim fit through seat and thighs. 5-pocket styling. Zip fly with button closure. 100% cotton. Machine washable. Imported.', '', 0),
(121, 1, 'Flexjean', 'Stretchable denim jeans are fashioned with contrast stitching and 4-pocket styling. Updated tab closure with zip fly. Heavyweight denim. 50% cotton/50% polyester. Machine washable. Made in the U.S.A.', '', 0),
(121, 2, 'Flexjean', 'Stretchable denim jeans are fashioned with contrast stitching and 4-pocket styling. Updated tab closure with zip fly. Heavyweight denim. 50% cotton/50% polyester. Machine washable. Made in the U.S.A.', '', 0),
(119, 2, 'Blues Relaxed Fit Jeans', 'Relaxed fit jeans give you more room in the seat and thigh for comfort. Traditional 5-pocket styling. Zip fly with button closure. 100% cotton. Machine washable. Imported.', '', 0),
(119, 3, 'Blues Relaxed Fit Jeans', 'Relaxed fit jeans give you more room in the seat and thigh for comfort. Traditional 5-pocket styling. Zip fly with button closure. 100% cotton. Machine washable. Imported.', '', 0),
(120, 1, 'Blues Classic Fit Jeans', 'Classic fit jeans have a natural waistline and slim fit through seat and thighs. 5-pocket styling. Zip fly with button closure. 100% cotton. Machine washable. Imported.', '', 0),
(118, 2, 'Short Sleeve All Over Striped Polo', 'Bright, bold polo is fashioned of soft cotton with yarn-dyed engineered stripes for long-wearing style. Rib knit collar and two-button placket. 100% Cotton. Machine washable. Imported.', '', 0),
(118, 3, 'Short Sleeve All Over Striped Polo', 'Bright, bold polo is fashioned of soft cotton with yarn-dyed engineered stripes for long-wearing style. Rib knit collar and two-button placket. 100% Cotton. Machine washable. Imported.', '', 0),
(119, 1, 'Blues Relaxed Fit Jeans', 'Relaxed fit jeans give you more room in the seat and thigh for comfort. Traditional 5-pocket styling. Zip fly with button closure. 100% cotton. Machine washable. Imported.', '', 0),
(117, 3, 'Short Sleeve Henley', 'This super-comfortable top combines several special features for a memorable, but laid-back look. The ringer neckline and short sleeves are detailed with contrasting rib-knit bands, as is the inside layer of the short, wide placket. 100% Cotton. Machine washable. Imported.', '', 0),
(118, 1, 'Short Sleeve All Over Striped Polo', 'Bright, bold polo is fashioned of soft cotton with yarn-dyed engineered stripes for long-wearing style. Rib knit collar and two-button placket. 100% Cotton. Machine washable. Imported.', '', 0),
(117, 1, 'Short Sleeve Henley', 'This super-comfortable top combines several special features for a memorable, but laid-back look. The ringer neckline and short sleeves are detailed with contrasting rib-knit bands, as is the inside layer of the short, wide placket. 100% Cotton. Machine washable. Imported.', '', 0),
(116, 1, 'Short Sleeve Chest Striped Polo', 'Bright, bold polo is fashioned of soft cotton with yarn-dyed engineered stripes for long-wearing style. Rib knit collar and two-button placket. 100% Cotton. Machine washable. Imported.', '', 1),
(116, 2, 'Short Sleeve Chest Striped Polo', 'Bright, bold polo is fashioned of soft cotton with yarn-dyed engineered stripes for long-wearing style. Rib knit collar and two-button placket. 100% Cotton. Machine washable. Imported.', '', 0),
(116, 3, 'Short Sleeve Chest Striped Polo', 'Bright, bold polo is fashioned of soft cotton with yarn-dyed engineered stripes for long-wearing style. Rib knit collar and two-button placket. 100% Cotton. Machine washable. Imported.', '', 0),
(114, 2, 'Eagle Shield', 'Now he can display his patriotism in a stylish, comfortable way with this eagle printed tee. Features short sleeves, crew neckline and an eagle shield screenprint with patriotic flair. Falls hip length. 100% Cotton. Machine washable. Imported.', '', 0),
(114, 3, 'Eagle Shield', 'Now he can display his patriotism in a stylish, comfortable way with this eagle printed tee. Features short sleeves, crew neckline and an eagle shield screenprint with patriotic flair. Falls hip length. 100% Cotton. Machine washable. Imported.', '', 0),
(117, 2, 'Short Sleeve Henley', 'This super-comfortable top combines several special features for a memorable, but laid-back look. The ringer neckline and short sleeves are detailed with contrasting rib-knit bands, as is the inside layer of the short, wide placket. 100% Cotton. Machine washable. Imported.', '', 0),
(113, 1, 'Liberty Cross', 'He can display his patriotism to the world while staying cool and comfortable in this stylish tee. Features short sleeves, crewneckline and a patriotic-hued liberty cross with chrome-inspired trim. Falls hip length. 100% Cotton. Machine washable. Imported.', '', 1),
(113, 2, 'Liberty Cross', 'He can display his patriotism to the world while staying cool and comfortable in this stylish tee. Features short sleeves, crewneckline and a patriotic-hued liberty cross with chrome-inspired trim. Falls hip length. 100% Cotton. Machine washable. Imported.', '', 0),
(113, 3, 'Liberty Cross', 'He can display his patriotism to the world while staying cool and comfortable in this stylish tee. Features short sleeves, crewneckline and a patriotic-hued liberty cross with chrome-inspired trim. Falls hip length. 100% Cotton. Machine washable. Imported.', '', 0),
(114, 1, 'Eagle Shield', 'Now he can display his patriotism in a stylish, comfortable way with this eagle printed tee. Features short sleeves, crew neckline and an eagle shield screenprint with patriotic flair. Falls hip length. 100% Cotton. Machine washable. Imported.', '', 1),
(112, 2, 'American Track', 'Whether he is site-seeing at a car show or working under the hood, your guy will look great in this detailed tee. Features short sleeves, crew neckline and an "American Classic" screenprint with patriotic hot rod. Falls hip length. 100% Cotton. Machine washable. Imported.', '', 0),
(112, 3, 'American Track', 'Whether he is site-seeing at a car show or working under the hood, your guy will look great in this detailed tee. Features short sleeves, crew neckline and an "American Classic" screenprint with patriotic hot rod. Falls hip length. 100% Cotton. Machine washable. Imported.', '', 0),
(111, 1, 'Sleeveless Tank', 'The all-purpose cotton tank fuses with fashionable bright colored rugby stripes in this comfortable cool top, essential for the summer. Features a deep feminine scoop neck, fine ribbed fabric and flirty bold stripes. Falls hip-length. 100% Cotton. Machine washable. Imported.', '', 47),
(111, 2, 'Sleeveless Tank', 'The all-purpose cotton tank fuses with fashionable bright colored rugby stripes in this comfortable cool top, essential for the summer. Features a deep feminine scoop neck, fine ribbed fabric and flirty bold stripes. Falls hip-length. 100% Cotton. Machine washable. Imported.', '', 0),
(111, 3, 'Sleeveless Tank', 'The all-purpose cotton tank fuses with fashionable bright colored rugby stripes in this comfortable cool top, essential for the summer. Features a deep feminine scoop neck, fine ribbed fabric and flirty bold stripes. Falls hip-length. 100% Cotton. Machine washable. Imported.', '', 0),
(112, 1, 'American Track', 'Whether he is site-seeing at a car show or working under the hood, your guy will look great in this detailed tee. Features short sleeves, crew neckline and an "American Classic" screenprint with patriotic hot rod. Falls hip length. 100% Cotton. Machine washable. Imported.', '', 1),
(109, 2, 'End Mens Straight Leg Fleece Sport Pants', '80% combed cotton/20% polyester\r\nGarment washed for softness and to minimize shrinkage\r\nComfortable elasticized waist\r\nHemmed leg openings\r\nSporty leg stripe', '', 0),
(109, 3, 'End Mens Straight Leg Fleece Sport Pants', '80% combed cotton/20% polyester\r\nGarment washed for softness and to minimize shrinkage\r\nComfortable elasticized waist\r\nHemmed leg openings\r\nSporty leg stripe', '', 0),
(109, 1, 'End Mens Straight Leg Fleece Sport Pants', '80% combed cotton/20% polyester\r\nGarment washed for softness and to minimize shrinkage\r\nComfortable elasticized waist\r\nHemmed leg openings\r\nSporty leg stripe', '', 0),
(108, 2, 'Athletic NuBlend Fleece Pant', 'This hefty 9 oz. per square yard fleece blend, feels so good, you\'ll want to live in these pants. Featuring a great athletic cut, they have a fit that\'s just roomy enough without looking sloppy. Tunnel elastic waist with inside draw cord means you get all-day comfort with easy-on, easy-off access. Elastic leg bottoms. 50% Cotton/50% Polyester. Machine washable. Imported.', '', 0),
(108, 3, 'Athletic NuBlend Fleece Pant', 'This hefty 9 oz. per square yard fleece blend, feels so good, you\'ll want to live in these pants. Featuring a great athletic cut, they have a fit that\'s just roomy enough without looking sloppy. Tunnel elastic waist with inside draw cord means you get all-day comfort with easy-on, easy-off access. Elastic leg bottoms. 50% Cotton/50% Polyester. Machine washable. Imported.', '', 0),
(108, 1, 'Athletic NuBlend Fleece Pant', 'This hefty 9 oz. per square yard fleece blend, feels so good, you\'ll want to live in these pants. Featuring a great athletic cut, they have a fit that\'s just roomy enough without looking sloppy. Tunnel elastic waist with inside draw cord means you get all-day comfort with easy-on, easy-off access. Elastic leg bottoms. 50% Cotton/50% Polyester. Machine washable. Imported.', '', 0),
(107, 3, 'Athletic NuBlend Fleece Crew', 'Designed for optimum comfort, NuBlend is a hefty 9 oz. per square yard fleece blend that is super soft. Fully-covered seams and reinforced trim make this crew supremely durable. Cuffs and waistband have a touch of spandex. Rib knit collar with V-patch detail and full-length, set-in sleeves finish off the easy-on, easy-off relaxed fit. 50% Cotton/50% Polyester. Machine washable. Imported', '', 0),
(107, 2, 'Athletic NuBlend Fleece Crew', 'Designed for optimum comfort, NuBlend is a hefty 9 oz. per square yard fleece blend that is super soft. Fully-covered seams and reinforced trim make this crew supremely durable. Cuffs and waistband have a touch of spandex. Rib knit collar with V-patch detail and full-length, set-in sleeves finish off the easy-on, easy-off relaxed fit. 50% Cotton/50% Polyester. Machine washable. Imported', '', 0),
(106, 3, 'Athletic ProCotton(tm) Pocket T-Shirt', 'Your most basic layer just got better. Fully covered seams make the neck, shoulders and armholes super strong. Double needle stitching gives the hemmed sleeves and bottom extra reinforcement. Beefy, ring-spun cotton for a comfortable feel right from the start. Rib-knit collar and Pro Cotton logo on the lower front. 100% Cotton. Machine washable. Imported.', '', 0),
(107, 1, 'Athletic NuBlend Fleece Crew', 'Designed for optimum comfort, NuBlend is a hefty 9 oz. per square yard fleece blend that is super soft. Fully-covered seams and reinforced trim make this crew supremely durable. Cuffs and waistband have a touch of spandex. Rib knit collar with V-patch detail and full-length, set-in sleeves finish off the easy-on, easy-off relaxed fit. 50% Cotton/50% Polyester. Machine washable. Imported', '', 5),
(106, 2, 'Athletic ProCotton(tm) Pocket T-Shirt', 'Your most basic layer just got better. Fully covered seams make the neck, shoulders and armholes super strong. Double needle stitching gives the hemmed sleeves and bottom extra reinforcement. Beefy, ring-spun cotton for a comfortable feel right from the start. Rib-knit collar and Pro Cotton logo on the lower front. 100% Cotton. Machine washable. Imported.', '', 0),
(106, 1, 'Athletic ProCotton(tm) Pocket T-Shirt', 'Your most basic layer just got better. Fully covered seams make the neck, shoulders and armholes super strong. Double needle stitching gives the hemmed sleeves and bottom extra reinforcement. Beefy, ring-spun cotton for a comfortable feel right from the start. Rib-knit collar and Pro Cotton logo on the lower front. 100% Cotton. Machine washable. Imported.', '', 2),
(105, 2, 'Crewneck Tee-shirt with Navy Color', 'This super-soft tee offers plenty of comfort for relaxing with friends, and a look you\'ll love. The ringer neckline is detailed with an eye-catching rib-knit band in a contrasting color. 100% Cotton. Machine washable. Imported.', '', 0),
(105, 3, 'Crewneck Tee-shirt with Navy Color', 'This super-soft tee offers plenty of comfort for relaxing with friends, and a look you\'ll love. The ringer neckline is detailed with an eye-catching rib-knit band in a contrasting color. 100% Cotton. Machine washable. Imported.', '', 0),
(105, 1, 'Crewneck Tee-shirt with Navy Color', 'This super-soft tee offers plenty of comfort for relaxing with friends, and a look you\'ll love. The ringer neckline is detailed with an eye-catching rib-knit band in a contrasting color. 100% Cotton. Machine washable. Imported.', '', 2),
(104, 3, 'Trifold Burnished Tan Wallet', 'Made of full grain leather with a burnished tan finish for added character. This attractive tri-fold wallet has plenty of room for your essentials with the four vertical credit card pockets, the secure ID window, the lined currency compartment and three utility pockets. The familiar Levi\'sŪ logo is embossed on the front. Packaged in a gift tin for an extra touch of class. Imported.', '', 0),
(104, 2, 'Trifold Burnished Tan Wallet', 'Made of full grain leather with a burnished tan finish for added character. This attractive tri-fold wallet has plenty of room for your essentials with the four vertical credit card pockets, the secure ID window, the lined currency compartment and three utility pockets. The familiar Levi\'sŪ logo is embossed on the front. Packaged in a gift tin for an extra touch of class. Imported.', '', 0),
(99, 1, 'Dockers Gold Buckle Belt', 'Genuine leather with a solid brass buckle. Self loop, feathered edges, and tapered end give this belt a sophisticated appearance. Belt width is 30 MM. Available in sizes 32 to 42. Imported.', '', 1),
(99, 2, 'Dockers Gold Buckle Belt', 'Genuine leather with a solid brass buckle. Self loop, feathered edges, and tapered end give this belt a sophisticated appearance. Belt width is 30 MM. Available in sizes 32 to 42. Imported.', '', 0),
(99, 3, 'Dockers Gold Buckle Belt', 'Genuine leather with a solid brass buckle. Self loop, feathered edges, and tapered end give this belt a sophisticated appearance. Belt width is 30 MM. Available in sizes 32 to 42. Imported.', '', 0),
(100, 1, 'Cotton Web Belt', 'Cotton webbing with brushed nickel finish and military style, slide-through buckle offers a trendy look. Metal reinforcement tab on end. One size fits all. Belt width is 38 MM. Imported', '', 2),
(100, 2, 'Cotton Web Belt', 'Cotton webbing with brushed nickel finish and military style, slide-through buckle offers a trendy look. Metal reinforcement tab on end. One size fits all. Belt width is 38 MM. Imported', '', 0),
(100, 3, 'Cotton Web Belt', 'Cotton webbing with brushed nickel finish and military style, slide-through buckle offers a trendy look. Metal reinforcement tab on end. One size fits all. Belt width is 38 MM. Imported', '', 0),
(101, 1, 'Braided Gold Buckle Belt', 'Full grain leather with a silver-tone buckle. Braided for a casual style. Tapered end and self loop for added character. Embossed Levi\'s(R) logo. Belt width is 35 MM. Available in sizes 30 to 42. Imported', '', 9),
(101, 2, 'Braided Gold Buckle Belt', 'Full grain leather with a silver-tone buckle. Braided for a casual style. Tapered end and self loop for added character. Embossed Levi\'s(R) logo. Belt width is 35 MM. Available in sizes 30 to 42. Imported', '', 0),
(101, 3, 'Braided Gold Buckle Belt', 'Full grain leather with a silver-tone buckle. Braided for a casual style. Tapered end and self loop for added character. Embossed Levi\'s(R) logo. Belt width is 35 MM. Available in sizes 30 to 42. Imported', '', 0),
(102, 1, '10 piece Manicure Set', 'Portable grooming set includes ten implements: cuticle pusher, toenail clipper, fingernail clipper, eyeglasses repair kit, lint brush, nail file, scissors, tweezers, comb and five-way knife. Attractive case with embossed detailing on front and Dockers(R) logo on front and inside spine. Imported.', '', 2),
(102, 2, '10 piece Manicure Set', 'Portable grooming set includes ten implements: cuticle pusher, toenail clipper, fingernail clipper, eyeglasses repair kit, lint brush, nail file, scissors, tweezers, comb and five-way knife. Attractive case with embossed detailing on front and Dockers(R) logo on front and inside spine. Imported.', '', 0),
(102, 3, '10 piece Manicure Set', 'Portable grooming set includes ten implements: cuticle pusher, toenail clipper, fingernail clipper, eyeglasses repair kit, lint brush, nail file, scissors, tweezers, comb and five-way knife. Attractive case with embossed detailing on front and Dockers(R) logo on front and inside spine. Imported.', '', 0),
(103, 1, 'Regular Wool Surcingle Belt', 'Hand crafted in the USA with an easy, flexible wool blend strap and gold tone solid brass buckle', '', 0),
(103, 2, 'Regular Wool Surcingle Belt', 'Hand crafted in the USA with an easy, flexible wool blend strap and gold tone solid brass buckle', '', 0),
(103, 3, '', 'Hand crafted in the USA with an easy, flexible wool blend strap and gold tone solid brass buckle', '', 0),
(104, 1, 'Trifold Burnished Tan Wallet', 'Made of full grain leather with a burnished tan finish for added character. This attractive tri-fold wallet has plenty of room for your essentials with the four vertical credit card pockets, the secure ID window, the lined currency compartment and three utility pockets. The familiar Levi\'sŪ logo is embossed on the front. Packaged in a gift tin for an extra touch of class. Imported.', '', 2),
(181, 3, 'George - Charmeuse Camisole Top', 'He can display his patriotism to the world while staying cool and comfortable in this stylish tee. Features short sleeves, crewneckline and a patriotic-hued liberty cross with chrome-inspired trim. Falls hip length. 100% Cotton. Machine washable. Imported.', '', 0),
(180, 2, 'Faded Glory - Women\'s Lace Top', 'He can display his patriotism to the world while staying cool and comfortable in this stylish tee. Features short sleeves, crewneckline and a patriotic-hued liberty cross with chrome-inspired trim. Falls hip length. 100% Cotton. Machine washable. Imported.', '', 0),
(180, 3, 'Faded Glory - Women\'s Lace Top', 'He can display his patriotism to the world while staying cool and comfortable in this stylish tee. Features short sleeves, crewneckline and a patriotic-hued liberty cross with chrome-inspired trim. Falls hip length. 100% Cotton. Machine washable. Imported.', '', 0),
(181, 1, 'George - Charmeuse Camisole Top', 'He can display his patriotism to the world while staying cool and comfortable in this stylish tee. Features short sleeves, crewneckline and a patriotic-hued liberty cross with chrome-inspired trim. Falls hip length. 100% Cotton. Machine washable. Imported.', '', 2),
(181, 2, 'George - Charmeuse Camisole Top', 'He can display his patriotism to the world while staying cool and comfortable in this stylish tee. Features short sleeves, crewneckline and a patriotic-hued liberty cross with chrome-inspired trim. Falls hip length. 100% Cotton. Machine washable. Imported.', '', 0),
(179, 2, 'Women\'s Layered Paisley Bra Tank', 'He can display his patriotism to the world while staying cool and comfortable in this stylish tee. Features short sleeves, crewneckline and a patriotic-hued liberty cross with chrome-inspired trim. Falls hip length. 100% Cotton. Machine washable. Imported.', '', 0),
(179, 3, 'Women\'s Layered Paisley Bra Tank', 'He can display his patriotism to the world while staying cool and comfortable in this stylish tee. Features short sleeves, crewneckline and a patriotic-hued liberty cross with chrome-inspired trim. Falls hip length. 100% Cotton. Machine washable. Imported.', '', 0),
(180, 1, 'Faded Glory - Women\'s Lace Top', 'He can display his patriotism to the world while staying cool and comfortable in this stylish tee. Features short sleeves, crewneckline and a patriotic-hued liberty cross with chrome-inspired trim. Falls hip length. 100% Cotton. Machine washable. Imported.', '', 0),
(178, 2, 'Wine Country Print Jersey Flounce Skirt', 'Wide-rib provides a snug fit. Skillfully reinforced at the toe for longer, more comfortable wear. Flattened toe seams provide a sleek fit. 85% Cotton/12% Nylon/3% Spandex. Machine washable. Imported.', '', 0),
(178, 3, 'Wine Country Print Jersey Flounce Skirt', 'Wide-rib provides a snug fit. Skillfully reinforced at the toe for longer, more comfortable wear. Flattened toe seams provide a sleek fit. 85% Cotton/12% Nylon/3% Spandex. Machine washable. Imported.', '', 0),
(179, 1, 'Women\'s Layered Paisley Bra Tank', 'He can display his patriotism to the world while staying cool and comfortable in this stylish tee. Features short sleeves, crewneckline and a patriotic-hued liberty cross with chrome-inspired trim. Falls hip length. 100% Cotton. Machine washable. Imported.', '', 0),
(177, 2, 'Women\'s East Village Blouse', 'Bright, bold polo is fashioned of soft cotton with yarn-dyed engineered stripes for long-wearing style. Rib knit collar and two-button placket. 100% Cotton. Machine washable. Imported.', '', 0),
(177, 3, 'Women\'s East Village Blouse', 'Bright, bold polo is fashioned of soft cotton with yarn-dyed engineered stripes for long-wearing style. Rib knit collar and two-button placket. 100% Cotton. Machine washable. Imported.', '', 0),
(178, 1, 'Wine Country Print Jersey Flounce Skirt', 'Wide-rib provides a snug fit. Skillfully reinforced at the toe for longer, more comfortable wear. Flattened toe seams provide a sleek fit. 85% Cotton/12% Nylon/3% Spandex. Machine washable. Imported.', '', 0),
(176, 1, 'George - Sateen Bermuda Short', 'Sold as separates for great fit from top to bottom. Skirt hides an attached swim panty. SupplexŪ nylon dries in a flash. Panty gives full back coverage - no tugging. Small back pocket.', '', 1),
(176, 2, 'George - Sateen Bermuda Short', 'Sold as separates for great fit from top to bottom. Skirt hides an attached swim panty. SupplexŪ nylon dries in a flash. Panty gives full back coverage - no tugging. Small back pocket.', '', 0),
(176, 3, 'George - Sateen Bermuda Short', 'Sold as separates for great fit from top to bottom. Skirt hides an attached swim panty. SupplexŪ nylon dries in a flash. Panty gives full back coverage - no tugging. Small back pocket.', '', 0),
(177, 1, 'Women\'s East Village Blouse', 'Bright, bold polo is fashioned of soft cotton with yarn-dyed engineered stripes for long-wearing style. Rib knit collar and two-button placket. 100% Cotton. Machine washable. Imported.', '', 0);
# --------------------------------------------------------

#
# Table structure for table `products_notifications`
#

DROP TABLE IF EXISTS `products_notifications`;
CREATE TABLE `products_notifications` (
  `products_id` int(11) NOT NULL default '0',
  `customers_id` int(11) NOT NULL default '0',
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`products_id`,`customers_id`)
) TYPE=MyISAM;

#
# Dumping data for table `products_notifications`
#

INSERT INTO `products_notifications` VALUES (0, 2, '2005-07-11 18:22:39');
# --------------------------------------------------------

#
# Table structure for table `products_options`
#

DROP TABLE IF EXISTS `products_options`;
CREATE TABLE `products_options` (
  `products_options_id` int(11) NOT NULL default '0',
  `language_id` int(11) NOT NULL default '1',
  `products_options_name` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`products_options_id`,`language_id`)
) TYPE=MyISAM;

#
# Dumping data for table `products_options`
#

INSERT INTO `products_options` VALUES (1, 1, 'Color'),
(2, 1, 'Size'),
(3, 1, 'Model'),
(4, 1, 'Memory'),
(1, 2, 'Farbe'),
(2, 2, 'Größe'),
(3, 2, 'Modell'),
(4, 2, 'Speicher'),
(1, 3, 'Color'),
(2, 3, 'Talla'),
(3, 3, 'Modelo'),
(4, 3, 'Memoria'),
(5, 3, 'Version'),
(5, 2, 'Version'),
(5, 1, 'Version');
# --------------------------------------------------------

#
# Table structure for table `products_options_values`
#

DROP TABLE IF EXISTS `products_options_values`;
CREATE TABLE `products_options_values` (
  `products_options_values_id` int(11) NOT NULL default '0',
  `language_id` int(11) NOT NULL default '1',
  `products_options_values_name` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`products_options_values_id`,`language_id`)
) TYPE=MyISAM;

#
# Dumping data for table `products_options_values`
#

INSERT INTO `products_options_values` VALUES (1, 1, '4 mb'),
(2, 1, '8 mb'),
(3, 1, '16 mb'),
(4, 1, '32 mb'),
(5, 1, 'Value'),
(6, 1, 'Premium'),
(7, 1, 'Deluxe'),
(8, 1, 'PS/2'),
(9, 1, 'USB'),
(1, 2, '4 MB'),
(2, 2, '8 MB'),
(3, 2, '16 MB'),
(4, 2, '32 MB'),
(5, 2, 'Value Ausgabe'),
(6, 2, 'Premium Ausgabe'),
(7, 2, 'Deluxe Ausgabe'),
(8, 2, 'PS/2 Anschluss'),
(9, 2, 'USB Anschluss'),
(1, 3, '4 mb'),
(2, 3, '8 mb'),
(3, 3, '16 mb'),
(4, 3, '32 mb'),
(5, 3, 'Value'),
(6, 3, 'Premium'),
(7, 3, 'Deluxe'),
(8, 3, 'PS/2'),
(9, 3, 'USB'),
(10, 1, 'Download: Windows - English'),
(10, 2, 'Download: Windows - Englisch'),
(10, 3, 'Download: Windows - Inglese'),
(13, 1, 'Box: Windows - English'),
(13, 2, 'Box: Windows - Englisch'),
(13, 3, 'Box: Windows - Inglese');
# --------------------------------------------------------

#
# Table structure for table `products_options_values_to_products_options`
#

DROP TABLE IF EXISTS `products_options_values_to_products_options`;
CREATE TABLE `products_options_values_to_products_options` (
  `products_options_values_to_products_options_id` int(11) NOT NULL auto_increment,
  `products_options_id` int(11) NOT NULL default '0',
  `products_options_values_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`products_options_values_to_products_options_id`)
) TYPE=MyISAM;

#
# Dumping data for table `products_options_values_to_products_options`
#

INSERT INTO `products_options_values_to_products_options` VALUES (1, 4, 1),
(2, 4, 2),
(3, 4, 3),
(4, 4, 4),
(5, 3, 5),
(6, 3, 6),
(7, 3, 7),
(8, 3, 8),
(9, 3, 9),
(10, 5, 10),
(13, 5, 13);
# --------------------------------------------------------

#
# Table structure for table `products_to_categories`
#

DROP TABLE IF EXISTS `products_to_categories`;
CREATE TABLE `products_to_categories` (
  `products_id` int(11) NOT NULL default '0',
  `categories_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`products_id`,`categories_id`)
) TYPE=MyISAM;

#
# Dumping data for table `products_to_categories`
#

INSERT INTO `products_to_categories` VALUES (99, 48),
(100, 48),
(101, 48),
(102, 48),
(103, 48),
(104, 48),
(105, 49),
(106, 49),
(107, 49),
(108, 49),
(109, 49),
(111, 49),
(112, 50),
(113, 50),
(114, 50),
(116, 50),
(117, 50),
(118, 50),
(119, 51),
(120, 51),
(121, 51),
(122, 51),
(123, 51),
(124, 51),
(125, 52),
(126, 52),
(127, 52),
(128, 52),
(129, 52),
(130, 52),
(131, 54),
(132, 54),
(133, 54),
(134, 54),
(135, 54),
(136, 54),
(137, 55),
(138, 55),
(139, 55),
(140, 55),
(141, 55),
(142, 55),
(143, 56),
(144, 56),
(145, 56),
(146, 56),
(147, 56),
(148, 56),
(149, 57),
(150, 57),
(151, 57),
(152, 57),
(153, 57),
(154, 57),
(155, 60),
(156, 60),
(157, 60),
(158, 60),
(159, 60),
(160, 60),
(161, 58),
(162, 58),
(163, 58),
(164, 58),
(165, 58),
(166, 58),
(167, 59),
(168, 59),
(169, 59),
(170, 59),
(171, 59),
(176, 58),
(177, 50),
(178, 58),
(179, 50),
(180, 50),
(181, 50);
# --------------------------------------------------------

#
# Table structure for table `reviews`
#

DROP TABLE IF EXISTS `reviews`;
CREATE TABLE `reviews` (
  `reviews_id` int(11) NOT NULL auto_increment,
  `products_id` int(11) NOT NULL default '0',
  `customers_id` int(11) default NULL,
  `customers_name` varchar(64) NOT NULL default '',
  `reviews_rating` int(1) default NULL,
  `date_added` datetime default NULL,
  `last_modified` datetime default NULL,
  `reviews_read` int(5) NOT NULL default '0',
  PRIMARY KEY  (`reviews_id`)
) TYPE=MyISAM;

#
# Dumping data for table `reviews`
#

# --------------------------------------------------------

#
# Table structure for table `reviews_description`
#

DROP TABLE IF EXISTS `reviews_description`;
CREATE TABLE `reviews_description` (
  `reviews_id` int(11) NOT NULL default '0',
  `languages_id` int(11) NOT NULL default '0',
  `reviews_text` text NOT NULL,
  PRIMARY KEY  (`reviews_id`,`languages_id`)
) TYPE=MyISAM;

#
# Dumping data for table `reviews_description`
#

# --------------------------------------------------------

#
# Table structure for table `sessions`
#

DROP TABLE IF EXISTS `sessions`;
CREATE TABLE `sessions` (
  `sesskey` varchar(32) NOT NULL default '',
  `expiry` int(11) unsigned NOT NULL default '0',
  `value` text NOT NULL,
  PRIMARY KEY  (`sesskey`)
) TYPE=MyISAM;

#
# Dumping data for table `sessions`
#

INSERT INTO `sessions` VALUES ('3190280d2abc098133b00b6db755158a', 1120727173, 'cart|O:12:"shoppingcart":5:{s:8:"contents";a:0:{}s:5:"total";i:0;s:6:"weight";i:0;s:6:"cartID";N;s:12:"content_type";b:0;}language|s:7:"english";languages_id|s:1:"1";currency|s:3:"USD";navigation|O:17:"navigationhistory":2:{s:4:"path";a:3:{i:0;a:4:{s:4:"page";s:9:"index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:1;a:4:{s:4:"page";s:11:"account.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}i:2;a:4:{s:4:"page";s:9:"login.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1:{s:6:"action";s:7:"process";}s:4:"post";a:4:{s:13:"email_address";s:4:"yyty";s:8:"password";s:5:"yuyuy";s:1:"x";s:2:"34";s:1:"y";s:1:"9";}}}s:8:"snapshot";a:4:{s:4:"page";s:11:"account.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:0:{}s:4:"post";a:0:{}}}');
# --------------------------------------------------------

#
# Table structure for table `specials`
#

DROP TABLE IF EXISTS `specials`;
CREATE TABLE `specials` (
  `specials_id` int(11) NOT NULL auto_increment,
  `products_id` int(11) NOT NULL default '0',
  `specials_new_products_price` decimal(15,4) NOT NULL default '0.0000',
  `specials_date_added` datetime default NULL,
  `specials_last_modified` datetime default NULL,
  `expires_date` datetime default NULL,
  `date_status_change` datetime default NULL,
  `status` int(1) NOT NULL default '1',
  PRIMARY KEY  (`specials_id`)
) TYPE=MyISAM;

#
# Dumping data for table `specials`
#

INSERT INTO `specials` VALUES (9, 160, '9.9900', '2005-07-20 17:08:53', NULL, '0000-00-00 00:00:00', NULL, 1),
(8, 146, '19.9900', '2005-07-20 17:08:44', NULL, '0000-00-00 00:00:00', NULL, 1),
(10, 166, '11.0000', '2005-07-20 17:09:06', NULL, '0000-00-00 00:00:00', NULL, 1),
(11, 106, '5.5000', '2005-07-20 17:09:17', NULL, '0000-00-00 00:00:00', NULL, 1),
(12, 143, '17.9900', '2005-07-20 17:09:37', NULL, '0000-00-00 00:00:00', NULL, 1),
(13, 140, '51.0000', '2005-07-20 17:09:54', NULL, '0000-00-00 00:00:00', NULL, 1),
(14, 181, '10.9900', '2005-08-27 16:45:02', NULL, '0000-00-00 00:00:00', NULL, 1);
# --------------------------------------------------------

#
# Table structure for table `tax_class`
#

DROP TABLE IF EXISTS `tax_class`;
CREATE TABLE `tax_class` (
  `tax_class_id` int(11) NOT NULL auto_increment,
  `tax_class_title` varchar(32) NOT NULL default '',
  `tax_class_description` varchar(255) NOT NULL default '',
  `last_modified` datetime default NULL,
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`tax_class_id`)
) TYPE=MyISAM;

#
# Dumping data for table `tax_class`
#

INSERT INTO `tax_class` VALUES (1, 'Taxable Goods', 'The following types of products are included non-food, services, etc', '2005-07-07 10:38:23', '2005-07-07 10:38:23');
# --------------------------------------------------------

#
# Table structure for table `tax_rates`
#

DROP TABLE IF EXISTS `tax_rates`;
CREATE TABLE `tax_rates` (
  `tax_rates_id` int(11) NOT NULL auto_increment,
  `tax_zone_id` int(11) NOT NULL default '0',
  `tax_class_id` int(11) NOT NULL default '0',
  `tax_priority` int(5) default '1',
  `tax_rate` decimal(7,4) NOT NULL default '0.0000',
  `tax_description` varchar(255) NOT NULL default '',
  `last_modified` datetime default NULL,
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`tax_rates_id`)
) TYPE=MyISAM;

#
# Dumping data for table `tax_rates`
#

INSERT INTO `tax_rates` VALUES (1, 1, 1, 1, '7.0000', 'FL TAX 7.0%', '2005-07-07 10:38:23', '2005-07-07 10:38:23');
# --------------------------------------------------------

#
# Table structure for table `whos_online`
#

DROP TABLE IF EXISTS `whos_online`;
CREATE TABLE `whos_online` (
  `customer_id` int(11) default NULL,
  `full_name` varchar(64) NOT NULL default '',
  `session_id` varchar(128) NOT NULL default '',
  `ip_address` varchar(15) NOT NULL default '',
  `time_entry` varchar(14) NOT NULL default '',
  `time_last_click` varchar(14) NOT NULL default '',
  `last_page_url` varchar(64) NOT NULL default ''
) TYPE=MyISAM;

#
# Dumping data for table `whos_online`
#

INSERT INTO `whos_online` VALUES (0, 'Guest', '90db9ba39b8510659fe4da560a70287e', '192.168.0.6', '1125149301', '1125151506', '/017/shopping_cart.php'),
(0, 'Guest', '5f3d08a258707f78c66cc2bfb468c087', '192.168.0.39', '1125151150', '1125151378', '/017/index.php?cPath=50');
# --------------------------------------------------------

#
# Table structure for table `zones`
#

DROP TABLE IF EXISTS `zones`;
CREATE TABLE `zones` (
  `zone_id` int(11) NOT NULL auto_increment,
  `zone_country_id` int(11) NOT NULL default '0',
  `zone_code` varchar(32) NOT NULL default '',
  `zone_name` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`zone_id`)
) TYPE=MyISAM;

#
# Dumping data for table `zones`
#

INSERT INTO `zones` VALUES (1, 223, 'AL', 'Alabama'),
(2, 223, 'AK', 'Alaska'),
(3, 223, 'AS', 'American Samoa'),
(4, 223, 'AZ', 'Arizona'),
(5, 223, 'AR', 'Arkansas'),
(6, 223, 'AF', 'Armed Forces Africa'),
(7, 223, 'AA', 'Armed Forces Americas'),
(8, 223, 'AC', 'Armed Forces Canada'),
(9, 223, 'AE', 'Armed Forces Europe'),
(10, 223, 'AM', 'Armed Forces Middle East'),
(11, 223, 'AP', 'Armed Forces Pacific'),
(12, 223, 'CA', 'California'),
(13, 223, 'CO', 'Colorado'),
(14, 223, 'CT', 'Connecticut'),
(15, 223, 'DE', 'Delaware'),
(16, 223, 'DC', 'District of Columbia'),
(17, 223, 'FM', 'Federated States Of Micronesia'),
(18, 223, 'FL', 'Florida'),
(19, 223, 'GA', 'Georgia'),
(20, 223, 'GU', 'Guam'),
(21, 223, 'HI', 'Hawaii'),
(22, 223, 'ID', 'Idaho'),
(23, 223, 'IL', 'Illinois'),
(24, 223, 'IN', 'Indiana'),
(25, 223, 'IA', 'Iowa'),
(26, 223, 'KS', 'Kansas'),
(27, 223, 'KY', 'Kentucky'),
(28, 223, 'LA', 'Louisiana'),
(29, 223, 'ME', 'Maine'),
(30, 223, 'MH', 'Marshall Islands'),
(31, 223, 'MD', 'Maryland'),
(32, 223, 'MA', 'Massachusetts'),
(33, 223, 'MI', 'Michigan'),
(34, 223, 'MN', 'Minnesota'),
(35, 223, 'MS', 'Mississippi'),
(36, 223, 'MO', 'Missouri'),
(37, 223, 'MT', 'Montana'),
(38, 223, 'NE', 'Nebraska'),
(39, 223, 'NV', 'Nevada'),
(40, 223, 'NH', 'New Hampshire'),
(41, 223, 'NJ', 'New Jersey'),
(42, 223, 'NM', 'New Mexico'),
(43, 223, 'NY', 'New York'),
(44, 223, 'NC', 'North Carolina'),
(45, 223, 'ND', 'North Dakota'),
(46, 223, 'MP', 'Northern Mariana Islands'),
(47, 223, 'OH', 'Ohio'),
(48, 223, 'OK', 'Oklahoma'),
(49, 223, 'OR', 'Oregon'),
(50, 223, 'PW', 'Palau'),
(51, 223, 'PA', 'Pennsylvania'),
(52, 223, 'PR', 'Puerto Rico'),
(53, 223, 'RI', 'Rhode Island'),
(54, 223, 'SC', 'South Carolina'),
(55, 223, 'SD', 'South Dakota'),
(56, 223, 'TN', 'Tennessee'),
(57, 223, 'TX', 'Texas'),
(58, 223, 'UT', 'Utah'),
(59, 223, 'VT', 'Vermont'),
(60, 223, 'VI', 'Virgin Islands'),
(61, 223, 'VA', 'Virginia'),
(62, 223, 'WA', 'Washington'),
(63, 223, 'WV', 'West Virginia'),
(64, 223, 'WI', 'Wisconsin'),
(65, 223, 'WY', 'Wyoming'),
(66, 38, 'AB', 'Alberta'),
(67, 38, 'BC', 'British Columbia'),
(68, 38, 'MB', 'Manitoba'),
(69, 38, 'NF', 'Newfoundland'),
(70, 38, 'NB', 'New Brunswick'),
(71, 38, 'NS', 'Nova Scotia'),
(72, 38, 'NT', 'Northwest Territories'),
(73, 38, 'NU', 'Nunavut'),
(74, 38, 'ON', 'Ontario'),
(75, 38, 'PE', 'Prince Edward Island'),
(76, 38, 'QC', 'Quebec'),
(77, 38, 'SK', 'Saskatchewan'),
(78, 38, 'YT', 'Yukon Territory'),
(79, 81, 'NDS', 'Niedersachsen'),
(80, 81, 'BAW', 'Baden-Württemberg'),
(81, 81, 'BAY', 'Bayern'),
(82, 81, 'BER', 'Berlin'),
(83, 81, 'BRG', 'Brandenburg'),
(84, 81, 'BRE', 'Bremen'),
(85, 81, 'HAM', 'Hamburg'),
(86, 81, 'HES', 'Hessen'),
(87, 81, 'MEC', 'Mecklenburg-Vorpommern'),
(88, 81, 'NRW', 'Nordrhein-Westfalen'),
(89, 81, 'RHE', 'Rheinland-Pfalz'),
(90, 81, 'SAR', 'Saarland'),
(91, 81, 'SAS', 'Sachsen'),
(92, 81, 'SAC', 'Sachsen-Anhalt'),
(93, 81, 'SCN', 'Schleswig-Holstein'),
(94, 81, 'THE', 'Thüringen'),
(95, 14, 'WI', 'Wien'),
(96, 14, 'NO', 'Niederösterreich'),
(97, 14, 'OO', 'Oberösterreich'),
(98, 14, 'SB', 'Salzburg'),
(99, 14, 'KN', 'Kärnten'),
(100, 14, 'ST', 'Steiermark'),
(101, 14, 'TI', 'Tirol'),
(102, 14, 'BL', 'Burgenland'),
(103, 14, 'VB', 'Voralberg'),
(104, 204, 'AG', 'Aargau'),
(105, 204, 'AI', 'Appenzell Innerrhoden'),
(106, 204, 'AR', 'Appenzell Ausserrhoden'),
(107, 204, 'BE', 'Bern'),
(108, 204, 'BL', 'Basel-Landschaft'),
(109, 204, 'BS', 'Basel-Stadt'),
(110, 204, 'FR', 'Freiburg'),
(111, 204, 'GE', 'Genf'),
(112, 204, 'GL', 'Glarus'),
(113, 204, 'JU', 'Graubünden'),
(114, 204, 'JU', 'Jura'),
(115, 204, 'LU', 'Luzern'),
(116, 204, 'NE', 'Neuenburg'),
(117, 204, 'NW', 'Nidwalden'),
(118, 204, 'OW', 'Obwalden'),
(119, 204, 'SG', 'St. Gallen'),
(120, 204, 'SH', 'Schaffhausen'),
(121, 204, 'SO', 'Solothurn'),
(122, 204, 'SZ', 'Schwyz'),
(123, 204, 'TG', 'Thurgau'),
(124, 204, 'TI', 'Tessin'),
(125, 204, 'UR', 'Uri'),
(126, 204, 'VD', 'Waadt'),
(127, 204, 'VS', 'Wallis'),
(128, 204, 'ZG', 'Zug'),
(129, 204, 'ZH', 'Zürich'),
(130, 195, 'A Coruņa', 'A Coruņa'),
(131, 195, 'Alava', 'Alava'),
(132, 195, 'Albacete', 'Albacete'),
(133, 195, 'Alicante', 'Alicante'),
(134, 195, 'Almeria', 'Almeria'),
(135, 195, 'Asturias', 'Asturias'),
(136, 195, 'Avila', 'Avila'),
(137, 195, 'Badajoz', 'Badajoz'),
(138, 195, 'Baleares', 'Baleares'),
(139, 195, 'Barcelona', 'Barcelona'),
(140, 195, 'Burgos', 'Burgos'),
(141, 195, 'Caceres', 'Caceres'),
(142, 195, 'Cadiz', 'Cadiz'),
(143, 195, 'Cantabria', 'Cantabria'),
(144, 195, 'Castellon', 'Castellon'),
(145, 195, 'Ceuta', 'Ceuta'),
(146, 195, 'Ciudad Real', 'Ciudad Real'),
(147, 195, 'Cordoba', 'Cordoba'),
(148, 195, 'Cuenca', 'Cuenca'),
(149, 195, 'Girona', 'Girona'),
(150, 195, 'Granada', 'Granada'),
(151, 195, 'Guadalajara', 'Guadalajara'),
(152, 195, 'Guipuzcoa', 'Guipuzcoa'),
(153, 195, 'Huelva', 'Huelva'),
(154, 195, 'Huesca', 'Huesca'),
(155, 195, 'Jaen', 'Jaen'),
(156, 195, 'La Rioja', 'La Rioja'),
(157, 195, 'Las Palmas', 'Las Palmas'),
(158, 195, 'Leon', 'Leon'),
(159, 195, 'Lleida', 'Lleida'),
(160, 195, 'Lugo', 'Lugo'),
(161, 195, 'Madrid', 'Madrid'),
(162, 195, 'Malaga', 'Malaga'),
(163, 195, 'Melilla', 'Melilla'),
(164, 195, 'Murcia', 'Murcia'),
(165, 195, 'Navarra', 'Navarra'),
(166, 195, 'Ourense', 'Ourense'),
(167, 195, 'Palencia', 'Palencia'),
(168, 195, 'Pontevedra', 'Pontevedra'),
(169, 195, 'Salamanca', 'Salamanca'),
(170, 195, 'Santa Cruz de Tenerife', 'Santa Cruz de Tenerife'),
(171, 195, 'Segovia', 'Segovia'),
(172, 195, 'Sevilla', 'Sevilla'),
(173, 195, 'Soria', 'Soria'),
(174, 195, 'Tarragona', 'Tarragona'),
(175, 195, 'Teruel', 'Teruel'),
(176, 195, 'Toledo', 'Toledo'),
(177, 195, 'Valencia', 'Valencia'),
(178, 195, 'Valladolid', 'Valladolid'),
(179, 195, 'Vizcaya', 'Vizcaya'),
(180, 195, 'Zamora', 'Zamora'),
(181, 195, 'Zaragoza', 'Zaragoza');
# --------------------------------------------------------

#
# Table structure for table `zones_to_geo_zones`
#

DROP TABLE IF EXISTS `zones_to_geo_zones`;
CREATE TABLE `zones_to_geo_zones` (
  `association_id` int(11) NOT NULL auto_increment,
  `zone_country_id` int(11) NOT NULL default '0',
  `zone_id` int(11) default NULL,
  `geo_zone_id` int(11) default NULL,
  `last_modified` datetime default NULL,
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`association_id`)
) TYPE=MyISAM;

#
# Dumping data for table `zones_to_geo_zones`
#

INSERT INTO `zones_to_geo_zones` VALUES (1, 223, 18, 1, NULL, '2005-07-07 10:38:23');

