g1t/services/projects/migrations/0007_deploys.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.
| A project is an app or a library: libraries show their package and how to ship a release, not production | 1 | -- Whether a project deploys (an app) or not (a library or a tool), so its |
| 2 | -- pages offer production or releases. `deploys` is the setting: auto, yes | |
| 3 | -- or no. On auto the kind is worked out from the columns after it, which | |
| 4 | -- the service keeps (services/projects/src/kind.ts). | |
| 5 | ALTER TABLE projects ADD COLUMN deploys TEXT NOT NULL DEFAULT 'auto'; | |
| 6 | ||
| 7 | -- What the manifests at its root say, read at `detected_commit` of the | |
| 8 | -- default branch: app, library, or null when none says. '' for the commit | |
| 9 | -- of a repository with no commits yet; null until first read. | |
| 10 | ALTER TABLE projects ADD COLUMN detected_kind TEXT; | |
| 11 | ALTER TABLE projects ADD COLUMN detected_detail TEXT; | |
| 12 | ALTER TABLE projects ADD COLUMN detected_ecosystem TEXT; | |
| 13 | ALTER TABLE projects ADD COLUMN detected_commit TEXT; | |
| 14 | ||
| 15 | -- A package its repository publishes, other than a container image, as | |
| 16 | -- `Composer package psr/log`; null for none. Kept from package events. | |
| 17 | ALTER TABLE projects ADD COLUMN linked_package TEXT; | |
| 18 | ||
| 19 | -- Whether Deployments are on for it, kept from the deployments service; | |
| 20 | -- null until it has said. | |
| 21 | ALTER TABLE projects ADD COLUMN deployments_on INTEGER; |