Fixes Issue 41485. Adds new Database Constraint to the Table.
authorDavid Miguelez <david.miguelez@openbravo.com>
Tue, 30 Jul 2019 12:51:15 +0200
changeset 903 207ebeef9c2b
parent 902 9323caf4d782
child 904 3c417ba9bcbc
Fixes Issue 41485. Adds new Database Constraint to the Table.
model/src-db/database/model/tables/M_CH_VALUE.xml
--- a/model/src-db/database/model/tables/M_CH_VALUE.xml	Thu Jul 25 00:52:51 2019 +0530
+++ b/model/src-db/database/model/tables/M_CH_VALUE.xml	Tue Jul 30 12:51:15 2019 +0200
@@ -69,6 +69,10 @@
       <index name="M_CH_VALUE_CHARACTERISTIC" unique="false">
         <index-column name="M_CHARACTERISTIC_ID"/>
       </index>
+      <unique name="M_CH_VALUE_NAME">
+        <unique-column name="M_CHARACTERISTIC_ID"/>
+        <unique-column name="NAME"/>
+      </unique>
       <check name="M_CH_VALUE_ISACTIVE"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
       <check name="M_CH_VALUE_ISSUMMARY"><![CDATA[ISSUMMARY IN ('Y', 'N')]]></check>
     </table>