Skip to content

Instantly share code, notes, and snippets.

@sudarshan-webonise

sudarshan-webonise/databaseChangeLog

Created July 28, 2015 19:01
Show Gist options
  • Save sudarshan-webonise/ad1fdae960d697070aec to your computer and use it in GitHub Desktop.
Save sudarshan-webonise/ad1fdae960d697070aec to your computer and use it in GitHub Desktop.
Download ZIP
Raw
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>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment