-- Table structure for table `zen_banners`
--

CREATE TABLE `zen_banners` (
  `banners_id` int(11) NOT NULL AUTO_INCREMENT,
  `banners_title` varchar(64) NOT NULL DEFAULT '',
  `banners_url` varchar(255) NOT NULL DEFAULT '',
  `banners_image` varchar(64) NOT NULL DEFAULT '',
  `banners_group` varchar(15) NOT NULL DEFAULT '',
  `banners_html_text` text,
  `expires_impressions` int(7) DEFAULT '0',
  `expires_date` datetime DEFAULT NULL,
  `date_scheduled` datetime DEFAULT NULL,
  `date_added` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
  `date_status_change` datetime DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT '1',
  `banners_open_new_windows` int(1) NOT NULL DEFAULT '1',
  `banners_on_ssl` int(1) NOT NULL DEFAULT '1',
  `banners_sort_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`banners_id`),
  KEY `idx_status_group_zen` (`status`,`banners_group`),
  KEY `idx_expires_date_zen` (`expires_date`),
  KEY `idx_date_scheduled_zen` (`date_scheduled`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_banners`
--

INSERT INTO `zen_banners` VALUES (1,'Let\'s Have Chinese Tonight!','http://www.1chinesedelight.com','tonight.jpg','Wide-Banners','',0,NULL,NULL,'2004-01-11 20:59:12',NULL,1,1,1,0),(2,'Chinese Delight','http://www.1chinesedelight.com','coup160.jpg','SideBox-Banners','',0,NULL,NULL,'2004-01-11 20:59:12',NULL,1,1,1,2),(3,'Chinese Delight Coupons Food Deals','http://www.1chinesedelight.com','coup2160.jpg','SideBox-Banners','',0,NULL,NULL,'2004-01-11 20:59:12',NULL,1,1,1,0),(4,'Chinese Delight','http://www.1chinesedelight.com','tonight.jpg','Wide-Banners','',0,NULL,NULL,'2004-01-12 20:53:18',NULL,1,1,1,0),(5,'Chinese Delight','http://www.1chinesedelight.com','cookie.gif','BannersAll','',0,NULL,NULL,'2005-05-13 10:54:38',NULL,1,1,1,10),(6,'Chinese Delight','http://www.1chinesedelight.com','tonight.jpg','Wide-Banners','',0,NULL,NULL,'2006-03-13 11:02:43',NULL,1,1,1,0),(7,'chinese Delight','http://www.1chinesedelight.com','tonight.jpg','Wide-Banners','',0,NULL,NULL,'2007-02-10 00:00:00',NULL,1,1,1,1),(8,'Chinese Delight','http://www.1chinesedelight.com','coup160.jpg','SideBox-Banners','',0,NULL,NULL,'2007-02-10 00:00:00',NULL,1,1,1,1),(9,'Chinese Delight','http://www.1chinesedelight.com','togo.jpg','BannersAll','',0,NULL,NULL,'2007-02-10 00:00:00',NULL,1,1,1,5);

--
-- Table structure for table `zen_banners_history`
--

CREATE TABLE `zen_banners_history` (
  `banners_history_id` int(11) NOT NULL AUTO_INCREMENT,
  `banners_id` int(11) NOT NULL DEFAULT '0',
  `banners_shown` int(5) NOT NULL DEFAULT '0',
  `banners_clicked` int(5) NOT NULL DEFAULT '0',
  `banners_history_date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
  PRIMARY KEY (`banners_history_id`),
  KEY `idx_banners_id_zen` (`banners_id`)
) ENGINE=MyISAM AUTO_INCREMENT=331 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_banners_history`
--

INSERT INTO `zen_banners_history` VALUES (7,2,58,0,'2010-03-04 18:43:35'),(8,5,95,0,'2010-03-04 18:43:35'),(9,9,95,0,'2010-03-04 18:43:35'),(10,6,28,0,'2010-03-04 18:43:35'),(11,3,68,0,'2010-03-04 18:44:15'),(12,7,25,0,'2010-03-04 18:44:15'),(13,4,22,0,'2010-03-04 18:44:17'),(14,8,64,0,'2010-03-04 18:44:21'),(15,1,20,0,'2010-03-04 19:17:02'),(16,2,110,0,'2010-03-05 00:00:03'),(17,5,161,0,'2010-03-05 00:00:04'),(18,9,161,0,'2010-03-05 00:00:04'),(19,4,36,0,'2010-03-05 00:00:04'),(20,8,89,0,'2010-03-05 08:14:51'),(21,3,123,0,'2010-03-05 08:21:39'),(22,6,46,0,'2010-03-05 08:21:39'),(23,7,44,0,'2010-03-05 08:23:20'),(24,1,35,0,'2010-03-05 08:32:09'),(25,3,63,0,'2010-03-06 00:31:59'),(26,9,103,0,'2010-03-06 00:31:59'),(27,5,103,0,'2010-03-06 00:31:59'),(28,8,75,0,'2010-03-06 00:31:59'),(29,4,29,0,'2010-03-06 00:31:59'),(30,7,32,1,'2010-03-06 00:33:16'),(31,2,68,0,'2010-03-06 00:33:22'),(32,1,21,0,'2010-03-06 00:34:31'),(33,6,21,0,'2010-03-06 00:46:13'),(34,8,4,0,'2010-03-07 12:35:31'),(35,9,5,0,'2010-03-07 12:35:31'),(36,5,5,0,'2010-03-07 12:35:31'),(37,7,1,0,'2010-03-07 12:35:31'),(38,3,4,0,'2010-03-07 12:36:14'),(39,4,3,0,'2010-03-07 12:36:14'),(40,2,2,0,'2010-03-07 12:36:22'),(41,1,1,0,'2010-03-07 12:36:31'),(42,8,6,0,'2010-03-15 15:06:38'),(43,9,11,0,'2010-03-15 15:06:38'),(44,5,11,0,'2010-03-15 15:06:38'),(45,2,8,0,'2010-03-15 15:06:38'),(46,4,4,0,'2010-03-15 15:06:38'),(47,3,8,0,'2010-03-15 15:06:44'),(48,7,3,0,'2010-03-15 15:06:44'),(49,6,3,0,'2010-03-15 15:06:50'),(50,1,1,0,'2010-03-15 15:07:15'),(51,8,2,0,'2010-03-21 16:22:44'),(52,9,6,0,'2010-03-21 16:22:44'),(53,5,6,0,'2010-03-21 16:22:44'),(54,2,6,0,'2010-03-21 16:22:44'),(55,1,5,0,'2010-03-21 16:22:44'),(56,3,4,0,'2010-03-21 16:23:38'),(57,6,1,0,'2010-03-21 16:24:41'),(58,3,3,0,'2010-03-23 20:27:48'),(59,9,7,0,'2010-03-23 20:27:48'),(60,5,7,0,'2010-03-23 20:27:48'),(61,2,2,0,'2010-03-23 20:27:48'),(62,4,2,0,'2010-03-23 20:27:49'),(63,8,9,0,'2010-03-23 20:28:07'),(64,6,2,0,'2010-03-23 21:12:28'),(65,1,3,0,'2010-03-23 21:13:05'),(66,2,17,0,'2010-03-24 20:03:43'),(67,9,18,0,'2010-03-24 20:03:44'),(68,5,18,0,'2010-03-24 20:03:44'),(69,3,9,0,'2010-03-24 20:03:44'),(70,1,4,0,'2010-03-24 20:03:44'),(71,8,10,0,'2010-03-24 20:04:00'),(72,7,5,0,'2010-03-24 20:04:48'),(73,6,6,0,'2010-03-24 21:46:20'),(74,4,3,0,'2010-03-24 21:46:36'),(75,8,86,0,'2010-03-25 07:23:55'),(76,9,157,0,'2010-03-25 07:23:55'),(77,5,157,0,'2010-03-25 07:23:55'),(78,3,116,1,'2010-03-25 07:23:55'),(79,7,38,0,'2010-03-25 07:23:55'),(80,2,112,0,'2010-03-25 07:47:01'),(81,1,36,0,'2010-03-25 07:47:01'),(82,4,33,0,'2010-03-25 07:47:21'),(83,6,50,0,'2010-03-25 07:55:29'),(84,2,43,0,'2010-03-26 18:37:12'),(85,9,73,0,'2010-03-26 18:37:12'),(86,5,73,0,'2010-03-26 18:37:12'),(87,6,16,0,'2010-03-26 18:37:12'),(88,8,60,0,'2010-03-26 18:39:56'),(89,7,22,0,'2010-03-26 18:39:56'),(90,1,18,0,'2010-03-26 18:39:59'),(91,3,43,0,'2010-03-26 18:45:24'),(92,4,17,0,'2010-03-26 19:06:42'),(93,2,7,0,'2010-03-27 17:49:57'),(94,9,14,0,'2010-03-27 17:49:57'),(95,5,14,0,'2010-03-27 17:49:57'),(96,3,14,0,'2010-03-27 17:49:57'),(97,1,5,0,'2010-03-27 17:49:57'),(98,4,3,0,'2010-03-27 17:50:00'),(99,8,7,0,'2010-03-27 17:50:02'),(100,6,4,0,'2010-03-27 17:50:02'),(101,7,2,0,'2010-03-27 17:51:59'),(102,3,22,0,'2010-03-28 18:45:01'),(103,9,29,0,'2010-03-28 18:45:01'),(104,5,29,0,'2010-03-28 18:45:01'),(105,2,16,0,'2010-03-28 18:45:01'),(106,1,10,0,'2010-03-28 18:45:01'),(107,7,8,0,'2010-03-28 18:45:31'),(108,8,20,0,'2010-03-28 18:58:53'),(109,4,5,0,'2010-03-28 18:58:53'),(110,6,6,0,'2010-03-28 19:44:17'),(111,8,27,0,'2010-03-29 00:04:48'),(112,9,38,0,'2010-03-29 00:04:48'),(113,5,38,0,'2010-03-29 00:04:48'),(114,1,5,0,'2010-03-29 00:04:48'),(115,3,24,0,'2010-03-29 00:05:42'),(116,2,25,0,'2010-03-29 00:05:42'),(117,4,12,0,'2010-03-29 00:05:42'),(118,6,5,0,'2010-03-29 00:08:00'),(119,7,16,0,'2010-03-29 12:43:08'),(120,8,15,0,'2010-03-31 19:14:21'),(121,9,23,0,'2010-03-31 19:14:21'),(122,5,23,0,'2010-03-31 19:14:21'),(123,3,15,0,'2010-03-31 19:14:21'),(124,7,6,0,'2010-03-31 19:14:21'),(125,2,16,0,'2010-03-31 19:14:47'),(126,6,9,0,'2010-03-31 19:14:47'),(127,1,6,0,'2010-03-31 19:15:29'),(128,4,2,0,'2010-03-31 19:15:48'),(129,3,61,0,'2010-04-02 05:00:23'),(130,9,95,0,'2010-04-02 05:00:23'),(131,5,95,0,'2010-04-02 05:00:23'),(132,1,22,0,'2010-04-02 05:00:23'),(133,2,65,0,'2010-04-02 05:00:31'),(134,8,64,0,'2010-04-02 05:00:31'),(135,7,18,0,'2010-04-02 05:00:31'),(136,4,29,0,'2010-04-02 05:46:37'),(137,6,26,0,'2010-04-02 05:47:15'),(138,3,59,0,'2010-04-03 06:59:39'),(139,9,51,0,'2010-04-03 06:59:39'),(140,5,51,0,'2010-04-03 06:59:39'),(141,7,27,0,'2010-04-03 06:59:39'),(142,2,56,0,'2010-04-03 07:00:20'),(143,8,47,0,'2010-04-03 07:00:20'),(144,1,26,0,'2010-04-03 07:00:20'),(145,6,31,0,'2010-04-03 07:01:21'),(146,4,26,0,'2010-04-03 07:09:15'),(147,8,1,0,'2010-04-20 14:27:43'),(148,4,1,0,'2010-04-20 14:27:43'),(149,2,5,0,'2010-04-30 13:47:49'),(150,6,2,0,'2010-04-30 13:47:49'),(151,1,6,0,'2010-04-30 13:53:03'),(152,3,4,0,'2010-04-30 13:53:06'),(153,7,2,0,'2010-04-30 13:53:07'),(154,8,4,0,'2010-04-30 13:53:14'),(155,4,3,0,'2010-04-30 14:09:44'),(156,8,4,0,'2010-05-01 18:40:03'),(157,7,3,0,'2010-05-01 18:40:03'),(158,2,7,0,'2010-05-01 18:40:27'),(159,6,6,0,'2010-05-01 18:40:28'),(160,4,3,0,'2010-05-01 18:40:43'),(161,1,3,0,'2010-05-01 18:40:50'),(162,3,4,0,'2010-05-01 18:41:31'),(163,2,30,0,'2010-05-02 13:17:38'),(164,7,25,0,'2010-05-02 13:17:38'),(165,6,27,0,'2010-05-02 13:17:38'),(166,3,35,0,'2010-05-02 13:17:38'),(167,8,28,0,'2010-05-02 13:18:24'),(168,4,22,0,'2010-05-02 13:20:23'),(169,1,15,0,'2010-05-02 13:20:47'),(170,2,7,0,'2010-05-03 10:37:36'),(171,4,4,0,'2010-05-03 10:37:36'),(172,3,8,0,'2010-05-03 10:38:09'),(173,1,7,0,'2010-05-03 10:38:09'),(174,6,2,0,'2010-05-03 10:51:57'),(175,8,6,0,'2010-05-03 18:32:45'),(176,7,8,0,'2010-05-03 18:34:11'),(177,8,1,0,'2010-05-06 13:45:47'),(178,1,1,0,'2010-05-06 13:45:47'),(179,2,1,0,'2010-05-07 15:31:05'),(180,1,1,0,'2010-05-07 15:31:05'),(181,8,1,0,'2010-05-07 15:31:11'),(182,4,1,0,'2010-05-07 15:31:11'),(183,8,5,0,'2010-05-21 12:26:56'),(184,4,3,0,'2010-05-21 12:26:56'),(185,3,3,0,'2010-05-21 12:27:13'),(186,7,3,0,'2010-05-21 12:27:13'),(187,2,5,0,'2010-05-21 12:27:43'),(188,1,3,0,'2010-05-21 12:27:45'),(189,6,4,0,'2010-05-21 14:13:05'),(190,3,1,0,'2010-05-26 19:44:26'),(191,4,4,0,'2010-05-26 19:44:26'),(192,8,2,0,'2010-05-26 19:44:53'),(193,1,1,0,'2010-05-26 19:44:53'),(194,2,3,0,'2010-05-26 20:57:42'),(195,7,1,0,'2010-05-26 20:57:42'),(196,8,1,0,'2010-06-04 19:53:55'),(197,1,1,0,'2010-06-04 19:53:55'),(198,3,8,0,'2010-06-06 12:06:49'),(199,6,3,0,'2010-06-06 12:06:49'),(200,7,6,0,'2010-06-06 12:07:03'),(201,8,2,0,'2010-06-06 12:23:25'),(202,1,3,0,'2010-06-06 12:23:25'),(203,2,3,0,'2010-06-06 12:23:41'),(204,4,1,0,'2010-06-06 12:24:40'),(205,3,1,0,'2010-06-21 21:56:15'),(206,6,1,0,'2010-06-21 21:56:15'),(207,8,2,0,'2010-08-22 13:26:14'),(208,4,3,0,'2010-08-22 13:26:14'),(209,2,1,0,'2010-08-22 13:26:38'),(210,7,2,0,'2010-08-22 13:26:38'),(211,3,4,0,'2010-08-22 13:27:00'),(212,1,1,0,'2010-08-22 13:27:00'),(213,6,1,0,'2010-08-22 13:27:24'),(214,2,4,0,'2010-09-13 13:11:18'),(215,4,3,0,'2010-09-13 13:11:18'),(216,1,5,0,'2010-09-13 13:11:43'),(217,3,3,0,'2010-09-13 13:12:51'),(218,8,3,0,'2010-09-13 13:12:58'),(219,7,2,0,'2010-09-13 13:13:07'),(220,8,4,0,'2010-09-22 09:15:00'),(221,7,3,0,'2010-09-22 09:15:00'),(222,6,1,0,'2010-09-22 09:15:16'),(223,3,4,0,'2010-09-22 09:15:22'),(224,1,4,0,'2010-09-22 09:15:22'),(225,4,1,0,'2010-09-22 12:08:16'),(226,2,1,0,'2010-09-22 12:09:00'),(227,3,11,0,'2010-10-26 09:40:43'),(228,1,5,0,'2010-10-26 09:40:43'),(229,8,7,0,'2010-10-26 09:41:02'),(230,6,4,0,'2010-10-26 09:41:02'),(231,7,10,0,'2010-10-26 09:41:08'),(232,2,6,0,'2010-10-26 09:41:15'),(233,4,5,0,'2010-10-26 09:41:37'),(234,8,4,0,'2010-10-27 20:51:01'),(235,7,3,0,'2010-10-27 20:51:01'),(236,6,4,0,'2010-10-27 20:52:11'),(237,3,2,0,'2010-10-27 20:53:21'),(238,2,2,0,'2010-10-27 20:54:00'),(239,1,1,0,'2010-10-27 20:54:00'),(240,2,4,0,'2011-01-07 12:53:51'),(241,1,5,0,'2011-01-07 12:53:51'),(242,3,3,0,'2011-01-07 12:54:06'),(243,4,3,0,'2011-01-07 12:54:06'),(244,8,2,0,'2011-01-07 12:55:40'),(245,6,1,0,'2011-01-07 12:55:55'),(246,8,34,0,'2011-01-08 09:05:47'),(247,4,31,0,'2011-01-08 09:05:47'),(248,6,28,1,'2011-01-08 09:26:37'),(249,3,38,0,'2011-01-08 09:27:10'),(250,2,35,0,'2011-01-08 09:37:21'),(251,1,23,0,'2011-01-08 09:37:21'),(252,7,25,0,'2011-01-08 09:37:31'),(253,3,2,0,'2011-01-15 09:06:59'),(254,1,2,0,'2011-01-15 09:06:59'),(255,2,2,0,'2011-01-15 09:07:28'),(256,4,2,0,'2011-01-15 09:07:28'),(257,6,1,0,'2011-01-15 09:07:51'),(258,8,1,0,'2011-01-15 09:08:28'),(259,8,5,0,'2011-01-19 22:33:55'),(260,7,3,0,'2011-01-19 22:33:55'),(261,2,3,0,'2011-01-19 22:34:04'),(262,1,4,0,'2011-01-19 22:34:04'),(263,3,2,0,'2011-01-19 22:34:33'),(264,4,3,0,'2011-01-19 22:34:34'),(265,2,4,0,'2011-02-19 18:39:14'),(266,4,2,0,'2011-02-19 18:39:14'),(267,3,7,0,'2011-02-19 18:39:48'),(268,7,5,1,'2011-02-19 18:39:48'),(269,8,4,0,'2011-02-19 18:39:50'),(270,6,5,0,'2011-02-19 18:40:16'),(271,1,3,0,'2011-02-19 18:41:01'),(272,2,4,0,'2011-02-20 16:03:20'),(273,4,3,0,'2011-02-20 16:03:20'),(274,6,2,0,'2011-02-20 16:03:25'),(275,8,1,0,'2011-02-20 16:03:32'),(276,8,1,0,'2011-04-05 18:04:48'),(277,7,1,0,'2011-04-05 18:04:48'),(278,8,14,0,'2011-05-24 07:45:49'),(279,4,10,0,'2011-05-24 07:45:49'),(280,2,17,0,'2011-05-24 07:46:01'),(281,1,15,0,'2011-05-24 07:46:03'),(282,3,21,0,'2011-05-24 07:46:32'),(283,7,13,0,'2011-05-24 07:47:04'),(284,6,14,0,'2011-05-24 07:47:51'),(285,3,4,0,'2011-05-25 22:16:27'),(286,4,2,0,'2011-05-25 22:16:27'),(287,8,5,0,'2011-05-25 22:16:29'),(288,1,5,0,'2011-05-25 22:16:35'),(289,2,4,0,'2011-05-25 22:19:04'),(290,6,5,0,'2011-05-25 22:29:47'),(291,7,1,0,'2011-05-25 22:56:20'),(292,2,6,0,'2011-07-05 14:22:40'),(293,7,5,0,'2011-07-05 14:22:40'),(294,1,5,0,'2011-07-05 14:23:03'),(295,3,7,0,'2011-07-05 14:23:15'),(296,8,6,0,'2011-07-05 14:23:43'),(297,4,4,0,'2011-07-05 14:23:43'),(298,6,5,0,'2011-07-05 14:24:18'),(299,8,27,0,'2011-07-06 14:30:43'),(300,6,23,0,'2011-07-06 14:30:43'),(301,2,26,0,'2011-07-06 14:31:45'),(302,7,14,0,'2011-07-06 14:32:35'),(303,1,11,0,'2011-07-06 14:32:50'),(304,4,19,0,'2011-07-06 14:48:45'),(305,3,14,0,'2011-07-06 17:31:23'),(306,8,28,1,'2011-07-07 19:20:34'),(307,4,19,0,'2011-07-07 19:20:34'),(308,3,22,0,'2011-07-07 19:20:54'),(309,1,23,0,'2011-07-07 19:20:54'),(310,2,20,0,'2011-07-07 19:22:20'),(311,6,14,0,'2011-07-07 19:22:20'),(312,7,13,0,'2011-07-07 19:31:16'),(313,3,4,0,'2011-07-11 13:29:52'),(314,6,2,0,'2011-07-11 13:29:52'),(315,8,4,0,'2011-07-11 13:29:57'),(316,4,3,0,'2011-07-11 13:29:57'),(317,1,2,0,'2011-07-11 13:30:54'),(318,7,1,0,'2011-07-11 13:31:14'),(319,3,1,0,'2011-07-12 12:42:05'),(320,1,1,0,'2011-07-12 12:42:06'),(321,8,2,0,'2011-08-08 09:31:54'),(322,4,1,0,'2011-08-08 09:31:56'),(323,7,1,0,'2011-08-08 09:33:32'),(324,2,4,0,'2011-11-01 18:38:51'),(325,1,3,0,'2011-11-01 18:38:51'),(326,3,5,0,'2011-11-01 18:42:43'),(327,6,4,0,'2011-11-01 18:42:43'),(328,4,1,0,'2011-11-01 18:43:45'),(329,8,1,0,'2011-11-01 18:44:24'),(330,7,2,0,'2011-11-01 18:44:24');

--
-- Table structure for table `zen_categories`
--

CREATE TABLE `zen_categories` (
  `categories_id` int(11) NOT NULL AUTO_INCREMENT,
  `categories_image` varchar(64) DEFAULT NULL,
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `sort_order` int(3) DEFAULT NULL,
  `date_added` datetime DEFAULT NULL,
  `last_modified` datetime DEFAULT NULL,
  `categories_status` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`categories_id`),
  KEY `idx_parent_id_cat_id_zen` (`parent_id`,`categories_id`),
  KEY `idx_status_zen` (`categories_status`),
  KEY `idx_sort_order_zen` (`sort_order`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_categories`
--

INSERT INTO `zen_categories` VALUES (1,NULL,0,0,'2010-03-04 21:25:06','2010-03-25 08:56:04',1),(2,NULL,0,2,'2010-03-04 21:26:00','2010-03-28 23:23:45',1),(4,'categories/salad.jpg',1,0,'2010-03-04 21:29:08',NULL,1),(5,'categories/soup.jpg',1,1,'2010-03-04 21:29:38','2010-03-25 09:29:12',1),(6,'categories/seafood.jpg',1,3,'2010-03-04 21:30:03','2010-03-25 09:30:06',1),(7,NULL,1,2,'2010-03-24 20:09:01','2010-03-25 09:29:54',1),(8,NULL,1,4,'2010-03-25 05:42:09','2010-03-25 09:30:48',1),(9,NULL,1,5,'2010-03-25 06:00:50','2010-03-25 09:32:05',1),(10,NULL,1,6,'2010-03-25 06:15:08','2010-03-25 09:32:18',1),(11,NULL,1,7,'2010-03-25 06:21:03','2010-03-25 06:21:14',1),(12,NULL,1,8,'2010-03-25 06:25:23',NULL,1),(13,NULL,1,9,'2010-03-25 06:29:43','2010-03-25 06:30:23',1),(14,NULL,1,10,'2010-03-25 06:34:47',NULL,1),(15,NULL,1,11,'2010-03-25 06:39:06','2010-03-25 06:48:45',1),(17,NULL,1,12,'2010-03-25 06:46:52','2010-03-25 06:52:20',1),(18,NULL,0,1,'2010-03-28 18:26:50',NULL,1),(19,NULL,2,0,'2010-03-28 23:25:13','2010-03-29 14:04:42',1),(20,NULL,2,1,'2010-03-28 23:25:50',NULL,1),(21,NULL,2,2,'2010-03-28 23:26:11',NULL,1),(22,NULL,2,4,'2010-03-28 23:26:55',NULL,1),(23,NULL,2,5,'2010-03-28 23:27:26',NULL,1),(24,NULL,2,6,'2010-03-28 23:28:31','2010-03-29 12:54:34',1),(25,NULL,2,7,'2010-03-28 23:29:21','2010-03-28 23:32:12',1),(26,NULL,2,8,'2010-03-28 23:32:48','2010-03-28 23:33:08',1),(27,NULL,2,9,'2010-03-28 23:33:58',NULL,1),(28,NULL,0,0,'2011-05-24 20:58:46','2011-05-25 22:26:53',1);

--
-- Table structure for table `zen_categories_description`
--

CREATE TABLE `zen_categories_description` (
  `categories_id` int(11) NOT NULL DEFAULT '0',
  `language_id` int(11) NOT NULL DEFAULT '1',
  `categories_name` varchar(32) NOT NULL DEFAULT '',
  `categories_description` text NOT NULL,
  PRIMARY KEY (`categories_id`,`language_id`),
  KEY `idx_categories_name_zen` (`categories_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_categories_description`
--

INSERT INTO `zen_categories_description` VALUES (1,1,'MENU',''),(2,1,'LUNCHEON SPECIALS','<div align=\"center\"><strong>Monday -  Saturday: 11:00    a.m. ~ 3:30 p.m.    Sunday:12:00 a.m. ~    3:30 p.m.</strong> <br />\r\n  <strong>Served    with Soup</strong> (EGG DROP, HOT    &amp; SOUR OR WON TON)<br />\r\n  <strong>Appetizer</strong>  (EGG ROLL OR CRABMEAT CHEESE)<br />\r\n  <strong>and Rice</strong> ( FRIED RICE OR WHITE RICE)\r\n</div>'),(18,1,'DELIGHTFUL FAMILY DINNERS',''),(4,1,'Appetizers & Salad',''),(5,1,'Soup','<strong>*   Represents Hot and Spicy - May be altered according to your taste.\r\n</br></br>  MOST ENTRIES CAN BE PREPARED IN THE VEGETARIAN MANNER</strong>'),(6,1,'Seafood','<strong>*   Represents Hot and Spicy - May be altered according to your taste.\r\n</br></br>  MOST ENTRIES CAN BE PREPARED IN THE VEGETARIAN MANNER</strong>'),(7,1,'House Specialties','<strong>*   Represents Hot and Spicy - May be altered according to your taste.\r\n</br></br>  MOST ENTRIES CAN BE PREPARED IN THE VEGETARIAN MANNER</strong>'),(8,1,'Poultry','<strong>*   Represents Hot and Spicy - May be altered according to your taste.\r\n</br></br>  MOST ENTRIES CAN BE PREPARED IN THE VEGETARIAN MANNER</strong>'),(9,1,'Beef','<strong>*   Represents Hot and Spicy - May be altered according to your taste.\r\n</br></br>  MOST ENTRIES CAN BE PREPARED IN THE VEGETARIAN MANNER</strong>'),(10,1,'Pork','<strong>*   Represents Hot and Spicy - May be altered according to your taste.\r\n</br></br>  MOST ENTRIES CAN BE PREPARED IN THE VEGETARIAN MANNER</strong>'),(11,1,'Vegetables',''),(12,1,'Special Diet Dish',''),(13,1,'Egg Foo Young','(2 Patties)'),(14,1,'Pan Fried Chow Mein','(Hong Kong Style Golden Noodle)'),(15,1,'Chop Suey & Chow Mein','(Chop Suey Served with Rice)\r\n</br>(Chow Mein Served with Cantonese Crispy Chow Mein)'),(17,1,'Fried Rice & Soft Noodle',''),(19,1,'Poultry','MOST OF ENTRÉES CAN BE PREPARED IN THE VEGETARIAN MANNER</br></br>* Represents Hot and Spicy -May be altered according to your taste.'),(20,1,'Beef',''),(21,1,'Pork',''),(22,1,'Seafood',''),(23,1,'Vegetables & Diet Dish',''),(24,1,'Fried Rice',''),(25,1,'Soft Noodle','(Stir fried soft noodle)'),(26,1,'Chop Suey','(Served with Rice)'),(27,1,'Chow Mein','(Served with Hard Noodle)'),(28,1,'TEST','');

--
-- Table structure for table `zen_configuration`
--

CREATE TABLE `zen_configuration` (
  `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,
  `configuration_group_id` int(11) NOT NULL DEFAULT '0',
  `sort_order` int(5) DEFAULT NULL,
  `last_modified` datetime DEFAULT NULL,
  `date_added` datetime NOT NULL DEFAULT '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)),
  KEY `idx_cfg_grp_id_zen` (`configuration_group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=635 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_configuration`
--



--
-- Table structure for table `zen_configuration_group`
--

CREATE TABLE `zen_configuration_group` (
  `configuration_group_id` int(11) NOT NULL AUTO_INCREMENT,
  `configuration_group_title` varchar(64) NOT NULL DEFAULT '',
  `configuration_group_description` varchar(255) NOT NULL DEFAULT '',
  `sort_order` int(5) DEFAULT NULL,
  `visible` int(1) DEFAULT '1',
  PRIMARY KEY (`configuration_group_id`),
  KEY `idx_visible_zen` (`visible`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_configuration_group`
--

INSERT INTO `zen_configuration_group` VALUES (1,'My Store','General information about my store',1,1),(2,'Minimum Values','The minimum values for functions / data',2,1),(3,'Maximum Values','The maximum values for functions / data',3,1),(4,'Images','Image parameters',4,1),(5,'Customer Details','Customer account configuration',5,1),(6,'Module Options','Hidden from configuration',6,0),(7,'Shipping/Packaging','Shipping options available at my store',7,1),(8,'Product Listing','Product Listing configuration options',8,1),(9,'Stock','Stock configuration options',9,1),(10,'Logging','Logging configuration options',10,1),(11,'Regulations','Regulation options',16,1),(12,'E-Mail Options','General settings for E-Mail transport and HTML E-Mails',12,1),(13,'Attribute Settings','Configure products attributes settings',13,1),(14,'GZip Compression','GZip compression options',14,1),(15,'Sessions','Session options',15,1),(16,'GV Coupons','Gift Vouchers and Coupons',16,1),(17,'Credit Cards','Credit Cards Accepted',17,1),(18,'Product Info','Product Info Display Options',18,1),(19,'Layout Settings','Layout Options',19,1),(20,'Website Maintenance','Website Maintenance Options',20,1),(21,'New Listing','New Products Listing',21,1),(22,'Featured Listing','Featured Products Listing',22,1),(23,'All Listing','All Products Listing',23,1),(24,'Index Listing','Index Products Listing',24,1),(25,'Define Page Status','Define Main Pages and HTMLArea Options',25,1),(30,'EZ-Pages Settings','EZ-Pages Settings',30,1);

--
-- Table structure for table `zen_counter`
--

CREATE TABLE `zen_counter` (
  `startdate` char(8) DEFAULT NULL,
  `counter` int(12) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_counter`
--

INSERT INTO `zen_counter` VALUES ('20100304',1649);

--
-- Table structure for table `zen_counter_history`
--

CREATE TABLE `zen_counter_history` (
  `startdate` char(8) NOT NULL DEFAULT '',
  `counter` int(12) DEFAULT NULL,
  `session_counter` int(12) DEFAULT NULL,
  PRIMARY KEY (`startdate`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_counter_history`
--

INSERT INTO `zen_counter_history` VALUES ('20100304',102,2),('20100305',164,6),('20100306',106,9),('20100307',5,1),('20100315',11,1),('20100321',6,1),('20100323',9,4),('20100324',18,2),('20100325',161,6),('20100326',79,2),('20100327',16,4),('20100328',32,4),('20100329',46,7),('20100331',31,2),('20100402',109,6),('20100403',115,4),('20100420',2,1),('20100430',14,1),('20100501',15,1),('20100502',100,4),('20100503',21,2),('20100506',2,1),('20100507',2,1),('20100521',13,2),('20100526',6,2),('20100604',2,1),('20100606',14,1),('20100621',1,1),('20100822',8,1),('20100913',11,1),('20100922',10,2),('20101026',25,3),('20101027',8,1),('20110107',10,1),('20110108',142,11),('20110115',6,1),('20110119',11,1),('20110219',16,1),('20110220',5,1),('20110405',1,1),('20110524',71,6),('20110525',24,3),('20110530',1,1),('20110705',21,2),('20110706',12,3),('20110707',53,1),('20110711',8,1),('20110712',1,1),('20110808',2,1);

--
-- Table structure for table `zen_countries`
--

CREATE TABLE `zen_countries` (
  `countries_id` int(11) NOT NULL AUTO_INCREMENT,
  `countries_name` varchar(64) NOT NULL DEFAULT '',
  `countries_iso_code_2` char(2) NOT NULL DEFAULT '',
  `countries_iso_code_3` char(3) NOT NULL DEFAULT '',
  `address_format_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`countries_id`),
  KEY `idx_countries_name_zen` (`countries_name`),
  KEY `idx_address_format_id_zen` (`address_format_id`),
  KEY `idx_iso_2_zen` (`countries_iso_code_2`),
  KEY `idx_iso_3_zen` (`countries_iso_code_3`)
) ENGINE=MyISAM AUTO_INCREMENT=241 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_countries`
--

INSERT INTO `zen_countries` VALUES (240,'Aaland Islands','AX','ALA',1),(1,'Afghanistan','AF','AFG',1),(2,'Albania','AL','ALB',1),(3,'Algeria','DZ','DZA',1),(4,'American Samoa','AS','ASM',1),(5,'Andorra','AD','AND',1),(6,'Angola','AO','AGO',1),(7,'Anguilla','AI','AIA',1),(8,'Antarctica','AQ','ATA',1),(9,'Antigua and Barbuda','AG','ATG',1),(10,'Argentina','AR','ARG',1),(11,'Armenia','AM','ARM',1),(12,'Aruba','AW','ABW',1),(13,'Australia','AU','AUS',1),(14,'Austria','AT','AUT',5),(15,'Azerbaijan','AZ','AZE',1),(16,'Bahamas','BS','BHS',1),(17,'Bahrain','BH','BHR',1),(18,'Bangladesh','BD','BGD',1),(19,'Barbados','BB','BRB',1),(20,'Belarus','BY','BLR',1),(21,'Belgium','BE','BEL',1),(22,'Belize','BZ','BLZ',1),(23,'Benin','BJ','BEN',1),(24,'Bermuda','BM','BMU',1),(25,'Bhutan','BT','BTN',1),(26,'Bolivia','BO','BOL',1),(27,'Bosnia and Herzegowina','BA','BIH',1),(28,'Botswana','BW','BWA',1),(29,'Bouvet Island','BV','BVT',1),(30,'Brazil','BR','BRA',1),(31,'British Indian Ocean Territory','IO','IOT',1),(32,'Brunei Darussalam','BN','BRN',1),(33,'Bulgaria','BG','BGR',1),(34,'Burkina Faso','BF','BFA',1),(35,'Burundi','BI','BDI',1),(36,'Cambodia','KH','KHM',1),(37,'Cameroon','CM','CMR',1),(38,'Canada','CA','CAN',2),(39,'Cape Verde','CV','CPV',1),(40,'Cayman Islands','KY','CYM',1),(41,'Central African Republic','CF','CAF',1),(42,'Chad','TD','TCD',1),(43,'Chile','CL','CHL',1),(44,'China','CN','CHN',1),(45,'Christmas Island','CX','CXR',1),(46,'Cocos (Keeling) Islands','CC','CCK',1),(47,'Colombia','CO','COL',1),(48,'Comoros','KM','COM',1),(49,'Congo','CG','COG',1),(50,'Cook Islands','CK','COK',1),(51,'Costa Rica','CR','CRI',1),(52,'Cote D\'Ivoire','CI','CIV',1),(53,'Croatia','HR','HRV',1),(54,'Cuba','CU','CUB',1),(55,'Cyprus','CY','CYP',1),(56,'Czech Republic','CZ','CZE',1),(57,'Denmark','DK','DNK',1),(58,'Djibouti','DJ','DJI',1),(59,'Dominica','DM','DMA',1),(60,'Dominican Republic','DO','DOM',1),(61,'Timor-Leste','TL','TLS',1),(62,'Ecuador','EC','ECU',1),(63,'Egypt','EG','EGY',1),(64,'El Salvador','SV','SLV',1),(65,'Equatorial Guinea','GQ','GNQ',1),(66,'Eritrea','ER','ERI',1),(67,'Estonia','EE','EST',1),(68,'Ethiopia','ET','ETH',1),(69,'Falkland Islands (Malvinas)','FK','FLK',1),(70,'Faroe Islands','FO','FRO',1),(71,'Fiji','FJ','FJI',1),(72,'Finland','FI','FIN',1),(73,'France','FR','FRA',1),(75,'French Guiana','GF','GUF',1),(76,'French Polynesia','PF','PYF',1),(77,'French Southern Territories','TF','ATF',1),(78,'Gabon','GA','GAB',1),(79,'Gambia','GM','GMB',1),(80,'Georgia','GE','GEO',1),(81,'Germany','DE','DEU',5),(82,'Ghana','GH','GHA',1),(83,'Gibraltar','GI','GIB',1),(84,'Greece','GR','GRC',1),(85,'Greenland','GL','GRL',1),(86,'Grenada','GD','GRD',1),(87,'Guadeloupe','GP','GLP',1),(88,'Guam','GU','GUM',1),(89,'Guatemala','GT','GTM',1),(90,'Guinea','GN','GIN',1),(91,'Guinea-bissau','GW','GNB',1),(92,'Guyana','GY','GUY',1),(93,'Haiti','HT','HTI',1),(94,'Heard and Mc Donald Islands','HM','HMD',1),(95,'Honduras','HN','HND',1),(96,'Hong Kong','HK','HKG',1),(97,'Hungary','HU','HUN',1),(98,'Iceland','IS','ISL',1),(99,'India','IN','IND',1),(100,'Indonesia','ID','IDN',1),(101,'Iran (Islamic Republic of)','IR','IRN',1),(102,'Iraq','IQ','IRQ',1),(103,'Ireland','IE','IRL',1),(104,'Israel','IL','ISR',1),(105,'Italy','IT','ITA',1),(106,'Jamaica','JM','JAM',1),(107,'Japan','JP','JPN',1),(108,'Jordan','JO','JOR',1),(109,'Kazakhstan','KZ','KAZ',1),(110,'Kenya','KE','KEN',1),(111,'Kiribati','KI','KIR',1),(112,'Korea, Democratic People\'s Republic of','KP','PRK',1),(113,'Korea, Republic of','KR','KOR',1),(114,'Kuwait','KW','KWT',1),(115,'Kyrgyzstan','KG','KGZ',1),(116,'Lao People\'s Democratic Republic','LA','LAO',1),(117,'Latvia','LV','LVA',1),(118,'Lebanon','LB','LBN',1),(119,'Lesotho','LS','LSO',1),(120,'Liberia','LR','LBR',1),(121,'Libyan Arab Jamahiriya','LY','LBY',1),(122,'Liechtenstein','LI','LIE',1),(123,'Lithuania','LT','LTU',1),(124,'Luxembourg','LU','LUX',1),(125,'Macao','MO','MAC',1),(126,'Macedonia, The Former Yugoslav Republic of','MK','MKD',1),(127,'Madagascar','MG','MDG',1),(128,'Malawi','MW','MWI',1),(129,'Malaysia','MY','MYS',1),(130,'Maldives','MV','MDV',1),(131,'Mali','ML','MLI',1),(132,'Malta','MT','MLT',1),(133,'Marshall Islands','MH','MHL',1),(134,'Martinique','MQ','MTQ',1),(135,'Mauritania','MR','MRT',1),(136,'Mauritius','MU','MUS',1),(137,'Mayotte','YT','MYT',1),(138,'Mexico','MX','MEX',1),(139,'Micronesia, Federated States of','FM','FSM',1),(140,'Moldova','MD','MDA',1),(141,'Monaco','MC','MCO',1),(142,'Mongolia','MN','MNG',1),(143,'Montserrat','MS','MSR',1),(144,'Morocco','MA','MAR',1),(145,'Mozambique','MZ','MOZ',1),(146,'Myanmar','MM','MMR',1),(147,'Namibia','NA','NAM',1),(148,'Nauru','NR','NRU',1),(149,'Nepal','NP','NPL',1),(150,'Netherlands','NL','NLD',1),(151,'Netherlands Antilles','AN','ANT',1),(152,'New Caledonia','NC','NCL',1),(153,'New Zealand','NZ','NZL',1),(154,'Nicaragua','NI','NIC',1),(155,'Niger','NE','NER',1),(156,'Nigeria','NG','NGA',1),(157,'Niue','NU','NIU',1),(158,'Norfolk Island','NF','NFK',1),(159,'Northern Mariana Islands','MP','MNP',1),(160,'Norway','NO','NOR',1),(161,'Oman','OM','OMN',1),(162,'Pakistan','PK','PAK',1),(163,'Palau','PW','PLW',1),(164,'Panama','PA','PAN',1),(165,'Papua New Guinea','PG','PNG',1),(166,'Paraguay','PY','PRY',1),(167,'Peru','PE','PER',1),(168,'Philippines','PH','PHL',1),(169,'Pitcairn','PN','PCN',1),(170,'Poland','PL','POL',1),(171,'Portugal','PT','PRT',1),(172,'Puerto Rico','PR','PRI',1),(173,'Qatar','QA','QAT',1),(174,'Reunion','RE','REU',1),(175,'Romania','RO','ROU',1),(176,'Russian Federation','RU','RUS',1),(177,'Rwanda','RW','RWA',1),(178,'Saint Kitts and Nevis','KN','KNA',1),(179,'Saint Lucia','LC','LCA',1),(180,'Saint Vincent and the Grenadines','VC','VCT',1),(181,'Samoa','WS','WSM',1),(182,'San Marino','SM','SMR',1),(183,'Sao Tome and Principe','ST','STP',1),(184,'Saudi Arabia','SA','SAU',1),(185,'Senegal','SN','SEN',1),(186,'Seychelles','SC','SYC',1),(187,'Sierra Leone','SL','SLE',1),(188,'Singapore','SG','SGP',4),(189,'Slovakia (Slovak Republic)','SK','SVK',1),(190,'Slovenia','SI','SVN',1),(191,'Solomon Islands','SB','SLB',1),(192,'Somalia','SO','SOM',1),(193,'South Africa','ZA','ZAF',1),(194,'South Georgia and the South Sandwich Islands','GS','SGS',1),(195,'Spain','ES','ESP',3),(196,'Sri Lanka','LK','LKA',1),(197,'St. Helena','SH','SHN',1),(198,'St. Pierre and Miquelon','PM','SPM',1),(199,'Sudan','SD','SDN',1),(200,'Suriname','SR','SUR',1),(201,'Svalbard and Jan Mayen Islands','SJ','SJM',1),(202,'Swaziland','SZ','SWZ',1),(203,'Sweden','SE','SWE',1),(204,'Switzerland','CH','CHE',1),(205,'Syrian Arab Republic','SY','SYR',1),(206,'Taiwan','TW','TWN',1),(207,'Tajikistan','TJ','TJK',1),(208,'Tanzania, United Republic of','TZ','TZA',1),(209,'Thailand','TH','THA',1),(210,'Togo','TG','TGO',1),(211,'Tokelau','TK','TKL',1),(212,'Tonga','TO','TON',1),(213,'Trinidad and Tobago','TT','TTO',1),(214,'Tunisia','TN','TUN',1),(215,'Turkey','TR','TUR',1),(216,'Turkmenistan','TM','TKM',1),(217,'Turks and Caicos Islands','TC','TCA',1),(218,'Tuvalu','TV','TUV',1),(219,'Uganda','UG','UGA',1),(220,'Ukraine','UA','UKR',1),(221,'United Arab Emirates','AE','ARE',1),(222,'United Kingdom','GB','GBR',6),(223,'United States','US','USA',2),(224,'United States Minor Outlying Islands','UM','UMI',1),(225,'Uruguay','UY','URY',1),(226,'Uzbekistan','UZ','UZB',1),(227,'Vanuatu','VU','VUT',1),(228,'Vatican City State (Holy See)','VA','VAT',1),(229,'Venezuela','VE','VEN',1),(230,'Viet Nam','VN','VNM',1),(231,'Virgin Islands (British)','VG','VGB',1),(232,'Virgin Islands (U.S.)','VI','VIR',1),(233,'Wallis and Futuna Islands','WF','WLF',1),(234,'Western Sahara','EH','ESH',1),(235,'Yemen','YE','YEM',1),(236,'Serbia','RS','SRB',1),(238,'Zambia','ZM','ZMB',1),(239,'Zimbabwe','ZW','ZWE',1);

--
-- Table structure for table `zen_coupon_email_track`
--

CREATE TABLE `zen_coupon_email_track` (
  `unique_id` int(11) NOT NULL AUTO_INCREMENT,
  `coupon_id` int(11) NOT NULL DEFAULT '0',
  `customer_id_sent` int(11) NOT NULL DEFAULT '0',
  `sent_firstname` varchar(32) DEFAULT NULL,
  `sent_lastname` varchar(32) DEFAULT NULL,
  `emailed_to` varchar(32) DEFAULT NULL,
  `date_sent` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
  PRIMARY KEY (`unique_id`),
  KEY `idx_coupon_id_zen` (`coupon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_coupon_email_track`
--


--
-- Table structure for table `zen_coupon_gv_customer`
--

CREATE TABLE `zen_coupon_gv_customer` (
  `customer_id` int(5) NOT NULL DEFAULT '0',
  `amount` decimal(15,4) NOT NULL DEFAULT '0.0000',
  PRIMARY KEY (`customer_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_coupon_gv_customer`
--


--
-- Table structure for table `zen_coupon_gv_queue`
--

CREATE TABLE `zen_coupon_gv_queue` (
  `unique_id` int(5) NOT NULL AUTO_INCREMENT,
  `customer_id` int(5) NOT NULL DEFAULT '0',
  `order_id` int(5) NOT NULL DEFAULT '0',
  `amount` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `date_created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
  `ipaddr` varchar(32) NOT NULL DEFAULT '',
  `release_flag` char(1) NOT NULL DEFAULT 'N',
  PRIMARY KEY (`unique_id`),
  KEY `idx_cust_id_order_id_zen` (`customer_id`,`order_id`),
  KEY `idx_release_flag_zen` (`release_flag`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_coupon_gv_queue`
--


--
-- Table structure for table `zen_coupon_redeem_track`
--

CREATE TABLE `zen_coupon_redeem_track` (
  `unique_id` int(11) NOT NULL AUTO_INCREMENT,
  `coupon_id` int(11) NOT NULL DEFAULT '0',
  `customer_id` int(11) NOT NULL DEFAULT '0',
  `redeem_date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
  `redeem_ip` varchar(32) NOT NULL DEFAULT '',
  `order_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`unique_id`),
  KEY `idx_coupon_id_zen` (`coupon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_coupon_redeem_track`
--


--
-- Table structure for table `zen_coupon_restrict`
--

CREATE TABLE `zen_coupon_restrict` (
  `restrict_id` int(11) NOT NULL AUTO_INCREMENT,
  `coupon_id` int(11) NOT NULL DEFAULT '0',
  `product_id` int(11) NOT NULL DEFAULT '0',
  `category_id` int(11) NOT NULL DEFAULT '0',
  `coupon_restrict` char(1) NOT NULL DEFAULT 'N',
  PRIMARY KEY (`restrict_id`),
  KEY `idx_coup_id_prod_id_zen` (`coupon_id`,`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_coupon_restrict`
--


--
-- Table structure for table `zen_coupons`
--

CREATE TABLE `zen_coupons` (
  `coupon_id` int(11) NOT NULL AUTO_INCREMENT,
  `coupon_type` char(1) NOT NULL DEFAULT 'F',
  `coupon_code` varchar(32) NOT NULL DEFAULT '',
  `coupon_amount` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `coupon_minimum_order` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `coupon_start_date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
  `coupon_expire_date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
  `uses_per_coupon` int(5) NOT NULL DEFAULT '1',
  `uses_per_user` int(5) NOT NULL DEFAULT '0',
  `restrict_to_products` varchar(255) DEFAULT NULL,
  `restrict_to_categories` varchar(255) DEFAULT NULL,
  `restrict_to_customers` text,
  `coupon_active` char(1) NOT NULL DEFAULT 'Y',
  `date_created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
  `date_modified` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
  `coupon_zone_restriction` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`coupon_id`),
  KEY `idx_active_type_zen` (`coupon_active`,`coupon_type`),
  KEY `idx_coupon_code_zen` (`coupon_code`),
  KEY `idx_coupon_type_zen` (`coupon_type`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_coupons`
--

INSERT INTO `zen_coupons` VALUES (1,'P','MARCH-1234',15.0000,10.0000,'2010-03-05 00:00:00','2011-04-05 00:00:00',30,30,'','',NULL,'Y','2010-03-05 13:19:50','2010-03-05 13:19:50',0);

--
-- Table structure for table `zen_coupons_description`
--

CREATE TABLE `zen_coupons_description` (
  `coupon_id` int(11) NOT NULL DEFAULT '0',
  `language_id` int(11) NOT NULL DEFAULT '0',
  `coupon_name` varchar(32) NOT NULL DEFAULT '',
  `coupon_description` text,
  PRIMARY KEY (`coupon_id`,`language_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_coupons_description`
--

INSERT INTO `zen_coupons_description` VALUES (1,1,'Spring Special Delight','15 % Off for All Online Orders During March. Use the coupon as often as you like for the entire month!');

--
-- Table structure for table `zen_currencies`
--

CREATE TABLE `zen_currencies` (
  `currencies_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(32) NOT NULL DEFAULT '',
  `code` char(3) NOT NULL DEFAULT '',
  `symbol_left` varchar(24) DEFAULT NULL,
  `symbol_right` varchar(24) DEFAULT NULL,
  `decimal_point` char(1) DEFAULT NULL,
  `thousands_point` char(1) DEFAULT NULL,
  `decimal_places` char(1) DEFAULT NULL,
  `value` float(13,8) DEFAULT NULL,
  `last_updated` datetime DEFAULT NULL,
  PRIMARY KEY (`currencies_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_currencies`
--

INSERT INTO `zen_currencies` VALUES (1,'US Dollar','USD','$','','.',',','2',1.00000000,'2010-03-04 18:39:23'),(2,'Euro','EUR','&euro;','','.',',','2',0.74129999,'2010-03-04 18:39:23'),(3,'GB Pound','GBP','&pound;','','.',',','2',0.50300002,'2010-03-04 18:39:23'),(4,'Canadian Dollar','CAD','$','','.',',','2',1.10590005,'2010-03-04 18:39:23'),(5,'Australian Dollar','AUD','$','','.',',','2',1.24070001,'2010-03-04 18:39:23');

--
-- Table structure for table `zen_customers_basket`
--

CREATE TABLE `zen_customers_basket` (
  `customers_basket_id` int(11) NOT NULL AUTO_INCREMENT,
  `customers_id` int(11) NOT NULL DEFAULT '0',
  `products_id` tinytext NOT NULL,
  `customers_basket_quantity` float NOT NULL DEFAULT '0',
  `final_price` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `customers_basket_date_added` varchar(8) DEFAULT NULL,
  PRIMARY KEY (`customers_basket_id`),
  KEY `idx_customers_id_zen` (`customers_id`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_customers_basket`
--

INSERT INTO `zen_customers_basket` VALUES (18,2,'3:9d2458150f98263abbde3fa39f5a952c',1,0.0000,'20110108');

--
-- Table structure for table `zen_customers_basket_attributes`
--

CREATE TABLE `zen_customers_basket_attributes` (
  `customers_basket_attributes_id` int(11) NOT NULL AUTO_INCREMENT,
  `customers_id` int(11) NOT NULL DEFAULT '0',
  `products_id` tinytext NOT NULL,
  `products_options_id` varchar(64) NOT NULL DEFAULT '0',
  `products_options_value_id` int(11) NOT NULL DEFAULT '0',
  `products_options_value_text` blob,
  `products_options_sort_order` text NOT NULL,
  PRIMARY KEY (`customers_basket_attributes_id`),
  KEY `idx_cust_id_prod_id_zen` (`customers_id`,`products_id`(36))
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_customers_basket_attributes`
--

INSERT INTO `zen_customers_basket_attributes` VALUES (9,2,'3:9d2458150f98263abbde3fa39f5a952c','1',1,'','0.00000');

--
-- Table structure for table `zen_customers_info`
--

CREATE TABLE `zen_customers_info` (
  `customers_info_id` int(11) NOT NULL DEFAULT '0',
  `customers_info_date_of_last_logon` datetime DEFAULT NULL,
  `customers_info_number_of_logons` int(5) DEFAULT NULL,
  `customers_info_date_account_created` datetime DEFAULT NULL,
  `customers_info_date_account_last_modified` datetime DEFAULT NULL,
  `global_product_notifications` int(1) DEFAULT '0',
  PRIMARY KEY (`customers_info_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_customers_info`
--

INSERT INTO `zen_customers_info` VALUES (1,'2010-04-02 20:00:13',4,'2010-03-31 19:21:26',NULL,0),(2,'2011-01-08 17:08:28',6,'2011-01-08 10:00:07',NULL,0),(3,'2011-05-24 22:36:56',3,'2011-05-24 21:53:33',NULL,0),(4,'2011-05-25 22:55:38',2,'2011-05-25 22:55:38',NULL,0),(5,'2011-07-07 19:43:02',1,'2011-07-07 19:43:02',NULL,0);

--
-- Table structure for table `zen_customers_wishlist`
--

CREATE TABLE `zen_customers_wishlist` (
  `products_id` int(13) NOT NULL DEFAULT '0',
  `customers_id` int(13) NOT NULL DEFAULT '0',
  `products_model` varchar(13) DEFAULT NULL,
  `products_name` varchar(64) NOT NULL DEFAULT '',
  `products_price` decimal(8,2) NOT NULL DEFAULT '0.00',
  `final_price` decimal(8,2) NOT NULL DEFAULT '0.00',
  `products_quantity` int(2) NOT NULL DEFAULT '0',
  `wishlist_name` varchar(64) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_customers_wishlist`
--


--
-- Table structure for table `zen_db_cache`
--

CREATE TABLE `zen_db_cache` (
  `cache_entry_name` varchar(64) NOT NULL DEFAULT '',
  `cache_data` mediumblob,
  `cache_entry_created` int(15) DEFAULT NULL,
  PRIMARY KEY (`cache_entry_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_db_cache`
--


--
-- Table structure for table `zen_email_archive`
--

CREATE TABLE `zen_email_archive` (
  `archive_id` int(11) NOT NULL AUTO_INCREMENT,
  `email_to_name` varchar(96) NOT NULL DEFAULT '',
  `email_to_address` varchar(96) NOT NULL DEFAULT '',
  `email_from_name` varchar(96) NOT NULL DEFAULT '',
  `email_from_address` varchar(96) NOT NULL DEFAULT '',
  `email_subject` varchar(255) NOT NULL DEFAULT '',
  `email_html` text NOT NULL,
  `email_text` text NOT NULL,
  `date_sent` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
  `module` varchar(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`archive_id`),
  KEY `idx_email_to_address_zen` (`email_to_address`),
  KEY `idx_module_zen` (`module`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_email_archive`
--


--
-- Table structure for table `zen_ezpages`
--

CREATE TABLE `zen_ezpages` (
  `pages_id` int(11) NOT NULL AUTO_INCREMENT,
  `languages_id` int(11) NOT NULL DEFAULT '1',
  `pages_title` varchar(64) NOT NULL DEFAULT '',
  `alt_url` varchar(255) NOT NULL DEFAULT '',
  `alt_url_external` varchar(255) NOT NULL DEFAULT '',
  `pages_html_text` mediumtext,
  `status_header` int(1) NOT NULL DEFAULT '1',
  `status_sidebox` int(1) NOT NULL DEFAULT '1',
  `status_footer` int(1) NOT NULL DEFAULT '1',
  `status_toc` int(1) NOT NULL DEFAULT '1',
  `header_sort_order` int(3) NOT NULL DEFAULT '0',
  `sidebox_sort_order` int(3) NOT NULL DEFAULT '0',
  `footer_sort_order` int(3) NOT NULL DEFAULT '0',
  `toc_sort_order` int(3) NOT NULL DEFAULT '0',
  `page_open_new_window` int(1) NOT NULL DEFAULT '0',
  `page_is_ssl` int(1) NOT NULL DEFAULT '0',
  `toc_chapter` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`pages_id`),
  KEY `idx_lang_id_zen` (`languages_id`),
  KEY `idx_ezp_status_header_zen` (`status_header`),
  KEY `idx_ezp_status_sidebox_zen` (`status_sidebox`),
  KEY `idx_ezp_status_footer_zen` (`status_footer`),
  KEY `idx_ezp_status_toc_zen` (`status_toc`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_ezpages`
--

INSERT INTO `zen_ezpages` VALUES (3,1,'WINE & BEVERAGES','','','<img src=\"includes/templates/cd/images/chinese_delight208b.jpg\" alt=\"Beer and Soft Drinks\" width=\"477\" height=\"633\" />\r\n\r\n<img src=\"includes/templates/cd/images/chinese_delightRedWine.jpg\" alt=\"Red Wines\" width=\"477\" height=\"633\" />\r\n\r\n<img src=\"includes/templates/cd/images/chinese_delightWhiteWine.jpg\" alt=\"White Wines\" width=\"477\" height=\"633\" />',0,1,0,0,0,3,0,3,0,0,0);

--
-- Table structure for table `zen_featured`
--

CREATE TABLE `zen_featured` (
  `featured_id` int(11) NOT NULL AUTO_INCREMENT,
  `products_id` int(11) NOT NULL DEFAULT '0',
  `featured_date_added` datetime DEFAULT NULL,
  `featured_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',
  `featured_date_available` date NOT NULL DEFAULT '0001-01-01',
  PRIMARY KEY (`featured_id`),
  KEY `idx_status_zen` (`status`),
  KEY `idx_products_id_zen` (`products_id`),
  KEY `idx_date_avail_zen` (`featured_date_available`),
  KEY `idx_expires_date_zen` (`expires_date`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_featured`
--


--
-- Table structure for table `zen_geo_zones`
--

CREATE TABLE `zen_geo_zones` (
  `geo_zone_id` int(11) NOT NULL AUTO_INCREMENT,
  `geo_zone_name` varchar(32) NOT NULL DEFAULT '',
  `geo_zone_description` varchar(255) NOT NULL DEFAULT '',
  `last_modified` datetime DEFAULT NULL,
  `date_added` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
  PRIMARY KEY (`geo_zone_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_geo_zones`
--

INSERT INTO `zen_geo_zones` VALUES (1,'Florida','Florida local sales tax zone',NULL,'2010-03-04 18:39:23');

--
-- Table structure for table `zen_get_terms_to_filter`
--

CREATE TABLE `zen_get_terms_to_filter` (
  `get_term_name` varchar(255) NOT NULL DEFAULT '',
  `get_term_table` varchar(64) NOT NULL,
  `get_term_name_field` varchar(64) NOT NULL,
  PRIMARY KEY (`get_term_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_get_terms_to_filter`
--

INSERT INTO `zen_get_terms_to_filter` VALUES ('manufacturers_id','TABLE_MANUFACTURERS','manufacturers_name'),('music_genre_id','TABLE_MUSIC_GENRE','music_genre_name'),('record_company_id','TABLE_RECORD_COMPANY','record_company_name');

--
-- Table structure for table `zen_group_pricing`
--

CREATE TABLE `zen_group_pricing` (
  `group_id` int(11) NOT NULL AUTO_INCREMENT,
  `group_name` varchar(32) NOT NULL DEFAULT '',
  `group_percentage` decimal(5,2) NOT NULL DEFAULT '0.00',
  `last_modified` datetime DEFAULT NULL,
  `date_added` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
  PRIMARY KEY (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_group_pricing`
--


--
-- Table structure for table `zen_languages`
--

CREATE TABLE `zen_languages` (
  `languages_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL DEFAULT '',
  `code` char(2) NOT NULL DEFAULT '',
  `image` varchar(64) DEFAULT NULL,
  `directory` varchar(32) DEFAULT NULL,
  `sort_order` int(3) DEFAULT NULL,
  PRIMARY KEY (`languages_id`),
  KEY `idx_languages_name_zen` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_languages`
--

INSERT INTO `zen_languages` VALUES (1,'English','en','icon.gif','english',1);

--
-- Table structure for table `zen_layout_boxes`
--

CREATE TABLE `zen_layout_boxes` (
  `layout_id` int(11) NOT NULL AUTO_INCREMENT,
  `layout_template` varchar(64) NOT NULL DEFAULT '',
  `layout_box_name` varchar(64) NOT NULL DEFAULT '',
  `layout_box_status` tinyint(1) NOT NULL DEFAULT '0',
  `layout_box_location` tinyint(1) NOT NULL DEFAULT '0',
  `layout_box_sort_order` int(11) NOT NULL DEFAULT '0',
  `layout_box_sort_order_single` int(11) NOT NULL DEFAULT '0',
  `layout_box_status_single` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`layout_id`),
  KEY `idx_name_template_zen` (`layout_template`,`layout_box_name`),
  KEY `idx_layout_box_status_zen` (`layout_box_status`),
  KEY `idx_layout_box_sort_order_zen` (`layout_box_sort_order`)
) ENGINE=MyISAM AUTO_INCREMENT=103 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_layout_boxes`
--

INSERT INTO `zen_layout_boxes` VALUES (1,'default_template_settings','banner_box_all.php',1,1,5,0,0),(2,'default_template_settings','banner_box.php',1,0,300,1,127),(3,'default_template_settings','banner_box2.php',1,1,15,1,15),(4,'default_template_settings','best_sellers.php',1,1,30,70,1),(5,'default_template_settings','categories.php',1,0,10,10,1),(6,'default_template_settings','currencies.php',1,1,80,60,1),(7,'default_template_settings','document_categories.php',1,0,0,0,0),(8,'default_template_settings','ezpages.php',1,1,-1,2,1),(9,'default_template_settings','featured.php',1,0,45,0,0),(10,'default_template_settings','information.php',1,0,50,40,1),(11,'default_template_settings','languages.php',1,1,70,50,1),(12,'default_template_settings','manufacturers.php',1,0,30,20,1),(13,'default_template_settings','manufacturer_info.php',1,1,35,95,1),(14,'default_template_settings','more_information.php',1,0,200,200,1),(15,'default_template_settings','music_genres.php',1,1,0,0,0),(16,'default_template_settings','order_history.php',1,1,0,0,0),(17,'default_template_settings','product_notifications.php',1,1,55,85,1),(18,'default_template_settings','record_companies.php',1,1,0,0,0),(19,'default_template_settings','reviews.php',1,0,40,0,0),(20,'default_template_settings','search.php',1,1,10,0,0),(21,'default_template_settings','search_header.php',0,0,0,0,1),(22,'default_template_settings','shopping_cart.php',1,1,20,30,1),(23,'default_template_settings','specials.php',1,1,45,0,0),(24,'default_template_settings','tell_a_friend.php',1,1,65,0,0),(25,'default_template_settings','whats_new.php',1,0,20,0,0),(26,'default_template_settings','whos_online.php',1,1,200,200,1),(27,'template_default','banner_box_all.php',1,1,5,0,0),(28,'template_default','banner_box.php',1,0,300,1,127),(29,'template_default','banner_box2.php',1,1,15,1,15),(30,'template_default','best_sellers.php',1,1,30,70,1),(31,'template_default','categories.php',1,0,10,10,1),(32,'template_default','currencies.php',1,1,80,60,1),(33,'template_default','ezpages.php',1,1,-1,2,1),(34,'template_default','featured.php',1,0,45,0,0),(35,'template_default','information.php',1,0,50,40,1),(36,'template_default','languages.php',1,1,70,50,1),(37,'template_default','manufacturers.php',1,0,30,20,1),(38,'template_default','manufacturer_info.php',1,1,35,95,1),(39,'template_default','more_information.php',1,0,200,200,1),(40,'template_default','my_broken_box.php',1,0,0,0,0),(41,'template_default','order_history.php',1,1,0,0,0),(42,'template_default','product_notifications.php',1,1,55,85,1),(43,'template_default','reviews.php',1,0,40,0,0),(44,'template_default','search.php',1,1,10,0,0),(45,'template_default','search_header.php',0,0,0,0,1),(46,'template_default','shopping_cart.php',1,1,20,30,1),(47,'template_default','specials.php',1,1,45,0,0),(48,'template_default','tell_a_friend.php',1,1,65,0,0),(49,'template_default','whats_new.php',1,0,20,0,0),(50,'template_default','whos_online.php',1,1,200,200,1),(51,'classic','banner_box.php',1,0,300,1,127),(52,'classic','banner_box2.php',1,1,15,1,15),(53,'classic','banner_box_all.php',1,1,5,0,0),(54,'classic','best_sellers.php',1,1,30,70,1),(55,'classic','categories.php',1,0,10,10,1),(56,'classic','currencies.php',1,1,80,60,1),(57,'classic','document_categories.php',1,0,0,0,0),(58,'classic','ezpages.php',1,1,-1,2,1),(59,'classic','featured.php',1,0,45,0,0),(60,'classic','information.php',1,0,50,40,1),(61,'classic','languages.php',1,1,70,50,1),(62,'classic','manufacturers.php',1,0,30,20,1),(63,'classic','manufacturer_info.php',1,1,35,95,1),(64,'classic','more_information.php',1,0,200,200,1),(65,'classic','music_genres.php',1,1,0,0,0),(66,'classic','order_history.php',1,1,0,0,0),(67,'classic','product_notifications.php',1,1,55,85,1),(68,'classic','record_companies.php',1,1,0,0,0),(69,'classic','reviews.php',1,0,40,0,0),(70,'classic','search.php',1,1,10,0,0),(71,'classic','search_header.php',0,0,0,0,1),(72,'classic','shopping_cart.php',1,1,20,30,1),(73,'classic','specials.php',1,1,45,0,0),(74,'classic','tell_a_friend.php',1,1,65,0,0),(75,'classic','whats_new.php',1,0,20,0,0),(76,'classic','whos_online.php',1,1,200,200,1),(77,'cd','banner_box.php',1,0,300,1,127),(78,'cd','banner_box2.php',0,1,15,1,1),(79,'cd','banner_box_all.php',0,1,5,0,0),(80,'cd','best_sellers.php',1,0,30,70,1),(81,'cd','categories.php',1,0,10,10,1),(82,'cd','currencies.php',0,1,80,60,0),(83,'cd','document_categories.php',1,0,0,0,0),(84,'cd','ezpages.php',1,0,10,10,1),(85,'cd','featured.php',1,0,45,0,0),(86,'cd','information.php',1,0,50,40,1),(87,'cd','languages.php',0,1,70,50,0),(88,'cd','manufacturer_info.php',0,1,35,95,0),(89,'cd','manufacturers.php',1,0,30,20,1),(90,'cd','more_information.php',1,0,200,200,1),(91,'cd','music_genres.php',1,1,0,0,0),(92,'cd','order_history.php',0,0,300,300,0),(93,'cd','product_notifications.php',0,1,55,85,0),(94,'cd','record_companies.php',1,1,0,0,0),(95,'cd','reviews.php',1,0,40,0,0),(96,'cd','search.php',0,0,190,0,0),(97,'cd','search_header.php',0,0,0,0,0),(98,'cd','shopping_cart.php',1,0,0,300,1),(99,'cd','specials.php',1,1,7,0,0),(100,'cd','tell_a_friend.php',1,1,65,0,0),(101,'cd','whats_new.php',0,0,20,0,0),(102,'cd','whos_online.php',0,1,200,200,0);

--
-- Table structure for table `zen_manufacturers`
--

CREATE TABLE `zen_manufacturers` (
  `manufacturers_id` int(11) NOT NULL AUTO_INCREMENT,
  `manufacturers_name` varchar(32) NOT NULL DEFAULT '',
  `manufacturers_image` varchar(64) DEFAULT NULL,
  `date_added` datetime DEFAULT NULL,
  `last_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`manufacturers_id`),
  KEY `idx_mfg_name_zen` (`manufacturers_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_manufacturers`
--


--
-- Table structure for table `zen_manufacturers_info`
--

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

--
-- Dumping data for table `zen_manufacturers_info`
--


--
-- Table structure for table `zen_media_clips`
--

CREATE TABLE `zen_media_clips` (
  `clip_id` int(11) NOT NULL AUTO_INCREMENT,
  `media_id` int(11) NOT NULL DEFAULT '0',
  `clip_type` smallint(6) NOT NULL DEFAULT '0',
  `clip_filename` text NOT NULL,
  `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 (`clip_id`),
  KEY `idx_media_id_zen` (`media_id`),
  KEY `idx_clip_type_zen` (`clip_type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_media_clips`
--


--
-- Table structure for table `zen_media_manager`
--

CREATE TABLE `zen_media_manager` (
  `media_id` int(11) NOT NULL AUTO_INCREMENT,
  `media_name` varchar(255) 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',
  PRIMARY KEY (`media_id`),
  KEY `idx_media_name_zen` (`media_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_media_manager`
--


--
-- Table structure for table `zen_media_to_products`
--

CREATE TABLE `zen_media_to_products` (
  `media_id` int(11) NOT NULL DEFAULT '0',
  `product_id` int(11) NOT NULL DEFAULT '0',
  KEY `idx_media_product_zen` (`media_id`,`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_media_to_products`
--


--
-- Table structure for table `zen_media_types`
--

CREATE TABLE `zen_media_types` (
  `type_id` int(11) NOT NULL AUTO_INCREMENT,
  `type_name` varchar(64) NOT NULL DEFAULT '',
  `type_ext` varchar(8) NOT NULL DEFAULT '',
  PRIMARY KEY (`type_id`),
  KEY `idx_type_name_zen` (`type_name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_media_types`
--

INSERT INTO `zen_media_types` VALUES (1,'MP3','.mp3');

--
-- Table structure for table `zen_meta_tags_categories_description`
--

CREATE TABLE `zen_meta_tags_categories_description` (
  `categories_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT '1',
  `metatags_title` varchar(255) NOT NULL DEFAULT '',
  `metatags_keywords` text,
  `metatags_description` text,
  PRIMARY KEY (`categories_id`,`language_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_meta_tags_categories_description`
--


--
-- Table structure for table `zen_meta_tags_products_description`
--

CREATE TABLE `zen_meta_tags_products_description` (
  `products_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT '1',
  `metatags_title` varchar(255) NOT NULL DEFAULT '',
  `metatags_keywords` text,
  `metatags_description` text,
  PRIMARY KEY (`products_id`,`language_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_meta_tags_products_description`
--


--
-- Table structure for table `zen_music_genre`
--

CREATE TABLE `zen_music_genre` (
  `music_genre_id` int(11) NOT NULL AUTO_INCREMENT,
  `music_genre_name` varchar(32) NOT NULL DEFAULT '',
  `date_added` datetime DEFAULT NULL,
  `last_modified` datetime DEFAULT NULL,
  PRIMARY KEY (`music_genre_id`),
  KEY `idx_music_genre_name_zen` (`music_genre_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_music_genre`
--


--
-- Table structure for table `zen_newsletters`
--

CREATE TABLE `zen_newsletters` (
  `newsletters_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `content` text NOT NULL,
  `content_html` text NOT NULL,
  `module` varchar(255) NOT NULL DEFAULT '',
  `date_added` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
  `date_sent` datetime DEFAULT NULL,
  `status` int(1) DEFAULT NULL,
  `locked` int(1) DEFAULT '0',
  PRIMARY KEY (`newsletters_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_newsletters`
--


--
-- Table structure for table `zen_nochex_apc_transactions`
--

CREATE TABLE `zen_nochex_apc_transactions` (
  `nochex_apc_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(11) unsigned NOT NULL DEFAULT '0',
  `nc_transaction_id` varchar(30) NOT NULL,
  `nc_transaction_date` varchar(100) NOT NULL,
  `nc_to_email` varchar(255) NOT NULL,
  `nc_from_email` varchar(255) NOT NULL,
  `nc_order_id` varchar(255) NOT NULL,
  `nc_custom` varchar(255) NOT NULL,
  `nc_amount` decimal(9,2) NOT NULL,
  `nc_security_key` varchar(255) NOT NULL,
  `nc_status` varchar(15) NOT NULL,
  `nochex_response` varchar(255) NOT NULL,
  `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 (`nochex_apc_id`),
  KEY `idx_order_id_zen` (`order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_nochex_apc_transactions`
--


--
-- Table structure for table `zen_orders_products`
--

CREATE TABLE `zen_orders_products` (
  `orders_products_id` int(11) NOT NULL AUTO_INCREMENT,
  `orders_id` int(11) NOT NULL DEFAULT '0',
  `products_id` int(11) NOT NULL DEFAULT '0',
  `products_model` varchar(32) DEFAULT NULL,
  `products_name` varchar(64) NOT NULL DEFAULT '',
  `products_price` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `final_price` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `products_tax` decimal(7,4) NOT NULL DEFAULT '0.0000',
  `products_quantity` float NOT NULL DEFAULT '0',
  `onetime_charges` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `products_priced_by_attribute` tinyint(1) NOT NULL DEFAULT '0',
  `product_is_free` tinyint(1) NOT NULL DEFAULT '0',
  `products_discount_type` tinyint(1) NOT NULL DEFAULT '0',
  `products_discount_type_from` tinyint(1) NOT NULL DEFAULT '0',
  `products_prid` tinytext NOT NULL,
  PRIMARY KEY (`orders_products_id`),
  KEY `idx_orders_id_prod_id_zen` (`orders_id`,`products_id`),
  KEY `idx_prod_id_orders_id_zen` (`products_id`,`orders_id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_orders_products`
--

INSERT INTO `zen_orders_products` VALUES (1,1,131,'','Chop Suey (Served with Rice)',0.0000,5.9500,0.0000,1,0.0000,0,0,0,0,'131:58ffa379ef119dd81538a3cd0ae8432f'),(2,1,128,'','THE MANDARIN DINNER',0.0000,90.6500,0.0000,1,0.0000,0,0,0,0,'128:6c1d114371273c6d429f959ca4afa40c'),(3,2,1,'','CHINESE CHICKEN SALAD',7.9500,7.9500,0.0000,1,0.0000,0,0,0,0,'1'),(4,2,5,'','SWEET AND SOUR SHRIMP',11.2500,11.2500,0.0000,1,0.0000,0,0,0,0,'5'),(5,2,140,'','*  MANDARIN SPICY CHICKEN',5.9500,5.9500,0.0000,1,0.0000,0,0,0,0,'140'),(6,2,143,'','* CHICKEN GREEN BEANS',6.7500,6.7500,0.0000,2,0.0000,0,0,0,0,'143'),(7,2,142,'','SNOW WHITE CHICKEN',5.9500,5.9500,0.0000,1,0.0000,0,0,0,0,'142'),(8,3,115,'','CRABMEAT CHEESE (4)',4.9500,4.9500,0.0000,1,0.0000,0,0,0,0,'115'),(9,4,3,'','EGG DROP SOUP',0.0000,1.7500,0.0000,1,0.0000,0,0,0,0,'3:9d2458150f98263abbde3fa39f5a952c'),(10,5,3,'','EGG DROP SOUP',0.0000,1.7500,0.0000,1,0.0000,0,0,0,0,'3:9d2458150f98263abbde3fa39f5a952c'),(11,6,3,'','EGG DROP SOUP',0.0000,1.7500,0.0000,1,0.0000,0,0,0,0,'3:9d2458150f98263abbde3fa39f5a952c'),(12,7,103,'','PORK FRIED RICE',7.4500,7.4500,0.0000,1,0.0000,0,0,0,0,'103'),(13,8,3,'','EGG DROP SOUP',0.0000,1.7500,0.0000,1,0.0000,0,0,0,0,'3:9d2458150f98263abbde3fa39f5a952c'),(14,9,3,'','EGG DROP SOUP',0.0000,1.7500,0.0000,1,0.0000,0,0,0,0,'3:9d2458150f98263abbde3fa39f5a952c'),(15,10,165,'test01','test',0.1000,0.1000,0.0000,1,0.0000,0,0,0,0,'165:3a98e7b694cf93ceb76f20e3165f04c7'),(16,11,165,'test01','test product dig down',0.1000,0.1000,0.0000,1,0.0000,1,0,0,0,'165:3a98e7b694cf93ceb76f20e3165f04c7');

--
-- Table structure for table `zen_orders_products_attributes`
--

CREATE TABLE `zen_orders_products_attributes` (
  `orders_products_attributes_id` int(11) NOT NULL AUTO_INCREMENT,
  `orders_id` int(11) NOT NULL DEFAULT '0',
  `orders_products_id` int(11) NOT NULL DEFAULT '0',
  `products_options` varchar(32) NOT NULL DEFAULT '',
  `products_options_values` text NOT NULL,
  `options_values_price` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `price_prefix` char(1) NOT NULL DEFAULT '',
  `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_discounted` tinyint(1) NOT NULL DEFAULT '1',
  `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',
  `products_options_id` int(11) NOT NULL DEFAULT '0',
  `products_options_values_id` int(11) NOT NULL DEFAULT '0',
  `products_prid` tinytext NOT NULL,
  PRIMARY KEY (`orders_products_attributes_id`),
  KEY `idx_orders_id_prod_id_zen` (`orders_id`,`orders_products_id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_orders_products_attributes`
--

INSERT INTO `zen_orders_products_attributes` VALUES (1,1,1,'Chop Suey','Chicken, Pork or Vegetable',5.9500,'',1,0,'+',1,1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,5,17,'131:58ffa379ef119dd81538a3cd0ae8432f'),(2,1,2,'Number of Persons','7 Persons',90.6500,'',1,0,'+',1,1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,2,8,'128:6c1d114371273c6d429f959ca4afa40c'),(3,4,9,'Size','Small (8 oz.)',1.7500,'',1,0,'+',1,1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,1,1,'3:9d2458150f98263abbde3fa39f5a952c'),(4,5,10,'Size','Small (8 oz.)',1.7500,'',1,0,'+',1,1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,1,1,'3:9d2458150f98263abbde3fa39f5a952c'),(5,6,11,'Size','Small (8 oz.)',1.7500,'',1,0,'+',1,1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,1,1,'3:9d2458150f98263abbde3fa39f5a952c'),(6,8,13,'Size','Small (8 oz.)',1.7500,'',1,0,'+',1,1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,1,1,'3:9d2458150f98263abbde3fa39f5a952c'),(7,9,14,'Size','Small (8 oz.)',1.7500,'',1,0,'+',1,1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,1,1,'3:9d2458150f98263abbde3fa39f5a952c'),(8,10,15,'download','zip',0.0000,'+',1,0,'+',1,1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,7,29,'165:3a98e7b694cf93ceb76f20e3165f04c7'),(9,11,16,'download','zip',0.0000,'+',1,0,'+',1,1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,7,29,'165:3a98e7b694cf93ceb76f20e3165f04c7');

--
-- Table structure for table `zen_orders_products_download`
--

CREATE TABLE `zen_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 `zen_orders_products_download`
--


--
-- Table structure for table `zen_orders_status`
--

CREATE TABLE `zen_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 `zen_orders_status`
--

INSERT INTO `zen_orders_status` VALUES (1,1,'Pending'),(2,1,'Processing'),(3,1,'Delivered'),(4,1,'Update'),(100,1,'Google New'),(101,1,'Google Processing'),(103,1,'Google Digital Processed'),(105,1,'Google Shipped'),(107,1,'Google Refunded'),(109,1,'Google Shipped and Refunded'),(111,1,'Google Canceled');

--
-- Table structure for table `zen_orders_status_history`
--

CREATE TABLE `zen_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=14 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_orders_status_history`
--

INSERT INTO `zen_orders_status_history` VALUES (1,1,1,'2010-03-31 19:22:43',1,''),(2,2,1,'2010-04-02 19:56:49',1,''),(3,3,1,'2011-01-08 10:03:20',1,'MAKE IT HOT AND SPICY'),(4,4,1,'2011-01-08 10:11:15',1,'HOT N SPICY'),(5,5,1,'2011-01-08 10:54:20',1,'HOT N SPICY BOYS'),(6,6,1,'2011-01-08 11:02:03',1,'HOT N GOOD'),(7,7,1,'2011-01-08 14:17:43',1,'hot n good'),(8,8,1,'2011-01-08 15:56:18',1,'hot n good'),(9,9,1,'2011-01-08 17:09:05',1,'hot n ready'),(10,10,2,'2011-05-24 22:53:21',1,''),(11,10,2,'2011-05-24 22:53:21',0,'Transaction ID: 5K02035550982172A \nPayment Type: PayPal Express Checkout (instant) \nTimestamp: 2011-05-25T03:53:20Z \nPayment Status: Completed \nAmount: 0.10 USD '),(12,11,2,'2011-05-25 22:56:19',1,''),(13,11,2,'2011-05-25 22:56:19',0,'Transaction ID: 1WF82056VF891643W \nPayment Type: PayPal Express Checkout (instant) \nTimestamp: 2011-05-26T03:56:18Z \nPayment Status: Completed \nAmount: 0.10 USD ');

--
-- Table structure for table `zen_orders_total`
--

CREATE TABLE `zen_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`),
  KEY `idx_ot_class_zen` (`class`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_orders_total`
--

INSERT INTO `zen_orders_total` VALUES (1,1,'Sub-Total:','$96.60',96.6000,'ot_subtotal',100),(2,1,'Flat Rate (Best Way):','$5.00',5.0000,'ot_shipping',200),(3,1,'Total:','$101.60',101.6000,'ot_total',999),(4,2,'Sub-Total:','$44.60',44.6000,'ot_subtotal',100),(5,2,'Total:','$44.60',44.6000,'ot_total',999),(6,3,'Sub-Total:','$4.95',4.9500,'ot_subtotal',100),(7,3,'Total:','$4.95',4.9500,'ot_total',999),(8,4,'Sub-Total:','$1.75',1.7500,'ot_subtotal',100),(9,4,'Total:','$1.75',1.7500,'ot_total',999),(10,5,'Sub-Total:','$1.75',1.7500,'ot_subtotal',100),(11,5,'Total:','$1.75',1.7500,'ot_total',999),(12,6,'Sub-Total:','$1.75',1.7500,'ot_subtotal',100),(13,6,'Total:','$1.75',1.7500,'ot_total',999),(14,7,'Sub-Total:','$7.45',7.4500,'ot_subtotal',100),(15,7,'Total:','$7.45',7.4500,'ot_total',999),(16,8,'Sub-Total:','$1.75',1.7500,'ot_subtotal',100),(17,8,'Total:','$1.75',1.7500,'ot_total',999),(18,9,'Sub-Total:','$1.75',1.7500,'ot_subtotal',100),(19,9,'Total:','$1.75',1.7500,'ot_total',999),(20,10,'Sub-Total:','$0.10',0.1000,'ot_subtotal',100),(21,10,'Total:','$0.10',0.1000,'ot_total',999),(22,11,'Sub-Total:','$0.10',0.1000,'ot_subtotal',100),(23,11,'Total:','$0.10',0.1000,'ot_total',999);

--
-- Table structure for table `zen_paypal`
--

CREATE TABLE `zen_paypal` (
  `paypal_ipn_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(11) unsigned NOT NULL DEFAULT '0',
  `txn_type` varchar(40) NOT NULL DEFAULT '',
  `module_name` varchar(40) NOT NULL DEFAULT '',
  `module_mode` varchar(40) NOT NULL DEFAULT '',
  `reason_code` varchar(40) DEFAULT NULL,
  `payment_type` varchar(40) NOT NULL DEFAULT '',
  `payment_status` varchar(32) NOT NULL DEFAULT '',
  `pending_reason` varchar(32) DEFAULT NULL,
  `invoice` varchar(128) 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(128) DEFAULT NULL,
  `address_name` varchar(64) DEFAULT NULL,
  `address_street` varchar(254) DEFAULT NULL,
  `address_city` varchar(120) DEFAULT NULL,
  `address_state` varchar(120) DEFAULT NULL,
  `address_zip` varchar(10) DEFAULT NULL,
  `address_country` varchar(64) DEFAULT NULL,
  `address_status` varchar(11) DEFAULT NULL,
  `payer_email` varchar(128) 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(128) NOT NULL DEFAULT '',
  `receiver_email` varchar(128) NOT NULL DEFAULT '',
  `receiver_id` varchar(32) NOT NULL DEFAULT '',
  `txn_id` varchar(20) NOT NULL DEFAULT '',
  `parent_txn_id` varchar(20) 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` varchar(6) NOT NULL DEFAULT '',
  `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_order_id_zen` (`order_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_paypal`
--

INSERT INTO `zen_paypal` VALUES (1,10,'expresscheckout','paypalwpp','PayPal','None','PayPal Express Checkout (instant)','Completed','None','EC-13P49337UB2738432','USD','John','Brake','','John Brake','2210 Ridgewood Circle','Royal Palm Beach','FL','33411','','Confirmed','jack.b@aaasurvivalproducts.com','7AUEEUBBE22H4','unverified','2011-05-25 03:53:20','','eorder.adirondakchairs.net','','5K02035550982172A','',1,0.10,0.10,NULL,NULL,0.00,'USD',1.00,'0','','0001-01-01 00:00:00','2011-05-24 22:53:21','{Record generated by payment module}'),(2,11,'expresscheckout','paypalwpp','PayPal','None','PayPal Express Checkout (instant)','Completed','None','EC-8YD88380SM970580L','USD','John','Brake','','John Brake','9079 Pierson Rd','Fowlerville','MI','48836','','Confirmed','jbrake@nsconstruct.com','3C7X2QVAB5RJL','unverified','2011-05-26 03:56:18','','eorder.adirondakchairs.net','','1WF82056VF891643W','',1,0.10,0.10,NULL,NULL,0.00,'USD',1.00,'0','','0001-01-01 00:00:00','2011-05-25 22:56:19','{Record generated by payment module}');

--
-- Table structure for table `zen_paypal_payment_status`
--

CREATE TABLE `zen_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 `zen_paypal_payment_status`
--

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

--
-- Table structure for table `zen_paypal_payment_status_history`
--

CREATE TABLE `zen_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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_paypal_payment_status_history`
--


--
-- Table structure for table `zen_paypal_testing`
--

CREATE TABLE `zen_paypal_testing` (
  `paypal_ipn_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(11) unsigned NOT NULL DEFAULT '0',
  `custom` varchar(255) NOT NULL DEFAULT '',
  `txn_type` varchar(40) NOT NULL DEFAULT '',
  `module_name` varchar(40) NOT NULL DEFAULT '',
  `module_mode` varchar(40) NOT NULL DEFAULT '',
  `reason_code` varchar(40) DEFAULT NULL,
  `payment_type` varchar(40) NOT NULL DEFAULT '',
  `payment_status` varchar(32) NOT NULL DEFAULT '',
  `pending_reason` varchar(32) DEFAULT NULL,
  `invoice` varchar(128) 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(128) DEFAULT NULL,
  `address_name` varchar(64) DEFAULT NULL,
  `address_street` varchar(254) DEFAULT NULL,
  `address_city` varchar(120) DEFAULT NULL,
  `address_state` varchar(120) DEFAULT NULL,
  `address_zip` varchar(10) DEFAULT NULL,
  `address_country` varchar(64) DEFAULT NULL,
  `address_status` varchar(11) DEFAULT NULL,
  `payer_email` varchar(128) 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(128) NOT NULL DEFAULT '',
  `receiver_email` varchar(128) NOT NULL DEFAULT '',
  `receiver_id` varchar(32) NOT NULL DEFAULT '',
  `txn_id` varchar(20) NOT NULL DEFAULT '',
  `parent_txn_id` varchar(20) 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_order_id_zen` (`order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_paypal_testing`
--


--
-- Table structure for table `zen_product_music_extra`
--

CREATE TABLE `zen_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`),
  KEY `idx_artists_id_zen` (`artists_id`),
  KEY `idx_record_company_id_zen` (`record_company_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_product_music_extra`
--


--
-- Table structure for table `zen_product_type_layout`
--

CREATE TABLE `zen_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)),
  KEY `idx_type_id_sort_order_zen` (`product_type_id`,`sort_order`)
) ENGINE=MyISAM AUTO_INCREMENT=144 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_product_type_layout`
--

INSERT INTO `zen_product_type_layout` VALUES (1,'Show Model Number','SHOW_PRODUCT_INFO_MODEL','0','Display Model Number on Product Info 0= off 1= on',1,1,'2010-03-05 11:27:24','2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(2,'Show Weight','SHOW_PRODUCT_INFO_WEIGHT','0','Display Weight on Product Info 0= off 1= on',1,2,'2010-03-04 22:35:15','2010-03-04 18:39:24',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','0','Display Attribute Weight on Product Info 0= off 1= on',1,3,'2010-03-04 22:35:26','2010-03-04 18:39:24',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,'2010-03-04 18:39:24',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,'2010-03-04 18:39:24',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','0','Display Quantity in Stock on Product Info 0= off 1= on',1,6,'2010-03-04 22:20:08','2010-03-04 18:39:24',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','0','Display Product Reviews Count on Product Info 0= off 1= on',1,7,'2010-03-04 22:20:25','2010-03-04 18:39:24',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,'2010-03-04 18:39:24',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','0','Display Date Available on Product Info 0= off 1= on',1,9,'2010-03-05 11:28:27','2010-03-04 18:39:24',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','0','Display Date Added on Product Info 0= off 1= on',1,10,'2010-03-05 11:28:12','2010-03-04 18:39:24',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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(12,'Show Product Additional Images','SHOW_PRODUCT_INFO_ADDITIONAL_IMAGES','1','Display Additional Images on Product Info 0= off 1= on',1,13,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(13,'Show Starting At text on Price','SHOW_PRODUCT_INFO_STARTING_AT','0','Display Starting At text on products with attributes Product Info 0= off 1= on',1,12,'2010-03-25 10:31:20','2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(14,'Show Product Tell a Friend button','SHOW_PRODUCT_INFO_TELL_A_FRIEND','0','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,'2010-03-04 22:20:45','2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(15,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(16,'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,'2010-03-04 18:39:24','',''),(17,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(18,'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?<br />Yes, Always Free Shipping ON<br />No, Always Free Shipping OFF<br />Special, Product/Download Requires Shipping',1,102,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes, Always ON\'), array(\'id\'=>\'0\', \'text\'=>\'No, Always OFF\'), array(\'id\'=>\'2\', \'text\'=>\'Special\')), '),(19,'Show Model Number','SHOW_PRODUCT_MUSIC_INFO_MODEL','1','Display Model Number on Product Info 0= off 1= on',2,1,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(20,'Show Weight','SHOW_PRODUCT_MUSIC_INFO_WEIGHT','0','Display Weight on Product Info 0= off 1= on',2,2,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(21,'Show Attribute Weight','SHOW_PRODUCT_MUSIC_INFO_WEIGHT_ATTRIBUTES','1','Display Attribute Weight on Product Info 0= off 1= on',2,3,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(22,'Show Artist','SHOW_PRODUCT_MUSIC_INFO_ARTIST','1','Display Artists Name on Product Info 0= off 1= on',2,4,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(23,'Show Music Genre','SHOW_PRODUCT_MUSIC_INFO_GENRE','1','Display Music Genre on Product Info 0= off 1= on',2,4,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(24,'Show Record Company','SHOW_PRODUCT_MUSIC_INFO_RECORD_COMPANY','1','Display Record Company on Product Info 0= off 1= on',2,4,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(25,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(26,'Show Quantity in Stock','SHOW_PRODUCT_MUSIC_INFO_QUANTITY','0','Display Quantity in Stock on Product Info 0= off 1= on',2,6,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(27,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(28,'Show Product Reviews Button','SHOW_PRODUCT_MUSIC_INFO_REVIEWS','1','Display Product Reviews Button on Product Info 0= off 1= on',2,8,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(29,'Show Date Available','SHOW_PRODUCT_MUSIC_INFO_DATE_AVAILABLE','1','Display Date Available on Product Info 0= off 1= on',2,9,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(30,'Show Date Added','SHOW_PRODUCT_MUSIC_INFO_DATE_ADDED','1','Display Date Added on Product Info 0= off 1= on',2,10,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(31,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(32,'Show Product Additional Images','SHOW_PRODUCT_MUSIC_INFO_ADDITIONAL_IMAGES','1','Display Additional Images on Product Info 0= off 1= on',2,13,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(33,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(34,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(35,'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,'2010-03-04 18:39:24','',''),(36,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(37,'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?<br />Yes, Always Free Shipping ON<br />No, Always Free Shipping OFF<br />Special, Product/Download Requires Shipping',2,102,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes, Always ON\'), array(\'id\'=>\'0\', \'text\'=>\'No, Always OFF\'), array(\'id\'=>\'2\', \'text\'=>\'Special\')), '),(38,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(39,'Show Product Reviews Button','SHOW_DOCUMENT_GENERAL_INFO_REVIEWS','1','Display Product Reviews Button on Product Info 0= off 1= on',3,8,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(40,'Show Date Available','SHOW_DOCUMENT_GENERAL_INFO_DATE_AVAILABLE','1','Display Date Available on Product Info 0= off 1= on',3,9,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(41,'Show Date Added','SHOW_DOCUMENT_GENERAL_INFO_DATE_ADDED','1','Display Date Added on Product Info 0= off 1= on',3,10,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(42,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(43,'Show Product URL','SHOW_DOCUMENT_GENERAL_INFO_URL','1','Display URL on Product Info 0= off 1= on',3,11,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(44,'Show Product Additional Images','SHOW_DOCUMENT_GENERAL_INFO_ADDITIONAL_IMAGES','1','Display Additional Images on Product Info 0= off 1= on',3,13,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(45,'Show Model Number','SHOW_DOCUMENT_PRODUCT_INFO_MODEL','1','Display Model Number on Product Info 0= off 1= on',4,1,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(46,'Show Weight','SHOW_DOCUMENT_PRODUCT_INFO_WEIGHT','0','Display Weight on Product Info 0= off 1= on',4,2,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(47,'Show Attribute Weight','SHOW_DOCUMENT_PRODUCT_INFO_WEIGHT_ATTRIBUTES','1','Display Attribute Weight on Product Info 0= off 1= on',4,3,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(48,'Show Manufacturer','SHOW_DOCUMENT_PRODUCT_INFO_MANUFACTURER','1','Display Manufacturer Name on Product Info 0= off 1= on',4,4,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(49,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(50,'Show Quantity in Stock','SHOW_DOCUMENT_PRODUCT_INFO_QUANTITY','0','Display Quantity in Stock on Product Info 0= off 1= on',4,6,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(51,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(52,'Show Product Reviews Button','SHOW_DOCUMENT_PRODUCT_INFO_REVIEWS','1','Display Product Reviews Button on Product Info 0= off 1= on',4,8,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(53,'Show Date Available','SHOW_DOCUMENT_PRODUCT_INFO_DATE_AVAILABLE','1','Display Date Available on Product Info 0= off 1= on',4,9,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(54,'Show Date Added','SHOW_DOCUMENT_PRODUCT_INFO_DATE_ADDED','1','Display Date Added on Product Info 0= off 1= on',4,10,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(55,'Show Product URL','SHOW_DOCUMENT_PRODUCT_INFO_URL','1','Display URL on Product Info 0= off 1= on',4,11,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(56,'Show Product Additional Images','SHOW_DOCUMENT_PRODUCT_INFO_ADDITIONAL_IMAGES','1','Display Additional Images on Product Info 0= off 1= on',4,13,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(57,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(58,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(59,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(60,'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,'2010-03-04 18:39:24','',''),(61,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(62,'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?<br />Yes, Always Free Shipping ON<br />No, Always Free Shipping OFF<br />Special, Product/Download Requires Shipping',4,102,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes, Always ON\'), array(\'id\'=>\'0\', \'text\'=>\'No, Always OFF\'), array(\'id\'=>\'2\', \'text\'=>\'Special\')), '),(63,'Show Model Number','SHOW_PRODUCT_FREE_SHIPPING_INFO_MODEL','1','Display Model Number on Product Info 0= off 1= on',5,1,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(64,'Show Weight','SHOW_PRODUCT_FREE_SHIPPING_INFO_WEIGHT','0','Display Weight on Product Info 0= off 1= on',5,2,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(65,'Show Attribute Weight','SHOW_PRODUCT_FREE_SHIPPING_INFO_WEIGHT_ATTRIBUTES','1','Display Attribute Weight on Product Info 0= off 1= on',5,3,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(66,'Show Manufacturer','SHOW_PRODUCT_FREE_SHIPPING_INFO_MANUFACTURER','1','Display Manufacturer Name on Product Info 0= off 1= on',5,4,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(67,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(68,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(69,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(70,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(71,'Show Date Available','SHOW_PRODUCT_FREE_SHIPPING_INFO_DATE_AVAILABLE','0','Display Date Available on Product Info 0= off 1= on',5,9,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(72,'Show Date Added','SHOW_PRODUCT_FREE_SHIPPING_INFO_DATE_ADDED','1','Display Date Added on Product Info 0= off 1= on',5,10,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(73,'Show Product URL','SHOW_PRODUCT_FREE_SHIPPING_INFO_URL','1','Display URL on Product Info 0= off 1= on',5,11,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(74,'Show Product Additional Images','SHOW_PRODUCT_FREE_SHIPPING_INFO_ADDITIONAL_IMAGES','1','Display Additional Images on Product Info 0= off 1= on',5,13,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(75,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(76,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(77,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(78,'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,'2010-03-04 18:39:24','',''),(79,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(80,'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?<br />Yes, Always Free Shipping ON<br />No, Always Free Shipping OFF<br />Special, Product/Download Requires Shipping',5,102,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes, Always ON\'), array(\'id\'=>\'0\', \'text\'=>\'No, Always OFF\'), array(\'id\'=>\'2\', \'text\'=>\'Special\')), '),(81,'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,'2010-03-04 18:39:24',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_INFO_METATAGS_PRODUCTS_NAME_STATUS','1','Display Product Name in Meta Tags Title 0= off 1= on',1,51,NULL,'2010-03-04 18:39:24',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_INFO_METATAGS_MODEL_STATUS','1','Display Product Model in Meta Tags Title 0= off 1= on',1,52,NULL,'2010-03-04 18:39:24',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_INFO_METATAGS_PRICE_STATUS','1','Display Product Price in Meta Tags Title 0= off 1= on',1,53,NULL,'2010-03-04 18:39:24',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_INFO_METATAGS_TITLE_TAGLINE_STATUS','1','Display Product Tagline in Meta Tags Title 0= off 1= on',1,54,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(86,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(87,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(88,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(89,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(90,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(91,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(92,'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,'2010-03-04 18:39:24',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_GENERAL_INFO_METATAGS_TITLE_TAGLINE_STATUS','1','Display Document Tagline in Meta Tags Title 0= off 1= on',3,54,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(94,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(95,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(96,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(97,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(98,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(99,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(100,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(101,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(102,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(103,'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,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), '),(104,'PRODUCT Attribute is Display Only - Default','DEFAULT_PRODUCT_ATTRIBUTES_DISPLAY_ONLY','0','PRODUCT Attribute is Display Only<br />Used For Display Purposes Only<br />0= No 1= Yes',1,200,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(105,'PRODUCT Attribute is Free - Default','DEFAULT_PRODUCT_ATTRIBUTE_IS_FREE','1','PRODUCT Attribute is Free<br />Attribute is Free When Product is Free<br />0= No 1= Yes',1,201,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(106,'PRODUCT Attribute is Default - Default','DEFAULT_PRODUCT_ATTRIBUTES_DEFAULT','0','PRODUCT Attribute is Default<br />Default Attribute to be Marked Selected<br />0= No 1= Yes',1,202,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(107,'PRODUCT Attribute is Discounted - Default','DEFAULT_PRODUCT_ATTRIBUTES_DISCOUNTED','1','PRODUCT Attribute is Discounted<br />Apply Discounts Used by Product Special/Sale<br />0= No 1= Yes',1,203,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(108,'PRODUCT Attribute is Included in Base Price - Default','DEFAULT_PRODUCT_ATTRIBUTES_PRICE_BASE_INCLUDED','1','PRODUCT Attribute is Included in Base Price<br />Include in Base Price When Priced by Attributes<br />0= No 1= Yes',1,204,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(109,'PRODUCT Attribute is Required - Default','DEFAULT_PRODUCT_ATTRIBUTES_REQUIRED','0','PRODUCT Attribute is Required<br />Attribute Required for Text<br />0= No 1= Yes',1,205,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(110,'PRODUCT Attribute Price Prefix - Default','DEFAULT_PRODUCT_PRICE_PREFIX','1','PRODUCT Attribute Price Prefix<br />Default Attribute Price Prefix for Adding<br />Blank, + or -',1,206,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Blank\'), array(\'id\'=>\'1\', \'text\'=>\'+\'), array(\'id\'=>\'2\', \'text\'=>\'-\')), '),(111,'PRODUCT Attribute Weight Prefix - Default','DEFAULT_PRODUCT_PRODUCTS_ATTRIBUTES_WEIGHT_PREFIX','1','PRODUCT Attribute Weight Prefix<br />Default Attribute Weight Prefix<br />Blank, + or -',1,207,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Blank\'), array(\'id\'=>\'1\', \'text\'=>\'+\'), array(\'id\'=>\'2\', \'text\'=>\'-\')), '),(112,'MUSIC Attribute is Display Only - Default','DEFAULT_PRODUCT_MUSIC_ATTRIBUTES_DISPLAY_ONLY','0','MUSIC Attribute is Display Only<br />Used For Display Purposes Only<br />0= No 1= Yes',2,200,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(113,'MUSIC Attribute is Free - Default','DEFAULT_PRODUCT_MUSIC_ATTRIBUTE_IS_FREE','1','MUSIC Attribute is Free<br />Attribute is Free When Product is Free<br />0= No 1= Yes',2,201,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(114,'MUSIC Attribute is Default - Default','DEFAULT_PRODUCT_MUSIC_ATTRIBUTES_DEFAULT','0','MUSIC Attribute is Default<br />Default Attribute to be Marked Selected<br />0= No 1= Yes',2,202,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(115,'MUSIC Attribute is Discounted - Default','DEFAULT_PRODUCT_MUSIC_ATTRIBUTES_DISCOUNTED','1','MUSIC Attribute is Discounted<br />Apply Discounts Used by Product Special/Sale<br />0= No 1= Yes',2,203,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(116,'MUSIC Attribute is Included in Base Price - Default','DEFAULT_PRODUCT_MUSIC_ATTRIBUTES_PRICE_BASE_INCLUDED','1','MUSIC Attribute is Included in Base Price<br />Include in Base Price When Priced by Attributes<br />0= No 1= Yes',2,204,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(117,'MUSIC Attribute is Required - Default','DEFAULT_PRODUCT_MUSIC_ATTRIBUTES_REQUIRED','0','MUSIC Attribute is Required<br />Attribute Required for Text<br />0= No 1= Yes',2,205,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(118,'MUSIC Attribute Price Prefix - Default','DEFAULT_PRODUCT_MUSIC_PRICE_PREFIX','1','MUSIC Attribute Price Prefix<br />Default Attribute Price Prefix for Adding<br />Blank, + or -',2,206,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Blank\'), array(\'id\'=>\'1\', \'text\'=>\'+\'), array(\'id\'=>\'2\', \'text\'=>\'-\')), '),(119,'MUSIC Attribute Weight Prefix - Default','DEFAULT_PRODUCT_MUSIC_PRODUCTS_ATTRIBUTES_WEIGHT_PREFIX','1','MUSIC Attribute Weight Prefix<br />Default Attribute Weight Prefix<br />Blank, + or -',2,207,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Blank\'), array(\'id\'=>\'1\', \'text\'=>\'+\'), array(\'id\'=>\'2\', \'text\'=>\'-\')), '),(120,'DOCUMENT GENERAL Attribute is Display Only - Default','DEFAULT_DOCUMENT_GENERAL_ATTRIBUTES_DISPLAY_ONLY','0','DOCUMENT GENERAL Attribute is Display Only<br />Used For Display Purposes Only<br />0= No 1= Yes',3,200,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(121,'DOCUMENT GENERAL Attribute is Free - Default','DEFAULT_DOCUMENT_GENERAL_ATTRIBUTE_IS_FREE','1','DOCUMENT GENERAL Attribute is Free<br />Attribute is Free When Product is Free<br />0= No 1= Yes',3,201,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(122,'DOCUMENT GENERAL Attribute is Default - Default','DEFAULT_DOCUMENT_GENERAL_ATTRIBUTES_DEFAULT','0','DOCUMENT GENERAL Attribute is Default<br />Default Attribute to be Marked Selected<br />0= No 1= Yes',3,202,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(123,'DOCUMENT GENERAL Attribute is Discounted - Default','DEFAULT_DOCUMENT_GENERAL_ATTRIBUTES_DISCOUNTED','1','DOCUMENT GENERAL Attribute is Discounted<br />Apply Discounts Used by Product Special/Sale<br />0= No 1= Yes',3,203,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(124,'DOCUMENT GENERAL Attribute is Included in Base Price - Default','DEFAULT_DOCUMENT_GENERAL_ATTRIBUTES_PRICE_BASE_INCLUDED','1','DOCUMENT GENERAL Attribute is Included in Base Price<br />Include in Base Price When Priced by Attributes<br />0= No 1= Yes',3,204,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(125,'DOCUMENT GENERAL Attribute is Required - Default','DEFAULT_DOCUMENT_GENERAL_ATTRIBUTES_REQUIRED','0','DOCUMENT GENERAL Attribute is Required<br />Attribute Required for Text<br />0= No 1= Yes',3,205,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(126,'DOCUMENT GENERAL Attribute Price Prefix - Default','DEFAULT_DOCUMENT_GENERAL_PRICE_PREFIX','1','DOCUMENT GENERAL Attribute Price Prefix<br />Default Attribute Price Prefix for Adding<br />Blank, + or -',3,206,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Blank\'), array(\'id\'=>\'1\', \'text\'=>\'+\'), array(\'id\'=>\'2\', \'text\'=>\'-\')), '),(127,'DOCUMENT GENERAL Attribute Weight Prefix - Default','DEFAULT_DOCUMENT_GENERAL_PRODUCTS_ATTRIBUTES_WEIGHT_PREFIX','1','DOCUMENT GENERAL Attribute Weight Prefix<br />Default Attribute Weight Prefix<br />Blank, + or -',3,207,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Blank\'), array(\'id\'=>\'1\', \'text\'=>\'+\'), array(\'id\'=>\'2\', \'text\'=>\'-\')), '),(128,'DOCUMENT PRODUCT Attribute is Display Only - Default','DEFAULT_DOCUMENT_PRODUCT_ATTRIBUTES_DISPLAY_ONLY','0','DOCUMENT PRODUCT Attribute is Display Only<br />Used For Display Purposes Only<br />0= No 1= Yes',4,200,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(129,'DOCUMENT PRODUCT Attribute is Free - Default','DEFAULT_DOCUMENT_PRODUCT_ATTRIBUTE_IS_FREE','1','DOCUMENT PRODUCT Attribute is Free<br />Attribute is Free When Product is Free<br />0= No 1= Yes',4,201,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(130,'DOCUMENT PRODUCT Attribute is Default - Default','DEFAULT_DOCUMENT_PRODUCT_ATTRIBUTES_DEFAULT','0','DOCUMENT PRODUCT Attribute is Default<br />Default Attribute to be Marked Selected<br />0= No 1= Yes',4,202,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(131,'DOCUMENT PRODUCT Attribute is Discounted - Default','DEFAULT_DOCUMENT_PRODUCT_ATTRIBUTES_DISCOUNTED','1','DOCUMENT PRODUCT Attribute is Discounted<br />Apply Discounts Used by Product Special/Sale<br />0= No 1= Yes',4,203,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(132,'DOCUMENT PRODUCT Attribute is Included in Base Price - Default','DEFAULT_DOCUMENT_PRODUCT_ATTRIBUTES_PRICE_BASE_INCLUDED','1','DOCUMENT PRODUCT Attribute is Included in Base Price<br />Include in Base Price When Priced by Attributes<br />0= No 1= Yes',4,204,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(133,'DOCUMENT PRODUCT Attribute is Required - Default','DEFAULT_DOCUMENT_PRODUCT_ATTRIBUTES_REQUIRED','0','DOCUMENT PRODUCT Attribute is Required<br />Attribute Required for Text<br />0= No 1= Yes',4,205,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(134,'DOCUMENT PRODUCT Attribute Price Prefix - Default','DEFAULT_DOCUMENT_PRODUCT_PRICE_PREFIX','1','DOCUMENT PRODUCT Attribute Price Prefix<br />Default Attribute Price Prefix for Adding<br />Blank, + or -',4,206,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Blank\'), array(\'id\'=>\'1\', \'text\'=>\'+\'), array(\'id\'=>\'2\', \'text\'=>\'-\')), '),(135,'DOCUMENT PRODUCT Attribute Weight Prefix - Default','DEFAULT_DOCUMENT_PRODUCT_PRODUCTS_ATTRIBUTES_WEIGHT_PREFIX','1','DOCUMENT PRODUCT Attribute Weight Prefix<br />Default Attribute Weight Prefix<br />Blank, + or -',4,207,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Blank\'), array(\'id\'=>\'1\', \'text\'=>\'+\'), array(\'id\'=>\'2\', \'text\'=>\'-\')), '),(136,'PRODUCT FREE SHIPPING Attribute is Display Only - Default','DEFAULT_PRODUCT_FREE_SHIPPING_ATTRIBUTES_DISPLAY_ONLY','0','PRODUCT FREE SHIPPING Attribute is Display Only<br />Used For Display Purposes Only<br />0= No 1= Yes',5,201,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(137,'PRODUCT FREE SHIPPING Attribute is Free - Default','DEFAULT_PRODUCT_FREE_SHIPPING_ATTRIBUTE_IS_FREE','1','PRODUCT FREE SHIPPING Attribute is Free<br />Attribute is Free When Product is Free<br />0= No 1= Yes',5,201,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(138,'PRODUCT FREE SHIPPING Attribute is Default - Default','DEFAULT_PRODUCT_FREE_SHIPPING_ATTRIBUTES_DEFAULT','0','PRODUCT FREE SHIPPING Attribute is Default<br />Default Attribute to be Marked Selected<br />0= No 1= Yes',5,202,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(139,'PRODUCT FREE SHIPPING Attribute is Discounted - Default','DEFAULT_PRODUCT_FREE_SHIPPING_ATTRIBUTES_DISCOUNTED','1','PRODUCT FREE SHIPPING Attribute is Discounted<br />Apply Discounts Used by Product Special/Sale<br />0= No 1= Yes',5,203,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(140,'PRODUCT FREE SHIPPING Attribute is Included in Base Price - Default','DEFAULT_PRODUCT_FREE_SHIPPING_ATTRIBUTES_PRICE_BASE_INCLUDED','1','PRODUCT FREE SHIPPING Attribute is Included in Base Price<br />Include in Base Price When Priced by Attributes<br />0= No 1= Yes',5,204,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(141,'PRODUCT FREE SHIPPING Attribute is Required - Default','DEFAULT_PRODUCT_FREE_SHIPPING_ATTRIBUTES_REQUIRED','0','PRODUCT FREE SHIPPING Attribute is Required<br />Attribute Required for Text<br />0= No 1= Yes',5,205,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'Yes\'), array(\'id\'=>\'0\', \'text\'=>\'No\')), '),(142,'PRODUCT FREE SHIPPING Attribute Price Prefix - Default','DEFAULT_PRODUCT_FREE_SHIPPING_PRICE_PREFIX','1','PRODUCT FREE SHIPPING Attribute Price Prefix<br />Default Attribute Price Prefix for Adding<br />Blank, + or -',5,206,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Blank\'), array(\'id\'=>\'1\', \'text\'=>\'+\'), array(\'id\'=>\'2\', \'text\'=>\'-\')), '),(143,'PRODUCT FREE SHIPPING Attribute Weight Prefix - Default','DEFAULT_PRODUCT_FREE_SHIPPING_PRODUCTS_ATTRIBUTES_WEIGHT_PREFIX','1','PRODUCT FREE SHIPPING Attribute Weight Prefix<br />Default Attribute Weight Prefix<br />Blank, + or -',5,207,NULL,'2010-03-04 18:39:24',NULL,'zen_cfg_select_drop_down(array(array(\'id\'=>\'0\', \'text\'=>\'Blank\'), array(\'id\'=>\'1\', \'text\'=>\'+\'), array(\'id\'=>\'2\', \'text\'=>\'-\')), ');

--
-- Table structure for table `zen_product_types`
--

CREATE TABLE `zen_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 `zen_product_types`
--

INSERT INTO `zen_product_types` VALUES (1,'Product - General','product',1,'Y','','2010-03-04 18:39:24','2010-03-04 18:39:24'),(2,'Product - Music','product_music',1,'Y','','2010-03-04 18:39:24','2010-03-04 18:39:24'),(3,'Document - General','document_general',3,'N','','2010-03-04 18:39:24','2010-03-04 18:39:24'),(4,'Document - Product','document_product',3,'Y','','2010-03-04 18:39:24','2010-03-04 18:39:24'),(5,'Product - Free Shipping','product_free_shipping',1,'Y','','2010-03-04 18:39:24','2010-03-04 18:39:24');

--
-- Table structure for table `zen_product_types_to_category`
--

CREATE TABLE `zen_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 `zen_product_types_to_category`
--


--
-- Table structure for table `zen_products`
--

CREATE TABLE `zen_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`),
  KEY `idx_products_date_available_zen` (`products_date_available`),
  KEY `idx_products_ordered_zen` (`products_ordered`),
  KEY `idx_products_model_zen` (`products_model`),
  KEY `idx_products_price_sorter_zen` (`products_price_sorter`),
  KEY `idx_master_categories_id_zen` (`master_categories_id`),
  KEY `idx_products_sort_order_zen` (`products_sort_order`),
  KEY `idx_manufacturers_id_zen` (`manufacturers_id`)
) ENGINE=MyISAM AUTO_INCREMENT=166 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_products`
--

INSERT INTO `zen_products` VALUES (1,1,0,'','medium/chicken.gif',7.9500,1,'2010-03-04 21:33:17','2010-04-02 06:47:27',NULL,0,1,0,0,1,1,1,0,0,0,1,0,1,0,0,0,0,7.9500,4,1,0,0,0,0,0),(2,1,0,'','',6.2500,1,'2010-03-04 21:36:16',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,1,0,0,6.2500,4,1,0,0,0,0,0),(3,1,0,'','',0.0000,1,'2010-03-04 21:38:29','2010-03-25 07:17:53',NULL,0,1,0,0,5,1,1,0,0,0,1,0,1,0,0,0,0,0.0000,5,1,0,0,0,0,0),(4,1,0,'','',0.0000,1,'2010-03-04 21:39:17','2010-03-05 12:38:25',NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,1,0,0,0.0000,5,1,0,0,0,0,0),(5,1,0,'','swsour.gif',11.2500,1,'2010-03-04 21:40:32','2010-03-05 13:27:57',NULL,0,1,0,0,1,1,1,0,0,0,1,0,1,0,0,0,0,11.2500,6,1,0,0,0,0,0),(6,1,0,'','',11.2500,1,'2010-03-04 21:41:03','2010-03-04 21:42:14',NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,1,0,0,11.2500,6,1,0,0,0,0,0),(7,1,0,'','',14.9500,1,'2010-03-24 20:49:13',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,1,0,0,14.9500,7,1,0,0,0,0,0),(8,1,0,'','',13.9500,1,'2010-03-24 20:51:56',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,2,0,0,13.9500,7,1,0,0,0,0,0),(9,1,0,'','',10.5000,1,'2010-03-24 20:52:53',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,3,0,0,10.5000,7,1,0,0,0,0,0),(10,1,0,'','',9.9500,1,'2010-03-24 20:54:32',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,4,0,0,9.9500,7,1,0,0,0,0,0),(11,1,0,'','',10.5000,1,'2010-03-24 20:55:24',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,5,0,0,10.5000,7,1,0,0,0,0,0),(12,1,0,'','',10.5000,1,'2010-03-24 20:56:31',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,5,0,0,10.5000,7,1,0,0,0,0,0),(13,1,0,'','',13.9500,1,'2010-03-24 20:57:22',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,6,0,0,13.9500,7,1,0,0,0,0,0),(14,1,0,'','',13.9500,1,'2010-03-24 20:58:57',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,8,0,0,13.9500,7,1,0,0,0,0,0),(15,1,0,'','',13.9500,1,'2010-03-24 20:59:59',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,9,0,0,13.9500,7,1,0,0,0,0,0),(16,1,0,'','',13.9500,1,'2010-03-24 21:01:05',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,10,0,0,13.9500,7,1,0,0,0,0,0),(17,1,0,'','',13.9500,1,'2010-03-24 21:15:57',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,11,0,0,13.9500,7,1,0,0,0,0,0),(18,1,0,'','',13.9500,1,'2010-03-24 21:17:46',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,12,0,0,13.9500,7,1,0,0,0,0,0),(19,1,0,'','',13.9500,1,'2010-03-24 21:18:51',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,13,0,0,13.9500,7,1,0,0,0,0,0),(20,1,0,'','',13.9500,1,'2010-03-24 21:19:31',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,14,0,0,13.9500,7,1,0,0,0,0,0),(21,1,0,'','',9.9500,1,'2010-03-24 21:22:41',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,15,0,0,9.9500,7,1,0,0,0,0,0),(22,1,0,'','',13.9500,1,'2010-03-24 21:23:23',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,16,0,0,13.9500,7,1,0,0,0,0,0),(23,1,0,'','',13.9500,1,'2010-03-24 21:24:17',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,17,0,0,13.9500,7,1,0,0,0,0,0),(24,1,0,'','',0.0000,1,'2010-03-24 21:26:02',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,18,0,0,0.0000,7,1,0,0,0,0,0),(25,1,0,'','',11.2500,1,'2010-03-25 05:32:42',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,3,0,0,11.2500,6,1,0,0,0,0,0),(26,1,0,'','',11.2500,1,'2010-03-25 05:33:35',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,4,0,0,11.2500,6,1,0,0,0,0,0),(27,1,0,'','',11.2500,1,'2010-03-25 05:34:13',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,5,0,0,11.2500,6,1,0,0,0,0,0),(28,1,0,'','',13.9500,1,'2010-03-25 05:35:25',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,6,0,0,13.9500,6,1,0,0,0,0,0),(29,1,0,'','',13.9500,1,'2010-03-25 05:36:59',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,7,0,0,13.9500,6,1,0,0,0,0,0),(30,1,0,'','',11.2500,1,'2010-03-25 05:38:22',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,9,0,0,11.2500,6,1,0,0,0,0,0),(31,1,0,'','',11.2500,1,'2010-03-25 05:39:23',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,10,0,0,11.2500,6,1,0,0,0,0,0),(32,1,0,'','',11.2500,1,'2010-03-25 05:40:15',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,11,0,0,11.2500,6,1,0,0,0,0,0),(33,1,0,'','',11.2500,1,'2010-03-25 05:40:43',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,12,0,0,11.2500,6,1,0,0,0,0,0),(34,1,0,'','',11.2500,1,'2010-03-25 05:41:11',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,13,0,0,11.2500,6,1,0,0,0,0,0),(35,1,0,'','',8.9500,1,'2010-03-25 05:43:45',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,0,0,0,8.9500,8,1,0,0,0,0,0),(36,1,0,'','',8.9500,1,'2010-03-25 05:44:15',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,1,0,0,8.9500,8,1,0,0,0,0,0),(37,1,0,'','',10.5000,1,'2010-03-25 05:45:04',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,2,0,0,10.5000,8,1,0,0,0,0,0),(38,1,0,'','',10.5000,1,'2010-03-25 05:45:48',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,3,0,0,10.5000,8,1,0,0,0,0,0),(39,1,0,'','',8.9500,1,'2010-03-25 05:46:46',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,4,0,0,8.9500,8,1,0,0,0,0,0),(40,1,0,'','',8.9500,1,'2010-03-25 05:47:19',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,5,0,0,8.9500,8,1,0,0,0,0,0),(41,1,0,'','',8.9500,1,'2010-03-25 05:48:04','2010-03-25 05:48:36',NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,6,0,0,8.9500,8,1,0,0,0,0,0),(42,1,0,'','',8.9500,1,'2010-03-25 05:49:09',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,7,0,0,8.9500,8,1,0,0,0,0,0),(43,1,0,'','',8.9500,1,'2010-03-25 05:49:44',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,8,0,0,8.9500,8,1,0,0,0,0,0),(44,1,0,'','',10.5000,1,'2010-03-25 05:50:23',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,9,0,0,10.5000,8,1,0,0,0,0,0),(45,1,0,'','',13.9500,1,'2010-03-25 05:50:58',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,10,0,0,13.9500,8,1,0,0,0,0,0),(46,1,0,'','',13.9500,1,'2010-03-25 05:51:23',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,11,0,0,13.9500,8,1,0,0,0,0,0),(47,1,0,'','',8.9500,1,'2010-03-25 05:52:37',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,12,0,0,8.9500,8,1,0,0,0,0,0),(48,1,0,'','',10.5000,1,'2010-03-25 05:53:31','2010-03-25 05:53:47',NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,13,0,0,10.5000,8,1,0,0,0,0,0),(49,1,0,'','',8.9500,1,'2010-03-25 05:54:18',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,14,0,0,8.9500,8,1,0,0,0,0,0),(50,1,0,'','',8.9500,1,'2010-03-25 05:55:25',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,15,0,0,8.9500,8,1,0,0,0,0,0),(51,1,0,'','',8.9500,1,'2010-03-25 05:56:17',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,16,0,0,8.9500,8,1,0,0,0,0,0),(52,1,0,'','',8.9500,1,'2010-03-25 05:57:09',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,17,0,0,8.9500,8,1,0,0,0,0,0),(53,1,0,'','',8.9500,1,'2010-03-25 05:57:48',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,18,0,0,8.9500,8,1,0,0,0,0,0),(54,1,0,'','',8.9500,1,'2010-03-25 05:58:09',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,19,0,0,8.9500,8,1,0,0,0,0,0),(55,1,0,'','',8.9500,1,'2010-03-25 05:59:07',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,20,0,0,8.9500,8,1,0,0,0,0,0),(56,1,0,'','',10.5000,1,'2010-03-25 05:59:55',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,21,0,0,10.5000,8,1,0,0,0,0,0),(57,1,0,'','',10.5000,1,'2010-03-25 06:01:59',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,0,0,0,10.5000,9,1,0,0,0,0,0),(58,1,0,'','',10.5000,1,'2010-03-25 06:02:53',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,1,0,0,10.5000,9,1,0,0,0,0,0),(59,1,0,'','',10.5000,1,'2010-03-25 06:03:21',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,2,0,0,10.5000,9,1,0,0,0,0,0),(60,1,0,'','',10.5000,1,'2010-03-25 06:03:51','2010-03-25 06:04:30',NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,4,0,0,10.5000,9,1,0,0,0,0,0),(61,1,0,'','',10.5000,1,'2010-03-25 06:04:17',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,3,0,0,10.5000,9,1,0,0,0,0,0),(62,1,0,'','',10.5000,1,'2010-03-25 06:05:18',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,5,0,0,10.5000,9,1,0,0,0,0,0),(63,1,0,'','',10.5000,1,'2010-03-25 06:06:33',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,6,0,0,10.5000,9,1,0,0,0,0,0),(64,1,0,'','',10.5000,1,'2010-03-25 06:06:57',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,7,0,0,10.5000,9,1,0,0,0,0,0),(65,1,0,'','',10.5000,1,'2010-03-25 06:07:58',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,8,0,0,10.5000,9,1,0,0,0,0,0),(66,1,0,'','',10.5000,1,'2010-03-25 06:08:24',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,9,0,0,10.5000,9,1,0,0,0,0,0),(67,1,0,'','',10.5000,1,'2010-03-25 06:08:53',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,10,0,0,10.5000,9,1,0,0,0,0,0),(68,1,0,'','',8.7500,1,'2010-03-25 06:15:54',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,0,0,0,8.7500,10,1,0,0,0,0,0),(69,1,0,'','',8.7500,1,'2010-03-25 06:16:57',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,1,0,0,8.7500,10,1,0,0,0,0,0),(70,1,0,'','',8.7500,1,'2010-03-25 06:19:01',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,2,0,0,8.7500,10,1,0,0,0,0,0),(71,1,0,'','',10.5000,1,'2010-03-25 06:19:59',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,3,0,0,10.5000,10,1,0,0,0,0,0),(72,1,0,'','',8.7500,1,'2010-03-25 06:20:28',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,4,0,0,8.7500,10,1,0,0,0,0,0),(73,1,0,'','',8.7500,1,'2010-03-25 06:22:36',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,1,0,0,8.7500,11,1,0,0,0,0,0),(74,1,0,'','',8.7500,1,'2010-03-25 06:23:18',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,2,0,0,8.7500,11,1,0,0,0,0,0),(75,1,0,'','',8.7500,1,'2010-03-25 06:24:17',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,3,0,0,8.7500,11,1,0,0,0,0,0),(76,1,0,'','',8.7500,1,'2010-03-25 06:24:47',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,4,0,0,8.7500,11,1,0,0,0,0,0),(77,1,0,'','',8.7500,1,'2010-03-25 06:25:52',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,0,0,0,8.7500,12,1,0,0,0,0,0),(78,1,0,'','',8.7500,1,'2010-03-25 06:26:34',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,1,0,0,8.7500,12,1,0,0,0,0,0),(79,1,0,'','',8.9500,1,'2010-03-25 06:27:14',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,2,0,0,8.9500,12,1,0,0,0,0,0),(80,1,0,'','',11.2500,1,'2010-03-25 06:28:01','2010-03-25 06:28:14',NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,3,0,0,11.2500,12,1,0,0,0,0,0),(81,1,0,'','',13.9500,1,'2010-03-25 06:28:44',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,4,0,0,13.9500,12,1,0,0,0,0,0),(82,1,0,'','',8.7500,1,'2010-03-25 06:30:51',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,0,0,0,8.7500,13,1,0,0,0,0,0),(83,1,0,'','',8.7500,1,'2010-03-25 06:31:33',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,1,0,0,8.7500,13,1,0,0,0,0,0),(84,1,0,'','',8.7500,1,'2010-03-25 06:31:59',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,2,0,0,8.7500,13,1,0,0,0,0,0),(85,1,0,'','',10.5000,1,'2010-03-25 06:32:25',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,3,0,0,10.5000,13,1,0,0,0,0,0),(86,1,0,'','',11.2500,1,'2010-03-25 06:32:48','2010-03-25 06:33:13',NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,4,0,0,11.2500,13,1,0,0,0,0,0),(87,1,0,'','',8.7500,1,'2010-03-25 06:35:05',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,0,0,0,8.7500,14,1,0,0,0,0,0),(88,1,0,'','',8.7500,1,'2010-03-25 06:35:31',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,1,0,0,8.7500,14,1,0,0,0,0,0),(89,1,0,'','',8.9500,1,'2010-03-25 06:35:57',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,2,0,0,8.9500,14,1,0,0,0,0,0),(90,1,0,'','',10.5000,1,'2010-03-25 06:36:29',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,3,0,0,10.5000,14,1,0,0,0,0,0),(91,1,0,'','',11.2500,1,'2010-03-25 06:37:05','2010-03-25 06:37:27',NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,4,0,0,11.2500,14,1,0,0,0,0,0),(92,1,0,'','',8.7500,1,'2010-03-25 06:39:44',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,0,0,0,8.7500,15,1,0,0,0,0,0),(93,1,0,'','',8.7500,1,'2010-03-25 06:40:08',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,1,0,0,8.7500,15,1,0,0,0,0,0),(94,1,0,'','',8.9500,1,'2010-03-25 06:40:33',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,2,0,0,8.9500,15,1,0,0,0,0,0),(95,1,0,'','',10.5000,1,'2010-03-25 06:40:56','2010-03-25 06:41:12',NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,3,0,0,10.5000,15,1,0,0,0,0,0),(96,1,0,'','',11.2500,1,'2010-03-25 06:41:38',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,4,0,0,11.2500,15,1,0,0,0,0,0),(97,1,0,'','',8.7500,1,'2010-03-25 06:43:31','2010-03-25 06:53:12',NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,5,0,0,8.7500,15,1,0,0,0,0,0),(98,1,0,'','',8.7500,1,'2010-03-25 06:43:56','2010-03-25 06:53:28',NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,6,0,0,8.7500,15,1,0,0,0,0,0),(99,1,0,'','',8.9500,1,'2010-03-25 06:44:17','2010-03-25 06:53:46',NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,7,0,0,8.9500,15,1,0,0,0,0,0),(100,1,0,'','',10.5000,1,'2010-03-25 06:44:38','2010-03-25 06:54:16',NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,8,0,0,10.5000,15,1,0,0,0,0,0),(101,1,0,'','',11.2500,1,'2010-03-25 06:45:10','2010-03-25 06:54:38',NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,9,0,0,11.2500,15,1,0,0,0,0,0),(102,1,0,'','',7.4500,1,'2010-03-25 06:55:14',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,0,0,0,7.4500,17,1,0,0,0,0,0),(103,1,0,'','',7.4500,1,'2010-03-25 06:55:42',NULL,NULL,0,1,0,0,1,1,1,0,0,0,1,0,1,0,1,0,0,7.4500,17,1,0,0,0,0,0),(104,1,0,'','',7.4500,1,'2010-03-25 06:56:06',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,2,0,0,7.4500,17,1,0,0,0,0,0),(105,1,0,'','',7.9500,1,'2010-03-25 06:56:35',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,3,0,0,7.9500,17,1,0,0,0,0,0),(106,1,0,'','',8.9500,1,'2010-03-25 06:57:04',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,4,0,0,8.9500,17,1,0,0,0,0,0),(107,1,0,'','',9.4500,1,'2010-03-25 06:57:35',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,5,0,0,9.4500,17,1,0,0,0,0,0),(108,1,0,'','',7.9500,1,'2010-03-25 06:58:02','2010-03-25 06:58:52',NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,6,0,0,7.9500,17,1,0,0,0,0,0),(109,1,0,'','',7.9500,1,'2010-03-25 06:58:36',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,7,0,0,7.9500,17,1,0,0,0,0,0),(110,1,0,'','',7.9500,1,'2010-03-25 06:59:27',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,8,0,0,7.9500,17,1,0,0,0,0,0),(111,1,0,'','',8.4500,1,'2010-03-25 06:59:53',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,9,0,0,8.4500,17,1,0,0,0,0,0),(112,1,0,'','',9.4500,1,'2010-03-25 07:00:24',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,10,0,0,9.4500,17,1,0,0,0,0,0),(113,1,0,'','',9.9500,1,'2010-03-25 07:00:57','2010-03-25 07:01:10',NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,11,0,0,9.9500,17,1,0,0,0,0,0),(115,1,0,'','',4.9500,1,'2010-03-25 07:05:03',NULL,NULL,0,1,0,0,1,1,1,0,0,0,1,0,1,0,2,0,0,4.9500,4,1,0,0,0,0,0),(116,1,0,'','',4.9500,1,'2010-03-25 07:06:42',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,4,0,0,4.9500,4,1,0,0,0,0,0),(117,1,0,'','',1.5000,1,'2010-03-25 07:07:09',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,5,0,0,1.5000,4,1,0,0,0,0,0),(118,1,0,'','',1.5000,1,'2010-03-25 07:07:45',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,6,0,0,1.5000,4,1,0,0,0,0,0),(119,1,0,'','',7.2500,1,'2010-03-25 07:08:18',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,7,0,0,7.2500,4,1,0,0,0,0,0),(120,1,0,'','',5.9500,1,'2010-03-25 07:09:02','2010-03-25 07:09:24',NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,8,0,0,5.9500,4,1,0,0,0,0,0),(121,1,0,'','',4.9500,1,'2010-03-25 07:09:50',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,9,0,0,4.9500,4,1,0,0,0,0,0),(122,1,0,'','',4.9500,1,'2010-03-25 07:10:22',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,10,0,0,4.9500,4,1,0,0,0,0,0),(123,1,0,'','',0.0000,1,'2010-03-25 07:18:48',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,4,0,0,0.0000,5,1,0,0,0,0,0),(124,1,0,'','',0.0000,1,'2010-03-25 07:19:23',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,3,0,0,0.0000,5,1,0,0,0,0,0),(125,1,0,'','',0.0000,1,'2010-03-25 07:19:52',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,5,0,0,0.0000,5,1,0,0,0,0,0),(126,1,0,'','',10.5000,1,'2010-03-25 07:20:36',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,6,0,0,10.5000,5,1,0,0,0,0,0),(128,1,0,'','',0.0000,1,'2010-03-28 18:32:17','2010-03-28 20:51:04',NULL,0,1,0,0,1,1,1,0,0,0,1,0,1,0,0,0,0,0.0000,18,1,0,0,0,0,0),(129,1,0,'','',0.0000,1,'2010-03-28 20:00:12','2010-03-28 20:52:40',NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,1,0,0,0.0000,18,1,0,0,0,0,0),(130,1,0,'','',0.0000,1,'2010-03-28 23:36:15','2010-03-29 13:11:46',NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,0,0,0,0.0000,27,1,0,0,0,0,0),(131,1,0,'','',0.0000,1,'2010-03-28 23:37:33','2010-03-29 13:10:30',NULL,0,1,0,0,1,1,1,0,0,0,1,0,1,0,0,0,0,0.0000,26,1,0,0,0,0,0),(132,1,0,'','',0.0000,1,'2010-03-28 23:38:10','2010-03-29 13:03:03',NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,0,0,0,0.0000,25,1,0,0,0,0,0),(133,1,0,'','',0.0000,1,'2010-03-28 23:38:37','2010-03-29 12:52:52',NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,0,0,0,0.0000,24,1,0,0,0,0,0),(134,1,0,'','',6.7500,1,'2010-03-29 13:22:28',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,1,0,0,6.7500,19,1,0,0,0,0,0),(135,1,0,'','',5.9500,1,'2010-03-29 13:23:12','2010-03-29 13:23:36',NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,2,0,0,5.9500,19,1,0,0,0,0,0),(136,1,0,'','',5.9500,1,'2010-03-29 13:24:22',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,3,0,0,5.9500,19,1,0,0,0,0,0),(137,1,0,'','',5.9500,1,'2010-03-29 13:25:07',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,4,0,0,5.9500,19,1,0,0,0,0,0),(138,1,0,'','',6.7500,1,'2010-03-29 13:25:50',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,5,0,0,6.7500,19,1,0,0,0,0,0),(139,1,0,'','',5.9500,1,'2010-03-29 13:26:40',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,6,0,0,5.9500,19,1,0,0,0,0,0),(140,1,0,'','',5.9500,1,'2010-03-29 13:27:15',NULL,NULL,0,1,0,0,1,1,1,0,0,0,1,0,1,0,7,0,0,5.9500,19,1,0,0,0,0,0),(141,1,0,'','',5.9500,1,'2010-03-29 13:27:59',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,8,0,0,5.9500,19,1,0,0,0,0,0),(142,1,0,'','',5.9500,1,'2010-03-29 13:28:30',NULL,NULL,0,1,0,0,1,1,1,0,0,0,1,0,1,0,9,0,0,5.9500,19,1,0,0,0,0,0),(143,1,0,'','',6.7500,1,'2010-03-29 13:29:16',NULL,NULL,0,1,0,0,2,1,1,0,0,0,1,0,1,0,10,0,0,6.7500,19,1,0,0,0,0,0),(144,1,0,'','',5.9500,1,'2010-03-29 13:29:53',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,11,0,0,5.9500,19,1,0,0,0,0,0),(145,1,0,'','',6.7500,1,'2010-03-29 13:30:27',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,12,0,0,6.7500,19,1,0,0,0,0,0),(146,1,0,'','',6.7500,1,'2010-03-29 13:31:03',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,13,0,0,6.7500,19,1,0,0,0,0,0),(147,1,0,'','',5.9500,1,'2010-03-29 13:31:33',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,14,0,0,5.9500,19,1,0,0,0,0,0),(148,1,0,'','',6.2500,1,'2010-03-29 13:32:48',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,15,0,0,6.2500,20,1,0,0,0,0,0),(149,1,0,'','',6.2500,1,'2010-03-29 13:33:27',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,16,0,0,6.2500,20,1,0,0,0,0,0),(150,1,0,'','',6.2500,1,'2010-03-29 13:33:58',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,17,0,0,6.2500,20,1,0,0,0,0,0),(151,1,0,'','',6.2500,1,'2010-03-29 13:34:29',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,18,0,0,6.2500,20,1,0,0,0,0,0),(152,1,0,'','',6.2500,1,'2010-03-29 13:35:52','2010-03-29 13:37:03',NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,19,0,0,6.2500,20,1,0,0,0,0,0),(153,1,0,'','',6.7500,1,'2010-03-29 13:36:44',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,20,0,0,6.7500,20,1,0,0,0,0,0),(154,1,0,'','',5.9500,1,'2010-03-29 13:38:14',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,21,0,0,5.9500,21,1,0,0,0,0,0),(155,1,0,'','',5.9500,1,'2010-03-29 13:38:56',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,22,0,0,5.9500,21,1,0,0,0,0,0),(156,1,0,'','',5.9500,1,'2010-03-29 13:39:36',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,23,0,0,5.9500,21,1,0,0,0,0,0),(157,1,0,'','',5.9500,1,'2010-03-29 13:40:08',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,24,0,0,5.9500,21,1,0,0,0,0,0),(158,1,0,'','',6.9500,1,'2010-03-29 13:46:55',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,25,0,0,6.9500,22,1,0,0,0,0,0),(159,1,0,'','',6.9500,1,'2010-03-29 13:47:34',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,26,0,0,6.9500,22,1,0,0,0,0,0),(160,1,0,'','',6.9500,1,'2010-03-29 13:48:11',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,27,0,0,6.9500,22,1,0,0,0,0,0),(161,1,0,'','',6.9500,1,'2010-03-29 13:49:00',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,28,0,0,6.9500,22,1,0,0,0,0,0),(162,1,0,'','',5.9500,1,'2010-03-29 13:50:15',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,29,0,0,5.9500,23,1,0,0,0,0,0),(163,1,0,'','',5.9500,1,'2010-03-29 13:52:01',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,30,0,0,5.9500,23,1,0,0,0,0,0),(164,1,0,'','',5.9500,1,'2010-03-29 13:52:39',NULL,NULL,0,1,0,0,0,1,1,0,0,0,1,0,1,0,31,0,0,5.9500,23,1,0,0,0,0,0),(165,1,1000,'test01','chinese_delight24.png',0.1000,1,'2011-05-24 21:04:12','2011-05-25 22:33:16',NULL,0,1,0,0,2,1,1,1,0,0,1,0,0,1,0,0,0,0.1000,28,1,0,0,0,0,0);

--
-- Table structure for table `zen_products_attributes`
--

CREATE TABLE `zen_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`),
  KEY `idx_opt_sort_order_zen` (`products_options_sort_order`)
) ENGINE=MyISAM AUTO_INCREMENT=57 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_products_attributes`
--

INSERT INTO `zen_products_attributes` VALUES (1,3,1,1,1.7500,'',0,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(2,3,1,2,3.5000,'',1,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(3,3,1,3,5.2500,'',2,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(4,4,1,1,1.9500,'',0,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(5,4,1,2,3.9000,'',1,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(6,4,1,3,5.7500,'',2,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(7,123,1,1,1.9500,'+',0,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(8,123,1,2,3.9000,'',1,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(9,123,1,3,5.7500,'',2,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(10,125,1,1,1.9500,'',0,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(11,125,1,2,3.9000,'',1,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(12,125,1,3,5.7500,'',2,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(13,124,1,1,1.9500,'',0,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(14,124,1,2,3.9000,'',1,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(15,124,1,3,5.7500,'',2,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(16,128,2,11,129.5000,'',10,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(17,128,2,4,38.8500,'',0,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(18,128,2,12,25.9000,'',0,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(19,128,2,5,51.8000,'',0,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(20,128,2,6,64.7500,'',0,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(21,128,2,7,77.7000,'',0,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(22,128,2,8,90.6500,'',0,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(23,128,2,9,103.6000,'',0,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(24,128,2,10,116.5500,'',0,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(25,129,2,11,139.5000,'',10,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(26,129,2,12,27.9000,'',2,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(27,129,2,4,41.8500,'',3,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(28,129,2,5,55.8000,'',4,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(29,129,2,6,69.7500,'',5,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(30,129,2,7,83.7000,'',6,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(31,129,2,8,97.6500,'',7,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(32,129,2,9,111.6000,'',8,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(33,129,2,10,125.5500,'',9,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(35,133,3,13,5.9500,'',0,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(36,133,3,14,6.2500,'',1,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(37,133,3,15,6.9500,'',2,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(38,133,3,16,7.4500,'',3,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(46,132,4,28,7.4500,'',3,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(45,132,4,27,6.9500,'',2,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(44,132,4,26,6.2500,'',1,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(43,132,4,25,5.9500,'',0,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(47,131,5,17,5.9500,'',0,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(48,131,5,18,6.2500,'',1,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(49,131,5,20,7.4500,'',3,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(50,131,5,19,6.9500,'',2,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(51,130,6,21,5.9500,'',0,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(52,130,6,22,6.2500,'',1,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(53,130,6,23,6.9500,'',2,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(54,130,6,24,7.4500,'',3,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(55,165,7,29,0.0000,'+',0,1,0,'+',0,0,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0),(56,165,0,0,0.0000,'+',0,1,0,'+',0,1,1,'',1,0.0000,0.0000,0.0000,0.0000,0.0000,'','',0.0000,0,0.0000,0,0);

--
-- Table structure for table `zen_products_attributes_download`
--

CREATE TABLE `zen_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 `zen_products_attributes_download`
--

INSERT INTO `zen_products_attributes_download` VALUES (56,'pdf_sample.zip',1,2);

--
-- Table structure for table `zen_products_description`
--

CREATE TABLE `zen_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=166 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_products_description`
--

INSERT INTO `zen_products_description` VALUES (1,1,'CHINESE CHICKEN SALAD','Crispy chicken tossed with greens, sesame seeds and imperial spices. </br>(For each additional person, increase by a half order)\r\n</br>\r\nServes 1-2','',15),(2,1,'FLAMING PU PU PLATTER','An assortment of fried shrimp, crabmeat cheese, egg rolls, foil wrapped chicken, pot stickers and beef skewers served with flaming habachi. <br />\r\n\r\n(Minimum of 2)<br />\r\nPer Person 6.25','',6),(3,1,'EGG DROP SOUP','','',36),(4,1,'* HOT AND SOUR SOUP','','',14),(5,1,'SWEET AND SOUR SHRIMP','','',10),(6,1,'SHRIMP WITH LOBSTER SAUCE','','',1),(7,1,'HOUSE SPECIAL SIZZLING PLATE','A classic combination of seafood, meat, and vegetables sautéed in a house brown sauce and served on a sizzling hot plate.','',0),(8,1,'TEA SMOKED DUCK','Marinated half duck in a Chinese wok smoked oven burning tea leaves, served with 4 Chinese pancakes, green onion and plum sauce. Haunting flavors.','',0),(9,1,'RAINBOW CHICKEN','Stir fried minced chicken, rice noodle, ground almond nut, sesame seed, served with plum sauce in lettuce cup.','',0),(10,1,'MU SHU PORK (OR CHICKEN AND VEGETABLES)','Served with 4 pancakes.','',0),(11,1,'* GENERAL TSOU\'S CHICKEN','Browned chunky chicken in chef\'s special garlic sauce and garnish with broccoli and tomatoes.','',0),(12,1,'* ORANGE CRISPY CHICKEN OR BEEF','Lightly battered meats with orange peel in a famous spicy orange flavor sauce.','',0),(13,1,'* KUNG PO THREE COMBO','Hot tender beef, scallops, shrimps, and peanuts with a famous spicy Kung Po sauce.','',1),(14,1,'* YU SHIANG COMBINATION','Shrimp, beef, chicken with vegetables in house special spicy ginger and garlic sauce.','',0),(15,1,'DRAGON AND PHOENIX BIRD\'S NEST','Shrimp and chicken stir fried with vegetables served in a bird\'s nest.','',1),(16,1,'SHRIMP WITH HONEYED WALNUTS','Crispy shrimp in a tangy white cream sauce with honey glazed walnuts.','',0),(17,1,'* SPICY SALT & PEPPER SHRIMP','Crispy marinated shrimp sautéed and coated with a salt and hot pepper flavor.','',0),(18,1,'THREE DELICACIES','Shrimp, scallops, crabmeat with vegetables in delightful light garlic sauce.','',0),(19,1,'* HUNAN DOUBLE DELIGHT','Shrimp and beef sautéed with vegetables in a spicy brown sauce.','',0),(20,1,'SIZZLING BEEF AND SCALLOPS','Sea scallops and beef and fresh vegetables with homemade brown sauce served on a sizzling hot plate.','',0),(21,1,'* SEAFOOD NOODLE SOUP','An assortment of stir seafood, beef and vegetables soup broth with noodle.','',0),(22,1,'FISH FILET','Any style you wish - black bean sauce, sweet and sour, *Szechuan crispy.','',0),(23,1,'LAMB','Your choice of flavors - *Mongolian, *Hunan style or * Szechuan spicy style','',0),(24,1,'PEKING DUCK','Market Price.\r\n\r\nA traditional gourmet\'s  \"MUST\". One day notice required','',0),(25,1,'SHRIMP WITH SNOW PEAS','','',0),(26,1,'SHRIMP WITH BLACK BEAN SAUCE','','',0),(27,1,'SHRIMP VEGETABLE DELIGHT','','',0),(28,1,'SCALLOPS','Any style you wish:* Hunan style, * Szechuan Spicy style.* Kung Pao style, * Yu Shiang style or Sautéed with vegetables.','',0),(29,1,'CALAMARI','Any style you wish:* Hunan style, * Szechuan Spicy style.* Kung Pao style, * Yu Shiang style or Sautéed with vegetables.','',0),(30,1,'* KUNG PO SHRIMP','Shrimp, bamboo shoots and peanuts with red pepper in a famous spicy Kung Po sauce.','',3),(31,1,'* YU SHIANG SHRIMP','Shrimp and vegetables in spicy ginger and garlic sauce.','',0),(32,1,'* SZECHUAN CRISPY SHRIMP','Light battered shrimp glazed with a mild spicy Szechuan sauce.','',0),(33,1,'* HUNAN SHRIMP','','',0),(34,1,'* SZECHUAN SPICY SHRIMP','','',0),(35,1,'CASHEW OR ALMOND CHICKEN','Diced chicken with vegetable in brown sauce.','',0),(36,1,'SWEET AND SOUR CHICKEN','','',0),(37,1,'LEMON CHICKEN','Fried chicken with tangy lemon sauce.','',0),(38,1,'SESAME CHICKEN','','',0),(39,1,'* SZECHUAN CRISPY CHICKEN','Fried chicken with house special spicy ketchup sauce.','',0),(40,1,'* CHICKEN WITH GREEN BEANS','','',0),(41,1,'* GARLIC CHICKEN','For the garlic lovers!','',0),(42,1,'CHICKEN VEGETABLE DELIGHT','','',0),(43,1,'CHICKEN WITH BROCCOLI','','',0),(44,1,'CHICKEN WITH HONEYED WALNUTS','','',0),(45,1,'HOUSE DUCK','','',0),(46,1,'CRISPY DUCK','','',1),(47,1,'SNOW WHITE CHICKEN','Sliced chicken breast and fresh vegetables sauteed in a delightful garlic sauce.','',0),(48,1,'ALMOND BONELESS CHICKEN','Fried chicken breast with yellow gravy.','',0),(49,1,'* YU SHIANG CHICKEN','','',0),(50,1,'* HUNAN CHICKEN','Tender chicken with vegetables in a spicy brown sauce.','',0),(51,1,'* MANDARIN SPICY CHICKEN','Fried chicken with vegetables in spicy garlic sauce.','',0),(52,1,'AMAZING CHICKEN','Sliced chicken with vegetable sautéed in sweet and sour ketchup sauce.','',0),(53,1,'* KUNG PO CHICKEN','','',0),(54,1,'* CURRY CHICKEN','','',0),(55,1,'* SZECHUAN SPICY CHICKEN','Sliced chicken with vegetable sautéed in Szechuan spicy brown sauce.','',0),(56,1,'CHICKEN TERIYAKI','','',0),(57,1,'BEEF WITH BROCCOLI','','',0),(58,1,'BEEF WITH BLACK MUSHROOM','Tender beef stir fried with black mushroom and snow peas. A very tasty dish.','',0),(59,1,'BEEF WITH SNOW PEAS','','',0),(60,1,'BEEF WITH OYSTER SAUCE','','',0),(61,1,'BEEF VEGETABLE DELIGHT','','',0),(62,1,'* MANDARIN CRISPY BEEF','Lightly battered beef glazed with a spicy Mandarin ginger and garlic sauce.','',0),(63,1,'* MONGOLIAN BEEF','Slices of beef filet sauteed with fresh onion and ginger in a dark seasoned sauce.','',0),(64,1,'PEPPER STEAK','','',0),(65,1,'* SZECHUAN SPICY BEEF','Slices of beef filet sauteed with Chinese vegetables in s hot brown garlic sauce.','',0),(66,1,'* KUNG PO BEEF','','',0),(67,1,'* HUNAN BEEF','','',0),(68,1,'SWEET AND SOUR PORK','','',1),(69,1,'* TWICE COOKED PORK','Sliced port sauteed with cabbage and	bell peppers in a five spiced Peking sauce.','',0),(70,1,'* MANDARIN CRISPY PORK','','',0),(71,1,'PEKING SPARERIBS','Fried baby ribs and lean pork glazed with sweet and pungent sauce.','',0),(72,1,'PORK VEGETABLE DELIGHT','','',0),(73,1,'VEGETABLE DELIGHT','Seasonal vegetables toss cooked in alight sauce. A very healthy and delightful dish!','',0),(74,1,'* SZECHUAN GREEN BEAN','','',0),(75,1,'* FAMILY STYLE TO FU','Fried bean curds and vegetables braised in spicy brown sauce.','',0),(76,1,'* YU SHIANG TO FU','','',0),(77,1,'STEAMED VEGETABLE','','',0),(78,1,'STEAMED VEGETABLE WITH TOFU','','',0),(79,1,'STEAMED VEGETABLE WITH CHICKEN','','',1),(80,1,'STEAMED VEGETABLE WITH SHRIMP','','',0),(81,1,'STEAMED VEGETABLE WITH SEAFOOD','','',0),(82,1,'PORK EGG FOO YOUNG','','',0),(83,1,'VEGETABLE EGG FOO YOUNG','','',0),(84,1,'CHICKEN EGG FOO YOUNG','','',0),(85,1,'BEEF EGG FOO YOUNG','','',0),(86,1,'SHRIMP EGG FOO YOUNG','','',0),(87,1,'PORK PAN FRIED CHOW MEIN','','',1),(88,1,'VEGETABLE PAN FRIED CHOW MEIN','','',0),(89,1,'CHICKEN PAN FRIED CHOW MEIN','','',0),(90,1,'BEEF PAN FRIED CHOW MEIN','','',0),(91,1,'SHRIMP PAN FRIED CHOW MEIN','','',0),(92,1,'PORK CHOP SUEY','','',0),(93,1,'VEGETABLE CHOP SUEY','','',0),(94,1,'CHICKEN CHOP SUEY','','',0),(95,1,'BEEF CHOP SUEY','','',0),(96,1,'SHRIMP CHOP SUEY','','',0),(97,1,'PORK CHOW MEIN','','',0),(98,1,'VEGETABLE CHOW MEIN','','',0),(99,1,'CHICKEN CHOW MEIN','','',0),(100,1,'BEEF CHOW MEIN','','',0),(101,1,'SHRIMP CHOW MEIN','','',0),(102,1,'CHICKEN FRIED RICE','','',0),(103,1,'PORK FRIED RICE','','',2),(104,1,'VEGETABLE FRIED RICE','','',0),(105,1,'BEEF FRIED RICE','','',0),(106,1,'SHRIMP FRIED RICE','','',0),(107,1,'COMBINATION FRIED RICE','','',0),(108,1,'CHICKEN LOW MEIN','','',0),(109,1,'PORK LOW MEIN','','',0),(110,1,'VEGETABLE LOW MEIN','','',0),(111,1,'BEEF LOW MEIN','','',0),(112,1,'SHRIMP LOW MEIN','','',0),(113,1,'COMBINATION LOW MEIN','','',0),(115,1,'CRABMEAT CHEESE (4)','Wrapped fillings of crabmeat and cheese, deep fried to create a delectable appetizer.','',0),(116,1,'POT STICKERS (4)','','',0),(117,1,'EGG ROLL','','',0),(118,1,'SPRING ROLL  ( Vegetarian )','','',0),(119,1,'FRIED SHRIMP (6)','','',0),(120,1,'BBQ SPARE RIBS (4)','','',0),(121,1,'FOIL WRAPPED CHICKEN (4)','','',0),(122,1,'BEEF SKEWERS (4)','','',0),(123,1,'SIZZLING RICE','','',3),(124,1,'WONTON','','',8),(125,1,'VEGETARIAN','','',7),(126,1,'SEAFOOD','','',2),(128,1,'THE MANDARIN DINNER','<p align=\"center\"><em>Service for Two or More …12.95 Per Person<br />\r\n  </em><br />\r\n <em>Appetizers:</em><strong>  FRIED SHRIMP, EGG ROLL, CRABMEAT CHEESE</strong></br>\r\n<br />\r\n  <em>Soup:</em> <strong>  WON TON SOUP</strong><br />\r\n  <br />\r\n  <em><br />\r\n  <strong>ENTRÉES</strong></em> \r\n  <br />\r\n  <br />\r\n  <strong>BEEF BROCCOLI                              SWEET AND SOUR PORK</strong><br />\r\n  <em><br />\r\n  Steamed  or Fried Rice<br />\r\n  Cookies</em><br />\r\n  <br />\r\n  </br>\r\n  <em>For 3 Add:</em> <strong>ALMOND BONELESS CHICKEN</br>\r\n  </strong><br />\r\n  <em>For 4 Add:</em><strong> MOO SHU PORK</strong><br />\r\n  </br>\r\n  <em>For 5 Add:</em> <strong>SHRIMP WITH LOBSTER SAUCE</strong></br>\r\n  <br />\r\n  <em>For 6 Add: </em><strong>VEGETABLE DELIGHT</strong><br />\r\n  <em></br>\r\n  For 7 or More:</em> Portions of above will be increased.</p>','',18),(129,1,'THE SZECHUAN DINNER','<p align=\"center\"><em>Service for Two or More …13.95 Per Person<br />\r\n  </em><br />\r\n  <em>Appetizers: </em> <strong>FRIED SHRIMP, EGG ROLL, CRABMEAT CHEESE</strong></br>\r\n<br />\r\n   <em>Soup: </em><strong>* HOT AND SOUR SOUP<br />\r\n  <br />\r\n  <em><br />\r\n  ENTRÉES</em></strong>\r\n  <br />\r\n  <br />\r\n  <strong>*    MONGOLIAN BEEF              * YU SHIANG CHICKEN</strong><br />\r\n  <em><br />\r\n  Steamed  or Fried Rice<br />\r\n  Cookies</em><br />\r\n  <br />\r\n  </br>\r\n  <em>For 3 Add:</em> <strong>SHRIMP VEGETABLE DELIGHT</br>\r\n  </strong><br />\r\n  <em>For 4 Add:</em><strong> MOO SHU BEEF</strong><br />\r\n  </br>\r\n  <em>For 5 Add:</em> <strong>* KUNG PO THREE COMBO</strong></br>\r\n  <br />\r\n  <em>For 6 Add: </em><strong>* SZECHUAN GREEN BEAN</strong><br />\r\n  <em></br>\r\n  For 7 or More:</em> Portions of above will be increased.</p>','',9),(130,1,'Chow Mein (Served with Hard Noodle)','','',7),(131,1,'Chop Suey (Served with Rice)','','',4),(132,1,'Low Mein (Stir Fried Soft Noodle)','','',4),(133,1,'Fried Rice','','',8),(134,1,'CHINESE CHICKEN SALAD','','',0),(135,1,'CHICKEN TERIYAKI','','',1),(136,1,'SWEET AND SOUR CHICKEN','','',0),(137,1,'CASHEW OR ALMOND CHICKEN','','',0),(138,1,'ALMOND BONELESS CHICKEN','','',0),(139,1,'* KUNG PO CHICKEN','','',0),(140,1,'*  MANDARIN SPICY CHICKEN','','',1),(141,1,'* SZECHUAN CRISPY CHICKEN','','',0),(142,1,'SNOW WHITE CHICKEN','','',1),(143,1,'* CHICKEN GREEN BEANS','','',9),(144,1,'GARLIC CHICKEN','','',0),(145,1,'* GENERAL TSOU\'S CHICKEN','','',0),(146,1,'SESAME CHICKEN','','',0),(147,1,'CHINESE VEGETABLE DELIGHT','','',0),(148,1,'BEEF WITH BROCCOLI','','',0),(149,1,'* HUNAN BEEF','','',0),(150,1,'PEPPER STEAK','','',0),(151,1,'* SZECHUAN SPICY BEEF','','',0),(152,1,'* MONGOLIAN BEEF','','',1),(153,1,'* ORANGE CRISPY BEEF','','',0),(154,1,'SWEET AND SOUR PORK','','',0),(155,1,'PORK WITH BLACK MUSHROOM','','',0),(156,1,'* MANDARIN CRISPY PORK','','',0),(157,1,'* TWICE COOKED PORK','','',0),(158,1,'SWEET AND SOUR SHRIMP','','',0),(159,1,'* YU SHIANG SHRIMP','','',0),(160,1,'SHRIMP WITH SNOW PEAS','','',0),(161,1,'SHRIMP WITH LOBSTER SAUCE','','',0),(162,1,'VEGETABLE DELIGHT','','',0),(163,1,'STEAM VEGETABLES','Vegetarian, To Fu or Chicken','',0),(164,1,'* FAMILY TO FU','','',0),(165,1,'test product dig down','','',14);

--
-- Table structure for table `zen_products_discount_quantity`
--

CREATE TABLE `zen_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 `zen_products_discount_quantity`
--


--
-- Table structure for table `zen_products_notifications`
--

CREATE TABLE `zen_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 `zen_products_notifications`
--


--
-- Table structure for table `zen_products_options`
--

CREATE TABLE `zen_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',
  `products_options_rows` smallint(2) NOT NULL DEFAULT '1',
  PRIMARY KEY (`products_options_id`,`language_id`),
  KEY `idx_lang_id_zen` (`language_id`),
  KEY `idx_products_options_sort_order_zen` (`products_options_sort_order`),
  KEY `idx_products_options_name_zen` (`products_options_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_products_options`
--

INSERT INTO `zen_products_options` VALUES (3,1,'Fried Rice',0,2,32,NULL,32,0,0,0),(2,1,'Number of Persons',1,0,32,'',32,0,0,1),(1,1,'Size',0,2,32,'',32,0,0,0),(4,1,'Low Mein',1,2,32,'',32,0,0,0),(5,1,'Chop Suey',2,2,32,NULL,32,0,0,0),(6,1,'Chow Mein',3,2,32,NULL,32,0,0,0),(7,1,'download',0,2,32,'',32,0,0,0);

--
-- Table structure for table `zen_products_options_types`
--

CREATE TABLE `zen_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;

--
-- Dumping data for table `zen_products_options_types`
--

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

--
-- Table structure for table `zen_products_options_values`
--

CREATE TABLE `zen_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_products_options_values_name_zen` (`products_options_values_name`),
  KEY `idx_products_options_values_sort_order_zen` (`products_options_values_sort_order`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_products_options_values`
--

INSERT INTO `zen_products_options_values` VALUES (0,1,'TEXT',0),(1,1,'Small (8 oz.)',0),(2,1,'Medium (16 oz.)',1),(3,1,'Large (32 oz.)',2),(4,1,'3 Persons',3),(5,1,'4 Persons',4),(6,1,'5 Persons',5),(7,1,'6 Persons',6),(8,1,'7 Persons',7),(9,1,'8 Persons',8),(10,1,'9 Persons',9),(11,1,'10 Persons',11),(12,1,'2 Persons',2),(13,1,'Chicken, Pork or Vegetable',0),(14,1,'Beef',1),(15,1,'Shrimp',2),(16,1,'Combination',3),(17,1,'Chicken, Pork or Vegetable',0),(18,1,'Beef',1),(19,1,'Shrimp',2),(20,1,'Combination',3),(21,1,'Chicken, Pork or Vegetable',0),(22,1,'Beef',1),(23,1,'Shrimp',2),(24,1,'Combination',3),(25,1,'Chicken, Pork or Vegetable',0),(26,1,'Beef',1),(27,1,'Shrimp',2),(28,1,'Combination',3),(29,1,'zip',0);

--
-- Table structure for table `zen_products_options_values_to_products_options`
--

CREATE TABLE `zen_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`),
  KEY `idx_products_options_id_zen` (`products_options_id`),
  KEY `idx_products_options_values_id_zen` (`products_options_values_id`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_products_options_values_to_products_options`
--

INSERT INTO `zen_products_options_values_to_products_options` VALUES (1,1,1),(2,1,2),(3,1,3),(5,2,4),(6,2,5),(7,2,6),(8,2,7),(9,2,8),(10,2,9),(11,2,10),(12,2,11),(13,2,12),(14,3,13),(15,3,14),(16,3,15),(17,3,16),(18,5,17),(19,5,18),(20,5,19),(21,5,20),(22,6,21),(23,6,22),(24,6,23),(25,6,24),(26,4,25),(27,4,26),(28,4,27),(29,4,28),(30,7,29);

--
-- Table structure for table `zen_products_to_categories`
--

CREATE TABLE `zen_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 `zen_products_to_categories`
--

INSERT INTO `zen_products_to_categories` VALUES (1,4),(2,4),(3,5),(4,5),(5,6),(6,6),(7,7),(8,7),(9,7),(10,7),(11,7),(12,7),(13,7),(14,7),(15,7),(16,7),(17,7),(18,7),(19,7),(20,7),(21,7),(22,7),(23,7),(24,7),(25,6),(26,6),(27,6),(28,6),(29,6),(30,6),(31,6),(32,6),(33,6),(34,6),(35,8),(36,8),(37,8),(38,8),(39,8),(40,8),(41,8),(42,8),(43,8),(44,8),(45,8),(46,8),(47,8),(48,8),(49,8),(50,8),(51,8),(52,8),(53,8),(54,8),(55,8),(56,8),(57,9),(58,9),(59,9),(60,9),(61,9),(62,9),(63,9),(64,9),(65,9),(66,9),(67,9),(68,10),(69,10),(70,10),(71,10),(72,10),(73,11),(74,11),(75,11),(76,11),(77,12),(78,12),(79,12),(80,12),(81,12),(82,13),(83,13),(84,13),(85,13),(86,13),(87,14),(88,14),(89,14),(90,14),(91,14),(92,15),(93,15),(94,15),(95,15),(96,15),(97,15),(98,15),(99,15),(100,15),(101,15),(102,17),(103,17),(104,17),(105,17),(106,17),(107,17),(108,17),(109,17),(110,17),(111,17),(112,17),(113,17),(115,4),(116,4),(117,4),(118,4),(119,4),(120,4),(121,4),(122,4),(123,5),(124,5),(125,5),(126,5),(128,18),(129,18),(130,27),(131,26),(132,25),(133,24),(134,19),(135,19),(136,19),(137,19),(138,19),(139,19),(140,19),(141,19),(142,19),(143,19),(144,19),(145,19),(146,19),(147,19),(148,20),(149,20),(150,20),(151,20),(152,20),(153,20),(154,21),(155,21),(156,21),(157,21),(158,22),(159,22),(160,22),(161,22),(162,23),(163,23),(164,23),(165,28);

--
-- Table structure for table `zen_project_version`
--

CREATE TABLE `zen_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;

--
-- Dumping data for table `zen_project_version`
--

INSERT INTO `zen_project_version` VALUES (1,'Zen-Cart Main','1','3.9b','','','','','Version Update 1.3.8->1.3.9b','2010-06-06 12:04:30'),(2,'Zen-Cart Database','1','3.9b','','','','','Version Update 1.3.8->1.3.9b','2010-06-06 12:04:30');

--
-- Table structure for table `zen_project_version_history`
--

CREATE TABLE `zen_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=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_project_version_history`
--

INSERT INTO `zen_project_version_history` VALUES (1,'Zen-Cart Main','1','3.8','','Fresh Installation','2010-03-04 18:39:24'),(2,'Zen-Cart Database','1','3.8','','Fresh Installation','2010-03-04 18:39:24'),(3,'Zen-Cart Main','1','3.8','','Fresh Installation','2010-03-04 18:39:24'),(4,'Zen-Cart Database','1','3.8','','Fresh Installation','2010-03-04 18:39:24');

--
-- Table structure for table `zen_query_builder`
--

CREATE TABLE `zen_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=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_query_builder`
--

INSERT INTO `zen_query_builder` VALUES (1,'email','All Customers','Returns all customers name and email address for sending mass emails (ie: for newsletters, coupons, GVs, 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 o.date_purchased, 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 c.customers_newsletter = 1 GROUP BY c.customers_email_address HAVING max(o.date_purchased) <= subdate(now(),INTERVAL 3 MONTH) 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',''),(6,'email,newsletters','Administrator','Just the email account of the current administrator','select \'ADMIN\' as customers_firstname, admin_name as customers_lastname, admin_email as customers_email_address from TABLE_ADMIN where admin_id = $SESSION:admin_id',''),(7,'email,newsletters','Customers who have never completed a purchase','For sending newsletter to all customers who registered but have never completed a purchase','SELECT DISTINCT c.customers_email_address as customers_email_address, c.customers_lastname as customers_lastname, c.customers_firstname as customers_firstname FROM TABLE_CUSTOMERS c LEFT JOIN  TABLE_ORDERS o ON c.customers_id=o.customers_id WHERE o.date_purchased IS NULL','');

--
-- Table structure for table `zen_record_artists`
--

CREATE TABLE `zen_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 `zen_record_artists`
--


--
-- Table structure for table `zen_record_artists_info`
--

CREATE TABLE `zen_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 `zen_record_artists_info`
--


--
-- Table structure for table `zen_record_company`
--

CREATE TABLE `zen_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 `zen_record_company`
--


--
-- Table structure for table `zen_record_company_info`
--

CREATE TABLE `zen_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 `zen_record_company_info`
--


--
-- Table structure for table `zen_reviews`
--

CREATE TABLE `zen_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`),
  KEY `idx_status_zen` (`status`),
  KEY `idx_date_added_zen` (`date_added`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_reviews`
--


--
-- Table structure for table `zen_reviews_description`
--

CREATE TABLE `zen_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 `zen_reviews_description`
--


--
-- Table structure for table `zen_salemaker_sales`
--

CREATE TABLE `zen_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`),
  KEY `idx_sale_date_start_zen` (`sale_date_start`),
  KEY `idx_sale_date_end_zen` (`sale_date_end`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_salemaker_sales`
--


--
-- Table structure for table `zen_specials`
--

CREATE TABLE `zen_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`),
  KEY `idx_expires_date_zen` (`expires_date`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_specials`
--

INSERT INTO `zen_specials` VALUES (1,5,10.1250,'2010-03-04 22:09:21','2010-03-04 22:10:39','2010-04-01','2010-04-02 05:00:22',0,'2010-03-04');

--
-- Table structure for table `zen_tax_class`
--

CREATE TABLE `zen_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 `zen_tax_class`
--

INSERT INTO `zen_tax_class` VALUES (1,'Taxable Goods','The following types of products are included: non-food, services, etc',NULL,'2010-03-04 18:39:24');

--
-- Table structure for table `zen_tax_rates`
--

CREATE TABLE `zen_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 `zen_tax_rates`
--

INSERT INTO `zen_tax_rates` VALUES (1,1,1,1,7.0000,'FL TAX 7.0%','2010-03-04 18:39:24','2010-03-04 18:39:24');

--
-- Table structure for table `zen_template_select`
--

CREATE TABLE `zen_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`),
  KEY `idx_tpl_lang_zen` (`template_language`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_template_select`
--

INSERT INTO `zen_template_select` VALUES (1,'cd','0');

--
-- Table structure for table `zen_upgrade_exceptions`
--

CREATE TABLE `zen_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 `zen_upgrade_exceptions`
--


--
-- Table structure for table `zen_zones`
--

CREATE TABLE `zen_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`),
  KEY `idx_zone_country_id_zen` (`zone_country_id`),
  KEY `idx_zone_code_zen` (`zone_code`)
) ENGINE=MyISAM AUTO_INCREMENT=190 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_zones`
--

INSERT INTO `zen_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'),(43,223,'NY','New York'),(44,223,'NC','North Carolina'),(45,223,'ND','North Dakota'),(46,223,'MP','Northern Mariana Islands'),(47,223,'OH','Ohio'),(48,223,'OK','Oklahoma'),(49,223,'OR','Oregon'),(50,163,'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,'NL','Newfoundland'),(70,38,'NB','New Brunswick'),(71,38,'NS','Nova Scotia'),(72,38,'NT','Northwest Territories'),(73,38,'NU','Nunavut'),(74,38,'ON','Ontario'),(75,38,'PE','Prince Edward Island'),(76,38,'QC','Quebec'),(77,38,'SK','Saskatchewan'),(78,38,'YT','Yukon Territory'),(79,81,'NDS','Niedersachsen'),(80,81,'BAW','Baden WÃ¼rtemberg'),(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Ã¤rnten'),(100,14,'ST','Steiermark'),(101,14,'TI','Tirol'),(102,14,'BL','Burgenland'),(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'),(182,13,'ACT','Australian Capital Territory'),(183,13,'NSW','New South Wales'),(184,13,'NT','Northern Territory'),(185,13,'QLD','Queensland'),(186,13,'SA','South Australia'),(187,13,'TAS','Tasmania'),(188,13,'VIC','Victoria'),(189,13,'WA','Western Australia');

--
-- Table structure for table `zen_zones_to_geo_zones`
--

CREATE TABLE `zen_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`),
  KEY `idx_zones_zen` (`geo_zone_id`,`zone_country_id`,`zone_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zen_zones_to_geo_zones`
--

INSERT INTO `zen_zones_to_geo_zones` VALUES (1,223,18,1,NULL,'2010-03-04 18:39:24');

--
-- Dumping events for database 'nsadmin_zc1'
--

--
-- Dumping routines for database 'nsadmin_zc1'
--


