stuff

5 files changed, 1 insertions, 164 deletions

diff --git a/sql/functions/resume.insert_contactinfo.sql b/sql/functions/resume.insert_contactinfo.sql
deleted file mode 100644
index 428e69b..0000000
--- a/sql/functions/resume.insert_contactinfo.sql
+++ /dev/null
@@ -1,45 +0,0 @@
-drop function resume.insert_contactinfo (
-    p_user_id int,
-    p_state_id bigint,
-    p_visastatus_id bigint,
-    p_address character varying,
-    p_city character varying,
-    p_phone character varying,
-    p_email character varying
-);
-
-create or replace function resume.insert_contactinfo (
-    p_user_id int,
-    p_state_id bigint,
-    p_visastatus_id bigint,
-    p_address character varying,
-    p_city character varying,
-    p_phone character varying,
-    p_email character varying
-)
-returns bigint
-as $$
-declare
-  l_id bigint;
-begin
-    insert into resume.contactinfo (
-        user_id,
-        state_id,
-        visastatus_id,
-        address,
-        city,
-        phone,
-        email
-    ) values (
-        p_user_id,
-        p_state_id,
-        p_visastatus_id,
-        p_address,
-        p_city,
-        p_phone,
-        p_email
-    ) returning id into l_id;
-
-    return l_id;
-end;
-$$ language plpgsql;
diff --git a/sql/functions/resume.insert_education.sql b/sql/functions/resume.insert_education.sql
deleted file mode 100644
index 59ba98b..0000000
--- a/sql/functions/resume.insert_education.sql
+++ /dev/null
@@ -1,49 +0,0 @@
-drop function resume.insert_education (
-    p_user_id int,
-    p_school character varying,
-    p_start_date character varying,
-    p_end_date character varying,
-    p_major character varying,
-    p_minor character varying,
-    p_degree character varying,
-    p_progress character varying
-);
-
-create or replace function resume.insert_education (
-    p_user_id int,
-    p_school character varying,
-    p_start_date character varying,
-    p_end_date character varying,
-    p_major character varying,
-    p_minor character varying,
-    p_degree character varying,
-    p_progress character varying
-)
-returns bigint
-as $$
-declare
-  l_id bigint;
-begin
-    insert into resume.education (
-        user_id,
-        school,
-        start_date,
-        end_date,
-        major,
-        minor,
-        degree,
-        progress
-    ) values (
-        p_user_id,
-        p_school,
-        p_start_date,
-        p_end_date,
-        p_major,
-        p_minor,
-        p_degree,
-        p_progress
-    ) returning id into l_id;
-
-    return l_id;
-end;
-$$ language plpgsql;
diff --git a/sql/functions/resume.insert_language.sql b/sql/functions/resume.insert_language.sql
deleted file mode 100644
index 92ce6b9..0000000
--- a/sql/functions/resume.insert_language.sql
+++ /dev/null
@@ -1,45 +0,0 @@
-drop function resume.insert_language (
-    p_user_id int,
-    p_name character varying,
-    p_understanding_listening character varying,
-    p_understanding_reading character varying,
-    p_speaking_interaction character varying,
-    p_speaking_production character varying,
-    p_writing character varying
-);
-
-create or replace function resume.insert_language (
-    p_user_id int,
-    p_name character varying,
-    p_understanding_listening character varying,
-    p_understanding_reading character varying,
-    p_speaking_interaction character varying,
-    p_speaking_production character varying,
-    p_writing character varying
-)
-returns bigint
-as $$
-declare
-  l_id bigint;
-begin
-    insert into resume.language (
-        user_id,
-        name,
-        understanding_listening,
-        understanding_reading,
-        speaking_interaction,
-        speaking_production,
-        writing
-    ) values (
-        p_user_id,
-        p_name,
-        p_understanding_listening,
-        p_understanding_reading,
-        p_speaking_interaction,
-        p_speaking_production,
-        p_writing
-    ) returning id into l_id;
-
-    return l_id;
-end;
-$$ language plpgsql;
diff --git a/sql/functions/resume.insert_resume.sql b/sql/functions/resume.insert_resume.sql
deleted file mode 100644
index 99ac786..0000000
--- a/sql/functions/resume.insert_resume.sql
+++ /dev/null
@@ -1,25 +0,0 @@
-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
-    ) returning id into l_id;
-
-    return l_id;
-end;
-$$ language plpgsql;
diff --git a/sql/tables/resume.skill.sql b/sql/tables/resume.skill.sql
index 5085cf1..d7ad218 100644
--- a/sql/tables/resume.skill.sql
+++ b/sql/tables/resume.skill.sql
@@ -2,5 +2,6 @@ drop table resume.skill cascade;
 
 create table resume.skill (
     id serial8 primary key,
+    user_id bigint not null references auth.users(id),
     skill text not null
 );