Bugs item #807790, was opened at 2003-09-17 15:40 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=807790&group_id=22866
Category: JBossCMP Group: v3.2 Status: Open Resolution: None Priority: 5 Submitted By: Alexei Yudichev (sflexus) Assigned to: Nobody/Anonymous (nobody) Summary: Multi-column foreign key is created with wrong column order Initial Comment: I have "many DeliveryTickets" - "one Terminal" CMP relationship. Terminal has a compound primary key (vendor, model). JBoss issues the following command to add a foreign key on DeliveryTicket table: ALTER TABLE deliveryticket ADD CONSTRAINT fk_deliveryticket_terminal FOREIGN KEY (terminal_model, terminal_vendor) REFERENCES terminal (vendor, mode l) As you can see, column order is reverse. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=807790&group_id=22866 ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ JBoss-Development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development