Error trying delete Window definition when the window is on ad_recentitem table

Description

Hi guys,

I'm trying to delete a Window on dictionary definition but the window is related to table ad_recentitem. I change database definition for constraint with this code:

ALTER TABLE ad_recentitem
DROP CONSTRAINT adwindow_adrecentitem

ALTER TABLE ad_recentitem
ADD CONSTRAINT adwindow_adrecentitem FOREIGN KEY (ad_window_id)
REFERENCES ad_window (ad_window_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED

Can you add this code to migration script?

Environment

None

Activity

Show:
Fixed

Details

Assignee

Reporter

Components

Priority

Created October 31, 2014 at 6:12 PM
Updated January 5, 2015 at 11:43 PM
Resolved November 1, 2014 at 12:36 AM