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())
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
