[TORQUE-6] Generator does not generate foreign key constraints for Interbase/Firebird

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.2
• Fix Version/s: 3.3
• Component/s: Generator
• Assignee: Thomas Fox
• Reporter: Joerg Friedrich
• Created: 20/Apr/06 21:53
• Updated: 26/Nov/06 18:23
• Resolved: 01/Jun/06 03:03

Description

The generator does not generate foreign key constraints for Interbase/Firebird. This could probably be easily fixed by adding a file foreignkey.vm to the sql/base/interbase directory in the templates jar (torque-gen-templates-3.2.jar) containing this:

#foreach ($fk in $table.ForeignKeys)
FOREIGN KEY ($fk.LocalColumnNames) REFERENCES $fk.ForeignTableName ($fk.ForeignColumnNames),
#end