Fixes issue 18083: Extend AD_User.Email length from 40 to 255
authorIván Perdomo <ivan.perdomo@openbravo.com>
Tue, 26 Jul 2011 15:53:57 +0200
changeset 305 fc84df1f6af4
parent 304 ec82c777792f
child 306 fd48ed8aef1d
Fixes issue 18083: Extend AD_User.Email length from 40 to 255
model/src-db/database/model/tables/AD_USER.xml
model/src-db/database/sourcedata/AD_COLUMN.xml
model/src-db/database/sourcedata/AD_FIELD.xml
--- a/model/src-db/database/model/tables/AD_USER.xml	Fri Jul 15 17:59:26 2011 +0200
+++ b/model/src-db/database/model/tables/AD_USER.xml	Tue Jul 26 15:53:57 2011 +0200
@@ -45,7 +45,7 @@
         <default/>
         <onCreateDefault/>
       </column>
-      <column name="EMAIL" primaryKey="false" required="false" type="NVARCHAR" size="40" autoIncrement="false">
+      <column name="EMAIL" primaryKey="false" required="false" type="NVARCHAR" size="255" autoIncrement="false">
         <default/>
         <onCreateDefault/>
       </column>
--- a/model/src-db/database/sourcedata/AD_COLUMN.xml	Fri Jul 15 17:59:26 2011 +0200
+++ b/model/src-db/database/sourcedata/AD_COLUMN.xml	Tue Jul 26 15:53:57 2011 +0200
@@ -76054,7 +76054,7 @@
 <!--5396-->  <COLUMNNAME><![CDATA[Email]]></COLUMNNAME>
 <!--5396-->  <AD_TABLE_ID><![CDATA[114]]></AD_TABLE_ID>
 <!--5396-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
-<!--5396-->  <FIELDLENGTH><![CDATA[40]]></FIELDLENGTH>
+<!--5396-->  <FIELDLENGTH><![CDATA[255]]></FIELDLENGTH>
 <!--5396-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--5396-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--5396-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
--- a/model/src-db/database/sourcedata/AD_FIELD.xml	Fri Jul 15 17:59:26 2011 +0200
+++ b/model/src-db/database/sourcedata/AD_FIELD.xml	Tue Jul 26 15:53:57 2011 +0200
@@ -52356,7 +52356,7 @@
 <!--4260-->  <AD_COLUMN_ID><![CDATA[5396]]></AD_COLUMN_ID>
 <!--4260-->  <AD_FIELDGROUP_ID><![CDATA[402880E72F1C15A5012F1C7AA98B00E8]]></AD_FIELDGROUP_ID>
 <!--4260-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
-<!--4260-->  <DISPLAYLENGTH><![CDATA[40]]></DISPLAYLENGTH>
+<!--4260-->  <DISPLAYLENGTH><![CDATA[60]]></DISPLAYLENGTH>
 <!--4260-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
 <!--4260-->  <SEQNO><![CDATA[120]]></SEQNO>
 <!--4260-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>