starting resume logic

2 files changed, 3 insertions, 2 deletions

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)
 );