fixed bug 0007805: Unistall a module with ad_process fails
authorAsier Lostalé <asier.lostale@openbravo.com>
Wed, 25 Feb 2009 10:55:02 +0100
changeset 3237 20a02b5e1722
parent 3236 e8e56cff06a9
child 3238 f4a2f386a023
fixed bug 0007805: Unistall a module with ad_process fails
src-db/database/model/tables/AD_ALERTRULE.xml
src-db/database/model/tables/AD_ATTACHMENT.xml
src-db/database/model/tables/AD_CHANGELOG.xml
src-db/database/model/tables/AD_CLIENTMODULE.xml
src-db/database/model/tables/AD_COLUMN_ACCESS.xml
src-db/database/model/tables/AD_DIMENSION.xml
src-db/database/model/tables/AD_IMPFORMAT.xml
src-db/database/model/tables/AD_IMPFORMAT_ROW.xml
src-db/database/model/tables/AD_NOTE.xml
src-db/database/model/tables/AD_ORGMODULE.xml
src-db/database/model/tables/AD_PREFERENCE.xml
src-db/database/model/tables/AD_PROCESS_REQUEST.xml
src-db/database/model/tables/AD_PROCESS_SCHEDULING.xml
src-db/database/model/tables/AD_RECORD_ACCESS.xml
src-db/database/model/tables/AD_REF_DATA_LOADED.xml
src-db/database/model/tables/C_ACCTSCHEMA_TABLE.xml
src-db/database/model/tables/C_DOCTYPE.xml
src-db/database/model/tables/C_FILE.xml
src-db/database/model/tables/FACT_ACCT.xml
src-db/database/model/tables/I_ELEMENTVALUE.xml
--- a/src-db/database/model/tables/AD_ALERTRULE.xml	Tue Feb 24 14:26:08 2009 +0100
+++ b/src-db/database/model/tables/AD_ALERTRULE.xml	Wed Feb 25 10:55:02 2009 +0100
@@ -59,7 +59,7 @@
       <foreign-key foreignTable="AD_ORG" name="ADORG_ADALERTRULE">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="AD_TAB" name="ADTAB_ADALTERTRULE">
+      <foreign-key foreignTable="AD_TAB" name="ADTAB_ADALTERTRULE" onDelete="cascade">
         <reference local="AD_TAB_ID" foreign="AD_TAB_ID"/>
       </foreign-key>
     </table>
--- a/src-db/database/model/tables/AD_ATTACHMENT.xml	Tue Feb 24 14:26:08 2009 +0100
+++ b/src-db/database/model/tables/AD_ATTACHMENT.xml	Wed Feb 25 10:55:02 2009 +0100
@@ -66,7 +66,7 @@
       <foreign-key foreignTable="AD_ORG" name="ADORG_ADATTACHMENT">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="AD_TABLE" name="ADTABLE_ADATTACHMENT">
+      <foreign-key foreignTable="AD_TABLE" name="ADTABLE_ADATTACHMENT" onDelete="cascade">
         <reference local="AD_TABLE_ID" foreign="AD_TABLE_ID"/>
       </foreign-key>
       <index name="AD_ATTACHMENT_RECORD" unique="false">
--- a/src-db/database/model/tables/AD_CHANGELOG.xml	Tue Feb 24 14:26:08 2009 +0100
+++ b/src-db/database/model/tables/AD_CHANGELOG.xml	Wed Feb 25 10:55:02 2009 +0100
@@ -60,7 +60,7 @@
       <foreign-key foreignTable="AD_CLIENT" name="ADCLIENT_ADCHANGELOG">
         <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="AD_COLUMN" name="ADCOLUMN_ADCHANGELOG">
+      <foreign-key foreignTable="AD_COLUMN" name="ADCOLUMN_ADCHANGELOG" onDelete="cascade">
         <reference local="AD_COLUMN_ID" foreign="AD_COLUMN_ID"/>
       </foreign-key>
       <foreign-key foreignTable="AD_ORG" name="ADORG_ADCHANGELOG">
