-- MySQL dump 9.11 -- -- Host: localhost Database: cart2 -- ------------------------------------------------------ -- Server version 4.0.25-nt-max -- -- Table structure for table `address_book` -- CREATE TABLE address_book ( address_book_id int(11) NOT NULL auto_increment, customers_id int(11) NOT NULL default '0', entry_gender char(1) NOT NULL default '', entry_company varchar(32) default NULL, entry_firstname varchar(32) NOT NULL default '', entry_lastname varchar(32) NOT NULL default '', entry_street_address varchar(64) NOT NULL default '', entry_suburb varchar(32) default NULL, entry_postcode varchar(10) NOT NULL default '', entry_city varchar(32) NOT NULL default '', entry_state varchar(32) default NULL, entry_country_id int(11) NOT NULL default '0', entry_zone_id int(11) NOT NULL default '0', PRIMARY KEY (address_book_id), KEY idx_address_book_customers_id (customers_id) ) TYPE=MyISAM; -- -- Dumping data for table `address_book` -- INSERT INTO address_book VALUES (17,15,'','','Evelyn','Ruiz','165 Newton St','','06450','Meriden','',223,14); INSERT INTO address_book VALUES (13,12,'','','Karen','Lindley','601 Country Club Road #123','','97401','Eugene','',223,49); INSERT INTO address_book VALUES (14,12,'','','Karen','Lindley','4897 Elderberry Loop','','97478','Springfield','',223,49); INSERT INTO address_book VALUES (15,13,'','Ultimate Water Massage','Karen','Sloan','PO Box 609','','98382','Sequim','',223,62); INSERT INTO address_book VALUES (16,14,'','','cheryl','thompson','17805 n. dunn rd.','','99005','colbert','',223,62); INSERT INTO address_book VALUES (11,11,'','','Tarun','Kumar','testing','','12345','testing','testing',125,0); INSERT INTO address_book VALUES (12,2,'','','John','Robben','523 N. Dunlap','','98382','Sequim','',223,62); -- -- Table structure for table `address_format` -- CREATE TABLE address_format ( address_format_id int(11) NOT NULL auto_increment, address_format varchar(128) NOT NULL default '', address_summary varchar(48) NOT NULL default '', PRIMARY KEY (address_format_id) ) TYPE=MyISAM; -- -- Dumping data for table `address_format` -- INSERT INTO address_format VALUES (1,'$firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country','$city / $country'); INSERT INTO address_format VALUES (2,'$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country','$city, $state / $country'); INSERT INTO address_format VALUES (3,'$firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country','$state / $country'); INSERT INTO address_format VALUES (4,'$firstname $lastname$cr$streets$cr$city ($postcode)$cr$country','$postcode / $country'); INSERT INTO address_format VALUES (5,'$firstname $lastname$cr$streets$cr$postcode $city$cr$country','$city / $country'); -- -- Table structure for table `banners` -- CREATE TABLE banners ( banners_id int(11) NOT NULL auto_increment, banners_title varchar(64) NOT NULL default '', banners_url varchar(255) NOT NULL default '', banners_image varchar(64) NOT NULL default '', banners_group varchar(10) NOT NULL default '', banners_html_text text, expires_impressions int(7) default '0', expires_date datetime default NULL, date_scheduled datetime default NULL, date_added datetime NOT NULL default '0000-00-00 00:00:00', date_status_change datetime default NULL, status int(1) NOT NULL default '1', PRIMARY KEY (banners_id) ) TYPE=MyISAM; -- -- Dumping data for table `banners` -- INSERT INTO banners VALUES (1,'osCommerce','http://www.oscommerce.com','banners/oscommerce.gif','468x50','',0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2005-08-11 14:56:10','2005-11-21 10:30:25',0); -- -- Table structure for table `banners_history` -- CREATE TABLE banners_history ( banners_history_id int(11) NOT NULL auto_increment, banners_id int(11) NOT NULL default '0', banners_shown int(5) NOT NULL default '0', banners_clicked int(5) NOT NULL default '0', banners_history_date datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (banners_history_id) ) TYPE=MyISAM; -- -- Dumping data for table `banners_history` -- INSERT INTO banners_history VALUES (1,1,1,0,'2005-11-21 10:27:27'); -- -- Table structure for table `categories` -- CREATE TABLE categories ( categories_id int(11) NOT NULL auto_increment, categories_image varchar(64) default NULL, parent_id int(11) NOT NULL default '0', sort_order int(3) default NULL, date_added datetime default NULL, last_modified datetime default NULL, PRIMARY KEY (categories_id), KEY idx_categories_parent_id (parent_id) ) TYPE=MyISAM; -- -- Dumping data for table `categories` -- INSERT INTO categories VALUES (24,'buckwheat-mt-neckwrap_tnail.jpg',23,0,'2005-12-17 16:54:05','2006-02-11 13:43:34'); INSERT INTO categories VALUES (23,'hc-shoulder-fan-moon_tnail.jpg',0,0,'2005-12-17 16:54:05','2006-02-11 12:07:42'); INSERT INTO categories VALUES (20,'buckwheat_pillow_displayed.jpg',0,0,'2005-12-17 16:54:05','2006-02-09 22:32:04'); INSERT INTO categories VALUES (21,'MIL_CHO108counter coup5_tnail.jpg',220,0,'2005-12-17 16:54:05','2006-02-11 17:12:28'); INSERT INTO categories VALUES (22,'',21,0,'2005-12-17 16:54:05','2005-12-17 16:54:05'); INSERT INTO categories VALUES (12,'al-oil-bottle_tnail.jpg',0,0,'2005-12-17 16:54:04','2006-02-11 12:02:05'); INSERT INTO categories VALUES (14,'chienergizer_tnail.jpg',0,0,'2005-12-17 16:54:04','2006-02-11 12:01:35'); INSERT INTO categories VALUES (15,'bci-brace-woman_200.jpg',220,0,'2005-12-17 16:54:04','2006-02-11 17:20:37'); INSERT INTO categories VALUES (16,'',15,0,'2005-12-17 16:54:04','2005-12-17 16:54:04'); INSERT INTO categories VALUES (17,'traction-air-necksoft7_tnail.jpg',0,0,'2005-12-17 16:54:05','2006-02-11 13:24:56'); INSERT INTO categories VALUES (18,'mil-obus-lowback_tnail.jpg',220,0,'2005-12-17 16:54:05','2006-02-11 17:18:39'); INSERT INTO categories VALUES (19,'mil-chrioflow-pillow-person_tnail.jpg',220,0,'2005-12-17 16:54:05','2006-02-11 17:17:17'); INSERT INTO categories VALUES (1,'body-rub-chrio_small.jpg',0,0,'2005-12-17 16:54:03','2006-02-11 12:55:48'); INSERT INTO categories VALUES (2,'green-tea-3-box_tnail.jpg',0,0,'2005-12-17 16:54:03','2006-02-11 12:02:44'); INSERT INTO categories VALUES (3,'bathtub-pedals.jpg',220,0,'2005-12-17 16:54:03','2006-02-11 17:26:03'); INSERT INTO categories VALUES (4,'pp-vibrassage-spinal.jpg',0,0,'2005-12-17 16:54:03','2006-02-11 12:22:59'); INSERT INTO categories VALUES (5,'kk-glide-foot.jpg',4,0,'2005-12-17 16:54:03','2006-02-11 13:53:09'); INSERT INTO categories VALUES (7,'rs-dual-wood-roller_tnail.jpg',4,0,'2005-12-17 16:54:04','2006-02-11 13:50:25'); INSERT INTO categories VALUES (8,'rs-hand-wizard-vibration-2_tnail.jpg',4,0,'2005-12-17 16:54:04','2006-02-11 13:51:47'); INSERT INTO categories VALUES (9,'reflexology-excerise-mat_tnail.jpg',0,0,'2005-12-17 16:54:04','2006-02-11 13:05:44'); INSERT INTO categories VALUES (10,'spa-therabath-hand_tnail.jpg',0,0,'2005-12-17 16:54:04','2006-02-11 12:16:28'); INSERT INTO categories VALUES (11,'al-oil-bottle_tnail.jpg',0,0,'2005-12-17 16:54:04','2006-02-11 12:06:05'); INSERT INTO categories VALUES (25,'hc-eye-pillow_tnail.jpg',23,0,'2005-12-17 16:54:06','2006-02-11 13:31:44'); INSERT INTO categories VALUES (26,'hc-ultimate-vest_tnail.jpg',23,0,'2005-12-17 16:54:06','2006-02-11 13:42:37'); INSERT INTO categories VALUES (27,'hc-verybig-pack_tnail.jpg',23,0,'2005-12-17 16:54:06','2006-02-11 13:32:55'); INSERT INTO categories VALUES (28,'',219,0,'2005-12-17 16:54:06','2006-02-06 18:17:32'); INSERT INTO categories VALUES (29,'',28,0,'2005-12-17 16:54:06','2005-12-17 16:54:06'); INSERT INTO categories VALUES (30,'',21,0,'2005-12-17 16:54:06','2005-12-17 16:54:06'); INSERT INTO categories VALUES (31,'',21,0,'2005-12-17 16:54:06','2005-12-17 16:54:06'); INSERT INTO categories VALUES (32,'',219,0,'2005-12-17 16:54:06','2006-02-01 12:12:17'); INSERT INTO categories VALUES (33,'',32,0,'2005-12-17 16:54:06','2005-12-17 16:54:06'); INSERT INTO categories VALUES (34,'',219,0,'2005-12-17 16:54:06','2006-02-01 11:58:51'); INSERT INTO categories VALUES (35,'',34,0,'2005-12-17 16:54:06','2005-12-17 16:54:06'); INSERT INTO categories VALUES (36,'',35,0,'2005-12-17 16:54:06','2005-12-17 16:54:06'); INSERT INTO categories VALUES (37,'',21,0,'2005-12-17 16:54:06','2005-12-17 16:54:06'); INSERT INTO categories VALUES (38,'',21,0,'2005-12-17 16:54:06','2005-12-17 16:54:06'); INSERT INTO categories VALUES (39,'',21,0,'2005-12-17 16:54:06','2005-12-17 16:54:06'); INSERT INTO categories VALUES (40,'',21,0,'2005-12-17 16:54:06','2005-12-17 16:54:06'); INSERT INTO categories VALUES (41,'dt-travel-pillow_tnail.jpg',23,0,'2005-12-17 16:54:06','2006-02-11 13:30:18'); INSERT INTO categories VALUES (42,'',18,0,'2005-12-17 16:54:06','2006-02-01 12:19:14'); INSERT INTO categories VALUES (43,'',42,0,'2005-12-17 16:54:06','2005-12-17 16:54:06'); INSERT INTO categories VALUES (44,'',28,0,'2005-12-17 16:54:06','2005-12-17 16:54:06'); INSERT INTO categories VALUES (45,'',28,0,'2005-12-17 16:54:06','2005-12-17 16:54:06'); INSERT INTO categories VALUES (46,'',219,0,'2005-12-17 16:54:06','2006-02-01 12:07:52'); INSERT INTO categories VALUES (47,'',46,0,'2005-12-17 16:54:06','2005-12-17 16:54:06'); INSERT INTO categories VALUES (48,'',42,0,'2005-12-17 16:54:06','2005-12-17 16:54:06'); INSERT INTO categories VALUES (49,'VAL169_tnail.jpg',220,0,'2005-12-17 16:54:06','2006-02-11 17:16:27'); INSERT INTO categories VALUES (50,'',49,0,'2005-12-17 16:54:06','2005-12-17 16:54:06'); INSERT INTO categories VALUES (51,'',219,0,'2005-12-17 16:54:06','2006-02-01 12:14:22'); INSERT INTO categories VALUES (52,'',51,0,'2005-12-17 16:54:06','2005-12-17 16:54:06'); INSERT INTO categories VALUES (53,'',219,0,'2005-12-17 16:54:06','2006-02-01 11:58:06'); INSERT INTO categories VALUES (54,'',53,0,'2005-12-17 16:54:06','2005-12-17 16:54:06'); INSERT INTO categories VALUES (55,'',85,0,'2005-12-17 16:54:07','2006-02-01 12:13:15'); INSERT INTO categories VALUES (56,'',55,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (57,'',21,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (58,'',85,0,'2005-12-17 16:54:07','2006-02-01 12:12:48'); INSERT INTO categories VALUES (59,'',58,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (60,'',219,0,'2005-12-17 16:54:07','2006-02-01 12:03:56'); INSERT INTO categories VALUES (61,'',60,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (62,'',219,0,'2005-12-17 16:54:07','2006-02-01 11:56:47'); INSERT INTO categories VALUES (63,'',62,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (64,'',46,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (65,'',51,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (66,'',219,0,'2005-12-17 16:54:07','2006-02-01 12:05:50'); INSERT INTO categories VALUES (67,'',66,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (68,'',66,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (69,'',21,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (70,'',58,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (71,'',66,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (72,'',55,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (73,'',85,0,'2005-12-17 16:54:07','2006-02-01 12:15:54'); INSERT INTO categories VALUES (74,'',73,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (75,'',28,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (76,'',58,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (77,'',157,0,'2005-12-17 16:54:07','2006-02-01 12:10:25'); INSERT INTO categories VALUES (78,'',77,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (79,'',60,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (80,'',219,0,'2005-12-17 16:54:07','2006-02-01 12:01:40'); INSERT INTO categories VALUES (81,'',80,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (82,'',157,0,'2005-12-17 16:54:07','2006-02-01 12:11:43'); INSERT INTO categories VALUES (83,'',82,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (84,'',62,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (85,'',219,0,'2005-12-17 16:54:07','2006-02-06 18:16:49'); INSERT INTO categories VALUES (86,'',85,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (87,'',219,0,'2005-12-17 16:54:07','2006-02-01 12:00:17'); INSERT INTO categories VALUES (88,'',87,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (89,'',219,0,'2005-12-17 16:54:07','2006-02-01 12:05:08'); INSERT INTO categories VALUES (90,'',89,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (91,'',89,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (92,'',85,0,'2005-12-17 16:54:07','2006-02-01 12:15:18'); INSERT INTO categories VALUES (93,'',92,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (94,'',82,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (95,'',77,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (96,'',46,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (97,'',85,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (98,'',66,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (99,'',58,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (100,'',157,0,'2005-12-17 16:54:07','2006-02-01 11:47:51'); INSERT INTO categories VALUES (101,'',100,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (102,'',219,0,'2005-12-17 16:54:07','2006-02-01 12:08:55'); INSERT INTO categories VALUES (103,'',102,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (104,'',62,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (105,'',157,0,'2005-12-17 16:54:07','2006-02-01 12:11:10'); INSERT INTO categories VALUES (106,'',105,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (107,'',66,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (108,'',89,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (109,'',73,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (110,'',105,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (111,'',105,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (112,'',62,0,'2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO categories VALUES (113,'',102,0,'2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO categories VALUES (114,'',102,0,'2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO categories VALUES (115,'',102,0,'2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO categories VALUES (116,'',102,0,'2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO categories VALUES (117,'',32,0,'2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO categories VALUES (118,'',60,0,'2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO categories VALUES (119,'mil-rehab-icy-blue-coolant_tnail.jpg',220,0,'2005-12-17 16:54:08','2006-02-11 17:15:46'); INSERT INTO categories VALUES (120,'',119,0,'2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO categories VALUES (121,'',119,0,'2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO categories VALUES (122,'',62,0,'2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO categories VALUES (123,'',85,0,'2005-12-17 16:54:08','2005-12-18 15:26:04'); INSERT INTO categories VALUES (124,'',123,0,'2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO categories VALUES (125,'',123,0,'2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO categories VALUES (126,'',123,0,'2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO categories VALUES (127,'',51,0,'2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO categories VALUES (128,'',119,0,'2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO categories VALUES (129,'',60,0,'2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO categories VALUES (130,'',51,0,'2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO categories VALUES (131,'',102,0,'2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO categories VALUES (132,'',102,0,'2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO categories VALUES (133,'',102,0,'2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO categories VALUES (134,'',60,0,'2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO categories VALUES (135,'',66,0,'2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO categories VALUES (136,'',46,0,'2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO categories VALUES (137,'',62,0,'2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO categories VALUES (138,'',21,0,'2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO categories VALUES (139,'',15,0,'2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO categories VALUES (140,'',85,0,'2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO categories VALUES (141,'',77,0,'2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO categories VALUES (142,'',80,0,'2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO categories VALUES (143,'',80,0,'2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO categories VALUES (144,'',80,0,'2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO categories VALUES (145,'',105,0,'2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO categories VALUES (146,'',105,0,'2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO categories VALUES (147,'',85,0,'2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO categories VALUES (148,'',28,0,'2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO categories VALUES (149,'',157,0,'2005-12-17 16:54:09','2006-02-01 11:54:20'); INSERT INTO categories VALUES (150,'',149,0,'2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO categories VALUES (151,'',157,0,'2005-12-17 16:54:09','2006-02-01 11:59:34'); INSERT INTO categories VALUES (152,'',151,0,'2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO categories VALUES (153,'',73,0,'2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO categories VALUES (154,'',32,0,'2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO categories VALUES (155,'',53,0,'2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO categories VALUES (156,'',32,0,'2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO categories VALUES (157,'',219,0,'2005-12-17 16:54:09','2006-02-11 13:25:28'); INSERT INTO categories VALUES (158,'',157,0,'2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO categories VALUES (159,'',89,0,'2005-12-17 16:54:10','2005-12-17 16:54:10'); INSERT INTO categories VALUES (160,'',32,0,'2005-12-17 16:54:10','2005-12-17 16:54:10'); INSERT INTO categories VALUES (161,'',32,0,'2005-12-17 16:54:10','2005-12-17 16:54:10'); INSERT INTO categories VALUES (162,'',62,0,'2005-12-17 16:54:10','2005-12-17 16:54:10'); INSERT INTO categories VALUES (163,'',32,0,'2005-12-17 16:54:10','2005-12-17 16:54:10'); INSERT INTO categories VALUES (164,'',102,0,'2005-12-17 16:54:10','2005-12-17 16:54:10'); INSERT INTO categories VALUES (165,'',82,0,'2005-12-17 16:54:10','2005-12-17 16:54:10'); INSERT INTO categories VALUES (166,'',77,0,'2005-12-17 16:54:10','2005-12-17 16:54:10'); INSERT INTO categories VALUES (167,'',62,0,'2005-12-17 16:54:10','2005-12-17 16:54:10'); INSERT INTO categories VALUES (168,'',219,0,'2005-12-17 16:54:10','2006-02-01 12:07:14'); INSERT INTO categories VALUES (169,'',168,0,'2005-12-17 16:54:10','2005-12-17 16:54:10'); INSERT INTO categories VALUES (170,'',168,0,'2005-12-17 16:54:10','2005-12-17 16:54:10'); INSERT INTO categories VALUES (171,'',58,0,'2005-12-17 16:54:10','2005-12-17 16:54:10'); INSERT INTO categories VALUES (172,'',49,0,'2005-12-17 16:54:10','2005-12-17 16:54:10'); INSERT INTO categories VALUES (173,'',219,0,'2005-12-17 16:54:10','2006-02-01 12:04:33'); INSERT INTO categories VALUES (174,'',173,0,'2005-12-17 16:54:10','2005-12-17 16:54:10'); INSERT INTO categories VALUES (175,'',73,0,'2005-12-17 16:54:10','2005-12-17 16:54:10'); INSERT INTO categories VALUES (176,'',66,0,'2005-12-17 16:54:10','2005-12-17 16:54:10'); INSERT INTO categories VALUES (177,'',77,0,'2005-12-17 16:54:10','2005-12-17 16:54:10'); INSERT INTO categories VALUES (178,'',123,0,'2005-12-17 16:54:10','2005-12-17 16:54:10'); INSERT INTO categories VALUES (179,'',73,0,'2005-12-17 16:54:11','2005-12-17 16:54:11'); INSERT INTO categories VALUES (180,'',55,0,'2005-12-17 16:54:11','2005-12-17 16:54:11'); INSERT INTO categories VALUES (181,'',123,0,'2005-12-17 16:54:11','2005-12-17 16:54:11'); INSERT INTO categories VALUES (182,'',73,0,'2005-12-17 16:54:11','2005-12-17 16:54:11'); INSERT INTO categories VALUES (183,'',85,0,'2005-12-17 16:54:11','2006-02-01 12:06:23'); INSERT INTO categories VALUES (184,'',183,0,'2005-12-17 16:54:11','2005-12-17 16:54:11'); INSERT INTO categories VALUES (185,'',123,0,'2005-12-17 16:54:11','2005-12-17 16:54:11'); INSERT INTO categories VALUES (186,'',55,0,'2005-12-17 16:54:12','2005-12-17 16:54:12'); INSERT INTO categories VALUES (187,'',32,0,'2005-12-17 16:54:12','2005-12-17 16:54:12'); INSERT INTO categories VALUES (188,'',60,0,'2005-12-17 16:54:12','2005-12-17 16:54:12'); INSERT INTO categories VALUES (189,'',60,0,'2005-12-17 16:54:12','2005-12-17 16:54:12'); INSERT INTO categories VALUES (190,'',60,0,'2005-12-17 16:54:12','2005-12-17 16:54:12'); INSERT INTO categories VALUES (191,'',60,0,'2005-12-17 16:54:12','2005-12-17 16:54:12'); INSERT INTO categories VALUES (192,'',46,0,'2005-12-17 16:54:12','2005-12-17 16:54:12'); INSERT INTO categories VALUES (193,'',66,0,'2005-12-17 16:54:12','2005-12-17 16:54:12'); INSERT INTO categories VALUES (194,'',149,0,'2005-12-17 16:54:13','2005-12-17 16:54:13'); INSERT INTO categories VALUES (195,'',21,0,'2005-12-17 16:54:13','2005-12-17 16:54:13'); INSERT INTO categories VALUES (196,'',77,0,'2005-12-17 16:54:13','2005-12-17 16:54:13'); INSERT INTO categories VALUES (197,'',66,0,'2005-12-17 16:54:14','2005-12-17 16:54:14'); INSERT INTO categories VALUES (198,'',82,0,'2005-12-17 16:54:14','2005-12-17 16:54:14'); INSERT INTO categories VALUES (199,'',219,0,'2005-12-17 16:54:14','2006-02-01 12:00:57'); INSERT INTO categories VALUES (200,'',199,0,'2005-12-17 16:54:14','2005-12-17 16:54:14'); INSERT INTO categories VALUES (201,'',66,0,'2005-12-17 16:54:14','2005-12-17 16:54:14'); INSERT INTO categories VALUES (202,'',199,0,'2005-12-17 16:54:15','2005-12-17 16:54:15'); INSERT INTO categories VALUES (203,'vita-aller-7_tnail.jpg',220,0,'2005-12-17 16:54:15','2006-02-11 17:21:10'); INSERT INTO categories VALUES (204,'',203,0,'2005-12-17 16:54:15','2005-12-17 16:54:15'); INSERT INTO categories VALUES (205,'',203,0,'2005-12-17 16:54:15','2005-12-17 16:54:15'); INSERT INTO categories VALUES (206,'',203,0,'2005-12-17 16:54:15','2005-12-17 16:54:15'); INSERT INTO categories VALUES (207,'',203,0,'2005-12-17 16:54:15','2005-12-17 16:54:15'); INSERT INTO categories VALUES (208,'',203,0,'2005-12-17 16:54:15','2005-12-17 16:54:15'); INSERT INTO categories VALUES (209,'',203,0,'2005-12-17 16:54:15','2005-12-17 16:54:15'); INSERT INTO categories VALUES (210,'',203,0,'2005-12-17 16:54:15','2005-12-17 16:54:15'); INSERT INTO categories VALUES (211,'',203,0,'2005-12-17 16:54:15','2005-12-17 16:54:15'); INSERT INTO categories VALUES (212,'',203,0,'2005-12-17 16:54:16','2005-12-17 16:54:16'); INSERT INTO categories VALUES (213,'',203,0,'2005-12-17 16:54:16','2005-12-17 16:54:16'); INSERT INTO categories VALUES (214,'',203,0,'2005-12-17 16:54:16','2005-12-17 16:54:16'); INSERT INTO categories VALUES (215,'',203,0,'2005-12-17 16:54:16','2005-12-17 16:54:16'); INSERT INTO categories VALUES (216,'',203,0,'2005-12-17 16:54:16','2005-12-17 16:54:16'); INSERT INTO categories VALUES (217,'',203,0,'2005-12-17 16:54:16','2005-12-17 16:54:16'); INSERT INTO categories VALUES (218,'',203,0,'2005-12-17 16:54:16','2005-12-17 16:54:16'); INSERT INTO categories VALUES (219,'ISG20G1319_tnail.jpg',220,0,'2006-02-01 11:55:54','2006-02-11 17:11:52'); INSERT INTO categories VALUES (220,'thera-band-exercise-ball-sit_tnail.jpg',0,0,'2006-02-11 17:11:15',NULL); -- -- Table structure for table `categories_description` -- CREATE TABLE categories_description ( categories_id int(11) NOT NULL default '0', language_id int(11) NOT NULL default '1', categories_name varchar(32) NOT NULL default '', PRIMARY KEY (categories_id,language_id), KEY idx_categories_name (categories_name) ) TYPE=MyISAM; -- -- Dumping data for table `categories_description` -- INSERT INTO categories_description VALUES (32,1,'Wound Care'); INSERT INTO categories_description VALUES (1,1,'Massagers - Electric'); INSERT INTO categories_description VALUES (2,1,'Green Tea'); INSERT INTO categories_description VALUES (3,1,'Bath and Body'); INSERT INTO categories_description VALUES (4,1,'Massage Tools'); INSERT INTO categories_description VALUES (5,1,'Hand Massage Tools'); INSERT INTO categories_description VALUES (219,1,'Home Health Care'); INSERT INTO categories_description VALUES (7,1,'Wooden Massagers'); INSERT INTO categories_description VALUES (8,1,'Vibrating Massagers'); INSERT INTO categories_description VALUES (9,1,'Reflexology'); INSERT INTO categories_description VALUES (10,1,'Home Spa'); INSERT INTO categories_description VALUES (11,1,'Aromatherapy'); INSERT INTO categories_description VALUES (12,1,'Essential Oils'); INSERT INTO categories_description VALUES (14,1,'Chi Machines'); INSERT INTO categories_description VALUES (15,1,'Back & Neck Supports'); INSERT INTO categories_description VALUES (16,1,'Neck Supports'); INSERT INTO categories_description VALUES (17,1,'Traction'); INSERT INTO categories_description VALUES (18,1,'Sitting & Chair Supports'); INSERT INTO categories_description VALUES (19,1,'Pillows'); INSERT INTO categories_description VALUES (20,1,'Buckwheat Pillows'); INSERT INTO categories_description VALUES (21,1,'Limb Braces & Splints'); INSERT INTO categories_description VALUES (22,1,'Orthopedic Misc'); INSERT INTO categories_description VALUES (23,1,'Herbal Heat Packs'); INSERT INTO categories_description VALUES (24,1,'Unscented Heat Packs'); INSERT INTO categories_description VALUES (25,1,'Eye Pillows'); INSERT INTO categories_description VALUES (26,1,'Shoulder Heat Wraps'); INSERT INTO categories_description VALUES (27,1,'Rest of the Body'); INSERT INTO categories_description VALUES (28,1,'Diabetic Supplies'); INSERT INTO categories_description VALUES (29,1,'Diabetic Misc'); INSERT INTO categories_description VALUES (30,1,'Supports for your Wrist and Elbo'); INSERT INTO categories_description VALUES (31,1,'Supports for your Wrist and Elbo'); INSERT INTO categories_description VALUES (33,1,'Bandaids'); INSERT INTO categories_description VALUES (34,1,'Invacare Supply Group'); INSERT INTO categories_description VALUES (35,1,'Wound Care'); INSERT INTO categories_description VALUES (36,1,'Bandaids'); INSERT INTO categories_description VALUES (37,1,'Knee/Thigh/Hip Supports'); INSERT INTO categories_description VALUES (38,1,'Foot and Ankle'); INSERT INTO categories_description VALUES (39,1,'Supports for your Wrist and Elbo'); INSERT INTO categories_description VALUES (40,1,'Neck/Shoulder Supports'); INSERT INTO categories_description VALUES (41,1,'DreamTime'); INSERT INTO categories_description VALUES (42,1,'Seating/Cushions'); INSERT INTO categories_description VALUES (43,1,'Wheelchair Cushions'); INSERT INTO categories_description VALUES (44,1,'Strips'); INSERT INTO categories_description VALUES (45,1,'Meters'); INSERT INTO categories_description VALUES (46,1,'Home Diagnostics'); INSERT INTO categories_description VALUES (47,1,'Blood Pressure Products'); INSERT INTO categories_description VALUES (48,1,'Uplift Seating'); INSERT INTO categories_description VALUES (49,1,'Physical Therapy & Training'); INSERT INTO categories_description VALUES (50,1,'Strength Training'); INSERT INTO categories_description VALUES (51,1,'Skin Care'); INSERT INTO categories_description VALUES (52,1,'Creams Lotions Powders'); INSERT INTO categories_description VALUES (53,1,'Infusion/Iv Supplies'); INSERT INTO categories_description VALUES (54,1,'Iv Poles'); INSERT INTO categories_description VALUES (55,1,'Wheelchairs/Acc'); INSERT INTO categories_description VALUES (56,1,'Wheelchair Acc/Misc'); INSERT INTO categories_description VALUES (57,1,'Supports for your Wrist and Elbo'); INSERT INTO categories_description VALUES (58,1,'Walking Aids'); INSERT INTO categories_description VALUES (59,1,'Rollators/Acc'); INSERT INTO categories_description VALUES (60,1,'Ostomy'); INSERT INTO categories_description VALUES (61,1,'Cleaners/Deodorants'); INSERT INTO categories_description VALUES (62,1,'Incontinence'); INSERT INTO categories_description VALUES (63,1,'Incontinence Misc'); INSERT INTO categories_description VALUES (64,1,'Thermometers'); INSERT INTO categories_description VALUES (65,1,'Barrier Products'); INSERT INTO categories_description VALUES (66,1,'Respiratory'); INSERT INTO categories_description VALUES (67,1,'Resp Misc'); INSERT INTO categories_description VALUES (68,1,'Cpap/Bipap/Acc'); INSERT INTO categories_description VALUES (69,1,'Neck/Back Pillows'); INSERT INTO categories_description VALUES (70,1,'Canes/Acc'); INSERT INTO categories_description VALUES (71,1,'Compressors/Nebs/Acc'); INSERT INTO categories_description VALUES (72,1,'Transport Chairs'); INSERT INTO categories_description VALUES (73,1,'Bedroom Aids'); INSERT INTO categories_description VALUES (74,1,'Beds/Misc'); INSERT INTO categories_description VALUES (75,1,'Lancets & Lancet Device'); INSERT INTO categories_description VALUES (76,1,'Crutches/Acc'); INSERT INTO categories_description VALUES (77,1,'Tracheostomy Care'); INSERT INTO categories_description VALUES (78,1,'Trach Tubes'); INSERT INTO categories_description VALUES (79,1,'Pastes Powders/Rings'); INSERT INTO categories_description VALUES (80,1,'Nutrition Supp / Feeding Aids'); INSERT INTO categories_description VALUES (81,1,'Nutritional Supplements'); INSERT INTO categories_description VALUES (82,1,'Urological Catheters'); INSERT INTO categories_description VALUES (83,1,'Foley'); INSERT INTO categories_description VALUES (84,1,'Briefs, Disp'); INSERT INTO categories_description VALUES (85,1,'Aids To Daily Living'); INSERT INTO categories_description VALUES (86,1,'Oral Care'); INSERT INTO categories_description VALUES (87,1,'Medications/Otc'); INSERT INTO categories_description VALUES (88,1,'Enemas/Suppositories'); INSERT INTO categories_description VALUES (89,1,'Personal Protect/Gloves'); INSERT INTO categories_description VALUES (90,1,'Gloves & Hand Sanitizers'); INSERT INTO categories_description VALUES (91,1,'Protective Wear'); INSERT INTO categories_description VALUES (92,1,'Women\'s/Infant Products'); INSERT INTO categories_description VALUES (93,1,'Breast Pumps/Acc'); INSERT INTO categories_description VALUES (94,1,'External Nonlatex'); INSERT INTO categories_description VALUES (95,1,'Trach Humidification'); INSERT INTO categories_description VALUES (96,1,'Home Diagnostics Misc'); INSERT INTO categories_description VALUES (97,1,'Medication Helpers'); INSERT INTO categories_description VALUES (98,1,'Concentrators/Acc'); INSERT INTO categories_description VALUES (99,1,'Walkers/Acc'); INSERT INTO categories_description VALUES (100,1,'Prescription'); INSERT INTO categories_description VALUES (101,1,'Tens/Ems/Electrotherapy'); INSERT INTO categories_description VALUES (102,1,'Specialty Wound Care'); INSERT INTO categories_description VALUES (103,1,'Composite Drsg'); INSERT INTO categories_description VALUES (104,1,'Liners/Pads, Disp'); INSERT INTO categories_description VALUES (105,1,'Urol Collection Devices'); INSERT INTO categories_description VALUES (106,1,'Room Deodorizers'); INSERT INTO categories_description VALUES (107,1,'Cylinders Regulators/Ac'); INSERT INTO categories_description VALUES (108,1,'Preps/Disinectants'); INSERT INTO categories_description VALUES (109,1,'Pressure Relief Surface'); INSERT INTO categories_description VALUES (110,1,'Urological Misc'); INSERT INTO categories_description VALUES (111,1,'Bedside Drainage'); INSERT INTO categories_description VALUES (112,1,'Bed Wetting Devices'); INSERT INTO categories_description VALUES (113,1,'Collagen/Silicone'); INSERT INTO categories_description VALUES (114,1,'Compression Bandages'); INSERT INTO categories_description VALUES (115,1,'Absorbers'); INSERT INTO categories_description VALUES (116,1,'Hydrocolloid Drsg'); INSERT INTO categories_description VALUES (117,1,'Core Wound Misc'); INSERT INTO categories_description VALUES (118,1,'Ostomy Acc'); INSERT INTO categories_description VALUES (119,1,'Pain Management'); INSERT INTO categories_description VALUES (120,1,'Pain Management Misc'); INSERT INTO categories_description VALUES (121,1,'Electrodes'); INSERT INTO categories_description VALUES (122,1,'Undergarment, Disp'); INSERT INTO categories_description VALUES (123,1,'Bathroom Safety'); INSERT INTO categories_description VALUES (124,1,'Transfer Benches/Acc'); INSERT INTO categories_description VALUES (125,1,'Bath Benches/Shwr Chair'); INSERT INTO categories_description VALUES (126,1,'Commodes/Acc'); INSERT INTO categories_description VALUES (127,1,'Skin Pressure Protectio'); INSERT INTO categories_description VALUES (128,1,'Hot/Cold Therapy'); INSERT INTO categories_description VALUES (129,1,'Irrig Items'); INSERT INTO categories_description VALUES (130,1,'Perineal/Skin Cleaners'); INSERT INTO categories_description VALUES (131,1,'Foam Drsg'); INSERT INTO categories_description VALUES (132,1,'Hydrogels'); INSERT INTO categories_description VALUES (133,1,'Wound Cleansers'); INSERT INTO categories_description VALUES (134,1,'1-Piece Drainable'); INSERT INTO categories_description VALUES (135,1,'Disp Oxygen Products'); INSERT INTO categories_description VALUES (136,1,'Scales'); INSERT INTO categories_description VALUES (137,1,'Pants/Briefs, Reusable'); INSERT INTO categories_description VALUES (138,1,'Supports for your Wrist and Elbo'); INSERT INTO categories_description VALUES (139,1,'Back/Abdominal Supports'); INSERT INTO categories_description VALUES (140,1,'Aids To Daily Lving Mis'); INSERT INTO categories_description VALUES (141,1,'Trach Misc'); INSERT INTO categories_description VALUES (142,1,'Feeding Bags/Pump Sets'); INSERT INTO categories_description VALUES (143,1,'Feeding Pumps'); INSERT INTO categories_description VALUES (144,1,'Feeding Tubes'); INSERT INTO categories_description VALUES (145,1,'Leg Bags, Disp'); INSERT INTO categories_description VALUES (146,1,'Urinals/Bedpans'); INSERT INTO categories_description VALUES (147,1,'Activity Helpers'); INSERT INTO categories_description VALUES (148,1,'Insulin Products'); INSERT INTO categories_description VALUES (149,1,'Impotence'); INSERT INTO categories_description VALUES (150,1,'Vacuum Pumps'); INSERT INTO categories_description VALUES (151,1,'Lymphedema Pumps/Acc'); INSERT INTO categories_description VALUES (152,1,'Lymphedema Pumps'); INSERT INTO categories_description VALUES (153,1,'Bed Rails/Bed Rail Pads'); INSERT INTO categories_description VALUES (154,1,'Nonadherent Pads'); INSERT INTO categories_description VALUES (155,1,'Iv Dressings'); INSERT INTO categories_description VALUES (156,1,'Tapes/Adherent Wraps'); INSERT INTO categories_description VALUES (157,1,'Prof Use And Diagnostic'); INSERT INTO categories_description VALUES (158,1,'Prof Otoscopes'); INSERT INTO categories_description VALUES (159,1,'Sharps Disposal'); INSERT INTO categories_description VALUES (160,1,'Sponges, Gauze'); INSERT INTO categories_description VALUES (161,1,'Sponges, Nonwoven'); INSERT INTO categories_description VALUES (162,1,'Washcloths, Disp'); INSERT INTO categories_description VALUES (163,1,'Pads, Gauze'); INSERT INTO categories_description VALUES (164,1,'Sodium Chloride Drsg'); INSERT INTO categories_description VALUES (165,1,'Catheter Trays'); INSERT INTO categories_description VALUES (166,1,'Suction Catheters'); INSERT INTO categories_description VALUES (167,1,'Feminine Hygiene'); INSERT INTO categories_description VALUES (168,1,'Socks/Stockings'); INSERT INTO categories_description VALUES (169,1,'Socks/Stockings Misc'); INSERT INTO categories_description VALUES (170,1,'Socks'); INSERT INTO categories_description VALUES (171,1,'Ambulatory Misc'); INSERT INTO categories_description VALUES (172,1,'Sport and Leg Conditioning'); INSERT INTO categories_description VALUES (173,1,'Patient Lifts/Acc'); INSERT INTO categories_description VALUES (174,1,'Patient Lifts'); INSERT INTO categories_description VALUES (175,1,'Sheet/Pilwcases/Mat Cvr'); INSERT INTO categories_description VALUES (176,1,'Peak Flow Meters/Acc'); INSERT INTO categories_description VALUES (177,1,'Suction Pumps/Acc'); INSERT INTO categories_description VALUES (178,1,'Bath Acc/Misc'); INSERT INTO categories_description VALUES (179,1,'Beds/Mattresses'); INSERT INTO categories_description VALUES (180,1,'Wheelchairs'); INSERT INTO categories_description VALUES (181,1,'Grab Bars'); INSERT INTO categories_description VALUES (182,1,'Overbed Tables'); INSERT INTO categories_description VALUES (183,1,'Scooters/Acc'); INSERT INTO categories_description VALUES (184,1,'Scooters Misc'); INSERT INTO categories_description VALUES (185,1,'Toilet Seats/Acc'); INSERT INTO categories_description VALUES (186,1,'Wheelchair Ramps'); INSERT INTO categories_description VALUES (187,1,'Attachment Devices'); INSERT INTO categories_description VALUES (188,1,'1-Piece Urostomy'); INSERT INTO categories_description VALUES (189,1,'Skin Barriers'); INSERT INTO categories_description VALUES (190,1,'2-Piece Drainable'); INSERT INTO categories_description VALUES (191,1,'1-Piece Closed'); INSERT INTO categories_description VALUES (192,1,'Otoscopes/Opthalmoscope'); INSERT INTO categories_description VALUES (193,1,'Spacer Devices/Acc'); INSERT INTO categories_description VALUES (194,1,'Rings'); INSERT INTO categories_description VALUES (195,1,'Supports for your Wrist and Elbo'); INSERT INTO categories_description VALUES (196,1,'Trach Care/Cleaning'); INSERT INTO categories_description VALUES (197,1,'Air Cleaners/Acc'); INSERT INTO categories_description VALUES (198,1,'Intermittent'); INSERT INTO categories_description VALUES (199,1,'Needles/Syringes'); INSERT INTO categories_description VALUES (200,1,'Syringes With Needles'); INSERT INTO categories_description VALUES (201,1,'Resp Irrig Solutions'); INSERT INTO categories_description VALUES (202,1,'Needles/Syringes Misc'); INSERT INTO categories_description VALUES (203,1,'Nutrition Supplements'); INSERT INTO categories_description VALUES (204,1,'Japanese Herbals'); INSERT INTO categories_description VALUES (205,1,'Minerals'); INSERT INTO categories_description VALUES (206,1,'Women\'s Health'); INSERT INTO categories_description VALUES (207,1,'Weight Control / Diabetes'); INSERT INTO categories_description VALUES (208,1,'Vitamins'); INSERT INTO categories_description VALUES (209,1,'Heart Health'); INSERT INTO categories_description VALUES (210,1,'Sport Nutrition'); INSERT INTO categories_description VALUES (211,1,'Skin Aids/Beauty'); INSERT INTO categories_description VALUES (212,1,'Tooth Whitening Products'); INSERT INTO categories_description VALUES (213,1,'Allergy / Sinus / Immune System'); INSERT INTO categories_description VALUES (214,1,'Herbal Supplements'); INSERT INTO categories_description VALUES (215,1,'Digestive Health'); INSERT INTO categories_description VALUES (216,1,'Antioxidants'); INSERT INTO categories_description VALUES (217,1,'Stress / Sleeping Aids'); INSERT INTO categories_description VALUES (218,1,'Joint & Bone Health'); INSERT INTO categories_description VALUES (219,2,''); INSERT INTO categories_description VALUES (219,3,''); INSERT INTO categories_description VALUES (220,1,'Coming Soon'); INSERT INTO categories_description VALUES (220,2,''); INSERT INTO categories_description VALUES (220,3,''); -- -- Table structure for table `configuration` -- CREATE TABLE configuration ( configuration_id int(11) NOT NULL auto_increment, configuration_title varchar(64) NOT NULL default '', configuration_key varchar(64) NOT NULL default '', configuration_value varchar(255) NOT NULL default '', configuration_description varchar(255) NOT NULL default '', configuration_group_id int(11) NOT NULL default '0', sort_order int(5) default NULL, last_modified datetime default NULL, date_added datetime NOT NULL default '0000-00-00 00:00:00', use_function varchar(255) default NULL, set_function varchar(255) default NULL, PRIMARY KEY (configuration_id) ) TYPE=MyISAM; -- -- Dumping data for table `configuration` -- INSERT INTO configuration VALUES (1,'Store Name','STORE_NAME','Pain Relief Source','The name of my store',1,1,'2005-12-18 15:18:08','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (2,'Store Owner','STORE_OWNER','Pain Relief','The name of my store owner',1,2,'2005-11-21 10:37:21','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (3,'E-Mail Address','STORE_OWNER_EMAIL_ADDRESS','service@painrelief101.com','The e-mail address of my store owner',1,3,'2005-11-21 10:37:56','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (4,'E-Mail From','EMAIL_FROM','service@painrelief101.com','The e-mail address used in (sent) e-mails',1,4,'2005-11-21 10:44:09','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (5,'Country','STORE_COUNTRY','223','The country my store is located in

Note: Please remember to update the store zone.',1,6,'0000-00-00 00:00:00','2005-08-11 14:56:10','tep_get_country_name','tep_cfg_pull_down_country_list('); INSERT INTO configuration VALUES (6,'Zone','STORE_ZONE','62','The zone my store is located in',1,7,'2005-11-21 10:41:37','2005-08-11 14:56:10','tep_cfg_get_zone_name','tep_cfg_pull_down_zone_list('); INSERT INTO configuration VALUES (7,'Expected Sort Order','EXPECTED_PRODUCTS_SORT','desc','This is the sort order used in the expected products box.',1,8,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'asc\', \'desc\'),'); INSERT INTO configuration VALUES (8,'Expected Sort Field','EXPECTED_PRODUCTS_FIELD','date_expected','The column to sort by in the expected products box.',1,9,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'products_name\', \'date_expected\'),'); INSERT INTO configuration VALUES (9,'Switch To Default Language Currency','USE_DEFAULT_LANGUAGE_CURRENCY','false','Automatically switch to the language\'s currency when it is changed',1,10,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (10,'Send Extra Order Emails To','SEND_EXTRA_ORDER_EMAILS_TO','tarun , Service , John ','Send extra order emails to the following email addresses, in this format: Name 1 <email@address1>, Name 2 <email@address2>',1,11,'2006-02-13 02:37:07','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (11,'Use Search-Engine Safe URLs (still in development)','SEARCH_ENGINE_FRIENDLY_URLS','false','Use search-engine safe urls for all site links',1,12,'2006-01-14 08:33:30','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (12,'Display Cart After Adding Product','DISPLAY_CART','true','Display the shopping cart after adding a product (or return back to their origin)',1,14,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (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,'2005-11-21 10:35:35','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (14,'Default Search Operator','ADVANCED_SEARCH_DEFAULT_OPERATOR','and','Default search operators',1,17,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'and\', \'or\'),'); INSERT INTO configuration VALUES (15,'Store Address and Phone','STORE_NAME_ADDRESS','Pain Relief 101\r\nP.O. Box 609\r\nSequim, WA 98382\r\n800-589-1509','This is the Store Name, Address and Phone used on printable documents and displayed online',1,18,'2005-11-21 10:43:28','2005-08-11 14:56:10','','tep_cfg_textarea('); INSERT INTO configuration VALUES (16,'Show Category Counts','SHOW_COUNTS','true','Count recursively how many products are in each category',1,19,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (17,'Tax Decimal Places','TAX_DECIMAL_PLACES','0','Pad the tax value this amount of decimal places',1,20,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (18,'Display Prices with Tax','DISPLAY_PRICE_WITH_TAX','false','Display prices with tax included (true) or add the tax at the end (false)',1,21,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (19,'First Name','ENTRY_FIRST_NAME_MIN_LENGTH','2','Minimum length of first name',2,1,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (20,'Last Name','ENTRY_LAST_NAME_MIN_LENGTH','2','Minimum length of last name',2,2,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (21,'Date of Birth','ENTRY_DOB_MIN_LENGTH','10','Minimum length of date of birth',2,3,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (22,'E-Mail Address','ENTRY_EMAIL_ADDRESS_MIN_LENGTH','6','Minimum length of e-mail address',2,4,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (23,'Street Address','ENTRY_STREET_ADDRESS_MIN_LENGTH','5','Minimum length of street address',2,5,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (24,'Company','ENTRY_COMPANY_MIN_LENGTH','2','Minimum length of company name',2,6,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (25,'Post Code','ENTRY_POSTCODE_MIN_LENGTH','4','Minimum length of post code',2,7,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (26,'City','ENTRY_CITY_MIN_LENGTH','3','Minimum length of city',2,8,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (27,'State','ENTRY_STATE_MIN_LENGTH','2','Minimum length of state',2,9,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (28,'Telephone Number','ENTRY_TELEPHONE_MIN_LENGTH','3','Minimum length of telephone number',2,10,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (29,'Password','ENTRY_PASSWORD_MIN_LENGTH','5','Minimum length of password',2,11,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (30,'Credit Card Owner Name','CC_OWNER_MIN_LENGTH','3','Minimum length of credit card owner name',2,12,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (31,'Credit Card Number','CC_NUMBER_MIN_LENGTH','10','Minimum length of credit card number',2,13,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (32,'Review Text','REVIEW_TEXT_MIN_LENGTH','50','Minimum length of review text',2,14,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (33,'Best Sellers','MIN_DISPLAY_BESTSELLERS','1','Minimum number of best sellers to display',2,15,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (34,'Also Purchased','MIN_DISPLAY_ALSO_PURCHASED','1','Minimum number of products to display in the \'This Customer Also Purchased\' box',2,16,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (35,'Address Book Entries','MAX_ADDRESS_BOOK_ENTRIES','5','Maximum address book entries a customer is allowed to have',3,1,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (36,'Search Results','MAX_DISPLAY_SEARCH_RESULTS','20','Amount of products to list',3,2,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (37,'Page Links','MAX_DISPLAY_PAGE_LINKS','5','Number of \'number\' links use for page-sets',3,3,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (38,'Special Products','MAX_DISPLAY_SPECIAL_PRODUCTS','9','Maximum number of products on special to display',3,4,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (39,'New Products Module','MAX_DISPLAY_NEW_PRODUCTS','9','Maximum number of new products to display in a category',3,5,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (40,'Products Expected','MAX_DISPLAY_UPCOMING_PRODUCTS','10','Maximum number of products expected to display',3,6,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (41,'Manufacturers List','MAX_DISPLAY_MANUFACTURERS_IN_A_LIST','0','Used in manufacturers box; when the number of manufacturers exceeds this number, a drop-down list will be displayed instead of the default list',3,7,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (42,'Manufacturers Select Size','MAX_MANUFACTURERS_LIST','1','Used in manufacturers box; when this value is \'1\' the classic drop-down list will be used for the manufacturers box. Otherwise, a list-box with the specified number of rows will be displayed.',3,7,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (43,'Length of Manufacturers Name','MAX_DISPLAY_MANUFACTURER_NAME_LEN','15','Used in manufacturers box; maximum length of manufacturers name to display',3,8,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (44,'New Reviews','MAX_DISPLAY_NEW_REVIEWS','6','Maximum number of new reviews to display',3,9,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (45,'Selection of Random Reviews','MAX_RANDOM_SELECT_REVIEWS','10','How many records to select from to choose one random product review',3,10,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (46,'Selection of Random New Products','MAX_RANDOM_SELECT_NEW','10','How many records to select from to choose one random new product to display',3,11,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (47,'Selection of Products on Special','MAX_RANDOM_SELECT_SPECIALS','10','How many records to select from to choose one random product special to display',3,12,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (48,'Categories To List Per Row','MAX_DISPLAY_CATEGORIES_PER_ROW','3','How many categories to list per row',3,13,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (49,'New Products Listing','MAX_DISPLAY_PRODUCTS_NEW','10','Maximum number of new products to display in new products page',3,14,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (50,'Best Sellers','MAX_DISPLAY_BESTSELLERS','10','Maximum number of best sellers to display',3,15,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (51,'Also Purchased','MAX_DISPLAY_ALSO_PURCHASED','6','Maximum number of products to display in the \'This Customer Also Purchased\' box',3,16,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (52,'Customer Order History Box','MAX_DISPLAY_PRODUCTS_IN_ORDER_HISTORY_BOX','6','Maximum number of products to display in the customer order history box',3,17,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (53,'Order History','MAX_DISPLAY_ORDER_HISTORY','10','Maximum number of orders to display in the order history page',3,18,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (54,'Small Image Width','SMALL_IMAGE_WIDTH','100','The pixel width of small images',4,1,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (55,'Small Image Height','SMALL_IMAGE_HEIGHT','100','The pixel height of small images',4,2,'2005-12-18 15:19:27','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (56,'Heading Image Width','HEADING_IMAGE_WIDTH','40','The pixel width of heading images',4,3,'2006-02-12 06:51:18','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (57,'Heading Image Height','HEADING_IMAGE_HEIGHT','40','The pixel height of heading images',4,4,'2006-02-12 06:36:20','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (58,'Subcategory Image Width','SUBCATEGORY_IMAGE_WIDTH','100','The pixel width of subcategory images',4,5,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (59,'Subcategory Image Height','SUBCATEGORY_IMAGE_HEIGHT','100','The pixel height of subcategory images',4,6,'2005-12-18 15:20:02','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (60,'Calculate Image Size','CONFIG_CALCULATE_IMAGE_SIZE','true','Calculate the size of images?',4,7,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (61,'Image Required','IMAGE_REQUIRED','true','Enable to display broken images. Good for development.',4,8,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (62,'Gender','ACCOUNT_GENDER','false','Display gender in the customers account',5,1,'2005-12-20 11:42:44','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (63,'Date of Birth','ACCOUNT_DOB','true','Display date of birth in the customers account',5,2,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (64,'Company','ACCOUNT_COMPANY','true','Display company in the customers account',5,3,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (65,'Suburb','ACCOUNT_SUBURB','true','Display suburb in the customers account',5,4,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (66,'State','ACCOUNT_STATE','true','Display state in the customers account',5,5,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (67,'Installed Modules','MODULE_PAYMENT_INSTALLED','eprocessingnetwork.php;paypal.php;moneyorder.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,'2006-01-27 07:24:04','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (68,'Installed Modules','MODULE_ORDER_TOTAL_INSTALLED','ot_subtotal.php;ot_shipping.php;ot_tax.php;ot_total.php','List of order_total module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php)',6,0,'2005-12-18 15:16:50','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (69,'Installed Modules','MODULE_SHIPPING_INSTALLED','table.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,'2005-12-18 15:03:06','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (198,'Enable EProcessing Network Module','MODULE_PAYMENT_EPROCESSINGNETWORK_STATUS','True','Do you want to accept eProcessing Network payments?',6,0,NULL,'2006-01-27 07:24:04',NULL,'tep_cfg_select_option(array(\'True\', \'False\'),'); INSERT INTO configuration VALUES (181,'Text Color','MODULE_PAYMENT_EPROCESSINGNETWORK_TEXT_COLOR','#000000','The Color of the Text in Hex format:',6,0,NULL,'2005-12-20 19:07:24',NULL,NULL); INSERT INTO configuration VALUES (84,'Default Currency','DEFAULT_CURRENCY','USD','Default Currency',6,0,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (85,'Default Language','DEFAULT_LANGUAGE','en','Default Language',6,0,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (86,'Default Order Status For New Orders','DEFAULT_ORDERS_STATUS_ID','1','When a new order is created, this order status will be assigned to it.',6,0,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (87,'Display Shipping','MODULE_ORDER_TOTAL_SHIPPING_STATUS','true','Do you want to display the order shipping cost?',6,1,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (88,'Sort Order','MODULE_ORDER_TOTAL_SHIPPING_SORT_ORDER','2','Sort order of display.',6,2,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (89,'Allow Free Shipping','MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING','false','Do you want to allow free shipping?',6,3,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (90,'Free Shipping For Orders Over','MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER','50','Provide free shipping for orders over the set amount.',6,4,'0000-00-00 00:00:00','2005-08-11 14:56:10','currencies->format',''); INSERT INTO configuration VALUES (91,'Provide Free Shipping For Orders Made','MODULE_ORDER_TOTAL_SHIPPING_DESTINATION','national','Provide free shipping for orders sent to the set destination.',6,5,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'national\', \'international\', \'both\'),'); INSERT INTO configuration VALUES (92,'Display Sub-Total','MODULE_ORDER_TOTAL_SUBTOTAL_STATUS','true','Do you want to display the order sub-total cost?',6,1,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (93,'Sort Order','MODULE_ORDER_TOTAL_SUBTOTAL_SORT_ORDER','1','Sort order of display.',6,2,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (94,'Display Tax','MODULE_ORDER_TOTAL_TAX_STATUS','true','Do you want to display the order tax value?',6,1,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (95,'Sort Order','MODULE_ORDER_TOTAL_TAX_SORT_ORDER','3','Sort order of display.',6,2,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (96,'Display Total','MODULE_ORDER_TOTAL_TOTAL_STATUS','true','Do you want to display the total order value?',6,1,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (97,'Sort Order','MODULE_ORDER_TOTAL_TOTAL_SORT_ORDER','4','Sort order of display.',6,2,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (98,'Country of Origin','SHIPPING_ORIGIN_COUNTRY','223','Select the country of origin to be used in shipping quotes.',7,1,'0000-00-00 00:00:00','2005-08-11 14:56:10','tep_get_country_name','tep_cfg_pull_down_country_list('); INSERT INTO configuration VALUES (99,'Postal Code','SHIPPING_ORIGIN_ZIP','NONE','Enter the Postal Code (ZIP) of the Store to be used in shipping quotes.',7,2,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (100,'Enter the Maximum Package Weight you will ship','SHIPPING_MAX_WEIGHT','50','Carriers have a max weight limit for a single package. This is a common one for all.',7,3,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (101,'Package Tare weight.','SHIPPING_BOX_WEIGHT','3','What is the weight of typical packaging of small to medium packages?',7,4,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (102,'Larger packages - percentage increase.','SHIPPING_BOX_PADDING','10','For 10% enter 10',7,5,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (103,'Display Product Image','PRODUCT_LIST_IMAGE','1','Do you want to display the Product Image?',8,1,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (104,'Display Product Manufaturer Name','PRODUCT_LIST_MANUFACTURER','0','Do you want to display the Product Manufacturer Name?',8,2,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (105,'Display Product Model','PRODUCT_LIST_MODEL','0','Do you want to display the Product Model?',8,3,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (106,'Display Product Name','PRODUCT_LIST_NAME','2','Do you want to display the Product Name?',8,4,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (107,'Display Product Price','PRODUCT_LIST_PRICE','3','Do you want to display the Product Price',8,5,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (108,'Display Product Quantity','PRODUCT_LIST_QUANTITY','0','Do you want to display the Product Quantity?',8,6,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (109,'Display Product Weight','PRODUCT_LIST_WEIGHT','0','Do you want to display the Product Weight?',8,7,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (110,'Display Buy Now column','PRODUCT_LIST_BUY_NOW','4','Do you want to display the Buy Now column?',8,8,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (111,'Display Category/Manufacturer Filter (0=disable; 1=enable)','PRODUCT_LIST_FILTER','1','Do you want to display the Category/Manufacturer Filter?',8,9,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (112,'Location of Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)','PREV_NEXT_BAR_LOCATION','3','Sets the location of the Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)',8,10,'2006-03-24 15:15:08','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (113,'Check stock level','STOCK_CHECK','true','Check to see if sufficent stock is available',9,1,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (114,'Subtract stock','STOCK_LIMITED','true','Subtract product in stock by product orders',9,2,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (115,'Allow Checkout','STOCK_ALLOW_CHECKOUT','true','Allow customer to checkout even if there is insufficient stock',9,3,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (116,'Mark product out of stock','STOCK_MARK_PRODUCT_OUT_OF_STOCK','***','Display something on screen so customer can see which product has insufficient stock',9,4,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (117,'Stock Re-order level','STOCK_REORDER_LEVEL','5','Define when stock needs to be re-ordered',9,5,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (118,'Store Page Parse Time','STORE_PAGE_PARSE_TIME','false','Store the time it takes to parse a page',10,1,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (119,'Log Destination','STORE_PAGE_PARSE_TIME_LOG','/var/log/www/tep/page_parse_time.log','Directory and filename of the page parse time log',10,2,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (120,'Log Date Format','STORE_PARSE_DATE_TIME_FORMAT','%d/%m/%Y %H:%M:%S','The date format',10,3,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (121,'Display The Page Parse Time','DISPLAY_PAGE_PARSE_TIME','true','Display the page parse time (store page parse time must be enabled)',10,4,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (122,'Store Database Queries','STORE_DB_TRANSACTIONS','false','Store the database queries in the page parse time log (PHP4 only)',10,5,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (123,'Use Cache','USE_CACHE','false','Use caching features',11,1,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (124,'Cache Directory','DIR_FS_CACHE','/tmp/','The directory where the cached files are saved',11,2,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (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,'2005-11-21 22:26:32','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'sendmail\', \'smtp\'),'); INSERT INTO configuration VALUES (126,'E-Mail Linefeeds','EMAIL_LINEFEED','LF','Defines the character sequence used to separate mail headers.',12,2,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'LF\', \'CRLF\'),'); INSERT INTO configuration VALUES (127,'Use MIME HTML When Sending Emails','EMAIL_USE_HTML','false','Send e-mails in HTML format',12,3,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (128,'Verify E-Mail Addresses Through DNS','ENTRY_EMAIL_ADDRESS_CHECK','false','Verify e-mail address through a DNS server',12,4,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (129,'Send E-Mails','SEND_EMAILS','true','Send out e-mails',12,5,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (130,'Enable download','DOWNLOAD_ENABLED','false','Enable the products download functions.',13,1,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (131,'Download by redirect','DOWNLOAD_BY_REDIRECT','false','Use browser redirection for download. Disable on non-Unix systems.',13,2,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (132,'Expiry delay (days)','DOWNLOAD_MAX_DAYS','7','Set number of days before the download link expires. 0 means no limit.',13,3,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (133,'Maximum number of downloads','DOWNLOAD_MAX_COUNT','5','Set the maximum number of downloads. 0 means no download authorized.',13,4,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (134,'Enable GZip Compression','GZIP_COMPRESSION','false','Enable HTTP GZip compression.',14,1,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'true\', \'false\'),'); INSERT INTO configuration VALUES (135,'Compression Level','GZIP_LEVEL','5','Use this compression level 0-9 (0 = minimum, 9 = maximum).',14,2,'0000-00-00 00:00:00','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (136,'Session Directory','SESSION_WRITE_DIRECTORY','\\tmp','If sessions are file based, store them in this directory.',15,1,'2005-11-23 13:52:34','2005-08-11 14:56:10','',''); INSERT INTO configuration VALUES (137,'Force Cookie Use','SESSION_FORCE_COOKIE_USE','False','Force the use of sessions when cookies are only enabled.',15,2,'2005-11-23 13:31:10','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'True\', \'False\'),'); INSERT INTO configuration VALUES (138,'Check SSL Session ID','SESSION_CHECK_SSL_SESSION_ID','False','Validate the SSL_SESSION_ID on every secure HTTPS page request.',15,3,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'True\', \'False\'),'); INSERT INTO configuration VALUES (139,'Check User Agent','SESSION_CHECK_USER_AGENT','False','Validate the clients browser user agent on every page request.',15,4,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'True\', \'False\'),'); INSERT INTO configuration VALUES (140,'Check IP Address','SESSION_CHECK_IP_ADDRESS','False','Validate the clients IP address on every page request.',15,5,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'True\', \'False\'),'); INSERT INTO configuration VALUES (141,'Prevent Spider Sessions','SESSION_BLOCK_SPIDERS','False','Prevent known spiders from starting a session.',15,6,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'True\', \'False\'),'); INSERT INTO configuration VALUES (142,'Recreate Session','SESSION_RECREATE','False','Recreate the session to generate a new session ID when the customer logs on or creates an account (PHP >=4.1 needed).',15,7,'0000-00-00 00:00:00','2005-08-11 14:56:10','','tep_cfg_select_option(array(\'True\', \'False\'),'); INSERT INTO configuration VALUES (143,'Enable PayPal Module','MODULE_PAYMENT_PAYPAL_STATUS','True','Do you want to accept PayPal payments?',6,3,NULL,'2005-11-21 10:45:29',NULL,'tep_cfg_select_option(array(\'True\', \'False\'),'); INSERT INTO configuration VALUES (144,'E-Mail Address','MODULE_PAYMENT_PAYPAL_ID','payments@ultimatewatermassgae.com','The e-mail address to use for the PayPal service',6,4,NULL,'2005-11-21 10:45:29',NULL,NULL); INSERT INTO configuration VALUES (145,'Transaction Currency','MODULE_PAYMENT_PAYPAL_CURRENCY','Selected Currency','The currency to use for credit card transactions',6,6,NULL,'2005-11-21 10:45:29',NULL,'tep_cfg_select_option(array(\'Selected Currency\',\'Only USD\',\'Only CAD\',\'Only EUR\',\'Only GBP\',\'Only JPY\'),'); INSERT INTO configuration VALUES (146,'Sort order of display.','MODULE_PAYMENT_PAYPAL_SORT_ORDER','1','Sort order of display. Lowest is displayed first.',6,0,NULL,'2005-11-21 10:45:29',NULL,NULL); INSERT INTO configuration VALUES (147,'Payment Zone','MODULE_PAYMENT_PAYPAL_ZONE','0','If a zone is selected, only enable this payment method for that zone.',6,2,NULL,'2005-11-21 10:45:29','tep_get_zone_class_title','tep_cfg_pull_down_zone_classes('); INSERT INTO configuration VALUES (148,'Set Order Status','MODULE_PAYMENT_PAYPAL_ORDER_STATUS_ID','0','Set the status of orders made with this payment module to this value',6,0,NULL,'2005-11-21 10:45:29','tep_get_order_status_name','tep_cfg_pull_down_order_statuses('); INSERT INTO configuration VALUES (175,'Sort Order','MODULE_SHIPPING_TABLE_SORT_ORDER','0','Sort order of display.',6,0,NULL,'2005-12-18 15:02:36',NULL,NULL); INSERT INTO configuration VALUES (174,'Shipping Zone','MODULE_SHIPPING_TABLE_ZONE','0','If a zone is selected, only enable this shipping method for that zone.',6,0,NULL,'2005-12-18 15:02:36','tep_get_zone_class_title','tep_cfg_pull_down_zone_classes('); INSERT INTO configuration VALUES (173,'Tax Class','MODULE_SHIPPING_TABLE_TAX_CLASS','0','Use the following tax class on the shipping fee.',6,0,NULL,'2005-12-18 15:02:36','tep_get_tax_class_title','tep_cfg_pull_down_tax_classes('); INSERT INTO configuration VALUES (172,'Handling Fee','MODULE_SHIPPING_TABLE_HANDLING','0','Handling fee for this shipping method.',6,0,NULL,'2005-12-18 15:02:36',NULL,NULL); INSERT INTO configuration VALUES (171,'Table Method','MODULE_SHIPPING_TABLE_MODE','price','The shipping cost is based on the order total or the total weight of the items ordered.',6,0,NULL,'2005-12-18 15:02:36',NULL,'tep_cfg_select_option(array(\'weight\', \'price\'),'); INSERT INTO configuration VALUES (170,'Shipping Table','MODULE_SHIPPING_TABLE_COST','24.99:6.99,49.99:12.99,75.99:17.99150:00.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',6,0,NULL,'2005-12-18 15:02:36',NULL,NULL); INSERT INTO configuration VALUES (158,'Enable Check/Money Order Module','MODULE_PAYMENT_MONEYORDER_STATUS','True','Do you want to accept Check/Money Order payments?',6,1,NULL,'2005-12-18 02:53:10',NULL,'tep_cfg_select_option(array(\'True\', \'False\'),'); INSERT INTO configuration VALUES (159,'Make Payable to:','MODULE_PAYMENT_MONEYORDER_PAYTO','Ultimate Water Massage Inc','Who should payments be made payable to?',6,1,NULL,'2005-12-18 02:53:10',NULL,NULL); INSERT INTO configuration VALUES (160,'Sort order of display.','MODULE_PAYMENT_MONEYORDER_SORT_ORDER','2','Sort order of display. Lowest is displayed first.',6,0,NULL,'2005-12-18 02:53:10',NULL,NULL); INSERT INTO configuration VALUES (161,'Payment Zone','MODULE_PAYMENT_MONEYORDER_ZONE','0','If a zone is selected, only enable this payment method for that zone.',6,2,NULL,'2005-12-18 02:53:10','tep_get_zone_class_title','tep_cfg_pull_down_zone_classes('); INSERT INTO configuration VALUES (162,'Set Order Status','MODULE_PAYMENT_MONEYORDER_ORDER_STATUS_ID','0','Set the status of orders made with this payment module to this value',6,0,NULL,'2005-12-18 02:53:10','tep_get_order_status_name','tep_cfg_pull_down_order_statuses('); INSERT INTO configuration VALUES (180,'Background Color','MODULE_PAYMENT_EPROCESSINGNETWORK_BCK_COLOR','#FFFFFF','The Background Color in Hex format:',6,0,NULL,'2005-12-20 19:07:24',NULL,NULL); INSERT INTO configuration VALUES (179,'URL for Store Logo','MODULE_PAYMENT_EPROCESSINGNETWORK_LOGO_URL','','The URL to a logo to be used by eProcessing to display during transactions',6,0,NULL,'2005-12-20 19:07:24',NULL,NULL); INSERT INTO configuration VALUES (177,'Enable eProcessingNetwork To Collect CC#','MODULE_PAYMENT_EPROCESSINGNETWORK_CC','True','Do you want eProcessingNetwork to Collect the Credit Card Number??',6,0,NULL,'2005-12-20 19:07:24',NULL,'tep_cfg_select_option(array(\'True\', \'False\'),'); INSERT INTO configuration VALUES (169,'Enable Table Method','MODULE_SHIPPING_TABLE_STATUS','True','Do you want to offer table rate shipping?',6,0,NULL,'2005-12-18 15:02:36',NULL,'tep_cfg_select_option(array(\'True\', \'False\'),'); -- -- Table structure for table `configuration_group` -- CREATE TABLE configuration_group ( configuration_group_id int(11) NOT NULL auto_increment, configuration_group_title varchar(64) NOT NULL default '', configuration_group_description varchar(255) NOT NULL default '', sort_order int(5) default NULL, visible int(1) default '1', PRIMARY KEY (configuration_group_id) ) TYPE=MyISAM; -- -- Dumping data for table `configuration_group` -- INSERT INTO configuration_group VALUES (1,'My Store','General information about my store',1,1); INSERT INTO configuration_group VALUES (2,'Minimum Values','The minimum values for functions / data',2,1); INSERT INTO configuration_group VALUES (3,'Maximum Values','The maximum values for functions / data',3,1); INSERT INTO configuration_group VALUES (4,'Images','Image parameters',4,1); INSERT INTO configuration_group VALUES (5,'Customer Details','Customer account configuration',5,1); INSERT INTO configuration_group VALUES (6,'Module Options','Hidden from configuration',6,0); INSERT INTO configuration_group VALUES (7,'Shipping/Packaging','Shipping options available at my store',7,1); INSERT INTO configuration_group VALUES (8,'Product Listing','Product Listing configuration options',8,1); INSERT INTO configuration_group VALUES (9,'Stock','Stock configuration options',9,1); INSERT INTO configuration_group VALUES (10,'Logging','Logging configuration options',10,1); INSERT INTO configuration_group VALUES (11,'Cache','Caching configuration options',11,1); INSERT INTO configuration_group VALUES (12,'E-Mail Options','General setting for E-Mail transport and HTML E-Mails',12,1); INSERT INTO configuration_group VALUES (13,'Download','Downloadable products options',13,1); INSERT INTO configuration_group VALUES (14,'GZip Compression','GZip compression options',14,1); INSERT INTO configuration_group VALUES (15,'Sessions','Session options',15,1); -- -- Table structure for table `counter` -- CREATE TABLE counter ( startdate char(8) default NULL, counter int(12) default NULL ) TYPE=MyISAM; -- -- Dumping data for table `counter` -- INSERT INTO counter VALUES ('20051121',5251); -- -- Table structure for table `counter_history` -- CREATE TABLE counter_history ( month char(8) default NULL, counter int(12) default NULL ) TYPE=MyISAM; -- -- Dumping data for table `counter_history` -- -- -- Table structure for table `countries` -- CREATE TABLE countries ( countries_id int(11) NOT NULL auto_increment, countries_name varchar(64) NOT NULL default '', countries_iso_code_2 char(2) NOT NULL default '', countries_iso_code_3 char(3) NOT NULL default '', address_format_id int(11) NOT NULL default '0', PRIMARY KEY (countries_id), KEY IDX_COUNTRIES_NAME (countries_name) ) TYPE=MyISAM; -- -- Dumping data for table `countries` -- INSERT INTO countries VALUES (2,'Albania','AL','ALB',1); INSERT INTO countries VALUES (3,'Algeria','DZ','DZA',1); INSERT INTO countries VALUES (4,'American Samoa','AS','ASM',1); INSERT INTO countries VALUES (5,'Andorra','AD','AND',1); INSERT INTO countries VALUES (6,'Angola','AO','AGO',1); INSERT INTO countries VALUES (7,'Anguilla','AI','AIA',1); INSERT INTO countries VALUES (8,'Antarctica','AQ','ATA',1); INSERT INTO countries VALUES (9,'Antigua and Barbuda','AG','ATG',1); INSERT INTO countries VALUES (10,'Argentina','AR','ARG',1); INSERT INTO countries VALUES (11,'Armenia','AM','ARM',1); INSERT INTO countries VALUES (12,'Aruba','AW','ABW',1); INSERT INTO countries VALUES (13,'Australia','AU','AUS',1); INSERT INTO countries VALUES (14,'Austria','AT','AUT',5); INSERT INTO countries VALUES (15,'Azerbaijan','AZ','AZE',1); INSERT INTO countries VALUES (16,'Bahamas','BS','BHS',1); INSERT INTO countries VALUES (17,'Bahrain','BH','BHR',1); INSERT INTO countries VALUES (18,'Bangladesh','BD','BGD',1); INSERT INTO countries VALUES (19,'Barbados','BB','BRB',1); INSERT INTO countries VALUES (20,'Belarus','BY','BLR',1); INSERT INTO countries VALUES (21,'Belgium','BE','BEL',1); INSERT INTO countries VALUES (22,'Belize','BZ','BLZ',1); INSERT INTO countries VALUES (23,'Benin','BJ','BEN',1); INSERT INTO countries VALUES (24,'Bermuda','BM','BMU',1); INSERT INTO countries VALUES (25,'Bhutan','BT','BTN',1); INSERT INTO countries VALUES (26,'Bolivia','BO','BOL',1); INSERT INTO countries VALUES (27,'Bosnia and Herzegowina','BA','BIH',1); INSERT INTO countries VALUES (28,'Botswana','BW','BWA',1); INSERT INTO countries VALUES (29,'Bouvet Island','BV','BVT',1); INSERT INTO countries VALUES (30,'Brazil','BR','BRA',1); INSERT INTO countries VALUES (31,'British Indian Ocean Territory','IO','IOT',1); INSERT INTO countries VALUES (32,'Brunei Darussalam','BN','BRN',1); INSERT INTO countries VALUES (33,'Bulgaria','BG','BGR',1); INSERT INTO countries VALUES (34,'Burkina Faso','BF','BFA',1); INSERT INTO countries VALUES (35,'Burundi','BI','BDI',1); INSERT INTO countries VALUES (36,'Cambodia','KH','KHM',1); INSERT INTO countries VALUES (37,'Cameroon','CM','CMR',1); INSERT INTO countries VALUES (38,'Canada','CA','CAN',1); INSERT INTO countries VALUES (39,'Cape Verde','CV','CPV',1); INSERT INTO countries VALUES (40,'Cayman Islands','KY','CYM',1); INSERT INTO countries VALUES (41,'Central African Republic','CF','CAF',1); INSERT INTO countries VALUES (42,'Chad','TD','TCD',1); INSERT INTO countries VALUES (43,'Chile','CL','CHL',1); INSERT INTO countries VALUES (44,'China','CN','CHN',1); INSERT INTO countries VALUES (45,'Christmas Island','CX','CXR',1); INSERT INTO countries VALUES (46,'Cocos (Keeling) Islands','CC','CCK',1); INSERT INTO countries VALUES (47,'Colombia','CO','COL',1); INSERT INTO countries VALUES (48,'Comoros','KM','COM',1); INSERT INTO countries VALUES (49,'Congo','CG','COG',1); INSERT INTO countries VALUES (50,'Cook Islands','CK','COK',1); INSERT INTO countries VALUES (51,'Costa Rica','CR','CRI',1); INSERT INTO countries VALUES (52,'Cote D\'Ivoire','CI','CIV',1); INSERT INTO countries VALUES (53,'Croatia','HR','HRV',1); INSERT INTO countries VALUES (54,'Cuba','CU','CUB',1); INSERT INTO countries VALUES (55,'Cyprus','CY','CYP',1); INSERT INTO countries VALUES (56,'Czech Republic','CZ','CZE',1); INSERT INTO countries VALUES (57,'Denmark','DK','DNK',1); INSERT INTO countries VALUES (58,'Djibouti','DJ','DJI',1); INSERT INTO countries VALUES (59,'Dominica','DM','DMA',1); INSERT INTO countries VALUES (60,'Dominican Republic','DO','DOM',1); INSERT INTO countries VALUES (61,'East Timor','TP','TMP',1); INSERT INTO countries VALUES (62,'Ecuador','EC','ECU',1); INSERT INTO countries VALUES (63,'Egypt','EG','EGY',1); INSERT INTO countries VALUES (64,'El Salvador','SV','SLV',1); INSERT INTO countries VALUES (65,'Equatorial Guinea','GQ','GNQ',1); INSERT INTO countries VALUES (66,'Eritrea','ER','ERI',1); INSERT INTO countries VALUES (67,'Estonia','EE','EST',1); INSERT INTO countries VALUES (68,'Ethiopia','ET','ETH',1); INSERT INTO countries VALUES (69,'Falkland Islands (Malvinas)','FK','FLK',1); INSERT INTO countries VALUES (70,'Faroe Islands','FO','FRO',1); INSERT INTO countries VALUES (71,'Fiji','FJ','FJI',1); INSERT INTO countries VALUES (72,'Finland','FI','FIN',1); INSERT INTO countries VALUES (73,'France','FR','FRA',1); INSERT INTO countries VALUES (74,'France, Metropolitan','FX','FXX',1); INSERT INTO countries VALUES (75,'French Guiana','GF','GUF',1); INSERT INTO countries VALUES (76,'French Polynesia','PF','PYF',1); INSERT INTO countries VALUES (77,'French Southern Territories','TF','ATF',1); INSERT INTO countries VALUES (78,'Gabon','GA','GAB',1); INSERT INTO countries VALUES (79,'Gambia','GM','GMB',1); INSERT INTO countries VALUES (80,'Georgia','GE','GEO',1); INSERT INTO countries VALUES (81,'Germany','DE','DEU',5); INSERT INTO countries VALUES (82,'Ghana','GH','GHA',1); INSERT INTO countries VALUES (83,'Gibraltar','GI','GIB',1); INSERT INTO countries VALUES (84,'Greece','GR','GRC',1); INSERT INTO countries VALUES (85,'Greenland','GL','GRL',1); INSERT INTO countries VALUES (86,'Grenada','GD','GRD',1); INSERT INTO countries VALUES (87,'Guadeloupe','GP','GLP',1); INSERT INTO countries VALUES (88,'Guam','GU','GUM',1); INSERT INTO countries VALUES (89,'Guatemala','GT','GTM',1); INSERT INTO countries VALUES (90,'Guinea','GN','GIN',1); INSERT INTO countries VALUES (91,'Guinea-bissau','GW','GNB',1); INSERT INTO countries VALUES (92,'Guyana','GY','GUY',1); INSERT INTO countries VALUES (93,'Haiti','HT','HTI',1); INSERT INTO countries VALUES (94,'Heard and Mc Donald Islands','HM','HMD',1); INSERT INTO countries VALUES (95,'Honduras','HN','HND',1); INSERT INTO countries VALUES (96,'Hong Kong','HK','HKG',1); INSERT INTO countries VALUES (97,'Hungary','HU','HUN',1); INSERT INTO countries VALUES (98,'Iceland','IS','ISL',1); INSERT INTO countries VALUES (99,'India','IN','IND',1); INSERT INTO countries VALUES (100,'Indonesia','ID','IDN',1); INSERT INTO countries VALUES (101,'Iran (Islamic Republic of)','IR','IRN',1); INSERT INTO countries VALUES (102,'Iraq','IQ','IRQ',1); INSERT INTO countries VALUES (103,'Ireland','IE','IRL',1); INSERT INTO countries VALUES (104,'Israel','IL','ISR',1); INSERT INTO countries VALUES (105,'Italy','IT','ITA',1); INSERT INTO countries VALUES (106,'Jamaica','JM','JAM',1); INSERT INTO countries VALUES (107,'Japan','JP','JPN',1); INSERT INTO countries VALUES (108,'Jordan','JO','JOR',1); INSERT INTO countries VALUES (109,'Kazakhstan','KZ','KAZ',1); INSERT INTO countries VALUES (110,'Kenya','KE','KEN',1); INSERT INTO countries VALUES (111,'Kiribati','KI','KIR',1); INSERT INTO countries VALUES (112,'Korea, Democratic People\'s Republic of','KP','PRK',1); INSERT INTO countries VALUES (113,'Korea, Republic of','KR','KOR',1); INSERT INTO countries VALUES (114,'Kuwait','KW','KWT',1); INSERT INTO countries VALUES (115,'Kyrgyzstan','KG','KGZ',1); INSERT INTO countries VALUES (116,'Lao People\'s Democratic Republic','LA','LAO',1); INSERT INTO countries VALUES (117,'Latvia','LV','LVA',1); INSERT INTO countries VALUES (118,'Lebanon','LB','LBN',1); INSERT INTO countries VALUES (119,'Lesotho','LS','LSO',1); INSERT INTO countries VALUES (120,'Liberia','LR','LBR',1); INSERT INTO countries VALUES (121,'Libyan Arab Jamahiriya','LY','LBY',1); INSERT INTO countries VALUES (122,'Liechtenstein','LI','LIE',1); INSERT INTO countries VALUES (123,'Lithuania','LT','LTU',1); INSERT INTO countries VALUES (124,'Luxembourg','LU','LUX',1); INSERT INTO countries VALUES (125,'Macau','MO','MAC',1); INSERT INTO countries VALUES (126,'Macedonia, The Former Yugoslav Republic of','MK','MKD',1); INSERT INTO countries VALUES (127,'Madagascar','MG','MDG',1); INSERT INTO countries VALUES (128,'Malawi','MW','MWI',1); INSERT INTO countries VALUES (129,'Malaysia','MY','MYS',1); INSERT INTO countries VALUES (130,'Maldives','MV','MDV',1); INSERT INTO countries VALUES (131,'Mali','ML','MLI',1); INSERT INTO countries VALUES (132,'Malta','MT','MLT',1); INSERT INTO countries VALUES (133,'Marshall Islands','MH','MHL',1); INSERT INTO countries VALUES (134,'Martinique','MQ','MTQ',1); INSERT INTO countries VALUES (135,'Mauritania','MR','MRT',1); INSERT INTO countries VALUES (136,'Mauritius','MU','MUS',1); INSERT INTO countries VALUES (137,'Mayotte','YT','MYT',1); INSERT INTO countries VALUES (138,'Mexico','MX','MEX',1); INSERT INTO countries VALUES (139,'Micronesia, Federated States of','FM','FSM',1); INSERT INTO countries VALUES (140,'Moldova, Republic of','MD','MDA',1); INSERT INTO countries VALUES (141,'Monaco','MC','MCO',1); INSERT INTO countries VALUES (142,'Mongolia','MN','MNG',1); INSERT INTO countries VALUES (143,'Montserrat','MS','MSR',1); INSERT INTO countries VALUES (144,'Morocco','MA','MAR',1); INSERT INTO countries VALUES (145,'Mozambique','MZ','MOZ',1); INSERT INTO countries VALUES (146,'Myanmar','MM','MMR',1); INSERT INTO countries VALUES (147,'Namibia','NA','NAM',1); INSERT INTO countries VALUES (148,'Nauru','NR','NRU',1); INSERT INTO countries VALUES (149,'Nepal','NP','NPL',1); INSERT INTO countries VALUES (150,'Netherlands','NL','NLD',1); INSERT INTO countries VALUES (151,'Netherlands Antilles','AN','ANT',1); INSERT INTO countries VALUES (152,'New Caledonia','NC','NCL',1); INSERT INTO countries VALUES (153,'New Zealand','NZ','NZL',1); INSERT INTO countries VALUES (154,'Nicaragua','NI','NIC',1); INSERT INTO countries VALUES (155,'Niger','NE','NER',1); INSERT INTO countries VALUES (156,'Nigeria','NG','NGA',1); INSERT INTO countries VALUES (157,'Niue','NU','NIU',1); INSERT INTO countries VALUES (158,'Norfolk Island','NF','NFK',1); INSERT INTO countries VALUES (159,'Northern Mariana Islands','MP','MNP',1); INSERT INTO countries VALUES (160,'Norway','NO','NOR',1); INSERT INTO countries VALUES (161,'Oman','OM','OMN',1); INSERT INTO countries VALUES (162,'Pakistan','PK','PAK',1); INSERT INTO countries VALUES (163,'Palau','PW','PLW',1); INSERT INTO countries VALUES (164,'Panama','PA','PAN',1); INSERT INTO countries VALUES (165,'Papua New Guinea','PG','PNG',1); INSERT INTO countries VALUES (166,'Paraguay','PY','PRY',1); INSERT INTO countries VALUES (167,'Peru','PE','PER',1); INSERT INTO countries VALUES (168,'Philippines','PH','PHL',1); INSERT INTO countries VALUES (169,'Pitcairn','PN','PCN',1); INSERT INTO countries VALUES (170,'Poland','PL','POL',1); INSERT INTO countries VALUES (171,'Portugal','PT','PRT',1); INSERT INTO countries VALUES (172,'Puerto Rico','PR','PRI',1); INSERT INTO countries VALUES (173,'Qatar','QA','QAT',1); INSERT INTO countries VALUES (174,'Reunion','RE','REU',1); INSERT INTO countries VALUES (175,'Romania','RO','ROM',1); INSERT INTO countries VALUES (176,'Russian Federation','RU','RUS',1); INSERT INTO countries VALUES (177,'Rwanda','RW','RWA',1); INSERT INTO countries VALUES (178,'Saint Kitts and Nevis','KN','KNA',1); INSERT INTO countries VALUES (179,'Saint Lucia','LC','LCA',1); INSERT INTO countries VALUES (180,'Saint Vincent and the Grenadines','VC','VCT',1); INSERT INTO countries VALUES (181,'Samoa','WS','WSM',1); INSERT INTO countries VALUES (182,'San Marino','SM','SMR',1); INSERT INTO countries VALUES (183,'Sao Tome and Principe','ST','STP',1); INSERT INTO countries VALUES (184,'Saudi Arabia','SA','SAU',1); INSERT INTO countries VALUES (185,'Senegal','SN','SEN',1); INSERT INTO countries VALUES (186,'Seychelles','SC','SYC',1); INSERT INTO countries VALUES (187,'Sierra Leone','SL','SLE',1); INSERT INTO countries VALUES (188,'Singapore','SG','SGP',4); INSERT INTO countries VALUES (189,'Slovakia (Slovak Republic)','SK','SVK',1); INSERT INTO countries VALUES (190,'Slovenia','SI','SVN',1); INSERT INTO countries VALUES (191,'Solomon Islands','SB','SLB',1); INSERT INTO countries VALUES (192,'Somalia','SO','SOM',1); INSERT INTO countries VALUES (193,'South Africa','ZA','ZAF',1); INSERT INTO countries VALUES (194,'South Georgia and the South Sandwich Islands','GS','SGS',1); INSERT INTO countries VALUES (195,'Spain','ES','ESP',3); INSERT INTO countries VALUES (196,'Sri Lanka','LK','LKA',1); INSERT INTO countries VALUES (197,'St. Helena','SH','SHN',1); INSERT INTO countries VALUES (198,'St. Pierre and Miquelon','PM','SPM',1); INSERT INTO countries VALUES (199,'Sudan','SD','SDN',1); INSERT INTO countries VALUES (200,'Suriname','SR','SUR',1); INSERT INTO countries VALUES (201,'Svalbard and Jan Mayen Islands','SJ','SJM',1); INSERT INTO countries VALUES (202,'Swaziland','SZ','SWZ',1); INSERT INTO countries VALUES (203,'Sweden','SE','SWE',1); INSERT INTO countries VALUES (204,'Switzerland','CH','CHE',1); INSERT INTO countries VALUES (205,'Syrian Arab Republic','SY','SYR',1); INSERT INTO countries VALUES (206,'Taiwan','TW','TWN',1); INSERT INTO countries VALUES (207,'Tajikistan','TJ','TJK',1); INSERT INTO countries VALUES (208,'Tanzania, United Republic of','TZ','TZA',1); INSERT INTO countries VALUES (209,'Thailand','TH','THA',1); INSERT INTO countries VALUES (210,'Togo','TG','TGO',1); INSERT INTO countries VALUES (211,'Tokelau','TK','TKL',1); INSERT INTO countries VALUES (212,'Tonga','TO','TON',1); INSERT INTO countries VALUES (213,'Trinidad and Tobago','TT','TTO',1); INSERT INTO countries VALUES (214,'Tunisia','TN','TUN',1); INSERT INTO countries VALUES (215,'Turkey','TR','TUR',1); INSERT INTO countries VALUES (216,'Turkmenistan','TM','TKM',1); INSERT INTO countries VALUES (217,'Turks and Caicos Islands','TC','TCA',1); INSERT INTO countries VALUES (218,'Tuvalu','TV','TUV',1); INSERT INTO countries VALUES (219,'Uganda','UG','UGA',1); INSERT INTO countries VALUES (220,'Ukraine','UA','UKR',1); INSERT INTO countries VALUES (221,'United Arab Emirates','AE','ARE',1); INSERT INTO countries VALUES (222,'United Kingdom','GB','GBR',1); INSERT INTO countries VALUES (223,'United States','US','USA',2); INSERT INTO countries VALUES (224,'United States Minor Outlying Islands','UM','UMI',1); INSERT INTO countries VALUES (225,'Uruguay','UY','URY',1); INSERT INTO countries VALUES (226,'Uzbekistan','UZ','UZB',1); INSERT INTO countries VALUES (227,'Vanuatu','VU','VUT',1); INSERT INTO countries VALUES (228,'Vatican City State (Holy See)','VA','VAT',1); INSERT INTO countries VALUES (229,'Venezuela','VE','VEN',1); INSERT INTO countries VALUES (230,'Viet Nam','VN','VNM',1); INSERT INTO countries VALUES (231,'Virgin Islands (British)','VG','VGB',1); INSERT INTO countries VALUES (232,'Virgin Islands (U.S.)','VI','VIR',1); INSERT INTO countries VALUES (233,'Wallis and Futuna Islands','WF','WLF',1); INSERT INTO countries VALUES (234,'Western Sahara','EH','ESH',1); INSERT INTO countries VALUES (235,'Yemen','YE','YEM',1); INSERT INTO countries VALUES (236,'Yugoslavia','YU','YUG',1); INSERT INTO countries VALUES (237,'Zaire','ZR','ZAR',1); INSERT INTO countries VALUES (238,'Zambia','ZM','ZMB',1); INSERT INTO countries VALUES (239,'Zimbabwe','ZW','ZWE',1); -- -- Table structure for table `currencies` -- CREATE TABLE currencies ( currencies_id int(11) NOT NULL auto_increment, title varchar(32) NOT NULL default '', code char(3) NOT NULL default '', symbol_left varchar(12) default NULL, symbol_right varchar(12) default NULL, decimal_point char(1) default NULL, thousands_point char(1) default NULL, decimal_places char(1) default NULL, value float(13,8) default NULL, last_updated datetime default NULL, PRIMARY KEY (currencies_id) ) TYPE=MyISAM; -- -- Dumping data for table `currencies` -- INSERT INTO currencies VALUES (1,'US Dollar','USD','$','','.',',','2',1.00000000,'2005-08-11 14:56:10'); INSERT INTO currencies VALUES (2,'Euro','EUR','','EUR','.',',','2',1.10360003,'2005-08-11 14:56:10'); -- -- Table structure for table `customers` -- CREATE TABLE customers ( customers_id int(11) NOT NULL auto_increment, customers_gender char(1) NOT NULL default '', customers_firstname varchar(32) NOT NULL default '', customers_lastname varchar(32) NOT NULL default '', customers_dob datetime NOT NULL default '0000-00-00 00:00:00', customers_email_address varchar(96) NOT NULL default '', customers_default_address_id int(11) NOT NULL default '0', customers_telephone varchar(32) NOT NULL default '', customers_fax varchar(32) default NULL, customers_password varchar(40) NOT NULL default '', customers_newsletter char(1) default NULL, PRIMARY KEY (customers_id) ) TYPE=MyISAM; -- -- Dumping data for table `customers` -- INSERT INTO customers VALUES (2,'m','John','Robben','1955-05-01 00:00:00','john@ultimatewatermassage.com',12,'800-589-1509','','7f7c3096a29e4753ac294d4c95454e1e:3f','1'); INSERT INTO customers VALUES (15,'','Evelyn','Ruiz','1960-01-07 00:00:00','yogy1960@yahoo.com',17,'203 235-4123','','1470174256e57049a493288251958cc2:d0',''); INSERT INTO customers VALUES (12,'','Karen','Lindley','1982-02-12 00:00:00','lindleyk@comcast.net',13,'541-517-8593','','9d42743bbcc75ddbb05aaf1830bcf4ba:3e',''); INSERT INTO customers VALUES (13,'','Karen','Sloan','1968-03-05 00:00:00','shipping@ultimatewatermassage.com',15,'1-800-589-1509','','1ad512ac844653167f246bbf950ad2ed:b9',''); INSERT INTO customers VALUES (14,'','cheryl','thompson','1955-12-28 00:00:00','nutsrus@dc4pc.net',16,'none','','be14733bcdf16d2b8ceda071ddff90db:df','1'); INSERT INTO customers VALUES (11,'','Tarun','Kumar','1970-05-21 00:00:00','definetarun@gmail.com',11,'123456789123','','25004d0f83e5db46654583e0e060c59b:65',''); -- -- Table structure for table `customers_basket` -- CREATE TABLE customers_basket ( customers_basket_id int(11) NOT NULL auto_increment, customers_id int(11) NOT NULL default '0', products_id tinytext NOT NULL, customers_basket_quantity int(2) NOT NULL default '0', final_price decimal(15,4) NOT NULL default '0.0000', customers_basket_date_added varchar(8) default NULL, PRIMARY KEY (customers_basket_id) ) TYPE=MyISAM; -- -- Dumping data for table `customers_basket` -- -- -- Table structure for table `customers_basket_attributes` -- CREATE TABLE customers_basket_attributes ( customers_basket_attributes_id int(11) NOT NULL auto_increment, customers_id int(11) NOT NULL default '0', products_id tinytext NOT NULL, products_options_id int(11) NOT NULL default '0', products_options_value_id int(11) NOT NULL default '0', PRIMARY KEY (customers_basket_attributes_id) ) TYPE=MyISAM; -- -- Dumping data for table `customers_basket_attributes` -- -- -- Table structure for table `customers_info` -- CREATE TABLE customers_info ( customers_info_id int(11) NOT NULL default '0', customers_info_date_of_last_logon datetime default NULL, customers_info_number_of_logons int(5) default NULL, customers_info_date_account_created datetime default NULL, customers_info_date_account_last_modified datetime default NULL, global_product_notifications int(1) default '0', PRIMARY KEY (customers_info_id) ) TYPE=MyISAM; -- -- Dumping data for table `customers_info` -- INSERT INTO customers_info VALUES (2,'2006-03-28 21:33:23',29,'2005-11-21 10:32:51',NULL,0); INSERT INTO customers_info VALUES (14,NULL,0,'2006-06-02 20:04:56',NULL,0); INSERT INTO customers_info VALUES (13,NULL,0,'2006-05-10 09:30:43',NULL,0); INSERT INTO customers_info VALUES (12,'2006-04-07 07:31:54',2,'2006-04-06 13:20:19',NULL,0); INSERT INTO customers_info VALUES (15,NULL,0,'2006-11-02 09:44:24',NULL,0); INSERT INTO customers_info VALUES (11,'2006-02-13 02:38:06',56,'2005-12-24 06:56:42',NULL,0); -- -- Table structure for table `geo_zones` -- CREATE TABLE geo_zones ( geo_zone_id int(11) NOT NULL auto_increment, geo_zone_name varchar(32) NOT NULL default '', geo_zone_description varchar(255) NOT NULL default '', last_modified datetime default NULL, date_added datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (geo_zone_id) ) TYPE=MyISAM; -- -- Dumping data for table `geo_zones` -- INSERT INTO geo_zones VALUES (1,'Florida','Florida local sales tax zone','0000-00-00 00:00:00','2005-08-11 14:56:11'); -- -- Table structure for table `languages` -- CREATE TABLE languages ( languages_id int(11) NOT NULL auto_increment, name varchar(32) NOT NULL default '', code char(2) NOT NULL default '', image varchar(64) default NULL, directory varchar(32) default NULL, sort_order int(3) default NULL, PRIMARY KEY (languages_id), KEY IDX_LANGUAGES_NAME (name) ) TYPE=MyISAM; -- -- Dumping data for table `languages` -- INSERT INTO languages VALUES (1,'English','en','icon.gif','english',1); INSERT INTO languages VALUES (2,'Deutsch','de','icon.gif','german',2); INSERT INTO languages VALUES (3,'Espaņol','es','icon.gif','espanol',3); -- -- Table structure for table `manufacturers` -- CREATE TABLE manufacturers ( manufacturers_id int(11) NOT NULL auto_increment, manufacturers_name varchar(32) NOT NULL default '', manufacturers_image varchar(64) default NULL, date_added datetime default NULL, last_modified datetime default NULL, PRIMARY KEY (manufacturers_id), KEY IDX_MANUFACTURERS_NAME (manufacturers_name) ) TYPE=MyISAM; -- -- Dumping data for table `manufacturers` -- INSERT INTO manufacturers VALUES (6,'Kelley Kinetic','','2005-12-17 16:16:48','2005-12-17 16:16:48'); INSERT INTO manufacturers VALUES (5,'Pointer Pressure','','2005-12-17 16:16:48','2005-12-17 16:16:48'); INSERT INTO manufacturers VALUES (1,'Ultimate Water Massage','','2005-12-17 07:00:39','2005-12-17 07:00:39'); INSERT INTO manufacturers VALUES (7,'Health Body','','2005-12-17 16:16:48','2005-12-17 16:16:48'); INSERT INTO manufacturers VALUES (8,'Body','','2005-12-17 16:16:48','2005-12-17 16:16:48'); INSERT INTO manufacturers VALUES (2,'Body Rub','','2005-12-17 16:14:25','2005-12-17 16:14:25'); INSERT INTO manufacturers VALUES (3,'Kenshin','','2005-12-17 16:16:48','2005-12-17 16:16:48'); INSERT INTO manufacturers VALUES (4,'County Meadows','','2005-12-17 16:16:48','2005-12-17 16:16:48'); INSERT INTO manufacturers VALUES (9,'Mil','','2005-12-17 16:16:48','2005-12-17 16:16:48'); INSERT INTO manufacturers VALUES (10,'Earthstone','','2005-12-17 16:16:48','2005-12-17 16:16:48'); INSERT INTO manufacturers VALUES (11,'Aqua Aire','','2005-12-17 16:16:48','2005-12-17 16:16:48'); INSERT INTO manufacturers VALUES (12,'Omnimassage','','2005-12-17 16:16:48','2005-12-17 16:16:48'); INSERT INTO manufacturers VALUES (13,'Bongers','','2005-12-17 16:16:48','2005-12-17 16:16:48'); INSERT INTO manufacturers VALUES (14,'The Happy Co','','2005-12-17 16:16:48','2005-12-17 16:16:48'); INSERT INTO manufacturers VALUES (15,'Pressure Positive','','2005-12-17 16:16:48','2005-12-17 16:16:48'); INSERT INTO manufacturers VALUES (16,'Relaxs','','2005-12-17 16:16:48','2005-12-17 16:16:48'); INSERT INTO manufacturers VALUES (17,'Happy Co','','2005-12-17 16:16:48','2005-12-17 16:16:48'); INSERT INTO manufacturers VALUES (18,'Heaven','','2005-12-17 16:16:49','2005-12-17 16:16:49'); INSERT INTO manufacturers VALUES (19,'AromaLand','','2005-12-17 16:16:49','2005-12-17 16:16:49'); INSERT INTO manufacturers VALUES (20,'JT','','2005-12-17 16:16:49','2005-12-17 16:16:49'); INSERT INTO manufacturers VALUES (21,'Aromalife','','2005-12-17 16:16:49','2005-12-17 16:16:49'); INSERT INTO manufacturers VALUES (22,'SunPen','','2005-12-17 16:16:49','2005-12-17 16:16:49'); INSERT INTO manufacturers VALUES (23,'YCY','','2005-12-17 16:16:49','2005-12-17 16:16:49'); INSERT INTO manufacturers VALUES (24,'MILPOS','','2005-12-17 16:16:49','2005-12-17 16:16:49'); INSERT INTO manufacturers VALUES (25,'Nada Chair','','2005-12-17 16:16:49','2005-12-17 16:16:49'); INSERT INTO manufacturers VALUES (26,'Medicine Flower','','2005-12-17 16:16:49','2005-12-17 16:16:49'); INSERT INTO manufacturers VALUES (27,'MILG5','','2005-12-17 16:16:49','2005-12-17 16:16:49'); INSERT INTO manufacturers VALUES (28,'Jeanie','','2005-12-17 16:16:49','2005-12-17 16:16:49'); INSERT INTO manufacturers VALUES (29,'Massage Genius','','2005-12-17 16:16:49','2005-12-17 16:16:49'); INSERT INTO manufacturers VALUES (30,'Amrita','','2005-12-17 16:16:50','2005-12-17 16:16:50'); INSERT INTO manufacturers VALUES (31,'Homedic','','2005-12-17 16:16:50','2005-12-17 16:16:50'); INSERT INTO manufacturers VALUES (32,'Roloke','','2005-12-17 16:16:50','2005-12-17 16:16:50'); INSERT INTO manufacturers VALUES (33,'BaxPort','','2005-12-17 16:54:05','2005-12-17 16:54:05'); INSERT INTO manufacturers VALUES (34,'Aircast','','2005-12-17 16:54:05','2005-12-17 16:54:05'); INSERT INTO manufacturers VALUES (35,'Copper Cobra','','2005-12-17 16:54:05','2005-12-17 16:54:05'); INSERT INTO manufacturers VALUES (36,'Maxtor','','2005-12-17 16:54:05','2005-12-17 16:54:05'); INSERT INTO manufacturers VALUES (37,'Buckwheat Therapy','','2005-12-17 16:54:05','2005-12-17 16:54:05'); INSERT INTO manufacturers VALUES (38,'Precious Aromatherapy','','2005-12-17 16:54:06','2005-12-17 16:54:06'); INSERT INTO manufacturers VALUES (39,'Kits and Kabootles','','2005-12-17 16:54:06','2005-12-17 16:54:06'); INSERT INTO manufacturers VALUES (40,'Herbal Concepts','','2005-12-17 16:54:06','2005-12-17 16:54:06'); INSERT INTO manufacturers VALUES (41,'Makua','','2005-12-17 16:54:06','2005-12-17 16:54:06'); INSERT INTO manufacturers VALUES (42,'Ross Products','','2005-12-17 16:54:06','2005-12-17 16:54:06'); INSERT INTO manufacturers VALUES (43,'Invacare Supply Group','','2005-12-17 16:54:06','2005-12-17 16:54:06'); INSERT INTO manufacturers VALUES (44,'DreamTime','','2005-12-17 16:54:06','2005-12-17 16:54:06'); INSERT INTO manufacturers VALUES (45,'Uplift Technologies','','2005-12-17 16:54:06','2005-12-17 16:54:06'); INSERT INTO manufacturers VALUES (46,'All Pro Exercise Product','','2005-12-17 16:54:06','2005-12-17 16:54:06'); INSERT INTO manufacturers VALUES (47,'Us Pharmacal','','2005-12-17 16:54:06','2005-12-17 16:54:06'); INSERT INTO manufacturers VALUES (48,'Hermell','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (49,'Homecare Products','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (50,'DJ Orthopedics','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (51,'Wenzelite Rehab','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (52,'Denren','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (53,'Kimberly Clark','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (54,'Medport','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (55,'LifeScan','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (56,'BSN - Jobst','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (57,'Invacare','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (58,'Conair','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (59,'Respironics','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (60,'Mediflow','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (61,'Mountain Properties','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (62,'Medicool','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (63,'Omron','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (64,'Pari Respiratory','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (65,'Owen-Mumford','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (66,'Therasense','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (67,'Camp','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (68,'Sims Portex','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (69,'Hollister','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (70,'Fisher & Paykel Healthcare','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (71,'Mentor Corporation','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (72,'Principle Business Enterprises','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (73,'Triad Medical - H.P. Industries','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (74,'Molnlycke Healthcare','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (75,'Kendall','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (76,'Ballard','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (77,'Amd Ritmed Inc','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (78,'Biomedical Life Systems','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (79,'American Diagnostic','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (80,'Smith & Nephew','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (81,'Crown Therapeutics','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (82,'HoMedics','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (83,'Waterbury Companies','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (84,'Victor','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (85,'Veridien','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (86,'Val Med','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (87,'Uresil Corporation','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (88,'Urocare','','2005-12-17 16:54:07','2005-12-17 16:54:07'); INSERT INTO manufacturers VALUES (89,'Uni-Patch','','2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO manufacturers VALUES (90,'Universal Caddy','','2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO manufacturers VALUES (91,'Trademark','','2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO manufacturers VALUES (92,'Tubular Fabricators','','2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO manufacturers VALUES (93,'Tagg Industries','','2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO manufacturers VALUES (94,'Southwest Technologies','','2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO manufacturers VALUES (95,'Sunbeam','','2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO manufacturers VALUES (96,'ConvaTec','','2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO manufacturers VALUES (97,'Spenco','','2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO manufacturers VALUES (98,'Salter Labs','','2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO manufacturers VALUES (99,'Silipos','','2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO manufacturers VALUES (100,'Sheepskin Ranch','','2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO manufacturers VALUES (101,'Seca','','2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO manufacturers VALUES (102,'SCA Hygiene Products','','2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO manufacturers VALUES (103,'Scott Specialties','','2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO manufacturers VALUES (104,'Salk','','2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO manufacturers VALUES (105,'Marpac','','2005-12-17 16:54:08','2005-12-17 16:54:08'); INSERT INTO manufacturers VALUES (106,'Rochester Medical','','2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO manufacturers VALUES (107,'Reachgood Industrial Company','','2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO manufacturers VALUES (108,'Providence Spillproof Container','','2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO manufacturers VALUES (109,'Parthenon','','2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO manufacturers VALUES (110,'PaperPak','','2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO manufacturers VALUES (111,'Premium Plastics','','2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO manufacturers VALUES (112,'Posey','','2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO manufacturers VALUES (113,'Penco Medical','','2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO manufacturers VALUES (114,'Timm Medical','','2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO manufacturers VALUES (115,'Nytone','','2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO manufacturers VALUES (116,'NuHope','','2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO manufacturers VALUES (117,'Nutech','','2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO manufacturers VALUES (118,'N/R Laboratories','','2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO manufacturers VALUES (119,'Nite Train\'r','','2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO manufacturers VALUES (120,'Nestle Clinical Nutrition','','2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO manufacturers VALUES (121,'Conmed','','2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO manufacturers VALUES (122,'NDL Products','','2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO manufacturers VALUES (123,'Mobility Transfer','','2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO manufacturers VALUES (124,'MediSense','','2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO manufacturers VALUES (125,'Vital Signs','','2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO manufacturers VALUES (126,'Montreal Ostomy','','2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO manufacturers VALUES (127,'Medmart','','2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO manufacturers VALUES (128,'3M','','2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO manufacturers VALUES (129,'Priva','','2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO manufacturers VALUES (130,'Medical World','','2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO manufacturers VALUES (131,'Medical Devices','','2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO manufacturers VALUES (132,'Medela','','2005-12-17 16:54:09','2005-12-17 16:54:09'); INSERT INTO manufacturers VALUES (133,'M. C. Johnson','','2005-12-17 16:54:10','2005-12-17 16:54:10'); INSERT INTO manufacturers VALUES (134,'Mallinckrodt','','2005-12-17 16:54:10','2005-12-17 16:54:10'); INSERT INTO manufacturers VALUES (135,'Lumiscope','','2005-12-17 16:54:10','2005-12-17 16:54:10'); INSERT INTO manufacturers VALUES (136,'KEM Enterprises','','2005-12-17 16:54:10','2005-12-17 16:54:10'); INSERT INTO manufacturers VALUES (137,'Johnson & Johnson','','2005-12-17 16:54:10','2005-12-17 16:54:10'); INSERT INTO manufacturers VALUES (138,'Jay Medical','','2005-12-17 16:54:10','2005-12-17 16:54:10'); INSERT INTO manufacturers VALUES (139,'Huntleigh Healthcare','','2005-12-17 16:54:11','2005-12-17 16:54:11'); INSERT INTO manufacturers VALUES (140,'Humanicare International Inc.','','2005-12-17 16:54:11','2005-12-17 16:54:11'); INSERT INTO manufacturers VALUES (141,'Hudson RCI','','2005-12-17 16:54:11','2005-12-17 16:54:11'); INSERT INTO manufacturers VALUES (142,'Healthpoint Medical','','2005-12-17 16:54:11','2005-12-17 16:54:11'); INSERT INTO manufacturers VALUES (143,'Health Enterprises','','2005-12-17 16:54:12','2005-12-17 16:54:12'); INSERT INTO manufacturers VALUES (144,'Hudson Medical','','2005-12-17 16:54:12','2005-12-17 16:54:12'); INSERT INTO manufacturers VALUES (145,'Sage','','2005-12-17 16:54:12','2005-12-17 16:54:12'); INSERT INTO manufacturers VALUES (146,'Gaymar Industries','','2005-12-17 16:54:13','2005-12-17 16:54:13'); INSERT INTO manufacturers VALUES (147,'Global Unlimited','','2005-12-17 16:54:13','2005-12-17 16:54:13'); INSERT INTO manufacturers VALUES (148,'FNC Medical','','2005-12-17 16:54:13','2005-12-17 16:54:13'); INSERT INTO manufacturers VALUES (149,'Environmental Care Center','','2005-12-17 16:54:13','2005-12-17 16:54:13'); INSERT INTO manufacturers VALUES (150,'Encore','','2005-12-17 16:54:13','2005-12-17 16:54:13'); INSERT INTO manufacturers VALUES (151,'Swiss-American','','2005-12-17 16:54:13','2005-12-17 16:54:13'); INSERT INTO manufacturers VALUES (152,'Duro-Med','','2005-12-17 16:54:13','2005-12-17 16:54:13'); INSERT INTO manufacturers VALUES (153,'DeRoyal','','2005-12-17 16:54:13','2005-12-17 16:54:13'); INSERT INTO manufacturers VALUES (154,'Devilbiss','','2005-12-17 16:54:13','2005-12-17 16:54:13'); INSERT INTO manufacturers VALUES (155,'Dermasciences','','2005-12-17 16:54:13','2005-12-17 16:54:13'); INSERT INTO manufacturers VALUES (156,'Carrington','','2005-12-17 16:54:13','2005-12-17 16:54:13'); INSERT INTO manufacturers VALUES (157,'Consolidated Products','','2005-12-17 16:54:13','2005-12-17 16:54:13'); INSERT INTO manufacturers VALUES (158,'Coloplast','','2005-12-17 16:54:13','2005-12-17 16:54:13'); INSERT INTO manufacturers VALUES (159,'Calmoseptine','','2005-12-17 16:54:14','2005-12-17 16:54:14'); INSERT INTO manufacturers VALUES (160,'Concepts in Confidence','','2005-12-17 16:54:14','2005-12-17 16:54:14'); INSERT INTO manufacturers VALUES (161,'Dewitt','','2005-12-17 16:54:14','2005-12-17 16:54:14'); INSERT INTO manufacturers VALUES (162,'Hypoguard','','2005-12-17 16:54:14','2005-12-17 16:54:14'); INSERT INTO manufacturers VALUES (163,'Rubbermaid','','2005-12-17 16:54:14','2005-12-17 16:54:14'); INSERT INTO manufacturers VALUES (164,'Can-Am Care','','2005-12-17 16:54:14','2005-12-17 16:54:14'); INSERT INTO manufacturers VALUES (165,'Battle Creek','','2005-12-17 16:54:14','2005-12-17 16:54:14'); INSERT INTO manufacturers VALUES (166,'Bard','','2005-12-17 16:54:14','2005-12-17 16:54:14'); INSERT INTO manufacturers VALUES (167,'Becton Dickinson','','2005-12-17 16:54:14','2005-12-17 16:54:14'); INSERT INTO manufacturers VALUES (168,'Blairex Labs','','2005-12-17 16:54:14','2005-12-17 16:54:14'); INSERT INTO manufacturers VALUES (169,'Roche Diagnostics','','2005-12-17 16:54:14','2005-12-17 16:54:14'); INSERT INTO manufacturers VALUES (170,'Bed Handlers, Inc.','','2005-12-17 16:54:15','2005-12-17 16:54:15'); INSERT INTO manufacturers VALUES (171,'Allegiance','','2005-12-17 16:54:15','2005-12-17 16:54:15'); INSERT INTO manufacturers VALUES (172,'Arcmate','','2005-12-17 16:54:15','2005-12-17 16:54:15'); INSERT INTO manufacturers VALUES (173,'Apex Medical','','2005-12-17 16:54:15','2005-12-17 16:54:15'); INSERT INTO manufacturers VALUES (174,'A+ Medical','','2005-12-17 16:54:15','2005-12-17 16:54:15'); INSERT INTO manufacturers VALUES (175,'Action Products','','2005-12-17 16:54:15','2005-12-17 16:54:15'); INSERT INTO manufacturers VALUES (176,'Bayer','','2005-12-17 16:54:15','2005-12-17 16:54:15'); INSERT INTO manufacturers VALUES (177,'AliMed','','2005-12-17 16:54:15','2005-12-17 16:54:15'); INSERT INTO manufacturers VALUES (178,'AccuTech, LLC','','2005-12-17 16:54:15','2005-12-17 16:54:15'); INSERT INTO manufacturers VALUES (179,'Vitabase','','2005-12-17 16:54:15','2005-12-17 16:54:15'); -- -- Table structure for table `manufacturers_info` -- CREATE TABLE manufacturers_info ( manufacturers_id int(11) NOT NULL default '0', languages_id int(11) NOT NULL default '0', manufacturers_url varchar(255) NOT NULL default '', url_clicked int(5) NOT NULL default '0', date_last_click datetime default NULL, PRIMARY KEY (manufacturers_id,languages_id) ) TYPE=MyISAM; -- -- Dumping data for table `manufacturers_info` -- -- -- Table structure for table `newsletters` -- CREATE TABLE newsletters ( newsletters_id int(11) NOT NULL auto_increment, title varchar(255) NOT NULL default '', content text NOT NULL, module varchar(255) NOT NULL default '', date_added datetime NOT NULL default '0000-00-00 00:00:00', date_sent datetime default NULL, status int(1) default NULL, locked int(1) default '0', PRIMARY KEY (newsletters_id) ) TYPE=MyISAM; -- -- Dumping data for table `newsletters` -- -- -- Table structure for table `orders` -- CREATE TABLE orders ( orders_id int(11) NOT NULL auto_increment, customers_id int(11) NOT NULL default '0', customers_name varchar(64) NOT NULL default '', customers_company varchar(32) default NULL, customers_street_address varchar(64) NOT NULL default '', customers_suburb varchar(32) default NULL, customers_city varchar(32) NOT NULL default '', customers_postcode varchar(10) NOT NULL default '', customers_state varchar(32) default NULL, customers_country varchar(32) NOT NULL default '', customers_telephone varchar(32) NOT NULL default '', customers_email_address varchar(96) NOT NULL default '', customers_address_format_id int(5) NOT NULL default '0', delivery_name varchar(64) NOT NULL default '', delivery_company varchar(32) default NULL, delivery_street_address varchar(64) NOT NULL default '', delivery_suburb varchar(32) default NULL, delivery_city varchar(32) NOT NULL default '', delivery_postcode varchar(10) NOT NULL default '', delivery_state varchar(32) default NULL, delivery_country varchar(32) NOT NULL default '', delivery_address_format_id int(5) NOT NULL default '0', billing_name varchar(64) NOT NULL default '', billing_company varchar(32) default NULL, billing_street_address varchar(64) NOT NULL default '', billing_suburb varchar(32) default NULL, billing_city varchar(32) NOT NULL default '', billing_postcode varchar(10) NOT NULL default '', billing_state varchar(32) default NULL, billing_country varchar(32) NOT NULL default '', billing_address_format_id int(5) NOT NULL default '0', payment_method varchar(32) NOT NULL default '', cc_type varchar(20) default NULL, cc_owner varchar(64) default NULL, cc_number varchar(32) default NULL, cc_expires varchar(4) default NULL, last_modified datetime default NULL, date_purchased datetime default NULL, orders_status int(5) NOT NULL default '0', orders_date_finished datetime default NULL, currency char(3) default NULL, currency_value decimal(14,6) default NULL, PRIMARY KEY (orders_id) ) TYPE=MyISAM; -- -- Dumping data for table `orders` -- INSERT INTO orders VALUES (113,15,'Evelyn Ruiz','','165 Newton St','','Meriden','06450','Connecticut','United States','203 235-4123','yogy1960@yahoo.com',2,'Evelyn Ruiz','','165 Newton St','','Meriden','06450','Connecticut','United States',2,'Evelyn Ruiz','','165 Newton St','','Meriden','06450','Connecticut','United States',2,'We Accept: Visa, Mastercard','','','','',NULL,'2006-11-02 09:51:12',1,NULL,'USD','1.000000'); -- -- Table structure for table `orders_products` -- CREATE TABLE orders_products ( orders_products_id int(11) NOT NULL auto_increment, orders_id int(11) NOT NULL default '0', products_id int(11) NOT NULL default '0', products_model varchar(12) default NULL, products_name varchar(64) NOT NULL default '', products_price decimal(15,4) NOT NULL default '0.0000', final_price decimal(15,4) NOT NULL default '0.0000', products_tax decimal(7,4) NOT NULL default '0.0000', products_quantity int(2) NOT NULL default '0', PRIMARY KEY (orders_products_id) ) TYPE=MyISAM; -- -- Dumping data for table `orders_products` -- INSERT INTO orders_products VALUES (133,113,969,'045-045','Comfort Pack 7\"x14\" Regular','10.9900','10.9900','0.0000',1); -- -- Table structure for table `orders_products_attributes` -- CREATE TABLE orders_products_attributes ( orders_products_attributes_id int(11) NOT NULL auto_increment, orders_id int(11) NOT NULL default '0', orders_products_id int(11) NOT NULL default '0', products_options varchar(32) NOT NULL default '', products_options_values varchar(32) NOT NULL default '', options_values_price decimal(15,4) NOT NULL default '0.0000', price_prefix char(1) NOT NULL default '', PRIMARY KEY (orders_products_attributes_id) ) TYPE=MyISAM; -- -- Dumping data for table `orders_products_attributes` -- -- -- Table structure for table `orders_products_download` -- CREATE TABLE orders_products_download ( orders_products_download_id int(11) NOT NULL auto_increment, orders_id int(11) NOT NULL default '0', orders_products_id int(11) NOT NULL default '0', orders_products_filename varchar(255) NOT NULL default '', download_maxdays int(2) NOT NULL default '0', download_count int(2) NOT NULL default '0', PRIMARY KEY (orders_products_download_id) ) TYPE=MyISAM; -- -- Dumping data for table `orders_products_download` -- -- -- Table structure for table `orders_status` -- CREATE TABLE orders_status ( orders_status_id int(11) NOT NULL default '0', language_id int(11) NOT NULL default '1', orders_status_name varchar(32) NOT NULL default '', PRIMARY KEY (orders_status_id,language_id), KEY idx_orders_status_name (orders_status_name) ) TYPE=MyISAM; -- -- Dumping data for table `orders_status` -- INSERT INTO orders_status VALUES (1,1,'Pending'); INSERT INTO orders_status VALUES (1,2,'Offen'); INSERT INTO orders_status VALUES (1,3,'Pendiente'); INSERT INTO orders_status VALUES (2,1,'Processing'); INSERT INTO orders_status VALUES (2,2,'In Bearbeitung'); INSERT INTO orders_status VALUES (2,3,'Proceso'); INSERT INTO orders_status VALUES (3,1,'Delivered'); INSERT INTO orders_status VALUES (3,2,'Versendet'); INSERT INTO orders_status VALUES (3,3,'Entregado'); -- -- Table structure for table `orders_status_history` -- CREATE TABLE orders_status_history ( orders_status_history_id int(11) NOT NULL auto_increment, orders_id int(11) NOT NULL default '0', orders_status_id int(5) NOT NULL default '0', date_added datetime NOT NULL default '0000-00-00 00:00:00', customer_notified int(1) default '0', comments text, PRIMARY KEY (orders_status_history_id) ) TYPE=MyISAM; -- -- Dumping data for table `orders_status_history` -- INSERT INTO orders_status_history VALUES (114,113,1,'2006-11-02 09:51:12',1,'Please if possible ship overnight, my sister has cancer and this seem to eliviate her back pain.'); -- -- Table structure for table `orders_total` -- CREATE TABLE orders_total ( orders_total_id int(10) unsigned NOT NULL auto_increment, orders_id int(11) NOT NULL default '0', title varchar(255) NOT NULL default '', text varchar(255) NOT NULL default '', value decimal(15,4) NOT NULL default '0.0000', class varchar(32) NOT NULL default '', sort_order int(11) NOT NULL default '0', PRIMARY KEY (orders_total_id), KEY idx_orders_total_orders_id (orders_id) ) TYPE=MyISAM; -- -- Dumping data for table `orders_total` -- INSERT INTO orders_total VALUES (337,113,'Sub-Total:','$10.99','10.9900','ot_subtotal',1); INSERT INTO orders_total VALUES (338,113,'Table Rate (Best Way):','$6.99','6.9900','ot_shipping',2); INSERT INTO orders_total VALUES (339,113,'Total:','$17.98','17.9800','ot_total',4); -- -- Table structure for table `products` -- CREATE TABLE products ( products_id int(11) NOT NULL auto_increment, products_quantity int(4) NOT NULL default '0', products_model varchar(12) default NULL, products_image varchar(64) default NULL, products_price decimal(15,4) NOT NULL default '0.0000', products_date_added datetime NOT NULL default '0000-00-00 00:00:00', products_last_modified datetime default NULL, products_date_available datetime default NULL, products_weight decimal(5,2) NOT NULL default '0.00', products_status tinyint(1) NOT NULL default '0', products_tax_class_id int(11) NOT NULL default '0', manufacturers_id int(11) default NULL, products_ordered int(11) NOT NULL default '0', PRIMARY KEY (products_id), KEY idx_products_date_added (products_date_added) ) TYPE=MyISAM; -- -- Dumping data for table `products` -- INSERT INTO products VALUES (1169,1,'019479-ISG-S','isg/q-t/SCT61120_200.jpg','26.4500','2005-12-17 16:54:08','2005-12-17 16:54:08',NULL,'0.00',1,0,102,0); INSERT INTO products VALUES (1168,1,'019480-ISG-S','isg/q-t/SCT61209_200.jpg','9.7600','2005-12-17 16:54:08','2005-12-17 16:54:08',NULL,'0.00',1,0,102,0); INSERT INTO products VALUES (1057,1,'020720-ISG-M','isg/m-p/MNT_10911_200.jpg','12.2900','2005-12-17 16:54:07','2005-12-17 16:54:07',NULL,'0.00',1,0,61,0); INSERT INTO products VALUES (1044,1,'020901-ISG-O','isg/m-p/OWNATO465_200.jpg','6.7400','2005-12-17 16:54:07','2005-12-17 16:54:07',NULL,'0.00',1,0,65,0); INSERT INTO products VALUES (1045,1,'020894-ISG-T','isg/q-t/TSI11001BIG_200.jpg','120.0800','2005-12-17 16:54:07','2005-12-17 16:54:07',NULL,'0.00',1,0,66,0); INSERT INTO products VALUES (1046,1,'020843-ISG-C','isg/a-d/CMP82000_200.jpg','384.0000','2005-12-17 16:54:07','2005-12-17 16:54:07',NULL,'0.00',1,0,67,0); INSERT INTO products VALUES (1047,1,'020821-ISG-S','isg/q-t/SPX670165_200.jpg','176.0000','2005-12-17 16:54:07','2005-12-17 16:54:07',NULL,'0.00',1,0,68,0); INSERT INTO products VALUES (1048,1,'020810-ISG-T','isg/q-t/TSI12050_SH_200.jpg','82.2900','2005-12-17 16:54:07','2005-12-17 16:54:07',NULL,'0.00',1,0,66,0); INSERT INTO products VALUES (1049,1,'020800-ISG-H','isg/e-h/HOL79400_200.jpg','68.5300','2005-12-17 16:54:07','2005-12-17 16:54:07',NULL,'0.00',1,0,69,0); INSERT INTO products VALUES (1050,1,'020799-ISG-H','isg/e-h/HOL79300_200.jpg','12.9500','2005-12-17 16:54:07','2005-12-17 16:54:07',NULL,'0.00',1,0,69,0); INSERT INTO products VALUES (1051,1,'020795-ISG-R','isg/q-t/ROS57024_200.jpg','71.1400','2005-12-17 16:54:07','2005-12-17 16:54:07',NULL,'0.00',1,0,42,0); INSERT INTO products VALUES (1052,1,'020793-ISG-F','isg/e-h/FPK900HC401A_200.jpg','103.2300','2005-12-17 16:54:07','2005-12-17 16:54:07',NULL,'0.00',1,0,70,0); INSERT INTO products VALUES (1053,1,'020782-ISG-F','isg/e-h/FPKHC221JHU_200.jpg','747.4600','2005-12-17 16:54:07','2005-12-17 16:54:07',NULL,'0.00',1,0,70,0); INSERT INTO products VALUES (1054,1,'020752-ISG-R','isg/q-t/ROS00245_200.jpg','75.6500','2005-12-17 16:54:07','2005-12-17 16:54:07',NULL,'0.00',1,0,42,0); INSERT INTO products VALUES (1055,1,'020733-ISG-M','isg/m-p/MEN2316_200.jpg','8.8800','2005-12-17 16:54:07','2005-12-17 16:54:07',NULL,'0.00',1,0,71,0); INSERT INTO products VALUES (1056,1,'020722-ISG-T','isg/q-t/TRA2190_200.jpg','128.9100','2005-12-17 16:54:07','2005-12-17 16:54:07',NULL,'0.00',1,0,72,0); INSERT INTO products VALUES (975,1,'038-JCP-038','products/buckwheat-mt-hulls-girl_200.jpg','10.9900','2005-12-17 16:54:06','2005-12-17 16:54:06',NULL,'0.00',1,0,41,0); INSERT INTO products VALUES (976,1,'037-037','products/mt-pillow-cover_200.jpg','7.9900','2005-12-17 16:54:06','2005-12-17 16:54:06',NULL,'0.00',1,0,41,0);