details:   /erp/erp/devel/api-checks/rev/14ea2d987800
changeset: 34:14ea2d987800
user:      Vinoth Babu <vinoth.babu <at> openbravo.com>
date:      Thu Aug 20 17:07:34 2009 +0530
summary:   Commit for Unique constraint added: table: C_ELEMENTVALUE

diffstat:

 model/model/tables/C_ELEMENTVALUE.xml |  4 ++++
 1 files changed, 4 insertions(+), 0 deletions(-)

diffs (14 lines):

diff -r 4caed150ac56 -r 14ea2d987800 model/model/tables/C_ELEMENTVALUE.xml
--- a/model/model/tables/C_ELEMENTVALUE.xml     Wed Aug 19 17:10:18 2009 +0200
+++ b/model/model/tables/C_ELEMENTVALUE.xml     Thu Aug 20 17:07:34 2009 +0530
@@ -135,6 +135,10 @@
       <index name="C_ELEMENTVALUE_NAME" unique="false">
         <index-column name="NAME"/>
       </index>
+      <unique name="C_ELEMENTVALUE_VALUE">
+        <unique-column name="C_ELEMENT_ID"/>
+        <unique-column name="VALUE"/>
+      </unique>
       <check name="C_ELEMENTVALUE_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 
'N')]]></check>
       <check name="CELEMVAL_ISBANKACCOUNT_CHECK"><![CDATA[ISBANKACCOUNT IN 
('Y', 'N')]]></check>
       <check name="CELEMVAL_ISDOCCONTROL_CHECK"><![CDATA[ISDOCCONTROLLED IN 
('Y', 'N')]]></check>

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to