details: /erp/devel/main/rev/bcc76c8a4527
changeset: 9063:bcc76c8a4527
user: Sivaraman Rajagopal <sivaraman.rajagopal <at> openbravo.com>
date: Wed Dec 01 18:25:23 2010 +0530
summary: Fixes issue 15139: Lack a constraint in the tables
MA_Sequenceproduct and MA_Wrphaseproduct
the following constrains 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
details: /erp/devel/main/rev/36e9c0a1809f
changeset: 9064:36e9c0a1809f
user: RM packaging bot <staff.rm <at> openbravo.com>
date: Thu Dec 02 03:52:59 2010 +0000
summary: CI: promote changesets from pi to main
diffstat:
src-db/database/model/tables/MA_SEQUENCEPRODUCT.xml | 1 +
src-db/database/model/tables/MA_WRPHASEPRODUCT.xml | 1 +
src-db/database/sourcedata/AD_MESSAGE.xml | 22 +++++++++++++++++++++
src-db/database/sourcedata/AD_MODULE.xml | 4 +-
4 files changed, 26 insertions(+), 2 deletions(-)
diffs (81 lines):
diff -r 47efb3cb3ff3 -r 36e9c0a1809f
src-db/database/model/tables/MA_SEQUENCEPRODUCT.xml
--- a/src-db/database/model/tables/MA_SEQUENCEPRODUCT.xml Wed Dec 01
12:34:26 2010 +0100
+++ b/src-db/database/model/tables/MA_SEQUENCEPRODUCT.xml Thu Dec 02
03:52:59 2010 +0000
@@ -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>
diff -r 47efb3cb3ff3 -r 36e9c0a1809f
src-db/database/model/tables/MA_WRPHASEPRODUCT.xml
--- a/src-db/database/model/tables/MA_WRPHASEPRODUCT.xml Wed Dec 01
12:34:26 2010 +0100
+++ b/src-db/database/model/tables/MA_WRPHASEPRODUCT.xml Thu Dec 02
03:52:59 2010 +0000
@@ -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>
diff -r 47efb3cb3ff3 -r 36e9c0a1809f src-db/database/sourcedata/AD_MESSAGE.xml
--- a/src-db/database/sourcedata/AD_MESSAGE.xml Wed Dec 01 12:34:26 2010 +0100
+++ b/src-db/database/sourcedata/AD_MESSAGE.xml Thu Dec 02 03:52:59 2010 +0000
@@ -29553,6 +29553,17 @@
<!--02758CBBA66D42108380E648EF7C026E-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--02758CBBA66D42108380E648EF7C026E--></AD_MESSAGE>
+<!--0285053A21CD44D78A85AB89B3D7AE81--><AD_MESSAGE>
+<!--0285053A21CD44D78A85AB89B3D7AE81-->
<AD_MESSAGE_ID><![CDATA[0285053A21CD44D78A85AB89B3D7AE81]]></AD_MESSAGE_ID>
+<!--0285053A21CD44D78A85AB89B3D7AE81-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--0285053A21CD44D78A85AB89B3D7AE81--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--0285053A21CD44D78A85AB89B3D7AE81--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--0285053A21CD44D78A85AB89B3D7AE81-->
<VALUE><![CDATA[MA_SEQUENCEPRODUCT_CHECK1]]></VALUE>
+<!--0285053A21CD44D78A85AB89B3D7AE81--> <MSGTEXT><![CDATA[Order Quantity and
Order UOM are co-dependent fields. We can not assign value for one field and
leave other empty.]]></MSGTEXT>
+<!--0285053A21CD44D78A85AB89B3D7AE81--> <MSGTYPE><![CDATA[E]]></MSGTYPE>
+<!--0285053A21CD44D78A85AB89B3D7AE81-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--0285053A21CD44D78A85AB89B3D7AE81--></AD_MESSAGE>
+
<!--03C7B58E00F246E7BA06D153B3DB2D5B--><AD_MESSAGE>
<!--03C7B58E00F246E7BA06D153B3DB2D5B-->
<AD_MESSAGE_ID><![CDATA[03C7B58E00F246E7BA06D153B3DB2D5B]]></AD_MESSAGE_ID>
<!--03C7B58E00F246E7BA06D153B3DB2D5B-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -31872,6 +31883,17 @@
<!--7BF4B33E022E407BB6615E106AC7A8A6-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--7BF4B33E022E407BB6615E106AC7A8A6--></AD_MESSAGE>
+<!--7D189EE376C54A0A877A6FB41C6E2E68--><AD_MESSAGE>
+<!--7D189EE376C54A0A877A6FB41C6E2E68-->
<AD_MESSAGE_ID><![CDATA[7D189EE376C54A0A877A6FB41C6E2E68]]></AD_MESSAGE_ID>
+<!--7D189EE376C54A0A877A6FB41C6E2E68-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--7D189EE376C54A0A877A6FB41C6E2E68--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--7D189EE376C54A0A877A6FB41C6E2E68--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--7D189EE376C54A0A877A6FB41C6E2E68-->
<VALUE><![CDATA[MA_WRPHASEPRODUCT_CHECK1]]></VALUE>
+<!--7D189EE376C54A0A877A6FB41C6E2E68--> <MSGTEXT><![CDATA[Order Quantity and
Order UOM are co-dependent fields. We can not assign value for one field and
leave other empty.]]></MSGTEXT>
+<!--7D189EE376C54A0A877A6FB41C6E2E68--> <MSGTYPE><![CDATA[E]]></MSGTYPE>
+<!--7D189EE376C54A0A877A6FB41C6E2E68-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--7D189EE376C54A0A877A6FB41C6E2E68--></AD_MESSAGE>
+
<!--7DB1074FDA3549A1A211A0A0E16B79A7--><AD_MESSAGE>
<!--7DB1074FDA3549A1A211A0A0E16B79A7-->
<AD_MESSAGE_ID><![CDATA[7DB1074FDA3549A1A211A0A0E16B79A7]]></AD_MESSAGE_ID>
<!--7DB1074FDA3549A1A211A0A0E16B79A7-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff -r 47efb3cb3ff3 -r 36e9c0a1809f src-db/database/sourcedata/AD_MODULE.xml
--- a/src-db/database/sourcedata/AD_MODULE.xml Wed Dec 01 12:34:26 2010 +0100
+++ b/src-db/database/sourcedata/AD_MODULE.xml Thu Dec 02 03:52:59 2010 +0000
@@ -6,7 +6,7 @@
<!--0--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
<!--0--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
<!--0--> <NAME><![CDATA[Core]]></NAME>
-<!--0--> <VERSION><![CDATA[2.50.19053]]></VERSION>
+<!--0--> <VERSION><![CDATA[2.50.19063]]></VERSION>
<!--0--> <DESCRIPTION><![CDATA[Core module is the base one]]></DESCRIPTION>
<!--0--> <HELP><![CDATA[Core module is the base one, all developments in core
are included as part of the standard Openbravo ERP.]]></HELP>
<!--0--> <URL><![CDATA[www.openbravo.com]]></URL>
@@ -22,7 +22,7 @@
<!--0--> <ISTRANSLATIONMODULE><![CDATA[N]]></ISTRANSLATIONMODULE>
<!--0--> <HASREFERENCEDATA><![CDATA[Y]]></HASREFERENCEDATA>
<!--0--> <REFERENCEDATAINFO><![CDATA[Standard document types for orders,
invoices, etc. and settings]]></REFERENCEDATAINFO>
-<!--0--> <VERSION_LABEL><![CDATA[dev]]></VERSION_LABEL>
+<!--0--> <VERSION_LABEL><![CDATA[CI]]></VERSION_LABEL>
<!--0--> <ISCOMMERCIAL><![CDATA[N]]></ISCOMMERCIAL>
<!--0--></AD_MODULE>
------------------------------------------------------------------------------
Increase Visibility of Your 3D Game App & Earn a Chance To Win $500!
Tap into the largest installed PC base & get more eyes on your game by
optimizing for Intel(R) Graphics Technology. Get started today with the
Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs.
http://p.sf.net/sfu/intelisp-dev2dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
