From cbff93285eeba03e9900dcef19a7631245669e16 Mon Sep 17 00:00:00 2001
From: Chris Sharp <csharp@georgialibraries.org>
Date: Thu, 1 Aug 2019 07:25:37 -0400
Subject: [PATCH] LP#1006466 - remove testing upgrade script
Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
---
...x.schema.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.11.0