From cc36b43862ecf03a60a743712cdecd2a1778ca53 Mon Sep 17 00:00:00 2001 From: dbs Date: Mon, 30 Aug 2010 14:47:37 +0000 Subject: [PATCH] Add upgrade script to go along with r13763 (thanks for the reminder, senator) git-svn-id: svn://svn.open-ils.org/ILS/trunk@17371 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- .../Pg/upgrade/0382.schema.asset_copy_location_callnums.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/0382.schema.asset_copy_location_callnums.sql diff --git a/Open-ILS/src/sql/Pg/upgrade/0382.schema.asset_copy_location_callnums.sql b/Open-ILS/src/sql/Pg/upgrade/0382.schema.asset_copy_location_callnums.sql new file mode 100644 index 000000000..0df40bd1d --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/0382.schema.asset_copy_location_callnums.sql @@ -0,0 +1,10 @@ +BEGIN; + +INSERT INTO config.upgrade_log (version) VALUES ('0382'); -- dbs + +-- Start picking up call number label prefixes and suffixes +-- from asset.copy_location +ALTER TABLE asset.copy_location ADD COLUMN label_prefix TEXT; +ALTER TABLE asset.copy_location ADD COLUMN label_suffix TEXT; + +COMMIT; -- 2.11.0