Forward port 3.4.5-3.4.6 db upgrade script
authorJason Stephenson <jason@sigio.com>
Wed, 17 Feb 2021 19:13:33 +0000 (14:13 -0500)
committerJason Stephenson <jason@sigio.com>
Thu, 18 Feb 2021 12:30:15 +0000 (07:30 -0500)
Signed-off-by: Jason Stephenson <jason@sigio.com>

Open-ILS/src/sql/Pg/version-upgrade/3.4.5-3.4.6-upgrade-db.sql [new file with mode: 0644]

diff --git a/Open-ILS/src/sql/Pg/version-upgrade/3.4.5-3.4.6-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/3.4.5-3.4.6-upgrade-db.sql
new file mode 100644 (file)
index 0000000..a74f5e1
--- /dev/null
@@ -0,0 +1,9 @@
+--Upgrade Script for 3.4.5 to 3.4.6
+\set eg_version '''3.4.6'''
+BEGIN;
+INSERT INTO config.upgrade_log (version, applied_to) VALUES ('3.4.6', :eg_version);
+COMMIT;
+
+-- Update auditor tables to catch changes to source tables.
+--   Can be removed/skipped if there were no schema changes.
+SELECT auditor.update_auditors();