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');