Hack23/cia

<?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-3.5.xsd">

    <changeSet author="pether (generated)" id="1414872417007-279">
         <addColumn tableName="document_element">
            <column name="domain_org" type="varchar(255)"/>
            <column name="database_source" type="varchar(255)"/>
            <column name="origin" type="varchar(255)"/>
            <column name="lang" type="varchar(255)"/>
            <column name="summary" type="varchar(8192)"/>
            <column name="note" type="varchar(8192)"/>
            <column name="note_title" type="varchar(8192)"/>
            <column name="debate_name" type="varchar(255)"/>
            <column name="document_name" type="varchar(255)"/>
        </addColumn>
    </changeSet>

    <changeSet author="pether (generated)" id="1414872417007-280">
         <addColumn tableName="document_element">
            <column name="doc_type" type="varchar(255)"/>
        </addColumn>
    </changeSet>


    <changeSet author="pether (generated)" id="1414872417007-281">
        <createTable tableName="USER_ACCOUNT_GOOGLE_AUTH_SCR_0">
            <column name="hjid" type="INT8">
                <constraints nullable="false" />
            </column>
            <column name="hjvalue" type="INT4" />
            <column name="hjindex" type="INT4">
                <constraints nullable="false" />
            </column>
        </createTable>
    </changeSet>

    <changeSet author="pether (generated)" id="1414872417007-282">
        <addPrimaryKey columnNames="hjid, hjindex"
            constraintName="USER_ACCOUNT_GOOGLE_AUTH_SCR_0_pkey" tableName="USER_ACCOUNT_GOOGLE_AUTH_SCR_0" />
    </changeSet>

    <changeSet author="pether (generated)" id="1414872417007-283">
        <addForeignKeyConstraint baseColumnNames="hjid"
            baseTableName="USER_ACCOUNT_GOOGLE_AUTH_SCR_0" constraintName="fk_8931ymg13vy6vfkrichdsd4"
            deferrable="false" initiallyDeferred="false" onDelete="NO ACTION"
            onUpdate="NO ACTION" referencedColumnNames="hjid"
            referencedTableName="user_account" />
    </changeSet>

    <changeSet author="pether (generated)" id="1414872417007-284">
         <addColumn tableName="user_account">
            <column name="GOOGLE_AUTH_KEY" type="varchar(1024)"/>
        </addColumn>
         <addColumn tableName="user_account">
            <column name="GOOGLE_AUTH_VERIFICATION_CODE" type="INT4"/>
        </addColumn>
    </changeSet>


</databaseChangeLog>