From 42d06f4e1c15a91b2349f15784ad9d20c5b4e84d Mon Sep 17 00:00:00 2001 From: miker Date: Mon, 16 Mar 2009 16:39:29 +0000 Subject: [PATCH] account for audited table constraint changes in 1.2-1.4 upgrade git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_4_0@12540 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/1.2.3-1.4-upgrade-db.sql | 2 ++ Open-ILS/src/sql/Pg/1.2.4-1.4-upgrade-db.sql | 2 ++ 2 files changed, 4 insertions(+) diff --git a/Open-ILS/src/sql/Pg/1.2.3-1.4-upgrade-db.sql b/Open-ILS/src/sql/Pg/1.2.3-1.4-upgrade-db.sql index a7ec22d438..c35f8f8a47 100644 --- a/Open-ILS/src/sql/Pg/1.2.3-1.4-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/1.2.3-1.4-upgrade-db.sql @@ -17,6 +17,8 @@ \set ON_ERROR_STOP 1 +ALTER TABLE auditor.asset_copy_history ALTER COLUMN price DROP NOT NULL; -- Price is nullable in 1.4+, auditor triggers complain when it's not informed of this + BEGIN; -- To avoid any updates while we're doin' our thing... diff --git a/Open-ILS/src/sql/Pg/1.2.4-1.4-upgrade-db.sql b/Open-ILS/src/sql/Pg/1.2.4-1.4-upgrade-db.sql index 94cc5fc08a..717edbedd9 100644 --- a/Open-ILS/src/sql/Pg/1.2.4-1.4-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/1.2.4-1.4-upgrade-db.sql @@ -17,6 +17,8 @@ \set ON_ERROR_STOP 1 +ALTER TABLE auditor.asset_copy_history ALTER COLUMN price DROP NOT NULL; -- Price is nullable in 1.4+, auditor triggers complain when it's not informed of this + BEGIN; -- To avoid any updates while we're doin' our thing... -- 2.11.0