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;