-
Notifications
You must be signed in to change notification settings - Fork 0
/
findgift.sql
287 lines (244 loc) · 66.9 KB
/
findgift.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
-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: 2016-05-23 14:25:23
-- 服务器版本： 10.1.8-MariaDB
-- PHP Version: 5.6.14
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `findgift`
--
-- --------------------------------------------------------
--
-- 表的结构 `fg_goods`
--
CREATE TABLE `fg_goods` (
`id` int(11) NOT NULL,
`brand` varchar(50) COLLATE utf8_bin DEFAULT NULL,
`goodsname` varchar(200) COLLATE utf8_bin NOT NULL,
`price` varchar(50) COLLATE utf8_bin DEFAULT NULL,
`price_E` float DEFAULT NULL,
`post` int(2) NOT NULL DEFAULT '0',
`link` varchar(500) COLLATE utf8_bin DEFAULT NULL,
`imagename` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`content` text COLLATE utf8_bin,
`description` text COLLATE utf8_bin,
`type1` varchar(50) COLLATE utf8_bin DEFAULT NULL,
`type2` varchar(50) COLLATE utf8_bin DEFAULT NULL,
`type3` varchar(50) COLLATE utf8_bin DEFAULT NULL,
`application` varchar(50) COLLATE utf8_bin DEFAULT NULL,
`application_EX` float DEFAULT NULL,
`application_EY` float DEFAULT NULL,
`art_tech` varchar(50) COLLATE utf8_bin DEFAULT NULL,
`art_tech_nearby` varchar(50) COLLATE utf8_bin DEFAULT NULL,
`art_tech_EX` float DEFAULT NULL,
`art_tech_EY` float DEFAULT NULL,
`createtime` varchar(50) COLLATE utf8_bin NOT NULL,
`createman` varchar(50) COLLATE utf8_bin NOT NULL,
`seller` varchar(50) COLLATE utf8_bin DEFAULT NULL,
`composite` float DEFAULT NULL,
`a3` varchar(50) COLLATE utf8_bin DEFAULT NULL,
`a4` varchar(50) COLLATE utf8_bin DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
--
-- 转存表中的数据 `fg_goods`
--
INSERT INTO `fg_goods` (`id`, `brand`, `goodsname`, `price`, `price_E`, `post`, `link`, `imagename`, `content`, `description`, `type1`, `type2`, `type3`, `application`, `application_EX`, `application_EY`, `art_tech`, `art_tech_nearby`, `art_tech_EX`, `art_tech_EY`, `createtime`, `createman`, `seller`, `composite`, `a3`, `a4`) VALUES
(1, '乐上/LEXON', 'HOOK SPEAKER 音箱', '419', 2.62221, 0, 'http://www.zglpdq.com.cn/productdetail.php?id=11272', '20151117/564a8df0a6771.jpg', '<p><span style="color: rgb(51, 51, 51); font-family: 微软雅黑; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); display: inline !important; float: none;">商品名称：HOOK SPEAKER 音箱</span><br style="font-family: 微软雅黑; color: rgb(51, 51, 51); font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);"/><span style="color: rgb(51, 51, 51); font-family: 微软雅黑; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); display: inline !important; float: none;">代 码： LA95</span><br style="font-family: 微软雅黑; color: rgb(51, 51, 51); font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);"/><span style="color: rgb(51, 51, 51); font-family: 微软雅黑; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); display: inline !important; float: none;">尺 寸： Φ12*4.1cm</span><br style="font-family: 微软雅黑; color: rgb(51, 51, 51); font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);"/><span style="color: rgb(51, 51, 51); font-family: 微软雅黑; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); display: inline !important; float: none;">重 量： 310g</span><br style="font-family: 微软雅黑; color: rgb(51, 51, 51); font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);"/><br style="font-family: 微软雅黑; color: rgb(51, 51, 51); font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);"/><span style="color: rgb(51, 51, 51); font-family: 微软雅黑; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); display: inline !important; float: none;">箱 规：20pcs/外箱，10pcs/内箱</span><br style="font-family: 微软雅黑; color: rgb(51, 51, 51); font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);"/><span style="color: rgb(51, 51, 51); font-family: 微软雅黑; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); display: inline !important; float: none;">颜 色：深蓝色-灰色-红色-浅绿色</span><br style="font-family: 微软雅黑; color: rgb(51, 51, 51); font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);"/><span style="color: rgb(51, 51, 51); font-family: 微软雅黑; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); display: inline !important; float: none;">材 料： ABS橡胶<span class="Apple-converted-space">&nbsp;</span></span><br style="font-family: 微软雅黑; color: rgb(51, 51, 51); font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);"/><span style="color: rgb(51, 51, 51); font-family: 微软雅黑; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); display: inline !important; float: none;">电 源：5V 500MAH</span><br style="font-family: 微软雅黑; color: rgb(51, 51, 51); font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);"/><br style="font-family: 微软雅黑; color: rgb(51, 51, 51); font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);"/><span style="color: rgb(51, 51, 51); font-family: 微软雅黑; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); display: inline !important; float: none;">产品功能：可充电蓝牙音箱(有效距离远至10米) - 适用于smartphone,等具蓝牙功能3C产品– AUX IN –触碰式电子音量调节-双颗3W喇叭-充电时间2~3小时，可播放时间5~6小时</span><br style="font-family: 微软雅黑; color: rgb(51, 51, 51); font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);"/><br style="font-family: 微软雅黑; color: rgb(51, 51, 51); font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);"/><span style="color: rgb(51, 51, 51); font-family: 微软雅黑; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); display: inline !important; float: none;">产品描述：甜甜圈型蓝牙音箱，颜色多彩，精致细密的网格层与中空硅胶套完美结合，柔美独特，俏皮可爱，它可悬挂于墙上，也可吊挂于单车上，便利精致生活。高配置达到Bluetooth v4.0+EDR，可以在嘈杂环境极大消除干扰，可快速清除传送讯息。在一个静谧微倦的下午，品着热咖，聆听着甜甜圈音箱洋溢出的阵阵音符，不失一种美妙的享受。</span><br style="font-family: 微软雅黑; color: rgb(51, 51, 51); font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);"/><br style="font-family: 微软雅黑; color: rgb(51, 51, 51); font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);"/><span style="color: rgb(51, 51, 51); font-family: 微软雅黑; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); display: inline !important; float: none;">设 计 师： Valentina Ciotto&amp; Simone Spalvieri</span><br style="font-family: 微软雅黑; color: rgb(51, 51, 51); font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);"/><span style="color: rgb(51, 51, 51); font-family: 微软雅黑; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); display: inline !important; float: none;">设计师简介：Valenthna Del Clotto 和 Simon Spalvieri在意大利著名阿斯科利皮切诺学院毕业并获得工业技术学士学位后，转站米兰理工大学继续深造。</span><br style="font-family: 微软雅黑; color: rgb(51, 51, 51); font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);"/><span style="color: rgb(51, 51, 51); font-family: 微软雅黑; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); display: inline !important; float: none;">并于2009年在米兰开设自己的工作室，此后屡获国际设计大奖的他们与各大著名意大利公司及一些国际公司合作，赢获不少嘉奖。</span></p>', '商品名称：HOOK SPEAKER 音箱代 码： LA95尺 寸： Φ12*4.1cm重 量： 310g箱 规：20pcs/外箱，10pcs/内箱颜 色：深蓝色-灰色-红色-浅绿色材 料： ABS橡胶 电 源：5V 500MAH产品功能：可', '数码', '生活', '家庭', '[工作]', -0.5, 0.866025, '[50%，50%]', '4,6', 0, 0, '15-12-03 03:44:31', 'admin', '淘宝', 5.41724, NULL, NULL),
(2, '鸥翡妮OPHANIE', '纯洁的心（3.5克拉）', '299.0-799.0', 2.47567, 0, 'http://www.liyi99.com/product/giftview13911.html', '20151117/564a90ea5e568.jpg', '<h2 style="margin: 0px auto; padding: 0px; line-height: 30px; text-rendering: optimizelegibility; clear: both; overflow: hidden; font-size: 14px; white-space: normal;">礼品属性</h2><ul style="list-style-type: none;" class=" list-paddingleft-2"><li><p>礼品尺寸:2.5*1.3CM</p></li><li><p>礼品材质：天然托帕石/紫晶</p></li><li><p>礼品颜色：蓝色/紫色</p></li></ul><p><img src="/ueditor/php/upload/image/20151117/1447727384291755.jpg"/><img src="/ueditor/php/upload/image/20151117/1447727399944977.jpg"/><img src="/ueditor/php/upload/image/20151117/1447727408387716.jpg"/><img src="/ueditor/php/upload/image/20151117/1447727414286419.jpg"/><img src="/ueditor/php/upload/image/20151117/1447727423710454.jpg"/><img src="/ueditor/php/upload/image/20151117/1447727431949281.jpg"/><img src="/ueditor/php/upload/image/20151117/1447727437112958.jpg"/><img src="/ueditor/php/upload/image/20151117/1447727440452694.jpg"/><img src="/ueditor/php/upload/image/20151117/1447727445107226.jpg"/><img src="/ueditor/php/upload/image/20151117/1447727450691434.jpg"/><img src="/ueditor/php/upload/image/20151117/1447727458670693.jpg"/><img src="/ueditor/php/upload/image/20151117/1447727464351139.jpg"/><img src="/ueditor/php/upload/image/20151117/1447727477762092.jpg"/></p>', '礼品属性礼品尺寸:2.5*1.3CM礼品材质：天然托帕石/紫晶礼品颜色：蓝色/紫色', '女人', '生活', '文艺', '[家庭]', -0.5, -0.866025, '[100%，0%]', '9', -1, 0, '15-12-04 10:45:13', 'admin', '淘宝', 8.11025, NULL, NULL),
(3, '千足金制品', '999千足银爱情银行卡+银卡证书', '198.0-228.0', 2.29667, 1, 'http://www.liyi99.com/product/giftview13661.html', '20151117/564a92e22b82f.jpg', '<h2 style="margin: 0px auto; padding: 0px; line-height: 30px; text-rendering: optimizelegibility; clear: both; overflow: hidden; font-size: 14px; white-space: normal;">礼品属性</h2><ul style="list-style-type: none;" class=" list-paddingleft-2"><li><p>礼品尺寸：80*50*0.32mm &nbsp; 包装尺寸：20cm*12cm*3cm &nbsp; 礼品材质：999千足银 &nbsp;</p></li><li><p>礼品重量：13.14g &nbsp; 礼品颜色：银色</p><p><img src="/ueditor/php/upload/image/20151117/1447727917378507.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447727925685926.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447727932912273.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447727940837484.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447727947106804.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447727954380831.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447727961772764.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447727967617764.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447727973338143.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447727981721556.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447727986127778.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447727992129628.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447727999903753.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447728007711573.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447728014532733.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447728030862184.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447728035268604.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447728040117734.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447728047976907.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447728053372999.jpg"/><br/></p></li></ul><p><br/></p>', '礼品属性礼品尺寸：80*50*0.32mm 包装尺寸：20cm*12cm*3cm 礼品材质：999千足银 礼品重量：13.14g 礼品颜色：银色', '女人', '文艺', '', '[家庭]', -0.5, -0.866025, '[100%，0%]', '9', -1, 0, '15-12-04 10:45:04', 'admin', 'liyi99', 7.52383, NULL, NULL),
(4, 'EAR动物暖手移动电源', '超Q萌物，动物4500毫安充电宝移动电源暖手宝', '128.0-138.0', 2.10721, 1, 'http://www.liyi99.com/product/giftview14064.html', '20151117/564a95c81660a.jpg', '<p><strong>礼品情意</strong></p><p>在冬天的日子里，人们总渴望得到温暖，这款萌萌哒的礼物，捧在手心，给你恰到好处的温暖，外观萌萌哒，摸起来很温暖哦，随身携带，你的口袋萌宠，这个冬天，让萌宠来温暖你。</p><h2 style="margin: 0px auto; padding: 0px; line-height: 30px; text-rendering: optimizelegibility; clear: both; overflow: hidden; font-size: 14px; white-space: normal;">礼品属性</h2><ul style="list-style-type: none;" class=" list-paddingleft-2"><li><p>包装尺寸：14cm*14cm*5cm &nbsp; 礼品材质：PC+铝+硅胶 &nbsp; 礼品重量：150.0g &nbsp; 礼品颜色：黄，粉，紫，蓝</p><p><img src="/ueditor/php/upload/image/20151117/1447728635268518.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447728642945924.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447728647997476.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447728653125489.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447728660214470.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447728667126685.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447728675734896.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447728681122434.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447728686928195.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447728691986632.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447728697126195.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447728702139612.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447728708458288.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447728719822423.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447728724764502.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447728730116030.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447728736721470.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447728741695909.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447728746131685.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447728751375581.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447728756257330.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447728765790579.jpg"/></p></li><li><p><img src="/ueditor/php/upload/image/20151117/1447728771121048.jpg"/><br/></p></li></ul><p><br/></p>', '礼品情意在冬天的日子里，人们总渴望得到温暖，这款萌萌哒的礼物，捧在手心，给你恰到好处的温暖，外观萌萌哒，摸起来很温暖哦，随身携带，你的口袋萌宠，这个冬天，让萌宠来温暖你。礼品属性包装尺寸：14cm*14cm*5cm 礼品材质：PC+铝+', '数码', '生活', '', '[娱乐、工作]', 0.5, 0.866025, '[0%，100%]', '1', 1, 0, '15-12-04 10:44:57', 'admin', 'liyi99', 2.37279, NULL, NULL),
(5, '薰衣草小熊蓝牙音箱', '普罗旺斯的爱情(薰衣草小熊)', '199.0', 2.29885, 1, 'http://www.liyi99.com/product/giftview13930.html', '20151117/564a9cc332433.jpg', '<p>礼品情意</p><p>你总说，我们结婚的时候，就去普罗旺斯度蜜月，要在大片大片的薰衣草里和我亲吻……亲爱的，我在很努力的去实现我们的梦想。我一定会在开满薰衣草的时候带你去普罗旺斯，到时候请一定要嫁给我！</p><h2 style="font-family: 微软雅黑; margin: 0px auto; padding: 0px; font-weight: bold; line-height: 30px; color: rgb(0, 0, 0); text-rendering: optimizelegibility; clear: both; overflow: hidden; font-size: 14px; font-style: normal; font-variant: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;">礼品属性</h2><ul class=" list-paddingleft-2" style="list-style-type: none;"><li><p>礼品尺寸：高30cm&nbsp;&nbsp; 包装尺寸：35cm*20cm*12cm&nbsp; 礼品材质：毛绒+薰衣草&nbsp;&nbsp; 礼品重量：500.0g&nbsp;&nbsp; 礼品颜色：紫色</p></li><li><p>温馨提示：配有数据线，没有充电头</p></li></ul><p><img src="/ueditor/php/upload/image/20151117/1447730427661226.jpg"/><img src="/ueditor/php/upload/image/20151117/1447730435891790.jpg"/><img src="/ueditor/php/upload/image/20151117/1447730443204573.jpg"/><br/></p><p><img src="/ueditor/php/upload/image/20151117/1447730450922601.jpg"/></p><p><img src="/ueditor/php/upload/image/20151117/1447730458769666.jpg"/><br/></p><p><img src="/ueditor/php/upload/image/20151117/1447730469821218.jpg"/><br/></p><p><img src="/ueditor/php/upload/image/20151117/1447730480107863.jpg"/><br/></p><p><img src="/ueditor/php/upload/image/20151117/1447730489382122.jpg"/><br/></p><p><img src="/ueditor/php/upload/image/20151117/1447730498558638.jpg"/><br/></p><p><img src="/ueditor/php/upload/image/20151117/1447730510104808.jpg"/></p>', '礼品情意你总说，我们结婚的时候，就去普罗旺斯度蜜月，要在大片大片的薰衣草里和我亲吻……亲爱的，我在很努力的去实现我们的梦想。我一定会在开满薰衣草的时候带你去普罗旺斯，到时候请一定要嫁给我！礼品属性礼品尺寸：高30cm 包装尺寸：35cm', '女人', '爱情', '生活', '[家庭、工作]', -1, 0, '[100%，0%]', '9', -1, 0, '15-12-04 10:44:42', 'admin', 'liyi99', 7.26961, NULL, NULL),
(6, '黑曜石', '辟邪平安（黑曜石）', '166.0', 2.22011, 1, 'http://www.liyi99.com/product/giftview11711.html', '20151117/564a9e7fada83.jpg', '<p>&nbsp; &nbsp; &nbsp; &nbsp; </p><p><strong>礼品情意</strong></p><p>似乎佩戴手链的男生，举手投足之间，都透着一种帅气和阳刚。这款黑曜石\n手链，除了辟邪保平安，强力化解负能量之外，还有纳财的说法，貔貅是一种瑞兽，帮主人招取钱财，咬住钱财只进不出，并能够赶走坏运气，带来欢乐与好运，平\n安健康和聚财，是很多女孩子选择这款礼物的主要原因。</p><h2><span style="font-size: 16px;">礼品属性</span></h2><ul class=" list-paddingleft-2"><li><p><span style="font-size: 16px;">\n 礼品尺寸：20cm，珠径约14mm</span></p></li><li><p><span style="font-size: 16px;">\n 包装尺寸：10cm*8cm*5cm</span></p></li><li><p><span style="font-size: 16px;">\n 礼品材质：黑曜石</span></p></li><li><p><span style="font-size: 16px;">\n 礼品颜色：黑色</span></p><p><span style="font-size: 16px;"><img alt="" class="scrollLoading" src="http://img.liyi99.com/UserFiles/Image/product/59/11%282%29.jpg" data-url="http://img.liyi99.com/UserFiles/Image/product/59/11(2).jpg" height="5119" width="750"/></span></p></li></ul>', '礼品情意似乎佩戴手链的男生，举手投足之间，都透着一种帅气和阳刚。这款黑曜石\n手链，除了辟邪保平安，强力化解负能量之外，还有纳财的说法，貔貅是一种瑞兽，帮主人招取钱财，咬住钱财只进不出，并能够赶走坏运气，带来欢乐与好运，平\n安', '男人', '生活', '文艺', '[家庭]', -0.5, -0.866025, '[80%，20%]', '7,9', -0.6, 0.8, '15-12-03 03:43:46', 'admin', 'liyi99', 6.40841, NULL, NULL),
(7, ' 蘑菇空气净化器创意台灯', '360°护眼台灯+净化器', '129.0-149.0', 2.11059, 1, 'http://www.liyi99.com/product/giftview13822.html', '20151117/564a9fa02be57.jpg', '<p><strong>礼品情意</strong></p><p>空气污染，雾霾，二手烟，统统去掉。净化空气，送的不仅是礼，更是健康和关</p><p><br/></p><h2><span style="font-size: 16px;">礼品属性</span></h2><p><span style="font-size: 16px;">礼品尺寸：17.7*21.1cm&nbsp;&nbsp; 包装尺寸：19cm*19cm*24cm&nbsp;&nbsp; 礼品材质：ABS+PS&nbsp;&nbsp; 礼品颜色：图片色 <br/></span></p><p><span style="font-size: 16px;"><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447731168810374.jpg" data-url="http://img.liyi99.com/accessorypic/70/1415168430211.jpg" style="width: 750px; height: 745px"/><br/></span></p><p><span style="font-size: 16px;"><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447731177108569.jpg" data-url="http://img.liyi99.com/accessorypic/70/1440830644010.jpg" style="width: 750px; height: 796px"/><br/></span></p><p><span style="font-size: 16px;"><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447731183121986.jpg" data-url="http://img.liyi99.com/accessorypic/70/1415170398467.jpg" style="width: 750px; height: 500px"/><br/></span></p><p><span style="font-size: 16px;"><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447731190282030.jpg" data-url="http://img.liyi99.com/accessorypic/70/1416382422519.jpg" style="width: 750px; height: 724px"/><br/></span></p><p><span style="font-size: 16px;"><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447731196646165.jpg" data-url="http://img.liyi99.com/accessorypic/70/1415168459656.jpg" style="width: 750px; height: 662px"/><br/></span></p><p><span style="font-size: 16px;"><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447731206588244.jpg" data-url="http://img.liyi99.com/accessorypic/70/1415168467205.jpg" style="width: 750px; height: 729px"/><br/></span></p><p><span style="font-size: 16px;"><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447731213984050.jpg" data-url="http://img.liyi99.com/accessorypic/70/1415168482420.jpg"/><br/></span></p><p><span style="font-size: 16px;"><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447731220726462.jpg" data-url="http://img.liyi99.com/accessorypic/70/1440830659478.jpg" style="width: 750px; height: 548px"/><br/></span></p><p><span style="font-size: 16px;"><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447731227603133.jpg" data-url="http://img.liyi99.com/accessorypic/70/1415168506743.jpg"/><br/></span></p><p><span style="font-size: 16px;"><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447731236123845.jpg" data-url="http://img.liyi99.com/accessorypic/70/1441879151076.jpg" style="width: 750px; height: 671px"/><br/></span></p><p><span style="font-size: 16px;"><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447731242139818.jpg" data-url="http://img.liyi99.com/accessorypic/70/1418089645969.jpg" style="width: 750px; height: 926px"/><br/></span></p><p><br/></p><p><br/></p>', '礼品情意空气污染，雾霾，二手烟，统统去掉。净化空气，送的不仅是礼，更是健康和关礼品属性礼品尺寸：17.7*21.1cm 包装尺寸：19cm*19cm*24cm 礼品材质：ABS+PS 礼品颜色：图片色', '孩子', '家庭', '生活', '[家庭、工作]', -1, 0, '[60%，40%]', '5,7', -0.2, 0.979796, '15-12-03 03:43:39', 'admin', 'liyi99', 5.35625, NULL, NULL),
(8, '鹅卵石外观空气净化器', '空气净化器-健康使者', '598.0-698.0', 2.7767, 1, 'http://www.liyi99.com/product/giftview13602.html', '20151117/564aa1ee3616b.jpg', '<p><strong>礼品情意</strong></p><p>适用于：新家装修用户、吸烟人群、有老人小孩家庭、呼吸道患者、花粉过敏者、办公室会议室</p><p><br/></p><h2><span style="font-size: 16px;">礼品属性</span></h2><p><br/></p><p><span style="font-size: 16px;">\n 礼品尺寸:21.5*15.6*11.5&nbsp;&nbsp;&nbsp; 包装尺寸：24cm*19cm*19cm&nbsp;&nbsp;&nbsp; 礼品颜色：黑+白色</span></p><p><span style="font-size: 16px;"><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447731744585963.jpg" data-url="http://img.liyi99.com/UserFiles/Image/product/69/eluanshi_01.jpg" height="1247" width="750"/><br/></span></p><p><br/></p><p><br/></p>', '礼品情意适用于：新家装修用户、吸烟人群、有老人小孩家庭、呼吸道患者、花粉过敏者、办公室会议室礼品属性\n 礼品尺寸:21.5*15.6*11.5 包装尺寸：24cm*19cm*19cm 礼品颜色：黑+白色', '健康', '家庭', '', '[娱乐、工作]', 0.5, 0.866025, '[30%，70%]', '2,4', 0.4, 0.916515, '15-12-03 03:43:29', 'admin', 'liyi99', 2.21253, NULL, NULL),
(10, '天然雨花石', '超密鹅卵石足底按摩垫穴位按摩脚垫天然雨花石足疗垫', '168.0-298.0', 2.22531, 0, 'http://www.liyi99.com/product/giftview13701.html', '20151117/564aa38a85d23.jpg', '<p><strong>礼品情意</strong></p><p>脚底按摩，针对足跟痛、脚麻、消化不良等病症</p><h2><span style="font-size: 16px;">礼品属性</span></h2><p><br/></p><p><span style="font-size: 16px;">\n 礼品尺寸:150cm*40cm&nbsp;&nbsp; 包装尺寸：150cm*40cm*1cm&nbsp;&nbsp; 礼品材质：鹅卵石</span></p><p><span style="font-size: 16px;">\n 礼品重量：7000.0g&nbsp;&nbsp; 发货地址：江苏</span></p><p><span style="font-size: 16px;"><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447732167862485.jpg" data-url="http://img.liyi99.com/accessorypic/69/1430387381709.jpg" style="width: 750px; height: 1149px"/><br/></span></p><p><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447732175895104.jpg" data-url="http://img.liyi99.com/accessorypic/69/1430384686433.jpg" style="width: 750px; height: 568px"/><br/></p><p><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447732186457427.jpg" data-url="http://img.liyi99.com/accessorypic/69/1430384697543.jpg" style="width: 750px; height: 947px"/><br/></p><p><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447732192710411.jpg" data-url="http://img.liyi99.com/accessorypic/69/1430384706478.jpg" style="width: 750px; height: 961px"/><br/></p><p><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447732202658343.jpg" data-url="http://img.liyi99.com/accessorypic/69/1430384715953.jpg" style="width: 750px; height: 1304px"/><br/></p><p><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447732212113986.jpg" data-url="http://img.liyi99.com/accessorypic/69/1430384725089.jpg" style="width: 750px; height: 1333px"/><br/></p><p><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447732218893641.jpg" data-url="http://img.liyi99.com/accessorypic/69/1430384734817.jpg" style="width: 750px; height: 1043px"/><br/></p><p><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447732225243129.jpg" data-url="http://img.liyi99.com/accessorypic/69/1430384734817.jpg" style="width: 750px; height: 1043px"/><br/></p><p><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447732229106008.jpg" data-url="http://img.liyi99.com/accessorypic/69/1430384743793.jpg" style="width: 750px; height: 958px"/><br/></p><p><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447732234139810.jpg" data-url="http://img.liyi99.com/accessorypic/69/1430384743793.jpg" style="width: 750px; height: 958px"/><br/></p><p><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447732240761103.jpg" data-url="http://img.liyi99.com/accessorypic/69/1430384753197.jpg" style="width: 750px; height: 1402px"/><br/></p><p><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447732252737263.jpg" data-url="http://img.liyi99.com/accessorypic/69/1430384770902.jpg" style="width: 750px; height: 1356px"/><br/></p><p><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447732264305138.jpg" data-url="http://img.liyi99.com/accessorypic/69/1430384804055.jpg" style="width: 750px; height: 1047px"/><br/></p><p><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447732272362542.jpg" data-url="http://img.liyi99.com/accessorypic/69/1430384812678.jpg" style="width: 750px; height: 743px"/></p>', '礼品情意脚底按摩，针对足跟痛、脚麻、消化不良等病症礼品属性\n 礼品尺寸:150cm*40cm 包装尺寸：150cm*40cm*1cm 礼品材质：鹅卵石\n 礼品重量：7000.0g 发货地址：江苏', '运动', '健康', '家庭', '[家庭]', -0.5, -0.866025, '[80%，20%]', '7,9', -0.6, 0.8, '15-12-03 03:43:19', 'admin', 'liyi99', 6.42342, NULL, NULL),
(11, '胡巴，一起玩耍', '旋转发光胡巴音乐水晶摆件', '99.0-219.0', 1.99564, 1, 'http://www.liyi99.com/product/giftview14042.html', '20151117/564aa5b3317f5.jpg', '<p>&nbsp; &nbsp; &nbsp; &nbsp; </p><p><strong>礼品情意</strong></p><p>胡巴是电影捉妖记的萌神，简直就要萌化了我们的心，此款水晶运用3D内雕技术，还原了捉妖记的胡巴，萌萌哒，很可爱哦。还能替你陪伴你的爱人，让她们一起玩耍，赶紧送她一个吧。</p><h2><span style="font-size: 16px;">礼品属性</span></h2><p><br/></p><p><span style="font-size: 16px;">\n 礼品尺寸:8*5*5cm&nbsp;&nbsp; 礼品颜色：图片色&nbsp;&nbsp; 礼品材质：k9水晶&nbsp; 塑料烤漆&nbsp;&nbsp; 温馨提示：电池我们不配送，请自行购买</span></p><p><span style="font-size: 16px;"><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447732710884174.jpg" data-url="http://img.liyi99.com/accessorypic/71/1438306948025.jpg" style="width: 790px; height: 503px"/><br/></span></p><p><span style="font-size: 16px;"><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447732716880989.jpg" data-url="http://img.liyi99.com/accessorypic/71/1440725738558.jpg" style="width: 790px; height: 532px"/><br/></span></p><p><span style="font-size: 16px;"><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447732722502568.jpg" data-url="http://img.liyi99.com/accessorypic/71/1440726023593.jpg" style="width: 790px; height: 502px"/><br/></span></p><p><span style="font-size: 16px;"><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447732728126362.jpg" data-url="http://img.liyi99.com/accessorypic/71/1438306989879.jpg" style="width: 790px; height: 512px"/><br/></span></p><p><span style="font-size: 16px;"><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447732735521114.jpg" data-url="http://img.liyi99.com/accessorypic/71/1440725906588.jpg" style="width: 790px; height: 778px"/><br/></span></p><p><span style="font-size: 16px;"><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447732742571892.jpg" data-url="http://img.liyi99.com/accessorypic/71/1440725771149.jpg" style="width: 790px; height: 778px"/><br/></span></p><p><span style="font-size: 16px;"><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447732748546288.jpg" data-url="http://img.liyi99.com/accessorypic/71/1438307014189.jpg" style="width: 790px; height: 629px"/><br/></span></p><p><span style="font-size: 16px;"><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447732754742771.jpg" data-url="http://img.liyi99.com/accessorypic/71/1438307022498.jpg" style="width: 790px; height: 552px"/><br/></span></p><p><span style="font-size: 16px;"><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447732760883485.jpg" data-url="http://img.liyi99.com/accessorypic/71/1438307032079.jpg" style="width: 790px; height: 914px"/><br/></span></p><p><span style="font-size: 16px;"><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447732768456179.jpg" data-url="http://img.liyi99.com/accessorypic/71/1438307039552.jpg" style="width: 790px; height: 652px"/><br/></span></p><p><span style="font-size: 16px;"><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447732779667121.jpg" data-url="http://img.liyi99.com/accessorypic/71/1438307108993.jpg" style="width: 790px; height: 779px"/><br/></span></p><p><span style="font-size: 16px;"><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447732788126844.jpg" data-url="http://img.liyi99.com/accessorypic/71/1438307146933.jpg" style="width: 790px; height: 325px"/><br/></span></p><p><span style="font-size: 16px;"><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447732796205648.jpg" data-url="http://img.liyi99.com/accessorypic/71/1438307183068.jpg" style="width: 790px; height: 964px"/><br/></span></p><p><span style="font-size: 16px;"><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447732808315379.jpg" data-url="http://img.liyi99.com/accessorypic/36/1439364921236.jpg"/><br/></span></p><p><span style="font-size: 16px;"><img alt="" class="scrollLoading" src="/ueditor/php/upload/image/20151117/1447732816512551.jpg" data-url="http://img.liyi99.com/accessorypic/71/1438307224512.jpg" style="width: 790px; height: 744px"/><br/></span></p><p><br/></p>', '礼品情意胡巴是电影捉妖记的萌神，简直就要萌化了我们的心，此款水晶运用3D内雕技术，还原了捉妖记的胡巴，萌萌哒，很可爱哦。还能替你陪伴你的爱人，让她们一起玩耍，赶紧送她一个吧。礼品属性\n 礼品尺寸:8*5*5cm 礼', '游戏', '运动', '文艺', '[家庭、工作]', -1, 0, '[80%，20%]', '7,9', -0.6, 0.8, '15-12-03 03:43:10', 'admin', 'liyi99', 5.50159, NULL, NULL),
(12, 'Thomas＆Friends/托马斯', '多多岛百变轨道套装CGW29 儿童玩具礼物', '275.0', 2.43933, 1, 'https://detail.tmall.com/item.htm?id=43817945056&ali_refid=a3_430571_1006:1106551017:N:%E7%A4%BC%E5%93%81:d3f05fe6b0c6066a87cfee05dc8a7895&ali_trackid=1_d3f05fe6b0c6066a87cfee05dc8a7895&sp', '20151117/564acc068a687.jpg', '<p class="attr-list-hd tm-clear"><strong><em>产品参数：</em></strong></p><p><br/></p><p>产品名称：Thomas＆Friends/托马斯&nbsp;&nbsp; 品牌:&nbsp;Thomas＆Friends/托马斯＆朋友&nbsp;&nbsp; 型号:&nbsp;CGW29</p><p>是否含遥控:&nbsp;不含&nbsp;&nbsp; 儿童玩具价格:&nbsp;301-500&nbsp;&nbsp; 是否有导购视频:&nbsp;无&nbsp;&nbsp; 货号:&nbsp;CGW29&nbsp;&nbsp; 适用年龄:&nbsp;3岁</p><p><img src="/ueditor/php/upload/image/20151117/1447742539707872.jpg" align="absmiddle"/><br/></p><p><img src="/ueditor/php/upload/image/20151117/1447742562336594.jpg" align="absmiddle"/><img src="/ueditor/php/upload/image/20151117/1447742550413793.jpg" align="absmiddle"/></p><p><img src="/ueditor/php/upload/image/20151117/1447742581118251.jpg" align="absmiddle"/></p>', '产品参数：产品名称：Thomas＆Friends/托马斯 品牌: Thomas＆Friends/托马斯＆朋友 型号: CGW29是否含遥控: 不含 儿童玩具价格: 301-500 是否有导购视频: 无 货号: CGW29', '游戏', '孩子', '运动', '[娱乐、家庭]', 0.5, -0.866025, '[40%，60%]', '3,5', 0.2, 0.979796, '15-12-03 03:43:01', 'admin', '淘宝', 5.10075, NULL, NULL),
(13, '人体红外感应 光控节能', '幸运四叶草人体感应夜灯创意家居生活用品百货日用品新奇特小礼品', '48.00', 1.68124, 1, 'https://detail.tmall.com/item.htm?id=520675892569&ali_refid=a3_430571_1006:1110484654:N:%E5%B0%8F%E7%A4%BC%E5%93%81%20%E5%88%9B%E6%84%8F%20%E6%89%B9%E5%8F%91:3287092f232f886a8f723d69c9b2d2a5&a', '20151117/564ace31b5511.jpg', '<p class="attr-list-hd tm-clear"><em>产品参数：</em></p><p><br/></p><p>品牌:&nbsp;初窦&nbsp;&nbsp; 货号:&nbsp;YF033&nbsp;&nbsp; 颜色分类:&nbsp;黄光（充电款）&nbsp;白光（充电款）&nbsp;&nbsp; 商品类型:&nbsp;居家</p><p><img src="/ueditor/php/upload/image/20151117/1447743071888563.jpg" align="absmiddle"/></p><p><br/></p>', '产品参数：品牌: 初窦 货号: YF033 颜色分类: 黄光（充电款） 白光（充电款） 商品类型: 居家', '创意', '家庭', '文艺', '[娱乐、家庭]', 0.5, -0.866025, '[50%，50%]', '4,6', 0, 0, '15-12-03 03:39:25', 'admin', '淘宝', 4.02518, NULL, NULL);
INSERT INTO `fg_goods` (`id`, `brand`, `goodsname`, `price`, `price_E`, `post`, `link`, `imagename`, `content`, `description`, `type1`, `type2`, `type3`, `application`, `application_EX`, `application_EY`, `art_tech`, `art_tech_nearby`, `art_tech_EX`, `art_tech_EY`, `createtime`, `createman`, `seller`, `composite`, `a3`, `a4`) VALUES
(14, 'STAND BY ME 哆啦A梦', '送女生全套哆啦a梦公仔手办摆件器猫小叮当玩具礼物送男生送闺蜜', '99.20', 1.99651, 0, 'http://item.taobao.com/item.htm?id=520466735959&ali_trackid=2:mm_29071549_10284462_34236748:1447753834_256_250119975&spm=0.0.0.0.0_a231o.7705542.10010.1&pvid=200_10.176.141.97_58129_144775', '20151117/564af97fed139.jpg', '<p>ACG作品名:&nbsp;哆啦A梦/机器猫&nbsp;&nbsp; ACG角色名:&nbsp;哆啦A梦&nbsp;&nbsp; 作品地区:&nbsp;日本&nbsp;&nbsp; 作品来源:&nbsp;动漫</p><p>出售状态:&nbsp;现货&nbsp;&nbsp; 品牌:&nbsp;机器猫&nbsp;&nbsp; 大小:&nbsp;选择您要的款式&nbsp;&nbsp; 材质:&nbsp;搪胶&nbsp;&nbsp; 款式:&nbsp;静态</p><p>适用年龄:&nbsp;8周岁以上&nbsp;&nbsp; 颜色分类:&nbsp;捧烧饼（最新款） 臭美</p><p><img src="/ueditor/php/upload/image/20151117/1447754203530323.jpg" class="" align="absmiddle"/></p><p><img src="/ueditor/php/upload/image/20151117/1447754212137985.jpg" class=""/><br/></p><p><img src="/ueditor/php/upload/image/20151117/1447754219468874.jpg" class=""/><br/></p><p><img src="/ueditor/php/upload/image/20151117/1447754226479804.jpg" class=""/><br/></p><p><img src="/ueditor/php/upload/image/20151117/1447754232105462.jpg" class="" align="absMiddle"/><br/></p><p><img src="/ueditor/php/upload/image/20151117/1447754239126246.jpg" class="" align="absMiddle"/><br/></p><p><img src="/ueditor/php/upload/image/20151117/1447754246657181.jpg" class="" align="absMiddle"/><br/></p><p><img src="/ueditor/php/upload/image/20151117/1447754252334873.jpg" class="" align="absMiddle"/></p><p><img src="/ueditor/php/upload/image/20151117/1447754262117132.jpg" class="" align="absMiddle"/></p><p><img src="/ueditor/php/upload/image/20151117/1447754272649349.jpg" class="" align="absMiddle"/></p><p><img src="/ueditor/php/upload/image/20151117/1447754279966665.jpg" class="" align="absMiddle"/><br/></p><p><img src="/ueditor/php/upload/image/20151117/1447754286222990.jpg" class="" align="absMiddle"/><br/></p><p><img src="/ueditor/php/upload/image/20151117/1447754291527913.jpg" class="" align="absMiddle" height="470" width="750"/><br/></p><p><img src="/ueditor/php/upload/image/20151117/1447754298598055.jpg" class="" align="absMiddle" height="522" width="750"/><br/></p><p><img src="/ueditor/php/upload/image/20151117/1447754305104481.jpg" class="" align="absMiddle" height="387" width="750"/><br/></p><p><img src="/ueditor/php/upload/image/20151117/1447754314120170.jpg" class="" align="absMiddle" height="563" width="750"/><br/></p><p><img src="/ueditor/php/upload/image/20151117/1447754321181938.jpg" class="" align="absMiddle" height="623" width="750"/><br/></p><p><img src="/ueditor/php/upload/image/20151117/1447754327756068.jpg" class="" align="absMiddle" height="735" width="735"/><br/></p><p><img src="/ueditor/php/upload/image/20151117/1447754334539102.jpg" class="" align="absMiddle" height="785" width="750"/><br/></p><p><img src="/ueditor/php/upload/image/20151117/1447754340983706.jpg"/></p><p><br/></p>', 'ACG作品名: 哆啦A梦/机器猫 ACG角色名: 哆啦A梦 作品地区: 日本 作品来源: 动漫出售状态: 现货 品牌: 机器猫 大小: 选择您要的款式 材质: 搪胶 款式: 静态适用年龄: 8周岁以上 颜色分', '创意', '孩子', '家庭', '[娱乐]', 1, 0, '[10%，90%]', '0,2', 0.8, 0.6, '15-12-12 11:45:47', 'admin', '淘宝', 2.82349, NULL, NULL),
(15, 'MODERN', '德国Modern新品216位磁力魔方益智新奇玩具5MM办公减压球创意礼品', '155.0', 2.19033, 0, 'https://item.taobao.com/item.htm?id=41816286433&ali_refid=a3_420630_1006:1103775723:N:%E7%A4%BC%E5%93%81:4c01ffba1322ab2336185ec4640529c6&ali_trackid=1_4c01ffba1322ab2336185ec4640529c6&spm', '20151117/564aff7aa56f0.jpg', '<p>品牌:&nbsp;MODERN&nbsp;&nbsp; 颜色分类:&nbsp;方形魔方 圆形魔方&nbsp;&nbsp; 是否进口:&nbsp;进口</p><p>大小描述:&nbsp;包邮&nbsp;&nbsp; 玩具类型:&nbsp;疗伤&nbsp;&nbsp; 适用年龄:&nbsp;6岁 7岁 8岁 9岁 10岁 11</p><p style="color: #000000;"><span style="color: #444444;"><span style="font-size: large;line-height: 27.0px;">MODERN磁性球魔方其中一个大的作用是可以令你释放压力。</span><span style="font-size: large;line-height: 27.0px;">当你玩</span><span style="font-size: large;line-height: 27.0px;">磁性球魔方</span><span style="font-size: large;line-height: 27.0px;">时，你不仅要运用到空间想像能力以及创造力，还会运用到你的逻辑思维能力甚至是数学方面的知识,同时你还需要动手去做。这就使你的左右脑同时得到了锻炼.</span></span></p><p style="margin-top: 0.0px;margin-bottom: 0.0px;color: #000000;line-height: 18.0px;font-size: 12.0px;"><span style="font-size: 18.0px;">【名 称】：益智魔方</span></p><p style="margin-top: 0.0px;margin-bottom: 0.0px;line-height: 18.0px;color: #404040;font-size: 12.0px;"><span style="font-size: 18.0px;"><span style="color: #000000;">【品 牌】：Modern</span></span></p><p style="margin-top: 0.0px;margin-bottom: 0.0px;line-height: 18.0px;color: #404040;font-size: 12.0px;"><span style="font-size: 18.0px;"><span style="color: #000000;">【编 号】：MYC86/GNB</span></span></p><p style="margin-top: 0.0px;margin-bottom: 0.0px;line-height: 18.0px;color: #404040;font-size: 12.0px;"><span style="font-size: 18.0px;"><span style="color: #000000;">【规 格】：单颗直径5MM，共216颗</span></span></p><p style="margin-top: 0.0px;margin-bottom: 0.0px;line-height: 18.0px;color: #404040;font-size: 12.0px;"><span style="font-size: 18.0px;"><span style="color: #000000;">【重 量】：150克</span></span></p><p style="margin-top: 0.0px;margin-bottom: 0.0px;line-height: 18.0px;color: #404040;font-size: 12.0px;"><span style="font-size: 18.0px;"><span style="color: #000000;"><span style="font-family:tahoma helvetica arial 宋体 sans-serif">【材 质】：</span><span style="font-family:Verdana">超强磁</span></span></span></p><p style="margin-top: 0.0px;margin-bottom: 0.0px;line-height: 18.0px;color: #404040;font-size: 12.0px;"><span style="font-size: 18.0px;"><span style="color: #000000;">【包 装】：原厂包装（付带小册子一份）</span></span></p><p style="margin-top: 0.0px;margin-bottom: 0.0px;line-height: 18.0px;color: #404040;font-size: 12.0px;"><span style="font-size: 18.0px;"><span style="color: #000000;">【功 能】：益智开发大脑，办公减压</span></span></p><p><img src="/ueditor/php/upload/image/20151117/1447755696126573.jpg" class="" align="absmiddle"/></p><p><img src="/ueditor/php/upload/image/20151117/1447755705207413.jpg" class="" align="absmiddle"/></p><p><img src="/ueditor/php/upload/image/20151117/1447755715963309.jpg" class="" align="absmiddle"/><img src="/ueditor/php/upload/image/20151117/1447755723908831.jpg" class="" align="absmiddle"/><img src="/ueditor/php/upload/image/20151117/1447755730133011.jpg" class="" align="absmiddle"/><img src="/ueditor/php/upload/image/20151117/1447755739115032.jpg" class="" align="absmiddle"/></p>', '品牌: MODERN 颜色分类: 方形魔方 圆形魔方 是否进口: 进口大小描述: 包邮 玩具类型: 疗伤 适用年龄: 6岁 7岁 8岁 9岁 10岁 11MODERN磁性球魔方其中一个大的作用是可以令你释放压力。当你玩磁性球', '创意', '游戏', '运动', '[娱乐]', 1, 0, '[90%，10%]', '8,A', -0.8, 0.6, '15-12-12 11:45:16', 'admin', '淘宝', 3.0976, NULL, NULL);
-- --------------------------------------------------------
--
-- 表的结构 `fg_link`
--
CREATE TABLE `fg_link` (
`id` int(11) NOT NULL,
`linkname` varchar(50) COLLATE utf8_bin NOT NULL,
`rank` varchar(50) COLLATE utf8_bin NOT NULL,
`address` varchar(200) COLLATE utf8_bin NOT NULL,
`a1` varchar(50) COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
--
-- 转存表中的数据 `fg_link`
--
INSERT INTO `fg_link` (`id`, `linkname`, `rank`, `address`, `a1`) VALUES
(1, '可可礼物网', '1', 'http://www.cocodiy.com/', ''),
(2, '卡当', '2', 'http://www.kadang.com/', ''),
(3, '鲜花网', '3', 'http://www.hua.com/', ''),
(4, '礼无忧网', '4', 'http://www.liwuyou.com/', ''),
(5, '麦琪礼品', '5', 'http://www.magift.com.cn/', ''),
(6, '京东礼品', '6', 'http://re.jd.com/search?keyword=%E7%A4%BC%E5%93%81%E5%BA%97', ''),
(7, '左岸童话', '7', 'http://www.leftdays.com/', ''),
(8, '礼意久久', '8', 'http://www.liyi99.com/', ''),
(9, 'U尚社', '9', 'http://www.ushsh.com/', ''),
(10, '遨礼礼品网', '10', 'http://www.aoligift.com/', ''),
(11, '汽车礼品网', '11', 'http://www.cargift.cn/', ''),
(12, '淘宝', '12', 'https://www.taobao.com/', ''),
(13, '天猫', '13', 'https://www.tmall.com/', '');
-- --------------------------------------------------------
--
-- 表的结构 `fg_seller`
--
CREATE TABLE `fg_seller` (
`id` int(11) NOT NULL,
`category` varchar(50) COLLATE utf8_bin NOT NULL,
`rank` varchar(50) COLLATE utf8_bin DEFAULT NULL,
`a1` varchar(50) COLLATE utf8_bin DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
--
-- 转存表中的数据 `fg_seller`
--
INSERT INTO `fg_seller` (`id`, `category`, `rank`, `a1`) VALUES
(1, '淘宝', '1', NULL),
(2, '京东', '2', NULL),
(4, '亚马逊', '3', NULL),
(5, 'liyi99', '4', NULL);
-- --------------------------------------------------------
--
-- 表的结构 `fg_test`
--
CREATE TABLE `fg_test` (
`id` int(11) NOT NULL,
`test` float NOT NULL,
`a1` double NOT NULL,
`a2` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
--
-- 转存表中的数据 `fg_test`
--
INSERT INTO `fg_test` (`id`, `test`, `a1`, `a2`) VALUES
(1, 1, 2, 3),
(2, -1, 3, 4);
-- --------------------------------------------------------
--
-- 表的结构 `fg_type`
--
CREATE TABLE `fg_type` (
`id` int(11) NOT NULL,
`type` varchar(50) COLLATE utf8_bin NOT NULL,
`rank` varchar(50) COLLATE utf8_bin DEFAULT NULL,
`filter` varchar(50) COLLATE utf8_bin DEFAULT NULL,
`a1` varchar(50) COLLATE utf8_bin DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
--
-- 转存表中的数据 `fg_type`
--
INSERT INTO `fg_type` (`id`, `type`, `rank`, `filter`, `a1`) VALUES
(1, '男人', '1', 'man', NULL),
(2, '女人', '2', 'woman', NULL),
(3, '数码', '3', 'digital', NULL),
(4, '健康', '4', 'health', NULL),
(5, '生活', '5', 'life', NULL),
(6, '游戏', '6', 'game', NULL),
(7, '文艺', '7', 'art', NULL),
(8, '运动', '8', 'sport', NULL),
(9, '爱情', '9', 'love', NULL),
(10, '家庭', '10', 'family', NULL),
(11, '孩子', '11', 'children', NULL),
(12, '创意', '12', 'idea', NULL);
-- --------------------------------------------------------
--
-- 表的结构 `fg_user`
--
CREATE TABLE `fg_user` (
`id` int(11) NOT NULL,
`username` varchar(50) COLLATE utf8_bin NOT NULL,
`password` varchar(50) COLLATE utf8_bin NOT NULL,
`type` varchar(50) COLLATE utf8_bin DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
--
-- 转存表中的数据 `fg_user`
--
INSERT INTO `fg_user` (`id`, `username`, `password`, `type`) VALUES
(2, 'admin', 'c4ca4238a0b923820dcc509a6f75849b', '系统管理员'),
(3, '荆心', 'c4ca4238a0b923820dcc509a6f75849b', '普通操作员'),
(5, 'user', 'c4ca4238a0b923820dcc509a6f75849b', '普通操作员'),
(6, 'jiachao', 'c4ca4238a0b923820dcc509a6f75849b', '系统管理员');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `fg_goods`
--
ALTER TABLE `fg_goods`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `fg_link`
--
ALTER TABLE `fg_link`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `fg_seller`
--
ALTER TABLE `fg_seller`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `fg_test`
--
ALTER TABLE `fg_test`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `fg_type`
--
ALTER TABLE `fg_type`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `fg_user`
--
ALTER TABLE `fg_user`
ADD PRIMARY KEY (`id`);
--
-- 在导出的表使用AUTO_INCREMENT
--
--
-- 使用表AUTO_INCREMENT `fg_goods`
--
ALTER TABLE `fg_goods`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
-- 使用表AUTO_INCREMENT `fg_link`
--
ALTER TABLE `fg_link`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
--
-- 使用表AUTO_INCREMENT `fg_seller`
--
ALTER TABLE `fg_seller`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- 使用表AUTO_INCREMENT `fg_test`
--
ALTER TABLE `fg_test`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- 使用表AUTO_INCREMENT `fg_type`
--
ALTER TABLE `fg_type`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- 使用表AUTO_INCREMENT `fg_user`
--
ALTER TABLE `fg_user`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;