db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Guy Davis (JIRA)" <j...@apache.org>
Subject [jira] Created: (DDLUTILS-75) Add support for "On Delete" and "On Update" in schema XML for foreign keys
Date Wed, 22 Feb 2006 03:08:40 GMT
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
 Assigned to: Thomas Dudziak 
    Priority: Critical


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


Mime
View raw message