/*!40101 SET NAMES utf8mb4 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`tmerclub_admin` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `tmerclub_admin`;
/*Table structure for table `offline_handle_event` */
DROP TABLE IF EXISTS `offline_handle_event`;
CREATE TABLE `offline_handle_event` (
`event_id` bigint NOT NULL AUTO_INCREMENT COMMENT '事件id',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`handle_type` tinyint DEFAULT NULL COMMENT '1 商品 2 店铺 3满减 4.优惠券 5.团购 6.分销 7.秒杀 9.自提点',
`handle_id` bigint DEFAULT NULL COMMENT '处理id，如果是商品就是商品id，店铺就是店铺id',
`shop_id` bigint DEFAULT NULL COMMENT '关联店铺id',
`sys_type` tinyint DEFAULT NULL COMMENT '用户类型见SysTypeEnum 0.普通用户系统 1.商家端 2平台端 3供应商端',
`handler_id` bigint DEFAULT NULL COMMENT '处理人id',
`status` tinyint DEFAULT NULL COMMENT '处理状态 1平台进行下线 2 重新申请，等待审核 3.审核通过 4 审核未通过',
`offline_reason` varchar(255) DEFAULT NULL COMMENT '下线原因',
PRIMARY KEY (`event_id`),
KEY `k_handler_id` (`handle_id`),
KEY `idx_shop_and_handle` (`shop_id`,`handle_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='下线处理事件';
/*Data for the table `offline_handle_event` */
/*Table structure for table `offline_handle_event_item` */
DROP TABLE IF EXISTS `offline_handle_event_item`;
CREATE TABLE `offline_handle_event_item` (
`event_item_id` bigint NOT NULL AUTO_INCREMENT,
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`event_id` bigint NOT NULL COMMENT '事件id',
`reapply_reason` varchar(255) DEFAULT NULL COMMENT '重新申请上线理由',
`reapply_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '重新申请上线时间',
`refuse_reason` varchar(255) DEFAULT NULL COMMENT '拒绝原因',
`audit_time` datetime DEFAULT NULL COMMENT '审核时间',
PRIMARY KEY (`event_item_id`),
KEY `idx_event_id` (`event_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='下线处理事件记录项';
/*Data for the table `offline_handle_event_item` */
/*Table structure for table `sys_config` */
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config` (
`id` bigint NOT NULL AUTO_INCREMENT,
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`param_key` varchar(50) DEFAULT NULL COMMENT 'key',
`param_value` text COMMENT 'value',
`remark` varchar(500) DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`id`),
UNIQUE KEY `key` (`param_key`)
) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='系统配置信息表';
/*Data for the table `sys_config` */
insert into `sys_config`(`id`,`create_time`,`update_time`,`param_key`,`param_value`,`remark`) values
(47,'2021-01-29 10:28:51','2021-01-29 10:28:51','WXPAY_CONFIG','{\"mchId\":\"xxx\",\"keyPath\":\"/cert/apiclient_cert.p12\",\"mchKey\":\"xxxx\",\"version\":3,\"apiv3Key\":\"xxx\",\"certSerialNo\":\"xxx\",\"privateKeyContent\":\"\",\"privateCertContent\":\"\"}', '微信支付参数配置'),
(53,'2021-01-29 10:28:51','2021-05-18 20:20:39','QUICKBIRD_CONFIG','{\"eBusinessID\":\"xxxx\",\"appKey\":\"xxxx\",\"reqUrl\":\"http://api.kdniao.com/Ebusiness/EbusinessOrderHandle.aspx\",\"isOpen\":false}','快递鸟物流配置'),
(56,'2021-01-29 10:28:51','2021-01-29 10:28:51','MA_CONFIG','{\"appId\":\"xxxx\",\"secret\":\"xxxx\",\"wechatShippingAudit\":false}','微信小程序参数配置'),
(57,'2021-01-29 10:28:51','2021-01-29 10:28:51','MX_APP_CONFIG','{\"appId\":\"xxxx\"}','微信开放平申请应用相关信息参数配置'),
(59,'2021-01-29 10:28:51','2021-01-29 10:28:51','MP_CONFIG','{\"appId\":\"xxxx\",\"secret\":\"xxxx\"}','微信公众号参数配置'),
(83,'2021-01-29 10:28:51','2021-05-18 20:20:41','QUICK100_CONFIG','{\"customer\":\"xxxx\",\"key\":\"xxxx\",\"secret\":\"xxxx\",\"reqUrl\":\"https://poll.kuaidi100.com/poll/query.do\",\"isOpen\":false,\"isPrint\":false,\"mock\":false,\"printReqUrl\":\"https://api.kuaidi100.com/label/order\"}','快递100物流配置'),
(84,'2020-12-25 11:09:40','2021-07-12 10:58:06','SCORE_CONFIG','{\"signInScoreString\":\"1,1,1,1,1,1,1\",\"registerScore\":0,\"shoppingScoreSwitch\":false,\"shoppingGetScore\":100,\"shoppingUseScoreRatio\":1,\"getRatioLimit\":100.0,\"useRatioLimit\":100.0}','积分获取比例和积分抵现规则'),
(86,'2020-12-25 18:52:59','2021-07-12 10:53:41','GROWTH_CONFIG','{\"shopGrowthSwitch\":false,\"buyPrice\":1.0,\"buyOrder\":1.0}','成长值获取规则'),
(91,'2020-12-27 19:20:55','2021-07-12 10:53:48','SCORE_EXPIRE','{\"scoreExpireSwitch\":false,\"expireYear\":1}','积分常见问题设置'),
(92,'2020-12-27 21:47:19','2021-05-20 18:51:49','SCORE_QUESTION','- 1什么是积分？
积分是商城对用户的一种奖励。用户可通过完善个人资料、登录签到、参加活动等方式获得积分。积分可以在积分商城兑换到商品以及购物时使用。
- 2如何获得积分？
1）在首页签到，即可一次性获得100积分。
2）参加活动，转发微博或者填写问卷等，即可获得相应奖励积分。
3）在商城购买部分物品，即可获得相应积分。
- 3积分有有效期吗？
有。若用户连续一年没有登录，则积分自动清零。
- 4为什么我完成了任务但是没有得到积分？
“广告点击”和“问卷调查”任务都是在完成后即时结算。“领码激活”任务完成后一般需要3-5个工作日结算，结算完毕才能点击领取任务积分。
','积分常见问题设置'),
(93,'2020-12-27 21:51:08','2022-01-11 16:19:31','LEVEL_SHOW','升级好礼
会员升级送好礼，每提升一个等级都送专属优惠券
会员折扣
无折扣
部分商品99折
部分商品98折
部分商品95折
商品包邮
注册成为会员在自营店购买商品时可享受包邮优惠，商品包邮快递由商家决定，特殊原因或特殊地区，不享受包邮。
专属好券
会员注册和升级均会获赠送优惠券，购买VIP会员还可获赠付费会员专属优惠券，专属优惠券由平台直接发放到会员账户，全平台通用，尽享独特礼遇。
购物积分
会员购物返积分，升级为付费会员获得积分比例将会大大增加，累积足够积分可到积分商城兑换精美礼品或优惠券。
会员折扣
会员达到至尊会员等级，部分商品可95折购买，付费会员可直接获得折扣特权，黄金VIP至黑金VIP部分商品折扣分别为：95折、9折、85折、8折。
\n
\n
注册成为大众会员
可购买黄金VIP
\n
\n
大众会员
\n
\n
\n
成长值≥200达成
可购买铂金VIP
\n
\n
黄金VIP
\n
\n
\n
成长值≥300达成
可购买钻石VIP
\n
\n
白金VIP
\n
\n
\n
成长值≥500达成
可购买黑金VIP
\n
\n
钻石VIP
\n
\n
\n
\n
会员特权
\n
普通会员
\n
高级会员
\n
尊贵会员
\n
至尊会员
\n
\n
\n
注册好礼
\n
注册成为会员即送100积分和新人礼券
\n
\n
\n
商品包邮
\n
注册成为会员在自营店购买商品可免运费
\n
\n
\n
升级好礼
\n
会员升级送好礼，每提升一个等级都送专属优惠券
\n
\n
\n
购物积分
\n
会员购物返积分，积分可用于兑换好礼
\n
\n
\n
会员折扣
\n
无折扣
\n
部分商品99折
\n
部分商品98折
\n
部分商品95折
\n
\n
\n
付费会员
\n
黄金VIP
\n
铂金VIP
\n
钻石VIP
\n
黑金VIP
\n
\n
\n
\n
\n
\n
\n
\n
\n
商品包邮
\n
注册成为会员在自营店购买商品时可享受包邮优惠，商品包邮快递由商家决定，特殊原因或特殊地区，不享受包邮。
\n
\n
\n
\n
\n
\n
专属好券
\n
会员注册和升级均会获赠送优惠券，购买VIP会员还可获赠付费会员专属优惠券，专属优惠券由平台直接发放到会员账户，全平台通用，尽享独特礼遇。
\n
\n
\n
\n
\n
\n
购物积分
\n
会员购物返积分，升级为付费会员获得积分比例将会大大增加，累积足够积分可到积分商城兑换精美礼品或优惠券。
\n
\n
\n
\n
\n
\n
会员折扣
\n
会员达到至尊会员等级，部分商品可95折购买，付费会员可直接获得折扣特权，黄金VIP至黑金VIP部分商品折扣分别为：95折、9折、85折、8折。
\n
\n
\n
商家入驻协议
一，服务条款的确认及接受
\n1，云掌柜客户端软件（以下称“本软件”）组成电子服务的所有权和运作权归属于“xxx”所有，本软件提供的服务将完全按照其发布的服务条款和操作规则严格执行。您确认所有服务条款并完成注册程序时，本协议在您与本软件间成立并发生法律效力，同时您成为本软件正式用户。
\n2，根据国家法律法规变化和本软件运营需要，xxx有权对本协议条款及相关规则不时地进行修改，修改后的内容一旦以任何形式公布在本软件上即强制执行，并取代了相关内容，您应不时关注本软件公告，提示信息及协议，规则等相关内容的移动。您知悉并确认，如您不同意更新后的内容，应立即停止使用本软件；如您继续使用本软件，即视为知悉移动内容并同意接受。
\n二，服务需知
\n1，本软件运用自身开发的操作系统通过国际互联网络为用户提供购买商品等服务。使用本软件，您必须：
\n（1）自行配备上网的所需设备，包括个人手机，平板电脑，变频器，路由器等；
\n（2）自行负担个人上网所支付的有关服务有关的电话费用，网络费用等；
\n（3）选择与所安装终端设备相匹配的软件版本，包括但不限于iOS，Android，iPad，Windows Phone等多个xxx发布的应用版本。
\n2，基于本软件所提供的网络服务的本质，您确认并同意：
\n（1）提供的注册资料真实，准确，完整，合法有效，注册资料如有变动的，应及时更新；
\n（2）如果您提供的注册资料不合法，不真实，不准确，不详尽的，您需要承担因此引起的相应责任和后果，并且xxx保留终止您使用本软件的服务的权利。
\n三，订单
\n1，使用本软件下订单，您应先购买相关商品的权利能力和行为能力，如果您在18周岁以下，您需要在父母或监护人的监护参与下才能使用本软件。在下订单的同时，即视为您满足上述条件，逐步您在订单中提供的所有信息的真实性负责。
\n2，在您下订单时，请您仔细确认所购商品的名称，价格，数量，型号，规格，尺寸，联系地址，电话，收货人等信息。人的行为和含义表示您的行为和含义表示，您应对收货人的行为及含义表示的法律后果承担连带责任。
\n3，您理解并同意：本软件上销售商展示的商品和价格等信息可能要约邀请，您下单时应填写您希望购买的商品数量，价款及支付方式，收货人，联系方式，收据货物地址（合同预定地点），合同清单方式等内容；系统生成的订单信息是计算机信息系统根据您填充的内容自动生成的数据，仅是您向销售商发出的合同要约；销售商收到您的订单信息后，只有在销售商将您在订单中订购的商品从仓库实际直接向您发出时（以商品出库为标志），方认为您与销售商之间就实际直接向您发出的商品建立了合同关系；如果您在一份订单里订购了多种商品和销售商只给您发出了部分商品时，您与销售商之间仅就实际直接向您发出的商品建立了合同关系；只有在销售商实际直接向您发出了订单中订购的其他商品时，您和销售商之间就订单中其他已实际直接向您发出的商品才建立了合同关系。对于电子书，数字音乐，在线手机充值等数字化商品，您下单并支付货款后合同即成立。
\n4，尽管销售商做出最大的努力，但由于市场变化以及各种以合理的商业努力而非控制因素的影响，本软件无法避免您提交的订单信息中的商品出现缺货情况；如您下单所购买的商品发生缺货，您有权取消订单，销售商亦有权自行取消订单，若您已经付款，则为您进行退款。
\n四，配送
\n1，您在本软件购买的商品将按照本软件上您所指定的送货地址进行配送。订单信息中列出的运送时间为参考时间，参考时间的计算是根据库存状况，正常的处理过程和正确的正确地地填写您的送货地址，联系和联系方式等配送信息，您知悉并确认，您所购买的商品应仅由您填写的联系人接受身份查验后接收商品，因您变更联系或相关分发信息而造成的损失由您自行承担。
\n2，因如下情况造成订单延期或无法配送等，本软件将无法承受迟延配送的责任：
\n（1）客户提供错误信息和不详细的地址；
\n（2）货物送达无人签收，造成的重复配送所产生的费用及相关的后果。
\n（3）不可抗力，例如：自然灾害，交通戒严，突发战争等。
\n五，用户个人信息保护及授权
\n1，您知悉并同意，为方便您使用本软件相关服务，本软件将存储您在使用时的必要信息，包括但不限于您的真实姓名，性别，生日，配送地址，联系方式，通讯录，相册，日历，定位信息等。除法律法规规定的外部，声明您的许可xxx不会向第三方公开，披露您的个人信息。xxx对相关信息采用专业加密存储与传输方式，利用合理措施保障用户个人信息的安全。
\n2，您知悉并确认，您在注册帐号或使用本软件的过程中，需要提供真实的身份信息，xxx将根据国家法律法规相关要求，进行通过移动电话号码的真实身份信息认证。的信息不真实，不完整，则无法使用本软件或在使用过程中受到限制，同时，会产生不利后果，由您自行承担。
\n3，您在使用本软件某些特定服务时，该服务可能会另有单独的协议，相关业务规则等（以下统称为“单独协议”），您在使用此服务前请阅读并同意相关的单独协议；您使用先前特定的服务，即认为您已阅读并同意接受相关单独协议。
\n4，您充分理解并同意：
\n（1）通过邮件，短信，电话等形式接收，向在本软件注册，购物的用户，收货人发送的订单信息，促销活动等内容；
\n（2）为配合行政监管机关，司法机关执行工作，在法律规定范围内xxx有权向上述行政，司法机关提供您在使用本软件时所储存的相关信息，包括但不限于您的注册信息等，或使用相关信息进行证据保全，包括但不限于公证，见证等；
\n（3）xxx依法保障您在安装或使用过程中的知情权和选择权，在您使用本软件服务过程中，涉及您设备自带功能的服务会提前征得您同意，您一经确认，xxx有权开启包括但不预定收集位置，读取通讯录，使用摄像头，启用录音等提供服务必要的辅助功??能。
\n（4）xxx有权根据实际情况，在法律规定的范围内自行决定是否终止用户在本软件及服务中数据的最大存储期限以及用户日志的存储期限，并在服务器上为其分配数据最大存储空间等。
\n六，用户行为规范
\n1，本协议依据国家相关法律法规法规章章制定，您同意严格遵守以下义务：
\n（1）不得传输或发表：煽动抗拒，破坏宪法和法律，行政法规实施的言论，煽动颠覆国家政权，推翻社会主义制度的言论，煽动分裂国家，破坏国家统一的言论，煽动民族仇恨，民族歧视，破坏民族团结的言论；
\n（2）从中国大陆向境外传输资料信息时必须符合中国有关法规；
\n（三）不得利用本软件从事洗钱，窃取商业秘密，窃取个人信息等违法犯罪活动；
\n（4）不得干扰本软件的正常运转，不得侵入本软件及国家计算机信息系统；
\n（5）不得传输或发表任何违法犯罪的，骚扰性的，中伤他人的，侮辱性的，恐吓性的，伤害性的，庸俗的，淫秽的，不文明的等信息资料；
\n（六）不得传输或发表损害国家社会公共利益和涉及国家安全的信息资料或言论；
\n（7）不得教唆他人从事本条所禁止的行为；
\n（八）不得利用在本软件注册的账户进行牟利性经营活动；
\n（9）不得发布任何侵犯他人版权，个人信息，著作权，商标权等知识产权或合法权利的内容；
\n2，您必须对自己在网上的言论和行为承担法律责任，您若在本软件上散布和传播反动，色情或其他违反国家法律的信息，本软件的系统记录有可能作为您违反法律的证据。
\n七，软件使用规范
\n1，关于软件的获取与更新：
\n（1）您可以直接从xxx的网站上获取本软件，也可以从得到xxx授权的第三方获取，如果您从该xxx授权的第三方获取本软件或与本软件名称相同的安装程序，xxx无法保证该软件能够正常使用，因此因此给您造成的损失不予负责；
\n（2）为了改善用户体验，完善服务内容，xxx将不断努力开发新的服务，并为您不时提供软件更新，本软件新版本发布后，旧版本的软件可能无法使用，xxx不保证旧版本软件继续可用及相应的客户服务，请您随时核对并下载最新版本。
\n2，除非法律允许或xxx书面许可，否则您使用本软件过程中不得强制从事以下行为：
\n（1）删除本软件及其副本上关于著作权的信息；
\n（2）对本软件进行反向工程，反向编译，反向编译，或者以其他方式尝试发现本软件的源代码；
\n（3）对xxx拥有知识产权的内容进行使用，出租，出借，复制，修改，链接，转载，汇编，发表，出版，建立站点等；
\n（4）对本软件或本软件运行过程中释放到任何终端内存中的数据，软件运行过程中客户端与服务器端的交互数据，以及本软件运行所必需的系统数据，进行复制，修改，增加，删除，挂接运行或创作任何衍生作品，形式包括但不限于使用插件，外挂或非经xxx授权的第三方工具/服务连接本软件和相关系统；
\n（5）通过修改或伪造软件运行中的指令，数据，增加，减少减量，移动软件的功能或运行效果，或者将用作上述特定用途的软件，方法进行运营或向公众传播，无论这些行为是否为商业目的
\n（6）通过非xxx开发，授权的第三方软件，插件，外挂，系统，登录或使用xxx软件及服务，或制作，发布，传播上述工具；
\n（7）自行或者授权他人，第三方软件对本软件及其组件，模块，数据进行干扰。
\n八，违约责任
\n1，如果xxx发现或收到他人举报投诉您违反了本协议约定的，xxx有权不经通知随时对相关内容进行删除，屏蔽，并视行为情节对违规规则处所以包括但不限于警告，限制或禁止使用部分或全部功能，帐号封禁禁止重新的替换，并宣布处理结果。
\n2，xxx有权依据合理判断对有关法律法规或本协议规定的行为采取适当的法律行动，并依据法律法规保存有关信息向有关部门报告等，您应独自承担并同时产生一切法律责任。
\n3，您理解并同意，因您违反了本协议或相关服务条款的规定，导致或产生第三方所有权的任何支出，要求或损失，您必须独立承担责任；xxx因此而遭受损失的，您也必须一并赔偿。
\n4，除非另有明确的书面说明，xxx不对本软件的运营及其包含在本软件上的信息，内容，材料，产品（包括软件）或服务作任何形式的，明示或默示的声明或担保（根据中华人民共和国法律另有规定的之外）。
\n九，所有权及知识产权
\n1，您一旦接受本协议，即表明您主动将您在任何时间段在本软件发布的任何形式的信息内容（包括但不限于客户评估，客户咨询，各类主题等信息内容）的财产性权利等任何可转让的权利，如著作权财产权（包括并非逐一：复制权，发行权，出租权，展览权，表演权，放映权，广播权，信息网络传播权，摄制权，改编权，翻译权，汇编权以及所有权由著作权人版权的其他可转让权利），全部独家且不可撤销地转让给xxx所有，并且您同意xxx有权就任何所有权而单独提起诉讼。
\n2，本协议已经构成《中华人民共和国著作权法》第二十五条（条文序号遵循2010年修订版《著作权法》确定）及相关法律规定的著作权权等权利转让书面协议，其效力及于您在xxx软件上发布的任何受著作权法保护的作品内容，无论如何这些内容形成于本协议引发前还是本协议引发后。
\n3，您同意并已充分了解本协议的条款，承诺不将已发布其本软件的信息，以任何形式发布或授权其他主体以任何方式使用（包括但不限于在各类网站，媒体上使用） 。
\n4，除法另有强制性规定外，规定xxx明确的特别书面许可，任何单位或个人不得以任何方式非法地全部或部分复制，转载，引用，链接，抓取或以其他方式使用本软件的信息内容，否则，xxx有权追究其法律责任。
\n5，本软件所发布的资料信息（如文字，图表，标识，按钮图标，图像，声音文件片段，数字下载，数据编辑和软件），均是xxx内容内容提供者的财产，受中国和国际版权法的保护。本软件上所有内容的汇编是xxx的排他财产，受中国和国际版权法的保护。受中国和国际版权法的保护。
\n十，法律允许适用及其他
\n1，本协议的共识，执行和解释及争议的解决均值应适用中国法律。如双方就本协议内容发生执行任何争议，双方应尽力友好协商解决；协商不成时，任何一方不利向协议初期地人民法院提起诉讼。本协议多次地为中华人民共和国北京市大兴区。
\n2，如果本协议中任何一条被视为废止，无效或因任何理由不可执行，该条应视为可分的且并不影响任何其他条款的有效和替代性。
\n3，本协议未明示授权的其他权利仍由xxx保留，您在行使这些权利时应另外获得xxx的书面许可。xxx如果未行使任何权利，并不构成该权利的放弃。
\n4，本协议内容中以加粗方式显着标识的条款，请您进行重读。您单击“同意”按钮即视为您完全接受本协议，在单击之前请您再次确认发现注意并完全理解本协议的全部内容。
','开店协议中文配置'),
(99,'2021-05-11 16:08:08','2021-05-12 11:04:32','SHOP_PROTOCOL_EN','Merchant Onboarding Agreement
\n\n- Confirmation and acceptance of the Terms of Service
\n
\n
\n1, the cloud palm client software (hereinafter referred to as \"the software\") consists of electronic services ownership and operation rights belong to \"xxx\" all, the services provided by the software will be in full accordance with the terms of service and operating rules issued by the strict implementation. When you confirm all the terms of service and complete the registration process, this agreement is established and legally effective between you and the Software, and you become a formal user of the Software.
\n
\n2, according to changes in national laws and regulations and the operation of the Software needs, xxx has the right to modify the terms of this Agreement and related rules from time to time, the modified content once published in any form on the Software is mandatory and replaces the relevant content, you should pay attention to the Software announcement from time to time, prompt information and the agreement, rules and other related content of the move. You acknowledge and confirm that if you do not agree with the updated content, you should immediately stop using the Software; if you continue to use the Software, you are deemed to be aware of the moved content and agree to accept it.
\n
\nTwo, service needs to know
\n
\n1, the software uses its own developed operating system through the international Internet to provide users with services such as the purchase of goods. To use this software, you must.
\n
\n(1) Equip yourself with the necessary equipment for Internet access, including personal cell phones, tablets, inverters, routers, etc..
\n
\n(2) To bear their own telephone charges, network charges, etc. related to the services they pay for when accessing the Internet.
\n
\n(3) Select the software version that matches the installed terminal device, including but not limited to multiple xxx released application versions for iOS, Android, iPad, Windows Phone, etc.
\n
\n\n- Based on the nature of the network services provided by the Software, you acknowledge and agree that.
\n
\n
\n(1) the registration information provided is true, accurate, complete, legal and valid, and the registration information, if changed, should be updated in a timely manner.
\n
\n(2) If the registration information you provide is not legal, true, accurate or detailed, you need to assume the corresponding responsibility and consequences arising therefrom, and xxx reserves the right to terminate your use of the services of the Software.
\n
\nThree, orders
\n
\n1, use the software to place an order, you should first purchase the relevant goods right capacity and capacity, if you are under 18 years of age, you need to be under the supervision of parents or guardians involved in order to use the software. At the same time of placing an order, it is deemed that you meet the above conditions, and gradually you are responsible for the authenticity of all information provided in the order.
\n
\n2, when you place an order, please carefully confirm the name, price, quantity, model, specifications, size, contact address, telephone, consignee and other information of the purchased goods. The conduct and meaning of the person indicates your conduct and meaning indicates that you shall be jointly and severally liable for the legal consequences of the consignee\'s conduct and meaning.
\n
\n3, you understand and agree that: the information such as goods and prices displayed by the seller on this software may be an invitation to offer, you should fill in the quantity of goods you wish to purchase, price and payment method, consignee, contact information, receipt of goods address (the intended location of the contract), contract list method and other content; the order information generated by the system is the data automatically generated by the computer information system according to the content you fill in, and is only your After the seller receives your order information, the contractual relationship between you and the seller is considered to be established only when the seller actually sends the goods you ordered in the order directly to you from the warehouse (marked by the goods leaving the warehouse); if you order multiple goods in one order and the seller only sends you some of the goods, the contractual relationship between you and the seller is established only for the goods actually sent directly to you; if you order multiple goods in one order and the seller only sends you some of the goods, the contractual relationship between you and the seller is established only for the goods actually sent directly to you. A contractual relationship is established between you and the seller only for those items actually shipped directly to you; a contractual relationship is established between you and the seller for the other items in the order that have actually been shipped directly to you only if the seller actually shipped the other items ordered in the order directly to you. For digital goods such as e-books, digital music, and online cell phone recharge, the contract is established when you place an order and pay for the goods.
\n
\n4, despite the best efforts of the seller, due to market changes and various factors that are not controlled by reasonable commercial efforts, the Software cannot prevent the goods in your submitted order information from being out of stock; if the goods you have placed an order for are out of stock, you have the right to cancel the order and the seller has the right to cancel the order itself and refund you if you have already paid.
\n
\n\n- Distribution
\n
\n
\n1, the goods you purchase in the software will be delivered according to the delivery address you specify on the software. The delivery time listed in the order information is the reference time, the calculation of the reference time is based on the inventory status, normal processing and correctly and correctly fill in your delivery address, contact and contact information and other distribution information, you know and confirm that the goods you have purchased should only be accepted by the contact person you fill in the identity check after receiving the goods, the loss caused by your change of contact or related distribution information is your own You are responsible for any damage caused by your change of contact or related distribution information.
\n
\n2, the software will not be able to bear the responsibility for the delayed delivery if the order is delayed or cannot be delivered due to the following circumstances.
\n
\n(1) The customer provides incorrect information and an address that is not detailed.
\n
\n(2) Costs incurred for duplicate deliveries and related consequences if the goods are delivered unsigned for.
\n
\n(3) Force majeure, such as: natural disasters, traffic martial law, sudden war, etc.
\n
\nFive, user personal information protection and authorization
\n
\n1, you know and agree that in order to facilitate your use of services related to the Software, the Software will store the necessary information about you in use, including but not limited to your real name, gender, birthday, delivery address, contact information, address book, photo album, calendar, location information, etc.. Except for the laws and regulations outside, state your permission xxx will not disclose to third parties, disclose your personal information. xxx uses professional encrypted storage and transmission of relevant information, using reasonable measures to protect the safety of users\' personal information.
\n
\n2, you know and confirm that you need to provide real identity information in the process of registering an account or using the Software. xxx will carry out real identity information authentication through cell phone numbers in accordance with the relevant requirements of national laws and regulations. The information is not true and incomplete, you will not be able to use the Software or be restricted in the process of use, at the same time, there will be adverse consequences, which will be borne by you.
\n
\n\n- When you use certain specific services of the Software, there may be separate agreements and business rules for such services (hereinafter collectively referred to as \"Separate Agreements\"), and you should read and agree to the relevant Separate Agreements before using such services; by using the previous specific services, you are deemed to have read and agreed to accept the relevant Separate Agreements.
\n
\n
\n4, you fully understand and agree that.
\n
\n(1) Receive, by e-mail, SMS, telephone, etc., order information, promotions, etc., sent to users registered in the software, shopping, and consignees.
\n
\n(2) In order to cooperate with the administrative supervisory and judicial authorities, xxx has the right to provide the above administrative and judicial authorities with relevant information stored in your use of the Software, including but not limited to your registration information, etc., or use the relevant information for evidence preservation, including but not limited to notarization, witnessing, etc., within the scope of the law.
\n
\n(3) xxx in accordance with the law to protect your right to information and choice in the installation or use of the process, in the process of your use of the software service, the service involving your device comes with the function will seek your consent in advance, once you confirm, xxx has the right to open including but not scheduled to collect location, read contacts, use the camera, enable recording and other auxiliary functions necessary to provide the service? functions.
\n
\n(4) xxx has the right to terminate the maximum storage period of the User\'s data in the Software and the Services and the storage period of the User\'s logs and to allocate the maximum storage space for the data on the server, etc., at its sole discretion and within the scope of the law.
\n
\nSix, user behavior norms
\n
\n1, this agreement is based on the relevant national laws and regulations chapter, you agree to strictly comply with the following obligations.
\n
\n(1) shall not transmit or publish: incitement to resist or undermine the implementation of the Constitution, laws and administrative regulations, incitement to subvert state power or overthrow the socialist system, incitement to split the country or undermine national unity, incitement to ethnic hatred, ethnic discrimination or undermine national unity.
\n
\n(2) The transmission of data and information from mainland China to outside China must comply with relevant Chinese regulations.
\n
\n(iii) The software shall not be used to engage in money laundering, theft of trade secrets, theft of personal information and other illegal and criminal activities.
\n
\n(4) shall not interfere with the normal operation of the Software and shall not intrude into the Software and the national computer information system.
\n
\n(5) Not to transmit or publish any illegal, criminal, harassing, libelous, insulting, threatening, injurious, vulgar, obscene, uncivilized or other information materials.
\n
\n(vi) shall not transmit or publish information materials or statements that are harmful to the public interest of the state society and related to national security.
\n
\n(7) Shall not abet others to engage in conduct prohibited by this Article.
\n
\n(viii) Not to use the account registered in the Software for profit-making business activities.
\n
\n(9) Not to publish any content that infringes on the copyright, personal information, copyright, trademark rights and other intellectual property rights or legal rights of others.
\n
\n2, you must take legal responsibility for your own words and actions on the Internet, you spread and disseminate reactionary, pornographic or other information that violates national laws on the Software, the system records of the Software may be used as evidence of your violation of the law.
\n
\nSeven, software use specifications
\n
\n1, on the acquisition and updating of software.
\n
\n(1) You may obtain the Software directly from xxx\'s website or from a third party authorized by xxx, if you obtain the Software or an installer with the same name as the Software from such third party authorized by xxx, xxx cannot guarantee that the Software can be used properly and therefore will not be responsible for any damage caused to you as a result.
\n
\n(2) In order to improve the user experience and improve the service content, xxx will constantly strive to develop new services and provide you with software updates from time to time, after the release of new versions of this software, the old version of the software may not be available, xxx does not guarantee that the old version of the software continues to be available and the corresponding customer service, please feel free to check and download the latest version.
\n
\n2, unless permitted by law or xxx written permission, you may not compulsorily engage in the following acts in the course of using the Software.
\n
\n(1) Removal of information regarding copyright on the Software and its copies.
\n
\n(2) reverse engineer, reverse compile, reverse compile, or otherwise attempt to discover the source code of this software.
\n
\n(3) to use, rent, lend, copy, modify, link, reproduce, compile, publish, publish, create a site, etc. of the content of which xxx owns the intellectual property rights.
\n
\n(4) copy, modify, add, delete, hook up, run or create any derivative works of the Software or the data released into the memory of any terminal during the operation of the Software, the interaction data between the client and the server during the operation of the Software, and the system data necessary for the operation of the Software, in the form of, but not limited to, using plug-ins, plug-ins or non-xxx authorized third-party tools/services to connect the Software Software and related systems.
\n
\n(5) To modify or falsify the instructions, data, increase, decrease, or move the function or operation of the software, or to operate or communicate to the public the software or method used for the above specific purposes, whether or not for commercial purposes
\n
\n(6) through non-xxx development, authorized third-party software, plug-ins, plug-ins, systems, login or use of xxx software and services, or the production, distribution, dissemination of the above tools.
\n
\n(7) Interfere with the Software and its components, modules, and data by itself or by authorizing others or third party software.
\n
\nVIII, liability for breach of contract
\n
\n1, if xxx found or received complaints from others that you have violated the agreement, xxx has the right to remove the relevant content without notice at any time, blocking, and depending on the circumstances of the act on the violation of the rules imposed so including but not limited to warnings, restrictions or prohibitions on the use of some or all of the functions, account blocking ban on the replacement of the re-, and announced the results of the treatment.
\n
\n2, xxx has the right to take appropriate legal action based on reasonable judgment of the relevant laws and regulations or the conduct specified in this Agreement, and save the relevant information to the relevant departments in accordance with the laws and regulations, etc. You shall solely assume and generate all legal responsibilities at the same time.
\n
\n3, you understand and agree that you are solely responsible for any expenses, demands or losses of third party ownership resulting from or arising out of your breach of this agreement or the relevant terms of service; xxx must also indemnify you for any losses suffered as a result.
\n
\n4, unless otherwise expressly stated in writing, xxx makes no representations or warranties of any kind, express or implied, as to the operation of the Software or the information, content, materials, products (including the Software) or services contained on the Software (except as otherwise provided under the laws of the People\'s Republic of China).
\n
\n\n- Ownership and Intellectual Property
\n
\n
\n1, by accepting this Agreement, you are voluntarily assigning to xxx any transferable rights such as property rights in any form of information content (including, but not limited to, customer assessments, customer inquiries, information content on various topics, etc.) that you publish in the Software at any time, such as copyright property rights (including, but not individually: reproduction rights, distribution rights, rental rights, exhibition rights, performance rights, screening rights, broadcasting rights information network transmission rights, filming rights, adaptation rights, translation rights, compilation rights and other transferable rights whose ownership is copyrighted by the copyright owner), are exclusively and irrevocably assigned to xxx, and you agree that xxx has the right to bring a separate action with respect to any ownership rights.
\n
\n2, this Agreement has constituted a written agreement for the transfer of copyright rights and other rights under Article 25 of the Copyright Law of the People\'s Republic of China (the article number follows the Copyright Law as amended in 2010) and related laws, the effect of which shall apply to the content of any works protected by copyright law that you post on the xxx Software, regardless of whether such content was formed before or after this Agreement was triggered.
\n
\n3, you agree and have fully understood the terms of this agreement, promise not to release its information of this software in any form or authorize other subjects to use it in any way (including but not limited to on various websites, media).
\n
\n4, in addition to the law otherwise mandatory provisions, the provisions of xxx express special written permission, any unit or individual may not in any way illegally copy, reproduce, quote, link, capture or otherwise use the information content of the Software in whole or in part, otherwise, xxx has the right to pursue its legal responsibility.
\n
\n\n- The material information (such as text, graphics, logos, button icons, images, sound file clips, digital downloads, data compilations and software) published on the Software is the property of xxx content content providers and is protected by Chinese and international copyright laws. The compilation of all content on the Software is the exclusive property of xxx and is protected by Chinese and international copyright laws. Protected by Chinese and international copyright laws.
\n
\n
\nX, the law allows the application and other
\n
\n1, the consensus, implementation and interpretation of this Agreement and the settlement of disputes shall be governed by the laws of China. If any dispute arises between the parties regarding the implementation of the contents of this Agreement, the parties shall endeavor to resolve it through friendly consultation; if consultation fails, either party shall bring a lawsuit to the People\'s Court at the initial stage of the Agreement. The place of this Agreement is Daxing District, Beijing, People\'s Republic of China.
\n
\n\n- If any provision of this Agreement is deemed to be abrogated, invalid or for any reason unenforceable, such provision shall be deemed severable and shall not affect the validity and replaceability of any other provision.
\n
\n
\n3, Other rights not expressly authorized herein remain reserved by xxx, and you shall obtain separate written permission from xxx to exercise such rights. xxx\'s failure to exercise any right does not constitute a waiver of that right.
\n
\n4, the content of this agreement in bold marked terms, please reread. You click the \"Agree\" button is deemed to be your full acceptance of this Agreement, before you click, please reconfirm that you find attention and fully understand the entire content of this Agreement.
','开店协议英文配置'),
(103,'2021-05-18 20:28:09','2021-05-18 20:28:09','ALI_QUICK_CONFIG','{\"aliCode\":\"xxxx\",\"reqUrl\":\"https://wuliu.market.alicloudapi.com/kdi\",\"isOpen\":true}','阿里快递物流配置'),
(104,'2021-05-18 20:28:09','2021-05-18 20:28:09','PRIVACY_PROTOCOL_CN','{\"content\":\"隐私政策
\\n ,
\\n本站（以下亦称&ldquo,我们&rdquo,）深知个人信息对您的重要性，我们尊重并保护所有使用我们平台服务的用户的个人信息，并会尽全力保护您的个人信息安全可靠。我们致力于维持您对我们的信任，恪守以下原则，保护您的个人信息：权责一致原则、目的明确原则、选择同意原则、最少够用原则、确保安全原则、主体参与原则、公开透明原则等。同时，我们承诺，我们将按业界成熟的安全标准，采取相应的安全保护措施来保护您的个人信息。请在使用我们的产品（或服务）前，仔细阅读并了解本《我们隐私政策》（下称&ldquo,本隐私政策&rdquo,）。
\\n ,
\\n一、我们处理个人信息的法律依据
\\n本隐私政策制定的法律依据为《中华人民共和国消费者权益保护法》、《中华人民共和国网络安全法》、《中华人民共和国电子商务法》、《信息安全技术个人信息安全规范》以及其他涉及公民个人信息的相关法律法规。通常，我们会基于本隐私政策提示的功能收集您的个人信息。某些情况下，如果涉及其他信息的收集我们会单独向您出示个人信息保护说明条款。
\\n二、本隐私政策的适用范围
\\n本隐私政策适用于您使用本平台的产品或服务时使用。
\\n三、我们如何收集和使用您的个人信息
\\n个人信息是指以电子或者其他方式记录的能够单独或者与其他信息结合识别特定自然人身份或者反映特定自然人活动情况的各种信息。
\\n个人敏感信息是指一旦泄露、非法提供或滥用可能危害人身和财产安全，极易导致个人名誉、身心健康受到损害或歧视性待遇等的个人信息。在您向我们提供任何属于敏感信息的个人信息前，请您清楚考虑提供是恰当的并且同意您的个人敏感信息可按本隐私政策所述的目的和方式进行处理。我们会在得到您的同意后收集和使用您的敏感信息以实现与我们业务相关的功能，并允许您对这些敏感信息的收集与使用做出不同意的选择，但是拒绝使用这些信息会影响您使用相关功能。
\\n原则上，我们仅会出于本隐私政策所述的以下目的，收集和使用您的个人信息，如果超过以下目的收集和使用您的个人信息时我们会单独向您提示并征得您的同意。
\\n（一）帮助您成为我们的注册\\\\登录用户
\\n您自行注册成为我们的用户
\\n您在使用我们提供的服务时，首先需要成为我们的注册\\\\登录用户。当您注册我们账户时，您需要向我们提供您准备使用的用户名及您本人的手机号码，当您的账户密码遗失时，可以通过注册手机号码发送的链接重置密码。
\\n您可自行创建用户名，用户名的命名及使用应遵守相关法律法规并符合网络道德。用户名中不能含有任何侮辱、威胁、淫秽、谩骂等侵害他人合法权益的文字。用户名将作为您在平台上活动的标识，用以区别平台上其他用户。
\\n您提供的上述信息，将在您使用我们服务期间持续授权我们使用。在您注销账号时，我们将停止使用并删除上述信息。
\\n（二）客户服务
\\n当您向我们申诉或进行咨询时，为了方便与您联系或帮助您解决问题，我们可能需要您提供用户名、手机号码信息。如您拒绝提供上述信息，可能部分功能无法使用，同时无法向您及时反馈申诉或咨询结果。
\\n会员在本平台删除账号或后期不继续使用，注销账号时会员可以通过个人中心-系统设置-注销账号。
\\n（三）征得授权同意的例外
\\n根据相关法律法规的规定，在以下情形中，我们可以在不征得您的授权同意的情况下收集、使用一些必要的个人信息：
\\n1. ,与公共安全、公共卫生、重大公共利益直接相关的；
\\n2. ,出于维护您或其他个人的生命、财产等重大合法权益但又很难得到本人同意的；
\\n3. ,法律法规规定的其他情形。
\\n四、我们如何保护您的个人信息
\\n为保障您的信息安全，我们努力采取各种合理的物理、电子和管理方面的安全措施来保护您的信息，使您的信息不会被泄漏、毁损或者丢失，包括但不限于SSL、信息加密存储、数据中心的访问控制。
\\n数据加密：我们对于用户的用户名、手机号进行加密存储，保证用户基本信息不会被恶意获取；
\\n身份鉴别：我们通过校验账号密码或者账号绑定的手机号码，进行用户身份合法性鉴别，防止非经授权的介入；
\\n1. ,账号保护：您的账户均有安全保护功能，请妥善保管您的账户及密码信息。对用户密码进行加密等安全措施确保您的信息不丢失，不被滥用和变造。尽管有前述安全措施，但同时也请您理解，由于技术的限制以及可能存在的各种恶意手段，即便竭尽所能加强安全措施，在信息网络上也不存在&ldquo,完善的安全措施&rdquo,。如因您自己的原因导致账户及密码信息泄露而造成的任何法律后果需由您本人负责。
\\n2. ,互联网环境并非百分之百安全，我们将尽力确保或担保您发送给我们的任何信息的安全性。在不幸发生个人信息安全事件后，我们将按照法律法规的要求，及时向您告知：安全事件的基本情况和可能的影响、我们已采取或将要采取的处置措施、您可自主防范和降低风险的建议、对您的补救措施等。我们将及时将事件相关情况以手机短信的方式告知您，难以逐一告知个人信息主体时，我们会采取合理、有效的方式发布公告。
\\n五、我们如何处理未成年人的个人信息
\\n1. ,我们的服务主要面向成年人（原则上18周岁以上为成年人，16周岁以上且以自己的劳动收入为主要生活来源的我们亦视为成年人）。若您是未成年人，在使用我们的产品和/或服务前，您应在监护人的陪同下阅读本隐私政策，并应确保已征得您的监护人同意后使用我们的服务并向我们提供您的信息。 我们会根据国家相关法律法规的规定着重保护未成年人的个人信息。
\\n2. ,如您的监护人不同意您按照本隐私政策使用我们的服务或向我们提供信息，请您立即终止使用我们的服务并及时通知我们。
\\n3. ,若您是未成年人的监护人，当您对您所监护的未成年人使用我们的服务或其向我们提供的用户信息有任何疑问时，请您及时与我们联系。我们将根据国家相关法律法规及本隐私政策的规定保护未成年人用户信息的保密性及安全性。如果我们发现自己在未事先获得可证实的父母或法定监护人同意的情况下收集了未成年人的个人信息，则会设法尽快删除相关数据。
\\n六、本隐私政策的更新和通知
\\n我们的隐私政策可能变更，未经您明确同意，我们不会削减您按照本隐私政策所应享有的权利，我们会在本页面上发布对本隐私政策所做的任何变更。
\\n对于重大变更，我们还会提供更为显著的通知（包括对于某些服务， ,我们会通过手机短信发送通知，说明隐私政策的具体变更内容）。
\\n本隐私政策所指的重大变更包括但不限于：
\\n1. ,我们的服务模式发生重大变化，如处理个人信息的目的、处理的个人信息类型、个人信息的使用方式等；
\\n2. ,我们在所有权结构、组织架构等方面发生重大变化，如业务调整、破产并购等引起的所有者变更等；
\\n3. ,个人信息共享、转让或公开披露的主要对象发生变化；
\\n4. ,您参与个人信息处理方面的权利及其行使方式发生重大变化；
\\n5. ,我们负责处理个人信息安全的责任部门、联络方式及投诉渠道发生变化时。
\\n ,
\"}','隐私策略中文配置'),
(105,'2021-05-18 20:28:09','2021-05-18 20:28:09','PRIVACY_PROTOCOL_EN','{\"content\":\"Privacy Policy ,
\\nThis site (hereinafter also referred to as \\\"we\\\") is well aware of the importance of personal information to you, we respect and protect the personal information of all users who use our platform services, and will do our best to protect your personal information safe and reliable. We are committed to maintaining your trust in us and abide by the following principles to protect your personal information: the principle of consistency of rights and responsibilities, the principle of clear purpose, the principle of consent, the principle of minimum sufficient, the principle of ensuring security, the principle of subject participation, the principle of openness and transparency. At the same time, we promise that we will take appropriate security measures to protect your personal information according to the industry\'s mature security standards. Please read and understand this Privacy Policy (hereinafter referred to as the \\\"Privacy Policy\\\") carefully before using our products (or services).
\\nThe legal basis on which we process personal information
\\nThe legal basis for the formulation of this privacy policy is the Law of the People\'s Republic of China on the Protection of Consumer Rights and Interests, the Cybersecurity Law of the People\'s Republic of China, the E-commerce Law of the People\'s Republic of China, the Code for the Security of Personal Information in Information Security Technology and other relevant laws and regulations involving
\\ncitizens\' personal information. In general, we collect your personal information based on the functions indicated in this Privacy Policy. In some cases, if the collection involves other information, we will show you the terms of the Personal Information Protection Statement separately.
\\nThe scope of application of this Privacy Policy
\\nThis Privacy Policy applies to your use of the products or services of this platform.
\\nHow do we collect and use your Personal information
\\nPersonal information refers to all kinds of information recorded by electronic or other means that can identify a specific natural person or reflect the activities of a specific natural person alone or in combination with other information.
\\nSensitive personal information refers to personal information that, if leaked, illegally provided or abused, may endanger personal and property safety, easily lead to damage to personal reputation, physical and mental health, or discriminatory treatment. Before you provide us with any personal information that is sensitive information, please clearly consider that it is appropriate to provide and agree that your personal sensitive information may be processed in accordance with the purposes and methods described in this Privacy Policy. After obtaining your consent, we will collect and use your sensitive personal information to achieve functions related to our business, and allow you to choose not to consent to the collection and use of such sensitive information, but refusing to use such information will affect your use of relevant functions.
\\nIn principle, we will only collect and use your personal information for the following purposes as described in this Privacy Policy. If we collect and use your personal information for more than the following purposes, we will inform you separately and obtain your consent.
\\n1. ,To help you become our registered/logged in user
\\nYou register yourself as our user
\\nWhen you use the services we provide, you first need to become our registered/logged in user. When you register our account, you need to provide us with the user name you intend to use and your own mobile phone number, when your account password is lost, you can reset the password through the link sent by the registered mobile phone number.
\\nYou can create your own user name. The name and use of the user name should comply with relevant laws and regulations and conform to network ethics. The user name shall not contain any insulting, threatening, obscene, abusive words that infringe upon the legitimate rights and interests of others. The username will be used to identify your activities on the platform and to distinguish other users on the platform.
\\nThe above information you provide will continue to authorize us to use it during your use of our services. When you cancel your account, we will stop using and delete the above information.
\\n2. Customer Service
\\nWhen you complain or consult us, in order to contact you or help you solve the problem, we may require you to provide user name and mobile phone number information. If you refuse to provide the above information, some functions may not be available, and we will not be able to timely feedback to you about the complaint or consultation results.
\\nWhen a member deletes an account on this platform or does not continue to use it later, the member can cancel the account through Personal Center - System Settings - cancel the account.
\\n3.Exceptions to the consent of authorization
\\nAccording to the provisions of relevant laws and regulations, in the following circumstances, we can collect and use some necessary personal information without your authorization and consent:
\\nl ,Directly related to public safety, public health and major public interests,
\\nl ,Out of safeguarding your or other individuals\' life, property and other major legitimate rights and interests, but it is difficult to obtain the consent of the person,
\\nl ,Other circumstances stipulated by laws and regulations.
\\n ,
\\nHow do we protect your personal information
\\nIn order to protect the security of your information, we strive to take a variety of reasonable physical, electronic and management security measures to protect your
\\ninformation, so that your information will not be leaked, damaged or lost, including but not limited to SSL, encrypted information storage, data center access control.
\\nData encryption: We encrypt and store the user\'s user name and mobile phone number to ensure that the user\'s basic information will not be maliciously obtained,
\\nIdentity authentication: we verify the legitimacy of user identity by verifying the account password or the mobile phone number bound to the account to prevent unauthorized intervention,
\\n1. Account protection: Your account has a security protection function, please properly keep your account and password information. Encrypt the user password and other security measures to ensure that your information is not lost, not abused and altered. Despite the aforementioned security measures, please understand that due to technical limitations and possible malicious means, even if we do our best to strengthen security measures, there is no \\\"perfect security measures\\\" on the information network. You shall be responsible for any legal consequences caused by the disclosure of your account and password information due to your own reasons.
\\n2. The Internet environment is not 100% secure and we will do our best to ensure or guarantee the security of any information you send us. In the event of an unfortunate personal information security incident, we will inform you in a timely manner in accordance with the requirements of laws and regulations: the basic situation and possible impact of the security incident, the disposal measures we
\\n ,
\\n ,
\\nhave taken or will take, the suggestions you can independently prevent and reduce risks, and the remedial measures for you. We will promptly inform you of the incident by mobile phone SMS. When it is difficult to inform the subject of personal information one by one, we will take a reasonable and effective way to issue an announcement.
\\n ,
\\nHow do we handle minors\' personal information
\\n1. Our services are mainly aimed at adults (in principle, adults over the age of 18, and we also consider adults over the age of 16 who rely on their own labor income as their main source of living). If you are a minor, you should read this Privacy Policy with a guardian before using our products and/or services, and you should ensure that you have obtained the consent of your guardian to use our services and provide us with your information. We will focus on protecting minors\' personal information in accordance with relevant national laws and regulations.
\\n2. If your guardian does not agree with your use of our services or the provision of information to us in accordance with this Privacy Policy, please terminate your use of our Services immediately and notify us in time.
\\n3. If you are the guardian of a minor, if you have any questions about the minor under your custody\'s use of our Services or the user information that he or she provides to us, please contact us in time. We will protect the confidentiality and security of minor user information in accordance with relevant national laws and regulations and this privacy policy. If we discover that we have collected personal information from minors without prior verifiable parental or legal guardian consent, we will try to delete the data as soon as possible.
\\n ,
\\nUpdates and notices to this Privacy Policy
\\nOur Privacy Policy may change, and we will not reduce your rights under this Privacy Policy without your express consent. We will post any changes to this Privacy Policy on this page.
\\nFor significant changes, we may also provide more prominent notice (including for some services, we may send a notification via SMS stating the specific changes to our Privacy Policy).
\\nMaterial changes referred to in this Privacy Policy include but are not limited to:
\\nl ,Significant changes in our service model, such as the purpose of processing personal information, the type of personal information processed, the use of personal information, etc.,
\\nl ,Major changes in our ownership structure and organizational structure, such as changes in owners caused by business adjustments, bankruptcy and mergers and acquisitions,
\\nl ,Changes in the main targets for sharing, transferring or publicly disclosing personal information,
\\nl ,Significant changes in your rights to participate in the processing of personal information and the way in which they are exercised,
\\n ,
\\n ,
\\nWhen the department responsible for handling the security of personal information, contact methods and complaint channels change.
\"}','隐私策略英文配置'),
(106,'2021-05-18 20:28:09','2021-05-18 20:28:09','SERVICE_PROTOCOL_CN','{\"content\":\"服务条款
, ,
\\n一、定义
\\n平台，是指您当前所浏览的网站平台。
\\n用户，包含注册用户和非注册用户，以下亦称为&ldquo,您&rdquo,。注册用户是指通过我们平台完成全部注册程序后，使用我们平台服务或我们网站资料的用户。非注册用户是指未进行注册、直接登录我们平台或通过其他网站进入我们平台直接或间接地使用我们平台服务或我们网站资料的用户。
\\n协议方，本协议中协议双方合称&ldquo,协议方&rdquo,。
\\n二、协议的效力
\\n1. ,在您按照注册页面提示填写信息、阅读并同意本协议完成全部注册程序后，您即受本协议的约束。
\\n2. ,本协议内容包括本协议正文《隐私政策》，所有我们已经发布的或将来可能发布的规则为本协议不可分割的组成部分，与本协议具有同等法律效力。除另行明确声明外，任何我司网站提供的服务（以下称为&ldquo,我们平台服务&rdquo,）均受本协议约束。您承诺接受并遵守本协议的约定。如果您不同意本协议的约定，您应立即停止注册程序或停止使用我们平台服务；如您继续访问和使用我们平台服务，即视为您已确知并完全同意本协议各项内容。
\\n3. ,我们有权根据国家法律法规的更新、产品和服务规则的调整需要不时地制订、修改本协议或各类规则，并提前以网站公示的方式进行公示。如您继续使用我们平台服务的，即表示您接受经修订的协议和规则。如发生有关争议时，以我们最新的相关协议和规则为准。
\\n三、注册
\\n1. ,在您完成注册程序使用我们平台服务后，您应当是具备相应民事行为能力的自然人（十六周岁以上的未成年人，以自己的劳动收入为主要生活来源的，视为完全民事行为能力人）、法人或其他组织。若您不具备前述主体资格，则您及您的家长或法定监护人（以下统称\\\"监护人\\\"）应承担因此而导致的一切后果，且我们有权注销您的账户，并向您及您的监护人索偿。
\\n2. ,我们非常重视对青少年个人信息搜集和使用的安全性的保护。我们建议，任何未满18周岁的未成年人参加网上活动应事先取得其监护人可经查证的同意并遵守《全国青少年网络文明公约》。监护人应承担未成年人网络活动风险及保护未成年人相关网络隐私的首要责任。
\\n3. ,在您签署本协议，完成注册程序后，您应对您的用户名、登录密码的安全，以及对通过您的账户和密码实施的行为负责，因此所衍生的任何损失或损害，我们无法也不承担任何责任。除非有法律规定或行政司法机关的指令，且征得我们的同意，否则您的用户名、登录密码不得以任何方式转让、借用、赠与、继承（与账户相关的财产权益除外）<,或>,在第三方平台上进行展示或售卖。否则，由此给您（或我们、任何第三方）造成的一切损失，概由您自行承担（或者负责赔偿）。
\\n4. ,您在注册帐号或使用我们平台服务的过程中，应提供合法、真实、准确的个人资料，您填写的个人资料有变动的，应及时进行更新。如果因您提供的个人资料不合法、不真实、不准确的，您需承担因此引起的相应责任及后果，并且我们保留终止您使用我们各项服务的权利。
\\n5. ,您了解并同意遵守本协议条款，在通过我们平台完成注册程序之后，即可成为我们平台注册用户。
\\n6. ,您不得通过任何手段恶意注册我们网站帐号，包括但不限于以牟利、炒作、套现等为目的多个账号注册，您亦不得盗用其他用户帐号。
\\n四、我们平台服务使用规范
\\n1. ,通过我们平台，您可以按照我们的规则销售各种相关的商品。但所发布之信息不得含有如下内容：
\\n1) 反对宪法所确定的基本原则，煽动抗拒、破坏宪法和法律、行政法规实施的；
\\n2)煽动危害国家安全、泄露国家秘密、颠覆国家政权，推翻社会主义制度的；
\\n3)煽动分裂国家、破坏国家统一、损害国家荣誉和民族利益的；
\\n4)煽动民族仇恨、民族歧视，破坏民族团结的；
\\n5)捏造或者歪曲事实，散布谣言，扰乱社会秩序的；
\\n6)进行政治宣传或破坏国家宗教政策、宣扬封建迷信、淫秽、色情、赌博、暴力、凶杀、恐怖、教唆犯罪的；
\\n7)公然侮辱他人或者捏造事实诽谤他人的，或者进行其他恶意攻击的；
\\n8)损害国家机关信誉的；
\\n9)其他违反宪法和法律法规的；
\\n2. ,在接受我们服务的过程中，您不得从事下列行为：
\\n1) ,在使用我们平台服务过程中实施的所有行为均遵守国家法律、法规等规范文件及我们平台各项规则的规定和要求，不违背社会公共利益或公共道德，不损害他人的合法权益，不违反本协议及相关规则。您如果违反前述承诺，产生任何法律后果的，您应以自己的名义独立承担所有的法律责任，并确保我们免于因此产生任何损失或增加费用。
\\n2) ,不发布国家禁止发布的信息，不发布涉嫌侵犯他人知识产权或其它合法权益的信息，不发布违背社会公共利益或公共道德、公序良俗的信息，不发布其它涉嫌违法或违反本协议及各类规则的信息。
\\n3) ,不对我们平台上的任何数据作商业性利用，包括但不限于在未经我们事先书面同意的情况下，以复制、传播等任何方式使用我们平台上展示的资料。
\\n4) ,不使用任何装置、软件或例行程序干预或试图干预我们平台的正常运作或正在我们平台上进行的任何活动。您不得采取任何将导致不合理的庞大数据负载加诸我们平台网络设备的行动。
\\n3. ,您同意，在发现本网站任何内容不符合法律规定，或不符合本用户协议规定的，您有义务及时通知我们。如果您发现您的个人信息被盗用、您的版权或者其他权利被侵害，请将此情况告知我们并同时提供如下信息和材料：
\\n1)侵犯您权利的信息的网址，编号或其他可以找到该信息的细节；
\\n2)您是所述的版权或者其他权利的合法拥有者的权利证明；
\\n3)您的联系方式，包括联系人用户名，地址，电话号码和电子邮件；
\\n五、终止协议
\\n1. ,我们将在本平台公布并不时修订隐私权条款，隐私权条款构成本协议的有效组成部分。
\\n2. ,在您注销本平台账号时或后期不继续使用，我们将停止使用并删除您的信息。
\"}','服务条款中文配置'),
(107,'2021-05-18 20:28:09','2021-05-18 20:28:09','SERVICE_PROTOCOL_EN','{\"content\":\"Terms of service
\\nDefinitions
\\nl ,Platform ,refers to the platform of the website you are currently browsing.
\\nl ,Users, including registered users and non-registered users, are also referred to as \\\"you\\\". Registered user refers to the user who uses the services of our platform or materials on our website after completing all registration procedures through our platform. Non-registered user refers to the user who does not register, directly logs in to our platform or accesses our platform through other websites to use our Platform services or materials directly or indirectly.
\\nl ,Parties hereto ,are collectively referred to as \\\"Parties\\\".
\\nValidity of the Agreement
\\n1. After you fill in the information according to the prompts on the registration page, read and agree to this Agreement to complete all registration procedures, you will be bound by this Agreement.
\\n2. The content of this Agreement includes the text of this Agreement \\\"Privacy Policy\\\", all the rules we have published or may publish in the future are an integral part of this Agreement, and have the same legal effect as this Agreement. Unless otherwise expressly stated, any services provided by our website (hereinafter referred to as \\\"our Platform Services\\\") are subject to this Agreement. You undertake to accept and abide by the terms of this Agreement. If you do not agree to the terms of this Agreement, you should immediately stop the registration process or stop using our platform services, If you continue to access and use our platform services, it is deemed that you have confirmed and fully agreed to the contents of this Agreement.
\\n3. We have the right to formulate and modify this Agreement or various rules from time to time according to the update of national laws and regulations and the adjustment of product and service rules, and publicize it in advance by way of website publicity. If you continue to use our platform services, it means that you accept the revised agreement and rules. In the event of any dispute, our latest agreement and rules shall prevail.
\\n ,
\\nRegistration
\\n1. After you complete the registration procedure to use our platform services, you should be a natural person with the corresponding capacity for civil conduct (minors over the age of 16, whose main source of living is their own labor income, regarded as a person with full capacity for civil conduct), legal person or other organization. If you do not have the above-mentioned subject qualifications, you and your parents or legal guardian (hereinafter collectively referred to as the \\\"guardian\\\") shall bear all the consequences caused by this, and we have the right to cancel your account and claim compensation from you and your guardian.
\\n2. We attach great importance to the protection of the security of the collection and use of young people\'s personal information. We recommend that any minors under the age of 18 who participate in online activities should obtain the prior verifiable consent of their guardians and comply with the National Convention on Youth Internet Civility. Guardians should bear the primary responsibility for the risks of minors\' online activities and the protection of minors\' online privacy.
\\n3. After you sign this Agreement and complete the registration process, you are responsible for the security of your user name and login password, as well as for the actions carried out through your account and password, and we cannot and will not be liable for any loss or damage arising therefrom. Your user name and login password shall not be transferred, borrowed, donated, inherited (except for the property rights related to the account) in any way or displayed or sold on the third party platform, unless there is a law or the order of the administrative and judicial authorities, and with our consent. Otherwise, all losses caused to you (or us, any third party) shall be borne by you (or be liable for compensation).
\\n4. In the process of registering an account or using our platform services, you should provide legitimate, true and accurate personal information. If there is any change in the personal information you fill in, you should update it in time. If the personal information you provide is illegal, untrue and inaccurate, you shall bear the corresponding responsibilities and consequences caused by it, and we reserve the right to terminate your use of our services.
\\n5.You understand and agree to abide by the terms of this agreement, aftercompleting the registration process through our platform, you can become a registered user of our platform.
\\n6.You shall not maliciously register our website account by any means, including butnot limited to the registration of multiple accounts for the purpose of profit, speculation, cash out, etc., and you shall not steal other users\' accounts.
\\n ,
\\n ,Our platform service usage specifications ,
\\n1.Through our platform, you can sell all kinds of related goods according to our rules.However, the information posted shall not contain the following content:
\\nl ,opposing the basic principles set forth in the Constitution, inciting resistance to,or undermining the implementation of the Constitution, laws, and administrative regulations,
\\nl , ,Inciting subversion of state power, endangering national security, leaking state secrets, and overthrowing the socialist system.
\\nl ,incitement to split the country, undermine national unity, or harm nationalhonor and national interests,
\\nl ,inciting ethnic hatred, ethnic discrimination and undermining ethnic unity,
\\nl ,fabricating or distorting facts, spreading rumors and disturbing social order,
\\nl ,Conducting political propaganda or undermining the state\'s religious policies, propagating feudal superstition, obscenity, pornography, gambling, violence, murder, terror, or instigating crimes,
\\nl ,Openly insulting others or fabricating facts to slander others, or carrying out other malicious attacks,
\\nl ,damaging the reputation of state organs,
\\nl ,other activities that violate the Constitution, laws and regulations,
\\n2. In the process of receiving our services, you shall not engage in the following acts:
\\nl ,All acts carried out in the process of using our platform services shall comply with the provisions and requirements of national laws, regulations and other normative documents and the rules of our platform, and shall not violate the public interest or public morality, harm the legitimate rights and interests of others, and violate this Agreement and relevant rules. If you violate the above commitments, resulting in any legal consequences, you shall independently bear all legal responsibilities in your own name, and ensure that we are free from any loss or increase in costs.
\\nl ,Do not publish information prohibited by the State, do not publish information suspected of infringing others\' intellectual property rights or other legitimate rights and interests, do not publish information contrary to social public interests or public morality, public order and good customs, do not publish other information suspected of violating the law or in violation of this Agreement and various rules.
\\nl ,Not to make commercial use of any data on our platform, including but not limited to using the materials displayed on our platform by any means such as copying, disseminating or otherwise without our prior written consent.
\\nl ,Not use any device, software or routine to interfere or attempt to interfere with the proper operation of our Platform or any activity being conducted on our Platform. You may not take any action that would result in an unreasonably large data load being placed on the equipment on our Platform network.
\\n3. You agree that you are obligated to notify us in a timely manner if you find any content on this Site that does not comply with the law or the provisions of this User Agreement. If you find that your personal information has been used, your copyright or other rights have been infringed, please inform us of this situation and provide the following information and materials:
\\nl ,the web address, serial number or other details of the information that infringes your rights,
\\nl ,proof of rights that you are the legal owner of said copyright or other rights,
\\nl ,your contact information, including contact username, address, phone number and email,
\\nTermination of the agreement
\\n1. We will revise the Privacy Policy from time to time when it is published on this platform, and the Privacy policy forms an effective part of this Agreement.
\\n2. If you do not continue to use this platform when you cancel your account or later, we will stop using it and delete your information.
\"}','服务条款英文配置'),
(108,'2021-06-01 19:32:37','2021-06-22 15:12:15','MERCHANT_REGISTER_PROTOCOL_EN','Merchant registration agreement I. Terms of service confirmation and acceptance 1, the cloud palm client software (hereinafter referred to as \"the software\") the ownership and operation of the various electronic services belong to \"xx\" all, the services provided by the software will be in full accordance with its published service The services provided by the Software will be strictly enforced in accordance with the terms of service and operating rules published by the Software. When you confirm all the terms of service and complete the registration process, this Agreement is established and legally effective between you and the Software, and you become a formal user of the Software. 2. xx has the right to amend the terms of this Agreement and related rules from time to time in accordance with changes in national laws and regulations and the operational needs of the Software, and the amended content will take effect once it is published in any form on the Software and will replace the previous relevant content. You should pay attention to the changes in the Software\'s announcements, alert messages and related contents of the Agreement and rules from time to time. You know and confirm that if you do not agree with the updated content, you should immediately stop using the Software; if you continue to use the Software, you are deemed to know the changes and agree to accept them. Second, the service needs to know 1, the software uses its own developed operating system through the international Internet network to provide users with the purchase of goods and other services. To use the Software, you must: (1) equip yourself with the necessary equipment to access the Internet, including personal cell phones, tablets, modems, routers, etc.; (2) pay for your own personal Internet access related to this service such as telephone charges, network charges; (3) choose the software version that matches the installed terminal equipment, including but not limited to iOS, Android, iPad, Windows Phone, etc. 2. Based on the importance of the network services provided by this software, you confirm and agree that: (1) the registration information provided is true, accurate, complete, legal and valid, and the registration information shall be updated in a timely manner if there is any change; (2) if the registration information provided by you is not legal, true, accurate or exhaustive, you shall bear the corresponding responsibility and consequences arising from it. (2) If the registration information you provide is not legal, true, accurate or detailed, you shall bear the corresponding responsibility and consequences arising therefrom, and xx reserves the right to terminate your use of the services of the Software. Third, the order 1, the use of the software to place orders, you should have the right to purchase the relevant goods and capacity, if you are under 18 years of age, you need to participate in the supervision of parents or guardians to use the software. While placing an order, you are deemed to meet the above conditions and are responsible for the authenticity of all the information you provide in the order. 2. When you place an order, please carefully confirm the name, price, quantity, model, specification, size, contact address, telephone number, consignee and other information of the purchased goods. If the consignee is not the same as you, the consignee\'s behavior and intention is deemed to be your behavior and intention, and you shall be jointly and severally liable for the legal consequences of the consignee\'s behavior and intention. 3. You understand and agree that: the information of the goods and price displayed by the seller on the software is only an invitation to offer, and you shall fill in the quantity of goods you wish to purchase, price and payment method, consignee, contact information The order information generated by the system is the data automatically generated by the computer information system according to the content you fill in, and is only an offer of contract issued by you to the seller; after the seller receives your order information, only when the seller sends the goods you ordered in the order directly to you from the warehouse (marked by the goods out of the warehouse), it will be regarded as a contract between you and the seller for the actual direct delivery to you. If you have ordered multiple items in one order and the seller has only shipped some of the items to you, a contractual relationship is established between you and the seller only with respect to the items actually shipped directly to you; only when the seller has actually shipped other items ordered in the order directly to you, a contractual relationship is established between you and the seller with respect to the other items in the order that have actually been shipped directly to you. The contractual relationship is only established between you and the seller for the other goods in the order that have actually been shipped directly to you. For digital goods such as e-books, digital music, online cell phone recharge, etc., the contract will be established after you place an order and pay for the goods. 4. Despite the Seller\'s best efforts, the Software cannot prevent the goods in your submitted order information from being out of stock due to market changes and various factors that are difficult to control with reasonable commercial efforts; if the goods you have placed an order for are out of stock, you have the right to cancel the order, and the Seller has the right to cancel the order itself. The seller also has the right to cancel the order itself, and if you have already paid for it, it will handle the refund for you. IV. Delivery 1. The goods you purchase in this software will be delivered according to the delivery address specified by you on this software. The delivery time listed in the order information is the reference time, the calculation of the reference time is based on the inventory status, the normal processing and delivery time, delivery location estimates. You should clearly and accurately fill in your delivery address, contact person and contact information and other delivery information, you know and confirm that the goods you have purchased should only be accepted by the contact person you fill in after identity check to receive the goods, the loss caused by your change of contact person or relevant delivery information shall be borne by you. 2. The software will not be able to assume the responsibility for the delayed delivery if the order is delayed or cannot be delivered due to the following circumstances. (1) incorrect information and non-detailed address provided by the customer; (2) delivery of goods without anyone signing for them, resulting in the costs and related consequences arising from repeated deliveries. (3) Force majeure, such as: natural disasters, traffic martial law, sudden war, etc. V. User personal information protection and authorization 1. You know and agree that in order to facilitate your use of the services related to the Software, the Software will store the necessary information when you use it, including but not limited to your real name, gender, birthday, delivery address, contact information, address book, photo album, calendar, positioning information, etc.. Except for the circumstances stipulated by laws and regulations, xx will not disclose or reveal your personal information to third parties without your permission. xx takes professional encrypted storage and transmission of relevant information and uses reasonable measures to protect the safety of users\' personal information. 2. you know and confirm that you need to provide real identity information in the process of registering an account or using the Software. xx will, in accordance with the relevant requirements of national laws and regulations The real identity information authentication based on cell phone number will be conducted. If the information you provide is not true or complete, you will not be able to use the Software or be restricted in the process of use, and you will bear the adverse consequences arising therefrom. 3. When you use a particular service of the Software, there may be separate agreements and related business rules for that service (hereinafter collectively referred to as \"separate agreements\") 4. You fully understand and agree to: (1) receive order information, promotions and other content sent to users and recipients of the Software through email, SMS, telephone, etc.; (2) cooperate with administrative and regulatory authorities and judicial authorities to carry out their work. (2) in order to cooperate with the administrative regulatory organs, judicial organs to carry out their work, within the scope of the law xx has the right to provide the above administrative and judicial organs with the relevant information stored in your use of the Software, including but not limited to your registration information, etc., or use the relevant information for evidence preservation, including but not limited to notary, witness, etc.; (3) xx according to law to protect your right to know and the right to choose in the process of installation or use, in the process of your use of the Software services (3) xx shall protect your right to information and choice in the process of installation or use in accordance with the law, and in the process of your use of the software service, the service involving your device\'s own functions will obtain your consent in advance. (4) xx has the right to determine the maximum storage period of data in the Software and the Services for a single user and the storage period of user logs, and to allocate the maximum storage space for the data on the server, etc. in accordance with the actual situation and within the scope of the law. You agree to strictly comply with the following obligations: (1) not to transmit or publish: speech that incites resistance to or undermines the implementation of the Constitution, laws and administrative regulations, speech that incites subversion of state power or overthrows the socialist system, speech that incites secession or undermines national unity, speech that incites ethnic hatred, ethnic discrimination or undermines national unity (2) the transmission of data and information from mainland China to foreign countries must comply with the relevant Chinese laws and regulations; (3) the software shall not be used to engage in money laundering, theft of commercial secrets, theft of personal information and other illegal and criminal activities; (4) shall not interfere with the normal operation of the software, and shall not intrude into the software and the national computer information system; (5) shall not transmit or publish any illegal, criminal, harassing, slanderous, abusive, threatening (9) shall not publish any content that violates the privacy, personal information, copyright, trademark rights and other intellectual property rights or legal rights of others; 2. You shall bear legal responsibility for your own words and actions on the Internet, if you spread and disseminate reactionary, pornographic or other information that violates national laws on the Software, the system records of the Software may be used as evidence of your violation of the law. Seven, the software use specification 1, about the acquisition and update of the software: (1) you can get the software directly from the xx website, but also from the third party authorized by the xx, if you get the software from a third party not authorized by the xx or the installation program with the same name as the software, the xx can not guarantee that the software can be used normally, and is not responsible for the losses caused to you as a result; (2) in order to (2) in order to improve the user experience and improve the service content, xx will constantly strive to develop new services and provide you with software updates from time to time, after the release of the new version of the Software, the old version of the Software may not be used, xx does not guarantee that the old version of the Software will continue to be available and the corresponding customer service, please check and download the latest version at any time. 2. unless permitted by law or xx written permission, you may not engage in the process of using the Software (4) copy, modify, add, delete, hook up, run or create any derivative works of the Software or the data released into the memory of any terminal during the operation of the Software, the interaction data between the client and the server during the operation of the Software, and the system data necessary for the operation of the Software, including but not limited to the use of plug-ins, plug-ins or non-xx-authorized third-party tools/services to access the Software and related system; (5) add, delete or change the functions or operating effects of the Software by modifying or falsifying the instructions or data in the operation of the Software, or operate or disseminate the Software or methods used for the above purposes to the public, whether or not these acts are for commercial purposes; (6) log in or use the xx Software and services through third-party software, plug-ins, plug-ins or systems not developed or authorized by xx, or produce, release, dissemination of the above tools; (7) own or authorize others, third-party software to interfere with the Software and its components, modules, data. VIII. Liability for breach of contract 1. If xx finds or receives complaints from others about your violation of this Agreement, xx has the right to delete or block the relevant content at any time without notice and, depending on the circumstances of the act, impose penalties on the offending account, including but not limited to warnings, restrictions or prohibitions on the use of some or all of the functions, account banning or cancellation, and announce the results of the treatment. 2. xx has the right to impose penalties for violations of relevant laws and regulations or the provisions of this Agreement based on reasonable judgment. 3. you understand and agree that you shall be independently responsible for any claims, demands or losses claimed by third parties as a result of or arising from your violation of this Agreement or the relevant Terms of Service; xx therefore suffer 4. Unless otherwise expressly stated in writing, xx makes no representations or warranties of any kind, express or implied, regarding the operation of the Software and the information, content, materials, products (including the Software) or services contained on the Software (except as otherwise provided by the laws of the People\'s Republic of China). IX. Ownership and Intellectual Property Rights 1. Once you accept this Agreement, it means that you take the initiative to transfer any property rights and other transferable rights, such as copyright property rights (including and not limited to: reproduction rights, distribution rights, rental rights, exhibition rights, performance rights, screening rights, broadcasting rights, information rights, etc.) to any form of information content (including but not limited to customer reviews, customer inquiries, various topics of articles and other information content) published in the Software at any time. You agree that xx has the right to file a separate lawsuit against any subject for infringement. 2. This Agreement constitutes Article 25 of the Copyright Law of the People\'s Republic of China (the numbering of the articles is in accordance with You agree and have fully understood the terms of this Agreement, and undertake not to publish the information published in the Software in any form or authorize other subjects to use the Software for any purpose. 4. Except as otherwise compulsorily provided by law, without the express written permission of xx, no entity or individual may unlawfully copy, reproduce, quote, link, capture or otherwise use the information content of the Software in whole or in part in any manner, or xx shall have the right to pursue its legal liability. 5. The data and information published in the Software (such as text, graphics, logos, button icons, images, sound file clips, digital downloads, data editing and software) are the property of xx or its content providers and are protected by Chinese and international copyright laws. The compilation of all content on the Software is the exclusive property of xx and is protected by Chinese and international copyright laws. All software on the Software is the property of xx or its affiliates or its software suppliers and is protected by Chinese and international copyright laws. X. Legal Jurisdiction Applicable and Others 1. The laws of China shall apply to the conclusion, execution and interpretation of this Agreement and the resolution of disputes. If any dispute arises between the parties regarding the content of this Agreement or its implementation, the parties shall endeavor to resolve it through friendly negotiation; if negotiation fails, either party may file a lawsuit with the People\'s Court of the place where the Agreement was signed. This Agreement is entered into in Daxing District, Beijing, People\'s Republic of China.2. If any provision of this Agreement is deemed to be abrogated, invalid or for any reason unenforceable, such provision shall be deemed severable and shall not affect the validity and enforceability of any remaining provisions.3. Other rights not expressly authorized by this Agreement shall remain reserved by xx, and you shall obtain separate written permission from xx to exercise such rights.xx If xx does not If xx does not exercise any of the foregoing rights, it does not constitute a waiver of such rights. 4. Please read the terms of this Agreement that are prominently marked in bold in the content of this Agreement. You are deemed to have accepted this Agreement in its entirety by clicking the \"Agree\" button, and please reaffirm that you are aware of and fully understand this Agreement before clicking.
','商家注册协议英文配置'),
(109,'2021-06-01 19:32:37','2021-06-02 09:53:14','MERCHANT_REGISTER_PROTOCOL_CN','商家注册协议
\n一、服务条款的确认及接受
\n1、云掌柜客户端软件（以下称“本软件”）各项电子服务的所有权和运作权归属于“xx”所有，本软件提供的服务将完全按照其发布的服务条款和操作规则严格执行。您确认所有服务条款并完成注册程序时，本协议在您与本软件间成立并发生法律效力，同时您成为本软件正式用户。
\n2、根据国家法律法规变化及本软件运营需要，xx有权对本协议条款及相关规则不时地进行修改，修改后的内容一旦以任何形式公布在本软件上即生效，并取代此前相关内容，您应不时关注本软件公告、提示信息及协议、规则等相关内容的变动。您知悉并确认，如您不同意更新后的内容，应立即停止使用本软件；如您继续使用本软件，即视为知悉变动内容并同意接受。
\n二、服务需知
\n1、本软件运用自身开发的操作系统通过国际互联网络为用户提供购买商品等服务。使用本软件，您必须：
\n（1）自行配备上网的所需设备，包括个人手机、平板电脑、调制解调器、路由器等；
\n（2）自行负担个人上网所支付的与此服务有关的电话费用、网络费用等；
\n（3）选择与所安装终端设备相匹配的软件版本，包括但不限于iOS、Android、iPad、Windows Phone等多个xx发布的应用版本。
\n2、基于本软件所提供的网络服务的重要性，您确认并同意：
\n（1）提供的注册资料真实、准确、完整、合法有效，注册资料如有变动的，应及时更新；
\n（2）如果您提供的注册资料不合法、不真实、不准确、不详尽的，您需承担因此引起的相应责任及后果，并且xx保留终止您使用本软件各项服务的权利。
\n三、订单
\n1、使用本软件下订单，您应具备购买相关商品的权利能力和行为能力，如果您在18周岁以下，您需要在父母或监护人的监护参与下才能使用本软件。在下订单的同时，即视为您满足上述条件，并对您在订单中提供的所有信息的真实性负责。
\n2、在您下订单时，请您仔细确认所购商品的名称、价格、数量、型号、规格、尺寸、联系地址、电话、收货人等信息。收货人与您本人不一致的，收货人的行为和意思表示视为您的行为和意思表示，您应对收货人的行为及意思表示的法律后果承担连带责任。
\n3、您理解并同意：本软件上销售商展示的商品和价格等信息仅仅是要约邀请，您下单时须填写您希望购买的商品数量、价款及支付方式、收货人、联系方式、收货地址（合同履行地点）、合同履行方式等内容；系统生成的订单信息是计算机信息系统根据您填写的内容自动生成的数据，仅是您向销售商发出的合同要约；销售商收到您的订单信息后，只有在销售商将您在订单中订购的商品从仓库实际直接向您发出时（以商品出库为标志），方视为您与销售商之间就实际直接向您发出的商品建立了合同关系；如果您在一份订单里订购了多种商品并且销售商只给您发出了部分商品时，您与销售商之间仅就实际直接向您发出的商品建立了合同关系；只有在销售商实际直接向您发出了订单中订购的其他商品时，您和销售商之间就订单中其他已实际直接向您发出的商品才成立合同关系。对于电子书、数字音乐、在线手机充值等数字化商品，您下单并支付货款后合同即成立。
\n4、尽管销售商做出最大的努力，但由于市场变化及各种以合理商业努力难以控制因素的影响，本软件无法避免您提交的订单信息中的商品出现缺货情况；如您下单所购买的商品发生缺货，您有权取消订单，销售商亦有权自行取消订单，若您已经付款，则为您办理退款。
\n四、配送
\n1、您在本软件购买的商品将按照本软件上您所指定的送货地址进行配送。订单信息中列出的送货时间为参考时间，参考时间的计算是根据库存状况、正常的处理过程和送货时间、送货地点的基础上估计得出的。您应当清楚准确地填写您的送货地址、联系人及联系方式等配送信息，您知悉并确认，您所购买的商品应仅由您填写的联系人接受身份查验后接收商品，因您变更联系人或相关配送信息而造成的损失由您自行承担。
\n2、因如下情况造成订单延迟或无法配送等，本软件将无法承担迟延配送的责任：
\n（1）客户提供错误信息和不详细的地址；
\n（2）货物送达无人签收，由此造成的重复配送所产生的费用及相关的后果。
\n（3）不可抗力，例如：自然灾害、交通戒严、突发战争等。
\n五、用户个人信息保护及授权
\n1、您知悉并同意，为方便您使用本软件相关服务，本软件将存储您在使用时的必要信息，包括但不限于您的真实姓名、性别、生日、配送地址、联系方式、通讯录、相册、日历、定位信息等。除法律法规规定的情形外，未经您的许可xx不会向第三方公开、透露您的个人信息。xx对相关信息采取专业加密存储与传输方式，利用合理措施保障用户个人信息的安全。
\n2、您知悉并确认，您在注册帐号或使用本软件的过程中，需要提供真实的身份信息，xx将根据国家法律法规相关要求，进行基于移动电话号码的真实身份信息认证。若您提供的信息不真实、不完整，则无法使用本软件或在使用过程中受到限制，同时，由此产生的不利后果，由您自行承担。
\n3、您在使用本软件某一特定服务时，该服务可能会另有单独的协议、相关业务规则等（以下统称为“单独协议”），您在使用该项服务前请阅读并同意相关的单独协议；您使用前述特定服务，即视为您已阅读并同意接受相关单独协议。
\n4、您充分理解并同意：
\n（1）接收通过邮件、短信、电话等形式，向在本软件注册、购物的用户、收货人发送的订单信息、促销活动等内容；
\n（2）为配合行政监管机关、司法机关执行工作，在法律规定范围内xx有权向上述行政、司法机关提供您在使用本软件时所储存的相关信息，包括但不限于您的注册信息等，或使用相关信息进行证据保全，包括但不限于公证、见证等；
\n（3）xx依法保障您在安装或使用过程中的知情权和选择权，在您使用本软件服务过程中，涉及您设备自带功能的服务会提前征得您同意，您一经确认，xx有权开启包括但不限于收集地理位置、读取通讯录、使用摄像头、启用录音等提供服务必要的辅助功能。
\n（4）xx有权根据实际情况，在法律规定范围内自行决定单个用户在本软件及服务中数据的最长储存期限以及用户日志的储存期限，并在服务器上为其分配数据最大存储空间等。
\n六、用户行为规范
\n1、本协议依据国家相关法律法规规章制定，您同意严格遵守以下义务：
\n（1）不得传输或发表：煽动抗拒、破坏宪法和法律、行政法规实施的言论，煽动颠覆国家政权，推翻社会主义制度的言论，煽动分裂国家、破坏国家统一的言论，煽动民族仇恨、民族歧视、破坏民族团结的言论；
\n（2）从中国大陆向境外传输资料信息时必须符合中国有关法规；
\n（3）不得利用本软件从事洗钱、窃取商业秘密、窃取个人信息等违法犯罪活动；
\n（4）不得干扰本软件的正常运转，不得侵入本软件及国家计算机信息系统；
\n（5）不得传输或发表任何违法犯罪的、骚扰性的、中伤他人的、辱骂性的、恐吓性的、伤害性的、庸俗的，淫秽的、不文明的等信息资料；
\n（6） 不得传输或发表损害国家社会公共利益和涉及国家安全的信息资料或言论；
\n（7）不得教唆他人从事本条所禁止的行为；
\n（8）不得利用在本软件注册的账户进行牟利性经营活动；
\n（9）不得发布任何侵犯他人隐私、个人信息、著作权、商标权等知识产权或合法权利的内容；
\n2、您须对自己在网上的言论和行为承担法律责任，您若在本软件上散布和传播反动、色情或其它违反国家法律的信息，本软件的系统记录有可能作为您违反法律的证据。
\n七、软件使用规范
\n1、关于软件的获取与更新：
\n（1）您可以直接从xx的网站上获取本软件，也可以从得到xx授权的第三方获取，如果您从未经xx授权的第三方获取本软件或与本软件名称相同的安装程序，xx无法保证该软件能够正常使用，并对因此给您造成的损失不予负责；
\n（2）为了改善用户体验、完善服务内容，xx将不断努力开发新的服务，并为您不时提供软件更新，本软件新版本发布后，旧版本的软件可能无法使用，xx不保证旧版本软件继续可用及相应的客户服务，请您随时核对并下载最新版本。
\n2、除非法律允许或xx书面许可，您使用本软件过程中不得从事下列行为：
\n（1）删除本软件及其副本上关于著作权的信息；
\n（2）对本软件进行反向工程、反向汇编、反向编译，或者以其他方式尝试发现本软件的源代码；
\n（3）对xx拥有知识产权的内容进行使用、出租、出借、复制、修改、链接、转载、汇编、发表、出版、建立镜像站点等；
\n（4）对本软件或者本软件运行过程中释放到任何终端内存中的数据、软件运行过程中客户端与服务器端的交互数据，以及本软件运行所必需的系统数据，进行复制、修改、增加、删除、挂接运行或创作任何衍生作品，形式包括但不限于使用插件、外挂或非经xx授权的第三方工具/服务接入本软件和相关系统；
\n（5）通过修改或伪造软件运行中的指令、数据，增加、删减、变动软件的功能或运行效果，或者将用于上述用途的软件、方法进行运营或向公众传播，无论这些行为是否为商业目的；
\n（6）通过非xx开发、授权的第三方软件、插件、外挂、系统，登录或使用xx软件及服务，或制作、发布、传播上述工具；
\n（7）自行或者授权他人、第三方软件对本软件及其组件、模块、数据进行干扰。
\n八、违约责任
\n1、如果xx发现或收到他人举报投诉您违反本协议约定的，xx有权不经通知随时对相关内容进行删除、屏蔽，并视行为情节对违规帐号处以包括但不限于警告、限制或禁止使用部分或全部功能、帐号封禁直至注销的处罚，并公告处理结果。
\n2、xx有权依据合理判断对违反有关法律法规或本协议规定的行为采取适当的法律行动，并依据法律法规保存有关信息向有关部门报告等，您应独自承担由此而产生的一切法律责任。
\n3、您理解并同意，因您违反本协议或相关服务条款的规定，导致或产生第三方主张的任何索赔、要求或损失，您应当独立承担责任；xx因此遭受损失的，您也应当一并赔偿。
\n4、除非另有明确的书面说明,xx不对本软件的运营及其包含在本软件上的信息、内容、材料、产品（包括软件）或服务作任何形式的、明示或默示的声明或担保（根据中华人民共和国法律另有规定的以外）。
\n九、所有权及知识产权
\n1、您一旦接受本协议，即表明您主动将您在任何时间段在本软件发表的任何形式的信息内容（包括但不限于客户评价、客户咨询、各类话题文章等信息内容）的财产性权利等任何可转让的权利，如著作权财产权（包括并不限于：复制权、发行权、出租权、展览权、表演权、放映权、广播权、信息网络传播权、摄制权、改编权、翻译权、汇编权以及应当由著作权人享有的其他可转让权利），全部独家且不可撤销地转让给xx所有，并且您同意xx有权就任何主体侵权而单独提起诉讼。
\n2、本协议已经构成《中华人民共和国著作权法》第二十五条（条文序号依照2010年修订版《著作权法》确定）及相关法律规定的著作财产权等权利转让书面协议，其效力及于您在xx软件上发布的任何受著作权法保护的作品内容，无论该等内容形成于本协议订立前还是本协议订立后。
\n3、您同意并已充分了解本协议的条款，承诺不将已发表于本软件的信息，以任何形式发布或授权其它主体以任何方式使用（包括但不限于在各类网站、媒体上使用）。
\n4、除法律另有强制性规定外，未经xx明确的特别书面许可,任何单位或个人不得以任何方式非法地全部或部分复制、转载、引用、链接、抓取或以其他方式使用本软件的信息内容，否则，xx有权追究其法律责任。
\n5、本软件所刊登的资料信息（诸如文字、图表、标识、按钮图标、图像、声音文件片段、数字下载、数据编辑和软件），均是xx或其内容提供者的财产，受中国和国际版权法的保护。本软件上所有内容的汇编是xx的排他财产，受中国和国际版权法的保护。本软件上所有软件都是xx或其关联公司或其软件供应商的财产，受中国和国际版权法的保护。
\n十、法律管辖适用及其他
\n1、本协议的订立、执行和解释及争议的解决均应适用中国法律。如双方就本协议内容或其执行发生任何争议，双方应尽力友好协商解决；协商不成时，任何一方均可向协议签订地人民法院提起诉讼。本协议签订地为中华人民共和国北京市大兴区。
\n2、如果本协议中任何一条被视为废止、无效或因任何理由不可执行，该条应视为可分的且并不影响任何其余条款的有效性和可执行性。
\n3、本协议未明示授权的其他权利仍由xx保留，您在行使这些权利时须另外取得xx的书面许可。xx如果未行使前述任何权利，并不构成对该权利的放弃。
\n4、本协议内容中以加粗方式显著标识的条款，请您着重阅读。您点击“同意”按钮即视为您完全接受本协议，在点击之前请您再次确认已知悉并完全理解本协议的全部内容。
','商家注册协议中文配置'),
(110,'2021-08-06 10:30:51','2021-08-13 13:22:11','SENSITIVE_WORDS','{\"sensitiveWords\":\"\"}','敏感词配置'),
(111,'2021-08-24 14:33:51','2021-08-24 14:33:51','DISTRIBUTION_CONFIG','{\"distributionSwitch\":0,\"attribution\":1,\"autoCheck\":0,\"realName\":true,\"identityCardPic\":false,\"identityCardNumber\":true,\"frequency\":30,\"amountMax\":300,\"amountMin\":1,\"paymentExplain\":\"预计处理需要1-5个工作日\",\"number\":2}','分销配置'),
(112,'2021-08-24 14:34:51','2021-08-24 14:34:51','DISTRIBUTION_RECRUIT_CONFIG','{"title":"分销员招募计划","content":"","state":0}','分销招募推广配置'),
(113,'2021-08-24 14:35:51','2021-08-24 14:35:51','PLATFROM_WEBSITE_CONFIG','{\"loginLogoImg\":\"/2022/08/03/210b36a6cb714753b26f2671fef01453\",\"loginBgImg\":\"/2022/09/05/e18a2550528a41b0b6b23b9d5d72be80\",\"copyrightCn\":\"Copyright © 2018-2022 广州市蓝海创新科技有限公司 版权所有 | 粤ICP备18115813号-1\",\"copyrightEn\":\"Copyright © 2018-2022 广州市蓝海创新科技有限公司 版权所有 | 粤ICP备18115813号-1\",\"titleContentCn\":\"Mall4j 白洞版 平台端\",\"titleContentEn\":\"Mall4j 白洞版 平台端\",\"titleImg\":\"/2022/09/05/e18a2550528a41b0b6b23b9d5d72be80\",\"bsMenuTitleOpenCn\":\"白洞版 平台端\",\"bsMenuTitleOpenEn\":\"白洞版 平台端\",\"bsMenuTitleCloseCn\":\"平台端\",\"bsMenuTitleCloseEn\":\"平台端\",\"bsTopBarIcon\":\"/2022/09/05/e18a2550528a41b0b6b23b9d5d72be80\"}','平台端网站配置'),
(114,'2021-08-24 14:35:55','2021-08-24 14:35:55','MULTISHOP_WEBSITE_CONFIG','{\"loginLogoImg\":null,\"loginBgImg\":\"/nullb6feb720eca046a2aacba5eaa82f6ef1\",\"copyrightCn\":\"Copyright © 2018-2022 广州市蓝海创新科技有限公司\",\"copyrightEn\":\"Copyright © 2018-2022 Guangzhou Blue Ocean Innovation Technology Co., Ltd\",\"titleContentCn\":\"Mall4j 白洞版 商家端\",\"titleContentEn\":\"Mall4j-Shop\",\"titleImg\":\"/nullb6feb720eca046a2aacba5eaa82f6ef1\",\"bsTopBarIcon\":\"/nullb6feb720eca046a2aacba5eaa82f6ef1\",\"bsMenuTitleOpenCn\":\"白洞版 商家端\",\"bsMenuTitleOpenEn\":\"Mall4j-Shop\",\"bsMenuTitleCloseCn\":\"商家端\",\"bsMenuTitleCloseEn\":\"Shop\",\"pcQrcodeImg\":null,\"pcCompanyNameCn\":null,\"pcCompanyNameEn\":null,\"pcCompanyInfoCn\":null,\"pcCompanyInfoEn\":null,\"pcCompanyNameShortCn\":null,\"pcCompanyNameShortEn\":null,\"pcLogoImgText\":null,\"pcWelcomeCn\":null,\"pcWelcomeEn\":null,\"stationLoginLogoImg\":null}','商家端网站配置'),
(115,'2021-08-24 14:36:01','2021-08-24 14:36:01','SUPPLIER_WEBSITE_CONFIG','{\"loginLogoImg\":null,\"loginBgImg\":null,\"copyrightCn\":\"Copyright © 2018-2022 广州市蓝海创新科技有限公司 版权所有 | 粤ICP备18115813号-1\",\"copyrightEn\":\"Copyright © 2018-2022 广州市蓝海创新科技有限公司 版权所有 | 粤ICP备18115813号-1\",\"titleContentCn\":\"白洞版-供应商端\",\"titleContentEn\":\"白洞版-供应商端\",\"titleImg\":null,\"bsTopBarIcon\":null,\"bsMenuTitleOpenCn\":\"白洞版-供应商端\",\"bsMenuTitleOpenEn\":\"白洞版-供应商端\",\"bsMenuTitleCloseCn\":\"供应商端\",\"bsMenuTitleCloseEn\":\"供应商端\",\"pcQrcodeImg\":null,\"pcCompanyNameCn\":null,\"pcCompanyNameEn\":null,\"pcCompanyInfoCn\":null,\"pcCompanyInfoEn\":null,\"pcCompanyNameShortCn\":null,\"pcCompanyNameShortEn\":null,\"pcLogoImgText\":null,\"pcWelcomeCn\":null,\"pcWelcomeEn\":null,\"stationLoginLogoImg\":null}','供应商端网站配置'),
(116,'2021-08-24 14:36:11','2021-08-24 14:36:11','PC_WEBSITE_CONFIG','{\"loginLogoImg\":\"/nullb6feb720eca046a2aacba5eaa82f6ef1\",\"loginBgImg\":\"/nullb6feb720eca046a2aacba5eaa82f6ef1\",\"copyrightCn\":\"Copyright © 2018-2021 广州市蓝海创新科技有限公司 版权所有 | 粤ICP备18115813号-1\",\"copyrightEn\":\"Copyright © 2018-2022 广州市蓝海创新科技有限公司 版权所有 | 粤ICP备18115813号-1\",\"titleContentCn\":\"Mall4j 白洞版\",\"titleContentEn\":\"Mall4j 白洞版\",\"titleImg\":\"/nullb6feb720eca046a2aacba5eaa82f6ef1\",\"bsTopBarIcon\":null,\"bsMenuTitleOpenCn\":null,\"bsMenuTitleOpenEn\":null,\"bsMenuTitleCloseCn\":null,\"bsMenuTitleCloseEn\":null,\"pcQrcodeImg\":\"/nullb6feb720eca046a2aacba5eaa82f6ef1\",\"pcCompanyNameCn\":\" 广州市蓝海创新科技有限公司\",\"pcCompanyNameEn\":\" 广州市蓝海创新科技有限公司\",\"pcCompanyInfoCn\":\"官方网站：www.gz-yami.com\\n开源官网：www.mall4j.com\",\"pcCompanyInfoEn\":\"官方网站：www.gz-yami.com\\n开源官网：www.mall4j.com\",\"pcCompanyNameShortCn\":null,\"pcCompanyNameShortEn\":null,\"pcLogoImgText\":\"/nullb6feb720eca046a2aacba5eaa82f6ef1\",\"pcWelcomeCn\":\"欢迎来到 Mall4j 商城！\",\"pcWelcomeEn\":\"欢迎来到 Mall4j 商城！\",\"stationLoginLogoImg\":null}','PC端网站配置'),
(117,'2021-08-24 14:36:15','2021-08-24 14:36:15','H5_WEBSITE_CONFIG','{\"loginLogoImg\":\"/nullb6feb720eca046a2aacba5eaa82f6ef1\",\"loginBgImg\":null,\"copyrightCn\":null,\"copyrightEn\":null,\"titleContentCn\":\"蓝海商城\",\"titleContentEn\":\"Mall4j\",\"titleImg\":null,\"bsTopBarIcon\":null,\"bsMenuTitleOpenCn\":null,\"bsMenuTitleOpenEn\":null,\"bsMenuTitleCloseCn\":null,\"bsMenuTitleCloseEn\":null,\"pcQrcodeImg\":null,\"pcCompanyNameCn\":null,\"pcCompanyNameEn\":null,\"pcCompanyInfoCn\":null,\"pcCompanyInfoEn\":null,\"pcCompanyNameShortCn\":null,\"pcCompanyNameShortEn\":null,\"pcLogoImgText\":null,\"pcWelcomeCn\":null,\"pcWelcomeEn\":null,\"stationLoginLogoImg\":null,\"h5WelcomeCn\":\"欢迎来到蓝海创新科技！\"}','H5端网站配置'),
(118, '2023-01-17 09:09:46', '2023-01-17 15:55:33', 'SPU_SWITCH_CONFIG', '{\"spuAudit\":false}', '商品配置'),
(119,'2021-08-24 14:36:15','2021-08-24 14:36:15','STATION_WEBSITE_CONFIG','{\"stationLoginLogoImg\":\"\"}','门店端网站配置'),
(120,'2023-05-29 12:35:28','2023-05-29 12:35:28','PAY_SETTLEMENT_CONFIG','{\"paySettlementType\":0}','支付结算配置'),
(121,'2023-05-29 12:35:28','2023-05-29 12:35:28','ALLINPAY_CONFIG','{\"requestUrl\":\"https://open.allinpay.com/gateway\",\"appId\":\"\",\"appSecret\":\"\",\"appPrivateKey\":\"\",\"accountSetNo\":\"\",\"appCertPath\":\"\",\"appPrivateCertPath\":\"\",\"vspCusId\":\"\",\"wechatSubAppId\":\"\",\"alipaySubAppId\":\"\"}','通联支付配置'),
(122,'2023-05-29 12:35:28','2023-05-29 12:35:28','ALI_LIVE_CONFIG','{\"pushDomain\":\"\",\"pullDomain\":\"\",\"appName\":\"\",\"pushAuthKey\":\"\",\"pullAuthKey\":\"\",\"isHttps\":\"\"}','直播配置'),
(124, '2023-11-21 10:44:00', '2023-11-21 10:45:01', 'UPLOAD_FILE_CONFIG', '{\"storageType\":\"1\",\"endPoint\":\"\",\"accessKey\":\"\",\"secretKey\":\"\",\"bucketName\":\"\"}', '文件上传配置');
/*Table structure for table `sys_user` */
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
`sys_user_id` bigint unsigned NOT NULL COMMENT '平台用户id',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`nick_name` varchar(32) NOT NULL COMMENT '昵称',
`avatar` varchar(255) NOT NULL COMMENT '头像',
`code` varchar(255) DEFAULT NULL COMMENT '员工编号',
`phone_num` varchar(64) DEFAULT NULL COMMENT '联系方式',
`has_account` tinyint DEFAULT NULL COMMENT '是否已经设置账号',
PRIMARY KEY (`sys_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='平台用户';
/*Data for the table `sys_user` */
insert into `sys_user`(`sys_user_id`,`create_time`,`update_time`,`nick_name`,`avatar`,`code`,`phone_num`,`has_account`) values
(1,'2021-06-15 11:32:33','2021-06-15 13:05:42','admin','avatar.jpg',NULL,'13800138000',1);
/*Table structure for table `web_config` */
DROP TABLE IF EXISTS `web_config`;
CREATE TABLE `web_config` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`config_type` tinyint DEFAULT NULL COMMENT '配置类型（1:平台端 2:商家端 3:PC端 4:h5端）',
`is_activity` tinyint DEFAULT '0' COMMENT '激活（0:否 1:是）',
`login_logo_img` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '登录logo',
`login_bg_img` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '登录背景(后台+pc)',
`copyright_cn` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '版权声明-中文(后台+pc)',
`copyright_en` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '版权声明-英文(后台+pc)',
`title_content_cn` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '网站标题文本-中文(后台+pc+h5)',
`title_content_en` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '网站标题文本-英文(后台+pc+h5)',
`title_img` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '标题图标(后台+pc)',
`bs_menu_title_open_cn` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '后台-菜单展开时的文本-中文',
`bs_menu_title_open_en` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '后台-菜单展开时的文本-英文',
`bs_menu_title_close_cn` varchar(15) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '后台-菜单缩小时的文本-中文',
`bs_menu_title_close_en` varchar(15) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '后台-菜单缩小时的文本-英文',
`bs_top_bar_icon` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '后台-顶部栏图标',
`pc_qrcode_img` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'PC-底部二维码',
`pc_company_name_cn` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'PC-公司全名-中文',
`pc_company_name_en` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'PC-公司全名-英文',
`pc_company_name_short_cn` varchar(120) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'PC-公司名简写-中文',
`pc_company_name_short_en` varchar(120) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'PC-公司名简写-英文',
`pc_logo_img_text` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'PC-公司图文logo（注册、登录、改密时显示）',
`pc_welcome_cn` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'PC-导航栏欢迎语-中文',
`pc_welcome_en` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'PC-导航栏欢迎语-英文',
`pc_company_info_cn` text COLLATE utf8mb4_general_ci COMMENT 'PC-底部公司地址等信息-中文',
`pc_company_info_en` text COLLATE utf8mb4_general_ci COMMENT 'PC-底部公司地址等信息-英文',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='网站配置信息表';
/*Data for the table `web_config` */
insert into `web_config`(`id`,`config_type`,`is_activity`,`login_logo_img`,`login_bg_img`,`copyright_cn`,`copyright_en`,`title_content_cn`,`title_content_en`,`title_img`,`bs_menu_title_open_cn`,`bs_menu_title_open_en`,`bs_menu_title_close_cn`,`bs_menu_title_close_en`,`bs_top_bar_icon`,`pc_qrcode_img`,`pc_company_name_cn`,`pc_company_name_en`,`pc_company_name_short_cn`,`pc_company_name_short_en`,`pc_logo_img_text`,`pc_welcome_cn`,`pc_welcome_en`,`pc_company_info_cn`,`pc_company_info_en`) values
(6,2,1,NULL,NULL,'Copyright © 2018-2021 广州市蓝海创新科技有限公司','Copyright © 2018-2021 Guangzhou Blue Ocean Innovation Technology Co., Ltd','Mall4j白洞版 商家端','Mall4j-Shop',NULL,'白洞版 商家端','Mall4j-Shop',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(9,4,1,NULL,NULL,NULL,NULL,'蓝海商城','Mall4j',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(10,1,1,NULL,NULL,'Copyright © 2018-2021 广州市蓝海创新科技有限公司 版权所有 | 粤ICP备18115813号-1','Copyright © 2018-2021 广州市蓝海创新科技有限公司 版权所有 | 粤ICP备18115813号-1','Mall4j 白洞版 平台端','Mall4j 白洞版 平台端',NULL,'白洞版 平台端','白洞版 平台端',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(11,3,1,NULL,NULL,'Copyright © 2018-2021 广州市蓝海创新科技有限公司 版权所有 | 粤ICP备18115813号-1','Copyright © 2018-2021 广州市蓝海创新科技有限公司 版权所有 | 粤ICP备18115813号-1','Mall4j 白洞版','Mall4j 白洞版',NULL,NULL,NULL,NULL,NULL,NULL,NULL,' 广州市蓝海创新科技有限公司',' 广州市蓝海创新科技有限公司',NULL,NULL,NULL,'欢迎来到 Mall4j 商城！','欢迎来到 Mall4j 商城！','官方网站：www.gz-yami.com\n开源官网：www.mall4j.com','官方网站：www.gz-yami.com\n开源官网：www.mall4j.com');
/*Table structure for table `sys_access_key` */
DROP TABLE IF EXISTS `sys_access_key`;
CREATE TABLE `sys_access_key` (
`sys_access_key_id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称',
`remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
`access_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '账号id',
`access_key` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密钥',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`prem_type` tinyint NOT NULL DEFAULT '0' COMMENT '密钥权限类型 0.全部权限 1.指定权限',
`usability_shop_id` tinyint NOT NULL DEFAULT '0' COMMENT '密钥可用店铺/供应商id,如果为0则为所有店铺/供应商',
`sys_type` tinyint NOT NULL COMMENT '系统类型 0.c端用户 1.商家端 2.平台端 3.供应商端',
PRIMARY KEY (`sys_access_key_id`),
UNIQUE KEY `un_access` (`access_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='系统密钥';
CREATE TABLE `sys_access_menu` (
`id` bigint NOT NULL AUTO_INCREMENT,
`sys_access_key_id` bigint DEFAULT NULL COMMENT '密钥id',
`menu_id` bigint DEFAULT NULL COMMENT '菜单ID',
PRIMARY KEY (`id`),
KEY `sys_access_key_idx` (`sys_access_key_id`,`menu_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6860 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='密钥对应可用菜单';
CREATE TABLE `sys_access_menu_permission` (
`id` int NOT NULL AUTO_INCREMENT,
`sys_access_key_id` bigint DEFAULT NULL COMMENT '密钥id',
`menu_permission_id` bigint DEFAULT NULL COMMENT '菜单资源id',
PRIMARY KEY (`id`),
KEY `sys_access_key_idx` (`sys_access_key_id`,`menu_permission_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1279 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='密钥对应菜单资源';
CREATE TABLE `public_bank` (
`bank_id` bigint NOT NULL AUTO_INCREMENT COMMENT '银行id',
`bank_name` varchar(255) NULL COMMENT '银行名称',
`bank_code` varchar(255) NULL COMMENT '银行代码',
`create_time` datetime NULL COMMENT '创建时间',
`update_time` datetime NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`bank_id`)
);
INSERT INTO `public_bank`
VALUES
( 1, '西安银行', '04447910', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 2, '齐鲁银行', '04094510', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 3, '汉口银行', '04145210', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 4, '中国银行', '01040000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 5, '广发银行', '03060000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 6, '交通银行', '03010000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 7, '浦东发展银行', '03100000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 8, '大连银行', '04202220', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 9, '贵阳银行', '04437010', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 10, '华夏银行', '03040000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 11, '河北银行', '04221219', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 12, '烟台银行', '04044560', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 13, '潍坊银行', '64624580', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 14, '枣庄银行', '05824540', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 15, '平安银行', '04105840', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 16, '杭州银行', '03133310', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 17, '杭州联合银行', '04023310', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 18, '汉口银行', '04140000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 19, '北京农村商业银行', '14181000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 20, '东莞农村商业银行', '14156020', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 21, '农信福建', '14173900', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 22, '农信安徽', '14473600', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 23, '农信山东', '14144500', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 24, '浙江泰隆商业银行', '03133450', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 25, '泰安商行', '05284630', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 26, '农信河南', '14404900', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 27, '日照银行', '04554770', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 28, '威海银行', '04814650', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 29, '东营银行', '05274550', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 30, '济宁银行', '05374610', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 31, '渤海银行', '03170000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 32, '恒丰银行', '03110000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 33, '德州银行', '05154680', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 34, '山东农信社', '14144500', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 35, '临商银行', '04314730', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 36, '青岛银行', '04504520', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 37, '上海银行', '04012900', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 38, '广西农信社', '14436100', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 39, '农村商业银行', '0314', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 40, '晋中市商业银行', '05605110', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 41, '上饶市商业银行', '05264330', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 42, '农信内蒙', '14511900', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 43, '农信湖南', '14385500', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 44, '深圳农村商业银行', '1404', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 45, '农村信用社', '14367000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 46, '南京银行', '04243010', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 47, '宁波银行', '04083320', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 48, '北京银行', '04031000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 49, '光大银行', '03030000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 50, '湖北农信社', '14105200', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 51, '钦州市钦南国民村镇银行', '15366310', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 52, '招商银行', '03080000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 53, '成都商业银行', '04296510', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 54, '中信银行', '03020000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 55, '民生银行', '03050000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 56, '成都银行', '3136', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 57, '农村村镇银行', '15584712', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 58, '莱商银行', '04974790', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 59, '锦州银行', '04392270', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 60, '郑州市市郊农村信用合作联社', '402491007010', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 61, '浙商银行', '0316', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 62, '湖北农信', '14105200', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 63, '成都农村商业银行', '14226510', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 64, '天津农村商业银行', '14191100', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 65, '广东南粤银行', '04895910', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 66, '浦北国民村镇银行', '0320', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 67, '钦南国民村镇银行', '15366310', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 68, '江西赣州银座村镇银行', '15204280', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 69, '焦作中旅银行股份有限公司', '04115010', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 70, '农信福建', '04023910', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 71, '湖北三峡农村商业银行', '04025350', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 72, '台州银行', '04593451', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 73, '江苏长江商业银行股份有限公司', '04933160', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 74, '盛京银行', '03132210', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 75, '石河子国民村镇银行', '14448800', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 76, '郑州银行', '04354910', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 77, '新疆石河子交银村镇银行', '03209028', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 78, '内蒙农信', '04021910', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 79, '东亚银行', '05026530', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 80, '丹东银行', '04462262', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 81, '遂宁银行', '03136620', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 82, '晋城银行', '03131680', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 83, '长安银行', '03137950', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 84, '包商银行股份有限公司鞍山道支行', '313192000110', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 85, '成都银行', '04296510', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 86, '长治银行', '05121660', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 87, '长沙农村商业银行', '31455100', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 88, '武汉农村商业银行', '04025210', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 89, '南充农村商业银行', '03146730', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 90, '青岛农商银行', '402452007125', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 91, '泸州商业银行', '03136570', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 92, '重庆农村商业银行', '14136900', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 93, '平顶山银行股份有限公司', '05484950', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 94, '江苏江南农村商业银行', '03143040', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 95, '龙江银行', '04922600', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 96, '营口银行', '64652280', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 97, '辽阳银行', '04192310', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 98, '青岛胶南海汇村镇银行', '320452200015', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 99, '乐山市商业银行', '05406650', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 100, '企业银行', '0596', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 101, '徽商银行', '0319', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 102, '村镇银行有限公司', '0320', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 103, '承德银行', '05131419', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 104, '洛阳银行', '04184930', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 105, '贵州银行', '05847000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 106, '重庆三峡银行', '0542', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 107, '乐山银行', '03136650', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 108, '农村信用社', '04020000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 109, '广东省农村信用社联合社', '14505800', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 110, '中国农业发展银行', '0203', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 111, '合肥科技农村商业银行', '04023610', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 112, '北京顺义银座村镇银行', '15201000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 113, '建设银行', '01050000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 114, '中国建设银行', '01050000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 115, '农业银行', '01030000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 116, '中国农业银行', '01030000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 117, '中国农业银行股份有限公司', '01030000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 118, '中国民生银行', '03050000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 119, '中国邮储银行', '01000000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 120, '中国工商银行', '01020000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 121, '浦发银行', '03100000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 122, '汇丰银行', '25120344', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 123, '华商银行', '03370000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 124, '南昌银行', '04484210', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 125, '绵阳商行', '04856590', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 126, '江西农信', '14394200', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 127, '广东南粤银行', '0489', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 128, '包商银行', '04791920', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 129, '哈尔滨市商业银行', '04422610', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 130, '深圳农村商业银行', '14045840', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 131, '农信银', '0402', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 132, '中原银行股份有限公司', '05864910', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 133, '长安银行', '05417900', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 134, '大华银行（中国）', '03340000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 135, '华侨永亨银行股份有限公司', '25060344', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 136, '韩亚银行（中国）', '03290000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 137, '华融湘江', '05705500', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 138, '湖南三湘银行', '03235510', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 139, '吉林银行', '04512420', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 140, '兴业银行', '03090000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 141, '湖北银行', '05755200', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 142, '晋商银行', '04491610', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 143, '盛京银行', '04170000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 144, '齐商银行', '04384530', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 145, '江苏银行', '05083000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 146, '浙江泰隆商业银行', '64733450', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 147, '广西北部湾银行', '64786110', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 148, '遂宁银行', '05516620', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 149, '江苏江南农村商业银行', '14603040', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 150, '常熟市农村商业银行', '14030001', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 151, '浙商银行', '03160000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 152, '徽商银行', '64403600', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 153, '北京农商行', '14181001', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 154, '尧都农信社', '14341770', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 155, '武汉农村商业银行', '14595210', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 156, '深圳农村商业银行', '14040000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 157, '顺德农村商业银行', '65085883', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 158, '重庆农商行', '14136530', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 159, '福建海峡银行股份有限公司', '04053910', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 160, '四川天府银行', '03130000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 161, '东莞银行', '04256020', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 162, '上海农商行', '14012900', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 163, '工商银行', '01020000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 164, '广州银行', '04135810', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 165, '温州银行', '05063330', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 166, '哈尔滨银行', '64422610', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 167, '长沙银行', '04615510', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 168, '泉州银行', '04643970', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 169, '营口银行', '04652280', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 170, '邮储银行', '01000000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 171, '东亚银行', '63200000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 172, '南洋商业银行', '03320000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 173, '恒生银行', '25140344', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 174, '晋城银行', '05031680', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 175, '集友银行有限公司', '25210344', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 176, '创兴银行有限公司', '25170344', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 177, '星展银行(中国)有限公司', '03240000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 178, '永亨银行(中国)有限公司', '03300000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 179, '永隆银行', '25100344', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 180, '花旗银行(中国)有限公司', '03190001', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 181, '日本三菱信用卡公司', '27090392', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 182, '日本三井住友银行股份有限公司', '26110392', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 183, '友利银行(中国)有限公司', '03270000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 184, '武汉农商银行', '14105210', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 185, '广东南海农村商业银行', '14075882', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 186, '广州农村商业银行股份有限公司', '14055810', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 187, '华一银行', '03390000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 188, '城市商业银行', '0313', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 189, '厦门国际银行', '05870000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 190, '重庆三峡银行', '05426900', '2023-03-21 17:15:44', '2023-03-21 17:15:44' ),
( 191, '渣打银行中国有限公司', '03220000', '2023-03-21 17:15:44', '2023-03-21 17:15:44' );
/*Table structure for table `hot_search` */
DROP TABLE IF EXISTS `hot_search`;
CREATE TABLE `hot_search` (
`hot_search_id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`shop_id` bigint DEFAULT NULL COMMENT '店铺ID 0为全平台热搜',
`content` varchar(255) NOT NULL COMMENT '内容',
`seq` int DEFAULT NULL COMMENT '顺序',
`status` tinyint NOT NULL DEFAULT '1' COMMENT '状态 0下线 1上线',
`title` varchar(255) NOT NULL COMMENT '热搜标题',
`type` tinyint NOT NULL COMMENT '1:商品热搜 2:店铺热搜',
PRIMARY KEY (`hot_search_id`) USING BTREE,
KEY `idx_shop_id` (`shop_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='热搜';
/*Data for the table `hot_search` */
/*Table structure for table `index_img` */
DROP TABLE IF EXISTS `index_img`;
CREATE TABLE `index_img` (
`img_id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`shop_id` bigint NOT NULL COMMENT '店铺ID',
`img_url` varchar(200) NOT NULL COMMENT '图片',
`status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态 1:enable, 0:disable',
`seq` int NOT NULL DEFAULT '0' COMMENT '顺序',
`spu_id` bigint DEFAULT NULL COMMENT '关联商品id',
`img_type` tinyint NOT NULL COMMENT '图片类型 0:小程序 1:pc',
PRIMARY KEY (`img_id`) USING BTREE,
KEY `idx_shop_id` (`shop_id`),
KEY `idx_spu_id` (`spu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='轮播图';
/*Data for the table `index_img` */
/*Table structure for table `notice` */
DROP TABLE IF EXISTS `notice`;
CREATE TABLE `notice` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '公告id',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`shop_id` bigint NOT NULL COMMENT '店铺id',
`title` varchar(36) NOT NULL COMMENT '公告标题',
`content` text NOT NULL COMMENT '公告内容',
`types` VARCHAR(500) NULL COMMENT '类型(多类型用逗号隔开 1:商家端显示 2:用户端 3:供应商端显示)',
`status` tinyint(1) NOT NULL COMMENT '状态(1:公布 0:撤回)',
`is_top` tinyint DEFAULT NULL COMMENT '是否置顶',
`publish_time` datetime DEFAULT NULL COMMENT '发布时间',
`is_learning` tinyint(1) DEFAULT '0' COMMENT '是否(已读1:已读 0:未读)',
`multi_shop_ids` VARCHAR(500) NULL COMMENT '可见商家范围',
`supplier_ids` VARCHAR(500) NULL COMMENT '可见供应商范围',
`user_ids` VARCHAR(500) NULL COMMENT '可见用户范围',
`immediately_send` tinyint DEFAULT NULL COMMENT '是否立即发送 1：立即发送 0：定时发送',
`send_time` datetime DEFAULT NULL COMMENT '定时发送时间' ,
PRIMARY KEY (`id`),
KEY `shop_idx`(`shop_id`)
) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='公告';
/*Data for the table `notice` */
/*Table structure for table `shop_auditing` */
DROP TABLE IF EXISTS `shop_auditing`;
CREATE TABLE `shop_auditing` (
`shop_auditing_id` bigint NOT NULL AUTO_INCREMENT COMMENT '店铺审核id',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`user_id` bigint DEFAULT NULL COMMENT '申请人id',
`shop_id` bigint DEFAULT NULL COMMENT '店铺id',
`auditor_id` bigint DEFAULT NULL COMMENT '审核人id',
`status` tinyint DEFAULT NULL COMMENT '0 未审核 1已通过 -1未通过',
`remarks` varchar(1000) DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`shop_auditing_id`),
KEY `idx_user_id` (`user_id`),
KEY `idx_shop_id` (`shop_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='商家审核信息';
/*Data for the table `shop_auditing` */
/*Table structure for table `shop_bank_card` */
DROP TABLE IF EXISTS `shop_bank_card`;
CREATE TABLE `shop_bank_card` (
`shop_bank_card_id` bigint NOT NULL AUTO_INCREMENT COMMENT '银行卡自增id',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`shop_id` bigint NOT NULL COMMENT '店铺id',
`bank_name` varchar(20) NOT NULL COMMENT '银行名称',
`opening_bank` varchar(100) DEFAULT NULL COMMENT '银行开户行',
`recipient_name` varchar(100) NOT NULL COMMENT '收款方户名',
`card_no` varchar(100) NOT NULL COMMENT '收款方账户',
`is_default` tinyint DEFAULT NULL COMMENT '是否默认 1:默认 0:非默认',
`branch_name` varchar(20) DEFAULT NULL COMMENT '支行名称',
`status` tinyint NOT NULL DEFAULT 1 COMMENT '1.正常，-1.已删除',
`bank_card_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '银行卡卡号',
`bank_card_pro` tinyint DEFAULT NULL COMMENT '银行卡/账户属性 0个人银行卡 1企业对公账户',
`union_bank` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '支付行号',
PRIMARY KEY (`shop_bank_card_id`),
KEY `idx_shop_id` (`shop_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='银行卡信息';
/*Data for the table `shop_bank_card` */
/*Table structure for table `shop_collection` */
DROP TABLE IF EXISTS `shop_collection`;
CREATE TABLE `shop_collection` (
`collection_id` bigint NOT NULL AUTO_INCREMENT COMMENT '收藏自增id',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`shop_id` bigint DEFAULT NULL COMMENT '店铺id',
`user_id` bigint NOT NULL COMMENT '用户id',
PRIMARY KEY (`collection_id`),
KEY `k_shop_id` (`shop_id`),
KEY `k_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户店铺收藏记录';
/*Data for the table `shop_collection` */
/*Table structure for table `shop_company` */
DROP TABLE IF EXISTS `shop_company`;
CREATE TABLE `shop_company` (
`shop_company_id` bigint NOT NULL AUTO_INCREMENT COMMENT '店铺工商信息id',
`shop_id` bigint unsigned NOT NULL COMMENT '店铺id',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`credit_code` varchar(30) NOT NULL COMMENT '统一社会信用代码',
`firm_name` varchar(50) NOT NULL COMMENT '企业名称',
`residence` varchar(50) DEFAULT NULL COMMENT '住所',
`representative` varchar(20) DEFAULT NULL COMMENT '法定代表人',
`legal_ids` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '法人身份证号',
`legal_phone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '法人手机号',
`capital` decimal(10,2) DEFAULT NULL COMMENT '注册资本（万元）',
`found_time` datetime DEFAULT NULL COMMENT '成立日期',
`start_time` datetime NOT NULL COMMENT '营业起始日期',
`end_time` datetime DEFAULT NULL COMMENT '营业终止日期',
`business_scope` varchar(500) NOT NULL COMMENT '经营范围',
`business_license` varchar(200) NOT NULL COMMENT '营业执照',
`identity_card_front` varchar(200) DEFAULT NULL COMMENT '身份证正面',
`identity_card_later` varchar(200) DEFAULT NULL COMMENT '身份证反面',
`status` TINYINT NOT NULL COMMENT '审核状态：1:已通过 0:待审核 -1:未通过',
PRIMARY KEY (`shop_company_id`) USING BTREE,
KEY `shop_idx`(`shop_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='店铺工商信息';
/*Data for the table `shop_company` */
/*Table structure for table `company_auditing` */
DROP TABLE IF EXISTS `company_auditing`;
CREATE TABLE `company_auditing` (
`company_auditing_id` bigint NOT NULL AUTO_INCREMENT COMMENT '工商信息审核id',
`user_id` bigint DEFAULT NULL COMMENT '申请人id',
`shop_id` bigint DEFAULT NULL COMMENT '店铺id',
`shop_company_id` bigint NOT NULL COMMENT '工商信息id',
`auditor_id` bigint DEFAULT NULL COMMENT '审核人id',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`status` tinyint NOT NULL COMMENT '审核状态：1:已通过 0:待审核 -1:未通过',
`remarks` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`company_auditing_id`) USING BTREE,
KEY `k_shop_id` (`shop_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='工商信息审核记录';
/*Data for the table `company_auditing` */
/*Table structure for table `shop_detail` */
DROP TABLE IF EXISTS `shop_detail`;
CREATE TABLE `shop_detail` (
`shop_id` bigint NOT NULL AUTO_INCREMENT COMMENT '店铺id',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`shop_name` varchar(50) NOT NULL COMMENT '店铺名称',
`intro` varchar(255) DEFAULT NULL COMMENT '店铺简介',
`notice_mobile` varchar(50) DEFAULT NULL COMMENT '接收短信号码',
`shop_logo` varchar(200) DEFAULT NULL COMMENT '店铺logo(可修改)',
`mobile_background_pic` varchar(200) DEFAULT NULL COMMENT '店铺移动端背景图',
`pc_background_pic` varchar(200) DEFAULT NULL COMMENT '店铺pc背景图',
`shop_status` tinyint NOT NULL COMMENT '店铺状态(-1:已删除 0: 停业中 1:营业中 2:平台下线 3:开店待审核 4:开店申请中 5:上线待审核)',
`type` tinyint DEFAULT NULL COMMENT '店铺类型1自营店 2普通店',
`is_preferred` tinyint DEFAULT '0' COMMENT '是否优选好店 1.是 0.不是',
`merchant_name` varchar(50) NOT NULL COMMENT '商家名称',
`contact_name` varchar(50) NOT NULL COMMENT '联系人',
`contact_phone` varchar(50) NOT NULL COMMENT '联系方式',
`contract_start_time` datetime DEFAULT NULL COMMENT '签约起始时间',
`contract_end_time` datetime DEFAULT NULL COMMENT '签约终止时间',
`is_create_member` tinyint NOT NULL DEFAULT '0' COMMENT '是否在通联创建了企业会员 0否1是',
`is_bind_phone` tinyint NOT NULL DEFAULT '0' COMMENT '是否绑定了手机号 0否1是',
`company_info_process_status` tinyint NOT NULL DEFAULT '0' COMMENT '企业信息审核状态 0.未提交 1.待审核 2.审核成功 3.审核失败',
`id_card_collect_process_status` tinyint NOT NULL DEFAULT '0' COMMENT '影印件采集审核状态 0.未上传 1.待审核 2.只有工商认证通过 3.只有法人信息通过 4.均审核通过',
`allinpay_shop_status` tinyint NOT NULL DEFAULT '0' COMMENT '通联店铺状态 0未开通 1营业中 2平台下线 3上线待审核 4开店待审核',
`company_acct_protocol_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '企业账户提现协议编号',
`legal_acct_protocol_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '法人账户提现协议编号',
PRIMARY KEY (`shop_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='店铺详情';
/*Data for the table `shop_detail` */
/*Table structure for table `shop_extension` */
DROP TABLE IF EXISTS `shop_extension`;
CREATE TABLE `shop_extension` (
`shop_extension_id` bigint NOT NULL AUTO_INCREMENT,
`shop_id` bigint NOT NULL COMMENT '店铺id',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`sale_num` int DEFAULT '0' COMMENT '店铺商品总销量',
`collection_num` bigint DEFAULT '0' COMMENT '店铺收藏数量',
PRIMARY KEY (`shop_extension_id`),
UNIQUE KEY `shop_idx`(`shop_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='店铺扩张信息';
/*Data for the table `shop_extension` */
/*Table structure for table `shop_refund_addr` */
DROP TABLE IF EXISTS `shop_refund_addr`;
CREATE TABLE `shop_refund_addr` (
`shop_refund_addr_id` bigint NOT NULL AUTO_INCREMENT COMMENT '商家退货地址id',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '建立时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`shop_id` bigint NOT NULL COMMENT '店铺id',
`mobile` varchar(20) DEFAULT NULL COMMENT '手机',
`is_default` tinyint NOT NULL COMMENT '默认地址 1:是 0:不是',
`consignee` varchar(50) DEFAULT NULL COMMENT '收货人',
`province_id` bigint DEFAULT NULL COMMENT '省ID',
`province` varchar(100) DEFAULT NULL COMMENT '省',
`city_id` bigint DEFAULT NULL COMMENT '城市ID',
`city` varchar(20) DEFAULT NULL COMMENT '城市',
`area_id` bigint DEFAULT NULL COMMENT '区ID',
`area` varchar(20) DEFAULT NULL COMMENT '区',
`addr` varchar(255) DEFAULT NULL COMMENT '地址',
`post_code` varchar(15) DEFAULT NULL COMMENT '邮编',
`lng` decimal(12,6) DEFAULT NULL COMMENT '经度',
`lat` decimal(12,6) DEFAULT NULL COMMENT '纬度',
PRIMARY KEY (`shop_refund_addr_id`),
KEY `idx_shop_id` (`shop_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='商家退货地址';
/*Data for the table `shop_refund_addr` */
/*Table structure for table `shop_user` */
DROP TABLE IF EXISTS `shop_user`;
CREATE TABLE `shop_user` (
`shop_user_id` bigint unsigned NOT NULL COMMENT '商家用户id',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`shop_id` bigint DEFAULT NULL COMMENT '关联店铺id(-1代表还没有申请创建店铺)',
`nick_name` varchar(32) NOT NULL COMMENT '昵称',
`code` varchar(255) DEFAULT NULL COMMENT '员工编号',
`phone_num` varchar(64) DEFAULT NULL COMMENT '联系方式',
`has_account` tinyint DEFAULT NULL COMMENT '是否已经设置账号 0:未设置 1:已设置',
PRIMARY KEY (`shop_user_id`),
KEY `idx_shopid` (`shop_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='商家用户';
/*Data for the table `shop_user` */
/*Table structure for table `shop_wallet` */
DROP TABLE IF EXISTS `shop_wallet`;
CREATE TABLE `shop_wallet` (
`shop_wallet_id` bigint NOT NULL AUTO_INCREMENT COMMENT '店铺钱包id',
`pay_sys_type` tinyint NOT NULL DEFAULT '0' COMMENT '支付系统类型 0默认1通联支付',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`shop_id` bigint DEFAULT NULL COMMENT '店铺id',
`unsettled_amount` bigint DEFAULT NULL COMMENT '未结算金额（用户支付）',
`settled_amount` bigint DEFAULT NULL COMMENT '已结算金额（用户确认收货后，可以提现）',
`freeze_amount` bigint DEFAULT NULL COMMENT '冻结金额（用户确认收货）',
`total_settled_amount` bigint DEFAULT NULL COMMENT '累积结算金额',
`sms_num` int DEFAULT NULL COMMENT '可用短信数量',
`version` bigint DEFAULT NULL COMMENT '乐观锁',
PRIMARY KEY (`shop_wallet_id`),
UNIQUE KEY `uk_shop_id` (`shop_id`,`pay_sys_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='商家钱包信息';
/*Data for the table `shop_wallet` */
insert into `shop_wallet`(`shop_wallet_id`,`create_time`,`update_time`,`shop_id`,`unsettled_amount`,`settled_amount`,`freeze_amount`,`total_settled_amount`,`sms_num`,`version`) values
(1,'2021-05-31 09:22:18','2021-07-09 17:31:47',0,0,0,0,0,0,0);
/*Table structure for table `shop_withdraw_cash` */
DROP TABLE IF EXISTS `shop_withdraw_cash`;
CREATE TABLE `shop_withdraw_cash` (
`cash_id` bigint NOT NULL AUTO_INCREMENT COMMENT '提现id',
`pay_sys_type` tinyint NOT NULL DEFAULT '0' COMMENT '支付系统类型 0默认1通联支付',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`shop_id` bigint DEFAULT NULL COMMENT '店铺id',
`auditor_id` bigint DEFAULT NULL COMMENT '审核人id',
`amount` bigint DEFAULT NULL COMMENT '提现金额',
`auditing_time` datetime DEFAULT NULL COMMENT '审核时间',
`status` tinyint DEFAULT NULL COMMENT '状态(0:未审核、1:已通过 -1:未通过 2:发放成功 3:发放失败)',
`remarks` varchar(255) DEFAULT NULL COMMENT '平台备注',
`shop_remarks` varchar(255) DEFAULT NULL COMMENT '店铺备注',
`paying_account` varchar(100) DEFAULT NULL COMMENT '付款户名',
`paying_card_no` varchar(100) DEFAULT NULL COMMENT '汇款账户',
`paying_time` datetime DEFAULT NULL COMMENT '汇款时间',
`shop_bank_card_id` bigint DEFAULT NULL COMMENT '收款银行卡id',
`allinpay_status` tinyint DEFAULT NULL COMMENT '通联提现状态 0.待支付 1.申请成功(还没确认) 2.提现成功 3.提现失败',
`biz_order_no` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '通联提现订单号',
`pay_fail_message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '通联提现失败原因',
PRIMARY KEY (`cash_id`),
KEY `idx_shop_id` (`shop_id`),
KEY `idx_auditor_id` (`auditor_id`),
KEY `idx_biz_order_no` (`biz_order_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='商家提现申请信息';
/*Data for the table `shop_withdraw_cash` */
/*Table structure for table `shop_withdraw_cash` */
DROP TABLE IF EXISTS `shop_payment_balance`;
CREATE TABLE `shop_payment_balance`(
`balance_payment_id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '商家支付余额表' ,
`create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' ,
`update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`shop_id` BIGINT NOT NULL COMMENT '店铺id' ,
`pay_id` BIGINT NULL COMMENT '支付单号' ,
`is_payed` TINYINT NULL COMMENT '是否支付1已支付0未支付' ,
`pay_amount` BIGINT NULL COMMENT '支付金额' ,
PRIMARY KEY (`balance_payment_id`) ,
KEY `idx_shop_id`(`shop_id`)
) ENGINE=INNODB DEFAULT CHARSET='utf8mb4' COLLATE='utf8mb4_general_ci' COMMENT='商家余额支付表';
/* Create table in target */
DROP TABLE IF EXISTS `shop_substitute_sales`;
CREATE TABLE `shop_substitute_sales`(
`shop_substitute_sales_id` bigint NOT NULL auto_increment COMMENT '代销设置id' ,
`shop_id` bigint NOT NULL COMMENT '店铺id' ,
`create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' ,
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`sales_type` tinyint NOT NULL COMMENT '代销设置类型 0.智能设价 1.手动设价' ,
`sales_price_type` tinyint NULL COMMENT '默认加价比例 0.按比例加价 1.按固定数值加价' ,
`sales_price` bigint NULL COMMENT '默认加价比例为0时，代表百分比*100，为1时代表实际奖励金额*100' ,
`order_shape` tinyint NULL DEFAULT 0 COMMENT '商家收入低于供货价订单形式默认为0 0.直接转换为待采购订单 1.通过商家已结算金额扣除差价' ,
`modifier` bigint NULL COMMENT '操作人id' ,
`automatic_off` tinyint NULL COMMENT '代销设置类型为1才有:供货价高于代销价时是否自动下架：1.是，0.否' ,
PRIMARY KEY (`shop_substitute_sales_id`) ,
KEY `idx_shop_id`(`shop_id`)
) ENGINE=InnoDB DEFAULT CHARSET='utf8mb4' COLLATE='utf8mb4_general_ci' COMMENT='代销设置表';
/*Table structure for table `shop_template` */
DROP TABLE IF EXISTS `shop_template`;
CREATE TABLE `shop_template` (
`template_id` bigint NOT NULL AUTO_INCREMENT COMMENT '店铺模板表',
`shop_id` bigint DEFAULT NULL COMMENT '店铺id',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称',
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '装修内容',
`image` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '图片',
`type` int DEFAULT NULL COMMENT '类型 1.pc 2.移动端',
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`template_id`),
KEY `shop_idx`(`shop_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='商品装修模板表';
/*Table structure for table `shop_renovation` */
DROP TABLE IF EXISTS `shop_renovation`;
CREATE TABLE `shop_renovation` (
`renovation_id` bigint NOT NULL AUTO_INCREMENT COMMENT '店铺装修id',
`shop_id` bigint DEFAULT NULL COMMENT '店铺id',
`name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '装修名称',
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '装修内容',
`home_status` tinyint DEFAULT '0' COMMENT '是否主页 1.是 0.不是',
`renovation_type` int DEFAULT NULL COMMENT '装修类型 1.pc 2.移动端',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`renovation_id`),
KEY `shop_idx`(`shop_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='店铺装修信息';
/*Table structure for table `supplier_auditing` */
DROP TABLE IF EXISTS `supplier_auditing`;
CREATE TABLE `supplier_auditing` (
`supplier_auditing_id` bigint NOT NULL AUTO_INCREMENT COMMENT '供应商审核id',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`user_id` bigint DEFAULT NULL COMMENT '申请人id',
`supplier_id` bigint DEFAULT NULL COMMENT '供应商ID',
`auditor_id` bigint DEFAULT NULL COMMENT '审核人id',
`status` tinyint DEFAULT NULL COMMENT '0 未审核 1已通过 -1未通过',
`remarks` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`supplier_auditing_id`),
KEY `idx_user_id` (`user_id`),
KEY `idx_supplier_id` (`supplier_id`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='供应商审核信息';
/*Table structure for table `supplier_bank_card` */
DROP TABLE IF EXISTS `supplier_bank_card`;
CREATE TABLE `supplier_bank_card` (
`supplier_bank_card_id` bigint NOT NULL AUTO_INCREMENT COMMENT '银行卡自增id',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`supplier_id` bigint NOT NULL COMMENT '供应商ID',
`bank_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '银行名称',
`opening_bank` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '银行开户行',
`recipient_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '收款方户名',
`card_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '收款方账户',
`is_default` tinyint DEFAULT NULL COMMENT '是否默认 1:默认 0:非默认',
`branch_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '支行名称',
`bank_card_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '银行卡卡号',
`bank_card_pro` tinyint DEFAULT NULL COMMENT '银行卡/账户属性 0个人银行卡 1企业对公账户',
`union_bank` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '支付行号',
`status` tinyint NOT NULL DEFAULT '1' COMMENT '1.正常，-1.已删除',
PRIMARY KEY (`supplier_bank_card_id`),
KEY `idx_supplier_id` (`supplier_id`)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='银行卡信息';
/*Table structure for table `supplier_company` */
DROP TABLE IF EXISTS `supplier_company`;
CREATE TABLE `supplier_company` (
`supplier_company_id` bigint NOT NULL AUTO_INCREMENT COMMENT '供应商工商信息id',
`supplier_id` bigint unsigned NOT NULL COMMENT '供应商ID',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`credit_code` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '统一社会信用代码',
`firm_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '企业名称',
`residence` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '住所',
`representative` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '法定代表人',
`legal_ids` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '法人身份证号',
`legal_phone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '法人手机号',
`capital` decimal(10,2) DEFAULT NULL COMMENT '注册资本（万元）',
`found_time` datetime DEFAULT NULL COMMENT '成立日期',
`start_time` datetime NOT NULL COMMENT '营业起始日期',
`end_time` datetime DEFAULT NULL COMMENT '营业终止日期',
`business_scope` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '经营范围',
`business_license` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '营业执照',
`identity_card_front` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '身份证正面',
`identity_card_later` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '身份证反面',
`status` TINYINT NOT NULL COMMENT '审核状态：1:已通过 0:待审核 -1:未通过',
PRIMARY KEY (`supplier_company_id`) USING BTREE,
KEY `supplier_idx`(`supplier_id`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='供应商工商信息';
/*Table structure for table `supplier_company_auditing` */
DROP TABLE IF EXISTS `supplier_company_auditing`;
CREATE TABLE `supplier_company_auditing` (
`company_auditing_id` bigint NOT NULL AUTO_INCREMENT COMMENT '工商信息审核id',
`user_id` bigint DEFAULT NULL COMMENT '申请人id',
`supplier_id` bigint DEFAULT NULL COMMENT '店铺id',
`supplier_company_id` bigint NOT NULL COMMENT '工商信息id',
`auditor_id` bigint DEFAULT NULL COMMENT '审核人id',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`status` tinyint NOT NULL COMMENT '审核状态：1:已通过 0:待审核 -1:未通过',
`remarks` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`company_auditing_id`) USING BTREE,
KEY `k_supplier_id` (`supplier_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='工商信息审核记录';
/*Data for the table `supplier_company_auditing` */
/*Table structure for table `supplier_detail` */
DROP TABLE IF EXISTS `supplier_detail`;
CREATE TABLE `supplier_detail` (
`supplier_id` bigint NOT NULL AUTO_INCREMENT COMMENT '供应商ID',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`supplier_shop_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '供应商店铺名称',
`intro` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '供应商简介',
`notice_mobile` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '接收短信号码',
`supplier_logo` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '供应商logo(可修改)',
`mobile_background_pic` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '供应商移动端背景图',
`pc_background_pic` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '供应商pc背景图',
`supplier_status` tinyint NOT NULL COMMENT '供应商状态(-1:已删除 0: 停业中 1:营业中 2:平台下线 3:开店待审核 4:开店申请中 5:上线待审核)',
`type` tinyint DEFAULT NULL COMMENT '供应商类型1自营店 2普通店',
`is_preferred` tinyint DEFAULT '0' COMMENT '是否优选好店 1.是 0.不是',
`supplier_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '供应商名称',
`contact_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '联系人',
`contact_phone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '联系方式',
`contract_start_time` datetime DEFAULT NULL COMMENT '签约起始时间',
`contract_end_time` datetime DEFAULT NULL COMMENT '签约终止时间',
`is_create_member` tinyint NOT NULL DEFAULT '0' COMMENT '是否在通联创建了企业会员 0否1是',
`is_bind_phone` tinyint NOT NULL DEFAULT '0' COMMENT '是否绑定了手机号 0否1是',
`company_info_process_status` tinyint NOT NULL DEFAULT '0' COMMENT '企业信息审核状态 0.未提交 1.待审核 2.审核成功 3.审核失败',
`id_card_collect_process_status` tinyint NOT NULL DEFAULT '0' COMMENT '影印件采集审核状态 0.未上传 1.待审核 2.只有工商认证通过 3.只有法人信息通过 4.均审核通过',
`allinpay_supplier_status` tinyint NOT NULL DEFAULT '0' COMMENT '通联供应商状态 0未开通 1营业中 2平台下线 3上线待审核 4开店待审核',
`company_acct_protocol_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '企业账户提现协议编号',
`legal_acct_protocol_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '法人账户提现协议编号',
PRIMARY KEY (`supplier_id`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='供应商详情';
/*Table structure for table `supplier_extension` */
DROP TABLE IF EXISTS `supplier_extension`;
CREATE TABLE `supplier_extension` (
`supplier_extension_id` bigint NOT NULL AUTO_INCREMENT,
`supplier_id` bigint NOT NULL COMMENT '供应商ID',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`sale_num` int DEFAULT '0' COMMENT '供应商商品总销量',
PRIMARY KEY (`supplier_extension_id`),
KEY `idx_supplier_id` (`supplier_id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='供应商扩张信息';
/*Table structure for table `supplier_refund_addr` */
DROP TABLE IF EXISTS `supplier_refund_addr`;
CREATE TABLE `supplier_refund_addr` (
`supplier_refund_addr_id` bigint NOT NULL AUTO_INCREMENT COMMENT '供应商退货地址id',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '建立时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`supplier_id` bigint NOT NULL COMMENT '供应商ID',
`mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '手机',
`is_default` tinyint NOT NULL COMMENT '默认地址 1:是 0:不是',
`consignee` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '收货人',
`province_id` bigint DEFAULT NULL COMMENT '省ID',
`province` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '省',
`city_id` bigint DEFAULT NULL COMMENT '城市ID',
`city` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '城市',
`area_id` bigint DEFAULT NULL COMMENT '区ID',
`area` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '区',
`addr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '地址',
`post_code` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '邮编',
`lng` decimal(12,6) DEFAULT NULL COMMENT '经度',
`lat` decimal(12,6) DEFAULT NULL COMMENT '纬度',
PRIMARY KEY (`supplier_refund_addr_id`),
KEY `idx_supplier_id` (`supplier_id`)
) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='供应商退货地址';
/*Table structure for table `supplier_user` */
DROP TABLE IF EXISTS `supplier_user`;
CREATE TABLE `supplier_user` (
`supplier_user_id` bigint unsigned NOT NULL COMMENT '供应商用户id',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`supplier_id` bigint DEFAULT NULL COMMENT '关联供应商ID(-1代表还没有申请创建供应商)',
`nick_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '昵称',
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '员工编号',
`phone_num` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '联系方式',
`has_account` tinyint DEFAULT NULL COMMENT '是否已经设置账号 0:未设置 1:已设置',
PRIMARY KEY (`supplier_user_id`),
KEY `idx_supplierid` (`supplier_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='供应商用户';
/*Table structure for table `supplier_wallet` */
DROP TABLE IF EXISTS `supplier_wallet`;
CREATE TABLE `supplier_wallet` (
`supplier_wallet_id` bigint NOT NULL AUTO_INCREMENT COMMENT '供应商钱包id',
`pay_sys_type` tinyint NOT NULL DEFAULT '0' COMMENT '支付系统类型 0默认1通联支付',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`supplier_id` bigint DEFAULT NULL COMMENT '供应商ID',
`unsettled_amount` bigint DEFAULT NULL COMMENT '未结算金额（用户支付）',
`settled_amount` bigint DEFAULT NULL COMMENT '已结算金额（用户确认收货后，可以提现）',
`freeze_amount` bigint DEFAULT NULL COMMENT '冻结金额（用户确认收货）',
`total_settled_amount` bigint DEFAULT NULL COMMENT '累积结算金额',
`version` bigint DEFAULT NULL COMMENT '乐观锁',
PRIMARY KEY (`supplier_wallet_id`),
UNIQUE KEY `uk_supplier_id` (`supplier_id`,`pay_sys_type`)
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='供应商钱包信息';
/*Table structure for table `supplier_withdraw_cash` */
DROP TABLE IF EXISTS `supplier_withdraw_cash`;
CREATE TABLE `supplier_withdraw_cash` (
`cash_id` bigint NOT NULL AUTO_INCREMENT COMMENT '提现id',
`pay_sys_type` tinyint NOT NULL DEFAULT '0' COMMENT '支付系统类型 0默认1通联支付',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`supplier_id` bigint DEFAULT NULL COMMENT '供应商ID',
`auditor_id` bigint DEFAULT NULL COMMENT '审核人id',
`amount` bigint DEFAULT NULL COMMENT '提现金额',
`auditing_time` datetime DEFAULT NULL COMMENT '审核时间',
`status` tinyint DEFAULT NULL COMMENT '状态(0:未审核、1:已通过 -1:未通过 2:发放成功 3:发放失败)',
`remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '平台备注',
`supplier_remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '供应商备注',
`paying_account` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '付款户名',
`paying_card_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '汇款账户',
`paying_time` datetime DEFAULT NULL COMMENT '汇款时间',
`supplier_bank_card_id` bigint DEFAULT NULL COMMENT '收款银行卡id',
`allinpay_status` tinyint DEFAULT NULL COMMENT '通联提现状态 0.待支付 1.申请成功(还没确认) 2.提现成功 3.提现失败',
`biz_order_no` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '通联提现订单号',
`pay_fail_message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '通联提现失败原因',
PRIMARY KEY (`cash_id`),
KEY `idx_supplier_id` (`supplier_id`),
KEY `idx_auditor_id` (`auditor_id`),
KEY `idx_biz_order_no` (`biz_order_no`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='供应商提现申请信息';
/*Table structure for table `leaf_alloc` */
CREATE TABLE IF NOT EXISTS `leaf_alloc` (
`biz_tag` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '区分业务',
`max_id` bigint unsigned NOT NULL DEFAULT '1' COMMENT '该biz_tag目前所被分配的ID号段的最大值',
`step` int NOT NULL COMMENT '每次分配的号段长度',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`description` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '描述',
PRIMARY KEY (`biz_tag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*Data for the table `leaf_alloc` */
insert into `leaf_alloc` (`biz_tag`, `max_id`, `step`, `description`) values
('tmerclub-authorization','1','1000','sys_access_key表的id'),
('tmerclub-multishop-user','1','1000','shop_user表的id'),
('tmerclub-platform-user','1','1000','sys_user表的id'),
('tmerclub-purchase-amount-log','1','1000','采购金额日志id'),
('tmerclub-shop-wallet-log','1','1000','MongoDB中shopWalletLog表的钱包日志id'),
('tmerclub-supplier-user','1','1000','supplier_user表的id');
/*Table structure for table `undo_log` */
DROP TABLE IF EXISTS `undo_log`;
CREATE TABLE `undo_log` (
`id` bigint NOT NULL AUTO_INCREMENT,
`branch_id` bigint NOT NULL,
`xid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`context` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`rollback_info` longblob NOT NULL,
`log_status` int NOT NULL,
`log_created` datetime NOT NULL,
`log_modified` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `ux_undo_log` (`xid`,`branch_id`)
) ENGINE=InnoDB AUTO_INCREMENT=622 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*Data for the table `undo_log` */
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
