From bd6ed01c79b6c790bac71b301c7c50b6cccd539d Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Wed, 8 Jan 2014 08:01:11 -0500 Subject: [PATCH] adding fields to be automatically stripped when importing MARC records --- .../src/sql/Pg/version-upgrade/pines-post-2.5-db-upgrade.sql | 9 +++++++++ 1 file changed, 9 insertions(+) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/pines-post-2.5-db-upgrade.sql b/Open-ILS/src/sql/Pg/version-upgrade/pines-post-2.5-db-upgrade.sql index 2887fa3ac9..c69e771aea 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/pines-post-2.5-db-upgrade.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/pines-post-2.5-db-upgrade.sql @@ -6,4 +6,13 @@ BEGIN; INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES (1, 'circ.patron_expires_soon_warning', '30'); +-- add fields to be automatically stripped in record import +INSERT INTO vandelay.import_bib_trash_group (owner, label, always_apply) VALUES (1, 'PINES stripped tags', TRUE); + +INSERT INTO vandelay.import_bib_trash_fields (field, grp) VALUES ('029', (SELECT id FROM vandelay.import_bib_trash_group WHERE label = 'PINES stripped tags')); +INSERT INTO vandelay.import_bib_trash_fields (field, grp) VALUES ('938', (SELECT id FROM vandelay.import_bib_trash_group WHERE label = 'PINES stripped tags')); +INSERT INTO vandelay.import_bib_trash_fields (field, grp) VALUES ('948', (SELECT id FROM vandelay.import_bib_trash_group WHERE label = 'PINES stripped tags')); +INSERT INTO vandelay.import_bib_trash_fields (field, grp) VALUES ('952', (SELECT id FROM vandelay.import_bib_trash_group WHERE label = 'PINES stripped tags')); + + COMMIT; -- 2.11.0