119_add_non_empty_constraint_to_team_name.go

package migrations

import "github.com/concourse/atc/dbng/migration"

func AddNonEmptyConstraintToTeamName(tx migration.LimitedTx) error {
	_, err := tx.Exec(`
ALTER TABLE teams
ADD CONSTRAINT constraint_teams_name_not_empty CHECK(length(name)>0)
    `)

	if err != nil {
		return err
	}

	return err
}