易公会数据库v1.8调整记录
<pre><code class="language-sql">
-------------------------------- V1.8.4 -------------------------
ALTER TABLE `income_and_withdrawl` ADD COLUMN `fee` decimal(13,2) NOT NULL COMMENT '手续费';
ALTER TABLE `income_and_withdrawl` ADD COLUMN `rate` decimal(13,4) NOT NULL COMMENT '费率';
-------------------------------- V1.8.3 -------------------------
-- 新增权限
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_05301', 'EGH-API-FRONT-STL-05301');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_05302', 'EGH-API-FRONT-STL-05302');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WD_01101', 'EGH-API-FRONT-WD-01101');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WD_01102', 'EGH-API-FRONT-WD-01102');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WD_01103', 'EGH-API-FRONT-WD-01103');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WD_01104', 'EGH-API-FRONT-WD-01104');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WD_01105', 'EGH-API-FRONT-WD-01105');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WD_01106', 'EGH-API-FRONT-WD-01106');
-- 支出明细
CREATE TABLE `expend_detail` (
`no_` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(128) NOT NULL COMMENT '日结结算数据ID',
`date` int(11) unsigned NOT NULL COMMENT '提现时间',
`begin_amount` decimal(10,2) NOT NULL COMMENT '流水金额',
`grant_amount` decimal(10,2) NOT NULL COMMENT '流水金额',
`withdrawl_amount` decimal(10,2) NOT NULL COMMENT '流水金额',
`end_amount` decimal(10,2) NOT 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_withdrawl_stm_id` (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- 提现记录回单地址记录表
CREATE TABLE `withdrawl_stm_receipt` (
`no_` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`withdrawl_stm_id` varchar(128) NOT NULL COMMENT '提现记录ID',
`grant_receipt_id` varchar(128) NOT NULL COMMENT '发放回单记录ID',
`is_effect` tinyint(4) unsigned NOT NULL COMMENT '是否生效 0失效 1生效',
`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 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- 发放流水回单文件地址记录表
CREATE TABLE `image_file_path` (
`no_` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`grant_receipt_id` varchar(128) NOT NULL COMMENT '发放回单记录ID',
`image_domain` varchar(128) COMMENT '文件域名',
`image_path` varchar(256) NOT NULL COMMENT '文件地址',
`image_name` varchar(256) NOT 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- --------------- 已上线 ---------- V1.8.1.3 -------------------------
-- 新增权限
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_EARNINGS_01008', 'EGH-API-FRONT-EARNINGS-01008');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_EARNINGS_01009', 'EGH-API-FRONT-EARNINGS-01009');
-- --------------- 已上线 ---------- V1.8.1 -------------------------
CREATE TABLE `open_account` (
`no_` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(64) NOT NULL COMMENT '开放id',
`app_code` varchar(32) NOT NULL COMMENT 'appcode',
`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_open_account_id` (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
CREATE TABLE `ip_whitelist` (
`no_` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`open_acct_id` varchar(64) NOT NULL COMMENT '开放id',
`ip` varchar(16) NOT NULL COMMENT 'ip地址',
`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 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
</code></pre>