databaseChangeLog:
  - logicalFilePath: db-changelog-000237-add-index-for-deployment-foreign-keys.yaml
  - changeSet:
      author: appian
      id: tag-pre-000237
      tagDatabase:
        tag: 'pre-000237'

  - changeSet:
      author: appian
      id: '000237.0.0'
      comment: Add index on deployment_app.deployment_id for foreign key
      preConditions: # DO NOT COPY THIS PRECONDITION PATTERN. It's not necessary any more, and we can/should treat all DBs the same when creating indexes
        onFail: MARK_RAN
        not:
          or:
            - dbms:
              type: mysql
            - dbms:
              type: mariadb
        createIndex:
          tableName: deployment_app
          columns:
            - column:
                name: deployment_id
          indexName: dpl_app_dpl_id_fk_ix

  - changeSet:
      author: appian
      id: '000237.1.0'
      comment: Add index on deployment_db_script.deployment_id for foreign key
      preConditions: # DO NOT COPY THIS PRECONDITION PATTERN. It's not necessary any more, and we can/should treat all DBs the same when creating indexes
        onFail: MARK_RAN
        not:
          or:
            - dbms:
              type: mysql
            - dbms:
              type: mariadb
        createIndex:
          tableName: deployment_db_script
          columns:
            - column:
                name: deployment_id
          indexName: dpl_db_script_dpl_id_fk_ix