You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-dev@db.apache.org by jm...@apache.org on 2002/12/09 06:46:07 UTC
cvs commit: jakarta-turbine-torque/src/templates/sql/base/oracle foreignkey.vm
jmcnally 2002/12/08 21:46:07
Modified: src/templates/sql/base/oracle foreignkey.vm
Log:
oracle does not support ON UPDATE CASCADE
Revision Changes Path
1.6 +1 -1 jakarta-turbine-torque/src/templates/sql/base/oracle/foreignkey.vm
Index: foreignkey.vm
===================================================================
RCS file: /home/cvs/jakarta-turbine-torque/src/templates/sql/base/oracle/foreignkey.vm,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -r1.5 -r1.6
--- foreignkey.vm 26 Oct 2002 10:13:28 -0000 1.5
+++ foreignkey.vm 9 Dec 2002 05:46:07 -0000 1.6
@@ -2,7 +2,7 @@
ALTER TABLE $table.Name
ADD CONSTRAINT $fk.Name FOREIGN KEY ($fk.LocalColumnNames)
REFERENCES $fk.ForeignTableName ($fk.ForeignColumnNames)
-#if ($fk.hasOnUpdate())
+#if ($fk.hasOnUpdate() && !$fk.OnUpdate.equalsIgnoreCase("cascade"))
ON UPDATE $fk.OnUpdate
#end
#if ($fk.hasOnDelete())