<commit_before><?xml version="1.0" encoding="UTF-8" standalone="no"?>
<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-3.2.xsd">
    <changeSet author="<EMAIL>" id="1.0.0.Final">
        <createTable tableName="APPLICATION_DEFAULT_ROLES">
            <column name="APPLICATION_ID" type="VARCHAR(36)">
                <constraints nullable="false"/>
            </column>
            <column name="ROLE_ID" type="VARCHAR(36)">
                <constraints nullable="false"/>
            </column>
        </createTable>
        <createTable tableName="CLIENT">
            <column name="DTYPE" type="VARCHAR(31)">
                <constraints nullable="false"/>
            </column>
            <column name="ID" type="VARCHAR(36)">
                <constraints nullable="false"/>
            </column>
            <column name="ALLOWED_CLAIMS_MASK" type="BIGINT"/>
            <column name="ENABLED" type="BOOLEAN" defaultValueBoolean="false">
                <constraints nullable="false"/>
            </column>
            <column name="FULL_SCOPE_ALLOWED" type="BOOLEAN" defaultValueBoolean="false">
                <constraints nullable="false"/>
            </column>
            <column name="NAME" type="VARCHAR(255)"/>
            <column name="NOT_BEFORE" type="INT"/>
            <column name="PUBLIC_CLIENT" type="BOOLEAN" defaultValueBoolean="false">
                <constraints nullable="false"/>
            </column>
            <column name="SECRET" type="VARCHAR(255)"/>
            <column name="BASE_URL" type="VARCHAR(255)"/>
            <column name="BEARER_ONLY" type="BOOLEAN" defaultValueBoolean="false">
                <constraints nullable="false"/>
            </column>
            <column name="MANAGEMENT_URL" type="VARCHAR(255)"/>
            <column name="SURROGATE_AUTH_REQUIRED" type="BOOLEAN" defaultValueBoolean="false">
                <constraints nullable="false"/>
            </column>
            <column name="DIRECT_GRANTS_ONLY" type="BOOLEAN" defaultValueBoolean="false">
                <constraints nullable="false"/>
            </column>
            <column name="REALM_ID" type="VARCHAR(36)"/>
        </createTable>
        <createTable tableName="CLIENT_SESSION">
            <column name="ID" type="VARCHAR(36)">
                <constraints nullable="false"/>
            </column>
            <column name="ACTION" type="INT"/>
            <column name="CLIENT_ID" type="VARCHAR(36)"/>
            <column name="REDIRECT_URI" type="VARCHAR(255)"/>
            <column name="STATE" type="VARCHAR(255)"/>
            <column name="TIMESTAMP" type="INT"/>
            <column name="SESSION_ID" type="VARCHAR(36)"/>
        </createTable>
        <createTable tableName="CLIENT_SESSION_ROLE">
            <column name="ROLE_ID" type="VARCHAR(255)">
                <constraints nullable="false"/>
            </column>
            <column name="CLIENT_SESSION" type="VARCHAR(36)">
                <constraints nullable="false"/>
            </column>
        </createTable>
        <createTable tableName="COMPOSITE_ROLE">
            <column name="COMPOSITE" type="VARCHAR(36)">
                <constraints nullable="false"/>
            </column>
            <column name="CHILD_ROLE" type="VARCHAR(36)">
                <constraints nullable="false"/>
            </column>
        </createTable>
        <createTable tableName="CREDENTIAL">
            <column name="ID" type="VARCHAR(36)">
                <constraints nullable="false"/>
            </column>
            <column name="DEVICE" type="VARCHAR(255)"/>
            <column name="HASH_ITERATIONS" type="INT"/>
            <column name="SALT" type="VARBINARY(16)"/>
            <column name="TYPE" type="VARCHAR(255)"/>
            <column name="VALUE" type="VARCHAR(255)"/>
            <column name="USER_ID" type="VARCHAR(36)"/>
        </createTable>
        <createTable tableName="EVENT_ENTITY">
            <column name="ID" type="VARCHAR(36)">
                <constraints nullable="false"/>
            </column>
            <column name="CLIENT_ID" type="VARCHAR(255)"/>
            <column name="DETAILS_JSON" type="VARCHAR(2550)"/>
            <column name="ERROR" type="VARCHAR(255)"/>
            <column name="IP_ADDRESS" type="VARCHAR(255)"/>
            <column name="REALM_ID" type="VARCHAR(255)"/>
            <column name="SESSION_ID" type="VARCHAR(255)"/>
            <column name="TIME" type="BIGINT"/>
            <column name="TYPE" type="VARCHAR(255)"/>
            <column name="USER_ID" type="VARCHAR(255)"/>
        </createTable>
        <createTable tableName="FED_PROVIDERS">
            <column name="REALM_ID" type="VARCHAR(36)">
                <constraints nullable="false"/><commit_msg>KEYCLOAK-766 Keycloak fails with OpenShift PostgreSQL 9.2 cartridge, works fine with MySQL one<commit_after><?xml version="1.0" encoding="UTF-8" standalone="no"?>
