svn commit: r664547 - in /ofbiz/trunk/framework: entity/fieldtype/ shark/entitydef/

[jonesde]

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