From 2dbae926a756ea7f2182bcc6c5f94f82bc062008 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 14 Nov 2013 17:10:47 -0500 Subject: [PATCH] display fields / upgrade script schema repairs Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.metabib-display-field.sql | 7 +++---- 1 file changed, 3 insertions(+), 4 deletions(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.metabib-display-field.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.metabib-display-field.sql index 0416b47aaa..d8fb79bd9b 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.metabib-display-field.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.metabib-display-field.sql @@ -1,7 +1,9 @@ BEGIN; -ALTER TABLE config.metabib_field ADD COLUMN display_xpath TEXT, display_field BOOL NOT NULL DEFAULT TRUE; +ALTER TABLE config.metabib_field + ADD COLUMN display_xpath TEXT, + ADD COLUMN display_field BOOL NOT NULL DEFAULT TRUE; CREATE TABLE metabib.display_entry ( id BIGSERIAL PRIMARY KEY, @@ -66,9 +68,6 @@ CREATE TRIGGER display_field_force_nfc_tgr BEFORE UPDATE OR INSERT ON metabib.display_entry FOR EACH ROW EXECUTE PROCEDURE evergreen.display_field_force_nfc(); -ALTER TABLE config.metabib_field - ADD COLUMN display_field BOOL NOT NULL DEFAULT TRUE; - ALTER TYPE metabib.field_entry_template ADD ATTRIBUTE display_field BOOL; CREATE OR REPLACE FUNCTION biblio.extract_metabib_field_entry ( rid BIGINT, default_joiner TEXT ) RETURNS SETOF metabib.field_entry_template AS $func$ -- 2.11.0