Another Problem Here, Help please!

This is the entire Database code... Thanks again in advance!

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl2
-- phpMyAdmin
--
-- Host: localhost
-- Generation Time: Mar 17, 2006 at 06:25 PM
-- Server version: 4.1.14
-- PHP Version: 4.3.11
--
-- Anewshop.co.uk - anew shop Resources and Information.This website is for sale!
--

-- --------------------------------------------------------

--
-- Table structure for table `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_city` varchar(32) NOT NULL default '',
`entry_state` varchar(32) default NULL,
`entry_postcode` varchar(10) NOT NULL default '',
`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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=106 ;

--
-- Dumping data for table `address_book`
--

INSERT INTO `address_book` VALUES (105, 105, 'm', NULL, 'test', 'test', '', '', '', '', '', 222, 0);

-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `address_format`
--

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

-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `banners`
--

INSERT INTO `banners` VALUES (2, 'Rintones, Games, Logos & the UK top 40', 'http://ringtoneslogosgamesvideos.co.uk', 'tone2.gif', '468x60', '', 0, NULL, NULL, '2006-02-22 22:27:14', NULL, 1);
INSERT INTO `banners` VALUES (4, 'A New Shop', 'http://anewshop.co.uk', 'anewshopbanner.jpg', '468x60', '', NULL, NULL, NULL, '2006-02-25 12:36:39', NULL, 1);
INSERT INTO `banners` VALUES (5, 'Free Debt Advice', 'http://freedebtconsolidationadvice.co.uk', 'debtbanner.JPG', '468x60', '', 0, NULL, NULL, '2006-03-10 00:40:50', NULL, 1);
INSERT INTO `banners` VALUES (6, 'Articles Heaven', 'http://articlesheaven.co.uk', 'articleheaven.jpg', '468x60', '', 0, NULL, NULL, '2006-03-12 15:20:32', NULL, 1);

-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=73 ;

--
-- Dumping data for table `banners_history`
--

INSERT INTO `banners_history` VALUES (4, 2, 11, 1, '2006-02-22 22:27:33');
INSERT INTO `banners_history` VALUES (6, 2, 40, 1, '2006-02-25 11:13:27');
INSERT INTO `banners_history` VALUES (8, 4, 15, 1, '2006-02-25 12:36:50');
INSERT INTO `banners_history` VALUES (10, 4, 8, 2, '2006-02-26 18:11:37');
INSERT INTO `banners_history` VALUES (11, 2, 13, 0, '2006-02-26 18:11:39');
INSERT INTO `banners_history` VALUES (12, 2, 105, 0, '2006-02-27 07:46:46');
INSERT INTO `banners_history` VALUES (14, 4, 101, 1, '2006-02-27 16:59:23');
INSERT INTO `banners_history` VALUES (15, 2, 26, 0, '2006-02-28 01:25:57');
INSERT INTO `banners_history` VALUES (17, 4, 17, 0, '2006-02-28 01:26:28');
INSERT INTO `banners_history` VALUES (19, 4, 32, 0, '2006-03-01 00:01:54');
INSERT INTO `banners_history` VALUES (20, 2, 33, 0, '2006-03-01 16:55:35');
INSERT INTO `banners_history` VALUES (22, 4, 10, 0, '2006-03-02 00:01:17');
INSERT INTO `banners_history` VALUES (23, 2, 8, 0, '2006-03-02 10:04:27');
INSERT INTO `banners_history` VALUES (24, 4, 86, 2, '2006-03-03 05:15:20');
INSERT INTO `banners_history` VALUES (26, 2, 85, 0, '2006-03-03 07:30:55');
INSERT INTO `banners_history` VALUES (27, 4, 62, 0, '2006-03-04 00:06:50');
INSERT INTO `banners_history` VALUES (28, 2, 58, 1, '2006-03-04 00:06:52');
INSERT INTO `banners_history` VALUES (31, 2, 87, 1, '2006-03-05 01:53:32');
INSERT INTO `banners_history` VALUES (32, 4, 83, 3, '2006-03-05 01:53:34');
INSERT INTO `banners_history` VALUES (33, 4, 35, 0, '2006-03-06 00:04:55');
INSERT INTO `banners_history` VALUES (35, 2, 37, 0, '2006-03-06 00:21:37');
INSERT INTO `banners_history` VALUES (36, 2, 160, 2, '2006-03-07 00:13:08');
INSERT INTO `banners_history` VALUES (38, 4, 28, 1, '2006-03-07 00:28:32');
INSERT INTO `banners_history` VALUES (40, 2, 166, 0, '2006-03-08 00:42:29');
INSERT INTO `banners_history` VALUES (42, 2, 155, 1, '2006-03-09 01:13:52');
INSERT INTO `banners_history` VALUES (54, 2, 22, 0, '2006-03-13 00:53:21');
INSERT INTO `banners_history` VALUES (44, 2, 65, 1, '2006-03-10 00:18:19');
INSERT INTO `banners_history` VALUES (45, 5, 63, 2, '2006-03-10 00:41:48');
INSERT INTO `banners_history` VALUES (46, 5, 120, 2, '2006-03-11 00:01:03');
INSERT INTO `banners_history` VALUES (53, 6, 30, 2, '2006-03-13 00:01:43');
INSERT INTO `banners_history` VALUES (48, 2, 93, 0, '2006-03-11 00:01:07');
INSERT INTO `banners_history` VALUES (52, 6, 39, 2, '2006-03-12 15:21:24');
INSERT INTO `banners_history` VALUES (50, 2, 67, 0, '2006-03-12 01:41:12');
INSERT INTO `banners_history` VALUES (51, 5, 69, 3, '2006-03-12 03:28:05');
INSERT INTO `banners_history` VALUES (55, 5, 39, 0, '2006-03-13 05:15:10');
INSERT INTO `banners_history` VALUES (56, 4, 19, 0, '2006-03-13 15:11:20');
INSERT INTO `banners_history` VALUES (57, 4, 5, 0, '2006-03-14 05:57:06');
INSERT INTO `banners_history` VALUES (58, 2, 12, 0, '2006-03-14 19:48:37');
INSERT INTO `banners_history` VALUES (59, 5, 6, 0, '2006-03-14 21:14:39');
INSERT INTO `banners_history` VALUES (60, 6, 5, 0, '2006-03-14 23:08:45');
INSERT INTO `banners_history` VALUES (61, 2, 27, 0, '2006-03-15 08:28:07');
INSERT INTO `banners_history` VALUES (62, 6, 20, 0, '2006-03-15 11:05:36');
INSERT INTO `banners_history` VALUES (63, 5, 12, 0, '2006-03-15 17:01:33');
INSERT INTO `banners_history` VALUES (64, 4, 10, 0, '2006-03-15 17:20:54');
INSERT INTO `banners_history` VALUES (65, 5, 6, 0, '2006-03-16 00:39:02');
INSERT INTO `banners_history` VALUES (66, 4, 6, 0, '2006-03-16 00:39:08');
INSERT INTO `banners_history` VALUES (67, 6, 4, 0, '2006-03-16 00:39:09');
INSERT INTO `banners_history` VALUES (68, 2, 4, 0, '2006-03-16 00:39:24');
INSERT INTO `banners_history` VALUES (69, 2, 4, 0, '2006-03-17 00:07:43');
INSERT INTO `banners_history` VALUES (70, 4, 4, 0, '2006-03-17 06:16:09');
INSERT INTO `banners_history` VALUES (71, 5, 6, 0, '2006-03-17 07:10:00');
INSERT INTO `banners_history` VALUES (72, 6, 2, 0, '2006-03-17 17:59:43');

-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` VALUES (1, NULL, 25, 0, '0000-00-00 00:00:00', '2006-02-27 20:48:19');
INSERT INTO `categories` VALUES (3, NULL, 25, 0, '0000-00-00 00:00:00', '2006-02-27 20:49:47');
INSERT INTO `categories` VALUES (4, NULL, 25, 0, '0000-00-00 00:00:00', '2006-02-27 20:50:44');
INSERT INTO `categories` VALUES (5, NULL, 25, 0, '0000-00-00 00:00:00', '2006-02-27 20:50:34');
INSERT INTO `categories` VALUES (6, NULL, 25, 0, '0000-00-00 00:00:00', '2006-02-27 20:49:57');
INSERT INTO `categories` VALUES (7, NULL, 25, 0, '0000-00-00 00:00:00', '2006-02-27 20:46:59');
INSERT INTO `categories` VALUES (8, NULL, 25, 0, '0000-00-00 00:00:00', '2006-02-27 20:50:20');
INSERT INTO `categories` VALUES (9, NULL, 25, 0, '0000-00-00 00:00:00', '2006-02-27 20:48:40');
INSERT INTO `categories` VALUES (10, NULL, 25, 0, '0000-00-00 00:00:00', '2006-02-27 20:50:08');
INSERT INTO `categories` VALUES (11, NULL, 25, 0, '0000-00-00 00:00:00', '2006-02-27 20:48:31');
INSERT INTO `categories` VALUES (12, NULL, 25, 0, '0000-00-00 00:00:00', '2006-02-27 20:48:51');
INSERT INTO `categories` VALUES (13, NULL, 25, 0, '0000-00-00 00:00:00', '2006-02-27 20:47:46');
INSERT INTO `categories` VALUES (14, NULL, 25, 0, '0000-00-00 00:00:00', '2006-02-27 20:49:01');
INSERT INTO `categories` VALUES (15, NULL, 25, 0, '0000-00-00 00:00:00', '2006-02-27 20:47:56');
INSERT INTO `categories` VALUES (16, NULL, 25, 0, '0000-00-00 00:00:00', '2006-02-27 20:47:37');
INSERT INTO `categories` VALUES (17, NULL, 25, 0, '0000-00-00 00:00:00', '2006-02-27 20:49:23');
INSERT INTO `categories` VALUES (18, NULL, 25, 0, '0000-00-00 00:00:00', '2006-02-27 20:47:27');
INSERT INTO `categories` VALUES (19, NULL, 25, 0, '0000-00-00 00:00:00', '2006-02-27 20:48:05');
INSERT INTO `categories` VALUES (20, NULL, 25, 0, '0000-00-00 00:00:00', '2006-02-27 20:49:34');
INSERT INTO `categories` VALUES (23, NULL, 0, 0, '2006-02-27 17:49:54', NULL);
INSERT INTO `categories` VALUES (25, NULL, 0, 0, '2006-02-27 20:46:38', '2006-02-27 21:23:33');
INSERT INTO `categories` VALUES (29, NULL, 0, 0, '2006-02-27 22:46:58', NULL);
INSERT INTO `categories` VALUES (30, NULL, 0, 0, '2006-03-07 11:18:16', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `categories_description`
--

INSERT INTO `categories_description` VALUES (1, 1, 'Sex / Adult Interest');
INSERT INTO `categories_description` VALUES (3, 1, 'Health and Beauty');
INSERT INTO `categories_description` VALUES (4, 1, 'Gaming');
INSERT INTO `categories_description` VALUES (5, 1, 'Food and Drink');
INSERT INTO `categories_description` VALUES (6, 1, 'Business');
INSERT INTO `categories_description` VALUES (7, 1, 'Financial');
INSERT INTO `categories_description` VALUES (8, 1, 'Betting and Gambling');
INSERT INTO `categories_description` VALUES (9, 1, 'Making Money');
INSERT INTO `categories_description` VALUES (10, 1, 'Dieting Tips');
INSERT INTO `categories_description` VALUES (11, 1, 'Love and Romance');
INSERT INTO `categories_description` VALUES (12, 1, 'Sport');
INSERT INTO `categories_description` VALUES (13, 1, 'Internet');
INSERT INTO `categories_description` VALUES (14, 1, 'Web Design');
INSERT INTO `categories_description` VALUES (15, 1, 'Magic');
INSERT INTO `categories_description` VALUES (16, 1, 'Jokes');
INSERT INTO `categories_description` VALUES (17, 1, 'Psychic / Paranormal');
INSERT INTO `categories_description` VALUES (18, 1, 'Hypnosis');
INSERT INTO `categories_description` VALUES (19, 1, 'How To Guides');
INSERT INTO `categories_description` VALUES (20, 1, 'Keeping Fit');
INSERT INTO `categories_description` VALUES (23, 1, 'Websites');
INSERT INTO `categories_description` VALUES (25, 1, 'eBooks');
INSERT INTO `categories_description` VALUES (29, 1, 'Website Templates');
INSERT INTO `categories_description` VALUES (30, 1, 'Software');

-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=214 ;

--
-- Dumping data for table `configuration`
--

INSERT INTO `configuration` VALUES (1, 'Store Title', 'STORE_NAME', 'Change this to your store name', 'The name of your store which is displayed as the name of your store.', 1, 1, '2006-03-13 15:47:13', '2005-01-11 16:56:10', NULL, NULL);
INSERT INTO `configuration` VALUES (2, 'Store Name', 'STORE_OWNER', 'Change this to your store name', 'The name of your store again, that displays on various places on your store.', 1, 2, '2006-03-13 15:47:54', '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (3, 'Email Address', 'STORE_OWNER_EMAIL_ADDRESS', 'youremailaddy', 'The main contact email address of your store.', 1, 3, '2006-03-13 15:39:33', '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (4, 'Email From', 'EMAIL_FROM', 'youremailaddy', 'The email address of your store used in (sent) e-mails. Should be the same as the email address above and My EBOOK Store should be replaced with your Store name', 1, 4, '2006-03-13 15:39:44', '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (5, 'Country', 'STORE_COUNTRY', '222', 'The country your store is located in.', 1, 40, '2005-01-11 17:06:44', '2005-01-11 16:56:11', 'tep_get_country_name', 'tep_cfg_pull_down_country_list(');
INSERT INTO `configuration` VALUES (6, 'Zone (Please do not touch this configuration)', 'STORE_ZONE', '332', 'Please do not touch this configuration', 999, 1112, '2005-01-13 16:40:12', '2005-01-11 16:56:11', 'tep_cfg_get_zone_name', 'tep_cfg_pull_down_zone_list(');
INSERT INTO `configuration` VALUES (7, 'Expected Sort Order', 'EXPECTED_PRODUCTS_SORT', 'desc', 'This is the sort order used in the expected products box.', 999, 1111, NULL, '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''asc'', ''desc''),');
INSERT INTO `configuration` VALUES (8, 'Expected Sort Field', 'EXPECTED_PRODUCTS_FIELD', 'date_expected', 'The column to sort by in the expected products box.', 999, 9, NULL, '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''products_name'', ''date_expected''),');
INSERT INTO `configuration` VALUES (9, 'Switch To Default Language Currency', 'USE_DEFAULT_LANGUAGE_CURRENCY', 'false', 'Automatically switch to the languages currency when it is changed', 999, 10, '2005-07-01 15:14:56', '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (10, 'Send Copies of Order Emails To', 'SEND_EXTRA_ORDER_EMAILS_TO', 'youremailaddy', 'Send copies of order emails to your email addresses. You will then receive a duplicate of the email order receipt that your customer gets.', 1, 11, '2006-03-13 15:39:58', '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (11, 'Safe URLs (not available)', 'SEARCH_ENGINE_FRIENDLY_URLS', 'false', 'Please do not touch', 999, 12, NULL, '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (12, 'Display Cart After Adding Product', 'DISPLAY_CART', 'true', 'Display the shopping cart after adding a product (or return back to their origin)', 999, 14, NULL, '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (13, 'Tell A Friend (Not available)', 'ALLOW_GUEST_TO_TELL_A_FRIEND', 'false', 'This feature is not available. Do not touch this.', 999, 15, NULL, '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (14, 'Default Search Operator', 'ADVANCED_SEARCH_DEFAULT_OPERATOR', 'and', 'Default search operators', 999, 17, NULL, '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''and'', ''or''),');
INSERT INTO `configuration` VALUES (15, 'Store Address and Phone', 'STORE_NAME_ADDRESS', 'Store Name\r\nAddress\r\nCountry\r\nPhone', 'This is the Store Name, Address and Phone used on printable invoices.', 9999, 18, NULL, '2005-01-11 16:56:11', NULL, 'tep_cfg_textarea(');
INSERT INTO `configuration` VALUES (16, 'Show Category Counts', 'SHOW_COUNTS', 'false', 'Count recursively how many products are in each category', 999, 19, '2005-05-07 07:56:55', '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (17, 'Tax Decimal Places', 'TAX_DECIMAL_PLACES', '0', 'Pad the tax value this amount of decimal places', 999, 20, '2005-05-07 23:14:46', '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (18, 'Display Prices with Tax', 'DISPLAY_PRICE_WITH_TAX', 'false', 'If you do NOT charge vat or tax, IGNORE this. Display prices with tax included in the shown product price (true) or add the tax at the end of the checkout process. (false) This feature will ONLY work for store owners who charge vat or sales tax.', 1, 45, '2005-05-07 21:27:14', '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (19, 'First Name', 'ENTRY_FIRST_NAME_MIN_LENGTH', '2', 'Minimum length of first name', 2, 1, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (20, 'Last Name', 'ENTRY_LAST_NAME_MIN_LENGTH', '2', 'Minimum length of last name', 2, 2, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (21, 'Date of Birth', 'ENTRY_DOB_MIN_LENGTH', '0', 'Minimum length of date of birth', 2, 3, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (22, 'E-Mail Address', 'ENTRY_EMAIL_ADDRESS_MIN_LENGTH', '6', 'Minimum length of e-mail address', 2, 4, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (23, 'Street Address', 'ENTRY_STREET_ADDRESS_MIN_LENGTH', '0', 'Minimum length of street address', 2, 5, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (24, 'Company', 'ENTRY_COMPANY_MIN_LENGTH', '0', 'Minimum length of company name', 2, 6, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (25, 'Post Code', 'ENTRY_POSTCODE_MIN_LENGTH', '0', 'Minimum length of post code', 2, 7, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (26, 'City', 'ENTRY_CITY_MIN_LENGTH', '0', 'Minimum length of city', 2, 8, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (27, 'County', 'ENTRY_STATE_MIN_LENGTH', '0', 'Minimum length of county', 2, 9, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (28, 'Telephone Number', 'ENTRY_TELEPHONE_MIN_LENGTH', '0', 'Minimum length of telephone number', 2, 10, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (29, 'Password', 'ENTRY_PASSWORD_MIN_LENGTH', '3', 'Minimum length of password', 2, 11, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (30, 'Credit Card Owner Name', 'CC_OWNER_MIN_LENGTH', '3', 'Minimum length of credit card owner name', 2, 12, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (31, 'Credit Card Number', 'CC_NUMBER_MIN_LENGTH', '10', 'Minimum length of credit card number', 2, 13, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (32, 'Review Text', 'REVIEW_TEXT_MIN_LENGTH', '50', 'Minimum length of review text', 2, 14, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (33, 'Best Sellers', 'MIN_DISPLAY_BESTSELLERS', '1', 'Minimum number of best sellers to display', 2, 15, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (34, 'Also Purchased', 'MIN_DISPLAY_ALSO_PURCHASED', '1', 'Minimum number of products to display in the ''This Customer Also Purchased'' box', 2, 16, '2005-05-08 09:24:40', '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (35, 'Address Book Entries', 'MAX_ADDRESS_BOOK_ENTRIES', '1', 'Maximum address book entries a customer is allowed to have', 777, 1, '2005-09-06 04:49:55', '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (36, 'Number of Products to List Per Page', 'MAX_DISPLAY_SEARCH_RESULTS', '20', 'Amount of products to list in categories and search results per page', 3, 2, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (37, 'Page Links', 'MAX_DISPLAY_PAGE_LINKS', '5', 'Number of ''number'' links use for page-sets', 9999, 3, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (38, 'No. of Special Offers per Page', 'MAX_DISPLAY_SPECIAL_PRODUCTS', '10', 'Maximum number of special offers to display per page in the Special Offers section', 3, 4, '2005-06-16 18:41:37', '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (39, 'New Products Box', 'MAX_DISPLAY_NEW_PRODUCTS', '3', 'Maximum number of new products to display on the front page.', 3, 5, '2005-06-16 18:39:46', '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (40, 'Products Expected', 'MAX_DISPLAY_UPCOMING_PRODUCTS', '10', 'Maximum number of products expected to display', 999, 6, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (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', 999, 7, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (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.', 999, 7, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (43, 'Length of Manufacturers Name', 'MAX_DISPLAY_MANUFACTURER_NAME_LEN', '15', 'Used in manufacturers box; maximum length of manufacturers name to display', 999, 8, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (44, 'New Reviews', 'MAX_DISPLAY_NEW_REVIEWS', '6', 'Maximum number of new reviews to display', 999, 9, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (45, 'Selection of Random Reviews', 'MAX_RANDOM_SELECT_REVIEWS', '', 'How many records to select from to choose one random product review', 999, 10, '2005-07-01 17:35:38', '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (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', 999, 11, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (47, 'Selection of Products on Special', 'MAX_RANDOM_SELECT_SPECIALS', '9', 'How many records to select from to choose one random product special to display', 999, 12, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (48, 'Categories To List Per Row', 'MAX_DISPLAY_CATEGORIES_PER_ROW', '3', 'How many categories to list per row', 9999, 13, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (49, 'No. of New Products to List per Page', 'MAX_DISPLAY_PRODUCTS_NEW', '10', 'Maximum number of new products to display per page in the New Products page', 3, 14, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (50, 'Best Sellers', 'MAX_DISPLAY_BESTSELLERS', '10', 'Maximum number of best sellers to display', 999, 15, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (51, 'Maximum Associated Products', 'MAX_DISPLAY_ALSO_PURCHASED', '6', 'Maximum number of products to display in the Associated Products box', 9999, 16, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (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', 999, 17, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (53, 'Order History', 'MAX_DISPLAY_ORDER_HISTORY', '10', 'Maximum number of orders to display in the order history page', 999, 18, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (54, 'Thumbnail Product Image Width', 'SMALL_IMAGE_WIDTH', '80', 'The pixel width of small product images that appear on front page and categories. If your thumbnail images distort, try playing around with this configuration. (Max. 100px)', 1, 30, '2005-09-05 02:29:30', '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (55, 'Thumbnail Product Image Height', 'SMALL_IMAGE_HEIGHT', '100', 'The pixel height of small product images that appear on front page and categories. If your thumbnail images distort, try playing around with this configuration. (Max. 100px)', 1, 31, '2005-09-05 02:29:39', '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (56, 'Heading Image Width', 'HEADING_IMAGE_WIDTH', '57', 'The pixel width of heading images', 4, 3, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (57, 'Heading Image Height', 'HEADING_IMAGE_HEIGHT', '40', 'The pixel height of heading images', 4, 4, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (58, 'Subcategory Image Width', 'SUBCATEGORY_IMAGE_WIDTH', '100', 'The pixel width of subcategory images', 4, 5, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (59, 'Subcategory Image Height', 'SUBCATEGORY_IMAGE_HEIGHT', '57', 'The pixel height of subcategory images', 4, 6, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (60, 'Calculate Image Size', 'CONFIG_CALCULATE_IMAGE_SIZE', 'true', 'Calculate the size of images?', 4, 7, NULL, '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (61, 'Image Required', 'IMAGE_REQUIRED', 'true', 'Enable to display broken images. Good for development.', 4, 8, NULL, '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (62, 'Gender', 'ACCOUNT_GENDER', 'true', 'Ask for gender in the customer sign-up page', 5, 1, NULL, '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (63, 'Date of Birth', 'ACCOUNT_DOB', 'false', 'Ask for date of birth in the customer sign-up page', 5, 2, '2005-05-07 05:13:17', '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (64, 'Company', 'ACCOUNT_COMPANY', 'false', 'Ask for Company in the customer sign-up page', 5, 3, '2005-06-05 21:08:35', '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (65, 'Address Line 2', 'ACCOUNT_SUBURB', 'true', 'Do not touch this', 999, 4, NULL, '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (66, 'County', 'ACCOUNT_STATE', 'true', 'Display county in the customers account', 999, 5, NULL, '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (67, 'Installed Modules', 'MODULE_PAYMENT_INSTALLED', '', '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, '2006-03-13 14:46:58', '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (68, 'Installed Modules', 'MODULE_ORDER_TOTAL_INSTALLED', 'ot_subtotal.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_tota l.php)', 6, 0, '2005-09-05 22:30:34', '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (69, 'Installed Modules', 'MODULE_SHIPPING_INSTALLED', '', 'List of shipping module filenames separated by a semi-colon. This is automatically updated. No need to edit.', 6, 0, '2005-07-01 11:49:22', '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (73, 'Make Payable to:', 'Make Payable to:', 'My Name', 'Who should payments be made payable to? <font color=#ff0033>NOTE: To set your payment address, click on Configuration, Store Details, Store Name And Address.</font>', 6, 1, NULL, '2005-06-30 20:22:22', NULL, NULL);
INSERT INTO `configuration` VALUES (76, 'Default Currency', 'DEFAULT_CURRENCY', 'GBP', 'Select your Default Currency. Can be GBP USD EUR AUD or CAD. If you change currency remember to go to My Catalogue, then Update Currencies to update exchange rate', 1, 41, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (77, 'Default Language', 'DEFAULT_LANGUAGE', 'en', 'Default Language', 6, 0, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (78, '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-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (147, 'Handling Fee', 'MODULE_SHIPPING_TABLE_HANDLING', '0', 'Handling fee for this delivery method. (optional)', 6, 0, NULL, '2005-06-30 21:05:19', NULL, NULL);
INSERT INTO `configuration` VALUES (148, 'Tax Class', 'MODULE_SHIPPING_TABLE_TAX_CLASS', '0', 'Select this ONLY if you charge tax.', 6, 0, NULL, '2005-06-30 21:05:19', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(');
INSERT INTO `configuration` VALUES (146, 'Table Method', 'MODULE_SHIPPING_TABLE_MODE', 'price', 'The delivery cost is based on the order total price or the total weight of the items ordered. If you select weight, you will have to add the weight to each product you stock. PRICE is the default method.', 6, 0, NULL, '2005-06-30 21:05:19', NULL, 'tep_cfg_select_option(array(''weight'', ''price''),');
INSERT INTO `configuration` VALUES (145, 'Delivery Rates', 'MODULE_SHIPPING_TABLE_COST', '', 'Add your table of delivery rates in the example format. Example: 25:2.50,50:5.00. This would make it: Up to 25 charge 2.50, from 26 to 50 charge 5.00.', 6, 0, NULL, '2005-06-30 21:05:19', NULL, NULL);
INSERT INTO `configuration` VALUES (84, 'Display Sub-Total', 'MODULE_ORDER_TOTAL_SUBTOTAL_STATUS', 'true', 'Do you want to display the order sub-total cost in the customers checkout screen? False for no and true for yes.', 6, 1, NULL, '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (85, 'Sort Order', 'MODULE_ORDER_TOTAL_SUBTOTAL_SORT_ORDER', '1', 'Sort order of display.', 6, 2, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (86, 'Sort Order', 'MODULE_ORDER_TOTAL_TAX_SORT_ORDER', '', 'Sort order of display.', 6, 2, NULL, '2005-06-30 20:06:44', NULL, NULL);
INSERT INTO `configuration` VALUES (87, 'Display Tax', 'MODULE_ORDER_TOTAL_TAX_STATUS', 'false', 'Do you want to display the order tax value in the customers checkout screen? False for no and true for yes.', 6, 1, NULL, '2005-06-30 20:06:44', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (191, 'Sort Order', 'MODULE_ORDER_TOTAL_TOTAL_SORT_ORDER', '2', 'Sort order of display.', 6, 2, NULL, '2005-09-05 22:30:25', NULL, NULL);
INSERT INTO `configuration` VALUES (190, 'Display Total', 'MODULE_ORDER_TOTAL_TOTAL_STATUS', 'true', 'Do you want to display the total order value in the customers checkout screen? False for no and true for yes.', 6, 1, NULL, '2005-09-05 22:30:25', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (90, 'Country of Origin', 'SHIPPING_ORIGIN_COUNTRY', '222', 'Select the country of origin to be used in shipping quotes.', 7, 1, '2005-05-08 09:25:52', '2005-01-11 16:56:11', 'tep_get_country_name', 'tep_cfg_pull_down_country_list(');
INSERT INTO `configuration` VALUES (91, 'Postal Code', 'SHIPPING_ORIGIN_ZIP', 'NONE', 'Enter the Postal Code (ZIP) of the Store to be used in shipping quotes.', 999, 2, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (100, 'Enter the Maximum Package Weight you will ship (kg)', '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-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (101, 'Package Tare weight.', 'SHIPPING_BOX_WEIGHT', '3', 'What is the weight of typical packaging of small to medium packages?', 7, 4, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (102, 'Larger packages - percentage increase.', 'SHIPPING_BOX_PADDING', '10', 'For 10% enter 10', 7, 5, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (103, 'Display Product Image', 'PRODUCT_LIST_IMAGE', '1', 'Do you want to display the Product Image? Put 0 to hide this from view. Put a number from 1 upward, depending on the order you want it to display. i.e. 1 = first column, 2 = second, etc.', 8, 1, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (104, 'Display Product Manufaturer Name', 'PRODUCT_LIST_MANUFACTURER', '0', 'Do you want to display the Product Manufacturer Name?', 999, 2, '2005-06-18 17:42:26', '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (105, 'Display Product Model', 'PRODUCT_LIST_MODEL', '0', 'Do you want to display the Product Model? Put 0 to hide this from view. Put a number from 1 upward, depending on the order you want it to display. i.e. 1 = first column, 2 = second, etc.', 8, 3, '2005-06-18 17:42:19', '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (106, 'Display Product Name', 'PRODUCT_LIST_NAME', '2', 'Do you want to display the Product Name? Put 0 to hide this from view. Put a number from 1 upward, depending on the order you want it to display. i.e. 1 = first column, 2 = second, etc.', 8, 4, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (107, 'Display Product Price', 'PRODUCT_LIST_PRICE', '3', 'Do you want to display the Product Price? Put 0 to hide this from view. Put a number from 1 upward, depending on the order you want it to display. i.e. 1 = first column, 2 = second, etc.', 8, 5, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (108, 'Display Your Stock Count', 'PRODUCT_LIST_QUANTITY', '0', 'Do you want to display how many of each product your have in stock? Put 0 to hide this from view. Put a number from 1 upward, depending on the order you want it to display. i.e. 1 = first column, 2 = second, etc.', 8, 8, '2005-06-18 17:42:05', '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (109, 'Display Product Weight', 'PRODUCT_LIST_WEIGHT', '0', 'Do you want to display the Product Weight?', 8, 7, '2005-06-18 17:42:11', '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (110, 'Display Buy Now column', 'PRODUCT_LIST_BUY_NOW', '4', 'Do you want to display the Buy Now column? Put 0 to hide this from view. Put a number from 1 upward, depending on the order you want it to display. i.e. 1 = first column, 2 = second, etc.', 8, 6, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (111, 'Display Category/Manufacturer Filter (0=disable; 1=enable)', 'PRODUCT_LIST_FILTER', '1', 'Do you want to display the Category/Manufacturer Filter?', 999, 9, '2005-06-30 22:17:05', '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (112, 'Location of Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)', 'PREV_NEXT_BAR_LOCATION', '3', 'Sets the location of the Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)', 999, 10, '2005-05-08 09:27:01', '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (113, 'Check stock level', 'STOCK_CHECK', 'true', 'Check to see if sufficent stock is available', 9, 1, NULL, '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (114, 'Subtract stock', 'STOCK_LIMITED', 'true', 'Subtract product in stock by product orders', 9, 2, NULL, '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (115, 'Allow Checkout', 'STOCK_ALLOW_CHECKOUT', 'true', 'Allow customer to checkout even if there is insufficient stock', 9, 3, NULL, '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (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-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (117, 'Stock Re-order level', 'STOCK_REORDER_LEVEL', '1', 'Define when stock needs to be re-ordered', 9, 5, '2005-07-01 11:48:20', '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (118, 'Store Page Parse Time', 'STORE_PAGE_PARSE_TIME', 'false', 'Store the time it takes to parse a page', 10, 1, NULL, '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (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-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (120, 'Log Date Format', 'STORE_PARSE_DATE_TIME_FORMAT', '%d/%m/%Y %H:%M:%S', 'The date format', 10, 3, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (121, 'Display The Page Parse Time', 'DISPLAY_PAGE_PARSE_TIME', 'false', 'Display the page parse time (store page parse time must be enabled)', 10, 4, '2005-06-30 21:37:00', '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (122, 'Store Database Queries', 'STORE_DB_TRANSACTIONS', 'false', 'Store the database queries in the page parse time log (PHP4 only)', 10, 5, NULL, '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (123, 'Use Cache', 'USE_CACHE', 'false', 'Use caching features', 11, 1, NULL, '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (124, 'Cache Directory', 'DIR_FS_CACHE', '/tmp/', 'The directory where the cached files are saved', 11, 2, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (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-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''sendmail'', ''smtp''),');
INSERT INTO `configuration` VALUES (126, 'E-Mail Linefeeds', 'EMAIL_LINEFEED', 'LF', 'Defines the character sequence used to separate mail headers.', 12, 2, NULL, '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''LF'', ''CRLF''),');
INSERT INTO `configuration` VALUES (127, 'Use MIME HTML When Sending Emails', 'EMAIL_USE_HTML', 'true', 'Send e-mails in HTML format', 12, 3, NULL, '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (128, 'Verify E-Mail Addresses Through DNS', 'ENTRY_EMAIL_ADDRESS_CHECK', 'false', 'Verify e-mail address through a DNS server', 12, 4, NULL, '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (129, 'Send E-Mails', 'SEND_EMAILS', 'true', 'Send out e-mails', 12, 5, NULL, '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (130, 'Enable download', 'DOWNLOAD_ENABLED', 'true', 'Enable the products download functions.', 13, 1, '2005-06-19 22:14:26', '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (131, 'Download by redirect', 'DOWNLOAD_BY_REDIRECT', 'true', 'Use browser redirection for download. Disable on non-Unix systems.', 13, 2, '2005-09-04 21:28:51', '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (132, 'Expiry delay (days)', 'DOWNLOAD_MAX_DAYS', '7', 'Set number of days before the download link expires. 0 means no limit.', 13, 3, '2005-09-04 21:28:46', '2005-01-11 16:56:11', NULL, '');
INSERT INTO `configuration` VALUES (133, 'Maximum number of downloads', 'DOWNLOAD_MAX_COUNT', '1', 'Set the maximum number of downloads. 0 means no download authorized.', 13, 4, '2005-09-04 23:22:33', '2005-01-11 16:56:11', NULL, '');
INSERT INTO `configuration` VALUES (134, 'Enable GZip Compression', 'GZIP_COMPRESSION', 'true', 'Enable HTTP GZip compression.', 14, 1, '2005-06-30 21:18:27', '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (135, 'Compression Level', 'GZIP_LEVEL', '8', 'Use this compression level 0-9 (0 = minimum, 9 = maximum).', 14, 2, '2005-05-07 09:13:06', '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (136, 'Session Directory', 'SESSION_WRITE_DIRECTORY', '/tmp', 'If sessions are file based, store them in this directory.', 15, 1, NULL, '2005-01-11 16:56:11', NULL, NULL);
INSERT INTO `configuration` VALUES (137, 'Force Cookie Use', 'SESSION_FORCE_COOKIE_USE', 'False', 'Force the use of sessions when cookies are only enabled.', 15, 2, NULL, '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''True'', ''False''),');
INSERT INTO `configuration` VALUES (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-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''True'', ''False''),');
INSERT INTO `configuration` VALUES (139, 'Check User Agent', 'SESSION_CHECK_USER_AGENT', 'False', 'Validate the clients browser user agent on every page request.', 15, 4, NULL, '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''True'', ''False''),');
INSERT INTO `configuration` VALUES (140, 'Check IP Address', 'SESSION_CHECK_IP_ADDRESS', 'False', 'Validate the clients IP address on every page request.', 15, 5, NULL, '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''True'', ''False''),');
INSERT INTO `configuration` VALUES (141, 'Prevent Spider Sessions', 'SESSION_BLOCK_SPIDERS', 'True', 'Prevent known spiders from starting a session.', 15, 6, '2005-06-30 21:37:26', '2005-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''True'', ''False''),');
INSERT INTO `configuration` VALUES (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-01-11 16:56:11', NULL, 'tep_cfg_select_option(array(''True'', ''False''),');
INSERT INTO `configuration` VALUES (151, 'Recommended Box', 'THUMB_BOX_PRODUCTS_DISPLAY', 'true', 'Enable the Recommended Box', 30, 1, '2003-03-09 18:10:10', '2003-03-09 18:10:10', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (152, 'Recommended Box - Number of Rows', 'THUMB_BOX_NUM_ROWS', '1', 'Set the number of rows you would like.', 30, 2, '2005-09-05 02:01:33', '2003-03-09 18:10:10', NULL, '');
INSERT INTO `configuration` VALUES (153, 'Recommended Box - Number of Columns', 'THUMB_BOX_NUM_COLS', '1', 'Set the number of columns you would like.', 30, 3, '2005-06-17 22:12:50', '2003-03-09 18:10:10', NULL, '');
INSERT INTO `configuration` VALUES (154, 'Recommended Box - Minimum Price (query parameter)', 'THUMB_BOX_MIN_PRICE', '0', 'Set to 0 for no minimum price.', 30, 4, '2005-06-16 03:26:24', '2003-03-09 18:10:10', NULL, '');
INSERT INTO `configuration` VALUES (155, 'Recommended Box - Maximum Price (query parameter)', 'THUMB_BOX_MAX_PRICE', '99999', 'Set the maximum price value of thumbnailed products.', 30, 5, '2003-03-09 18:10:10', '2003-03-09 18:10:10', NULL, '');
INSERT INTO `configuration` VALUES (156, 'Recommended Box - Scale Value for Thumbnails', 'THUMB_BOX_SCALE', '1', 'This is a multiplier which will set the size of the picture. It will "scale" the normal small image size.', 30, 6, '2005-06-16 03:27:25', '2003-03-09 18:10:10', NULL, '');
INSERT INTO `configuration` VALUES (157, 'Recommended Box - Behavior of Pictures/Name/Price', 'THUMB_BOX_PICTURES_ONLY', '0', 'Set one of these options: <br>0=display picture/name/price<br>1=(pic reqd) display picture/name/price<br>2=(pic reqd) display picture/price<br>3=(pic reqd) display picture', 30, 7, '2005-06-16 03:27:14', '2003-03-09 18:10:10', NULL, 'tep_cfg_select_option(array(''0'', ''1'',''2'',''3''),');
INSERT INTO `configuration` VALUES (158, 'Featured Products', 'THUMBADS_PRODUCTS_DISPLAY', 'true', 'This will enable or disable the use of the Featured Products Box on the front page.', 30, 8, '2003-03-09 18:10:10', '2003-03-09 18:10:10', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (159, 'Featured Products - Number of Rows', 'THUMBADS_NUM_ROWS', '2', 'Set the number of rows you would like.', 30, 9, '2005-09-05 20:50:45', '2003-03-09 18:10:10', NULL, '');
INSERT INTO `configuration` VALUES (160, 'Featured Products - Number of Columns', 'THUMBADS_NUM_COLS', '3', 'Set the number of columns you would like.', 30, 10, '2003-03-09 18:10:10', '2003-03-09 18:10:10', NULL, '');
INSERT INTO `configuration` VALUES (161, 'Featured Products - Minimum Price (query parameter)', 'THUMBADS_MIN_PRICE', '0', 'Set to 0 for no minimum price.', 30, 11, '2005-06-04 21:35:02', '2003-03-09 18:10:10', NULL, '');
INSERT INTO `configuration` VALUES (162, 'Featured Products - Maximum Price (query parameter)', 'THUMBADS_MAX_PRICE', '99999', 'Set the maximum price value of thumbnailed products.', 30, 12, '2003-03-09 18:10:10', '2003-03-09 18:10:10', NULL, '');
INSERT INTO `configuration` VALUES (163, 'Featured Products - Scale Value for Thumbnails', 'THUMBADS_SCALE', '1', 'This is a multiplier which will set the size of the picture. It will "scale" the normal small image size.', 30, 13, '2003-03-09 18:10:10', '2003-03-09 18:10:10', NULL, '');
INSERT INTO `configuration` VALUES (164, 'Featured Products - Behavior of Pictures/Name/Price', 'THUMBADS_PICTURES_ONLY', '1', 'Set one of these options: <br>0=display picture/name/price<br>1=(pic reqd) display picture/name/price<br>2=(pic reqd) display picture/price<br>3=(pic reqd) display picture', 30, 14, '2003-03-09 18:10:10', '2003-03-09 18:10:10', NULL, 'tep_cfg_select_option(array(''0'', ''1'',''2'',''3''),');
INSERT INTO `configuration` VALUES (165, 'Display Product Info', 'PRODUCT_LIST_INFO', '3', 'Set to 0 to disable, set to 1-99 to enable.', 8, 11, '2005-07-14 22:09:36', '2005-07-14 21:20:50', NULL, NULL);
INSERT INTO `configuration` VALUES (166, 'Link Contact Name Minimum Length', 'ENTRY_LINKS_CONTACT_NAME_MIN_LENGTH', '2', 'Minimum length of link contact name.', 9999, 13, NULL, '2005-07-16 20:05:51', NULL, NULL);
INSERT INTO `configuration` VALUES (167, 'Link Description Minimum Length', 'ENTRY_LINKS_DESCRIPTION_MIN_LENGTH', '10', 'Minimum length of link description.', 9999, 12, NULL, '2005-07-16 20:05:51', NULL, NULL);
INSERT INTO `configuration` VALUES (168, 'Link URL Minimum Length', 'ENTRY_LINKS_URL_MIN_LENGTH', '10', 'Minimum length of link URL.', 9999, 11, NULL, '2005-07-16 20:05:51', NULL, NULL);
INSERT INTO `configuration` VALUES (169, 'Link Title Minimum Length', 'ENTRY_LINKS_TITLE_MIN_LENGTH', '2', 'Minimum length of link title.', 9999, 10, NULL, '2005-07-16 20:05:51', NULL, NULL);
INSERT INTO `configuration` VALUES (170, 'Display Link Click Count', 'LINK_LIST_COUNT', '0', 'Do you want to display the Link Click Count?', 9999, 9, '2005-07-16 20:19:10', '2005-07-16 20:05:51', NULL, NULL);
INSERT INTO `configuration` VALUES (171, 'Display Link Description', 'LINK_LIST_DESCRIPTION', '2', 'Do you want to display the Link Description?', 9999, 8, '2005-07-16 20:49:18', '2005-07-16 20:05:51', NULL, NULL);
INSERT INTO `configuration` VALUES (172, 'Links Check URL', 'LINKS_CHECK_PHRASE', 'Change this to your domainname', 'Enter your domain name here. The link check system will check to see if websites that exchange links with you are displaying your website.', 31, 14, '2006-03-16 19:37:59', '2005-07-16 20:05:51', NULL, NULL);
INSERT INTO `configuration` VALUES (173, 'Maximum Links to Display', 'MAX_LINKS_DISPLAY', '20', 'How many links should be displayed per page?', 31, 15, NULL, '2005-07-16 20:05:51', NULL, NULL);
INSERT INTO `configuration` VALUES (174, 'Display Link Title', 'LINK_LIST_TITLE', '1', 'Do you want to display the Link Title?', 9999, 7, '2005-07-16 20:49:11', '2005-07-16 20:05:51', NULL, NULL);
INSERT INTO `configuration` VALUES (175, 'Display Link Image', 'LINK_LIST_IMAGE', '0', 'Do you want to display the Link Image?', 9999, 5, '2005-07-16 20:18:44', '2005-07-16 20:05:51', NULL, NULL);
INSERT INTO `configuration` VALUES (176, 'Display Link URL', 'LINK_LIST_URL', '0', 'Do you want to display the Link URL?', 9999, 6, '2005-07-16 20:49:02', '2005-07-16 20:05:51', NULL, NULL);
INSERT INTO `configuration` VALUES (177, 'Links Image Height', 'LINKS_IMAGE_HEIGHT', '60', 'Maximum height of the links image.', 9999, 4, NULL, '2005-07-16 20:05:51', NULL, NULL);
INSERT INTO `configuration` VALUES (178, 'Links Image Width', 'LINKS_IMAGE_WIDTH', '120', 'Maximum width of the links image.', 9999, 3, NULL, '2005-07-16 20:05:51', NULL, NULL);
INSERT INTO `configuration` VALUES (179, 'Click Count', 'ENABLE_LINKS_COUNT', 'False', 'Enable links click count.', 9999, 0, '2005-08-31 22:35:52', '2005-07-16 20:05:51', NULL, 'tep_cfg_select_option(array(''True'', ''False''),');
INSERT INTO `configuration` VALUES (180, 'Spider Friendly Links', 'ENABLE_SPIDER_FRIENDLY_LINKS', 'True', 'Enable spider friendly links (recommended).', 9999, 2, NULL, '2005-07-16 20:05:51', NULL, 'tep_cfg_select_option(array(''True'', ''False''),');
INSERT INTO `configuration` VALUES (149, 'Delivery Zone', 'MODULE_SHIPPING_TABLE_ZONE', '0', 'ONLY select this if you will only deliver to the EU.', 6, 0, NULL, '2005-06-30 21:05:19', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(');
INSERT INTO `configuration` VALUES (150, 'Sort Order', 'MODULE_SHIPPING_TABLE_SORT_ORDER', '1', 'Sort the order in which you want these delivery methods to appear in your store. i.e. 1, 2, 3, etc', 6, 0, NULL, '2005-06-30 21:05:19', NULL, NULL);
INSERT INTO `configuration` VALUES (193, 'Store Descripton', 'META_DESCRIPTION', 'add a description here for the search engines', 'A brief description of your store that will be indexed by search engines. 100 characters max including spaces.', 32, 1, '2006-03-16 19:38:29', '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO `configuration` VALUES (194, 'Meta Tag Keywords', 'META_KEYWORDS', 'add some keywords here for the search engines', 'Keywords and phrases, separated by commas, to do with your store, that will be indexed by search engines. 255 characters max including spaces.', 32, 2, '2006-03-16 19:38:44', '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO `configuration` VALUES (195, 'Featured eBooks', 'FEATURED', 'Featured Products', 'Change the text displayed in your store.', 33, 1, '2006-03-09 19:39:39', '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO `configuration` VALUES (196, 'New eBooks', 'NEW_PRODUCTS', 'New Products', 'Change the text displayed in your store.', 33, 2, '2006-02-27 20:28:26', '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO `configuration` VALUES (197, 'More eBooks', 'MORE_PRODUCTS', 'Quick Links', 'Change the text displayed in your store.', 33, 3, '2006-02-27 23:41:15', '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO `configuration` VALUES (198, 'Bargains', 'OFFERS', 'Bargains', 'Change the text displayed in your store.', 33, 4, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO `configuration` VALUES (199, 'All eBooks', 'ALL', 'All Products', 'Change the text displayed in your store.', 33, 5, '2006-02-27 23:41:43', '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO `configuration` VALUES (200, 'How To Buy', 'HOWTOBUY', 'How To Buy', 'Change the text displayed in your store.', 33, 6, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO `configuration` VALUES (201, 'Shopping Basket', 'BASKET', 'Shopping Basket', 'Change the text displayed in your store.', 33, 7, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO `configuration` VALUES (202, 'There are no products in your basket', 'EMPTY_TEXT', 'There are no products in your basket', 'Change the text displayed in your store.', 33, 8, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO `configuration` VALUES (203, 'Choose Currency', 'CHOOSE_CURRENCY', 'Choose Currency', 'Change the text displayed in your store.', 33, 9, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO `configuration` VALUES (204, 'View Basket', 'VIEW_BASKET', 'View Basket', 'Change the text displayed in your store.', 33, 10, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO `configuration` VALUES (205, 'Recommended', 'RECOMMENDED', 'Recommended', 'Change the text displayed in your store.', 33, 11, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO `configuration` VALUES (206, 'details', 'INFO', 'details', 'Change the text displayed in your store.', 33, 12, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO `configuration` VALUES (207, 'buy now', 'BUYNOW', 'buy now', 'Change the text displayed in your store.', 33, 13, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO `configuration` VALUES (208, 'Product Description', 'ITEM_DESCRIPTION', 'Product Description', 'Change the text displayed in your store.', 33, 14, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO `configuration` VALUES (209, 'Customers who bought this product also purchased', 'TEXT_ALSO', 'Customers who bought this product also purchased', 'Change the text displayed in your store.', 33, 15, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO `configuration` VALUES (210, 'Change Text of the Customer Registration Email', 'TEXT_CUSTOMER_REGISTRATION', 'Your account has been created. You can now log in and purchase goods from our store.', 'Change Text of the Customer Registration Email that the users receive when they register at your store. TEXT ONLY!', 33, 16, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO `configuration` VALUES (211, 'Store Slogan', 'STORE_SLOGAN', 'Your Store Slogan Goes Here.....', 'Enter your BRIEF store slogan here. This will dislay under your store title, in the title bar of the users browser and on various other places.', 1, 34, '2006-03-13 15:47:37', '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO `configuration` VALUES (212, 'Google Adsense ID', 'ADSENSE', 'pub-7008704035590196', 'Enter your Google Adsense ID so that you can earn revenue with their Adsense Programme.', 34, 1, '2006-02-22 20:59:19', '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO `configuration` VALUES (213, 'Adsense Box Header Title', 'ADVERTS', 'Google Ads', 'Change the title text of the adsense box.', 34, 2, '2006-02-28 18:42:04', '0000-00-00 00:00:00', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;

--
-- Dumping data for table `configuration_group`
--

INSERT INTO `configuration_group` VALUES (1, 'Store Details', 'General information about your store', 1, 1);
INSERT INTO `configuration_group` VALUES (2, 'Minimum Values', 'The minimum values for functions / data', 4, 0);
INSERT INTO `configuration_group` VALUES (3, 'Maximum Options', 'The maximum values for store functions', 3, 1);
INSERT INTO `configuration_group` VALUES (4, 'Image Sizes', 'Sets the width and height of thumbnailed product images.', 2, 0);
INSERT INTO `configuration_group` VALUES (5, 'Customer Options', 'Customer account configuration', 5, 0);
INSERT INTO `configuration_group` VALUES (6, 'Module Options', 'Hidden from configuration', 6, 0);
INSERT INTO `configuration_group` VALUES (7, 'Weight/Tare', 'Shipping weight options available at the store', 30, 0);
INSERT INTO `configuration_group` VALUES (8, 'Product Listing', 'Product Listing configuration options', 8, 0);
INSERT INTO `configuration_group` VALUES (9, 'Stock', 'Stock configuration options', 9, 0);
INSERT INTO `configuration_group` VALUES (10, 'Logging', 'Logging configuration options', 10, 0);
INSERT INTO `configuration_group` VALUES (11, 'Cache', 'Caching configuration options', 11, 0);
INSERT INTO `configuration_group` VALUES (12, 'Email Options', 'General settings for Email transport', 12, 0);
INSERT INTO `configuration_group` VALUES (13, 'Download Options', 'Downloadable products options', 13, 0);
INSERT INTO `configuration_group` VALUES (14, 'GZip Compression', 'GZip compression options', 14, 0);
INSERT INTO `configuration_group` VALUES (15, 'Sessions', 'Session options', 15, 0);
INSERT INTO `configuration_group` VALUES (30, 'Random Items', 'This has settings related to Featured Products and Recommended', 7, 1);
INSERT INTO `configuration_group` VALUES (31, 'Links Configuration', 'Links Manager configuration options', 99, 1);
INSERT INTO `configuration_group` VALUES (32, 'Meta Tags', 'Meta Tags configuration options', 100, 1);
INSERT INTO `configuration_group` VALUES (33, 'Change Store Text', 'Store text configuration options', 101, 1);
INSERT INTO `configuration_group` VALUES (34, 'Google Adsense', 'Adsense configuration', 102, 1);

-- --------------------------------------------------------

--
-- Table structure for table `counter`
--

CREATE TABLE `counter` (
`startdate` char(8) default NULL,
`counter` int(12) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `counter`
--

INSERT INTO `counter` VALUES ('20060221', 3699);

-- --------------------------------------------------------

--
-- Table structure for table `counter_history`
--

CREATE TABLE `counter_history` (
`month` char(8) default NULL,
`counter` int(12) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `counter_history`
--


-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=240 ;

--
-- Dumping data for table `countries`
--

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

-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `currencies`
--

INSERT INTO `currencies` VALUES (1, 'US Dollar', 'USD', '$', '', '.', ',', '2', 1.72660005, '2006-03-13 14:55:39');
INSERT INTO `currencies` VALUES (2, 'Euro', 'EUR', '€', '', '.', ',', '2', 1.45070004, '2006-03-13 14:55:39');
INSERT INTO `currencies` VALUES (3, 'UK Pound', 'GBP', '£', '', '.', ',', '2', 1.00000000, '2006-03-13 14:55:39');

-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=106 ;

--
-- Dumping data for table `customers`
--

INSERT INTO `customers` VALUES (105, 'm', 'test', 'test', '0000-00-00 00:00:00', 'test@anewshop.co.uk', 105, '', '', 'bcde0a577d4322d1c712e948b4a7cfab:eb', '1');

-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `customers_basket`
--


-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `customers_basket_attributes`
--


-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `customers_info`
--

INSERT INTO `customers_info` VALUES (105, NULL, 0, '2006-03-13 15:28:57', NULL, 0);

-- --------------------------------------------------------

--
-- Table structure for table `faq`
--

CREATE TABLE `faq` (
`faq_id` tinyint(3) unsigned NOT NULL auto_increment,
`visible` enum('1','0') NOT NULL default '1',
`v_order` tinyint(3) unsigned NOT NULL default '0',
`question` text NOT NULL,
`answer` text NOT NULL,
`date` date NOT NULL default '0000-00-00',
`language` varchar(32) NOT NULL default '',
PRIMARY KEY (`faq_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `faq`
--

INSERT INTO `faq` VALUES (1, '1', 1, 'What is an Ebook?', 'The term Ebook stands for electronic book. It is basically a book in digital form that can be read on your PC. They come in many formats including PDF, exe and Word.', '0000-00-00', 'english');
INSERT INTO `faq` VALUES (2, '1', 2, 'Do I need any special software to read an Ebook?', 'Most Ebooks can be read using the default software of your computer. For Ebooks in PDF format, you will need Acrobat Reader which can be obtained from Adobe. Ebooks in Word format will require Microsoft Word. Many Ebooks come in exe format which can be read on any PC.<br>\r\nYou will also need extracting software such as Winzip ( WinZip - The Zip File Utility for Windows - Zip Files, Unzip Files ) to unpack your purchase from the ZIP folder that it will arrive in.', '0000-00-00', 'english');
INSERT INTO `faq` VALUES (3, '1', 3, 'Will I get an instant download of my purchase?', 'Yes. After you have made your payment, you are then redirected to a page where you can download your purchase straight away.', '0000-00-00', 'english');
INSERT INTO `faq` VALUES (4, '1', 4, 'Which methods of payment do you accept?', 'Currently we accept credit card and debit card payments by PayPal.<br>\r\nIf you haven''t got a FREE PayPal account <a href=https://www.paypal.com/uk/pal=UH3HUZG9963WN target=_blank>click here</a> to get one!', '2006-03-05', 'english');
INSERT INTO `faq` VALUES (5, '1', 5, 'I cannot download my purchase! What shall I do?', 'Simply <a href=contact_us.php>contact us</a> and we will help you.', '0000-00-00', 'english');

-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `geo_zones`
--

INSERT INTO `geo_zones` VALUES (1, 'USA States', 'USA Sales Tax', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `geo_zones` VALUES (2, 'European Countries', 'UK and EU VAT', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `info_about`
--

CREATE TABLE `info_about` (
`Id` int(1) unsigned NOT NULL default '0',
`Text` blob NOT NULL,
PRIMARY KEY (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `info_about`
--

INSERT INTO `info_about` VALUES (1, 0x476f746f207468652041646d696e205061676520746f2063 68616e6765207468697320746578740d0a0d0a687474703a2f 2f796f7572646f6d61696e6e616d652e636f6d2f61646d696e );

-- --------------------------------------------------------

--
-- Table structure for table `info_conditions`
--

CREATE TABLE `info_conditions` (
`Id` int(1) unsigned NOT NULL default '0',
`Text` blob NOT NULL,
PRIMARY KEY (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `info_conditions`
--

INSERT INTO `info_conditions` VALUES (1, 0x5468657365207465726d7320616e6420636f6e646974696f 6e732028746865205465726d732920676f7665726e20746865 2075736572732028796f7520206f7220796f75722920757365 206f6620746869732077656273697465202874686520576562 736974652920616e6420796f75722072656c6174696f6e7368 6970207769746820746869732057656273697465202877652c 206f7572206f72207573292e20506c65617365207265616420 7468656d206361726566756c6c792061732074686579206166 6665637420796f75722072696768747320616e64206c696162 696c697469657320756e646572206c61772e20496620796f75 20646f206e6f7420616772656520746f207468657365205465 726d732c20706c6561736520646f206e6f7420616363657373 206e6f72207573652074686520576562736974652e200d0a0d 0a3c623e4163637572616379206f6620496e666f726d617469 6f6e3c2f623e0d0a5768696c737420776520656e646561766f 757220746f20656e73757265207468617420616c6c20696e66 6f726d6174696f6e20696e636c75646564206f6e2074686520 5765627369746520697320636f72726563742c207765207769 6c6c206e6f742062652068656c6420726573706f6e7369626c 6520666f7220616e79206572726f7273206f72206f6d697373 696f6e732e2049662077652061726520696e666f726d656420 6f6620616e7920696e6163637572616369657320696e207468 65206d6174657269616c206f6e207468652057656273697465 2c2077652077696c6c20636f72726563742074686973206173 20736f6f6e20617320776520726561736f6e61626c79206361 6e2e205072696365732c206465736372697074696f6e732c20 73706563696669636174696f6e7320616e642070726f647563 7420617661696c61626c697479206d6179206368616e676520 617420616e792074696d6520776974686f7574206675727468 6572206e6f74696669636174696f6e2e200d0a0d0a3c623e41 63636f756e7420616e642050617373776f72643c2f623e200d 0a596f752061726520726573706f6e7369626c6520666f7220 6d61696e7461696e696e672074686520636f6e666964656e74 69616c697479206f6620796f7572206163636f756e7420616e 642070617373776f726420616e6420666f7220726573747269 6374696e672061636365737320746f20796f757220636f6d70 757465722c20616e6420796f7520616772656520746f206163 6365707420726573706f6e736962696c69747920666f722061 6c6c20616374697669746965732074686174206f6363757220 756e64657220796f7572206163636f756e74206f7220706173 73776f72642e200d0a0d0a3c623e4f72646572696e6720496e 666f726d6174696f6e3c2f623e0d0a506c6561736520726566 657220746f206f7572203c6120687265663d6661712e706870 3e3c753e48656c7020616e64204641513c2f613e3c2f753e20 73656374696f6e20666f72206d6f726520696e666f726d6174 696f6e2e0d0a0d0a3c623e507269766163793c2f623e0d0a50 6c6561736520726566657220746f206f7572203c6120687265 663d707269766163792e7068703e3c753e5072697661637920 506f6c6963793c2f613e3c2f753e20666f72206d6f72652069 6e666f726d6174696f6e2e0d0a0d0a3c623e54726164656d61 726b7320616e6420436f707972696768743c2f623e200d0a41 6c6c2074726164656d61726b7320616e6420636f7079726967 687473206172652074686520736f6c652070726f7065727479 206f662074686569722072657370656374697665206f776e65 727320616e642070686f746f67726170687320636f75727465 7379206f662074686569722072657370656374697665206175 74686f72732e20576520686f6c642066756c6c2072652d7361 6c652072696768747320666f7220616c6c2070726f64756374 73206c6973746564206f6e207468697320776562736974652e 200d0a0d0a3c623e4c6963656e736520616e64205765627369 7465204163636573733c2f623e0d0a54686973205765627369 7465206772616e747320796f752061206c696d69746564206c 6963656e736520746f2061636365737320616e64206d616b65 20706572736f6e616c20757365206f66207468697320736974 6520616e64206e6f7420746f20646f776e6c6f616420286f74 686572207468616e20706167652063616368696e6729206f72 206d6f646966792069742c206f7220616e7920706f7274696f 6e206f662069742c2065786365707420776974682065787072 657373207772697474656e20636f6e73656e742e2054686973 206c6963656e736520646f6573206e6f7420696e636c756465 20616e7920726573616c65206f7220636f6d6d65726369616c 20757365206f6620746869732073697465206f722069747320 636f6e74656e74733a20616e7920636f6c6c656374696f6e20 616e6420757365206f6620616e792070726f64756374206c69 7374696e67732c206465736372697074696f6e732c206f7220 7072696365733a20616e792064657269766174697665207573 65206f6620746869732073697465206f722069747320636f6e 74656e74733a20616e7920646f776e6c6f6164696e67206f72 20636f7079696e67206f66206163636f756e7420696e666f72 6d6174696f6e20666f72207468652062656e65666974206f66 20616e6f74686572206d65726368616e743a206f7220616e79 20757365206f662064617461206d696e696e672c20726f626f 74732c206f722073696d696c61722064617461206761746865 72696e6720616e642065787472616374696f6e20746f6f6c73 2e2020416e7920756e617574686f72697a6564207573652074 65726d696e6174657320746865207065726d697373696f6e20 6f72206c6963656e7365206772616e74656420627920746869 7320576562736974652e20596f7520617265206772616e7465 642061206c696d697465642c207265766f6361626c652c2061 6e64206e6f6e206578636c757369766520726967687420746f 2063726561746520612068797065726c696e6b20746f207468 6520686f6d652070616765206f662074686973205765627369 746520736f206c6f6e6720617320746865206c696e6b20646f 6573206e6f7420706f72747261792074686973205765627369 74652c20697473206173736f6369617465732c206f72207468 6569722070726f6475637473206f7220736572766963657320 696e20612066616c73652c206d69736c656164696e672c2064 65726f6761746f72792c206f72206f7468657277697365206f 6666656e73697665206d61747465722e20596f75206d617920 6e6f742075736520616e79206c6f676f206f72206f74686572 2070726f70726965746172792067726170686963206f722074 726164656d61726b2061732070617274206f6620746865206c 696e6b20776974686f75742065787072657373207772697474 656e207065726d697373696f6e2e200d0a0d0a3c623e496e64 656d6e6974793c2f623e0d0a596f7520616772656520746f20 66756c6c7920696e64656d6e6966792c20646566656e642061 6e6420686f6c642075732c20616e64206f757220656d706c6f 7965657320616e6420737570706c696572732c206861726d6c 65737320696d6d6564696174656c79206f6e2064656d616e64 2c2066726f6d20616e6420616761696e737420616c6c20636c 61696d732c206c6f737365732c20636f73747320616e642065 7870656e7365732c20696e636c7564696e6720726561736f6e 61626c65206c6567616c20666565732c2061726973696e6720 6f7574206f6620616e7920627265616368206f662074686573 65205465726d7320627920796f752c206f7220616e79206f74 686572206c696162696c69746965732061726973696e67206f 7574206f6620796f757220757365206f662074686973205765 6273697465206f7220616e79206f7468657220706572736f6e 20616363657373696e67207468652057656273697465207573 696e6720796f757220706572736f6e616c20696e666f726d61 74696f6e2e200d0a0d0a3c623e4c617720616e64204a757269 7364696374696f6e3c2f623e200d0a496620616e7920706172 74206f6620746865205465726d73207368616c6c2062652064 65656d656420756e6c617766756c2c20766f6964206f722066 6f7220616e7920726561736f6e20756e656e666f7263656162 6c652c207468656e20746861742070726f766973696f6e2073 68616c6c206265206465656d656420736576657261626c6520 66726f6d207468657365205465726d7320616e64207368616c 6c206e6f7420616666656374207468652076616c6964697479 20616e6420656e666f7263656162696c697479206f6620616e 792072656d61696e696e672070726f766973696f6e73206f66 20746865205465726d732e200d0a0d0a3c623e4368616e6765 7320746f207468657365205465726d7320616e6420436f6e64 6974696f6e733c2f623e0d0a54686973205765627369746520 72657365727665732074686520726967687420746f20636861 6e6765207468657365205465726d7320616e6420436f6e6469 74696f6e7320776974686f7574207072696f72206e6f746963 6520617420616e792074696d652e);

-- --------------------------------------------------------

--
-- Table structure for table `info_privacy`
--

CREATE TABLE `info_privacy` (
`Id` int(1) unsigned NOT NULL default '0',
`Text` blob NOT NULL,
PRIMARY KEY (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `info_privacy`
--

INSERT INTO `info_privacy` VALUES (1, 0x3c623e596f757220507269766163793c2f623e0d0a576520 7265737065637420796f757220707269766163792e20576520 6f6e6c79207573652074686520696e666f726d6174696f6e20 776520636f6c6c6563742061626f757420796f7520746f2070 726f63657373206f726465727320616e6420746f2070726f76 696465206120706572736f6e616c697a65642073686f707069 6e6720657870657269656e63652e200d0a0d0a3c623e576861 7420696e666f726d6174696f6e20646f20776520636f6c6c65 63743f3c2f623e0d0a5768656e20796f752072656769737465 72206173206120437573746f6d65722c20796f75207375626d 697420796f7572206e616d652c20656d61696c206164647265 737320616e6420636f756e7472792e205468697320696e666f 726d6174696f6e20616c6c6f777320757320746f2066756c66 696c6c20796f7572206f726465727320616e6420746f20636f 6e7461637420796f7520696620746865206e65656420617269 7365732e20416c6c20637573746f6d657220696e666f726d61 74696f6e2073746f726564206f6e206f757220736572766572 732061626f757420796f752063616e20626520616363657373 6564206f72206d6f64696669656420627920796f7520617420 616e792074696d65206279206c6f6767696e6720696e746f20 4d79204163636f756e74207769746820796f757220656d6169 6c206164647265737320616e642070617373776f72642e0d0a 0d0a3c623e57696c6c20796f7520646973636c6f7365207468 697320496e666f726d6174696f6e3f3c2f623e200d0a4e6f21 204e657665722120596f7572207072697661746520696e666f 726d6174696f6e20697320746f6f2070726563696f75732074 6f207368617265207769746820616e796f6e652e20496e666f 726d6174696f6e206761746865726564206f6e207468697320 73697465206973204e45564552206d61646520617661696c61 626c6520746f2074686972642070617274792076656e646f72 7320616e64204e4556455220736f6c6420746f206d61696c69 6e67206c697374206469737472696275746f72732e0d0a0d0a 3c623e456d61696c204e6f74696669636174696f6e733c2f62 3e0d0a5768656e20796f752072656769737465722061732061 20437573746f6d65722c20796f752077696c6c207265636569 766520616e206175746f6d6174656420656d61696c20636f6e 7461696e696e6720796f757220437573746f6d6572204c6f67 20496e2064657461696c732e0d0a5768656e20796f75207075 72636861736520676f6f64732066726f6d2075732c20796f75 2077696c6c207265636569766520616e206175746f6d617465 64207265636569707420627920656d61696c2e205765206f6e 6c7920656d61696c20796f7520696e20706572736f6e206966 207765206e65656420746f20636c6172696679206465746169 6c732061626f757420796f7572206f72646572206f72206966 2077652061726520726573706f6e64696e6720746f20796f75 72207175657374696f6e73206f7220717565726965732e0d0a 0d0a3c623e456d61696c20436f6d6d756e69636174696f6e73 20616e64204e6577736c6574746572733c2f623e0d0a576520 73656e64206f7574206f63636173696f6e616c20656d61696c 206e6577736c65747465727320746f206f757220637573746f 6d6572732e204f7572206e6577736c65747465727320636f6e 7461696e20696e666f726d6174696f6e2061626f7574206e65 772070726f64756374732c207370656369616c2070726f6d6f 74696f6e732c2070726f6475637420757064617465732c2064 6973636f756e747320616e6420756e69717565206f66666572 732e0d0a596f75206861766520746865206f7074696f6e2074 6f20756e73756273637269626520616e7920616e792074696d 65206279206c6f6767696e6720696e746f20796f7572204375 73746f6d6572204163636f756e74204172656120616e642075 70646174696e6720796f7572204e6577736c65747465722050 7265666572656e6365732e0d0a0d0a3c623e43726564697420 616e64204465626974204361726420496e666f726d6174696f 6e3c2f623e0d0a417320776520757365207365637572652074 68697264207061727479207061796d656e742070726f636573 736f7273206c696b652050617950616c20746f2070726f6365 737320637265646974206361726420616e6420646562697420 63617264206f72646572732c20776520646f206e6f74206861 766520616e792061636365737320746f20796f757220637265 646974206361726420696e666f726d6174696f6e2061742061 6c6c2e0d0a5768656e20796f75206d616b6520612070757263 6861736520617420746869732073746f72652c20796f752061 7265207472616e7366657272656420746f2074686520736563 7572652073657276657273206f66206f7572207061796d656e 742070726f636573736f72732e204e6f206372656469742063 61726420696e666f726d6174696f6e20697320657665722073 746f72656420696e206f757220736974652064617461626173 652e200d0a0d0a3c623e436f6f6b69652055736167652c2053 6563757269747920616e6420536166652053686f7070696e67 3c2f623e0d0a54686973207765627369746520757365732063 6f6f6b69657320746f2073746f726520696e666f726d617469 6f6e206f6e20796f7572206c6f63616c20636f6d7075746572 2e20546865736520636f6f6b69657320646f204e4f5420636f 6e7461696e20616e79206f6620796f75722070726976617465 20696e666f726d6174696f6e3b207468657920736572766520 6f6e6c7920746f2073746f7265206974656d7320696e20796f 75722053686f7070696e67204261736b6574206f7220746f20 7265636f676e697a6520796f75206173206120726567697374 6572656420437573746f6d6572207768656e20796f75204c6f 6720496e206f722061636365737320796f7572204163636f75 6e742e0d0a546869732070726576656e747320756e61757468 6f72697a65642075736572732066726f6d2061636365737369 6e6720796f7572207072697661746520696e666f726d617469 6f6e2e0d0a0d0a576520726573657276652074686520726967 687420746f206d6f6469667920746865736520706f6c696369 657320666f7220616e7920726561736f6e20617420616e7920 74696d652e20);

-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` VALUES (1, 'English', 'en', 'icon.gif', 'english', 1);

-- --------------------------------------------------------

--
-- Table structure for table `link_categories`
--

CREATE TABLE `link_categories` (
`link_categories_id` int(11) NOT NULL auto_increment,
`link_categories_image` varchar(64) default NULL,
`link_categories_sort_order` int(3) default NULL,
`link_categories_date_added` datetime default NULL,
`link_categories_last_modified` datetime default NULL,
`link_categories_status` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`link_categories_id`),
KEY `idx_link_categories_date_added` (`link_categories_date_added`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `link_categories`
--

INSERT INTO `link_categories` VALUES (1, NULL, 0, '0000-00-00 00:00:00', NULL, 1);
INSERT INTO `link_categories` VALUES (2, NULL, 0, '0000-00-00 00:00:00', NULL, 1);
INSERT INTO `link_categories` VALUES (3, NULL, 0, '0000-00-00 00:00:00', NULL, 1);
INSERT INTO `link_categories` VALUES (4, NULL, 0, '0000-00-00 00:00:00', NULL, 1);
INSERT INTO `link_categories` VALUES (5, NULL, 0, '0000-00-00 00:00:00', NULL, 1);
INSERT INTO `link_categories` VALUES (6, NULL, 0, '0000-00-00 00:00:00', NULL, 1);
INSERT INTO `link_categories` VALUES (7, NULL, 0, '0000-00-00 00:00:00', NULL, 1);
INSERT INTO `link_categories` VALUES (8, NULL, 0, '0000-00-00 00:00:00', NULL, 1);
INSERT INTO `link_categories` VALUES (9, NULL, 0, '0000-00-00 00:00:00', NULL, 1);

-- --------------------------------------------------------

--
-- Table structure for table `link_categories_description`
--

CREATE TABLE `link_categories_description` (
`link_categories_id` int(11) NOT NULL default '0',
`language_id` int(11) NOT NULL default '1',
`link_categories_name` varchar(32) NOT NULL default '',
`link_categories_description` text,
PRIMARY KEY (`link_categories_id`,`language_id`),
KEY `idx_link_categories_name` (`link_categories_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `link_categories_description`
--

INSERT INTO `link_categories_description` VALUES (1, 1, 'Lifestyle', '');
INSERT INTO `link_categories_description` VALUES (2, 1, 'Web Services', '');
INSERT INTO `link_categories_description` VALUES (3, 1, 'Business', '');
INSERT INTO `link_categories_description` VALUES (4, 1, 'Entertainment', '');
INSERT INTO `link_categories_description` VALUES (5, 1, 'Shopping', '');
INSERT INTO `link_categories_description` VALUES (6, 1, 'Links Directories', '');
INSERT INTO `link_categories_description` VALUES (7, 1, 'Computers and Internet', '');
INSERT INTO `link_categories_description` VALUES (8, 1, 'Making Money', '');
INSERT INTO `link_categories_description` VALUES (9, 1, 'Free Stuff', '');

-- --------------------------------------------------------

--
-- Table structure for table `links`
--

CREATE TABLE `links` (
`links_id` int(11) NOT NULL auto_increment,
`links_url` varchar(255) default NULL,
`links_reciprocal_url` varchar(255) default NULL,
`links_image_url` varchar(255) default NULL,
`links_contact_name` varchar(64) default NULL,
`links_contact_email` varchar(96) default NULL,
`links_date_added` datetime NOT NULL default '0000-00-00 00:00:00',
`links_last_modified` datetime default NULL,
`links_status` tinyint(1) NOT NULL default '0',
`links_clicked` int(11) NOT NULL default '0',
`links_rating` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`links_id`),
KEY `idx_links_date_added` (`links_date_added`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `links`
--

INSERT INTO `links` VALUES (4, 'http://anewshop.co.uk', 'http://anewshop.co.uk', '', 'Angela', 'angela@anewshop.co.uk', '2006-02-22 22:10:03', '2006-02-22 22:13:36', 2, 0, 0);
INSERT INTO `links` VALUES (3, 'http://ringtoneslogosgamesvideos.co.uk', 'http://ringtoneslogosgamesvideos.co.uk', '', 'Angela', 'angela@anewshop.co.uk', '2006-02-22 22:07:30', '2006-02-22 22:08:27', 2, 0, 0);
INSERT INTO `links` VALUES (5, 'http://articlesheaven.co.uk', 'http://articlesheaven.co.uk', '', 'Angela', 'angela@anewshop.co.uk', '2006-02-22 22:11:18', '2006-03-10 00:47:18', 2, 0, 0);
INSERT INTO `links` VALUES (6, 'http://anewshop.co.uk/free_information/voip/index.php', 'http://geminiinternetservices.co.uk/free_information/voip/index.php', '', 'A New Shop', 'admin@anewshop.co.uk', '2006-02-22 22:13:16', '2006-02-27 23:48:10', 2, 0, 0);
INSERT INTO `links` VALUES (7, 'http://geminiwebtemplates.com', 'http://geminiwebtemplates.com', '', 'A New Shop', 'admin@anewshop.co.uk', '2006-02-22 22:16:29', '2006-02-22 22:17:11', 2, 0, 0);
INSERT INTO `links` VALUES (8, 'http://freedebtconsolidationadvice.co.uk', 'http://freedebtconsolidationadvice.co.uk', '', 'A New Shop', 'admin@anewshop.co.uk', '2006-03-04 13:47:58', NULL, 2, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `links_description`
--

CREATE TABLE `links_description` (
`links_id` int(11) NOT NULL auto_increment,
`language_id` int(11) NOT NULL default '1',
`links_title` varchar(64) NOT NULL default '',
`links_description` text,
PRIMARY KEY (`links_id`,`language_id`),
KEY `links_title` (`links_title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `links_description`
--

INSERT INTO `links_description` VALUES (4, 1, 'A New Shop', 'eBooks and more at this download \r\nstore - Get the latest ebooks here. \r\nInstant download after purchase.');
INSERT INTO `links_description` VALUES (3, 1, 'Ringtones & Logos for your mobile', 'Ringtones, wallpaper, games, logos and \r\nthe UK top 40 for your mobile \r\nphone');
INSERT INTO `links_description` VALUES (5, 1, 'Article Heaven', 'Your one-stop source for free articles. \r\nDo you need contents to add to \r\nyour web site? Or articles for use on \r\nyour opt-in newsletters and e-\r\nzines? Article Heaven has scoured the \r\nweb \r\nand indexed a huge collection of \r\narticles on various subjects.');
INSERT INTO `links_description` VALUES (6, 1, 'IP Phone information', 'The way we make phone \r\ncalls is changing. In fact in many \r\ncircumstances things have already \r\nchanged. Visit this website for all the \r\nlatest information on Voice over IP');
INSERT INTO `links_description` VALUES (7, 1, 'Gemini Website Templates', 'Website Templates Logos is a premium \r\nsource for high quality website \r\ntemplates, flash templates, flash intros, \r\nlogo templates, corporate identities, and \r\nphp-nuke themes. Web templates can \r\nbe used to build your personal webpage \r\nor huge corporate site, online shop or \r\noffline presentation or even as a design \r\nfor the software you develop! And \r\neverything you create is going to be \r\neasy, fast and professional!');
INSERT INTO `links_description` VALUES (8, 1, 'Complete Debt Consolidation Guide Directory', '"How You Can Get Out Of Debt FAST \r\nWithout Filing Bankruptcy -- Using \r\nSeveral Little Known But Highly Effective \r\nTechniques Which Are Guaranteed To \r\nWork No Matter How Much You Currently \r\nOwe!"');

-- --------------------------------------------------------

--
-- Table structure for table `links_status`
--

CREATE TABLE `links_status` (
`links_status_id` int(11) NOT NULL default '0',
`language_id` int(11) NOT NULL default '1',
`links_status_name` varchar(32) NOT NULL default '',
PRIMARY KEY (`links_status_id`,`language_id`),
KEY `idx_links_status_name` (`links_status_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `links_status`
--

INSERT INTO `links_status` VALUES (1, 1, 'Pending');
INSERT INTO `links_status` VALUES (2, 1, 'Approved');
INSERT INTO `links_status` VALUES (3, 1, 'Disabled');

-- --------------------------------------------------------

--
-- Table structure for table `links_to_link_categories`
--

CREATE TABLE `links_to_link_categories` (
`links_id` int(11) NOT NULL default '0',
`link_categories_id` int(11) NOT NULL default '0',
PRIMARY KEY (`links_id`,`link_categories_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `links_to_link_categories`
--

INSERT INTO `links_to_link_categories` VALUES (3, 4);
INSERT INTO `links_to_link_categories` VALUES (4, 2);
INSERT INTO `links_to_link_categories` VALUES (5, 9);
INSERT INTO `links_to_link_categories` VALUES (6, 9);
INSERT INTO `links_to_link_categories` VALUES (7, 2);
INSERT INTO `links_to_link_categories` VALUES (8, 3);

-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `manufacturers`
--


-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `manufacturers_info`
--


-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `newsletters`
--

INSERT INTO `newsletters` VALUES (1, 'Example newsletter. Do not send', 'This is an example newsletter. Do not send this. It is merely an example, so that you can see how it works.\r\n\r\nWhen you send a newsletter, make sure that it contains a short line about how to unsubscribe, just in case the customer does not wish to receive further mailings. It should look\r\nlike the example below.\r\n\r\n--------------------------------------------\r\n\r\nThis email is not spam.\r\nYou are receiving this newsletter because you are a customer of our website.\r\n\r\nIf you do not want to receive this newsletter anymore, simply log into My Account at our website and change your newsletter preferences.', 'newsletter', '0000-00-00 00:00:00', '2006-02-27 23:51:01', 1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `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 '1',
`orders_date_finished` datetime default NULL,
`currency` char(3) default NULL,
`currency_value` decimal(14,6) default NULL,
PRIMARY KEY (`orders_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=107 ;

--
-- Dumping data for table `orders`
--


-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `orders_products`
--


-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `orders_products_attributes`
--


-- --------------------------------------------------------

--
-- Table structure for table `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 '7',
`download_count` int(2) NOT NULL default '1',
PRIMARY KEY (`orders_products_download_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `orders_products_download`
--

INSERT INTO `orders_products_download` VALUES (1, 99, 1, 'exampleproduct.zip', 7, 0);
INSERT INTO `orders_products_download` VALUES (2, 100, 2, '1000atkins.zip', 7, 0);
INSERT INTO `orders_products_download` VALUES (3, 101, 3, 'articlesitedirectory.zip', 7, 0);
INSERT INTO `orders_products_download` VALUES (4, 102, 4, 'ebookstore.zip', 7, 0);
INSERT INTO `orders_products_download` VALUES (5, 103, 5, 'xboxcheats', 7, 1);
INSERT INTO `orders_products_download` VALUES (6, 104, 6, 'PS2Cheats.zip', 7, 0);
INSERT INTO `orders_products_download` VALUES (7, 105, 7, 'atkinsrevolution.zip', 7, 0);
INSERT INTO `orders_products_download` VALUES (8, 106, 8, 'guidedating.zip', 7, 1);
INSERT INTO `orders_products_download` VALUES (9, 106, 9, '1000atkins.zip', 7, 1);

-- --------------------------------------------------------

--
-- Table structure for table `orders_status`
--

CREATE TABLE `orders_status` (
`orders_status_id` int(11) NOT NULL default '1',
`language_id` int(11) NOT NULL default '1',
`orders_status_name` varchar(32) NOT NULL default 'Completed',
PRIMARY KEY (`orders_status_id`,`language_id`),
KEY `idx_orders_status_name` (`orders_status_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `orders_status`
--

INSERT INTO `orders_status` VALUES (1, 1, 'Completed');

-- --------------------------------------------------------

--
-- Table structure for table `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 '1',
`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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `orders_status_history`
--


-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `orders_total`
--


-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=80 ;

--
-- Dumping data for table `products`
--

INSERT INTO `products` VALUES (1, 99999, '', 'book_penis.jpg', 1.9900, '2005-09-05 00:16:53', '2005-09-05 03:11:49', NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (2, 99999, '', 'book_orgsm.jpg', 1.9900, '2005-09-05 01:02:52', '2005-09-05 01:03:23', NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (3, 999999, '', 'book_longsex.jpg', 1.9900, '2005-09-05 01:14:54', NULL, NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (4, 99999, '', 'SexPositions.jpg', 1.9900, '2005-09-05 01:31:47', NULL, NULL, 0.00, 1, 0, 0, 1);
INSERT INTO `products` VALUES (5, 99999, '', 'fruit.jpg', 1.9900, '2005-09-05 01:49:10', '2005-09-05 03:30:00', NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (6, 999999, '', 'horse.jpg', 1.9900, '2005-09-05 01:59:14', '2005-09-05 03:02:16', NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (7, 99999, '', 'atkins.jpg', 1.9900, '2005-09-05 03:25:28', NULL, NULL, 0.00, 1, 0, 0, 2);
INSERT INTO `products` VALUES (8, 99999, '', 'atkins_diet_recipes.jpg', 1.9900, '2005-09-05 04:04:29', '2005-09-05 05:06:38', NULL, 0.00, 1, 0, 0, 2);
INSERT INTO `products` VALUES (60, 99999, '', 'icecreambk.gif', 1.9900, '2005-12-04 17:22:47', NULL, NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (10, 99999, '', 'Hypnotism.jpg', 2.9900, '2005-09-05 04:27:50', '2005-09-05 05:05:27', NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (11, 99999, '', 'weightwatchers.jpg', 2.9900, '2005-09-05 04:40:01', '2005-09-05 05:06:24', NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (58, 99999, '', 'moneyleak.gif', 1.9900, '2005-12-04 17:13:19', NULL, NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (14, 99999, '', 'yoga_techniques.jpg', 1.9900, '2005-09-05 05:14:08', NULL, NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (15, 99999, '', 'credit_secrets_revealed.jpg', 1.9900, '2005-09-05 05:21:58', '2005-10-14 04:48:18', NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (16, 9999, '', '597_business_letters.jpg', 1.9900, '2005-09-05 05:27:45', NULL, NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (17, 999999, '', 'unlock_your_psychic_ability.jpg', 1.9900, '2005-09-05 05:40:47', '2005-09-05 05:41:11', NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (18, 99999, '', 'truth.jpg', 1.9900, '2005-09-05 05:50:13', NULL, NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (19, 99999, '', 'bread_recipes.jpg', 1.9900, '2005-09-05 05:57:42', '2005-09-05 05:57:54', NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (20, 99999, '', 'bread.jpg', 1.9900, '2005-09-05 06:02:37', '2005-10-20 22:29:30', NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (28, 99999, '', 'football.jpg', 1.9900, '2005-09-05 06:55:25', NULL, NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (22, 99999, '', 'stop_smoking.jpg', 1.9900, '2005-09-05 06:22:44', '2005-09-05 06:23:45', NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (23, 99999, '', 'gamecube_cheats.jpg', 1.9900, '2005-09-05 06:25:58', NULL, NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (24, 99999, '', 'ps2_cheats.jpg', 1.9900, '2005-09-05 06:27:02', NULL, NULL, 0.00, 1, 0, 0, 1);
INSERT INTO `products` VALUES (25, 99999, '', 'xbox_cheats.jpg', 0.4500, '2005-09-05 06:28:21', NULL, NULL, 0.00, 1, 0, 0, 2);
INSERT INTO `products` VALUES (27, 99999, '', 'ezyinternetsmall.jpg', 1.9900, '2005-09-05 06:43:41', NULL, NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (29, 99999, '', 'women.jpg', 1.9900, '2005-09-05 07:04:40', NULL, NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (30, 99999, '', 'book_onl_d.jpg', 1.9900, '2005-09-05 07:07:58', NULL, NULL, 0.00, 1, 0, 0, 1);
INSERT INTO `products` VALUES (31, 99999, '', 'book_gr_tip.jpg', 1.9900, '2005-09-05 07:09:48', NULL, NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (32, 999999, '', 'greatsex.gif', 1.9900, '2005-09-05 07:15:03', '2005-09-05 07:15:46', NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (33, 99999, '', 'ufos_andaliens.jpg', 1.9900, '2005-09-05 07:24:30', NULL, NULL, 0.00, 1, 0, 0, 6);
INSERT INTO `products` VALUES (34, 999999, '', 'sexallnight.jpg', 1.9900, '2005-09-05 07:31:28', NULL, NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (35, 99999, '', 'sellebooks.jpg', 1.9900, '2005-09-05 07:43:25', '2005-09-05 07:51:42', NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (37, 999999, '', 'auctionprofits.jpg', 1.9900, '2005-09-05 08:00:16', NULL, NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (38, 99999, '', 'ukwholesalers.jpg', 1.9900, '2005-09-05 08:07:46', '2005-10-11 04:58:21', NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (41, 99999, '', 'saladrecipes.jpg', 1.9900, '2005-09-05 08:28:28', NULL, NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (42, 99999, '', 'lowfat.jpg', 1.9900, '2005-09-05 08:33:33', NULL, NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (43, 99999, '', 'learn_html.jpg', 1.9900, '2005-09-05 08:39:41', NULL, NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (44, 999999, '', 'gambling_systems_revealed.jpg', 1.9900, '2005-09-05 08:54:54', '2005-11-23 02:43:21', NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (45, 999999, '', 'disastersmall.jpg', 1.9900, '2005-09-05 08:59:26', NULL, NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (46, 999999, '', 'ebook_security.gif', 1.9900, '2005-09-05 09:02:41', NULL, NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (47, 99999, '', 'chinese.jpg', 1.9900, '2005-09-05 09:08:49', NULL, NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (61, 999999, '', 'car.jpg', 1.9900, '2005-12-04 17:25:54', NULL, NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (57, 999999, '', 'bigarms.jpg', 1.9900, '2005-12-04 17:09:44', NULL, NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (50, 99999, '', 'closeupmagic.jpg', 1.9900, '2005-09-05 09:44:47', '2005-09-05 09:47:37', NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (51, 99999, '', 'blainbook.jpg', 1.9900, '2005-09-05 09:51:14', NULL, NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (52, 999999, '', 'auto.jpg', 1.9900, '2005-09-05 09:56:53', '2005-09-05 10:08:31', NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (53, 99999, '', 'insidestory.jpg', 1.9900, '2005-09-05 10:03:32', '2005-09-21 00:53:52', NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (54, 99999, '', 'dumbblonde.jpg', 1.9900, '2005-09-05 11:12:39', NULL, NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (55, 999999, '', 'premium.jpg', 1.9900, '2005-09-05 21:30:37', '2005-10-13 03:50:39', NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (59, 99999, '', 'kidsbk.gif', 1.9900, '2005-12-04 17:19:26', NULL, NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (63, 999999, '', '1141065716_219.jpg', 6.9900, '2006-02-27 18:42:30', '2006-03-08 20:49:58', NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (66, 999999, '', 'phpmegapack.jpg', 2.9900, '2006-03-01 17:40:05', '2006-03-08 21:40:46', NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (67, 999999, '', 'templates-samples1.gif', 1.9900, '2006-03-01 17:49:12', '2006-03-01 18:23:48', NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (68, 999999, '', 'a9_1_b.jpg', 1.9900, '2006-03-01 17:56:32', '2006-03-01 18:21:23', NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (69, 999999, '', '90_day_powerseller.jpg', 1.9900, '2006-03-01 19:03:22', '2006-03-01 19:03:47', NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (71, 999999, '', '2.jpg', 1.9900, '2006-03-01 23:44:19', '2006-03-12 18:58:00', NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (72, 999999, '', 'gsmm1-small.jpg', 2.9900, '2006-03-07 11:20:13', '2006-03-07 11:29:03', NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (74, 999999, '', 'msm-box1-medium.jpg', 3.9900, '2006-03-07 11:55:16', '2006-03-07 12:05:43', NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (75, 999999, '', 'APMBOX2.jpg', 2.9900, '2006-03-07 12:00:23', '2006-03-07 12:02:19', NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (78, 999999, '', 'internet-marketing.jpg', 1.9900, '2006-03-11 18:26:40', '2006-03-12 18:58:18', NULL, 0.00, 1, 0, 0, 0);
INSERT INTO `products` VALUES (79, 999999, '', 'mortgages.jpg', 0.9900, '2006-03-12 18:52:32', '2006-03-12 18:57:36', NULL, 0.00, 1, 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `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 '',
`attribute_sort` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`products_attributes_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=82 ;

--
-- Dumping data for table `products_attributes`
--

INSERT INTO `products_attributes` VALUES (6, 8, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (7, 54, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (61, 59, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (63, 61, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (62, 60, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (60, 57, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (12, 20, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (13, 16, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (14, 35, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (15, 52, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (16, 17, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (17, 19, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (18, 44, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (19, 47, 1, 1, 0.0000, '', 0);
INSERT INTO `products_attributes` VALUES (20, 50, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (21, 1, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (22, 51, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (23, 45, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (24, 7, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (25, 28, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (26, 23, 1, 1, 0.0000, '', 0);
INSERT INTO `products_attributes` VALUES (27, 31, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (28, 30, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (29, 46, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (30, 29, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (31, 43, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (32, 18, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (33, 2, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (34, 37, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (35, 34, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (36, 3, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (37, 22, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (39, 10, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (59, 58, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (41, 55, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (42, 42, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (43, 24, 1, 1, 0.0000, '', 0);
INSERT INTO `products_attributes` VALUES (44, 14, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (46, 41, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (47, 53, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (48, 4, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (49, 15, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (50, 27, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (51, 5, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (52, 6, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (54, 32, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (55, 33, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (56, 38, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (57, 11, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (58, 25, 1, 1, 0.0000, '+', 0);
INSERT INTO `products_attributes` VALUES (67, 63, 1, 1, 0.0000, '', 0);
INSERT INTO `products_attributes` VALUES (70, 66, 1, 1, 0.0000, '', 0);
INSERT INTO `products_attributes` VALUES (71, 67, 1, 1, 0.0000, '', 0);
INSERT INTO `products_attributes` VALUES (72, 68, 1, 1, 0.0000, '', 0);
INSERT INTO `products_attributes` VALUES (73, 69, 1, 1, 0.0000, '', 0);
INSERT INTO `products_attributes` VALUES (75, 71, 1, 1, 0.0000, '', 0);
INSERT INTO `products_attributes` VALUES (76, 72, 1, 1, 0.0000, '', 0);
INSERT INTO `products_attributes` VALUES (78, 74, 1, 1, 0.0000, '', 0);
INSERT INTO `products_attributes` VALUES (79, 75, 1, 1, 0.0000, '', 0);
INSERT INTO `products_attributes` VALUES (80, 78, 1, 1, 0.0000, '', 0);
INSERT INTO `products_attributes` VALUES (81, 79, 1, 1, 0.0000, '', 0);

-- --------------------------------------------------------

--
-- Table structure for table `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 '7',
`products_attributes_maxcount` int(2) default '1',
PRIMARY KEY (`products_attributes_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `products_attributes_download`
--

INSERT INTO `products_attributes_download` VALUES (6, '1000atkins.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (7, 'dirtyblondejokes.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (8, '101healthyrecipes.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (9, '101businessideas.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (10, '101jokes.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (11, '101romanticideas.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (12, '500breadrecipes.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (13, '597businessforms.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (14, 'cheapandeasyguide.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (15, 'automate.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (16, 'psychic.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (17, 'breadrecipes.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (18, 'casinotips.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (19, 'chineaseRecipes.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (20, 'closeupmagic.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (21, 'smallpenis.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (22, 'davidblaine', 7, 1);
INSERT INTO `products_attributes_download` VALUES (23, 'disaster.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (24, 'atkinsrevolution.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (25, 'football.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (26, 'Gamecube.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (27, 'greattipsdating.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (28, 'guidedating.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (29, 'security.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (30, 'successwithwomen.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (31, 'buildhtml.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (32, 'truth.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (33, 'orgasms.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (34, 'auctionprofits.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (35, 'loveallnight.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (36, 'sexlastlonger.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (37, 'stopsmoking.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (38, 'watchskyonyourpc.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (39, 'hypnosis.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (40, '120cardtricks.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (41, 'premium.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (42, 'lowfat.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (43, 'PS2Cheats.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (44, 'yoga.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (45, 'arcadegamer.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (46, 'saladrecipes.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (47, 'insidestory.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (48, 'sexpositions.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (49, 'borrowersbible.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (50, 'easyinternet.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (51, 'fruitmachine.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (52, 'horseracing.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (53, 'negative.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (54, 'greatsex.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (55, 'ufo.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (56, 'wholesaler.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (57, 'weightwatchers.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (58, 'xboxcheats', 7, 1);
INSERT INTO `products_attributes_download` VALUES (59, 'moneyleak.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (60, '31days.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (61, 'kids.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (62, 'icecream.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (63, 'carcredit.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (64, 'ebookstore.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (67, 'phpringtones.ZIP', 7, 1);
INSERT INTO `products_attributes_download` VALUES (68, 'articlesitedirectory.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (69, 'allmyebooks.txt', 7, 1);
INSERT INTO `products_attributes_download` VALUES (70, 'PHP_MEGAPACK.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (71, '55readytogotemps.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (72, '100pluswebtemps.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (73, '90DayPowerSellerChallenge.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (74, 'GoogleWebsiteeBook.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (75, 'debtconsolidationebook.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (76, 'sitemapmaker.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (77, 'bloglink.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (78, 'sitemanager.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (79, 'apm.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (80, 'InternetMarketing.zip', 7, 1);
INSERT INTO `products_attributes_download` VALUES (81, 'MortgagestheCompleteGuide.zip', 7, 1);

-- --------------------------------------------------------

--
-- Table structure for table `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_info` text NOT NULL,
`products_viewed` int(5) default '0',
PRIMARY KEY (`products_id`,`language_id`),
KEY `products_name` (`products_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=80 ;

--
-- Dumping data for table `products_description`
--

INSERT INTO `products_description` VALUES (1, 1, 'Coping With A Small Penis', 'It can seem like a cold, cruel world out there, especially to a man who feels that his equipment doesn''t measure up. Coping with a Small Penis is one man''s journey to personal enlightenment and sexual freedom. You?ll learn from his experience and, perhaps, find the insight and wisdom to get on with your life.', '', 'Coping with a Small Penis is one man''s journey to personal enlightenment and sexual freedom. You?ll learn from his experience and, perhaps, find insight and wisdom.', 227);
INSERT INTO `products_description` VALUES (2, 1, 'How To Give Any Woman Orgasms', 'Your body and a few tips from this ebook are all you need to help your woman achieve orgasm after orgasm. This concise Guide is a frank and explicit look at the female orgasm and what YOU can do to make it happen again and again.', '', 'A frank and explicit look at the female orgasm and what YOU can do to make it happen again and again.', 121);
INSERT INTO `products_description` VALUES (3, 1, 'How To Make Sex Last Longer', 'If you?re like most men, you?re easily aroused and easily satisfied. That?s great for you, but what about your partner? <br>This ebook shows you easy-to-follow techniques for delaying and prolonging ejaculation, that will enhance the lovemaking experience for both of you!', '', 'This ebook shows you easy-to-follow techniques for delaying and prolonging ejaculation, that will enhance the lovemaking experience for both of you!', 97);
INSERT INTO `products_description` VALUES (4, 1, 'Sex Positions', '170 Pages with high quality pictures showing each position there is!', '', '170 Pages with high quality pictures showing each position there is!', 158);
INSERT INTO `products_description` VALUES (5, 1, 'The Fruit Machine Cheat Code', 'How to legally empty fruit machines! <br>\r\nThis concise ebook was written by someone who used to build fruit machines and covers all the tips and tricks required to win the jackpots!', '', 'How to legally empty fruit machines!', 134);
INSERT INTO `products_description` VALUES (6, 1, 'The Horse Racing Betting System', 'This is a unique betting system guaranteed to earn you any thing from ?10-?1000 + per month. This is a no risk system! The betting industry is very lucrative indeed and you can make some serious money from the right knowledge!', '', 'This is a unique betting system guaranteed to earn you any thing from ?10-?1000 + per month.', 154);
INSERT INTO `products_description` VALUES (8, 1, '1000 Atkins Diet Recipes', 'This E-Book provides you with an extensive range of recipes to be used in conjunction with the acclaimed Dr Atkins Diet.\r\n<p>\r\n<table width="100%" cellspacing="0" cellpadding="0" >\r\n <tr>\r\n <td class=main>\r\n<ul>\r\n<li>Salads \r\n<li>Appetizers & Snacks \r\n<li>Beverages \r\n<li>Cakes & Pies \r\n<li>Desserts \r\n<li>Fish Meals \r\n<li>Pork Meals \r\n<li>Beef, Lamb & Veal \r\n<li>Poultry Meals \r\n<li>Breads & Pastries \r\n<li>Sweets \r\n<li>Biscuits \r\n<li>Eggs & Breakfasts \r\n<li>Sauces & Dips \r\n<li>Soups & Stews\r\n</ul></td>\r\n </tr>\r\n</table>', '', 'This E-Book provides you with an extensive range of recipes to be used in conjunction with the acclaimed Dr Atkins Diet.', 129);
INSERT INTO `products_description` VALUES (7, 1, 'Dr Atkins New Diet Revolution', 'All you''ll ever need to know about the Atkins diet is explaining in this tutorial, including how it works, the right foods to eat, rules of the diet and what goals to set yourself.', '', 'All you''ll ever need to know about the Atkins diet.', 131);
INSERT INTO `products_description` VALUES (59, 1, 'Kids Fun Recipes', 'Make fun and delicious recipes with your family! Kids Fun Recipes is a collection of simple and easy to follow recipes that kids of all ages will enjoy.', '', 'Make fun and delicious recipes with your family! Kids Fun Recipes is a collection of simple and easy to follow recipes that kids of all ages will enjoy.', 3);
INSERT INTO `products_description` VALUES (10, 1, 'Hypnosis Ebook Package', 'Everything you need to learn the art of hypnosis. <br>\r\nFIVE ebooks in one pack.<p>\r\n<table width="100%" cellspacing="0" cellpadding="0" >\r\n <tr>\r\n <td class=main>\r\n<ul>\r\n<li> Hypnosis For Beginners\r\n<li> How To Hypnotize People\r\n<li> Mind Power Seduction Manual\r\n<li> Advanced Hypnosis Techniques\r\n<li> 7 Success Secrets of Hypnotism\r\n\r\n</ul></td>\r\n </tr>\r\n</table>', '', 'Everything you need to learn the art of hypnosis. FIVE ebooks in one pack.', 84);
INSERT INTO `products_description` VALUES (11, 1, 'Weightwatchers Ebook Package', 'FIVE Weightwatchers ebooks in one money saving package.<br>\r\nThis pack contains:<p>\r\n<table width="100%" cellspacing="0" cellpadding="0" >\r\n <tr>\r\n <td class=main>\r\n<ul>\r\n<li> 100 Favourite Weightwatchers Recipes\r\n<li> Weightwatchers Drop Diet Recipes\r\n<li> Weightwatchers Eating Out Guide\r\n<li> Weightwatchers Points Guide\r\n<li> Weightwatchers Points Guide Tracker\r\n</ul></td>\r\n </tr>\r\n</table>', '', 'FIVE Weightwatchers ebooks in one money saving package.', 201);
INSERT INTO `products_description` VALUES (58, 1, '101 Ways To Stop The Money Leak', 'Do You Really Want To Save Money?<br>\r\nLet me show you 101 easy to implement ways you can start plugging all of the money leaks immediately.<br>\r\nNot only will I reveal all of these fantastic money saving tips to you I will also show you where you can save money from a wide variety of sources.', '', 'Do You Really Want To Save Money? Let me show you 101 easy to implement ways you can start plugging all of the money leaks immediately.', 7);
INSERT INTO `products_description` VALUES (14, 1, 'Practical Lessons in Yoga', 'Yoga is an exact science based on certain immutable Laws of Nature. \r\nIt is well known to people of all countries of the world interested in the study of Eastern civilisation and culture, and is held in awe and reverence as it contains in it the master-key to unlock the realms of Peace, Bliss, Mystery and Miracle.\r\n<br>\r\n\r\nLearn all there is to know about Yoga. Packed full of techniques.', '', 'Learn all there is to know about Yoga. Packed full of techniques.', 96);
INSERT INTO `products_description` VALUES (15, 1, 'Credit Secrets Revealed', '<table width="60%" height=150 cellspacing="0" cellpadding="0" >\r\n <tr valign=top>\r\n <td class=main>\r\nWritten by a financial expert, this ebook covers everything about borrowing money, credit checks, bankruptcy, using over peoples money, plus much more!\r\n</td>\r\n </tr>\r\n</table>\r\n\r\n<table width="100%" cellspacing="0" cellpadding="0" >\r\n <tr>\r\n <td class=main>\r\n<ul>\r\nSECTION ONE : Credit Secrets<p>\r\n\r\n<li>1. Save ?000s Off The Cost of Your Mortgage \r\n<li>2. The Secrets of Obtaining a First Class Credit Rating \r\n<li>3. How to Have CCJ''S Legally Removed \r\n<li>4. Raising Thousands in a Matter of Days \r\n<li>5. A Guaranteed Income of ?100,000 In a Year \r\n<li>6. All the Credit Cards You Could Ever Want \r\n<li>7. Virtually Unlimited Finance from Your Credit Cards \r\n<li>8. Finance for Your Business - 100%! \r\n<li>9. "Borrow" Money - That You Don''t Need To Repay \r\n<li>10. A Loan Which is Guaranteed by the Government \r\n<li>11. Huge Profits from Property Deals - \r\nUsing Other Peoples'' Money \r\n\r\n<p>\r\nSECTION TWO : When Credit Becomes A Problem\r\n<p>\r\n<li>12. When Thing Get Out of Hand - The Problems of Repayment \r\n<li>13.The Need To Plan\r\n<li>14. Don''t Make Enemies of Your Creditors \r\n<li>15. Are You Entitled to Help From the State \r\n<li>16. What''s The Worst That Can Happen \r\n<li>17. What About The Future? \r\n<li>18. Professional Help \r\n<li>19. Bankruptcy, The Very Last Resort\r\n(And How To Avoid It) \r\n<p>\r\nSECTION THREE: Special Supplement: Credit With No Credit Checks.\r\n\r\n</ul></td>\r\n </tr>\r\n</table>', '', 'Written by a financial expert, this ebook covers everything about borrowing money, credit checks, bankruptcy, using over peoples money, plus much more!', 112);
INSERT INTO `products_description` VALUES (16, 1, '597 Ready To Use Sales Letters and Business Forms', 'At your fingertips, just about every kind of letter or form you might need for your business, ready for your instant use! With the 597 Business Letters Library you will never be at a loss for words. This easy to use collection provides you with almost any type of business letter you can imagine. Just select the document you need and change the names and address to suit your needs.', '', 'This easy to use collection provides you with almost any type of business letter you can imagine. Just select the document you need and change the names and address to suit your needs.', 98);
INSERT INTO `products_description` VALUES (17, 1, 'Be Your Own Psychic', 'Have you ever wished that you had psychic abilities? <br>\r\nHave you ever wished that you had more control over your mind?<br>\r\n Have you ever wished that you could control your life and destiny?<br>\r\nThen this is a must-read e-Book.', '', 'Have you ever wished that you had psychic abilities? \r\nHave you ever wished that you had more control over your mind?\r\n Have you ever wished that you could control your life and destiny? Then this ebook is for you!', 72);
INSERT INTO `products_description` VALUES (18, 1, 'How To Get The Truth Out Of Anyone', 'In an ideal world, there would be no need for lies. But we live in a world of deception. And, whether you want to play or not, your''e in the game!<br>\r\nThe question is....<br>\r\nDo you want to win?', '', 'Never be lied to again.', 107);
INSERT INTO `products_description` VALUES (19, 1, 'Bread Recipes', 'Are you getting the full benefit from your Bread Machine? <br>\r\nThis e-Book has over 100 bread recipes! <br>\r\nThey can be made in any brand of automated bread machine - they can also be baked in an oven.', '', 'This e-Book has over 100 bread recipes! They can be made in any brand of automated bread machine - they can also be baked in an oven.', 101);
INSERT INTO `products_description` VALUES (20, 1, 'Bread Machine Recipes', 'An amazing selection of bread recipes for bread machines.<br>\r\nEnough to keep any cook busy!', '', 'An amazing selection of bread recipes for bread machines.', 99);
INSERT INTO `products_description` VALUES (28, 1, 'The Fixed Odds Football System', 'Football Matches are a lot easier to predict than Horse Races!\r\nThere are only three possible outcomes, home win - away win - or draw! Football matches are much more likely to go true to form than horse races. Consequently bookmakers have always been very cautious when it comes to Football betting! This ebook shows you how to bet properly.', '', 'How to bet successfully on football matches.', 142);
INSERT INTO `products_description` VALUES (22, 1, 'How To Stop Smoking Forever', 'Have you been wanting to stop smoking, but haven''t really known the right way to stop? What if I told you that within a week from starting this one stop smoking program you could be smoke free forever? Its really not as hard as you may think. In this eBook you will learn how you can be smoke free forever!', '', 'In this eBook you will learn how you can be smoke free forever!', 76);
INSERT INTO `products_description` VALUES (23, 1, 'Gamecube Cheats', 'This e-Book is jam packed with 1000s of cheats, codes, tips and a lot more for 1000s of Gamecube games.', '', 'This e-Book is jam packed with 1000s of cheats, codes, tips and a lot more for 1000s of Gamecube games.', 112);
INSERT INTO `products_description` VALUES (24, 1, 'Playstation 2 Cheats (PS2)', 'This is an excellent collection of PS2 cheat codes, cheats, guides and a whole lot more.', '', 'This is an excellent collection of PS2 cheat codes, cheats, guides and a whole lot more.', 104);
INSERT INTO `products_description` VALUES (25, 1, 'XBox Cheats', 'This e-Book contains 1000s of cheats, guides, codes and much more for the Microsoft Xbox.', '', 'This e-Book contains 1000s of cheats, guides, codes and much more for the Microsoft Xbox.', 83);
INSERT INTO `products_description` VALUES (27, 1, 'The Easy Internet Beginners Guide', 'Everything a beginner needs to know about the internet and how to use it.', '', 'Everything a beginner needs to know about the internet and how to use it.', 115);
INSERT INTO `products_description` VALUES (29, 1, 'How To Be Successful With Women', 'Everything you need to know about being successful with women.', '', 'Everything you need to know about being successful with women.', 111);
INSERT INTO `products_description` VALUES (30, 1, 'Guide To Online Dating', 'Think thousands of people are finding love-matches online? You?re wrong. Every day, MILLIONS of people ? every age, background, race, creed and color ? are using the Internet to meet their mate. What are YOU waiting for?', '', 'Think thousands of people are finding love-matches online? You?re wrong. Every day, MILLIONS of people ? every age, background, race, creed and color ? are using the Internet to meet their mate. What are YOU waiting for?', 118);
INSERT INTO `products_description` VALUES (31, 1, 'Great Tips For Dating Success', 'Think you?re the only one out there trying ? and failing -- to get a date? You?re not alone! And with Dr. Dating?s Great Tips for Dating Success, you won?t ever have to be alone again.', '', 'Think you?re the only one out there trying ? and failing -- to get a date? You?re not alone! And with Dr. Dating?s Great Tips for Dating Success, you won?t ever have to be alone again.', 99);
INSERT INTO `products_description` VALUES (32, 1, 'The Secrets Of Having Great Sex', 'Everything you need to know about how to spice up your time between the sheets!', '', 'Everything you need to know about how to spice up your time between the sheets!', 132);
INSERT INTO `products_description` VALUES (33, 1, 'UFOs And Aliens Guide', 'Loads of information about UFOs. Packed with info, links and video footage.\r\n<p>\r\nBuy this ebook today and get an extra ebook UFO - FBI Top Secret Files absolutely free.', '', 'Loads of information about UFOs. Packed with info, links and video footage.', 95);
INSERT INTO `products_description` VALUES (34, 1, 'How to Make Love All Night (and Drive a Woman Wild)', 'Everything you need to know about making love all night and pleasing your partner.', '', 'Everything you need to know about making love all night and pleasing your partner.', 146);
INSERT INTO `products_description` VALUES (35, 1, 'A Cheap and Easy Guide to Self-publishing eBooks', 'A Cheap and Easy Guide to Self-publishing eBooks is a complete system that will teach you how to self publish an ebook and sell it over the internet.', '', 'A Cheap and Easy Guide to Self-publishing eBooks is a complete system that will teach you how to self publish an ebook and sell it over the internet.', 130);
INSERT INTO `products_description` VALUES (37, 1, 'How to Increase Auction Profits at eBay', 'If you sell ebooks or anything else on auction websites on eBay, this ebok wil show you how to increase your auction profits!', '', 'If you sell ebooks or anything else on auction websites on eBay, this ebok wil show you how to increase your auction profits!', 102);
INSERT INTO `products_description` VALUES (38, 1, 'Directory Of UK Wholesalers', 'A huge directory of hundreds of UK wholesalers, trade websites and dropshippers, where you can buy cheap goods of EVERY category known to man and sell for a profit! This ebook is linked to an online database, so it ALWAYS updates itself. It''s the only UK wholesale guide you''ll ever need!', '', 'A huge directory of UK wholesalers, trade websites and dropshippers, where you can buy cheap goods of EVERY category known to man and sell for a profit!', 92);
INSERT INTO `products_description` VALUES (41, 1, 'Salad Recipes', 'A ebook filled with healthy salad recipes.', '', 'A ebook filled with healthy salad recipes.', 104);
INSERT INTO `products_description` VALUES (42, 1, 'Low Fat Recipes', 'A feast of tasty low fat recipes.', '', 'A feast of tasty low fat recipes.', 129);
INSERT INTO `products_description` VALUES (43, 1, 'How To Build HTML', 'This newly released eBook guides you through the process, step-by-step, of creating your first website from begining to end.<BR>\r\nThis eBook contains 10 chapters with helpful pictures to make learning HTML a breeze!', '', 'This newly released eBook guides you through the process, step-by-step, of creating your first website from begining to end.\r\nThis eBook contains 10 chapters with helpful pictures to make learning HTML a breeze!', 146);
INSERT INTO `products_description` VALUES (44, 1, 'Gambling Systems Revealed', 'Gambling tips and secret systems that casinos don''t want you to know, including tips on card counting, blackjack, roulette and much more.', '', 'Gambling tips and secret systems that casinos don''t want you to know, including tips on card counting, blackjack, roulette and much more.', 152);
INSERT INTO `products_description` VALUES (45, 1, 'Disaster Preparedness Kit', 'Don''t get caught out in a disaster, be prepared for the unlikely. You just never know when disaster will strike, but if it does you will be more then prepared for it with the information this ebook gives you.', '', 'Don''t get caught out in a disaster, be prepared for the unlikely. You just never know when disaster will strike, but if it does you will be more then prepared for it with the information this ebook gives you.', 85);
INSERT INTO `products_description` VALUES (46, 1, 'Home Security - How To Protect Your Home And Family', 'Is your home secure or are you crying out to be burgled? This free book will set you straight and put your mind at ease (includes a fire-safety checklist and a list of great places to hide your valuables).', '', 'Is your home secure or are you crying out to be burgled? This free book will set you straight and put your mind at ease (includes a fire-safety checklist and a list of great places to hide your valuables).', 68);
INSERT INTO `products_description` VALUES (47, 1, 'Chinese Recipes', 'Learn to cook Chinese better than your local takeaway!<br>\r\nEvery recipe you find in this eBook is a genuine Chinese recipe. As such you will obviously get the best results if you use genuine Chinese ingredients.<br>\r\nWe realise that these can often be hard to find, however dont worry. Most of the ingredients can now be found at your local supermarket. If you cant find the ingredients at your local supermarket, try a specialist Deli or considering asking the supermarket if they would be able to get the product for you.', '', 'Learn to cook Chinese better than your local takeaway!', 91);
INSERT INTO `products_description` VALUES (60, 1, '131 Ice Cream Maker Recipes', 'Homemade Ice Cream has not lost any of its good, old-fashioned appeal. In this ebook, there is a delicious homemade ice cream recipe to meet every need: regular, low calorie, sugar free and non-dairy, Anyone can make a homemade ice cream to suit their need.', '', 'Homemade Ice Cream has not lost any of its good, old-fashioned appeal. In this ebook, there is a delicious homemade ice cream recipe to meet every need: regular, low calorie, sugar free and non-dairy, Anyone can make a homemade ice cream to suit their need.', 12);
INSERT INTO `products_description` VALUES (61, 1, 'How To Buy A Car With Little Or No Credit', 'Think you can''t get a car because you have no credit? You need to read this report today!<p>\r\nThis essential report includes:<p>\r\nWhere to Find The Vehicle of Your Choice <br>\r\nMaking the Initial Contact (Common Questions and Answers)<br>\r\nThe Face to Face Presentation <br>\r\nClosing the Deal<br>\r\nPaperwork and Insurance<br>', '', 'Think you can''t get a car because you have no credit? You need to read this report today!', 8);
INSERT INTO `products_description` VALUES (50, 1, 'Close Up Magic Revealed', 'This is a brand new title that was released on the 8th June 2005. Close Up Magic Revealed does exactly what is says. This little treasure comprises of 15 of the most sort after close up tricks.<br>\r\nYou will be the life and soul of any party with the information compiled into this ebook. Every single trick is laid out in a easy to follow step by step guard, including wonderful colour illustrations for each trick!', '', 'Close Up Magic Revealed does exactly what is says. This little treasure comprises of 15 of the most sort after close up tricks.', 76);
INSERT INTO `products_description` VALUES (51, 1, 'David Blaines Mega Magic Guide Book', 'You have seen David Blaine perform amazing street magic on your TV, Now you to can learn how to perform these amazing street magic tricks with our simple to use step by step guide.', '', 'You have seen David Blaine perform amazing street magic on your TV, Now you to can learn how to perform these amazing street magic tricks with our simple to use step by step guide.', 107);
INSERT INTO `products_description` VALUES (52, 1, 'Automate Ebook Sales With Outlook Express', 'If you are selling e-books on eBay, this is for YOU!<br>\r\nGive your customers the service they deserve.<br>\r\nWhen they pay, they don''t want to wait until you come in from work, or wake up in the morning to send them the e-book they ordered at 2am. <br>\r\n\r\nTHEY WANT IT INSTANTLY!<br>\r\n\r\nAuto E-book explains exactly how to set up Outlook Express to send out your e-books to the buyer as soon as they pay you with PayPal.', '', 'Do you sell ebooks? Fed up with manually emailing customers their purchases? This ebook explains exactly how to set up Outlook Express to send out your e-books automatically to the buyer as soon as they pay you with PayPal.', 131);
INSERT INTO `products_description` VALUES (53, 1, 'Ebay The Inside Story', 'This UNIQUE new eBook has been written by two serious contenders who have developed their businesses on eBay after a lot of careful and serious research on both sides of the Atlantic.\r\n<p>\r\nYou now have the chance to purchase their UNIQUE new eBook which will save you months and possibly years of trial and error and probably buying a lot of baloney on the way - Learn from their mistakes and GET IT RIGHT FIRST TIME.\r\n\r\n<p>\r\nSome of the subjects covered are:<p>\r\n<ul>\r\n<li>Learn how to use ebay''s search function in advanced ways you never knew possible to find the best prices. \r\n<li>How to use software to find incorrectly spelt listings that nobody else finds. Be the only bidder and grab a bargain! \r\n<li>Learn all about the ebay toolbar. \r\n<li>Find out about dropshipping and find dropshippers. \r\n<li>Learn all the mistakes we have made so that you don''t waste time making the same mistakes. \r\n<li>We teach you how to make sure your listings get seen and clicked on by potential buyers. \r\n<li>We show you how to make the best use of your listings title and subtitle. Not as simple as you think! \r\n<li>You will learn how to write listing descriptions that will have buyers rushing to the buy now button. \r\n<li>Find out the best day to list your item and what time of day to list. This is really important! \r\n<li>We also teach you how to take great looking pictures for your ebay listings. \r\n<li>Listing upgrades - Are they worth it and when should you use them. \r\n</ul>', '', 'This UNIQUE new eBook has been written by two serious contenders who have developed their businesses on eBay after a lot of careful and serious research on both sides of the Atlantic.', 176);
INSERT INTO `products_description` VALUES (54, 1, '101 Dirty Dumb Blonde Jokes', 'We all love those dirty jokes about oversexed dumb blonde girls! <br>\r\nSo, here we present 101 of them at their dirtiest in one hilarious ebook!<p>\r\nSTRICTLY ADULTS ONLY!', '', 'We all love those dirty jokes about oversexed dumb blonde girls! So, here we present 101 of them at their dirtiest in one hilarious ebook!', 268);
INSERT INTO `products_description` VALUES (55, 1, 'Learn How To Profit From Premium Rate Lines', 'Millions of pounds are made each year in the UK through premium rate services. Learn how you can start your own automated premium rate buiness, providing chat lines, text services, tarot readings and much more with this money making opportunity.<br>\r\nThis ebook shows you how you can achieve this.', '', 'Millions of pounds are made each year in the UK with premium rate services. Learn how you can start your own premium rate buiness, providing chat lines, text services, tarot readings and much more with this automated money making opportunity.', 180);
INSERT INTO `products_description` VALUES (57, 1, '31 Days To Bigger Arms', 'If you want to put Inches on your arms and develop bigger biceps within a month, you must have this!<p>\r\nThis ebook will give you loads of tips on how to build your arm muscles, including exercise, diet recommendations and much more.', '', 'If you want to put Inches on your arms and develop bigger biceps within a month, you must have this!', 8);
INSERT INTO `products_description` VALUES (63, 1, 'PHP Ringtone Website', '<p align="center"><b>This fully functional and fully automated website sells mobile phone ring tones, games, wallpaper, logos, mobile phone wallpaper, polyphonic tones and screensavers.</b>\r\n<p align="center">This site works in conjunction with a company from the Netherlands that supplies \r\nthe mobile content on the site and pays you very well for sales. Signup with \r\nthis company is <b>free</b>. <BR><BR>Once installed the site is fully automated. A \r\ntrusted and respected 3rd party will handle all of the transactions for you and \r\ndeliver the products right to your customers phone. Your job is to promote the \r\nsite. <BR><BR>This item comes with reseller rights so you are free to sell it on \r\nif you wish to. <BR><BR>What else do I need if I want my own ring tone \r\nsite?<BR><BR>1. Web hosting that supports PHP (Unix web server) - We can provide \r\nthis <A href="hosting.shtml">click here</A> for details, we will also configure \r\nyour site free of charge if you choose our hosting<BR> <BR>2. Domain Name - You \r\nmay already have one, if not domain names are cheap and easy to buy, we can help \r\nwith this <BR><BR>What do I need to do if I want my own ring tone \r\nsite?<BR><BR>1. Create an account with the content provider, this is free and \r\neasy <BR>Create a new logo for the site (optional) ** <BR>Edit 2 text files to \r\ncustomize your site ** <BR>Upload your site to your web space ** <BR>Promote \r\nyour new ring tone website <BR>** We do this for free if you choose our \r\nhosting<BR><BR>2. What do I get if I buy this script?<BR><BR>A copy of the PHP \r\nscript that powers the demo site <BR>The contact details for the content \r\nprovider <BR>Any help and support you may need \r\n<BR><BR><A \r\nhref="http://anewshop.co.uk/demoringtonewebsite" target=_blank>Click here to see \r\na demo of the ready made Ringtone Website</A><BR></p>', '', 'This fully functional and fully automated website sells mobile phone ring tones, games, wallpaper, logos, mobile phone wallpaper, polyphonic tones and screensavers.', 61);
INSERT INTO `products_description` VALUES (66, 1, 'PHP WEBSITE SCRIPTS MEGAPACK!', 'This is a great chance for someone wishing to enter the dotcom revolution by selling readymade websites. We usually sell these scripts for a lot more, but we want to allow fellow entrepreneurs on eBay to share in our success. Similar scripts sell for ?10 - ?20+ EACH on eBay. But don''t pay silly prices! Get them all here for a bargain price! The scripts come with Full Re-Sell Rights, so you can make a fortune by either splitting them all up and selling them separately on eBay or simply resell this Megapack. \r\n<p> All scripts come with full installation instructions, so you could even use them yourself! \r\n\r\nHere''s What You Get... </p>\r\n<p> \r\n\r\n Ringtone Website PHP Script (Sell ringtones online - <a href="http://geminiis.com/demoringtonewebsite" target="_blank">Demo</a>) <br>\r\n\r\n Photo Rating Website PHP Script (Your own photo rating website - <a href="http://www.geminiis.com/demoratemyphotowebsite" target="_blank">Demo</a>) <br>\r\n\r\n\r\n Automated Slimming Ebook Website PHP Script (Sell slimming ebooks - <a href="http://geminiis.com/demoslimmingebookwebsite" target="_blank">Demo</a>) <br>\r\n\r\n\r\n Automated Gambling Ebook Website PHP Script (Sell gambling ebooks) <br>\r\n\r\n Dating Website PHP Script (Run your own dating website) <br>\r\n\r\n\r\n Guestbook PHP Script (A guestbook for your website.) <br>\r\n\r\n\r\n FAQ Page PHP Script (A Help and FAQ section for your website) <br>\r\n\r\n\r\n Auction Website PHP Script (your own auction website like eBay) <br>\r\n\r\n\r\n Forum Service Website PHP Script (Start a free forum service for webmasters) <br>\r\n\r\n\r\n Banner Exchange Website PHP Script (Start a banner exchange service for webmasters -\r\n <a href="http://geminiis.com/demobannerexchange" target="_blank">Demo</a>) <br>\r\n\r\n\r\n Classified Ads Website PHP Script (Start a paid classified ads service) <br>\r\n\r\n\r\n Models Portfolio Website PHP Script (Models can create their own portfolios) <br>\r\n\r\n\r\n Real Estate Website PHP Script (Make money from people wanting to sell houses) <br>\r\n\r\n\r\n Jokes Website PHP Script (Start your own jokes website. Users can submit their own jokes)<br>\r\n \r\n \r\n What You Will Also Get... \r\n\r\n A Simple Guide To Search Engine Optimization (an ebook written by webpreneur Mikey J) <br>\r\n \r\n\r\n An eBay Sales Template (a readymade html sales page to sell this megapack on eBay) <br>\r\n\r\n\r\n\r\n <b>\r\n\r\n\r\n\r\nServer Requirements:</b><br>\r\n\r\nIf you want to use them yourself, your web server must have support for PHP. Some of the scripts also require mysql.</p>', '', '14 PHP WEBSITE SCRIPTS! FULL RE-SELL RIGHTS! RESELL FOR A PROFIT!', 47);
INSERT INTO `products_description` VALUES (67, 1, '55 Ready To Start Website Templates', 'By using this package, you''ll have access to 55 ready-to-use webpage layouts. If your curious to see just how fantastic these templates look, here''s just 12 samples of these super web sites for you to see:\r\n\r\nThere as stunning as you''ll ever get and best the best part is that all 55 professional web templates are optimised and researched to increase efficiency!...\r\n<p>Each template is literally ''modified'' in the following ways: <br>\r\n\r\n\r\n(1) The color schemes and style selections have been chosen to attract a greater majority of visitors. <br>\r\n\r\n\r\n(2) The images and graphics on the templates are chosen to appeal almost instantly to your visitors. <br>\r\n\r\n\r\n(3) The layout is designed to be as user-friendly as possible in order to keep your visitors smiling. <br>\r\n(4) Every web template is based upon our ''simplicity to popularity'' theory which means that the average visitor on the internet prefers a simplistic web site instead of a confusing layout. And that what this web solution is about!<br>\r\n\r\n\r\nSo what''s the end result from all this researching and optimization? Simple. Your web template will receive a greater boost of popularity and appeal from any of your visitors and if your selling products, you''ll also boost your sales incredibly!</p>\r\n<p>The Templates Work With Any Web Editor!<br>\r\n\r\nWith these web templates, all you''d be doing is filling in the blank spaces! <br>\r\n\r\nHow easy can you get! It''s Childs Play! And their all built in ''easy-to-use'' HTML Format!<br><br>\r\nSimply once you have filled in the spaces and placed your desired images using your favorite web editor such as Microsoft Frontpage or Macromedia Dreamweaver or over 120 other web editors, and all you have to do is link up the new page(s) to an order form or shopping cart software, upload the saved pages to to your selected web host server, and you''re in business! <br><br>\r\n\r\nSimply put, you can use the templates for anything you please whether its building a powerful two-page mini-site selling a mind-blowing product or a full-fledged content/portal web site, any of these templates can adapt to any sort of web site you have in mind. You can use all of the pages, mix and match pages or just use one or maybe three - it''s totally up to you!<br><br>\r\n</p>', '', 'Quickly & Easily Create Amazing Professional \r\nWeb Sites With 55 Ready-To-Start Templates \r\nYou Can Use Right Now... With Full Resell Rights.....', 10);
INSERT INTO `products_description` VALUES (68, 1, '100 Ready To Use Website templates', '100 Websites In a Box...<br>\r\n\r\nWhat you get is 100+ good looking Professional Webpage templates...WITH FULL RESELL RIGHTS...<br><br>\r\n\r\n\r\nWhy would you want to pay a lot for a website when you can use these 100+ Webpage templates to create professional looking websites for only pennies! 100+ Web templates allow you to have your website up and running in a matter of minutes!\r\n<br><br>\r\nMix and match for unlimited possiblilities!<br>\r\n<br>\r\n\r\nThis is one of the best deals on webpage templates ever put together! You''re sure to find more than one design you like... and here you can have them all for one super low price! <br>\r\n<br>\r\nThis package also comes with Full Master Resell Rights! Use the templates yourself and, or resell them for 100% Profit. For Resellers we''ll even throw in a copy of this website for you to use!<br>\r\n<br>\r\nThis is a must Have for anyone wanting to get their own website up a running easily and keep their site looking professional...<br>\r\n<br><br>\r\n<img border="0" src="images/100.gif">\r\n<img border="0" src="images/71.gif">\r\n<img border="0" src="images/86.gif"><br>\r\n<img border="0" src="images/69.gif">\r\n<img border="0" src="images/80.gif">\r\n<img border="0" src="images/73.gif"><br><br><br>', '', 'Why would you want to pay a lot for a website when you can use these 100+ Webpage templates to create professional looking websites for only pennies! 100+ Web templates allow you to have your website up and running in a matter of minutes!', 18);
INSERT INTO `products_description` VALUES (69, 1, 'The 90 Day Powerseller Challenge.....', 'The Reward? - Powerseller status and respect in the eBay community<br>\r\n\r\nDetails: <br><br>\r\nThe author of this E-Book is an eBay TITANIUM POWERSELLER. This is the highest eBay powerseller ranking. If you choose to buy this E-Book from me he will show you exactly how he does it. He hides nothing and his eBay feedback is there for all to see.<br><br>\r\n\r\nSo what does this person sell??? E-Books... Yes E-Books... E-Books are probably the best and fastest selling items on eBay. If you would like to find out the secrets most powersellers don''t know then buy this E-Book.<br><br>\r\n\r\nIt really is that simple, buy this E-Book and you will be a powerseller in 90 days or less. <br><br>\r\n\r\nMost of the people who read this web page will do absolutely NOTHING with the information on it. Consequently, they will be no better off tomorrow than they are today.\r\nDon''t be that person!<br><br>', '', 'The Challenge? - To become an eBay powerseller in 90 days or less!', 36);
INSERT INTO `products_description` VALUES (71, 1, 'Debt Consolidation Advice eBook', '1. Introduction to Debt <br>\r\n2. Short Term Debt Problems <br>\r\n3. Long Term Debt Problems<br>\r\n4. Why is My Credit Score so Low?<br>\r\n5. How to Steer Clear of Debt<br>\r\n6. Removing a County Court Judgement (CCJ)<br>\r\n7. Expenditure Check List<br><br>\r\n\r\n\r\nThis eBook will tell you the facts about Debt Consolidation and allow you to make an educated decision if you are considering consolidating your debts.\r\n\r\n<br>\r\n\r\nIncludes Full Resell Rights.\r\n\r\n <br>\r\n<br><br><br>', '', 'Debt Consolidation Advice eBook', 35);
INSERT INTO `products_description` VALUES (72, 1, 'Google Sitemap Maker - Get listed free and fast', '<p align="center"><b>I am about to show you a way that you can get your web sites listed in Google lightening time!<br>\r\n\r\nIt has always seemed like such a mystery but now there is an easier way... List as many sites as you want!\r\nGoogle is the 1st step in getting the traffic you need and deserve!\r\n<br></b><br>\r\n\r\nThere?s a lot of money to be made on the web?you know, I know it, everyone knows it. \r\n\r\nBut even if you have the most incredible web pages ever, it?s no good if people can?t find them.\r\n<p align="center"><b>That?s why you need a Google site map.</b> <br>\r\n\r\nGoogle site maps let people find every page you have quickly and easily.<br>\r\n\r\nBut to make a Google site map you have to install a script onto your web site, and then try to get that script to run, right?<br>\r\n\r\nLet me ask you something: how much time do you spend hassling with scripts that are supposed to make Google site maps for you? Too much?<br>\r\n\r\nYeah, me too. Those stupid scripts never seemed to work right and I was spending half my day sometimes trying to sort them out. I?d install them on my site, then experience massive frustration trying to get them to run.<br>\r\n\r\nBut what if you didn?t have to deal with site-based scripts? <br>\r\n\r\nWhat if you could make Google site maps quickly and easily off your PC desktop?<br>\r\n\r\nIf you?d like to save yourself time and frustration, this will be one of the most important messages you?ll ever read.<br>\r\n\r\n<b><br>\r\n\r\nHere?s what Google site maps do for you?<br>\r\n\r\n</b>\r\n\r\n? Help people find more of your web pages, since they give you better crawl coverage.<br>\r\n\r\n? Make sure that when people search on your keywords they get fresher search results.<br>\r\n\r\n? Let you provide specific information to Google concerning your web pages, like when a page was last modified \r\nor how frequently it changes.<br>\r\n\r\n? Get your web pages crawled by Google quickly without having to know some secret back door into the search \r\nengines like many of those SEO guys will try to sell you packages for.<br>\r\n\r\n\r\n<b><br>\r\n\r\n\r\nSound too good to be true? Well, Google Site Map Maker actually does just that!</b><br>\r\n\r\n\r\nIntroducing ?Google Site Map Maker?<br>\r\n\r\nHere, for the very first time ever, is an incredible piece of software that RUNS ON YOUR PC?S DESKTOP and makes Google\r\n site maps for you!<br>\r\n\r\nIt doesn?t matter if you?re a beginner or pro site developer?with ?Google Site Map Maker? you?ll be able \r\nto produce your own Google site maps anytime you need them. <br>\r\n\r\nHere?s How ?Google Site Map Maker? Works?.<br>\r\n\r\nLet?s say you want to make a Google site map.<br>\r\n</p>\r\n<p align="center"><b>\r\nStart Google Site Map Maker-<br>\r\n\r\n</b>\r\n\r\nStep 1. Enter The URL of the website you wish to create a site map for. Google Site Map Maker will then crawl that site and make a list of all the links it can find.<br>\r\n\r\nStep2. Set a few features like how often your site content changes, this will help tell Goggle how often it should crawl your site! <br>\r\n\r\nStep 3. If there are any URL''s on your site you do not wish to have included into Goggle then list them in the bypass area so they will not be crawled and posted to your site map, you can also select file types to bypass such as .zip or .exe<br>\r\n\r\nStep 4. You can optionally add your sites FTP information and if you ask Google Site Map Maker to it will automatically upload your site map for you .<br>\r\n\r\nStep 5. Spider your site....<br>\r\n\r\n<b><br>\r\n\r\n Google site Map Maker will<br>\r\n\r\n</b>\r\n\r\n Spider your web site-<br>\r\n\r\n Create a site map for your site<br>\r\n\r\n Save a copy of that site map to a selected folder on your PC<br>\r\n\r\n Upload a copy of your site map to yourdomain.com/sitemap.gz<br>\r\n\r\n Thats right .gz the preferred Google Site Map format, it will zip and upload the site map for you.<br>\r\n\r\nBut wait we are not done yet! After this process has been completed Google Site Map Maker will then ping Google and tell them you have a new site pam ready to be crawled!<br>\r\n\r\n\r\nAll you have to do is download the software, follow the user guide, and PRESTO?you?ve got a Google site map!<br>\r\n\r\n\r\nIs that powerful or what!<br>\r\n\r\nPicture this: you make Google site maps for all your sites quickly and easily. You submit them. Then you get huge hits?enough that you''re catapulted to the top of the search engines. Now you''re down at the bank cashing a big, juice check. Feels good, doesn''t it?<br>\r\n<br>\r\n\r\n<b>\r\n\r\nThat''s the power of having ?Google Site Map Maker? on your computer. <br>\r\n\r\n</b>\r\n\r\nWhat''s more, you can download this software instantly and it works on any PC computer. You''ll have your copy downloaded in less than 3 minutes. This way there''s no waiting around for the postman to come with your box and no bothering with driving to a store. <br>\r\n\r\nIf you''d like to put this resource to use now just click here to order . Or if you''d like to learn more just keep reading? <br>\r\n\r\n<b>\r\n\r\nNow anyone can placed in the biggest search engine on the net ? it''s easy!<br>\r\n\r\n</b></p>', '', 'Are You Sick And Tired Of Trying To Figure Out The Secret Formula Of Getting Listed In Google?', 15);
INSERT INTO `products_description` VALUES (74, 1, 'Membership Site Manager', '<p align="center"><b>Now you can generate recurring income month after month with a membership\r\nsite!...</b>\r\n<p align="center"><br>\r\n\r\n"Incredible New Software Lets You Run A Money-Making Membership Site, On 100% Autopilot!?\r\n<br>\r\n\r\nRun A Subscription Site Like The Internet Marketing Pros <br>\r\n\r\n? Generate Recurring Income, Month After Month <br>\r\n\r\n? Get Paid Without Having To Set Up A Merchant Account <br>\r\n\r\n? Automatically Manage All Your Subscription Accounts</p>\r\n<p align="center">\r\n<br>\r\n\r\nWouldn''t it be great if you could run your very own high-dollar subscription web site?<br>\r\n\r\nYou know the ones I mean - where you sign up for a subscription so you can read the really good stuff, or download new software every month with resell rights... Money just pours into those sites, doesn?t it?<br>\r\n\r\nBut it costs plenty for the script to run a site like that, right? Everyone know that''s ever looked into it that it''s very expensive to get started with a real membership web site of your own.\r\n<b>\r\n\r\nNOT ANY MORE!</b> <br>\r\n\r\nI?ve got good news - there?s a brand new resource available just for people who want to quickly and easily manage a subscription site without spending a fortune to do it.<br>\r\n\r\nYes, it?s true and you won?t believe how simple it really is to manage a site once you?ve got the right\r\ntools - affordable tools, I might add. <br>\r\n\r\n\r\nIt''s All Possible And Inexpensive With A Hot New Script Called\r\nMembership Site Manager<br>\r\n\r\nWell, let me give you just a list of a few things this amazing script does: <br>\r\n\r\n Automatically creates accounts<br>\r\n\r\n Automatically Suspends delinquent accounts <br>\r\n\r\n Takes recurring subscription payment over PayPal<br>\r\n\r\n Automatic Account Setup <br>\r\n\r\n Brings you steady monthly income! <br>\r\n<b>\r\n\r\n And lots more? <br>\r\n</b>\r\n\r\n\r\nJust think! You?ll be up and running with your own membership site on the Internet so fast it will make your head spin watching all those recurring funds come in!</p>', '', 'Now you can generate recurring income month after month with a membership site?without paying thousands for a management script!...', 51);
INSERT INTO `products_description` VALUES (75, 1, 'Article Page Machine', '<p align="center"><b>Turn Any Text Into A Search Engine Friendly Web Page In Seconds!</b>\r\n<p align="center">Introducing Article Page Machine \r\n\r\nThis incredibly simple to use software allows you to convert any text article or data into a search engine friendly web page in seconds.&nbsp;</p>\r\n<p align="center">\r\n\r\nNo HTML knowledge required\r\n\r\nSimply enter a few details and in less than half a dozen mouse clicks you have a perfectly formatted web page.\r\n\r\n \r\n\r\nYou can control table sizes, border thickness, background colours to match your existing web pages.&nbsp;</p>\r\n<p align="center">\r\n\r\nEdit and Change titles, sub headlines and paste in fresh content at the click of a button. You can also preview your created pages before saving them.&nbsp;</p>\r\n<p align="center">\r\n\r\nWith Article Page Machine''s excellent save template feature you can create dozens of new web pages in just a few minutes - Great for use with software like CB Text Ad Generator or Adsense and simple enough for anyone to use. \r\n\r\nDon''t miss out on this incredible offer.&nbsp;</p>\r\n<p align="center"> If you''ve ever laboured over web page creation then suffer no more, get Article Page Machine today and start turning your text and content files into web pages with ease in the next few minutes!</p>', '', 'Turn Any Text Article Into A Search Engine Friendly Web Page In Seconds!', 11);
INSERT INTO `products_description` VALUES (78, 1, 'Internet Marketing eBook', 'Internet marketing, how do these guys do it?<br>\r\n Well I will try to give you an insight into the way this all happens. As mentioned in the contents above I will delve into the main tools of the internet marketer and the way these guys generate cash from their internet marketing businesses. <br><br>\r\n\r\nContents<br>\r\n\r\n1. Introduction<br>\r\n\r\n2. I.M. with e-books<br>\r\n\r\n3. Affiliate programs<br>\r\n\r\n4. Newsletters<br>\r\n\r\n5. Google Adsense/Adwords<br>\r\n\r\n6. Traffic Generators<br>\r\n\r\n7. Auto-responders\r\n<br>\r\n\r\n<br>\r\n\r\nIncludes Full Resell Rights.\r\n\r\n <br>', '', 'Internet marketing, how do these guys do it? Well I will try to give you an insight into the way this all happens. As mentioned in the contents I will delve into the main tools of the internet marketer and the way these guys generate cash from their internet marketing businesses.', 10);
INSERT INTO `products_description` VALUES (79, 1, 'Mortgages the Complete Guide eBook', '<br>\r\n1. Choosing a Mortgage <br>\r\n\r\n2. Affordability <br>\r\n\r\n3. Types of Mortgage <br>\r\n\r\n4. Types of Interest Rate <br>\r\n\r\n5. Flexible Mortgages <br>\r\n\r\n6. Mortgage Check List <br>\r\n <br>\r\n\r\nIncludes Full Resell Rights.\r\n\r\n <br>', '', '', 8);

-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `products_notifications`
--


-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `products_options`
--

INSERT INTO `products_options` VALUES (1, 1, 'Format');

-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `products_options_values`
--

INSERT INTO `products_options_values` VALUES (1, 1, 'Download');

-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `products_options_values_to_products_options`
--

INSERT INTO `products_options_values_to_products_options` VALUES (1, 1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `products_to_categories`
--

INSERT INTO `products_to_categories` VALUES (1, 1);
INSERT INTO `products_to_categories` VALUES (2, 1);
INSERT INTO `products_to_categories` VALUES (3, 1);
INSERT INTO `products_to_categories` VALUES (4, 1);
INSERT INTO `products_to_categories` VALUES (5, 4);
INSERT INTO `products_to_categories` VALUES (5, 8);
INSERT INTO `products_to_categories` VALUES (6, 8);
INSERT INTO `products_to_categories` VALUES (6, 9);
INSERT INTO `products_to_categories` VALUES (6, 12);
INSERT INTO `products_to_categories` VALUES (7, 3);
INSERT INTO `products_to_categories` VALUES (7, 5);
INSERT INTO `products_to_categories` VALUES (7, 10);
INSERT INTO `products_to_categories` VALUES (8, 3);
INSERT INTO `products_to_categories` VALUES (8, 5);
INSERT INTO `products_to_categories` VALUES (8, 10);
INSERT INTO `products_to_categories` VALUES (10, 18);
INSERT INTO `products_to_categories` VALUES (11, 3);
INSERT INTO `products_to_categories` VALUES (11, 5);
INSERT INTO `products_to_categories` VALUES (11, 10);
INSERT INTO `products_to_categories` VALUES (14, 3);
INSERT INTO `products_to_categories` VALUES (14, 20);
INSERT INTO `products_to_categories` VALUES (15, 7);
INSERT INTO `products_to_categories` VALUES (16, 6);
INSERT INTO `products_to_categories` VALUES (17, 17);
INSERT INTO `products_to_categories` VALUES (18, 19);
INSERT INTO `products_to_categories` VALUES (19, 5);
INSERT INTO `products_to_categories` VALUES (20, 5);
INSERT INTO `products_to_categories` VALUES (22, 3);
INSERT INTO `products_to_categories` VALUES (22, 19);
INSERT INTO `products_to_categories` VALUES (23, 4);
INSERT INTO `products_to_categories` VALUES (24, 4);
INSERT INTO `products_to_categories` VALUES (25, 4);
INSERT INTO `products_to_categories` VALUES (27, 13);
INSERT INTO `products_to_categories` VALUES (28, 8);
INSERT INTO `products_to_categories` VALUES (28, 12);
INSERT INTO `products_to_categories` VALUES (29, 1);
INSERT INTO `products_to_categories` VALUES (29, 11);
INSERT INTO `products_to_categories` VALUES (30, 1);
INSERT INTO `products_to_categories` VALUES (30, 11);
INSERT INTO `products_to_categories` VALUES (31, 1);
INSERT INTO `products_to_categories` VALUES (31, 11);
INSERT INTO `products_to_categories` VALUES (32, 1);
INSERT INTO `products_to_categories` VALUES (33, 17);
INSERT INTO `products_to_categories` VALUES (34, 1);
INSERT INTO `products_to_categories` VALUES (35, 6);
INSERT INTO `products_to_categories` VALUES (35, 9);
INSERT INTO `products_to_categories` VALUES (37, 6);
INSERT INTO `products_to_categories` VALUES (37, 9);
INSERT INTO `products_to_categories` VALUES (38, 6);
INSERT INTO `products_to_categories` VALUES (38, 9);
INSERT INTO `products_to_categories` VALUES (41, 5);
INSERT INTO `products_to_categories` VALUES (42, 5);
INSERT INTO `products_to_categories` VALUES (42, 10);
INSERT INTO `products_to_categories` VALUES (42, 20);
INSERT INTO `products_to_categories` VALUES (43, 14);
INSERT INTO `products_to_categories` VALUES (44, 8);
INSERT INTO `products_to_categories` VALUES (45, 19);
INSERT INTO `products_to_categories` VALUES (46, 19);
INSERT INTO `products_to_categories` VALUES (47, 5);
INSERT INTO `products_to_categories` VALUES (50, 15);
INSERT INTO `products_to_categories` VALUES (51, 15);
INSERT INTO `products_to_categories` VALUES (52, 6);
INSERT INTO `products_to_categories` VALUES (52, 9);
INSERT INTO `products_to_categories` VALUES (52, 13);
INSERT INTO `products_to_categories` VALUES (52, 19);
INSERT INTO `products_to_categories` VALUES (53, 19);
INSERT INTO `products_to_categories` VALUES (54, 16);
INSERT INTO `products_to_categories` VALUES (55, 6);
INSERT INTO `products_to_categories` VALUES (55, 9);
INSERT INTO `products_to_categories` VALUES (57, 20);
INSERT INTO `products_to_categories` VALUES (58, 7);
INSERT INTO `products_to_categories` VALUES (59, 5);
INSERT INTO `products_to_categories` VALUES (60, 5);
INSERT INTO `products_to_categories` VALUES (61, 7);
INSERT INTO `products_to_categories` VALUES (63, 23);
INSERT INTO `products_to_categories` VALUES (66, 23);
INSERT INTO `products_to_categories` VALUES (67, 29);
INSERT INTO `products_to_categories` VALUES (68, 29);
INSERT INTO `products_to_categories` VALUES (69, 9);
INSERT INTO `products_to_categories` VALUES (71, 7);
INSERT INTO `products_to_categories` VALUES (72, 30);
INSERT INTO `products_to_categories` VALUES (74, 23);
INSERT INTO `products_to_categories` VALUES (75, 30);
INSERT INTO `products_to_categories` VALUES (78, 9);
INSERT INTO `products_to_categories` VALUES (79, 7);

-- --------------------------------------------------------

--
-- Table structure for table `products_xsell`
--

CREATE TABLE `products_xsell` (
`ID` int(10) NOT NULL auto_increment,
`products_id` int(10) unsigned NOT NULL default '1',
`xsell_id` int(10) unsigned NOT NULL default '1',
`sort_order` int(10) unsigned NOT NULL default '1',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `products_xsell`
--


-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `reviews`
--


-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `reviews_description`
--


-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` VALUES ('1a9357259b535f643ef7f201ca81aa7e', 1142555503, 'cart|O:12:"shoppingcart":4:{s:8:"contents";a:0:{} s:5:"total";i:0;s:6:"weight";i:0;s:12:"content_typ e";b:0;}language|s:7:"english";languages_id|s:1:"1 ";currency|s:3:"GBP";navigation|O:17:"navigationhi story":2:{s:4:"path";a:1:{i:0;a:4:{s:4:"page";s:9: "index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1: {s:5:"cPath";s:2:"23";}s:4:"post";a:0:{ } s:8:"sna pshot";a:0:{ } }');
INSERT INTO `sessions` VALUES ('b988e539af6cc2a0857738b8d5f38ac9', 1142554605, 'cart|O:12:"shoppingcart":4:{s:8:"contents";a:0:{} s:5:"total";i:0;s:6:"weight";i:0;s:12:"content_typ e";b:0;}language|s:7:"english";languages_id|s:1:"1 ";currency|s:3:"GBP";navigation|O:17:"navigationhi story":2:{s:4:"path";a:1:{i:0;a:4:{s:4:"page";s:11 :"product.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a :1:{s:11:"products_id";s:2:"62";}s:4:"post";a:0:{} } }s:8:"snapshot";a:0:{ } }');
INSERT INTO `sessions` VALUES ('bcb3ddf8b22b5ce845d12ce8b4154c86', 1142539372, 'language|s:7:"english";languages_id|s:1:"1";selec ted_box|s:13:"configuration";current_path|s:26:"/home/geminiin/public_html";');
INSERT INTO `sessions` VALUES ('9a8b89e9e7a9be88a91662ba535967a5', 1142539433, '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";lang uages_id|s:1:"1";currency|s:3:"GBP";navigation|O:1 7:"navigationhistory":2:{s:4:"path";a:1:{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:{ } s:8:"snapshot" ;a:0:{ } }');
INSERT INTO `sessions` VALUES ('2150b9a2d61a4834d04bedf37ada1216', 1142577609, 'cart|O:12:"shoppingcart":4:{s:8:"contents";a:0:{} s:5:"total";i:0;s:6:"weight";i:0;s:12:"content_typ e";b:0;}language|s:7:"english";languages_id|s:1:"1 ";currency|s:3:"GBP";navigation|O:17:"navigationhi story":2:{s:4:"path";a:1:{i:0;a:4:{s:4:"page";s:11 :"product.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a :1:{s:11:"products_id";s:2:"62";}s:4:"post";a:0:{} } }s:8:"snapshot";a:0:{ } }');
INSERT INTO `sessions` VALUES ('9c00fbb10e2891456be3726b08c4d214', 1142580840, 'cart|O:12:"shoppingcart":4:{s:8:"contents";a:0:{} s:5:"total";i:0;s:6:"weight";i:0;s:12:"content_typ e";b:0;}language|s:7:"english";languages_id|s:1:"1 ";currency|s:3:"GBP";navigation|O:17:"navigationhi story":2:{s:4:"path";a:1:{i:0;a:4:{s:4:"page";s:9: "index.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a:1: {s:5:"cPath";s:2:"23";}s:4:"post";a:0:{ } s:8:"sna pshot";a:0:{ } }');
INSERT INTO `sessions` VALUES ('85aa770d12534c294e1aa588368afaa6', 1142607087, 'cart|O:12:"shoppingcart":4:{s:8:"contents";a:0:{} s:5:"total";i:0;s:6:"weight";i:0;s:12:"content_typ e";b:0;}language|s:7:"english";languages_id|s:1:"1 ";currency|s:3:"GBP";navigation|O:17:"navigationhi story":2:{s:4:"path";a:1:{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:{ } s:8:"snapshot";a:0:{ } }');
INSERT INTO `sessions` VALUES ('f034270afda6f5c9171cf3f26780dd41', 1142620047, '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";lang uages_id|s:1:"1";currency|s:3:"GBP";navigation|O:1 7:"navigationhistory":2:{s:4:"path";a:1:{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:{ } s:8:"snapshot" ;a:0:{ } }');
INSERT INTO `sessions` VALUES ('40994bf0b2dc66444f8947cc107ddc1c', 1142621333, 'language|s:7:"english";languages_id|s:1:"1";selec ted_box|s:7:"catalog";');
INSERT INTO `sessions` VALUES ('4c7955b103a61351ec6f4e931dce3276', 1142619745, 'cart|O:12:"shoppingcart":4:{s:8:"contents";a:0:{} s:5:"total";i:0;s:6:"weight";i:0;s:12:"content_typ e";b:0;}language|s:7:"english";languages_id|s:1:"1 ";currency|s:3:"GBP";navigation|O:17:"navigationhi story":2:{s:4:"path";a:1:{i:0;a:4:{s:4:"page";s:11 :"product.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a :1:{s:11:"products_id";s:1:"6";}s:4:"post";a:0:{ } } }s:8:"snapshot";a:0:{ } }');
INSERT INTO `sessions` VALUES ('09babae11ad19ec4ee53ced937beabee', 1142619823, 'cart|O:12:"shoppingcart":4:{s:8:"contents";a:0:{} s:5:"total";i:0;s:6:"weight";i:0;s:12:"content_typ e";b:0;}language|s:7:"english";languages_id|s:1:"1 ";currency|s:3:"GBP";navigation|O:17:"navigationhi story":2:{s:4:"path";a:1:{i:0;a:4:{s:4:"page";s:11 :"product.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a :1:{s:11:"products_id";s:2:"13";}s:4:"post";a:0:{} } }s:8:"snapshot";a:0:{ } }');
INSERT INTO `sessions` VALUES ('fa629b09ca92436990fac857cc78e529', 1142619843, 'cart|O:12:"shoppingcart":4:{s:8:"contents";a:0:{} s:5:"total";i:0;s:6:"weight";i:0;s:12:"content_typ e";b:0;}language|s:7:"english";languages_id|s:1:"1 ";currency|s:3:"GBP";navigation|O:17:"navigationhi story":2:{s:4:"path";a:1:{i:0;a:4:{s:4:"page";s:11 :"product.php";s:4:"mode";s:6:"NONSSL";s:3:"get";a :1:{s:11:"products_id";s:2:"33";}s:4:"post";a:0:{} } }s:8:"snapshot";a:0:{ } }');
INSERT INTO `sessions` VALUES ('5049f3f6820393c4a732da06240ca925', 1142620346, 'language|s:7:"english";languages_id|s:1:"1";selec ted_box|s:7:"catalog";');

-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `specials`
--

INSERT INTO `specials` VALUES (9, 43, 0.4500, '2006-03-13 16:18:56', NULL, '0000-00-00 00:00:00', NULL, 1);
INSERT INTO `specials` VALUES (7, 78, 0.4500, '2006-03-11 18:30:50', NULL, '0000-00-00 00:00:00', NULL, 1);
INSERT INTO `specials` VALUES (8, 79, 0.4500, '2006-03-12 18:53:56', NULL, '0000-00-00 00:00:00', NULL, 1);
INSERT INTO `specials` VALUES (10, 69, 0.4500, '2006-03-13 16:20:22', NULL, '0000-00-00 00:00:00', NULL, 1);
INSERT INTO `specials` VALUES (11, 71, 0.4500, '2006-03-13 16:21:04', NULL, '0000-00-00 00:00:00', NULL, 1);

-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tax_class`
--

INSERT INTO `tax_class` VALUES (1, 'USA Sales Tax', 'USA States', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `tax_class` VALUES (2, 'VAT Taxable Goods', 'European countries', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tax_rates`
--


-- --------------------------------------------------------

--
-- Table structure for table `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 ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `whos_online`
--

INSERT INTO `whos_online` VALUES (0, 'Guest', '4c7955b103a61351ec6f4e931dce3276', '66.249.66.99', '1142618305', '1142618305', '/product.php?products_id=6');
INSERT INTO `whos_online` VALUES (0, 'Guest', 'f034270afda6f5c9171cf3f26780dd41', '84.83.6.88', '1142618297', '1142618607', '/');
INSERT INTO `whos_online` VALUES (0, 'Guest', '09babae11ad19ec4ee53ced937beabee', '66.249.66.99', '1142618383', '1142618383', '/product.php?products_id=13');
INSERT INTO `whos_online` VALUES (0, 'Guest', 'fa629b09ca92436990fac857cc78e529', '66.249.66.99', '1142618403', '1142618403', '/product.php?products_id=33');
INSERT INTO `whos_online` VALUES (0, 'Guest', '', '66.249.66.99', '1142618563', '1142618563', '/index.php');

-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=369 ;

--
-- Dumping data for table `zones`
--

INSERT INTO `zones` VALUES (1, 223, 'AL', 'Alabama');
INSERT INTO `zones` VALUES (2, 223, 'AK', 'Alaska');
INSERT INTO `zones` VALUES (3, 223, 'AS', 'American Samoa');
INSERT INTO `zones` VALUES (4, 223, 'AZ', 'Arizona');
INSERT INTO `zones` VALUES (5, 223, 'AR', 'Arkansas');
INSERT INTO `zones` VALUES (6, 223, 'AF', 'Armed Forces Africa');
INSERT INTO `zones` VALUES (7, 223, 'AA', 'Armed Forces Americas');
INSERT INTO `zones` VALUES (8, 223, 'AC', 'Armed Forces Canada');
INSERT INTO `zones` VALUES (9, 223, 'AE', 'Armed Forces Europe');
INSERT INTO `zones` VALUES (10, 223, 'AM', 'Armed Forces Middle East');
INSERT INTO `zones` VALUES (11, 223, 'AP', 'Armed Forces Pacific');
INSERT INTO `zones` VALUES (12, 223, 'CA', 'California');
INSERT INTO `zones` VALUES (13, 223, 'CO', 'Colorado');
INSERT INTO `zones` VALUES (14, 223, 'CT', 'Connecticut');
INSERT INTO `zones` VALUES (15, 223, 'DE', 'Delaware');
INSERT INTO `zones` VALUES (16, 223, 'DC', 'District of Columbia');
INSERT INTO `zones` VALUES (17, 223, 'FM', 'Federated States Of Micronesia');
INSERT INTO `zones` VALUES (18, 223, 'FL', 'Florida');
INSERT INTO `zones` VALUES (19, 223, 'GA', 'Georgia');
INSERT INTO `zones` VALUES (20, 223, 'GU', 'Guam');
INSERT INTO `zones` VALUES (21, 223, 'HI', 'Hawaii');
INSERT INTO `zones` VALUES (22, 223, 'ID', 'Idaho');
INSERT INTO `zones` VALUES (23, 223, 'IL', 'Illinois');
INSERT INTO `zones` VALUES (24, 223, 'IN', 'Indiana');
INSERT INTO `zones` VALUES (25, 223, 'IA', 'Iowa');
INSERT INTO `zones` VALUES (26, 223, 'KS', 'Kansas');
INSERT INTO `zones` VALUES (27, 223, 'KY', 'Kentucky');
INSERT INTO `zones` VALUES (28, 223, 'LA', 'Louisiana');
INSERT INTO `zones` VALUES (29, 223, 'ME', 'Maine');
INSERT INTO `zones` VALUES (30, 223, 'MH', 'Marshall Islands');
INSERT INTO `zones` VALUES (31, 223, 'MD', 'Maryland');
INSERT INTO `zones` VALUES (32, 223, 'MA', 'Massachusetts');
INSERT INTO `zones` VALUES (33, 223, 'MI', 'Michigan');
INSERT INTO `zones` VALUES (34, 223, 'MN', 'Minnesota');
INSERT INTO `zones` VALUES (35, 223, 'MS', 'Mississippi');
INSERT INTO `zones` VALUES (36, 223, 'MO', 'Missouri');
INSERT INTO `zones` VALUES (37, 223, 'MT', 'Montana');
INSERT INTO `zones` VALUES (38, 223, 'NE', 'Nebraska');
INSERT INTO `zones` VALUES (39, 223, 'NV', 'Nevada');
INSERT INTO `zones` VALUES (40, 223, 'NH', 'New Hampshire');
INSERT INTO `zones` VALUES (41, 223, 'NJ', 'New Jersey');
INSERT INTO `zones` VALUES (42, 223, 'NM', 'New Mexico');
INSERT INTO `zones` VALUES (43, 223, 'NY', 'New York');
INSERT INTO `zones` VALUES (44, 223, 'NC', 'North Carolina');
INSERT INTO `zones` VALUES (45, 223, 'ND', 'North Dakota');
INSERT INTO `zones` VALUES (46, 223, 'MP', 'Northern Mariana Islands');
INSERT INTO `zones` VALUES (47, 223, 'OH', 'Ohio');
INSERT INTO `zones` VALUES (48, 223, 'OK', 'Oklahoma');
INSERT INTO `zones` VALUES (49, 223, 'OR', 'Oregon');
INSERT INTO `zones` VALUES (50, 223, 'PW', 'Palau');
INSERT INTO `zones` VALUES (51, 223, 'PA', 'Pennsylvania');
INSERT INTO `zones` VALUES (52, 223, 'PR', 'Puerto Rico');
INSERT INTO `zones` VALUES (53, 223, 'RI', 'Rhode Island');
INSERT INTO `zones` VALUES (54, 223, 'SC', 'South Carolina');
INSERT INTO `zones` VALUES (55, 223, 'SD', 'South Dakota');
INSERT INTO `zones` VALUES (56, 223, 'TN', 'Tennessee');
INSERT INTO `zones` VALUES (57, 223, 'TX', 'Texas');
INSERT INTO `zones` VALUES (58, 223, 'UT', 'Utah');
INSERT INTO `zones` VALUES (59, 223, 'VT', 'Vermont');
INSERT INTO `zones` VALUES (60, 223, 'VI', 'Virgin Islands');
INSERT INTO `zones` VALUES (61, 223, 'VA', 'Virginia');
INSERT INTO `zones` VALUES (62, 223, 'WA', 'Washington');
INSERT INTO `zones` VALUES (63, 223, 'WV', 'West Virginia');
INSERT INTO `zones` VALUES (64, 223, 'WI', 'Wisconsin');
INSERT INTO `zones` VALUES (65, 223, 'WY', 'Wyoming');
INSERT INTO `zones` VALUES (66, 38, 'AB', 'Alberta');
INSERT INTO `zones` VALUES (67, 38, 'BC', 'British Columbia');
INSERT INTO `zones` VALUES (68, 38, 'MB', 'Manitoba');
INSERT INTO `zones` VALUES (69, 38, 'NF', 'Newfoundland');
INSERT INTO `zones` VALUES (70, 38, 'NB', 'New Brunswick');
INSERT INTO `zones` VALUES (71, 38, 'NS', 'Nova Scotia');
INSERT INTO `zones` VALUES (72, 38, 'NT', 'Northwest Territories');
INSERT INTO `zones` VALUES (73, 38, 'NU', 'Nunavut');
INSERT INTO `zones` VALUES (74, 38, 'ON', 'Ontario');
INSERT INTO `zones` VALUES (75, 38, 'PE', 'Prince Edward Island');
INSERT INTO `zones` VALUES (76, 38, 'QC', 'Quebec');
INSERT INTO `zones` VALUES (77, 38, 'SK', 'Saskatchewan');
INSERT INTO `zones` VALUES (78, 38, 'YT', 'Yukon Territory');
INSERT INTO `zones` VALUES (79, 81, 'NDS', 'Niedersachsen');
INSERT INTO `zones` VALUES (80, 81, 'BAW', 'Baden-W?rttemberg');
INSERT INTO `zones` VALUES (81, 81, 'BAY', 'Bayern');
INSERT INTO `zones` VALUES (82, 81, 'BER', 'Berlin');
INSERT INTO `zones` VALUES (83, 81, 'BRG', 'Brandenburg');
INSERT INTO `zones` VALUES (84, 81, 'BRE', 'Bremen');
INSERT INTO `zones` VALUES (85, 81, 'HAM', 'Hamburg');
INSERT INTO `zones` VALUES (86, 81, 'HES', 'Hessen');
INSERT INTO `zones` VALUES (87, 81, 'MEC', 'Mecklenburg-Vorpommern');
INSERT INTO `zones` VALUES (88, 81, 'NRW', 'Nordrhein-Westfalen');
INSERT INTO `zones` VALUES (89, 81, 'RHE', 'Rheinland-Pfalz');
INSERT INTO `zones` VALUES (90, 81, 'SAR', 'Saarland');
INSERT INTO `zones` VALUES (91, 81, 'SAS', 'Sachsen');
INSERT INTO `zones` VALUES (92, 81, 'SAC', 'Sachsen-Anhalt');
INSERT INTO `zones` VALUES (93, 81, 'SCN', 'Schleswig-Holstein');
INSERT INTO `zones` VALUES (94, 81, 'THE', 'Th?ringen');
INSERT INTO `zones` VALUES (95, 14, 'WI', 'Wien');
INSERT INTO `zones` VALUES (96, 14, 'NO', 'Nieder?sterreich');
INSERT INTO `zones` VALUES (97, 14, 'OO', 'Ober?sterreich');
INSERT INTO `zones` VALUES (98, 14, 'SB', 'Salzburg');
INSERT INTO `zones` VALUES (99, 14, 'KN', 'K?rnten');
INSERT INTO `zones` VALUES (100, 14, 'ST', 'Steiermark');
INSERT INTO `zones` VALUES (101, 14, 'TI', 'Tirol');
INSERT INTO `zones` VALUES (102, 14, 'BL', 'Burgenland');
INSERT INTO `zones` VALUES (103, 14, 'VB', 'Voralberg');
INSERT INTO `zones` VALUES (104, 204, 'AG', 'Aargau');
INSERT INTO `zones` VALUES (105, 204, 'AI', 'Appenzell Innerrhoden');
INSERT INTO `zones` VALUES (106, 204, 'AR', 'Appenzell Ausserrhoden');
INSERT INTO `zones` VALUES (107, 204, 'BE', 'Bern');
INSERT INTO `zones` VALUES (108, 204, 'BL', 'Basel-Landschaft');
INSERT INTO `zones` VALUES (109, 204, 'BS', 'Basel-Stadt');
INSERT INTO `zones` VALUES (110, 204, 'FR', 'Freiburg');
INSERT INTO `zones` VALUES (111, 204, 'GE', 'Genf');
INSERT INTO `zones` VALUES (112, 204, 'GL', 'Glarus');
INSERT INTO `zones` VALUES (113, 204, 'JU', 'Graub?nden');
INSERT INTO `zones` VALUES (114, 204, 'JU', 'Jura');
INSERT INTO `zones` VALUES (115, 204, 'LU', 'Luzern');
INSERT INTO `zones` VALUES (116, 204, 'NE', 'Neuenburg');
INSERT INTO `zones` VALUES (117, 204, 'NW', 'Nidwalden');
INSERT INTO `zones` VALUES (118, 204, 'OW', 'Obwalden');
INSERT INTO `zones` VALUES (119, 204, 'SG', 'St. Gallen');
INSERT INTO `zones` VALUES (120, 204, 'SH', 'Schaffhausen');
INSERT INTO `zones` VALUES (121, 204, 'SO', 'Solothurn');
INSERT INTO `zones` VALUES (122, 204, 'SZ', 'Schwyz');
INSERT INTO `zones` VALUES (123, 204, 'TG', 'Thurgau');
INSERT INTO `zones` VALUES (124, 204, 'TI', 'Tessin');
INSERT INTO `zones` VALUES (125, 204, 'UR', 'Uri');
INSERT INTO `zones` VALUES (126, 204, 'VD', 'Waadt');
INSERT INTO `zones` VALUES (127, 204, 'VS', 'Wallis');
INSERT INTO `zones` VALUES (128, 204, 'ZG', 'Zug');
INSERT INTO `zones` VALUES (129, 204, 'ZH', 'Z?rich');
INSERT INTO `zones` VALUES (130, 195, 'A Coru?a', 'A Coru?a');
INSERT INTO `zones` VALUES (131, 195, 'Alava', 'Alava');
INSERT INTO `zones` VALUES (132, 195, 'Albacete', 'Albacete');
INSERT INTO `zones` VALUES (133, 195, 'Alicante', 'Alicante');
INSERT INTO `zones` VALUES (134, 195, 'Almeria', 'Almeria');
INSERT INTO `zones` VALUES (135, 195, 'Asturias', 'Asturias');
INSERT INTO `zones` VALUES (136, 195, 'Avila', 'Avila');
INSERT INTO `zones` VALUES (137, 195, 'Badajoz', 'Badajoz');
INSERT INTO `zones` VALUES (138, 195, 'Baleares', 'Baleares');
INSERT INTO `zones` VALUES (139, 195, 'Barcelona', 'Barcelona');
INSERT INTO `zones` VALUES (140, 195, 'Burgos', 'Burgos');
INSERT INTO `zones` VALUES (141, 195, 'Caceres', 'Caceres');
INSERT INTO `zones` VALUES (142, 195, 'Cadiz', 'Cadiz');
INSERT INTO `zones` VALUES (143, 195, 'Cantabria', 'Cantabria');
INSERT INTO `zones` VALUES (144, 195, 'Castellon', 'Castellon');
INSERT INTO `zones` VALUES (145, 195, 'Ceuta', 'Ceuta');
INSERT INTO `zones` VALUES (146, 195, 'Ciudad Real', 'Ciudad Real');
INSERT INTO `zones` VALUES (147, 195, 'Cordoba', 'Cordoba');
INSERT INTO `zones` VALUES (148, 195, 'Cuenca', 'Cuenca');
INSERT INTO `zones` VALUES (149, 195, 'Girona', 'Girona');
INSERT INTO `zones` VALUES (150, 195, 'Granada', 'Granada');
INSERT INTO `zones` VALUES (151, 195, 'Guadalajara', 'Guadalajara');
INSERT INTO `zones` VALUES (152, 195, 'Guipuzcoa', 'Guipuzcoa');
INSERT INTO `zones` VALUES (153, 195, 'Huelva', 'Huelva');
INSERT INTO `zones` VALUES (154, 195, 'Huesca', 'Huesca');
INSERT INTO `zones` VALUES (155, 195, 'Jaen', 'Jaen');
INSERT INTO `zones` VALUES (156, 195, 'La Rioja', 'La Rioja');
INSERT INTO `zones` VALUES (157, 195, 'Las Palmas', 'Las Palmas');
INSERT INTO `zones` VALUES (158, 195, 'Leon', 'Leon');
INSERT INTO `zones` VALUES (159, 195, 'Lleida', 'Lleida');
INSERT INTO `zones` VALUES (160, 195, 'Lugo', 'Lugo');
INSERT INTO `zones` VALUES (161, 195, 'Madrid', 'Madrid');
INSERT INTO `zones` VALUES (162, 195, 'Malaga', 'Malaga');
INSERT INTO `zones` VALUES (163, 195, 'Melilla', 'Melilla');
INSERT INTO `zones` VALUES (164, 195, 'Murcia', 'Murcia');
INSERT INTO `zones` VALUES (165, 195, 'Navarra', 'Navarra');
INSERT INTO `zones` VALUES (166, 195, 'Ourense', 'Ourense');
INSERT INTO `zones` VALUES (167, 195, 'Palencia', 'Palencia');
INSERT INTO `zones` VALUES (168, 195, 'Pontevedra', 'Pontevedra');
INSERT INTO `zones` VALUES (169, 195, 'Salamanca', 'Salamanca');
INSERT INTO `zones` VALUES (170, 195, 'Santa Cruz de Tenerife', 'Santa Cruz de Tenerife');
INSERT INTO `zones` VALUES (171, 195, 'Segovia', 'Segovia');
INSERT INTO `zones` VALUES (172, 195, 'Sevilla', 'Sevilla');
INSERT INTO `zones` VALUES (173, 195, 'Soria', 'Soria');
INSERT INTO `zones` VALUES (174, 195, 'Tarragona', 'Tarragona');
INSERT INTO `zones` VALUES (175, 195, 'Teruel', 'Teruel');
INSERT INTO `zones` VALUES (176, 195, 'Toledo', 'Toledo');
INSERT INTO `zones` VALUES (177, 195, 'Valencia', 'Valencia');
INSERT INTO `zones` VALUES (178, 195, 'Valladolid', 'Valladolid');
INSERT INTO `zones` VALUES (179, 195, 'Vizcaya', 'Vizcaya');
INSERT INTO `zones` VALUES (180, 195, 'Zamora', 'Zamora');
INSERT INTO `zones` VALUES (181, 195, 'Zaragoza', 'Zaragoza');
INSERT INTO `zones` VALUES (346, 222, 'OXFO', 'Oxfordshire');
INSERT INTO `zones` VALUES (345, 222, 'NYOR', 'North Yorkshire');
INSERT INTO `zones` VALUES (344, 222, 'NWHI', 'North west Highlands');
INSERT INTO `zones` VALUES (343, 222, 'NUMB', 'Northumberland');
INSERT INTO `zones` VALUES (342, 222, 'NOTT', 'Nottinghamshire');
INSERT INTO `zones` VALUES (341, 222, 'NORF', 'Norfolk');
INSERT INTO `zones` VALUES (340, 222, 'NHAM', 'Northamptonshire');
INSERT INTO `zones` VALUES (339, 222, 'NEWP', 'Newport');
INSERT INTO `zones` VALUES (338, 222, 'NEAT', 'Neath Port Talbot');
INSERT INTO `zones` VALUES (337, 222, 'MONM', 'Monmouthshire');
INSERT INTO `zones` VALUES (336, 222, 'MERT', 'Merthyr Tydfil');
INSERT INTO `zones` VALUES (335, 222, 'MERS', 'Merseyside');
INSERT INTO `zones` VALUES (334, 222, 'MANC', 'Manchester');
INSERT INTO `zones` VALUES (333, 222, 'LOTH', 'Lothian');
INSERT INTO `zones` VALUES (332, 222, 'LOND', 'London');
INSERT INTO `zones` VALUES (331, 222, 'LINC', 'Lincolnshire');
INSERT INTO `zones` VALUES (330, 222, 'LEIC', 'Leicestershire');
INSERT INTO `zones` VALUES (329, 222, 'LDY', 'Londonderry');
INSERT INTO `zones` VALUES (328, 222, 'LANC', 'Lancashire');
INSERT INTO `zones` VALUES (327, 222, 'KENT', 'Kent');
INSERT INTO `zones` VALUES (326, 222, 'JSY', 'Jersey');
INSERT INTO `zones` VALUES (325, 222, 'JSY', 'Jersey');
INSERT INTO `zones` VALUES (324, 222, 'ISLE', 'Isle of Anglesey');
INSERT INTO `zones` VALUES (323, 222, 'HUMB', 'Humberside');
INSERT INTO `zones` VALUES (322, 222, 'HERT', 'Hertfordshire');
INSERT INTO `zones` VALUES (321, 222, 'HERE', 'Hereford & Worcester');
INSERT INTO `zones` VALUES (320, 222, 'HAMP', 'Hampshire');
INSERT INTO `zones` VALUES (319, 222, 'GWYN', 'Gwynedd');
INSERT INTO `zones` VALUES (318, 222, 'GWYN', 'Gwynedd');
INSERT INTO `zones` VALUES (317, 222, 'GWEN', 'Gwent');
INSERT INTO `zones` VALUES (316, 222, 'GSY', 'Guernsey');
INSERT INTO `zones` VALUES (315, 222, 'GRAM', 'Grampian');
INSERT INTO `zones` VALUES (314, 222, 'GLOU', 'Gloucestershire');
INSERT INTO `zones` VALUES (313, 222, 'GLAM', 'Glamorgan');
INSERT INTO `zones` VALUES (312, 222, 'FLIN', 'Flintshire');
INSERT INTO `zones` VALUES (311, 222, 'FIFE', 'Fife');
INSERT INTO `zones` VALUES (310, 222, 'FER', 'Fermanagh');
INSERT INTO `zones` VALUES (309, 222, 'ESUS', 'East Sussex');
INSERT INTO `zones` VALUES (308, 222, 'ESSE', 'Essex');
INSERT INTO `zones` VALUES (307, 222, 'DYFE', 'Dyfed');
INSERT INTO `zones` VALUES (306, 222, 'DURH', 'Durham');
INSERT INTO `zones` VALUES (305, 222, 'DUMF', 'Dumfries & Galloway');
INSERT INTO `zones` VALUES (304, 222, 'DOW', 'County Down');
INSERT INTO `zones` VALUES (303, 222, 'DORS', 'Dorset');
INSERT INTO `zones` VALUES (302, 222, 'DEVO', 'Devon');
INSERT INTO `zones` VALUES (301, 222, 'DERB', 'Derbyshire');
INSERT INTO `zones` VALUES (300, 222, 'DENB', 'Denbighshire');
INSERT INTO `zones` VALUES (299, 222, 'CUMB', 'Cumbria');
INSERT INTO `zones` VALUES (298, 222, 'CORN', 'Cornwall');
INSERT INTO `zones` VALUES (297, 222, 'CONW', 'Conway');
INSERT INTO `zones` VALUES (296, 222, 'CLWY', 'Clwyd');
INSERT INTO `zones` VALUES (295, 222, 'CLEV', 'Cleveland');
INSERT INTO `zones` VALUES (294, 222, 'CHI', 'Channel Islands');
INSERT INTO `zones` VALUES (293, 222, 'CHES', 'Cheshire');
INSERT INTO `zones` VALUES (292, 222, 'CERE', 'Ceredigion');
INSERT INTO `zones` VALUES (291, 222, 'CENT', 'Central');
INSERT INTO `zones` VALUES (290, 222, 'CARM', 'Carmarthenshire');
INSERT INTO `zones` VALUES (289, 222, 'CARD', 'Cardiff');
INSERT INTO `zones` VALUES (288, 222, 'CAMB', 'Cambridgeshire');
INSERT INTO `zones` VALUES (287, 222, 'CAER', 'Caerphilly');
INSERT INTO `zones` VALUES (286, 222, 'BUCK', 'Buckinghamshire');
INSERT INTO `zones` VALUES (285, 222, 'BRID', 'Bridgend');
INSERT INTO `zones` VALUES (284, 222, 'BORD', 'Borders');
INSERT INTO `zones` VALUES (283, 222, 'BLGW', 'Blaenau Gwent');
INSERT INTO `zones` VALUES (282, 222, 'BIRM', 'Birmingham');
INSERT INTO `zones` VALUES (281, 222, 'BERK', 'Berkshire');
INSERT INTO `zones` VALUES (280, 222, 'BEDS', 'Bedfordshire');
INSERT INTO `zones` VALUES (279, 222, 'AVON', 'Avon');
INSERT INTO `zones` VALUES (278, 222, 'ARM', 'County Armagh');
INSERT INTO `zones` VALUES (277, 222, 'ANT', 'County Antrim');
INSERT INTO `zones` VALUES (276, 222, 'ALD', 'Alderney');
INSERT INTO `zones` VALUES (347, 222, 'PEMB', 'Pembrokeshire');
INSERT INTO `zones` VALUES (348, 222, 'POWY', 'Powys');
INSERT INTO `zones` VALUES (349, 222, 'SHRO', 'Shropshire');
INSERT INTO `zones` VALUES (350, 222, 'SOME', 'Somerset');
INSERT INTO `zones` VALUES (351, 222, 'STAF', 'Staffordshire');
INSERT INTO `zones` VALUES (352, 222, 'STRA', 'Strathclyde');
INSERT INTO `zones` VALUES (353, 222, 'SUFF', 'Suffolk');
INSERT INTO `zones` VALUES (354, 222, 'SURR', 'Surrey');
INSERT INTO `zones` VALUES (355, 222, 'SWAN', 'Swansea');
INSERT INTO `zones` VALUES (356, 222, 'SYOR', 'South Yorkshire');
INSERT INTO `zones` VALUES (357, 222, 'TAFF', 'Rhondda Cynon Taff');
INSERT INTO `zones` VALUES (358, 222, 'TAYS', 'Tayside');
INSERT INTO `zones` VALUES (359, 222, 'TORF', 'Torfaen');
INSERT INTO `zones` VALUES (360, 222, 'TYR', 'County Tyrone');
INSERT INTO `zones` VALUES (361, 222, 'TYWE', 'Tyne & Wear');
INSERT INTO `zones` VALUES (362, 222, 'VALE', 'Vale of Glamorgan');
INSERT INTO `zones` VALUES (363, 222, 'WARW', 'Warwickshire');
INSERT INTO `zones` VALUES (364, 222, 'WILT', 'Wiltshire');
INSERT INTO `zones` VALUES (365, 222, 'WISL', 'West Isles');
INSERT INTO `zones` VALUES (366, 222, 'WREX', 'Wrexham');
INSERT INTO `zones` VALUES (367, 222, 'WSUS', 'West Sussex');
INSERT INTO `zones` VALUES (368, 222, 'WYOR', 'West Yorkshire');

-- --------------------------------------------------------

--
-- Table structure for table `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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=53 ;

--
-- Dumping data for table `zones_to_geo_zones`
--

INSERT INTO `zones_to_geo_zones` VALUES (1, 223, 18, 1, NULL, '0000-00-00 00:00:00');
INSERT INTO `zones_to_geo_zones` VALUES (32, 117, 0, 2, NULL, '0000-00-00 00:00:00');
INSERT INTO `zones_to_geo_zones` VALUES (31, 105, 0, 2, NULL, '0000-00-00 00:00:00');
INSERT INTO `zones_to_geo_zones` VALUES (30, 103, 0, 2, NULL, '0000-00-00 00:00:00');
INSERT INTO `zones_to_geo_zones` VALUES (29, 98, 0, 2, NULL, '0000-00-00 00:00:00');
INSERT INTO `zones_to_geo_zones` VALUES (28, 97, 0, 2, NULL, '0000-00-00 00:00:00');
INSERT INTO `zones_to_geo_zones` VALUES (27, 84, 0, 2, NULL, '0000-00-00 00:00:00');
INSERT INTO `zones_to_geo_zones` VALUES (25, 81, 0, 2, NULL, '0000-00-00 00:00:00');
INSERT INTO `zones_to_geo_zones` VALUES (24, 73, 0, 2, NULL, '0000-00-00 00:00:00');
INSERT INTO `zones_to_geo_zones` VALUES (23, 72, 0, 2, NULL, '0000-00-00 00:00:00');
INSERT INTO `zones_to_geo_zones` VALUES (22, 67, 0, 2, NULL, '0000-00-00 00:00:00');
INSERT INTO `zones_to_geo_zones` VALUES (21, 57, 0, 2, NULL, '0000-00-00 00:00:00');
INSERT INTO `zones_to_geo_zones` VALUES (20, 56, 0, 2, NULL, '0000-00-00 00:00:00');
INSERT INTO `zones_to_geo_zones` VALUES (19, 55, 0, 2, NULL, '0000-00-00 00:00:00');
INSERT INTO `zones_to_geo_zones` VALUES (18, 21, 0, 2, NULL, '0000-00-00 00:00:00');
INSERT INTO `zones_to_geo_zones` VALUES (17, 14, 0, 2, NULL, '0000-00-00 00:00:00');
INSERT INTO `zones_to_geo_zones` VALUES (33, 123, 0, 2, NULL, '0000-00-00 00:00:00');
INSERT INTO `zones_to_geo_zones` VALUES (34, 124, 0, 2, NULL, '0000-00-00 00:00:00');
INSERT INTO `zones_to_geo_zones` VALUES (35, 132, 0, 2, NULL, '0000-00-00 00:00:00');
INSERT INTO `zones_to_geo_zones` VALUES (36, 150, 0, 2, NULL, '0000-00-00 00:00:00');
INSERT INTO `zones_to_geo_zones` VALUES (37, 160, 0, 2, NULL, '0000-00-00 00:00:00');
INSERT INTO `zones_to_geo_zones` VALUES (38, 170, 0, 2, NULL, '0000-00-00 00:00:00');
INSERT INTO `zones_to_geo_zones` VALUES (46, 171, 0, 2, NULL, '0000-00-00 00:00:00');
INSERT INTO `zones_to_geo_zones` VALUES (47, 189, 0, 2, NULL, '0000-00-00 00:00:00');
INSERT INTO `zones_to_geo_zones` VALUES (48, 190, 0, 2, NULL, '0000-00-00 00:00:00');
INSERT INTO `zones_to_geo_zones` VALUES (49, 195, 0, 2, NULL, '0000-00-00 00:00:00');
INSERT INTO `zones_to_geo_zones` VALUES (50, 203, 0, 2, NULL, '0000-00-00 00:00:00');
INSERT INTO `zones_to_geo_zones` VALUES (51, 204, 0, 2, NULL, '0000-00-00 00:00:00');
INSERT INTO `zones_to_geo_zones` VALUES (52, 222, 0, 2, NULL, '0000-00-00 00:00:00');