Index: src/main/resources/db/migration/V1__init_ddl.sql
===================================================================
--- src/main/resources/db/migration/V1__init_ddl.sql	(revision 7a612b9f7945eb326de428ad61940dcf24d94b4e)
+++ src/main/resources/db/migration/V1__init_ddl.sql	(revision b48ccc170007d943d36833ee3d6336cde395b061)
@@ -484,4 +484,23 @@
 $$;
 
+
+CREATE OR REPLACE FUNCTION fn_change_status_on_pending_reports()
+    RETURNS TRIGGER
+    LANGUAGE plpgsql
+AS $$
+BEGIN
+    RAISE NOTICE 'user_id: %, topic_id: %', NEW.user_id, NEW.topic_id;
+
+    UPDATE submission
+    SET status = 'ACCEPTED'
+    WHERE id in (
+        select id
+        from report r
+        where r.for_user_id = NEW.user_id and r.thread_id = NEW.topic_id
+    );
+
+    RETURN NEW;
+END;
+$$;
 -------------------------- TRIGGERS ----------------------
 
@@ -548,4 +567,10 @@
 for each row
 execute function fn_add_blacklisted_user();
+
+CREATE OR REPLACE TRIGGER tr_change_status_on_pending_reports
+    AFTER INSERT
+    ON blacklisted_user
+    FOR EACH ROW
+EXECUTE FUNCTION fn_change_status_on_pending_reports();
 
 -- create or replace trigger tr_remove_thread_from_project