Add query to delete BPS profiles by Tenant ID
@@ -145,6 +145,8 @@ public class SQLConstants {
public static final String DELETE_BPS_PROFILES_QUERY = "DELETE FROM WF_BPS_PROFILE WHERE PROFILE_NAME = ?";
+ public static final String DELETE_BPS_PROFILES_OF_TENANT_QUERY = "DELETE FROM WF_BPS_PROFILE WHERE TENANT_ID = ?";
+
public static final String ADD_REQUEST_ENTITY_RELATIONSHIP = "INSERT INTO WF_REQUEST_ENTITY_RELATIONSHIP " +
"(REQUEST_ID, ENTITY_NAME, ENTITY_TYPE, TENANT_ID) VALUES (?, ?, ?, ?)";
