易公会数据库v1.5调整记录
<pre><code class="language-sql">------------------ 已上线 ------------------ v1.5.2.4 ------------------
-- 新增字段
ALTER TABLE `withdrawl_stm` ADD COLUMN `withdrawl_type` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '提现类型 0-正常提现 1-修改收款账户提现';
-- 新增权限
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_09008', 'EGH-API-FRONT-TEAM-09008');
------------------ 已上线 ------------------ v1.5.2.3.2 ----------------
-- 新增权限
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WAL_01011', 'EGH-API-FRONT-WAL-01013');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_USER_01009', 'EGH-API-FRONT-USER-01009');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_USER_01010', 'EGH-API-FRONT-USER-01010');
-- 二要素校验请求记录表
CREATE TABLE `two_elements_request_rec` (
`no_` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(128) NOT NULL COMMENT 'id',
`name` varchar(32) NOT NULL COMMENT '姓名',
`id_card_num` varchar(32) NOT NULL COMMENT '身份证号码',
`response_code` varchar(16) NOT NULL COMMENT '请求返回错误码 查看枚举IdCardApiStatusEnum',
`request_id` varchar(64) NOT NULL COMMENT '请求ID',
`result_status` varchar(16) NOT NULL COMMENT '返回状态',
`result_state` tinyint(4) NOT NULL COMMENT '返回值为 1 : 查询成功, 二要素一致 返回值为 2 : 查询成功, 二要素不一致 返回值为 4:库无',
`is_available` tinyint(1) unsigned NOT NULL DEFAULT '1',
`creation_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE KEY `uk_bank_account_id` (`id`) USING BTREE,
UNIQUE KEY `uk_three_elements` (`id_card_num`,`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=utf8mb4;
------------------ 已上线 ------------------ v1.5.2.3.1 ----------------
-- 修改业务账号昵称 流程信息
INSERT INTO `process`(`id`, `name`, `process_num`) VALUES ('PR61G69AFSUDWGHL', '修改业务账号昵称', 'UPDATE_BIZ_ACCT_ALIAS');
-- 修改业务账号昵称 流程节点
INSERT INTO `process_node`(`id`, `type`, `process_id`, `func_title`, `prev_node_id`, `next_node_id`) VALUES ('PN61E34E6781KSK28', 1, 'PR61G69AFSUDWGHL', 'EGH-API-FRONT-INFO-03004', 'PN61E65E66GJHXFH', '');
INSERT INTO `process_node`(`id`, `type`, `process_id`, `func_title`, `prev_node_id`, `next_node_id`) VALUES ('PN61E65E66GJHXFH', 2, 'PR61G69AFSUDWGHL', 'EGH-API-FRONT-INFO-03004', '', 'PN61E34E6781KSK28');
-- 修改业务账号昵称 流程字段
INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E74F58PBKQEF', 'PR61G69AFSUDWGHL', '账号id', 1, 1);
INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E75658N6NFGE', 'PR61G69AFSUDWGHL', '原业务账号id', 1, 1);
INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E77F58U7EBVS', 'PR61G69AFSUDWGHL', '原业务账号昵称', 1, 1);
INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E7D65319QFEG', 'PR61G69AFSUDWGHL', '新业务账号id', 1, 1);
INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E77568AAOGVB', 'PR61G69AFSUDWGHL', '新业务账号昵称', 1, 1);
INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E54890SLBGDF', 'PR61G69AFSUDWGHL', '厅id', 1, 1);
INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E7UF58WOUGDG', 'PR61G69AFSUDWGHL', '账号昵称', 1, 1);
INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E77F98KOUGHO', 'PR61G69AFSUDWGHL', '业务账号类型', 1, 1);
------------------ 已上线 ------------------ v1.5.2.2.2 ----------------
-- 三要素请求记录表
CREATE TABLE `three_elements_request_rec` (
`no_` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(128) NOT NULL COMMENT 'id',
`name` varchar(32) NOT NULL COMMENT '姓名',
`id_card_num` varchar(32) NOT NULL COMMENT '身份证号码',
`phone_num` varchar(16) NOT NULL COMMENT '手机号',
`response_code` varchar(16) NOT NULL COMMENT '请求返回错误码 查看枚举MobileApiCodeEnum',
`response_res` varchar(16) NOT NULL COMMENT '验证结果 1:一致 2:不一致 3:无记录 -1:异常',
`is_available` tinyint(1) unsigned NOT NULL DEFAULT '1',
`creation_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE KEY `uk_bank_account_id` (`id`) USING BTREE,
UNIQUE KEY `uk_three_elements` (`id_card_num`,`name`,`phone_num`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=utf8mb4;
-- --------------- 已上线 ------------------ V1.5.2.2 ----------------
-- 新增权限
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_07006', 'EGH-API-FRONT-SYS-07006');
-- 更新钱包出入记录长度
ALTER TABLE wallet_detail MODIFY COLUMN title VARCHAR(256);
----------------- 已上线 ----------------- V1.5.2.1 -----------------
-- 新增权限
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_04008', 'EGH-API-FRONT-SYS-04008');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_04009', 'EGH-API-FRONT-SYS-04009');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_09007', 'EGH-API-FRONT-TEAM-09007');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WAL_01012', 'EGH-API-FRONT-WAL-01012');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WAL_01011', 'EGH-API-FRONT-WAL-01011');
-- 新增表
CREATE TABLE `rec_account_info` (
`no_` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(128) NOT NULL COMMENT 'id',
`account_id` varchar(128) NOT NULL COMMENT '收款账户id',
`account_type` tinyint(4) unsigned NOT NULL COMMENT '1银行卡 3支付宝',
`account_name` varchar(32) NOT NULL COMMENT '账户姓名',
`account_number` varchar(32) NOT NULL COMMENT '账户号码',
`id_card_num` varchar(32) NOT NULL COMMENT '身份证号码',
`phone_num` varchar(16) NOT NULL COMMENT '账户绑定的手机号',
`bank` varchar(64) NULL COMMENT '开户行',
`location` varchar(64) NULL COMMENT '开户地址',
`is_available` tinyint(1) unsigned NOT NULL DEFAULT '1',
`creation_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE KEY `uk_bank_account_id` (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8mb4;
-- 修改字段
ALTER TABLE withdrawl_stm MODIFY COLUMN remark VARCHAR(256);
-- 新增 字段
ALTER TABLE `withdrawl_stm` ADD COLUMN `account_type` tinyint(4) unsigned NOT NULL COMMENT '1银行卡 3支付宝';
ALTER TABLE `withdrawl_stm` ADD COLUMN `account_name` varchar(32) NOT NULL COMMENT '账户姓名';
ALTER TABLE `withdrawl_stm` ADD COLUMN `account_number` varchar(32) NOT NULL COMMENT '账户号码';
ALTER TABLE `withdrawl_stm` ADD COLUMN `id_card_num` varchar(32) NOT NULL COMMENT '身份证号码';
ALTER TABLE `withdrawl_stm` ADD COLUMN `phone_num` varchar(16) NOT NULL COMMENT '账户绑定的手机号';
ALTER TABLE `withdrawl_stm` ADD COLUMN `bank` varchar(64) NULL COMMENT '开户行';
ALTER TABLE `withdrawl_stm` ADD COLUMN `location` varchar(64) NULL COMMENT '开户地址';
ALTER TABLE `withdrawl_bat` ADD COLUMN `bat_remark` varchar(256) NULL COMMENT '批次备注';
-- 更新旧提现流水收款账户信息
UPDATE withdrawl_stm AS ws,bank_account AS ba SET ws.account_name = ba.name,ws.account_number = ba.number,ws.id_card_num = ba.id_card_num,ws.phone_num = ba.phone_num,ws.account_type = ba.type WHERE ba.id = ws.account_id;
UPDATE withdrawl_stm AS ws,bank_card AS bc SET ws.bank = bc.bank,ws.location = bc.location WHERE bc.acct_id = ws.account_id;
----------------- 已上线 ----------------- V1.5.1.3 -----------------
-- 新增 权限
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_03030', 'EGH-API-FRONT-TEAM-03030');
----------------- 已上线 ----------------- V1.5.1.2 -----------------
-- 新增 权限
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WAL_01010', 'EGH-API-FRONT-WAL-01010');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_04007', 'EGH-API-FRONT-SYS-04007');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_06008', 'EGH-API-FRONT-SYS-06008');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_06009', 'EGH-API-FRONT-SYS-06009');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_INFO_03007', 'EGH-API-FRONT-INFO-03007');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_INFO_03008', 'EGH-API-FRONT-INFO-03008');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_03022', 'EGH-API-FRONT-TEAM-03022');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_03023', 'EGH-API-FRONT-TEAM-03023');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_03024', 'EGH-API-FRONT-TEAM-03024');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_03025', 'EGH-API-FRONT-TEAM-03025');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_03026', 'EGH-API-FRONT-TEAM-03026');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_03027', 'EGH-API-FRONT-TEAM-03027');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_03028', 'EGH-API-FRONT-TEAM-03028');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_03029', 'EGH-API-FRONT-TEAM-03029');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_04016', 'EGH-API-FRONT-TEAM-04016');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_04017', 'EGH-API-FRONT-TEAM-04017');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_04018', 'EGH-API-FRONT-TEAM-04018');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_04019', 'EGH-API-FRONT-TEAM-04019');
-- "修改新开业务账号流程名称"
UPDATE process SET name = "申请进厅" WHERE id = "PR601CFB13N8VQDM";
-- 流程数据
INSERT INTO `process` (`id`, `name`, `process_num`, `is_available`) VALUES ('PR621893B7HA7CYV', '申请开厅', 'BIZ_ACCT_CREATE_ROOM', 1);
-- 开关厅节点
INSERT INTO `process_node` (`id`, `type`, `process_id`, `func_title`, `prev_node_id`, `next_node_id`, `fail_time`, `is_available`) VALUES ('PN6218951EOPJXCU', 1, 'PR621893B7HA7CYV', 'EGH-API-FRONT-INFO-03008', NULL, 'PN6218951EE92NUD', NULL, 1);
INSERT INTO `process_node` (`id`, `type`, `process_id`, `func_title`, `prev_node_id`, `next_node_id`, `fail_time`, `is_available`) VALUES ('PN6218951EE92NUD', 2, 'PR621893B7HA7CYV', 'EGH-API-FRONT-INFO-03008', 'PN6218951EOPJXCU', NULL, NULL, 1);
-- 开关厅字段
INSERT INTO `process_field` (`id`, `process_id`, `name`, `type`, `is_not_null`, `is_available`) VALUES ('PF621895EA8RTMYZ', 'PR621893B7HA7CYV', '申请用户ID', 1, 1, 1);
INSERT INTO `process_field` (`id`, `process_id`, `name`, `type`, `is_not_null`, `is_available`) VALUES ('PF621895EAGLD6TW', 'PR621893B7HA7CYV', '申请用户花名', 1, 1, 1);
INSERT INTO `process_field` (`id`, `process_id`, `name`, `type`, `is_not_null`, `is_available`) VALUES ('PF621895EAQXRBYJ', 'PR621893B7HA7CYV', '业务账号ID', 1, 1, 1);
INSERT INTO `process_field` (`id`, `process_id`, `name`, `type`, `is_not_null`, `is_available`) VALUES ('PF621895EAWNQH3C', 'PR621893B7HA7CYV', '业务账号号码', 1, 1, 1);
INSERT INTO `process_field` (`id`, `process_id`, `name`, `type`, `is_not_null`, `is_available`) VALUES ('PF621895EAPBJ86W', 'PR621893B7HA7CYV', '业务账号昵称', 1, 1, 1);
INSERT INTO `process_field` (`id`, `process_id`, `name`, `type`, `is_not_null`, `is_available`) VALUES ('PF621895EAIRVSVC', 'PR621893B7HA7CYV', '业务账号类型', 1, 1, 1);
INSERT INTO `process_field` (`id`, `process_id`, `name`, `type`, `is_not_null`, `is_available`) VALUES ('PF621895EAYZTHQA', 'PR621893B7HA7CYV', '平台业务ID', 1, 1, 1);
INSERT INTO `process_field` (`id`, `process_id`, `name`, `type`, `is_not_null`, `is_available`) VALUES ('PF621DBD16SEVQFU', 'PR621893B7HA7CYV', '平台业务名称', 1, 1, 1);
INSERT INTO `process_field` (`id`, `process_id`, `name`, `type`, `is_not_null`, `is_available`) VALUES ('PF621895EAMGLWMA', 'PR621893B7HA7CYV', '运营组ID', 1, 1, 1);
INSERT INTO `process_field` (`id`, `process_id`, `name`, `type`, `is_not_null`, `is_available`) VALUES ('PF621DBD165NEZMT', 'PR621893B7HA7CYV', '运营组名称', 1, 1, 1);
INSERT INTO `process_field` (`id`, `process_id`, `name`, `type`, `is_not_null`, `is_available`) VALUES ('PF621895EAWHUZHL', 'PR621893B7HA7CYV', '厅ID', 1, 1, 1);
-- 公用账号解绑流程
INSERT INTO `process` (`id`, `name`, `process_num`, `is_available`) VALUES ('PR6221DC273QPKWJ', '公用账号解绑', 'NEW_UNBIND_PUBLIC_BIZ_ACCT', 1);
-- 公用账号解绑节点
INSERT INTO `process_node` (`id`, `type`, `process_id`, `func_title`, `prev_node_id`, `next_node_id`, `fail_time`, `is_available`) VALUES ('PN6221E01AEISW7Q', 1, 'PR6221DC273QPKWJ', '待定', NULL, 'PN6221E01APMZRIH', NULL, 1);
INSERT INTO `process_node` (`id`, `type`, `process_id`, `func_title`, `prev_node_id`, `next_node_id`, `fail_time`, `is_available`) VALUES ('PN6221E01APMZRIH', 2, 'PR6221DC273QPKWJ', '待定', 'PN6221E01AEISW7Q', NULL, NULL, 1);
-- 公用账号解绑字段
INSERT INTO `process_field` (`id`, `process_id`, `name`, `type`, `is_not_null`, `is_available`) VALUES ('PF6221DC94XB7SL1', 'PR6221DC273QPKWJ', '解绑类型', 1, 1, 1);
INSERT INTO `process_field` (`id`, `process_id`, `name`, `type`, `is_not_null`, `is_available`) VALUES ('PF6221DC94SPIF1V', 'PR6221DC273QPKWJ', '操作人系统id', 1, 1, 1);
INSERT INTO `process_field` (`id`, `process_id`, `name`, `type`, `is_not_null`, `is_available`) VALUES ('PF6221DC94IYJZJW', 'PR6221DC273QPKWJ', '使用人系统id', 1, 1, 1);
INSERT INTO `process_field` (`id`, `process_id`, `name`, `type`, `is_not_null`, `is_available`) VALUES ('PF6221DC943VC9I1', 'PR6221DC273QPKWJ', '使用人昵称', 1, 1, 1);
INSERT INTO `process_field` (`id`, `process_id`, `name`, `type`, `is_not_null`, `is_available`) VALUES ('PF6221DC94HZ2FPK', 'PR6221DC273QPKWJ', '操作人角色', 1, 1, 1);
INSERT INTO `process_field` (`id`, `process_id`, `name`, `type`, `is_not_null`, `is_available`) VALUES ('PF6221DC94PV9ZHW', 'PR6221DC273QPKWJ', '操作人', 1, 1, 1);
INSERT INTO `process_field` (`id`, `process_id`, `name`, `type`, `is_not_null`, `is_available`) VALUES ('PF6221DC94TH7XCD', 'PR6221DC273QPKWJ', '审核类型', 1, 1, 1);
INSERT INTO `process_field` (`id`, `process_id`, `name`, `type`, `is_not_null`, `is_available`) VALUES ('PF6221DC944PWP3N', 'PR6221DC273QPKWJ', '公用账号系统id', 1, 1, 1);
INSERT INTO `process_field` (`id`, `process_id`, `name`, `type`, `is_not_null`, `is_available`) VALUES ('PF6221DC94EOFCFJ', 'PR6221DC273QPKWJ', '公用账号昵称', 1, 1, 1);
INSERT INTO `process_field` (`id`, `process_id`, `name`, `type`, `is_not_null`, `is_available`) VALUES ('PF6221DC944YQ0VE', 'PR6221DC273QPKWJ', '公用账号id', 1, 1, 1);
INSERT INTO `process_field` (`id`, `process_id`, `name`, `type`, `is_not_null`, `is_available`) VALUES ('PF6221DC94S75DCW', 'PR6221DC273QPKWJ', '厅ID', 1, 1, 1);
INSERT INTO `process_field` (`id`, `process_id`, `name`, `type`, `is_not_null`, `is_available`) VALUES ('PF6221DC94XDH0W4', 'PR6221DC273QPKWJ', '所属部门名称', 1, 1, 1);
INSERT INTO `process_field` (`id`, `process_id`, `name`, `type`, `is_not_null`, `is_available`) VALUES ('PF6221DC94XIEEWT', 'PR6221DC273QPKWJ', '所属部门系统id', 1, 1, 1);
-- 厅部门开关厅历史记录
CREATE TABLE `rec_room_info` (
`no_` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(64) NOT NULL COMMENT 'id',
`room_id` varchar(64) NOT NULL COMMENT '部门id',
`name` varchar(32) NOT NULL COMMENT '厅名',
`number` varchar(32) NOT NULL COMMENT '厅房间号',
`invitation_code` varchar(32) DEFAULT NULL COMMENT '厅邀请码',
`group_id` varchar(32) NOT NULL COMMENT '运营组ID',
`plf_id` varchar(32) NOT NULL COMMENT '平台ID',
`biz_id` varchar(32) NOT NULL COMMENT '业务ID',
`user_id` varchar(128) NOT NULL COMMENT '失效时间',
`create_room_time` int(11) unsigned NOT NULL COMMENT '开厅时间',
`close_room_time` int(11) unsigned DEFAULT NULL COMMENT '关厅时间',
`stl_date` int(11) unsigned NOT NULL COMMENT '可结算时间',
`is_available` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '数据可用状态',
`creation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '数据可用状态',
`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.5.1.2
INSERT INTO `process`(`id`, `name`, `process_num`) VALUES ('PR621F2470DYNRP4', '新绑定公用账号', 'NEW_BIND_PUBLIC_BIZ_ACCT');
-- 绑定 公用账号 新绑定公用账号v1.5.1.2
INSERT INTO `process_node`(`id`, `type`, `process_id`, `func_title`, `prev_node_id`, `next_node_id`) VALUES ('PN621F39D1DONDVI', 1, 'PR621F2470DYNRP4', 'EGH-API-FRONT-TEAM-03027', 'PN621F39EC7UK9ZV', '');
INSERT INTO `process_node`(`id`, `type`, `process_id`, `func_title`, `prev_node_id`, `next_node_id`) VALUES ('PN621F39EC7UK9ZV', 2, 'PR621F2470DYNRP4', 'EGH-API-FRONT-TEAM-03027', '', 'PN621F39D1DONDVI');
-- 绑定 公用账号 流程字段v1.5.1.2
INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF621F3A43V8JF9L', 'PR621F2470DYNRP4', '所属部门系统id', 1, 1);
INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF621F3A49VGDCNA', 'PR621F2470DYNRP4', '所属部门名称', 1, 1);
INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF621F3A4EKIZO3X', 'PR621F2470DYNRP4', '厅ID', 1, 1);
INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF621F3A54MZOQ10', 'PR621F2470DYNRP4', '公用账号id', 1, 1);
INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF621F3A59EQP2L0', 'PR621F2470DYNRP4', '公用账号昵称', 1, 1);
INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF621F3A5ET2HCQX', 'PR621F2470DYNRP4', '公用账号系统id', 1, 1);
INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF621F3A63WALYIR', 'PR621F2470DYNRP4', '审核类型', 1, 1);
INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF621F3A68L4IX5R', 'PR621F2470DYNRP4', '操作人', 1, 1);
INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF621F3A6ELGSX7Y', 'PR621F2470DYNRP4', '操作人角色', 1, 1);
INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF621F3EF0AV20Y5', 'PR621F2470DYNRP4', '操作人系统id', 1, 1);
INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF62203434TQJKRP', 'PR621F2470DYNRP4', '使用人系统id', 1, 1);
INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF6220343BFLXUEK', 'PR621F2470DYNRP4', '使用人昵称', 1, 1);
-- 新增 角色字段
ALTER TABLE `biz_acct_info` ADD COLUMN `role` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '角色1.艺人号2.房主号';
-- 新增 模式字段
ALTER TABLE `biz_dept_info` ADD COLUMN `mode` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '模式1.now模式2斗鱼模式';
-- 新增 模式字段
ALTER TABLE `rec_biz_plf_info` ADD COLUMN `mode` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '模式1.now模式2斗鱼模式';
-- 新增 状态字段
ALTER TABLE `room_info` ADD COLUMN `status` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '状态1.正常2.关厅';
-- 新增 平台业务字段
ALTER TABLE `room_info` ADD COLUMN `plf_biz_id` varchar(64) NOT NULL COMMENT '平台业务部门id';
-- 新增 同步平台业务字段数据需要先执行上面新增平台业务字段sql
UPDATE room_info AS room SET room.plf_biz_id =(SELECT biz.dept_id FROM biz_dept_info AS biz,dept_node AS dept WHERE biz.dept_id = dept.id AND dept.scope = 10 AND biz.biz_id = ( SELECT info.biz_id FROM biz_dept_info AS info WHERE info.dept_id = room.dept_id ) AND biz.plf_id = ( SELECT info.plf_id FROM biz_dept_info AS info WHERE info.dept_id = room.dept_id )) WHERE room.dept_id IN ( SELECT id FROM dept_node WHERE scope = 25 );
-- 新增 申请进厅 流程字段
INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF21E74F53U9ECIB', 'PR601CFB13N8VQDM', '业务账号部门ID', 1, 1);
----------------- 已上线 ----------------- V1.5.1.1 -----------------
-- 新增 表
CREATE TABLE `payee_conf` (
`no_` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(128) NOT NULL COMMENT 'id',
`payee_type` tinyint(4) unsigned NOT NULL COMMENT '1银行卡 3支付宝',
`payee_name` varchar(32) NOT NULL COMMENT '收款账户配置名称',
`payee_status` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '状态 0禁用 1 启用',
`is_available` tinyint(1) unsigned NOT NULL DEFAULT '1',
`creation_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE KEY `uk_payee_conf_id` (`id`) USING BTREE,
UNIQUE KEY `uk_payee_type_id` (`payee_type`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- 新增数据
INSERT INTO `payee_conf` (`id`, `payee_type`, `payee_name`, `payee_status`, `is_available`) VALUES ('ALIPAY', 3, '支付宝', 1, 1);
INSERT INTO `payee_conf` (`id`, `payee_type`, `payee_name`, `payee_status`, `is_available`) VALUES ('BANK', 1, '银行卡', 1, 1);
-- 新增权限
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WAL_01007', 'EGH-API-FRONT-WAL-01007');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WAL_01008', 'EGH-API-FRONT-WAL-01008');
INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WAL_01009', 'EGH-API-FRONT-WAL-01009');
</code></pre>