g1t/services/projects/migrations/0007_deploys.sql
| 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; |