Главная Обзор Помощь
Регистрация Вход
lichunlei
/
kxs-java
1
0
Ответвить 0
Файлы Задачи 0 Запросы на слияние 0 Вики
Дерево: 8d98126add
Ветки Метки
kxs-java
/
db
/
kxs_config.sql

kxs_config.sql 56 KB
История Исходник

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334 
  1. /*
    2. 

  2.  Navicat Premium Data Transfer
    3. 

  3. 

  4.  Source Server         : local
    5. 

  5.  Source Server Type    : MySQL
    6. 

  6.  Source Server Version : 80032 (8.0.32)
    7. 

  7.  Source Host           : localhost:3306
    8. 

  8.  Source Schema         : kxs_config
    9. 

  9. 

  10.  Target Server Type    : MySQL
    11. 

  11.  Target Server Version : 80032 (8.0.32)
    12. 

  12.  File Encoding         : 65001
    13. 

  13. 

  14.  Date: 04/12/2023 11:30:29
    15. 

  15. */
    16. 

  16. 

  17. SET NAMES utf8mb4;
    18. 

  18. SET FOREIGN_KEY_CHECKS = 0;
    19. 

  19. 

  20. -- ----------------------------
    21. 

  21. -- Table structure for config_info
    22. 

  22. -- ----------------------------
    23. 

  23. DROP TABLE IF EXISTS `config_info`;
    24. 

  24. CREATE TABLE `config_info` (
    25. 

  25.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
    26. 

  26.   `data_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'data_id',
    27. 

  27.   `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
    28. 

  28.   `content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'content',
    29. 

  29.   `md5` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'md5',
    30. 

  30.   `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    31. 

  31.   `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
    32. 

  32.   `src_user` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'source user',
    33. 

  33.   `src_ip` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'source ip',
    34. 

  34.   `app_name` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
    35. 

  35.   `tenant_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT '' COMMENT '租户字段',
    36. 

  36.   `c_desc` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
    37. 

  37.   `c_use` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
    38. 

  38.   `effect` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
    39. 

  39.   `type` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
    40. 

  40.   `c_schema` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
    41. 

  41.   `encrypted_data_key` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '秘钥',
    42. 

  42.   PRIMARY KEY (`id`) USING BTREE,
    43. 

  43.   UNIQUE KEY `uk_configinfo_datagrouptenant` (`data_id`,`group_id`,`tenant_id`) USING BTREE
    44. 

  44. ) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin ROW_FORMAT=DYNAMIC COMMENT='config_info';
    45. 

  45. 

  46. -- ----------------------------
    47. 

  47. -- Records of config_info
    48. 

  48. -- ----------------------------
    49. 

  49. BEGIN;
    50. 

  50. INSERT INTO `config_info` (`id`, `data_id`, `group_id`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `app_name`, `tenant_id`, `c_desc`, `c_use`, `effect`, `type`, `c_schema`, `encrypted_data_key`) VALUES (1, 'application-dev.yml', 'DEFAULT_GROUP', 'spring:\n  cache:\n    type: redis\n    repositories:\n      enabled: false # 项目未使用到 Spring Data Redis 的 Repository，所以直接禁用，保证启动速度\\\n  data:\n    redis:\n      host: kxs-redis\n  # Servlet 配置\n  servlet:\n    # 文件上传相关配置项\n    multipart:\n      max-file-size: 16MB # 单个文件大小\n      max-request-size: 32MB # 设置总上传的文件大小\n\n# swagger 配置\nswagger:\n  enabled: true\n  title: 客小爽API\n  gateway: http://${GATEWAY_HOST:localhost}:${GATEWAY-PORT:9999}\n  token-url: ${swagger.gateway}/v1/kxs/admin/oauth2/token\n  scope: server\n  services:\n    kxs-system-biz: admin\n    sky-codegen: gen\n\n# mybaits-plus配置\nmybatis-plus:\n  mapper-locations: classpath*:/mapper/*.xml\n  global-config:\n    banner: false # 关闭控制台的 Banner 打印\n    db-config:\n      id-type: auto\n      table-underline: true\n      logic-delete-value: 1  # 逻辑已删除值(默认为 1)\n      logic-not-delete-value: 0 # 逻辑未删除值(默认为 0)\n  type-handlers-package: com.kxs.common.mybatis.handler\n  configuration:\n    map-underscore-to-camel-case: true\n    shrink-whitespaces-in-sql: true', '2f0f0ec94d649f628922a1a4b4b1712a', '2022-05-08 12:10:37', '2023-12-04 10:13:25', 'nacos', '192.168.65.1', '', '', '', '', '', 'yaml', '', '');
    51. 

  51. INSERT INTO `config_info` (`id`, `data_id`, `group_id`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `app_name`, `tenant_id`, `c_desc`, `c_use`, `effect`, `type`, `c_schema`, `encrypted_data_key`) VALUES (4, 'kxs-gateway-dev.yml', 'DEFAULT_GROUP', 'spring:\n  cloud:\n    gateway:\n      locator:\n        enabled: true\n      routes:\n        #ADMIN 模块\n        - id: kxs-system-biz\n          uri: lb://kxs-system-biz\n          predicates:\n            - Path=/v1/kxs/admin/**\n          filters:\n            # 过滤前缀\n            - StripPrefix=3\n            # 限流配置\n            - name: RequestRateLimiter\n              args:\n                key-resolver: \'#{@remoteAddrKeyResolver}\'\n                redis-rate-limiter.replenishRate: 100\n                redis-rate-limiter.burstCapacity: 200\n            # 解密过滤器\n            - RequestDecoderFilter\n            # 验证码处理\n            - ValidateCodeGatewayFilter #如果该服务需要验证码则开启此过滤器\n        #用户模块\n        - id: kxs-user-biz\n          uri: lb://kxs-user-biz\n          predicates:\n            - Path=/v1/kxs/user/**\n          filters:\n            # 过滤前缀\n            - StripPrefix=3\n            # 限流配置\n            - name: RequestRateLimiter\n              args:\n                key-resolver: \'#{@remoteAddrKeyResolver}\'\n                redis-rate-limiter.replenishRate: 100\n                redis-rate-limiter.burstCapacity: 200\n            # 解密过滤器\n            - RequestDecoderFilter\n        \n        # 代码生成模块\n        - id: kxs-codegen\n          uri: lb://kxs-codegen\n          predicates:\n            - Path=/v1/kxs/gen/**\n          filters:\n            # 过滤前缀\n            - StripPrefix=3\n            # 解密过滤器\n            - RequestDecoderFilter\n\n        # 定时任务成模块\n        - id: kxs-quartz\n          uri: lb://kxs-quartz\n          predicates:\n            - Path=/v1/kxs/job/**\n          filters:\n            # 过滤前缀\n            - StripPrefix=3\n            # 解密过滤器\n            - RequestDecoderFilter\n        # 固定路由转发配置 无修改\n        - id: openapi\n          uri: lb://kxs-gateway\n          predicates:\n            - Path=/v3/api-docs/**\n          filters:\n            - RewritePath=/v3/api-docs/(?<path>.*), /$\\{path}/$\\{path}/v3/api-docs\n\ngateway:\n  aes:\n    encode-key: \'CBTU1dD4Kd5pyiGWTsI10jRQ3SvKusSV\'\n    encode-iv: \'DYgjCEIMVrj2W9xN\'\n    encode-mode: \'CBC\'\n    encode-padding: \'PKCS7Padding\'\n  #不校验验证码的客户端\n  ignore-clients:\n    - kxs\n\n    \nknife4j:\n  gateway:\n    enabled: true\n    tags-sorter: order\n    operations-sorter: order\n    strategy: manual\n    routes:\n      - name: 权限管理\n        url: /v1/kxs/admin/v3/api-docs?group=default\n        service-name: upms\n        context-path: /admin\n   \n      ', '910ed069b98310bdbafe9a83ac2ff8cb', '2022-05-08 12:10:37', '2023-12-04 11:28:49', 'nacos', '192.168.65.1', '', '', '', '', '', 'yaml', '', '');
    52. 

  52. INSERT INTO `config_info` (`id`, `data_id`, `group_id`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `app_name`, `tenant_id`, `c_desc`, `c_use`, `effect`, `type`, `c_schema`, `encrypted_data_key`) VALUES (7, 'kxs-quartz-dev.yml', 'DEFAULT_GROUP', 'spring:\n  datasource:\n    type: com.zaxxer.hikari.HikariDataSource\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    username: root\n    password: root\n    url: jdbc:mysql://kxs-mysql:3306/kxs_job?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowMultiQueries=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true\n  quartz:\n    #相关属性配置\n    properties:\n      org:\n        quartz:\n          scheduler:\n            instanceName: clusteredScheduler\n            instanceId: AUTO\n          jobStore:\n            class: org.springframework.scheduling.quartz.LocalDataSourceJobStore\n            driverDelegateClass: org.quartz.impl.jdbcjobstore.StdJDBCDelegate\n            tablePrefix: QRTZ_\n            isClustered: true\n            clusterCheckinInterval: 10000\n            useProperties: false\n          threadPool:\n            class: org.quartz.simpl.SimpleThreadPool\n            threadCount: 50\n            threadPriority: 5\n            threadsInheritContextClassLoaderOfInitializingThread: true\n    #数据库方式\n    job-store-type: jdbc\n    #初始化表结构\n    #jdbc:\n    #initialize-schema: never\n  web:\n    resources:\n      static-locations: classpath:/static/,classpath:/views/\n\n', '5863ce18706ed4c1b444991243546680', '2023-07-02 12:24:33', '2023-12-04 10:14:31', 'nacos', '192.168.65.1', '', '', '', '', '', 'yaml', '', '');
    53. 

  53. INSERT INTO `config_info` (`id`, `data_id`, `group_id`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `app_name`, `tenant_id`, `c_desc`, `c_use`, `effect`, `type`, `c_schema`, `encrypted_data_key`) VALUES (23, 'kxs-user-biz-dev.yml', 'DEFAULT_GROUP', '# 数据源\nspring:\n  datasource:\n    type: com.zaxxer.hikari.HikariDataSource\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    username: root\n    password: root\n    url: jdbc:mysql://sky-mysql:3306/sky?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowMultiQueries=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true\n\n# 文件上传相关 支持阿里云、华为云、腾讯、minio\nfile:\n  bucketName: skyAdmin \n  local:\n    enable: true\n    #base-path: /Users/Lxq/Downloads/img\n    base-path: /blog/skycloud/Downloads/img\naliyun:\n  sms:\n    SMS_268485466:\n      accessKeyId: LTAI5tH16w1BSXEPcAg8WtB2 \n      accessKeySecret: luS4wmI7I19Vl8KVQmFkjDWeGLPK0A \n      signName: 时空时代', 'a225bbd308049656a984a2e09472b005', '2023-09-05 16:14:40', '2023-09-08 16:54:45', 'nacos', '172.18.0.1', '', '', '', '', '', 'yaml', '', '');
    54. 

  54. INSERT INTO `config_info` (`id`, `data_id`, `group_id`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `app_name`, `tenant_id`, `c_desc`, `c_use`, `effect`, `type`, `c_schema`, `encrypted_data_key`) VALUES (60, 'seataServer.properties', 'SEATA_GROUP', 'store.mode=db\n#-----db-----\nstore.db.datasource=druid\nstore.db.dbType=mysql\nstore.db.driverClassName=com.mysql.cj.jdbc.Driver\nstore.db.url=jdbc:mysql://sky-mysql:3306/sky_seata?useUnicode=true&characterEncoding=utf8&connectTimeout=1000&socketTimeout=3000&autoReconnect=true&useSSL=false\nstore.db.user=root\nstore.db.password=root\n# 数据库初始连接数\nstore.db.minConn=1\n# 数据库最大连接数\nstore.db.maxConn=20\n# 获取连接时最大等待时间 默认5000，单位毫秒\nstore.db.maxWait=5000\n# 全局事务表名 默认global_table\nstore.db.globalTable=global_table\n# 分支事务表名 默认branch_table\nstore.db.branchTable=branch_table\n# 全局锁表名 默认lock_table\nstore.db.lockTable=lock_table\n# 查询全局事务一次的最大条数 默认100\nstore.db.queryLimit=100\n# undo保留天数 默认7天,log_status=1（附录3）和未正常清理的undo\nserver.undo.logSaveDays=7\n# undo清理线程间隔时间 默认86400000，单位毫秒\nserver.undo.logDeletePeriod=86400000\n# 二阶段提交重试超时时长 单位ms,s,m,h,d,对应毫秒,秒,分,小时,天,默认毫秒。默认值-1表示无限重试\n# 公式: timeout>=now-globalTransactionBeginTime,true表示超时则不再重试\n# 注: 达到超时时间后将不会做任何重试,有数据不一致风险,除非业务自行可校准数据,否者慎用\nserver.maxCommitRetryTimeout=-1\n# 二阶段回滚重试超时时长\nserver.maxRollbackRetryTimeout=-1\n# 二阶段提交未完成状态全局事务重试提交线程间隔时间 默认1000，单位毫秒\nserver.recovery.committingRetryPeriod=1000\n# 二阶段异步提交状态重试提交线程间隔时间 默认1000，单位毫秒\nserver.recovery.asynCommittingRetryPeriod=1000\n# 二阶段回滚状态重试回滚线程间隔时间  默认1000，单位毫秒\nserver.recovery.rollbackingRetryPeriod=1000\n# 超时状态检测重试线程间隔时间 默认1000，单位毫秒，检测出超时将全局事务置入回滚会话管理器\nserver.recovery.timeoutRetryPeriod=1000', 'e6c4134e1a0ca736c1097fa68cef3a99', '2023-09-26 15:00:31', '2023-09-26 17:26:48', 'nacos', '172.18.0.1', '', '99d16661-b9b1-41ef-a298-784e12a9258c', 'seataServer.properties', '', '', 'properties', '', '');
    55. 

  55. INSERT INTO `config_info` (`id`, `data_id`, `group_id`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `app_name`, `tenant_id`, `c_desc`, `c_use`, `effect`, `type`, `c_schema`, `encrypted_data_key`) VALUES (63, 'seataServer.properties', 'SEATA_GROUP', 'store.mode=db\n#-----db-----\nstore.db.datasource=druid\nstore.db.dbType=mysql\nstore.db.driverClassName=com.mysql.cj.jdbc.Driver\nstore.db.url=jdbc:mysql://sky-mysql:3306/sky_seata?useUnicode=true&characterEncoding=utf8&connectTimeout=1000&socketTimeout=3000&autoReconnect=true&useSSL=false\nstore.db.user=root\nstore.db.password=root\n# 数据库初始连接数\nstore.db.minConn=1\n# 数据库最大连接数\nstore.db.maxConn=20\n# 获取连接时最大等待时间 默认5000，单位毫秒\nstore.db.maxWait=5000\n# 全局事务表名 默认global_table\nstore.db.globalTable=global_table\n# 分支事务表名 默认branch_table\nstore.db.branchTable=branch_table\n# 全局锁表名 默认lock_table\nstore.db.lockTable=lock_table\n# 查询全局事务一次的最大条数 默认100\nstore.db.queryLimit=100\n# undo保留天数 默认7天,log_status=1（附录3）和未正常清理的undo\nserver.undo.logSaveDays=7\n# undo清理线程间隔时间 默认86400000，单位毫秒\nserver.undo.logDeletePeriod=86400000\n# 二阶段提交重试超时时长 单位ms,s,m,h,d,对应毫秒,秒,分,小时,天,默认毫秒。默认值-1表示无限重试\n# 公式: timeout>=now-globalTransactionBeginTime,true表示超时则不再重试\n# 注: 达到超时时间后将不会做任何重试,有数据不一致风险,除非业务自行可校准数据,否者慎用\nserver.maxCommitRetryTimeout=-1\n# 二阶段回滚重试超时时长\nserver.maxRollbackRetryTimeout=-1\n# 二阶段提交未完成状态全局事务重试提交线程间隔时间 默认1000，单位毫秒\nserver.recovery.committingRetryPeriod=1000\n# 二阶段异步提交状态重试提交线程间隔时间 默认1000，单位毫秒\nserver.recovery.asynCommittingRetryPeriod=1000\n# 二阶段回滚状态重试回滚线程间隔时间  默认1000，单位毫秒\nserver.recovery.rollbackingRetryPeriod=1000\n# 超时状态检测重试线程间隔时间 默认1000，单位毫秒，检测出超时将全局事务置入回滚会话管理器\nserver.recovery.timeoutRetryPeriod=1000', 'e6c4134e1a0ca736c1097fa68cef3a99', '2023-09-26 17:30:40', '2023-10-10 15:56:26', 'nacos', '172.18.0.1', '', '', '', '', '', 'properties', '', '');
    56. 

  56. INSERT INTO `config_info` (`id`, `data_id`, `group_id`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `app_name`, `tenant_id`, `c_desc`, `c_use`, `effect`, `type`, `c_schema`, `encrypted_data_key`) VALUES (76, 'kxs-system-biz-dev.yml', 'DEFAULT_GROUP', '# 数据源\nspring:\n  datasource:\n    type: com.zaxxer.hikari.HikariDataSource\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    username: root\n    password: root\n    url: jdbc:mysql://kxs-mysql:3306/kxs_sys?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowMultiQueries=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true\n    #hikari数据源特性配置\n    hikari:\n      maximum-pool-size: 50 #最大连接数,默认值10.\n      minimum-idle: 20 #最小空闲连接，默认值10.\n      connection-timeout: 60000 #连接超时时间(毫秒),默认值30秒.\n      #空闲连接超时时间，默认值600000(10分钟),只有空闲连接数大于最大连接数且空闲时间超过该值，才会被释放\n      #如果大于等于 max-lifetime 且 max-lifetime>0,则会被重置为0.\n      idle-timeout: 600000\n      max-lifetime: 3000000 #连接最大存活时间,默认值30分钟.设置应该比mysql设置的超时时间短\n      connection-test-query: select 1 #连接测试查询', 'cc4d107f6f656a2db2088aca2e3aabc6', '2023-12-04 10:17:24', '2023-12-04 10:17:41', 'nacos', '192.168.65.1', '', '', '', '', '', 'yaml', '', '');
    57. 

  57. COMMIT;
    58. 

  58. 

  59. -- ----------------------------
    60. 

  60. -- Table structure for config_info_aggr
    61. 

  61. -- ----------------------------
    62. 

  62. DROP TABLE IF EXISTS `config_info_aggr`;
    63. 

  63. CREATE TABLE `config_info_aggr` (
    64. 

  64.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
    65. 

  65.   `data_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'data_id',
    66. 

  66.   `group_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'group_id',
    67. 

  67.   `datum_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'datum_id',
    68. 

  68.   `content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '内容',
    69. 

  69.   `gmt_modified` datetime NOT NULL COMMENT '修改时间',
    70. 

  70.   `app_name` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
    71. 

  71.   `tenant_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT '' COMMENT '租户字段',
    72. 

  72.   PRIMARY KEY (`id`) USING BTREE,
    73. 

  73.   UNIQUE KEY `uk_configinfoaggr_datagrouptenantdatum` (`data_id`,`group_id`,`tenant_id`,`datum_id`) USING BTREE
    74. 

  74. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin ROW_FORMAT=DYNAMIC COMMENT='增加租户字段';
    75. 

  75. 

  76. -- ----------------------------
    77. 

  77. -- Records of config_info_aggr
    78. 

  78. -- ----------------------------
    79. 

  79. BEGIN;
    80. 

  80. COMMIT;
    81. 

  81. 

  82. -- ----------------------------
    83. 

  83. -- Table structure for config_info_beta
    84. 

  84. -- ----------------------------
    85. 

  85. DROP TABLE IF EXISTS `config_info_beta`;
    86. 

  86. CREATE TABLE `config_info_beta` (
    87. 

  87.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
    88. 

  88.   `data_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'data_id',
    89. 

  89.   `group_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'group_id',
    90. 

  90.   `app_name` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'app_name',
    91. 

  91.   `content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'content',
    92. 

  92.   `beta_ips` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'betaIps',
    93. 

  93.   `md5` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'md5',
    94. 

  94.   `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    95. 

  95.   `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
    96. 

  96.   `src_user` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'source user',
    97. 

  97.   `src_ip` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'source ip',
    98. 

  98.   `tenant_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT '' COMMENT '租户字段',
    99. 

  99.   `encrypted_data_key` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '秘钥',
    100. 

  100.   PRIMARY KEY (`id`) USING BTREE,
    101. 

  101.   UNIQUE KEY `uk_configinfobeta_datagrouptenant` (`data_id`,`group_id`,`tenant_id`) USING BTREE
    102. 

  102. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin ROW_FORMAT=DYNAMIC COMMENT='config_info_beta';
    103. 

  103. 

  104. -- ----------------------------
    105. 

  105. -- Records of config_info_beta
    106. 

  106. -- ----------------------------
    107. 

  107. BEGIN;
    108. 

  108. COMMIT;
    109. 

  109. 

  110. -- ----------------------------
    111. 

  111. -- Table structure for config_info_tag
    112. 

  112. -- ----------------------------
    113. 

  113. DROP TABLE IF EXISTS `config_info_tag`;
    114. 

  114. CREATE TABLE `config_info_tag` (
    115. 

  115.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
    116. 

  116.   `data_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'data_id',
    117. 

  117.   `group_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'group_id',
    118. 

  118.   `tenant_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT '' COMMENT 'tenant_id',
    119. 

  119.   `tag_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'tag_id',
    120. 

  120.   `app_name` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'app_name',
    121. 

  121.   `content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'content',
    122. 

  122.   `md5` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'md5',
    123. 

  123.   `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    124. 

  124.   `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
    125. 

  125.   `src_user` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'source user',
    126. 

  126.   `src_ip` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'source ip',
    127. 

  127.   PRIMARY KEY (`id`) USING BTREE,
    128. 

  128.   UNIQUE KEY `uk_configinfotag_datagrouptenanttag` (`data_id`,`group_id`,`tenant_id`,`tag_id`) USING BTREE
    129. 

  129. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin ROW_FORMAT=DYNAMIC COMMENT='config_info_tag';
    130. 

  130. 

  131. -- ----------------------------
    132. 

  132. -- Records of config_info_tag
    133. 

  133. -- ----------------------------
    134. 

  134. BEGIN;
    135. 

  135. COMMIT;
    136. 

  136. 

  137. -- ----------------------------
    138. 

  138. -- Table structure for config_tags_relation
    139. 

  139. -- ----------------------------
    140. 

  140. DROP TABLE IF EXISTS `config_tags_relation`;
    141. 

  141. CREATE TABLE `config_tags_relation` (
    142. 

  142.   `id` bigint NOT NULL COMMENT 'id',
    143. 

  143.   `tag_name` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'tag_name',
    144. 

  144.   `tag_type` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'tag_type',
    145. 

  145.   `data_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'data_id',
    146. 

  146.   `group_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'group_id',
    147. 

  147.   `tenant_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT '' COMMENT 'tenant_id',
    148. 

  148.   `nid` bigint NOT NULL AUTO_INCREMENT,
    149. 

  149.   PRIMARY KEY (`nid`) USING BTREE,
    150. 

  150.   UNIQUE KEY `uk_configtagrelation_configidtag` (`id`,`tag_name`,`tag_type`) USING BTREE,
    151. 

  151.   KEY `idx_tenant_id` (`tenant_id`) USING BTREE
    152. 

  152. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin ROW_FORMAT=DYNAMIC COMMENT='config_tag_relation';
    153. 

  153. 

  154. -- ----------------------------
    155. 

  155. -- Records of config_tags_relation
    156. 

  156. -- ----------------------------
    157. 

  157. BEGIN;
    158. 

  158. COMMIT;
    159. 

  159. 

  160. -- ----------------------------
    161. 

  161. -- Table structure for group_capacity
    162. 

  162. -- ----------------------------
    163. 

  163. DROP TABLE IF EXISTS `group_capacity`;
    164. 

  164. CREATE TABLE `group_capacity` (
    165. 

  165.   `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
    166. 

  166.   `group_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT 'Group ID，空字符表示整个集群',
    167. 

  167.   `quota` int unsigned NOT NULL DEFAULT '0' COMMENT '配额，0表示使用默认值',
    168. 

  168.   `usage` int unsigned NOT NULL DEFAULT '0' COMMENT '使用量',
    169. 

  169.   `max_size` int unsigned NOT NULL DEFAULT '0' COMMENT '单个配置大小上限，单位为字节，0表示使用默认值',
    170. 

  170.   `max_aggr_count` int unsigned NOT NULL DEFAULT '0' COMMENT '聚合子配置最大个数，，0表示使用默认值',
    171. 

  171.   `max_aggr_size` int unsigned NOT NULL DEFAULT '0' COMMENT '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值',
    172. 

  172.   `max_history_count` int unsigned NOT NULL DEFAULT '0' COMMENT '最大变更历史数量',
    173. 

  173.   `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    174. 

  174.   `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
    175. 

  175.   PRIMARY KEY (`id`) USING BTREE,
    176. 

  176.   UNIQUE KEY `uk_group_id` (`group_id`) USING BTREE
    177. 

  177. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin ROW_FORMAT=DYNAMIC COMMENT='集群、各Group容量信息表';
    178. 

  178. 

  179. -- ----------------------------
    180. 

  180. -- Records of group_capacity
    181. 

  181. -- ----------------------------
    182. 

  182. BEGIN;
    183. 

  183. COMMIT;
    184. 

  184. 

  185. -- ----------------------------
    186. 

  186. -- Table structure for his_config_info
    187. 

  187. -- ----------------------------
    188. 

  188. DROP TABLE IF EXISTS `his_config_info`;
    189. 

  189. CREATE TABLE `his_config_info` (
    190. 

  190.   `id` bigint unsigned NOT NULL,
    191. 

  191.   `nid` bigint unsigned NOT NULL AUTO_INCREMENT,
    192. 

  192.   `data_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
    193. 

  193.   `group_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
    194. 

  194.   `app_name` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'app_name',
    195. 

  195.   `content` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
    196. 

  196.   `md5` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
    197. 

  197.   `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    198. 

  198.   `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    199. 

  199.   `src_user` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
    200. 

  200.   `src_ip` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
    201. 

  201.   `op_type` char(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
    202. 

  202.   `tenant_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT '' COMMENT '租户字段',
    203. 

  203.   `encrypted_data_key` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '秘钥',
    204. 

  204.   PRIMARY KEY (`nid`) USING BTREE,
    205. 

  205.   KEY `idx_gmt_create` (`gmt_create`) USING BTREE,
    206. 

  206.   KEY `idx_gmt_modified` (`gmt_modified`) USING BTREE,
    207. 

  207.   KEY `idx_did` (`data_id`) USING BTREE
    208. 

  208. ) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin ROW_FORMAT=DYNAMIC COMMENT='多租户改造';
    209. 

  209. 

  210. -- ----------------------------
    211. 

  211. -- Records of his_config_info
    212. 

  212. -- ----------------------------
    213. 

  213. BEGIN;
    214. 

  214. INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (5, 59, 'sky-monitor-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  autoconfigure:\n    exclude: com.skycloud.sky.common.core.config.JacksonConfiguration\n  # 安全配置\n  security:\n    user:\n      name: ENC(8Hk2ILNJM8UTOuW/Xi75qg==)     # sky\n      password: ENC(o6cuPFfUevmTbkmBnE67Ow====) # sky\n', 'a17343b27f328e6638e59ee5dd0b6fb7', '2023-12-02 17:17:06', '2023-12-02 17:17:06', NULL, '192.168.65.1', 'D', '', '');
    215. 

  215. INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (2, 60, 'sky-auth-dev.yml', 'DEFAULT_GROUP', '', '# 数据源\nspring:\n  freemarker:\n    allow-request-override: false\n    allow-session-override: false\n    cache: true\n    charset: UTF-8\n    check-template-location: true\n    content-type: text/html\n    enabled: true\n    expose-request-attributes: false\n    expose-session-attributes: false\n    expose-spring-macro-helpers: true\n    prefer-file-system-access: true\n    suffix: .ftl\n    template-loader-path: classpath:/templates/', '74f53b71c7799aa754da75662378b93c', '2023-12-02 17:17:30', '2023-12-02 17:17:31', NULL, '192.168.65.1', 'D', '', '');
    216. 

  216. INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (1, 61, 'application-dev.yml', 'DEFAULT_GROUP', '', '# 配置文件加密根密码\njasypt:\n  encryptor:\n    password: pig\n    algorithm: PBEWithMD5AndDES\n    iv-generator-classname: org.jasypt.iv.NoIvGenerator\n    \n# Spring 相关\nspring:\n  cache:\n    type: redis\n  data:\n    redis:\n      host: sky-redis\n  cloud:\n    sentinel:\n      eager: true\n      transport:\n        dashboard: sky-sentinel:5003\n    openfeign:\n      sentinel:\n        enabled: true\n      okhttp:\n        enabled: true\n      httpclient:\n        enabled: false\n      compression:\n        request:\n          enabled: true\n        response:\n          enabled: true\n\n# 暴露监控端点\nmanagement:\n  endpoints:\n    web:\n      exposure:\n        include: \"*\"  \n  endpoint:\n    health:\n      show-details: ALWAYS\n\n# mybaits-plus配置\nmybatis-plus:\n  mapper-locations: classpath:/mapper/*Mapper.xml\n  global-config:\n    banner: false\n    db-config:\n      id-type: auto\n      table-underline: true\n      logic-delete-value: 1\n      logic-not-delete-value: 0\n  type-handlers-package: com.skycloud.sky.common.mybatis.handler\n  configuration:\n    map-underscore-to-camel-case: true\n    shrink-whitespaces-in-sql: true\n\n# swagger 配置\nswagger:\n  enabled: true\n  title: 时空驿站API\n  gateway: http://${GATEWAY_HOST:sky-gateway}:${GATEWAY-PORT:9999}\n  token-url: ${swagger.gateway}/auth/oauth2/token\n  scope: server\n  services:\n    sky-upms-biz: admin\n    sky-user-biz: user\n    sky-codegen: gen', '85a2ea936e647ab6ce6011ee7e3a8571', '2023-12-04 09:58:39', '2023-12-04 09:58:39', 'nacos', '192.168.65.1', 'U', '', '');
    217. 

  217. INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (3, 62, 'sky-codegen-dev.yml', 'DEFAULT_GROUP', '', '# 数据源配置\nspring:\n  datasource:\n    type: com.zaxxer.hikari.HikariDataSource\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    username: root\n    password: root\n    url: jdbc:mysql://sky-mysql:3306/sky_codegen?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true\n  resources:\n    static-locations: classpath:/static/,classpath:/views/\n', 'f0f02acc997d7c76e4ea2906b1c45239', '2023-12-04 10:02:08', '2023-12-04 10:02:09', NULL, '192.168.65.1', 'D', '', '');
    218. 

  218. INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (4, 63, 'sky-gateway-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  cloud:\n    gateway:\n      locator:\n        enabled: true\n      routes:\n        # 认证中心\n        - id: sky-auth\n          uri: lb://sky-auth\n          predicates:\n            - Path=/auth/**\n          filters:\n            # 验证码处理\n            - ValidateCodeGatewayFilter\n            # 前端密码解密\n            - PasswordDecoderFilter\n        #UPMS 模块\n        - id: sky-upms-biz\n          uri: lb://sky-upms-biz\n          predicates:\n            - Path=/admin/**\n          filters:\n            # 限流配置\n            - name: RequestRateLimiter\n              args:\n                key-resolver: \'#{@remoteAddrKeyResolver}\'\n                redis-rate-limiter.replenishRate: 100\n                redis-rate-limiter.burstCapacity: 200\n                #UPMS 模块\n        #用户模块\n        - id: sky-user-biz\n          uri: lb://sky-user-biz\n          predicates:\n            - Path=/user/**\n          filters:\n            # 限流配置\n            - name: RequestRateLimiter\n              args:\n                key-resolver: \'#{@remoteAddrKeyResolver}\'\n                redis-rate-limiter.replenishRate: 100\n                redis-rate-limiter.burstCapacity: 200\n        #商城模块\n        - id: sky-shop-biz\n          uri: lb://sky-shop-biz\n          predicates:\n            - Path=/shop/**\n          filters:\n            # 限流配置\n            - name: RequestRateLimiter\n              args:\n                key-resolver: \'#{@remoteAddrKeyResolver}\'\n                redis-rate-limiter.replenishRate: 100\n                redis-rate-limiter.burstCapacity: 200\n        #zc模块\n        - id: sky-crowd-biz\n          uri: lb://sky-crowd-biz\n          predicates:\n            - Path=/crowd/**\n          filters:\n            # 限流配置\n            - name: RequestRateLimiter\n              args:\n                key-resolver: \'#{@remoteAddrKeyResolver}\'\n                redis-rate-limiter.replenishRate: 100\n                redis-rate-limiter.burstCapacity: 200\n        #任务包模块\n        - id: sky-package-biz\n          uri: lb://sky-package-biz\n          predicates:\n            - Path=/package/**\n          filters:\n            # 限流配置\n            - name: RequestRateLimiter\n              args:\n                key-resolver: \'#{@remoteAddrKeyResolver}\'\n                redis-rate-limiter.replenishRate: 100\n                redis-rate-limiter.burstCapacity: 200\n        # 代码生成模块\n        - id: sky-codegen\n          uri: lb://sky-codegen\n          predicates:\n            - Path=/gen/**\n        # 代码生成模块\n        - id: sky-quartz\n          uri: lb://sky-quartz\n          predicates:\n            - Path=/job/**\n        # 固定路由转发配置 无修改\n        - id: openapi\n          uri: lb://sky-gateway\n          predicates:\n            - Path=/v3/api-docs/**\n          filters:\n            - RewritePath=/v3/api-docs/(?<path>.*), /$\\{path}/$\\{path}/v3/api-docs\n\ngateway:\n  encode-key: \'NfNg4zkpMcBP8hty\'\n  #不校验验证码的客户端\n  ignore-clients:\n    - sky\n\n    \nknife4j:\n  gateway:\n    enabled: true\n    tags-sorter: order\n    operations-sorter: order\n    strategy: manual\n    routes:\n      - name: 权限管理\n        url: /admin/v3/api-docs?group=default\n        service-name: upms\n        context-path: /admin\n      - name: 时空用户管理\n        url: /user/v3/api-docs?group=default\n        service-name: user\n        context-path: /user\n      - name: 时空商城管理\n        url: /shop/v3/api-docs?group=default\n        service-name: shop\n        context-path: /shop\n      - name: 时空zc管理\n        url: /crowd/v3/api-docs?group=default\n        service-name: crowd\n        context-path: /crowd\n      - name: 时空任务包管理\n        url: /package/v3/api-docs?group=default\n        service-name: package\n        context-path: /package\n   \n      ', 'ac2dc90bd1a0e3feadb1180bc1d0d895', '2023-12-04 10:09:00', '2023-12-04 10:09:01', 'nacos', '192.168.65.1', 'U', '', '');
    219. 

  219. INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (6, 64, 'sky-upms-biz-dev.yml', 'DEFAULT_GROUP', '', '# 数据源\nspring:\n  datasource:\n    type: com.zaxxer.hikari.HikariDataSource\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    username: root\n    password: root\n    url: jdbc:mysql://sky-mysql:3306/sky?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowMultiQueries=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true\n\n# 文件上传相关 支持阿里云、华为云、腾讯、minio\nfile:\n  bucketName: skyAdmin \n  local:\n    enable: true\n    #base-path: /Users/Lxq/Downloads/img\n    base-path: /blog/sky-cloud/Downloads/img', '78902e59785e7dcd797538ffe509a284', '2023-12-04 10:10:52', '2023-12-04 10:10:53', 'nacos', '192.168.65.1', 'U', '', '');
    220. 

  220. INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (6, 65, 'sky-upms-biz-dev.yml', 'DEFAULT_GROUP', '', '# 数据源\nspring:\n  datasource:\n    type: com.zaxxer.hikari.HikariDataSource\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    username: root\n    password: root\n    url: jdbc:mysql://kxs-mysql:3306/kxs_sys?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowMultiQueries=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true\n', 'ec80309113dab59eeb4f0920af77dcd4', '2023-12-04 10:11:15', '2023-12-04 10:11:16', 'nacos', '192.168.65.1', 'U', '', '');
    221. 

  221. INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (1, 66, 'application-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  cache:\n    type: redis\n  # Servlet 配置\n  servlet:\n    # 文件上传相关配置项\n    multipart:\n      max-file-size: 16MB # 单个文件大小\n      max-request-size: 32MB # 设置总上传的文件大小\n\n# swagger 配置\nswagger:\n  enabled: true\n  title: 客小爽API\n  gateway: http://${GATEWAY_HOST:localhost}:${GATEWAY-PORT:9999}\n  token-url: ${swagger.gateway}/v1/kxs/admin/oauth2/token\n  scope: server\n  services:\n    kxs-system-biz: admin\n    sky-codegen: gen\n\n# mybaits-plus配置\nmybatis-plus:\n  mapper-locations: classpath*:/mapper/*.xml\n  global-config:\n    banner: false # 关闭控制台的 Banner 打印\n    db-config:\n      id-type: auto\n      table-underline: true\n      logic-delete-value: 1  # 逻辑已删除值(默认为 1)\n      logic-not-delete-value: 0 # 逻辑未删除值(默认为 0)\n  type-handlers-package: com.kxs.common.mybatis.handler\n  configuration:\n    map-underscore-to-camel-case: true\n    shrink-whitespaces-in-sql: true', '47de409a5bf09a5ac518e10fc5a6ff11', '2023-12-04 10:12:07', '2023-12-04 10:12:07', 'nacos', '192.168.65.1', 'U', '', '');
    222. 

  222. INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (1, 67, 'application-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  cache:\n    type: redis\n    repositories:\n      enabled: false # 项目未使用到 Spring Data Redis 的 Repository，所以直接禁用，保证启动速度\\\n  # Servlet 配置\n  servlet:\n    # 文件上传相关配置项\n    multipart:\n      max-file-size: 16MB # 单个文件大小\n      max-request-size: 32MB # 设置总上传的文件大小\n\n# swagger 配置\nswagger:\n  enabled: true\n  title: 客小爽API\n  gateway: http://${GATEWAY_HOST:localhost}:${GATEWAY-PORT:9999}\n  token-url: ${swagger.gateway}/v1/kxs/admin/oauth2/token\n  scope: server\n  services:\n    kxs-system-biz: admin\n    sky-codegen: gen\n\n# mybaits-plus配置\nmybatis-plus:\n  mapper-locations: classpath*:/mapper/*.xml\n  global-config:\n    banner: false # 关闭控制台的 Banner 打印\n    db-config:\n      id-type: auto\n      table-underline: true\n      logic-delete-value: 1  # 逻辑已删除值(默认为 1)\n      logic-not-delete-value: 0 # 逻辑未删除值(默认为 0)\n  type-handlers-package: com.kxs.common.mybatis.handler\n  configuration:\n    map-underscore-to-camel-case: true\n    shrink-whitespaces-in-sql: true', '91b0ec3d6d910dfa3664b488f43f77f2', '2023-12-04 10:13:25', '2023-12-04 10:13:25', 'nacos', '192.168.65.1', 'U', '', '');
    223. 

  223. INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (7, 68, 'sky-quartz-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  datasource:\n    type: com.zaxxer.hikari.HikariDataSource\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    username: root\n    password: root\n    url: jdbc:mysql://sky-mysql:3306/sky_job?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowMultiQueries=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true\n  quartz:\n    #相关属性配置\n    properties:\n      org:\n        quartz:\n          scheduler:\n            instanceName: clusteredScheduler\n            instanceId: AUTO\n          jobStore:\n            class: org.springframework.scheduling.quartz.LocalDataSourceJobStore\n            driverDelegateClass: org.quartz.impl.jdbcjobstore.StdJDBCDelegate\n            tablePrefix: QRTZ_\n            isClustered: true\n            clusterCheckinInterval: 10000\n            useProperties: false\n          threadPool:\n            class: org.quartz.simpl.SimpleThreadPool\n            threadCount: 50\n            threadPriority: 5\n            threadsInheritContextClassLoaderOfInitializingThread: true\n    #数据库方式\n    job-store-type: jdbc\n    #初始化表结构\n    #jdbc:\n    #initialize-schema: never\n  web:\n    resources:\n      static-locations: classpath:/static/,classpath:/views/\n\n', '047c1b2e7a993a0d44cedc8fdac94ddc', '2023-12-04 10:14:30', '2023-12-04 10:14:31', 'nacos', '192.168.65.1', 'U', '', '');
    224. 

  224. INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (0, 69, 'kxs-system-biz-dev.yml', 'DEFAULT_GROUP', '', 'd', '8277e0910d750195b448797616e091ad', '2023-12-04 10:17:24', '2023-12-04 10:17:24', NULL, '192.168.65.1', 'I', '', '');
    225. 

  225. INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (76, 70, 'kxs-system-biz-dev.yml', 'DEFAULT_GROUP', '', 'd', '8277e0910d750195b448797616e091ad', '2023-12-04 10:17:41', '2023-12-04 10:17:41', 'nacos', '192.168.65.1', 'U', '', '');
    226. 

  226. INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (6, 71, 'sky-upms-biz-dev.yml', 'DEFAULT_GROUP', '', '# 数据源\nspring:\n  datasource:\n    type: com.zaxxer.hikari.HikariDataSource\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    username: root\n    password: root\n    url: jdbc:mysql://kxs-mysql:3306/kxs_sys?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowMultiQueries=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true\n    #hikari数据源特性配置\n    hikari:\n      maximum-pool-size: 50 #最大连接数,默认值10.\n      minimum-idle: 20 #最小空闲连接，默认值10.\n      connection-timeout: 60000 #连接超时时间(毫秒),默认值30秒.\n      #空闲连接超时时间，默认值600000(10分钟),只有空闲连接数大于最大连接数且空闲时间超过该值，才会被释放\n      #如果大于等于 max-lifetime 且 max-lifetime>0,则会被重置为0.\n      idle-timeout: 600000\n      max-lifetime: 3000000 #连接最大存活时间,默认值30分钟.设置应该比mysql设置的超时时间短\n      connection-test-query: select 1 #连接测试查询', 'cc4d107f6f656a2db2088aca2e3aabc6', '2023-12-04 10:17:47', '2023-12-04 10:17:47', NULL, '192.168.65.1', 'D', '', '');
    227. 

  227. INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (52, 72, 'sky-shop-biz-dev.yml', 'DEFAULT_GROUP', '', '# 数据源\nspring:\n  datasource:\n    type: com.zaxxer.hikari.HikariDataSource\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    username: root\n    password: root\n    url: jdbc:mysql://sky-mysql:3306/sky_shop?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowMultiQueries=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true\n\n# 文件上传相关 支持阿里云、华为云、腾讯、minio\nfile:\n  bucketName: chengduskyz \n  oss:\n    enable: true\n    endpoint: chengduskyz.oss-cn-hangzhou.aliyuncs.com \n    access-key: LTAI5tH16w1BSXEPcAg8WtB2 \n    secret-key: luS4wmI7I19Vl8KVQmFkjDWeGLPK0A\n# file:\n#   bucketName: skyAdmin \n#   local:\n#     enable: true\n#     #base-path: /Users/Lxq/Downloads/img\n#     base-path: /blog/skycloud/Downloads/img', '363d405aef3da8368abefc5fd223054a', '2023-12-04 10:17:53', '2023-12-04 10:17:53', NULL, '192.168.65.1', 'D', '', '');
    228. 

  228. INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (4, 73, 'kxs-gateway-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  cloud:\n    gateway:\n      locator:\n        enabled: true\n      routes:\n        #UPMS 模块\n        - id: kxs-system-biz\n          uri: lb://kxs-system-biz\n          predicates:\n            - Path=/admin/**\n          filters:\n            # 限流配置\n            - name: RequestRateLimiter\n              args:\n                key-resolver: \'#{@remoteAddrKeyResolver}\'\n                redis-rate-limiter.replenishRate: 100\n                redis-rate-limiter.burstCapacity: 200\n            # 解密过滤器\n            - RequestDecoderFilter\n            # 验证码处理\n            - ValidateCodeGatewayFilter #如果该服务需要验证码则开启此过滤器\n        #用户模块\n        - id: kxs-user-biz\n          uri: lb://kxs-user-biz\n          predicates:\n            - Path=/user/**\n          filters:\n            # 限流配置\n            - name: RequestRateLimiter\n              args:\n                key-resolver: \'#{@remoteAddrKeyResolver}\'\n                redis-rate-limiter.replenishRate: 100\n                redis-rate-limiter.burstCapacity: 200\n            # 解密过滤器\n            - RequestDecoderFilter\n        \n                # 代码生成模块\n        - id: kxs-codegen\n          uri: lb://kxs-codegen\n          predicates:\n            - Path=/v1/kxs/gen/**\n          filters:\n            # 过滤前缀\n            - StripPrefix=3\n            # 解密过滤器\n            - RequestDecoderFilter\n\n        # 定时任务成模块\n        - id: kxs-quartz\n          uri: lb://kxs-quartz\n          predicates:\n            - Path=/v1/kxs/job/**\n          filters:\n            # 过滤前缀\n            - StripPrefix=3\n            # 解密过滤器\n            - RequestDecoderFilter\n        # 固定路由转发配置 无修改\n        - id: openapi\n          uri: lb://kxs-gateway\n          predicates:\n            - Path=/v3/api-docs/**\n          filters:\n            - RewritePath=/v3/api-docs/(?<path>.*), /$\\{path}/$\\{path}/v3/api-docs\n\ngateway:\n  aes:\n    encode-key: \'CBTU1dD4Kd5pyiGWTsI10jRQ3SvKusSV\'\n    encode-iv: \'DYgjCEIMVrj2W9xN\'\n    encode-mode: \'CBC\'\n    encode-padding: \'PKCS7Padding\'\n  #不校验验证码的客户端\n  ignore-clients:\n    - kxs\n\n    \nknife4j:\n  gateway:\n    enabled: true\n    tags-sorter: order\n    operations-sorter: order\n    strategy: manual\n    routes:\n      - name: 权限管理\n        url: /v1/kxs/admin/v3/api-docs?group=default\n        service-name: upms\n        context-path: /admin\n   \n      ', 'cfb3d116d4907d1964e33dcd26ede24a', '2023-12-04 11:20:48', '2023-12-04 11:20:48', 'nacos', '192.168.65.1', 'U', '', '');
    229. 

  229. INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (4, 74, 'kxs-gateway-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  cloud:\n    gateway:\n      locator:\n        enabled: true\n      routes:\n        #ADMIN 模块\n        - id: kxs-system-biz\n          uri: lb://kxs-system-biz\n          predicates:\n            - Path=/admin/**\n          filters:\n            # 限流配置\n            - name: RequestRateLimiter\n              args:\n                key-resolver: \'#{@remoteAddrKeyResolver}\'\n                redis-rate-limiter.replenishRate: 100\n                redis-rate-limiter.burstCapacity: 200\n            # 解密过滤器\n            - RequestDecoderFilter\n            # 验证码处理\n            - ValidateCodeGatewayFilter #如果该服务需要验证码则开启此过滤器\n        #用户模块\n        - id: kxs-user-biz\n          uri: lb://kxs-user-biz\n          predicates:\n            - Path=/user/**\n          filters:\n            # 限流配置\n            - name: RequestRateLimiter\n              args:\n                key-resolver: \'#{@remoteAddrKeyResolver}\'\n                redis-rate-limiter.replenishRate: 100\n                redis-rate-limiter.burstCapacity: 200\n            # 解密过滤器\n            - RequestDecoderFilter\n        \n        # 代码生成模块\n        - id: kxs-codegen\n          uri: lb://kxs-codegen\n          predicates:\n            - Path=/v1/kxs/gen/**\n          filters:\n            # 过滤前缀\n            - StripPrefix=3\n            # 解密过滤器\n            - RequestDecoderFilter\n\n        # 定时任务成模块\n        - id: kxs-quartz\n          uri: lb://kxs-quartz\n          predicates:\n            - Path=/v1/kxs/job/**\n          filters:\n            # 过滤前缀\n            - StripPrefix=3\n            # 解密过滤器\n            - RequestDecoderFilter\n        # 固定路由转发配置 无修改\n        - id: openapi\n          uri: lb://kxs-gateway\n          predicates:\n            - Path=/v3/api-docs/**\n          filters:\n            - RewritePath=/v3/api-docs/(?<path>.*), /$\\{path}/$\\{path}/v3/api-docs\n\ngateway:\n  aes:\n    encode-key: \'CBTU1dD4Kd5pyiGWTsI10jRQ3SvKusSV\'\n    encode-iv: \'DYgjCEIMVrj2W9xN\'\n    encode-mode: \'CBC\'\n    encode-padding: \'PKCS7Padding\'\n  #不校验验证码的客户端\n  ignore-clients:\n    - kxs\n\n    \nknife4j:\n  gateway:\n    enabled: true\n    tags-sorter: order\n    operations-sorter: order\n    strategy: manual\n    routes:\n      - name: 权限管理\n        url: /v1/kxs/admin/v3/api-docs?group=default\n        service-name: upms\n        context-path: /admin\n   \n      ', '937bc0ed7dcfaed130db2fc54a5e87a0', '2023-12-04 11:22:40', '2023-12-04 11:22:40', 'nacos', '192.168.65.1', 'U', '', '');
    230. 

  230. INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (4, 75, 'kxs-gateway-dev.yml', 'DEFAULT_GROUP', '', 'spring:\n  cloud:\n    gateway:\n      locator:\n        enabled: true\n      routes:\n        #ADMIN 模块\n        - id: kxs-system-biz\n          uri: lb://kxs-system-biz\n          predicates:\n            - Path=/admin/**\n          filters:\n            # 限流配置\n            - name: RequestRateLimiter\n              args:\n                key-resolver: \'#{@remoteAddrKeyResolver}\'\n                redis-rate-limiter.replenishRate: 100\n                redis-rate-limiter.burstCapacity: 200\n            # 解密过滤器\n            - RequestDecoderFilter\n            # 验证码处理\n            - ValidateCodeGatewayFilter #如果该服务需要验证码则开启此过滤器\n        #用户模块\n        - id: kxs-user-biz\n          uri: lb://kxs-user-biz\n          predicates:\n            - Path=/user/**\n          filters:\n            # 限流配置\n            - name: RequestRateLimiter\n              args:\n                key-resolver: \'#{@remoteAddrKeyResolver}\'\n                redis-rate-limiter.replenishRate: 100\n                redis-rate-limiter.burstCapacity: 200\n            # 解密过滤器\n            - RequestDecoderFilter\n        \n        # 代码生成模块\n        - id: kxs-codegen\n          uri: lb://kxs-codegen\n          predicates:\n            - Path=/gen/**\n          filters:\n            # 过滤前缀\n            # - StripPrefix=3\n            # 解密过滤器\n            - RequestDecoderFilter\n\n        # 定时任务成模块\n        - id: kxs-quartz\n          uri: lb://kxs-quartz\n          predicates:\n            - Path=/job/**\n          filters:\n            # 解密过滤器\n            - RequestDecoderFilter\n        # 固定路由转发配置 无修改\n        - id: openapi\n          uri: lb://kxs-gateway\n          predicates:\n            - Path=/v3/api-docs/**\n          filters:\n            - RewritePath=/v3/api-docs/(?<path>.*), /$\\{path}/$\\{path}/v3/api-docs\n\ngateway:\n  aes:\n    encode-key: \'CBTU1dD4Kd5pyiGWTsI10jRQ3SvKusSV\'\n    encode-iv: \'DYgjCEIMVrj2W9xN\'\n    encode-mode: \'CBC\'\n    encode-padding: \'PKCS7Padding\'\n  #不校验验证码的客户端\n  ignore-clients:\n    - kxs\n\n    \nknife4j:\n  gateway:\n    enabled: true\n    tags-sorter: order\n    operations-sorter: order\n    strategy: manual\n    routes:\n      - name: 权限管理\n        url: /v1/kxs/admin/v3/api-docs?group=default\n        service-name: upms\n        context-path: /admin\n   \n      ', 'aec293ec98410e228ffce11c6a6b3e38', '2023-12-04 11:28:48', '2023-12-04 11:28:49', 'nacos', '192.168.65.1', 'U', '', '');
    231. 

  231. COMMIT;
    232. 

  232. 

  233. -- ----------------------------
    234. 

  234. -- Table structure for permissions
    235. 

  235. -- ----------------------------
    236. 

  236. DROP TABLE IF EXISTS `permissions`;
    237. 

  237. CREATE TABLE `permissions` (
    238. 

  238.   `role` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
    239. 

  239.   `resource` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
    240. 

  240.   `action` varchar(8) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
    241. 

  241.   UNIQUE KEY `uk_role_permission` (`role`,`resource`,`action`) USING BTREE
    242. 

  242. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
    243. 

  243. 

  244. -- ----------------------------
    245. 

  245. -- Records of permissions
    246. 

  246. -- ----------------------------
    247. 

  247. BEGIN;
    248. 

  248. COMMIT;
    249. 

  249. 

  250. -- ----------------------------
    251. 

  251. -- Table structure for roles
    252. 

  252. -- ----------------------------
    253. 

  253. DROP TABLE IF EXISTS `roles`;
    254. 

  254. CREATE TABLE `roles` (
    255. 

  255.   `username` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
    256. 

  256.   `role` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
    257. 

  257.   UNIQUE KEY `idx_user_role` (`username`,`role`) USING BTREE
    258. 

  258. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
    259. 

  259. 

  260. -- ----------------------------
    261. 

  261. -- Records of roles
    262. 

  262. -- ----------------------------
    263. 

  263. BEGIN;
    264. 

  264. INSERT INTO `roles` (`username`, `role`) VALUES ('nacos', 'ROLE_ADMIN');
    265. 

  265. COMMIT;
    266. 

  266. 

  267. -- ----------------------------
    268. 

  268. -- Table structure for tenant_capacity
    269. 

  269. -- ----------------------------
    270. 

  270. DROP TABLE IF EXISTS `tenant_capacity`;
    271. 

  271. CREATE TABLE `tenant_capacity` (
    272. 

  272.   `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
    273. 

  273.   `tenant_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT 'Tenant ID',
    274. 

  274.   `quota` int unsigned NOT NULL DEFAULT '0' COMMENT '配额，0表示使用默认值',
    275. 

  275.   `usage` int unsigned NOT NULL DEFAULT '0' COMMENT '使用量',
    276. 

  276.   `max_size` int unsigned NOT NULL DEFAULT '0' COMMENT '单个配置大小上限，单位为字节，0表示使用默认值',
    277. 

  277.   `max_aggr_count` int unsigned NOT NULL DEFAULT '0' COMMENT '聚合子配置最大个数',
    278. 

  278.   `max_aggr_size` int unsigned NOT NULL DEFAULT '0' COMMENT '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值',
    279. 

  279.   `max_history_count` int unsigned NOT NULL DEFAULT '0' COMMENT '最大变更历史数量',
    280. 

  280.   `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    281. 

  281.   `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
    282. 

  282.   PRIMARY KEY (`id`) USING BTREE,
    283. 

  283.   UNIQUE KEY `uk_tenant_id` (`tenant_id`) USING BTREE
    284. 

  284. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin ROW_FORMAT=DYNAMIC COMMENT='租户容量信息表';
    285. 

  285. 

  286. -- ----------------------------
    287. 

  287. -- Records of tenant_capacity
    288. 

  288. -- ----------------------------
    289. 

  289. BEGIN;
    290. 

  290. COMMIT;
    291. 

  291. 

  292. -- ----------------------------
    293. 

  293. -- Table structure for tenant_info
    294. 

  294. -- ----------------------------
    295. 

  295. DROP TABLE IF EXISTS `tenant_info`;
    296. 

  296. CREATE TABLE `tenant_info` (
    297. 

  297.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
    298. 

  298.   `kp` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'kp',
    299. 

  299.   `tenant_id` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT '' COMMENT 'tenant_id',
    300. 

  300.   `tenant_name` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT '' COMMENT 'tenant_name',
    301. 

  301.   `tenant_desc` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'tenant_desc',
    302. 

  302.   `create_source` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'create_source',
    303. 

  303.   `gmt_create` bigint NOT NULL COMMENT '创建时间',
    304. 

  304.   `gmt_modified` bigint NOT NULL COMMENT '修改时间',
    305. 

  305.   PRIMARY KEY (`id`) USING BTREE,
    306. 

  306.   UNIQUE KEY `uk_tenant_info_kptenantid` (`kp`,`tenant_id`) USING BTREE,
    307. 

  307.   KEY `idx_tenant_id` (`tenant_id`) USING BTREE
    308. 

  308. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin ROW_FORMAT=DYNAMIC COMMENT='tenant_info';
    309. 

  309. 

  310. -- ----------------------------
    311. 

  311. -- Records of tenant_info
    312. 

  312. -- ----------------------------
    313. 

  313. BEGIN;
    314. 

  314. COMMIT;
    315. 

  315. 

  316. -- ----------------------------
    317. 

  317. -- Table structure for users
    318. 

  318. -- ----------------------------
    319. 

  319. DROP TABLE IF EXISTS `users`;
    320. 

  320. CREATE TABLE `users` (
    321. 

  321.   `username` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
    322. 

  322.   `password` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
    323. 

  323.   `enabled` tinyint(1) NOT NULL,
    324. 

  324.   PRIMARY KEY (`username`) USING BTREE
    325. 

  325. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
    326. 

  326. 

  327. -- ----------------------------
    328. 

  328. -- Records of users
    329. 

  329. -- ----------------------------
    330. 

  330. BEGIN;
    331. 

  331. INSERT INTO `users` (`username`, `password`, `enabled`) VALUES ('nacos', '$2a$10$EuWPZHzz32dJN7jexM34MOeYirDdFAZm2kuWj7VEOJhhZkDrxfvUu', 1);
    332. 

  332. COMMIT;
    333. 

  333. 

  334. SET FOREIGN_KEY_CHECKS = 1;
    335.