[ http://issues.apache.org/jira/browse/DDLUTILS-75?page=all ]
Guy Davis updated DDLUTILS-75:
------------------------------
Attachment: delete_cascade.patch
Patch supports ON DELETE cascade for foreign keys.
> Add support for "On Delete" and "On Update" in schema XML for foreign keys
> --------------------------------------------------------------------------
>
> Key: DDLUTILS-75
> URL: http://issues.apache.org/jira/browse/DDLUTILS-75
> Project: DdlUtils
> Type: Improvement
> Environment: Oracle 10g Express Edition
> Windows XP
> Java 1.5.0
> Ant 1.6.5
> Reporter: Guy Davis
> Assignee: Thomas Dudziak
> Priority: Critical
> Attachments: delete_cascade.patch
>
> Currently, when dumping the schema from a live database to XML, the 'on
> delete' and 'on update' rules for foreign keys are ignored. As shown in the
> DTD for database.dtd (below), the attributes onDelete and onUpdate should
> translate into "on delete cascade" for example in the target SQL.
> <!ELEMENT foreign-key (reference+)>
> <!ATTLIST foreign-key
> foreignTable CDATA #REQUIRED
> name CDATA #IMPLIED
> onUpdate (cascade|setnull|restrict|none) "none"
> onDelete (cascade|setnull|restrict|none) "none"
> >
>
> If the dump (DatabaseToDdl) is modified to write these attributes out, then
> the schema load (DdlToDatabase) needs to handle them and set the correct
> behavior on the foreign key creation.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
