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 mp...@apache.org on 2003/05/22 21:36:54 UTC
cvs commit: db-torque/src/templates/sql/base/oracle foreignkey.vm
mpoeschl 2003/05/22 12:36:54
Modified: src/templates/sql/base/oracle Tag: TORQUE_3_0_BRANCH
foreignkey.vm
Log:
oracle does not support ON UPDATE CASCADE
Revision Changes Path
No revision
No revision
1.5.2.1 +1 -1 db-torque/src/templates/sql/base/oracle/Attic/foreignkey.vm
Index: foreignkey.vm
===================================================================
RCS file: /home/cvs/db-torque/src/templates/sql/base/oracle/Attic/foreignkey.vm,v
retrieving revision 1.5
retrieving revision 1.5.2.1
diff -u -r1.5 -r1.5.2.1
--- foreignkey.vm 26 Oct 2002 10:13:28 -0000 1.5
+++ foreignkey.vm 22 May 2003 19:36:54 -0000 1.5.2.1
@@ -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())