nacos.sql 86 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304
  1. /*
  2. Navicat Premium Data Transfer
  3. Source Server : 本机
  4. Source Server Type : MySQL
  5. Source Server Version : 50741
  6. Source Host : localhost:3306
  7. Source Schema : nacos
  8. Target Server Type : MySQL
  9. Target Server Version : 50741
  10. File Encoding : 65001
  11. Date: 05/07/2025 13:19:56
  12. */
  13. SET NAMES utf8mb4;
  14. SET FOREIGN_KEY_CHECKS = 0;
  15. -- ----------------------------
  16. -- Table structure for config_info
  17. -- ----------------------------
  18. DROP TABLE IF EXISTS `config_info`;
  19. CREATE TABLE `config_info` (
  20. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  21. `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  22. `group_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  23. `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
  24. `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'md5',
  25. `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  26. `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  27. `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user',
  28. `src_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'source ip',
  29. `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  30. `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租户字段',
  31. `c_desc` varchar(256) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  32. `c_use` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  33. `effect` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  34. `type` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  35. `c_schema` text CHARACTER SET utf8 COLLATE utf8_bin NULL,
  36. PRIMARY KEY (`id`) USING BTREE,
  37. UNIQUE INDEX `uk_configinfo_datagrouptenant`(`data_id`, `group_id`, `tenant_id`) USING BTREE
  38. ) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_info' ROW_FORMAT = DYNAMIC;
  39. -- ----------------------------
  40. -- Records of config_info
  41. -- ----------------------------
  42. INSERT INTO `config_info` VALUES (1, 'blade-dev.yaml', 'DEFAULT_GROUP', '#spring配置\nspring:\n redis:\n ##redis 单机环境配置\n host: 127.0.0.1\n port: 6379\n password: 123456\n database: 2\n ssl: false\n ##redis 集群环境配置\n #cluster:\n # nodes: 127.0.0.1:7001,127.0.0.1:7002,127.0.0.1:7003\n # commandTimeout: 5000\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n #driver-class-name: org.postgresql.Driver\n #driver-class-name: oracle.jdbc.OracleDriver\n #driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver\n #driver-class-name: dm.jdbc.driver.DmDriver\n druid:\n # MySql、PostgreSQL、SqlServer、DaMeng校验\n validation-query: select 1\n # Oracle校验\n #validation-query: select 1 from dual\n rabbitmq:\n host: 120.79.156.41\n port: 5672\n username: root\n password: hrwb2022\n virtual-host: dev\n listener:\n simple:\n acknowledge-mode: manual\n default-requeue-rejected: true\n retry:\n #时间间隔5秒\n initial-interval: 5000ms\n enabled: true\n #最大重试次数\n max-attempts: 3\n publisher-confirm-type: correlated\n publisher-returns: true \n\n#项目模块集中配置\nblade:\n #分布式锁配置\n lock:\n enabled: true\n address: redis://127.0.0.1:6379\n password: 123456\n #多团队协作服务配置\n loadbalancer:\n #开启配置\n enabled: true\n #负载均衡优先调用的ip段\n prior-ip-pattern:\n - 192.168.0.*\n - 127.0.0.1\n #通用开发生产环境数据库地址(特殊情况可在对应的子工程里配置覆盖)\n datasource:\n # MySql\n url: jdbc:mysql://127.0.0.1:3306/sc_test?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&tinyInt1isBit=false&allowMultiQueries=true&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true\n username: root\n password: 123456\nchain: \n name: TiChain\n app-id: tichain0000000000001\n app-key: xyusdjysdsdsasds3UyZ\n url: https://test.api.tichain.tianhecloud.com/api/v2\n make-time: 7\n first-make-time: 7\norder:\n expired:\n duration: 600000\n delivery: \n duration: 86400000\n make:\n duration: 86400000 \noss:\n enabled: true\n name: ali\n tenant-mode: false\n endpoint: https://oss-cn-guangzhou.aliyuncs.com\n access-key: LTAI5tN2FFvL434rEQfKmPPC\n secret-key: DsQTkQETZnDJNdCq0JragfEp1RWh4f\n bucket-name: szcp-ywc\n args:\n cdn-domain: https://oss.yuanwenchuang.com\nsandpay:\n merchant-no: 6888800120010\n private-key: yuanwenchuang\n private-key-password: 991107\n notify-url: https://site.yuanwenchuang.com/api/sc/payment/notify\n return-url: https://site.yuanwenchuang.com/h5/pageA/home/hpay/index\nsms:\n white-list: 18975176249,18616319407,18975191459\nalipay:\n appId: 2021003185630147\n privateKey: MIIEvQIBADANBgkqhkiG9w0BAQEFAASCBKcwggSjAgEAAoIBAQDiq3YV8u9Cq4ekmsyCNrJ6EY7bMxO+k4tco3OWxH7VPhInXEA2rqplD4KXFDw63tyoU1WPeq2fTSZuv7UDkm3PLwCsohVaQ3ODQLIGl5EC4ZPsjSnTpE1QmppJy+ItK1FfgrSj+NCnNm4eSf42z4MDphU0+idaqR24Wur9PdFVh/YKMbMmjZmb1xOF88QQw6r+uMkMXzJW13zgo2tHKXiYm66BwYIgUQRyO1nb33Mzoy3vcW07lzTPCvC4Wm+5hQKvbcTEnpZUFQn3vSYO1dzU62eaeaV/w/DGAH7yHvLIilXoFVS1k4SExNttkJmLdgS0zaAfJmP42QJqGWpTxxFrAgMBAAECggEAPA13LJt/PieZuUd11S3OnT6XnYVrvrryWinHzvLiM3bNcnYjYRlndXzleUdYKbSvuzzQ10GGTEUxYHgT6g1aYGCwigwrIg3qxaRXRh3TwnKnMS25HiRSg39iTxjgJF1soqRLXYHnLdXi2M17t2PE7yuKRM3drUxO3m/gABXnpwPtwMSilgsNgFy7IBdStGA90pABMQZLuEnRmSLGgpmmtZsM4UKHX29B4+rOO3sKAyP3hub+wT1+u7dkxp2+nBH4ssjMIa8EMnF62L5OmF3NqevSu0E6BudfjC+/qoy8BInRMqAcx1lJKNn9mliKpBFwyNFS1n4Dsp95m0meFK+rAQKBgQD3Yc0m/W4/gPt9kKmx7/CJ2DTzxHJHEEzfyk8Df2lcDkk+2FL6NPt2z9ldebcTUHjDhRQg3qv4CYCAFRGwLun+RxO3GkaWe21Erw8duj7a68xYYRx4n98yw9bhyA5gUnq9mldFzpNgaE8IwfidPE3xmkclMT5g3QEHyYke2W0CgQKBgQDqkPGvwePs9reAAckfck0D4vIfMTKh5pvsvCZhPj7cbfzTTBTdBawj1C1+uxqvU0tI8tPBsTTmFqzUmhsRZx93SB00xi2gfXfv1O/rIJyFciUUhBoWATWElkqGUkuRuE7hS3ASPhAZ75AELPhaP7utzv1/scDCxXS/oA8eBIlF6wKBgH4cy7suw394P705fGkLyvJa2FPVN/TmaGpF9pXv5ERbvBdfrJ2FWRSuzT8MB7q+8XGrbCF9ouml3m5tT0EkCYHptjFIIeghMAktvWUIR3bPcrMzfpI33k9A61Da7glIwu3ZutgJgbRKONBcImP2FD4wykg5nHVA9X+EzHR/n0UBAoGBAICc5Mf3yd9+D3NSh1KEu5Gr+BH+ScLXzRrqtyiOlq0KaZv5lV7y40Xp6uAX+zOyug7Phign39dhC3au4LSUFH60vb7YAuCCqyaHXN1RTkElKwuquxrhotSGC2rG6MSHiEijslluSinOXurLNYlWdLOCUSCY+BZTagY/3soYtqPtAoGALUB+uu+a3aC7MKJRDtVhNdQr3Xg5O2uIwCLpjSEUtn+JNQqKwM6PIzU7XQ7wT7Zb02KLqJrO946kAPOmroyygtTuv+AFY8WkqzFIo0mFx/yrWCs6+nAeFWn8LyUZseuXd9mPgRSa93RKIUefegvfWT9H9k3WWZ5YxfuF91SJOrY=\n alipayPublicKey: MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAxkySUAdNkK0PsNXyFhSpaVYI3Z7o8CuaW5PsDDN9FeyxnBNzhIs5dr/tFSLq58yG6tTnqWsil0iy+Pj3+NhXVTFeeIa1KobLijWTvrfqo2mX/qozd+de5WDM8I9NDnMChpiA5bPEjZU+dDuOS1BrYdEAdz7dLYso0eWrBpmdsorjwu7bBpvZlzbRpBXo2dP3AK9UFRPpX9uEYs8i3u1GDNvQG8Iuaqy8cDOj308GaNJAGyTuwhycnG51nIRNQXomX4nzKCyzg8WD/qAsxEihvfmGhxWa9u50gvAujxo/Ss2y1e0rDge3WgwziYlFaWDzx7JKzhAXqOY/6LcZ5CFtpwIDAQAB\n serverUrl: https://openapi.alipay.com/gateway.do\n notifyUrl: https://site.yuanwenchuang.com/api/sc/alipay/notify\n returnUrl: https://site.yuanwenchuang.com/h5/pageA/home/hpay/index\n format: json\n charset: UTF8\n signType: RSA2 \n', '47d0030ec446a3684585715fa88bd2d2', '2024-01-17 00:59:16', '2024-01-17 01:03:40', NULL, '0:0:0:0:0:0:0:1', '', 'db463518-66f2-42c1-9070-35afa7555d45', '', '', '', 'yaml', '');
  43. INSERT INTO `config_info` VALUES (2, 'blade.yaml', 'DEFAULT_GROUP', '#服务器配置\nserver:\n undertow:\n threads:\n # 设置IO线程数, 它主要执行非阻塞的任务,它们会负责多个连接, 默认设置每个CPU核心一个线程\n io: 16\n # 阻塞任务线程池, 当执行类似servlet请求阻塞操作, undertow会从这个线程池中取得线程,它的值设置取决于系统的负载\n worker: 400\n # 以下的配置会影响buffer,这些buffer会用于服务器连接的IO操作,有点类似netty的池化内存管理\n buffer-size: 1024\n # 是否分配的直接内存\n direct-buffers: true\n\n#spring配置\nspring:\n cloud:\n # sentinel:\n # eager: true\n # port: 8719\n # dashboard: 120.79.156.41:8858\n devtools:\n restart:\n log-condition-evaluation-delta: false\n livereload:\n port: 23333\n servlet:\n multipart:\n enabled: true\n max-file-size: 50MB\n max-request-size: 50MB\n\n#feign配置\nfeign:\n sentinel:\n enabled: true\n okhttp:\n enabled: true\n httpclient:\n enabled: false\n\n#对外暴露端口\nmanagement:\n endpoints:\n web:\n exposure:\n include: \"*\"\n endpoint:\n health:\n show-details: always\n\n#knife4j配置\nknife4j:\n #启用\n enable: true\n #基础认证\n basic:\n enable: false\n username: blade\n password: blade\n #增强配置\n setting:\n enableSwaggerModels: true\n enableDocumentManage: true\n enableHost: false\n enableHostText: http://localhost\n enableRequestCache: true\n enableFilterMultipartApis: false\n enableFilterMultipartApiMethodType: POST\n language: zh-CN\n enableFooter: false\n enableFooterCustom: true\n footerCustomContent: Copyright © 2022 BladeX All Rights Reserved\n\n#swagger公共信息\nswagger:\n title: BladeX 接口文档系统\n description: BladeX 接口文档系统\n version: 3.0.1.RELEASE\n license: Powered By BladeX\n license-url: https://bladex.vip\n terms-of-service-url: https://bladex.vip\n contact:\n name: smallchill\n email: smallchill@163.com\n url: https://gitee.com/smallc\n\n#blade配置\nblade:\n #token配置\n token:\n #是否有状态\n state: false\n #redis序列化方式\n redis:\n serializer-type: protostuff\n rate-limiter: \n enabled: true\n #接口配置\n api:\n #报文加密配置\n crypto:\n #启用报文加密配置\n enabled: false\n #使用AesUtil.genAesKey()生成\n aes-key: O2BEeIv399qHQNhD6aGW8R8DEj4bqHXm\n #使用DesUtil.genDesKey()生成\n des-key: jMVCBsFGDQr1USHo\n #jackson配置\n jackson:\n #null自动转空值\n null-to-empty: true\n #大数字自动转字符串\n big-num-to-string: true\n #支持text文本请求,与报文加密同时开启\n support-text-plain: false\n #xss配置\n xss:\n enabled: true\n skip-url:\n - /weixin\n - /notice/submit\n - /model/submit\n - /store/content\n - /lottery/create\n - /version/create\n #安全框架配置\n secure:\n #接口放行\n skip-url:\n - /test/**\n - /payment/notify\n - /store/info/**\n - /store/content/h5\n - /store/content/detail\n - /product/h/page\n - /product/h/detail/**\n - /issue/calendar/h\n - /compose/page/h\n - /compose/detail\n - /drop/export-template\n - /box/page/h\n - /box/detail\n - /lottery/page/h\n - /lottery/h/detail\n - /alipay/notify\n - /drop/lx/detail\n - /version/check/**\n #授权认证配置\n auth:\n - method: ALL\n pattern: /weixin/**\n expression: \"hasAuth()\"\n - method: POST\n pattern: /dashboard/upload\n expression: \"hasTimeAuth(9, 17)\"\n - method: POST\n pattern: /dashboard/submit\n expression: \"hasAnyRole(\'administrator\', \'admin\', \'user\')\"\n #基础认证配置\n basic:\n - method: ALL\n pattern: /dashboard/info\n username: \"blade\"\n password: \"blade\"\n #动态签名认证配置\n sign:\n - method: ALL\n pattern: /dashboard/sign\n crypto: \"sha1\"\n #多终端认证配置\n client:\n - client-id: sword\n path-patterns:\n - /sword/**\n - client-id: saber\n path-patterns:\n - /saber/**\n #多租户配置\n tenant:\n #多租户增强\n enhance: true\n #多租户授权保护\n license: false\n #动态数据源功能\n dynamic-datasource: false\n #动态数据源全局扫描\n dynamic-global: false\n #多租户字段名\n column: tenant_id\n #排除多租户逻辑\n exclude-tables:\n - blade_user\n - sc_user_chain\n - sc_delivery_address\n - sc_product_mint\n - sc_product_mint_log\n - sc_drop_log\n - sc_certification\n - sc_message\n - sc_message_log\n - sc_transaction_pwd\n - sc_blind_box_info\n - sc_drop_lx_log\n - sc_version', '60f4a8df9eda8ced06a3052a73b6444c', '2024-01-17 00:59:16', '2024-01-17 00:59:16', NULL, '0:0:0:0:0:0:0:1', '', 'db463518-66f2-42c1-9070-35afa7555d45', NULL, NULL, NULL, 'yaml', NULL);
  44. INSERT INTO `config_info` VALUES (3, 'blade-gateway-flow-rules', 'DEFAULT_GROUP', '[{\"app\":\"blade-gateway\",\"burst\":0,\"controlBehavior\":0,\"count\":12.0,\"gmtCreate\":1684294048263,\"gmtModified\":1684294147792,\"grade\":1,\"id\":2,\"interval\":1,\"intervalUnit\":0,\"ip\":\"192.168.0.87\",\"port\":8720,\"resource\":\"列表\",\"resourceMode\":1}]', '43e1e8d35c8ad8d7b4db3650c3b47b4c', '2024-01-17 00:59:16', '2024-01-17 00:59:16', NULL, '0:0:0:0:0:0:0:1', '', 'db463518-66f2-42c1-9070-35afa7555d45', NULL, NULL, NULL, NULL, NULL);
  45. INSERT INTO `config_info` VALUES (11, 'kd.yaml', 'DEFAULT_GROUP', '#服务器配置\nserver:\n undertow:\n threads:\n # 设置IO线程数, 它主要执行非阻塞的任务,它们会负责多个连接, 默认设置每个CPU核心一个线程\n io: 16\n # 阻塞任务线程池, 当执行类似servlet请求阻塞操作, undertow会从这个线程池中取得线程,它的值设置取决于系统的负载\n worker: 400\n # 以下的配置会影响buffer,这些buffer会用于服务器连接的IO操作,有点类似netty的池化内存管理\n buffer-size: 1024\n # 是否分配的直接内存\n direct-buffers: true\n\n#spring配置\nspring:\n cloud:\n nacos:\n discovery:\n # 禁用云命名空间解析,防止和云平台环境变量冲突\n isUseCloudNamespaceParsing: false\n config:\n # 禁用云命名空间解析,防止和云平台环境变量冲突\n isUseCloudNamespaceParsing: false\n sentinel:\n eager: true\n devtools:\n restart:\n log-condition-evaluation-delta: false\n livereload:\n port: 23333\n\n#feign配置\nfeign:\n sentinel:\n enabled: true\n okhttp:\n enabled: true\n httpclient:\n enabled: false\n\n#对外暴露端口\nmanagement:\n endpoints:\n web:\n exposure:\n include: \"*\"\n endpoint:\n health:\n show-details: always\n\n#springdoc-openapi配置\nspringdoc:\n default-flat-param-object: true\n\n#knife4j配置\nknife4j:\n #基础认证\n basic:\n enable: false\n username: blade\n password: blade\n #增强配置\n setting:\n enableSwaggerModels: true\n enableDocumentManage: true\n enableHost: false\n enableHostText: http://localhost\n enableRequestCache: true\n enableFilterMultipartApis: false\n enableFilterMultipartApiMethodType: POST\n language: zh_cn\n enableFooter: false\n enableFooterCustom: true\n footerCustomContent: Copyright © 2025 BladeX All Rights Reserved\n\n#swagger公共信息\nswagger:\n title: 接口文档系统\n description: 接口文档系统\n version: 1.0.0.RELEASE\n license: Powered By Sky\n\n#blade配置\nkd:\n #oauth2配置\n oauth2:\n #启用 oauth2\n enabled: true\n #使用 @org.springblade.test.Sm2KeyGenerator 获取,用于国密sm2验签,需和前端保持一致\n public-key: 041283c3cff7c97b1b2ce9bae5754a25878b2bd254ebf0613db364db740ef0cf459af9db50a4434d2f36a49cee43e3457a828bc9a7eee331673f1dd6a3fa2c8b88\n #${BLADE_OAUTH2_PUBLIC_KEY}\n #使用 @org.springblade.test.Sm2KeyGenerator 获取,用于国密sm2解密,前端无需配置\n private-key: 00e209e0f9ac35192f4afb8fa8139b4b7bb4c866ad993c0f65e80156ced56e7b4a\n # ${BLADE_OAUTH2_PRIVATE_KEY}\n #token配置\n token:\n #是否有状态\n state: false\n #是否单用户登录\n single: false\n #单用户登录范围\n single-level: all\n #token签名 使用blade-auth服务 @org.springblade.test.SignKeyGenerator 获取\n sign-key: 2PVirX37iWjxOQ00TrC5Q3fYuN8QWvD7 \n #${BLADE_TOKEN_SIGN_KEY}\n #token加密 使用blade-auth服务 @org.springblade.test.CryptoKeyGenerator 获取\n crypto-key: qd9cXfGFhFfB1L4rCQquVyhNHP0dUpRa\n #${BLADE_TOKEN_CRYPTO_KEY}\n #接口配置\n api:\n #报文加密配置\n crypto:\n #启用报文加密配置\n enabled: false\n #使用blade-auth服务 @org.springblade.test.CryptoKeyGenerator 获取,需和前端保持一致\n aes-key: 8BJBWkaeMoVsNwyIxZQPEItsBzYr9A1H\n #${BLADE_API_CRYPTO_AES_KEY}\n #使用blade-auth服务 @org.springblade.test.CryptoKeyGenerator 获取,需和前端保持一致\n des-key: I4Wy5fZVvtvLejxg\n #${BLADE_API_CRYPTO_DES_KEY}\n #jackson配置\n jackson:\n #null自动转空值\n null-to-empty: true\n #大数字自动转字符串\n big-num-to-string: true\n #支持text文本请求,与报文加密同时开启\n support-text-plain: false\n #redis序列化方式\n redis:\n serializer-type: protostuff\n #日志配置\n log:\n request:\n #开启控制台请求日志\n enabled: true\n #控制台请求日志忽略\n skip-url:\n - /notice/list\n - /wechat/**\n #开启错误日志入库\n error-log: true\n #xss配置\n xss:\n enabled: true\n skip-url:\n - /wechat\n - /qq\n #安全框架配置\n secure:\n #严格模式\n #缺失令牌字段则取消授权\n strict-token: true\n #缺失请求头则取消授权\n strict-header: true\n #接口放行\n skip-url:\n - /test/**\n #授权认证配置\n auth:\n - method: ALL\n pattern: /chat/wechat/**\n expression: \"hasAuth()\"\n - method: ALL\n pattern: /chat/qq/**\n expression: \"hasStrictToken()\"\n - method: ALL\n pattern: /chat/ding/**\n expression: \"hasStrictHeader()\"\n - method: ALL\n pattern: /dashboard/notice\n expression: \"hasMenu(\'notice\')\"\n - method: POST\n pattern: /dashboard/upload\n expression: \"hasTimeAuth(9, 17)\"\n - method: POST\n pattern: /dashboard/submit\n expression: \"hasAnyRole(\'administrator\', \'admin\', \'user\')\"\n #基础认证配置\n basic:\n - method: ALL\n pattern: /dashboard/info\n username: \"blade\"\n password: \"blade\"\n #动态签名认证配置\n sign:\n - method: ALL\n pattern: /dashboard/sign\n crypto: \"sha1\"\n #多终端认证配置\n client:\n - client-id: sword\n path-patterns:\n - /sword/**\n - client-id: saber\n path-patterns:\n - /saber/**\n #多租户配置\n tenant:\n #多租户增强\n enhance: true\n #多租户授权保护\n license: false\n #动态数据源功能\n dynamic-datasource: false\n #动态数据源全局扫描\n dynamic-global: false\n #多租户字段名\n column: tenant_id\n #排除多租户逻辑\n exclude-tables:\n - kd_user\n - kd_yfzd_type\n #分库分表配置\n sharding:\n enabled: false\n', 'f898d0c102d7360f1576452acf5a1ed6', '2025-06-05 06:20:32', '2025-07-02 07:42:42', NULL, '0:0:0:0:0:0:0:1', '', 'bc98aa53-bc32-4e17-bb82-605c8e95d336', '', '', '', 'yaml', '');
  46. INSERT INTO `config_info` VALUES (12, 'kd-dev.yaml', 'DEFAULT_GROUP', '#spring配置\nspring:\n data:\n redis:\n ##redis 单机环境配置\n host: 127.0.0.1\n port: 6379\n password: 123456\n database: 0\n ssl:\n enabled: false\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n druid:\n # MySql、PostgreSQL、SqlServer、DaMeng校验\n validation-query: select 1\n#项目模块集中配置\nkd:\n #分布式锁配置\n lock:\n enabled: false\n address: redis://127.0.0.1:6379\n #多团队协作服务配置\n loadbalancer:\n #开启配置\n enabled: true\n #负载均衡优先调用的ip段\n prior-ip-pattern:\n - 192.168.0.*\n - 127.0.0.1\n #通用开发生产环境数据库地址(特殊情况可在对应的子工程里配置覆盖)\n datasource:\n dev:\n # MySql\n url: jdbc:mysql://localhost:3306/kd_dev?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&tinyInt1isBit=false&allowMultiQueries=true&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true\n username: root\n password: 123456', '4f342e4c2a8f92153f21cb77cb623c57', '2025-06-05 06:20:56', '2025-06-09 03:35:13', NULL, '0:0:0:0:0:0:0:1', '', 'bc98aa53-bc32-4e17-bb82-605c8e95d336', '', '', '', 'yaml', '');
  47. -- ----------------------------
  48. -- Table structure for config_info_aggr
  49. -- ----------------------------
  50. DROP TABLE IF EXISTS `config_info_aggr`;
  51. CREATE TABLE `config_info_aggr` (
  52. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  53. `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  54. `group_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  55. `datum_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'datum_id',
  56. `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '内容',
  57. `gmt_modified` datetime NOT NULL COMMENT '修改时间',
  58. `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  59. `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租户字段',
  60. PRIMARY KEY (`id`) USING BTREE,
  61. UNIQUE INDEX `uk_configinfoaggr_datagrouptenantdatum`(`data_id`, `group_id`, `tenant_id`, `datum_id`) USING BTREE
  62. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '增加租户字段' ROW_FORMAT = DYNAMIC;
  63. -- ----------------------------
  64. -- Records of config_info_aggr
  65. -- ----------------------------
  66. -- ----------------------------
  67. -- Table structure for config_info_beta
  68. -- ----------------------------
  69. DROP TABLE IF EXISTS `config_info_beta`;
  70. CREATE TABLE `config_info_beta` (
  71. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  72. `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  73. `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  74. `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'app_name',
  75. `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
  76. `beta_ips` varchar(1024) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'betaIps',
  77. `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'md5',
  78. `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  79. `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  80. `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user',
  81. `src_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'source ip',
  82. `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租户字段',
  83. PRIMARY KEY (`id`) USING BTREE,
  84. UNIQUE INDEX `uk_configinfobeta_datagrouptenant`(`data_id`, `group_id`, `tenant_id`) USING BTREE
  85. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_info_beta' ROW_FORMAT = DYNAMIC;
  86. -- ----------------------------
  87. -- Records of config_info_beta
  88. -- ----------------------------
  89. -- ----------------------------
  90. -- Table structure for config_info_tag
  91. -- ----------------------------
  92. DROP TABLE IF EXISTS `config_info_tag`;
  93. CREATE TABLE `config_info_tag` (
  94. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  95. `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  96. `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  97. `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_id',
  98. `tag_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'tag_id',
  99. `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'app_name',
  100. `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'content',
  101. `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'md5',
  102. `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  103. `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  104. `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL COMMENT 'source user',
  105. `src_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'source ip',
  106. PRIMARY KEY (`id`) USING BTREE,
  107. UNIQUE INDEX `uk_configinfotag_datagrouptenanttag`(`data_id`, `group_id`, `tenant_id`, `tag_id`) USING BTREE
  108. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_info_tag' ROW_FORMAT = DYNAMIC;
  109. -- ----------------------------
  110. -- Records of config_info_tag
  111. -- ----------------------------
  112. -- ----------------------------
  113. -- Table structure for config_tags_relation
  114. -- ----------------------------
  115. DROP TABLE IF EXISTS `config_tags_relation`;
  116. CREATE TABLE `config_tags_relation` (
  117. `id` bigint(20) NOT NULL COMMENT 'id',
  118. `tag_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'tag_name',
  119. `tag_type` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'tag_type',
  120. `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'data_id',
  121. `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'group_id',
  122. `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_id',
  123. `nid` bigint(20) NOT NULL AUTO_INCREMENT,
  124. PRIMARY KEY (`nid`) USING BTREE,
  125. UNIQUE INDEX `uk_configtagrelation_configidtag`(`id`, `tag_name`, `tag_type`) USING BTREE,
  126. INDEX `idx_tenant_id`(`tenant_id`) USING BTREE
  127. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'config_tag_relation' ROW_FORMAT = DYNAMIC;
  128. -- ----------------------------
  129. -- Records of config_tags_relation
  130. -- ----------------------------
  131. -- ----------------------------
  132. -- Table structure for group_capacity
  133. -- ----------------------------
  134. DROP TABLE IF EXISTS `group_capacity`;
  135. CREATE TABLE `group_capacity` (
  136. `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  137. `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'Group ID,空字符表示整个集群',
  138. `quota` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '配额,0表示使用默认值',
  139. `usage` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '使用量',
  140. `max_size` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个配置大小上限,单位为字节,0表示使用默认值',
  141. `max_aggr_count` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '聚合子配置最大个数,,0表示使用默认值',
  142. `max_aggr_size` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个聚合数据的子配置大小上限,单位为字节,0表示使用默认值',
  143. `max_history_count` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最大变更历史数量',
  144. `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  145. `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  146. PRIMARY KEY (`id`) USING BTREE,
  147. UNIQUE INDEX `uk_group_id`(`group_id`) USING BTREE
  148. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '集群、各Group容量信息表' ROW_FORMAT = DYNAMIC;
  149. -- ----------------------------
  150. -- Records of group_capacity
  151. -- ----------------------------
  152. -- ----------------------------
  153. -- Table structure for his_config_info
  154. -- ----------------------------
  155. DROP TABLE IF EXISTS `his_config_info`;
  156. CREATE TABLE `his_config_info` (
  157. `id` bigint(64) UNSIGNED NOT NULL,
  158. `nid` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  159. `data_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  160. `group_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  161. `app_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'app_name',
  162. `content` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  163. `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  164. `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  165. `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  166. `src_user` text CHARACTER SET utf8 COLLATE utf8_bin NULL,
  167. `src_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  168. `op_type` char(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  169. `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租户字段',
  170. PRIMARY KEY (`nid`) USING BTREE,
  171. INDEX `idx_gmt_create`(`gmt_create`) USING BTREE,
  172. INDEX `idx_gmt_modified`(`gmt_modified`) USING BTREE,
  173. INDEX `idx_did`(`data_id`) USING BTREE
  174. ) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '多租户改造' ROW_FORMAT = DYNAMIC;
  175. -- ----------------------------
  176. -- Records of his_config_info
  177. -- ----------------------------
  178. INSERT INTO `his_config_info` VALUES (7, 12, 'blade.yaml', 'DEFAULT_GROUP', '', '#服务器配置\nserver:\n undertow:\n threads:\n # 设置IO线程数, 它主要执行非阻塞的任务,它们会负责多个连接, 默认设置每个CPU核心一个线程\n io: 16\n # 阻塞任务线程池, 当执行类似servlet请求阻塞操作, undertow会从这个线程池中取得线程,它的值设置取决于系统的负载\n worker: 400\n # 以下的配置会影响buffer,这些buffer会用于服务器连接的IO操作,有点类似netty的池化内存管理\n buffer-size: 1024\n # 是否分配的直接内存\n direct-buffers: true\n\n#spring配置\nspring:\n cloud:\n nacos:\n discovery:\n # 禁用云命名空间解析,防止和云平台环境变量冲突\n isUseCloudNamespaceParsing: false\n config:\n # 禁用云命名空间解析,防止和云平台环境变量冲突\n isUseCloudNamespaceParsing: false\n sentinel:\n eager: true\n devtools:\n restart:\n log-condition-evaluation-delta: false\n livereload:\n port: 23333\n\n#feign配置\nfeign:\n sentinel:\n enabled: true\n okhttp:\n enabled: true\n httpclient:\n enabled: false\n\n#对外暴露端口\nmanagement:\n endpoints:\n web:\n exposure:\n include: \"*\"\n endpoint:\n health:\n show-details: always\n\n#springdoc-openapi配置\nspringdoc:\n default-flat-param-object: true\n\n#knife4j配置\nknife4j:\n #基础认证\n basic:\n enable: false\n username: blade\n password: blade\n #增强配置\n setting:\n enableSwaggerModels: true\n enableDocumentManage: true\n enableHost: false\n enableHostText: http://localhost\n enableRequestCache: true\n enableFilterMultipartApis: false\n enableFilterMultipartApiMethodType: POST\n language: zh_cn\n enableFooter: false\n enableFooterCustom: true\n footerCustomContent: Copyright © 2025 BladeX All Rights Reserved\n\n#swagger公共信息\nswagger:\n title: BladeX 接口文档系统\n description: BladeX 接口文档系统\n version: 4.5.0.RELEASE\n license: Powered By BladeX\n license-url: https://bladex.cn\n terms-of-service-url: https://bladex.cn\n contact:\n name: 翼宿\n email: bladejava@qq.com\n url: https://gitee.com/smallc\n\n#blade配置\nblade:\n #oauth2配置\n oauth2:\n #启用 oauth2\n enabled: true\n #使用 @org.springblade.test.Sm2KeyGenerator 获取,用于国密sm2验签,需和前端保持一致\n public-key: 041283c3cff7c97b1b2ce9bae5754a25878b2bd254ebf0613db364db740ef0cf459af9db50a4434d2f36a49cee43e3457a828bc9a7eee331673f1dd6a3fa2c8b88\n #${BLADE_OAUTH2_PUBLIC_KEY}\n #使用 @org.springblade.test.Sm2KeyGenerator 获取,用于国密sm2解密,前端无需配置\n private-key: 00e209e0f9ac35192f4afb8fa8139b4b7bb4c866ad993c0f65e80156ced56e7b4a\n # ${BLADE_OAUTH2_PRIVATE_KEY}\n #token配置\n token:\n #是否有状态\n state: false\n #是否单用户登录\n single: false\n #单用户登录范围\n single-level: all\n #token签名 使用blade-auth服务 @org.springblade.test.SignKeyGenerator 获取\n sign-key: 2PVirX37iWjxOQ00TrC5Q3fYuN8QWvD7 \n #${BLADE_TOKEN_SIGN_KEY}\n #token加密 使用blade-auth服务 @org.springblade.test.CryptoKeyGenerator 获取\n crypto-key: qd9cXfGFhFfB1L4rCQquVyhNHP0dUpRa\n #${BLADE_TOKEN_CRYPTO_KEY}\n #接口配置\n api:\n #报文加密配置\n crypto:\n #启用报文加密配置\n enabled: false\n #使用blade-auth服务 @org.springblade.test.CryptoKeyGenerator 获取,需和前端保持一致\n aes-key: 8BJBWkaeMoVsNwyIxZQPEItsBzYr9A1H\n #${BLADE_API_CRYPTO_AES_KEY}\n #使用blade-auth服务 @org.springblade.test.CryptoKeyGenerator 获取,需和前端保持一致\n des-key: I4Wy5fZVvtvLejxg\n #${BLADE_API_CRYPTO_DES_KEY}\n #jackson配置\n jackson:\n #null自动转空值\n null-to-empty: true\n #大数字自动转字符串\n big-num-to-string: true\n #支持text文本请求,与报文加密同时开启\n support-text-plain: false\n #redis序列化方式\n redis:\n serializer-type: protostuff\n #日志配置\n log:\n request:\n #开启控制台请求日志\n enabled: true\n #控制台请求日志忽略\n skip-url:\n - /notice/list\n - /wechat/**\n #开启错误日志入库\n error-log: true\n #xss配置\n xss:\n enabled: true\n skip-url:\n - /wechat\n - /qq\n #安全框架配置\n secure:\n #严格模式\n #缺失令牌字段则取消授权\n strict-token: true\n #缺失请求头则取消授权\n strict-header: true\n #接口放行\n skip-url:\n - /test/**\n #授权认证配置\n auth:\n - method: ALL\n pattern: /chat/wechat/**\n expression: \"hasAuth()\"\n - method: ALL\n pattern: /chat/qq/**\n expression: \"hasStrictToken()\"\n - method: ALL\n pattern: /chat/ding/**\n expression: \"hasStrictHeader()\"\n - method: ALL\n pattern: /dashboard/notice\n expression: \"hasMenu(\'notice\')\"\n - method: POST\n pattern: /dashboard/upload\n expression: \"hasTimeAuth(9, 17)\"\n - method: POST\n pattern: /dashboard/submit\n expression: \"hasAnyRole(\'administrator\', \'admin\', \'user\')\"\n #基础认证配置\n basic:\n - method: ALL\n pattern: /dashboard/info\n username: \"blade\"\n password: \"blade\"\n #动态签名认证配置\n sign:\n - method: ALL\n pattern: /dashboard/sign\n crypto: \"sha1\"\n #多终端认证配置\n client:\n - client-id: sword\n path-patterns:\n - /sword/**\n - client-id: saber\n path-patterns:\n - /saber/**\n #多租户配置\n tenant:\n #多租户增强\n enhance: true\n #多租户授权保护\n license: false\n #动态数据源功能\n dynamic-datasource: false\n #动态数据源全局扫描\n dynamic-global: false\n #多租户字段名\n column: tenant_id\n #排除多租户逻辑\n exclude-tables:\n - blade_user\n #分库分表配置\n sharding:\n enabled: false\n', '3fa4f01ba68dc734d3b9e0c0b698f32d', '2025-06-05 14:19:53', '2025-06-05 06:19:53', NULL, '0:0:0:0:0:0:0:1', 'U', 'bc98aa53-bc32-4e17-bb82-605c8e95d336');
  179. INSERT INTO `his_config_info` VALUES (0, 13, 'kd.yaml', 'DEFAULT_GROUP', '', '#服务器配置\r\nserver:\r\n undertow:\r\n threads:\r\n # 设置IO线程数, 它主要执行非阻塞的任务,它们会负责多个连接, 默认设置每个CPU核心一个线程\r\n io: 16\r\n # 阻塞任务线程池, 当执行类似servlet请求阻塞操作, undertow会从这个线程池中取得线程,它的值设置取决于系统的负载\r\n worker: 400\r\n # 以下的配置会影响buffer,这些buffer会用于服务器连接的IO操作,有点类似netty的池化内存管理\r\n buffer-size: 1024\r\n # 是否分配的直接内存\r\n direct-buffers: true\r\n\r\n#spring配置\r\nspring:\r\n cloud:\r\n nacos:\r\n discovery:\r\n # 禁用云命名空间解析,防止和云平台环境变量冲突\r\n isUseCloudNamespaceParsing: false\r\n config:\r\n # 禁用云命名空间解析,防止和云平台环境变量冲突\r\n isUseCloudNamespaceParsing: false\r\n sentinel:\r\n eager: true\r\n devtools:\r\n restart:\r\n log-condition-evaluation-delta: false\r\n livereload:\r\n port: 23333\r\n\r\n#feign配置\r\nfeign:\r\n sentinel:\r\n enabled: true\r\n okhttp:\r\n enabled: true\r\n httpclient:\r\n enabled: false\r\n\r\n#对外暴露端口\r\nmanagement:\r\n endpoints:\r\n web:\r\n exposure:\r\n include: \"*\"\r\n endpoint:\r\n health:\r\n show-details: always\r\n\r\n#springdoc-openapi配置\r\nspringdoc:\r\n default-flat-param-object: true\r\n\r\n#knife4j配置\r\nknife4j:\r\n #基础认证\r\n basic:\r\n enable: false\r\n username: blade\r\n password: blade\r\n #增强配置\r\n setting:\r\n enableSwaggerModels: true\r\n enableDocumentManage: true\r\n enableHost: false\r\n enableHostText: http://localhost\r\n enableRequestCache: true\r\n enableFilterMultipartApis: false\r\n enableFilterMultipartApiMethodType: POST\r\n language: zh_cn\r\n enableFooter: false\r\n enableFooterCustom: true\r\n footerCustomContent: Copyright © 2025 BladeX All Rights Reserved\r\n\r\n#swagger公共信息\r\nswagger:\r\n title: BladeX 接口文档系统\r\n description: BladeX 接口文档系统\r\n version: 4.5.0.RELEASE\r\n license: Powered By BladeX\r\n license-url: https://bladex.cn\r\n terms-of-service-url: https://bladex.cn\r\n contact:\r\n name: 翼宿\r\n email: bladejava@qq.com\r\n url: https://gitee.com/smallc\r\n\r\n#blade配置\r\nkd:\r\n #oauth2配置\r\n oauth2:\r\n #启用 oauth2\r\n enabled: true\r\n #使用 @org.springblade.test.Sm2KeyGenerator 获取,用于国密sm2验签,需和前端保持一致\r\n public-key: 041283c3cff7c97b1b2ce9bae5754a25878b2bd254ebf0613db364db740ef0cf459af9db50a4434d2f36a49cee43e3457a828bc9a7eee331673f1dd6a3fa2c8b88\r\n #${BLADE_OAUTH2_PUBLIC_KEY}\r\n #使用 @org.springblade.test.Sm2KeyGenerator 获取,用于国密sm2解密,前端无需配置\r\n private-key: 00e209e0f9ac35192f4afb8fa8139b4b7bb4c866ad993c0f65e80156ced56e7b4a\r\n # ${BLADE_OAUTH2_PRIVATE_KEY}\r\n #token配置\r\n token:\r\n #是否有状态\r\n state: false\r\n #是否单用户登录\r\n single: false\r\n #单用户登录范围\r\n single-level: all\r\n #token签名 使用blade-auth服务 @org.springblade.test.SignKeyGenerator 获取\r\n sign-key: 2PVirX37iWjxOQ00TrC5Q3fYuN8QWvD7 \r\n #${BLADE_TOKEN_SIGN_KEY}\r\n #token加密 使用blade-auth服务 @org.springblade.test.CryptoKeyGenerator 获取\r\n crypto-key: qd9cXfGFhFfB1L4rCQquVyhNHP0dUpRa\r\n #${BLADE_TOKEN_CRYPTO_KEY}\r\n #接口配置\r\n api:\r\n #报文加密配置\r\n crypto:\r\n #启用报文加密配置\r\n enabled: false\r\n #使用blade-auth服务 @org.springblade.test.CryptoKeyGenerator 获取,需和前端保持一致\r\n aes-key: 8BJBWkaeMoVsNwyIxZQPEItsBzYr9A1H\r\n #${BLADE_API_CRYPTO_AES_KEY}\r\n #使用blade-auth服务 @org.springblade.test.CryptoKeyGenerator 获取,需和前端保持一致\r\n des-key: I4Wy5fZVvtvLejxg\r\n #${BLADE_API_CRYPTO_DES_KEY}\r\n #jackson配置\r\n jackson:\r\n #null自动转空值\r\n null-to-empty: true\r\n #大数字自动转字符串\r\n big-num-to-string: true\r\n #支持text文本请求,与报文加密同时开启\r\n support-text-plain: false\r\n #redis序列化方式\r\n redis:\r\n serializer-type: protostuff\r\n #日志配置\r\n log:\r\n request:\r\n #开启控制台请求日志\r\n enabled: true\r\n #控制台请求日志忽略\r\n skip-url:\r\n - /notice/list\r\n - /wechat/**\r\n #开启错误日志入库\r\n error-log: true\r\n #xss配置\r\n xss:\r\n enabled: true\r\n skip-url:\r\n - /wechat\r\n - /qq\r\n #安全框架配置\r\n secure:\r\n #严格模式\r\n #缺失令牌字段则取消授权\r\n strict-token: true\r\n #缺失请求头则取消授权\r\n strict-header: true\r\n #接口放行\r\n skip-url:\r\n - /test/**\r\n #授权认证配置\r\n auth:\r\n - method: ALL\r\n pattern: /chat/wechat/**\r\n expression: \"hasAuth()\"\r\n - method: ALL\r\n pattern: /chat/qq/**\r\n expression: \"hasStrictToken()\"\r\n - method: ALL\r\n pattern: /chat/ding/**\r\n expression: \"hasStrictHeader()\"\r\n - method: ALL\r\n pattern: /dashboard/notice\r\n expression: \"hasMenu(\'notice\')\"\r\n - method: POST\r\n pattern: /dashboard/upload\r\n expression: \"hasTimeAuth(9, 17)\"\r\n - method: POST\r\n pattern: /dashboard/submit\r\n expression: \"hasAnyRole(\'administrator\', \'admin\', \'user\')\"\r\n #基础认证配置\r\n basic:\r\n - method: ALL\r\n pattern: /dashboard/info\r\n username: \"blade\"\r\n password: \"blade\"\r\n #动态签名认证配置\r\n sign:\r\n - method: ALL\r\n pattern: /dashboard/sign\r\n crypto: \"sha1\"\r\n #多终端认证配置\r\n client:\r\n - client-id: sword\r\n path-patterns:\r\n - /sword/**\r\n - client-id: saber\r\n path-patterns:\r\n - /saber/**\r\n #多租户配置\r\n tenant:\r\n #多租户增强\r\n enhance: true\r\n #多租户授权保护\r\n license: false\r\n #动态数据源功能\r\n dynamic-datasource: false\r\n #动态数据源全局扫描\r\n dynamic-global: false\r\n #多租户字段名\r\n column: tenant_id\r\n #排除多租户逻辑\r\n exclude-tables:\r\n - blade_user\r\n #分库分表配置\r\n sharding:\r\n enabled: false\r\n', '884963a403421b0023b633968557b160', '2025-06-05 14:20:31', '2025-06-05 06:20:32', NULL, '0:0:0:0:0:0:0:1', 'I', 'bc98aa53-bc32-4e17-bb82-605c8e95d336');
  180. INSERT INTO `his_config_info` VALUES (0, 14, 'kd-dev.yaml', 'DEFAULT_GROUP', '', 'a', '0cc175b9c0f1b6a831c399e269772661', '2025-06-05 14:20:56', '2025-06-05 06:20:56', NULL, '0:0:0:0:0:0:0:1', 'I', 'bc98aa53-bc32-4e17-bb82-605c8e95d336');
  181. INSERT INTO `his_config_info` VALUES (12, 15, 'kd-dev.yaml', 'DEFAULT_GROUP', '', 'a', '0cc175b9c0f1b6a831c399e269772661', '2025-06-05 14:21:15', '2025-06-05 06:21:15', NULL, '0:0:0:0:0:0:0:1', 'U', 'bc98aa53-bc32-4e17-bb82-605c8e95d336');
  182. INSERT INTO `his_config_info` VALUES (7, 16, 'blade.yaml', 'DEFAULT_GROUP', '', '#服务器配置\nserver:\n undertow:\n threads:\n # 设置IO线程数, 它主要执行非阻塞的任务,它们会负责多个连接, 默认设置每个CPU核心一个线程\n io: 16\n # 阻塞任务线程池, 当执行类似servlet请求阻塞操作, undertow会从这个线程池中取得线程,它的值设置取决于系统的负载\n worker: 400\n # 以下的配置会影响buffer,这些buffer会用于服务器连接的IO操作,有点类似netty的池化内存管理\n buffer-size: 1024\n # 是否分配的直接内存\n direct-buffers: true\n\n#spring配置\nspring:\n cloud:\n nacos:\n discovery:\n # 禁用云命名空间解析,防止和云平台环境变量冲突\n isUseCloudNamespaceParsing: false\n config:\n # 禁用云命名空间解析,防止和云平台环境变量冲突\n isUseCloudNamespaceParsing: false\n sentinel:\n eager: true\n devtools:\n restart:\n log-condition-evaluation-delta: false\n livereload:\n port: 23333\n\n#feign配置\nfeign:\n sentinel:\n enabled: true\n okhttp:\n enabled: true\n httpclient:\n enabled: false\n\n#对外暴露端口\nmanagement:\n endpoints:\n web:\n exposure:\n include: \"*\"\n endpoint:\n health:\n show-details: always\n\n#springdoc-openapi配置\nspringdoc:\n default-flat-param-object: true\n\n#knife4j配置\nknife4j:\n #基础认证\n basic:\n enable: false\n username: blade\n password: blade\n #增强配置\n setting:\n enableSwaggerModels: true\n enableDocumentManage: true\n enableHost: false\n enableHostText: http://localhost\n enableRequestCache: true\n enableFilterMultipartApis: false\n enableFilterMultipartApiMethodType: POST\n language: zh_cn\n enableFooter: false\n enableFooterCustom: true\n footerCustomContent: Copyright © 2025 BladeX All Rights Reserved\n\n#swagger公共信息\nswagger:\n title: BladeX 接口文档系统\n description: BladeX 接口文档系统\n version: 4.5.0.RELEASE\n license: Powered By BladeX\n license-url: https://bladex.cn\n terms-of-service-url: https://bladex.cn\n contact:\n name: 翼宿\n email: bladejava@qq.com\n url: https://gitee.com/smallc\n\n#blade配置\nkd:\n #oauth2配置\n oauth2:\n #启用 oauth2\n enabled: true\n #使用 @org.springblade.test.Sm2KeyGenerator 获取,用于国密sm2验签,需和前端保持一致\n public-key: 041283c3cff7c97b1b2ce9bae5754a25878b2bd254ebf0613db364db740ef0cf459af9db50a4434d2f36a49cee43e3457a828bc9a7eee331673f1dd6a3fa2c8b88\n #${BLADE_OAUTH2_PUBLIC_KEY}\n #使用 @org.springblade.test.Sm2KeyGenerator 获取,用于国密sm2解密,前端无需配置\n private-key: 00e209e0f9ac35192f4afb8fa8139b4b7bb4c866ad993c0f65e80156ced56e7b4a\n # ${BLADE_OAUTH2_PRIVATE_KEY}\n #token配置\n token:\n #是否有状态\n state: false\n #是否单用户登录\n single: false\n #单用户登录范围\n single-level: all\n #token签名 使用blade-auth服务 @org.springblade.test.SignKeyGenerator 获取\n sign-key: 2PVirX37iWjxOQ00TrC5Q3fYuN8QWvD7 \n #${BLADE_TOKEN_SIGN_KEY}\n #token加密 使用blade-auth服务 @org.springblade.test.CryptoKeyGenerator 获取\n crypto-key: qd9cXfGFhFfB1L4rCQquVyhNHP0dUpRa\n #${BLADE_TOKEN_CRYPTO_KEY}\n #接口配置\n api:\n #报文加密配置\n crypto:\n #启用报文加密配置\n enabled: false\n #使用blade-auth服务 @org.springblade.test.CryptoKeyGenerator 获取,需和前端保持一致\n aes-key: 8BJBWkaeMoVsNwyIxZQPEItsBzYr9A1H\n #${BLADE_API_CRYPTO_AES_KEY}\n #使用blade-auth服务 @org.springblade.test.CryptoKeyGenerator 获取,需和前端保持一致\n des-key: I4Wy5fZVvtvLejxg\n #${BLADE_API_CRYPTO_DES_KEY}\n #jackson配置\n jackson:\n #null自动转空值\n null-to-empty: true\n #大数字自动转字符串\n big-num-to-string: true\n #支持text文本请求,与报文加密同时开启\n support-text-plain: false\n #redis序列化方式\n redis:\n serializer-type: protostuff\n #日志配置\n log:\n request:\n #开启控制台请求日志\n enabled: true\n #控制台请求日志忽略\n skip-url:\n - /notice/list\n - /wechat/**\n #开启错误日志入库\n error-log: true\n #xss配置\n xss:\n enabled: true\n skip-url:\n - /wechat\n - /qq\n #安全框架配置\n secure:\n #严格模式\n #缺失令牌字段则取消授权\n strict-token: true\n #缺失请求头则取消授权\n strict-header: true\n #接口放行\n skip-url:\n - /test/**\n #授权认证配置\n auth:\n - method: ALL\n pattern: /chat/wechat/**\n expression: \"hasAuth()\"\n - method: ALL\n pattern: /chat/qq/**\n expression: \"hasStrictToken()\"\n - method: ALL\n pattern: /chat/ding/**\n expression: \"hasStrictHeader()\"\n - method: ALL\n pattern: /dashboard/notice\n expression: \"hasMenu(\'notice\')\"\n - method: POST\n pattern: /dashboard/upload\n expression: \"hasTimeAuth(9, 17)\"\n - method: POST\n pattern: /dashboard/submit\n expression: \"hasAnyRole(\'administrator\', \'admin\', \'user\')\"\n #基础认证配置\n basic:\n - method: ALL\n pattern: /dashboard/info\n username: \"blade\"\n password: \"blade\"\n #动态签名认证配置\n sign:\n - method: ALL\n pattern: /dashboard/sign\n crypto: \"sha1\"\n #多终端认证配置\n client:\n - client-id: sword\n path-patterns:\n - /sword/**\n - client-id: saber\n path-patterns:\n - /saber/**\n #多租户配置\n tenant:\n #多租户增强\n enhance: true\n #多租户授权保护\n license: false\n #动态数据源功能\n dynamic-datasource: false\n #动态数据源全局扫描\n dynamic-global: false\n #多租户字段名\n column: tenant_id\n #排除多租户逻辑\n exclude-tables:\n - blade_user\n #分库分表配置\n sharding:\n enabled: false\n', 'ccdc3a4a2dda0f024c4cc5f9c17cad01', '2025-06-05 15:00:56', '2025-06-05 07:00:56', NULL, '0:0:0:0:0:0:0:1', 'D', 'bc98aa53-bc32-4e17-bb82-605c8e95d336');
  183. INSERT INTO `his_config_info` VALUES (9, 17, 'blade-dev.yaml', 'DEFAULT_GROUP', '', '#spring配置\nspring:\n data:\n redis:\n ##redis 单机环境配置\n host: 127.0.0.1\n port: 6379\n password: 123456\n database: 0\n ssl:\n enabled: false\n ##redis 集群环境配置\n #cluster:\n # nodes: 127.0.0.1:7001,127.0.0.1:7002,127.0.0.1:7003\n # commandTimeout: 5000\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n #driver-class-name: org.postgresql.Driver\n #driver-class-name: oracle.jdbc.OracleDriver\n #driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver\n #driver-class-name: dm.jdbc.driver.DmDriver\n #driver-class-name: com.yashandb.jdbc.Driver\n druid:\n # MySql、PostgreSQL、SqlServer、DaMeng校验\n validation-query: select 1\n # Oracle、YashanDB校验\n #oracle: true\n #validation-query: select 1 from dual\n\n#项目模块集中配置\nkd:\n #分布式锁配置\n lock:\n enabled: false\n address: redis://127.0.0.1:6379\n #多团队协作服务配置\n loadbalancer:\n #开启配置\n enabled: true\n #负载均衡优先调用的ip段\n prior-ip-pattern:\n - 192.168.0.*\n - 127.0.0.1\n #通用开发生产环境数据库地址(特殊情况可在对应的子工程里配置覆盖)\n datasource:\n dev:\n # MySql\n url: jdbc:mysql://localhost:3306/bladex?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&tinyInt1isBit=false&allowMultiQueries=true&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true\n username: root\n password: 123456\n # PostgreSQL\n #url: jdbc:postgresql://127.0.0.1:5432/bladex\n #username: postgres\n #password: 123456\n # Oracle\n #url: jdbc:oracle:thin:@127.0.0.1:1521:orcl\n #username: BLADEX\n #password: BLADEX\n # SqlServer\n #url: jdbc:sqlserver://127.0.0.1:1433;DatabaseName=bladex\n #username: bladex\n #password: bladex\n # DaMeng\n #url: jdbc:dm://127.0.0.1:5236/BLADEX?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8\n #username: BLADEX\n #password: BLADEX\n # YashanDB\n #url: jdbc:yasdb://127.0.0.1:1688/BLADEX\n #username: BLADEX\n #password: BLADEX\n', '0d39ab508052f19aac441f8755ea8a99', '2025-06-05 15:01:03', '2025-06-05 07:01:04', NULL, '0:0:0:0:0:0:0:1', 'D', 'bc98aa53-bc32-4e17-bb82-605c8e95d336');
  184. INSERT INTO `his_config_info` VALUES (11, 18, 'kd.yaml', 'DEFAULT_GROUP', '', '#服务器配置\r\nserver:\r\n undertow:\r\n threads:\r\n # 设置IO线程数, 它主要执行非阻塞的任务,它们会负责多个连接, 默认设置每个CPU核心一个线程\r\n io: 16\r\n # 阻塞任务线程池, 当执行类似servlet请求阻塞操作, undertow会从这个线程池中取得线程,它的值设置取决于系统的负载\r\n worker: 400\r\n # 以下的配置会影响buffer,这些buffer会用于服务器连接的IO操作,有点类似netty的池化内存管理\r\n buffer-size: 1024\r\n # 是否分配的直接内存\r\n direct-buffers: true\r\n\r\n#spring配置\r\nspring:\r\n cloud:\r\n nacos:\r\n discovery:\r\n # 禁用云命名空间解析,防止和云平台环境变量冲突\r\n isUseCloudNamespaceParsing: false\r\n config:\r\n # 禁用云命名空间解析,防止和云平台环境变量冲突\r\n isUseCloudNamespaceParsing: false\r\n sentinel:\r\n eager: true\r\n devtools:\r\n restart:\r\n log-condition-evaluation-delta: false\r\n livereload:\r\n port: 23333\r\n\r\n#feign配置\r\nfeign:\r\n sentinel:\r\n enabled: true\r\n okhttp:\r\n enabled: true\r\n httpclient:\r\n enabled: false\r\n\r\n#对外暴露端口\r\nmanagement:\r\n endpoints:\r\n web:\r\n exposure:\r\n include: \"*\"\r\n endpoint:\r\n health:\r\n show-details: always\r\n\r\n#springdoc-openapi配置\r\nspringdoc:\r\n default-flat-param-object: true\r\n\r\n#knife4j配置\r\nknife4j:\r\n #基础认证\r\n basic:\r\n enable: false\r\n username: blade\r\n password: blade\r\n #增强配置\r\n setting:\r\n enableSwaggerModels: true\r\n enableDocumentManage: true\r\n enableHost: false\r\n enableHostText: http://localhost\r\n enableRequestCache: true\r\n enableFilterMultipartApis: false\r\n enableFilterMultipartApiMethodType: POST\r\n language: zh_cn\r\n enableFooter: false\r\n enableFooterCustom: true\r\n footerCustomContent: Copyright © 2025 BladeX All Rights Reserved\r\n\r\n#swagger公共信息\r\nswagger:\r\n title: BladeX 接口文档系统\r\n description: BladeX 接口文档系统\r\n version: 4.5.0.RELEASE\r\n license: Powered By BladeX\r\n license-url: https://bladex.cn\r\n terms-of-service-url: https://bladex.cn\r\n contact:\r\n name: 翼宿\r\n email: bladejava@qq.com\r\n url: https://gitee.com/smallc\r\n\r\n#blade配置\r\nkd:\r\n #oauth2配置\r\n oauth2:\r\n #启用 oauth2\r\n enabled: true\r\n #使用 @org.springblade.test.Sm2KeyGenerator 获取,用于国密sm2验签,需和前端保持一致\r\n public-key: 041283c3cff7c97b1b2ce9bae5754a25878b2bd254ebf0613db364db740ef0cf459af9db50a4434d2f36a49cee43e3457a828bc9a7eee331673f1dd6a3fa2c8b88\r\n #${BLADE_OAUTH2_PUBLIC_KEY}\r\n #使用 @org.springblade.test.Sm2KeyGenerator 获取,用于国密sm2解密,前端无需配置\r\n private-key: 00e209e0f9ac35192f4afb8fa8139b4b7bb4c866ad993c0f65e80156ced56e7b4a\r\n # ${BLADE_OAUTH2_PRIVATE_KEY}\r\n #token配置\r\n token:\r\n #是否有状态\r\n state: false\r\n #是否单用户登录\r\n single: false\r\n #单用户登录范围\r\n single-level: all\r\n #token签名 使用blade-auth服务 @org.springblade.test.SignKeyGenerator 获取\r\n sign-key: 2PVirX37iWjxOQ00TrC5Q3fYuN8QWvD7 \r\n #${BLADE_TOKEN_SIGN_KEY}\r\n #token加密 使用blade-auth服务 @org.springblade.test.CryptoKeyGenerator 获取\r\n crypto-key: qd9cXfGFhFfB1L4rCQquVyhNHP0dUpRa\r\n #${BLADE_TOKEN_CRYPTO_KEY}\r\n #接口配置\r\n api:\r\n #报文加密配置\r\n crypto:\r\n #启用报文加密配置\r\n enabled: false\r\n #使用blade-auth服务 @org.springblade.test.CryptoKeyGenerator 获取,需和前端保持一致\r\n aes-key: 8BJBWkaeMoVsNwyIxZQPEItsBzYr9A1H\r\n #${BLADE_API_CRYPTO_AES_KEY}\r\n #使用blade-auth服务 @org.springblade.test.CryptoKeyGenerator 获取,需和前端保持一致\r\n des-key: I4Wy5fZVvtvLejxg\r\n #${BLADE_API_CRYPTO_DES_KEY}\r\n #jackson配置\r\n jackson:\r\n #null自动转空值\r\n null-to-empty: true\r\n #大数字自动转字符串\r\n big-num-to-string: true\r\n #支持text文本请求,与报文加密同时开启\r\n support-text-plain: false\r\n #redis序列化方式\r\n redis:\r\n serializer-type: protostuff\r\n #日志配置\r\n log:\r\n request:\r\n #开启控制台请求日志\r\n enabled: true\r\n #控制台请求日志忽略\r\n skip-url:\r\n - /notice/list\r\n - /wechat/**\r\n #开启错误日志入库\r\n error-log: true\r\n #xss配置\r\n xss:\r\n enabled: true\r\n skip-url:\r\n - /wechat\r\n - /qq\r\n #安全框架配置\r\n secure:\r\n #严格模式\r\n #缺失令牌字段则取消授权\r\n strict-token: true\r\n #缺失请求头则取消授权\r\n strict-header: true\r\n #接口放行\r\n skip-url:\r\n - /test/**\r\n #授权认证配置\r\n auth:\r\n - method: ALL\r\n pattern: /chat/wechat/**\r\n expression: \"hasAuth()\"\r\n - method: ALL\r\n pattern: /chat/qq/**\r\n expression: \"hasStrictToken()\"\r\n - method: ALL\r\n pattern: /chat/ding/**\r\n expression: \"hasStrictHeader()\"\r\n - method: ALL\r\n pattern: /dashboard/notice\r\n expression: \"hasMenu(\'notice\')\"\r\n - method: POST\r\n pattern: /dashboard/upload\r\n expression: \"hasTimeAuth(9, 17)\"\r\n - method: POST\r\n pattern: /dashboard/submit\r\n expression: \"hasAnyRole(\'administrator\', \'admin\', \'user\')\"\r\n #基础认证配置\r\n basic:\r\n - method: ALL\r\n pattern: /dashboard/info\r\n username: \"blade\"\r\n password: \"blade\"\r\n #动态签名认证配置\r\n sign:\r\n - method: ALL\r\n pattern: /dashboard/sign\r\n crypto: \"sha1\"\r\n #多终端认证配置\r\n client:\r\n - client-id: sword\r\n path-patterns:\r\n - /sword/**\r\n - client-id: saber\r\n path-patterns:\r\n - /saber/**\r\n #多租户配置\r\n tenant:\r\n #多租户增强\r\n enhance: true\r\n #多租户授权保护\r\n license: false\r\n #动态数据源功能\r\n dynamic-datasource: false\r\n #动态数据源全局扫描\r\n dynamic-global: false\r\n #多租户字段名\r\n column: tenant_id\r\n #排除多租户逻辑\r\n exclude-tables:\r\n - blade_user\r\n #分库分表配置\r\n sharding:\r\n enabled: false\r\n', '884963a403421b0023b633968557b160', '2025-06-05 15:02:21', '2025-06-05 07:02:22', NULL, '0:0:0:0:0:0:0:1', 'U', 'bc98aa53-bc32-4e17-bb82-605c8e95d336');
  185. INSERT INTO `his_config_info` VALUES (12, 19, 'kd-dev.yaml', 'DEFAULT_GROUP', '', '#spring配置\nspring:\n data:\n redis:\n ##redis 单机环境配置\n host: 127.0.0.1\n port: 6379\n password: 123456\n database: 0\n ssl:\n enabled: false\n ##redis 集群环境配置\n #cluster:\n # nodes: 127.0.0.1:7001,127.0.0.1:7002,127.0.0.1:7003\n # commandTimeout: 5000\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n #driver-class-name: org.postgresql.Driver\n #driver-class-name: oracle.jdbc.OracleDriver\n #driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver\n #driver-class-name: dm.jdbc.driver.DmDriver\n #driver-class-name: com.yashandb.jdbc.Driver\n druid:\n # MySql、PostgreSQL、SqlServer、DaMeng校验\n validation-query: select 1\n # Oracle、YashanDB校验\n #oracle: true\n #validation-query: select 1 from dual\n\n#项目模块集中配置\nkd:\n #分布式锁配置\n lock:\n enabled: false\n address: redis://127.0.0.1:6379\n #多团队协作服务配置\n loadbalancer:\n #开启配置\n enabled: true\n #负载均衡优先调用的ip段\n prior-ip-pattern:\n - 192.168.0.*\n - 127.0.0.1\n #通用开发生产环境数据库地址(特殊情况可在对应的子工程里配置覆盖)\n datasource:\n dev:\n # MySql\n url: jdbc:mysql://localhost:3306/bladex?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&tinyInt1isBit=false&allowMultiQueries=true&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true\n username: root\n password: 123456\n # PostgreSQL\n #url: jdbc:postgresql://127.0.0.1:5432/bladex\n #username: postgres\n #password: 123456\n # Oracle\n #url: jdbc:oracle:thin:@127.0.0.1:1521:orcl\n #username: BLADEX\n #password: BLADEX\n # SqlServer\n #url: jdbc:sqlserver://127.0.0.1:1433;DatabaseName=bladex\n #username: bladex\n #password: bladex\n # DaMeng\n #url: jdbc:dm://127.0.0.1:5236/BLADEX?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8\n #username: BLADEX\n #password: BLADEX\n # YashanDB\n #url: jdbc:yasdb://127.0.0.1:1688/BLADEX\n #username: BLADEX\n #password: BLADEX\n', '0d39ab508052f19aac441f8755ea8a99', '2025-06-09 11:31:29', '2025-06-09 03:31:29', NULL, '0:0:0:0:0:0:0:1', 'U', 'bc98aa53-bc32-4e17-bb82-605c8e95d336');
  186. INSERT INTO `his_config_info` VALUES (12, 20, 'kd-dev.yaml', 'DEFAULT_GROUP', '', '#spring配置\nspring:\n data:\n redis:\n ##redis 单机环境配置\n host: 127.0.0.1\n port: 6379\n password: 123456\n database: 0\n ssl:\n enabled: false\n ##redis 集群环境配置\n #cluster:\n # nodes: 127.0.0.1:7001,127.0.0.1:7002,127.0.0.1:7003\n # commandTimeout: 5000\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n #driver-class-name: org.postgresql.Driver\n #driver-class-name: oracle.jdbc.OracleDriver\n #driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver\n #driver-class-name: dm.jdbc.driver.DmDriver\n #driver-class-name: com.yashandb.jdbc.Driver\n druid:\n # MySql、PostgreSQL、SqlServer、DaMeng校验\n validation-query: select 1\n # Oracle、YashanDB校验\n #oracle: true\n #validation-query: select 1 from dual\n\n#项目模块集中配置\nkd:\n #分布式锁配置\n lock:\n enabled: false\n address: redis://127.0.0.1:6379\n #多团队协作服务配置\n loadbalancer:\n #开启配置\n enabled: true\n #负载均衡优先调用的ip段\n prior-ip-pattern:\n - 192.168.0.*\n - 127.0.0.1\n #通用开发生产环境数据库地址(特殊情况可在对应的子工程里配置覆盖)\n datasource:\n dev:\n # MySql\n url: jdbc:mysql://localhost:3306/kd_dev?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&tinyInt1isBit=false&allowMultiQueries=true&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true\n username: root\n password: 123456\n', '97f21b8bff3b04ee67ebf959ac3d022f', '2025-06-09 11:35:12', '2025-06-09 03:35:13', NULL, '0:0:0:0:0:0:0:1', 'U', 'bc98aa53-bc32-4e17-bb82-605c8e95d336');
  187. INSERT INTO `his_config_info` VALUES (11, 21, 'kd.yaml', 'DEFAULT_GROUP', '', '#服务器配置\nserver:\n undertow:\n threads:\n # 设置IO线程数, 它主要执行非阻塞的任务,它们会负责多个连接, 默认设置每个CPU核心一个线程\n io: 16\n # 阻塞任务线程池, 当执行类似servlet请求阻塞操作, undertow会从这个线程池中取得线程,它的值设置取决于系统的负载\n worker: 400\n # 以下的配置会影响buffer,这些buffer会用于服务器连接的IO操作,有点类似netty的池化内存管理\n buffer-size: 1024\n # 是否分配的直接内存\n direct-buffers: true\n\n#spring配置\nspring:\n cloud:\n nacos:\n discovery:\n # 禁用云命名空间解析,防止和云平台环境变量冲突\n isUseCloudNamespaceParsing: false\n config:\n # 禁用云命名空间解析,防止和云平台环境变量冲突\n isUseCloudNamespaceParsing: false\n sentinel:\n eager: true\n devtools:\n restart:\n log-condition-evaluation-delta: false\n livereload:\n port: 23333\n\n#feign配置\nfeign:\n sentinel:\n enabled: true\n okhttp:\n enabled: true\n httpclient:\n enabled: false\n\n#对外暴露端口\nmanagement:\n endpoints:\n web:\n exposure:\n include: \"*\"\n endpoint:\n health:\n show-details: always\n\n#springdoc-openapi配置\nspringdoc:\n default-flat-param-object: true\n\n#knife4j配置\nknife4j:\n #基础认证\n basic:\n enable: false\n username: blade\n password: blade\n #增强配置\n setting:\n enableSwaggerModels: true\n enableDocumentManage: true\n enableHost: false\n enableHostText: http://localhost\n enableRequestCache: true\n enableFilterMultipartApis: false\n enableFilterMultipartApiMethodType: POST\n language: zh_cn\n enableFooter: false\n enableFooterCustom: true\n footerCustomContent: Copyright © 2025 BladeX All Rights Reserved\n\n#swagger公共信息\nswagger:\n title: BladeX 接口文档系统\n description: BladeX 接口文档系统\n version: 4.5.0.RELEASE\n license: Powered By BladeX\n license-url: https://bladex.cn\n terms-of-service-url: https://bladex.cn\n contact:\n name: 翼宿\n email: bladejava@qq.com\n url: https://gitee.com/smallc\n\n#blade配置\nkd:\n #oauth2配置\n oauth2:\n #启用 oauth2\n enabled: true\n #使用 @org.springblade.test.Sm2KeyGenerator 获取,用于国密sm2验签,需和前端保持一致\n public-key: 041283c3cff7c97b1b2ce9bae5754a25878b2bd254ebf0613db364db740ef0cf459af9db50a4434d2f36a49cee43e3457a828bc9a7eee331673f1dd6a3fa2c8b88\n #${BLADE_OAUTH2_PUBLIC_KEY}\n #使用 @org.springblade.test.Sm2KeyGenerator 获取,用于国密sm2解密,前端无需配置\n private-key: 00e209e0f9ac35192f4afb8fa8139b4b7bb4c866ad993c0f65e80156ced56e7b4a\n # ${BLADE_OAUTH2_PRIVATE_KEY}\n #token配置\n token:\n #是否有状态\n state: false\n #是否单用户登录\n single: false\n #单用户登录范围\n single-level: all\n #token签名 使用blade-auth服务 @org.springblade.test.SignKeyGenerator 获取\n sign-key: 2PVirX37iWjxOQ00TrC5Q3fYuN8QWvD7 \n #${BLADE_TOKEN_SIGN_KEY}\n #token加密 使用blade-auth服务 @org.springblade.test.CryptoKeyGenerator 获取\n crypto-key: qd9cXfGFhFfB1L4rCQquVyhNHP0dUpRa\n #${BLADE_TOKEN_CRYPTO_KEY}\n #接口配置\n api:\n #报文加密配置\n crypto:\n #启用报文加密配置\n enabled: false\n #使用blade-auth服务 @org.springblade.test.CryptoKeyGenerator 获取,需和前端保持一致\n aes-key: 8BJBWkaeMoVsNwyIxZQPEItsBzYr9A1H\n #${BLADE_API_CRYPTO_AES_KEY}\n #使用blade-auth服务 @org.springblade.test.CryptoKeyGenerator 获取,需和前端保持一致\n des-key: I4Wy5fZVvtvLejxg\n #${BLADE_API_CRYPTO_DES_KEY}\n #jackson配置\n jackson:\n #null自动转空值\n null-to-empty: true\n #大数字自动转字符串\n big-num-to-string: true\n #支持text文本请求,与报文加密同时开启\n support-text-plain: false\n #redis序列化方式\n redis:\n serializer-type: protostuff\n #日志配置\n log:\n request:\n #开启控制台请求日志\n enabled: true\n #控制台请求日志忽略\n skip-url:\n - /notice/list\n - /wechat/**\n #开启错误日志入库\n error-log: true\n #xss配置\n xss:\n enabled: true\n skip-url:\n - /wechat\n - /qq\n #安全框架配置\n secure:\n #严格模式\n #缺失令牌字段则取消授权\n strict-token: true\n #缺失请求头则取消授权\n strict-header: true\n #接口放行\n skip-url:\n - /test/**\n #授权认证配置\n auth:\n - method: ALL\n pattern: /chat/wechat/**\n expression: \"hasAuth()\"\n - method: ALL\n pattern: /chat/qq/**\n expression: \"hasStrictToken()\"\n - method: ALL\n pattern: /chat/ding/**\n expression: \"hasStrictHeader()\"\n - method: ALL\n pattern: /dashboard/notice\n expression: \"hasMenu(\'notice\')\"\n - method: POST\n pattern: /dashboard/upload\n expression: \"hasTimeAuth(9, 17)\"\n - method: POST\n pattern: /dashboard/submit\n expression: \"hasAnyRole(\'administrator\', \'admin\', \'user\')\"\n #基础认证配置\n basic:\n - method: ALL\n pattern: /dashboard/info\n username: \"blade\"\n password: \"blade\"\n #动态签名认证配置\n sign:\n - method: ALL\n pattern: /dashboard/sign\n crypto: \"sha1\"\n #多终端认证配置\n client:\n - client-id: sword\n path-patterns:\n - /sword/**\n - client-id: saber\n path-patterns:\n - /saber/**\n #多租户配置\n tenant:\n #多租户增强\n enhance: true\n #多租户授权保护\n license: false\n #动态数据源功能\n dynamic-datasource: false\n #动态数据源全局扫描\n dynamic-global: false\n #多租户字段名\n column: tenant_id\n #排除多租户逻辑\n exclude-tables:\n - kd_user\n #分库分表配置\n sharding:\n enabled: false\n', '1c118ddb1335365386634c6538a694f3', '2025-06-09 11:36:07', '2025-06-09 03:36:08', NULL, '0:0:0:0:0:0:0:1', 'U', 'bc98aa53-bc32-4e17-bb82-605c8e95d336');
  188. INSERT INTO `his_config_info` VALUES (11, 22, 'kd.yaml', 'DEFAULT_GROUP', '', '#服务器配置\nserver:\n undertow:\n threads:\n # 设置IO线程数, 它主要执行非阻塞的任务,它们会负责多个连接, 默认设置每个CPU核心一个线程\n io: 16\n # 阻塞任务线程池, 当执行类似servlet请求阻塞操作, undertow会从这个线程池中取得线程,它的值设置取决于系统的负载\n worker: 400\n # 以下的配置会影响buffer,这些buffer会用于服务器连接的IO操作,有点类似netty的池化内存管理\n buffer-size: 1024\n # 是否分配的直接内存\n direct-buffers: true\n\n#spring配置\nspring:\n cloud:\n nacos:\n discovery:\n # 禁用云命名空间解析,防止和云平台环境变量冲突\n isUseCloudNamespaceParsing: false\n config:\n # 禁用云命名空间解析,防止和云平台环境变量冲突\n isUseCloudNamespaceParsing: false\n sentinel:\n eager: true\n devtools:\n restart:\n log-condition-evaluation-delta: false\n livereload:\n port: 23333\n\n#feign配置\nfeign:\n sentinel:\n enabled: true\n okhttp:\n enabled: true\n httpclient:\n enabled: false\n\n#对外暴露端口\nmanagement:\n endpoints:\n web:\n exposure:\n include: \"*\"\n endpoint:\n health:\n show-details: always\n\n#springdoc-openapi配置\nspringdoc:\n default-flat-param-object: true\n\n#knife4j配置\nknife4j:\n #基础认证\n basic:\n enable: false\n username: blade\n password: blade\n #增强配置\n setting:\n enableSwaggerModels: true\n enableDocumentManage: true\n enableHost: false\n enableHostText: http://localhost\n enableRequestCache: true\n enableFilterMultipartApis: false\n enableFilterMultipartApiMethodType: POST\n language: zh_cn\n enableFooter: false\n enableFooterCustom: true\n footerCustomContent: Copyright © 2025 BladeX All Rights Reserved\n\n#swagger公共信息\nswagger:\n title: 接口文档系统\n description: 接口文档系统\n version: 1.0.0.RELEASE\n license: Powered By Sky\n\n#blade配置\nkd:\n #oauth2配置\n oauth2:\n #启用 oauth2\n enabled: true\n #使用 @org.springblade.test.Sm2KeyGenerator 获取,用于国密sm2验签,需和前端保持一致\n public-key: 041283c3cff7c97b1b2ce9bae5754a25878b2bd254ebf0613db364db740ef0cf459af9db50a4434d2f36a49cee43e3457a828bc9a7eee331673f1dd6a3fa2c8b88\n #${BLADE_OAUTH2_PUBLIC_KEY}\n #使用 @org.springblade.test.Sm2KeyGenerator 获取,用于国密sm2解密,前端无需配置\n private-key: 00e209e0f9ac35192f4afb8fa8139b4b7bb4c866ad993c0f65e80156ced56e7b4a\n # ${BLADE_OAUTH2_PRIVATE_KEY}\n #token配置\n token:\n #是否有状态\n state: false\n #是否单用户登录\n single: false\n #单用户登录范围\n single-level: all\n #token签名 使用blade-auth服务 @org.springblade.test.SignKeyGenerator 获取\n sign-key: 2PVirX37iWjxOQ00TrC5Q3fYuN8QWvD7 \n #${BLADE_TOKEN_SIGN_KEY}\n #token加密 使用blade-auth服务 @org.springblade.test.CryptoKeyGenerator 获取\n crypto-key: qd9cXfGFhFfB1L4rCQquVyhNHP0dUpRa\n #${BLADE_TOKEN_CRYPTO_KEY}\n #接口配置\n api:\n #报文加密配置\n crypto:\n #启用报文加密配置\n enabled: false\n #使用blade-auth服务 @org.springblade.test.CryptoKeyGenerator 获取,需和前端保持一致\n aes-key: 8BJBWkaeMoVsNwyIxZQPEItsBzYr9A1H\n #${BLADE_API_CRYPTO_AES_KEY}\n #使用blade-auth服务 @org.springblade.test.CryptoKeyGenerator 获取,需和前端保持一致\n des-key: I4Wy5fZVvtvLejxg\n #${BLADE_API_CRYPTO_DES_KEY}\n #jackson配置\n jackson:\n #null自动转空值\n null-to-empty: true\n #大数字自动转字符串\n big-num-to-string: true\n #支持text文本请求,与报文加密同时开启\n support-text-plain: false\n #redis序列化方式\n redis:\n serializer-type: protostuff\n #日志配置\n log:\n request:\n #开启控制台请求日志\n enabled: true\n #控制台请求日志忽略\n skip-url:\n - /notice/list\n - /wechat/**\n #开启错误日志入库\n error-log: true\n #xss配置\n xss:\n enabled: true\n skip-url:\n - /wechat\n - /qq\n #安全框架配置\n secure:\n #严格模式\n #缺失令牌字段则取消授权\n strict-token: true\n #缺失请求头则取消授权\n strict-header: true\n #接口放行\n skip-url:\n - /test/**\n #授权认证配置\n auth:\n - method: ALL\n pattern: /chat/wechat/**\n expression: \"hasAuth()\"\n - method: ALL\n pattern: /chat/qq/**\n expression: \"hasStrictToken()\"\n - method: ALL\n pattern: /chat/ding/**\n expression: \"hasStrictHeader()\"\n - method: ALL\n pattern: /dashboard/notice\n expression: \"hasMenu(\'notice\')\"\n - method: POST\n pattern: /dashboard/upload\n expression: \"hasTimeAuth(9, 17)\"\n - method: POST\n pattern: /dashboard/submit\n expression: \"hasAnyRole(\'administrator\', \'admin\', \'user\')\"\n #基础认证配置\n basic:\n - method: ALL\n pattern: /dashboard/info\n username: \"blade\"\n password: \"blade\"\n #动态签名认证配置\n sign:\n - method: ALL\n pattern: /dashboard/sign\n crypto: \"sha1\"\n #多终端认证配置\n client:\n - client-id: sword\n path-patterns:\n - /sword/**\n - client-id: saber\n path-patterns:\n - /saber/**\n #多租户配置\n tenant:\n #多租户增强\n enhance: true\n #多租户授权保护\n license: false\n #动态数据源功能\n dynamic-datasource: false\n #动态数据源全局扫描\n dynamic-global: false\n #多租户字段名\n column: tenant_id\n #排除多租户逻辑\n exclude-tables:\n - kd_user\n #分库分表配置\n sharding:\n enabled: false\n', '412b6bdc4fd4f1b4090064ac2b189a2f', '2025-06-20 17:41:43', '2025-06-20 09:41:43', NULL, '0:0:0:0:0:0:0:1', 'U', 'bc98aa53-bc32-4e17-bb82-605c8e95d336');
  189. INSERT INTO `his_config_info` VALUES (11, 23, 'kd.yaml', 'DEFAULT_GROUP', '', '#服务器配置\nserver:\n undertow:\n threads:\n # 设置IO线程数, 它主要执行非阻塞的任务,它们会负责多个连接, 默认设置每个CPU核心一个线程\n io: 16\n # 阻塞任务线程池, 当执行类似servlet请求阻塞操作, undertow会从这个线程池中取得线程,它的值设置取决于系统的负载\n worker: 400\n # 以下的配置会影响buffer,这些buffer会用于服务器连接的IO操作,有点类似netty的池化内存管理\n buffer-size: 1024\n # 是否分配的直接内存\n direct-buffers: true\n\n#spring配置\nspring:\n cloud:\n nacos:\n discovery:\n # 禁用云命名空间解析,防止和云平台环境变量冲突\n isUseCloudNamespaceParsing: false\n config:\n # 禁用云命名空间解析,防止和云平台环境变量冲突\n isUseCloudNamespaceParsing: false\n sentinel:\n eager: true\n devtools:\n restart:\n log-condition-evaluation-delta: false\n livereload:\n port: 23333\n\n#feign配置\nfeign:\n sentinel:\n enabled: true\n okhttp:\n enabled: true\n httpclient:\n enabled: false\n\n#对外暴露端口\nmanagement:\n endpoints:\n web:\n exposure:\n include: \"*\"\n endpoint:\n health:\n show-details: always\n\n#springdoc-openapi配置\nspringdoc:\n default-flat-param-object: true\n\n#knife4j配置\nknife4j:\n #基础认证\n basic:\n enable: false\n username: blade\n password: blade\n #增强配置\n setting:\n enableSwaggerModels: true\n enableDocumentManage: true\n enableHost: false\n enableHostText: http://localhost\n enableRequestCache: true\n enableFilterMultipartApis: false\n enableFilterMultipartApiMethodType: POST\n language: zh_cn\n enableFooter: false\n enableFooterCustom: true\n footerCustomContent: Copyright © 2025 BladeX All Rights Reserved\n\n#swagger公共信息\nswagger:\n title: 接口文档系统\n description: 接口文档系统\n version: 1.0.0.RELEASE\n license: Powered By Sky\n\n#blade配置\nkd:\n #oauth2配置\n oauth2:\n #启用 oauth2\n enabled: true\n #使用 @org.springblade.test.Sm2KeyGenerator 获取,用于国密sm2验签,需和前端保持一致\n public-key: 041283c3cff7c97b1b2ce9bae5754a25878b2bd254ebf0613db364db740ef0cf459af9db50a4434d2f36a49cee43e3457a828bc9a7eee331673f1dd6a3fa2c8b88\n #${BLADE_OAUTH2_PUBLIC_KEY}\n #使用 @org.springblade.test.Sm2KeyGenerator 获取,用于国密sm2解密,前端无需配置\n private-key: 00e209e0f9ac35192f4afb8fa8139b4b7bb4c866ad993c0f65e80156ced56e7b4a\n # ${BLADE_OAUTH2_PRIVATE_KEY}\n #token配置\n token:\n #是否有状态\n state: false\n #是否单用户登录\n single: false\n #单用户登录范围\n single-level: all\n #token签名 使用blade-auth服务 @org.springblade.test.SignKeyGenerator 获取\n sign-key: 2PVirX37iWjxOQ00TrC5Q3fYuN8QWvD7 \n #${BLADE_TOKEN_SIGN_KEY}\n #token加密 使用blade-auth服务 @org.springblade.test.CryptoKeyGenerator 获取\n crypto-key: qd9cXfGFhFfB1L4rCQquVyhNHP0dUpRa\n #${BLADE_TOKEN_CRYPTO_KEY}\n #接口配置\n api:\n #报文加密配置\n crypto:\n #启用报文加密配置\n enabled: false\n #使用blade-auth服务 @org.springblade.test.CryptoKeyGenerator 获取,需和前端保持一致\n aes-key: 8BJBWkaeMoVsNwyIxZQPEItsBzYr9A1H\n #${BLADE_API_CRYPTO_AES_KEY}\n #使用blade-auth服务 @org.springblade.test.CryptoKeyGenerator 获取,需和前端保持一致\n des-key: I4Wy5fZVvtvLejxg\n #${BLADE_API_CRYPTO_DES_KEY}\n #jackson配置\n jackson:\n #null自动转空值\n null-to-empty: true\n #大数字自动转字符串\n big-num-to-string: true\n #支持text文本请求,与报文加密同时开启\n support-text-plain: false\n #redis序列化方式\n redis:\n serializer-type: protostuff\n #日志配置\n log:\n request:\n #开启控制台请求日志\n enabled: true\n #控制台请求日志忽略\n skip-url:\n - /notice/list\n - /wechat/**\n #开启错误日志入库\n error-log: true\n #xss配置\n xss:\n enabled: true\n skip-url:\n - /wechat\n - /qq\n #安全框架配置\n secure:\n #严格模式\n #缺失令牌字段则取消授权\n strict-token: true\n #缺失请求头则取消授权\n strict-header: true\n #接口放行\n skip-url:\n - /test/**\n #授权认证配置\n auth:\n - method: ALL\n pattern: /chat/wechat/**\n expression: \"hasAuth()\"\n - method: ALL\n pattern: /chat/qq/**\n expression: \"hasStrictToken()\"\n - method: ALL\n pattern: /chat/ding/**\n expression: \"hasStrictHeader()\"\n - method: ALL\n pattern: /dashboard/notice\n expression: \"hasMenu(\'notice\')\"\n - method: POST\n pattern: /dashboard/upload\n expression: \"hasTimeAuth(9, 17)\"\n - method: POST\n pattern: /dashboard/submit\n expression: \"hasAnyRole(\'administrator\', \'admin\', \'user\')\"\n #基础认证配置\n basic:\n - method: ALL\n pattern: /dashboard/info\n username: \"blade\"\n password: \"blade\"\n #动态签名认证配置\n sign:\n - method: ALL\n pattern: /dashboard/sign\n crypto: \"sha1\"\n #多终端认证配置\n client:\n - client-id: sword\n path-patterns:\n - /sword/**\n - client-id: saber\n path-patterns:\n - /saber/**\n #多租户配置\n tenant:\n #多租户增强\n enhance: true\n #多租户授权保护\n license: false\n #动态数据源功能\n dynamic-datasource: false\n #动态数据源全局扫描\n dynamic-global: false\n #多租户字段名\n column: tenant_id\n #排除多租户逻辑\n exclude-tables:\n - kd_user\n - kd_technician_detail\n #分库分表配置\n sharding:\n enabled: false\n', '6db3f750f7ea97c131c526886a7ecf44', '2025-07-02 15:42:42', '2025-07-02 07:42:42', NULL, '0:0:0:0:0:0:0:1', 'U', 'bc98aa53-bc32-4e17-bb82-605c8e95d336');
  190. -- ----------------------------
  191. -- Table structure for permissions
  192. -- ----------------------------
  193. DROP TABLE IF EXISTS `permissions`;
  194. CREATE TABLE `permissions` (
  195. `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  196. `resource` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  197. `action` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  198. UNIQUE INDEX `uk_role_permission`(`role`, `resource`, `action`) USING BTREE
  199. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
  200. -- ----------------------------
  201. -- Records of permissions
  202. -- ----------------------------
  203. -- ----------------------------
  204. -- Table structure for roles
  205. -- ----------------------------
  206. DROP TABLE IF EXISTS `roles`;
  207. CREATE TABLE `roles` (
  208. `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  209. `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  210. UNIQUE INDEX `idx_user_role`(`username`, `role`) USING BTREE
  211. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
  212. -- ----------------------------
  213. -- Records of roles
  214. -- ----------------------------
  215. INSERT INTO `roles` VALUES ('nacos', 'ROLE_ADMIN');
  216. -- ----------------------------
  217. -- Table structure for tenant_capacity
  218. -- ----------------------------
  219. DROP TABLE IF EXISTS `tenant_capacity`;
  220. CREATE TABLE `tenant_capacity` (
  221. `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  222. `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'Tenant ID',
  223. `quota` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '配额,0表示使用默认值',
  224. `usage` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '使用量',
  225. `max_size` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个配置大小上限,单位为字节,0表示使用默认值',
  226. `max_aggr_count` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '聚合子配置最大个数',
  227. `max_aggr_size` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '单个聚合数据的子配置大小上限,单位为字节,0表示使用默认值',
  228. `max_history_count` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最大变更历史数量',
  229. `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  230. `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  231. PRIMARY KEY (`id`) USING BTREE,
  232. UNIQUE INDEX `uk_tenant_id`(`tenant_id`) USING BTREE
  233. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '租户容量信息表' ROW_FORMAT = DYNAMIC;
  234. -- ----------------------------
  235. -- Records of tenant_capacity
  236. -- ----------------------------
  237. -- ----------------------------
  238. -- Table structure for tenant_info
  239. -- ----------------------------
  240. DROP TABLE IF EXISTS `tenant_info`;
  241. CREATE TABLE `tenant_info` (
  242. `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  243. `kp` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'kp',
  244. `tenant_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_id',
  245. `tenant_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT 'tenant_name',
  246. `tenant_desc` varchar(256) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'tenant_desc',
  247. `create_source` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'create_source',
  248. `gmt_create` bigint(20) NOT NULL COMMENT '创建时间',
  249. `gmt_modified` bigint(20) NOT NULL COMMENT '修改时间',
  250. PRIMARY KEY (`id`) USING BTREE,
  251. UNIQUE INDEX `uk_tenant_info_kptenantid`(`kp`, `tenant_id`) USING BTREE,
  252. INDEX `idx_tenant_id`(`tenant_id`) USING BTREE
  253. ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = 'tenant_info' ROW_FORMAT = DYNAMIC;
  254. -- ----------------------------
  255. -- Records of tenant_info
  256. -- ----------------------------
  257. INSERT INTO `tenant_info` VALUES (1, '1', 'db463518-66f2-42c1-9070-35afa7555d45', 'szcp_dev', '数字藏品-开发环境配置', 'nacos', 1705452986955, 1705452986955);
  258. INSERT INTO `tenant_info` VALUES (2, '1', 'e8aea774-edcc-4b59-b904-8ec45ba6d2ac', 'yudao', 'yudao', 'nacos', 1745742418401, 1745742418401);
  259. INSERT INTO `tenant_info` VALUES (3, '1', 'bc98aa53-bc32-4e17-bb82-605c8e95d336', 'kd_dev', 'kd_dev', 'nacos', 1747214148712, 1747214148712);
  260. -- ----------------------------
  261. -- Table structure for users
  262. -- ----------------------------
  263. DROP TABLE IF EXISTS `users`;
  264. CREATE TABLE `users` (
  265. `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  266. `password` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  267. `enabled` tinyint(1) NOT NULL,
  268. PRIMARY KEY (`username`) USING BTREE
  269. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
  270. -- ----------------------------
  271. -- Records of users
  272. -- ----------------------------
  273. INSERT INTO `users` VALUES ('nacos', '$2a$10$EuWPZHzz32dJN7jexM34MOeYirDdFAZm2kuWj7VEOJhhZkDrxfvUu', 1);
  274. SET FOREIGN_KEY_CHECKS = 1;