Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0021634Openbravo ERPA. Platformpublic2012-09-12 20:182012-09-26 17:19
shuehner 
AugustoMauch 
normalmajorhave not tried
closedfixed 
5
 
3.0MP16 
AugustoMauch
Core
No
0021634: obuiapp_note.ad_table_id is missing onDeleteCascade
After adding a note entry to any record of some specific ad_table. It it not possible anymore to delete that table.

Example case.
Install module having any new table. Add a note to a record in that table.
Uninstall the module having the table.
Rebuild. -> fails
As fk from obuiapp_note.ad_table_id does not have onDelete cascade notes related to the deleted table do not get deleted as well.

Imo they should same as the system does of course delete all the content of the table itself.
See description.
Add onDelete="cascade" to the obuiapp_note.ad_table_id foreign-key
No tags attached.
related to defect 00216723.0MP16 closed AugustoMauch API change: Added delete on cascade constraint 
Issue History
2012-09-12 20:18shuehnerNew Issue
2012-09-12 20:18shuehnerAssigned To => AugustoMauch
2012-09-12 20:18shuehnerModules => Core
2012-09-14 12:31hgbotCheckin
2012-09-14 12:31hgbotNote Added: 0052130
2012-09-14 12:31hgbotStatusnew => resolved
2012-09-14 12:31hgbotResolutionopen => fixed
2012-09-14 12:31hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/38acdd74058a16e99608f6e302e7b3fb140d2705 [^]
2012-09-17 14:20AugustoMauchRelationship addedrelated to 0021672
2012-09-24 16:52AugustoMauchClosed by => AugustoMauch
2012-09-24 16:52AugustoMauchNote Added: 0052350
2012-09-24 16:52AugustoMauchStatusresolved => closed
2012-09-24 16:52AugustoMauchFixed in Version => 3.0MP16
2012-09-26 17:19hudsonbotCheckin
2012-09-26 17:19hudsonbotNote Added: 0052760

Notes
(0052130)
hgbot   
2012-09-14 12:31   
Repository: erp/devel/pi
Changeset: 38acdd74058a16e99608f6e302e7b3fb140d2705
Author: Shankar Balachandran <shankar.balachandran <at> openbravo.com>
Date: Fri Sep 14 12:13:37 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/38acdd74058a16e99608f6e302e7b3fb140d2705 [^]

Fixes Issue 21634 : Added Cascade delete to obuiapp_note.ad_table_id

Added onDelete Cascade to ad_table_id field in obuiapp_note table.

---
M modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_NOTE.xml
---
(0052350)
AugustoMauch   
2012-09-24 16:52   
Code reviewed and verified in pi@4c4431d17dbd
(0052760)
hudsonbot   
2012-09-26 17:19   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/b780e90c6452 [^]

Maturity status: Test