• 尚品汇-(七)


    (1)在网关中实现跨域

    全局配置类实现

    包名:com.atguigu.gmall.gateway.config

    创建CorsConfig

    1. @Configuration
    2. public class CorsConfig {
    3. @Bean
    4. public CorsWebFilter corsWebFilter(){
    5. // cors跨域配置对象
    6. CorsConfiguration configuration = new CorsConfiguration();
    7. configuration.addAllowedOrigin("*"); //设置允许访问的网络
    8. configuration.setAllowCredentials(true); // 设置是否从服务器获取cookie
    9. configuration.addAllowedMethod("*"); // 设置请求方法 * 表示任意
    10. configuration.addAllowedHeader("*"); // 所有请求头信息 * 表示任意
    11. // 配置源对象
    12. UrlBasedCorsConfigurationSource configurationSource = new UrlBasedCorsConfigurationSource();
    13. configurationSource.registerCorsConfiguration("/**", configuration);
    14. // cors过滤器对象
    15. return new CorsWebFilter(configurationSource);
    16. }
    17. }

    (2)配置文件迁移nacos

     

    1.重新安装nacos,nacos数据保存至mysql,先删除已安装的nacos,再安装

     

    2.资源库获取nacos数据库表结构并且导入数据库

    导入nacos.sql:

    1. /*
    2. Navicat MySQL Data Transfer
    3. Source Server : 192.168.200.129
    4. Source Server Version : 50735
    5. Source Host : 192.168.200.129:3306
    6. Source Database : nacos
    7. Target Server Type : MYSQL
    8. Target Server Version : 50735
    9. File Encoding : 65001
    10. Date: 2021-10-19 16:59:32
    11. */
    12. SET FOREIGN_KEY_CHECKS=0;
    13. -- ----------------------------
    14. -- Table structure for `config_info`
    15. -- ----------------------------
    16. DROP TABLE IF EXISTS `config_info`;
    17. CREATE TABLE `config_info` (
    18. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    19. `data_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'data_id',
    20. `group_id` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    21. `content` longtext COLLATE utf8_bin NOT NULL COMMENT 'content',
    22. `md5` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT 'md5',
    23. `gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '创建时间',
    24. `gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '修改时间',
    25. `src_user` text COLLATE utf8_bin COMMENT 'source user',
    26. `src_ip` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT 'source ip',
    27. `app_name` varchar(128) COLLATE utf8_bin DEFAULT NULL,
    28. `tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT '租户字段',
    29. `c_desc` varchar(256) COLLATE utf8_bin DEFAULT NULL,
    30. `c_use` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    31. `effect` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    32. `type` varchar(64) COLLATE utf8_bin DEFAULT NULL,
    33. `c_schema` text COLLATE utf8_bin,
    34. PRIMARY KEY (`id`),
    35. UNIQUE KEY `uk_configinfo_datagrouptenant` (`data_id`,`group_id`,`tenant_id`)
    36. ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info';
    37. -- ----------------------------
    38. -- Records of config_info
    39. -- ----------------------------
    40. 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', '');
    41. 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', '');
    42. 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', '');
    43. 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);
    44. 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);
    45. 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', '');
    46. 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', '');
    47. 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', '');
    48. 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', '');
    49. 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);
    50. 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', '');
    51. 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);
    52. 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', '');
    53. 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);
    54. -- ----------------------------
    55. -- Table structure for `config_info_aggr`
    56. -- ----------------------------
    57. DROP TABLE IF EXISTS `config_info_aggr`;
    58. CREATE TABLE `config_info_aggr` (
    59. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    60. `data_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'data_id',
    61. `group_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'group_id',
    62. `datum_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'datum_id',
    63. `content` longtext COLLATE utf8_bin NOT NULL COMMENT '内容',
    64. `gmt_modified` datetime NOT NULL COMMENT '修改时间',
    65. `app_name` varchar(128) COLLATE utf8_bin DEFAULT NULL,
    66. `tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT '租户字段',
    67. PRIMARY KEY (`id`),
    68. UNIQUE KEY `uk_configinfoaggr_datagrouptenantdatum` (`data_id`,`group_id`,`tenant_id`,`datum_id`)
    69. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='增加租户字段';
    70. -- ----------------------------
    71. -- Records of config_info_aggr
    72. -- ----------------------------
    73. -- ----------------------------
    74. -- Table structure for `config_info_beta`
    75. -- ----------------------------
    76. DROP TABLE IF EXISTS `config_info_beta`;
    77. CREATE TABLE `config_info_beta` (
    78. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    79. `data_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'data_id',
    80. `group_id` varchar(128) COLLATE utf8_bin NOT NULL COMMENT 'group_id',
    81. `app_name` varchar(128) COLLATE utf8_bin DEFAULT NULL COMMENT 'app_name',
    82. `content` longtext COLLATE utf8_bin NOT NULL COMMENT 'content',
    83. `beta_ips` varchar(1024) COLLATE utf8_bin DEFAULT NULL COMMENT 'betaIps',
    84. `md5` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT 'md5',
    85. `gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '创建时间',
    86. `gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '修改时间',
    87. `src_user` text COLLATE utf8_bin COMMENT 'source user',
    88. `src_ip` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT 'source ip',
    89. `tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT '租户字段',
    90. PRIMARY KEY (`id`),
    91. UNIQUE KEY `uk_configinfobeta_datagrouptenant` (`data_id`,`group_id`,`tenant_id`)
    92. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info_beta';
    93. -- ----------------------------
    94. -- Records of config_info_beta
    95. -- ----------------------------
    96. -- ----------------------------
    97. -- Table structure for `config_info_tag`
    98. -- ----------------------------
    99. DROP TABLE IF EXISTS `config_info_tag`;
    100. CREATE TABLE `config_info_tag` (
    101. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    102. `data_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'data_id',
    103. `group_id` varchar(128) COLLATE utf8_bin NOT NULL COMMENT 'group_id',
    104. `tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT 'tenant_id',
    105. `tag_id` varchar(128) COLLATE utf8_bin NOT NULL COMMENT 'tag_id',
    106. `app_name` varchar(128) COLLATE utf8_bin DEFAULT NULL COMMENT 'app_name',
    107. `content` longtext COLLATE utf8_bin NOT NULL COMMENT 'content',
    108. `md5` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT 'md5',
    109. `gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '创建时间',
    110. `gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '修改时间',
    111. `src_user` text COLLATE utf8_bin COMMENT 'source user',
    112. `src_ip` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT 'source ip',
    113. PRIMARY KEY (`id`),
    114. UNIQUE KEY `uk_configinfotag_datagrouptenanttag` (`data_id`,`group_id`,`tenant_id`,`tag_id`)
    115. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info_tag';
    116. -- ----------------------------
    117. -- Records of config_info_tag
    118. -- ----------------------------
    119. -- ----------------------------
    120. -- Table structure for `config_tags_relation`
    121. -- ----------------------------
    122. DROP TABLE IF EXISTS `config_tags_relation`;
    123. CREATE TABLE `config_tags_relation` (
    124. `id` bigint(20) NOT NULL COMMENT 'id',
    125. `tag_name` varchar(128) COLLATE utf8_bin NOT NULL COMMENT 'tag_name',
    126. `tag_type` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT 'tag_type',
    127. `data_id` varchar(255) COLLATE utf8_bin NOT NULL COMMENT 'data_id',
    128. `group_id` varchar(128) COLLATE utf8_bin NOT NULL COMMENT 'group_id',
    129. `tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT 'tenant_id',
    130. `nid` bigint(20) NOT NULL AUTO_INCREMENT,
    131. PRIMARY KEY (`nid`),
    132. UNIQUE KEY `uk_configtagrelation_configidtag` (`id`,`tag_name`,`tag_type`),
    133. KEY `idx_tenant_id` (`tenant_id`)
    134. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_tag_relation';
    135. -- ----------------------------
    136. -- Records of config_tags_relation
    137. -- ----------------------------
    138. -- ----------------------------
    139. -- Table structure for `group_capacity`
    140. -- ----------------------------
    141. DROP TABLE IF EXISTS `group_capacity`;
    142. CREATE TABLE `group_capacity` (
    143. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
    144. `group_id` varchar(128) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'Group ID,空字符表示整个集群',
    145. `quota` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '配额,0表示使用默认值',
    146. `usage` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '使用量',
    147. `max_size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '单个配置大小上限,单位为字节,0表示使用默认值',
    148. `max_aggr_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '聚合子配置最大个数,,0表示使用默认值',
    149. `max_aggr_size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '单个聚合数据的子配置大小上限,单位为字节,0表示使用默认值',
    150. `max_history_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最大变更历史数量',
    151. `gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '创建时间',
    152. `gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '修改时间',
    153. PRIMARY KEY (`id`),
    154. UNIQUE KEY `uk_group_id` (`group_id`)
    155. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='集群、各Group容量信息表';
    156. -- ----------------------------
    157. -- Records of group_capacity
    158. -- ----------------------------
    159. -- ----------------------------
    160. -- Table structure for `his_config_info`
    161. -- ----------------------------
    162. DROP TABLE IF EXISTS `his_config_info`;
    163. CREATE TABLE `his_config_info` (
    164. `id` bigint(64) unsigned NOT NULL,
    165. `nid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    166. `data_id` varchar(255) COLLATE utf8_bin NOT NULL,
    167. `group_id` varchar(128) COLLATE utf8_bin NOT NULL,
    168. `app_name` varchar(128) COLLATE utf8_bin DEFAULT NULL COMMENT 'app_name',
    169. `content` longtext COLLATE utf8_bin NOT NULL,
    170. `md5` varchar(32) COLLATE utf8_bin DEFAULT NULL,
    171. `gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00',
    172. `gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00',
    173. `src_user` text COLLATE utf8_bin,
    174. `src_ip` varchar(20) COLLATE utf8_bin DEFAULT NULL,
    175. `op_type` char(10) COLLATE utf8_bin DEFAULT NULL,
    176. `tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT '租户字段',
    177. PRIMARY KEY (`nid`),
    178. KEY `idx_gmt_create` (`gmt_create`),
    179. KEY `idx_gmt_modified` (`gmt_modified`),
    180. KEY `idx_did` (`data_id`)
    181. ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='多租户改造';
    182. -- ----------------------------
    183. -- Records of his_config_info
    184. -- ----------------------------
    185. 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', '');
    186. 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', '');
    187. 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', '');
    188. 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', '');
    189. 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', '');
    190. 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', '');
    191. 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', '');
    192. 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', '');
    193. 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', '');
    194. 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', '');
    195. 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', '');
    196. 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', '');
    197. 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', '');
    198. 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', '');
    199. 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', '');
    200. 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', '');
    201. -- ----------------------------
    202. -- Table structure for `roles`
    203. -- ----------------------------
    204. DROP TABLE IF EXISTS `roles`;
    205. CREATE TABLE `roles` (
    206. `username` varchar(50) NOT NULL,
    207. `role` varchar(50) NOT NULL
    208. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    209. -- ----------------------------
    210. -- Records of roles
    211. -- ----------------------------
    212. INSERT INTO `roles` VALUES ('nacos', 'ROLE_ADMIN');
    213. -- ----------------------------
    214. -- Table structure for `tenant_capacity`
    215. -- ----------------------------
    216. DROP TABLE IF EXISTS `tenant_capacity`;
    217. CREATE TABLE `tenant_capacity` (
    218. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
    219. `tenant_id` varchar(128) COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'Tenant ID',
    220. `quota` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '配额,0表示使用默认值',
    221. `usage` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '使用量',
    222. `max_size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '单个配置大小上限,单位为字节,0表示使用默认值',
    223. `max_aggr_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '聚合子配置最大个数',
    224. `max_aggr_size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '单个聚合数据的子配置大小上限,单位为字节,0表示使用默认值',
    225. `max_history_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最大变更历史数量',
    226. `gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '创建时间',
    227. `gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00' COMMENT '修改时间',
    228. PRIMARY KEY (`id`),
    229. UNIQUE KEY `uk_tenant_id` (`tenant_id`)
    230. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='租户容量信息表';
    231. -- ----------------------------
    232. -- Records of tenant_capacity
    233. -- ----------------------------
    234. -- ----------------------------
    235. -- Table structure for `tenant_info`
    236. -- ----------------------------
    237. DROP TABLE IF EXISTS `tenant_info`;
    238. CREATE TABLE `tenant_info` (
    239. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
    240. `kp` varchar(128) COLLATE utf8_bin NOT NULL COMMENT 'kp',
    241. `tenant_id` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT 'tenant_id',
    242. `tenant_name` varchar(128) COLLATE utf8_bin DEFAULT '' COMMENT 'tenant_name',
    243. `tenant_desc` varchar(256) COLLATE utf8_bin DEFAULT NULL COMMENT 'tenant_desc',
    244. `create_source` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT 'create_source',
    245. `gmt_create` bigint(20) NOT NULL COMMENT '创建时间',
    246. `gmt_modified` bigint(20) NOT NULL COMMENT '修改时间',
    247. PRIMARY KEY (`id`),
    248. UNIQUE KEY `uk_tenant_info_kptenantid` (`kp`,`tenant_id`),
    249. KEY `idx_tenant_id` (`tenant_id`)
    250. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='tenant_info';
    251. -- ----------------------------
    252. -- Records of tenant_info
    253. -- ----------------------------
    254. -- ----------------------------
    255. -- Table structure for `users`
    256. -- ----------------------------
    257. DROP TABLE IF EXISTS `users`;
    258. CREATE TABLE `users` (
    259. `username` varchar(50) NOT NULL,
    260. `password` varchar(500) NOT NULL,
    261. `enabled` tinyint(1) NOT NULL,
    262. PRIMARY KEY (`username`)
    263. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    264. -- ----------------------------
    265. -- Records of users
    266. -- ----------------------------
    267. 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 父模块添加依赖

    1. <dependency>
    2. <groupId>com.alibaba.cloud</groupId>
    3. <artifactId>spring-cloud-starter-alibaba-nacos-config</artifactId>
    4. </dependency>

    说明:搭建环境是我们注释了的,现在打开

    改造:service-product

    删除之前的配置文件

    1,添加配置文件bootstrap.properties

    #server.port = 8206
    
      spring.application.name=service-product
    
      spring.profiles.active=dev
    
      spring.cloud.nacos.discovery.server-addr=192.168.168.165:8848
    
      spring.cloud.nacos.config.server-addr=192.168.168.165:8848
    
      spring.cloud.nacos.config.prefix=${spring.application.name}
    
      spring.cloud.nacos.config.file-extension=yaml
    
      spring.cloud.nacos.config.shared-configs[0].data-id=common.yaml

     

    说明:

    1. 配置文件统一配置到nacos配置中心
    2. common.yaml为公共配置,后续有需要的service模块都可直接引用,避免重复配置

    common.yaml配置文件如下:

    1. mybatis-plus:
    2. configuration:
    3. log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
    4. mapper-locations: classpath:mapper/*Mapper.xml
    5. feign:
    6. sentinel:
    7. enabled: true
    8. client:
    9. config:
    10. default:
    11. readTimeout: 3000
    12. connectTimeout: 1000
    13. spring:
    14. cloud:
    15. sentinel:
    16. transport:
    17. dashboard: http://192.168.254.165:8080
    18. rabbitmq:
    19. host: 192.168.254.165
    20. port: 5672
    21. username: guest
    22. password: guest
    23. publisher-confirm-type: correlated
    24. publisher-returns: true
    25. listener:
    26. simple:
    27. acknowledge-mode: manual #默认情况下消息消费者是自动确认消息的,如果要手动确认消息则需要修改确认模式为manual
    28. prefetch: 1 # 消费者每次从队列获取的消息数量。此属性当不设置时为:轮询分发,设置为1为:公平分发
    29. redis:
    30. host: 192.168.254.165
    31. port: 6379
    32. database: 0
    33. timeout: 1800000
    34. password:
    35. lettuce:
    36. pool:
    37. max-active: 20 #最大连接数
    38. max-wait: -1 #最大阻塞等待时间(负数表示没限制)
    39. max-idle: 5 #最大空闲
    40. min-idle: 0 #最小空闲
    41. jackson:
    42. date-format: yyyy-MM-dd HH:mm:ss
    43. time-zone: GMT+8

    商品模块配置文件service-product-dev.yaml

    1. server:
    2. port: 8206
    3. spring:
    4. datasource:
    5. type: com.zaxxer.hikari.HikariDataSource
    6. driver-class-name: com.mysql.jdbc.Driver
    7. url: jdbc:mysql://192.168.254.165:3306/gmall_product?characterEncoding=utf-8&useSSL=false
    8. username: root
    9. password: root
    10. hikari:
    11. connection-test-query: SELECT 1 # 自动检测连接
    12. connection-timeout: 60000 #数据库连接超时时间,默认30
    13. idle-timeout: 500000 #空闲连接存活最大时间,默认60000010分钟)
    14. max-lifetime: 540000 #此属性控制池中连接的最长生命周期,值0表示无限生命周期,默认180000030分钟
    15. maximum-pool-size: 12 #连接池最大连接数,默认是10
    16. minimum-idle: 10 #最小空闲连接数量
    17. pool-name: SPHHikariPool # 连接池名称
    18. minio:
    19. endpointUrl: http://192.168.254.165:9000
    20. accessKey: admin
    21. secreKey: admin123456
    22. bucketName: gmall

    配置完之后:注释一下项目里的:端口,看一下是否能够加载到nacos的配置文件

    启动项目:加载到了8206,说明是从注册中心加载的

    说明:其实配置属性还是以前项目的配置属性,只是变化了文件命名规则,配置项不变。

    改造:server-gateway

    删除之前的配置文件

    添加配置文件bootstrap.properties

    spring.application.name=server-gateway
    
      spring.profiles.active=dev
    
      spring.cloud.nacos.discovery.server-addr=192.168.254.165:8848
    
      spring.cloud.nacos.config.server-addr=192.168.254.165:8848
    
      spring.cloud.nacos.config.prefix=${spring.application.name}
    
      spring.cloud.nacos.config.file-extension=yaml

    这个代码就是原来的配置 :application.yml中的内容

    1. server:
    2. port: 80
    3. spring:
    4. application:
    5. name: api-gateway
    6. cloud:
    7. nacos:
    8. discovery:
    9. server-addr: 192.168.154.165:8848
    10. gateway:
    11. discovery: #是否与服务发现组件进行结合,通过 serviceId(必须设置成大写) 转发到具体的服务实例。默认为false,设为true便开启通过服务中心的自动根据 serviceId 创建路由的功能。
    12. locator: #路由访问方式:http://Gateway_HOST:Gateway_PORT/大写的serviceId/**,其中微服务应用名默认大写访问。
    13. enabled: true
    14. routes:
    15. - id: service-product
    16. uri: lb://service-product
    17. predicates:
    18. - Path=/*/product/** # 路径匹配

     

     

     

    说明:其他服务配置文件统一提供,资源库获取,上传nacos

     

     

  • 相关阅读:
    item_get-商品详情
    Jmeter测试添加凭证和导出压测结果
    2021-09-21如何在PCB上做一个城市地铁图?
    JavaEE初阶 --多线程(一)
    SuperMap iDesktopX基于地形DEM数据做最佳路径分析
    阿里巴巴2022年最新最全面的500道Java后端面试大全(值得收藏)助你拿下面试
    方程组解的情况与向量组相关性转化【线代碎碎念】
    组合模式,宏指令和普通指令的聚合应用(设计模式与开发实践 P10)
    学校网页设计成品 基于HTML+CSS+JavaScript仿山东财经大学官网 学校班级网页制作模板 校园网页设计成品
    【论文阅读】EssayGAN:基于生成对抗网络的数据增强用于自动作文评分
  • 原文地址:https://blog.csdn.net/dengfengling999/article/details/139998725