• Home
• io.spinnaker.front50
• front50-sql
• 2.23.9
• source code
• 20200428-initial-plugin-versions-schema.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.20200428-initial-plugin-versions-schema.yml Maven / Gradle / Ivy

databaseChangeLog:
  - changeSet:
      id: create-plugin-versions-table
      author: robzienert
      changes:
        - createTable:
            tableName: plugin_versions
            columns:
              - column:
                  name: id
                  type: char(255)
                  constraints:
                    primaryKey: true
                    nullable: false
              - column:
                  name: body
                  type: longtext
                  constraints:
                    nullable: false
              - column:
                  name: created_at
                  type: bigint
                  constraints:
                    nullable: false
              - column:
                  name: last_modified_at
                  type: bigint
                  constraints:
                    nullable: false
              - column:
                  name: last_modified_by
                  type: varchar(255)
                  constraints:
                    nullable: false
              - column:
                  name: is_deleted
                  type: boolean
                  defaultValueBoolean: false
                  constraints:
                    nullable: false
        - modifySql:
            dbms: mysql
            append:
              value: " engine innodb DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_unicode_ci"
      rollback:
        - dropTable:
            tableName: plugin_versions
  - changeSet:
      id: plugin-versions-is-deleted-index
      author: rzienert
      changes:
        - createIndex:
            indexName: is_deleted_plugin_versions_idx
            tableName: plugin_versions
            columns:
              - column:
                  name: is_deleted
  - changeSet:
      preConditions:
        onFail: CONTINUE
        dbms:
          type: postgresql
      id: modify-plugin-versions-id-to-varchar
      author: rzienert
      changes:
        - modifyDataType:
            columnName: id
            newDataType: varchar(255)
            tableName: plugin_versions