-- ABS-38328
----------------------   CONTACTCAUSE_DESC   --------------------------
ALTER TABLE CONTACTCAUSE_DESC 
DROP CONSTRAINT CONTACTCAUSE_CONTACTCAUSE_DESC;

ALTER TABLE CONTACTCAUSE_DESC
ADD CONSTRAINT CONTACTCAUSE_CONTACTCAUSE_DESC FOREIGN KEY (CONTACTCAUSE_ID)
REFERENCES CONTACTCAUSE (CONTACTCAUSE_ID) ON DELETE CASCADE;

----------------------   CONTACTRESOLUTION_DESC   --------------------------
ALTER TABLE CONTACTRESOLUTION_DESC 
DROP CONSTRAINT CONTACTRES_CONTACTRES_DESC;

ALTER TABLE CONTACTRESOLUTION_DESC
ADD CONSTRAINT CONTACTRES_CONTACTRES_DESC FOREIGN KEY (CONTACTRESOLUTION_ID)
REFERENCES CONTACTRESOLUTION (CONTACTRESOLUTION_ID) ON DELETE CASCADE;

----------------------   INVOICELINESUBTYPE_DESC   --------------------------
ALTER TABLE INVOICELINESUBTYPE_DESC 
DROP CONSTRAINT INVOICELINESUBTYPE_D_INVOICELI;

ALTER TABLE INVOICELINESUBTYPE_DESC
ADD CONSTRAINT INVOICELINESUBTYPE_D_INVOICELI FOREIGN KEY (INVOICELINESUBTYPE_ID)
REFERENCES INVOICELINESUBTYPE (INVOICELINESUBTYPE_ID) ON DELETE CASCADE;

----------------------   LOCATIONTYPE_DESC   --------------------------
ALTER TABLE LOCATIONTYPE_DESC 
DROP CONSTRAINT LOCATIONTYPE_D_LOCATIONTYPE_ID;

ALTER TABLE LOCATIONTYPE_DESC
ADD CONSTRAINT LOCATIONTYPE_D_LOCATIONTYPE_ID FOREIGN KEY (LOCATIONTYPE_ID)
REFERENCES LOCATIONTYPE (LOCATIONTYPE_ID) ON DELETE CASCADE;

----------------------   OOSACTION_DESC   --------------------------
ALTER TABLE OOSACTION_DESC 
DROP CONSTRAINT OOSACTION_DESC_OOSACTION_ID;

ALTER TABLE OOSACTION_DESC
ADD CONSTRAINT OOSACTION_DESC_OOSACTION_ID FOREIGN KEY (OOSACTION_ID)
REFERENCES OOSACTION (OOSACTION_ID) ON DELETE CASCADE;

----------------------   OOSRESTRICTION_DESC   --------------------------
ALTER TABLE OOSRESTRICTION_DESC 
DROP CONSTRAINT OOSRESTRICTION_DESC_OOSREST_ID;

ALTER TABLE OOSRESTRICTION_DESC
ADD CONSTRAINT OOSRESTRICTION_DESC_OOSREST_ID FOREIGN KEY (OOSRESTRICTION_ID)
REFERENCES OOSRESTRICTION (OOSRESTRICTION_ID) ON DELETE CASCADE;

----------------------   SERVICECHARGEEVENT_DESC   --------------------------
ALTER TABLE SERVICECHARGEEVENT_DESC 
DROP CONSTRAINT SERVICECHARGEEVENT_DESC_SCE;

ALTER TABLE SERVICECHARGEEVENT_DESC
ADD CONSTRAINT SERVICECHARGEEVENT_DESC_SCE FOREIGN KEY (SERVICECHARGEEVENT_ID)
REFERENCES SERVICECHARGEEVENT (SERVICECHARGEEVENT_ID) ON DELETE CASCADE;

----------------------   STOCKTYPE_DESC   --------------------------
ALTER TABLE STOCKTYPE_DESC 
DROP CONSTRAINT STOCKTYPE_D_STOCKTYPE_ID;

ALTER TABLE STOCKTYPE_DESC
ADD CONSTRAINT STOCKTYPE_D_STOCKTYPE_ID FOREIGN KEY (STOCKTYPE_ID)
REFERENCES STOCKTYPE (STOCKTYPE_ID) ON DELETE CASCADE;