Skip to content

Instantly share code, notes, and snippets.

@loic-sharma
Created November 7, 2017 17:04
Show Gist options
  • Save loic-sharma/76090850a76d38c1611ec7b0183bc3ea to your computer and use it in GitHub Desktop.
Save loic-sharma/76090850a76d38c1611ec7b0183bc3ea to your computer and use it in GitHub Desktop.
[NuGet] SQL Queries to Create the Non-Community Package Set in Statistics DB
BEGIN TRANSACTION;
IF NOT EXISTS (SELECT * FROM [dbo].[Dimension_PackageSet] WHERE [Name] = 'NonCommunityPackages')
BEGIN
INSERT INTO [dbo].[Dimension_PackageSet] (Name) VALUES ('NonCommunityPackages')
END
DECLARE @NonCommunityPackagesId int = (SELECT [Id] FROM [dbo].[Dimension_PackageSet] WHERE [Name] = 'NonCommunityPackages');
DELETE FROM [dbo].[Fact_Package_PackageSet]
WHERE [Dimension_PackageSet_Id] = @NonCommunityPackagesId;
INSERT INTO [dbo].[Fact_Package_PackageSet] (Dimension_PackageSet_id, LowercasedPackageId, IsPrimary) VALUES
(@NonCommunityPackagesId, 'ajaxgridscaffolder', 0),
(@NonCommunityPackagesId, 'ajaxmin', 0),
(@NonCommunityPackagesId, 'antixss', 0),
(@NonCommunityPackagesId, 'appforsharepointwebtoolkit', 0),
(@NonCommunityPackagesId, 'appforsharepointwebtoolkit.cs', 0),
(@NonCommunityPackagesId, 'appforsharepointwebtoolkit.de', 0),
(@NonCommunityPackagesId, 'appforsharepointwebtoolkit.es', 0),
(@NonCommunityPackagesId, 'appforsharepointwebtoolkit.fr', 0),
(@NonCommunityPackagesId, 'appforsharepointwebtoolkit.it', 0),
(@NonCommunityPackagesId, 'appforsharepointwebtoolkit.ja', 0),
(@NonCommunityPackagesId, 'appforsharepointwebtoolkit.ko', 0),
(@NonCommunityPackagesId, 'appforsharepointwebtoolkit.pl', 0),
(@NonCommunityPackagesId, 'appforsharepointwebtoolkit.pt', 0),
(@NonCommunityPackagesId, 'appforsharepointwebtoolkit.ru', 0),
(@NonCommunityPackagesId, 'appforsharepointwebtoolkit.tr', 0),
(@NonCommunityPackagesId, 'appforsharepointwebtoolkit.zh-hans', 0),
(@NonCommunityPackagesId, 'appforsharepointwebtoolkit.zh-hant', 0),
(@NonCommunityPackagesId, 'aspnetmvc', 0),
(@NonCommunityPackagesId, 'aspnetrazor.core', 0),
(@NonCommunityPackagesId, 'aspnetsprites-core', 0),
(@NonCommunityPackagesId, 'aspnetsprites-mvcandrazorhelper', 0),
(@NonCommunityPackagesId, 'aspnetsprites-webformscontrol', 0),
(@NonCommunityPackagesId, 'aspnetwebapi', 0),
(@NonCommunityPackagesId, 'aspnetwebapi.core', 0),
(@NonCommunityPackagesId, 'aspnetwebapi.data', 0),
(@NonCommunityPackagesId, 'aspnetwebapi.selfhost', 0),
(@NonCommunityPackagesId, 'aspnetwebpages', 0),
(@NonCommunityPackagesId, 'aspnetwebpages.core', 0),
(@NonCommunityPackagesId, 'aspnetwebpagescore', 0),
(@NonCommunityPackagesId, 'bakery.template.vb2', 0),
(@NonCommunityPackagesId, 'calendar.template', 0),
(@NonCommunityPackagesId, 'calendar.template.vb2', 0),
(@NonCommunityPackagesId, 'ciqsfunctionsutils', 0),
(@NonCommunityPackagesId, 'coreclr', 0),
(@NonCommunityPackagesId, 'custommarshalers', 0),
(@NonCommunityPackagesId, 'dynamicdata.efcodefirstprovider', 0),
(@NonCommunityPackagesId, 'efcodefirst.sample', 0),
(@NonCommunityPackagesId, 'efcodefirst.sqlservercompact', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.caching', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.caching.cryptography', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.caching.database', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.common', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.data', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.data.sqlce', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.exceptionhandling', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.exceptionhandling.logging', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.exceptionhandling.wcf', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.logging', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.logging.database', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.logging.service', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.policyinjection', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.security', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.security.azman', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.security.cache.cachingstore', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.security.cryptography', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.semanticlogging', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.semanticlogging.database', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.semanticlogging.service', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.semanticlogging.windowsazure', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.source', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.source.silverlight', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.source.windowsazure', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.source.windowsazure.preview', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.transientfaulthandling', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.transientfaulthandling.caching', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.transientfaulthandling.configuration', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.transientfaulthandling.data', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.transientfaulthandling.servicebus', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.transientfaulthandling.windowsazure.storage', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.validation', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.validation.integration.aspnet', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.validation.integration.wcf', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.validation.integration.winforms', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.validation.integration.wpf', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.windowsazure.autoscaling', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.windowsazure.autoscaling.preview', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.windowsazure.configuration', 0),
(@NonCommunityPackagesId, 'enterpriselibrary.windowsazure.transientfaulthandling', 0),
(@NonCommunityPackagesId, 'entityframework', 0),
(@NonCommunityPackagesId, 'entityframework.azuretablestorage', 0),
(@NonCommunityPackagesId, 'entityframework.commands', 0),
(@NonCommunityPackagesId, 'entityframework.core', 0),
(@NonCommunityPackagesId, 'entityframework.de', 0),
(@NonCommunityPackagesId, 'entityframework.es', 0),
(@NonCommunityPackagesId, 'entityframework.fr', 0),
(@NonCommunityPackagesId, 'entityframework.inmemory', 0),
(@NonCommunityPackagesId, 'entityframework.it', 0),
(@NonCommunityPackagesId, 'entityframework.ja', 0),
(@NonCommunityPackagesId, 'entityframework.ko', 0),
(@NonCommunityPackagesId, 'entityframework.migrations', 0),
(@NonCommunityPackagesId, 'entityframework.migrations.design', 0),
(@NonCommunityPackagesId, 'entityframework.redis', 0),
(@NonCommunityPackagesId, 'entityframework.relational', 0),
(@NonCommunityPackagesId, 'entityframework.relational.design', 0),
(@NonCommunityPackagesId, 'entityframework.ru', 0),
(@NonCommunityPackagesId, 'entityframework.sqlite', 0),
(@NonCommunityPackagesId, 'entityframework.sqlserver', 0),
(@NonCommunityPackagesId, 'entityframework.sqlserver.design', 0),
(@NonCommunityPackagesId, 'entityframework.sqlservercompact', 0),
(@NonCommunityPackagesId, 'entityframework.zh-hans', 0),
(@NonCommunityPackagesId, 'entityframework.zh-hant', 0),
(@NonCommunityPackagesId, 'entlib3.daab', 0),
(@NonCommunityPackagesId, 'entlib4.daab', 0),
(@NonCommunityPackagesId, 'envdte', 0),
(@NonCommunityPackagesId, 'facebook.helper', 0),
(@NonCommunityPackagesId, 'httpclient', 0),
(@NonCommunityPackagesId, 'ix-async', 0),
(@NonCommunityPackagesId, 'ixjs-all', 0),
(@NonCommunityPackagesId, 'ixjs-l2o', 0),
(@NonCommunityPackagesId, 'ixjs-main', 0),
(@NonCommunityPackagesId, 'ix-main', 0),
(@NonCommunityPackagesId, 'jquery.ajax.unobtrusive', 0),
(@NonCommunityPackagesId, 'jquery.datalink', 0),
(@NonCommunityPackagesId, 'jquery.mobile.mvc', 0),
(@NonCommunityPackagesId, 'jquery.templates', 0),
(@NonCommunityPackagesId, 'jquery.validation.unobtrusive', 0),
(@NonCommunityPackagesId, 'jquery.vsdoc', 0),
(@NonCommunityPackagesId, 'jsonvalue', 0),
(@NonCommunityPackagesId, 'k.collections', 0),
(@NonCommunityPackagesId, 'k.commonfx', 0),
(@NonCommunityPackagesId, 'k.corefx', 0),
(@NonCommunityPackagesId, 'k.diagnostics', 0),
(@NonCommunityPackagesId, 'k.io', 0),
(@NonCommunityPackagesId, 'k.leanfx', 0),
(@NonCommunityPackagesId, 'k.linq', 0),
(@NonCommunityPackagesId, 'k.networking.core', 0),
(@NonCommunityPackagesId, 'k.reflection.emit', 0),
(@NonCommunityPackagesId, 'k.roslyn', 0),
(@NonCommunityPackagesId, 'k.threading', 0),
(@NonCommunityPackagesId, 'kestrel', 0),
(@NonCommunityPackagesId, 'klr.core45.managed', 0),
(@NonCommunityPackagesId, 'klr.host', 0),
(@NonCommunityPackagesId, 'klr.hosting.shared', 0),
(@NonCommunityPackagesId, 'klr.net45.managed', 0),
(@NonCommunityPackagesId, 'korebuild', 0),
(@NonCommunityPackagesId, 'kre-clr-amd64', 0),
(@NonCommunityPackagesId, 'kre-clr-win-x64', 0),
(@NonCommunityPackagesId, 'kre-clr-win-x86', 0),
(@NonCommunityPackagesId, 'kre-clr-x86', 0),
(@NonCommunityPackagesId, 'kre-coreclr-amd64', 0),
(@NonCommunityPackagesId, 'kre-coreclr-win-x64', 0),
(@NonCommunityPackagesId, 'kre-coreclr-win-x86', 0),
(@NonCommunityPackagesId, 'kre-coreclr-x86', 0),
(@NonCommunityPackagesId, 'kre-mono', 0),
(@NonCommunityPackagesId, 'kre-mono45-x86', 0),
(@NonCommunityPackagesId, 'kre-svr50-x64', 0),
(@NonCommunityPackagesId, 'kre-svr50-x86', 0),
(@NonCommunityPackagesId, 'kre-svrc50-x64', 0),
(@NonCommunityPackagesId, 'kre-svrc50-x86', 0),
(@NonCommunityPackagesId, 'libuv', 0),
(@NonCommunityPackagesId, 'localize', 0),
(@NonCommunityPackagesId, 'microsoft.admediator.core', 0),
(@NonCommunityPackagesId, 'microsoft.admediator.windowsphone8', 0),
(@NonCommunityPackagesId, 'microsoft.admediator.windowsphone8.adduplex', 0),
(@NonCommunityPackagesId, 'microsoft.admediator.windowsphone8.googleadmob', 0),
(@NonCommunityPackagesId, 'microsoft.admediator.windowsphone8.inmobi', 0),
(@NonCommunityPackagesId, 'microsoft.admediator.windowsphone8.inneractive', 0),
(@NonCommunityPackagesId, 'microsoft.admediator.windowsphone8.microsoftadvertising', 0),
(@NonCommunityPackagesId, 'microsoft.admediator.windowsphone8.mobfox', 0),
(@NonCommunityPackagesId, 'microsoft.admediator.windowsphone8.smaato', 0),
(@NonCommunityPackagesId, 'microsoft.admediator.windowsphone81', 0),
(@NonCommunityPackagesId, 'microsoft.admediator.windowsphone81.adduplex', 0),
(@NonCommunityPackagesId, 'microsoft.admediator.windowsphone81.microsoftadvertising', 0),
(@NonCommunityPackagesId, 'microsoft.admediator.windowsphone81.smaato', 0),
(@NonCommunityPackagesId, 'microsoft.admediator.windowsphone81sl.microsoftadvertising', 0),
(@NonCommunityPackagesId, 'microsoft.advertising.windowsphone.sl80', 0),
(@NonCommunityPackagesId, 'microsoft.advertising.windowsphone.sl81', 0),
(@NonCommunityPackagesId, 'microsoft.advertising.windowsphone.xaml81', 0),
(@NonCommunityPackagesId, 'microsoft.applicationinsights.log4netappender', 0),
(@NonCommunityPackagesId, 'microsoft.applicationinsights.nlogtarget', 0),
(@NonCommunityPackagesId, 'microsoft.applicationinsights.snapshotcollector', 0),
(@NonCommunityPackagesId, 'microsoft.applicationinsights.telemetry.services', 0),
(@NonCommunityPackagesId, 'microsoft.applicationinsights.telemetry.windowsphone', 0),
(@NonCommunityPackagesId, 'microsoft.applicationinsights.telemetry.windowsstore', 0),
(@NonCommunityPackagesId, 'microsoft.applicationinsights.tracelistener', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.cache.session', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.cors', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.cors.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.cors.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.cors.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.cors.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.cors.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.cors.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.cors.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.cors.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.cors.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.cors.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.cors.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.cors.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.cors.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.diagnostics', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.diagnostics.elm', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.diagnostics.entity', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.dynamicdatatemplates.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.featuremodel', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.fileproviders', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.fileproviders.interfaces', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.filesystems', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.friendlyurls', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.friendlyurls.core', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.friendlyurls.core.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.friendlyurls.core.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.friendlyurls.core.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.friendlyurls.core.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.friendlyurls.core.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.friendlyurls.core.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.friendlyurls.core.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.friendlyurls.core.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.friendlyurls.core.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.friendlyurls.core.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.friendlyurls.core.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.friendlyurls.core.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.friendlyurls.core.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.friendlyurls.viewswitcher', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.hosting', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.http', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.http.core', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.http.extensions', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.http.interfaces', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.httpfeature', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.authentication', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.core', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.core.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.core.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.core.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.core.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.core.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.core.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.core.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.core.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.core.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.core.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.core.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.core.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.core.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.entity', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.entityframework', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.entityframework.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.entityframework.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.entityframework.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.entityframework.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.entityframework.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.entityframework.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.entityframework.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.entityframework.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.entityframework.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.entityframework.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.entityframework.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.entityframework.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.entityframework.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.inmemory', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.owin', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.owin.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.owin.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.owin.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.owin.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.owin.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.owin.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.owin.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.owin.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.owin.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.owin.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.owin.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.owin.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.owin.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.identity.security', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.loader.iis', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.loader.iis.interop', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.membership.openauth', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.membership.openauth.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.membership.openauth.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.membership.openauth.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.membership.openauth.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.membership.openauth.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.membership.openauth.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.membership.openauth.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.membership.openauth.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.membership.openauth.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.membership.openauth.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.membership.openauth.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.membership.openauth.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.membership.openauth.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.common', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.core', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.facebook', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.facebook.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.facebook.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.facebook.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.facebook.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.facebook.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.facebook.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.facebook.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.facebook.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.facebook.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.facebook.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.facebook.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.facebook.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.facebook.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.fixeddisplaymodes', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.futures', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.headervalueabstractions', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.modelbinding', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.mvc4views.csharp', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.mvc4views.visualbasic', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.razor', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.razor.host', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.scaffoldertemplates.attributerouting.csharp', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.scaffoldertemplates.attributerouting.visualbasic', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.taghelpers', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.webapicompatshim', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.mvc.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.odata', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.odata.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.odata.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.odata.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.odata.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.odata.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.odata.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.odata.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.odata.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.odata.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.odata.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.odata.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.owin', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.pipelinecore', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.providers', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.providers.core', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.providers.core.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.providers.core.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.providers.core.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.providers.core.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.providers.core.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.providers.core.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.providers.core.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.providers.core.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.providers.core.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.providers.core.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.providers.core.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.providers.core.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.providers.core.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.providers.localdb', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.providers.sqlce', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.razor', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.razor.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.razor.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.razor.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.razor.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.razor.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.razor.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.razor.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.razor.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.razor.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.razor.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.razor.runtime', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.razor.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.razor.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.razor.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.requestcontainer', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.routing', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.scaffolding.infrastructure', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.scaffolding.webforms', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.scriptmanager.msajax', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.scriptmanager.webforms', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.security', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.security.cookies', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.security.dataprotection', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.security.dataprotection.azure', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.security.dataprotection.compatibility', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.security.facebook', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.security.google', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.security.microsoftaccount', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.security.oauth', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.security.oauthbearer', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.security.openidconnect', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.security.twitter', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.security.windows', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.server.iis', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.server.kestrel', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.server.weblistener', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.session', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.client', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.client.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.client.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.client.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.client.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.client.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.client.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.client.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.client.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.client.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.client.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.client.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.client.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.client.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.core', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.core.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.core.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.core.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.core.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.core.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.core.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.core.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.core.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.core.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.core.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.core.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.core.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.core.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.hosting.aspnet', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.hosting.common', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.hosting.utils', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.i18n', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.js', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.owin', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.redis', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.redis.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.redis.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.redis.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.redis.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.redis.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.redis.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.redis.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.redis.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.redis.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.redis.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.redis.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.redis.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.redis.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.sample', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.selfhost', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.server', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.servicebus', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.servicebus.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.servicebus.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.servicebus.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.servicebus.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.servicebus.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.servicebus.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.servicebus.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.servicebus.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.servicebus.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.servicebus.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.servicebus.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.servicebus.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.servicebus.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.sqlserver', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.sqlserver.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.sqlserver.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.sqlserver.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.sqlserver.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.sqlserver.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.sqlserver.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.sqlserver.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.sqlserver.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.sqlserver.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.sqlserver.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.sqlserver.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.sqlserver.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.sqlserver.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.systemweb', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.systemweb.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.systemweb.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.systemweb.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.systemweb.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.systemweb.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.systemweb.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.systemweb.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.systemweb.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.systemweb.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.systemweb.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.systemweb.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.systemweb.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.systemweb.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.utils', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.signalr.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.staticfiles', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.testhost', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.testing', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.web.helpers.mvc', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.web.optimization', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.web.optimization.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.web.optimization.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.web.optimization.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.web.optimization.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.web.optimization.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.web.optimization.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.web.optimization.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.web.optimization.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.web.optimization.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.web.optimization.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.web.optimization.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.web.optimization.webforms', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.web.optimization.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.web.optimization.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.client', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.client.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.client.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.client.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.client.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.client.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.client.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.client.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.client.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.client.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.client.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.client.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.client.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.client.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.core', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.core.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.core.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.core.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.core.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.core.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.core.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.core.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.core.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.core.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.core.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.core.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.core.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.core.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.cors', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.cors.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.cors.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.cors.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.cors.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.cors.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.cors.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.cors.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.cors.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.cors.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.cors.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.cors.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.cors.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.cors.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.helppage', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.helppage.vb', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.odata', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.odata.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.odata.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.odata.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.odata.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.odata.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.odata.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.odata.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.odata.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.odata.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.odata.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.odata.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.odata.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.odata.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.owin', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.owin.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.owin.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.owin.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.owin.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.owin.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.owin.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.owin.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.owin.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.owin.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.owin.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.owin.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.owin.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.owin.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.owinselfhost', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.scaffoldertemplates.attributerouting.csharp', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.scaffoldertemplates.attributerouting.visualbasic', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.selfhost', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.selfhost.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.selfhost.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.selfhost.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.selfhost.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.selfhost.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.selfhost.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.selfhost.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.selfhost.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.selfhost.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.selfhost.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.selfhost.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.selfhost.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.selfhost.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.signalr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.signalr.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.signalr.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.signalr.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.signalr.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.signalr.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.signalr.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.signalr.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.signalr.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.signalr.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.signalr.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.signalr.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.signalr.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.signalr.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.tracing', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.tracing.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.tracing.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.tracing.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.tracing.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.tracing.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.tracing.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.tracing.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.tracing.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.tracing.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.tracing.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.tracing.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.tracing.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.tracing.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.webhost', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.webhost.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.webhost.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.webhost.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.webhost.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.webhost.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.webhost.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.webhost.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.webhost.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.webhost.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.webhost.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.webhost.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.webhost.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webapi.webhost.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webhelpers', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webhooks.common', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webhooks.custom', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webhooks.custom.azurestorage', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webhooks.custom.mvc', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webhooks.receivers', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webhooks.receivers.azure', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webhooks.receivers.bitbucket', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webhooks.receivers.custom', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webhooks.receivers.dropbox', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webhooks.receivers.github', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webhooks.receivers.instagram', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webhooks.receivers.mailchimp', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webhooks.receivers.paypal', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webhooks.receivers.pusher', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webhooks.receivers.slack', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webhooks.receivers.stripe', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webhooks.receivers.trello', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webhooks.receivers.wordpress', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.administration', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.administration.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.administration.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.administration.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.administration.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.administration.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.administration.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.administration.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.administration.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.administration.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.administration.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.administration.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.administration.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.administration.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.data', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.data.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.data.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.data.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.data.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.data.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.data.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.data.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.data.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.data.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.data.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.data.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.data.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.data.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.oauth', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.oauth.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.oauth.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.oauth.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.oauth.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.oauth.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.oauth.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.oauth.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.oauth.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.oauth.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.oauth.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.oauth.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.oauth.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.oauth.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.webdata', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.webdata.cs', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.webdata.de', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.webdata.es', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.webdata.fr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.webdata.it', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.webdata.ja', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.webdata.ko', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.webdata.pl', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.webdata.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.webdata.ru', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.webdata.tr', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.webdata.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.webdata.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webpages.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.websockets', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.websockets.client', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.websockets.middleware', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.websockets.protocol', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.websockets.server', 0),
(@NonCommunityPackagesId, 'microsoft.aspnet.webutilities', 0),
(@NonCommunityPackagesId, 'microsoft.azure.activedirectory.graphclient', 0),
(@NonCommunityPackagesId, 'microsoft.azure.activedirectory.graphclient.js', 0),
(@NonCommunityPackagesId, 'microsoft.azure.amqp', 0),
(@NonCommunityPackagesId, 'microsoft.azure.c.sharedutility', 0),
(@NonCommunityPackagesId, 'microsoft.azure.datalake.usql.interfaces', 0),
(@NonCommunityPackagesId, 'microsoft.azure.devices', 0),
(@NonCommunityPackagesId, 'microsoft.azure.devices.client', 0),
(@NonCommunityPackagesId, 'microsoft.azure.devices.gateway.lin', 0),
(@NonCommunityPackagesId, 'microsoft.azure.devices.gateway.module', 0),
(@NonCommunityPackagesId, 'microsoft.azure.devices.gateway.module.netstandard', 0),
(@NonCommunityPackagesId, 'microsoft.azure.devices.gateway.native.debian.x64', 0),
(@NonCommunityPackagesId, 'microsoft.azure.devices.gateway.native.ubuntu.x64', 0),
(@NonCommunityPackagesId, 'microsoft.azure.devices.gateway.native.windows.x64', 0),
(@NonCommunityPackagesId, 'microsoft.azure.devices.gateway.win32', 0),
(@NonCommunityPackagesId, 'microsoft.azure.devices.shared', 0),
(@NonCommunityPackagesId, 'microsoft.azure.iot.edge.function', 0),
(@NonCommunityPackagesId, 'microsoft.azure.iot.edge.module', 0),
(@NonCommunityPackagesId, 'microsoft.azure.iot.gateway.module', 0),
(@NonCommunityPackagesId, 'microsoft.azure.iothub.iothubclient', 0),
(@NonCommunityPackagesId, 'microsoft.azure.iothub.mqtttransport', 0),
(@NonCommunityPackagesId, 'microsoft.azure.iothub.serializer', 0),
(@NonCommunityPackagesId, 'microsoft.azure.uamqp', 0),
(@NonCommunityPackagesId, 'microsoft.azure.umqtt', 0),
(@NonCommunityPackagesId, 'microsoft.bcl', 0),
(@NonCommunityPackagesId, 'microsoft.bcl.async', 0),
(@NonCommunityPackagesId, 'microsoft.bcl.build', 0),
(@NonCommunityPackagesId, 'microsoft.bcl.compression', 0),
(@NonCommunityPackagesId, 'microsoft.bcl.immutable', 0),
(@NonCommunityPackagesId, 'microsoft.bcl.metadata', 0),
(@NonCommunityPackagesId, 'microsoft.bcl.simd', 0),
(@NonCommunityPackagesId, 'microsoft.bingads.sdk', 0),
(@NonCommunityPackagesId, 'microsoft.build', 0),
(@NonCommunityPackagesId, 'microsoft.build.conversion.core', 0),
(@NonCommunityPackagesId, 'microsoft.build.engine', 0),
(@NonCommunityPackagesId, 'microsoft.build.framework', 0),
(@NonCommunityPackagesId, 'microsoft.build.localization', 0),
(@NonCommunityPackagesId, 'microsoft.build.runtime', 0),
(@NonCommunityPackagesId, 'microsoft.build.tasks.core', 0),
(@NonCommunityPackagesId, 'microsoft.build.utilities.core', 0),
(@NonCommunityPackagesId, 'microsoft.cci', 0),
(@NonCommunityPackagesId, 'microsoft.codeanalysis', 0),
(@NonCommunityPackagesId, 'microsoft.codeanalysis.codeactions', 0),
(@NonCommunityPackagesId, 'microsoft.codeanalysis.common', 0),
(@NonCommunityPackagesId, 'microsoft.codeanalysis.compilers', 0),
(@NonCommunityPackagesId, 'microsoft.codeanalysis.csharp', 0),
(@NonCommunityPackagesId, 'microsoft.codeanalysis.csharp.workspaces', 0),
(@NonCommunityPackagesId, 'microsoft.codeanalysis.test.resources.proprietary', 0),
(@NonCommunityPackagesId, 'microsoft.codeanalysis.visualbasic', 0),
(@NonCommunityPackagesId, 'microsoft.codeanalysis.visualbasic.workspaces', 0),
(@NonCommunityPackagesId, 'microsoft.codeanalysis.workspaces.common', 0),
(@NonCommunityPackagesId, 'microsoft.commondataservice', 0),
(@NonCommunityPackagesId, 'microsoft.compilerservices.asynctargetingpack', 0),
(@NonCommunityPackagesId, 'microsoft.composition', 0),
(@NonCommunityPackagesId, 'microsoft.configurationmanagement.messaging', 0),
(@NonCommunityPackagesId, 'microsoft.crmsdk.coreassemblies', 0),
(@NonCommunityPackagesId, 'microsoft.crmsdk.deployment', 0),
(@NonCommunityPackagesId, 'microsoft.crmsdk.extensions', 0),
(@NonCommunityPackagesId, 'microsoft.crmsdk.outlook', 0),
(@NonCommunityPackagesId, 'microsoft.crmsdk.workflow', 0),
(@NonCommunityPackagesId, 'microsoft.csharp', 0),
(@NonCommunityPackagesId, 'microsoft.data.common', 0),
(@NonCommunityPackagesId, 'microsoft.data.edm', 0),
(@NonCommunityPackagesId, 'microsoft.data.entity', 0),
(@NonCommunityPackagesId, 'microsoft.data.entity.inmemory', 0),
(@NonCommunityPackagesId, 'microsoft.data.entity.migrations', 0),
(@NonCommunityPackagesId, 'microsoft.data.entity.relational', 0),
(@NonCommunityPackagesId, 'microsoft.data.entity.sqlite', 0),
(@NonCommunityPackagesId, 'microsoft.data.entity.sqlserver', 0),
(@NonCommunityPackagesId, 'microsoft.data.odata', 0),
(@NonCommunityPackagesId, 'microsoft.data.odata.contrib', 0),
(@NonCommunityPackagesId, 'microsoft.data.odata.windowsphone', 0),
(@NonCommunityPackagesId, 'microsoft.data.services', 0),
(@NonCommunityPackagesId, 'microsoft.data.services.client', 0),
(@NonCommunityPackagesId, 'microsoft.data.services.client.t4', 0),
(@NonCommunityPackagesId, 'microsoft.data.services.client.windowsphone', 0),
(@NonCommunityPackagesId, 'microsoft.data.sqlite', 0),
(@NonCommunityPackagesId, 'microsoft.data.sqlserver', 0),
(@NonCommunityPackagesId, 'microsoft.dataannotations', 0),
(@NonCommunityPackagesId, 'microsoft.dataannotations.core', 0),
(@NonCommunityPackagesId, 'microsoft.dataannotations.supplemental', 0),
(@NonCommunityPackagesId, 'microsoft.devskim', 0),
(@NonCommunityPackagesId, 'microsoft.dotnet.analyzers.compatibility', 0),
(@NonCommunityPackagesId, 'microsoft.dotnet.buildtools', 0),
(@NonCommunityPackagesId, 'microsoft.dotnet.buildtools.genapi', 0),
(@NonCommunityPackagesId, 'microsoft.dotnet.cli.utils', 0),
(@NonCommunityPackagesId, 'microsoft.dotnet.compiler.common', 0),
(@NonCommunityPackagesId, 'microsoft.dotnet.files', 0),
(@NonCommunityPackagesId, 'microsoft.dotnet.frameworkcompatibilitydiagnostics', 0),
(@NonCommunityPackagesId, 'microsoft.dotnet.internalabstractions', 0),
(@NonCommunityPackagesId, 'microsoft.dotnet.platformabstractions', 0),
(@NonCommunityPackagesId, 'microsoft.dotnet.projectmodel', 0),
(@NonCommunityPackagesId, 'microsoft.dotnet.projectmodel.loader', 0),
(@NonCommunityPackagesId, 'microsoft.dotnet.projectmodel.workspaces', 0),
(@NonCommunityPackagesId, 'microsoft.entityframeworkcore.tools.dotnet', 0),
(@NonCommunityPackagesId, 'microsoft.experimental.collections', 0),
(@NonCommunityPackagesId, 'microsoft.extensions.dependencymodel', 0),
(@NonCommunityPackagesId, 'microsoft.extensions.testing.abstractions', 0),
(@NonCommunityPackagesId, 'microsoft.framework.applicationhost', 0),
(@NonCommunityPackagesId, 'microsoft.framework.cache.distributed', 0),
(@NonCommunityPackagesId, 'microsoft.framework.cache.memory', 0),
(@NonCommunityPackagesId, 'microsoft.framework.cache.redis', 0),
(@NonCommunityPackagesId, 'microsoft.framework.codegeneration', 0),
(@NonCommunityPackagesId, 'microsoft.framework.codegeneration.common', 0),
(@NonCommunityPackagesId, 'microsoft.framework.codegeneration.core', 0),
(@NonCommunityPackagesId, 'microsoft.framework.codegeneration.entityframework', 0),
(@NonCommunityPackagesId, 'microsoft.framework.codegeneration.templating', 0),
(@NonCommunityPackagesId, 'microsoft.framework.codegenerators.mvc', 0),
(@NonCommunityPackagesId, 'microsoft.framework.commandlineutils', 0),
(@NonCommunityPackagesId, 'microsoft.framework.configurationmodel', 0),
(@NonCommunityPackagesId, 'microsoft.framework.configurationmodel.json', 0),
(@NonCommunityPackagesId, 'microsoft.framework.configurationmodel.shared', 0),
(@NonCommunityPackagesId, 'microsoft.framework.configurationmodel.xml', 0),
(@NonCommunityPackagesId, 'microsoft.framework.dependencyinjection', 0),
(@NonCommunityPackagesId, 'microsoft.framework.dependencyinjection.autofac', 0),
(@NonCommunityPackagesId, 'microsoft.framework.dependencyinjection.ninject', 0),
(@NonCommunityPackagesId, 'microsoft.framework.dependencyinjection.structuremap', 0),
(@NonCommunityPackagesId, 'microsoft.framework.dependencyinjection.unity', 0),
(@NonCommunityPackagesId, 'microsoft.framework.dependencyinjection.windsor', 0),
(@NonCommunityPackagesId, 'microsoft.framework.designtimehost', 0),
(@NonCommunityPackagesId, 'microsoft.framework.logging', 0),
(@NonCommunityPackagesId, 'microsoft.framework.logging.console', 0),
(@NonCommunityPackagesId, 'microsoft.framework.logging.interfaces', 0),
(@NonCommunityPackagesId, 'microsoft.framework.logging.nlog', 0),
(@NonCommunityPackagesId, 'microsoft.framework.optionsmodel', 0),
(@NonCommunityPackagesId, 'microsoft.framework.packagemanager', 0),
(@NonCommunityPackagesId, 'microsoft.framework.project', 0),
(@NonCommunityPackagesId, 'microsoft.framework.runtime', 0),
(@NonCommunityPackagesId, 'microsoft.framework.runtime.common', 0),
(@NonCommunityPackagesId, 'microsoft.framework.runtime.interfaces', 0),
(@NonCommunityPackagesId, 'microsoft.framework.runtime.loader', 0),
(@NonCommunityPackagesId, 'microsoft.framework.runtime.roslyn', 0),
(@NonCommunityPackagesId, 'microsoft.framework.runtime.roslyn.common', 0),
(@NonCommunityPackagesId, 'microsoft.framework.testadapter', 0),
(@NonCommunityPackagesId, 'microsoft.framework.testhost', 0),
(@NonCommunityPackagesId, 'microsoft.googletest.v140.windesktop.msvcstl.dyn.rt-dyn', 0),
(@NonCommunityPackagesId, 'microsoft.googletest.v140.windesktop.msvcstl.static.rt-dyn', 0),
(@NonCommunityPackagesId, 'microsoft.googletest.v140.windesktop.msvcstl.static.rt-static', 0),
(@NonCommunityPackagesId, 'microsoft.healthvault', 0),
(@NonCommunityPackagesId, 'microsoft.healthvault.client', 0),
(@NonCommunityPackagesId, 'microsoft.healthvault.web', 0),
(@NonCommunityPackagesId, 'microsoft.identitymodel', 0),
(@NonCommunityPackagesId, 'microsoft.identitymodel.clients.activedirectory', 0),
(@NonCommunityPackagesId, 'microsoft.iis.host', 0),
(@NonCommunityPackagesId, 'microsoft.jquery.unobtrusive.ajax', 0),
(@NonCommunityPackagesId, 'microsoft.jquery.unobtrusive.validation', 0),
(@NonCommunityPackagesId, 'microsoft.mef.lightweight', 0),
(@NonCommunityPackagesId, 'microsoft.mef.mvccompositionprovider', 0),
(@NonCommunityPackagesId, 'microsoft.net.http', 0),
(@NonCommunityPackagesId, 'microsoft.net.http.cs', 0),
(@NonCommunityPackagesId, 'microsoft.net.http.de', 0),
(@NonCommunityPackagesId, 'microsoft.net.http.es', 0),
(@NonCommunityPackagesId, 'microsoft.net.http.fr', 0),
(@NonCommunityPackagesId, 'microsoft.net.http.headers', 0),
(@NonCommunityPackagesId, 'microsoft.net.http.it', 0),
(@NonCommunityPackagesId, 'microsoft.net.http.ja', 0),
(@NonCommunityPackagesId, 'microsoft.net.http.ko', 0),
(@NonCommunityPackagesId, 'microsoft.net.http.pl', 0),
(@NonCommunityPackagesId, 'microsoft.net.http.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.net.http.ru', 0),
(@NonCommunityPackagesId, 'microsoft.net.http.server', 0),
(@NonCommunityPackagesId, 'microsoft.net.http.tr', 0),
(@NonCommunityPackagesId, 'microsoft.net.http.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.net.http.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.net.native.compiler', 0),
(@NonCommunityPackagesId, 'microsoft.net.native.sharedlibrary-arm', 0),
(@NonCommunityPackagesId, 'microsoft.net.native.sharedlibrary-x64', 0),
(@NonCommunityPackagesId, 'microsoft.net.native.sharedlibrary-x86', 0),
(@NonCommunityPackagesId, 'microsoft.net.server', 0),
(@NonCommunityPackagesId, 'microsoft.net.toolsetcompilers', 0),
(@NonCommunityPackagesId, 'microsoft.net.uwpcoreruntimesdk', 0),
(@NonCommunityPackagesId, 'microsoft.net.websocketabstractions', 0),
(@NonCommunityPackagesId, 'microsoft.net.websockets', 0),
(@NonCommunityPackagesId, 'microsoft.netcore', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.app', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.console', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.consolehost', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.consolehost-arm', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.consolehost-x64', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.consolehost-x86', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.dotnetapphost', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.dotnethost', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.dotnethostpolicy', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.dotnethostresolver', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.ilasm', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.ildasm', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.jit', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.native', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.platforms', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.portable.compatibility', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.runtime', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.runtime.coreclr', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.runtime.coreclr-arm', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.runtime.coreclr-x64', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.runtime.coreclr-x86', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.runtime.native', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.targets', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.targets.dnxcore', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.targets.netframework', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.targets.universalwindowsplatform', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.testhost', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.testhost-arm', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.testhost-x64', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.testhost-x86', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.universalwindowsplatform', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.windows.apisets', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.windows.apisets-x64', 0),
(@NonCommunityPackagesId, 'microsoft.netcore.windows.apisets-x86', 0),
(@NonCommunityPackagesId, 'microsoft.netframework.compatibility', 0),
(@NonCommunityPackagesId, 'microsoft.o365.actionablemessages.utilities', 0),
(@NonCommunityPackagesId, 'microsoft.odata.client', 0),
(@NonCommunityPackagesId, 'microsoft.odata.core', 0),
(@NonCommunityPackagesId, 'microsoft.odata.edm', 0),
(@NonCommunityPackagesId, 'microsoft.odata.entityframeworkprovider', 0),
(@NonCommunityPackagesId, 'microsoft.office.js', 0),
(@NonCommunityPackagesId, 'microsoft.office.webwidgets.experimental', 0),
(@NonCommunityPackagesId, 'microsoft.orleans.client', 0),
(@NonCommunityPackagesId, 'microsoft.orleans.core', 0),
(@NonCommunityPackagesId, 'microsoft.orleans.countercontrol', 0),
(@NonCommunityPackagesId, 'microsoft.orleans.eventsourcing', 0),
(@NonCommunityPackagesId, 'microsoft.orleans.orleansawsutils', 0),
(@NonCommunityPackagesId, 'microsoft.orleans.orleansazureutils', 0),
(@NonCommunityPackagesId, 'microsoft.orleans.orleanscodegenerator', 0),
(@NonCommunityPackagesId, 'microsoft.orleans.orleanscodegenerator.build', 0),
(@NonCommunityPackagesId, 'microsoft.orleans.orleansconsulutils', 0),
(@NonCommunityPackagesId, 'microsoft.orleans.orleansgoogleutils', 0),
(@NonCommunityPackagesId, 'microsoft.orleans.orleanshost', 0),
(@NonCommunityPackagesId, 'microsoft.orleans.orleansmanager', 0),
(@NonCommunityPackagesId, 'microsoft.orleans.orleansproviders', 0),
(@NonCommunityPackagesId, 'microsoft.orleans.orleansruntime', 0),
(@NonCommunityPackagesId, 'microsoft.orleans.orleansservicebus', 0),
(@NonCommunityPackagesId, 'microsoft.orleans.orleanssqlutils', 0),
(@NonCommunityPackagesId, 'microsoft.orleans.orleanstelemetryconsumers.ai', 0),
(@NonCommunityPackagesId, 'microsoft.orleans.orleanstelemetryconsumers.counters', 0),
(@NonCommunityPackagesId, 'microsoft.orleans.orleanstelemetryconsumers.newrelic', 0),
(@NonCommunityPackagesId, 'microsoft.orleans.orleanszookeeperutils', 0),
(@NonCommunityPackagesId, 'microsoft.orleans.serialization.bond', 0),
(@NonCommunityPackagesId, 'microsoft.orleans.server', 0),
(@NonCommunityPackagesId, 'microsoft.orleans.servicefabric', 0),
(@NonCommunityPackagesId, 'microsoft.orleans.templates.grains', 0),
(@NonCommunityPackagesId, 'microsoft.orleans.templates.interfaces', 0),
(@NonCommunityPackagesId, 'microsoft.orleans.testinghost', 0),
(@NonCommunityPackagesId, 'microsoft.owin', 0),
(@NonCommunityPackagesId, 'microsoft.owin.cors', 0),
(@NonCommunityPackagesId, 'microsoft.owin.cs', 0),
(@NonCommunityPackagesId, 'microsoft.owin.de', 0),
(@NonCommunityPackagesId, 'microsoft.owin.diagnostics', 0),
(@NonCommunityPackagesId, 'microsoft.owin.diagnostics.cs', 0),
(@NonCommunityPackagesId, 'microsoft.owin.diagnostics.de', 0),
(@NonCommunityPackagesId, 'microsoft.owin.diagnostics.es', 0),
(@NonCommunityPackagesId, 'microsoft.owin.diagnostics.fr', 0),
(@NonCommunityPackagesId, 'microsoft.owin.diagnostics.it', 0),
(@NonCommunityPackagesId, 'microsoft.owin.diagnostics.ja', 0)
;
INSERT INTO [dbo].[Fact_Package_PackageSet] (Dimension_PackageSet_id, LowercasedPackageId, IsPrimary) VALUES
(@NonCommunityPackagesId, 'microsoft.owin.diagnostics.ko', 0),
(@NonCommunityPackagesId, 'microsoft.owin.diagnostics.pl', 0),
(@NonCommunityPackagesId, 'microsoft.owin.diagnostics.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.owin.diagnostics.ru', 0),
(@NonCommunityPackagesId, 'microsoft.owin.diagnostics.tr', 0),
(@NonCommunityPackagesId, 'microsoft.owin.diagnostics.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.owin.diagnostics.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.owin.es', 0),
(@NonCommunityPackagesId, 'microsoft.owin.filesystems', 0),
(@NonCommunityPackagesId, 'microsoft.owin.fr', 0),
(@NonCommunityPackagesId, 'microsoft.owin.host.httplistener', 0),
(@NonCommunityPackagesId, 'microsoft.owin.host.httplistener.cs', 0),
(@NonCommunityPackagesId, 'microsoft.owin.host.httplistener.de', 0),
(@NonCommunityPackagesId, 'microsoft.owin.host.httplistener.es', 0),
(@NonCommunityPackagesId, 'microsoft.owin.host.httplistener.fr', 0),
(@NonCommunityPackagesId, 'microsoft.owin.host.httplistener.it', 0),
(@NonCommunityPackagesId, 'microsoft.owin.host.httplistener.ja', 0),
(@NonCommunityPackagesId, 'microsoft.owin.host.httplistener.ko', 0),
(@NonCommunityPackagesId, 'microsoft.owin.host.httplistener.pl', 0),
(@NonCommunityPackagesId, 'microsoft.owin.host.httplistener.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.owin.host.httplistener.ru', 0),
(@NonCommunityPackagesId, 'microsoft.owin.host.httplistener.tr', 0),
(@NonCommunityPackagesId, 'microsoft.owin.host.httplistener.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.owin.host.httplistener.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.owin.host.systemweb', 0),
(@NonCommunityPackagesId, 'microsoft.owin.host.systemweb.cs', 0),
(@NonCommunityPackagesId, 'microsoft.owin.host.systemweb.de', 0),
(@NonCommunityPackagesId, 'microsoft.owin.host.systemweb.es', 0),
(@NonCommunityPackagesId, 'microsoft.owin.host.systemweb.fr', 0),
(@NonCommunityPackagesId, 'microsoft.owin.host.systemweb.it', 0),
(@NonCommunityPackagesId, 'microsoft.owin.host.systemweb.ja', 0),
(@NonCommunityPackagesId, 'microsoft.owin.host.systemweb.ko', 0),
(@NonCommunityPackagesId, 'microsoft.owin.host.systemweb.pl', 0),
(@NonCommunityPackagesId, 'microsoft.owin.host.systemweb.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.owin.host.systemweb.ru', 0),
(@NonCommunityPackagesId, 'microsoft.owin.host.systemweb.tr', 0),
(@NonCommunityPackagesId, 'microsoft.owin.host.systemweb.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.owin.host.systemweb.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.owin.hosting', 0),
(@NonCommunityPackagesId, 'microsoft.owin.hosting.cs', 0),
(@NonCommunityPackagesId, 'microsoft.owin.hosting.de', 0),
(@NonCommunityPackagesId, 'microsoft.owin.hosting.es', 0),
(@NonCommunityPackagesId, 'microsoft.owin.hosting.fr', 0),
(@NonCommunityPackagesId, 'microsoft.owin.hosting.it', 0),
(@NonCommunityPackagesId, 'microsoft.owin.hosting.ja', 0),
(@NonCommunityPackagesId, 'microsoft.owin.hosting.ko', 0),
(@NonCommunityPackagesId, 'microsoft.owin.hosting.pl', 0),
(@NonCommunityPackagesId, 'microsoft.owin.hosting.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.owin.hosting.ru', 0),
(@NonCommunityPackagesId, 'microsoft.owin.hosting.tr', 0),
(@NonCommunityPackagesId, 'microsoft.owin.hosting.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.owin.hosting.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.owin.it', 0),
(@NonCommunityPackagesId, 'microsoft.owin.ja', 0),
(@NonCommunityPackagesId, 'microsoft.owin.ko', 0),
(@NonCommunityPackagesId, 'microsoft.owin.pl', 0),
(@NonCommunityPackagesId, 'microsoft.owin.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.owin.ru', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.activedirectory', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.activedirectory.cs', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.activedirectory.de', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.activedirectory.es', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.activedirectory.fr', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.activedirectory.it', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.activedirectory.ja', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.activedirectory.ko', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.activedirectory.pl', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.activedirectory.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.activedirectory.ru', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.activedirectory.tr', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.activedirectory.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.activedirectory.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.cookies', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.cs', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.de', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.es', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.facebook', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.facebook.cs', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.facebook.de', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.facebook.es', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.facebook.fr', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.facebook.it', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.facebook.ja', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.facebook.ko', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.facebook.pl', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.facebook.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.facebook.ru', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.facebook.tr', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.facebook.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.facebook.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.forms', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.fr', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.google', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.google.cs', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.google.de', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.google.es', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.google.fr', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.google.it', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.google.ja', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.google.ko', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.google.pl', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.google.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.google.ru', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.google.tr', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.google.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.google.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.it', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.ja', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.jwt', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.jwt.cs', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.jwt.de', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.jwt.es', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.jwt.fr', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.jwt.it', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.jwt.ja', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.jwt.ko', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.jwt.pl', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.jwt.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.jwt.ru', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.jwt.tr', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.jwt.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.jwt.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.ko', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.microsoftaccount', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.microsoftaccount.cs', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.microsoftaccount.de', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.microsoftaccount.es', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.microsoftaccount.fr', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.microsoftaccount.it', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.microsoftaccount.ja', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.microsoftaccount.ko', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.microsoftaccount.pl', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.microsoftaccount.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.microsoftaccount.ru', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.microsoftaccount.tr', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.microsoftaccount.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.microsoftaccount.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.oauth', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.openidconnect', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.pl', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.ru', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.tr', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.twitter', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.twitter.cs', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.twitter.de', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.twitter.es', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.twitter.fr', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.twitter.it', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.twitter.ja', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.twitter.ko', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.twitter.pl', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.twitter.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.twitter.ru', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.twitter.tr', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.twitter.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.twitter.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.windowsazure', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.windowsazure.cs', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.windowsazure.de', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.windowsazure.es', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.windowsazure.fr', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.windowsazure.it', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.windowsazure.ja', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.windowsazure.ko', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.windowsazure.pl', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.windowsazure.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.windowsazure.ru', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.windowsazure.tr', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.windowsazure.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.windowsazure.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.wsfederation', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.owin.security.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.owin.selfhost', 0),
(@NonCommunityPackagesId, 'microsoft.owin.staticfiles', 0),
(@NonCommunityPackagesId, 'microsoft.owin.staticfiles.cs', 0),
(@NonCommunityPackagesId, 'microsoft.owin.staticfiles.de', 0),
(@NonCommunityPackagesId, 'microsoft.owin.staticfiles.es', 0),
(@NonCommunityPackagesId, 'microsoft.owin.staticfiles.fr', 0),
(@NonCommunityPackagesId, 'microsoft.owin.staticfiles.it', 0),
(@NonCommunityPackagesId, 'microsoft.owin.staticfiles.ja', 0),
(@NonCommunityPackagesId, 'microsoft.owin.staticfiles.ko', 0),
(@NonCommunityPackagesId, 'microsoft.owin.staticfiles.pl', 0),
(@NonCommunityPackagesId, 'microsoft.owin.staticfiles.pt-br', 0),
(@NonCommunityPackagesId, 'microsoft.owin.staticfiles.ru', 0),
(@NonCommunityPackagesId, 'microsoft.owin.staticfiles.tr', 0),
(@NonCommunityPackagesId, 'microsoft.owin.staticfiles.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.owin.staticfiles.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.owin.testing', 0),
(@NonCommunityPackagesId, 'microsoft.owin.tr', 0),
(@NonCommunityPackagesId, 'microsoft.owin.zh-hans', 0),
(@NonCommunityPackagesId, 'microsoft.owin.zh-hant', 0),
(@NonCommunityPackagesId, 'microsoft.packaging.tools', 0),
(@NonCommunityPackagesId, 'microsoft.packaging.tools.trimming', 0),
(@NonCommunityPackagesId, 'microsoft.preview.windowsazure.activedirectory.authentication', 0),
(@NonCommunityPackagesId, 'microsoft.private.corefx.uap', 0),
(@NonCommunityPackagesId, 'microsoft.private.intellisense', 0),
(@NonCommunityPackagesId, 'microsoft.private.packagebaseline', 0),
(@NonCommunityPackagesId, 'microsoft.research.dryad', 0),
(@NonCommunityPackagesId, 'microsoft.research.dryadlinq.samples', 0),
(@NonCommunityPackagesId, 'microsoft.research.peloponnese', 0),
(@NonCommunityPackagesId, 'microsoft.scriptmanager.jquery', 0),
(@NonCommunityPackagesId, 'microsoft.scriptmanager.jquery.ui.combined', 0),
(@NonCommunityPackagesId, 'microsoft.scriptmanager.msajax', 0),
(@NonCommunityPackagesId, 'microsoft.scriptmanager.webforms', 0),
(@NonCommunityPackagesId, 'microsoft.servicefabric', 0),
(@NonCommunityPackagesId, 'microsoft.sharepoint.emulators', 0),
(@NonCommunityPackagesId, 'microsoft.spatial', 0),
(@NonCommunityPackagesId, 'microsoft.sqlserver.compact', 0),
(@NonCommunityPackagesId, 'microsoft.syndicationfeed', 0),
(@NonCommunityPackagesId, 'microsoft.syndicationfeed.readerwriter', 0),
(@NonCommunityPackagesId, 'microsoft.targetingpack.private.coreclr', 0),
(@NonCommunityPackagesId, 'microsoft.targetingpack.private.netnative', 0),
(@NonCommunityPackagesId, 'microsoft.teamfoundation.distributedtask.common.contracts', 0),
(@NonCommunityPackagesId, 'microsoft.teamfoundation.distributedtask.webapi', 0),
(@NonCommunityPackagesId, 'microsoft.teamfoundationserver.client', 0),
(@NonCommunityPackagesId, 'microsoft.teamfoundationserver.extendedclient', 0),
(@NonCommunityPackagesId, 'microsoft.toolkit', 0),
(@NonCommunityPackagesId, 'microsoft.toolkit.services', 0),
(@NonCommunityPackagesId, 'microsoft.toolkit.uwp', 0),
(@NonCommunityPackagesId, 'microsoft.toolkit.uwp.connectivity', 0),
(@NonCommunityPackagesId, 'microsoft.toolkit.uwp.developertools', 0),
(@NonCommunityPackagesId, 'microsoft.toolkit.uwp.notifications', 0),
(@NonCommunityPackagesId, 'microsoft.toolkit.uwp.notifications.javascript', 0),
(@NonCommunityPackagesId, 'microsoft.toolkit.uwp.services', 0),
(@NonCommunityPackagesId, 'microsoft.toolkit.uwp.ui', 0),
(@NonCommunityPackagesId, 'microsoft.toolkit.uwp.ui.animations', 0),
(@NonCommunityPackagesId, 'microsoft.toolkit.uwp.ui.controls', 0),
(@NonCommunityPackagesId, 'microsoft.tpl.dataflow', 0),
(@NonCommunityPackagesId, 'microsoft.visualbasic', 0),
(@NonCommunityPackagesId, 'microsoft.visualstudio.commandbars', 0),
(@NonCommunityPackagesId, 'microsoft.visualstudio.languageservices', 0),
(@NonCommunityPackagesId, 'microsoft.visualstudio.sdk.embedinteroptypes', 0),
(@NonCommunityPackagesId, 'microsoft.visualstudio.services.client', 0),
(@NonCommunityPackagesId, 'microsoft.visualstudio.services.distributedtask.client', 0),
(@NonCommunityPackagesId, 'microsoft.visualstudio.services.extensionmanagement.webapi', 0),
(@NonCommunityPackagesId, 'microsoft.visualstudio.services.gallery.webapi', 0),
(@NonCommunityPackagesId, 'microsoft.visualstudio.services.interactiveclient', 0),
(@NonCommunityPackagesId, 'microsoft.visualstudio.services.memberentitlementmanagement.webapi', 0),
(@NonCommunityPackagesId, 'microsoft.visualstudio.services.notifications.webapi', 0),
(@NonCommunityPackagesId, 'microsoft.visualstudio.services.release.client', 0),
(@NonCommunityPackagesId, 'microsoft.visualstudio.services.servicehooks.webapi', 0),
(@NonCommunityPackagesId, 'microsoft.visualstudio.setup.configuration.interop', 0),
(@NonCommunityPackagesId, 'microsoft.visualstudio.setup.configuration.native', 0),
(@NonCommunityPackagesId, 'microsoft.visualstudio.validation', 0),
(@NonCommunityPackagesId, 'microsoft.visualstudio.web.browserlink.loader', 0),
(@NonCommunityPackagesId, 'microsoft.web.administration', 0),
(@NonCommunityPackagesId, 'microsoft.web.infrastructure', 0),
(@NonCommunityPackagesId, 'microsoft.web.optimization', 0),
(@NonCommunityPackagesId, 'microsoft.web.sessionstate.sqlinmemory', 0),
(@NonCommunityPackagesId, 'microsoft.web.webjobs.publish', 0),
(@NonCommunityPackagesId, 'microsoft.web.xdt', 0),
(@NonCommunityPackagesId, 'microsoft.win32.primitives', 0),
(@NonCommunityPackagesId, 'microsoft.win32.registry', 0),
(@NonCommunityPackagesId, 'microsoft.win32.registry.accesscontrol', 0),
(@NonCommunityPackagesId, 'microsoft.windows.ocr', 0),
(@NonCommunityPackagesId, 'microsoft.windows.storebroker', 0),
(@NonCommunityPackagesId, 'microsoft.windowsazure.activedirectory.authentication', 0),
(@NonCommunityPackagesId, 'microsoft.windowsazure.activedirectory.authentication.x64', 0),
(@NonCommunityPackagesId, 'microsoft.windowsazure.activedirectory.authentication.x86', 0),
(@NonCommunityPackagesId, 'microsoft.windowsazure.caching', 0),
(@NonCommunityPackagesId, 'microsoft.windowsazure.caching.memcacheshim', 0),
(@NonCommunityPackagesId, 'microsoft.windowsazure.configurationmanager', 0),
(@NonCommunityPackagesId, 'microsoft.windowsazure.storageclient', 0),
(@NonCommunityPackagesId, 'microsoft.windowspreview.midirt', 0),
(@NonCommunityPackagesId, 'microsoft.xaml.behaviors.uwp.managed', 0),
(@NonCommunityPackagesId, 'microsoft.xaml.behaviors.uwp.native', 0),
(@NonCommunityPackagesId, 'microsoft.xmlserializer.generator', 0),
(@NonCommunityPackagesId, 'microsoftajax', 0),
(@NonCommunityPackagesId, 'microsoftmvcajax.mvc5', 0),
(@NonCommunityPackagesId, 'microsoft-web-helpers', 0),
(@NonCommunityPackagesId, 'microsoftwebmvc', 0),
(@NonCommunityPackagesId, 'mvc2futures', 0),
(@NonCommunityPackagesId, 'mvc3futures', 0),
(@NonCommunityPackagesId, 'mvc4futures', 0),
(@NonCommunityPackagesId, 'mvcdiagnostics', 0),
(@NonCommunityPackagesId, 'netstandard.library', 0),
(@NonCommunityPackagesId, 'netstandard.library.netframework', 0),
(@NonCommunityPackagesId, 'owinhost', 0),
(@NonCommunityPackagesId, 'pagegenerator', 0),
(@NonCommunityPackagesId, 'paypal.helper', 0),
(@NonCommunityPackagesId, 'photo.gallery.template.vb2', 0),
(@NonCommunityPackagesId, 'riaservices.ef4', 0),
(@NonCommunityPackagesId, 'riaservices.endpoints', 0),
(@NonCommunityPackagesId, 'riaservices.entityframework', 0),
(@NonCommunityPackagesId, 'riaservices.jquery', 0),
(@NonCommunityPackagesId, 'riaservices.jquery.sample', 0),
(@NonCommunityPackagesId, 'riaservices.linqtosql', 0),
(@NonCommunityPackagesId, 'riaservices.server', 0),
(@NonCommunityPackagesId, 'riaservices.silverlight', 0),
(@NonCommunityPackagesId, 'riaservices.silverlight.domaindatasource', 0),
(@NonCommunityPackagesId, 'riaservices.t4', 0),
(@NonCommunityPackagesId, 'riaservices.toolkit.all', 0),
(@NonCommunityPackagesId, 'riaservices.unittesting', 0),
(@NonCommunityPackagesId, 'riaservices.viewmodel', 0),
(@NonCommunityPackagesId, 'riaservices.webforms', 0),
(@NonCommunityPackagesId, 'riaservices.windowsazure', 0),
(@NonCommunityPackagesId, 'roslyn', 0),
(@NonCommunityPackagesId, 'runtime.any.system.appcontext', 0),
(@NonCommunityPackagesId, 'runtime.any.system.collections', 0),
(@NonCommunityPackagesId, 'runtime.any.system.diagnostics.tools', 0),
(@NonCommunityPackagesId, 'runtime.any.system.diagnostics.tracing', 0),
(@NonCommunityPackagesId, 'runtime.any.system.globalization', 0),
(@NonCommunityPackagesId, 'runtime.any.system.globalization.calendars', 0),
(@NonCommunityPackagesId, 'runtime.any.system.io', 0),
(@NonCommunityPackagesId, 'runtime.any.system.linq.expressions', 0),
(@NonCommunityPackagesId, 'runtime.any.system.private.datacontractserialization', 0),
(@NonCommunityPackagesId, 'runtime.any.system.reflection', 0),
(@NonCommunityPackagesId, 'runtime.any.system.reflection.dispatchproxy', 0),
(@NonCommunityPackagesId, 'runtime.any.system.reflection.extensions', 0),
(@NonCommunityPackagesId, 'runtime.any.system.reflection.primitives', 0),
(@NonCommunityPackagesId, 'runtime.any.system.resources.resourcemanager', 0),
(@NonCommunityPackagesId, 'runtime.any.system.runtime', 0),
(@NonCommunityPackagesId, 'runtime.any.system.runtime.handles', 0),
(@NonCommunityPackagesId, 'runtime.any.system.runtime.interopservices', 0),
(@NonCommunityPackagesId, 'runtime.any.system.text.encoding', 0),
(@NonCommunityPackagesId, 'runtime.any.system.text.encoding.extensions', 0),
(@NonCommunityPackagesId, 'runtime.any.system.threading.tasks', 0),
(@NonCommunityPackagesId, 'runtime.any.system.threading.timer', 0),
(@NonCommunityPackagesId, 'runtime.any.system.xml.xmlserializer', 0),
(@NonCommunityPackagesId, 'runtime.aot.system.collections', 0),
(@NonCommunityPackagesId, 'runtime.aot.system.diagnostics.tools', 0),
(@NonCommunityPackagesId, 'runtime.aot.system.diagnostics.tracing', 0),
(@NonCommunityPackagesId, 'runtime.aot.system.globalization', 0),
(@NonCommunityPackagesId, 'runtime.aot.system.globalization.calendars', 0),
(@NonCommunityPackagesId, 'runtime.aot.system.io', 0),
(@NonCommunityPackagesId, 'runtime.aot.system.linq.expressions', 0),
(@NonCommunityPackagesId, 'runtime.aot.system.private.datacontractserialization', 0),
(@NonCommunityPackagesId, 'runtime.aot.system.reflection', 0),
(@NonCommunityPackagesId, 'runtime.aot.system.reflection.dispatchproxy', 0),
(@NonCommunityPackagesId, 'runtime.aot.system.reflection.extensions', 0),
(@NonCommunityPackagesId, 'runtime.aot.system.reflection.primitives', 0),
(@NonCommunityPackagesId, 'runtime.aot.system.resources.resourcemanager', 0),
(@NonCommunityPackagesId, 'runtime.aot.system.runtime', 0),
(@NonCommunityPackagesId, 'runtime.aot.system.runtime.handles', 0),
(@NonCommunityPackagesId, 'runtime.aot.system.runtime.interopservices', 0),
(@NonCommunityPackagesId, 'runtime.aot.system.text.encoding', 0),
(@NonCommunityPackagesId, 'runtime.aot.system.text.encoding.extensions', 0),
(@NonCommunityPackagesId, 'runtime.aot.system.threading.tasks', 0),
(@NonCommunityPackagesId, 'runtime.aot.system.threading.timer', 0),
(@NonCommunityPackagesId, 'runtime.aot.system.xml.xmlserializer', 0),
(@NonCommunityPackagesId, 'runtime.centos.7.1-x64.microsoft.netcore.consolehost', 0),
(@NonCommunityPackagesId, 'runtime.centos.7.1-x64.microsoft.netcore.runtime.coreclr', 0),
(@NonCommunityPackagesId, 'runtime.centos.7.1-x64.microsoft.netcore.testhost', 0),
(@NonCommunityPackagesId, 'runtime.debian.8-x64.microsoft.netcore.consolehost', 0),
(@NonCommunityPackagesId, 'runtime.debian.8-x64.microsoft.netcore.dotnethost', 0),
(@NonCommunityPackagesId, 'runtime.debian.8-x64.microsoft.netcore.dotnethostpolicy', 0),
(@NonCommunityPackagesId, 'runtime.debian.8-x64.microsoft.netcore.dotnethostresolver', 0),
(@NonCommunityPackagesId, 'runtime.debian.8-x64.microsoft.netcore.ilasm', 0),
(@NonCommunityPackagesId, 'runtime.debian.8-x64.microsoft.netcore.ildasm', 0),
(@NonCommunityPackagesId, 'runtime.debian.8-x64.microsoft.netcore.jit', 0),
(@NonCommunityPackagesId, 'runtime.debian.8-x64.microsoft.netcore.native', 0),
(@NonCommunityPackagesId, 'runtime.debian.8-x64.microsoft.netcore.runtime.coreclr', 0),
(@NonCommunityPackagesId, 'runtime.debian.8-x64.microsoft.netcore.testhost', 0),
(@NonCommunityPackagesId, 'runtime.debian.8-x64.runtime.native.system', 0),
(@NonCommunityPackagesId, 'runtime.debian.8-x64.runtime.native.system.io.compression', 0),
(@NonCommunityPackagesId, 'runtime.debian.8-x64.runtime.native.system.net.http', 0),
(@NonCommunityPackagesId, 'runtime.debian.8-x64.runtime.native.system.net.security', 0),
(@NonCommunityPackagesId, 'runtime.debian.8-x64.runtime.native.system.security.cryptography', 0),
(@NonCommunityPackagesId, 'runtime.debian.8-x64.runtime.native.system.security.cryptography.openssl', 0),
(@NonCommunityPackagesId, 'runtime.fedora.23-x64.microsoft.netcore.dotnethost', 0),
(@NonCommunityPackagesId, 'runtime.fedora.23-x64.microsoft.netcore.dotnethostpolicy', 0),
(@NonCommunityPackagesId, 'runtime.fedora.23-x64.microsoft.netcore.dotnethostresolver', 0),
(@NonCommunityPackagesId, 'runtime.fedora.23-x64.microsoft.netcore.ilasm', 0),
(@NonCommunityPackagesId, 'runtime.fedora.23-x64.microsoft.netcore.ildasm', 0),
(@NonCommunityPackagesId, 'runtime.fedora.23-x64.microsoft.netcore.jit', 0),
(@NonCommunityPackagesId, 'runtime.fedora.23-x64.microsoft.netcore.runtime.coreclr', 0),
(@NonCommunityPackagesId, 'runtime.fedora.23-x64.microsoft.netcore.testhost', 0),
(@NonCommunityPackagesId, 'runtime.fedora.23-x64.runtime.native.system', 0),
(@NonCommunityPackagesId, 'runtime.fedora.23-x64.runtime.native.system.io.compression', 0),
(@NonCommunityPackagesId, 'runtime.fedora.23-x64.runtime.native.system.net.http', 0),
(@NonCommunityPackagesId, 'runtime.fedora.23-x64.runtime.native.system.net.security', 0),
(@NonCommunityPackagesId, 'runtime.fedora.23-x64.runtime.native.system.security.cryptography', 0),
(@NonCommunityPackagesId, 'runtime.fedora.23-x64.runtime.native.system.security.cryptography.openssl', 0),
(@NonCommunityPackagesId, 'runtime.fedora.24-x64.microsoft.netcore.dotnethost', 0),
(@NonCommunityPackagesId, 'runtime.fedora.24-x64.microsoft.netcore.dotnethostpolicy', 0),
(@NonCommunityPackagesId, 'runtime.fedora.24-x64.microsoft.netcore.dotnethostresolver', 0),
(@NonCommunityPackagesId, 'runtime.fedora.24-x64.microsoft.netcore.ilasm', 0),
(@NonCommunityPackagesId, 'runtime.fedora.24-x64.microsoft.netcore.ildasm', 0),
(@NonCommunityPackagesId, 'runtime.fedora.24-x64.microsoft.netcore.jit', 0),
(@NonCommunityPackagesId, 'runtime.fedora.24-x64.microsoft.netcore.native', 0),
(@NonCommunityPackagesId, 'runtime.fedora.24-x64.microsoft.netcore.runtime.coreclr', 0),
(@NonCommunityPackagesId, 'runtime.fedora.24-x64.microsoft.netcore.testhost', 0),
(@NonCommunityPackagesId, 'runtime.fedora.24-x64.runtime.native.system', 0),
(@NonCommunityPackagesId, 'runtime.fedora.24-x64.runtime.native.system.io.compression', 0),
(@NonCommunityPackagesId, 'runtime.fedora.24-x64.runtime.native.system.net.http', 0),
(@NonCommunityPackagesId, 'runtime.fedora.24-x64.runtime.native.system.net.security', 0),
(@NonCommunityPackagesId, 'runtime.fedora.24-x64.runtime.native.system.security.cryptography', 0),
(@NonCommunityPackagesId, 'runtime.fedora.24-x64.runtime.native.system.security.cryptography.openssl', 0),
(@NonCommunityPackagesId, 'runtime.linux.system.diagnostics.process', 0),
(@NonCommunityPackagesId, 'runtime.linux.system.io.filesystem', 0),
(@NonCommunityPackagesId, 'runtime.linux.system.io.filesystem.driveinfo', 0),
(@NonCommunityPackagesId, 'runtime.linux.system.io.filesystem.watcher', 0),
(@NonCommunityPackagesId, 'runtime.linux.system.io.memorymappedfiles', 0),
(@NonCommunityPackagesId, 'runtime.linux.system.net.http', 0),
(@NonCommunityPackagesId, 'runtime.linux.system.net.nameresolution', 0),
(@NonCommunityPackagesId, 'runtime.linux.system.net.networkinformation', 0),
(@NonCommunityPackagesId, 'runtime.linux.system.net.sockets', 0),
(@NonCommunityPackagesId, 'runtime.linux.system.runtime.extensions', 0),
(@NonCommunityPackagesId, 'runtime.linux.system.runtime.interopservices.runtimeinformation', 0),
(@NonCommunityPackagesId, 'runtime.linux.system.security.cryptography.algorithms', 0),
(@NonCommunityPackagesId, 'runtime.linux-arm.microsoft.netcore.app', 0),
(@NonCommunityPackagesId, 'runtime.linux-arm.microsoft.netcore.dotnetapphost', 0),
(@NonCommunityPackagesId, 'runtime.linux-arm.microsoft.netcore.dotnethost', 0),
(@NonCommunityPackagesId, 'runtime.linux-arm.microsoft.netcore.dotnethostpolicy', 0),
(@NonCommunityPackagesId, 'runtime.linux-arm.microsoft.netcore.dotnethostresolver', 0),
(@NonCommunityPackagesId, 'runtime.linux-arm.microsoft.netcore.ilasm', 0),
(@NonCommunityPackagesId, 'runtime.linux-arm.microsoft.netcore.ildasm', 0),
(@NonCommunityPackagesId, 'runtime.linux-arm.microsoft.netcore.jit', 0),
(@NonCommunityPackagesId, 'runtime.linux-arm.microsoft.netcore.native', 0),
(@NonCommunityPackagesId, 'runtime.linux-arm.microsoft.netcore.runtime.coreclr', 0),
(@NonCommunityPackagesId, 'runtime.linux-arm.microsoft.netcore.testhost', 0),
(@NonCommunityPackagesId, 'runtime.linux-x64.microsoft.netcore.app', 0),
(@NonCommunityPackagesId, 'runtime.linux-x64.microsoft.netcore.dotnetapphost', 0),
(@NonCommunityPackagesId, 'runtime.linux-x64.microsoft.netcore.dotnethost', 0),
(@NonCommunityPackagesId, 'runtime.linux-x64.microsoft.netcore.dotnethostpolicy', 0),
(@NonCommunityPackagesId, 'runtime.linux-x64.microsoft.netcore.dotnethostresolver', 0),
(@NonCommunityPackagesId, 'runtime.linux-x64.microsoft.netcore.ilasm', 0),
(@NonCommunityPackagesId, 'runtime.linux-x64.microsoft.netcore.ildasm', 0),
(@NonCommunityPackagesId, 'runtime.linux-x64.microsoft.netcore.jit', 0),
(@NonCommunityPackagesId, 'runtime.linux-x64.microsoft.netcore.native', 0),
(@NonCommunityPackagesId, 'runtime.linux-x64.microsoft.netcore.runtime.coreclr', 0),
(@NonCommunityPackagesId, 'runtime.linux-x64.microsoft.netcore.testhost', 0),
(@NonCommunityPackagesId, 'runtime.native.system', 0),
(@NonCommunityPackagesId, 'runtime.native.system.data.sqlclient.sni', 0),
(@NonCommunityPackagesId, 'runtime.native.system.io.compression', 0),
(@NonCommunityPackagesId, 'runtime.native.system.net.http', 0),
(@NonCommunityPackagesId, 'runtime.native.system.net.security', 0),
(@NonCommunityPackagesId, 'runtime.native.system.security.cryptography', 0),
(@NonCommunityPackagesId, 'runtime.native.system.security.cryptography.apple', 0),
(@NonCommunityPackagesId, 'runtime.native.system.security.cryptography.openssl', 0),
(@NonCommunityPackagesId, 'runtime.opensuse.13.2-x64.microsoft.netcore.dotnethost', 0),
(@NonCommunityPackagesId, 'runtime.opensuse.13.2-x64.microsoft.netcore.dotnethostpolicy', 0),
(@NonCommunityPackagesId, 'runtime.opensuse.13.2-x64.microsoft.netcore.dotnethostresolver', 0),
(@NonCommunityPackagesId, 'runtime.opensuse.13.2-x64.microsoft.netcore.ilasm', 0),
(@NonCommunityPackagesId, 'runtime.opensuse.13.2-x64.microsoft.netcore.ildasm', 0),
(@NonCommunityPackagesId, 'runtime.opensuse.13.2-x64.microsoft.netcore.jit', 0),
(@NonCommunityPackagesId, 'runtime.opensuse.13.2-x64.microsoft.netcore.runtime.coreclr', 0),
(@NonCommunityPackagesId, 'runtime.opensuse.13.2-x64.microsoft.netcore.testhost', 0),
(@NonCommunityPackagesId, 'runtime.opensuse.13.2-x64.runtime.native.system', 0),
(@NonCommunityPackagesId, 'runtime.opensuse.13.2-x64.runtime.native.system.io.compression', 0),
(@NonCommunityPackagesId, 'runtime.opensuse.13.2-x64.runtime.native.system.net.http', 0),
(@NonCommunityPackagesId, 'runtime.opensuse.13.2-x64.runtime.native.system.net.security', 0),
(@NonCommunityPackagesId, 'runtime.opensuse.13.2-x64.runtime.native.system.security.cryptography', 0),
(@NonCommunityPackagesId, 'runtime.opensuse.13.2-x64.runtime.native.system.security.cryptography.openssl', 0),
(@NonCommunityPackagesId, 'runtime.opensuse.42.1-x64.microsoft.netcore.dotnethost', 0),
(@NonCommunityPackagesId, 'runtime.opensuse.42.1-x64.microsoft.netcore.dotnethostpolicy', 0),
(@NonCommunityPackagesId, 'runtime.opensuse.42.1-x64.microsoft.netcore.dotnethostresolver', 0),
(@NonCommunityPackagesId, 'runtime.opensuse.42.1-x64.microsoft.netcore.ilasm', 0),
(@NonCommunityPackagesId, 'runtime.opensuse.42.1-x64.microsoft.netcore.ildasm', 0),
(@NonCommunityPackagesId, 'runtime.opensuse.42.1-x64.microsoft.netcore.jit', 0),
(@NonCommunityPackagesId, 'runtime.opensuse.42.1-x64.microsoft.netcore.native', 0),
(@NonCommunityPackagesId, 'runtime.opensuse.42.1-x64.microsoft.netcore.runtime.coreclr', 0),
(@NonCommunityPackagesId, 'runtime.opensuse.42.1-x64.microsoft.netcore.testhost', 0),
(@NonCommunityPackagesId, 'runtime.opensuse.42.1-x64.runtime.native.system', 0),
(@NonCommunityPackagesId, 'runtime.opensuse.42.1-x64.runtime.native.system.io.compression', 0),
(@NonCommunityPackagesId, 'runtime.opensuse.42.1-x64.runtime.native.system.net.http', 0),
(@NonCommunityPackagesId, 'runtime.opensuse.42.1-x64.runtime.native.system.net.security', 0),
(@NonCommunityPackagesId, 'runtime.opensuse.42.1-x64.runtime.native.system.security.cryptography', 0),
(@NonCommunityPackagesId, 'runtime.opensuse.42.1-x64.runtime.native.system.security.cryptography.openssl', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.10.system.diagnostics.process', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.10.system.io.filesystem', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.10.system.io.filesystem.driveinfo', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.10.system.io.filesystem.watcher', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.10.system.io.memorymappedfiles', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.10.system.net.http', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.10.system.net.nameresolution', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.10.system.net.networkinformation', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.10.system.net.primitives', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.10.system.net.sockets', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.10.system.runtime.extensions', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.10.system.runtime.interopservices.runtimeinformation', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.10.system.security.cryptography.algorithms', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.10-x64.microsoft.netcore.consolehost', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.10-x64.microsoft.netcore.dotnethost', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.10-x64.microsoft.netcore.dotnethostpolicy', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.10-x64.microsoft.netcore.dotnethostresolver', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.10-x64.microsoft.netcore.ilasm', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.10-x64.microsoft.netcore.ildasm', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.10-x64.microsoft.netcore.jit', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.10-x64.microsoft.netcore.runtime.coreclr', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.10-x64.microsoft.netcore.testhost', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.10-x64.runtime.native.system', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.10-x64.runtime.native.system.io.compression', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.10-x64.runtime.native.system.net.http', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.10-x64.runtime.native.system.net.security', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.10-x64.runtime.native.system.security.cryptography', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.10-x64.runtime.native.system.security.cryptography.apple', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.10-x64.runtime.native.system.security.cryptography.openssl', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.12-x64.microsoft.netcore.ilasm', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.12-x64.microsoft.netcore.ildasm', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.12-x64.microsoft.netcore.jit', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.12-x64.microsoft.netcore.native', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.12-x64.microsoft.netcore.runtime.coreclr', 0),
(@NonCommunityPackagesId, 'runtime.osx.10.12-x64.microsoft.netcore.testhost', 0),
(@NonCommunityPackagesId, 'runtime.osx-x64.microsoft.netcore.app', 0),
(@NonCommunityPackagesId, 'runtime.osx-x64.microsoft.netcore.dotnetapphost', 0),
(@NonCommunityPackagesId, 'runtime.osx-x64.microsoft.netcore.dotnethost', 0),
(@NonCommunityPackagesId, 'runtime.osx-x64.microsoft.netcore.dotnethostpolicy', 0),
(@NonCommunityPackagesId, 'runtime.osx-x64.microsoft.netcore.dotnethostresolver', 0),
(@NonCommunityPackagesId, 'runtime.osx-x64.microsoft.netcore.ilasm', 0),
(@NonCommunityPackagesId, 'runtime.osx-x64.microsoft.netcore.ildasm', 0),
(@NonCommunityPackagesId, 'runtime.osx-x64.microsoft.netcore.jit', 0),
(@NonCommunityPackagesId, 'runtime.osx-x64.microsoft.netcore.native', 0),
(@NonCommunityPackagesId, 'runtime.osx-x64.microsoft.netcore.runtime.coreclr', 0),
(@NonCommunityPackagesId, 'runtime.osx-x64.microsoft.netcore.testhost', 0),
(@NonCommunityPackagesId, 'runtime.rhel.7-x64.microsoft.netcore.consolehost', 0),
(@NonCommunityPackagesId, 'runtime.rhel.7-x64.microsoft.netcore.dotnethost', 0),
(@NonCommunityPackagesId, 'runtime.rhel.7-x64.microsoft.netcore.dotnethostpolicy', 0),
(@NonCommunityPackagesId, 'runtime.rhel.7-x64.microsoft.netcore.dotnethostresolver', 0),
(@NonCommunityPackagesId, 'runtime.rhel.7-x64.microsoft.netcore.ilasm', 0),
(@NonCommunityPackagesId, 'runtime.rhel.7-x64.microsoft.netcore.ildasm', 0),
(@NonCommunityPackagesId, 'runtime.rhel.7-x64.microsoft.netcore.jit', 0),
(@NonCommunityPackagesId, 'runtime.rhel.7-x64.microsoft.netcore.native', 0),
(@NonCommunityPackagesId, 'runtime.rhel.7-x64.microsoft.netcore.runtime.coreclr', 0),
(@NonCommunityPackagesId, 'runtime.rhel.7-x64.microsoft.netcore.testhost', 0),
(@NonCommunityPackagesId, 'runtime.rhel.7-x64.runtime.native.system', 0),
(@NonCommunityPackagesId, 'runtime.rhel.7-x64.runtime.native.system.io.compression', 0),
(@NonCommunityPackagesId, 'runtime.rhel.7-x64.runtime.native.system.net.http', 0),
(@NonCommunityPackagesId, 'runtime.rhel.7-x64.runtime.native.system.net.security', 0),
(@NonCommunityPackagesId, 'runtime.rhel.7-x64.runtime.native.system.security.cryptography', 0),
(@NonCommunityPackagesId, 'runtime.rhel.7-x64.runtime.native.system.security.cryptography.openssl', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.14.04-arm.microsoft.netcore.ilasm', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.14.04-arm.microsoft.netcore.ildasm', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.14.04-arm.microsoft.netcore.jit', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.14.04-arm.microsoft.netcore.native', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.14.04-arm.microsoft.netcore.runtime.coreclr', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.14.04-arm.microsoft.netcore.testhost', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.14.04-x64.microsoft.netcore.consolehost', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.14.04-x64.microsoft.netcore.dotnethost', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.14.04-x64.microsoft.netcore.dotnethostpolicy', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.14.04-x64.microsoft.netcore.dotnethostresolver', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.14.04-x64.microsoft.netcore.ilasm', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.14.04-x64.microsoft.netcore.ildasm', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.14.04-x64.microsoft.netcore.jit', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.14.04-x64.microsoft.netcore.native', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.14.04-x64.microsoft.netcore.runtime.coreclr', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.14.04-x64.microsoft.netcore.testhost', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.14.04-x64.runtime.native.system', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.14.04-x64.runtime.native.system.io.compression', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.14.04-x64.runtime.native.system.net.http', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.14.04-x64.runtime.native.system.net.security', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.14.04-x64.runtime.native.system.security.cryptography', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.14.04-x64.runtime.native.system.security.cryptography.openssl', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.04-arm.microsoft.netcore.ilasm', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.04-arm.microsoft.netcore.ildasm', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.04-arm.microsoft.netcore.jit', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.04-arm.microsoft.netcore.native', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.04-arm.microsoft.netcore.runtime.coreclr', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.04-arm.microsoft.netcore.testhost', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.04-x64.microsoft.netcore.dotnethost', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.04-x64.microsoft.netcore.dotnethostpolicy', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.04-x64.microsoft.netcore.dotnethostresolver', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.04-x64.microsoft.netcore.ilasm', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.04-x64.microsoft.netcore.ildasm', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.04-x64.microsoft.netcore.jit', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.04-x64.microsoft.netcore.native', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.04-x64.microsoft.netcore.runtime.coreclr', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.04-x64.microsoft.netcore.testhost', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.04-x64.runtime.native.system', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.04-x64.runtime.native.system.io.compression', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.04-x64.runtime.native.system.net.http', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.04-x64.runtime.native.system.net.security', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.04-x64.runtime.native.system.security.cryptography', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.04-x64.runtime.native.system.security.cryptography.openssl', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.10-x64.microsoft.netcore.dotnethost', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.10-x64.microsoft.netcore.dotnethostpolicy', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.10-x64.microsoft.netcore.dotnethostresolver', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.10-x64.microsoft.netcore.ilasm', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.10-x64.microsoft.netcore.ildasm', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.10-x64.microsoft.netcore.jit', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.10-x64.microsoft.netcore.native', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.10-x64.microsoft.netcore.runtime.coreclr', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.10-x64.microsoft.netcore.testhost', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.10-x64.runtime.native.system', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.10-x64.runtime.native.system.io.compression', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.10-x64.runtime.native.system.net.http', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.10-x64.runtime.native.system.net.security', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.10-x64.runtime.native.system.security.cryptography', 0),
(@NonCommunityPackagesId, 'runtime.ubuntu.16.10-x64.runtime.native.system.security.cryptography.openssl', 0),
(@NonCommunityPackagesId, 'runtime.unix.microsoft.win32.primitives', 0),
(@NonCommunityPackagesId, 'runtime.unix.system.console', 0),
(@NonCommunityPackagesId, 'runtime.unix.system.data.sqlclient', 0),
(@NonCommunityPackagesId, 'runtime.unix.system.diagnostics.debug', 0),
(@NonCommunityPackagesId, 'runtime.unix.system.diagnostics.fileversioninfo', 0),
(@NonCommunityPackagesId, 'runtime.unix.system.diagnostics.tracesource', 0),
(@NonCommunityPackagesId, 'runtime.unix.system.globalization.extensions', 0),
(@NonCommunityPackagesId, 'runtime.unix.system.io.compression', 0),
(@NonCommunityPackagesId, 'runtime.unix.system.io.filesystem', 0),
(@NonCommunityPackagesId, 'runtime.unix.system.io.pipes', 0),
(@NonCommunityPackagesId, 'runtime.unix.system.net.primitives', 0),
(@NonCommunityPackagesId, 'runtime.unix.system.net.requests', 0),
(@NonCommunityPackagesId, 'runtime.unix.system.net.security', 0),
(@NonCommunityPackagesId, 'runtime.unix.system.net.sockets', 0),
(@NonCommunityPackagesId, 'runtime.unix.system.net.websockets.client', 0),
(@NonCommunityPackagesId, 'runtime.unix.system.private.uri', 0),
(@NonCommunityPackagesId, 'runtime.unix.system.runtime.extensions', 0),
(@NonCommunityPackagesId, 'runtime.unix.system.runtime.interopservices.runtimeinformation', 0),
(@NonCommunityPackagesId, 'runtime.unix.system.security.cryptography.encoding', 0),
(@NonCommunityPackagesId, 'runtime.unix.system.security.cryptography.x509certificates', 0),
(@NonCommunityPackagesId, 'runtime.unix.system.text.encoding.codepages', 0),
(@NonCommunityPackagesId, 'runtime.unix.system.threading', 0),
(@NonCommunityPackagesId, 'runtime.win.microsoft.win32.primitives', 0),
(@NonCommunityPackagesId, 'runtime.win.system.console', 0),
(@NonCommunityPackagesId, 'runtime.win.system.diagnostics.debug', 0),
(@NonCommunityPackagesId, 'runtime.win.system.io.filesystem', 0),
(@NonCommunityPackagesId, 'runtime.win.system.net.primitives', 0),
(@NonCommunityPackagesId, 'runtime.win.system.net.sockets', 0),
(@NonCommunityPackagesId, 'runtime.win.system.runtime.extensions', 0),
(@NonCommunityPackagesId, 'runtime.win.system.runtime.interopservices.runtimeinformation', 0),
(@NonCommunityPackagesId, 'runtime.win.system.text.encoding.codepages', 0),
(@NonCommunityPackagesId, 'runtime.win10-arm.microsoft.net.uwpcoreruntimesdk', 0),
(@NonCommunityPackagesId, 'runtime.win10-arm.microsoft.netcore.universalwindowsplatform', 0),
(@NonCommunityPackagesId, 'runtime.win10-arm.runtime.native.system.io.compression', 0),
(@NonCommunityPackagesId, 'runtime.win10-arm64.microsoft.netcore.dotnethostpolicy', 0),
(@NonCommunityPackagesId, 'runtime.win10-arm64.microsoft.netcore.ilasm', 0),
(@NonCommunityPackagesId, 'runtime.win10-arm64.microsoft.netcore.ildasm', 0),
(@NonCommunityPackagesId, 'runtime.win10-arm64.microsoft.netcore.jit', 0),
(@NonCommunityPackagesId, 'runtime.win10-arm64.microsoft.netcore.runtime.coreclr', 0),
(@NonCommunityPackagesId, 'runtime.win10-arm64.microsoft.netcore.testhost', 0),
(@NonCommunityPackagesId, 'runtime.win10-arm64.runtime.native.system.io.compression', 0),
(@NonCommunityPackagesId, 'runtime.win10-arm-aot.microsoft.netcore.universalwindowsplatform', 0),
(@NonCommunityPackagesId, 'runtime.win10-arm-aot.runtime.native.system.io.compression', 0),
(@NonCommunityPackagesId, 'runtime.win10-x64.microsoft.net.uwpcoreruntimesdk', 0),
(@NonCommunityPackagesId, 'runtime.win10-x64.microsoft.netcore.universalwindowsplatform', 0),
(@NonCommunityPackagesId, 'runtime.win10-x64.runtime.native.system.io.compression', 0),
(@NonCommunityPackagesId, 'runtime.win10-x64-aot.microsoft.netcore.universalwindowsplatform', 0),
(@NonCommunityPackagesId, 'runtime.win10-x64-aot.runtime.native.system.io.compression', 0),
(@NonCommunityPackagesId, 'runtime.win10-x86.microsoft.net.uwpcoreruntimesdk', 0),
(@NonCommunityPackagesId, 'runtime.win10-x86.microsoft.netcore.universalwindowsplatform', 0),
(@NonCommunityPackagesId, 'runtime.win10-x86.runtime.native.system.io.compression', 0),
(@NonCommunityPackagesId, 'runtime.win10-x86-aot.microsoft.netcore.universalwindowsplatform', 0),
(@NonCommunityPackagesId, 'runtime.win10-x86-aot.runtime.native.system.io.compression', 0),
(@NonCommunityPackagesId, 'runtime.win7.microsoft.win32.primitives', 0),
(@NonCommunityPackagesId, 'runtime.win7.system.console', 0),
(@NonCommunityPackagesId, 'runtime.win7.system.data.sqlclient', 0),
(@NonCommunityPackagesId, 'runtime.win7.system.diagnostics.debug', 0),
(@NonCommunityPackagesId, 'runtime.win7.system.diagnostics.fileversioninfo', 0),
(@NonCommunityPackagesId, 'runtime.win7.system.diagnostics.process', 0),
(@NonCommunityPackagesId, 'runtime.win7.system.diagnostics.tracesource', 0),
(@NonCommunityPackagesId, 'runtime.win7.system.globalization.extensions', 0),
(@NonCommunityPackagesId, 'runtime.win7.system.io.compression', 0),
(@NonCommunityPackagesId, 'runtime.win7.system.io.filesystem', 0),
(@NonCommunityPackagesId, 'runtime.win7.system.io.filesystem.driveinfo', 0),
(@NonCommunityPackagesId, 'runtime.win7.system.io.filesystem.watcher', 0),
(@NonCommunityPackagesId, 'runtime.win7.system.io.memorymappedfiles', 0),
(@NonCommunityPackagesId, 'runtime.win7.system.io.pipes', 0),
(@NonCommunityPackagesId, 'runtime.win7.system.net.http', 0),
(@NonCommunityPackagesId, 'runtime.win7.system.net.nameresolution', 0),
(@NonCommunityPackagesId, 'runtime.win7.system.net.networkinformation', 0),
(@NonCommunityPackagesId, 'runtime.win7.system.net.primitives', 0),
(@NonCommunityPackagesId, 'runtime.win7.system.net.requests', 0),
(@NonCommunityPackagesId, 'runtime.win7.system.net.security', 0),
(@NonCommunityPackagesId, 'runtime.win7.system.net.sockets', 0),
(@NonCommunityPackagesId, 'runtime.win7.system.net.websockets.client', 0),
(@NonCommunityPackagesId, 'runtime.win7.system.private.uri', 0),
(@NonCommunityPackagesId, 'runtime.win7.system.runtime.extensions', 0),
(@NonCommunityPackagesId, 'runtime.win7.system.runtime.interopservices.runtimeinformation', 0),
(@NonCommunityPackagesId, 'runtime.win7.system.security.cryptography.algorithms', 0),
(@NonCommunityPackagesId, 'runtime.win7.system.security.cryptography.encoding', 0),
(@NonCommunityPackagesId, 'runtime.win7.system.security.cryptography.x509certificates', 0),
(@NonCommunityPackagesId, 'runtime.win7.system.text.encoding.codepages', 0),
(@NonCommunityPackagesId, 'runtime.win7.system.threading', 0),
(@NonCommunityPackagesId, 'runtime.win7-arm.microsoft.netcore.consolehost', 0),
(@NonCommunityPackagesId, 'runtime.win7-arm.microsoft.netcore.testhost', 0),
(@NonCommunityPackagesId, 'runtime.win7-arm.runtime.native.system.io.compression', 0),
(@NonCommunityPackagesId, 'runtime.win7-arm.system.io.compression.clrcompression', 0),
(@NonCommunityPackagesId, 'runtime.win7-x64.microsoft.netcore.consolehost', 0),
(@NonCommunityPackagesId, 'runtime.win7-x64.microsoft.netcore.dotnethost', 0),
(@NonCommunityPackagesId, 'runtime.win7-x64.microsoft.netcore.dotnethostpolicy', 0),
(@NonCommunityPackagesId, 'runtime.win7-x64.microsoft.netcore.dotnethostresolver', 0),
(@NonCommunityPackagesId, 'runtime.win7-x64.microsoft.netcore.ilasm', 0),
(@NonCommunityPackagesId, 'runtime.win7-x64.microsoft.netcore.ildasm', 0),
(@NonCommunityPackagesId, 'runtime.win7-x64.microsoft.netcore.jit', 0),
(@NonCommunityPackagesId, 'runtime.win7-x64.microsoft.netcore.runtime.coreclr', 0),
(@NonCommunityPackagesId, 'runtime.win7-x64.microsoft.netcore.testhost', 0),
(@NonCommunityPackagesId, 'runtime.win7-x64.microsoft.netcore.windows.apisets', 0),
(@NonCommunityPackagesId, 'runtime.win7-x64.runtime.native.system.data.sqlclient.sni', 0),
(@NonCommunityPackagesId, 'runtime.win7-x64.runtime.native.system.io.compression', 0),
(@NonCommunityPackagesId, 'runtime.win7-x64.system.data.sqlclient.sni', 0),
(@NonCommunityPackagesId, 'runtime.win7-x64.system.io.compression.clrcompression', 0),
(@NonCommunityPackagesId, 'runtime.win7-x86.microsoft.netcore.consolehost', 0),
(@NonCommunityPackagesId, 'runtime.win7-x86.microsoft.netcore.dotnethost', 0),
(@NonCommunityPackagesId, 'runtime.win7-x86.microsoft.netcore.dotnethostpolicy', 0),
(@NonCommunityPackagesId, 'runtime.win7-x86.microsoft.netcore.dotnethostresolver', 0),
(@NonCommunityPackagesId, 'runtime.win7-x86.microsoft.netcore.ilasm', 0),
(@NonCommunityPackagesId, 'runtime.win7-x86.microsoft.netcore.ildasm', 0),
(@NonCommunityPackagesId, 'runtime.win7-x86.microsoft.netcore.jit', 0),
(@NonCommunityPackagesId, 'runtime.win7-x86.microsoft.netcore.runtime.coreclr', 0),
(@NonCommunityPackagesId, 'runtime.win7-x86.microsoft.netcore.testhost', 0),
(@NonCommunityPackagesId, 'runtime.win7-x86.microsoft.netcore.windows.apisets', 0),
(@NonCommunityPackagesId, 'runtime.win7-x86.runtime.native.system.data.sqlclient.sni', 0),
(@NonCommunityPackagesId, 'runtime.win7-x86.runtime.native.system.io.compression', 0),
(@NonCommunityPackagesId, 'runtime.win7-x86.system.data.sqlclient.sni', 0),
(@NonCommunityPackagesId, 'runtime.win7-x86.system.io.compression.clrcompression', 0),
(@NonCommunityPackagesId, 'runtime.win81-x64.microsoft.netcore.windows.apisets', 0),
(@NonCommunityPackagesId, 'runtime.win81-x86.microsoft.netcore.windows.apisets', 0),
(@NonCommunityPackagesId, 'runtime.win8-arm.microsoft.netcore.ilasm', 0),
(@NonCommunityPackagesId, 'runtime.win8-arm.microsoft.netcore.ildasm', 0),
(@NonCommunityPackagesId, 'runtime.win8-arm.microsoft.netcore.jit', 0),
(@NonCommunityPackagesId, 'runtime.win8-arm.microsoft.netcore.runtime.coreclr', 0),
(@NonCommunityPackagesId, 'runtime.win8-arm.microsoft.netcore.testhost', 0),
(@NonCommunityPackagesId, 'runtime.win8-arm.runtime.native.system.io.compression', 0),
(@NonCommunityPackagesId, 'runtime.win8-arm64.microsoft.netcore.runtime.coreclr', 0),
(@NonCommunityPackagesId, 'runtime.win8-x64.microsoft.netcore.windows.apisets', 0),
(@NonCommunityPackagesId, 'runtime.win8-x86.microsoft.netcore.windows.apisets', 0),
(@NonCommunityPackagesId, 'runtime.win-arm.microsoft.netcore.app', 0),
(@NonCommunityPackagesId, 'runtime.win-arm.microsoft.netcore.dotnetapphost', 0),
(@NonCommunityPackagesId, 'runtime.win-arm.microsoft.netcore.dotnethost', 0),
(@NonCommunityPackagesId, 'runtime.win-arm.microsoft.netcore.dotnethostpolicy', 0),
(@NonCommunityPackagesId, 'runtime.win-arm.microsoft.netcore.dotnethostresolver', 0),
(@NonCommunityPackagesId, 'runtime.win-arm.microsoft.netcore.ilasm', 0),
(@NonCommunityPackagesId, 'runtime.win-arm.microsoft.netcore.ildasm', 0),
(@NonCommunityPackagesId, 'runtime.win-arm.microsoft.netcore.jit', 0),
(@NonCommunityPackagesId, 'runtime.win-arm.microsoft.netcore.runtime.coreclr', 0),
(@NonCommunityPackagesId, 'runtime.win-arm.microsoft.netcore.testhost', 0),
(@NonCommunityPackagesId, 'runtime.win-arm64.microsoft.netcore.app', 0),
(@NonCommunityPackagesId, 'runtime.win-arm64.microsoft.netcore.dotnetapphost', 0),
(@NonCommunityPackagesId, 'runtime.win-arm64.microsoft.netcore.dotnethost', 0),
(@NonCommunityPackagesId, 'runtime.win-arm64.microsoft.netcore.dotnethostpolicy', 0),
(@NonCommunityPackagesId, 'runtime.win-arm64.microsoft.netcore.dotnethostresolver', 0),
(@NonCommunityPackagesId, 'runtime.win-arm64.microsoft.netcore.ilasm', 0),
(@NonCommunityPackagesId, 'runtime.win-arm64.microsoft.netcore.ildasm', 0),
(@NonCommunityPackagesId, 'runtime.win-arm64.microsoft.netcore.jit', 0),
(@NonCommunityPackagesId, 'runtime.win-arm64.microsoft.netcore.runtime.coreclr', 0),
(@NonCommunityPackagesId, 'runtime.win-arm64.microsoft.netcore.testhost', 0),
(@NonCommunityPackagesId, 'runtime.win-arm64.runtime.native.system.data.sqlclient.sni', 0),
(@NonCommunityPackagesId, 'runtime.win-x64.microsoft.netcore.app', 0),
(@NonCommunityPackagesId, 'runtime.win-x64.microsoft.netcore.dotnetapphost', 0),
(@NonCommunityPackagesId, 'runtime.win-x64.microsoft.netcore.dotnethost', 0),
(@NonCommunityPackagesId, 'runtime.win-x64.microsoft.netcore.dotnethostpolicy', 0),
(@NonCommunityPackagesId, 'runtime.win-x64.microsoft.netcore.dotnethostresolver', 0),
(@NonCommunityPackagesId, 'runtime.win-x64.microsoft.netcore.ilasm', 0),
(@NonCommunityPackagesId, 'runtime.win-x64.microsoft.netcore.ildasm', 0),
(@NonCommunityPackagesId, 'runtime.win-x64.microsoft.netcore.jit', 0),
(@NonCommunityPackagesId, 'runtime.win-x64.microsoft.netcore.runtime.coreclr', 0),
(@NonCommunityPackagesId, 'runtime.win-x64.microsoft.netcore.testhost', 0),
(@NonCommunityPackagesId, 'runtime.win-x64.runtime.native.system.data.sqlclient.sni', 0),
(@NonCommunityPackagesId, 'runtime.win-x86.microsoft.netcore.app', 0),
(@NonCommunityPackagesId, 'runtime.win-x86.microsoft.netcore.dotnetapphost', 0),
(@NonCommunityPackagesId, 'runtime.win-x86.microsoft.netcore.dotnethost', 0),
(@NonCommunityPackagesId, 'runtime.win-x86.microsoft.netcore.dotnethostpolicy', 0),
(@NonCommunityPackagesId, 'runtime.win-x86.microsoft.netcore.dotnethostresolver', 0),
(@NonCommunityPackagesId, 'runtime.win-x86.microsoft.netcore.ilasm', 0),
(@NonCommunityPackagesId, 'runtime.win-x86.microsoft.netcore.ildasm', 0),
(@NonCommunityPackagesId, 'runtime.win-x86.microsoft.netcore.jit', 0),
(@NonCommunityPackagesId, 'runtime.win-x86.microsoft.netcore.runtime.coreclr', 0),
(@NonCommunityPackagesId, 'runtime.win-x86.microsoft.netcore.testhost', 0),
(@NonCommunityPackagesId, 'runtime.win-x86.runtime.native.system.data.sqlclient.sni', 0),
(@NonCommunityPackagesId, 'rx_experimental-xaml', 0),
(@NonCommunityPackagesId, 'rx-core', 0),
(@NonCommunityPackagesId, 'rx-experimental', 0),
(@NonCommunityPackagesId, 'rx-interfaces', 0),
(@NonCommunityPackagesId, 'rxjs-aggregates', 0),
(@NonCommunityPackagesId, 'rxjs-all', 0),
(@NonCommunityPackagesId, 'rxjs-async', 0),
(@NonCommunityPackagesId, 'rxjs-binding', 0),
(@NonCommunityPackagesId, 'rxjs-bridges-html', 0),
(@NonCommunityPackagesId, 'rxjs-bridges-jquery', 0),
(@NonCommunityPackagesId, 'rxjs-bridges-winjs', 0),
(@NonCommunityPackagesId, 'rxjs-coincidence', 0),
(@NonCommunityPackagesId, 'rxjs-experimental', 0),
(@NonCommunityPackagesId, 'rxjs-joinpatterns', 0),
(@NonCommunityPackagesId, 'rxjs-lite', 0),
(@NonCommunityPackagesId, 'rxjs-main', 0),
(@NonCommunityPackagesId, 'rxjs-testing', 0),
(@NonCommunityPackagesId, 'rxjs-time', 0),
(@NonCommunityPackagesId, 'rxjs-virtualtime', 0),
(@NonCommunityPackagesId, 'rx-linq', 0),
(@NonCommunityPackagesId, 'rx-main', 0),
(@NonCommunityPackagesId, 'rx-platformservices', 0),
(@NonCommunityPackagesId, 'rx-providers', 0),
(@NonCommunityPackagesId, 'rx-remoting', 0),
(@NonCommunityPackagesId, 'rx-silverlight', 0),
(@NonCommunityPackagesId, 'rx-testing', 0),
(@NonCommunityPackagesId, 'rx-windowstoreapps', 0),
(@NonCommunityPackagesId, 'rx-winforms', 0),
(@NonCommunityPackagesId, 'rx-winrt', 0),
(@NonCommunityPackagesId, 'rx-wpf', 0),
(@NonCommunityPackagesId, 'rx-xaml', 0),
(@NonCommunityPackagesId, 'singlepageapplication', 0),
(@NonCommunityPackagesId, 'sqlservercompact', 0),
(@NonCommunityPackagesId, 'starter.site.template.vb2', 0),
(@NonCommunityPackagesId, 'stylecop.krules', 0),
(@NonCommunityPackagesId, 'system.appcontext', 0),
(@NonCommunityPackagesId, 'system.applicationcontext', 0),
(@NonCommunityPackagesId, 'system.buffers', 0),
(@NonCommunityPackagesId, 'system.codedom', 0),
(@NonCommunityPackagesId, 'system.collections', 0),
(@NonCommunityPackagesId, 'system.collections.concurrent', 0),
(@NonCommunityPackagesId, 'system.collections.immutable', 0),
(@NonCommunityPackagesId, 'system.collections.nongeneric', 0),
(@NonCommunityPackagesId, 'system.collections.sequences', 0),
(@NonCommunityPackagesId, 'system.collections.specialized', 0),
(@NonCommunityPackagesId, 'system.commandline', 0),
(@NonCommunityPackagesId, 'system.componentmodel', 0),
(@NonCommunityPackagesId, 'system.componentmodel.annotations', 0),
(@NonCommunityPackagesId, 'system.componentmodel.eventbasedasync', 0),
(@NonCommunityPackagesId, 'system.componentmodel.primitives', 0),
(@NonCommunityPackagesId, 'system.componentmodel.typeconverter', 0),
(@NonCommunityPackagesId, 'system.composition', 0),
(@NonCommunityPackagesId, 'system.composition.attributedmodel', 0),
(@NonCommunityPackagesId, 'system.composition.convention', 0),
(@NonCommunityPackagesId, 'system.composition.hosting', 0),
(@NonCommunityPackagesId, 'system.composition.runtime', 0),
(@NonCommunityPackagesId, 'system.composition.typedparts', 0),
(@NonCommunityPackagesId, 'system.configuration.configurationmanager', 0),
(@NonCommunityPackagesId, 'system.console', 0),
(@NonCommunityPackagesId, 'system.data.common', 0),
(@NonCommunityPackagesId, 'system.data.sqlclient', 0),
(@NonCommunityPackagesId, 'system.data.sqlclient.sni-arm', 0),
(@NonCommunityPackagesId, 'system.data.sqlclient.sni-x64', 0),
(@NonCommunityPackagesId, 'system.data.sqlclient.sni-x86', 0),
(@NonCommunityPackagesId, 'system.diagnostics.contracts', 0),
(@NonCommunityPackagesId, 'system.diagnostics.debug', 0),
(@NonCommunityPackagesId, 'system.diagnostics.diagnosticsource', 0),
(@NonCommunityPackagesId, 'system.diagnostics.fileversioninfo', 0),
(@NonCommunityPackagesId, 'system.diagnostics.process', 0),
(@NonCommunityPackagesId, 'system.diagnostics.stacktrace', 0),
(@NonCommunityPackagesId, 'system.diagnostics.textwritertracelistener', 0),
(@NonCommunityPackagesId, 'system.diagnostics.tools', 0),
(@NonCommunityPackagesId, 'system.diagnostics.tracesource', 0),
(@NonCommunityPackagesId, 'system.diagnostics.tracing', 0),
(@NonCommunityPackagesId, 'system.diagnostics.tracing.telemetry', 0),
(@NonCommunityPackagesId, 'system.drawing.common', 0),
(@NonCommunityPackagesId, 'system.drawing.primitives', 0),
(@NonCommunityPackagesId, 'system.dynamic.runtime', 0),
(@NonCommunityPackagesId, 'system.globalization', 0),
(@NonCommunityPackagesId, 'system.globalization.calendars', 0),
(@NonCommunityPackagesId, 'system.globalization.extensions', 0),
(@NonCommunityPackagesId, 'system.identitymodel.clients.activedirectory', 0),
(@NonCommunityPackagesId, 'system.identitymodel.tokens.jwt', 0),
(@NonCommunityPackagesId, 'system.identitymodel.tokens.validatingissuernameregistry', 0),
(@NonCommunityPackagesId, 'system.io', 0),
(@NonCommunityPackagesId, 'system.io.compression', 0),
(@NonCommunityPackagesId, 'system.io.compression.clrcompression-arm', 0),
(@NonCommunityPackagesId, 'system.io.compression.clrcompression-x64', 0),
(@NonCommunityPackagesId, 'system.io.compression.clrcompression-x86', 0),
(@NonCommunityPackagesId, 'system.io.compression.zipfile', 0),
(@NonCommunityPackagesId, 'system.io.filesystem', 0),
(@NonCommunityPackagesId, 'system.io.filesystem.accesscontrol', 0),
(@NonCommunityPackagesId, 'system.io.filesystem.driveinfo', 0),
(@NonCommunityPackagesId, 'system.io.filesystem.primitives', 0),
(@NonCommunityPackagesId, 'system.io.filesystem.watcher', 0),
(@NonCommunityPackagesId, 'system.io.isolatedstorage', 0),
(@NonCommunityPackagesId, 'system.io.memorymappedfiles', 0),
(@NonCommunityPackagesId, 'system.io.packaging', 0),
(@NonCommunityPackagesId, 'system.io.pipelines', 0),
(@NonCommunityPackagesId, 'system.io.pipelines.extensions', 0),
(@NonCommunityPackagesId, 'system.io.pipes', 0),
(@NonCommunityPackagesId, 'system.io.pipes.accesscontrol', 0),
(@NonCommunityPackagesId, 'system.io.ports', 0),
(@NonCommunityPackagesId, 'system.io.unmanagedmemorystream', 0),
(@NonCommunityPackagesId, 'system.json', 0),
(@NonCommunityPackagesId, 'system.linq', 0),
(@NonCommunityPackagesId, 'system.linq.expressions', 0),
(@NonCommunityPackagesId, 'system.linq.parallel', 0),
(@NonCommunityPackagesId, 'system.linq.queryable', 0),
(@NonCommunityPackagesId, 'system.memory', 0),
(@NonCommunityPackagesId, 'system.net.http', 0),
(@NonCommunityPackagesId, 'system.net.http.formatting', 0),
(@NonCommunityPackagesId, 'system.net.http.rtc', 0),
(@NonCommunityPackagesId, 'system.net.http.winhttphandler', 0),
(@NonCommunityPackagesId, 'system.net.nameresolution', 0),
(@NonCommunityPackagesId, 'system.net.networkinformation', 0),
(@NonCommunityPackagesId, 'system.net.ping', 0),
(@NonCommunityPackagesId, 'system.net.primitives', 0),
(@NonCommunityPackagesId, 'system.net.requests', 0),
(@NonCommunityPackagesId, 'system.net.security', 0),
(@NonCommunityPackagesId, 'system.net.sockets', 0),
(@NonCommunityPackagesId, 'system.net.utilities', 0),
(@NonCommunityPackagesId, 'system.net.webheadercollection', 0),
(@NonCommunityPackagesId, 'system.net.websockets', 0),
(@NonCommunityPackagesId, 'system.net.websockets.client', 0),
(@NonCommunityPackagesId, 'system.numerics.vectors', 0),
(@NonCommunityPackagesId, 'system.numerics.vectors.windowsruntime', 0),
(@NonCommunityPackagesId, 'system.objectmodel', 0),
(@NonCommunityPackagesId, 'system.private.datacontractserialization', 0),
(@NonCommunityPackagesId, 'system.private.networking', 0),
(@NonCommunityPackagesId, 'system.private.servicemodel', 0),
(@NonCommunityPackagesId, 'system.private.uri', 0),
(@NonCommunityPackagesId, 'system.reflection', 0),
(@NonCommunityPackagesId, 'system.reflection.context', 0),
(@NonCommunityPackagesId, 'system.reflection.dispatchproxy', 0),
(@NonCommunityPackagesId, 'system.reflection.emit', 0),
(@NonCommunityPackagesId, 'system.reflection.emit.ilgeneration', 0),
(@NonCommunityPackagesId, 'system.reflection.emit.lightweight', 0),
(@NonCommunityPackagesId, 'system.reflection.extensions', 0),
(@NonCommunityPackagesId, 'system.reflection.metadata', 0),
(@NonCommunityPackagesId, 'system.reflection.primitives', 0),
(@NonCommunityPackagesId, 'system.reflection.typeextensions', 0),
(@NonCommunityPackagesId, 'system.resources.reader', 0),
(@NonCommunityPackagesId, 'system.resources.readerwriter', 0),
(@NonCommunityPackagesId, 'system.resources.resourcemanager', 0),
(@NonCommunityPackagesId, 'system.resources.resourcewriter', 0),
(@NonCommunityPackagesId, 'system.resources.writer', 0),
(@NonCommunityPackagesId, 'system.runtime', 0),
(@NonCommunityPackagesId, 'system.runtime.compilerservices.unsafe', 0),
(@NonCommunityPackagesId, 'system.runtime.compilerservices.visualc', 0),
(@NonCommunityPackagesId, 'system.runtime.extensions', 0),
(@NonCommunityPackagesId, 'system.runtime.handles', 0),
(@NonCommunityPackagesId, 'system.runtime.interopservices', 0),
(@NonCommunityPackagesId, 'system.runtime.interopservices.pinvoke', 0),
(@NonCommunityPackagesId, 'system.runtime.interopservices.runtimeinformation', 0),
(@NonCommunityPackagesId, 'system.runtime.interopservices.windowsruntime', 0),
(@NonCommunityPackagesId, 'system.runtime.loader', 0),
(@NonCommunityPackagesId, 'system.runtime.numerics', 0),
(@NonCommunityPackagesId, 'system.runtime.serialization.formatters', 0),
(@NonCommunityPackagesId, 'system.runtime.serialization.json', 0),
(@NonCommunityPackagesId, 'system.runtime.serialization.primitives', 0),
(@NonCommunityPackagesId, 'system.runtime.serialization.xml', 0),
(@NonCommunityPackagesId, 'system.runtime.windowsruntime', 0),
(@NonCommunityPackagesId, 'system.runtime.windowsruntime.ui.xaml', 0),
(@NonCommunityPackagesId, 'system.security.accesscontrol', 0),
(@NonCommunityPackagesId, 'system.security.claims', 0),
(@NonCommunityPackagesId, 'system.security.cryptography', 0),
(@NonCommunityPackagesId, 'system.security.cryptography.algorithms', 0),
(@NonCommunityPackagesId, 'system.security.cryptography.cng', 0),
(@NonCommunityPackagesId, 'system.security.cryptography.csp', 0),
(@NonCommunityPackagesId, 'system.security.cryptography.derivebytes', 0),
(@NonCommunityPackagesId, 'system.security.cryptography.encoding', 0),
(@NonCommunityPackagesId, 'system.security.cryptography.encryption', 0),
(@NonCommunityPackagesId, 'system.security.cryptography.encryption.aes', 0),
(@NonCommunityPackagesId, 'system.security.cryptography.encryption.rsa', 0),
(@NonCommunityPackagesId, 'system.security.cryptography.hashalgorithms.md5', 0),
(@NonCommunityPackagesId, 'system.security.cryptography.hashalgorithms.sha1', 0),
(@NonCommunityPackagesId, 'system.security.cryptography.hashalgorithms.sha2', 0),
(@NonCommunityPackagesId, 'system.security.cryptography.hashing', 0),
(@NonCommunityPackagesId, 'system.security.cryptography.hashing.algorithms', 0),
(@NonCommunityPackagesId, 'system.security.cryptography.openssl', 0),
(@NonCommunityPackagesId, 'system.security.cryptography.pkcs', 0),
(@NonCommunityPackagesId, 'system.security.cryptography.primitives', 0),
(@NonCommunityPackagesId, 'system.security.cryptography.protecteddata', 0),
(@NonCommunityPackagesId, 'system.security.cryptography.randomnumbergenerator', 0),
(@NonCommunityPackagesId, 'system.security.cryptography.rsa', 0),
(@NonCommunityPackagesId, 'system.security.cryptography.x509certificates', 0),
(@NonCommunityPackagesId, 'system.security.cryptography.xml', 0),
(@NonCommunityPackagesId, 'system.security.permissions', 0),
(@NonCommunityPackagesId, 'system.security.principal', 0),
(@NonCommunityPackagesId, 'system.security.principal.windows', 0),
(@NonCommunityPackagesId, 'system.security.securestring', 0),
(@NonCommunityPackagesId, 'system.servicemodel.duplex', 0),
(@NonCommunityPackagesId, 'system.servicemodel.http', 0),
(@NonCommunityPackagesId, 'system.servicemodel.nettcp', 0),
(@NonCommunityPackagesId, 'system.servicemodel.primitives', 0),
(@NonCommunityPackagesId, 'system.servicemodel.security', 0),
(@NonCommunityPackagesId, 'system.serviceprocess.servicecontroller', 0),
(@NonCommunityPackagesId, 'system.spatial', 0),
(@NonCommunityPackagesId, 'system.text.encoding', 0),
(@NonCommunityPackagesId, 'system.text.encoding.codepages', 0),
(@NonCommunityPackagesId, 'system.text.encoding.extensions', 0),
(@NonCommunityPackagesId, 'system.text.encodings.web', 0),
(@NonCommunityPackagesId, 'system.text.regularexpressions', 0),
(@NonCommunityPackagesId, 'system.threading', 0),
(@NonCommunityPackagesId, 'system.threading.accesscontrol', 0),
(@NonCommunityPackagesId, 'system.threading.executioncontext', 0),
(@NonCommunityPackagesId, 'system.threading.overlapped', 0),
(@NonCommunityPackagesId, 'system.threading.tasks', 0),
(@NonCommunityPackagesId, 'system.threading.tasks.channels', 0),
(@NonCommunityPackagesId, 'system.threading.tasks.dataflow', 0),
(@NonCommunityPackagesId, 'system.threading.tasks.extensions', 0),
(@NonCommunityPackagesId, 'system.threading.tasks.parallel', 0),
(@NonCommunityPackagesId, 'system.threading.thread', 0),
(@NonCommunityPackagesId, 'system.threading.threadpool', 0),
(@NonCommunityPackagesId, 'system.threading.timer', 0),
(@NonCommunityPackagesId, 'system.valuetuple', 0),
(@NonCommunityPackagesId, 'system.web.http.common', 0),
(@NonCommunityPackagesId, 'system.web.providers', 0),
(@NonCommunityPackagesId, 'system.web.providers.core', 0),
(@NonCommunityPackagesId, 'system.web.providers.localdb', 0),
(@NonCommunityPackagesId, 'system.web.providers.sqlce', 0),
(@NonCommunityPackagesId, 'system.xml.readerwriter', 0),
(@NonCommunityPackagesId, 'system.xml.xdocument', 0),
(@NonCommunityPackagesId, 'system.xml.xmldocument', 0),
(@NonCommunityPackagesId, 'system.xml.xmlserializer', 0),
(@NonCommunityPackagesId, 'system.xml.xpath', 0),
(@NonCommunityPackagesId, 'system.xml.xpath.xdocument', 0),
(@NonCommunityPackagesId, 'system.xml.xpath.xmldocument', 0),
(@NonCommunityPackagesId, 'transientfaulthandling.core', 0),
(@NonCommunityPackagesId, 'translatorwidget', 0),
(@NonCommunityPackagesId, 'twitter.helper', 0),
(@NonCommunityPackagesId, 'upshot', 0),
(@NonCommunityPackagesId, 'vsixbootstrapper', 0),
(@NonCommunityPackagesId, 'vswhere', 0),
(@NonCommunityPackagesId, 'webapi.all', 0),
(@NonCommunityPackagesId, 'webapi.core', 0),
(@NonCommunityPackagesId, 'webapi.enhancements', 0),
(@NonCommunityPackagesId, 'webgrease', 0),
(@NonCommunityPackagesId, 'webmatrix.data', 0),
(@NonCommunityPackagesId, 'webmatrix.security', 0),
(@NonCommunityPackagesId, 'webmatrix.webdata', 0),
(@NonCommunityPackagesId, 'win2d', 0),
(@NonCommunityPackagesId, 'windowsazure.caching', 0),
(@NonCommunityPackagesId, 'windowsazure.mediaservices', 0),
(@NonCommunityPackagesId, 'windowsazure.mobileservices', 0),
(@NonCommunityPackagesId, 'windowsazure.mobileservices.winjs', 0),
(@NonCommunityPackagesId, 'windowsazure.servicebus', 0),
(@NonCommunityPackagesId, 'windowsazure.storage', 0)
;
INSERT INTO [dbo].[Fact_Package_PackageSet] (Dimension_PackageSet_id, LowercasedPackageId, IsPrimary) VALUES
(@NonCommunityPackagesId, 'wishlist.template', 0),
(@NonCommunityPackagesId, 'xunit.krunner', 0)
;
COMMIT TRANSACTION;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment