cps-ri/src/main/resources/changelog/db/changes/18-cascade-delete-fragment-children.yaml

   1 databaseChangeLog:
   2   - changeSet:
   3       author: cps
   4       id: 18
   5       changes:
   6         - dropForeignKeyConstraint:
   7             baseTableName: fragment
   8             constraintName: fragment_parent_id_fkey
   9         - addForeignKeyConstraint:
  10             baseColumnNames: parent_id
  11             baseTableName: fragment
  12             constraintName: fragment_parent_id_fkey
  13             deferrable: false
  14             initiallyDeferred: false
  15             onDelete: CASCADE
  16             onUpdate: NO ACTION
  17             referencedColumnNames: id
  18             referencedTableName: fragment
  19             validate: true
  20       rollback:
  21         - dropForeignKeyConstraint:
  22             baseTableName: fragment
  23             constraintName: fragment_parent_id_fkey
  24         - addForeignKeyConstraint:
  25             baseColumnNames: parent_id
  26             baseTableName: fragment
  27             constraintName: fragment_parent_id_fkey
  28             deferrable: false
  29             initiallyDeferred: false
  30             onDelete: NO ACTION
  31             onUpdate: NO ACTION
  32             referencedColumnNames: id
  33             referencedTableName: fragment
  34             validate: true