diff options
Diffstat (limited to 'sql/tables')
| -rw-r--r-- | sql/tables/resume.contactinfo.sql | 2 | ||||
| -rw-r--r-- | sql/tables/resume.resume.sql | 3 |
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) ); |