Bug 16565: Drop additional_fields and additional_field_values before creating them
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Mon, 23 May 2016 11:19:46 +0000 (12:19 +0100)
committerBrendan Gallagher <brendan@bywatersolutions.com>
Fri, 3 Jun 2016 08:56:44 +0000 (08:56 +0000)
commita01cd77e19f810bf61c8d26ebb97f7c49f1d1f32
tree366959bf2a9f2970d991c151b7bd7985d6524cf7
parentedec5921b11afcbda44fbb6c45f26174768b1708
Bug 16565: Drop additional_fields and additional_field_values before creating them

These 2 tables should be dropped before trying to create them

Test plan:
From the SQL CLI, source the kohastructure.sql file
source it again
=> Without this patch you get 2 warnings
ERROR 1050 (42S01) at line 3580 in file:
'installer/data/mysql/kohastructure.sql': Table
'additional_fields' already exi
sts
ERROR 1050 (42S01) at line 3596 in file:
'installer/data/mysql/kohastructure.sql': Table
'additional_field_values' alrea
dy exists

=> With this patch, you won't get them

Signed-off-by: Mark Tompsett <mtompset@hotmail.com>
Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Brendan Gallagher <brendan@bywatersolutions.com>
installer/data/mysql/kohastructure.sql