易公会数据库v1.7调整记录
<pre><code class="language-sql">-- --------------- 已上线 ----------------- v1.7.3 -----------------
-- 新增权限
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_INFO_01004', 'EGH-API-FRONT-INFO-01004');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_08010', 'EGH-API-FRONT-TEAM-08010');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WAL_01013', 'EGH-API-FRONT-WAL-01013');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WAL_01014', 'EGH-API-FRONT-WAL-01014');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WAL_01015', 'EGH-API-FRONT-WAL-01015');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_EARNINGS_01007', 'EGH-API-FRONT-EARNINGS-01007');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WALLET_01001', 'EGH-API-FRONT-WALLET-01001');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WALLET_01002', 'EGH-API-FRONT-WALLET-01002');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_MANAGE_05004', 'EGH-API-FRONT-MANAGE-05004');
ALTER TABLE `withdrawl_astrict` ADD COLUMN `min_withdrawl_limit` decimal(13,2) NOT NULL DEFAULT 0 COMMENT '最小提现额度限制';
ALTER TABLE `user` ADD COLUMN `entry_time` int(11) DEFAULT NULL COMMENT '入职时间';
-- 开户行查询
CREATE TABLE `bank_address_request_rec` (
`no_` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`order_no` varchar(128) NOT NULL COMMENT '订单号',
`bank_num` varchar(128) NOT NULL COMMENT '银行卡号',
`bank` varchar(128) NULL COMMENT '银行名称',
`province` varchar(128) NULL COMMENT '开户省',
`city` varchar(128) NULL COMMENT '开户市',
`card_name` varchar(128) NULL COMMENT '卡名称',
`type` varchar(128) NULL COMMENT '卡类型',
`abbreviation` varchar(128) NULL COMMENT '银联支付网关简码',
`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_num` (`bank_num`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- 收益发放记录
CREATE TABLE `view_earnings_grant_bat_grant_rec` (
`no_` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(128) NOT NULL COMMENT '收益发放记录ID',
`plf_biz_id` varchar(128) NOT NULL COMMENT '平台业务ID',
`stl_cycle` tinyint(1) NOT NULL DEFAULT '1' COMMENT '结算模式',
`start_stl_date` int(11) NOT NULL COMMENT '结算开始时间',
`end_stl_date` int(11) NOT NULL COMMENT '结算结束时间',
`grant_amount_sum` decimal(13,2) NOT NULL COMMENT '发放总金额',
`grant_time` int(11) NOT NULL COMMENT '发放时间',
`grant_sucess_amount` decimal(13,2) NOT NULL COMMENT '发放成功金额',
`grant_fail_amount` decimal(13,2) NOT NULL COMMENT '发放失败金额',
`grant_status` tinyint(1) NOT NULL COMMENT '发放结果',
`grant_status_remark` varchar(256) DEFAULT NULL COMMENT '发放结果说明',
`grant_bat_id` varchar(256) DEFAULT NULL COMMENT '发放批次ID',
`is_available` tinyint(1) unsigned 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_view_earnings_grant_bat` (`id`) USING BTREE,
KEY `k_plf_biz_id` (`plf_biz_id`) USING BTREE,
KEY `k_stl_cycle` (`stl_cycle`) USING BTREE,
KEY `k_start_stl_date` (`start_stl_date`) USING BTREE,
KEY `k_end_stl_date` (`end_stl_date`) USING BTREE,
KEY `k_grant_time` (`grant_time`) USING BTREE,
KEY `k_grant_status` (`grant_status`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- --------------- 已上线 ----------------- v1.7.2 -----------------
-- 新增权限
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_04023', 'EGH-API-FRONT-STL-04023');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_06108', 'EGH-API-FRONT-STL-06108');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_06109', 'EGH-API-FRONT-STL-06109');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_06120', 'EGH-API-FRONT-STL-06120');
CREATE TABLE `stl_acct_income_and_stl_data` (
`no_` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(64) NOT NULL COMMENT 'id',
`data_id` varchar(64) NOT NULL COMMENT '结算数据ID stl_stm',
`income_id` varchar(64) NOT NULL COMMENT '钱包收入ID',
`stl_income_id` varchar(64) NOT NULL COMMENT '结算账户收入ID',
`pack_id` varchar(64) NOT NULL COMMENT '手动划款打包批次ID',
`is_available` tinyint(1) unsigned 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
) ENGINE=InnoDB AUTO_INCREMENT=960 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- --------------- 已上线 ----------------- v1.7.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 AUTO_INCREMENT=92 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- 新增权限
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_03017', 'EGH-API-FRONT-STL-03017');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_03018', 'EGH-API-FRONT-STL-03018');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_04020', 'EGH-API-FRONT-STL-04020');
-- --------------- 已上线 ----------------- V1.7.1.1 -----------------
-- 新增权限
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_MANAGE_01001', 'EGH-API-FRONT-MANAGE-01001');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_MANAGE_01002', 'EGH-API-FRONT-MANAGE-01002');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_MANAGE_02001', 'EGH-API-FRONT-MANAGE-02001');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_MANAGE_03001', 'EGH-API-FRONT-MANAGE-03001');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_MANAGE_03002', 'EGH-API-FRONT-MANAGE-03002');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_MANAGE_04001', 'EGH-API-FRONT-MANAGE-04001');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_MANAGE_05001', 'EGH-API-FRONT-MANAGE-05001');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_MANAGE_05002', 'EGH-API-FRONT-MANAGE-05002');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_MANAGE_05003', 'EGH-API-FRONT-MANAGE-05003');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_MANAGE_06001', 'EGH-API-FRONT-MANAGE-06001');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_MANAGE_06002', 'EGH-API-FRONT-MANAGE-06002');</code></pre>