@@ -69,7 +69,7 @@
       <foreign-key foreignTable="AD_SESSION" name="ADSESSION_ADCHANGELOG">
         <reference local="AD_SESSION_ID" foreign="AD_SESSION_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="AD_TABLE" name="ADTABLE_ADCHANGELOG">
+      <foreign-key foreignTable="AD_TABLE" name="ADTABLE_ADCHANGELOG" onDelete="cascade">
         <reference local="AD_TABLE_ID" foreign="AD_TABLE_ID"/>
       </foreign-key>
     </table>
--- a/src-db/database/model/tables/AD_CLIENTMODULE.xml	Tue Feb 24 14:26:08 2009 +0100
+++ b/src-db/database/model/tables/AD_CLIENTMODULE.xml	Wed Feb 25 10:55:02 2009 +0100
@@ -40,7 +40,7 @@
       <foreign-key foreignTable="AD_CLIENT" name="ADCLIENT_ADCLIENTMODULE">
         <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="AD_MODULE" name="ADMODULE_ADCLIENTMODULE">
+      <foreign-key foreignTable="AD_MODULE" name="ADMODULE_ADCLIENTMODULE" onDelete="cascade">
         <reference local="AD_MODULE_ID" foreign="AD_MODULE_ID"/>
       </foreign-key>
       <check name="AD_CLIENTMODULE_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
--- a/src-db/database/model/tables/AD_COLUMN_ACCESS.xml	Tue Feb 24 14:26:08 2009 +0100
+++ b/src-db/database/model/tables/AD_COLUMN_ACCESS.xml	Wed Feb 25 10:55:02 2009 +0100
@@ -56,7 +56,7 @@
       <foreign-key foreignTable="AD_CLIENT" name="ADCLIENT_ADCOLUMNACCESS">
         <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="AD_COLUMN" name="ADCOLUMN_ADCOLUMNACCESS">
+      <foreign-key foreignTable="AD_COLUMN" name="ADCOLUMN_ADCOLUMNACCESS" onDelete="cascade">
         <reference local="AD_COLUMN_ID" foreign="AD_COLUMN_ID"/>
       </foreign-key>
       <foreign-key foreignTable="AD_ORG" name="ADORG_ADCOLUMNACCESS">
@@ -65,7 +65,7 @@
       <foreign-key foreignTable="AD_ROLE" name="ADROLE_ADCOLUMNACCESS">
         <reference local="AD_ROLE_ID" foreign="AD_ROLE_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="AD_TABLE" name="ADTABLE_ADCOLUMNACCESS">
+      <foreign-key foreignTable="AD_TABLE" name="ADTABLE_ADCOLUMNACCESS" onDelete="cascade">
         <reference local="AD_TABLE_ID" foreign="AD_TABLE_ID"/>
       </foreign-key>
       <unique name="ADCOLUMNACCESS_ADROLEID_ADC_UN">
--- a/src-db/database/model/tables/AD_DIMENSION.xml	Tue Feb 24 14:26:08 2009 +0100
+++ b/src-db/database/model/tables/AD_DIMENSION.xml	Wed Feb 25 10:55:02 2009 +0100
@@ -67,7 +67,7 @@
       <foreign-key foreignTable="AD_ORG" name="ADORG_ADDIMENSION">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="AD_PROCESS" name="ADPROCESS_ADDIMENSION">
+      <foreign-key foreignTable="AD_PROCESS" name="ADPROCESS_ADDIMENSION" onDelete="cascade">
         <reference local="AD_PROCESS_ID" foreign="AD_PROCESS_ID"/>
       </foreign-key>
     </table>
--- a/src-db/database/model/tables/AD_IMPFORMAT.xml	Tue Feb 24 14:26:08 2009 +0100
+++ b/src-db/database/model/tables/AD_IMPFORMAT.xml	Wed Feb 25 10:55:02 2009 +0100
@@ -59,7 +59,7 @@
       <foreign-key foreignTable="AD_ORG" name="ADORG_ADIMPFORMAT">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="AD_TABLE" name="ADTABLE_ADIMPFORMAT">
