g1t/services/packages/migrations/0002_workspace_deleted.sql
| 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; |