liquibase 新增表PK

liquibase add表PK

1.1liquibase add表PK

databaseChangeLog:
  - changeSet:
       id:  xxx_0.0.1_add_pk
       author:  username
       comment: xxx table add primary key
       dbms: oracle
       changes:
         -  addPrimaryKey:
              columnNames:  columnA, columnB
              constraintName:  PK_columnA_columnB
              tableName:  TABLE_NAME
              validate:  true

1.2 SQL 描述

ALTER TABLE TABLE_NAME ADD CONSTRAINT  PK_columnA_columnB PRIMARY  KEY  (columnA, columnB);

2.1liquibase addPrimaryKey使用方法

databaseChangeLog:
-  changeSet:
    id:  addPrimaryKey-example
    author:  liquibase-docs
    changes:
    -  addPrimaryKey:
        catalogName:  cat
        clustered:  true
        columnNames:  id, name
        constraintName:  pk_person
        forIndexName:  A String
        schemaName:  public
        tableName:  person
        tablespace:  A String
        validate:  true

2.2 对应SQL

ALTER  TABLE  cat.person  ADD  PRIMARY  KEY  (id, name);

liquibase栏位解释：