A new topic, 'diff generates add/drop for foreign keys that already exist in
both db's', has been made on a board you are watching.
You can see it at
http://liquibase.org/forum/index.php?topic=45.new#new
The text of the topic is shown below:
Hi,
I suspect this is a bug, but diff appears to produce changesets for foreign
keys that are actually the same. Example below. Is this something that is on
the radar to be fixed?
Thanks,
Brendan
Code:
<changeSet author="bcollins (generated)" id="1244664363185-2">
<addForeignKeyConstraint baseColumnNames="channel_id, distributor_id"
baseTableName="distribution_channel_agency_mappings" baseTableSchemaName="dbo"
constraintName="FKEDD440681B8AC7C9" deferrable="false"
initiallyDeferred="false" onDelete="RESTRICT" onUpdate="RESTRICT"
referencedColumnNames="channel_id, distributor_id"
referencedTableName="distribution_channels" referencedTableSchemaName="dbo"/>
</changeSet>
<changeSet author="bcollins (generated)" id="1244664363185-3">
<addForeignKeyConstraint baseColumnNames="channel_id, distributor_id"
baseTableName="distribution_channel_company_mappings" baseTableSchemaName="dbo"
constraintName="FK4E98BFFE1B8AC7C9" deferrable="false"
initiallyDeferred="false" onDelete="RESTRICT" onUpdate="RESTRICT"
referencedColumnNames="channel_id, distributor_id"
referencedTableName="distribution_channels" referencedTableSchemaName="dbo"/>
</changeSet>
<changeSet author="bcollins (generated)" id="1244664363185-4">
<dropForeignKeyConstraint
baseTableName="distribution_channel_agency_mappings" baseTableSchemaName="dbo"
constraintName="FKEDD440681B8AC7C9"/>
</changeSet>
<changeSet author="bcollins (generated)" id="1244664363185-5">
<dropForeignKeyConstraint
baseTableName="distribution_channel_company_mappings" baseTableSchemaName="dbo"
constraintName="FK4E98BFFE1B8AC7C9"/>
</changeSet>
Unsubscribe to new topics from this board by clicking here:
http://liquibase.org/forum/index.php?action=notifyboard;board=1.0
Regards,
The LiquiBase Community Forum Team.------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user
