technological-brain-server/target/classes/db/migration/V1.0.1__remove_param_code.sql

8 lines
284 B
SQL

-- 删除原有的唯一索引
ALTER TABLE `sys_param` DROP INDEX `uk_param_type_code`;
-- 删除param_code字段
ALTER TABLE `sys_param` DROP COLUMN `param_code`;
-- 创建新的唯一索引
ALTER TABLE `sys_param` ADD UNIQUE KEY `uk_param_type_name` (`param_type`, `param_name`);