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";