-
Notifications
You must be signed in to change notification settings - Fork 148
/
Copy pathshopping.sql
618 lines (594 loc) · 52.6 KB
/
shopping.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
/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50636
Source Host : localhost:3306
Source Database : shopping
Target Server Type : MYSQL
Target Server Version : 50636
File Encoding : 65001
Date: 2018-06-27 08:50:25
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `shopping_active`
-- ----------------------------
DROP TABLE IF EXISTS `shopping_active`;
CREATE TABLE `shopping_active` (
`user_id` bigint(20) unsigned NOT NULL COMMENT '用户id',
`category2_id` bigint(20) unsigned NOT NULL COMMENT '二级类目的id',
`hits` bigint(20) unsigned NOT NULL COMMENT '该用户在该二级类目的点击次数',
PRIMARY KEY (`user_id`,`category2_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of shopping_active
-- ----------------------------
INSERT INTO `shopping_active` VALUES ('1', '1', '1040');
INSERT INTO `shopping_active` VALUES ('1', '2', '837');
INSERT INTO `shopping_active` VALUES ('1', '3', '880');
INSERT INTO `shopping_active` VALUES ('1', '4', '892');
INSERT INTO `shopping_active` VALUES ('1', '5', '969');
INSERT INTO `shopping_active` VALUES ('1', '6', '907');
INSERT INTO `shopping_active` VALUES ('1', '7', '925');
INSERT INTO `shopping_active` VALUES ('1', '8', '1812');
INSERT INTO `shopping_active` VALUES ('1', '9', '1763');
INSERT INTO `shopping_active` VALUES ('1', '10', '1679');
INSERT INTO `shopping_active` VALUES ('1', '11', '1702');
INSERT INTO `shopping_active` VALUES ('1', '12', '1652');
INSERT INTO `shopping_active` VALUES ('1', '13', '65');
INSERT INTO `shopping_active` VALUES ('1', '14', '26');
INSERT INTO `shopping_active` VALUES ('1', '15', '46');
INSERT INTO `shopping_active` VALUES ('1', '16', '37');
INSERT INTO `shopping_active` VALUES ('1', '17', '23');
INSERT INTO `shopping_active` VALUES ('1', '18', '35');
INSERT INTO `shopping_active` VALUES ('1', '19', '35');
INSERT INTO `shopping_active` VALUES ('1', '20', '45');
INSERT INTO `shopping_active` VALUES ('1', '21', '55');
INSERT INTO `shopping_active` VALUES ('1', '22', '135');
INSERT INTO `shopping_active` VALUES ('1', '23', '77');
INSERT INTO `shopping_active` VALUES ('1', '24', '29');
INSERT INTO `shopping_active` VALUES ('1', '25', '98');
INSERT INTO `shopping_active` VALUES ('1', '26', '152');
INSERT INTO `shopping_active` VALUES ('1', '27', '76');
INSERT INTO `shopping_active` VALUES ('1', '28', '69');
INSERT INTO `shopping_active` VALUES ('1', '29', '1413');
INSERT INTO `shopping_active` VALUES ('1', '30', '45');
INSERT INTO `shopping_active` VALUES ('1', '31', '35');
INSERT INTO `shopping_active` VALUES ('1', '32', '28');
INSERT INTO `shopping_active` VALUES ('1', '33', '18');
INSERT INTO `shopping_active` VALUES ('1', '34', '23');
INSERT INTO `shopping_active` VALUES ('1', '35', '18');
INSERT INTO `shopping_active` VALUES ('2', '1', '10');
INSERT INTO `shopping_active` VALUES ('2', '2', '20');
INSERT INTO `shopping_active` VALUES ('2', '3', '30');
INSERT INTO `shopping_active` VALUES ('2', '4', '40');
INSERT INTO `shopping_active` VALUES ('2', '5', '50');
INSERT INTO `shopping_active` VALUES ('2', '6', '60');
INSERT INTO `shopping_active` VALUES ('2', '7', '70');
INSERT INTO `shopping_active` VALUES ('2', '8', '80');
INSERT INTO `shopping_active` VALUES ('2', '9', '90');
INSERT INTO `shopping_active` VALUES ('2', '10', '80');
INSERT INTO `shopping_active` VALUES ('2', '11', '70');
INSERT INTO `shopping_active` VALUES ('2', '12', '60');
INSERT INTO `shopping_active` VALUES ('2', '13', '50');
INSERT INTO `shopping_active` VALUES ('2', '14', '40');
INSERT INTO `shopping_active` VALUES ('2', '15', '30');
INSERT INTO `shopping_active` VALUES ('2', '16', '20');
INSERT INTO `shopping_active` VALUES ('2', '17', '10');
INSERT INTO `shopping_active` VALUES ('2', '18', '20');
INSERT INTO `shopping_active` VALUES ('2', '19', '30');
INSERT INTO `shopping_active` VALUES ('2', '20', '40');
INSERT INTO `shopping_active` VALUES ('2', '21', '50');
INSERT INTO `shopping_active` VALUES ('2', '22', '60');
INSERT INTO `shopping_active` VALUES ('2', '23', '70');
INSERT INTO `shopping_active` VALUES ('2', '24', '80');
INSERT INTO `shopping_active` VALUES ('2', '25', '90');
INSERT INTO `shopping_active` VALUES ('2', '26', '80');
INSERT INTO `shopping_active` VALUES ('2', '27', '70');
INSERT INTO `shopping_active` VALUES ('2', '28', '60');
INSERT INTO `shopping_active` VALUES ('2', '29', '50');
INSERT INTO `shopping_active` VALUES ('2', '30', '40');
INSERT INTO `shopping_active` VALUES ('2', '31', '30');
INSERT INTO `shopping_active` VALUES ('2', '32', '20');
INSERT INTO `shopping_active` VALUES ('2', '33', '10');
INSERT INTO `shopping_active` VALUES ('2', '34', '10');
INSERT INTO `shopping_active` VALUES ('2', '35', '0');
INSERT INTO `shopping_active` VALUES ('3', '1', '10');
INSERT INTO `shopping_active` VALUES ('3', '2', '20');
INSERT INTO `shopping_active` VALUES ('3', '3', '10');
INSERT INTO `shopping_active` VALUES ('3', '4', '40');
INSERT INTO `shopping_active` VALUES ('3', '5', '50');
INSERT INTO `shopping_active` VALUES ('3', '6', '60');
INSERT INTO `shopping_active` VALUES ('3', '7', '0');
INSERT INTO `shopping_active` VALUES ('3', '8', '118');
INSERT INTO `shopping_active` VALUES ('3', '9', '90');
INSERT INTO `shopping_active` VALUES ('3', '10', '80');
INSERT INTO `shopping_active` VALUES ('3', '11', '70');
INSERT INTO `shopping_active` VALUES ('3', '12', '60');
INSERT INTO `shopping_active` VALUES ('3', '13', '10');
INSERT INTO `shopping_active` VALUES ('3', '14', '40');
INSERT INTO `shopping_active` VALUES ('3', '15', '30');
INSERT INTO `shopping_active` VALUES ('3', '16', '20');
INSERT INTO `shopping_active` VALUES ('3', '17', '10');
INSERT INTO `shopping_active` VALUES ('3', '18', '10');
INSERT INTO `shopping_active` VALUES ('3', '19', '30');
INSERT INTO `shopping_active` VALUES ('3', '20', '0');
INSERT INTO `shopping_active` VALUES ('3', '21', '10');
INSERT INTO `shopping_active` VALUES ('3', '22', '60');
INSERT INTO `shopping_active` VALUES ('3', '23', '70');
INSERT INTO `shopping_active` VALUES ('3', '24', '80');
INSERT INTO `shopping_active` VALUES ('3', '25', '90');
INSERT INTO `shopping_active` VALUES ('3', '26', '80');
INSERT INTO `shopping_active` VALUES ('3', '27', '70');
INSERT INTO `shopping_active` VALUES ('3', '28', '60');
INSERT INTO `shopping_active` VALUES ('3', '29', '50');
INSERT INTO `shopping_active` VALUES ('3', '30', '40');
INSERT INTO `shopping_active` VALUES ('3', '31', '10');
INSERT INTO `shopping_active` VALUES ('3', '32', '20');
INSERT INTO `shopping_active` VALUES ('3', '33', '10');
INSERT INTO `shopping_active` VALUES ('3', '34', '10');
INSERT INTO `shopping_active` VALUES ('3', '35', '0');
INSERT INTO `shopping_active` VALUES ('4', '1', '0');
INSERT INTO `shopping_active` VALUES ('4', '2', '0');
INSERT INTO `shopping_active` VALUES ('4', '3', '10');
INSERT INTO `shopping_active` VALUES ('4', '4', '0');
INSERT INTO `shopping_active` VALUES ('4', '5', '50');
INSERT INTO `shopping_active` VALUES ('4', '6', '0');
INSERT INTO `shopping_active` VALUES ('4', '7', '10');
INSERT INTO `shopping_active` VALUES ('4', '8', '80');
INSERT INTO `shopping_active` VALUES ('4', '9', '0');
INSERT INTO `shopping_active` VALUES ('4', '10', '87');
INSERT INTO `shopping_active` VALUES ('4', '11', '0');
INSERT INTO `shopping_active` VALUES ('4', '12', '0');
INSERT INTO `shopping_active` VALUES ('4', '13', '0');
INSERT INTO `shopping_active` VALUES ('4', '14', '40');
INSERT INTO `shopping_active` VALUES ('4', '15', '10');
INSERT INTO `shopping_active` VALUES ('4', '16', '0');
INSERT INTO `shopping_active` VALUES ('4', '17', '0');
INSERT INTO `shopping_active` VALUES ('4', '18', '0');
INSERT INTO `shopping_active` VALUES ('4', '19', '30');
INSERT INTO `shopping_active` VALUES ('4', '20', '0');
INSERT INTO `shopping_active` VALUES ('4', '21', '0');
INSERT INTO `shopping_active` VALUES ('4', '22', '1160');
INSERT INTO `shopping_active` VALUES ('4', '23', '0');
INSERT INTO `shopping_active` VALUES ('4', '24', '80');
INSERT INTO `shopping_active` VALUES ('4', '25', '20');
INSERT INTO `shopping_active` VALUES ('4', '26', '0');
INSERT INTO `shopping_active` VALUES ('4', '27', '0');
INSERT INTO `shopping_active` VALUES ('4', '28', '0');
INSERT INTO `shopping_active` VALUES ('4', '29', '50');
INSERT INTO `shopping_active` VALUES ('4', '30', '0');
INSERT INTO `shopping_active` VALUES ('4', '31', '0');
INSERT INTO `shopping_active` VALUES ('4', '32', '20');
INSERT INTO `shopping_active` VALUES ('4', '33', '10');
INSERT INTO `shopping_active` VALUES ('4', '34', '10');
INSERT INTO `shopping_active` VALUES ('4', '35', '0');
INSERT INTO `shopping_active` VALUES ('5', '1', '10');
INSERT INTO `shopping_active` VALUES ('5', '2', '60');
INSERT INTO `shopping_active` VALUES ('5', '3', '30');
INSERT INTO `shopping_active` VALUES ('5', '4', '10');
INSERT INTO `shopping_active` VALUES ('5', '5', '50');
INSERT INTO `shopping_active` VALUES ('5', '6', '60');
INSERT INTO `shopping_active` VALUES ('5', '7', '70');
INSERT INTO `shopping_active` VALUES ('5', '8', '80');
INSERT INTO `shopping_active` VALUES ('5', '9', '91');
INSERT INTO `shopping_active` VALUES ('5', '10', '80');
INSERT INTO `shopping_active` VALUES ('5', '11', '70');
INSERT INTO `shopping_active` VALUES ('5', '12', '10');
INSERT INTO `shopping_active` VALUES ('5', '13', '20');
INSERT INTO `shopping_active` VALUES ('5', '14', '42');
INSERT INTO `shopping_active` VALUES ('5', '15', '30');
INSERT INTO `shopping_active` VALUES ('5', '16', '20');
INSERT INTO `shopping_active` VALUES ('5', '17', '10');
INSERT INTO `shopping_active` VALUES ('5', '18', '1');
INSERT INTO `shopping_active` VALUES ('5', '19', '10');
INSERT INTO `shopping_active` VALUES ('5', '20', '40');
INSERT INTO `shopping_active` VALUES ('5', '21', '50');
INSERT INTO `shopping_active` VALUES ('5', '22', '10');
INSERT INTO `shopping_active` VALUES ('5', '23', '10');
INSERT INTO `shopping_active` VALUES ('5', '24', '80');
INSERT INTO `shopping_active` VALUES ('5', '25', '10');
INSERT INTO `shopping_active` VALUES ('5', '26', '20');
INSERT INTO `shopping_active` VALUES ('5', '27', '70');
INSERT INTO `shopping_active` VALUES ('5', '28', '60');
INSERT INTO `shopping_active` VALUES ('5', '29', '50');
INSERT INTO `shopping_active` VALUES ('5', '30', '40');
INSERT INTO `shopping_active` VALUES ('5', '31', '10');
INSERT INTO `shopping_active` VALUES ('5', '32', '20');
INSERT INTO `shopping_active` VALUES ('5', '33', '10');
INSERT INTO `shopping_active` VALUES ('5', '34', '10');
INSERT INTO `shopping_active` VALUES ('5', '35', '10');
INSERT INTO `shopping_active` VALUES ('6', '1', '14');
INSERT INTO `shopping_active` VALUES ('6', '2', '60');
INSERT INTO `shopping_active` VALUES ('6', '3', '230');
INSERT INTO `shopping_active` VALUES ('6', '4', '10');
INSERT INTO `shopping_active` VALUES ('6', '5', '50');
INSERT INTO `shopping_active` VALUES ('6', '6', '10');
INSERT INTO `shopping_active` VALUES ('6', '7', '70');
INSERT INTO `shopping_active` VALUES ('6', '8', '1');
INSERT INTO `shopping_active` VALUES ('6', '9', '91');
INSERT INTO `shopping_active` VALUES ('6', '10', '280');
INSERT INTO `shopping_active` VALUES ('6', '11', '70');
INSERT INTO `shopping_active` VALUES ('6', '12', '10');
INSERT INTO `shopping_active` VALUES ('6', '13', '220');
INSERT INTO `shopping_active` VALUES ('6', '14', '42');
INSERT INTO `shopping_active` VALUES ('6', '15', '130');
INSERT INTO `shopping_active` VALUES ('6', '16', '220');
INSERT INTO `shopping_active` VALUES ('6', '17', '10');
INSERT INTO `shopping_active` VALUES ('6', '18', '21');
INSERT INTO `shopping_active` VALUES ('6', '19', '10');
INSERT INTO `shopping_active` VALUES ('6', '20', '40');
INSERT INTO `shopping_active` VALUES ('6', '21', '250');
INSERT INTO `shopping_active` VALUES ('6', '22', '10');
INSERT INTO `shopping_active` VALUES ('6', '23', '210');
INSERT INTO `shopping_active` VALUES ('6', '24', '80');
INSERT INTO `shopping_active` VALUES ('6', '25', '110');
INSERT INTO `shopping_active` VALUES ('6', '26', '20');
INSERT INTO `shopping_active` VALUES ('6', '27', '170');
INSERT INTO `shopping_active` VALUES ('6', '28', '160');
INSERT INTO `shopping_active` VALUES ('6', '29', '50');
INSERT INTO `shopping_active` VALUES ('6', '30', '140');
INSERT INTO `shopping_active` VALUES ('6', '31', '10');
INSERT INTO `shopping_active` VALUES ('6', '32', '20');
INSERT INTO `shopping_active` VALUES ('6', '33', '110');
INSERT INTO `shopping_active` VALUES ('6', '34', '10');
INSERT INTO `shopping_active` VALUES ('6', '35', '10');
-- ----------------------------
-- Table structure for `shopping_car`
-- ----------------------------
DROP TABLE IF EXISTS `shopping_car`;
CREATE TABLE `shopping_car` (
`user_id` bigint(20) unsigned NOT NULL COMMENT '用户id',
`product_id` bigint(20) unsigned NOT NULL COMMENT '商品id',
`product_name` varchar(255) NOT NULL COMMENT '商品的名称',
`gmt_create` datetime NOT NULL COMMENT '记录创建的时间',
`gmt_modified` datetime NOT NULL COMMENT '记录修改的时间',
`is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '逻辑删除的标识',
PRIMARY KEY (`user_id`,`product_id`),
KEY `idx_member` (`user_id`) USING HASH
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of shopping_car
-- ----------------------------
-- ----------------------------
-- Table structure for `shopping_category1`
-- ----------------------------
DROP TABLE IF EXISTS `shopping_category1`;
CREATE TABLE `shopping_category1` (
`category1_id` bigint(100) unsigned NOT NULL AUTO_INCREMENT COMMENT '一级类目id',
`category1_name` varchar(20) NOT NULL COMMENT '一级类目名称',
`category1_record` varchar(255) DEFAULT NULL COMMENT '备注',
`gmt_create` datetime NOT NULL COMMENT '记录创建的时间',
`gmt_modified` datetime NOT NULL COMMENT '记录修改的时间',
`is_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否显示该分类，1显示，0隐藏',
`is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '逻辑删除标识',
PRIMARY KEY (`category1_id`),
KEY `idx_category1_name` (`category1_name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of shopping_category1
-- ----------------------------
INSERT INTO `shopping_category1` VALUES ('1', '女装男装', '此分类为女装男装', '2018-02-24 22:55:02', '2018-02-24 22:55:02', '1', '0');
INSERT INTO `shopping_category1` VALUES ('2', '鞋靴箱包', '此分类为鞋靴箱包', '2018-02-24 22:55:02', '2018-02-24 22:55:02', '1', '0');
INSERT INTO `shopping_category1` VALUES ('3', '日常生活用品', '此分类为日常生活用品', '2018-02-24 22:55:02', '2018-02-24 22:55:02', '1', '0');
INSERT INTO `shopping_category1` VALUES ('4', '珠宝配饰', '此分类为珠宝配饰', '2018-02-24 22:55:02', '2018-02-24 22:55:02', '1', '0');
INSERT INTO `shopping_category1` VALUES ('5', '手机数码', '此分类为手机数码', '2018-02-24 22:55:02', '2018-02-24 22:55:02', '1', '0');
INSERT INTO `shopping_category1` VALUES ('6', '家用电器', '此分类为家用电器', '2018-02-24 22:55:02', '2018-02-24 22:55:02', '1', '0');
INSERT INTO `shopping_category1` VALUES ('7', '食品', '此分类为食品', '2018-02-24 22:55:02', '2018-02-24 22:55:02', '1', '0');
INSERT INTO `shopping_category1` VALUES ('8', '测试类目', '用于测试', '2018-03-19 09:37:57', '2018-03-19 09:37:57', '1', '1');
-- ----------------------------
-- Table structure for `shopping_category2`
-- ----------------------------
DROP TABLE IF EXISTS `shopping_category2`;
CREATE TABLE `shopping_category2` (
`category2_id` bigint(100) unsigned NOT NULL AUTO_INCREMENT COMMENT '二级类目id',
`category2_name` varchar(20) NOT NULL COMMENT '二级类目名称',
`category2_record` varchar(255) DEFAULT NULL COMMENT '二级类目的备注',
`category1_id` bigint(20) NOT NULL COMMENT '所属的一级类目的id',
`gmt_create` datetime NOT NULL COMMENT '记录创建的时间',
`gmt_modified` datetime NOT NULL COMMENT '记录被修改的时间',
`is_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否显示分类，1显示，0隐藏',
`is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '逻辑删除的标识',
PRIMARY KEY (`category2_id`),
KEY `idx_category1_id` (`category1_id`) USING BTREE,
KEY `idx_category2_name` (`category2_name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of shopping_category2
-- ----------------------------
INSERT INTO `shopping_category2` VALUES ('1', '潮流女装', 'fashion', '1', '2018-02-24 23:08:21', '2018-03-09 09:41:03', '1', '0');
INSERT INTO `shopping_category2` VALUES ('2', '初冬羽绒', '默认备注', '1', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('3', '毛皮大衣', '默认备注', '1', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('4', '温暖毛衣', '默认备注', '1', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('5', '精选男装', '默认备注', '1', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('6', '冬季外套', '默认备注', '1', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('7', '羽绒服', '默认备注', '1', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('8', '女鞋', '默认备注', '2', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('9', '短靴', '默认备注', '2', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('10', '男鞋', '默认备注', '2', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('11', '女包', '默认备注', '2', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('12', '男包', '默认备注', '2', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('13', '服饰配件', '默认备注', '3', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('14', '雨伞雨具', '默认备注', '3', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('15', '洗嗮/熨烫', '默认备注', '3', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('16', '净化除味', '默认备注', '3', '2018-02-24 23:08:21', '2018-03-09 16:25:03', '1', '0');
INSERT INTO `shopping_category2` VALUES ('17', '缝纫针织', '默认备注', '3', '2018-02-24 23:08:21', '2018-03-10 08:51:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('18', '骑行装备', '默认备注', '3', '2018-02-24 23:08:21', '2018-03-09 15:39:13', '1', '0');
INSERT INTO `shopping_category2` VALUES ('19', '珠宝首饰', '默认备注', '4', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('20', '时尚饰品', '默认备注', '4', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('21', '品质手表', '默认备注', '4', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('22', '眼镜配饰', '默认备注', '4', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('23', '手机', '默认备注', '5', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('24', '平板', '默认备注', '5', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('25', '电脑', '默认备注', '5', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('26', '相机', '默认备注', '5', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('27', '大家电', '默认备注', '6', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('28', '厨房电器', '默认备注', '6', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('29', '生活电器', '默认备注', '6', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('30', '个户电器', '默认备注', '6', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('31', '办公耗材', '默认备注', '6', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('32', '休闲零食', '默认备注', '7', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('33', '饼干糕点', '默认备注', '7', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('34', '生鲜果蔬', '默认备注', '7', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('35', '粮油干货', '默认备注', '7', '2018-02-24 23:08:21', '2018-02-24 23:08:21', '1', '0');
INSERT INTO `shopping_category2` VALUES ('36', '二级测试类目', '专门用于二级类目的测试', '8', '2018-03-19 09:38:22', '2018-03-19 09:38:22', '1', '1');
-- ----------------------------
-- Table structure for `shopping_order`
-- ----------------------------
DROP TABLE IF EXISTS `shopping_order`;
CREATE TABLE `shopping_order` (
`order_id` bigint(100) unsigned NOT NULL AUTO_INCREMENT COMMENT '订单编号',
`user_id` bigint(100) unsigned NOT NULL COMMENT '谁的订单',
`username` varchar(100) NOT NULL COMMENT '谁的订单',
`order_memo` varchar(255) DEFAULT NULL COMMENT '给卖家的留言',
`address` varchar(255) NOT NULL COMMENT '收获地址',
`mobile` char(11) NOT NULL COMMENT '联系电话',
`status` tinyint(1) unsigned NOT NULL COMMENT '订单状态：0未付款，1已付款，2待发货',
`total` decimal(10,0) unsigned NOT NULL COMMENT '订单总金额',
`gmt_create` datetime NOT NULL COMMENT '订单创建时间',
`gmt_modified` datetime NOT NULL COMMENT '订单修改时间',
`id_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '逻辑删除标识',
PRIMARY KEY (`order_id`),
KEY `idx_status` (`status`) USING HASH,
KEY `idx_user_id` (`user_id`) USING HASH
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of shopping_order
-- ----------------------------
-- ----------------------------
-- Table structure for `shopping_order_item`
-- ----------------------------
DROP TABLE IF EXISTS `shopping_order_item`;
CREATE TABLE `shopping_order_item` (
`item_id` bigint(100) unsigned NOT NULL COMMENT '订单明细id',
`order_id` bigint(100) unsigned NOT NULL DEFAULT '0' COMMENT '订单编号',
`product_id` bigint(100) unsigned NOT NULL DEFAULT '0' COMMENT '商品编号',
`product_num` int(10) unsigned NOT NULL COMMENT '商品数量',
`sub_total` decimal(10,0) unsigned NOT NULL COMMENT '小计',
`gmt_create` datetime NOT NULL COMMENT '记录创建的时间',
`gmt_modified` datetime NOT NULL COMMENT '记录修改的时间',
`is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '逻辑删除标识',
PRIMARY KEY (`item_id`,`order_id`,`product_id`),
UNIQUE KEY `uk_order_product` (`product_id`) USING BTREE,
KEY `idx_order_id` (`order_id`) USING HASH
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of shopping_order_item
-- ----------------------------
-- ----------------------------
-- Table structure for `shopping_product`
-- ----------------------------
DROP TABLE IF EXISTS `shopping_product`;
CREATE TABLE `shopping_product` (
`product_id` bigint(100) unsigned NOT NULL AUTO_INCREMENT COMMENT '商品id',
`product_name` varchar(40) NOT NULL COMMENT '商品名称',
`category1_id` bigint(20) unsigned NOT NULL COMMENT '商品所属的一级类目',
`category2_id` bigint(20) unsigned NOT NULL COMMENT '商品所属的二级类目',
`purchase_price` decimal(30,0) unsigned NOT NULL COMMENT '采购价',
`sale_price` decimal(30,0) unsigned NOT NULL COMMENT '销售价',
`inventory` int(10) unsigned NOT NULL COMMENT '库存',
`hits` bigint(30) unsigned NOT NULL DEFAULT '0' COMMENT '该商品的点击量',
`img_src` varchar(255) NOT NULL COMMENT '图片地址',
`description` varchar(255) NOT NULL COMMENT '商品描述',
`gmt_create` datetime NOT NULL COMMENT '记录创建的时间',
`gmt_modified` datetime NOT NULL COMMENT '记录修改的日期',
`is_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否展示该商品，1展示，0隐藏',
`is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '逻辑删除标识',
PRIMARY KEY (`product_id`),
KEY `idx_category1_id` (`category1_id`) USING HASH,
KEY `idx_category2_id` (`category2_id`) USING HASH
) ENGINE=InnoDB AUTO_INCREMENT=114 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of shopping_product
-- ----------------------------
INSERT INTO `shopping_product` VALUES ('1', '时尚潮流女装', '1', '1', '280', '998', '100', '66', '/images/product/women_man_clothes/cs10001.jpg', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '0');
INSERT INTO `shopping_product` VALUES ('2', '坦博尔羽绒服', '1', '2', '380', '1098', '100', '1', '/images/product/women_man_clothes/cs10002.jpg', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '0');
INSERT INTO `shopping_product` VALUES ('3', '貂皮大衣', '1', '3', '380', '1098', '100', '0', '/images/product/women_man_clothes/cs10003.jpg', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '0');
INSERT INTO `shopping_product` VALUES ('4', '情侣毛衣111', '1', '1', '111', '1111', '10011', '0', '/images/product/a2677116-5d04-4d22-8a68-6c52a0a2995d.jpg', '爆款特卖aaaaa', '2018-03-13 09:29:15', '2018-03-18 16:54:04', '1', '0');
INSERT INTO `shopping_product` VALUES ('5', '海澜之家男装', '1', '5', '380', '1998', '100', '61', '/images/product/women_man_clothes/cs60010.png', '爆款特卖', '2018-03-13 09:29:15', '2018-03-23 23:37:24', '1', '0');
INSERT INTO `shopping_product` VALUES ('6', '冬季卫衣', '1', '6', '380', '1098', '100', '23', '/images/product/women_man_clothes/cs70007.png', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '0');
INSERT INTO `shopping_product` VALUES ('7', '深冬羽绒', '1', '7', '380', '1098', '100', '6', '/images/product/women_man_clothes/cs70010.png', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '0');
INSERT INTO `shopping_product` VALUES ('12', '高跟鞋', '2', '8', '120', '320', '100', '1', '/images/product/shoes_package/100102.png', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '0');
INSERT INTO `shopping_product` VALUES ('13', '女士短靴', '2', '9', '120', '320', '100', '0', '/images/product/shoes_package/100101.png', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '0');
INSERT INTO `shopping_product` VALUES ('14', '鳄鱼皮鞋', '2', '10', '120', '320', '100', '3', '/images/product/shoes_package/10004.png', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '0');
INSERT INTO `shopping_product` VALUES ('15', '香奈儿包包', '2', '11', '120', '320', '100', '0', '/images/product/shoes_package/', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '1');
INSERT INTO `shopping_product` VALUES ('16', '男士公文包', '2', '12', '120', '320', '100', '0', '/images/product/shoes_package/', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '1');
INSERT INTO `shopping_product` VALUES ('17', '红领巾', '3', '13', '120', '320', '100', '0', '/images/product/life_thing/', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '1');
INSERT INTO `shopping_product` VALUES ('18', '共享雨伞', '3', '14', '120', '320', '100', '0', '/images/product/life_thing/', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '1');
INSERT INTO `shopping_product` VALUES ('19', '电熨斗', '3', '15', '120', '320', '100', '0', '/images/product/life_thing/', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '1');
INSERT INTO `shopping_product` VALUES ('20', '除湿剂', '3', '16', '120', '320', '100', '0', '/images/product/life_thing/', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '1');
INSERT INTO `shopping_product` VALUES ('21', '缝纫机', '3', '17', '120', '320', '100', '0', '/images/product/life_thing/', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '1');
INSERT INTO `shopping_product` VALUES ('22', '车轮胎', '3', '18', '120', '320', '100', '0', '/images/product/life_thing/', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '1');
INSERT INTO `shopping_product` VALUES ('23', '帅气墨镜', '4', '22', '120', '320', '100', '1', '/images/product/jewellery/10007.png', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '0');
INSERT INTO `shopping_product` VALUES ('24', '潜水眼镜', '4', '22', '120', '320', '100', '49', '/images/product/jewellery/10008.png', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '0');
INSERT INTO `shopping_product` VALUES ('25', '北极星手表', '4', '21', '120', '320', '100', '0', '/images/product/jewellery/10013.png', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '0');
INSERT INTO `shopping_product` VALUES ('26', '学生眼镜', '4', '22', '120', '320', '100', '3', '/images/product/jewellery/10010.png', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '0');
INSERT INTO `shopping_product` VALUES ('27', '香蕉手机', '5', '23', '120', '320', '100', '0', '/product/mobile_phone/', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '1');
INSERT INTO `shopping_product` VALUES ('28', '草莓平板', '5', '24', '120', '320', '100', '0', '/product/mobile_phone/', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '1');
INSERT INTO `shopping_product` VALUES ('29', '联想电脑', '5', '25', '120', '320', '100', '0', '/product/mobile_phone/', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '1');
INSERT INTO `shopping_product` VALUES ('30', '摩卡相机', '5', '26', '120', '320', '100', '0', '/product/mobile_phone/', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '1');
INSERT INTO `shopping_product` VALUES ('31', '电视机', '1', '1', '120', '320', '100', '0', '/images/product/fa753768-398b-4cc6-9fd7-f3564fa56ccf.jpg', '爆款特卖', '2018-03-13 09:29:15', '2018-03-25 22:32:06', '1', '1');
INSERT INTO `shopping_product` VALUES ('32', '抽油烟机', '1', '1', '120', '320', '100', '0', '/images/product/0f06771a-0389-4ece-bdf4-77b33f05065f.jpg', '爆款特卖', '2018-03-13 09:29:15', '2018-03-25 22:33:09', '1', '1');
INSERT INTO `shopping_product` VALUES ('33', '豆浆机', '6', '29', '120', '320', '100', '0', '/product/life_thing/', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '1');
INSERT INTO `shopping_product` VALUES ('34', '充电器', '6', '30', '120', '320', '100', '0', '/product/life_thing/', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '1');
INSERT INTO `shopping_product` VALUES ('35', '办公袋', '6', '31', '120', '320', '100', '0', '/product/life_thing/', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '1');
INSERT INTO `shopping_product` VALUES ('36', '薯片', '7', '32', '120', '320', '100', '0', '/product/food/', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '1');
INSERT INTO `shopping_product` VALUES ('37', '蛋挞', '7', '33', '120', '320', '100', '0', '/product/food/', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '1');
INSERT INTO `shopping_product` VALUES ('38', '盒马生鲜', '7', '34', '120', '320', '100', '0', '/product/food/', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '1');
INSERT INTO `shopping_product` VALUES ('39', '7+1粮油', '7', '35', '120', '320', '100', '0', '/product/food/', '爆款特卖', '2018-03-13 09:29:15', '2018-03-13 09:29:15', '1', '1');
INSERT INTO `shopping_product` VALUES ('56', '美妆', '1', '1', '11', '1', '1', '0', '/images/product/9426e270-d6f2-44e3-bf1f-9a91aa16259e.jpg', '嗯恩恩嫩恩恩额额', '2018-03-18 16:15:35', '2018-03-18 17:00:42', '1', '1');
INSERT INTO `shopping_product` VALUES ('57', '测试商品', '3', '15', '100', '230', '200', '0', '/www', '测试描述', '2018-03-18 17:10:32', '2018-03-18 17:10:32', '1', '1');
INSERT INTO `shopping_product` VALUES ('58', '测试商品', '8', '36', '110', '1110', '12', '0', '/images/product/fc9dae9d-c523-47db-8f81-d8fddaea2c9b.jpg', '多级反馈角度看', '2018-03-19 09:39:03', '2018-03-19 09:40:07', '1', '1');
INSERT INTO `shopping_product` VALUES ('59', 'test', '8', '36', '998', '1998', '112', '0', '/images/product/cd263942-cdd5-432b-91b0-b77dcf5be1f5.jpg', '爆款', '2018-03-19 09:42:45', '2018-03-19 09:42:45', '1', '1');
INSERT INTO `shopping_product` VALUES ('60', '测试商品二', '8', '36', '333', '23', '45', '0', '/images/product/698b8450-f167-44a5-ac0a-ee72db034862.jpg', '这是测试二', '2018-03-19 18:39:37', '2018-03-19 18:39:37', '1', '1');
INSERT INTO `shopping_product` VALUES ('61', '21212', '8', '36', '787', '7878', '777', '0', '/images/product/b7b788f6-838f-4999-8c86-cdbbe8e85ef8.jpg', 'qqwqw', '2018-03-19 18:48:15', '2018-03-19 18:48:15', '1', '1');
INSERT INTO `shopping_product` VALUES ('62', '34434', '8', '36', '1212', '12', '33', '0', '/images/product/0cb5afa5-a6b6-48ab-9879-fd34e83d8cf5.jpg', 'ddddd', '2018-03-19 18:49:25', '2018-03-19 18:49:25', '1', '1');
INSERT INTO `shopping_product` VALUES ('63', '11', '8', '36', '11', '1', '1', '0', '/images/product/682aa30e-846c-4913-8655-fd0705b44734.jpg', '111', '2018-03-19 18:57:38', '2018-03-19 18:57:38', '1', '1');
INSERT INTO `shopping_product` VALUES ('64', '2', '8', '36', '2', '2', '2', '0', '/images/product/5b2c86d3-e1c7-49f7-8944-3880b64bdcb0.jpg', '2', '2018-03-19 18:57:56', '2018-03-19 18:57:56', '1', '1');
INSERT INTO `shopping_product` VALUES ('65', '潮流女装', '1', '1', '123', '232', '12', '115', '/images/product/192737e5-cc30-4d28-933e-b8a0a2d2f564.png', 'dfdsfsdf', '2018-03-23 23:50:34', '2018-03-23 23:50:34', '1', '0');
INSERT INTO `shopping_product` VALUES ('66', '男装', '1', '5', '345', '543', '232', '0', '/images/product/2b2bd253-0a61-4414-8f6f-c41867cfc220.png', '地方大幅度发', '2018-03-23 23:51:11', '2018-03-23 23:51:11', '1', '0');
INSERT INTO `shopping_product` VALUES ('67', '外套外套', '1', '6', '111', '333', '23', '1', '/images/product/4d094fb0-7185-42a3-bf40-c299ff30a4e2.png', '打发打发', '2018-03-23 23:53:03', '2018-03-23 23:53:03', '1', '0');
INSERT INTO `shopping_product` VALUES ('68', '毛衣', '1', '4', '34', '3434', '12', '1', '/images/product/e81cb1c2-452e-4518-8efd-c3d9027d2c47.jpg', '的方法打发打发', '2018-03-23 23:54:31', '2018-03-23 23:54:31', '1', '0');
INSERT INTO `shopping_product` VALUES ('69', '女鞋', '2', '8', '34', '555', '323', '1', '/images/product/00816061-f842-472d-be8a-bd6da92b2a5e.jpg', '333233', '2018-03-23 23:56:01', '2018-03-23 23:56:01', '1', '0');
INSERT INTO `shopping_product` VALUES ('70', '女鞋', '2', '9', '123', '32', '656', '57', '/images/product/b069d414-b0f4-4ca1-8e91-fb77a40fce43.png', '', '2018-03-23 23:56:20', '2018-03-23 23:56:20', '1', '0');
INSERT INTO `shopping_product` VALUES ('71', '女鞋', '2', '8', '444', '666', '23', '0', '/images/product/c86e8259-cd5f-4df2-901f-a0cc78527c46.png', '复古风格', '2018-03-23 23:56:40', '2018-03-23 23:56:40', '1', '0');
INSERT INTO `shopping_product` VALUES ('72', '电视机', '6', '27', '1212', '33', '121', '0', '', '1', '2018-03-25 15:01:54', '2018-03-25 15:01:54', '1', '1');
INSERT INTO `shopping_product` VALUES ('73', '电视机', '6', '27', '3', '3', '55', '0', '', '', '2018-03-25 15:02:21', '2018-03-25 15:02:21', '1', '1');
INSERT INTO `shopping_product` VALUES ('74', '电视机', '6', '27', '121', '21', '3', '0', '', 'f', '2018-03-25 15:02:36', '2018-03-25 15:02:36', '1', '1');
INSERT INTO `shopping_product` VALUES ('75', '外套外套', '1', '6', '12', '23', '23', '0', '/images/product/f985ec77-cf40-4eb5-9140-ed936d8ab64d.png', '232323', '2018-03-25 16:26:41', '2018-03-25 16:26:41', '1', '0');
INSERT INTO `shopping_product` VALUES ('76', '外套外套', '1', '6', '232', '23', '23', '0', '/images/product/a1cdb333-7816-44c8-a537-be842f519019.png', '2323', '2018-03-25 16:27:08', '2018-03-25 16:27:08', '1', '0');
INSERT INTO `shopping_product` VALUES ('77', '外套外套', '1', '6', '7878', '78', '23', '3', '/images/product/df40521b-68a3-4dd7-9912-7be87ce79780.png', '撒大声地撒多', '2018-03-25 16:27:46', '2018-03-25 16:27:46', '1', '0');
INSERT INTO `shopping_product` VALUES ('78', '服饰配件', '3', '13', '56', '56', '56', '0', '', '56', '2018-03-25 22:22:57', '2018-03-25 22:22:57', '1', '1');
INSERT INTO `shopping_product` VALUES ('79', '服饰配件', '3', '13', '67', '67', '67', '0', '', '6767', '2018-03-25 22:23:10', '2018-03-25 22:23:10', '1', '1');
INSERT INTO `shopping_product` VALUES ('80', '服饰配件', '3', '14', '54', '64', '45', '0', '', '', '2018-03-25 22:23:27', '2018-03-25 22:23:27', '1', '1');
INSERT INTO `shopping_product` VALUES ('81', '眼镜', '4', '22', '34', '34', '34', '0', '', '5353', '2018-03-25 22:24:15', '2018-03-25 22:24:15', '1', '1');
INSERT INTO `shopping_product` VALUES ('82', '眼镜', '4', '22', '111', '12', '32', '0', '/images/product/9ad6911b-84a5-4d4b-96f8-64a444a6b0ad.png', '232', '2018-03-25 22:24:41', '2018-03-25 22:24:41', '1', '1');
INSERT INTO `shopping_product` VALUES ('83', '眼镜', '4', '22', '454', '211', '334', '0', '/images/product/f34fed19-e5ec-4c62-a9c1-a51a5a9cbec7.png', '', '2018-03-25 22:25:00', '2018-03-25 22:25:00', '1', '1');
INSERT INTO `shopping_product` VALUES ('84', '眼镜', '4', '22', '54', '54', '64', '0', '/images/product/61fa9d31-4713-4c86-8389-b17f8b6fe28e.png', '梵蒂冈的风格', '2018-03-25 22:25:21', '2018-03-25 22:25:21', '1', '1');
INSERT INTO `shopping_product` VALUES ('85', '手机', '5', '23', '21', '21', '21', '0', '/images/product/aef79d1f-0a64-450e-8dc2-b827a1d79a2e.jpg', '21', '2018-03-25 22:27:05', '2018-03-25 22:27:05', '1', '0');
INSERT INTO `shopping_product` VALUES ('86', '手机', '5', '23', '4444', '4444', '123', '0', '/images/product/22eadcba-e87d-4f6e-9f41-a1fc5cb44b53.jpg', '2323', '2018-03-25 22:27:41', '2018-03-25 22:27:41', '1', '0');
INSERT INTO `shopping_product` VALUES ('87', '平板', '5', '24', '121', '313', '232', '1', '/images/product/0c3f749d-407e-4b0a-ba3a-ba2083d3489d.jpg', '是的是的', '2018-03-25 22:28:45', '2018-03-25 22:28:45', '1', '0');
INSERT INTO `shopping_product` VALUES ('88', '电脑', '5', '25', '23', '23', '23', '1', '/images/product/7dbd8efd-4429-4b5d-9bc8-e56056837fa1.jpg', '水电费第三方', '2018-03-25 22:29:32', '2018-03-25 22:29:32', '1', '0');
INSERT INTO `shopping_product` VALUES ('89', '相机', '5', '26', '23', '232', '424', '62', '/images/product/57411a8c-1531-4fac-ada2-eb02d28471eb.jpg', '地方斯蒂芬', '2018-03-25 22:30:22', '2018-03-25 22:30:22', '1', '0');
INSERT INTO `shopping_product` VALUES ('90', '电视机', '6', '29', '1212', '3131', '12', '0', '/images/product/c85965ef-dd30-421c-91f2-e0a04b646611.jpg', '是的发顺丰', '2018-03-25 22:35:38', '2018-03-25 22:35:38', '1', '0');
INSERT INTO `shopping_product` VALUES ('91', '电视机', '6', '29', '232', '2323', '12', '0', '/images/product/4c8ae988-3339-4f6c-9cf9-1919c1194a82.jpg', '的的非官方', '2018-03-25 22:36:33', '2018-03-25 22:36:33', '1', '0');
INSERT INTO `shopping_product` VALUES ('92', '电视机', '6', '29', '1212', '2323', '12', '0', '/images/product/6cf01a7f-f55e-4067-adff-c79dadc9f27e.jpg', '第三方的所发生的', '2018-03-25 22:37:17', '2018-03-25 22:37:17', '1', '0');
INSERT INTO `shopping_product` VALUES ('93', '电视机', '6', '29', '34', '3434', '21', '1248', '/images/product/ce00d849-71ce-46ea-8617-340a638219b9.jpg', '帝国时代发', '2018-03-25 22:37:46', '2018-03-25 22:37:46', '1', '0');
INSERT INTO `shopping_product` VALUES ('94', '抽油烟机', '6', '28', '34', '2323', '121', '1', '/images/product/1f0e977e-64c4-4d32-8506-0e905cdd8513.jpg', '大幅度所发生的', '2018-03-25 22:38:55', '2018-03-25 22:38:55', '1', '0');
INSERT INTO `shopping_product` VALUES ('95', '办公电脑', '6', '31', '1212', '323', '23', '0', '/images/product/a572f426-d01e-46ef-aa5e-4f61d2c01928.jpg', '是的是的', '2018-03-25 22:39:46', '2018-03-25 22:39:46', '1', '0');
INSERT INTO `shopping_product` VALUES ('96', '薯片', '7', '32', '3242', '3434', '121', '0', '/images/product/ad55c435-2322-470c-bb7c-4d9116d869d8.jpg', '地方大幅度', '2018-03-25 22:41:47', '2018-03-25 22:41:47', '1', '0');
INSERT INTO `shopping_product` VALUES ('97', '蔬菜', '7', '34', '3434', '3434', '1213', '1', '/images/product/bd13d505-1b39-4302-b4ea-fca1ddf80046.jpg', '地方水电费孙大夫', '2018-03-25 22:42:49', '2018-03-25 22:42:49', '1', '0');
INSERT INTO `shopping_product` VALUES ('98', '蛋糕', '7', '33', '1343', '232', '121', '0', '/images/product/b847907b-9045-45ea-8854-1bf3e5e6a385.jpg', '2132', '2018-03-25 22:43:39', '2018-03-25 22:43:39', '1', '0');
INSERT INTO `shopping_product` VALUES ('99', '粮油', '7', '35', '343', '232', '123', '0', '/images/product/fcf590e2-2559-497c-91b9-1e09ca1230b0.jpg', '的发送端发送端', '2018-03-25 22:44:16', '2018-03-25 22:44:16', '1', '0');
INSERT INTO `shopping_product` VALUES ('100', '服饰配件', '3', '13', '2323', '121', '232', '1', '/images/product/eb50d812-776e-4f63-8cfe-4727435acfd7.jpg', '的发送端发送端', '2018-03-25 22:48:04', '2018-03-25 22:48:04', '1', '0');
INSERT INTO `shopping_product` VALUES ('101', '抽油烟机', '3', '13', '232', '2323', '21', '0', '/images/product/3fa1b40b-b16b-4035-bb55-bba3e180a580.jpg', '斯蒂芬斯蒂芬', '2018-03-25 22:48:49', '2018-03-25 22:48:49', '1', '0');
INSERT INTO `shopping_product` VALUES ('102', '雨伞雨具', '3', '14', '3434', '232', '232', '0', '/images/product/d14feaa2-f5ab-42de-833c-0a6610b75020.jpg', '大范甘迪发', '2018-03-25 22:49:48', '2018-03-25 22:49:48', '1', '0');
INSERT INTO `shopping_product` VALUES ('103', '净化除味', '3', '16', '3434', '23', '2213', '0', '/images/product/02fcf591-e811-4e8e-9bdf-291860edc11b.jpg', '发鬼地方', '2018-03-25 22:50:29', '2018-03-25 22:50:29', '1', '0');
INSERT INTO `shopping_product` VALUES ('104', '骑行装备', '3', '18', '2323', '1231', '23', '0', '/images/product/68a27541-78bf-4a7d-ab73-7946a0ca0226.jpg', '打发打发', '2018-03-25 22:51:13', '2018-03-25 22:51:13', '1', '0');
INSERT INTO `shopping_product` VALUES ('105', '缝纫针织', '3', '17', '343', '232', '232', '0', '/images/product/414344b0-14cc-4cae-a092-3a6f230e80b6.jpg', '地方', '2018-03-25 22:52:16', '2018-03-25 22:52:16', '1', '0');
INSERT INTO `shopping_product` VALUES ('106', '熨斗', '3', '15', '343', '2323', '11', '0', '/images/product/ce62b5e6-1a2e-4ded-9678-0e8c65607f06.jpg', '地方', '2018-03-25 22:53:09', '2018-03-25 22:53:09', '1', '0');
INSERT INTO `shopping_product` VALUES ('107', '女包', '2', '11', '23', '23', '23', '0', '/images/product/b32bcd04-aaf7-4f32-9028-beeea11ac367.jpg', '二恶烷若', '2018-03-25 22:57:11', '2018-03-25 22:57:11', '1', '0');
INSERT INTO `shopping_product` VALUES ('108', '男包', '2', '12', '1212', '313', '12', '0', '/images/product/132c9627-4a84-4b7f-bdc5-ba8e51caadc5.jpg', 'SDR孙大夫', '2018-03-25 22:58:14', '2018-03-25 22:58:14', '1', '0');
INSERT INTO `shopping_product` VALUES ('109', '品质手表', '4', '21', '1212', '2323', '121', '0', '/images/product/4c563ae1-f550-4a83-bbc0-e0c6324d0a9b.png', '谁是谁的谁多所', '2018-03-25 22:59:54', '2018-03-25 22:59:54', '1', '0');
INSERT INTO `shopping_product` VALUES ('110', '钻戒', '4', '19', '99999', '99999', '121', '0', '/images/product/59f94f8b-9eea-478d-aa0f-d054becd0b91.jpg', '打发打发是', '2018-03-25 23:01:12', '2018-03-25 23:01:12', '1', '0');
INSERT INTO `shopping_product` VALUES ('111', '时尚饰品', '4', '20', '3435', '123', '1223', '0', '/images/product/77131fe2-d50f-46c0-b20d-e2057ef403e9.jpg', '打发打发', '2018-03-25 23:02:35', '2018-03-25 23:02:35', '1', '0');
INSERT INTO `shopping_product` VALUES ('112', '大冰箱', '6', '27', '5555', '3434', '1212', '0', '/images/product/dec3c318-9fdb-4afe-8533-86afa678b481.jpg', '肥嘟嘟', '2018-03-25 23:03:53', '2018-03-25 23:03:53', '1', '0');
INSERT INTO `shopping_product` VALUES ('113', '个户电器', '6', '30', '3434', '232', '121', '0', '/images/product/cabad2d6-a8cc-47f1-8358-08adf350f8f9.jpg', '打发打发', '2018-03-25 23:05:13', '2018-03-25 23:05:13', '1', '0');
-- ----------------------------
-- Table structure for `shopping_similarity`
-- ----------------------------
DROP TABLE IF EXISTS `shopping_similarity`;
CREATE TABLE `shopping_similarity` (
`user_id` bigint(20) NOT NULL COMMENT '用户id',
`user_ref_id` bigint(20) NOT NULL COMMENT '被参考的用户id',
`similarity` decimal(8,7) NOT NULL COMMENT 'user_id与user_ref_id之间的相似度',
PRIMARY KEY (`user_id`,`user_ref_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of shopping_similarity
-- ----------------------------
INSERT INTO `shopping_similarity` VALUES ('1', '2', '0.9994891');
INSERT INTO `shopping_similarity` VALUES ('1', '3', '0.9510095');
INSERT INTO `shopping_similarity` VALUES ('1', '4', '0.6101699');
INSERT INTO `shopping_similarity` VALUES ('1', '5', '0.8290315');
INSERT INTO `shopping_similarity` VALUES ('1', '6', '0.7550847');
INSERT INTO `shopping_similarity` VALUES ('2', '3', '0.9514955');
INSERT INTO `shopping_similarity` VALUES ('2', '4', '0.6104818');
INSERT INTO `shopping_similarity` VALUES ('2', '5', '0.8284235');
INSERT INTO `shopping_similarity` VALUES ('2', '6', '0.7550809');
INSERT INTO `shopping_similarity` VALUES ('3', '4', '0.6408098');
INSERT INTO `shopping_similarity` VALUES ('3', '5', '0.7858549');
INSERT INTO `shopping_similarity` VALUES ('3', '6', '0.6873625');
INSERT INTO `shopping_similarity` VALUES ('4', '5', '0.6673668');
INSERT INTO `shopping_similarity` VALUES ('4', '6', '0.5847285');
INSERT INTO `shopping_similarity` VALUES ('5', '6', '0.7201599');
-- ----------------------------
-- Table structure for `shopping_sys_admin`
-- ----------------------------
DROP TABLE IF EXISTS `shopping_sys_admin`;
CREATE TABLE `shopping_sys_admin` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户id',
`login_name` varchar(255) NOT NULL COMMENT '登录名',
`admin_name` varchar(255) NOT NULL COMMENT '用户名',
`password` varchar(255) NOT NULL COMMENT '密码',
`email` varchar(255) NOT NULL COMMENT '邮箱',
`mobile` char(11) NOT NULL COMMENT '移动电话',
`age` tinyint(3) unsigned NOT NULL COMMENT '年龄',
`sex` char(1) NOT NULL DEFAULT '男',
`address` varchar(255) NOT NULL COMMENT '用户地址',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '用户状态：0正常，1冻结',
`gmt_create` datetime NOT NULL COMMENT '用户创建的时间',
`gmt_modified` datetime NOT NULL COMMENT '用户修改的时间',
`is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '逻辑删除的标识',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_login_name` (`login_name`) USING HASH,
KEY `idx_username` (`admin_name`) USING BTREE,
KEY `idx_status` (`status`) USING HASH
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of shopping_sys_admin
-- ----------------------------
INSERT INTO `shopping_sys_admin` VALUES ('1', 'admin', '曲健磊', '8c20ee34f92493fe6bb33aa59d317d54534e7f7b3a0cd7a7b3602c66', '909301740@qq.com', '13954501821', '23', '男', '山东', '0', '2018-02-24 23:13:46', '2018-03-07 19:09:17', '0');
INSERT INTO `shopping_sys_admin` VALUES ('3', 'xiaoming', '小明', '6db577c1eab45ca48c56a0fe6d45189e5ac9cda9dcf0f73ad33343ee', '994564536@qq.com', '13765648897', '18', '女', '深圳', '0', '2018-02-26 19:12:13', '2018-02-26 19:12:13', '0');
INSERT INTO `shopping_sys_admin` VALUES ('4', 'array', '小王', 'f8ac215f6525bf6009278bdd9c7404f458116aa0bbc90f426b3255dd', '776546342@qq.com', '17806342234', '40', '男', '广东', '0', '2018-02-26 21:44:39', '2018-02-26 21:44:39', '0');
INSERT INTO `shopping_sys_admin` VALUES ('5', 'ss', 'qqq', '049a6c279f4e05bc1620d8b2497a44fdc16b2f8204409f045a8f7b80', '22222@qq.com', '12222222222', '112', '女', '1111111111', '0', '2018-02-27 18:58:07', '2018-02-28 21:28:17', '1');
INSERT INTO `shopping_sys_admin` VALUES ('7', 'dd', '小亮红', '7c5bb92486cd4972a802e3dbc665a4dcc52fd1fb2cd9d7f4e0009505', '991281927@qq.com', '15753506293', '43', '女', 'dfdfdf', '0', '2018-02-27 19:06:13', '2018-03-03 19:45:44', '0');
INSERT INTO `shopping_sys_admin` VALUES ('8', 'qwq', '小明', '5f27f07d1184afe2518c5e701db51e9084ea3cfb484467f84c9c5932', '1212', '12111111111', '121', '男', 'dfsdfsd', '0', '2018-02-27 19:08:33', '2018-03-03 20:05:19', '0');
INSERT INTO `shopping_sys_admin` VALUES ('9', 'xiaohua', '小花', '63da62e7d3df8355ee4b2ef9aadb9b56004f815b9f9ae3383b74075c', '545434323@qq.com', '14653436453', '25', '女', '张家口', '0', '2018-02-28 18:33:46', '2018-02-28 18:33:46', '0');
INSERT INTO `shopping_sys_admin` VALUES ('10', 'hello', '老刘', 'cd3ac2193579104915b77f19575a4eb84a53d92866b7bf4b91d43be1', '9098765651@qq.com', '11111111111', '111', '男', '深圳1', '0', '2018-02-28 18:35:59', '2018-03-02 14:29:56', '0');
INSERT INTO `shopping_sys_admin` VALUES ('11', 'zhangsan', '张珊', 'd4edb5264405b1f9d2a0acedb9732a092b4f3e3470013440095dd60e', '1212@qq.com', '12345678767', '21', '女', '广州', '0', '2018-02-28 18:38:33', '2018-02-28 18:38:33', '0');
INSERT INTO `shopping_sys_admin` VALUES ('12', 'df', 'd', '39e1cd85220ca3f21ab572b2c8b9be504f14c1c2c1f0426ce158fbb4', '1', '11111111111', '12', '女', '1', '0', '2018-02-28 18:40:54', '2018-02-28 18:40:54', '1');
INSERT INTO `shopping_sys_admin` VALUES ('13', 'zw', '赵武', '26a10b10e941fb994be6821508f812f6d356a433d6c99acde060f00e', '12121@qq.com', '11245343546', '18', '男', 'China', '0', '2018-03-03 14:06:44', '2018-03-03 14:06:44', '0');
-- ----------------------------
-- Table structure for `shopping_sys_member`
-- ----------------------------
DROP TABLE IF EXISTS `shopping_sys_member`;
CREATE TABLE `shopping_sys_member` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户id',
`login_name` varchar(255) NOT NULL COMMENT '登录名',
`member_name` varchar(255) NOT NULL COMMENT '用户名',
`password` varchar(255) NOT NULL COMMENT '密码',
`email` varchar(255) NOT NULL COMMENT '邮箱',
`mobile` char(11) NOT NULL COMMENT '移动电话',
`age` tinyint(3) unsigned NOT NULL COMMENT '年龄',
`sex` char(1) NOT NULL DEFAULT '男',
`address` varchar(255) NOT NULL COMMENT '用户地址',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '用户状态：0正常，1冻结',
`gmt_create` datetime NOT NULL COMMENT '用户创建的时间',
`gmt_modified` datetime NOT NULL COMMENT '用户修改的时间',
`is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '逻辑删除的标识',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_login_name` (`login_name`) USING HASH,
KEY `idx_username` (`member_name`) USING BTREE,
KEY `idx_status` (`status`) USING HASH
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of shopping_sys_member
-- ----------------------------
INSERT INTO `shopping_sys_member` VALUES ('1', 'cus1', '曲健磊h', '8c20ee34f92493fe6bb33aa59d317d54534e7f7b3a0cd7a7b3602c66', '909301740@qq.com', '15653577659', '21', '男', '山东', '0', '2018-02-24 23:13:46', '2018-02-24 23:13:46', '0');
INSERT INTO `shopping_sys_member` VALUES ('3', 'cus2', '小明h', '6db577c1eab45ca48c56a0fe6d45189e5ac9cda9dcf0f73ad33343ee', '994564536@qq.com', '13765648897', '18', '女', '深圳', '0', '2018-02-26 19:12:13', '2018-02-26 19:12:13', '0');
INSERT INTO `shopping_sys_member` VALUES ('4', 'cus3', '小王h', 'f8ac215f6525bf6009278bdd9c7404f458116aa0bbc90f426b3255dd', '776546342@qq.com', '17806342234', '40', '女', '广东', '0', '2018-02-26 21:44:39', '2018-04-17 19:19:06', '0');
INSERT INTO `shopping_sys_member` VALUES ('5', 'cus4', '老李h', '049a6c279f4e05bc1620d8b2497a44fdc16b2f8204409f045a8f7b80', '223487656@qq.com', '13876464546', '41', '男', '山东', '0', '2018-02-27 18:58:07', '2018-02-27 18:58:07', '0');
INSERT INTO `shopping_sys_member` VALUES ('7', 'cus5', '小红h', '7c5bb92486cd4972a802e3dbc665a4dcc52fd1fb2cd9d7f4e0009505', '1212', '12121212121', '21', '女', 'dfdfdf', '0', '2018-02-27 19:06:13', '2018-02-27 19:06:13', '0');
INSERT INTO `shopping_sys_member` VALUES ('8', 'hhone', '会员一号', '801d4668e38c0e9881ec03daf82296298084c6d544a8b9cf8919eb6f', '123@163.com', '12345454345', '34', '男', '深圳', '0', '2018-04-17 19:20:31', '2018-04-17 19:20:31', '0');
INSERT INTO `shopping_sys_member` VALUES ('11', 'tt_y', '131331', '6ae921a23d34dec7689b388e7064d4271ad361e3d7010fd602d8761e', '123@163.com', 'efsdf', '10', '男', 'sdsd', '0', '2018-04-23 20:52:49', '2018-04-23 20:52:49', '0');