易公会数据库实时更新

20211118_1835 测试环境已更新
------------------------
-- V1.0.4.1 调整的sql
------------------------
-- 角色及接口用例
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_06004', 'EGH-API-FRONT-SYS-06004');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_06005', 'EGH-API-FRONT-SYS-06005');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_04012', 'EGH-API-FRONT-STL-04012');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_04013', 'EGH-API-FRONT-STL-04013');

-- 系统管理员权限
INSERT INTO `role_privilege`(`func_title`, `role_id`) VALUES ('EGH_SYS_06004', 'R20210001');
INSERT INTO `role_privilege`(`func_title`, `role_id`) VALUES ('EGH_SYS_06005', 'R20210001');
-- 超级管理权限
INSERT INTO `role_privilege`(`func_title`, `role_id`) VALUES ('EGH_STL_04012', 'R20210002');
-- 结算主管权限
INSERT INTO `role_privilege`(`func_title`, `role_id`) VALUES ('EGH_STL_04013', 'R20210003');

------------------------
-- V1.0.4.1需要更新的数据表
------------------------

-- 新增数据表 2021/11/18 V1.0.4.1
CREATE TABLE `withdrawl_astrict` (
  `no_` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
  `id` varchar(128) NOT NULL COMMENT '提现限制ID',
  `daily_withdrawl_time` int(32) NOT NULL COMMENT '每日累计提现次数',
  `monthly_withdrawl_limit` decimal(11,2) DEFAULT NULL COMMENT '每月提现累计额度',
  `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_wallet_detail_id` (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;