From 81804c9e733b02dcfad7aa91c0b26747512b7c5b Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Mon, 8 Dec 2014 10:34:26 -0500 Subject: [PATCH] LP#1380709 fund_debit.invoice_entry INDEX Adds index on new acq.fund_debit.invoice_entry column, since fund_debit can get quite large. Signed-off-by: Bill Erickson Signed-off-by: Jennifer Pringle Signed-off-by: Kathy Lussier --- Open-ILS/src/sql/Pg/200.schema.acq.sql | 2 ++ .../src/sql/Pg/upgrade/XXXX.schema.fund_debit_invoice_links.sql | 2 ++ 2 files changed, 4 insertions(+) diff --git a/Open-ILS/src/sql/Pg/200.schema.acq.sql b/Open-ILS/src/sql/Pg/200.schema.acq.sql index ac780c526c..3df7e855cd 100644 --- a/Open-ILS/src/sql/Pg/200.schema.acq.sql +++ b/Open-ILS/src/sql/Pg/200.schema.acq.sql @@ -857,6 +857,8 @@ ALTER TABLE acq.fund_debit REFERENCES acq.invoice_entry (id) ON DELETE SET NULL; +CREATE INDEX fund_debit_invoice_entry_idx ON acq.fund_debit (invoice_entry); + CREATE TABLE acq.invoice_item_type ( code TEXT PRIMARY KEY, name TEXT NOT NULL, -- i18n-ize diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fund_debit_invoice_links.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fund_debit_invoice_links.sql index aca7918dbb..7575ef9535 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fund_debit_invoice_links.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fund_debit_invoice_links.sql @@ -7,4 +7,6 @@ ALTER TABLE acq.fund_debit REFERENCES acq.invoice_entry (id) ON DELETE SET NULL; +CREATE INDEX fund_debit_invoice_entry_idx ON acq.fund_debit (invoice_entry); + COMMIT; -- 2.43.2