Bug 22634: Standardize table creation for stockrotation* tables in kohastructure.sql
authorKatrin Fischer <katrin.fischer.83@web.de>
Wed, 3 Apr 2019 20:35:38 +0000 (22:35 +0200)
committerMartin Renvoize <martin.renvoize@ptfs-europe.com>
Mon, 15 Apr 2019 17:45:50 +0000 (18:45 +0100)
commitac5c0700fcab5e74befef6a2d5f400573d83411b
tree8731d909bfd8b7d36e1ea177be3c47b0a8ca5845
parent764260ded4f350904c548422defb74d32581f65e
Bug 22634: Standardize table creation for stockrotation* tables in kohastructure.sql

The existing pattern is:
DROP TABLE IF EXISTS ...
CRATE TABLE

Stockrotation was using:
CREATE TABLE IF NOT EXISTS ...
which would not recreate the table in a database it's already
existing in possibly causing mismatches in table structure.

To test:
- Drop your database
- Run through the web installer
- Make sure there are no Database/SQL errors
- Makse sure the 4 stockrotation tables have been created

Signed-off-by: Frédéric Demians <f.demians@tamil.fr>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
(cherry picked from commit fbdb2b2be009140be6f9b5b84c765741bc828a3c)
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
installer/data/mysql/kohastructure.sql