• Home
• io.spinnaker.orca
• orca-sql
• 8.55.0
• source code
• 20200603-deleted-executions-table-not-mysql.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.20200603-deleted-executions-table-not-mysql.yml Maven / Gradle / Ivy

databaseChangeLog:
  - changeSet:
      id: create-deleted-executions-table-for-not-mysql
      author: robzienert
      preConditions:
        onFail: MARK_RAN
        not:
          tableExists:
            tableName: deleted_executions
      changes:
        - createTable:
            tableName: deleted_executions
            columns:
              - column:
                  name: id
                  type: int
                  constraints:
                    primaryKey: true
                    nullable: false
              - column:
                  name: execution_id
                  type: char(26)
                  constraints:
                    nullable: false
              - column:
                  name: execution_type
                  type: varchar(15)
                  constraints:
                    nullable: false
              - column:
                  name: deleted_at
                  type: datetime
                  constraints:
                    nullable: false
        - addAutoIncrement:
            tableName: deleted_executions
            columnName: id
            columnDataType: int

      rollback:
        - dropTable:
            tableName: deleted_executions
  - changeSet:
      id: create-deleted-executions-index-for-not-mysql
      author: robzienert
      preConditions:
        onFail: MARK_RAN
        not:
          indexExists:
            indexName: deleted_at_idx
      changes:
        - createIndex:
            indexName: deleted_at_idx
            tableName: deleted_executions
            columns:
              - column:
                  name: deleted_at
      rollback:
        - dropIndex:
            indexName: deleted_at_idx
            tableName: deleted_executions