• Home
• io.spinnaker.keel
• keel-sql
• 0.199.0
• source code
• 20201221-shorten-environment-last-verified-pk.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.20201221-shorten-environment-last-verified-pk.yml Maven / Gradle / Ivy

databaseChangeLog:
- changeSet:
    id: shorten-environment-last-verified-pk
    author: fletch
    changes:
    - dropAllForeignKeyConstraints:
        baseTableName: environment_last_verified
    - delete:
        tableName: environment_last_verified
    - dropPrimaryKey:
        tableName: environment_last_verified
    - addForeignKeyConstraint:
        baseTableName: environment_last_verified
        baseColumnNames: environment_uid
        constraintName: fk_environment_last_verified_environment
        referencedTableName: environment
        referencedColumnNames: uid
        referencesUniqueColumn: true
        onDelete: CASCADE
    - addForeignKeyConstraint:
        baseTableName: environment_last_verified
        baseColumnNames: artifact_uid
        constraintName: fk_environment_last_verified_delivery_artifact
        referencedTableName: delivery_artifact
        referencedColumnNames: uid
        referencesUniqueColumn: true
        onDelete: CASCADE
    - addPrimaryKey:
        tableName: environment_last_verified
        columnNames: environment_uid, artifact_uid