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"/>



Reply via email to