summaryrefslogtreecommitdiff
path: root/sql/tables/resume.resume.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/tables/resume.resume.sql')
-rw-r--r--sql/tables/resume.resume.sql3
1 files changed, 2 insertions, 1 deletions
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)
);