java-insagent-pc/sql/Online.sql

-- add by  2024-06-20  账户表添加总金额
ALTER TABLE `sys_user_account` ADD COLUMN `sum_amount` decimal(15,5) DEFAULT 0 COMMENT '账号总金额';
ALTER TABLE `sys_user_account` ADD COLUMN `sum_amount_withdrawal` decimal(15,5) DEFAULT 0 COMMENT '提现总金额';
ALTER TABLE `sys_user_account` ADD COLUMN `sum_amount_account` decimal(15,5) DEFAULT 0 COMMENT '已到账总金额';
ALTER TABLE `sys_user_account` ADD COLUMN `sum_amount_payment` decimal(15,5) DEFAULT 0 COMMENT '支付中总金额';
--  add by   历史表添加业务板块字段
ALTER TABLE `sys_user_account_history` ADD COLUMN `business_eegments_type` int DEFAULT NULL COMMENT '业务版块';

-- add by  审核轨迹表
DROP TABLE IF EXISTS `sys_amount_auditing_history`;
CREATE TABLE `sys_amount_auditing_history`  (
                                                `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
                                                `amount_auding_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '银行卡号',
                                                `amount` decimal(10, 2) NOT NULL COMMENT '提现金额',
                                                `user_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;