<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        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-latest.xsd">

    <changeSet id="021-add-completion-fields-to-batches" author="effigenix">
        <addColumn tableName="batches">
            <column name="actual_quantity_amount" type="DECIMAL(19,6)"/>
            <column name="actual_quantity_unit" type="VARCHAR(10)"/>
            <column name="waste_amount" type="DECIMAL(19,6)"/>
            <column name="waste_unit" type="VARCHAR(10)"/>
            <column name="remarks" type="VARCHAR(500)"/>
            <column name="completed_at" type="TIMESTAMPTZ"/>
        </addColumn>
    </changeSet>

</databaseChangeLog>
