38_add_ordering_to_pipelines.go

package migrations

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

func AddOrderingToPipelines(tx migration.LimitedTx) error {
	_, err := tx.Exec(`
		ALTER TABLE pipelines ADD COLUMN ordering int DEFAULT(0) NOT NULL
	`)

	if err != nil {
		return err
	}

	_, err = tx.Exec(`
			UPDATE pipelines
			SET ordering = id
	`)

	return err
}