0026468: Api change: Modify FK on delete clause

Description

The c_orderline_id FK on m_requisition_order table has been changed to include an "on delete cascade" clause. This will cause a change in the application:

Before: Removing a Purchase Order with a related Requisition will fail with a "linked items" error.
After: Removing a Purchase Order with a related Requisition will also try to remove the record in the requisition order table. There is a trigger in this table preventing to delete records of closed requisitions. This means that the automatic deletion will only happen on open requisitions.

Api-check test with the failure:
http://ci.openbravo.com/view/try/job/try-api/198/ [^]

Steps To Reproduce

N/A

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0066834) dmitry_mezentsev (developer) 2014-05-06 10:55	Approved.

(0066836) hgbot (developer) 2014-05-06 11:16	Repository: erp/devel/api-checks Changeset: 7335ef336f63d21b8f3cce9d985f1060d6430e2e Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com> Date: Tue May 06 11:16:26 2014 +0200 URL: http://code.openbravo.com/erp/devel/api-checks/rev/7335ef336f63d21b8f3cce9d985f1060d6430e2e [^] Fixed issue 26468.Modified FK definition. --- M model/src-db/database/model/tables/M_REQUISITIONORDER.xml ---

Issue History
Date Modified	Username	Field	Change
2014-05-06 10:41	gorkaion	New Issue
2014-05-06 10:41	gorkaion	Assigned To	=> gorkaion
2014-05-06 10:41	gorkaion	Modules	=> Core
2014-05-06 10:41	gorkaion	Triggers an Emergency Pack	=> No
2014-05-06 10:55	dmitry_mezentsev	Note Added: 0066834
2014-05-06 11:16	hgbot	Checkin
2014-05-06 11:16	hgbot	Note Added: 0066836
2014-05-06 11:16	hgbot	Status	new => resolved
2014-05-06 11:16	hgbot	Resolution	open => fixed
2014-05-06 11:16	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/api-checks/rev/7335ef336f63d21b8f3cce9d985f1060d6430e2e [^]
2014-05-06 12:46	gorkaion	Review Assigned To	=> gorkaion
2014-05-06 12:46	gorkaion	Status	resolved => closed