dev/2020/2020-022(OK)/2020-022-ljy-002.sql

use dcp;

UPDATE dcp.sys_dict SET DICT_DISP_ORDER='4' WHERE DICT_TYPE_ID=(SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='RESEARCH_RESULT_TYPE_DICT') AND DICT_VALUE='engineering research';

UPDATE dcp.sys_dict SET DICT_DISP_ORDER='3' WHERE DICT_TYPE_ID=(SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='RESEARCH_RESULT_TYPE_DICT') AND DICT_VALUE='technical study';

INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='RESEARCH_RESULT_TYPE_DICT'),'一带一路','B&R','0','Y','一带一路','1',now(),'1',now() FROM DUAL);

UPDATE dcp.sys_dict SET DICT_DISP_ORDER='4' WHERE DICT_TYPE_ID=(SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='RESEARCH_RESULT_TYPE_DICT_EN') AND DICT_VALUE='engineering research';

UPDATE dcp.sys_dict SET DICT_DISP_ORDER='3' WHERE DICT_TYPE_ID=(SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='RESEARCH_RESULT_TYPE_DICT_EN') AND DICT_VALUE='technical study';

INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='RESEARCH_RESULT_TYPE_DICT_EN'),'The Belt and Road','B&R','0','Y','The Belt and Road','1',now(),'1',now() FROM DUAL);

-- 159，161已执行