You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
use dms;
drop table cloudbeaver_connection_caches;
alter table member_group_role_op_ranges drop foreign key fk_member_groups_role_with_op_ranges;
alter table member_group_users drop foreign key fk_member_group_users_member_group;
alter table member_group_users drop foreign key fk_member_group_users_user;
alter table member_role_op_ranges drop foreign key fk_members_role_with_op_ranges;
alter table role_op_permissions drop foreign key fk_role_op_permissions_op_permission;
alter table role_op_permissions drop foreign key fk_role_op_permissions_role;
alter table user_group_users drop foreign key fk_user_group_users_user;
alter table user_group_users drop foreign key fk_user_group_users_user_group;
alter table user_op_permissions drop foreign key fk_user_op_permissions_op_permission;
alter table user_op_permissions drop foreign key fk_user_op_permissions_user;
insert into op_permissions (uid, created_at, updated_at, name, description, range_type) values ('700011', NOW(), NOW(), '审批/驳回数据导出工单', '审批/驳回数据导出工单;拥有该权限的用户可以执行审批导出数据工单或者驳回导出数据工单', 'db_service'), ('700012', NOW(), NOW(), '创建数据导出任务', '创建数据导出任务;拥有该权限的用户可以创建数据导出任务或者工单', 'db_service');
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
不兼容的变更内容
新版本的SQLE做了非兼容性变更,旧的SQLE升级到新SQLE需要额外的手动升级操作。相关issue:
actiontech/dms#141
actiontech/dms#86
https://github.com/actiontech/dms-ee/issues/112
版本升级方案
假设DMS配置的元数据库名为"dms",升级rpm包后,启动DMS/SQLE服务前,在元数据实例执行如下SQL:
Beta Was this translation helpful? Give feedback.
All reactions