liquibase添加非空字段-报错解决
这取决于您的数据库。Mysql / Mariadb可以像这样简单:
<changeSet author="tibi" id="201803062100-1">
<addColumn tableName="jhi_user">
<column name="status" type="varchar(20)" value="ENABLED" />
<constraints nullable="false" />
</addColumn>
</changeSet>
H2不允许这样做,因此您需要这样做:
<changeSet author="tibi" id="201803062100-1">
<addColumn tableName="jhi_user">
<column name="status" type="varchar(20)" value="ENABLED" />
</addColumn>
<addNotNullConstraint columnDataType="varchar(20)" columnName="status" tableName="jhi_user" />
</changeSet>
或您的情况:
<changeSet author="tibi" id="201803062100-1">
<addColumn tableName="jhi_user">
<column name="status" type="boolean" value="0" />
</addColumn>
<addNotNullConstraint columnDataType="boolean" columnName="status" tableName="jhi_user" />
</changeSet>