8 files changed, 39 insertions, 13 deletions
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;
diff --git a/sql/tables/resume.contactinfo.sql b/sql/tables/resume.contactinfo.sql
index 47eb1c7..9290da0 100644
--- a/sql/tables/resume.contactinfo.sql
+++ b/sql/tables/resume.contactinfo.sql
@@ -4,8 +4,8 @@ create table resume.contactinfo (
     id serial8 primary key,
     address character varying(255) not null,
     city character varying(255) not null,
-    state_id int not null references resume.states(id),
+    state_id bigint 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)
+    visastatus_id bigint not null references resume.visastatus(id)
 );
diff --git a/sql/tables/resume.job_skill.sql b/sql/tables/resume.job_skill.sql
index 3b16b53..0bf003d 100644
--- a/sql/tables/resume.job_skill.sql
+++ b/sql/tables/resume.job_skill.sql
@@ -2,6 +2,6 @@ drop table resume.job_skill cascade;
 
 create table resume.job_skill (
     id serial8 primary key,
-    job_id int not null references resume.job(id),
-    skill_id int not null references resume.skill(id)
+    job_id bigint not null references resume.job(id),
+    skill_id bigint not null references resume.skill(id)
 );
diff --git a/sql/tables/resume.resume.sql b/sql/tables/resume.resume.sql
index dd34db1..f751a28 100644
--- a/sql/tables/resume.resume.sql
+++ b/sql/tables/resume.resume.sql
@@ -2,7 +2,7 @@ drop table resume.resume cascade;
 
 create table resume.resume (
     id serial8 primary key,
-    user_id int not null references auth.users(id),
+    user_id bigint not null references auth.users(id),
     name character varying(255) not null,
     unique (user_id, name)
 );
diff --git a/sql/tables/resume.resume_contactinfo.sql b/sql/tables/resume.resume_contactinfo.sql
index a51e33c..01f2f5f 100644
--- a/sql/tables/resume.resume_contactinfo.sql
+++ b/sql/tables/resume.resume_contactinfo.sql
@@ -2,6 +2,6 @@ drop table resume.resume_contactinfo cascade;
 
 create table resume.resume_contactinfo (
     id serial8 primary key,
-    resume_id int not null references resume.resume(id),
-    contactinfo_id int not null references resume.contactinfo(id)
+    resume_id bigint not null references resume.resume(id),
+    contactinfo_id bigint not null references resume.contactinfo(id)
 );
diff --git a/sql/tables/resume.resume_education.sql b/sql/tables/resume.resume_education.sql
index 739169d..92bf58a 100644
--- a/sql/tables/resume.resume_education.sql
+++ b/sql/tables/resume.resume_education.sql
@@ -2,6 +2,6 @@ drop table resume.resume_education cascade;
 
 create table resume.resume_education (
     id serial8 primary key,
-    resume_id int not null references resume.resume(id),
-    education_id int not null references resume.education(id)
+    resume_id bigint not null references resume.resume(id),
+    education_id bigint not null references resume.education(id)
 );
diff --git a/sql/tables/resume.resume_job.sql b/sql/tables/resume.resume_job.sql
index 4418242..42faec6 100644
--- a/sql/tables/resume.resume_job.sql
+++ b/sql/tables/resume.resume_job.sql
@@ -2,6 +2,6 @@ drop table resume.resume_job cascade;
 
 create table resume.resume_job (
     id serial8 primary key,
-    resume_id int not null references resume.resume(id),
-    job_id int not null references resume.job(id)
+    resume_id bigint not null references resume.resume(id),
+    job_id bigint not null references resume.job(id)
 );
diff --git a/sql/tables/resume.resume_language.sql b/sql/tables/resume.resume_language.sql
index 15a63e3..1ca5d91 100644
--- a/sql/tables/resume.resume_language.sql
+++ b/sql/tables/resume.resume_language.sql
@@ -2,6 +2,6 @@ drop table resume.resume_language cascade;
 
 create table resume.resume_language (
     id serial8 primary key,
-    resume_id int not null references resume.resume(id),
-    language_id int not null references resume.language(id)
+    resume_id bigint not null references resume.resume(id),
+    language_id bigint not null references resume.language(id)
 );