details: /erp/devel/pi/rev/1d302dd34cee
changeset: 9324:1d302dd34cee
user: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
date: Thu Dec 23 11:42:18 2010 +0100
summary: [OBCQL] Added missing foreign key for AD_TAB_ID in OBCQL_QUERY_COLUMN
details: /erp/devel/pi/rev/63260e2b151b
changeset: 9325:63260e2b151b
user: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
date: Thu Dec 23 11:42:46 2010 +0100
summary: [OBCQL] Removed not needed decimals on WIDTH and SEQNO columns of
OBCQL_QUERY_COLUMN
diffstat:
modules/org.openbravo.client.querylist/src-db/database/model/tables/OBCQL_QUERY_COLUMN.xml
| 3 +
modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_QUERY_COLUMN.xml
| 32 +++++-----
2 files changed, 19 insertions(+), 16 deletions(-)
diffs (112 lines):
diff -r ade9c029d150 -r 63260e2b151b
modules/org.openbravo.client.querylist/src-db/database/model/tables/OBCQL_QUERY_COLUMN.xml
---
a/modules/org.openbravo.client.querylist/src-db/database/model/tables/OBCQL_QUERY_COLUMN.xml
Thu Dec 23 11:32:09 2010 +0100
+++
b/modules/org.openbravo.client.querylist/src-db/database/model/tables/OBCQL_QUERY_COLUMN.xml
Thu Dec 23 11:42:46 2010 +0100
@@ -81,6 +81,9 @@
<default/>
<onCreateDefault/>
</column>
+ <foreign-key foreignTable="AD_TAB" name="OBCQL_QUERY_COLUMN_ADTAB">
+ <reference local="AD_TAB_ID" foreign="AD_TAB_ID"/>
+ </foreign-key>
<foreign-key foreignTable="AD_CLIENT" name="OBCQL_QUERY_COLUMN_CLIENT">
<reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
</foreign-key>
diff -r ade9c029d150 -r 63260e2b151b
modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_QUERY_COLUMN.xml
---
a/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_QUERY_COLUMN.xml
Thu Dec 23 11:32:09 2010 +0100
+++
b/modules/org.openbravo.client.querylist/src-db/database/sourcedata/OBCQL_QUERY_COLUMN.xml
Thu Dec 23 11:42:46 2010 +0100
@@ -41,9 +41,9 @@
<!--1FCFFA0840074019BF84BBD9E507CB91-->
<OBCQL_WIDGET_QUERY_ID><![CDATA[58BCB96595FA45678CC1423402238309]]></OBCQL_WIDGET_QUERY_ID>
<!--1FCFFA0840074019BF84BBD9E507CB91-->
<DISPLAY_EXPRESSION><![CDATA[invoiceDate]]></DISPLAY_EXPRESSION>
<!--1FCFFA0840074019BF84BBD9E507CB91--> <NAME><![CDATA[Date]]></NAME>
-<!--1FCFFA0840074019BF84BBD9E507CB91--> <WIDTH><![CDATA[100.0000]]></WIDTH>
+<!--1FCFFA0840074019BF84BBD9E507CB91--> <WIDTH><![CDATA[100]]></WIDTH>
<!--1FCFFA0840074019BF84BBD9E507CB91-->
<LINK_EXPRESSION><![CDATA[invoiceId]]></LINK_EXPRESSION>
-<!--1FCFFA0840074019BF84BBD9E507CB91--> <SEQNO><![CDATA[30.0000]]></SEQNO>
+<!--1FCFFA0840074019BF84BBD9E507CB91--> <SEQNO><![CDATA[30]]></SEQNO>
<!--1FCFFA0840074019BF84BBD9E507CB91-->
<AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
<!--1FCFFA0840074019BF84BBD9E507CB91--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
<!--1FCFFA0840074019BF84BBD9E507CB91--> <HAS_LINK><![CDATA[Y]]></HAS_LINK>
@@ -73,9 +73,9 @@
<!--379830F53AF44639B79DB5AB113A575F-->
<OBCQL_WIDGET_QUERY_ID><![CDATA[1EF87E8E961A4E5BA3B41E1AB772B47C]]></OBCQL_WIDGET_QUERY_ID>
<!--379830F53AF44639B79DB5AB113A575F-->
<DISPLAY_EXPRESSION><![CDATA[documentNo]]></DISPLAY_EXPRESSION>
<!--379830F53AF44639B79DB5AB113A575F--> <NAME><![CDATA[Document
Number]]></NAME>
-<!--379830F53AF44639B79DB5AB113A575F--> <WIDTH><![CDATA[100.0000]]></WIDTH>
+<!--379830F53AF44639B79DB5AB113A575F--> <WIDTH><![CDATA[100]]></WIDTH>
<!--379830F53AF44639B79DB5AB113A575F-->
<LINK_EXPRESSION><![CDATA[invoiceId]]></LINK_EXPRESSION>
-<!--379830F53AF44639B79DB5AB113A575F--> <SEQNO><![CDATA[10.0000]]></SEQNO>
+<!--379830F53AF44639B79DB5AB113A575F--> <SEQNO><![CDATA[10]]></SEQNO>
<!--379830F53AF44639B79DB5AB113A575F-->
<AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
<!--379830F53AF44639B79DB5AB113A575F--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
<!--379830F53AF44639B79DB5AB113A575F--> <HAS_LINK><![CDATA[Y]]></HAS_LINK>
@@ -90,9 +90,9 @@
<!--3C3DBC6021C94CFFA82AF855A7AF6C2F-->
<OBCQL_WIDGET_QUERY_ID><![CDATA[1EF87E8E961A4E5BA3B41E1AB772B47C]]></OBCQL_WIDGET_QUERY_ID>
<!--3C3DBC6021C94CFFA82AF855A7AF6C2F-->
<DISPLAY_EXPRESSION><![CDATA[businessPartnerName]]></DISPLAY_EXPRESSION>
<!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <NAME><![CDATA[Business
Partner]]></NAME>
-<!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <WIDTH><![CDATA[100.0000]]></WIDTH>
+<!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <WIDTH><![CDATA[100]]></WIDTH>
<!--3C3DBC6021C94CFFA82AF855A7AF6C2F-->
<LINK_EXPRESSION><![CDATA[invoiceId]]></LINK_EXPRESSION>
-<!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <SEQNO><![CDATA[20.0000]]></SEQNO>
+<!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <SEQNO><![CDATA[20]]></SEQNO>
<!--3C3DBC6021C94CFFA82AF855A7AF6C2F-->
<AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
<!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
<!--3C3DBC6021C94CFFA82AF855A7AF6C2F--> <HAS_LINK><![CDATA[Y]]></HAS_LINK>
@@ -107,9 +107,9 @@
<!--51429339D294475986634D7E876F4A53-->
<OBCQL_WIDGET_QUERY_ID><![CDATA[58BCB96595FA45678CC1423402238309]]></OBCQL_WIDGET_QUERY_ID>
<!--51429339D294475986634D7E876F4A53-->
<DISPLAY_EXPRESSION><![CDATA[documentNo]]></DISPLAY_EXPRESSION>
<!--51429339D294475986634D7E876F4A53--> <NAME><![CDATA[Document
Number]]></NAME>
-<!--51429339D294475986634D7E876F4A53--> <WIDTH><![CDATA[100.0000]]></WIDTH>
+<!--51429339D294475986634D7E876F4A53--> <WIDTH><![CDATA[100]]></WIDTH>
<!--51429339D294475986634D7E876F4A53-->
<LINK_EXPRESSION><![CDATA[invoiceId]]></LINK_EXPRESSION>
-<!--51429339D294475986634D7E876F4A53--> <SEQNO><![CDATA[10.0000]]></SEQNO>
+<!--51429339D294475986634D7E876F4A53--> <SEQNO><![CDATA[10]]></SEQNO>
<!--51429339D294475986634D7E876F4A53-->
<AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
<!--51429339D294475986634D7E876F4A53--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
<!--51429339D294475986634D7E876F4A53--> <HAS_LINK><![CDATA[Y]]></HAS_LINK>
@@ -139,9 +139,9 @@
<!--742D993ADF7444318F8CAF38DDCB1997-->
<OBCQL_WIDGET_QUERY_ID><![CDATA[58BCB96595FA45678CC1423402238309]]></OBCQL_WIDGET_QUERY_ID>
<!--742D993ADF7444318F8CAF38DDCB1997-->
<DISPLAY_EXPRESSION><![CDATA[businessPartnerName]]></DISPLAY_EXPRESSION>
<!--742D993ADF7444318F8CAF38DDCB1997--> <NAME><![CDATA[Business
Partner]]></NAME>
-<!--742D993ADF7444318F8CAF38DDCB1997--> <WIDTH><![CDATA[100.0000]]></WIDTH>
+<!--742D993ADF7444318F8CAF38DDCB1997--> <WIDTH><![CDATA[100]]></WIDTH>
<!--742D993ADF7444318F8CAF38DDCB1997-->
<LINK_EXPRESSION><![CDATA[invoiceId]]></LINK_EXPRESSION>
-<!--742D993ADF7444318F8CAF38DDCB1997--> <SEQNO><![CDATA[20.0000]]></SEQNO>
+<!--742D993ADF7444318F8CAF38DDCB1997--> <SEQNO><![CDATA[20]]></SEQNO>
<!--742D993ADF7444318F8CAF38DDCB1997-->
<AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
<!--742D993ADF7444318F8CAF38DDCB1997--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
<!--742D993ADF7444318F8CAF38DDCB1997--> <HAS_LINK><![CDATA[Y]]></HAS_LINK>
@@ -156,9 +156,9 @@
<!--BBBF2F44391C43F98B4FDEAF62BE81D1-->
<OBCQL_WIDGET_QUERY_ID><![CDATA[1EF87E8E961A4E5BA3B41E1AB772B47C]]></OBCQL_WIDGET_QUERY_ID>
<!--BBBF2F44391C43F98B4FDEAF62BE81D1-->
<DISPLAY_EXPRESSION><![CDATA[invoiceDate]]></DISPLAY_EXPRESSION>
<!--BBBF2F44391C43F98B4FDEAF62BE81D1--> <NAME><![CDATA[Date]]></NAME>
-<!--BBBF2F44391C43F98B4FDEAF62BE81D1--> <WIDTH><![CDATA[100.0000]]></WIDTH>
+<!--BBBF2F44391C43F98B4FDEAF62BE81D1--> <WIDTH><![CDATA[100]]></WIDTH>
<!--BBBF2F44391C43F98B4FDEAF62BE81D1-->
<LINK_EXPRESSION><![CDATA[invoiceId]]></LINK_EXPRESSION>
-<!--BBBF2F44391C43F98B4FDEAF62BE81D1--> <SEQNO><![CDATA[30.0000]]></SEQNO>
+<!--BBBF2F44391C43F98B4FDEAF62BE81D1--> <SEQNO><![CDATA[30]]></SEQNO>
<!--BBBF2F44391C43F98B4FDEAF62BE81D1-->
<AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
<!--BBBF2F44391C43F98B4FDEAF62BE81D1--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
<!--BBBF2F44391C43F98B4FDEAF62BE81D1--> <HAS_LINK><![CDATA[Y]]></HAS_LINK>
@@ -174,9 +174,9 @@
<!--CDC05CE5642E4327BA12FEA50597A8A3-->
<DISPLAY_EXPRESSION><![CDATA[grandTotalAmount]]></DISPLAY_EXPRESSION>
<!--CDC05CE5642E4327BA12FEA50597A8A3--> <NAME><![CDATA[Amount]]></NAME>
<!--CDC05CE5642E4327BA12FEA50597A8A3-->
<SUMMARIZE_TYPE><![CDATA[sum]]></SUMMARIZE_TYPE>
-<!--CDC05CE5642E4327BA12FEA50597A8A3--> <WIDTH><![CDATA[100.0000]]></WIDTH>
+<!--CDC05CE5642E4327BA12FEA50597A8A3--> <WIDTH><![CDATA[100]]></WIDTH>
<!--CDC05CE5642E4327BA12FEA50597A8A3-->
<LINK_EXPRESSION><![CDATA[invoiceId]]></LINK_EXPRESSION>
-<!--CDC05CE5642E4327BA12FEA50597A8A3--> <SEQNO><![CDATA[40.0000]]></SEQNO>
+<!--CDC05CE5642E4327BA12FEA50597A8A3--> <SEQNO><![CDATA[40]]></SEQNO>
<!--CDC05CE5642E4327BA12FEA50597A8A3-->
<AD_REFERENCE_ID><![CDATA[12]]></AD_REFERENCE_ID>
<!--CDC05CE5642E4327BA12FEA50597A8A3--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
<!--CDC05CE5642E4327BA12FEA50597A8A3--> <HAS_LINK><![CDATA[Y]]></HAS_LINK>
@@ -192,9 +192,9 @@
<!--FAB0DB1A67D948DB85AD5918B7845ABF-->
<DISPLAY_EXPRESSION><![CDATA[grandTotalAmount]]></DISPLAY_EXPRESSION>
<!--FAB0DB1A67D948DB85AD5918B7845ABF--> <NAME><![CDATA[Amount]]></NAME>
<!--FAB0DB1A67D948DB85AD5918B7845ABF-->
<SUMMARIZE_TYPE><![CDATA[sum]]></SUMMARIZE_TYPE>
-<!--FAB0DB1A67D948DB85AD5918B7845ABF--> <WIDTH><![CDATA[100.0000]]></WIDTH>
+<!--FAB0DB1A67D948DB85AD5918B7845ABF--> <WIDTH><![CDATA[100]]></WIDTH>
<!--FAB0DB1A67D948DB85AD5918B7845ABF-->
<LINK_EXPRESSION><![CDATA[invoiceId]]></LINK_EXPRESSION>
-<!--FAB0DB1A67D948DB85AD5918B7845ABF--> <SEQNO><![CDATA[40.0000]]></SEQNO>
+<!--FAB0DB1A67D948DB85AD5918B7845ABF--> <SEQNO><![CDATA[40]]></SEQNO>
<!--FAB0DB1A67D948DB85AD5918B7845ABF-->
<AD_REFERENCE_ID><![CDATA[12]]></AD_REFERENCE_ID>
<!--FAB0DB1A67D948DB85AD5918B7845ABF--> <INCLUDE_IN><![CDATA[W]]></INCLUDE_IN>
<!--FAB0DB1A67D948DB85AD5918B7845ABF--> <HAS_LINK><![CDATA[Y]]></HAS_LINK>
------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
