Add query to delete BPS profile from tenant
@@ -150,6 +150,9 @@ public class SQLConstants {
public static final String DELETE_BPS_PROFILES_QUERY = "DELETE FROM WF_BPS_PROFILE WHERE PROFILE_NAME = ?";
+ public static final String DELETE_TENANTED_BPS_PROFILES_QUERY = "DELETE FROM WF_BPS_PROFILE WHERE " +
+ "PROFILE_NAME = ? AND TENANT_ID = ?";
+
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 " +
