details:   /erp/devel/pi/rev/93dda800a37d
changeset: 6489:93dda800a37d
user:      David Alsasua <david.alsasua <at> openbravo.com>
date:      Thu Feb 25 11:04:05 2010 +0100
summary:   Fixes issue 12438: Uncorrect FK in Fact_acct

diffstat:

 src-db/database/model/tables/C_BUDGETLINE.xml       |  6 ------
 src-db/database/model/tables/C_VALIDCOMBINATION.xml |  6 ------
 src-db/database/model/tables/FACT_ACCT.xml          |  6 ------
 src-db/database/model/tables/I_GLJOURNAL.xml        |  6 ------
 4 files changed, 0 insertions(+), 24 deletions(-)

diffs (64 lines):

diff -r 46657e4bb4ad -r 93dda800a37d 
src-db/database/model/tables/C_BUDGETLINE.xml
--- a/src-db/database/model/tables/C_BUDGETLINE.xml     Thu Feb 25 13:33:59 
2010 +0530
+++ b/src-db/database/model/tables/C_BUDGETLINE.xml     Thu Feb 25 11:04:05 
2010 +0100
@@ -148,12 +148,6 @@
       <foreign-key foreignTable="C_PERIOD" name="C_BUDGETLINE_C_PERIOD">
         <reference local="C_PERIOD_ID" foreign="C_PERIOD_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="C_ELEMENTVALUE" name="C_BUDGETLINE_USER1">
-        <reference local="USER1_ID" foreign="C_ELEMENTVALUE_ID"/>
-      </foreign-key>
-      <foreign-key foreignTable="C_ELEMENTVALUE" name="C_BUDGETLINE_USER2">
-        <reference local="USER2_ID" foreign="C_ELEMENTVALUE_ID"/>
-      </foreign-key>
       <foreign-key foreignTable="C_BPARTNER" name="C_BUSPARTNER_C_BUDGETLINE">
         <reference local="C_BPARTNER_ID" foreign="C_BPARTNER_ID"/>
       </foreign-key>
diff -r 46657e4bb4ad -r 93dda800a37d 
src-db/database/model/tables/C_VALIDCOMBINATION.xml
--- a/src-db/database/model/tables/C_VALIDCOMBINATION.xml       Thu Feb 25 
13:33:59 2010 +0530
+++ b/src-db/database/model/tables/C_VALIDCOMBINATION.xml       Thu Feb 25 
11:04:05 2010 +0100
@@ -140,12 +140,6 @@
       <foreign-key foreignTable="M_PRODUCT" 
name="C_VALIDCOMBINATION_M_PRODUCT">
         <reference local="M_PRODUCT_ID" foreign="M_PRODUCT_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="C_ELEMENTVALUE" 
name="C_VALIDCOMBINATION_USER1">
-        <reference local="USER1_ID" foreign="C_ELEMENTVALUE_ID"/>
-      </foreign-key>
-      <foreign-key foreignTable="C_ELEMENTVALUE" 
name="C_VALIDCOMBINATION_USER2">
-        <reference local="USER2_ID" foreign="C_ELEMENTVALUE_ID"/>
-      </foreign-key>
       <index name="C_VALIDCOMBINATION_ALIAS" unique="false">
         <index-column name="AD_CLIENT_ID"/>
         <index-column name="ALIAS"/>
diff -r 46657e4bb4ad -r 93dda800a37d src-db/database/model/tables/FACT_ACCT.xml
--- a/src-db/database/model/tables/FACT_ACCT.xml        Thu Feb 25 13:33:59 
2010 +0530
+++ b/src-db/database/model/tables/FACT_ACCT.xml        Thu Feb 25 11:04:05 
2010 +0100
@@ -263,12 +263,6 @@
       <foreign-key foreignTable="M_LOCATOR" name="FACT_ACCT_M_LOCATOR">
         <reference local="M_LOCATOR_ID" foreign="M_LOCATOR_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="C_ELEMENTVALUE" name="FACT_ACCT_USER1">
-        <reference local="USER1_ID" foreign="C_ELEMENTVALUE_ID"/>
-      </foreign-key>
-      <foreign-key foreignTable="C_ELEMENTVALUE" name="FACT_ACCT_USER2">
-        <reference local="USER2_ID" foreign="C_ELEMENTVALUE_ID"/>
-      </foreign-key>
       <foreign-key foreignTable="M_PRODUCT" name="M_PRODUCT_FACT_ACCT">
         <reference local="M_PRODUCT_ID" foreign="M_PRODUCT_ID"/>
       </foreign-key>
diff -r 46657e4bb4ad -r 93dda800a37d 
src-db/database/model/tables/I_GLJOURNAL.xml
--- a/src-db/database/model/tables/I_GLJOURNAL.xml      Thu Feb 25 13:33:59 
2010 +0530
+++ b/src-db/database/model/tables/I_GLJOURNAL.xml      Thu Feb 25 11:04:05 
2010 +0100
@@ -322,12 +322,6 @@
       <foreign-key foreignTable="M_PRODUCT" name="I_GLJOURNAL_M_PRODUCT">
         <reference local="M_PRODUCT_ID" foreign="M_PRODUCT_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="C_ELEMENTVALUE" name="I_GLJOURNAL_USER1">
-        <reference local="USER1_ID" foreign="C_ELEMENTVALUE_ID"/>
-      </foreign-key>
-      <foreign-key foreignTable="C_ELEMENTVALUE" name="I_GLJOURNAL_USER2">
-        <reference local="USER2_ID" foreign="C_ELEMENTVALUE_ID"/>
-      </foreign-key>
       <check name="I_GLJOURNAL_I_ISIMPORTED_CHK"><![CDATA[I_ISIMPORTED IN 
('Y', 'N')]]></check>
       <check name="I_GLJOURNAL_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 
'N')]]></check>
       <check name="I_GLJOURNAL_PROCESSED_CHECK"><![CDATA[PROCESSED IN ('Y', 
'N')]]></check>

------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to