4 files changed, 0 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;