-- 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',
  `products_prid` tinytext NOT NULL,
  PRIMARY KEY  (`orders_products_download_id`),
  KEY `idx_orders_id_zen` (`orders_id`),
  KEY `idx_orders_products_id_zen` (`orders_products_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- 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_zen` (`orders_status_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `orders_status` VALUES (1,1,'Pending'),(2,1,'Processing'),(3,1,'Delivered'),(4,1,'Update');

--
-- 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 '0001-01-01 00:00:00',
  `customer_notified` int(1) default '0',
  `comments` text,
  PRIMARY KEY  (`orders_status_history_id`),
  KEY `idx_orders_id_status_id_zen` (`orders_id`,`orders_status_id`)
) ENGINE=MyISAM AUTO_INCREMENT=329 DEFAULT CHARSET=latin1;

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

INSERT INTO `orders_status_history` VALUES (1,1,2,'2005-11-11 07:02:59',1,''),(9,1,3,'2005-11-22 16:46:23',1,'We\'ve shipped your order, bitch.'),(10,8,2,'2005-11-23 07:58:49',1,''),(11,9,2,'2005-11-28 12:45:18',1,''),(12,10,2,'2005-11-28 15:07:51',1,''),(13,11,2,'2005-11-30 13:27:54',1,''),(14,12,2,'2005-12-02 06:08:22',1,''),(15,13,2,'2005-12-02 19:04:15',1,''),(16,14,2,'2005-12-04 11:51:34',1,''),(17,14,3,'2005-12-06 20:22:29',1,''),(18,8,3,'2005-12-06 20:23:19',1,''),(19,12,3,'2005-12-06 20:23:56',1,''),(20,10,3,'2005-12-06 20:24:10',1,''),(21,11,3,'2005-12-06 20:24:29',1,''),(22,9,3,'2005-12-06 20:25:10',1,''),(23,15,2,'2005-12-07 08:19:23',1,''),(24,15,2,'2005-12-07 21:58:28',1,'# 9101 0105 2129 7940 7332 37 \r\n\r\nUSPS.COM\r\n\r\nThanks,\r\n\r\ncustomer service \r\nmojo cosmetics'),(25,16,2,'2005-12-08 11:40:56',1,''),(26,17,2,'2005-12-19 18:17:44',1,'Janie, don\'t sent this. It\'s a test'),(27,18,2,'2005-12-22 05:00:53',1,'have 20% discount code -- \"returncustomer\"\r\n\r\nalso -- if you have any business cards from your company, can you enclose them (I collect them) -- I would appreciate it -- thanks'),(28,19,2,'2006-01-08 14:35:48',1,'May I have a sample of suede and mojo lipstick colors?'),(29,19,2,'2006-01-09 12:44:48',1,'Order No. 19 for Kerry Neysmith tracking # 9101 0105 2129 7939 7906 54\r\n\r\nusps.com'),(30,20,2,'2006-01-09 20:45:31',1,''),(31,21,2,'2006-01-09 21:48:09',1,''),(32,20,2,'2006-01-10 09:44:31',1,'Order No. 20 for Sherry Hicks, Tracking # 9101 0105 2129 7934 1796 52.  USPS.COM\r\n\r\nconviction bullet (paid)  mojo bullet (comped)\r\nThank you for your order.'),(33,21,2,'2006-01-10 09:47:09',1,'Order No. 21 for Alana Barfield, Tracking # 9101 0105 2129 7934 1788 84.  USPS.COM  \r\nThank you.'),(34,13,3,'2006-01-14 17:22:07',1,''),(35,21,3,'2006-01-14 17:22:39',1,''),(36,20,3,'2006-01-14 17:23:16',1,''),(37,19,3,'2006-01-14 17:23:35',1,''),(38,18,3,'2006-01-14 17:23:53',1,''),(39,16,3,'2006-01-14 17:24:44',1,''),(40,15,3,'2006-01-14 17:24:57',1,''),(41,22,2,'2006-01-18 09:37:29',1,'Please do not include the invoice of the items when shipping.'),(42,22,2,'2006-01-19 11:30:09',1,'We could not get in touch with you, nor did the credit card match the address.  We will wait for you to contact us before we ship.  This prevents fraud and protects us as we as the customer'),(43,23,2,'2006-01-22 23:42:44',1,''),(44,24,2,'2006-02-03 00:30:29',1,''),(45,24,4,'2006-02-04 08:29:27',1,'Hi Marina,\r\n\r\nOrder No. 24 for Marina Sheu Tracking # 9101 0105 2129 7399 7476 94  usps.com.\r\n\r\nThank you for ordering from our boutique.\r\nIf you think you\'d like to give these as a gift to a friend,etc or order yourself more, contact us for a discount.\r\n\r\nSincerely,\r\nThe shop'),(46,25,2,'2006-02-11 14:38:46',1,''),(47,26,2,'2006-02-17 16:14:41',1,''),(48,27,2,'2006-02-18 17:02:38',1,''),(49,28,2,'2006-02-20 09:39:41',1,''),(50,29,2,'2006-02-20 13:40:43',1,''),(51,30,2,'2006-02-20 13:43:21',1,''),(52,31,2,'2006-02-20 23:42:36',1,''),(53,32,2,'2006-02-21 19:10:02',1,''),(54,33,2,'2006-02-23 07:47:03',1,''),(55,34,2,'2006-02-23 14:04:54',1,''),(56,35,2,'2006-02-27 18:50:19',1,'thanks dolly doll, love you!!!'),(57,36,2,'2006-03-01 08:13:22',1,''),(58,37,2,'2006-03-01 14:55:37',1,''),(59,38,2,'2006-03-02 09:55:24',1,''),(60,39,2,'2006-03-04 11:11:51',1,''),(61,40,2,'2006-03-06 08:38:15',1,''),(62,41,2,'2006-03-07 11:21:33',1,'Ms. Ford,\r\n\r\n \r\n\r\nI am very sorry to hear you lost your cap. I wanted to contact you personally. Our components are made by complete sets. We actually have no mechanism set up to handle pieced out TITANs. This is the first time I’ve ever heard of this happening, as our threads have a friction lock at the end of the threading.\r\n\r\n \r\n\r\nI would however love you to continue using our products. Can I offer you a discount that we usually reserve for family and friends of our company? If you type in FOM20, you’ll save 20% on your entire order at our online boutique.\r\n\r\nPlease let me know if there is anything else I can do for you. BTW, were you happy with your purchase? We have really gone to great lengths to make sure our customers get a world-class product and I want to make sure we delivered based on your expectations.\r\n\r\nI look forward to hearing back from you.\r\n\r\n\r\n Jamion Blackwell, President\r\nmojo cosmetics\r\nwww.mojocosmetics.us\r\n\r\n\r\n \r\nIt won\'t take this code ....Sheldon'),(63,42,2,'2006-03-12 20:27:34',1,''),(64,43,2,'2006-03-16 07:20:45',1,'please do not include the invoice in the order.'),(65,44,2,'2006-03-28 21:20:54',1,''),(66,45,2,'2006-04-01 15:47:43',1,''),(67,46,2,'2006-04-09 18:49:03',1,''),(68,47,2,'2006-04-11 00:46:10',1,''),(69,48,2,'2006-04-12 04:07:19',1,'Pls send without the prices tag.\r\nthanks.'),(70,49,2,'2006-04-16 03:10:10',1,''),(71,50,2,'2006-04-21 09:45:59',1,''),(72,51,2,'2006-04-25 08:55:06',1,''),(73,52,2,'2006-04-28 20:39:54',1,''),(74,53,2,'2006-05-04 15:22:51',1,''),(75,54,2,'2006-05-04 17:01:12',1,''),(76,55,2,'2006-05-05 16:13:14',1,''),(77,56,2,'2006-05-17 14:14:42',1,''),(78,57,2,'2006-05-19 09:42:47',1,''),(79,58,2,'2006-05-28 00:19:12',1,''),(80,59,2,'2006-05-29 18:45:40',1,''),(81,60,2,'2006-06-11 18:44:08',1,''),(82,61,2,'2006-06-18 04:21:37',1,''),(83,62,2,'2006-07-10 01:02:09',1,''),(84,63,2,'2006-07-10 01:08:10',1,''),(85,64,2,'2006-07-27 10:40:59',1,''),(86,65,2,'2006-07-29 18:58:32',1,''),(87,66,2,'2006-07-29 19:46:47',1,''),(88,67,2,'2006-08-07 03:21:45',1,''),(89,68,2,'2006-08-07 15:36:42',1,''),(90,69,2,'2006-08-28 15:07:23',1,''),(91,70,2,'2006-08-29 14:35:46',1,''),(92,71,2,'2006-08-29 21:50:36',1,''),(93,72,2,'2006-09-10 07:12:37',1,''),(94,73,2,'2006-09-15 17:57:01',1,''),(95,74,2,'2006-10-01 09:38:45',1,''),(96,75,2,'2006-10-13 12:12:21',1,'I would really prefer to have an original bullet with the ribbed alloy if at all possible. Thank you!'),(97,76,2,'2006-10-17 12:55:19',1,''),(98,77,2,'2006-10-22 00:37:28',1,''),(99,77,2,'2006-10-22 00:37:28',0,'PayPal status: Completed  @ 23:57:11 Oct 21, 2006 PDT'),(100,78,2,'2006-10-26 01:41:18',1,''),(101,78,2,'2006-10-26 01:41:18',0,'PayPal status: Completed  @ 01:00:24 Oct 26, 2006 PDT'),(102,79,2,'2006-11-02 07:45:08',1,''),(103,80,2,'2006-11-02 11:04:27',1,'TIGHTLY SECURE BOTTOM AFTER ASSEMBLY'),(104,80,2,'2006-11-02 11:04:27',0,'PayPal status: Completed  @ 10:22:21 Nov 02, 2006 PST'),(105,81,2,'2006-11-03 08:52:44',1,''),(106,82,2,'2006-11-09 21:16:21',1,''),(107,83,2,'2006-11-09 23:21:46',1,''),(108,83,2,'2006-11-09 23:21:46',0,'PayPal status: Completed  @ 22:38:29 Nov 09, 2006 PST'),(109,84,2,'2006-11-10 07:07:12',1,''),(110,85,3,'2006-11-10 10:35:25',1,''),(111,86,3,'2006-11-26 18:12:48',1,''),(112,87,3,'2006-11-29 21:03:52',1,''),(113,88,3,'2006-11-30 09:21:47',1,''),(114,89,3,'2006-12-08 15:12:00',1,''),(115,90,3,'2006-12-11 08:08:25',1,''),(116,91,3,'2006-12-12 19:14:17',1,''),(117,92,3,'2006-12-12 22:56:34',1,'This will be given as a gift, but I kind of assume it already comes nicely packaged...thanks! My sister will be the tester receiving this, and perhaps myself + my mother will be the next purchases. Such an interesting product, I can\'t wait to see it in person.'),(118,93,3,'2006-12-14 07:53:44',1,''),(119,94,3,'2006-12-14 11:28:01',1,''),(120,95,3,'2006-12-26 12:25:28',1,''),(121,96,3,'2007-01-01 11:45:16',1,''),(122,97,3,'2007-01-10 21:26:52',1,''),(123,98,3,'2007-01-16 19:02:36',1,''),(124,99,3,'2007-01-23 16:26:12',1,''),(125,100,3,'2007-01-24 09:12:34',1,''),(126,101,3,'2007-01-29 19:34:22',1,''),(127,102,3,'2007-02-02 12:42:29',1,''),(128,23103,3,'2007-02-09 13:43:03',1,''),(129,23104,3,'2007-02-13 21:17:28',1,''),(130,23105,3,'2007-02-13 22:49:58',1,''),(131,23106,2,'2007-02-14 00:00:25',1,'VDAY'),(132,23106,2,'2007-02-14 00:00:25',0,'PayPal status: Completed  @ 23:08:36 Feb 13, 2007 PST'),(133,23107,3,'2007-02-14 15:27:59',1,''),(134,23108,3,'2007-02-14 17:40:13',1,''),(135,23109,2,'2007-02-27 09:34:25',1,''),(136,23109,2,'2007-02-27 09:34:25',0,'PayPal status: Completed  @ 08:44:13 Feb 27, 2007 PST'),(137,23110,2,'2007-02-28 16:12:11',1,''),(138,23110,1,'2007-02-28 16:12:11',0,'PayPal status: Pending echeck @ 15:21:55 Feb 28, 2007 PST'),(139,23111,3,'2007-03-09 09:27:22',1,'Thanks again for designing such a wonderful product. Stoked!\r\n- ag'),(140,23112,3,'2007-03-12 07:37:56',1,''),(141,23113,3,'2007-03-15 22:54:26',1,''),(142,23114,3,'2007-03-17 08:18:14',1,'I would also like to buy 3 more locking caps with this order. I did not see how to order them. Thanks, Kathy'),(143,23115,3,'2007-03-17 11:41:48',1,'this is a test'),(144,23116,2,'2007-03-17 21:29:51',1,''),(145,23116,2,'2007-03-17 21:29:51',0,'PayPal status: Completed  @ 21:39:46 Mar 17, 2007 PDT'),(146,23117,3,'2007-03-18 00:47:30',1,''),(147,23118,3,'2007-03-21 06:35:32',1,''),(148,23119,3,'2007-03-21 14:35:03',1,'What does \"Late Rate\" Mean? I would like this shipped overnight - to arrive on Thursday, March 22, 2007.'),(149,23120,3,'2007-03-27 12:47:58',1,'discount code stevie'),(150,23121,3,'2007-03-28 09:17:47',1,''),(151,23122,3,'2007-04-01 18:49:35',1,'sad to hear you are closing. I guess I better stock up.'),(152,23123,3,'2007-04-01 19:05:15',1,''),(153,23124,3,'2007-04-02 04:19:44',1,'Thanks and sorry to hear about you guys closing...'),(154,23125,2,'2007-04-02 08:07:38',1,''),(155,23125,2,'2007-04-02 08:07:38',0,'PayPal status: Completed  @ 07:15:08 Apr 02, 2007 PDT'),(156,23126,2,'2007-04-16 21:14:57',1,''),(157,23126,2,'2007-04-16 21:14:57',0,'PayPal status: Completed  @ 20:20:26 Apr 16, 2007 PDT'),(158,23127,2,'2007-04-18 13:55:28',1,''),(159,23127,2,'2007-04-18 13:55:28',0,'PayPal status: Completed  @ 13:00:39 Apr 18, 2007 PDT'),(160,23128,3,'2007-04-23 09:26:42',1,''),(161,23129,3,'2007-05-08 15:39:47',1,''),(162,23130,3,'2007-05-08 18:20:37',1,''),(163,23131,3,'2007-05-09 13:18:50',1,''),(164,23132,2,'2007-05-23 06:53:20',1,''),(165,23132,2,'2007-05-23 06:53:20',0,'PayPal status: Completed  @ 09:52:34 May 23, 2007 PDT'),(166,23133,3,'2007-05-23 14:11:01',1,''),(167,23134,3,'2007-06-11 11:47:14',1,''),(168,23135,3,'2007-06-21 16:08:07',1,''),(169,23136,3,'2007-07-03 18:20:37',1,''),(170,23137,2,'2007-07-04 01:57:27',1,''),(171,23137,2,'2007-07-04 01:57:27',0,'PayPal status: Completed  @ 23:57:20 Jul 03, 2007 PDT'),(172,23138,3,'2007-07-07 18:03:38',1,''),(173,23139,2,'2007-07-25 16:30:30',1,''),(174,23139,2,'2007-07-25 16:30:30',0,'PayPal status: Completed  @ 14:30:21 Jul 25, 2007 PDT'),(175,23140,2,'2007-07-27 22:30:29',1,''),(176,23140,2,'2007-07-27 22:30:29',0,'PayPal status: Completed  @ 20:30:21 Jul 27, 2007 PDT'),(177,23141,2,'2007-07-29 08:27:11',1,''),(178,23141,2,'2007-07-29 08:27:11',0,'PayPal status: Completed  @ 06:27:01 Jul 29, 2007 PDT'),(179,23142,2,'2007-08-01 17:36:18',1,'If you could mail the order without any price sheet or documentation, I would greatly appreciate it. If not possible, no worries; I\'m totally excited to use your products. Five years ago I sustained a spinal cord injury leaving extensive, permanent paralysis. I need products to be easy to use and VERY durable. Thanks so much for your innovative design!!www.myspace.com/shaunamariejensen'),(180,23142,2,'2007-08-01 17:36:18',0,'PayPal status: Completed  @ 15:36:06 Aug 01, 2007 PDT'),(181,23143,2,'2007-08-05 23:04:35',1,''),(182,23143,2,'2007-08-05 23:04:35',0,'PayPal status: Completed  @ 21:04:24 Aug 05, 2007 PDT'),(183,23144,2,'2007-08-07 10:38:28',1,'no signature required'),(184,23144,2,'2007-08-07 10:38:28',0,'PayPal status: Completed  @ 08:38:19 Aug 07, 2007 PDT'),(185,23145,2,'2007-08-07 20:38:23',1,''),(186,23145,2,'2007-08-07 20:38:23',0,'PayPal status: Completed  @ 18:38:01 Aug 07, 2007 PDT'),(187,23146,2,'2007-08-07 23:54:16',1,''),(188,23146,2,'2007-08-07 23:54:16',0,'PayPal status: Completed  @ 21:54:05 Aug 07, 2007 PDT'),(189,23147,2,'2007-08-08 13:39:21',1,''),(190,23147,2,'2007-08-08 13:39:21',0,'PayPal status: Completed  @ 11:39:14 Aug 08, 2007 PDT'),(191,23148,3,'2007-08-09 13:34:18',1,''),(192,23149,2,'2007-08-14 22:04:36',1,''),(193,23149,2,'2007-08-14 22:04:36',0,'PayPal status: Completed  @ 20:04:29 Aug 14, 2007 PDT'),(194,23150,2,'2007-08-15 22:27:33',1,''),(195,23150,2,'2007-08-15 22:27:33',0,'PayPal status: Completed  @ 20:27:06 Aug 15, 2007 PDT'),(196,23151,3,'2007-08-16 05:57:16',1,''),(197,23152,2,'2007-08-19 13:13:20',1,''),(198,23152,2,'2007-08-19 13:13:20',0,'PayPal status: Completed  @ 11:13:10 Aug 19, 2007 PDT'),(199,23153,2,'2007-08-31 14:00:24',1,''),(200,23153,2,'2007-08-31 14:00:24',0,'PayPal status: Completed  @ 12:00:18 Aug 31, 2007 PDT'),(201,23154,2,'2007-09-09 14:24:30',1,''),(202,23154,2,'2007-09-09 14:24:30',0,'PayPal status: Completed  @ 12:24:21 Sep 09, 2007 PDT'),(203,23155,2,'2007-09-12 11:58:51',1,''),(204,23155,2,'2007-09-12 11:58:51',0,'PayPal status: Completed  @ 09:58:39 Sep 12, 2007 PDT'),(205,23156,3,'2007-09-24 11:01:30',1,''),(206,23157,3,'2007-09-24 11:03:52',1,''),(207,23158,2,'2007-09-27 20:45:15',1,''),(208,23158,2,'2007-09-27 20:45:15',0,'PayPal status: Completed  @ 18:44:58 Sep 27, 2007 PDT'),(209,23159,3,'2007-10-01 19:42:52',1,''),(210,23160,2,'2007-10-06 12:43:36',1,''),(211,23160,2,'2007-10-06 12:43:36',0,'PayPal status: Completed  @ 10:43:22 Oct 06, 2007 PDT'),(212,23161,3,'2007-10-13 11:19:56',1,''),(213,23162,3,'2007-10-14 16:06:00',1,''),(214,23163,3,'2007-10-15 06:07:59',1,''),(215,23164,3,'2007-10-17 14:18:02',1,''),(216,23165,3,'2007-10-17 23:56:45',1,''),(217,23166,3,'2007-10-21 08:10:20',1,''),(218,23167,2,'2007-10-23 10:52:25',1,''),(219,23167,2,'2007-10-23 10:52:25',0,'PayPal status: Completed  @ 08:52:20 Oct 23, 2007 PDT'),(220,23168,2,'2007-10-25 13:55:38',1,''),(221,23168,2,'2007-10-25 13:55:38',0,'PayPal status: Completed  @ 11:55:27 Oct 25, 2007 PDT'),(222,23169,3,'2007-10-29 17:23:11',1,''),(223,23170,3,'2007-11-02 01:54:36',1,''),(224,23171,3,'2007-11-03 10:32:28',1,''),(225,23172,3,'2007-11-04 16:12:57',1,''),(226,23173,3,'2007-11-06 15:17:18',1,''),(227,23174,3,'2007-11-09 00:43:18',1,''),(228,23175,3,'2007-11-11 18:52:37',1,''),(229,23176,2,'2007-11-13 14:05:47',1,'I\'m completly in LOVE with your products! If it\'s possible to ship my order without any receipt or pricing documentation, that would be absolutey apprecation!! \r\n\r\nOne more small request... you included a chain with my last order that\'s become a staple in my wardrobe. Is it possible to send one more or least let me know when they will be available for sale?\r\n \r\nTHANK YOU THANK YOU!!\r\nShauna'),(230,23176,2,'2007-11-13 14:05:47',0,'PayPal status: Completed  @ 11:54:31 Nov 13, 2007 PST'),(231,23177,2,'2007-11-13 19:27:25',1,''),(232,23177,2,'2007-11-13 19:27:25',0,'PayPal status: Completed  @ 17:27:15 Nov 13, 2007 PST'),(233,23178,3,'2007-11-14 13:27:08',1,''),(234,23179,2,'2007-11-16 14:28:49',1,''),(235,23179,2,'2007-11-16 14:28:49',0,'PayPal status: Completed  @ 12:28:10 Nov 16, 2007 PST'),(236,23180,2,'2007-11-16 22:10:17',1,''),(237,23180,2,'2007-11-16 22:10:17',0,'PayPal status: Completed  @ 20:09:58 Nov 16, 2007 PST'),(238,23181,2,'2007-11-16 23:29:31',1,''),(239,23181,2,'2007-11-16 23:29:31',0,'PayPal status: Completed  @ 21:29:18 Nov 16, 2007 PST'),(240,23182,3,'2007-11-17 07:19:53',1,''),(241,23183,3,'2007-11-20 18:04:08',1,''),(242,23184,3,'2007-11-20 22:57:37',1,''),(243,23185,2,'2007-11-21 23:05:25',1,''),(244,23185,2,'2007-11-21 23:05:25',0,'PayPal status: Completed  @ 21:05:09 Nov 21, 2007 PST'),(245,23186,2,'2007-12-01 19:03:55',1,''),(246,23186,2,'2007-12-01 19:03:55',0,'PayPal status: Completed  @ 17:03:40 Dec 01, 2007 PST'),(247,23187,3,'2007-12-02 21:15:15',1,''),(248,23188,2,'2007-12-08 16:30:23',1,''),(249,23188,2,'2007-12-08 16:30:23',0,'PayPal status: Completed  @ 14:30:12 Dec 08, 2007 PST'),(250,23189,3,'2007-12-25 15:02:46',1,''),(251,23190,3,'2007-12-29 16:40:52',1,''),(252,23191,3,'2008-01-24 09:17:56',1,''),(253,23192,2,'2008-01-27 12:50:05',1,''),(254,23192,2,'2008-01-27 12:50:05',0,'PayPal status: Completed  @ 10:49:48 Jan 27, 2008 PST'),(255,23193,3,'2008-01-31 15:36:24',1,'wholesale01'),(256,23194,3,'2008-02-02 18:00:20',1,''),(257,23195,2,'2008-02-12 10:52:47',1,''),(258,23195,2,'2008-02-12 10:52:47',0,'PayPal status: Completed  @ 08:52:30 Feb 12, 2008 PST'),(259,23196,3,'2008-02-14 11:17:33',1,''),(260,23197,3,'2008-02-14 15:17:08',1,''),(261,23198,2,'2008-02-19 23:58:01',1,''),(262,23198,1,'2008-02-19 23:58:01',0,'PayPal status: Pending echeck @ 21:57:50 Feb 19, 2008 PST'),(263,23199,2,'2008-02-24 15:50:07',1,''),(264,23199,2,'2008-02-24 15:50:07',0,'PayPal status: Completed  @ 13:49:51 Feb 24, 2008 PST'),(265,23200,3,'2008-03-21 15:02:58',1,''),(266,23201,2,'2008-04-03 14:40:41',1,''),(267,23201,2,'2008-04-03 14:40:41',0,'PayPal status: Completed  @ 12:40:29 Apr 03, 2008 PDT'),(268,23202,3,'2008-04-10 12:23:25',1,''),(269,23203,2,'2008-04-14 23:32:06',1,''),(270,23203,2,'2008-04-14 23:32:06',0,'PayPal status: Completed  @ 21:31:53 Apr 14, 2008 PDT'),(271,23204,2,'2008-04-17 11:39:30',1,''),(272,23204,2,'2008-04-17 11:39:30',0,'PayPal status: Completed  @ 09:29:51 Apr 17, 2008 PDT'),(273,23205,2,'2008-04-21 16:38:04',1,''),(274,23205,2,'2008-04-21 16:38:05',0,'PayPal status: Completed  @ 14:37:56 Apr 21, 2008 PDT'),(275,23206,3,'2008-04-22 09:38:37',1,''),(276,23207,2,'2008-04-22 17:46:09',1,''),(277,23207,1,'2008-04-22 17:46:09',0,'PayPal status: Pending echeck @ 15:45:47 Apr 22, 2008 PDT'),(278,23208,3,'2008-04-23 09:51:04',1,''),(279,23209,2,'2008-04-23 10:34:14',1,'DO NOT SHIP, TEST!!'),(280,23210,2,'2008-04-24 11:59:31',1,''),(281,23210,2,'2008-04-24 11:59:31',0,'PayPal status: Completed  @ 09:59:23 Apr 24, 2008 PDT'),(282,23211,2,'2008-04-24 19:01:12',1,''),(283,23212,2,'2008-04-30 17:37:44',1,''),(284,23213,2,'2008-05-01 16:19:01',1,''),(285,23213,2,'2008-05-01 16:19:01',0,'PayPal status: Completed  @ 14:18:44 May 01, 2008 PDT'),(286,23214,2,'2008-05-02 12:53:48',1,''),(287,23215,2,'2008-05-07 15:33:27',1,''),(288,23216,2,'2008-05-11 18:39:07',1,''),(289,23217,2,'2008-05-12 19:20:22',1,'I got your product through Yellow Box Beauty in April and I love it. Do you have a discount code from them? If so please apply.\r\n\r\nThanks'),(290,23218,2,'2008-05-13 17:20:08',1,''),(291,23219,2,'2008-05-13 19:31:22',1,''),(292,23219,2,'2008-05-13 19:31:22',0,'PayPal status: Completed  @ 17:31:16 May 13, 2008 PDT'),(293,23220,2,'2008-05-14 17:55:19',1,''),(294,23221,2,'2008-05-15 00:32:44',1,'DISCOUNT CODE: mojo20'),(295,23222,2,'2008-05-15 19:53:32',1,''),(296,23223,2,'2008-06-03 09:33:25',1,'Dear Mr. Blackwell, I hope you received the previous letter I sent regards to the item coming undone again. I\'m hoping it was just a fluke for the second time and that the new one won\'t unscrew. I won\'t go without my mojo & must place another order...they are addictive & non fattening. \r\nBest Wishes,\r\nPS I gave a platinum unisex mojo to my neice for one of her graduation gifts.\r\nDiane\r\nhttp://www.dianesfineart.com'),(297,23224,2,'2008-06-12 00:22:34',1,''),(298,23224,1,'2008-06-12 00:22:34',0,'PayPal status: Pending echeck @ 22:22:15 Jun 11, 2008 PDT'),(299,23225,2,'2008-06-12 08:52:54',1,'Thank you James for the free chain! Great customer service.'),(300,23226,2,'2008-06-24 11:51:05',1,''),(301,23227,2,'2008-07-10 15:20:28',1,''),(302,23228,2,'2008-07-18 13:56:24',1,''),(303,23228,2,'2008-07-18 13:56:24',0,'PayPal status: Completed  @ 11:55:56 Jul 18, 2008 PDT'),(304,23229,2,'2008-07-28 12:19:39',1,''),(305,23230,2,'2008-08-13 14:31:44',1,''),(306,23230,2,'2008-08-13 14:31:44',0,'PayPal status: Completed  @ 12:31:33 Aug 13, 2008 PDT'),(307,23231,2,'2008-09-07 14:23:37',1,'if not at home , please leave at mgr. rental office'),(308,23231,2,'2008-09-07 14:23:37',0,'PayPal status: Completed  @ 12:23:30 Sep 07, 2008 PDT'),(309,23232,2,'2008-09-09 18:53:23',1,''),(310,23233,2,'2008-09-18 12:12:02',1,''),(311,23234,2,'2008-09-18 16:09:59',1,'Thank you for shipping international.'),(312,23234,2,'2008-09-18 16:09:59',0,'PayPal status: Completed  @ 14:09:38 Sep 18, 2008 PDT'),(313,23235,2,'2008-09-18 16:58:06',1,''),(314,23236,2,'2008-09-22 09:17:37',1,''),(315,23237,2,'2008-09-22 19:17:50',1,''),(316,23238,2,'2008-09-27 09:42:15',1,''),(317,23239,2,'2008-10-10 15:09:53',1,'Please do not use UPS as they charge extra duty on shipping. Mark as a gift if possible. Thank you!'),(318,23239,2,'2008-10-10 15:09:53',0,'PayPal status: Completed  @ 13:09:44 Oct 10, 2008 PDT'),(319,23240,2,'2008-10-16 14:25:04',1,''),(320,23241,2,'2008-11-08 09:48:37',1,'DO NOT SHIP...TESTING'),(321,23242,2,'2008-12-10 01:59:25',1,'I need this for Christmas so it would be great if I could receive this by Christmas. Thank you'),(322,23243,2,'2008-12-25 01:46:56',1,''),(323,23244,2,'2009-01-07 13:17:36',1,''),(324,23244,2,'2009-01-07 13:17:36',0,'PayPal status: Completed  @ 11:17:30 Jan 07, 2009 PST'),(325,23245,2,'2009-01-11 00:51:43',1,'delusion polish'),(326,23245,2,'2009-01-11 00:51:43',0,'PayPal status: Completed  @ 22:51:36 Jan 10, 2009 PST'),(327,23246,2,'2009-01-29 22:26:01',1,''),(328,23246,2,'2009-01-29 22:26:01',0,'PayPal status: Completed  @ 20:25:57 Jan 29, 2009 PST');

--
-- 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_ot_orders_id_zen` (`orders_id`)
) ENGINE=MyISAM AUTO_INCREMENT=874 DEFAULT CHARSET=latin1;

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

INSERT INTO `orders_total` VALUES (1,1,'Sub-Total:','$32.00','32.0000','ot_subtotal',100),(2,1,'Flat Rate (Best Way):','$5.00','5.0000','ot_shipping',200),(3,1,'Total:','$37.00','37.0000','ot_total',999),(27,9,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(26,8,'Total:','$88.00','88.0000','ot_total',999),(24,8,'Sub-Total:','$82.00','82.0000','ot_subtotal',100),(25,8,'Shipping &amp; Handling (Flat Rate):','$6.00','6.0000','ot_shipping',200),(28,9,'Shipping &amp; Handling (Flat Rate):','$6.00','6.0000','ot_shipping',200),(29,9,'CA TAX 8.25%:','$3.71','3.7125','ot_tax',300),(30,9,'Total:','$54.71','54.7100','ot_total',999),(31,10,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(32,10,'Shipping &amp; Handling (Flat Rate):','$6.00','6.0000','ot_shipping',200),(33,10,'CA TAX 8.25%:','$3.71','3.7125','ot_tax',300),(34,10,'Total:','$54.71','54.7100','ot_total',999),(35,11,'Sub-Total:','$110.00','110.0000','ot_subtotal',100),(36,11,'Shipping &amp; Handling (Flat Rate):','$6.00','6.0000','ot_shipping',200),(37,11,'Total:','$116.00','116.0000','ot_total',999),(38,12,'Sub-Total:','$122.00','122.0000','ot_subtotal',100),(39,12,'Shipping &amp; Handling (Flat Rate):','$6.00','6.0000','ot_shipping',200),(40,12,'Total:','$128.00','128.0000','ot_total',999),(41,13,'Sub-Total:','$55.00','55.0000','ot_subtotal',100),(42,13,'Shipping &amp; Handling (Flat Rate):','$6.00','6.0000','ot_shipping',200),(43,13,'Total:','$61.00','61.0000','ot_total',999),(44,14,'Sub-Total:','$55.00','55.0000','ot_subtotal',100),(45,14,'Shipping &amp; Handling (Flat Rate):','$6.00','6.0000','ot_shipping',200),(46,14,'Total:','$61.00','61.0000','ot_total',999),(47,15,'Sub-Total:','$72.00','72.0000','ot_subtotal',100),(48,15,'Shipping &amp; Handling (Flat Rate):','$6.00','6.0000','ot_shipping',200),(49,15,'Total:','$78.00','78.0000','ot_total',999),(50,16,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(51,16,'Shipping &amp; Handling (Flat Rate):','$6.00','6.0000','ot_shipping',200),(52,16,'Total:','$51.00','51.0000','ot_total',999),(53,17,'Sub-Total:','$40.00','40.0000','ot_subtotal',100),(54,17,'Shipping &amp; Handling (Flat Rate):','$6.00','6.0000','ot_shipping',200),(55,17,'Discount Coupons: returncustomer :','-$8.66','8.6600','ot_coupon',280),(56,17,'CA TAX 8.25%:','$2.64','2.6400','ot_tax',300),(57,17,'Total:','$39.98','39.9800','ot_total',999),(58,18,'Sub-Total:','$27.00','27.0000','ot_subtotal',100),(59,18,'Shipping &amp; Handling (Flat Rate):','$6.00','6.0000','ot_shipping',200),(60,18,'Discount Coupons: returncustomer :','-$5.40','5.4000','ot_coupon',280),(61,18,'Total:','$27.60','27.6000','ot_total',999),(62,19,'Sub-Total:','$73.00','73.0000','ot_subtotal',100),(63,19,'Shipping &amp; Handling (Flat Rate):','$6.00','6.0000','ot_shipping',200),(64,19,'Total:','$79.00','79.0000','ot_total',999),(65,20,'Sub-Total:','$18.00','18.0000','ot_subtotal',100),(66,20,'Shipping &amp; Handling (Flat Rate):','$6.00','6.0000','ot_shipping',200),(67,20,'CA TAX 8.25%:','$1.49','1.4850','ot_tax',300),(68,20,'Total:','$25.49','25.4900','ot_total',999),(69,21,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(70,21,'Shipping &amp; Handling (Flat Rate):','$6.00','6.0000','ot_shipping',200),(71,21,'Discount Coupons: FOM20 :','-$9.00','9.0000','ot_coupon',280),(72,21,'Total:','$42.00','42.0000','ot_total',999),(73,22,'Sub-Total:','$360.00','360.0000','ot_subtotal',100),(74,22,'Shipping &amp; Handling (Flat Rate):','$6.00','6.0000','ot_shipping',200),(75,22,'Total:','$366.00','366.0000','ot_total',999),(76,23,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(77,23,'Shipping &amp; Handling (Flat Rate):','$6.00','6.0000','ot_shipping',200),(78,23,'CA TAX 8.25%:','$3.71','3.7125','ot_tax',300),(79,23,'Total:','$54.71','54.7100','ot_total',999),(80,24,'Sub-Total:','$55.00','55.0000','ot_subtotal',100),(81,24,'Shipping &amp; Handling (Flat Rate):','$6.00','6.0000','ot_shipping',200),(82,24,'Discount Coupons: 20 :','-$11.91','11.9100','ot_coupon',280),(83,24,'CA TAX 8.25%:','$3.63','3.6298','ot_tax',300),(84,24,'Total:','$52.72','52.7223','ot_total',999),(85,25,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(86,25,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$7.55','7.5500','ot_shipping',200),(87,25,'Total:','$52.55','52.5500','ot_total',999),(88,26,'Sub-Total:','$63.00','63.0000','ot_subtotal',100),(89,26,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$9.00','9.0000','ot_shipping',200),(90,26,'Discount Coupons: returncustomer :','-$6.30','6.3000','ot_coupon',280),(91,26,'Total:','$65.70','65.7000','ot_total',999),(92,27,'Sub-Total:','$63.00','63.0000','ot_subtotal',100),(93,27,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$9.00','9.0000','ot_shipping',200),(94,27,'Total:','$72.00','72.0000','ot_total',999),(95,28,'Sub-Total:','$82.00','82.0000','ot_subtotal',100),(96,28,'United States Postal Service (1 x 3.00lbs) (Global Express Mail (EMS) (3 - 5 days)):','$33.75','33.7500','ot_shipping',200),(97,28,'Discount Coupons: 20 :','-$16.40','16.4000','ot_coupon',280),(98,28,'Total:','$99.35','99.3500','ot_total',999),(99,29,'Sub-Total:','$27.00','27.0000','ot_subtotal',100),(100,29,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$9.00','9.0000','ot_shipping',200),(101,29,'Discount Coupons: returncustomer :','-$2.70','2.7000','ot_coupon',280),(102,29,'Total:','$33.30','33.3000','ot_total',999),(103,30,'Sub-Total:','$82.00','82.0000','ot_subtotal',100),(104,30,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$8.25','8.2500','ot_shipping',200),(105,30,'Total:','$90.25','90.2500','ot_total',999),(106,31,'Sub-Total:','$100.00','100.0000','ot_subtotal',100),(107,31,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$9.00','9.0000','ot_shipping',200),(108,31,'Discount Coupons: returncustomer :','-$10.00','10.0000','ot_coupon',280),(109,31,'Total:','$99.00','99.0000','ot_total',999),(110,32,'Sub-Total:','$55.00','55.0000','ot_subtotal',100),(111,32,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$7.20','7.2000','ot_shipping',200),(112,32,'Total:','$62.20','62.2000','ot_total',999),(113,33,'Sub-Total:','$100.00','100.0000','ot_subtotal',100),(114,33,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$9.00','9.0000','ot_shipping',200),(115,33,'Total:','$109.00','109.0000','ot_total',999),(116,34,'Sub-Total:','$18.00','18.0000','ot_subtotal',100),(117,34,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$5.00','5.0000','ot_shipping',200),(118,34,'Discount Coupons: test :','-$19.49','19.4900','ot_coupon',280),(119,34,'CA TAX 8.25%:','$0.41','0.4100','ot_tax',300),(120,34,'Total:','$3.93','3.9250','ot_total',999),(121,35,'Sub-Total:','$18.00','18.0000','ot_subtotal',100),(122,35,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$9.00','9.0000','ot_shipping',200),(123,35,'Total:','$27.00','27.0000','ot_total',999),(124,36,'Sub-Total:','$68.00','68.0000','ot_subtotal',100),(125,36,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$7.55','7.5500','ot_shipping',200),(126,36,'Total:','$75.55','75.5500','ot_total',999),(127,37,'Sub-Total:','$32.00','32.0000','ot_subtotal',100),(128,37,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$7.55','7.5500','ot_shipping',200),(129,37,'Total:','$39.55','39.5500','ot_total',999),(130,38,'Sub-Total:','$100.00','100.0000','ot_subtotal',100),(131,38,'United States Postal Service (1 x 3.00lbs) (Global Priority Mail - Flat-rate Envelope (Large) (4 - 6 days)):','$9.50','9.5000','ot_shipping',200),(132,38,'Total:','$109.50','109.5000','ot_total',999),(133,39,'Sub-Total:','$55.00','55.0000','ot_subtotal',100),(134,39,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$8.25','8.2500','ot_shipping',200),(135,39,'Total:','$63.25','63.2500','ot_total',999),(136,40,'Sub-Total:','$47.00','47.0000','ot_subtotal',100),(137,40,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$7.55','7.5500','ot_shipping',200),(138,40,'Total:','$54.55','54.5500','ot_total',999),(139,41,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(140,41,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$8.25','8.2500','ot_shipping',200),(141,41,'Total:','$53.25','53.2500','ot_total',999),(142,42,'Sub-Total:','$63.00','63.0000','ot_subtotal',100),(143,42,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$5.00','5.0000','ot_shipping',200),(144,42,'CA TAX 8.25%:','$5.61','5.6075','ot_tax',300),(145,42,'Total:','$73.61','73.6100','ot_total',999),(146,43,'Sub-Total:','$167.00','167.0000','ot_subtotal',100),(147,43,'United States Postal Service (1 x 3.00lbs) (Global Express Mail (EMS) (3 - 5 days)):','$42.70','42.7000','ot_shipping',200),(148,43,'Total:','$209.70','209.7000','ot_total',999),(149,44,'Sub-Total:','$85.00','85.0000','ot_subtotal',100),(150,44,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$5.00','5.0000','ot_shipping',200),(151,44,'Discount Coupons: 20 :','-$18.40','18.4000','ot_coupon',280),(152,44,'CA TAX 8.25%:','$6.02','6.0201','ot_tax',300),(153,44,'Total:','$77.62','77.6176','ot_total',999),(154,45,'Sub-Total:','$55.00','55.0000','ot_subtotal',100),(155,45,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$5.00','5.0000','ot_shipping',200),(156,45,'CA TAX 8.25%:','$4.95','4.9475','ot_tax',300),(157,45,'Total:','$64.95','64.9500','ot_total',999),(158,46,'Sub-Total:','$20.00','20.0000','ot_subtotal',100),(159,46,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$6.40','6.4000','ot_shipping',200),(160,46,'CA TAX 8.25%:','$2.18','2.1800','ot_tax',300),(161,46,'Total:','$28.58','28.5800','ot_total',999),(162,47,'Sub-Total:','$20.00','20.0000','ot_subtotal',100),(163,47,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$6.40','6.4000','ot_shipping',200),(164,47,'CA TAX 8.25%:','$2.18','2.1800','ot_tax',300),(165,47,'Total:','$28.58','28.5800','ot_total',999),(166,48,'Sub-Total:','$700.00','700.0000','ot_subtotal',100),(167,48,'United States Postal Service (1 x 3.00lbs) (Global Express Mail (EMS) (3 - 5 days)):','$42.70','42.7000','ot_shipping',200),(168,48,'Total:','$742.70','742.7000','ot_total',999),(169,49,'Sub-Total:','$50.00','50.0000','ot_subtotal',100),(170,49,'United States Postal Service (Priority Mail (2 - 3 days)):','$5.00','5.0000','ot_shipping',200),(171,49,'CA TAX 8.25%:','$1.90','1.8950','ot_tax',300),(172,49,'Total:','$56.90','56.9000','ot_total',999),(173,50,'Sub-Total:','$55.00','55.0000','ot_subtotal',100),(174,50,'United States Postal Service (Priority Mail (2 - 3 days)):','$6.40','6.4000','ot_shipping',200),(175,50,'CA TAX 8.25%:','$5.07','5.0675','ot_tax',300),(176,50,'Total:','$66.47','66.4700','ot_total',999),(177,51,'Sub-Total:','$52.00','52.0000','ot_subtotal',100),(178,51,'United States Postal Service (Priority Mail (2 - 3 days)):','$7.55','7.5500','ot_shipping',200),(179,51,'Discount Coupons: returncustomer :','-$5.20','5.2000','ot_coupon',280),(180,51,'Total:','$54.35','54.3500','ot_total',999),(181,52,'Sub-Total:','$27.00','27.0000','ot_subtotal',100),(182,52,'United States Postal Service (Priority Mail (2 - 3 days)):','$9.00','9.0000','ot_shipping',200),(183,52,'Discount Coupons: returncustomer :','-$2.70','2.7000','ot_coupon',280),(184,52,'Total:','$33.30','33.3000','ot_total',999),(185,53,'Sub-Total:','$99.00','99.0000','ot_subtotal',100),(186,53,'United States Postal Service (Priority Mail (2 - 3 days)):','$9.00','9.0000','ot_shipping',200),(187,53,'Total:','$108.00','108.0000','ot_total',999),(188,54,'Sub-Total:','$63.00','63.0000','ot_subtotal',100),(189,54,'United States Postal Service (Priority Mail (2 - 3 days)):','$9.00','9.0000','ot_shipping',200),(190,54,'Total:','$72.00','72.0000','ot_total',999),(191,55,'Sub-Total:','$20.00','20.0000','ot_subtotal',100),(192,55,'United States Postal Service (Priority Mail (2 - 3 days)):','$6.40','6.4000','ot_shipping',200),(193,55,'CA TAX 8.25%:','$2.18','2.1800','ot_tax',300),(194,55,'Total:','$28.58','28.5800','ot_total',999),(195,56,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(196,56,'United States Postal Service (Priority Mail (2 - 3 days)):','$9.00','9.0000','ot_shipping',200),(197,56,'Total:','$54.00','54.0000','ot_total',999),(198,57,'Sub-Total:','$50.00','50.0000','ot_subtotal',100),(199,57,'United States Postal Service (Priority Mail (2 - 3 days)):','$9.00','9.0000','ot_shipping',200),(200,57,'Discount Coupons: 20 :','-$10.00','10.0000','ot_coupon',280),(201,57,'Total:','$49.00','49.0000','ot_total',999),(202,58,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(203,58,'United States Postal Service (Priority Mail (2 - 3 days)):','$6.40','6.4000','ot_shipping',200),(204,58,'CA TAX 8.25%:','$4.24','4.2425','ot_tax',300),(205,58,'Total:','$55.64','55.6400','ot_total',999),(206,59,'Sub-Total:','$55.00','55.0000','ot_subtotal',100),(207,59,'United States Postal Service (Priority Mail (2 - 3 days)):','$7.20','7.2000','ot_shipping',200),(208,59,'Total:','$62.20','62.2000','ot_total',999),(209,60,'Sub-Total:','$55.00','55.0000','ot_subtotal',100),(210,60,'United States Postal Service (Priority Mail (2 - 3 days)):','$5.00','5.0000','ot_shipping',200),(211,60,'CA TAX 8.25%:','$4.95','4.9475','ot_tax',300),(212,60,'Total:','$64.95','64.9500','ot_total',999),(213,61,'Sub-Total:','$110.00','110.0000','ot_subtotal',100),(214,61,'United States Postal Service (Priority Mail (2 - 3 days)):','$5.00','5.0000','ot_shipping',200),(215,61,'CA TAX 8.25%:','$9.49','9.4850','ot_tax',300),(216,61,'Total:','$124.48','124.4800','ot_total',999),(217,62,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(218,62,'United States Postal Service (Priority Mail (2 - 3 days)):','$5.00','5.0000','ot_shipping',200),(219,62,'CA TAX 8.25%:','$4.12','4.1225','ot_tax',300),(220,62,'Total:','$54.12','54.1200','ot_total',999),(221,63,'Sub-Total:','$18.00','18.0000','ot_subtotal',100),(222,63,'United States Postal Service (Priority Mail (2 - 3 days)):','$5.00','5.0000','ot_shipping',200),(223,63,'CA TAX 8.25%:','$1.90','1.8950','ot_tax',300),(224,63,'Total:','$24.90','24.9000','ot_total',999),(225,64,'Sub-Total:','$20.00','20.0000','ot_subtotal',100),(226,64,'United States Postal Service (Priority Mail (2 - 3 days)):','$5.00','5.0000','ot_shipping',200),(227,64,'Discount Coupons: 20 :','-$4.33','4.3300','ot_coupon',280),(228,64,'CA TAX 8.25%:','$1.73','1.7300','ot_tax',300),(229,64,'Total:','$22.40','22.4000','ot_total',999),(230,65,'Sub-Total:','$55.00','55.0000','ot_subtotal',100),(231,65,'United States Postal Service (Priority Mail (2 - 3 days)):','$8.25','8.2500','ot_shipping',200),(232,65,'Total:','$63.25','63.2500','ot_total',999),(233,66,'Sub-Total:','$90.00','90.0000','ot_subtotal',100),(234,66,'United States Postal Service (Priority Mail (2 - 3 days)):','$5.00','5.0000','ot_shipping',200),(235,66,'CA TAX 8.25%:','$7.84','7.8350','ot_tax',300),(236,66,'Total:','$102.83','102.8300','ot_total',999),(237,67,'Sub-Total:','$135.00','135.0000','ot_subtotal',100),(238,67,'Shipping &amp; Handling (Flat Rate):','$0.00','0.0000','ot_shipping',200),(239,67,'Total:','$135.00','135.0000','ot_total',999),(240,68,'Sub-Total:','$65.00','65.0000','ot_subtotal',100),(241,68,'Shipping &amp; Handling (Flat Rate):','$0.00','0.0000','ot_shipping',200),(242,68,'Total:','$65.00','65.0000','ot_total',999),(243,69,'Sub-Total:','$72.00','72.0000','ot_subtotal',100),(244,69,'Shipping &amp; Handling (Flat Rate):','$0.00','0.0000','ot_shipping',200),(245,69,'CA TAX 8.25%:','$5.94','5.9400','ot_tax',300),(246,69,'Total:','$77.94','77.9400','ot_total',999),(247,70,'Sub-Total:','$32.00','32.0000','ot_subtotal',100),(248,70,'Shipping &amp; Handling (Flat Rate):','$0.00','0.0000','ot_shipping',200),(249,70,'Total:','$32.00','32.0000','ot_total',999),(250,71,'Sub-Total:','$40.00','40.0000','ot_subtotal',100),(251,71,'Shipping &amp; Handling (Flat Rate):','$0.00','0.0000','ot_shipping',200),(252,71,'CA TAX 8.25%:','$3.30','3.3000','ot_tax',300),(253,71,'Total:','$43.30','43.3000','ot_total',999),(254,72,'Sub-Total:','$55.00','55.0000','ot_subtotal',100),(255,72,'Shipping &amp; Handling (Flat Rate):','$0.00','0.0000','ot_shipping',200),(256,72,'Total:','$55.00','55.0000','ot_total',999),(257,73,'Sub-Total:','$63.00','63.0000','ot_subtotal',100),(258,73,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$5.40','5.4000','ot_shipping',200),(259,73,'Discount Coupons: RB10 :','-$6.82','6.8200','ot_coupon',280),(260,73,'CA TAX 8.25%:','$4.68','4.6777','ot_tax',300),(261,73,'Total:','$66.26','66.2602','ot_total',999),(262,74,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(263,74,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$4.80','4.8000','ot_shipping',200),(264,74,'CA TAX 8.25%:','$3.71','3.7125','ot_tax',300),(265,74,'Total:','$53.51','53.5100','ot_total',999),(266,75,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(267,75,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$5.50','5.5000','ot_shipping',200),(268,75,'CA TAX 8.25%:','$3.71','3.7125','ot_tax',300),(269,75,'Total:','$54.21','54.2100','ot_total',999),(270,76,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(271,76,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$4.80','4.8000','ot_shipping',200),(272,76,'CA TAX 8.25%:','$3.71','3.7125','ot_tax',300),(273,76,'Total:','$53.51','53.5100','ot_total',999),(274,77,'Sub-Total:','$55.00','55.0000','ot_subtotal',100),(275,77,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$6.90','6.9000','ot_shipping',200),(276,77,'Discount Coupons: jaimarie :','-$0.60','0.6000','ot_coupon',280),(277,77,'CA TAX 8.25%:','$4.49','4.4917','ot_tax',300),(278,77,'Total:','$65.79','65.7942','ot_total',999),(279,78,'Sub-Total:','$27.00','27.0000','ot_subtotal',100),(280,78,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$5.50','5.5000','ot_shipping',200),(281,78,'Discount Coupons: myspacejaimarie :','-$4.38','4.3800','ot_coupon',280),(282,78,'CA TAX 8.25%:','$1.89','1.8937','ot_tax',300),(283,78,'Total:','$30.02','30.0162','ot_total',999),(284,79,'Sub-Total:','$55.00','55.0000','ot_subtotal',100),(285,79,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$7.16','7.1600','ot_shipping',200),(286,79,'CA TAX 8.25%:','$4.54','4.5375','ot_tax',300),(287,79,'Total:','$66.70','66.7000','ot_total',999),(288,80,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(289,80,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$7.16','7.1600','ot_shipping',200),(290,80,'Discount Coupons: mom :','-$7.16','7.1600','ot_coupon',280),(291,80,'CA TAX 8.25%:','$3.71','3.7125','ot_tax',300),(292,80,'Total:','$48.71','48.7100','ot_total',999),(293,81,'Sub-Total:','$63.00','63.0000','ot_subtotal',100),(294,81,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$6.52','6.5200','ot_shipping',200),(295,81,'CA TAX 8.25%:','$5.20','5.1975','ot_tax',300),(296,81,'Total:','$74.72','74.7200','ot_total',999),(297,82,'Sub-Total:','$55.00','55.0000','ot_subtotal',100),(298,82,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$6.52','6.5200','ot_shipping',200),(299,82,'CA TAX 8.25%:','$4.54','4.5375','ot_tax',300),(300,82,'Total:','$66.06','66.0600','ot_total',999),(301,83,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(302,83,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$8.05','8.0500','ot_shipping',200),(303,83,'CA TAX 8.25%:','$3.71','3.7125','ot_tax',300),(304,83,'Total:','$56.76','56.7600','ot_total',999),(305,84,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(306,84,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$8.05','8.0500','ot_shipping',200),(307,84,'CA TAX 8.25%:','$3.71','3.7125','ot_tax',300),(308,84,'Total:','$56.76','56.7600','ot_total',999),(309,85,'Sub-Total:','$55.00','55.0000','ot_subtotal',100),(310,85,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$7.16','7.1600','ot_shipping',200),(311,85,'CA TAX 8.25%:','$4.54','4.5375','ot_tax',300),(312,85,'Total:','$66.70','66.7000','ot_total',999),(313,86,'Sub-Total:','$55.00','55.0000','ot_subtotal',100),(314,86,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$8.05','8.0500','ot_shipping',200),(315,86,'Discount Coupons: jaimarie :','-$5.50','5.5000','ot_coupon',280),(316,86,'Total:','$57.55','57.5500','ot_total',999),(317,87,'Sub-Total:','$27.00','27.0000','ot_subtotal',100),(318,87,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$5.50','5.5000','ot_shipping',200),(319,87,'CA TAX 8.25%:','$2.23','2.2275','ot_tax',300),(320,87,'Total:','$34.73','34.7300','ot_total',999),(321,88,'Sub-Total:','$68.00','68.0000','ot_subtotal',100),(322,88,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$6.52','6.5200','ot_shipping',200),(323,88,'Total:','$74.52','74.5200','ot_total',999),(324,89,'Sub-Total:','$36.00','36.0000','ot_subtotal',100),(325,89,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$4.80','4.8000','ot_shipping',200),(326,89,'CA TAX 8.25%:','$2.97','2.9700','ot_tax',300),(327,89,'Total:','$43.78','43.7800','ot_total',999),(328,90,'Sub-Total:','$249.00','249.0000','ot_subtotal',100),(329,90,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$8.05','8.0500','ot_shipping',200),(330,90,'Total:','$257.05','257.0500','ot_total',999),(331,91,'Sub-Total:','$55.00','55.0000','ot_subtotal',100),(332,91,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$5.50','5.5000','ot_shipping',200),(333,91,'CA TAX 8.25%:','$4.54','4.5375','ot_tax',300),(334,91,'Total:','$65.04','65.0400','ot_total',999),(335,92,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(336,92,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$9.50','9.5000','ot_shipping',200),(337,92,'Total:','$54.50','54.5000','ot_total',999),(338,93,'Sub-Total:','$90.00','90.0000','ot_subtotal',100),(339,93,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$7.70','7.7000','ot_shipping',200),(340,93,'Total:','$97.70','97.7000','ot_total',999),(341,94,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(342,94,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$6.58','6.5800','ot_shipping',200),(343,94,'Total:','$51.58','51.5800','ot_total',999),(344,95,'Sub-Total:','$18.00','18.0000','ot_subtotal',100),(345,95,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$6.58','6.5800','ot_shipping',200),(346,95,'Total:','$24.58','24.5800','ot_total',999),(347,96,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(348,96,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$6.52','6.5200','ot_shipping',200),(349,96,'Total:','$51.52','51.5200','ot_total',999),(350,97,'Sub-Total:','$20.00','20.0000','ot_subtotal',100),(351,97,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$6.58','6.5800','ot_shipping',200),(352,97,'Total:','$26.58','26.5800','ot_total',999),(353,98,'Sub-Total:','$20.00','20.0000','ot_subtotal',100),(354,98,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$8.75','8.7500','ot_shipping',200),(355,98,'Discount Coupons: myspacejaimarie :','-$3.00','3.0000','ot_coupon',280),(356,98,'Total:','$25.75','25.7500','ot_total',999),(357,99,'Sub-Total:','$18.00','18.0000','ot_subtotal',100),(358,99,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$8.75','8.7500','ot_shipping',200),(359,99,'Discount Coupons: myspacejaimarie :','-$2.70','2.7000','ot_coupon',280),(360,99,'Total:','$24.05','24.0500','ot_total',999),(361,100,'Sub-Total:','$18.00','18.0000','ot_subtotal',100),(362,100,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$4.80','4.8000','ot_shipping',200),(363,100,'CA TAX 8.25%:','$1.49','1.4850','ot_tax',300),(364,100,'Total:','$24.29','24.2900','ot_total',999),(365,101,'Sub-Total:','$27.00','27.0000','ot_subtotal',100),(366,101,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$6.52','6.5200','ot_shipping',200),(367,101,'Total:','$33.52','33.5200','ot_total',999),(368,102,'Sub-Total:','$54.00','54.0000','ot_subtotal',100),(369,102,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$7.70','7.7000','ot_shipping',200),(370,102,'Total:','$61.70','61.7000','ot_total',999),(371,23103,'Sub-Total:','$32.00','32.0000','ot_subtotal',100),(372,23103,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$6.46','6.4600','ot_shipping',200),(373,23103,'Total:','$38.46','38.4600','ot_total',999),(374,23104,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(375,23104,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$7.16','7.1600','ot_shipping',200),(376,23104,'Discount Coupons: VDAY :','-$9.00','9.0000','ot_coupon',280),(377,23104,'Total:','$43.16','43.1600','ot_total',999),(378,23105,'Sub-Total:','$36.00','36.0000','ot_subtotal',100),(379,23105,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$6.90','6.9000','ot_shipping',200),(380,23105,'Discount Coupons: VDAY :','-$7.20','7.2000','ot_coupon',280),(381,23105,'Total:','$35.70','35.7000','ot_total',999),(382,23106,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(383,23106,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$7.16','7.1600','ot_shipping',200),(384,23106,'Total:','$52.16','52.1600','ot_total',999),(385,23107,'Sub-Total:','$18.00','18.0000','ot_subtotal',100),(386,23107,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$6.58','6.5800','ot_shipping',200),(387,23107,'Discount Coupons: VDAY :','-$3.60','3.6000','ot_coupon',280),(388,23107,'Total:','$20.98','20.9800','ot_total',999),(389,23108,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(390,23108,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$6.52','6.5200','ot_shipping',200),(391,23108,'Discount Coupons: VDAY :','-$9.00','9.0000','ot_coupon',280),(392,23108,'Total:','$42.52','42.5200','ot_total',999),(393,23109,'Sub-Total:','$82.00','82.0000','ot_subtotal',100),(394,23109,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$9.50','9.5000','ot_shipping',200),(395,23109,'Discount Coupons: myspacejaimarie :','-$12.30','12.3000','ot_coupon',280),(396,23109,'Total:','$79.20','79.2000','ot_total',999),(397,23110,'Sub-Total:','$99.00','99.0000','ot_subtotal',100),(398,23110,'Shipping &amp; Handling (Flat Rate):','$13.00','13.0000','ot_shipping',200),(399,23110,'Total:','$112.00','112.0000','ot_total',999),(400,23111,'Sub-Total:','$27.00','27.0000','ot_subtotal',100),(401,23111,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$7.16','7.1600','ot_shipping',200),(402,23111,'Total:','$34.16','34.1600','ot_total',999),(403,23112,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(404,23112,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$8.75','8.7500','ot_shipping',200),(405,23112,'Total:','$53.75','53.7500','ot_total',999),(406,23113,'Sub-Total:','$54.00','54.0000','ot_subtotal',100),(407,23113,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$6.58','6.5800','ot_shipping',200),(408,23113,'Discount Coupons: myspacejaimarie :','-$8.10','8.1000','ot_coupon',280),(409,23113,'Total:','$52.48','52.4800','ot_total',999),(410,23114,'Sub-Total:','$54.00','54.0000','ot_subtotal',100),(411,23114,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$6.52','6.5200','ot_shipping',200),(412,23114,'Total:','$60.52','60.5200','ot_total',999),(413,23115,'Sub-Total:','$18.00','18.0000','ot_subtotal',100),(414,23115,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$4.80','4.8000','ot_shipping',200),(415,23115,'Discount Coupons: mom :','-$4.80','4.8000','ot_coupon',280),(416,23115,'CA TAX 8.25%:','$1.49','1.4850','ot_tax',300),(417,23115,'Total:','$19.49','19.4900','ot_total',999),(418,23116,'Sub-Total:','$18.00','18.0000','ot_subtotal',100),(419,23116,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$8.05','8.0500','ot_shipping',200),(420,23116,'Total:','$26.05','26.0500','ot_total',999),(421,23117,'Sub-Total:','$118.00','118.0000','ot_subtotal',100),(422,23117,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$6.90','6.9000','ot_shipping',200),(423,23117,'CA TAX 8.25%:','$9.74','9.7350','ot_tax',300),(424,23117,'Total:','$134.64','134.6400','ot_total',999),(425,23118,'Sub-Total:','$63.00','63.0000','ot_subtotal',100),(426,23118,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$8.05','8.0500','ot_shipping',200),(427,23118,'Total:','$71.05','71.0500','ot_total',999),(428,23119,'Sub-Total:','$135.00','135.0000','ot_subtotal',100),(429,23119,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$8.75','8.7500','ot_shipping',200),(430,23119,'Total:','$143.75','143.7500','ot_total',999),(431,23120,'Sub-Total:','$83.00','83.0000','ot_subtotal',100),(432,23120,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$4.80','4.8000','ot_shipping',200),(433,23120,'Discount Coupons: Stevie :','-$44.93','44.9300','ot_coupon',280),(434,23120,'CA TAX 8.25%:','$3.42','3.4233','ot_tax',300),(435,23120,'Total:','$46.30','46.2958','ot_total',999),(436,23121,'Sub-Total:','$40.00','40.0000','ot_subtotal',100),(437,23121,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$9.50','9.5000','ot_shipping',200),(438,23121,'Total:','$49.50','49.5000','ot_total',999),(439,23122,'Sub-Total:','$108.00','108.0000','ot_subtotal',100),(440,23122,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$5.40','5.4000','ot_shipping',200),(441,23122,'CA TAX 8.25%:','$8.91','8.9100','ot_tax',300),(442,23122,'Total:','$122.32','122.3200','ot_total',999),(443,23123,'Sub-Total:','$27.00','27.0000','ot_subtotal',100),(444,23123,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$7.16','7.1600','ot_shipping',200),(445,23123,'Total:','$34.16','34.1600','ot_total',999),(446,23124,'Sub-Total:','$135.00','135.0000','ot_subtotal',100),(447,23124,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$9.50','9.5000','ot_shipping',200),(448,23124,'Total:','$144.50','144.5000','ot_total',999),(449,23125,'Sub-Total:','$122.00','122.0000','ot_subtotal',100),(450,23125,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$7.16','7.1600','ot_shipping',200),(451,23125,'Discount Coupons: myspacejaimarie :','-$18.30','18.3000','ot_coupon',280),(452,23125,'Total:','$110.86','110.8600','ot_total',999),(453,23126,'Sub-Total:','$27.00','27.0000','ot_subtotal',100),(454,23126,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$8.05','8.0500','ot_shipping',200),(455,23126,'Total:','$35.05','35.0500','ot_total',999),(456,23127,'Sub-Total:','$63.00','63.0000','ot_subtotal',100),(457,23127,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$6.35','6.3500','ot_shipping',200),(458,23127,'Total:','$69.35','69.3500','ot_total',999),(459,23128,'Sub-Total:','$85.00','85.0000','ot_subtotal',100),(460,23128,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$7.16','7.1600','ot_shipping',200),(461,23128,'Total:','$92.16','92.1600','ot_total',999),(462,23129,'Sub-Total:','$63.00','63.0000','ot_subtotal',100),(463,23129,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$6.58','6.5800','ot_shipping',200),(464,23129,'Total:','$69.58','69.5800','ot_total',999),(465,23130,'Sub-Total:','$18.00','18.0000','ot_subtotal',100),(466,23130,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$6.52','6.5200','ot_shipping',200),(467,23130,'Total:','$24.52','24.5200','ot_total',999),(468,23131,'Sub-Total:','$55.00','55.0000','ot_subtotal',100),(469,23131,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$6.35','6.3500','ot_shipping',200),(470,23131,'CA TAX 8.25%:','$4.54','4.5375','ot_tax',300),(471,23131,'Total:','$65.89','65.8900','ot_total',999),(472,23132,'Sub-Total:','$40.00','40.0000','ot_subtotal',100),(473,23132,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$11.05','11.0500','ot_shipping',200),(474,23132,'Total:','$51.05','51.0500','ot_total',999),(475,23133,'Sub-Total:','$27.00','27.0000','ot_subtotal',100),(476,23133,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$9.60','9.6000','ot_shipping',200),(477,23133,'Total:','$36.60','36.6000','ot_total',999),(478,23134,'Sub-Total:','$18.00','18.0000','ot_subtotal',100),(479,23134,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$4.65','4.6500','ot_shipping',200),(480,23134,'Discount Coupons: FRIEND :','-$3.90','3.9000','ot_coupon',280),(481,23134,'CA TAX 8.25%:','$1.19','1.1878','ot_tax',300),(482,23134,'Total:','$19.94','19.9428','ot_total',999),(483,23135,'Sub-Total:','$27.00','27.0000','ot_subtotal',100),(484,23135,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$5.55','5.5500','ot_shipping',200),(485,23135,'Discount Coupons: FRIEND :','-$5.85','5.8500','ot_coupon',280),(486,23135,'CA TAX 8.25%:','$1.78','1.7816','ot_tax',300),(487,23135,'Total:','$28.48','28.4841','ot_total',999),(488,23136,'Sub-Total:','$90.00','90.0000','ot_subtotal',100),(489,23136,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$6.90','6.9000','ot_shipping',200),(490,23136,'Total:','$96.90','96.9000','ot_total',999),(491,23137,'Sub-Total:','$40.00','40.0000','ot_subtotal',100),(492,23137,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$11.05','11.0500','ot_shipping',200),(493,23137,'Total:','$51.05','51.0500','ot_total',999),(494,23138,'Sub-Total:','$27.00','27.0000','ot_subtotal',100),(495,23138,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$5.55','5.5500','ot_shipping',200),(496,23138,'Discount Coupons: FRIEND :','-$5.85','5.8500','ot_coupon',280),(497,23138,'CA TAX 8.25%:','$1.78','1.7816','ot_tax',300),(498,23138,'Total:','$28.48','28.4841','ot_total',999),(499,23139,'Sub-Total:','$218.00','218.0000','ot_subtotal',100),(500,23139,'Shipping &amp; Handling (Flat Rate):','$13.00','13.0000','ot_shipping',200),(501,23139,'Total:','$231.00','231.0000','ot_total',999),(502,23140,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(503,23140,'Shipping &amp; Handling (Flat Rate):','$13.00','13.0000','ot_shipping',200),(504,23140,'Total:','$58.00','58.0000','ot_total',999),(505,23141,'Sub-Total:','$90.00','90.0000','ot_subtotal',100),(506,23141,'Shipping &amp; Handling (Flat Rate):','$13.00','13.0000','ot_shipping',200),(507,23141,'Total:','$103.00','103.0000','ot_total',999),(508,23142,'Sub-Total:','$137.00','137.0000','ot_subtotal',100),(509,23142,'Shipping &amp; Handling (Flat Rate):','$13.00','13.0000','ot_shipping',200),(510,23142,'Total:','$150.00','150.0000','ot_total',999),(511,23143,'Sub-Total:','$40.00','40.0000','ot_subtotal',100),(512,23143,'Shipping &amp; Handling (Flat Rate):','$13.00','13.0000','ot_shipping',200),(513,23143,'Total:','$53.00','53.0000','ot_total',999),(514,23144,'Sub-Total:','$90.00','90.0000','ot_subtotal',100),(515,23144,'Shipping &amp; Handling (Flat Rate):','$13.00','13.0000','ot_shipping',200),(516,23144,'Total:','$103.00','103.0000','ot_total',999),(517,23145,'Sub-Total:','$50.00','50.0000','ot_subtotal',100),(518,23145,'Shipping &amp; Handling (Flat Rate):','$13.00','13.0000','ot_shipping',200),(519,23145,'Total:','$63.00','63.0000','ot_total',999),(520,23146,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(521,23146,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$7.55','7.5500','ot_shipping',200),(522,23146,'Total:','$52.55','52.5500','ot_total',999),(523,23147,'Sub-Total:','$90.00','90.0000','ot_subtotal',100),(524,23147,'Shipping &amp; Handling (Flat Rate):','$13.00','13.0000','ot_shipping',200),(525,23147,'Total:','$103.00','103.0000','ot_total',999),(526,23148,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(527,23148,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$6.20','6.2000','ot_shipping',200),(528,23148,'Total:','$51.20','51.2000','ot_total',999),(529,23149,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(530,23149,'Shipping &amp; Handling (Flat Rate):','$13.00','13.0000','ot_shipping',200),(531,23149,'Total:','$58.00','58.0000','ot_total',999),(532,23150,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(533,23150,'Shipping &amp; Handling (Flat Rate):','$13.00','13.0000','ot_shipping',200),(534,23150,'Total:','$58.00','58.0000','ot_total',999),(535,23151,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(536,23151,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$11.05','11.0500','ot_shipping',200),(537,23151,'Total:','$56.05','56.0500','ot_total',999),(538,23152,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(539,23152,'Shipping &amp; Handling (Flat Rate):','$13.00','13.0000','ot_shipping',200),(540,23152,'Total:','$58.00','58.0000','ot_total',999),(541,23153,'Sub-Total:','$72.00','72.0000','ot_subtotal',100),(542,23153,'Shipping &amp; Handling (Flat Rate):','$13.00','13.0000','ot_shipping',200),(543,23153,'Total:','$85.00','85.0000','ot_total',999),(544,23154,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(545,23154,'Shipping &amp; Handling (Flat Rate):','$13.00','13.0000','ot_shipping',200),(546,23154,'Total:','$58.00','58.0000','ot_total',999),(547,23155,'Sub-Total:','$85.00','85.0000','ot_subtotal',100),(548,23155,'Shipping &amp; Handling (Flat Rate):','$13.00','13.0000','ot_shipping',200),(549,23155,'Discount Coupons: myspacejaimarie :','-$12.75','12.7500','ot_coupon',280),(550,23155,'Total:','$85.25','85.2500','ot_total',999),(551,23156,'Sub-Total:','$55.00','55.0000','ot_subtotal',100),(552,23156,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$6.80','6.8000','ot_shipping',200),(553,23156,'CA TAX 8.25%:','$4.54','4.5375','ot_tax',300),(554,23156,'Total:','$66.34','66.3400','ot_total',999),(555,23157,'Sub-Total:','$55.00','55.0000','ot_subtotal',100),(556,23157,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$6.80','6.8000','ot_shipping',200),(557,23157,'CA TAX 8.25%:','$4.54','4.5375','ot_tax',300),(558,23157,'Total:','$66.34','66.3400','ot_total',999),(559,23158,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(560,23158,'Shipping &amp; Handling (Flat Rate):','$13.00','13.0000','ot_shipping',200),(561,23158,'Total:','$58.00','58.0000','ot_total',999),(562,23159,'Sub-Total:','$32.00','32.0000','ot_subtotal',100),(563,23159,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$8.75','8.7500','ot_shipping',200),(564,23159,'Total:','$40.75','40.7500','ot_total',999),(565,23160,'Sub-Total:','$72.00','72.0000','ot_subtotal',100),(566,23160,'Shipping &amp; Handling (Flat Rate):','$13.00','13.0000','ot_shipping',200),(567,23160,'Total:','$85.00','85.0000','ot_total',999),(568,23161,'Sub-Total:','$36.00','36.0000','ot_subtotal',100),(569,23161,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$8.43','8.4300','ot_shipping',200),(570,23161,'Total:','$44.43','44.4300','ot_total',999),(571,23162,'Sub-Total:','$12.00','12.0000','ot_subtotal',100),(572,23162,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$4.65','4.6500','ot_shipping',200),(573,23162,'Discount Coupons: t3st :','-$4.65','4.6500','ot_coupon',280),(574,23162,'CA TAX 8.25%:','$0.99','0.9900','ot_tax',300),(575,23162,'Total:','$12.99','12.9900','ot_total',999),(576,23163,'Sub-Total:','$30.00','30.0000','ot_subtotal',100),(577,23163,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$7.55','7.5500','ot_shipping',200),(578,23163,'Total:','$37.55','37.5500','ot_total',999),(579,23164,'Sub-Total:','$25.00','25.0000','ot_subtotal',100),(580,23164,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$7.55','7.5500','ot_shipping',200),(581,23164,'Total:','$32.55','32.5500','ot_total',999),(582,23165,'Sub-Total:','$42.00','42.0000','ot_subtotal',100),(583,23165,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$5.46','5.4600','ot_shipping',200),(584,23165,'CA TAX 8.25%:','$3.47','3.4650','ot_tax',300),(585,23165,'Total:','$50.93','50.9300','ot_total',999),(586,23166,'Sub-Total:','$70.00','70.0000','ot_subtotal',100),(587,23166,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$7.55','7.5500','ot_shipping',200),(588,23166,'Total:','$77.55','77.5500','ot_total',999),(589,23167,'Sub-Total:','$30.00','30.0000','ot_subtotal',100),(590,23167,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$9.60','9.6000','ot_shipping',200),(591,23167,'Total:','$39.60','39.6000','ot_total',999),(592,23168,'Sub-Total:','$40.00','40.0000','ot_subtotal',100),(593,23168,'Shipping &amp; Handling (Flat Rate):','$13.00','13.0000','ot_shipping',200),(594,23168,'Total:','$53.00','53.0000','ot_total',999),(595,23169,'Sub-Total:','$15.00','15.0000','ot_subtotal',100),(596,23169,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$5.46','5.4600','ot_shipping',200),(597,23169,'Discount Coupons: FRIEND :','-$3.25','3.2500','ot_coupon',280),(598,23169,'CA TAX 8.25%:','$0.99','0.9898','ot_tax',300),(599,23169,'Total:','$18.20','18.2023','ot_total',999),(600,23170,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(601,23170,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$6.20','6.2000','ot_shipping',200),(602,23170,'Total:','$51.20','51.2000','ot_total',999),(603,23171,'Sub-Total:','$25.00','25.0000','ot_subtotal',100),(604,23171,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$8.43','8.4300','ot_shipping',200),(605,23171,'Total:','$33.43','33.4300','ot_total',999),(606,23172,'Sub-Total:','$25.00','25.0000','ot_subtotal',100),(607,23172,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$8.43','8.4300','ot_shipping',200),(608,23172,'Total:','$33.43','33.4300','ot_total',999),(609,23173,'Sub-Total:','$40.00','40.0000','ot_subtotal',100),(610,23173,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$5.46','5.4600','ot_shipping',200),(611,23173,'CA TAX 8.25%:','$3.30','3.3000','ot_tax',300),(612,23173,'Total:','$48.76','48.7600','ot_total',999),(613,23174,'Sub-Total:','$12.00','12.0000','ot_subtotal',100),(614,23174,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$5.46','5.4600','ot_shipping',200),(615,23174,'CA TAX 8.25%:','$0.99','0.9900','ot_tax',300),(616,23174,'Total:','$18.45','18.4500','ot_total',999),(617,23175,'Sub-Total:','$42.00','42.0000','ot_subtotal',100),(618,23175,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$6.80','6.8000','ot_shipping',200),(619,23175,'CA TAX 8.25%:','$3.47','3.4650','ot_tax',300),(620,23175,'Total:','$52.27','52.2700','ot_total',999),(621,23176,'Sub-Total:','$105.00','105.0000','ot_subtotal',100),(622,23176,'Shipping &amp; Handling (Flat Rate):','$15.30','15.3000','ot_shipping',200),(623,23176,'Total:','$120.30','120.3000','ot_total',999),(624,23177,'Sub-Total:','$95.00','95.0000','ot_subtotal',100),(625,23177,'Shipping &amp; Handling (Flat Rate):','$15.30','15.3000','ot_shipping',200),(626,23177,'Discount Coupons: 6061 :','-$9.50','9.5000','ot_coupon',280),(627,23177,'Total:','$100.80','100.8000','ot_total',999),(628,23178,'Sub-Total:','$30.00','30.0000','ot_subtotal',100),(629,23178,'United States Postal Service (1 x 3.00lbs) (Priority Mail (2 - 3 days)):','$11.05','11.0500','ot_shipping',200),(630,23178,'Total:','$41.05','41.0500','ot_total',999),(631,23179,'Sub-Total:','$107.00','107.0000','ot_subtotal',100),(632,23179,'Shipping &amp; Handling (Flat Rate):','$15.30','15.3000','ot_shipping',200),(633,23179,'Total:','$122.30','122.3000','ot_total',999),(634,23180,'Sub-Total:','$50.00','50.0000','ot_subtotal',100),(635,23180,'Shipping &amp; Handling (Flat Rate):','$15.30','15.3000','ot_shipping',200),(636,23180,'Total:','$65.30','65.3000','ot_total',999),(637,23181,'Sub-Total:','$30.00','30.0000','ot_subtotal',100),(638,23181,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$5.46','5.4600','ot_shipping',200),(639,23181,'CA TAX 8.25%:','$2.48','2.4750','ot_tax',300),(640,23181,'Total:','$37.94','37.9400','ot_total',999),(641,23182,'Sub-Total:','$42.00','42.0000','ot_subtotal',100),(642,23182,'United States Postal Service (1 x 3.00lbs) (Parcel Post (4 - 7 days)):','$7.83','7.8300','ot_shipping',200),(643,23182,'Total:','$49.83','49.8300','ot_total',999),(644,23183,'Sub-Total:','$87.00','87.0000','ot_subtotal',100),(645,23183,'United States Postal Service (1 x 3.00lbs) (PRIORITY):','$8.75','8.7500','ot_shipping',200),(646,23183,'Total:','$95.75','95.7500','ot_total',999),(647,23184,'Sub-Total:','$15.00','15.0000','ot_subtotal',100),(648,23184,'United States Postal Service (1 x 3.00lbs) (PRIORITY):','$6.90','6.9000','ot_shipping',200),(649,23184,'CA TAX 8.25%:','$1.24','1.2375','ot_tax',300),(650,23184,'Total:','$23.14','23.1400','ot_total',999),(651,23185,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(652,23185,'United States Postal Service (1 x 3.00lbs) (PRIORITY):','$5.55','5.5500','ot_shipping',200),(653,23185,'CA TAX 8.25%:','$3.71','3.7125','ot_tax',300),(654,23185,'Total:','$54.27','54.2700','ot_total',999),(655,23186,'Sub-Total:','$12.00','12.0000','ot_subtotal',100),(656,23186,'United States Postal Service (1 x 3.00lbs) (PRIORITY):','$10.15','10.1500','ot_shipping',200),(657,23186,'Total:','$22.15','22.1500','ot_total',999),(658,23187,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(659,23187,'United States Postal Service (1 x 3.00lbs) (PRIORITY):','$9.60','9.6000','ot_shipping',200),(660,23187,'Total:','$54.60','54.6000','ot_total',999),(661,23188,'Sub-Total:','$12.00','12.0000','ot_subtotal',100),(662,23188,'United States Postal Service (1 x 3.00lbs) (PRIORITY):','$9.60','9.6000','ot_shipping',200),(663,23188,'Total:','$21.60','21.6000','ot_total',999),(664,23189,'Sub-Total:','$25.00','25.0000','ot_subtotal',100),(665,23189,'United States Postal Service (1 x 3.00lbs) (PRIORITY):','$11.05','11.0500','ot_shipping',200),(666,23189,'Total:','$36.05','36.0500','ot_total',999),(667,23190,'Sub-Total:','$20.00','20.0000','ot_subtotal',100),(668,23190,'United States Postal Service (1 x 3.00lbs) (PRIORITY):','$11.05','11.0500','ot_shipping',200),(669,23190,'Total:','$31.05','31.0500','ot_total',999),(670,23191,'Sub-Total:','$12.00','12.0000','ot_subtotal',100),(671,23191,'United States Postal Service (1 x 3.00lbs) (PRIORITY):','$5.55','5.5500','ot_shipping',200),(672,23191,'CA TAX 8.25%:','$0.99','0.9900','ot_tax',300),(673,23191,'Total:','$18.54','18.5400','ot_total',999),(674,23192,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(675,23192,'Shipping &amp; Handling (Flat Rate):','$15.30','15.3000','ot_shipping',200),(676,23192,'Total:','$60.30','60.3000','ot_total',999),(677,23193,'Sub-Total:','$42.00','42.0000','ot_subtotal',100),(678,23193,'United States Postal Service (1 x 3.00lbs) (PRIORITY):','$5.55','5.5500','ot_shipping',200),(679,23193,'Discount Coupons: wholesale01 :','-$22.74','22.7400','ot_coupon',280),(680,23193,'CA TAX 8.25%:','$1.73','1.7321','ot_tax',300),(681,23193,'Total:','$26.55','26.5471','ot_total',999),(682,23194,'Sub-Total:','$130.00','130.0000','ot_subtotal',100),(683,23194,'United States Postal Service (1 x 3.00lbs) (PRIORITY):','$6.20','6.2000','ot_shipping',200),(684,23194,'CA TAX 8.25%:','$10.73','10.7250','ot_tax',300),(685,23194,'Total:','$146.92','146.9200','ot_total',999),(686,23195,'Sub-Total:','$95.00','95.0000','ot_subtotal',100),(687,23195,'Shipping &amp; Handling (Flat Rate):','$15.30','15.3000','ot_shipping',200),(688,23195,'Total:','$110.30','110.3000','ot_total',999),(689,23196,'Sub-Total:','$80.00','80.0000','ot_subtotal',100),(690,23196,'United States Postal Service (1 x 3.00lbs) (PRIORITY):','$11.05','11.0500','ot_shipping',200),(691,23196,'Total:','$91.05','91.0500','ot_total',999),(692,23197,'Sub-Total:','$15.00','15.0000','ot_subtotal',100),(693,23197,'United States Postal Service (1 x 3.00lbs) (PRIORITY):','$5.55','5.5500','ot_shipping',200),(694,23197,'Discount Coupons: FRIEND :','-$3.25','3.2500','ot_coupon',280),(695,23197,'CA TAX 8.25%:','$0.99','0.9898','ot_tax',300),(696,23197,'Total:','$18.29','18.2923','ot_total',999),(697,23198,'Sub-Total:','$42.00','42.0000','ot_subtotal',100),(698,23198,'United States Postal Service (1 x 3.00lbs) (PRIORITY):','$10.15','10.1500','ot_shipping',200),(699,23198,'Total:','$52.15','52.1500','ot_total',999),(700,23199,'Sub-Total:','$75.00','75.0000','ot_subtotal',100),(701,23199,'United States Postal Service (1 x 3.00lbs) (PRIORITY):','$5.55','5.5500','ot_shipping',200),(702,23199,'CA TAX 8.25%:','$6.19','6.1875','ot_tax',300),(703,23199,'Total:','$86.74','86.7400','ot_total',999),(704,23200,'Sub-Total:','$50.00','50.0000','ot_subtotal',100),(705,23200,'United States Postal Service (1 x 3.00lbs) (PRIORITY):','$8.75','8.7500','ot_shipping',200),(706,23200,'Discount Coupons: wholesale01 :','-$25.00','25.0000','ot_coupon',280),(707,23200,'Total:','$33.75','33.7500','ot_total',999),(708,23201,'Sub-Total:','$30.00','30.0000','ot_subtotal',100),(709,23201,'United States Postal Service (1 x 3.00lbs) (PRIORITY):','$10.15','10.1500','ot_shipping',200),(710,23201,'Total:','$40.15','40.1500','ot_total',999),(711,23202,'Sub-Total:','$99.00','99.0000','ot_subtotal',100),(712,23202,'United States Postal Service (1 x 3.00lbs) (PRIORITY):','$5.55','5.5500','ot_shipping',200),(713,23202,'CA TAX 8.25%:','$8.17','8.1675','ot_tax',300),(714,23202,'Total:','$112.73','112.7300','ot_total',999),(715,23203,'Sub-Total:','$50.00','50.0000','ot_subtotal',100),(716,23203,'United States Postal Service (1 x 3.00lbs) (PRIORITY):','$11.05','11.0500','ot_shipping',200),(717,23203,'Discount Coupons: mojo20 :','-$10.00','10.0000','ot_coupon',280),(718,23203,'Total:','$51.05','51.0500','ot_total',999),(719,23204,'Sub-Total:','$42.00','42.0000','ot_subtotal',100),(720,23204,'United States Postal Service (1 x 3.00lbs) (PRIORITY):','$9.60','9.6000','ot_shipping',200),(721,23204,'Discount Coupons: mojo20 :','-$8.40','8.4000','ot_coupon',280),(722,23204,'Total:','$43.20','43.2000','ot_total',999),(723,23205,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(724,23205,'United States Postal Service (1 x 3.00lbs) (PRIORITY):','$11.05','11.0500','ot_shipping',200),(725,23205,'Discount Coupons: mojo20 :','-$9.00','9.0000','ot_coupon',280),(726,23205,'Total:','$47.05','47.0500','ot_total',999),(727,23206,'Sub-Total:','$12.00','12.0000','ot_subtotal',100),(728,23206,'United States Postal Service (1 x 3.00lbs) (PRIORITY):','$10.15','10.1500','ot_shipping',200),(729,23206,'Total:','$22.15','22.1500','ot_total',999),(730,23207,'Sub-Total:','$42.00','42.0000','ot_subtotal',100),(731,23207,'United States Postal Service (1 x 3.00lbs) (PRIORITY):','$10.15','10.1500','ot_shipping',200),(732,23207,'Total:','$52.15','52.1500','ot_total',999),(733,23208,'Sub-Total:','$15.00','15.0000','ot_subtotal',100),(734,23208,'United States Postal Service (1 x 3.00lbs) (PRIORITY):','$11.05','11.0500','ot_shipping',200),(735,23208,'Discount Coupons: mojo20 :','-$3.00','3.0000','ot_coupon',280),(736,23208,'Total:','$23.05','23.0500','ot_total',999),(737,23209,'Sub-Total:','$12.00','12.0000','ot_subtotal',100),(738,23209,'United States Postal Service (1 x 3.00lbs) (PARCEL):','$4.65','4.6500','ot_shipping',200),(739,23209,'Discount Coupons: wholesale01 :','-$6.50','6.5000','ot_coupon',280),(740,23209,'CA TAX 8.25%:','$0.49','0.4946','ot_tax',300),(741,23209,'Total:','$10.64','10.6446','ot_total',999),(742,23210,'Sub-Total:','$35.00','35.0000','ot_subtotal',100),(743,23210,'United States Postal Service (1 x 3.00lbs) (PARCEL):','$8.43','8.4300','ot_shipping',200),(744,23210,'Total:','$43.43','43.4300','ot_total',999),(745,23211,'Sub-Total:','$42.00','42.0000','ot_subtotal',100),(746,23211,'United States Postal Service (1 x 3.00lbs) (PARCEL):','$8.43','8.4300','ot_shipping',200),(747,23211,'Total:','$50.43','50.4300','ot_total',999),(748,23212,'Sub-Total:','$37.00','37.0000','ot_subtotal',100),(749,23212,'United States Postal Service (1 x 3.00lbs) (PARCEL):','$6.80','6.8000','ot_shipping',200),(750,23212,'Total:','$43.80','43.8000','ot_total',999),(751,23213,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(752,23213,'Per Item (Best Way):','$18.30','18.3000','ot_shipping',200),(753,23213,'Total:','$63.30','63.3000','ot_total',999),(754,23214,'Sub-Total:','$42.00','42.0000','ot_subtotal',100),(755,23214,'United States Postal Service (1 x 3.00lbs) (PARCEL):','$8.43','8.4300','ot_shipping',200),(756,23214,'Total:','$50.43','50.4300','ot_total',999),(757,23215,'Sub-Total:','$84.00','84.0000','ot_subtotal',100),(758,23215,'United States Postal Service (1 x 3.00lbs) (PARCEL):','$5.46','5.4600','ot_shipping',200),(759,23215,'CA TAX 8.25%:','$6.93','6.9300','ot_tax',300),(760,23215,'Total:','$96.39','96.3900','ot_total',999),(761,23216,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(762,23216,'United States Postal Service (1 x 3.00lbs) (PARCEL):','$5.46','5.4600','ot_shipping',200),(763,23216,'CA TAX 8.25%:','$3.71','3.7125','ot_tax',300),(764,23216,'Total:','$54.17','54.1700','ot_total',999),(765,23217,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(766,23217,'United States Postal Service (1 x 3.00lbs) (PARCEL):','$8.62','8.6200','ot_shipping',200),(767,23217,'Total:','$53.62','53.6200','ot_total',999),(768,23218,'Sub-Total:','$15.00','15.0000','ot_subtotal',100),(769,23218,'United States Postal Service (1 x 3.00lbs) (PARCEL):','$8.62','8.6200','ot_shipping',200),(770,23218,'Discount Coupons: mojo20 :','-$3.00','3.0000','ot_coupon',280),(771,23218,'Total:','$20.62','20.6200','ot_total',999),(772,23219,'Sub-Total:','$92.00','92.0000','ot_subtotal',100),(773,23219,'United States Postal Service (1 x 3.00lbs) (PARCEL):','$5.50','5.5000','ot_shipping',200),(774,23219,'Discount Coupons: mojo20 :','-$19.92','19.9200','ot_coupon',280),(775,23219,'CA TAX 8.25%:','$6.07','6.0718','ot_tax',300),(776,23219,'Total:','$83.65','83.6518','ot_total',999),(777,23220,'Sub-Total:','$55.00','55.0000','ot_subtotal',100),(778,23220,'United States Postal Service (1 x 3.00lbs) (PARCEL):','$5.50','5.5000','ot_shipping',200),(779,23220,'Discount Coupons: mojo20 :','-$11.91','11.9100','ot_coupon',280),(780,23220,'CA TAX 8.25%:','$3.63','3.6298','ot_tax',300),(781,23220,'Total:','$52.22','52.2223','ot_total',999),(782,23221,'Sub-Total:','$37.00','37.0000','ot_subtotal',100),(783,23221,'United States Postal Service (1 x 3.00lbs) (PARCEL):','$6.20','6.2000','ot_shipping',200),(784,23221,'Discount Coupons: mojo20 :','-$8.01','8.0100','ot_coupon',280),(785,23221,'CA TAX 8.25%:','$2.44','2.4420','ot_tax',300),(786,23221,'Total:','$37.63','37.6295','ot_total',999),(787,23222,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(788,23222,'United States Postal Service (1 x 3.00lbs) (PARCEL):','$5.50','5.5000','ot_shipping',200),(789,23222,'Discount Coupons: mojo20 :','-$9.74','9.7400','ot_coupon',280),(790,23222,'CA TAX 8.25%:','$2.97','2.9701','ot_tax',300),(791,23222,'Total:','$43.73','43.7276','ot_total',999),(792,23223,'Sub-Total:','$42.00','42.0000','ot_subtotal',100),(793,23223,'United States Postal Service (1 x 3.00lbs) (PARCEL):','$8.02','8.0200','ot_shipping',200),(794,23223,'Discount Coupons: mojo20 :','-$8.40','8.4000','ot_coupon',280),(795,23223,'Total:','$41.62','41.6200','ot_total',999),(796,23224,'Sub-Total:','$42.00','42.0000','ot_subtotal',100),(797,23224,'United States Postal Service (1 x 3.00lbs) (PARCEL):','$7.10','7.1000','ot_shipping',200),(798,23224,'CA TAX 8.25%:','$3.47','3.4650','ot_tax',300),(799,23224,'Total:','$52.57','52.5700','ot_total',999),(800,23225,'Sub-Total:','$35.00','35.0000','ot_subtotal',100),(801,23225,'United States Postal Service (1 x 3.00lbs) (PARCEL):','$8.62','8.6200','ot_shipping',200),(802,23225,'Total:','$43.62','43.6200','ot_total',999),(803,23226,'Sub-Total:','$80.00','80.0000','ot_subtotal',100),(804,23226,'Per Item (Best Way):','$22.80','22.8000','ot_shipping',200),(805,23226,'Total:','$102.80','102.8000','ot_total',999),(806,23227,'Sub-Total:','$42.00','42.0000','ot_subtotal',100),(807,23227,'United States Postal Service (1 x 3.00lbs) (PARCEL):','$5.50','5.5000','ot_shipping',200),(808,23227,'Discount Coupons: mojo20 :','-$9.09','9.0900','ot_coupon',280),(809,23227,'CA TAX 8.25%:','$2.77','2.7723','ot_tax',300),(810,23227,'Total:','$41.19','41.1873','ot_total',999),(811,23228,'Sub-Total:','$30.00','30.0000','ot_subtotal',100),(812,23228,'United States Postal Service (1 x 3.00lbs) (PARCEL):','$8.02','8.0200','ot_shipping',200),(813,23228,'Total:','$38.02','38.0200','ot_total',999),(814,23229,'Sub-Total:','$30.00','30.0000','ot_subtotal',100),(815,23229,'United States Postal Service (1 x 3.00lbs) (PARCEL):','$8.62','8.6200','ot_shipping',200),(816,23229,'Total:','$38.62','38.6200','ot_total',999),(817,23230,'Sub-Total:','$90.00','90.0000','ot_subtotal',100),(818,23230,'Per Item (Best Way):','$21.30','21.3000','ot_shipping',200),(819,23230,'Total:','$111.30','111.3000','ot_total',999),(820,23231,'Sub-Total:','$20.00','20.0000','ot_subtotal',100),(821,23231,'United States Postal Service (1 x 3.00lbs) (PARCEL):','$5.50','5.5000','ot_shipping',200),(822,23231,'CA TAX 8.25%:','$1.65','1.6500','ot_tax',300),(823,23231,'Total:','$27.15','27.1500','ot_total',999),(824,23232,'Sub-Total:','$42.00','42.0000','ot_subtotal',100),(825,23232,'United States Postal Service (1 x 3.00lbs) (PARCEL):','$8.62','8.6200','ot_shipping',200),(826,23232,'Total:','$50.62','50.6200','ot_total',999),(827,23233,'Sub-Total:','$12.00','12.0000','ot_subtotal',100),(828,23233,'United States Postal Service (1 x 3.00lbs) (PARCEL):','$8.62','8.6200','ot_shipping',200),(829,23233,'Total:','$20.62','20.6200','ot_total',999),(830,23234,'Sub-Total:','$42.00','42.0000','ot_subtotal',100),(831,23234,'Per Item (Best Way):','$16.80','16.8000','ot_shipping',200),(832,23234,'Total:','$58.80','58.8000','ot_total',999),(833,23235,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(834,23235,'United States Postal Service (1 x 3.00lbs) (PARCEL):','$8.62','8.6200','ot_shipping',200),(835,23235,'Total:','$53.62','53.6200','ot_total',999),(836,23236,'Sub-Total:','$189.00','189.0000','ot_subtotal',100),(837,23236,'United States Postal Service (1 x 3.00lbs) (PARCEL):','$8.62','8.6200','ot_shipping',200),(838,23236,'Total:','$197.62','197.6200','ot_total',999),(839,23237,'Sub-Total:','$35.00','35.0000','ot_subtotal',100),(840,23237,'United States Postal Service (1 x 3.00lbs) (PARCEL):','$5.50','5.5000','ot_shipping',200),(841,23237,'CA TAX 8.25%:','$2.89','2.8875','ot_tax',300),(842,23237,'Total:','$43.39','43.3900','ot_total',999),(843,23238,'Sub-Total:','$42.00','42.0000','ot_subtotal',100),(844,23238,'United States Postal Service (1 x 3.00lbs) (PARCEL):','$5.50','5.5000','ot_shipping',200),(845,23238,'CA TAX 8.25%:','$3.47','3.4650','ot_tax',300),(846,23238,'Total:','$50.97','50.9700','ot_total',999),(847,23239,'Sub-Total:','$65.00','65.0000','ot_subtotal',100),(848,23239,'Per Item (Best Way):','$19.80','19.8000','ot_shipping',200),(849,23239,'Total:','$84.80','84.8000','ot_total',999),(850,23240,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(851,23240,'United States Postal Service (1 x 4.00lbs) (PARCEL):','$8.05','8.0500','ot_shipping',200),(852,23240,'Total:','$53.05','53.0500','ot_total',999),(853,23241,'Sub-Total:','$32.00','32.0000','ot_subtotal',100),(854,23241,'United States Postal Service (1 x 3.50lbs) (PARCEL):','$5.38','5.3800','ot_shipping',200),(855,23241,'Discount Coupons: TEST2 :','-$34.64','34.6400','ot_coupon',280),(856,23241,'Total:','$2.74','2.7400','ot_total',999),(857,23242,'Sub-Total:','$12.00','12.0000','ot_subtotal',100),(858,23242,'United States Postal Service (1 x 3.20lbs) (PARCEL):','$8.73','8.7300','ot_shipping',200),(859,23242,'Total:','$20.73','20.7300','ot_total',999),(860,23243,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(861,23243,'United States Postal Service (1 x 4.00lbs) (PARCEL):','$8.73','8.7300','ot_shipping',200),(862,23243,'Total:','$53.73','53.7300','ot_total',999),(863,23244,'Sub-Total:','$35.00','35.0000','ot_subtotal',100),(864,23244,'United States Postal Service (1 x 3.50lbs) (PARCEL):','$8.73','8.7300','ot_shipping',200),(865,23244,'Total:','$43.73','43.7300','ot_total',999),(866,23245,'Sub-Total:','$27.00','27.0000','ot_subtotal',100),(867,23245,'United States Postal Service (1 x 3.20lbs) (PARCEL):','$6.20','6.2000','ot_shipping',200),(868,23245,'Discount Coupons: mojo20 :','-$5.85','5.8500','ot_coupon',280),(869,23245,'CA TAX 8.25%:','$1.78','1.7816','ot_tax',300),(870,23245,'Total:','$29.13','29.1341','ot_total',999),(871,23246,'Sub-Total:','$45.00','45.0000','ot_subtotal',100),(872,23246,'United States Postal Service (1 x 3.50lbs) (PARCEL):','$8.73','8.7300','ot_shipping',200),(873,23246,'Total:','$53.73','53.7300','ot_total',999);

--
-- Table structure for table `paypal`
--

CREATE TABLE `paypal` (
  `paypal_ipn_id` int(11) unsigned NOT NULL auto_increment,
  `zen_order_id` int(11) unsigned NOT NULL default '0',
  `txn_type` varchar(10) NOT NULL default '',
  `reason_code` varchar(15) default NULL,
  `payment_type` varchar(7) NOT NULL default '',
  `payment_status` varchar(17) NOT NULL default '',
  `pending_reason` varchar(14) default NULL,
  `invoice` varchar(64) default NULL,
  `mc_currency` char(3) NOT NULL default '',
  `first_name` varchar(32) NOT NULL default '',
  `last_name` varchar(32) NOT NULL default '',
  `payer_business_name` varchar(64) default NULL,
  `address_name` varchar(32) default NULL,
  `address_street` varchar(64) default NULL,
  `address_city` varchar(32) default NULL,
  `address_state` varchar(32) default NULL,
  `address_zip` varchar(10) default NULL,
  `address_country` varchar(64) default NULL,
  `address_status` varchar(11) default NULL,
  `payer_email` varchar(96) NOT NULL default '',
  `payer_id` varchar(32) NOT NULL default '',
  `payer_status` varchar(10) NOT NULL default '',
  `payment_date` datetime NOT NULL default '0001-01-01 00:00:00',
  `business` varchar(96) NOT NULL default '',
  `receiver_email` varchar(96) NOT NULL default '',
  `receiver_id` varchar(32) NOT NULL default '',
  `txn_id` varchar(17) NOT NULL default '',
  `parent_txn_id` varchar(17) default NULL,
  `num_cart_items` tinyint(4) unsigned NOT NULL default '1',
  `mc_gross` decimal(7,2) NOT NULL default '0.00',
  `mc_fee` decimal(7,2) NOT NULL default '0.00',
  `payment_gross` decimal(7,2) default NULL,
  `payment_fee` decimal(7,2) default NULL,
  `settle_amount` decimal(7,2) default NULL,
  `settle_currency` char(3) default NULL,
  `exchange_rate` decimal(4,2) default NULL,
  `notify_version` decimal(2,1) NOT NULL default '0.0',
  `verify_sign` varchar(128) NOT NULL default '',
  `last_modified` datetime NOT NULL default '0001-01-01 00:00:00',
  `date_added` datetime NOT NULL default '0001-01-01 00:00:00',
  `memo` text,
  PRIMARY KEY  (`paypal_ipn_id`,`txn_id`),
  KEY `idx_paypal_paypal_ipn_id_zen` (`paypal_ipn_id`),
  KEY `idx_zen_order_id_zen` (`zen_order_id`)
) ENGINE=MyISAM AUTO_INCREMENT=62 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `paypal`
--

INSERT INTO `paypal` VALUES (1,77,'web_accept','','instant','Completed','','','USD','Maxine','Lim','','Maxine Lim','26180 Rancho Manuella Lane','Los Altos Hills','CA','94022','United States','confirmed','itsmaxine@gmail.com','LA7VGGLLYZATC','verified','2006-10-21 23:57:11','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','25M83793K5611403J','',0,'65.79','2.21',NULL,NULL,'0.00','','0.00','2.1','A8RQ0F8gkUzMctcqZ4r9aZzwD7JUAmSja8Ojl.rm2cYfDadhK1O2Ji7p','0001-01-01 00:00:00','2006-10-22 00:37:28',''),(2,78,'web_accept','','instant','Completed','','','USD','Monica','Der','','Monica Der','68 New Season','Irvine','CA','92602','United States','confirmed','monibabie96@yahoo.com','DUSRPU97QL438','verified','2006-10-26 01:00:24','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','90L81613W3485844A','',0,'30.02','1.17',NULL,NULL,'0.00','','0.00','2.1','Ay23xXigfAcIAV9asyMdgQv.nSCxAHnfPcsr4n.R82e74rbD0Qgpv9Tr','0001-01-01 00:00:00','2006-10-26 01:41:18',''),(3,80,'web_accept','','instant','Completed','','','USD','JERI LOU','BERARDI','','JERI LOU BERARDI','865 ASH ST','BROOMFIELD','CO','80020','United States','confirmed','JLBERARDI@COMCAST.NET','FV498CLTFEE76','unverified','2006-11-02 10:22:21','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','13F35861PM086141J','',0,'48.71','1.71',NULL,NULL,'0.00','','0.00','2.1','AVRVrUfS99K-YWiPS8ePV36F2ONRAf14MZeen-5c5l09RnZ1REL1ylMr','0001-01-01 00:00:00','2006-11-02 11:04:27',''),(4,83,'web_accept','','instant','Completed','','','USD','Christine','Thompson','','Christine Thompson','5702 Grand Creek Ln','Katy','TX','77450','United States','confirmed','atctfl@aol.com','4W3GH44JBH5BW','verified','2006-11-09 22:38:29','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','5NW64192684041622','',0,'56.76','1.95',NULL,NULL,'0.00','','0.00','2.1','An5ns1Kso7MWUdW4ErQKJJJ4qi4-AsSROcz2owhlkfeVfFSByub990-I','0001-01-01 00:00:00','2006-11-09 23:21:46',''),(5,23106,'web_accept','','instant','Completed','','','USD','Erin','Michaels','','Erin Michaels','144 La Belle St','Dayton','OH','45403','United States','unconfirmed','elmtree86@yahoo.com','552D4GRGDRALS','verified','2007-02-13 23:08:36','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','00R66245AD703641M','',0,'52.16','1.81',NULL,NULL,'0.00','','0.00','2.1','ANTeydYaXtVPPyZIXCqvooHBGghIARDRDk028mbfpWt.VNOALc4VJ7Jm','0001-01-01 00:00:00','2007-02-14 00:00:25','VDAY'),(6,23109,'web_accept','','instant','Completed','','','USD','jessica','neal','','jessica neal','43 Ivy Place\r\n1st Floor','Rutherford','NJ','07070','United States','confirmed','jessicaneal@gmail.com','VY4ZM2VXXSC66','verified','2007-02-27 08:44:13','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','4XF06607KG368493D','',0,'79.20','2.60',NULL,NULL,'0.00','','0.00','2.1','AUtOsfkvJVo0XEJIxvJctgLYf03PAtVoGOah71OtYCNdPbsj9VnYofxo','0001-01-01 00:00:00','2007-02-27 09:34:25',''),(7,23110,'web_accept','','echeck','Pending','echeck','','USD','Michael','Timpe','','Michael Timpe','Friedrich Ebert Strasse 60','Ingolstadt','BA','85055','Germany','unconfirmed','timmi67@t-online.de','5DPNN6ZMKS2AY','verified','2007-02-28 15:21:55','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','8XU780450G6076344','',0,'112.00','0.00',NULL,NULL,'0.00','','0.00','2.1','A4joEfULm8Gcvj0yqJFvHXuJ2x.3AETF8Pw-0EwyDbzV-.Wj5nVovjys','0001-01-01 00:00:00','2007-02-28 16:12:11',''),(8,23116,'web_accept','','instant','Completed','','','USD','michel','letko','','michel letko','1315 briar bayou drive','houston','TX','77077','United States','confirmed','micheletko@gmail.com','26QVWVU7JFXKJ','verified','2007-03-17 21:39:46','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','16350646VB203574W','',0,'26.05','1.06',NULL,NULL,'0.00','','0.00','2.1','AKwUpvimaCAfmfJ-.PhckWeGqTcrAO3ynIBldfaW8XbRowIIHTCONahh','0001-01-01 00:00:00','2007-03-17 21:29:51',''),(9,23125,'web_accept','','instant','Completed','','','USD','jessica','neal','','jessica neal','43 Ivy Place\r\n1st Floor','Rutherford','NJ','07070','United States','confirmed','jessicaneal@gmail.com','VY4ZM2VXXSC66','verified','2007-04-02 07:15:08','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','41Y80067GH8150047','',0,'110.86','3.51',NULL,NULL,'0.00','','0.00','2.1','A5hbyBq8t.4RFxP1V9ls-vH0SAwvASjp0me6Tbp4O.FCgt8qEE1JuIEM','0001-01-01 00:00:00','2007-04-02 08:07:38',''),(10,23126,'web_accept','','instant','Completed','','','USD','michel','letko','','michel letko','1315 briar bayou drive','houston','TX','77077','United States','confirmed','micheletko@gmail.com','26QVWVU7JFXKJ','verified','2007-04-16 20:20:26','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','0JD78180SR440081F','',0,'35.05','1.32',NULL,NULL,'0.00','','0.00','2.1','AjUswMjkGZMpju02FL6CmQUapYo-Aq7YCudzQrSAcuVwBJbXlWgxRpQB','0001-01-01 00:00:00','2007-04-16 21:14:57',''),(11,23127,'web_accept','','instant','Completed','','','USD','shaheen','neil','','shaheen neil','7445 E. Butler Drive','Scottsdale','AZ','85258','United States','confirmed','spneil@cox.net','S4NDTLZKFYAM4','unverified','2007-04-18 13:00:39','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','0U765870T4037590F','',0,'69.35','2.31',NULL,NULL,'0.00','','0.00','2.1','A5Z-s1XfNvbTlsUrRoLTAbr.0vnNAKtW8OKA6blBBN-PViR5a4BBRD5D','0001-01-01 00:00:00','2007-04-18 13:55:28',''),(12,23132,'web_accept','','instant','Completed','','','USD','Jennifer','Zambernard','','Jennifer Zambernard','9737 Mt. Pisgah  Rd. Apt 607','Silver Spring','MD','20903','United States','confirmed','J_Zambernard@msn.com','9F3WXR3B69ZD4','verified','2007-05-23 09:52:34','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','21X5710764091420S','',0,'51.05','1.78',NULL,NULL,'0.00','','0.00','2.1','AGRVCaWJk8VeOP3sCpkj0CH.jpJUABp-FzL1-YtlB0cr8Riqp2RyjoTq','0001-01-01 00:00:00','2007-05-23 06:53:20',''),(13,23137,'web_accept','','instant','Completed','','','USD','Marcus','King','','Marcus King','343 57th Street','Newport News','VA','23607','United States','confirmed','marcusking@cox.net','ZXJZXXXNLNXQA','verified','2007-07-03 23:57:20','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','26X6424006683450C','',0,'51.05','1.78',NULL,NULL,'0.00','','0.00','2.4','AFcWxV21C7fd0v3bYYYRCpSSRl31ASE-G.9H7tCPwHCraz-LV44SNarD','0001-01-01 00:00:00','2007-07-04 01:57:27',''),(14,23139,'web_accept','','instant','Completed','','','USD','yolanta','Kurzydlo','','yolanta Kurzydlo','PO BOX 60034','OAKVILLE','Ontario','L6M 3H2','Canada','confirmed','yolanta@sympatico.ca','W4W2SDZPNLY3Q','unverified','2007-07-25 14:30:21','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','3M232119VT577384A','',0,'231.00','9.31',NULL,NULL,'0.00','','0.00','2.4','ASNkeSHY6BfsN2hU07WyVShf-ISEANhkPXoZKb8HJBvGz9N-9TQcg9k2','0001-01-01 00:00:00','2007-07-25 16:30:30',''),(15,23140,'web_accept','','instant','Completed','','','USD','teri','conry','','teri conry','56 winegarden trail','dundas','Ontario','L9H7M2','Canada','confirmed','lipstickchick1@hotmail.com','C8KQJG2RM3RPJ','unverified','2007-07-27 20:30:21','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','0CC331806G774654B','',0,'58.00','2.56',NULL,NULL,'0.00','','0.00','2.4','A.CSYz4u5IILQm5wM0J0JbJiIcEuARIntDLzfQK4iZI.AXds971Oqkzs','0001-01-01 00:00:00','2007-07-27 22:30:29',''),(16,23141,'web_accept','','instant','Completed','','','USD','Isabelle','Genna','','Isabelle Genna','133 Leventoux','Sept-ILes','QC','G4R 5K3','Canada','confirmed','isamax@cgocable.ca','7899YA6XECDQ4','verified','2007-07-29 06:27:01','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','5VE18637V52431702','',0,'103.00','4.32',NULL,NULL,'0.00','','0.00','2.4','ARyNDMbKwa-zLx7AtfPa-etrhyTVAcUBCYBgFguabO8487gn9uhbhBXx','0001-01-01 00:00:00','2007-07-29 08:27:11',''),(17,23142,'web_accept','','instant','Completed','','','USD','Shauna','Jensen','','Shauna Jensen','705, 9330 - 101 A Ave\r\nBuzzer 11','Edmonton','Alberta','T5H 0C3','Canada','confirmed','sjdesign@shaw.ca','6LRWB7GZUWLT6','verified','2007-08-01 15:36:06','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','8EY39372JX3620101','',0,'150.00','6.15',NULL,NULL,'0.00','','0.00','2.4','AxY4PZnLwHn-wCsVYatnHp9kp4-PAMuPqYzjzp3rUo-5FOnR0LIibrh-','0001-01-01 00:00:00','2007-08-01 17:36:18',''),(18,23143,'web_accept','','instant','Completed','','','USD','Cynthia','Lai','','Cynthia Lai','2065 West 13th Avenue','Vancouver','British Columbia','V6J 2H8','Canada','confirmed','cynthia_lai@shaw.ca','34ZUJ5VL4YNDN','unverified','2007-08-05 21:04:24','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','4338506230289425J','',0,'53.00','2.37',NULL,NULL,'0.00','','0.00','2.4','Ar-gNnjIZSj.5KnoyA1pPaXiLuAqAwy7jZtQeUn-VmoPjhjU7L3AS236','0001-01-01 00:00:00','2007-08-05 23:04:35',''),(19,23144,'web_accept','','instant','Completed','','','USD','Marisa','Colosimo','','Marisa Colosimo','41 Flatbush Ave.','Woodbridge','Ontario','L4L 8K2','Canada','unconfirmed','marisa@emair.on.ca','8PNGBZHA2ARXQ','unverified','2007-08-07 08:38:19','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','3SG33887U04338944','',0,'103.00','4.32',NULL,NULL,'0.00','','0.00','2.4','A5piKcRN.ppHPWYiQMet5S3HGN-lAOc9e5CG73u4THNSqJCshvoMXh5v','0001-01-01 00:00:00','2007-08-07 10:38:28',''),(20,23145,'web_accept','','instant','Completed','','','USD','angelique','roy','','angelique roy','1638 beauharnois','longueuil','Quebec','j4m1z7','Canada','unconfirmed','angelique.roy@hotmail.com','9L95HSQCWM9Q8','unverified','2007-08-07 18:38:01','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','8MK19348H5277894P','',0,'63.00','2.76',NULL,NULL,'0.00','','0.00','2.4','A.CSYz4u5IILQm5wM0J0JbJiIcEuA56.MdUEjGeAgYgHXXA3SHyhPQoj','0001-01-01 00:00:00','2007-08-07 20:38:23',''),(21,23146,'web_accept','','instant','Completed','','','USD','michel','letko','','michel letko','1315 briar bayou drive','houston','TX','77077','United States','confirmed','micheletko@gmail.com','26QVWVU7JFXKJ','verified','2007-08-07 21:54:05','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','18085850KL097423K','',0,'52.55','1.82',NULL,NULL,'0.00','','0.00','2.4','AQU0e5vuZCvSg-XJploSa.sGUDlpAci34HljdWXvkZGKSSN8ZpkOvqSc','0001-01-01 00:00:00','2007-08-07 23:54:16',''),(22,23147,'web_accept','','instant','Completed','','','USD','Cynthia','Chan','','Cynthia Chan','#8, 287 MacEwan Road SW','Edmonton','AL','T6W 1T4','Canada','unconfirmed','cchan@ualberta.net','JZCVTWPMHLK94','verified','2007-08-08 11:39:14','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','9VU777687U945434A','',0,'103.00','4.32',NULL,NULL,'0.00','','0.00','2.4','AUkau1FwogE3kL3qo1vGTARqlijQA78I-E6ZZo4zz-V7EzNJh6zYP0n.','0001-01-01 00:00:00','2007-08-08 13:39:21',''),(23,23149,'web_accept','','instant','Completed','','','USD','Danielle','Biderman','','Danielle Biderman','16 Furnival Road','Toronto','Ontario','M4B 1W2','Canada','confirmed','pinnhead@sympatico.ca','SPU9NNHGR2TNE','unverified','2007-08-14 20:04:29','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','1TW18584W7805944W','',0,'58.00','2.56',NULL,NULL,'0.00','','0.00','2.4','AGu.hbwMxRXoqDiyy-IJNOnULnvNAPpDD8JG3N.9tV1j0asx5-Gq9BBg','0001-01-01 00:00:00','2007-08-14 22:04:36',''),(24,23150,'web_accept','','instant','Completed','','','USD','Cherie','Lue','','Cherie Lue','9 Kevlin Rd.','Markham','Ontario','L3R 8P3','Canada','unconfirmed','cherie_lue@hotmail.com','C8ADDR4E8QNQG','unverified','2007-08-15 20:27:06','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','1A3537257N8694540','',0,'58.00','2.56',NULL,NULL,'0.00','','0.00','2.4','A8fbXTElYegAYvbur23atwEOsQ69AEUAJBwkx8EVvwKUZSVkvjMmSyfz','0001-01-01 00:00:00','2007-08-15 22:27:33',''),(25,23152,'web_accept','','instant','Completed','','','USD','Karen','Turner','','Karen Turner','222 Gathercole Cres','Saskatoon','Saskatchewan','S7K 7J2','Canada','confirmed','tcem.kturner@sasktel.net','LGXJ8HKB35XJ6','unverified','2007-08-19 11:13:10','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','9VC14087C93410639','',0,'58.00','2.56',NULL,NULL,'0.00','','0.00','2.4','ACUe-E7Hjxmeel8FjYAtjnx-yjHAAxbWNmVFjK1rZjB-oteHlvTLT2Lu','0001-01-01 00:00:00','2007-08-19 13:13:20',''),(26,23153,'web_accept','','instant','Completed','','','USD','Lewis','Levin','','Lewis Levin','131 Riverdale Avenue','Ottawa','Ontario','K1S 1R1','Canada','unconfirmed','lewislevin@rogers.com','AALA7Q53839KE','verified','2007-08-31 12:00:18','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','5F380595DJ030524T','',0,'85.00','3.62',NULL,NULL,'0.00','','0.00','2.4','AMEMlF4Nrgs5CeOS27FhaeVXHAHtAvNjpqVPh9VgVFwW0VHQGcbHoy.x','0001-01-01 00:00:00','2007-08-31 14:00:24',''),(27,23154,'web_accept','','instant','Completed','','','USD','ginette','martin','','ginette martin','667 josaphat-demers','laval','Quebec','H7X 3R3','Canada','unconfirmed','gmarti5@videotron.ca','CKS2XZ338F2WU','unverified','2007-09-09 12:24:21','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','2CE672267L639870J','',0,'58.00','2.56',NULL,NULL,'0.00','','0.00','2.4','AxTw8exiQOTbGlAXBlfTz5kehuiXALR6kCl9cmRYdVwoxIa9ZvNorLZD','0001-01-01 00:00:00','2007-09-09 14:24:30',''),(28,23155,'web_accept','','instant','Completed','','','USD','Andrey','Abrosimov','','Andrey Abrosimov','61 Somervale Pk SW','Calgary','Alberta','T2Y 3J4','Canada','confirmed','write.letters@shaw.ca','XALQNF58BWVPQ','unverified','2007-09-12 09:58:39','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','37B04948SD805600M','',0,'85.25','3.62',NULL,NULL,'0.00','','0.00','2.4','AwXPaAdZ.FzSiJYtX6G1b0AzyoheA5q4uVqk0fdvL9-S32qmeqpfrA7n','0001-01-01 00:00:00','2007-09-12 11:58:51',''),(29,23158,'web_accept','','instant','Completed','','','USD','isabelle','blouin','','isabelle blouin','182 principale','ste-justine','Quebec','g0r1y0','Canada','unconfirmed','isab@sogetel.net','PED2CMB98RK2A','unverified','2007-09-27 18:44:58','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','40U294111F084940T','',0,'58.00','2.56',NULL,NULL,'0.00','','0.00','2.4','An5ns1Kso7MWUdW4ErQKJJJ4qi4-AXlgs1i4.aSemQ9BCFvSxynpe0ju','0001-01-01 00:00:00','2007-09-27 20:45:15',''),(30,23160,'web_accept','','instant','Completed','','','USD','Karen','Wagg','','Karen Wagg','3143-104 Street','Edmonton','Alberta','T6J 3B2','Canada','confirmed','karenwagg@shaw.ca','VGF3VAG3DX3BW','unverified','2007-10-06 10:43:22','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','7BV48266U52992228','',0,'85.00','3.62',NULL,NULL,'0.00','','0.00','2.4','AcxNuZeF2SaXOHLpACNgpGxGNZgwAbBQt2qGbDBy5X.R2M6wT2243VHp','0001-01-01 00:00:00','2007-10-06 12:43:36',''),(31,23167,'web_accept','','instant','Completed','','','USD','michel','letko','','michel letko','1315 briar bayou drive','houston','TX','77077','United States','confirmed','micheletko@gmail.com','26QVWVU7JFXKJ','verified','2007-10-23 08:52:20','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','5BD51887NJ047371D','',0,'39.60','1.45',NULL,NULL,'0.00','','0.00','2.4','AwZavtaPGTwyxfIxFp02C49sm24DAQvdOY.cNTVL9wJYYH1BBrHQJkWo','0001-01-01 00:00:00','2007-10-23 10:52:25',''),(32,23168,'web_accept','','instant','Completed','','','USD','Connie','Varndell','','Connie Varndell','9 Lock Place','Okotoks','Alberta','T1S1E9','Canada','confirmed','dottymay@hotmail.com','C2PW2ZZYKQVZN','unverified','2007-10-25 11:55:27','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','46663424H7687982C','',0,'53.00','2.37',NULL,NULL,'0.00','','0.00','2.4','AYJLvLRc-8CHNMODSzFC6aPWX4d0A34H7w7L2OMSwZHgSSb2cMIWrEhq','0001-01-01 00:00:00','2007-10-25 13:55:38',''),(33,23176,'web_accept','','instant','Completed','','','USD','Shauna','Jensen','','Shauna Jensen','705, 9330 - 101 A Ave\r\nBuzzer 11','Edmonton','Alberta','T5H 0C3','Canada','confirmed','sjdesign@shaw.ca','6LRWB7GZUWLT6','verified','2007-11-13 11:54:31','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','568432158B607563V','',0,'120.30','4.99',NULL,NULL,'0.00','','0.00','2.4','Adc7Vzlq67vfUmnw9uoqZxQ8.ukOA4lYhTPQvaYC4skPEVILVHzYh9S3','0001-01-01 00:00:00','2007-11-13 14:05:47',''),(34,23177,'web_accept','','instant','Completed','','','USD','Andrey','Abrosimov','','Andrey Abrosimov','61 Somervale Pk SW','Calgary','Alberta','T2Y 3J4','Canada','confirmed','write.letters@shaw.ca','XALQNF58BWVPQ','unverified','2007-11-13 17:27:15','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','9UC74008TK282483U','',0,'100.80','4.23',NULL,NULL,'0.00','','0.00','2.4','AOh0tu.5JUQyG2Aao4MpntBA2sFjA8zgNRmMV9t8zRTnyk6T9Rk8BBML','0001-01-01 00:00:00','2007-11-13 19:27:25',''),(35,23179,'web_accept','','instant','Completed','','','USD','Maja','Ten Ton','','Maja Ten Ton','Calle Calvario 8','Marbella','MA','29600','Spain','unconfirmed','tanukigirl@mac.com','CVZ8ARFTAVEAL','verified','2007-11-16 12:28:10','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','7MK0241213678870X','',0,'122.30','5.07',NULL,NULL,'0.00','','0.00','2.4','ApBHX6qbpxJW-Ll3oP22LSbo0WeuATmdzrdPH80l8mEe64v2K8o9RRxg','0001-01-01 00:00:00','2007-11-16 14:28:49',''),(36,23180,'web_accept','','instant','Completed','','','USD','Natsue','Ishida','','Natsue Ishida','#101 G Heim, 6-1-25','Shinagawa-ku','TO','1420053','Japan','unconfirmed','lillicat@nifty.com','D33FQUEHQYGUJ','unverified','2007-11-16 20:09:58','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','5M3871526A092273U','',0,'65.30','2.85',NULL,NULL,'0.00','','0.00','2.4','AZcbG9jp.5arkyx7wu50u8BOcCTPAkxnTdhTmadjafA.dsbDWx0E2cUB','0001-01-01 00:00:00','2007-11-16 22:10:17',''),(37,23181,'web_accept','','instant','Completed','','','USD','Karen','Horie','','Karen Horie','2216 Punta Del Este Drive','Hacienda Heights','CA','91745','United States','confirmed','kh247@verizon.net','8BXWMKDPBYK2A','verified','2007-11-16 21:29:18','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','4W088202DD566312J','',0,'37.94','1.40',NULL,NULL,'0.00','','0.00','2.4','AFd.erwt7VoeoUMr85yut0RloHozAGf9nmUxYTewPAbwync9rwJEgE9C','0001-01-01 00:00:00','2007-11-16 23:29:31',''),(38,23185,'web_accept','','instant','Completed','','','USD','Karen','Herz','','Karen Herz','1 Orange Blossom','Irvine','CA','92618','United States','confirmed','booberlynn@yahoo.com','R2R93C84BFTAN','verified','2007-11-21 21:05:09','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','230147530N7816446','',0,'54.27','1.87',NULL,NULL,'0.00','','0.00','2.4','AiKZhEEPLJjSIccz.2M.tbyW5YFwAQAfASFYESZTjA7RxivFlKuld7u7','0001-01-01 00:00:00','2007-11-21 23:05:25',''),(39,23186,'web_accept','','instant','Completed','','','USD','Jessica','Zeidal Meyer','','Jessica Zeidal Meyer','810 N. Maplewood\r\n#1','Chicago','IL','60622','United States','confirmed','zeidal_2000@yahoo.com','JYSNXE3XNZLRL','unverified','2007-12-01 17:03:40','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','0J808948342207845','',0,'22.15','0.94',NULL,NULL,'0.00','','0.00','2.4','A21kmBLyRcQpDSjYvmswlm3ckjahAxr17ewnYCQRxFF3q7Qa86-LLKpe','0001-01-01 00:00:00','2007-12-01 19:03:55',''),(40,23188,'web_accept','','instant','Completed','','','USD','dale','duncan','','dale duncan','1200 trenton lane','euless','TX','76040','United States','confirmed','dmautogroup@sbcglobal.net','LR7UU9NL7S4AQ','verified','2007-12-08 14:30:12','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','8P067384671843111','',0,'21.60','0.93',NULL,NULL,'0.00','','0.00','2.4','A-l7Ht3gCcGUz87UP0AOBYyGo3TWADdj0LEF93iwHhoBgKnfa3BIVvBb','0001-01-01 00:00:00','2007-12-08 16:30:23',''),(41,23192,'web_accept','','instant','Completed','','','USD','Stephenie','Corn','','Stephenie Corn','88 Albert Street','Waterloo','Ontario','N2L 3S7','Canada','confirmed','stephcorn@sympatico.ca','GM2GXGGF3BVVU','verified','2008-01-27 10:49:48','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','97304876B2288823G','',0,'60.30','2.65',NULL,NULL,'0.00','','0.00','2.4','AfBNSKv1sSapksBfsFS9OJArkMmWAJb.3Qjpm-E5sfqeqWaW00cyIYbY','0001-01-01 00:00:00','2008-01-27 12:50:05',''),(42,23195,'web_accept','','instant','Completed','','','USD','Yolanta','Kurzydlo','','Yolanta Kurzydlo','PO BOX 60034','OAKVILLE','Ontario','L6M 3H2','Canada','confirmed','yolanta@sympatico.ca','W4W2SDZPNLY3Q','unverified','2008-02-12 08:52:30','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','9WE89088R86144255','',0,'110.30','4.60',NULL,NULL,'0.00','','0.00','2.4','Aby717TIyQXiy0P8RG3mBmfZrRuSAtCbMA2tYKjZWfzJ93W4a3l0447A','0001-01-01 00:00:00','2008-02-12 10:52:47',''),(43,23198,'web_accept','','echeck','Pending','echeck','','USD','Mary','Lewison','','Mary Lewison','58721 160th Street','Rose Creek','MN','55970','United States','confirmed','mjlewison@msn.com','GBCVQWLW4G8ZC','verified','2008-02-19 21:57:50','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','3DV98800MM1000529','',0,'52.15','0.00',NULL,NULL,'0.00','','0.00','2.4','AZcYg5STzz0AsovXTYLiwqCuuzcSAn8PAv.FpfL4DsSvSwOF55fBIp7s','0001-01-01 00:00:00','2008-02-19 23:58:01',''),(44,23199,'web_accept','','instant','Completed','','','USD','lynn','behm','','lynn behm','1650 266th street','harbor city','CA','90710','United States','unconfirmed','lynnpko@yahoo.com','DTT28L8MFWWJQ','unverified','2008-02-24 13:49:51','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','8E4743901L7645649','',0,'86.74','2.82',NULL,NULL,'0.00','','0.00','2.4','A.CSYz4u5IILQm5wM0J0JbJiIcEuAUOLJVfYj5ht9VhLclG1mgNYWHHx','0001-01-01 00:00:00','2008-02-24 15:50:07',''),(45,23201,'web_accept','','instant','Completed','','','USD','Diane','Naylor','Dianes Fine Art','Dianes Fine Art','1000 Pleasant Plain Rd, Unit #201','Fairfield','IA','52556','United States','confirmed','info@dianesfineart.com','JVUL8GR9ZFPYJ','verified','2008-04-03 12:40:29','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','82R57524XH649625G','',0,'40.15','1.46',NULL,NULL,'0.00','','0.00','2.4','AZHQaA4dyQEpHZFzHmIcyG62.X4NABH94pT1ZFmzBJ6aabonI1lSXmQS','0001-01-01 00:00:00','2008-04-03 14:40:41',''),(46,23203,'web_accept','','instant','Completed','','','USD','Debbie','Turkington','','Debbie Turkington','PO Box 3534','Soldotna','AK','99669','United States','confirmed','jjbjj@gci.net','97YD5PZQVZEYC','verified','2008-04-14 21:31:53','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','3PD69125B2987690G','',0,'51.05','1.78',NULL,NULL,'0.00','','0.00','2.4','A2YnYs6LuOd-R8BHIdbWTA6xHgalAKAqiaSBsI3s31hWMk2Epo9.siuj','0001-01-01 00:00:00','2008-04-14 23:32:06',''),(47,23204,'web_accept','','instant','Completed','','','USD','Todd','Miller','','Mary Margaret Miller','1908 Flynn Street','Alva','OK','73717-3704','United States','confirmed','mmmgsmd62@sbcglobal.net','8NBUK658TKQ4W','verified','2008-04-17 09:29:51','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','878926976B2697626','',0,'43.20','1.55',NULL,NULL,'0.00','','0.00','2.4','A-RSRUGgn6Qr3M.Oc5mK0FLdAW.5ACgFTLQ4gjn6FE5Tgoq3dYsSLXUG','0001-01-01 00:00:00','2008-04-17 11:39:30',''),(48,23205,'web_accept','','instant','Completed','','','USD','Darla','Catalano','','Darla Catalano','1056 Wheatland Avenue','Lancaster','PA','17603','United States','confirmed','darlacatalano@aol.com','UCKCPECF7S2BG','verified','2008-04-21 14:37:56','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','6KK58663VF4403138','',0,'47.05','1.66',NULL,NULL,'0.00','','0.00','2.4','ATOwmFugiV5w7zYaJ0M7DizFlZzMAhK.UKvrojToGMVu63CGY9HSXCaO','0001-01-01 00:00:00','2008-04-21 16:38:05',''),(49,23207,'web_accept','','echeck','Pending','echeck','','USD','Mary','Lewison','','Mary Lewison','58721 160th Street','Rose Creek','MN','55970','United States','confirmed','mjlewison@msn.com','GBCVQWLW4G8ZC','verified','2008-04-22 15:45:47','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','5B874272388706101','',0,'52.15','0.00',NULL,NULL,'0.00','','0.00','2.4','ArFZ5DF1pEd4euI2jpvbEwe5Q4BiA3UjXBaXZ.G3sVypra5Uzt3VPd6O','0001-01-01 00:00:00','2008-04-22 17:46:09',''),(50,23210,'web_accept','','instant','Completed','','','USD','Maria','Castro','','Maria Castro','1 Leonard Street Apt. #5','Meriden','CT','06451','United States','confirmed','marialoida25@yahoo.com','4ZTX9AGUJ2XE2','unverified','2008-04-24 09:59:23','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','6RG48801VU3694214','',0,'43.43','1.56',NULL,NULL,'0.00','','0.00','2.4','AxXkeaiqAbnk8HGCz3H-2kp3P.Z3A0kMYUvCMEqp59w55WP6RN9Hq3K1','0001-01-01 00:00:00','2008-04-24 11:59:31',''),(51,23213,'web_accept','','instant','Completed','','','USD','Peter','Boersma','','Peter Boersma','Oostenburgervoorstraat 296','Amsterdam','Noord-Holland','1018 MR','Netherlands','unconfirmed','peter@peterboersma.com','BU93UGDXQE4PE','verified','2008-05-01 14:18:44','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','1MK117354T399852G','',0,'63.30','2.77',NULL,NULL,'0.00','','0.00','2.4','AAgnoRnAF3j.XXcmqCSkv5wc1Y.FAVsGYJLSEfpPRrM5mcgBsPt219is','0001-01-01 00:00:00','2008-05-01 16:19:01',''),(52,23219,'web_accept','','instant','Completed','','','USD','lynn','behm','','lynn behm','1650 266th street','harbor city','CA','90710','United States','unconfirmed','lynnpko@yahoo.com','DTT28L8MFWWJQ','unverified','2008-05-13 17:31:16','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','8EG19214E7428925B','',0,'83.65','2.73',NULL,NULL,'0.00','','0.00','2.4','AI36sk2Aln3iC.t.mla1wMizPRcQADr1w5hPFC.7a6qZK0zA-xnGyDRN','0001-01-01 00:00:00','2008-05-13 19:31:22',''),(53,23224,'web_accept','','echeck','Pending','echeck','','USD','Jeff','Major','','Jeff Major','7332 Parkvale Way','Citrus Heights','CA','95621','United States','confirmed','jmajor9@surewest.net','XKZYYYHT7P2CG','verified','2008-06-11 22:22:15','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','9LG88424UN890501T','',0,'52.57','0.00',NULL,NULL,'0.00','','0.00','2.4','AWAJz3uKHu3GqRSoRyqRT6cjx9KBAPJlMatqgbPidEWBJbXSyRcDMpxc','0001-01-01 00:00:00','2008-06-12 00:22:34',''),(54,23228,'web_accept','','instant','Completed','','','USD','Mary','Lewison','','Mary Lewison','58721 160th Street','Rose Creek','MN','55970','United States','confirmed','mjlewison@msn.com','GBCVQWLW4G8ZC','verified','2008-07-18 11:55:56','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','84D435649S7501718','',0,'38.02','1.40',NULL,NULL,'0.00','','0.00','2.4','AkObo0jCskFHpix5eN5.jLG1LJ.8AlyOiZukK1x2Bdu1dKZ2WmjGGtWi','0001-01-01 00:00:00','2008-07-18 13:56:24',''),(55,23230,'web_accept','','instant','Completed','','','USD','Jolanta','Kurzydlo','','Jolanta Kurzydlo','PO BOX 60034','OAKVILLE','Ontario','L6M 3H2','Canada','confirmed','yolanta@sympatico.ca','YNBTYDX37XFMS','unverified','2008-08-13 12:31:33','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','11R99200WK0517134','',0,'111.30','4.64',NULL,NULL,'0.00','','0.00','2.4','AEBLNVGK33V6d4bL5w79JRQsJIobAC4D01ri4FD7w3xImsfYMFxXtWwn','0001-01-01 00:00:00','2008-08-13 14:31:44',''),(56,23231,'web_accept','','instant','Completed','','','USD','SHARON','DRIVER','','SHARON DRIVER','4905 Castana AVE Apt 03','Lakewood','CA','90712','United States','confirmed','sharon.stjames@sbcglobal.net','2242HYZDXYP7J','unverified','2008-09-07 12:23:30','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','64451613YF386551D','',0,'27.15','1.09',NULL,NULL,'0.00','','0.00','2.5','ARmIEN4ypApusFjGmBa9WkdCk5M7ATFqlROzv-Id.WW2uWVKUAQqQN-2','0001-01-01 00:00:00','2008-09-07 14:23:37',''),(57,23234,'web_accept','','instant','Completed','','','USD','Jeannie','Vega Bjorkoy','','Jeannie Vega','Røyskattveien 62','Kattem','NO','7082','Norway','unconfirmed','M00NGENIE@aol.com','RMS6E2DQ6VFE8','unverified','2008-09-18 14:09:38','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','8GJ14907A55270542','',0,'58.80','2.59',NULL,NULL,'0.00','','0.00','2.5','A.CSYz4u5IILQm5wM0J0JbJiIcEuAA6E9Ss6TIXtwjKc65ZEKCCV2IjZ','0001-01-01 00:00:00','2008-09-18 16:09:59',''),(58,23239,'web_accept','','instant','Completed','','','USD','Lynn','Schwartz','','Lynn Langille','2120 Shannon Ridge Drive','Westbank','BR','V4T 2Z3','Canada','unconfirmed','lynna@telus.net','F57TH9GKFXNBL','unverified','2008-10-10 13:09:44','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','43P60134J29064119','',0,'84.80','3.61',NULL,NULL,'0.00','','0.00','2.5','AomRS5l2W2xlt2An.GaSrAzpCl-NA5IXX6fQ4ppu2.Equxx6xdkVCiL.','0001-01-01 00:00:00','2008-10-10 15:09:53',''),(59,23244,'web_accept','','instant','Completed','','','USD','michel','letko','','michel letko','1315 briar bayou drive','houston','TX','77077','United States','confirmed','micheletko@gmail.com','26QVWVU7JFXKJ','verified','2009-01-07 11:17:30','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','2YK74786WT231540W','',0,'43.73','1.57',NULL,NULL,'0.00','','0.00','2.6','An5ns1Kso7MWUdW4ErQKJJJ4qi4-AE7-UIuMbIDQD6igVBpdzUaEM.HZ','0001-01-01 00:00:00','2009-01-07 13:17:36',''),(60,23245,'web_accept','','instant','Completed','','','USD','Melissa','Chitwood','','Melissa Chitwood','2729 Broadmoor Ave','Simi valley','CA','93065','United States','confirmed','mochimeli@aol.com','Z8BZA4L7MJFXL','unverified','2009-01-10 22:51:36','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','47093425A1682443L','',0,'29.13','1.14',NULL,NULL,'0.00','','0.00','2.6','An5ns1Kso7MWUdW4ErQKJJJ4qi4-Aiwn56vphqZ1OWPzTXKRUtUI5C0Y','0001-01-01 00:00:00','2009-01-11 00:51:43',''),(61,23246,'web_accept','','instant','Completed','','','USD','linda','post','','linda post','P.O. Box 367\r\n1801 North 4th','Sayre','OK','73662','United States','confirmed','jlpost@cableone.net','TR8LQCMXRWDKS','verified','2009-01-29 20:25:57','shop@mojocosmetics.us','shop@mojocosmetics.us','23E983ZPS9QDG','8ME67549VL2079358','',0,'53.73','1.86',NULL,NULL,'0.00','','0.00','2.6','A0asK6oiIZmtBFrRCq-Iiqf8lrk.ATHHGxiH.GSfIR8XuH4nVoHNVKIL','0001-01-01 00:00:00','2009-01-29 22:26:01','');

--
-- Table structure for table `paypal_payment_status`
--

CREATE TABLE `paypal_payment_status` (
  `payment_status_id` int(11) NOT NULL auto_increment,
  `payment_status_name` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`payment_status_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `paypal_payment_status`
--

INSERT INTO `paypal_payment_status` VALUES (1,'Completed'),(2,'Pending'),(3,'Failed'),(4,'Denied'),(5,'Refunded'),(6,'Canceled_Reversal'),(7,'Reversed');

--
-- Table structure for table `paypal_payment_status_history`
--

CREATE TABLE `paypal_payment_status_history` (
  `payment_status_history_id` int(11) NOT NULL auto_increment,
  `paypal_ipn_id` int(11) NOT NULL default '0',
  `txn_id` varchar(64) NOT NULL default '',
  `parent_txn_id` varchar(64) NOT NULL default '',
  `payment_status` varchar(17) NOT NULL default '',
  `pending_reason` varchar(14) default NULL,
  `date_added` datetime NOT NULL default '0001-01-01 00:00:00',
  PRIMARY KEY  (`payment_status_history_id`),
  KEY `idx_paypal_ipn_id_zen` (`paypal_ipn_id`)
) ENGINE=MyISAM AUTO_INCREMENT=62 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `paypal_payment_status_history`
--

INSERT INTO `paypal_payment_status_history` VALUES (1,1,'25M83793K5611403J','','Completed','','2006-10-22 00:37:28'),(2,2,'90L81613W3485844A','','Completed','','2006-10-26 01:41:18'),(3,3,'13F35861PM086141J','','Completed','','2006-11-02 11:04:27'),(4,4,'5NW64192684041622','','Completed','','2006-11-09 23:21:46'),(5,5,'00R66245AD703641M','','Completed','','2007-02-14 00:00:25'),(6,6,'4XF06607KG368493D','','Completed','','2007-02-27 09:34:25'),(7,7,'8XU780450G6076344','','Pending','echeck','2007-02-28 16:12:11'),(8,8,'16350646VB203574W','','Completed','','2007-03-17 21:29:51'),(9,9,'41Y80067GH8150047','','Completed','','2007-04-02 08:07:38'),(10,10,'0JD78180SR440081F','','Completed','','2007-04-16 21:14:57'),(11,11,'0U765870T4037590F','','Completed','','2007-04-18 13:55:28'),(12,12,'21X5710764091420S','','Completed','','2007-05-23 06:53:20'),(13,13,'26X6424006683450C','','Completed','','2007-07-04 01:57:27'),(14,14,'3M232119VT577384A','','Completed','','2007-07-25 16:30:30'),(15,15,'0CC331806G774654B','','Completed','','2007-07-27 22:30:29'),(16,16,'5VE18637V52431702','','Completed','','2007-07-29 08:27:11'),(17,17,'8EY39372JX3620101','','Completed','','2007-08-01 17:36:18'),(18,18,'4338506230289425J','','Completed','','2007-08-05 23:04:35'),(19,19,'3SG33887U04338944','','Completed','','2007-08-07 10:38:28'),(20,20,'8MK19348H5277894P','','Completed','','2007-08-07 20:38:23'),(21,21,'18085850KL097423K','','Completed','','2007-08-07 23:54:16'),(22,22,'9VU777687U945434A','','Completed','','2007-08-08 13:39:21'),(23,23,'1TW18584W7805944W','','Completed','','2007-08-14 22:04:36'),(24,24,'1A3537257N8694540','','Completed','','2007-08-15 22:27:33'),(25,25,'9VC14087C93410639','','Completed','','2007-08-19 13:13:20'),(26,26,'5F380595DJ030524T','','Completed','','2007-08-31 14:00:24'),(27,27,'2CE672267L639870J','','Completed','','2007-09-09 14:24:30'),(28,28,'37B04948SD805600M','','Completed','','2007-09-12 11:58:51'),(29,29,'40U294111F084940T','','Completed','','2007-09-27 20:45:15'),(30,30,'7BV48266U52992228','','Completed','','2007-10-06 12:43:36'),(31,31,'5BD51887NJ047371D','','Completed','','2007-10-23 10:52:25'),(32,32,'46663424H7687982C','','Completed','','2007-10-25 13:55:38'),(33,33,'568432158B607563V','','Completed','','2007-11-13 14:05:47'),(34,34,'9UC74008TK282483U','','Completed','','2007-11-13 19:27:25'),(35,35,'7MK0241213678870X','','Completed','','2007-11-16 14:28:49'),(36,36,'5M3871526A092273U','','Completed','','2007-11-16 22:10:17'),(37,37,'4W088202DD566312J','','Completed','','2007-11-16 23:29:31'),(38,38,'230147530N7816446','','Completed','','2007-11-21 23:05:25'),(39,39,'0J808948342207845','','Completed','','2007-12-01 19:03:55'),(40,40,'8P067384671843111','','Completed','','2007-12-08 16:30:23'),(41,41,'97304876B2288823G','','Completed','','2008-01-27 12:50:05'),(42,42,'9WE89088R86144255','','Completed','','2008-02-12 10:52:47'),(43,43,'3DV98800MM1000529','','Pending','echeck','2008-02-19 23:58:01'),(44,44,'8E4743901L7645649','','Completed','','2008-02-24 15:50:07'),(45,45,'82R57524XH649625G','','Completed','','2008-04-03 14:40:41'),(46,46,'3PD69125B2987690G','','Completed','','2008-04-14 23:32:06'),(47,47,'878926976B2697626','','Completed','','2008-04-17 11:39:30'),(48,48,'6KK58663VF4403138','','Completed','','2008-04-21 16:38:05'),(49,49,'5B874272388706101','','Pending','echeck','2008-04-22 17:46:09'),(50,50,'6RG48801VU3694214','','Completed','','2008-04-24 11:59:31'),(51,51,'1MK117354T399852G','','Completed','','2008-05-01 16:19:01'),(52,52,'8EG19214E7428925B','','Completed','','2008-05-13 19:31:22'),(53,53,'9LG88424UN890501T','','Pending','echeck','2008-06-12 00:22:34'),(54,54,'84D435649S7501718','','Completed','','2008-07-18 13:56:24'),(55,55,'11R99200WK0517134','','Completed','','2008-08-13 14:31:44'),(56,56,'64451613YF386551D','','Completed','','2008-09-07 14:23:37'),(57,57,'8GJ14907A55270542','','Completed','','2008-09-18 16:09:59'),(58,58,'43P60134J29064119','','Completed','','2008-10-10 15:09:53'),(59,59,'2YK74786WT231540W','','Completed','','2009-01-07 13:17:36'),(60,60,'47093425A1682443L','','Completed','','2009-01-11 00:51:43'),(61,61,'8ME67549VL2079358','','Completed','','2009-01-29 22:26:01');

--
-- Table structure for table `product_music_extra`
--

CREATE TABLE `product_music_extra` (
  `products_id` int(11) NOT NULL default '0',
  `artists_id` int(11) NOT NULL default '0',
  `record_company_id` int(11) NOT NULL default '0',
  `music_genre_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`products_id`),
  KEY `idx_music_genre_id_zen` (`music_genre_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_music_extra`
--


--
-- Table structure for table `product_type_layout`
--

CREATE TABLE `product_type_layout` (
  `configuration_id` int(11) NOT NULL auto_increment,
  `configuration_title` text NOT NULL,
  `configuration_key` varchar(255) NOT NULL default '',
  `configuration_value` text NOT NULL,
  `configuration_description` text NOT NULL,
  `product_type_id` int(11) NOT NULL default '0',
  `sort_order` int(5) default NULL,
  `last_modified` datetime default NULL,
  `date_added` datetime NOT NULL default '0001-01-01 00:00:00',
  `use_function` text,
  `set_function` text,
  PRIMARY KEY  (`configuration_id`),
  UNIQUE KEY `unq_config_key_zen` (`configuration_key`),
  KEY `idx_key_value_zen` (`configuration_key`,`configuration_value`(10))
) ENGINE=MyISAM AUTO_INCREMENT=99 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_type_layout`
--

INSERT INTO `product_type_layout` VALUES (1,'Show Model Number','SHOW_PRODUCT_INFO_MODEL','1','Display Model Number on Product Info 0= off 1= on',1,1,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(2,'Show Weight','SHOW_PRODUCT_INFO_WEIGHT','1','Display Weight on Product Info 0= off 1= on',1,2,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(3,'Show Attribute Weight','SHOW_PRODUCT_INFO_WEIGHT_ATTRIBUTES','1','Display Attribute Weight on Product Info 0= off 1= on',1,3,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(4,'Show Manufacturer','SHOW_PRODUCT_INFO_MANUFACTURER','1','Display Manufacturer Name on Product Info 0= off 1= on',1,4,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(5,'Show Quantity in Shopping Cart','SHOW_PRODUCT_INFO_IN_CART_QTY','1','Display Quantity in Current Shopping Cart on Product Info 0= off 1= on',1,5,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(6,'Show Quantity in Stock','SHOW_PRODUCT_INFO_QUANTITY','1','Display Quantity in Stock on Product Info 0= off 1= on',1,6,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(7,'Show Product Reviews Count','SHOW_PRODUCT_INFO_REVIEWS_COUNT','1','Display Product Reviews Count on Product Info 0= off 1= on',1,7,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(8,'Show Product Reviews Button','SHOW_PRODUCT_INFO_REVIEWS','1','Display Product Reviews Button on Product Info 0= off 1= on',1,8,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(9,'Show Date Available','SHOW_PRODUCT_INFO_DATE_AVAILABLE','1','Display Date Available on Product Info 0= off 1= on',1,9,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(10,'Show Date Added','SHOW_PRODUCT_INFO_DATE_ADDED','1','Display Date Added on Product Info 0= off 1= on',1,10,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(11,'Show Product URL','SHOW_PRODUCT_INFO_URL','1','Display URL on Product Info 0= off 1= on',1,11,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(12,'Show Starting At text on Price','SHOW_PRODUCT_INFO_STARTING_AT','1','Display Starting At text on products with attributes Product Info 0= off 1= on',1,12,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(13,'Show Product Tell a Friend button','SHOW_PRODUCT_INFO_TELL_A_FRIEND','1','Display the Tell a Friend button on Product Info<br /><br />Note: Turning this setting off does not affect the Tell a Friend box in the columns and turning off the Tell a Friend box does not affect the button<br />0= off 1= on',1,15,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(14,'Product Free Shipping Image Status - Catalog','SHOW_PRODUCT_INFO_ALWAYS_FREE_SHIPPING_IMAGE_SWITCH','0','Show the Free Shipping image/text in the catalog?',1,16,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(15,'Product Price Tax Class Default - When adding new products?','DEFAULT_PRODUCT_TAX_CLASS_ID','0','What should the Product Price Tax Class Default ID be when adding new products?',1,100,NULL,'2005-09-20 18:35:50','',''),(16,'Product Virtual Default Status - Skip Shipping Address - When adding new products?','DEFAULT_PRODUCT_PRODUCTS_VIRTUAL','0','Default Virtual Product status to be ON when adding new products?',1,101,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(17,'Product Free Shipping Default Status - Normal Shipping Rules - When adding new products?','DEFAULT_PRODUCT_PRODUCTS_IS_ALWAYS_FREE_SHIPPING','0','What should the Default Free Shipping status be when adding new products?',1,102,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(18,'Show Model Number','SHOW_PRODUCT_MUSIC_INFO_MODEL','1','Display Model Number on Product Info 0= off 1= on',2,1,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(19,'Show Weight','SHOW_PRODUCT_MUSIC_INFO_WEIGHT','0','Display Weight on Product Info 0= off 1= on',2,2,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(20,'Show Attribute Weight','SHOW_PRODUCT_MUSIC_INFO_WEIGHT_ATTRIBUTES','1','Display Attribute Weight on Product Info 0= off 1= on',2,3,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(21,'Show Artist','SHOW_PRODUCT_MUSIC_INFO_ARTIST','1','Display Artists Name on Product Info 0= off 1= on',2,4,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(22,'Show Music Genre','SHOW_PRODUCT_MUSIC_INFO_GENRE','1','Display Music Genre on Product Info 0= off 1= on',2,4,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(23,'Show Record Company','SHOW_PRODUCT_MUSIC_INFO_RECORD_COMPANY','1','Display Recoprd Company on Product Info 0= off 1= on',2,4,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(24,'Show Quantity in Shopping Cart','SHOW_PRODUCT_MUSIC_INFO_IN_CART_QTY','1','Display Quantity in Current Shopping Cart on Product Info 0= off 1= on',2,5,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(25,'Show Quantity in Stock','SHOW_PRODUCT_MUSIC_INFO_QUANTITY','0','Display Quantity in Stock on Product Info 0= off 1= on',2,6,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(26,'Show Product Reviews Count','SHOW_PRODUCT_MUSIC_INFO_REVIEWS_COUNT','1','Display Product Reviews Count on Product Info 0= off 1= on',2,7,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(27,'Show Product Reviews Button','SHOW_PRODUCT_MUSIC_INFO_REVIEWS','1','Display Product Reviews Button on Product Info 0= off 1= on',2,8,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(28,'Show Date Available','SHOW_PRODUCT_MUSIC_INFO_DATE_AVAILABLE','1','Display Date Available on Product Info 0= off 1= on',2,9,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(29,'Show Date Added','SHOW_PRODUCT_MUSIC_INFO_DATE_ADDED','1','Display Date Added on Product Info 0= off 1= on',2,10,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(30,'Show Starting At text on Price','SHOW_PRODUCT_MUSIC_INFO_STARTING_AT','1','Display Starting At text on products with attributes Product Info 0= off 1= on',2,12,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(31,'Show Product Tell a Friend button','SHOW_PRODUCT_MUSIC_INFO_TELL_A_FRIEND','1','Display the Tell a Friend button on Product Info<br /><br />Note: Turning this setting off does not affect the Tell a Friend box in the columns and turning off the Tell a Friend box does not affect the button<br />0= off 1= on',2,15,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(32,'Product Free Shipping Image Status - Catalog','SHOW_PRODUCT_MUSIC_INFO_ALWAYS_FREE_SHIPPING_IMAGE_SWITCH','0','Show the Free Shipping image/text in the catalog?',2,16,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(33,'Product Price Tax Class Default - When adding new products?','DEFAULT_PRODUCT_MUSIC_TAX_CLASS_ID','0','What should the Product Price Tax Class Default ID be when adding new products?',2,100,NULL,'2005-09-20 18:35:50','',''),(34,'Product Virtual Default Status - Skip Shipping Address - When adding new products?','DEFAULT_PRODUCT_MUSIC_PRODUCTS_VIRTUAL','0','Default Virtual Product status to be ON when adding new products?',2,101,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(35,'Product Free Shipping Default Status - Normal Shipping Rules - When adding new products?','DEFAULT_PRODUCT_MUSIC_PRODUCTS_IS_ALWAYS_FREE_SHIPPING','0','What should the Default Free Shipping status be when adding new products?',2,102,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(36,'Show Product Reviews Count','SHOW_DOCUMENT_GENERAL_INFO_REVIEWS_COUNT','1','Display Product Reviews Count on Product Info 0= off 1= on',3,7,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(37,'Show Product Reviews Button','SHOW_DOCUMENT_GENERAL_INFO_REVIEWS','1','Display Product Reviews Button on Product Info 0= off 1= on',3,8,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(38,'Show Date Available','SHOW_DOCUMENT_GENERAL_INFO_DATE_AVAILABLE','1','Display Date Available on Product Info 0= off 1= on',3,9,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(39,'Show Date Added','SHOW_DOCUMENT_GENERAL_INFO_DATE_ADDED','1','Display Date Added on Product Info 0= off 1= on',3,10,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(40,'Show Product Tell a Friend button','SHOW_DOCUMENT_GENERAL_INFO_TELL_A_FRIEND','1','Display the Tell a Friend button on Product Info<br /><br />Note: Turning this setting off does not affect the Tell a Friend box in the columns and turning off the Tell a Friend box does not affect the button<br />0= off 1= on',3,15,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(41,'Show Product URL','SHOW_DOCUMENT_GENERAL_INFO_URL','1','Display URL on Product Info 0= off 1= on',3,11,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(42,'Show Model Number','SHOW_DOCUMENT_PRODUCT_INFO_MODEL','1','Display Model Number on Product Info 0= off 1= on',4,1,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(43,'Show Weight','SHOW_DOCUMENT_PRODUCT_INFO_WEIGHT','0','Display Weight on Product Info 0= off 1= on',4,2,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(44,'Show Attribute Weight','SHOW_DOCUMENT_PRODUCT_INFO_WEIGHT_ATTRIBUTES','1','Display Attribute Weight on Product Info 0= off 1= on',4,3,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(45,'Show Manufacturer','SHOW_DOCUMENT_PRODUCT_INFO_MANUFACTURER','1','Display Manufacturer Name on Product Info 0= off 1= on',4,4,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(46,'Show Quantity in Shopping Cart','SHOW_DOCUMENT_PRODUCT_INFO_IN_CART_QTY','1','Display Quantity in Current Shopping Cart on Product Info 0= off 1= on',4,5,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(47,'Show Quantity in Stock','SHOW_DOCUMENT_PRODUCT_INFO_QUANTITY','0','Display Quantity in Stock on Product Info 0= off 1= on',4,6,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(48,'Show Product Reviews Count','SHOW_DOCUMENT_PRODUCT_INFO_REVIEWS_COUNT','1','Display Product Reviews Count on Product Info 0= off 1= on',4,7,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(49,'Show Product Reviews Button','SHOW_DOCUMENT_PRODUCT_INFO_REVIEWS','1','Display Product Reviews Button on Product Info 0= off 1= on',4,8,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(50,'Show Date Available','SHOW_DOCUMENT_PRODUCT_INFO_DATE_AVAILABLE','1','Display Date Available on Product Info 0= off 1= on',4,9,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(51,'Show Date Added','SHOW_DOCUMENT_PRODUCT_INFO_DATE_ADDED','1','Display Date Added on Product Info 0= off 1= on',4,10,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(52,'Show Product URL','SHOW_DOCUMENT_PRODUCT_INFO_URL','1','Display URL on Product Info 0= off 1= on',4,11,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(53,'Show Starting At text on Price','SHOW_DOCUMENT_PRODUCT_INFO_STARTING_AT','1','Display Starting At text on products with attributes Product Info 0= off 1= on',4,12,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(54,'Show Product Tell a Friend button','SHOW_DOCUMENT_PRODUCT_INFO_TELL_A_FRIEND','1','Display the Tell a Friend button on Product Info<br /><br />Note: Turning this setting off does not affect the Tell a Friend box in the columns and turning off the Tell a Friend box does not affect the button<br />0= off 1= on',4,15,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(55,'Product Free Shipping Image Status - Catalog','SHOW_DOCUMENT_PRODUCT_INFO_ALWAYS_FREE_SHIPPING_IMAGE_SWITCH','0','Show the Free Shipping image/text in the catalog?',4,16,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(56,'Product Price Tax Class Default - When adding new products?','DEFAULT_DOCUMENT_PRODUCT_TAX_CLASS_ID','0','What should the Product Price Tax Class Default ID be when adding new products?',4,100,NULL,'2005-09-20 18:35:50','',''),(57,'Product Virtual Default Status - Skip Shipping Address - When adding new products?','DEFAULT_DOCUMENT_PRODUCT_PRODUCTS_VIRTUAL','0','Default Virtual Product status to be ON when adding new products?',4,101,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(58,'Product Free Shipping Default Status - Normal Shipping Rules - When adding new products?','DEFAULT_DOCUMENT_PRODUCT_PRODUCTS_IS_ALWAYS_FREE_SHIPPING','0','What should the Default Free Shipping status be when adding new products?',4,102,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(59,'Show Model Number','SHOW_PRODUCT_FREE_SHIPPING_INFO_MODEL','1','Display Model Number on Product Info 0= off 1= on',5,1,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(60,'Show Weight','SHOW_PRODUCT_FREE_SHIPPING_INFO_WEIGHT','0','Display Weight on Product Info 0= off 1= on',5,2,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(61,'Show Attribute Weight','SHOW_PRODUCT_FREE_SHIPPING_INFO_WEIGHT_ATTRIBUTES','1','Display Attribute Weight on Product Info 0= off 1= on',5,3,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(62,'Show Manufacturer','SHOW_PRODUCT_FREE_SHIPPING_INFO_MANUFACTURER','1','Display Manufacturer Name on Product Info 0= off 1= on',5,4,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(63,'Show Quantity in Shopping Cart','SHOW_PRODUCT_FREE_SHIPPING_INFO_IN_CART_QTY','1','Display Quantity in Current Shopping Cart on Product Info 0= off 1= on',5,5,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(64,'Show Quantity in Stock','SHOW_PRODUCT_FREE_SHIPPING_INFO_QUANTITY','1','Display Quantity in Stock on Product Info 0= off 1= on',5,6,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(65,'Show Product Reviews Count','SHOW_PRODUCT_FREE_SHIPPING_INFO_REVIEWS_COUNT','1','Display Product Reviews Count on Product Info 0= off 1= on',5,7,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(66,'Show Product Reviews Button','SHOW_PRODUCT_FREE_SHIPPING_INFO_REVIEWS','1','Display Product Reviews Button on Product Info 0= off 1= on',5,8,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(67,'Show Date Available','SHOW_PRODUCT_FREE_SHIPPING_INFO_DATE_AVAILABLE','0','Display Date Available on Product Info 0= off 1= on',5,9,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(68,'Show Date Added','SHOW_PRODUCT_FREE_SHIPPING_INFO_DATE_ADDED','1','Display Date Added on Product Info 0= off 1= on',5,10,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(69,'Show Product URL','SHOW_PRODUCT_FREE_SHIPPING_INFO_URL','1','Display URL on Product Info 0= off 1= on',5,11,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(70,'Show Starting At text on Price','SHOW_PRODUCT_FREE_SHIPPING_INFO_STARTING_AT','1','Display Starting At text on products with attributes Product Info 0= off 1= on',5,12,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(71,'Show Product Tell a Friend button','SHOW_PRODUCT_FREE_SHIPPING_INFO_TELL_A_FRIEND','1','Display the Tell a Friend button on Product Info<br /><br />Note: Turning this setting off does not affect the Tell a Friend box in the columns and turning off the Tell a Friend box does not affect the button<br />0= off 1= on',5,15,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(72,'Product Free Shipping Image Status - Catalog','SHOW_PRODUCT_FREE_SHIPPING_INFO_ALWAYS_FREE_SHIPPING_IMAGE_SWITCH','1','Show the Free Shipping image/text in the catalog?',5,16,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(73,'Product Price Tax Class Default - When adding new products?','DEFAULT_PRODUCT_FREE_SHIPPING_TAX_CLASS_ID','0','What should the Product Price Tax Class Default ID be when adding new products?',5,100,NULL,'2005-09-20 18:35:50','',''),(74,'Product Virtual Default Status - Skip Shipping Address - When adding new products?','DEFAULT_PRODUCT_FREE_SHIPPING_PRODUCTS_VIRTUAL','0','Default Virtual Product status to be ON when adding new products?',5,101,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(75,'Product Free Shipping Default Status - Normal Shipping Rules - When adding new products?','DEFAULT_PRODUCT_FREE_SHIPPING_PRODUCTS_IS_ALWAYS_FREE_SHIPPING','1','What should the Default Free Shipping status be when adding new products?',5,102,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(76,'Show Metatags Title Default - Product Title','SHOW_PRODUCT_INFO_METATAGS_TITLE_STATUS','1','Display Product Title in Meta Tags Title 0= off 1= on',1,50,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(77,'Show Metatags Title Default - Product Name','SHOW_PRODUCT_INFO_METATAGS_PRODUCTS_NAME_STATUS','1','Display Product Name in Meta Tags Title 0= off 1= on',1,51,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(78,'Show Metatags Title Default - Product Model','SHOW_PRODUCT_INFO_METATAGS_MODEL_STATUS','1','Display Product Model in Meta Tags Title 0= off 1= on',1,52,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(79,'Show Metatags Title Default - Product Price','SHOW_PRODUCT_INFO_METATAGS_PRICE_STATUS','1','Display Product Price in Meta Tags Title 0= off 1= on',1,53,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(80,'Show Metatags Title Default - Product Tagline','SHOW_PRODUCT_INFO_METATAGS_TITLE_TAGLINE_STATUS','1','Display Product Tagline in Meta Tags Title 0= off 1= on',1,54,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(81,'Show Metatags Title Default - Product Title','SHOW_PRODUCT_MUSIC_INFO_METATAGS_TITLE_STATUS','1','Display Product Title in Meta Tags Title 0= off 1= on',2,50,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(82,'Show Metatags Title Default - Product Name','SHOW_PRODUCT_MUSIC_INFO_METATAGS_PRODUCTS_NAME_STATUS','1','Display Product Name in Meta Tags Title 0= off 1= on',2,51,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(83,'Show Metatags Title Default - Product Model','SHOW_PRODUCT_MUSIC_INFO_METATAGS_MODEL_STATUS','1','Display Product Model in Meta Tags Title 0= off 1= on',2,52,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(84,'Show Metatags Title Default - Product Price','SHOW_PRODUCT_MUSIC_INFO_METATAGS_PRICE_STATUS','1','Display Product Price in Meta Tags Title 0= off 1= on',2,53,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(85,'Show Metatags Title Default - Product Tagline','SHOW_PRODUCT_MUSIC_INFO_METATAGS_TITLE_TAGLINE_STATUS','1','Display Product Tagline in Meta Tags Title 0= off 1= on',2,54,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(86,'Show Metatags Title Default - Document Title','SHOW_DOCUMENT_GENERAL_INFO_METATAGS_TITLE_STATUS','1','Display Document Title in Meta Tags Title 0= off 1= on',3,50,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(87,'Show Metatags Title Default - Document Name','SHOW_DOCUMENT_GENERAL_INFO_METATAGS_PRODUCTS_NAME_STATUS','1','Display Document Name in Meta Tags Title 0= off 1= on',3,51,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(88,'Show Metatags Title Default - Document Tagline','SHOW_DOCUMENT_GENERAL_INFO_METATAGS_TITLE_TAGLINE_STATUS','1','Display Document Tagline in Meta Tags Title 0= off 1= on',3,54,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(89,'Show Metatags Title Default - Document Title','SHOW_DOCUMENT_PRODUCT_INFO_METATAGS_TITLE_STATUS','1','Display Document Title in Meta Tags Title 0= off 1= on',4,50,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(90,'Show Metatags Title Default - Document Name','SHOW_DOCUMENT_PRODUCT_INFO_METATAGS_PRODUCTS_NAME_STATUS','1','Display Document Name in Meta Tags Title 0= off 1= on',4,51,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(91,'Show Metatags Title Default - Document Model','SHOW_DOCUMENT_PRODUCT_INFO_METATAGS_MODEL_STATUS','1','Display Document Model in Meta Tags Title 0= off 1= on',4,52,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(92,'Show Metatags Title Default - Document Price','SHOW_DOCUMENT_PRODUCT_INFO_METATAGS_PRICE_STATUS','1','Display Document Price in Meta Tags Title 0= off 1= on',4,53,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(93,'Show Metatags Title Default - Document Tagline','SHOW_DOCUMENT_PRODUCT_INFO_METATAGS_TITLE_TAGLINE_STATUS','1','Display Document Tagline in Meta Tags Title 0= off 1= on',4,54,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(94,'Show Metatags Title Default - Product Title','SHOW_PRODUCT_FREE_SHIPPING_INFO_METATAGS_TITLE_STATUS','1','Display Product Title in Meta Tags Title 0= off 1= on',5,50,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(95,'Show Metatags Title Default - Product Name','SHOW_PRODUCT_FREE_SHIPPING_INFO_METATAGS_PRODUCTS_NAME_STATUS','1','Display Product Name in Meta Tags Title 0= off 1= on',5,51,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(96,'Show Metatags Title Default - Product Model','SHOW_PRODUCT_FREE_SHIPPING_INFO_METATAGS_MODEL_STATUS','1','Display Product Model in Meta Tags Title 0= off 1= on',5,52,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(97,'Show Metatags Title Default - Product Price','SHOW_PRODUCT_FREE_SHIPPING_INFO_METATAGS_PRICE_STATUS','1','Display Product Price in Meta Tags Title 0= off 1= on',5,53,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(98,'Show Metatags Title Default - Product Tagline','SHOW_PRODUCT_FREE_SHIPPING_INFO_METATAGS_TITLE_TAGLINE_STATUS','1','Display Product Tagline in Meta Tags Title 0= off 1= on',5,54,NULL,'2005-09-20 18:35:50',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), ');

--
-- Table structure for table `product_types`
--

CREATE TABLE `product_types` (
  `type_id` int(11) NOT NULL auto_increment,
  `type_name` varchar(255) NOT NULL default '',
  `type_handler` varchar(255) NOT NULL default '',
  `type_master_type` int(11) NOT NULL default '1',
  `allow_add_to_cart` char(1) NOT NULL default 'Y',
  `default_image` varchar(255) NOT NULL default '',
  `date_added` datetime NOT NULL default '0001-01-01 00:00:00',
  `last_modified` datetime NOT NULL default '0001-01-01 00:00:00',
  PRIMARY KEY  (`type_id`),
  KEY `idx_type_master_type_zen` (`type_master_type`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_types`
--

INSERT INTO `product_types` VALUES (1,'Product - General','product',1,'Y','','2005-09-20 18:35:50','2005-09-20 18:35:50'),(2,'Product - Music','product_music',1,'Y','','2005-09-20 18:35:50','2005-09-20 18:35:50'),(3,'Document - General','document_general',3,'N','','2005-09-20 18:35:50','2005-09-20 18:35:50'),(4,'Document - Product','document_product',3,'Y','','2005-09-20 18:35:50','2005-09-20 18:35:50'),(5,'Product - Free Shipping','product_free_shipping',1,'Y','','2005-09-20 18:35:50','2005-09-20 18:35:50');

--
-- Table structure for table `product_types_to_category`
--

CREATE TABLE `product_types_to_category` (
  `product_type_id` int(11) NOT NULL default '0',
  `category_id` int(11) NOT NULL default '0',
  KEY `idx_category_id_zen` (`category_id`),
  KEY `idx_product_type_id_zen` (`product_type_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_types_to_category`
--


--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `products_id` int(11) NOT NULL auto_increment,
  `products_type` int(11) NOT NULL default '1',
  `products_quantity` float NOT NULL default '0',
  `products_model` varchar(32) default NULL,
  `products_image` varchar(64) default NULL,
  `products_price` decimal(15,4) NOT NULL default '0.0000',
  `products_virtual` tinyint(1) NOT NULL default '0',
  `products_date_added` datetime NOT NULL default '0001-01-01 00:00:00',
  `products_last_modified` datetime default NULL,
  `products_date_available` datetime default NULL,
  `products_weight` float NOT NULL default '0',
  `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` float NOT NULL default '0',
  `products_quantity_order_min` float NOT NULL default '1',
  `products_quantity_order_units` float NOT NULL default '1',
  `products_priced_by_attribute` tinyint(1) NOT NULL default '0',
  `product_is_free` tinyint(1) NOT NULL default '0',
  `product_is_call` tinyint(1) NOT NULL default '0',
  `products_quantity_mixed` tinyint(1) NOT NULL default '0',
  `product_is_always_free_shipping` tinyint(1) NOT NULL default '0',
  `products_qty_box_status` tinyint(1) NOT NULL default '1',
  `products_quantity_order_max` float NOT NULL default '0',
  `products_sort_order` int(11) NOT NULL default '0',
  `products_discount_type` tinyint(1) NOT NULL default '0',
  `products_discount_type_from` tinyint(1) NOT NULL default '0',
  `products_price_sorter` decimal(15,4) NOT NULL default '0.0000',
  `master_categories_id` int(11) NOT NULL default '0',
  `products_mixed_discount_quantity` tinyint(1) NOT NULL default '1',
  `metatags_title_status` tinyint(1) NOT NULL default '0',
  `metatags_products_name_status` tinyint(1) NOT NULL default '0',
  `metatags_model_status` tinyint(1) NOT NULL default '0',
  `metatags_price_status` tinyint(1) NOT NULL default '0',
  `metatags_title_tagline_status` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`products_id`),
  KEY `idx_products_date_added_zen` (`products_date_added`),
  KEY `idx_products_status_zen` (`products_status`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

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

INSERT INTO `products` VALUES (1,1,9931,'','josie021.jpg','20.0000',0,'2005-09-20 19:17:46','2008-10-06 00:15:58',NULL,0.5,1,1,0,68,1,1,0,0,0,1,0,1,0,0,0,0,'20.0000',0,1,1,1,1,1,1),(2,1,9891,'','bullet.jpg','15.0000',0,'2005-09-20 20:06:54','2008-10-06 00:20:07',NULL,0,1,1,0,108,1,1,0,0,0,1,0,1,0,0,0,0,'15.0000',0,0,1,1,1,1,1),(3,1,9954,'','','12.0000',0,'2005-11-09 20:20:42','2008-10-06 00:16:38',NULL,0.2,1,1,0,45,1,1,0,0,0,1,0,1,0,0,0,0,'12.0000',0,1,1,1,1,1,1),(4,1,9915,'Package','','45.0000',0,'2005-11-10 15:31:47','2008-10-06 00:16:53',NULL,0.5,0,1,0,84,1,1,0,0,0,1,0,1,0,0,0,0,'45.0000',0,1,1,1,1,1,1),(5,1,9929,'Package','','25.0000',0,'2005-11-10 16:58:46','2008-10-06 00:16:16',NULL,0.5,1,1,0,70,1,1,0,0,0,1,0,1,0,0,0,0,'25.0000',0,0,1,1,1,1,1),(6,1,9940,'Package','','42.0000',0,'2005-11-10 17:19:13','2007-10-16 23:36:30',NULL,0,1,1,0,59,1,1,0,0,0,1,0,1,0,0,0,0,'42.0000',0,1,1,1,1,1,1),(7,1,9974,'Package','','30.0000',0,'2005-11-10 18:01:07','2007-10-14 11:54:28',NULL,0,1,1,0,25,1,1,0,0,0,1,0,1,0,0,0,0,'30.0000',0,1,1,1,1,1,1),(8,1,9999,'','','13.0000',0,'2008-10-06 00:14:29','2008-10-06 00:20:31',NULL,0.5,1,1,0,0,1,1,0,0,0,1,0,1,0,0,0,0,'13.0000',0,1,0,0,0,0,0),(9,1,9999,'','','15.0000',0,'2008-10-06 00:17:52',NULL,NULL,0.2,1,1,0,0,1,1,0,0,0,1,0,1,0,0,0,0,'15.0000',0,1,0,0,0,0,0),(10,1,9999,'','','20.0000',0,'2008-10-06 00:18:46','2008-10-06 00:19:55',NULL,0.3,1,1,0,1,1,1,0,0,0,1,0,1,0,0,0,0,'20.0000',0,1,0,0,0,0,0),(11,1,500,'','','20.0000',0,'2008-10-06 00:22:19',NULL,NULL,0.2,1,1,0,0,1,1,0,0,0,1,0,1,0,0,0,0,'20.0000',0,1,0,0,0,0,0);

--
-- Table structure for table `products_attributes`
--

CREATE TABLE `products_attributes` (
  `products_attributes_id` int(11) NOT NULL auto_increment,
  `products_id` int(11) NOT NULL default '0',
  `options_id` int(11) NOT NULL default '0',
  `options_values_id` int(11) NOT NULL default '0',
  `options_values_price` decimal(15,4) NOT NULL default '0.0000',
  `price_prefix` char(1) NOT NULL default '',
  `products_options_sort_order` int(11) NOT NULL default '0',
  `product_attribute_is_free` tinyint(1) NOT NULL default '0',
  `products_attributes_weight` float NOT NULL default '0',
  `products_attributes_weight_prefix` char(1) NOT NULL default '',
  `attributes_display_only` tinyint(1) NOT NULL default '0',
  `attributes_default` tinyint(1) NOT NULL default '0',
  `attributes_discounted` tinyint(1) NOT NULL default '1',
  `attributes_image` varchar(64) default NULL,
  `attributes_price_base_included` tinyint(1) NOT NULL default '1',
  `attributes_price_onetime` decimal(15,4) NOT NULL default '0.0000',
  `attributes_price_factor` decimal(15,4) NOT NULL default '0.0000',
  `attributes_price_factor_offset` decimal(15,4) NOT NULL default '0.0000',
  `attributes_price_factor_onetime` decimal(15,4) NOT NULL default '0.0000',
  `attributes_price_factor_onetime_offset` decimal(15,4) NOT NULL default '0.0000',
  `attributes_qty_prices` text,
  `attributes_qty_prices_onetime` text,
  `attributes_price_words` decimal(15,4) NOT NULL default '0.0000',
  `attributes_price_words_free` int(4) NOT NULL default '0',
  `attributes_price_letters` decimal(15,4) NOT NULL default '0.0000',
  `attributes_price_letters_free` int(4) NOT NULL default '0',
  `attributes_required` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`products_attributes_id`),
  KEY `idx_id_options_id_values_zen` (`products_id`,`options_id`,`options_values_id`)
) ENGINE=MyISAM AUTO_INCREMENT=72 DEFAULT CHARSET=latin1;

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

INSERT INTO `products_attributes` VALUES (1,1,1,1,'0.0000','+',0,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(2,1,1,2,'0.0000','+',0,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(16,2,2,9,'0.0000','+',70,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(11,2,2,4,'0.0000','+',20,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(12,2,2,5,'0.0000','+',30,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(13,2,2,6,'0.0000','+',40,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(14,2,2,7,'0.0000','+',50,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(15,2,2,8,'0.0000','+',60,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(10,2,2,3,'0.0000','+',10,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(17,4,1,1,'0.0000','+',110,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(18,4,1,2,'0.0000','+',120,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(19,4,2,3,'0.0000','+',211,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(20,4,2,4,'0.0000','+',221,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(21,4,2,5,'0.0000','+',231,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(22,4,2,6,'0.0000','+',241,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(23,4,2,7,'0.0000','+',251,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(24,4,2,8,'0.0000','+',261,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(25,4,2,9,'0.0000','+',271,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(26,5,2,3,'0.0000','+',110,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(27,5,2,4,'0.0000','+',120,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(28,5,2,5,'0.0000','+',130,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(29,5,2,6,'0.0000','+',140,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(30,5,2,7,'0.0000','+',150,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(31,5,2,8,'0.0000','+',160,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(32,5,2,9,'0.0000','+',170,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(33,5,3,10,'0.0000','+',510,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(34,5,3,11,'0.0000','+',520,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(35,5,3,12,'0.0000','+',530,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(36,5,3,13,'0.0000','+',540,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(37,5,3,14,'0.0000','+',550,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(38,5,3,16,'0.0000','+',560,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(39,5,3,15,'0.0000','+',570,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(40,6,1,1,'0.0000','+',110,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(41,6,1,2,'0.0000','+',120,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(42,6,2,3,'0.0000','+',211,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(43,6,2,4,'0.0000','+',221,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(44,6,2,5,'0.0000','+',231,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(45,6,2,6,'0.0000','+',241,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(46,6,2,7,'0.0000','+',251,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(47,6,2,8,'0.0000','+',261,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(48,6,2,9,'0.0000','+',271,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(49,6,4,17,'0.0000','+',310,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(51,2,2,19,'0.0000','+',0,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(52,2,2,21,'0.0000','+',0,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(53,2,2,20,'0.0000','+',0,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(54,5,2,21,'0.0000','+',100,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(55,5,2,20,'0.0000','+',90,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(56,5,2,19,'0.0000','+',80,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(57,5,3,22,'0.0000','+',480,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(58,5,3,24,'0.0000','+',500,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(59,5,3,23,'0.0000','+',490,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(60,6,2,19,'0.0000','+',201,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(61,6,2,21,'0.0000','+',191,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(62,6,2,20,'0.0000','+',181,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(63,4,2,19,'0.0000','+',181,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(64,4,2,21,'0.0000','+',201,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(65,4,2,20,'0.0000','+',191,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(66,10,8,39,'0.0000','+',0,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(67,10,8,40,'0.0000','+',0,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(68,10,8,41,'0.0000','+',0,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(69,10,8,42,'0.0000','+',0,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(70,10,8,43,'0.0000','+',0,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0),(71,2,8,40,'0.0000','+',0,0,0,'+',0,0,1,'',1,'0.0000','0.0000','0.0000','0.0000','0.0000','','','0.0000',0,'0.0000',0,0);

--
-- Table structure for table `products_attributes_download`
--

CREATE TABLE `products_attributes_download` (
  `products_attributes_id` int(11) NOT NULL default '0',
  `products_attributes_filename` varchar(255) NOT NULL default '',
  `products_attributes_maxdays` int(2) default '0',
  `products_attributes_maxcount` int(2) default '0',
  PRIMARY KEY  (`products_attributes_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


--
-- Table structure for table `products_description`
--

CREATE TABLE `products_description` (
  `products_id` int(11) NOT NULL auto_increment,
  `language_id` int(11) NOT NULL default '1',
  `products_name` varchar(64) NOT NULL default '',
  `products_description` text,
  `products_url` varchar(255) default NULL,
  `products_viewed` int(5) default '0',
  PRIMARY KEY  (`products_id`,`language_id`),
  KEY `idx_products_name_zen` (`products_name`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

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

INSERT INTO `products_description` VALUES (1,1,'TITAN: refillable lipstick','','',2513),(2,1,'Bullet: TITAN lipstick refills','','',2480),(3,1,'platinum: lip gloss | plumper','','',2616),(4,1,'TITAN & bullet combo','','',2398),(5,1,'double barrel','','',3174),(6,1,'full monty: full lip treatment 3 pack','','',2312),(7,1,'mojo unisex: titanium grey TITAN and lip therapy','','',2313),(8,1,'mojo nail lacquer','','',0),(9,1,'TITAN: silver pearls','','',0),(10,1,'Bullet:  TITAN concealer refills','','',0),(11,1,'pods: cream based eye shadows','','',0);

--
-- Table structure for table `products_discount_quantity`
--

CREATE TABLE `products_discount_quantity` (
  `discount_id` int(4) NOT NULL default '0',
  `products_id` int(11) NOT NULL default '0',
  `discount_qty` float NOT NULL default '0',
  `discount_price` decimal(15,4) NOT NULL default '0.0000',
  KEY `idx_id_qty_zen` (`products_id`,`discount_qty`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `products_discount_quantity`
--


--
-- Table structure for table `products_notifications`
--

CREATE TABLE `products_notifications` (
  `products_id` int(11) NOT NULL default '0',
  `customers_id` int(11) NOT NULL default '0',
  `date_added` datetime NOT NULL default '0001-01-01 00:00:00',
  PRIMARY KEY  (`products_id`,`customers_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `products_notifications` VALUES (0,10,'2005-12-04 11:51:55'),(0,17,'2006-01-08 14:36:06'),(0,35,'2006-02-17 16:15:01'),(0,41,'2006-02-18 17:05:33'),(0,19,'2006-02-20 23:42:56'),(0,49,'2006-03-02 09:56:26'),(0,52,'2006-03-04 11:12:30'),(0,54,'2006-03-12 20:28:07'),(0,60,'2006-04-16 03:10:32'),(0,65,'2006-05-04 17:01:36'),(0,61,'2006-05-28 00:19:50'),(0,70,'2006-05-29 18:45:55'),(0,73,'2006-06-18 04:21:57'),(0,82,'2006-08-07 03:22:22'),(0,91,'2006-09-10 07:13:04'),(0,72,'2006-09-15 17:57:21'),(0,114,'2006-10-22 00:37:51'),(0,158,'2006-11-03 08:53:25'),(0,163,'2006-11-10 10:35:41'),(0,180,'2006-12-11 08:09:15'),(0,181,'2006-12-12 19:14:51'),(0,160,'2007-02-14 17:40:47'),(0,203,'2007-03-12 07:38:10'),(0,155,'2007-03-17 11:42:43'),(0,206,'2007-03-27 12:48:37'),(0,207,'2007-03-28 09:18:08'),(0,209,'2007-04-23 09:27:09'),(0,212,'2007-05-08 15:40:11'),(0,230,'2007-08-01 17:38:22'),(0,260,'2007-10-13 11:20:13'),(0,268,'2007-11-13 19:27:58'),(0,277,'2007-11-20 18:04:33'),(0,282,'2007-12-02 21:15:29'),(0,295,'2008-02-02 18:00:48'),(0,309,'2008-04-14 23:32:54'),(0,323,'2008-04-23 09:51:29'),(0,324,'2008-04-24 19:01:44'),(0,327,'2008-05-02 12:54:20'),(0,330,'2008-05-11 18:40:24'),(0,331,'2008-05-12 19:20:36'),(0,278,'2008-05-15 19:54:00'),(0,356,'2008-10-10 15:10:35'),(0,360,'2008-12-25 01:47:11');

--
-- Table structure for table `products_options`
--

CREATE TABLE `products_options` (
  `products_options_id` int(11) NOT NULL default '0',
  `language_id` int(11) NOT NULL default '1',
  `products_options_name` varchar(32) NOT NULL default '',
  `products_options_sort_order` int(11) NOT NULL default '0',
  `products_options_type` int(5) NOT NULL default '0',
  `products_options_length` smallint(2) NOT NULL default '32',
  `products_options_comment` varchar(64) default NULL,
  `products_options_size` smallint(2) NOT NULL default '32',
  `products_options_images_per_row` int(2) default '5',
  `products_options_images_style` int(1) default '0',
  PRIMARY KEY  (`products_options_id`,`language_id`),
  KEY `idx_lang_id_zen` (`language_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `products_options` VALUES (1,1,'titan',10,0,32,'',32,0,0),(2,1,'bullet',20,0,32,'',32,0,0),(3,1,'bullet 2',25,0,32,'',32,0,0),(4,1,'platinum',30,0,32,'',32,0,0),(5,1,'lacquer',40,0,32,NULL,32,0,0),(6,1,'silver pearls',50,0,32,NULL,32,0,0),(7,1,'pod',60,0,32,NULL,32,0,0),(8,1,'concealer',70,0,32,NULL,32,0,0);

--
-- Table structure for table `products_options_types`
--

CREATE TABLE `products_options_types` (
  `products_options_types_id` int(11) NOT NULL default '0',
  `products_options_types_name` varchar(32) default NULL,
  PRIMARY KEY  (`products_options_types_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Track products_options_types';

--
-- Dumping data for table `products_options_types`
--

INSERT INTO `products_options_types` VALUES (0,'Dropdown'),(1,'Text'),(2,'Radio'),(3,'Checkbox'),(4,'File'),(5,'Read Only');

--
-- Table structure for table `products_options_values`
--

CREATE TABLE `products_options_values` (
  `products_options_values_id` int(11) NOT NULL default '0',
  `language_id` int(11) NOT NULL default '1',
  `products_options_values_name` varchar(64) NOT NULL default '',
  `products_options_values_sort_order` int(11) NOT NULL default '0',
  PRIMARY KEY  (`products_options_values_id`,`language_id`),
  KEY `idx_prod_opt_val_id_zen` (`products_options_values_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `products_options_values` VALUES (0,1,'TEXT',0),(1,1,'titanium grey',1010),(2,1,'pink alloy',1020),(3,1,'mojo',11),(4,1,'dune',21),(5,1,'suede',31),(6,1,'pinup',41),(7,1,'conviction',51),(8,1,'diabolic',61),(9,1,'delusion',71),(10,1,'mojo',510),(11,1,'dune',520),(12,1,'suede',530),(13,1,'pinup',540),(14,1,'conviction',550),(15,1,'delusion',570),(16,1,'diabolic',560),(17,1,'lip gloss | plumper',0),(22,1,'NEW caliber',480),(19,1,'NEW caliber',81),(20,1,'NEW tirade',91),(21,1,'NEW dubai',101),(23,1,'NEW tirade',490),(24,1,'NEW dubai',500),(25,1,'conviction',10),(26,1,'delusion',20),(27,1,'dune',30),(28,1,'diabolic',40),(29,1,'suede',50),(30,1,'dubai',60),(31,1,'forbidden',70),(32,1,'platinum',80),(33,1,'pinup',90),(34,1,'dot dash',10),(35,1,'sphere',20),(36,1,'obsidian',10),(37,1,'blossom',20),(38,1,'vintage',30),(39,1,'1',10),(40,1,'2',20),(41,1,'3',30),(42,1,'4',40),(43,1,'5',50);

--
-- Table structure for table `products_options_values_to_products_options`
--

CREATE TABLE `products_options_values_to_products_options` (
  `products_options_values_to_products_options_id` int(11) NOT NULL auto_increment,
  `products_options_id` int(11) NOT NULL default '0',
  `products_options_values_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`products_options_values_to_products_options_id`)
) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=latin1;

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

INSERT INTO `products_options_values_to_products_options` VALUES (1,1,1),(2,1,2),(3,2,3),(4,2,4),(5,2,5),(6,2,6),(7,2,7),(8,2,8),(9,2,9),(11,3,10),(12,3,11),(13,3,12),(14,3,13),(15,3,14),(16,3,15),(17,3,16),(18,4,17),(23,3,22),(20,2,19),(21,2,20),(22,2,21),(24,3,23),(25,3,24),(26,5,25),(27,5,26),(28,5,27),(29,5,28),(30,5,29),(31,5,30),(32,5,31),(33,5,32),(34,5,33),(35,6,34),(36,6,35),(37,7,36),(38,7,37),(39,7,38),(40,8,39),(41,8,40),(42,8,41),(43,8,42),(44,8,43);

--
-- Table structure for table `products_to_categories`
--

CREATE TABLE `products_to_categories` (
  `products_id` int(11) NOT NULL default '0',
  `categories_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`products_id`,`categories_id`),
  KEY `idx_cat_prod_id_zen` (`categories_id`,`products_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `products_to_categories` VALUES (1,0),(2,0),(3,0),(4,0),(5,0),(6,0),(7,0),(8,0),(9,0),(10,0),(11,0);

--
-- Table structure for table `project_version`
--

CREATE TABLE `project_version` (
  `project_version_id` tinyint(3) NOT NULL auto_increment,
  `project_version_key` varchar(40) NOT NULL default '',
  `project_version_major` varchar(20) NOT NULL default '',
  `project_version_minor` varchar(20) NOT NULL default '',
  `project_version_patch1` varchar(20) NOT NULL default '',
  `project_version_patch2` varchar(20) NOT NULL default '',
  `project_version_patch1_source` varchar(20) NOT NULL default '',
  `project_version_patch2_source` varchar(20) NOT NULL default '',
  `project_version_comment` varchar(250) NOT NULL default '',
  `project_version_date_applied` datetime NOT NULL default '0001-01-01 01:01:01',
  PRIMARY KEY  (`project_version_id`),
  UNIQUE KEY `idx_project_version_key_zen` (`project_version_key`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COMMENT='Database Version Tracking';

--
-- Dumping data for table `project_version`
--

INSERT INTO `project_version` VALUES (1,'Zen-Cart Main','1','2.6','','','','','Fresh Installation','2005-09-20 18:35:50'),(2,'Zen-Cart Database','1','2.6','','','','','Fresh Installation','2005-09-20 18:35:50');

--
-- Table structure for table `project_version_history`
--

CREATE TABLE `project_version_history` (
  `project_version_id` tinyint(3) NOT NULL auto_increment,
  `project_version_key` varchar(40) NOT NULL default '',
  `project_version_major` varchar(20) NOT NULL default '',
  `project_version_minor` varchar(20) NOT NULL default '',
  `project_version_patch` varchar(20) NOT NULL default '',
  `project_version_comment` varchar(250) NOT NULL default '',
  `project_version_date_applied` datetime NOT NULL default '0001-01-01 01:01:01',
  PRIMARY KEY  (`project_version_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COMMENT='Database Version Tracking History';

--
-- Dumping data for table `project_version_history`
--

INSERT INTO `project_version_history` VALUES (1,'Zen-Cart Main','1','2.6','','Fresh Installation','2005-09-20 18:35:50'),(2,'Zen-Cart Database','1','2.6','','Fresh Installation','2005-09-20 18:35:50');

--
-- Table structure for table `query_builder`
--

CREATE TABLE `query_builder` (
  `query_id` int(11) NOT NULL auto_increment,
  `query_category` varchar(40) NOT NULL default '',
  `query_name` varchar(80) NOT NULL default '',
  `query_description` text NOT NULL,
  `query_string` text NOT NULL,
  `query_keys_list` text NOT NULL,
  PRIMARY KEY  (`query_id`),
  UNIQUE KEY `query_name` (`query_name`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COMMENT='Stores queries for re-use in Admin email and report modules';

--
-- Dumping data for table `query_builder`
--

INSERT INTO `query_builder` VALUES (1,'email','All Customers','Returns all customers name and email address for sending mass emails (ie: for newsletters, coupons, GV\'s, messages, etc).','select customers_email_address, customers_firstname, customers_lastname from TABLE_CUSTOMERS order by customers_lastname, customers_firstname, customers_email_address',''),(2,'email,newsletters','All Newsletter Subscribers','Returns name and email address of newsletter subscribers','select customers_firstname, customers_lastname, customers_email_address from TABLE_CUSTOMERS where customers_newsletter = \'1\'',''),(3,'email,newsletters','Dormant Customers (>3months) (Subscribers)','Subscribers who HAVE purchased something, but have NOT purchased for at least three months.','select c.customers_email_address, c.customers_lastname, c.customers_firstname from TABLE_CUSTOMERS c, TABLE_ORDERS o where c.customers_newsletter = \'1\' AND c.customers_id = o.customers_id and o.date_purchased < subdate(now(),INTERVAL 3 MONTH) GROUP BY c.customers_email_address order by c.customers_lastname, c.customers_firstname ASC',''),(4,'email,newsletters','Active customers in past 3 months (Subscribers)','Newsletter subscribers who are also active customers (purchased something) in last 3 months.','select c.customers_email_address, c.customers_lastname, c.customers_firstname from TABLE_CUSTOMERS c, TABLE_ORDERS o where c.customers_newsletter = \'1\' AND c.customers_id = o.customers_id and o.date_purchased > subdate(now(),INTERVAL 3 MONTH) GROUP BY c.customers_email_address order by c.customers_lastname, c.customers_firstname ASC',''),(5,'email,newsletters','Active customers in past 3 months (Regardless of subscription status)','All active customers (purchased something) in last 3 months, ignoring newsletter-subscription status.','select c.customers_email_address, c.customers_lastname, c.customers_firstname from TABLE_CUSTOMERS c, TABLE_ORDERS o WHERE c.customers_id = o.customers_id and o.date_purchased > subdate(now(),INTERVAL 3 MONTH) GROUP BY c.customers_email_address order by c.customers_lastname, c.customers_firstname ASC','');

--
-- Table structure for table `record_artists`
--

CREATE TABLE `record_artists` (
  `artists_id` int(11) NOT NULL auto_increment,
  `artists_name` varchar(32) NOT NULL default '',
  `artists_image` varchar(64) default NULL,
  `date_added` datetime default NULL,
  `last_modified` datetime default NULL,
  PRIMARY KEY  (`artists_id`),
  KEY `idx_rec_artists_name_zen` (`artists_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `record_artists`
--


--
-- Table structure for table `record_artists_info`
--

CREATE TABLE `record_artists_info` (
  `artists_id` int(11) NOT NULL default '0',
  `languages_id` int(11) NOT NULL default '0',
  `artists_url` varchar(255) NOT NULL default '',
  `url_clicked` int(5) NOT NULL default '0',
  `date_last_click` datetime default NULL,
  PRIMARY KEY  (`artists_id`,`languages_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `record_artists_info`
--


--
-- Table structure for table `record_company`
--

CREATE TABLE `record_company` (
  `record_company_id` int(11) NOT NULL auto_increment,
  `record_company_name` varchar(32) NOT NULL default '',
  `record_company_image` varchar(64) default NULL,
  `date_added` datetime default NULL,
  `last_modified` datetime default NULL,
  PRIMARY KEY  (`record_company_id`),
  KEY `idx_rec_company_name_zen` (`record_company_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `record_company`
--


--
-- Table structure for table `record_company_info`
--

CREATE TABLE `record_company_info` (
  `record_company_id` int(11) NOT NULL default '0',
  `languages_id` int(11) NOT NULL default '0',
  `record_company_url` varchar(255) NOT NULL default '',
  `url_clicked` int(5) NOT NULL default '0',
  `date_last_click` datetime default NULL,
  PRIMARY KEY  (`record_company_id`,`languages_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `record_company_info`
--


--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `reviews_id` int(11) NOT NULL auto_increment,
  `products_id` int(11) NOT NULL default '0',
  `customers_id` int(11) default NULL,
  `customers_name` varchar(64) NOT NULL default '',
  `reviews_rating` int(1) default NULL,
  `date_added` datetime default NULL,
  `last_modified` datetime default NULL,
  `reviews_read` int(5) NOT NULL default '0',
  `status` int(1) NOT NULL default '1',
  PRIMARY KEY  (`reviews_id`),
  KEY `idx_products_id_zen` (`products_id`),
  KEY `idx_customers_id_zen` (`customers_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


--
-- Table structure for table `reviews_description`
--

CREATE TABLE `reviews_description` (
  `reviews_id` int(11) NOT NULL default '0',
  `languages_id` int(11) NOT NULL default '0',
  `reviews_text` text NOT NULL,
  PRIMARY KEY  (`reviews_id`,`languages_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


--
-- Table structure for table `salemaker_sales`
--

CREATE TABLE `salemaker_sales` (
  `sale_id` int(11) NOT NULL auto_increment,
  `sale_status` tinyint(4) NOT NULL default '0',
  `sale_name` varchar(30) NOT NULL default '',
  `sale_deduction_value` decimal(15,4) NOT NULL default '0.0000',
  `sale_deduction_type` tinyint(4) NOT NULL default '0',
  `sale_pricerange_from` decimal(15,4) NOT NULL default '0.0000',
  `sale_pricerange_to` decimal(15,4) NOT NULL default '0.0000',
  `sale_specials_condition` tinyint(4) NOT NULL default '0',
  `sale_categories_selected` text,
  `sale_categories_all` text,
  `sale_date_start` date NOT NULL default '0001-01-01',
  `sale_date_end` date NOT NULL default '0001-01-01',
  `sale_date_added` date NOT NULL default '0001-01-01',
  `sale_date_last_modified` date NOT NULL default '0001-01-01',
  `sale_date_status_change` date NOT NULL default '0001-01-01',
  PRIMARY KEY  (`sale_id`),
  KEY `idx_sale_status_zen` (`sale_status`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salemaker_sales`
--


--
-- Table structure for table `specials`
--

CREATE TABLE `specials` (
  `specials_id` int(11) NOT NULL auto_increment,
  `products_id` int(11) NOT NULL default '0',
  `specials_new_products_price` decimal(15,4) NOT NULL default '0.0000',
  `specials_date_added` datetime default NULL,
  `specials_last_modified` datetime default NULL,
  `expires_date` date NOT NULL default '0001-01-01',
  `date_status_change` datetime default NULL,
  `status` int(1) NOT NULL default '1',
  `specials_date_available` date NOT NULL default '0001-01-01',
  PRIMARY KEY  (`specials_id`),
  KEY `idx_status_zen` (`status`),
  KEY `idx_products_id_zen` (`products_id`),
  KEY `idx_date_avail_zen` (`specials_date_available`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


--
-- Table structure for table `tax_class`
--

CREATE TABLE `tax_class` (
  `tax_class_id` int(11) NOT NULL auto_increment,
  `tax_class_title` varchar(32) NOT NULL default '',
  `tax_class_description` varchar(255) NOT NULL default '',
  `last_modified` datetime default NULL,
  `date_added` datetime NOT NULL default '0001-01-01 00:00:00',
  PRIMARY KEY  (`tax_class_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

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

INSERT INTO `tax_class` VALUES (1,'Taxable Goods','The following types of products are included non-food, services, etc','2004-01-21 01:35:29','2004-01-21 01:35:29');

--
-- Table structure for table `tax_rates`
--

CREATE TABLE `tax_rates` (
  `tax_rates_id` int(11) NOT NULL auto_increment,
  `tax_zone_id` int(11) NOT NULL default '0',
  `tax_class_id` int(11) NOT NULL default '0',
  `tax_priority` int(5) default '1',
  `tax_rate` decimal(7,4) NOT NULL default '0.0000',
  `tax_description` varchar(255) NOT NULL default '',
  `last_modified` datetime default NULL,
  `date_added` datetime NOT NULL default '0001-01-01 00:00:00',
  PRIMARY KEY  (`tax_rates_id`),
  KEY `idx_tax_zone_id_zen` (`tax_zone_id`),
  KEY `idx_tax_class_id_zen` (`tax_class_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

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

INSERT INTO `tax_rates` VALUES (1,2,1,1,'8.2500','CA TAX 8.25%','2006-11-10 09:30:50','2005-09-20 18:35:50');

--
-- Table structure for table `template_select`
--

CREATE TABLE `template_select` (
  `template_id` int(11) NOT NULL auto_increment,
  `template_dir` varchar(64) NOT NULL default '',
  `template_language` varchar(64) NOT NULL default '0',
  PRIMARY KEY  (`template_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `template_select`
--

INSERT INTO `template_select` VALUES (1,'mojo','0');

--
-- Table structure for table `upgrade_exceptions`
--

CREATE TABLE `upgrade_exceptions` (
  `upgrade_exception_id` smallint(5) NOT NULL auto_increment,
  `sql_file` varchar(50) default NULL,
  `reason` varchar(200) default NULL,
  `errordate` datetime default '0001-01-01 00:00:00',
  `sqlstatement` text,
  PRIMARY KEY  (`upgrade_exception_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `upgrade_exceptions`
--


--
-- Table structure for table `zones`
--

CREATE TABLE `zones` (
  `zone_id` int(11) NOT NULL auto_increment,
  `zone_country_id` int(11) NOT NULL default '0',
  `zone_code` varchar(32) NOT NULL default '',
  `zone_name` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`zone_id`)
) ENGINE=MyISAM AUTO_INCREMENT=184 DEFAULT CHARSET=latin1;

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

INSERT INTO `zones` VALUES (1,223,'AL','Alabama'),(2,223,'AK','Alaska'),(3,223,'AS','American Samoa'),(4,223,'AZ','Arizona'),(5,223,'AR','Arkansas'),(6,223,'AF','Armed Forces Africa'),(7,223,'AA','Armed Forces Americas'),(8,223,'AC','Armed Forces Canada'),(9,223,'AE','Armed Forces Europe'),(10,223,'AM','Armed Forces Middle East'),(11,223,'AP','Armed Forces Pacific'),(12,223,'CA','California'),(13,223,'CO','Colorado'),(14,223,'CT','Connecticut'),(15,223,'DE','Delaware'),(16,223,'DC','District of Columbia'),(17,223,'FM','Federated States Of Micronesia'),(18,223,'FL','Florida'),(19,223,'GA','Georgia'),(20,223,'GU','Guam'),(21,223,'HI','Hawaii'),(22,223,'ID','Idaho'),(23,223,'IL','Illinois'),(24,223,'IN','Indiana'),(25,223,'IA','Iowa'),(26,223,'KS','Kansas'),(27,223,'KY','Kentucky'),(28,223,'LA','Louisiana'),(29,223,'ME','Maine'),(30,223,'MH','Marshall Islands'),(31,223,'MD','Maryland'),(32,223,'MA','Massachusetts'),(33,223,'MI','Michigan'),(34,223,'MN','Minnesota'),(35,223,'MS','Mississippi'),(36,223,'MO','Missouri'),(37,223,'MT','Montana'),(38,223,'NE','Nebraska'),(39,223,'NV','Nevada'),(40,223,'NH','New Hampshire'),(41,223,'NJ','New Jersey'),(42,223,'NM','New Mexico'),(183,223,'NY','New York'),(44,223,'NC','North Carolina'),(45,223,'ND','North Dakota'),(46,223,'MP','Northern Mariana Islands'),(47,223,'OH','Ohio'),(48,223,'OK','Oklahoma'),(49,223,'OR','Oregon'),(50,223,'PW','Palau'),(51,223,'PA','Pennsylvania'),(52,223,'PR','Puerto Rico'),(53,223,'RI','Rhode Island'),(54,223,'SC','South Carolina'),(55,223,'SD','South Dakota'),(56,223,'TN','Tennessee'),(57,223,'TX','Texas'),(58,223,'UT','Utah'),(59,223,'VT','Vermont'),(60,223,'VI','Virgin Islands'),(61,223,'VA','Virginia'),(62,223,'WA','Washington'),(63,223,'WV','West Virginia'),(64,223,'WI','Wisconsin'),(65,223,'WY','Wyoming'),(66,38,'AB','Alberta'),(67,38,'BC','British Columbia'),(68,38,'MB','Manitoba'),(69,38,'NF','Newfoundland'),(70,38,'NB','New Brunswick'),(71,38,'NS','Nova Scotia'),(72,38,'NT','Northwest Territories'),(73,38,'NU','Nunavut'),(74,38,'ON','Ontario'),(75,38,'PE','Prince Edward Island'),(76,38,'QC','Quebec'),(77,38,'SK','Saskatchewan'),(78,38,'YT','Yukon Territory'),(79,81,'NDS','Niedersachsen'),(80,81,'BAW','Baden-Wrttemberg'),(81,81,'BAY','Bayern'),(82,81,'BER','Berlin'),(83,81,'BRG','Brandenburg'),(84,81,'BRE','Bremen'),(85,81,'HAM','Hamburg'),(86,81,'HES','Hessen'),(87,81,'MEC','Mecklenburg-Vorpommern'),(88,81,'NRW','Nordrhein-Westfalen'),(89,81,'RHE','Rheinland-Pfalz'),(90,81,'SAR','Saarland'),(91,81,'SAS','Sachsen'),(92,81,'SAC','Sachsen-Anhalt'),(93,81,'SCN','Schleswig-Holstein'),(94,81,'THE','Thringen'),(95,14,'WI','Wien'),(96,14,'NO','Niedersterreich'),(97,14,'OO','Obersterreich'),(98,14,'SB','Salzburg'),(99,14,'KN','K???nten'),(100,14,'ST','Steiermark'),(101,14,'TI','Tirol'),(102,223,'US, USA','USA'),(103,14,'VB','Voralberg'),(104,204,'AG','Aargau'),(105,204,'AI','Appenzell Innerrhoden'),(106,204,'AR','Appenzell Ausserrhoden'),(107,204,'BE','Bern'),(108,204,'BL','Basel-Landschaft'),(109,204,'BS','Basel-Stadt'),(110,204,'FR','Freiburg'),(111,204,'GE','Genf'),(112,204,'GL','Glarus'),(113,204,'JU','Graubnden'),(114,204,'JU','Jura'),(115,204,'LU','Luzern'),(116,204,'NE','Neuenburg'),(117,204,'NW','Nidwalden'),(118,204,'OW','Obwalden'),(119,204,'SG','St. Gallen'),(120,204,'SH','Schaffhausen'),(121,204,'SO','Solothurn'),(122,204,'SZ','Schwyz'),(123,204,'TG','Thurgau'),(124,204,'TI','Tessin'),(125,204,'UR','Uri'),(126,204,'VD','Waadt'),(127,204,'VS','Wallis'),(128,204,'ZG','Zug'),(129,204,'ZH','Zrich'),(130,195,'A Corua','A Corua'),(131,195,'Alava','Alava'),(132,195,'Albacete','Albacete'),(133,195,'Alicante','Alicante'),(134,195,'Almeria','Almeria'),(135,195,'Asturias','Asturias'),(136,195,'Avila','Avila'),(137,195,'Badajoz','Badajoz'),(138,195,'Baleares','Baleares'),(139,195,'Barcelona','Barcelona'),(140,195,'Burgos','Burgos'),(141,195,'Caceres','Caceres'),(142,195,'Cadiz','Cadiz'),(143,195,'Cantabria','Cantabria'),(144,195,'Castellon','Castellon'),(145,195,'Ceuta','Ceuta'),(146,195,'Ciudad Real','Ciudad Real'),(147,195,'Cordoba','Cordoba'),(148,195,'Cuenca','Cuenca'),(149,195,'Girona','Girona'),(150,195,'Granada','Granada'),(151,195,'Guadalajara','Guadalajara'),(152,195,'Guipuzcoa','Guipuzcoa'),(153,195,'Huelva','Huelva'),(154,195,'Huesca','Huesca'),(155,195,'Jaen','Jaen'),(156,195,'La Rioja','La Rioja'),(157,195,'Las Palmas','Las Palmas'),(158,195,'Leon','Leon'),(159,195,'Lleida','Lleida'),(160,195,'Lugo','Lugo'),(161,195,'Madrid','Madrid'),(162,195,'Malaga','Malaga'),(163,195,'Melilla','Melilla'),(164,195,'Murcia','Murcia'),(165,195,'Navarra','Navarra'),(166,195,'Ourense','Ourense'),(167,195,'Palencia','Palencia'),(168,195,'Pontevedra','Pontevedra'),(169,195,'Salamanca','Salamanca'),(170,195,'Santa Cruz de Tenerife','Santa Cruz de Tenerife'),(171,195,'Segovia','Segovia'),(172,195,'Sevilla','Sevilla'),(173,195,'Soria','Soria'),(174,195,'Tarragona','Tarragona'),(175,195,'Teruel','Teruel'),(176,195,'Toledo','Toledo'),(177,195,'Valencia','Valencia'),(178,195,'Valladolid','Valladolid'),(179,195,'Vizcaya','Vizcaya'),(180,195,'Zamora','Zamora'),(181,195,'Zaragoza','Zaragoza');

--
-- Table structure for table `zones_to_geo_zones`
--

CREATE TABLE `zones_to_geo_zones` (
  `association_id` int(11) NOT NULL auto_increment,
  `zone_country_id` int(11) NOT NULL default '0',
  `zone_id` int(11) default NULL,
  `geo_zone_id` int(11) default NULL,
  `last_modified` datetime default NULL,
  `date_added` datetime NOT NULL default '0001-01-01 00:00:00',
  PRIMARY KEY  (`association_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

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

INSERT INTO `zones_to_geo_zones` VALUES (2,223,12,2,'2006-11-17 16:49:32','2006-11-17 16:46:44'),(3,223,NULL,3,'2007-02-05 21:15:35','2006-11-17 16:49:10'),(4,81,0,4,NULL,'2007-02-05 20:58:29'),(6,0,NULL,5,'2007-02-05 21:20:15','2007-02-05 21:19:03');


