Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0021767 | Openbravo ERP | 09. Financial management | public | 2012-09-26 16:56 | 2012-09-27 16:20 |
| Reporter | dmiguelez | ||||
| Assigned To | dmiguelez | ||||
| Priority | immediate | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 20 | OS Version | Community Appliance | |
| Product Version | |||||
| Target Version | Fixed in Version | ||||
| Merge Request Status | |||||
| Review Assigned To | dmiguelez | ||||
| OBNetwork customer | |||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0021767: API Change. In FIN_Orig_Payment_Schedule and FIN_Orig_Payment_ScheduleDetail all foreign keys should be ON DELETE CASCADE. | ||||
| Description | FIN_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 Reproduce | FIN_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. | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| 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 | ||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||