Fixes issue 15337: try-api 268 fails with a warning
authorSivaraman Rajagopal <sivaraman.rajagopal@openbravo.com>
Wed, 01 Dec 2010 18:30:07 +0530
changeset 181 6b4e2ac1b439
parent 180 db215dba3dd8
child 182 edee8957c30c
Fixes issue 15337: try-api 268 fails with a warning

The following constraint have been added for both MA_SEQUENCEPRODUCT and MA_WRPHASEPRODUCT tables.

((QUANTITYORDER IS NULL) AND (M_PRODUCT_UOM_ID IS NULL)) OR ((QUANTITYORDER IS NOT NULL) AND (M_PRODUCT_UOM_ID IS NOT NULL))

Impacts:
None
model/model/tables/MA_SEQUENCEPRODUCT.xml
model/model/tables/MA_WRPHASEPRODUCT.xml
--- a/model/model/tables/MA_SEQUENCEPRODUCT.xml	Tue Nov 30 17:48:38 2010 +0100
+++ b/model/model/tables/MA_SEQUENCEPRODUCT.xml	Wed Dec 01 18:30:07 2010 +0530
@@ -103,5 +103,6 @@
         <index-column name="MA_SEQUENCE_ID"/>
       </index>
       <check name="MA_SEQUENCEPROD_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
+      <check name="MA_SEQUENCEPRODUCT_CHECK1"><![CDATA[((QUANTITYORDER IS NULL) AND (M_PRODUCT_UOM_ID IS NULL)) OR ((QUANTITYORDER IS NOT NULL) AND (M_PRODUCT_UOM_ID IS NOT NULL))]]></check>
     </table>
   </database>
--- a/model/model/tables/MA_WRPHASEPRODUCT.xml	Tue Nov 30 17:48:38 2010 +0100
+++ b/model/model/tables/MA_WRPHASEPRODUCT.xml	Wed Dec 01 18:30:07 2010 +0530
@@ -91,6 +91,7 @@
         <index-column name="M_PRODUCT_ID"/>
         <index-column name="MA_WRPHASE_ID"/>
       </index>
+      <check name="MA_WRPHASEPRODUCT_CHECK1"><![CDATA[((QUANTITYORDER IS NULL) AND (M_PRODUCT_UOM_ID IS NULL)) OR ((QUANTITYORDER IS NOT NULL) AND (M_PRODUCT_UOM_ID IS NOT NULL))]]></check>
       <check name="MA_WRPHASEPRODUCT_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
       <check name="MA_WRPHASEPRODUCT_PRODUCTI_CHK"><![CDATA[PRODUCTIONTYPE IN ('+', '-')]]></check>
     </table>