From 9df3fbe32f7933b369670ceb18af2e583b4c9a07 Mon Sep 17 00:00:00 2001 From: Lebbeous Fogle-Weekley Date: Thu, 9 Aug 2012 11:36:35 -0400 Subject: [PATCH] Do the same thing I did to fix constrain names in upgr scripts to baseline Signed-off-by: Lebbeous Fogle-Weekley --- Open-ILS/src/sql/Pg/075.schema.url_verify.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/075.schema.url_verify.sql b/Open-ILS/src/sql/Pg/075.schema.url_verify.sql index fd365e05b9..d45d5649f5 100644 --- a/Open-ILS/src/sql/Pg/075.schema.url_verify.sql +++ b/Open-ILS/src/sql/Pg/075.schema.url_verify.sql @@ -28,7 +28,7 @@ CREATE TABLE url_verify.session ( container INT NOT NULL REFERENCES container.biblio_record_entry_bucket (id) DEFERRABLE INITIALLY DEFERRED, create_time TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(), search TEXT NOT NULL, - CONSTRAINT name_once_per_lib UNIQUE (name, owning_lib) + CONSTRAINT uvs_name_once_per_lib UNIQUE (name, owning_lib) ); CREATE TABLE url_verify.url_selector ( @@ -95,7 +95,7 @@ CREATE TABLE url_verify.filter_set ( creator INT NOT NULL REFERENCES actor.usr (id) DEFERRABLE INITIALLY DEFERRED, create_time TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(), filter TEXT NOT NULL, - CONSTRAINT name_once_per_lib UNIQUE (name, owning_lib) + CONSTRAINT uvfs_name_once_per_lib UNIQUE (name, owning_lib) ); COMMIT; -- 2.11.0