Fixes Issue 9277: Is not possible to include the same Product/Product Category in two different External Point of Sales
authorHarikrishnan Raja <harikrishnan.raja@openbravo.com>
Thu, 02 Jul 2009 15:01:57 +0530
changeset 4088 683280592d18
parent 4087 137c92e9d8a7
child 4089 dafdea02ffcf
Fixes Issue 9277: Is not possible to include the same Product/Product Category in two different External Point of Sales
src-db/database/model/tables/C_EXTERNALPOS_CATEGORY.xml
src-db/database/model/tables/C_EXTERNALPOS_PRODUCT.xml
--- a/src-db/database/model/tables/C_EXTERNALPOS_CATEGORY.xml	Wed Jul 01 23:12:30 2009 +0200
+++ b/src-db/database/model/tables/C_EXTERNALPOS_CATEGORY.xml	Thu Jul 02 15:01:57 2009 +0530
@@ -55,6 +55,7 @@
       </foreign-key>
       <unique name="C_EXTPOSCAT_PRODCATEGORY_UN">
         <unique-column name="M_PRODUCT_CATEGORY_ID"/>
+        <unique-column name="C_EXTERNALPOS_ID"/>
       </unique>
       <check name="C_EXTERNALPOS_C_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
--- a/src-db/database/model/tables/C_EXTERNALPOS_PRODUCT.xml	Wed Jul 01 23:12:30 2009 +0200
+++ b/src-db/database/model/tables/C_EXTERNALPOS_PRODUCT.xml	Thu Jul 02 15:01:57 2009 +0530
@@ -55,6 +55,7 @@
       </foreign-key>
       <unique name="C_EXTPOSPROD_PRODUCT_UN">
         <unique-column name="M_PRODUCT_ID"/>
+        <unique-column name="C_EXTERNALPOS_ID"/>
       </unique>
     </table>
   </database>