Files
OpenShell/crates/openshell-server/migrations/postgres/004_add_object_metadata.sql
Derek Carr 5e28ea3a4b feat(server): add object meta convention to top-level objects (#919)
- adds filterable label selectors on resources

Closes #864

Signed-off-by: Derek Carr <decarr@redhat.com>
2026-04-27 07:16:07 -07:00

6 lines
217 B
SQL

-- Add labels column to support Kubernetes-style object metadata
ALTER TABLE objects ADD COLUMN labels JSONB;
-- Backfill existing rows with empty labels
UPDATE objects SET labels = '{}'::jsonb WHERE labels IS NULL;