要删除组织,请执行以下一项操作:
- 如果您在组织管理控制台中创建了组织,请执行以下操作:
- 为您创建的组织查找 ORGENTITY.ORGENITY_ID。
- 删除 ORGENTITY 表条目。
- 删除 MEMBER.MEMBER_ID=ORGENTITY.ORGENTITY_ID 的 MEMBER 行。
- 删除 MBRREL.DESCENDANT_ID=ORGENTITY.ORGENTITY_ID 的所有 MBRREL 行
- 如果您使用转销商注册命令创建组织,则主数据库表和次要数据库表已填充。MEMBER 表是添加了主要信息的数据库表。次要表包含以下表:MBRREL、
MBRROLE、APRVSTATUS、USERREG、ADDRESS 和 ADDRBOOK。要删除组织,请在 SQL 中执行以下操作:
select users_id from userreg where logonId = <'User Name' entered during registration> delete from member where member_id = <users_id of the new user above><users_id of the new user above> select orgentity_id from orgentity where orgentityname = <'Your organization name' entered during registration> select mbrgrp_id from mbrgrp where owner_id = <orgentity_id above><orgentity_id above> delete from member where member_id = <mbrgrp_id of the mbrgrp above><mbrgrp_id of the mbrgrp above> delete from member where member_id = <orgentity_id from above><orgentity_id from above>
注意:建议您在删除组织之前查看每个数据库表以确保注意到将要删除的信息。