databaseChangeLog:
  - changeSet:
      id: added-remove-from-all-dossier-to-manual-remove-redaction
      author: dom
      changes:
        - addColumn:
            columns:
              - column:
                  name: remove_from_all_dossiers
                  type: BOOLEAN
            tableName: id_removal
  - changeSet:
      id: added-remove-from-all-dossier-to-manual-remove-redaction-2
      author: dom
      changes:
        - createTable:
            columns:
              - column:
                  constraints:
                    nullable: false
                  name: id_removal_entity_annotation_id
                  type: VARCHAR(255)
              - column:
                  constraints:
                    nullable: false
                  name: id_removal_entity_file_id
                  type: VARCHAR(255)
              - column:
                  name: type_ids_of_modified_dictionaries
                  type: VARCHAR(255)
            tableName: id_removal_entity_type_ids_of_modified_dictionaries
  - changeSet:
      id: added-remove-from-all-dossier-to-manual-remove-redaction-3
      author: dom
      changes:
        - addForeignKeyConstraint:
            baseColumnNames: id_removal_entity_annotation_id, id_removal_entity_file_id
            baseTableName: id_removal_entity_type_ids_of_modified_dictionaries
            constraintName: fk64e6qfq7tqad3lknqmqpzzz
            deferrable: false
            initiallyDeferred: false
            onDelete: NO ACTION
            onUpdate: NO ACTION
            referencedColumnNames: annotation_id, file_id
            referencedTableName: id_removal
            validate: true