AxonIQ Liquibase Scripts

axoniq-liquibase.yaml

databaseChangeLog:
  - changeSet:
      id: 1
      author: Manuel Doncel Martos
      comment: Create axoniq needed tables
      changes:
        - createTable:
            tableName: association_value_entry
            columns:
              - column:
                  name: id
                  type: bigint
                  constraints:
                    primaryKey: true
                    nullable: false
              - column:
                  name: association_key
                  type: varchar(255)
              - column:
                  name: association_value
                  type: varchar(255)
              - column:
                  name: saga_id
                  type: varchar(255)
              - column:
                  name: saga_type
                  type: varchar(255)
        - createIndex:
            indexName: idx_association_value_entry
            tableName: association_value_entry
            columns:
              - column:
                  name: saga_type
                  descending: false
              - column:
                  name: association_key
                  descending: false
              - column:
                  name: association_value
                  descending: false
        - createIndex:
            indexName: idx2_association_value_entry
            tableName: association_value_entry
            columns:
              - column:
                  name: saga_id
                  descending: false
              - column:
                  name: saga_type
                  descending: false
        - createTable:
            tableName: dead_letter_entry
            columns:
              - column:
                  name: dead_letter_id
                  type: varchar(255)
                  constraints:
                    primaryKey: true
                    nullable: false
              - column:
                  name: cause_message
                  type: varchar(1023)
              - column:
                  name: cause_type
                  type: varchar(255)
              - column:
                  name: diagnostics
                  type: binary
              - column:
                  name: enqueued_at
                  type: timestamptz
                  constraints:
                    nullable: false
              - column:
                  name: last_touched
                  type: timestamptz
              - column:
                  name: aggregate_identifier
                  type: varchar(255)
              - column:
                  name: event_identifier
                  type: varchar(255)
                  constraints:
                    nullable: false
              - column:
                  name: message_type
                  type: varchar(255)
                  constraints:
                    nullable: false
              - column:
                  name: meta_data
                  type: binary
              - column:
                  name: payload
                  type: binary
                  constraints:
                    nullable: false
              - column:
                  name: payload_revision
                  type: varchar(255)
              - column:
                  name: payload_type
                  type: varchar(255)
                  constraints:
                    nullable: false
              - column:
                  name: sequence_number
                  type: bigint
              - column:
                  name: time_stamp
                  type: varchar(255)
                  constraints:
                    nullable: false
              - column:
                  name: token
                  type: binary
              - column:
                  name: token_type
                  type: varchar(255)
              - column:
                  name: type
                  type: varchar(255)
              - column:
                  name: processing_group
                  type: varchar(255)
                  constraints:
                    nullable: false
              - column:
                  name: processing_started
                  type: timestamptz
              - column:
                  name: sequence_identifier
                  type: varchar(255)
                  constraints:
                    nullable: false
              - column:
                  name: sequence_index
                  type: bigint
                  constraints:
                    nullable: false
        - addUniqueConstraint:
            constraintName: uk_dead_letter_entry
            tableName: dead_letter_entry
            columnNames: processing_group, sequence_identifier, sequence_index
        - createIndex:
            indexName: idx_dead_letter_entry
            tableName: dead_letter_entry
            columns:
              - column:
                  name: processing_group
                  descending: false
        - createIndex:
            indexName: idx2_dead_letter_entry
            tableName: dead_letter_entry
            columns:
              - column:
                  name: processing_group
                  descending:  false
              - column:
                  name: sequence_identifier
                  descending:  false
        # create indexes
        - createTable:
            tableName: saga_entry
            columns:
              - column:
                  name: saga_id
                  type: varchar(255)
                  constraints:
                    primaryKey: true
                    nullable: false
              - column:
                  name: revision
                  type: varchar(255)
              - column:
                  name: saga_type
                  type: varchar(255)
              - column:
                  name: serialized_saga
                  type: binary
        - createTable:
            tableName: token_entry
            columns:
              - column:
                  name: processor_name
                  type: varchar(255)
                  constraints:
                    nullable: false
              - column:
                  name: segment
                  type: integer
                  constraints:
                    nullable: false
              - column:
                  name: owner
                  type: varchar(255)
              - column:
                  name: timestamp
                  type: varchar(255)
                  constraints:
                    nullable: false
              - column:
                  name: token
                  type: blob
              - column:
                  name: token_type
                  type: varchar(255)
        - addUniqueConstraint:
            constraintName: uk_token_entry
            tableName:  token_entry
            columnNames: processor_name, segment