<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 id="1" author="meri">
        <comment>
            Create table structure for users, passwords, roles and permissions.
        </comment>
        <createTable tableName="sec_users">
            <column name="name" type="varchar(150)">
                <constraints primaryKey="true" nullable="false" />
            </column>
            <column name="password" type="varchar(1500)">
                <constraints nullable="false" />
            </column>
            <column name="salt" type="varchar(1500)">
                <constraints nullable="false" />
            </column>
        </createTable>

        <createTable tableName="sec_roles">
            <column name="name" type="varchar(150)">
                <constraints primaryKey="true" nullable="false" />
            </column>
            <column name="description" type="varchar(1500)">
            </column><commit_msg>*liquibase XSD schema from version 1.9 to 2.0<commit_after><?xml version="1.0" encoding="UTF-8"?>

<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-2.0.xsd">

    <changeSet id="1" author="meri">
        <comment>
            Create table structure for users, passwords, roles and permissions.
        </comment>
        <createTable tableName="sec_users">
            <column name="name" type="varchar(150)">
                <constraints primaryKey="true" nullable="false" />
            </column>
            <column name="password" type="varchar(1500)">
                <constraints nullable="false" />
            </column>
            <column name="salt" type="varchar(1500)">
                <constraints nullable="false" />
            </column>
        </createTable>

        <createTable tableName="sec_roles">
            <column name="name" type="varchar(150)">
                <constraints primaryKey="true" nullable="false" />
            </column>
            <column name="description" type="varchar(1500)">
            </column>
{'fraction_non_alphanumeric': 0.15228628230616303, 'fraction_numerical': 0.026242544731610338, 'mean_word_length': 2.271781534460338, 'pattern_counts': {'":': 0, '<': 47, '<?xml version=': 2, '>': 47, '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': '3511041', 'n_tokens_mistral': 802, 'n_tokens_neox': 731, 'n_words': 120}