#
# Dumping data for table `currencies`
#

INSERT INTO currencies VALUES (1, 'US Dollar', 'USD', '$', 'USD', '.', ',', '2', '1', '2001-11-28 15:46:58');
INSERT INTO currencies VALUES (2, 'Deutsche Mark', 'DEM', '', 'DM', ',', '.', '2', '2.1585', '2001-11-28 15:46:58');
INSERT INTO currencies VALUES (3, 'Spanish Peseta', 'ESP', '', 'Pts', '.', ',', '0', '183.624', '2001-11-28 15:46:58');
INSERT INTO currencies VALUES (4, 'Euro', 'EUR', '€', '', '.', ',', '2', '1.1036', '2001-11-28 15:46:58');

#
# 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', '$city / $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');

#
# Dumping data for table `configuration`
#

INSERT INTO configuration VALUES (1, 'Store Name', 'STORE_NAME', 'Southern Glow Candles', 'The name of my store', 1, 1, '2002-10-28 11:10:09', '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (2, 'Store Owner', 'STORE_OWNER', 'Benjamin D. Wolfley', 'The name of my store owner', 1, 2, '2002-10-28 11:10:37', '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (3, 'E-Mail Address', 'STORE_OWNER_EMAIL_ADDRESS', 'quorben@hotmail.com', 'The e-mail address of my store owner', 1, 3, '2003-06-30 15:04:41', '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (4, 'E-Mail From', 'EMAIL_FROM', 'Southern Glow Candles <info@stc.southern.edu>', 'The e-mail address used in (sent) e-mails', 1, 4, '2002-10-28 11:11:45', '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (5, 'Use MIME HTML when sending emails', 'EMAIL_USE_HTML', '0', 'Send Emails in HTML format', 1, 5, NULL, '2001-11-28 15:46:58', NULL, 'tep_cfg_true_false_option');
INSERT INTO configuration VALUES (6, 'Country', 'STORE_COUNTRY', '223', 'The country my store is located in', 1, 6, '2001-11-29 15:32:16', '2001-11-28 15:46:58', 'tep_get_country_name', 'tep_cfg_pull_down_country_list');
INSERT INTO configuration VALUES (7, 'Expected Sort Order', 'EXPECTED_PRODUCTS_SORT', 'DESC', 'This is the sort order used in the &quot;expected products&quot; box.  It can be either ASC (ascending) or DESC (descending, the default).', 1, 7, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (8, 'Expected Sort Field', 'EXPECTED_PRODUCTS_FIELD', 'date_expected', 'The column to sort by in the &quot;expected products&quot; box.  Can be &quot;products_name&quot; or &quot;date_expected&quot; (the default)', 1, 8, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (9, 'Switch To Default Language Currency', 'USE_DEFAULT_LANGUAGE_CURRENCY', 'false', 'Automatically switch to the language\'s currency when it is changed', 1, 9, NULL, '2001-11-28 15:46:58', NULL, 'tep_cfg_true_false_option');
INSERT INTO configuration VALUES (10, 'First Name', 'ENTRY_FIRST_NAME_MIN_LENGTH', '2', 'Minimum length of first name', 2, 1, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (11, 'Last Name', 'ENTRY_LAST_NAME_MIN_LENGTH', '2', 'Minimum length of last name', 2, 2, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (12, 'Date of Birth', 'ENTRY_DOB_MIN_LENGTH', '10', 'Minimum length of date of birth', 2, 3, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (13, 'E-Mail Address', 'ENTRY_EMAIL_ADDRESS_MIN_LENGTH', '6', 'Minimum length of e-mail address', 2, 4, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (14, 'Street Address', 'ENTRY_STREET_ADDRESS_MIN_LENGTH', '5', 'Minimum length of street address', 2, 5, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (15, 'Company', 'ENTRY_COMPANY_LENGTH', '2', 'Minimum length of company name', 2, 6, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (16, 'Post Code', 'ENTRY_POSTCODE_MIN_LENGTH', '4', 'Minimum length of post code', 2, 7, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (17, 'City', 'ENTRY_CITY_MIN_LENGTH', '3', 'Minimum length of city', 2, 8, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (18, 'State', 'ENTRY_STATE_MIN_LENGTH', '4', 'Minimum length of state', 2, 9, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (19, 'Telephone Number', 'ENTRY_TELEPHONE_MIN_LENGTH', '3', 'Minimum length of telephone number', 2, 10, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (20, 'Password', 'ENTRY_PASSWORD_MIN_LENGTH', '5', 'Minimum length of password', 2, 11, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (21, 'Credit Card Owner Name', 'CC_OWNER_MIN_LENGTH', '3', 'Minimum length of credit card owner name', 2, 12, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (22, 'Credit Card Number', 'CC_NUMBER_MIN_LENGTH', '10', 'Minimum length of credit card number', 2, 13, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (23, 'Review Text', 'REVIEW_TEXT_MIN_LENGTH', '50', 'Minimum length of review text', 2, 14, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (24, 'Address Book Entries', 'MAX_ADDRESS_BOOK_ENTRIES', '5', 'Maximum address book entries a customer is allowed to have', 3, 1, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (25, 'Search Results', 'MAX_DISPLAY_SEARCH_RESULTS', '20', 'Amount of products to list', 3, 2, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (26, 'Page Links', 'MAX_DISPLAY_PAGE_LINKS', '5', 'Number of \'number\' links use for page-sets', 3, 3, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (27, 'Special Products', 'MAX_DISPLAY_SPECIAL_PRODUCTS', '9', 'Maximum number of products on special to display', 3, 4, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (28, 'New Products Module', 'MAX_DISPLAY_NEW_PRODUCTS', '9', 'Maximum number of new products to display in a category', 3, 5, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (29, 'Products Expected', 'MAX_DISPLAY_UPCOMING_PRODUCTS', '10', 'Maximum number of products expected to display', 3, 6, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (30, 'Manufacturers List', 'MAX_DISPLAY_MANUFACTURERS_IN_A_LIST', '0', 'Used in manufacturers box; when the number of manufacturers exceeds this number, a drop-down list will be displayed instead of the default list', 3, 7, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (31, 'Manufacturers Select Size', 'MAX_MANUFACTURERS_LIST', '1', 'Used in manufacturers box; when this value is \'1\' the classic drop-down list will be used for the manufacturers box. Otherwise, a list-box with the specified number of rows will be displayed.', 3, 7, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (32, 'Length of Manufacturers Name', 'MAX_DISPLAY_MANUFACTURER_NAME_LEN', '15', 'Used in manufacturers box; maximum length of manufacturers name to display', 3, 8, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (33, 'New Reviews', 'MAX_DISPLAY_NEW_REVIEWS', '6', 'Maximum number of new reviews to display', 3, 9, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (34, 'Selection of Random Reviews', 'MAX_RANDOM_SELECT_REVIEWS', '10', 'How many records to select from to choose one random product review', 3, 10, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (35, 'Selection of Random New Products', 'MAX_RANDOM_SELECT_NEW', '10', 'How many records to select from to choose one random new product to display', 3, 11, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (36, 'Selection of Products on Special', 'MAX_RANDOM_SELECT_SPECIALS', '10', 'How many records to select from to choose one random product special to display', 3, 12, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (37, 'Categories To List Per Row', 'MAX_DISPLAY_CATEGORIES_PER_ROW', '3', 'How many categories to list per row', 3, 13, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (38, 'New Products Listing', 'MAX_DISPLAY_PRODUCTS_NEW', '10', 'Maximum number of new products to display in new products page', 3, 14, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (39, 'Small Image Width', 'SMALL_IMAGE_WIDTH', '100', 'The pixel width of small images', 4, 1, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (40, 'Small Image Height', 'SMALL_IMAGE_HEIGHT', '80', 'The pixel height of small images', 4, 2, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (41, 'Heading Image Width', 'HEADING_IMAGE_WIDTH', '85', 'The pixel width of heading images', 4, 3, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (42, 'Heading Image Height', 'HEADING_IMAGE_HEIGHT', '60', 'The pixel height of heading images', 4, 4, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (43, 'Subcategory Image Width', 'SUBCATEGORY_IMAGE_WIDTH', '100', 'The pixel width of subcategory images', 4, 5, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (44, 'Subcategory Image Height', 'SUBCATEGORY_IMAGE_HEIGHT', '57', 'The pixel height of subcategory images', 4, 6, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (45, 'Calculate Image Size', 'CONFIG_CALCULATE_IMAGE_SIZE', '1', 'Calculate the size of images?', 4, 7, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (46, 'Image Required', 'IMAGE_REQUIRED', '1', 'Enable to display broken images. Good for development.', 4, 8, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (47, 'Installed Modules', 'MODULE_PAYMENT_INSTALLED', 'email_cc.php', 'List of payment module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: cc.php;cod.php;paypal.php)', 6, 0, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (48, 'Installed Modules', 'MODULE_SHIPPING_INSTALLED', '', 'List of shipping module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: ups.php;flat.php;item.php)', 6, 0, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (147, 'Allow Credit Card', 'MODULE_PAYMENT_EMAIL_CC_STATUS', '1', 'Do you want to accept credit card payments through e-mail?', 6, 0, NULL, '2003-07-23 11:29:50', NULL, NULL);
INSERT INTO configuration VALUES (146, 'From E-mail', 'MODULE_PAYMENT_EMAIL_CC_FROM_EMAIL', 'quorben@hotmail.com', 'What e-mail address do you want credit card notifications to be from?', 6, 2, NULL, '2003-07-23 11:29:50', NULL, NULL);
INSERT INTO configuration VALUES (145, 'To E-mail Address', 'MODULE_PAYMENT_EMAIL_CC_EMAIL', 'quorben@hotmail.com', 'This is the e-mail address to send the credit card information to?', 6, 1, NULL, '2003-07-23 11:29:50', NULL, NULL);
INSERT INTO configuration VALUES (52, 'Default Currency', 'DEFAULT_CURRENCY', 'USD', 'Default Currency', 6, 0, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (53, 'Default Language', 'DEFAULT_LANGUAGE', 'en', 'Default Language', 6, 0, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (54, 'Country Code', 'STORE_ORIGIN_COUNTRY', 'US', 'Enter the &quot;ISO 3166&quot; Country Code of the Store to be used in shipping quotes.  To find your country code, visit the <A HREF="http://www.din.de/gremien/nas/nabd/iso3166ma/codlstp1/index.html" TARGET="_blank">ISO 3166 Maintenance Agency</A>.', 7, 1, '2001-12-17 13:31:45', '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (55, 'Postal Code', 'STORE_ORIGIN_ZIP', '91301', 'Enter the Postal Code (ZIP) of the Store to be used in shipping quotes.', 7, 2, '2001-12-15 10:40:50', '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (56, 'Enter the Maximum Package Weight you will ship', 'SHIPPING_MAX_WEIGHT', '50', 'Carriers have a max weight limit for a single package. This is a common one for all.', 7, 3, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (57, 'Package Tare weight.', 'SHIPPING_BOX_WEIGHT', '3', 'What is the weight of typical packaging of small to medium packages?', 7, 4, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (58, 'Larger packages - percentage increase.', 'SHIPPING_BOX_PADDING', '10', 'For 10% enter 10', 7, 5, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (59, 'Handling Fee', 'SHIPPING_HANDLING', '5.00', 'Enter the handling fee you may charge.', 7, 6, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (60, 'Display Product Image', 'PRODUCT_LIST_IMAGE', '0', 'Do you want to display the Product Image?', 8, 1, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (61, 'Display Product Manufaturer Name', 'PRODUCT_LIST_MANUFACTURER', '0', 'Do you want to display the Product Manufacturer Name?', 8, 2, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (62, 'Display Product Model', 'PRODUCT_LIST_MODEL', '0', 'Do you want to display the Product Model?', 8, 3, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (63, 'Display Product Name', 'PRODUCT_LIST_NAME', '1', 'Do you want to display the Product Name?', 8, 4, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (64, 'Display Product Price', 'PRODUCT_LIST_PRICE', '2', 'Do you want to display the Product Price', 8, 5, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (65, 'Display Product Quantity', 'PRODUCT_LIST_QUANTITY', '0', 'Do you want to display the Product Quantity?', 8, 6, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (66, 'Display Product Weight', 'PRODUCT_LIST_WEIGHT', '0', 'Do you want to display the Product Weight?', 8, 7, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (67, 'Display Buy Now column', 'PRODUCT_LIST_BUY_NOW', '0', 'Do you want to display the Buy Now column?', 8, 8, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (68, 'Display Category/Manufacturer Filter (0=disable; 1=enable)', 'PRODUCT_LIST_FILTER', '1', 'Do you want to display the Category/Manufacturer Filter?', 8, 9, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (69, 'Location of Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)', 'PREV_NEXT_BAR_LOCATION', '2', 'Sets the location of the Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)', 8, 10, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (70, 'Check stock level', 'STOCK_CHECK', '1', 'Check to see if sufficent stock is available', 9, 1, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (71, 'Subtract stock', 'STOCK_LIMITED', '1', 'Subtract product in stock by product orders', 9, 2, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (72, 'Allow Checkout', 'STOCK_ALLOW_CHECKOUT', '1', 'Allow customer to checkout even if there is insufficient stock', 9, 3, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (73, '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, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (74, 'Stock Re-order level', 'STOCK_REORDER_LEVEL', '5', 'Define when stock needs to be re-ordered', 9, 5, NULL, '2001-11-28 15:46:58', NULL, NULL);
INSERT INTO configuration VALUES (84, 'Credit Card TP email address', 'MODULE_PAYMENT_ECHO_CC_EMAIL', 'NONE', 'If this email address is not NONE then the middle digits of any stored cc numbers will be X-ed out and emailed with the order id.', 6, 0, NULL, '2001-11-29 15:02:19', NULL, NULL);
INSERT INTO configuration VALUES (115, 'Residential Delivery?', 'MODULE_SHIPPING_UPS_RES', 'RES', 'Quote for Residential (RES) or Commercial Delivery (COM)', 6, 12, NULL, '2001-11-30 16:00:23', NULL, NULL);
INSERT INTO configuration VALUES (112, 'Enable UPS Shipping', 'MODULE_SHIPPING_UPS_STATUS', '1', 'Do you want to offer UPS shipping?', 6, 9, NULL, '2001-11-30 16:00:23', NULL, NULL);
INSERT INTO configuration VALUES (113, 'UPS Pickup Method', 'MODULE_SHIPPING_UPS_PICKUP', 'CC', 'How do you give packages to UPS? CC - Customer Counter, RDP - Daily Pickup, OTP - One Time Pickup, LC - Letter Center, OCA - On Call Air', 6, 10, NULL, '2001-11-30 16:00:23', NULL, NULL);
INSERT INTO configuration VALUES (114, 'UPS Packaging?', 'MODULE_SHIPPING_UPS_PACKAGE', 'CP', 'CP - Your Packaging, ULE - UPS Letter, UT - UPS Tube, UBE - UPS Express Box', 6, 11, NULL, '2001-11-30 16:00:23', NULL, NULL);
INSERT INTO configuration VALUES (120, 'Enable FedEx Shipping', 'MODULE_SHIPPING_FEDEX_STATUS', '1', 'Do you want to offer Federal Express (FedEx) shipping?', 6, 10, NULL, '2001-12-15 13:01:45', NULL, NULL);

#
# Dumping data for table `configuration_group`
#

INSERT INTO configuration_group VALUES (1, 'My Store', 'General information about my store', 1, 1);
INSERT INTO configuration_group VALUES (2, 'Minimum Values', 'The minimum values for functions / data', 2, 1);
INSERT INTO configuration_group VALUES (3, 'Maximum Values', 'The maximum values for functions / data', 3, 1);
INSERT INTO configuration_group VALUES (4, 'Images', 'Image parameters', 4, 1);
INSERT INTO configuration_group VALUES (6, 'Module Options', 'Hidden from configuration', 6, 0);
INSERT INTO configuration_group VALUES (7, 'Shipping/Packaging', 'Shipping options available at my store', 7, 1);
INSERT INTO configuration_group VALUES (8, 'Product Listing', 'Product Listing    configuration options', 8, 1);
INSERT INTO configuration_group VALUES (9, 'Stock', 'Stock configuration options', 9, 1);

#
# Dumping data for table `counter`
#

INSERT INTO counter VALUES ('20030721', 13);

#
# 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, Province of China', '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', 1);
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);

#
# Dumping data for table `geo_zones`
#

INSERT INTO geo_zones VALUES (2, 'Tennessee', 'Tennessee sales tax', NULL, '2003-07-23 14:13:30');

#
# Dumping data for table `languages`
#

INSERT INTO languages VALUES (1, 'English', 'en', 'flag_en.gif', 'english', 1);
INSERT INTO languages VALUES (2, 'Deutsch', 'de', 'flag_de.gif', 'german', 2);
INSERT INTO languages VALUES (3, 'Español', 'es', 'flag_es.gif', 'espanol', 3);

#
# Dumping data for table `orders_status`
#

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

#
# Dumping data for table `products_options`
#

INSERT INTO products_options VALUES (1, 1, 'Color');
INSERT INTO products_options VALUES (2, 1, 'Size');
INSERT INTO products_options VALUES (3, 1, 'Model');
INSERT INTO products_options VALUES (1, 2, 'Farbe');
INSERT INTO products_options VALUES (2, 2, 'Größe');
INSERT INTO products_options VALUES (3, 2, 'Modell');
INSERT INTO products_options VALUES (1, 3, 'Color');
INSERT INTO products_options VALUES (2, 3, 'Talla');
INSERT INTO products_options VALUES (3, 3, 'Modelo');

#
# Dumping data for table `tax_class`
#

INSERT INTO tax_class VALUES (1, 'Taxable Goods', 'The following types of products are included non-food, services, etc', '2001-11-28 15:46:58', '2001-11-28 15:46:58');

#
# Dumping data for table `tax_rates`
#

INSERT INTO tax_rates VALUES (2, 2, 1, 1, '8.7500', 'TN 8.75 salse tax', NULL, '2003-07-23 14:14:04');

#
# Dumping data for table `text_conf`
#

INSERT INTO text_conf VALUES (1, 'Store owner please go to the Configure Messages option of the Tools section in the Administration tool and change this text!', '<i>ECHOcart</i> is a powerful, scalable and fully customisable storefront for your web site. Based on the PHP language, backed with a blisteringly fast MySQL back-end database, <i>ECHOcart</i> is the ideal solution for all medium-to-large sites.<br><br>\r\n\r\nStore owner please go to the Configure Messages option of the Tools section in the Administration tool to change this text!', 'Informaiton about your store', 'Store owner please go to the Configure Messages option of the Tools section in the Administration tool and change this text!', 'Store owner please go to the Configure Messages option of the Tools section in the Administration tool and change this text!', 'Store owner please go to the Configure Messages option of the Tools section in the Administration tool and change this text!', 'Contact me please', NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 'Kontakten ussen jahh', 'header_exchange_logo.gif', 'header_exchange.gif', 'stylesheet.css');

#
# Dumping data for table `whos_online`
#

INSERT INTO whos_online VALUES (0, 'Guest', 'c8ef06f3d25ae12378fd9f8404266c9a', '10.0.0.1', '1058887683', '1058888375', '/echocart/');

#
# 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');

#
# Dumping data for table `zones_to_geo_zones`
#

INSERT INTO zones_to_geo_zones VALUES (1, 223, 18, 1, NULL, '2001-11-28 15:46:58');
INSERT INTO zones_to_geo_zones VALUES (2, 223, 56, 2, NULL, '2003-07-23 14:14:41');