admin/tmerclub-doc
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
tmerclub-doc/开发环境搭建/db/initDb/tmerclub_admin.sql

1085 lines
348 KiB
MySQL
Raw Permalink Normal View History

初始提交
2025-03-19 15:04:57 +08:00
/*!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 */;
初始提交
2025-03-20 17:43:07 +08:00
CREATE DATABASE /*!32312 IF NOT EXISTS*/`tmerclub_admin` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
初始提交
2025-03-19 15:04:57 +08:00
初始提交
2025-03-20 17:43:07 +08:00
USE `tmerclub_admin`;
初始提交
2025-03-19 15:04:57 +08:00
/*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','<ul style="margin: 0px; padding: 0px; list-style: none; color: #474747; font-family: ''Microsoft Yahei''; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;"><li style="margin: 0px; padding: 16px 44px 16px 24px; border-bottom: 1px dashed #e5e5e5; position: relative; overflow: hidden;"><em style="display: block; width: 18px; height: 18px; border-radius: 50%; background-color: #ff4400; color: #ffffff; font-size: 12px; font-style: normal; text-align: center; line-height: 18px; position: absolute; left: 0px; top: 19px;">1</em><span style="display: block; line-height: 24px;">什么是积分？</span><p style="margin: 0px; padding: 10px 0px 0px; line-height: 24px; position: relative; color: #707070;">积分是商城对用户的一种奖励。用户可通过完善个人资料、登录签到、参加活动等方式获得积分。积分可以在积分商城兑换到商品以及购物时使用。</p></li><li style="margin: 0px; padding: 16px 44px 16px 24px; border-bottom: 1px dashed #e5e5e5; position: relative; overflow: hidden;"><em style="display: block; width: 18px; height: 18px; border-radius: 50%; background-color: #ff4400; color: #ffffff; font-size: 12px; font-style: normal; text-align: center; line-height: 18px; position: absolute; left: 0px; top: 19px;">2</em><span style="display: block; line-height: 24px;">如何获得积分？</span><p style="margin: 0px; padding: 10px 0px 0px; line-height: 24px; position: relative; color: #707070;">1）在首页签到，即可一次性获得100积分。<br />2）参加活动，转发微博或者填写问卷等，即可获得相应奖励积分。<br />3）在商城购买部分物品，即可获得相应积分。</p></li><li style="margin: 0px; padding: 16px 44px 16px 24px; border-bottom: 1px dashed #e5e5e5; position: relative; overflow: hidden;"><em style="display: block; width: 18px; height: 18px; border-radius: 50%; background-color: #ff4400; color: #ffffff; font-size: 12px; font-style: normal; text-align: center; line-height: 18px; position: absolute; left: 0px; top: 19px;">3</em><span style="display: block; line-height: 24px;">积分有有效期吗？</span><p style="margin: 0px; padding: 10px 0px 0px; line-height: 24px; position: relative; color: #707070;">有。若用户连续一年没有登录，则积分自动清零。</p></li><li style="margin: 0px; padding: 16px 44px 16px 24px; border-bottom: none; position: relative; overflow: hidden;"><em style="display: block; width: 18px; height: 18px; border-radius: 50%; background-color: #ff4400; color: #ffffff; font-size: 12px; font-style: normal; text-align: center; line-height: 18px; position: absolute; left: 0px; top: 19px;">4</em><span style="display: block; line-height: 24px;">为什么我完成了任务但是没有得到积分？</span><p style="margin: 0px; padding: 10px 0px 0px; line-height: 24px; position: relative; color: #707070;">&ldquo;广告点击&rdquo;和&ldquo;问卷调查&rdquo;任务都是在完成后即时结算。&ldquo;领码激活&rdquo;任务完成后一般需要3-5个工作日结算，结算完毕才能点击领取任务积分。</p></li></ul>','积分常见问题设置'),
(93,'2020-12-27 21:51:08','2022-01-11 16:19:31','LEVEL_SHOW','<div style="outline: 0px; zoom: 1; margin: 50px auto 0px; padding: 0px; width: 1200px; color: #000000; font-family: -apple-system, system-ui, -apple-system, ''Segoe UI'', Roboto, Ubuntu, Cantarell, ''Noto Sans'', sans-serif, BlinkMacSystemFont, ''Segoe UI'', Roboto, ''Helvetica Neue'', Arial, ''PingFang SC'', ''Hiragino Sans GB'', ''Microsoft YaHei'', sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;"><div style="outline: 0px; zoom: 1; margin: 0px; padding: 0px; display: flex; justify-content: center; align-items: center;"><div style="outline: 0px; zoom: 1; margin: 0px; padding: 0px; width: 44px; height: 10px; background: url(''data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACwAAAAKCAYAAADPcbwqAAABIElEQVQ4jc3UMS+DURgF4KdfKuliYiTSkggzdqmRv2DyA7C2Qwdd+QMmm7lG/QFaoxAJbYSxJksTiRh6JZ+m6n6NwUne4b7n5Jw3dzi5Wq1mUuwuvUXpzh6ms/js4ADr4d3GMS4gPy70t6AUZrCFUnh3cInXWIOAI1SGdpth6qjmkWAVc0Hwglt8RIbMYg+F1G4FRZyiF+mzPeLYNCq4SlLmU2GKWI4MgfLQsV8oBC4WhxGagwTzI4iFDEGlMdxiBp+1GE2SwfA/IJfgeQTxlMGkM4Z7zOBzHaFpJ7hDF+9hurjPENREf8S+H7hYnMRo8gZtcBNmEvQM2qDse601xTcENAyq66emqKORn/DIYfRw/gc+VbSwj42waxn8fgM+AVbSOoOuVy+hAAAAAElFTkSuQmCC'') no-repeat;">&nbsp;</div><div style="outline: 0px; zoom: 1; margin: 0px 20px; padding: 0px; font-size: 18px; font-weight: 600;">会员成长体系</div><div style="outline: 0px; zoom: 1; margin: 0px; padding: 0px; width: 44px; height: 10px; background: url(''data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACwAAAAKCAYAAADPcbwqAAABIElEQVQ4jc3UMS+DURgF4KdfKuliYiTSkggzdqmRv2DyA7C2Qwdd+QMmm7lG/QFaoxAJbYSxJksTiRh6JZ+m6n6NwUne4b7n5Jw3dzi5Wq1mUuwuvUXpzh6ms/js4ADr4d3GMS4gPy70t6AUZrCFUnh3cInXWIOAI1SGdpth6qjmkWAVc0Hwglt8RIbMYg+F1G4FRZyiF+mzPeLYNCq4SlLmU2GKWI4MgfLQsV8oBC4WhxGagwTzI4iFDEGlMdxiBp+1GE2SwfA/IJfgeQTxlMGkM4Z7zOBzHaFpJ7hDF+9hurjPENREf8S+H7hYnMRo8gZtcBNmEvQM2qDse601xTcENAyq66emqKORn/DIYfRw/gc+VbSwj42waxn8fgM+AVbSOoOuVy+hAAAAAElFTkSuQmCC'') no-repeat; transform: rotate(180deg);">&nbsp;</div></div><div style="outline: 0px; zoom: 1; margin: 40px auto; padding: 50px 40px 40px; background: #f9f9f9; display: flex; justify-content: center; align-items: flex-end;"><div style="outline: 0px; zoom: 1; margin: 0px 80px 0px 0px; padding: 0px; width: 100px; position: relative;"><div style="outline: 0px; zoom: 1; margin: 0px 0px 10px; padding: 0px; color: #999999; line-height: 18px;">注册成为大众会员<br style="outline: 0px; zoom: 1;" />可购买黄金VIP</div><div style="outline: 0px; zoom: 1; margin: 0px; padding: 0px; position: relative; width: 100px; height: 40px; background: #dedede;">&nbsp;</div><div style="outline: 0px; zoom: 1; margin: 10px 0px 0px; padding: 0px; text-align: center; font-size: 14px; font-weight: 600; height: 20px;">大众会员</div></div><div style="outline: 0px; zoom: 1; margin: 0px 80px 0px 0px; padding: 0px; width: 100px; position: relative;"><div style="outline: 0px; zoom: 1; margin: 0px 0px 10px; padding: 0px; color: #999999; line-height: 18px;">成长值&ge;200达成<br style="outline: 0px; zoom: 1;" />可购买铂金VIP</div><div style="outline: 0px; zoom: 1; margin: 0px; padding: 0px; position: relative; width: 100px; height: 120px; background: #c9b485;">&nbsp;</div><div style="outline: 0px; zoom: 1; margin: 10px 0px 0px; padding: 0px; text-align: center; font-size: 14px; font-weight: 600; height: 20px;">黄金VIP</div></div><div style="outline: 0px; zoom: 1; margin: 0px 80px 0px 0px; padding: 0px; width: 100px; position: relative;"><div style="outline: 0px; zoom: 1; margin: 0px 0px 10px; padding: 0px; color: #999999; line-height: 18px;">成长值&ge;300达成<br style="outline: 0px; zoom: 1;" />可购买钻石VIP</div><div style="outline: 0px; zoom: 1; margin: 0px; padding: 0px; position: relative; width: 100px; height: 200p
(94,'2020-12-30 08:19:16','2021-02-22 10:00:53','ALIPAY_CONFIG','{\"appId\":\"xxxx\",\"appCertContent\":\"\",\"alipayCertContent\":\"\",\"alipayRootCertContent\":\"\",\"appPrivateKey\":\"xxxxxx\"}','支付宝支付配置'),
(95,'2021-01-14 11:09:20','2021-06-21 10:59:29','ALIDAYU_CONFIG','{\"accessKeyId\":\"xxxx\",\"accessKeySecret\":\"xxxx\",\"signName\":\"xxxx\"}','阿里短信服务平台'),
(96,'2021-04-12 09:48:38','2022-01-11 16:21:09','MEMBER_GROWTH_DESCRIPTION','<div style=\"outline: 0px; zoom: 1; margin: 0px; padding: 0px; display: flex; justify-content: center; align-items: center;\">\n<div style=\"outline: 0px; zoom: 1; margin: 0px; padding: 0px; width: 44px; height: 10px; background: url(\'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACwAAAAKCAYAAADPcbwqAAABIElEQVQ4jc3UMS+DURgF4KdfKuliYiTSkggzdqmRv2DyA7C2Qwdd+QMmm7lG/QFaoxAJbYSxJksTiRh6JZ+m6n6NwUne4b7n5Jw3dzi5Wq1mUuwuvUXpzh6ms/js4ADr4d3GMS4gPy70t6AUZrCFUnh3cInXWIOAI1SGdpth6qjmkWAVc0Hwglt8RIbMYg+F1G4FRZyiF+mzPeLYNCq4SlLmU2GKWI4MgfLQsV8oBC4WhxGagwTzI4iFDEGlMdxiBp+1GE2SwfA/IJfgeQTxlMGkM4Z7zOBzHaFpJ7hDF+9hurjPENREf8S+H7hYnMRo8gZtcBNmEvQM2qDse601xTcENAyq66emqKORn/DIYfRw/gc+VbSwj42waxn8fgM+AVbSOoOuVy+hAAAAAElFTkSuQmCC\') no-repeat;\">&nbsp;</div>\n<div style=\"outline: 0px; zoom: 1; margin: 0px 20px; padding: 0px; font-size: 18px; font-weight: 600;\">会员成长体系</div>\n<div style=\"outline: 0px; zoom: 1; margin: 0px; padding: 0px; width: 44px; height: 10px; background: url(\'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACwAAAAKCAYAAADPcbwqAAABIElEQVQ4jc3UMS+DURgF4KdfKuliYiTSkggzdqmRv2DyA7C2Qwdd+QMmm7lG/QFaoxAJbYSxJksTiRh6JZ+m6n6NwUne4b7n5Jw3dzi5Wq1mUuwuvUXpzh6ms/js4ADr4d3GMS4gPy70t6AUZrCFUnh3cInXWIOAI1SGdpth6qjmkWAVc0Hwglt8RIbMYg+F1G4FRZyiF+mzPeLYNCq4SlLmU2GKWI4MgfLQsV8oBC4WhxGagwTzI4iFDEGlMdxiBp+1GE2SwfA/IJfgeQTxlMGkM4Z7zOBzHaFpJ7hDF+9hurjPENREf8S+H7hYnMRo8gZtcBNmEvQM2qDse601xTcENAyq66emqKORn/DIYfRw/gc+VbSwj42waxn8fgM+AVbSOoOuVy+hAAAAAElFTkSuQmCC\') no-repeat; transform: rotate(180deg);\">&nbsp;</div>\n</div>\n<div style=\"outline: 0px; zoom: 1; margin: 40px auto; padding: 50px 40px 40px; background: #f9f9f9; display: flex; justify-content: center; align-items: flex-end;\">\n<div style=\"outline: 0px; zoom: 1; margin: 0px 80px 0px 0px; padding: 0px; width: 100px; position: relative;\">\n<div style=\"outline: 0px; zoom: 1; margin: 0px 0px 10px; padding: 0px; color: #999999; line-height: 18px;\">注册成为大众会员<br style=\"outline: 0px; zoom: 1;\" />可购买黄金VIP</div>\n<div style=\"outline: 0px; zoom: 1; margin: 0px; padding: 0px; position: relative; width: 100px; height: 40px; background: #dedede;\">&nbsp;</div>\n<div style=\"outline: 0px; zoom: 1; margin: 10px 0px 0px; padding: 0px; text-align: center; font-size: 14px; font-weight: 600; height: 20px;\">大众会员</div>\n</div>\n<div style=\"outline: 0px; zoom: 1; margin: 0px 80px 0px 0px; padding: 0px; width: 100px; position: relative;\">\n<div style=\"outline: 0px; zoom: 1; margin: 0px 0px 10px; padding: 0px; color: #999999; line-height: 18px;\">成长值&ge;200达成<br style=\"outline: 0px; zoom: 1;\" />可购买铂金VIP</div>\n<div style=\"outline: 0px; zoom: 1; margin: 0px; padding: 0px; position: relative; width: 100px; height: 120px; background: #c9b485;\">&nbsp;</div>\n<div style=\"outline: 0px; zoom: 1; margin: 10px 0px 0px; padding: 0px; text-align: center; font-size: 14px; font-weight: 600; height: 20px;\">黄金VIP</div>\n</div>\n<div style=\"outline: 0px; zoom: 1; margin: 0px 80px 0px 0px; padding: 0px; width: 100px; position: relative;\">\n<div style=\"outline: 0px; zoom: 1; margin: 0px 0px 10px; padding: 0px; color: #999999; line-height: 18px;\">成长值&ge;300达成<br style=\"outline: 0px; zoom: 1;\" />可购买钻石VIP</div>\n<div style=\"outline: 0px; zoom: 1; margin: 0px; padding: 0px; position: relative; width: 100px; height: 200px; background: #b79271;\">&nbsp;</div>\n<div style=\"outline: 0px; zoom: 1; margin: 10px 0px 0px; padding: 0px; text-align: center; font-size: 14px; font-weight: 600; height: 20px;\">白金VIP</div>\n</div>\n<div style=\"outline: 0px; zoom: 1; margin: 0px; padding: 0px; width: 100px; position: relative;\">\n<div style=\"outline: 0px; zoom: 1; margin: 0px 0px 10px; padding: 0px; color: #999999; line-height: 18px;\">成长值&ge;500达成<br style=\"outline: 0px; zoom: 1;\" />可购买黑金VIP</div>\n<div style=\"outline: 0px; zoom: 1; margin: 0px; padding: 0px; position: relative; width: 100px; height: 280px; background: #6d543
(97,'2021-04-20 14:32:55','2021-07-09 16:24:17','SECKILL_TIME_CONFIG','{\"seckillTimeList\":[8,10,11,14,15,16,17,18,19,20,21,22],\"imgUrls\":\"\"}','秒杀场次选择'),
(98,'2021-05-11 16:08:08','2021-05-12 11:20:49','SHOP_PROTOCOL_CN','<p style=\"text-align: left;\">商家入驻协议<br />一，服务条款的确认及接受</p>\n<p>1，云掌柜客户端软件（以下称&ldquo;本软件&rdquo;）组成电子服务的所有权和运作权归属于&ldquo;xxx&rdquo;所有，本软件提供的服务将完全按照其发布的服务条款和操作规则严格执行。您确认所有服务条款并完成注册程序时，本协议在您与本软件间成立并发生法律效力，同时您成为本软件正式用户。</p>\n<p>2，根据国家法律法规变化和本软件运营需要，xxx有权对本协议条款及相关规则不时地进行修改，修改后的内容一旦以任何形式公布在本软件上即强制执行，并取代了相关内容，您应不时关注本软件公告，提示信息及协议，规则等相关内容的移动。您知悉并确认，如您不同意更新后的内容，应立即停止使用本软件；如您继续使用本软件，即视为知悉移动内容并同意接受。</p>\n<p>二，服务需知</p>\n<p>1，本软件运用自身开发的操作系统通过国际互联网络为用户提供购买商品等服务。使用本软件，您必须：</p>\n<p>（1）自行配备上网的所需设备，包括个人手机，平板电脑，变频器，路由器等；</p>\n<p>（2）自行负担个人上网所支付的有关服务有关的电话费用，网络费用等；</p>\n<p>（3）选择与所安装终端设备相匹配的软件版本，包括但不限于iOS，Android，iPad，Windows Phone等多个xxx发布的应用版本。</p>\n<p>2，基于本软件所提供的网络服务的本质，您确认并同意：</p>\n<p>（1）提供的注册资料真实，准确，完整，合法有效，注册资料如有变动的，应及时更新；</p>\n<p>（2）如果您提供的注册资料不合法，不真实，不准确，不详尽的，您需要承担因此引起的相应责任和后果，并且xxx保留终止您使用本软件的服务的权利。</p>\n<p>三，订单</p>\n<p>1，使用本软件下订单，您应先购买相关商品的权利能力和行为能力，如果您在18周岁以下，您需要在父母或监护人的监护参与下才能使用本软件。在下订单的同时，即视为您满足上述条件，逐步您在订单中提供的所有信息的真实性负责。</p>\n<p>2，在您下订单时，请您仔细确认所购商品的名称，价格，数量，型号，规格，尺寸，联系地址，电话，收货人等信息。人的行为和含义表示您的行为和含义表示，您应对收货人的行为及含义表示的法律后果承担连带责任。</p>\n<p>3，您理解并同意：本软件上销售商展示的商品和价格等信息可能要约邀请，您下单时应填写您希望购买的商品数量，价款及支付方式，收货人，联系方式，收据货物地址（合同预定地点），合同清单方式等内容；系统生成的订单信息是计算机信息系统根据您填充的内容自动生成的数据，仅是您向销售商发出的合同要约；销售商收到您的订单信息后，只有在销售商将您在订单中订购的商品从仓库实际直接向您发出时（以商品出库为标志），方认为您与销售商之间就实际直接向您发出的商品建立了合同关系；如果您在一份订单里订购了多种商品和销售商只给您发出了部分商品时，您与销售商之间仅就实际直接向您发出的商品建立了合同关系；只有在销售商实际直接向您发出了订单中订购的其他商品时，您和销售商之间就订单中其他已实际直接向您发出的商品才建立了合同关系。对于电子书，数字音乐，在线手机充值等数字化商品，您下单并支付货款后合同即成立。</p>\n<p>4，尽管销售商做出最大的努力，但由于市场变化以及各种以合理的商业努力而非控制因素的影响，本软件无法避免您提交的订单信息中的商品出现缺货情况；如您下单所购买的商品发
(99,'2021-05-11 16:08:08','2021-05-12 11:04:32','SHOP_PROTOCOL_EN','<p>Merchant Onboarding Agreement</p>\n<ol>\n<li>Confirmation and acceptance of the Terms of Service</li>\n</ol>\n<p>&nbsp;</p>\n<p>1, 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.</p>\n<p>&nbsp;</p>\n<p>2, 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.</p>\n<p>&nbsp;</p>\n<p>Two, service needs to know</p>\n<p>&nbsp;</p>\n<p>1, 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.</p>\n<p>&nbsp;</p>\n<p>(1) Equip yourself with the necessary equipment for Internet access, including personal cell phones, tablets, inverters, routers, etc..</p>\n<p>&nbsp;</p>\n<p>(2) To bear their own telephone charges, network charges, etc. related to the services they pay for when accessing the Internet.</p>\n<p>&nbsp;</p>\n<p>(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.</p>\n<p>&nbsp;</p>\n<ol start=\"2\">\n<li>Based on the nature of the network services provided by the Software, you acknowledge and agree that.</li>\n</ol>\n<p>&nbsp;</p>\n<p>(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.</p>\n<p>&nbsp;</p>\n<p>(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.</p>\n<p>&nbsp;</p>\n<p>Three, orders</p>\n<p>&nbsp;</p>\n<p>1, 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.</p>\n<p>&nbsp;</p>\n<p>2, 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.</p>\n<p>&nbsp;</p>\n<p>3, 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 loca
(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\":\"<h3 style=\\\"text-align: center, background: #ffffff, margin: 15.0000pt 10.5000pt 7.5000pt 10.5000pt,\\\" align=\\\"center\\\" data-mce-fragment=\\\"1\\\"><strong data-mce-fragment=\\\"1\\\"><span style=\\\"mso-spacerun: \'yes\', font-family: 微软雅黑, color: #333333, font-weight: bold, font-size: 20.0000pt, mso-font-kerning: 1.0000pt,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"font-family: 微软雅黑,\\\" data-mce-fragment=\\\"1\\\">隐私政策</span></span></strong></h3>\\n<p class=\\\"p\\\" style=\\\"margin-top: 0.0000pt, margin-bottom: 7.5000pt, text-indent: 24.0000pt, background: #ffffff,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"mso-spacerun: \'yes\', font-family: 微软雅黑, color: #333333, font-size: 10.0000pt, mso-font-kerning: 0.0000pt,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"font-family: 微软雅黑,\\\" data-mce-fragment=\\\"1\\\">&nbsp,</span></span></p>\\n<p class=\\\"p\\\" style=\\\"margin-top: 0.0000pt, margin-bottom: 7.5000pt, text-indent: 24.0000pt, background: #ffffff,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"mso-spacerun: \'yes\', font-family: 微软雅黑, color: #333333, font-size: 10.0000pt, mso-font-kerning: 0.0000pt,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"font-family: 微软雅黑,\\\" data-mce-fragment=\\\"1\\\">本站（以下亦称</span><span style=\\\"font-family: 微软雅黑,\\\" data-mce-fragment=\\\"1\\\">&ldquo,我们&rdquo,）深知个人信息对您的重要性，我们尊重并保护所有使用我们平台服务的用户的个人信息，并会尽全力保护您的个人信息安全可靠。我们致力于维持您对我们的信任，恪守以下原则，保护您的个人信息：权责一致原则、目的明确原则、选择同意原则、最少够用原则、确保安全原则、主体参与原则、公开透明原则等。同时，我们承诺，我们将按业界成熟的安全标准，采取相应的安全保护措施来保护您的个人信息。请在使用我们的产品（或服务）前，仔细阅读并了解本《我们隐私政策》（下称&ldquo,本隐私政策&rdquo,）。</span></span></p>\\n<p class=\\\"p\\\" style=\\\"margin-top: 0.0000pt, margin-bottom: 7.5000pt, text-indent: 24.0000pt, background: #ffffff,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"mso-spacerun: \'yes\', font-family: 微软雅黑, color: #333333, font-size: 10.0000pt, mso-font-kerning: 0.0000pt,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"font-family: 微软雅黑,\\\" data-mce-fragment=\\\"1\\\">&nbsp,</span></span></p>\\n<p class=\\\"p\\\" style=\\\"margin-top: 0.0000pt, margin-bottom: 7.5000pt, background: #ffffff,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"mso-spacerun: \'yes\', font-family: 微软雅黑, color: #333333, font-size: 10.0000pt, mso-font-kerning: 0.0000pt,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"font-family: 微软雅黑,\\\" data-mce-fragment=\\\"1\\\">一、我们处理个人信息的法律依据</span></span></p>\\n<p class=\\\"p\\\" style=\\\"margin-top: 0.0000pt, margin-bottom: 7.5000pt, text-indent: 24.0000pt, background: #ffffff,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"mso-spacerun: \'yes\', font-family: 微软雅黑, color: #333333, font-size: 10.0000pt, mso-font-kerning: 0.0000pt,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"font-family: 微软雅黑,\\\" data-mce-fragment=\\\"1\\\">本隐私政策制定的法律依据为《中华人民共和国消费者权益保护法》、《中华人民共和国网络安全法》、《中华人民共和国电子商务法》、《信息安全技术个人信息安全规范》以及其他涉及公民个人信息的相关法律法规。通常，我们会基于本隐私政策提示的功能收集您的个人信息。某些情况下，如果涉及其他信息的收集我们会单独向您出示个人信息保护说明条款。</span></span></p>\\n<p class=\\\"p\\\" style=\\\"margin-top: 0.0000pt, margin-bottom: 7.5000pt, background: #ffffff,\\\" data-mce-fragment=\\\"
(105,'2021-05-18 20:28:09','2021-05-18 20:28:09','PRIVACY_PROTOCOL_EN','{\"content\":\"<p class=\\\"MsoNormal\\\" style=\\\"mso-para-margin-top: 0.0000gd, mso-para-margin-bottom: 0.0000gd, page-break-before: always, text-align: left,\\\" data-mce-fragment=\\\"1\\\"><strong style=\\\"mso-bidi-font-weight: normal,\\\" data-mce-fragment=\\\"1\\\"><span class=\\\"15\\\" style=\\\"mso-spacerun: \'yes\', font-family: 宋体, mso-ansi-font-weight: bold, font-size: 26.0000pt, mso-font-kerning: 22.0000pt,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"font-family: Times New Roman,\\\" data-mce-fragment=\\\"1\\\">Privacy Policy</span></span></strong><strong style=\\\"mso-bidi-font-weight: normal,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"mso-spacerun: \'yes\', font-family: 微软雅黑, color: #323232, mso-ansi-font-weight: bold, font-size: 20.0000pt, mso-font-kerning: 1.0000pt,\\\" data-mce-fragment=\\\"1\\\">&nbsp,</span></strong></p>\\n<p class=\\\"MsoNormal\\\" style=\\\"mso-para-margin-top: 0.0000gd, mso-para-margin-bottom: 0.0000gd, text-align: left,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"mso-spacerun: \'yes\', font-family: 微软雅黑, color: #323232, font-size: 9.5000pt, mso-font-kerning: 1.0000pt,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"font-family: 微软雅黑,\\\" data-mce-fragment=\\\"1\\\">This 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). </span></span></p>\\n<h2 data-mce-fragment=\\\"1\\\"><strong style=\\\"mso-bidi-font-weight: normal,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"mso-spacerun: \'yes\', font-family: 黑体, mso-ascii-font-family: Arial, mso-hansi-font-family: Arial, mso-bidi-font-family: \'Times New Roman\', mso-ansi-font-weight: bold, font-size: 16.0000pt, mso-font-kerning: 1.0000pt,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"font-family: Arial,\\\" data-mce-fragment=\\\"1\\\">The legal basis on which we process personal information </span></span></strong></h2>\\n<p class=\\\"MsoNormal\\\" style=\\\"mso-para-margin-top: 0.0000gd, mso-para-margin-bottom: 0.0000gd, text-align: left,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"mso-spacerun: \'yes\', font-family: 微软雅黑, color: #323232, font-size: 9.5000pt, mso-font-kerning: 1.0000pt,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"font-family: 微软雅黑,\\\" data-mce-fragment=\\\"1\\\">The 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 </span></span></p>\\n<p class=\\\"MsoNormal\\\" style=\\\"mso-para-margin-top: 0.0000gd, mso-para-margin-bottom: 0.0000gd, page-break-before: always, text-align: left,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"mso-spacerun: \'yes\', font-family: 微软雅黑, color: #323232, font-size: 9.5000pt, mso-font-kerning: 1.0000pt,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"font
(106,'2021-05-18 20:28:09','2021-05-18 20:28:09','SERVICE_PROTOCOL_CN','{\"content\":\"<p class=\\\"MsoNormal\\\" style=\\\"mso-para-margin-right: 0.0000gd, mso-para-margin-left: 0.0000gd, mso-pagination: widow-orphan, text-align: center, mso-outline-level: 2, background: #ffffff, margin: 15.0000pt 10.5000pt 7.5000pt 10.5000pt,\\\" align=\\\"center\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"mso-spacerun: \'yes\', font-family: 微软雅黑, color: #333333, font-size: 24.0000pt, mso-font-kerning: 0.0000pt,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"font-family: 微软雅黑,\\\" data-mce-fragment=\\\"1\\\">服务条款</span></span><span style=\\\"mso-spacerun: \'yes\', font-family: 微软雅黑, color: #333333, font-size: 24.0000pt, mso-font-kerning: 0.0000pt,\\\" data-mce-fragment=\\\"1\\\"><br data-mce-fragment=\\\"1\\\" /></span><span style=\\\"mso-spacerun: \'yes\', font-family: 微软雅黑, color: #333333, font-size: 24.0000pt, mso-font-kerning: 0.0000pt,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"font-family: 微软雅黑,\\\" data-mce-fragment=\\\"1\\\">&nbsp,&nbsp,</span></span></p>\\n<p class=\\\"MsoNormal\\\" style=\\\"margin-right: 0.0000pt, margin-bottom: 7.5000pt, mso-para-margin-right: 0.0000gd, mso-pagination: widow-orphan, text-align: left, background: #ffffff,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"mso-spacerun: \'yes\', font-family: 微软雅黑, color: #333333, font-size: 10.0000pt, mso-font-kerning: 0.0000pt,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"font-family: 微软雅黑,\\\" data-mce-fragment=\\\"1\\\">一、定义</span></span></p>\\n<p class=\\\"MsoNormal\\\" style=\\\"margin-right: 0.0000pt, margin-bottom: 7.5000pt, margin-left: 0.0000pt, mso-para-margin-right: 0.0000gd, mso-para-margin-left: 0.0000gd, text-indent: 24.0000pt, mso-pagination: widow-orphan, text-align: left, background: #ffffff,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"mso-spacerun: \'yes\', font-family: 微软雅黑, color: #333333, font-size: 10.0000pt, mso-font-kerning: 0.0000pt,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"font-family: 微软雅黑,\\\" data-mce-fragment=\\\"1\\\">平台，是指您当前所浏览的网站平台。</span></span></p>\\n<p class=\\\"MsoNormal\\\" style=\\\"margin-right: 0.0000pt, margin-bottom: 7.5000pt, margin-left: 0.0000pt, mso-para-margin-right: 0.0000gd, mso-para-margin-left: 0.0000gd, text-indent: 24.0000pt, mso-pagination: widow-orphan, text-align: left, background: #ffffff,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"mso-spacerun: \'yes\', font-family: 微软雅黑, color: #333333, font-size: 10.0000pt, mso-font-kerning: 0.0000pt,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"font-family: 微软雅黑,\\\" data-mce-fragment=\\\"1\\\">用户，包含注册用户和非注册用户，以下亦称为</span><span style=\\\"font-family: 微软雅黑,\\\" data-mce-fragment=\\\"1\\\">&ldquo,您&rdquo,。注册用户是指通过我们平台完成全部注册程序后，使用我们平台服务或我们网站资料的用户。非注册用户是指未进行注册、直接登录我们平台或通过其他网站进入我们平台直接或间接地使用我们平台服务或我们网站资料的用户。</span></span></p>\\n<p class=\\\"MsoNormal\\\" style=\\\"margin-right: 0.0000pt, margin-bottom: 7.5000pt, margin-left: 0.0000pt, mso-para-margin-right: 0.0000gd, mso-para-margin-left: 0.0000gd, text-indent: 24.0000pt, mso-pagination: widow-orphan, text-align: left, background: #ffffff,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"mso-spacerun: \'yes\', font-family: 微软雅黑, color: #333333, font-size: 10.0000pt, mso-font-kerning: 0.0000pt,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"font-family: 微软雅黑,\\\" data-mce-fragment=\\\"1\\\">协议方，本协议中协议双方合称</span><span style=\\\"font-family: 微软雅黑,\\\" data-mce-fragment=\\\"1\\\">&ldquo,协议方&rdquo,。</span></span></p>\\n<p class=\\\"MsoNormal\\\" style=\\\"margin-right: 0.0000pt, margin-bottom: 7.5000pt, mso-para-margin-right: 0.0000gd, mso-pagination
(107,'2021-05-18 20:28:09','2021-05-18 20:28:09','SERVICE_PROTOCOL_EN','{\"content\":\"<p class=\\\"MsoNormal\\\" style=\\\"mso-para-margin-top: 0.0000gd, mso-para-margin-bottom: 0.0000gd, text-align: left,\\\" data-mce-fragment=\\\"1\\\"><strong style=\\\"mso-bidi-font-weight: normal,\\\" data-mce-fragment=\\\"1\\\"><span class=\\\"16\\\" style=\\\"mso-spacerun: \'yes\', font-family: 宋体, mso-ascii-font-family: \'Times New Roman\', mso-hansi-font-family: \'Times New Roman\', mso-bidi-font-family: \'Times New Roman\', mso-ansi-font-weight: bold, font-size: 26.0000pt, mso-font-kerning: 22.0000pt,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"font-family: Times New Roman,\\\" data-mce-fragment=\\\"1\\\">Terms of service </span></span></strong></p>\\n<h2 data-mce-fragment=\\\"1\\\"><strong style=\\\"mso-bidi-font-weight: normal,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"mso-spacerun: \'yes\', font-family: 黑体, mso-ascii-font-family: Arial, mso-hansi-font-family: Arial, mso-ansi-font-weight: bold, font-size: 16.0000pt, mso-font-kerning: 1.0000pt,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"font-family: Arial,\\\" data-mce-fragment=\\\"1\\\">Definitions </span></span></strong></h2>\\n<p class=\\\"MsoNormal\\\" style=\\\"margin-left: 21.0000pt, mso-para-margin-top: 0.0000gd, mso-para-margin-bottom: 0.0000gd, mso-para-margin-left: 0.0000gd, text-indent: -21.0000pt, mso-char-indent-count: 0.0000, text-align: left, mso-list: l1 level1 lfo1,\\\" data-mce-fragment=\\\"1\\\"><!-- [if !supportLists]--><span style=\\\"font-family: Wingdings, mso-fareast-font-family: 微软雅黑, color: #323232, font-weight: bold, font-size: 9.5000pt, mso-font-kerning: 1.0000pt,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"mso-list: Ignore,\\\" data-mce-fragment=\\\"1\\\">l&nbsp,</span></span><!--[endif]--><strong data-mce-fragment=\\\"1\\\"><span style=\\\"mso-spacerun: \'yes\', font-family: 微软雅黑, color: #323232, font-weight: bold, font-size: 9.5000pt, mso-font-kerning: 1.0000pt,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"font-family: 微软雅黑,\\\" data-mce-fragment=\\\"1\\\">Platform</span></span></strong><span style=\\\"mso-spacerun: \'yes\', font-family: 微软雅黑, color: #323232, font-size: 9.5000pt, mso-font-kerning: 1.0000pt,\\\" data-mce-fragment=\\\"1\\\">&nbsp,<span style=\\\"font-family: 微软雅黑,\\\" data-mce-fragment=\\\"1\\\">refers to the platform of the website you are currently browsing. </span></span></p>\\n<p class=\\\"MsoNormal\\\" style=\\\"margin-left: 21.0000pt, mso-para-margin-top: 0.0000gd, mso-para-margin-bottom: 0.0000gd, mso-para-margin-left: 0.0000gd, text-indent: -21.0000pt, mso-char-indent-count: 0.0000, text-align: left, mso-list: l1 level1 lfo1,\\\" data-mce-fragment=\\\"1\\\"><!-- [if !supportLists]--><span style=\\\"font-family: Wingdings, mso-fareast-font-family: 微软雅黑, color: #323232, font-weight: bold, font-size: 9.5000pt, mso-font-kerning: 1.0000pt,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"mso-list: Ignore,\\\" data-mce-fragment=\\\"1\\\">l&nbsp,</span></span><!--[endif]--><strong data-mce-fragment=\\\"1\\\"><span style=\\\"mso-spacerun: \'yes\', font-family: 微软雅黑, color: #323232, font-weight: bold, font-size: 9.5000pt, mso-font-kerning: 1.0000pt,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"font-family: 微软雅黑,\\\" data-mce-fragment=\\\"1\\\">Users</span></span></strong><span style=\\\"mso-spacerun: \'yes\', font-family: 微软雅黑, color: #323232, font-size: 9.5000pt, mso-font-kerning: 1.0000pt,\\\" data-mce-fragment=\\\"1\\\"><span style=\\\"font-family: 微软雅黑,\\\" data-mce-fragment=\\\"1\\\">, 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 mate
(108,'2021-06-01 19:32:37','2021-06-22 15:12:15','MERCHANT_REGISTER_PROTOCOL_EN','<p>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 c
(109,'2021-06-01 19:32:37','2021-06-02 09:53:14','MERCHANT_REGISTER_PROTOCOL_CN','<p style=\"text-align: center;\"><strong>商家注册协议</strong></p>\n<p>一、服务条款的确认及接受</p>\n<p>1、云掌柜客户端软件（以下称&ldquo;本软件&rdquo;）各项电子服务的所有权和运作权归属于&ldquo;xx&rdquo;所有，本软件提供的服务将完全按照其发布的服务条款和操作规则严格执行。您确认所有服务条款并完成注册程序时，本协议在您与本软件间成立并发生法律效力，同时您成为本软件正式用户。</p>\n<p>2、根据国家法律法规变化及本软件运营需要，xx有权对本协议条款及相关规则不时地进行修改，修改后的内容一旦以任何形式公布在本软件上即生效，并取代此前相关内容，您应不时关注本软件公告、提示信息及协议、规则等相关内容的变动。您知悉并确认，如您不同意更新后的内容，应立即停止使用本软件；如您继续使用本软件，即视为知悉变动内容并同意接受。</p>\n<p>二、服务需知</p>\n<p>1、本软件运用自身开发的操作系统通过国际互联网络为用户提供购买商品等服务。使用本软件，您必须：</p>\n<p>（1）自行配备上网的所需设备，包括个人手机、平板电脑、调制解调器、路由器等；</p>\n<p>（2）自行负担个人上网所支付的与此服务有关的电话费用、网络费用等；</p>\n<p>（3）选择与所安装终端设备相匹配的软件版本，包括但不限于iOS、Android、iPad、Windows Phone等多个xx发布的应用版本。</p>\n<p>2、基于本软件所提供的网络服务的重要性，您确认并同意：</p>\n<p>（1）提供的注册资料真实、准确、完整、合法有效，注册资料如有变动的，应及时更新；</p>\n<p>（2）如果您提供的注册资料不合法、不真实、不准确、不详尽的，您需承担因此引起的相应责任及后果，并且xx保留终止您使用本软件各项服务的权利。</p>\n<p>三、订单</p>\n<p>1、使用本软件下订单，您应具备购买相关商品的权利能力和行为能力，如果您在18周岁以下，您需要在父母或监护人的监护参与下才能使用本软件。在下订单的同时，即视为您满足上述条件，并对您在订单中提供的所有信息的真实性负责。</p>\n<p>2、在您下订单时，请您仔细确认所购商品的名称、价格、数量、型号、规格、尺寸、联系地址、电话、收货人等信息。收货人与您本人不一致的，收货人的行为和意思表示视为您的行为和意思表示，您应对收货人的行为及意思表示的法律后果承担连带责任。</p>\n<p>3、您理解并同意：本软件上销售商展示的商品和价格等信息仅仅是要约邀请，您下单时须填写您希望购买的商品数量、价款及支付方式、收货人、联系方式、收货地址（合同履行地点）、合同履行方式等内容；系统生成的订单信息是计算机信息系统根据您填写的内容自动生成的数据，仅是您向销售商发出的合同要约；销售商收到您的订单信息后，只有在销售商将您在订单中订购的商品从仓库实际直接向您发出时（以商品出库为标志），方视为您与销售商之间就实际直接向您发出的商品建立了合同关系；如果您在一份订单里订购了多种商品并且销售商只给您发出了部分商品时，您与销售商之间仅就实际直接向您发出的商品建立了合同关系；只有在销售商实际直接向您发出了订单中订购的其他商品时，您和销售商之间就订单中其他已实际直接向您发出的商品才成立合同关系。对于电子书、数字音乐、在线手机充值等数字化商品，您下单并支付货款后合同即成立。</p>\n<p>4、尽管销售商做出最大的努力，但由于市场变化及各种以合理商业努力难以控制因素的影响，本软件无法避免您提交<E68F90>
(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
初始提交
2025-03-20 17:43:07 +08:00
('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');
初始提交
2025-03-19 15:04:57 +08:00
/*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 */;
Reference in New Issue Copy Permalink