From f36493cd6d28f33eaa7489c07fb3ac503da62f47 Mon Sep 17 00:00:00 2001 From: scottmk Date: Thu, 16 Sep 2010 22:08:34 +0000 Subject: [PATCH] Add column usr_summary to actor.stat_cat. (This column was added before we started maintaining individual update scripts.) M Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql git-svn-id: svn://svn.open-ils.org/ILS/trunk@17748 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql b/Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql index 4f8a956cfa..0b3fc2ef79 100644 --- a/Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql @@ -17648,8 +17648,6 @@ CREATE INDEX queued_authority_record_attr_record_idx ON vandelay.queued_authorit CREATE INDEX queued_bib_record_queue_idx ON vandelay.queued_bib_record (queue); CREATE INDEX queued_authority_record_queue_idx ON vandelay.queued_authority_record (queue); -CREATE INDEX actor_card_barcode_lower_idx ON actor.card (lower(barcode)); - -- Start picking up call number label prefixes and suffixes -- from asset.copy_location ALTER TABLE asset.copy_location ADD COLUMN label_prefix TEXT; @@ -17862,6 +17860,9 @@ CREATE INDEX by_heading_and_thesaurus ALTER TABLE acq.provider_contact ALTER COLUMN name SET NOT NULL; +ALTER TABLE actor.stat_cat + ADD COLUMN usr_summary BOOL NOT NULL DEFAULT FALSE; + COMMIT; -- Some operations go outside of the transaction, because they may @@ -17910,6 +17911,8 @@ CREATE INDEX serial_basic_summary_dist_idx ON serial.basic_summary (distribution CREATE INDEX serial_supplement_summary_dist_idx ON serial.supplement_summary (distribution); CREATE INDEX serial_index_summary_dist_idx ON serial.index_summary (distribution); +CREATE INDEX actor_card_barcode_lower_idx ON actor.card (lower(barcode)); + \qecho if the following CREATE INDEX fails, It will be necessary to do some \qecho data cleanup as described in the comments. -- 2.11.0