g1t/services/packages/migrations/0005_version_downloads.sql
Pick any line to see why it is the way it is: the commit, the pull request and issue it came from, and what the agent was thinking.
| NuGet: symbol packages (.snupkg) pushed to SymbolPackagePublish, a symbol server serving their portable PDBs by key, Symbols on the package page; each .nupkg download counts for its version | 1 | -- Each version's own downloads, beside its package's: NuGet's registration |
| 2 | -- and search name them. Counted the way the package's are, approximately. | |
| 3 | ALTER TABLE versions ADD COLUMN downloads INTEGER NOT NULL DEFAULT 0; | |
| 4 | ||
| 5 | -- The NuGet symbol server finds a PDB by the name a version keeps it under | |
| 6 | -- (`pdb:<file>:<key>`), across a workspace's packages. | |
| 7 | CREATE INDEX version_files_name ON version_files (name); |