1.首先编辑changelog目录下的.xml文件
<?xml version="1.0" encoding="utf-8"?>
<databaseChangeLog
xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.3.xsd
http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd">
<changeSet author="zhuangbinan" id="modifyDataType-test02">
<modifyDataType columnName="id"
newDataType="bigint"
schemaName="jhipster7app"
tableName="test_01"/>
</changeSet>
</databaseChangeLog>
意为把test_01表的id字段类型改为bigint, 即Java的long类型,schemaName是数据库名;这里用的是mysql;
参考liquibase官方文档:
https://docs.liquibase.com/change-types/community/modify-data-type.html
这里的catalogName属性我删了,我用的mysql,因为mysql不支持catlog
2.在master.xml加入这个changlog.xml
<include file="config/liquibase/changelog/20211008145102_modify_data_type_Test02.xml" relativeToChangelogFile="false"/>