g1t/services/packages/migrations/0002_workspace_deleted.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.
| Packages, with a container registry on g1t.sh; workspaces deleted whole and kept 30 days; Members for every member | 1 | -- Set when the package's workspace is deleted (workspace.deleting) and |
| 2 | -- cleared when it is restored: hidden from the registries, the site and | |
| 3 | -- billing meanwhile. The purge (workspace.deleted) removes the rows. | |
| 4 | ALTER TABLE packages ADD COLUMN workspace_deleted_at TEXT; | |
| 5 | CREATE INDEX packages_workspace_deleted ON packages (workspace) WHERE workspace_deleted_at IS NOT NULL; |