develop
/
digimeta-MultiSaas
12
0
Форкнуть 0
Код Задачи 0 Pull Request'ы 0 Релизы 149 Вики Активность
数字人管理平台
Вы не можете выбрать более 25 тем Темы должны начинаться с буквы или цифры, могут содержать дефисы(-) и должны содержать не более 35 символов.
1506 коммитов
39 Ветки
647 MiB
 
 
 
 
 
 
ветка: main
Ветки Теги
${ item.name }
Создать ветку ${ searchTerm }
из 'main'
${ noResults }
digimeta-MultiSaas/sql/xy_config.sql

221 строка
26 KiB
Исходник Постоянная ссылка Вина История 

  1. CREATE DATABASE  IF NOT EXISTS `xy-config` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

  2. 

  3. SET NAMES utf8mb4;

  4. SET FOREIGN_KEY_CHECKS = 0;

  5. #

  6. USE `xy-config`;

  7. 

  8. /******************************************/

  9. /*   表名称 = config_info   */

  10. /******************************************/

  11. drop table if exists `config_info`;

  12. CREATE TABLE `config_info` (

  13.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',

  14.   `data_id` varchar(255) NOT NULL COMMENT 'data_id',

  15.   `group_id` varchar(255) DEFAULT NULL,

  16.   `content` longtext NOT NULL COMMENT 'content',

  17.   `md5` varchar(32) DEFAULT NULL COMMENT 'md5',

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

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

  20.   `src_user` text COMMENT 'source user',

  21.   `src_ip` varchar(50) DEFAULT NULL COMMENT 'source ip',

  22.   `app_name` varchar(128) DEFAULT NULL,

  23.   `tenant_id` varchar(128) DEFAULT '' COMMENT '租户字段',

  24.   `c_desc` varchar(256) DEFAULT NULL,

  25.   `c_use` varchar(64) DEFAULT NULL,

  26.   `effect` varchar(64) DEFAULT NULL,

  27.   `type` varchar(64) DEFAULT NULL,

  28.   `c_schema` text,

  29.   `encrypted_data_key` text COMMENT '秘钥',

  30.   PRIMARY KEY (`id`),

  31.   UNIQUE KEY `uk_configinfo_datagrouptenant` (`data_id`,`group_id`,`tenant_id`)

  32. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info';

  33. 

  34. 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)

  35. VALUES (1, 'application-dev.yml', 'DEFAULT_GROUP', 'spring:\r\n  autoconfigure:\r\n    exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure\r\n  mvc:\r\n    pathmatch:\r\n      matching-strategy: ant_path_matcher\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  client:\r\n    config:\r\n      default:\r\n        connectTimeout: 10000\r\n        readTimeout: 10000\r\n  compression:\r\n    request:\r\n      enabled: true\r\n    response:\r\n      enabled: true\r\n\r\n# 暴露监控端点\r\nmanagement:\r\n  endpoints:\r\n    web:\r\n      exposure:\r\n        include: ''*''\r\n', 'db868af6c3e2b2bbc45a12787a3c33f6', '2022-02-01 16:11:30', '2022-02-01 16:11:30', null, '0:0:0:0:0:0:0:1', '', '', '通用配置', 'null', 'null', 'yaml'),

  36.        (2, 'application-secret-dev.yml', 'DEFAULT_GROUP', 'secret:\r\n  #redis参数信息\r\n  redis:\r\n    host: localhost\r\n    port: 6381\r\n    password:\r\n  #服务状态监控参数信息\r\n  security:\r\n    name: xueyi\r\n    password: xueyi123\r\n    title: 服务状态监控\r\n  # swagger参数信息\r\n  swagger:\r\n    title: 接口文档\r\n    license: Powered By xueyi\r\n    licenseUrl: https://doc.xueyitt.cn\r\n  # datasource主库参数信息\r\n  datasource:\r\n    driver-class-name: com.mysql.cj.jdbc.Driver\r\n    url: jdbc:mysql://172.17.0.1:3308/xy-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&allowMultiQueries=true&serverTimezone=GMT%2B8\r\n    username: root\r\n    password: password\r\n  # druid控制台参数信息\r\n  druid:\r\n    stat-view-servlet:\r\n      enabled: true\r\n      loginUsername: admin\r\n      loginPassword: 123456\r\n  # nacos参数信息\r\n  nacos:\r\n    serverAddr: 172.17.0.1:18848', 'c28955605f738593b0f70a6cc3816a11', '2022-02-01 16:11:30', '2022-04-07 07:46:59', null, '192.168.73.204', '', '', '通用参数配置', 'null', 'null', 'yaml'),

  37.        (3, 'application-datasource-dev.yml', 'DEFAULT_GROUP', '# spring配置\r\nspring: \r\n  redis:\r\n    host: ${secret.redis.host}\r\n    port: ${secret.redis.port}\r\n    password: ${secret.redis.password}\r\n  datasource:\r\n    druid:\r\n      stat-view-servlet:\r\n        enabled: ${secret.druid.stat-view-servlet.enabled}\r\n        loginUsername: ${secret.druid.stat-view-servlet.loginUsername}\r\n        loginPassword: ${secret.druid.stat-view-servlet.loginPassword}\r\n    dynamic:\r\n      druid:\r\n        initial-size: 5\r\n        min-idle: 5\r\n        maxActive: 20\r\n        maxWait: 60000\r\n        timeBetweenEvictionRunsMillis: 60000\r\n        minEvictableIdleTimeMillis: 300000\r\n        validationQuery: SELECT 1 FROM DUAL\r\n        testWhileIdle: true\r\n        testOnBorrow: false\r\n        testOnReturn: false\r\n        poolPreparedStatements: true\r\n        breakAfterAcquireFailure: true\r\n        ConnectionErrorRetryAttempts: 2\r\n        maxPoolPreparedStatementPerConnectionSize: 20\r\n        filters: stat,slf4j\r\n        connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000\r\n      datasource:\r\n          # 主库数据源\r\n          master:\r\n            driver-class-name: ${secret.datasource.driver-class-name}\r\n            url: ${secret.datasource.url}\r\n            username: ${secret.datasource.username}\r\n            password: ${secret.datasource.password}\r\n          # 数据源信息会通过master库进行获取并生成，请在主库的xy_tenant_source中配置即可\r\n      # seata: true    # 开启seata代理，开启后默认每个数据源都代理，如果某个不需要代理可单独关闭\r\n\r\n# mybatis-plus配置\r\nmybatis-plus:\r\n  global-config:\r\n    # 是否控制台 print mybatis-plus 的 LOGO\r\n    banner: false\r\n    db-config:\r\n      # 字段验证策略之 select\r\n      selectStrategy: NOT_EMPTY\r\n      # 字段验证策略之 insert\r\n      insertStrategy: NOT_NULL\r\n      # 字段验证策略之 update\r\n      updateStrategy: IGNORED\r\n      # 全局逻辑删除的实体字段名\r\n      logic-delete-field: delFlag\r\n      # 逻辑已删除值\r\n      logic-delete-value: 1\r\n      # 逻辑未删除值\r\n      logic-not-delete-value: 0\r\n  # configuration:\r\n    # log-impl: org.apache.ibatis.logging.stdout.StdOutImpl\r\n\r\n# seata配置\r\nseata:\r\n  # 默认关闭，如需启用spring.datasource.dynami.seata需要同时开启\r\n  enabled: false\r\n  # Seata 应用编号，默认为 ${spring.application.name}\r\n  application-id: ${spring.application.name}\r\n  # Seata 事务组编号，用于 TC 集群名\r\n  tx-service-group: ${spring.application.name}-group\r\n  # 关闭自动代理\r\n  enable-auto-data-source-proxy: false\r\n  config:\r\n    type: nacos\r\n    nacos:\r\n      serverAddr: ${secret.nacos.serverAddr}\r\n      group: SEATA_GROUP\r\n      namespace:\r\n  registry:\r\n    type: nacos\r\n    nacos:\r\n      application: seata-server\r\n      server-addr: ${secret.nacos.serverAddr}\r\n      namespace:\r\n', '3e7f0ebc7439a0e1d997404a6b473aa9', '2022-02-01 16:11:30', '2022-04-07 08:59:58', null, '192.168.73.204', '', '', '通用动态多数据源配置', 'null', 'null', 'yaml'),

  38.        (4, 'xueyi-gateway-dev.yml', 'DEFAULT_GROUP', '# spring配置\r\nspring:\r\n  redis:\r\n    host: ${secret.redis.host}\r\n    port: ${secret.redis.port}\r\n    password: ${secret.redis.password}\r\n  cloud:\r\n    gateway:\r\n      discovery:\r\n        locator:\r\n          lowerCaseServiceId: true\r\n          enabled: true\r\n      routes:\r\n        # 认证中心\r\n        - id: xueyi-auth\r\n          uri: lb://xueyi-auth\r\n          predicates:\r\n            - Path=/auth/**\r\n          filters:\r\n            # 验证码处理\r\n            - CacheRequestFilter\r\n            - ValidateCodeFilter\r\n            - StripPrefix=1\r\n        # 代码生成\r\n        - id: xueyi-gen\r\n          uri: lb://xueyi-gen\r\n          predicates:\r\n            - Path=/code/**\r\n          filters:\r\n            - StripPrefix=1\r\n        # 定时任务\r\n        - id: xueyi-job\r\n          uri: lb://xueyi-job\r\n          predicates:\r\n            - Path=/schedule/**\r\n          filters:\r\n            - StripPrefix=1\r\n        # 系统模块\r\n        - id: xueyi-system\r\n          uri: lb://xueyi-system\r\n          predicates:\r\n            - Path=/system/**\r\n          filters:\r\n            - StripPrefix=1\r\n        # 租户模块\r\n        - id: xueyi-tenant\r\n          uri: lb://xueyi-tenant\r\n          predicates:\r\n            - Path=/tenant/**\r\n          filters:\r\n            - StripPrefix=1\r\n        # 文件服务\r\n        - id: xueyi-file\r\n          uri: lb://xueyi-file\r\n          predicates:\r\n            - Path=/file/**\r\n          filters:\r\n            - StripPrefix=1\r\n\r\n# 安全配置\r\nsecurity:\r\n  # 验证码\r\n  captcha:\r\n    enabled: true\r\n    type: math\r\n  # 防止XSS攻击\r\n  xss:\r\n    enabled: true\r\n    excludeUrls:\r\n      - /system/notice\r\n  # 不校验白名单\r\n  ignore:\r\n    whites:\r\n      - /auth/logout\r\n      - /auth/login\r\n      - /auth/register\r\n      - /*/v3/api-docs\r\n      - /csrf\r\n', '20c5e882255155e0594f03af0877804a', '2022-02-01 16:11:30', '2022-04-07 07:47:32', null, '192.168.73.204', '', '', '网关模块', 'null', 'null', 'yaml'),

  39.        (5, 'xueyi-auth-dev.yml', 'DEFAULT_GROUP', '# spring配置\r\nspring:\r\n  redis:\r\n    host: ${secret.redis.host}\r\n    port: ${secret.redis.port}\r\n    password: ${secret.redis.password}\r\n', 'b7354e1eb62c2d846d44a796d9ec6930', '2022-02-01 16:11:30', '2022-02-01 16:11:30', null, '0:0:0:0:0:0:0:1', '', '', '认证中心', 'null', 'null', 'yaml'),

  40.        (6, 'xueyi-monitor-dev.yml', 'DEFAULT_GROUP', '# spring配置\r\nspring:\r\n  security:\r\n    user:\r\n      name: ${secret.security.name}\r\n      password: ${secret.security.password}\r\n  boot:\r\n    admin:\r\n      ui:\r\n        title: ${secret.security.title}\r\n', 'd8997d0707a2fd5d9fc4e8409da38129', '2022-02-01 16:11:30', '2022-02-01 16:11:30', null, '0:0:0:0:0:0:0:1', '', '', '监控中心', 'null', 'null', 'yaml'),

  41.        (7, 'xueyi-tenant-dev.yml', 'DEFAULT_GROUP', 'xueyi:\r\n  # 租户配置\r\n  tenant:\r\n    # 公共表配置\r\n    common-table:\r\n      - sys_menu\r\n      - sys_module\r\n    # 非租户表配置\r\n    exclude-table:\r\n      - te_tenant\r\n      - te_strategy\r\n      - te_source\r\n\r\n# mybatis-plus配置\r\nmybatis-plus:\r\n  # 搜索指定包别名\r\n  typeAliasesPackage: com.xueyi.tenant\r\n  # 配置mapper的扫描，找到所有的mapper.xml映射文件\r\n  mapperLocations: classpath:mapper/**/*.xml\r\n\r\n# swagger配置\r\nswagger:\r\n  title: 租户模块${secret.swagger.title}\r\n  license: ${secret.swagger.license}\r\n  licenseUrl: ${secret.swagger.licenseUrl}\r\n\r\n#seata配置\r\nseata:\r\n  # 服务配置项\r\n  service:\r\n    # 虚拟组和分组的映射\r\n    vgroup-mapping:\r\n      xueyi-tenant-group: default\r\n', '840ef59c3cea0d055675ac638f90a09d', '2022-02-01 16:11:30', '2022-04-07 07:44:52', null, '192.168.73.204', '', '', '租户管理模块', 'null', 'null', 'yaml'),

  42.        (8, 'xueyi-system-dev.yml', 'DEFAULT_GROUP', 'xueyi:\r\n  # 租户配置\r\n  tenant:\r\n    # 公共表配置\r\n    common-table:\r\n      - sys_menu\r\n      - sys_module\r\n    # 非租户表配置\r\n    exclude-table:\r\n      - te_tenant\r\n      - te_strategy\r\n      - sys_dict_type\r\n      - sys_dict_data\r\n      - sys_config\r\n\r\n# mybatis-plus配置\r\nmybatis-plus:\r\n  # 搜索指定包别名\r\n  typeAliasesPackage: com.xueyi.system\r\n  # 配置mapper的扫描，找到所有的mapper.xml映射文件\r\n  mapperLocations: classpath:mapper/**/*.xml\r\n\r\n# swagger配置\r\nswagger:\r\n  title: 系统模块${secret.swagger.title}\r\n  license: ${secret.swagger.license}\r\n  licenseUrl: ${secret.swagger.licenseUrl}\r\n\r\n#seata配置\r\nseata:\r\n  # 服务配置项\r\n  service:\r\n    # 虚拟组和分组的映射\r\n    vgroup-mapping:\r\n      xueyi-system-group: default', 'cc2fef8a73408605894dd30d36db445e', '2022-02-01 16:11:30', '2022-04-07 07:41:51', null, '192.168.73.204', '', '', '系统模块', 'null', 'null', 'yaml'),

  43.        (9, 'xueyi-gen-dev.yml', 'DEFAULT_GROUP', 'xueyi:\n  # 租户配置\n  tenant:\n    # 非租户表配置\n    exclude-table:\n      - gen_table\n      - gen_table_column\n\n# mybatis-plus配置\nmybatis-plus:\n  # 搜索指定包别名\n  typeAliasesPackage: com.xueyi.gen\n  # 配置mapper的扫描，找到所有的mapper.xml映射文件\n  mapperLocations: classpath:mapper/**/*.xml\n  configuration:\n    jdbc-type-for-null: \'null\'\n\n# swagger配置\nswagger:\n  title: 代码生成${secret.swagger.title}\n  license: ${secret.swagger.license}\n  licenseUrl: ${secret.swagger.licenseUrl}\n\n# 代码生成\ngen: \n  # 作者\n  author: xueyi\n  # ui路径（空代表生成在后端主路径下，可设置为ui项目地址如：C:UsersxueyiMultiSaas-UI）\n  uiPath: \n  # 自动去除表前缀，默认是true\n  autoRemovePre: true\n  # 数据库映射\n  data-base:\n    # 字符串类型\n    type-str: [\"char\", \"varchar\", \"nvarchar\", \"varchar2\"]\n    # 文本类型\n    type-text: [\"tinytext\", \"text\", \"mediumtext\", \"longtext\"]\n    # 日期类型\n    type-date: [\"datetime\", \"time\", \"date\", \"timestamp\"]\n    # 时间类型\n    type-time: [\"datetime\", \"time\", \"date\", \"timestamp\"]\n    # 数字类型\n    type-number: [\"tinyint\", \"smallint\", \"mediumint\", \"int\", \"number\", \"integer\"]\n    # 长数字类型\n    type-long: [\"bigint\"]\n    # 浮点类型\n    type-float: [\"float\", \"double\", \"decimal\"]\n  # 字段配置\n  operate:\n    # 隐藏详情显示\n    not-view: [\"id\", \"createBy\", \"createTime\", \"updateBy\", \"updateTime\"]\n    # 隐藏新增显示\n    not-insert: [\"id\", \"createBy\", \"createTime\", \"updateBy\", \"updateTime\"]\n    # 隐藏编辑显示\n    not-edit: [\"id\", \"createBy\", \"createTime\", \"updateBy\", \"updateTime\"]\n    # 隐藏列表显示\n    not-list: [\"id\", \"createBy\", \"createTime\", \"updateBy\", \"updateTime\", \"remark\"]\n    # 隐藏查询显示\n    not-query: [\"id\", \"sort\", \"createBy\", \"createTime\", \"updateBy\", \"updateTime\", \"remark\"]\n    # 隐藏导入显示\n    not-import: [\"id\", \"createBy\", \"createTime\", \"updateBy\", \"updateTime\"]\n    # 隐藏导出显示\n    not-export: [\"id\", \"sort\", \"createBy\", \"updateBy\"]\n  # 基类配置\n  entity:\n    # 必定隐藏字段（前后端均隐藏）\n    must-hide: [\"delFlag\", \"tenantId\", \"ancestors\"]\n    # 后端基类\n    back:\n      base: [\"id\", \"name\", \"status\", \"sort\", \"remark\", \"createBy\", \"createTime\", \"updateBy\", \"updateTime\", \"delFlag\"]\n      tree: [\"parentId\", \"ancestors\", \"level\"]\n      tenant: [\"tenantId\"]\n      common: [\"isCommon\"]\n    # 前端基类\n    front:\n      base: [\"createBy\", \"createName\", \"createTime\", \"updateBy\", \"updateName\", \"updateTime\", \"delFlag\"]\n      tree: [\"parentId\", \"ancestors\", \"level\"]\n      tenant: [\"tenantId\"]\n      common: [\"isCommon\"]\n  # 表前缀（与remove-lists对应）\n  dict-type-remove: [\"sys_\", \"te_\", \"gen_\"]\n  # 表更替配置\n  remove-lists:\n      # 表前缀（生成类名不会包含表前缀）\n    - prefix: sys_\n      # 默认生成包路径 system 需改成自己的模块名称 如 system monitor tool\n      packageName: com.xueyi.system\n      frontPackageName: system\n    - prefix: te_\n      packageName: com.xueyi.tenant\n      frontPackageName: tenant\n    - prefix: gen_\n      packageName: com.xueyi.gen\n      frontPackageName: gen\n', '7d5029b9e5871b8a1c7f717f9d7ba436', '2022-02-01 16:11:30', '2022-12-14 13:26:22', NULL, '192.168.31.40', '', '', '代码生成', 'null', 'null', 'yaml'),

  44.        (10, 'xueyi-job-dev.yml', 'DEFAULT_GROUP', '# mybatis-plus配置\r\nmybatis-plus:\r\n  # 搜索指定包别名\r\n  typeAliasesPackage: com.xueyi.job\r\n  # 配置mapper的扫描，找到所有的mapper.xml映射文件\r\n  mapperLocations: classpath:mapper/**/*.xml\r\n\r\n# swagger配置\r\nswagger:\r\n  title: 定时任务${secret.swagger.title}\r\n  license: ${secret.swagger.license}\r\n  licenseUrl: ${secret.swagger.licenseUrl}\r\n\r\n# seata配置\r\nseata:\r\n  # 服务配置项\r\n  service:\r\n    # 虚拟组和分组的映射\r\n    vgroup-mapping:\r\n      xueyi-job-group: default\r\n', 'ebb507f8a468ef381b4948ae7ecd5017', '2022-02-01 16:11:30', '2022-04-07 08:02:40', null, '192.168.73.204', '', '', '定时任务', 'null', 'null', 'yaml'),

  45.        (11, 'xueyi-file-dev.yml', 'DEFAULT_GROUP', '# spring配置\r\nspring:\r\n  redis:\r\n    host: ${secret.redis.host}\r\n    port: ${secret.redis.port}\r\n    password: ${secret.redis.password}\r\n\r\n# 本地文件上传\r\nfile:\r\n  domain: http://127.0.0.1:9300\r\n  path: D:/xueyi/uploadPath\r\n  prefix: /statics\r\n\r\n# FastDFS配置\r\nfdfs:\r\n  domain: http://8.129.231.12\r\n  soTimeout: 3000\r\n  connectTimeout: 2000\r\n  trackerList: 8.129.231.12:22122\r\n\r\n# Minio配置\r\nminio:\r\n  url: http://8.129.231.12:9000\r\n  accessKey: minioadmin\r\n  secretKey: minioadmin\r\n  bucketName: test', 'e507ba4ba82516bd5b9d1bea147bd910', '2022-02-01 16:11:30', '2022-04-07 07:45:53', null, '192.168.73.204', '', '', '文件服务', 'null', 'null', 'yaml'),

  46.        (12, 'sentinel-xueyi-gateway', 'DEFAULT_GROUP', '[\r\n    {\r\n        "resource": "xueyi-auth",\r\n        "count": 500,\r\n        "grade": 1,\r\n        "limitApp": "default",\r\n        "strategy": 0,\r\n        "controlBehavior": 0\r\n    },\r\n	{\r\n        "resource": "xueyi-system",\r\n        "count": 1000,\r\n        "grade": 1,\r\n        "limitApp": "default",\r\n        "strategy": 0,\r\n        "controlBehavior": 0\r\n    },\r\n	{\r\n        "resource": "xueyi-tenant",\r\n        "count": 500,\r\n        "grade": 1,\r\n        "limitApp": "default",\r\n        "strategy": 0,\r\n        "controlBehavior": 0\r\n    },\r\n	{\r\n        "resource": "xueyi-gen",\r\n        "count": 200,\r\n        "grade": 1,\r\n        "limitApp": "default",\r\n        "strategy": 0,\r\n        "controlBehavior": 0\r\n    },\r\n	{\r\n        "resource": "xueyi-job",\r\n        "count": 300,\r\n        "grade": 1,\r\n        "limitApp": "default",\r\n        "strategy": 0,\r\n        "controlBehavior": 0\r\n    }\r\n]', '9f3a3069261598f74220bc47958ec252', '2022-02-01 16:11:30', '2022-02-01 16:11:30', null, '0:0:0:0:0:0:0:1', '', '', '限流策略', 'null', 'null', 'json');

  47. 

  48. /******************************************/

  49. /*   表名称 = config_info_aggr   */

  50. /******************************************/

  51. CREATE TABLE `config_info_aggr` (

  52.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',

  53.   `data_id` varchar(255) NOT NULL COMMENT 'data_id',

  54.   `group_id` varchar(255) NOT NULL COMMENT 'group_id',

  55.   `datum_id` varchar(255) NOT NULL COMMENT 'datum_id',

  56.   `content` longtext NOT NULL COMMENT '内容',

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

  58.   `app_name` varchar(128) DEFAULT NULL,

  59.   `tenant_id` varchar(128) DEFAULT '' COMMENT '租户字段',

  60.   PRIMARY KEY (`id`),

  61.   UNIQUE KEY `uk_configinfoaggr_datagrouptenantdatum` (`data_id`,`group_id`,`tenant_id`,`datum_id`)

  62. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='增加租户字段';

  63. 

  64. 

  65. /******************************************/

  66. /*   表名称 = config_info_beta   */

  67. /******************************************/

  68. CREATE TABLE `config_info_beta` (

  69.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',

  70.   `data_id` varchar(255) NOT NULL COMMENT 'data_id',

  71.   `group_id` varchar(128) NOT NULL COMMENT 'group_id',

  72.   `app_name` varchar(128) DEFAULT NULL COMMENT 'app_name',

  73.   `content` longtext NOT NULL COMMENT 'content',

  74.   `beta_ips` varchar(1024) DEFAULT NULL COMMENT 'betaIps',

  75.   `md5` varchar(32) DEFAULT NULL COMMENT 'md5',

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

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

  78.   `src_user` text COMMENT 'source user',

  79.   `src_ip` varchar(50) DEFAULT NULL COMMENT 'source ip',

  80.   `tenant_id` varchar(128) DEFAULT '' COMMENT '租户字段',

  81.   `encrypted_data_key` text COMMENT '秘钥',

  82.   PRIMARY KEY (`id`),

  83.   UNIQUE KEY `uk_configinfobeta_datagrouptenant` (`data_id`,`group_id`,`tenant_id`)

  84. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info_beta';

  85. 

  86. /******************************************/

  87. /*   表名称 = config_info_tag   */

  88. /******************************************/

  89. CREATE TABLE `config_info_tag` (

  90.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',

  91.   `data_id` varchar(255) NOT NULL COMMENT 'data_id',

  92.   `group_id` varchar(128) NOT NULL COMMENT 'group_id',

  93.   `tenant_id` varchar(128) DEFAULT '' COMMENT 'tenant_id',

  94.   `tag_id` varchar(128) NOT NULL COMMENT 'tag_id',

  95.   `app_name` varchar(128) DEFAULT NULL COMMENT 'app_name',

  96.   `content` longtext NOT NULL COMMENT 'content',

  97.   `md5` varchar(32) DEFAULT NULL COMMENT 'md5',

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

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

  100.   `src_user` text COMMENT 'source user',

  101.   `src_ip` varchar(50) DEFAULT NULL COMMENT 'source ip',

  102.   PRIMARY KEY (`id`),

  103.   UNIQUE KEY `uk_configinfotag_datagrouptenanttag` (`data_id`,`group_id`,`tenant_id`,`tag_id`)

  104. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info_tag';

  105. 

  106. /******************************************/

  107. /*   表名称 = config_tags_relation   */

  108. /******************************************/

  109. CREATE TABLE `config_tags_relation` (

  110.   `id` bigint(20) NOT NULL COMMENT 'id',

  111.   `tag_name` varchar(128) NOT NULL COMMENT 'tag_name',

  112.   `tag_type` varchar(64) DEFAULT NULL COMMENT 'tag_type',

  113.   `data_id` varchar(255) NOT NULL COMMENT 'data_id',

  114.   `group_id` varchar(128) NOT NULL COMMENT 'group_id',

  115.   `tenant_id` varchar(128) DEFAULT '' COMMENT 'tenant_id',

  116.   `nid` bigint(20) NOT NULL AUTO_INCREMENT,

  117.   PRIMARY KEY (`nid`),

  118.   UNIQUE KEY `uk_configtagrelation_configidtag` (`id`,`tag_name`,`tag_type`),

  119.   KEY `idx_tenant_id` (`tenant_id`)

  120. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_tag_relation';

  121. 

  122. /******************************************/

  123. /*   表名称 = group_capacity   */

  124. /******************************************/

  125. CREATE TABLE `group_capacity` (

  126.   `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',

  127.   `group_id` varchar(128) NOT NULL DEFAULT '' COMMENT 'Group ID，空字符表示整个集群',

  128.   `quota` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '配额，0表示使用默认值',

  129.   `usage` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '使用量',

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

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

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

  133.   `max_history_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最大变更历史数量',

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

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

  136.   PRIMARY KEY (`id`),

  137.   UNIQUE KEY `uk_group_id` (`group_id`)

  138. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='集群、各Group容量信息表';

  139. 

  140. /******************************************/

  141. /*   表名称 = his_config_info   */

  142. /******************************************/

  143. CREATE TABLE `his_config_info` (

  144.   `id` bigint(64) unsigned NOT NULL,

  145.   `nid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

  146.   `data_id` varchar(255) NOT NULL,

  147.   `group_id` varchar(128) NOT NULL,

  148.   `app_name` varchar(128) DEFAULT NULL COMMENT 'app_name',

  149.   `content` longtext NOT NULL,

  150.   `md5` varchar(32) DEFAULT NULL,

  151.   `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

  152.   `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

  153.   `src_user` text,

  154.   `src_ip` varchar(50) DEFAULT NULL,

  155.   `op_type` char(10) DEFAULT NULL,

  156.   `tenant_id` varchar(128) DEFAULT '' COMMENT '租户字段',

  157.   `encrypted_data_key` text COMMENT '秘钥',

  158.   PRIMARY KEY (`nid`),

  159.   KEY `idx_gmt_create` (`gmt_create`),

  160.   KEY `idx_gmt_modified` (`gmt_modified`),

  161.   KEY `idx_did` (`data_id`)

  162. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='多租户改造';

  163. 

  164. 

  165. /******************************************/

  166. /*   数据库全名 = nacos_config   */

  167. /*   表名称 = tenant_capacity   */

  168. /******************************************/

  169. CREATE TABLE `tenant_capacity` (

  170.   `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',

  171.   `tenant_id` varchar(128) NOT NULL DEFAULT '' COMMENT 'Tenant ID',

  172.   `quota` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '配额，0表示使用默认值',

  173.   `usage` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '使用量',

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

  175.   `max_aggr_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '聚合子配置最大个数',

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

  177.   `max_history_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最大变更历史数量',

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

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

  180.   PRIMARY KEY (`id`),

  181.   UNIQUE KEY `uk_tenant_id` (`tenant_id`)

  182. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='租户容量信息表';

  183. 

  184. 

  185. CREATE TABLE `tenant_info` (

  186.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',

  187.   `kp` varchar(128) NOT NULL COMMENT 'kp',

  188.   `tenant_id` varchar(128) default '' COMMENT 'tenant_id',

  189.   `tenant_name` varchar(128) default '' COMMENT 'tenant_name',

  190.   `tenant_desc` varchar(256) DEFAULT NULL COMMENT 'tenant_desc',

  191.   `create_source` varchar(32) DEFAULT NULL COMMENT 'create_source',

  192.   `gmt_create` bigint(20) NOT NULL COMMENT '创建时间',

  193.   `gmt_modified` bigint(20) NOT NULL COMMENT '修改时间',

  194.   PRIMARY KEY (`id`),

  195.   UNIQUE KEY `uk_tenant_info_kptenantid` (`kp`,`tenant_id`),

  196.   KEY `idx_tenant_id` (`tenant_id`)

  197. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='tenant_info';

  198. 

  199. CREATE TABLE `users` (

  200. 	`username` varchar(50) NOT NULL PRIMARY KEY,

  201. 	`password` varchar(500) NOT NULL,

  202. 	`enabled` boolean NOT NULL

  203. );

  204. 

  205. CREATE TABLE `roles` (

  206. 	`username` varchar(50) NOT NULL,

  207. 	`role` varchar(50) NOT NULL,

  208. 	UNIQUE INDEX `idx_user_role` (`username` ASC, `role` ASC) USING BTREE

  209. );

  210. 

  211. CREATE TABLE `permissions` (

  212.     `role` varchar(50) NOT NULL,

  213.     `resource` varchar(255) NOT NULL,

  214.     `action` varchar(8) NOT NULL,

  215.     UNIQUE INDEX `uk_role_permission` (`role`,`resource`,`action`) USING BTREE

  216. );

  217. 

  218. INSERT INTO users (username, password, enabled) VALUES ('nacos', '$2a$10$EuWPZHzz32dJN7jexM34MOeYirDdFAZm2kuWj7VEOJhhZkDrxfvUu', TRUE);

  219. 

  220. INSERT INTO roles (username, role) VALUES ('nacos', 'ROLE_ADMIN');