dobbs 02/05/06 16:49:31
Modified: src/templates/sql/base/sapdb db.props drop.vm foreignkey.vm
primarykey.vm
Log:
Applying patch from Zsombor Gegesy <deepspaceATmailbox.hu>
Revision Changes Path
1.3 +3 -3 jakarta-turbine-torque/src/templates/sql/base/sapdb/db.props
Index: db.props
===================================================================
RCS file: /home/cvs/jakarta-turbine-torque/src/templates/sql/base/sapdb/db.props,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- db.props 6 May 2002 17:07:01 -0000 1.2
+++ db.props 6 May 2002 23:49:31 -0000 1.3
@@ -11,9 +11,9 @@
DOUBLE =
NUMERIC =
DECIMAL =
-CHAR = VARCHAR2
-VARCHAR = VARCHAR2
-LONGVARCHAR = VARCHAR2
+CHAR = CHAR
+VARCHAR = VARCHAR
+LONGVARCHAR = LONG VARCHAR
DATE = DATE
TIME =
TIMESTAMP = DATE
1.2 +1 -1 jakarta-turbine-torque/src/templates/sql/base/sapdb/drop.vm
Index: drop.vm
===================================================================
RCS file: /home/cvs/jakarta-turbine-torque/src/templates/sql/base/sapdb/drop.vm,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- drop.vm 2 Aug 2001 05:08:40 -0000 1.1
+++ drop.vm 6 May 2002 23:49:31 -0000 1.2
@@ -1,4 +1,4 @@
-drop table $table.Name cascade constraints;
+drop table $table.Name cascade ;
#if ($table.IdMethod == "native")
drop sequence $table.SequenceName;
#end
1.3 +2 -2
jakarta-turbine-torque/src/templates/sql/base/sapdb/foreignkey.vm
Index: foreignkey.vm
===================================================================
RCS file:
/home/cvs/jakarta-turbine-torque/src/templates/sql/base/sapdb/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 6 May 2002 23:49:31 -0000 1.3
@@ -1,7 +1,7 @@
#foreach ($fk in $table.ForeignKeys)
ALTER TABLE $table.Name
- ADD CONSTRAINT $fk.Name FOREIGN KEY ($fk.LocalColumnNames)
- REFERENCES $fk.ForeignTableName ($fk.ForeignColumnNames)
+ FOREIGN KEY $fk.Name ($fk.LocalColumnNames)
+ REFERENCES $fk.ForeignTableName ("$fk.ForeignColumnNames")
;
#end
1.2 +1 -2
jakarta-turbine-torque/src/templates/sql/base/sapdb/primarykey.vm
Index: primarykey.vm
===================================================================
RCS file:
/home/cvs/jakarta-turbine-torque/src/templates/sql/base/sapdb/primarykey.vm,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- primarykey.vm 2 Aug 2001 05:08:40 -0000 1.1
+++ primarykey.vm 6 May 2002 23:49:31 -0000 1.2
@@ -1,3 +1,2 @@
ALTER TABLE $table.Name
- ADD CONSTRAINT ${table.Name}_PK
-PRIMARY KEY ($table.printPrimaryKey());
+ ADD PRIMARY KEY ("$table.printPrimaryKey()") ;
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
