<commit_before><?xml version="1.0" encoding="utf-8"?>
<database name="default" defaultIdMethod="native" defaultPhpNamingMethod="underscore" nameSpace="ChurchCRM">

    <table name="version_ver" idMethod="native" phpName="Version" description="History of all version upgrades applied to this database">
        <column name="ver_ID" phpName="Id" type="SMALLINT" size="9" sqlType="mediumint(9) unsigned" primaryKey="true"
                autoIncrement="true" required="true"/>
        <column name="ver_version" phpName="Version" type="VARCHAR" size="50" required="true" defaultValue=""/>
        <column name="ver_update_start" phpName="UpdateStart" type="TIMESTAMP"/>
        <column name="ver_update_end" phpName="UpdateEnd" type="TIMESTAMP"/>
        <unique name="ver_version">
            <unique-column name="ver_version"/>
        </unique>
        <vendor type="mysql">
            <parameter name="Engine" value="InnoDB"/>
        </vendor>
    </table>

    <table name="person_per" idMethod="native" phpName="Person" description="This contains the main person data, including person names, person addresses, person phone numbers, and foreign keys to the family table">
        <column name="per_ID" phpName="Id" type="SMALLINT" size="9" sqlType="mediumint(9) unsigned" primaryKey="true"
                autoIncrement="true" required="true"/>
        <column name="per_Title" phpName="Title" type="VARCHAR" size="50"/>
        <column name="per_FirstName" phpName="FirstName" type="VARCHAR" size="50"/>
        <column name="per_MiddleName" phpName="MiddleName" type="VARCHAR" size="50"/>
        <column name="per_LastName" phpName="LastName" type="VARCHAR" size="50"/>
        <column name="per_Suffix" phpName="Suffix" type="VARCHAR" size="50"/>
        <column name="per_Address1" phpName="Address1" type="VARCHAR" size="50"/>
        <column name="per_Address2" phpName="Address2" type="VARCHAR" size="50"/>
        <column name="per_City" phpName="City" type="VARCHAR" size="50"/>
        <column name="per_State" phpName="State" type="VARCHAR" size="50"/>
        <column name="per_Zip" phpName="Zip" type="VARCHAR" size="50"/>
        <column name="per_Country" phpName="Country" type="VARCHAR" size="50"/>
        <column name="per_HomePhone" phpName="HomePhone" type="VARCHAR" size="30"/>
        <column name="per_WorkPhone" phpName="WorkPhone" type="VARCHAR" size="30"/>
        <column name="per_CellPhone" phpName="CellPhone" type="VARCHAR" size="30"/>
        <column name="per_Email" phpName="Email" type="VARCHAR" size="50"/>
        <column name="per_WorkEmail" phpName="WorkEmail" type="VARCHAR" size="50"/>
        <column name="per_BirthMonth" phpName="BirthMonth" type="TINYINT" size="3" sqlType="tinyint(3) unsigned"
                required="true" defaultValue="0"/>
        <column name="per_BirthDay" phpName="BirthDay" type="TINYINT" size="3" sqlType="tinyint(3) unsigned"
                required="true" defaultValue="0"/>
        <column name="per_BirthYear" phpName="BirthYear" type="INTEGER" size="4"/>
        <column name="per_MembershipDate" phpName="MembershipDate" type="DATE"/>
        <column name="per_Gender" phpName="Gender" type="TINYINT" size="1" sqlType="tinyint(1) unsigned" required="true"
                defaultValue="false"/>
        <column name="per_fmr_ID" phpName="FmrId" type="TINYINT" size="3" sqlType="tinyint(3) unsigned" required="true"
                defaultValue="0"/>
        <column name="per_cls_ID" phpName="ClsId" type="TINYINT" size="3" sqlType="tinyint(3) unsigned" required="true"
                defaultValue="0"/>
        <column name="per_fam_ID" phpName="FamId" type="SMALLINT" size="5" sqlType="smallint(5) unsigned"
                required="true" defaultValue="0"/>
        <column name="per_Envelope" phpName="Envelope" type="SMALLINT" size="5" sqlType="smallint(5) unsigned"/>
        <column name="per_DateLastEdited" phpName="DateLastEdited" type="TIMESTAMP"/>
        <column name="per_DateEntered" phpName="DateEntered" type="TIMESTAMP" required="true" />
        <column name="per_EnteredBy" phpName="EnteredBy" type="SMALLINT" size="5" sqlType="smallint(5)"
                required="true" defaultValue="0"/>
        <column name="per_EditedBy" phpName="EditedBy" type="SMALLINT" size="5" sqlType="smallint(5) unsigned"
                defaultValue="0"/>
        <column name="per_FriendDate" phpName="FriendDate" type="DATE"/>
        <column name="per_Flags" phpName="Flags" type="SMALLINT" size="9" required="true" defaultValue="0"/>
        <column name="per_FacebookID" phpName="FacebookID" type="bigint" size="20" Description="FacebookID" />
        <column name="per_Twitter" phpName="Twitter" type="VARCHAR" size="50" Description="Twitter username" />
        <column name="per_LinkedIn" phpName="LinkedIn" type="VARCHAR" size="50" Description="LinkedIn name" />
        <index name="per_ID">
            <index-column name="per_ID"/>
        </index>
        <foreign-key foreignTable="family_fam">
            <reference local="per_fam_ID" foreign="fam_ID"/>
        </foreign-key>
        <vendor type="mysql">
            <parameter name="Engine" value="InnoDB"/>
        </vendor>
    </table>
    <table name="whycame_why" idMethod="native" phpName="WhyCame" description="This contains the comments related to why people came">
        <column name="why_ID" phpName="Id" type="SMALLINT" size="9" primaryKey="true" autoIncrement="true"
                required="true"/>
        <column name="why_per_ID" phpName="PerId" type="SMALLINT" size="9" required="true" defaultValue="0"/>
        <column name="why_join" phpName="Join" type="LONGVARCHAR" required="true"/>
        <column name="why_come" phpName="Come" type="LONGVARCHAR" required="true"/>
        <column name="why_suggest" phpName="Suggest" type="LONGVARCHAR" required="true"/>
        <column name="why_hearOfUs" phpName="HearOfUs" type="LONGVARCHAR" required="true"/>
        <foreign-key foreignTable="person_per">
            <reference local="why_per_ID" foreign="per_ID"/>
        </foreign-key>
        <vendor type="mysql">
            <parameter name="Engine" value="InnoDB"/>
        </vendor>
    </table>
    <table name="person_custom" idMethod="native" phpName="PersonCustom" description="Person custom fields">
        <column name="per_ID" phpName="PerId" type="SMALLINT" size="9" primaryKey="true" required="true"
                defaultValue="0"/>
        <vendor type="mysql">
            <parameter name="Engine" value="InnoDB"/>
        </vendor>
    </table>
    <table name="person_custom_master" idMethod="native" phpName="PersonCustomMaster" description="This contains definitions for the custom person fields">
        <column name="custom_Order" phpName="Order" type="SMALLINT" required="true" defaultValue="0"/>
        <column name="custom_Field" phpName="Id" type="VARCHAR" primaryKey="true" size="5" required="true" defaultValue=""/>
        <column name="custom_Name" phpName="Name" type="VARCHAR" size="40" required="true" defaultValue=""/>
        <column name="custom_Special" phpName="Special" type="SMALLINT" size="8" sqlType="mediumint(8) unsigned"/>
        <column name="custom_Side" phpName="Side" type="CHAR" sqlType="enum('left','right')" required="true"
                defaultValue="left"/>
        <column name="custom_FieldSec" phpName="CustomFieldSec" type="TINYINT" required="true"/>
        <column name="type_ID" phpName="TypeId" type="TINYINT" required="true" defaultValue="0"/>
        <vendor type="mysql">
            <parameter name="Engine" value="InnoDB"/>
        </vendor>
    </table>

    <table name="family_fam" idMethod="native" phpName="Family" description="This contains the main family data, including family name, family addresses, and family phone numbers">
        <column name="fam_ID" phpName="Id" type="SMALLINT" size="9" sqlType="mediumint(9) unsigned" primaryKey="true"
                autoIncrement="true" required="true"/>
        <column name="fam_Name" phpName="Name" type="VARCHAR" size="50"/><commit_msg>Person Custom Added Person FK reference  (#3403)<commit_after><?xml version="1.0" encoding="utf-8"?>
<database name="default" defaultIdMethod="native" defaultPhpNamingMethod="underscore" nameSpace="ChurchCRM">

    <table name="version_ver" idMethod="native" phpName="Version" description="History of all version upgrades applied to this database">
        <column name="ver_ID" phpName="Id" type="SMALLINT" size="9" sqlType="mediumint(9) unsigned" primaryKey="true"
                autoIncrement="true" required="true"/>
        <column name="ver_version" phpName="Version" type="VARCHAR" size="50" required="true" defaultValue=""/>
        <column name="ver_update_start" phpName="UpdateStart" type="TIMESTAMP"/>
        <column name="ver_update_end" phpName="UpdateEnd" type="TIMESTAMP"/>
        <unique name="ver_version">
            <unique-column name="ver_version"/>
        </unique>
        <vendor type="mysql">
            <parameter name="Engine" value="InnoDB"/>
        </vendor>
    </table>

    <table name="person_per" idMethod="native" phpName="Person" description="This contains the main person data, including person names, person addresses, person phone numbers, and foreign keys to the family table">
        <column name="per_ID" phpName="Id" type="SMALLINT" size="9" sqlType="mediumint(9) unsigned" primaryKey="true"
                autoIncrement="true" required="true"/>
        <column name="per_Title" phpName="Title" type="VARCHAR" size="50"/>
        <column name="per_FirstName" phpName="FirstName" type="VARCHAR" size="50"/>
        <column name="per_MiddleName" phpName="MiddleName" type="VARCHAR" size="50"/>
        <column name="per_LastName" phpName="LastName" type="VARCHAR" size="50"/>
        <column name="per_Suffix" phpName="Suffix" type="VARCHAR" size="50"/>
        <column name="per_Address1" phpName="Address1" type="VARCHAR" size="50"/>
        <column name="per_Address2" phpName="Address2" type="VARCHAR" size="50"/>
        <column name="per_City" phpName="City" type="VARCHAR" size="50"/>
        <column name="per_State" phpName="State" type="VARCHAR" size="50"/>
        <column name="per_Zip" phpName="Zip" type="VARCHAR" size="50"/>
        <column name="per_Country" phpName="Country" type="VARCHAR" size="50"/>
        <column name="per_HomePhone" phpName="HomePhone" type="VARCHAR" size="30"/>
        <column name="per_WorkPhone" phpName="WorkPhone" type="VARCHAR" size="30"/>
        <column name="per_CellPhone" phpName="CellPhone" type="VARCHAR" size="30"/>
        <column name="per_Email" phpName="Email" type="VARCHAR" size="50"/>
        <column name="per_WorkEmail" phpName="WorkEmail" type="VARCHAR" size="50"/>
        <column name="per_BirthMonth" phpName="BirthMonth" type="TINYINT" size="3" sqlType="tinyint(3) unsigned"
                required="true" defaultValue="0"/>
        <column name="per_BirthDay" phpName="BirthDay" type="TINYINT" size="3" sqlType="tinyint(3) unsigned"
                required="true" defaultValue="0"/>
        <column name="per_BirthYear" phpName="BirthYear" type="INTEGER" size="4"/>
        <column name="per_MembershipDate" phpName="MembershipDate" type="DATE"/>
        <column name="per_Gender" phpName="Gender" type="TINYINT" size="1" sqlType="tinyint(1) unsigned" required="true"
                defaultValue="false"/>
        <column name="per_fmr_ID" phpName="FmrId" type="TINYINT" size="3" sqlType="tinyint(3) unsigned" required="true"
                defaultValue="0"/>
        <column name="per_cls_ID" phpName="ClsId" type="TINYINT" size="3" sqlType="tinyint(3) unsigned" required="true"
                defaultValue="0"/>
        <column name="per_fam_ID" phpName="FamId" type="SMALLINT" size="5" sqlType="smallint(5) unsigned"
                required="true" defaultValue="0"/>
        <column name="per_Envelope" phpName="Envelope" type="SMALLINT" size="5" sqlType="smallint(5) unsigned"/>
        <column name="per_DateLastEdited" phpName="DateLastEdited" type="TIMESTAMP"/>
        <column name="per_DateEntered" phpName="DateEntered" type="TIMESTAMP" required="true" />
        <column name="per_EnteredBy" phpName="EnteredBy" type="SMALLINT" size="5" sqlType="smallint(5)"
                required="true" defaultValue="0"/>
        <column name="per_EditedBy" phpName="EditedBy" type="SMALLINT" size="5" sqlType="smallint(5) unsigned"
                defaultValue="0"/>
        <column name="per_FriendDate" phpName="FriendDate" type="DATE"/>
        <column name="per_Flags" phpName="Flags" type="SMALLINT" size="9" required="true" defaultValue="0"/>
        <column name="per_FacebookID" phpName="FacebookID" type="bigint" size="20" Description="FacebookID" />
        <column name="per_Twitter" phpName="Twitter" type="VARCHAR" size="50" Description="Twitter username" />
        <column name="per_LinkedIn" phpName="LinkedIn" type="VARCHAR" size="50" Description="LinkedIn name" />
        <index name="per_ID">
            <index-column name="per_ID"/>
        </index>
        <foreign-key foreignTable="family_fam">
            <reference local="per_fam_ID" foreign="fam_ID"/>
        </foreign-key>
        <vendor type="mysql">
            <parameter name="Engine" value="InnoDB"/>
        </vendor>
    </table>
    <table name="whycame_why" idMethod="native" phpName="WhyCame" description="This contains the comments related to why people came">
        <column name="why_ID" phpName="Id" type="SMALLINT" size="9" primaryKey="true" autoIncrement="true"
                required="true"/>
        <column name="why_per_ID" phpName="PerId" type="SMALLINT" size="9" required="true" defaultValue="0"/>
        <column name="why_join" phpName="Join" type="LONGVARCHAR" required="true"/>
        <column name="why_come" phpName="Come" type="LONGVARCHAR" required="true"/>
        <column name="why_suggest" phpName="Suggest" type="LONGVARCHAR" required="true"/>
        <column name="why_hearOfUs" phpName="HearOfUs" type="LONGVARCHAR" required="true"/>
        <foreign-key foreignTable="person_per">
            <reference local="why_per_ID" foreign="per_ID"/>
        </foreign-key>
        <vendor type="mysql">
            <parameter name="Engine" value="InnoDB"/>
        </vendor>
    </table>
    <table name="person_custom" idMethod="native" phpName="PersonCustom" description="Person custom fields">
        <column name="per_ID" phpName="PerId" type="SMALLINT" size="9" primaryKey="true" required="true"
                defaultValue="0"/>
        <foreign-key foreignTable="person_per">
            <reference local="per_ID" foreign="per_ID"/>
        </foreign-key>
        <vendor type="mysql">
            <parameter name="Engine" value="InnoDB"/>
        </vendor>
    </table>
    <table name="person_custom_master" idMethod="native" phpName="PersonCustomMaster" description="This contains definitions for the custom person fields">
        <column name="custom_Order" phpName="Order" type="SMALLINT" required="true" defaultValue="0"/>
        <column name="custom_Field" phpName="Id" type="VARCHAR" primaryKey="true" size="5" required="true" defaultValue=""/>
        <column name="custom_Name" phpName="Name" type="VARCHAR" size="40" required="true" defaultValue=""/>
        <column name="custom_Special" phpName="Special" type="SMALLINT" size="8" sqlType="mediumint(8) unsigned"/>
        <column name="custom_Side" phpName="Side" type="CHAR" sqlType="enum('left','right')" required="true"
                defaultValue="left"/>
        <column name="custom_FieldSec" phpName="CustomFieldSec" type="TINYINT" required="true"/>
        <column name="type_ID" phpName="TypeId" type="TINYINT" required="true" defaultValue="0"/>
        <vendor type="mysql">
            <parameter name="Engine" value="InnoDB"/>
        </vendor>
    </table>

    <table name="family_fam" idMethod="native" phpName="Family" description="This contains the main family data, including family name, family addresses, and family phone numbers">
        <column name="fam_ID" phpName="Id" type="SMALLINT" size="9" sqlType="mediumint(9) unsigned" primaryKey="true"
                autoIncrement="true" required="true"/>
        <column name="fam_Name" phpName="Name" type="VARCHAR" size="50"/>
{'fraction_non_alphanumeric': 0.16290649781766767, 'fraction_numerical': 0.011925985123255671, 'mean_word_length': 4.167725540025413, 'pattern_counts': {'":': 0, '<': 196, '<?xml version=': 2, '>': 196, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 2}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 6, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '462282', 'n_tokens_mistral': 5066, 'n_tokens_neox': 4813, 'n_words': 1009}