<?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="023-add-batch-cancel-permission" author="effigenix">
        <comment>Add BATCH_CANCEL permission for ADMIN and PRODUCTION_MANAGER roles</comment>

        <!-- ADMIN -->
        <insert tableName="role_permissions">
            <column name="role_id" value="c0a80121-0000-0000-0000-000000000001"/>
            <column name="permission" value="BATCH_CANCEL"/>
        </insert>

        <!-- PRODUCTION_MANAGER -->
        <insert tableName="role_permissions">
            <column name="role_id" value="c0a80121-0000-0000-0000-000000000002"/>
            <column name="permission" value="BATCH_CANCEL"/>
        </insert>
    </changeSet>

</databaseChangeLog>
