kmall-haikong/sql/init/merch_pay_cfg.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 海控测试库
 Source Server Type    : MySQL
 Source Server Version : 50651
 Source Host           : 14.29.226.8:3306
 Source Schema         : kmall-haikong

 Target Server Type    : MySQL
 Target Server Version : 50651
 File Encoding         : 65001

 Date: 14/12/2021 17:19:36
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for merch_pay_cfg
-- ----------------------------
DROP TABLE IF EXISTS `merch_pay_cfg`;
CREATE TABLE `merch_pay_cfg`  (
  `pay_cfg_sn` varchar(22) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '支付配置编号',
  `appid` varchar(22) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商户编号,由e码头分配',
  `merch_wx_api_key` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '商户微信支付api密钥',
  `notify_url` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '商户通知回调接口',
  `pay_chnl_flag` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '支付通道标识,weixin:微信，alipay:蚂蚁金服',
  `is_valid` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否有效,0:有效，1:无效',
  `remark` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注',
  `creater_sn` varchar(22) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人编号',
  `create_time` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建时间,yyyy-MM-dd HH:mm:ss',
  `moder_sn` varchar(22) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人编号',
  `mod_time` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改时间,yyyy-MM-dd HH:mm:ss',
  `tstm` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '时间戳',
  PRIMARY KEY (`pay_cfg_sn`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商户支付配置，商户:支付通道，1:n' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of merch_pay_cfg
-- ----------------------------
INSERT INTO `merch_pay_cfg` VALUES ('mpct000000000000000003', 'wxb6b30b1b14ee502a', 'Zx1245uytDLliom12345622222222222', '', 'weixin', '0', '中网小程序', NULL, NULL, NULL, NULL, '2021-12-08 11:45:02');
INSERT INTO `merch_pay_cfg` VALUES ('mpct000000000000000005', '2088821582509154', '6zo20oar6qufb6x41ipli3yma9ju107h', '', 'alipay', '0', '支付宝', NULL, '', NULL, NULL, '2021-12-08 11:45:02');

SET FOREIGN_KEY_CHECKS = 1;