/*
SQLyog Ultimate v12.09 (64 bit)
MySQL - 5.7.41 
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;

create table `customer_info` (
	`id` int (11),
	`name` varchar (765),
	`phone` varchar (765),
	`createTime` datetime ,
	`pre_time` datetime ,
	`city` varchar (765),
	`wechat` varchar (765),
	`seller_id` int (11)
); 
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('1','顾智宸','15564206102','2022-04-06 21:39:49','2022-07-01 02:22:44','乳山','17617217969','61');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('2','叶雨泽','17152556822','2022-01-26 01:45:39','2022-05-12 01:16:04','湖州','13466714499','67');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('3','卢语堂','17670112426','2022-04-06 19:20:11','2022-11-01 12:55:36','丽水','15657303064','28');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('4','孙皓轩','15622224925','2022-04-10 13:11:22','2022-07-31 04:30:08','阳江','15945111886','39');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('5','徐鑫磊','17156451862','2022-07-18 17:58:57','2022-06-30 20:13:36','莱西','17194672148','56');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('6','钱雨泽','17089872364','2022-05-13 11:20:31','2022-02-25 08:09:50','武汉','17591220183','85');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('7','刘航','14745044302','2022-03-04 04:47:07','2022-12-03 07:04:58','绵阳','15872403921','71');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('8','郑烨霖','15168080583','2022-03-30 19:00:59','2022-04-21 08:46:19','抚顺','14535970437','19');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('9','白哲瀚','15697405785','2022-09-11 01:19:05','2022-06-08 07:28:54','徐州','17562792772','87');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('10','毛荣轩','15379674779','2022-11-04 14:09:17','2022-09-02 09:02:11','温州','17015822985','30');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('11','郝绍辉','14799000608','2022-10-25 19:47:51','2022-09-21 19:05:06','岳阳','15302042811','48');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('12','姚瑾瑜','17606953965','2022-01-17 18:46:07','2022-08-08 20:03:24','沈阳','17369302473','82');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('13','廖远航','15115653326','2022-09-01 05:23:49','2022-09-05 16:27:56','葫芦岛','17837763427','35');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('14','何嘉懿','17679820212','2022-05-19 20:39:39','2022-03-13 14:44:27','乳山','17239348813','7');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('15','胡明辉','13449494495','2022-10-19 04:31:15','2022-08-26 21:45:53','济南','17546999687','89');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('16','许熠彤','18759299842','2022-10-14 20:19:22','2022-01-15 07:01:35','淄博','15577594012','42');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('17','陈驰','13817894340','2022-06-14 23:57:53','2022-07-18 03:58:33','湖州','15968784982','29');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('18','李子涵','15707753425','2022-04-26 07:43:27','2022-06-08 22:50:41','寿光','17344485077','44');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('19','林彬','15670539767','2022-05-05 14:05:20','2022-07-10 13:32:24','太原','17658934464','33');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('20','曾钰轩','17231414536','2022-01-26 07:49:07','2022-02-17 15:25:41','苏州','14565083864','47');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('21','杜子默','14756315677','2022-07-06 22:23:45','2022-12-03 11:51:14','河源','14553763430','99');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('22','邹鑫鹏','17308525437','2022-03-21 16:55:02','2022-03-29 12:43:20','玉溪','15557680378','6');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('23','曹明哲','17108290858','2022-01-02 14:27:24','2022-05-08 05:17:51','成都','15987131202','77');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('24','宋瑞霖','14729810717','2022-08-04 03:40:02','2022-08-31 03:25:47','淮安','17307787373','58');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('25','林子默','17311051030','2022-02-13 07:56:11','2022-06-05 04:14:12','阳泉','14792196024','85');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('26','阎伟诚','15013545681','2022-07-31 09:58:16','2022-07-21 23:35:02','西宁','17273974375','79');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('27','尹越彬','15806807298','2022-09-11 03:58:11','2022-05-10 03:57:42','延安','17271111184','2');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('28','段皓轩','17889055208','2022-08-25 01:12:55','2022-11-08 14:04:21','南通','15698895568','35');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('29','杜明辉','17083813056','2022-09-30 22:39:37','2022-10-18 04:33:22','自贡','15048186942','50');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('30','袁耀杰','15265007781','2022-08-29 15:57:06','2022-07-25 23:00:46','拉萨','14784193199','51');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('31','何熠彤','17660196731','2022-05-01 21:09:14','2022-12-01 00:17:27','苏州','15083611120','52');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('32','张立果','15377824754','2022-02-06 09:27:02','2022-09-03 23:50:43','衡水','17234955877','77');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('33','顾远航','17076228382','2022-11-17 05:51:24','2022-09-01 19:41:23','桂林','17504715846','15');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('34','贾烨伟','17090610502','2022-03-29 12:15:37','2022-09-12 10:53:04','淮安','17756432220','18');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('35','田远航','15872379475','2022-01-17 01:15:21','2022-09-09 07:46:08','宜昌','17667574452','66');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('36','马鹤轩','18210954502','2022-09-14 00:59:27','2022-03-02 18:03:22','无锡','17600730466','7');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('37','贾正豪','15094844926','2022-10-05 14:47:48','2022-02-15 05:06:47','三门峡','18107441654','38');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('38','顾致远','17798262590','2022-08-20 04:57:36','2022-04-19 12:56:23','嘉兴','15768861507','53');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('39','钱煜城','15035348667','2022-03-18 01:51:12','2022-04-20 07:29:03','广州','17383084644','60');
insert into `customer_info` (`id`, `name`, `phone`, `createTime`, `pre_time`, `city`, `wechat`, `seller_id`) values('40','董文博','14594836466','2022-02-06 04:54:41','2022-04-30 16:13:38','莱芜','15556483203','100');