64_add_team_id_to_pipeline_name_uniqueness.go

package migrations

import "github.com/BurntSushi/migration"

func AddTeamIDToPipelineNameUniqueness(tx migration.LimitedTx) error {
	_, err := tx.Exec(`
		ALTER TABLE pipelines
		ADD CONSTRAINT pipelines_name_team_id UNIQUE (name, team_id);
	`)
	if err != nil {
		return err
	}

	_, err = tx.Exec(`
		ALTER TABLE pipelines
		DROP CONSTRAINT constraint_pipelines_name_unique;
	`)
	return err
}