-- --------------- v1.5.6 --------------------------------
-- 修改字段
ALTER TABLE bank_three_elements_request_rec MODIFY COLUMN result_state tinyint(1) NOT NULL COMMENT '返回值为 0 : 一致 返回值为 1 : 不一致 返回值为 2:卡状态异常';
-- 三要素请求记录表
CREATE TABLE `bank_three_elements_request_rec` (
`no_` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(128) NOT NULL COMMENT 'id',
`name` varchar(32) NOT NULL COMMENT '姓名',
`id_card_num` varchar(32) NOT NULL COMMENT '身份证号码',
`bank_card_num` varchar(32) NOT NULL COMMENT '银行卡号',
`response_code` varchar(16) NOT NULL COMMENT '请求返回错误码 200正常 200以上 错误',
`request_id` varchar(32) DEFAULT NULL COMMENT '请求ID',
`result_state` tinyint(1) DEFAULT NULL COMMENT '返回值为 0 : 一致 返回值为 1 : 不一致 返回值为 2:卡状态异常',
`result_msg` varchar(128) DEFAULT NULL COMMENT '错误码为200以上时会有',
`is_available` tinyint(1) unsigned NOT NULL DEFAULT '1',
`creation_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE KEY `uk_bank_account_id` (`id`) USING BTREE,
UNIQUE KEY `uk_three_elements` (`name`,`id_card_num`,`bank_card_num`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
----------------- v1.5.5 申请回单 -----------------
-- 申请回单批次
CREATE TABLE `statement_receipt_batch` (
`no_` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id` varchar(128) NOT NULL,
`app_code` varchar(256) DEFAULT NULL COMMENT '请求使用的App_code',
`pay_acct_type` smallint(5) unsigned NOT NULL COMMENT '收款账户类型',
`status` smallint(5) unsigned NOT NULL COMMENT '回执批次状态(待上传, 全部伤处, 部分上传)',
`stm_count` int(10) unsigned NOT NULL COMMENT '回执批次流水条数',
`stm_amount` decimal(11,2) unsigned NOT NULL COMMENT '回执批次流水总金额',
`apply_time` int(10) unsigned NOT NULL COMMENT '申请时间',
`notify_url` varchar(256) DEFAULT NULL COMMENT '回调地址',
`remark` varchar(256) DEFAULT NULL COMMENT '备注',
`is_available` tinyint(1) NOT NULL DEFAULT '1',
`creation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '自动更新最新修改时间',
`source` varchar(128) DEFAULT NULL COMMENT '批次来源',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE KEY `uk_bat_id` (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- 申请回单记录
CREATE TABLE `statement_receipt_rec` (
`no_` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id` varchar(100) NOT NULL COMMENT '发放回单记录ID',
`bat_id` varchar(100) NOT NULL COMMENT '发放流水ID',
`statement_id` varchar(100) NOT NULL COMMENT '发放流水ID',
`out_stm_id` varchar(100) NOT NULL COMMENT '第三方提现记录ID',
`is_need_input` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否需要上传图片',
`is_available` tinyint(1) NOT NULL DEFAULT '1',
`creation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '自动更新最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE KEY `uk_alipay_stm_bill_ereceipt_id` (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- 发放流水回单文件地址关系记录表
CREATE TABLE `statement_receipt_image_path_relation` (
`no_` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id` varchar(100) NOT NULL COMMENT '发放回单地址关系记录ID',
`receipt_id` varchar(100) NOT NULL COMMENT '发放回单记录ID',
`md5_value` varchar(100) NOT NULL COMMENT '第三方提现记录ID',
`is_available` tinyint(1) NOT NULL DEFAULT '1',
`creation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '自动更新最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE KEY `uk_alipay_stm_bill_ereceipt_id` (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- 发放流水回单文件地址关系记录表
CREATE TABLE `image_file_path` (
`no_` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id` varchar(100) NOT NULL COMMENT '文件的MD5值',
`file_domain` varchar(256) NOT NULL COMMENT '文件域名',
`file_path` varchar(256) NOT NULL COMMENT '文件地址',
`file_name` varchar(256) NOT NULL COMMENT '文件名称',
`is_available` tinyint(1) NOT NULL DEFAULT '1',
`creation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '自动更新最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE KEY `uk_alipay_stm_bill_ereceipt_id` (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- --------------- v1.5.4 自动获取回单 --------------------------------
-- 自动获取支付流水回单记录
CREATE TABLE `alipay_stm_bill_ereceipt` (
`no_` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id` varchar(100) NOT NULL COMMENT '回单记录ID',
`pay_stm_id` varchar(100) NOT NULL COMMENT '支付宝付款流水号',
`file_domain` varchar(256) NOT NULL COMMENT '文件域名',
`file_path` varchar(256) NOT NULL COMMENT '文件路径',
`file_name` varchar(256) NOT NULL COMMENT '文件名称',
`is_available` tinyint(1) NOT NULL DEFAULT '1',
`creation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '自动更新最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE KEY `uk_alipay_stm_bill_ereceipt_id` (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- --------------- v1.5.3 --------------------------------
-- 创建 批次来源 字段
ALTER TABLE `wage_batch` ADD COLUMN `source` varchar(128) DEFAULT NULL COMMENT '批次来源';
-- 创建 APP_NAME 字段
ALTER TABLE `open_account` ADD COLUMN `app_name` varchar(64) NULL COMMENT 'APP NAME';