LiqiuBase更新数据库字段类型，兼容各种数据库

振钧

于 2024-03-28 15:07:59 发布

阅读量498

点赞数 3

分类专栏： MySQL 文章标签：数据库 LiqiuBase

本文链接：https://blog.csdn.net/qq_42567801/article/details/137112758

版权

MySQL 专栏收录该内容

8 篇文章 1 订阅

订阅专栏

databaseChangeLog:
  - changeSet:
      id: 1692862815000-2
      author: admin
      changes:
        - sqlFile:
            encoding: utf8
            path: db/changelog/data.sql
  - changeSet:
      id: 1692862815000-4
      author: admin
      dbms: postgresql
      comment: 修改role_user表id字段类型
      changes:
        - addColumn:
            tableName: role_user
            columns:
              - column:
                  name: temp_id
                  type: varchar(256)
                  remarks: 主键id
        - sql:
            sql: UPDATE role_user SET temp_id = gen_random_uuid();
        - dropColumn:
            tableName: role_user
            columns:
              - column:
                  name: id
        - addColumn:
            tableName: role_user
            columns:
              - column:
                  name: id
                  type: varchar(256)
                  remarks: 主键id
        - sql:
            sql: UPDATE role_user SET id = temp_id;
        - dropColumn:
            tableName: role_user
            columns:
              - column:
                  name: temp_id