Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0021767 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | major | always | 2012-09-26 16:56 | 2012-09-27 16:20 | |||
| Reporter | dmiguelez | View Status | public | |||||
| Assigned To | dmiguelez | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | c0e12684d0fc | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_18 | |||
| OS Version | Community Appliance | Database version | 8.3.9 | Ant version | 1.7.1 | |||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | dmiguelez | |||||||
| OBNetwork customer | No | |||||||
| 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. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0052821) iciordia (viewer) 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 (viewer) 2012-09-27 16:20 |
API Checks working again |
|
Notes |
|
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 16:56 | dmiguelez | OBNetwork customer | => No |
| 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |