20220523232954_allow_user_deletes.sql

1ALTER TABLE contacts DROP CONSTRAINT contacts_user_id_a_fkey;
2ALTER TABLE contacts DROP CONSTRAINT contacts_user_id_b_fkey;
3ALTER TABLE contacts ADD CONSTRAINT contacts_user_id_a_fkey FOREIGN KEY (user_id_a) REFERENCES users(id) ON DELETE CASCADE;
4ALTER TABLE contacts ADD CONSTRAINT contacts_user_id_b_fkey FOREIGN KEY (user_id_b) REFERENCES users(id) ON DELETE CASCADE;
5ALTER TABLE users DROP CONSTRAINT users_inviter_id_fkey;
6ALTER TABLE users ADD CONSTRAINT users_inviter_id_fkey FOREIGN KEY (inviter_id) REFERENCES users(id) ON DELETE SET NULL;