taylor 2002/10/18 11:03:15
Modified: src/templates/sql/base/mssql db.props foreignkey.vm
Log:
- added support to mssql for on update and on delete
- 'binary' data type was failing on insert/updates, had to give it a size
Revision Changes Path
1.8 +1 -1 jakarta-turbine-torque/src/templates/sql/base/mssql/db.props
Index: db.props
===================================================================
RCS file: /home/cvs/jakarta-turbine-torque/src/templates/sql/base/mssql/db.props,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -r1.7 -r1.8
--- db.props 20 May 2002 17:55:15 -0000 1.7
+++ db.props 18 Oct 2002 18:03:15 -0000 1.8
@@ -14,7 +14,7 @@
DATE = DATETIME
TIME = DATETIME
TIMESTAMP = DATETIME
-BINARY = BINARY
+BINARY = BINARY(7132)
VARBINARY = IMAGE
LONGVARBINARY = IMAGE
NULL = NULL
1.3 +6 -0
jakarta-turbine-torque/src/templates/sql/base/mssql/foreignkey.vm
Index: foreignkey.vm
===================================================================
RCS file:
/home/cvs/jakarta-turbine-torque/src/templates/sql/base/mssql/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 18 Oct 2002 18:03:15 -0000 1.3
@@ -3,6 +3,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:turbine-torque-dev-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:turbine-torque-dev-help@;jakarta.apache.org>
