Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0021767
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2012-09-26 16:562012-09-27 16:20
ReporterdmiguelezView Statuspublic 
Assigned Todmiguelez 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revisionc0e12684d0fc
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionSCM revision 
Review Assigned Todmiguelez
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0021767: API Change. In FIN_Orig_Payment_Schedule and FIN_Orig_Payment_ScheduleDetail all foreign keys should be ON DELETE CASCADE.

DescriptionFIN_Orig_Payment_Schedule and FIN_Orig_Payment_ScheduleDetail are deprecated.
They have not been deleted since the users might want to recover the information.
But they should not interfere with the functionality of the application.

Since the Foreign Key references do not have the ON DELETE CASCADE Constraint, they do not allow to delete related records when it should be possible.

Plus, all the Link to Parent references of the Columns should be removed, for the same reason.

This change should not be risky, since this table is only kept for storing the information inside, nothing else.
Steps To ReproduceFIN_Orig_Payment_Schedule and FIN_Orig_Payment_ScheduleDetail are deprecated.
They have not been deleted since the users might want to recover the information.
But they should not interfere with the functionality of the application.

Since the Foreign Key references do not have the ON DELETE CASCADE Constraint, they do not allow to delete related records when it should be possible.

Plus, all the Link to Parent references of the Columns should be removed, for the same reason.

This change should not be risky, since this table is only kept for storing the information inside, nothing else.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0052821)
iciordia (manager)
2012-09-26 21:44

Approved.

Ismael
(0052835)
hgbot (developer)
2012-09-27 13:57

Repository: erp/devel/api-checks
Changeset: c0e12684d0fc7e132f6ec071e34b8a0b8345a720
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Thu Sep 27 13:09:21 2012 +0200
URL: http://code.openbravo.com/erp/devel/api-checks/rev/c0e12684d0fc7e132f6ec071e34b8a0b8345a720 [^]

Fixes issue 21767: Foreign Keys are ON DELETE CASCADE on Deprecated
Table.

---
M model/src-db/database/model/tables/FIN_ORIG_PAYMENT_SCHEDULE.xml
M model/src-db/database/model/tables/FIN_ORIG_PAYM_SCHEDDETAIL.xml
---
(0052839)
dmiguelez (developer)
2012-09-27 16:20

API Checks working again

- Issue History
Date Modified Username Field Change
2012-09-26 16:56 dmiguelez New Issue
2012-09-26 16:56 dmiguelez Assigned To => iciordia
2012-09-26 16:56 dmiguelez Modules => Core
2012-09-26 21:44 iciordia Note Added: 0052821
2012-09-26 21:45 iciordia Assigned To iciordia => dmiguelez
2012-09-27 13:12 dmiguelez Status new => scheduled
2012-09-27 13:12 dmiguelez fix_in_branch => pi
2012-09-27 13:57 hgbot Checkin
2012-09-27 13:57 hgbot Note Added: 0052835
2012-09-27 13:57 hgbot Status scheduled => resolved
2012-09-27 13:57 hgbot Resolution open => fixed
2012-09-27 13:57 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/api-checks/rev/c0e12684d0fc7e132f6ec071e34b8a0b8345a720 [^]
2012-09-27 16:20 dmiguelez Closed by => dmiguelez
2012-09-27 16:20 dmiguelez Note Added: 0052839
2012-09-27 16:20 dmiguelez Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker