30 lines
1.6 KiB
SQL
30 lines
1.6 KiB
SQL
|
--- Nacos2.5.1 升级 Nacos3.1.1
|
||
|
|
ALTER TABLE `nacos`.`config_info` MODIFY COLUMN `encrypted_data_key` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT '密钥' AFTER `c_schema`;
|
||
|
|
|
||
|
|
ALTER TABLE `nacos`.`permissions` COLLATE = utf8mb4_0900_ai_ci;
|
||
|
|
|
||
|
|
ALTER TABLE `nacos`.`permissions` MODIFY COLUMN `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'role' FIRST;
|
||
|
|
|
||
|
|
ALTER TABLE `nacos`.`permissions` MODIFY COLUMN `resource` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'resource' AFTER `role`;
|
||
|
|
|
||
|
|
ALTER TABLE `nacos`.`permissions` MODIFY COLUMN `action` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'action' AFTER `resource`;
|
||
|
|
|
||
|
|
ALTER TABLE `nacos`.`roles` COLLATE = utf8mb4_0900_ai_ci;
|
||
|
|
|
||
|
|
ALTER TABLE `nacos`.`roles` MODIFY COLUMN `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'username' FIRST;
|
||
|
|
|
||
|
|
ALTER TABLE `nacos`.`roles` MODIFY COLUMN `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'role' AFTER `username`;
|
||
|
|
|
||
|
|
ALTER TABLE `nacos`.`users` COLLATE = utf8mb4_0900_ai_ci;
|
||
|
|
|
||
|
|
ALTER TABLE `nacos`.`users` MODIFY COLUMN `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'username' FIRST;
|
||
|
|
|
||
|
|
ALTER TABLE `nacos`.`users` MODIFY COLUMN `password` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'password' AFTER `username`;
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `nacos`.`config_info_aggr`;
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `nacos`.`config_info_beta`;
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `nacos`.`config_info_tag`;
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `nacos`.`flyway_schema_history`;
|