added education

3 files changed, 54 insertions, 3 deletions

diff --git a/sql/functions/resume.insert_education.sql b/sql/functions/resume.insert_education.sql
new file mode 100644
index 0000000..59ba98b
--- /dev/null
+++ b/sql/functions/resume.insert_education.sql
@@ -0,0 +1,49 @@
+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/tables/resume.education.sql b/sql/tables/resume.education.sql
index 638a50c..161dbfc 100644
--- a/sql/tables/resume.education.sql
+++ b/sql/tables/resume.education.sql
@@ -2,11 +2,12 @@ drop table resume.education cascade;
 
 create table resume.education (
     id serial8 primary key,
+    user_id bigint not null references auth.users(id),
     school character varying(255) not null,
-    start_date timestamp without time zone not null default now(),
-    end_date timestamp without time zone not null default now(),
+    start_date character varying(255) not null,
+    end_date character varying(255) not null,
     major character varying(255) not null,
-    minor character varying(255) not null,
+    minor character varying(255),
     degree character varying(255) not null,
     progress character varying(255) not null
 );
diff --git a/sql/tables/resume.language.sql b/sql/tables/resume.language.sql
index 0f5c452..6aaf0d8 100644
--- a/sql/tables/resume.language.sql
+++ b/sql/tables/resume.language.sql
@@ -2,6 +2,7 @@ drop table resume.language cascade;
 
 create table resume.language (
     id serial8 primary key,
+    user_id bigint not null references auth.users(id),
     name character varying(255) not null,
     understanding_listening character varying(2) not null,
     understanding_reading character varying(2) not null,