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

databaseChangeLog:
- removeChangeSetProperty:
    change: addColumn
    dbms: postgresql
    remove: afterColumn
- changeSet:
    validCheckSum: 8:26bce67df849ed409cdd5dffc335a95b
    id: partition-updated-executions
    author: rzienert
    changes:
    - addColumn:
        tableName: orchestrations
        columns:
        - column:
            name: partition
            type: varchar(32)
            afterColumn: legacy_id
        - column:
            name: updated_at
            type: bigint
            afterColumn: build_time
    - addColumn:
        tableName: pipelines
        columns:
        - column:
            name: partition
            type: varchar(32)
            afterColumn: legacy_id
        - column:
            name: updated_at
            type: bigint
            afterColumn: build_time
    - addColumn:
        tableName: orchestration_stages
        columns:
        - column:
            name: updated_at
            type: bigint
            afterColumn: status
    - addColumn:
        tableName: pipeline_stages
        columns:
        - column:
            name: updated_at
            type: bigint
            afterColumn: status
    rollback:
    - dropColumn:
        tableName: orchestrations
        columnName: partition
    - dropColumn:
        tableName: orchestrations
        columnName: updated_at
    - dropColumn:
        tableName: pipelines
        columnName: partition
    - dropColumn:
        tableName: pipelines
        columnName: updated_at
    - dropColumn:
        tableName: orchestration_stages
        columnName: updated_at
    - dropColumn:
        tableName: pipeline_stages
        columnName: updated_at

- changeSet:
    id: add-partition-indexes
    author: rzienert
    changes:
    - createIndex:
        indexName: pipelines_partition_updated_idx
        tableName: pipelines
        columns:
        - column:
            name: updated_at
        - column:
            name: partition
    - createIndex:
        indexName: orchestrations_partition_updated_idx
        tableName: orchestrations
        column:
        - column:
            name: updated_at
        - column:
            name: partition
    rollback:
    - dropIndex:
        indexName: pipelines_partition_updated_idx
        tableName: pipelines
    - dropIndex:
        indexName: orchestrations_partition_updated_idx
        tableName: orchestrations