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

[Jacques Le Roux]

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