<commit_before><?xml version="1.0" encoding="UTF-8"?>
<!--will create Portal DB that is at version 2.0-->

<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"
         logicalFilePath="classpath:cagrid_portal-db-20-changelog.xml">

    <changeSet author="kherm (generated)" id="20-1">
        <preConditions onFail="MARK_RAN">
            <not>
                <tableExists tableName="addresses"/>
            </not>
        </preConditions>
        <createTable tableName="addresses">
            <column autoIncrement="true" name="id" type="INT">
                <constraints nullable="false" primaryKey="true"/>
            </column>
            <column name="country" type="VARCHAR(255)"/>
            <column name="latitude" type="FLOAT(12,0)"/>
            <column name="locality" type="VARCHAR(255)"/>
            <column name="longitude" type="FLOAT(12,0)"/>
            <column name="postalCode" type="VARCHAR(255)"/>
            <column name="stateProvince" type="VARCHAR(255)"/>
            <column name="street1" type="VARCHAR(255)"/>
            <column name="street2" type="VARCHAR(255)"/>
        </createTable>
    </changeSet>

    <changeSet author="kherm (generated)" id="20-2">
        <preConditions onFail="MARK_RAN">
            <not>
                <tableExists tableName="authn_tickets"/>
            </not>
        </preConditions>
        <createTable tableName="authn_tickets">
            <column autoIncrement="true" name="id" type="INT">
                <constraints nullable="false" primaryKey="true"/>
            </column>
            <column name="notAfter" type="DATETIME"/>
            <column name="ticket" type="VARCHAR(255)"/>
            <column name="user_id" type="INT"/>
        </createTable>
    </changeSet>

    <changeSet author="kherm (generated)" id="20-3">
        <preConditions onFail="MARK_RAN">
            <not>
                <tableExists tableName="c_hier"/>
            </not>
        </preConditions>
        <createTable tableName="c_hier">
            <column autoIncrement="true" name="id" type="INT">
                <constraints nullable="false" primaryKey="true"/>
            </column><commit_msg>rfe<commit_after><?xml version="1.0" encoding="UTF-8"?>
<!--will create Portal DB that is at version 2.0-->

<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"
         logicalFilePath="classpath:cagrid_portal-db-20-changelog.xml">

    <changeSet author="kherm (generated)" id="20-1">
        <preConditions onFail="MARK_RAN">
            <not>
                <tableExists tableName="addresses"/>
            </not>
        </preConditions>
        <createTable tableName="addresses">
            <column autoIncrement="true" name="id" type="INT">
                <constraints nullable="false" primaryKey="true"/>
            </column>
            <column name="country" type="VARCHAR(255)"/>
            <column name="latitude" type="FLOAT(12,0)"/>
            <column name="locality" type="VARCHAR(255)"/>
            <column name="longitude" type="FLOAT(12,0)"/>
            <column name="postalCode" type="VARCHAR(255)"/>
            <column name="stateProvince" type="VARCHAR(255)"/>
            <column name="street1" type="VARCHAR(255)"/>
            <column name="street2" type="VARCHAR(255)"/>
        </createTable>
    </changeSet>

    <changeSet author="kherm (generated)" id="20-2">
        <preConditions onFail="MARK_RAN">
            <not>
                <tableExists tableName="authn_tickets"/>
            </not>
        </preConditions>
        <createTable tableName="authn_tickets">
            <column autoIncrement="true" name="id" type="INT">
                <constraints nullable="false" primaryKey="true"/>
            </column>
            <column name="notAfter" type="DATETIME"/>
            <column name="ticket" type="VARCHAR(255)"/>
            <column name="user_id" type="INT"/>
        </createTable>
    </changeSet>

    <!--clean all authentication tickets. Will always run-->
    <changeSet id="20-2-always" author="kherm" runAlways="true">
        <preConditions onError="MARK_RAN">
            <tableExists tableName="authn_tickets"/>
        </preConditions>
        <delete tableName="authn_tickets">
        </delete>
    </changeSet>

    <changeSet author="kherm (generated)" id="20-3">
        <preConditions onFail="MARK_RAN">
            <not>
                <tableExists tableName="c_hier"/>
            </not>
        </preConditions>
        <createTable tableName="c_hier">
            <column autoIncrement="true" name="id" type="INT">
                <constraints nullable="false" primaryKey="true"/>
            </column>
{'fraction_non_alphanumeric': 0.16012436844150796, 'fraction_numerical': 0.022347454333462885, 'mean_word_length': 2.331391585760518, 'pattern_counts': {'":': 0, '<': 107, '<?xml version=': 2, '>': 107, 'https://': 0, 'lorem ipsum': 0, 'www.': 8, 'xml': 14}, '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': '3867311', 'n_tokens_mistral': 1624, 'n_tokens_neox': 1539, 'n_words': 255}