Skip to content

Commit

Permalink
TRUNK-3884 Relationships missing for encounter_provider table
Browse files Browse the repository at this point in the history
  • Loading branch information
@ArcTanSusan @rkorytkowski
ArcTanSusan authored and rkorytkowski committed Jun 18, 2013
1 parent 29027e2 commit 0b227ca
Showing 1 changed file with 8 additions and 2 deletions.
10 changes: 8 additions & 2 deletions api/src/main/resources/liquibase-update-to-latest.xml
View file
Expand Up @@ -7499,7 +7499,7 @@
<not><columnExists tableName="person" columnName="deathdate_estimated"/></not>
</preConditions>
<comment>
Adding deathdate_estimated column to person.
Adding deathdate_estimated column to person.
</comment>
<addColumn tableName="person">
<column defaultValueBoolean="false" name="deathdate_estimated" type="BOOLEAN">
Expand All @@ -7508,5 +7508,11 @@
</addColumn>
</changeSet>

</databaseChangeLog>
<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 0b227ca

Please sign in to comment.