From e7301bcd63c0cbfc4d55f21d0d7c33c7557d6444 Mon Sep 17 00:00:00 2001 From: ckonstanski Date: Sun, 19 Jul 2026 22:05:02 -0600 Subject: starting resume logic --- sql/tables/resume.contactinfo.sql | 2 +- sql/tables/resume.resume.sql | 3 ++- 2 files changed, 3 insertions(+), 2 deletions(-) (limited to 'sql/tables') 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) ); -- cgit v1.3