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

databaseChangeLog:
- changeSet:
    id: fix-environment-last-verified-cascade
    author: fletch
    changes:
    - dropForeignKeyConstraint:
        baseTableName: environment_last_verified
        constraintName: fk_environment_last_verified_environment
    - addForeignKeyConstraint:
        baseTableName: environment_last_verified
        baseColumnNames: environment_uid
        constraintName: fk_environment_last_verified_environment
        referencedTableName: environment
        referencedColumnNames: uid
        referencesUniqueColumn: true
        onDelete: CASCADE
    - dropForeignKeyConstraint:
        baseTableName: environment_last_verified
        constraintName: fk_environment_last_verified_delivery_artifact
    - addForeignKeyConstraint:
        baseTableName: environment_last_verified
        baseColumnNames: artifact_uid
        constraintName: fk_environment_last_verified_delivery_artifact
        referencedTableName: delivery_artifact
        referencedColumnNames: uid
        referencesUniqueColumn: true
        onDelete: CASCADE