From b212468779aa74dd719cb9ac614919c749927260 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Wed, 4 May 2011 15:44:19 -0400 Subject: [PATCH] Allow different quality measures for different values on the same tag+sf/svf --- Open-ILS/src/sql/Pg/012.schema.vandelay.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/012.schema.vandelay.sql b/Open-ILS/src/sql/Pg/012.schema.vandelay.sql index b5d72df918..8c18550258 100644 --- a/Open-ILS/src/sql/Pg/012.schema.vandelay.sql +++ b/Open-ILS/src/sql/Pg/012.schema.vandelay.sql @@ -42,7 +42,7 @@ CREATE TABLE vandelay.match_set_quality ( CONSTRAINT vmsq_need_a_subfield_with_a_tag CHECK ((tag IS NOT NULL AND subfield IS NOT NULL) OR tag IS NULL), CONSTRAINT vmsq_need_a_tag_or_a_ff CHECK ((tag IS NOT NULL AND svf IS NULL) OR (tag IS NULL AND svf IS NOT NULL)) ); -CREATE UNIQUE INDEX vmsq_def_once_per_set ON vandelay.match_set_quality (match_set, COALESCE(tag,''), COALESCE(subfield,''), COALESCE(svf,'')); +CREATE UNIQUE INDEX vmsq_def_once_per_set ON vandelay.match_set_quality (match_set, COALESCE(tag,''), COALESCE(subfield,''), COALESCE(svf,''), value); CREATE TABLE vandelay.queue ( -- 2.11.0