From 97c7ba2ca83b986f86c9afd07bf2f10bf7d3d3ff Mon Sep 17 00:00:00 2001 From: scottmk Date: Tue, 22 Sep 2009 16:48:24 +0000 Subject: [PATCH] Add upgrade script for changes previously committed, adding a dummy_isbn column to asset.copy and auditor.asset_copy_history. A Open-ILS/src/sql/Pg/upgrade/0010.schema.asset-copy-dummy-isbn.sql git-svn-id: svn://svn.open-ils.org/ILS/trunk@14084 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- .../src/sql/Pg/upgrade/0010.schema.asset-copy-dummy-isbn.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/0010.schema.asset-copy-dummy-isbn.sql diff --git a/Open-ILS/src/sql/Pg/upgrade/0010.schema.asset-copy-dummy-isbn.sql b/Open-ILS/src/sql/Pg/upgrade/0010.schema.asset-copy-dummy-isbn.sql new file mode 100644 index 0000000000..4789910531 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/0010.schema.asset-copy-dummy-isbn.sql @@ -0,0 +1,12 @@ +BEGIN; + +INSERT INTO config.upgrade_log (version) VALUES ('0010.schema.asset-copy-dummy-isbn.sql'); + +ALTER TABLE asset.copy +ADD COLUMN dummy_isbn TEXT; + +ALTER TABLE auditor.asset_copy_history +ADD COLUMN dummy_isbn TEXT; + +COMMIT; + -- 2.11.0