All Downloads are FREE. Search and download functionalities are using the official Maven repository.

liquibase.changelogs.v1_20_16.schema.yml Maven / Gradle / Ivy

There is a newer version: 3.9.2
Show newest version
databaseChangeLog:
  - changeSet:
      id: 1.20.16
      author: GraviteeSource Team
      changes:
        - createTable:
            tableName: commands
            columns:
              - column: {name: id, type: nvarchar(64), constraints: { nullable: false } }
              - column: {name: from, type: nvarchar(64), constraints: { nullable: false } }
              - column: {name: to, type: nvarchar(64), constraints: { nullable: false } }
              - column: {name: content, type: nclob, constraints: { nullable: true } }
              - column: {name: expired_at, type: timestamp(6), constraints: { nullable: true } }
              - column: {name: created_at, type: timestamp(6), constraints: { nullable: true } }
              - column: {name: updated_at, type: timestamp(6), constraints: { nullable: true } }

        - addPrimaryKey:
            constraintName: pk_commands
            columnNames: id
            tableName: commands

        - createTable:
            tableName: command_acknowledgments
            columns:
              - column: {name: command_id, type: nvarchar(64), constraints: { nullable: false } }
              - column: {name: acknowledgment, type: nvarchar(64), constraints: { nullable: false } }

        - addPrimaryKey:
            constraintName: pk_command_acknowledgments
            columnNames: command_id, acknowledgment
            tableName: command_acknowledgments

        - createTable:
            tableName: command_tags
            columns:
              - column: {name: command_id, type: nvarchar(64), constraints: { nullable: false } }
              - column: {name: tag, type: nvarchar(64), constraints: { nullable: false } }

        - addPrimaryKey:
            constraintName: pk_command_tags
            columnNames: command_id, tag
            tableName: command_tags




© 2015 - 2025 Weber Informatics LLC | Privacy Policy