+      <foreign-key foreignTable="AD_TABLE" name="ADTABLE_ADIMPFORMAT" onDelete="cascade">
         <reference local="AD_TABLE_ID" foreign="AD_TABLE_ID"/>
       </foreign-key>
       <unique name="AD_IMPFORMAT_NAME">
--- a/src-db/database/model/tables/AD_IMPFORMAT_ROW.xml	Tue Feb 24 14:26:08 2009 +0100
+++ b/src-db/database/model/tables/AD_IMPFORMAT_ROW.xml	Wed Feb 25 10:55:02 2009 +0100
@@ -88,7 +88,7 @@
       <foreign-key foreignTable="AD_CLIENT" name="ADCLIENT_ADIMPFORMATROW">
         <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="AD_COLUMN" name="ADCOLUMN_ADIMPFORMATROW">
+      <foreign-key foreignTable="AD_COLUMN" name="ADCOLUMN_ADIMPFORMATROW" onDelete="cascade">
         <reference local="AD_COLUMN_ID" foreign="AD_COLUMN_ID"/>
       </foreign-key>
       <foreign-key foreignTable="AD_IMPFORMAT" name="ADIMPFORMAT_ADIMPFORMATROW" onDelete="cascade">
--- a/src-db/database/model/tables/AD_NOTE.xml	Tue Feb 24 14:26:08 2009 +0100
+++ b/src-db/database/model/tables/AD_NOTE.xml	Wed Feb 25 10:55:02 2009 +0100
@@ -64,13 +64,13 @@
       <foreign-key foreignTable="AD_CLIENT" name="ADCLIENT_ADNOTE">
         <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="AD_MESSAGE" name="ADMESSAGE_ADNOTE">
+      <foreign-key foreignTable="AD_MESSAGE" name="ADMESSAGE_ADNOTE" onDelete="cascade">
         <reference local="AD_MESSAGE_ID" foreign="AD_MESSAGE_ID"/>
       </foreign-key>
       <foreign-key foreignTable="AD_ORG" name="ADORG_ADNOTE">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="AD_TABLE" name="ADTABLE_ADNOTE">
+      <foreign-key foreignTable="AD_TABLE" name="ADTABLE_ADNOTE" onDelete="cascade">
         <reference local="AD_TABLE_ID" foreign="AD_TABLE_ID"/>
       </foreign-key>
       <foreign-key foreignTable="AD_USER" name="ADUSER_ADNOTE">
--- a/src-db/database/model/tables/AD_ORGMODULE.xml	Tue Feb 24 14:26:08 2009 +0100
+++ b/src-db/database/model/tables/AD_ORGMODULE.xml	Wed Feb 25 10:55:02 2009 +0100
@@ -47,7 +47,7 @@
       <foreign-key foreignTable="AD_CLIENT" name="ADCLIENT_ADORGMODULE">
         <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="AD_MODULE" name="ADMODULE_ADORGMODULE">
+      <foreign-key foreignTable="AD_MODULE" name="ADMODULE_ADORGMODULE" onDelete="cascade">
         <reference local="AD_MODULE_ID" foreign="AD_MODULE_ID"/>
       </foreign-key>
       <check name="AD_ORGMODULE_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
--- a/src-db/database/model/tables/AD_PREFERENCE.xml	Tue Feb 24 14:26:08 2009 +0100
+++ b/src-db/database/model/tables/AD_PREFERENCE.xml	Wed Feb 25 10:55:02 2009 +0100
@@ -58,7 +58,7 @@
       <foreign-key foreignTable="AD_USER" name="AD_USER_PREFERENCE">
         <reference local="AD_USER_ID" foreign="AD_USER_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="AD_WINDOW" name="AD_WINDOW_PREFERENCE">
+      <foreign-key foreignTable="AD_WINDOW" name="AD_WINDOW_PREFERENCE" onDelete="cascade">
         <reference local="AD_WINDOW_ID" foreign="AD_WINDOW_ID"/>
       </foreign-key>
       <unique name="AD_PREFERENCE_ATTRIBUTE">
