(1)在网关中实现跨域
全局配置类实现
包名:com.atguigu.gmall.gateway.config
创建CorsConfig类
@Configuration
public class CorsConfig {@Beanpublic CorsWebFilter corsWebFilter(){// cors跨域配置对象CorsConfiguration configuration = new CorsConfiguration();configuration.addAllowedOrigin("*"); //设置允许访问的网络configuration.setAllowCredentials(true); // 设置是否从服务器获取cookieconfiguration.addAllowedMethod("*"); // 设置请求方法 * 表示任意configuration.addAllowedHeader("*"); // 所有请求头信息 * 表示任意// 配置源对象UrlBasedCorsConfigurationSource configurationSource = new UrlBasedCorsConfigurationSource();configurationSource.registerCorsConfiguration("/**", configuration);// cors过滤器对象return new CorsWebFilter(configurationSource);}
}
(2)配置文件迁移nacos
1.重新安装nacos,nacos数据保存至mysql,先删除已安装的nacos,再安装
2.资源库获取nacos数据库表结构并且导入数据库
导入nacos.sql:
/*
Navicat MySQL Data TransferSource Server : 192.168.200.129
Source Server Version : 50735
Source Host : 192.168.200.129:3306
Source Database : nacosTarget Server Type : MYSQL
Target Server Version : 50735
File Encoding : 65001Date: 2021-10-19 16:59:32
*/SET FOREIGN_KEY_CHECKS=0;-- ----------------------------
-- Table structure for `config_info`
-- ----------------------------
DROP TABLE IF EXISTS `config_info`;
CREATE TABLE `config_info` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',`data_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'data_id',`group_id` varchar(255) COLLATE utf8_bin DEFAULT NULL,`content` longtext COLLATE utf8_bin NOT NULL COMMENT 'content',`md5` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT 'md5',`gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '创建时间',`gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '修改时间',`src_user` text COLLATE utf8_bin COMMENT 'source user',`src_ip` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT 'source ip',`app_name` varchar(128) COLLATE utf8_bin DEFAULT NULL,`tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT '租户字段',`c_desc` varchar(256) COLLATE utf8_bin DEFAULT NULL,`c_use` varchar(64) COLLATE utf8_bin DEFAULT NULL,`effect` varchar(64) COLLATE utf8_bin DEFAULT NULL,`type` varchar(64) COLLATE utf8_bin DEFAULT NULL,`c_schema` text COLLATE utf8_bin,PRIMARY KEY (`id`),UNIQUE KEY `uk_configinfo_datagrouptenant` (`data_id`,`group_id`,`tenant_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info';-- ----------------------------
-- Records of config_info
-- ----------------------------
INSERT INTO `config_info` VALUES ('3', 'common.yaml', 'DEFAULT_GROUP', 0x6D7962617469732D706C75733A0A2020636F6E66696775726174696F6E3A0A202020206C6F672D696D706C3A206F72672E6170616368652E6962617469732E6C6F6767696E672E7374646F75742E5374644F7574496D706C0A20206D61707065722D6C6F636174696F6E733A20636C617373706174683A6D61707065722F2A4D61707065722E786D6C0A666569676E3A0A202073656E74696E656C3A0A20202020656E61626C65643A20747275650A2020636C69656E743A0A20202020636F6E6669673A0A20202020202064656661756C743A0A20202020202020207265616454696D656F75743A2033303030300A2020202020202020636F6E6E65637454696D656F75743A2031303030300A737072696E673A0A20207A69706B696E3A0A20202020626173652D75726C3A20687474703A2F2F3139322E3136382E3230302E3132393A393431310A20202020646973636F766572792D636C69656E742D656E61626C65643A2066616C73650A2020202073656E6465723A0A202020202020747970653A207765620A20202320636C6F75643A0A20202320202073656E74696E656C3A0A20202320202020207472616E73706F72743A0A2020232020202020202064617368626F6172643A20687474703A2F2F3139322E3136382E3230302E3132393A383835380A20207261626269746D713A0A20202020686F73743A203139322E3136382E3230302E3132390A20202020706F72743A20353637320A20202020757365726E616D653A2067756573740A2020202070617373776F72643A2067756573740A202020207075626C69736865722D636F6E6669726D2D747970653A20636F7272656C617465640A202020207075626C69736865722D72657475726E733A20747275650A202020206C697374656E65723A0A20202020202073696D706C653A0A202020202020202061636B6E6F776C656467652D6D6F64653A206D616E75616C2023E9BB98E8AEA4E68385E586B5E4B88BE6B688E681AFE6B688E8B4B9E88085E698AFE887AAE58AA8E7A1AEE8AEA4E6B688E681AFE79A84EFBC8CE5A682E69E9CE8A681E6898BE58AA8E7A1AEE8AEA4E6B688E681AFE58899E99C80E8A681E4BFAEE694B9E7A1AEE8AEA4E6A8A1E5BC8FE4B8BA6D616E75616C0A202020202020202070726566657463683A2031202320E6B688E8B4B9E88085E6AF8FE6ACA1E4BB8EE9989FE58897E88EB7E58F96E79A84E6B688E681AFE695B0E9878FE38082E6ADA4E5B19EE680A7E5BD93E4B88DE8AEBEE7BDAEE697B6E4B8BAEFBC9AE8BDAEE8AFA2E58886E58F91EFBC8CE8AEBEE7BDAEE4B8BA31E4B8BAEFBC9AE585ACE5B9B3E58886E58F910A202072656469733A0A20202020686F73743A203139322E3136382E3230302E3132390A20202020706F72743A20363337390A2020202064617461626173653A20300A2020202074696D656F75743A20313830303030300A2020202070617373776F72643A0A202020206C6574747563653A0A202020202020706F6F6C3A0A20202020202020206D61782D6163746976653A2032302023E69C80E5A4A7E8BF9EE68EA5E695B00A20202020202020206D61782D776169743A202D312020202023E69C80E5A4A7E998BBE5A19EE7AD89E5BE85E697B6E997B428E8B49FE695B0E8A1A8E7A4BAE6B2A1E99990E588B6290A20202020202020206D61782D69646C653A20352020202023E69C80E5A4A7E7A9BAE997B20A20202020202020206D696E2D69646C653A2030202020202023E69C80E5B08FE7A9BAE997B20A20206A61636B736F6E3A0A20202020646174652D666F726D61743A20797979792D4D4D2D64642048483A6D6D3A73730A2020202074696D652D7A6F6E653A20474D542B38, '7bf752d402b371d9e7daf435415a32c2', '2021-09-08 05:10:00', '2021-09-24 07:00:15', null, '192.168.200.1', '', '', '', '', '', 'yaml', '');
INSERT INTO `config_info` VALUES ('4', 'server-gateway-dev.yaml', 'DEFAULT_GROUP', 0x7365727665723A0A2020706F72743A2038300A737072696E673A0A202072656469733A0A20202020686F73743A203139322E3136382E3230302E3132390A20202020706F72743A20363337390A2020202064617461626173653A20300A2020202074696D656F75743A20313830303030300A2020202070617373776F72643A0A2020636C6F75643A0A20202020676174657761793A0A202020202020646973636F766572793A20202020202023E698AFE590A6E4B88EE69C8DE58AA1E58F91E78EB0E7BB84E4BBB6E8BF9BE8A18CE7BB93E59088EFBC8CE9809AE8BF872073657276696365496428E5BF85E9A1BBE8AEBEE7BDAEE68890E5A4A7E586992920E8BDACE58F91E588B0E585B7E4BD93E79A84E69C8DE58AA1E5AE9EE4BE8BE38082E9BB98E8AEA4E4B8BA66616C7365EFBC8CE8AEBEE4B8BA74727565E4BEBFE5BC80E590AFE9809AE8BF87E69C8DE58AA1E4B8ADE5BF83E79A84E887AAE58AA8E6A0B9E68DAE2073657276696365496420E5889BE5BBBAE8B7AFE794B1E79A84E58A9FE883BDE380820A20202020202020206C6F6361746F723A20202020202023E8B7AFE794B1E8AEBFE997AEE696B9E5BC8FEFBC9A687474703A2F2F476174657761795F484F53543A476174657761795F504F52542FE5A4A7E58699E79A847365727669636549642F2A2AEFBC8CE585B6E4B8ADE5BEAEE69C8DE58AA1E5BA94E794A8E5908DE9BB98E8AEA4E5A4A7E58699E8AEBFE997AEE380820A20202020202020202020656E61626C65643A20747275650A202020202020726F757465733A0A20202020202020202D2069643A20736572766963652D70726F647563740A202020202020202020207572693A206C623A2F2F736572766963652D70726F647563740A20202020202020202020707265646963617465733A0A2020202020202020202020202D20506174683D2F2A2F70726F647563742F2A2A202320E8B7AFE5BE84E58CB9E9858D0A20202020202020202D2069643A20736572766963652D6974656D0A202020202020202020207572693A206C623A2F2F736572766963652D6974656D0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20506174683D2F2A2F6974656D2F2A2A0A20202020202020202D2069643A20736572766963652D757365720A202020202020202020207572693A206C623A2F2F736572766963652D757365720A20202020202020202020707265646963617465733A0A2020202020202020202020202D20506174683D2F2A2F757365722F2A2A0A20202020202020202D2069643A20736572766963652D636172740A202020202020202020207572693A206C623A2F2F736572766963652D636172740A20202020202020202020707265646963617465733A0A2020202020202020202020202D20506174683D2F2A2F636172742F2A2A0A20202020202020202D2069643A20736572766963652D6F726465720A202020202020202020207572693A206C623A2F2F736572766963652D6F726465720A20202020202020202020707265646963617465733A0A2020202020202020202020202D20506174683D2F2A2F6F726465722F2A2A0A20202020202020202D2069643A20736572766963652D7061796D656E740A202020202020202020207572693A206C623A2F2F736572766963652D7061796D656E740A20202020202020202020707265646963617465733A0A2020202020202020202020202D20506174683D2F2A2F7061796D656E742F2A2A0A20202020202020202D2069643A20736572766963652D61637469766974790A202020202020202020207572693A206C623A2F2F736572766963652D61637469766974790A20202020202020202020707265646963617465733A0A2020202020202020202020202D20506174683D2F2A2F61637469766974792F2A2A202320E8B7AFE5BE84E58CB9E9858D0A20202020202020202D2069643A20736572766963652D636F6D6D656E740A202020202020202020207572693A206C623A2F2F736572766963652D636F6D6D656E740A20202020202020202020707265646963617465733A0A2020202020202020202020202D20506174683D2F2A2F636F6D6D656E742F2A2A0A2020202020202020233D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D776562E5898DE7ABAF3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D0A20202020202020202D2069643A207765622D6974656D0A202020202020202020207572693A206C623A2F2F7765622D616C6C0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20486F73743D6974656D2E676D616C6C2E636F6D0A2020202020202020233D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3DE9A696E9A1B5E5898DE7ABAF3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D0A20202020202020202D2069643A207765622D696E6465780A202020202020202020207572693A206C623A2F2F7765622D616C6C0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20486F73743D7777772E676D616C6C2E636F6D0A20202020202020202D2069643A207765622D6C6973740A202020202020202020207572693A206C623A2F2F7765622D616C6C0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20486F73743D6C6973742E676D616C6C2E636F6D0A20202020202020202D2069643A207765622D70617373706F72740A202020202020202020207572693A206C623A2F2F7765622D616C6C0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20486F73743D70617373706F72742E676D616C6C2E636F6D0A20202020202020202D2069643A207765622D636172740A202020202020202020207572693A206C623A2F2F7765622D616C6C0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20486F73743D636172742E676D616C6C2E636F6D0A20202020202020202D2069643A207765622D6F726465720A202020202020202020207572693A206C623A2F2F7765622D616C6C0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20486F73743D6F726465722E676D616C6C2E636F6D0A20202020202020202D2069643A207765622D7061796D656E740A202020202020202020207572693A206C623A2F2F7765622D616C6C0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20486F73743D7061796D656E742E676D616C6C2E636F6D0A20202020202020202D2069643A207765622D61637469766974790A202020202020202020207572693A206C623A2F2F7765622D616C6C0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20486F73743D61637469766974792E676D616C6C2E636F6D0A20202020202020202D2069643A207765622D636F6D6D656E740A202020202020202020207572693A206C623A2F2F7765622D616C6C0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20486F73743D636F6D6D656E742E676D616C6C2E636F6D0A6175746855726C733A0A202075726C3A2074726164652E68746D6C2C6D794F726465722E68746D6C2C236C6973742E68746D6C2C23616464436172742E68746D6C202320E794A8E688B7E8AEBFE997AEE8AFA5E68EA7E588B6E599A8E79A84E697B6E58099EFBC8CE4BC9AE8A2ABE68BA6E688AAE8B7B3E8BDACE588B0E799BBE5BD95EFBC810A, '6b0b2bec24e127449ea8dabcb20a5b89', '2021-09-08 05:10:00', '2021-09-25 00:56:54', null, '192.168.200.1', '', '', '', '', '', 'yaml', '');
INSERT INTO `config_info` VALUES ('5', 'service-activity-dev.yaml', 'DEFAULT_GROUP', 0x7365727665723A0A2020706F72743A20383230300A737072696E673A0A202064617461736F757263653A0A20202020747970653A20636F6D2E7A61787865722E68696B6172692E48696B61726944617461536F757263650A202020206472697665722D636C6173732D6E616D653A20636F6D2E6D7973716C2E6A6462632E4472697665720A2020202075726C3A206A6462633A6D7973716C3A2F2F3139322E3136382E3230302E3132393A333330362F676D616C6C5F61637469766974793F636861726163746572456E636F64696E673D7574662D382675736553534C3D66616C73650A20202020757365726E616D653A20726F6F740A2020202070617373776F72643A20726F6F740A2020202068696B6172693A0A202020202020636F6E6E656374696F6E2D746573742D71756572793A2053454C45435420310A202020202020636F6E6E656374696F6E2D74696D656F75743A2036303030300A20202020202069646C652D74696D656F75743A203530303030300A2020202020206D61782D6C69666574696D653A203534303030300A2020202020206D6178696D756D2D706F6F6C2D73697A653A2031320A2020202020206D696E696D756D2D69646C653A2031300A202020202020706F6F6C2D6E616D653A2047756C6948696B617269506F6F6C, '97d26ff69be9a6f526dc97dd7939d725', '2021-09-08 05:10:00', '2021-09-30 06:26:59', null, '192.168.200.1', '', '', '', '', '', 'yaml', '');
INSERT INTO `config_info` VALUES ('6', 'service-cart-dev.yaml', 'DEFAULT_GROUP', 0x7365727665723A0A2020706F72743A20383230310A2320737072696E673A0A2320202064617461736F757263653A0A232020202020747970653A20636F6D2E7A61787865722E68696B6172692E48696B61726944617461536F757263650A2320202020206472697665722D636C6173732D6E616D653A20636F6D2E6D7973716C2E6A6462632E4472697665720A23202020202075726C3A206A6462633A6D7973716C3A2F2F6C6F63616C686F73743A333330362F676D616C6C5F6F726465723F636861726163746572456E636F64696E673D7574662D382675736553534C3D66616C73650A232020202020757365726E616D653A20726F6F740A23202020202070617373776F72643A20726F6F740A23202020202068696B6172693A0A2320202020202020636F6E6E656374696F6E2D746573742D71756572793A2053454C45435420310A2320202020202020636F6E6E656374696F6E2D74696D656F75743A2036303030300A232020202020202069646C652D74696D656F75743A203530303030300A23202020202020206D61782D6C69666574696D653A203534303030300A23202020202020206D6178696D756D2D706F6F6C2D73697A653A2031320A23202020202020206D696E696D756D2D69646C653A2031300A2320202020202020706F6F6C2D6E616D653A2047756C6948696B617269506F6F6C0A, '9ac51021de802686cce22a3a173cc7cb', '2021-09-08 05:10:00', '2021-09-08 05:10:00', null, '192.168.200.1', '', '', null, null, null, 'yaml', null);
INSERT INTO `config_info` VALUES ('7', 'service-item-dev.yaml', 'DEFAULT_GROUP', 0x7365727665723A0D0A2020706F72743A2038323032, 'bb8505f90d2099a1d5267b0e037cf1a3', '2021-09-08 05:10:00', '2021-09-08 05:10:00', null, '192.168.200.1', '', '', null, null, null, 'yaml', null);
INSERT INTO `config_info` VALUES ('8', 'service-list-dev.yaml', 'DEFAULT_GROUP', 0x7365727665723A0A2020706F72743A20383230330A0A737072696E673A0A2020656C61737469637365617263683A0A20202020726573743A0A202020202020757269733A20687474703A2F2F3139322E3136382E3230302E3132393A39323030, 'a4a6e54f94f867e72872bc67c7d824f9', '2021-09-08 05:10:00', '2021-09-17 05:54:44', null, '192.168.200.1', '', '', '', '', '', 'yaml', '');
INSERT INTO `config_info` VALUES ('9', 'service-order-dev.yaml', 'DEFAULT_GROUP', 0x7365727665723A0A2020706F72743A20383230340A737072696E673A0A202064617461736F757263653A0A20202020747970653A20636F6D2E7A61787865722E68696B6172692E48696B61726944617461536F757263650A202020206472697665722D636C6173732D6E616D653A20636F6D2E6D7973716C2E6A6462632E4472697665720A2020202075726C3A206A6462633A6D7973716C3A2F2F3139322E3136382E3230302E3132393A333330362F676D616C6C5F6F726465723F636861726163746572456E636F64696E673D7574662D382675736553534C3D66616C73650A20202020757365726E616D653A20726F6F740A2020202070617373776F72643A20726F6F740A2020202068696B6172693A0A202020202020636F6E6E656374696F6E2D746573742D71756572793A2053454C45435420310A202020202020636F6E6E656374696F6E2D74696D656F75743A2036303030300A20202020202069646C652D74696D656F75743A203530303030300A2020202020206D61782D6C69666574696D653A203534303030300A2020202020206D6178696D756D2D706F6F6C2D73697A653A2031320A2020202020206D696E696D756D2D69646C653A2031300A202020202020706F6F6C2D6E616D653A2047756C6948696B617269506F6F6C0A776172653A0A202075726C3A20687474703A2F2F6C6F63616C686F73743A39303031, 'b34bcc1e5084f9c724ba3a2871b9630f', '2021-09-08 05:10:00', '2021-09-25 01:39:45', null, '192.168.200.1', '', '', '', '', '', 'yaml', '');
INSERT INTO `config_info` VALUES ('10', 'service-payment-dev.yaml', 'DEFAULT_GROUP', 0x7365727665723A0A2020706F72743A20383230350A737072696E673A0A202064617461736F757263653A0A20202020747970653A20636F6D2E7A61787865722E68696B6172692E48696B61726944617461536F757263650A202020206472697665722D636C6173732D6E616D653A20636F6D2E6D7973716C2E6A6462632E4472697665720A2020202075726C3A206A6462633A6D7973716C3A2F2F3139322E3136382E3230302E3132393A333330362F676D616C6C5F6F726465723F636861726163746572456E636F64696E673D7574662D382675736553534C3D66616C73650A20202020757365726E616D653A20726F6F740A2020202070617373776F72643A20726F6F740A2020202068696B6172693A0A202020202020636F6E6E656374696F6E2D746573742D71756572793A2053454C45435420310A202020202020636F6E6E656374696F6E2D74696D656F75743A2036303030300A20202020202069646C652D74696D656F75743A203530303030300A2020202020206D61782D6C69666574696D653A203534303030300A2020202020206D6178696D756D2D706F6F6C2D73697A653A2031320A2020202020206D696E696D756D2D69646C653A2031300A202020202020706F6F6C2D6E616D653A2047756C6948696B617269506F6F6C0A616C697061795F7075626C69635F6B65793A204D494942496A414E42676B71686B6947397730424151454641414F43415138414D49494243674B43415145416B57732B3367584D6F736957472B45626652796F7457423077617155337437714D51534278553072334A5A6F4E4435336A765751667A72475A38572B6F624D632B4F677775704F4444567868472F44454B5642497074755551596476416A43534839386D3268636C46636B737370754379397853375079666C5045343770567A5336764133536C7677354F4651327155636B75347061576E427867754C5547506A456E63696A354E637946796B2B2F6B35374D6D72564A77435A61492B6C464F533345713249586330377457584F34732F3253577233454A69774A75744F474264413164647676315572726C307057704546673330704A42364A37597465757864454C39306B754F3565642F766E544B35716751527645656C524F6B55573434784F4E6B313738347632384F4A586D4749436D4E4C312B4B794D2F534662464F53674A5A535631744558557A764C2F78767A46704C774944415141420A616C697061795F75726C3A2068747470733A2F2F6F70656E6170692E616C697061792E636F6D2F676174657761792E646F0A6170705F69643A20323032313030313136333631373435320A6170705F707269766174655F6B65793A204D494945765149424144414E42676B71686B6947397730424151454641415343424B63776767536A41674541416F4942415143385A37455A6D616E78794647734B344C724955654B4B727247785741484967506D55563854745A44732B6A65706C4A537731636B535936335168455534343444357164367872754A48427542333348472B696B346E384E386E5257693341744D6770433036316F713244636774494B4D6D51484F372F706F5944776270445A724F57584979694E73684666554F535455706E7253385576456B73366E3678522F4737327232464730376F5A7A4F3767335873504D723733777059616A4D59432F6268546D36434A4745575A696B4F4E4E44466B51705648612B7A6769747773716C4275764276567747774F48413942386152666F6B77414D6C364244584B6F4838424E6E53454D705753545253776273736179584151574E5537584B444B476F7A626E3455326445626C384743467A696B492F54377962544E6D35677334365A5A42476C712F5942342B76344433743734566C366E41674D4241414543676745414F69647A6865686C69596B416C4C6B316875685630624D51786577456B5138527A78544D32534F52495753327137522B46507459506B48675539325146466738356C4E6C74736935645A304D796C4B554658465259496938434C346D3756364531713132664A50656177566B4258487569673859366931545752764355557475766B546A742B2B41572F30514543484F74424D567A49393565592B765A7756546F7138682F2B55634E6D784B795674363651706F342B722B6355766C764758356D5867515643354674662F4D74484131692B6B6A747A42495443307841766D53584B7A6A4E315968746353397258794D485842694668584C646D764F586A6B6E304F6B6F7372322B746D65735866537744476848335A6C4F64487A69743444363032524E6C306E544131644F55574875436E63733154725762726961783836502F4559766D7A4D6948574356546D6D4E4A4330624D514B42675144304841584B4E735973646A43514F56347433534D714F4B61756C3637782F4B413230506D4D5A5666513273516B796A79466757704C38433136527A66337A493764662B7A4635536B76684659342B4C525A567758356F6B454659547A415A2F4E596F756A312F444142594F5071304530735931382F78747137464A2F43496B38716D437163637A716F79616F786F6143317A4174394534435945383969454F6E4F2B476863493348334C774B42675144466C517A7662586857527952466B6566742F613532584C6E796A367439695037774E4762474353656F4D44724175335A676F7161635550576A354D6753465A64543438483972463470506978586F65336A66554E735742554871443146326472447A376C704C30506270537367793665692B443452775441447375795877726B7672577247726F2B6836704E4A46796C79336E65612F676C6F44744A547A6668464677744E666D717943514B426742587A4D783455774D7363735938326156364D5A4F34562B2F373143726B64737A5A616F69586173775048754231717866686E5136796959795238704F36325352356E73313230466E6A3857466831484A7076396379567032305A616B494F31745867694477654F6837566E496A76784243367573546356367938315153363277324563306877494255765651747A63695547765032354E445834696778535977504757485034682F586E416F474163514E32614B546E42674B6650715063553461632B6472454358676745536742476F662B6D527533635435552F4E53394F7A304E71362B724D566D3144704D48416462757152696B71316143716F56577570353171453068696B5779396E644C364743796E765749444F5347724C57515A326B7970356B6D793562574F57414A364C6C36723759394E64496B2B4E4F6B77363134494646614E416A32535455773475507864527677443345436759454172774F5A7852337A6C2F465A667376564358664B382F6668755A584D4F7036487577716B7934744E70564C764F796968704F4A4F6349466A365A4A686F56646D694C3870312F31532B536D2F373567783174704675724B4D4E636D595A626973454337556B783752516F685A685A54714D5067697A6C56425475356E5233786B6865614A43396F6476796A7257514A3536396566586F3330676B57303461427037413135564E47355A2F553D0A6E6F746966795F7061796D656E745F75726C3A20687474703A2F2F726A736833382E6E6174617070667265652E63632F6170692F7061796D656E742F616C697061792F63616C6C6261636B2F6E6F746966790A72657475726E5F6F726465725F75726C3A20687474703A2F2F7061796D656E742E676D616C6C2E636F6D2F7061792F737563636573732E68746D6C0A72657475726E5F7061796D656E745F75726C3A20687474703A2F2F6170692E676D616C6C2E636F6D2F6170692F7061796D656E742F616C697061792F63616C6C6261636B2F72657475726E0A, 'f2f7293c80635c58561c11d45d45b097', '2021-09-08 05:10:00', '2021-09-30 02:32:07', null, '192.168.200.1', '', '', '', '', '', 'yaml', '');
INSERT INTO `config_info` VALUES ('11', 'service-product-dev.yaml', 'DEFAULT_GROUP', 0x23207365727665723A0A23202020706F72743A20383230360A737072696E673A0A202064617461736F757263653A0A20202020747970653A20636F6D2E7A61787865722E68696B6172692E48696B61726944617461536F757263650A202020206472697665722D636C6173732D6E616D653A20636F6D2E6D7973716C2E6A6462632E4472697665720A2020202075726C3A206A6462633A6D7973716C3A2F2F3139322E3136382E3230302E3132393A333330362F676D616C6C5F70726F647563743F636861726163746572456E636F64696E673D7574662D382675736553534C3D66616C73650A20202020757365726E616D653A20726F6F740A2020202070617373776F72643A20726F6F740A2020202068696B6172693A0A202020202020636F6E6E656374696F6E2D746573742D71756572793A2053454C4543542031202320E887AAE58AA8E6A380E6B58BE8BF9EE68EA50A202020202020636F6E6E656374696F6E2D74696D656F75743A2036303030302023E695B0E68DAEE5BA93E8BF9EE68EA5E8B685E697B6E697B6E997B42CE9BB98E8AEA43330E7A7920A20202020202069646C652D74696D656F75743A203530303030302023E7A9BAE997B2E8BF9EE68EA5E5AD98E6B4BBE69C80E5A4A7E697B6E997B4EFBC8CE9BB98E8AEA4363030303030EFBC883130E58886E9929FEFBC890A2020202020206D61782D6C69666574696D653A203534303030302023E6ADA4E5B19EE680A7E68EA7E588B6E6B1A0E4B8ADE8BF9EE68EA5E79A84E69C80E995BFE7949FE591BDE591A8E69C9FEFBC8CE580BC30E8A1A8E7A4BAE697A0E99990E7949FE591BDE591A8E69C9FEFBC8CE9BB98E8AEA431383030303030E58DB33330E58886E9929F0A2020202020206D6178696D756D2D706F6F6C2D73697A653A2031322023E8BF9EE68EA5E6B1A0E69C80E5A4A7E8BF9EE68EA5E695B0EFBC8CE9BB98E8AEA4E698AF31300A2020202020206D696E696D756D2D69646C653A2031302023E69C80E5B08FE7A9BAE997B2E8BF9EE68EA5E695B0E9878F0A202020202020706F6F6C2D6E616D653A2053504848696B617269506F6F6C202320E8BF9EE68EA5E6B1A0E5908DE7A7B00A6D696E696F3A0A2020656E64706F696E7455726C3A20687474703A2F2F3139322E3136382E3230302E3132393A393030300A20206163636573734B65793A2061646D696E0A202073656372654B65793A2061646D696E3132333435360A20206275636B65744E616D653A20676D616C6C0A, 'c3b9c821881027abd4280fa12526598e', '2021-09-08 05:10:00', '2021-09-15 04:05:41', null, '192.168.200.1', '', '', '', '', '', 'yaml', '');
INSERT INTO `config_info` VALUES ('12', 'service-task-dev.yaml', 'DEFAULT_GROUP', 0x7365727665723A0D0A2020706F72743A20383230370D0A, 'f63f928c5905b317abec7c22b434f9c9', '2021-09-08 05:10:00', '2021-09-08 05:10:00', null, '192.168.200.1', '', '', null, null, null, 'yaml', null);
INSERT INTO `config_info` VALUES ('13', 'service-user-dev.yaml', 'DEFAULT_GROUP', 0x7365727665723A0A2020706F72743A20383230380A0A737072696E673A0A202064617461736F757263653A0A20202020747970653A20636F6D2E7A61787865722E68696B6172692E48696B61726944617461536F757263650A202020206472697665722D636C6173732D6E616D653A20636F6D2E6D7973716C2E6A6462632E4472697665720A2020202075726C3A206A6462633A6D7973716C3A2F2F3139322E3136382E3230302E3132393A333330362F676D616C6C5F757365723F636861726163746572456E636F64696E673D7574662D382675736553534C3D66616C73650A20202020757365726E616D653A20726F6F740A2020202070617373776F72643A20726F6F740A2020202068696B6172693A0A202020202020636F6E6E656374696F6E2D746573742D71756572793A2053454C45435420310A202020202020636F6E6E656374696F6E2D74696D656F75743A2036303030300A20202020202069646C652D74696D656F75743A203530303030300A2020202020206D61782D6C69666574696D653A203534303030300A2020202020206D6178696D756D2D706F6F6C2D73697A653A2031320A2020202020206D696E696D756D2D69646C653A2031300A202020202020706F6F6C2D6E616D653A2047756C6948696B617269506F6F6C0A, '450677a9fa7b26942b1ef6e95496fa81', '2021-09-08 05:10:00', '2021-09-22 06:25:52', null, '192.168.200.1', '', '', '', '', '', 'yaml', '');
INSERT INTO `config_info` VALUES ('14', 'web-all-dev.yaml', 'DEFAULT_GROUP', 0x7365727665723A0D0A2020706F72743A20383330300D0A0D0A737072696E673A0D0A20207468796D656C6561663A0D0A202020206D6F64653A204C454741435948544D4C350D0A2020202023E7BC96E7A08120E58FAFE4B88DE794A8E9858DE7BDAE0D0A20202020656E636F64696E673A205554462D380D0A2020202023E5BC80E58F91E9858DE7BDAEE4B8BA66616C73652CE981BFE5858DE4BFAEE694B9E6A8A1E69DBFE8BF98E8A681E9878DE590AFE69C8DE58AA1E599A80D0A2020202063616368653A2066616C73650D0A2020202023E9858DE7BDAEE6A8A1E69DBFE8B7AFE5BE84EFBC8CE9BB98E8AEA4E698AF74656D706C61746573EFBC8CE58FAFE4BBA5E4B88DE794A8E9858DE7BDAE0D0A202020207072656669783A20636C617373706174683A2F74656D706C617465732F0D0A, '63683bfbfac5775737692b3850b78962', '2021-09-08 05:10:00', '2021-09-08 05:10:00', null, '192.168.200.1', '', '', null, null, null, 'yaml', null);
INSERT INTO `config_info` VALUES ('15', 'service-comment-dev.yaml', 'DEFAULT_GROUP', 0x7365727665723A0A2020706F72743A20383231310A737072696E673A0A20206D61696E3A0A20202020616C6C6F772D6265616E2D646566696E6974696F6E2D6F766572726964696E673A20747275652023E5BD93E98187E588B0E5908CE6A0B7E5908DE5AD97E79A84E697B6E58099EFBC8CE698AFE590A6E58581E8AEB8E8A686E79B96E6B3A8E5868C0A2020646174613A0A202020206D6F6E676F64623A0A202020202020686F73743A203139322E3136382E3230302E3132390A202020202020706F72743A2032373031370A20202020202064617461626173653A20676D616C6C2023E68C87E5AE9AE6938DE4BD9CE79A84E695B0E68DAEE5BA930A2020232072656469733A0A202023202020686F73743A203139322E3136382E3230302E3132390A202023202020706F72743A20363337390A20202320202064617461626173653A20300A20202320202074696D656F75743A20313830303030300A20202320202070617373776F72643A0A2020232020206C6574747563653A0A2020232020202020706F6F6C3A0A202023202020202020206D61782D6163746976653A2032302023E69C80E5A4A7E8BF9EE68EA5E695B00A202023202020202020206D61782D776169743A202D312020202023E69C80E5A4A7E998BBE5A19EE7AD89E5BE85E697B6E997B428E8B49FE695B0E8A1A8E7A4BAE6B2A1E99990E588B6290A202023202020202020206D61782D69646C653A20352020202023E69C80E5A4A7E7A9BAE997B20A202023202020202020206D696E2D69646C653A2030202020202023E69C80E5B08FE7A9BAE997B20A202023206A61636B736F6E3A0A202023202020646174652D666F726D61743A20797979792D4D4D2D64642048483A6D6D3A73730A20202320202074696D652D7A6F6E653A20474D542B38, 'c55a785cc7a29a631e0af94ae417c1e8', '2021-09-08 05:10:00', '2021-10-08 09:13:52', null, '192.168.200.1', '', '', '', '', '', 'yaml', '');
INSERT INTO `config_info` VALUES ('16', 'service-mq-dev.yaml', 'DEFAULT_GROUP', 0x7365727665723A0D0A2020706F72743A2038323832, '8e27892125791fb1cf2acc89acaac3a7', '2021-09-27 03:01:44', '2021-09-27 03:01:44', null, '192.168.200.1', '', '', null, null, null, 'yaml', null);-- ----------------------------
-- Table structure for `config_info_aggr`
-- ----------------------------
DROP TABLE IF EXISTS `config_info_aggr`;
CREATE TABLE `config_info_aggr` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',`data_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'data_id',`group_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'group_id',`datum_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'datum_id',`content` longtext COLLATE utf8_bin NOT NULL COMMENT '内容',`gmt_modified` datetime NOT NULL COMMENT '修改时间',`app_name` varchar(128) COLLATE utf8_bin DEFAULT NULL,`tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT '租户字段',PRIMARY KEY (`id`),UNIQUE KEY `uk_configinfoaggr_datagrouptenantdatum` (`data_id`,`group_id`,`tenant_id`,`datum_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='增加租户字段';-- ----------------------------
-- Records of config_info_aggr
-- ------------------------------ ----------------------------
-- Table structure for `config_info_beta`
-- ----------------------------
DROP TABLE IF EXISTS `config_info_beta`;
CREATE TABLE `config_info_beta` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',`data_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'data_id',`group_id` varchar(128) COLLATE utf8_bin NOT NULL COMMENT 'group_id',`app_name` varchar(128) COLLATE utf8_bin DEFAULT NULL COMMENT 'app_name',`content` longtext COLLATE utf8_bin NOT NULL COMMENT 'content',`beta_ips` varchar(1024) COLLATE utf8_bin DEFAULT NULL COMMENT 'betaIps',`md5` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT 'md5',`gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '创建时间',`gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '修改时间',`src_user` text COLLATE utf8_bin COMMENT 'source user',`src_ip` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT 'source ip',`tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT '租户字段',PRIMARY KEY (`id`),UNIQUE KEY `uk_configinfobeta_datagrouptenant` (`data_id`,`group_id`,`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info_beta';-- ----------------------------
-- Records of config_info_beta
-- ------------------------------ ----------------------------
-- Table structure for `config_info_tag`
-- ----------------------------
DROP TABLE IF EXISTS `config_info_tag`;
CREATE TABLE `config_info_tag` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',`data_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'data_id',`group_id` varchar(128) COLLATE utf8_bin NOT NULL COMMENT 'group_id',`tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT 'tenant_id',`tag_id` varchar(128) COLLATE utf8_bin NOT NULL COMMENT 'tag_id',`app_name` varchar(128) COLLATE utf8_bin DEFAULT NULL COMMENT 'app_name',`content` longtext COLLATE utf8_bin NOT NULL COMMENT 'content',`md5` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT 'md5',`gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '创建时间',`gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '修改时间',`src_user` text COLLATE utf8_bin COMMENT 'source user',`src_ip` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT 'source ip',PRIMARY KEY (`id`),UNIQUE KEY `uk_configinfotag_datagrouptenanttag` (`data_id`,`group_id`,`tenant_id`,`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info_tag';-- ----------------------------
-- Records of config_info_tag
-- ------------------------------ ----------------------------
-- Table structure for `config_tags_relation`
-- ----------------------------
DROP TABLE IF EXISTS `config_tags_relation`;
CREATE TABLE `config_tags_relation` (`id` bigint(20) NOT NULL COMMENT 'id',`tag_name` varchar(128) COLLATE utf8_bin NOT NULL COMMENT 'tag_name',`tag_type` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT 'tag_type',`data_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'data_id',`group_id` varchar(128) COLLATE utf8_bin NOT NULL COMMENT 'group_id',`tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT 'tenant_id',`nid` bigint(20) NOT NULL AUTO_INCREMENT,PRIMARY KEY (`nid`),UNIQUE KEY `uk_configtagrelation_configidtag` (`id`,`tag_name`,`tag_type`),KEY `idx_tenant_id` (`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_tag_relation';-- ----------------------------
-- Records of config_tags_relation
-- ------------------------------ ----------------------------
-- Table structure for `group_capacity`
-- ----------------------------
DROP TABLE IF EXISTS `group_capacity`;
CREATE TABLE `group_capacity` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',`group_id` varchar(128) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'Group ID,空字符表示整个集群',`quota` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '配额,0表示使用默认值',`usage` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '使用量',`max_size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '单个配置大小上限,单位为字节,0表示使用默认值',`max_aggr_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '聚合子配置最大个数,,0表示使用默认值',`max_aggr_size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '单个聚合数据的子配置大小上限,单位为字节,0表示使用默认值',`max_history_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最大变更历史数量',`gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '创建时间',`gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '修改时间',PRIMARY KEY (`id`),UNIQUE KEY `uk_group_id` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='集群、各Group容量信息表';-- ----------------------------
-- Records of group_capacity
-- ------------------------------ ----------------------------
-- Table structure for `his_config_info`
-- ----------------------------
DROP TABLE IF EXISTS `his_config_info`;
CREATE TABLE `his_config_info` (`id` bigint(64) unsigned NOT NULL,`nid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,`data_id` varchar(255) COLLATE utf8_bin NOT NULL,`group_id` varchar(128) COLLATE utf8_bin NOT NULL,`app_name` varchar(128) COLLATE utf8_bin DEFAULT NULL COMMENT 'app_name',`content` longtext COLLATE utf8_bin NOT NULL,`md5` varchar(32) COLLATE utf8_bin DEFAULT NULL,`gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00',`gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00',`src_user` text COLLATE utf8_bin,`src_ip` varchar(20) COLLATE utf8_bin DEFAULT NULL,`op_type` char(10) COLLATE utf8_bin DEFAULT NULL,`tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT '租户字段',PRIMARY KEY (`nid`),KEY `idx_gmt_create` (`gmt_create`),KEY `idx_gmt_modified` (`gmt_modified`),KEY `idx_did` (`data_id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='多租户改造';-- ----------------------------
-- Records of his_config_info
-- ----------------------------
INSERT INTO `his_config_info` VALUES ('11', '21', 'service-product-dev.yaml', 'DEFAULT_GROUP', '', 0x7365727665723A0A2020706F72743A20383230360A737072696E673A0A202064617461736F757263653A0A20202020747970653A20636F6D2E7A61787865722E68696B6172692E48696B61726944617461536F757263650A202020206472697665722D636C6173732D6E616D653A20636F6D2E6D7973716C2E6A6462632E4472697665720A2020202075726C3A206A6462633A6D7973716C3A2F2F3139322E3136382E3230302E3132393A333330362F676D616C6C5F70726F647563743F636861726163746572456E636F64696E673D7574662D382675736553534C3D66616C73650A20202020757365726E616D653A20726F6F740A2020202070617373776F72643A20726F6F740A2020202068696B6172693A0A202020202020636F6E6E656374696F6E2D746573742D71756572793A2053454C4543542031202320E887AAE58AA8E6A380E6B58BE8BF9EE68EA50A202020202020636F6E6E656374696F6E2D74696D656F75743A2036303030302023E695B0E68DAEE5BA93E8BF9EE68EA5E8B685E697B6E697B6E997B42CE9BB98E8AEA43330E7A7920A20202020202069646C652D74696D656F75743A203530303030302023E7A9BAE997B2E8BF9EE68EA5E5AD98E6B4BBE69C80E5A4A7E697B6E997B4EFBC8CE9BB98E8AEA4363030303030EFBC883130E58886E9929FEFBC890A2020202020206D61782D6C69666574696D653A203534303030302023E6ADA4E5B19EE680A7E68EA7E588B6E6B1A0E4B8ADE8BF9EE68EA5E79A84E69C80E995BFE7949FE591BDE591A8E69C9FEFBC8CE580BC30E8A1A8E7A4BAE697A0E99990E7949FE591BDE591A8E69C9FEFBC8CE9BB98E8AEA431383030303030E58DB33330E58886E9929F0A2020202020206D6178696D756D2D706F6F6C2D73697A653A2031322023E8BF9EE68EA5E6B1A0E69C80E5A4A7E8BF9EE68EA5E695B0EFBC8CE9BB98E8AEA4E698AF31300A2020202020206D696E696D756D2D69646C653A2031302023E69C80E5B08FE7A9BAE997B2E8BF9EE68EA5E695B0E9878F0A202020202020706F6F6C2D6E616D653A2053504848696B617269506F6F6C202320E8BF9EE68EA5E6B1A0E5908DE7A7B00A6D696E696F3A0A2020656E64706F696E7455726C3A20687474703A2F2F34372E39332E3134382E3139323A393030300A20206163636573734B65793A2061646D696E0A202073656372654B65793A2061646D696E3132333435360A20206275636B65744E616D653A20676D616C6C0A, 'e4df11fb359466da8db8876f215c2ba2', '2010-05-05 00:00:00', '2021-09-10 05:58:26', null, '192.168.200.1', 'U', '');
INSERT INTO `his_config_info` VALUES ('11', '22', 'service-product-dev.yaml', 'DEFAULT_GROUP', '', 0x7365727665723A0A2020706F72743A20383230360A737072696E673A0A202064617461736F757263653A0A20202020747970653A20636F6D2E7A61787865722E68696B6172692E48696B61726944617461536F757263650A202020206472697665722D636C6173732D6E616D653A20636F6D2E6D7973716C2E6A6462632E4472697665720A2020202075726C3A206A6462633A6D7973716C3A2F2F3139322E3136382E3230302E3132393A333330362F676D616C6C5F70726F647563743F636861726163746572456E636F64696E673D7574662D382675736553534C3D66616C73650A20202020757365726E616D653A20726F6F740A2020202070617373776F72643A20726F6F740A2020202068696B6172693A0A202020202020636F6E6E656374696F6E2D746573742D71756572793A2053454C4543542031202320E887AAE58AA8E6A380E6B58BE8BF9EE68EA50A202020202020636F6E6E656374696F6E2D74696D656F75743A2036303030302023E695B0E68DAEE5BA93E8BF9EE68EA5E8B685E697B6E697B6E997B42CE9BB98E8AEA43330E7A7920A20202020202069646C652D74696D656F75743A203530303030302023E7A9BAE997B2E8BF9EE68EA5E5AD98E6B4BBE69C80E5A4A7E697B6E997B4EFBC8CE9BB98E8AEA4363030303030EFBC883130E58886E9929FEFBC890A2020202020206D61782D6C69666574696D653A203534303030302023E6ADA4E5B19EE680A7E68EA7E588B6E6B1A0E4B8ADE8BF9EE68EA5E79A84E69C80E995BFE7949FE591BDE591A8E69C9FEFBC8CE580BC30E8A1A8E7A4BAE697A0E99990E7949FE591BDE591A8E69C9FEFBC8CE9BB98E8AEA431383030303030E58DB33330E58886E9929F0A2020202020206D6178696D756D2D706F6F6C2D73697A653A2031322023E8BF9EE68EA5E6B1A0E69C80E5A4A7E8BF9EE68EA5E695B0EFBC8CE9BB98E8AEA4E698AF31300A2020202020206D696E696D756D2D69646C653A2031302023E69C80E5B08FE7A9BAE997B2E8BF9EE68EA5E695B0E9878F0A202020202020706F6F6C2D6E616D653A2053504848696B617269506F6F6C202320E8BF9EE68EA5E6B1A0E5908DE7A7B00A6D696E696F3A0A2020656E64706F696E7455726C3A20687474703A2F2F3139322E3136382E3230302E3132393A393030300A20206163636573734B65793A2061646D696E0A202073656372654B65793A2061646D696E3132333435360A20206275636B65744E616D653A20676D616C6C0A, '9dbc1f488435b5777c765ef7a881211a', '2010-05-05 00:00:00', '2021-09-15 04:05:41', null, '192.168.200.1', 'U', '');
INSERT INTO `his_config_info` VALUES ('3', '23', 'common.yaml', 'DEFAULT_GROUP', '', 0x6D7962617469732D706C75733A0A2020636F6E66696775726174696F6E3A0A202020206C6F672D696D706C3A206F72672E6170616368652E6962617469732E6C6F6767696E672E7374646F75742E5374644F7574496D706C0A20206D61707065722D6C6F636174696F6E733A20636C617373706174683A6D61707065722F2A4D61707065722E786D6C0A666569676E3A0A202073656E74696E656C3A0A20202020656E61626C65643A20747275650A2020636C69656E743A0A20202020636F6E6669673A0A20202020202064656661756C743A0A20202020202020207265616454696D656F75743A20333030300A2020202020202020636F6E6E65637454696D656F75743A20313030300A737072696E673A0A20207A69706B696E3A0A20202020626173652D75726C3A20687474703A2F2F3139322E3136382E3230302E3132393A393431310A20202020646973636F766572792D636C69656E742D656E61626C65643A2066616C73650A2020202073656E6465723A0A202020202020747970653A207765620A2020636C6F75643A0A2020202073656E74696E656C3A0A2020202020207472616E73706F72743A0A202020202020202064617368626F6172643A20687474703A2F2F3139322E3136382E3230302E3132393A383038300A20207261626269746D713A0A20202020686F73743A203139322E3136382E3230302E3132390A20202020706F72743A20353637320A20202020757365726E616D653A2067756573740A2020202070617373776F72643A2067756573740A202020207075626C69736865722D636F6E6669726D2D747970653A20636F7272656C617465640A202020207075626C69736865722D72657475726E733A20747275650A202020206C697374656E65723A0A20202020202073696D706C653A0A202020202020202061636B6E6F776C656467652D6D6F64653A206D616E75616C2023E9BB98E8AEA4E68385E586B5E4B88BE6B688E681AFE6B688E8B4B9E88085E698AFE887AAE58AA8E7A1AEE8AEA4E6B688E681AFE79A84EFBC8CE5A682E69E9CE8A681E6898BE58AA8E7A1AEE8AEA4E6B688E681AFE58899E99C80E8A681E4BFAEE694B9E7A1AEE8AEA4E6A8A1E5BC8FE4B8BA6D616E75616C0A202020202020202070726566657463683A2031202320E6B688E8B4B9E88085E6AF8FE6ACA1E4BB8EE9989FE58897E88EB7E58F96E79A84E6B688E681AFE695B0E9878FE38082E6ADA4E5B19EE680A7E5BD93E4B88DE8AEBEE7BDAEE697B6E4B8BAEFBC9AE8BDAEE8AFA2E58886E58F91EFBC8CE8AEBEE7BDAEE4B8BA31E4B8BAEFBC9AE585ACE5B9B3E58886E58F910A202072656469733A0A20202020686F73743A203139322E3136382E3230302E3132390A20202020706F72743A20363337390A2020202064617461626173653A20300A2020202074696D656F75743A20313830303030300A2020202070617373776F72643A0A202020206C6574747563653A0A202020202020706F6F6C3A0A20202020202020206D61782D6163746976653A2032302023E69C80E5A4A7E8BF9EE68EA5E695B00A20202020202020206D61782D776169743A202D312020202023E69C80E5A4A7E998BBE5A19EE7AD89E5BE85E697B6E997B428E8B49FE695B0E8A1A8E7A4BAE6B2A1E99990E588B6290A20202020202020206D61782D69646C653A20352020202023E69C80E5A4A7E7A9BAE997B20A20202020202020206D696E2D69646C653A2030202020202023E69C80E5B08FE7A9BAE997B20A20206A61636B736F6E3A0A20202020646174652D666F726D61743A20797979792D4D4D2D64642048483A6D6D3A73730A2020202074696D652D7A6F6E653A20474D542B38, '31b8835d9d70294dec9c8f32c27a11ef', '2010-05-05 00:00:00', '2021-09-16 04:57:48', null, '192.168.200.1', 'U', '');
INSERT INTO `his_config_info` VALUES ('3', '24', 'common.yaml', 'DEFAULT_GROUP', '', 0x6D7962617469732D706C75733A0A2020636F6E66696775726174696F6E3A0A202020206C6F672D696D706C3A206F72672E6170616368652E6962617469732E6C6F6767696E672E7374646F75742E5374644F7574496D706C0A20206D61707065722D6C6F636174696F6E733A20636C617373706174683A6D61707065722F2A4D61707065722E786D6C0A666569676E3A0A202073656E74696E656C3A0A20202020656E61626C65643A20747275650A2020636C69656E743A0A20202020636F6E6669673A0A20202020202064656661756C743A0A20202020202020207265616454696D656F75743A20333030300A2020202020202020636F6E6E65637454696D656F75743A20313030300A737072696E673A0A20207A69706B696E3A0A20202020626173652D75726C3A20687474703A2F2F3139322E3136382E3230302E3132393A393431310A20202020646973636F766572792D636C69656E742D656E61626C65643A2066616C73650A2020202073656E6465723A0A202020202020747970653A207765620A2020636C6F75643A0A2020202073656E74696E656C3A0A2020202020207472616E73706F72743A0A202020202020202064617368626F6172643A20687474703A2F2F3139322E3136382E3230302E3132393A383835380A20207261626269746D713A0A20202020686F73743A203139322E3136382E3230302E3132390A20202020706F72743A20353637320A20202020757365726E616D653A2067756573740A2020202070617373776F72643A2067756573740A202020207075626C69736865722D636F6E6669726D2D747970653A20636F7272656C617465640A202020207075626C69736865722D72657475726E733A20747275650A202020206C697374656E65723A0A20202020202073696D706C653A0A202020202020202061636B6E6F776C656467652D6D6F64653A206D616E75616C2023E9BB98E8AEA4E68385E586B5E4B88BE6B688E681AFE6B688E8B4B9E88085E698AFE887AAE58AA8E7A1AEE8AEA4E6B688E681AFE79A84EFBC8CE5A682E69E9CE8A681E6898BE58AA8E7A1AEE8AEA4E6B688E681AFE58899E99C80E8A681E4BFAEE694B9E7A1AEE8AEA4E6A8A1E5BC8FE4B8BA6D616E75616C0A202020202020202070726566657463683A2031202320E6B688E8B4B9E88085E6AF8FE6ACA1E4BB8EE9989FE58897E88EB7E58F96E79A84E6B688E681AFE695B0E9878FE38082E6ADA4E5B19EE680A7E5BD93E4B88DE8AEBEE7BDAEE697B6E4B8BAEFBC9AE8BDAEE8AFA2E58886E58F91EFBC8CE8AEBEE7BDAEE4B8BA31E4B8BAEFBC9AE585ACE5B9B3E58886E58F910A202072656469733A0A20202020686F73743A203139322E3136382E3230302E3132390A20202020706F72743A20363337390A2020202064617461626173653A20300A2020202074696D656F75743A20313830303030300A2020202070617373776F72643A0A202020206C6574747563653A0A202020202020706F6F6C3A0A20202020202020206D61782D6163746976653A2032302023E69C80E5A4A7E8BF9EE68EA5E695B00A20202020202020206D61782D776169743A202D312020202023E69C80E5A4A7E998BBE5A19EE7AD89E5BE85E697B6E997B428E8B49FE695B0E8A1A8E7A4BAE6B2A1E99990E588B6290A20202020202020206D61782D69646C653A20352020202023E69C80E5A4A7E7A9BAE997B20A20202020202020206D696E2D69646C653A2030202020202023E69C80E5B08FE7A9BAE997B20A20206A61636B736F6E3A0A20202020646174652D666F726D61743A20797979792D4D4D2D64642048483A6D6D3A73730A2020202074696D652D7A6F6E653A20474D542B38, '5a35a0cacbd21e1e418941a401088498', '2010-05-05 00:00:00', '2021-09-16 05:02:54', null, '192.168.200.1', 'U', '');
INSERT INTO `his_config_info` VALUES ('8', '25', 'service-list-dev.yaml', 'DEFAULT_GROUP', '', 0x7365727665723A0D0A2020706F72743A20383230330D0A0D0A737072696E673A0D0A2020656C61737469637365617263683A0D0A20202020726573743A0D0A202020202020757269733A20687474703A2F2F3132372E302E302E313A39323030, '7aff8d069ba6063b0ab02a2430c4af5d', '2010-05-05 00:00:00', '2021-09-17 05:54:44', null, '192.168.200.1', 'U', '');
INSERT INTO `his_config_info` VALUES ('13', '26', 'service-user-dev.yaml', 'DEFAULT_GROUP', '', 0x7365727665723A0A2020706F72743A20383230380A0A737072696E673A0A202064617461736F757263653A0A20202020747970653A20636F6D2E7A61787865722E68696B6172692E48696B61726944617461536F757263650A202020206472697665722D636C6173732D6E616D653A20636F6D2E6D7973716C2E6A6462632E4472697665720A2020202075726C3A206A6462633A6D7973716C3A2F2F6C6F63616C686F73743A333330362F676D616C6C5F757365723F636861726163746572456E636F64696E673D7574662D382675736553534C3D66616C73650A20202020757365726E616D653A20726F6F740A2020202070617373776F72643A20726F6F740A2020202068696B6172693A0A202020202020636F6E6E656374696F6E2D746573742D71756572793A2053454C45435420310A202020202020636F6E6E656374696F6E2D74696D656F75743A2036303030300A20202020202069646C652D74696D656F75743A203530303030300A2020202020206D61782D6C69666574696D653A203534303030300A2020202020206D6178696D756D2D706F6F6C2D73697A653A2031320A2020202020206D696E696D756D2D69646C653A2031300A202020202020706F6F6C2D6E616D653A2047756C6948696B617269506F6F6C0A, 'f231ebcfaa638ca767a598e9889fe2e9', '2010-05-05 00:00:00', '2021-09-22 06:25:52', null, '192.168.200.1', 'U', '');
INSERT INTO `his_config_info` VALUES ('4', '27', 'server-gateway-dev.yaml', 'DEFAULT_GROUP', '', 0x7365727665723A0A2020706F72743A2038300A737072696E673A0A202072656469733A0A20202020686F73743A203139322E3136382E3230302E3132390A20202020706F72743A20363337390A2020202064617461626173653A20300A2020202074696D656F75743A20313830303030300A2020202070617373776F72643A0A2020636C6F75643A0A20202020676174657761793A0A202020202020646973636F766572793A20202020202023E698AFE590A6E4B88EE69C8DE58AA1E58F91E78EB0E7BB84E4BBB6E8BF9BE8A18CE7BB93E59088EFBC8CE9809AE8BF872073657276696365496428E5BF85E9A1BBE8AEBEE7BDAEE68890E5A4A7E586992920E8BDACE58F91E588B0E585B7E4BD93E79A84E69C8DE58AA1E5AE9EE4BE8BE38082E9BB98E8AEA4E4B8BA66616C7365EFBC8CE8AEBEE4B8BA74727565E4BEBFE5BC80E590AFE9809AE8BF87E69C8DE58AA1E4B8ADE5BF83E79A84E887AAE58AA8E6A0B9E68DAE2073657276696365496420E5889BE5BBBAE8B7AFE794B1E79A84E58A9FE883BDE380820A20202020202020206C6F6361746F723A20202020202023E8B7AFE794B1E8AEBFE997AEE696B9E5BC8FEFBC9A687474703A2F2F476174657761795F484F53543A476174657761795F504F52542FE5A4A7E58699E79A847365727669636549642F2A2AEFBC8CE585B6E4B8ADE5BEAEE69C8DE58AA1E5BA94E794A8E5908DE9BB98E8AEA4E5A4A7E58699E8AEBFE997AEE380820A20202020202020202020656E61626C65643A20747275650A202020202020726F757465733A0A20202020202020202D2069643A20736572766963652D70726F647563740A202020202020202020207572693A206C623A2F2F736572766963652D70726F647563740A20202020202020202020707265646963617465733A0A2020202020202020202020202D20506174683D2F2A2F70726F647563742F2A2A202320E8B7AFE5BE84E58CB9E9858D0A20202020202020202D2069643A20736572766963652D6974656D0A202020202020202020207572693A206C623A2F2F736572766963652D6974656D0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20506174683D2F2A2F6974656D2F2A2A0A20202020202020202D2069643A20736572766963652D757365720A202020202020202020207572693A206C623A2F2F736572766963652D757365720A20202020202020202020707265646963617465733A0A2020202020202020202020202D20506174683D2F2A2F757365722F2A2A0A20202020202020202D2069643A20736572766963652D636172740A202020202020202020207572693A206C623A2F2F736572766963652D636172740A20202020202020202020707265646963617465733A0A2020202020202020202020202D20506174683D2F2A2F636172742F2A2A0A20202020202020202D2069643A20736572766963652D6F726465720A202020202020202020207572693A206C623A2F2F736572766963652D6F726465720A20202020202020202020707265646963617465733A0A2020202020202020202020202D20506174683D2F2A2F6F726465722F2A2A0A20202020202020202D2069643A20736572766963652D7061796D656E740A202020202020202020207572693A206C623A2F2F736572766963652D7061796D656E740A20202020202020202020707265646963617465733A0A2020202020202020202020202D20506174683D2F2A2F7061796D656E742F2A2A0A20202020202020202D2069643A20736572766963652D61637469766974790A202020202020202020207572693A206C623A2F2F736572766963652D61637469766974790A20202020202020202020707265646963617465733A0A2020202020202020202020202D20506174683D2F2A2F61637469766974792F2A2A202320E8B7AFE5BE84E58CB9E9858D0A20202020202020202D2069643A20736572766963652D636F6D6D656E740A202020202020202020207572693A206C623A2F2F736572766963652D636F6D6D656E740A20202020202020202020707265646963617465733A0A2020202020202020202020202D20506174683D2F2A2F636F6D6D656E742F2A2A0A2020202020202020233D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D776562E5898DE7ABAF3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D0A20202020202020202D2069643A207765622D6974656D0A202020202020202020207572693A206C623A2F2F7765622D616C6C0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20486F73743D6974656D2E676D616C6C2E636F6D0A2020202020202020233D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3DE9A696E9A1B5E5898DE7ABAF3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D0A20202020202020202D2069643A207765622D696E6465780A202020202020202020207572693A206C623A2F2F7765622D616C6C0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20486F73743D7777772E676D616C6C2E636F6D0A20202020202020202D2069643A207765622D6C6973740A202020202020202020207572693A206C623A2F2F7765622D616C6C0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20486F73743D6C6973742E676D616C6C2E636F6D0A20202020202020202D2069643A207765622D70617373706F72740A202020202020202020207572693A206C623A2F2F7765622D616C6C0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20486F73743D70617373706F72742E676D616C6C2E636F6D0A20202020202020202D2069643A207765622D636172740A202020202020202020207572693A206C623A2F2F7765622D616C6C0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20486F73743D636172742E676D616C6C2E636F6D0A20202020202020202D2069643A207765622D6F726465720A202020202020202020207572693A206C623A2F2F7765622D616C6C0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20486F73743D6F726465722E676D616C6C2E636F6D0A20202020202020202D2069643A207765622D7061796D656E740A202020202020202020207572693A206C623A2F2F7765622D616C6C0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20486F73743D7061796D656E742E676D616C6C2E636F6D0A20202020202020202D2069643A207765622D61637469766974790A202020202020202020207572693A206C623A2F2F7765622D616C6C0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20486F73743D61637469766974792E676D616C6C2E636F6D0A20202020202020202D2069643A207765622D636F6D6D656E740A202020202020202020207572693A206C623A2F2F7765622D616C6C0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20486F73743D636F6D6D656E742E676D616C6C2E636F6D0A6175746855726C733A0A202075726C3A2074726164652E68746D6C2C6D794F726465722E68746D6C20232C6C6973742E68746D6C2C20616464436172742E68746D6C202320E794A8E688B7E8AEBFE997AEE8AFA5E68EA7E588B6E599A8E79A84E697B6E58099EFBC8CE4BC9AE8A2ABE68BA6E688AAE8B7B3E8BDACE588B0E799BBE5BD95EFBC810A, '0c663b4bbd896b245c398ad257450790', '2010-05-05 00:00:00', '2021-09-23 02:47:21', null, '192.168.200.1', 'U', '');
INSERT INTO `his_config_info` VALUES ('3', '28', 'common.yaml', 'DEFAULT_GROUP', '', 0x6D7962617469732D706C75733A0A2020636F6E66696775726174696F6E3A0A202020206C6F672D696D706C3A206F72672E6170616368652E6962617469732E6C6F6767696E672E7374646F75742E5374644F7574496D706C0A20206D61707065722D6C6F636174696F6E733A20636C617373706174683A6D61707065722F2A4D61707065722E786D6C0A666569676E3A0A202073656E74696E656C3A0A20202020656E61626C65643A20747275650A2020636C69656E743A0A20202020636F6E6669673A0A20202020202064656661756C743A0A20202020202020207265616454696D656F75743A20333030300A2020202020202020636F6E6E65637454696D656F75743A20313030300A737072696E673A0A20207A69706B696E3A0A20202020626173652D75726C3A20687474703A2F2F3139322E3136382E3230302E3132393A393431310A20202020646973636F766572792D636C69656E742D656E61626C65643A2066616C73650A2020202073656E6465723A0A202020202020747970653A207765620A20202320636C6F75643A0A20202320202073656E74696E656C3A0A20202320202020207472616E73706F72743A0A2020232020202020202064617368626F6172643A20687474703A2F2F3139322E3136382E3230302E3132393A383835380A20207261626269746D713A0A20202020686F73743A203139322E3136382E3230302E3132390A20202020706F72743A20353637320A20202020757365726E616D653A2067756573740A2020202070617373776F72643A2067756573740A202020207075626C69736865722D636F6E6669726D2D747970653A20636F7272656C617465640A202020207075626C69736865722D72657475726E733A20747275650A202020206C697374656E65723A0A20202020202073696D706C653A0A202020202020202061636B6E6F776C656467652D6D6F64653A206D616E75616C2023E9BB98E8AEA4E68385E586B5E4B88BE6B688E681AFE6B688E8B4B9E88085E698AFE887AAE58AA8E7A1AEE8AEA4E6B688E681AFE79A84EFBC8CE5A682E69E9CE8A681E6898BE58AA8E7A1AEE8AEA4E6B688E681AFE58899E99C80E8A681E4BFAEE694B9E7A1AEE8AEA4E6A8A1E5BC8FE4B8BA6D616E75616C0A202020202020202070726566657463683A2031202320E6B688E8B4B9E88085E6AF8FE6ACA1E4BB8EE9989FE58897E88EB7E58F96E79A84E6B688E681AFE695B0E9878FE38082E6ADA4E5B19EE680A7E5BD93E4B88DE8AEBEE7BDAEE697B6E4B8BAEFBC9AE8BDAEE8AFA2E58886E58F91EFBC8CE8AEBEE7BDAEE4B8BA31E4B8BAEFBC9AE585ACE5B9B3E58886E58F910A202072656469733A0A20202020686F73743A203139322E3136382E3230302E3132390A20202020706F72743A20363337390A2020202064617461626173653A20300A2020202074696D656F75743A20313830303030300A2020202070617373776F72643A0A202020206C6574747563653A0A202020202020706F6F6C3A0A20202020202020206D61782D6163746976653A2032302023E69C80E5A4A7E8BF9EE68EA5E695B00A20202020202020206D61782D776169743A202D312020202023E69C80E5A4A7E998BBE5A19EE7AD89E5BE85E697B6E997B428E8B49FE695B0E8A1A8E7A4BAE6B2A1E99990E588B6290A20202020202020206D61782D69646C653A20352020202023E69C80E5A4A7E7A9BAE997B20A20202020202020206D696E2D69646C653A2030202020202023E69C80E5B08FE7A9BAE997B20A20206A61636B736F6E3A0A20202020646174652D666F726D61743A20797979792D4D4D2D64642048483A6D6D3A73730A2020202074696D652D7A6F6E653A20474D542B38, 'd1dfd87e6427393c58bc991a1207d79c', '2010-05-05 00:00:00', '2021-09-24 07:00:15', null, '192.168.200.1', 'U', '');
INSERT INTO `his_config_info` VALUES ('4', '29', 'server-gateway-dev.yaml', 'DEFAULT_GROUP', '', 0x7365727665723A0A2020706F72743A2038300A737072696E673A0A202072656469733A0A20202020686F73743A203139322E3136382E3230302E3132390A20202020706F72743A20363337390A2020202064617461626173653A20300A2020202074696D656F75743A20313830303030300A2020202070617373776F72643A0A2020636C6F75643A0A20202020676174657761793A0A202020202020646973636F766572793A20202020202023E698AFE590A6E4B88EE69C8DE58AA1E58F91E78EB0E7BB84E4BBB6E8BF9BE8A18CE7BB93E59088EFBC8CE9809AE8BF872073657276696365496428E5BF85E9A1BBE8AEBEE7BDAEE68890E5A4A7E586992920E8BDACE58F91E588B0E585B7E4BD93E79A84E69C8DE58AA1E5AE9EE4BE8BE38082E9BB98E8AEA4E4B8BA66616C7365EFBC8CE8AEBEE4B8BA74727565E4BEBFE5BC80E590AFE9809AE8BF87E69C8DE58AA1E4B8ADE5BF83E79A84E887AAE58AA8E6A0B9E68DAE2073657276696365496420E5889BE5BBBAE8B7AFE794B1E79A84E58A9FE883BDE380820A20202020202020206C6F6361746F723A20202020202023E8B7AFE794B1E8AEBFE997AEE696B9E5BC8FEFBC9A687474703A2F2F476174657761795F484F53543A476174657761795F504F52542FE5A4A7E58699E79A847365727669636549642F2A2AEFBC8CE585B6E4B8ADE5BEAEE69C8DE58AA1E5BA94E794A8E5908DE9BB98E8AEA4E5A4A7E58699E8AEBFE997AEE380820A20202020202020202020656E61626C65643A20747275650A202020202020726F757465733A0A20202020202020202D2069643A20736572766963652D70726F647563740A202020202020202020207572693A206C623A2F2F736572766963652D70726F647563740A20202020202020202020707265646963617465733A0A2020202020202020202020202D20506174683D2F2A2F70726F647563742F2A2A202320E8B7AFE5BE84E58CB9E9858D0A20202020202020202D2069643A20736572766963652D6974656D0A202020202020202020207572693A206C623A2F2F736572766963652D6974656D0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20506174683D2F2A2F6974656D2F2A2A0A20202020202020202D2069643A20736572766963652D757365720A202020202020202020207572693A206C623A2F2F736572766963652D757365720A20202020202020202020707265646963617465733A0A2020202020202020202020202D20506174683D2F2A2F757365722F2A2A0A20202020202020202D2069643A20736572766963652D636172740A202020202020202020207572693A206C623A2F2F736572766963652D636172740A20202020202020202020707265646963617465733A0A2020202020202020202020202D20506174683D2F2A2F636172742F2A2A0A20202020202020202D2069643A20736572766963652D6F726465720A202020202020202020207572693A206C623A2F2F736572766963652D6F726465720A20202020202020202020707265646963617465733A0A2020202020202020202020202D20506174683D2F2A2F6F726465722F2A2A0A20202020202020202D2069643A20736572766963652D7061796D656E740A202020202020202020207572693A206C623A2F2F736572766963652D7061796D656E740A20202020202020202020707265646963617465733A0A2020202020202020202020202D20506174683D2F2A2F7061796D656E742F2A2A0A20202020202020202D2069643A20736572766963652D61637469766974790A202020202020202020207572693A206C623A2F2F736572766963652D61637469766974790A20202020202020202020707265646963617465733A0A2020202020202020202020202D20506174683D2F2A2F61637469766974792F2A2A202320E8B7AFE5BE84E58CB9E9858D0A20202020202020202D2069643A20736572766963652D636F6D6D656E740A202020202020202020207572693A206C623A2F2F736572766963652D636F6D6D656E740A20202020202020202020707265646963617465733A0A2020202020202020202020202D20506174683D2F2A2F636F6D6D656E742F2A2A0A2020202020202020233D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D776562E5898DE7ABAF3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D0A20202020202020202D2069643A207765622D6974656D0A202020202020202020207572693A206C623A2F2F7765622D616C6C0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20486F73743D6974656D2E676D616C6C2E636F6D0A2020202020202020233D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3DE9A696E9A1B5E5898DE7ABAF3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D3D0A20202020202020202D2069643A207765622D696E6465780A202020202020202020207572693A206C623A2F2F7765622D616C6C0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20486F73743D7777772E676D616C6C2E636F6D0A20202020202020202D2069643A207765622D6C6973740A202020202020202020207572693A206C623A2F2F7765622D616C6C0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20486F73743D6C6973742E676D616C6C2E636F6D0A20202020202020202D2069643A207765622D70617373706F72740A202020202020202020207572693A206C623A2F2F7765622D616C6C0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20486F73743D70617373706F72742E676D616C6C2E636F6D0A20202020202020202D2069643A207765622D636172740A202020202020202020207572693A206C623A2F2F7765622D616C6C0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20486F73743D636172742E676D616C6C2E636F6D0A20202020202020202D2069643A207765622D6F726465720A202020202020202020207572693A206C623A2F2F7765622D616C6C0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20486F73743D6F726465722E676D616C6C2E636F6D0A20202020202020202D2069643A207765622D7061796D656E740A202020202020202020207572693A206C623A2F2F7765622D616C6C0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20486F73743D7061796D656E742E676D616C6C2E636F6D0A20202020202020202D2069643A207765622D61637469766974790A202020202020202020207572693A206C623A2F2F7765622D616C6C0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20486F73743D61637469766974792E676D616C6C2E636F6D0A20202020202020202D2069643A207765622D636F6D6D656E740A202020202020202020207572693A206C623A2F2F7765622D616C6C0A20202020202020202020707265646963617465733A0A2020202020202020202020202D20486F73743D636F6D6D656E742E676D616C6C2E636F6D0A6175746855726C733A0A202075726C3A2074726164652E68746D6C2C6D794F726465722E68746D6C2C6C6973742E68746D6C2C23616464436172742E68746D6C202320E794A8E688B7E8AEBFE997AEE8AFA5E68EA7E588B6E599A8E79A84E697B6E58099EFBC8CE4BC9AE8A2ABE68BA6E688AAE8B7B3E8BDACE588B0E799BBE5BD95EFBC810A, '8b915dd5ec90e0df54d96097263ba379', '2010-05-05 00:00:00', '2021-09-25 00:56:54', null, '192.168.200.1', 'U', '');
INSERT INTO `his_config_info` VALUES ('9', '30', 'service-order-dev.yaml', 'DEFAULT_GROUP', '', 0x7365727665723A0A2020706F72743A20383230340A737072696E673A0A202064617461736F757263653A0A20202020747970653A20636F6D2E7A61787865722E68696B6172692E48696B61726944617461536F757263650A202020206472697665722D636C6173732D6E616D653A20636F6D2E6D7973716C2E6A6462632E4472697665720A2020202075726C3A206A6462633A6D7973716C3A2F2F6C6F63616C686F73743A333330362F676D616C6C5F6F726465723F636861726163746572456E636F64696E673D7574662D382675736553534C3D66616C73650A20202020757365726E616D653A20726F6F740A2020202070617373776F72643A20726F6F740A2020202068696B6172693A0A202020202020636F6E6E656374696F6E2D746573742D71756572793A2053454C45435420310A202020202020636F6E6E656374696F6E2D74696D656F75743A2036303030300A20202020202069646C652D74696D656F75743A203530303030300A2020202020206D61782D6C69666574696D653A203534303030300A2020202020206D6178696D756D2D706F6F6C2D73697A653A2031320A2020202020206D696E696D756D2D69646C653A2031300A202020202020706F6F6C2D6E616D653A2047756C6948696B617269506F6F6C0A776172653A0A202075726C3A20687474703A2F2F6C6F63616C686F73743A39303031, '013aff083e39ce063c57527e197b86a8', '2010-05-05 00:00:00', '2021-09-25 01:39:45', null, '192.168.200.1', 'U', '');
INSERT INTO `his_config_info` VALUES ('0', '31', 'service-mq-dev.yaml', 'DEFAULT_GROUP', '', 0x7365727665723A0D0A2020706F72743A2038323832, '8e27892125791fb1cf2acc89acaac3a7', '2010-05-05 00:00:00', '2021-09-27 03:01:44', null, '192.168.200.1', 'I', '');
INSERT INTO `his_config_info` VALUES ('10', '32', 'service-payment-dev.yaml', 'DEFAULT_GROUP', '', 0x7365727665723A0A2020706F72743A20383230350A737072696E673A0A202064617461736F757263653A0A20202020747970653A20636F6D2E7A61787865722E68696B6172692E48696B61726944617461536F757263650A202020206472697665722D636C6173732D6E616D653A20636F6D2E6D7973716C2E6A6462632E4472697665720A2020202075726C3A206A6462633A6D7973716C3A2F2F6C6F63616C686F73743A333330362F676D616C6C5F6F726465723F636861726163746572456E636F64696E673D7574662D382675736553534C3D66616C73650A20202020757365726E616D653A20726F6F740A2020202070617373776F72643A20726F6F740A2020202068696B6172693A0A202020202020636F6E6E656374696F6E2D746573742D71756572793A2053454C45435420310A202020202020636F6E6E656374696F6E2D74696D656F75743A2036303030300A20202020202069646C652D74696D656F75743A203530303030300A2020202020206D61782D6C69666574696D653A203534303030300A2020202020206D6178696D756D2D706F6F6C2D73697A653A2031320A2020202020206D696E696D756D2D69646C653A2031300A202020202020706F6F6C2D6E616D653A2047756C6948696B617269506F6F6C0A616C697061795F7075626C69635F6B65793A204D494942496A414E42676B71686B6947397730424151454641414F43415138414D49494243674B43415145416B57732B3367584D6F736957472B45626652796F7457423077617155337437714D51534278553072334A5A6F4E4435336A765751667A72475A38572B6F624D632B4F677775704F4444567868472F44454B5642497074755551596476416A43534839386D3268636C46636B737370754379397853375079666C5045343770567A5336764133536C7677354F4651327155636B75347061576E427867754C5547506A456E63696A354E637946796B2B2F6B35374D6D72564A77435A61492B6C464F533345713249586330377457584F34732F3253577233454A69774A75744F474264413164647676315572726C307057704546673330704A42364A37597465757864454C39306B754F3565642F766E544B35716751527645656C524F6B55573434784F4E6B313738347632384F4A586D4749436D4E4C312B4B794D2F534662464F53674A5A535631744558557A764C2F78767A46704C774944415141420A616C697061795F75726C3A2068747470733A2F2F6F70656E6170692E616C697061792E636F6D2F676174657761792E646F0A6170705F69643A20323032313030313136333631373435320A6170705F707269766174655F6B65793A204D494945765149424144414E42676B71686B6947397730424151454641415343424B63776767536A41674541416F4942415143385A37455A6D616E78794647734B344C724955654B4B727247785741484967506D55563854745A44732B6A65706C4A537731636B535936335168455534343444357164367872754A48427542333348472B696B346E384E386E5257693341744D6770433036316F713244636774494B4D6D51484F372F706F5944776270445A724F57584979694E73684666554F535455706E7253385576456B73366E3678522F4737327232464730376F5A7A4F3767335873504D723733777059616A4D59432F6268546D36434A4745575A696B4F4E4E44466B51705648612B7A6769747773716C4275764276567747774F48413942386152666F6B77414D6C364244584B6F4838424E6E53454D705753545253776273736179584151574E5537584B444B476F7A626E3455326445626C384743467A696B492F54377962544E6D35677334365A5A42476C712F5942342B76344433743734566C366E41674D4241414543676745414F69647A6865686C69596B416C4C6B316875685630624D51786577456B5138527A78544D32534F52495753327137522B46507459506B48675539325146466738356C4E6C74736935645A304D796C4B554658465259496938434C346D3756364531713132664A50656177566B4258487569673859366931545752764355557475766B546A742B2B41572F30514543484F74424D567A49393565592B765A7756546F7138682F2B55634E6D784B795674363651706F342B722B6355766C764758356D5867515643354674662F4D74484131692B6B6A747A42495443307841766D53584B7A6A4E315968746353397258794D485842694668584C646D764F586A6B6E304F6B6F7372322B746D65735866537744476848335A6C4F64487A69743444363032524E6C306E544131644F55574875436E63733154725762726961783836502F4559766D7A4D6948574356546D6D4E4A4330624D514B42675144304841584B4E735973646A43514F56347433534D714F4B61756C3637782F4B413230506D4D5A5666513273516B796A79466757704C38433136527A66337A493764662B7A4635536B76684659342B4C525A567758356F6B454659547A415A2F4E596F756A312F444142594F5071304530735931382F78747137464A2F43496B38716D437163637A716F79616F786F6143317A4174394534435945383969454F6E4F2B476863493348334C774B42675144466C517A7662586857527952466B6566742F613532584C6E796A367439695037774E4762474353656F4D44724175335A676F7161635550576A354D6753465A64543438483972463470506978586F65336A66554E735742554871443146326472447A376C704C30506270537367793665692B443452775441447375795877726B7672577247726F2B6836704E4A46796C79336E65612F676C6F44744A547A6668464677744E666D717943514B426742587A4D783455774D7363735938326156364D5A4F34562B2F373143726B64737A5A616F69586173775048754231717866686E5136796959795238704F36325352356E73313230466E6A3857466831484A7076396379567032305A616B494F31745867694477654F6837566E496A76784243367573546356367938315153363277324563306877494255765651747A63695547765032354E445834696778535977504757485034682F586E416F474163514E32614B546E42674B6650715063553461632B6472454358676745536742476F662B6D527533635435552F4E53394F7A304E71362B724D566D3144704D48416462757152696B71316143716F56577570353171453068696B5779396E644C364743796E765749444F5347724C57515A326B7970356B6D793562574F57414A364C6C36723759394E64496B2B4E4F6B77363134494646614E416A32535455773475507864527677443345436759454172774F5A7852337A6C2F465A667376564358664B382F6668755A584D4F7036487577716B7934744E70564C764F796968704F4A4F6349466A365A4A686F56646D694C3870312F31532B536D2F373567783174704675724B4D4E636D595A626973454337556B783752516F685A685A54714D5067697A6C56425475356E5233786B6865614A43396F6476796A7257514A3536396566586F3330676B57303461427037413135564E47355A2F553D0A6E6F746966795F7061796D656E745F75726C3A20687474703A2F2F6E38736139682E6E6174617070667265652E63632F6170692F7061796D656E742F616C697061792F63616C6C6261636B2F6E6F746966790A72657475726E5F6F726465725F75726C3A20687474703A2F2F7061796D656E742E676D616C6C2E636F6D2F7061792F737563636573732E68746D6C0A72657475726E5F7061796D656E745F75726C3A20687474703A2F2F6170692E676D616C6C2E636F6D2F6170692F7061796D656E742F616C697061792F63616C6C6261636B2F72657475726E0A, 'c4d5d81247596b2c6c19b187423cb0d7', '2010-05-05 00:00:00', '2021-09-28 06:19:03', null, '192.168.200.1', 'U', '');
INSERT INTO `his_config_info` VALUES ('10', '33', 'service-payment-dev.yaml', 'DEFAULT_GROUP', '', 0x7365727665723A0A2020706F72743A20383230350A737072696E673A0A202064617461736F757263653A0A20202020747970653A20636F6D2E7A61787865722E68696B6172692E48696B61726944617461536F757263650A202020206472697665722D636C6173732D6E616D653A20636F6D2E6D7973716C2E6A6462632E4472697665720A2020202075726C3A206A6462633A6D7973716C3A2F2F3139322E3136382E3230302E3132393A333330362F676D616C6C5F6F726465723F636861726163746572456E636F64696E673D7574662D382675736553534C3D66616C73650A20202020757365726E616D653A20726F6F740A2020202070617373776F72643A20726F6F740A2020202068696B6172693A0A202020202020636F6E6E656374696F6E2D746573742D71756572793A2053454C45435420310A202020202020636F6E6E656374696F6E2D74696D656F75743A2036303030300A20202020202069646C652D74696D656F75743A203530303030300A2020202020206D61782D6C69666574696D653A203534303030300A2020202020206D6178696D756D2D706F6F6C2D73697A653A2031320A2020202020206D696E696D756D2D69646C653A2031300A202020202020706F6F6C2D6E616D653A2047756C6948696B617269506F6F6C0A616C697061795F7075626C69635F6B65793A204D494942496A414E42676B71686B6947397730424151454641414F43415138414D49494243674B43415145416B57732B3367584D6F736957472B45626652796F7457423077617155337437714D51534278553072334A5A6F4E4435336A765751667A72475A38572B6F624D632B4F677775704F4444567868472F44454B5642497074755551596476416A43534839386D3268636C46636B737370754379397853375079666C5045343770567A5336764133536C7677354F4651327155636B75347061576E427867754C5547506A456E63696A354E637946796B2B2F6B35374D6D72564A77435A61492B6C464F533345713249586330377457584F34732F3253577233454A69774A75744F474264413164647676315572726C307057704546673330704A42364A37597465757864454C39306B754F3565642F766E544B35716751527645656C524F6B55573434784F4E6B313738347632384F4A586D4749436D4E4C312B4B794D2F534662464F53674A5A535631744558557A764C2F78767A46704C774944415141420A616C697061795F75726C3A2068747470733A2F2F6F70656E6170692E616C697061792E636F6D2F676174657761792E646F0A6170705F69643A20323032313030313136333631373435320A6170705F707269766174655F6B65793A204D494945765149424144414E42676B71686B6947397730424151454641415343424B63776767536A41674541416F4942415143385A37455A6D616E78794647734B344C724955654B4B727247785741484967506D55563854745A44732B6A65706C4A537731636B535936335168455534343444357164367872754A48427542333348472B696B346E384E386E5257693341744D6770433036316F713244636774494B4D6D51484F372F706F5944776270445A724F57584979694E73684666554F535455706E7253385576456B73366E3678522F4737327232464730376F5A7A4F3767335873504D723733777059616A4D59432F6268546D36434A4745575A696B4F4E4E44466B51705648612B7A6769747773716C4275764276567747774F48413942386152666F6B77414D6C364244584B6F4838424E6E53454D705753545253776273736179584151574E5537584B444B476F7A626E3455326445626C384743467A696B492F54377962544E6D35677334365A5A42476C712F5942342B76344433743734566C366E41674D4241414543676745414F69647A6865686C69596B416C4C6B316875685630624D51786577456B5138527A78544D32534F52495753327137522B46507459506B48675539325146466738356C4E6C74736935645A304D796C4B554658465259496938434C346D3756364531713132664A50656177566B4258487569673859366931545752764355557475766B546A742B2B41572F30514543484F74424D567A49393565592B765A7756546F7138682F2B55634E6D784B795674363651706F342B722B6355766C764758356D5867515643354674662F4D74484131692B6B6A747A42495443307841766D53584B7A6A4E315968746353397258794D485842694668584C646D764F586A6B6E304F6B6F7372322B746D65735866537744476848335A6C4F64487A69743444363032524E6C306E544131644F55574875436E63733154725762726961783836502F4559766D7A4D6948574356546D6D4E4A4330624D514B42675144304841584B4E735973646A43514F56347433534D714F4B61756C3637782F4B413230506D4D5A5666513273516B796A79466757704C38433136527A66337A493764662B7A4635536B76684659342B4C525A567758356F6B454659547A415A2F4E596F756A312F444142594F5071304530735931382F78747137464A2F43496B38716D437163637A716F79616F786F6143317A4174394534435945383969454F6E4F2B476863493348334C774B42675144466C517A7662586857527952466B6566742F613532584C6E796A367439695037774E4762474353656F4D44724175335A676F7161635550576A354D6753465A64543438483972463470506978586F65336A66554E735742554871443146326472447A376C704C30506270537367793665692B443452775441447375795877726B7672577247726F2B6836704E4A46796C79336E65612F676C6F44744A547A6668464677744E666D717943514B426742587A4D783455774D7363735938326156364D5A4F34562B2F373143726B64737A5A616F69586173775048754231717866686E5136796959795238704F36325352356E73313230466E6A3857466831484A7076396379567032305A616B494F31745867694477654F6837566E496A76784243367573546356367938315153363277324563306877494255765651747A63695547765032354E445834696778535977504757485034682F586E416F474163514E32614B546E42674B6650715063553461632B6472454358676745536742476F662B6D527533635435552F4E53394F7A304E71362B724D566D3144704D48416462757152696B71316143716F56577570353171453068696B5779396E644C364743796E765749444F5347724C57515A326B7970356B6D793562574F57414A364C6C36723759394E64496B2B4E4F6B77363134494646614E416A32535455773475507864527677443345436759454172774F5A7852337A6C2F465A667376564358664B382F6668755A584D4F7036487577716B7934744E70564C764F796968704F4A4F6349466A365A4A686F56646D694C3870312F31532B536D2F373567783174704675724B4D4E636D595A626973454337556B783752516F685A685A54714D5067697A6C56425475356E5233786B6865614A43396F6476796A7257514A3536396566586F3330676B57303461427037413135564E47355A2F553D0A6E6F746966795F7061796D656E745F75726C3A20687474703A2F2F6E38736139682E6E6174617070667265652E63632F6170692F7061796D656E742F616C697061792F63616C6C6261636B2F6E6F746966790A72657475726E5F6F726465725F75726C3A20687474703A2F2F7061796D656E742E676D616C6C2E636F6D2F7061792F737563636573732E68746D6C0A72657475726E5F7061796D656E745F75726C3A20687474703A2F2F6170692E676D616C6C2E636F6D2F6170692F7061796D656E742F616C697061792F63616C6C6261636B2F72657475726E0A, '3e713dd6506a54bf6acb584de65008a4', '2010-05-05 00:00:00', '2021-09-29 03:12:31', null, '192.168.200.1', 'U', '');
INSERT INTO `his_config_info` VALUES ('10', '34', 'service-payment-dev.yaml', 'DEFAULT_GROUP', '', 0x7365727665723A0A2020706F72743A20383230350A737072696E673A0A202064617461736F757263653A0A20202020747970653A20636F6D2E7A61787865722E68696B6172692E48696B61726944617461536F757263650A202020206472697665722D636C6173732D6E616D653A20636F6D2E6D7973716C2E6A6462632E4472697665720A2020202075726C3A206A6462633A6D7973716C3A2F2F3139322E3136382E3230302E3132393A333330362F676D616C6C5F6F726465723F636861726163746572456E636F64696E673D7574662D382675736553534C3D66616C73650A20202020757365726E616D653A20726F6F740A2020202070617373776F72643A20726F6F740A2020202068696B6172693A0A202020202020636F6E6E656374696F6E2D746573742D71756572793A2053454C45435420310A202020202020636F6E6E656374696F6E2D74696D656F75743A2036303030300A20202020202069646C652D74696D656F75743A203530303030300A2020202020206D61782D6C69666574696D653A203534303030300A2020202020206D6178696D756D2D706F6F6C2D73697A653A2031320A2020202020206D696E696D756D2D69646C653A2031300A202020202020706F6F6C2D6E616D653A2047756C6948696B617269506F6F6C0A616C697061795F7075626C69635F6B65793A204D494942496A414E42676B71686B6947397730424151454641414F43415138414D49494243674B43415145416B57732B3367584D6F736957472B45626652796F7457423077617155337437714D51534278553072334A5A6F4E4435336A765751667A72475A38572B6F624D632B4F677775704F4444567868472F44454B5642497074755551596476416A43534839386D3268636C46636B737370754379397853375079666C5045343770567A5336764133536C7677354F4651327155636B75347061576E427867754C5547506A456E63696A354E637946796B2B2F6B35374D6D72564A77435A61492B6C464F533345713249586330377457584F34732F3253577233454A69774A75744F474264413164647676315572726C307057704546673330704A42364A37597465757864454C39306B754F3565642F766E544B35716751527645656C524F6B55573434784F4E6B313738347632384F4A586D4749436D4E4C312B4B794D2F534662464F53674A5A535631744558557A764C2F78767A46704C774944415141420A616C697061795F75726C3A2068747470733A2F2F6F70656E6170692E616C697061792E636F6D2F676174657761792E646F0A6170705F69643A20323032313030313136333631373435320A6170705F707269766174655F6B65793A204D494945765149424144414E42676B71686B6947397730424151454641415343424B63776767536A41674541416F4942415143385A37455A6D616E78794647734B344C724955654B4B727247785741484967506D55563854745A44732B6A65706C4A537731636B535936335168455534343444357164367872754A48427542333348472B696B346E384E386E5257693341744D6770433036316F713244636774494B4D6D51484F372F706F5944776270445A724F57584979694E73684666554F535455706E7253385576456B73366E3678522F4737327232464730376F5A7A4F3767335873504D723733777059616A4D59432F6268546D36434A4745575A696B4F4E4E44466B51705648612B7A6769747773716C4275764276567747774F48413942386152666F6B77414D6C364244584B6F4838424E6E53454D705753545253776273736179584151574E5537584B444B476F7A626E3455326445626C384743467A696B492F54377962544E6D35677334365A5A42476C712F5942342B76344433743734566C366E41674D4241414543676745414F69647A6865686C69596B416C4C6B316875685630624D51786577456B5138527A78544D32534F52495753327137522B46507459506B48675539325146466738356C4E6C74736935645A304D796C4B554658465259496938434C346D3756364531713132664A50656177566B4258487569673859366931545752764355557475766B546A742B2B41572F30514543484F74424D567A49393565592B765A7756546F7138682F2B55634E6D784B795674363651706F342B722B6355766C764758356D5867515643354674662F4D74484131692B6B6A747A42495443307841766D53584B7A6A4E315968746353397258794D485842694668584C646D764F586A6B6E304F6B6F7372322B746D65735866537744476848335A6C4F64487A69743444363032524E6C306E544131644F55574875436E63733154725762726961783836502F4559766D7A4D6948574356546D6D4E4A4330624D514B42675144304841584B4E735973646A43514F56347433534D714F4B61756C3637782F4B413230506D4D5A5666513273516B796A79466757704C38433136527A66337A493764662B7A4635536B76684659342B4C525A567758356F6B454659547A415A2F4E596F756A312F444142594F5071304530735931382F78747137464A2F43496B38716D437163637A716F79616F786F6143317A4174394534435945383969454F6E4F2B476863493348334C774B42675144466C517A7662586857527952466B6566742F613532584C6E796A367439695037774E4762474353656F4D44724175335A676F7161635550576A354D6753465A64543438483972463470506978586F65336A66554E735742554871443146326472447A376C704C30506270537367793665692B443452775441447375795877726B7672577247726F2B6836704E4A46796C79336E65612F676C6F44744A547A6668464677744E666D717943514B426742587A4D783455774D7363735938326156364D5A4F34562B2F373143726B64737A5A616F69586173775048754231717866686E5136796959795238704F36325352356E73313230466E6A3857466831484A7076396379567032305A616B494F31745867694477654F6837566E496A76784243367573546356367938315153363277324563306877494255765651747A63695547765032354E445834696778535977504757485034682F586E416F474163514E32614B546E42674B6650715063553461632B6472454358676745536742476F662B6D527533635435552F4E53394F7A304E71362B724D566D3144704D48416462757152696B71316143716F56577570353171453068696B5779396E644C364743796E765749444F5347724C57515A326B7970356B6D793562574F57414A364C6C36723759394E64496B2B4E4F6B77363134494646614E416A32535455773475507864527677443345436759454172774F5A7852337A6C2F465A667376564358664B382F6668755A584D4F7036487577716B7934744E70564C764F796968704F4A4F6349466A365A4A686F56646D694C3870312F31532B536D2F373567783174704675724B4D4E636D595A626973454337556B783752516F685A685A54714D5067697A6C56425475356E5233786B6865614A43396F6476796A7257514A3536396566586F3330676B57303461427037413135564E47355A2F553D0A6E6F746966795F7061796D656E745F75726C3A20687474703A2F2F6134626762772E6E6174617070667265652E63632F6170692F7061796D656E742F616C697061792F63616C6C6261636B2F6E6F746966790A72657475726E5F6F726465725F75726C3A20687474703A2F2F7061796D656E742E676D616C6C2E636F6D2F7061792F737563636573732E68746D6C0A72657475726E5F7061796D656E745F75726C3A20687474703A2F2F6170692E676D616C6C2E636F6D2F6170692F7061796D656E742F616C697061792F63616C6C6261636B2F72657475726E0A, '04b2fb42c239babaa09d09298af1710c', '2010-05-05 00:00:00', '2021-09-30 02:32:07', null, '192.168.200.1', 'U', '');
INSERT INTO `his_config_info` VALUES ('5', '35', 'service-activity-dev.yaml', 'DEFAULT_GROUP', '', 0x7365727665723A0A2020706F72743A20383230300A737072696E673A0A202064617461736F757263653A0A20202020747970653A20636F6D2E7A61787865722E68696B6172692E48696B61726944617461536F757263650A202020206472697665722D636C6173732D6E616D653A20636F6D2E6D7973716C2E6A6462632E4472697665720A2020202075726C3A206A6462633A6D7973716C3A2F2F6C6F63616C686F73743A333330362F676D616C6C5F61637469766974793F636861726163746572456E636F64696E673D7574662D382675736553534C3D66616C73650A20202020757365726E616D653A20726F6F740A2020202070617373776F72643A20726F6F740A2020202068696B6172693A0A202020202020636F6E6E656374696F6E2D746573742D71756572793A2053454C45435420310A202020202020636F6E6E656374696F6E2D74696D656F75743A2036303030300A20202020202069646C652D74696D656F75743A203530303030300A2020202020206D61782D6C69666574696D653A203534303030300A2020202020206D6178696D756D2D706F6F6C2D73697A653A2031320A2020202020206D696E696D756D2D69646C653A2031300A202020202020706F6F6C2D6E616D653A2047756C6948696B617269506F6F6C, 'fb83ec416feca31d55098ec3751a9757', '2010-05-05 00:00:00', '2021-09-30 06:26:59', null, '192.168.200.1', 'U', '');
INSERT INTO `his_config_info` VALUES ('15', '36', 'service-comment-dev.yaml', 'DEFAULT_GROUP', '', 0x7365727665723A0A2020706F72743A20383231310A737072696E673A0A20206D61696E3A0A20202020616C6C6F772D6265616E2D646566696E6974696F6E2D6F766572726964696E673A20747275652023E5BD93E98187E588B0E5908CE6A0B7E5908DE5AD97E79A84E697B6E58099EFBC8CE698AFE590A6E58581E8AEB8E8A686E79B96E6B3A8E5868C0A2020646174613A0A202020206D6F6E676F64623A0A202020202020686F73743A2034372E39332E3131382E3234310A202020202020706F72743A2032373031370A20202020202064617461626173653A20676D616C6C2023E68C87E5AE9AE6938DE4BD9CE79A84E695B0E68DAEE5BA930A202072656469733A0A20202020686F73743A206C6F63616C686F73740A20202020706F72743A20363337390A2020202064617461626173653A20300A2020202074696D656F75743A20313830303030300A2020202070617373776F72643A0A202020206C6574747563653A0A202020202020706F6F6C3A0A20202020202020206D61782D6163746976653A2032302023E69C80E5A4A7E8BF9EE68EA5E695B00A20202020202020206D61782D776169743A202D312020202023E69C80E5A4A7E998BBE5A19EE7AD89E5BE85E697B6E997B428E8B49FE695B0E8A1A8E7A4BAE6B2A1E99990E588B6290A20202020202020206D61782D69646C653A20352020202023E69C80E5A4A7E7A9BAE997B20A20202020202020206D696E2D69646C653A2030202020202023E69C80E5B08FE7A9BAE997B20A20206A61636B736F6E3A0A20202020646174652D666F726D61743A20797979792D4D4D2D64642048483A6D6D3A73730A2020202074696D652D7A6F6E653A20474D542B38, '4b9041b7cc6b82f98b0e371a5c3286d5', '2010-05-05 00:00:00', '2021-10-08 09:13:52', null, '192.168.200.1', 'U', '');-- ----------------------------
-- Table structure for `roles`
-- ----------------------------
DROP TABLE IF EXISTS `roles`;
CREATE TABLE `roles` (`username` varchar(50) NOT NULL,`role` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of roles
-- ----------------------------
INSERT INTO `roles` VALUES ('nacos', 'ROLE_ADMIN');-- ----------------------------
-- Table structure for `tenant_capacity`
-- ----------------------------
DROP TABLE IF EXISTS `tenant_capacity`;
CREATE TABLE `tenant_capacity` (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',`tenant_id` varchar(128) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'Tenant ID',`quota` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '配额,0表示使用默认值',`usage` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '使用量',`max_size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '单个配置大小上限,单位为字节,0表示使用默认值',`max_aggr_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '聚合子配置最大个数',`max_aggr_size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '单个聚合数据的子配置大小上限,单位为字节,0表示使用默认值',`max_history_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最大变更历史数量',`gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '创建时间',`gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '修改时间',PRIMARY KEY (`id`),UNIQUE KEY `uk_tenant_id` (`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='租户容量信息表';-- ----------------------------
-- Records of tenant_capacity
-- ------------------------------ ----------------------------
-- Table structure for `tenant_info`
-- ----------------------------
DROP TABLE IF EXISTS `tenant_info`;
CREATE TABLE `tenant_info` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',`kp` varchar(128) COLLATE utf8_bin NOT NULL COMMENT 'kp',`tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT 'tenant_id',`tenant_name` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT 'tenant_name',`tenant_desc` varchar(256) COLLATE utf8_bin DEFAULT NULL COMMENT 'tenant_desc',`create_source` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT 'create_source',`gmt_create` bigint(20) NOT NULL COMMENT '创建时间',`gmt_modified` bigint(20) NOT NULL COMMENT '修改时间',PRIMARY KEY (`id`),UNIQUE KEY `uk_tenant_info_kptenantid` (`kp`,`tenant_id`),KEY `idx_tenant_id` (`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='tenant_info';-- ----------------------------
-- Records of tenant_info
-- ------------------------------ ----------------------------
-- Table structure for `users`
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (`username` varchar(50) NOT NULL,`password` varchar(500) NOT NULL,`enabled` tinyint(1) NOT NULL,PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('nacos', '$2a$10$EuWPZHzz32dJN7jexM34MOeYirDdFAZm2kuWj7VEOJhhZkDrxfvUu', '1');
这些内容可以删除
3.更改nacos启动配置参数
docker run -d \
-e MODE=standalone \
-e PREFER_HOST_MODE=hostname \
-e SPRING_DATASOURCE_PLATFORM=mysql \
-e MYSQL_SERVICE_HOST=192.168.254.165 \
-e MYSQL_SERVICE_PORT=3306 \
-e MYSQL_SERVICE_USER=root \
-e MYSQL_SERVICE_PASSWORD=root \
-e MYSQL_SERVICE_DB_NAME=nacos \
-p 8848:8848 \
--name nacos \
--restart=always \
nacos/nacos-server:1.4.1
在sevice,还有service-gateway 父模块添加依赖
<dependency><groupId>com.alibaba.cloud</groupId><artifactId>spring-cloud-starter-alibaba-nacos-config</artifactId>
</dependency>
说明:搭建环境是我们注释了的,现在打开
改造:service-product
删除之前的配置文件
1,添加配置文件bootstrap.properties
#server.port = 8206spring.application.name=service-productspring.profiles.active=devspring.cloud.nacos.discovery.server-addr=192.168.168.165:8848spring.cloud.nacos.config.server-addr=192.168.168.165:8848spring.cloud.nacos.config.prefix=${spring.application.name}spring.cloud.nacos.config.file-extension=yamlspring.cloud.nacos.config.shared-configs[0].data-id=common.yaml
说明:
- 配置文件统一配置到nacos配置中心
- common.yaml为公共配置,后续有需要的service模块都可直接引用,避免重复配置
common.yaml配置文件如下:
mybatis-plus:configuration:log-impl: org.apache.ibatis.logging.stdout.StdOutImplmapper-locations: classpath:mapper/*Mapper.xml
feign:sentinel:enabled: trueclient:config:default:readTimeout: 3000connectTimeout: 1000
spring:cloud:sentinel:transport:dashboard: http://192.168.254.165:8080rabbitmq:host: 192.168.254.165port: 5672username: guestpassword: guestpublisher-confirm-type: correlatedpublisher-returns: truelistener:simple:acknowledge-mode: manual #默认情况下消息消费者是自动确认消息的,如果要手动确认消息则需要修改确认模式为manualprefetch: 1 # 消费者每次从队列获取的消息数量。此属性当不设置时为:轮询分发,设置为1为:公平分发redis:host: 192.168.254.165port: 6379database: 0timeout: 1800000password:lettuce:pool:max-active: 20 #最大连接数max-wait: -1 #最大阻塞等待时间(负数表示没限制)max-idle: 5 #最大空闲min-idle: 0 #最小空闲jackson:date-format: yyyy-MM-dd HH:mm:sstime-zone: GMT+8
商品模块配置文件service-product-dev.yaml
server:port: 8206
spring:datasource:type: com.zaxxer.hikari.HikariDataSourcedriver-class-name: com.mysql.jdbc.Driverurl: jdbc:mysql://192.168.254.165:3306/gmall_product?characterEncoding=utf-8&useSSL=falseusername: rootpassword: roothikari:connection-test-query: SELECT 1 # 自动检测连接connection-timeout: 60000 #数据库连接超时时间,默认30秒idle-timeout: 500000 #空闲连接存活最大时间,默认600000(10分钟)max-lifetime: 540000 #此属性控制池中连接的最长生命周期,值0表示无限生命周期,默认1800000即30分钟maximum-pool-size: 12 #连接池最大连接数,默认是10minimum-idle: 10 #最小空闲连接数量pool-name: SPHHikariPool # 连接池名称
minio:endpointUrl: http://192.168.254.165:9000accessKey: adminsecreKey: admin123456bucketName: gmall
配置完之后:注释一下项目里的:端口,看一下是否能够加载到nacos的配置文件
启动项目:加载到了8206,说明是从注册中心加载的
说明:其实配置属性还是以前项目的配置属性,只是变化了文件命名规则,配置项不变。
改造:server-gateway
删除之前的配置文件
添加配置文件bootstrap.properties
spring.application.name=server-gatewayspring.profiles.active=devspring.cloud.nacos.discovery.server-addr=192.168.254.165:8848spring.cloud.nacos.config.server-addr=192.168.254.165:8848spring.cloud.nacos.config.prefix=${spring.application.name}spring.cloud.nacos.config.file-extension=yaml
这个代码就是原来的配置 :application.yml中的内容
server:port: 80
spring:application:name: api-gatewaycloud:nacos:discovery:server-addr: 192.168.154.165:8848gateway:discovery: #是否与服务发现组件进行结合,通过 serviceId(必须设置成大写) 转发到具体的服务实例。默认为false,设为true便开启通过服务中心的自动根据 serviceId 创建路由的功能。locator: #路由访问方式:http://Gateway_HOST:Gateway_PORT/大写的serviceId/**,其中微服务应用名默认大写访问。enabled: trueroutes:- id: service-producturi: lb://service-productpredicates:- Path=/*/product/** # 路径匹配
说明:其他服务配置文件统一提供,资源库获取,上传nacos