2020-021-ljy-001.sql 1.0 KB

123456
  1. USE DCP;
  2. 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('调研资源对接方式(英文)','DOCKING_MODE_DICT_EN','2','Y','调研资源对接方式(英文)','1',now(),'1',now());
  3. 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='DOCKING_MODE_DICT_EN'),'This unit docking','dbwdj','2','Y','This unit docking','1',now(),'1',now() FROM DUAL);
  4. 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='DOCKING_MODE_DICT_EN'),'GEIDCO docking','hzzzdj','2','Y','GEIDCO docking','1',now(),'1',now() FROM DUAL);
  5. -- 159,161 已执行