<commit_before><?xml version="1.0" encoding="UTF-8"?>
<database defaultIdMethod="native" name="default" namespace="Extia\Bundle\TaskBundle\Model">

    <table name="task">
        <column name="id" type="INTEGER" primaryKey="true" required="true" autoIncrement="true" description="id, primary key" />

        <column name="workflow_node_id" type="INTEGER" required="true" description="workflow node fk" />
        <foreign-key foreignTable="workflow_node" onDelete="cascade" onUpdate="cascade" phpName="Node" >
            <reference local="workflow_node_id" foreign="id" />
        </foreign-key>
        <behavior name="delegate">
            <parameter name="to" value="workflow_node" />
        </behavior>

        <column name="assigned_to" type="INTEGER" required="true" description="who have to handle this task" />
        <foreign-key foreignTable="person" onDelete="setnull" onUpdate="cascade" phpName="UserAssigned" skipSql="true">
            <reference local="assigned_to" foreign="id" />
        </foreign-key>

        <column name="workflow_created_by" type="INTEGER" required="true" description="user who create workflow" />
        <foreign-key foreignTable="person" onDelete="setnull" onUpdate="cascade" phpName="UserCreatedWorkflow" skipSql="true">
            <reference local="workflow_created_by" foreign="id" />
        </foreign-key>

        <column name="activation_date" type="TIMESTAMP" required="false" description="date on task have to be completed" />

        <column name="user_target_id" type="INTEGER" required="false" description="user whos concerned by the task" />
        <foreign-key foreignTable="person" onDelete="setnull" onUpdate="cascade" phpName="UserTarget" skipSql="true">
            <reference local="user_target_id" foreign="id" />
        </foreign-key>

        <column name="data" type="LONGVARCHAR" required="false" description="json extra data for task" />

        <behavior name="timestampable" /><commit_msg>adds completion date notion to tasks<commit_after><?xml version="1.0" encoding="UTF-8"?>
<database defaultIdMethod="native" name="default" namespace="Extia\Bundle\TaskBundle\Model">

    <table name="task">
        <column name="id" type="INTEGER" primaryKey="true" required="true" autoIncrement="true" description="id, primary key" />

        <column name="workflow_node_id" type="INTEGER" required="true" description="workflow node fk" />
        <foreign-key foreignTable="workflow_node" onDelete="cascade" onUpdate="cascade" phpName="Node" >
            <reference local="workflow_node_id" foreign="id" />
        </foreign-key>
        <behavior name="delegate">
            <parameter name="to" value="workflow_node" />
        </behavior>

        <column name="assigned_to" type="INTEGER" required="true" description="who have to handle this task" />
        <foreign-key foreignTable="person" onDelete="setnull" onUpdate="cascade" phpName="UserAssigned" skipSql="true">
            <reference local="assigned_to" foreign="id" />
        </foreign-key>

        <column name="workflow_created_by" type="INTEGER" required="true" description="user who create workflow" />
        <foreign-key foreignTable="person" onDelete="setnull" onUpdate="cascade" phpName="UserCreatedWorkflow" skipSql="true">
            <reference local="workflow_created_by" foreign="id" />
        </foreign-key>

        <column name="activation_date" type="TIMESTAMP" required="false" description="date on task is activated" />
        <column name="completion_date" type="TIMESTAMP" required="false" description="date on task have to be completed" />

        <column name="user_target_id" type="INTEGER" required="false" description="user whos concerned by the task" />
        <foreign-key foreignTable="person" onDelete="setnull" onUpdate="cascade" phpName="UserTarget" skipSql="true">
            <reference local="user_target_id" foreign="id" />
        </foreign-key>

        <column name="data" type="LONGVARCHAR" required="false" description="json extra data for task" />

        <behavior name="timestampable" />
{'fraction_non_alphanumeric': 0.14586908556018632, 'fraction_numerical': 0.0014709487619514587, 'mean_word_length': 4.197452229299363, 'pattern_counts': {'":': 0, '<': 56, '<?xml version=': 2, '>': 56, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 2}, 'pii_count': 0, 'substrings_counts': 0, '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': '6961369', 'n_tokens_mistral': 1177, 'n_tokens_neox': 1124, 'n_words': 254}