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

振钧

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

阅读量692

点赞数 3

CC 4.0 BY-SA版权

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

本文链接：https://blog.youkuaiyun.com/qq_42567801/article/details/137112758

MySQL 专栏收录该内容

8 篇文章

订阅专栏

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