From fa7c4554b4c2b4ad70a7c0afbab11b6f0a43d14a Mon Sep 17 00:00:00 2001
From: ckonstanski <kostcarl@isu.edu>
Date: Mon, 20 Jul 2026 12:19:48 -0600
Subject: stuff

---
 sql/functions/resume.delete_resume.sql | 26 ++++++++++++++++++++++++++
 1 file changed, 26 insertions(+)
 create mode 100644 sql/functions/resume.delete_resume.sql

(limited to 'sql/functions/resume.delete_resume.sql')

diff --git a/sql/functions/resume.delete_resume.sql b/sql/functions/resume.delete_resume.sql
new file mode 100644
index 0000000..9a3c06f
--- /dev/null
+++ b/sql/functions/resume.delete_resume.sql
@@ -0,0 +1,26 @@
+drop function resume.delete_resume (
+    p_id bigint
+);
+
+create or replace function resume.delete_resume (
+    p_id bigint
+)
+returns void
+as $$
+begin
+    delete from resume.resume_contactinfo
+    where resume_id = p_id;
+
+    delete from resume.resume_education
+    where resume_id = p_id;
+
+    delete from resume.resume_job
+    where resume_id = p_id;
+
+    delete from resume.resume_language
+    where resume_id = p_id;
+
+    delete from resume.resume
+    where id = p_id;
+end;
+$$ language plpgsql;
-- 
cgit v1.3