dev/2020/2020-017(OK)/2020-017-wzw-001.sql

/*161 159已执行  2020年11月24日 14:19:06*/

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 ('委员会信息发布发布渠道', 'CHANNEL_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='CHANNEL_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='CHANNEL_DICT'),'APP','2','2','Y','APP','1',now(),'1',now() FROM DUAL);

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 ('委员会信息发布发布渠道-英文', 'CHANNEL_DICT_EN', 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='CHANNEL_DICT_EN'),'Web','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='CHANNEL_DICT_EN'),'APP','2','2','Y','APP','1',now(),'1',now() FROM DUAL);

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 ('委员会活动类型代码', 'COMMITTEE_ACTIVITY_TYPE', 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='COMMITTEE_ACTIVITY_TYPE'),'委员会活动','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='COMMITTEE_ACTIVITY_TYPE'),'委员会动态','2','2','Y','委员会动态','1',now(),'1',now() FROM DUAL);

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 ('委员会活动类型代码-英文', 'COMMITTEE_ACTIVITY_TYPE_EN', 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='COMMITTEE_ACTIVITY_TYPE_EN'),'Committee activities','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='COMMITTEE_ACTIVITY_TYPE_EN'),'Committee dynamics','2','2','Y','委员会动态','1',now(),'1',now() FROM DUAL);

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 ('委员会类型代码', 'COMMITTEE_CATEGORIES_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='COMMITTEE_CATEGORIES_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='COMMITTEE_CATEGORIES_DICT'),'区域委员会','2','2','Y','区域委员会','1',now(),'1',now() FROM DUAL);

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 ('委员会类型代码-英文', 'COMMITTEE_CATEGORIES_DICT_EN', 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='COMMITTEE_CATEGORIES_DICT_EN'),'National Committee','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='COMMITTEE_CATEGORIES_DICT_EN'),'Regional Committee','2','3','Y','区域委员会','1',now(),'1',now() FROM DUAL);

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 ('委员会职务代码', 'COMMITTEE_POST_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='COMMITTEE_POST_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='COMMITTEE_POST_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='COMMITTEE_POST_DICT'),'秘书长','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='COMMITTEE_POST_DICT'),'委员','4','4','Y','委员','1',now(),'1',now() FROM DUAL);

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 ('委员会职务代码-英文', 'COMMITTEE_POST_DICT_EN', 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='COMMITTEE_POST_DICT_EN'),'Chairman','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='COMMITTEE_POST_DICT_EN'),'Vice Chairman','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='COMMITTEE_POST_DICT_EN'),'Secretary General','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='COMMITTEE_POST_DICT_EN'),'Committee member','4','4','Y','委员','1',now(),'1',now() FROM DUAL);

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 ('委员会区域代码', 'COMMITTEE_REGIONAL_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='COMMITTEE_REGIONAL_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='COMMITTEE_REGIONAL_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='COMMITTEE_REGIONAL_DICT'),'欧洲','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='COMMITTEE_REGIONAL_DICT'),'东欧-中亚','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='COMMITTEE_REGIONAL_DICT'),'东南亚-南亚','5','5','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='COMMITTEE_REGIONAL_DICT'),'北美','6','6','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='COMMITTEE_REGIONAL_DICT'),'中南美','7','7','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='COMMITTEE_REGIONAL_DICT'),'大洋洲','8','8','Y','大洋洲','1',now(),'1',now() FROM DUAL);


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 ('委员会区域代码-英文', 'COMMITTEE_REGIONAL_DICT_EN', 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='COMMITTEE_REGIONAL_DICT_EN'),'Africa','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='COMMITTEE_REGIONAL_DICT_EN'),'West Asia-North Africa','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='COMMITTEE_REGIONAL_DICT_EN'),'European','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='COMMITTEE_REGIONAL_DICT_EN'),'Eastern Europe-Central Asia','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='COMMITTEE_REGIONAL_DICT_EN'),'Southeast Asia-South Asia','5','5','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='COMMITTEE_REGIONAL_DICT_EN'),'North American','6','6','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='COMMITTEE_REGIONAL_DICT_EN'),'Central and South American','7','7','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='COMMITTEE_REGIONAL_DICT_EN'),'Oceania','8','8','Y','大洋洲','1',now(),'1',now() FROM DUAL);

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 ('委员会单位职务代码', 'COMMITTEE_UNIT_POST_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='COMMITTEE_UNIT_POST_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='COMMITTEE_UNIT_POST_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='COMMITTEE_UNIT_POST_DICT'),'副主席单位','3','3','Y','3','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='COMMITTEE_UNIT_POST_DICT'),'委员单位','4','4','Y','委员单位','1',now(),'1',now() FROM DUAL);

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 ('委员会单位职务代码-英文', 'COMMITTEE_UNIT_POST_DICT_EN', 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='COMMITTEE_UNIT_POST_DICT_EN'),'Supporting agency','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='COMMITTEE_UNIT_POST_DICT_EN'),'Chairman Unit','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='COMMITTEE_UNIT_POST_DICT_EN'),'Vice Chairman Unit','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='COMMITTEE_UNIT_POST_DICT_EN'),'Member unit','4','4','Y','委员单位','1',now(),'1',now() FROM DUAL);

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 ('委员会信息发布所属模块', 'MODULE_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='MODULE_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='MODULE_DICT'),'区域委员会','1A','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='MODULE_DICT'),'国家委员会','1B','5','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='MODULE_DICT'),'区域委员会简介','1AA','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='MODULE_DICT'),'区域委员会职责','1AB','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='MODULE_DICT'),'国家委员会简介','1BA','6','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='MODULE_DICT'),'国家委员会职责','1BB','7','Y','国家委员会职责','1',now(),'1',now() FROM DUAL);

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 ('委员会信息发布所属模块-英文', 'MODULE_DICT_EN', 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='MODULE_DICT_EN'),'About the Committee','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='MODULE_DICT_EN'),'Regional Committee','1A','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='MODULE_DICT_EN'),'Introduction to Regional Committees','1AA','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='MODULE_DICT_EN'),'Responsibilities of the Regional Committee','1AB','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='MODULE_DICT_EN'),'National Committee','1B','5','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='MODULE_DICT_EN'),'National Committee Introduction','1BA','6','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='MODULE_DICT_EN'),'National Committee Responsibilities','1BB','7','Y','国家委员会职责','1',now(),'1',now() FROM DUAL);

/*161 159已执行  2020年11月24日 14:19:06*/