From 39763429c96edf8e60217764b86b2a998fcb198a Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Mon, 31 Oct 2016 11:45:16 -0400 Subject: [PATCH] Creating PINES pre-upgrade script. Drop public.demographic view --- Open-ILS/src/sql/Pg/version-upgrade/pines-pre-upgrade-2.9-2.11.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/version-upgrade/pines-pre-upgrade-2.9-2.11.sql diff --git a/Open-ILS/src/sql/Pg/version-upgrade/pines-pre-upgrade-2.9-2.11.sql b/Open-ILS/src/sql/Pg/version-upgrade/pines-pre-upgrade-2.9-2.11.sql new file mode 100644 index 0000000000..35de4c012c --- /dev/null +++ b/Open-ILS/src/sql/Pg/version-upgrade/pines-pre-upgrade-2.9-2.11.sql @@ -0,0 +1,6 @@ +BEGIN; + +-- drop the redundant demographic view +DROP VIEW public.demographic; + +COMMIT; -- 2.11.0