forked from siam1026/siam-server
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathsiam_db.sql
5120 lines (4970 loc) · 601 KB
/
siam_db.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for tb_admin
-- ----------------------------
DROP TABLE IF EXISTS `tb_admin`;
CREATE TABLE `tb_admin` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`username` varchar(50) DEFAULT NULL COMMENT '管理员用户名',
`mobile` varchar(11) NOT NULL COMMENT '手机号',
`password` varchar(100) DEFAULT NULL COMMENT '密码',
`password_salt` varchar(100) DEFAULT NULL COMMENT '密码加盐',
`nickname` varchar(100) DEFAULT NULL COMMENT '昵称',
`roles` varchar(128) DEFAULT NULL COMMENT '权限',
`is_disabled` int(1) NOT NULL DEFAULT '0' COMMENT '是否禁用 0=启用 1=禁用',
`is_deleted` int(1) NOT NULL DEFAULT '0' COMMENT '是否删除 0=正常 1=已删除',
`disabled` int(1) NOT NULL DEFAULT '0' COMMENT '是否禁用 0=启用 1=禁用',
`create_time` datetime DEFAULT NULL COMMENT '注册时间',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`last_login_time` datetime DEFAULT NULL COMMENT '最后登陆时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='后台管理员表';
-- ----------------------------
-- Records of tb_admin
-- ----------------------------
INSERT INTO `tb_admin` VALUES ('1', 'admin', '13121860001', 'e9cb2c139f656e6f7b0745dd1e4e8c84', '9f7986235b06419fbabf50d9f29fba6a', 'admin', '0', '0', '0', '0', '2019-10-21 15:57:57', '2019-10-21 15:58:00', '2023-11-24 14:39:05');
INSERT INTO `tb_admin` VALUES ('2', 'siam', '13121865386', 'e9cb2c139f656e6f7b0745dd1e4e8c84', '9f7986235b06419fbabf50d9f29fba6a', 'siam', '0', '0', '0', '0', '2019-10-21 15:57:57', '2019-10-21 15:58:00', '2023-11-24 15:08:38');
-- ----------------------------
-- Table structure for tb_admin_token
-- ----------------------------
DROP TABLE IF EXISTS `tb_admin_token`;
CREATE TABLE `tb_admin_token` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`admin_id` int(11) NOT NULL COMMENT '管理员id',
`username` varchar(50) DEFAULT NULL COMMENT '管理员用户名',
`token` varchar(128) NOT NULL COMMENT 'token',
`type` varchar(5) DEFAULT NULL COMMENT '登陆方式 wap',
`login_time` datetime NOT NULL COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1226 DEFAULT CHARSET=utf8 COMMENT='管理员登陆token表';
-- ----------------------------
-- Records of tb_admin_token
-- ----------------------------
-- ----------------------------
-- Table structure for tb_advertisement
-- ----------------------------
DROP TABLE IF EXISTS `tb_advertisement`;
CREATE TABLE `tb_advertisement` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`image_name` varchar(50) DEFAULT NULL COMMENT '轮播图名称',
`image_path` varchar(256) DEFAULT NULL COMMENT '轮播图路径',
`description` varchar(50) DEFAULT NULL COMMENT '说明',
`type` int(2) DEFAULT '1' COMMENT '轮播图类型 1=首页轮播图 2=菜单页轮播图 3=积分商城页面轮播图 4=分享页面生成美图',
`sort_number` int(11) DEFAULT NULL COMMENT '排序号',
`image_link_url` varchar(256) DEFAULT NULL COMMENT '点击轮播图跳转的链接',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COMMENT='广告轮播图表';
-- ----------------------------
-- Records of tb_advertisement
-- ----------------------------
INSERT INTO `tb_advertisement` VALUES ('16', '新用户全场首单品3折', 'data/images/admin/1/deerspot_202010141035.jpg', '新店入驻,新用户全场首单品3折', '1', '1', '', '2020-04-05 06:58:40', '2020-09-22 23:29:31');
INSERT INTO `tb_advertisement` VALUES ('19', '邀请瓜分红包', 'data/images/admin/1/deerspot_1616945420417.png', '', '1', null, '/pages/mine/share/index/index', '2021-03-28 23:31:25', '2021-04-19 00:34:48');
INSERT INTO `tb_advertisement` VALUES ('20', '商城邀请海报', 'data/images/admin/1/deerspot_1616945568711.png', '', '3', null, '/pages/mine/share/index/index', '2021-03-28 23:32:55', '2021-04-19 00:34:43');
INSERT INTO `tb_advertisement` VALUES ('23', '朋友圈转发', 'data/images/admin/1/deerspot_1618144948605.png', '', '4', null, '', '2021-04-11 20:42:29', '2021-04-11 20:42:29');
INSERT INTO `tb_advertisement` VALUES ('24', '宣传海报', 'data/images/admin/1/deerspot_1619338886758.png', '', '3', null, '', '2021-04-25 16:21:29', '2021-04-25 16:21:29');
-- ----------------------------
-- Table structure for tb_appraise
-- ----------------------------
DROP TABLE IF EXISTS `tb_appraise`;
CREATE TABLE `tb_appraise` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`member_id` int(11) DEFAULT NULL COMMENT '用户id',
`order_id` int(11) DEFAULT NULL COMMENT '订单id',
`shop_id` int(11) DEFAULT NULL COMMENT '店铺id',
`appraise_type` int(1) NOT NULL DEFAULT '1' COMMENT '评价类型 1-订单评价,2-店铺评价',
`content` varchar(512) COLLATE utf8_bin NOT NULL COMMENT '评价内容',
`images_url` varchar(512) COLLATE utf8_bin DEFAULT NULL COMMENT '图url,用逗号分隔',
`level` int(1) DEFAULT NULL COMMENT '评价等级',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='用户评价表';
-- ----------------------------
-- Records of tb_appraise
-- ----------------------------
-- ----------------------------
-- Table structure for tb_coupons
-- ----------------------------
DROP TABLE IF EXISTS `tb_coupons`;
CREATE TABLE `tb_coupons` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`name` varchar(100) DEFAULT NULL COMMENT '优惠卷名称',
`preferential_type` int(11) DEFAULT NULL COMMENT '优惠类型,1=折扣,2=满减',
`discount_amount` decimal(10,2) DEFAULT '1.00' COMMENT '折扣额度',
`limited_price` decimal(10,2) DEFAULT '0.00' COMMENT '满足价格(元,满足该价格才能使用)',
`reduced_price` decimal(10,2) DEFAULT '0.00' COMMENT '减价额度(元)',
`description` varchar(500) DEFAULT NULL COMMENT '使用规则描述',
`valid_type` int(1) NOT NULL DEFAULT '2' COMMENT '时效:1绝对时效(领取后XXX-XXX时间段有效) 2相对时效(领取后N天有效)',
`valid_start_time` datetime DEFAULT NULL COMMENT '使用开始时间',
`valid_end_time` datetime DEFAULT NULL COMMENT '使用结束时间',
`valid_days` int(3) NOT NULL DEFAULT '0' COMMENT '自领取之日起有效天数',
`is_delete` tinyint(1) DEFAULT '0' COMMENT '是否被删除,0-否,1-是',
`source` int(2) DEFAULT NULL COMMENT '优惠券发放来源 1=商家中心 2=调度中心',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8 COMMENT='优惠卷表';
-- ----------------------------
-- Records of tb_coupons
-- ----------------------------
INSERT INTO `tb_coupons` VALUES ('1', '新人3折卷', '1', '0.30', '0.00', '0.00', '全场饮品一律3折', '2', null, null, '7', '0', '2', '2020-04-27 17:39:40', '2023-11-10 15:26:53');
INSERT INTO `tb_coupons` VALUES ('2', '推荐新人3折卷', '1', '0.30', '0.00', '0.00', '全场饮品一律3折', '2', null, null, '7', '0', '2', '2020-04-27 13:38:48', null);
INSERT INTO `tb_coupons` VALUES ('28', '3.8折单品券', '1', '0.38', '0.00', '0.00', '本优惠券有效期内仅限单品使用', '1', '2020-05-11 00:00:00', '2020-05-31 00:00:00', '0', '1', '1', '2020-05-11 01:26:00', null);
INSERT INTO `tb_coupons` VALUES ('29', '3折单品券', '1', '0.30', '0.00', '0.00', '全场单品可以使用', '1', '2020-05-12 00:00:00', '2020-05-31 00:00:00', '0', '1', '1', '2020-05-12 16:15:22', null);
INSERT INTO `tb_coupons` VALUES ('30', '3折单品券', '1', '0.30', '0.00', '0.00', '仅限全场单品使用', '2', null, null, '7', '1', '1', '2020-05-13 12:29:30', '2020-05-13 12:30:40');
INSERT INTO `tb_coupons` VALUES ('31', '3折单品券', '1', '0.30', '0.00', '0.00', '全场单品使用', '1', '2020-05-12 00:00:00', '2020-05-30 00:00:00', '0', '1', '1', '2020-05-13 12:31:33', null);
INSERT INTO `tb_coupons` VALUES ('32', '3折单品券', '1', '0.30', '0.00', '0.00', '全场单品使用', '1', '2020-05-12 00:00:00', '2020-06-01 00:00:00', '0', '1', '1', '2020-05-13 14:07:43', null);
INSERT INTO `tb_coupons` VALUES ('33', '3.8折单品券', '1', '0.38', '0.00', '0.00', '全场单品使用', '1', '2020-05-13 00:00:00', '2020-05-31 00:00:00', '0', '1', '1', '2020-05-14 09:07:44', null);
INSERT INTO `tb_coupons` VALUES ('34', '3.8折单品券', '1', '0.38', '0.00', '0.00', '全场单品使用', '1', '2020-05-16 00:00:00', '2020-05-31 00:00:00', '0', '1', '1', '2020-05-16 12:00:52', '2020-05-22 11:02:03');
INSERT INTO `tb_coupons` VALUES ('35', '520告白券', '1', '0.35', '0.00', '0.00', '全场单品使用', '1', '2020-05-20 00:00:00', '2020-05-21 00:00:00', '0', '1', '1', '2020-05-20 08:50:31', '2020-05-21 09:27:46');
INSERT INTO `tb_coupons` VALUES ('36', '3.8折单品券', '1', '0.38', '0.00', '0.00', '全场单品使用', '1', '2020-05-22 00:00:00', '2020-05-31 00:00:00', '0', '1', '1', '2020-05-22 11:02:55', '2020-05-30 14:43:02');
INSERT INTO `tb_coupons` VALUES ('37', '4折单品券', '1', '0.40', '0.00', '0.00', '全场单品使用', '1', '2020-05-30 00:00:00', '2020-06-05 00:00:00', '0', '1', '1', '2020-05-30 14:43:59', '2020-06-03 11:31:08');
INSERT INTO `tb_coupons` VALUES ('38', '5.5折单品券', '1', '0.55', '0.00', '0.00', '全场单品使用,邀请好友一起喝奖励3折优惠券哦', '1', '2020-06-03 00:00:00', '2020-06-30 00:00:00', '0', '1', '1', '2020-06-03 11:32:28', '2020-06-15 09:42:24');
INSERT INTO `tb_coupons` VALUES ('39', '5.8折单品券【邀请好友奖励3折券】', '1', '0.58', '0.00', '0.00', '仅限制饮品使用,邀请好友奖励3折优惠券', '1', '2020-06-15 00:00:00', '2020-08-31 00:00:00', '0', '1', '1', '2020-06-15 09:44:00', '2020-06-22 11:04:31');
INSERT INTO `tb_coupons` VALUES ('40', '3.9折节日特惠券(邀请好友获3折优惠券)', '1', '0.39', '0.00', '0.00', '全场单品使用,有效期3天,邀请好友获3折优惠券', '1', '2020-06-22 00:00:00', '2020-06-25 00:00:00', '0', '1', '1', '2020-06-22 11:06:54', '2020-06-27 11:48:02');
INSERT INTO `tb_coupons` VALUES ('41', '4.8折单品券(邀请好友奖励3折优惠券)', '1', '0.48', '0.00', '0.00', '全场单品使用,邀请好友奖励3折优惠券', '1', '2020-06-27 00:00:00', '2020-07-03 00:00:00', '0', '1', '1', '2020-06-27 11:49:31', '2020-07-03 18:40:47');
INSERT INTO `tb_coupons` VALUES ('42', '7.7专场券(邀请好友奖励3折优惠券)', '1', '0.68', '0.00', '0.00', '全场饮品使用(邀请好友奖励3折优惠券)', '1', '2020-07-03 00:00:00', '2020-09-30 00:00:00', '0', '1', '1', '2020-07-03 18:45:03', '2020-08-11 11:41:17');
INSERT INTO `tb_coupons` VALUES ('43', '5.8折商品通用券(邀请好友奖励3折优惠券)', '1', '0.58', '0.00', '0.00', '5.8折商品通用券(邀请好友奖励3折优惠券)', '1', '2020-07-08 00:00:00', '2020-07-31 00:00:00', '0', '1', '1', '2020-07-08 11:34:23', '2020-08-11 11:41:19');
INSERT INTO `tb_coupons` VALUES ('44', '夏日6折饮品畅饮券(邀请好友奖励3折优惠券)', '1', '0.60', '0.00', '0.00', '全场饮品专用(邀请好友奖励3折优惠券)', '1', '2020-07-17 00:00:00', '2020-07-31 00:00:00', '0', '1', '1', '2020-07-17 11:18:13', '2020-08-11 11:41:24');
INSERT INTO `tb_coupons` VALUES ('45', '3.8折单品餐饮券(邀请好友奖励3折优惠券)', '1', '0.38', '0.00', '0.00', '全场单品使用,邀请好友奖励3折优惠券哟', '2', null, null, '7', '1', '1', '2020-08-11 11:42:56', '2020-08-11 12:19:50');
INSERT INTO `tb_coupons` VALUES ('46', '4.8折畅饮券(邀请好友奖励3折优惠券)', '1', '0.48', '0.00', '0.00', '全场饮品4.8折(邀请好友奖励3折优惠券)', '2', null, null, '7', '0', '1', '2020-08-14 11:17:03', null);
INSERT INTO `tb_coupons` VALUES ('47', '5.5折畅饮券', '1', '0.55', '0.00', '0.00', '全场饮品通用(邀请好友奖励3折优惠券)', '2', null, null, '7', '0', '1', '2020-08-17 11:52:33', null);
INSERT INTO `tb_coupons` VALUES ('48', '6.8折畅饮券(邀请好友奖励3折优惠券)', '1', '0.68', '0.00', '0.00', '全场饮品使用(邀请好友奖励3折优惠券)', '2', null, null, '7', '0', '1', '2020-08-18 11:48:10', null);
INSERT INTO `tb_coupons` VALUES ('49', '新用户7折', '1', '0.70', '0.00', '0.00', '1', '1', '2020-10-07 00:00:00', '2020-10-31 00:00:00', '0', '1', '1', '2020-10-07 17:44:56', '2020-10-07 17:48:03');
INSERT INTO `tb_coupons` VALUES ('50', '新店入驻8折', '1', '0.80', '0.00', '0.00', '1', '1', '2020-10-14 00:00:00', '2020-10-31 00:00:00', '0', '1', '1', '2020-10-14 12:52:29', '2020-10-14 12:53:54');
INSERT INTO `tb_coupons` VALUES ('52', '白桃拿铁7折', '1', '0.70', '0.00', '0.00', '1', '1', '2020-10-14 00:00:00', '2020-10-31 00:00:00', '0', '0', '1', '2020-10-14 17:22:54', null);
INSERT INTO `tb_coupons` VALUES ('53', '会员专享折扣-8折', '1', '0.80', '0.00', '0.00', '会员专享折扣券,有效期1年内有效,仅外卖订单使用', '2', null, null, '365', '0', '2', '2021-02-22 10:23:32', '2021-02-22 10:25:31');
INSERT INTO `tb_coupons` VALUES ('54', '会员专享折扣-7折', '1', '0.70', '0.00', '0.00', '会员专享折扣券,有效期1年内有效,仅外卖订单使用', '2', null, null, '365', '0', '2', '2021-02-22 22:15:19', '2021-02-22 22:15:53');
INSERT INTO `tb_coupons` VALUES ('55', '会员专享折扣-9折', '1', '0.90', '0.00', '0.00', '会员专享折扣券,有效期1年内有效,仅外卖订单使用', '2', null, null, '365', '0', '2', '2021-02-22 22:16:27', null);
INSERT INTO `tb_coupons` VALUES ('56', '会员专享折扣-6折', '1', '0.60', '0.00', '0.00', '会员专享折扣券,有效期1年内有效,仅外卖订单使用', '2', null, null, '365', '0', '2', '2021-02-22 22:17:43', null);
INSERT INTO `tb_coupons` VALUES ('57', '会员专享折扣-5折', '1', '0.50', '0.00', '0.00', '会员专享折扣券,有效期1年内有效,仅外卖订单使用', '2', null, null, '365', '0', '2', '2021-02-22 22:22:25', null);
INSERT INTO `tb_coupons` VALUES ('58', '会员专享折扣-4折', '1', '0.40', '0.00', '0.00', '会员专享折扣券,有效期1年内有效,仅外卖订单使用', '2', null, null, '365', '1', '2', '2021-02-22 22:25:01', '2023-11-10 15:28:17');
INSERT INTO `tb_coupons` VALUES ('59', '奶茶季专享券', '1', '0.50', '0.00', '0.00', '外卖专用', '2', null, null, '7', '0', '2', '2021-07-02 12:06:57', null);
-- ----------------------------
-- Table structure for tb_coupons_goods_relation
-- ----------------------------
DROP TABLE IF EXISTS `tb_coupons_goods_relation`;
CREATE TABLE `tb_coupons_goods_relation` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`coupons_id` int(11) DEFAULT NULL COMMENT '优惠卷id',
`goods_id` int(11) DEFAULT NULL COMMENT '商品id',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1458 DEFAULT CHARSET=utf8 COMMENT='优惠卷使用规则对应的固定商品,如优惠卷用于‘美国拿铁’';
-- ----------------------------
-- Records of tb_coupons_goods_relation
-- ----------------------------
INSERT INTO `tb_coupons_goods_relation` VALUES ('206', '1', '28', '2020-05-05 17:30:04');
INSERT INTO `tb_coupons_goods_relation` VALUES ('207', '2', '28', '2020-05-05 17:30:04');
INSERT INTO `tb_coupons_goods_relation` VALUES ('210', '1', '33', '2020-05-05 17:30:04');
INSERT INTO `tb_coupons_goods_relation` VALUES ('211', '2', '33', '2020-05-05 17:30:05');
INSERT INTO `tb_coupons_goods_relation` VALUES ('212', '1', '38', '2020-05-05 17:30:05');
INSERT INTO `tb_coupons_goods_relation` VALUES ('213', '2', '38', '2020-05-05 17:30:05');
INSERT INTO `tb_coupons_goods_relation` VALUES ('214', '1', '39', '2020-05-05 17:30:05');
INSERT INTO `tb_coupons_goods_relation` VALUES ('215', '2', '39', '2020-05-05 17:30:05');
INSERT INTO `tb_coupons_goods_relation` VALUES ('216', '1', '41', '2020-05-05 17:30:05');
INSERT INTO `tb_coupons_goods_relation` VALUES ('217', '2', '41', '2020-05-05 17:30:05');
INSERT INTO `tb_coupons_goods_relation` VALUES ('222', '1', '45', '2020-05-10 17:50:44');
INSERT INTO `tb_coupons_goods_relation` VALUES ('223', '2', '45', '2020-05-10 17:50:44');
INSERT INTO `tb_coupons_goods_relation` VALUES ('224', '1', '46', '2020-05-10 17:58:42');
INSERT INTO `tb_coupons_goods_relation` VALUES ('225', '2', '46', '2020-05-10 17:58:42');
INSERT INTO `tb_coupons_goods_relation` VALUES ('226', '1', '47', '2020-05-10 18:23:24');
INSERT INTO `tb_coupons_goods_relation` VALUES ('227', '2', '47', '2020-05-10 18:23:24');
INSERT INTO `tb_coupons_goods_relation` VALUES ('228', '1', '48', '2020-05-10 18:40:11');
INSERT INTO `tb_coupons_goods_relation` VALUES ('229', '2', '48', '2020-05-10 18:40:11');
INSERT INTO `tb_coupons_goods_relation` VALUES ('230', '1', '49', '2020-05-10 23:53:19');
INSERT INTO `tb_coupons_goods_relation` VALUES ('231', '2', '49', '2020-05-10 23:53:19');
INSERT INTO `tb_coupons_goods_relation` VALUES ('234', '1', '51', '2020-05-11 00:13:56');
INSERT INTO `tb_coupons_goods_relation` VALUES ('235', '2', '51', '2020-05-11 00:13:56');
INSERT INTO `tb_coupons_goods_relation` VALUES ('236', '1', '52', '2020-05-11 12:22:42');
INSERT INTO `tb_coupons_goods_relation` VALUES ('237', '2', '52', '2020-05-11 12:22:42');
INSERT INTO `tb_coupons_goods_relation` VALUES ('238', '1', '53', '2020-05-11 12:39:35');
INSERT INTO `tb_coupons_goods_relation` VALUES ('239', '2', '53', '2020-05-11 12:39:35');
INSERT INTO `tb_coupons_goods_relation` VALUES ('244', '1', '56', '2020-05-12 11:13:42');
INSERT INTO `tb_coupons_goods_relation` VALUES ('245', '2', '56', '2020-05-12 11:13:42');
INSERT INTO `tb_coupons_goods_relation` VALUES ('246', '1', '57', '2020-05-12 17:52:48');
INSERT INTO `tb_coupons_goods_relation` VALUES ('247', '2', '57', '2020-05-12 17:52:48');
INSERT INTO `tb_coupons_goods_relation` VALUES ('248', '1', '58', '2020-05-13 10:23:23');
INSERT INTO `tb_coupons_goods_relation` VALUES ('249', '2', '58', '2020-05-13 10:23:23');
INSERT INTO `tb_coupons_goods_relation` VALUES ('250', '1', '59', '2020-05-13 10:40:30');
INSERT INTO `tb_coupons_goods_relation` VALUES ('251', '2', '59', '2020-05-13 10:40:30');
INSERT INTO `tb_coupons_goods_relation` VALUES ('252', '1', '60', '2020-05-13 11:58:38');
INSERT INTO `tb_coupons_goods_relation` VALUES ('253', '2', '60', '2020-05-13 11:58:38');
INSERT INTO `tb_coupons_goods_relation` VALUES ('317', '1', '61', '2020-05-13 13:07:36');
INSERT INTO `tb_coupons_goods_relation` VALUES ('318', '2', '61', '2020-05-13 13:07:36');
INSERT INTO `tb_coupons_goods_relation` VALUES ('363', '1', '62', '2020-05-15 14:38:01');
INSERT INTO `tb_coupons_goods_relation` VALUES ('364', '2', '62', '2020-05-15 14:38:01');
INSERT INTO `tb_coupons_goods_relation` VALUES ('365', '1', '63', '2020-05-15 14:51:29');
INSERT INTO `tb_coupons_goods_relation` VALUES ('366', '2', '63', '2020-05-15 14:51:29');
INSERT INTO `tb_coupons_goods_relation` VALUES ('367', '1', '64', '2020-05-15 14:55:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('368', '2', '64', '2020-05-15 14:55:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('369', '1', '65', '2020-05-15 14:58:19');
INSERT INTO `tb_coupons_goods_relation` VALUES ('370', '2', '65', '2020-05-15 14:58:19');
INSERT INTO `tb_coupons_goods_relation` VALUES ('396', '1', '66', '2020-05-17 11:36:34');
INSERT INTO `tb_coupons_goods_relation` VALUES ('397', '2', '66', '2020-05-17 11:36:34');
INSERT INTO `tb_coupons_goods_relation` VALUES ('450', '1', '67', '2020-05-20 14:39:21');
INSERT INTO `tb_coupons_goods_relation` VALUES ('451', '2', '67', '2020-05-20 14:39:21');
INSERT INTO `tb_coupons_goods_relation` VALUES ('452', '1', '68', '2020-05-20 14:46:25');
INSERT INTO `tb_coupons_goods_relation` VALUES ('453', '2', '68', '2020-05-20 14:46:25');
INSERT INTO `tb_coupons_goods_relation` VALUES ('510', '1', '69', '2020-05-23 14:31:48');
INSERT INTO `tb_coupons_goods_relation` VALUES ('511', '2', '69', '2020-05-23 14:31:48');
INSERT INTO `tb_coupons_goods_relation` VALUES ('541', '1', '70', '2020-05-25 16:40:04');
INSERT INTO `tb_coupons_goods_relation` VALUES ('542', '2', '70', '2020-05-25 16:40:04');
INSERT INTO `tb_coupons_goods_relation` VALUES ('573', '1', '71', '2020-05-28 21:42:50');
INSERT INTO `tb_coupons_goods_relation` VALUES ('574', '2', '71', '2020-05-28 21:42:50');
INSERT INTO `tb_coupons_goods_relation` VALUES ('575', '1', '72', '2020-05-29 12:15:52');
INSERT INTO `tb_coupons_goods_relation` VALUES ('576', '2', '72', '2020-05-29 12:15:52');
INSERT INTO `tb_coupons_goods_relation` VALUES ('607', '1', '73', '2020-06-01 15:16:31');
INSERT INTO `tb_coupons_goods_relation` VALUES ('608', '2', '73', '2020-06-01 15:16:31');
INSERT INTO `tb_coupons_goods_relation` VALUES ('640', '1', '74', '2020-06-05 10:15:19');
INSERT INTO `tb_coupons_goods_relation` VALUES ('641', '2', '74', '2020-06-05 10:15:19');
INSERT INTO `tb_coupons_goods_relation` VALUES ('706', '1', '75', '2020-06-15 14:33:36');
INSERT INTO `tb_coupons_goods_relation` VALUES ('707', '2', '75', '2020-06-15 14:33:36');
INSERT INTO `tb_coupons_goods_relation` VALUES ('741', '1', '76', '2020-06-17 13:44:00');
INSERT INTO `tb_coupons_goods_relation` VALUES ('742', '2', '76', '2020-06-17 13:44:00');
INSERT INTO `tb_coupons_goods_relation` VALUES ('743', '1', '77', '2020-06-17 14:21:44');
INSERT INTO `tb_coupons_goods_relation` VALUES ('744', '2', '77', '2020-06-17 14:21:44');
INSERT INTO `tb_coupons_goods_relation` VALUES ('780', '1', '78', '2020-06-17 19:19:51');
INSERT INTO `tb_coupons_goods_relation` VALUES ('781', '2', '78', '2020-06-17 19:19:51');
INSERT INTO `tb_coupons_goods_relation` VALUES ('856', '1', '80', '2020-06-22 13:29:57');
INSERT INTO `tb_coupons_goods_relation` VALUES ('857', '2', '80', '2020-06-22 13:29:57');
INSERT INTO `tb_coupons_goods_relation` VALUES ('895', '1', '81', '2020-07-01 14:01:44');
INSERT INTO `tb_coupons_goods_relation` VALUES ('896', '2', '81', '2020-07-01 14:01:44');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1011', '1', '82', '2020-08-04 09:02:54');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1012', '2', '82', '2020-08-04 09:02:54');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1130', '46', '82', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1131', '46', '81', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1132', '46', '80', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1133', '46', '78', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1134', '46', '77', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1135', '46', '76', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1136', '46', '75', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1137', '46', '74', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1138', '46', '73', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1139', '46', '72', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1140', '46', '71', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1141', '46', '70', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1142', '46', '69', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1143', '46', '68', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1144', '46', '67', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1145', '46', '66', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1146', '46', '65', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1147', '46', '64', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1148', '46', '63', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1149', '46', '62', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1150', '46', '61', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1151', '46', '60', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1152', '46', '59', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1153', '46', '58', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1154', '46', '57', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1155', '46', '56', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1156', '46', '53', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1157', '46', '52', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1158', '46', '51', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1159', '46', '49', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1160', '46', '48', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1161', '46', '47', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1162', '46', '46', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1163', '46', '45', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1164', '46', '41', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1165', '46', '39', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1166', '46', '38', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1167', '46', '33', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1168', '46', '28', '2020-08-16 15:10:06');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1169', '47', '82', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1170', '47', '81', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1171', '47', '80', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1172', '47', '78', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1173', '47', '77', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1174', '47', '76', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1175', '47', '75', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1176', '47', '74', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1177', '47', '73', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1178', '47', '72', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1179', '47', '71', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1180', '47', '70', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1181', '47', '69', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1182', '47', '68', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1183', '47', '67', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1184', '47', '66', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1185', '47', '65', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1186', '47', '64', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1187', '47', '63', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1188', '47', '62', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1189', '47', '61', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1190', '47', '60', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1191', '47', '59', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1192', '47', '58', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1193', '47', '57', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1194', '47', '56', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1195', '47', '53', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1196', '47', '52', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1197', '47', '51', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1198', '47', '49', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1199', '47', '48', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1200', '47', '47', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1201', '47', '46', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1202', '47', '45', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1203', '47', '41', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1204', '47', '39', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1205', '47', '38', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1206', '47', '33', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1207', '47', '28', '2020-08-17 11:52:41');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1208', '48', '82', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1209', '48', '81', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1210', '48', '80', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1211', '48', '78', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1212', '48', '77', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1213', '48', '76', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1214', '48', '75', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1215', '48', '74', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1216', '48', '73', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1217', '48', '72', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1218', '48', '71', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1219', '48', '70', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1220', '48', '69', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1221', '48', '68', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1222', '48', '67', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1223', '48', '66', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1224', '48', '65', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1225', '48', '64', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1226', '48', '63', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1227', '48', '62', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1228', '48', '61', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1229', '48', '60', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1230', '48', '59', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1231', '48', '58', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1232', '48', '57', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1233', '48', '56', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1234', '48', '53', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1235', '48', '52', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1236', '48', '51', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1237', '48', '49', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1238', '48', '48', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1239', '48', '47', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1240', '48', '46', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1241', '48', '45', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1242', '48', '41', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1243', '48', '39', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1244', '48', '38', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1245', '48', '33', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1246', '48', '28', '2020-08-18 11:48:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1409', '52', '185', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1410', '52', '184', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1411', '52', '183', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1412', '52', '182', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1413', '52', '181', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1414', '52', '180', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1415', '52', '179', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1416', '52', '178', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1417', '52', '177', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1418', '52', '176', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1419', '52', '175', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1420', '52', '174', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1421', '52', '173', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1422', '52', '172', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1423', '52', '171', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1424', '52', '170', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1425', '52', '169', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1426', '52', '168', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1427', '52', '167', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1428', '52', '166', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1429', '52', '165', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1430', '52', '164', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1431', '52', '163', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1432', '52', '162', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1433', '52', '161', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1434', '52', '160', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1435', '52', '159', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1436', '52', '158', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1437', '52', '157', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1438', '52', '156', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1439', '52', '155', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1440', '52', '154', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1441', '52', '153', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1442', '52', '152', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1443', '52', '151', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1444', '52', '150', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1445', '52', '149', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1446', '52', '148', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1447', '52', '147', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1448', '52', '146', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1449', '52', '145', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1450', '52', '144', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1451', '52', '143', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1452', '52', '142', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1453', '52', '141', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1454', '52', '140', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1455', '52', '139', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1456', '52', '138', '2020-10-14 17:23:16');
INSERT INTO `tb_coupons_goods_relation` VALUES ('1457', '52', '137', '2020-10-14 17:23:16');
-- ----------------------------
-- Table structure for tb_coupons_member_relation
-- ----------------------------
DROP TABLE IF EXISTS `tb_coupons_member_relation`;
CREATE TABLE `tb_coupons_member_relation` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`coupons_id` int(11) DEFAULT NULL COMMENT '优惠卷id',
`coupons_name` varchar(100) DEFAULT NULL COMMENT '优惠卷名称',
`member_id` int(11) DEFAULT NULL COMMENT '用户id',
`start_time` datetime DEFAULT NULL COMMENT '生效时间',
`end_time` datetime DEFAULT NULL COMMENT '过期时间',
`is_used` tinyint(1) DEFAULT '0' COMMENT '是否已经使用,0=未使用,1=已使用',
`is_expired` tinyint(1) DEFAULT '0' COMMENT '是否过期,0=未过期,1=已过期',
`is_valid` tinyint(1) DEFAULT '1' COMMENT '是否有效,0-否,1-是',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19598 DEFAULT CHARSET=utf8 COMMENT='优惠卷用户关联表';
-- ----------------------------
-- Records of tb_coupons_member_relation
-- ----------------------------
-- ----------------------------
-- Table structure for tb_coupons_shop_relation
-- ----------------------------
DROP TABLE IF EXISTS `tb_coupons_shop_relation`;
CREATE TABLE `tb_coupons_shop_relation` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`coupons_id` int(11) DEFAULT NULL COMMENT '优惠卷id',
`shop_id` int(11) DEFAULT NULL COMMENT '店铺id',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=168 DEFAULT CHARSET=utf8 COMMENT='优惠卷使用店铺范围,优惠卷和店铺关系表';
-- ----------------------------
-- Records of tb_coupons_shop_relation
-- ----------------------------
INSERT INTO `tb_coupons_shop_relation` VALUES ('50', '1', '13', '2020-09-15 17:05:56');
INSERT INTO `tb_coupons_shop_relation` VALUES ('51', '2', '13', '2020-09-15 17:05:56');
INSERT INTO `tb_coupons_shop_relation` VALUES ('52', '28', '13', '2020-09-16 00:06:22');
INSERT INTO `tb_coupons_shop_relation` VALUES ('53', '29', '13', '2020-09-16 00:06:22');
INSERT INTO `tb_coupons_shop_relation` VALUES ('54', '30', '13', '2020-09-16 00:06:23');
INSERT INTO `tb_coupons_shop_relation` VALUES ('55', '31', '13', '2020-09-16 00:06:23');
INSERT INTO `tb_coupons_shop_relation` VALUES ('56', '32', '13', '2020-09-16 00:06:23');
INSERT INTO `tb_coupons_shop_relation` VALUES ('57', '33', '13', '2020-09-16 00:06:23');
INSERT INTO `tb_coupons_shop_relation` VALUES ('58', '34', '13', '2020-09-16 00:06:23');
INSERT INTO `tb_coupons_shop_relation` VALUES ('59', '35', '13', '2020-09-16 00:06:24');
INSERT INTO `tb_coupons_shop_relation` VALUES ('60', '36', '13', '2020-09-16 00:06:24');
INSERT INTO `tb_coupons_shop_relation` VALUES ('61', '37', '13', '2020-09-16 00:06:24');
INSERT INTO `tb_coupons_shop_relation` VALUES ('62', '38', '13', '2020-09-16 00:06:24');
INSERT INTO `tb_coupons_shop_relation` VALUES ('63', '39', '13', '2020-09-16 00:06:24');
INSERT INTO `tb_coupons_shop_relation` VALUES ('64', '40', '13', '2020-09-16 00:06:24');
INSERT INTO `tb_coupons_shop_relation` VALUES ('65', '41', '13', '2020-09-16 00:06:25');
INSERT INTO `tb_coupons_shop_relation` VALUES ('66', '42', '13', '2020-09-16 00:06:25');
INSERT INTO `tb_coupons_shop_relation` VALUES ('67', '43', '13', '2020-09-16 00:06:25');
INSERT INTO `tb_coupons_shop_relation` VALUES ('68', '44', '13', '2020-09-16 00:06:25');
INSERT INTO `tb_coupons_shop_relation` VALUES ('69', '45', '13', '2020-09-16 00:06:25');
INSERT INTO `tb_coupons_shop_relation` VALUES ('70', '46', '13', '2020-09-16 00:06:25');
INSERT INTO `tb_coupons_shop_relation` VALUES ('71', '47', '13', '2020-09-16 00:06:26');
INSERT INTO `tb_coupons_shop_relation` VALUES ('72', '48', '13', '2020-09-16 00:06:26');
INSERT INTO `tb_coupons_shop_relation` VALUES ('73', '1', '14', '2020-09-16 16:57:03');
INSERT INTO `tb_coupons_shop_relation` VALUES ('74', '2', '14', '2020-09-16 16:57:04');
INSERT INTO `tb_coupons_shop_relation` VALUES ('75', '1', '15', '2020-09-22 22:11:51');
INSERT INTO `tb_coupons_shop_relation` VALUES ('76', '2', '15', '2020-09-22 22:11:51');
INSERT INTO `tb_coupons_shop_relation` VALUES ('77', '49', '15', '2020-10-07 17:44:56');
INSERT INTO `tb_coupons_shop_relation` VALUES ('78', '1', '16', '2020-10-08 16:19:37');
INSERT INTO `tb_coupons_shop_relation` VALUES ('79', '2', '16', '2020-10-08 16:19:37');
INSERT INTO `tb_coupons_shop_relation` VALUES ('80', '1', '17', '2020-10-09 10:02:53');
INSERT INTO `tb_coupons_shop_relation` VALUES ('81', '2', '17', '2020-10-09 10:02:53');
INSERT INTO `tb_coupons_shop_relation` VALUES ('82', '1', '18', '2020-10-11 19:04:31');
INSERT INTO `tb_coupons_shop_relation` VALUES ('83', '2', '18', '2020-10-11 19:04:31');
INSERT INTO `tb_coupons_shop_relation` VALUES ('84', '50', '15', '2020-10-14 12:52:29');
INSERT INTO `tb_coupons_shop_relation` VALUES ('85', '51', '18', '2020-10-14 16:44:49');
INSERT INTO `tb_coupons_shop_relation` VALUES ('86', '52', '16', '2020-10-14 17:22:54');
INSERT INTO `tb_coupons_shop_relation` VALUES ('87', '1', '19', '2021-02-21 14:57:02');
INSERT INTO `tb_coupons_shop_relation` VALUES ('88', '2', '19', '2021-02-21 14:57:02');
INSERT INTO `tb_coupons_shop_relation` VALUES ('96', '54', '13', '2021-02-22 22:15:19');
INSERT INTO `tb_coupons_shop_relation` VALUES ('97', '54', '14', '2021-02-22 22:15:19');
INSERT INTO `tb_coupons_shop_relation` VALUES ('98', '54', '15', '2021-02-22 22:15:19');
INSERT INTO `tb_coupons_shop_relation` VALUES ('99', '54', '16', '2021-02-22 22:15:19');
INSERT INTO `tb_coupons_shop_relation` VALUES ('100', '54', '17', '2021-02-22 22:15:19');
INSERT INTO `tb_coupons_shop_relation` VALUES ('101', '54', '18', '2021-02-22 22:15:19');
INSERT INTO `tb_coupons_shop_relation` VALUES ('102', '54', '19', '2021-02-22 22:15:19');
INSERT INTO `tb_coupons_shop_relation` VALUES ('103', '55', '13', '2021-02-22 22:16:27');
INSERT INTO `tb_coupons_shop_relation` VALUES ('104', '55', '14', '2021-02-22 22:16:27');
INSERT INTO `tb_coupons_shop_relation` VALUES ('105', '55', '15', '2021-02-22 22:16:27');
INSERT INTO `tb_coupons_shop_relation` VALUES ('106', '55', '16', '2021-02-22 22:16:27');
INSERT INTO `tb_coupons_shop_relation` VALUES ('107', '55', '17', '2021-02-22 22:16:27');
INSERT INTO `tb_coupons_shop_relation` VALUES ('108', '55', '18', '2021-02-22 22:16:27');
INSERT INTO `tb_coupons_shop_relation` VALUES ('109', '55', '19', '2021-02-22 22:16:27');
INSERT INTO `tb_coupons_shop_relation` VALUES ('110', '56', '13', '2021-02-22 22:17:43');
INSERT INTO `tb_coupons_shop_relation` VALUES ('111', '56', '14', '2021-02-22 22:17:43');
INSERT INTO `tb_coupons_shop_relation` VALUES ('112', '56', '15', '2021-02-22 22:17:43');
INSERT INTO `tb_coupons_shop_relation` VALUES ('113', '56', '16', '2021-02-22 22:17:43');
INSERT INTO `tb_coupons_shop_relation` VALUES ('114', '56', '17', '2021-02-22 22:17:43');
INSERT INTO `tb_coupons_shop_relation` VALUES ('115', '56', '18', '2021-02-22 22:17:43');
INSERT INTO `tb_coupons_shop_relation` VALUES ('116', '56', '19', '2021-02-22 22:17:43');
INSERT INTO `tb_coupons_shop_relation` VALUES ('117', '57', '13', '2021-02-22 22:22:25');
INSERT INTO `tb_coupons_shop_relation` VALUES ('118', '57', '14', '2021-02-22 22:22:25');
INSERT INTO `tb_coupons_shop_relation` VALUES ('119', '57', '15', '2021-02-22 22:22:25');
INSERT INTO `tb_coupons_shop_relation` VALUES ('120', '57', '16', '2021-02-22 22:22:25');
INSERT INTO `tb_coupons_shop_relation` VALUES ('121', '57', '17', '2021-02-22 22:22:25');
INSERT INTO `tb_coupons_shop_relation` VALUES ('122', '57', '18', '2021-02-22 22:22:25');
INSERT INTO `tb_coupons_shop_relation` VALUES ('123', '57', '19', '2021-02-22 22:22:25');
INSERT INTO `tb_coupons_shop_relation` VALUES ('124', '58', '13', '2021-02-22 22:25:01');
INSERT INTO `tb_coupons_shop_relation` VALUES ('125', '58', '14', '2021-02-22 22:25:01');
INSERT INTO `tb_coupons_shop_relation` VALUES ('126', '58', '15', '2021-02-22 22:25:01');
INSERT INTO `tb_coupons_shop_relation` VALUES ('127', '58', '16', '2021-02-22 22:25:01');
INSERT INTO `tb_coupons_shop_relation` VALUES ('128', '58', '17', '2021-02-22 22:25:01');
INSERT INTO `tb_coupons_shop_relation` VALUES ('129', '58', '18', '2021-02-22 22:25:01');
INSERT INTO `tb_coupons_shop_relation` VALUES ('130', '58', '19', '2021-02-22 22:25:01');
INSERT INTO `tb_coupons_shop_relation` VALUES ('138', '59', '13', '2021-07-02 12:07:07');
INSERT INTO `tb_coupons_shop_relation` VALUES ('139', '59', '14', '2021-07-02 12:07:07');
INSERT INTO `tb_coupons_shop_relation` VALUES ('140', '59', '15', '2021-07-02 12:07:07');
INSERT INTO `tb_coupons_shop_relation` VALUES ('141', '59', '16', '2021-07-02 12:07:07');
INSERT INTO `tb_coupons_shop_relation` VALUES ('142', '59', '17', '2021-07-02 12:07:07');
INSERT INTO `tb_coupons_shop_relation` VALUES ('143', '59', '18', '2021-07-02 12:07:07');
INSERT INTO `tb_coupons_shop_relation` VALUES ('144', '59', '19', '2021-07-02 12:07:07');
INSERT INTO `tb_coupons_shop_relation` VALUES ('145', '1', '34', '2021-10-21 14:52:18');
INSERT INTO `tb_coupons_shop_relation` VALUES ('146', '2', '34', '2021-10-21 14:52:36');
INSERT INTO `tb_coupons_shop_relation` VALUES ('147', '1', '35', '2021-10-21 16:06:41');
INSERT INTO `tb_coupons_shop_relation` VALUES ('148', '2', '35', '2021-10-21 16:06:44');
INSERT INTO `tb_coupons_shop_relation` VALUES ('149', '1', '36', '2021-10-21 16:44:23');
INSERT INTO `tb_coupons_shop_relation` VALUES ('150', '2', '36', '2021-10-21 16:44:24');
INSERT INTO `tb_coupons_shop_relation` VALUES ('151', '60', '13', '2023-11-10 15:28:09');
INSERT INTO `tb_coupons_shop_relation` VALUES ('152', '60', '14', '2023-11-10 15:28:09');
INSERT INTO `tb_coupons_shop_relation` VALUES ('153', '60', '15', '2023-11-10 15:28:09');
INSERT INTO `tb_coupons_shop_relation` VALUES ('154', '60', '16', '2023-11-10 15:28:09');
INSERT INTO `tb_coupons_shop_relation` VALUES ('155', '60', '17', '2023-11-10 15:28:09');
INSERT INTO `tb_coupons_shop_relation` VALUES ('156', '60', '18', '2023-11-10 15:28:09');
INSERT INTO `tb_coupons_shop_relation` VALUES ('157', '60', '19', '2023-11-10 15:28:09');
INSERT INTO `tb_coupons_shop_relation` VALUES ('158', '60', '34', '2023-11-10 15:28:09');
INSERT INTO `tb_coupons_shop_relation` VALUES ('159', '60', '35', '2023-11-10 15:28:09');
INSERT INTO `tb_coupons_shop_relation` VALUES ('160', '60', '36', '2023-11-10 15:28:09');
INSERT INTO `tb_coupons_shop_relation` VALUES ('161', '53', '13', '2023-11-10 17:13:08');
INSERT INTO `tb_coupons_shop_relation` VALUES ('162', '53', '14', '2023-11-10 17:13:08');
INSERT INTO `tb_coupons_shop_relation` VALUES ('163', '53', '15', '2023-11-10 17:13:08');
INSERT INTO `tb_coupons_shop_relation` VALUES ('164', '53', '16', '2023-11-10 17:13:08');
INSERT INTO `tb_coupons_shop_relation` VALUES ('165', '53', '17', '2023-11-10 17:13:08');
INSERT INTO `tb_coupons_shop_relation` VALUES ('166', '53', '18', '2023-11-10 17:13:08');
INSERT INTO `tb_coupons_shop_relation` VALUES ('167', '53', '19', '2023-11-10 17:13:08');
-- ----------------------------
-- Table structure for tb_courier
-- ----------------------------
DROP TABLE IF EXISTS `tb_courier`;
CREATE TABLE `tb_courier` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`shop_id` int(11) DEFAULT NULL COMMENT '店铺id',
`realname` varchar(100) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '真实姓名',
`phone` varchar(11) DEFAULT NULL COMMENT '联系电话',
`sex` int(1) DEFAULT '0' COMMENT '性别 0=无 1=男 2=女',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of tb_courier
-- ----------------------------
-- ----------------------------
-- Table structure for tb_delivery_address
-- ----------------------------
DROP TABLE IF EXISTS `tb_delivery_address`;
CREATE TABLE `tb_delivery_address` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`member_id` int(11) NOT NULL COMMENT '用户id',
`realname` varchar(100) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '联系人姓名',
`phone` varchar(11) DEFAULT NULL COMMENT '联系电话',
`province` varchar(20) DEFAULT NULL COMMENT '省份',
`city` varchar(20) DEFAULT NULL COMMENT '城市',
`area` varchar(100) DEFAULT NULL COMMENT '区/县',
`street` varchar(100) DEFAULT NULL COMMENT '详细地址',
`is_default` int(1) NOT NULL DEFAULT '0' COMMENT '是否默认收获地址 0=否 1=是',
`sex` int(1) DEFAULT '0' COMMENT '联系人性别 0=无 1=先生 2=女士',
`house_number` varchar(100) DEFAULT NULL COMMENT '门牌号',
`longitude` decimal(18,6) DEFAULT NULL COMMENT '经度',
`latitude` decimal(18,6) DEFAULT NULL COMMENT '纬度',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=612 DEFAULT CHARSET=utf8 COMMENT='收货地址表';
-- ----------------------------
-- Records of tb_delivery_address
-- ----------------------------
INSERT INTO `tb_delivery_address` VALUES ('603', '2', '暹罗', '13121865386', '湖南省', '长沙市', '岳麓区', '麓谷小镇', '1', '0', '', '112.885538', '28.232363', '2023-11-19 16:59:03', '2023-11-19 16:59:03');
-- ----------------------------
-- Table structure for tb_full_reduction_rule
-- ----------------------------
DROP TABLE IF EXISTS `tb_full_reduction_rule`;
CREATE TABLE `tb_full_reduction_rule` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`shop_id` int(11) DEFAULT NULL COMMENT '店铺id',
`name` varchar(100) DEFAULT NULL COMMENT '规则名称',
`status` int(11) DEFAULT NULL COMMENT '活动状态,1=开启,2=关闭',
`limited_price` decimal(10,2) DEFAULT '0.00' COMMENT '满足价格(元,满足该价格才能使用)',
`reduced_price` decimal(10,2) DEFAULT '0.00' COMMENT '减价额度(元)',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8 COMMENT='满减规则表';
-- ----------------------------
-- Records of tb_full_reduction_rule
-- ----------------------------
INSERT INTO `tb_full_reduction_rule` VALUES ('11', '13', '满19减5', '1', '19.00', '5.00', '2020-05-12 16:14:25', null);
INSERT INTO `tb_full_reduction_rule` VALUES ('12', '13', '满39减14', '1', '39.00', '14.00', '2020-05-12 16:14:41', null);
INSERT INTO `tb_full_reduction_rule` VALUES ('13', '13', '满9减2', '1', '9.00', '2.00', '2020-05-14 10:14:48', null);
INSERT INTO `tb_full_reduction_rule` VALUES ('29', '13', '满88减30', '1', '88.00', '30.00', '2020-07-06 13:48:12', null);
INSERT INTO `tb_full_reduction_rule` VALUES ('30', '13', '满168减66', '1', '168.00', '66.00', '2020-07-06 13:49:05', null);
INSERT INTO `tb_full_reduction_rule` VALUES ('33', '16', '25减5', '1', '25.00', '5.00', '2020-10-10 13:54:06', null);
INSERT INTO `tb_full_reduction_rule` VALUES ('34', '16', '38减10', '1', '38.00', '10.00', '2020-10-10 13:55:12', null);
INSERT INTO `tb_full_reduction_rule` VALUES ('35', '16', '69减20', '1', '69.00', '20.00', '2020-10-10 13:55:33', null);
INSERT INTO `tb_full_reduction_rule` VALUES ('36', '16', '128减38', '1', '128.00', '38.00', '2020-10-10 13:56:04', null);
INSERT INTO `tb_full_reduction_rule` VALUES ('37', '15', '25减4', '1', '25.00', '4.00', '2020-10-10 13:57:00', null);
INSERT INTO `tb_full_reduction_rule` VALUES ('38', '15', '49减9', '1', '49.00', '9.00', '2020-10-10 13:57:20', null);
INSERT INTO `tb_full_reduction_rule` VALUES ('39', '15', '88减20', '1', '88.00', '20.00', '2020-10-10 13:57:36', null);
INSERT INTO `tb_full_reduction_rule` VALUES ('40', '15', '168减39', '1', '168.00', '39.00', '2020-10-10 13:57:59', null);
INSERT INTO `tb_full_reduction_rule` VALUES ('51', '18', '满25减3', '1', '25.00', '3.00', '2021-07-01 22:00:10', null);
INSERT INTO `tb_full_reduction_rule` VALUES ('52', '18', '满38减8', '1', '38.00', '8.00', '2021-07-01 22:00:24', null);
INSERT INTO `tb_full_reduction_rule` VALUES ('53', '18', '满72减15', '1', '72.00', '15.00', '2021-07-01 22:01:04', null);
INSERT INTO `tb_full_reduction_rule` VALUES ('54', '18', '满109减25', '1', '109.00', '25.00', '2021-07-01 22:01:30', null);
-- ----------------------------
-- Table structure for tb_give_like
-- ----------------------------
DROP TABLE IF EXISTS `tb_give_like`;
CREATE TABLE `tb_give_like` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`member_id` int(11) DEFAULT NULL COMMENT '用户id',
`appraise_id` int(11) DEFAULT NULL COMMENT '评价id',
`reply_id` int(11) DEFAULT NULL COMMENT '回复id',
`type` int(1) NOT NULL DEFAULT '1' COMMENT '点赞类型 1-评价点赞,2-回复点赞',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='用户点赞表';
-- ----------------------------
-- Records of tb_give_like
-- ----------------------------
-- ----------------------------
-- Table structure for tb_goods
-- ----------------------------
DROP TABLE IF EXISTS `tb_goods`;
CREATE TABLE `tb_goods` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`shop_id` int(11) DEFAULT NULL COMMENT '店铺id',
`name` varchar(50) NOT NULL COMMENT '商品名称',
`main_image` varchar(128) DEFAULT NULL COMMENT '商品主图',
`sub_images` varchar(1024) DEFAULT NULL COMMENT '商品子图',
`detail` varchar(1024) DEFAULT NULL COMMENT '商品详情',
`detail_images` varchar(1024) DEFAULT NULL COMMENT '详情图片',
`price` decimal(10,2) DEFAULT '0.00' COMMENT '一口价',
`stock` int(11) DEFAULT '0' COMMENT '库存',
`is_hot` tinyint(1) DEFAULT '0' COMMENT '是否热门',
`is_new` tinyint(1) DEFAULT '0' COMMENT '是否新品',
`status` int(2) DEFAULT '1' COMMENT '状态 1=待上架 2=已上架 3=已下架 4=售罄',
`is_sale` tinyint(1) unsigned DEFAULT '0' COMMENT '是否开启促销 0-否 1-是',
`sale_price` decimal(10,2) DEFAULT '0.00' COMMENT '折扣价',
`monthly_sales` int(11) DEFAULT '0' COMMENT '月销量',
`total_sales` int(11) DEFAULT '0' COMMENT '累计销量',
`total_comments` int(11) DEFAULT '0' COMMENT '累计评价',
`preferential_name` varchar(20) DEFAULT NULL COMMENT '优惠名称',
`packing_charges` decimal(10,2) DEFAULT '0.00' COMMENT '包装费',
`product_time` decimal(10,2) DEFAULT '0.00' COMMENT '制作时长(分钟)',
`exchange_points` int(10) DEFAULT NULL COMMENT '兑换商品所需积分数量',
`sort_number` int(11) DEFAULT NULL COMMENT '排序号',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=281 DEFAULT CHARSET=utf8 COMMENT='商品表';
-- ----------------------------
-- Records of tb_goods
-- ----------------------------
INSERT INTO `tb_goods` VALUES ('28', '13', '布丁仙草', 'data/images/admin/1/deerspot_1591847965973.jpg', 'data/images/admin/1/deerspot_1591847965973.jpg', '一半都是料', 'data/images/admin/1/deerspot_1591847969280.jpg', '10.00', '-290', '0', '0', '2', '0', '10.00', '0', '637', '0', null, '1.00', '0.00', '6', null, '2020-03-23 11:04:57', '2020-06-17 20:37:32');
INSERT INTO `tb_goods` VALUES ('33', '13', '姜汁撞奶', 'data/images/admin/1/deerspot_1589253795582.jpg', 'data/images/admin/1/deerspot_1589253795582.jpg', '当生姜汁遇见牛奶会发生什么呢', 'data/images/admin/1/deerspot_1589253800285.jpg', '12.00', '-2159', '0', '0', '2', '0', '12.00', '0', '62', '0', null, '1.00', '0.00', '1', null, '2020-03-23 12:41:37', '2020-07-13 15:11:00');
INSERT INTO `tb_goods` VALUES ('38', '13', '柠檬汁', 'data/images/admin/1/deerspot_1590674515926.jpg', 'data/images/admin/1/deerspot_1590674515926.jpg', '口感酸甜,解渴必备', 'data/images/admin/1/deerspot_1590674522457.jpg', '5.00', '227', '0', '0', '2', '0', '5.00', '0', '96', '0', null, '1.00', '0.00', '1', null, '2020-03-24 12:31:28', '2020-05-29 00:20:22');
INSERT INTO `tb_goods` VALUES ('39', '13', '椰果奶茶', 'data/images/admin/1/deerspot_1591616215790.jpg', 'data/images/admin/1/deerspot_1591616215790.jpg', '不详', 'data/images/admin/1/deerspot_1591616221489.jpg', '7.00', '5', '0', '0', '2', '0', '7.00', '0', '217', '0', null, '1.00', '3.00', '12', null, '2020-03-24 12:42:12', '2020-06-08 19:37:03');
INSERT INTO `tb_goods` VALUES ('41', '13', '卡布基诺', 'data/images/admin/1/deerspot_1590563935696.jpg', 'data/images/admin/1/deerspot_1590563935696.jpg', '选用上等咖啡粉和牛奶调制,味香醇厚,', 'data/images/admin/1/deerspot_1590564060451.jpg', '10.00', '2', '0', '0', '2', '0', '10.00', '0', '81', '0', null, '1.00', '0.00', '10', null, '2020-04-05 00:15:13', '2020-05-27 15:21:03');
INSERT INTO `tb_goods` VALUES ('45', '13', '抹茶拿铁', 'data/images/admin/1/deerspot_1591705887087.jpg', 'data/images/admin/1/deerspot_1591705887087.jpg', '抹茶拿铁', 'data/images/admin/1/deerspot_1591705892837.jpg', '8.00', '6', '0', '0', '2', '0', '8.00', '0', '111', '0', null, '1.00', '3.00', '8', null, '2020-05-10 17:50:44', '2020-06-09 20:31:35');
INSERT INTO `tb_goods` VALUES ('46', '13', '金桔柠檬', 'data/images/admin/1/deerspot_1591604902009.jpg', 'data/images/admin/1/deerspot_1591604902009.jpg', '1', 'data/images/admin/1/deerspot_1591604912267.jpg', '9.00', '1', '0', '0', '2', '0', '9.00', '0', '101', '0', null, '1.00', '3.00', '9', null, '2020-05-10 17:58:42', '2020-06-08 16:28:36');
INSERT INTO `tb_goods` VALUES ('47', '13', '蜂蜜柚子', 'data/images/admin/1/deerspot_1591603513492.jpg', 'data/images/admin/1/deerspot_1591603513492.jpg', '蜂蜜柚子', 'data/images/admin/1/deerspot_1591603517951.jpg', '9.00', '2', '0', '0', '2', '0', '9.00', '0', '82', '0', null, '1.00', '3.00', '9', null, '2020-05-10 18:23:23', '2020-06-08 16:05:20');
INSERT INTO `tb_goods` VALUES ('48', '13', '芝士绿颜', 'data/images/admin/1/deerspot_1592548306115.jpg', 'data/images/admin/1/deerspot_1592548306115.jpg', '1', 'data/images/admin/1/deerspot_1592548310080.jpg', '12.00', '1', '0', '0', '2', '0', '12.00', '0', '33', '0', null, '1.00', '5.00', '12', null, '2020-05-10 18:40:11', '2020-06-21 19:24:12');
INSERT INTO `tb_goods` VALUES ('49', '13', '红豆奶茶', 'data/images/admin/1/deerspot_1591616292814.jpg', 'data/images/admin/1/deerspot_1591616292814.jpg', '1', 'data/images/admin/1/deerspot_1591616296803.jpg', '7.00', '3', '0', '0', '2', '0', '7.00', '0', '147', '0', null, '1.00', '3.00', '7', null, '2020-05-10 23:53:19', '2020-06-08 19:38:18');
INSERT INTO `tb_goods` VALUES ('51', '13', '黄金珍奶', 'data/images/admin/3/deerspot_1591719311481.jpg', 'data/images/admin/3/deerspot_1591719311481.jpg', 'Q弹软糯的口感', 'data/images/admin/3/deerspot_1591719314034.jpg', '8.00', '4', '0', '0', '2', '0', '8.00', '0', '246', '0', null, '1.00', '3.00', '8', null, '2020-05-11 00:13:55', '2020-06-10 00:15:16');
INSERT INTO `tb_goods` VALUES ('52', '13', '蓝色海洋', 'data/images/admin/1/deerspot_1591264167859.jpg', 'data/images/admin/1/deerspot_1591264167859.jpg', '1', 'data/images/admin/1/deerspot_1591264191442.jpg', '9.00', '1', '0', '0', '2', '0', '9.00', '0', '83', '0', null, '1.00', '3.00', '9', null, '2020-05-11 12:22:42', '2020-06-04 18:11:13');
INSERT INTO `tb_goods` VALUES ('53', '13', '薄荷苏打', 'data/images/admin/1/deerspot_1591264346926.jpg', 'data/images/admin/1/deerspot_1591264346926.jpg', '口感清新', 'data/images/admin/1/deerspot_1591264350213.jpg', '9.00', '1', '0', '0', '2', '0', '9.00', '0', '39', '0', null, '1.00', '3.00', '9', null, '2020-05-11 12:39:35', '2020-06-04 17:53:16');
INSERT INTO `tb_goods` VALUES ('56', '13', '布丁果冻', 'data/images/admin/3/deerspot_1591720158652.jpg', 'data/images/admin/3/deerspot_1591720158652.jpg', '1', 'data/images/admin/3/deerspot_1591720160926.jpg', '6.00', '0', '0', '0', '4', '0', '6.00', '0', '10', '0', null, '1.00', '3.00', '6', null, '2020-05-12 11:13:42', '2020-07-03 11:01:20');
INSERT INTO `tb_goods` VALUES ('57', '13', '芝士仙草', 'data/images/admin/1/deerspot_1590216480659.jpg', 'data/images/admin/1/deerspot_1590216480659.jpg', '芝士布丁仙草', 'data/images/admin/1/deerspot_1590216544440.jpg', '15.00', '3', '0', '0', '2', '0', '15.00', '0', '259', '0', null, '1.00', '2.00', '15', null, '2020-05-12 17:52:48', '2020-06-04 17:40:09');
INSERT INTO `tb_goods` VALUES ('58', '13', '黑糖小芋圆', 'data/images/admin/1/deerspot_1591622581910.jpg', 'data/images/admin/1/deerspot_1591622581910.jpg', '黑糖小芋圆', 'data/images/admin/1/deerspot_1591622587499.jpg', '10.00', '8', '0', '0', '2', '0', '10.00', '0', '89', '0', null, '1.00', '4.00', '8', null, '2020-05-13 10:23:23', '2020-07-18 14:39:50');
INSERT INTO `tb_goods` VALUES ('59', '13', '椰奶半杯料', 'data/images/admin/3/deerspot_1592749335669.jpg', 'data/images/admin/3/deerspot_1592749335669.jpg', '满满的椰奶香味,喝上半杯满足的味道,真正的零脂肪饮品', 'data/images/admin/3/deerspot_1592749340566.jpg', '10.00', '10', '0', '0', '2', '0', '10.00', '0', '53', '0', null, '1.00', '5.00', '12', null, '2020-05-13 10:40:30', '2020-07-03 18:35:38');
INSERT INTO `tb_goods` VALUES ('60', '13', '鲜果草莓汁', 'data/images/admin/1/deerspot_1590565521257.jpg', 'data/images/admin/1/deerspot_1590565521257.jpg', '浓浓的草莓味道', 'data/images/admin/1/deerspot_1590565528729.jpg', '10.00', '0', '0', '0', '2', '0', '10.00', '0', '44', '0', null, '1.00', '3.00', '10', null, '2020-05-13 11:58:38', '2020-05-27 15:45:49');
INSERT INTO `tb_goods` VALUES ('61', '13', '芝士很草', 'data/images/admin/3/deerspot_1590777231649.jpg', 'data/images/admin/3/deerspot_1590777231649.jpg', '芝士奶茶加上鲜果草莓的味道', 'data/images/admin/3/deerspot_1590777238880.jpg', '15.00', '4', '0', '0', '2', '0', '15.00', '0', '86', '0', null, '1.00', '3.00', '15', null, '2020-05-13 13:07:36', '2020-05-30 02:34:19');
INSERT INTO `tb_goods` VALUES ('62', '13', '鲜果芒果冰冰冻冻', 'data/images/admin/1/deerspot_1591623477034.jpg', 'data/images/admin/1/deerspot_1591623477034.jpg', '浓浓的芒果味道', 'data/images/admin/1/deerspot_1591623480295.jpg', '10.00', '3', '0', '0', '2', '0', '10.00', '0', '74', '0', null, '1.00', '3.00', '10', null, '2020-05-15 14:38:01', '2020-06-08 21:38:02');
INSERT INTO `tb_goods` VALUES ('63', '13', '满杯西瓜', 'data/images/admin/1/deerspot_1592726120158.jpg', 'data/images/admin/1/deerspot_1592726120158.jpg', '选择多汁甘甜西瓜600,杯底含有200g西瓜丁,满满的西瓜味道', 'data/images/admin/1/deerspot_1592726123613.jpg', '12.00', '0', '0', '0', '2', '0', '12.00', '0', '71', '0', null, '1.00', '1.00', '12', null, '2020-05-15 14:51:29', '2020-06-21 15:56:17');
INSERT INTO `tb_goods` VALUES ('64', '13', '鲜果草莓益菌多', 'data/images/admin/1/deerspot_1592548035563.jpg', 'data/images/admin/1/deerspot_1592548035563.jpg', '鲜果草莓益菌多', 'data/images/admin/1/deerspot_1592548073376.jpg', '13.00', '3', '0', '0', '2', '0', '13.00', '0', '138', '0', null, '1.00', '3.00', '10', null, '2020-05-15 14:55:06', '2020-07-15 17:33:09');
INSERT INTO `tb_goods` VALUES ('65', '13', '鲜果彩虹冰冰冻冻', 'data/images/admin/1/deerspot_1589525885573.jpg', 'data/images/admin/1/deerspot_1589525885573.jpg', '芒果 草莓', 'data/images/admin/1/deerspot_1589525896188.jpg', '12.00', '1', '0', '0', '3', '0', '12.00', '0', '16', '0', null, '1.00', '5.00', '12', null, '2020-05-15 14:58:18', '2020-06-21 14:50:06');
INSERT INTO `tb_goods` VALUES ('66', '13', '鲜果芒果益菌多', 'data/images/admin/1/deerspot_1591613166071.jpg', 'data/images/admin/1/deerspot_1591613166071.jpg', '鲜果芒果益菌多', 'data/images/admin/1/deerspot_1591613171654.jpg', '13.00', '3', '0', '0', '2', '0', '13.00', '0', '77', '0', null, '1.00', '3.00', '12', null, '2020-05-17 11:36:34', '2020-07-15 17:32:53');
INSERT INTO `tb_goods` VALUES ('67', '13', '鲜果草莓橙茉波波', 'data/images/admin/1/deerspot_1591605925025.jpg', 'data/images/admin/1/deerspot_1591605925025.jpg,data/images/admin/1/deerspot_1591605945344.jpg', '鲜果草莓橙茉波波', 'data/images/admin/1/deerspot_1591605929805.jpg', '14.00', '4', '0', '0', '2', '0', '14.00', '0', '288', '0', null, '1.00', '5.00', '14', null, '2020-05-20 14:39:21', '2020-06-21 11:32:32');
INSERT INTO `tb_goods` VALUES ('68', '13', '鲜果橙意满满', 'data/images/admin/1/deerspot_1591012263741.jpg', 'data/images/admin/1/deerspot_1591012263741.jpg', '一整颗橙子榨出来的灵魂', 'data/images/admin/1/deerspot_1591012270172.jpg', '12.00', '0', '0', '0', '3', '0', '12.00', '0', '38', '0', null, '1.00', '5.00', '12', null, '2020-05-20 14:46:25', '2020-07-06 13:56:51');
INSERT INTO `tb_goods` VALUES ('69', '13', '芝士很芒', 'data/images/admin/1/deerspot_1592547883421.jpg', 'data/images/admin/1/deerspot_1592547883421.jpg', '鲜芒果汁加上芝士奶盖', 'data/images/admin/1/deerspot_1592547886805.jpg', '15.00', '4', '0', '0', '2', '0', '15.00', '0', '246', '0', null, '1.00', '5.00', '15', null, '2020-05-23 14:31:48', '2020-06-19 14:24:48');
INSERT INTO `tb_goods` VALUES ('70', '13', '百香茉金水果茶', 'data/images/admin/1/deerspot_1591622107370.jpg', 'data/images/admin/1/deerspot_1591622107370.jpg', '西瓜 芒果 百香果 柠檬 金桔 香橙 茉莉绿茶', 'data/images/admin/1/deerspot_1591622110926.jpg', '18.00', '1', '0', '0', '2', '0', '18.00', '0', '56', '0', null, '1.00', '5.00', '18', null, '2020-05-25 16:40:04', '2020-07-02 11:24:16');
INSERT INTO `tb_goods` VALUES ('71', '13', '爆橙百香果', 'data/images/admin/1/deerspot_1590673364361.jpg', 'data/images/admin/1/deerspot_1590673364361.jpg', '口感酸甜,浓缩百香果精华', 'data/images/admin/1/deerspot_1590673367816.jpg', '13.00', '0', '0', '0', '3', '0', '13.00', '0', '10', '0', null, '1.00', '5.00', '13', null, '2020-05-28 21:42:50', '2020-07-03 16:07:53');
INSERT INTO `tb_goods` VALUES ('72', '13', '绿野仙踪', 'data/images/admin/1/deerspot_1591264022633.jpg', 'data/images/admin/1/deerspot_1591264022633.jpg', '青苹果的酸甜口感', 'data/images/admin/1/deerspot_1591264026456.jpg', '9.00', '0', '0', '0', '2', '0', '9.00', '0', '11', '0', null, '1.00', '3.00', '9', null, '2020-05-29 12:15:52', '2020-06-21 19:23:26');
INSERT INTO `tb_goods` VALUES ('73', '13', '芝士桃桃', 'data/images/admin/1/deerspot_1590995783575.jpg', 'data/images/admin/1/deerspot_1590995783575.jpg', '鲜果水蜜桃用茉莉花香绿茶榨汁萃取后加上一点奶盖,口感酸甜', 'data/images/admin/1/deerspot_1590995788964.jpg', '16.00', '90', '0', '0', '2', '0', '16.00', '0', '353', '0', null, '1.00', '5.00', '16', null, '2020-06-01 15:16:30', '2020-06-29 14:16:49');
INSERT INTO `tb_goods` VALUES ('74', '13', '西瓜椰椰', 'data/images/admin/1/deerspot_1591861930820.jpg', 'data/images/admin/1/deerspot_1591861930820.jpg', '鲜果西瓜与椰奶的融合,口感清甜,加上椰果的嚼劲,解暑必备', 'data/images/admin/1/deerspot_1591861934566.jpg', '12.00', '6', '0', '0', '2', '0', '12.00', '0', '519', '0', null, '1.00', '3.00', '12', null, '2020-06-05 10:15:19', '2020-06-17 10:59:57');
INSERT INTO `tb_goods` VALUES ('75', '13', '⭐ ⭐ ⭐ ⭐', 'data/images/admin/1/deerspot_1592202810151.jpg', 'data/images/admin/1/deerspot_1592202810151.jpg', '一颗橙子的霸气', 'data/images/admin/1/deerspot_1592202814877.jpg', '14.00', '2', '0', '0', '3', '0', '14.00', '0', '20', '0', null, '1.00', '4.00', '14', null, '2020-06-15 14:33:36', '2020-09-09 23:32:14');
INSERT INTO `tb_goods` VALUES ('76', '13', '百香果芒果', 'data/images/admin/1/deerspot_1592372635018.jpg', 'data/images/admin/1/deerspot_1592372635018.jpg', '鲜芒果和百香果的交合', 'data/images/admin/1/deerspot_1592372638898.jpg', '14.00', '2', '0', '0', '2', '0', '14.00', '0', '37', '0', null, '1.00', '5.00', '14', null, '2020-06-17 13:44:00', '2020-06-17 13:44:00');
INSERT INTO `tb_goods` VALUES ('77', '13', '柠檬益菌多', 'data/images/admin/1/deerspot_1592374898933.jpg', 'data/images/admin/1/deerspot_1592374898933.jpg', '柠檬的酸的口感', 'data/images/admin/1/deerspot_1592374902583.jpg', '12.00', '1', '0', '0', '2', '0', '12.00', '0', '30', '0', null, '1.00', '5.00', '13', null, '2020-06-17 14:21:44', '2020-07-15 17:32:38');
INSERT INTO `tb_goods` VALUES ('78', '13', '牛芒', 'data/images/admin/1/deerspot_1592392781920.jpg', 'data/images/admin/1/deerspot_1592392781920.jpg', '醇香芒果肉加上脱脂纯牛奶', 'data/images/admin/1/deerspot_1592392785923.jpg', '15.00', '122', '0', '0', '2', '0', '15.00', '0', '888', '0', null, '1.00', '5.00', '15', null, '2020-06-17 19:19:51', '2020-08-04 09:03:54');
INSERT INTO `tb_goods` VALUES ('80', '13', '多肉葡萄', 'data/images/admin/1/deerspot_1592803789993.jpg', 'data/images/admin/1/deerspot_1592803789993.jpg', '选用优质的葡萄原料榨汁,不含任何果酱,鲜果鲜汁', 'data/images/admin/1/deerspot_1592803793702.jpg', '14.00', '0', '0', '0', '3', '0', '14.00', '0', '3', '0', null, '1.00', '5.00', '14', null, '2020-06-22 13:29:57', '2020-07-07 00:13:28');
INSERT INTO `tb_goods` VALUES ('81', '13', '百香果双响炮', 'data/images/admin/1/deerspot_1593583283106.jpg', 'data/images/admin/1/deerspot_1593583283106.jpg,data/images/admin/1/deerspot_1593583302764.jpg', '珍珠和椰果做底料,百香果和绿茶酸甜的口感', 'data/images/admin/1/deerspot_1593583288044.jpg', '14.00', '5', '0', '0', '2', '0', '14.00', '0', '37', '0', null, '1.00', '5.00', '14', null, '2020-07-01 14:01:44', '2020-08-04 09:03:35');
INSERT INTO `tb_goods` VALUES ('82', '13', '奥利奥芝士草莓牛奶', 'data/images/admin/1/deerspot_1596502968273.jpg', 'data/images/admin/1/deerspot_1596502968273.jpg', '牛奶与草莓融合而成的碎冰,盖上一层芝士味道奶盖,撒上奥利奥饼干碎', 'data/images/admin/1/deerspot_1596502971936.jpg', '16.00', '7', '0', '0', '2', '0', '16.00', '0', '204', '0', null, '1.00', '5.00', '16', null, '2020-08-04 09:02:54', '2020-08-04 09:02:54');
INSERT INTO `tb_goods` VALUES ('83', '15', '招牌杨枝甘露(喝前均匀摇一摇)', 'data/images/merchant/20/deerspot_1600790057478.jpg', 'data/images/merchant/20/deerspot_1600790057478.jpg', '当热带芒果混入美味西米喝清新野果\n色彩如织布明霞\n亮澄露中分雪白\n闻之醉而不迷\n饮之纯而不腻', null, '18.90', '0', '0', '0', '2', '0', '0.00', '0', '14', '0', null, '1.00', '0.00', '20', null, '2020-09-22 23:54:20', '2020-10-14 14:37:23');
INSERT INTO `tb_goods` VALUES ('84', '15', '蓝色妖姬(喝前摇一摇)', 'data/images/merchant/20/deerspot_1600790697172.jpg', 'data/images/merchant/20/deerspot_1600790697172.jpg', '爆款蓝色妖姬,清凉又解渴,0糖分添加,美丽容颜纤身佳品,非碳酸饮料哦,怎么喝都不会打隔,到店点的客户非常多', null, '15.00', '0', '0', '0', '2', '0', '0.00', '0', '12', '0', null, '1.00', '0.00', '15', null, '2020-09-23 00:05:00', '2020-09-23 00:05:00');
INSERT INTO `tb_goods` VALUES ('85', '15', '泰式奥利奥蛋糕奶茶', 'data/images/merchant/20/deerspot_1600791458616.jpg', 'data/images/merchant/20/deerspot_1600791458616.jpg', '41%精选新西兰进口脱脂淡奶\n59%斯里兰卡阿萨姆\n浓情鲜奶\n分享给最亲爱的人\n展现自己的小仙女娇气', null, '17.00', '0', '0', '0', '2', '0', '0.00', '0', '2', '0', null, '1.00', '0.00', '17', null, '2020-09-23 00:17:40', '2020-09-23 00:17:40');
INSERT INTO `tb_goods` VALUES ('86', '15', '金桔柠檬', 'data/images/merchant/20/deerspot_1600792148443.jpg', 'data/images/merchant/20/deerspot_1600792148443.jpg', '金桔是刚刚好的甜度\n柠檬是调试好的酸度\n加冰凝固是这一刻的口感\n在冰块还没融化时品尝最佳', null, '14.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '14', null, '2020-09-23 00:29:18', '2020-09-23 00:29:31');
INSERT INTO `tb_goods` VALUES ('87', '15', '鲜果芒果奶昔', 'data/images/merchant/20/deerspot_1600792655135.jpg', 'data/images/merchant/20/deerspot_1600792655135.jpg', '果酱酿玉露,只需轻轻一口,\n便被深深的迷住~', null, '16.00', '0', '0', '0', '2', '0', '0.00', '0', '3', '0', null, '1.00', '0.00', '16', null, '2020-09-23 00:37:37', '2020-09-23 00:37:37');
INSERT INTO `tb_goods` VALUES ('88', '15', '粉红佳人(喝前摇一摇)', 'data/images/merchant/20/deerspot_1600792955123.jpg', 'data/images/merchant/20/deerspot_1600792955123.jpg', '超高的颜值和口感', null, '15.00', '0', '0', '0', '2', '0', '0.00', '0', '1', '0', null, '1.00', '0.00', '15', null, '2020-09-23 00:42:36', '2020-09-23 00:43:45');
INSERT INTO `tb_goods` VALUES ('89', '15', '草莓奶昔', 'data/images/merchant/20/deerspot_1600819761094.jpg', 'data/images/merchant/20/deerspot_1600819761094.jpg', '果酱琼浆玉露,只需轻轻一口,就会被深深的爱上~', null, '15.00', '0', '0', '0', '2', '0', '0.00', '0', '3', '0', null, '1.00', '0.00', '15', null, '2020-09-23 08:09:23', '2020-09-23 08:09:23');
INSERT INTO `tb_goods` VALUES ('90', '15', '可可奶昔', 'data/images/merchant/20/deerspot_1600916461441.jpg', 'data/images/merchant/20/deerspot_1600916461441.jpg', '果酱酿玉露,只需轻轻一口,便被深深迷住~', null, '16.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '16', null, '2020-09-24 11:01:03', '2020-09-24 11:01:03');
INSERT INTO `tb_goods` VALUES ('91', '15', '妃子笑芝芝', 'data/images/merchant/20/deerspot_1600917065360.jpg', 'data/images/merchant/20/deerspot_1600917065360.jpg', '满满的红心火龙果肉,与奶盖的融合,颜值超级棒!', null, '18.90', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '20', null, '2020-09-24 11:11:08', '2020-10-14 14:38:36');
INSERT INTO `tb_goods` VALUES ('92', '15', '草莓芝芝', 'data/images/merchant/20/deerspot_1601048139177.jpg', 'data/images/merchant/20/deerspot_1601048139177.jpg', '草莓', null, '18.90', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '20', null, '2020-09-25 23:35:40', '2020-10-14 14:38:02');
INSERT INTO `tb_goods` VALUES ('93', '15', '小淘气', 'data/images/merchant/20/deerspot_1602223917034.jpg', 'data/images/merchant/20/deerspot_1602223917034.jpg', '小桃气选用优质水蜜桃,浓浓的水蜜桃味道,搭配奶盖一起喝味道更好哟', null, '18.90', '0', '0', '0', '2', '0', '0.00', '0', '2', '0', null, '1.00', '0.00', '20', null, '2020-09-25 23:45:54', '2020-10-14 13:24:07');
INSERT INTO `tb_goods` VALUES ('94', '15', '芒芒芝士', 'data/images/merchant/20/deerspot_1601049012745.jpg', 'data/images/merchant/20/deerspot_1601049012745.jpg', '选用优质小台芒制成沙冰,口感细腻,芒果控的福音!', null, '18.90', '0', '0', '0', '2', '0', '0.00', '0', '1', '0', null, '1.00', '0.00', '20', null, '2020-09-25 23:50:14', '2020-10-23 18:39:01');
INSERT INTO `tb_goods` VALUES ('95', '15', '凤梨泡泡柚(喝前摇一摇)', 'data/images/merchant/20/deerspot_1601050220627.jpg', 'data/images/merchant/20/deerspot_1601050220627.jpg', '盛锦的重妍\n华丽的收稍\n凤梨和红柚\n最终粉碎在明媚的通透里\n捧在手心\n凝为香甜', null, '15.00', '0', '0', '0', '2', '0', '0.00', '0', '1', '0', null, '15.00', '0.00', '15', null, '2020-09-26 00:10:22', '2020-09-26 00:10:22');
INSERT INTO `tb_goods` VALUES ('96', '15', '小气红西柚', 'data/images/merchant/20/deerspot_1601050533950.jpg', 'data/images/merchant/20/deerspot_1601050533950.jpg', '偶尔也需要一杯小气茶来降温\n晶莹剔透的碎冰里,加满橘色的红西柚\n清新的色调,让人想起记忆中蝉鸣不止的夏天\n一秒平静的内心,带来丝丝的凉意', null, '14.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '14', null, '2020-09-26 00:15:35', '2020-10-07 16:57:30');
INSERT INTO `tb_goods` VALUES ('97', '15', '鸡柳', 'data/images/merchant/20/deerspot_1601050850619.jpg', 'data/images/merchant/20/deerspot_1601050850619.jpg', '口感酥脆,好吃到停不下来', null, '12.00', '0', '0', '0', '3', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '12', null, '2020-09-26 00:20:52', '2020-10-14 14:28:39');
INSERT INTO `tb_goods` VALUES ('98', '15', '鸡米花', 'data/images/merchant/20/deerspot_1601051047475.jpg', 'data/images/merchant/20/deerspot_1601051047475.jpg,data/images/merchant/20/deerspot_1601051054900.jpg', '口感酥脆,好吃到停不下来', null, '10.00', '0', '0', '0', '4', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '10', null, '2020-09-26 00:24:20', '2020-10-14 14:28:30');
INSERT INTO `tb_goods` VALUES ('99', '15', '鱿米花', 'data/images/merchant/20/deerspot_1601051217303.jpg', 'data/images/merchant/20/deerspot_1601051217303.jpg', '口感酥脆,好吃到停不下来', null, '10.00', '0', '0', '0', '4', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '10', null, '2020-09-26 00:27:19', '2020-10-14 14:28:19');
INSERT INTO `tb_goods` VALUES ('100', '15', '蓝颜知己', 'data/images/merchant/20/deerspot_1602063645167.png', 'data/images/merchant/20/deerspot_1602063645167.png', '1', null, '16.00', '0', '0', '0', '2', '0', '0.00', '0', '9', '0', null, '1.00', '0.00', '16', null, '2020-10-07 17:40:56', '2020-10-07 17:40:56');
INSERT INTO `tb_goods` VALUES ('101', '15', '茉莉奶绿', 'data/images/merchant/20/deerspot_1602122388382.jpg', 'data/images/merchant/20/deerspot_1602122388382.jpg', '牛奶、红茶', null, '10.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '10', null, '2020-10-08 09:59:50', '2020-10-08 09:59:50');
INSERT INTO `tb_goods` VALUES ('102', '15', '奶霜治愈抹茶', 'data/images/merchant/20/deerspot_1602122561273.jpg', 'data/images/merchant/20/deerspot_1602122561273.jpg', '芝士、抹茶', null, '16.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '16', null, '2020-10-08 10:02:43', '2020-10-08 10:02:43');
INSERT INTO `tb_goods` VALUES ('103', '15', '治愈奶霜可可', 'data/images/merchant/20/deerspot_1602122673636.jpg', 'data/images/merchant/20/deerspot_1602122673636.jpg', '可可、芝士', null, '16.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '16', null, '2020-10-08 10:04:35', '2020-10-08 10:04:35');
INSERT INTO `tb_goods` VALUES ('104', '15', '抹茶三兄弟', 'data/images/merchant/20/deerspot_1602122787090.jpg', 'data/images/merchant/20/deerspot_1602122787090.jpg', '芋圆、红豆', null, '14.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '14', null, '2020-10-08 10:06:28', '2020-10-08 10:06:28');
INSERT INTO `tb_goods` VALUES ('105', '15', '治愈抹茶', 'data/images/merchant/20/deerspot_1602122901246.jpg', 'data/images/merchant/20/deerspot_1602122901246.jpg', '简约的几何,原始的色调', null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '12', null, '2020-10-08 10:08:22', '2020-10-08 10:08:22');
INSERT INTO `tb_goods` VALUES ('106', '15', '蜜桃乌龙', 'data/images/merchant/20/deerspot_1602123012605.jpg', 'data/images/merchant/20/deerspot_1602123012605.jpg', '独特的茶香气味', null, '10.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '10', null, '2020-10-08 10:10:14', '2020-10-08 10:10:14');
INSERT INTO `tb_goods` VALUES ('107', '15', '玫瑰乌龙', 'data/images/merchant/20/deerspot_1602123129857.jpg', 'data/images/merchant/20/deerspot_1602123129857.jpg', '纯粹茶香', null, '10.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '10.00', '0.00', '10', null, '2020-10-08 10:12:11', '2020-10-08 10:12:11');
INSERT INTO `tb_goods` VALUES ('108', '15', '桂花乌龙', 'data/images/merchant/20/deerspot_1602123180115.jpg', 'data/images/merchant/20/deerspot_1602123180115.jpg', '纯粹茶香', null, '10.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '10', null, '2020-10-08 10:13:13', '2020-10-08 10:13:13');
INSERT INTO `tb_goods` VALUES ('109', '15', '阿里山四季春', 'data/images/merchant/20/deerspot_1602123305716.jpg', 'data/images/merchant/20/deerspot_1602123305716.jpg', '纯粹茶香', null, '8.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '8', null, '2020-10-08 10:15:07', '2020-10-08 10:15:07');
INSERT INTO `tb_goods` VALUES ('110', '15', '九印茉莉', 'data/images/merchant/20/deerspot_1602123467126.jpg', 'data/images/merchant/20/deerspot_1602123467126.jpg', '特选九印茉莉使用100°纯净开水冲泡', null, '8.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '8', null, '2020-10-08 10:17:48', '2020-10-08 10:18:01');
INSERT INTO `tb_goods` VALUES ('111', '15', '蜜桃芝士奶霜', 'data/images/merchant/20/deerspot_1602123633454.jpg', 'data/images/merchant/20/deerspot_1602123633454.jpg', '蜜桃乌龙茶汤、芝士', null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '12', null, '2020-10-08 10:20:55', '2020-10-08 10:20:55');
INSERT INTO `tb_goods` VALUES ('112', '15', '玫瑰芝士奶霜', 'data/images/merchant/20/deerspot_1602123913432.jpg', 'data/images/merchant/20/deerspot_1602123913432.jpg', '芝士、玫瑰茶汤', null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '12', null, '2020-10-08 10:25:15', '2020-10-08 10:25:15');
INSERT INTO `tb_goods` VALUES ('113', '15', '四季春芝士奶霜', 'data/images/merchant/20/deerspot_1602124041203.jpg', 'data/images/merchant/20/deerspot_1602124041203.jpg', '四季春茶', null, '10.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '10', null, '2020-10-08 10:27:22', '2020-10-08 10:27:22');
INSERT INTO `tb_goods` VALUES ('114', '15', '桂花芝士奶霜', 'data/images/merchant/20/deerspot_1602124196624.jpg', 'data/images/merchant/20/deerspot_1602124196624.jpg', '桂花茶汤', null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '12', null, '2020-10-08 10:29:58', '2020-10-08 10:29:58');
INSERT INTO `tb_goods` VALUES ('115', '15', '抹茶奶昔', 'data/images/merchant/20/deerspot_1602124429775.jpg', 'data/images/merchant/20/deerspot_1602124429775.jpg', '牛奶', null, '16.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '16', null, '2020-10-08 10:33:51', '2020-10-08 10:33:51');
INSERT INTO `tb_goods` VALUES ('116', '15', '可可奶昔', 'data/images/merchant/20/deerspot_1602124532669.jpg', 'data/images/merchant/20/deerspot_1602124532669.jpg', '芝士、、可可', null, '16.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '16', null, '2020-10-08 10:35:34', '2020-10-08 10:35:34');
INSERT INTO `tb_goods` VALUES ('117', '15', '红柚奶昔', 'data/images/merchant/20/deerspot_1602124673923.jpg', 'data/images/merchant/20/deerspot_1602124673923.jpg', '红柚、芝士', null, '16.00', '0', '0', '0', '2', '0', '0.00', '0', '1', '0', null, '1.00', '0.00', '16', null, '2020-10-08 10:37:55', '2020-10-08 10:37:55');
INSERT INTO `tb_goods` VALUES ('118', '15', '凤梨奶昔', 'data/images/merchant/20/deerspot_1602124830567.jpg', 'data/images/merchant/20/deerspot_1602124830567.jpg', '凤梨、芝士', null, '16.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '16', null, '2020-10-08 10:40:32', '2020-10-08 10:40:32');
INSERT INTO `tb_goods` VALUES ('119', '15', '双拼奶茶', 'data/images/merchant/20/deerspot_1602125224526.jpg', 'data/images/merchant/20/deerspot_1602125224526.jpg', '红豆', null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '2', '0', null, '1.00', '0.00', '12', null, '2020-10-08 10:47:10', '2020-10-08 10:47:10');
INSERT INTO `tb_goods` VALUES ('120', '15', '烧仙草奶茶', 'data/images/merchant/20/deerspot_1602125416032.jpg', 'data/images/merchant/20/deerspot_1602125416032.jpg', '仙草冻、花生碎、葡萄、红豆、野果', null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '1', '0', null, '1.00', '0.00', '12', null, '2020-10-08 10:50:17', '2020-10-08 10:50:17');
INSERT INTO `tb_goods` VALUES ('121', '15', '黑糖珍珠奶茶', 'data/images/merchant/20/deerspot_1602125650972.jpg', 'data/images/merchant/20/deerspot_1602125650972.jpg', '红茶、黑糖、珍珠', null, '10.00', '0', '0', '0', '2', '0', '0.00', '0', '3', '0', null, '1.00', '0.00', '10', null, '2020-10-08 10:54:13', '2020-10-08 10:54:13');
INSERT INTO `tb_goods` VALUES ('122', '15', '红豆奶茶', 'data/images/merchant/20/deerspot_1602125764570.jpg', 'data/images/merchant/20/deerspot_1602125764570.jpg', '红豆、牛奶', null, '10.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '10', null, '2020-10-08 10:56:06', '2020-10-08 10:56:06');
INSERT INTO `tb_goods` VALUES ('123', '15', '布丁奶茶', 'data/images/merchant/20/deerspot_1602125891667.jpg', 'data/images/merchant/20/deerspot_1602125891667.jpg', '布丁、红茶', null, '10.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '10', null, '2020-10-08 10:58:13', '2020-10-08 10:58:13');
INSERT INTO `tb_goods` VALUES ('124', '15', '椰果奶茶', 'data/images/merchant/20/deerspot_1602126013964.jpg', 'data/images/merchant/20/deerspot_1602126013964.jpg', '野果、奶茶', null, '10.00', '0', '0', '0', '2', '0', '0.00', '0', '1', '0', null, '1.00', '0.00', '10', null, '2020-10-08 11:00:16', '2020-10-09 15:47:04');
INSERT INTO `tb_goods` VALUES ('125', '15', '原味奶茶', 'data/images/merchant/20/deerspot_1602126072764.jpg', 'data/images/merchant/20/deerspot_1602126072764.jpg', '红茶', null, '8.00', '0', '0', '0', '2', '0', '0.00', '0', '4', '0', null, '1.00', '0.00', '8', null, '2020-10-08 11:01:14', '2020-10-08 11:01:14');
INSERT INTO `tb_goods` VALUES ('126', '15', '四季奶青', 'data/images/merchant/20/deerspot_1602126212777.jpg', 'data/images/merchant/20/deerspot_1602126212777.jpg', '牛奶、红茶', null, '10.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '10', null, '2020-10-08 11:03:34', '2020-10-08 11:03:41');
INSERT INTO `tb_goods` VALUES ('127', '15', '泰式椰子水', 'data/images/merchant/20/deerspot_1602126749503.jpg', 'data/images/merchant/20/deerspot_1602126749503.jpg', '牛奶', null, '17.00', '0', '0', '0', '2', '0', '0.00', '0', '12', '0', null, '1.00', '0.00', '17', null, '2020-10-08 11:12:31', '2020-10-08 11:12:31');
INSERT INTO `tb_goods` VALUES ('128', '15', '百香果双响炮', 'data/images/merchant/20/deerspot_1602126856452.jpg', 'data/images/merchant/20/deerspot_1602126856452.jpg', '百香果、芋圆', null, '13.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '13', null, '2020-10-08 11:14:22', '2020-10-08 11:14:22');
INSERT INTO `tb_goods` VALUES ('129', '15', '葡萄柚绿茶', 'data/images/merchant/20/deerspot_1602127095763.jpg', 'data/images/merchant/20/deerspot_1602127095763.jpg', '绿茶、西柚', null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '12', null, '2020-10-08 11:18:18', '2020-10-08 11:18:18');
INSERT INTO `tb_goods` VALUES ('130', '15', '凤梨小清新', 'data/images/merchant/20/deerspot_1602127224855.jpg', 'data/images/merchant/20/deerspot_1602127224855.jpg', '凤梨、茉莉茶汤', null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '12', null, '2020-10-08 11:20:27', '2020-10-08 11:20:27');
INSERT INTO `tb_goods` VALUES ('131', '15', '小气百香果', 'data/images/merchant/20/deerspot_1602127589572.jpg', 'data/images/merchant/20/deerspot_1602127589572.jpg', '百香果、青柠檬', null, '13.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '13', null, '2020-10-08 11:26:32', '2020-10-08 11:26:32');
INSERT INTO `tb_goods` VALUES ('132', '15', '女朋友益菌多', 'data/images/merchant/20/deerspot_1602128147756.jpg', 'data/images/merchant/20/deerspot_1602128147756.jpg', '西柚', null, '17.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '17', null, '2020-10-08 11:32:38', '2020-10-08 11:35:52');
INSERT INTO `tb_goods` VALUES ('133', '15', '芒果益菌多', 'data/images/merchant/20/deerspot_1602128045830.jpg', 'data/images/merchant/20/deerspot_1602128045830.jpg', '芒果', null, '16.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '16', null, '2020-10-08 11:34:08', '2020-10-08 11:34:08');
INSERT INTO `tb_goods` VALUES ('134', '15', '草莓果啤', 'data/images/merchant/20/deerspot_1602128458739.jpg', 'data/images/merchant/20/deerspot_1602128458739.jpg', '草莓,啤酒', null, '13.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '13', null, '2020-10-08 11:41:05', '2020-10-08 11:41:05');
INSERT INTO `tb_goods` VALUES ('135', '15', '小气红枣茶', 'data/images/merchant/20/deerspot_1602130161424.jpg', 'data/images/merchant/20/deerspot_1602130161424.jpg', '红枣、全脂牛奶', null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '12', null, '2020-10-08 12:09:24', '2020-10-08 12:09:24');
INSERT INTO `tb_goods` VALUES ('136', '15', '小气槟榔奶芋', 'data/images/merchant/20/deerspot_1602130280074.jpg', 'data/images/merchant/20/deerspot_1602130280074.jpg', '全脂牛奶、芋头', null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '12', null, '2020-10-08 12:11:21', '2020-10-08 12:11:21');
INSERT INTO `tb_goods` VALUES ('137', '16', '奥利奥可可', 'data/images/merchant/21/deerspot_1602150961490.jpg', 'data/images/merchant/21/deerspot_1602150961490.jpg', '奥利奥、芝士、可可', null, '13.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '15', null, '2020-10-08 17:56:03', '2020-10-14 18:00:50');
INSERT INTO `tb_goods` VALUES ('138', '16', '奥利奥芝士奶茶', 'data/images/merchant/21/deerspot_1602151105703.jpg', 'data/images/merchant/21/deerspot_1602151105703.jpg', '奥利奥、芝士、红茶、牛奶、珍珠', null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '1', '0', null, '1.00', '0.00', '15', null, '2020-10-08 17:58:27', '2020-10-14 18:00:37');
INSERT INTO `tb_goods` VALUES ('139', '16', '白桃乌龙拿铁', 'data/images/merchant/21/deerspot_1602151262380.jpg', 'data/images/merchant/21/deerspot_1602151262380.jpg', '奶油、白桃茶汤、全脂牛奶', null, '13.00', '0', '0', '0', '2', '0', '0.00', '0', '4', '0', null, '1.00', '0.00', '15', null, '2020-10-08 18:01:11', '2020-10-14 18:01:20');
INSERT INTO `tb_goods` VALUES ('140', '16', '黑芝麻烧仙草', 'data/images/merchant/21/deerspot_1602151558112.jpg', 'data/images/merchant/21/deerspot_1602151558112.jpg', '黑芝麻', null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '15.00', '0.00', '15', null, '2020-10-08 18:05:59', '2020-10-14 18:00:17');
INSERT INTO `tb_goods` VALUES ('141', '16', '经典咖啡', 'data/images/merchant/21/deerspot_1602151634081.jpg', 'data/images/merchant/21/deerspot_1602151634081.jpg', '全脂牛奶', null, '10.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '11', null, '2020-10-08 18:07:15', '2020-10-14 17:59:59');
INSERT INTO `tb_goods` VALUES ('142', '16', '荔枝乌龙拿铁', 'data/images/merchant/21/deerspot_1602151787976.jpg', 'data/images/merchant/21/deerspot_1602151787976.jpg', '奶油核桃碎让人欲罢不能的味道哟!', null, '13.00', '0', '0', '0', '2', '0', '0.00', '0', '1', '0', null, '1.00', '0.00', '15', null, '2020-10-08 18:09:49', '2020-10-14 18:01:07');
INSERT INTO `tb_goods` VALUES ('143', '16', '黑芝麻芋圆奶茶', 'data/images/merchant/21/deerspot_1602151910531.jpg', 'data/images/merchant/21/deerspot_1602151910531.jpg', '红茶、牛奶、小芋圆', null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '12', null, '2020-10-08 18:11:54', '2020-10-14 17:59:44');
INSERT INTO `tb_goods` VALUES ('144', '16', '抹茶玛奇朵', 'data/images/merchant/21/deerspot_1602152084981.jpg', 'data/images/merchant/21/deerspot_1602152084981.jpg', '抹茶、牛奶、芝士', null, '13.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '15', null, '2020-10-08 18:14:51', '2020-10-14 17:59:16');
INSERT INTO `tb_goods` VALUES ('145', '16', '芋泥燕麦奶茶', 'data/images/merchant/21/deerspot_1602152312428.jpg', 'data/images/merchant/21/deerspot_1602152312428.jpg', '芋泥、燕麦', null, '9.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '15', null, '2020-10-08 18:18:33', '2020-10-14 17:59:03');
INSERT INTO `tb_goods` VALUES ('146', '16', '百香果益菌多', 'data/images/merchant/21/deerspot_1602152466696.jpg', 'data/images/merchant/21/deerspot_1602152466696.jpg', '百香果、益菌多、绿茶', null, '14.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '14', null, '2020-10-08 18:21:08', '2020-10-08 18:22:18');
INSERT INTO `tb_goods` VALUES ('147', '16', '百香芒果', 'data/images/merchant/21/deerspot_1602152582424.jpg', 'data/images/merchant/21/deerspot_1602152582424.jpg', '百香果、芒果', null, '13.00', '0', '0', '0', '2', '0', '0.00', '0', '1', '0', null, '1.00', '0.00', '13', null, '2020-10-08 18:23:04', '2020-10-14 17:58:19');
INSERT INTO `tb_goods` VALUES ('148', '16', '百香果芒果益菌多', 'data/images/merchant/21/deerspot_1602152649293.jpg', 'data/images/merchant/21/deerspot_1602152649293.jpg', '百香果、芒果、益菌多', null, '14.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '14', null, '2020-10-08 18:24:11', '2020-10-08 18:24:11');
INSERT INTO `tb_goods` VALUES ('149', '16', '百香果双响炮', 'data/images/merchant/21/deerspot_1602152830758.jpg', 'data/images/merchant/21/deerspot_1602152830758.jpg', '百香果、珍珠、野果', null, '13.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '13', null, '2020-10-08 18:27:12', '2020-10-08 18:27:12');
INSERT INTO `tb_goods` VALUES ('150', '16', '布丁奶茶', 'data/images/merchant/21/deerspot_1602152993838.jpg', 'data/images/merchant/21/deerspot_1602152993838.jpg', '布丁、红茶、牛奶', null, '7.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '7', null, '2020-10-08 18:29:55', '2020-10-08 18:29:55');
INSERT INTO `tb_goods` VALUES ('151', '16', '奶绿三兄弟', 'data/images/merchant/21/deerspot_1602153131363.jpg', 'data/images/merchant/21/deerspot_1602153131363.jpg', '布丁、西米', null, '9.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '9', null, '2020-10-08 18:32:13', '2020-10-14 17:57:48');
INSERT INTO `tb_goods` VALUES ('152', '16', '草莓波波奶茶', 'data/images/merchant/21/deerspot_1602153275555.jpg', 'data/images/merchant/21/deerspot_1602153275555.jpg', '全职牛奶、西米、草莓果酱', null, '10.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '10', null, '2020-10-08 18:34:37', '2020-10-14 17:56:04');
INSERT INTO `tb_goods` VALUES ('153', '16', '草莓波波酸奶', 'data/images/merchant/21/deerspot_1602153399584.jpg', 'data/images/merchant/21/deerspot_1602153399584.jpg', '酸奶、草莓酱', null, '14.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '14', null, '2020-10-08 18:36:43', '2020-10-14 17:55:09');
INSERT INTO `tb_goods` VALUES ('154', '16', '草莓波波益菌多', 'data/images/merchant/21/deerspot_1602153528014.jpg', 'data/images/merchant/21/deerspot_1602153528014.jpg', '草莓酱、茉莉绿茶、脆波波', null, '13.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '13', null, '2020-10-08 18:38:50', '2020-10-14 17:54:39');
INSERT INTO `tb_goods` VALUES ('155', '16', '草莓芋圆冻冻', 'data/images/merchant/21/deerspot_1602153698235.jpg', 'data/images/merchant/21/deerspot_1602153698235.jpg', '草莓、芋圆、茉莉绿茶', null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '13', null, '2020-10-08 18:41:40', '2020-10-14 17:54:14');
INSERT INTO `tb_goods` VALUES ('156', '16', '多肉桃桃', 'data/images/merchant/21/deerspot_1602153915131.jpg', 'data/images/merchant/21/deerspot_1602153915131.jpg', '满杯水蜜桃、口感甜蜜', null, '13.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '13', null, '2020-10-08 18:45:16', '2020-10-08 18:45:16');
INSERT INTO `tb_goods` VALUES ('157', '16', '粉桃波波酸奶', 'data/images/merchant/21/deerspot_1602154054986.jpg', 'data/images/merchant/21/deerspot_1602154054986.jpg', '水蜜桃、酸奶', null, '14.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '14', null, '2020-10-08 18:47:36', '2020-10-08 18:47:36');
INSERT INTO `tb_goods` VALUES ('158', '16', '蜂蜜柚子茶', 'data/images/merchant/21/deerspot_1602154218902.jpg', 'data/images/merchant/21/deerspot_1602154218902.jpg', '柚子酱、茉莉绿茶', null, '10.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '10', null, '2020-10-08 18:50:20', '2020-10-08 18:50:20');
INSERT INTO `tb_goods` VALUES ('159', '16', '黑糖芋圆奶茶', 'data/images/merchant/21/deerspot_1602154346707.jpg', 'data/images/merchant/21/deerspot_1602154346707.jpg', '黑糖、芋圆、红茶、牛奶', null, '10.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '10', null, '2020-10-08 18:52:28', '2020-10-08 18:52:28');
INSERT INTO `tb_goods` VALUES ('160', '16', '红豆奶茶', 'data/images/merchant/21/deerspot_1602154480821.jpg', 'data/images/merchant/21/deerspot_1602154480821.jpg', '红豆、红茶、牛奶', null, '7.00', '0', '0', '0', '2', '0', '0.00', '0', '1', '0', null, '1.00', '0.00', '7', null, '2020-10-08 18:54:43', '2020-10-08 18:54:43');
INSERT INTO `tb_goods` VALUES ('161', '16', '黄金烤奶', 'data/images/merchant/21/deerspot_1602154597573.jpg', 'data/images/merchant/21/deerspot_1602154597573.jpg', '牛奶、红茶、珍珠', null, '10.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '7', null, '2020-10-08 18:56:39', '2020-10-14 17:53:30');
INSERT INTO `tb_goods` VALUES ('162', '16', '金观音奶茶', 'data/images/merchant/21/deerspot_1602154779774.jpg', 'data/images/merchant/21/deerspot_1602154779774.jpg', '金观音茶汤、牛奶、珍珠', null, '9.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '9', null, '2020-10-08 18:59:50', '2020-10-14 17:51:50');
INSERT INTO `tb_goods` VALUES ('163', '16', '金桔柠檬', 'data/images/merchant/21/deerspot_1602158264036.jpg', 'data/images/merchant/21/deerspot_1602158264036.jpg', '酸甜的口感清热解暑', null, '9.00', '0', '0', '0', '2', '0', '0.00', '0', '2', '0', null, '1.00', '0.00', '9', null, '2020-10-08 19:57:46', '2020-10-08 19:57:46');
INSERT INTO `tb_goods` VALUES ('164', '16', '蓝莓波波酸奶', 'data/images/merchant/21/deerspot_1602158370935.jpg', 'data/images/merchant/21/deerspot_1602158370935.jpg', '酸奶、蓝莓酱', null, '14.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '14', null, '2020-10-08 19:59:52', '2020-10-08 19:59:52');
INSERT INTO `tb_goods` VALUES ('165', '16', '蓝莓芋圆冻冻', 'data/images/merchant/21/deerspot_1602158517220.jpg', 'data/images/merchant/21/deerspot_1602158517220.jpg', '蓝莓、芋圆', null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '13', null, '2020-10-08 20:01:59', '2020-10-14 17:50:52');
INSERT INTO `tb_goods` VALUES ('166', '16', '荔枝波波芋圆', 'data/images/merchant/21/deerspot_1602158671268.jpg', 'data/images/merchant/21/deerspot_1602158671268.jpg', '荔枝、芋圆', null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '13', null, '2020-10-08 20:04:33', '2020-10-14 17:49:54');
INSERT INTO `tb_goods` VALUES ('167', '16', '满杯橙子', 'data/images/merchant/21/deerspot_1602158816193.jpg', 'data/images/merchant/21/deerspot_1602158816193.jpg', '橙子、蜂蜜、绿茶', null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '12', null, '2020-10-08 20:06:57', '2020-10-08 20:06:57');
INSERT INTO `tb_goods` VALUES ('168', '16', '满杯烧仙草', 'data/images/merchant/21/deerspot_1602158952994.jpg', 'data/images/merchant/21/deerspot_1602158952994.jpg', '仙草冻、花生碎、葡萄干、珍珠、野果', null, '9.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '9', null, '2020-10-08 20:09:15', '2020-10-08 20:09:15');
INSERT INTO `tb_goods` VALUES ('169', '16', '芒果椰汁西米露', 'data/images/merchant/21/deerspot_1602159276866.jpg', 'data/images/merchant/21/deerspot_1602159276866.jpg', '芒果、椰汁、西米露', null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '13', null, '2020-10-08 20:14:38', '2020-10-14 17:48:33');
INSERT INTO `tb_goods` VALUES ('170', '16', '蜜桃波波益菌多', 'data/images/merchant/21/deerspot_1602159815191.jpg', 'data/images/merchant/21/deerspot_1602159815191.jpg', '水蜜桃、益菌多、茉莉绿茶', null, '13.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '13', null, '2020-10-08 20:23:37', '2020-10-08 20:23:37');
INSERT INTO `tb_goods` VALUES ('171', '16', '奶茶三兄弟', 'data/images/merchant/21/deerspot_1602159885270.jpg', 'data/images/merchant/21/deerspot_1602159885270.jpg', '布丁、西米、野果', null, '9.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '9', null, '2020-10-08 20:25:41', '2020-10-14 17:47:49');
INSERT INTO `tb_goods` VALUES ('172', '16', '柠檬水', 'data/images/merchant/21/deerspot_1602160083679.jpg', 'data/images/merchant/21/deerspot_1602160083679.jpg', '柠檬、蜂蜜', null, '7.00', '0', '0', '0', '2', '0', '0.00', '0', '1', '0', null, '1.00', '0.00', '6', null, '2020-10-08 20:28:05', '2020-10-14 17:21:41');
INSERT INTO `tb_goods` VALUES ('173', '16', '柠檬益菌多', 'data/images/merchant/21/deerspot_1602160238500.jpg', 'data/images/merchant/21/deerspot_1602160238500.jpg', '柠檬、茉莉绿茶、益菌多', null, '13.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '13', null, '2020-10-08 20:30:40', '2020-10-08 20:30:40');
INSERT INTO `tb_goods` VALUES ('174', '16', '葡萄柚益菌多', 'data/images/merchant/21/deerspot_1602160355537.jpg', 'data/images/merchant/21/deerspot_1602160355537.jpg', '葡萄、西柚、益菌多、茉莉绿茶', null, '13.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '13', null, '2020-10-08 20:32:37', '2020-10-14 17:47:29');
INSERT INTO `tb_goods` VALUES ('175', '16', '葡萄芋圆冻冻', 'data/images/merchant/21/deerspot_1602160614758.jpg', 'data/images/merchant/21/deerspot_1602160614758.jpg', '葡萄、芋圆、茉莉绿茶', null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '13', null, '2020-10-08 20:36:56', '2020-10-14 17:46:55');
INSERT INTO `tb_goods` VALUES ('176', '16', '奇异果波波芋圆', 'data/images/merchant/21/deerspot_1602160729047.jpg', 'data/images/merchant/21/deerspot_1602160729047.jpg', '奇异果、芋圆、脆波波', null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '13', null, '2020-10-08 20:38:51', '2020-10-14 17:46:37');
INSERT INTO `tb_goods` VALUES ('177', '16', '酸奶烧仙草', 'data/images/merchant/21/deerspot_1602160851277.jpg', 'data/images/merchant/21/deerspot_1602160851277.jpg', '西米、仙草冻', null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '12', null, '2020-10-08 20:40:54', '2020-10-14 17:52:10');
INSERT INTO `tb_goods` VALUES ('178', '16', '鲜橙葡萄柚', 'data/images/merchant/21/deerspot_1602161045589.jpg', 'data/images/merchant/21/deerspot_1602161045589.jpg', '红西柚诱人香气,配合橙子香甜', null, '13.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '13', null, '2020-10-08 20:44:09', '2020-10-08 20:44:09');
INSERT INTO `tb_goods` VALUES ('179', '16', '鲜橙益菌多', 'data/images/merchant/21/deerspot_1602161200771.jpg', 'data/images/merchant/21/deerspot_1602161200771.jpg', '真果粒,看的见', null, '13.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '13', null, '2020-10-08 20:46:42', '2020-10-08 20:46:42');
INSERT INTO `tb_goods` VALUES ('180', '16', '杨枝甘露烧仙草', 'data/images/merchant/21/deerspot_1602161463510.jpg', 'data/images/merchant/21/deerspot_1602161463510.jpg', '西米、杨枝甘露、椰浆、芒果、仙草冻冻', null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '2', '0', null, '1.00', '0.00', '13', null, '2020-10-08 20:51:06', '2020-10-14 17:46:02');
INSERT INTO `tb_goods` VALUES ('181', '16', '杨枝甘露酸奶', 'data/images/merchant/21/deerspot_1602161604335.jpg', 'data/images/merchant/21/deerspot_1602161604335.jpg', '西米、西柚、酸奶、芒果、茉莉绿茶', null, '14.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '15', null, '2020-10-08 20:53:26', '2020-10-14 17:45:09');
INSERT INTO `tb_goods` VALUES ('182', '16', '椰果奶茶', 'data/images/merchant/21/deerspot_1602161741171.jpg', 'data/images/merchant/21/deerspot_1602161741171.jpg', '野果、红茶、牛奶', null, '7.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '7', null, '2020-10-08 20:55:43', '2020-10-14 17:44:11');
INSERT INTO `tb_goods` VALUES ('183', '16', '小芋圆奶茶', 'data/images/merchant/21/deerspot_1602161866341.jpg', 'data/images/merchant/21/deerspot_1602161866341.jpg', '芋圆', null, '9.00', '0', '0', '0', '2', '0', '0.00', '0', '1', '0', null, '1.00', '0.00', '9', null, '2020-10-08 20:57:48', '2020-10-10 18:21:06');
INSERT INTO `tb_goods` VALUES ('184', '16', '小芋圆烧仙草', 'data/images/merchant/21/deerspot_1602162092691.jpg', 'data/images/merchant/21/deerspot_1602162092691.jpg', '芋圆、仙草冻、珍珠、花生碎', null, '10.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '10', null, '2020-10-08 21:01:55', '2020-10-08 21:01:55');
INSERT INTO `tb_goods` VALUES ('185', '16', '黄金珍珠奶茶', 'data/images/merchant/21/deerspot_1602162204376.jpg', 'data/images/merchant/21/deerspot_1602162204376.jpg', '牛奶、红茶、珍珠', null, '7.00', '0', '0', '0', '2', '0', '0.00', '0', '1', '0', null, '1.00', '0.00', '7', null, '2020-10-08 21:03:34', '2020-10-08 21:03:34');
INSERT INTO `tb_goods` VALUES ('186', '15', '西瓜椰奶', 'data/images/merchant/20/deerspot_1602223067045.jpg', 'data/images/merchant/20/deerspot_1602223067045.jpg', '西瓜、椰奶', null, '16.00', '0', '0', '0', '2', '0', '0.00', '0', '13', '0', null, '1.00', '0.00', '16', null, '2020-10-09 13:57:49', '2020-10-09 13:57:49');
INSERT INTO `tb_goods` VALUES ('187', '15', '西米西瓜汁', 'data/images/merchant/20/deerspot_1602223302458.jpg', 'data/images/merchant/20/deerspot_1602223302458.jpg', '西瓜、西米', null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '12', null, '2020-10-09 14:01:44', '2020-10-09 14:01:44');
INSERT INTO `tb_goods` VALUES ('188', '15', '蜜桃桂花酒酿', 'data/images/merchant/20/deerspot_1602223662936.jpg', 'data/images/merchant/20/deerspot_1602223662936.jpg', '水蜜桃、桂花茶', null, '16.00', '0', '0', '0', '2', '0', '0.00', '0', '6', '0', null, '1.00', '0.00', '16', null, '2020-10-09 14:07:46', '2020-10-09 14:07:46');
INSERT INTO `tb_goods` VALUES ('189', '15', '冰荔沉香', 'data/images/merchant/20/deerspot_1602224085614.jpg', 'data/images/merchant/20/deerspot_1602224085614.jpg', '荔枝', null, '18.90', '0', '0', '0', '2', '0', '0.00', '0', '6', '0', null, '1.00', '0.00', '20', null, '2020-10-09 14:14:47', '2020-10-14 14:37:38');
INSERT INTO `tb_goods` VALUES ('190', '15', '小气阳光橙', 'data/images/merchant/20/deerspot_1602224270930.jpg', 'data/images/merchant/20/deerspot_1602224270930.jpg', '橙子、茉香绿茶', null, '18.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '18', null, '2020-10-09 14:17:53', '2020-10-09 14:17:53');
INSERT INTO `tb_goods` VALUES ('191', '15', '多肉莓莓', 'data/images/merchant/20/deerspot_1602224512630.jpg', 'data/images/merchant/20/deerspot_1602224512630.jpg', '草莓', null, '15.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '15', null, '2020-10-09 14:21:54', '2020-10-09 14:21:54');
INSERT INTO `tb_goods` VALUES ('192', '15', '百香啤酒', 'data/images/merchant/20/deerspot_1602224991782.jpg', 'data/images/merchant/20/deerspot_1602224991782.jpg', '啤酒、百香果', null, '14.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '14', null, '2020-10-09 14:29:53', '2020-10-09 14:29:53');
INSERT INTO `tb_goods` VALUES ('193', '15', '小桃微醺', 'data/images/merchant/20/deerspot_1602225403176.jpg', 'data/images/merchant/20/deerspot_1602225403176.jpg', '水蜜桃', null, '16.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '16', null, '2020-10-09 14:36:45', '2020-10-09 14:36:45');
INSERT INTO `tb_goods` VALUES ('194', '15', '金桂飘香', 'data/images/merchant/20/deerspot_1602225775350.jpg', 'data/images/merchant/20/deerspot_1602225775350.jpg', '桂花', null, '15.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '15', null, '2020-10-09 14:42:57', '2020-10-09 14:42:57');
INSERT INTO `tb_goods` VALUES ('195', '15', '老虎斑奶茶', 'data/images/merchant/20/deerspot_1602225931463.jpg', 'data/images/merchant/20/deerspot_1602225931463.jpg', '牛奶、红茶、黑糖、珍珠', null, '17.00', '0', '0', '0', '2', '0', '0.00', '0', '58', '0', null, '1.00', '0.00', '17', null, '2020-10-09 14:45:33', '2020-10-09 14:45:33');
INSERT INTO `tb_goods` VALUES ('196', '15', '男朋友益菌多', 'data/images/merchant/20/deerspot_1602226090625.jpg', 'data/images/merchant/20/deerspot_1602226090625.jpg', '青柠檬、蓝柑', null, '17.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '17', null, '2020-10-09 14:48:12', '2020-10-09 14:48:12');
INSERT INTO `tb_goods` VALUES ('197', '15', '小归薯', 'data/images/merchant/20/deerspot_1602226274881.jpg', 'data/images/merchant/20/deerspot_1602226274881.jpg', '紫薯', null, '15.00', '0', '0', '0', '2', '0', '0.00', '0', '9', '0', null, '1.00', '0.00', '15', null, '2020-10-09 14:51:17', '2020-10-09 14:51:17');
INSERT INTO `tb_goods` VALUES ('198', '18', '黑糖波波茶', 'data/images/merchant/23/deerspot_1602472553211.jpg', 'data/images/merchant/23/deerspot_1602472553211.jpg', '黑糖、波波、红茶、牛奶', null, '8.00', '0', '0', '0', '2', '0', '0.00', '0', '39', '0', null, '1.00', '0.00', '8', null, '2020-10-12 11:15:55', '2020-10-12 11:15:55');
INSERT INTO `tb_goods` VALUES ('199', '18', '姜汁柚子蜜', 'data/images/merchant/23/deerspot_1602472993855.jpg', 'data/images/merchant/23/deerspot_1602472993855.jpg', '小芋圆、绿茶、柚子酱、蜂蜜', null, '12.00', '0', '0', '0', '3', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '12', null, '2020-10-12 11:23:15', '2021-07-01 18:30:08');
INSERT INTO `tb_goods` VALUES ('200', '18', '脏脏草莓', 'data/images/merchant/23/deerspot_1602777061891.jpg', 'data/images/merchant/23/deerspot_1602777061891.jpg', '草莓', null, '10.00', '0', '0', '0', '2', '0', '0.00', '0', '7', '0', null, '1.00', '0.00', '10', null, '2020-10-12 11:32:29', '2020-10-16 00:25:20');
INSERT INTO `tb_goods` VALUES ('201', '18', '芝士奶茶', 'data/images/merchant/23/deerspot_1603216451624.jpg', 'data/images/merchant/23/deerspot_1603216451624.jpg', '芝士奶盖、牛奶', null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '12', null, '2020-10-12 12:02:03', '2020-10-21 12:59:48');
INSERT INTO `tb_goods` VALUES ('202', '18', '幽兰拿铁', 'data/images/merchant/23/deerspot_1602475560912.jpg', 'data/images/merchant/23/deerspot_1602475560912.jpg', '奶油、红茶、牛奶', null, '15.00', '0', '0', '0', '2', '0', '0.00', '0', '5', '0', null, '1.00', '0.00', '15', null, '2020-10-12 12:06:02', '2020-10-12 12:06:02');
INSERT INTO `tb_goods` VALUES ('203', '18', '黑钻奶茶', 'data/images/merchant/23/deerspot_1602475746841.jpg', 'data/images/merchant/23/deerspot_1602475746841.jpg', '红茶、牛奶、黑糖', null, '9.00', '0', '0', '0', '3', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '9', null, '2020-10-12 12:09:09', '2021-07-01 18:30:43');
INSERT INTO `tb_goods` VALUES ('204', '18', '草莓芦荟爽', 'data/images/merchant/23/deerspot_1602475955501.jpg', 'data/images/merchant/23/deerspot_1602475955501.jpg', '草莓、芦荟,绿茶', null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '12', null, '2020-10-12 12:12:37', '2020-10-12 12:12:37');
INSERT INTO `tb_goods` VALUES ('205', '18', '冰摇绿妍', 'data/images/merchant/23/deerspot_1602476146225.jpg', 'data/images/merchant/23/deerspot_1602476146225.jpg', '绿茶', null, '6.00', '0', '0', '0', '3', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '6', null, '2020-10-12 12:15:48', '2021-07-01 18:30:55');
INSERT INTO `tb_goods` VALUES ('206', '18', '金桔柠檬', 'data/images/merchant/23/deerspot_1625112206648.jpg', 'data/images/merchant/23/deerspot_1625112206648.jpg', '金桔、柠檬、绿茶', null, '9.00', '0', '0', '0', '2', '0', '0.00', '0', '2', '0', null, '1.00', '0.00', '9', null, '2020-10-13 15:04:45', '2021-07-01 18:31:22');
INSERT INTO `tb_goods` VALUES ('207', '18', '百香果益菌多', 'data/images/merchant/23/deerspot_1602572832496.jpg', 'data/images/merchant/23/deerspot_1602572832496.jpg', '百香果、绿茶、益菌多', null, '10.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '10', null, '2020-10-13 15:07:14', '2020-10-13 15:07:14');
INSERT INTO `tb_goods` VALUES ('208', '18', '葡萄柚益菌多', 'data/images/merchant/23/deerspot_1603216077549.jpg', 'data/images/merchant/23/deerspot_1603216077549.jpg', '西柚、益菌多、绿茶', null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '11', '0', null, '1.00', '0.00', '12', null, '2020-10-13 15:11:09', '2020-10-21 01:48:00');
INSERT INTO `tb_goods` VALUES ('209', '18', '水蜜桃益菌多', 'data/images/merchant/23/deerspot_1603215883701.jpg', 'data/images/merchant/23/deerspot_1603215883701.jpg', '水蜜桃、益菌多、绿茶', null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '9', '0', null, '1.00', '0.00', '12', null, '2020-10-13 15:19:48', '2020-10-21 01:44:45');
INSERT INTO `tb_goods` VALUES ('210', '18', '杨枝甘露', 'data/images/merchant/23/deerspot_1603215528332.jpg', 'data/images/merchant/23/deerspot_1603215528332.jpg', '芒果、西米、椰浆', null, '15.00', '0', '0', '0', '2', '0', '0.00', '0', '3', '0', null, '1.00', '0.00', '15', null, '2020-10-13 15:23:42', '2020-10-21 01:38:52');
INSERT INTO `tb_goods` VALUES ('211', '18', '百香果双响炮', 'data/images/merchant/23/deerspot_1603215184233.jpg', 'data/images/merchant/23/deerspot_1603215184233.jpg', '百香果、珍珠、椰果、绿茶', null, '12.00', '0', '0', '0', '3', '0', '0.00', '0', '1', '0', null, '1.00', '0.00', '12', null, '2020-10-13 15:26:16', '2021-07-01 18:27:16');
INSERT INTO `tb_goods` VALUES ('212', '18', '宜兰青桔茉莉', 'data/images/merchant/23/deerspot_1602777706179.jpg', 'data/images/merchant/23/deerspot_1602777706179.jpg', '金桔、青柠', null, '9.00', '0', '0', '0', '3', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '9', null, '2020-10-13 15:29:04', '2021-07-01 18:27:28');
INSERT INTO `tb_goods` VALUES ('213', '18', '柠檬汁', 'data/images/merchant/23/deerspot_1602574285494.jpg', 'data/images/merchant/23/deerspot_1602574285494.jpg', '柠檬', null, '5.00', '0', '0', '0', '3', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '5', null, '2020-10-13 15:31:29', '2021-07-01 18:27:45');
INSERT INTO `tb_goods` VALUES ('214', '18', '芒果西米露', 'data/images/merchant/23/deerspot_1603215738039.jpg', 'data/images/merchant/23/deerspot_1603215738039.jpg', '芒果、西米', null, '13.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '13', null, '2020-10-13 15:35:08', '2020-10-21 01:42:19');
INSERT INTO `tb_goods` VALUES ('215', '18', '芋圆葡萄冻冻', 'data/images/merchant/23/deerspot_1602574686668.jpg', 'data/images/merchant/23/deerspot_1602574686668.jpg', '芋圆、葡萄', null, '13.00', '0', '0', '0', '3', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '13', null, '2020-10-13 15:38:08', '2021-07-01 18:28:08');
INSERT INTO `tb_goods` VALUES ('216', '18', '豆乳波波', 'data/images/merchant/23/deerspot_1602574873506.jpg', 'data/images/merchant/23/deerspot_1602574873506.jpg', '豆乳', null, '11.00', '0', '0', '0', '3', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '11', null, '2020-10-13 15:41:15', '2021-07-01 18:28:42');
INSERT INTO `tb_goods` VALUES ('217', '18', '元气烤奶', 'data/images/merchant/23/deerspot_1602575085184.jpg', 'data/images/merchant/23/deerspot_1602575085184.jpg', '烤奶、黑糖', null, '9.00', '0', '0', '0', '3', '0', '0.00', '0', '6', '0', null, '1.00', '0.00', '9', null, '2020-10-13 15:44:47', '2021-07-01 18:28:33');
INSERT INTO `tb_goods` VALUES ('218', '18', '海洋之心', 'data/images/merchant/23/deerspot_1602575450732.jpg', 'data/images/merchant/23/deerspot_1602575450732.jpg', '蓝柑、青柠', null, '9.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '9', null, '2020-10-13 15:51:47', '2020-10-13 15:51:47');
INSERT INTO `tb_goods` VALUES ('219', '18', '芝芝桃桃', 'data/images/merchant/23/deerspot_1602775589231.jpg', 'data/images/merchant/23/deerspot_1602775589231.jpg', '水蜜桃', null, '13.00', '0', '0', '0', '2', '0', '0.00', '0', '11', '0', null, '1.00', '0.00', '13', null, '2020-10-13 16:02:15', '2020-10-15 23:26:31');
INSERT INTO `tb_goods` VALUES ('220', '18', '满杯橙橙', 'data/images/merchant/23/deerspot_1602778137566.jpg', 'data/images/merchant/23/deerspot_1602778137566.jpg', '橙子', null, '12.00', '0', '0', '0', '3', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '12', null, '2020-10-13 16:04:51', '2021-07-01 18:28:59');
INSERT INTO `tb_goods` VALUES ('221', '18', '红豆奶茶', 'data/images/merchant/23/deerspot_1602576964675.jpg', 'data/images/merchant/23/deerspot_1602576964675.jpg', '红豆', null, '7.00', '0', '0', '0', '2', '0', '0.00', '0', '1', '0', null, '1.00', '0.00', '7', null, '2020-10-13 16:16:09', '2020-10-13 16:16:09');
INSERT INTO `tb_goods` VALUES ('222', '18', '红颜佳荔', 'data/images/merchant/23/deerspot_1602577219121.jpg', 'data/images/merchant/23/deerspot_1602577219121.jpg', '绿茶', null, '12.00', '0', '0', '0', '3', '0', '0.00', '0', '1', '0', null, '1.00', '0.00', '12', null, '2020-10-13 16:20:20', '2021-07-01 18:29:09');
INSERT INTO `tb_goods` VALUES ('223', '18', '柠檬益菌多', 'data/images/merchant/23/deerspot_1602577403784.jpg', 'data/images/merchant/23/deerspot_1602577403784.jpg', '柠檬、益菌多', null, '10.00', '0', '0', '0', '3', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '10', null, '2020-10-13 16:23:25', '2021-07-01 18:29:44');
INSERT INTO `tb_goods` VALUES ('224', '18', '鲜奶可可', 'data/images/merchant/23/deerspot_1602776161295.jpg', 'data/images/merchant/23/deerspot_1602776161295.jpg', '可可、奶盖', null, '12.00', '0', '0', '0', '3', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '12', null, '2020-10-15 23:36:02', '2021-07-01 18:29:27');
INSERT INTO `tb_goods` VALUES ('225', '18', '红豆抹茶', 'data/images/merchant/23/deerspot_1602776495792.jpg', 'data/images/merchant/23/deerspot_1602776495792.jpg', '抹茶、红豆', null, '10.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '10', null, '2020-10-15 23:41:37', '2020-10-15 23:41:37');
INSERT INTO `tb_goods` VALUES ('226', '18', '脏脏芒果', 'data/images/merchant/23/deerspot_1602779000259.jpg', 'data/images/merchant/23/deerspot_1602779000259.jpg', '芒果', null, '10.00', '0', '0', '0', '2', '0', '0.00', '0', '1', '0', null, '1.00', '0.00', '10', null, '2020-10-16 00:23:21', '2020-10-16 00:23:21');
INSERT INTO `tb_goods` VALUES ('227', '18', '招牌烧仙草', 'data/images/merchant/23/deerspot_1603216685230.jpg', 'data/images/merchant/23/deerspot_1603216685230.jpg', '仙草冻、椰果、红豆、花生、珍珠、葡萄', null, '10.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '10', null, '2020-10-21 01:58:07', '2020-10-21 01:58:07');
INSERT INTO `tb_goods` VALUES ('228', '18', '双拼奶茶', 'data/images/merchant/23/deerspot_1603216842236.jpg', 'data/images/merchant/23/deerspot_1603216842236.jpg', '两种底料任选哦', null, '8.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '8', null, '2020-10-21 02:00:43', '2020-10-21 02:00:43');
INSERT INTO `tb_goods` VALUES ('229', '18', '桂圆红枣奶茶', 'data/images/merchant/23/deerspot_1603255419132.jpg', 'data/images/merchant/23/deerspot_1603255419132.jpg', '桂圆、红枣、奶茶', null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '5', '0', null, '1.00', '0.00', '12', null, '2020-10-21 12:43:40', '2020-10-21 12:43:40');
INSERT INTO `tb_goods` VALUES ('230', '18', '元气燕麦烤玉米', 'data/images/merchant/23/deerspot_1603255609232.jpg', 'data/images/merchant/23/deerspot_1603255609232.jpg', '燕麦、奶茶', null, '12.00', '0', '0', '0', '3', '0', '0.00', '0', '18', '0', null, '1.00', '0.00', '12', null, '2020-10-21 12:46:51', '2021-07-01 18:26:57');
INSERT INTO `tb_goods` VALUES ('231', '18', '芝士莓莓', 'data/images/merchant/23/deerspot_1603256188313.jpg', 'data/images/merchant/23/deerspot_1603256188313.jpg', '水蜜桃、草莓', null, '15.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '15', null, '2020-10-21 12:56:30', '2021-06-28 22:32:25');
INSERT INTO `tb_goods` VALUES ('232', '18', '经典醇香咖啡', 'data/images/merchant/23/deerspot_1603256771145.jpg', 'data/images/merchant/23/deerspot_1603256771145.jpg', '咖啡豆', null, '10.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '10', null, '2020-10-21 13:06:13', '2020-10-21 13:06:13');
INSERT INTO `tb_goods` VALUES ('233', '18', '卡布基诺', 'data/images/merchant/23/deerspot_1603256951398.jpg', 'data/images/merchant/23/deerspot_1603256951398.jpg', '咖啡豆', null, '10.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '10', null, '2020-10-21 13:09:13', '2020-10-21 13:09:13');
INSERT INTO `tb_goods` VALUES ('234', '18', '拿铁', 'data/images/merchant/23/deerspot_1603257063587.jpg', 'data/images/merchant/23/deerspot_1603257063587.jpg', '咖啡豆', null, '10.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '10', null, '2020-10-21 13:11:05', '2020-10-21 13:11:05');
INSERT INTO `tb_goods` VALUES ('235', '18', '芒果双皮奶', 'data/images/merchant/23/deerspot_1603257583612.jpg', 'data/images/merchant/23/deerspot_1603257583612.jpg', '芒果双皮奶', null, '5.00', '0', '0', '0', '2', '0', '0.00', '0', '2', '0', null, '1.00', '0.00', '6', null, '2020-10-21 13:19:46', '2021-07-01 20:50:47');
INSERT INTO `tb_goods` VALUES ('237', '19', '原味奶茶', 'data/images/merchant/24/deerspot_1615789977715.png', 'data/images/merchant/24/deerspot_1615789977715.png', null, null, '6.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '6', null, '2021-03-15 14:33:33', '2021-03-15 14:33:33');
INSERT INTO `tb_goods` VALUES ('239', '19', '琥珀珍珠奶茶', 'data/images/merchant/24/deerspot_1619353829385.png', 'data/images/merchant/24/deerspot_1619353829385.png', null, null, '8.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '8', null, '2021-04-12 21:53:15', '2021-04-25 20:30:31');
INSERT INTO `tb_goods` VALUES ('240', '19', '椰果奶茶', 'data/images/merchant/24/deerspot_1619353804464.png', 'data/images/merchant/24/deerspot_1619353804464.png', null, null, '8.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '8', null, '2021-04-12 22:01:33', '2021-04-25 20:30:06');
INSERT INTO `tb_goods` VALUES ('241', '19', '抹茶奶绿', 'data/images/merchant/24/deerspot_1619353761590.png', 'data/images/merchant/24/deerspot_1619353761590.png', null, null, '7.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '7', null, '2021-04-25 19:02:49', '2021-04-25 20:29:23');
INSERT INTO `tb_goods` VALUES ('242', '19', '抹茶珍珠', 'data/images/merchant/24/deerspot_1619353743852.png', 'data/images/merchant/24/deerspot_1619353743852.png', null, null, '9.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '9', null, '2021-04-25 19:08:10', '2021-04-25 20:29:06');
INSERT INTO `tb_goods` VALUES ('243', '19', '红豆抹抹茶', 'data/images/merchant/24/deerspot_1619353723356.png', 'data/images/merchant/24/deerspot_1619353723356.png', null, null, '8.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '8', null, '2021-04-25 19:10:48', '2021-04-25 20:28:45');
INSERT INTO `tb_goods` VALUES ('244', '19', '满杯烧仙草', 'data/images/merchant/24/deerspot_1619353687255.png', 'data/images/merchant/24/deerspot_1619353687255.png', null, null, '10.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '10', null, '2021-04-25 19:16:20', '2021-04-25 20:28:09');
INSERT INTO `tb_goods` VALUES ('245', '19', '奶茶三兄弟', 'data/images/merchant/24/deerspot_1619353669403.png', 'data/images/merchant/24/deerspot_1619353669403.png', null, null, '9.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '9', null, '2021-04-25 19:36:30', '2021-04-25 20:27:51');
INSERT INTO `tb_goods` VALUES ('246', '19', '红豆双皮奶', 'data/images/merchant/24/deerspot_1619353634474.png', 'data/images/merchant/24/deerspot_1619353634474.png', null, null, '6.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '6', null, '2021-04-25 19:40:48', '2021-04-25 20:27:16');
INSERT INTO `tb_goods` VALUES ('247', '19', '椰果双皮奶', 'data/images/merchant/24/deerspot_1619353619521.png', 'data/images/merchant/24/deerspot_1619353619521.png', null, null, '6.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '6', null, '2021-04-25 19:54:34', '2021-04-25 20:27:01');
INSERT INTO `tb_goods` VALUES ('248', '19', '茉莉奶绿', 'data/images/merchant/24/deerspot_1619353587300.png', 'data/images/merchant/24/deerspot_1619353587300.png', null, null, '6.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '6', null, '2021-04-25 19:57:54', '2021-04-25 20:26:29');
INSERT INTO `tb_goods` VALUES ('249', '19', '柠檬红茶', 'data/images/merchant/24/deerspot_1619353564899.png', 'data/images/merchant/24/deerspot_1619353564899.png', null, null, '7.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '7', null, '2021-04-25 19:59:49', '2021-04-25 20:26:06');
INSERT INTO `tb_goods` VALUES ('250', '19', '百香四季', 'data/images/merchant/24/deerspot_1619353454367.png', 'data/images/merchant/24/deerspot_1619353454367.png', null, null, '11.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '11', null, '2021-04-25 20:04:49', '2021-04-25 20:24:16');
INSERT INTO `tb_goods` VALUES ('251', '19', '茉莉橙子', 'data/images/merchant/24/deerspot_1619353524338.png', 'data/images/merchant/24/deerspot_1619353524338.png', null, null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '12', null, '2021-04-25 20:20:22', '2021-04-25 20:25:26');
INSERT INTO `tb_goods` VALUES ('252', '19', '金桔柠檬绿茶', 'data/images/merchant/24/deerspot_1619354142615.png', 'data/images/merchant/24/deerspot_1619354142615.png', null, null, '9.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '12', null, '2021-04-25 20:35:44', '2021-04-25 20:37:07');
INSERT INTO `tb_goods` VALUES ('253', '19', '百香果双响炮', 'data/images/merchant/24/deerspot_1619354304921.png', 'data/images/merchant/24/deerspot_1619354304921.png', null, null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '12', null, '2021-04-25 20:38:26', '2021-04-25 20:38:26');
INSERT INTO `tb_goods` VALUES ('254', '19', '百香金桔柠檬', 'data/images/merchant/24/deerspot_1619354480442.png', 'data/images/merchant/24/deerspot_1619354480442.png', null, null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '12', null, '2021-04-25 20:41:22', '2021-04-25 20:41:22');
INSERT INTO `tb_goods` VALUES ('255', '19', '芒果牛奶', 'data/images/merchant/24/deerspot_1619355534032.png', 'data/images/merchant/24/deerspot_1619355534032.png', null, null, '8.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '8', null, '2021-04-25 20:58:56', '2021-04-25 23:28:45');
INSERT INTO `tb_goods` VALUES ('256', '19', '椰浆西米露', 'data/images/merchant/24/deerspot_1619358453180.png', 'data/images/merchant/24/deerspot_1619358453180.png', null, null, '10.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '10', null, '2021-04-25 21:47:35', '2021-04-25 23:28:38');
INSERT INTO `tb_goods` VALUES ('257', '19', '芒果益菌多', 'data/images/merchant/24/deerspot_1619359158859.png', 'data/images/merchant/24/deerspot_1619359158859.png', null, null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '13', null, '2021-04-25 21:59:20', '2021-04-25 22:33:10');
INSERT INTO `tb_goods` VALUES ('258', '19', '柠檬益菌多', 'data/images/merchant/24/deerspot_1619359264893.png', 'data/images/merchant/24/deerspot_1619359264893.png', null, null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '13', null, '2021-04-25 22:01:06', '2021-04-25 22:32:49');
INSERT INTO `tb_goods` VALUES ('259', '19', '百香果益菌多', 'data/images/merchant/24/deerspot_1619361128763.png', 'data/images/merchant/24/deerspot_1619361128763.png', null, null, '13.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '13', null, '2021-04-25 22:32:10', '2021-04-25 22:32:10');
INSERT INTO `tb_goods` VALUES ('260', '19', '熊猫奶盖', 'data/images/merchant/24/deerspot_1622733955759.png', 'data/images/merchant/24/deerspot_1622733955759.png', null, null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '12', null, '2021-04-25 23:25:51', '2021-06-03 23:25:58');
INSERT INTO `tb_goods` VALUES ('261', '13', 'test-a', 'data/images/merchant/18/deerspot_1622733699122.png', 'data/images/merchant/18/deerspot_1622733699122.png', '1', null, '10000.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '10000', null, '2021-06-03 23:21:50', '2021-06-03 23:21:50');
INSERT INTO `tb_goods` VALUES ('262', '18', '脏脏蓝莓', 'data/images/merchant/23/deerspot_1624764648593.jpg', 'data/images/merchant/23/deerspot_1624764648593.jpg', null, null, '10.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '10', null, '2021-06-27 11:30:50', '2021-06-27 11:31:02');
INSERT INTO `tb_goods` VALUES ('263', '18', '原味奶茶', 'data/images/merchant/23/deerspot_1624889025764.jpg', 'data/images/merchant/23/deerspot_1624889025764.jpg', null, null, '6.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '6', null, '2021-06-28 22:03:47', '2021-06-28 22:11:41');
INSERT INTO `tb_goods` VALUES ('264', '18', '芋泥椰奶波波', 'data/images/merchant/23/deerspot_1624889229079.jpg', 'data/images/merchant/23/deerspot_1624889229079.jpg', null, null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '12', null, '2021-06-28 22:07:11', '2021-06-28 22:11:34');
INSERT INTO `tb_goods` VALUES ('265', '18', '奥利奥奶茶', 'data/images/merchant/23/deerspot_1624889444597.jpg', 'data/images/merchant/23/deerspot_1624889444597.jpg', null, null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '12', null, '2021-06-28 22:10:46', '2021-06-28 22:11:29');
INSERT INTO `tb_goods` VALUES ('266', '18', '花香阿华田', 'data/images/merchant/23/deerspot_1624889720668.jpg', 'data/images/merchant/23/deerspot_1624889720668.jpg', null, null, '16.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '16', null, '2021-06-28 22:15:22', '2021-06-28 22:15:22');
INSERT INTO `tb_goods` VALUES ('267', '18', '芝士芒芒', 'data/images/merchant/23/deerspot_1624890682710.jpg', 'data/images/merchant/23/deerspot_1624890682710.jpg', null, null, '15.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '15', null, '2021-06-28 22:31:24', '2021-06-28 22:31:24');
INSERT INTO `tb_goods` VALUES ('268', '18', '芝士多肉葡萄', 'data/images/merchant/23/deerspot_1624890875564.jpg', 'data/images/merchant/23/deerspot_1624890875564.jpg', null, null, '18.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '18', null, '2021-06-28 22:34:37', '2021-06-28 22:34:37');
INSERT INTO `tb_goods` VALUES ('269', '18', '脏脏牛乳茶', 'data/images/merchant/23/deerspot_1625111261841.jpg', 'data/images/merchant/23/deerspot_1625111261841.jpg', null, null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '12', null, '2021-07-01 11:47:43', '2021-07-01 11:47:43');
INSERT INTO `tb_goods` VALUES ('270', '18', '超级柠檬水', 'data/images/merchant/23/deerspot_1625111730453.jpg', 'data/images/merchant/23/deerspot_1625111730453.jpg', null, null, '5.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '5', null, '2021-07-01 11:55:32', '2021-07-01 11:55:32');
INSERT INTO `tb_goods` VALUES ('271', '18', '百香果三重奏', 'data/images/merchant/23/deerspot_1625115665092.jpg', 'data/images/merchant/23/deerspot_1625115665092.jpg', null, null, '12.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '12', null, '2021-07-01 13:01:06', '2021-07-01 13:01:06');
INSERT INTO `tb_goods` VALUES ('272', '18', '芋圆葡萄冻冻', 'data/images/merchant/23/deerspot_1625134448911.jpg', 'data/images/merchant/23/deerspot_1625134448911.jpg', null, null, '13.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '13', null, '2021-07-01 18:14:10', '2021-07-01 18:14:10');
INSERT INTO `tb_goods` VALUES ('273', '18', '美式咖啡', 'data/images/merchant/23/deerspot_1625134931730.jpg', 'data/images/merchant/23/deerspot_1625134931730.jpg', null, null, '10.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '10', null, '2021-07-01 18:22:13', '2021-07-01 18:22:13');
INSERT INTO `tb_goods` VALUES ('274', '18', '原味鸡蛋仔(多口味)', 'data/images/merchant/23/deerspot_1625135121727.jpg', 'data/images/merchant/23/deerspot_1625135121727.jpg', null, null, '9.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '1.00', '0.00', '9', null, '2021-07-01 18:25:29', '2021-07-01 18:25:29');
INSERT INTO `tb_goods` VALUES ('275', '18', '珍珠', 'data/images/merchant/23/deerspot_1625146462382.jpg', 'data/images/merchant/23/deerspot_1625146462382.jpg', null, null, '2.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '0.00', '0.00', '2', null, '2021-07-01 21:34:24', '2021-07-01 21:34:24');
INSERT INTO `tb_goods` VALUES ('276', '18', '椰果', 'data/images/merchant/23/deerspot_1625146549591.jpg', 'data/images/merchant/23/deerspot_1625146549591.jpg', null, null, '2.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '0.00', '0.00', '2', null, '2021-07-01 21:35:51', '2021-07-01 21:35:51');
INSERT INTO `tb_goods` VALUES ('277', '18', '红豆', 'data/images/merchant/23/deerspot_1625147026980.jpg', 'data/images/merchant/23/deerspot_1625147026980.jpg', null, null, '2.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '0.00', '0.00', '2', null, '2021-07-01 21:43:49', '2021-07-01 21:43:49');
INSERT INTO `tb_goods` VALUES ('278', '18', '布丁', 'data/images/merchant/23/deerspot_1625147158381.jpg', 'data/images/merchant/23/deerspot_1625147158381.jpg', '', null, '2.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '0.00', '0.00', '2', null, '2021-07-01 21:46:00', '2021-07-01 21:46:00');
INSERT INTO `tb_goods` VALUES ('279', '18', '仙草', 'data/images/merchant/23/deerspot_1625147259171.jpg', 'data/images/merchant/23/deerspot_1625147259171.jpg', null, null, '2.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '0.00', '0.00', '2', null, '2021-07-01 21:47:41', '2021-07-01 21:47:41');
INSERT INTO `tb_goods` VALUES ('280', '18', '芝士奶油', 'data/images/merchant/23/deerspot_1625147419502.jpg', 'data/images/merchant/23/deerspot_1625147419502.jpg', null, null, '4.00', '0', '0', '0', '2', '0', '0.00', '0', '0', '0', null, '0.00', '0.00', '4', null, '2021-07-01 21:50:21', '2021-07-01 21:50:21');
-- ----------------------------
-- Table structure for tb_goods_specification
-- ----------------------------
DROP TABLE IF EXISTS `tb_goods_specification`;
CREATE TABLE `tb_goods_specification` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`goods_id` int(11) NOT NULL COMMENT '商品id',
`name` varchar(10) NOT NULL COMMENT '商品规格名称',
`sort_number` int(11) DEFAULT NULL COMMENT '排序号',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1678 DEFAULT CHARSET=utf8 COMMENT='商品规格表';
-- ----------------------------
-- Records of tb_goods_specification
-- ----------------------------
INSERT INTO `tb_goods_specification` VALUES ('141', '28', '规格', '1', '2020-03-23 11:07:24', '2020-03-23 11:07:24');
INSERT INTO `tb_goods_specification` VALUES ('180', '28', '甜度', '2', '2020-03-23 17:26:12', '2020-03-23 17:26:12');
INSERT INTO `tb_goods_specification` VALUES ('181', '33', '规格', '1', '2020-03-24 11:52:53', '2020-03-24 11:52:53');
INSERT INTO `tb_goods_specification` VALUES ('190', '38', '规格', '1', '2020-03-24 12:43:24', '2020-03-24 12:43:24');
INSERT INTO `tb_goods_specification` VALUES ('193', '39', '添加', '2', '2020-03-24 12:46:12', '2020-03-24 12:46:12');
INSERT INTO `tb_goods_specification` VALUES ('194', '39', '温度', '3', '2020-03-24 18:11:09', '2020-03-24 18:11:09');
INSERT INTO `tb_goods_specification` VALUES ('204', '41', '温度', '1', '2020-04-05 00:15:47', '2020-04-05 00:15:47');
INSERT INTO `tb_goods_specification` VALUES ('205', '41', '甜度', '2', '2020-04-05 00:16:55', '2020-04-05 00:16:55');
INSERT INTO `tb_goods_specification` VALUES ('262', '53', '规格', '1', '2020-05-11 13:02:35', '2020-05-11 13:02:35');
INSERT INTO `tb_goods_specification` VALUES ('263', '53', '温度', '2', '2020-05-11 13:02:54', '2020-05-11 13:02:54');
INSERT INTO `tb_goods_specification` VALUES ('264', '53', '甜度', '3', '2020-05-11 13:03:19', '2020-05-11 13:03:19');
INSERT INTO `tb_goods_specification` VALUES ('265', '52', '规格', '1', '2020-05-11 13:03:38', '2020-05-11 13:03:38');
INSERT INTO `tb_goods_specification` VALUES ('266', '52', '温度', '2', '2020-05-11 13:03:49', '2020-05-11 13:03:49');
INSERT INTO `tb_goods_specification` VALUES ('267', '52', '甜度', '3', '2020-05-11 13:03:58', '2020-05-11 13:03:58');
INSERT INTO `tb_goods_specification` VALUES ('268', '51', '温度', '1', '2020-05-11 13:04:23', '2020-05-11 13:04:23');
INSERT INTO `tb_goods_specification` VALUES ('269', '51', '加料', '2', '2020-05-11 13:04:48', '2020-05-11 13:04:48');
INSERT INTO `tb_goods_specification` VALUES ('270', '51', '甜度', '3', '2020-05-11 13:07:02', '2020-05-11 13:07:02');
INSERT INTO `tb_goods_specification` VALUES ('273', '49', '温度', '1', '2020-05-11 13:22:49', '2020-05-11 13:22:49');
INSERT INTO `tb_goods_specification` VALUES ('274', '49', '加料', '2', '2020-05-11 13:23:07', '2020-05-11 13:23:07');
INSERT INTO `tb_goods_specification` VALUES ('275', '49', '甜度', '3', '2020-05-11 13:24:25', '2020-05-11 13:24:25');
INSERT INTO `tb_goods_specification` VALUES ('276', '48', '规格', '1', '2020-05-11 18:05:51', '2020-05-11 18:05:51');
INSERT INTO `tb_goods_specification` VALUES ('277', '48', '温度', '2', '2020-05-11 18:06:00', '2020-05-11 18:06:00');
INSERT INTO `tb_goods_specification` VALUES ('278', '48', '甜度', '3', '2020-05-11 18:06:12', '2020-05-11 18:06:12');
INSERT INTO `tb_goods_specification` VALUES ('279', '47', '规格', '1', '2020-05-11 18:06:38', '2020-05-11 18:06:38');
INSERT INTO `tb_goods_specification` VALUES ('280', '47', '温度', '2', '2020-05-11 18:06:49', '2020-05-11 18:06:49');
INSERT INTO `tb_goods_specification` VALUES ('281', '47', '甜度', '3', '2020-05-11 18:07:09', '2020-05-11 18:07:09');
INSERT INTO `tb_goods_specification` VALUES ('282', '46', '规格', '1', '2020-05-11 18:07:55', '2020-05-11 18:07:55');
INSERT INTO `tb_goods_specification` VALUES ('283', '46', '温度', '2', '2020-05-11 18:08:03', '2020-05-11 18:08:03');
INSERT INTO `tb_goods_specification` VALUES ('284', '46', '甜度', '3', '2020-05-11 18:08:15', '2020-05-11 18:08:15');
INSERT INTO `tb_goods_specification` VALUES ('285', '45', '规格', '1', '2020-05-11 18:08:44', '2020-05-11 18:08:44');
INSERT INTO `tb_goods_specification` VALUES ('289', '39', '加料', '4', '2020-05-11 18:11:01', '2020-05-11 18:11:01');
INSERT INTO `tb_goods_specification` VALUES ('290', '39', '甜度', '5', '2020-05-11 18:11:51', '2020-05-11 18:11:51');
INSERT INTO `tb_goods_specification` VALUES ('291', '45', '加料', '2', '2020-05-11 18:12:38', '2020-05-11 18:12:38');
INSERT INTO `tb_goods_specification` VALUES ('292', '45', '温度', '3', '2020-05-11 18:12:58', '2020-05-11 18:12:58');
INSERT INTO `tb_goods_specification` VALUES ('293', '45', '甜度', '4', '2020-05-11 18:13:10', '2020-05-11 18:13:10');
INSERT INTO `tb_goods_specification` VALUES ('294', '28', '加料', '3', '2020-05-11 18:17:00', '2020-05-11 18:17:00');
INSERT INTO `tb_goods_specification` VALUES ('307', '56', '规格', '1', '2020-05-12 11:14:21', '2020-05-12 11:14:21');
INSERT INTO `tb_goods_specification` VALUES ('308', '56', '加料', '2', '2020-05-12 11:14:27', '2020-05-12 11:14:27');
INSERT INTO `tb_goods_specification` VALUES ('313', '57', '规格', '1', '2020-05-12 17:53:16', '2020-05-12 17:53:16');
INSERT INTO `tb_goods_specification` VALUES ('314', '57', '温度', '2', '2020-05-12 17:53:30', '2020-05-12 17:53:30');
INSERT INTO `tb_goods_specification` VALUES ('319', '58', '规格', '1', '2020-05-13 10:23:40', '2020-05-13 10:23:40');
INSERT INTO `tb_goods_specification` VALUES ('320', '58', '温度', '2', '2020-05-13 10:23:47', '2020-05-13 10:23:47');
INSERT INTO `tb_goods_specification` VALUES ('321', '58', '甜度', '3', '2020-05-13 10:24:01', '2020-05-13 10:24:01');
INSERT INTO `tb_goods_specification` VALUES ('333', '60', '规格', '1', '2020-05-13 11:59:04', '2020-05-13 11:59:04');
INSERT INTO `tb_goods_specification` VALUES ('334', '60', '甜度', '2', '2020-05-13 11:59:25', '2020-05-13 11:59:25');
INSERT INTO `tb_goods_specification` VALUES ('339', '61', '规格', '1', '2020-05-13 13:07:55', '2020-05-13 13:07:55');
INSERT INTO `tb_goods_specification` VALUES ('340', '61', '甜度', '2', '2020-05-13 13:08:06', '2020-05-13 13:08:06');
INSERT INTO `tb_goods_specification` VALUES ('345', '62', '规格', '1', '2020-05-15 14:38:32', '2020-05-15 14:38:32');
INSERT INTO `tb_goods_specification` VALUES ('346', '62', '温度', '2', '2020-05-15 14:38:44', '2020-05-15 14:38:44');
INSERT INTO `tb_goods_specification` VALUES ('351', '63', '规格', '1', '2020-05-15 14:51:46', '2020-05-15 14:51:46');
INSERT INTO `tb_goods_specification` VALUES ('352', '63', '温度', '2', '2020-05-15 14:51:54', '2020-05-15 14:51:54');