From 799bce691b65c841583089810fc15b74fdb2d2f4 Mon Sep 17 00:00:00 2001 From: miker Date: Wed, 22 Feb 2006 03:34:09 +0000 Subject: [PATCH] removing the item-once-per-bucket constraint git-svn-id: svn://svn.open-ils.org/ILS/trunk@3153 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/070.schema.container.sql | 12 ++++-------- 1 file changed, 4 insertions(+), 8 deletions(-) diff --git a/Open-ILS/src/sql/Pg/070.schema.container.sql b/Open-ILS/src/sql/Pg/070.schema.container.sql index f441d5ab91..d8acdd99af 100644 --- a/Open-ILS/src/sql/Pg/070.schema.container.sql +++ b/Open-ILS/src/sql/Pg/070.schema.container.sql @@ -32,8 +32,7 @@ CREATE TABLE container.copy_bucket_item ( ON UPDATE CASCADE DEFERRABLE INITIALLY DEFERRED, - create_time TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(), - CONSTRAINT cb_cb_item_once_per_bucket UNIQUE (bucket,target_copy) + create_time TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW() ); @@ -68,8 +67,7 @@ CREATE TABLE container.call_number_bucket_item ( ON UPDATE CASCADE DEFERRABLE INITIALLY DEFERRED, - create_time TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(), - CONSTRAINT cnb_item_once_per_bucket UNIQUE (bucket,target_call_number) + create_time TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW() ); @@ -104,8 +102,7 @@ CREATE TABLE container.biblio_record_entry_bucket_item ( ON UPDATE CASCADE DEFERRABLE INITIALLY DEFERRED, - create_time TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(), - CONSTRAINT breb_item_once_per_bucket UNIQUE (bucket,target_biblio_record_entry) + create_time TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW() ); @@ -140,8 +137,7 @@ CREATE TABLE container.user_bucket_item ( ON UPDATE CASCADE DEFERRABLE INITIALLY DEFERRED, - create_time TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(), - CONSTRAINT ub_item_once_per_bucket UNIQUE (bucket,target_user) + create_time TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW() ); COMMIT; -- 2.43.2