You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ofbiz.apache.org by jo...@apache.org on 2008/06/08 22:12:34 UTC
svn commit: r664547 - in /ofbiz/trunk/framework: entity/fieldtype/
shark/entitydef/
Author: jonesde
Date: Sun Jun 8 13:12:34 2008
New Revision: 664547
URL: http://svn.apache.org/viewvc?rev=664547&view=rev
Log:
Removed the highly redundant field type long which was 19 digits, and changed the existing field type numeric to be 20 digits, which is bigger than 19 so should be fine; updated the shark entity defs to use numeric instead of long
Modified:
ofbiz/trunk/framework/entity/fieldtype/fieldtypeadvantage.xml
ofbiz/trunk/framework/entity/fieldtype/fieldtypeaxion.xml
ofbiz/trunk/framework/entity/fieldtype/fieldtypecloudscape.xml
ofbiz/trunk/framework/entity/fieldtype/fieldtypedaffodil.xml
ofbiz/trunk/framework/entity/fieldtype/fieldtypederby.xml
ofbiz/trunk/framework/entity/fieldtype/fieldtypefirebird.xml
ofbiz/trunk/framework/entity/fieldtype/fieldtypehsql.xml
ofbiz/trunk/framework/entity/fieldtype/fieldtypemssql.xml
ofbiz/trunk/framework/entity/fieldtype/fieldtypemysql.xml
ofbiz/trunk/framework/entity/fieldtype/fieldtypeoracle.xml
ofbiz/trunk/framework/entity/fieldtype/fieldtypepostgres.xml
ofbiz/trunk/framework/entity/fieldtype/fieldtypesapdb.xml
ofbiz/trunk/framework/entity/fieldtype/fieldtypesybase.xml
ofbiz/trunk/framework/shark/entitydef/entitymodel.xml
Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypeadvantage.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypeadvantage.xml?rev=664547&r1=664546&r2=664547&view=diff
==============================================================================
--- ofbiz/trunk/framework/entity/fieldtype/fieldtypeadvantage.xml (original)
+++ ofbiz/trunk/framework/entity/fieldtype/fieldtypeadvantage.xml Sun Jun 8 13:12:34 2008
@@ -30,7 +30,6 @@
<field-type-def type="date-time" sql-type="TimeStamp" java-type="java.sql.Timestamp"></field-type-def>
<field-type-def type="date" sql-type="Date" java-type="java.sql.Date"></field-type-def>
<field-type-def type="time" sql-type="Time" java-type="java.sql.Time"></field-type-def>
- <field-type-def type="long" sql-type="Integer" java-type="java.lang.Long"><validate method="isSignedLong" /></field-type-def>
<field-type-def type="currency-amount" sql-type="Money" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
<field-type-def type="currency-precise" sql-type="Double" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypeaxion.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypeaxion.xml?rev=664547&r1=664546&r2=664547&view=diff
==============================================================================
--- ofbiz/trunk/framework/entity/fieldtype/fieldtypeaxion.xml (original)
+++ ofbiz/trunk/framework/entity/fieldtype/fieldtypeaxion.xml Sun Jun 8 13:12:34 2008
@@ -27,12 +27,11 @@
<field-type-def type="date-time" sql-type="TIMESTAMP" java-type="java.sql.Timestamp"></field-type-def>
<field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"></field-type-def>
<field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"></field-type-def>
- <field-type-def type="long" sql-type="NUMBER(19,0)" java-type="java.lang.Long"><validate method="isSignedLong" /></field-type-def>
<field-type-def type="currency-amount" sql-type="NUMBER(18,2)" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
<field-type-def type="currency-precise" sql-type="NUMBER(18,3)" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
<field-type-def type="floating-point" sql-type="FLOAT" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
- <field-type-def type="numeric" sql-type="NUMBER(18,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
+ <field-type-def type="numeric" sql-type="NUMBER(20,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
<field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"></field-type-def>
<field-type-def type="id-long" sql-type="VARCHAR(60)" java-type="String"></field-type-def>
Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypecloudscape.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypecloudscape.xml?rev=664547&r1=664546&r2=664547&view=diff
==============================================================================
--- ofbiz/trunk/framework/entity/fieldtype/fieldtypecloudscape.xml (original)
+++ ofbiz/trunk/framework/entity/fieldtype/fieldtypecloudscape.xml Sun Jun 8 13:12:34 2008
@@ -27,12 +27,11 @@
<field-type-def type="date-time" sql-type="DATE" java-type="java.sql.Timestamp"></field-type-def>
<field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"></field-type-def>
<field-type-def type="time" sql-type="DATE" java-type="java.sql.Time"></field-type-def>
- <field-type-def type="long" sql-type="NUMERIC(19,0)" java-type="java.lang.Long"><validate method="isSignedLong" /></field-type-def>
<field-type-def type="currency-amount" sql-type="NUMERIC(18,2)" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
<field-type-def type="currency-precise" sql-type="NUMERIC(18,3)" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
<field-type-def type="floating-point" sql-type="NUMERIC(18,6)" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
- <field-type-def type="numeric" sql-type="NUMERIC(18,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
+ <field-type-def type="numeric" sql-type="NUMERIC(20,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
<field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"></field-type-def>
<field-type-def type="id-long" sql-type="VARCHAR(60)" java-type="String"></field-type-def>
Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypedaffodil.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypedaffodil.xml?rev=664547&r1=664546&r2=664547&view=diff
==============================================================================
--- ofbiz/trunk/framework/entity/fieldtype/fieldtypedaffodil.xml (original)
+++ ofbiz/trunk/framework/entity/fieldtype/fieldtypedaffodil.xml Sun Jun 8 13:12:34 2008
@@ -27,12 +27,11 @@
<field-type-def type="date-time" sql-type="TIMESTAMP" java-type="java.sql.Timestamp"></field-type-def>
<field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"></field-type-def>
<field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"></field-type-def>
- <field-type-def type="long" sql-type="NUMBER(19,0)" java-type="java.lang.Long"><validate method="isSignedLong" /></field-type-def>
<field-type-def type="currency-amount" sql-type="NUMBER(18,2)" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
<field-type-def type="currency-precise" sql-type="NUMBER(18,3)" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
<field-type-def type="floating-point" sql-type="NUMBER(18,6)" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
- <field-type-def type="numeric" sql-type="NUMBER(18,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
+ <field-type-def type="numeric" sql-type="NUMBER(20,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
<field-type-def type="id" sql-type="VARCHAR2(20)" java-type="String"></field-type-def>
<field-type-def type="id-long" sql-type="VARCHAR2(60)" java-type="String"></field-type-def>
Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypederby.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypederby.xml?rev=664547&r1=664546&r2=664547&view=diff
==============================================================================
--- ofbiz/trunk/framework/entity/fieldtype/fieldtypederby.xml (original)
+++ ofbiz/trunk/framework/entity/fieldtype/fieldtypederby.xml Sun Jun 8 13:12:34 2008
@@ -27,13 +27,11 @@
<field-type-def type="date-time" sql-type="TIMESTAMP" java-type="java.sql.Timestamp"></field-type-def>
<field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"></field-type-def>
<field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"></field-type-def>
- <field-type-def type="long" sql-type="NUMERIC(19,0)" java-type="java.lang.Long"><validate method="isSignedLong" /></field-type-def>
- <!-- <field-type-def type="long" sql-type="BIGINT" java-type="java.lang.Long"></field-type-def> -->
<field-type-def type="currency-amount" sql-type="NUMERIC(18,2)" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
<field-type-def type="currency-precise" sql-type="NUMERIC(18,3)" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
<field-type-def type="floating-point" sql-type="DOUBLE" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
- <field-type-def type="numeric" sql-type="NUMERIC(18,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
+ <field-type-def type="numeric" sql-type="NUMERIC(20,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
<field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"></field-type-def>
<field-type-def type="id-long" sql-type="VARCHAR(60)" java-type="String"></field-type-def>
Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypefirebird.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypefirebird.xml?rev=664547&r1=664546&r2=664547&view=diff
==============================================================================
--- ofbiz/trunk/framework/entity/fieldtype/fieldtypefirebird.xml (original)
+++ ofbiz/trunk/framework/entity/fieldtype/fieldtypefirebird.xml Sun Jun 8 13:12:34 2008
@@ -28,12 +28,11 @@
<field-type-def type="date-time" sql-type="TIMESTAMP" java-type="java.sql.Timestamp"></field-type-def>
<field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"></field-type-def>
<field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"></field-type-def>
- <field-type-def type="long" sql-type="NUMERIC(19,0)" java-type="java.lang.Long"><validate method="isSignedLong" /></field-type-def>
<field-type-def type="currency-amount" sql-type="NUMERIC(18,2)" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
<field-type-def type="currency-precise" sql-type="NUMERIC(18,3)" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
<field-type-def type="floating-point" sql-type="FLOAT" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
- <field-type-def type="numeric" sql-type="NUMERIC(18,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
+ <field-type-def type="numeric" sql-type="NUMERIC(20,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
<field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"></field-type-def>
<field-type-def type="id-long" sql-type="VARCHAR(60)" java-type="String"></field-type-def>
Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypehsql.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypehsql.xml?rev=664547&r1=664546&r2=664547&view=diff
==============================================================================
--- ofbiz/trunk/framework/entity/fieldtype/fieldtypehsql.xml (original)
+++ ofbiz/trunk/framework/entity/fieldtype/fieldtypehsql.xml Sun Jun 8 13:12:34 2008
@@ -27,7 +27,6 @@
<field-type-def type="date-time" sql-type="TIMESTAMP" java-type="java.sql.Timestamp"></field-type-def>
<field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"></field-type-def>
<field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"></field-type-def>
- <field-type-def type="long" sql-type="BIGINT" java-type="java.lang.Long"><validate method="isSignedLong" /></field-type-def>
<field-type-def type="currency-amount" sql-type="DOUBLE" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
<field-type-def type="currency-precise" sql-type="DOUBLE" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypemssql.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypemssql.xml?rev=664547&r1=664546&r2=664547&view=diff
==============================================================================
--- ofbiz/trunk/framework/entity/fieldtype/fieldtypemssql.xml (original)
+++ ofbiz/trunk/framework/entity/fieldtype/fieldtypemssql.xml Sun Jun 8 13:12:34 2008
@@ -27,7 +27,6 @@
<field-type-def type="date-time" sql-type="DATETIME" java-type="java.sql.Timestamp"></field-type-def>
<field-type-def type="date" sql-type="DATETIME" java-type="java.sql.Date"></field-type-def>
<field-type-def type="time" sql-type="DATETIME" java-type="java.sql.Time"></field-type-def>
- <field-type-def type="long" sql-type="INT" java-type="java.lang.Long"><validate method="isSignedLong" /></field-type-def>
<field-type-def type="currency-amount" sql-type="DECIMAL(18,2)" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
<field-type-def type="currency-precise" sql-type="DECIMAL(18,3)" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypemysql.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypemysql.xml?rev=664547&r1=664546&r2=664547&view=diff
==============================================================================
--- ofbiz/trunk/framework/entity/fieldtype/fieldtypemysql.xml (original)
+++ ofbiz/trunk/framework/entity/fieldtype/fieldtypemysql.xml Sun Jun 8 13:12:34 2008
@@ -27,12 +27,11 @@
<field-type-def type="date-time" sql-type="DATETIME" java-type="java.sql.Timestamp"></field-type-def>
<field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"></field-type-def>
<field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"></field-type-def>
- <field-type-def type="long" sql-type="DECIMAL(19,0)" java-type="java.lang.Long"><validate method="isSignedLong" /></field-type-def>
<field-type-def type="currency-amount" sql-type="DECIMAL(18,2)" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
<field-type-def type="currency-precise" sql-type="DECIMAL(18,3)" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
<field-type-def type="floating-point" sql-type="DECIMAL(18,6)" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
- <field-type-def type="numeric" sql-type="DECIMAL(18,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
+ <field-type-def type="numeric" sql-type="DECIMAL(20,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
<field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"></field-type-def>
<field-type-def type="id-long" sql-type="VARCHAR(60)" java-type="String"></field-type-def>
Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypeoracle.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypeoracle.xml?rev=664547&r1=664546&r2=664547&view=diff
==============================================================================
--- ofbiz/trunk/framework/entity/fieldtype/fieldtypeoracle.xml (original)
+++ ofbiz/trunk/framework/entity/fieldtype/fieldtypeoracle.xml Sun Jun 8 13:12:34 2008
@@ -27,12 +27,11 @@
<field-type-def type="date-time" sql-type="TIMESTAMP" sql-type-alias="TIMESTAMP(6)" java-type="java.sql.Timestamp"></field-type-def>
<field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"></field-type-def>
<field-type-def type="time" sql-type="DATE" java-type="java.sql.Time"></field-type-def>
- <field-type-def type="long" sql-type="NUMBER(19,0)" java-type="java.lang.Long"><validate method="isSignedLong" /></field-type-def>
<field-type-def type="currency-amount" sql-type="NUMBER(18,2)" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
<field-type-def type="currency-precise" sql-type="NUMBER(18,3)" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
<field-type-def type="floating-point" sql-type="NUMBER(18,6)" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
- <field-type-def type="numeric" sql-type="NUMBER(18,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
+ <field-type-def type="numeric" sql-type="NUMBER(20,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
<field-type-def type="id" sql-type="VARCHAR2(20)" java-type="String"></field-type-def>
<field-type-def type="id-long" sql-type="VARCHAR2(60)" java-type="String"></field-type-def>
Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypepostgres.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypepostgres.xml?rev=664547&r1=664546&r2=664547&view=diff
==============================================================================
--- ofbiz/trunk/framework/entity/fieldtype/fieldtypepostgres.xml (original)
+++ ofbiz/trunk/framework/entity/fieldtype/fieldtypepostgres.xml Sun Jun 8 13:12:34 2008
@@ -27,12 +27,11 @@
<field-type-def type="date-time" sql-type="TIMESTAMPTZ" java-type="java.sql.Timestamp"></field-type-def>
<field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"></field-type-def>
<field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"></field-type-def>
- <field-type-def type="long" sql-type="NUMERIC(19,0)" java-type="java.lang.Long"><validate method="isSignedLong" /></field-type-def>
<field-type-def type="currency-amount" sql-type="NUMERIC(18,2)" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
<field-type-def type="currency-precise" sql-type="NUMERIC(18,3)" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
<field-type-def type="floating-point" sql-type="FLOAT8" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
- <field-type-def type="numeric" sql-type="NUMERIC(18,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
+ <field-type-def type="numeric" sql-type="NUMERIC(20,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
<field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"></field-type-def>
<field-type-def type="id-long" sql-type="VARCHAR(60)" java-type="String"></field-type-def>
Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypesapdb.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypesapdb.xml?rev=664547&r1=664546&r2=664547&view=diff
==============================================================================
--- ofbiz/trunk/framework/entity/fieldtype/fieldtypesapdb.xml (original)
+++ ofbiz/trunk/framework/entity/fieldtype/fieldtypesapdb.xml Sun Jun 8 13:12:34 2008
@@ -27,12 +27,11 @@
<field-type-def type="date-time" sql-type="TIMESTAMP" java-type="java.sql.Timestamp"></field-type-def>
<field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"></field-type-def>
<field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"></field-type-def>
- <field-type-def type="long" sql-type="FIXED(19,0)" java-type="java.lang.Long"><validate method="isSignedLong" /></field-type-def>
<field-type-def type="currency-amount" sql-type="FIXED(18,2)" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
<field-type-def type="currency-precise" sql-type="FIXED(18,3)" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
<field-type-def type="floating-point" sql-type="FIXED(18,6)" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
- <field-type-def type="numeric" sql-type="FIXED(18,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
+ <field-type-def type="numeric" sql-type="FIXED(20,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
<field-type-def type="id" sql-type="VARCHAR(20) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"></field-type-def>
<field-type-def type="id-long" sql-type="VARCHAR(60) UNICODE" sql-type-alias="VARCHAR() UNICODE" java-type="String"></field-type-def>
Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypesybase.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypesybase.xml?rev=664547&r1=664546&r2=664547&view=diff
==============================================================================
--- ofbiz/trunk/framework/entity/fieldtype/fieldtypesybase.xml (original)
+++ ofbiz/trunk/framework/entity/fieldtype/fieldtypesybase.xml Sun Jun 8 13:12:34 2008
@@ -27,12 +27,11 @@
<field-type-def type="date-time" sql-type="DATETIME" java-type="Timestamp"></field-type-def>
<field-type-def type="date" sql-type="DATETIME" java-type="java.sql.Date"></field-type-def>
<field-type-def type="time" sql-type="DATETIME" java-type="java.sql.Time"></field-type-def>
- <field-type-def type="long" sql-type="NUMERIC(19,0)" java-type="java.lang.Long"><validate method="isSignedLong" /></field-type-def>
<field-type-def type="currency-amount" sql-type="NUMERIC(18,2)" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
<field-type-def type="currency-precise" sql-type="NUMERIC(18,3)" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
<field-type-def type="floating-point" sql-type="NUMERIC(18,6)" java-type="Double"><validate method="isSignedDouble" /></field-type-def>
- <field-type-def type="numeric" sql-type="NUMERIC(18,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
+ <field-type-def type="numeric" sql-type="NUMERIC(20,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
<field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"></field-type-def>
<field-type-def type="id-long" sql-type="VARCHAR(60)" java-type="String"></field-type-def>
Modified: ofbiz/trunk/framework/shark/entitydef/entitymodel.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/shark/entitydef/entitymodel.xml?rev=664547&r1=664546&r2=664547&view=diff
==============================================================================
--- ofbiz/trunk/framework/shark/entitydef/entitymodel.xml (original)
+++ ofbiz/trunk/framework/shark/entitydef/entitymodel.xml Sun Jun 8 13:12:34 2008
@@ -150,12 +150,12 @@
<field name="activityName" type="long-varchar"></field>
<field name="description" type="long-varchar"></field>
<field name="currentState" type="long-varchar"></field>
- <field name="priority" type="long"></field>
+ <field name="priority" type="numeric"></field>
<field name="accepted" type="indicator"></field>
- <field name="timeLimit" type="long"></field>
- <field name="activatedTime" type="long"></field>
- <field name="acceptedTime" type="long"></field>
- <field name="lastStateTime" type="long"></field>
+ <field name="timeLimit" type="numeric"></field>
+ <field name="activatedTime" type="numeric"></field>
+ <field name="acceptedTime" type="numeric"></field>
+ <field name="lastStateTime" type="numeric"></field>
<prim-key field="activityId"/>
<relation type="one" fk-name="WF_ACT_PROC" rel-entity-name="WfProcess">
<key-map field-name="processId"/>
@@ -173,7 +173,7 @@
<field name="definitionId" type="long-varchar"></field>
<field name="valueField" type="name"></field>
<field name="strValue" type="long-varchar"></field>
- <field name="numValue" type="long"></field>
+ <field name="numValue" type="numeric"></field>
<field name="dblValue" type="floating-point"></field>
<field name="objValue" type="blob"></field>
<field name="isModified" type="indicator"></field>
@@ -217,7 +217,7 @@
<field name="processId" type="long-varchar"></field>
<field name="activityId" type="long-varchar"></field>
<field name="exceptionName" type="long-varchar"></field>
- <field name="timeLimit" type="long"></field>
+ <field name="timeLimit" type="numeric"></field>
<field name="isExecuted" type="indicator"></field>
<field name="isSync" type="indicator"></field>
<prim-key field="deadlineId"/>
@@ -239,15 +239,15 @@
<field name="activityReqProcessId" type="long-varchar"></field>
<field name="activityReqId" type="long-varchar"></field>
<field name="resourceReqId" type="long-varchar"></field>
- <field name="timeLimit" type="long"></field>
+ <field name="timeLimit" type="numeric"></field>
<field name="processName" type="long-varchar"></field>
<field name="description" type="long-varchar"></field>
<field name="currentState" type="long-varchar"></field>
- <field name="priority" type="long"></field>
+ <field name="priority" type="numeric"></field>
<field name="externalReq" type="blob"></field>
- <field name="createdTime" type="long"></field>
- <field name="startedTime" type="long"></field>
- <field name="lastStateTime" type="long"></field>
+ <field name="createdTime" type="numeric"></field>
+ <field name="startedTime" type="numeric"></field>
+ <field name="lastStateTime" type="numeric"></field>
<field name="ExternalRequesterClassName" type="long-varchar"></field>
<prim-key field="processId"/>
<relation type="one" fk-name="WF_PROC_MGR" rel-entity-name="WfProcessMgr">
@@ -261,8 +261,8 @@
<field name="packageId" type="long-varchar"></field>
<field name="packageVer" type="long-varchar"></field>
<field name="definitionId" type="long-varchar"></field>
- <field name="created" type="long"></field>
- <field name="currentState" type="long"></field>
+ <field name="created" type="numeric"></field>
+ <field name="currentState" type="numeric"></field>
<prim-key field="mgrName"/>
</entity>
<entity entity-name="WfProcessVariable"
@@ -273,7 +273,7 @@
<field name="definitionId" type="long-varchar"></field>
<field name="valueField" type="name"></field>
<field name="strValue" type="long-varchar"></field>
- <field name="numValue" type="long"></field>
+ <field name="numValue" type="numeric"></field>
<field name="dblValue" type="floating-point"></field>
<field name="objValue" type="blob"></field>
<prim-key field="processVariableId"/>
@@ -299,7 +299,7 @@
<field name="userName" type="long-varchar"></field>
<field name="passwd" type="long-varchar"></field>
<field name="applicationName" type="long-varchar"></field>
- <field name="applicationMode" type="long"></field>
+ <field name="applicationMode" type="numeric"></field>
<prim-key field="packageId"/>
<prim-key field="processDefId"/>
<prim-key field="applicationDefId"/>
@@ -351,8 +351,8 @@
title="">
<field name="requesterId" type="long-varchar"></field>
<field name="processId" type="long-varchar"></field>
- <field name="fromDate" type="long"></field>
- <field name="thruDate" type="long"></field>
+ <field name="fromDate" type="numeric"></field>
+ <field name="thruDate" type="numeric"></field>
<field name="className" type="long-varchar"></field>
<field name="classData" type="long-varchar"></field>
<prim-key field="requesterId"/>
Re: svn commit: r664547 - in /ofbiz/trunk/framework: entity/fieldtype/ shark/entitydef/
Posted by Jacques Le Roux <ja...@les7arts.com>.
Thanks David,
I see the point, happy that 20 is ok (should be enough, else we will just have to increase I guess)
Jacques
> Author: jonesde
> Date: Sun Jun 8 13:12:34 2008
> New Revision: 664547
>
> URL: http://svn.apache.org/viewvc?rev=664547&view=rev
> Log:
> Removed the highly redundant field type long which was 19 digits, and changed the existing field type numeric to be 20 digits,
> which is bigger than 19 so should be fine; updated the shark entity defs to use numeric instead of long
>
> Modified:
> ofbiz/trunk/framework/entity/fieldtype/fieldtypeadvantage.xml
> ofbiz/trunk/framework/entity/fieldtype/fieldtypeaxion.xml
> ofbiz/trunk/framework/entity/fieldtype/fieldtypecloudscape.xml
> ofbiz/trunk/framework/entity/fieldtype/fieldtypedaffodil.xml
> ofbiz/trunk/framework/entity/fieldtype/fieldtypederby.xml
> ofbiz/trunk/framework/entity/fieldtype/fieldtypefirebird.xml
> ofbiz/trunk/framework/entity/fieldtype/fieldtypehsql.xml
> ofbiz/trunk/framework/entity/fieldtype/fieldtypemssql.xml
> ofbiz/trunk/framework/entity/fieldtype/fieldtypemysql.xml
> ofbiz/trunk/framework/entity/fieldtype/fieldtypeoracle.xml
> ofbiz/trunk/framework/entity/fieldtype/fieldtypepostgres.xml
> ofbiz/trunk/framework/entity/fieldtype/fieldtypesapdb.xml
> ofbiz/trunk/framework/entity/fieldtype/fieldtypesybase.xml
> ofbiz/trunk/framework/shark/entitydef/entitymodel.xml
>
> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypeadvantage.xml
> URL:
> http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypeadvantage.xml?rev=664547&r1=664546&r2=664547&view=diff
> ==============================================================================
> --- ofbiz/trunk/framework/entity/fieldtype/fieldtypeadvantage.xml (original)
> +++ ofbiz/trunk/framework/entity/fieldtype/fieldtypeadvantage.xml Sun Jun 8 13:12:34 2008
> @@ -30,7 +30,6 @@
> <field-type-def type="date-time" sql-type="TimeStamp" java-type="java.sql.Timestamp"></field-type-def>
> <field-type-def type="date" sql-type="Date" java-type="java.sql.Date"></field-type-def>
> <field-type-def type="time" sql-type="Time" java-type="java.sql.Time"></field-type-def>
> - <field-type-def type="long" sql-type="Integer" java-type="java.lang.Long"><validate method="isSignedLong" /></field-type-def>
>
> <field-type-def type="currency-amount" sql-type="Money" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> <field-type-def type="currency-precise" sql-type="Double" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
>
> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypeaxion.xml
> URL:
> http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypeaxion.xml?rev=664547&r1=664546&r2=664547&view=diff
> ==============================================================================
> --- ofbiz/trunk/framework/entity/fieldtype/fieldtypeaxion.xml (original)
> +++ ofbiz/trunk/framework/entity/fieldtype/fieldtypeaxion.xml Sun Jun 8 13:12:34 2008
> @@ -27,12 +27,11 @@
> <field-type-def type="date-time" sql-type="TIMESTAMP" java-type="java.sql.Timestamp"></field-type-def>
> <field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"></field-type-def>
> <field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"></field-type-def>
> - <field-type-def type="long" sql-type="NUMBER(19,0)" java-type="java.lang.Long"><validate method="isSignedLong"
> /></field-type-def>
>
> <field-type-def type="currency-amount" sql-type="NUMBER(18,2)" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> <field-type-def type="currency-precise" sql-type="NUMBER(18,3)" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> <field-type-def type="floating-point" sql-type="FLOAT" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> - <field-type-def type="numeric" sql-type="NUMBER(18,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
> + <field-type-def type="numeric" sql-type="NUMBER(20,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
>
> <field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"></field-type-def>
> <field-type-def type="id-long" sql-type="VARCHAR(60)" java-type="String"></field-type-def>
>
> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypecloudscape.xml
> URL:
> http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypecloudscape.xml?rev=664547&r1=664546&r2=664547&view=diff
> ==============================================================================
> --- ofbiz/trunk/framework/entity/fieldtype/fieldtypecloudscape.xml (original)
> +++ ofbiz/trunk/framework/entity/fieldtype/fieldtypecloudscape.xml Sun Jun 8 13:12:34 2008
> @@ -27,12 +27,11 @@
> <field-type-def type="date-time" sql-type="DATE" java-type="java.sql.Timestamp"></field-type-def>
> <field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"></field-type-def>
> <field-type-def type="time" sql-type="DATE" java-type="java.sql.Time"></field-type-def>
> - <field-type-def type="long" sql-type="NUMERIC(19,0)" java-type="java.lang.Long"><validate method="isSignedLong"
> /></field-type-def>
>
> <field-type-def type="currency-amount" sql-type="NUMERIC(18,2)" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> <field-type-def type="currency-precise" sql-type="NUMERIC(18,3)" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> <field-type-def type="floating-point" sql-type="NUMERIC(18,6)" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> - <field-type-def type="numeric" sql-type="NUMERIC(18,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
> + <field-type-def type="numeric" sql-type="NUMERIC(20,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
>
> <field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"></field-type-def>
> <field-type-def type="id-long" sql-type="VARCHAR(60)" java-type="String"></field-type-def>
>
> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypedaffodil.xml
> URL:
> http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypedaffodil.xml?rev=664547&r1=664546&r2=664547&view=diff
> ==============================================================================
> --- ofbiz/trunk/framework/entity/fieldtype/fieldtypedaffodil.xml (original)
> +++ ofbiz/trunk/framework/entity/fieldtype/fieldtypedaffodil.xml Sun Jun 8 13:12:34 2008
> @@ -27,12 +27,11 @@
> <field-type-def type="date-time" sql-type="TIMESTAMP" java-type="java.sql.Timestamp"></field-type-def>
> <field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"></field-type-def>
> <field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"></field-type-def>
> - <field-type-def type="long" sql-type="NUMBER(19,0)" java-type="java.lang.Long"><validate method="isSignedLong"
> /></field-type-def>
>
> <field-type-def type="currency-amount" sql-type="NUMBER(18,2)" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> <field-type-def type="currency-precise" sql-type="NUMBER(18,3)" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> <field-type-def type="floating-point" sql-type="NUMBER(18,6)" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> - <field-type-def type="numeric" sql-type="NUMBER(18,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
> + <field-type-def type="numeric" sql-type="NUMBER(20,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
>
> <field-type-def type="id" sql-type="VARCHAR2(20)" java-type="String"></field-type-def>
> <field-type-def type="id-long" sql-type="VARCHAR2(60)" java-type="String"></field-type-def>
>
> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypederby.xml
> URL:
> http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypederby.xml?rev=664547&r1=664546&r2=664547&view=diff
> ==============================================================================
> --- ofbiz/trunk/framework/entity/fieldtype/fieldtypederby.xml (original)
> +++ ofbiz/trunk/framework/entity/fieldtype/fieldtypederby.xml Sun Jun 8 13:12:34 2008
> @@ -27,13 +27,11 @@
> <field-type-def type="date-time" sql-type="TIMESTAMP" java-type="java.sql.Timestamp"></field-type-def>
> <field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"></field-type-def>
> <field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"></field-type-def>
> - <field-type-def type="long" sql-type="NUMERIC(19,0)" java-type="java.lang.Long"><validate method="isSignedLong"
> /></field-type-def>
> - <!-- <field-type-def type="long" sql-type="BIGINT" java-type="java.lang.Long"></field-type-def> -->
>
> <field-type-def type="currency-amount" sql-type="NUMERIC(18,2)" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> <field-type-def type="currency-precise" sql-type="NUMERIC(18,3)" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> <field-type-def type="floating-point" sql-type="DOUBLE" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> - <field-type-def type="numeric" sql-type="NUMERIC(18,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
> + <field-type-def type="numeric" sql-type="NUMERIC(20,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
>
> <field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"></field-type-def>
> <field-type-def type="id-long" sql-type="VARCHAR(60)" java-type="String"></field-type-def>
>
> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypefirebird.xml
> URL:
> http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypefirebird.xml?rev=664547&r1=664546&r2=664547&view=diff
> ==============================================================================
> --- ofbiz/trunk/framework/entity/fieldtype/fieldtypefirebird.xml (original)
> +++ ofbiz/trunk/framework/entity/fieldtype/fieldtypefirebird.xml Sun Jun 8 13:12:34 2008
> @@ -28,12 +28,11 @@
> <field-type-def type="date-time" sql-type="TIMESTAMP" java-type="java.sql.Timestamp"></field-type-def>
> <field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"></field-type-def>
> <field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"></field-type-def>
> - <field-type-def type="long" sql-type="NUMERIC(19,0)" java-type="java.lang.Long"><validate method="isSignedLong"
> /></field-type-def>
>
> <field-type-def type="currency-amount" sql-type="NUMERIC(18,2)" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> <field-type-def type="currency-precise" sql-type="NUMERIC(18,3)" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> <field-type-def type="floating-point" sql-type="FLOAT" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> - <field-type-def type="numeric" sql-type="NUMERIC(18,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
> + <field-type-def type="numeric" sql-type="NUMERIC(20,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
>
> <field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"></field-type-def>
> <field-type-def type="id-long" sql-type="VARCHAR(60)" java-type="String"></field-type-def>
>
> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypehsql.xml
> URL:
> http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypehsql.xml?rev=664547&r1=664546&r2=664547&view=diff
> ==============================================================================
> --- ofbiz/trunk/framework/entity/fieldtype/fieldtypehsql.xml (original)
> +++ ofbiz/trunk/framework/entity/fieldtype/fieldtypehsql.xml Sun Jun 8 13:12:34 2008
> @@ -27,7 +27,6 @@
> <field-type-def type="date-time" sql-type="TIMESTAMP" java-type="java.sql.Timestamp"></field-type-def>
> <field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"></field-type-def>
> <field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"></field-type-def>
> - <field-type-def type="long" sql-type="BIGINT" java-type="java.lang.Long"><validate method="isSignedLong" /></field-type-def>
>
> <field-type-def type="currency-amount" sql-type="DOUBLE" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> <field-type-def type="currency-precise" sql-type="DOUBLE" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
>
> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypemssql.xml
> URL:
> http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypemssql.xml?rev=664547&r1=664546&r2=664547&view=diff
> ==============================================================================
> --- ofbiz/trunk/framework/entity/fieldtype/fieldtypemssql.xml (original)
> +++ ofbiz/trunk/framework/entity/fieldtype/fieldtypemssql.xml Sun Jun 8 13:12:34 2008
> @@ -27,7 +27,6 @@
> <field-type-def type="date-time" sql-type="DATETIME" java-type="java.sql.Timestamp"></field-type-def>
> <field-type-def type="date" sql-type="DATETIME" java-type="java.sql.Date"></field-type-def>
> <field-type-def type="time" sql-type="DATETIME" java-type="java.sql.Time"></field-type-def>
> - <field-type-def type="long" sql-type="INT" java-type="java.lang.Long"><validate method="isSignedLong" /></field-type-def>
>
> <field-type-def type="currency-amount" sql-type="DECIMAL(18,2)" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> <field-type-def type="currency-precise" sql-type="DECIMAL(18,3)" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
>
> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypemysql.xml
> URL:
> http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypemysql.xml?rev=664547&r1=664546&r2=664547&view=diff
> ==============================================================================
> --- ofbiz/trunk/framework/entity/fieldtype/fieldtypemysql.xml (original)
> +++ ofbiz/trunk/framework/entity/fieldtype/fieldtypemysql.xml Sun Jun 8 13:12:34 2008
> @@ -27,12 +27,11 @@
> <field-type-def type="date-time" sql-type="DATETIME" java-type="java.sql.Timestamp"></field-type-def>
> <field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"></field-type-def>
> <field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"></field-type-def>
> - <field-type-def type="long" sql-type="DECIMAL(19,0)" java-type="java.lang.Long"><validate method="isSignedLong"
> /></field-type-def>
>
> <field-type-def type="currency-amount" sql-type="DECIMAL(18,2)" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> <field-type-def type="currency-precise" sql-type="DECIMAL(18,3)" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> <field-type-def type="floating-point" sql-type="DECIMAL(18,6)" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> - <field-type-def type="numeric" sql-type="DECIMAL(18,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
> + <field-type-def type="numeric" sql-type="DECIMAL(20,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
>
> <field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"></field-type-def>
> <field-type-def type="id-long" sql-type="VARCHAR(60)" java-type="String"></field-type-def>
>
> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypeoracle.xml
> URL:
> http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypeoracle.xml?rev=664547&r1=664546&r2=664547&view=diff
> ==============================================================================
> --- ofbiz/trunk/framework/entity/fieldtype/fieldtypeoracle.xml (original)
> +++ ofbiz/trunk/framework/entity/fieldtype/fieldtypeoracle.xml Sun Jun 8 13:12:34 2008
> @@ -27,12 +27,11 @@
> <field-type-def type="date-time" sql-type="TIMESTAMP" sql-type-alias="TIMESTAMP(6)"
> java-type="java.sql.Timestamp"></field-type-def>
> <field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"></field-type-def>
> <field-type-def type="time" sql-type="DATE" java-type="java.sql.Time"></field-type-def>
> - <field-type-def type="long" sql-type="NUMBER(19,0)" java-type="java.lang.Long"><validate method="isSignedLong"
> /></field-type-def>
>
> <field-type-def type="currency-amount" sql-type="NUMBER(18,2)" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> <field-type-def type="currency-precise" sql-type="NUMBER(18,3)" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> <field-type-def type="floating-point" sql-type="NUMBER(18,6)" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> - <field-type-def type="numeric" sql-type="NUMBER(18,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
> + <field-type-def type="numeric" sql-type="NUMBER(20,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
>
> <field-type-def type="id" sql-type="VARCHAR2(20)" java-type="String"></field-type-def>
> <field-type-def type="id-long" sql-type="VARCHAR2(60)" java-type="String"></field-type-def>
>
> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypepostgres.xml
> URL:
> http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypepostgres.xml?rev=664547&r1=664546&r2=664547&view=diff
> ==============================================================================
> --- ofbiz/trunk/framework/entity/fieldtype/fieldtypepostgres.xml (original)
> +++ ofbiz/trunk/framework/entity/fieldtype/fieldtypepostgres.xml Sun Jun 8 13:12:34 2008
> @@ -27,12 +27,11 @@
> <field-type-def type="date-time" sql-type="TIMESTAMPTZ" java-type="java.sql.Timestamp"></field-type-def>
> <field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"></field-type-def>
> <field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"></field-type-def>
> - <field-type-def type="long" sql-type="NUMERIC(19,0)" java-type="java.lang.Long"><validate method="isSignedLong"
> /></field-type-def>
>
> <field-type-def type="currency-amount" sql-type="NUMERIC(18,2)" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> <field-type-def type="currency-precise" sql-type="NUMERIC(18,3)" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> <field-type-def type="floating-point" sql-type="FLOAT8" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> - <field-type-def type="numeric" sql-type="NUMERIC(18,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
> + <field-type-def type="numeric" sql-type="NUMERIC(20,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
>
> <field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"></field-type-def>
> <field-type-def type="id-long" sql-type="VARCHAR(60)" java-type="String"></field-type-def>
>
> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypesapdb.xml
> URL:
> http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypesapdb.xml?rev=664547&r1=664546&r2=664547&view=diff
> ==============================================================================
> --- ofbiz/trunk/framework/entity/fieldtype/fieldtypesapdb.xml (original)
> +++ ofbiz/trunk/framework/entity/fieldtype/fieldtypesapdb.xml Sun Jun 8 13:12:34 2008
> @@ -27,12 +27,11 @@
> <field-type-def type="date-time" sql-type="TIMESTAMP" java-type="java.sql.Timestamp"></field-type-def>
> <field-type-def type="date" sql-type="DATE" java-type="java.sql.Date"></field-type-def>
> <field-type-def type="time" sql-type="TIME" java-type="java.sql.Time"></field-type-def>
> - <field-type-def type="long" sql-type="FIXED(19,0)" java-type="java.lang.Long"><validate method="isSignedLong"
> /></field-type-def>
>
> <field-type-def type="currency-amount" sql-type="FIXED(18,2)" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> <field-type-def type="currency-precise" sql-type="FIXED(18,3)" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> <field-type-def type="floating-point" sql-type="FIXED(18,6)" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> - <field-type-def type="numeric" sql-type="FIXED(18,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
> + <field-type-def type="numeric" sql-type="FIXED(20,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
>
> <field-type-def type="id" sql-type="VARCHAR(20) UNICODE" sql-type-alias="VARCHAR() UNICODE"
> java-type="String"></field-type-def>
> <field-type-def type="id-long" sql-type="VARCHAR(60) UNICODE" sql-type-alias="VARCHAR() UNICODE"
> java-type="String"></field-type-def>
>
> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypesybase.xml
> URL:
> http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypesybase.xml?rev=664547&r1=664546&r2=664547&view=diff
> ==============================================================================
> --- ofbiz/trunk/framework/entity/fieldtype/fieldtypesybase.xml (original)
> +++ ofbiz/trunk/framework/entity/fieldtype/fieldtypesybase.xml Sun Jun 8 13:12:34 2008
> @@ -27,12 +27,11 @@
> <field-type-def type="date-time" sql-type="DATETIME" java-type="Timestamp"></field-type-def>
> <field-type-def type="date" sql-type="DATETIME" java-type="java.sql.Date"></field-type-def>
> <field-type-def type="time" sql-type="DATETIME" java-type="java.sql.Time"></field-type-def>
> - <field-type-def type="long" sql-type="NUMERIC(19,0)" java-type="java.lang.Long"><validate method="isSignedLong"
> /></field-type-def>
>
> <field-type-def type="currency-amount" sql-type="NUMERIC(18,2)" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> <field-type-def type="currency-precise" sql-type="NUMERIC(18,3)" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> <field-type-def type="floating-point" sql-type="NUMERIC(18,6)" java-type="Double"><validate method="isSignedDouble"
> /></field-type-def>
> - <field-type-def type="numeric" sql-type="NUMERIC(18,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
> + <field-type-def type="numeric" sql-type="NUMERIC(20,0)" java-type="Long"><validate method="isSignedLong" /></field-type-def>
>
> <field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"></field-type-def>
> <field-type-def type="id-long" sql-type="VARCHAR(60)" java-type="String"></field-type-def>
>
> Modified: ofbiz/trunk/framework/shark/entitydef/entitymodel.xml
> URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/shark/entitydef/entitymodel.xml?rev=664547&r1=664546&r2=664547&view=diff
> ==============================================================================
> --- ofbiz/trunk/framework/shark/entitydef/entitymodel.xml (original)
> +++ ofbiz/trunk/framework/shark/entitydef/entitymodel.xml Sun Jun 8 13:12:34 2008
> @@ -150,12 +150,12 @@
> <field name="activityName" type="long-varchar"></field>
> <field name="description" type="long-varchar"></field>
> <field name="currentState" type="long-varchar"></field>
> - <field name="priority" type="long"></field>
> + <field name="priority" type="numeric"></field>
> <field name="accepted" type="indicator"></field>
> - <field name="timeLimit" type="long"></field>
> - <field name="activatedTime" type="long"></field>
> - <field name="acceptedTime" type="long"></field>
> - <field name="lastStateTime" type="long"></field>
> + <field name="timeLimit" type="numeric"></field>
> + <field name="activatedTime" type="numeric"></field>
> + <field name="acceptedTime" type="numeric"></field>
> + <field name="lastStateTime" type="numeric"></field>
> <prim-key field="activityId"/>
> <relation type="one" fk-name="WF_ACT_PROC" rel-entity-name="WfProcess">
> <key-map field-name="processId"/>
> @@ -173,7 +173,7 @@
> <field name="definitionId" type="long-varchar"></field>
> <field name="valueField" type="name"></field>
> <field name="strValue" type="long-varchar"></field>
> - <field name="numValue" type="long"></field>
> + <field name="numValue" type="numeric"></field>
> <field name="dblValue" type="floating-point"></field>
> <field name="objValue" type="blob"></field>
> <field name="isModified" type="indicator"></field>
> @@ -217,7 +217,7 @@
> <field name="processId" type="long-varchar"></field>
> <field name="activityId" type="long-varchar"></field>
> <field name="exceptionName" type="long-varchar"></field>
> - <field name="timeLimit" type="long"></field>
> + <field name="timeLimit" type="numeric"></field>
> <field name="isExecuted" type="indicator"></field>
> <field name="isSync" type="indicator"></field>
> <prim-key field="deadlineId"/>
> @@ -239,15 +239,15 @@
> <field name="activityReqProcessId" type="long-varchar"></field>
> <field name="activityReqId" type="long-varchar"></field>
> <field name="resourceReqId" type="long-varchar"></field>
> - <field name="timeLimit" type="long"></field>
> + <field name="timeLimit" type="numeric"></field>
> <field name="processName" type="long-varchar"></field>
> <field name="description" type="long-varchar"></field>
> <field name="currentState" type="long-varchar"></field>
> - <field name="priority" type="long"></field>
> + <field name="priority" type="numeric"></field>
> <field name="externalReq" type="blob"></field>
> - <field name="createdTime" type="long"></field>
> - <field name="startedTime" type="long"></field>
> - <field name="lastStateTime" type="long"></field>
> + <field name="createdTime" type="numeric"></field>
> + <field name="startedTime" type="numeric"></field>
> + <field name="lastStateTime" type="numeric"></field>
> <field name="ExternalRequesterClassName" type="long-varchar"></field>
> <prim-key field="processId"/>
> <relation type="one" fk-name="WF_PROC_MGR" rel-entity-name="WfProcessMgr">
> @@ -261,8 +261,8 @@
> <field name="packageId" type="long-varchar"></field>
> <field name="packageVer" type="long-varchar"></field>
> <field name="definitionId" type="long-varchar"></field>
> - <field name="created" type="long"></field>
> - <field name="currentState" type="long"></field>
> + <field name="created" type="numeric"></field>
> + <field name="currentState" type="numeric"></field>
> <prim-key field="mgrName"/>
> </entity>
> <entity entity-name="WfProcessVariable"
> @@ -273,7 +273,7 @@
> <field name="definitionId" type="long-varchar"></field>
> <field name="valueField" type="name"></field>
> <field name="strValue" type="long-varchar"></field>
> - <field name="numValue" type="long"></field>
> + <field name="numValue" type="numeric"></field>
> <field name="dblValue" type="floating-point"></field>
> <field name="objValue" type="blob"></field>
> <prim-key field="processVariableId"/>
> @@ -299,7 +299,7 @@
> <field name="userName" type="long-varchar"></field>
> <field name="passwd" type="long-varchar"></field>
> <field name="applicationName" type="long-varchar"></field>
> - <field name="applicationMode" type="long"></field>
> + <field name="applicationMode" type="numeric"></field>
> <prim-key field="packageId"/>
> <prim-key field="processDefId"/>
> <prim-key field="applicationDefId"/>
> @@ -351,8 +351,8 @@
> title="">
> <field name="requesterId" type="long-varchar"></field>
> <field name="processId" type="long-varchar"></field>
> - <field name="fromDate" type="long"></field>
> - <field name="thruDate" type="long"></field>
> + <field name="fromDate" type="numeric"></field>
> + <field name="thruDate" type="numeric"></field>
> <field name="className" type="long-varchar"></field>
> <field name="classData" type="long-varchar"></field>
> <prim-key field="requesterId"/>
>
>