doc/DB/data/insert_alert.sql

# 时间:20211009 是否已发版: 测试- 是  生产-否
ALTER TABLE `zc_finance_record` ADD `zfr_reason` varchar(300) DEFAULT NULL COMMENT '拒绝放款理由';


ALTER TABLE `pay_acc_inf` ADD `pai_accno_name` varchar(300) DEFAULT NULL COMMENT '账户名称';
ALTER TABLE `pay_acc_inf` ADD `pai_bank_name` varchar(300) DEFAULT NULL COMMENT '银行名称';
ALTER TABLE `pay_acc_detail` ADD `PAD_STATE` varchar(2) DEFAULT NULL COMMENT '状态（00：交易中 01：成功 02：失败）';
ALTER TABLE `pay_acc_detail` ADD `pad_business_id` varchar(64) DEFAULT NULL COMMENT '业务表主键';
ALTER TABLE `pay_acc_detail` ADD `pad_tar_count` varchar(64) DEFAULT NULL COMMENT '交易查询次数';
ALTER TABLE `pay_acc_detail` ADD `pad_pay_count` varchar(64) DEFAULT NULL COMMENT '转账查询次数';

# 时间:20211012 是否已发版: 测试- 是  生产-否
UPDATE sys_menu SET parent_id = '0',order_num = '3' WHERE menu_id = '2517';
UPDATE sys_menu SET parent_id = '0',order_num = '4',path = 'Bill/creditLine' WHERE menu_id = '2530';
UPDATE sys_menu SET parent_id = '0',order_num = '5', path = 'Bill/Bill' WHERE menu_id = '2518';
UPDATE sys_menu SET parent_id = '0',order_num = '6' WHERE menu_id = '2528';
UPDATE sys_menu SET parent_id = '0',order_num = '7', path = 'Bill/contract' WHERE menu_id = '2544';
UPDATE sys_menu SET parent_id = '0',order_num = '8' WHERE menu_id = '2546';
UPDATE sys_menu SET parent_id = '0',order_num = '9' WHERE menu_id = '2575';
UPDATE sys_menu SET parent_id = '0',order_num = '10', path = 'Bill/rel' WHERE menu_id = '2536';
UPDATE sys_menu SET parent_id = '0',order_num = '11' WHERE menu_id = '2591';
UPDATE sys_menu SET parent_id = '0',order_num = '12',path = 'Bill/costManage' WHERE menu_id = '2576';

# 时间:20211013 是否已发版: 测试- 是  生产-否
delete from sys_company where scy_id = '000000';
insert into `sys_company` (`scy_id`, `scy_license_file`, `scy_name`, `scy_social_code`, `scy_registered_capital`, `scy_start_time`, `scy_end_time`, `scy_address`, `scy_phone`, `scy_legal_file`, `scy_legal_back_file`, `scy_legal`, `scy_legal_id`, `scy_authorization_file`, `scy_commitment_file`, `scy_appendix_file`, `scy_type`, `scy_industry`, `scy_scale`, `scy_organization`, `scy_manager`, `scy_cfca_user_id`, `scy_cfca_auth_number`, `scy_cfca_bank_time`, `scy_remarks`, `scy_auth_status`, `scy_status`, `create_by`, `create_time`, `update_by`, `update_time`, `scy_contract_id`) values('000000',NULL,'招采云链（山东）信息服务有限公司','','无','','无','中国（山东）自由贸易试验区济南片区汉峪金谷A3-1-1401','18810133746',NULL,NULL,'丛美红','',NULL,NULL,NULL,'00',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,'01','00',NULL,NULL,NULL,NULL,NULL);


UPDATE sys_user SET email = 'congmeihong@zcylian.com' WHERE user_id = '1' 

insert into `pay_acc_inf` (`PAI_CSTNO`, `PAI_ACCNO`, `PAI_VERSION`, `PAI_STATUS`, `PAI_BALANCE`, `PAI_AVABALANCE`, `PAI_ACCTYPE`, `PAI_CRYTYPE`, `PAI_QLBANKNO`, `PAI_QLBANKNAME`, `create_by`, `create_time`, `update_by`, `update_time`, `pai_accno_name`, `pai_bank_name`) values('000000','3115730025233104147','1','2','0.00','0.00','07','CNY','302','中信银行',NULL,'2021-10-09 15:07:55',NULL,NULL,'招采云链（山东）信息服务有限公司','中信银行');
insert into `pay_acc_inf` (`PAI_CSTNO`, `PAI_ACCNO`, `PAI_VERSION`, `PAI_STATUS`, `PAI_BALANCE`, `PAI_AVABALANCE`, `PAI_ACCTYPE`, `PAI_CRYTYPE`, `PAI_QLBANKNO`, `PAI_QLBANKNAME`, `create_by`, `create_time`, `update_by`, `update_time`, `pai_accno_name`, `pai_bank_name`) values('000000','3115730025233104148','1','2','0.00','0.00','09','CNY','302','中信银行',NULL,'2021-10-09 15:07:55',NULL,NULL,'招采云链（山东）信息服务有限公司','中信银行');
insert into `pay_acc_inf` (`PAI_CSTNO`, `PAI_ACCNO`, `PAI_VERSION`, `PAI_STATUS`, `PAI_BALANCE`, `PAI_AVABALANCE`, `PAI_ACCTYPE`, `PAI_CRYTYPE`, `PAI_QLBANKNO`, `PAI_QLBANKNAME`, `create_by`, `create_time`, `update_by`, `update_time`, `pai_accno_name`, `pai_bank_name`) values('000000','3115730025230000214','1','2','0.00','0.00','06','CNY','302','中信银行',NULL,'2021-10-09 15:07:55',NULL,NULL,'招采云链（山东）信息服务有限公司','中信银行');

# 时间:20211018 是否已发版: 测试- 是  生产-否
UPDATE sys_menu SET parent_id = '0',order_num = '3', path = 'Bill/repayment' WHERE menu_id = '2567';
UPDATE sys_menu SET parent_id = '0',order_num = '4', path = 'Bill/financeRecord' WHERE menu_id = '2569';
UPDATE sys_menu SET parent_id = '6',order_num = '2' WHERE menu_id = '2652';
UPDATE sys_menu SET parent_id = '6',order_num = '3' WHERE menu_id = '2648';
UPDATE sys_menu SET parent_id = '6',order_num = '4' WHERE menu_id = '2650';
UPDATE sys_menu SET parent_id = '6',order_num = '5' WHERE menu_id = '2649';
UPDATE sys_menu SET parent_id = '6',order_num = '6' WHERE menu_id = '2521';
DELETE FROM sys_menu WHERE menu_id = '2647';