From 6af7debf5da745da38fdf18919c28114255bd11e Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 16 Jul 2015 16:12:22 -0400 Subject: [PATCH] add extensions Signed-off-by: Bill Erickson --- Open-ILS/src/sql/deploy/create_extensions.sql | 12 ++++++++++++ Open-ILS/src/sql/revert/create_extensions.sql | 12 ++++++++++++ Open-ILS/src/sql/sqitch.plan | 1 + Open-ILS/src/sql/verify/create_extensions.sql | 7 +++++++ 4 files changed, 32 insertions(+) create mode 100644 Open-ILS/src/sql/deploy/create_extensions.sql create mode 100644 Open-ILS/src/sql/revert/create_extensions.sql create mode 100644 Open-ILS/src/sql/verify/create_extensions.sql diff --git a/Open-ILS/src/sql/deploy/create_extensions.sql b/Open-ILS/src/sql/deploy/create_extensions.sql new file mode 100644 index 0000000000..b8266af665 --- /dev/null +++ b/Open-ILS/src/sql/deploy/create_extensions.sql @@ -0,0 +1,12 @@ +-- Deploy evergreen:create_extensions to pg + +BEGIN; + +CREATE LANGUAGE plperlu; + +CREATE EXTENSION tablefunc; +CREATE EXTENSION xml2; +CREATE EXTENSION hstore; +CREATE EXTENSION intarray; + +COMMIT; diff --git a/Open-ILS/src/sql/revert/create_extensions.sql b/Open-ILS/src/sql/revert/create_extensions.sql new file mode 100644 index 0000000000..5f901e93d4 --- /dev/null +++ b/Open-ILS/src/sql/revert/create_extensions.sql @@ -0,0 +1,12 @@ +-- Revert evergreen:create_extensions from pg + +BEGIN; + +DROP LANGUAGE plperlu; + +DROP EXTENSION tablefunc; +DROP EXTENSION xml2; +DROP EXTENSION hstore; +DROP EXTENSION intarray; + +COMMIT; diff --git a/Open-ILS/src/sql/sqitch.plan b/Open-ILS/src/sql/sqitch.plan index 5f03c5d1ad..dda7fe2fbf 100644 --- a/Open-ILS/src/sql/sqitch.plan +++ b/Open-ILS/src/sql/sqitch.plan @@ -2,3 +2,4 @@ %project=evergreen %uri=http://evergreen-ils.org/ +create_extensions 2015-07-16T20:02:22Z Bill Erickson # Start with extensions diff --git a/Open-ILS/src/sql/verify/create_extensions.sql b/Open-ILS/src/sql/verify/create_extensions.sql new file mode 100644 index 0000000000..90ccce01d6 --- /dev/null +++ b/Open-ILS/src/sql/verify/create_extensions.sql @@ -0,0 +1,7 @@ +-- Verify evergreen:create_extensions on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; -- 2.11.0