Skip to content

Commit

Permalink
TRUNK-3884 Relationships missing for encounter_provider table
Browse files Browse the repository at this point in the history 
(cherry picked from commit 0b227ca)
  • Loading branch information
@ArcTanSusan @rkorytkowski
ArcTanSusan authored and rkorytkowski committed Jun 18, 2013
1 parent 9c146da commit 77b80d9
Showing 1 changed file with 7 additions and 0 deletions.
7 changes: 7 additions & 0 deletions api/src/main/resources/liquibase-update-to-latest.xml
View file
Expand Up @@ -6411,5 +6411,12 @@
<where>name='Auto Close Visits Task'</where>
</update>
</changeSet>

<changeSet id="201306141103-TRUNK-3884" author="susantan">
<comment>Adding 3 foreign key relationships (creator,created_by,voided_by) to encounter_provider table</comment>
<addForeignKeyConstraint constraintName="encounter_provider_creator" baseTableName="encounter_provider" baseColumnNames="creator" referencedTableName="users" referencedColumnNames="user_id"/>
<addForeignKeyConstraint constraintName="encounter_provider_changed_by" baseTableName="encounter_provider" baseColumnNames="changed_by" referencedTableName="users" referencedColumnNames="user_id"/>
<addForeignKeyConstraint constraintName="encounter_provider_voided_by" baseTableName="encounter_provider" baseColumnNames="voided_by" referencedTableName="users" referencedColumnNames="user_id"/>
</changeSet>

</databaseChangeLog>

0 comments on commit 77b80d9

Please sign in to comment.