From aac2ab106fb07e2a4ce459d0b196e5e2eb40bd2b Mon Sep 17 00:00:00 2001 From: miker Date: Thu, 3 Dec 2009 21:51:59 +0000 Subject: [PATCH] overzealous replace spotted by Lebbeous git-svn-id: svn://svn.open-ils.org/ILS/trunk@15072 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/095.schema.booking.sql | 6 +++--- Open-ILS/src/sql/Pg/upgrade/0105.schema.booking-integration.sql | 6 +++--- 2 files changed, 6 insertions(+), 6 deletions(-) diff --git a/Open-ILS/src/sql/Pg/095.schema.booking.sql b/Open-ILS/src/sql/Pg/095.schema.booking.sql index 7218da4e11..2b31b3b37f 100644 --- a/Open-ILS/src/sql/Pg/095.schema.booking.sql +++ b/Open-ILS/src/sql/Pg/095.schema.booking.sql @@ -137,9 +137,9 @@ ALTER TABLE booking.reservation FOREIGN KEY (usr) REFERENCES actor.usr (id) DEFERRABLE INITIALLY DEFERRED; -CREATE TRIGGER mat_summary_create_tgr AFTER INSERT ON booking.reservation FOR EACH ROW EXECUTE PROCEDURE booking.mat_summary_create ('reservation'); -CREATE TRIGGER mat_summary_change_tgr AFTER UPDATE ON booking.reservation FOR EACH ROW EXECUTE PROCEDURE booking.mat_summary_update (); -CREATE TRIGGER mat_summary_remove_tgr AFTER DELETE ON booking.reservation FOR EACH ROW EXECUTE PROCEDURE booking.mat_summary_delete (); +CREATE TRIGGER mat_summary_create_tgr AFTER INSERT ON booking.reservation FOR EACH ROW EXECUTE PROCEDURE money.mat_summary_create ('reservation'); +CREATE TRIGGER mat_summary_change_tgr AFTER UPDATE ON booking.reservation FOR EACH ROW EXECUTE PROCEDURE money.mat_summary_update (); +CREATE TRIGGER mat_summary_remove_tgr AFTER DELETE ON booking.reservation FOR EACH ROW EXECUTE PROCEDURE money.mat_summary_delete (); CREATE TABLE booking.reservation_attr_value_map ( diff --git a/Open-ILS/src/sql/Pg/upgrade/0105.schema.booking-integration.sql b/Open-ILS/src/sql/Pg/upgrade/0105.schema.booking-integration.sql index 4b96afab56..2887048384 100644 --- a/Open-ILS/src/sql/Pg/upgrade/0105.schema.booking-integration.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0105.schema.booking-integration.sql @@ -2,9 +2,9 @@ BEGIN; INSERT INTO config.upgrade_log (version) VALUES ('0105'); -- miker -CREATE TRIGGER mat_summary_create_tgr AFTER INSERT ON booking.reservation FOR EACH ROW EXECUTE PROCEDURE booking.mat_summary_create ('reservation'); -CREATE TRIGGER mat_summary_change_tgr AFTER UPDATE ON booking.reservation FOR EACH ROW EXECUTE PROCEDURE booking.mat_summary_update (); -CREATE TRIGGER mat_summary_remove_tgr AFTER DELETE ON booking.reservation FOR EACH ROW EXECUTE PROCEDURE booking.mat_summary_delete (); +CREATE TRIGGER mat_summary_create_tgr AFTER INSERT ON booking.reservation FOR EACH ROW EXECUTE PROCEDURE money.mat_summary_create ('reservation'); +CREATE TRIGGER mat_summary_change_tgr AFTER UPDATE ON booking.reservation FOR EACH ROW EXECUTE PROCEDURE money.mat_summary_update (); +CREATE TRIGGER mat_summary_remove_tgr AFTER DELETE ON booking.reservation FOR EACH ROW EXECUTE PROCEDURE money.mat_summary_delete (); CREATE OR REPLACE VIEW money.open_billable_xact_summary AS SELECT xact.id AS id, -- 2.11.0