--- a/src-db/database/model/tables/AD_PROCESS_REQUEST.xml	Tue Feb 24 14:26:08 2009 +0100
+++ b/src-db/database/model/tables/AD_PROCESS_REQUEST.xml	Wed Feb 25 10:55:02 2009 +0100
@@ -203,7 +203,7 @@
       <foreign-key foreignTable="AD_ORG" name="AD_PROCESS_REQUEST_AD_ORG">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="AD_PROCESS" name="AD_PROCESS_REQUEST_AD_PROCESS">
+      <foreign-key foreignTable="AD_PROCESS" name="AD_PROCESS_REQUEST_AD_PROCESS" onDelete="cascade">
         <reference local="AD_PROCESS_ID" foreign="AD_PROCESS_ID"/>
       </foreign-key>
       <foreign-key foreignTable="AD_USER" name="AD_PROCESS_REQUEST_AD_USER">
--- a/src-db/database/model/tables/AD_PROCESS_SCHEDULING.xml	Tue Feb 24 14:26:08 2009 +0100
+++ b/src-db/database/model/tables/AD_PROCESS_SCHEDULING.xml	Wed Feb 25 10:55:02 2009 +0100
@@ -63,7 +63,7 @@
       <foreign-key foreignTable="AD_ORG" name="ORG_FK_PROCESS_SCHEDULING">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="AD_PROCESS" name="PROCESS_FK_PROCESS_SCHEDULING">
+      <foreign-key foreignTable="AD_PROCESS" name="PROCESS_FK_PROCESS_SCHEDULING" onDelete="cascade">
         <reference local="AD_PROCESS_ID" foreign="AD_PROCESS_ID"/>
       </foreign-key>
       <check name="AD_PROCESS_SCHEDULING_ISFT"><![CDATA[ISFULLTIME IN ('Y', 'N')]]></check>
--- a/src-db/database/model/tables/AD_RECORD_ACCESS.xml	Tue Feb 24 14:26:08 2009 +0100
+++ b/src-db/database/model/tables/AD_RECORD_ACCESS.xml	Wed Feb 25 10:55:02 2009 +0100
@@ -62,7 +62,7 @@
       <foreign-key foreignTable="AD_ROLE" name="ADROLE_ARDECORDACCESS">
         <reference local="AD_ROLE_ID" foreign="AD_ROLE_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="AD_TABLE" name="ADTABLE_ADRECORDACCESS">
+      <foreign-key foreignTable="AD_TABLE" name="ADTABLE_ADRECORDACCESS" onDelete="cascade">
         <reference local="AD_TABLE_ID" foreign="AD_TABLE_ID"/>
       </foreign-key>
       <unique name="ADRECORDACCESS_ADROLEID_ADT_UN">
--- a/src-db/database/model/tables/AD_REF_DATA_LOADED.xml	Tue Feb 24 14:26:08 2009 +0100
+++ b/src-db/database/model/tables/AD_REF_DATA_LOADED.xml	Wed Feb 25 10:55:02 2009 +0100
@@ -49,13 +49,13 @@
         <default/>
         <onCreateDefault/>
       </column>
-      <foreign-key foreignTable="AD_TABLE" name="AD_REF_DATA_LOADED_AD_TABLE">
+      <foreign-key foreignTable="AD_TABLE" name="AD_REF_DATA_LOADED_AD_TABLE" onDelete="cascade">
         <reference local="AD_TABLE_ID" foreign="AD_TABLE_ID"/>
       </foreign-key>
       <foreign-key foreignTable="AD_CLIENT" name="ADCLIENT_ADREFDATALOADED">
         <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="AD_MODULE" name="ADMODULE_ADREFDATALOADED">
+      <foreign-key foreignTable="AD_MODULE" name="ADMODULE_ADREFDATALOADED" onDelete="cascade">
         <reference local="AD_MODULE_ID" foreign="AD_MODULE_ID"/>
       </foreign-key>
       <foreign-key foreignTable="AD_ORG" name="ADORG_ADREFDATALOADED">
