Bug 10488: Followup replacing DELETEs by more restricted INSERTs
authorMarcel de Rooy <m.de.rooy@rijksmuseum.nl>
Mon, 1 Jul 2013 11:37:39 +0000 (13:37 +0200)
committerTomas Cohen Arazi <tomascohen@gmail.com>
Sat, 6 Jul 2013 23:59:40 +0000 (20:59 -0300)
commit54135a4b22242ba306e496f6f7ba154e4e1289ab
tree180bae8030aebf2df4082262b2e3ad53677c2c26
parent76a126ee3d169912a92a54d5982bb345679c795c
Bug 10488: Followup replacing DELETEs by more restricted INSERTs

Instead of inserting followed by deleting, this patch combines the two where
clauses of both sql statements, meanwhile leaving the separation intact.

As suggested by Galen, removed all 162's from the non-default types.
The 162 calls for a new authority type. We can add that later on.

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Ran this .sql script after deleting all auth records.
The former version had 9 types, 1148 tags and 11621 subfields.
This one has 9 types, 1140 tags and 11597 subfields.
That is expected: 8 tags 162 less and 8x3 subfields less.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
(cherry picked from commit 14babcecf681874e4a75eff0a5ba2d869f1966bf)
Signed-off-by: Tomas Cohen Arazi <tomascohen@gmail.com>
installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql