To delete an organization do one of the following:
- If you created the organization in the Organization Administration Console,
do the following:
- Find the ORGENTITY.ORGENITY_ID for the organization you created.
- Delete the ORGENTITY table entry.
- Delete the MEMBER row where MEMBER.MEMBER_ID=ORGENTITY.ORGENTITY_ID.
- Delete all MBRREL rows where MBRREL.DESCENDANT_ID=ORGENTITY.ORGENTITY_ID
- If you created the organization using the Reseller Registration commands,
there are primary and secondary database tables that have been populated. The
MEMBER table is the database
table that has primary information added. Secondary tables include the
following: MBRREL,
MBRROLE,
APRVSTATUS,
USERREG,
ADDRESS, and
ADDRBOOK. To delete an
organization, do the following in 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>
Note: It is recommended that you view each database table before deleting an organization to ensure that you are aware of what information will be deleted.