From cbff93285eeba03e9900dcef19a7631245669e16 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Thu, 1 Aug 2019 07:25:37 -0400 Subject: [PATCH 1/1] LP#1006466 - remove testing upgrade script Signed-off-by: Chris Sharp --- ....action_hold_request_fkey_to_hold_type.sql | 19 ------------------- 1 file changed, 19 deletions(-) delete mode 100644 Open-ILS/src/sql/Pg/upgrade/xxxx.schema.action_hold_request_fkey_to_hold_type.sql diff --git a/Open-ILS/src/sql/Pg/upgrade/xxxx.schema.action_hold_request_fkey_to_hold_type.sql b/Open-ILS/src/sql/Pg/upgrade/xxxx.schema.action_hold_request_fkey_to_hold_type.sql deleted file mode 100644 index 8362f62397..0000000000 --- a/Open-ILS/src/sql/Pg/upgrade/xxxx.schema.action_hold_request_fkey_to_hold_type.sql +++ /dev/null @@ -1,19 +0,0 @@ -CREATE TABLE config.hold_type ( - id SERIAL, - hold_type TEXT UNIQUE, - description TEXT -); - -INSERT INTO config.hold_type (hold_type,description) VALUES - ('C','Copy Hold'), - ('V','Volume Hold'), - ('T','Title Hold'), - ('M','Metarecord Hold'), - ('R','Recall Hold'), - ('F','Force Hold'), - ('I','Issuance Hold'), - ('P','Part Hold') -; - -ALTER TABLE action.hold_request ADD CONSTRAINT hold_request_hold_type_fkey FOREIGN KEY (hold_type) REFERENCES config.hold_type(hold_type) DEFERRABLE INITIALLY DEFERRED; - -- 2.43.2