databaseChangeLog

<?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"
    xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
    xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
    http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd"> 
 <changeSet author="sudarshan" id="insertRedisNonceConfigTag">
        <tagDatabase tag="v2"/> 
 </changeSet>   
 <changeSet author="sudarshan" id="insertRedisNonceHostUrl">
    <!-- <tagDatabase tag="${redis_nonce_hosturl_config_tag}"/> -->
    <insert tableName="MAGNUS_PROPERTIES">
        <column name="PROP_Name" type="varchar(512)" value = "redis.nonce_hosturl"/>
        <column name="PROP_Dynamic" type="bit(1)" value = ""/>
        <column name="PROP_Desc" type="varchar(5096)" value = "The redis host"/>
        <column name="PROP_Value" type="varchar(1024)" value = "${redis.nonce_hosturl.value}" />
        <column name="PROP_Application" type="varchar(512)" value = "secure"/>
    </insert>
    <rollback>DELETE FROM MAGNUS_PROPERTIES where PROP_Name = "redis.nonce_hosturl"</rollback>
 </changeSet>
 <changeSet author="sudarshan" id="insertRedisNoncePort">
    <!-- <tagDatabase tag="${redis_nonce_port_config_tag}"/> -->
    <insert tableName="MAGNUS_PROPERTIES">
        <column name="PROP_Name" type="varchar(512)" value = "redis.nonce_port"/>
        <column name="PROP_Dynamic" type="bit(1)" value = ""/>
        <column name="PROP_Desc" type="varchar(5096)" value = "The redis nonce port"/>
        <column name="PROP_Value" type="varchar(1024)" value = "${redis.nonce_port.value}"/>
        <column name="PROP_Application" type="varchar(512)" value = "secure"/>
    </insert>
    <rollback>DELETE FROM MAGNUS_PROPERTIES where PROP_Name = "redis.nonce_port"</rollback>
 </changeSet> 
 <changeSet author="sudarshan" id="insertRedisNonceDBIndex">
    <!-- <tagDatabase tag="${redis_nonce_dbindex_config_tag}"/> -->
    <insert  tableName="MAGNUS_PROPERTIES">
        <column name="PROP_Name" type="varchar(512)" value = "redis.nonce_database_index"/>
        <column name="PROP_Dynamic" type="bit(1)" value = ""/>
        <column name="PROP_Desc" type="varchar(5096)" value = "The redis nonce database index"/>
        <column name="PROP_Value" type="varchar(1024)" value = "${redis.nonce_database_index.value}"/>
        <column name="PROP_Application" type="varchar(512)" value = "secure"/>
    </insert>
    <rollback>DELETE FROM MAGNUS_PROPERTIES where PROP_Name = "redis.nonce_database_index"</rollback>
 </changeSet>
 <changeSet author="sudarshan" id="insertRedisNonceKeyTTLInDays">
    <!-- <tagDatabase tag="${redis_nonce_keyttl_config_tag}"/> -->
    <insert tableName="MAGNUS_PROPERTIES">
        <column name="PROP_Name" type="varchar(512)" value = "redis.nonce_key_ttl_in_days"/>
        <column name="PROP_Dynamic" type="bit(1)" value = ""/>
        <column name="PROP_Desc" type="varchar(5096)" value = "The redis nonce key TTL in days "/>
        <column name="PROP_Value" type="varchar(1024)" value = "${redis.nonce_key_ttl_in_days.value}"/>
        <column name="PROP_Application" type="varchar(512)" value = "secure"/>
    </insert>
    <rollback>DELETE FROM MAGNUS_PROPERTIES where PROP_Name = "redis.nonce_key_ttl_in_days"</rollback>
 </changeSet>
</databaseChangeLog>