--  add by  hxl  2024-07-05  部门提现表添加审核时间
ALTER TABLE `sys_dept_account_withdraw` ADD COLUMN `auditing_time` datetime DEFAULT NULL COMMENT '部门提现审核时间';

--  add  by  hxl  机构账户表添加
ALTER TABLE `sys_dept_account` ADD COLUMN `sum_amount_withdrawal` decimal(10,2) DEFAULT 0 COMMENT '提现总金额';
ALTER TABLE `sys_dept_account` ADD COLUMN `sum_amount_account` decimal(10,2) DEFAULT 0 COMMENT '已到账总金额';
ALTER TABLE `sys_dept_account` ADD COLUMN `sum_amount_payment` decimal(10,2) DEFAULT 0 COMMENT '支付中总金额';
--  add  by hxl   部门账户历史表添加部门提现审核id
ALTER TABLE `sys_dept_account_history` ADD COLUMN `auditing_id`  varchar(30) DEFAULT NULL COMMENT '部门提现审核Id';
ALTER TABLE `sys_dept_account_history` ADD COLUMN `business_eegments_type` int DEFAULT NULL COMMENT '业务版块';
ALTER TABLE `sys_dept_account_history` ADD COLUMN `property` int DEFAULT NULL COMMENT '金钱属性  5退款 6 提现';
-- add by hxl  部门审核轨迹表
DROP TABLE IF EXISTS `sys_amount_auditing_dept_history`;
CREATE TABLE `sys_amount_auditing_dept_history`  (
                                                     `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
                                                     `amount_auding_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审核表id',
                                                     `amount` decimal(10, 2) NOT NULL COMMENT '提现金额',
                                                     `dept_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '机构Id',
                                                     `create_time` datetime NOT NULL COMMENT '创建时间',
                                                     `auditing_status` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '审核状态 1 提现申请  2.处理中 3.驳回  4.提现成功',
                                                     `amount_status` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '金额类型 1 提现',
                                                     `history_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '历史记录表id',
                                                     PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '部门审核轨迹表' ROW_FORMAT = Dynamic;

--  add by  hxl  2024-07-08  提现审核表添加 内部银行卡信息
ALTER TABLE `sys_amount_auditing` ADD COLUMN `account_name`  varchar(30) DEFAULT NULL COMMENT '内部账户名称';
ALTER TABLE `sys_amount_auditing` ADD COLUMN `bank_card_num` varchar(100) DEFAULT NULL COMMENT '内部银行卡号';
ALTER TABLE `sys_amount_auditing` ADD COLUMN `bank_name` varchar(100) DEFAULT NULL COMMENT '内部银行卡开户行名称';
ALTER TABLE `sys_amount_auditing` ADD COLUMN `bank_num` varchar(100) DEFAULT NULL COMMENT '内部银行卡开户行号';
ALTER TABLE `sys_amount_auditing` ADD COLUMN `account_id` varchar(30) DEFAULT NULL COMMENT '内部账户id';