Source/NuGetGallery.Operations/Scripts/NuGetDownloadsProcs_ConfirmPackageExported.sql (13 lines of code) (raw):
IF OBJECT_ID('[dbo].[ConfirmPackageExported]') IS NOT NULL
DROP PROCEDURE [dbo].[ConfirmPackageExported]
GO
CREATE PROCEDURE [dbo].[ConfirmPackageExported]
@PackageId NVARCHAR(128),
@DirtyCount INT
AS
BEGIN
DELETE PackageReportDirty
WHERE PackageId = @PackageId
AND DirtyCount = @DirtyCount
END
GO