23 lines
4.4 KiB
SQL
23 lines
4.4 KiB
SQL
-- 字段修改【biz_coop_sftp_config表 prd_code字段不可为空】
|
||
ALTER TABLE `rec_loan`.`biz_coop_sftp_config` MODIFY COLUMN `prd_code` varchar(32) NOT NULL COMMENT '产品编号' AFTER `coop_no`;
|
||
|
||
-- 字段修改【biz_coop_sftp_config表 coop_no字段不可为空】
|
||
ALTER TABLE `rec_loan`.`biz_coop_sftp_config` MODIFY COLUMN `coop_no` varchar(30) NOT NULL COMMENT '合作方编号' AFTER `id`;
|
||
|
||
-- 字段删除【bam_file_store表删除字段：oss_url(OSS文件外链URL)】
|
||
ALTER TABLE `rec_loan`.`bam_file_store` DROP COLUMN oss_url;
|
||
|
||
-- 字段删除【bam_file_store表删除字段：file_store_type(文件存储类型)】
|
||
ALTER TABLE `rec_loan`.`bam_file_store` DROP COLUMN file_store_type;
|
||
|
||
-- sftp配置修改
|
||
DELETE FROM `rec_loan`.`biz_coop_sftp_config` WHERE id ='6';
|
||
-- 影像平台上传配置回滚
|
||
UPDATE `rec_loan`.`sys_option` SET `option_val` = 'P22071001:XDLYXSQYX:007', `option_txt` = 'P22071001:XDLYXSQYX:007', `option_ord` = 2, `option_desc` = '新大陆产品用信影像', `select_id` = '20564456180739473408', `create_user` = '007002', `create_org` = '007', `create_time` = '2021-12-28 17:19:07', `create_date` = '2037-07-19', `update_user` = '007001', `update_org` = '007', `update_time` = '2022-01-08 10:15:22', `update_date` = '2030-12-01', `cur_vers` = 1 WHERE `id` = Cast('20573921493361098752'AS Binary(20));
|
||
UPDATE `rec_loan`.`sys_option` SET `option_val` = 'P22071001:XDLSXSQYX:007', `option_txt` = 'P22071001:XDLSXSQYX:007', `option_ord` = 1, `option_desc` = '新大陆产品授信影像', `select_id` = '20564456180739473408', `create_user` = '007002', `create_org` = '007', `create_time` = '2021-12-29 14:13:39', `create_date` = '2037-08-11', `update_user` = '007001', `update_org` = '007', `update_time` = '2022-01-08 10:15:17', `update_date` = '2030-12-01', `cur_vers` = 1 WHERE `id` = Cast('20574237207263444992'AS Binary(20));
|
||
UPDATE `rec_loan`.`sys_option` SET `option_val` = 'P22071001:XDLDKZMYX:007', `option_txt` = 'P22071001:XDLDKZMYX:007', `option_ord` = 3, `option_desc` = '新大陆贷款证明影像', `select_id` = '20564456180739473408', `create_user` = '00000000', `create_org` = '999999', `create_time` = '2022-01-05 14:59:23', `create_date` = '2037-12-07', `update_user` = '007001', `update_org` = '007', `update_time` = '2022-01-08 10:15:25', `update_date` = '2030-12-01', `cur_vers` = 1 WHERE `id` = Cast('20576785431765450752'AS Binary(20));
|
||
UPDATE `rec_loan`.`sys_option` SET `option_val` = 'P22071001:XDLCPZAYX:007', `option_txt` = 'P22071001:XDLCPZAYX:007', `option_ord` = 4, `option_desc` = '新大陆产品专案影像', `select_id` = '20564456180739473408', `create_user` = '00000000', `create_org` = '999999', `create_time` = '2022-01-05 15:00:04', `create_date` = '2037-12-07', `update_user` = '007001', `update_org` = '007', `update_time` = '2022-01-08 10:15:30', `update_date` = '2030-12-01', `cur_vers` = 1 WHERE `id` = Cast('20576785604356866048'AS Binary(20));
|
||
UPDATE `rec_loan`.`sys_option` SET `option_val` = 'null:GRKHYX:007', `option_txt` = 'null:GRKHYX:007', `option_ord` = 5, `option_desc` = '个人客户影像', `select_id` = '20564456180739473408', `create_user` = '00000000', `create_org` = '999999', `create_time` = '2022-01-05 15:00:38', `create_date` = '2037-12-07', `update_user` = '007001', `update_org` = '007', `update_time` = '2022-01-09 10:48:45', `update_date` = '2031-01-21', `cur_vers` = 1 WHERE `id` = Cast('20576785745352589312'AS Binary(20));
|
||
UPDATE `rec_loan`.`sys_option` SET `option_val` = 'null:QYKHYX:007', `option_txt` = 'null:QYKHYX:007', `option_ord` = 6, `option_desc` = '企业客户影像', `select_id` = '20564456180739473408', `create_user` = '00000000', `create_org` = '999999', `create_time` = '2022-01-05 15:00:58', `create_date` = '2037-12-07', `update_user` = '007001', `update_org` = '007', `update_time` = '2022-01-09 10:48:36', `update_date` = '2031-01-21', `cur_vers` = 1 WHERE `id` = Cast('20576785830132056064'AS Binary(20));
|
||
UPDATE `rec_loan`.`sys_option` SET `option_val` = 'null:HZFYX:007', `option_txt` = 'null:HZFYX:007', `option_ord` = 7, `option_desc` = '合作方影像', `select_id` = '20564456180739473408', `create_user` = '00000000', `create_org` = '999999', `create_time` = '2022-01-05 15:01:27', `create_date` = '2037-12-07', `update_user` = '007001', `update_org` = '007', `update_time` = '2022-01-09 10:48:25', `update_date` = '2031-01-21', `cur_vers` = 1 WHERE `id` = Cast('20576785949816520704'AS Binary(20));
|
||
DELETE FROM `rec_loan`.`sys_option` WHERE id ='20617685846044180480'; |