<commit_before><?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog/1.9"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog/1.9
                      http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd">
    <changeSet context="update" id="1000000000000-53" author="ThoughtWorks">
        <comment>
            Serial Number field to become optional in opv form
        </comment>
        <update tableName="incoming_message_form_parameter_definition">
            <column name="required" valueBoolean="false"/>
            <where>id=10000000001504</where>
        </update>
        <update tableName="incoming_message_form_parameter_definition">
            <column name="required" valueBoolean="false"/>
            <where>id=10000000001604</where>
        </update>
        <update tableName="incoming_message_form_parameter_definition">
            <column name="required" valueBoolean="false"/>
            <where>id=10000000001704</where>
        </update>
        <update tableName="incoming_message_form_parameter_definition">
            <column name="required" valueBoolean="false"/>
            <where>id=447236646138029</where>
        </update>
        <update tableName="incoming_message_form_parameter_definition">
            <column name="required" valueBoolean="false"/>
            <where>id=695474663923333</where>
        </update>
        <update tableName="incoming_message_form_parameter_definition">
            <column name="required" valueBoolean="false"/>
            <where>id=879874663983213</where>
        </update>
    </changeSet>

    <changeSet context="setup" author="ThoughtWorks" id="1000000000000-54">
        <loadData encoding="UTF-8" file="data/notification_type_child_week_5_to_52.csv" tableName="notification_type">
            <column header="id" type="NUMERIC"/>
            <column header="name" type="STRING"/>
            <column header="description" type="STRING"/>
        </loadData>
    </changeSet>


    <changeSet context="update" id="1000000000000-55" author="ThoughtWorks">
        <comment>
            Making community field optional in client-registration
        </comment>
        <update tableName="incoming_message_form_parameter_definition">
            <column name="required" valueBoolean="false"/>
            <where>id=10000000001021</where>
        </update>
    </changeSet>

    <changeSet context="setup" author="ThoughtWorks" id="1000000000000-56">
        <loadData encoding="UTF-8" file="data/message_template_first_year_content.csv" tableName="message_template">
            <column header="id" type="NUMERIC"/>
            <column header="obj_vesion" type="NUMERIC"/>
            <column header="date_created" type="DATE"/>
            <column header="message_type" type="STRING"/>
            <column header="template" type="STRING"/>
            <column header="notification_type" type="NUMERIC"/>
            <column header="language" type="NUMERIC"/>
        </loadData>
    </changeSet>

    <changeSet context="update" id="1000000000000-57" author="ThoughtWorks">
        <comment>
            Reverting change made in changeSet 1000000000000-53
        </comment>
        <update tableName="incoming_message_form_parameter_definition">
            <column name="required" valueBoolean="true"/>
            <where>id=10000000001504</where>
        </update>
        <update tableName="incoming_message_form_parameter_definition">
            <column name="required" valueBoolean="true"/>
            <where>id=10000000001604</where>
        </update>
        <update tableName="incoming_message_form_parameter_definition">
            <column name="required" valueBoolean="true"/>
            <where>id=10000000001704</where>
        </update>
        <update tableName="incoming_message_form_parameter_definition">
            <column name="required" valueBoolean="true"/>
            <where>id=447236646138029</where>
        </update>
        <update tableName="incoming_message_form_parameter_definition">
            <column name="required" valueBoolean="true"/>
            <where>id=695474663923333</where>
        </update>
        <update tableName="incoming_message_form_parameter_definition">
            <column name="required" valueBoolean="true"/>
            <where>id=879874663983213</where>
        </update>
    </changeSet>
