Which DB statements do I need to execute to completely delete the Space Privacy add-on?

extranet
spaceprivacy

#1

Which DB statements do I need to execute to completely delete the Space Privacy add-on?


#2

To completely remove the plugin after uninstallation, you should run the following (PSQL 9.5)

DROP TABLE “AO_EBE6AF_EXTRANET_ROLE”;
DROP TABLE “AO_EBE6AF_EXTRANET_REL_KIND”;
DROP TABLE “AO_EBE6AF_EXTRANET_SP_PERM”;
DROP TABLE “AO_EBE6AF_EXTRANET_GROUP_REL”;
DROP TABLE “AO_EBE6AF_EXTRANET_RELATION”;
DROP TABLE “AO_EBE6AF_EXTRANET”;

DELETE FROM bandana WHERE bandanakey ~ ‘net.seibertmedia.extranet’;
DELETE FROM bandana WHERE bandanakey = ‘AO_EBE6AF_#’;

Furthermore I would recommend to rebuild the search index.