如果要刪除組織,請執行下列之一:
- 如果您已在「組織管理主控台」中建立組織,請執行下列步驟:
- 尋找您所建組織的 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>
附註:建議您在刪除組織前,先檢視每一個資料庫表格,以確定您知道將會刪除哪些資訊。