nacos配置mysql建表语句
时间: 2023-09-13 08:10:08 浏览: 167
nacos配置mysql的建表语句可以在使用mysql作为数据源时使用。根据引用[2]中提供的资料,nacos数据库的建表语句如下:
CREATE TABLE `config_info` (
`data_id` varchar(255) NOT NULL,
`group_id` varchar(32) NOT NULL,
`content` mediumtext NOT NULL,
`md5` varchar(32) DEFAULT NULL,
`gmt_create` datetime DEFAULT CURRENT_TIMESTAMP,
`gmt_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`src_user` varchar(64) DEFAULT NULL,
`src_ip` varchar(64) DEFAULT NULL,
`app_name` varchar(128) DEFAULT NULL,
`tenant_id` varchar(32) DEFAULT NULL,
PRIMARY KEY (`data_id`,`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
这是nacos中用于存储配置信息的表结构。你可以在mysql中执行以上建表语句来创建nacos的配置信息表。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *3* [Mysql表结构转Postgresql建表语句快速操作](https://blog.csdn.net/qq_42105629/article/details/123526928)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
- *2* [NACOS以MySQL为数据源的SQL导入文件](https://download.csdn.net/download/AlexanderRon/84270909)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]
阅读全文