03_add_type_to_versioned_resources.go

package migrations

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

func AddTypeToVersionedResources(tx migration.LimitedTx) error {
	_, err := tx.Exec(`
		ALTER TABLE versioned_resources
		ADD COLUMN type text,
		DROP CONSTRAINT versioned_resources_resource_name_version_key,
		ADD UNIQUE (resource_name, type, version);
	`)
	if err != nil {
		return err
	}

	return nil
}