mpoeschl 2002/10/26 03:10:13
Modified: src/templates/sql/base/oracle foreignkey.vm
Log:
TRQS20: "on delete cascade" not generated
Revision Changes Path
1.4 +4 -0
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.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- foreignkey.vm 15 Oct 2002 04:27:53 -0000 1.3
+++ foreignkey.vm 26 Oct 2002 10:10:13 -0000 1.4
@@ -2,6 +2,10 @@
ALTER TABLE $table.Name
ADD CONSTRAINT $fk.Name FOREIGN KEY ($fk.LocalColumnNames)
REFERENCES $fk.ForeignTableName ($fk.ForeignColumnNames)
+## Oracle only supports "on delete cascade"
+#if ($fk.hasOnDelete() && $fk.OnDelete.equalsIgnoreCase("cascade"))
+ ON DELETE $fk.OnDelete
+#end
#if ($fk.hasOnUpdate())
ON UPDATE $fk.OnUpdate
#end
--
To unsubscribe, e-mail: <mailto:turbine-torque-dev-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:turbine-torque-dev-help@;jakarta.apache.org>
