Skip to content

Instantly share code, notes, and snippets.

@cechus
Created July 13, 2018 15:10
Show Gist options
  • Save cechus/d55b7f7bcd5c5d44817914b124d9f1c7 to your computer and use it in GitHub Desktop.
Save cechus/d55b7f7bcd5c5d44817914b124d9f1c7 to your computer and use it in GitHub Desktop.
add delete on cascade
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