details: https://code.openbravo.com/erp/devel/pi/rev/50d4546d8a8b
changeset: 13305:50d4546d8a8b
user: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
date: Wed Jul 27 11:34:53 2011 +0200
summary: Fixed bug 18092: Added contact field inside Organization |
Information
diffstat:
src-db/database/model/tables/AD_ORGINFO.xml | 7 ++++++
src-db/database/sourcedata/AD_COLUMN.xml | 33 +++++++++++++++++++++++++++++
src-db/database/sourcedata/AD_FIELD.xml | 27 +++++++++++++++++++++++
3 files changed, 67 insertions(+), 0 deletions(-)
diffs (104 lines):
diff -r 700fb1166e8a -r 50d4546d8a8b src-db/database/model/tables/AD_ORGINFO.xml
--- a/src-db/database/model/tables/AD_ORGINFO.xml Wed Jul 27 13:44:02
2011 +0200
+++ b/src-db/database/model/tables/AD_ORGINFO.xml Wed Jul 27 11:34:53
2011 +0200
@@ -69,6 +69,10 @@
<default/>
<onCreateDefault/>
</column>
+ <column name="AD_USER_ID" primaryKey="false" required="false"
type="VARCHAR" size="32" autoIncrement="false">
+ <default/>
+ <onCreateDefault/>
+ </column>
<foreign-key foreignTable="AD_ORG" name="AD_ORG_AD_ORGINFO"
onDelete="cascade">
<reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
</foreign-key>
@@ -84,6 +88,9 @@
<foreign-key foreignTable="AD_IMAGE" name="AD_ORGINFO_IMAGEDOCUM">
<reference local="YOUR_COMPANY_DOCUMENT_IMAGE" foreign="AD_IMAGE_ID"/>
</foreign-key>
+ <foreign-key foreignTable="AD_USER" name="AD_USER_AD_ORGINFO">
+ <reference local="AD_USER_ID" foreign="AD_USER_ID"/>
+ </foreign-key>
<foreign-key foreignTable="C_LOCATION" name="C_LOCATION_AD_ORGINFO">
<reference local="C_LOCATION_ID" foreign="C_LOCATION_ID"/>
</foreign-key>
diff -r 700fb1166e8a -r 50d4546d8a8b src-db/database/sourcedata/AD_COLUMN.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml Wed Jul 27 13:44:02 2011 +0200
+++ b/src-db/database/sourcedata/AD_COLUMN.xml Wed Jul 27 11:34:53 2011 +0200
@@ -257187,6 +257187,39 @@
<!--A8577512171B4D3781C6A49BD3A8370A-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
<!--A8577512171B4D3781C6A49BD3A8370A--></AD_COLUMN>
+<!--A908EA6CF218F9C9E040007F01011582--><AD_COLUMN>
+<!--A908EA6CF218F9C9E040007F01011582-->
<AD_COLUMN_ID><![CDATA[A908EA6CF218F9C9E040007F01011582]]></AD_COLUMN_ID>
+<!--A908EA6CF218F9C9E040007F01011582-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--A908EA6CF218F9C9E040007F01011582--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--A908EA6CF218F9C9E040007F01011582--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--A908EA6CF218F9C9E040007F01011582--> <NAME><![CDATA[User/Contact]]></NAME>
+<!--A908EA6CF218F9C9E040007F01011582--> <DESCRIPTION><![CDATA[An acquaintance
to reach for information related to the business partner.]]></DESCRIPTION>
+<!--A908EA6CF218F9C9E040007F01011582--> <HELP><![CDATA[The User identifies a
unique user in the system. This could be an internal user or a business partner
contact]]></HELP>
+<!--A908EA6CF218F9C9E040007F01011582-->
<COLUMNNAME><![CDATA[AD_User_ID]]></COLUMNNAME>
+<!--A908EA6CF218F9C9E040007F01011582-->
<AD_TABLE_ID><![CDATA[228]]></AD_TABLE_ID>
+<!--A908EA6CF218F9C9E040007F01011582-->
<AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--A908EA6CF218F9C9E040007F01011582-->
<FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--A908EA6CF218F9C9E040007F01011582--> <ISKEY><![CDATA[N]]></ISKEY>
+<!--A908EA6CF218F9C9E040007F01011582--> <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--A908EA6CF218F9C9E040007F01011582-->
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--A908EA6CF218F9C9E040007F01011582-->
<ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--A908EA6CF218F9C9E040007F01011582-->
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--A908EA6CF218F9C9E040007F01011582--> <SEQNO><![CDATA[91]]></SEQNO>
+<!--A908EA6CF218F9C9E040007F01011582-->
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--A908EA6CF218F9C9E040007F01011582-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--A908EA6CF218F9C9E040007F01011582-->
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--A908EA6CF218F9C9E040007F01011582-->
<AD_ELEMENT_ID><![CDATA[138]]></AD_ELEMENT_ID>
+<!--A908EA6CF218F9C9E040007F01011582-->
<ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--A908EA6CF218F9C9E040007F01011582-->
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--A908EA6CF218F9C9E040007F01011582-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--A908EA6CF218F9C9E040007F01011582-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--A908EA6CF218F9C9E040007F01011582-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--A908EA6CF218F9C9E040007F01011582--> <POSITION><![CDATA[18]]></POSITION>
+<!--A908EA6CF218F9C9E040007F01011582-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--A908EA6CF218F9C9E040007F01011582--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--A908EA6CF218F9C9E040007F01011582-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--A908EA6CF218F9C9E040007F01011582--></AD_COLUMN>
+
<!--A9AD9098307E46ECBB9CC712DA6E0302--><AD_COLUMN>
<!--A9AD9098307E46ECBB9CC712DA6E0302-->
<AD_COLUMN_ID><![CDATA[A9AD9098307E46ECBB9CC712DA6E0302]]></AD_COLUMN_ID>
<!--A9AD9098307E46ECBB9CC712DA6E0302-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff -r 700fb1166e8a -r 50d4546d8a8b src-db/database/sourcedata/AD_FIELD.xml
--- a/src-db/database/sourcedata/AD_FIELD.xml Wed Jul 27 13:44:02 2011 +0200
+++ b/src-db/database/sourcedata/AD_FIELD.xml Wed Jul 27 11:34:53 2011 +0200
@@ -188148,6 +188148,33 @@
<!--A8B23A0E8C3E428F90882F96159274C4-->
<ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
<!--A8B23A0E8C3E428F90882F96159274C4--></AD_FIELD>
+<!--A908E57D081C6863E040007F01011588--><AD_FIELD>
+<!--A908E57D081C6863E040007F01011588-->
<AD_FIELD_ID><![CDATA[A908E57D081C6863E040007F01011588]]></AD_FIELD_ID>
+<!--A908E57D081C6863E040007F01011588-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--A908E57D081C6863E040007F01011588--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--A908E57D081C6863E040007F01011588--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--A908E57D081C6863E040007F01011588--> <NAME><![CDATA[Contact]]></NAME>
+<!--A908E57D081C6863E040007F01011588--> <DESCRIPTION><![CDATA[An acquaintance
to reach for information related to the organization.]]></DESCRIPTION>
+<!--A908E57D081C6863E040007F01011588--> <HELP><![CDATA[The User identifies a
unique user in the system. This could be an internal user or a business
partner/organization contact]]></HELP>
+<!--A908E57D081C6863E040007F01011588-->
<ISCENTRALLYMAINTAINED><![CDATA[N]]></ISCENTRALLYMAINTAINED>
+<!--A908E57D081C6863E040007F01011588--> <AD_TAB_ID><![CDATA[170]]></AD_TAB_ID>
+<!--A908E57D081C6863E040007F01011588-->
<AD_COLUMN_ID><![CDATA[A908EA6CF218F9C9E040007F01011582]]></AD_COLUMN_ID>
+<!--A908E57D081C6863E040007F01011588-->
<ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--A908E57D081C6863E040007F01011588-->
<DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
+<!--A908E57D081C6863E040007F01011588--> <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--A908E57D081C6863E040007F01011588--> <SEQNO><![CDATA[55]]></SEQNO>
+<!--A908E57D081C6863E040007F01011588--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--A908E57D081C6863E040007F01011588-->
<ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--A908E57D081C6863E040007F01011588-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--A908E57D081C6863E040007F01011588-->
<SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--A908E57D081C6863E040007F01011588-->
<ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--A908E57D081C6863E040007F01011588-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--A908E57D081C6863E040007F01011588-->
<GRID_SEQNO><![CDATA[55]]></GRID_SEQNO>
+<!--A908E57D081C6863E040007F01011588-->
<STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--A908E57D081C6863E040007F01011588-->
<STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--A908E57D081C6863E040007F01011588-->
<ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--A908E57D081C6863E040007F01011588--></AD_FIELD>
+
<!--ABA8AFDB0CDD49B9B20A24D2D8127B38--><AD_FIELD>
<!--ABA8AFDB0CDD49B9B20A24D2D8127B38-->
<AD_FIELD_ID><![CDATA[ABA8AFDB0CDD49B9B20A24D2D8127B38]]></AD_FIELD_ID>
<!--ABA8AFDB0CDD49B9B20A24D2D8127B38-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
------------------------------------------------------------------------------
Got Input? Slashdot Needs You.
Take our quick survey online. Come on, we don't ask for help often.
Plus, you'll get a chance to win $100 to spend on ThinkGeek.
http://p.sf.net/sfu/slashdot-survey
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
