Fixes Issue 0025593: Changing constraint to unique index
authorShankar Balachandran <shankar.balachandran@openbravo.com>
Thu, 30 Jan 2014 12:46:53 +0530
changeset 537 c008fb1242ed
parent 536 faa3f7e05223
child 538 f7c97d2f384c
Fixes Issue 0025593: Changing constraint to unique index

Is not possible to enter more than one datasource table in ORACLE.
There is a unique constraint called AD_TABLE_CLASSNAME_PACKAGE_UN in AD_TABLE that has the fields: CLASSNAME and AD_PACKAGE_ID.
Changed the constraint to unique index to solve this issue.
model/src-db/database/model/tables/AD_TABLE.xml
--- a/model/src-db/database/model/tables/AD_TABLE.xml	Fri Jan 24 18:09:18 2014 +0530
+++ b/model/src-db/database/model/tables/AD_TABLE.xml	Thu Jan 30 12:46:53 2014 +0530
@@ -157,10 +157,10 @@
       <index name="AD_TABLE_PACKAGE_IDX" unique="false">
         <index-column name="AD_PACKAGE_ID"/>
       </index>
-      <unique name="AD_TABLE_CLASSNAME_PACKAGE_UN">
-        <unique-column name="CLASSNAME"/>
-        <unique-column name="AD_PACKAGE_ID"/>
-      </unique>
+      <index name="AD_TABLE_CLASSNAME_PACKAGE_UN" unique="true">
+        <index-column name="CLASSNAME"/>
+        <index-column name="AD_PACKAGE_ID"/>
+      </index>
       <unique name="AD_TABLE_NAME">
         <unique-column name="NAME"/>
       </unique>