DECLARE @PortalId int
DECLARE @TabId int
DECLARE @DesktopModuleId int
DECLARE @ModuleDefID int
DECLARE @ModuleID int

SELECT @DesktopModuleId=DesktopModuleId FROM {databaseOwner}[{objectQualifier}DesktopModules] WHERE FriendlyName like 'PageBlaster Admin'
SELECT @ModuleDefID=ModuleDefID FROM {databaseOwner}[{objectQualifier}ModuleDefinitions] WHERE DesktopModuleId=@DesktopModuleId
SELECT @ModuleId=ModuleId FROM {databaseOwner}[{objectQualifier}Modules]  WHERE ModuleDefID=@ModuleDefID 


DECLARE portal_cursor cursor 
FOR	SELECT 	PortalId 
	FROM	{databaseOwner}{objectQualifier}Portals

OPEN portal_cursor

FETCH NEXT FROM portal_cursor 
INTO @PortalId

WHILE @@FETCH_STATUS = 0
BEGIN

    SELECT @TabId=TabId FROM {databaseOwner}[{objectQualifier}Tabs] WHERE PortalId=@PortalId and TabName='PageBlaster'
    DELETE FROM {databaseOwner}[{objectQualifier}TabPermission]  WHERE TabId=@TabId 
    DELETE FROM {databaseOwner}[{objectQualifier}Tabs] WHERE TabId=@TabId 
    DELETE FROM {databaseOwner}[{objectQualifier}TabModules] WHERE TabId=@TabId 
    
    DELETE FROM {databaseOwner}{objectQualifier}ModulePermission WHERE ModuleId=@ModuleId 
    DELETE FROM {databaseOwner}[{objectQualifier}Modules]  WHERE ModuleDefID=@ModuleDefID 
    DELETE FROM {databaseOwner}[{objectQualifier}ModuleDefinitions] WHERE DesktopModuleId=@DesktopModuleId
    DELETE FROM {databaseOwner}[{objectQualifier}DesktopModules] WHERE DesktopModuleId=@DesktopModuleId
    
	
	FETCH NEXT FROM portal_cursor 
    INTO @PortalId
END

CLOSE portal_cursor
DEALLOCATE portal_cursor