zh_cn.sql

本次新版本发布是在ECshop与ShopEx整合后的首次产品升级

(12, '手机耳机', '', '', 10, 0, '', '', 0, '', 1, 5, 0),
(13, '手机充电器', '', '', 10, 4, '', '', 0, '', 1, 0, 0);

--
-- `ecs_goods`
--

INSERT INTO `ecs_goods`
(`goods_id`, `cat_id`, `goods_sn`, `goods_name`, `goods_name_style`, `click_count`, `brand_id`, `provider_name`, `goods_number`, `goods_weight`, `market_price`, `shop_price`, `promote_price`, `promote_start_date`, `promote_end_date`, `warn_number`, `keywords`, `goods_brief`, `goods_desc`, `goods_thumb`, `goods_img`, `original_img`, `is_real`, `extension_code`, `is_on_sale`, `is_alone_sale`, `integral`, `add_time`, `sort_order`, `is_delete`, `is_best`, `is_new`, `is_hot`, `is_promote`, `bonus_type_id`, `last_update`, `goods_type`, `seller_note`, `give_integral`, `rank_integral`) VALUES
(3, 7, 'ECS000003', '移动10元充值卡', '+', 12, 0, '', 1, 0.000, 10.79, 9.00, 0.00, 0, 0, 1, '', '', '<p><span style="font-size: xx-large"><strong>使用在线支付可以自动发货</strong></span></p>', 'images/200810/thumb_img/3_thumb_G_1225048690981.jpg', 'images/200810/goods_img/3_G_1225048690596.jpg', 'images/200810/source_img/3_G_1225048690954.jpg', 0, 'virtual_card', 1, 1, 9, 1224899223, 0, 0, 1, 1, 1, 0, 0, 1225072778, 1, '', -1, -1),
(30, 2, 'ECS000030', '恒基伟业G101', '+', 16, 11, '', 10, 0.000, 1185.60, 988.00, 0.00, 0, 0, 1, '2008年06月 GSM,900,1800,1900,2100 直板 1600万 240×320 像素 黑色', '', '<p>\r\n<table cellspacing="0" cellpadding="0" bordercolor="#cccccc" border="1" bgcolor="#ffffff" align="center" width="95%" bordercolorlight="#cccccc" bordercolordark="#ffffff">\r\n    <tbody>\r\n        <tr>\r\n            <td height="20" width="50%">\r\n            <table cellspacing="2" cellpadding="0" width="100%" class="title_txt_66">\r\n                <tbody>\r\n                    <tr>\r\n                        <td height="20" bgcolor="#f7f7f7" width="36%">\r\n                        <div align="center"><b>天线位置</b></div>\r\n                        </td>\r\n                        <td height="20" bgcolor="#ffffff" width="64%">内置&nbsp;</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td height="20" width="50%">\r\n            <table cellspacing="2" cellpadding="0" width="100%" class="title_txt_66">\r\n                <tbody>\r\n                    <tr>\r\n                        <td height="20" bgcolor="#f7f7f7" width="36%">\r\n                        <div align="center"><b>主屏幕</b></div>\r\n                        </td>\r\n                        <td height="20" bgcolor="#ffffff" width="64%">65536色TFT显示屏,分辨率为240&times;320&nbsp;2.8英寸显示屏</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td height="20" width="50%">\r\n            <table cellspacing="2" cellpadding="0" width="100%" class="title_txt_66">\r\n                <tbody>\r\n                    <tr>\r\n                        <td height="20" bgcolor="#f7f7f7" width="36%">\r\n                        <div align="center"><b>副屏幕</b></div>\r\n                        </td>\r\n                        <td height="20" bgcolor="#ffffff" width="64%">不支持&nbsp;</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td height="20" width="50%">\r\n            <table cellspacing="2" cellpadding="0" width="100%" class="title_txt_66">\r\n                <tbody>\r\n                    <tr>\r\n                        <td height="20" bgcolor="#f7f7f7" width="36%">\r\n                        <div align="center"><b>通话记录</b></div>\r\n                        </td>\r\n                        <td height="20" bgcolor="#ffffff" width="64%">20条已接＋20条未接＋20条已拨&nbsp;</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td height="20" width="50%">\r\n            <table cellspacing="2" cellpadding="0" width="100%" class="title_txt_66">\r\n                <tbody>\r\n                    <tr>\r\n                        <td height="20" bgcolor="#f7f7f7" width="36%">\r\n                        <div align="center"><b>和弦铃声</b></div>\r\n                        </td>\r\n                        <td height="20" bgcolor="#ffffff" width="64%">64和弦&nbsp;</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td height="20" width="50%">\r\n            <table cellspacing="2" cellpadding="0" width="100%" class="title_txt_66">\r\n                <tbody>\r\n                    <tr>\r\n                        <td height="20" bgcolor="#f7f7f7" width="36%">\r\n                        <div align="center"><b>铃声格式</b></div>\r\n                        </td>\r\n                        <td height="20" bgcolor="#ffffff" width="64%">MIDI,MP3&nbsp;</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td height="20" width="50%">\r\n            <table cellspacing="2" cellpadding="0" width="100%" class="title_txt_66">\r\n                <tbody>\r\n                    <tr>\r\n                        <td height="20" bgcolor="#f7f7f7" width="36%">\r\n                        <div align="center"><b>铃声下载</b></div>\r\n                        </td>\r\n                        <td height="20" bgcolor="#ffffff" width="64%">支持&nbsp; &nbsp;<a href="http://www.imobile.com.cn/wapdiyringlist2005.php?wpid=1" class="title_txt_pi">MID（MIDI格式）</a> &nbsp;<a href="http://www.imobile.com.cn/wapdiyringlist2005.php?wpid=9" class="title_txt_pi">MP3（MP3格式）</a></td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td height="20" width="50%">\r\n            <table cellspacing="2" cellpadding="0" width="100%" class="title_txt_66">\r\n                <tbody>\r\n                    <tr>\r\n                        <td height="20" bgcolor="#f7f7f7" width="36%">\r\n                        <div align="center"><b>图片下载</b></div>\r\n                        </td>\r\n                        <td height="20" bgcolor="#ffffff" width="64%">支持&nbsp; &nbsp;<a href="http://www.imobile.com.cn/wapdiylogolist2005.php?wpid=1237" class="title_txt_pi">240&times;320</a></td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td height="20" width="50%">\r\n            <table cellspacing="2" cellpadding="0" width="100%" class="title_txt_66">\r\n                <tbody>\r\n                    <tr>\r\n                        <td height="20" bgcolor="#f7f7f7" width="36%">\r\n                        <div align="center"><b>图形菜单</b></div>\r\n                        </td>\r\n                        <td height="20" bgcolor="#ffffff" width="64%">支持&nbsp;</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td height="20" width="50%">\r\n            <table cellspacing="2" cellpadding="0" width="100%" class="title_txt_66">\r\n                <tbody>\r\n                    <tr>\r\n                        <td height="20" bgcolor="#f7f7f7" width="36%">\r\n                        <div align="center"><b>STK 服务</b></div>\r\n                        </td>\r\n                        <td height="20" bgcolor="#ffffff" width="64%">支持&nbsp;</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td height="20" width="50%">\r\n            <table cellspacing="2" cellpadding="0" width="100%" class="title_txt_66">\r\n                <tbody>\r\n                    <tr>\r\n                        <td height="20" bgcolor="#f7f7f7" width="36%">\r\n                        <div align="center"><b>EFR 服务</b></div>\r\n                        </td>\r\n                        <td height="20" bgcolor="#ffffff" width="64%">支持&nbsp;</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td height="20" width="50%">\r\n            <table cellspacing="2" cellpadding="0" width="100%" class="title_txt_66">\r\n                <tbody>\r\n                    <tr>\r\n                        <td height="20" bgcolor="#f7f7f7" width="36%">\r\n                        <div align="center"><b>免提通话</b></div>\r\n                        </td>\r\n                        <td height="20" bgcolor="#ffffff" width="64%">支持&nbsp;</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td height="20" width="50%">\r\n            <table cellspacing="2" cellpadding="0" width="100%" class="title_txt_66">\r\n                <tbody>\r\n                    <tr>\r\n                        <td height="20" bgcolor="#f7f7f7" width="36%">\r\n                        <div align="center"><b>振动</b></div>\r\n                        </td>\r\n                        <td height="20" bgcolor="#ffffff" width="64%">支持&nbsp;</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td height="20" width="50%">\r\n            <table cellspacing="2" cellpadding="0" width="100%" class="title_txt_66">\r\n                <tbody>\r\n                    <tr>\r\n                        <td height="20" bgcolor="#f7f7f7" width="36%">\r\n                        <div align="center"><b>记事录音</b></div>\r\n                        </td>\r\n                        <td height="20" bgcolor="#ffffff" width="64%">支持&nbsp;</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td height="20" width="50%">\r\n            <table cellspacing="2" cellpadding="0" width="100%" class="title_txt_66">\r\n                <tbody>\r\n                    <tr>\r\n                        <td height="20" bgcolor="#f7f7f7" width="36%">\r\n                        <div align="center"><b>通话时间提示</b></div>\r\n                        </td>\r\n                        <td height="20" bgcolor="#ffffff" width="64%">支持&nbsp;</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td height="20" width="50%">\r\n            <table cellspacing="2" cellpadding="0" width="100%" class="title_txt_66">\r\n                <tbody>\r\n                    <tr>\r\n                        <td height="20" bgcolor="#f7f7f7" width="36%">\r\n                        <div align="center"><b>话机电话薄（条）</b></div>\r\n                        </td>\r\n                        <td height="20" bgcolor="#ffffff" width="64%">300&nbsp;</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td height="20" width="50%">\r\n            <table cellspacing="2" cellpadding="0" width="100%" class="title_txt_66">\r\n                <tbody>\r\n                    <tr>\r\n                        <td height="20" bgcolor="#f7f7f7" width="36%">\r\n                        <div align="center"><b>中文输入法</b></div>\r\n                        </td>\r\n                        <td height="20" bgcolor="#ffffff" width="64%">支持&nbsp;</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td height="20" width="50%">\r\n            <table cellspacing="2" cellpadding="0" width="100%" class="title_txt_66">\r\n                <tbody>\r\n                    <tr>\r\n                        <td height="20" bgcolor="#f7f7f7" width="36%">\r\n                        <div align="center"><b>中文短消息</b></div>\r\n                        </td>\r\n                        <td height="20" bgcolor="#ffffff" width="64%">SMS,EMS,MMS,超长信息发送,短消息群发&nbsp;</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td height="20" width="50%">\r\n            <table cellspacing="2" cellpadding="0" width="100%" class="title_txt_66">\r\n                <tbody>\r\n                    <tr>\r\n                        <td height="20" bgcolor="#f7f7f7" width="36%">\r\n                        <div align="center"><b>情景模式</b></div>\r\n                        </td>\r\n                        <td height="20" bgcolor="#ffffff" width="64%">支持&nbsp;</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n        <tr>\r\n            <td height="20" width="50%">\r\n            <table cellspacing="2" cellpadding="0" width="100%" class="title_txt_66">\r\n                <tbody>\r\n                    <tr>\r\n                        <td height="20" bgcolor="#f7f7f7" width="36%">\r\n                        <div align="center"><b>外观样式</b></div>\r\n                        </td>\r\n                        <td height="20" bgcolor="#ffffff" width="64%">直板&nbsp;</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>\r\n            </td>\r\n        </tr>\r\n    </tbody>\r\n</table>\r\n</p>', 'images/200810/thumb_img/30_thumb_G_1225055875528.jpg', 'images/200810/goods_img/30_G_1225055875992.jpg', 'images/200810/source_img/30_G_1225055875506.gif', 1, '', 1, 1, 988, 1225055875, 0, 0, 1, 1, 1, 0, 0, 1225072694, 9, '', -1, -1),
(15, 7, 'ECS000015', '移动20元充值卡', '+', 1, 0, '', 3, 0.000, 22.20, 18.50, 0.00, 0, 0, 1, '', '', '<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p><strong><font face="黑体" color="#ff0000" size="4">特别提示:因为系统限制,同个号码,同个金额一天内只可冲1次.</font></strong></p>\r\n<p><font face="新宋体" color="#996600" size="3" style="background-color: rgb(255,255,255)">1.购买前请询问是否有货</font><font face="新宋体" color="#996600" size="3" style="background-color: rgb(255,255,255)">。</font></p>\r\n<p><font face="新宋体" color="#996600" size="3" style="background-color: rgb(255,255,255)">2.冲值速度:闲时1分钟,忙时11分钟.<strong><font face="宋体" color="#ff0000" size="4">（特殊情况例外，如停电，充值平台系统维护等）</font></strong></font></p>\r\n<p><font color="#996600" size="3" style="background-color: rgb(255,255,255)">3<font face="新宋体">.</font>适合所有所有地区，移动号码段，所有套餐</font></p>\r\n<p><font color="#996600" style="background-color: rgb(255,255,255)"><font size="3">4<font face="新宋体">.</font>买家请确认号码正确。<strong><font color="#3333ff">付款即冲,</font></strong></font></font><font face="隶书" size="3"><font face="黑体" color="#3333ff" size="4"><strong>号码一律以收货地址栏上号码为准(系统自动截取前11位号码,不足10位,自动加0,请不要多写或少写号码)，否则充错的话，责任自负。拍下后15分钟内没有冲上，请联系我查询，谢谢配合！</strong></font></font></p>\r\n<p><font style="background-color: rgb(255,255,255)"><font color="#996600" size="3" style="background-color: rgb(255,255,255)">5<font face="新宋体">.</font>欠费手机请确认欠费额，以免万一充值后话费还不够，不能正常开机，造成不必要的误会。</font></font></p>\r\n<p><font style="background-color: rgb(255,255,255)"><font size="3"><font color="#996600"><font face="新宋体"><font face="宋体">6</font>.十</font>分钟内未收到话费到帐信息请拔打10086查询。注明：一般为提交后10分钟左右，但不排除个别号码出现延迟到帐现象，因实际到帐时间每天有所不同，最终到帐时间以系统为准。充值提交后在未提示充值失败前不可以退款，不接受者请勿下手。</font></font></font></p>\r\n<p><font face="新宋体"><font style="background-color: rgb(255,255,255)"><font color="#996600"><font face="新宋体"><font size="3"><font face="宋体">7</font>.<strong><font face="宋体" color="#000000" size="4">本商品为电子虚拟商品，</font></strong>无卡无密码，由店主代理提交充值平台系统后，一般会收到短信通知。</font></font></font></font></font></p>\r\n<p><strong><font face="宋体" size="4">充值后系统（10658636或者10658638或者10086）会发一条短消息给你确认。您也可通过查询热线13800XYZ506或发短消息11至10086进行余额查询、确认。(XYZ对应你开户地的区号）</font></strong></p>', 'images/200810/thumb_img/15_thumb_G_1225048506093.jpg', 'images/200810/goods_img/15_G_1225048506711.jpg', 'images/200810/source_img/15_G_1225048506739.jpg', 0, 'virtual_card', 1, 1, 19, 1225045110, 0, 0, 1, 1, 1, 0, 0, 1225072778, 1, '', -1, -1),
(16, 7, 'ECS000016', '移动50元充值卡', '+', 1, 0, '', 3, 0.000, 57.00, 47.50, 0.00, 0, 0, 1, '', '', '', 'images/200810/thumb_img/16_thumb_G_1225048193307.jpg', 'images/200810/goods_img/16_G_1225048193234.jpg', 'images/200810/source_img/16_G_1225048193626.jpg', 0, 'virtual_card', 1, 1, 48, 1225046276, 0, 0, 1, 1, 1, 0, 0, 1225072778, 1, '', -1, -1),
(17, 7, 'ECS000017', '移动100元充值卡', '+', 4, 0, '', 3, 0.000, 0.00, 100.00, 0.00, 0, 0, 1, '', '', '<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p><span style="font-size: xx-large"><strong><font size="6">使用在线支付可以自动发货</font></strong></span></p>', 'images/200810/thumb_img/17_thumb_G_1225048178012.jpg', 'images/200810/goods_img/17_G_1225048178641.jpg', 'images/200810/source_img/17_G_1225048178389.jpg', 0, 'virtual_card', 1, 1, 0, 1225046386, 0, 0, 1, 1, 1, 0, 0, 1225072778, 1, '', -1, -1),
(18, 8, 'ECS000018', '联通10元充值卡', '+', 6, 0, '', 2, 0.000, 10.79, 9.00, 0.00, 0, 0, 1, '', '', '<p>&nbsp;</p>\r\n<p><span style="font-size: medium"><font color="#000000">使用范围：全国联通公司开户的所有号码。（桌面通、公用电话除外）</font></span></p>\r\n<p><span style="font-size: medium"><font color="#000000">包括(130、131、132、133、153、156）如意通、如意133、UP新势力、CDMA无线上网卡等。</font></span></p>\r\n<p>&nbsp;</p>\r\n<p><span style="color: #ff0000"><span style="font-size: medium">本宝贝为卡密型，使用在线支付<strong>可以自动发货</strong></span></span></p>\r\n<p>&nbsp;</p>\r\n<p><span style="font-size: medium"><font color="#0000cc"><font color="#000066">充值成功后有联通公司的短信提示</font></font></span></p>\r\n<p><span style="font-size: medium"><font color="#000066">主动查询热线10011进行余额查询、确认。</font></span></p>\r\n<p><span style="font-size: medium"><font color="#000066">联通公司客服电话：10010</font></span></p>\r\n<p>&nbsp;</p>', 'images/200810/thumb_img/18_thumb_G_1225049339689.jpg', 'images/200810/goods_img/18_G_1225049339129.jpg', 'images/200810/source_img/18_G_1225049339587.jpg', 0, 'virtual_card', 1, 1, 9, 1225049339, 0, 0, 1, 1, 1, 0, 0, 1225072778, 1, '', -1, -1),
(19, 8, 'ECS000019', '联通20元充值卡', '+', 0, 0, '', 2, 0.000, 141.60, 118.00, 0.00, 0, 0, 1, '', '', '<p><span style="font-size: medium"><font color="#000000">使用范围：全国联通公司开户的所有号码。（桌面通、公用电话除外）</font></span></p>\r\n<p><span style="font-size: medium"><font color="#000000">包括(130、131、132、133、153、156）如意通、如意133、UP新势力、CDMA无线上网卡等。</font></span></p>\r\n<p>&nbsp;</p>\r\n<p><span style="color: #ff0000"><span style="font-size: medium">本宝贝为卡密型，使用在线支付<strong>可以自动发货</strong></span></span></p>\r\n<p>&nbsp;</p>\r\n<p><span style="font-size: medium"><font color="#0000cc"><font color="#000066">充值成功后有联通公司的短信提示</font></font></span></p>\r\n<p><span style="font-size: medium"><font color="#000066">主动查询热线10011进行余额查询、确认。</font></span></p>\r\n<p><span style="font-size: medium"><font color="#000066">联通公司客服电话：10010</font></span></p>', 'images/200810/thumb_img/19_thumb_G_1225049490632.jpg', 'images/200810/goods_img/19_G_1225049490099.jpg', 'images/200810/source_img/19_G_1225049490105.jpg', 0, 'virtual_card', 1, 1, 118, 1225049490, 0, 0, 1, 1, 1, 0, 0, 1225072778, 1, '', -1, -1),
(20, 8, 'ECS000020', '联通50元充值卡', '+', 0, 0, '', 2, 0.000, 57.59, 48.00, 0.00, 0, 0, 1, '', '', '<p><span style="font-size: medium"><font color="#000000">使用范围：全国联通公司开户的所有号码。（桌面通、公用电话除外）</font></span></p>\r\n<p><span style="font-size: medium"><font color="#000000">包括(130、131、132、133、153、156）如意通、如意133、UP新势力、CDMA无线上网卡等。</font></span></p>\r\n<p>&nbsp;</p>\r\n<p><span style="color: #ff0000"><span style="font-size: medium">本宝贝为卡密型，使用在线支付<strong>可以自动发货</strong></span></span></p>\r\n<p>&nbsp;</p>\r\n<p><span style="font-size: medium"><font color="#0000cc"><font color="#000066">充值成功后有联通公司的短信提示</font></font></span></p>\r\n<p><span style="font-size: medium"><font color="#000066">主动查询热线10011进行余额查询、确认。</font></span></p>\r\n<p><span style="font-size: medium"><font color="#000066">联通公司客服电话：10010</font></span></p>', 'images/200810/thumb_img/20_thumb_G_1225049524313.jpg', 'images/200810/goods_img/20_G_1225049524821.jpg', 'images/200810/source_img/20_G_1225049524030.jpg', 0, 'virtual_card', 1, 1, 48, 1225049524, 0, 0, 1, 1, 1, 0, 0, 1225072778, 1, '', -1, -1),
(21, 8, 'ECS000021', '联通100元充值卡', '+', 2, 0, '', 2, 0.000, 114.00, 95.00, 0.00, 0, 0, 1, '', '', '<p><span style="font-size: medium"><font color="#000000">使用范围：全国联通公司开户的所有号码。（桌面通、公用电话除外）</font></span></p>\r\n<p><span style="font-size: medium"><font color="#000000">包括(130、131、132、133、153、156）如意通、如意133、UP新势力、CDMA无线上网卡等。</font></span></p>\r\n<p>&nbsp;</p>\r\n<p><span style="col