removing the item-once-per-bucket constraint
authormiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 22 Feb 2006 03:34:09 +0000 (03:34 +0000)
committermiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Wed, 22 Feb 2006 03:34:09 +0000 (03:34 +0000)
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

index f441d5a..d8acdd9 100644 (file)
@@ -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;