From e7301bcd63c0cbfc4d55f21d0d7c33c7557d6444 Mon Sep 17 00:00:00 2001
From: ckonstanski <kostcarl@isu.edu>
Date: Sun, 19 Jul 2026 22:05:02 -0600
Subject: starting resume logic

---
 sql/functions/resume.insert_resume.sql | 30 ++++++++++++++++++++++++++++++
 sql/tables/resume.contactinfo.sql      |  2 +-
 sql/tables/resume.resume.sql           |  3 ++-
 3 files changed, 33 insertions(+), 2 deletions(-)
 create mode 100644 sql/functions/resume.insert_resume.sql

(limited to 'sql')

diff --git a/sql/functions/resume.insert_resume.sql b/sql/functions/resume.insert_resume.sql
new file mode 100644
index 0000000..eb56897
--- /dev/null
+++ b/sql/functions/resume.insert_resume.sql
@@ -0,0 +1,30 @@
+drop function resume.insert_resume (
+    p_user_id int,
+    p_name character varying
+);
+
+create or replace function resume.insert_resume (
+    p_user_id int,
+    p_name character varying
+)
+returns bigint
+as $$
+declare
+  l_id bigint;
+begin
+    insert into resume.resume (
+        user_id,
+        name
+    ) values (
+        p_user_id,
+        p_name
+    );
+
+    select id into l_id
+    from resume.resume
+    where user_id = p_user_id
+        and name = p_name;
+
+    return l_id;
+end;
+$$ language plpgsql;
diff --git a/sql/tables/resume.contactinfo.sql b/sql/tables/resume.contactinfo.sql
index 85bcd2c..47eb1c7 100644
--- a/sql/tables/resume.contactinfo.sql
+++ b/sql/tables/resume.contactinfo.sql
@@ -4,7 +4,7 @@ create table resume.contactinfo (
     id serial8 primary key,
     address character varying(255) not null,
     city character varying(255) not null,
-    state int not null references resume.states(id),
+    state_id int not null references resume.states(id),
     phone character varying(255) not null,
     email character varying(255) not null,
     visastatus_id int not null references resume.visastatus(id)
diff --git a/sql/tables/resume.resume.sql b/sql/tables/resume.resume.sql
index 2d3c8bf..dd34db1 100644
--- a/sql/tables/resume.resume.sql
+++ b/sql/tables/resume.resume.sql
@@ -3,5 +3,6 @@ drop table resume.resume cascade;
 create table resume.resume (
     id serial8 primary key,
     user_id int not null references auth.users(id),
-    name character varying(255) not null
+    name character varying(255) not null,
+    unique (user_id, name)
 );
-- 
cgit v1.3