| Panel | ||
|---|---|---|
| ||
This section describes how custom database changes can be made, defining those changes in XML files rather that writing SQL directly against the database.
What does this section cover?
|
...
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
<databaseChangeLog>
...
<changeSet author="custom_developer" id="custom-data-db-change-3">
<insert tableName="CUSTOMTABLE">
<column name="CUSTOMID" value="63E096DF859A44ED958007C71F0389E5"/>
<column name="CUSTOMNAME" value="Standard Customer"/>
<column name="CUSTOMALTCODE" value="SC"/>
<column name="CUSTOMDESC"/>
<column name="CUSTOMCREATEDDATE" valueDate="2016-03-11 10:03:21.0"/>
<column name="CUSTOMUPDATEDDATE" valueDate="2016-03-11 10:03:56.0"/>
<column name="CUSTOMDELETED" valueNumeric="0"/>
<column name="CUSTOMCREATEDBYUSERID" value="1"/>
<column name="CUSTOMUPDATEDBYUSERID" value="1"/>
<column name="CUSTOMCREATEDBYOUUID" value="1"/>
<column name="CUSTOMUPDATEDBYOUUID" value="1"/>
<column name="RECVERSION" valueNumeric="0"/>
</insert>
</changeSet>
...
</databaseChangeLog> |
...
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
<databaseChangeLog>
...
<changeSet author="custom_developer" id="custom-data-db-change-3">
<insert tableName="CUSTOMTABLE">
<column name="CUSTOMID" value="63E096DF859A44ED958007C71F0389E5"/>
<column name="CUSTOMNAME" value="Standard Customer"/>
<column name="CUSTOMALTCODE" value="SC"/>
<column name="CUSTOMDESC"/>
<column name="CUSTOMCREATEDDATE" valueDate="2016-03-11 10:03:21.0"/>
<column name="CUSTOMUPDATEDDATE" valueDate="2016-03-11 10:03:56.0"/>
<column name="CUSTOMDELETED" valueNumeric="0"/>
<column name="CUSTOMCREATEDBYUSERID" value="1"/>
<column name="CUSTOMUPDATEDBYUSERID" value="1"/>
<column name="CUSTOMCREATEDBYOUUID" value="1"/>
<column name="CUSTOMUPDATEDBYOUUID" value="1"/>
<column name="RECVERSION" valueNumeric="0"/>
</insert>
</changeSet>
...
</databaseChangeLog> |