Bug 16573: fix linkid value on marc_subfield_structure
authorBernardo Gonzalez Kriegel <bgkriegel@gmail.com>
Mon, 23 May 2016 19:58:03 +0000 (16:58 -0300)
committerFrédéric Demians <f.demians@tamil.fr>
Fri, 5 Aug 2016 05:11:33 +0000 (07:11 +0200)
commit58bd47a462a008f2e5cb9cfa221ee5b0a0bd5826
tree51caaba6434303bd50dff5f4cfa4e07f297607e6
parent27cd564c20ffede4a7e7fdef332c457389e94240
Bug 16573: fix linkid value on marc_subfield_structure

followup to previous patch.

This patch fixes linkid value. It was set to '', but
declared as tinyint.
Mysql < 5.7 replaced this with nearest right value, i.e 0
Mysql 5.7 gives error here.

Also some normalization, all lines with data begins with two tabs

To test:
On top of Bug 16572 and previous patch

1) Run webinstaller
2) Add mandatory values
3) There must be no problems on MySQL 5.7

Signed-off-by: Mark Tompsett <mtompset@hotmail.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
(cherry picked from commit d00d46112df2dc1c3f823fbc2a8c347deb69cdb7)
Signed-off-by: Frédéric Demians <f.demians@tamil.fr>
installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql