summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--db/create.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/db/create.sql b/db/create.sql
index 39eab20..e720238 100644
--- a/db/create.sql
+++ b/db/create.sql
@@ -72,7 +72,7 @@ create table problem (
constraint problem_fk1 foreign key (language_id) references language (id) on delete no action on update cascade,
constraint problem_fk2 foreign key (problem_group_id) references problem_group (id) on delete no action on update cascade,
constraint problem_uq1 unique (language_id, problem_group_id, name),
- constraint problem_uq2 unique (identifier)
+ constraint problem_uq2 unique (language_id, problem_group_id, identifier)
);
create table solution (