12345678910111213141516 |
- 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('智库咨询需求类型','THINK_TANK_TYPE_DICT','1','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='THINK_TANK_TYPE_DICT'),'市场调研','scdy','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='THINK_TANK_TYPE_DICT'),'项目咨询','xmzx','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='THINK_TANK_TYPE_DICT'),'技术交流','jsjl','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='THINK_TANK_TYPE_DICT'),'规划研究','ghyj','1','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('智库咨询需求类型(英)','THINK_TANK_TYPE_DICT_EN','2','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='THINK_TANK_TYPE_DICT_EN'),'Market Research','scdy','1','Y','Market Research','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='THINK_TANK_TYPE_DICT_EN'),'Project Consultation','xmzx','1','Y','Project Consultation','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='THINK_TANK_TYPE_DICT_EN'),'Technical Exchange','jsjl','1','Y','Technical Exchange','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='THINK_TANK_TYPE_DICT_EN'),'Planning Research','ghyj','1','Y','Planning Research','1',now(),'1',now() FROM DUAL);
- -- 159,161已执行
|