| 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="p_kestora" id="CRMCOMcustom-db-5483change-053"> <addForeignKeyConstraint baseColumnNames="RENTALID" baseTableName="CUSTOMTABLE" constraintName="FK_CUSTOMTABLE_01" deferrable="false" initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION" referencedColumnNames="RENTALID" referencedTableName="TRN_RENTALS"/> </changeSet> ... </databaseChangeLog> |
Create an Index
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
<databaseChangeLog>
...
<changeSet author="custom_developer" id="custom-db-change-4">
<createIndex indexName="IX_CUSTOMTABLE01" tableName="CUSTOMTABLE">
<column name="RENTALID"/>
</createIndex>
</changeSet>
...
</databaseChangeLog> |
Changelog For Data Changes
...
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
<databaseChangeLog> ... <changeSet author="custom_developer" id="custom-data-db-change-35"> <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-46"> <update tableName="CUSTOMTABLE"> <column name="CUSTOMDESC" value="This record is related to a rental" type="varchar(512)"/> <where>RENTALID IS NOT NULL</where> </update> </changeSet> ... </databaseChangeLog> |
...