[Uml-devel] [Bug 77377] SQL code generator generates "circular reference" foreign keys

[Alexey Parshin]

------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
         
http://bugs.kde.org/show_bug.cgi?id=77377         




------- Additional Comments From alexeyp gmail com  2006-11-20 08:29 -------
Created an attachment (id=18621)
 --> (http://bugs.kde.org/attachment.cgi?id=18621&action=view)
Patch to allow tables to have self-references

Sometimes, you need something like this:
create table t1 (
  id int primary key,
  parent int references t1(id)
);
The proposed patch allows it.
Also, Umbrello sometimes tries to create (in the export file) the empty foreign
keys with no table name and fields. These declarations come as a result of
deleting associations and not accessible through the Umbrello interface.
However, they are presented in the XMI file. This patch offers a primitive
workaround for this problem, too, by ignoring such associations during export.