github.com/nais/knorten@v0.0.0-20240104110906-55926958e361/pkg/database/migrations/011_team_owner.sql (about) 1 -- +goose Up 2 ALTER TABLE teams ADD COLUMN "owner" TEXT; 3 UPDATE teams t SET owner = (SELECT users[1] FROM teams where id = t.id), users = (SELECT users[2:] FROM teams WHERE id = t.id); 4 ALTER TABLE teams ALTER COLUMN "owner" SET NOT NULL; 5 6 -- +goose Down 7 UPDATE teams t SET users = array_prepend(t.owner, t.users); 8 ALTER TABLE teams DROP COLUMN "owner";