I made a step further at revision: 1529674. Now, if nobody disagree, I'd like to replace fieldtypepostgres.xml by fieldtypepostnew.xml which would be renamed fieldtypepostgres.xml The only difference is to allow unlimited texts in comment and description
Jacques Adrian Crum wrote: > There are no field lengths specified in that file. > > Adrian Crum > Sandglass Software > www.sandglass-software.com > > On 10/6/2013 9:31 AM, Jacques Le Roux wrote: >> Why not in fieldtypepostnew.xml ? >> >> Jacques >> >> [email protected] wrote: >>> Author: adrianc >>> Date: Sun Oct 6 15:57:31 2013 >>> New Revision: 1529637 >>> >>> URL: http://svn.apache.org/r1529637 >>> Log: >>> Increased the "url" field type to 2000 characters. >>> >>> Modified: >>> ofbiz/trunk/framework/entity/fieldtype/fieldtypeadvantage.xml >>> ofbiz/trunk/framework/entity/fieldtype/fieldtypeaxion.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 >>> >>> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypeadvantage.xml >>> URL: >>> http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypeadvantage.xml?rev=1529637&r1=1529636&r2=1529637&view=diff >>> ============================================================================== >>> --- >>> ofbiz/trunk/framework/entity/fieldtype/fieldtypeadvantage.xml (original) +++ >>> ofbiz/trunk/framework/entity/fieldtype/fieldtypeadvantage.xml Sun Oct 6 >>> 15:57:31 2013 @@ -59,7 +59,7 @@ under the License. >>> <field-type-def type="credit-card-number" sql-type="Char(255)" >>> java-type="String"/> >>> <field-type-def type="credit-card-date" sql-type="Char(20)" >>> java-type="String"/> >>> <field-type-def type="email" sql-type="Char(255)" java-type="String"/> >>> - <field-type-def type="url" sql-type="Char(255)" java-type="String"/> >>> + <field-type-def type="url" sql-type="Char(2000)" java-type="String"/> >>> <field-type-def type="id-ne" sql-type="Char(20)" java-type="String"/> >>> <field-type-def type="id-long-ne" sql-type="Char(60)" >>> java-type="String"/> >>> <field-type-def type="id-vlong-ne" sql-type="Char(255)" >>> java-type="String"/> >>> >>> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypeaxion.xml >>> URL: >>> http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypeaxion.xml?rev=1529637&r1=1529636&r2=1529637&view=diff >>> ============================================================================== >>> --- >>> ofbiz/trunk/framework/entity/fieldtype/fieldtypeaxion.xml (original) +++ >>> ofbiz/trunk/framework/entity/fieldtype/fieldtypeaxion.xml Sun Oct 6 >>> 15:57:31 2013 @@ -55,7 +55,7 @@ under the License. >>> <field-type-def type="credit-card-number" sql-type="VARCHAR(255)" >>> java-type="String"/> >>> <field-type-def type="credit-card-date" sql-type="VARCHAR(20)" >>> java-type="String"/> >>> <field-type-def type="email" sql-type="VARCHAR(255)" >>> java-type="String"/> >>> - <field-type-def type="url" sql-type="VARCHAR(255)" java-type="String"/> >>> + <field-type-def type="url" sql-type="VARCHAR(2000)" >>> java-type="String"/> >>> <field-type-def type="id-ne" sql-type="VARCHAR(20)" >>> java-type="String"/> >>> <field-type-def type="id-long-ne" sql-type="VARCHAR(60)" >>> java-type="String"/> >>> <field-type-def type="id-vlong-ne" sql-type="VARCHAR(255)" >>> java-type="String"/> >>> >>> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypedaffodil.xml >>> URL: >>> http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypedaffodil.xml?rev=1529637&r1=1529636&r2=1529637&view=diff >>> ============================================================================== >>> --- >>> ofbiz/trunk/framework/entity/fieldtype/fieldtypedaffodil.xml (original) +++ >>> ofbiz/trunk/framework/entity/fieldtype/fieldtypedaffodil.xml Sun Oct 6 >>> 15:57:31 2013 @@ -55,7 +55,7 @@ under the License. >>> <field-type-def type="credit-card-number" sql-type="VARCHAR2(255)" >>> java-type="String"/> >>> <field-type-def type="credit-card-date" sql-type="VARCHAR2(20)" >>> java-type="String"/> >>> <field-type-def type="email" sql-type="VARCHAR2(255)" >>> java-type="String"/> >>> - <field-type-def type="url" sql-type="VARCHAR2(255)" >>> java-type="String"/> >>> + <field-type-def type="url" sql-type="VARCHAR2(2000)" >>> java-type="String"/> >>> <field-type-def type="id-ne" sql-type="VARCHAR2(20)" >>> java-type="String"/> >>> <field-type-def type="id-long-ne" sql-type="VARCHAR2(60)" >>> java-type="String"/> >>> <field-type-def type="id-vlong-ne" sql-type="VARCHAR2(255)" >>> java-type="String"/> >>> >>> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypederby.xml >>> URL: >>> http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypederby.xml?rev=1529637&r1=1529636&r2=1529637&view=diff >>> ============================================================================== >>> --- >>> ofbiz/trunk/framework/entity/fieldtype/fieldtypederby.xml (original) +++ >>> ofbiz/trunk/framework/entity/fieldtype/fieldtypederby.xml Sun Oct 6 >>> 15:57:31 2013 @@ -55,7 +55,7 @@ under the License. >>> <field-type-def type="credit-card-number" sql-type="VARCHAR(255)" >>> java-type="String"/> >>> <field-type-def type="credit-card-date" sql-type="VARCHAR(20)" >>> java-type="String"/> >>> <field-type-def type="email" sql-type="VARCHAR(255)" >>> java-type="String"/> >>> - <field-type-def type="url" sql-type="VARCHAR(255)" java-type="String"/> >>> + <field-type-def type="url" sql-type="VARCHAR(2000)" >>> java-type="String"/> >>> <field-type-def type="id-ne" sql-type="VARCHAR(20)" >>> java-type="String"/> >>> <field-type-def type="id-long-ne" sql-type="VARCHAR(60)" >>> java-type="String"/> >>> <field-type-def type="id-vlong-ne" sql-type="VARCHAR(255)" >>> java-type="String"/> >>> >>> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypefirebird.xml >>> URL: >>> http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypefirebird.xml?rev=1529637&r1=1529636&r2=1529637&view=diff >>> ============================================================================== >>> --- >>> ofbiz/trunk/framework/entity/fieldtype/fieldtypefirebird.xml (original) +++ >>> ofbiz/trunk/framework/entity/fieldtype/fieldtypefirebird.xml Sun Oct 6 >>> 15:57:31 2013 @@ -55,7 +55,7 @@ under the License. >>> <field-type-def type="credit-card-number" sql-type="VARCHAR(255)" >>> java-type="String"/> >>> <field-type-def type="credit-card-date" sql-type="VARCHAR(20)" >>> java-type="String"/> >>> <field-type-def type="email" sql-type="VARCHAR(255)" >>> java-type="String"/> >>> - <field-type-def type="url" sql-type="VARCHAR(255)" java-type="String"/> >>> + <field-type-def type="url" sql-type="VARCHAR(2000)" >>> java-type="String"/> >>> <field-type-def type="id-ne" sql-type="VARCHAR(20)" >>> java-type="String"/> >>> <field-type-def type="id-long-ne" sql-type="VARCHAR(60)" >>> java-type="String"/> >>> <field-type-def type="id-vlong-ne" sql-type="VARCHAR(255)" >>> java-type="String"/> >>> >>> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypehsql.xml >>> URL: >>> http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypehsql.xml?rev=1529637&r1=1529636&r2=1529637&view=diff >>> ============================================================================== >>> --- >>> ofbiz/trunk/framework/entity/fieldtype/fieldtypehsql.xml (original) +++ >>> ofbiz/trunk/framework/entity/fieldtype/fieldtypehsql.xml >>> Sun Oct 6 15:57:31 2013 @@ -55,7 +55,7 @@ under the License. >>> <field-type-def type="credit-card-number" sql-type="VARCHAR" >>> java-type="String"/> >>> <field-type-def type="credit-card-date" sql-type="VARCHAR" >>> java-type="String"/> >>> <field-type-def type="email" sql-type="VARCHAR" java-type="String"/> >>> - <field-type-def type="url" sql-type="VARCHAR" java-type="String"/> >>> + <field-type-def type="url" sql-type="VARCHAR(2000)" >>> java-type="String"/> >>> <field-type-def type="id-ne" sql-type="VARCHAR" java-type="String"/> >>> <field-type-def type="id-long-ne" sql-type="VARCHAR" >>> java-type="String"/> >>> <field-type-def type="id-vlong-ne" sql-type="VARCHAR" >>> java-type="String"/> >>> >>> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypemssql.xml >>> URL: >>> http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypemssql.xml?rev=1529637&r1=1529636&r2=1529637&view=diff >>> ============================================================================== >>> --- >>> ofbiz/trunk/framework/entity/fieldtype/fieldtypemssql.xml (original) +++ >>> ofbiz/trunk/framework/entity/fieldtype/fieldtypemssql.xml Sun Oct 6 >>> 15:57:31 2013 @@ -55,7 +55,7 @@ under the License. >>> <field-type-def type="credit-card-number" sql-type="VARCHAR(255)" >>> java-type="String"/> >>> <field-type-def type="credit-card-date" sql-type="VARCHAR(20)" >>> java-type="String"/> >>> <field-type-def type="email" sql-type="VARCHAR(255)" >>> java-type="String"/> >>> - <field-type-def type="url" sql-type="VARCHAR(255)" java-type="String"/> >>> + <field-type-def type="url" sql-type="VARCHAR(2000)" >>> java-type="String"/> >>> <field-type-def type="id-ne" sql-type="VARCHAR(20)" >>> java-type="String"/> >>> <field-type-def type="id-long-ne" sql-type="VARCHAR(60)" >>> java-type="String"/> >>> <field-type-def type="id-vlong-ne" sql-type="VARCHAR(250)" >>> java-type="String"/> >>> >>> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypemysql.xml >>> URL: >>> http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypemysql.xml?rev=1529637&r1=1529636&r2=1529637&view=diff >>> ============================================================================== >>> --- >>> ofbiz/trunk/framework/entity/fieldtype/fieldtypemysql.xml (original) +++ >>> ofbiz/trunk/framework/entity/fieldtype/fieldtypemysql.xml Sun Oct 6 >>> 15:57:31 2013 @@ -55,7 +55,7 @@ under the License. >>> <field-type-def type="credit-card-number" sql-type="VARCHAR(255)" >>> java-type="String"/> >>> <field-type-def type="credit-card-date" sql-type="VARCHAR(20)" >>> java-type="String"/> >>> <field-type-def type="email" sql-type="VARCHAR(255)" >>> java-type="String"/> >>> - <field-type-def type="url" sql-type="VARCHAR(255)" java-type="String"/> >>> + <field-type-def type="url" sql-type="VARCHAR(2000)" >>> java-type="String"/> >>> <field-type-def type="id-ne" sql-type="VARCHAR(20)" >>> java-type="String"/> >>> <field-type-def type="id-long-ne" sql-type="VARCHAR(60)" >>> java-type="String"/> >>> <field-type-def type="id-vlong-ne" sql-type="VARCHAR(250)" >>> java-type="String"/> >>> >>> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypeoracle.xml >>> URL: >>> http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypeoracle.xml?rev=1529637&r1=1529636&r2=1529637&view=diff >>> ============================================================================== >>> --- >>> ofbiz/trunk/framework/entity/fieldtype/fieldtypeoracle.xml (original) +++ >>> ofbiz/trunk/framework/entity/fieldtype/fieldtypeoracle.xml Sun Oct 6 >>> 15:57:31 2013 @@ -69,7 +69,7 @@ under the License. >>> <field-type-def type="credit-card-number" sql-type="VARCHAR2(255)" >>> java-type="String"/> >>> <field-type-def type="credit-card-date" sql-type="VARCHAR2(20)" >>> java-type="String"/> >>> <field-type-def type="email" sql-type="VARCHAR2(255)" >>> java-type="String"/> >>> - <field-type-def type="url" sql-type="VARCHAR2(255)" >>> java-type="String"/> >>> + <field-type-def type="url" sql-type="VARCHAR2(2000)" >>> java-type="String"/> >>> <field-type-def type="id-ne" sql-type="VARCHAR2(20)" >>> java-type="String"/> >>> <field-type-def type="id-long-ne" sql-type="VARCHAR2(60)" >>> java-type="String"/> >>> <field-type-def type="id-vlong-ne" sql-type="VARCHAR2(255)" >>> java-type="String"/> >>> >>> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypepostgres.xml >>> URL: >>> http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypepostgres.xml?rev=1529637&r1=1529636&r2=1529637&view=diff >>> ============================================================================== >>> --- >>> ofbiz/trunk/framework/entity/fieldtype/fieldtypepostgres.xml (original) +++ >>> ofbiz/trunk/framework/entity/fieldtype/fieldtypepostgres.xml Sun Oct 6 >>> 15:57:31 2013 @@ -55,7 +55,7 @@ under the License. >>> <field-type-def type="credit-card-number" sql-type="VARCHAR(255)" >>> java-type="String"/> >>> <field-type-def type="credit-card-date" sql-type="VARCHAR(20)" >>> java-type="String"/> >>> <field-type-def type="email" sql-type="VARCHAR(255)" >>> java-type="String"/> >>> - <field-type-def type="url" sql-type="VARCHAR(255)" java-type="String"/> >>> + <field-type-def type="url" sql-type="VARCHAR(2000)" >>> java-type="String"/> >>> <field-type-def type="id-ne" sql-type="VARCHAR(20)" >>> java-type="String"/> >>> <field-type-def type="id-long-ne" sql-type="VARCHAR(60)" >>> java-type="String"/> >>> <field-type-def type="id-vlong-ne" sql-type="VARCHAR(255)" >>> java-type="String"/> >>> >>> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypesapdb.xml >>> URL: >>> http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypesapdb.xml?rev=1529637&r1=1529636&r2=1529637&view=diff >>> ============================================================================== >>> --- >>> ofbiz/trunk/framework/entity/fieldtype/fieldtypesapdb.xml (original) +++ >>> ofbiz/trunk/framework/entity/fieldtype/fieldtypesapdb.xml Sun Oct 6 >>> 15:57:31 2013 @@ -55,7 +55,7 @@ under the License. >>> <field-type-def type="credit-card-number" sql-type="VARCHAR(255) >>> UNICODE" sql-type-alias="VARCHAR() UNICODE" >>> java-type="String"/> <field-type-def type="credit-card-date" >>> sql-type="VARCHAR(20) UNICODE" sql-type-alias="VARCHAR() >>> UNICODE" java-type="String"/> <field-type-def type="email" >>> sql-type="VARCHAR(255) UNICODE" sql-type-alias="VARCHAR() >>> UNICODE" java-type="String"/> - <field-type-def type="url" >>> sql-type="VARCHAR(255) UNICODE" sql-type-alias="VARCHAR() UNICODE" >>> java-type="String"/> + <field-type-def type="url" >>> sql-type="VARCHAR(2000) UNICODE" sql-type-alias="VARCHAR() UNICODE" >>> java-type="String"/> <field-type-def type="id-ne" >>> sql-type="VARCHAR(20) UNICODE" sql-type-alias="VARCHAR() UNICODE" >>> java-type="String"/> <field-type-def type="id-long-ne" >>> sql-type="VARCHAR(60) UNICODE" sql-type-alias="VARCHAR() UNICODE" >>> java-type="String"/> <field-type-def type="id-vlong-ne" >>> sql-type="VARCHAR(255) UNICODE" sql-type-alias="VARCHAR() UNICODE" >>> java-type="String"/> >>> >>> Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypesybase.xml >>> URL: >>> http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypesybase.xml?rev=1529637&r1=1529636&r2=1529637&view=diff >>> ============================================================================== >>> --- >>> ofbiz/trunk/framework/entity/fieldtype/fieldtypesybase.xml (original) +++ >>> ofbiz/trunk/framework/entity/fieldtype/fieldtypesybase.xml Sun Oct 6 >>> 15:57:31 2013 @@ -26,7 +26,7 @@ under the License. >>> <field-type-def type="byte-array" sql-type="IMAGE" java-type="byte[]"/> >>> <field-type-def type="object" sql-type="IMAGE" java-type="Object"/> >>> >>> - <field-type-def type="date-time" sql-type="DATETIME" >>> java-type="Timestamp"/> >>> + <field-type-def type="date-time" sql-type="DATETIME" >>> java-type="java.sql.Timestamp"/> >>> <field-type-def type="date" sql-type="DATETIME" >>> java-type="java.sql.Date"/> >>> <field-type-def type="time" sql-type="DATETIME" >>> java-type="java.sql.Time"/> >>> >>> @@ -55,7 +55,7 @@ under the License. >>> <field-type-def type="credit-card-number" sql-type="VARCHAR(255)" >>> java-type="String"/> >>> <field-type-def type="credit-card-date" sql-type="VARCHAR(20)" >>> java-type="String"/> >>> <field-type-def type="email" sql-type="VARCHAR(255)" >>> java-type="String"/> >>> - <field-type-def type="url" sql-type="VARCHAR(255)" java-type="String"/> >>> + <field-type-def type="url" sql-type="VARCHAR(2000)" >>> java-type="String"/> >>> <field-type-def type="id-ne" sql-type="VARCHAR(20)" >>> java-type="String"/> >>> <field-type-def type="id-long-ne" sql-type="VARCHAR(60)" >>> java-type="String"/> >>> <field-type-def type="id-vlong-ne" sql-type="VARCHAR(255)" >>> java-type="String"/>
