Author: tv
Date: Fri Apr 8 08:09:38 2016
New Revision: 1738219
URL: http://svn.apache.org/viewvc?rev=1738219&view=rev
Log:
Fix foreign key references for Derby
Modified:
db/torque/torque4/trunk/torque-templates/src/main/resources/org/apache/torque/templates/sql/templates/ddl/derby/foreignKey.groovy
db/torque/torque4/trunk/torque-templates/src/main/resources/org/apache/torque/templates/sql/templates/ddl/derby/foreignKey.vm
Modified:
db/torque/torque4/trunk/torque-templates/src/main/resources/org/apache/torque/templates/sql/templates/ddl/derby/foreignKey.groovy
URL:
http://svn.apache.org/viewvc/db/torque/torque4/trunk/torque-templates/src/main/resources/org/apache/torque/templates/sql/templates/ddl/derby/foreignKey.groovy?rev=1738219&r1=1738218&r2=1738219&view=diff
==============================================================================
---
db/torque/torque4/trunk/torque-templates/src/main/resources/org/apache/torque/templates/sql/templates/ddl/derby/foreignKey.groovy
(original)
+++
db/torque/torque4/trunk/torque-templates/src/main/resources/org/apache/torque/templates/sql/templates/ddl/derby/foreignKey.groovy
Fri Apr 8 08:09:38 2016
@@ -30,6 +30,11 @@ if (foreignKey.onUpdate == "setnull")
result += """
ON UPDATE SET NULL"""
}
+else if (foreignKey.onUpdate == "none")
+{
+ result += """
+ ON UPDATE NO ACTION"""
+}
else if (foreignKey.onUpdate)
{
result += """
@@ -41,6 +46,12 @@ if (foreignKey.onDelete == "setnull")
ON DELETE SET NULL"""
}
+else if (foreignKey.onDelete == "none")
+{
+ result += """
+
+ ON DELETE NO ACTION"""
+}
else if (foreignKey.onDelete)
{
result += """
Modified:
db/torque/torque4/trunk/torque-templates/src/main/resources/org/apache/torque/templates/sql/templates/ddl/derby/foreignKey.vm
URL:
http://svn.apache.org/viewvc/db/torque/torque4/trunk/torque-templates/src/main/resources/org/apache/torque/templates/sql/templates/ddl/derby/foreignKey.vm?rev=1738219&r1=1738218&r2=1738219&view=diff
==============================================================================
---
db/torque/torque4/trunk/torque-templates/src/main/resources/org/apache/torque/templates/sql/templates/ddl/derby/foreignKey.vm
(original)
+++
db/torque/torque4/trunk/torque-templates/src/main/resources/org/apache/torque/templates/sql/templates/ddl/derby/foreignKey.vm
Fri Apr 8 08:09:38 2016
@@ -21,6 +21,9 @@ ALTER TABLE $torqueGen.getParent().getAt
#if ($onUpdate == "setnull")
ON UPDATE SET NULL##
+#elseif ($onUpdate == "none")
+
+ ON UPDATE NO ACTION##
#elseif ($onUpdate)
ON UPDATE ${onUpdate.toUpperCase()}##
@@ -28,6 +31,9 @@ ALTER TABLE $torqueGen.getParent().getAt
#if ($onDelete == "setnull")
ON DELETE SET NULL##
+#elseif ($onDelete == "none")
+
+ ON DELETE NO ACTION##
#elseif ($onDelete)
ON DELETE ${onDelete.toUpperCase()}##
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