--- a/src-db/database/model/tables/C_ACCTSCHEMA_TABLE.xml	Tue Feb 24 14:26:08 2009 +0100
+++ b/src-db/database/model/tables/C_ACCTSCHEMA_TABLE.xml	Wed Feb 25 10:55:02 2009 +0100
@@ -51,7 +51,7 @@
       <foreign-key foreignTable="AD_ORG" name="AD_ORG_C_ACCTSCHEMA_TABLE">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="AD_TABLE" name="AD_TABLE_C_ACCTSCHEMA_TABLE">
+      <foreign-key foreignTable="AD_TABLE" name="AD_TABLE_C_ACCTSCHEMA_TABLE" onDelete="cascade">
         <reference local="AD_TABLE_ID" foreign="AD_TABLE_ID"/>
       </foreign-key>
       <foreign-key foreignTable="C_ACCTSCHEMA" name="CACCTSCHEMA_CACCTSCHEMATABLE">
--- a/src-db/database/model/tables/C_DOCTYPE.xml	Tue Feb 24 14:26:08 2009 +0100
+++ b/src-db/database/model/tables/C_DOCTYPE.xml	Wed Feb 25 10:55:02 2009 +0100
@@ -110,7 +110,7 @@
       <foreign-key foreignTable="AD_ORG" name="ADORG_CDOCTYPE">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="AD_TABLE" name="ADTABLE_CDOCTYPE">
+      <foreign-key foreignTable="AD_TABLE" name="ADTABLE_CDOCTYPE" onDelete="cascade">
         <reference local="AD_TABLE_ID" foreign="AD_TABLE_ID"/>
       </foreign-key>
       <foreign-key foreignTable="C_DOCTYPE" name="C_DOCTYPE_C_DOCTYPE">
--- a/src-db/database/model/tables/C_FILE.xml	Tue Feb 24 14:26:08 2009 +0100
+++ b/src-db/database/model/tables/C_FILE.xml	Wed Feb 25 10:55:02 2009 +0100
@@ -63,7 +63,7 @@
       <foreign-key foreignTable="AD_ORG" name="ADORG_CFILE">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="AD_TABLE" name="ADTABLE_CFILE">
+      <foreign-key foreignTable="AD_TABLE" name="ADTABLE_CFILE" onDelete="cascade">
         <reference local="AD_TABLE_ID" foreign="AD_TABLE_ID"/>
       </foreign-key>
     </table>
--- a/src-db/database/model/tables/FACT_ACCT.xml	Tue Feb 24 14:26:08 2009 +0100
+++ b/src-db/database/model/tables/FACT_ACCT.xml	Wed Feb 25 10:55:02 2009 +0100
@@ -201,7 +201,7 @@
       <foreign-key foreignTable="AD_ORG" name="AD_ORGTRX_FACT_ACCT">
         <reference local="AD_ORGTRX_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="AD_TABLE" name="ADTABLE_FACTACCT">
+      <foreign-key foreignTable="AD_TABLE" name="ADTABLE_FACTACCT" onDelete="cascade">
         <reference local="AD_TABLE_ID" foreign="AD_TABLE_ID"/>
       </foreign-key>
       <foreign-key foreignTable="C_BPARTNER" name="C_BUSPARTNER_FACT_ACCT">
--- a/src-db/database/model/tables/I_ELEMENTVALUE.xml	Tue Feb 24 14:26:08 2009 +0100
+++ b/src-db/database/model/tables/I_ELEMENTVALUE.xml	Wed Feb 25 10:55:02 2009 +0100
@@ -132,7 +132,7 @@
       <foreign-key foreignTable="AD_CLIENT" name="ADCLIENT_IELEMENTVALUE">
         <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
       </foreign-key>
-      <foreign-key foreignTable="AD_COLUMN" name="ADCOLUMN_IELEMENTVALUE">
+      <foreign-key foreignTable="AD_COLUMN" name="ADCOLUMN_IELEMENTVALUE" onDelete="cascade">
         <reference local="AD_COLUMN_ID" foreign="AD_COLUMN_ID"/>
       </foreign-key>
       <foreign-key foreignTable="AD_ORG" name="ADORG_IELEMENTVALUE">