-
-
Save cechus/d55b7f7bcd5c5d44817914b124d9f1c7 to your computer and use it in GitHub Desktop.
add delete on cascade
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
ALTER TABLE public.ret_fun_address_beneficiary | |
DROP CONSTRAINT ret_fun_address_beneficiary_ret_fun_beneficiary_id_foreign; | |
ALTER TABLE public.ret_fun_address_beneficiary | |
ADD CONSTRAINT ret_fun_address_beneficiary_ret_fun_beneficiary_id_foreign | |
FOREIGN KEY (ret_fun_beneficiary_id) REFERENCES ret_fun_beneficiaries (id) ON DELETE CASCADE; | |
ALTER TABLE public.ret_fun_address_beneficiary | |
DROP CONSTRAINT ret_fun_address_beneficiary_address_id_foreign; | |
ALTER TABLE public.ret_fun_address_beneficiary | |
ADD CONSTRAINT ret_fun_address_beneficiary_address_id_foreign | |
FOREIGN KEY (address_id) REFERENCES addresses (id) ON DELETE CASCADE; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment