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