portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tay...@apache.org
Subject cvs commit: jakarta-jetspeed/build/torque/templates/sql/base/oracle db.props
Date Wed, 27 Feb 2002 21:24:53 GMT
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:   <mailto:jetspeed-dev-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:jetspeed-dev-help@jakarta.apache.org>


Mime
View raw message