</databaseChangeLog><commit_msg>#93 Added new languages to table<commit_after><?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog/1.9"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog/1.9
                      http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd">
    <changeSet context="update" id="1000000000000-53" author="ThoughtWorks">
        <comment>
            Serial Number field to become optional in opv form
        </comment>
        <update tableName="incoming_message_form_parameter_definition">
            <column name="required" valueBoolean="false"/>
            <where>id=10000000001504</where>
        </update>
        <update tableName="incoming_message_form_parameter_definition">
            <column name="required" valueBoolean="false"/>
            <where>id=10000000001604</where>
        </update>
        <update tableName="incoming_message_form_parameter_definition">
            <column name="required" valueBoolean="false"/>
            <where>id=10000000001704</where>
        </update>
        <update tableName="incoming_message_form_parameter_definition">
            <column name="required" valueBoolean="false"/>
            <where>id=447236646138029</where>
        </update>
        <update tableName="incoming_message_form_parameter_definition">
            <column name="required" valueBoolean="false"/>
            <where>id=695474663923333</where>
        </update>
        <update tableName="incoming_message_form_parameter_definition">
            <column name="required" valueBoolean="false"/>
            <where>id=879874663983213</where>
        </update>
    </changeSet>

    <changeSet context="setup" author="ThoughtWorks" id="1000000000000-54">
        <loadData encoding="UTF-8" file="data/notification_type_child_week_5_to_52.csv" tableName="notification_type">
            <column header="id" type="NUMERIC"/>
            <column header="name" type="STRING"/>
            <column header="description" type="STRING"/>
        </loadData>
    </changeSet>


    <changeSet context="update" id="1000000000000-55" author="ThoughtWorks">
        <comment>
            Making community field optional in client-registration
        </comment>
        <update tableName="incoming_message_form_parameter_definition">
            <column name="required" valueBoolean="false"/>
            <where>id=10000000001021</where>
        </update>
    </changeSet>

    <changeSet context="setup" author="ThoughtWorks" id="1000000000000-56">
        <loadData encoding="UTF-8" file="data/message_template_first_year_content.csv" tableName="message_template">
            <column header="id" type="NUMERIC"/>
            <column header="obj_vesion" type="NUMERIC"/>
            <column header="date_created" type="DATE"/>
            <column header="message_type" type="STRING"/>
            <column header="template" type="STRING"/>
            <column header="notification_type" type="NUMERIC"/>
            <column header="language" type="NUMERIC"/>
        </loadData>
    </changeSet>

    <changeSet context="update" id="1000000000000-57" author="ThoughtWorks">
        <comment>
            Reverting change made in changeSet 1000000000000-53
        </comment>
        <update tableName="incoming_message_form_parameter_definition">
            <column name="required" valueBoolean="true"/>
            <where>id=10000000001504</where>
        </update>
        <update tableName="incoming_message_form_parameter_definition">
            <column name="required" valueBoolean="true"/>
            <where>id=10000000001604</where>
        </update>
        <update tableName="incoming_message_form_parameter_definition">
            <column name="required" valueBoolean="true"/>
            <where>id=10000000001704</where>
        </update>
        <update tableName="incoming_message_form_parameter_definition">
            <column name="required" valueBoolean="true"/>
            <where>id=447236646138029</where>
        </update>
        <update tableName="incoming_message_form_parameter_definition">
            <column name="required" valueBoolean="true"/>
            <where>id=695474663923333</where>
        </update>
        <update tableName="incoming_message_form_parameter_definition">
            <column name="required" valueBoolean="true"/>
            <where>id=879874663983213</where>
        </update>
    </changeSet>

    <changeSet context="update" id="1000000000000-58" author="ThoughtWorks">
        <comment>
            #93 Adding new languages
        </comment>
        <insert tableName="languages">
            <column name="id" valueNumeric="4"/>
            <column name="code" value="fan"/>
            <column name="name" value="Fanti"/>
            <column name="description" value="Fanti is a language in Ghana"/>
        </insert>
        <insert tableName="languages">
            <column name="id" valueNumeric="5"/>
            <column name="code" value="sen"/>
            <column name="name" value="Senya"/>
            <column name="description" value="Senya is a language in Ghana"/>
        </insert>
    </changeSet>
</databaseChangeLog>
{'fraction_non_alphanumeric': 0.13103025347506134, 'fraction_numerical': 0.06285772690106296, 'mean_word_length': 2.8630082905645478, 'pattern_counts': {'":': 0, '<': 215, '<?xml version=': 2, '>': 215, 'https://': 0, 'lorem ipsum': 0, 'www.': 8, 'xml': 12}, 'pii_count': 0, 'substrings_counts': 27, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '4626324', 'n_tokens_mistral': 3127, 'n_tokens_neox': 2677, 'n_words': 439}