From 7d001a45de80d4f1236a4075ef7361d271ac0024 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Mon, 22 Dec 2014 15:39:48 -0500 Subject: [PATCH] Updating KCLS DB schema for 2014-12-22 Signed-off-by: Bill Erickson --- KCLS/sql/dev-data/kcls-eg-db-schema.sql | 83 ++++++++++++++++++++++++++++++--- 1 file changed, 76 insertions(+), 7 deletions(-) diff --git a/KCLS/sql/dev-data/kcls-eg-db-schema.sql b/KCLS/sql/dev-data/kcls-eg-db-schema.sql index 09a65828dd..f6c86dbea6 100644 --- a/KCLS/sql/dev-data/kcls-eg-db-schema.sql +++ b/KCLS/sql/dev-data/kcls-eg-db-schema.sql @@ -3,7 +3,7 @@ -- /* -Generated 2014-10-29 +Generated 2014-12-22 pg_dump -U evergreen evergreen -s > kcls-eg-db-schema.sql */ @@ -4508,6 +4508,38 @@ $$; ALTER FUNCTION action.hold_copy_calculated_proximity(ahr_id integer, acp_id bigint, copy_context_ou integer) OWNER TO evergreen; -- +-- Name: hold_copy_calculated_proximity_update(); Type: FUNCTION; Schema: action; Owner: evergreen +-- + +CREATE FUNCTION hold_copy_calculated_proximity_update() RETURNS trigger + LANGUAGE plpgsql + AS $$ +BEGIN + NEW.proximity := action.hold_copy_calculated_proximity(NEW.hold,NEW.target_copy); + RETURN NEW; +END; +$$; + + +ALTER FUNCTION action.hold_copy_calculated_proximity_update() OWNER TO evergreen; + +-- +-- Name: hold_request_clear_map(); Type: FUNCTION; Schema: action; Owner: evergreen +-- + +CREATE FUNCTION hold_request_clear_map() RETURNS trigger + LANGUAGE plpgsql + AS $$ +BEGIN + DELETE FROM action.hold_copy_map WHERE hold = NEW.id; + RETURN NEW; +END; +$$; + + +ALTER FUNCTION action.hold_request_clear_map() OWNER TO evergreen; + +-- -- Name: hold_request_permit_test(integer, integer, bigint, integer, integer); Type: FUNCTION; Schema: action; Owner: evergreen -- @@ -36027,7 +36059,8 @@ CREATE TABLE fund_debit ( encumbrance boolean DEFAULT true NOT NULL, debit_type text NOT NULL, xfer_destination integer, - create_time timestamp with time zone DEFAULT now() NOT NULL + create_time timestamp with time zone DEFAULT now() NOT NULL, + invoice_entry integer ); @@ -78753,6 +78786,13 @@ CREATE INDEX fund_alloc_allocator_idx ON fund_allocation USING btree (allocator) -- +-- Name: fund_debit_invoice_entry_idx; Type: INDEX; Schema: acq; Owner: evergreen; Tablespace: +-- + +CREATE INDEX fund_debit_invoice_entry_idx ON fund_debit USING btree (invoice_entry); + + +-- -- Name: li_attr_definition_idx; Type: INDEX; Schema: acq; Owner: evergreen; Tablespace: -- @@ -78844,6 +78884,13 @@ CREATE INDEX li_usr_attr_def_usr_idx ON lineitem_usr_attr_definition USING btree -- +-- Name: lineitem_detail_fund_debit_idx; Type: INDEX; Schema: acq; Owner: evergreen; Tablespace: +-- + +CREATE INDEX lineitem_detail_fund_debit_idx ON lineitem_detail USING btree (fund_debit); + + +-- -- Name: po_creator_idx; Type: INDEX; Schema: acq; Owner: evergreen; Tablespace: -- @@ -84974,6 +85021,20 @@ CREATE TRIGGER fill_circ_copy_location_tgr BEFORE INSERT ON circulation FOR EACH -- +-- Name: hold_copy_proximity_update_tgr; Type: TRIGGER; Schema: action; Owner: evergreen +-- + +CREATE TRIGGER hold_copy_proximity_update_tgr BEFORE INSERT OR UPDATE ON hold_copy_map FOR EACH ROW EXECUTE PROCEDURE hold_copy_calculated_proximity_update(); + + +-- +-- Name: hold_request_clear_map_tgr; Type: TRIGGER; Schema: action; Owner: evergreen +-- + +CREATE TRIGGER hold_request_clear_map_tgr AFTER UPDATE ON hold_request FOR EACH ROW WHEN ((((new.cancel_time IS NOT NULL) AND (old.cancel_time IS NULL)) OR ((new.capture_time IS NOT NULL) AND (old.capture_time IS NULL)))) EXECUTE PROCEDURE hold_request_clear_map(); + + +-- -- Name: mat_summary_change_tgr; Type: TRIGGER; Schema: action; Owner: evergreen -- @@ -86206,6 +86267,14 @@ ALTER TABLE ONLY fund_debit -- +-- Name: fund_debit_invoice_entry_fkey; Type: FK CONSTRAINT; Schema: acq; Owner: evergreen +-- + +ALTER TABLE ONLY fund_debit + ADD CONSTRAINT fund_debit_invoice_entry_fkey FOREIGN KEY (invoice_entry) REFERENCES invoice_entry(id) ON DELETE SET NULL; + + +-- -- Name: fund_debit_origin_currency_type_fkey; Type: FK CONSTRAINT; Schema: acq; Owner: evergreen -- @@ -91404,7 +91473,7 @@ SET search_path = money, pg_catalog; REVOKE ALL ON TABLE billable_xact FROM PUBLIC; REVOKE ALL ON TABLE billable_xact FROM evergreen; GRANT ALL ON TABLE billable_xact TO evergreen; -GRANT SELECT ON TABLE billable_xact TO bbonner; +GRANT ALL ON TABLE billable_xact TO bbonner; -- @@ -91488,7 +91557,7 @@ GRANT SELECT,INSERT,UPDATE ON TABLE address_alert TO bbonner; REVOKE ALL ON TABLE usr_standing_penalty FROM PUBLIC; REVOKE ALL ON TABLE usr_standing_penalty FROM evergreen; GRANT ALL ON TABLE usr_standing_penalty TO evergreen; -GRANT SELECT ON TABLE usr_standing_penalty TO bbonner; +GRANT SELECT,DELETE ON TABLE usr_standing_penalty TO bbonner; -- @@ -92005,7 +92074,7 @@ SET search_path = permission, pg_catalog; REVOKE ALL ON TABLE grp_tree FROM PUBLIC; REVOKE ALL ON TABLE grp_tree FROM evergreen; GRANT ALL ON TABLE grp_tree TO evergreen; -GRANT SELECT ON TABLE grp_tree TO bbonner; +GRANT SELECT,UPDATE ON TABLE grp_tree TO bbonner; -- @@ -94308,7 +94377,7 @@ GRANT USAGE ON SEQUENCE stat_cat_entry_id_seq TO bbonner; REVOKE ALL ON TABLE stat_cat_entry_usr_map FROM PUBLIC; REVOKE ALL ON TABLE stat_cat_entry_usr_map FROM evergreen; GRANT ALL ON TABLE stat_cat_entry_usr_map TO evergreen; -GRANT SELECT ON TABLE stat_cat_entry_usr_map TO bbonner; +GRANT SELECT,DELETE ON TABLE stat_cat_entry_usr_map TO bbonner; -- @@ -97569,7 +97638,7 @@ SET search_path = money, pg_catalog; REVOKE ALL ON TABLE billing FROM PUBLIC; REVOKE ALL ON TABLE billing FROM evergreen; GRANT ALL ON TABLE billing TO evergreen; -GRANT SELECT ON TABLE billing TO bbonner; +GRANT ALL ON TABLE billing TO bbonner; -- -- 2.11.0