易公会数据库v1.8调整记录

-------------------------------- 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;