• Home
• io.spinnaker.orca
• orca-sql
• 8.55.0
• source code
• 20180724-indices.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.20180724-indices.yml Maven / Gradle / Ivy

databaseChangeLog:
- changeSet:
    id: 20180724-add-and-remove-indices
    author: afeldman
    changes:
    - createIndex:
        indexName: pipeline_config_idx
        tableName: pipelines
        columns:
        - column:
            name: config_id
    - createIndex:
        indexName: pipeline_application_idx
        tableName: pipelines
        columns:
        - column:
            name: application
    - createIndex:
        indexName: orchestration_application_idx
        tableName: orchestrations
        columns:
        - column:
            name: application
    - dropIndex:
        indexName: pipeline_canceled_idx
        tableName: pipelines
    - dropIndex:
        indexName: pipeline_application_status_buildtime_idx
        tableName: pipelines
    - dropIndex:
        indexName: pipelines_legacy_id_idx
        tableName: pipelines
    - dropIndex:
        indexName: pipeline_stages_legacy_id_idx
        tableName: pipeline_stages
    - dropIndex:
        indexName: orchestrations_legacy_id_idx
        tableName: orchestrations
    - dropIndex:
        indexName: orchestration_application_status_buildtime_idx
        tableName: orchestrations
    - dropIndex:
        indexName: orchestration_canceled_idx
        tableName: orchestrations
    - dropIndex:
        indexName: orchestration_stages_legacy_id_idx
        tableName: orchestration_stages
    rollback:
    - createIndex:
        indexName: pipeline_canceled_idx
        tableName: pipelines
        columns:
        - column:
            name: canceled
    - createIndex:
        indexName: pipelines_legacy_id_idx
        tableName: pipelines
        columns:
        - column:
            name: legacy_id
    - createIndex:
        indexName: orchestration_canceled_idx
        tableName: orchestrations
        columns:
        - column:
            name: canceled
    - createIndex:
        indexName: orchestrations_legacy_id_idx
        tableName: orchestrations
        columns:
        - column:
            name: legacy_id
    - createIndex:
        indexName: pipeline_application_status_buildtime_idx
        tableName: pipelines
        columns:
        - column:
            name: application
        - column:
            name: status
        - column:
            name: build_time
    - createIndex:
        indexName: orchestration_application_status_buildtime_idx
        tableName: orchestrations
        columns:
        - column:
            name: application
        - column:
            name: status
        - column:
            name: build_time
    - createIndex:
        indexName: pipeline_stages_legacy_id_idx
        tableName: pipeline_stages
        columns:
        - column:
            name: legacy_id
    - createIndex:
        indexName: orchestration_stages_legacy_id_idx
        tableName: orchestration_stages
        columns:
        - column:
            name: legacy_id
    - dropIndex:
        indexName: pipeline_config_idx
        tableName: pipelines
    - dropIndex:
        indexName: pipeline_application_idx
        tableName: pipelines
    - dropIndex:
        indexName: orchestration_application_idx
        tableName: orchestrations