<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-3.2.xsd">
    <changeSet author="<EMAIL>" id="1.0.0.Final">
        <createTable tableName="APPLICATION_DEFAULT_ROLES">
            <column name="APPLICATION_ID" type="VARCHAR(36)">
                <constraints nullable="false"/>
            </column>
            <column name="ROLE_ID" type="VARCHAR(36)">
                <constraints nullable="false"/>
            </column>
        </createTable>
        <createTable tableName="CLIENT">
            <column name="DTYPE" type="VARCHAR(31)">
                <constraints nullable="false"/>
            </column>
            <column name="ID" type="VARCHAR(36)">
                <constraints nullable="false"/>
            </column>
            <column name="ALLOWED_CLAIMS_MASK" type="BIGINT"/>
            <column name="ENABLED" type="BOOLEAN" defaultValueBoolean="false">
                <constraints nullable="false"/>
            </column>
            <column name="FULL_SCOPE_ALLOWED" type="BOOLEAN" defaultValueBoolean="false">
                <constraints nullable="false"/>
            </column>
            <column name="NAME" type="VARCHAR(255)"/>
            <column name="NOT_BEFORE" type="INT"/>
            <column name="PUBLIC_CLIENT" type="BOOLEAN" defaultValueBoolean="false">
                <constraints nullable="false"/>
            </column>
            <column name="SECRET" type="VARCHAR(255)"/>
            <column name="BASE_URL" type="VARCHAR(255)"/>
            <column name="BEARER_ONLY" type="BOOLEAN" defaultValueBoolean="false">
                <constraints nullable="false"/>
            </column>
            <column name="MANAGEMENT_URL" type="VARCHAR(255)"/>
            <column name="SURROGATE_AUTH_REQUIRED" type="BOOLEAN" defaultValueBoolean="false">
                <constraints nullable="false"/>
            </column>
            <column name="DIRECT_GRANTS_ONLY" type="BOOLEAN" defaultValueBoolean="false">
                <constraints nullable="false"/>
            </column>
            <column name="REALM_ID" type="VARCHAR(36)"/>
        </createTable>
        <createTable tableName="CLIENT_SESSION">
            <column name="ID" type="VARCHAR(36)">
                <constraints nullable="false"/>
            </column>
            <column name="ACTION" type="INT"/>
            <column name="CLIENT_ID" type="VARCHAR(36)"/>
            <column name="REDIRECT_URI" type="VARCHAR(255)"/>
            <column name="STATE" type="VARCHAR(255)"/>
            <column name="TIMESTAMP" type="INT"/>
            <column name="SESSION_ID" type="VARCHAR(36)"/>
        </createTable>
        <createTable tableName="CLIENT_SESSION_ROLE">
            <column name="ROLE_ID" type="VARCHAR(255)">
                <constraints nullable="false"/>
            </column>
            <column name="CLIENT_SESSION" type="VARCHAR(36)">
                <constraints nullable="false"/>
            </column>
        </createTable>
        <createTable tableName="COMPOSITE_ROLE">
            <column name="COMPOSITE" type="VARCHAR(36)">
                <constraints nullable="false"/>
            </column>
            <column name="CHILD_ROLE" type="VARCHAR(36)">
                <constraints nullable="false"/>
            </column>
        </createTable>
        <createTable tableName="CREDENTIAL">
            <column name="ID" type="VARCHAR(36)">
                <constraints nullable="false"/>
            </column>
            <column name="DEVICE" type="VARCHAR(255)"/>
            <column name="HASH_ITERATIONS" type="INT"/>
            <column name="SALT" type="BLOB(16)"/>
            <column name="TYPE" type="VARCHAR(255)"/>
            <column name="VALUE" type="VARCHAR(255)"/>
            <column name="USER_ID" type="VARCHAR(36)"/>
        </createTable>
        <createTable tableName="EVENT_ENTITY">
            <column name="ID" type="VARCHAR(36)">
                <constraints nullable="false"/>
            </column>
            <column name="CLIENT_ID" type="VARCHAR(255)"/>
            <column name="DETAILS_JSON" type="VARCHAR(2550)"/>
            <column name="ERROR" type="VARCHAR(255)"/>
            <column name="IP_ADDRESS" type="VARCHAR(255)"/>
            <column name="REALM_ID" type="VARCHAR(255)"/>
            <column name="SESSION_ID" type="VARCHAR(255)"/>
            <column name="TIME" type="BIGINT"/>
            <column name="TYPE" type="VARCHAR(255)"/>
            <column name="USER_ID" type="VARCHAR(255)"/>
        </createTable>
        <createTable tableName="FED_PROVIDERS">
            <column name="REALM_ID" type="VARCHAR(36)">
                <constraints nullable="false"/>
{'fraction_non_alphanumeric': 0.15742415109503718, 'fraction_numerical': 0.020594735784609203, 'mean_word_length': 2.288734720845722, 'pattern_counts': {'":': 0, '<': 203, '<?xml version=': 2, '>': 203, 'https://': 0, 'lorem ipsum': 0, 'www.': 8, 'xml': 12}, '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': '4673704', 'n_tokens_mistral': 3027, 'n_tokens_neox': 2853, 'n_words': 475}