Schema Changes: 2.3.11

-- Remove [ and ] characters from seriestitle.
-- Those characters don't play well when searching.


INSERT INTO config.metabib_field_index_norm_map (field,norm,params, pos)
     SELECT  m.id,
             i.id,
             $$["]",""]$$,
             '-1'
       FROM  config.metabib_field m,
             config.index_normalizer i
       WHERE i.func IN ('replace')
             AND m.id IN (1);

INSERT INTO config.metabib_field_index_norm_map (field,norm,params, pos)
     SELECT  m.id,
             i.id,
             $$["[",""]$$,
             '-1'
       FROM  config.metabib_field m,
             config.index_normalizer i
       WHERE i.func IN ('replace')
             AND m.id IN (1);

-- Placeholder script for 0821 which was backported for fixing 2.3 and 2.4
-- only, and not master.

-- Nothing to do here.

-- Evergreen DB patch 0825.data.bre_format.sql
--
-- Fix some templates that loop over bibs to not have duplicated/run-on titles
--

-- check whether patch can be applied

-- I think we shy away from modifying templates on existing systems, but this seems pretty safe...
UPDATE
    action_trigger.event_definition
SET
    template = replace(template,'[% FOR cbreb IN target %]','[% FOR cbreb IN target %][% title = '''' %]')
WHERE
    id IN (31,32);