• 【Nacos】1.docker-compose 安装nacos 2.1.0 报错 no datasource set

    总结：

            如何优雅安装nacos，请参考解决方案。

    场景：

            单体架构拆分后，微服务越来越多，需要注册中心管理（前期因为工作忙无法一开始使用注册中心），选用nacos，所以数据库已经安装，官方文档提供的例子适合没有安装mysql的前提下使用。

    环境：docker-compose 安装 nacos 2.1.0 ，已安装mysql，且账号/密码非:root/root

    报错：

            no datasource set    ：没有设置数据库

            

    原因：

            数据库没有正常设置，如 数据库地址，数据库名称，账号，密码 哪个出错都会提示            no datasource set

    解决方案：

            这里只介绍docker-compose安装，其它方法见官方文档 

    • Step1：linux服务器下建立如下文件夹（自己指定目录，如 /opt/docker）
    1. mkdir -p ./nacos/logs                     #新建/opt/docker/logs/nacos目录
    2. mkdir -p ./nacos/init.d
    3. mkdir -p ./nacos/data
    4. touch ./nacos/init.d/custom.properties    #新建properties文件，暂时感觉没什么用
    •  Step2：新建docker-compose.yaml文件

    设置数据库地址，数据库名称，账号，密码

    1. version: "3.1"
    2. services:
    3.   nacos:
    4.     image: nacos/nacos-server:latest
    5.     container_name: nacos
    6.     environment:
    7.       - PREFER_HOST_MODE=hostname
    8.       - MODE=standalone
    9.       - SPRING_DATASOURCE_PLATFORM=mysql
    10.       - MYSQL_SERVICE_HOST=48.108.188.88
    11.       - MYSQL_SERVICE_DB_NAME=nacos
    12.       - MYSQL_SERVICE_PORT=3306
    13.       - MYSQL_SERVICE_USER=root
    14.       - MYSQL_SERVICE_PASSWORD=password
    15.       - MYSQL_DATABASE_NUM=1
    16.     volumes:
    17.       - ./logs:/home/nacos/logs 
    18.       - ./init.d/custom.properties:/home/nacos/init.d/custom.properties 
    19.       - ./data:/home/nacos/data 
    20.     ports:
    21.       - "8848:8848"
    22.       - "9848:9848"
    23.       - "9849:9849" 
    24.     restart: always
    •  Step3：ip地址下建立数据库，并执行如下脚本（这里是mysql 5.7的脚本）见附录
    •  Step4：cd /opt/docker 执行 docker-compose up -d
    •  Step5：进入nacos 页面 http://ip:8848/nacos

    其它问题：

    1. nacos 非 2.1.0 （一般大版本才会改变量名，如。1.XX.XX ）
    2. mysql 非5.7

    解决方法：

    • nacos配置文件地址（不同大版本，参数有所不同更改docker-compose.yam环境变量名）

    变量命名需要参考nacos容器中的application.properties , ${} 变量名

    1. docker exec -it nacos /bin/bash
    2. cd /home/nacos/conf
    3. vi application.properties
    1. db.url.1=jdbc:mysql://${MYSQL_SERVICE_HOST}:${MYSQL_SERVICE_PORT:3306}/${MYSQL_SERVICE_DB_NAME}?${MYSQL_SERVICE_DB_PARAM:characterEncoding=utf8&connectTimeout=1000&socketTimeout=3000&autoReconnect=true&useSSL=false}
    2. db.user=${MYSQL_SERVICE_USER}
    3. db.password=${MYSQL_SERVICE_PASSWORD}
    4. ### The auth system to use, currently only 'nacos' is supported:
    5. nacos.core.auth.system.type=${NACOS_AUTH_SYSTEM_TYPE:nacos}
    6.  
    7.  
    8. ### The token expiration in seconds:
    9. nacos.core.auth.default.token.expire.seconds=${NACOS_AUTH_TOKEN_EXPIRE_SECONDS:18000}
    10.  
    11. ### The default token:
    12. nacos.core.auth.default.token.secret.key=${NACOS_AUTH_TOKEN:SecretKey012345678901234567890123456789012345678901234567890123456789}
    13.  
    14. ### Turn on/off caching of auth information. By turning on this switch, the update of auth information would have a 15 seconds delay.
    15. nacos.core.auth.caching.enabled=${NACOS_AUTH_CACHE_ENABLE:false}
    16. nacos.core.auth.enable.userAgentAuthWhite=${NACOS_AUTH_USER_AGENT_AUTH_WHITE_ENABLE:false}
    17. nacos.core.auth.server.identity.key=${NACOS_AUTH_IDENTITY_KEY:serverIdentity}
    18. nacos.core.auth.server.identity.value=${NACOS_AUTH_IDENTITY_VALUE:security}
    19. server.tomcat.accesslog.enabled=${TOMCAT_ACCESSLOG_ENABLED:false}
    20. server.tomcat.accesslog.pattern=%h %l %u %t "%r" %s %b %D
    21. # default current work dir
    22. server.tomcat.basedir=
    23. ## spring security config
    24. ### turn off security
    25. nacos.security.ignore.urls=${NACOS_SECURITY_IGNORE_URLS:/,/error,/**/*.css,/**/*.js,/**/*.html,/**/*.map,/**/*.svg,/**/*.png,/**/*.ico,/console-fe/public/**,/v1/auth/**,/v1/console/health/**,/actuator/**,/v1/console/server/**}
    26. # metrics for elastic search
    27. management.metrics.export.elastic.enabled=false
    28. management.metrics.export.influx.enabled=false
    29.  
    30. nacos.naming.distro.taskDispatchThreadCount=10
    31. nacos.naming.distro.taskDispatchPeriod=200
    32. nacos.naming.distro.batchSyncKeyCount=1000
    33. nacos.naming.distro.initDataRatio=0.9
    34. nacos.naming.distro.syncRetryDelay=5000
    35. nacos.naming.data.warmup=true

         

    附录：

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

  • 相关阅读:
    【设计模式深度剖析】【2】【结构型】【装饰器模式】| 以去咖啡馆买咖啡为例 | 以穿衣服出门类比
    SpringBoot微服务的发布与部署（3种方式）
    俯瞰·明攻山西之战（太原之战）
    Spring加载后置处理器方式之模板方法
    计算机毕业设计之java+ssm服装定制系统
    SpringBoot发送请求与匹配响应信息
    AsynchronousSocketChannel http server 接收浏览器请求 java代码 并获取浏览器请求路径
    负载平衡介绍
    金融级国产化替代中间件有哪些？
    springboot基础(60):完整的自定义ip-spring-boot-starter(包含yml提示功能)
  • 原文地址：https://blog.csdn.net/ladymorgana/article/details/126260611