details: https://code.openbravo.com/erp/devel/pi/rev/751258826d60
changeset: 18559:751258826d60
user: Ioritz Cia <ioritz.cia <at> openbravo.com>
date: Thu Nov 15 09:44:09 2012 +0100
summary: Fixes issue 21886: Restrictions in M_PRODUCT_PO can not be enforced.
diffstat:
src-db/database/model/tables/M_PRODUCT_PO.xml | 6 +-----
src-db/database/sourcedata/AD_COLUMN.xml | 2 +-
2 files changed, 2 insertions(+), 6 deletions(-)
diffs (35 lines):
diff -r 506b45ab88e4 -r 751258826d60
src-db/database/model/tables/M_PRODUCT_PO.xml
--- a/src-db/database/model/tables/M_PRODUCT_PO.xml Sun Oct 28 18:50:13
2012 +0100
+++ b/src-db/database/model/tables/M_PRODUCT_PO.xml Thu Nov 15 09:44:09
2012 +0100
@@ -73,7 +73,7 @@
<default><![CDATA[0]]></default>
<onCreateDefault/>
</column>
- <column name="VENDORPRODUCTNO" primaryKey="false" required="true"
type="NVARCHAR" size="40" autoIncrement="false">
+ <column name="VENDORPRODUCTNO" primaryKey="false" required="false"
type="NVARCHAR" size="40" autoIncrement="false">
<default/>
<onCreateDefault/>
</column>
@@ -159,10 +159,6 @@
<unique-column name="M_PRODUCT_ID"/>
<unique-column name="C_BPARTNER_ID"/>
</unique>
- <unique name="M_PRODUCT_PO_VENDORPRODNO">
- <unique-column name="C_BPARTNER_ID"/>
- <unique-column name="VENDORPRODUCTNO"/>
- </unique>
<check name="M_PRODUCT_PO_DISCONTINUED_CHK"><![CDATA[DISCONTINUED IN
('Y', 'N')]]></check>
<check name="M_PRODUCT_PO_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y',
'N')]]></check>
<check name="M_PRODUCT_PO_ISCURRENTVEND_CHK"><![CDATA[ISCURRENTVENDOR IN
('Y', 'N')]]></check>
diff -r 506b45ab88e4 -r 751258826d60 src-db/database/sourcedata/AD_COLUMN.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml Sun Oct 28 18:50:13 2012 +0100
+++ b/src-db/database/sourcedata/AD_COLUMN.xml Thu Nov 15 09:44:09 2012 +0100
@@ -39746,7 +39746,7 @@
<!--2709--> <DEFAULTVALUE><![CDATA[@Value@]]></DEFAULTVALUE>
<!--2709--> <ISKEY><![CDATA[N]]></ISKEY>
<!--2709--> <ISPARENT><![CDATA[N]]></ISPARENT>
-<!--2709--> <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--2709--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
<!--2709--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
<!--2709--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
<!--2709--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
------------------------------------------------------------------------------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases, vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
