Deleting a package registration directly in the database

delete_package_registration.sql

use NuGetGallery

BEGIN TRAN

DECLARE @PackageRegistrationId nvarchar(max)
SET @PackageRegistrationId = '<id>'

ALTER TABLE GallerySettings NOCHECK CONSTRAINT ALL

DELETE FROM PackageStatistics
	FROM PackageStatistics ps
	JOIN Packages p ON p.[Key] = ps.PackageKey
	JOIN PackageRegistrations pr ON pr.[Key] = p.PackageRegistrationKey
	WHERE pr.Id = @PackageRegistrationId
	
ALTER TABLE GallerySettings CHECK CONSTRAINT ALL

DELETE FROM PackageDependencies
	FROM PackageDependencies pd
	JOIN Packages p ON p.[Key] = pd.PackageKey
	JOIN PackageRegistrations pr ON pr.[Key] = p.PackageRegistrationKey
	WHERE pr.Id = @PackageRegistrationId
	
DELETE FROM PackageAuthors
	FROM PackageAuthors pa
	JOIN Packages p ON p.[Key] = pa.PackageKey
	JOIN PackageRegistrations pr ON pr.[Key] = p.PackageRegistrationKey
	WHERE pr.Id = @PackageRegistrationId

DELETE FROM Packages
	FROM Packages p
	JOIN PackageRegistrations pr ON pr.[Key] = p.PackageRegistrationKey
	WHERE pr.Id = @PackageRegistrationId
	
DELETE FROM PackageOwnerRequests
	FROM PackageOwnerRequests por
	JOIN PackageRegistrations pr ON pr.[Key] = por.PackageRegistrationKey
	WHERE pr.Id = @PackageRegistrationId
	
DELETE FROM PackageRegistrationOwners
	FROM PackageRegistrationOwners pro
	JOIN PackageRegistrations pr ON pr.[Key] = pro.PackageRegistrationKey
	WHERE pr.Id = @PackageRegistrationId

DELETE FROM PackageRegistrations WHERE Id = @PackageRegistrationId

COMMIT TRAN