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="encryptedValueTableAddColumns" id="1414872417007-302" failOnError="true">
        
        <addColumn tableName="encrypted_value">
            <column name="user_id" type="VARCHAR(255)" />
        </addColumn>
        
        <addColumn tableName="encrypted_value">
            <column name="vault_name" type="VARCHAR(255)" />
        </addColumn>
    </changeSet>


    <changeSet author="deleteUserAccountGoogleMFAColumns" id="1414872417007-303" failOnError="true">
         <dropForeignKeyConstraint baseTableName="USER_ACCOUNT_GOOGLE_AUTH_SCR_0" constraintName="fk_8931ymg13vy6vfkrichdsd4"/>        
         <dropPrimaryKey constraintName="USER_ACCOUNT_GOOGLE_AUTH_SCR_0_pkey" tableName="USER_ACCOUNT_GOOGLE_AUTH_SCR_0"/>         
         <dropTable cascadeConstraints="true" tableName="USER_ACCOUNT_GOOGLE_AUTH_SCR_0"/>
         
         <dropColumn columnName="GOOGLE_AUTH_KEY" tableName="user_account"/>
         <dropColumn columnName="GOOGLE_AUTH_VERIFICATION_CODE" tableName="user_account"/>          
    </changeSet>
    

    <changeSet author="gdpr-classification-update-account" id="1414872417007-304" failOnError="true">
         <sql> COMMENT ON COLUMN public.encrypted_value.storage IS 'DATA.Confidential GDPR.Personal_Sensitive' </sql>
         <sql> COMMENT ON COLUMN public.encrypted_value.vault_name IS 'DATA.Sensitive GDPR.na' </sql>
         <sql> COMMENT ON COLUMN public.encrypted_value.user_id IS 'DATA.Sensitive GDPR.Personal_Identifier' </sql>
         <sql> COMMENT ON COLUMN public.encrypted_value.id IS 'DATA.Confidential GDPR.Personal_Sensitive' </sql>
                  
         <sql> COMMENT ON COLUMN public.user_account.user_lock_status IS 'DATA.Sensitive GDPR.Personal_Sensitive' </sql>
         <sql> COMMENT ON COLUMN public.user_account.user_email_status IS 'DATA.Sensitive GDPR.Personal_Sensitive' </sql>
    </changeSet>


    <changeSet author="encryptedValueTableChangeStorageType" id="1414872417007-305" failOnError="true">
        <modifyDataType
            columnName="storage"
            newDataType="VARCHAR(4096)"
            tableName="encrypted_value"/>            
    </changeSet>

</databaseChangeLog>