forked from 617746883/thinkphp5.0_shop
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathinstall.sql
6778 lines (5955 loc) · 511 KB
/
install.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
-- phpMyAdmin SQL Dump
-- version 4.7.9
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: 2019-08-19 10:14:06
-- 服务器版本： 10.1.39-MariaDB
-- PHP Version: 5.6.40
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `mall_sul1ss_onli`
--
-- --------------------------------------------------------
--
-- 表的结构 `suliss_admin`
--
CREATE TABLE `suliss_admin` (
`id` int(10) UNSIGNED NOT NULL,
`avatar` varchar(255) NOT NULL DEFAULT '',
`username` varchar(30) NOT NULL,
`password` varchar(200) NOT NULL,
`salt` varchar(10) NOT NULL,
`type` tinyint(3) UNSIGNED NOT NULL,
`token` varchar(255) NOT NULL,
`status` tinyint(4) NOT NULL,
`joindate` int(10) UNSIGNED NOT NULL,
`joinip` varchar(15) NOT NULL,
`lastvisit` int(10) UNSIGNED NOT NULL,
`lastip` varchar(15) NOT NULL,
`remark` varchar(500) NOT NULL,
`starttime` int(10) UNSIGNED NOT NULL,
`endtime` int(10) UNSIGNED NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 插入之前先把表清空（truncate） `suliss_admin`
--
TRUNCATE TABLE `suliss_admin`;
--
-- 转存表中的数据 `suliss_admin`
--
INSERT INTO `suliss_admin` (`id`, `avatar`, `username`, `password`, `salt`, `type`, `token`, `status`, `joindate`, `joinip`, `lastvisit`, `lastip`, `remark`, `starttime`, `endtime`) VALUES
(1, '/public/attachment/images/20180711/89bea514e1d302d006fac4d8ba69d22f.jpg', 'admin', 'f374baf63f70a5c2c4d172a0a6e37897', 'U66yPU04', 0, 'd1a63a50fad4332a8dea5383c4586361d4bd96ed', 1, 1532331947, '182.245.71.7', 1566177224, '116.52.235.156', 'wqe12', 0, 0),
(3, '/public/attachment/images/20180719/fd38d78f8dfe912b836e4ff320bbebcf.jpg', 'test', '438b6acb8aca7eea3295ffb62cbc238a', 'yoHo3WGS', 0, 'ead29ada1a8c5cfc982f65383fd5b0', 1, 1532612737, '14.204.0.220', 1535596524, '182.245.71.15', '', 0, 0),
(2, '/public/attachment/images/20180530/0847d00bfcc965c68a7ac014715270aa.jpg', 'administrator', '5d1b9a1c47060c0a16c723b7471bba74', 'lVRVVp9g', 0, 'afabe677ee5a06b80afb2616802c92474ef39fed', 1, 1532408484, '218.63.141.87', 1564378770, '39.128.20.82', 'ces121312', 1544492160, 1613612160);
-- --------------------------------------------------------
--
-- 表的结构 `suliss_admin_log`
--
CREATE TABLE `suliss_admin_log` (
`id` int(11) NOT NULL,
`adminid` int(11) DEFAULT '0',
`type` varchar(255) DEFAULT '',
`op` text,
`createtime` int(11) DEFAULT '0',
`ip` varchar(255) DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 插入之前先把表清空（truncate） `suliss_admin_log`
--
TRUNCATE TABLE `suliss_admin_log`;
--
-- 转存表中的数据 `suliss_admin_log`
--
INSERT INTO `suliss_admin_log` (`id`, `adminid`, `type`, `op`, `createtime`, `ip`) VALUES
(723, 1, 'admin.login', '管理员 : admin悄悄地登陆了后台', 1562654760, '116.52.120.135'),
(724, 1, 'sysset.shop.edit', '修改系统设置-商城设置', 1562655321, '116.52.120.135'),
(725, 1, 'admin.login', '管理员 : admin悄悄地登陆了后台', 1563413121, '116.52.235.98'),
(726, 1, 'admin.login', '管理员 : admin悄悄地登陆了后台', 1563758378, '116.52.34.204'),
(727, 1, 'shop.category.edit', '修改分类 ID: 60', 1563861616, '182.245.71.172'),
(728, 1, 'shop.category.edit', '修改分类 ID: 61', 1563861635, '182.245.71.172'),
(729, 1, 'shop.category.edit', '修改分类 ID: 62', 1563861681, '182.245.71.172'),
(730, 1, 'sysset.shop.edit', '修改系统设置-商城设置', 1563863717, '182.245.71.172'),
(731, 1, 'admin.login', '管理员 : admin悄悄地登陆了后台', 1563895012, '222.172.249.164'),
(732, 1, 'admin.login', '管理员 : admin悄悄地登陆了后台', 1563930593, '116.52.98.162'),
(733, 1, 'livemall.set.edit', '修改星店基本设置', 1564035573, '182.245.71.3'),
(734, 1, 'livemall.set.edit', '修改星店基本设置', 1564035681, '182.245.71.3'),
(735, 1, 'livemall.set.edit', '修改星店基本设置', 1564035735, '182.245.71.3'),
(736, 1, 'livemall.set.edit', '修改星店基本设置', 1564036460, '182.245.71.3'),
(737, 1, 'merch.user.edit', '编辑主播代理商品 ID: ', 1564038434, '182.245.71.3'),
(738, 1, 'merch.user.edit', '编辑主播代理商品 ID: ', 1564038466, '182.245.71.3'),
(739, 1, 'merch.user.edit', '编辑主播代理商品 ID: ', 1564038477, '182.245.71.3'),
(740, 1, 'merch.user.edit', '编辑主播代理商品 ID: ', 1564038487, '182.245.71.3'),
(741, 1, 'merch.user.edit', '编辑主播代理商品 ID: ', 1564038566, '182.245.71.3'),
(742, 1, 'merch.user.edit', '编辑主播代理商品 ID: ', 1564038569, '182.245.71.3'),
(743, 1, 'goods.edit', '编辑商品 ID: 3', 1564039678, '182.245.71.3'),
(744, 1, 'goods.edit', '编辑商品 ID: 3', 1564039688, '182.245.71.3'),
(745, 1, 'goods.edit', '编辑商品 ID: 3', 1564040087, '182.245.71.3'),
(746, 1, 'goods.edit', '编辑商品 ID: 3', 1564040223, '182.245.71.3'),
(747, 1, 'goods.edit', '编辑商品 ID: 3', 1564040382, '182.245.71.3'),
(748, 1, 'merch.user.edit', '编辑主播代理商品 ID: ', 1564044957, '182.245.71.3'),
(749, 1, 'merch.user.edit', '编辑主播代理商品 ID: ', 1564045043, '182.245.71.3'),
(750, 1, 'livemall.set.edit', '修改星店基本设置', 1564049424, '182.245.71.3'),
(751, 1, 'admin.login', '管理员 : admin悄悄地登陆了后台', 1564378533, '116.52.45.25'),
(752, 1, 'system.admin.delete', '删除操作员 ID: 4 操作员名称: doncheng ', 1564378700, '116.52.45.25'),
(753, 1, 'system.admin.delete', '删除操作员 ID: 5 操作员名称: zhuxietong ', 1564378700, '116.52.45.25'),
(754, 1, 'system.admin.delete', '删除操作员 ID: 6 操作员名称: xiaoxiao ', 1564378700, '116.52.45.25'),
(755, 1, 'system.admin.delete', '删除操作员 ID: 7 操作员名称: zhutong ', 1564378700, '116.52.45.25'),
(756, 1, 'system.admin.edit', '编辑操作员 ID: 2 用户名: administrator ', 1564378726, '116.52.45.25'),
(757, 2, 'admin.login', '管理员 : administrator悄悄地登陆了后台', 1564378770, '39.128.20.82'),
(758, 1, 'admin.login', '管理员 : admin悄悄地登陆了后台', 1564539733, '116.52.120.6'),
(759, 1, 'admin.login', '管理员 : admin悄悄地登陆了后台', 1564849679, '222.221.182.245'),
(760, 1, 'system.database.optimize', '数据库优化', 1564851573, '222.221.182.245'),
(761, 1, 'admin.login', '管理员 : admin悄悄地登陆了后台', 1565145925, '116.52.235.145'),
(762, 1, 'admin.login', '管理员 : admin悄悄地登陆了后台', 1565616722, '222.172.249.17'),
(763, 1, 'sysset.shop.edit', '修改系统设置-商城设置', 1565616734, '222.172.249.17'),
(764, 1, 'admin.login', '管理员 : admin悄悄地登陆了后台', 1565616786, '222.172.249.17'),
(765, 1, 'merch.user.edit', '编辑主播代理商品 ID: ', 1565617791, '222.172.249.17'),
(766, 1, 'system.admin.edit', '编辑个人信息 ID: 1 用户名: admin ', 1565618782, '222.172.249.17'),
(767, 1, 'admin.login', '管理员 : admin悄悄地登陆了后台', 1565619041, '222.172.249.17'),
(768, 1, 'system.admin.edit', '编辑个人信息 ID: 1 用户名: ', 1565619515, '222.172.249.17'),
(769, 1, 'admin.login', '管理员 : admin悄悄地登陆了后台', 1565619554, '222.172.249.17'),
(770, 1, 'admin.login', '管理员 : admin悄悄地登陆了后台', 1566177224, '116.52.235.156'),
(771, 1, 'goods.edit', '编辑商品 ID: 3', 1566180323, '116.52.235.156');
-- --------------------------------------------------------
--
-- 表的结构 `suliss_attachment_group`
--
CREATE TABLE `suliss_attachment_group` (
`id` int(11) NOT NULL,
`name` varchar(25) NOT NULL,
`uid` int(11) DEFAULT NULL,
`type` tinyint(1) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 插入之前先把表清空（truncate） `suliss_attachment_group`
--
TRUNCATE TABLE `suliss_attachment_group`;
-- --------------------------------------------------------
--
-- 表的结构 `suliss_auth_group`
--
CREATE TABLE `suliss_auth_group` (
`id` mediumint(8) UNSIGNED NOT NULL,
`title` char(100) NOT NULL DEFAULT '',
`status` tinyint(1) NOT NULL DEFAULT '1',
`rules` char(80) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 插入之前先把表清空（truncate） `suliss_auth_group`
--
TRUNCATE TABLE `suliss_auth_group`;
-- --------------------------------------------------------
--
-- 表的结构 `suliss_auth_group_access`
--
CREATE TABLE `suliss_auth_group_access` (
`uid` mediumint(8) UNSIGNED NOT NULL,
`group_id` mediumint(8) UNSIGNED NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 插入之前先把表清空（truncate） `suliss_auth_group_access`
--
TRUNCATE TABLE `suliss_auth_group_access`;
-- --------------------------------------------------------
--
-- 表的结构 `suliss_auth_rule`
--
CREATE TABLE `suliss_auth_rule` (
`id` mediumint(8) UNSIGNED NOT NULL,
`name` char(80) NOT NULL DEFAULT '',
`title` char(20) NOT NULL DEFAULT '',
`pid` int(11) NOT NULL DEFAULT '0',
`type` tinyint(1) NOT NULL DEFAULT '1',
`status` tinyint(1) NOT NULL DEFAULT '1',
`condition` char(100) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 插入之前先把表清空（truncate） `suliss_auth_rule`
--
TRUNCATE TABLE `suliss_auth_rule`;
-- --------------------------------------------------------
--
-- 表的结构 `suliss_core_attachment`
--
CREATE TABLE `suliss_core_attachment` (
`id` int(10) UNSIGNED NOT NULL,
`uid` int(10) UNSIGNED NOT NULL,
`filename` varchar(255) NOT NULL,
`attachment` varchar(255) NOT NULL,
`type` tinyint(3) UNSIGNED NOT NULL,
`createtime` int(10) UNSIGNED NOT NULL,
`module_upload_dir` varchar(100) NOT NULL,
`group_id` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 插入之前先把表清空（truncate） `suliss_core_attachment`
--
TRUNCATE TABLE `suliss_core_attachment`;
--
-- 转存表中的数据 `suliss_core_attachment`
--
INSERT INTO `suliss_core_attachment` (`id`, `uid`, `filename`, `attachment`, `type`, `createtime`, `module_upload_dir`, `group_id`) VALUES
(1, 1, '20190723/c32cb2659ec75fb1f6ecaef4ec20cfc8.png', '/public/attachment/images/20190723/c32cb2659ec75fb1f6ecaef4ec20cfc8.png', 1, 1563861612, '', -1),
(2, 1, '20190723/1233bce264e0c2503623b0a28e8b797f.png', '/public/attachment/images/20190723/1233bce264e0c2503623b0a28e8b797f.png', 1, 1563861630, '', -1),
(3, 1, '20190723/d0478e0852281c0b7fa48461e46cf118.png', '/public/attachment/images/20190723/d0478e0852281c0b7fa48461e46cf118.png', 1, 1563861678, '', -1),
(4, 1, '20190723/5955aa9b90526d89169663701456b20d.jpg', '/public/attachment/images/20190723/5955aa9b90526d89169663701456b20d.jpg', 1, 1563863713, '', -1);
-- --------------------------------------------------------
--
-- 表的结构 `suliss_livemall_goods_agent`
--
CREATE TABLE `suliss_livemall_goods_agent` (
`id` int(11) NOT NULL,
`mid` int(11) DEFAULT '0',
`goodsid` int(11) DEFAULT '0',
`regid` int(11) DEFAULT '0',
`slogans` varchar(500) DEFAULT '',
`hascommission` tinyint(3) NOT NULL DEFAULT '0',
`commission1_rate` decimal(10,2) DEFAULT '0.00',
`commission1_pay` decimal(10,2) DEFAULT '0.00',
`commission2_rate` decimal(10,2) DEFAULT '0.00',
`commission2_pay` decimal(10,2) DEFAULT '0.00',
`commission3_rate` decimal(10,2) DEFAULT '0.00',
`commission3_pay` decimal(10,2) DEFAULT '0.00',
`commission` text,
`salers` int(11) DEFAULT '0',
`createtime` int(11) DEFAULT '0',
`status` tinyint(3) DEFAULT '0',
`deleted` tinyint(1) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 插入之前先把表清空（truncate） `suliss_livemall_goods_agent`
--
TRUNCATE TABLE `suliss_livemall_goods_agent`;
--
-- 转存表中的数据 `suliss_livemall_goods_agent`
--
INSERT INTO `suliss_livemall_goods_agent` (`id`, `mid`, `goodsid`, `regid`, `slogans`, `hascommission`, `commission1_rate`, `commission1_pay`, `commission2_rate`, `commission2_pay`, `commission3_rate`, `commission3_pay`, `commission`, `salers`, `createtime`, `status`, `deleted`) VALUES
(1, 21, 2, 1, '我来卖', 1, '8.00', '0.00', '0.00', '0.00', '0.00', '0.00', NULL, 0, 1564038434, 1, 0),
(2, 21, 1, 2, '我来卖', 1, '15.00', '1.00', '0.00', '0.00', '0.00', '0.00', NULL, 0, 1564045043, 1, 0),
(3, 21, 3, 3, '我来卖', 0, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', NULL, 0, 0, -1, 0);
-- --------------------------------------------------------
--
-- 表的结构 `suliss_livemall_reg`
--
CREATE TABLE `suliss_livemall_reg` (
`id` int(11) NOT NULL,
`mid` int(11) DEFAULT '0',
`goodsid` int(11) DEFAULT '0',
`slogans` varchar(500) DEFAULT '',
`status` tinyint(3) DEFAULT '0',
`applytime` int(11) DEFAULT '0',
`reason` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 插入之前先把表清空（truncate） `suliss_livemall_reg`
--
TRUNCATE TABLE `suliss_livemall_reg`;
--
-- 转存表中的数据 `suliss_livemall_reg`
--
INSERT INTO `suliss_livemall_reg` (`id`, `mid`, `goodsid`, `slogans`, `status`, `applytime`, `reason`) VALUES
(2, 21, 1, '我来卖', 1, 1564045026, ''),
(3, 21, 3, '我来卖', 0, 1566180325, NULL);
-- --------------------------------------------------------
--
-- 表的结构 `suliss_member`
--
CREATE TABLE `suliss_member` (
`id` int(11) NOT NULL,
`uid` int(11) NOT NULL DEFAULT '0',
`groupid` int(11) DEFAULT '0',
`level` int(11) DEFAULT '0',
`realname` varchar(20) DEFAULT '',
`mobile` varchar(11) DEFAULT '',
`content` text,
`createtime` int(10) DEFAULT '0',
`status` tinyint(1) DEFAULT '0',
`nickname` varchar(255) DEFAULT '',
`carrier_mobile` varchar(11) NOT NULL DEFAULT '',
`carrier_realname` varchar(255) NOT NULL DEFAULT '',
`credit1` decimal(10,2) DEFAULT '0.00',
`credit2` decimal(10,2) DEFAULT '0.00',
`birthyear` varchar(255) DEFAULT '',
`birthmonth` varchar(255) DEFAULT '',
`birthday` varchar(255) DEFAULT '',
`gender` tinyint(3) DEFAULT '0',
`avatar` varchar(255) DEFAULT '',
`province` varchar(255) DEFAULT '',
`city` varchar(255) DEFAULT '',
`area` varchar(255) DEFAULT '',
`isblack` int(11) DEFAULT '0',
`username` varchar(255) DEFAULT '',
`salt` varchar(32) DEFAULT '',
`password` varchar(50) DEFAULT '',
`mobileverify` tinyint(3) DEFAULT '0',
`token` varchar(50) DEFAULT '',
`expirestime` int(10) DEFAULT '0',
`diymaxcredit` tinyint(3) NOT NULL DEFAULT '0',
`maxcredit` int(10) NOT NULL DEFAULT '0',
`regId` varchar(50) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 插入之前先把表清空（truncate） `suliss_member`
--
TRUNCATE TABLE `suliss_member`;
--
-- 转存表中的数据 `suliss_member`
--
INSERT INTO `suliss_member` (`id`, `uid`, `groupid`, `level`, `realname`, `mobile`, `content`, `createtime`, `status`, `nickname`, `carrier_mobile`, `carrier_realname`, `credit1`, `credit2`, `birthyear`, `birthmonth`, `birthday`, `gender`, `avatar`, `province`, `city`, `area`, `isblack`, `username`, `salt`, `password`, `mobileverify`, `token`, `expirestime`, `diymaxcredit`, `maxcredit`, `regId`) VALUES
(21, 8, 0, 0, '', '13099907747', NULL, 1544455229, 1, 'SUL1SS', '13099907747', '敖敖', '0.00', '0.00', '2018', '01', '01', 1, 'http://mall.sul1ss.online/public/attachment/app/20190722/b1aa960244dde3645ae6bcab7eb215e0.jpg', '云南省', '昆明市', '西山区', 0, 'a123456', 'vP9DTrfi7T1rpD0r', 'd4ac47dc8bc86a493fa920d8d082dcc3', 1, '29003bb389060d2b51a75bb4fa132016', 1566785125, 0, 0, '1104a89792d25faf618'),
(22, 0, 0, 0, '', '18687510604', NULL, 1544602652, 1, '', '', '', '0.00', '0.00', '', '', '', 0, 'http://aoao.doncheng.cn/public/attachment/app/20190114/74b7742286c5c9e036b607c7366dcaca.png', '云南省', '昆明市', '五华区', 0, 'zhuxietong', 'J2UNn2k72j2d4j2m', 'ea4ded31f6ed1e04911a91ca15c5a07e', 1, '3be01d0fb2a035eb5fd9da1f43cf76ab', 1549414683, 0, 0, '171976fa8ac79f03c33'),
(23, 0, 0, 0, '不包', '15559952836', NULL, 1546573646, 1, '', '18487165037', '不包', '0.00', '0.00', '', '', '', 0, 'http://aoao.doncheng.cn/public/attachment/app/20190129/659ea593c83eb7196c4d22464d17933c.jpg', '安徽省', '合肥市', '瑶海区', 0, 'jimmy', 'MyQlzHPS3G65ZPZG', 'e5fcedbe26a6a56b4d2725c25044f9fc', 1, 'c152b7ad9d0996dc8fc698234be96284', 1549361352, 0, 0, '1a0018970af07939261'),
(24, 0, 0, 0, 'ID', '18687510603', NULL, 1546925054, 1, '', '18687510603', 'ID', '0.00', '0.00', '', '', '', 0, 'http://aoao.doncheng.cn/public/attachment/app/20190114/af0d75d690a172b55f12f5c35d37d038.png', '北京市', '北京市', '东城区', 0, 'tong', 'g8DSgSPGSM3mBZsT', '098b7b84ad60c702fc53d26a0b575cdd', 1, '6300679493d7ed243c71fa108760a577', 1548740024, 0, 0, ''),
(25, 0, 0, 0, 'gg', '13988982118', NULL, 1547629841, 1, '', '15484152485', 'gg', '0.00', '0.00', '', '', '', 0, 'http://aoao.doncheng.cn/public/attachment/app/20190117/33593248514a1f320a91987116e0acb6.jpg', '云南省', '昆明市', '西山区', 0, 'ztind', 'EXxHeXC17N3h1Nc7', 'ef049045902e4285505822d13de61966', 1, '0a04a9cb3915c3f094c541736647c0e0', 1549360831, 0, 0, ''),
(27, 0, 0, 0, '', '13466260815', NULL, 1563897852, 1, '马翔', '', '', '0.00', '0.00', '', '', '', 1, './public/attachment/201904/8/1555267161936.png', '火星', '', '', 0, '', '', '', 0, 'ec6045e388b9f4d4891921a2ecc0e1f5', 1566783816, 0, 0, '');
-- --------------------------------------------------------
--
-- 表的结构 `suliss_member_credits_record`
--
CREATE TABLE `suliss_member_credits_record` (
`id` int(11) NOT NULL,
`mid` int(10) UNSIGNED NOT NULL,
`credittype` varchar(10) NOT NULL,
`num` decimal(10,2) NOT NULL,
`operator` int(10) UNSIGNED NOT NULL,
`module` varchar(30) NOT NULL,
`clerk_id` int(10) UNSIGNED NOT NULL,
`store_id` int(10) UNSIGNED NOT NULL,
`clerk_type` tinyint(3) UNSIGNED NOT NULL,
`createtime` int(10) UNSIGNED NOT NULL,
`remark` varchar(200) NOT NULL,
`real_uniacid` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 插入之前先把表清空（truncate） `suliss_member_credits_record`
--
TRUNCATE TABLE `suliss_member_credits_record`;
-- --------------------------------------------------------
--
-- 表的结构 `suliss_member_failed_login`
--
CREATE TABLE `suliss_member_failed_login` (
`id` int(10) UNSIGNED NOT NULL,
`ip` varchar(15) NOT NULL,
`username` varchar(32) NOT NULL,
`count` tinyint(1) UNSIGNED NOT NULL,
`lastupdate` int(11) UNSIGNED NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 插入之前先把表清空（truncate） `suliss_member_failed_login`
--
TRUNCATE TABLE `suliss_member_failed_login`;
-- --------------------------------------------------------
--
-- 表的结构 `suliss_member_group`
--
CREATE TABLE `suliss_member_group` (
`id` int(11) NOT NULL,
`groupname` varchar(255) DEFAULT '',
`description` varchar(255) DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 插入之前先把表清空（truncate） `suliss_member_group`
--
TRUNCATE TABLE `suliss_member_group`;
-- --------------------------------------------------------
--
-- 表的结构 `suliss_member_level`
--
CREATE TABLE `suliss_member_level` (
`id` int(11) NOT NULL,
`level` int(11) DEFAULT '0',
`levelname` varchar(50) DEFAULT '',
`ordermoney` decimal(10,2) DEFAULT '0.00',
`ordercount` int(10) DEFAULT '0',
`discount` decimal(10,2) DEFAULT '0.00',
`enabled` tinyint(3) DEFAULT '0',
`enabledadd` tinyint(1) DEFAULT '0',
`buygoods` tinyint(1) NOT NULL DEFAULT '0',
`goodsids` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 插入之前先把表清空（truncate） `suliss_member_level`
--
TRUNCATE TABLE `suliss_member_level`;
-- --------------------------------------------------------
--
-- 表的结构 `suliss_member_message`
--
CREATE TABLE `suliss_member_message` (
`id` int(11) NOT NULL,
`mid` int(11) DEFAULT '0',
`title` varchar(255) DEFAULT '',
`remark` text NOT NULL,
`datas` text NOT NULL,
`messagethumb` varchar(255) NOT NULL,
`messagetype` varchar(30) DEFAULT '',
`businessid` int(11) NOT NULL DEFAULT '0',
`messagetid` varchar(30) DEFAULT '',
`createtime` int(11) DEFAULT '0',
`sendtime` int(11) DEFAULT '0',
`sendcount` int(11) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- 表的结构 `suliss_prefix_jobs`
--
CREATE TABLE `suliss_prefix_jobs` (
`id` int(11) NOT NULL,
`queue` varchar(255) NOT NULL,
`payload` longtext NOT NULL,
`attempts` tinyint(3) UNSIGNED NOT NULL,
`reserved` tinyint(3) UNSIGNED NOT NULL,
`reserved_at` int(10) UNSIGNED DEFAULT NULL,
`available_at` int(10) UNSIGNED NOT NULL,
`created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- 插入之前先把表清空（truncate） `suliss_prefix_jobs`
--
TRUNCATE TABLE `suliss_prefix_jobs`;
--
-- 转存表中的数据 `suliss_prefix_jobs`
--
INSERT INTO `suliss_prefix_jobs` (`id`, `queue`, `payload`, `attempts`, `reserved`, `reserved_at`, `available_at`, `created_at`) VALUES
(1, '拍卖队列23', '{\"job\":\"application\\\\apiv1\\\\job\\\\Hello\",\"data\":\"{\\\"mid\\\":21,\\\"nickname\\\":\\\"SUL1SS\\\",\\\"goodsid\\\":1,\\\"ordersn\\\":\\\"AU20181217144647606552\\\",\\\"price\\\":1150,\\\"addprice\\\":500,\\\"bond\\\":150,\\\"paytype\\\":1,\\\"createtime\\\":1545029207}\"}', 0, 0, NULL, 1545029207, 1545029207),
(2, '拍卖队列24', '{\"job\":\"application\\\\apiv1\\\\job\\\\Hello\",\"data\":\"{\\\"mid\\\":21,\\\"nickname\\\":\\\"SUL1SS\\\",\\\"goodsid\\\":1,\\\"ordersn\\\":\\\"AU20181218091513474196\\\",\\\"price\\\":1150,\\\"addprice\\\":500,\\\"bond\\\":150,\\\"paytype\\\":1,\\\"createtime\\\":1545095713}\"}', 0, 0, NULL, 1545095713, 1545095713),
(3, '拍卖队列25', '{\"job\":\"application\\\\apiv1\\\\job\\\\Hello\",\"data\":\"{\\\"mid\\\":21,\\\"nickname\\\":\\\"SUL1SS\\\",\\\"goodsid\\\":1,\\\"ordersn\\\":\\\"AU20181218151237880746\\\",\\\"price\\\":1150,\\\"addprice\\\":500,\\\"bond\\\":150,\\\"paytype\\\":1,\\\"createtime\\\":1545117157}\"}', 0, 0, NULL, 1545117157, 1545117157);
-- --------------------------------------------------------
--
-- 表的结构 `suliss_shop_adv`
--
CREATE TABLE `suliss_shop_adv` (
`id` int(11) NOT NULL,
`advname` varchar(50) DEFAULT '',
`link` varchar(255) DEFAULT '',
`thumb` varchar(255) DEFAULT '',
`displayorder` int(11) DEFAULT '0',
`enabled` int(11) DEFAULT '0',
`shopid` int(11) DEFAULT '0',
`iswxapp` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 插入之前先把表清空（truncate） `suliss_shop_adv`
--
TRUNCATE TABLE `suliss_shop_adv`;
-- --------------------------------------------------------
--
-- 表的结构 `suliss_shop_area_config`
--
CREATE TABLE `suliss_shop_area_config` (
`id` int(11) NOT NULL,
`new_area` tinyint(3) NOT NULL DEFAULT '0',
`address_street` tinyint(3) NOT NULL DEFAULT '0',
`createtime` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;
--
-- 插入之前先把表清空（truncate） `suliss_shop_area_config`
--
TRUNCATE TABLE `suliss_shop_area_config`;
--
-- 转存表中的数据 `suliss_shop_area_config`
--
INSERT INTO `suliss_shop_area_config` (`id`, `new_area`, `address_street`, `createtime`) VALUES
(2, 1, 1, 1545882026);
-- --------------------------------------------------------
--
-- 表的结构 `suliss_shop_article`
--
CREATE TABLE `suliss_shop_article` (
`id` int(11) NOT NULL,
`article_title` varchar(255) NOT NULL DEFAULT '',
`resp_desc` text NOT NULL,
`resp_img` text NOT NULL,
`article_content` longtext,
`article_category` int(11) NOT NULL DEFAULT '0',
`article_date` varchar(20) NOT NULL DEFAULT '',
`article_mp` varchar(50) NOT NULL DEFAULT '',
`article_author` varchar(20) NOT NULL DEFAULT '',
`article_readnum_v` int(11) NOT NULL DEFAULT '0',
`article_readnum` int(11) NOT NULL DEFAULT '0',
`article_likenum_v` int(11) NOT NULL DEFAULT '0',
`article_likenum` int(11) NOT NULL DEFAULT '0',
`page_set_option_nocopy` int(1) NOT NULL DEFAULT '0',
`page_set_option_noshare_tl` int(1) NOT NULL DEFAULT '0',
`page_set_option_noshare_msg` int(1) NOT NULL DEFAULT '0',
`article_state` int(1) NOT NULL DEFAULT '0',
`article_endtime` int(11) DEFAULT '0',
`article_hasendtime` tinyint(3) DEFAULT '0',
`displayorder` int(11) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='营销文章';
--
-- 插入之前先把表清空（truncate） `suliss_shop_article`
--
TRUNCATE TABLE `suliss_shop_article`;
-- --------------------------------------------------------
--
-- 表的结构 `suliss_shop_article_category`
--
CREATE TABLE `suliss_shop_article_category` (
`id` int(11) NOT NULL,
`category_name` varchar(255) NOT NULL DEFAULT '',
`displayorder` int(11) NOT NULL DEFAULT '0',
`isshow` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='营销表单分类';
--
-- 插入之前先把表清空（truncate） `suliss_shop_article_category`
--
TRUNCATE TABLE `suliss_shop_article_category`;
-- --------------------------------------------------------
--
-- 表的结构 `suliss_shop_auction_banner`
--
CREATE TABLE `suliss_shop_auction_banner` (
`id` int(11) NOT NULL,
`bannername` varchar(50) DEFAULT '',
`link` varchar(255) DEFAULT '',
`thumb` varchar(255) DEFAULT '',
`displayorder` int(11) DEFAULT '0',
`enabled` int(11) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 插入之前先把表清空（truncate） `suliss_shop_auction_banner`
--
TRUNCATE TABLE `suliss_shop_auction_banner`;
--
-- 转存表中的数据 `suliss_shop_auction_banner`
--
INSERT INTO `suliss_shop_auction_banner` (`id`, `bannername`, `link`, `thumb`, `displayorder`, `enabled`) VALUES
(3, '幻灯片一', '', '/public/attachment/images/20181221/7153e21983f045827077f228335a4b4a.jpg', 50, 1),
(4, '幻灯片二', '', '/public/attachment/images/20190102/efe89f51520e92ec7b552fabf6129729.jpg', 50, 1);
-- --------------------------------------------------------
--
-- 表的结构 `suliss_shop_auction_bondorder`
--
CREATE TABLE `suliss_shop_auction_bondorder` (
`id` int(11) NOT NULL,
`goodsid` int(11) NOT NULL DEFAULT '0',
`mid` int(11) DEFAULT '0',
`ordersn` varchar(30) DEFAULT '',
`price` decimal(10,2) DEFAULT '0.00',
`status` tinyint(3) DEFAULT '0',
`paytype` tinyint(1) DEFAULT '0',
`transid` varchar(30) DEFAULT '0',
`createtime` int(10) DEFAULT NULL,
`deleted` tinyint(3) DEFAULT '0',
`userdeleted` tinyint(3) DEFAULT '0',
`finishtime` int(11) DEFAULT '0',
`paytime` int(11) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
--
-- 插入之前先把表清空（truncate） `suliss_shop_auction_bondorder`
--
TRUNCATE TABLE `suliss_shop_auction_bondorder`;
--
-- 转存表中的数据 `suliss_shop_auction_bondorder`
--
INSERT INTO `suliss_shop_auction_bondorder` (`id`, `goodsid`, `mid`, `ordersn`, `price`, `status`, `paytype`, `transid`, `createtime`, `deleted`, `userdeleted`, `finishtime`, `paytime`) VALUES
(57, 1, 21, 'AUB20190103180443850825', '150.00', 1, 1, '0', 1546509883, 0, 0, 1546509883, 1546509883),
(54, 5, 21, 'AUB20190103175940714469', '60.00', 1, 1, '0', 1546509580, 0, 0, 1546509883, 1546509883),
(58, 2, 21, 'AUB20190104133531920242', '100.00', 0, 0, '0', 1546580131, 0, 0, 0, 0),
(59, 4, 21, 'AUB20190104163706774330', '888.00', 1, 0, '0', 1546591026, 0, 0, 0, 1546509883),
(83, 5, 22, 'AUB20190124175252891628', '60.00', 0, 0, '0', 1548323572, 0, 0, 0, 0),
(75, 4, 22, 'AUB20190124160744844280', '888.00', 0, 0, '0', 1548317264, 0, 0, 0, 0),
(81, 7, 22, 'AUB20190124163011653254', '0.00', 0, 0, '0', 1548318611, 0, 0, 0, 0),
(82, 7, 21, 'AUB20190124175137688685', '0.00', 0, 0, '0', 1548323497, 0, 0, 0, 0);
-- --------------------------------------------------------
--
-- 表的结构 `suliss_shop_auction_goods`
--
CREATE TABLE `suliss_shop_auction_goods` (
`id` int(10) UNSIGNED NOT NULL COMMENT '主键',
`title` varchar(100) DEFAULT '' COMMENT '商品标题',
`category` int(10) DEFAULT '0' COMMENT '分类id',
`displayorder` int(11) NOT NULL DEFAULT '0',
`shprice` int(10) DEFAULT '0' COMMENT '起拍金额',
`addprice` int(10) DEFAULT '0' COMMENT '默认加价金额',
`stprice` int(10) DEFAULT '0' COMMENT '成交金额',
`bond` int(10) DEFAULT '0' COMMENT '保证金',
`thumb` varchar(255) NOT NULL DEFAULT '',
`thumb_url` text,
`content` text NOT NULL COMMENT '商品详情',
`starttime` int(11) UNSIGNED DEFAULT '0' COMMENT '开始时间',
`endtime` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '结束时间',
`createtime` int(11) UNSIGNED DEFAULT '0' COMMENT '创建时间',
`pos` tinyint(4) UNSIGNED DEFAULT '0' COMMENT '出价次数',
`status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '1:已付余款',
`dealmid` int(11) NOT NULL DEFAULT '0' COMMENT '成交人id',
`deleted` tinyint(3) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 插入之前先把表清空（truncate） `suliss_shop_auction_goods`
--
TRUNCATE TABLE `suliss_shop_auction_goods`;
--
-- 转存表中的数据 `suliss_shop_auction_goods`
--
INSERT INTO `suliss_shop_auction_goods` (`id`, `title`, `category`, `displayorder`, `shprice`, `addprice`, `stprice`, `bond`, `thumb`, `thumb_url`, `content`, `starttime`, `endtime`, `createtime`, `pos`, `status`, `dealmid`, `deleted`) VALUES
(1, '茅台老酒(1949年陈酿茅台)', 2, 0, 500, 50, 599, 150, '/public/attachment/images/20181225/11dff62422d0f1ebecbab5a73c8bb30e.jpg', 'a:2:{i:0;s:71:\"/public/attachment/images/20181225/11dff62422d0f1ebecbab5a73c8bb30e.jpg\";i:1;s:71:\"/public/attachment/images/20181225/43555cfcb33fdacb7971645e9fc70b66.jpg\";}', '<p><img src=\"http://test.doncheng.cn/public/attachment/images/20181211/bbecd1426cbd2594a0f94ffd7be806bd.png\" width=\"100%\" alt=\"20181211/bbecd1426cbd2594a0f94ffd7be806bd.png\"/></p>', 1545025200, 1546585500, 1544672372, 2, 1, 21, 0),
(2, '玻璃女鞋', 2, 0, 100, 30, 0, 100, '/public/attachment/images/20181221/fee7033d9cedb85099aaf4f6cd90b61a.jpg', 'a:1:{i:0;s:71:\"/public/attachment/images/20181221/fee7033d9cedb85099aaf4f6cd90b61a.jpg\";}', '<p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\"><span style=\"font-size: 1em; font-weight: 700;\">女鞋品牌前十一大排名（2013年）</span></p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">1<span style=\"font-size: 1em; font-weight: 700;\">达芙妮Daphne</span>(于1987年在香港创立,一个以鞋业研发、生产、加工及销售为主的<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=7546983&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">多元化经营</a>集团,<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=121772&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">达芙妮国际控股有限公司</a>)</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">2<span style=\"font-size: 1em; font-weight: 700;\">ROXE诺晞</span>（<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=155899&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">中国驰名商标</a>,中国名牌,中国<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=10333830&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">真皮标志</a>品牌,行业著名品牌,十大女鞋品牌,<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=133821795&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">广州诺晞鞋业有限公司</a>）</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">3百丽<span style=\"font-size: 1em; font-weight: 700;\">BeLLE</span>(中国驰名商标,中国名牌,中国真皮标志品牌,上市公司,行业著名品牌,十大女鞋品牌,<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=103428835&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">百丽国际</a>控股有限公司)</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">4<span style=\"font-size: 1em; font-weight: 700;\">他她TATA</span>(专业致力于各类<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=61356943&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">女性鞋</a>设计生产的专业女鞋制造企业,行业著名品牌,女鞋十大品牌女鞋,百丽国际控股有限公司)</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">5<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=64292980&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">红蜻蜓</a>(中国名牌,中国驰名商标,全国<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=10184853&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">民企500强</a>,最具价值品牌500强,行业影响力品牌之一,<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=66327517&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">红蜻蜓集团有限公司</a>)</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">6<span style=\"font-size: 1em; font-weight: 700;\">星期六ST&SAT</span>(广东省著名商标,中国真皮标志,女鞋十大品牌女鞋,中国大陆领先的鞋业品牌运营商,<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=10833786&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">佛山星期六鞋业股份有限公司</a>)</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">7<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=65052988&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">千百度</a><span style=\"font-size: 1em; font-weight: 700;\">C.banner</span>(中国驰名商标,专业致力于女性产品设计生产的企业,<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=169113651&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">鸿国实业集团有限公司</a>旗下东莞美丽华鞋业有限公司)</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">8<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=7636938&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">天美意</a><span style=\"font-size: 1em; font-weight: 700;\">Teenmix</span>(原由香港<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=70818410&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">美丽宝</a>集团所创后被百丽所收购,行业著名女鞋品牌,大型专业女鞋制造企业,百丽国际控股有限公司)</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">9<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=59241965&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">戈美其</a><span style=\"font-size: 1em; font-weight: 700;\">GEMEIQI</span>(中国驰名商标,国内知名女鞋品牌,集研发/生产/销售/服务于一体的现代化企业,<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=60712799&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">浙江戈美其鞋业有限公司</a>)</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">10<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=74576594&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">接吻猫</a><span style=\"font-size: 1em; font-weight: 700;\">Kisscat</span>(中国女鞋行业中最具代表性的中高端品牌之一,中国十大女鞋品牌,行业著名品牌,广州市天创鞋业有限公司)</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">11<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=121874&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">思加图</a><span style=\"font-size: 1em; font-weight: 700;\">Staccato</span>(源自意大利,香港和中国大陆著名的高档女鞋品牌,十大女鞋品牌,专业的女鞋制造商,百丽国际控股有限公司)</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">12<span style=\"font-size: 1em; font-weight: 700;\">人和春天</span>（中国女鞋行业时尚代表中高端品牌，中国女鞋品牌，行业著名时尚品牌人和春天女鞋有限公司）</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">13<span style=\"font-size: 1em; font-weight: 700;\">自由漫步</span><span style=\"font-size: 1em; font-weight: 700;\">free-bummel</span>(源于美国，是美式鞋业的领导品牌，中国名牌,中国驰名商标，是<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=133963270&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">广州市圣奇步鞋业有限公司</a>旗下品牌）</p><p><br/></p>', 1545112740, 1547625120, 1545026619, 0, 1, 0, 0),
(3, '进口德国男士皮鞋', 2, 0, 199, 50, 0, 100, '/public/attachment/images/20181221/fee7033d9cedb85099aaf4f6cd90b61a.jpg', 'a:1:{i:0;s:71:\"/public/attachment/images/20181221/fee7033d9cedb85099aaf4f6cd90b61a.jpg\";}', '<p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">男正装鞋是一种常见鞋类，一般与西服等正统服装相搭配。男正装鞋也称为绅士鞋，指外观造型庄重、大方，无过多装饰的男鞋（彩图71）。最为典型的传统男正装鞋是内耳式三接头皮鞋（<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=250860&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">牛津鞋</a>）和外耳式三接头皮鞋，拌带耳扣式鞋（也称僧侣鞋Monk）也属于正装鞋类。男正装鞋已不仅仅局限于以上几种式样，一些造型简洁大方的素头鞋、舌式鞋、前开口式鞋和“<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=63024516&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">包子</a>”鞋（莫卡辛Moccsin）等都可以作为正装鞋来穿。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">随着时代发展和<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=476097&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">雅皮士</a>的产生，造型有个性的准正装鞋随之出现，这种鞋在秉承传统正装鞋基础上，在造型式样上追求一种个性及其独特品位。一般楦型不过分怪异，有时紧跟正装<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=7757156&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">鞋楦</a>造型的流行，如铲头式、方头式、斜头式等，但在结构式样、材质选择搭配、配件装饰等方面进行一些独特的有个性的设计。男性穿正装鞋一方面是为特定场合需要，要与西服、礼服相搭配，另一方面男性选择穿正装鞋也是为显示自己的修养和地位。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">因此，男正装鞋设计必须是在高贵、典雅、大方的总体造型风格下进行，并在产品中充分表现出一种精致的工艺美感，即必须有精湛的工艺。男正装鞋设计特点是造型要素变化微妙、幅度较小，注重各造型要素之间的谐调性。高档正装鞋设计特别注意对高档材料的选用，包括<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=68308508&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">鞋面材料</a>、鞋底材料、配件和各种辅料。另外，正装鞋设计受流行时尚的影响较大（主要是楦型和材料使用上）。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">传统式样三节头正装鞋的造型款式基本是固定的、程式化的，一般不对其进行太大的设计变化，像包头长度、中帮长度和鞋身的长度之间都有固定的比例，中帮拖脚也有固定的位置等。当然，以上固定的各部件造型、比例、位置不是绝对不可以改变的，略微的设计变化也是允许的，如鞋型（楦型）稍微加长、变薄等。但传统式样几近完美，人们对它的审美也已形成格式化，为满足这一部分消费者的需求，传统式样三节头正装鞋在造型设计上可以基本保持不变。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">（一）<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=63382788&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">形态设计</a></p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">男正装鞋形态设计包括鞋头部立体形态的造型设计（<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=41790815&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">楦头</a>式造型设计）和帮部件平面<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=72800289&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">廓形</a>造型设计。男正装鞋形态设计一般将传统式样三节头鞋去除在外，前面已说过，这种鞋有其固定的程式化的形式，改变了它的造型特有格式，常常弄巧成拙。总体上说，无论哪种结构式样的正装鞋，它们的形态一方面注意控制变化的幅度，遵从和追寻正装鞋总体造型风格，另一方面注意正装鞋当时在形态方面的流行时尚（主要是楦型）。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">横条舌式男正装鞋形态设计重点在对横条的变化设计和头式造型设计上，横条也可以作为配件来看待。横条的设计变化一般是通过镂空、串花、编花、镶嵌等装饰工艺来完成。如果是高档男正装鞋，横条除要在造型上设计得优雅、新颖，同时在完成这种造型的装饰工艺上也要使人感到精致。正装鞋头式造型设计既要进行一些微妙造型变化，又要注意与流行时尚相结合。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">拌带耳扣式正装鞋（僧侣鞋）形态设计的重点在头式造型设计和鞋钎造型设计上，头式造型设计要大方、新颖但不要过分夸张。拌带造型要注意与鞋的头式造型风格特点相谐调，如果头式造型是优雅修长型的，那么拌带造型也应该是略窄、修长形的。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">（二）色彩设计</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">男正装鞋色彩一般都为黑色和棕色，并且通常用一色配色，也可以使用棕红色、棕黄色、白色、米色、咖啡色等颜色。男正装鞋配色设计受时尚性影响较大。男正装鞋由于其穿用的目的和性质，使得配色设计总体上要求沉稳、含蓄，不能用纯度过高及鲜艳的颜色。如果用二色配色，要用接近的<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=7810538&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">同类色</a>搭配。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">（三）材质设计</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">男正装鞋的材质一般用粒纹细致、手感柔软、滑爽、丰满的<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=304940&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">胎牛皮</a>和小牛皮比较理想。对于高档男正装鞋来说，稀有高档的鞋面材料是必不可少的，如<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=47506663&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">鳄鱼皮</a>、<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=55234481&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">鸵鸟皮</a>、<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=64435334&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">鲨鱼皮</a>等，鞋底材料往往也选用天然革，使鞋具更好的透气性。高档男正装鞋的鞋面材料设计运用，非常注重用高档材料的特殊肌理与其它肌理的较好普通鞋面材料搭配使用，这样设计既可以节省高档鞋材，同时还可以使鞋具有一种高贵感。另外由于肌理不同，还可以形成一种对比的美感。不同材质的组合运用，其设计的关键是不同材料部件造型和位置的安排要有新意。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">（四）配件设计</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">正装鞋上的配件设计依结构式样而定，一般情况下，耳式三节头正装鞋和前开口正装鞋不加装任何配件；舌式正装鞋通常要加装一个小的标牌配件，也可不加；在舌式鞋的跗背处加上横条配件，变成横条舌式鞋，横条舌式也有多种式样变化；拌带耳扣式正装鞋一般要加装既有实用价值又有装饰功能的鞋钎配件，也有用尼龙粘扣代替鞋钎的。配件在正装鞋上往往起到画龙点晴的作用，因此，正装鞋配件设计原则是既要与鞋的整体造型风格相谐调，又要有较高艺术性，真正起到点缀、美化、标识的作用。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">正装鞋上加装的标牌除具有点缀、美化的功能外，它还具有品牌标识和宣传的实用功能。制鞋企业自己品牌标志设计得是否新颖、独特、美观，直接决定了标牌在正装鞋上所发挥的功能效果。正装鞋上标牌在体积上要小巧、纤秀；在造型轮廓上有规矩廓形形态的，即标牌图案在一个完整轮廓造型中，也有自由形态的，即标牌没有一个规矩的廓形，如有的标牌廓形造型用的就是品牌标志的字母体或具象的图案轮廓。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">正装鞋标牌色彩一般有金色、银色和<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=7950178&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">古铜色</a>三种。金色和古铜色适合于各种颜色的正装鞋，银色除与棕色、咖啡色搭配不<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=74348729&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">太适合</a>外，与其它颜色的鞋面材料搭配都适合。正装鞋标牌材质应与鞋材相谐调，普通正装鞋用金属或仿金属效果比较好，高档鞋材及名牌正装鞋可以选用镀金、<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=382645&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">18K金</a>、纯银等高级金属材料，充分衬托出高档正装鞋的名贵感。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">正装鞋标牌工艺加工非常重要，精美的正装鞋上装配一个制作粗糙的标牌会极不谐调，使鞋的整体品质大打折扣。横条舌式正装鞋上的横条配件常常是这种款式的鞋的审美视觉中心，设计师对此处设计应给予特别重视。横条配件除要在形态设计上新颖别致外，还要对工艺手法进行深入考虑，独特或精致的工艺手法可以使横条配件产生一种独特的工艺美感，尤其对皮质横条配件更是如此。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">正装鞋上横条配件颜色一般要求与鞋面材料颜色一致，如果是金属件，金色和银色都可以，其中银色用在黑色鞋面材料上最为合适。横条配件材质选择上以皮革和金属为主，皮革材质显得柔和、高雅、亲切、合谐，金属材质则显得冷峻、严谨、自信、刚毅。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">拌带耳扣式正装鞋配件设计主要集中在鞋钎上，这种鞋的形态设计变化一般在鞋的头式造型（楦头式造型）、拌带和鞋耳部件的造型变化上，鞋钎在这种款式鞋的整体造型的构成中发挥着重要作用，设计师应精心设计。鞋钎形态设计应遵循大方与新颖相结合的原则，只大方，不新颖，会失去装饰审美功能，只新颖（或怪异）不大方又会与正装鞋性质不相吻合。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">在色彩上，棕色或咖啡色鞋面材料适合配金色或古铜色鞋钎，黑色鞋面材料用银色、金色和古铜色都适宜。鞋钎在材质肌理上有光亮型和亚光型两种。一般情况下，配件肌理效果与鞋面材质肌理效果相对比为好，例如在鳄鱼皮、鸵鸟皮等<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=464038&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">漫反射</a>光肌理的鞋面上，搭配一个光亮型的鞋钎，会使鞋面上产生一种材质对比的美感。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">准正装鞋的出现是伴随西方雅皮士一族的出现而产生的。所谓雅皮士是一些受过良好教育、有较高收入和社会地位，又与社会格格不入的一批在20世纪五六十年代成长起来的人。他们崇尚自由，追求个性解放，反传统，但这些人在对待事物的做法上比较温和、含蓄，不像其后出现的朋克一族那样狂放不羁。这样，一些突破常规但又与传统保持一定联系的准正统事物成为他们的追求，准正装鞋由此出现。当然，在喜欢准正装鞋的不一定就是雅皮士，一些有个性的青年人也越来越迷恋这种类型的鞋。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">准正装鞋设计属于“中庸”设计，在总体设计风格上，既要有传统的大方、端庄、典雅、高贵的一面，又要有创新、个性的一面。准正装鞋整体上看是反正统<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=76485169&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">反潮流</a>的，但它并不完全抛弃传统，它是在传统中显示个性的存在，在和谐中制造一种矛盾。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">准正装鞋形态设计主要包括头式造型设计、结构式样设计和帮部件造型设计。对这三个方面的设计，设计师可以在某个方面突破，也可以在几个方面都突破，形态方面的创新设计对准正装鞋整体设计效果影响较大。形态设计的方法一般是在传统式样基础上进行适度的变化或夸张，如传统三节头式样，设计师可将鞋的头式造型变得尖一些、方一些或薄一些、加长一些等。包头部件与中帮部件和鞋耳部件长度比改变一下，鞋耳部件变得更方或更圆一些，也可以加一些装饰工艺、配件等。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">彩图75是一款比较典型的准正装鞋，设计师在鞋款的结构式样上进行了比较大胆的设计，将多种人们熟悉的传统式样进行了独特组合，为打破正统的式样，设计师又将鞋头前部正中破缝和<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=7906822&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">鞋舌</a>两侧破缝，并结合粗犷的辑线工艺和材质对比，使此款鞋造型在新颖、大方中蕴藏着一种不合谐的怪异感，充分显示了准正装鞋的独特品位。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">准正装鞋色彩设计除常用的黑色、棕色和咖啡色，也可使用棕红色、棕黄色、米色、白色等较鲜艳与明亮的颜色。从色彩上将这种鞋塑造得具有个性感，表现出准正装鞋独特的品位。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">准正装鞋材质设计注重不同材质的搭配使用，如漆皮革与鳄鱼皮革、有独特图案的压花革或编织皮革与无图案的全粒面革搭配等都可以获得一种独特的视觉效果。有金属配件的准正装鞋，对配件的设计运用要给予充分重视。配件对准正装鞋的风格塑造可以发挥很大作用。这种作用往往是通过配件奇特的造型、加大的体量和冷峻质感等方面表现出来的。</p><p><br/></p>', 1545026940, 1553845920, 1545027090, 0, 1, 0, 0),
(4, '劳力士经典高贵男士手表', 2, 0, 1000, 200, 1600, 888, '/public/attachment/images/20181221/fee7033d9cedb85099aaf4f6cd90b61a.jpg', 'a:1:{i:0;s:71:\"/public/attachment/images/20181221/fee7033d9cedb85099aaf4f6cd90b61a.jpg\";}', '<p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">劳力士手表是瑞士产的名贵手表，它的设计、制作、始终保持传统的风格。它的性能包括全自动、单历、双历、防水、防尘等，做工精益求精，特别是表盘、表把及表带、雕刻成的<a class=\"ed_inner_link\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=525485\" target=\"_blank\" ss_c=\"ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">王冠</a>更是其高品质的标志。因为名牌手表在制造方面使用先进设备、高质材料，达到了加工精细、高<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=7692022&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">光洁度</a>。真劳力士手表，不论做工、文字都十分精细，有完美的手感，这是鉴别真伪的一个重要方面。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">从外表看劳力士手表壳精细、表带、王冠、英文字清楚、完整，而仿造表外壳粗糙，文字稍模糊。尤其表底、盖齿，十分精细而清楚、洁亮而有立体感，而仿造品粗糙而没有立体感，一般都比较浅。重量方面，真的手感沉实一些，假的轻得多（注：但有些仿造的里面也加一个铜圈）。就<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=382645&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">18K金</a>质地<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=120269&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">劳力士</a>的表壳、表带而言，真品一般由新到旧黄金品质、颜色不变，仿造品有<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=4177473&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">14K</a>金或者更低一些K金或镀上18K金的，但时间一长，就会变回原色。<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=101570586&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">满天星</a>的劳力士、镶在表上的钻石都是真的，而仿造品的钻石则是假的。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">市场上也有出现真表壳、表带、里面放假机芯的<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=8269309&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">劳力士表</a>，所以最好用专用工具开表。真的劳力士机芯，一撬去自动舵，机芯夹板上刻有ROLEX字样，还刻有机芯号：1570、2135、3135、3035……等，假的则没有。真的机芯机件精细、纹线清楚，假的机芯比较粗糙发暗。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">另外，拆下表带，表壳的侧表耳中间有表厂的型批号，下侧表耳中间有表号，仿造的基本没有（有些仿品也有，但不够齐整和清楚）；劳力士手表都有质量<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=457769&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">保证书</a>，右上角有两行以上阿拉伯字号码针孔刺字，齐整而清楚，而假的只一行针孔刺字，很不统一，不太齐整，但不能以此来辨别，因为市场上也有假的保证书。</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">Cal 4130是Cal 4030的<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=55457161&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">替代者</a>，是Rolex自厂开发的第一款计时自动上链机芯，同样采用了柱状轮进行计时。但是其内部构造更好的解决了计时针启动和停止的时候有抖动情况发生的问题。同时解决让计时芯在计时情况下依旧可以保持腕表本身走时精准的问题。Rolex Daytona的Cal 4130依旧是“超级<a class=\"ed_inner_link\" target=\"_blank\" href=\"https://baike.sogou.com/lemma/ShowInnerLink.htm?lemmaId=470781&ss_c=ssc.citiao.link\" style=\"color: rgb(51, 102, 204); text-decoration-line: none;\">天文台</a>官方认证”，其旋入式计时按钮保证了计时按钮这个部位能够拥有100米的防水</p><p style=\"margin-top: 0px; margin-bottom: 15px; padding: 0px; font-family: arial, \" pingfang=\"\" text-indent:=\"\" line-height:=\"\" color:=\"\" font-size:=\"\" white-space:=\"\" background-color:=\"\">Rolex Daytona是仅次于Day Date的高价表，甚至其钢款都要超过6W RMB，哪怕是在HK或者JP购买。同样，我一直觉得Rolex Daytona是最好的计时表，不是因为它的牌子有多好，也不是因为其功能有多强。归根结底的一条——它秉承了Rolex最牛逼的传统——稳，准，狠——男人的表，就应该这样。</p><p><br/></p>', 1545027120, 1549093980, 1545027482, 3, 1, 0, 0),
(5, '男士二手背包', 2, 0, 88, 10, 0, 60, '/public/attachment/images/20181221/fee7033d9cedb85099aaf4f6cd90b61a.jpg', 'a:1:{i:0;s:71:\"/public/attachment/images/20181221/fee7033d9cedb85099aaf4f6cd90b61a.jpg\";}', '<div class=\"para-title level-3\" label-module=\"para-title\" style=\"clear: both; zoom: 1; margin: 20px 0px 12px; line-height: 20px; font-size: 18px; font-family: \" microsoft=\"\" color:=\"\" white-space:=\"\" background-color:=\"\"><h3 class=\"title-text\" style=\"margin: 0px; padding: 0px; font-size: 18px; font-weight: 400;\">根据人数</h3></div><div class=\"para\" label-module=\"para\" style=\"font-size: 14px; overflow-wrap: break-word; color: rgb(51, 51, 51); margin-bottom: 15px; text-indent: 2em; line-height: 24px; zoom: 1; font-family: arial, 宋体, sans-serif; white-space: normal; background-color: rgb(255, 255, 255);\">独自<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E9%83%8A%E6%B8%B8\" style=\"color: rgb(19, 110, 194); text-decoration-line: none;\">郊游</a>时，可选择25～35公升左右的背包。假日带家人孩子出游时，从照顾家人的角度考虑，需选择40公升左右的背包，外挂系统要多，方便帮助家人携带雨伞、相机、食物等物品。</div><div class=\"anchor-list\" style=\"position: relative; color: rgb(51, 51, 51); font-family: arial, 宋体, sans-serif; font-size: 12px; white-space: normal; background-color: rgb(255, 255, 255);\"><a style=\"color: rgb(19, 110, 194); position: absolute; top: -50px;\" name=\"6_2\"></a><a style=\"color: rgb(19, 110, 194); position: absolute; top: -50px;\" name=\"sub13349277_6_2\"></a><a style=\"color: rgb(19, 110, 194); position: absolute; top: -50px;\" name=\"根据性别\"></a><a style=\"color: rgb(19, 110, 194); position: absolute; top: -50px;\" name=\"6-2\"></a></div><div class=\"para-title level-3\" label-module=\"para-title\" style=\"clear: both; zoom: 1; margin: 20px 0px 12px; line-height: 20px; font-size: 18px; font-family: \" microsoft=\"\" color:=\"\" white-space:=\"\" background-color:=\"\"><h3 class=\"title-text\" style=\"margin: 0px; padding: 0px; font-size: 18px; font-weight: 400;\">根据性别</h3></div><div class=\"para\" label-module=\"para\" style=\"font-size: 14px; overflow-wrap: break-word; color: rgb(51, 51, 51); margin-bottom: 15px; text-indent: 2em; line-height: 24px; zoom: 1; font-family: arial, 宋体, sans-serif; white-space: normal; background-color: rgb(255, 255, 255);\">由于男女的体型和承重力不同，户外背包的选择也不太一样。一般一两天的短途郊游，男女通用30公升左右的背包就可以了。而超过2至3天的长距离旅行或<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E9%9C%B2%E8%90%A5\" style=\"color: rgb(19, 110, 194); text-decoration-line: none;\">露营</a>，要选择45至70升甚至更大的背包时，一般而男性选择55升左右背包，女性选择45升背包。</div><div class=\"anchor-list\" style=\"position: relative; color: rgb(51, 51, 51); font-family: arial, 宋体, sans-serif; font-size: 12px; white-space: normal; background-color: rgb(255, 255, 255);\"><a style=\"color: rgb(19, 110, 194); position: absolute; top: -50px;\" name=\"6_3\"></a><a style=\"color: rgb(19, 110, 194); position: absolute; top: -50px;\" name=\"sub13349277_6_3\"></a><a style=\"color: rgb(19, 110, 194); position: absolute; top: -50px;\" name=\"根据行程\"></a><a style=\"color: rgb(19, 110, 194); position: absolute; top: -50px;\" name=\"6-3\"></a></div><div class=\"para-title level-3\" label-module=\"para-title\" style=\"clear: both; zoom: 1; margin: 20px 0px 12px; line-height: 20px; font-size: 18px; font-family: \" microsoft=\"\" color:=\"\" white-space:=\"\" background-color:=\"\"><h3 class=\"title-text\" style=\"margin: 0px; padding: 0px; font-size: 18px; font-weight: 400;\">根据行程</h3></div><div class=\"para\" label-module=\"para\" style=\"font-size: 14px; overflow-wrap: break-word; color: rgb(51, 51, 51); margin-bottom: 15px; text-indent: 2em; line-height: 24px; zoom: 1; font-family: arial, 宋体, sans-serif; white-space: normal; background-color: rgb(255, 255, 255);\">单日往返郊游、骑行、登山活动，选择30公升以下背包。二到三日露营可选择30—40公升的多功能背包，四日以上徒步旅行，要放置帐篷、睡袋、防潮垫等户外装备，可选择45以上的公升的背包。另外，一般的野外活动和<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%94%80%E7%99%BB\" style=\"color: rgb(19, 110, 194); text-decoration-line: none;\">攀登</a>高山时所用的背包不同，登山所用的背包没有许多零件，喜欢登山的朋友需注意。</div><div class=\"anchor-list\" style=\"position: relative; color: rgb(51, 51, 51); font-family: arial, 宋体, sans-serif; font-size: 12px; white-space: normal; background-color: rgb(255, 255, 255);\"><a style=\"color: rgb(19, 110, 194); position: absolute; top: -50px;\" name=\"6_4\"></a><a style=\"color: rgb(19, 110, 194); position: absolute; top: -50px;\" name=\"sub13349277_6_4\"></a><a style=\"color: rgb(19, 110, 194); position: absolute; top: -50px;\" name=\"根据身长\"></a><a style=\"color: rgb(19, 110, 194); position: absolute; top: -50px;\" name=\"6-4\"></a></div><div class=\"para-title level-3\" label-module=\"para-title\" style=\"clear: both; zoom: 1; margin: 20px 0px 12px; line-height: 20px; font-size: 18px; font-family: \" microsoft=\"\" color:=\"\" white-space:=\"\" background-color:=\"\"><h3 class=\"title-text\" style=\"margin: 0px; padding: 0px; font-size: 18px; font-weight: 400;\">根据身长</h3></div><div class=\"para\" label-module=\"para\" style=\"font-size: 14px; overflow-wrap: break-word; color: rgb(51, 51, 51); margin-bottom: 15px; text-indent: 2em; line-height: 24px; zoom: 1; font-family: arial, 宋体, sans-serif; white-space: normal; background-color: rgb(255, 255, 255);\">挑选背包之前，首先需要量一下自己的后上身长，即颈椎突起处至最后一节腰椎的距离。如果躯干长度小于45厘米，应该买一个小号的包。如果躯干长度在45—52厘米之间，应该选一个中号的包。如果你的躯干长度在52厘米以上，应该挑一个大号的包。</div><p><br/></p>', 1545029400, 1550217180, 1545029427, 0, 1, 0, 0),
(6, '拍卖1', 2, 0, 0, 0, 0, 0, '/public/attachment/images/20181224/2c3d6d1a750a61d07f20600732eda930.jpg', 'a:1:{i:0;s:71:\"/public/attachment/images/20181224/2c3d6d1a750a61d07f20600732eda930.jpg\";}', '<p>cewrwqer</p>', 1548317580, 1548317580, 1548317660, 0, 1, 0, 0),
(7, '001', 2, 0, 0, 0, 0, 0, '/public/attachment/images/20181225/11dff62422d0f1ebecbab5a73c8bb30e.jpg', 'a:1:{i:0;s:71:\"/public/attachment/images/20181225/11dff62422d0f1ebecbab5a73c8bb30e.jpg\";}', '<p>aewrwqr</p>', 1548317760, 1548490560, 1548317815, 0, 1, 0, 0);
-- --------------------------------------------------------
--
-- 表的结构 `suliss_shop_auction_goods_category`
--
CREATE TABLE `suliss_shop_auction_goods_category` (
`id` int(11) NOT NULL,
`name` varchar(50) DEFAULT NULL,
`thumb` varchar(255) DEFAULT NULL,
`displayorder` tinyint(3) UNSIGNED DEFAULT '0',
`enabled` tinyint(1) DEFAULT '1',
`advimg` varchar(255) DEFAULT '',
`advurl` varchar(500) DEFAULT '',
`isrecommand` tinyint(3) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 插入之前先把表清空（truncate） `suliss_shop_auction_goods_category`
--
TRUNCATE TABLE `suliss_shop_auction_goods_category`;
--
-- 转存表中的数据 `suliss_shop_auction_goods_category`
--
INSERT INTO `suliss_shop_auction_goods_category` (`id`, `name`, `thumb`, `displayorder`, `enabled`, `advimg`, `advurl`, `isrecommand`) VALUES
(2, '分类1', '/public/attachment/images/20181221/9f347732463586cd8208695dd225779b.png', 50, 1, '', '', 0);
-- --------------------------------------------------------
--
-- 表的结构 `suliss_shop_auction_order`
--
CREATE TABLE `suliss_shop_auction_order` (
`id` int(10) UNSIGNED NOT NULL,
`ordersn` varchar(50) NOT NULL COMMENT '订单编号',
`mid` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
`goodsid` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '商品编号',
`price` decimal(10,2) DEFAULT '0.00' COMMENT '交易价格',
`bondprice` decimal(10,2) DEFAULT '0.00' COMMENT '保证金',
`stprice` decimal(10,2) NOT NULL DEFAULT '0.00',
`status` tinyint(3) DEFAULT '0',
`paytype` tinyint(1) DEFAULT '0',
`paystatus` tinyint(3) NOT NULL DEFAULT '0',
`paytime` int(11) NOT NULL DEFAULT '0',
`transid` varchar(30) DEFAULT '0',
`addressid` int(11) DEFAULT '0',
`address` text,
`expresscom` varchar(30) NOT NULL DEFAULT '',
`expresssn` varchar(50) NOT NULL DEFAULT '',
`express` varchar(255) NOT NULL DEFAULT '',
`sendtime` int(11) NOT NULL DEFAULT '0',
`fetchtime` int(11) NOT NULL DEFAULT '0',
`finishtime` int(11) NOT NULL DEFAULT '0',
`mobile` varchar(11) NOT NULL DEFAULT '',
`realname` varchar(50) NOT NULL DEFAULT '',
`remark` varchar(500) NOT NULL DEFAULT '',
`createtime` int(10) UNSIGNED NOT NULL COMMENT '购买时间',
`deleted` tinyint(3) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 插入之前先把表清空（truncate） `suliss_shop_auction_order`
--
TRUNCATE TABLE `suliss_shop_auction_order`;
--
-- 转存表中的数据 `suliss_shop_auction_order`
--
INSERT INTO `suliss_shop_auction_order` (`id`, `ordersn`, `mid`, `goodsid`, `price`, `bondprice`, `stprice`, `status`, `paytype`, `paystatus`, `paytime`, `transid`, `addressid`, `address`, `expresscom`, `expresssn`, `express`, `sendtime`, `fetchtime`, `finishtime`, `mobile`, `realname`, `remark`, `createtime`, `deleted`) VALUES
(25, 'AU20181218151237880746', 21, 1, '1150.00', '150.00', '500.00', 0, 1, 0, 0, '0', 0, NULL, '', '', '', 0, 0, 0, '', '', '', 1545117157, 0);
-- --------------------------------------------------------
--
-- 表的结构 `suliss_shop_auction_record`
--
CREATE TABLE `suliss_shop_auction_record` (
`id` int(10) UNSIGNED NOT NULL,
`recordsn` varchar(50) NOT NULL COMMENT '订单编号',
`mid` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
`goodsid` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '商品id',
`price` decimal(10,2) DEFAULT '0.00' COMMENT '交易价格',
`status` tinyint(3) DEFAULT '0',
`createtime` int(10) UNSIGNED NOT NULL COMMENT '购买时间'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 插入之前先把表清空（truncate） `suliss_shop_auction_record`
--
TRUNCATE TABLE `suliss_shop_auction_record`;
--
-- 转存表中的数据 `suliss_shop_auction_record`
--
INSERT INTO `suliss_shop_auction_record` (`id`, `recordsn`, `mid`, `goodsid`, `price`, `status`, `createtime`) VALUES
(1, 'AU20190104104039681381', 21, 1, '545.00', 1, 1546569639),
(2, 'AU20190104104506892644', 21, 1, '549.00', 1, 1546569906),
(3, 'AU20190104133004271469', 21, 1, '599.00', 1, 1546579804),
(4, 'AU20190104163800053367', 21, 4, '1200.00', 1, 1546591080),
(5, 'AU20190104163858948721', 21, 4, '1400.00', 1, 1546591138),
(6, 'AU20190104164734278444', 21, 4, '1600.00', 1, 1546591654);
-- --------------------------------------------------------
--
-- 表的结构 `suliss_shop_banner`
--
CREATE TABLE `suliss_shop_banner` (
`id` int(11) NOT NULL,
`bannername` varchar(50) DEFAULT NULL,
`link` varchar(255) DEFAULT '',
`thumb` varchar(255) DEFAULT '',
`displayorder` int(11) DEFAULT '0',
`enabled` int(11) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 插入之前先把表清空（truncate） `suliss_shop_banner`
--
TRUNCATE TABLE `suliss_shop_banner`;
--
-- 转存表中的数据 `suliss_shop_banner`
--
INSERT INTO `suliss_shop_banner` (`id`, `bannername`, `link`, `thumb`, `displayorder`, `enabled`) VALUES
(9, '6', '', '/public/attachment/images/20181211/59fb62ee2215b40e8a198842faa652ea.jpg', 6, 1),
(10, '88', '', '/public/attachment/images/20181211/473d7ff3d2f6e5cefc09bf07ea54bc48.jpg', 88, 1),
(11, '89', '', '/public/attachment/images/20181211/b6ab7194916f642e6d51b7286fc5d50e.jpg', 89, 1);
-- --------------------------------------------------------
--
-- 表的结构 `suliss_shop_bargain_actor`
--
CREATE TABLE `suliss_shop_bargain_actor` (
`id` int(11) NOT NULL,
`goods_id` int(11) NOT NULL,
`mid` int(11) DEFAULT '0',
`now_price` decimal(9,2) NOT NULL,
`created_time` datetime NOT NULL,
`update_time` datetime NOT NULL,
`bargain_times` int(10) NOT NULL,
`nickname` varchar(20) NOT NULL,
`head_image` varchar(200) NOT NULL,
`bargain_price` decimal(9,2) NOT NULL,
`status` tinyint(2) NOT NULL,
`account_id` int(11) NOT NULL,
`initiate` tinyint(4) NOT NULL DEFAULT '0',
`order` int(11) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
--
-- 插入之前先把表清空（truncate） `suliss_shop_bargain_actor`
--
TRUNCATE TABLE `suliss_shop_bargain_actor`;
-- --------------------------------------------------------
--
-- 表的结构 `suliss_shop_city_express`
--
CREATE TABLE `suliss_shop_city_express` (
`id` int(11) NOT NULL,
`merchid` int(11) DEFAULT '0',
`start_fee` decimal(10,2) DEFAULT '0.00',
`start_km` int(11) DEFAULT '0',
`pre_km` int(11) DEFAULT '0',
`pre_km_fee` decimal(10,2) DEFAULT '0.00',
`fixed_km` int(11) DEFAULT '0',
`fixed_fee` decimal(10,2) DEFAULT '0.00',
`receive_goods` int(11) DEFAULT NULL,
`lng` varchar(255) DEFAULT '',
`lat` varchar(255) DEFAULT '',
`range` int(11) DEFAULT '0',
`zoom` int(11) NOT NULL DEFAULT '13',
`express_type` int(11) NOT NULL DEFAULT '0',
`config` varchar(255) NOT NULL DEFAULT '',
`tel1` varchar(255) DEFAULT '',
`tel2` varchar(255) DEFAULT '',
`is_sum` tinyint(1) DEFAULT '0',
`is_dispatch` tinyint(1) DEFAULT '1',
`enabled` tinyint(1) DEFAULT '0',
`geo_key` varchar(255) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 插入之前先把表清空（truncate） `suliss_shop_city_express`
--
TRUNCATE TABLE `suliss_shop_city_express`;
-- --------------------------------------------------------
--
-- 表的结构 `suliss_shop_core_paylog`
--
CREATE TABLE `suliss_shop_core_paylog` (
`plid` bigint(11) UNSIGNED NOT NULL,
`type` varchar(20) NOT NULL DEFAULT '',
`mid` int(10) NOT NULL DEFAULT '0',
`uniontid` varchar(64) NOT NULL DEFAULT '',
`tid` varchar(128) NOT NULL,
`credit` int(10) NOT NULL DEFAULT '0',
`creditmoney` decimal(10,2) NOT NULL DEFAULT '0.00',
`fee` decimal(10,2) NOT NULL DEFAULT '0.00',
`status` tinyint(4) NOT NULL DEFAULT '0',
`module` varchar(50) NOT NULL,
`tag` varchar(2000) NOT NULL DEFAULT '',
`is_usecard` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
`card_type` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
`card_id` varchar(50) NOT NULL DEFAULT '',
`card_fee` decimal(10,2) UNSIGNED NOT NULL DEFAULT '0.00',
`encrypt_code` varchar(100) NOT NULL DEFAULT '',
`createtime` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 插入之前先把表清空（truncate） `suliss_shop_core_paylog`
--
TRUNCATE TABLE `suliss_shop_core_paylog`;
--
-- 转存表中的数据 `suliss_shop_core_paylog`
--
INSERT INTO `suliss_shop_core_paylog` (`plid`, `type`, `mid`, `uniontid`, `tid`, `credit`, `creditmoney`, `fee`, `status`, `module`, `tag`, `is_usecard`, `card_type`, `card_id`, `card_fee`, `encrypt_code`, `createtime`) VALUES
(832, '', 21, '', 'AUB20190103175227636468', 0, '0.00', '150.00', 0, 'auction_bond', '', 0, 0, '', '0.00', '', 0),
(831, '', 21, '', 'AUB20190103174647282968', 0, '0.00', '150.00', 0, 'auction_bond', '', 0, 0, '', '0.00', '', 0),
(829, '', 21, '', 'AUB20190103174602623232', 0, '0.00', '150.00', 0, 'auction_bond', '', 0, 0, '', '0.00', '', 0),
(830, '', 21, '', 'AUB20190103174615673464', 0, '0.00', '150.00', 0, 'auction_bond', '', 0, 0, '', '0.00', '', 0),
(828, '', 21, '', 'AUB20190103174556147467', 0, '0.00', '150.00', 0, 'auction_bond', '', 0, 0, '', '0.00', '', 0),
(826, '', 21, '', 'AUB20190103174512469646', 0, '0.00', '150.00', 0, 'auction_bond', '', 0, 0, '', '0.00', '', 0),
(827, '', 21, '', 'AUB20190103174546520686', 0, '0.00', '150.00', 0, 'auction_bond', '', 0, 0, '', '0.00', '', 0),
(825, '', 21, '', 'AUB20190103174416449686', 0, '0.00', '150.00', 0, 'auction_bond', '', 0, 0, '', '0.00', '', 0),
(824, '', 21, '', 'AUB20190103174318917636', 0, '0.00', '150.00', 0, 'auction_bond', '', 0, 0, '', '0.00', '', 0),
(823, '', 21, '', 'AUB20190103174256424696', 0, '0.00', '150.00', 0, 'auction_bond', '', 0, 0, '', '0.00', '', 0),
(822, '', 21, '', 'AUB20190103174228248616', 0, '0.00', '150.00', 0, 'auction_bond', '', 0, 0, '', '0.00', '', 0),
(821, '', 21, '', 'AUB20190103174210444208', 0, '0.00', '150.00', 0, 'auction_bond', '', 0, 0, '', '0.00', '', 0),
(820, '', 21, '', 'AUB20190103174145736244', 0, '0.00', '150.00', 0, 'auction_bond', '', 0, 0, '', '0.00', '', 0),
(819, '', 21, '', 'AUB20190103174141488381', 0, '0.00', '150.00', 0, 'auction_bond', '', 0, 0, '', '0.00', '', 0),
(818, '', 21, '', 'AUB20190103174122321462', 0, '0.00', '150.00', 0, 'auction_bond', '', 0, 0, '', '0.00', '', 0),
(817, '', 21, '', 'AUB20190103174035604886', 0, '0.00', '150.00', 0, 'auction_bond', '', 0, 0, '', '0.00', '', 0),
(816, '', 21, '', 'AUB20190103174035516866', 0, '0.00', '150.00', 0, 'auction_bond', '', 0, 0, '', '0.00', '', 0),
(815, '', 21, '', 'AUB20190103174034284241', 0, '0.00', '150.00', 0, 'auction_bond', '', 0, 0, '', '0.00', '', 0),
(814, '', 21, '', 'AUB20190103174033424734', 0, '0.00', '150.00', 0, 'auction_bond', '', 0, 0, '', '0.00', '', 0),
(813, '', 21, '', 'AUB20190103173755486366', 0, '0.00', '150.00', 0, 'auction_bond', '', 0, 0, '', '0.00', '', 0),
(812, '', 21, '', 'AUB20190103173711826278', 0, '0.00', '150.00', 0, 'auction_bond', '', 0, 0, '', '0.00', '', 0),
(811, '', 21, '', 'AUB20190103173509183446', 0, '0.00', '150.00', 0, 'auction_bond', '', 0, 0, '', '0.00', '', 0),
(810, '', 21, '', 'AUB20190103173342184292', 0, '0.00', '150.00', 0, 'auction_bond', '', 0, 0, '', '0.00', '', 0),
(809, '', 0, '', 'PT20190102173308875816', 0, '0.00', '0.04', 0, 'groups', '', 0, 0, '', '0.00', '', 0),
(808, 'wechat', 22, '', 'PT20190102110217822692', 0, '0.00', '0.02', 1, 'groups', 'a:1:{s:14:\"transaction_id\";s:28:\"4200000251201901027731163502\";}', 0, 0, '', '0.00', '', 1546398144),
(807, 'wechat', 22, '', 'PT20190102101521484667', 0, '0.00', '0.02', 1, 'groups', 'a:1:{s:14:\"transaction_id\";s:28:\"4200000254201901024526789787\";}', 0, 0, '', '0.00', '', 1546395328),
(806, 'wechat', 21, '', 'PT20190102092605223668', 0, '0.00', '0.02', 1, 'groups', 'a:1:{s:14:\"transaction_id\";s:28:\"4200000258201901028179661069\";}', 0, 0, '', '0.00', '', 1546392375),
(805, 'wechat', 22, '', 'PT20181229172045486610', 0, '0.00', '0.05', 1, 'groups', 'a:1:{s:14:\"transaction_id\";s:28:\"4200000248201812298929482046\";}', 0, 0, '', '0.00', '', 1546075251),
(798, 'wechat', 22, '', 'PT20181229104410654748', 0, '0.00', '0.03', 1, 'groups', 'a:1:{s:14:\"transaction_id\";s:28:\"4200000248201812299047555680\";}', 0, 0, '', '0.00', '', 1546051456),
(799, 'wechat', 22, '', 'PT20181229154545668252', 0, '0.00', '0.02', 1, 'groups', 'a:1:{s:14:\"transaction_id\";s:28:\"4200000251201812290557333236\";}', 0, 0, '', '0.00', '', 1546069551),
(800, 'wechat', 22, '', 'PT20181229163758490867', 0, '0.00', '0.04', 1, 'groups', 'a:1:{s:14:\"transaction_id\";s:28:\"4200000253201812291260102561\";}', 0, 0, '', '0.00', '', 1546072699),
(801, '', 22, '', 'PT20181229163828210423', 0, '0.00', '0.03', 0, 'groups', '', 0, 0, '', '0.00', '', 0),
(802, 'wechat', 22, '', 'PT20181229163839235984', 0, '0.00', '0.01', 1, 'groups', 'a:1:{s:14:\"transaction_id\";s:28:\"4200000248201812293466518861\";}', 0, 0, '', '0.00', '', 1546072725),
(803, 'wechat', 22, '', 'PT20181229164814642183', 0, '0.00', '0.06', 1, 'groups', 'a:1:{s:14:\"transaction_id\";s:28:\"4200000240201812298655854167\";}', 0, 0, '', '0.00', '', 1546073300),
(804, 'wechat', 22, '', 'PT20181229172003806149', 0, '0.00', '0.02', 1, 'groups', 'a:1:{s:14:\"transaction_id\";s:28:\"4200000245201812293630934750\";}', 0, 0, '', '0.00', '', 1546075209),
(796, '', 21, '', 'PT20181229092207802236', 0, '0.00', '0.02', 0, 'groups', '', 0, 0, '', '0.00', '', 0),
(797, 'wechat', 22, '', 'PT20181229104356606236', 0, '0.00', '0.02', 1, 'groups', 'a:1:{s:14:\"transaction_id\";s:28:\"4200000244201812299339586870\";}', 0, 0, '', '0.00', '', 1546051443),
(833, '', 21, '', 'AUB20190103175231284246', 0, '0.00', '150.00', 0, 'auction_bond', '', 0, 0, '', '0.00', '', 0),
(834, '', 21, '', 'AUB20190103175233438130', 0, '0.00', '150.00', 0, 'auction_bond', '', 0, 0, '', '0.00', '', 0),
(835, '', 21, '', 'AUB20190103175241664720', 0, '0.00', '150.00', 0, 'auction_bond', '', 0, 0, '', '0.00', '', 0),
(836, '', 21, '', 'AUB20190103175329600817', 0, '0.00', '150.00', 0, 'auction_bond', '', 0, 0, '', '0.00', '', 0),
(837, '', 21, '', 'AUB20190103175428251626', 0, '0.00', '150.00', 0, 'auction_bond', '', 0, 0, '', '0.00', '', 0),
(838, '', 21, '', 'AUB20190103175433942214', 0, '0.00', '150.00', 0, 'auction_bond', '', 0, 0, '', '0.00', '', 0),
(839, '', 21, '', 'AUB20190103175516962383', 0, '0.00', '60.00', 0, 'auction_bond', '', 0, 0, '', '0.00', '', 0),