易公会Plus v0.4 调整记录
<pre><code class="language-sql">-- --------------- ---------- v0.4.3 -------------------------
-- 新增权限
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 `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(128) NOT NULL COMMENT '文件地址',
`image_name` varchar(64) 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;
-- --------------- 已上线 ---------- v0.4.2 -------------------------
-- 新增权限
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_13003', 'EGH-API-FRONT-TEAM-13003');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_13002', 'EGH-API-FRONT-TEAM-13002');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01501', 'EGH-API-FRONT-STL-01501');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01502', 'EGH-API-FRONT-STL-01502');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01503', 'EGH-API-FRONT-STL-01503');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01504', 'EGH-API-FRONT-STL-01504');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_FAST_01001', 'EGH-API-FRONT-FAST-01001');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_FAST_01002', 'EGH-API-FRONT-FAST-01002');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_FAST_01005', 'EGH-API-FRONT-FAST-01005');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_FAST_01006', 'EGH-API-FRONT-FAST-01006');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_FAST_01007', 'EGH-API-FRONT-FAST-01007');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_FAST_02001', 'EGH-API-FRONT-FAST-02001');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_FAST_02002', 'EGH-API-FRONT-FAST-02002');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_FAST_02003', 'EGH-API-FRONT-FAST-02003');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_FAST_02004', 'EGH-API-FRONT-FAST-02004');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_FAST_02005', 'EGH-API-FRONT-FAST-02005');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_FAST_02006', 'EGH-API-FRONT-FAST-02006');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_FAST_02007', 'EGH-API-FRONT-FAST-02007');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_FAST_02008', 'EGH-API-FRONT-FAST-02008');
-- 新增字段
ALTER TABLE `user` ADD COLUMN `collect_acct` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '收款账户状态 1-未添加, 2-已添加';
-- 更新字段数据
UPDATE user,bank_account SET user.collect_acct = 2 WHERE user.id = bank_account.user_id AND bank_account.is_available = 1;
-- 部门结算模式配置
CREATE TABLE `dept_stl_type_conf` (
`no_` INT ( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` VARCHAR ( 32 ) NOT NULL COMMENT '初始数据ID',
`dept_id` VARCHAR ( 32 ) NOT NULL COMMENT '部门id',
`dept_scope` TINYINT ( 4 ) UNSIGNED NOT NULL COMMENT '部门层级',
`stl_type` TINYINT ( 4 ) UNSIGNED NOT NULL COMMENT '结算模式 1-正常结算 2-快速结算 ',
`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_dept_stl_type_conf_id` ( `id` ) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- 快速发放收益初始数据
CREATE TABLE `fast_stl_gain_data` (
`no_` INT ( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` VARCHAR ( 128 ) NOT NULL COMMENT '初始数据ID',
`tab_id` VARCHAR ( 64 ) NOT NULL COMMENT '关联模板表ID',
`bat_id` VARCHAR ( 128 ) NOT NULL COMMENT '批次ID',
`date` INT ( 11 ) UNSIGNED NOT NULL COMMENT '流水发生日期',
`biz_acct_id` VARCHAR ( 64 ) NOT NULL COMMENT '业务账号ID',
`biz_acct_num` VARCHAR ( 64 ) NOT NULL COMMENT '业务账号num',
`biz_acct_alias` VARCHAR ( 64 ) NOT NULL COMMENT '业务账号花名',
`room_id` VARCHAR ( 64 ) NOT NULL COMMENT '厅ID',
`room_num` VARCHAR ( 64 ) NOT NULL COMMENT '厅num',
`room_name` VARCHAR ( 64 ) NOT NULL COMMENT '厅名称',
`plf_biz_id` VARCHAR ( 64 ) DEFAULT NULL COMMENT '平台业务ID',
`tax_rate` DECIMAL ( 4, 3 ) NOT NULL COMMENT '税率',
`stl_dept` TINYINT ( 4 ) UNSIGNED NOT NULL COMMENT '结算部门 20-运营组 25-厅 30-业务账号',
`cus_fields` json DEFAULT NULL COMMENT '可变字段',
`other_fields` json 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_fast_stl_gain_data_id` ( `id` ) USING BTREE
) ENGINE = INNODB AUTO_INCREMENT = 8944 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC;
-- 快速发放收益批次
CREATE TABLE `fast_stl_gain_data_bat` (
`no_` INT ( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` VARCHAR ( 128 ) NOT NULL COMMENT '批次ID',
`tab_id` VARCHAR ( 64 ) NOT NULL COMMENT '关联模板表ID',
`company_id` VARCHAR ( 64 ) DEFAULT NULL COMMENT '公司主体ID',
`plf_biz_id` VARCHAR ( 64 ) DEFAULT NULL COMMENT '平台业务ID',
`room_id` VARCHAR ( 64 ) NOT NULL COMMENT '厅ID',
`total` int(11) NOT NULL COMMENT '总数',
`user_id` VARCHAR ( 128 ) DEFAULT NULL COMMENT '导入用户ID',
`import_date` INT ( 11 ) UNSIGNED NOT NULL COMMENT '导入时间',
`start_time` INT ( 11 ) UNSIGNED NOT NULL COMMENT '开始时间',
`end_time` INT ( 11 ) UNSIGNED NOT NULL COMMENT '结束时间',
`status` tinyint(1) NOT NULL DEFAULT '5' COMMENT '审核状态',
`reject_reason` varchar(255) 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_fast_stl_gain_data_id` ( `id` ) USING BTREE
) ENGINE = INNODB AUTO_INCREMENT = 8944 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC;
-- 快速发放收益计算数据
CREATE TABLE `fast_stl_gain_stm_data` (
`no_` INT ( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` VARCHAR ( 128 ) NOT NULL COMMENT '初始数据ID',
`tab_id` VARCHAR ( 64 ) NOT NULL COMMENT '关联模板表ID',
`bat_id` VARCHAR ( 128 ) NOT NULL COMMENT '批次ID',
`date` INT ( 11 ) UNSIGNED NOT NULL COMMENT '流水发生日期',
`biz_acct_id` VARCHAR ( 64 ) DEFAULT NULL COMMENT '业务账号ID',
`room_id` VARCHAR ( 64 ) NOT NULL COMMENT '厅ID',
`plf_biz_id` VARCHAR ( 64 ) NOT NULL COMMENT '平台业务ID',
`stm_amount` DECIMAL( 13, 2 ) NOT NULL COMMENT '流水',
`stl_dept` TINYINT ( 4 ) UNSIGNED NOT NULL COMMENT '结算部门 20-运营组 25-厅 30-业务账号',
`tax_rate` DECIMAL ( 4, 3 ) NOT NULL COMMENT '税率',
`all_earnings_amount` DECIMAL( 13, 2 ) NOT NULL COMMENT '总收益(税后)',
`pack_id` varchar(64) DEFAULT NULL COMMENT '打包ID',
`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_fast_stl_gain_data_id` ( `id` ) USING BTREE
) ENGINE = INNODB AUTO_INCREMENT = 8944 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC;
-- 快速发放收益批次状态变化记录
CREATE TABLE `fast_stl_gain_data_bat_status_line` (
`no_` INT ( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` VARCHAR ( 128 ) NOT NULL COMMENT '批次ID',
`bat_id` VARCHAR ( 128 ) NOT NULL COMMENT '批次ID',
`status` tinyint(1) NOT NULL DEFAULT '5' 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_fast_stl_gain_data_id` ( `id` ) USING BTREE
) ENGINE = INNODB AUTO_INCREMENT = 8944 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC;
-- 结算账户新增收入类型字段, 用于区分是快速结算还是正常结算 1-正常结算 2-快速结算
ALTER TABLE `stl_acct_income` ADD COLUMN `income_type` TINYINT ( 1 ) NOT NULL DEFAULT '1' COMMENT '结算账户收入类型';
-- 收益发放记录展示表新增快速收益字段
ALTER TABLE `view_earnings_grant_detail` ADD COLUMN `fast_stl_earning` DECIMAL ( 13, 2 ) NOT NULL DEFAULT 0 COMMENT '快速收益(税后)';
-- 结算批次对应发放批次新增批次类型
ALTER TABLE `stl_bat_and_grant_bat` ADD COLUMN `bat_type` TINYINT ( 1 ) NOT NULL DEFAULT '1' COMMENT '批次类型';
</code></pre>