-- MySQL dump 9.07 -- -- Host: localhost Database: zmox_osc --------------------------------------------------------- -- Server version 4.0.12 -- -- Table structure for table 'address_book' -- CREATE TABLE address_book ( customers_id int(11) NOT NULL default '0', address_book_id int(11) NOT NULL default '1', entry_gender char(1) NOT NULL default '', entry_company varchar(32) default NULL, entry_firstname varchar(32) NOT NULL default '', entry_lastname varchar(32) NOT NULL default '', entry_street_address varchar(64) NOT NULL default '', entry_suburb varchar(32) default NULL, entry_postcode varchar(10) NOT NULL default '', entry_city varchar(32) NOT NULL default '', entry_state varchar(32) default NULL, entry_country_id int(11) NOT NULL default '0', entry_zone_id int(11) NOT NULL default '0', PRIMARY KEY (address_book_id,customers_id) ) TYPE=MyISAM; -- -- Dumping data for table 'address_book' -- INSERT INTO address_book VALUES (1,1,'m','ACME Inc.','John','Doe','1 Way Street','','12345','NeverNever','',223,12); -- -- 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) ) TYPE=MyISAM; -- -- Dumping data for table 'address_format' -- INSERT INTO address_format VALUES (1,'$firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country','$city / $country'); 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) ) TYPE=MyISAM; -- -- Dumping data for table 'banners' -- INSERT INTO banners VALUES (1,'osCommerce','http://www.oscommerce.com','banners/oscommerce.gif','468x50','',0,NULL,NULL,'2003-05-01 12:26:45','2003-05-01 12:28:26',0); -- -- 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) ) TYPE=MyISAM; -- -- Dumping data for table 'banners_history' -- INSERT INTO banners_history VALUES (1,1,1,0,'2003-05-01 12:27:41'); -- -- 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) ) TYPE=MyISAM; -- -- Dumping data for table 'categories' -- INSERT INTO categories VALUES (1,'category_hardware.gif',0,1,'2003-05-01 12:26:45',NULL); INSERT INTO categories VALUES (2,'category_software.gif',0,2,'2003-05-01 12:26:45',NULL); INSERT INTO categories VALUES (3,'category_dvd_movies.gif',0,3,'2003-05-01 12:26:45',NULL); INSERT INTO categories VALUES (4,'subcategory_graphic_cards.gif',1,0,'2003-05-01 12:26:45',NULL); INSERT INTO categories VALUES (5,'subcategory_printers.gif',1,0,'2003-05-01 12:26:45',NULL); INSERT INTO categories VALUES (6,'subcategory_monitors.gif',1,0,'2003-05-01 12:26:45',NULL); INSERT INTO categories VALUES (7,'subcategory_speakers.gif',1,0,'2003-05-01 12:26:45',NULL); INSERT INTO categories VALUES (8,'subcategory_keyboards.gif',1,0,'2003-05-01 12:26:45',NULL); INSERT INTO categories VALUES (9,'subcategory_mice.gif',1,0,'2003-05-01 12:26:45',NULL); INSERT INTO categories VALUES (10,'subcategory_action.gif',3,0,'2003-05-01 12:26:45',NULL); INSERT INTO categories VALUES (11,'subcategory_science_fiction.gif',3,0,'2003-05-01 12:26:45',NULL); INSERT INTO categories VALUES (12,'subcategory_comedy.gif',3,0,'2003-05-01 12:26:45',NULL); INSERT INTO categories VALUES (13,'subcategory_cartoons.gif',3,0,'2003-05-01 12:26:45',NULL); INSERT INTO categories VALUES (14,'subcategory_thriller.gif',3,0,'2003-05-01 12:26:45',NULL); INSERT INTO categories VALUES (15,'subcategory_drama.gif',3,0,'2003-05-01 12:26:45',NULL); INSERT INTO categories VALUES (16,'subcategory_memory.gif',1,0,'2003-05-01 12:26:45',NULL); INSERT INTO categories VALUES (17,'subcategory_cdrom_drives.gif',1,0,'2003-05-01 12:26:45',NULL); INSERT INTO categories VALUES (18,'subcategory_simulation.gif',2,0,'2003-05-01 12:26:45',NULL); INSERT INTO categories VALUES (19,'subcategory_action_games.gif',2,0,'2003-05-01 12:26:45',NULL); INSERT INTO categories VALUES (20,'subcategory_strategy.gif',2,0,'2003-05-01 12:26:45',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) ) TYPE=MyISAM; -- -- Dumping data for table 'categories_description' -- INSERT INTO categories_description VALUES (1,1,'Hardware'); INSERT INTO categories_description VALUES (2,1,'Software'); INSERT INTO categories_description VALUES (3,1,'DVD Movies'); INSERT INTO categories_description VALUES (4,1,'Graphics Cards'); INSERT INTO categories_description VALUES (5,1,'Printers'); INSERT INTO categories_description VALUES (6,1,'Monitors'); INSERT INTO categories_description VALUES (7,1,'Speakers'); INSERT INTO categories_description VALUES (8,1,'Keyboards'); INSERT INTO categories_description VALUES (9,1,'Mice'); INSERT INTO categories_description VALUES (10,1,'Action'); INSERT INTO categories_description VALUES (11,1,'Science Fiction'); INSERT INTO categories_description VALUES (12,1,'Comedy'); INSERT INTO categories_description VALUES (13,1,'Cartoons'); INSERT INTO categories_description VALUES (14,1,'Thriller'); INSERT INTO categories_description VALUES (15,1,'Drama'); INSERT INTO categories_description VALUES (16,1,'Memory'); INSERT INTO categories_description VALUES (17,1,'CDROM Drives'); INSERT INTO categories_description VALUES (18,1,'Simulation'); INSERT INTO categories_description VALUES (19,1,'Action'); INSERT INTO categories_description VALUES (20,1,'Strategy'); INSERT INTO categories_description VALUES (1,2,'Hardware'); INSERT INTO categories_description VALUES (2,2,'Software'); INSERT INTO categories_description VALUES (3,2,'DVD Filme'); INSERT INTO categories_description VALUES (4,2,'Grafikkarten'); INSERT INTO categories_description VALUES (5,2,'Drucker'); INSERT INTO categories_description VALUES (6,2,'Bildschirme'); INSERT INTO categories_description VALUES (7,2,'Lautsprecher'); INSERT INTO categories_description VALUES (8,2,'Tastaturen'); INSERT INTO categories_description VALUES (9,2,'Mäuse'); INSERT INTO categories_description VALUES (10,2,'Action'); INSERT INTO categories_description VALUES (11,2,'Science Fiction'); INSERT INTO categories_description VALUES (12,2,'Komödie'); INSERT INTO categories_description VALUES (13,2,'Zeichentrick'); INSERT INTO categories_description VALUES (14,2,'Thriller'); INSERT INTO categories_description VALUES (15,2,'Drama'); INSERT INTO categories_description VALUES (16,2,'Speicher'); INSERT INTO categories_description VALUES (17,2,'CDROM Laufwerke'); INSERT INTO categories_description VALUES (18,2,'Simulation'); INSERT INTO categories_description VALUES (19,2,'Action'); INSERT INTO categories_description VALUES (20,2,'Strategie'); INSERT INTO categories_description VALUES (1,3,'Hardware'); INSERT INTO categories_description VALUES (2,3,'Software'); INSERT INTO categories_description VALUES (3,3,'Peliculas DVD'); INSERT INTO categories_description VALUES (4,3,'Tarjetas Graficas'); INSERT INTO categories_description VALUES (5,3,'Impresoras'); INSERT INTO categories_description VALUES (6,3,'Monitores'); INSERT INTO categories_description VALUES (7,3,'Altavoces'); INSERT INTO categories_description VALUES (8,3,'Teclados'); INSERT INTO categories_description VALUES (9,3,'Ratones'); INSERT INTO categories_description VALUES (10,3,'Accion'); INSERT INTO categories_description VALUES (11,3,'Ciencia Ficcion'); INSERT INTO categories_description VALUES (12,3,'Comedia'); INSERT INTO categories_description VALUES (13,3,'Dibujos Animados'); INSERT INTO categories_description VALUES (14,3,'Suspense'); INSERT INTO categories_description VALUES (15,3,'Drama'); INSERT INTO categories_description VALUES (16,3,'Memoria'); INSERT INTO categories_description VALUES (17,3,'Unidades CDROM'); INSERT INTO categories_description VALUES (18,3,'Simulacion'); INSERT INTO categories_description VALUES (19,3,'Accion'); INSERT INTO categories_description VALUES (20,3,'Estrategia'); -- -- 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) ) TYPE=MyISAM; -- -- Dumping data for table 'configuration' -- INSERT INTO configuration VALUES (1,'Store Name','STORE_NAME','WaterStuff','The name of my store',1,1,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (2,'Store Owner','STORE_OWNER','Chris Kofer','The name of my store owner',1,2,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (3,'E-Mail Address','STORE_OWNER_EMAIL_ADDRESS','chriskofer@h2oguy.com','The e-mail address of my store owner',1,3,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (4,'E-Mail From','EMAIL_FROM','chriskofer@h2oguy.com ','The e-mail address used in (sent) e-mails',1,4,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (5,'Country','STORE_COUNTRY','81','The country my store is located in

Note: Please remember to update the store zone.',1,6,NULL,'2003-05-01 12:26:45','tep_get_country_name','tep_cfg_pull_down_country_list('); INSERT INTO configuration VALUES (6,'Zone','STORE_ZONE','88','The zone my store is located in',1,7,NULL,'2003-05-01 12:26:45','tep_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.',1,8,NULL,'2003-05-01 12:26:45',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.',1,9,NULL,'2003-05-01 12:26:45',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 language\'s currency when it is changed',1,10,NULL,'2003-05-01 12:26:45',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (10,'Send Extra Order Emails To','SEND_EXTRA_ORDER_EMAILS_TO','chriskofer@h2oguy.com','Send extra order emails to the following email addresses, in this format: Name 1 <email@address1>, Name 2 <email@address2>',1,11,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (11,'Use Search-Engine Safe URLs (still in development)','SEARCH_ENGINE_FRIENDLY_URLS','false','Use search-engine safe urls for all site links',1,12,NULL,'2003-05-01 12:26:45',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)',1,14,NULL,'2003-05-01 12:26:45',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (13,'Allow Guest To Tell A Friend','ALLOW_GUEST_TO_TELL_A_FRIEND','false','Allow guests to tell a friend about a product',1,15,NULL,'2003-05-01 12:26:45',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (14,'Default Search Operator','ADVANCED_SEARCH_DEFAULT_OPERATOR','and','Default search operators',1,17,NULL,'2003-05-01 12:26:45',NULL,'tep_cfg_select_option(array(\'and\', \'or\'),'); INSERT INTO configuration VALUES (15,'Store Address and Phone','STORE_NAME_ADDRESS','Store Name\nAddress\nCountry\nPhone','This is the Store Name, Address and Phone used on printable documents and displayed online',1,18,NULL,'2003-05-01 12:26:45',NULL,'tep_cfg_textarea('); INSERT INTO configuration VALUES (16,'Show Category Counts','SHOW_COUNTS','true','Count recursively how many products are in each category',1,19,NULL,'2003-05-01 12:26:45',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (17,'Tax Decimal Places','TAX_DECIMAL_PLACES','2','Pad the tax value this amount of decimal places',1,20,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (18,'Display Prices with Tax','DISPLAY_PRICE_WITH_TAX','true','Display prices with tax included (true) or add the tax at the end (false)',1,21,NULL,'2003-05-01 12:26:45',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,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (20,'Last Name','ENTRY_LAST_NAME_MIN_LENGTH','2','Minimum length of last name',2,2,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (21,'Date of Birth','ENTRY_DOB_MIN_LENGTH','10','Minimum length of date of birth',2,3,NULL,'2003-05-01 12:26:45',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,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (23,'Street Address','ENTRY_STREET_ADDRESS_MIN_LENGTH','5','Minimum length of street address',2,5,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (24,'Company','ENTRY_COMPANY_LENGTH','2','Minimum length of company name',2,6,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (25,'Post Code','ENTRY_POSTCODE_MIN_LENGTH','4','Minimum length of post code',2,7,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (26,'City','ENTRY_CITY_MIN_LENGTH','3','Minimum length of city',2,8,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (27,'State','ENTRY_STATE_MIN_LENGTH','2','Minimum length of state',2,9,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (28,'Telephone Number','ENTRY_TELEPHONE_MIN_LENGTH','3','Minimum length of telephone number',2,10,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (29,'Password','ENTRY_PASSWORD_MIN_LENGTH','5','Minimum length of password',2,11,NULL,'2003-05-01 12:26:45',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,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (31,'Credit Card Number','CC_NUMBER_MIN_LENGTH','10','Minimum length of credit card number',2,13,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (32,'Review Text','REVIEW_TEXT_MIN_LENGTH','50','Minimum length of review text',2,14,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (33,'Best Sellers','MIN_DISPLAY_BESTSELLERS','1','Minimum number of best sellers to display',2,15,NULL,'2003-05-01 12:26:45',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,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (35,'Address Book Entries','MAX_ADDRESS_BOOK_ENTRIES','5','Maximum address book entries a customer is allowed to have',3,1,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (36,'Search Results','MAX_DISPLAY_SEARCH_RESULTS','20','Amount of products to list',3,2,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (37,'Page Links','MAX_DISPLAY_PAGE_LINKS','5','Number of \'number\' links use for page-sets',3,3,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (38,'Special Products','MAX_DISPLAY_SPECIAL_PRODUCTS','9','Maximum number of products on special to display',3,4,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (39,'New Products Module','MAX_DISPLAY_NEW_PRODUCTS','9','Maximum number of new products to display in a category',3,5,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (40,'Products Expected','MAX_DISPLAY_UPCOMING_PRODUCTS','10','Maximum number of products expected to display',3,6,NULL,'2003-05-01 12:26:45',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',3,7,NULL,'2003-05-01 12:26:45',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.',3,7,NULL,'2003-05-01 12:26:45',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',3,8,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (44,'New Reviews','MAX_DISPLAY_NEW_REVIEWS','6','Maximum number of new reviews to display',3,9,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (45,'Selection of Random Reviews','MAX_RANDOM_SELECT_REVIEWS','10','How many records to select from to choose one random product review',3,10,NULL,'2003-05-01 12:26:45',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',3,11,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (47,'Selection of Products on Special','MAX_RANDOM_SELECT_SPECIALS','10','How many records to select from to choose one random product special to display',3,12,NULL,'2003-05-01 12:26:45',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',3,13,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (49,'New Products Listing','MAX_DISPLAY_PRODUCTS_NEW','10','Maximum number of new products to display in new products page',3,14,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (50,'Best Sellers','MAX_DISPLAY_BESTSELLERS','10','Maximum number of best sellers to display',3,15,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (51,'Also Purchased','MAX_DISPLAY_ALSO_PURCHASED','6','Maximum number of products to display in the \'This Customer Also Purchased\' box',3,16,NULL,'2003-05-01 12:26:45',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',3,17,NULL,'2003-05-01 12:26:45',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',3,18,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (54,'Small Image Width','SMALL_IMAGE_WIDTH','100','The pixel width of small images',4,1,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (55,'Small Image Height','SMALL_IMAGE_HEIGHT','80','The pixel height of small images',4,2,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (56,'Heading Image Width','HEADING_IMAGE_WIDTH','57','The pixel width of heading images',4,3,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (57,'Heading Image Height','HEADING_IMAGE_HEIGHT','40','The pixel height of heading images',4,4,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (58,'Subcategory Image Width','SUBCATEGORY_IMAGE_WIDTH','100','The pixel width of subcategory images',4,5,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (59,'Subcategory Image Height','SUBCATEGORY_IMAGE_HEIGHT','57','The pixel height of subcategory images',4,6,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (60,'Calculate Image Size','CONFIG_CALCULATE_IMAGE_SIZE','true','Calculate the size of images?',4,7,NULL,'2003-05-01 12:26:45',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,'2003-05-01 12:26:45',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (62,'Gender','ACCOUNT_GENDER','false','Display gender in the custommers account',5,1,NULL,'2003-05-01 12:26:45',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (63,'Date of Birth','ACCOUNT_DOB','false','Display date of birth in the custommers account',5,2,NULL,'2003-05-01 12:26:45',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (64,'Company','ACCOUNT_COMPANY','false','Display company in the custommers account',5,3,NULL,'2003-05-01 12:26:45',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (65,'Suburb','ACCOUNT_SUBURB','false','Display suburb in the custommers account',5,4,NULL,'2003-05-01 12:26:45',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (66,'State','ACCOUNT_STATE','true','Display state in the custommers account',5,5,NULL,'2003-05-01 12:26:45',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (67,'Installed Modules','MODULE_PAYMENT_INSTALLED','cc.php;cod.php','List of payment module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: cc.php;cod.php;paypal.php)',6,0,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (68,'Installed Modules','MODULE_ORDER_TOTAL_INSTALLED','ot_subtotal.php;ot_shipping.php;ot_tax.php;ot_total.php','List of order_total module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php)',6,0,'2003-05-01 12:31:41','2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (69,'Installed Modules','MODULE_SHIPPING_INSTALLED','flat.php','List of shipping module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: ups.php;flat.php;item.php)',6,0,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (70,'Enable Cash On Delivery Module','MODULE_PAYMENT_COD_STATUS','True','Do you want to accept Cash On Delevery payments?',6,1,NULL,'2003-05-01 12:26:45',NULL,'tep_cfg_select_option(array(\'True\', \'False\'),'); INSERT INTO configuration VALUES (71,'Payment Zone','MODULE_PAYMENT_COD_ZONE','0','If a zone is selected, only enable this payment method for that zone.',6,2,NULL,'2003-05-01 12:26:45','tep_get_zone_class_title','tep_cfg_pull_down_zone_classes('); INSERT INTO configuration VALUES (72,'Sort order of display.','MODULE_PAYMENT_COD_SORT_ORDER','0','Sort order of display. Lowest is displayed first.',6,0,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (73,'Set Order Status','MODULE_PAYMENT_COD_ORDER_STATUS_ID','0','Set the status of orders made with this payment module to this value',6,0,NULL,'2003-05-01 12:26:45','tep_get_order_status_name','tep_cfg_pull_down_order_statuses('); INSERT INTO configuration VALUES (74,'Enable Credit Card Module','MODULE_PAYMENT_CC_STATUS','True','Do you want to accept credit card payments?',6,0,NULL,'2003-05-01 12:26:45',NULL,'tep_cfg_select_option(array(\'True\', \'False\'),'); INSERT INTO configuration VALUES (75,'Split Credit Card E-Mail Address','MODULE_PAYMENT_CC_EMAIL','','If an e-mail address is entered, the middle digits of the credit card number will be sent to the e-mail address (the outside digits are stored in the database with the middle digits censored)',6,0,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (76,'Sort order of display.','MODULE_PAYMENT_CC_SORT_ORDER','0','Sort order of display. Lowest is displayed first.',6,0,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (77,'Payment Zone','MODULE_PAYMENT_CC_ZONE','0','If a zone is selected, only enable this payment method for that zone.',6,2,NULL,'2003-05-01 12:26:45','tep_get_zone_class_title','tep_cfg_pull_down_zone_classes('); INSERT INTO configuration VALUES (78,'Set Order Status','MODULE_PAYMENT_CC_ORDER_STATUS_ID','0','Set the status of orders made with this payment module to this value',6,0,NULL,'2003-05-01 12:26:45','tep_get_order_status_name','tep_cfg_pull_down_order_statuses('); INSERT INTO configuration VALUES (79,'Enable Flat Shipping','MODULE_SHIPPING_FLAT_STATUS','True','Do you want to offer flat rate shipping?',6,0,NULL,'2003-05-01 12:26:45',NULL,'tep_cfg_select_option(array(\'True\', \'False\'),'); INSERT INTO configuration VALUES (80,'Shipping Cost','MODULE_SHIPPING_FLAT_COST','5.00','The shipping cost for all orders using this shipping method.',6,0,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (81,'Tax Class','MODULE_SHIPPING_FLAT_TAX_CLASS','0','Use the following tax class on the shipping fee.',6,0,NULL,'2003-05-01 12:26:45','tep_get_tax_class_title','tep_cfg_pull_down_tax_classes('); INSERT INTO configuration VALUES (82,'Shipping Zone','MODULE_SHIPPING_FLAT_ZONE','0','If a zone is selected, only enable this shipping method for that zone.',6,0,NULL,'2003-05-01 12:26:45','tep_get_zone_class_title','tep_cfg_pull_down_zone_classes('); INSERT INTO configuration VALUES (83,'Sort Order','MODULE_SHIPPING_FLAT_SORT_ORDER','0','Sort order of display.',6,0,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (84,'Default Currency','DEFAULT_CURRENCY','USD','Default Currency',6,0,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (85,'Default Language','DEFAULT_LANGUAGE','en','Default Language',6,0,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (86,'Default Order Status For New Orders','DEFAULT_ORDERS_STATUS_ID','1','When a new order is created, this order status will be assigned to it.',6,0,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (87,'Display Shipping','MODULE_ORDER_TOTAL_SHIPPING_STATUS','true','Do you want to display the order shipping cost?',6,1,NULL,'2003-05-01 12:26:45',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (88,'Sort Order','MODULE_ORDER_TOTAL_SHIPPING_SORT_ORDER','2','Sort order of display.',6,2,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (89,'Allow Free Shipping','MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING','false','Do you want to allow free shipping?',6,3,NULL,'2003-05-01 12:26:45',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (90,'Free Shipping For Orders Over','MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER','50','Provide free shipping for orders over the set amount.',6,4,NULL,'2003-05-01 12:26:45','currencies->format',NULL); INSERT INTO configuration VALUES (91,'Provide Free Shipping For Orders Made','MODULE_ORDER_TOTAL_SHIPPING_DESTINATION','national','Provide free shipping for orders sent to the set destination.',6,5,NULL,'2003-05-01 12:26:45',NULL,'tep_cfg_select_option(array(\'national\', \'international\', \'both\'),'); INSERT INTO configuration VALUES (92,'Display Sub-Total','MODULE_ORDER_TOTAL_SUBTOTAL_STATUS','true','Do you want to display the order sub-total cost?',6,1,NULL,'2003-05-01 12:26:45',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (93,'Sort Order','MODULE_ORDER_TOTAL_SUBTOTAL_SORT_ORDER','1','Sort order of display.',6,2,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (94,'Display Tax','MODULE_ORDER_TOTAL_TAX_STATUS','true','Do you want to display the order tax value?',6,1,NULL,'2003-05-01 12:26:45',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (95,'Sort Order','MODULE_ORDER_TOTAL_TAX_SORT_ORDER','3','Sort order of display.',6,2,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (96,'Display Total','MODULE_ORDER_TOTAL_TOTAL_STATUS','true','Do you want to display the total order value?',6,1,NULL,'2003-05-01 12:26:45',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (97,'Sort Order','MODULE_ORDER_TOTAL_TOTAL_SORT_ORDER','4','Sort order of display.',6,2,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (98,'Country Code','STORE_ORIGIN_COUNTRY','NONE','Enter the "ISO 3166" Country Code of the Store to be used in shipping quotes. To find your country code, visit the ISO 3166 Maintenance Agency.',7,1,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (99,'Postal Code','STORE_ORIGIN_ZIP','NONE','Enter the Postal Code (ZIP) of the Store to be used in shipping quotes.',7,2,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (100,'Enter the Maximum Package Weight you will ship','SHIPPING_MAX_WEIGHT','50','Carriers have a max weight limit for a single package. This is a common one for all.',7,3,NULL,'2003-05-01 12:26:45',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,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (102,'Larger packages - percentage increase.','SHIPPING_BOX_PADDING','10','For 10% enter 10',7,5,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (103,'Display Product Image','PRODUCT_LIST_IMAGE','0','Do you want to display the Product Image?',8,1,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (104,'Display Product Manufaturer Name','PRODUCT_LIST_MANUFACTURER','0','Do you want to display the Product Manufacturer Name?',8,2,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (105,'Display Product Model','PRODUCT_LIST_MODEL','0','Do you want to display the Product Model?',8,3,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (106,'Display Product Name','PRODUCT_LIST_NAME','1','Do you want to display the Product Name?',8,4,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (107,'Display Product Price','PRODUCT_LIST_PRICE','2','Do you want to display the Product Price',8,5,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (108,'Display Product Quantity','PRODUCT_LIST_QUANTITY','0','Do you want to display the Product Quantity?',8,6,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (109,'Display Product Weight','PRODUCT_LIST_WEIGHT','0','Do you want to display the Product Weight?',8,7,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (110,'Display Buy Now column','PRODUCT_LIST_BUY_NOW','0','Do you want to display the Buy Now column?',8,8,NULL,'2003-05-01 12:26:45',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?',8,9,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (112,'Location of Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)','PREV_NEXT_BAR_LOCATION','2','Sets the location of the Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)',8,10,NULL,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (113,'Check stock level','STOCK_CHECK','true','Check to see if sufficent stock is available',9,1,NULL,'2003-05-01 12:26:45',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,'2003-05-01 12:26:45',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,'2003-05-01 12:26:45',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,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (117,'Stock Re-order level','STOCK_REORDER_LEVEL','5','Define when stock needs to be re-ordered',9,5,NULL,'2003-05-01 12:26:45',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,'2003-05-01 12:26:45',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,'2003-05-01 12:26:45',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,'2003-05-01 12:26:45',NULL,NULL); INSERT INTO configuration VALUES (121,'Display The Page Parse Time','DISPLAY_PAGE_PARSE_TIME','true','Display the page parse time (store page parse time must be enabled)',10,4,NULL,'2003-05-01 12:26:45',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,'2003-05-01 12:26:45',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (123,'Use Cache','USE_CACHE','false','Use caching features',11,1,NULL,'2003-05-01 12:26:45',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,'2003-05-01 12:26:45',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,'2003-05-01 12:26:45',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,'2003-05-01 12:26:45',NULL,'tep_cfg_select_option(array(\'LF\', \'CRLF\'),'); INSERT INTO configuration VALUES (127,'Use MIME HTML When Sending Emails','EMAIL_USE_HTML','false','Send e-mails in HTML format',12,3,NULL,'2003-05-01 12:26:45',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,'2003-05-01 12:26:45',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,'2003-05-01 12:26:45',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (130,'Enable download','DOWNLOAD_ENABLED','false','Enable the products download functions.',13,1,NULL,'2003-05-01 12:26:45',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (131,'Download by redirect','DOWNLOAD_BY_REDIRECT','false','Use browser redirection for download. Disable on non-Unix systems.',13,2,NULL,'2003-05-01 12:26:45',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,NULL,'2003-05-01 12:26:45',NULL,''); INSERT INTO configuration VALUES (133,'Maximum number of downloads','DOWNLOAD_MAX_COUNT','5','Set the maximum number of downloads. 0 means no download authorized.',13,4,NULL,'2003-05-01 12:26:45',NULL,''); INSERT INTO configuration VALUES (134,'Enable GZip Compression','GZIP_COMPRESSION','false','Enable HTTP GZip compression.',14,1,NULL,'2003-05-01 12:26:45',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (135,'Compression Level','GZIP_LEVEL','5','Use this compression level 0-9 (0 = minimum, 9 = maximum).',14,2,NULL,'2003-05-01 12:26:45',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) ) TYPE=MyISAM; -- -- 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 (5,'Customer Details','Customer account configuration',5,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); INSERT INTO configuration_group VALUES (10,'Logging','Logging configuration options',10,1); INSERT INTO configuration_group VALUES (11,'Cache','Caching configuration options',11,1); INSERT INTO configuration_group VALUES (12,'E-Mail Options','General setting for E-Mail transport and HTML E-Mails',12,1); INSERT INTO configuration_group VALUES (13,'Download','Downloadable products options',13,1); INSERT INTO configuration_group VALUES (14,'GZip Compression','GZip compression options',14,1); -- -- Table structure for table 'counter' -- CREATE TABLE counter ( startdate char(8) default NULL, counter int(12) default NULL ) TYPE=MyISAM; -- -- Dumping data for table 'counter' -- INSERT INTO counter VALUES ('20030501',2); -- -- Table structure for table 'counter_history' -- CREATE TABLE counter_history ( month char(8) default NULL, counter int(12) default NULL ) TYPE=MyISAM; -- -- Dumping data for table 'counter_history' -- -- -- Table structure for table 'countries' -- CREATE TABLE countries ( countries_id int(11) NOT NULL auto_increment, countries_name varchar(64) NOT NULL default '', countries_iso_code_2 char(2) NOT NULL default '', countries_iso_code_3 char(3) NOT NULL default '', address_format_id int(11) NOT NULL default '0', PRIMARY KEY (countries_id), KEY IDX_COUNTRIES_NAME (countries_name) ) TYPE=MyISAM; -- -- Dumping data for table 'countries' -- INSERT INTO countries VALUES (1,'Afghanistan','AF','AFG',1); 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',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); -- -- 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) ) TYPE=MyISAM; -- -- Dumping data for table 'currencies' -- INSERT INTO currencies VALUES (1,'US Dollar','USD','$','','.',',','2',1.00000000,'2003-05-01 12:26:45'); INSERT INTO currencies VALUES (2,'Deutsche Mark','DEM','','DM',',','.','2',2.15849996,'2003-05-01 12:26:45'); INSERT INTO currencies VALUES (3,'Spanish Peseta','ESP','','Pts','.',',','0',183.62399292,'2003-05-01 12:26:45'); INSERT INTO currencies VALUES (4,'Euro','EUR','','EUR','.',',','2',1.10360003,'2003-05-01 12:26:45'); -- -- 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(5) NOT NULL default '1', customers_telephone varchar(32) NOT NULL default '', customers_fax varchar(32) default NULL, customers_password varchar(40) NOT NULL default '', customers_newsletter char(1) default NULL, PRIMARY KEY (customers_id) ) TYPE=MyISAM; -- -- Dumping data for table 'customers' -- INSERT INTO customers VALUES (1,'m','John','doe','2001-01-01 00:00:00','root@localhost',1,'12345','','d95e8fa7f20a009372eb3477473fcd34:1c','0'); -- -- 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) ) TYPE=MyISAM; -- -- 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) ) TYPE=MyISAM; -- -- 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) ) TYPE=MyISAM; -- -- Dumping data for table 'customers_info' -- INSERT INTO customers_info VALUES (1,'0000-00-00 00:00:00',0,'2003-05-01 12:26:45','0000-00-00 00:00:00',0); -- -- 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) ) TYPE=MyISAM; -- -- Dumping data for table 'geo_zones' -- INSERT INTO geo_zones VALUES (1,'Florida','Florida local sales tax zone',NULL,'2003-05-01 12:26:45'); -- -- 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) ) TYPE=MyISAM; -- -- Dumping data for table 'languages' -- INSERT INTO languages VALUES (1,'English','en','icon.gif','english',1); INSERT INTO languages VALUES (2,'Deutsch','de','icon.gif','german',2); INSERT INTO languages VALUES (3,'Español','es','icon.gif','espanol',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) ) TYPE=MyISAM; -- -- Dumping data for table 'manufacturers' -- INSERT INTO manufacturers VALUES (1,'Matrox','manufacturer_matrox.gif','2003-05-01 12:26:45',NULL); INSERT INTO manufacturers VALUES (2,'Microsoft','manufacturer_microsoft.gif','2003-05-01 12:26:45',NULL); INSERT INTO manufacturers VALUES (3,'Warner','manufacturer_warner.gif','2003-05-01 12:26:45',NULL); INSERT INTO manufacturers VALUES (4,'Fox','manufacturer_fox.gif','2003-05-01 12:26:45',NULL); INSERT INTO manufacturers VALUES (5,'Logitech','manufacturer_logitech.gif','2003-05-01 12:26:45',NULL); INSERT INTO manufacturers VALUES (6,'Canon','manufacturer_canon.gif','2003-05-01 12:26:45',NULL); INSERT INTO manufacturers VALUES (7,'Sierra','manufacturer_sierra.gif','2003-05-01 12:26:45',NULL); INSERT INTO manufacturers VALUES (8,'GT Interactive','manufacturer_gt_interactive.gif','2003-05-01 12:26:45',NULL); INSERT INTO manufacturers VALUES (9,'Hewlett Packard','manufacturer_hewlett_packard.gif','2003-05-01 12:26:45',NULL); -- -- 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) ) TYPE=MyISAM; -- -- Dumping data for table 'manufacturers_info' -- INSERT INTO manufacturers_info VALUES (1,1,'http://www.matrox.com',0,NULL); INSERT INTO manufacturers_info VALUES (1,2,'http://www.matrox.de',0,NULL); INSERT INTO manufacturers_info VALUES (1,3,'http://www.matrox.com',0,NULL); INSERT INTO manufacturers_info VALUES (2,1,'http://www.microsoft.com',0,NULL); INSERT INTO manufacturers_info VALUES (2,2,'http://www.microsoft.de',0,NULL); INSERT INTO manufacturers_info VALUES (2,3,'http://www.microsoft.es',0,NULL); INSERT INTO manufacturers_info VALUES (3,1,'http://www.warner.com',0,NULL); INSERT INTO manufacturers_info VALUES (3,2,'http://www.warner.de',0,NULL); INSERT INTO manufacturers_info VALUES (3,3,'http://www.warner.com',0,NULL); INSERT INTO manufacturers_info VALUES (4,1,'http://www.fox.com',0,NULL); INSERT INTO manufacturers_info VALUES (4,2,'http://www.fox.de',0,NULL); INSERT INTO manufacturers_info VALUES (4,3,'http://www.fox.com',0,NULL); INSERT INTO manufacturers_info VALUES (5,1,'http://www.logitech.com',0,NULL); INSERT INTO manufacturers_info VALUES (5,2,'http://www.logitech.com',0,NULL); INSERT INTO manufacturers_info VALUES (5,3,'http://www.logitech.com',0,NULL); INSERT INTO manufacturers_info VALUES (6,1,'http://www.canon.com',0,NULL); INSERT INTO manufacturers_info VALUES (6,2,'http://www.canon.de',0,NULL); INSERT INTO manufacturers_info VALUES (6,3,'http://www.canon.es',0,NULL); INSERT INTO manufacturers_info VALUES (7,1,'http://www.sierra.com',0,NULL); INSERT INTO manufacturers_info VALUES (7,2,'http://www.sierra.de',0,NULL); INSERT INTO manufacturers_info VALUES (7,3,'http://www.sierra.com',0,NULL); INSERT INTO manufacturers_info VALUES (8,1,'http://www.infogrames.com',0,NULL); INSERT INTO manufacturers_info VALUES (8,2,'http://www.infogrames.de',0,NULL); INSERT INTO manufacturers_info VALUES (8,3,'http://www.infogrames.com',0,NULL); INSERT INTO manufacturers_info VALUES (9,1,'http://www.hewlettpackard.com',0,NULL); INSERT INTO manufacturers_info VALUES (9,2,'http://www.hewlettpackard.de',0,NULL); INSERT INTO manufacturers_info VALUES (9,3,'http://welcome.hp.com/country/es/spa/welcome.htm',0,NULL); -- -- 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) ) TYPE=MyISAM; -- -- Dumping data for table 'newsletters' -- -- -- 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 '0', orders_date_finished datetime default NULL, currency char(3) default NULL, currency_value decimal(14,6) default NULL, PRIMARY KEY (orders_id) ) TYPE=MyISAM; -- -- Dumping data for table 'orders' -- -- -- 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) ) TYPE=MyISAM; -- -- 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) ) TYPE=MyISAM; -- -- 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 '0', download_count int(2) NOT NULL default '0', PRIMARY KEY (orders_products_download_id) ) TYPE=MyISAM; -- -- Dumping data for table 'orders_products_download' -- -- -- Table structure for table 'orders_status' -- CREATE TABLE orders_status ( orders_status_id int(11) NOT NULL default '0', language_id int(11) NOT NULL default '1', orders_status_name varchar(32) NOT NULL default '', PRIMARY KEY (orders_status_id,language_id), KEY idx_orders_status_name (orders_status_name) ) TYPE=MyISAM; -- -- Dumping data for table 'orders_status' -- INSERT INTO orders_status VALUES (1,1,'Pending'); 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'); -- -- 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 '0', date_added datetime NOT NULL default '0000-00-00 00:00:00', customer_notified int(1) default '0', comments text, PRIMARY KEY (orders_status_history_id) ) TYPE=MyISAM; -- -- Dumping data for table 'orders_status_history' -- -- -- 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) ) TYPE=MyISAM; -- -- 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) ) TYPE=MyISAM; -- -- Dumping data for table 'products' -- INSERT INTO products VALUES (1,32,'MG200MMS','matrox/mg200mms.gif',299.9900,'2003-05-01 12:26:45',NULL,'0000-00-00 00:00:00',23.00,1,1,1,0); INSERT INTO products VALUES (2,32,'MG400-32MB','matrox/mg400-32mb.gif',499.9900,'2003-05-01 12:26:45',NULL,'0000-00-00 00:00:00',23.00,1,1,1,0); INSERT INTO products VALUES (3,2,'MSIMPRO','microsoft/msimpro.gif',49.9900,'2003-05-01 12:26:45',NULL,'0000-00-00 00:00:00',7.00,1,1,3,0); INSERT INTO products VALUES (4,13,'DVD-RPMK','dvd/replacement_killers.gif',42.0000,'2003-05-01 12:26:45',NULL,'0000-00-00 00:00:00',23.00,1,1,2,0); INSERT INTO products VALUES (5,17,'DVD-BLDRNDC','dvd/blade_runner.gif',35.9900,'2003-05-01 12:26:45',NULL,'0000-00-00 00:00:00',7.00,1,1,3,0); INSERT INTO products VALUES (6,10,'DVD-MATR','dvd/the_matrix.gif',39.9900,'2003-05-01 12:26:45',NULL,'0000-00-00 00:00:00',7.00,1,1,3,0); INSERT INTO products VALUES (7,10,'DVD-YGEM','dvd/youve_got_mail.gif',34.9900,'2003-05-01 12:26:45',NULL,'0000-00-00 00:00:00',7.00,1,1,3,0); INSERT INTO products VALUES (8,10,'DVD-ABUG','dvd/a_bugs_life.gif',35.9900,'2003-05-01 12:26:45',NULL,'0000-00-00 00:00:00',7.00,1,1,3,0); INSERT INTO products VALUES (9,10,'DVD-UNSG','dvd/under_siege.gif',29.9900,'2003-05-01 12:26:45',NULL,'0000-00-00 00:00:00',7.00,1,1,3,0); INSERT INTO products VALUES (10,10,'DVD-UNSG2','dvd/under_siege2.gif',29.9900,'2003-05-01 12:26:45',NULL,'0000-00-00 00:00:00',7.00,1,1,3,0); INSERT INTO products VALUES (11,10,'DVD-FDBL','dvd/fire_down_below.gif',29.9900,'2003-05-01 12:26:45',NULL,'0000-00-00 00:00:00',7.00,1,1,3,0); INSERT INTO products VALUES (12,10,'DVD-DHWV','dvd/die_hard_3.gif',39.9900,'2003-05-01 12:26:45',NULL,'0000-00-00 00:00:00',7.00,1,1,4,0); INSERT INTO products VALUES (13,10,'DVD-LTWP','dvd/lethal_weapon.gif',34.9900,'2003-05-01 12:26:45',NULL,'0000-00-00 00:00:00',7.00,1,1,3,0); INSERT INTO products VALUES (14,10,'DVD-REDC','dvd/red_corner.gif',32.0000,'2003-05-01 12:26:45',NULL,'0000-00-00 00:00:00',7.00,1,1,3,0); INSERT INTO products VALUES (15,10,'DVD-FRAN','dvd/frantic.gif',35.0000,'2003-05-01 12:26:45',NULL,'0000-00-00 00:00:00',7.00,1,1,3,0); INSERT INTO products VALUES (16,10,'DVD-CUFI','dvd/courage_under_fire.gif',38.9900,'2003-05-01 12:26:45',NULL,'0000-00-00 00:00:00',7.00,1,1,4,0); INSERT INTO products VALUES (17,10,'DVD-SPEED','dvd/speed.gif',39.9900,'2003-05-01 12:26:45',NULL,'0000-00-00 00:00:00',7.00,1,1,4,0); INSERT INTO products VALUES (18,10,'DVD-SPEED2','dvd/speed_2.gif',42.0000,'2003-05-01 12:26:45',NULL,'0000-00-00 00:00:00',7.00,1,1,4,0); INSERT INTO products VALUES (19,10,'DVD-TSAB','dvd/theres_something_about_mary.gif',49.9900,'2003-05-01 12:26:45',NULL,'0000-00-00 00:00:00',7.00,1,1,4,0); INSERT INTO products VALUES (20,10,'DVD-BELOVED','dvd/beloved.gif',54.9900,'2003-05-01 12:26:45',NULL,'0000-00-00 00:00:00',7.00,1,1,3,0); INSERT INTO products VALUES (21,16,'PC-SWAT3','sierra/swat_3.gif',79.9900,'2003-05-01 12:26:45',NULL,'0000-00-00 00:00:00',7.00,1,1,7,0); INSERT INTO products VALUES (22,13,'PC-UNTM','gt_interactive/unreal_tournament.gif',89.9900,'2003-05-01 12:26:45',NULL,'0000-00-00 00:00:00',7.00,1,1,8,0); INSERT INTO products VALUES (23,16,'PC-TWOF','gt_interactive/wheel_of_time.gif',99.9900,'2003-05-01 12:26:45',NULL,'0000-00-00 00:00:00',10.00,1,1,8,0); INSERT INTO products VALUES (24,17,'PC-DISC','gt_interactive/disciples.gif',90.0000,'2003-05-01 12:26:45',NULL,'0000-00-00 00:00:00',8.00,1,1,8,0); INSERT INTO products VALUES (25,16,'MSINTKB','microsoft/intkeyboardps2.gif',69.9900,'2003-05-01 12:26:45',NULL,'0000-00-00 00:00:00',8.00,1,1,2,0); INSERT INTO products VALUES (26,10,'MSIMEXP','microsoft/imexplorer.gif',64.9500,'2003-05-01 12:26:45',NULL,'0000-00-00 00:00:00',8.00,1,1,2,0); INSERT INTO products VALUES (27,8,'HPLJ1100XI','hewlett_packard/lj1100xi.gif',499.9900,'2003-05-01 12:26:45',NULL,'0000-00-00 00:00:00',45.00,1,1,9,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 '', PRIMARY KEY (products_attributes_id) ) TYPE=MyISAM; -- -- Dumping data for table 'products_attributes' -- INSERT INTO products_attributes VALUES (1,1,4,1,0.0000,'+'); INSERT INTO products_attributes VALUES (2,1,4,2,50.0000,'+'); INSERT INTO products_attributes VALUES (3,1,4,3,70.0000,'+'); INSERT INTO products_attributes VALUES (4,1,3,5,0.0000,'+'); INSERT INTO products_attributes VALUES (5,1,3,6,100.0000,'+'); INSERT INTO products_attributes VALUES (6,2,4,3,10.0000,'-'); INSERT INTO products_attributes VALUES (7,2,4,4,0.0000,'+'); INSERT INTO products_attributes VALUES (8,2,3,6,0.0000,'+'); INSERT INTO products_attributes VALUES (9,2,3,7,120.0000,'+'); INSERT INTO products_attributes VALUES (10,26,3,8,0.0000,'+'); INSERT INTO products_attributes VALUES (11,26,3,9,6.0000,'+'); INSERT INTO products_attributes VALUES (26,22,5,10,0.0000,'+'); INSERT INTO products_attributes VALUES (27,22,5,13,0.0000,'+'); -- -- 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 '0', products_attributes_maxcount int(2) default '0', PRIMARY KEY (products_attributes_id) ) TYPE=MyISAM; -- -- Dumping data for table 'products_attributes_download' -- INSERT INTO products_attributes_download VALUES (26,'unreal.zip',7,3); -- -- Table structure for table 'products_description' -- CREATE TABLE products_description ( products_id int(11) NOT NULL auto_increment, language_id int(11) NOT NULL default '1', products_name varchar(64) NOT NULL default '', products_description text, products_url varchar(255) default NULL, products_viewed int(5) default '0', PRIMARY KEY (products_id,language_id), KEY products_name (products_name) ) TYPE=MyISAM; -- -- Dumping data for table 'products_description' -- INSERT INTO products_description VALUES (1,1,'Matrox G200 MMS','Reinforcing its position as a multi-monitor trailblazer, Matrox Graphics Inc. has once again developed the most flexible and highly advanced solution in the industry. Introducing the new Matrox G200 Multi-Monitor Series; the first graphics card ever to support up to four DVI digital flat panel displays on a single 8" PCI board.

With continuing demand for digital flat panels in the financial workplace, the Matrox G200 MMS is the ultimate in flexible solutions. The Matrox G200 MMS also supports the new digital video interface (DVI) created by the Digital Display Working Group (DDWG) designed to ease the adoption of digital flat panels. Other configurations include composite video capture ability and onboard TV tuner, making the Matrox G200 MMS the complete solution for business needs.

Based on the award-winning MGA-G200 graphics chip, the Matrox G200 Multi-Monitor Series provides superior 2D/3D graphics acceleration to meet the demanding needs of business applications such as real-time stock quotes (Versus), live video feeds (Reuters & Bloombergs), multiple windows applications, word processing, spreadsheets and CAD.','www.matrox.com/mga/products/g200_mms/home.cfm',0); INSERT INTO products_description VALUES (2,1,'Matrox G400 32MB','Dramatically Different High Performance Graphics

Introducing the Millennium G400 Series - a dramatically different, high performance graphics experience. Armed with the industry\'s fastest graphics chip, the Millennium G400 Series takes explosive acceleration two steps further by adding unprecedented image quality, along with the most versatile display options for all your 3D, 2D and DVD applications. As the most powerful and innovative tools in your PC\'s arsenal, the Millennium G400 Series will not only change the way you see graphics, but will revolutionize the way you use your computer.

Key features:','www.matrox.com/mga/products/mill_g400/home.htm',0); INSERT INTO products_description VALUES (3,1,'Microsoft IntelliMouse Pro','Every element of IntelliMouse Pro - from its unique arched shape to the texture of the rubber grip around its base - is the product of extensive customer and ergonomic research. Microsoft\'s popular wheel control, which now allows zooming and universal scrolling functions, gives IntelliMouse Pro outstanding comfort and efficiency.','www.microsoft.com/hardware/mouse/intellimouse.asp',0); INSERT INTO products_description VALUES (4,1,'The Replacement Killers','Regional Code: 2 (Japan, Europe, Middle East, South Africa).
Languages: English, Deutsch.
Subtitles: English, Deutsch, Spanish.
Audio: Dolby Surround 5.1.
Picture Format: 16:9 Wide-Screen.
Length: (approx) 80 minutes.
Other: Interactive Menus, Chapter Selection, Subtitles (more languages).','www.replacement-killers.com',0); INSERT INTO products_description VALUES (5,1,'Blade Runner - Director\'s Cut','Regional Code: 2 (Japan, Europe, Middle East, South Africa).
Languages: English, Deutsch.
Subtitles: English, Deutsch, Spanish.
Audio: Dolby Surround 5.1.
Picture Format: 16:9 Wide-Screen.
Length: (approx) 112 minutes.
Other: Interactive Menus, Chapter Selection, Subtitles (more languages).','www.bladerunner.com',0); INSERT INTO products_description VALUES (6,1,'The Matrix','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r
\nLanguages: English, Deutsch.\r
\nSubtitles: English, Deutsch.\r
\nAudio: Dolby Surround.\r
\nPicture Format: 16:9 Wide-Screen.\r
\nLength: (approx) 131 minutes.\r
\nOther: Interactive Menus, Chapter Selection, Making Of.','www.thematrix.com',0); INSERT INTO products_description VALUES (7,1,'You\'ve Got Mail','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r
\nLanguages: English, Deutsch, Spanish.\r
\nSubtitles: English, Deutsch, Spanish, French, Nordic, Polish.\r
\nAudio: Dolby Digital 5.1.\r
\nPicture Format: 16:9 Wide-Screen.\r
\nLength: (approx) 115 minutes.\r
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','www.youvegotmail.com',0); INSERT INTO products_description VALUES (8,1,'A Bug\'s Life','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r
\nLanguages: English, Deutsch.\r
\nSubtitles: English, Deutsch, Spanish.\r
\nAudio: Dolby Digital 5.1 / Dobly Surround Stereo.\r
\nPicture Format: 16:9 Wide-Screen.\r
\nLength: (approx) 91 minutes.\r
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','www.abugslife.com',0); INSERT INTO products_description VALUES (9,1,'Under Siege','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r
\nLanguages: English, Deutsch.\r
\nSubtitles: English, Deutsch, Spanish.\r
\nAudio: Dolby Surround 5.1.\r
\nPicture Format: 16:9 Wide-Screen.\r
\nLength: (approx) 98 minutes.\r
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); INSERT INTO products_description VALUES (10,1,'Under Siege 2 - Dark Territory','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r
\nLanguages: English, Deutsch.\r
\nSubtitles: English, Deutsch, Spanish.\r
\nAudio: Dolby Surround 5.1.\r
\nPicture Format: 16:9 Wide-Screen.\r
\nLength: (approx) 98 minutes.\r
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); INSERT INTO products_description VALUES (11,1,'Fire Down Below','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r
\nLanguages: English, Deutsch.\r
\nSubtitles: English, Deutsch, Spanish.\r
\nAudio: Dolby Surround 5.1.\r
\nPicture Format: 16:9 Wide-Screen.\r
\nLength: (approx) 100 minutes.\r
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); INSERT INTO products_description VALUES (12,1,'Die Hard With A Vengeance','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r
\nLanguages: English, Deutsch.\r
\nSubtitles: English, Deutsch, Spanish.\r
\nAudio: Dolby Surround 5.1.\r
\nPicture Format: 16:9 Wide-Screen.\r
\nLength: (approx) 122 minutes.\r
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); INSERT INTO products_description VALUES (13,1,'Lethal Weapon','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r
\nLanguages: English, Deutsch.\r
\nSubtitles: English, Deutsch, Spanish.\r
\nAudio: Dolby Surround 5.1.\r
\nPicture Format: 16:9 Wide-Screen.\r
\nLength: (approx) 100 minutes.\r
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); INSERT INTO products_description VALUES (14,1,'Red Corner','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r
\nLanguages: English, Deutsch.\r
\nSubtitles: English, Deutsch, Spanish.\r
\nAudio: Dolby Surround 5.1.\r
\nPicture Format: 16:9 Wide-Screen.\r
\nLength: (approx) 117 minutes.\r
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); INSERT INTO products_description VALUES (15,1,'Frantic','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r
\nLanguages: English, Deutsch.\r
\nSubtitles: English, Deutsch, Spanish.\r
\nAudio: Dolby Surround 5.1.\r
\nPicture Format: 16:9 Wide-Screen.\r
\nLength: (approx) 115 minutes.\r
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); INSERT INTO products_description VALUES (16,1,'Courage Under Fire','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r
\nLanguages: English, Deutsch.\r
\nSubtitles: English, Deutsch, Spanish.\r
\nAudio: Dolby Surround 5.1.\r
\nPicture Format: 16:9 Wide-Screen.\r
\nLength: (approx) 112 minutes.\r
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); INSERT INTO products_description VALUES (17,1,'Speed','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r
\nLanguages: English, Deutsch.\r
\nSubtitles: English, Deutsch, Spanish.\r
\nAudio: Dolby Surround 5.1.\r
\nPicture Format: 16:9 Wide-Screen.\r
\nLength: (approx) 112 minutes.\r
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); INSERT INTO products_description VALUES (18,1,'Speed 2: Cruise Control','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r
\nLanguages: English, Deutsch.\r
\nSubtitles: English, Deutsch, Spanish.\r
\nAudio: Dolby Surround 5.1.\r
\nPicture Format: 16:9 Wide-Screen.\r
\nLength: (approx) 120 minutes.\r
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); INSERT INTO products_description VALUES (19,1,'There\'s Something About Mary','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r
\nLanguages: English, Deutsch.\r
\nSubtitles: English, Deutsch, Spanish.\r
\nAudio: Dolby Surround 5.1.\r
\nPicture Format: 16:9 Wide-Screen.\r
\nLength: (approx) 114 minutes.\r
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); INSERT INTO products_description VALUES (20,1,'Beloved','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r
\nLanguages: English, Deutsch.\r
\nSubtitles: English, Deutsch, Spanish.\r
\nAudio: Dolby Surround 5.1.\r
\nPicture Format: 16:9 Wide-Screen.\r
\nLength: (approx) 164 minutes.\r
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); INSERT INTO products_description VALUES (21,1,'SWAT 3: Close Quarters Battle','Windows 95/98

211 in progress with shots fired. Officer down. Armed suspects with hostages. Respond Code 3! Los Angles, 2005, In the next seven days, representatives from every nation around the world will converge on Las Angles to witness the signing of the United Nations Nuclear Abolishment Treaty. The protection of these dignitaries falls on the shoulders of one organization, LAPD SWAT. As part of this elite tactical organization, you and your team have the weapons and all the training necessary to protect, to serve, and \"When needed\" to use deadly force to keep the peace. It takes more than weapons to make it through each mission. Your arsenal includes C2 charges, flashbangs, tactical grenades. opti-Wand mini-video cameras, and other devices critical to meeting your objectives and keeping your men free of injury. Uncompromised Duty, Honor and Valor!','www.swat3.com',0); INSERT INTO products_description VALUES (22,1,'Unreal Tournament','From the creators of the best-selling Unreal, comes Unreal Tournament. A new kind of single player experience. A ruthless multiplayer revolution.

This stand-alone game showcases completely new team-based gameplay, groundbreaking multi-faceted single player action or dynamic multi-player mayhem. It\'s a fight to the finish for the title of Unreal Grand Master in the gladiatorial arena. A single player experience like no other! Guide your team of \'bots\' (virtual teamates) against the hardest criminals in the galaxy for the ultimate title - the Unreal Grand Master.','www.unrealtournament.net',0); INSERT INTO products_description VALUES (23,1,'The Wheel Of Time','The world in which The Wheel of Time takes place is lifted directly out of Jordan\'s pages; it\'s huge and consists of many different environments. How you navigate the world will depend largely on which game - single player or multipayer - you\'re playing. The single player experience, with a few exceptions, will see Elayna traversing the world mainly by foot (with a couple notable exceptions). In the multiplayer experience, your character will have more access to travel via Ter\'angreal, Portal Stones, and the Ways. However you move around, though, you\'ll quickly discover that means of locomotion can easily become the least of the your worries...

During your travels, you quickly discover that four locations are crucial to your success in the game. Not surprisingly, these locations are the homes of The Wheel of Time\'s main characters. Some of these places are ripped directly from the pages of Jordan\'s books, made flesh with Legend\'s unparalleled pixel-pushing ways. Other places are specific to the game, conceived and executed with the intent of expanding this game world even further. Either way, they provide a backdrop for some of the most intense first person action and strategy you\'ll have this year.','www.wheeloftime.com',0); INSERT INTO products_description VALUES (24,1,'Disciples: Sacred Lands','A new age is dawning...

Enter the realm of the Sacred Lands, where the dawn of a New Age has set in motion the most momentous of wars. As the prophecies long foretold, four races now clash with swords and sorcery in a desperate bid to control the destiny of their gods. Take on the quest as a champion of the Empire, the Mountain Clans, the Legions of the Damned, or the Undead Hordes and test your faith in battles of brute force, spellbinding magic and acts of guile. Slay demons, vanquish giants and combat merciless forces of the dead and undead. But to ensure the salvation of your god, the hero within must evolve.

The day of reckoning has come... and only the chosen will survive.','',0); INSERT INTO products_description VALUES (25,1,'Microsoft Internet Keyboard PS/2','The Internet Keyboard has 10 Hot Keys on a comfortable standard keyboard design that also includes a detachable palm rest. The Hot Keys allow you to browse the web, or check e-mail directly from your keyboard. The IntelliType Pro software also allows you to customize your hot keys - make the Internet Keyboard work the way you want it to!','',0); INSERT INTO products_description VALUES (26,1,'Microsoft IntelliMouse Explorer','Microsoft introduces its most advanced mouse, the IntelliMouse Explorer! IntelliMouse Explorer features a sleek design, an industrial-silver finish, a glowing red underside and taillight, creating a style and look unlike any other mouse. IntelliMouse Explorer combines the accuracy and reliability of Microsoft IntelliEye optical tracking technology, the convenience of two new customizable function buttons, the efficiency of the scrolling wheel and the comfort of expert ergonomic design. All these great features make this the best mouse for the PC!','www.microsoft.com/hardware/mouse/explorer.asp',0); INSERT INTO products_description VALUES (27,1,'Hewlett Packard LaserJet 1100Xi','HP has always set the pace in laser printing technology. The new generation HP LaserJet 1100 series sets another impressive pace, delivering a stunning 8 pages per minute print speed. The 600 dpi print resolution with HP\'s Resolution Enhancement technology (REt) makes every document more professional.

Enhanced print speed and laser quality results are just the beginning. With 2MB standard memory, HP LaserJet 1100xi users will be able to print increasingly complex pages. Memory can be increased to 18MB to tackle even more complex documents with ease. The HP LaserJet 1100xi supports key operating systems including Windows 3.1, 3.11, 95, 98, NT 4.0, OS/2 and DOS. Network compatibility available via the optional HP JetDirect External Print Servers.

HP LaserJet 1100xi also features The Document Builder for the Web Era from Trellix Corp. (featuring software to create Web documents).','www.pandi.hp.com/pandi-db/prodinfo.main?product=laserjet1100',0); INSERT INTO products_description VALUES (1,2,'Matrox G200 MMS','Unterstützung für zwei bzw. vier analoge oder digitale Monitore

\r\nDie Matrox G200 Multi-Monitor-Serie führt die bewährte Matrox Tradition im Multi-Monitor- Bereich fort und bietet flexible und fortschrittliche Lösungen.Matrox stellt als erstes Unternehmen einen vierfachen digitalen PanelLink® DVI Flachbildschirm Ausgang zur Verfügung. Mit den optional erhältlichen TV Tuner und Video-Capture Möglichkeiten stellt die Matrox G200 MMS eine alles umfassende Mehrschirm-Lösung dar.

\r\nLeistungsmerkmale:\r\n','www.matrox.com/mga/deutsch/products/g200_mms/home.cfm',0); INSERT INTO products_description VALUES (2,2,'Matrox G400 32 MB','Neu! Matrox G400 "all inclusive" und vieles mehr...

\r\nDie neue Millennium G400-Serie - Hochleistungsgrafik mit dem sensationellen Unterschied. Ausgestattet mit dem neu eingeführten Matrox G400 Grafikchip, bietet die Millennium G400-Serie eine überragende Beschleunigung inklusive bisher nie dagewesener Bildqualitat und enorm flexibler Darstellungsoptionen bei allen Ihren 3D-, 2D- und DVD-Anwendungen.

\r\n\r\n"Bleibt abschließend festzustellen, daß die Matrox Millennium G400 Max als Allroundkarte für den Highend-PC derzeit unerreicht ist. Das ergibt den Testsieg und unsere wärmste Empfehlung."
\r\nGameStar 8/99 (S.184)','www.matrox.com/mga/deutsch/products/mill_g400/home.cfm',0); INSERT INTO products_description VALUES (3,2,'Microsoft IntelliMouse Pro','Die IntelliMouse Pro hat mit der IntelliRad-Technologie einen neuen Standard gesetzt. Anwenderfreundliche Handhabung und produktiveres Arbeiten am PC zeichnen die IntelliMouse aus. Die gewölbte Oberseite paßt sich natürlich in die Handfläche ein, die geschwungene Form erleichtert das Bedienen der Maus. Sie ist sowohl für Rechts- wie auch für Linkshänder geeignet. Mit dem Rad der IntelliMouse kann der Anwender einfach und komfortabel durch Dokumente navigieren.

\r\nEigenschaften:\r\n','',0); INSERT INTO products_description VALUES (4,2,'Die Ersatzkiller','Originaltitel: "The Replacement Killers"

\r\nRegional Code: 2 (Japan, Europe, Middle East, South Africa).
\r\nSprachen: English, Deutsch.
\r\nUntertitel: English, Deutsch, Spanish.
\r\nAudio: Dolby Surround 5.1.
\r\nBildformat: 16:9 Wide-Screen.
\r\nDauer: (approx) 80 minutes.
\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.

\r\n(USA 1998). Til Schweiger schießt auf Hongkong-Star Chow Yun-Fat ("Anna und der König") ­ ein Fehler ...','www.replacement-killers.com',0); INSERT INTO products_description VALUES (5,2,'Blade Runner - Director\'s Cut','Regional Code: 2 (Japan, Europe, Middle East, South Africa).
\r\nSprachen: English, Deutsch.
\r\nUntertitel: English, Deutsch, Spanish.
\r\nAudio: Dolby Surround 5.1.
\r\nBildformat: 16:9 Wide-Screen.
\r\nDauer: (approx) 112 minutes.
\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.

\r\nSci-Fi-Klassiker, USA 1983, 112 Min.

\r\nLos Angeles ist im Jahr 2019 ein Hexenkessel. Dauerregen und Smog tauchen den überbevölkerten Moloch in ewige Dämmerung. Polizeigleiter schwirren durch die Luft und überwachen das grelle Ethnogemisch, das sich am Fuße 400stöckiger Stahlbeton-Pyramiden tummelt. Der abgehalfterte Ex-Cop und \"Blade Runner\" Rick Deckard ist Spezialist für die Beseitigung von Replikanten, künstlichen Menschen, geschaffen für harte Arbeit auf fremden Planeten. Nur ihm kann es gelingen, vier flüchtige, hochintelligente \"Nexus 6\"-Spezialmodelle zu stellen. Die sind mit ihrem starken und brandgefährlichen Anführer Batty auf der Suche nach ihrem Schöpfer. Er soll ihnen eine längere Lebenszeit schenken. Das muß Rick Deckard verhindern. Als sich der eiskalte Jäger in Rachel, die Sekretärin seines Auftraggebers, verliebt, gerät sein Weltbild jedoch ins Wanken. Er entdeckt, daß sie - vielleicht wie er selbst - ein Replikant ist ...

\r\nDie Konfrontation des Menschen mit \"Realität\" und \"Virtualität\" und das verstrickte Spiel mit getürkten Erinnerungen zieht sich als roter Faden durch das Werk von Autor Philip K. Dick (\"Die totale Erinnerung\"). Sein Roman \"Träumen Roboter von elektrischen Schafen?\" liefert die Vorlage für diesen doppelbödigen Thriller, der den Zuschauer mit faszinierenden\r\nZukunftsvisionen und der gigantischen Kulisse des Großstadtmolochs gefangen nimmt.','www.bladerunner.com',0); INSERT INTO products_description VALUES (6,2,'Matrix','Originaltitel: "The Matrix"

\r\nRegional Code: 2 (Japan, Europe, Middle East, South Africa).
\r\nSprachen: English, Deutsch.
\r\nUntertitel: English, Deutsch, Spanish.
\r\nAudio: Dolby Surround 5.1.
\r\nBildformat: 16:9 Wide-Screen.
\r\nDauer: (approx) 136 minuten.
\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.

\r\n(USA 1999) Der Geniestreich der Wachowski-Brüder. In dieser technisch perfekten Utopie kämpft Hacker Keanu Reeves gegen die Diktatur der Maschinen...','www.whatisthematrix.com',0); INSERT INTO products_description VALUES (7,2,'e-m@il für Dich','Original: "You\'ve got mail"
\r\nRegional Code: 2 (Japan, Europe, Middle East, South Africa).
\r\nSprachen: English, Deutsch.
\r\nUntertitel: English, Deutsch, Spanish.
\r\nAudio: Dolby Surround 5.1.
\r\nBildformat: 16:9 Wide-Screen.
\r\nDauer: (approx) 112 minutes.
\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.

\r\n(USA 1998) von Nora Ephron (&qout;Schlaflos in Seattle"). Meg Ryan und Tom Hanks knüpfen per E-Mail zarte Bande. Dass sie sich schon kennen, ahnen sie nicht ...','www.youvegotmail.com',0); INSERT INTO products_description VALUES (8,2,'Das Große Krabbeln','Originaltitel: "A Bug\'s Life"

\r\nRegional Code: 2 (Japan, Europe, Middle East, South Africa).
\r\nSprachen: English, Deutsch.
\r\nUntertitel: English, Deutsch, Spanish.
\r\nAudio: Dolby Surround 5.1.
\r\nBildformat: 16:9 Wide-Screen.
\r\nDauer: (approx) 96 minuten.
\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.

\r\n(USA 1998). Ameise Flik zettelt einen Aufstand gegen gefräßige Grashüpfer an ... Eine fantastische Computeranimation des \"Toy Story\"-Teams. ','www.abugslife.com',0); INSERT INTO products_description VALUES (9,2,'Alarmstufe: Rot','Originaltitel: "Under Siege"

\r\nRegional Code: 2 (Japan, Europe, Middle East, South Africa).
\r\nSprachen: English, Deutsch.
\r\nUntertitel: English, Deutsch, Spanish.
\r\nAudio: Dolby Surround 5.1.
\r\nBildformat: 16:9 Wide-Screen.
\r\nDauer: (approx) 96 minuten.
\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.

\r\nActionthriller. Smutje Steven Seagal versalzt Schurke Tommy Lee Jones die Suppe

\r\nKatastrophe ahoi: Kurz vor Ausmusterung der \"U.S.S. Missouri\" kapert die High-tech-Bande von Ex-CIA-Agent Strannix (Tommy Lee Jones) das Schlachtschiff. Strannix will die Nuklearraketen des Kreuzers klauen und verscherbeln. Mit Hilfe des irren Ersten Offiziers Krill (lustig: Gary Busey) killen die Gangster den Käpt’n und sperren seine Crew unter Deck. Blöd, dass sie dabei Schiffskoch Rybak (Steven Seagal) vergessen. Der Ex-Elitekämpfer knipst einen Schurken nach dem anderen aus. Eine Verbündete findet er in Stripperin Jordan (Ex-\"Baywatch\"-Biene Erika Eleniak). Die sollte eigentlich aus Käpt’ns Geburtstagstorte hüpfen ... Klar: Seagal ist kein Edelmime. Dafür ist Regisseur Andrew Davis (\"Auf der Flucht\") ein Könner: Er würzt die Action-Orgie mit Ironie und nutzt die imposante Schiffskulisse voll aus. Für Effekte und Ton gab es 1993 Oscar-Nominierungen. ','',0); INSERT INTO products_description VALUES (10,2,'Alarmstufe: Rot 2','Originaltitel: "Under Siege 2: Dark Territory"

\r\nRegional Code: 2 (Japan, Europe, Middle East, South Africa).
\r\nSprachen: English, Deutsch.
\r\nUntertitel: English, Deutsch, Spanish.
\r\nAudio: Dolby Surround 5.1.
\r\nBildformat: 16:9 Wide-Screen.
\r\nDauer: (approx) 96 minuten.
\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.

\r\n(USA ’95). Von einem gekaperten Zug aus übernimmt Computerspezi Dane die Kontrolle über einen Kampfsatelliten und erpresst das Pentagon. Aber auch Ex-Offizier Ryback (Steven Seagal) ist im Zug ...\r\n','',0); INSERT INTO products_description VALUES (11,2,'Fire Down Below','Regional Code: 2 (Japan, Europe, Middle East, South Africa).
\r\nSprachen: English, Deutsch.
\r\nUntertitel: English, Deutsch, Spanish.
\r\nAudio: Dolby Surround 5.1.
\r\nBildformat: 16:9 Wide-Screen.
\r\nDauer: (approx) 96 minuten.
\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.

\r\nEin mysteriöser Mordfall führt den Bundesmarschall Jack Taggert in eine Kleinstadt im US-Staat Kentucky. Doch bei seinen Ermittlungen stößt er auf eine Mauer des Schweigens. Angst beherrscht die Stadt, und alle Spuren führen zu dem undurchsichtigen Minen-Tycoon Orin Hanner. Offenbar werden in der friedlichen Berglandschaft gigantische Mengen Giftmülls verschoben, mit unkalkulierbaren Risiken. Um eine Katastrophe zu verhindern, räumt Taggert gnadenlos auf ...','',0); INSERT INTO products_description VALUES (12,2,'Stirb Langsam - Jetzt Erst Recht','Originaltitel: "Die Hard With A Vengeance"

\r\nRegional Code: 2 (Japan, Europe, Middle East, South Africa).
\r\nSprachen: English, Deutsch.
\r\nUntertitel: English, Deutsch, Spanish.
\r\nAudio: Dolby Surround 5.1.
\r\nBildformat: 16:9 Wide-Screen.
\r\nDauer: (approx) 96 minuten.
\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.

\r\nSo explosiv, so spannend, so rasant wie nie zuvor: Bruce Willis als Detectiv John McClane in einem Action-Thriller der Superlative! Das ist heute nicht McClanes Tag. Seine Frau hat ihn verlassen, sein Boß hat ihn vom Dienst suspendiert und irgendein Verrückter hat ihn gerade zum Gegenspieler in einem teuflischen Spiel erkoren - und der Einsatz ist New York selbst. Ein Kaufhaus ist explodiert, doch das ist nur der Auftakt. Der geniale Superverbrecher Simon droht, die ganze Stadt Stück für Stück in die Luft zu sprengen, wenn McClane und sein Partner wider Willen seine explosiven\" Rätsel nicht lösen. Eine mörderische Hetzjagd quer durch New York beginnt - bis McClane merkt, daß der Bombenterror eigentlich nur ein brillantes Ablenkungsmanöver ist...!
\"Perfekt gemacht und stark besetzt. Das Action-Highlight des Jahres!\" (Bild)','',0); INSERT INTO products_description VALUES (13,2,'Zwei stahlharte Profis','Originaltitel: "Lethal Weapon"

\r\nRegional Code: 2 (Japan, Europe, Middle East, South Africa).
\r\nSprachen: English, Deutsch.
\r\nUntertitel: English, Deutsch, Spanish.
\r\nAudio: Dolby Surround 5.1.
\r\nBildformat: 16:9 Wide-Screen.
\r\nDauer: (approx) 96 minuten.
\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.

\r\nSie sind beide Cops in L.A.. Sie haben beide in Vietnam für eine Spezialeinheit gekämpft. Und sie hassen es beide, mit einem Partner arbeiten zu müssen. Aber sie sind Partner: Martin Riggs, der Mann mit dem Todeswunsch, für wen auch immer. Und Roger Murtaugh, der besonnene Polizist. Gemeinsam enttarnen sie einen gigantischen Heroinschmuggel, hinter dem sich eine Gruppe ehemaliger CIA-Söldner verbirgt. Eine Killerbande gegen zwei Profis ...','',0); INSERT INTO products_description VALUES (14,2,'Labyrinth ohne Ausweg','Originaltitel: "Red Corner"

\r\nRegional Code: 2 (Japan, Europe, Middle East, South Africa).
\r\nSprachen: English, Deutsch.
\r\nUntertitel: English, Deutsch, Spanish.
\r\nAudio: Dolby Surround 5.1.
\r\nBildformat: 16:9 Wide-Screen.
\r\nDauer: (approx) 96 minuten.
\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.

\r\nDem Amerikaner Jack Moore wird in China der bestialische Mord an einem Fotomodel angehängt. Brutale Gefängnisschergen versuchen, ihn durch Folter zu einem Geständnis zu zwingen. Vor Gericht fordert die Anklage die Todesstrafe - Moore\'s Schicksal scheint besiegelt. Durch einen Zufall gelingt es ihm, aus der Haft zu fliehen, doch aus der feindseligen chinesischen Hauptstadt gibt es praktisch kein Entkommen ...','',0); INSERT INTO products_description VALUES (15,2,'Frantic','Originaltitel: "Frantic"

\r\nRegional Code: 2 (Japan, Europe, Middle East, South Africa).
\r\nSprachen: English, Deutsch.
\r\nUntertitel: English, Deutsch, Spanish.
\r\nAudio: Dolby Surround 5.1.
\r\nBildformat: 16:9 Wide-Screen.
\r\nDauer: (approx) 96 minuten.
\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.

\r\nEin romantischer Urlaub in Paris, der sich in einen Alptraum verwandelt. Ein Mann auf der verzweifelten Suche nach seiner entführten Frau. Ein düster-bedrohliches Paris, in dem nur ein Mensch Licht in die tödliche Affäre bringen kann.','',0); INSERT INTO products_description VALUES (16,2,'Mut Zur Wahrheit','Originaltitel: "Courage Under Fire"

\r\nRegional Code: 2 (Japan, Europe, Middle East, South Africa).
\r\nSprachen: English, Deutsch.
\r\nUntertitel: English, Deutsch, Spanish.
\r\nAudio: Dolby Surround 5.1.
\r\nBildformat: 16:9 Wide-Screen.
\r\nDauer: (approx) 96 minuten.
\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.

\r\nLieutenant Colonel Nathaniel Serling (Denzel Washington) lässt während einer Schlacht im Golfkrieg versehentlich auf einen US-Panzer schießen, dessen Mannschaft dabei ums Leben kommt. Ein Jahr nach diesem Vorfall wird Serling, der mittlerweile nach Washington D.C. versetzt wurde, die Aufgabe übertragen, sich um einen Kandidaten zu kümmern, der während des Krieges starb und dem der höchste militärische Orden zuteil werden soll. Allerdings sind sowohl der Fall und als auch der betreffende Soldat ein politisch heißes Eisen -- Captain Karen Walden (Meg Ryan) ist Amerikas erster weiblicher Soldat, der im Kampf getötet wurde.

\r\nSerling findet schnell heraus, dass es im Fall des im felsigen Gebiet von Kuwait abgestürzten Rettungshubschraubers Diskrepanzen gibt. In Flashbacks werden von unterschiedlichen Personen verschiedene Versionen von Waldens Taktik, die Soldaten zu retten und den Absturz zu überleben, dargestellt (à la Kurosawas Rashomon). Genau wie in Glory erweist sich Regisseur Edward Zwicks Zusammenstellung von bekannten und unbekannten Schauspielern als die richtige Mischung. Waldens Crew ist besonders überzeugend. Matt Damon als der Sanitäter kommt gut als der leichtfertige Typ rüber, als er Washington seine Geschichte erzählt. Im Kampf ist er ein mit Fehlern behafteter, humorvoller Soldat.

\r\nDie erstaunlichste Arbeit in Mut zur Wahrheit leistet Lou Diamond Phillips (als der Schütze der Gruppe), dessen Karriere sich auf dem Weg in die direkt für den Videomarkt produzierten Filme befand. Und dann ist da noch Ryan. Sie hat sich in dramatischen Filmen in der Vergangenheit gut behauptet (Eine fast perfekte Liebe, Ein blutiges Erbe), es aber nie geschafft, ihrem Image zu entfliehen, das sie in die Ecke der romantischen Komödie steckte. Mit gefärbtem Haar, einem leichten Akzent und der von ihr geforderten Darstellungskunst hat sie endlich einen langlebigen dramatischen Film. Obwohl sie nur halb so oft wie Washington im Film zu sehen ist, macht ihre mutige und beeindruckend nachhaltige Darstellung Mut zur Wahrheit zu einem speziellen Film bis hin zu dessen seltsamer, aber lohnender letzter Szene.','',0); INSERT INTO products_description VALUES (17,2,'Speed','Originaltitel: "Speed"

\r\nRegional Code: 2 (Japan, Europe, Middle East, South Africa).
\r\nSprachen: English, Deutsch.
\r\nUntertitel: English, Deutsch, Spanish.
\r\nAudio: Dolby Surround 5.1.
\r\nBildformat: 16:9 Wide-Screen.
\r\nDauer: (approx) 96 minuten.
\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.

\r\nEr ist ein Cop aus der Anti-Terror-Einheit von Los Angeles. Und so ist der Alarm für Jack Traven nichts Ungewöhnliches: Ein Terrorist will drei Millionen Dollar erpressen, oder die zufälligen Geiseln in einem Aufzug fallen 35 Stockwerke in die Tiefe. Doch Jack schafft das Unmögliche - die Geiseln werden gerettet und der Terrorist stirbt an seiner eigenen Bombe. Scheinbar. Denn schon wenig später steht Jack (Keanu Reeves) dem Bombenexperten Payne erneut gegenüber. Diesmal hat sich der Erpresser eine ganz perfide Mordwaffe ausgedacht: Er plaziert eine Bombe in einem öffentlichen Bus. Der Mechanismus der Sprengladung schaltet sich automatisch ein, sobald der Bus schneller als 50 Meilen in der Stunde fährt und detoniert sofort, sobald die Geschwindigkeit sinkt. Plötzlich wird für eine Handvoll ahnungsloser Durchschnittsbürger der Weg zur Arbeit zum Höllentrip - und nur Jack hat ihr Leben in der Hand. Als der Busfahrer verletzt wird, übernimmt Fahrgast Annie (Sandra Bullock) das Steuer. Doch wohin mit einem Bus, der nicht bremsen kann in der Stadt der Staus? Doch es kommt noch schlimmer: Payne (Dennis Hopper) will jetzt nicht nur seine drei Millionen Dollar. Er will Jack. Um jeden Preis.','',0); INSERT INTO products_description VALUES (18,2,'Speed 2: Cruise Control','Originaltitel: "Speed 2 - Cruise Control"

\r\nRegional Code: 2 (Japan, Europe, Middle East, South Africa).
\r\nSprachen: English, Deutsch.
\r\nUntertitel: English, Deutsch, Spanish.
\r\nAudio: Dolby Surround 5.1.
\r\nBildformat: 16:9 Wide-Screen.
\r\nDauer: (approx) 96 minuten.
\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.

\r\nHalten Sie ihre Schwimmwesten bereit, denn die actiongeladene Fortsetzung von Speed begibt sich auf Hochseekurs. Erleben Sie Sandra Bullock erneut in ihrer Star-Rolle als Annie Porter. Die Karibik-Kreuzfahrt mit ihrem Freund Alex entwickelt sich unaufhaltsam zur rasenden Todesfahrt, als ein wahnsinniger Computer-Spezialist den Luxusliner in seine Gewalt bringt und auf einen mörderischen Zerstörungskurs programmiert. Eine hochexplosive Reise, bei der kein geringerer als Action-Spezialist Jan De Bont das Ruder in die Hand nimmt. Speed 2: Cruise Controll läßt ihre Adrenalin-Wellen in rasender Geschwindigkeit ganz nach oben schnellen.','',0); INSERT INTO products_description VALUES (19,2,'Verrückt nach Mary','Originaltitel: "There\'s Something About Mary"

\r\nRegional Code: 2 (Japan, Europe, Middle East, South Africa).
\r\nSprachen: English, Deutsch.
\r\nUntertitel: English, Deutsch, Spanish.
\r\nAudio: Dolby Surround 5.1.
\r\nBildformat: 16:9 Wide-Screen.
\r\nDauer: (approx) 96 minuten.
\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.

\r\n13 Jahre nachdem Teds Rendezvous mit seiner angebeteten Mary in einem peinlichen Fiasko endete, träumt er immer noch von ihr und engagiert den windigen Privatdetektiv Healy um sie aufzuspüren. Der findet Mary in Florida und verliebt sich auf den ersten Blick in die atemberaubende Traumfrau. Um Ted als Nebenbuhler auszuschalten, tischt er ihm dicke Lügen über Mary auf. Ted läßt sich jedoch nicht abschrecken, eilt nach Miami und versucht nun alles, um Healy die Balztour zu vermasseln. Doch nicht nur Healy ist verrückt nach Mary und Ted bekommt es mit einer ganzen Legion liebeskranker Konkurrenten zu tun ...','',0); INSERT INTO products_description VALUES (20,2,'Menschenkind','Originaltitel: "Beloved"

\r\nRegional Code: 2 (Japan, Europe, Middle East, South Africa).
\r\nSprachen: English, Deutsch.
\r\nUntertitel: English, Deutsch, Spanish.
\r\nAudio: Dolby Surround 5.1.
\r\nBildformat: 16:9 Wide-Screen.
\r\nDauer: (approx) 96 minuten.
\r\nAußerdem: Interaktive Menus, Kapitelauswahl, Untertitel.

\r\nDieser vielschichtige Film ist eine Arbeit, die Regisseur Jonathan Demme und dem amerikanischen Talkshow-Star Oprah Winfrey sehr am Herzen lag. Der Film deckt im Verlauf seiner dreistündigen Spielzeit viele Bereiche ab. Menschenkind ist teils Sklavenepos, teils Mutter-Tochter-Drama und teils Geistergeschichte.

\r\nDer Film fordert vom Publikum höchste Aufmerksamkeit, angefangen bei seiner dramatischen und etwas verwirrenden Eingangssequenz, in der die Bewohner eines Hauses von einem niederträchtigen übersinnlichen Angriff heimgesucht werden. Aber Demme und seine talentierte Besetzung bereiten denen, die dabei bleiben ein unvergessliches Erlebnis. Der Film folgt den Spuren von Sethe (in ihren mittleren Jahren von Oprah Winfrey dargestellt), einer ehemaligen Sklavin, die sich scheinbar ein friedliches und produktives Leben in Ohio aufgebaut hat. Aber durch den erschreckenden und sparsamen Einsatz von Rückblenden deckt Demme, genau wie das literarische Meisterwerk von Toni Morrison, auf dem der Film basiert, langsam die Schrecken von Sethes früherem Leben auf und das schreckliche Ereignis, dass dazu führte, dass Sethes Haus von Geistern heimgesucht wird.

\r\nWährend die Gräuel der Sklaverei und das blutige Ereignis in Sethes Familie unleugbar tief beeindrucken, ist die Qualität des Film auch in kleineren, genauso befriedigenden Details sichtbar. Die geistlich beeinflusste Musik von Rachel Portman ist gleichzeitig befreiend und bedrückend, und der Einblick in die afro-amerikanische Gemeinschaft nach der Sklaverei -- am Beispiel eines Familienausflugs zu einem Jahrmarkt, oder dem gospelsingenden Nähkränzchen -- machen diesen Film zu einem speziellen Vergnügen sowohl für den Geist als auch für das Herz. Die Schauspieler, besonders Kimberley Elise als Sethes kämpfende Tochter und Thandie Newton als der mysteriöse Titelcharakter, sind sehr rührend. Achten Sie auch auf Danny Glover (Lethal Weapon) als Paul D.','',0); INSERT INTO products_description VALUES (21,2,'SWAT 3: Elite Edition','KEINE KOMPROMISSE!
Kämpfen Sie Seite an Seite mit Ihren LAPD SWAT-Kameraden gegen das organisierte Verbrechen!

\r\nEine der realistischsten 3D-Taktiksimulationen der letzten Zeit jetzt mit Multiplayer-Modus, 5 neuen Missionen und jede Menge nützliche Tools!

\r\nLos Angeles, 2005. In wenigen Tagen steht die Unterzeichnung des Abkommens der Vereinten Nationen zur Atom-Ächtung durch Vertreter aller Nationen der Welt an. Radikale terroristische Vereinigungen machen sich in der ganzen Stadt breit. Verantwortlich für die Sicherheit der Delegierten zeichnet sich eine Eliteeinheit der LAPD: das SWAT-Team. Das Schicksal der Stadt liegt in Ihren Händen.

\r\nNeue Features:\r\n\r\nDie dritte Folge der Bestseller-Reihe im Bereich der 3D-Echtzeit-Simulationen präsentiert sich mit einer neuen Spielengine mit extrem ausgeprägtem Realismusgrad. Der Spieler übernimmt das Kommando über eine der besten Polizei-Spezialeinheiten oder einer der übelsten Terroristen-Gangs der Welt. Er durchläuft - als \"Guter\" oder \"Böser\" - eine der härtesten und elitärsten Kampfausbildungen, in der er lernt, mit jeder Art von Krisensituationen umzugehen. Bei diesem Action-Abenteuer geht es um das Leben prominenter Vertreter der Vereinten Nationen und bei 16 Missionen an Originalschauplätzen in LA gibt die \"lebensechte\" KI den Protagonisten jeder Seite so einige harte Nüsse zu knacken.','www.swat3.com',0); INSERT INTO products_description VALUES (22,2,'Unreal Tournament','2341: Die Gewalt ist eine Lebensweise, die sich ihren Weg durch die dunklen Risse der Gesellschaft bahnt. Sie bedroht die Macht und den Einfluss der regierenden Firmen, die schnellstens ein Mittel finden müssen, die tobenden Massen zu besänftigen - ein profitables Mittel ... Gladiatorenkämpfe sind die Lösung. Sie sollen den Durst der Menschen nach Blut stillen und sind die perfekte Gelegenheit, die Aufständischen, Kriminellen und Aliens zu beseitigen, die die Firmenelite bedrohen.

\r\nDas Turnier war geboren - ein Kampf auf Leben und Tod. Galaxisweit live und in Farbe! Kämpfen Sie für Freiheit, Ruhm und Ehre. Sie müssen stark, schnell und geschickt sein ... oder Sie bleiben auf der Strecke.

\r\nKämpfen Sie allein oder kommandieren Sie ein Team gegen Armeen unbarmherziger Krieger, die alle nur ein Ziel vor Augen haben: Die Arenen lebend zu verlassen und sich dem Grand Champion zu stellen ... um ihn dann zu bezwingen!

\r\nFeatures:\r\n\r\nDer Nachfolger des Actionhits \"Unreal\" verspricht ein leichtes, intuitives Interface, um auch Einsteigern schnellen Zugang zu den Duellen gegen die Bots zu ermöglichen. Mit diesen KI-Kriegern kann man auch Teams bilden und im umfangreichen Multiplayermodus ohne Onlinekosten in den Kampf ziehen. 35 komplett neue Arenen und das erweiterte Waffenangebot bilden dazu den würdigen Rahmen.','www.unrealtournament.net',0); INSERT INTO products_description VALUES (23,2,'The Wheel Of Time','\"Wheel Of Time\"(Das Rad der Zeit) basiert auf den Fantasy-Romanen von Kultautor Robert Jordan und stellt einen einzigartigen Mix aus Strategie-, Action- und Rollenspielelementen dar. Obwohl die Welt von \"Wheel of Time\" eng an die literarische Vorlage der Romane angelehnt ist, erzählt das Spiel keine lineare Geschichte. Die Story entwickelt sich abhängig von den Aktionen der Spieler, die jeweils die Rollen der Hauptcharaktere aus dem Roman übernehmen. Jede Figur hat den Oberbefehl über eine große Gefolgschaft, militärische Einheiten und Ländereien. Die Spieler können ihre eigenen Festungen konstruieren, individuell ausbauen, von dort aus das umliegende Land erforschen, magische Gegenstände sammeln oder die gegnerischen Zitadellen erstürmen. Selbstverständlich kann man sich auch über LAN oder Internet gegenseitig Truppen auf den Hals hetzen und die Festungen seiner Mitspieler in Schutt und Asche legen. Dreh- und Anlegepunkt von \"Wheel of Time\" ist der Kampf um die finstere Macht \"The Dark One\", die vor langer Zeit die Menschheit beinahe ins Verderben stürzte und nur mit Hilfe gewaltiger magischer Energie verbannt werden konnte. \"The Amyrlin Seat\" und \"The Children of the Night\" kämpfen nur gegen \"The Forsaken\" und \"The Hound\" um den Besitz des Schlüssels zu \"Shayol Ghul\" - dem magischen Siegel, mit dessen Hilfe \"The Dark One\" seinerzeit gebannt werden konnte.

\r\nFeatures: \r\n\r\nIm Mittelpunkt steht der Kampf gegen eine finstere Macht namens The Dark One. Deren Schergen müssen mit dem Einsatz von über 100 Artefakten und Zaubereien wie Blitzschlag oder Teleportation aus dem Weg geräumt werden. Die opulente 3D-Grafik verbindet Strategie- und Rollenspielelemente. \r\n\r\nVoraussetzungen\r\nmind. P200, 32MB RAM, 4x CD-Rom, Win95/98, DirectX 5.0 komp.Grafikkarte und Soundkarte. ','www.wheeloftime.com',0); INSERT INTO products_description VALUES (24,2,'Disciples: Sacred Land','Rundenbasierende Fantasy/RTS-Strategie mit gutem Design (vor allem die Levels, 4 versch. Rassen, tolle Einheiten), fantastischer Atmosphäre und exzellentem Soundtrack. Grafisch leider auf das Niveau von 1990.','www.strategyfirst.com/disciples/welcome.html',0); INSERT INTO products_description VALUES (25,2,'Microsoft Internet Tastatur PS/2','Microsoft Internet Keyboard,Windows-Tastatur mit 10 zusätzl. Tasten,2 selbst programmierbar, abnehmbareHandgelenkauflage. Treiber im Lieferumfang.

\r\nEin-Klick-Zugriff auf das Internet und vieles mehr! Das Internet Keyboard verfügt über 10 zusätzliche Abkürzungstasten auf einer benutzerfreundlichen Standardtastatur, die darüber hinaus eine abnehmbare Handballenauflage aufweist. Über die Abkürzungstasten können Sie durch das Internet surfen oder direkt von der Tastatur aus auf E-Mails zugreifen. Die IntelliType Pro-Software ermöglicht außerdem das individuelle Belegen der Tasten.','',0); INSERT INTO products_description VALUES (26,2,'Microsof IntelliMouse Explorer','Die IntelliMouse Explorer überzeugt durch ihr modernes Design mit silberfarbenem Gehäuse, sowie rot schimmernder Unter- und Rückseite. Die neuartige IntelliEye-Technologie sorgt für eine noch nie dagewesene Präzision, da statt der beweglichen Teile (zum Abtasten der Bewegungsänderungen an der Unterseite der Maus) ein optischer Sensor die Bewegungen der Maus erfaßt. Das Herzstück der Microsoft IntelliEye-Technologie ist ein kleiner Chip, der einen optischen Sensor und einen digitalen Signalprozessor (DSP) enthält.

\r\nDa auf bewegliche Teile, die Staub, Schmutz und Fett aufnehmen können, verzichtet wurde, muß die IntelliMouse Explorer nicht mehr gereinigt werden. Darüber hinaus arbeitet die IntelliMouse Explorer auf nahezu jeder Arbeitsoberfläche, so daß kein Mauspad mehr erforderlich ist. Mit dem Rad und zwei neuen zusätzlichen Maustasten ermöglicht sie effizientes und komfortables Arbeiten am PC.

\r\nEigenschaften:\r\n\r\nBEMERKUNG:
Keine Reinigung bewegter Teile mehr notwendig, da statt der Mauskugel ein Fotoempfänger benutzt wird.','',0); INSERT INTO products_description VALUES (27,2,'Hewlett-Packard LaserJet 1100Xi','HP LaserJet für mehr Produktivität und Flexibilität am Arbeitsplatz

\r\nDer HP LaserJet 1100Xi Drucker verbindet exzellente Laserdruckqualität mit hoher Geschwindigkeit für mehr Effizienz.

\r\nZielkunden\r\n\r\nEigenschaften\r\n\r\n','www.hp.com',0); INSERT INTO products_description VALUES (1,3,'Matrox G200 MMS','Reinforcing its position as a multi-monitor trailblazer, Matrox Graphics Inc. has once again developed the most flexible and highly advanced solution in the industry. Introducing the new Matrox G200 Multi-Monitor Series; the first graphics card ever to support up to four DVI digital flat panel displays on a single 8" PCI board.

With continuing demand for digital flat panels in the financial workplace, the Matrox G200 MMS is the ultimate in flexible solutions. The Matrox G200 MMS also supports the new digital video interface (DVI) created by the Digital Display Working Group (DDWG) designed to ease the adoption of digital flat panels. Other configurations include composite video capture ability and onboard TV tuner, making the Matrox G200 MMS the complete solution for business needs.

Based on the award-winning MGA-G200 graphics chip, the Matrox G200 Multi-Monitor Series provides superior 2D/3D graphics acceleration to meet the demanding needs of business applications such as real-time stock quotes (Versus), live video feeds (Reuters & Bloombergs), multiple windows applications, word processing, spreadsheets and CAD.','www.matrox.com/mga/products/g200_mms/home.cfm',0); INSERT INTO products_description VALUES (2,3,'Matrox G400 32MB','Dramatically Different High Performance Graphics

Introducing the Millennium G400 Series - a dramatically different, high performance graphics experience. Armed with the industry\'s fastest graphics chip, the Millennium G400 Series takes explosive acceleration two steps further by adding unprecedented image quality, along with the most versatile display options for all your 3D, 2D and DVD applications. As the most powerful and innovative tools in your PC\'s arsenal, the Millennium G400 Series will not only change the way you see graphics, but will revolutionize the way you use your computer.

Key features:','www.matrox.com/mga/products/mill_g400/home.htm',0); INSERT INTO products_description VALUES (3,3,'Microsoft IntelliMouse Pro','Every element of IntelliMouse Pro - from its unique arched shape to the texture of the rubber grip around its base - is the product of extensive customer and ergonomic research. Microsoft\'s popular wheel control, which now allows zooming and universal scrolling functions, gives IntelliMouse Pro outstanding comfort and efficiency.','www.microsoft.com/hardware/mouse/intellimouse.asp',0); INSERT INTO products_description VALUES (4,3,'The Replacement Killers','Regional Code: 2 (Japan, Europe, Middle East, South Africa).
Languages: English, Deutsch.
Subtitles: English, Deutsch, Spanish.
Audio: Dolby Surround 5.1.
Picture Format: 16:9 Wide-Screen.
Length: (approx) 80 minutes.
Other: Interactive Menus, Chapter Selection, Subtitles (more languages).','www.replacement-killers.com',0); INSERT INTO products_description VALUES (5,3,'Blade Runner - Director\'s Cut','Regional Code: 2 (Japan, Europe, Middle East, South Africa).
Languages: English, Deutsch.
Subtitles: English, Deutsch, Spanish.
Audio: Dolby Surround 5.1.
Picture Format: 16:9 Wide-Screen.
Length: (approx) 112 minutes.
Other: Interactive Menus, Chapter Selection, Subtitles (more languages).','www.bladerunner.com',0); INSERT INTO products_description VALUES (6,3,'The Matrix','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r
\nLanguages: English, Deutsch.\r
\nSubtitles: English, Deutsch.\r
\nAudio: Dolby Surround.\r
\nPicture Format: 16:9 Wide-Screen.\r
\nLength: (approx) 131 minutes.\r
\nOther: Interactive Menus, Chapter Selection, Making Of.','www.thematrix.com',0); INSERT INTO products_description VALUES (7,3,'You\'ve Got Mail','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r
\nLanguages: English, Deutsch, Spanish.\r
\nSubtitles: English, Deutsch, Spanish, French, Nordic, Polish.\r
\nAudio: Dolby Digital 5.1.\r
\nPicture Format: 16:9 Wide-Screen.\r
\nLength: (approx) 115 minutes.\r
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','www.youvegotmail.com',0); INSERT INTO products_description VALUES (8,3,'A Bug\'s Life','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r
\nLanguages: English, Deutsch.\r
\nSubtitles: English, Deutsch, Spanish.\r
\nAudio: Dolby Digital 5.1 / Dobly Surround Stereo.\r
\nPicture Format: 16:9 Wide-Screen.\r
\nLength: (approx) 91 minutes.\r
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','www.abugslife.com',0); INSERT INTO products_description VALUES (9,3,'Under Siege','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r
\nLanguages: English, Deutsch.\r
\nSubtitles: English, Deutsch, Spanish.\r
\nAudio: Dolby Surround 5.1.\r
\nPicture Format: 16:9 Wide-Screen.\r
\nLength: (approx) 98 minutes.\r
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); INSERT INTO products_description VALUES (10,3,'Under Siege 2 - Dark Territory','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r
\nLanguages: English, Deutsch.\r
\nSubtitles: English, Deutsch, Spanish.\r
\nAudio: Dolby Surround 5.1.\r
\nPicture Format: 16:9 Wide-Screen.\r
\nLength: (approx) 98 minutes.\r
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); INSERT INTO products_description VALUES (11,3,'Fire Down Below','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r
\nLanguages: English, Deutsch.\r
\nSubtitles: English, Deutsch, Spanish.\r
\nAudio: Dolby Surround 5.1.\r
\nPicture Format: 16:9 Wide-Screen.\r
\nLength: (approx) 100 minutes.\r
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); INSERT INTO products_description VALUES (12,3,'Die Hard With A Vengeance','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r
\nLanguages: English, Deutsch.\r
\nSubtitles: English, Deutsch, Spanish.\r
\nAudio: Dolby Surround 5.1.\r
\nPicture Format: 16:9 Wide-Screen.\r
\nLength: (approx) 122 minutes.\r
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); INSERT INTO products_description VALUES (13,3,'Lethal Weapon','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r
\nLanguages: English, Deutsch.\r
\nSubtitles: English, Deutsch, Spanish.\r
\nAudio: Dolby Surround 5.1.\r
\nPicture Format: 16:9 Wide-Screen.\r
\nLength: (approx) 100 minutes.\r
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); INSERT INTO products_description VALUES (14,3,'Red Corner','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r
\nLanguages: English, Deutsch.\r
\nSubtitles: English, Deutsch, Spanish.\r
\nAudio: Dolby Surround 5.1.\r
\nPicture Format: 16:9 Wide-Screen.\r
\nLength: (approx) 117 minutes.\r
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); INSERT INTO products_description VALUES (15,3,'Frantic','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r
\nLanguages: English, Deutsch.\r
\nSubtitles: English, Deutsch, Spanish.\r
\nAudio: Dolby Surround 5.1.\r
\nPicture Format: 16:9 Wide-Screen.\r
\nLength: (approx) 115 minutes.\r
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); INSERT INTO products_description VALUES (16,3,'Courage Under Fire','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r
\nLanguages: English, Deutsch.\r
\nSubtitles: English, Deutsch, Spanish.\r
\nAudio: Dolby Surround 5.1.\r
\nPicture Format: 16:9 Wide-Screen.\r
\nLength: (approx) 112 minutes.\r
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); INSERT INTO products_description VALUES (17,3,'Speed','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r
\nLanguages: English, Deutsch.\r
\nSubtitles: English, Deutsch, Spanish.\r
\nAudio: Dolby Surround 5.1.\r
\nPicture Format: 16:9 Wide-Screen.\r
\nLength: (approx) 112 minutes.\r
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); INSERT INTO products_description VALUES (18,3,'Speed 2: Cruise Control','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r
\nLanguages: English, Deutsch.\r
\nSubtitles: English, Deutsch, Spanish.\r
\nAudio: Dolby Surround 5.1.\r
\nPicture Format: 16:9 Wide-Screen.\r
\nLength: (approx) 120 minutes.\r
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); INSERT INTO products_description VALUES (19,3,'There\'s Something About Mary','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r
\nLanguages: English, Deutsch.\r
\nSubtitles: English, Deutsch, Spanish.\r
\nAudio: Dolby Surround 5.1.\r
\nPicture Format: 16:9 Wide-Screen.\r
\nLength: (approx) 114 minutes.\r
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); INSERT INTO products_description VALUES (20,3,'Beloved','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\r
\nLanguages: English, Deutsch.\r
\nSubtitles: English, Deutsch, Spanish.\r
\nAudio: Dolby Surround 5.1.\r
\nPicture Format: 16:9 Wide-Screen.\r
\nLength: (approx) 164 minutes.\r
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',0); INSERT INTO products_description VALUES (21,3,'SWAT 3: Close Quarters Battle','Windows 95/98

211 in progress with shots fired. Officer down. Armed suspects with hostages. Respond Code 3! Los Angles, 2005, In the next seven days, representatives from every nation around the world will converge on Las Angles to witness the signing of the United Nations Nuclear Abolishment Treaty. The protection of these dignitaries falls on the shoulders of one organization, LAPD SWAT. As part of this elite tactical organization, you and your team have the weapons and all the training necessary to protect, to serve, and \"When needed\" to use deadly force to keep the peace. It takes more than weapons to make it through each mission. Your arsenal includes C2 charges, flashbangs, tactical grenades. opti-Wand mini-video cameras, and other devices critical to meeting your objectives and keeping your men free of injury. Uncompromised Duty, Honor and Valor!','www.swat3.com',0); INSERT INTO products_description VALUES (22,3,'Unreal Tournament','From the creators of the best-selling Unreal, comes Unreal Tournament. A new kind of single player experience. A ruthless multiplayer revolution.

This stand-alone game showcases completely new team-based gameplay, groundbreaking multi-faceted single player action or dynamic multi-player mayhem. It\'s a fight to the finish for the title of Unreal Grand Master in the gladiatorial arena. A single player experience like no other! Guide your team of \'bots\' (virtual teamates) against the hardest criminals in the galaxy for the ultimate title - the Unreal Grand Master.','www.unrealtournament.net',0); INSERT INTO products_description VALUES (23,3,'The Wheel Of Time','The world in which The Wheel of Time takes place is lifted directly out of Jordan\'s pages; it\'s huge and consists of many different environments. How you navigate the world will depend largely on which game - single player or multipayer - you\'re playing. The single player experience, with a few exceptions, will see Elayna traversing the world mainly by foot (with a couple notable exceptions). In the multiplayer experience, your character will have more access to travel via Ter\'angreal, Portal Stones, and the Ways. However you move around, though, you\'ll quickly discover that means of locomotion can easily become the least of the your worries...

During your travels, you quickly discover that four locations are crucial to your success in the game. Not surprisingly, these locations are the homes of The Wheel of Time\'s main characters. Some of these places are ripped directly from the pages of Jordan\'s books, made flesh with Legend\'s unparalleled pixel-pushing ways. Other places are specific to the game, conceived and executed with the intent of expanding this game world even further. Either way, they provide a backdrop for some of the most intense first person action and strategy you\'ll have this year.','www.wheeloftime.com',0); INSERT INTO products_description VALUES (24,3,'Disciples: Sacred Lands','A new age is dawning...

Enter the realm of the Sacred Lands, where the dawn of a New Age has set in motion the most momentous of wars. As the prophecies long foretold, four races now clash with swords and sorcery in a desperate bid to control the destiny of their gods. Take on the quest as a champion of the Empire, the Mountain Clans, the Legions of the Damned, or the Undead Hordes and test your faith in battles of brute force, spellbinding magic and acts of guile. Slay demons, vanquish giants and combat merciless forces of the dead and undead. But to ensure the salvation of your god, the hero within must evolve.

The day of reckoning has come... and only the chosen will survive.','',0); INSERT INTO products_description VALUES (25,3,'Microsoft Internet Keyboard PS/2','The Internet Keyboard has 10 Hot Keys on a comfortable standard keyboard design that also includes a detachable palm rest. The Hot Keys allow you to browse the web, or check e-mail directly from your keyboard. The IntelliType Pro software also allows you to customize your hot keys - make the Internet Keyboard work the way you want it to!','',0); INSERT INTO products_description VALUES (26,3,'Microsoft IntelliMouse Explorer','Microsoft introduces its most advanced mouse, the IntelliMouse Explorer! IntelliMouse Explorer features a sleek design, an industrial-silver finish, a glowing red underside and taillight, creating a style and look unlike any other mouse. IntelliMouse Explorer combines the accuracy and reliability of Microsoft IntelliEye optical tracking technology, the convenience of two new customizable function buttons, the efficiency of the scrolling wheel and the comfort of expert ergonomic design. All these great features make this the best mouse for the PC!','www.microsoft.com/hardware/mouse/explorer.asp',0); INSERT INTO products_description VALUES (27,3,'Hewlett Packard LaserJet 1100Xi','HP has always set the pace in laser printing technology. The new generation HP LaserJet 1100 series sets another impressive pace, delivering a stunning 8 pages per minute print speed. The 600 dpi print resolution with HP\'s Resolution Enhancement technology (REt) makes every document more professional.

Enhanced print speed and laser quality results are just the beginning. With 2MB standard memory, HP LaserJet 1100xi users will be able to print increasingly complex pages. Memory can be increased to 18MB to tackle even more complex documents with ease. The HP LaserJet 1100xi supports key operating systems including Windows 3.1, 3.11, 95, 98, NT 4.0, OS/2 and DOS. Network compatibility available via the optional HP JetDirect External Print Servers.

HP LaserJet 1100xi also features The Document Builder for the Web Era from Trellix Corp. (featuring software to create Web documents).','www.pandi.hp.com/pandi-db/prodinfo.main?product=laserjet1100',0); -- -- 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) ) TYPE=MyISAM; -- -- 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) ) TYPE=MyISAM; -- -- 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 (4,1,'Memory'); 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 (4,2,'Speicher'); INSERT INTO products_options VALUES (1,3,'Color'); INSERT INTO products_options VALUES (2,3,'Talla'); INSERT INTO products_options VALUES (3,3,'Modelo'); INSERT INTO products_options VALUES (4,3,'Memoria'); INSERT INTO products_options VALUES (5,3,'Version'); INSERT INTO products_options VALUES (5,2,'Version'); INSERT INTO products_options VALUES (5,1,'Version'); -- -- 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) ) TYPE=MyISAM; -- -- Dumping data for table 'products_options_values' -- INSERT INTO products_options_values VALUES (1,1,'4 mb'); INSERT INTO products_options_values VALUES (2,1,'8 mb'); INSERT INTO products_options_values VALUES (3,1,'16 mb'); INSERT INTO products_options_values VALUES (4,1,'32 mb'); INSERT INTO products_options_values VALUES (5,1,'Value'); INSERT INTO products_options_values VALUES (6,1,'Premium'); INSERT INTO products_options_values VALUES (7,1,'Deluxe'); INSERT INTO products_options_values VALUES (8,1,'PS/2'); INSERT INTO products_options_values VALUES (9,1,'USB'); INSERT INTO products_options_values VALUES (1,2,'4 MB'); INSERT INTO products_options_values VALUES (2,2,'8 MB'); INSERT INTO products_options_values VALUES (3,2,'16 MB'); INSERT INTO products_options_values VALUES (4,2,'32 MB'); INSERT INTO products_options_values VALUES (5,2,'Value Ausgabe'); INSERT INTO products_options_values VALUES (6,2,'Premium Ausgabe'); INSERT INTO products_options_values VALUES (7,2,'Deluxe Ausgabe'); INSERT INTO products_options_values VALUES (8,2,'PS/2 Anschluss'); INSERT INTO products_options_values VALUES (9,2,'USB Anschluss'); INSERT INTO products_options_values VALUES (1,3,'4 mb'); INSERT INTO products_options_values VALUES (2,3,'8 mb'); INSERT INTO products_options_values VALUES (3,3,'16 mb'); INSERT INTO products_options_values VALUES (4,3,'32 mb'); INSERT INTO products_options_values VALUES (5,3,'Value'); INSERT INTO products_options_values VALUES (6,3,'Premium'); INSERT INTO products_options_values VALUES (7,3,'Deluxe'); INSERT INTO products_options_values VALUES (8,3,'PS/2'); INSERT INTO products_options_values VALUES (9,3,'USB'); INSERT INTO products_options_values VALUES (10,1,'Download: Windows - English'); INSERT INTO products_options_values VALUES (10,2,'Download: Windows - Englisch'); INSERT INTO products_options_values VALUES (10,3,'Download: Windows - Inglese'); INSERT INTO products_options_values VALUES (13,1,'Box: Windows - English'); INSERT INTO products_options_values VALUES (13,2,'Box: Windows - Englisch'); INSERT INTO products_options_values VALUES (13,3,'Box: Windows - Inglese'); -- -- 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) ) TYPE=MyISAM; -- -- Dumping data for table 'products_options_values_to_products_options' -- INSERT INTO products_options_values_to_products_options VALUES (1,4,1); INSERT INTO products_options_values_to_products_options VALUES (2,4,2); INSERT INTO products_options_values_to_products_options VALUES (3,4,3); INSERT INTO products_options_values_to_products_options VALUES (4,4,4); INSERT INTO products_options_values_to_products_options VALUES (5,3,5); INSERT INTO products_options_values_to_products_options VALUES (6,3,6); INSERT INTO products_options_values_to_products_options VALUES (7,3,7); INSERT INTO products_options_values_to_products_options VALUES (8,3,8); INSERT INTO products_options_values_to_products_options VALUES (9,3,9); INSERT INTO products_options_values_to_products_options VALUES (10,5,10); INSERT INTO products_options_values_to_products_options VALUES (13,5,13); -- -- 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) ) TYPE=MyISAM; -- -- Dumping data for table 'products_to_categories' -- INSERT INTO products_to_categories VALUES (1,4); INSERT INTO products_to_categories VALUES (2,4); INSERT INTO products_to_categories VALUES (3,9); INSERT INTO products_to_categories VALUES (4,10); INSERT INTO products_to_categories VALUES (5,11); INSERT INTO products_to_categories VALUES (6,10); INSERT INTO products_to_categories VALUES (7,12); INSERT INTO products_to_categories VALUES (8,13); INSERT INTO products_to_categories VALUES (9,10); INSERT INTO products_to_categories VALUES (10,10); INSERT INTO products_to_categories VALUES (11,10); INSERT INTO products_to_categories VALUES (12,10); INSERT INTO products_to_categories VALUES (13,10); INSERT INTO products_to_categories VALUES (14,15); INSERT INTO products_to_categories VALUES (15,14); INSERT INTO products_to_categories VALUES (16,15); INSERT INTO products_to_categories VALUES (17,10); INSERT INTO products_to_categories VALUES (18,10); INSERT INTO products_to_categories VALUES (19,12); INSERT INTO products_to_categories VALUES (20,15); INSERT INTO products_to_categories VALUES (21,18); INSERT INTO products_to_categories VALUES (22,19); INSERT INTO products_to_categories VALUES (23,20); INSERT INTO products_to_categories VALUES (24,20); INSERT INTO products_to_categories VALUES (25,8); INSERT INTO products_to_categories VALUES (26,9); INSERT INTO products_to_categories VALUES (27,5); -- -- 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) ) TYPE=MyISAM; -- -- Dumping data for table 'reviews' -- INSERT INTO reviews VALUES (1,19,1,'John doe',5,'2003-05-01 12:26:45','0000-00-00 00:00:00',0); -- -- 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) ) TYPE=MyISAM; -- -- Dumping data for table 'reviews_description' -- INSERT INTO reviews_description VALUES (1,1,'this has to be one of the funniest movies released for 1999!'); -- -- 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) ) TYPE=MyISAM; -- -- Dumping data for table 'sessions' -- INSERT INTO sessions VALUES ('c12b72d16680c92808ae87e9620c49ee',1051786348,'cart|O:12:\"shoppingcart\":5:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:6:\"cartID\";N;s:12:\"content_type\";b:0;}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:2:{i:0;a:4:{s:4:\"page\";s:11:\"default.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:0:{}s:4:\"post\";a:0:{}}i:1;a:4:{s:4:\"page\";s:11:\"default.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:2:{s:5:\"cPath\";s:1:\"1\";s:6:\"osCsid\";s:32:\"c12b72d16680c92808ae87e9620c49ee\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}'); INSERT INTO sessions VALUES ('b9fba0df0fdb803eccb7845e4a052a4d',1051786624,'language|s:7:\"english\";languages_id|s:1:\"1\";selected_box|s:5:\"tools\";'); -- -- 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) ) TYPE=MyISAM; -- -- Dumping data for table 'specials' -- INSERT INTO specials VALUES (1,3,39.9900,'2003-05-01 12:26:45','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',1); INSERT INTO specials VALUES (2,5,30.0000,'2003-05-01 12:26:45','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',1); INSERT INTO specials VALUES (3,6,30.0000,'2003-05-01 12:26:45','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',1); INSERT INTO specials VALUES (4,16,29.9900,'2003-05-01 12:26:45','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',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) ) TYPE=MyISAM; -- -- Dumping data for table 'tax_class' -- INSERT INTO tax_class VALUES (1,'Taxable Goods','The following types of products are included non-food, services, etc','2003-05-01 12:26:45','2003-05-01 12:26:45'); -- -- 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) ) TYPE=MyISAM; -- -- Dumping data for table 'tax_rates' -- INSERT INTO tax_rates VALUES (1,1,1,1,7.0000,'FL TAX 7.0%','2003-05-01 12:26:45','2003-05-01 12:26:45'); -- -- 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 '' ) TYPE=MyISAM; -- -- Dumping data for table 'whos_online' -- INSERT INTO whos_online VALUES (0,'Guest','c12b72d16680c92808ae87e9620c49ee','194.30.248.30','1051784861','1051784906','/tests/OS_Commerce/default.php?cPath=1&osCsid=c12b72d16680c92808'); -- -- 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) ) TYPE=MyISAM; -- -- 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'); -- -- 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) ) TYPE=MyISAM; -- -- Dumping data for table 'zones_to_geo_zones' -- INSERT INTO zones_to_geo_zones VALUES (1,223,18,1,NULL,'2003-05-01 12:26:45');