Author: tfischer
Date: Sun Jan 27 21:48:53 2013
New Revision: 1439195
URL: http://svn.apache.org/viewvc?rev=1439195&view=rev
Log:
TORQUE-262 map onUpdate="restrict" and onDelete="restrict" to NO ACTION
Modified:
db/torque/torque4/trunk/torque-templates/src/main/resources/org/apache/torque/templates/sql/templates/ddl/mssql/foreignKey.vm
Modified:
db/torque/torque4/trunk/torque-templates/src/main/resources/org/apache/torque/templates/sql/templates/ddl/mssql/foreignKey.vm
URL:
http://svn.apache.org/viewvc/db/torque/torque4/trunk/torque-templates/src/main/resources/org/apache/torque/templates/sql/templates/ddl/mssql/foreignKey.vm?rev=1439195&r1=1439194&r2=1439195&view=diff
==============================================================================
---
db/torque/torque4/trunk/torque-templates/src/main/resources/org/apache/torque/templates/sql/templates/ddl/mssql/foreignKey.vm
(original)
+++
db/torque/torque4/trunk/torque-templates/src/main/resources/org/apache/torque/templates/sql/templates/ddl/mssql/foreignKey.vm
Sun Jan 27 21:48:53 2013
@@ -23,6 +23,9 @@ ALTER TABLE $tableName
#if ($onUpdate == "setnull")
ON UPDATE SET NULL##
+#elseif ($onUpdate == "restrict")
+
+ ON UPDATE NO ACTION##
#elseif ($onUpdate)
ON UPDATE ${onUpdate.toUpperCase()}##
@@ -30,10 +33,14 @@ ALTER TABLE $tableName
#if ($onDelete == "setnull")
ON DELETE SET NULL##
+#elseif ($onDelete == "restrict")
+
+ ON DELETE NO ACTION##
#elseif ($onDelete)
ON DELETE ${onDelete.toUpperCase()}##
#end
+
END
;
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
