dev/2020/2020-009(OK)/2020-009-cf-001.sql

use dcp;
INSERT INTO `sys_dict_type` (`DICT_TYPE_NAME`, `DICT_TYPE_CODE`, `DICT_TYPE_DISP_ORDER`, `DICT_TYPE_STATUS`, `DICT_TYPE_DESCRIPTION`, `CREATE_USER_ID`, `CREATE_TIME`, `UPDATE_USER_ID`, `UPDATE_TIME`) VALUES('申请服务类型英文','SERVICE_TYPE_DICT_EN','200','Y','','1','2020-10-10 09:51:00','1','2020-10-10 09:51:00');


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='SERVICE_TYPE_DICT_EN'),'CustomService','1','1','Y','定制服务','1',now(),'1',now() FROM DUAL);
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='SERVICE_TYPE_DICT_EN'),'FundingNegotiation','2','2','Y','资助洽商','1',now(),'1',now() FROM DUAL);


INSERT INTO `sys_dict_type` (`DICT_TYPE_NAME`, `DICT_TYPE_CODE`, `DICT_TYPE_DISP_ORDER`, `DICT_TYPE_STATUS`, `DICT_TYPE_DESCRIPTION`, `CREATE_USER_ID`, `CREATE_TIME`, `UPDATE_USER_ID`, `UPDATE_TIME`) VALUES('申请服务子类型英文','SERVICE_CHILD_TYPE_DICT_EN','200','Y','','1','2020-10-10 09:51:00','1','2020-10-10 09:51:00');


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='SERVICE_CHILD_TYPE_DICT_EN'),'Exclusive Services','1','1','Y','','1',now(),'1',now() FROM DUAL);
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='SERVICE_CHILD_TYPE_DICT_EN'),'Special Research','2','2','Y','','1',now(),'1',now() FROM DUAL);
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='SERVICE_CHILD_TYPE_DICT_EN'),'Personalized Service','3','3','Y','','1',now(),'1',now() FROM DUAL);
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='SERVICE_CHILD_TYPE_DICT_EN'),'Customized Consultation','4','4','Y','','1',now(),'1',now() FROM DUAL);
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='SERVICE_CHILD_TYPE_DICT_EN'),'Joint Organization','5','5','Y','','1',now(),'1',now() FROM DUAL);


INSERT INTO `sys_dict_type` (`DICT_TYPE_NAME`, `DICT_TYPE_CODE`, `DICT_TYPE_DISP_ORDER`, `DICT_TYPE_STATUS`, `DICT_TYPE_DESCRIPTION`, `CREATE_USER_ID`, `CREATE_TIME`, `UPDATE_USER_ID`, `UPDATE_TIME`) VALUES('资助方式英文代码','SUPPORT_WAY_DICT_EN','200','Y','','1','2020-10-10 09:51:00','1','2020-10-10 09:51:00');

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='SUPPORT_WAY_DICT_EN'),'Donation Of Funds','1','1','Y','','1',now(),'1',now() FROM DUAL);
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='SUPPORT_WAY_DICT_EN'),'Material Donation','2','2','Y','','1',now(),'1',now() FROM DUAL);