-- MySQL Administrator dump 1.4 -- -- ------------------------------------------------------ -- Server version 5.0.27-community-nt /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -- -- Create schema facecart -- CREATE DATABASE IF NOT EXISTS facecart; USE facecart; -- -- Definition of table `address_book` -- DROP TABLE IF EXISTS `address_book`; CREATE TABLE `address_book` ( `address_book_id` int(11) NOT NULL auto_increment, `customers_id` int(11) NOT NULL, `entry_gender` char(1) NOT NULL, `entry_company` varchar(32) default NULL, `entry_firstname` varchar(32) NOT NULL, `entry_lastname` varchar(32) NOT NULL, `entry_street_address` varchar(64) NOT NULL, `entry_suburb` varchar(32) default NULL, `entry_postcode` varchar(10) NOT NULL, `entry_city` varchar(32) NOT NULL, `entry_state` varchar(32) default NULL, `entry_country_id` int(11) NOT NULL, `entry_zone_id` int(11) default NULL, PRIMARY KEY (`address_book_id`), KEY `idx_address_book_customers_id` (`customers_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `address_book` -- /*!40000 ALTER TABLE `address_book` DISABLE KEYS */; INSERT INTO `address_book` (`address_book_id`,`customers_id`,`entry_gender`,`entry_company`,`entry_firstname`,`entry_lastname`,`entry_street_address`,`entry_suburb`,`entry_postcode`,`entry_city`,`entry_state`,`entry_country_id`,`entry_zone_id`) VALUES (1,1,'m','ACME Inc.','John','Doe','1 Way Street','','12345','NeverNever','ari',223,12), (8,9,'m','test','ivan','ivanov','street','sub','1000','Sofia','Sofia',33,183), (19,33,'m','test','Dimitar','Dimitrov','mladost','','1000','Sofia','Sofia',33,183), (25,43,'m','unicoders','Pesho','Peshev','Rakovska','Rakovska','Rakovska','Rakovska','Rakovska',8,NULL), (26,44,'m','unicoders','Pesho2','Pesho2','street','suburb','1000','cty','test',8,NULL), (31,43,'m','Test','Test','Test','Test',NULL,'Test','Test','Test',8,NULL), (32,7,'m','unicoders','Alexander','Petrov','Rakovska157A','','1000','Sofia','Arizona',223,4), (35,7,'m','unicoders','Petia','Dimitrova','Han Krum','','1000','Sofia','Sofia',33,NULL), (36,7,'m','unicoder','Georgy','Zekov','test','melnik','test','test','arizona',223,4), (49,7,'m','test','test','test','testtest','test','test','test','test',8,NULL); INSERT INTO `address_book` (`address_book_id`,`customers_id`,`entry_gender`,`entry_company`,`entry_firstname`,`entry_lastname`,`entry_street_address`,`entry_suburb`,`entry_postcode`,`entry_city`,`entry_state`,`entry_country_id`,`entry_zone_id`) VALUES (50,45,'m','','Shalinder','Mahindru','I - 3 Lajpat Nagar - 2','','1100','Delhi','Delhi',99,NULL), (51,46,'f','','foo','bar','1234 Anywhere st','','V6K3','Vancouver','British Columbia',38,67), (52,47,'m','','Star','Gruhtar','17 Mente str.','','1700','Sofia','Sofia',33,183), (53,48,'m','','Daniel','Cohen','Main Str 123','','100223','Bono','Bern',64,NULL), (54,49,'m','','Purna','Budaya','Soka Sati Restaurant','','80361','Denpasar','Bali',100,NULL), (55,50,'m','','test','cust','testst.','','78749','Austin','Texas',223,57), (56,51,'m','','Seth','Kirby','asdasdf','','77777','Muncie','Indiana',223,24), (57,52,'m','','pete','rose','1234 main','','12345','fargo','Rhode Island',30,NULL), (58,53,'f','dfgdfg','xcxcv','xcvxcv','dfgdfgfdgdfg','dfg','4456456','ssss','North Carolina',223,44), (59,54,'m','','test','test','1234 forever st','','33633','Bansville','Utah',223,58); INSERT INTO `address_book` (`address_book_id`,`customers_id`,`entry_gender`,`entry_company`,`entry_firstname`,`entry_lastname`,`entry_street_address`,`entry_suburb`,`entry_postcode`,`entry_city`,`entry_state`,`entry_country_id`,`entry_zone_id`) VALUES (60,55,'m','None','asd','asd','None ','','1521','sofia','sofia',33,183), (61,56,'f','','test','test','address','','72934','chester','Arkansas',223,5), (62,57,'m','xcxcx','test','test','cxcxc','xcxc','11111','asas','asasas',42,NULL), (63,58,'m','','jan','kowalski','batorego','','23-452','warszawa','poland',170,NULL), (64,59,'m','','test','test','test asdfa asdf','test','11111','test','Alaska',99,NULL); /*!40000 ALTER TABLE `address_book` ENABLE KEYS */; -- -- Definition of table `address_format` -- DROP TABLE IF EXISTS `address_format`; CREATE TABLE `address_format` ( `address_format_id` int(11) NOT NULL auto_increment, `address_format` varchar(128) NOT NULL, `address_summary` varchar(48) NOT NULL, PRIMARY KEY (`address_format_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `address_format` -- /*!40000 ALTER TABLE `address_format` DISABLE KEYS */; INSERT INTO `address_format` (`address_format_id`,`address_format`,`address_summary`) VALUES (1,'$firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country','$city / $country'), (2,'$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country','$city, $state / $country'), (3,'$firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country','$state / $country'), (4,'$firstname $lastname$cr$streets$cr$city ($postcode)$cr$country','$postcode / $country'), (5,'$firstname $lastname$cr$streets$cr$postcode $city$cr$country','$city / $country'); /*!40000 ALTER TABLE `address_format` ENABLE KEYS */; -- -- Definition of table `banners` -- DROP TABLE IF EXISTS `banners`; CREATE TABLE `banners` ( `banners_id` int(11) NOT NULL auto_increment, `banners_title` varchar(64) NOT NULL, `banners_url` varchar(255) NOT NULL, `banners_image` varchar(64) NOT NULL, `banners_group` varchar(10) NOT NULL, `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, `date_status_change` datetime default NULL, `status` int(1) NOT NULL default '1', PRIMARY KEY (`banners_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `banners` -- /*!40000 ALTER TABLE `banners` DISABLE KEYS */; INSERT INTO `banners` (`banners_id`,`banners_title`,`banners_url`,`banners_image`,`banners_group`,`banners_html_text`,`expires_impressions`,`expires_date`,`date_scheduled`,`date_added`,`date_status_change`,`status`) VALUES (1,'osCommerce','http://www.oscommerce.com','banners/oscommerce.gif','468x50','',0,NULL,NULL,'2007-04-05 17:40:11',NULL,1); /*!40000 ALTER TABLE `banners` ENABLE KEYS */; -- -- Definition of table `banners_history` -- DROP TABLE IF EXISTS `banners_history`; CREATE TABLE `banners_history` ( `banners_history_id` int(11) NOT NULL auto_increment, `banners_id` int(11) NOT NULL, `banners_shown` int(5) NOT NULL default '0', `banners_clicked` int(5) NOT NULL default '0', `banners_history_date` datetime NOT NULL, PRIMARY KEY (`banners_history_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `banners_history` -- /*!40000 ALTER TABLE `banners_history` DISABLE KEYS */; INSERT INTO `banners_history` (`banners_history_id`,`banners_id`,`banners_shown`,`banners_clicked`,`banners_history_date`) VALUES (1,1,1,0,'2007-04-05 17:40:45'); /*!40000 ALTER TABLE `banners_history` ENABLE KEYS */; -- -- Definition of table `categories` -- DROP TABLE IF EXISTS `categories`; CREATE TABLE `categories` ( `categories_id` int(11) NOT NULL auto_increment, `categories_image` varchar(64) default NULL, `parent_id` int(11) NOT NULL default '0', `sort_order` int(3) default NULL, `date_added` datetime default NULL, `last_modified` datetime default NULL, PRIMARY KEY (`categories_id`), KEY `idx_categories_parent_id` (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `categories` -- /*!40000 ALTER TABLE `categories` DISABLE KEYS */; INSERT INTO `categories` (`categories_id`,`categories_image`,`parent_id`,`sort_order`,`date_added`,`last_modified`) VALUES (1,'category_software.gif',0,6,'2007-04-05 17:40:11','2007-05-14 14:11:57'), (2,'category_software.gif',0,1,'2007-04-05 17:40:11','2007-05-10 17:14:18'), (3,'category_dvd_movies.gif',0,2,'2007-04-05 17:40:11','2007-05-10 17:14:38'), (4,'subcategory_graphic_cards.gif',1,0,'2007-04-05 17:40:11',NULL), (5,'subcategory_printers.gif',1,0,'2007-04-05 17:40:11',NULL), (6,'subcategory_monitors.gif',1,0,'2007-04-05 17:40:11',NULL), (7,'subcategory_speakers.gif',1,0,'2007-04-05 17:40:11',NULL), (8,'subcategory_keyboards.gif',1,0,'2007-04-05 17:40:11',NULL), (9,'subcategory_mice.gif',1,0,'2007-04-05 17:40:11',NULL), (10,'subcategory_action.gif',3,0,'2007-04-05 17:40:11',NULL), (11,'subcategory_science_fiction.gif',3,0,'2007-04-05 17:40:11',NULL), (12,'subcategory_comedy.gif',3,0,'2007-04-05 17:40:11',NULL), (13,'subcategory_cartoons.gif',3,0,'2007-04-05 17:40:11',NULL), (14,'subcategory_thriller.gif',3,0,'2007-04-05 17:40:11',NULL); INSERT INTO `categories` (`categories_id`,`categories_image`,`parent_id`,`sort_order`,`date_added`,`last_modified`) VALUES (15,'subcategory_drama.gif',3,0,'2007-04-05 17:40:11',NULL), (16,'subcategory_memory.gif',1,0,'2007-04-05 17:40:11',NULL), (17,'subcategory_cdrom_drives.gif',1,5,'2007-04-05 17:40:11','2007-05-05 14:17:05'), (18,'subcategory_simulation.gif',2,0,'2007-04-05 17:40:11',NULL), (19,'subcategory_action_games.gif',2,0,'2007-04-05 17:40:11',NULL), (52,'subcategory_strategy.gif',2,0,'2007-11-24 16:00:07',NULL), (53,NULL,0,0,'2008-03-16 08:27:15',NULL); /*!40000 ALTER TABLE `categories` ENABLE KEYS */; -- -- Definition of table `categories_description` -- DROP TABLE IF EXISTS `categories_description`; CREATE TABLE `categories_description` ( `categories_id` int(11) NOT NULL default '0', `language_id` int(11) NOT NULL default '1', `categories_name` varchar(32) character set utf8 NOT NULL, PRIMARY KEY (`categories_id`,`language_id`), KEY `idx_categories_name` (`categories_name`) ) ENGINE=InnoDB DEFAULT CHARSET=cp1251; -- -- Dumping data for table `categories_description` -- /*!40000 ALTER TABLE `categories_description` DISABLE KEYS */; INSERT INTO `categories_description` (`categories_id`,`language_id`,`categories_name`) VALUES (10,1,'Action'), (19,1,'Action'), (13,1,'Cartoons'), (17,1,'CDROM '), (12,1,'Comedy'), (15,1,'Drama'), (3,1,'DVD Movies'), (3,2,'DVD Филми'), (4,1,'Graphics Cards'), (1,1,'Hardware'), (8,1,'Keyboards'), (16,1,'Memory'), (9,1,'Mice'), (6,1,'Monitors'), (5,1,'Printers'), (11,1,'Science Fiction'), (18,1,'Simulation'), (2,1,'Software'), (7,1,'Speakers'), (52,1,'Strategy'), (14,1,'Thriller'), (13,2,'Анимации'), (7,2,'Говорители'), (4,2,'Графични карти'), (17,2,'Дискови устройства'), (15,2,'Драма'), (10,2,'Екшън'), (19,2,'Екшън'), (8,2,'Клавиетури'), (12,2,'Комедия'), (9,2,'Мишки'), (6,2,'Монитори'), (11,2,'Научна Фантастика'), (16,2,'Памет'), (5,2,'Принтери'), (18,2,'Симулация'), (2,2,'Софтуер'), (52,2,'Стратегии'), (14,2,'Трилър'); INSERT INTO `categories_description` (`categories_id`,`language_id`,`categories_name`) VALUES (1,2,'Хардуер'); /*!40000 ALTER TABLE `categories_description` ENABLE KEYS */; -- -- Definition of table `configuration` -- DROP TABLE IF EXISTS `configuration`; CREATE TABLE `configuration` ( `configuration_id` int(11) NOT NULL auto_increment, `configuration_title` varchar(64) NOT NULL, `configuration_key` varchar(64) NOT NULL, `configuration_value` varchar(255) NOT NULL, `configuration_description` varchar(255) NOT NULL, `configuration_group_id` int(11) NOT NULL, `sort_order` int(5) default NULL, `last_modified` datetime default NULL, `date_added` datetime NOT NULL, `use_function` varchar(255) default NULL, `set_function` varchar(255) default NULL, `use_values` varchar(45) NOT NULL, `value_type` varchar(1) NOT NULL, PRIMARY KEY (`configuration_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `configuration` -- /*!40000 ALTER TABLE `configuration` DISABLE KEYS */; INSERT INTO `configuration` (`configuration_id`,`configuration_title`,`configuration_key`,`configuration_value`,`configuration_description`,`configuration_group_id`,`sort_order`,`last_modified`,`date_added`,`use_function`,`set_function`,`use_values`,`value_type`) VALUES (1,'Store Name','STORE_NAME','Dream Store','The name of my store',1,1,NULL,'2007-04-05 17:40:11',NULL,NULL,'',''), (2,'Store Owner','STORE_OWNER','Alexander Petrov','The name of my store owner',1,2,NULL,'2007-04-05 17:40:11',NULL,NULL,'',''), (3,'E-Mail Address','STORE_OWNER_EMAIL_ADDRESS','root@localhoster','The e-mail address of my store owner',1,3,NULL,'2007-04-05 17:40:11',NULL,NULL,'',''), (4,'E-Mail From','EMAIL_FROM','faceCart ','The e-mail address used in (sent) e-mails',1,4,NULL,'2007-04-05 17:40:11',NULL,NULL,'',''), (5,'Country','STORE_COUNTRY','223','The country my store is located in

Note: Please remember to update the store zone.',1,6,NULL,'2007-04-05 17:40:11','tep_get_country_name','tep_cfg_pull_down_country_list(','getAllCountries','T'), (6,'Zone','STORE_ZONE','1','The zone my store is located in',1,7,NULL,'2007-04-05 17:40:11','tep_cfg_get_zone_name','tep_cfg_pull_down_zone_list(','Zone.getZoneMenu','T'); INSERT INTO `configuration` (`configuration_id`,`configuration_title`,`configuration_key`,`configuration_value`,`configuration_description`,`configuration_group_id`,`sort_order`,`last_modified`,`date_added`,`use_function`,`set_function`,`use_values`,`value_type`) VALUES (7,'Expected Sort Order','EXPECTED_PRODUCTS_SORT','desc','This is the sort order used in the expected products box.',1,8,NULL,'2007-04-05 17:40:11',NULL,'tep_cfg_select_option(array(\'asc\', \'desc\'), ','asc|desc','E'), (8,'Expected Sort Field','EXPECTED_PRODUCTS_FIELD','date_expected','The column to sort by in the expected products box.',1,9,NULL,'2007-04-05 17:40:11',NULL,'tep_cfg_select_option(array(\'products_name\', \'date_expected\'), ','products_name|date_expected','E'), (9,'Switch To Default Language Currency','USE_DEFAULT_LANGUAGE_CURRENCY','true','Automatically switch to the language\'s currency when it is changed',1,10,NULL,'2007-04-05 17:40:11',NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ','true|false','E'), (10,'Send Extra Order Emails To','SEND_EXTRA_ORDER_EMAILS_TO','','Send extra order emails to the following email addresses, in this format: Name 1 <email@address1>, Name 2 <email@address2>',1,11,NULL,'2007-04-05 17:40:11',NULL,NULL,'',''); INSERT INTO `configuration` (`configuration_id`,`configuration_title`,`configuration_key`,`configuration_value`,`configuration_description`,`configuration_group_id`,`sort_order`,`last_modified`,`date_added`,`use_function`,`set_function`,`use_values`,`value_type`) VALUES (11,'Use Search-Engine Safe URLs (still in development)','SEARCH_ENGINE_FRIENDLY_URLS','true','Use search-engine safe urls for all site links',1,12,NULL,'2007-04-05 17:40:11',NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ','true|false','E'), (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,'2007-04-05 17:40:11',NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ','true|false','E'), (13,'Allow Guest To Tell A Friend','ALLOW_GUEST_TO_TELL_A_FRIEND','true','Allow guests to tell a friend about a product',1,15,NULL,'2007-04-05 17:40:11',NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ','true|false','E'), (14,'Default Search Operator','ADVANCED_SEARCH_DEFAULT_OPERATOR','or','Default search operators',1,17,NULL,'2007-04-05 17:40:11',NULL,'tep_cfg_select_option(array(\'and\', \'or\'), ','and|or','E'); INSERT INTO `configuration` (`configuration_id`,`configuration_title`,`configuration_key`,`configuration_value`,`configuration_description`,`configuration_group_id`,`sort_order`,`last_modified`,`date_added`,`use_function`,`set_function`,`use_values`,`value_type`) VALUES (15,'Store Address and Phone','STORE_NAME_ADDRESS','Cory\'s Rockin Supply Store\r\n1800 More Stuff Here\r\nTuscaloosa, AL 35023\r\n205-128-1832','This is the Store Name, Address and Phone used on printable documents and displayed online',1,18,NULL,'2007-04-05 17:40:11',NULL,'tep_cfg_textarea(','$textarea','M'), (16,'Show Category Counts','SHOW_COUNTS','true','Count recursively how many products are in each category',1,19,NULL,'2007-04-05 17:40:11',NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ','true|false','E'), (17,'Tax Decimal Places','TAX_DECIMAL_PLACES','4','Pad the tax value this amount of decimal places',1,20,NULL,'2007-04-05 17:40:11',NULL,NULL,'',''), (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,'2007-04-05 17:40:11',NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ','true|false','E'), (19,'First Name','ENTRY_FIRST_NAME_MIN_LENGTH','3','Minimum length of first name',2,1,NULL,'2007-04-05 17:40:11',NULL,NULL,'',''); INSERT INTO `configuration` (`configuration_id`,`configuration_title`,`configuration_key`,`configuration_value`,`configuration_description`,`configuration_group_id`,`sort_order`,`last_modified`,`date_added`,`use_function`,`set_function`,`use_values`,`value_type`) VALUES (20,'Last Name','ENTRY_LAST_NAME_MIN_LENGTH','2','Minimum length of last name',2,2,NULL,'2007-04-05 17:40:11',NULL,NULL,'',''), (22,'E-Mail Address','ENTRY_EMAIL_ADDRESS_MIN_LENGTH','6','Minimum length of e-mail address',2,4,NULL,'2007-04-05 17:40:11',NULL,NULL,'',''), (23,'Street Address','ENTRY_STREET_ADDRESS_MIN_LENGTH','5','Minimum length of street address',2,5,NULL,'2007-04-05 17:40:11',NULL,NULL,'',''), (24,'Company','ENTRY_COMPANY_MIN_LENGTH','2','Minimum length of company name',2,6,NULL,'2007-04-05 17:40:11',NULL,NULL,'',''), (25,'Post Code','ENTRY_POSTCODE_MIN_LENGTH','4','Minimum length of post code',2,7,NULL,'2007-04-05 17:40:11',NULL,NULL,'',''), (26,'City','ENTRY_CITY_MIN_LENGTH','3','Minimum length of city',2,8,NULL,'2007-04-05 17:40:11',NULL,NULL,'',''), (27,'State','ENTRY_STATE_MIN_LENGTH','2','Minimum length of state',2,9,NULL,'2007-04-05 17:40:11',NULL,NULL,'',''); INSERT INTO `configuration` (`configuration_id`,`configuration_title`,`configuration_key`,`configuration_value`,`configuration_description`,`configuration_group_id`,`sort_order`,`last_modified`,`date_added`,`use_function`,`set_function`,`use_values`,`value_type`) VALUES (28,'Telephone Number','ENTRY_TELEPHONE_MIN_LENGTH','3','Minimum length of telephone number',2,10,NULL,'2007-04-05 17:40:11',NULL,NULL,'',''), (29,'Password','ENTRY_PASSWORD_MIN_LENGTH','5','Minimum length of password',2,11,NULL,'2007-04-05 17:40:11',NULL,NULL,'',''), (30,'Credit Card Owner Name','CC_OWNER_MIN_LENGTH','3','Minimum length of credit card owner name',2,12,NULL,'2007-04-05 17:40:11',NULL,NULL,'',''), (31,'Credit Card Number','CC_NUMBER_MIN_LENGTH','10','Minimum length of credit card number',2,13,NULL,'2007-04-05 17:40:11',NULL,NULL,'',''), (32,'Review Text','REVIEW_TEXT_MIN_LENGTH','50','Minimum length of review text',2,14,NULL,'2007-04-05 17:40:11',NULL,NULL,'',''), (33,'Best Sellers','MIN_DISPLAY_BESTSELLERS','1','Minimum number of best sellers to display',2,15,NULL,'2007-04-05 17:40:11',NULL,NULL,'',''), (34,'Also Purchased','MIN_DISPLAY_ALSO_PURCHASED','1','Minimum number of products to display in the \'This Customer Also Purchased\' box',2,16,NULL,'2007-04-05 17:40:11',NULL,NULL,'',''); INSERT INTO `configuration` (`configuration_id`,`configuration_title`,`configuration_key`,`configuration_value`,`configuration_description`,`configuration_group_id`,`sort_order`,`last_modified`,`date_added`,`use_function`,`set_function`,`use_values`,`value_type`) VALUES (35,'Address Book Entries','MAX_ADDRESS_BOOK_ENTRIES','5','Maximum address book entries a customer is allowed to have',3,1,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (36,'Search Results','MAX_DISPLAY_SEARCH_RESULTS','20','Amount of products to list',3,2,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (37,'Page Links','MAX_DISPLAY_PAGE_LINKS','5','Number of \'number\' links use for page-sets',3,3,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (38,'Special Products','MAX_DISPLAY_SPECIAL_PRODUCTS','9','Maximum number of products on special to display',3,4,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (39,'New Products Module','MAX_DISPLAY_NEW_PRODUCTS','9','Maximum number of new products to display in a category',3,5,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (40,'Products Expected','MAX_DISPLAY_UPCOMING_PRODUCTS','10','Maximum number of products expected to display',3,6,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''); INSERT INTO `configuration` (`configuration_id`,`configuration_title`,`configuration_key`,`configuration_value`,`configuration_description`,`configuration_group_id`,`sort_order`,`last_modified`,`date_added`,`use_function`,`set_function`,`use_values`,`value_type`) 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,'2007-04-05 17:40:12',NULL,NULL,'',''), (42,'Manufacturers Select Size','MAX_MANUFACTURERS_LIST','1','Used in manufacturers box; when this value is \'1\' the classic drop-down list will be used for the manufacturers box. Otherwise, a list-box with the specified number of rows will be displayed.',3,7,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (43,'Length of Manufacturers Name','MAX_DISPLAY_MANUFACTURER_NAME_LEN','15','Used in manufacturers box; maximum length of manufacturers name to display',3,8,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (44,'New Reviews','MAX_DISPLAY_NEW_REVIEWS','6','Maximum number of new reviews to display',3,9,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''); INSERT INTO `configuration` (`configuration_id`,`configuration_title`,`configuration_key`,`configuration_value`,`configuration_description`,`configuration_group_id`,`sort_order`,`last_modified`,`date_added`,`use_function`,`set_function`,`use_values`,`value_type`) VALUES (48,'Categories To List Per Row','MAX_DISPLAY_CATEGORIES_PER_ROW','3','How many categories to list per row',3,13,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (49,'New Products Listing','MAX_DISPLAY_PRODUCTS_NEW','10','Maximum number of new products to display in new products page',3,14,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (50,'Best Sellers','MAX_DISPLAY_BESTSELLERS','10','Maximum number of best sellers to display',3,15,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (51,'Also Purchased','MAX_DISPLAY_ALSO_PURCHASED','6','Maximum number of products to display in the \'This Customer Also Purchased\' box',3,16,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (52,'Customer Order History Box','MAX_DISPLAY_PRODUCTS_IN_ORDER_HISTORY_BOX','6','Maximum number of products to display in the customer order history box',3,17,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (53,'Order History','MAX_DISPLAY_ORDER_HISTORY','10','Maximum number of orders to display in the order history page',3,18,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''); INSERT INTO `configuration` (`configuration_id`,`configuration_title`,`configuration_key`,`configuration_value`,`configuration_description`,`configuration_group_id`,`sort_order`,`last_modified`,`date_added`,`use_function`,`set_function`,`use_values`,`value_type`) VALUES (54,'Small Image Width','SMALL_IMAGE_WIDTH','100','The pixel width of small images',4,1,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (55,'Small Image Height','SMALL_IMAGE_HEIGHT','80','The pixel height of small images',4,2,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (56,'Heading Image Width','HEADING_IMAGE_WIDTH','57','The pixel width of heading images',4,3,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (57,'Heading Image Height','HEADING_IMAGE_HEIGHT','40','The pixel height of heading images',4,4,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (58,'Subcategory Image Width','SUBCATEGORY_IMAGE_WIDTH','100','The pixel width of subcategory images',4,5,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (59,'Subcategory Image Height','SUBCATEGORY_IMAGE_HEIGHT','57','The pixel height of subcategory images',4,6,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (60,'Calculate Image Size','CONFIG_CALCULATE_IMAGE_SIZE','true','Calculate the size of images?',4,7,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ','true|false','E'); INSERT INTO `configuration` (`configuration_id`,`configuration_title`,`configuration_key`,`configuration_value`,`configuration_description`,`configuration_group_id`,`sort_order`,`last_modified`,`date_added`,`use_function`,`set_function`,`use_values`,`value_type`) VALUES (61,'Image Required','IMAGE_REQUIRED','true','Enable to display broken images. Good for development.',4,8,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ','true|false','E'), (62,'Gender','ACCOUNT_GENDER','true','Display gender in the customers account',5,1,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ','true|false','E'), (63,'Date of Birth','ACCOUNT_DOB','true','Display date of birth in the customers account',5,2,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ','true|false','E'), (64,'Company','ACCOUNT_COMPANY','true','Display company in the customers account',5,3,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ','true|false','E'), (65,'Suburb','ACCOUNT_SUBURB','true','Display suburb in the customers account',5,4,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ','true|false','E'); INSERT INTO `configuration` (`configuration_id`,`configuration_title`,`configuration_key`,`configuration_value`,`configuration_description`,`configuration_group_id`,`sort_order`,`last_modified`,`date_added`,`use_function`,`set_function`,`use_values`,`value_type`) VALUES (66,'State','ACCOUNT_STATE','true','Display state in the customers account',5,5,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ','true|false','E'), (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,'2007-04-05 17:40:12',NULL,NULL,'',''), (68,'Installed Modules','MODULE_ORDER_TOTAL_INSTALLED','ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php','List of order_total module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php)',6,0,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (69,'Installed Modules','MODULE_SHIPPING_INSTALLED','flat.php','List of shipping module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: ups.php;flat.php;item.php)',6,0,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''); INSERT INTO `configuration` (`configuration_id`,`configuration_title`,`configuration_key`,`configuration_value`,`configuration_description`,`configuration_group_id`,`sort_order`,`last_modified`,`date_added`,`use_function`,`set_function`,`use_values`,`value_type`) VALUES (70,'Enable Cash On Delivery Module','MODULE_PAYMENT_COD_STATUS','True','Do you want to accept Cash On Delevery payments?',6,1,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'True\', \'False\'), ','true|false','E'), (71,'Payment Zone','MODULE_PAYMENT_COD_ZONE','0','If a zone is selected, only enable this payment method for that zone.',6,2,NULL,'2007-04-05 17:40:12','tep_get_zone_class_title','tep_cfg_pull_down_zone_classes(','',''), (72,'Sort order of display.','MODULE_PAYMENT_COD_SORT_ORDER','0','Sort order of display. Lowest is displayed first.',6,0,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (73,'Set Order Status','MODULE_PAYMENT_COD_ORDER_STATUS_ID','0','Set the status of orders made with this payment module to this value',6,0,NULL,'2007-04-05 17:40:12','tep_get_order_status_name','tep_cfg_pull_down_order_statuses(','',''), (74,'Enable Credit Card Module','MODULE_PAYMENT_CC_STATUS','True','Do you want to accept credit card payments?',6,0,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'True\', \'False\'), ','true|false','E'); INSERT INTO `configuration` (`configuration_id`,`configuration_title`,`configuration_key`,`configuration_value`,`configuration_description`,`configuration_group_id`,`sort_order`,`last_modified`,`date_added`,`use_function`,`set_function`,`use_values`,`value_type`) 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,'2007-04-05 17:40:12',NULL,NULL,'',''), (76,'Sort order of display.','MODULE_PAYMENT_CC_SORT_ORDER','0','Sort order of display. Lowest is displayed first.',6,0,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (77,'Payment Zone','MODULE_PAYMENT_CC_ZONE','0','If a zone is selected, only enable this payment method for that zone.',6,2,NULL,'2007-04-05 17:40:12','tep_get_zone_class_title','tep_cfg_pull_down_zone_classes(','',''), (78,'Set Order Status','MODULE_PAYMENT_CC_ORDER_STATUS_ID','0','Set the status of orders made with this payment module to this value',6,0,NULL,'2007-04-05 17:40:12','tep_get_order_status_name','tep_cfg_pull_down_order_statuses(','',''), (79,'Enable Flat Shipping','MODULE_SHIPPING_FLAT_STATUS','True','Do you want to offer flat rate shipping?',6,0,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'True\', \'False\'), ','true|false','E'); INSERT INTO `configuration` (`configuration_id`,`configuration_title`,`configuration_key`,`configuration_value`,`configuration_description`,`configuration_group_id`,`sort_order`,`last_modified`,`date_added`,`use_function`,`set_function`,`use_values`,`value_type`) VALUES (80,'Shipping Cost','MODULE_SHIPPING_FLAT_COST','5.00','The shipping cost for all orders using this shipping method.',6,0,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (81,'Tax Class','MODULE_SHIPPING_FLAT_TAX_CLASS','0','Use the following tax class on the shipping fee.',6,0,NULL,'2007-04-05 17:40:12','tep_get_tax_class_title','tep_cfg_pull_down_tax_classes(','',''), (82,'Shipping Zone','MODULE_SHIPPING_FLAT_ZONE','0','If a zone is selected, only enable this shipping method for that zone.',6,0,NULL,'2007-04-05 17:40:12','tep_get_zone_class_title','tep_cfg_pull_down_zone_classes(','',''), (83,'Sort Order','MODULE_SHIPPING_FLAT_SORT_ORDER','0','Sort order of display.',6,0,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (84,'Default Currency','DEFAULT_CURRENCY','USD','Default Currency',6,0,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (85,'Default Language','DEFAULT_LANGUAGE','en','Default Language',6,0,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''); INSERT INTO `configuration` (`configuration_id`,`configuration_title`,`configuration_key`,`configuration_value`,`configuration_description`,`configuration_group_id`,`sort_order`,`last_modified`,`date_added`,`use_function`,`set_function`,`use_values`,`value_type`) 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,'2007-04-05 17:40:12',NULL,NULL,'',''), (87,'Display Shipping','MODULE_ORDER_TOTAL_SHIPPING_STATUS','true','Do you want to display the order shipping cost?',6,1,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ','true|false','E'), (88,'Sort Order','MODULE_ORDER_TOTAL_SHIPPING_SORT_ORDER','2','Sort order of display.',6,2,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (89,'Allow Free Shipping','MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING','false','Do you want to allow free shipping?',6,3,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ','true|false','E'), (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,'2007-04-05 17:40:12','currencies->format',NULL,'',''); INSERT INTO `configuration` (`configuration_id`,`configuration_title`,`configuration_key`,`configuration_value`,`configuration_description`,`configuration_group_id`,`sort_order`,`last_modified`,`date_added`,`use_function`,`set_function`,`use_values`,`value_type`) 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,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'national\', \'international\', \'both\'), ','national|international|both','E'), (92,'Display Sub-Total','MODULE_ORDER_TOTAL_SUBTOTAL_STATUS','true','Do you want to display the order sub-total cost?',6,1,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ','true|false','E'), (93,'Sort Order','MODULE_ORDER_TOTAL_SUBTOTAL_SORT_ORDER','1','Sort order of display.',6,2,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (94,'Display Tax','MODULE_ORDER_TOTAL_TAX_STATUS','true','Do you want to display the order tax value?',6,1,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ','true|false','E'), (95,'Sort Order','MODULE_ORDER_TOTAL_TAX_SORT_ORDER','3','Sort order of display.',6,2,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''); INSERT INTO `configuration` (`configuration_id`,`configuration_title`,`configuration_key`,`configuration_value`,`configuration_description`,`configuration_group_id`,`sort_order`,`last_modified`,`date_added`,`use_function`,`set_function`,`use_values`,`value_type`) VALUES (96,'Display Total','MODULE_ORDER_TOTAL_TOTAL_STATUS','true','Do you want to display the total order value?',6,1,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ','true|false','E'), (97,'Sort Order','MODULE_ORDER_TOTAL_TOTAL_SORT_ORDER','4','Sort order of display.',6,2,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (98,'Country of Origin','SHIPPING_ORIGIN_COUNTRY','223','Select the country of origin to be used in shipping quotes.',7,1,NULL,'2007-04-05 17:40:12','tep_get_country_name','tep_cfg_pull_down_country_list(','getAllCountries','T'), (99,'Postal Code','SHIPPING_ORIGIN_ZIP','NONE','Enter the Postal Code (ZIP) of the Store to be used in shipping quotes.',7,2,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (100,'Enter the Maximum Package Weight you will ship','SHIPPING_MAX_WEIGHT','50','Carriers have a max weight limit for a single package. This is a common one for all.',7,3,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''); INSERT INTO `configuration` (`configuration_id`,`configuration_title`,`configuration_key`,`configuration_value`,`configuration_description`,`configuration_group_id`,`sort_order`,`last_modified`,`date_added`,`use_function`,`set_function`,`use_values`,`value_type`) VALUES (101,'Package Tare weight.','SHIPPING_BOX_WEIGHT','3','What is the weight of typical packaging of small to medium packages?',7,4,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (102,'Larger packages - percentage increase.','SHIPPING_BOX_PADDING','10','For 10% enter 10',7,5,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (103,'Display Product Image','PRODUCT_LIST_IMAGE','1','Do you want to display the Product Image?',8,1,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (104,'Display Product Manufaturer Name','PRODUCT_LIST_MANUFACTURER','1','Do you want to display the Product Manufacturer Name?',8,2,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (105,'Display Product Model','PRODUCT_LIST_MODEL','0','Do you want to display the Product Model?',8,3,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (106,'Display Product Name','PRODUCT_LIST_NAME','3','Do you want to display the Product Name?',8,4,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''); INSERT INTO `configuration` (`configuration_id`,`configuration_title`,`configuration_key`,`configuration_value`,`configuration_description`,`configuration_group_id`,`sort_order`,`last_modified`,`date_added`,`use_function`,`set_function`,`use_values`,`value_type`) VALUES (107,'Display Product Price','PRODUCT_LIST_PRICE','Yes','Do you want to display the Product Price',8,5,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (108,'Display Product Quantity','PRODUCT_LIST_QUANTITY','0','Do you want to display the Product Quantity?',8,6,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (109,'Display Product Weight','PRODUCT_LIST_WEIGHT','0','Do you want to display the Product Weight?',8,7,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (110,'Display Buy Now column','PRODUCT_LIST_BUY_NOW','4','Do you want to display the Buy Now column?',8,8,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (111,'Display Category/Manufacturer Filter (0=disable; 1=enable)','PRODUCT_LIST_FILTER','1','Do you want to display the Category/Manufacturer Filter?',8,9,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (112,'Location of Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)','PREV_NEXT_BAR_LOCATION','2','Sets the location of the Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)',8,10,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''); INSERT INTO `configuration` (`configuration_id`,`configuration_title`,`configuration_key`,`configuration_value`,`configuration_description`,`configuration_group_id`,`sort_order`,`last_modified`,`date_added`,`use_function`,`set_function`,`use_values`,`value_type`) VALUES (113,'Check stock level','STOCK_CHECK','true','Check to see if sufficent stock is available',9,1,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ','true|false','E'), (114,'Subtract stock','STOCK_LIMITED','true','Subtract product in stock by product orders',9,2,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ','true|false','E'), (115,'Allow Checkout','STOCK_ALLOW_CHECKOUT','true','Allow customer to checkout even if there is insufficient stock',9,3,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ','',''), (116,'Mark product out of stock','STOCK_MARK_PRODUCT_OUT_OF_STOCK','***','Display something on screen so customer can see which product has insufficient stock',9,4,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (117,'Stock Re-order level','STOCK_REORDER_LEVEL','5','Define when stock needs to be re-ordered',9,5,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''); INSERT INTO `configuration` (`configuration_id`,`configuration_title`,`configuration_key`,`configuration_value`,`configuration_description`,`configuration_group_id`,`sort_order`,`last_modified`,`date_added`,`use_function`,`set_function`,`use_values`,`value_type`) VALUES (118,'Store Page Parse Time','STORE_PAGE_PARSE_TIME','false','Store the time it takes to parse a page',10,1,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ','true|false','E'), (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,'2007-04-05 17:40:12',NULL,NULL,'',''), (120,'Log Date Format','STORE_PARSE_DATE_TIME_FORMAT','%d/%m/%Y %H:%M:%S','The date format',10,3,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (121,'Display The Page Parse Time','DISPLAY_PAGE_PARSE_TIME','true','Display the page parse time (store page parse time must be enabled)',10,4,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ','true|false','E'), (122,'Store Database Queries','STORE_DB_TRANSACTIONS','false','Store the database queries in the page parse time log (PHP4 only)',10,5,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ','true|false','E'); INSERT INTO `configuration` (`configuration_id`,`configuration_title`,`configuration_key`,`configuration_value`,`configuration_description`,`configuration_group_id`,`sort_order`,`last_modified`,`date_added`,`use_function`,`set_function`,`use_values`,`value_type`) VALUES (123,'Use Cache','USE_CACHE','false','Use caching features',11,1,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ','true|false','E'), (124,'Cache Directory','DIR_FS_CACHE','/tmp/','The directory where the cached files are saved',11,2,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (125,'E-Mail Transport Method','EMAIL_TRANSPORT','smtp','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,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'sendmail\', \'smtp\'),','sendmail|smtp','E'), (126,'E-Mail Linefeeds','EMAIL_LINEFEED','LF','Defines the character sequence used to separate mail headers.',12,2,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'LF\', \'CRLF\'),','LF|CRLF','E'), (127,'Use MIME HTML When Sending Emails','EMAIL_USE_HTML','true','Send e-mails in HTML format',12,3,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),','true|false','E'); INSERT INTO `configuration` (`configuration_id`,`configuration_title`,`configuration_key`,`configuration_value`,`configuration_description`,`configuration_group_id`,`sort_order`,`last_modified`,`date_added`,`use_function`,`set_function`,`use_values`,`value_type`) VALUES (128,'Verify E-Mail Addresses Through DNS','ENTRY_EMAIL_ADDRESS_CHECK','true','Verify e-mail address through a DNS server',12,4,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ','true|false','E'), (129,'Send E-Mails','SEND_EMAILS','true','Send out e-mails',12,5,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ','true|false','E'), (130,'Enable download','DOWNLOAD_ENABLED','false','Enable the products download functions.',13,1,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ','true|false','E'), (131,'Download by redirect','DOWNLOAD_BY_REDIRECT','true','Use browser redirection for download. Disable on non-Unix systems.',13,2,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ','true|false','E'), (132,'Expiry delay (days)','DOWNLOAD_MAX_DAYS','7','Set number of days before the download link expires. 0 means no limit.',13,3,NULL,'2007-04-05 17:40:12',NULL,'','',''); INSERT INTO `configuration` (`configuration_id`,`configuration_title`,`configuration_key`,`configuration_value`,`configuration_description`,`configuration_group_id`,`sort_order`,`last_modified`,`date_added`,`use_function`,`set_function`,`use_values`,`value_type`) VALUES (133,'Maximum number of downloads','DOWNLOAD_MAX_COUNT','5','Set the maximum number of downloads. 0 means no download authorized.',13,4,NULL,'2007-04-05 17:40:12',NULL,'','',''), (134,'Enable GZip Compression','GZIP_COMPRESSION','false','Enable HTTP GZip compression.',14,1,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ','true|false','E'), (135,'Compression Level','GZIP_LEVEL','5','Use this compression level 0-9 (0 = minimum, 9 = maximum).',14,2,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (136,'Session Directory','SESSION_WRITE_DIRECTORY','/tmp','If sessions are file based, store them in this directory.',15,1,NULL,'2007-04-05 17:40:12',NULL,NULL,'',''), (137,'Force Cookie Use','SESSION_FORCE_COOKIE_USE','False','Force the use of sessions when cookies are only enabled.',15,2,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'True\', \'False\'), ','true|false','E'), (138,'Check SSL Session ID','SESSION_CHECK_SSL_SESSION_ID','false','Validate the SSL_SESSION_ID on every secure HTTPS page request.',15,3,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'True\', \'False\'), ','true|false','E'); INSERT INTO `configuration` (`configuration_id`,`configuration_title`,`configuration_key`,`configuration_value`,`configuration_description`,`configuration_group_id`,`sort_order`,`last_modified`,`date_added`,`use_function`,`set_function`,`use_values`,`value_type`) VALUES (139,'Check User Agent','SESSION_CHECK_USER_AGENT','true','Validate the clients browser user agent on every page request.',15,4,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'True\', \'False\'), ','true|false','E'), (140,'Check IP Address','SESSION_CHECK_IP_ADDRESS','False','Validate the clients IP address on every page request.',15,5,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'True\', \'False\'), ','true|false','E'), (141,'Prevent Spider Sessions','SESSION_BLOCK_SPIDERS','true','Prevent known spiders from starting a session.',15,6,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'True\', \'False\'), ','true|false','E'), (142,'Recreate Session','SESSION_RECREATE','False','Recreate the session to generate a new session ID when the customer logs on or creates an account (PHP >=4.1 needed).',15,7,NULL,'2007-04-05 17:40:12',NULL,'tep_cfg_select_option(array(\'True\', \'False\'), ','true|false','E'), (143,'SMTP Server','EMAIL_SMTP_SERVER','localhost','SMTP Server used to send emails.',12,6,NULL,'2007-07-31 00:00:00','',NULL,'',''); INSERT INTO `configuration` (`configuration_id`,`configuration_title`,`configuration_key`,`configuration_value`,`configuration_description`,`configuration_group_id`,`sort_order`,`last_modified`,`date_added`,`use_function`,`set_function`,`use_values`,`value_type`) VALUES (144,'SMTP Port','EMAIL_SMTP_PORT','25','The SMTP port number',12,7,NULL,'2007-07-31 00:00:00','',NULL,' ',''), (145,'SMTP Username','EMAIL_SMTP_USER','test','The username used to authenticate on the mail server.',12,8,NULL,'2007-07-31 00:00:00','',NULL,' ',''), (146,'SMTP Password','EMAIL_SMTP_PASSWORD','password','The password used to authenticate on the mail server.',12,9,NULL,'2007-07-31 00:00:00','',NULL,'',''); /*!40000 ALTER TABLE `configuration` ENABLE KEYS */; -- -- Definition of table `configuration_group` -- DROP TABLE IF EXISTS `configuration_group`; CREATE TABLE `configuration_group` ( `configuration_group_id` int(11) NOT NULL auto_increment, `configuration_group_title` varchar(64) NOT NULL, `configuration_group_description` varchar(255) NOT NULL, `sort_order` int(5) default NULL, `visible` int(1) default '1', `screen_name` varchar(45) NOT NULL, PRIMARY KEY (`configuration_group_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `configuration_group` -- /*!40000 ALTER TABLE `configuration_group` DISABLE KEYS */; INSERT INTO `configuration_group` (`configuration_group_id`,`configuration_group_title`,`configuration_group_description`,`sort_order`,`visible`,`screen_name`) VALUES (1,'My Store','General information about my store',1,1,'my_store'), (2,'Minimum Values','The minimum values for functions / data',2,1,'min_val'), (3,'Maximum Values','The maximum values for functions / data',3,1,'max_val'), (4,'Images','Image parameters',4,1,'images'), (5,'Customer Details','Customer account configuration',5,1,'customer_detaims'), (6,'Module Options','Hidden from configuration',6,0,''), (7,'Shipping/Packaging','Shipping options available at my store',7,1,'ship_pack'), (8,'Product Listing','Product Listing configuration options',8,1,'prod_list'), (9,'Stock','Stock configuration options',9,1,'stock'), (10,'Logging','Logging configuration options',10,1,'logging'), (11,'Cache','Caching configuration options',11,1,'cache'), (12,'E-Mail Options','General setting for E-Mail transport and HTML E-Mails',12,1,'email'), (13,'Download','Downloadable products options',13,1,'download'); INSERT INTO `configuration_group` (`configuration_group_id`,`configuration_group_title`,`configuration_group_description`,`sort_order`,`visible`,`screen_name`) VALUES (14,'GZip Compression','GZip compression options',14,1,'gzip'), (15,'Sessions','Session options',15,1,'sessions'); /*!40000 ALTER TABLE `configuration_group` ENABLE KEYS */; -- -- Definition of table `counter` -- DROP TABLE IF EXISTS `counter`; CREATE TABLE `counter` ( `startdate` char(8) default NULL, `counter` int(12) default NULL, `id` int(10) unsigned NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `counter` -- /*!40000 ALTER TABLE `counter` DISABLE KEYS */; INSERT INTO `counter` (`startdate`,`counter`,`id`) VALUES ('20070405',1,0); /*!40000 ALTER TABLE `counter` ENABLE KEYS */; -- -- Definition of table `counter_history` -- DROP TABLE IF EXISTS `counter_history`; CREATE TABLE `counter_history` ( `month` char(8) default NULL, `counter` int(12) default NULL, `id` varchar(45) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `counter_history` -- /*!40000 ALTER TABLE `counter_history` DISABLE KEYS */; /*!40000 ALTER TABLE `counter_history` ENABLE KEYS */; -- -- Definition of table `countries` -- DROP TABLE IF EXISTS `countries`; CREATE TABLE `countries` ( `countries_id` int(11) NOT NULL auto_increment, `countries_name` varchar(64) NOT NULL, `countries_iso_code_2` char(2) NOT NULL, `countries_iso_code_3` char(3) NOT NULL, `address_format_id` int(11) NOT NULL, PRIMARY KEY (`countries_id`), KEY `IDX_COUNTRIES_NAME` (`countries_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `countries` -- /*!40000 ALTER TABLE `countries` DISABLE KEYS */; INSERT INTO `countries` (`countries_id`,`countries_name`,`countries_iso_code_2`,`countries_iso_code_3`,`address_format_id`) VALUES (8,'Antarctica','AQ','ATA',4), (9,'Antigua and Barbuda','AG','ATG',1), (10,'Argentina','AR','ARG',1), (15,'Azerbaijan','AZ','AZE',1), (20,'Belarus','BY','BLR',1), (21,'Belgium','BE','BEL',1), (23,'Benin','BJ','BEN',1), (24,'Bermuda','BM','BMU',1), (25,'Bhutan','BT','BTN',1), (26,'Bolivia','BO','BOL',1), (27,'Bosnia and Herzegowina','BA','BIH',1), (28,'Botswana','BW','BWA',1), (29,'Bouvet Island','BV','BVT',1), (30,'Brazil','BR','BRA',1), (31,'British Indian Ocean Territory','IO','IOT',1), (32,'Brunei Darussalam','BN','BRN',1), (33,'Bulgaria','BG','BGR',1), (34,'Burkina Faso','BF','BFA',1), (35,'Burundi','BI','BDI',1), (36,'Cambodia','KH','KHM',1), (37,'Cameroon','CM','CMR',1), (38,'Canada','CA','CAN',1), (39,'Cape Verde','CV','CPV',1), (40,'Cayman Islands','KY','CYM',1), (41,'Central African Republic','CF','CAF',1), (42,'Chad','TD','TCD',1), (43,'Chile','CL','CHL',1); INSERT INTO `countries` (`countries_id`,`countries_name`,`countries_iso_code_2`,`countries_iso_code_3`,`address_format_id`) VALUES (44,'China','CN','CHN',1), (45,'Christmas Island','CX','CXR',1), (46,'Cocos (Keeling) Islands','CC','CCK',1), (47,'Colombia','CO','COL',1), (48,'Comoros','KM','COM',1), (49,'Congo','CG','COG',1), (50,'Cook Islands','CK','COK',1), (51,'Costa Rica','CR','CRI',1), (52,'Cote D\'Ivoire','CI','CIV',1), (53,'Croatia','HR','HRV',1), (54,'Cuba','CU','CUB',1), (55,'Cyprus','CY','CYP',1), (56,'Czech Republic','CZ','CZE',1), (57,'Denmark','DK','DNK',1), (58,'Djibouti','DJ','DJI',1), (59,'Dominica','DM','DMA',1), (60,'Dominican Republic','DO','DOM',1), (61,'East Timor','TP','TMP',1), (62,'Ecuador','EC','ECU',1), (63,'Egypt','EG','EGY',1), (64,'El Salvador','SV','SLV',1), (65,'Equatorial Guinea','GQ','GNQ',1), (66,'Eritrea','ER','ERI',1), (67,'Estonia','EE','EST',1), (68,'Ethiopia','ET','ETH',1), (69,'Falkland Islands (Malvinas)','FK','FLK',1), (70,'Faroe Islands','FO','FRO',1); INSERT INTO `countries` (`countries_id`,`countries_name`,`countries_iso_code_2`,`countries_iso_code_3`,`address_format_id`) VALUES (71,'Fiji','FJ','FJI',1), (72,'Finland','FI','FIN',1), (73,'France','FR','FRA',1), (74,'France, Metropolitan','FX','FXX',1), (75,'French Guiana','GF','GUF',1), (76,'French Polynesia','PF','PYF',1), (77,'French Southern Territories','TF','ATF',1), (78,'Gabon','GA','GAB',1), (79,'Gambia','GM','GMB',1), (80,'Georgia','GE','GEO',1), (81,'Germany','DE','DEU',5), (82,'Ghana','GH','GHA',1), (83,'Gibraltar','GI','GIB',1), (84,'Greece','GR','GRC',1), (85,'Greenland','GL','GRL',1), (86,'Grenada','GD','GRD',1), (87,'Guadeloupe','GP','GLP',1), (88,'Guam','GU','GUM',1), (89,'Guatemala','GT','GTM',1), (90,'Guinea','GN','GIN',1), (91,'Guinea-bissau','GW','GNB',1), (92,'Guyana','GY','GUY',1), (93,'Haiti','HT','HTI',1), (94,'Heard and Mc Donald Islands','HM','HMD',1), (95,'Honduras','HN','HND',1), (96,'Hong Kong','HK','HKG',1), (97,'Hungary','HU','HUN',1), (98,'Iceland','IS','ISL',1); INSERT INTO `countries` (`countries_id`,`countries_name`,`countries_iso_code_2`,`countries_iso_code_3`,`address_format_id`) VALUES (99,'India','IN','IND',1), (100,'Indonesia','ID','IDN',1), (101,'Iran (Islamic Republic of)','IR','IRN',1), (102,'Iraq','IQ','IRQ',1), (103,'Ireland','IE','IRL',1), (104,'Israel','IL','ISR',1), (105,'Italy','IT','ITA',1), (106,'Jamaica','JM','JAM',1), (107,'Japan','JP','JPN',1), (108,'Jordan','JO','JOR',1), (109,'Kazakhstan','KZ','KAZ',1), (110,'Kenya','KE','KEN',1), (111,'Kiribati','KI','KIR',1), (112,'Korea, Democratic People\'s Republic of','KP','PRK',1), (113,'Korea, Republic of','KR','KOR',1), (114,'Kuwait','KW','KWT',1), (115,'Kyrgyzstan','KG','KGZ',1), (116,'Lao People\'s Democratic Republic','LA','LAO',1), (117,'Latvia','LV','LVA',1), (118,'Lebanon','LB','LBN',1), (119,'Lesotho','LS','LSO',1), (120,'Liberia','LR','LBR',1), (121,'Libyan Arab Jamahiriya','LY','LBY',1), (122,'Liechtenstein','LI','LIE',1), (123,'Lithuania','LT','LTU',1), (124,'Luxembourg','LU','LUX',1); INSERT INTO `countries` (`countries_id`,`countries_name`,`countries_iso_code_2`,`countries_iso_code_3`,`address_format_id`) VALUES (125,'Macau','MO','MAC',1), (126,'Macedonia, The Former Yugoslav Republic of','MK','MKD',1), (127,'Madagascar','MG','MDG',1), (128,'Malawi','MW','MWI',1), (129,'Malaysia','MY','MYS',1), (130,'Maldives','MV','MDV',1), (131,'Mali','ML','MLI',1), (132,'Malta','MT','MLT',1), (133,'Marshall Islands','MH','MHL',1), (134,'Martinique','MQ','MTQ',1), (135,'Mauritania','MR','MRT',1), (136,'Mauritius','MU','MUS',1), (137,'Mayotte','YT','MYT',1), (138,'Mexico','MX','MEX',1), (139,'Micronesia, Federated States of','FM','FSM',1), (140,'Moldova, Republic of','MD','MDA',1), (141,'Monaco','MC','MCO',1), (142,'Mongolia','MN','MNG',1), (143,'Montserrat','MS','MSR',1), (144,'Morocco','MA','MAR',1), (145,'Mozambique','MZ','MOZ',1), (146,'Myanmar','MM','MMR',1), (147,'Namibia','NA','NAM',1), (148,'Nauru','NR','NRU',1), (149,'Nepal','NP','NPL',1), (150,'Netherlands','NL','NLD',1), (151,'Netherlands Antilles','AN','ANT',1); INSERT INTO `countries` (`countries_id`,`countries_name`,`countries_iso_code_2`,`countries_iso_code_3`,`address_format_id`) VALUES (152,'New Caledonia','NC','NCL',1), (153,'New Zealand','NZ','NZL',1), (154,'Nicaragua','NI','NIC',1), (155,'Niger','NE','NER',1), (156,'Nigeria','NG','NGA',1), (157,'Niue','NU','NIU',1), (158,'Norfolk Island','NF','NFK',1), (159,'Northern Mariana Islands','MP','MNP',1), (160,'Norway','NO','NOR',1), (161,'Oman','OM','OMN',1), (162,'Pakistan','PK','PAK',1), (163,'Palau','PW','PLW',1), (164,'Panama','PA','PAN',1), (165,'Papua New Guinea','PG','PNG',1), (166,'Paraguay','PY','PRY',1), (167,'Peru','PE','PER',1), (168,'Philippines','PH','PHL',1), (169,'Pitcairn','PN','PCN',1), (170,'Poland','PL','POL',1), (171,'Portugal','PT','PRT',1), (172,'Puerto Rico','PR','PRI',1), (173,'Qatar','QA','QAT',1), (174,'Reunion','RE','REU',1), (175,'Romania','RO','ROM',1), (176,'Russian Federation','RU','RUS',1), (177,'Rwanda','RW','RWA',1), (178,'Saint Kitts and Nevis','KN','KNA',1), (179,'Saint Lucia','LC','LCA',1); INSERT INTO `countries` (`countries_id`,`countries_name`,`countries_iso_code_2`,`countries_iso_code_3`,`address_format_id`) VALUES (180,'Saint Vincent and the Grenadines','VC','VCT',1), (181,'Samoa','WS','WSM',1), (182,'San Marino','SM','SMR',1), (183,'Sao Tome and Principe','ST','STP',1), (184,'Saudi Arabia','SA','SAU',1), (185,'Senegal','SN','SEN',1), (186,'Seychelles','SC','SYC',1), (187,'Sierra Leone','SL','SLE',1), (188,'Singapore','SG','SGP',4), (189,'Slovakia (Slovak Republic)','SK','SVK',1), (190,'Slovenia','SI','SVN',1), (191,'Solomon Islands','SB','SLB',1), (192,'Somalia','SO','SOM',1), (193,'South Africa','ZA','ZAF',1), (194,'South Georgia and the South Sandwich Islands','GS','SGS',1), (195,'Spain','ES','ESP',3), (196,'Sri Lanka','LK','LKA',1), (197,'St. Helena','SH','SHN',1), (198,'St. Pierre and Miquelon','PM','SPM',1), (199,'Sudan','SD','SDN',1), (200,'Suriname','SR','SUR',1), (201,'Svalbard and Jan Mayen Islands','SJ','SJM',1), (202,'Swaziland','SZ','SWZ',1), (203,'Sweden','SE','SWE',1); INSERT INTO `countries` (`countries_id`,`countries_name`,`countries_iso_code_2`,`countries_iso_code_3`,`address_format_id`) VALUES (204,'Switzerland','CH','CHE',1), (205,'Syrian Arab Republic','SY','SYR',1), (206,'Taiwan','TW','TWN',1), (207,'Tajikistan','TJ','TJK',1), (208,'Tanzania, United Republic of','TZ','TZA',1), (209,'Thailand','TH','THA',1), (210,'Togo','TG','TGO',1), (211,'Tokelau','TK','TKL',1), (212,'Tonga','TO','TON',1), (213,'Trinidad and Tobago','TT','TTO',1), (214,'Tunisia','TN','TUN',1), (215,'Turkey','TR','TUR',1), (216,'Turkmenistan','TM','TKM',1), (217,'Turks and Caicos Islands','TC','TCA',1), (218,'Tuvalu','TV','TUV',1), (219,'Uganda','UG','UGA',1), (220,'Ukraine','UA','UKR',1), (221,'United Arab Emirates','AE','ARE',1), (222,'United Kingdom','GB','GBR',1), (223,'United States','US','USA',2), (224,'United States Minor Outlying Islands','UM','UMI',1), (225,'Uruguay','UY','URY',1), (226,'Uzbekistan','UZ','UZB',1), (227,'Vanuatu','VU','VUT',1), (228,'Vatican City State (Holy See)','VA','VAT',1); INSERT INTO `countries` (`countries_id`,`countries_name`,`countries_iso_code_2`,`countries_iso_code_3`,`address_format_id`) VALUES (229,'Venezuela','VE','VEN',1), (230,'Viet Nam','VN','VNM',1), (231,'Virgin Islands (British)','VG','VGB',1), (232,'Virgin Islands (U.S.)','VI','VIR',1), (233,'Wallis and Futuna Islands','WF','WLF',1), (234,'Western Sahara','EH','ESH',1), (235,'Yemen','YE','YEM',1), (236,'Yugoslavia','YU','YUG',1), (237,'Zaire','ZR','ZAR',1), (238,'Zambia','ZM','ZMB',1), (239,'Zimbabwe','ZW','ZWE',1), (240,'Albania','22','222',1); /*!40000 ALTER TABLE `countries` ENABLE KEYS */; -- -- Definition of table `currencies` -- DROP TABLE IF EXISTS `currencies`; CREATE TABLE `currencies` ( `currencies_id` int(11) NOT NULL auto_increment, `title` varchar(32) NOT NULL, `code` char(3) NOT NULL, `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) unsigned zerofill default '0000.00000000', `last_updated` datetime default NULL, PRIMARY KEY (`currencies_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `currencies` -- /*!40000 ALTER TABLE `currencies` DISABLE KEYS */; INSERT INTO `currencies` (`currencies_id`,`title`,`code`,`symbol_left`,`symbol_right`,`decimal_point`,`thousands_point`,`decimal_places`,`value`,`last_updated`) VALUES (1,'US Dollar','USD','$','','.',',','2',0000.64410001,'2008-06-20 16:55:32'), (2,'Euro','EUR','','EUR','.',',','2',0001.55260003,'2008-06-20 16:47:34'), (3,'Lev','BGN','','lv','.',',','2',0000.79329997,'2007-12-20 20:35:56'); /*!40000 ALTER TABLE `currencies` ENABLE KEYS */; -- -- Definition of table `customers` -- DROP TABLE IF EXISTS `customers`; CREATE TABLE `customers` ( `customers_id` int(11) NOT NULL auto_increment, `customers_gender` char(1) NOT NULL, `customers_firstname` varchar(32) NOT NULL, `customers_lastname` varchar(32) NOT NULL, `customers_dob` datetime NOT NULL default '0000-00-00 00:00:00', `customers_email_address` varchar(96) NOT NULL, `customers_default_address_id` int(11) default NULL, `customers_telephone` varchar(32) NOT NULL, `customers_fax` varchar(32) default NULL, `customers_password` varchar(40) NOT NULL, `customers_newsletter` tinyint(1) default NULL, PRIMARY KEY (`customers_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `customers` -- /*!40000 ALTER TABLE `customers` DISABLE KEYS */; INSERT INTO `customers` (`customers_id`,`customers_gender`,`customers_firstname`,`customers_lastname`,`customers_dob`,`customers_email_address`,`customers_default_address_id`,`customers_telephone`,`customers_fax`,`customers_password`,`customers_newsletter`) VALUES (1,'m','John','Doe','1996-05-03 00:00:00','facecart@dnd-bg.com',1,'12345','','d95e8fa7f20a009372eb3477473fcd34:1c',0), (7,'m','Georgy','Zekov','1982-03-02 00:00:00','mail_a_petrov@abv.bg',36,'9883210','9883210','tESsBmE/yNY3lb6a0L6vVQEZNqw=',0), (12,'m','ivan','ivanov','1997-04-30 00:00:00','ivan@ivanov.com',9,'1000','','cRDtpNCeBiql5KOQsKVyrA0sAiA=',0), (33,'m','Dimitar','Dimitrov','1999-05-10 00:00:00','mitko@dnd-bg.com',19,'12312345','1231234','cojt0Pw//L6ToM8G41aOKFIWh7w=',0), (34,'m','realp','realp','2004-04-04 00:00:00','realp@dir.bg',NULL,'23424','','8Q4oIbu+pSfqAiADUjE7wFlEUZA=',0), (37,'m','Arnold','Swartzeneger','1976-12-02 00:00:00','arnold@gmail.com',NULL,'988310','9883210','qUqP5cyxm6YcTAhz05Hph5gvu9M=',1), (43,'m','Pesho','Peshev','1998-04-03 00:00:00','pesho@abv.bg',25,'9883210','','2M24TXAWyO+F1lpOMToc0qbu8cI=',0); INSERT INTO `customers` (`customers_id`,`customers_gender`,`customers_firstname`,`customers_lastname`,`customers_dob`,`customers_email_address`,`customers_default_address_id`,`customers_telephone`,`customers_fax`,`customers_password`,`customers_newsletter`) VALUES (44,'m','Pesho2','Pesho2','2005-03-02 00:00:00','pesho2@abv.bg',26,'9883210','','2M24TXAWyO+F1lpOMToc0qbu8cI=',0), (45,'m','Shalinder','Mahindru','1983-06-04 00:00:00','shalinder.mahindru@headstrong.com',50,'9899020988','','wLE3/i15JFnyb/djzORFdKW1qwM=',0), (46,'f','foo','bar','1980-04-07 00:00:00','foobar@gmail.com',51,'6048567894','','jmm4ZrBX0pUBHYJp61WwMzA5B1o=',1), (47,'m','Star','Gruhtar','1977-02-01 00:00:00','stargruh@hotmail.com',52,'+359 2 981 981','','HZbkIGvqeCrCRsVvWpb/ihxqBs8=',0), (48,'m','Daniel','Cohen','2006-02-28 00:00:00','mm@mm.com',53,'132 456 6456','','fCIvspJ9goryL1khNOiTJIBjfA0=',0), (49,'m','Purna','Budaya','1980-07-10 00:00:00','purna.budaya@gmail.com',54,'7446003','','flC4oCGFmj+0J3iho3qOt0v9z2I=',1), (50,'m','test','cust','1990-12-31 00:00:00','test@test.com',55,'911','','qUqP5cyxm6YcTAhz05Hph5gvu9M=',0); INSERT INTO `customers` (`customers_id`,`customers_gender`,`customers_firstname`,`customers_lastname`,`customers_dob`,`customers_email_address`,`customers_default_address_id`,`customers_telephone`,`customers_fax`,`customers_password`,`customers_newsletter`) VALUES (51,'m','Seth','Kirby','1989-06-09 00:00:00','a@aol.com',56,'234567890','','96niR3fsIyEsVNejULxb6lR3/bs=',0), (52,'m','pete','rose','1984-02-01 00:00:00','pepe@home.com',57,'0232 122 4565','','XShC9ea+CRYkF7B8iVObV6S0txc=',0), (53,'f','xcxcv','xcvxcv','1944-03-01 00:00:00','xxx@s.com',58,'343634345345','34534535345','jLIjfQZ5yojbZGTqxg2pY0VROWQ=',0), (54,'m','test','test','1954-05-02 00:00:00','poppatest@pop.com',59,'727-777-2222','','qUqP5cyxm6YcTAhz05Hph5gvu9M=',0), (55,'m','asd','asd','2008-01-01 00:00:00','apkah@vip.bg',60,'088888888888','','vjH3phPTFkNkBwc27ZHR6paUxrk=',0), (56,'f','test','test','1979-12-31 00:00:00','info@godmosthigh.com',61,'0000000000','','c8UeFtVQ2oY6CMoTHyHVKYKIF5Q=',0), (57,'m','test','test','2006-03-02 00:00:00','test@test.cc',62,'121212','12121212','fEqNCco3Yq9h5ZUglD3CZJT4lBs=',0), (58,'m','jan','kowalski','2001-06-05 00:00:00','maitreya1@wp.pl',63,'442143475','','VAVzdxXKaT8F11mO00apMGcTNnM=',0); INSERT INTO `customers` (`customers_id`,`customers_gender`,`customers_firstname`,`customers_lastname`,`customers_dob`,`customers_email_address`,`customers_default_address_id`,`customers_telephone`,`customers_fax`,`customers_password`,`customers_newsletter`) VALUES (59,'m','test','test','1982-01-31 00:00:00','test@test.com',64,'11111','11111','qUqP5cyxm6YcTAhz05Hph5gvu9M=',0); /*!40000 ALTER TABLE `customers` ENABLE KEYS */; -- -- Definition of table `customers_basket` -- DROP TABLE IF EXISTS `customers_basket`; CREATE TABLE `customers_basket` ( `customers_basket_id` int(11) NOT NULL auto_increment, `customers_id` int(11) NOT NULL, `products_id` tinytext NOT NULL, `customers_basket_quantity` int(2) NOT NULL, `final_price` decimal(15,4) default NULL, `customers_basket_date_added` char(8) default NULL, `basket_attributes_id` int(10) unsigned default NULL, PRIMARY KEY (`customers_basket_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `customers_basket` -- /*!40000 ALTER TABLE `customers_basket` DISABLE KEYS */; /*!40000 ALTER TABLE `customers_basket` ENABLE KEYS */; -- -- Definition of table `customers_basket_attributes` -- DROP TABLE IF EXISTS `customers_basket_attributes`; CREATE TABLE `customers_basket_attributes` ( `customers_basket_attributes_id` int(11) NOT NULL auto_increment, `customers_id` int(11) NOT NULL, `products_id` tinytext NOT NULL, `products_options_id` int(11) NOT NULL, `products_options_value_id` int(11) NOT NULL, PRIMARY KEY (`customers_basket_attributes_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `customers_basket_attributes` -- /*!40000 ALTER TABLE `customers_basket_attributes` DISABLE KEYS */; /*!40000 ALTER TABLE `customers_basket_attributes` ENABLE KEYS */; -- -- Definition of table `customers_info` -- DROP TABLE IF EXISTS `customers_info`; CREATE TABLE `customers_info` ( `customers_info_id` int(11) NOT NULL, `customers_info_date_of_last_logon` datetime default NULL, `customers_info_number_of_logons` int(5) NOT NULL default '0', `customers_info_date_account_created` datetime default NULL, `customers_info_date_account_last_modified` datetime default NULL, `global_product_notifications` tinyint(1) NOT NULL default '0', PRIMARY KEY (`customers_info_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `customers_info` -- /*!40000 ALTER TABLE `customers_info` DISABLE KEYS */; INSERT INTO `customers_info` (`customers_info_id`,`customers_info_date_of_last_logon`,`customers_info_number_of_logons`,`customers_info_date_account_created`,`customers_info_date_account_last_modified`,`global_product_notifications`) VALUES (1,NULL,0,'2007-04-05 17:40:12','2007-12-19 13:34:21',0), (7,'2007-12-22 15:44:45',463,'2007-05-05 00:00:00','2007-09-30 20:19:11',0), (12,NULL,0,NULL,NULL,0), (33,'2007-09-06 17:46:05',57,'2007-08-15 17:19:23','2008-02-04 13:50:01',1), (34,NULL,0,'2007-09-18 12:36:25',NULL,0), (37,NULL,0,'2007-10-02 12:56:53',NULL,1), (39,NULL,0,'2007-10-02 13:13:00',NULL,1), (43,'2007-10-19 21:29:31',4,'2007-10-19 20:39:57','2008-02-20 17:01:44',0), (44,'2007-10-19 21:12:44',4,'2007-10-19 20:50:10',NULL,0), (45,'2007-12-20 16:24:10',1,'2007-12-20 16:24:10',NULL,0), (46,'2007-12-20 19:26:29',1,'2007-12-20 19:26:29',NULL,1), (47,'2008-02-04 14:05:10',1,'2008-02-04 14:05:10',NULL,0), (48,'2008-02-10 15:26:49',3,'2008-02-04 19:51:42','2008-02-04 19:53:02',0), (49,'2008-02-08 02:47:14',1,'2008-02-08 02:47:14',NULL,1); INSERT INTO `customers_info` (`customers_info_id`,`customers_info_date_of_last_logon`,`customers_info_number_of_logons`,`customers_info_date_account_created`,`customers_info_date_account_last_modified`,`global_product_notifications`) VALUES (50,'2008-02-08 11:07:16',1,'2008-02-08 11:07:16',NULL,0), (51,'2008-02-13 02:26:41',1,'2008-02-13 02:26:41',NULL,0), (52,'2008-02-13 06:20:09',1,'2008-02-13 06:20:09',NULL,0), (53,'2008-02-14 14:45:50',1,'2008-02-14 14:45:50',NULL,0), (54,'2008-02-14 19:05:11',1,'2008-02-14 19:05:10',NULL,0), (55,'2008-02-18 14:02:27',1,'2008-02-18 14:02:27',NULL,0), (56,'2008-02-19 23:37:37',1,'2008-02-19 23:37:37',NULL,0), (57,'2008-02-21 17:48:57',1,'2008-02-21 17:48:57',NULL,0), (58,'2008-02-23 23:28:21',1,'2008-02-23 23:28:21',NULL,0), (59,NULL,0,'2008-03-11 14:57:49',NULL,0); /*!40000 ALTER TABLE `customers_info` ENABLE KEYS */; -- -- Definition of table `geo_zones` -- DROP TABLE IF EXISTS `geo_zones`; CREATE TABLE `geo_zones` ( `geo_zone_id` int(11) NOT NULL auto_increment, `geo_zone_name` varchar(32) NOT NULL, `geo_zone_description` varchar(255) NOT NULL, `last_modified` datetime default NULL, `date_added` datetime NOT NULL, PRIMARY KEY (`geo_zone_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `geo_zones` -- /*!40000 ALTER TABLE `geo_zones` DISABLE KEYS */; INSERT INTO `geo_zones` (`geo_zone_id`,`geo_zone_name`,`geo_zone_description`,`last_modified`,`date_added`) VALUES (1,'Florida','Florida local sales tax zone','2007-05-12 18:01:38','2007-04-05 17:40:13'), (2,'%18 KDV','',NULL,'2008-03-19 13:03:14'), (3,'%8 KDV','',NULL,'2008-03-19 13:03:24'), (4,'%1 KDV','',NULL,'2008-03-19 13:03:40'); /*!40000 ALTER TABLE `geo_zones` ENABLE KEYS */; -- -- Definition of table `languages` -- DROP TABLE IF EXISTS `languages`; CREATE TABLE `languages` ( `languages_id` int(11) NOT NULL auto_increment, `name` varchar(32) NOT NULL, `code` char(2) NOT NULL, `image` varchar(64) default NULL, `directory` varchar(32) default NULL, `sort_order` int(3) default NULL, PRIMARY KEY (`languages_id`), KEY `IDX_LANGUAGES_NAME` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `languages` -- /*!40000 ALTER TABLE `languages` DISABLE KEYS */; INSERT INTO `languages` (`languages_id`,`name`,`code`,`image`,`directory`,`sort_order`) VALUES (1,'English','en','icon.gif','english',0), (2,'bulgarian','bg','icon.gif','bulgarian',1); /*!40000 ALTER TABLE `languages` ENABLE KEYS */; -- -- Definition of table `manufacturers` -- DROP TABLE IF EXISTS `manufacturers`; CREATE TABLE `manufacturers` ( `manufacturers_id` int(11) NOT NULL auto_increment, `manufacturers_name` varchar(32) NOT NULL, `manufacturers_image` varchar(64) default NULL, `date_added` datetime default NULL, `last_modified` datetime default NULL, PRIMARY KEY (`manufacturers_id`), KEY `IDX_MANUFACTURERS_NAME` (`manufacturers_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `manufacturers` -- /*!40000 ALTER TABLE `manufacturers` DISABLE KEYS */; INSERT INTO `manufacturers` (`manufacturers_id`,`manufacturers_name`,`manufacturers_image`,`date_added`,`last_modified`) VALUES (1,'Matrox','matrox/manufacturer_matrox.gif','2007-04-05 17:40:12',NULL), (2,'Microsoft','microsoft/manufacturer_microsoft.gif','2007-04-05 17:40:12',NULL), (3,'Warner','warner/manufacturer_warner.gif','2007-04-05 17:40:12',NULL), (4,'Fox','fox/manufacturer_fox.gif','2007-04-05 17:40:12','2007-07-29 20:55:34'), (5,'Logitech','logitech/manufacturer_logitech.gif','2007-04-05 17:40:12','2007-07-29 21:12:52'), (6,'Canon','canon/manufacturer_canon.gif','2007-04-05 17:40:12','2007-05-12 15:21:11'), (7,'Sierra','sierra/manufacturer_sierra.gif','2007-04-05 17:40:12','2007-05-05 19:25:23'), (8,'GT Interactive','gt_interactive/manufacturer_gt_interactive.gif','2007-04-05 17:40:12','2007-07-29 19:41:52'), (9,'Hewlett Packard','hewlett_packard/manufacturer_hewlett_packard.gif','2007-04-05 17:40:12','2007-05-05 19:25:01'); /*!40000 ALTER TABLE `manufacturers` ENABLE KEYS */; -- -- Definition of table `manufacturers_info` -- DROP TABLE IF EXISTS `manufacturers_info`; CREATE TABLE `manufacturers_info` ( `manufacturers_id` int(11) NOT NULL, `languages_id` int(11) NOT NULL, `manufacturers_url` varchar(255) NOT NULL, `url_clicked` int(5) NOT NULL default '0', `date_last_click` datetime default NULL, PRIMARY KEY (`manufacturers_id`,`languages_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `manufacturers_info` -- /*!40000 ALTER TABLE `manufacturers_info` DISABLE KEYS */; INSERT INTO `manufacturers_info` (`manufacturers_id`,`languages_id`,`manufacturers_url`,`url_clicked`,`date_last_click`) VALUES (1,1,'http://www.matrox.com',0,NULL), (1,2,'http://www.matrox.com',0,NULL), (2,1,'http://www.microsoft.com',0,NULL), (2,2,'http://www.microsoft.com',0,NULL), (3,1,'http://www.warner.com',0,NULL), (3,2,'http://www.warner.com',0,NULL), (4,1,'http://www.fox.com',0,NULL), (4,2,'http://www.fox.com',0,NULL), (5,1,'http://www.logitech.com',0,NULL), (5,2,'http://www.logitech.com',0,NULL), (6,1,'http://www.canon.com',0,NULL), (6,2,'http://www.canon.com',0,NULL), (7,1,'http://www.sierra.com',0,NULL), (7,2,'http://www.sierra.com',0,NULL), (8,1,'http://www.infogrames.com',0,NULL), (8,2,'http://www.infogrames.com',0,NULL), (9,1,'http://www.hewlettpackard.com',0,NULL), (9,2,'http://www.hewlettpackard.com',0,NULL); /*!40000 ALTER TABLE `manufacturers_info` ENABLE KEYS */; -- -- Definition of table `newsletters` -- DROP TABLE IF EXISTS `newsletters`; CREATE TABLE `newsletters` ( `newsletters_id` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL, `content` text NOT NULL, `module` varchar(255) NOT NULL, `date_added` datetime NOT NULL, `date_sent` datetime default NULL, `status` int(1) default NULL, `locked` int(1) default '0', PRIMARY KEY (`newsletters_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `newsletters` -- /*!40000 ALTER TABLE `newsletters` DISABLE KEYS */; /*!40000 ALTER TABLE `newsletters` ENABLE KEYS */; -- -- Definition of table `orders` -- DROP TABLE IF EXISTS `orders`; CREATE TABLE `orders` ( `orders_id` int(11) NOT NULL auto_increment, `customers_id` int(11) NOT NULL, `customers_name` varchar(64) NOT NULL, `customers_company` varchar(32) default NULL, `customers_street_address` varchar(64) NOT NULL, `customers_suburb` varchar(32) default NULL, `customers_city` varchar(32) NOT NULL, `customers_postcode` varchar(10) NOT NULL, `customers_state` varchar(32) default NULL, `customers_country` varchar(32) NOT NULL, `customers_telephone` varchar(32) NOT NULL, `customers_email_address` varchar(96) NOT NULL, `customers_address_format_id` int(5) NOT NULL, `delivery_name` varchar(64) NOT NULL, `delivery_company` varchar(32) default NULL, `delivery_street_address` varchar(64) NOT NULL, `delivery_suburb` varchar(32) default NULL, `delivery_city` varchar(32) NOT NULL, `delivery_postcode` varchar(10) NOT NULL, `delivery_state` varchar(32) default NULL, `delivery_country` varchar(32) NOT NULL, `delivery_address_format_id` int(5) NOT NULL, `billing_name` varchar(64) NOT NULL, `billing_company` varchar(32) default NULL, `billing_street_address` varchar(64) NOT NULL, `billing_suburb` varchar(32) default NULL, `billing_city` varchar(32) NOT NULL, `billing_postcode` varchar(10) NOT NULL, `billing_state` varchar(32) default NULL, `billing_country` varchar(32) NOT NULL, `billing_address_format_id` int(5) NOT NULL, `payment_method` varchar(32) NOT NULL, `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, `orders_date_finished` datetime default NULL, `currency` char(3) default NULL, `currency_value` decimal(14,6) default NULL, PRIMARY KEY (`orders_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `orders` -- /*!40000 ALTER TABLE `orders` DISABLE KEYS */; INSERT INTO `orders` (`orders_id`,`customers_id`,`customers_name`,`customers_company`,`customers_street_address`,`customers_suburb`,`customers_city`,`customers_postcode`,`customers_state`,`customers_country`,`customers_telephone`,`customers_email_address`,`customers_address_format_id`,`delivery_name`,`delivery_company`,`delivery_street_address`,`delivery_suburb`,`delivery_city`,`delivery_postcode`,`delivery_state`,`delivery_country`,`delivery_address_format_id`,`billing_name`,`billing_company`,`billing_street_address`,`billing_suburb`,`billing_city`,`billing_postcode`,`billing_state`,`billing_country`,`billing_address_format_id`,`payment_method`,`cc_type`,`cc_owner`,`cc_number`,`cc_expires`,`last_modified`,`date_purchased`,`orders_status`,`orders_date_finished`,`currency`,`currency_value`) VALUES (1,7,'Alexander Petrov','Unicoders','Rakovski 157A','','Sofia','1000','Florida','United States','9883210','mail_a_petrov@abv.bg',1,'Alexander Petrov','Unicoders','Rakovski 157A','','Sofia','1000','Florida','United States',1,'Alexander Petrov','Unicoders','Rakovski 157A','','Sofia','1000','Florida','United States',1,'cash on delivery',NULL,NULL,NULL,NULL,NULL,'2007-09-30 20:28:47',3,NULL,'USD','1.000000'), (4,7,'Alexander Petrov','Unicoders','Rakovski 157A','','Sofia','1000','Florida','United States','9883210','mail_a_petrov@abv.bg',1,'Rosiza Kirilova','Unicoders','Rakovska 157A',NULL,'Sofia123','1000','Arizona','United States',1,'Alexander Petrov','Unicoders','Rakovski 157A','','Sofia','1000','Florida','United States',1,'cash on delivery',NULL,NULL,NULL,NULL,NULL,'2007-10-02 18:09:36',3,NULL,'USD','1.000000'); INSERT INTO `orders` (`orders_id`,`customers_id`,`customers_name`,`customers_company`,`customers_street_address`,`customers_suburb`,`customers_city`,`customers_postcode`,`customers_state`,`customers_country`,`customers_telephone`,`customers_email_address`,`customers_address_format_id`,`delivery_name`,`delivery_company`,`delivery_street_address`,`delivery_suburb`,`delivery_city`,`delivery_postcode`,`delivery_state`,`delivery_country`,`delivery_address_format_id`,`billing_name`,`billing_company`,`billing_street_address`,`billing_suburb`,`billing_city`,`billing_postcode`,`billing_state`,`billing_country`,`billing_address_format_id`,`payment_method`,`cc_type`,`cc_owner`,`cc_number`,`cc_expires`,`last_modified`,`date_purchased`,`orders_status`,`orders_date_finished`,`currency`,`currency_value`) VALUES (5,7,'Alexander Petrov','Unicoders','Rakovski 157A','','Sofia','1000','Florida','United States','9883210','mail_a_petrov@abv.bg',1,'Alexander Petrov','Unicoders','Rakovski 157A','','Sofia','1000','Florida','United States',1,'Alexander Petrov','Unicoders','Rakovski 157A','','Sofia','1000','Florida','United States',1,'cash on delivery',NULL,NULL,NULL,NULL,NULL,'2007-10-02 18:10:21',3,NULL,'USD','1.000000'), (6,7,'Alexander Petrov','Unicoders','Rakovski 157A','','Sofia','1000','Florida','United States','9883210','mail_a_petrov@abv.bg',1,'Alexander Petrov','Unicoders','Rakovski 157A','','Sofia','1000','Florida','United States',1,'Alexander Petrov','Unicoders','Rakovski 157A','','Sofia','1000','Florida','United States',1,'cash on delivery',NULL,NULL,NULL,NULL,NULL,'2007-10-03 03:24:55',3,NULL,'USD','1.000000'); INSERT INTO `orders` (`orders_id`,`customers_id`,`customers_name`,`customers_company`,`customers_street_address`,`customers_suburb`,`customers_city`,`customers_postcode`,`customers_state`,`customers_country`,`customers_telephone`,`customers_email_address`,`customers_address_format_id`,`delivery_name`,`delivery_company`,`delivery_street_address`,`delivery_suburb`,`delivery_city`,`delivery_postcode`,`delivery_state`,`delivery_country`,`delivery_address_format_id`,`billing_name`,`billing_company`,`billing_street_address`,`billing_suburb`,`billing_city`,`billing_postcode`,`billing_state`,`billing_country`,`billing_address_format_id`,`payment_method`,`cc_type`,`cc_owner`,`cc_number`,`cc_expires`,`last_modified`,`date_purchased`,`orders_status`,`orders_date_finished`,`currency`,`currency_value`) VALUES (7,7,'Alexander Petrov','Unicoders','Rakovski 157A','','Sofia','1000','Florida','United States','9883210','mail_a_petrov@abv.bg',1,'Alexander Petrov','Unicoders','Rakovski 157A','','Sofia','1000','Florida','United States',1,'Alexander Petrov','Unicoders','Rakovski 157A','','Sofia','1000','Florida','United States',1,'cash on delivery',NULL,NULL,NULL,NULL,NULL,'2007-10-03 03:34:56',3,NULL,'USD','1.000000'), (8,7,'Alexander Petrov','Unicoders','Rakovski 157A','','Sofia','1000','Florida','United States','9883210','mail_a_petrov@abv.bg',1,'Alexander Petrov','Unicoders','Rakovski 157A','','Sofia','1000','Florida','United States',1,'Alexander Petrov','Unicoders','Rakovski 157A','','Sofia','1000','Florida','United States',1,'cash on delivery',NULL,NULL,NULL,NULL,NULL,'2007-10-03 03:42:43',3,NULL,'USD','1.000000'); INSERT INTO `orders` (`orders_id`,`customers_id`,`customers_name`,`customers_company`,`customers_street_address`,`customers_suburb`,`customers_city`,`customers_postcode`,`customers_state`,`customers_country`,`customers_telephone`,`customers_email_address`,`customers_address_format_id`,`delivery_name`,`delivery_company`,`delivery_street_address`,`delivery_suburb`,`delivery_city`,`delivery_postcode`,`delivery_state`,`delivery_country`,`delivery_address_format_id`,`billing_name`,`billing_company`,`billing_street_address`,`billing_suburb`,`billing_city`,`billing_postcode`,`billing_state`,`billing_country`,`billing_address_format_id`,`payment_method`,`cc_type`,`cc_owner`,`cc_number`,`cc_expires`,`last_modified`,`date_purchased`,`orders_status`,`orders_date_finished`,`currency`,`currency_value`) VALUES (10,7,'Alexander Petrov','Unicoders','Rakovski 157A','','Sofia','1000','Florida','United States','9883210','mail_a_petrov@abv.bg',1,'Georgi Mihailov','unicoders','rakovska',NULL,'Sofia','1000','Sofia','Bulgaria',1,'Alexander Petrov','Unicoders','Rakovski 157A','','Sofia','1000','Florida','United States',1,'cash on delivery',NULL,NULL,NULL,NULL,NULL,'2007-10-04 13:24:18',3,NULL,'USD','1.000000'), (11,7,'Alexander Petrov','Unicoders','Rakovski 157A','','Sofia','1000','Florida','United States','9883210','mail_a_petrov@abv.bg',1,'Rosiza Kirilova','Unicoders','Rakovska 157A',NULL,'Sofia123','1000','Arizona','United States',1,'Alexander Petrov','Unicoders','Rakovski 157A','','Sofia','1000','Florida','United States',1,'cash on delivery',NULL,NULL,NULL,NULL,NULL,'2007-10-04 22:06:53',3,NULL,'USD','1.000000'); INSERT INTO `orders` (`orders_id`,`customers_id`,`customers_name`,`customers_company`,`customers_street_address`,`customers_suburb`,`customers_city`,`customers_postcode`,`customers_state`,`customers_country`,`customers_telephone`,`customers_email_address`,`customers_address_format_id`,`delivery_name`,`delivery_company`,`delivery_street_address`,`delivery_suburb`,`delivery_city`,`delivery_postcode`,`delivery_state`,`delivery_country`,`delivery_address_format_id`,`billing_name`,`billing_company`,`billing_street_address`,`billing_suburb`,`billing_city`,`billing_postcode`,`billing_state`,`billing_country`,`billing_address_format_id`,`payment_method`,`cc_type`,`cc_owner`,`cc_number`,`cc_expires`,`last_modified`,`date_purchased`,`orders_status`,`orders_date_finished`,`currency`,`currency_value`) VALUES (12,7,'Alexander Petrov','Unicoders','Rakovski 157A','','Sofia','1000','Florida','United States','9883210','mail_a_petrov@abv.bg',1,'Rosiza Kirilova','Unicoders','Rakovska 157A',NULL,'Sofia123','1000','Arizona','United States',1,'Alexander Petrov','Unicoders','Rakovski 157A','','Sofia','1000','Florida','United States',1,'cash on delivery',NULL,NULL,NULL,NULL,NULL,'2007-10-04 22:27:59',3,NULL,'USD','1.000000'), (13,7,'Georgy Zekov','unicoder','test','melnik','test','test','arizona','United States','9883210','mail_a_petrov@abv.bg',1,'Alexander Petrov','unicoders','Rakovska157A','','Sofia','1000','Arizona','United States',1,'Georgy Zekov','unicoder','test','melnik','test','test','arizona','United States',1,'cash on delivery',NULL,NULL,NULL,NULL,NULL,'2007-11-30 12:47:40',3,NULL,'USD','1.000000'); INSERT INTO `orders` (`orders_id`,`customers_id`,`customers_name`,`customers_company`,`customers_street_address`,`customers_suburb`,`customers_city`,`customers_postcode`,`customers_state`,`customers_country`,`customers_telephone`,`customers_email_address`,`customers_address_format_id`,`delivery_name`,`delivery_company`,`delivery_street_address`,`delivery_suburb`,`delivery_city`,`delivery_postcode`,`delivery_state`,`delivery_country`,`delivery_address_format_id`,`billing_name`,`billing_company`,`billing_street_address`,`billing_suburb`,`billing_city`,`billing_postcode`,`billing_state`,`billing_country`,`billing_address_format_id`,`payment_method`,`cc_type`,`cc_owner`,`cc_number`,`cc_expires`,`last_modified`,`date_purchased`,`orders_status`,`orders_date_finished`,`currency`,`currency_value`) VALUES (14,45,'Shalinder Mahindru','','I - 3 Lajpat Nagar - 2','','Delhi','1100','Delhi','India','9899020988','shalinder.mahindru@headstrong.com',1,'Shalinder Mahindru','','I - 3 Lajpat Nagar - 2','','Delhi','1100','Delhi','India',1,'Shalinder Mahindru','','I - 3 Lajpat Nagar - 2','','Delhi','1100','Delhi','India',1,'cash on delivery',NULL,NULL,NULL,NULL,NULL,'2007-12-20 16:36:38',3,NULL,'USD','1.000000'), (15,7,'Georgy Zekov','unicoder','test','melnik','test','test','arizona','United States','9883210','mail_a_petrov@abv.bg',1,'Georgy Zekov','unicoder','test','melnik','test','test','arizona','United States',1,'Georgy Zekov','unicoder','test','melnik','test','test','arizona','United States',1,'cash on delivery',NULL,NULL,NULL,NULL,NULL,'2007-12-20 17:56:24',3,NULL,'EUR','1.440030'); INSERT INTO `orders` (`orders_id`,`customers_id`,`customers_name`,`customers_company`,`customers_street_address`,`customers_suburb`,`customers_city`,`customers_postcode`,`customers_state`,`customers_country`,`customers_telephone`,`customers_email_address`,`customers_address_format_id`,`delivery_name`,`delivery_company`,`delivery_street_address`,`delivery_suburb`,`delivery_city`,`delivery_postcode`,`delivery_state`,`delivery_country`,`delivery_address_format_id`,`billing_name`,`billing_company`,`billing_street_address`,`billing_suburb`,`billing_city`,`billing_postcode`,`billing_state`,`billing_country`,`billing_address_format_id`,`payment_method`,`cc_type`,`cc_owner`,`cc_number`,`cc_expires`,`last_modified`,`date_purchased`,`orders_status`,`orders_date_finished`,`currency`,`currency_value`) VALUES (16,49,'Purna Budaya','','Soka Sati Restaurant','','Denpasar','80361','Bali','Indonesia','7446003','purna.budaya@gmail.com',1,'Purna Budaya','','Soka Sati Restaurant','','Denpasar','80361','Bali','Indonesia',1,'Purna Budaya','','Soka Sati Restaurant','','Denpasar','80361','Bali','Indonesia',1,'cash on delivery',NULL,NULL,NULL,NULL,NULL,'2008-02-08 02:49:08',3,NULL,'SP','1.000000'), (17,50,'test cust','','testst.','','Austin','78749','Texas','United States','911','test@test.com',1,'test cust','','testst.','','Austin','78749','Texas','United States',1,'test cust','','testst.','','Austin','78749','Texas','United States',1,'cash on delivery',NULL,NULL,NULL,NULL,NULL,'2008-02-08 11:10:23',3,NULL,'SP','1.000000'); INSERT INTO `orders` (`orders_id`,`customers_id`,`customers_name`,`customers_company`,`customers_street_address`,`customers_suburb`,`customers_city`,`customers_postcode`,`customers_state`,`customers_country`,`customers_telephone`,`customers_email_address`,`customers_address_format_id`,`delivery_name`,`delivery_company`,`delivery_street_address`,`delivery_suburb`,`delivery_city`,`delivery_postcode`,`delivery_state`,`delivery_country`,`delivery_address_format_id`,`billing_name`,`billing_company`,`billing_street_address`,`billing_suburb`,`billing_city`,`billing_postcode`,`billing_state`,`billing_country`,`billing_address_format_id`,`payment_method`,`cc_type`,`cc_owner`,`cc_number`,`cc_expires`,`last_modified`,`date_purchased`,`orders_status`,`orders_date_finished`,`currency`,`currency_value`) VALUES (18,51,'Seth Kirby','','asdasdf','','Muncie','77777','Indiana','United States','234567890','a@aol.com',1,'Seth Kirby','','asdasdf','','Muncie','77777','Indiana','United States',1,'Seth Kirby','','asdasdf','','Muncie','77777','Indiana','United States',1,'cash on delivery',NULL,NULL,NULL,NULL,NULL,'2008-02-13 02:28:07',3,NULL,'USD','1.000000'), (19,55,'asd asd','None','None ','','sofia','1521','sofia','Bulgaria','088888888888','apkah@vip.bg',1,'asd asd','None','None ','','sofia','1521','sofia','Bulgaria',1,'asd asd','None','None ','','sofia','1521','sofia','Bulgaria',1,'cash on delivery',NULL,NULL,NULL,NULL,NULL,'2008-02-18 14:06:00',3,NULL,'USD','1.000000'); /*!40000 ALTER TABLE `orders` ENABLE KEYS */; -- -- Definition of table `orders_products` -- DROP TABLE IF EXISTS `orders_products`; CREATE TABLE `orders_products` ( `orders_products_id` int(11) NOT NULL auto_increment, `orders_id` int(11) NOT NULL, `products_id` int(11) NOT NULL, `products_model` varchar(12) default NULL, `products_name` varchar(64) NOT NULL, `products_price` decimal(15,4) NOT NULL, `final_price` decimal(15,4) NOT NULL, `products_tax` decimal(7,4) NOT NULL, `products_quantity` int(2) NOT NULL, PRIMARY KEY (`orders_products_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `orders_products` -- /*!40000 ALTER TABLE `orders_products` DISABLE KEYS */; INSERT INTO `orders_products` (`orders_products_id`,`orders_id`,`products_id`,`products_model`,`products_name`,`products_price`,`final_price`,`products_tax`,`products_quantity`) VALUES (1,1,19,'DVD-TSAB','There is something about mary','49.9900','49.9900','18.7700',1), (2,1,2,'MG400-32MB','Matrox','499.9900','489.9900','18.7700',4), (5,4,19,'DVD-TSAB','There is something about mary','49.9900','49.9900','18.7700',1), (6,5,4,'DVD-RPMK','Replacement Killers','42.0000','42.0000','18.7700',1), (7,5,19,'DVD-TSAB','There is something about mary','49.9900','49.9900','18.7700',1), (8,6,12,'DVD-DHWV','Die Hard','39.9900','39.9900','18.7700',1), (9,7,7,'DVD-YGEM','You\'ve got mail','34.9900','34.9900','18.7700',1), (10,8,34,'lalaaa','test','10.0000','10.0000','18.7700',1), (12,10,4,'DVD-RPMK','Replacement Killers','42.0000','42.0000','18.7700',4), (13,11,3,'MSIMPRO','SWAT 3: Elite Edition','49.9900','39.9900','18.7700',1), (14,11,12,'DVD-DHWV','Die Hard','39.9900','39.9900','18.7700',1), (15,11,6,'DVD-MATR','The Matrix','39.9900','39.9900','18.7700',1); INSERT INTO `orders_products` (`orders_products_id`,`orders_id`,`products_id`,`products_model`,`products_name`,`products_price`,`final_price`,`products_tax`,`products_quantity`) VALUES (16,12,12,'DVD-DHWV','Die Hard','39.9900','39.9900','18.7700',10), (17,12,14,'DVD-REDC','Red Corner','32.0000','32.0000','18.7700',1), (18,13,3,'MSIMPRO','Интелигентна мишка ПРО','49.9900','39.9900','18.8770',1), (19,14,30,'PC-TWOF','The Wheel of Time','22.0000','22.0000','0.0000',1), (20,15,2,'MG400-32MB','Matrox G400 32MB','499.9900','609.9900','18.8770',4), (21,15,8,'DVD-ABUG','A Bug\'s Life','35.9900','35.9900','18.8770',3), (22,16,25,'MSINTKB','Microsoft Internet Keyboard PS/2','69.9900','69.9900','0.0000',10), (23,16,2,'MG400-32MB','Matrox G400 32MB','499.9900','489.9900','0.0000',10), (24,17,4,'DVD-RPMK','Replacement Killers','42.0000','42.0000','18.8770',1), (25,18,21,'PC-SWAT3','SWAT 3: Close Quarters Battle','80.0000','80.0000','18.8770',1), (26,19,15,'DVD-FRAN','Frantic','35.0000','35.0000','0.0000',1); /*!40000 ALTER TABLE `orders_products` ENABLE KEYS */; -- -- Definition of table `orders_products_attributes` -- DROP TABLE IF EXISTS `orders_products_attributes`; CREATE TABLE `orders_products_attributes` ( `orders_products_attributes_id` int(11) NOT NULL auto_increment, `orders_id` int(11) NOT NULL, `orders_products_id` int(11) NOT NULL, `products_options` varchar(32) NOT NULL, `products_options_values` varchar(32) NOT NULL, `options_values_price` decimal(15,4) NOT NULL, `price_prefix` char(1) NOT NULL, PRIMARY KEY (`orders_products_attributes_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `orders_products_attributes` -- /*!40000 ALTER TABLE `orders_products_attributes` DISABLE KEYS */; INSERT INTO `orders_products_attributes` (`orders_products_attributes_id`,`orders_id`,`orders_products_id`,`products_options`,`products_options_values`,`options_values_price`,`price_prefix`) VALUES (1,1,2,'Memory','16 mb','10.0000','-'), (2,1,2,'Model4','Premium','0.0000','+'), (3,15,20,'Memory','16 mb','10.0000','-'), (4,15,20,'Model','Deluxe','120.0000','+'), (5,16,23,'Memory','16 mb','10.0000','-'), (6,16,23,'Model','Premium','0.0000','+'); /*!40000 ALTER TABLE `orders_products_attributes` ENABLE KEYS */; -- -- Definition of table `orders_products_download` -- DROP TABLE IF EXISTS `orders_products_download`; CREATE TABLE `orders_products_download` ( `orders_products_download_id` int(11) NOT NULL auto_increment, `orders_id` int(11) NOT NULL default '0', `orders_products_id` int(11) NOT NULL default '0', `orders_products_filename` varchar(255) NOT NULL default '', `download_maxdays` int(2) NOT NULL default '0', `download_count` int(2) NOT NULL default '0', PRIMARY KEY (`orders_products_download_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `orders_products_download` -- /*!40000 ALTER TABLE `orders_products_download` DISABLE KEYS */; /*!40000 ALTER TABLE `orders_products_download` ENABLE KEYS */; -- -- Definition of table `orders_status` -- DROP TABLE IF EXISTS `orders_status`; CREATE TABLE `orders_status` ( `orders_status_id` int(11) NOT NULL default '0', `language_id` int(11) NOT NULL default '1', `orders_status_name` varchar(32) NOT NULL, PRIMARY KEY (`orders_status_id`,`language_id`), KEY `idx_orders_status_name` (`orders_status_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `orders_status` -- /*!40000 ALTER TABLE `orders_status` DISABLE KEYS */; INSERT INTO `orders_status` (`orders_status_id`,`language_id`,`orders_status_name`) VALUES (3,1,'Delivered'), (3,2,'Delivered'), (1,1,'Pending'), (1,2,'Pending'), (2,1,'Processing'), (2,2,'Processing'), (4,1,'someNew Status'), (4,2,'statusBul'); /*!40000 ALTER TABLE `orders_status` ENABLE KEYS */; -- -- Definition of table `orders_status_history` -- DROP TABLE IF EXISTS `orders_status_history`; CREATE TABLE `orders_status_history` ( `orders_status_history_id` int(11) NOT NULL auto_increment, `orders_id` int(11) NOT NULL, `orders_status_id` int(5) NOT NULL, `date_added` datetime NOT NULL, `customer_notified` tinyint(1) default '0', `comments` text, PRIMARY KEY (`orders_status_history_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `orders_status_history` -- /*!40000 ALTER TABLE `orders_status_history` DISABLE KEYS */; INSERT INTO `orders_status_history` (`orders_status_history_id`,`orders_id`,`orders_status_id`,`date_added`,`customer_notified`,`comments`) VALUES (1,1,3,'2007-09-30 20:28:47',1,NULL), (2,1,1,'2007-10-01 15:02:55',1,'helllo'), (3,1,2,'2007-10-01 15:03:04',0,''), (6,4,3,'2007-10-02 18:09:37',1,''), (7,5,3,'2007-10-02 18:10:22',1,NULL), (8,4,1,'2007-10-02 18:53:02',0,''), (9,6,3,'2007-10-03 03:24:55',1,NULL), (10,7,3,'2007-10-03 03:34:57',1,NULL), (11,8,3,'2007-10-03 03:42:43',1,NULL), (13,10,3,'2007-10-04 13:24:18',1,NULL), (14,11,3,'2007-10-04 22:06:53',1,NULL), (15,1,3,'2007-10-04 22:17:58',1,''), (16,12,3,'2007-10-04 22:27:59',1,NULL), (17,1,1,'2007-10-04 22:29:07',1,''), (18,1,2,'2007-10-05 09:03:24',1,''), (19,13,3,'2007-11-30 12:47:41',1,NULL), (20,14,3,'2007-12-20 16:36:38',1,NULL), (21,15,3,'2007-12-20 17:56:24',1,NULL), (22,16,3,'2008-02-08 02:49:09',1,NULL), (23,17,3,'2008-02-08 11:10:23',1,NULL), (24,18,3,'2008-02-13 02:28:07',1,NULL), (25,19,3,'2008-02-18 14:06:00',1,NULL); /*!40000 ALTER TABLE `orders_status_history` ENABLE KEYS */; -- -- Definition of table `orders_total` -- DROP TABLE IF EXISTS `orders_total`; CREATE TABLE `orders_total` ( `orders_total_id` int(10) unsigned NOT NULL auto_increment, `orders_id` int(11) NOT NULL, `title` varchar(255) NOT NULL, `text` varchar(255) NOT NULL, `value` decimal(15,4) NOT NULL, `class` varchar(75) NOT NULL, `sort_order` int(11) NOT NULL, PRIMARY KEY (`orders_total_id`), KEY `idx_orders_total_orders_id` (`orders_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `orders_total` -- /*!40000 ALTER TABLE `orders_total` DISABLE KEYS */; INSERT INTO `orders_total` (`orders_total_id`,`orders_id`,`title`,`text`,`value`,`class`,`sort_order`) VALUES (1,1,'Sub-Total','$2,009.95','2009.9500','com.facecart.ecm.ordertotals.SubTotal',0), (2,1,'Total:','$2,009.95','2009.9500','com.facecart.ecm.ordertotals.OrderTotal',0), (3,1,'Flat Rate','$5.94','5.9400','com.facecart.ecm.ordertotals.Shipping',0), (4,1,'tt + VAT ','$377.27','377.2700','com.facecart.ecm.ordertotals.OrderTotalTax',0), (13,4,'Flat Rate','$5.94','5.9400','com.facecart.ecm.ordertotals.Shipping',0), (14,4,'Sub-Total','$49.99','49.9900','com.facecart.ecm.ordertotals.SubTotal',0), (15,4,'VAT + tt ','$9.38','9.3800','com.facecart.ecm.ordertotals.OrderTotalTax',0), (16,4,'Total:','$49.99','49.9900','com.facecart.ecm.ordertotals.OrderTotal',0), (17,5,'Total:','$91.99','91.9900','com.facecart.ecm.ordertotals.OrderTotal',0), (18,5,'VAT + tt ','$17.27','17.2700','com.facecart.ecm.ordertotals.OrderTotalTax',0), (19,5,'Sub-Total','$91.99','91.9900','com.facecart.ecm.ordertotals.SubTotal',0), (20,5,'Flat Rate','$5.94','5.9400','com.facecart.ecm.ordertotals.Shipping',0); INSERT INTO `orders_total` (`orders_total_id`,`orders_id`,`title`,`text`,`value`,`class`,`sort_order`) VALUES (21,6,'Total:','$39.99','39.9900','com.facecart.ecm.ordertotals.OrderTotal',1), (22,6,'Sub-Total','$39.99','39.9900','com.facecart.ecm.ordertotals.SubTotal',0), (23,6,'Flat Rate','$5.94','5.9400','com.facecart.ecm.ordertotals.Shipping',0), (24,6,'VAT + tt ','$7.51','7.5100','com.facecart.ecm.ordertotals.OrderTotalTax',0), (25,7,'VAT + tt ','$6.57','6.5700','com.facecart.ecm.ordertotals.OrderTotalTax',0), (26,7,'Flat Rate','$5.94','5.9400','com.facecart.ecm.ordertotals.Shipping',0), (27,7,'Total:','$34.99','34.9900','com.facecart.ecm.ordertotals.OrderTotal',1), (28,7,'Sub-Total','$34.99','34.9900','com.facecart.ecm.ordertotals.SubTotal',0), (29,8,'Sub-Total','$10','10.0000','com.facecart.ecm.ordertotals.SubTotal',0), (30,8,'tt + VAT ','$1.88','1.8800','com.facecart.ecm.ordertotals.OrderTotalTax',0), (31,8,'Total:','$10','10.0000','com.facecart.ecm.ordertotals.OrderTotal',1), (32,8,'Flat Rate','$5.94','5.9400','com.facecart.ecm.ordertotals.Shipping',0); INSERT INTO `orders_total` (`orders_total_id`,`orders_id`,`title`,`text`,`value`,`class`,`sort_order`) VALUES (37,10,'Total:','$168','168.0000','com.facecart.ecm.ordertotals.OrderTotal',1), (38,10,'VAT + tt ','$31.53','31.5300','com.facecart.ecm.ordertotals.OrderTotalTax',0), (39,10,'Flat Rate','$5.94','5.9400','com.facecart.ecm.ordertotals.Shipping',0), (40,10,'Sub-Total','$168','168.0000','com.facecart.ecm.ordertotals.SubTotal',0), (41,11,'tt + VAT ','$22.52','22.5200','com.facecart.ecm.ordertotals.OrderTotalTax',0), (42,11,'Flat Rate','$5.94','5.9400','com.facecart.ecm.ordertotals.Shipping',0), (43,11,'Sub-Total','$119.97','119.9700','com.facecart.ecm.ordertotals.SubTotal',0), (44,11,'Total:','$119.97','119.9700','com.facecart.ecm.ordertotals.OrderTotal',1), (45,12,'Total:','$431.9','431.9000','com.facecart.ecm.ordertotals.OrderTotal',1), (46,12,'Sub-Total','$431.9','431.9000','com.facecart.ecm.ordertotals.SubTotal',0), (47,12,'tt + VAT ','$81.07','81.0700','com.facecart.ecm.ordertotals.OrderTotalTax',0), (48,12,'Flat Rate','$5.94','5.9400','com.facecart.ecm.ordertotals.Shipping',0); INSERT INTO `orders_total` (`orders_total_id`,`orders_id`,`title`,`text`,`value`,`class`,`sort_order`) VALUES (49,13,'VAT + tt ','$7.55','7.5500','com.facecart.ecm.ordertotals.OrderTotalTax',0), (50,13,'Flat Rate','$5.94','5.9400','com.facecart.ecm.ordertotals.Shipping',0), (51,13,'Total:','$39.99','39.9900','com.facecart.ecm.ordertotals.OrderTotal',1), (52,13,'Sub-Total','$39.99','39.9900','com.facecart.ecm.ordertotals.SubTotal',0), (53,14,'Flat Rate','$5','5.0000','com.facecart.ecm.ordertotals.Shipping',0), (54,14,'Total:','$22','22.0000','com.facecart.ecm.ordertotals.OrderTotal',1), (55,14,'VAT + tt ','$0','0.0000','com.facecart.ecm.ordertotals.OrderTotalTax',0), (56,14,'Sub-Total','$22','22.0000','com.facecart.ecm.ordertotals.SubTotal',0), (57,15,'VAT + tt ','692.611EUR','480.9700','com.facecart.ecm.ordertotals.OrderTotalTax',0), (58,15,'Total:','3,669.096EUR','2547.9300','com.facecart.ecm.ordertotals.OrderTotal',1), (59,15,'Sub-Total','3,669.096EUR','2547.9300','com.facecart.ecm.ordertotals.SubTotal',0), (60,15,'Flat Rate','8.554EUR','5.9400','com.facecart.ecm.ordertotals.Shipping',0); INSERT INTO `orders_total` (`orders_total_id`,`orders_id`,`title`,`text`,`value`,`class`,`sort_order`) VALUES (61,16,'VAT + tt ','0SP','0.0000','com.facecart.ecm.ordertotals.OrderTotalTax',0), (62,16,'Sub-Total','5,599.8SP','5599.8000','com.facecart.ecm.ordertotals.SubTotal',0), (63,16,'Total:','5,599.8SP','5599.8000','com.facecart.ecm.ordertotals.OrderTotal',1), (64,16,'Flat Rate','5SP','5.0000','com.facecart.ecm.ordertotals.Shipping',0), (65,17,'Total:','42SP','42.0000','com.facecart.ecm.ordertotals.OrderTotal',1), (66,17,'VAT + tt ','7.93SP','7.9300','com.facecart.ecm.ordertotals.OrderTotalTax',0), (67,17,'Flat Rate','5.94SP','5.9400','com.facecart.ecm.ordertotals.Shipping',0), (68,17,'Sub-Total','42SP','42.0000','com.facecart.ecm.ordertotals.SubTotal',0), (69,18,'Sub-Total','$80','80.0000','com.facecart.ecm.ordertotals.SubTotal',0), (70,18,'Flat Rate','$5.94','5.9400','com.facecart.ecm.ordertotals.Shipping',0), (71,18,'tt + VAT ','$15.1','15.1000','com.facecart.ecm.ordertotals.OrderTotalTax',0), (72,18,'Total:','$80','80.0000','com.facecart.ecm.ordertotals.OrderTotal',1); INSERT INTO `orders_total` (`orders_total_id`,`orders_id`,`title`,`text`,`value`,`class`,`sort_order`) VALUES (73,19,'Total:','$35','35.0000','com.facecart.ecm.ordertotals.OrderTotal',1), (74,19,'Sub-Total','$35','35.0000','com.facecart.ecm.ordertotals.SubTotal',0), (75,19,'Flat Rate','$5','5.0000','com.facecart.ecm.ordertotals.Shipping',0), (76,19,'VAT + tt ','$0','0.0000','com.facecart.ecm.ordertotals.OrderTotalTax',0); /*!40000 ALTER TABLE `orders_total` ENABLE KEYS */; -- -- Definition of table `orders_total_config` -- DROP TABLE IF EXISTS `orders_total_config`; CREATE TABLE `orders_total_config` ( `id` int(10) unsigned NOT NULL auto_increment, `orders_total_method_id` int(10) unsigned NOT NULL default '0', `conf_key` varchar(80) NOT NULL, `conf_value` varchar(80) NOT NULL, `conf_description` varchar(80) NOT NULL, `enums` varchar(120) default NULL, `title` varchar(80) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `orders_total_config` -- /*!40000 ALTER TABLE `orders_total_config` DISABLE KEYS */; INSERT INTO `orders_total_config` (`id`,`orders_total_method_id`,`conf_key`,`conf_value`,`conf_description`,`enums`,`title`) VALUES (1,1,'MODULE_ORDER_TOTAL_LOWORDERFEE_LOW_ORDER_FEE','true','Do you want to allow low order fees?','false|true','Allow Low Order Fee'), (2,1,'MODULE_ORDER_TOTAL_LOWORDERFEE_ORDER_UNDER','55','Add the low order fee to orders under this amount.',NULL,'Order Fee For Orders Under'), (3,1,'MODULE_ORDER_TOTAL_LOWORDERFEE_FEE','5','Low order fee.',NULL,'Order Fee'), (4,1,'MODULE_ORDER_TOTAL_LOWORDERFEE_DESTINATION','international','Attach low order fee for orders sent to the set destination.','both|international|national','Attach Low Order Fee On Orders Made'), (5,1,'MODULE_ORDER_TOTAL_LOWORDERFEE_TAX_CLASS','1','Use the following tax class on the low order fee.',NULL,'Tax Class'), (6,2,'MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING','false','Do you want to allow free shipping?','true|false','Allow Free Shipping'), (7,2,'MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER','50','Provide free shipping for orders over the set amount.',NULL,'Free Shipping For Orders Over'), (8,2,'MODULE_ORDER_TOTAL_SHIPPING_DESTINATION','national','Provide free shipping for orders sent to the set destination.','national|international|both','Provide Free Shipping For Orders Made'); /*!40000 ALTER TABLE `orders_total_config` ENABLE KEYS */; -- -- Definition of table `orders_total_method` -- DROP TABLE IF EXISTS `orders_total_method`; CREATE TABLE `orders_total_method` ( `id` int(10) unsigned NOT NULL auto_increment, `status` tinyint(3) unsigned NOT NULL, `method_name` varchar(45) NOT NULL, `order_total_class` varchar(45) NOT NULL, `sort_order` int(10) unsigned NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `orders_total_method` -- /*!40000 ALTER TABLE `orders_total_method` DISABLE KEYS */; INSERT INTO `orders_total_method` (`id`,`status`,`method_name`,`order_total_class`,`sort_order`) VALUES (1,1,'Low Order Fee','com.facecart.ecm.ordertotals.LowOrderFee',0), (2,1,'Shipping','com.facecart.ecm.ordertotals.Shipping',0), (3,1,'Sub-Total','com.facecart.ecm.ordertotals.SubTotal',0), (4,1,'Tax','com.facecart.ecm.ordertotals.OrderTotalTax',0), (5,1,'Total','com.facecart.ecm.ordertotals.OrderTotal',1); /*!40000 ALTER TABLE `orders_total_method` ENABLE KEYS */; -- -- Definition of table `payment_config` -- DROP TABLE IF EXISTS `payment_config`; CREATE TABLE `payment_config` ( `id` int(10) unsigned NOT NULL auto_increment, `payment_method_id` int(10) unsigned NOT NULL, `conf_key` varchar(80) NOT NULL, `conf_value` varchar(80) NOT NULL, `conf_description` varchar(80) NOT NULL, `enums` varchar(120) default NULL, `title` varchar(80) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `payment_config` -- /*!40000 ALTER TABLE `payment_config` DISABLE KEYS */; INSERT INTO `payment_config` (`id`,`payment_method_id`,`conf_key`,`conf_value`,`conf_description`,`enums`,`title`) VALUES (1,2,'MODULE_PAYMENT_PAYPAL_ID','your@mail.com','The e-mail address to use for the PayPal service',NULL,'E-Mail Address'), (2,2,'MODULE_PAYMENT_PAYPAL_CURRENCY','Only GBP','The currency to use for credit card transactions','Only CAD|Only EUR|Only GBP|Only JPY|Only USD|Selected Currency','Transaction Currency'); /*!40000 ALTER TABLE `payment_config` ENABLE KEYS */; -- -- Definition of table `payment_method` -- DROP TABLE IF EXISTS `payment_method`; CREATE TABLE `payment_method` ( `id` int(10) unsigned NOT NULL auto_increment, `method_name` varchar(45) NOT NULL, `order_status_id` int(10) unsigned NOT NULL, `sort_order` varchar(45) default NULL, `zone_id` int(10) unsigned default NULL, `payment_class` varchar(45) NOT NULL, `enabled` tinyint(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `payment_method` -- /*!40000 ALTER TABLE `payment_method` DISABLE KEYS */; INSERT INTO `payment_method` (`id`,`method_name`,`order_status_id`,`sort_order`,`zone_id`,`payment_class`,`enabled`) VALUES (1,'cash on delivery',2,'0',1,'com.facecart.ecm.payments.CashOnDelivery',1), (2,'paypal',1,'1',0,'com.facecart.ecm.payments.Paypal',1); /*!40000 ALTER TABLE `payment_method` ENABLE KEYS */; -- -- Definition of table `products` -- DROP TABLE IF EXISTS `products`; CREATE TABLE `products` ( `products_id` int(11) NOT NULL auto_increment, `products_quantity` int(4) NOT NULL, `products_model` varchar(12) default NULL, `products_image` varchar(64) default NULL, `products_price` decimal(15,4) NOT NULL, `products_date_added` datetime NOT NULL, `products_last_modified` datetime default NULL, `products_date_available` datetime default NULL, `products_weight` decimal(5,2) NOT NULL, `products_status` tinyint(1) NOT NULL, `products_tax_class_id` int(11) NOT NULL, `manufacturers_id` int(11) default NULL, `products_ordered` int(11) NOT NULL default '0', PRIMARY KEY (`products_id`), KEY `idx_products_date_added` (`products_date_added`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `products` -- /*!40000 ALTER TABLE `products` DISABLE KEYS */; INSERT INTO `products` (`products_id`,`products_quantity`,`products_model`,`products_image`,`products_price`,`products_date_added`,`products_last_modified`,`products_date_available`,`products_weight`,`products_status`,`products_tax_class_id`,`manufacturers_id`,`products_ordered`) VALUES (1,32,'MG200MMS','matrox/mg200mms.gif','600.0000','2007-04-05 17:40:13',NULL,'2007-04-05 00:00:00','23.00',1,1,1,1), (2,32,'MG400-32MB','matrox/mg400-32mb.gif','499.9900','2007-04-05 17:40:13',NULL,'2007-05-26 00:00:00','23.00',1,1,1,18), (3,2,'MSIMPRO','microsoft/msimpro.gif','49.9900','2007-04-05 17:40:13',NULL,NULL,'7.00',1,1,3,3), (4,13,'DVD-RPMK','dvd/replacement_killers.gif','42.0000','2007-04-05 17:40:13',NULL,NULL,'23.00',1,1,2,7), (5,17,'DVD-BLDRNDC','dvd/blade_runner.gif','35.9900','2007-04-05 17:40:13',NULL,NULL,'7.00',1,1,3,0), (6,10,'DVD-MATR','dvd/the_matrix.gif','39.9900','2007-04-05 17:40:13',NULL,NULL,'7.00',1,1,3,1), (7,10,'DVD-YGEM','dvd/youve_got_mail.gif','34.9900','2007-04-05 17:40:13',NULL,NULL,'7.00',1,1,3,4), (8,1,'DVD-ABUG','dvd/a_bugs_life.gif','35.9900','2007-04-05 17:40:13',NULL,'2007-08-23 00:00:00','7.00',1,1,3,4); INSERT INTO `products` (`products_id`,`products_quantity`,`products_model`,`products_image`,`products_price`,`products_date_added`,`products_last_modified`,`products_date_available`,`products_weight`,`products_status`,`products_tax_class_id`,`manufacturers_id`,`products_ordered`) VALUES (9,10,'DVD-UNSG','dvd/under_siege.gif','29.9900','2007-04-05 17:40:13',NULL,NULL,'7.00',1,1,3,0), (10,10,'DVD-UNSG2','dvd/under_siege2.gif','29.9900','2007-04-05 17:40:13',NULL,NULL,'7.00',1,1,3,0), (11,13,'DVD-FDBL','dvd/fire_down_below.gif','29.9900','2007-04-05 17:40:13',NULL,NULL,'7.00',1,1,3,0), (12,13,'DVD-FDBL','dvd/die_hard_3.gif','29.9900','2007-04-05 17:40:13',NULL,'2007-12-21 00:00:00','7.00',1,1,4,12), (13,10,'DVD-LTWP','dvd/lethal_weapon.gif','34.9900','2007-04-05 17:40:13',NULL,NULL,'7.00',1,1,3,0), (14,10,'DVD-REDC','dvd/red_corner.gif','32.0000','2007-04-05 17:40:13',NULL,NULL,'7.00',1,1,3,1), (15,10,'DVD-FRAN','dvd/frantic.gif','35.0000','2007-04-05 17:40:13',NULL,NULL,'7.00',1,1,3,1), (16,10,'DVD-CUFI','dvd/courage_under_fire.gif','38.9900','2007-04-05 17:40:13',NULL,'2007-09-20 00:00:00','7.00',1,1,4,1); INSERT INTO `products` (`products_id`,`products_quantity`,`products_model`,`products_image`,`products_price`,`products_date_added`,`products_last_modified`,`products_date_available`,`products_weight`,`products_status`,`products_tax_class_id`,`manufacturers_id`,`products_ordered`) VALUES (17,10,'DVD-SPEED','dvd/speed.gif','39.9900','2007-04-05 17:40:13',NULL,NULL,'7.00',1,1,4,0), (18,10,'DVD-SPEED2','dvd/speed_2.gif','42.0000','2007-04-05 17:40:13',NULL,NULL,'7.00',1,1,4,0), (19,10,'DVD-TSAB','dvd/theres_something_about_mary.gif','49.9900','2007-04-05 17:40:13',NULL,NULL,'7.00',1,1,4,6), (20,10,'DVD-BELOVED','dvd/beloved.gif','54.9900','2007-04-05 17:40:13',NULL,NULL,'7.00',1,1,3,0), (21,16,'PC-SWAT3','sierra/intkeyboardps2.gif','80.0000','2007-04-05 17:40:13',NULL,'2007-04-05 03:00:00','7.00',1,1,7,6), (25,16,'MSINTKB','microsoft/intkeyboardps2.gif','69.9900','2007-04-05 17:40:13',NULL,NULL,'8.00',1,1,2,10), (26,10,'MSIMEXP','microsoft/imexplorer.gif','64.9500','2007-04-05 17:40:13',NULL,NULL,'8.00',1,1,2,0), (27,8,'HPLJ1100XI','hewlett_packard/lj1100xi.gif','499.9900','2007-04-05 17:40:13',NULL,'2008-01-16 00:00:00','45.00',1,1,9,0); INSERT INTO `products` (`products_id`,`products_quantity`,`products_model`,`products_image`,`products_price`,`products_date_added`,`products_last_modified`,`products_date_available`,`products_weight`,`products_status`,`products_tax_class_id`,`manufacturers_id`,`products_ordered`) VALUES (29,17,'PC-DISC','gt_interactive/disciples.gif','90.0000','2007-11-24 18:04:22',NULL,'2007-11-08 00:00:00','8.00',1,1,8,0), (30,15,'PC-TWOF','canon/wheel_of_time.gif','22.0000','2007-11-24 18:12:20',NULL,'2007-11-23 00:00:00','10.00',1,1,6,1), (31,13,'PC-UNTM','gt_interactive/unreal_tournament.gif','10.0000','2007-04-05 17:40:13',NULL,'2007-05-11 03:00:00','7.00',0,1,8,0); /*!40000 ALTER TABLE `products` ENABLE KEYS */; -- -- Definition of table `products_attributes` -- DROP TABLE IF EXISTS `products_attributes`; CREATE TABLE `products_attributes` ( `products_attributes_id` int(11) NOT NULL auto_increment, `products_id` int(11) NOT NULL, `options_id` int(11) NOT NULL, `options_values_id` int(11) NOT NULL, `options_values_price` decimal(15,4) NOT NULL, `price_prefix` char(1) NOT NULL, PRIMARY KEY (`products_attributes_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `products_attributes` -- /*!40000 ALTER TABLE `products_attributes` DISABLE KEYS */; INSERT INTO `products_attributes` (`products_attributes_id`,`products_id`,`options_id`,`options_values_id`,`options_values_price`,`price_prefix`) VALUES (1,1,4,4,'0.0000','+'), (2,1,4,2,'50.0000','+'), (3,1,4,4,'70.0000','+'), (4,1,3,5,'0.0000','+'), (5,1,3,6,'100.0000','+'), (6,2,4,3,'10.0000','-'), (7,2,4,4,'0.0000','+'), (8,2,3,6,'0.0000','+'), (9,2,3,7,'120.0000','+'), (10,26,3,8,'0.0000','+'), (11,26,3,9,'6.0000','+'), (12,13,3,9,'100.0000','+'), (13,8,4,4,'0.0000',''), (14,31,4,4,'0.0000',''); /*!40000 ALTER TABLE `products_attributes` ENABLE KEYS */; -- -- Definition of table `products_attributes_download` -- DROP TABLE IF EXISTS `products_attributes_download`; CREATE TABLE `products_attributes_download` ( `products_attributes_id` int(11) NOT NULL, `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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `products_attributes_download` -- /*!40000 ALTER TABLE `products_attributes_download` DISABLE KEYS */; INSERT INTO `products_attributes_download` (`products_attributes_id`,`products_attributes_filename`,`products_attributes_maxdays`,`products_attributes_maxcount`) VALUES (26,'unreal.zip',7,3); /*!40000 ALTER TABLE `products_attributes_download` ENABLE KEYS */; -- -- Definition of table `products_description` -- DROP TABLE IF EXISTS `products_description`; CREATE TABLE `products_description` ( `products_id` int(11) NOT NULL auto_increment, `language_id` int(11) NOT NULL default '1', `products_name` varchar(64) NOT NULL default '', `products_description` text, `products_url` varchar(255) default NULL, `products_viewed` int(5) default '0', PRIMARY KEY (`products_id`,`language_id`), KEY `products_name` (`products_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `products_description` -- /*!40000 ALTER TABLE `products_description` DISABLE KEYS */; INSERT INTO `products_description` (`products_id`,`language_id`,`products_name`,`products_description`,`products_url`,`products_viewed`) 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',79), (1,2,'Матрокс Г200 ММС','Матрокс отново ще зарадва своите фенове с поредният шедиовър в областта на графичните карти. То изключитено гъвкаво решение може да бъде ваше почти за без пари. Да знам че звучи странно, но в светът на фантазиите всичко е възможно нали. WOW за без пари:)))) Lineage i t.n.\nПридрожена със чаша червено вино, тази графична карта би могла да ви донесе изживявания за които дори и не сте подозирали.','www.matrox.com/mga/products/g200_mms/home.cfm',0); INSERT INTO `products_description` (`products_id`,`language_id`,`products_name`,`products_description`,`products_url`,`products_viewed`) 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',48), (2,2,'Матрокс Г400 32мб','Различната високо-скоростна графична карта

Представяме ви Хилядолетната серия Г400, въоражена с най бързият графичен чип, тази карта притежава експлозивно ускорение и качество на изображението. Този модел не просто ще промени вашите критерии за графична карта, но също така ще революционализира начинът по който използвате компютъра.

','www.matrox.com/mga/products/mill_g400/home.htm',0); INSERT INTO `products_description` (`products_id`,`language_id`,`products_name`,`products_description`,`products_url`,`products_viewed`) 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',40), (3,2,'Интелигентна мишка ПРО','Всеки елемент на тази мишка е плод на дълго изследване върху потребителите на наши продукти. ','www.microsoft.com/hardware/mouse/intellimouse.asp',0), (4,1,'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).','',48), (4,2,'Наемни убийци','Регонален код: 2(Япония, Европа, Средният Изток, Южна Африка)\n
\nЕзици: Английски, Немски\n
\nСубтитри: Английски,Немски,Български\n
\nАудиа: Долби Съраунд 5.1 \n
\nФормат на картината: 16:9 Широк екран\n
\nДължина: 100 минути\n
\nДруги: интерактивни менюта, избор на глави, субтитри\n','',0); INSERT INTO `products_description` (`products_id`,`language_id`,`products_name`,`products_description`,`products_url`,`products_viewed`) VALUES (5,1,'Blade Runner','KEINE KOMPROMISSE!
Kämpfen Sie Seite an Seite mit Ihren LAPD SWAT-Kameraden gegen das organisierte Verbrechen!

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

\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.

\nNeue Features:\n\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.','',33), (5,2,'Блейд Рънер','Регонален код: 2(Япония, Европа, Средният Изток, Южна Африка)\n
\nЕзици: Английски, Немски\n
\nСубтитри: Английски,Немски,Български\n
\nАудиа: Долби Съраунд 5.1 \n
\nФормат на картината: 16:9 Широк екран\n
\nДължина: 100 минути\n
\nДруги: интерактивни менюта, избор на глави, субтитри\n','',0); INSERT INTO `products_description` (`products_id`,`language_id`,`products_name`,`products_description`,`products_url`,`products_viewed`) VALUES (6,1,'The Matrix','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\n
\nLanguages: English, Deutsch.\n
\nSubtitles: English, Deutsch.\n
\nAudio: Dolby Surround.\n
\nPicture Format: 16:9 Wide-Screen.\n
\nLength: (approx) 131 minutes.\n
\nOther: Interactive Menus, Chapter Selection, Making Of.','',21), (6,2,'Матрицата','Регонален код: 2(Япония, Европа, Средният Изток, Южна Африка)\n
\nЕзици: Английски, Немски\n
\nСубтитри: Английски,Немски,Български\n
\nАудиа: Долби Съраунд 5.1 \n
\nФормат на картината: 16:9 Широк екран\n
\nДължина: 100 минути\n
\nДруги: интерактивни менюта, избор на глави, субтитри\n','',0), (7,1,'You\'ve got mail','KEINE KOMPROMISSE!
Kämpfen Sie Seite an Seite mit Ihren LAPD SWAT-Kameraden gegen das organisierte Verbrechen!

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

\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.

\nNeue Features:\n\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.','',24); INSERT INTO `products_description` (`products_id`,`language_id`,`products_name`,`products_description`,`products_url`,`products_viewed`) VALUES (7,2,'Имате поща','Регонален код: 2(Япония, Европа, Средният Изток, Южна Африка)\n
\nЕзици: Английски, Немски\n
\nСубтитри: Английски,Немски,Български\n
\nАудиа: Долби Съраунд 5.1 \n
\nФормат на картината: 16:9 Широк екран\n
\nДължина: 100 минути\n
\nДруги: интерактивни менюта, избор на глави, субтитри\n','',0), (8,1,'A Bug\'s Life','KEINE KOMPROMISSE!
Kämpfen Sie Seite an Seite mit Ihren LAPD SWAT-Kameraden gegen das organisierte Verbrechen!

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

\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.

\nNeue Features:\n\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.','',43), (8,2,'Животът на Буболечката','Регонален код: 2(Япония, Европа, Средният Изток, Южна Африка)\n
\nЕзици: Английски, Немски\n
\nСубтитри: Английски,Немски,Български\n
\nАудиа: Долби Съраунд 5.1 \n
\nФормат на картината: 16:9 Широк екран\n
\nДължина: 100 минути\n
\nДруги: интерактивни менюта, избор на глави, субтитри\n','',0); INSERT INTO `products_description` (`products_id`,`language_id`,`products_name`,`products_description`,`products_url`,`products_viewed`) VALUES (9,1,'Under Siege','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\n
\nLanguages: English, Deutsch.\n
\nSubtitles: English, Deutsch.\n
\nAudio: Dolby Surround.\n
\nPicture Format: 16:9 Wide-Screen.\n
\nLength: (approx) 131 minutes.\n
\nOther: Interactive Menus, Chapter Selection, Making Of.','',30), (9,2,'Под обсада','Регонален код: 2(Япония, Европа, Средният Изток, Южна Африка)\n
\nЕзици: Английски, Немски\n
\nСубтитри: Английски,Немски,Български\n
\nАудиа: Долби Съраунд 5.1 \n
\nФормат на картината: 16:9 Широк екран\n
\nДължина: 100 минути\n
\nДруги: интерактивни менюта, избор на глави, субтитри\n','',0), (10,1,'Under Siege 2','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\n
\nLanguages: English, Deutsch.\n
\nSubtitles: English, Deutsch.\n
\nAudio: Dolby Surround.\n
\nPicture Format: 16:9 Wide-Screen.\n
\nLength: (approx) 131 minutes.\n
\nOther: Interactive Menus, Chapter Selection, Making Of.','',21); INSERT INTO `products_description` (`products_id`,`language_id`,`products_name`,`products_description`,`products_url`,`products_viewed`) VALUES (10,2,'Под обсада 2','Регонален код: 2(Япония, Европа, Средният Изток, Южна Африка)\n
\nЕзици: Английски, Немски\n
\nСубтитри: Английски,Немски,Български\n
\nАудиа: Долби Съраунд 5.1 \n
\nФормат на картината: 16:9 Широк екран\n
\nДължина: 100 минути\n
\nДруги: интерактивни менюта, избор на глави, субтитри\n','',0), (11,1,'Fire Down Below','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\n
\nLanguages: English, Deutsch.\n
\nSubtitles: English, Deutsch, Spanish.\n
\nAudio: Dolby Surround 5.1.\n
\nPicture Format: 16:9 Wide-Screen.\n
\nLength: (approx) 100 minutes.\n
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','www.swat3.com',19), (11,2,'Огън отдолу','хеллоооо','',0); INSERT INTO `products_description` (`products_id`,`language_id`,`products_name`,`products_description`,`products_url`,`products_viewed`) VALUES (12,1,'Die Hard','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\n
\nLanguages: English, Deutsch.\n
\nSubtitles: English, Deutsch, Spanish.\n
\nAudio: Dolby Surround 5.1.\n
\nPicture Format: 16:9 Wide-Screen.\n
\nLength: (approx) 100 minutes.\n
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','www.swat3.com',45), (12,2,'Умирай трудно','Регонален код: 2(Япония, Европа, Средният Изток, Южна Африка)\n
\nЕзици: Английски, Немски\n
\nСубтитри: Английски,Немски,Български\n
\nАудиа: Долби Съраунд 5.1 \n
\nФормат на картината: 16:9 Широк екран\n
\nДължина: 100 минути\n
\nДруги: интерактивни менюта, избор на глави, субтитри\n','',0), (13,1,'Lethal Wapon','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\n
\nLanguages: English, Deutsch.\n
\nSubtitles: English, Deutsch, Spanish.\n
\nAudio: Dolby Surround 5.1.\n
\nPicture Format: 16:9 Wide-Screen.\n
\nLength: (approx) 100 minutes.\n
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',20); INSERT INTO `products_description` (`products_id`,`language_id`,`products_name`,`products_description`,`products_url`,`products_viewed`) VALUES (13,2,'Съмртоносно Оръжие','','',0), (14,1,'Red Corner','KEINE KOMPROMISSE!
Kämpfen Sie Seite an Seite mit Ihren LAPD SWAT-Kameraden gegen das organisierte Verbrechen!

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

\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.

\nNeue Features:\n\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.','',32), (14,2,'Червеният ъгъл','Регонален код: 2(Япония, Европа, Средният Изток, Южна Африка)\n
\nЕзици: Английски, Немски\n
\nСубтитри: Английски,Немски,Български\n
\nАудиа: Долби Съраунд 5.1 \n
\nФормат на картината: 16:9 Широк екран\n
\nДължина: 100 минути\n
\nДруги: интерактивни менюта, избор на глави, субтитри\n','',0); INSERT INTO `products_description` (`products_id`,`language_id`,`products_name`,`products_description`,`products_url`,`products_viewed`) VALUES (15,1,'Frantic','KEINE KOMPROMISSE!
Kämpfen Sie Seite an Seite mit Ihren LAPD SWAT-Kameraden gegen das organisierte Verbrechen!

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

\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.

\nNeue Features:\n\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.','',67), (15,2,'Обезумял','Регонален код: 2(Япония, Европа, Средният Изток, Южна Африка)\n
\nЕзици: Английски, Немски\n
\nСубтитри: Английски,Немски,Български\n
\nАудиа: Долби Съраунд 5.1 \n
\nФормат на картината: 16:9 Широк екран\n
\nДължина: 100 минути\n
\nДруги: интерактивни менюта, избор на глави, субтитри\n','',0); INSERT INTO `products_description` (`products_id`,`language_id`,`products_name`,`products_description`,`products_url`,`products_viewed`) VALUES (16,1,'Courage Under Fire','KEINE KOMPROMISSE!
Kämpfen Sie Seite an Seite mit Ihren LAPD SWAT-Kameraden gegen das organisierte Verbrechen!

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

\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.

\nNeue Features:\n\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.','',25), (16,2,'Под Обстрел','Регонален код: 2(Япония, Европа, Средният Изток, Южна Африка)\r\n
\r\nЕзици: Английски, Немски\r\n
\r\nСубтитри: Английски,Немски,Български\r\n
\r\nАудиа: Долби Съраунд 5.1 \r\n
тест\r\nФормат на картината: 16:9 Широк екран\r\n
\r\nДължина: 100 минути\r\n
\r\nДруги: интерактивни менюта, избор на глави, субтитри\r\n','',0); INSERT INTO `products_description` (`products_id`,`language_id`,`products_name`,`products_description`,`products_url`,`products_viewed`) VALUES (17,1,'Speed 2: Cruise Contron','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\n
\nLanguages: English, Deutsch.\n
\nSubtitles: English, Deutsch, Spanish.\n
\nAudio: Dolby Surround 5.1.\n
\nPicture Format: 16:9 Wide-Screen.\n
\nLength: (approx) 120 minutes.\n
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',37), (17,2,'Speed 2: катерът','Регонален код: 2(Япония, Европа, Средният Изток, Южна Африка)\n
\nЕзици: Английски, Немски\n
\nСубтитри: Английски,Немски,Български\n
\nАудиа: Долби Съраунд 5.1 \n
\nФормат на картината: 16:9 Широк екран\n
\nДължина: 100 минути\n
\nДруги: интерактивни менюта, избор на глави, субтитри\n','',0), (18,1,'Speed','Regional Code: 2 (Japan, Europe, Middle East, South Africa).\n
\nLanguages: English, Deutsch.\n
\nSubtitles: English, Deutsch, Spanish.\n
\nAudio: Dolby Surround 5.1.\n
\nPicture Format: 16:9 Wide-Screen.\n
\nLength: (approx) 112 minutes.\n
\nOther: Interactive Menus, Chapter Selection, Subtitles (more languages).','',20); INSERT INTO `products_description` (`products_id`,`language_id`,`products_name`,`products_description`,`products_url`,`products_viewed`) VALUES (18,2,'Скорост','Регонален код: 2(Япония, Европа, Средният Изток, Южна Африка)\n
\nЕзици: Английски, Немски\n
\nСубтитри: Английски,Немски,Български\n
\nАудиа: Долби Съраунд 5.1 \n
\nФормат на картината: 16:9 Широк екран\n
\nДължина: 160 минути\n
\nДруги: интерактивни менюта, избор на глави, субтитри\n','',0), (19,1,'There is something about mary','KEINE KOMPROMISSE!
Kämpfen Sie Seite an Seite mit Ihren LAPD SWAT-Kameraden gegen das organisierte Verbrechen!

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

\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.

\nNeue Features:\n\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.','',82), (19,2,'Ах тази мери!','Регонален код: 2(Япония, Европа, Средният Изток, Южна Африка)\n
\nЕзици: Английски, Немски\n
\nСубтитри: Английски,Немски,Български\n
\nАудиа: Долби Съраунд 5.1 \n
\nФормат на картината: 16:9 Широк екран\n
\nДължина: 100 минути\n
\nДруги: интерактивни менюта, избор на глави, субтитри\n','',0); INSERT INTO `products_description` (`products_id`,`language_id`,`products_name`,`products_description`,`products_url`,`products_viewed`) VALUES (20,1,'Beloved','KEINE KOMPROMISSE!
Kämpfen Sie Seite an Seite mit Ihren LAPD SWAT-Kameraden gegen das organisierte Verbrechen!

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

\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.

\nNeue Features:\n\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.','',61), (20,2,'Влюбени','Регонален код: 2(Япония, Европа, Средният Изток, Южна Африка)\n
\nЕзици: Английски, Немски\n
\nСубтитри: Английски,Немски,Български\n
\nАудиа: Долби Съраунд 5.1 \n
\nФормат на картината: 16:9 Широк екран\n
\nДължина: 100 минути\n
\nДруги: интерактивни менюта, избор на глави, субтитри\n','',0); INSERT INTO `products_description` (`products_id`,`language_id`,`products_name`,`products_description`,`products_url`,`products_viewed`) 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',62), (21,2,'Полицейски участък','Windows 95/98

211 в изпълнение на задача, чуват се изтрели. Офицер на земята. Въоражени заподозряни със заложници. Код 3, приет. Лос Анжелис 2005, в следващите седем дни представител на всяка нация по света ще бъде свидетел в Лос Анжелис на подписването на Ядреният Договор на ООН. Опазването нареда попада под отговорността на една организация. Специалният отряд на Лос Анжелистката полиция. Като част на елитна тактическа организация ти и твоят отбор имате оръжия както и необходимата подготовка да предпазвате, да служите и при необходимост до използвате смъртоносната сила на оръжията в опазването на мира','www.swat3.com',0); INSERT INTO `products_description` (`products_id`,`language_id`,`products_name`,`products_description`,`products_url`,`products_viewed`) 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!','',34), (25,2,'Микрософ клавиетура','Тази клавиетура има цели 10 горещи клавиша, удобна със стандартен дизайн. Горещите клавиши биха ви позволили с бързина и лекота да сърфирате из интернет пространството. Вашата пощенска кутия може да бъде на един клавиш разстояние.','',0), (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',49); INSERT INTO `products_description` (`products_id`,`language_id`,`products_name`,`products_description`,`products_url`,`products_viewed`) VALUES (26,2,'Интелигентна мишка от микрософт','Микрософт предлага този подобрен модел, на интелигентната мишка. Готин дизайн, индустриялно сребърен цвят искрящо червен под създава стил и комфот. Комбинира прецизност стил и надеждност оптично следящо устройство и други готини функции.','www.microsoft.com/hardware/mouse/explorer.asp',0), (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',75), (27,2,'Лазерен принтер Хюлет пакард','Хюлет пакар както винаги определя модните тенденции в областта на лазерното принтиране. Новото поколение лазерен джет е поредният шедиовър в своят клас. Със своята резолюция той прави всеки един документ по професионален

Подобрената скорост и качество на печат са просто началото. С 2 мб стандартна памет, потребителните могат да печатат страници с изключителна комплексност. Този принтер поддържа ключови операционни системи като windows 3.1,3.11, 95,98, NT 4.0','www.pandi.hp.com/pandi-db/prodinfo.main?product=laserjet1100',0); INSERT INTO `products_description` (`products_id`,`language_id`,`products_name`,`products_description`,`products_url`,`products_viewed`) VALUES (29,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.','www.strategyfirst.com/disciples/welcome.html',26), (29,2,'Наследниците','В зората на новата ера...

Добре дошли в реалността на Святите Земи, в зората на номата ера, в средата на най разтърсващите войни. Пророчествата са изказани, четири раси в съдбовен конфликт. Меч срещу меч магия се изправя срещу магия в отчайващата битка за контрол. \n Поеми мисията, като шампион на империята, или планинският клан,легионите на прокълнатите или хордите на безсмъртните.\n

Денят на завръщането дойде... и единствено избраните ще оцелеят.','www.strategyfirst.com/disciples/welcome.html',0), (30,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',13); INSERT INTO `products_description` (`products_id`,`language_id`,`products_name`,`products_description`,`products_url`,`products_viewed`) VALUES (30,2,'Колелото на времето','Светът в който действието на колелото на времето се развива е взет от страниците на Дордан. Той е необятен. Как се придвижваш в този свят зависи изключително от това дали играеш сингъл или мултиплейър режим. С няколко изключения сингъл плейър режима ще видим Илейн да крастосва света основно пеш. В рамките на мултиплейър режима твоят герой има достъп до тер-ангреали, портални камни и пътищата.

\nПо времето на твоите пътешествия, ти бързо ще откриеш че четири локации са критични за успехът ти в тази игра.
Очаква ви невероятно преживяване проеткривайки светът на Джордън в тази игра','www.wheeloftime.com',0), (31,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',3); INSERT INTO `products_description` (`products_id`,`language_id`,`products_name`,`products_description`,`products_url`,`products_viewed`) VALUES (31,2,'Турнир в отвъдното','От създателите на бестселъра Unreal, идва Unreal Tournament. Ново изживяване за всички фенове. Безпощадна мултиплейър революция.

Тази игра демонстрира напълно нов, отборен стил на игра, разбиващ екшън. Истинска битка е да се спечели титлата Господар на отвъдното в гладиаторската арена. Изправи се срещо най свирепите престъпници в Галактиката.','www.unrealtournament.net',0); /*!40000 ALTER TABLE `products_description` ENABLE KEYS */; -- -- Definition of table `products_notifications` -- DROP TABLE IF EXISTS `products_notifications`; CREATE TABLE `products_notifications` ( `products_id` int(11) NOT NULL, `customers_id` int(11) NOT NULL, `date_added` datetime NOT NULL, PRIMARY KEY (`products_id`,`customers_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `products_notifications` -- /*!40000 ALTER TABLE `products_notifications` DISABLE KEYS */; INSERT INTO `products_notifications` (`products_id`,`customers_id`,`date_added`) VALUES (26,33,'2007-09-06 15:39:43'), (34,33,'2007-09-06 15:28:00'); /*!40000 ALTER TABLE `products_notifications` ENABLE KEYS */; -- -- Definition of table `products_options` -- DROP TABLE IF EXISTS `products_options`; CREATE TABLE `products_options` ( `products_options_id` int(11) NOT NULL default '0', `language_id` int(11) NOT NULL default '1', `products_options_name` varchar(32) NOT NULL default '', PRIMARY KEY (`products_options_id`,`language_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `products_options` -- /*!40000 ALTER TABLE `products_options` DISABLE KEYS */; INSERT INTO `products_options` (`products_options_id`,`language_id`,`products_options_name`) VALUES (3,1,'...'), (3,2,'?????888'), (4,1,'Memory'), (4,2,'Памет'), (5,1,'Version'), (5,2,'Версия'), (6,1,'size'), (6,2,'размер'), (7,1,'Image Upload'), (7,2,''); /*!40000 ALTER TABLE `products_options` ENABLE KEYS */; -- -- Definition of table `products_options_values` -- DROP TABLE IF EXISTS `products_options_values`; CREATE TABLE `products_options_values` ( `products_options_values_id` int(11) NOT NULL default '0', `language_id` int(11) NOT NULL default '1', `products_options_values_name` varchar(64) NOT NULL default '', PRIMARY KEY (`products_options_values_id`,`language_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `products_options_values` -- /*!40000 ALTER TABLE `products_options_values` DISABLE KEYS */; INSERT INTO `products_options_values` (`products_options_values_id`,`language_id`,`products_options_values_name`) VALUES (1,1,'4 mb'), (1,2,'4 мб'), (2,1,'8 mb'), (2,2,'8 мб'), (3,1,'16 mb'), (3,2,'16 мб'), (4,1,'32 mb'), (4,2,'32 мб'), (5,1,'Standart'), (5,2,'Стандартен'), (6,1,'Premium'), (6,2,'Профи'), (7,1,'Deluxe'), (7,2,'Лукс'), (8,1,'PS/2-'), (8,2,'ПС/2-'), (9,1,'USB'), (9,2,'ЮСБ'), (10,1,'Download: Windows - English'), (10,2,'Даунлоуд: Английски'), (13,1,'Box: Windows - English'), (13,2,'Кутия:Уиндоус Английски'), (14,1,'circle'), (14,2,'кръг'), (15,1,'rectangle'), (15,2,'квадрат'); /*!40000 ALTER TABLE `products_options_values` ENABLE KEYS */; -- -- Definition of table `products_options_values_to_products_options` -- DROP TABLE IF EXISTS `products_options_values_to_products_options`; CREATE TABLE `products_options_values_to_products_options` ( `products_options_id` int(11) NOT NULL, `products_options_values_id` int(11) NOT NULL, `products_options_values_to_products_options_id` int(10) unsigned NOT NULL auto_increment, PRIMARY KEY (`products_options_values_to_products_options_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `products_options_values_to_products_options` -- /*!40000 ALTER TABLE `products_options_values_to_products_options` DISABLE KEYS */; INSERT INTO `products_options_values_to_products_options` (`products_options_id`,`products_options_values_id`,`products_options_values_to_products_options_id`) VALUES (3,5,1), (3,6,2), (3,7,3), (3,8,4), (3,9,5), (4,1,6), (4,2,7), (4,3,8), (4,4,9), (5,10,10), (5,13,11), (21,14,12), (6,14,13), (6,15,14); /*!40000 ALTER TABLE `products_options_values_to_products_options` ENABLE KEYS */; -- -- Definition of table `products_to_categories` -- DROP TABLE IF EXISTS `products_to_categories`; CREATE TABLE `products_to_categories` ( `products_id` int(11) NOT NULL, `categories_id` int(11) NOT NULL, PRIMARY KEY (`products_id`,`categories_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `products_to_categories` -- /*!40000 ALTER TABLE `products_to_categories` DISABLE KEYS */; INSERT INTO `products_to_categories` (`products_id`,`categories_id`) VALUES (1,4), (2,4), (3,9), (4,10), (5,11), (6,10), (7,12), (8,13), (9,10), (10,10), (11,10), (12,10), (13,10), (14,15), (15,14), (16,15), (17,10), (18,10), (19,12), (20,15), (21,18), (25,8), (26,9), (27,5), (29,52), (30,52), (31,19); /*!40000 ALTER TABLE `products_to_categories` ENABLE KEYS */; -- -- Definition of table `reviews` -- DROP TABLE IF EXISTS `reviews`; CREATE TABLE `reviews` ( `reviews_id` int(11) NOT NULL auto_increment, `products_id` int(11) NOT NULL, `customers_id` int(11) default NULL, `customers_name` varchar(64) NOT NULL, `reviews_rating` int(1) default NULL, `date_added` datetime default NULL, `last_modified` datetime default NULL, `reviews_read` int(5) NOT NULL default '0', PRIMARY KEY (`reviews_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `reviews` -- /*!40000 ALTER TABLE `reviews` DISABLE KEYS */; INSERT INTO `reviews` (`reviews_id`,`products_id`,`customers_id`,`customers_name`,`reviews_rating`,`date_added`,`last_modified`,`reviews_read`) VALUES (1,19,1,'John doe',5,'2007-04-05 17:40:13','2007-05-12 15:21:26',0), (7,19,7,'Alexander2 Nikolov Petrov',4,'2007-07-05 18:40:37','2008-03-18 14:43:21',0), (8,19,7,'Alexander2 Nikolov Petrov',5,'2007-07-05 18:54:51',NULL,0), (9,8,7,'Alexander2 Nikolov Petrov',3,'2007-07-05 18:55:36',NULL,0), (10,18,7,'Georgy Zekov',4,'2007-11-30 12:52:33',NULL,0), (11,13,7,'Georgy Zekov',5,'2007-11-30 13:03:53',NULL,0); /*!40000 ALTER TABLE `reviews` ENABLE KEYS */; -- -- Definition of table `reviews_description` -- DROP TABLE IF EXISTS `reviews_description`; CREATE TABLE `reviews_description` ( `reviews_id` int(11) NOT NULL, `languages_id` int(11) NOT NULL, `reviews_text` text NOT NULL, PRIMARY KEY (`reviews_id`,`languages_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `reviews_description` -- /*!40000 ALTER TABLE `reviews_description` DISABLE KEYS */; INSERT INTO `reviews_description` (`reviews_id`,`languages_id`,`reviews_text`) VALUES (1,1,'Hristo is the best !!!'), (7,1,'hellooo\r\nnice filmmmmmmmmmmmmm!!!!!!!!!!!!!nice filmmmmmmmmmmmmm!!!!!!!!!!!!!nice filmmmmmmmmmmmmm!!!!!!!!!!!!!nice filmmmmmmmmmmmmm!!!!!!!!!!!!!nice filmmmmmmmmmmmmm!!!!!!!!!!!!!nice filmmmmmmmmmmmmm!!!!!!!!!!!!!nice filmmmmmmmmmmmmm!!!!!!!!!!!!!nice filmmmmmmmmmmmmm!!!!!!!!!!!!!nice filmmmmmmmmmmmmm!!!!!!!!!!!!!nice filmmmmmmmmmmmmm!!!!!!!!!!!!!nice filmmmmmmmmmmmmm!!!!!!!!!!!!!nice filmmmmmmmmmmmmm!!!!!!!!!!!!!nice filmmmmmmmmmmmmm!!!!!!!!!!!!!nice filmmmmmmmmmmmmm!!!!!!!!!!!!!nice filmmmmmmmmmmmmm!!!!!!!!!!!!!nice filmmmmmmmmmmmmm!!!!!!!!!!!!!nice filmmmmmmmmmmmmm!!!!!!!!!!!!!nice filmmmmmmmmmmmmm!!!!!!!!!!!!!nice filmmmmmmmmmmmmm!!!!!!!!!!!!!nice filmmmmmmmmmmmmm!!!!!!!!!!!!!nice filmmmmmmmmmmmmm!!!!!!!!!!!!!nice filmmmmmmmmmmmmm!!!!!!!!!!!!!nice filmmmmmmmmmmmmm!!!!!!!!!!!!!'), (8,1,'tralalala'), (9,1,'This film is very interesting, although I have never watched it. But I still know.'), (10,1,'мноо як филм, за мен беше удоволствие да го гледам'); INSERT INTO `reviews_description` (`reviews_id`,`languages_id`,`reviews_text`) VALUES (11,2,'Смъртоносно оръжие, класика в жанра.'); /*!40000 ALTER TABLE `reviews_description` ENABLE KEYS */; -- -- Definition of table `sessions` -- DROP TABLE IF EXISTS `sessions`; CREATE TABLE `sessions` ( `sesskey` varchar(32) NOT NULL, `expiry` int(11) unsigned NOT NULL, `value` text NOT NULL, PRIMARY KEY (`sesskey`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `sessions` -- /*!40000 ALTER TABLE `sessions` DISABLE KEYS */; /*!40000 ALTER TABLE `sessions` ENABLE KEYS */; -- -- Definition of table `shipping_config` -- DROP TABLE IF EXISTS `shipping_config`; CREATE TABLE `shipping_config` ( `id` int(10) unsigned NOT NULL auto_increment, `shipping_method_id` int(10) unsigned NOT NULL, `conf_key` varchar(45) NOT NULL, `conf_value` varchar(255) default NULL, `conf_description` varchar(255) NOT NULL, `enums` varchar(120) default NULL, `title` varchar(80) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `shipping_config` -- /*!40000 ALTER TABLE `shipping_config` DISABLE KEYS */; INSERT INTO `shipping_config` (`id`,`shipping_method_id`,`conf_key`,`conf_value`,`conf_description`,`enums`,`title`) VALUES (1,1,'MODULE_SHIPPING_FLAT_COST','5.0','The shipping cost for all orders using this shipping method.',NULL,'Shipping Cost'), (2,2,'MODULE_SHIPPING_ITEM_COST','2.5','The shipping cost will be multiplied by the number of items in an order that uses this shipping method.',NULL,'Shipping Cost'), (3,2,'MODULE_SHIPPING_ITEM_HANDLING','0.0','The shipping cost will be multiplied by the number of items in an order that uses this shipping method.',NULL,'Handling Fee'), (4,3,'MODULE_SHIPPING_TABLE_COST','25:8.50,50:5.50,10000:0.00','The shipping cost is based on the total cost or weight of items. Example: 25:8.50,50:5.50,etc.. Up to 25 charge 8.50, from there to 50 charge 5.50, etc',NULL,'Shipping Table'), (5,3,'MODULE_SHIPPING_TABLE_MODE','weight','The shipping cost is based on the order total or the total weight of the items ordered.','weight|price','Table Method'), (6,3,'MODULE_SHIPPING_TABLE_HANDLING','0.0','The shipping cost will be multiplied by the number of items in an order that uses this shipping method.',NULL,'Handling Fee'); /*!40000 ALTER TABLE `shipping_config` ENABLE KEYS */; -- -- Definition of table `shipping_method` -- DROP TABLE IF EXISTS `shipping_method`; CREATE TABLE `shipping_method` ( `id` int(10) unsigned NOT NULL auto_increment, `method_name` varchar(45) NOT NULL, `tax_class_id` int(10) unsigned default NULL, `sort_order` int(10) unsigned default '0', `zone_id` int(10) unsigned default NULL, `shipping_class` varchar(80) NOT NULL, `enabled` tinyint(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `shipping_method` -- /*!40000 ALTER TABLE `shipping_method` DISABLE KEYS */; INSERT INTO `shipping_method` (`id`,`method_name`,`tax_class_id`,`sort_order`,`zone_id`,`shipping_class`,`enabled`) VALUES (1,'Flat Rate',1,0,1,'com.facecart.ecm.shipping.FlatShipping',1), (2,'Per Item',1,0,1,'com.facecart.ecm.shipping.PerItemShipping',1), (3,'Table Rate',1,0,1,'com.facecart.ecm.shipping.TableRateShipping',1); /*!40000 ALTER TABLE `shipping_method` ENABLE KEYS */; -- -- Definition of table `specials` -- DROP TABLE IF EXISTS `specials`; CREATE TABLE `specials` ( `specials_id` int(11) NOT NULL auto_increment, `products_id` int(11) NOT NULL, `specials_new_products_price` decimal(15,4) NOT NULL, `specials_date_added` datetime default NULL, `specials_last_modified` datetime default NULL, `expires_date` datetime default NULL, `date_status_change` datetime default NULL, `status` tinyint(1) unsigned NOT NULL default '1', PRIMARY KEY (`specials_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `specials` -- /*!40000 ALTER TABLE `specials` DISABLE KEYS */; INSERT INTO `specials` (`specials_id`,`products_id`,`specials_new_products_price`,`specials_date_added`,`specials_last_modified`,`expires_date`,`date_status_change`,`status`) VALUES (1,3,'39.9900','2007-04-05 17:40:13',NULL,'2007-11-13 00:00:00',NULL,1), (2,20,'17.0000',NULL,NULL,'2008-01-09 00:00:00',NULL,1), (3,14,'1.9900',NULL,NULL,'2008-02-20 00:00:00',NULL,1), (4,17,'11.9900',NULL,NULL,'2008-02-20 00:00:00',NULL,1), (5,29,'23.0000',NULL,NULL,'2008-02-14 00:00:00',NULL,1), (6,1,'10.0000',NULL,NULL,'2007-12-31 00:00:00',NULL,1); /*!40000 ALTER TABLE `specials` ENABLE KEYS */; -- -- Definition of table `tax_class` -- DROP TABLE IF EXISTS `tax_class`; CREATE TABLE `tax_class` ( `tax_class_id` int(11) NOT NULL auto_increment, `tax_class_title` varchar(32) NOT NULL, `tax_class_description` varchar(255) NOT NULL, `last_modified` datetime default NULL, `date_added` datetime NOT NULL, PRIMARY KEY (`tax_class_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tax_class` -- /*!40000 ALTER TABLE `tax_class` DISABLE KEYS */; INSERT INTO `tax_class` (`tax_class_id`,`tax_class_title`,`tax_class_description`,`last_modified`,`date_added`) VALUES (1,'Taxable ','The following types of products are included non-food, services, etc','2007-05-12 22:07:30','2007-04-05 17:40:13'); /*!40000 ALTER TABLE `tax_class` ENABLE KEYS */; -- -- Definition of table `tax_rates` -- DROP TABLE IF EXISTS `tax_rates`; CREATE TABLE `tax_rates` ( `tax_rates_id` int(11) NOT NULL auto_increment, `tax_zone_id` int(11) NOT NULL, `tax_class_id` int(11) NOT NULL, `tax_priority` int(5) default '1', `tax_rate` decimal(7,4) NOT NULL, `tax_description` varchar(255) NOT NULL, `last_modified` datetime default NULL, `date_added` datetime NOT NULL, PRIMARY KEY (`tax_rates_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tax_rates` -- /*!40000 ALTER TABLE `tax_rates` DISABLE KEYS */; INSERT INTO `tax_rates` (`tax_rates_id`,`tax_zone_id`,`tax_class_id`,`tax_priority`,`tax_rate`,`tax_description`,`last_modified`,`date_added`) VALUES (3,1,1,2,'11.1000','tt','2007-11-19 16:33:42','2007-05-12 22:07:30'), (4,1,1,3,'7.0000','VAT',NULL,'2007-05-12 22:07:30'); /*!40000 ALTER TABLE `tax_rates` ENABLE KEYS */; -- -- Definition of table `whos_online` -- DROP TABLE IF EXISTS `whos_online`; CREATE TABLE `whos_online` ( `customer_id` int(11) default NULL, `full_name` varchar(64) NOT NULL, `session_id` varchar(128) NOT NULL, `ip_address` varchar(15) NOT NULL, `time_entry` varchar(14) NOT NULL, `time_last_click` varchar(14) NOT NULL, `last_page_url` varchar(255) NOT NULL, `id` int(10) unsigned NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `whos_online` -- /*!40000 ALTER TABLE `whos_online` DISABLE KEYS */; INSERT INTO `whos_online` (`customer_id`,`full_name`,`session_id`,`ip_address`,`time_entry`,`time_last_click`,`last_page_url`,`id`) VALUES (0,'Guest','4a08ca3e7199b4b4652a8446a03f2826','127.0.0.1','1175784044','1175784044','',0); /*!40000 ALTER TABLE `whos_online` ENABLE KEYS */; -- -- Definition of table `zones` -- DROP TABLE IF EXISTS `zones`; CREATE TABLE `zones` ( `zone_id` int(11) NOT NULL auto_increment, `zone_country_id` int(11) NOT NULL, `zone_code` varchar(32) NOT NULL, `zone_name` varchar(32) NOT NULL, PRIMARY KEY (`zone_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `zones` -- /*!40000 ALTER TABLE `zones` DISABLE KEYS */; INSERT INTO `zones` (`zone_id`,`zone_country_id`,`zone_code`,`zone_name`) VALUES (1,223,'AL','Alabama'), (2,223,'AK','Alaska'), (3,223,'AS','American Samoa'), (4,223,'AZ','Arizona'), (5,223,'AR','Arkansas'), (6,223,'AF','Armed Forces Africa'), (7,223,'AA','Armed Forces Americas'), (8,223,'AC','Armed Forces Canada'), (9,223,'AE','Armed Forces Europe'), (10,223,'AM','Armed Forces Middle East'), (11,223,'AP','Armed Forces Pacific'), (12,223,'CA','California'), (13,223,'CO','Colorado'), (14,223,'CT','Connecticut'), (15,223,'DE','Delaware'), (16,223,'DC','District of Columbia'), (17,223,'FM','Federated States Of Micronesia'), (18,223,'FL','Florida'), (19,223,'GA','Georgia'), (20,223,'GU','Guam'), (21,223,'HI','Hawaii'), (22,223,'ID','Idaho'), (23,223,'IL','Illinois'), (24,223,'IN','Indiana'), (25,223,'IA','Iowa'), (26,223,'KS','Kansas'), (27,223,'KY','Kentucky'), (28,223,'LA','Louisiana'), (29,223,'ME','Maine'), (30,223,'MH','Marshall Islands'), (31,223,'MD','Maryland'), (32,223,'MA','Massachusetts'); INSERT INTO `zones` (`zone_id`,`zone_country_id`,`zone_code`,`zone_name`) VALUES (33,223,'MI','Michigan'), (34,223,'MN','Minnesota'), (35,223,'MS','Mississippi'), (36,223,'MO','Missouri'), (37,223,'MT','Montana'), (38,223,'NE','Nebraska'), (39,223,'NV','Nevada'), (40,223,'NH','New Hampshire'), (41,223,'NJ','New Jersey'), (42,223,'NM','New Mexico'), (43,223,'NY','New York'), (44,223,'NC','North Carolina'), (45,223,'ND','North Dakota'), (46,223,'MP','Northern Mariana Islands'), (47,223,'OH','Ohio'), (48,223,'OK','Oklahoma'), (49,223,'OR','Oregon'), (50,223,'PW','Palau'), (51,223,'PA','Pennsylvania'), (52,223,'PR','Puerto Rico'), (53,223,'RI','Rhode Island'), (54,223,'SC','South Carolina'), (55,223,'SD','South Dakota'), (56,223,'TN','Tennessee'), (57,223,'TX','Texas'), (58,223,'UT','Utah'), (59,223,'VT','Vermont'), (60,223,'VI','Virgin Islands'), (61,223,'VA','Virginia'), (62,223,'WA','Washington'), (63,223,'WV','West Virginia'), (64,223,'WI','Wisconsin'), (65,223,'WY','Wyoming'); INSERT INTO `zones` (`zone_id`,`zone_country_id`,`zone_code`,`zone_name`) VALUES (66,38,'AB','Alberta'), (67,38,'BC','British Columbia'), (68,38,'MB','Manitoba'), (69,38,'NF','Newfoundland'), (70,38,'NB','New Brunswick'), (71,38,'NS','Nova Scotia'), (72,38,'NT','Northwest Territories'), (73,38,'NU','Nunavut'), (74,38,'ON','Ontario'), (75,38,'PE','Prince Edward Island'), (76,38,'QC','Quebec'), (77,38,'SK','Saskatchewan'), (78,38,'YT','Yukon Territory'), (79,81,'NDS','Niedersachsen'), (80,81,'BAW','Baden-Württemberg'), (81,81,'BAY','Bayern'), (82,81,'BER','Berlin'), (83,81,'BRG','Brandenburg'), (84,81,'BRE','Bremen'), (85,81,'HAM','Hamburg'), (86,81,'HES','Hessen'), (87,81,'MEC','Mecklenburg-Vorpommern'), (88,81,'NRW','Nordrhein-Westfalen'), (89,81,'RHE','Rheinland-Pfalz'), (90,81,'SAR','Saarland'), (91,81,'SAS','Sachsen'), (92,81,'SAC','Sachsen-Anhalt'), (93,81,'SCN','Schleswig-Holstein'), (94,81,'THE','Thüringen'), (95,14,'WI','Wien'), (96,14,'NO','Niederösterreich'), (97,14,'OO','Oberösterreich'); INSERT INTO `zones` (`zone_id`,`zone_country_id`,`zone_code`,`zone_name`) VALUES (99,14,'KN','Kärnten'), (100,14,'ST','Steiermark'), (102,14,'BL','Burgenland'), (104,204,'AG','Aargau'), (105,204,'AI','Appenzell Innerrhoden'), (106,204,'AR','Appenzell Ausserrhoden'), (107,204,'BE','Bern'), (108,204,'BL','Basel-Landschaft'), (109,204,'BS','Basel-Stadt'), (110,204,'FR','Freiburg'), (111,204,'GE','Genf'), (112,204,'GL','Glarus'), (113,204,'JU','Graubünden'), (114,204,'JU','Jura'), (115,204,'LU','Luzern'), (116,204,'NE','Neuenburg'), (117,204,'NW','Nidwalden'), (118,204,'OW','Obwalden'), (119,204,'SG','St. Gallen'), (120,204,'SH','Schaffhausen'), (121,204,'SO','Solothurn'), (122,204,'SZ','Schwyz'), (123,204,'TG','Thurgau'), (124,204,'TI','Tessin'), (125,204,'UR','Uri'), (126,204,'VD','Waadt'), (127,204,'VS','Wallis'), (128,204,'ZG','Zug'), (129,204,'ZH','Zürich'), (130,195,'A Coruña','A Coruña'), (131,195,'Alava','Alava'), (132,195,'Albacete','Albacete'), (133,195,'Alicante','Alicante'); INSERT INTO `zones` (`zone_id`,`zone_country_id`,`zone_code`,`zone_name`) VALUES (134,195,'Almeria','Almeria'), (135,195,'Asturias','Asturias'), (136,195,'Avila','Avila'), (137,195,'Badajoz','Badajoz'), (138,195,'Baleares','Baleares'), (139,195,'Barcelona','Barcelona'), (140,195,'Burgos','Burgos'), (141,195,'Caceres','Caceres'), (142,195,'Cadiz','Cadiz'), (143,195,'Cantabria','Cantabria'), (144,195,'Castellon','Castellon'), (145,195,'Ceuta','Ceuta'), (146,195,'Ciudad Real','Ciudad Real'), (147,195,'Cordoba','Cordoba'), (148,195,'Cuenca','Cuenca'), (149,195,'Girona','Girona'), (150,195,'Granada','Granada'), (151,195,'Guadalajara','Guadalajara'), (152,195,'Guipuzcoa','Guipuzcoa'), (153,195,'Huelva','Huelva'), (154,195,'Huesca','Huesca'), (155,195,'Jaen','Jaen'), (156,195,'La Rioja','La Rioja'), (157,195,'Las Palmas','Las Palmas'), (158,195,'Leon','Leon'), (159,195,'Lleida','Lleida'), (160,195,'Lugo','Lugo'), (161,195,'Madrid','Madrid'), (162,195,'Malaga','Malaga'), (163,195,'Melilla','Melilla'); INSERT INTO `zones` (`zone_id`,`zone_country_id`,`zone_code`,`zone_name`) VALUES (164,195,'Murcia','Murcia'), (165,195,'Navarra','Navarra'), (166,195,'Ourense','Ourense'), (167,195,'Palencia','Palencia'), (168,195,'Pontevedra','Pontevedra'), (169,195,'Salamanca','Salamanca'), (170,195,'Santa Cruz de Tenerife','Santa Cruz de Tenerife'), (171,195,'Segovia','Segovia'), (172,195,'Sevilla','Sevilla'), (173,195,'Soria','Soria'), (174,195,'Tarragona','Tarragona'), (175,195,'Teruel','Teruel'), (176,195,'Toledo','Toledo'), (177,195,'Valencia','Valencia'), (178,195,'Valladolid','Valladolid'), (179,195,'Vizcaya','Vizcaya'), (180,195,'Zamora','Zamora'), (181,195,'Zaragoza','Zaragoza'), (182,240,'HS','Haskovo'), (183,33,'SF','Sofia'); /*!40000 ALTER TABLE `zones` ENABLE KEYS */; -- -- Definition of table `zones_to_geo_zones` -- DROP TABLE IF EXISTS `zones_to_geo_zones`; CREATE TABLE `zones_to_geo_zones` ( `association_id` int(11) NOT NULL auto_increment, `zone_country_id` int(11) NOT NULL, `zone_id` int(11) default NULL, `geo_zone_id` int(11) default NULL, `last_modified` datetime default NULL, `date_added` datetime NOT NULL, PRIMARY KEY (`association_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `zones_to_geo_zones` -- /*!40000 ALTER TABLE `zones_to_geo_zones` DISABLE KEYS */; INSERT INTO `zones_to_geo_zones` (`association_id`,`zone_country_id`,`zone_id`,`geo_zone_id`,`last_modified`,`date_added`) VALUES (1,223,18,1,NULL,'2007-04-05 17:40:13'), (2,223,0,1,NULL,'2007-08-13 12:28:19'); /*!40000 ALTER TABLE `zones_to_geo_zones` ENABLE KEYS */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;