From 48604bac68881bac6a73492aa41016a883dbaf9d Mon Sep 17 00:00:00 2001 From: miker Date: Mon, 12 Oct 2009 15:55:31 +0000 Subject: [PATCH] account for case differences in billing type change git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_6_0@14362 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/1.4.0.5-1.6.0.0-upgrade-db.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/1.4.0.5-1.6.0.0-upgrade-db.sql b/Open-ILS/src/sql/Pg/1.4.0.5-1.6.0.0-upgrade-db.sql index eace9a171d..6de1355446 100644 --- a/Open-ILS/src/sql/Pg/1.4.0.5-1.6.0.0-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/1.4.0.5-1.6.0.0-upgrade-db.sql @@ -810,10 +810,10 @@ CREATE TABLE container.user_bucket_item_note ( ----------------------------- -INSERT INTO config.billing_type (name,owner) SELECT DISTINCT billing_type, 1 FROM money.billing WHERE billing_type NOT IN (SELECT name FROM config.billing_type); +INSERT INTO config.billing_type (name,owner) SELECT DISTINCT billing_type, 1 FROM money.billing WHERE LOWER(billing_type) NOT IN (SELECT LOWER(name) FROM config.billing_type); ALTER TABLE money.billing ADD COLUMN btype INT; -UPDATE money.billing SET btype = config.billing_type.id FROM config.billing_type WHERE config.billing_type.name = money.billing.billing_type; +UPDATE money.billing SET btype = config.billing_type.id FROM config.billing_type WHERE LOWER(config.billing_type.name) = LOWER(money.billing.billing_type); ALTER TABLE money.billing ALTER COLUMN btype SET NOT NULL; ALTER TABLE money.billing ADD CONSTRAINT btype_fkey FOREIGN KEY (btype) REFERENCES config.billing_type (id) ON DELETE RESTRICT DEFERRABLE INITIALLY DEFERRED; -- 2.11.0