• Home
• io.spinnaker.orca
• orca-sql
• 8.55.0
• source code
• 20180530-add-legacy-id-constraints.yml

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.changelog.20180530-add-legacy-id-constraints.yml Maven / Gradle / Ivy

databaseChangeLog:
- changeSet:
    id: add-legacy-id-constraints
    author: cthielen

    changes:
    - addUniqueConstraint:
        tableName: orchestrations
        constraintName: orchestrations_legacy_id_unique
        columnNames: legacy_id
    - addUniqueConstraint:
        tableName: orchestration_stages
        constraintName: orchestration_stages_legacy_id_unique
        columnNames: legacy_id
    - addUniqueConstraint:
        tableName: pipelines
        constraintName: pipelines_legacy_id_unique
        columnNames: legacy_id
    - addUniqueConstraint:
        tableName: pipeline_stages
        constraintName: pipeline_stages_legacy_id_unique
        columnNames: legacy_id

    rollback:
    - dropUniqueConstraint:
        tableName: orchestrations
        constraintName: orchestrations_legacy_id_unique
    - dropUniqueConstraint:
        tableName: orchestration_stages
        constraintName: orchestration_stages_legacy_id_unique
    - dropUniqueConstraint:
        tableName: pipelines
        constraintName: pipelines_legacy_id_unique
    - dropUniqueConstraint:
        tableName: pipeline_stages
        constraintName: pipeline_stages_legacy_id_unique