Fixes Issue 24544, 19009. Updates C_Project_Value unique constraint.
authorDavid Miguelez <david.miguelez@openbravo.com>
Wed, 21 Aug 2013 11:01:14 +0200
changeset 21004 6ca87037847e
parent 21003 7fb360627360
child 21005 c56eb50a9239
child 21009 5a759279dc34
Fixes Issue 24544, 19009. Updates C_Project_Value unique constraint.
Now is Client + Organization + Project Category + Value.
src-db/database/model/tables/C_PROJECT.xml
--- a/src-db/database/model/tables/C_PROJECT.xml	Wed Aug 21 10:26:58 2013 +0200
+++ b/src-db/database/model/tables/C_PROJECT.xml	Wed Aug 21 11:01:14 2013 +0200
@@ -344,6 +344,8 @@
       </foreign-key>
       <index name="C_PROJECT_VALUE" unique="true">
         <index-column name="AD_CLIENT_ID"/>
+        <index-column name="AD_ORG_ID"/>
+        <index-column name="PROJECTCATEGORY"/>
         <index-column name="VALUE"/>
       </index>
       <check name="C_PROJECT_GENERATETO_CHECK"><![CDATA[GENERATETO IN ('Y', 'N')]]></check>