• Home
• io.spinnaker.front50
• front50-sql
• 2.23.9
• source code
• 20190530-add-is-deleted-indexes.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.20190530-add-is-deleted-indexes.yml Maven / Gradle / Ivy

databaseChangeLog:
  - changeSet:
      preConditions:
        onFail: CONTINUE
        dbms:
          type: mysql
      id: create-indexes
      author: ajordens
      changes:
      - createIndex:
          indexName: is_deleted_idx
          tableName: applications
          columns:
          - column:
              name: is_deleted
      - createIndex:
          indexName: is_deleted_idx
          tableName: application_permissions
          columns:
            - column:
                name: is_deleted
      - createIndex:
          indexName: is_deleted_idx
          tableName: deliveries
          columns:
            - column:
                name: is_deleted
      - createIndex:
          indexName: is_deleted_idx
          tableName: entity_tags
          columns:
            - column:
                name: is_deleted
      - createIndex:
          indexName: is_deleted_idx
          tableName: notifications
          columns:
            - column:
                name: is_deleted
      - createIndex:
          indexName: is_deleted_idx
          tableName: pipeline_strategies
          columns:
            - column:
                name: is_deleted
      - createIndex:
          indexName: is_deleted_idx
          tableName: pipeline_templates
          columns:
            - column:
                name: is_deleted
      - createIndex:
          indexName: is_deleted_idx
          tableName: pipelines
          columns:
            - column:
                name: is_deleted
      - createIndex:
          indexName: is_deleted_idx
          tableName: projects
          columns:
            - column:
                name: is_deleted
      - createIndex:
          indexName: is_deleted_idx
          tableName: service_accounts
          columns:
            - column:
                name: is_deleted
      - createIndex:
          indexName: is_deleted_idx
          tableName: snapshots
          columns:
            - column:
                name: is_deleted
      rollback:
      - dropIndex:
          indexName: is_deleted_idx
          tableName: applications
      - dropIndex:
          indexName: is_deleted_idx
          tableName: application_permissions
      - dropIndex:
          indexName: is_deleted_idx
          tableName: deliveries
      - dropIndex:
          indexName: is_deleted_idx
          tableName: entity_tags
      - dropIndex:
          indexName: is_deleted_idx
          tableName: notifications
      - dropIndex:
          indexName: is_deleted_idx
          tableName: pipeline_strategies
      - dropIndex:
          indexName: is_deleted_idx
          tableName: pipeline_templates
      - dropIndex:
          indexName: is_deleted_idx
          tableName: pipelines
      - dropIndex:
          indexName: is_deleted_idx
          tableName: projects
      - dropIndex:
          indexName: is_deleted_idx
          tableName: service_accounts
      - dropIndex:
          indexName: is_deleted_idx
          tableName: snapshots