You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by ta...@apache.org on 2002/02/27 22:24:53 UTC
cvs commit: jakarta-jetspeed/build/torque/templates/sql/base/oracle db.props
taylor 02/02/27 13:24:53
Modified: build/torque/schema dbpsml-schema.xml
build/torque/templates/sql/base/oracle db.props
Log:
- Oracle's torque generation bugs fixed
Revision Changes Path
1.2 +4 -35 jakarta-jetspeed/build/torque/schema/dbpsml-schema.xml
Index: dbpsml-schema.xml
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/build/torque/schema/dbpsml-schema.xml,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- dbpsml-schema.xml 12 Nov 2001 03:33:38 -0000 1.1
+++ dbpsml-schema.xml 27 Feb 2002 21:24:53 -0000 1.2
@@ -25,7 +25,7 @@
<column name="LANGUAGE" size="2" type="VARCHAR"/>
<column name="COUNTRY" size="2" type="VARCHAR"/>
<column name="PAGE" size="99" type="VARCHAR"/>
- <column name="PROFILE" required="true" type="VARBINARY"/>
+ <column name="PROFILE" type="VARBINARY"/>
<unique name="JETSPEED_USER_PROFILE_UNIQUE">
<unique-column name="USER_NAME" />
@@ -35,14 +35,6 @@
<unique-column name="PAGE" />
</unique>
- <index name="JETSPEED_USER_PROFILE_INDEX">
- <index-column name="USER_NAME" />
- <index-column name="MEDIA_TYPE" />
- <index-column name="LANGUAGE" />
- <index-column name="COUNTRY" />
- <index-column name="PAGE" />
- </index>
-
</table>
<table name="JETSPEED_GROUP_PROFILE" idMethod="idbroker" >
@@ -54,7 +46,7 @@
<column name="LANGUAGE" size="2" type="VARCHAR"/>
<column name="COUNTRY" size="2" type="VARCHAR"/>
<column name="PAGE" size="99" type="VARCHAR"/>
- <column name="PROFILE" required="true" type="VARBINARY"/>
+ <column name="PROFILE" type="VARBINARY"/>
<unique name="JETSPEED_GROUP_PROFILE_UNIQUE">
<unique-column name="GROUP_NAME" />
@@ -64,14 +56,6 @@
<unique-column name="PAGE" />
</unique>
- <index name="JETSPEED_GROUP_PROFILE_INDEX">
- <index-column name="GROUP_NAME" />
- <index-column name="MEDIA_TYPE" />
- <index-column name="LANGUAGE" />
- <index-column name="COUNTRY" />
- <index-column name="PAGE" />
- </index>
-
</table>
<table name="JETSPEED_ROLE_PROFILE" idMethod="idbroker" >
@@ -83,7 +67,7 @@
<column name="LANGUAGE" size="2" type="VARCHAR"/>
<column name="COUNTRY" size="2" type="VARCHAR"/>
<column name="PAGE" size="99" type="VARCHAR"/>
- <column name="PROFILE" required="true" type="VARBINARY"/>
+ <column name="PROFILE" type="VARBINARY"/>
<unique name="JETSPEED_ROLE_PROFILE_UNIQUE">
<unique-column name="ROLE_NAME" />
@@ -93,14 +77,6 @@
<unique-column name="PAGE" />
</unique>
- <index name="JETSPEED_ROLE_PROFILE_INDEX">
- <index-column name="ROLE_NAME" />
- <index-column name="MEDIA_TYPE" />
- <index-column name="LANGUAGE" />
- <index-column name="COUNTRY" />
- <index-column name="PAGE" />
- </index>
-
</table>
<table name="JETSPEED_ANON_PROFILE" idMethod="idbroker" >
@@ -111,7 +87,7 @@
<column name="LANGUAGE" size="2" type="VARCHAR"/>
<column name="COUNTRY" size="2" type="VARCHAR"/>
<column name="PAGE" size="99" type="VARCHAR"/>
- <column name="PROFILE" required="true" type="VARBINARY"/>
+ <column name="PROFILE" type="VARBINARY"/>
<unique name="JETSPEED_ANON_PROFILE_UNIQUE">
<unique-column name="MEDIA_TYPE" />
@@ -119,13 +95,6 @@
<unique-column name="COUNTRY" />
<unique-column name="PAGE" />
</unique>
-
- <index name="JETSPEED_ANON_PROFILE_INDEX">
- <index-column name="MEDIA_TYPE" />
- <index-column name="LANGUAGE" />
- <index-column name="COUNTRY" />
- <index-column name="PAGE" />
- </index>
</table>
1.2 +1 -1 jakarta-jetspeed/build/torque/templates/sql/base/oracle/db.props
Index: db.props
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/build/torque/templates/sql/base/oracle/db.props,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- db.props 12 Nov 2001 03:33:40 -0000 1.1
+++ db.props 27 Feb 2002 21:24:53 -0000 1.2
@@ -22,7 +22,7 @@
TIME = DATE
TIMESTAMP = DATE
BINARY = RAW
-VARBINARY = RAW
+VARBINARY = LONG RAW
LONGVARBINARY = LONG RAW
NULL =
OTHER =
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>