/*2020年11月24日 16:20:30生成 生产Sql ljh*/
USE DCP;
SET NAMES utf8mb4;
use dcp;
create table base_investment_guidelines_entity_20201124 as select * from base_investment_guidelines_entity;
create table base_investment_guidelines_info_20201124 as select * from base_investment_guidelines_info;
create table sys_dict_type_20201124 as select * from sys_dict_type;
create table sys_dict_20201124 as select * from sys_dict;
create table auth_privilege_20201124 as select * from auth_privilege;
create table cms_information_entity_20201124 as select * from cms_information_entity;
SET FOREIGN_KEY_CHECKS = 0;

ALTER TABLE `dcp`.`base_investment_guidelines_entity`
MODIFY COLUMN `countries` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '重点关注国家' AFTER `introduction`;
ALTER TABLE `dcp`.`base_investment_guidelines_info`
MODIFY COLUMN `countries` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '重点关注国家' AFTER `introduction`;
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_INSTITUTIONS_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='FINANCIAL_INSTITUTIONS_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_INSTITUTIONS_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_INSTITUTIONS_TYPE_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='FINANCIAL_INSTITUTIONS_TYPE_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='FINANCIAL_INSTITUTIONS_TYPE_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='FINANCIAL_INSTITUTIONS_TYPE_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='FINANCIAL_INSTITUTIONS_TYPE_DICT'),'外资银行','7','7','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('金融机构英文类型字典代码','FINANCIAL_INSTITUTIONS_TYPE_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='FINANCIAL_INSTITUTIONS_TYPE_DICT_EN'),'Foreign banks','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='FINANCIAL_INSTITUTIONS_TYPE_DICT_EN'),'Multilateral Investment Guarantee Agency (MIGA)','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='FINANCIAL_INSTITUTIONS_TYPE_DICT_EN'),'International financial institutions','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='FINANCIAL_INSTITUTIONS_TYPE_DICT_EN'),'Fund and other investment institutions','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='FINANCIAL_INSTITUTIONS_TYPE_DICT_EN'),'Domestic commercial banks','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='FINANCIAL_INSTITUTIONS_TYPE_DICT_EN'),'Guarantee institution','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_INSTITUTIONS_TYPE_DICT_EN'),'Policy oriented and development oriented banks','1','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('投资指引状态字典','INVESTMENT_GUIDE_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='INVESTMENT_GUIDE_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='INVESTMENT_GUIDE_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='INVESTMENT_GUIDE_DICT'),'已撤回','3','3','Y','','1',now(),'1',now() FROM DUAL);
INSERT INTO auth_privilege ( APPLICATION_ID, PRIVILEGE_KEY, PRIVILEGE_NAME, PRIVILEGE_TYPE_DICT, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME,PRIVILEGE_DISPLAY_ORDER,PRIVILEGE_PARENT_ID,PRIVILEGE_ICON,PRIVILEGE_URL,PRIVILEGE_STATUS ) (SELECT 2,'ITIM.DEVELOPMENT.FINANCE.ADD','金融机构维护','1','1',now(),'1',now(),1,(SELECT max(PRIVILEGE_ID) FROM auth_privilege WHERE PRIVILEGE_KEY='ITIM.DEVELOPMENT.FINANCE'),'fa-dashboard','BaseFinancialInstitutionEntityList','0' FROM DUAL);
INSERT INTO auth_privilege ( APPLICATION_ID, PRIVILEGE_KEY, PRIVILEGE_NAME, PRIVILEGE_TYPE_DICT, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME,PRIVILEGE_DISPLAY_ORDER,PRIVILEGE_PARENT_ID,PRIVILEGE_ICON,PRIVILEGE_URL,PRIVILEGE_STATUS ) (SELECT 2,'ITIM.DEVELOPMENT.FINANCE.INVESTMENT','投资指引管理','1','1',now(),'1',now(),2,(SELECT max(PRIVILEGE_ID) FROM auth_privilege WHERE PRIVILEGE_KEY='ITIM.DEVELOPMENT.FINANCE'),'fa-dashboard','BaseInvestmentGuidelinesEntityList','0' FROM DUAL);
INSERT INTO auth_privilege ( APPLICATION_ID, PRIVILEGE_KEY, PRIVILEGE_NAME, PRIVILEGE_TYPE_DICT, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME,PRIVILEGE_DISPLAY_ORDER,PRIVILEGE_PARENT_ID,PRIVILEGE_ICON,PRIVILEGE_URL,PRIVILEGE_STATUS ) (SELECT 2,'ITIM.DEVELOPMENT.FINANCE.PROJECT','项目评估报告管理','1','1',now(),'1',now(),3,(SELECT max(PRIVILEGE_ID) FROM auth_privilege WHERE PRIVILEGE_KEY='ITIM.DEVELOPMENT.FINANCE'),'fa-dashboard','BaseProjectEvaluationReportEntityList','0' FROM DUAL);
INSERT INTO auth_privilege ( APPLICATION_ID, PRIVILEGE_KEY, PRIVILEGE_NAME, PRIVILEGE_TYPE_DICT, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME,PRIVILEGE_DISPLAY_ORDER,PRIVILEGE_PARENT_ID,PRIVILEGE_ICON,PRIVILEGE_URL,PRIVILEGE_STATUS ) (SELECT 2,'ITIM.DEVELOPMENT.FINANCE.FUND','基金思路管理','1','1',now(),'1',now(),4,(SELECT max(PRIVILEGE_ID) FROM auth_privilege WHERE PRIVILEGE_KEY='ITIM.DEVELOPMENT.FINANCE'),'fa-dashboard','BaseFundIdeasEntityList','0' FROM DUAL);
update auth_privilege set PRIVILEGE_URL='FinancialShowList' where PRIVILEGE_KEY = 'ITIM.DEVELOPMENT.FINANCE.EDIT';
update auth_privilege set PRIVILEGE_URL='FinancialShowApproveList' where PRIVILEGE_KEY = 'ITIM.DEVELOPMENT.FINANCE.APPROVAL';
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('适用平台类型','SOFTWARE_PLATFORM_TYPE_DICT','7','Y','','1','2020-11-24 9:25:05','1','2020-11-24 9:25:05');
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='SOFTWARE_PLATFORM_TYPE_DICT'),'IOS','IOS','1','Y','iOS','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='SOFTWARE_PLATFORM_TYPE_DICT'),'android','android','1','Y','android','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='SOFTWARE_PLATFORM_TYPE_DICT'),'common','common','1','Y','common','1',now(),'1',now() FROM DUAL);
UPDATE auth_privilege a
SET a.PRIVILEGE_URL = 'BaseThinkTankEntityList'
WHERE a.PRIVILEGE_NAME = '智库咨询维护';

CREATE VIEW base_portal_model_follow_info_groupby_userId
AS
select user_id,count(1) as nums
from base_portal_model_follow_info
GROUP BY user_id;
CREATE VIEW base_portal_model_follow_info_groupby_model
AS
select model_type,model_entity_id,count(1) as nums
from base_portal_model_follow_info
GROUP BY model_type,model_entity_id;

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('研究成果类型','RESEARCH_RESULT_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='RESEARCH_RESULT_TYPE_DICT'),'战略研究','strategic research','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='RESEARCH_RESULT_TYPE_DICT'),'规划研究','planning research','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='RESEARCH_RESULT_TYPE_DICT'),'工程研究','engineering research','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='RESEARCH_RESULT_TYPE_DICT'),'技术研究','technical study','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='RESEARCH_RESULT_TYPE_DICT'),'政策研究','policy research','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='RESEARCH_RESULT_TYPE_DICT'),'国别研究','country study','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='RESEARCH_RESULT_TYPE_DICT'),'其他专题研究','other thematic studies','7','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('调研资源类型','RESEARCH_RESOURCE_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='RESEARCH_RESOURCE_TYPE_DICT'),'企业展厅','enterprise exhibition hall','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='RESEARCH_RESOURCE_TYPE_DICT'),'电力实验室','electric power laboratory','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='RESEARCH_RESOURCE_TYPE_DICT'),'示范项目','demonstration project','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='RESEARCH_RESOURCE_TYPE_DICT'),'其他调研','other research','4','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('调研资源对接方式','DOCKING_MODE_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='DOCKING_MODE_DICT'),'本单位对接','dbwdj','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='DOCKING_MODE_DICT'),'合作组织对接','hzzzdj','2','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('研究成果类型（英）','RESEARCH_RESULT_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='RESEARCH_RESULT_TYPE_DICT_EN'),'Strategic Research','strategic research','1','Y','Strategic 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='RESEARCH_RESULT_TYPE_DICT_EN'),'Planning Research','planning research','2','Y','Planning 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='RESEARCH_RESULT_TYPE_DICT_EN'),'Engineering Research','engineering research','3','Y','Engineering 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='RESEARCH_RESULT_TYPE_DICT_EN'),'Technical Research','technical study','4','Y','Technical 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='RESEARCH_RESULT_TYPE_DICT_EN'),'Policy Research','policy research','5','Y','Policy 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='RESEARCH_RESULT_TYPE_DICT_EN'),'Country Research','country study','6','Y','Country 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='RESEARCH_RESULT_TYPE_DICT_EN'),'Other Thematic Researchs','other thematic studies','7','Y','Other Thematic Researchs','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('调研资源类型（英文）','RESEARCH_RESOURCE_TYPE_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='RESEARCH_RESOURCE_TYPE_DICT_EN'),'Enterprise Exhibition Hall','enterprise exhibition hall','1','Y','Enterprise Exhibition Hall','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='RESEARCH_RESOURCE_TYPE_DICT_EN'),'Electric Power Laboratory','electric power laboratory','2','Y','Electric Power Laboratory','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='RESEARCH_RESOURCE_TYPE_DICT_EN'),'Demonstration Project','demonstration project','3','Y','Demonstration Project','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='RESEARCH_RESOURCE_TYPE_DICT_EN'),'Other Research','other research','4','Y','Other Research','1',now(),'1',now() FROM DUAL);

SELECT
	CONCAT(
	"INSERT INTO auth_privilege ( APPLICATION_ID, PRIVILEGE_KEY, PRIVILEGE_NAME, PRIVILEGE_TYPE_DICT, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME,PRIVILEGE_DISPLAY_ORDER,PRIVILEGE_PARENT_ID,PRIVILEGE_ICON,PRIVILEGE_URL,PRIVILEGE_STATUS ) (SELECT ",
	APPLICATION_ID,
	",'",
	PRIVILEGE_KEY,
	"','",
	PRIVILEGE_NAME,
	"','",
	PRIVILEGE_TYPE_DICT,
	"','1',now(),'1',now(),",
	PRIVILEGE_DISPLAY_ORDER,
	",(SELECT max(PRIVILEGE_ID) FROM auth_privilege WHERE PRIVILEGE_KEY='ITIM.COOPERATION'),'",
	PRIVILEGE_ICON,
	"','",
	PRIVILEGE_URL,
	"','",
	PRIVILEGE_STATUS,
	"' FROM DUAL);"
) AS psql
FROM
	auth_privilege
WHERE
	application_id = 2
	AND privilege_key = 'ITIM.COOPERATION.SHARE.STUDYRESULT'
ORDER BY
	privilege_layer_code;

SELECT
	CONCAT(
	"INSERT INTO auth_privilege ( APPLICATION_ID, PRIVILEGE_KEY, PRIVILEGE_NAME, PRIVILEGE_TYPE_DICT, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME,PRIVILEGE_DISPLAY_ORDER,PRIVILEGE_PARENT_ID,PRIVILEGE_ICON,PRIVILEGE_URL,PRIVILEGE_STATUS ) (SELECT ",
	APPLICATION_ID,
	",'",
	PRIVILEGE_KEY,
	"','",
	PRIVILEGE_NAME,
	"','",
	PRIVILEGE_TYPE_DICT,
	"','1',now(),'1',now(),",
	PRIVILEGE_DISPLAY_ORDER,
	",(SELECT max(PRIVILEGE_ID) FROM auth_privilege WHERE PRIVILEGE_KEY='ITIM.COOPERATION'),'",
	PRIVILEGE_ICON,
	"','",
	PRIVILEGE_URL,
	"','",
	PRIVILEGE_STATUS,
	"' FROM DUAL);"
) AS psql
FROM
	auth_privilege
WHERE
	application_id = 2
	AND privilege_key = 'ITIM.COOPERATION.SHARE.SURVEY'
ORDER BY
	privilege_layer_code;
	
UPDATE auth_privilege SET PRIVILEGE_URL='BaseResearchResultInfoList' WHERE PRIVILEGE_KEY = 'ITIM.COOPERATION.SHARE.STUDYRESULT';
UPDATE auth_privilege SET PRIVILEGE_URL='BaseResearchResourcesInfoList' WHERE PRIVILEGE_KEY = 'ITIM.COOPERATION.SHARE.SURVEY';

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);

SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for committee_activity_entity
-- ----------------------------
DROP TABLE IF EXISTS `committee_activity_entity`;
CREATE TABLE `committee_activity_entity`  (
  `id` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '委员会信息发布实体id',
  `activity_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '活动名称',
  `activity_start_time` datetime(0) NULL DEFAULT NULL COMMENT '活动开始时间',
  `activity_end_time` datetime(0) NULL DEFAULT NULL COMMENT '活动结束时间',
  `activity_type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '活动类型',
  `activity_type_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '活动类型代码',
  `committee_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属委员会名称',
  `committee_id` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属委员会id',
  `continent` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属区域（委员会）',
  `continent_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属区域代码（委员会）',
  `distribution_channels` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发布渠道',
  `num` bigint(20) NULL DEFAULT 0 COMMENT '浏览量',
  `status` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',
  `entity_zh` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '中文 0代表无，1代表有',
  `entity_en` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '英文',
  `entity_fr` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '法文',
  `entity_de` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '德文文',
  `entity_es` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '西班牙文',
  `entity_ja` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '日文',
  `entity_ar` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '阿拉伯文',
  `entity_ru` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '俄文',
  `sort` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '排序',
  `main_language` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主语言',
  `spare_one` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段1',
  `spare_two` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段2',
  `spare_three` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段3',
  `spare_four` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段4',
  `spare_five` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段5',
  `create_by` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者',
  `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新者',
  `update_date` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
)   COMMENT = '委员会活动实体表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for committee_activity_info
-- ----------------------------
DROP TABLE IF EXISTS `committee_activity_info`;
CREATE TABLE `committee_activity_info`  (
  `id` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '实体id',
  `activity_type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '活动类型',
  `activity_type_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '活动类型代码',
  `committee_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属委员会名称',
  `order_number` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属委员会联级id',
  `continent` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属区域（委员会）',
  `continent_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属区域代码（委员会）',
  `num` bigint(20) NULL DEFAULT 0 COMMENT '浏览次数',
  `committee_id` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属委员会id',
  `activity_time` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '活动时间范围',
  `activity_start_time` datetime(0) NULL DEFAULT NULL COMMENT '活动开始时间',
  `activity_end_time` datetime(0) NULL DEFAULT NULL COMMENT '活动结束时间',
  `activity_place` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '活动地点',
  `registration_time` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '报名时间范围',
  `registration_start_time` datetime(0) NULL DEFAULT NULL COMMENT '活动报名开始时间',
  `registration_end_time` datetime(0) NULL DEFAULT NULL COMMENT '活动报名结束时间',
  `registration_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '报名链接',
  `activity_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '活动名称',
  `activity_logo` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '活动封面',
  `activity_introduction` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '活动简介',
  `activity_introduction_ue` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '活动简介-ue',
  `show_flag` char(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'y' COMMENT '是否宣传区',
  `activity_preview_template` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '活动预告-模板',
  `activity_preview` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '活动预告',
  `activity_preview_ue` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '活动预告-ue',
  `activity_review_template` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '活动回顾模板',
  `activity_review` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '活动回顾',
  `activity_review_ue` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '活动回顾-ue',
  `pictures_id` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '精彩回顾图片id',
  `pictures` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '精彩回顾图片',
  `distribution_channels` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发布渠道',
  `status` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',
  `sort` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '排序',
  `entity_id` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关联实体id',
  `language` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '语言',
  `spare_one` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段1',
  `spare_two` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段2',
  `spare_three` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段3',
  `spare_four` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段4',
  `spare_five` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段5',
  `create_by` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者',
  `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新者',
  `update_date` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
)   COMMENT = '委员会活动信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for committee_basis_entity
-- ----------------------------
DROP TABLE IF EXISTS `committee_basis_entity`;
CREATE TABLE `committee_basis_entity`  (
  `id` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '委员会实体id',
  `committee_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '委员会名称',
  `committee_type` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '委员会类型',
  `committee_type_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '委员会类型代码',
  `committee_profile` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '委员会简介',
  `committee_profile_ue` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '委员会简介（带标签）',
  `regional` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属区域',
  `regional_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属区域代码',
  `national_flag` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '国家旗帜（国家委员会独有）',
  `order_number` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联级选择',
  `entity_zh` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '中文 0代表无，1代表有',
  `entity_en` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '英文',
  `entity_fr` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '法文',
  `entity_de` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '德文文',
  `entity_es` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '西班牙文',
  `entity_ja` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '日文',
  `entity_ar` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '阿拉伯文',
  `entity_ru` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '俄文',
  `sort` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '排序',
  `main_language` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主语言',
  `spare_one` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段1',
  `spare_two` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段2',
  `spare_three` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段3',
  `spare_four` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段4',
  `spare_five` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段5',
  `create_by` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者',
  `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新者',
  `update_date` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
)   COMMENT = '委员会实体信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for committee_basis_info
-- ----------------------------
DROP TABLE IF EXISTS `committee_basis_info`;
CREATE TABLE `committee_basis_info`  (
  `id` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '委员会实体id',
  `committee_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '委员会名称',
  `committee_type` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '委员会类型',
  `committee_type_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '委员会类型代码',
  `committee_profile` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '委员会简介',
  `committee_profile_ue` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '委员会简介（带标签）',
  `regional_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属区域代码',
  `regional` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属区域',
  `national_flag` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '国家旗帜（国家委员会独有）',
  `initial_order_zh` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '首字母排序-中文',
  `initial_order_en` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '首字母排序-英文',
  `order_number` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联级排序',
  `sort` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '排序',
  `entity_id` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关联实体id',
  `language` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '语言',
  `spare_one` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段1',
  `spare_two` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段2',
  `spare_three` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段3',
  `spare_four` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段4',
  `spare_five` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段5',
  `create_by` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者',
  `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新者',
  `update_date` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
)   COMMENT = '委员会实体信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for committee_information_release_management_entity
-- ----------------------------
DROP TABLE IF EXISTS `committee_information_release_management_entity`;
CREATE TABLE `committee_information_release_management_entity`  (
  `id` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '委员会信息发布实体id',
  `channel_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发布渠道代码',
  `channel` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发布渠道',
  `module_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属模块代码',
  `module` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属模块',
  `status` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',
  `release_tiem` datetime(0) NULL DEFAULT NULL COMMENT '发布时间',
  `browse_sum` bigint(20) NULL DEFAULT 0 COMMENT '浏览次数',
  `entity_zh` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '中文 0代表无，1代表有',
  `entity_en` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '英文',
  `entity_fr` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '法文',
  `entity_de` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '德文文',
  `entity_es` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '西班牙文',
  `entity_ja` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '日文',
  `entity_ar` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '阿拉伯文',
  `entity_ru` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '俄文',
  `sort` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '排序',
  `main_language` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主语言',
  `spare_one` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段1',
  `spare_two` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段2',
  `spare_three` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段3',
  `spare_four` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段4',
  `spare_five` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段5',
  `create_by` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者',
  `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新者',
  `update_date` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
)   COMMENT = '委员会信息发布实体信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for committee_information_release_management_info
-- ----------------------------
DROP TABLE IF EXISTS `committee_information_release_management_info`;
CREATE TABLE `committee_information_release_management_info`  (
  `id` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '实体id',
  `channel_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发布渠道代码',
  `channel` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发布渠道',
  `release_information` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '发布信息',
  `release_information_ue` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '发布信息-ue',
  `module_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属模块代码',
  `module` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属模块',
  `status` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',
  `release_tiem` datetime(0) NULL DEFAULT NULL COMMENT '发布时间',
  `browse_sum` bigint(20) NULL DEFAULT 0 COMMENT '浏览次数',
  `sort` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '排序',
  `entity_id` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关联实体id',
  `language` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '语言',
  `spare_one` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段1',
  `spare_two` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段2',
  `spare_three` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段3',
  `spare_four` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段4',
  `spare_five` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段5',
  `create_by` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者',
  `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新者',
  `update_date` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
)   COMMENT = '委员会信息发布详细信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for committee_show_message_entity
-- ----------------------------
DROP TABLE IF EXISTS `committee_show_message_entity`;
CREATE TABLE `committee_show_message_entity`  (
  `id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '实体id',
  `correlation_id` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关联id',
  `correlation_type` char(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关联类型',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '中文全称',
  `name_en` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '英文全称',
  `continent` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域（大洲）',
  `continent_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域（大洲）代码',
  `country` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '国家',
  `country_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '国家代码',
  `regional_committee` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域委员会',
  `regional_committee_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域委员会代码',
  `national_committee` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '国家委员会',
  `national_committee_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '国家委员会代码',
  `entity_zh` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '中文 0代表无，1代表有',
  `entity_en` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '英文',
  `entity_fr` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '法文',
  `entity_de` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '德文文',
  `entity_es` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '西班牙文',
  `entity_ja` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '日文',
  `entity_ar` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '阿拉伯文',
  `entity_ru` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '俄文',
  `sort` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '排序',
  `main_language` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主语言',
  `spare_one` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段1',
  `spare_two` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段2',
  `spare_three` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段3',
  `spare_four` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段4',
  `spare_five` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段5',
  `create_by` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者',
  `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新者',
  `update_date` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
)   COMMENT = '委员会展示信息实体信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for committee_show_message_info
-- ----------------------------
DROP TABLE IF EXISTS `committee_show_message_info`;
CREATE TABLE `committee_show_message_info`  (
  `id` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '实体id',
  `language` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '语言',
  `entity_id` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '实体id',
  `correlation_id` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关联id',
  `correlation_type` char(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关联类型',
  `personal_profile` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '个人简介',
  `personal_profile_ue` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '个人简介-ue',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '中文全称',
  `name_en` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '英文全称',
  `continent` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域（大洲）',
  `continent_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域（大洲）代码',
  `country` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '国家',
  `country_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '国家代码',
  `regional_committee` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域委员会',
  `regional_committee_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域委员会代码',
  `region_duty` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域委员会职务',
  `region_duty_dict` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域委员会职务代码',
  `national_committee` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '国家委员会',
  `national_committee_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '国家委员会代码',
  `country_duty` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '国家委员会职务',
  `country_duty_dict` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '国家委员会职务代码',
  `industry` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '行业',
  `industry_dict` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '行业代码',
  `sort` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '排序',
  `city` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '城市',
  `city_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '城市代码',
  `unit_address` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位地址',
  `corporate_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '法人姓名',
  `corporate_id_card` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '法人身份证号码',
  `official_website_path` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '官方网址',
  `link_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系人姓名',
  `link_phone_number` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系电话',
  `registered_capital` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '注册资本',
  `registration_type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登记注册类型',
  `registration_type_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登记注册类型代码',
  `registered_time` datetime(0) NULL DEFAULT NULL COMMENT '成立时间',
  `unit_profile` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '单位概况',
  `official_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '官方邮箱',
  `twitter` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'twitter账号',
  `unit_code` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '社会统一信用代码',
  `last_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓',
  `first_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名',
  `gender` char(4) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',
  `gender_dict` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别代码',
  `nation` char(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '民族',
  `nation_dict` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '民族代码',
  `birthday` datetime(0) NULL DEFAULT NULL COMMENT '出生日期',
  `highest_education` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最高学历',
  `highest_education_dict` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最高学历代码',
  `id_type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '证件类型',
  `id_number` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '证件号码',
  `original_duty` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '曾任职务',
  `telephone_number` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '办公电话',
  `fax_number` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户传真号码',
  `email` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `spare_email` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用邮箱',
  `expertise` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '专业特长',
  `postal_address` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '通讯地址',
  `wechat` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信',
  `qq` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'QQ',
  `weibo` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微博',
  `personal_page` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户主页',
  `tag` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户标签',
  `hobby` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '兴趣方向',
  `spare_one` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段1',
  `spare_two` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段2',
  `spare_three` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段3',
  `spare_four` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段4',
  `spare_five` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段5',
  `create_by` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者',
  `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新者',
  `update_date` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
)   COMMENT = '委员会展示信息详情表' ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;

INSERT INTO auth_privilege ( APPLICATION_ID, PRIVILEGE_KEY, PRIVILEGE_NAME, PRIVILEGE_TYPE_DICT, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME,PRIVILEGE_DISPLAY_ORDER,PRIVILEGE_PARENT_ID,PRIVILEGE_ICON,PRIVILEGE_URL,PRIVILEGE_STATUS ) (SELECT 2,'ITIM.COOPERATION.NATIONALREGIONALCOMMITTEES','国家区域委员会','1','1',now(),'1',now(),7,(SELECT max(PRIVILEGE_ID) FROM auth_privilege WHERE PRIVILEGE_KEY='ITIM.COOPERATION'),'fa-dashboard','','0' FROM DUAL);
INSERT INTO auth_privilege ( APPLICATION_ID, PRIVILEGE_KEY, PRIVILEGE_NAME, PRIVILEGE_TYPE_DICT, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME,PRIVILEGE_DISPLAY_ORDER,PRIVILEGE_PARENT_ID,PRIVILEGE_ICON,PRIVILEGE_URL,PRIVILEGE_STATUS ) (SELECT 2,'ITIM.COOPERATION.NATIONALREGIONALCOMMITTEES.NATIONALCOMMITTEE','委员会管理','1','1',now(),'1',now(),1,(SELECT max(PRIVILEGE_ID) FROM auth_privilege WHERE PRIVILEGE_KEY='ITIM.COOPERATION.NATIONALREGIONALCOMMITTEES'),'fa-dashboard','CommitteeBasisEntityList','0' FROM DUAL);
INSERT INTO auth_privilege ( APPLICATION_ID, PRIVILEGE_KEY, PRIVILEGE_NAME, PRIVILEGE_TYPE_DICT, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME,PRIVILEGE_DISPLAY_ORDER,PRIVILEGE_PARENT_ID,PRIVILEGE_ICON,PRIVILEGE_URL,PRIVILEGE_STATUS ) (SELECT 2,'ITIM.COOPERATION.NATIONALREGIONALCOMMITTEES.REGIONALCOMMITTEES','委员会展示信息管理','1','1',now(),'1',now(),2,(SELECT max(PRIVILEGE_ID) FROM auth_privilege WHERE PRIVILEGE_KEY='ITIM.COOPERATION.NATIONALREGIONALCOMMITTEES'),'fa-dashboard','CommitteeShowMessageEntityList','0' FROM DUAL);
INSERT INTO auth_privilege ( APPLICATION_ID, PRIVILEGE_KEY, PRIVILEGE_NAME, PRIVILEGE_TYPE_DICT, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME,PRIVILEGE_DISPLAY_ORDER,PRIVILEGE_PARENT_ID,PRIVILEGE_ICON,PRIVILEGE_URL,PRIVILEGE_STATUS ) (SELECT 2,'ITIM.OPERATE.COMMITEEANDREGION.ACTIVITY','委员会活动管理','1','1',now(),'1',now(),3,(SELECT max(PRIVILEGE_ID) FROM auth_privilege WHERE PRIVILEGE_KEY='ITIM.COOPERATION.NATIONALREGIONALCOMMITTEES'),'fa-dashboard','CommitteeActivityEntityList','0' FROM DUAL);
INSERT INTO auth_privilege ( APPLICATION_ID, PRIVILEGE_KEY, PRIVILEGE_NAME, PRIVILEGE_TYPE_DICT, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME,PRIVILEGE_DISPLAY_ORDER,PRIVILEGE_PARENT_ID,PRIVILEGE_ICON,PRIVILEGE_URL,PRIVILEGE_STATUS ) (SELECT 2,'ITIM.OPERATE.COMMITEEANDREGION.ACTIVITY.APPROVAL','委员会活动审批','1','1',now(),'1',now(),4,(SELECT max(PRIVILEGE_ID) FROM auth_privilege WHERE PRIVILEGE_KEY='ITIM.COOPERATION.NATIONALREGIONALCOMMITTEES'),'fa-dashboard','CommitteeActivityEntityApprovalList','0' FROM DUAL);
INSERT INTO auth_privilege ( APPLICATION_ID, PRIVILEGE_KEY, PRIVILEGE_NAME, PRIVILEGE_TYPE_DICT, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME,PRIVILEGE_DISPLAY_ORDER,PRIVILEGE_PARENT_ID,PRIVILEGE_ICON,PRIVILEGE_URL,PRIVILEGE_STATUS ) (SELECT 2,'ITIM.OPERATE.COMMITEEANDREGION.INFOMANAGER','委员会信息发布管理','1','1',now(),'1',now(),6,(SELECT max(PRIVILEGE_ID) FROM auth_privilege WHERE PRIVILEGE_KEY='ITIM.COOPERATION.NATIONALREGIONALCOMMITTEES'),'fa-dashboard','CommitteeInformationReleaseManagementEntityList','0' 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='DISPLAY_CLASSIFY'),'最新动态','5','5','Y','','1',now(),'1',now() FROM DUAL);


ALTER TABLE `cms_information_entity` 
ADD COLUMN `dynamic_business_json` varchar(4000) COMMENT '动态关联业务对象' AFTER `entity_ru`,
ADD COLUMN `dynamic_business_forbid` varchar(4000) COMMENT '动态关联业务对象禁止关联' AFTER `dynamic_business_json`;

ALTER TABLE `cms_information_info` 
ADD COLUMN `dynamic_business_json` varchar(4000) COMMENT '动态关联业务对象' AFTER `base_entity_id`,
ADD COLUMN `dynamic_business_forbid` varchar(4000) COMMENT '动态关联业务对象禁止关联' AFTER `dynamic_business_json`;

ALTER TABLE `cms_information_view` 
ADD COLUMN `dynamic_business_json` varchar(4000) COMMENT '动态关联业务对象' AFTER `base_entity_id`,
ADD COLUMN `dynamic_business_forbid` varchar(4000) COMMENT '动态关联业务对象禁止关联' AFTER `dynamic_business_json`;

DROP TABLE IF EXISTS `base_think_tank_entity`;
CREATE TABLE `base_think_tank_entity`  (
  `id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'id',
  `entity_name` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '实体名称',
  `entity_type` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '实体类型',
  `entity_type_dict` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '实体类型字典代码',
  `unit_name` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '企业名称',
  `unit_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '企业信用代码',
  `are` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域',
  `are_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域字典',
  `industry` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '行业',
  `industry_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '行业字典',
  `status` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数据状态',
  `status_dict` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数据状态代码字典',
  `country` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属国家',
  `approve_status` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '审批状态',
  `approve_status_dict` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '审批状态代码字典',
  `publishing_channels` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发布渠道',
  `publishing_channels_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发布渠道字典',
  `recommend_flag` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否推荐标识',
  `set_up_date` datetime(0) NULL DEFAULT NULL COMMENT '成立时间',
  `child_count` int(11) NULL DEFAULT NULL COMMENT '实体包含个数',
  `entity_zh` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '中文，0代表无，1代表有',
  `entity_en` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '英文',
  `entity_fr` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '法文',
  `entity_de` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '德文文',
  `entity_es` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '西班牙文',
  `entity_ja` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '日文',
  `entity_ar` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '阿拉伯文',
  `entity_ru` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '俄文',
  `sort` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  `main_language` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主语言',
  `remark` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `weight` int(255) NULL DEFAULT NULL COMMENT '权重',
  `unit_name_en` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位英文名称',
  `member_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '会员ID',
  `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',
  `update_date` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
INSERT INTO `base_think_tank_entity` VALUES ('33b92c2fe91411eaa9a3e454e8b99384', NULL, NULL, NULL, '北京赛尼尔风险管理科技有限公司', NULL, NULL, 'asia', NULL, '08', NULL, NULL, 'china', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Synior Corporate Counsel Institute', '361f0db0e90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33b92ca3e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '必维国际检验集团', NULL, NULL, 'asia', NULL, '08', NULL, NULL, 'china', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Bureau Veritas（China）', '36147e64e90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33b92d10e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '西安诺亚财务咨询有限公司', NULL, NULL, 'asia', NULL, '08', NULL, NULL, 'china', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Xi\'an Noah Financial Consulting Co., Ltd.', '361f0e5ee90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33b92d7de91411eaa9a3e454e8b99384', NULL, NULL, NULL, '西安和智方企业管理咨询有限公司', NULL, NULL, 'asia', NULL, '08', NULL, NULL, 'china', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Xi`an Hezhifang Enterprise Management Consulting Co., Ltd.', '365666f1e90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33b92df6e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '北京新易太和教育咨询有限公司', NULL, NULL, 'asia', NULL, '08', NULL, NULL, 'china', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Beijing Neweal Education Consulting Co., Ltd.', '36485b28e90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33b92ed1e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '上海企源科技股份有限公司', NULL, NULL, 'asia', NULL, '08', NULL, NULL, 'china', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Shanghai Qiyuan Technology Co., Ltd.', '364513f1e90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c37193e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '埃森哲', NULL, NULL, 'europe', NULL, '08', NULL, NULL, 'ireland', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Accenture', '36289847e90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c37234e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '毕马威企业咨询（中国）有限公司北京分公司', NULL, NULL, 'europe', NULL, '08', NULL, NULL, 'netherlands', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'KPMG Advisory (China) Ltd. Beijing Branch', '36289907e90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c372b9e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '安永（中国）企业咨询有限公司', NULL, NULL, 'europe', NULL, '08', NULL, NULL, 'england', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Ernst & Young(China) Advisory Limited', '362899bfe90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c37333e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '能源系统规划公司', NULL, NULL, 'africa', NULL, '08', NULL, NULL, 'south africa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Energy System Planning(Pty)Ltd', '362dfda3e90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c3739fe91411eaa9a3e454e8b99384', NULL, NULL, NULL, '蒂莫斯咨询公司', NULL, NULL, 'southamerica', NULL, '08', NULL, NULL, 'brazil', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Thymos Energia', '362dfe54e90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c37409e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '必维国际检验集团（巴西）', NULL, NULL, 'southamerica', NULL, '08', NULL, NULL, 'brazil', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Bureau Veritas（Brazil）', '362dff06e90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c37471e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '挪威Xynteo咨询公司', NULL, NULL, 'europe', NULL, '08', NULL, NULL, 'norway', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Xynteo', '36345bd3e90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c37546e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '埃及AM GLOBAL公司', NULL, NULL, 'africa', NULL, '08', NULL, NULL, 'egypt', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'AM Global', '36345c7fe90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c375afe91411eaa9a3e454e8b99384', NULL, NULL, NULL, 'JTJB国际律师事务所', NULL, NULL, 'asia', NULL, '08', NULL, NULL, 'thailand', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Joseph Tan Jude Benny', '36345d30e90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c37619e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '中国宏观经济咨询研究有限公司', NULL, NULL, 'asia', NULL, '08', NULL, NULL, 'china', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'PRC Macro Limited', '36345de2e90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c37682e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '柬埔寨环保国际咨询机构', NULL, NULL, 'asia', NULL, '08', NULL, NULL, 'cambodia', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Environmental Consulting Ltd(ECIC)', '364212f5e90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c376ede91411eaa9a3e454e8b99384', NULL, NULL, NULL, '斯泰特咨询有限公司', NULL, NULL, 'northamerica', NULL, '08', NULL, NULL, 'canada', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Stantec Consulting Ltd.', '364213aae90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c37765e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '中智律师事务所', NULL, NULL, 'southamerica', NULL, '08', NULL, NULL, 'chile', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Chile China Lawyers', '36421459e90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c377d1e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '罗马尼亚弗贝PFA咨询公司', NULL, NULL, 'europe', NULL, '08', NULL, NULL, 'romania', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Dan Vulpe PF A Consultancy', '36421510e90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c3783ee91411eaa9a3e454e8b99384', NULL, NULL, NULL, '亚美金融咨询有限公司', NULL, NULL, 'southamerica', NULL, '08', NULL, NULL, 'chile', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Asesorías CTE SpA', '364215c4e90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c378aae91411eaa9a3e454e8b99384', NULL, NULL, NULL, 'XEM咨询公司', NULL, NULL, 'africa', NULL, '08', NULL, NULL, 'nigeria', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'XEM Consultants Ltd.', '36421678e90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c37916e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '阿根廷可持续技术认证公司', NULL, NULL, 'southamerica', NULL, '08', NULL, NULL, 'argentina', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Certificacion Sustentable S.A.', '36421728e90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c37a00e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '环球能源公司', NULL, NULL, 'northamerica', NULL, '08', NULL, NULL, 'united states', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'One Universe Energy LLC', '364217e5e90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c37a6ae91411eaa9a3e454e8b99384', NULL, NULL, NULL, '莱索托PKF咨询公司', NULL, NULL, 'africa', NULL, '08', NULL, NULL, 'lesotho', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'PKF CONSULT Pty Limited', '36421894e90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c37ad3e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '唐古嘉雅公司', NULL, NULL, 'asia', NULL, '08', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'CV Tangguh Jaya Perkasa', '3642194be90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c37b41e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '振唐科技（香港）有限公司', NULL, NULL, 'asia', NULL, '08', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Zhentang Technology (HK) Co.,Ltd', '364219f2e90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c37bb8e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '瑞士JCT清洁技术咨询机构', NULL, NULL, 'europe', NULL, '08', NULL, NULL, 'switzerland', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Jirang Clean Technologies JCT Ltd', '36421aa2e90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c37c25e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '阿尔及利亚爱途比商业信息公司', NULL, NULL, 'africa', NULL, '08', NULL, NULL, 'algeria', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Sarl I2b Algeria', '36421b5fe90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c37cbce91411eaa9a3e454e8b99384', NULL, NULL, NULL, '托恩规划设计公司', NULL, NULL, 'europe', NULL, '08', NULL, NULL, 'russia', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Ton Corporation Ltd.', '36421c17e90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c37d2ce91411eaa9a3e454e8b99384', NULL, NULL, NULL, '大西洋能源咨询公司', NULL, NULL, 'southamerica', NULL, '08', NULL, NULL, 'brazil', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Atlantico Energia', '36421cc6e90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c37d9ae91411eaa9a3e454e8b99384', NULL, NULL, NULL, '电网策略咨询公司', NULL, NULL, 'northamerica', NULL, '08', NULL, NULL, 'united states', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Grid Strategies LLC', '36421d78e90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c37e09e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '哥斯达黎加GEO能源咨询公司', NULL, NULL, 'southamerica', NULL, '08', NULL, NULL, 'costa rica', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'GEO Ingenieria S.A.', '36421e60e90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c37edce91411eaa9a3e454e8b99384', NULL, NULL, NULL, 'SRL能源与环境技术咨询公司', NULL, NULL, 'southamerica', NULL, '08', NULL, NULL, 'argentina', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Grupo Induser SRL', '36421f0fe90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c37f48e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '俄罗斯国家评级标准机构', NULL, NULL, 'europe', NULL, '08', NULL, NULL, 'russia', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'National Rating Agency Limited Liability Company (NRA)', '36421fbbe90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c37fbde91411eaa9a3e454e8b99384', NULL, NULL, NULL, '立陶宛尤兹咨询公司', NULL, NULL, 'europe', NULL, '08', NULL, NULL, 'lithuania', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Lithuanian Auto UZ Company', '3642206fe90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c38035e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '谦益吉事务所', NULL, NULL, 'asia', NULL, '08', NULL, NULL, 'thailand', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Kanchanakit Office', '3642212be90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c380a3e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '赛百思中欧商务咨询公司', NULL, NULL, 'europe', NULL, '08', NULL, NULL, 'belgium', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'CEBIZ', '36450f0fe90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c3810fe91411eaa9a3e454e8b99384', NULL, NULL, NULL, '贝密斯能源咨询公司', NULL, NULL, 'northamerica', NULL, '08', NULL, NULL, 'united states', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Baymeath Group', '36450fc3e90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('33c3817be91411eaa9a3e454e8b99384', NULL, NULL, NULL, '大电网解决方案咨询公司', NULL, NULL, 'northamerica', NULL, '08', NULL, NULL, 'canada', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'TransGrid Solutions', '36451074e90111eaa9a3e454e8b99384', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('5f5318810b6a11eba650e454e8b99384', NULL, NULL, NULL, '南方能源咨询公司', NULL, NULL, 'southamerica', NULL, '08', NULL, NULL, 'chile', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Surenergia S.A.', 'b9a4a2f92725d5067e25613c11cf946a', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');
INSERT INTO `base_think_tank_entity` VALUES ('5f5319060b6a11eba650e454e8b99384', NULL, NULL, NULL, '未来金融方案公司', NULL, NULL, 'asia', NULL, '08', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Nextgen Financial Solutions Pvt.Ltd.', '04917304570ce8f324fff43036f13c4c', '1', '2020-11-17 11:21:44', '1', '2020-11-17 11:21:44');

SET FOREIGN_KEY_CHECKS = 1;
DROP TABLE IF EXISTS `base_think_tank_info`;
CREATE TABLE `base_think_tank_info`  (
  `id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '企业ID',
  `unit_name` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '企业名称',
  `unit_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '企业信用代码',
  `register_money` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '注册资本',
  `unit_country` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '国家代码',
  `unit_country_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '国家代码字典',
  `unit_province` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '省代码',
  `unit_province_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '省代码字典',
  `unit_city` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '市代码',
  `unit_city_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '市代码字典',
  `unit_region` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '企业所在地区',
  `set_up_date` datetime(0) NULL DEFAULT NULL COMMENT '成立时间',
  `corporate_name` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '法人姓名',
  `corporate_id_card` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '法人身份证号码',
  `corporate_duty` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '法人职务',
  `official_website_path` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '官方网址',
  `unit_address` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公司地址',
  `dynamic` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '动态',
  `dynamic_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '动态字典',
  `units_system` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '系统内单位',
  `units_system_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '系统内单位字典',
  `council_members` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '理事会成员',
  `council_members_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '理事会成员字典',
  `link_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系人姓名',
  `link_phone_number` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系电话',
  `are` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域',
  `industry` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '行业',
  `industry_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '行业字典',
  `are_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域字典',
  `recommend_flag` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否推荐标识',
  `latest_flag` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否最新会员标识',
  `unit_label` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '企业标签',
  `unit_scope` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '经营范围',
  `unit_introdution` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '单位概况',
  `status` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '状态',
  `status_dict` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '状态代码字典',
  `enterprise_property` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '企业性质',
  `enterprise_property_dict` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '企业性质字典表',
  `initial` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '企业名称首字母',
  `language` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '语言',
  `base_entity_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '基础信息id',
  `photo` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片地址',
  `weight` int(11) NULL DEFAULT 0 COMMENT '展示权重',
  `showable` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否展示',
  `member_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '会员ID',
  `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',
  `update_date` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '企业-企业信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of base_think_tank_info
-- ----------------------------
INSERT INTO `base_think_tank_info` VALUES ('8546c676288011eb993320040ff5fc9c', '未来金融方案公司', NULL, NULL, NULL, 'india', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '08', 'asia', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'W', 'ZH', '5f5319060b6a11eba650e454e8b99384', NULL, 0, '1', '04917304570ce8f324fff43036f13c4c', '1', '2020-11-17 10:56:42', '1', '2020-11-17 10:56:42');
INSERT INTO `base_think_tank_info` VALUES ('856fc3c3288011eb993320040ff5fc9c', 'Nextgen Financial Solutions Pvt.Ltd.', NULL, NULL, NULL, 'india', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '08', 'asia', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'N', 'EN', '5f5319060b6a11eba650e454e8b99384', NULL, 0, '1', '04917304570ce8f324fff43036f13c4c', '1', '2020-11-17 10:56:42', '1', '2020-11-17 10:56:42');
INSERT INTO `base_think_tank_info` VALUES ('85a444c1288011eb993320040ff5fc9c', 'Bureau Veritas（China）', NULL, NULL, '中国', 'china', NULL, NULL, 'SHANGHAI', NULL, 'SHANGHAI', NULL, NULL, NULL, NULL, 'www.bureauveritas.cn', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Asia', NULL, '08', 'asia', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'B', 'EN', '33b92ca3e91411eaa9a3e454e8b99384', NULL, 0, '0', '36147e64e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:42', '1', '2020-11-17 10:56:42');
INSERT INTO `base_think_tank_info` VALUES ('85ccbe8a288011eb993320040ff5fc9c', '必维国际检验集团', NULL, NULL, '中国', 'china', NULL, NULL, '上海', NULL, '上海', NULL, NULL, NULL, NULL, 'www.bureauveritas.cn', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '亚洲', '咨询公司', '08', 'asia', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'B', 'ZH', '33b92ca3e91411eaa9a3e454e8b99384', NULL, 0, '0', '36147e64e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:43', '1', '2020-11-17 10:56:43');
INSERT INTO `base_think_tank_info` VALUES ('8600863f288011eb993320040ff5fc9c', 'Synior Corporate Counsel Institute', NULL, '100', '中国', 'china', NULL, NULL, 'BEIJING', NULL, 'BEIJING', '2008-03-04 00:00:00', 'Xiaozhong Ye', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '亚洲', '咨询公司', '08', 'asia', '', NULL, NULL, NULL, '<p>Beijing Senier Risk Management Technology Co., LTD. Business scope includes technology promotion services; Business management consulting, legal consulting (excluding intermediary services), etc.</p><p><br/></p>', NULL, NULL, NULL, NULL, 'S', 'EN', '33b92c2fe91411eaa9a3e454e8b99384', 'unit/2020/09/28/d6bfb16b6d5f4a8986f2c63bbf2ebfa9.png', 0, '0', '361f0db0e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:43', '2', '2020-11-17 10:56:43');
INSERT INTO `base_think_tank_info` VALUES ('86293d5f288011eb993320040ff5fc9c', '北京赛尼尔风险管理科技有限公司', NULL, '100', '中国', 'china', NULL, NULL, '北京', NULL, '北京', '2008-03-04 00:00:00', '叶小忠', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '亚洲', '咨询公司', '08', 'asia', '', NULL, NULL, NULL, '<p>北京赛尼尔风险管理科技有限公司经营范围包括技术推广服务；企业管理咨询、法律咨询（不含中介服务）等。</p><p><br/></p>', NULL, NULL, NULL, NULL, 'B', 'ZH', '33b92c2fe91411eaa9a3e454e8b99384', 'unit/2020/09/28/d175edb8bfe242b48d0ef0b647d0cd99.png', 0, '0', '361f0db0e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:43', '2', '2020-11-17 10:56:43');
INSERT INTO `base_think_tank_info` VALUES ('865e284f288011eb993320040ff5fc9c', 'Xi\'an Noah Financial Consulting Co., Ltd.', NULL, '100', '中国', 'china', NULL, NULL, 'XIAN', NULL, 'XIAN', '2013-05-13 00:00:00', 'Hong Li', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '亚洲', '咨询公司', '08', 'asia', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'X', 'EN', '33b92d10e91411eaa9a3e454e8b99384', NULL, 0, '0', '361f0e5ee90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:43', '2', '2020-11-17 10:56:43');
INSERT INTO `base_think_tank_info` VALUES ('86886056288011eb993320040ff5fc9c', '西安诺亚财务咨询有限公司', NULL, '100', '中国', 'china', NULL, NULL, '西安', NULL, '西安', '2013-05-13 00:00:00', '李虹', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '亚洲', '咨询公司', '08', 'asia', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'X', 'ZH', '33b92d10e91411eaa9a3e454e8b99384', NULL, 0, '0', '361f0e5ee90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:44', '2', '2020-11-17 10:56:44');
INSERT INTO `base_think_tank_info` VALUES ('86bca155288011eb993320040ff5fc9c', 'Accenture', NULL, NULL, '爱尔兰', 'ireland', NULL, NULL, 'SHANGHAI', NULL, 'ublin, Ireland', '1989-01-01 00:00:00', NULL, NULL, NULL, 'www.accenture.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '欧洲', '咨询公司', '08', 'europe', '', NULL, NULL, NULL, '<p>Accenture is a leading global professional services company, providing a broad range of services in strategy and consulting, interactive, technology and operations, with digital capabilities across all of these services. We combine unmatched experience and specialized capabilities across more than 40 industries – powered by the world’s largest network of Advanced Technology and Intelligent Operations centers. With 513,000 people serving clients in more than 120 countries, Accenture brings continuous innovation to help clients improve their performance and create lasting value across their enterprises.</p><p>The company has been operating in Greater China for over 30 years. Today, it has more than 16,000 people servicing clients across the region with offices in the cities including Beijing, Shanghai, Dalian, Chengdu, Guangzhou, Shenzhen, Hong Kong and Taipei. As a trusted Partner of Choice for digital transformation, Accenture is bringing more innovation to the business and technology ecosystems and helping Chinese enterprises and the government to embrace digitization and enhance global competitiveness to succeed in the new era.</p><p><br/></p>', NULL, NULL, NULL, NULL, 'A', 'EN', '33c37193e91411eaa9a3e454e8b99384', 'unit/2020/09/22/a1ba37db5765439ea57e82ae074b239a.png', 0, '1', '36289847e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:44', '2', '2020-11-17 10:56:44');
INSERT INTO `base_think_tank_info` VALUES ('86e5c455288011eb993320040ff5fc9c', '埃森哲', NULL, NULL, '爱尔兰', 'ireland', NULL, NULL, '上海', NULL, '爱尔兰都柏林', '1989-01-01 00:00:00', NULL, NULL, NULL, 'www.accenture.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '欧洲', '咨询公司', '08', 'europe', '', NULL, NULL, NULL, '<p>埃森哲公司注册成立于爱尔兰，是一家全球领先的专业服务公司，依靠卓越的数字化能力，为客户提供战略与咨询、互动营销、技术和运营服务及解决方案。凭借独特的业内经验与专业技能，以及翘楚全球的卓越技术中心和智能运营中心，我们业务涵盖40多个行业，以及企业日常运营部门的各个职能。埃森哲是《财富》全球500强企业之一，目前拥有约51.3万名员工，服务于120多个国家的客户。我们坚持以创新促发展，帮助客户提升绩效，持续创造价值。</p><p>埃森哲在大中华区开展业务30余年，拥有一支1.6万多人的员工队伍，分布于多个城市，包括北京、上海、大连、成都、广州、深圳、香港和台北等。作为可信赖的数字化转型卓越伙伴，我们正在更创新地参与商业和技术生态圈的建设，帮助中国企业和政府把握数字化力量，通过制定战略、优化流程、集成系统、部署云计算等实现转型，提升全球竞争力，从而立足中国、赢在全球。</p><p><br/></p>', NULL, NULL, NULL, NULL, 'A', 'ZH', '33c37193e91411eaa9a3e454e8b99384', 'unit/2020/09/22/a1ba37db5765439ea57e82ae074b239a.png', 0, '1', '36289847e90111eaa9a3e454e8b99384', NULL, '2020-11-17 10:56:44', '2', '2020-11-17 10:56:44');
INSERT INTO `base_think_tank_info` VALUES ('8716ff38288011eb993320040ff5fc9c', 'KPMG Advisory (China) Ltd. Beijing Branch', NULL, NULL, '荷兰', 'netherlands', NULL, NULL, 'BEIJING', NULL, 'Netherlands', '2005-07-26 00:00:00', 'Jiang Liqin', NULL, NULL, 'www.kpmg.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '欧洲', '咨询公司', '08', 'europe', '', NULL, NULL, NULL, '<p>KPMG was established in 1897 and is headquartered in Amsterdam, the Netherlands. It is a professional service organization with a global network, specializing in auditing, taxation and consulting services. KPMG is also one of the four largest accounting firms in the world.</p><p>&nbsp;</p><p><br/></p>', NULL, NULL, NULL, NULL, 'K', 'EN', '33c37234e91411eaa9a3e454e8b99384', 'unit/2020/09/22/a1ba37db5765439ea57e82ae074b239a.png', 0, '1', '36289907e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:45', '2', '2020-11-17 10:56:45');
INSERT INTO `base_think_tank_info` VALUES ('873ce549288011eb993320040ff5fc9c', '毕马威企业咨询（中国）有限公司北京分公司', NULL, NULL, '荷兰', 'netherlands', NULL, NULL, '北京', NULL, '荷兰', '2005-07-26 00:00:00', 'Jiang Liqin', NULL, NULL, 'www.kpmg.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '欧洲', '咨询公司', '08', 'europe', '', NULL, NULL, NULL, '<p style=\"text-indent: 2em;\">毕马威是一个由专业服务成员所组成的全球网络。成员所遍布全球147个国家和地区，拥有专业人员超过219,000名，提供审计、税务和咨询等专业服务。1992年，毕马威在中国内地成为首家获准中外合作开业的国际会计师事务所。2012年8月1日，毕马威成为四大会计师事务所之中首家从中外合作制转为特殊普通合伙的事务所。</p><p style=\"text-indent: 2em;\">毕马威企业咨询(中国)有限公司北京分公司成立于2005年07月26日。经营范围包括财务咨询、税务咨询、商务信息咨询、投资咨询、企业管理咨询；国际经济咨询及市场信息咨询；受客户委托进行企业尽职调查（征信、资信、社会调查除外）；风险及系统咨询、供应链管理及咨询，从事系统应用管理和维护、信息技术支持管理、软件开发、数据处理等信息技术和业务流程外包服务；提供相关技术咨询等。</p><p><br/></p>', NULL, NULL, NULL, NULL, 'B', 'ZH', '33c37234e91411eaa9a3e454e8b99384', 'unit/2020/09/22/a1ba37db5765439ea57e82ae074b239a.png', 0, '1', '36289907e90111eaa9a3e454e8b99384', NULL, '2020-11-17 10:56:45', '2', '2020-11-17 10:56:45');
INSERT INTO `base_think_tank_info` VALUES ('878ccf1c288011eb993320040ff5fc9c', 'Ernst & Young(China) Advisory Limited', NULL, '5000', '英国', 'england', NULL, NULL, 'SHANGHAI', NULL, 'SHANGHAI', '2007-12-25 00:00:00', 'Chenkai', NULL, NULL, 'www.ey.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '欧洲', '咨询公司', '08', 'europe', '', NULL, NULL, NULL, '<p>EY is one of the world&#39;s leading audit, tax, financial transactions and advisory services. In 2007, EY established Ernst &amp; Young (China) Advisory Limited in China. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p><p>There are several business departments such as performance improvement, risk, information technology, transaction advisory service, and tax service. The partners of all business departments also belong to industry groups divided by different industries. These industry groups are finance, power and utilities, retail and consumer products, industrial products, technology, telecommunications and media.</p><p><br/></p>', NULL, NULL, NULL, NULL, 'E', 'EN', '33c372b9e91411eaa9a3e454e8b99384', 'unit/2020/09/22/a1ba37db5765439ea57e82ae074b239a.png', 0, '1', '362899bfe90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:45', '2', '2020-11-17 10:56:45');
INSERT INTO `base_think_tank_info` VALUES ('87b472c0288011eb993320040ff5fc9c', '安永（中国）企业咨询有限公司', NULL, '5000', '英国', 'england', NULL, NULL, '上海', NULL, '上海', '2007-12-25 00:00:00', '陈凯', NULL, NULL, 'www.ey.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '欧洲', '咨询公司', '08', 'europe', '', NULL, NULL, NULL, '<p>安永至今已有一百多年的历史。安永的前身是1903年成立于美国克利夫兰的Ernst&amp;Ernst(1979年后合并为Ernst&amp;Whinney)会计公司和1894年成立于美国纽约的ArthurYoung会计公司。1989年，原八大会计事物所之中的ArthurYoung及Ernst&amp;Whinney之间的兼并造就了Ernst&amp;Young。</p><p>安永在中国提供专业服务已超过40年。安永的前身雅特杨会计师事务所于1968年在香港成立首个办事处，并于1981年在中国内地设立办事处</p><p>1992年，安永获中国财政部批准在国内设立合作事务所–安永华明会计师事务所。2007年，安永在中国设立安永(中国)企业咨询服务公司，2001年在香港设立安永税务及咨询有限公司、安永企业财务有限公司，以及2007年设立安永咨询服务有限公司。</p><p>安永在中国在北京、香港、上海、成都、武汉、深圳、广州、大连、苏州、青岛、杭州、天津、厦门、澳门14个城市设有办事处，共有员工超过8,000人</p><p><br/></p>', NULL, NULL, NULL, NULL, 'A', 'ZH', '33c372b9e91411eaa9a3e454e8b99384', 'unit/2020/09/22/a1ba37db5765439ea57e82ae074b239a.png', 0, '1', '362899bfe90111eaa9a3e454e8b99384', NULL, '2020-11-17 10:56:46', '2', '2020-11-17 10:56:46');
INSERT INTO `base_think_tank_info` VALUES ('87e65622288011eb993320040ff5fc9c', 'Energy System Planning(Pty)Ltd', NULL, NULL, '南非', 'south africa', NULL, NULL, 'Johannesburg?', NULL, 'Johannesburg?', '2009-01-01 00:00:00', NULL, NULL, NULL, 'www.espcg.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '非洲', '咨询公司', '08', 'africa', '', NULL, NULL, NULL, '<p>Energy System Planning (Pty) Ltd trading as ESP is a leading provider of engineering consultancy services in the energy sector.</p><p><br/></p>', NULL, NULL, NULL, NULL, 'E', 'EN', '33c37333e91411eaa9a3e454e8b99384', NULL, 0, '0', '362dfda3e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:46', '167', '2020-11-17 10:56:46');
INSERT INTO `base_think_tank_info` VALUES ('883f5124288011eb993320040ff5fc9c', '能源系统规划公司', NULL, NULL, '南非', 'south africa', NULL, NULL, '约翰内斯堡', NULL, '约翰内斯堡', '2009-01-01 00:00:00', NULL, NULL, NULL, 'www.espcg.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '非洲', '咨询公司', '08', 'africa', '', NULL, NULL, '', '<p style=\"text-indent:43px;line-height:39px\"><span style=\";font-family:仿宋;font-size:21px\"><span style=\"font-family:仿宋\">南非</span></span><span style=\";font-family:仿宋;font-size:21px\"><span style=\"font-family:仿宋\">能源系统规划公司</span></span><span style=\";font-family:仿宋;font-size:21px\"><span style=\"font-family:仿宋\">是专门从事能源领域咨询服务的供应商</span></span><span style=\";font-family:仿宋;font-size:21px\"><span style=\"font-family:仿宋\">，</span></span><span style=\";font-family:仿宋;font-size:21px\"><span style=\"font-family:仿宋\">公司自</span></span><span style=\";font-family:仿宋;font-size:21px\">2009年成立以来，为广大客户提供了高质量的服务，公司愿景是在与客户密切沟通的基础上满足客户在各种能源领域的战略布局。公司为开发周期内的项目提供咨询服务：从前期专家研究、项目经济性评估、技术可行性到协助客户完成项目融资。</span></p><p><span style=\";font-family:仿宋;font-size:19px\"><span style=\"font-family:仿宋\">在发输配电环节公司提供的服务包括：长期电源规划、发电厂可行性研究、项目风险分析等方面；在天然气咨询领域提供的服务包括：需求预测、供给侧分析、天然气传输研究以及能源可替代性研究等等。</span></span></p><p><br/></p>', NULL, NULL, NULL, NULL, 'N', 'ZH', '33c37333e91411eaa9a3e454e8b99384', NULL, 0, '0', '362dfda3e90111eaa9a3e454e8b99384', NULL, '2020-11-17 10:56:47', '167', '2020-11-17 10:56:47');
INSERT INTO `base_think_tank_info` VALUES ('8871defb288011eb993320040ff5fc9c', 'Thymos Energia', NULL, NULL, '巴西', 'brazil', NULL, NULL, 'Sao Paulo', NULL, 'Sao Paulo', '2013-01-01 00:00:00', NULL, NULL, NULL, 'www.thymosenergca.com.bv', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '南美洲', '咨询公司', '08', 'southamerica', '', NULL, NULL, NULL, '<p>Thymos was founded in January 2013 with the aim of contributing to the advancement of the energy sector in terms of management and efficiency. A select group of professionals decided to invest in knowledge - a fundamental requirement to guide the modernization of the electricity sector and to promote the development of structured electricity and natural gas markets, based on free competition, capable of boosting the national economy and boosting economic growth. of Brazil.</p><p><br/></p>', NULL, NULL, NULL, NULL, 'T', 'EN', '33c3739fe91411eaa9a3e454e8b99384', 'unit/2020/09/28/d7f64a8a3da54c638b9baae25eedafdc.jpg', 0, '0', '362dfe54e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:47', '2', '2020-11-17 10:56:47');
INSERT INTO `base_think_tank_info` VALUES ('88993543288011eb993320040ff5fc9c', '蒂莫斯咨询公司', NULL, NULL, '巴西', 'brazil', NULL, NULL, '圣保罗', NULL, '圣保罗', '2013-01-01 00:00:00', NULL, NULL, NULL, 'www.thymosenergca.com.bv', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '南美洲', '咨询公司', '08', 'southamerica', '', NULL, NULL, NULL, '<p>蒂莫斯咨询公司成立于2013年1月，旨在为管理和效率方面的能源行业发展做出贡献。一批专业人士决定对知识进行投资，这是引导电力部门现代化并促进基于自由竞争的，能够促进国民经济和经济增长的结构化电力和天然气市场发展的基本要求。</p><p><br/></p>', NULL, NULL, NULL, NULL, 'D', 'ZH', '33c3739fe91411eaa9a3e454e8b99384', 'unit/2020/09/28/81b6aff1a5504e68bdbc0b0fdb5b5219.jpg', 0, '0', '362dfe54e90111eaa9a3e454e8b99384', NULL, '2020-11-17 10:56:47', '2', '2020-11-17 10:56:47');
INSERT INTO `base_think_tank_info` VALUES ('88d100c3288011eb993320040ff5fc9c', 'Bureau Veritas（Brazil）', NULL, NULL, '巴西', 'brazil', NULL, NULL, 'Sao Paulo', NULL, 'Sao Paulo', '1827-12-31 23:54:17', NULL, NULL, NULL, 'www.bureauveritas.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '南美洲', '咨询公司', '08', 'southamerica', '', NULL, NULL, NULL, '<p>Bureau Veritas International Inspection Group was established in 1828 and is a world-renowned international inspection and certification group. Its service areas are concentrated in the areas of quality, health, safety and environmental management and social responsibility assessment. Since its establishment, Bureau Veritas International Inspection Group has a service network covering more than 150 countries, with more than 900 offices and laboratories, and approximately 40,000 employees serving customers in 370,000 different fields in the global terminal market. In Brazil, the group has a strong influence, with offices and business departments in all regions of Brazil.</p><p>Bureau Veritas is an industry promoter of testing, inspection and certification (TIC) services. Our mission is to reduce customer risks, improve customer performance, and help customers innovate to meet social needs. Facing the core challenges of quality, health and safety, environmental protection and social responsibility, we rely on our extensive professional knowledge, impartiality and independence to promote the establishment of trust among enterprises, authorities and consumers.</p><p><br/></p>', NULL, NULL, NULL, NULL, 'B', 'EN', '33c37409e91411eaa9a3e454e8b99384', 'unit/2020/09/28/bf1467073b044049bcacd207351a65f7.jpg', 0, '0', '362dff06e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:48', '2', '2020-11-17 10:56:48');
INSERT INTO `base_think_tank_info` VALUES ('88fb761a288011eb993320040ff5fc9c', '必维国际检验集团（巴西）', NULL, NULL, '巴西', 'brazil', NULL, NULL, '圣保罗', NULL, '圣保罗', '1827-12-31 23:54:17', NULL, NULL, NULL, 'www.bureauveritas.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '南美洲', '咨询公司', '08', 'southamerica', '', NULL, NULL, NULL, '<p>维国际检验集团成立于1828年，是全球知名的国际检验、认证集团，其服务领域集中在质量、健康、安全和环境管理以及社会责任评估领域。从成立至今，必维国际检验集团的服务网络覆盖150多个国家，拥有900多个办事处和实验室，约40,000名员工为全球终端市场的370,000个不同领域的客户服务。在巴西，集团拥有强大的影响力，在巴西所有地区均设有办事处和业务部门。</p><p>必维集团是测试、检验和认证（TIC）服务的行业推进者 。我们的使命是降低客户风险、提高客户业绩、帮助客户创新以满足社会需求。面对质量、健康和安全、环境保护和社会责任的核心挑战，我们凭借广泛的专业知识、公正性和独立性，促进在企业、权威机构和消费者之间建立信任。</p><p><br/></p>', NULL, NULL, NULL, NULL, 'B', 'ZH', '33c37409e91411eaa9a3e454e8b99384', 'unit/2020/09/28/af3ec3d8c5474ad0b1bdad1c2388fe5a.jpg', 0, '0', '362dff06e90111eaa9a3e454e8b99384', NULL, '2020-11-17 10:56:48', '2', '2020-11-17 10:56:48');
INSERT INTO `base_think_tank_info` VALUES ('892e2fda288011eb993320040ff5fc9c', 'Xynteo', NULL, NULL, '挪威', 'norway', NULL, NULL, 'Oslo', NULL, 'Oslo', NULL, NULL, NULL, NULL, 'www.xynteo.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Europe', NULL, '08', 'europe', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'X', 'EN', '33c37471e91411eaa9a3e454e8b99384', NULL, 0, '0', '36345bd3e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:48', '1', '2020-11-17 10:56:48');
INSERT INTO `base_think_tank_info` VALUES ('89589f7c288011eb993320040ff5fc9c', '挪威Xynteo咨询公司', NULL, NULL, '挪威', 'norway', NULL, NULL, '奥斯陆', NULL, '奥斯陆', NULL, NULL, NULL, NULL, 'www.xynteo.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '欧洲', '咨询公司', '08', 'europe', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'N', 'ZH', '33c37471e91411eaa9a3e454e8b99384', NULL, 0, '0', '36345bd3e90111eaa9a3e454e8b99384', NULL, '2020-11-17 10:56:48', NULL, '2020-11-17 10:56:48');
INSERT INTO `base_think_tank_info` VALUES ('8988ea08288011eb993320040ff5fc9c', 'AM Global', NULL, NULL, '埃及', 'egypt', NULL, NULL, 'Cairo', NULL, 'Cairo', NULL, NULL, NULL, NULL, 'https://www.amglobal.com/', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '非洲', '咨询公司', '08', 'africa', '', NULL, NULL, NULL, '<p>AMGlobal provides exceptional solutions for Fortune 500 companies, technology firms, donor agencies, and NGOs. Our clients are the major players at the intersection of emerging markets, community engagement, and new technology.</p><p><br/></p>', NULL, NULL, NULL, NULL, 'A', 'EN', '33c37546e91411eaa9a3e454e8b99384', 'unit/2020/09/28/718fee4b1faa45c789b8a9b36e963494.png', 0, '0', '36345c7fe90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:49', '2', '2020-11-17 10:56:49');
INSERT INTO `base_think_tank_info` VALUES ('89ae679a288011eb993320040ff5fc9c', '埃及AM GLOBAL公司', NULL, NULL, '埃及', 'egypt', NULL, NULL, '开罗', NULL, '开罗', NULL, NULL, NULL, NULL, 'https://www.amglobal.com/', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '非洲', '咨询公司', '08', 'africa', '', NULL, NULL, NULL, '<p>AMGlobal为《财富》 500强公司，技术公司，捐助机构和非政府组织提供出色的解决方案。我们的客户是新兴市场，社区参与和新技术交汇处的主要参与者。</p><p><br/></p>', NULL, NULL, NULL, NULL, 'A', 'ZH', '33c37546e91411eaa9a3e454e8b99384', 'unit/2020/09/28/f4bbd522eeba44b3afebd0d65ed48c10.png', 0, '0', '36345c7fe90111eaa9a3e454e8b99384', NULL, '2020-11-17 10:56:49', '2', '2020-11-17 10:56:49');
INSERT INTO `base_think_tank_info` VALUES ('89dfdbdb288011eb993320040ff5fc9c', 'Joseph Tan Jude Benny', NULL, NULL, '泰国', 'thailand', NULL, NULL, 'Bangkok', NULL, 'Bangkok', '1988-02-01 00:00:00', NULL, NULL, NULL, 'www.jtjb.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '亚洲', '咨询公司', '08', 'asia', '', NULL, NULL, NULL, '<p>Our Firm traces its history to February 1988 where the practices of founding partners Joseph Tan and Jude Benny were merged and renamed Joseph Tan Jude Benny. Then, the Firm focused on maritime law, real estate and conveyancing.</p><p>We have since grown and are today a full service law firm. Our Firm is a prominent part of the legal landscape in Singapore with an international clientele and reputation.</p><p><br/></p>', NULL, NULL, NULL, NULL, 'J', 'EN', '33c375afe91411eaa9a3e454e8b99384', 'unit/2020/09/28/f5b2c5d05d4a4230821709c93b34f0d1.png', 0, '0', '36345d30e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:49', '2', '2020-11-17 10:56:49');
INSERT INTO `base_think_tank_info` VALUES ('8a0654ab288011eb993320040ff5fc9c', 'JTJB国际律师事务所', NULL, NULL, '泰国', 'thailand', NULL, NULL, '曼谷', NULL, '曼谷', '1988-02-01 00:00:00', NULL, NULL, NULL, 'www.jtjb.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '亚洲', '咨询公司', '08', 'asia', '', NULL, NULL, NULL, '<p>我们的公司历史可以追溯到1988年2月，创始合伙人Joseph Tan和Jude Benny的业务被合并并更名为Joseph Tan Jude Benny。 然后，事务所专注于海事法，房地产和产权转让。</p><p>自那时以来，我们已经发展壮大，如今已成为一家提供全方位服务的律师事务所。我们的事务所是新加坡法律界的重要组成部分，拥有国际客户和声誉。</p><p><br/></p>', NULL, NULL, NULL, NULL, 'J', 'ZH', '33c375afe91411eaa9a3e454e8b99384', 'unit/2020/09/28/8ee704076ef5445ab3639c305528ca42.png', 0, '0', '36345d30e90111eaa9a3e454e8b99384', NULL, '2020-11-17 10:56:50', '2', '2020-11-17 10:56:50');
INSERT INTO `base_think_tank_info` VALUES ('8a3be549288011eb993320040ff5fc9c', 'PRC Macro Limited', NULL, NULL, '香港', NULL, NULL, NULL, 'Hong Kong', NULL, 'Hong Kong', NULL, NULL, NULL, NULL, 'www.prcmacro.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '亚洲', '咨询公司', '08', 'asia', '', NULL, NULL, NULL, '<p>PRC Macro was created to provide investment managers, strategists and corporate planners with clarity where it comes to the political economy in China. This is achieved by providing extensive coverage of politics &amp; policy, analyzing proprietary household sector data collected through our established survey network, as well as conducting industry focused analysis, all within our proprietary macro framework.</p><p><br/></p>', NULL, NULL, NULL, NULL, 'P', 'EN', '33c37619e91411eaa9a3e454e8b99384', 'unit/2020/09/28/1f450c8bccf24e2ea917b8cd739a7184.png', 0, '0', '36345de2e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:50', '166', '2020-11-17 10:56:50');
INSERT INTO `base_think_tank_info` VALUES ('8a60a805288011eb993320040ff5fc9c', '中国宏观经济咨询研究有限公司', NULL, NULL, '香港', NULL, NULL, NULL, '香港', NULL, '香港', NULL, NULL, NULL, NULL, 'www.prcmacro.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '亚洲', '咨询公司', '08', 'asia', '', NULL, NULL, NULL, '<p>PRC Macro的创建旨在为投资经理，战略家和企业规划师提供有关中国政治经济的清晰信息。 这是通过广泛涵盖政治和政策，分析从我们已建立的调查网络收集的专有家庭部门数据以及进行针对行业的分析来实现的。</p>', NULL, NULL, NULL, NULL, 'Z', 'ZH', '33c37619e91411eaa9a3e454e8b99384', 'unit/2020/09/28/c27ea9eebbb345428a406b16471a95e1.png', 0, '0', '36345de2e90111eaa9a3e454e8b99384', NULL, '2020-11-17 10:56:50', '166', '2020-11-17 10:56:50');
INSERT INTO `base_think_tank_info` VALUES ('8a8ffa3a288011eb993320040ff5fc9c', '柬埔寨环保国际咨询机构', NULL, NULL, NULL, 'cambodia', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '08', 'asia', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'ZH', '33c37682e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '364212f5e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:50', '1', '2020-11-17 10:56:50');
INSERT INTO `base_think_tank_info` VALUES ('8a8ffde9288011eb993320040ff5fc9c', 'Environmental Consulting Ltd(ECIC)', NULL, NULL, NULL, 'cambodia', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '08', 'asia', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'EN', '33c37682e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '364212f5e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:50', '1', '2020-11-17 10:56:50');
INSERT INTO `base_think_tank_info` VALUES ('8ab7acad288011eb993320040ff5fc9c', 'Stantec Consulting Ltd.', NULL, NULL, '加拿大', 'canada', NULL, NULL, 'Calgary', NULL, 'Calgary', '1954-01-01 00:00:00', NULL, NULL, NULL, 'www.stantec.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '北美洲', '咨询公司', '08', 'northamerica', '', NULL, NULL, NULL, '<p>Stantec Inc. is an international professional services company in the design and consulting industry. Founded in 1954, as D. R. Stanley Associates in Edmonton, Alberta. Stantec provides professional consulting services in planning, engineering, architecture, interior design, landscape architecture, surveying, environmental sciences, project management, and project economics for infrastructure and facilities projects. The Company provides services on projects around the world through over 22,000 employees operating out of more than 410 locations in North America and across offices in 6 continents internationally.</p><p><br/></p>', NULL, NULL, NULL, NULL, 'S', 'EN', '33c376ede91411eaa9a3e454e8b99384', 'unit/2020/09/28/9ca1c8a23b5e4b929cb9debf272d5d9a.png', 0, '0', '364213aae90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:51', '166', '2020-11-17 10:56:51');
INSERT INTO `base_think_tank_info` VALUES ('8ade95d3288011eb993320040ff5fc9c', '斯泰特咨询有限公司', NULL, NULL, '加拿大', 'canada', NULL, NULL, '卡尔加里', NULL, '卡尔加里', '1954-01-01 00:00:00', NULL, NULL, NULL, 'www.stantec.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '北美洲', '咨询公司', '08', 'northamerica', '', NULL, NULL, NULL, '<p><span class=\"tlid-translation translation\" style=\"min-height: 20px;line-height: 28px;font-size: 18px;color: rgba(0, 0, 0, 0.87);white-space: pre-wrap;padding-right: 8px\"><span class=\"\">Stantec Inc.是一家设计和咨询行业的国际专业服务公司。</span> <span class=\"\">成立于1954年，前身为位于美国艾伯塔省埃德蒙顿的D. R. Stanley Associates。</span> <span class=\"\">Stantec在基础设施和设施项目的规划，工程，建筑，室内设计，景观设计，测量，环境科学，项目管理和项目经济学方面提供专业的咨询服务。</span> <span class=\"\">该公司通过在北美410多个地点和全球6大洲的办事处运营的22,000多名员工为全球项目提供服务。</span></span></p>', NULL, NULL, NULL, NULL, 'S', 'ZH', '33c376ede91411eaa9a3e454e8b99384', 'unit/2020/09/28/b62f1c7fe9b54ccbb253e0acc91de44e.png', 0, '0', '364213aae90111eaa9a3e454e8b99384', NULL, '2020-11-17 10:56:51', '166', '2020-11-17 10:56:51');
INSERT INTO `base_think_tank_info` VALUES ('8b10e893288011eb993320040ff5fc9c', 'Chile China Lawyers', NULL, NULL, '智利', 'chile', NULL, NULL, 'SANTIAGO', NULL, 'SANTIAGO', '2013-01-01 00:00:00', NULL, NULL, NULL, 'www.chilechinalawyers.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '南美洲', '咨询公司', '08', 'southamerica', '', NULL, NULL, NULL, '<p>Chile China Lawyers was officially established in San Diego in 2013. So far, it has developed into a comprehensive law firm with the most influential legal and taxation services for Chinese and Chilean companies in Chile. Focus on providing various legal, financial, taxation and other professional consulting services for corporate clients in both countries.</p><p><br/></p>', NULL, NULL, NULL, NULL, 'C', 'EN', '33c37765e91411eaa9a3e454e8b99384', NULL, 0, '0', '36421459e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:51', '166', '2020-11-17 10:56:51');
INSERT INTO `base_think_tank_info` VALUES ('8b3a68e0288011eb993320040ff5fc9c', '中智律师事务所', NULL, NULL, '智利', 'chile', NULL, NULL, '圣地亚哥', NULL, '圣地亚哥', '2013-01-01 00:00:00', NULL, NULL, NULL, 'www.chilechinalawyers.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '南美洲', '咨询公司', '08', 'southamerica', '', NULL, NULL, NULL, '<p>中智律师事务所（CHILE CHINA LAWYERS）于圣地亚哥2013年正式挂牌成立。至今已发展成为在智利针对中国和智利企业法律财税服务最具影响力的综合性事务所。专注于为两国企业客户提供各类法律，财务，税收等方面的专业咨询。</p><p><br/></p><p><br/></p>', NULL, NULL, NULL, NULL, 'Z', 'ZH', '33c37765e91411eaa9a3e454e8b99384', NULL, 0, '0', '36421459e90111eaa9a3e454e8b99384', NULL, '2020-11-17 10:56:52', '166', '2020-11-17 10:56:52');
INSERT INTO `base_think_tank_info` VALUES ('8b6fce99288011eb993320040ff5fc9c', '罗马尼亚弗贝PFA咨询公司', NULL, NULL, NULL, 'romania', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '08', 'europe', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'ZH', '33c377d1e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '36421510e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:52', '1', '2020-11-17 10:56:52');
INSERT INTO `base_think_tank_info` VALUES ('8b6fd2eb288011eb993320040ff5fc9c', 'Dan Vulpe PF A Consultancy', NULL, NULL, NULL, 'romania', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '08', 'europe', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'EN', '33c377d1e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '36421510e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:52', '1', '2020-11-17 10:56:52');
INSERT INTO `base_think_tank_info` VALUES ('8b9ac3ce288011eb993320040ff5fc9c', 'Asesorías CTE SpA', NULL, NULL, '智利', 'chile', NULL, NULL, 'SANTIAGO', NULL, 'SANTIAGO', NULL, NULL, NULL, NULL, 'www.cte.cl', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '南美洲', '咨询公司', '08', 'southamerica', '', NULL, NULL, NULL, '<p style=\"text-indent:28px\"><span style=\";font-family:宋体;font-size:14px\">CTE -- Chile Tax Expert is a professional consulting service company focusing on accounting, Tax law, taxation and related fields in Chile.</span></p><p><br/></p>', NULL, NULL, NULL, NULL, 'A', 'EN', '33c3783ee91411eaa9a3e454e8b99384', 'unit/2020/09/26/12a254e330f34edf8f0a7bb4f67967df.png', 0, '0', '364215c4e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:52', '166', '2020-11-17 10:56:52');
INSERT INTO `base_think_tank_info` VALUES ('8bc1f2d5288011eb993320040ff5fc9c', '亚美金融咨询有限公司', NULL, NULL, '智利', 'chile', NULL, NULL, '圣地亚哥', NULL, '圣地亚哥', NULL, NULL, NULL, NULL, 'www.cte.cl', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '南美洲', '咨询公司', '08', 'southamerica', '', NULL, NULL, NULL, '<p>亚美金融咨询有限公司是一家专注于智利的会计、税法、税务及其相关领域的研究、应用的专业咨询服务公司。</p>', NULL, NULL, NULL, NULL, 'Y', 'ZH', '33c3783ee91411eaa9a3e454e8b99384', 'unit/2020/09/26/a81a0b3375ba4eb49ad735292f387786.png', 0, '0', '364215c4e90111eaa9a3e454e8b99384', NULL, '2020-11-17 10:56:53', '166', '2020-11-17 10:56:53');
INSERT INTO `base_think_tank_info` VALUES ('8bf34fe6288011eb993320040ff5fc9c', 'XEM Consultants Ltd.', NULL, NULL, '尼日利亚', 'nigeria', NULL, NULL, 'Abuja', NULL, 'Abuja', NULL, NULL, NULL, NULL, 'https://www.xemconsultants.com/', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '非洲', '咨询公司', '08', 'africa', '', NULL, NULL, NULL, '<p>We lead with justice, equity, diversity, and inclusion to provide creative and meaningful solutions to clients across the country. We keep updated on the latest research and theory to help clients make data-informed decisions. We develop sustained and meaningful relationships with our clients to support their organization-specific needs.</p><p><br/></p>', NULL, NULL, NULL, NULL, 'X', 'EN', '33c378aae91411eaa9a3e454e8b99384', NULL, 0, '0', '36421678e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:53', '166', '2020-11-17 10:56:53');
INSERT INTO `base_think_tank_info` VALUES ('8c1b49dc288011eb993320040ff5fc9c', 'XEM咨询公司', NULL, NULL, '尼日利亚', 'nigeria', NULL, NULL, '阿布贾', NULL, '阿布贾', NULL, NULL, NULL, NULL, 'https://www.xemconsultants.com/', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '非洲', '咨询公司', '08', 'africa', '', NULL, NULL, NULL, '<p>我们以公正、公平、多元化和包容为领导，为全国各地的客户提供创造性和有意义的解决方案。我们不断更新最新的研究和理论，以帮助客户作出数据知情的决策。我们与我们的客户发展持续和有意义的关系，以支持他们的组织特定的需求。</p><p><br/></p>', NULL, NULL, NULL, NULL, 'X', 'ZH', '33c378aae91411eaa9a3e454e8b99384', NULL, 0, '0', '36421678e90111eaa9a3e454e8b99384', NULL, '2020-11-17 10:56:53', '166', '2020-11-17 10:56:53');
INSERT INTO `base_think_tank_info` VALUES ('8c58b0aa288011eb993320040ff5fc9c', 'Certificacion Sustentable S.A.', NULL, NULL, '阿根廷', 'argentina', NULL, NULL, 'Buenos Aires', NULL, 'Buenos Aires', NULL, NULL, NULL, NULL, 'www.sustentable.org', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '南美洲', '咨询公司', '08', 'southamerica', '', NULL, NULL, NULL, '<p style=\"text-indent:14px\"><span style=\";font-family:宋体;font-size:14px\">Turn sustainability into your competitive advantage, reducing costs and risks while increasing your sales and brand value.Don&#39;t ask if you need to evolve, ask when you will take up the challenge.</span></p><p><br/></p>', NULL, NULL, NULL, NULL, 'C', 'EN', '33c37916e91411eaa9a3e454e8b99384', 'unit/2020/09/27/a0a124b6dc96430ea99bc12e7ec526b1.png', 0, '0', '36421728e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:54', '1', '2020-11-17 10:56:54');
INSERT INTO `base_think_tank_info` VALUES ('8c7f34af288011eb993320040ff5fc9c', '阿根廷可持续技术认证公司', NULL, NULL, '阿根廷', 'argentina', NULL, NULL, '布宜诺斯艾利斯', NULL, '布宜诺斯艾利斯', NULL, NULL, NULL, NULL, 'www.sustentable.org', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '南美洲', '咨询公司', '08', 'southamerica', '', NULL, NULL, NULL, '<p style=\"text-indent:14px\"><span style=\";font-family:宋体;font-size:14px\"><span style=\"font-family:宋体\">将可持续性转化为你的竞争优势，降低成本和风险，同时增加你的销售额和品牌价值。不要问你是否需要进化，而要问你什么时候接受挑战。</span></span></p><p><br/></p>', NULL, NULL, NULL, NULL, 'A', 'ZH', '33c37916e91411eaa9a3e454e8b99384', 'unit/2020/09/27/f1ac54cdd3134565ab08caa6b1b60d32.png', 0, '0', '36421728e90111eaa9a3e454e8b99384', NULL, '2020-11-17 10:56:54', '1', '2020-11-17 10:56:54');
INSERT INTO `base_think_tank_info` VALUES ('8cb00084288011eb993320040ff5fc9c', '环球能源公司', NULL, NULL, NULL, 'united states', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '08', 'northamerica', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'ZH', '33c37a00e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '364217e5e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:54', '1', '2020-11-17 10:56:54');
INSERT INTO `base_think_tank_info` VALUES ('8cb0048c288011eb993320040ff5fc9c', 'One Universe Energy LLC', NULL, NULL, NULL, 'united states', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '08', 'northamerica', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'EN', '33c37a00e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '364217e5e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:54', '1', '2020-11-17 10:56:54');
INSERT INTO `base_think_tank_info` VALUES ('8cd7c69c288011eb993320040ff5fc9c', 'PKF CONSULT Pty Limited', NULL, NULL, '莱索托', 'lesotho', NULL, NULL, 'Maseru', NULL, 'Maseru', NULL, NULL, NULL, NULL, 'www.pkflesotho.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '非洲', '咨询公司', '08', 'africa', '', NULL, NULL, NULL, '<p>PKF Lesotho (Chartered Accountants and Business Advisers) is a member firm of PKF International. With representation in 150 countries, PKF International provides a highly-ranked global network of local expertise in audit, accounting and business advisory.</p><p><br/></p>', NULL, NULL, NULL, NULL, 'P', 'EN', '33c37a6ae91411eaa9a3e454e8b99384', NULL, 0, '0', '36421894e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:54', '166', '2020-11-17 10:56:54');
INSERT INTO `base_think_tank_info` VALUES ('8cff736c288011eb993320040ff5fc9c', '莱索托PKF咨询公司', NULL, NULL, '莱索托', 'lesotho', NULL, NULL, '马塞卢', NULL, '马塞卢', NULL, NULL, NULL, NULL, 'www.pkflesotho.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '非洲', '咨询公司', '08', 'africa', '', NULL, NULL, NULL, '<p>普科莱索托(特许会计师和商业顾问)是普科国际的成员公司。PKF国际在全球150个国家都有分支机构，在审计、会计和商业咨询方面提供高水平的全球专业知识网络。</p><p><br/></p>', NULL, NULL, NULL, NULL, 'L', 'ZH', '33c37a6ae91411eaa9a3e454e8b99384', NULL, 0, '0', '36421894e90111eaa9a3e454e8b99384', NULL, '2020-11-17 10:56:55', '166', '2020-11-17 10:56:55');
INSERT INTO `base_think_tank_info` VALUES ('8d2d9927288011eb993320040ff5fc9c', '唐古嘉雅公司', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '08', 'asia', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'ZH', '33c37ad3e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '3642194be90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:55', '1', '2020-11-17 10:56:55');
INSERT INTO `base_think_tank_info` VALUES ('8d2d9dd6288011eb993320040ff5fc9c', 'CV Tangguh Jaya Perkasa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '08', 'asia', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'EN', '33c37ad3e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '3642194be90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:55', '1', '2020-11-17 10:56:55');
INSERT INTO `base_think_tank_info` VALUES ('8d559c27288011eb993320040ff5fc9c', 'Zhentang Technology (HK) Co.,Ltd', NULL, NULL, '印度尼西亚', 'indonesia', NULL, NULL, 'Jakarta', NULL, 'Jakarta', '2007-01-01 00:00:00', NULL, NULL, NULL, 'http://www.zhentanggroup.com/', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '亚洲', '咨询公司', '08', 'asia', '', NULL, NULL, NULL, '<p>Zhentang company start the business in 1999 as consultant for Glass n Ceramic Industries in Indonesia, then in 2005 Zhentang Technology Co. Ltd established in Zuhai China , than in 2007 we registered in Hongkong, and change name become Zhentang Technology Co. Ltd (HK).This current time our focus are in Ceramics and Glass business. In Early of 2010, we make our Indonesian representative in Jakarta and we start new line business in Chemical section.</p><p><br/></p>', NULL, NULL, NULL, NULL, 'Z', 'EN', '33c37b41e91411eaa9a3e454e8b99384', 'unit/2020/09/28/a5608ad925684e4ea3b3bbfce8bfd0f7.png', 0, '0', '364219f2e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:55', '2', '2020-11-17 10:56:55');
INSERT INTO `base_think_tank_info` VALUES ('8d7da260288011eb993320040ff5fc9c', '振唐科技（香港）有限公司', NULL, NULL, '印度尼西亚', 'indonesia', NULL, NULL, '雅加达', NULL, '雅加达', '2007-01-01 00:00:00', NULL, NULL, NULL, 'http://www.zhentanggroup.com/', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '亚洲', '咨询公司', '08', 'asia', '', NULL, NULL, NULL, '<p>公司成立于1999年，在印度尼西亚担任玻璃陶瓷行业的顾问，2005年在中国祖海成立了振堂科技有限公司，2007年在香港注册，更名为振堂科技有限公司(香港)。目前我们的重点是陶瓷和玻璃业务。2010年初，我们在雅加达设立了印尼代表处，并在化工部门开始了新的生产线业务。</p><p><br/></p>', NULL, NULL, NULL, NULL, 'Z', 'ZH', '33c37b41e91411eaa9a3e454e8b99384', 'unit/2020/09/28/1e531740a845418990c4c2f018587a41.png', 0, '0', '364219f2e90111eaa9a3e454e8b99384', NULL, '2020-11-17 10:56:55', '2', '2020-11-17 10:56:55');
INSERT INTO `base_think_tank_info` VALUES ('8dae6660288011eb993320040ff5fc9c', 'Jirang Clean Technologies JCT Ltd', NULL, NULL, '瑞士', 'switzerland', NULL, NULL, 'WINTERTHUR', NULL, 'WINTERTHUR', '2017-11-27 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '欧洲', '咨询公司', '08', 'europe', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'J', 'EN', '33c37bb8e91411eaa9a3e454e8b99384', 'unit/2020/09/26/4db043a5d0a444e1a042d537b5a76b87.png', 0, '0', '36421aa2e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:56', '1', '2020-11-17 10:56:56');
INSERT INTO `base_think_tank_info` VALUES ('8dd30449288011eb993320040ff5fc9c', '瑞士JCT清洁技术咨询机构', NULL, NULL, '瑞士', 'switzerland', NULL, NULL, '温特图尔', NULL, '温特图尔', '2017-11-27 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '欧洲', '咨询公司', '08', 'europe', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'R', 'ZH', '33c37bb8e91411eaa9a3e454e8b99384', 'unit/2020/09/26/4accffd1553f49728c8513ba60b14737.png', 0, '0', '36421aa2e90111eaa9a3e454e8b99384', NULL, '2020-11-17 10:56:56', '1', '2020-11-17 10:56:56');
INSERT INTO `base_think_tank_info` VALUES ('8e025a3b288011eb993320040ff5fc9c', '阿尔及利亚爱途比商业信息公司', NULL, NULL, NULL, 'algeria', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '08', 'africa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'ZH', '33c37c25e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '36421b5fe90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:56', '1', '2020-11-17 10:56:56');
INSERT INTO `base_think_tank_info` VALUES ('8e025e4a288011eb993320040ff5fc9c', 'Sarl I2b Algeria', NULL, NULL, NULL, 'algeria', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '08', 'africa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'EN', '33c37c25e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '36421b5fe90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:56', '1', '2020-11-17 10:56:56');
INSERT INTO `base_think_tank_info` VALUES ('8e288cc9288011eb993320040ff5fc9c', '托恩规划设计公司', NULL, NULL, NULL, 'russia', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '08', 'europe', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'ZH', '33c37cbce91411eaa9a3e454e8b99384', NULL, NULL, NULL, '36421c17e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:57', '1', '2020-11-17 10:56:57');
INSERT INTO `base_think_tank_info` VALUES ('8e289169288011eb993320040ff5fc9c', 'Ton Corporation Ltd.', NULL, NULL, NULL, 'russia', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '08', 'europe', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'EN', '33c37cbce91411eaa9a3e454e8b99384', NULL, NULL, NULL, '36421c17e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:57', '1', '2020-11-17 10:56:57');
INSERT INTO `base_think_tank_info` VALUES ('8e507fd6288011eb993320040ff5fc9c', 'Atlantico Energia', NULL, NULL, '巴西', 'brazil', NULL, NULL, 'Sao Paulo', NULL, 'Sao Paulo', '2009-01-01 00:00:00', NULL, NULL, NULL, 'www.atlanticoenergia.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '南美洲', '咨询公司', '08', 'southamerica', '', NULL, NULL, NULL, '<p>Atlantic Renewable Energies establishes a safer and profitable business model for its investors, keeping its commitment to provide a clean and reliable energy source.</p><p>&nbsp;</p><p>Quality is a fundamental feature of our enterprises, that demonstrate high capacity factors and guaranteed power generation. Combined with Atlantic’s management model, that follows ESG (Environmental, Social and Corporate Governance) principles, high technology and qualified professionals guarantee reliability in the operation.</p><p>&nbsp;</p><p>Sustainability is inextricable from Atlantic’s business strategy. In the regions where the company operates, its actions focus on reducing environmental impact, developing local communities and providing safety to workers.</p><p><br/></p>', NULL, NULL, NULL, NULL, 'A', 'EN', '33c37d2ce91411eaa9a3e454e8b99384', 'unit/2020/09/28/ee343c426aa44b77af2ec9801a084370.png', 0, '0', '36421cc6e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:57', '2', '2020-11-17 10:56:57');
INSERT INTO `base_think_tank_info` VALUES ('8e755680288011eb993320040ff5fc9c', '大西洋能源咨询公司', NULL, NULL, '巴西', 'brazil', NULL, NULL, '圣保罗', NULL, '圣保罗', '2009-01-01 00:00:00', NULL, NULL, NULL, 'www.atlanticoenergia.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '南美洲', '咨询公司', '08', 'southamerica', '', NULL, NULL, NULL, '<p>大西洋可再生能源公司为其投资者建立了更安全和有利可图的商业模式，并恪守提供清洁和可靠能源的承诺。</p><p>质量是企业的基本特征，表现出高容量因子和有保证的发电能力。结合遵循ESG（环境，社会和公司治理）原则的Atlantic的管理模式，高科技和合格的专业人员可确保运营的可靠性。</p><p>可持续发展与大西洋能源咨询公司的业务战略密不可分。在公司经营的地区，其行动重点是减少环境影响，发展当地社区并为工人提供安全。</p><p><br/></p>', NULL, NULL, NULL, NULL, 'D', 'ZH', '33c37d2ce91411eaa9a3e454e8b99384', 'unit/2020/09/28/b2a00dd7532547d1afffe0b6847af5d4.png', 0, '0', '36421cc6e90111eaa9a3e454e8b99384', NULL, '2020-11-17 10:56:57', '2', '2020-11-17 10:56:57');
INSERT INTO `base_think_tank_info` VALUES ('8ea6e6c3288011eb993320040ff5fc9c', 'Grid Strategies LLC', NULL, NULL, '美国', 'united states', NULL, NULL, NULL, NULL, NULL, '2017-01-17 00:00:00', 'ROBERT GRAMLICH', NULL, NULL, 'www.gridstrategiesllc.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '北美洲', '咨询公司', '08', 'northamerica', '', NULL, NULL, NULL, '<p>Grid Strategies LLC is a power sector consulting firm helping clients understand the opportunities and barriers to integrating clean energy into the electric grid. Drawing on extensive experience in transmission and wholesale markets, Grid Strategies analyzes and helps advance grid integration solutions.&nbsp; Based in the Washington DC area,&nbsp; the firm is actively engaged with the Federal Energy Regulatory Commission (FERC), Department of Energy, state Public Utility Commissions, Regional Transmission Organizations, the North American Electric Reliability Corporation (NERC), Congressional committees, the administration, and various stakeholders</p>', NULL, NULL, NULL, NULL, 'G', 'EN', '33c37d9ae91411eaa9a3e454e8b99384', 'unit/2020/09/26/db9c3bfc1ea14bea872d9d196bc2e38b.png', 0, '0', '36421d78e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:57', '1', '2020-11-17 10:56:57');
INSERT INTO `base_think_tank_info` VALUES ('8ecd3073288011eb993320040ff5fc9c', '电网策略咨询公司', NULL, NULL, '美国', 'united states', NULL, NULL, '贝塞斯达', NULL, '贝塞斯达', '2017-01-17 00:00:00', '罗伯特·格拉米奇', NULL, NULL, 'www.gridstrategiesllc.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '北美洲', '咨询公司', '08', 'northamerica', '', NULL, NULL, NULL, '<p><span style=\"font-family: 等线;font-size: 15px\"><span style=\"font-family:等线\">电网策略咨询公司</span></span><span style=\";font-family:等线;font-size:14px\"><span style=\"font-family:等线\">是一家电力行业咨询公司，帮助客户了解将清洁能源融入电网的机遇和障碍。利用在输电和批发市场的广泛经验，电网战略分析并帮助推进电网集成解决方案。该公司总部位于华盛顿特区，积极与联邦能源监管委员会</span></span><span style=\";font-family:等线;font-size:14px\">(FERC)、能源部、州公共事业委员会、地区输电组织、北美电力可靠性公司(NERC)、国会委员会、政府以及各种利益相关者合作。</span></p><p><br/></p>', NULL, NULL, NULL, NULL, 'D', 'ZH', '33c37d9ae91411eaa9a3e454e8b99384', 'unit/2020/09/26/e5d59a395de24e02af778a193d6a928a.png', 0, '0', '36421d78e90111eaa9a3e454e8b99384', NULL, '2020-11-17 10:56:58', '1', '2020-11-17 10:56:58');
INSERT INTO `base_think_tank_info` VALUES ('8efeae39288011eb993320040ff5fc9c', 'GEO Ingenieria S.A.', NULL, NULL, '哥斯达黎加', 'costa rica', NULL, NULL, 'SAN JOSE', NULL, 'SAN JOSE', '1982-01-01 00:00:00', NULL, NULL, NULL, 'http://www.geoingenieria.co.cr/', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '南美洲', '咨询公司', '08', 'southamerica', '', NULL, NULL, NULL, '<p>Geo Ingeniería was established in Costa Rica in 1982 as a multi-disciplinary engineering consulting company, specialized in renewable energy and climate change projects. The company provides a full range of engineering management and consulting services, both in the local and international markets.</p><p><br/></p>', NULL, NULL, NULL, NULL, 'G', 'EN', '33c37e09e91411eaa9a3e454e8b99384', 'unit/2020/09/28/007d1f4cad8440449f4e590335aca050.png', 0, '0', '36421e60e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:58', '166', '2020-11-17 10:56:58');
INSERT INTO `base_think_tank_info` VALUES ('8f251dbc288011eb993320040ff5fc9c', '哥斯达黎加GEO能源咨询公司', NULL, NULL, '哥斯达黎加', 'costa rica', NULL, NULL, '圣何塞', NULL, '圣何塞', '1982-01-01 00:00:00', NULL, NULL, NULL, 'http://www.geoingenieria.co.cr/', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '南美洲', '咨询公司', '08', 'southamerica', '', NULL, NULL, NULL, '<p>哥斯达黎加GEO能源咨询公司于1982年在哥斯达黎加成立，拥有一支由工程，环境研究，气候变化，项目融资，基础设施领域的顾问组成的专家团队，以及专门从事野外调查任务的技术人员，此外，私人，国家和国际银行。</p><p><br/></p>', NULL, NULL, NULL, NULL, 'G', 'ZH', '33c37e09e91411eaa9a3e454e8b99384', 'unit/2020/09/28/462a7db9d36849df93e6e26b76569c10.png', 0, '0', '36421e60e90111eaa9a3e454e8b99384', NULL, '2020-11-17 10:56:58', '166', '2020-11-17 10:56:58');
INSERT INTO `base_think_tank_info` VALUES ('8f567f4c288011eb993320040ff5fc9c', 'Grupo Induser SRL', NULL, NULL, '阿根廷', 'argentina', NULL, NULL, 'Buenos Aires', NULL, 'Buenos Aires', '1991-01-01 00:00:00', NULL, NULL, NULL, 'www.induser.com.ar', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '南美洲', '咨询公司', '08', 'southamerica', '', NULL, NULL, NULL, '<p>Grupo Induser SRL with a solid and recognized track record in the industrial analysis laboratory market. Accredited for more than a decade by the Argentine Accreditation Body (OAA) to carry out tests according to ISO 17.025.</p><p><br/></p>', NULL, NULL, NULL, NULL, 'G', 'EN', '33c37edce91411eaa9a3e454e8b99384', 'unit/2020/09/28/47a04f407d0c4121bccea5bea45f20a4.jpg', 0, '0', '36421f0fe90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:59', '2', '2020-11-17 10:56:59');
INSERT INTO `base_think_tank_info` VALUES ('8f7cb682288011eb993320040ff5fc9c', 'SRL能源与环境技术咨询公司', NULL, NULL, '阿根廷', 'argentina', NULL, NULL, '布宜诺斯艾利斯', NULL, '布宜诺斯艾利斯', '1991-01-01 00:00:00', NULL, NULL, NULL, 'www.induser.com.ar', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '南美洲', '咨询公司', '08', 'southamerica', '', NULL, NULL, NULL, '<p>SRL能源与环境技术咨询公司在工业分析实验室市场上拥有可靠的公认记录。 由阿根廷认可机构（OAA）认可的十多年来，通过ISO 17.025进行了测试。</p><p><br/></p>', NULL, NULL, NULL, NULL, 'S', 'ZH', '33c37edce91411eaa9a3e454e8b99384', 'unit/2020/09/28/36fa6c045006416192844bb8f30758b3.jpg', 0, '0', '36421f0fe90111eaa9a3e454e8b99384', NULL, '2020-11-17 10:56:59', '2', '2020-11-17 10:56:59');
INSERT INTO `base_think_tank_info` VALUES ('8faea4c0288011eb993320040ff5fc9c', 'National Rating Agency Limited Liability Company (NRA)', NULL, NULL, '俄罗斯', 'russia', NULL, NULL, 'Moscow', NULL, 'Moscow', '2002-01-01 00:00:00', NULL, NULL, NULL, 'www.ra-national.ru', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '欧洲', '咨询公司', '08', 'europe', '', NULL, NULL, NULL, '<p>The National Rating Agency (NRA) was established in 2002. Over 1000 banks and corporates are involved in our other market information projects, whose products are regularly covered by the media and appear on NRA’s website and social networks.</p><p><br/></p>', NULL, NULL, NULL, NULL, 'N', 'EN', '33c37f48e91411eaa9a3e454e8b99384', 'unit/2020/09/28/92a75b7456dd4e6da65e47a8aeff421d.jpg', 0, '0', '36421fbbe90111eaa9a3e454e8b99384', '1', '2020-11-17 10:56:59', '166', '2020-11-17 10:56:59');
INSERT INTO `base_think_tank_info` VALUES ('8fd48fe1288011eb993320040ff5fc9c', '俄罗斯国家评级标准机构', NULL, NULL, '俄罗斯', 'russia', NULL, NULL, '莫斯科', NULL, '莫斯科', '2002-01-01 00:00:00', NULL, NULL, NULL, 'www.ra-national.ru', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '欧洲', '咨询公司', '08', 'europe', '', NULL, NULL, NULL, '<p>俄罗斯国家评级标准机构（NRA）成立于2002年。超过1000家银行和公司参与了公司的其他市场信息项目，其产品定期被媒体报道，并出现在NRA的网站和社交网络上。</p><p><br/></p>', NULL, NULL, NULL, NULL, 'E', 'ZH', '33c37f48e91411eaa9a3e454e8b99384', 'unit/2020/09/28/629b0326ac1947c7a2a8cd5e1b514154.jpg', 0, '0', '36421fbbe90111eaa9a3e454e8b99384', NULL, '2020-11-17 10:56:59', '166', '2020-11-17 10:56:59');
INSERT INTO `base_think_tank_info` VALUES ('9003eb89288011eb993320040ff5fc9c', '立陶宛尤兹咨询公司', NULL, NULL, NULL, 'lithuania', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '08', 'europe', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'ZH', '33c37fbde91411eaa9a3e454e8b99384', NULL, NULL, NULL, '3642206fe90111eaa9a3e454e8b99384', '1', '2020-11-17 10:57:00', '1', '2020-11-17 10:57:00');
INSERT INTO `base_think_tank_info` VALUES ('9003ef09288011eb993320040ff5fc9c', 'Lithuanian Auto UZ Company', NULL, NULL, NULL, 'lithuania', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '08', 'europe', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'EN', '33c37fbde91411eaa9a3e454e8b99384', NULL, NULL, NULL, '3642206fe90111eaa9a3e454e8b99384', '1', '2020-11-17 10:57:00', '1', '2020-11-17 10:57:00');
INSERT INTO `base_think_tank_info` VALUES ('9029d6b2288011eb993320040ff5fc9c', '谦益吉事务所', NULL, NULL, NULL, 'thailand', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '08', 'asia', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'ZH', '33c38035e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '3642212be90111eaa9a3e454e8b99384', '1', '2020-11-17 10:57:00', '1', '2020-11-17 10:57:00');
INSERT INTO `base_think_tank_info` VALUES ('9029da51288011eb993320040ff5fc9c', 'Kanchanakit Office', NULL, NULL, NULL, 'thailand', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '08', 'asia', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'EN', '33c38035e91411eaa9a3e454e8b99384', NULL, NULL, NULL, '3642212be90111eaa9a3e454e8b99384', '1', '2020-11-17 10:57:00', '1', '2020-11-17 10:57:00');
INSERT INTO `base_think_tank_info` VALUES ('905247cd288011eb993320040ff5fc9c', 'CEBIZ', NULL, NULL, '比利时', 'belgium', NULL, NULL, 'Brussels', NULL, 'Brussels', '2017-01-01 00:00:00', 'Baldan ,  Frédéric', NULL, NULL, 'www.cebiz.eu', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '欧洲', '咨询公司', '08', 'europe', '', NULL, NULL, NULL, '<p>CEBiz is a consulting company specialized in Sino-European Lobbying and Business Development. Its headquarter is based in Brussels, which is the capital of the European Union.</p><p><br/></p>', NULL, NULL, NULL, NULL, 'C', 'EN', '33c380a3e91411eaa9a3e454e8b99384', 'unit/2020/09/28/256ded942641431b94818b37063a3496.jpg', 0, '0', '36450f0fe90111eaa9a3e454e8b99384', '1', '2020-11-17 10:57:00', '166', '2020-11-17 10:57:00');
INSERT INTO `base_think_tank_info` VALUES ('90787e4c288011eb993320040ff5fc9c', '赛百思中欧商务咨询公司', NULL, NULL, '比利时', 'belgium', NULL, NULL, '布鲁塞尔', NULL, '布鲁塞尔', '2017-01-01 00:00:00', 'Baldan ,  Frédéric', NULL, NULL, 'www.cebiz.eu', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '欧洲', '咨询公司', '08', 'europe', '', NULL, NULL, NULL, '<p>赛百思中欧商务咨询公司是一家专门从事中欧游说和业务发展的咨询公司。它的总部设在欧盟的首都布鲁塞尔。</p><p><br/></p>', NULL, NULL, NULL, NULL, 'S', 'ZH', '33c380a3e91411eaa9a3e454e8b99384', 'unit/2020/09/28/88c34cdcbe3a431aa7b0158dece12dc6.jpg', 0, '0', '36450f0fe90111eaa9a3e454e8b99384', NULL, '2020-11-17 10:57:00', '166', '2020-11-17 10:57:00');
INSERT INTO `base_think_tank_info` VALUES ('90a8cd65288011eb993320040ff5fc9c', '贝密斯能源咨询公司', NULL, NULL, NULL, 'united states', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '08', 'northamerica', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'ZH', '33c3810fe91411eaa9a3e454e8b99384', NULL, NULL, NULL, '36450fc3e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:57:01', '1', '2020-11-17 10:57:01');
INSERT INTO `base_think_tank_info` VALUES ('90a8d1b1288011eb993320040ff5fc9c', 'Baymeath Group', NULL, NULL, NULL, 'united states', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '08', 'northamerica', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'EN', '33c3810fe91411eaa9a3e454e8b99384', NULL, NULL, NULL, '36450fc3e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:57:01', '1', '2020-11-17 10:57:01');
INSERT INTO `base_think_tank_info` VALUES ('90ea0f62288011eb993320040ff5fc9c', 'TransGrid Solutions', NULL, NULL, '加拿大', 'canada', NULL, NULL, 'Vancouver', NULL, 'Vancouver', NULL, NULL, NULL, NULL, 'TransGridSolutions.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '北美洲', '咨询公司', '08', 'northamerica', '', NULL, NULL, NULL, '<p>TransGrid Solutions is a world leader in power systems consulting, with decades of experience delivering peace of mind to clients around the globe. TGS engineers are power systems experts – with specialized knowledge and deep expertise to help navigate your project in the world’s most complex environments.<span style=\"font-family:&#39;MS Gothic&#39;\"></span></p><p><br/></p>', NULL, NULL, NULL, NULL, 'T', 'EN', '33c3817be91411eaa9a3e454e8b99384', 'unit/2020/09/28/8deb19d13b614ada8df650bf913286d6.png', 0, '0', '36451074e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:57:01', '166', '2020-11-17 10:57:01');
INSERT INTO `base_think_tank_info` VALUES ('91113794288011eb993320040ff5fc9c', '大电网解决方案咨询公司', NULL, NULL, '加拿大', 'canada', NULL, NULL, '温哥华', NULL, '温哥华', NULL, NULL, NULL, NULL, 'TransGridSolutions.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '北美洲', '咨询公司', '08', 'northamerica', '', NULL, NULL, NULL, '<p>大电网解决方案咨询公司（TransGrid Solutions，TGS）是由一群经验丰富的电力系统工程师于2002年创建的，TGS是电力系统咨询领域的全球领导者，拥有数十年的经验，可为全球客户带来安心。TGS的工程师是电力系统专家-具有专业知识和丰富的专业知识，可帮助您在世界上最复杂的环境中进行项目导航。</p><p><br/></p>', NULL, NULL, NULL, NULL, 'D', 'ZH', '33c3817be91411eaa9a3e454e8b99384', 'unit/2020/09/28/5dd0be677fc643b49c94ee4c6a354038.png', 0, '0', '36451074e90111eaa9a3e454e8b99384', NULL, '2020-11-17 10:57:01', '166', '2020-11-17 10:57:01');
INSERT INTO `base_think_tank_info` VALUES ('9141a7a6288011eb993320040ff5fc9c', 'Shanghai Qiyuan Technology Co., Ltd.', NULL, '6660', '中国', 'china', NULL, NULL, 'SHANGHAI', NULL, 'SHANGHAI', '2001-12-03 00:00:00', 'Xiangyun Kong', NULL, NULL, 'http://www.amt.com.cn/aboutus-en.html', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '亚洲', '咨询公司', '08', 'asia', '', NULL, NULL, NULL, '<p>AMT(Shanghai Qiyuan Technology Co., LTD.), founded in 1998, is a &quot;management +IT&quot; consulting service provider.</p><p><br/></p>', NULL, NULL, NULL, NULL, 'S', 'EN', '33b92ed1e91411eaa9a3e454e8b99384', NULL, 0, '0', '364513f1e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:57:02', '2', '2020-11-17 10:57:02');
INSERT INTO `base_think_tank_info` VALUES ('918a062e288011eb993320040ff5fc9c', '上海企源科技股份有限公司', NULL, '6660', '中国', 'china', NULL, NULL, '上海', NULL, '上海', '2001-12-03 00:00:00', '孔祥云', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '亚洲', '咨询公司', '08', 'asia', '', NULL, NULL, NULL, '<p>AMT(上海企源科技股份有限公司)创立于1998年，是一家“管理+IT”咨询综合服务机构。</p><p><br/></p>', NULL, NULL, NULL, NULL, 'S', 'ZH', '33b92ed1e91411eaa9a3e454e8b99384', NULL, 0, '0', '364513f1e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:57:02', '2', '2020-11-17 10:57:02');
INSERT INTO `base_think_tank_info` VALUES ('91bc6df3288011eb993320040ff5fc9c', 'Beijing Neweal Education Consulting Co., Ltd.', NULL, '138', '中国', 'china', NULL, NULL, 'BEIJING', NULL, 'BEIJING', '2011-06-08 00:00:00', 'Qingfeng Dong', NULL, NULL, 'www.neweal.cn', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '亚洲', '咨询公司', '08', 'asia', '', NULL, NULL, NULL, '<p>Beijing new yi tai education consulting co., LTD. (hereinafter referred to as new yi consulting) is a company dedicated to the great rejuvenation of the Chinese nation and upgrading comprehensive competitiveness of domestic enterprises as the goal, to the idea of Chinese traditional culture and western management experience, combining the enterprise reform, strategic consulting, team operation, such as brand marketing enterprise comprehensive management optimization to provide a series of innovation management consulting services and high-end management training.</p><p><br/></p>', NULL, NULL, NULL, NULL, 'B', 'EN', '33b92df6e91411eaa9a3e454e8b99384', 'unit/2020/09/28/f9c3544d6283431b9a366becab705033.png', 0, '0', '36485b28e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:57:03', '2', '2020-11-17 10:57:03');
INSERT INTO `base_think_tank_info` VALUES ('91e8144b288011eb993320040ff5fc9c', '北京新易太和教育咨询有限公司', NULL, '138', '中国', 'china', NULL, NULL, '北京', NULL, '北京', '2011-06-08 00:00:00', '董庆锋', NULL, NULL, 'www.neweal.cn', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '亚洲', '咨询公司', '08', 'asia', '', NULL, NULL, NULL, '<p>北京新易太和教育咨询有限公司（简称新易咨询）是一家致力于以中华民族伟大复兴及本土企业综合竞争力提升为奋斗目标，以中国传统文化思想与西方管理模式经验相结合，在企业变革、战略咨询、团队运营、品牌营销等企业全方位管理优化方面提供一系列创新管理咨询及高端管理培训服务。</p><p><br/></p>', NULL, NULL, NULL, NULL, 'B', 'ZH', '33b92df6e91411eaa9a3e454e8b99384', 'unit/2020/09/28/c18f68a7bcf84f37bba0a8aaba4d71b2.png', 0, '0', '36485b28e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:57:03', '2', '2020-11-17 10:57:03');
INSERT INTO `base_think_tank_info` VALUES ('921ad3c1288011eb993320040ff5fc9c', 'Xi`an Hezhifang Enterprise Management Consulting Co., Ltd.', NULL, '1000', '中国', 'china', NULL, NULL, 'XIAN', NULL, 'XIAN', '2015-04-29 00:00:00', 'Hongtao Wu', NULL, NULL, 'www.hezhifangzixun.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '亚洲', '咨询公司', '08', 'asia', '', NULL, NULL, NULL, '<p>Xi &#39;an Hezhifang Enterprise Management Consulting Co., LTD is the leading management consulting company in China.</p><p><br/></p>', NULL, NULL, NULL, NULL, 'X', 'EN', '33b92d7de91411eaa9a3e454e8b99384', NULL, 0, '0', '365666f1e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:57:03', '2', '2020-11-17 10:57:03');
INSERT INTO `base_think_tank_info` VALUES ('92412e5b288011eb993320040ff5fc9c', '西安和智方企业管理咨询有限公司', NULL, '1000', '中国', 'china', NULL, NULL, '西安', NULL, '西安', '2015-04-29 00:00:00', '吴洪涛', NULL, NULL, 'www.hezhifangzixun.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '亚洲', '咨询公司', '08', 'asia', '', NULL, NULL, NULL, '<p>西安和智方企业管理咨询有限公司，是目前国内领先的管理咨询公司。</p><p><br/></p>', NULL, NULL, NULL, NULL, 'X', 'ZH', '33b92d7de91411eaa9a3e454e8b99384', NULL, 0, '0', '365666f1e90111eaa9a3e454e8b99384', '1', '2020-11-17 10:57:03', '2', '2020-11-17 10:57:03');
INSERT INTO `base_think_tank_info` VALUES ('92721751288011eb993320040ff5fc9c', '南方能源咨询公司', NULL, NULL, NULL, 'chile', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '08', 'southamerica', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'N', 'ZH', '5f5318810b6a11eba650e454e8b99384', NULL, 0, '1', 'b9a4a2f92725d5067e25613c11cf946a', '1', '2020-11-17 10:57:04', '1', '2020-11-17 10:57:04');
INSERT INTO `base_think_tank_info` VALUES ('92987d5b288011eb993320040ff5fc9c', 'Surenergia S.A.', NULL, NULL, NULL, 'chile', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '08', 'southamerica', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'S', 'EN', '5f5318810b6a11eba650e454e8b99384', NULL, 0, '1', 'b9a4a2f92725d5067e25613c11cf946a', '1', '2020-11-17 10:57:04', '1', '2020-11-17 10:57:04');
SET FOREIGN_KEY_CHECKS = 1;
update cms_category set is_audit = 'y',object_list_name = 'ChooseFinancialInstitutionsList',object_relation_ship = 'y',object_name = '金融服务' where number = 'financial_institutions';
/*2020年11月24日 16:20:30生成 生产Sql ljh*/