taylor 2002/10/14 21:27:53
Modified: src/templates/sql/base/oracle foreignkey.vm
Log:
Partial fix to TRQS20: ON UPDATE and ON DELETE constraints are now properly
generated for Oracle.
Have yet to test with mySQL or other DBs
Revision Changes Path
1.3 +6 -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.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- foreignkey.vm 22 Aug 2001 20:14:15 -0000 1.2
+++ foreignkey.vm 15 Oct 2002 04:27:53 -0000 1.3
@@ -2,6 +2,12 @@
ALTER TABLE $table.Name
ADD CONSTRAINT $fk.Name FOREIGN KEY ($fk.LocalColumnNames)
REFERENCES $fk.ForeignTableName ($fk.ForeignColumnNames)
+#if ($fk.hasOnUpdate())
+ON UPDATE $fk.OnUpdate
+#end
+#if ($fk.hasOnDelete())
+ON DELETE $fk.OnDelete
+#end
;
#end
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
