use dcp;
INSERT INTO `dcp`.`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 ('入会流程字典', 'ADMISSION_PROCESS', 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='ADMISSION_PROCESS'),'入会申请','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='ADMISSION_PROCESS'),'初步审核','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='ADMISSION_PROCESS'),'会员确认','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='ADMISSION_PROCESS'),'颁发证书','4','4','Y','办法证书','1',now(),'1',now() FROM DUAL);