--
-- Host: grid50mysql13.secureserver.net    Database: daxwelldb
-- ------------------------------------------------------


--
-- Table structure for table `daxwell_admin_log`
--

CREATE TABLE `daxwell_admin_log` (
  `admin_log_id` int(11) NOT NULL auto_increment,
  `admin_id` int(11) NOT NULL,
  `login_time` datetime NOT NULL,
  `logout_time` datetime NOT NULL,
  PRIMARY KEY  (`admin_log_id`)
) ENGINE=MyISAM AUTO_INCREMENT=399 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `daxwell_admin_log`
--


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

--
-- Table structure for table `daxwell_admin_type`
--

CREATE TABLE `daxwell_admin_type` (
  `admin_type_id` int(11) NOT NULL auto_increment,
  `admin_type` varchar(200) NOT NULL,
  `previllage_id` varchar(255) NOT NULL,
  PRIMARY KEY  (`admin_type_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `daxwell_admin_type`
--


INSERT INTO `daxwell_admin_type` VALUES (1,'Manager','4,6,7,8,9,10,11'),(2,'Accountings','4,9,13'),(3,'Staffs','8,13'),(4,'Manufacturer','1,2,3,4,5'),(5,'Sales','8,12'),(6,'Technician','1,2,3,4,5,6,7,8,9,10,11,12,13'),(7,'Director','4,6,7,8,9,10,11');

--
-- Table structure for table `daxwell_blog_category`
--

CREATE TABLE `daxwell_blog_category` (
  `blog_category_id` int(11) NOT NULL auto_increment,
  `blog_category_name` varchar(400) NOT NULL,
  PRIMARY KEY  (`blog_category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_blog_category`
--


INSERT INTO `daxwell_blog_category` VALUES (4,'php'),(5,'Java'),(6,'C'),(7,'CPP');

--
-- Table structure for table `daxwell_blog_entry`
--

CREATE TABLE `daxwell_blog_entry` (
  `blog_entry_id` int(11) NOT NULL auto_increment,
  `item_id` varchar(50) NOT NULL COMMENT 'blog_{primary_key}',
  `blog_category_id` int(11) NOT NULL,
  `blog_entry_title` text NOT NULL,
  `blog_entry_description` blob NOT NULL,
  `entry_image` varchar(255) NOT NULL,
  `date_of_creation` datetime NOT NULL,
  `entry_status` enum('Y','N') NOT NULL,
  `entry_author` varchar(200) NOT NULL,
  `date_of_add` date NOT NULL,
  PRIMARY KEY  (`blog_entry_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_blog_entry`
--


INSERT INTO `daxwell_blog_entry` VALUES (1,'',5,'This is a Java based entry','<p> </p>\r\n<p> </p>\r\n<p style=\\\\\\\"\\\\\\\\\\\"margin-top:\\\\\\\"> Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \\\"de Finibus Bonorum et Malorum\\\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \\\"Lorem ipsum dolor sit amet..\\\", comes from a line in section 1.10.32.</p>\r\n<p style=\\\\\\\"text-align: justify; font-size: 11px; line-height: 14px; margin-top: 0px; margin-right: 0px; margin-bottom: 14px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; \\\\\\\">The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \\\"de Finibus Bonorum et Malorum\\\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \\\"de Finibus Bonorum et Malorum\\\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \\\"Lorem ipsum dolor sit amet..\\\", comes from a line in section 1.10.32.</p>\r\n<p style=\\\\\\\"text-align: justify; font-size: 11px; line-height: 14px; margin-top: 0px; margin-right: 0px; margin-bottom: 14px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; \\\\\\\">The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \\\"de Finibus Bonorum et Malorum\\\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \\\"de Finibus Bonorum et Malorum\\\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \\\"Lorem ipsum dolor sit amet..\\\", comes from a line in section 1.10.32.</p>\r\n<p style=\\\\\\\"text-align: justify; font-size: 11px; line-height: 14px; margin-top: 0px; margin-right: 0px; margin-bottom: 14px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; \\\\\\\">The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \\\"de Finibus Bonorum et Malorum\\\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \\\"de Finibus Bonorum et Malorum\\\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \\\"Lorem ipsum dolor sit amet..\\\", comes from a line in section 1.10.32.</p>\r\n<p style=\\\\\\\"text-align: justify; font-size: 11px; line-height: 14px; margin-top: 0px; margin-right: 0px; margin-bottom: 14px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; \\\\\\\">The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \\\"de Finibus Bonorum et Malorum\\\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \\\"de Finibus Bonorum et Malorum\\\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \\\"Lorem ipsum dolor sit amet..\\\", comes from a line in section 1.10.32.</p>\r\n<p style=\\\\\\\"text-align: justify; font-size: 11px; line-height: 14px; margin-top: 0px; margin-right: 0px; margin-bottom: 14px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; \\\\\\\">The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \\\"de Finibus Bonorum et Malorum\\\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \\\"de Finibus Bonorum et Malorum\\\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \\\"Lorem ipsum dolor sit amet..\\\", comes from a line in section 1.10.32.</p>\r\n<p style=\\\\\\\"text-align: justify; font-size: 11px; line-height: 14px; margin-top: 0px; margin-right: 0px; margin-bottom: 14px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; \\\\\\\">The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \\\"de Finibus Bonorum et Malorum\\\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p>','1259748042java_starting.jpg','2009-12-02 15:30:42','Y','Dev','2009-12-02');

--
-- Table structure for table `daxwell_category`
--

CREATE TABLE `daxwell_category` (
  `category_id` int(11) NOT NULL auto_increment,
  `category_name` varchar(200) NOT NULL,
  `parent_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `daxwell_category`
--


INSERT INTO `daxwell_category` VALUES (1,'Cutlery',0),(2,'Latex Gloves',0),(3,'Spoon',1),(4,'Flatware Set',1),(5,'Forks',1),(6,'Sporks',1),(7,'Knives',1),(8,'Salt Pepper Packs',1),(9,'Paper Towels',1),(10,'Medical Gloves',2),(11,'Commercial Gloves',2),(13,'Special Sales',0);

--
-- Table structure for table `daxwell_cms`
--

CREATE TABLE `daxwell_cms` (
  `page_id` int(11) NOT NULL auto_increment,
  `page_name` varchar(100) default NULL,
  `page_desc` text NOT NULL,
  `languages_id` tinyint(4) default NULL,
  `sort_order` tinyint(4) NOT NULL default '0',
  `status` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`page_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_cms`
--


INSERT INTO `daxwell_cms` VALUES (1,'home','<p>This is the text for home</p>',NULL,0,1),(2,'about_us','<p>This is test about us</p>',NULL,0,1);

--
-- Table structure for table `daxwell_countries`
--

CREATE TABLE `daxwell_countries` (
  `countries_id` int(11) NOT NULL auto_increment,
  `countries_name` varchar(64) NOT NULL,
  `countries_iso_code_2` char(2) NOT NULL,
  `countries_iso_code_3` char(3) NOT NULL,
  `address_format_id` int(11) NOT NULL,
  PRIMARY KEY  (`countries_id`),
  KEY `IDX_COUNTRIES_NAME` (`countries_name`)
) ENGINE=MyISAM AUTO_INCREMENT=240 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `daxwell_countries`
--


INSERT INTO `daxwell_countries` VALUES (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',1),(39,'Cape Verde','CV','CPV',1),(40,'Cayman Islands','KY','CYM',1),(41,'Central African Republic','CF','CAF',1),(42,'Chad','TD','TCD',1),(43,'Chile','CL','CHL',1),(44,'China','CN','CHN',1),(45,'Christmas Island','CX','CXR',1),(46,'Cocos (Keeling) Islands','CC','CCK',1),(47,'Colombia','CO','COL',1),(48,'Comoros','KM','COM',1),(49,'Congo','CG','COG',1),(50,'Cook Islands','CK','COK',1),(51,'Costa Rica','CR','CRI',1),(52,'Cote D\'Ivoire','CI','CIV',1),(53,'Croatia','HR','HRV',1),(54,'Cuba','CU','CUB',1),(55,'Cyprus','CY','CYP',1),(56,'Czech Republic','CZ','CZE',1),(57,'Denmark','DK','DNK',1),(58,'Djibouti','DJ','DJI',1),(59,'Dominica','DM','DMA',1),(60,'Dominican Republic','DO','DOM',1),(61,'East Timor','TP','TMP',1),(62,'Ecuador','EC','ECU',1),(63,'Egypt','EG','EGY',1),(64,'El Salvador','SV','SLV',1),(65,'Equatorial Guinea','GQ','GNQ',1),(66,'Eritrea','ER','ERI',1),(67,'Estonia','EE','EST',1),(68,'Ethiopia','ET','ETH',1),(69,'Falkland Islands (Malvinas)','FK','FLK',1),(70,'Faroe Islands','FO','FRO',1),(71,'Fiji','FJ','FJI',1),(72,'Finland','FI','FIN',1),(73,'France','FR','FRA',1),(74,'France, Metropolitan','FX','FXX',1),(75,'French Guiana','GF','GUF',1),(76,'French Polynesia','PF','PYF',1),(77,'French Southern Territories','TF','ATF',1),(78,'Gabon','GA','GAB',1),(79,'Gambia','GM','GMB',1),(80,'Georgia','GE','GEO',1),(81,'Germany','DE','DEU',5),(82,'Ghana','GH','GHA',1),(83,'Gibraltar','GI','GIB',1),(84,'Greece','GR','GRC',1),(85,'Greenland','GL','GRL',1),(86,'Grenada','GD','GRD',1),(87,'Guadeloupe','GP','GLP',1),(88,'Guam','GU','GUM',1),(89,'Guatemala','GT','GTM',1),(90,'Guinea','GN','GIN',1),(91,'Guinea-bissau','GW','GNB',1),(92,'Guyana','GY','GUY',1),(93,'Haiti','HT','HTI',1),(94,'Heard and Mc Donald Islands','HM','HMD',1),(95,'Honduras','HN','HND',1),(96,'Hong Kong','HK','HKG',1),(97,'Hungary','HU','HUN',1),(98,'Iceland','IS','ISL',1),(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,'Macau','MO','MAC',1),(126,'Macedonia, The Former Yugoslav Republic of','MK','MKD',1),(127,'Madagascar','MG','MDG',1),(128,'Malawi','MW','MWI',1),(129,'Malaysia','MY','MYS',1),(130,'Maldives','MV','MDV',1),(131,'Mali','ML','MLI',1),(132,'Malta','MT','MLT',1),(133,'Marshall Islands','MH','MHL',1),(134,'Martinique','MQ','MTQ',1),(135,'Mauritania','MR','MRT',1),(136,'Mauritius','MU','MUS',1),(137,'Mayotte','YT','MYT',1),(138,'Mexico','MX','MEX',1),(139,'Micronesia, Federated States of','FM','FSM',1),(140,'Moldova, Republic of','MD','MDA',1),(141,'Monaco','MC','MCO',1),(142,'Mongolia','MN','MNG',1),(143,'Montserrat','MS','MSR',1),(144,'Morocco','MA','MAR',1),(145,'Mozambique','MZ','MOZ',1),(146,'Myanmar','MM','MMR',1),(147,'Namibia','NA','NAM',1),(148,'Nauru','NR','NRU',1),(149,'Nepal','NP','NPL',1),(150,'Netherlands','NL','NLD',1),(151,'Netherlands Antilles','AN','ANT',1),(152,'New Caledonia','NC','NCL',1),(153,'New Zealand','NZ','NZL',1),(154,'Nicaragua','NI','NIC',1),(155,'Niger','NE','NER',1),(156,'Nigeria','NG','NGA',1),(157,'Niue','NU','NIU',1),(158,'Norfolk Island','NF','NFK',1),(159,'Northern Mariana Islands','MP','MNP',1),(160,'Norway','NO','NOR',1),(161,'Oman','OM','OMN',1),(162,'Pakistan','PK','PAK',1),(163,'Palau','PW','PLW',1),(164,'Panama','PA','PAN',1),(165,'Papua New Guinea','PG','PNG',1),(166,'Paraguay','PY','PRY',1),(167,'Peru','PE','PER',1),(168,'Philippines','PH','PHL',1),(169,'Pitcairn','PN','PCN',1),(170,'Poland','PL','POL',1),(171,'Portugal','PT','PRT',1),(172,'Puerto Rico','PR','PRI',1),(173,'Qatar','QA','QAT',1),(174,'Reunion','RE','REU',1),(175,'Romania','RO','ROM',1),(176,'Russian Federation','RU','RUS',1),(177,'Rwanda','RW','RWA',1),(178,'Saint Kitts and Nevis','KN','KNA',1),(179,'Saint Lucia','LC','LCA',1),(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',1),(223,'United States','US','USA',2),(224,'United States Minor Outlying Islands','UM','UMI',1),(225,'Uruguay','UY','URY',1),(226,'Uzbekistan','UZ','UZB',1),(227,'Vanuatu','VU','VUT',1),(228,'Vatican City State (Holy See)','VA','VAT',1),(229,'Venezuela','VE','VEN',1),(230,'Viet Nam','VN','VNM',1),(231,'Virgin Islands (British)','VG','VGB',1),(232,'Virgin Islands (U.S.)','VI','VIR',1),(233,'Wallis and Futuna Islands','WF','WLF',1),(234,'Western Sahara','EH','ESH',1),(235,'Yemen','YE','YEM',1),(236,'Yugoslavia','YU','YUG',1),(237,'Zaire','ZR','ZAR',1),(238,'Zambia','ZM','ZMB',1),(239,'Zimbabwe','ZW','ZWE',1);

--
-- Table structure for table `daxwell_customer_billing_details`
--

CREATE TABLE `daxwell_customer_billing_details` (
  `billing_id` int(11) NOT NULL auto_increment,
  `customer_id` int(11) NOT NULL,
  `b_first_name` varchar(100) NOT NULL,
  `b_middle_name` varchar(100) NOT NULL,
  `b_last_name` varchar(100) NOT NULL,
  `b_address` text NOT NULL,
  `b_state` varchar(255) NOT NULL,
  `b_country` varchar(255) NOT NULL,
  `b_zip` varchar(20) NOT NULL,
  `b_phone_no` varchar(20) NOT NULL,
  `b_mobile_no` varchar(20) NOT NULL,
  PRIMARY KEY  (`billing_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_customer_billing_details`
--


INSERT INTO `daxwell_customer_billing_details` VALUES (2,2,'taiwen','t','huang','pobox 866 spring tx ','tx','United States','77383','832-264-0605','');

--
-- Table structure for table `daxwell_customer_order_details`
--

CREATE TABLE `daxwell_customer_order_details` (
  `order_id` int(11) NOT NULL auto_increment,
  `order_number` varchar(100) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `total_price` varchar(25) NOT NULL,
  `discount_level` int(11) NOT NULL default '0',
  `discount_total_price` varchar(25) NOT NULL,
  `cur_disc_level` float NOT NULL default '0',
  `cur_disc_total` varchar(25) NOT NULL,
  `date_of_order` datetime NOT NULL,
  `order_status` int(11) NOT NULL default '0' COMMENT '0=>new,1=>pending,2=>activated,3=>processed ,4=>manufacturer_received, 5=>shipped ,6=>completed,7=>cancelled',
  `order_size` double NOT NULL default '0',
  `shipping_charge` float NOT NULL default '0',
  `insurance_charge` float NOT NULL default '0',
  `is_admin_view` enum('0','1') NOT NULL default '0',
  `deposit_paid` float NOT NULL default '0',
  `deposit_time` datetime NOT NULL,
  `transportation_status` int(11) NOT NULL default '0' COMMENT '0-eta 1-ready 2-waitport 3-ship 4-endport 5-inland 6-arrived',
  `payment_status` int(11) NOT NULL default '0' COMMENT '0-init 1-paid 2-deposit delinquent 3-postorder delinquent',
  `final_price_date` datetime NOT NULL,
  `duties` float NOT NULL default '0',
  `inland_truck_charge` float NOT NULL default '0',
  `order_complete_date` datetime NOT NULL,
  `balance_paid` float NOT NULL default '0',
  `balance_paid_date` datetime NOT NULL,
  PRIMARY KEY  (`order_id`)
) ENGINE=MyISAM AUTO_INCREMENT=97 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_customer_order_details`
--


INSERT INTO `daxwell_customer_order_details` VALUES (19,'1263338719',2,'549',15,'466.65',32,'373.5','2010-01-12 16:25:19',1,0,0,0,'1',0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(22,'1263339072',2,'1024',20,'819.2',20,'819.2','2010-01-12 16:31:12',1,0,0,0,'1',0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(24,'1263340210',2,'444',10,'399.6',10,'399.6','2010-01-12 16:50:10',1,0,0,0,'1',0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(25,'1263349121',5,'468',10,'421.2',10,'421.2','2010-01-12 19:18:41',1,0,0,0,'1',0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(26,'1263397166',2,'684',15,'581.4',15,'581.4','2010-01-13 08:39:26',1,0,0,0,'1',0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(28,'1263432165',2,'1324',20,'1059.2',20,'1059.2','2010-01-13 18:22:45',1,0,0,0,'1',0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(29,'1263435027',2,'1620',20,'1296',20,'1296','2010-01-13 19:10:27',1,0,0,0,'1',0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(30,'1263435223',2,'420',10,'378',10,'378','2010-01-13 19:13:44',1,0,0,0,'1',0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(31,'1263436036',2,'2020',25,'1515',25,'1515','2010-01-13 19:27:16',1,0,0,0,'1',0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(32,'1263440927',2,'1256',20,'1004.8',20,'1004.8','2010-01-13 20:48:47',1,0,0,0,'1',0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(33,'1263441139',2,'1620',20,'1296',20,'1296','2010-01-13 20:52:19',1,0,0,0,'1',0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(34,'1263441275',2,'412',10,'370.8',12,'362.56','2010-01-13 20:54:35',1,0,0,0,'1',0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(35,'1263441641',2,'420',10,'378',20,'336','2010-01-13 21:00:41',1,0,0,0,'1',0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(36,'1263484738',2,'420',10,'378',15,'357','2010-01-14 08:58:58',1,10136,80,20,'1',0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(38,'1263574963',2,'1220',20,'976',40,'732','2010-01-15 10:02:43',2,2000,80,25,'0',500,'2010-01-15 11:41:02',0,0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(43,'1263596390',2,'404',10,'363.6',35,'262.6','2010-01-15 15:59:50',2,10008,0,0,'0',0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(45,'1263601105',2,'420',10,'378',25,'315','2010-01-15 17:18:25',4,0,0,0,'0',300,'2010-01-25 17:55:08',0,0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(46,'1263601217',2,'420',10,'378',20,'336','2010-01-15 17:20:17',4,10136,30,20,'0',500,'2010-01-25 17:39:17',0,0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(47,'1263601524',2,'456',10,'410.4',40,'273.59999999999996','2010-01-15 17:25:24',4,900,38,15,'0',500,'2010-01-25 15:17:50',0,0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(48,'1263626646',1,'8000',25,'6000',26,'5920','2010-01-16 00:24:06',1,6000,80,35,'0',0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(49,'1263892844',2,'1220',20,'976',10,'1098','2010-01-19 02:20:44',1,10136,80,25,'0',0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(50,'1263893716',2,'3868',25,'2901',25,'2901','2010-01-19 02:35:16',0,15136,80,30,'0',0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(51,'1263893968',2,'4930',25,'3697.5',25,'3697.5','2010-01-19 02:39:28',0,10477,80,30,'0',0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(52,'1264004998',2,'400',10,'360',10,'360','2010-01-20 09:29:58',0,10000,80,20,'0',0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(56,'1264005163',2,'408',10,'367.2',10,'367.2','2010-01-20 09:32:43',0,10064,80,20,'0',0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(57,'1264005301',0,'3500',25,'2625',25,'2625','2010-01-20 09:35:01',0,4500,80,30,'0',0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(58,'1264006583',2,'826',18,'677.32',18,'677.32','2010-01-20 09:56:23',0,10349,80,25,'0',0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(59,'1264008500',2,'36400',25,'27300',25,'27300','2010-01-20 10:28:20',0,1000015520,0,0,'0',0,'0000-00-00 00:00:00',0,3,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(60,'1264011434',2,'1700',20,'1360',20,'1360','2010-01-20 11:17:14',0,10136,80,28,'0',0,'0000-00-00 00:00:00',0,3,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(61,'1264012104',2,'400',10,'360',10,'360','2010-01-20 11:28:24',0,10000,80,20,'0',0,'0000-00-00 00:00:00',0,3,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(62,'1264012131',3,'4200',25,'3150',25,'3150','2010-01-20 11:28:51',6,4500,80,30,'0',500,'0000-00-00 00:00:00',6,3,'2010-01-05 00:00:00',100,100,'2010-01-18 00:00:00',0,'0000-00-00 00:00:00'),(63,'1264012362',2,'412',10,'370.8',15,'350.2','2010-01-20 11:32:42',1,10072,80,20,'0',0,'0000-00-00 00:00:00',0,3,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(64,'1264019311',2,'840',18,'688.8',18,'688.8','2010-01-20 13:28:31',0,10136,80,25,'0',0,'0000-00-00 00:00:00',0,3,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(65,'1264034061',2,'8444',25,'6333',25,'6333','2010-01-20 17:34:21',0,15072,80,35,'0',0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(66,'1264034261',2,'5090',25,'3817.5',25,'3817.5','2010-01-20 17:37:41',0,10136,80,30,'0',0,'0000-00-00 00:00:00',0,2,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(67,'1264035352',3,'8400',25,'6300',10,'7560','2010-01-20 17:55:52',1,4500,80,35,'0',0,'0000-00-00 00:00:00',0,2,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(68,'1264058177',2,'4020',25,'3015',25,'3015','2010-01-21 00:16:17',0,10072,80,30,'0',0,'0000-00-00 00:00:00',0,2,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(69,'1264059117',2,'2404',25,'1803',25,'1803','2010-01-21 00:31:57',0,10008,80,28,'0',0,'0000-00-00 00:00:00',0,2,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(70,'1264059157',2,'412',10,'370.8',10,'370.8','2010-01-21 00:32:37',0,10072,80,20,'0',500,'2010-01-21 03:33:10',0,2,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(71,'1264130111',2,'412',10,'370.8',5,'391.4','2010-01-21 20:15:11',1,10072,80,20,'0',0,'0000-00-00 00:00:00',0,2,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(72,'1264131612',2,'420',10,'378',5,'399','2010-01-21 20:40:12',1,10136,80,20,'0',0,'0000-00-00 00:00:00',0,2,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(73,'1264132670',2,'24608',25,'18456',12,'21655.04','2010-01-21 20:57:50',1,999,40,100,'0',0,'0000-00-00 00:00:00',0,2,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(74,'1264132867',2,'404',10,'363.6',10,'363.6','2010-01-21 21:01:07',0,10008,80,20,'0',0,'0000-00-00 00:00:00',0,2,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(75,'1264135877',2,'1230',20,'984',20,'984','2010-01-21 21:51:17',0,10349,80,25,'0',0,'0000-00-00 00:00:00',0,2,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(76,'1264184579',2,'412',10,'370.8',10,'370.8','2010-01-22 11:22:59',0,10072,80,20,'0',0,'0000-00-00 00:00:00',0,2,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(77,'1264185341',2,'420',10,'378',15,'357','2010-01-22 11:35:41',1,600,35,20,'0',500,'2010-01-24 23:08:04',0,2,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(78,'1264216348',7,'1750',20,'1400',20,'1400','2010-01-22 20:12:28',4,47,10,28,'0',600,'2010-01-25 17:51:59',0,2,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(79,'1264275601',2,'444',10,'399.6',10,'399.6','2010-01-23 12:40:01',4,10072,80,20,'0',100,'2010-01-25 18:03:09',0,2,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(80,'1264390676',2,'420',10,'378',10,'378','2010-01-24 20:37:56',4,10136,80,20,'0',500,'2010-01-25 18:49:32',0,2,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(82,'1264391221',2,'412',10,'370.8',10,'370.8','2010-01-24 20:47:01',4,10072,80,20,'0',500,'2010-01-25 18:57:39',0,2,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(84,'1264391291',2,'404',10,'363.6',10,'363.6','2010-01-24 20:48:11',0,10008,80,20,'0',0,'0000-00-00 00:00:00',0,2,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(88,'1264391651',2,'602',15,'511.7',15,'511.7','2010-01-24 20:54:11',0,5001,80,25,'0',0,'0000-00-00 00:00:00',0,2,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(89,'1264393919',2,'1016',20,'812.8',20,'812.8','2010-01-24 21:31:59',0,800,35,25,'0',0,'0000-00-00 00:00:00',0,2,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(91,'1264394024',2,'1002',20,'801.6',20,'801.6','2010-01-24 21:33:44',0,8005001,100,25,'0',0,'0000-00-00 00:00:00',0,2,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(92,'1264394160',2,'1002',20,'801.6',20,'801.6','2010-01-24 21:36:00',0,8005001,100,25,'0',0,'0000-00-00 00:00:00',0,2,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(93,'1264394268',2,'412',10,'370.8',10,'370.8','2010-01-24 21:37:48',0,10072,80,20,'0',0,'0000-00-00 00:00:00',0,2,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(94,'1264394289',2,'1002',20,'801.6',20,'801.6','2010-01-24 21:38:09',0,8005001,100,25,'0',0,'0000-00-00 00:00:00',0,2,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(95,'1264394524',2,'1002',20,'801.6',20,'801.6','2010-01-24 21:42:04',2,8005001,100,25,'0',0,'0000-00-00 00:00:00',0,2,'2010-01-03 00:00:00',30,40,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00'),(96,'1264394564',2,'1402',20,'1121.6',20,'1121.6','2010-01-24 21:42:44',0,8015001,100,28,'0',0,'0000-00-00 00:00:00',0,2,'0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00');

--
-- Table structure for table `daxwell_customer_personal_details`
--

CREATE TABLE `daxwell_customer_personal_details` (
  `personal_id` int(11) NOT NULL auto_increment,
  `customer_id` int(11) NOT NULL,
  `first_name` varchar(100) NOT NULL,
  `middle_name` varchar(100) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `company_name` varchar(255) NOT NULL,
  `sex` enum('M','F') NOT NULL,
  `dob` date NOT NULL,
  `address` text NOT NULL,
  `city` varchar(255) NOT NULL,
  `zip` varchar(20) NOT NULL,
  `state` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `phone_no` varchar(20) NOT NULL,
  `mobile_no` varchar(20) NOT NULL,
  `status` int(11) NOT NULL default '0' COMMENT '0-init 1-active 2-modified,nonactive  3-not approved 4-deleted 5-no longer available',
  PRIMARY KEY  (`personal_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_customer_personal_details`
--


INSERT INTO `daxwell_customer_personal_details` VALUES (2,2,'jean','t','huang','best company','F','2009-05-19','pobox 866','everycity','77383','tx','United States','832-264-0605','',0),(3,3,'taiwen','j','huang','best company','F','0000-00-00','abc st','everycity','77654','tx','United States','123-456-8888','',0),(4,5,'test','test','test','best company','M','1993-01-05','123 str','everycity','77387','TX','United States','123-234-1234','2340555-6666',0),(5,7,'gary','','Huang','best company','M','2010-01-05','1234 Anywhere Street','everycity','75056','TX','United States','123-567-8888','',0),(6,9,'Debraj','','Dutta','','M','1983-07-18','Uttarpara','','712232','West Bengal','India','9231832026','9231832026',0);

--
-- Table structure for table `daxwell_customer_price_level`
--

CREATE TABLE `daxwell_customer_price_level` (
  `customer_price_level_id` int(11) NOT NULL auto_increment,
  `customer_id` int(11) NOT NULL,
  `price_level` varchar(100) NOT NULL,
  PRIMARY KEY  (`customer_price_level_id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_customer_price_level`
--


INSERT INTO `daxwell_customer_price_level` VALUES (1,1,'100'),(2,2,'100'),(3,3,'200'),(4,4,'90'),(5,5,'100'),(6,6,'150'),(7,7,'150'),(8,8,'150'),(9,9,'100');

--
-- Table structure for table `daxwell_customer_product_order_details`
--

CREATE TABLE `daxwell_customer_product_order_details` (
  `product_order_id` int(11) NOT NULL auto_increment,
  `order_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `quantity` int(11) NOT NULL,
  `shipping_id` int(11) NOT NULL,
  `shipping_method_id` int(11) NOT NULL,
  PRIMARY KEY  (`product_order_id`)
) ENGINE=MyISAM AUTO_INCREMENT=286 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_customer_product_order_details`
--


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

--
-- Table structure for table `daxwell_customer_shipping_details`
--

CREATE TABLE `daxwell_customer_shipping_details` (
  `shipping_id` int(11) NOT NULL auto_increment,
  `customer_id` int(11) NOT NULL,
  `s_first_name` varchar(100) NOT NULL,
  `s_middle_name` varchar(100) NOT NULL,
  `s_last_name` varchar(100) NOT NULL,
  `s_address` text NOT NULL,
  `s_state` varchar(255) NOT NULL,
  `s_country` varchar(255) NOT NULL,
  `s_zip` varchar(20) NOT NULL,
  `s_phone_no` varchar(20) NOT NULL,
  `s_mobile_no` varchar(20) NOT NULL,
  PRIMARY KEY  (`shipping_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_customer_shipping_details`
--


INSERT INTO `daxwell_customer_shipping_details` VALUES (2,2,'taiwen','t','huang','pobox 86 spring','tx','United States','77383','832-264-0605',''),(3,2,'abc','abc','abc','abc','abc','Afghanistan','123','12345','');

--
-- Table structure for table `daxwell_customerdetails`
--

CREATE TABLE `daxwell_customerdetails` (
  `customerdetails_id` int(11) NOT NULL auto_increment,
  `gender` enum('Y','N') NOT NULL,
  `date_of_birth` enum('Y','N') NOT NULL,
  `company` enum('Y','N') NOT NULL,
  `suburb` enum('Y','N') NOT NULL,
  `state` enum('Y','N') NOT NULL,
  PRIMARY KEY  (`customerdetails_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_customerdetails`
--



--
-- Table structure for table `daxwell_discount_coupons`
--

CREATE TABLE `daxwell_discount_coupons` (
  `coupons_id` int(11) NOT NULL auto_increment,
  `coupon_number` varchar(255) NOT NULL,
  `coupons_description` varchar(64) NOT NULL default '',
  `coupons_discount_amount` decimal(15,2) default NULL,
  `coupons_discount_type` varchar(35) default NULL,
  `coupons_date_start` date default NULL,
  `coupons_date_end` date default NULL,
  `coupons_max_use` int(3) NOT NULL default '0',
  `coupons_min_order` decimal(15,4) NOT NULL default '0.0000',
  `coupons_number_available` int(3) NOT NULL default '0',
  PRIMARY KEY  (`coupons_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_discount_coupons`
--


INSERT INTO `daxwell_discount_coupons` VALUES (1,'0123456789','testing','10.00','fixed','2009-11-27','2009-11-30',100,'1.0000',100);

--
-- Table structure for table `daxwell_discount_level`
--

CREATE TABLE `daxwell_discount_level` (
  `discount_id` int(11) NOT NULL auto_increment,
  `from_price` varchar(100) NOT NULL,
  `to_price` varchar(100) NOT NULL,
  `discount_amount` int(11) NOT NULL,
  PRIMARY KEY  (`discount_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_discount_level`
--


INSERT INTO `daxwell_discount_level` VALUES (1,'0','100',0),(2,'101','300',5),(3,'301','500',10),(4,'501','800',15),(5,'801','1000',18),(6,'1001','2000',20),(7,'2001','100000',25);

--
-- Table structure for table `daxwell_emailtemplate`
--

CREATE TABLE `daxwell_emailtemplate` (
  `template_id` int(11) NOT NULL auto_increment,
  `template_name` varchar(255) NOT NULL default '',
  `description` blob NOT NULL,
  `isactive` enum('Y','N') NOT NULL default 'N',
  `cronjob` varchar(255) NOT NULL,
  PRIMARY KEY  (`template_id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_emailtemplate`
--


INSERT INTO `daxwell_emailtemplate` VALUES (18,'dev','<p>dev</p>','Y','Y');

--
-- Table structure for table `daxwell_geo_zones`
--

CREATE TABLE `daxwell_geo_zones` (
  `geo_zone_id` int(11) NOT NULL auto_increment,
  `geo_zone_name` varchar(255) NOT NULL,
  `geo_zone_description` varchar(255) NOT NULL,
  `last_modified` datetime default NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY  (`geo_zone_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_geo_zones`
--


INSERT INTO `daxwell_geo_zones` VALUES (1,'Florida','Florida local sales tax zone','2009-10-23 10:11:51','2009-09-07 16:26:07'),(5,'vbnvbnvb','vbnvbbn',NULL,'2009-10-21 11:47:34');

--
-- Table structure for table `daxwell_images`
--

CREATE TABLE `daxwell_images` (
  `images_id` int(11) NOT NULL auto_increment,
  `small_image_width` varchar(11) NOT NULL,
  `small_image_height` varchar(11) NOT NULL,
  `heading_image_width` varchar(11) NOT NULL,
  `heading_image_height` varchar(11) NOT NULL,
  `subcategory_image_width` varchar(11) NOT NULL,
  `subcategory_image_height` varchar(11) NOT NULL,
  PRIMARY KEY  (`images_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_images`
--


INSERT INTO `daxwell_images` VALUES (1,'100','100','50','50','100','100');

--
-- Table structure for table `daxwell_insurance_value`
--

CREATE TABLE `daxwell_insurance_value` (
  `insurance_id` int(11) NOT NULL auto_increment,
  `min_order_price` varchar(100) NOT NULL,
  `max_order_price` varchar(100) NOT NULL,
  `insurance_value` varchar(100) NOT NULL,
  PRIMARY KEY  (`insurance_id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_insurance_value`
--


INSERT INTO `daxwell_insurance_value` VALUES (2,'0','100','13'),(3,'101','300','15'),(4,'301','500','20'),(5,'501','1000','25'),(6,'1001','2000','28'),(7,'2001','5000','30'),(8,'5001','8000','35'),(9,'8001','1000000','100');

--
-- Table structure for table `daxwell_item_wise_shipping_details`
--

CREATE TABLE `daxwell_item_wise_shipping_details` (
  `id` int(11) NOT NULL auto_increment,
  `product_id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `shipping_id` int(11) NOT NULL,
  `shipping_method_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_item_wise_shipping_details`
--



--
-- Table structure for table `daxwell_manufacturer`
--

CREATE TABLE `daxwell_manufacturer` (
  `manufacturer_id` int(11) NOT NULL auto_increment,
  `admin_id` int(11) NOT NULL,
  `manufacturer_name` varchar(255) NOT NULL,
  `manufacturer_address` text NOT NULL,
  `manufacturer_city` varbinary(100) NOT NULL,
  `manufacturer_state` varchar(100) NOT NULL,
  `manufacturer_country` varchar(100) NOT NULL,
  `manufacturer_zip` varchar(20) NOT NULL,
  `manufacturer_details` blob NOT NULL,
  `manufacturer_phone` varchar(20) NOT NULL,
  `manufacturer_fax` varchar(20) NOT NULL,
  `manufacturer_logo` varchar(100) NOT NULL,
  PRIMARY KEY  (`manufacturer_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `daxwell_manufacturer`
--


INSERT INTO `daxwell_manufacturer` VALUES (1,8,'S&W Trading','john address FFFFF','California','state john','United States','1212121212','John Details','1212112323434','211121312323','http://daxwellonline.com/dax/manufacturer_images/1261523479Daxwell_logo.jpg'),(2,6,'Oreiental Crest','abc','houston','TX','China','56789','test','','','');

--
-- Table structure for table `daxwell_might_also_like`
--

CREATE TABLE `daxwell_might_also_like` (
  `might_id` int(11) NOT NULL auto_increment,
  `main_product_id` int(11) NOT NULL,
  `might_product_id` int(11) NOT NULL,
  PRIMARY KEY  (`might_id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_might_also_like`
--


INSERT INTO `daxwell_might_also_like` VALUES (2,4,3),(4,2,3),(5,2,6),(12,7,4),(13,7,21);

--
-- Table structure for table `daxwell_mystore`
--

CREATE TABLE `daxwell_mystore` (
  `mystore_id` int(11) NOT NULL auto_increment,
  `store_name` varchar(255) NOT NULL,
  `store_owner` varchar(255) NOT NULL,
  `email_address` varchar(255) NOT NULL,
  `email_from` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `zone` varchar(255) NOT NULL,
  `store_address` text NOT NULL,
  `display_prices_with_tax` enum('N','Y') NOT NULL,
  `phone` varchar(255) NOT NULL,
  PRIMARY KEY  (`mystore_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_mystore`
--


INSERT INTO `daxwell_mystore` VALUES (1,'admin1','admin2','admin@admin.com','admin@admin.com','United States','Florida','Store Name\r\nAddress\r\nCountry\r\nPhone','Y','9685741236');

--
-- Table structure for table `daxwell_negotiation_conversation`
--

CREATE TABLE `daxwell_negotiation_conversation` (
  `negotiation_id` int(11) NOT NULL auto_increment,
  `order_id` int(11) NOT NULL,
  `message` text NOT NULL,
  `post_date` datetime NOT NULL,
  PRIMARY KEY  (`negotiation_id`)
) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_negotiation_conversation`
--


INSERT INTO `daxwell_negotiation_conversation` VALUES (1,49,'This is a test','2010-01-20 13:58:03'),(3,49,'','2010-01-20 14:07:00'),(4,49,'This is conversation test text','2010-01-20 14:07:22'),(5,66,'today I entered some data','2010-01-20 17:38:54'),(6,66,'I entered some more information','2010-01-20 17:46:55'),(7,64,'this is a test for the conversation log, there will be more information provided later to give a quote\r\n','2010-01-20 18:52:25'),(8,67,'this is a test for this conversation log entry','2010-01-20 19:00:09'),(9,67,'this is a tes','2010-01-20 19:01:08'),(10,67,'this is another test and will show all log','2010-01-20 19:06:04'),(11,67,'Another one','2010-01-20 19:15:01'),(12,67,'this is order id 67','2010-01-20 19:19:31'),(13,67,'this is a test for 67','2010-01-20 19:29:49'),(14,67,'','2010-01-20 19:55:10'),(15,67,'','2010-01-20 19:56:44'),(16,67,'this','2010-01-20 20:53:29'),(17,58,'This is a test','2010-01-21 00:17:28'),(18,52,'this is test','2010-01-21 13:13:03'),(19,52,'this is test 2','2010-01-21 13:13:11'),(20,70,'This is a test for this order','2010-01-21 14:45:28'),(21,70,'I will enter another comments \r\nthis is another line\r\nthis is 3line\r\nthis is 4th line\r\nthis is 5th line\r\nthis is 10 thline\r\nthis is 9th line\r\n','2010-01-21 14:46:35'),(22,70,'this is 3lin3','2010-01-21 14:47:15'),(23,70,'this is 4th line','2010-01-21 14:47:23'),(24,70,'this is 5thlinke','2010-01-21 14:47:32'),(25,70,'','2010-01-21 14:47:34'),(26,70,'this is another line','2010-01-21 14:47:41'),(27,70,'this','2010-01-21 16:39:45'),(28,70,'thid','2010-01-21 16:40:09'),(29,70,'this ti a test','2010-01-21 16:42:59'),(30,70,'this','2010-01-21 16:43:58'),(31,70,'this is new','2010-01-21 17:20:10'),(32,70,'','2010-01-21 18:03:39'),(33,75,'this is a test','2010-01-21 22:00:15'),(34,75,'another test','2010-01-21 22:00:31'),(35,77,'this is test','2010-01-24 11:24:40'),(36,77,'teat','2010-01-24 11:26:20'),(37,77,'test','2010-01-24 11:26:26'),(38,77,'test','2010-01-24 11:26:31'),(39,77,'test','2010-01-24 11:26:36'),(40,77,'test','2010-01-24 11:26:40'),(41,58,'This is the second test','2010-01-24 11:26:40'),(42,77,'test','2010-01-24 11:26:44'),(43,77,'test','2010-01-24 11:26:48'),(44,77,'test','2010-01-24 11:26:54'),(45,77,'test\ntest2\ntest3\ntest4','2010-01-24 11:27:28');

--
-- Table structure for table `daxwell_order_log_conversation`
--

CREATE TABLE `daxwell_order_log_conversation` (
  `conversation_id` int(11) NOT NULL auto_increment,
  `order_id` int(11) NOT NULL,
  `conversation_text` blob NOT NULL,
  `order_log_id` int(11) NOT NULL,
  `super_id` int(11) NOT NULL,
  `who_sent` varchar(100) NOT NULL,
  `date_of_conversation` datetime NOT NULL,
  PRIMARY KEY  (`conversation_id`)
) ENGINE=MyISAM AUTO_INCREMENT=91 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_order_log_conversation`
--


INSERT INTO `daxwell_order_log_conversation` VALUES (1,1,'This is the test for user',1,1,'admin_2','2010-01-08 19:57:59'),(2,27,'',2,2,'admin_2','2010-01-13 18:02:11'),(3,27,'',3,3,'admin_2','2010-01-13 18:02:33'),(4,26,'',4,4,'admin_2','2010-01-13 18:03:00'),(5,25,'',5,5,'admin_2','2010-01-13 18:07:17'),(6,24,'',6,6,'admin_2','2010-01-13 18:07:49'),(7,23,'',7,7,'admin_2','2010-01-13 18:08:30'),(8,22,'',8,8,'admin_2','2010-01-13 18:15:57'),(9,28,'',9,9,'admin_2','2010-01-13 19:02:57'),(10,31,'',10,10,'admin_2','2010-01-13 19:30:39'),(11,31,'',11,11,'admin_2','2010-01-13 19:46:23'),(12,30,'',12,12,'admin_2','2010-01-13 19:47:35'),(13,29,'',13,13,'admin_2','2010-01-13 20:03:13'),(14,31,'',14,14,'admin_2','2010-01-13 20:06:21'),(15,31,'',15,15,'admin_2','2010-01-13 20:07:07'),(16,31,'',16,16,'admin_2','2010-01-13 20:25:57'),(17,32,'',17,17,'admin_2','2010-01-13 20:49:10'),(18,33,'',18,18,'admin_2','2010-01-13 20:52:43'),(19,34,'',19,19,'admin_2','2010-01-13 20:55:15'),(20,35,'',20,20,'admin_2','2010-01-13 21:01:28'),(21,35,'',21,21,'admin_2','2010-01-13 21:04:24'),(22,35,'',22,22,'admin_2','2010-01-13 21:12:17'),(23,35,'',23,23,'admin_2','2010-01-13 21:23:21'),(24,35,'',24,24,'admin_2','2010-01-13 21:31:21'),(25,35,'',25,25,'admin_2','2010-01-13 21:31:38'),(26,35,'',26,26,'admin_2','2010-01-13 21:36:22'),(27,35,'',27,27,'admin_2','2010-01-13 21:36:36'),(28,35,'',28,28,'admin_2','2010-01-13 21:37:19'),(29,35,'',29,29,'admin_2','2010-01-13 21:38:36'),(30,35,'',30,30,'admin_2','2010-01-13 21:40:37'),(31,35,'',31,31,'admin_2','2010-01-13 21:44:57'),(32,35,'',32,32,'admin_2','2010-01-13 21:49:30'),(33,35,'',33,33,'admin_2','2010-01-13 21:53:08'),(34,35,'',34,34,'admin_2','2010-01-13 21:56:56'),(35,35,'',35,35,'admin_2','2010-01-13 22:01:35'),(36,35,'',36,36,'admin_2','2010-01-13 22:02:47'),(37,35,'',37,37,'admin_2','2010-01-13 22:04:37'),(38,35,'',38,38,'admin_2','2010-01-13 22:10:41'),(39,35,'',39,39,'admin_2','2010-01-13 22:17:05'),(40,35,'',40,40,'admin_2','2010-01-13 22:37:00'),(41,2,'',41,41,'admin_2','2010-01-14 00:19:33'),(42,36,'',42,42,'admin_2','2010-01-14 11:11:28'),(43,36,'',43,43,'admin_2','2010-01-14 11:14:50'),(44,19,'',44,44,'admin_2','2010-01-14 11:22:43'),(45,19,'',45,45,'admin_2','2010-01-14 11:23:19'),(46,19,'',46,46,'admin_2','2010-01-14 11:24:42'),(47,19,'',47,47,'admin_2','2010-01-14 11:26:50'),(48,19,'',48,48,'admin_2','2010-01-14 11:33:42'),(49,19,'',49,49,'admin_2','2010-01-14 11:34:10'),(50,1,'',50,50,'admin_2','2010-01-14 12:18:32'),(51,37,'',51,51,'admin_2','2010-01-14 14:24:44'),(52,18,'',52,52,'admin_2','2010-01-14 14:29:45'),(53,37,'',53,53,'admin_2','2010-01-14 14:30:53'),(54,17,'',54,54,'admin_2','2010-01-14 14:34:27'),(55,37,'',55,55,'admin_2','2010-01-14 14:35:30'),(56,37,'',56,56,'admin_2','2010-01-14 14:37:17'),(57,17,'',57,57,'admin_2','2010-01-14 14:39:49'),(58,37,'',58,58,'admin_2','2010-01-14 14:40:04'),(59,16,'',59,59,'admin_2','2010-01-14 14:41:28'),(60,37,'',60,60,'admin_2','2010-01-14 14:43:16'),(61,15,'',61,61,'admin_2','2010-01-14 14:44:01'),(62,37,'',62,62,'admin_2','2010-01-14 14:48:10'),(63,37,'',63,63,'admin_2','2010-01-14 14:49:10'),(64,37,'',64,64,'admin_2','2010-01-14 14:50:06'),(65,14,'',65,65,'admin_2','2010-01-14 14:51:22'),(66,37,'',66,66,'admin_2','2010-01-14 16:25:52'),(67,37,'',67,67,'admin_2','2010-01-14 16:30:44'),(68,37,'',68,68,'admin_2','2010-01-14 16:35:26'),(69,37,'',69,69,'admin_2','2010-01-14 16:42:00'),(70,9,'',70,70,'admin_2','2010-01-14 16:46:54'),(71,37,'',71,71,'admin_2','2010-01-14 16:47:17'),(72,37,'',72,72,'admin_2','2010-01-14 16:48:42'),(73,21,'',73,73,'admin_2','2010-01-14 17:14:58'),(74,36,'\r\n\r\n\r\n\r\n',74,74,'admin_2','2010-01-14 17:15:44'),(75,36,'',75,75,'admin_2','2010-01-14 17:15:53'),(76,36,'',76,76,'admin_2','2010-01-14 17:16:00'),(77,36,'',77,77,'admin_2','2010-01-14 17:16:11'),(78,36,'',78,78,'admin_2','2010-01-14 17:16:25'),(79,36,'',79,79,'admin_2','2010-01-14 17:16:35'),(80,8,'',80,80,'admin_2','2010-01-14 17:32:18'),(81,7,'',81,81,'admin_2','2010-01-14 17:33:55'),(82,6,'',82,82,'admin_2','2010-01-14 17:37:08'),(83,33,'',83,83,'admin_2','2010-01-14 17:37:41'),(84,33,'',84,84,'admin_2','2010-01-14 17:39:53'),(85,33,'',85,85,'admin_2','2010-01-14 17:41:06'),(86,5,'',86,86,'admin_2','2010-01-14 17:54:17'),(87,4,'',87,87,'admin_2','2010-01-14 17:54:42'),(88,10,'',88,88,'admin_2','2010-01-14 17:54:54'),(89,20,'',89,89,'admin_2','2010-01-14 17:55:44'),(90,29,'',90,90,'admin_2','2010-01-14 18:04:03');

--
-- Table structure for table `daxwell_order_log_final`
--

CREATE TABLE `daxwell_order_log_final` (
  `order_log_final_id` int(11) NOT NULL auto_increment,
  `super_id` int(11) NOT NULL,
  `order_log_id` int(11) NOT NULL,
  `price_level` varchar(100) NOT NULL,
  `original_discount_level` varchar(100) NOT NULL,
  `original_profit_margin` varchar(100) NOT NULL,
  `original_cost_total` varchar(100) NOT NULL,
  `original_quote_total` varchar(100) NOT NULL,
  `original_discount_total` varchar(100) NOT NULL,
  `current_discount_level` varchar(100) NOT NULL,
  `current_profit_margin` varchar(100) NOT NULL,
  `current_quote_total` varchar(100) NOT NULL,
  PRIMARY KEY  (`order_log_final_id`)
) ENGINE=MyISAM AUTO_INCREMENT=91 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_order_log_final`
--


INSERT INTO `daxwell_order_log_final` VALUES (1,1,1,'50','14.94','30.5','9000','13500','11745','13.6','29.6','11664'),(2,2,2,'100','10','80','239','478','430.2','0','-100',''),(3,3,3,'100','10','80','239','478','430.2','0','-100',''),(4,4,4,'100','15','70','342','684','581.4','15','70','581.4'),(5,5,5,'100','10','80','234','468','421.2','10','80','421.2'),(6,6,6,'100','10','80','222','444','399.6','10','80','399.6'),(7,7,7,'100','0','-100','256','0','0','0','-100','0'),(8,8,8,'100','20','93.21','424','1024','819.2','20','93.21','819.2'),(9,9,9,'100','20','60','662','1324','1059.2','20','60','1059.2'),(10,10,10,'100','11.16','79.92','1010','2020','1817.2','','','100'),(11,11,11,'100','25','50','1010','2020','1515','25','50','1515'),(12,12,12,'100','10','80','210','420','378','10','80','378'),(13,13,13,'100','20','60','810','1620','1296','20','60','1296'),(14,14,14,'100','25','50','1010','2020','1515','25','50','1515'),(15,15,15,'100','25','50','1010','2020','1515','25','50','1515'),(16,16,16,'100','25','50','1010','2020','1515','25','50','1515'),(17,17,17,'100','20','60','628','1256','1004.8','20','60','1004.8'),(18,18,18,'100','20','60','810','1620','1296','20','60','1296'),(19,19,19,'100','10','80','206','412','370.8','10','80','370.8'),(20,20,20,'100','10','80','210','420','378','10','80','378'),(21,21,21,'100','10','80','210','420','378','10','80','378'),(22,22,22,'100','10','80','210','420','378','10','80','378'),(23,23,23,'100','10','80','210','420','378','10','80','378'),(24,24,24,'100','10','80','210','420','378','10','80','378'),(25,25,25,'100','10','80','210','420','378','10','80','378'),(26,26,26,'100','10','80','210','420','378','10','80','378'),(27,27,27,'100','10','80','210','420','378','10','80','378'),(28,28,28,'100','10','80','210','420','378','10','80','378'),(29,29,29,'100','10','80','210','420','378','10','80','378'),(30,30,30,'100','10','80','210','420','378','10','80','378'),(31,31,31,'100','10','80','210','420','378','10','80','378'),(32,32,32,'100','10','80','210','420','378','10','80','378'),(33,33,33,'100','10','80','210','420','378','10','80','378'),(34,34,34,'100','10','80','210','420','378','10','80','378'),(35,35,35,'100','10','80','210','420','378','10','80','378'),(36,36,36,'100','10','80','210','420','378','10','80','378'),(37,37,37,'100','10','80','210','420','378','10','80','378'),(38,38,38,'100','10','80','210','420','378','10','80','378'),(39,39,39,'100','10','80','210','420','378','10','80','378'),(40,40,40,'100','10','80','210','420','378','10','80','378'),(41,41,41,'100','0','-100','300','400','','0','-100',''),(42,42,42,'100','10','80','210','420','378','15','70','357'),(43,43,43,'100','10','80','210','420','378','15','70','357'),(44,44,44,'100','15','87.41','249','549','466.65','20','76.39','439.20000000000004'),(45,45,45,'100','15','87.41','249','549','466.65','25','-100',''),(46,46,46,'100','15','87.41','249','549','466.65','25','-100',''),(47,47,47,'100','15','87.41','249','549','466.65','25','65.36','411.75'),(48,48,48,'100','15','87.41','249','549','466.65','25','65.36','411.75'),(49,49,49,'100','15','87.41','249','549','466.65','25','65.36','411.75'),(50,50,50,'100','0','-100','9000','27600','','0','-100',''),(51,51,51,'100','10','80','210','420','378','10','80','378'),(52,52,52,'100','20','97.07','410','1010','808','20','97.07','808'),(53,53,53,'100','10','80','210','420','378','10','-100',''),(54,54,54,'100','0','-100','850','2050','','0','-100',''),(55,55,55,'100','10','80','210','420','378','10','-100',''),(56,56,56,'100','10','80','210','420','378','10','-100',''),(57,57,57,'100','0','-100','850','2050','','0','-100',''),(58,58,58,'100','10','80','210','420','378','10','-100',''),(59,59,59,'100','15','90.37','242','542','460.7','15','90.37','460.7'),(60,60,60,'100','10','80','210','420','378','5','-100',''),(61,61,61,'100','20','95.02','626','1526','1220.8','0','-100',''),(62,62,62,'100','10','80','210','420','378','10','-100',''),(63,63,63,'100','10','80','210','420','378','40','-100',''),(64,64,64,'100','10','80','210','420','378','40','-100',''),(65,65,65,'100','0','-100','644','1544','','40','43.85','926.4'),(66,66,66,'100','10','80','210','420','378','40','-100',''),(67,67,67,'100','10','80','210','420','378','10','-100',''),(68,68,68,'100','10','80','210','420','378','10','-100',''),(69,69,69,'100','10','80','210','420','378','10','-100',''),(70,70,70,'100','0','-100','206','506','','0','-100',''),(71,71,71,'100','10','80','210','420','378','10','-100',''),(72,72,72,'100','10','80','210','420','378','10','-100',''),(73,73,73,'100','<br />\r\n<b>Warning</b>:  Division by zero in <b>/home/content/49/5389749/html/dax/library/log_functi','<br />\r\n<b>Warning</b>:  Division by zero in <b>/home/content/49/5389749/html/dax/library/log_functi','0','0','0','','',''),(74,74,74,'100','11.35','79.62','210','420','377.2','','',''),(75,75,75,'100','11.35','79.62','210','420','377.2','','',''),(76,76,76,'100','11.35','79.62','210','420','377.2','','',''),(77,77,77,'100','11.35','79.62','210','420','377.2','','',''),(78,78,78,'100','11.35','79.62','210','420','377.2','','',''),(79,79,79,'100','11.35','79.62','210','420','377.2','','',''),(80,80,80,'100','0','-100','200','500','','56','10','220'),(81,81,81,'100','0','-100','402','1002','','0','-100',''),(82,82,82,'100','0','-100','501','601','','0','-100',''),(83,83,83,'100','20','60','810','1620','1296','20','60','1296'),(84,84,84,'100','20','60','810','1620','1296','48','5','850.5'),(85,85,85,'100','20','60','810','1620','1296','48','5','850.5'),(86,86,86,'100','13.97','75.49','1104','2208','1937.4','','',''),(87,87,87,'100','5.26','90','100','200','190','','',''),(88,88,88,'100','<br />\r\n<b>Warning</b>:  Division by zero in <b>/home/content/49/5389749/html/dax/library/log_functi','<br />\r\n<b>Warning</b>:  Division by zero in <b>/home/content/49/5389749/html/dax/library/log_functi','0','0','0','','',''),(89,89,89,'100','<br />\r\n<b>Warning</b>:  Division by zero in <b>/home/content/49/5389749/html/dax/library/log_functi','<br />\r\n<b>Warning</b>:  Division by zero in <b>/home/content/49/5389749/html/dax/library/log_functi','0','0','0','','',''),(90,90,90,'100','11.17','79.9','810','1620','1457.2','10','','');

--
-- Table structure for table `daxwell_order_log_insurance_tax`
--

CREATE TABLE `daxwell_order_log_insurance_tax` (
  `insurance_tax_id` int(11) NOT NULL auto_increment,
  `super_id` int(11) NOT NULL,
  `order_log_id` int(11) NOT NULL,
  `shipping_handling` varchar(100) NOT NULL,
  `insurance` varchar(100) NOT NULL,
  PRIMARY KEY  (`insurance_tax_id`)
) ENGINE=MyISAM AUTO_INCREMENT=91 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_order_log_insurance_tax`
--


INSERT INTO `daxwell_order_log_insurance_tax` VALUES (1,1,1,'1000','250'),(2,2,2,'',''),(3,3,3,'',''),(4,4,4,'',''),(5,5,5,'',''),(6,6,6,'',''),(7,7,7,'',''),(8,8,8,'',''),(9,9,9,'',''),(10,10,10,'',''),(11,11,11,'',''),(12,12,12,'',''),(13,13,13,'',''),(14,14,14,'',''),(15,15,15,'',''),(16,16,16,'',''),(17,17,17,'',''),(18,18,18,'',''),(19,19,19,'',''),(20,20,20,'',''),(21,21,21,'',''),(22,22,22,'',''),(23,23,23,'',''),(24,24,24,'',''),(25,25,25,'',''),(26,26,26,'',''),(27,27,27,'',''),(28,28,28,'',''),(29,29,29,'',''),(30,30,30,'',''),(31,31,31,'',''),(32,32,32,'',''),(33,33,33,'',''),(34,34,34,'',''),(35,35,35,'',''),(36,36,36,'',''),(37,37,37,'',''),(38,38,38,'',''),(39,39,39,'',''),(40,40,40,'',''),(41,41,41,'',''),(42,42,42,'',''),(43,43,43,'',''),(44,44,44,'',''),(45,45,45,'',''),(46,46,46,'',''),(47,47,47,'',''),(48,48,48,'',''),(49,49,49,'',''),(50,50,50,'',''),(51,51,51,'80','20'),(52,52,52,'0','0'),(53,53,53,'80','20'),(54,54,54,'0','0'),(55,55,55,'80','20'),(56,56,56,'80','20'),(57,57,57,'0','0'),(58,58,58,'80','20'),(59,59,59,'0','0'),(60,60,60,'80','20'),(61,61,61,'0','0'),(62,62,62,'80','20'),(63,63,63,'80','20'),(64,64,64,'80','20'),(65,65,65,'0','0'),(66,66,66,'80','20'),(67,67,67,'80','20'),(68,68,68,'80','20'),(69,69,69,'80','20'),(70,70,70,'0','0'),(71,71,71,'80','20'),(72,72,72,'80','20'),(73,73,73,'',''),(74,74,74,'',''),(75,75,75,'',''),(76,76,76,'',''),(77,77,77,'',''),(78,78,78,'',''),(79,79,79,'',''),(80,80,80,'0','0'),(81,81,81,'0','0'),(82,82,82,'0','0'),(83,83,83,'0','0'),(84,84,84,'0','0'),(85,85,85,'0','0'),(86,86,86,'',''),(87,87,87,'',''),(88,88,88,'',''),(89,89,89,'',''),(90,90,90,'','');

--
-- Table structure for table `daxwell_order_log_master`
--

CREATE TABLE `daxwell_order_log_master` (
  `order_log_id` int(11) NOT NULL auto_increment,
  `order_id` int(11) NOT NULL,
  `super_id` int(11) NOT NULL,
  PRIMARY KEY  (`order_log_id`)
) ENGINE=MyISAM AUTO_INCREMENT=91 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_order_log_master`
--


INSERT INTO `daxwell_order_log_master` VALUES (1,1,1),(2,27,2),(3,27,3),(4,26,4),(5,25,5),(6,24,6),(7,23,7),(8,22,8),(9,28,9),(10,31,10),(11,31,11),(12,30,12),(13,29,13),(14,31,14),(15,31,15),(16,31,16),(17,32,17),(18,33,18),(19,34,19),(20,35,20),(21,35,21),(22,35,22),(23,35,23),(24,35,24),(25,35,25),(26,35,26),(27,35,27),(28,35,28),(29,35,29),(30,35,30),(31,35,31),(32,35,32),(33,35,33),(34,35,34),(35,35,35),(36,35,36),(37,35,37),(38,35,38),(39,35,39),(40,35,40),(41,2,41),(42,36,42),(43,36,43),(44,19,44),(45,19,45),(46,19,46),(47,19,47),(48,19,48),(49,19,49),(50,1,50),(51,37,51),(52,18,52),(53,37,53),(54,17,54),(55,37,55),(56,37,56),(57,17,57),(58,37,58),(59,16,59),(60,37,60),(61,15,61),(62,37,62),(63,37,63),(64,37,64),(65,14,65),(66,37,66),(67,37,67),(68,37,68),(69,37,69),(70,9,70),(71,37,71),(72,37,72),(73,21,73),(74,36,74),(75,36,75),(76,36,76),(77,36,77),(78,36,78),(79,36,79),(80,8,80),(81,7,81),(82,6,82),(83,33,83),(84,33,84),(85,33,85),(86,5,86),(87,4,87),(88,10,88),(89,20,89),(90,29,90);

--
-- Table structure for table `daxwell_order_log_master_products_price`
--

CREATE TABLE `daxwell_order_log_master_products_price` (
  `order_log_product_id` int(11) NOT NULL auto_increment,
  `order_log_id` int(11) NOT NULL,
  `super_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `quantity` int(11) NOT NULL,
  `unit_cost` varchar(100) NOT NULL,
  `unit_original_quote` varchar(100) NOT NULL,
  `unit_original_discount_price` varchar(100) NOT NULL,
  `current_unit_quote` varchar(100) NOT NULL,
  `total_cost` varchar(100) NOT NULL,
  `total_original_quote` varchar(100) NOT NULL,
  `total_original_discount_price` varchar(100) NOT NULL,
  `total_current_quote` varchar(100) NOT NULL,
  PRIMARY KEY  (`order_log_product_id`)
) ENGINE=MyISAM AUTO_INCREMENT=349 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_order_log_master_products_price`
--


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

--
-- Table structure for table `daxwell_order_log_shipment_tracking`
--

CREATE TABLE `daxwell_order_log_shipment_tracking` (
  `ship_id` int(11) NOT NULL auto_increment,
  `order_log_id` int(11) NOT NULL,
  `super_id` int(11) NOT NULL,
  `shipment_tracking_number` varchar(100) NOT NULL,
  `estimate_total_arival_time` varchar(255) NOT NULL,
  `date_of_add` datetime NOT NULL,
  PRIMARY KEY  (`ship_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_order_log_shipment_tracking`
--



--
-- Table structure for table `daxwell_order_log_super_master`
--

CREATE TABLE `daxwell_order_log_super_master` (
  `super_id` int(11) NOT NULL auto_increment,
  `order_id` int(11) NOT NULL,
  `date_of_add` datetime NOT NULL,
  PRIMARY KEY  (`super_id`)
) ENGINE=MyISAM AUTO_INCREMENT=91 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_order_log_super_master`
--


INSERT INTO `daxwell_order_log_super_master` VALUES (1,1,'0000-00-00 00:00:00'),(2,27,'2010-01-13 18:02:11'),(3,27,'2010-01-13 18:02:33'),(4,26,'2010-01-13 18:03:00'),(5,25,'2010-01-13 18:07:17'),(6,24,'2010-01-13 18:07:49'),(7,23,'2010-01-13 18:08:30'),(8,22,'2010-01-13 18:15:57'),(9,28,'2010-01-13 19:02:57'),(10,31,'2010-01-13 19:30:39'),(11,31,'2010-01-13 19:46:23'),(12,30,'2010-01-13 19:47:35'),(13,29,'2010-01-13 20:03:13'),(14,31,'2010-01-13 20:06:21'),(15,31,'2010-01-13 20:07:07'),(16,31,'2010-01-13 20:25:57'),(17,32,'2010-01-13 20:49:10'),(18,33,'2010-01-13 20:52:43'),(19,34,'2010-01-13 20:55:15'),(20,35,'2010-01-13 21:01:28'),(21,35,'2010-01-13 21:04:24'),(22,35,'2010-01-13 21:12:17'),(23,35,'2010-01-13 21:23:21'),(24,35,'2010-01-13 21:31:21'),(25,35,'2010-01-13 21:31:38'),(26,35,'2010-01-13 21:36:22'),(27,35,'2010-01-13 21:36:36'),(28,35,'2010-01-13 21:37:19'),(29,35,'2010-01-13 21:38:36'),(30,35,'2010-01-13 21:40:37'),(31,35,'2010-01-13 21:44:57'),(32,35,'2010-01-13 21:49:30'),(33,35,'2010-01-13 21:53:08'),(34,35,'2010-01-13 21:56:56'),(35,35,'2010-01-13 22:01:35'),(36,35,'2010-01-13 22:02:47'),(37,35,'2010-01-13 22:04:37'),(38,35,'2010-01-13 22:10:41'),(39,35,'2010-01-13 22:17:05'),(40,35,'2010-01-13 22:37:00'),(41,2,'2010-01-14 00:19:33'),(42,36,'2010-01-14 11:11:28'),(43,36,'2010-01-14 11:14:50'),(44,19,'2010-01-14 11:22:43'),(45,19,'2010-01-14 11:23:19'),(46,19,'2010-01-14 11:24:42'),(47,19,'2010-01-14 11:26:50'),(48,19,'2010-01-14 11:33:42'),(49,19,'2010-01-14 11:34:10'),(50,1,'2010-01-14 12:18:32'),(51,37,'2010-01-14 14:24:44'),(52,18,'2010-01-14 14:29:45'),(53,37,'2010-01-14 14:30:53'),(54,17,'2010-01-14 14:34:27'),(55,37,'2010-01-14 14:35:30'),(56,37,'2010-01-14 14:37:17'),(57,17,'2010-01-14 14:39:49'),(58,37,'2010-01-14 14:40:04'),(59,16,'2010-01-14 14:41:28'),(60,37,'2010-01-14 14:43:16'),(61,15,'2010-01-14 14:44:01'),(62,37,'2010-01-14 14:48:10'),(63,37,'2010-01-14 14:49:10'),(64,37,'2010-01-14 14:50:06'),(65,14,'2010-01-14 14:51:22'),(66,37,'2010-01-14 16:25:52'),(67,37,'2010-01-14 16:30:44'),(68,37,'2010-01-14 16:35:26'),(69,37,'2010-01-14 16:42:00'),(70,9,'2010-01-14 16:46:54'),(71,37,'2010-01-14 16:47:17'),(72,37,'2010-01-14 16:48:42'),(73,21,'2010-01-14 17:14:58'),(74,36,'2010-01-14 17:15:44'),(75,36,'2010-01-14 17:15:53'),(76,36,'2010-01-14 17:16:00'),(77,36,'2010-01-14 17:16:11'),(78,36,'2010-01-14 17:16:25'),(79,36,'2010-01-14 17:16:35'),(80,8,'2010-01-14 17:32:18'),(81,7,'2010-01-14 17:33:55'),(82,6,'2010-01-14 17:37:08'),(83,33,'2010-01-14 17:37:41'),(84,33,'2010-01-14 17:39:53'),(85,33,'2010-01-14 17:41:06'),(86,5,'2010-01-14 17:54:17'),(87,4,'2010-01-14 17:54:42'),(88,10,'2010-01-14 17:54:54'),(89,20,'2010-01-14 17:55:44'),(90,29,'2010-01-14 18:04:03');

--
-- Table structure for table `daxwell_other_charges`
--

CREATE TABLE `daxwell_other_charges` (
  `chages_id` int(11) NOT NULL auto_increment,
  `product_id` int(11) NOT NULL,
  `charges_name` varchar(255) NOT NULL,
  `amount` varchar(20) NOT NULL,
  PRIMARY KEY  (`chages_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_other_charges`
--



--
-- Table structure for table `daxwell_payment_modules`
--

CREATE TABLE `daxwell_payment_modules` (
  `payment_modules_id` int(11) NOT NULL auto_increment,
  `payment_modules_name` varchar(255) NOT NULL,
  `paypal_email` varchar(255) NOT NULL,
  `status` enum('Y','N') NOT NULL,
  PRIMARY KEY  (`payment_modules_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_payment_modules`
--


INSERT INTO `daxwell_payment_modules` VALUES (1,'PayPal Website Payments Standard','ajay_akd@yahoo.co.in','Y');

--
-- Table structure for table `daxwell_previllage`
--

CREATE TABLE `daxwell_previllage` (
  `previllage_id` int(11) NOT NULL auto_increment,
  `previllage_name` varchar(200) NOT NULL,
  PRIMARY KEY  (`previllage_id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `daxwell_previllage`
--


INSERT INTO `daxwell_previllage` VALUES (1,'product_add'),(2,'product_delete'),(3,'product_edit'),(4,'product_view'),(5,'product_cost'),(6,'change_schedule'),(7,'aprove_schedule'),(8,'log_communication'),(9,'customer_details_view'),(10,'customer_details_edit'),(11,'customer_details_delete'),(12,'view_own_order'),(13,'view_all_order');

--
-- Table structure for table `daxwell_price_level`
--

CREATE TABLE `daxwell_price_level` (
  `price_level_id` int(11) NOT NULL auto_increment,
  `retailer_price_level` varchar(100) NOT NULL,
  `wholesaler_price_level` varchar(100) NOT NULL,
  PRIMARY KEY  (`price_level_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_price_level`
--


INSERT INTO `daxwell_price_level` VALUES (1,'150','100');

--
-- Table structure for table `daxwell_product`
--

CREATE TABLE `daxwell_product` (
  `product_id` int(11) NOT NULL auto_increment,
  `category_parent_id` int(11) NOT NULL default '1',
  `category_id` int(11) NOT NULL,
  `admin_id` int(11) NOT NULL,
  `manufacturer_id` int(11) NOT NULL,
  `product_name` varchar(255) NOT NULL,
  `product_short_desc` varchar(255) NOT NULL,
  `product_long_desc` blob NOT NULL,
  `product_model` varchar(100) NOT NULL,
  `color` varchar(100) NOT NULL,
  `width` varchar(20) NOT NULL,
  `height` varchar(20) NOT NULL,
  `depth` varchar(20) NOT NULL,
  `cost_price` varchar(20) NOT NULL,
  `customer_price` varchar(20) NOT NULL,
  `retailer_price` varchar(20) NOT NULL,
  `visitor_price` varchar(20) NOT NULL,
  `product_quantity` varchar(20) NOT NULL,
  `quantity_per_box` varchar(10) NOT NULL,
  `shipping_price` varchar(20) NOT NULL,
  `other_charges` enum('Y','N') NOT NULL default 'N',
  `is_delivery_cost` enum('Y','N') NOT NULL,
  `delivery_cost` varchar(20) NOT NULL,
  `product_weight` varchar(20) NOT NULL,
  `size_available` enum('Y','N') NOT NULL,
  `discount` enum('Y','N') NOT NULL,
  `discount_type` varchar(20) NOT NULL,
  `status` enum('Y','N') NOT NULL,
  `available` enum('Y','N') NOT NULL,
  `date_of_add` datetime NOT NULL,
  `date_of_edit` datetime NOT NULL,
  `flag` int(11) NOT NULL default '0' COMMENT '0-init 1-active 2-modified,nonactive  3-not approved 4-deleted 5-no longer available',
  PRIMARY KEY  (`product_id`)
) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `daxwell_product`
--


INSERT INTO `daxwell_product` VALUES (2,0,7,2,2,'kitchen knives','<p>A <b>kitchen knife</b> is any knife that is intended to be used in food preparation. While much of this work can be accomplished with a few general-purpose knives, there are also many specialized knives that are designed for specific tasks. Kitchen kni','<p>A <b>kitchen knife</b> is any knife that is intended to be used in food preparation. While much of this work can be accomplished with a few general-purpose knives, there are also many specialized knives that are designed for specific tasks. Kitchen knives can be made from several different materials.A <b>kitchen knife</b> is any knife that is intended to be used in food preparation. While much of this work can be accomplished with a few general-purpose knives, there are also many specialized knives that are designed for specific tasks. Kitchen knives can be made from several different materials.</p>','','Steel','10','100','5','300','600','400','800','50','16','','N','N','100','100gm','','Y','','Y','Y','2009-12-30 12:14:42','2009-12-30 13:00:52',1),(3,0,5,2,2,'Forks','<p>As a piece of cutlery or kitchenware, a <b>fork</b> is a tool consisting of a handle with several narrow tines (usually two, three or four) on one end.&nbsp;</p>','<p>As a piece of cutlery or kitchenware, a <b>fork</b> is a tool consisting of a handle with several narrow tines (usually two, three or four) on one end. The fork, as an eating utensil, has been a feature primarily of the West, whereas in East Asia chopsticks have been more prevalent. Today, forks are increasingly available throughout East Asia. The utensil (usually metal) is used to lift food to the mouth or to hold food in place while cooking or cutting it. Food can be lifted either by spearing it on the tines, or by holding it on top of the tines, which are often curved slightly. For this latter function, in the American style of fork etiquette, the fork is held with tines curving up; however, in continental style, the fork is held with the tines curving down.</p>','FM001','Silver','2','10','1','100','600','300','900','400','18','200','N','Y','100','100','','Y','','Y','Y','2010-01-03 10:32:06','0000-00-00 00:00:00',1),(4,0,4,2,2,'Flatware Set','<ul>\r\n    <li><b>Cutlery</b> refers to any hand implement used in preparing, serving, and especially eating food in the Western world. It is more usually known as silverware or flatware in the United States, where <i>cutlery</i> can have the more specific','<p>&nbsp;</p>\r\n<p><b>Cutlery</b> refers to any hand implement used in preparing, serving, and especially eating food in the Western world. It is more usually known as silverware or flatware in the United States, where <i>cutlery</i> can have the more specific meaning of knives and other cutting instruments. This is probably the original meaning of the word. Since <i>silverware</i> suggests the presence of silver, the term tableware has come into use.</p>\r\n<p style=\\\"margin-left: 40px\\\"><b>-- Cutlery</b> refers to any hand implement used in preparing, serving, and especially eating food in the Western world. It is more usually known as silverware or flatware in the United States, where <i>cutlery</i> can have the more specific meaning of knives and other cutting instruments. This is probably the original meaning of the word. Since <i>silverware</i> suggests the presence of silver, the term tableware has come into use.</p>\r\n<p style=\\\"margin-left: 40px\\\"><b>-- Cutlery</b> refers to any hand implement used in preparing, serving, and especially eating food in the Western world. It is more usually known as silverware or flatware in the United States, where <i>cutlery</i> can have the more specific meaning of knives and other cutting instruments. This is probably the original meaning of the word. Since <i>silverware</i> suggests the presence of silver, the term tableware has come into use.</p>\r\n<p style=\\\"margin-left: 40px\\\">&nbsp;</p>\r\n<p style=\\\"margin-left: 40px\\\"><span style=\\\"font-size: larger\\\"><strong>The dimensions for this porduct are:</strong></span></p>','FS001','Steel','10','100','10','200','700','500','1000','10000','50','','N','Y','1200','100','','Y','','Y','Y','2010-01-03 11:02:51','2010-01-10 17:52:08',1),(5,0,6,2,2,'Sporks','spoon and fork ','<p>A <b>spork</b> or a <b>foon</b> is a hybrid form of cutlery taking the form of a spoon-like shallow scoop with three or four fork tines Spork-like utensils, such as the terrapin fork or ice cream fork, have been manufactured since the late 1800s;patents for spork-like designs date back to at least 1874, and the word &quot;spork&quot; was registered as a trademark in the US and the UK decades later. They are used by fast food restaurants, schools, prisons, the military and backpackers.</p>\r\n<p>The <i>spork</i> is a portmanteau word combining <i>spoon</i> and <i>fork</i>. Similarly, the word <i>foon</i> is a blend of <i>fork</i> and <i>spoon</i>. The word <i>&quot;spork&quot;</i> appeared in the 1909 supplement to the <i>Century Dictionary</i>, where it was described as a trade name and &quot;a \\\'portmanteau-word\\\' applied to a long, slender spoon having, at the end of the bowl, projections resembling the tines of a fork&quot;.</p>','SP001','Blue','1000','1000','1000','12000','18000','15000','24000','1200','100','','N','Y','2000','500','','Y','','Y','Y','2010-01-03 11:22:14','2010-01-03 11:28:03',0),(6,0,11,0,1,'Commercial Gloves','latex glove','<p>A <b>glove</b> (Middle English from Old English <i>glof</i>) is a garment covering the hand. Gloves have separate sheaths or openings for each finger and the thumb; if there is an opening but no covering sheath for each finger they are called &quot;fingerless gloves&quot;. Fingerless gloves with one large opening rather than individual openings for each finger are sometimes called gauntlets. Gloves which cover the entire hand but do not have separate finger openings or sheaths are called <b>mittens</b>. Mittens are warmer than gloves made of the same material because fingers maintain their warmth better when they are in contact with each other. Reduced surface area reduces heat loss.A <b>glove</b> (Middle English from Old English <i>glof</i>) is a garment covering the hand. Gloves have separate sheaths or openings for each finger and the thumb; if there is an opening but no covering sheath for each finger they are called &quot;fingerless gloves&quot;. Fingerless gloves with one large opening rather than individual openings for each finger are sometimes called gauntlets. Gloves which cover the entire hand but do not have separate finger openings or sheaths are called <b>mittens</b>. Mittens are warmer than gloves made of the same material because fingers maintain their warmth better when they are in contact with each other. Reduced surface area reduces heat loss.</p>','CG001','Red,Green,Blue,Yellow','15','30','10','1400','2500','2100','4000','1000000','12','9000','N','Y','3500','230','','Y','','Y','Y','2010-01-03 12:13:15','0000-00-00 00:00:00',0),(7,0,3,2,2,'test2','<p>test</p>','<p>test</p>','test2','red','1','1','1','5','10','12','12','12','12','','N','Y','5','1','','Y','','Y','Y','2010-01-08 10:41:46','2010-01-22 22:16:30',1),(10,0,4,2,2,'flat2','<p>flat2</p>','<p>flat2</p>','flat2','flat2','2','2','2','2','2','2','2','12','12','5','N','Y','5','2','','Y','','Y','Y','2010-01-08 10:52:20','0000-00-00 00:00:00',1),(11,0,4,2,2,'flat3','<p>flat4</p>','<p>flat4</p>','flat3','red','4','4','4','4','4','4','4','12','12','5','N','Y','5','4','','Y','','Y','Y','2010-01-08 10:55:08','0000-00-00 00:00:00',1),(12,0,4,2,2,'flat4','nice flatware','<p>flat4</p>','flat4','red','4','4','4','4','4','4','4','4','12','5','N','Y','5','4','','Y','','Y','Y','2010-01-08 10:58:05','0000-00-00 00:00:00',0),(13,0,4,2,2,'flat5','flatware 5','<p>flat5</p>','flat5','red','5','5','5','5','5','5','5','5','','5','N','Y','5','5','','Y','','Y','Y','2010-01-08 11:00:31','0000-00-00 00:00:00',0),(14,0,4,2,2,'flat6','<p>flat6</p>','<p>flat6</p>','flat6','flat6','6','6','6','6','6','6','6','6','6','5','N','Y','5','6','','Y','','Y','Y','2010-01-08 11:02:56','0000-00-00 00:00:00',1),(15,0,4,2,2,'flat7','flat7','<p>flat7</p>','flat7','flat7','7','7','7','7','7','7','7','7','7','5','N','Y','5','7','','Y','','Y','Y','2010-01-08 11:05:02','0000-00-00 00:00:00',0),(16,0,5,2,2,'fork1','fork1','<p>fork1</p>','fork1','fork1','1','1','1','1','1','1','1','1','1','5','N','Y','','1','','Y','','Y','Y','2010-01-08 11:06:52','0000-00-00 00:00:00',0),(17,0,5,2,2,'fork2','fork2','<p>fork2</p>','fork2','red','2','2','2','2','2','2','2','2','2','5','N','Y','5','2','','Y','','Y','Y','2010-01-08 11:08:27','0000-00-00 00:00:00',0),(19,0,5,2,2,'fork4','fork4','<p>fork4</p>','fork4','fork4','4','4','4','4','4','4','4','4','4','5','N','Y','5','4','','Y','','Y','Y','2010-01-08 11:12:49','0000-00-00 00:00:00',0),(20,0,5,2,2,'fork5','fork5','<p>fork5</p>','fork5','red','5','5','5','5','5','5','5','5','5','5','N','Y','5','5','','Y','','Y','Y','2010-01-08 11:35:34','0000-00-00 00:00:00',0),(21,0,5,2,2,'fork6','fork6','<p>fork6</p>','fork6','fork6','6','6','6','6','6','6','6','','','5','N','Y','5','6','','Y','','Y','Y','2010-01-08 11:52:56','0000-00-00 00:00:00',0),(22,0,5,2,2,'fork7','fork7','<p>fork7</p>','fork7','fork7','7','7','7','7','7','7','7','7','7','5','N','Y','5','7','','Y','','Y','Y','2010-01-08 11:54:41','0000-00-00 00:00:00',0),(24,0,7,2,2,'knife1','knife1','<p>knife1</p>','knife1','knife1','1','1','1','1','1','1','1','1','1','5','N','Y','5','1','','Y','','Y','Y','2010-01-08 11:59:00','0000-00-00 00:00:00',0),(25,0,7,2,2,'knife2','knif2','<p>knife2</p>','knife2','knife2','200','200','200','200','200','200','200','200','200','5','N','Y','5','200','','Y','','Y','Y','2010-01-08 12:12:41','0000-00-00 00:00:00',0);

--
-- Table structure for table `daxwell_product_discount`
--

CREATE TABLE `daxwell_product_discount` (
  `discount_id` int(11) NOT NULL auto_increment,
  `discount_type` varchar(255) NOT NULL default '',
  `discounts` float NOT NULL default '0',
  `type` enum('P','I') NOT NULL default 'P',
  PRIMARY KEY  (`discount_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `daxwell_product_discount`
--


INSERT INTO `daxwell_product_discount` VALUES (1,'Normal',7,'P'),(2,'Dhamaka',15,'P'),(3,'Special',9,'P'),(4,'Item Offer',2,'I'),(5,'Free',3,'P');

--
-- Table structure for table `daxwell_product_image`
--

CREATE TABLE `daxwell_product_image` (
  `image_id` int(11) NOT NULL auto_increment,
  `product_id` int(11) NOT NULL,
  `image_full_path` varchar(300) NOT NULL,
  PRIMARY KEY  (`image_id`)
) ENGINE=MyISAM AUTO_INCREMENT=111 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `daxwell_product_image`
--


INSERT INTO `daxwell_product_image` VALUES (6,2,'http://daxwellonline.com/dax/product_images/1262200482fallkniven-kitchen-knives.jpg'),(7,2,'http://daxwellonline.com/dax/product_images/1262200482kitchen_knives.jpg'),(8,2,'http://daxwellonline.com/dax/product_images/1262200482kitchen-knives.jpg'),(9,2,'http://daxwellonline.com/dax/product_images/1262200482pro-kitchen-knife-re-size.jpg'),(10,2,'http://daxwellonline.com/dax/product_images/1262200482throwingKnives7.jpg'),(11,3,'http://daxwellonline.com/dax/product_images/126253992657362.jpg'),(12,3,'http://daxwellonline.com/dax/product_images/12625399261331460-1-forks.jpg'),(13,3,'http://daxwellonline.com/dax/product_images/1262539926Art Deco cake forks (6)_Cake fork.Jpg'),(14,3,'http://daxwellonline.com/dax/product_images/1262539926Assorted_forks.jpg'),(15,3,'http://daxwellonline.com/dax/product_images/1262539926FONDUE_FORKS.jpg'),(16,3,'http://daxwellonline.com/dax/product_images/1262539926individual_08sForksSiloed4Prong.jpg'),(17,3,'http://daxwellonline.com/dax/product_images/1262539926mike-feeley-forks.jpg'),(18,4,'http://daxwellonline.com/dax/product_images/126254177141Vwoc4AnSL.jpg'),(19,4,'http://daxwellonline.com/dax/product_images/1262541771Heritage+45+Piece+Flatware+Set.jpg'),(20,4,'http://daxwellonline.com/dax/product_images/1262541771269067_810.jpg'),(21,4,'http://daxwellonline.com/dax/product_images/1262541771Naturewood+45+Piece+Flatware+Set.jpg'),(22,4,'http://daxwellonline.com/dax/product_images/1262541771Day+Break+20+Piece+Flatware+Set.jpg'),(23,4,'http://daxwellonline.com/dax/product_images/1262541771Windham+20+Piece+Flatware+Set.jpg'),(24,4,'http://daxwellonline.com/dax/product_images/1262541771gold sw.jpg'),(25,5,'http://daxwellonline.com/dax/product_images/12625429346a00d83451c3bd69e200e54f1d5b828834-800wi.jpg'),(26,5,'http://daxwellonline.com/dax/product_images/1262542934istockphoto_469885_spork.jpg'),(27,5,'http://daxwellonline.com/dax/product_images/1262542934spork.jpg'),(28,5,'http://daxwellonline.com/dax/product_images/1262542934spork1.jpg'),(29,5,'http://daxwellonline.com/dax/product_images/1262542934sporks.jpg'),(30,5,'http://daxwellonline.com/dax/product_images/1262542934spork-sul-l.jpg'),(31,5,'http://daxwellonline.com/dax/product_images/1262542934spork-sul-l.jpg'),(32,5,'http://daxwellonline.com/dax/product_images/1262542934te_spork_detail.jpg'),(33,6,'http://daxwellonline.com/dax/product_images/126254599541sKJCIM2eL._SL500_AA280_.jpg'),(34,6,'http://daxwellonline.com/dax/product_images/126254599551EhqIGn9HL.jpg'),(35,6,'http://daxwellonline.com/dax/product_images/1262545995092942701_1_271.jpg'),(36,6,'http://daxwellonline.com/dax/product_images/1262545995Open-source-Programmable-gloves-for-many-apps-450x329.jpg'),(37,6,'http://daxwellonline.com/dax/product_images/1262545995RCP9H00.JPG'),(38,6,'http://daxwellonline.com/dax/product_images/1262545995Showa-Best-Glove-introduce-Showa-hand-arm-protection-offering-to-Australian-industrial-markets.jpg'),(39,7,'http://www.daxwellonline.com/dax/product_images/1262972507fork_large.jpg'),(40,7,'http://www.daxwellonline.com/dax/product_images/1262972507flaware_bot2.jpg'),(41,7,'http://www.daxwellonline.com/dax/product_images/1262972507fork8.jpg'),(48,10,'http://daxwellonline.com/dax/product_images/1262973140fork4.jpg'),(49,10,'http://daxwellonline.com/dax/product_images/1262973140fork5.jpg'),(50,10,'http://daxwellonline.com/dax/product_images/1262973140fork6.jpg'),(51,11,'http://daxwellonline.com/dax/product_images/1262973308fork3.jpg'),(52,11,'http://daxwellonline.com/dax/product_images/1262973308fork4.jpg'),(53,11,'http://daxwellonline.com/dax/product_images/1262973308fork6.jpg'),(54,12,'http://daxwellonline.com/dax/product_images/1262973485fork5.jpg'),(55,12,'http://daxwellonline.com/dax/product_images/1262973485fork6.jpg'),(56,12,'http://daxwellonline.com/dax/product_images/1262973485fork1.jpg'),(57,13,'http://daxwellonline.com/dax/product_images/1262973631fork5.jpg'),(58,13,'http://daxwellonline.com/dax/product_images/1262973631fork6.jpg'),(59,13,'http://daxwellonline.com/dax/product_images/1262973631fork7.jpg'),(60,14,'http://daxwellonline.com/dax/product_images/1262973776fork1.jpg'),(61,14,'http://daxwellonline.com/dax/product_images/1262973776fork1.jpg'),(62,14,'http://daxwellonline.com/dax/product_images/1262973776fork1.jpg'),(63,15,'http://daxwellonline.com/dax/product_images/1262973902fork2.jpg'),(64,15,'http://daxwellonline.com/dax/product_images/1262973902fork2.jpg'),(65,15,'http://daxwellonline.com/dax/product_images/1262973902fork2.jpg'),(66,16,'http://daxwellonline.com/dax/product_images/1262974012fork1.jpg'),(67,16,'http://daxwellonline.com/dax/product_images/1262974012fork1.jpg'),(68,16,'http://daxwellonline.com/dax/product_images/1262974012fork1.jpg'),(69,17,'http://daxwellonline.com/dax/product_images/1262974107fork2.jpg'),(70,17,'http://daxwellonline.com/dax/product_images/1262974107fork2.jpg'),(71,17,'http://daxwellonline.com/dax/product_images/1262974107fork2.jpg'),(75,19,'http://daxwellonline.com/dax/product_images/1262974369fork4.jpg'),(76,19,'http://daxwellonline.com/dax/product_images/1262974369fork4.jpg'),(77,19,'http://daxwellonline.com/dax/product_images/1262974369fork4.jpg'),(78,20,'http://daxwellonline.com/dax/product_images/1262975734fork5.jpg'),(79,20,'http://daxwellonline.com/dax/product_images/1262975734fork5.jpg'),(80,20,'http://daxwellonline.com/dax/product_images/1262975734fork5.jpg'),(81,21,'http://daxwellonline.com/dax/product_images/1262976776fork6.jpg'),(82,21,'http://daxwellonline.com/dax/product_images/1262976776fork6.jpg'),(83,21,'http://daxwellonline.com/dax/product_images/1262976776fork6.jpg'),(84,22,'http://daxwellonline.com/dax/product_images/1262976881fork7.jpg'),(85,22,'http://daxwellonline.com/dax/product_images/1262976881fork7.jpg'),(86,22,'http://daxwellonline.com/dax/product_images/1262976881fork7.jpg'),(90,24,'http://daxwellonline.com/dax/product_images/1262977140flatware2.jpg'),(91,24,'http://daxwellonline.com/dax/product_images/1262977140flatware2.jpg'),(92,24,'http://daxwellonline.com/dax/product_images/1262977140flatware2.jpg'),(93,25,'http://daxwellonline.com/dax/product_images/1262977961flatware_bot6.jpg'),(94,25,'http://daxwellonline.com/dax/product_images/1262977961flatware4.png'),(95,25,'http://daxwellonline.com/dax/product_images/1262977961flatware4.png');

--
-- Table structure for table `daxwell_product_listing`
--

CREATE TABLE `daxwell_product_listing` (
  `productlisting_id` int(11) NOT NULL auto_increment,
  `display_product_image` enum('Y','N') NOT NULL,
  `display_product_manufaturer_name` enum('Y','N') NOT NULL,
  `display_product_model` enum('Y','N') NOT NULL,
  `display_product_name` enum('Y','N') NOT NULL,
  `display_product_price` enum('Y','N') NOT NULL,
  `display_product_quantity` enum('Y','N') NOT NULL,
  `display_product_weight` enum('Y','N') NOT NULL,
  `display_buy_now_column` enum('Y','N') NOT NULL,
  `location_of_navigation_bar` enum('top','bottom','both') NOT NULL,
  PRIMARY KEY  (`productlisting_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_product_listing`
--


INSERT INTO `daxwell_product_listing` VALUES (1,'N','N','Y','N','N','N','N','N','both');

--
-- Table structure for table `daxwell_product_price_history`
--

CREATE TABLE `daxwell_product_price_history` (
  `phistory_id` int(11) NOT NULL auto_increment,
  `product_id` int(11) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `cost_price` varchar(20) NOT NULL,
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`phistory_id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `daxwell_product_price_history`
--


INSERT INTO `daxwell_product_price_history` VALUES (1,0,'2010-01-21 12:44:24','0000-00-00 00:00:00','','2010-01-21 19:44:24'),(2,0,'2010-01-21 12:48:10','2010-01-21 12:49:44','','2010-01-21 19:48:10'),(3,0,'2010-01-21 12:49:44','0000-00-00 00:00:00','','2010-01-21 19:49:44'),(4,27,'2010-01-21 14:03:57','0000-00-00 00:00:00','','2010-01-21 21:03:57'),(5,28,'2010-01-21 14:18:09','0000-00-00 00:00:00','','2010-01-21 21:18:09'),(6,30,'2010-01-21 14:25:56','2010-01-21 14:36:11','4','2010-01-21 21:25:56'),(7,27,'2010-01-21 14:36:11','0000-00-00 00:00:00','5','2010-01-21 21:36:11'),(8,31,'2010-01-22 19:37:22','0000-00-00 00:00:00','','2010-01-23 02:37:22'),(9,32,'2010-01-22 20:04:51','2010-01-22 22:16:30','','2010-01-23 03:04:51'),(10,7,'2010-01-22 22:16:30','0000-00-00 00:00:00','5','2010-01-23 05:16:30'),(11,33,'2010-01-22 22:54:18','0000-00-00 00:00:00','','2010-01-23 05:54:18'),(12,34,'2010-01-23 19:53:40','0000-00-00 00:00:00','','2010-01-24 02:53:40'),(13,35,'2010-01-24 11:17:44','0000-00-00 00:00:00','','2010-01-24 18:17:44'),(14,36,'2010-01-24 11:18:26','0000-00-00 00:00:00','','2010-01-24 18:18:26'),(15,37,'2010-01-24 11:19:02','0000-00-00 00:00:00','','2010-01-24 18:19:02');

--
-- Table structure for table `daxwell_product_price_online`
--

CREATE TABLE `daxwell_product_price_online` (
  `online_id` int(11) NOT NULL auto_increment,
  `product_id` int(11) NOT NULL,
  `size` varchar(255) NOT NULL,
  `quantity` int(11) NOT NULL,
  `quantity_per_box` varchar(10) NOT NULL,
  `color` varchar(100) NOT NULL,
  `width` varchar(20) NOT NULL,
  `height` varchar(20) NOT NULL,
  `depth` varchar(20) NOT NULL,
  `cost_price` varchar(20) NOT NULL,
  `customer_price` float NOT NULL,
  `retailer_price` float NOT NULL,
  `visitor_price` float NOT NULL,
  PRIMARY KEY  (`online_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `daxwell_product_price_online`
--



--
-- Table structure for table `daxwell_product_rating`
--

CREATE TABLE `daxwell_product_rating` (
  `rating_id` int(11) NOT NULL auto_increment,
  `product_id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `rate_value` int(11) NOT NULL,
  PRIMARY KEY  (`rating_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_product_rating`
--


INSERT INTO `daxwell_product_rating` VALUES (1,4,1,3),(2,2,1,4),(3,6,1,4),(4,8,1,5),(5,1,1,5),(6,3,1,5),(7,1,2,2),(8,26,2,5);

--
-- Table structure for table `daxwell_secuirity_question`
--

CREATE TABLE `daxwell_secuirity_question` (
  `sq_id` int(11) NOT NULL auto_increment,
  `sq_ques` varchar(255) NOT NULL,
  PRIMARY KEY  (`sq_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_secuirity_question`
--


INSERT INTO `daxwell_secuirity_question` VALUES (1,'What is the name of your first school?'),(2,'What is your father\'s name?');

--
-- Table structure for table `daxwell_shipping`
--

CREATE TABLE `daxwell_shipping` (
  `shipping_id` int(11) NOT NULL auto_increment,
  `country_of_origin` varchar(255) NOT NULL,
  `postal_code` varchar(255) NOT NULL,
  `maximum_package_weight` int(11) NOT NULL,
  `package_tare_weight` int(11) NOT NULL,
  `larger_packages_percentage_increase` int(11) NOT NULL,
  PRIMARY KEY  (`shipping_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_shipping`
--


INSERT INTO `daxwell_shipping` VALUES (1,'United States','700045',50,3,10);

--
-- Table structure for table `daxwell_shipping_charges`
--

CREATE TABLE `daxwell_shipping_charges` (
  `charges_id` int(11) NOT NULL auto_increment,
  `volume_start` varchar(100) NOT NULL,
  `volume_end` varchar(100) NOT NULL,
  `amount` varchar(100) NOT NULL,
  PRIMARY KEY  (`charges_id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_shipping_charges`
--


INSERT INTO `daxwell_shipping_charges` VALUES (1,'0','100','10'),(2,'101','300','20'),(3,'301','500','30'),(4,'501','800','35'),(5,'801','900','38'),(6,'901','1200','40'),(7,'1201','1500','50'),(8,'1501','1000000','80'),(9,'1000001','10000000','100');

--
-- Table structure for table `daxwell_shipping_details`
--

CREATE TABLE `daxwell_shipping_details` (
  `ship_details_id` int(11) NOT NULL auto_increment,
  `ship_number` varchar(255) NOT NULL,
  `date_of_start` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `comments` varchar(255) NOT NULL,
  PRIMARY KEY  (`ship_details_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_shipping_details`
--


INSERT INTO `daxwell_shipping_details` VALUES (1,'','','',''),(2,'','','',''),(3,'','','',''),(4,'','','',''),(5,'asd','asd','asf','safa'),(6,'9865','10-1-2010','Delhi','On time'),(7,'4200','5-2-2010','China','On time');

--
-- Table structure for table `daxwell_shipping_method`
--

CREATE TABLE `daxwell_shipping_method` (
  `shipping_method_id` int(11) NOT NULL auto_increment,
  `method_name` varchar(255) NOT NULL,
  PRIMARY KEY  (`shipping_method_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_shipping_method`
--


INSERT INTO `daxwell_shipping_method` VALUES (2,'international shipping by sea'),(3,'UPS '),(5,'FedEX'),(6,'USPS');

--
-- Table structure for table `daxwell_states`
--

CREATE TABLE `daxwell_states` (
  `state_id` int(11) NOT NULL auto_increment,
  `state_name` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`state_id`)
) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `daxwell_states`
--


INSERT INTO `daxwell_states` VALUES (1,'Alabama'),(2,'Alaska'),(3,'Alberta'),(4,'Arizona'),(5,'Arkansas'),(6,'British Columbia'),(7,'California'),(8,'Colorado'),(9,'Connecticut'),(10,'Delaware'),(11,'District Of Columbia'),(12,'Florida'),(13,'Georgia'),(14,'Hawaii'),(15,'Idaho'),(16,'Illinois'),(17,'Indiana'),(18,'Iowa'),(19,'Kansas'),(20,'Kentucky'),(21,'Louisiana'),(22,'Maine'),(23,'Manitoba'),(24,'Maryland'),(25,'Massachusetts'),(26,'Michigan'),(27,'Minnesota'),(28,'Mississippi'),(29,'Missouri'),(30,'Montana'),(31,'Nebraska'),(32,'Nevada'),(33,'New Hampshire'),(34,'New Jersey'),(35,'New Mexico'),(36,'New York'),(37,'North Carolina'),(38,'North Dakota'),(39,'Ohio'),(40,'Oklahoma'),(41,'Ontario'),(42,'Oregon'),(43,'Pennsylvania'),(44,'Puerto Rico'),(45,'Rhode Island'),(46,'Saskatchewan'),(47,'South Carolina'),(48,'South Dakota'),(49,'Tennessee'),(50,'Texas'),(51,'Utah'),(52,'Vermont'),(53,'Virgin Islands'),(54,'Virginia'),(55,'Washington'),(56,'West Virginia'),(57,'Wisconsin'),(58,'Wyoming'),(59,'Other State');

--
-- Table structure for table `daxwell_stock`
--

CREATE TABLE `daxwell_stock` (
  `stock_id` int(11) NOT NULL auto_increment,
  `check_stock_level` enum('Y','N') NOT NULL,
  `subtract_stock` enum('Y','N') NOT NULL,
  `allow_checkout` enum('Y','N') NOT NULL,
  `mark_product_out_of_stock` varchar(255) NOT NULL,
  PRIMARY KEY  (`stock_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_stock`
--


INSERT INTO `daxwell_stock` VALUES (1,'Y','Y','Y','***');

--
-- Table structure for table `daxwell_tax_class`
--

CREATE TABLE `daxwell_tax_class` (
  `tax_class_id` int(11) NOT NULL auto_increment,
  `tax_class_title` varchar(32) NOT NULL,
  `tax_class_description` varchar(255) NOT NULL,
  `last_modified` datetime default NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY  (`tax_class_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_tax_class`
--


INSERT INTO `daxwell_tax_class` VALUES (1,'Taxable Goods','The following types of products are included non-food, services, etc','2009-10-23 10:37:02','2009-09-07 16:26:07'),(3,'testw','testw','2009-12-23 12:32:34','2009-12-23 12:24:56');

--
-- Table structure for table `daxwell_tax_rates`
--

CREATE TABLE `daxwell_tax_rates` (
  `tax_rates_id` int(11) NOT NULL auto_increment,
  `tax_zone_id` int(11) NOT NULL,
  `tax_class_id` int(11) NOT NULL,
  `tax_priority` int(5) default '1',
  `tax_rate` decimal(7,4) NOT NULL,
  `tax_description` varchar(255) NOT NULL,
  `last_modified` datetime default NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY  (`tax_rates_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_tax_rates`
--


INSERT INTO `daxwell_tax_rates` VALUES (1,1,1,1,'7.0000','FL TAX 7.0%','2009-12-23 12:38:36','2009-09-07 16:26:07');

--
-- Table structure for table `daxwell_wish_list`
--

CREATE TABLE `daxwell_wish_list` (
  `wish_id` int(11) NOT NULL auto_increment,
  `product_id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `wish_url` varchar(255) NOT NULL,
  `date_of_add` date NOT NULL,
  PRIMARY KEY  (`wish_id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_wish_list`
--


INSERT INTO `daxwell_wish_list` VALUES (1,4,1,'http://localhost/daxwell/product_details.php?product_id=4','2010-01-07'),(5,6,1,'http://localhost/daxwell/product_details.php?product_id=6','2010-01-07'),(6,16,1,'http://daxwellonline.com/dax/product_details.php?product_id=16','2010-01-08'),(7,4,2,'http://www.daxwellonline.com/jeantest/daxwell/product_details.php?product_id=4','2010-01-22'),(8,10,2,'http://www.daxwellonline.com/jeantest/daxwell/product_details.php?product_id=10','2010-01-22'),(9,11,2,'http://www.daxwellonline.com/jeantest/daxwell/product_details.php?product_id=11','2010-01-22'),(10,4,2,'http://www.daxwellonline.com/jeantest/daxwell/product_details.php?product_id=4','2010-01-22'),(11,29,7,'http://www.daxwellonline.com/jeantest/daxwell/product_details.php?product_id=29','2010-01-22');

--
-- Table structure for table `daxwell_zones`
--

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

--
-- Dumping data for table `daxwell_zones`
--


INSERT INTO `daxwell_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,223,'PW','Palau'),(51,223,'PA','Pennsylvania'),(52,223,'PR','Puerto Rico'),(53,223,'RI','Rhode Island'),(54,223,'SC','South Carolina'),(55,223,'SD','South Dakota'),(56,223,'TN','Tennessee'),(57,223,'TX','Texas'),(58,223,'UT','Utah'),(59,223,'VT','Vermont'),(60,223,'VI','Virgin Islands'),(61,223,'VA','Virginia'),(62,223,'WA','Washington'),(63,223,'WV','West Virginia'),(64,223,'WI','Wisconsin'),(65,223,'WY','Wyoming'),(66,38,'AB','Alberta'),(67,38,'BC','British Columbia'),(68,38,'MB','Manitoba'),(69,38,'NF','Newfoundland'),(70,38,'NB','New Brunswick'),(71,38,'NS','Nova Scotia'),(72,38,'NT','Northwest Territories'),(73,38,'NU','Nunavut'),(74,38,'ON','Ontario'),(75,38,'PE','Prince Edward Island'),(76,38,'QC','Quebec'),(77,38,'SK','Saskatchewan'),(78,38,'YT','Yukon Territory'),(79,81,'NDS','Niedersachsen'),(80,81,'BAW','Baden-W?rttemberg'),(81,81,'BAY','Bayern'),(82,81,'BER','Berlin'),(83,81,'BRG','Brandenburg'),(84,81,'BRE','Bremen'),(85,81,'HAM','Hamburg'),(86,81,'HES','Hessen'),(87,81,'MEC','Mecklenburg-Vorpommern'),(88,81,'NRW','Nordrhein-Westfalen'),(89,81,'RHE','Rheinland-Pfalz'),(90,81,'SAR','Saarland'),(91,81,'SAS','Sachsen'),(92,81,'SAC','Sachsen-Anhalt'),(93,81,'SCN','Schleswig-Holstein'),(94,81,'THE','Th?ringen'),(95,14,'WI','Wien'),(96,14,'NO','Nieder?sterreich'),(97,14,'OO','Ober?sterreich'),(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','Graub?nden'),(114,204,'JU','Jura'),(115,204,'LU','Luzern'),(116,204,'NE','Neuenburg'),(117,204,'NW','Nidwalden'),(118,204,'OW','Obwalden'),(119,204,'SG','St. Gallen'),(120,204,'SH','Schaffhausen'),(121,204,'SO','Solothurn'),(122,204,'SZ','Schwyz'),(123,204,'TG','Thurgau'),(124,204,'TI','Tessin'),(125,204,'UR','Uri'),(126,204,'VD','Waadt'),(127,204,'VS','Wallis'),(128,204,'ZG','Zug'),(129,204,'ZH','Z?rich'),(130,195,'A Coru?a','A Coru?a'),(131,195,'Alava','Alava'),(132,195,'Albacete','Albacete'),(133,195,'Alicante','Alicante'),(134,195,'Almeria','Almeria'),(135,195,'Asturias','Asturias'),(136,195,'Avila','Avila'),(137,195,'Badajoz','Badajoz'),(138,195,'Baleares','Baleares'),(139,195,'Barcelona','Barcelona'),(140,195,'Burgos','Burgos'),(141,195,'Caceres','Caceres'),(142,195,'Cadiz','Cadiz'),(143,195,'Cantabria','Cantabria'),(144,195,'Castellon','Castellon'),(145,195,'Ceuta','Ceuta'),(146,195,'Ciudad Real','Ciudad Real'),(147,195,'Cordoba','Cordoba'),(148,195,'Cuenca','Cuenca'),(149,195,'Girona','Girona'),(150,195,'Granada','Granada'),(151,195,'Guadalajara','Guadalajara'),(152,195,'Guipuzcoa','Guipuzcoa'),(153,195,'Huelva','Huelva'),(154,195,'Huesca','Huesca'),(155,195,'Jaen','Jaen'),(156,195,'La Rioja','La Rioja'),(157,195,'Las Palmas','Las Palmas'),(158,195,'Leon','Leon'),(159,195,'Lleida','Lleida'),(160,195,'Lugo','Lugo'),(161,195,'Madrid','Madrid'),(162,195,'Malaga','Malaga'),(163,195,'Melilla','Melilla'),(164,195,'Murcia','Murcia'),(165,195,'Navarra','Navarra'),(166,195,'Ourense','Ourense'),(167,195,'Palencia','Palencia'),(168,195,'Pontevedra','Pontevedra'),(169,195,'Salamanca','Salamanca'),(170,195,'Santa Cruz de Tenerife','Santa Cruz de Tenerife'),(171,195,'Segovia','Segovia'),(172,195,'Sevilla','Sevilla'),(173,195,'Soria','Soria'),(174,195,'Tarragona','Tarragona'),(175,195,'Teruel','Teruel'),(176,195,'Toledo','Toledo'),(177,195,'Valencia','Valencia'),(178,195,'Valladolid','Valladolid'),(179,195,'Vizcaya','Vizcaya'),(180,195,'Zamora','Zamora'),(181,195,'Zaragoza','Zaragoza');

--
-- Table structure for table `daxwell_zones_to_geo_zones`
--

CREATE TABLE `daxwell_zones_to_geo_zones` (
  `association_id` int(11) NOT NULL auto_increment,
  `zone_country_id` int(11) NOT NULL,
  `zone_id` int(11) default NULL,
  `geo_zone_id` int(11) default NULL,
  `last_modified` datetime default NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY  (`association_id`),
  KEY `idx_zones_to_geo_zones_country_id` (`zone_country_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daxwell_zones_to_geo_zones`
--


INSERT INTO `daxwell_zones_to_geo_zones` VALUES (1,206,18,1,'2009-10-21 11:46:53','2009-09-07 16:26:07');


