Merge branch 'master' of git.evergreen-ils.org:Evergreen into social

[evergreen-equinox.git] / Open-ILS / src / sql / Pg / upgrade / 0531.schema.auditor_affixes.sql

diff --git a/Open-ILS/src/sql/Pg/upgrade/0531.schema.auditor_affixes.sql b/Open-ILS/src/sql/Pg/upgrade/0531.schema.auditor_affixes.sql
new file mode 100644 (file)
index 0000000..b8d010f
--- /dev/null
+++ b/Open-ILS/src/sql/Pg/upgrade/0531.schema.auditor_affixes.sql
@@ -0,0 +1,9 @@
+BEGIN;
+
+INSERT INTO config.upgrade_log (version) VALUES ('0531'); --gmc
+
+ALTER TABLE auditor.asset_call_number_history
+    ADD COLUMN prefix INT,
+    ADD COLUMN suffix INT;
+
+COMMIT;