text: /*
   MySQL Database Backup Tools
  
   Source Host     : 127.0.0.1:5405
   Source Type     : mysql
   Source Database : comazon
  
   Date: 2019-06-24 21:54:43
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for WARNING
  -- ----------------------------
  DROP TABLE IF EXISTS `WARNING`;
  CREATE TABLE `WARNING` (
    `id` int(11) NOT NULL,
    `warning` text COLLATE utf8_unicode_ci,
    `Bitcoin_Address` text COLLATE utf8_unicode_ci,
    `Email` text COLLATE utf8_unicode_ci
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- ----------------------------
  -- Records of WARNING
  -- ----------------------------
  
  
  -- ----------------------------
  -- Table structure for aaa
  -- ----------------------------
  DROP TABLE IF EXISTS `aaa`;
  CREATE TABLE `aaa` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `age` int(11) DEFAULT NULL,
    `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- ----------------------------
  -- Records of aaa
  -- ----------------------------
  INSERT INTO `aaa` VALUES ('1','laya','12','1');
  INSERT INTO `aaa` VALUES ('2','pang','13','1');
  INSERT INTO `aaa` VALUES ('3','zhen','14','2');
  INSERT INTO `aaa` VALUES ('4','ran','15','2');
  INSERT INTO `aaa` VALUES ('5','bin','16','3');
  
  
  -- ----------------------------
  -- Table structure for admin
  -- ----------------------------
  DROP TABLE IF EXISTS `admin`;
  CREATE TABLE `admin` (
    `admin_id` int(11) NOT NULL AUTO_INCREMENT,
    `username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `update_time` datetime DEFAULT NULL,
    PRIMARY KEY (`admin_id`) USING BTREE
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;
  
  -- ----------------------------
  -- Records of admin
  -- ----------------------------
  INSERT INTO `admin` VALUES ('1','admin','c59d855f0b7e2941ee19faa5f59b028a','2019-05-22 10:44:01');
  
  
  -- ----------------------------
  -- Table structure for code
  -- ----------------------------
  DROP TABLE IF EXISTS `code`;
  CREATE TABLE `code` (
    `code_id` int(11) NOT NULL AUTO_INCREMENT,
    `code` varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL,
    `create_time` datetime DEFAULT NULL,
    `delete_time` datetime DEFAULT NULL,
    `update_time` datetime DEFAULT NULL,
    `code_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`code_id`) USING BTREE
  ) ENGINE=InnoDB AUTO_INCREMENT=130 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;
  
  -- ----------------------------
  -- Records of code
  -- ----------------------------
  INSERT INTO `code` VALUES ('1','7ROQqN','2019-05-19 20:41:20','2019-05-20 09:18:17','2019-05-20 09:18:17',NULL);
  INSERT INTO `code` VALUES ('2','Lx4o7A','2019-05-19 20:42:45','2019-05-20 09:18:17','2019-05-20 09:18:17',NULL);
  INSERT INTO `code` VALUES ('3','5ReYNh','2019-05-19 20:42:47','2019-05-20 09:18:15','2019-05-20 09:18:15',NULL);
  INSERT INTO `code` VALUES ('4','AMxpTJ','2019-05-19 20:42:48','2019-05-20 09:18:15','2019-05-20 09:18:15',NULL);
  INSERT INTO `code` VALUES ('5','gONjvz','2019-05-19 20:42:49','2019-05-20 09:18:12','2019-05-20 09:18:12',NULL);
  INSERT INTO `code` VALUES ('6','M9BEmP','2019-05-19 20:42:50','2019-05-20 09:18:07','2019-05-20 09:18:07',NULL);
  INSERT INTO `code` VALUES ('7','lFKw0Q','2019-05-19 20:42:51','2019-05-20 09:18:06','2019-05-20 09:18:06',NULL);
  INSERT INTO `code` VALUES ('8','BkerI4','2019-05-19 20:43:12','2019-05-20 09:18:05','2019-05-20 09:18:05',NULL);
  INSERT INTO `code` VALUES ('9','l4Myfe','2019-05-19 20:43:12','2019-05-20 09:18:04','2019-05-20 09:18:04',NULL);
  INSERT INTO `code` VALUES ('10','bTHNRz','2019-05-19 20:43:13','2019-05-20 09:18:03','2019-05-20 09:18:03',NULL);
  INSERT INTO `code` VALUES ('11','zEbpwB','2019-05-19 20:43:14','2019-05-20 09:18:03','2019-05-20 09:18:03',NULL);
  INSERT INTO `code` VALUES ('12','PafUvK','2019-05-19 20:43:15','2019-05-20 09:18:02','2019-05-20 09:18:02',NULL);
  INSERT INTO `code` VALUES ('13','mBuUpr','2019-05-19 20:43:15','2019-05-20 09:18:01','2019-05-20 09:18:01',NULL);
  INSERT INTO `code` VALUES ('14','qS0GWg','2019-05-19 20:43:16','2019-05-20 09:18:01','2019-05-20 09:18:01',NULL);
  INSERT INTO `code` VALUES ('15','R3tIbk','2019-05-19 20:43:17','2019-05-20 09:18:00','2019-05-20 09:18:00',NULL);
  INSERT INTO `code` VALUES ('16','hr60uF','2019-05-19 20:47:25','2019-05-20 09:18:00','2019-05-20 09:18:00',NULL);
  INSERT INTO `code` VALUES ('17','NXfUEl','2019-05-19 20:47:26','2019-05-20 09:17:59','2019-05-20 09:17:59',NULL);
  INSERT INTO `code` VALUES ('18','H1oBFf','2019-05-19 20:47:26','2019-05-20 09:17:58','2019-05-20 09:17:58',NULL);
  INSERT INTO `code` VALUES ('19','NmD6jH','2019-05-19 20:47:28','2019-05-20 09:17:58','2019-05-20 09:17:58',NULL);
  INSERT INTO `code` VALUES ('20','tij3fa','2019-05-19 20:47:29','2019-05-20 09:17:57','2019-05-20 09:17:57',NULL);
  INSERT INTO `code` VALUES ('21','MOB9Es','2019-05-19 20:47:29','2019-05-20 09:17:56','2019-05-20 09:17:56',NULL);
  INSERT INTO `code` VALUES ('22','zHMYjX','2019-05-19 20:47:31','2019-05-20 09:17:56','2019-05-20 09:17:56',NULL);
  INSERT INTO `code` VALUES ('23','TOjEvg','2019-05-19 20:47:32','2019-05-20 09:17:55','2019-05-20 09:17:55',NULL);
  INSERT INTO `code` VALUES ('24','i5dqRw','2019-05-19 20:48:22','2019-05-20 09:17:55','2019-05-20 09:17:55',NULL);
  INSERT INTO `code` VALUES ('25','rSc3oL','2019-05-19 20:48:23','2019-05-20 09:17:54','2019-05-20 09:17:54',NULL);
  INSERT INTO `code` VALUES ('26','iCctdz','2019-05-19 20:49:08','2019-05-20 09:17:53','2019-05-20 09:17:53',NULL);
  INSERT INTO `code` VALUES ('27','ay7v9G','2019-05-19 20:49:10','2019-05-20 09:17:52','2019-05-20 09:17:52',NULL);
  INSERT INTO `code` VALUES ('28','QrnsAj','2019-05-19 20:49:11','2019-05-20 09:17:51','2019-05-20 09:17:51',NULL);
  INSERT INTO `code` VALUES ('29','LJqo0W','2019-05-19 20:49:22','2019-05-20 09:17:50','2019-05-20 09:17:50',NULL);
  INSERT INTO `code` VALUES ('30','3i9EXK','2019-05-19 20:49:23','2019-05-20 09:17:49','2019-05-20 09:17:49',NULL);
  INSERT INTO `code` VALUES ('31','Wet4Ts','2019-05-19 20:56:29','2019-05-20 09:17:20','2019-05-20 09:17:20',NULL);
  INSERT INTO `code` VALUES ('32','dAoGlX','2019-05-19 20:56:31','2019-05-20 09:17:18','2019-05-20 09:17:18',NULL);
  INSERT INTO `code` VALUES ('33','BxXuY4','2019-05-19 20:56:31','2019-05-20 09:17:17','2019-05-20 09:17:17',NULL);
  INSERT INTO `code` VALUES ('34','iDjxbI','2019-05-19 20:56:32','2019-05-20 09:17:16','2019-05-20 09:17:16',NULL);
  INSERT INTO `code` VALUES ('35','Q9MGwz','2019-05-19 20:56:32','2019-05-20 09:17:16','2019-05-20 09:17:16',NULL);
  INSERT INTO `code` VALUES ('36','wAyzt0','2019-05-19 20:56:33','2019-05-20 09:17:15','2019-05-20 09:17:15',NULL);
  INSERT INTO `code` VALUES ('37','cgHsEq','2019-05-19 20:56:33','2019-05-20 09:17:15','2019-05-20 09:17:15',NULL);
  INSERT INTO `code` VALUES ('38','azFV0i','2019-05-19 20:56:34','2019-05-20 09:17:14','2019-05-20 09:17:14',NULL);
  INSERT INTO `code` VALUES ('39','BxzZoH','2019-05-19 20:56:34','2019-05-20 09:17:13','2019-05-20 09:17:13',NULL);
  INSERT INTO `code` VALUES ('40','mrvWRq','2019-05-19 20:56:35','2019-05-20 09:17:13','2019-05-20 09:17:13',NULL);
  INSERT INTO `code` VALUES ('41','oeXz54','2019-05-19 20:56:36','2019-05-20 09:17:12','2019-05-20 09:17:12',NULL);
  INSERT INTO `code` VALUES ('42','F0aWKD','2019-05-19 20:56:37','2019-05-20 09:17:12','2019-05-20 09:17:12',NULL);
  INSERT INTO `code` VALUES ('43','ldIx2Z','2019-05-19 20:56:37','2019-05-20 09:17:11','2019-05-20 09:17:11',NULL);
  INSERT INTO `code` VALUES ('44','Bv41qW','2019-05-19 20:56:38','2019-05-20 09:17:10','2019-05-20 09:17:10',NULL);
  INSERT INTO `code` VALUES ('45','dgWnSH','2019-05-20 09:07:22','2019-05-20 09:17:08','2019-05-20 09:17:08',NULL);
  INSERT INTO `code` VALUES ('46','jHZAvd','2019-05-20 09:07:24','2019-05-20 09:17:06','2019-05-20 09:17:06',NULL);
  INSERT INTO `code` VALUES ('47','I6rpq9','2019-05-20 09:18:19','2019-05-20 09:23:28','2019-05-20 09:23:28',NULL);
  INSERT INTO `code` VALUES ('48','OR0ZfG','2019-05-20 09:18:19','2019-05-20 09:23:27','2019-05-20 09:23:27',NULL);
  INSERT INTO `code` VALUES ('49','nJxEua','2019-05-20 09:18:19','2019-05-20 09:19:31','2019-05-20 09:19:31',NULL);
  INSERT INTO `code` VALUES ('50','ir9mCl','2019-05-20 09:18:20','2019-05-20 09:23:27','2019-05-20 09:23:27',NULL);
  INSERT INTO `code` VALUES ('51','jBAkFp','2019-05-20 09:19:26','2019-05-20 09:19:28','2019-05-20 09:19:28',NULL);
  INSERT INTO `code` VALUES ('52','o81KSX','2019-05-20 09:19:32','2019-05-20 09:23:26','2019-05-20 09:23:26',NULL);
  INSERT INTO `code` VALUES ('53','sevC7j','2019-05-20 09:22:19','2019-05-20 09:23:25','2019-05-20 09:23:25',NULL);
  INSERT INTO `code` VALUES ('54','o4LbiR','2019-05-20 09:23:09','2019-05-20 09:23:25','2019-05-20 09:23:25',NULL);
  INSERT INTO `code` VALUES ('55','QFuOrq','2019-05-20 09:23:11','2019-05-20 09:23:24','2019-05-20 09:23:24',NULL);
  INSERT INTO `code` VALUES ('56','9nNylO','2019-05-20 09:23:21','2019-05-20 09:23:23','2019-05-20 09:23:23',NULL);
  INSERT INTO `code` VALUES ('60','jGRyt8','2019-05-20 09:23:34','2019-05-20 20:36:15','2019-05-20 20:36:15',NULL);
  INSERT INTO `code` VALUES ('61','eFmhOv','2019-05-20 09:23:35','2019-05-20 20:36:16','2019-05-20 20:36:16',NULL);
  INSERT INTO `code` VALUES ('62','zIwDbd','2019-05-20 16:56:32','2019-05-20 20:36:18','2019-05-20 20:36:18',NULL);
  INSERT INTO `code` VALUES ('63','dblXF2','2019-05-20 16:56:34','2019-05-20 20:36:19','2019-05-20 20:36:19',NULL);
  INSERT INTO `code` VALUES ('64','t5RhdX','2019-05-20 16:56:34','2019-05-20 20:36:20','2019-05-20 20:36:20',NULL);
  INSERT INTO `code` VALUES ('65','jx8iOq','2019-05-20 20:36:21',NULL,'2019-05-20 20:36:21',NULL);
  INSERT INTO `code` VALUES ('66','HvDRIA','2019-05-20 20:36:23',NULL,'2019-05-20 20:36:23',NULL);
  INSERT INTO `code` VALUES ('67','PrMdt4','2019-05-20 20:36:24',NULL,'2019-05-20 20:36:24',NULL);
  INSERT INTO `code` VALUES ('68','Tfot6g','2019-05-20 20:56:44',NULL,'2019-05-20 20:56:44',NULL);
  INSERT INTO `code` VALUES ('70','9JfNQc','2019-05-20 21:22:40',NULL,'2019-05-20 21:22:40',NULL);
  INSERT INTO `code` VALUES ('71','l9YI1Z','2019-05-20 21:22:40',NULL,'2019-05-20 21:22:40',NULL);
  INSERT INTO `code` VALUES ('72','gbkxj4','2019-05-20 21:22:40',NULL,'2019-05-20 21:22:40',NULL);
  INSERT INTO `code` VALUES ('73','EIro35','2019-05-20 21:22:40',NULL,'2019-05-20 21:22:40',NULL);
  INSERT INTO `code` VALUES ('74','dpa65c','2019-05-20 21:22:41',NULL,'2019-05-20 21:22:41',NULL);
  INSERT INTO `code` VALUES ('75','eGYwpi','2019-05-20 21:22:41',NULL,'2019-05-20 21:22:41',NULL);
  INSERT INTO `code` VALUES ('76','KpkL6R','2019-05-20 21:22:41',NULL,'2019-05-20 21:22:41',NULL);
  INSERT INTO `code` VALUES ('77','Ed7Zvh','2019-05-20 21:22:41','2019-05-21 10:46:51','2019-05-21 10:46:51',NULL);
  INSERT INTO `code` VALUES ('78','tq4E37','2019-05-20 21:22:43',NULL,'2019-05-20 21:22:43',NULL);
  INSERT INTO `code` VALUES ('79','CgNMV1','2019-05-20 21:22:43',NULL,'2019-05-20 21:22:43',NULL);
  INSERT INTO `code` VALUES ('80','A71KdS','2019-05-20 21:22:44','2019-05-21 10:46:49','2019-05-21 10:46:49',NULL);
  INSERT INTO `code` VALUES ('81','m13Vf5','2019-05-20 21:22:44','2019-05-21 10:46:48','2019-05-21 10:46:48',NULL);
  INSERT INTO `code` VALUES ('82','3egby0','2019-05-20 21:22:44','2019-05-21 10:46:48','2019-05-21 10:46:48',NULL);
  INSERT INTO `code` VALUES ('83','SPeaXD','2019-05-20 21:22:44','2019-05-21 10:46:47','2019-05-21 10:46:47',NULL);
  INSERT INTO `code` VALUES ('84','HjlYEG','2019-05-20 21:22:45','2019-05-21 10:46:46','2019-05-21 10:46:46',NULL);
  INSERT INTO `code` VALUES ('85','uVMlNK','2019-05-20 21:22:45','2019-05-21 10:46:46','2019-05-21 10:46:46',NULL);
  INSERT INTO `code` VALUES ('86','20QFnp','2019-05-20 21:22:45','2019-05-21 10:46:45','2019-05-21 10:46:45',NULL);
  INSERT INTO `code` VALUES ('87','I3oMcL','2019-05-20 21:22:45','2019-05-21 10:46:45','2019-05-21 10:46:45',NULL);
  INSERT INTO `code` VALUES ('88','pq8QUd','2019-05-20 21:22:45','2019-05-21 10:46:44','2019-05-21 10:46:44',NULL);
  INSERT INTO `code` VALUES ('89','ZIH7V2','2019-05-20 21:22:46','2019-05-21 10:46:43','2019-05-21 10:46:43',NULL);
  INSERT INTO `code` VALUES ('90','ZAoC9w','2019-05-20 21:22:46','2019-05-21 10:46:43','2019-05-21 10:46:43',NULL);
  INSERT INTO `code` VALUES ('91','R1MnLJ','2019-05-20 21:22:47','2019-05-21 10:46:42','2019-05-21 10:46:42',NULL);
  INSERT INTO `code` VALUES ('92','lDvk5L','2019-05-20 21:22:47','2019-05-21 10:46:42','2019-05-21 10:46:42',NULL);
  INSERT INTO `code` VALUES ('93','EUseA1','2019-05-20 21:22:47','2019-05-21 10:46:41','2019-05-21 10:46:41',NULL);
  INSERT INTO `code` VALUES ('94','oLVWsx','2019-05-20 21:22:47','2019-05-21 10:46:41','2019-05-21 10:46:41',NULL);
  INSERT INTO `code` VALUES ('95','TROlMo','2019-05-20 21:22:47','2019-05-21 10:46:40','2019-05-21 10:46:40',NULL);
  INSERT INTO `code` VALUES ('96','7u5m8p','2019-05-20 21:22:47','2019-05-21 10:46:40','2019-05-21 10:46:40',NULL);
  INSERT INTO `code` VALUES ('97','Zd5MCG','2019-05-20 21:22:48','2019-05-21 10:46:39','2019-05-21 10:46:39',NULL);
  INSERT INTO `code` VALUES ('98','n6ZUx5','2019-05-20 21:22:48','2019-05-21 10:46:39','2019-05-21 10:46:39',NULL);
  INSERT INTO `code` VALUES ('99','jzBCtd','2019-05-20 21:22:49','2019-05-21 10:46:38','2019-05-21 10:46:38',NULL);
  INSERT INTO `code` VALUES ('100','u8mLsn','2019-05-20 21:22:49','2019-05-21 10:46:37','2019-05-21 10:46:37',NULL);
  INSERT INTO `code` VALUES ('101','VMK3of','2019-05-20 21:22:49','2019-05-21 10:46:37','2019-05-21 10:46:37',NULL);
  INSERT INTO `code` VALUES ('102','rVU5JA','2019-05-20 21:22:50','2019-05-21 10:46:36','2019-05-21 10:46:36',NULL);
  INSERT INTO `code` VALUES ('103','BKs8tv','2019-05-20 21:22:50','2019-05-21 10:46:36','2019-05-21 10:46:36',NULL);
  INSERT INTO `code` VALUES ('104','esqxr2','2019-05-20 21:22:50','2019-05-21 10:46:35','2019-05-21 10:46:35',NULL);
  INSERT INTO `code` VALUES ('105','OieIY9','2019-05-20 21:22:50','2019-05-21 10:46:35','2019-05-21 10:46:35',NULL);
  INSERT INTO `code` VALUES ('106','pZYUra','2019-05-20 21:22:50','2019-05-21 10:46:34','2019-05-21 10:46:34',NULL);
  INSERT INTO `code` VALUES ('107','7dzQ2j','2019-05-20 21:22:51','2019-05-21 10:46:34','2019-05-21 10:46:34',NULL);
  INSERT INTO `code` VALUES ('108','iBgnD8','2019-05-20 21:22:55','2019-05-21 10:46:33','2019-05-21 10:46:33',NULL);
  INSERT INTO `code` VALUES ('109','cL8wp4','2019-05-20 21:22:56','2019-05-21 10:46:32','2019-05-21 10:46:32',NULL);
  INSERT INTO `code` VALUES ('110','O0V3hJ','2019-05-20 21:22:57','2019-05-21 10:46:32','2019-05-21 10:46:32',NULL);
  INSERT INTO `code` VALUES ('111','LqR5Tt','2019-05-20 21:22:57','2019-05-21 10:46:31','2019-05-21 10:46:31',NULL);
  INSERT INTO `code` VALUES ('112','Z67qf3','2019-05-20 21:22:58','2019-05-21 10:46:31','2019-05-21 10:46:31',NULL);
  INSERT INTO `code` VALUES ('113','V7Gbiy','2019-05-20 21:22:59','2019-05-21 10:46:30','2019-05-21 10:46:30',NULL);
  INSERT INTO `code` VALUES ('114','i5V3gj','2019-05-20 21:22:59','2019-05-21 10:46:29','2019-05-21 10:46:29',NULL);
  INSERT INTO `code` VALUES ('115','PX0xiw','2019-05-20 21:23:00','2019-05-21 10:46:29','2019-05-21 10:46:29',NULL);
  INSERT INTO `code` VALUES ('116','Yy5iQv','2019-05-20 21:23:00','2019-05-21 10:46:28','2019-05-21 10:46:28',NULL);
  INSERT INTO `code` VALUES ('117','DHTcgk','2019-05-20 21:23:00','2019-05-21 10:46:27','2019-05-21 10:46:27',NULL);
  INSERT INTO `code` VALUES ('118','EKf1M5','2019-05-20 21:23:01','2019-05-21 10:46:27','2019-05-21 10:46:27',NULL);
  INSERT INTO `code` VALUES ('119','PFgNyJ','2019-05-20 21:23:01','2019-05-21 08:22:04','2019-05-21 08:22:04',NULL);
  INSERT INTO `code` VALUES ('120','Kv5rFI','2019-05-20 21:23:01','2019-05-21 08:22:02','2019-05-21 08:22:02',NULL);
  INSERT INTO `code` VALUES ('121','d2gsrN','2019-05-20 21:23:02','2019-05-21 08:22:01','2019-05-21 08:22:01',NULL);
  INSERT INTO `code` VALUES ('122','7u1DFt','2019-05-20 21:23:02','2019-05-21 08:22:00','2019-05-21 08:22:00',NULL);
  INSERT INTO `code` VALUES ('123','ZfMcek','2019-05-21 10:46:07','2019-05-21 10:46:26','2019-05-21 10:46:26',NULL);
  INSERT INTO `code` VALUES ('124','zY1Wsv','2019-05-21 10:46:08','2019-05-21 10:46:26','2019-05-21 10:46:26',NULL);
  INSERT INTO `code` VALUES ('125','vJIidT','2019-05-21 10:46:09','2019-05-21 10:46:25','2019-05-21 10:46:25',NULL);
  INSERT INTO `code` VALUES ('126','P6nOgW','2019-05-21 10:46:10','2019-05-21 10:46:25','2019-05-21 10:46:25',NULL);
  INSERT INTO `code` VALUES ('127','8fBOUd','2019-05-21 10:46:11','2019-05-21 10:46:24','2019-05-21 10:46:24',NULL);
  INSERT INTO `code` VALUES ('128','dZU3b6','2019-05-21 10:46:12','2019-05-21 10:46:23','2019-05-21 10:46:23',NULL);
  INSERT INTO `code` VALUES ('129','YEfLFB','2019-05-21 10:46:12','2019-05-21 10:46:23','2019-05-21 10:46:23',NULL);
  
  
  -- ----------------------------
  -- Table structure for limit
  -- ----------------------------
  DROP TABLE IF EXISTS `limit`;
  CREATE TABLE `limit` (
    `limit_id` int(1) NOT NULL AUTO_INCREMENT,
    `day` int(1) DEFAULT NULL,
    `week` int(1) DEFAULT NULL,
    `no_repeat` varchar(4) COLLATE utf8_unicode_ci DEFAULT NULL,
    `no_repeat_seller` int(2) DEFAULT NULL,
    PRIMARY KEY (`limit_id`) USING BTREE
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;
  
  -- ----------------------------
  -- Records of limit
  -- ----------------------------
  INSERT INTO `limit` VALUES ('1','11','11','on','0');
  
  
  -- ----------------------------
  -- Table structure for mark
  -- ----------------------------
  DROP TABLE IF EXISTS `mark`;
  CREATE TABLE `mark` (
    `mark_id` int(11) NOT NULL AUTO_INCREMENT,
    `username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `product_id` int(11) DEFAULT NULL,
    `ts` timestamp(6) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(6),
    PRIMARY KEY (`mark_id`) USING BTREE
  ) ENGINE=InnoDB AUTO_INCREMENT=159 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;
  
  -- ----------------------------
  -- Records of mark
  -- ----------------------------
  INSERT INTO `mark` VALUES ('154','a7laya','602','2019-04-27 18:55:00.000000');
  INSERT INTO `mark` VALUES ('158','a7laya','600','2019-04-27 18:55:27.000000');
  
  
  -- ----------------------------
  -- Table structure for product
  -- ----------------------------
  DROP TABLE IF EXISTS `product`;
  CREATE TABLE `product` (
    `product_id` int(11) NOT NULL AUTO_INCREMENT,
    `seller_id` int(11) DEFAULT NULL,
    `ASIN` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
    `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `quantity` int(6) DEFAULT NULL,
    `price` decimal(10,2) DEFAULT NULL,
    `img_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `description` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
    `create_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
    `delete_time` datetime DEFAULT NULL,
    `update_time` timestamp NULL DEFAULT NULL,
    `img_url2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `img_url3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `img_url4` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `img_url5` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `img_url6` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `img_url7` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`product_id`) USING BTREE
  ) ENGINE=InnoDB AUTO_INCREMENT=747 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;
  
  -- ----------------------------
  -- Records of product
  -- ----------------------------
  INSERT INTO `product` VALUES ('600','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur1','10','51.00','imgs/1.jpg','','2019-05-26 13:00:41',NULL,'2019-05-11 13:44:23',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('601','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur2','10','66.00','imgs/2.jpg','','2019-05-27 08:30:04',NULL,'2019-05-11 13:44:29',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('602','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur3','10','93.00','imgs/1.jpg','','2019-05-26 13:00:41',NULL,'2019-05-11 13:44:39',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('603','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur4','10','67.00','imgs/2.jpg','','2019-05-26 13:00:41',NULL,'2019-05-11 13:44:34',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('604','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur5','10','36.00','imgs/1.jpg','','2019-05-26 13:00:41',NULL,'2019-05-24 22:15:54',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('605','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur6','10','67.00','imgs/2.jpg','','2019-06-24 21:52:10',NULL,'2019-05-12 22:36:05',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('606','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur7','10','56.00','imgs/1.jpg','','2019-05-27 08:30:04',NULL,'2019-05-24 22:15:54',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('607','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur8','10','51.00','imgs/1.jpg','','2019-05-27 08:30:04',NULL,'2019-05-24 22:15:54',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('608','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur9','10','62.00','imgs/1.jpg','','2019-06-24 21:52:10',NULL,'2019-05-12 22:36:23',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('609','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur10','10','13.00','imgs/1.jpg','','2019-05-26 13:00:41',NULL,'2019-05-12 22:36:23',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('610','2','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur11','10','83.00','imgs/1.jpg','','2019-05-26 13:00:41',NULL,'2019-05-12 22:36:23',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('611','2','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur12','9','55.00','imgs/1.jpg','','2019-05-27 19:29:27',NULL,'2019-05-12 22:36:23',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('612','2','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur13','10','96.00','imgs/1.jpg','','2019-05-26 13:00:41',NULL,'2019-05-12 22:36:23',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('613','2','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur14','10','27.00','imgs/1.jpg','','2019-06-24 21:52:10',NULL,'2019-05-12 22:36:23',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('614','2','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur15','10','34.00','imgs/1.jpg','','2019-05-26 13:00:41',NULL,'2019-05-12 22:36:23',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('615','2','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur16','10','100.00','imgs/1.jpg','','2019-05-26 13:00:41',NULL,'2019-05-12 22:36:29',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('616','2','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur17','10','96.00','imgs/1.jpg','','2019-05-26 13:00:41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('617','2','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur18','10','9.00','imgs/1.jpg','','2019-05-26 13:00:41',NULL,'2019-05-24 21:47:24',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('618','2','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur19','10','12.00','imgs/1.jpg','','2019-06-24 21:52:10',NULL,'2019-05-11 20:57:35',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('619','2','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur20','10','34.00','imgs/1.jpg','','2019-05-26 13:00:41',NULL,'2019-05-24 21:46:40',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('620','3','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur21','10','33.00','imgs/1.jpg','','2019-05-26 13:00:41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('621','3','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur22','10','14.00','imgs/1.jpg','','2019-05-26 13:00:41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('622','3','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur23','10','6710.00','imgs/1.jpg','','2019-05-26 13:00:41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('623','3','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur24','10','43.00','imgs/1.jpg','','2019-05-26 13:00:41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('624','3','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur25','10','14.00','imgs/1.jpg','','2019-05-26 13:00:41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('625','3','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur26','10','75.00','imgs/1.jpg','','2019-05-26 13:00:41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('626','3','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur27','11','85.00','imgs/1.jpg','','2019-05-27 12:31:05',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('627','3','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur28','10','45.00','imgs/1.jpg','','2019-05-26 13:00:41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('628','3','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur29','10','92.00','imgs/1.jpg','','2019-05-26 13:00:41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('629','3','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur30','10','31.00','imgs/1.jpg','','2019-05-27 08:30:04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('630','4','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur31','10','62.00','imgs/1.jpg','','2019-05-27 08:30:04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('631','4','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur32','10','92.00','imgs/1.jpg','','2019-05-27 08:30:04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('632','4','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur33','10','85.00','imgs/1.jpg','','2019-05-27 08:30:04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('633','4','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur34','10','12.00','imgs/1.jpg','','2019-05-27 08:30:04',NULL,'2019-05-13 12:58:32',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('634','4','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur35','10','90.00','imgs/1.jpg','','2019-05-27 08:30:04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('635','4','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur36','10','11.00','imgs/1.jpg','','2019-05-27 08:30:04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('636','4','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur37','10','3.00','imgs/1.jpg','','2019-05-27 08:30:04',NULL,'2019-05-11 21:35:02',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('637','4','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur38','10','47.00','imgs/1.jpg','','2019-05-27 08:30:04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('638','4','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur39','10','123.00','imgs/1.jpg','aaaaa1','2019-05-27 08:30:04',NULL,'2019-05-14 12:30:45',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('639','4','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur40','10','29.00','imgs/1.jpg','','2019-05-27 08:30:04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('640','4','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur41','9','12.00','imgs/1.jpg','','2019-05-29 11:02:04',NULL,'2019-05-13 13:00:03',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('641','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur42','10','12.00','imgs/1.jpg','','2019-05-27 08:30:04',NULL,'2019-05-14 19:59:40',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('642','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur43','10','97.00','imgs/1.jpg','','2019-06-24 21:52:10',NULL,'2019-05-11 13:48:06',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('643','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur44','10','123123.00','imgs/1.jpg','','2019-06-24 21:52:00',NULL,'2019-05-14 19:59:38',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('644','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur45','10','13.00','imgs/1.jpg','','2019-06-24 21:52:11',NULL,'2019-05-11 13:43:46',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('645','1','B00N2BIFXS','halou','9','123.00','uploadImg/20190624/f705755302aa5377679bb7592e45e952.jpg','halouhalouhalouhalouhalouhalou','2019-06-24 21:42:55',NULL,'2019-06-24 21:42:55','','','','','','');
  INSERT INTO `product` VALUES ('646','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur47','10','31.00','imgs/1.jpg','','2019-06-24 21:52:00',NULL,'2019-05-12 22:45:45',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('647','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur48','10','23.00','imgs/1.jpg','','2019-05-27 08:30:04',NULL,'2019-05-12 22:45:45',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('648','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur49','10','47.00','imgs/1.jpg','','2019-06-24 21:52:10',NULL,'2019-05-11 13:47:59',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('649','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur50','10','85.00','imgs/1.jpg','','2019-06-24 21:52:00',NULL,'2019-05-12 22:45:45',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('650','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur51','10','91.00','imgs/1.jpg','','2019-06-24 21:52:00',NULL,'2019-05-12 22:45:45',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('651','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur52','10','64.00','imgs/1.jpg','','2019-05-27 08:30:04',NULL,'2019-05-12 22:45:45',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('652','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur53','10','83.00','imgs/1.jpg','','2019-06-24 21:52:00',NULL,'2019-05-12 22:45:45',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('653','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur54','10','7.00','imgs/1.jpg','','2019-05-27 08:30:04',NULL,'2019-05-12 22:45:45',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('654','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur55','10','71.00','imgs/1.jpg','','2019-05-27 08:30:04',NULL,'2019-05-12 22:45:45',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('655','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur56','10','90.00','imgs/1.jpg','','2019-06-24 21:52:00',NULL,'2019-05-12 22:45:45',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('656','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur57','10','62.00','imgs/1.jpg','','2019-06-24 21:52:11',NULL,'2019-05-11 13:42:25',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('657','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur58','10','63.00','imgs/1.jpg','','2019-05-27 08:30:04',NULL,'2019-05-12 22:45:33',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('658','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur59','10','29.00','imgs/1.jpg','','2019-06-24 21:52:00',NULL,'2019-05-12 22:45:45',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('659','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur60','10','90.00','imgs/1.jpg','','2019-05-27 08:30:04',NULL,'2019-05-12 22:45:33',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('671','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur72','9','28.00','imgs/1.jpg','','2019-06-24 21:36:18',NULL,'2019-05-12 22:45:33',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('673','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur74','10','9.00','imgs/1.jpg','','2019-06-24 21:52:10',NULL,'2019-05-11 13:47:05',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('674','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur75','10','92.00','imgs/1.jpg','','2019-06-24 21:52:00',NULL,'2019-05-12 22:45:33',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('675','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur76','10','52.00','imgs/1.jpg','','2019-06-24 21:52:10',NULL,'2019-05-11 13:47:41',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('676','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur77','10','62.00','imgs/1.jpg','','2019-06-24 21:52:10',NULL,'2019-05-11 13:47:32',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('678','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur79','10','61.00','imgs/1.jpg','','2019-06-24 21:52:03',NULL,'2019-05-12 22:44:32',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('679','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur80','10','92.00','imgs/1.jpg','','2019-06-24 21:52:03',NULL,'2019-05-12 22:44:32',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('680','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur81','10','96.00','imgs/1.jpg','','2019-06-24 21:52:11',NULL,'2019-05-11 13:45:11',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('681','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur82','10','84.00','imgs/1.jpg','','2019-06-24 21:52:10',NULL,'2019-05-12 22:35:15',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('682','1','B00N2BIFXS','Lorem ipsum dolor sit amet consectetur83','10','22.00','imgs/1.jpg','','2019-06-24 21:52:10',NULL,'2019-05-12 22:35:15',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('715','1','B00N2BIFXS','aaa','10','123.00','uploadImg/2019051198fc84fc6fc0208753a9c13bb77cb01c.jpg','123123123123123123123123123123123123','2019-06-24 21:52:04',NULL,'2019-05-12 22:42:09',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('716','1','B00N2BIFXS','kang de yu lu ','10','123.00','uploadImg/201905115e0bec93792cc7e4f6fed45fe4126c33.png','layui-elem-quote layui-quote-nmlayui-elem-quote layui-quote-nmlayui-elem-quote layui-quote-nmlayui-elem-quote layui-quote-nmlayui-elem-quote layui-quote-nm','2019-06-24 21:52:03',NULL,'2019-05-12 22:42:57',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('717','1','B00N2BIFXS','12312312','10','123123.00','uploadImg/201905116556a3fc370c408f675ebb1431d7830d.png','123123','2019-06-24 21:52:04',NULL,'2019-05-12 22:37:43',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('718','1','B00N2BIFXS','123123','10','123123.00','uploadImg/201905114928c583568d9a1702fdac6fceb7a613.png','1','2019-06-24 21:52:10',NULL,'2019-05-12 22:37:43',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('719','1','B00N2BIFXS','123123','10','123123.00','uploadImg/201905112730bdeb424d75ba9a10a16c7fcb774d.png','123123','2019-06-24 21:52:10',NULL,'2019-05-12 22:37:43',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('720','1','B00N2BIFXS','123123','10','123.00','uploadImg/20190511fb43cc156957bbec676363787088db8d.png','','2019-06-24 21:52:10',NULL,'2019-05-12 22:37:43',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('721','1','B00N2BIFXS','123123','10','123.00','uploadImg/20190511f4e3f4e2bd1f03dfc4f87a2265010871.png','','2019-06-24 21:52:10',NULL,'2019-05-12 22:37:43',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('722','1','B00N2BIFXS','bbb','10','123.00','uploadImg/20190511a02bb1aecc4ba6a3b8a21e05cebd3253.png','123','2019-06-24 21:52:10',NULL,'2019-05-12 22:37:43',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('723','1','B00N2BIFXS','bbb','10','123.00','uploadImg/20190511a02bb1aecc4ba6a3b8a21e05cebd3253.png','123','2019-06-24 21:52:04',NULL,'2019-05-12 22:37:43',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('724','1','B00N2BIFXS','123123','10','123.00','uploadImg/20190511f8ed52001686eb18d245b1a271e9120a.png','','2019-06-24 21:52:04',NULL,'2019-05-12 22:37:43',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('725','1','B00N2BIFXS','123123','10','123.00','uploadImg/20190511f8ed52001686eb18d245b1a271e9120a.png','','2019-06-24 21:52:10',NULL,'2019-05-12 22:35:00',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('726','1','B00N2BIFXS','123123','10','123.00','uploadImg/20190511f8ed52001686eb18d245b1a271e9120a.png','','2019-06-24 21:52:10',NULL,'2019-05-12 22:35:00',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('727','1','B00N2BIFXS','123123','10','123.00','uploadImg/20190511f8ed52001686eb18d245b1a271e9120a.png','','2019-06-24 21:52:10',NULL,'2019-05-12 22:35:00',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('728','1','B00N2BIFXS','123123','10','123.00','uploadImg/20190511f8ed52001686eb18d245b1a271e9120a.png','','2019-06-24 21:52:10',NULL,'2019-05-12 22:35:00',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('729','1','B00N2BIFXS','123123','10','123.00','uploadImg/20190511f8ed52001686eb18d245b1a271e9120a.png','','2019-06-24 21:52:03',NULL,'2019-05-12 22:42:57',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('730','1','B00N2BIFXS','123123','10','123.00','uploadImg/20190511f8ed52001686eb18d245b1a271e9120a.png','','2019-06-24 21:52:10',NULL,'2019-05-12 22:33:31',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('731','1','B00N2BIFXS','123123','10','123.00','uploadImg/20190511fdfdea22822a37fca005ca50cfac1f0b.png','123','2019-06-24 21:52:10',NULL,'2019-05-12 22:33:31',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('732','1','B00N2BIFXS','12312312','10','123.00','uploadImg/201905115e169780838d7591d1973af319079dff.png','','2019-06-24 21:52:04',NULL,'2019-05-12 22:42:57',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('733','1','B00N2BIFXS','123123','10','33.00','uploadImg/20190511ffbe31454bad8bef88df6fb41bfcdd52.png','','2019-06-24 21:52:10',NULL,'2019-05-12 00:01:09',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('734','1','B00N2BIFXS','123123','10','123123.00','uploadImg/20190511916b184e35c4e8948cb34531d1261def.png','','2019-06-24 21:52:03',NULL,'2019-05-12 22:42:57',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('735','1','B00N2BIFXS','123123','10','123.00','uploadImg/20190512e2c8ac88b478b5185030c24798c11dd.png','','2019-06-24 21:52:10',NULL,'2019-05-12 00:01:05',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('736','1','B00N2BIFXS','123123','10','123.00','uploadImg/20190512c3d4d7b68f82e2f04e9949ba343ae9e7.png','123','2019-06-24 21:52:10',NULL,'2019-05-12 00:01:01',NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `product` VALUES ('737','1','B00N2BIFXS','Lorem ipsum dolor sit amet laya 4612','10','12.00','uploadImg/20190624/dd961f0508bdec1ab87cb68395c0b044.gif','','2019-06-24 21:44:59',NULL,'2019-06-24 21:44:59','','','','','','');
  INSERT INTO `product` VALUES ('738','1','B00N2BIFXS','Lorem ipsu123123','10','12.00','uploadImg/20190603/6dfdb87fb06b561318efd0bf07480819.png','','2019-06-24 21:52:00',NULL,'2019-06-03 10:45:40','','','','','','');
  INSERT INTO `product` VALUES ('739','1','B00N2BIFXS','Lorem ipsu123123','10','12.00','uploadImg/20190624/3f31a8136c04fe0ac2087ddfdb89a1d9.gif','1231231231231','2019-06-24 21:44:36',NULL,'2019-06-24 21:44:36','','','','','','');
  INSERT INTO `product` VALUES ('740','1','B00N2BIFXS','asd asd asd asd','10','123.00','uploadImg/201905233a6558735cd5f2cfcfc6932aba6436f2.png','asdaasd','2019-06-24 21:52:00',NULL,'2019-06-03 10:45:04','uploadImg/201905234abbc693f9e7656e28f2d1517a3b4c72.png','uploadImg/20190523930a2a2b9f5418553f36b5361f2c9c4a.png','','uploadImg/201905234374dba7b1d3052730b5d8f07b31f6b7.png','uploadImg/201905235554d66061bcb2ab53de0016518c958e.png','uploadImg/201905236ecca5a31f150cf720d45f05123f2114.png');
  INSERT INTO `product` VALUES ('741','1','B00N2BIFXS','123123','10','123.00','uploadImg/20190624/0a195d563668e0cafd3058dfe64c8417.jpg','123123','2019-06-24 21:44:09',NULL,'2019-06-24 21:44:09','uploadImg/20190624/9f7b21746f944b90186d67fca7eb8f01.jpg','uploadImg/20190624/5187a9dccd07b1367303a5b5d005e4f5.gif','uploadImg/20190624/78ad7e93a582e7a6820f63e1ceac9e07.gif','uploadImg/20190624/60a884e65475074725da73ded4847d08.gif','uploadImg/20190624/a1c3fe9a6b71d8a5fc81ed1eb21847b7.gif','uploadImg/20190624/f814011b602c71d3f9c160c012d37477.png');
  INSERT INTO `product` VALUES ('742','1','B00N2BIFXS','big foo foo foo foo ','10','11.00','uploadImg/20190624/4c6963b057b66f9f3902b2a5d9010c74.jpg','foo foo foo ','2019-06-24 21:42:07',NULL,'2019-06-24 21:42:07','uploadImg/20190624/f66f3082812b8572aa59f7e89df84d55.jpg','uploadImg/20190624/91e056e1f3e73aaa4a4fe60ed2409381.gif','','','','');
  INSERT INTO `product` VALUES ('743','1','B00N2BIFXS','333','10','33.00','uploadImg/20190624/6b9ded8cc37f7181f7e3409da220501f.jpg','33','2019-06-24 21:43:20',NULL,'2019-06-24 21:43:20','','','','','','');
  INSERT INTO `product` VALUES ('744','1','B00N2BIFXS','123123123','10','123.00','uploadImg/20190624/896973a6549939b58d8a001d58e70861.jpg','','2019-06-24 21:42:32',NULL,'2019-06-24 21:42:32','','','','','','');
  INSERT INTO `product` VALUES ('745','2','B00N2BIFXS','123123','10','1.00','uploadImg/20190624/1e5a2b5bae14d198c2f434de1ca89f59.jpg','<p>123123</p><p>123123</p><p>123123</p><p>123123</p>','2019-06-24 21:42:26',NULL,'2019-06-24 21:42:26','','','','','','');
  INSERT INTO `product` VALUES ('746','1','B00N2BIFXS','Laya Male outdoor shoulder backpack 110161','9','12.00','uploadImg/20190610/34e8fc6a2ff1786876c4d700acddf35a.jpg','<ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Top Accessory Pocket</span></li><li><span class="a-list-item">External and Internal Accessible Laptop Compartment</span></li><li><span class="a-list-item">Rucksack Style Main Entry with Drawstring Closure</span></li><li><span class="a-list-item">Internal Zippered Mesh Pocket with Key Clip</span></li><li><span class="a-list-item">25L [20in x 13in x 6in] [52cm x 32cm x 16cm], 1.8 lbs. 0.8kg</span></li></ul>','2019-06-24 21:36:10',NULL,'2019-06-10 14:33:45','uploadImg/20190610/1e3fb4a6d28ec5ae999d3cebdfe57ae6.jpg','uploadImg/20190610/4bb9448c29de755bb73d1a2436ce1d95.jpg','uploadImg/20190610/9e80a1e9a1f3a0831339c492df59762d.jpg','uploadImg/20190610/d57f02d3003c9af159715610d469db94.jpg','uploadImg/20190610/81daaa9440c2aa030dabec3505fc00bd.jpg','uploadImg/20190610/7cabb2e58ccce85567d3b199198b347d.jpg');
  
  
  -- ----------------------------
  -- Table structure for purchased
  -- ----------------------------
  DROP TABLE IF EXISTS `purchased`;
  CREATE TABLE `purchased` (
    `purchased_id` int(11) NOT NULL AUTO_INCREMENT,
    `username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `product_id` int(11) DEFAULT NULL,
    `order_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `review_img` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `admin_review` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ts` timestamp NULL DEFAULT NULL,
    `delete_time` timestamp NULL DEFAULT NULL,
    `update_time` datetime DEFAULT NULL,
    `status` int(1) DEFAULT NULL,
    `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `paypal` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`purchased_id`) USING BTREE
  ) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;
  
  -- ----------------------------
  -- Records of purchased
  -- ----------------------------
  INSERT INTO `purchased` VALUES ('111','a7laya','746','123','uploadReview/201905276bcb18a3b137b66ea41d727532b13526.jpg',NULL,'2019-05-26 23:11:39',NULL,'2019-05-27 19:32:17','2','wo kao','75739899@qq.com');
  INSERT INTO `purchased` VALUES ('112','a7laya','743','1231232','uploadReview/20190528aa5586dd1d1698da48be112b82293a87.jpg',NULL,'2019-05-27 08:28:33',NULL,'2019-05-28 09:46:36','2','wo kao','75739899@qq.com');
  INSERT INTO `purchased` VALUES ('116','a7laya','645','123','uploadReview/20190527d055a728a2952896b089bc2cd4da128e.jpg',NULL,'2019-05-27 12:40:53',NULL,'2019-05-27 20:38:59','2','wo kao','75739899@qq.com');
  INSERT INTO `purchased` VALUES ('117','a7laya','611','123','uploadReview/20190527c802199ef297922015bb6b5183510efa.jpg',NULL,'2019-05-27 19:29:27',NULL,'2019-05-27 20:39:13','2','wo kao','75739899@qq.com');
  INSERT INTO `purchased` VALUES ('118','a7laya','640',NULL,NULL,NULL,'2019-05-29 11:02:04',NULL,'2019-06-21 18:48:29','0','wo kao','75739899@qq.com');
  INSERT INTO `purchased` VALUES ('121','admin','746',NULL,NULL,NULL,'2019-06-24 21:36:10',NULL,'2019-06-24 21:36:10','0','123','123');
  INSERT INTO `purchased` VALUES ('122','admin','671',NULL,NULL,NULL,'2019-06-24 21:36:18',NULL,'2019-06-24 21:36:18','0','123','123');
  
  
  -- ----------------------------
  -- Table structure for seller
  -- ----------------------------
  DROP TABLE IF EXISTS `seller`;
  CREATE TABLE `seller` (
    `seller_id` int(11) NOT NULL AUTO_INCREMENT,
    `seller_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `delete_time` datetime DEFAULT NULL,
    `update_time` datetime DEFAULT NULL,
    `create_time` datetime DEFAULT NULL,
    PRIMARY KEY (`seller_id`) USING BTREE
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;
  
  -- ----------------------------
  -- Records of seller
  -- ----------------------------
  INSERT INTO `seller` VALUES ('1','Laya',NULL,'2019-05-26 16:17:09','2019-05-23 23:34:10');
  INSERT INTO `seller` VALUES ('2','seller_one',NULL,'2019-05-25 10:37:32','2019-05-24 19:49:04');
  INSERT INTO `seller` VALUES ('3','laya3',NULL,'2019-05-25 13:10:49','2019-05-25 13:10:13');
  INSERT INTO `seller` VALUES ('4','laya4',NULL,'2019-05-25 13:10:19','2019-05-25 13:10:19');
  
  
  -- ----------------------------
  -- Table structure for setting
  -- ----------------------------
  DROP TABLE IF EXISTS `setting`;
  CREATE TABLE `setting` (
    `setting_id` int(11) NOT NULL AUTO_INCREMENT,
    `contact` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
    `site_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `create_time` datetime DEFAULT NULL,
    `update_time` datetime DEFAULT NULL,
    `dalete_time` datetime DEFAULT NULL,
    PRIMARY KEY (`setting_id`) USING BTREE
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;
  
  -- ----------------------------
  -- Records of setting
  -- ----------------------------
  INSERT INTO `setting` VALUES ('1','<p class="MsoNormal"><span>Please feel free to contact us if you have any other questions.</span></p><p>Email ：COMAZON1@COMAZON.com</p><p>Tel: 123123123</p>','COMAZON1','2019-05-21 10:05:21','2019-05-27 19:37:58',NULL);
  
  
  -- ----------------------------
  -- Table structure for user
  -- ----------------------------
  DROP TABLE IF EXISTS `user`;
  CREATE TABLE `user` (
    `user_id` int(4) NOT NULL AUTO_INCREMENT,
    `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `create_time` timestamp NULL DEFAULT NULL,
    `delete_time` timestamp NULL DEFAULT NULL,
    `update_time` datetime DEFAULT NULL,
    `tel` varchar(255) DEFAULT NULL,
    `paypal` varchar(255) DEFAULT NULL,
    `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `last_login_ip` varchar(255) DEFAULT NULL,
    `last_login_time` datetime DEFAULT NULL,
    `referral_code` varchar(6) DEFAULT NULL,
    PRIMARY KEY (`user_id`) USING BTREE
  ) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- ----------------------------
  -- Records of user
  -- ----------------------------
  INSERT INTO `user` VALUES ('45','a7laya','c59d855f0b7e2941ee19faa5f59b028a','75@qq.com','2019-04-23 16:15:20',NULL,'2019-05-29 11:02:04','121131123123','75739899@qq.com','wo kao','','127.0.0.1','2019-05-29 19:38:32',NULL);
  INSERT INTO `user` VALUES ('46','a8laya','c59d855f0b7e2941ee19faa5f59b028a','123@123.com','2019-04-23 21:50:52','2019-05-20 21:08:55','2019-05-20 21:08:55',NULL,NULL,NULL,NULL,'127.0.0.1','2019-05-19 18:38:24',NULL);
  INSERT INTO `user` VALUES ('47','a9laya','c59d855f0b7e2941ee19faa5f59b028a','a9laya@qq.com','2019-04-24 17:03:49','2019-05-20 21:09:00','2019-05-20 21:09:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `user` VALUES ('48','a10laya','c59d855f0b7e2941ee19faa5f59b028a','a10laya@qq.com','2019-04-24 22:48:54',NULL,'2019-05-22 10:35:45','123123','zzzzz','','',NULL,NULL,NULL);
  INSERT INTO `user` VALUES ('49','a12laya','c59d855f0b7e2941ee19faa5f59b028a','123456@qq.com','2019-05-06 22:19:48','2019-05-15 10:13:55','2019-05-15 10:13:55',NULL,NULL,NULL,NULL,'127.0.0.1','2019-05-27 10:50:58',NULL);
  INSERT INTO `user` VALUES ('50','a12laya12','c59d855f0b7e2941ee19faa5f59b028a','123123@123.com','2019-05-20 13:57:30',NULL,'2019-05-20 13:57:30',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  INSERT INTO `user` VALUES ('51','a12laya','c59d855f0b7e2941ee19faa5f59b028a','a12laya@123.com','2019-05-20 14:12:19',NULL,'2019-05-26 12:34:49','','123','123','','127.0.0.1','2019-05-27 10:50:58',NULL);
  INSERT INTO `user` VALUES ('52','a213123','c59d855f0b7e2941ee19faa5f59b028a','asdasd@123.com','2019-05-20 14:14:32','2019-05-20 23:15:41','2019-05-20 23:15:41',NULL,NULL,NULL,NULL,NULL,NULL,'48HCLf');
  INSERT INTO `user` VALUES ('57','a17laya','c59d855f0b7e2941ee19faa5f59b028a','123@321.com','2019-05-20 16:15:42',NULL,'2019-05-20 23:04:19','','123','','我看看',NULL,NULL,'bhnM1x');
  INSERT INTO `user` VALUES ('58','a22laya1','c59d855f0b7e2941ee19faa5f59b028a','a8laau@213.com','2019-05-20 16:47:24',NULL,'2019-05-20 22:57:30','1','123','123','123',NULL,NULL,'48HCLf');
  INSERT INTO `user` VALUES ('59','a21laya','c59d855f0b7e2941ee19faa5f59b028a','123@213.com','2019-05-20 16:48:52',NULL,'2019-05-22 08:53:58','123','123','','123',NULL,NULL,'tZvf7O');
  INSERT INTO `user` VALUES ('60','admin','c59d855f0b7e2941ee19faa5f59b028a','admin@123.com','2019-05-20 21:16:30',NULL,'2019-06-24 21:36:18','00000','123','123','123','117.150.193.68','2019-06-24 21:36:34','PqEKZl');
  
  
  -- ----------------------------
  -- View structure for vproduct
  -- ----------------------------
  DROP VIEW IF EXISTS `vproduct`;
  CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vproduct` AS select `p`.`product_id` AS `product_id`,`p`.`seller_id` AS `seller_id`,`s`.`seller_name` AS `seller_name`,`p`.`ASIN` AS `ASIN`,`p`.`title` AS `title`,`p`.`quantity` AS `quantity`,`p`.`price` AS `price`,`p`.`img_url` AS `img_url`,`p`.`description` AS `description`,`p`.`img_url2` AS `img_url2`,`p`.`img_url3` AS `img_url3`,`p`.`img_url4` AS `img_url4`,`p`.`img_url5` AS `img_url5`,`p`.`img_url6` AS `img_url6`,`p`.`img_url7` AS `img_url7`,`p`.`delete_time` AS `delete_time`,`p`.`update_time` AS `update_time`,`p`.`create_time` AS `create_time` from (`product` `p` join `seller` `s` on((`p`.`seller_id` = `s`.`seller_id`)));
  
  -- ----------------------------
  -- View structure for vpurchased
  -- ----------------------------
  DROP VIEW IF EXISTS `vpurchased`;
  CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vpurchased` AS select `a`.`status` AS `status`,`a`.`address` AS `address`,`a`.`paypal` AS `paypal`,`a`.`purchased_id` AS `purchased_id`,`a`.`username` AS `username`,`a`.`ts` AS `ts`,`a`.`order_id` AS `order_id`,`a`.`review_img` AS `review_img`,`a`.`admin_review` AS `admin_review`,`a`.`delete_time` AS `delete_time`,`a`.`update_time` AS `update_time`,`b`.`seller_id` AS `seller_id`,`b`.`ASIN` AS `ASIN`,`b`.`title` AS `title`,`b`.`price` AS `price`,`b`.`img_url` AS `img_url`,`b`.`description` AS `description`,`b`.`product_id` AS `product_id`,`c`.`user_id` AS `user_id`,`c`.`email` AS `email`,`d`.`seller_name` AS `seller_name` from (((`purchased` `a` join `product` `b` on((`a`.`product_id` = `b`.`product_id`))) join `user` `c` on((`a`.`username` = `c`.`username`))) join `seller` `d` on((`b`.`seller_id` = `d`.`seller_id`))) where isnull(`c`.`delete_time`);
  
  