1 -- @tag: foreign_key_constraints_on_delete
2 -- @description: Ändert "FOREIGN KEY" constraints auf "ON DELETE CASCADE"
7 ALTER TABLE auth.clients_groups DROP CONSTRAINT clients_groups_client_id_fkey;
8 ALTER TABLE auth.clients_groups DROP CONSTRAINT clients_groups_group_id_fkey;
10 ALTER TABLE auth.clients_groups ADD FOREIGN KEY (client_id) REFERENCES auth.clients (id) ON DELETE CASCADE;
11 ALTER TABLE auth.clients_groups ADD FOREIGN KEY (group_id) REFERENCES auth."group" (id) ON DELETE CASCADE;
14 ALTER TABLE auth.clients_users DROP CONSTRAINT clients_users_client_id_fkey;
15 ALTER TABLE auth.clients_users DROP CONSTRAINT clients_users_user_id_fkey;
17 ALTER TABLE auth.clients_users ADD FOREIGN KEY (client_id) REFERENCES auth.clients (id) ON DELETE CASCADE;
18 ALTER TABLE auth.clients_users ADD FOREIGN KEY (user_id) REFERENCES auth."user" (id) ON DELETE CASCADE;
21 ALTER TABLE auth.group_rights DROP CONSTRAINT group_rights_group_id_fkey;
23 ALTER TABLE auth.group_rights ADD FOREIGN KEY (group_id) REFERENCES auth."group" (id) ON DELETE CASCADE;
25 -- auth.session_content
26 ALTER TABLE auth.session_content DROP CONSTRAINT session_content_session_id_fkey;
28 ALTER TABLE auth.session_content ADD FOREIGN KEY (session_id) REFERENCES auth.session (id) ON DELETE CASCADE;
31 ALTER TABLE auth.user_config DROP CONSTRAINT user_config_user_id_fkey;
33 ALTER TABLE auth.user_config ADD FOREIGN KEY (user_id) REFERENCES auth."user" (id) ON DELETE CASCADE;
36 ALTER TABLE auth.user_group DROP CONSTRAINT user_group_user_id_fkey;
37 ALTER TABLE auth.user_group DROP CONSTRAINT user_group_group_id_fkey;
39 ALTER TABLE auth.user_group ADD FOREIGN KEY (user_id) REFERENCES auth."user" (id) ON DELETE CASCADE;
40 ALTER TABLE auth.user_group ADD FOREIGN KEY (group_id) REFERENCES auth."group" (id) ON DELETE CASCADE;