-- 20201014 delete from sys_dict where codeType ='subsidyBusinessType' and codeValue in('006','007','008'); INSERT INTO `sys_dict` ( `isActive`, `updateTime`, `updateflag`, `codeType`, `tableName`, `description`, `codeValue`, `label`, `seq`) VALUES ('1', now(), true, 'subsidyBusinessType', NULL, '琛ヨ创涓氬姟绫诲瀷', '006', '璧勬牸璇佸钩鍙版湇鍔¤垂', '6'), ('1', now(), true, 'subsidyBusinessType', NULL, '琛ヨ创涓氬姟绫诲瀷', '007', '绛夌骇璇佺粨涓氳瘉骞冲彴鏈嶅姟璐�', '7'), ('1', now(), true, 'subsidyBusinessType', NULL, '琛ヨ创涓氬姟绫诲瀷', '008', '绛夌骇璇侀壌瀹氳瘉骞冲彴鏈嶅姟璐�', '8'); delete from sys_dict where codeType ='grantState'; INSERT INTO `sys_dict` ( `isActive`, `updateTime`, `updateflag`, `codeType`, `tableName`, `description`, `codeValue`, `label`, `seq`) VALUES ('1', now(), true, 'grantState', NULL, '琛ヨ创鍙戞斁鐘舵€�', '1', '宸插彂鏀�', '1'), ('1', now(), true, 'grantState', NULL, '琛ヨ创鍙戞斁鐘舵€�', '0', '鏈彂鏀�', '2'); -- INSERT INTO `sys_dict` ( `isActive`, `updateTime`, `updateflag`, `codeType`, `tableName`, `description`, `codeValue`, `label`, `seq`)VALUES -- ('1', now(), true, 'subsidyStatus', NULL, '琛ヨ创姣斿鐘舵€�', '05', '鍏ず涓嶉€氳繃', '5'); -- -- INSERT INTO `sys_dict` ( `isActive`, `updateTime`, `updateflag`, `codeType`, `tableName`, `description`, `codeValue`, `label`, `seq`)VALUES -- ('1', now(), true, 'cerCompareStatus', NULL, '琛ヨ创姣斿鐘舵€�', '05', '鍏ず涓嶉€氳繃', '5'); -- -- INSERT INTO `sys_dict` ( `isActive`, `updateTime`, `updateflag`, `codeType`, `tableName`, `description`, `codeValue`, `label`, `seq`)VALUES -- ('1', now(), true, 'compareStatus', NULL, '琛ヨ创姣斿鐘舵€�', '05', '鍏ず涓嶉€氳繃', '5'); -- #骞冲彴鏈嶅姟璐� 20201026 delete from subsidyconfig where businesstype in ('006','007','008'); INSERT INTO `subsidyconfig` (`active`, `create_time`, `update_time`, `update_by`, `businessType`, `businessName`, `amount`, `percent`, `EffectiveTime`) VALUES ('', now(), now(), 'bj_super', '006', '璧勬牸璇佸钩鍙版湇鍔¤垂', '40', NULL, NULL), ('', now(), now(), 'bj_super', '007', '绛夌骇璇佺粨涓氳瘉骞冲彴鏈嶅姟璐�', '300', NULL, NULL), ('', now(), now(), 'bj_super', '008', '绛夌骇璇侀壌瀹氳瘉骞冲彴鏈嶅姟璐�', '500', NULL, NULL);