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('金融服务信息分类','FINANCIAL_INSTITUTION_TYPE_DICT',NULL,'Y','','1',now(),'1',now());
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='FINANCIAL_INSTITUTION_TYPE_DICT'),'产品与服务','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='FINANCIAL_INSTITUTION_TYPE_DICT'),'投融资案例','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='FINANCIAL_INSTITUTION_TYPE_DICT'),'机构动态','3','3','Y','','1',now(),'1',now() FROM DUAL);
-- 已执行159、161环境
