From fc7bd9a35d8279f0a8257444e4ef4a04f6eee8eb Mon Sep 17 00:00:00 2001
From: RuoYi <yzz_ivy@163.com>
Date: Mon, 31 May 2021 14:53:50 +0800
Subject: [PATCH] 升级nacos到最新版2.0.1 性能提升
---
sql/ry_config_20210531.sql | 10 +++++-----
1 files changed, 5 insertions(+), 5 deletions(-)
diff --git a/sql/ry_config_20210228.sql b/sql/ry_config_20210531.sql
similarity index 98%
rename from sql/ry_config_20210228.sql
rename to sql/ry_config_20210531.sql
index f42393f..7312449 100644
--- a/sql/ry_config_20210228.sql
+++ b/sql/ry_config_20210531.sql
@@ -19,7 +19,7 @@
`gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
`src_user` text COMMENT 'source user',
- `src_ip` varchar(20) DEFAULT NULL COMMENT 'source ip',
+ `src_ip` varchar(50) DEFAULT NULL COMMENT 'source ip',
`app_name` varchar(128) DEFAULT NULL,
`tenant_id` varchar(128) DEFAULT '' COMMENT '租户字段',
`c_desc` varchar(256) DEFAULT NULL,
@@ -74,7 +74,7 @@
`gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
`src_user` text COMMENT 'source user',
- `src_ip` varchar(20) DEFAULT NULL COMMENT 'source ip',
+ `src_ip` varchar(50) DEFAULT NULL COMMENT 'source ip',
`tenant_id` varchar(128) DEFAULT '' COMMENT '租户字段',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_configinfobeta_datagrouptenant` (`data_id`,`group_id`,`tenant_id`)
@@ -95,7 +95,7 @@
`gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
`src_user` text COMMENT 'source user',
- `src_ip` varchar(20) DEFAULT NULL COMMENT 'source ip',
+ `src_ip` varchar(50) DEFAULT NULL COMMENT 'source ip',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_configinfotag_datagrouptenanttag` (`data_id`,`group_id`,`tenant_id`,`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info_tag';
@@ -148,7 +148,7 @@
`gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`src_user` text,
- `src_ip` varchar(20) DEFAULT NULL,
+ `src_ip` varchar(50) DEFAULT NULL,
`op_type` char(10) DEFAULT NULL,
`tenant_id` varchar(128) DEFAULT '' COMMENT '租户字段',
PRIMARY KEY (`nid`),
@@ -206,7 +206,7 @@
CREATE TABLE `permissions` (
`role` varchar(50) NOT NULL,
- `resource` varchar(512) NOT NULL,
+ `resource` varchar(255) NOT NULL,
`action` varchar(8) NOT NULL,
UNIQUE INDEX `uk_role_permission` (`role`,`resource`,`action`) USING BTREE
);
--
Gitblit v1.9.3