Source/NuGetGallery.Operations/Scripts/NuGetDownloadsAlterTable.sql (8 lines of code) (raw):

/* you can use this script manually against an existing warehouse * for new warehouse instances, these schema changes have been incorporated into the create script */ ALTER TABLE [dbo].[Dimension_Package] ADD [PackageListed] BIT NOT NULL DEFAULT 1 GO ALTER TABLE [dbo].[Dimension_Package] ADD [PackageTitle] NVARCHAR(256) GO ALTER TABLE [dbo].[Dimension_Package] ADD [PackageDescription] NVARCHAR(MAX) GO ALTER TABLE [dbo].[Dimension_Package] ADD [PackageIconUrl] NVARCHAR(MAX) GO